KNOWLEDGE BASE

1. Backup their db and download it

2. Create and load into local db

3. run updates below

ALTER TABLE `tbldeliverycharges` ADD COLUMN IF NOT EXISTS `seoDesc` TEXT NULL AFTER `statusId`, ADD COLUMN IF NOT EXISTS `seoTitle` VARCHAR(400) NULL AFTER `seoDesc`; 

CREATE TABLE IF NOT EXISTS `tblredirect` ( `id` INT(11) NOT NULL AUTO_INCREMENT, `type` INT(1) DEFAULT 302, `fromUrl` VARCHAR(300), `toUrl` VARCHAR(300), PRIMARY KEY (`id`) );

ALTER TABLE `tblconnector` ADD COLUMN `f2fMemberCode` VARCHAR(25) NULL AFTER `f2fToken`;

DELETE FROM tblconfiglocation;

ALTER TABLE `tblconnector` ADD COLUMN IF NOT EXISTS `f2fMemberCode` VARCHAR(25) NULL AFTER `f2fToken`;

ALTER TABLE `tbldesignattrvalue` ADD COLUMN `orderVal` INT(3) DEFAULT 0 NULL AFTER `stockLevel4`; 

ALTER TABLE `tbldesign` ADD COLUMN `allowFunLetters` INT(1) DEFAULT 0 NULL AFTER `includesAlcohol`;

ALTER TABLE `tbldesign` ADD COLUMN  IF NOT EXISTS  `availableFrom` DATE NULL AFTER `freeDelivery`, ADD COLUMN  IF NOT EXISTS  `availableTo` DATE NULL AFTER `availableFrom`; 

ALTER TABLE `tblpaymentgateway` ADD COLUMN `myPosWalletNo` VARCHAR(100) NULL AFTER `propaySecret`, ADD COLUMN `myPosSID` VARCHAR(100) NULL AFTER `myPosWalletNo`;

ALTER TABLE `tblconfig` CHANGE `currencySymbol` `currencySymbol` VARCHAR(30) CHARSET utf8mb4 NULL, CHANGE `currencyChar` `currencyChar` VARCHAR(30) CHARSET utf8mb4 NULL;

ALTER TABLE `tblconnector` ADD COLUMN IF NOT EXISTS `strelShopId` INT(10) NULL AFTER `ffMessageType`, ADD COLUMN IF NOT EXISTS `strelConnectorType` VARCHAR(20) NULL AFTER `strelShopId`;

ALTER TABLE `tblconnector` ADD COLUMN IF NOT EXISTS `connectorStatus` VARCHAR(10) NULL AFTER `strelConnectorType`;

ALTER TABLE `tblconnector` ADD COLUMN IF NOT EXISTS `connectorName` VARCHAR(100) NULL AFTER `connectorStatus`;

ALTER TABLE `tblconnector` ADD COLUMN IF NOT EXISTS `strelToken` VARCHAR(100) NULL AFTER `connectorName`, ADD COLUMN IF NOT EXISTS  `strelType` VARCHAR(1) NULL AFTER `strelToken`;

ALTER TABLE `tblconnector` ADD COLUMN IF NOT EXISTS  `strelUrl` VARCHAR(200) NULL AFTER `strelType`;

ALTER TABLE `tblconfig` ADD COLUMN IF NOT EXISTS `logo` VARCHAR(100) NULL AFTER `bottomContent`;

ALTER TABLE `tblconfig` ADD COLUMN IF NOT EXISTS `delChargeVersion` VARCHAR(1) NULL AFTER `logo`;

ALTER TABLE `tblconfig` ADD COLUMN IF NOT EXISTS `customTopNav` INT(1) DEFAULT 0 NULL AFTER `delChargeVersion`, ADD COLUMN IF NOT EXISTS `customHeader` INT(1) DEFAULT 0 NULL AFTER `customTopNav`, ADD COLUMN IF NOT EXISTS `customFooter` INT(1) DEFAULT 0 NULL AFTER `customHeader`; 

ALTER TABLE `tblpage` ADD COLUMN IF NOT EXISTS `redirect` VARCHAR(300) NULL AFTER `lastUpdated`; 

ALTER TABLE `tbldeliverycharges` ADD COLUMN IF NOT EXISTS `shopTel2` VARCHAR(50) NULL AFTER `shopTel`;

CREATE TABLE `tbltransfercompany` ( `id` INT(11) NOT NULL AUTO_INCREMENT, `companyName` VARCHAR(300), `addressId` INT(15), `email` VARCHAR(100), PRIMARY KEY (`id`) ) CHARSET=utf8mb4;

CREATE TABLE `tbltransferrequest` ( `id` INT(15) NOT NULL AUTO_INCREMENT, `transferStatus` VARCHAR(20), `transferRoute` VARCHAR(2), `senderDataId` INT(15), `receiverDataId` INT(15), `senderOrderId` INT(20), `receiverOrderId` INT(20), `senderUrl` TEXT, `receiverUrl` TEXT, PRIMARY KEY (`id`) ) CHARSET=utf8mb4; 

ALTER TABLE `tbltransferrequest` DROP COLUMN `receiverDataId`, DROP COLUMN `receiverUrl`, CHANGE `senderDataId` `theirInfoId` INT(15) NULL, CHANGE `senderOrderId` `theirOrderId` INT(20) NULL, CHANGE `receiverOrderId` `yourOrderId` INT(20) NULL, CHANGE `senderUrl` `responseUrl` TEXT CHARSET utf8mb4 COLLATE utf8mb4_general_ci NULL;

ALTER TABLE `tbltransferrequest` ADD COLUMN IF NOT EXISTS `theirRequestId` INT(15) NULL AFTER `responseUrl`;

ALTER TABLE `tbldiscount` ADD COLUMN IF NOT EXISTS`claimedVal` DECIMAL(13,2) DEFAULT 0.00 NULL ;

ALTER TABLE `tblorderitem` MODIFY COLUMN `subOrderId` INT(11) NULL DEFAULT '0';

4. export to backup folder of script with dbname_backup.sql

5.  delete and recreate db in layer

6. run new db script from server

7. run migration script

8. Export adpanels from old db and load to new

9. run following sql

delete from tbldesignoccassion where designId not in (select id from tbldesign);

delete from tbldesign_designtype where designId not in (select id from tbldesign);

UPDATE tbldesign SET description = REPLACE(description, "'", "");

UPDATE `tbldesign` SET `availableTo` = '2029-06-02' WHERE `availableTo` = '0000-00-00';

UPDATE `tbldesign` SET `availableTo` = '2029-06-02' WHERE `availableTo` IS NULL and availableFrom IS NOT NULL;

UPDATE `tbldesign` SET `availableFrom` = '2000-06-02' WHERE `availableFrom` IS NULL and availableTo IS NOT NULL;

update tblpage set redirect="";