数据库加表
数据库:ucs
表名:app_manage_notice
sql:
CREATE TABLE `app_manage_notice` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`pid` int(11) NOT NULL,
`title` varchar(255) NOT NULL,
`content` varchar(255) NOT NULL,
`status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '0默认,1已通知',
`add_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`lastupdatetime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8