DROP TABLE IF EXISTS `#@_project_table`;
CREATE TABLE `#@_project_table` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(80) NOT NULL DEFAULT '',
  `client_id` smallint(6) NOT NULL DEFAULT '0',
  `status` tinyint(1) NOT NULL DEFAULT '10',
  `itemtype` tinyint(1) NOT NULL DEFAULT '1',
  `view_state` tinyint(1) NOT NULL DEFAULT '10',
  PRIMARY KEY (`id`),
  UNIQUE KEY `idx_project_name` (`name`),
  KEY `idx_project_sele` (`view_state`,`status`,`itemtype`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='项目列表';

