01-11-2013, 03:20 PM
Hmm, i didn't know this.
It also doesn't work if u create it?
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`)
)
COLLATE='latin1_swedish_ci'
ENGINE=MyISAM;

