zentaopms/db/update1.5.sql
2023-05-16 10:47:08 +08:00

24 lines
795 B
SQL

ALTER TABLE `zt_storySpec` ADD `verify` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;
CREATE TABLE IF NOT EXISTS `zt_extension` (
`id` mediumint(8) unsigned NOT NULL auto_increment,
`company` mediumint(8) unsigned NOT NULL,
`name` varchar(150) NOT NULL,
`code` varchar(30) NOT NULL,
`version` varchar(50) NOT NULL,
`author` varchar(100) NOT NULL,
`desc` text NOT NULL,
`license` text NOT NULL,
`site` varchar(150) NOT NULL,
`zentaoVersion` varchar(100) NOT NULL,
`installedTime` datetime NOT NULL,
`dirs` text NOT NULL,
`files` text NOT NULL,
`status` varchar(20) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `code` (`code`),
KEY `name` (`name`),
KEY `addedTime` (`installedTime`),
KEY `company` (`company`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;