[Err] 1067 - Invalid default value for 'level_up_date'
[Err] CREATE TABLE player_pets
(
player_id
int(11) NOT NULL,
pet_id
int(11) NOT NULL,
decoration
int(11) NOT NULL,
name
varchar(255) NOT NULL,
hungry_level
tinyint(4) NOT NULL DEFAULT '0',
feed_progress
int(11) NOT NULL DEFAULT '0',
reuse_time
bigint(20) NOT NULL DEFAULT '0',
birthday
timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
mood_started
bigint(20) NOT NULL DEFAULT '0',
counter
int(11) NOT NULL DEFAULT '0',
mood_cd_started
bigint(20) NOT NULL DEFAULT '0',
gift_cd_started
bigint(20) NOT NULL DEFAULT '0',
dopings
varchar(80) CHARACTER SET ascii DEFAULT NULL,
despawn_time
timestamp NULL DEFAULT NULL,
expire_time
int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (player_id
,pet_id
),
CONSTRAINT FK_player_pets
FOREIGN KEY (player_id
) REFERENCES players
(id
) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- Records of player_pets
-- Table structure for player_punishments
DROP TABLE IF EXISTS player_punishments
;
CREATE TABLE player_punishments
(
player_id
int(11) NOT NULL,
punishment_type
enum('PRISON','GATHER','CHARBAN') NOT NULL,
start_time
int(10) unsigned DEFAULT '0',
duration
int(10) unsigned DEFAULT '0',
reason
text,
PRIMARY KEY (player_id
,punishment_type
),
CONSTRAINT player_punishments_ibfk_1
FOREIGN KEY (player_id
) REFERENCES players
(id
) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- Records of player_punishments
-- Table structure for player_quests
DROP TABLE IF EXISTS player_quests
;
CREATE TABLE player_quests
(
player_id
int(11) NOT NULL,
quest_id
int(10) unsigned NOT NULL DEFAULT '0',
status
varchar(10) NOT NULL DEFAULT 'NONE',
quest_vars
int(10) unsigned NOT NULL DEFAULT '0',
complete_count
int(3) unsigned NOT NULL DEFAULT '0',
next_repeat_time
timestamp NULL DEFAULT NULL,
reward
smallint(3) DEFAULT NULL,
complete_time
timestamp NULL DEFAULT NULL,
PRIMARY KEY (player_id
,quest_id
),
CONSTRAINT player_quests_ibfk_1
FOREIGN KEY (player_id
) REFERENCES players
(id
) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- Records of player_quests
-- Table structure for player_recipes
DROP TABLE IF EXISTS player_recipes
;
CREATE TABLE player_recipes
(
player_id
int(11) NOT NULL,
recipe_id
int(11) NOT NULL,
PRIMARY KEY (player_id
,recipe_id
),
CONSTRAINT player_recipes_ibfk_1
FOREIGN KEY (player_id
) REFERENCES players
(id
) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- Records of player_recipes
-- Table structure for player_registered_items
DROP TABLE IF EXISTS player_registered_items
;
CREATE TABLE player_registered_items
(
player_id
int(10) NOT NULL,
item_unique_id
int(10) NOT NULL,
item_id
int(10) NOT NULL,
expire_time
int(20) DEFAULT NULL,
color
int(11) DEFAULT NULL,
color_expires
int(11) NOT NULL DEFAULT '0',
owner_use_count
int(10) NOT NULL DEFAULT '0',
visitor_use_count
int(10) NOT NULL DEFAULT '0',
x
float NOT NULL DEFAULT '0',
y
float NOT NULL DEFAULT '0',
z
float NOT NULL DEFAULT '0',
h
smallint(3) DEFAULT NULL,
area
enum('NONE','INTERIOR','EXTERIOR','ALL','DECOR') NOT NULL DEFAULT 'NONE',
floor
tinyint(4) NOT NULL DEFAULT '0',
PRIMARY KEY (player_id
,item_unique_id
,item_id
),
CONSTRAINT player_regitems_ibfk_1
FOREIGN KEY (player_id
) REFERENCES players
(`
[Msg] Finished - Unsuccessfully