05-30-2013, 06:56 PM
ok one second
DROP TABLE IF EXISTS `t_system_notice`;
CREATE TABLE `t_system_notice` (
`a_index` int(11) unsigned NOT NULL AUTO_INCREMENT,
`a_enable` int(11) NOT NULL DEFAULT 0,
`a_title` varchar(40) NOT NULL DEFAULT ,
`a_message` varchar(120) NOT NULL DEFAULT ,
`a_startTime` datetime NOT NULL DEFAULT 0000-00-00 00:00:00,
`a_endTime` datetime NOT NULL DEFAULT 0000-00-00 00:00:00,
`a_cycle` int(11) NOT NULL DEFAULT 0,
`a_color` varchar(10) NOT NULL DEFAULT ,
`a_enable_link` int(11) NOT NULL DEFAULT 0,
`a_link` varchar(200) NOT NULL DEFAULT ,
PRIMARY KEY (`a_index`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

