zentaopms/db/update3.0.beta1.sql
2023-05-16 10:47:08 +08:00

5 lines
343 B
SQL

UPDATE `zt_story` SET `source` = 'customer' WHERE `source` = 'custom';
ALTER TABLE `zt_action` CHANGE `product` `product` VARCHAR( 255 ) NOT NULL ;
ALTER TABLE `zt_history` CHANGE `diff` `diff` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ;
ALTER TABLE `zt_project` ADD `order` SMALLINT UNSIGNED NOT NULL AFTER `whitelist` ;