v42.sql 532 B

12345678
  1. ALTER TABLE `orders` ADD `seller_id` INT(11) NULL DEFAULT NULL AFTER `guest_id`;
  2. ALTER TABLE `orders` ADD `delivery_status` VARCHAR(20) NULL DEFAULT 'pending' AFTER `shipping_address`;
  3. ALTER TABLE `categories` ADD `order_level` INT(11) NOT NULL DEFAULT '0' AFTER `name`;
  4. ALTER TABLE `products` ADD `is_quantity_multiplied` TINYINT(1) NOT NULL DEFAULT '0' COMMENT '1 = Mutiplied with shipping cost' AFTER `shipping_cost`;
  5. UPDATE `business_settings` SET `value` = '4.2' WHERE `business_settings`.`type` = 'current_version';
  6. COMMIT;