text: -- 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` ;
  