zentaopms/db/update9.8.1.sql
2023-05-16 10:47:08 +08:00

5 lines
313 B
SQL

ALTER TABLE `zt_user` CHANGE `realname` `realname` varchar(100) COLLATE 'utf8_general_ci' NOT NULL DEFAULT '' AFTER `password`;
ALTER TABLE `zt_project` CHANGE `openedDate` `openedDate` datetime NOT NULL,
CHANGE `closedDate` `closedDate` datetime NOT NULL,
CHANGE `canceledDate` `canceledDate` datetime NOT NULL;