znt/db/update9.8.1.sql

5 lines
287 B
MySQL
Raw Permalink Normal View History

ALTER TABLE `zt_user` CHANGE `realname` `realname` varchar(100) 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;