1#@!#!123s

ALWAYS HENGHENG888 1#@!#!123s
: / var / www / api.kitchentoolsbd.com / _sql /
Filename : progress.txt
back
ALTER TABLE `kitchentoolsbd_dev`.`customer_cart`
ADD COLUMN `shipping_method` VARCHAR(255) NULL AFTER `coupon_discount`;


ALTER TABLE `orders`
ADD COLUMN `shipping_method` VARCHAR(255) NULL AFTER `payment_method`;



ALTER TABLE `kitchentoolsbd_dev`.`users`
ADD COLUMN `city` VARCHAR(191) NULL AFTER `email`,
ADD COLUMN `state` VARCHAR(191) NULL AFTER `city`,
ADD COLUMN `zip_code` VARCHAR(25) NULL AFTER `state`,
ADD COLUMN `address1` TEXT NULL AFTER `zip_code`,
ADD COLUMN `address2` TEXT NULL AFTER `address1`,
ADD COLUMN `country` VARCHAR(191) NULL AFTER `address2`;


ALTER TABLE `kitchentoolsbd_dev`.`customer_shipping_address`
ADD COLUMN `address2` TEXT NULL AFTER `address`;


ALTER TABLE `prorefurblab_dev`.`orders`
ADD COLUMN `tracking_number` VARCHAR(191) NULL AFTER `transaction_id`,
ADD COLUMN `tracking_check_link` VARCHAR(255) NULL AFTER `tracking_number


ALTER TABLE `prorefurblab_dev`.`customer_cart`
ADD COLUMN `use_credit` MEDIUMINT NULL AFTER `coupon_discount`;

ALTER TABLE `prorefurblab_dev`.`orders`
ADD COLUMN `use_credit` MEDIUMINT NULL AFTER `total_amount`;

ALTER TABLE `prorefurblab_dev`.`menus`
ADD COLUMN `reference_id` MEDIUMINT(9) NULL AFTER `order`;


ALTER TABLE `prorefurblab_dev`.`taxonomies`
ADD COLUMN `group_id` INT NULL AFTER `parent_id`,
ADD COLUMN `order` INT NULL AFTER `group_id`,
ADD COLUMN `options` TEXT NULL AFTER `order`,
ADD COLUMN `menu_type` VARCHAR(45) NULL AFTER `options`,
ADD COLUMN `url` VARCHAR(45) NULL AFTER `menu_type`,
CHANGE COLUMN `type` `type` VARCHAR(191) NULL DEFAULT NULL AFTER `meta_description`;


ALTER TABLE `prorefurblab_dev`.`brands`
ADD COLUMN `brand_url` VARCHAR(255) NULL AFTER `slug`;


UPDATE `taxonomies` SET `using_for`='product' WHERE using_for IS NULL;

ALTER TABLE `prorefurblab_dev`.`training`
ADD COLUMN `enroll_url` VARCHAR(255) NULL AFTER `description`;