v1.3.0.sql 1.5 KB

1234567891011121314151617181920212223242526272829303132
  1. SET NAMES utf8;
  2. SET FOREIGN_KEY_CHECKS=0;
  3. CREATE TABLE IF NOT EXISTS `lacew_mi_prod`.`t_customer_given` (
  4. `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'ID',
  5. `givenKey` varchar(50) NOT NULL,
  6. `companyId` int(11) DEFAULT NULL,
  7. PRIMARY KEY (`id`)
  8. ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
  9. CREATE TABLE IF NOT EXISTS `lacew_mi_prod`.`t_customer_visible` (
  10. `id` int(20) NOT NULL AUTO_INCREMENT,
  11. `userId` int(11) NOT NULL,
  12. `objectKey` varchar(50) NOT NULL,
  13. `companyId` int(11) DEFAULT NULL,
  14. PRIMARY KEY (`id`),
  15. KEY `userId` (`userId`,`objectKey`) USING BTREE,
  16. CONSTRAINT `t_customer_visible_ibfk_2` FOREIGN KEY (`userId`) REFERENCES `t_user` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE
  17. ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
  18. ALTER TABLE `lacew_mi_prod`.`t_customer_visible` MODIFY COLUMN IF EXISTS `id` bigint(20) NOT NULL AUTO_INCREMENT FIRST;
  19. ALTER TABLE `lacew_mi_prod`.`t_rule_new` ADD COLUMN IF NOT EXISTS `product_modular_public_see` tinyint(1) NULL DEFAULT 0 AFTER `documentary_modular_adjustment`;
  20. ALTER TABLE `lacew_mi_prod`.`t_rule_new` ADD COLUMN IF NOT EXISTS `product_modular_private_see` tinyint(1) NULL DEFAULT 0 AFTER `product_modular_public_see`;
  21. ALTER TABLE `lacew_mi_prod`.`t_rule_new` DROP COLUMN IF EXISTS `customer_modular_info`;
  22. UPDATE `lacew_mi_prod`.`t_rule_new` SET `product_modular_public_see` = `product_modular_public`,`product_modular_private_see` = `product_modular_private`;
  23. SET FOREIGN_KEY_CHECKS=1;