forked from easysoft/zentaopms
-
Notifications
You must be signed in to change notification settings - Fork 0
/
update11.6.sql
13 lines (12 loc) · 874 Bytes
/
update11.6.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
ALTER TABLE `zt_translation`
CHANGE `refer` `referer` text COLLATE 'utf8_general_ci' NOT NULL AFTER `value`,
CHANGE `translationTime` `translatedTime` datetime NOT NULL AFTER `translator`,
CHANGE `reviewTime` `reviewedTime` datetime NOT NULL AFTER `reviewer`;
ALTER TABLE `zt_product` ADD `subStatus` varchar(30) NOT NULL AFTER `status`;
ALTER TABLE `zt_release` ADD `subStatus` varchar(30) NOT NULL AFTER `status`;
ALTER TABLE `zt_story` ADD `subStatus` varchar(30) NOT NULL AFTER `status`;
ALTER TABLE `zt_project` ADD `subStatus` varchar(30) NOT NULL AFTER `status`;
ALTER TABLE `zt_task` ADD `subStatus` varchar(30) NOT NULL AFTER `status`;
ALTER TABLE `zt_bug` ADD `subStatus` varchar(30) NOT NULL AFTER `status`;
ALTER TABLE `zt_case` ADD `subStatus` varchar(30) NOT NULL AFTER `status`;
ALTER TABLE `zt_testtask` ADD `subStatus` varchar(30) NOT NULL AFTER `status`;