56 lines
2.1 KiB
SQL
56 lines
2.1 KiB
SQL
-- doc
|
|
CREATE TABLE IF NOT EXISTS `zt_doc` (
|
|
`id` mediumint(8) unsigned NOT NULL auto_increment,
|
|
`company` smallint(5) unsigned NOT NULL,
|
|
`product` mediumint(8) unsigned NOT NULL,
|
|
`project` mediumint(8) unsigned NOT NULL,
|
|
`lib` varchar(30) NOT NULL,
|
|
`module` varchar(30) NOT NULL,
|
|
`title` varchar(120) NOT NULL,
|
|
`digest` varchar(255) NOT NULL,
|
|
`type` varchar(30) NOT NULL,
|
|
`content` text NOT NULL,
|
|
`url` varchar(255) NOT NULL,
|
|
`views` smallint(5) unsigned NOT NULL,
|
|
`addedBy` varchar(30) NOT NULL,
|
|
`addedDate` datetime NOT NULL,
|
|
`editedBy` varchar(30) NOT NULL,
|
|
`editedDate` datetime NOT NULL,
|
|
`deleted` enum('0','1') NOT NULL default '0',
|
|
PRIMARY KEY (`id`)
|
|
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
|
|
|
|
-- doc lib
|
|
CREATE TABLE IF NOT EXISTS `zt_docLib` (
|
|
`id` smallint(5) unsigned NOT NULL auto_increment,
|
|
`company` smallint(5) unsigned NOT NULL,
|
|
`name` varchar(60) NOT NULL,
|
|
`deleted` enum('0','1') NOT NULL DEFAULT '0',
|
|
PRIMARY KEY (`id`),
|
|
KEY `company` (`company`)
|
|
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
|
|
-- module
|
|
ALTER TABLE `zt_module` CHANGE `product` `root` MEDIUMINT( 8 ) UNSIGNED NOT NULL DEFAULT '0';
|
|
ALTER TABLE `zt_module` CHANGE `view` `type` CHAR( 30 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;
|
|
ALTER TABLE `zt_module` ADD `owner` VARCHAR( 30 ) NOT NULL ;
|
|
update zt_module set `type` = 'story' where `type` = 'product';
|
|
-- tpl
|
|
CREATE TABLE IF NOT EXISTS `zt_userTPL` (
|
|
`id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
|
|
`company` mediumint(8) unsigned NOT NULL,
|
|
`account` char(30) NOT NULL,
|
|
`type` char(30) NOT NULL,
|
|
`title` varchar(150) NOT NULL,
|
|
`content` text NOT NULL,
|
|
PRIMARY KEY (`id`),
|
|
KEY `company` (`company`),
|
|
KEY `account` (`account`)
|
|
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
|
|
-- product acl
|
|
ALTER TABLE `zt_product` ADD `acl` ENUM( 'open', 'private', 'custom' ) NOT NULL DEFAULT 'open' AFTER `desc` ,
|
|
ADD `whitelist` VARCHAR( 255 ) NOT NULL AFTER `acl` ;
|
|
|
|
-- product owner.
|
|
ALTER TABLE `zt_product` ADD `productOwner` VARCHAR( 30 ) NOT NULL AFTER `desc` ,
|
|
ADD `bugOwner` VARCHAR( 30 ) NOT NULL AFTER `productOwner` ;
|