v24.sql 394 B

123456789
  1. ALTER TABLE `products` CHANGE `brand_id` `brand_id` INT(11) NULL DEFAULT NULL;
  2. ALTER TABLE `products` CHANGE `subsubcategory_id` `subsubcategory_id` INT(11) NULL DEFAULT NULL;
  3. ALTER TABLE `orders` ADD `commission_calculated` INT NOT NULL DEFAULT '0' AFTER `payment_status_viewed`;
  4. UPDATE `business_settings` SET `value` = '2.4' WHERE `business_settings`.`type` = 'current_version';
  5. COMMIT;