Version 7 to Version 8 In Place Upgrade: Post-Upgrade Database Changes
The following SQL statements are required for this upgrade:
- DROP TABLE core_custommenu
- DROP TABLE core_stats
- ALTER TABLE ecom_prod DROP COLUMN voltext
- ALTER TABLE ecom_prod DROP COLUMN skinoverride
- ALTER TABLE ecom_cat DROP COLUMN skinoverride
- ALTER TABLE cms_dynforms DROP COLUMN skinoverride
- ALTER TABLE cms_html DROP COLUMN skinoverride
- ALTER TABLE core_apps DROP COLUMN defaultskin
- ALTER TABLE core_namespaces DROP COLUMN defaultskin
- ALTER TABLE cms_dynforms DROP COLUMN xhtmlskin
- ALTER TABLE core_mail DROP COLUMN xhtmlskin
- ALTER TABLE ecom_orders DROP COLUMN fax
- ALTER TABLE core_users DROP COLUMN fax
- ALTER TABLE ecom_prod DROP COLUMN featuredisp
- ALTER TABLE ecom_prod DROP COLUMN reldisptype
- ALTER TABLE ecom_prod DROP COLUMN reldispnum
- DELETE FROM core_tabledefs WHERE tid='core_custommenu' OR tid='core_stats'
- DELETE FROM core_columndefs WHERE cid LIKE 'core_stats.%' OR cid LIKE 'core_custommenu.%' OR cid='ecom_prod.voltext' OR cid LIKE '%.skinoverride' OR cid LIKE '%.defaultskin' OR cid LIKE '%.xhtmlskin' OR cid='ecom_orders.fax' OR cid='core_users.fax' OR cid='ecom_prod.featuredisp' OR cid='ecom_prod.reldisptype' OR cid='ecom_prod.reldispnum'
- DELETE FROM core_incphp WHERE id='ecom.coimgone' OR id='ecom.coimgtwo' OR id='core.dashstats'OR id='ecom.ordersummaryco' OR id='ecom.olpheader' OR id='ecom.storemenuh' OR id='ecom.cartheader'OR id LIKE 'ecom.xmodquickbuy%' OR id='ecom.xmodreviews' OR id='core.formfield_textarearel' OR id='ecom.xmodbombatchinvfootl' OR id='ecom.breadcrumbs' OR id='core.skinwidgetmenucustom' OR id='core.skinwidgetpopular' OR id='core.skinwidgetrecent' OR id='core.dbrelate' OR id='core.formfield_textarearel' OR id='ecom.xmodshipestimator' OR id LIKE 'ecom.xmodshipestimator%' OR id='core.printmsg' OR id='core.xmodsitemap'
- DELETE FROM core_namespaces WHERE id='ecom.ordersummaryco' OR id='ecom.checkoutp' OR id='core.dashstatsint' OR id='core.xmodhdseo' OR id='ecom.xmodquickbuy' OR id LIKE 'ecom.xmodquickbuy%' OR id='core.skinwidget_menucustom' OR id='core.managecustommenu' OR id='core.skinwidget_popular' OR id='core.skinwidget_recent' OR id='core.reportsadmin' OR id='ecom.xmodreviews' OR id='ecom.managexmodreviews' OR id LIKE 'ecom.xmodreviews%' OR id='ecom.xmodshipestimator' OR id='ecom.xmodshipestimatorf' OR id='core.xmodsitemap' OR id LIKE 'ecom.xmodfup%' OR id='ecom.prodshowint'
- DELETE FROM core_settings WHERE id='core.xmodhdseo_status' OR id='ecom.disablebreadcrumbs' OR id='ecom.disablestoremenu' OR id='ecom.shipestimator_statusp' OR id='ecom.lang.GATEWAYDESC' OR id='ecom.showcoimg' OR id='ecom.lang.OPTPRICEREC' OR id='ecom.lang.OPTPRICEREG' OR id='ecom.disablewishlist' OR id='ecom.xmodquickbuy_status' OR id='ecom.prodfeaturenum' OR id='ecom.featprodtype' OR id='ecom.featprodnum' OR id='ecom.lang.OPTPRICEINC' OR id='ecom.lang.OPTPRICEDEC' OR id LIKE 'ecom.xmodreviews%' OR id LIKE 'ecom.xmodshipestimator%' OR id LIKE 'core.xmodsitemap%' OR id='core.postcodeanywhere_url' OR id='core.time_store_stats' OR id='ecom.lang.ADDTOCART'
- DELETE FROM core_formfields WHERE id='core.mailsend.xhtmlskin' OR id='core.subscriptsend.xhtmlskin' OR id='ecom.guestco.fax' OR id='core.accountmaint.fax' OR id='core.createaccount.fax' OR id='core.siteownerfax'
- DELETE FROM core_messages WHERE id='ecom.cosesschange' OR id='ecom.coordsetupconf' OR id LIKE 'ecom.xmodquickbuy%' OR id LIKE 'ecom.xmodreviews%' OR id LIKE 'core.xmodsendfu%'
- DELETE FROM core_modules WHERE id='core.XMOD_HDSEO' OR id='ecom.XMOD_QuickBuy' OR id='ecom.XMOD_Reviews' OR id='ecom.XMOD_ShipEstimator' OR id='core.XMOD_SiteMap' OR id='ecom.XMOD_FollowUp' OR id='skin.Mail' OR id='skin.COREMI711'
- DELETE FROM core_dbguided WHERE id='core.xmodhdseo.DBOVERCUSTTEXT' OR id LIKE 'ecom.xmodfollowup%'
- DELETE FROM core_forms WHERE id='ecom.xmodreviews' OR id='ecom.xmodshipestimator' OR id='core.xmodfupsend' OR id='ecom.xmodquickbuy'
- DELETE FROM core_selectcustom WHERE id LIKE 'ecom.prodfeature.%' OR id LIKE 'ecom.xmodshipestimator%' OR id LIKE 'core.xmodsitemap%' OR id LIKE 'ecom.xmodreviews%'
- DELETE FROM core_formfields WHERE id LIKE 'ecom.xmodshipestimator%' OR id LIKE 'core.xmodfup%' OR id LIKE 'ecom.xmodreviews%' OR form='ecom.xmodquickbuy' OR id='core.appprofile.defaultskin'
- DELETE FROM core_mail WHERE id='ecom.xmodreviews'
- UPDATE ecom_prod SET reviewsavg='0', reviewsnum='0'
- UPDATE core_forms SET description='Please enter your email address or username and password below to login.' WHERE id='core.login'
- UPDATE core_namespaces SET name='Processing' WHERE id='ecom.manageorders'
- UPDATE core_namespaces SET name='Account Overview' WHERE id='core.accountconf'
- UPDATE core_namespaces SET name='Postal Code Lookup' WHERE id='core.postcodeanywhere_changeinfo' OR id='core.postcodeanywhere_lookupproc'
- UPDATE core_namespaces SET hreftype='SSL' WHERE id='core.license' OR id='core.about' OR id='core.begenericconf' OR id='core.beaccountconf'
- UPDATE core_namespaces SET hreftype='' WHERE id='ecom.olpsetup'
- UPDATE core_namespaces SET name='Daily Activity Report' WHERE id='core.reportsday'
- UPDATE core_namespaces SET name='Monthly Activity Report' WHERE id='core.reportsmonth'
- UPDATE core_namespaces SET name='Yearly Activity Report' WHERE id='core.reportsyear'
- UPDATE core_namespaces SET name='Page Access Totals Report' WHERE id='core.reportspages'
- UPDATE core_namespaces SET name='Submit a Review' WHERE id='ecom.reviewsf'
- UPDATE core_namespaces SET name='Submit a Review - Process' WHERE id='ecom.reviewsp'
- UPDATE core_settings SET value='desc' WHERE id='ecom.splashcattype' OR id='ecom.splashprodtype' OR id='ecom.allprodtype' OR id='ecom.newprodtype' OR id='ecom.bestprodtype' OR id='ecom.searchprodtype' OR id='ecom.prodidxprodtype' OR id='ecom.specprodtype'
- UPDATE ecom_gateway SET dispname='Purchase by transmitting a purchase order' WHERE id='purchord'
- UPDATE core_formfields SET description='' WHERE id='core.contact.fname' OR id='core.contact.lname' OR id='core.contact.phone' OR id='core.contact.email_address' OR id='core.contact.message' OR id='core.login.user' OR id='core.login.password' OR id='core.sendpass.user' OR id='core.changepass.passnew1' OR id='core.changepass.passnew2' OR id='core.changeemail.emailnew1' OR id='core.changeemail.emailnew2' OR id='core.changeusername.usernamenew1' OR id='core.changeusername.usernamenew2' OR id='core.accountmaint.fname' OR id='core.accountmaint.lname' OR id='core.accountmaint.company' OR id='core.accountmaint.phone' OR id='core.accountmaint.addone' OR id='core.accountmaint.addtwo' OR id='core.accountmaint.city' OR id='core.accountmaint.country' OR id='core.accountmaint.postalcode' OR id='core.accountmaint.rescom' OR id='core.createaccount.emailnew1' OR id='core.createaccount.emailnew2' OR id='core.createaccount.usernamenew1' OR id='core.createaccount.usernamenew2' OR id='core.createaccount.passnew1' OR id='core.createaccount.passnew2' OR id='core.createaccount.fname' OR id='core.createaccount.lname' OR id='core.createaccount.company' OR id='core.createaccount.phone' OR id='core.createaccount.addone' OR id='core.createaccount.addtwo' OR id='core.createaccount.city' OR id='core.createaccount.country' OR id='core.createaccount.postalcode' OR id='core.createaccount.rescom' OR id='core.acctupgrade.fname' OR id='core.acctupgrade.lname' OR id='core.acctupgrade.phone' OR id='core.acctupgrade.email_address' OR id='core.acctupgrade.message' OR id='core.addbookins.fname' OR id='core.addbookins.lname' OR id='core.addbookins.company' OR id='core.addbookins.addone' OR id='core.addbookins.addtwo' OR id='core.addbookins.city' OR id='core.addbookins.country' OR id='core.addbookins.postalcode' OR id='core.addbookins.rescom' OR id='core.addbookupd.fname' OR id='core.addbookupd.lname' OR id='core.addbookupd.company' OR id='core.addbookupd.addone' OR id='core.addbookupd.addtwo' OR id='core.addbookupd.city' OR id='core.addbookupd.country' OR id='core.addbookupd.postalcode' OR id='core.addbookupd.rescom' OR id='core.gsubscript.email' OR id='core.gsubscriptcadd.change' OR id='core.gsubscriptcdel.change' OR id='core.postcodeanywhere_lookupshow.postcode' OR id='core.postcodeanywhere_changeinfo.seladdress' OR id='ecom.guestco.emailnew1' OR id='ecom.guestco.emailnew2' OR id='ecom.guestco.fname' OR id='ecom.guestco.lname' OR id='ecom.guestco.company' OR id='ecom.guestco.addone' OR id='ecom.guestco.addtwo' OR id='ecom.guestco.city' OR id='ecom.guestco.country' OR id='ecom.guestco.postalcode' OR id='ecom.guestco.rescom' OR id='ecom.prodsearch.string' OR id='ecom.prodsearch.type' OR id='ecom.prodsearch.resultspp' OR id='ecom.prodsearch.pricemin' OR id='ecom.prodsearch.pricemax' OR id='ecom.prodaddtocart.quantity' OR id='ecom.emailfriend.email' OR id='ecom.emailfriend.femail' OR id='ecom.emailfriend.msg' OR id='ecom.notifystock.email' OR id='ecom.reviews.nickname' OR id='ecom.reviews.email' OR id='ecom.reviews.subject' OR id='ecom.reviews.rating' OR id='ecom.reviews.ratingquality' OR id='ecom.reviews.ratingvalue' OR id='ecom.reviews.review' OR id='ecom.reviews.reviewpros' OR id='ecom.reviews.reviewcons' OR id='ecom.shipestimator.country' OR id='ecom.shipestimator.postalcode' OR id='ecom.shipestimator.rescom' OR id='ecom.guestco.phone' OR id LIKE 'core.belogin.%'
- UPDATE ecom_gateway SET refurlstr='sagepay' WHERE id='protxform'
- UPDATE core_formfields SET description='Browse your local hard drive and select the download file you wish to upload.' WHERE id='core.dlupload.upfile' OR id='core.mediaupload.upfile' OR id='core.skinupdupload.upfile'
- UPDATE ecom_orders SET loyaltypointstotal='0.00'
- UPDATE core_namespaces SET groupallow='superuser, admin' WHERE id='core.dbrelatejs' OR id='core.dbrelate'
- UPDATE core_settings SET value='image/jpeg, image/pjpeg, image/x-png, image/png, image/gif' WHERE id='core.upload_filetypes'
- UPDATE core_namespaces SET groupallow='superuser, admin' WHERE id='core.servernews' OR id='servernewsint'
- UPDATE core_namespaces SET groupallow='superuser' WHERE id='ecom.paypalsfcc' OR id='ecom.paypalsfconfig' OR id='ecom.paypalsfconfirm' OR id='ecom.paypalsfintro' OR id='ecom.paypalsfpp' OR id='ecom.paypalsfproc' OR id='core.manageskins'
- UPDATE core_formfields SET section='Billing Address' WHERE section='Address' AND (form='core.accountmaint' OR form='core.createaccount')
- UPDATE core_stateprov SET taxrate='6.000' WHERE id='Maryland'
- UPDATE core_country SET iseu='0' WHERE id='UK - Channel Islands'
- UPDATE core_namespaces SET hreftype='Non-SSL' WHERE id='ecom.procgwresp'
- UPDATE core_namespaces SET hreftype='' WHERE id='ecom.xmodgooglebase'
- DELETE FROM core_messages WHERE id='cms.invalidpage' OR id='ecom.invaliditem'
- DELETE FROM core_incphp WHERE id='cms.pagenotfound'
- UPDATE ecom_gateway SET fieldtotal='xxxVar3', refurlstr='http' WHERE id='internetsecure'
- UPDATE ecom_gateway SET fieldtotal='AMOUNT' WHERE id='epdqform'
If you had the Reviews Extension Module (XMOD) Installed, execute these statements:
- DROP TABLE ecom_xmodreviews
- DELETE FROM core_columndefs WHERE cid LIKE 'ecom_xmodreviews%'
- DELETE FROM core_tabledefs WHERE tid='ecom_xmodreviews'
If you had the FollowUp Extension Module (XMOD) Installed, execute these statements:
- DROP TABLE ecom_xmodfollowup
- DELETE FROM core_columndefs WHERE cid LIKE 'ecom_xmodfollowup.%' OR cid='ecom_orderitems.xmodfup_sent'
- DELETE FROM core_tabledefs WHERE tid='ecom_xmodfollowup'
- ALTER TABLE ecom_orderitems DROP COLUMN xmodfup_sent
If you had the HDSEO Extension Module (XMOD) Installed, execute these statements:
- DROP TABLE core_xmodhdseo
- DELETE FROM core_columndefs WHERE cid LIKE 'core_xmodhdseo.%'
- DELETE FROM core_tabledefs WHERE tid='core_xmodhdseo'