56,677
社区成员
发帖
与我相关
我的任务
分享
CREATE TABLE IF NOT EXISTS `oa_worklog` (
`log_id` int(11) unsigned NOT NULL,
`author_id` int(11) unsigned NOT NULL,
`author_name` varchar(50) NOT NULL,
`date` int(10) NOT NULL,
`log_title` varchar(100) NOT NULL,
`log_content` text NOT NULL,
`log_status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '1为开放0为关闭',
`log_ip` varchar(20) NOT NULL,
`log_type` tinyint(1) NOT NULL,
`comment_status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '1为开放0为关闭',
`comment_count` int(5) NOT NULL DEFAULT '0',
`attachment` tinyint(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`log_id`),
KEY `author_id` (`author_id`,`author_name`),
KEY `author_name` (`author_name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;