Files
EasySoft-ZenTaoPMS/db/update4.2.sql
2013-07-23 16:48:36 +08:00

5 lines
398 B
SQL

ALTER TABLE `zt_extension` ADD `depends` VARCHAR( 100 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL AFTER `installedTime` ;
ALTER TABLE `zt_extension` CHANGE `zentaoVersion` `zentaoCompatible` VARCHAR( 100 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;
ALTER TABLE `zt_company` DROP `pms`;
ALTER TABLE `zt_bug` ADD `plan` mediumint(8) unsigned NOT NULL DEFAULT '0' AFTER `project`;