|
|
[SQL] Query game_event start
[ERR] 1067 - Invalid default value for 'start_time'
[ERR] CREATE TABLE `game_event` (
`eventEntry` tinyint(3) unsigned NOT NULL COMMENT 'Entry of the game event',
`start_time` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT 'Absolute start date, the event will never start before',
`end_time` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT 'Absolute end date, the event will never start afler',
`occurence` bigint(20) unsigned NOT NULL DEFAULT '5184000' COMMENT 'Delay in minutes between occurences of the event',
`length` bigint(20) unsigned NOT NULL DEFAULT '2592000' COMMENT 'Length in minutes of the event',
`holiday` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT 'Client side holiday id',
`holidayStage` tinyint(3) unsigned NOT NULL DEFAULT '0',
`description` varchar(255) DEFAULT NULL COMMENT 'Description of the event displayed in console',
`world_event` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '0 if normal event, 1 if world event',
PRIMARY KEY (`eventEntry`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
[SQL] Process terminated
|
|
发表于 
