PHP Code:
# Dumping structure for table sfgame.server_settings
CREATE TABLE IF NOT EXISTS `server_settings` (
`name` varchar(255) DEFAULT NULL,
`value` varchar(255) DEFAULT NULL,
UNIQUE KEY `name` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
# Data exporting was unselected.
# Dumping structure for table sfgame.user
CREATE TABLE IF NOT EXISTS `user` (
`SG_PLAYER_ID` int(10) unsigned NOT NULL AUTO_INCREMENT,
`SG_SESSION_ID` varchar(40) DEFAULT NULL,
`SG_USERNAME` varchar(20) DEFAULT NULL,
`SG_PASSWORD` varchar(32) DEFAULT NULL,
PRIMARY KEY (`SG_PLAYER_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
# Data exporting was unselected.
# Dumping structure for table sfgame.user_data
CREATE TABLE IF NOT EXISTS `user_data` (
`SG_PAYMENT_ID` int(10) NOT NULL DEFAULT '0',
`SG_PLAYER_ID` int(10) NOT NULL DEFAULT '0',
`SG_LAST_ACTION_DATE` int(10) NOT NULL DEFAULT '0',
`SG_REGISTRATION_DATE` int(10) NOT NULL DEFAULT '0',
`SG_REGISTRATION_IP` int(10) NOT NULL DEFAULT '0',
`SG_MSG_COUNT` int(10) NOT NULL DEFAULT '0',
`SG_VALIDATION_IP` int(10) NOT NULL DEFAULT '0',
`SG_LEVEL` int(10) NOT NULL DEFAULT '1',
`SG_EXP` int(10) NOT NULL DEFAULT '0',
`SG_EXP_FOR_NEXTLEVEL` int(10) NOT NULL DEFAULT '400',
`SG_HONOR` int(10) NOT NULL DEFAULT '0',
`SG_RANK` int(10) NOT NULL DEFAULT '0',
`SG_CLASS_RANK` int(10) NOT NULL DEFAULT '0',
`SG_GOLD` int(10) NOT NULL DEFAULT '500',
`SG_MUSH` int(10) NOT NULL DEFAULT '25',
`SG_MUSH_GAINED` int(10) NOT NULL DEFAULT '0',
`SG_MUSH_SPENT` int(10) NOT NULL DEFAULT '0',
`SG_FACE_1` int(10) NOT NULL DEFAULT '0',
`SG_FACE_2` int(10) NOT NULL DEFAULT '0',
`SG_FACE_3` int(10) NOT NULL DEFAULT '0',
`SG_FACE_4` int(10) NOT NULL DEFAULT '0',
`SG_FACE_5` int(10) NOT NULL DEFAULT '0',
`SG_FACE_6` int(10) NOT NULL DEFAULT '0',
`SG_FACE_7` int(10) NOT NULL DEFAULT '0',
`SG_FACE_8` int(10) NOT NULL DEFAULT '0',
`SG_FACE_9` int(10) NOT NULL DEFAULT '0',
`SG_FACE_10` int(10) NOT NULL DEFAULT '0',
`SG_RACE` int(10) NOT NULL DEFAULT '0',
`SG_GENDER` int(10) NOT NULL DEFAULT '0',
`SG_CLASS` int(10) NOT NULL DEFAULT '0',
`SG_ATTR_STAERKE` int(10) NOT NULL DEFAULT '0',
`SG_ATTR_BEWEGLICHKEIT` int(10) NOT NULL DEFAULT '0',
`SG_ATTR_AUSDAUER` int(10) NOT NULL DEFAULT '0',
`SG_ATTR_INTELLIGENZ` int(10) NOT NULL DEFAULT '0',
`SG_ATTR_WILLENSKRAFT` int(10) NOT NULL DEFAULT '0',
`SG_ATTR_STAERKE_BONUS` int(10) NOT NULL DEFAULT '0',
`SG_ATTR_BEWEGLICHKEIT_BONUS` int(10) NOT NULL DEFAULT '0',
`SG_ATTR_AUSDAUER_BONUS` int(10) NOT NULL DEFAULT '0',
`SG_ATTR_INTELLIGENZ_BONUS` int(10) NOT NULL DEFAULT '0',
`SG_ATTR_WILLENSKRAFT_BONUS` int(10) NOT NULL DEFAULT '0',
`SG_ATTR_STAERKE_GEKAUFT` int(10) NOT NULL DEFAULT '0',
`SG_ATTR_BEWEGLICHKEIT_GEKAUFT` int(10) NOT NULL DEFAULT '0',
`SG_ATTR_AUSDAUER_GEKAUFT` int(10) NOT NULL DEFAULT '0',
`SG_ATTR_INTELLIGENZ_GEKAUFT` int(10) NOT NULL DEFAULT '0',
`SG_ATTR_WILLENSKRAFT_GEKAUFT` int(10) NOT NULL DEFAULT '0',
`SG_ACTION_STATUS` int(10) NOT NULL DEFAULT '0',
`SG_ACTION_INDEX` int(10) NOT NULL DEFAULT '0',
`SG_ACTION_ENDTIME` int(10) NOT NULL DEFAULT '0',
`SG_INVENTORY_OFFS1` int(10) NOT NULL DEFAULT '0',
`SG_INVENTORY_OFFS1_1` int(10) NOT NULL DEFAULT '0',
`SG_INVENTORY_OFFS1_2` int(10) NOT NULL DEFAULT '0',
`SG_INVENTORY_OFFS1_3` int(10) NOT NULL DEFAULT '0',
`SG_INVENTORY_OFFS1_4` int(10) NOT NULL DEFAULT '0',
`SG_INVENTORY_OFFS1_5` int(10) NOT NULL DEFAULT '0',
`SG_INVENTORY_OFFS1_6` int(10) NOT NULL DEFAULT '0',
`SG_INVENTORY_OFFS1_7` int(10) NOT NULL DEFAULT '0',
`SG_INVENTORY_OFFS1_8` int(10) NOT NULL DEFAULT '0',
`SG_INVENTORY_OFFS1_9` int(10) NOT NULL DEFAULT '0',
`SG_INVENTORY_OFFS1_10` int(10) NOT NULL DEFAULT '0',
`SG_INVENTORY_OFFS1_11` int(10) NOT NULL DEFAULT '0',
`SG_INVENTORY_OFFS2` int(10) NOT NULL DEFAULT '0',
`SG_INVENTORY_OFFS2_1` int(10) NOT NULL DEFAULT '0',
`SG_INVENTORY_OFFS2_2` int(10) NOT NULL DEFAULT '0',
`SG_INVENTORY_OFFS2_3` int(10) NOT NULL DEFAULT '0',
`SG_INVENTORY_OFFS2_4` int(10) NOT NULL DEFAULT '0',
`SG_INVENTORY_OFFS2_5` int(10) NOT NULL DEFAULT '0',
`SG_INVENTORY_OFFS2_6` int(10) NOT NULL DEFAULT '0',
`SG_INVENTORY_OFFS2_7` int(10) NOT NULL DEFAULT '0',
`SG_INVENTORY_OFFS2_8` int(10) NOT NULL DEFAULT '0',
`SG_INVENTORY_OFFS2_9` int(10) NOT NULL DEFAULT '0',
`SG_INVENTORY_OFFS2_10` int(10) NOT NULL DEFAULT '0',
`SG_INVENTORY_OFFS2_11` int(10) NOT NULL DEFAULT '0',
`SG_INVENTORY_OFFS3` int(10) NOT NULL DEFAULT '0',
`SG_INVENTORY_OFFS3_1` int(10) NOT NULL DEFAULT '0',
`SG_INVENTORY_OFFS3_2` int(10) NOT NULL DEFAULT '0',
`SG_INVENTORY_OFFS3_3` int(10) NOT NULL DEFAULT '0',
`SG_INVENTORY_OFFS3_4` int(10) NOT NULL DEFAULT '0',
`SG_INVENTORY_OFFS3_5` int(10) NOT NULL DEFAULT '0',
`SG_INVENTORY_OFFS3_6` int(10) NOT NULL DEFAULT '0',
`SG_INVENTORY_OFFS3_7` int(10) NOT NULL DEFAULT '0',
`SG_INVENTORY_OFFS3_8` int(10) NOT NULL DEFAULT '0',
`SG_INVENTORY_OFFS3_9` int(10) NOT NULL DEFAULT '0',
`SG_INVENTORY_OFFS3_10` int(10) NOT NULL DEFAULT '0',
`SG_INVENTORY_OFFS3_11` int(10) NOT NULL DEFAULT '0',
`SG_INVENTORY_OFFS4` int(10) NOT NULL DEFAULT '0',
`SG_INVENTORY_OFFS4_1` int(10) NOT NULL DEFAULT '0',
`SG_INVENTORY_OFFS4_2` int(10) NOT NULL DEFAULT '0',
`SG_INVENTORY_OFFS4_3` int(10) NOT NULL DEFAULT '0',
`SG_INVENTORY_OFFS4_4` int(10) NOT NULL DEFAULT '0',
`SG_INVENTORY_OFFS4_5` int(10) NOT NULL DEFAULT '0',
`SG_INVENTORY_OFFS4_6` int(10) NOT NULL DEFAULT '0',
`SG_INVENTORY_OFFS4_7` int(10) NOT NULL DEFAULT '0',
`SG_INVENTORY_OFFS4_8` int(10) NOT NULL DEFAULT '0',
`SG_INVENTORY_OFFS4_9` int(10) NOT NULL DEFAULT '0',
`SG_INVENTORY_OFFS4_10` int(10) NOT NULL DEFAULT '0',
`SG_INVENTORY_OFFS4_11` int(10) NOT NULL DEFAULT '0',
`SG_INVENTORY_OFFS5` int(10) NOT NULL DEFAULT '0',
`SG_INVENTORY_OFFS5_1` int(10) NOT NULL DEFAULT '0',
`SG_INVENTORY_OFFS5_2` int(10) NOT NULL DEFAULT '0',
`SG_INVENTORY_OFFS5_3` int(10) NOT NULL DEFAULT '0',
`SG_INVENTORY_OFFS5_4` int(10) NOT NULL DEFAULT '0',
`SG_INVENTORY_OFFS5_5` int(10) NOT NULL DEFAULT '0',
`SG_INVENTORY_OFFS5_6` int(10) NOT NULL DEFAULT '0',
`SG_INVENTORY_OFFS5_7` int(10) NOT NULL DEFAULT '0',
`SG_INVENTORY_OFFS5_8` int(10) NOT NULL DEFAULT '0',
`SG_INVENTORY_OFFS5_9` int(10) NOT NULL DEFAULT '0',
`SG_INVENTORY_OFFS5_10` int(10) NOT NULL DEFAULT '0',
`SG_INVENTORY_OFFS5_11` int(10) NOT NULL DEFAULT '0',
`SG_INVENTORY_OFFS6` int(10) NOT NULL DEFAULT '0',
`SG_INVENTORY_OFFS6_1` int(10) NOT NULL DEFAULT '0',
`SG_INVENTORY_OFFS6_2` int(10) NOT NULL DEFAULT '0',
`SG_INVENTORY_OFFS6_3` int(10) NOT NULL DEFAULT '0',
`SG_INVENTORY_OFFS6_4` int(10) NOT NULL DEFAULT '0',
`SG_INVENTORY_OFFS6_5` int(10) NOT NULL DEFAULT '0',
`SG_INVENTORY_OFFS6_6` int(10) NOT NULL DEFAULT '0',
`SG_INVENTORY_OFFS6_7` int(10) NOT NULL DEFAULT '0',
`SG_INVENTORY_OFFS6_8` int(10) NOT NULL DEFAULT '0',
`SG_INVENTORY_OFFS6_9` int(10) NOT NULL DEFAULT '0',
`SG_INVENTORY_OFFS6_10` int(10) NOT NULL DEFAULT '0',
`SG_INVENTORY_OFFS6_11` int(10) NOT NULL DEFAULT '0',
`SG_INVENTORY_OFFS7` int(10) NOT NULL DEFAULT '0',
`SG_INVENTORY_OFFS7_1` int(10) NOT NULL DEFAULT '0',
`SG_INVENTORY_OFFS7_2` int(10) NOT NULL DEFAULT '0',
`SG_INVENTORY_OFFS7_3` int(10) NOT NULL DEFAULT '0',
`SG_INVENTORY_OFFS7_4` int(10) NOT NULL DEFAULT '0',
`SG_INVENTORY_OFFS7_5` int(10) NOT NULL DEFAULT '0',
`SG_INVENTORY_OFFS7_6` int(10) NOT NULL DEFAULT '0',
`SG_INVENTORY_OFFS7_7` int(10) NOT NULL DEFAULT '0',
`SG_INVENTORY_OFFS7_8` int(10) NOT NULL DEFAULT '0',
`SG_INVENTORY_OFFS7_9` int(10) NOT NULL DEFAULT '0',
`SG_INVENTORY_OFFS7_10` int(10) NOT NULL DEFAULT '0',
`SG_INVENTORY_OFFS7_11` int(10) NOT NULL DEFAULT '0',
`SG_INVENTORY_OFFS8` int(10) NOT NULL DEFAULT '0',
`SG_INVENTORY_OFFS8_1` int(10) NOT NULL DEFAULT '0',
`SG_INVENTORY_OFFS8_2` int(10) NOT NULL DEFAULT '0',
`SG_INVENTORY_OFFS8_3` int(10) NOT NULL DEFAULT '0',
`SG_INVENTORY_OFFS8_4` int(10) NOT NULL DEFAULT '0',
`SG_INVENTORY_OFFS8_5` int(10) NOT NULL DEFAULT '0',
`SG_INVENTORY_OFFS8_6` int(10) NOT NULL DEFAULT '0',
`SG_INVENTORY_OFFS8_7` int(10) NOT NULL DEFAULT '0',
`SG_INVENTORY_OFFS8_8` int(10) NOT NULL DEFAULT '0',
`SG_INVENTORY_OFFS8_9` int(10) NOT NULL DEFAULT '0',
`SG_INVENTORY_OFFS8_10` int(10) NOT NULL DEFAULT '0',
`SG_INVENTORY_OFFS8_11` int(10) NOT NULL DEFAULT '0',
`SG_ITEM1` int(10) NOT NULL DEFAULT '0',
`SG_ITEM1_1` int(10) NOT NULL DEFAULT '0',
`SG_ITEM1_2` int(10) NOT NULL DEFAULT '0',
`SG_ITEM1_3` int(10) NOT NULL DEFAULT '0',
`SG_ITEM1_4` int(10) NOT NULL DEFAULT '0',
`SG_ITEM1_5` int(10) NOT NULL DEFAULT '0',
`SG_ITEM1_6` int(10) NOT NULL DEFAULT '0',
`SG_ITEM1_7` int(10) NOT NULL DEFAULT '0',
`SG_ITEM1_8` int(10) NOT NULL DEFAULT '0',
`SG_ITEM1_9` int(10) NOT NULL DEFAULT '0',
`SG_ITEM1_10` int(10) NOT NULL DEFAULT '0',
`SG_ITEM1_11` int(10) NOT NULL DEFAULT '0',
`SG_ITEM2` int(10) NOT NULL DEFAULT '0',
`SG_ITEM2_1` int(10) NOT NULL DEFAULT '0',
`SG_ITEM2_2` int(10) NOT NULL DEFAULT '0',
`SG_ITEM2_3` int(10) NOT NULL DEFAULT '0',
`SG_ITEM2_4` int(10) NOT NULL DEFAULT '0',
`SG_ITEM2_5` int(10) NOT NULL DEFAULT '0',
`SG_ITEM2_6` int(10) NOT NULL DEFAULT '0',
`SG_ITEM2_7` int(10) NOT NULL DEFAULT '0',
`SG_ITEM2_8` int(10) NOT NULL DEFAULT '0',
`SG_ITEM2_9` int(10) NOT NULL DEFAULT '0',
`SG_ITEM2_10` int(10) NOT NULL DEFAULT '0',
`SG_ITEM2_11` int(10) NOT NULL DEFAULT '0',
`SG_BACKPACK_OFFS1` int(10) NOT NULL DEFAULT '0',
`SG_BACKPACK_OFFS1_2` int(10) NOT NULL DEFAULT '0',
`SG_BACKPACK_OFFS1_3` int(10) NOT NULL DEFAULT '0',
`SG_BACKPACK_OFFS1_4` int(10) NOT NULL DEFAULT '0',
`SG_BACKPACK_OFFS1_5` int(10) NOT NULL DEFAULT '0',
`SG_BACKPACK_OFFS1_6` int(10) NOT NULL DEFAULT '0',
`SG_BACKPACK_OFFS1_7` int(10) NOT NULL DEFAULT '0',
`SG_BACKPACK_OFFS1_8` int(10) NOT NULL DEFAULT '0',
`SG_BACKPACK_OFFS1_9` int(10) NOT NULL DEFAULT '0',
`SG_BACKPACK_OFFS1_10` int(10) NOT NULL DEFAULT '0',
`SG_BACKPACK_OFFS1_11` int(10) NOT NULL DEFAULT '0',
`SG_BACKPACK_OFFS1_12` int(10) NOT NULL DEFAULT '0',
`SG_BACKPACK_OFFS2` int(10) NOT NULL DEFAULT '0',
`SG_BACKPACK_OFFS2_2` int(10) NOT NULL DEFAULT '0',
`SG_BACKPACK_OFFS2_3` int(10) NOT NULL DEFAULT '0',
`SG_BACKPACK_OFFS2_4` int(10) NOT NULL DEFAULT '0',
`SG_BACKPACK_OFFS2_5` int(10) NOT NULL DEFAULT '0',
`SG_BACKPACK_OFFS2_6` int(10) NOT NULL DEFAULT '0',
`SG_BACKPACK_OFFS2_7` int(10) NOT NULL DEFAULT '0',
`SG_BACKPACK_OFFS2_8` int(10) NOT NULL DEFAULT '0',
`SG_BACKPACK_OFFS2_9` int(10) NOT NULL DEFAULT '0',
`SG_BACKPACK_OFFS2_10` int(10) NOT NULL DEFAULT '0',
`SG_BACKPACK_OFFS2_11` int(10) NOT NULL DEFAULT '0',
`SG_BACKPACK_OFFS2_12` int(10) NOT NULL DEFAULT '0',
`SG_BACKPACK_OFFS3` int(10) NOT NULL DEFAULT '0',
`SG_BACKPACK_OFFS3_2` int(10) NOT NULL DEFAULT '0',
`SG_BACKPACK_OFFS3_3` int(10) NOT NULL DEFAULT '0',
`SG_BACKPACK_OFFS3_4` int(10) NOT NULL DEFAULT '0',
`SG_BACKPACK_OFFS3_5` int(10) NOT NULL DEFAULT '0',
`SG_BACKPACK_OFFS3_6` int(10) NOT NULL DEFAULT '0',
`SG_BACKPACK_OFFS3_7` int(10) NOT NULL DEFAULT '0',
`SG_BACKPACK_OFFS3_8` int(10) NOT NULL DEFAULT '0',
`SG_BACKPACK_OFFS3_9` int(10) NOT NULL DEFAULT '0',
`SG_BACKPACK_OFFS3_10` int(10) NOT NULL DEFAULT '0',
`SG_BACKPACK_OFFS3_11` int(10) NOT NULL DEFAULT '0',
`SG_BACKPACK_OFFS3_12` int(10) NOT NULL DEFAULT '0',
`SG_BACKPACK_OFFS4` int(10) NOT NULL DEFAULT '0',
`SG_BACKPACK_OFFS4_2` int(10) NOT NULL DEFAULT '0',
`SG_BACKPACK_OFFS4_3` int(10) NOT NULL DEFAULT '0',
`SG_BACKPACK_OFFS4_4` int(10) NOT NULL DEFAULT '0',
`SG_BACKPACK_OFFS4_5` int(10) NOT NULL DEFAULT '0',
`SG_BACKPACK_OFFS4_6` int(10) NOT NULL DEFAULT '0',
`SG_BACKPACK_OFFS4_7` int(10) NOT NULL DEFAULT '0',
`SG_BACKPACK_OFFS4_8` int(10) NOT NULL DEFAULT '0',
`SG_BACKPACK_OFFS4_9` int(10) NOT NULL DEFAULT '0',
`SG_BACKPACK_OFFS4_10` int(10) NOT NULL DEFAULT '0',
`SG_BACKPACK_OFFS4_11` int(10) NOT NULL DEFAULT '0',
`SG_BACKPACK_OFFS4_12` int(10) NOT NULL DEFAULT '0',
`SG_BACKPACK_OFFS5` int(10) NOT NULL DEFAULT '0',
`SG_BACKPACK_OFFS5_2` int(10) NOT NULL DEFAULT '0',
`SG_BACKPACK_OFFS5_3` int(10) NOT NULL DEFAULT '0',
`SG_BACKPACK_OFFS5_4` int(10) NOT NULL DEFAULT '0',
`SG_BACKPACK_OFFS5_5` int(10) NOT NULL DEFAULT '0',
`SG_BACKPACK_OFFS5_6` int(10) NOT NULL DEFAULT '0',
`SG_BACKPACK_OFFS5_7` int(10) NOT NULL DEFAULT '0',
`SG_BACKPACK_OFFS5_8` int(10) NOT NULL DEFAULT '0',
`SG_BACKPACK_OFFS5_9` int(10) NOT NULL DEFAULT '0',
`SG_BACKPACK_OFFS5_10` int(10) NOT NULL DEFAULT '0',
`SG_BACKPACK_OFFS5_11` int(10) NOT NULL DEFAULT '0',
`SG_BACKPACK_OFFS5_12` int(10) NOT NULL DEFAULT '0',
`SG_QUEST_REROLL_TIME` int(10) NOT NULL DEFAULT '0',
`SG_QUEST_OFFER_LEVEL1` int(10) NOT NULL DEFAULT '0',
`SG_QUEST_OFFER_LEVEL2` int(10) NOT NULL DEFAULT '0',
`SG_QUEST_OFFER_LEVEL3` int(10) NOT NULL DEFAULT '0',
`SG_QUEST_OFFER_TYPE1` int(10) NOT NULL DEFAULT '0',
`SG_QUEST_OFFER_TYPE2` int(10) NOT NULL DEFAULT '0',
`SG_QUEST_OFFER_TYPE3` int(10) NOT NULL DEFAULT '0',
`SG_QUEST_OFFER_ENEMY1` int(10) NOT NULL DEFAULT '0',
`SG_QUEST_OFFER_ENEMY2` int(10) NOT NULL DEFAULT '0',
`SG_QUEST_OFFER_ENEMY3` int(10) NOT NULL DEFAULT '0',
`SG_QUEST_OFFER_LOCATION1` int(10) NOT NULL DEFAULT '0',
`SG_QUEST_OFFER_LOCATION2` int(10) NOT NULL DEFAULT '0',
`SG_QUEST_OFFER_LOCATION3` int(10) NOT NULL DEFAULT '0',
`SG_QUEST_OFFER_DURATION1` int(10) NOT NULL DEFAULT '0',
`SG_QUEST_OFFER_DURATION2` int(10) NOT NULL DEFAULT '0',
`SG_QUEST_OFFER_DURATION3` int(10) NOT NULL DEFAULT '0',
`SG_QUEST_OFFER_REWARD_ITM1` int(10) NOT NULL DEFAULT '0',
`SG_QUEST_OFFER_REWARD_ITM1_2` int(10) NOT NULL DEFAULT '0',
`SG_QUEST_OFFER_REWARD_ITM1_3` int(10) NOT NULL DEFAULT '0',
`SG_QUEST_OFFER_REWARD_ITM1_4` int(10) NOT NULL DEFAULT '0',
`SG_QUEST_OFFER_REWARD_ITM1_5` int(10) NOT NULL DEFAULT '0',
`SG_QUEST_OFFER_REWARD_ITM1_6` int(10) NOT NULL DEFAULT '0',
`SG_QUEST_OFFER_REWARD_ITM1_7` int(10) NOT NULL DEFAULT '0',
`SG_QUEST_OFFER_REWARD_ITM1_8` int(10) NOT NULL DEFAULT '0',
`SG_QUEST_OFFER_REWARD_ITM1_9` int(10) NOT NULL DEFAULT '0',
`SG_QUEST_OFFER_REWARD_ITM1_10` int(10) NOT NULL DEFAULT '0',
`SG_QUEST_OFFER_REWARD_ITM1_11` int(10) NOT NULL DEFAULT '0',
`SG_QUEST_OFFER_REWARD_ITM1_12` int(10) NOT NULL DEFAULT '0',
`SG_QUEST_OFFER_REWARD_ITM2` int(10) NOT NULL DEFAULT '0',
`SG_QUEST_OFFER_REWARD_ITM2_2` int(10) NOT NULL DEFAULT '0',
`SG_QUEST_OFFER_REWARD_ITM2_3` int(10) NOT NULL DEFAULT '0',
`SG_QUEST_OFFER_REWARD_ITM2_4` int(10) NOT NULL DEFAULT '0',
`SG_QUEST_OFFER_REWARD_ITM2_5` int(10) NOT NULL DEFAULT '0',
`SG_QUEST_OFFER_REWARD_ITM2_6` int(10) NOT NULL DEFAULT '0',
`SG_QUEST_OFFER_REWARD_ITM2_7` int(10) NOT NULL DEFAULT '0',
`SG_QUEST_OFFER_REWARD_ITM2_8` int(10) NOT NULL DEFAULT '0',
`SG_QUEST_OFFER_REWARD_ITM2_9` int(10) NOT NULL DEFAULT '0',
`SG_QUEST_OFFER_REWARD_ITM2_10` int(10) NOT NULL DEFAULT '0',
`SG_QUEST_OFFER_REWARD_ITM2_11` int(10) NOT NULL DEFAULT '0',
`SG_QUEST_OFFER_REWARD_ITM2_12` int(10) NOT NULL DEFAULT '0',
`SG_QUEST_OFFER_REWARD_ITM3` int(10) NOT NULL DEFAULT '0',
`SG_QUEST_OFFER_REWARD_ITM3_2` int(10) NOT NULL DEFAULT '0',
`SG_QUEST_OFFER_REWARD_ITM3_3` int(10) NOT NULL DEFAULT '0',
`SG_QUEST_OFFER_REWARD_ITM3_4` int(10) NOT NULL DEFAULT '0',
`SG_QUEST_OFFER_REWARD_ITM3_5` int(10) NOT NULL DEFAULT '0',
`SG_QUEST_OFFER_REWARD_ITM3_6` int(10) NOT NULL DEFAULT '0',
`SG_QUEST_OFFER_REWARD_ITM3_7` int(10) NOT NULL DEFAULT '0',
`SG_QUEST_OFFER_REWARD_ITM3_8` int(10) NOT NULL DEFAULT '0',
`SG_QUEST_OFFER_REWARD_ITM3_9` int(10) NOT NULL DEFAULT '0',
`SG_QUEST_OFFER_REWARD_ITM3_10` int(10) NOT NULL DEFAULT '0',
`SG_QUEST_OFFER_REWARD_ITM3_11` int(10) NOT NULL DEFAULT '0',
`SG_QUEST_OFFER_REWARD_ITM3_12` int(10) NOT NULL DEFAULT '0',
`SG_QUEST_OFFER_EXP1` int(10) NOT NULL DEFAULT '0',
`SG_QUEST_OFFER_EXP2` int(10) NOT NULL DEFAULT '0',
`SG_QUEST_OFFER_EXP3` int(10) NOT NULL DEFAULT '0',
`SG_QUEST_OFFER_GOLD1` int(10) NOT NULL DEFAULT '0',
`SG_QUEST_OFFER_GOLD2` int(10) NOT NULL DEFAULT '0',
`SG_QUEST_OFFER_GOLD3` int(10) NOT NULL DEFAULT '0',
`SG_MOUNT` int(10) NOT NULL DEFAULT '0',
`SG_SHAKES_REROLL_TIME` int(10) NOT NULL DEFAULT '0',
`SG_SHAKES_ITEM1` int(10) NOT NULL DEFAULT '0',
`SG_SHAKES_ITEM1_2` int(10) NOT NULL DEFAULT '0',
`SG_SHAKES_ITEM1_3` int(10) NOT NULL DEFAULT '0',
`SG_SHAKES_ITEM1_4` int(10) NOT NULL DEFAULT '0',
`SG_SHAKES_ITEM1_5` int(10) NOT NULL DEFAULT '0',
`SG_SHAKES_ITEM1_6` int(10) NOT NULL DEFAULT '0',
`SG_SHAKES_ITEM1_7` int(10) NOT NULL DEFAULT '0',
`SG_SHAKES_ITEM1_8` int(10) NOT NULL DEFAULT '0',
`SG_SHAKES_ITEM1_9` int(10) NOT NULL DEFAULT '0',
`SG_SHAKES_ITEM1_10` int(10) NOT NULL DEFAULT '0',
`SG_SHAKES_ITEM1_11` int(10) NOT NULL DEFAULT '0',
`SG_SHAKES_ITEM1_12` int(10) NOT NULL DEFAULT '0',
`SG_SHAKES_ITEM2` int(10) NOT NULL DEFAULT '0',
`SG_SHAKES_ITEM2_2` int(10) NOT NULL DEFAULT '0',
`SG_SHAKES_ITEM2_3` int(10) NOT NULL DEFAULT '0',
`SG_SHAKES_ITEM2_4` int(10) NOT NULL DEFAULT '0',
`SG_SHAKES_ITEM2_5` int(10) NOT NULL DEFAULT '0',
`SG_SHAKES_ITEM2_6` int(10) NOT NULL DEFAULT '0',
`SG_SHAKES_ITEM2_7` int(10) NOT NULL DEFAULT '0',
`SG_SHAKES_ITEM2_8` int(10) NOT NULL DEFAULT '0',
`SG_SHAKES_ITEM2_9` int(10) NOT NULL DEFAULT '0',
`SG_SHAKES_ITEM2_10` int(10) NOT NULL DEFAULT '0',
`SG_SHAKES_ITEM2_11` int(10) NOT NULL DEFAULT '0',
`SG_SHAKES_ITEM2_12` int(10) NOT NULL DEFAULT '0',
`SG_SHAKES_ITEM3` int(10) NOT NULL DEFAULT '0',
`SG_SHAKES_ITEM3_2` int(10) NOT NULL DEFAULT '0',
`SG_SHAKES_ITEM3_3` int(10) NOT NULL DEFAULT '0',
`SG_SHAKES_ITEM3_4` int(10) NOT NULL DEFAULT '0',
`SG_SHAKES_ITEM3_5` int(10) NOT NULL DEFAULT '0',
`SG_SHAKES_ITEM3_6` int(10) NOT NULL DEFAULT '0',
`SG_SHAKES_ITEM3_7` int(10) NOT NULL DEFAULT '0',
`SG_SHAKES_ITEM3_8` int(10) NOT NULL DEFAULT '0',
`SG_SHAKES_ITEM3_9` int(10) NOT NULL DEFAULT '0',
`SG_SHAKES_ITEM3_10` int(10) NOT NULL DEFAULT '0',
`SG_SHAKES_ITEM3_11` int(10) NOT NULL DEFAULT '0',
`SG_SHAKES_ITEM3_12` int(10) NOT NULL DEFAULT '0',
`SG_SHAKES_ITEM4` int(10) NOT NULL DEFAULT '0',
`SG_SHAKES_ITEM4_2` int(10) NOT NULL DEFAULT '0',
`SG_SHAKES_ITEM4_3` int(10) NOT NULL DEFAULT '0',
`SG_SHAKES_ITEM4_4` int(10) NOT NULL DEFAULT '0',
`SG_SHAKES_ITEM4_5` int(10) NOT NULL DEFAULT '0',
`SG_SHAKES_ITEM4_6` int(10) NOT NULL DEFAULT '0',
`SG_SHAKES_ITEM4_7` int(10) NOT NULL DEFAULT '0',
`SG_SHAKES_ITEM4_8` int(10) NOT NULL DEFAULT '0',
`SG_SHAKES_ITEM4_9` int(10) NOT NULL DEFAULT '0',
`SG_SHAKES_ITEM4_10` int(10) NOT NULL DEFAULT '0',
`SG_SHAKES_ITEM4_11` int(10) NOT NULL DEFAULT '0',
`SG_SHAKES_ITEM4_12` int(10) NOT NULL DEFAULT '0',
`SG_SHAKES_ITEM5` int(10) NOT NULL DEFAULT '0',
`SG_SHAKES_ITEM5_2` int(10) NOT NULL DEFAULT '0',
`SG_SHAKES_ITEM5_3` int(10) NOT NULL DEFAULT '0',
`SG_SHAKES_ITEM5_4` int(10) NOT NULL DEFAULT '0',
`SG_SHAKES_ITEM5_5` int(10) NOT NULL DEFAULT '0',
`SG_SHAKES_ITEM5_6` int(10) NOT NULL DEFAULT '0',
`SG_SHAKES_ITEM5_7` int(10) NOT NULL DEFAULT '0',
`SG_SHAKES_ITEM5_8` int(10) NOT NULL DEFAULT '0',
`SG_SHAKES_ITEM5_9` int(10) NOT NULL DEFAULT '0',
`SG_SHAKES_ITEM5_10` int(10) NOT NULL DEFAULT '0',
`SG_SHAKES_ITEM5_11` int(10) NOT NULL DEFAULT '0',
`SG_SHAKES_ITEM5_12` int(10) NOT NULL DEFAULT '0',
`SG_SHAKES_ITEM6` int(10) NOT NULL DEFAULT '0',
`SG_SHAKES_ITEM6_2` int(10) NOT NULL DEFAULT '0',
`SG_SHAKES_ITEM6_3` int(10) NOT NULL DEFAULT '0',
`SG_SHAKES_ITEM6_4` int(10) NOT NULL DEFAULT '0',
`SG_SHAKES_ITEM6_5` int(10) NOT NULL DEFAULT '0',
`SG_SHAKES_ITEM6_6` int(10) NOT NULL DEFAULT '0',
`SG_SHAKES_ITEM6_7` int(10) NOT NULL DEFAULT '0',
`SG_SHAKES_ITEM6_8` int(10) NOT NULL DEFAULT '0',
`SG_SHAKES_ITEM6_9` int(10) NOT NULL DEFAULT '0',
`SG_SHAKES_ITEM6_10` int(10) NOT NULL DEFAULT '0',
`SG_SHAKES_ITEM6_11` int(10) NOT NULL DEFAULT '0',
`SG_SHAKES_ITEM6_12` int(10) NOT NULL DEFAULT '0',
`SG_FIDGET_REROLL_TIME` int(10) NOT NULL DEFAULT '0',
`SG_FIDGET_ITEM1` int(10) NOT NULL DEFAULT '0',
`SG_FIDGET_ITEM1_2` int(10) NOT NULL DEFAULT '0',
`SG_FIDGET_ITEM1_3` int(10) NOT NULL DEFAULT '0',
`SG_FIDGET_ITEM1_4` int(10) NOT NULL DEFAULT '0',
`SG_FIDGET_ITEM1_5` int(10) NOT NULL DEFAULT '0',
`SG_FIDGET_ITEM1_6` int(10) NOT NULL DEFAULT '0',
`SG_FIDGET_ITEM1_7` int(10) NOT NULL DEFAULT '0',
`SG_FIDGET_ITEM1_8` int(10) NOT NULL DEFAULT '0',
`SG_FIDGET_ITEM1_9` int(10) NOT NULL DEFAULT '0',
`SG_FIDGET_ITEM1_10` int(10) NOT NULL DEFAULT '0',
`SG_FIDGET_ITEM1_11` int(10) NOT NULL DEFAULT '0',
`SG_FIDGET_ITEM1_12` int(10) NOT NULL DEFAULT '0',
`SG_FIDGET_ITEM2` int(10) NOT NULL DEFAULT '0',
`SG_FIDGET_ITEM2_2` int(10) NOT NULL DEFAULT '0',
`SG_FIDGET_ITEM2_3` int(10) NOT NULL DEFAULT '0',
`SG_FIDGET_ITEM2_4` int(10) NOT NULL DEFAULT '0',
`SG_FIDGET_ITEM2_5` int(10) NOT NULL DEFAULT '0',
`SG_FIDGET_ITEM2_6` int(10) NOT NULL DEFAULT '0',
`SG_FIDGET_ITEM2_7` int(10) NOT NULL DEFAULT '0',
`SG_FIDGET_ITEM2_8` int(10) NOT NULL DEFAULT '0',
`SG_FIDGET_ITEM2_9` int(10) NOT NULL DEFAULT '0',
`SG_FIDGET_ITEM2_10` int(10) NOT NULL DEFAULT '0',
`SG_FIDGET_ITEM2_11` int(10) NOT NULL DEFAULT '0',
`SG_FIDGET_ITEM2_12` int(10) NOT NULL DEFAULT '0',
`SG_FIDGET_ITEM3` int(10) NOT NULL DEFAULT '0',
`SG_FIDGET_ITEM3_2` int(10) NOT NULL DEFAULT '0',
`SG_FIDGET_ITEM3_3` int(10) NOT NULL DEFAULT '0',
`SG_FIDGET_ITEM3_4` int(10) NOT NULL DEFAULT '0',
`SG_FIDGET_ITEM3_5` int(10) NOT NULL DEFAULT '0',
`SG_FIDGET_ITEM3_6` int(10) NOT NULL DEFAULT '0',
`SG_FIDGET_ITEM3_7` int(10) NOT NULL DEFAULT '0',
`SG_FIDGET_ITEM3_8` int(10) NOT NULL DEFAULT '0',
`SG_FIDGET_ITEM3_9` int(10) NOT NULL DEFAULT '0',
`SG_FIDGET_ITEM3_10` int(10) NOT NULL DEFAULT '0',
`SG_FIDGET_ITEM3_11` int(10) NOT NULL DEFAULT '0',
`SG_FIDGET_ITEM3_12` int(10) NOT NULL DEFAULT '0',
`SG_FIDGET_ITEM4` int(10) NOT NULL DEFAULT '0',
`SG_FIDGET_ITEM4_2` int(10) NOT NULL DEFAULT '0',
`SG_FIDGET_ITEM4_3` int(10) NOT NULL DEFAULT '0',
`SG_FIDGET_ITEM4_4` int(10) NOT NULL DEFAULT '0',
`SG_FIDGET_ITEM4_5` int(10) NOT NULL DEFAULT '0',
`SG_FIDGET_ITEM4_6` int(10) NOT NULL DEFAULT '0',
`SG_FIDGET_ITEM4_7` int(10) NOT NULL DEFAULT '0',
`SG_FIDGET_ITEM4_8` int(10) NOT NULL DEFAULT '0',
`SG_FIDGET_ITEM4_9` int(10) NOT NULL DEFAULT '0',
`SG_FIDGET_ITEM4_10` int(10) NOT NULL DEFAULT '0',
`SG_FIDGET_ITEM4_11` int(10) NOT NULL DEFAULT '0',
`SG_FIDGET_ITEM4_12` int(10) NOT NULL DEFAULT '0',
`SG_FIDGET_ITEM5` int(10) NOT NULL DEFAULT '0',
`SG_FIDGET_ITEM5_2` int(10) NOT NULL DEFAULT '0',
`SG_FIDGET_ITEM5_3` int(10) NOT NULL DEFAULT '0',
`SG_FIDGET_ITEM5_4` int(10) NOT NULL DEFAULT '0',
`SG_FIDGET_ITEM5_5` int(10) NOT NULL DEFAULT '0',
`SG_FIDGET_ITEM5_6` int(10) NOT NULL DEFAULT '0',
`SG_FIDGET_ITEM5_7` int(10) NOT NULL DEFAULT '0',
`SG_FIDGET_ITEM5_8` int(10) NOT NULL DEFAULT '0',
`SG_FIDGET_ITEM5_9` int(10) NOT NULL DEFAULT '0',
`SG_FIDGET_ITEM5_10` int(10) NOT NULL DEFAULT '0',
`SG_FIDGET_ITEM5_11` int(10) NOT NULL DEFAULT '0',
`SG_FIDGET_ITEM5_12` int(10) NOT NULL DEFAULT '0',
`SG_FIDGET_ITEM6` int(10) NOT NULL DEFAULT '0',
`SG_FIDGET_ITEM6_2` int(10) NOT NULL DEFAULT '0',
`SG_FIDGET_ITEM6_3` int(10) NOT NULL DEFAULT '0',
`SG_FIDGET_ITEM6_4` int(10) NOT NULL DEFAULT '0',
`SG_FIDGET_ITEM6_5` int(10) NOT NULL DEFAULT '0',
`SG_FIDGET_ITEM6_6` int(10) NOT NULL DEFAULT '0',
`SG_FIDGET_ITEM6_7` int(10) NOT NULL DEFAULT '0',
`SG_FIDGET_ITEM6_8` int(10) NOT NULL DEFAULT '0',
`SG_FIDGET_ITEM6_9` int(10) NOT NULL DEFAULT '0',
`SG_FIDGET_ITEM6_10` int(10) NOT NULL DEFAULT '0',
`SG_FIDGET_ITEM6_11` int(10) NOT NULL DEFAULT '0',
`SG_FIDGET_ITEM6_12` int(10) NOT NULL DEFAULT '0',
`SG_NEXT_BATTLE_TIME` int(10) NOT NULL DEFAULT '0',
`SG_UNREAD_MESSAGES` int(10) NOT NULL DEFAULT '0',
`SG_GUILD_INDEX` int(10) NOT NULL DEFAULT '0',
`SG_GUILD_RANK` int(10) NOT NULL DEFAULT '0',
`SG_MUSHROOMS_MAY_DONATE` int(10) NOT NULL DEFAULT '0',
`SG_ALBUM` int(10) NOT NULL DEFAULT '0',
`SG_LAST_GUILD_FIGHT_EXP` int(10) NOT NULL DEFAULT '0',
`SG_ACCOUNT_PROTECTION_DATE` int(10) NOT NULL DEFAULT '0',
`SG_NEW_DUNGEONS` int(10) NOT NULL DEFAULT '0',
`SG_EMPTY` int(10) NOT NULL DEFAULT '0',
`SG_GUILD_JOIN_DATE` int(10) NOT NULL DEFAULT '0',
`SG_ARCHIVE_NEW_CALC` int(10) NOT NULL DEFAULT '0',
`SG_MUSH_BOUGHT_SINCE_LAST_LOGIN` int(10) NOT NULL DEFAULT '0',
`SG_WE_MISS_YOU` int(10) NOT NULL DEFAULT '0',
`SG_ARMOR` int(10) NOT NULL DEFAULT '0',
`SG_DAMAGE_MIN` int(10) NOT NULL DEFAULT '0',
`SG_DAMAGE_MAX` int(10) NOT NULL DEFAULT '0',
`SG_LIFE` int(10) NOT NULL DEFAULT '0',
`SG_MOUNT_DURATION` int(10) NOT NULL DEFAULT '0',
`SG_TRANSACTION_COUNT` int(10) NOT NULL DEFAULT '0',
`SG_EVASION` int(10) NOT NULL DEFAULT '0',
`SG_MAGICRSISTANCE` int(10) NOT NULL DEFAULT '0',
`SG_TIMEBAR_REROLL_TIME` int(10) NOT NULL DEFAULT '0',
`SG_TIMEBAR` int(10) NOT NULL DEFAULT '6000',
`SG_BEERS` int(10) NOT NULL DEFAULT '0',
`SG_MQ_STATE` int(10) NOT NULL DEFAULT '0',
`SG_MQ_REROLL_TIME` int(10) NOT NULL DEFAULT '0',
`SG_PVP_REROLL_TIME` int(10) NOT NULL DEFAULT '0',
`SG_EXP_BONUS` int(10) NOT NULL DEFAULT '0',
`SG_GOLD_BONUS` int(10) NOT NULL DEFAULT '0',
`SG_EMAIL_VALID` int(10) NOT NULL DEFAULT '0',
`SG_EMAIL_DATE` int(10) NOT NULL DEFAULT '0',
`SG_ACHIEVEMENTS1` int(10) NOT NULL DEFAULT '0',
`SG_ACHIEVEMENTS1_2` int(10) NOT NULL DEFAULT '0',
`SG_ACHIEVEMENTS1_3` int(10) NOT NULL DEFAULT '0',
`SG_ACHIEVEMENTS1_4` int(10) NOT NULL DEFAULT '0',
`SG_ACHIEVEMENTS1_5` int(10) NOT NULL DEFAULT '0',
`SG_ACHIEVEMENTS1_6` int(10) NOT NULL DEFAULT '0',
`SG_ACHIEVEMENTS1_7` int(10) NOT NULL DEFAULT '0',
`SG_ACHIEVEMENTS1_8` int(10) NOT NULL DEFAULT '0',
`SG_ACHIEVEMENTS1_9` int(10) NOT NULL DEFAULT '0',
`SG_ACHIEVEMENTS1_10` int(10) NOT NULL DEFAULT '0',
`SG_LOCKDURATION` int(10) NOT NULL DEFAULT '0',
`SG_FOO` int(10) NOT NULL DEFAULT '0',
`SG_BAR` int(10) NOT NULL DEFAULT '0',
`SG_HELLO` int(10) NOT NULL DEFAULT '0',
`SG_FIRST_PAYMENT` int(10) NOT NULL DEFAULT '0',
`SG_DUNGEON_LEVEL1` int(10) NOT NULL DEFAULT '0',
`SG_DUNGEON_LEVEL1_2` int(10) NOT NULL DEFAULT '0',
`SG_DUNGEON_LEVEL1_3` int(10) NOT NULL DEFAULT '0',
`SG_DUNGEON_LEVEL1_4` int(10) NOT NULL DEFAULT '0',
`SG_DUNGEON_LEVEL1_5` int(10) NOT NULL DEFAULT '0',
`SG_DUNGEON_LEVEL1_6` int(10) NOT NULL DEFAULT '0',
`SG_DUNGEON_LEVEL1_7` int(10) NOT NULL DEFAULT '0',
`SG_DUNGEON_LEVEL1_8` int(10) NOT NULL DEFAULT '0',
`SG_DUNGEON_LEVEL1_9` int(10) NOT NULL DEFAULT '0',
`SG_DUNGEON_LEVEL1_10` int(10) NOT NULL DEFAULT '0',
`SG_DUNGEON_13` int(10) NOT NULL DEFAULT '0',
`SG_LAST_DUNGEON` int(10) NOT NULL DEFAULT '0',
`SG_PHP_SESSION` int(10) NOT NULL DEFAULT '0',
`SG_POTION_TYPE1` int(10) NOT NULL DEFAULT '0',
`SG_POTION_TYPE1_2` int(10) NOT NULL DEFAULT '0',
`SG_POTION_TYPE1_3` int(10) NOT NULL DEFAULT '0',
`SG_POTION_DURATION1` int(10) NOT NULL DEFAULT '0',
`SG_POTION_DURATION1_2` int(10) NOT NULL DEFAULT '0',
`SG_POTION_DURATION1_3` int(10) NOT NULL DEFAULT '0',
`SG_POTION_GAIN1` int(10) NOT NULL DEFAULT '0',
`SG_POTION_GAIN1_2` int(10) NOT NULL DEFAULT '0',
`SG_POTION_GAIN1_3` int(10) NOT NULL DEFAULT '0',
`SG_POWER_LIFE_POTION` int(10) NOT NULL DEFAULT '0',
`SG_LAST_LOGIN_IP1` int(10) NOT NULL DEFAULT '0',
`SG_LAST_LOGIN_IP2` int(10) NOT NULL DEFAULT '0',
`SG_LAST_LOGIN_IP3` int(10) NOT NULL DEFAULT '0',
`SG_MUSHROOM_BOUGHT_AMOUNT` int(10) NOT NULL DEFAULT '0',
`SG_MUSHROOM_BOUGHT_DATE` int(10) NOT NULL DEFAULT '0',
`SG_GUILD_FIGHT_STATUS` int(10) NOT NULL DEFAULT '0',
`SG_EVENT_TRIGGER_COUNT` int(10) NOT NULL DEFAULT '0',
`SG_SERVER_TIME` varchar(10) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8