diff options
| -rw-r--r-- | sql/base/auth_database.sql | 41 | ||||
| -rw-r--r-- | sql/base/characters_database.sql | 6 | ||||
| -rw-r--r-- | sql/base/dev/world_database.sql | 745 |
3 files changed, 321 insertions, 471 deletions
diff --git a/sql/base/auth_database.sql b/sql/base/auth_database.sql index cf54173cea3..c549c6b4a90 100644 --- a/sql/base/auth_database.sql +++ b/sql/base/auth_database.sql @@ -38,7 +38,7 @@ CREATE TABLE `account` ( `failed_logins` int(10) unsigned NOT NULL DEFAULT '0', `locked` tinyint(3) unsigned NOT NULL DEFAULT '0', `lock_country` varchar(2) NOT NULL DEFAULT '00', - `last_login` timestamp NULL, + `last_login` timestamp NULL DEFAULT NULL, `online` tinyint(3) unsigned NOT NULL DEFAULT '0', `expansion` tinyint(3) unsigned NOT NULL DEFAULT '2', `mutetime` bigint(20) NOT NULL DEFAULT '0', @@ -348,10 +348,10 @@ CREATE TABLE `rbac_default_permissions` ( LOCK TABLES `rbac_default_permissions` WRITE; /*!40000 ALTER TABLE `rbac_default_permissions` DISABLE KEYS */; INSERT INTO `rbac_default_permissions` VALUES -(3,192,-1), -(2,193,-1), (1,194,-1), (0,195,-1); +(2,193,-1), +(3,192,-1); /*!40000 ALTER TABLE `rbac_default_permissions` ENABLE KEYS */; UNLOCK TABLES; @@ -854,6 +854,7 @@ INSERT INTO `rbac_linked_permissions` VALUES (197,486), (197,487), (197,494), +(197,501), (197,506), (197,509), (197,510), @@ -920,7 +921,6 @@ INSERT INTO `rbac_linked_permissions` VALUES (198,316), (198,317), (198,318), -(198,855), (198,367), (198,368), (198,369), @@ -1014,6 +1014,7 @@ INSERT INTO `rbac_linked_permissions` VALUES (198,759), (198,760), (198,852), +(198,855), (199,217), (199,221), (199,222), @@ -1021,7 +1022,6 @@ INSERT INTO `rbac_linked_permissions` VALUES (199,225), (199,263), (199,496), -(197,501), (199,507), (199,525), (199,534), @@ -1696,6 +1696,7 @@ INSERT INTO `rbac_permissions` VALUES (839,'Command: server shutdown force'), (840,'Command: server restart force'), (841,'Command: debug neargraveyard'), +(843,'Command: reload quest_greeting'), (852,'Command: go offset'), (855,'Command: debug play music'), (856,'Command: npc spawngroup'), @@ -1818,20 +1819,20 @@ INSERT INTO `updates` VALUES ('2017_01_08_00_auth.sql','A68511D0BF94C41F720A11B630CCB36BBEA6B17D','ARCHIVED','2017-01-08 03:21:00',0), ('2017_02_06_00_auth_335.sql','612068198F744892ECC0ACFE3BDCB6D72995916E','ARCHIVED','2017-02-06 00:00:00',0), ('2017_03_17_00_auth.sql','4902E9B1B063F399F928C2DD7AFD60427738E227','ARCHIVED','2017-03-17 18:58:01',0), -('2017_04_19_00_auth.sql','EAE1C1D3AA752259785C056A8F18515E1EF32BC9','RELEASED','2017-04-19 00:07:40',0), -('2017_05_29_00_auth.sql','74BBB703AABD8A6BCB905EA2F5C14A5E26124CDD','RELEASED','2017-05-29 23:16:20',0), -('2017_06_12_00_auth.sql','176532AED785F1F759382C79A28E0FED92E99779','RELEASED','2017-06-12 14:46:29',0), -('2017_06_12_01_auth.sql','6661B4935E101AF188BEBF43203144104E89F8C54','RELEASED','2017-06-12 15:10:00',0), -('2017_06_12_02_auth.sql','166F059E411FAA4901BBBA09A41EF07B1CADC4B6','RELEASED','2017-06-12 16:39:17',0), -('2017_06_17_00_auth.sql','4A172895CB9DA8EFE1270434D6ECB22D4F4DCB17','RELEASED','2017-06-17 01:40:04',0), -('2017_06_28_00_auth.sql','D32EF80F57F629C23395D80F06E91D7E40719F83','RELEASED','2017-06-28 15:23:34',0), -('2017_08_01_00_auth.sql','6ECE808AF52345177189E962C0606B769B6806A6','RELEASED','2017-08-01 01:11:28',0), -('2017_10_13_00_auth.sql','87674E0D166AC60E3725B445714427892E42C6FE','RELEASED','2017-10-13 22:00:22',0), -('2017_10_29_00_auth.sql','0AF3E442B2F312D4F396EC07517B156EF2BFF0F4','RELEASED','2017-10-08 12:30:47',0), -('2017_12_17_00_auth.sql','2CD99730D4D32DBF0584CD5B1AA6F8F4AE3DA975','RELEASED','2017-12-17 03:17:39',0), -('2018_01_03_00_auth_2018_01_02_00_auth.sql','08AF5DAB45515B681B738DA17FA414C7C7CCA44E','RELEASED','2018-01-02 20:40:37',0), -('2018_01_09_00_auth.sql','A5D4EC8FCFAB4F2DCE70EDCAD1ACBFB484FD68D5','RELEASED','2018-01-09 00:00:00',0), -('2018_01_24_00_auth.sql','167B17D8A253D62A8112F8A7EB21C6E99CAEF1E4','RELEASED','2018-01-24 00:00:00',0); +('2017_04_19_00_auth.sql','EAE1C1D3AA752259785C056A8F18515E1EF32BC9','ARCHIVED','2017-04-19 00:07:40',0), +('2017_05_29_00_auth.sql','74BBB703AABD8A6BCB905EA2F5C14A5E26124CDD','ARCHIVED','2017-05-29 23:16:20',0), +('2017_06_12_00_auth.sql','176532AED785F1F759382C79A28E0FED92E99779','ARCHIVED','2017-06-12 14:46:29',0), +('2017_06_12_01_auth.sql','661B4935E101AF188BEBF43203144104E89F8C54','ARCHIVED','2018-02-18 16:25:51',148), +('2017_06_12_02_auth.sql','166F059E411FAA4901BBBA09A41EF07B1CADC4B6','ARCHIVED','2017-06-12 16:39:17',0), +('2017_06_17_00_auth.sql','4A172895CB9DA8EFE1270434D6ECB22D4F4DCB17','ARCHIVED','2017-06-17 01:40:04',0), +('2017_06_28_00_auth.sql','D32EF80F57F629C23395D80F06E91D7E40719F83','ARCHIVED','2017-06-28 15:23:34',0), +('2017_08_01_00_auth.sql','6ECE808AF52345177189E962C0606B769B6806A6','ARCHIVED','2017-08-01 01:11:28',0), +('2017_10_13_00_auth.sql','87674E0D166AC60E3725B445714427892E42C6FE','ARCHIVED','2017-10-13 22:00:22',0), +('2017_10_29_00_auth.sql','F742569F56BB29CE9C8DBBD40A6AB474F846485C','ARCHIVED','2018-02-18 16:25:52',143), +('2017_12_17_00_auth.sql','2CD99730D4D32DBF0584CD5B1AA6F8F4AE3DA975','ARCHIVED','2017-12-17 03:17:39',0), +('2018_01_03_00_auth_2018_01_02_00_auth.sql','08AF5DAB45515B681B738DA17FA414C7C7CCA44E','ARCHIVED','2018-01-02 20:40:37',0), +('2018_01_09_00_auth.sql','A5D4EC8FCFAB4F2DCE70EDCAD1ACBFB484FD68D5','ARCHIVED','2018-01-09 00:00:00',0), +('2018_01_24_00_auth.sql','167B17D8A253D62A8112F8A7EB21C6E99CAEF1E4','ARCHIVED','2018-01-24 00:00:00',0); /*!40000 ALTER TABLE `updates` ENABLE KEYS */; UNLOCK TABLES; @@ -1897,4 +1898,4 @@ UNLOCK TABLES; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2017-04-19 1:08:18 +-- Dump completed on 2018-02-18 19:49:37 diff --git a/sql/base/characters_database.sql b/sql/base/characters_database.sql index 9cc2f556875..278545ee4f5 100644 --- a/sql/base/characters_database.sql +++ b/sql/base/characters_database.sql @@ -189,8 +189,8 @@ DROP TABLE IF EXISTS `auctionbidders`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `auctionbidders` ( - `id` INT(10) unsigned NOT NULL DEFAULT '0', - `bidderguid` INT(10) unsigned NOT NULL DEFAULT '0', + `id` int(10) unsigned NOT NULL DEFAULT '0', + `bidderguid` int(10) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`,`bidderguid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; @@ -2787,4 +2787,4 @@ UNLOCK TABLES; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2017-04-19 1:08:18 +-- Dump completed on 2018-02-18 19:49:38 diff --git a/sql/base/dev/world_database.sql b/sql/base/dev/world_database.sql index a3da3422d07..bcbcdd086f2 100644 --- a/sql/base/dev/world_database.sql +++ b/sql/base/dev/world_database.sql @@ -83,19 +83,35 @@ DROP TABLE IF EXISTS `achievement_reward`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `achievement_reward` ( - `entry` mediumint(8) unsigned NOT NULL DEFAULT '0', - `title_A` mediumint(8) unsigned NOT NULL DEFAULT '0', - `title_H` mediumint(8) unsigned NOT NULL DEFAULT '0', - `item` mediumint(8) unsigned NOT NULL DEFAULT '0', - `sender` mediumint(8) unsigned NOT NULL DEFAULT '0', - `subject` varchar(255) DEFAULT NULL, - `text` text, - `mailTemplate` mediumint(8) unsigned DEFAULT '0', - PRIMARY KEY (`entry`) + `ID` mediumint(8) unsigned NOT NULL DEFAULT '0', + `TitleA` mediumint(8) unsigned NOT NULL DEFAULT '0', + `TitleH` mediumint(8) unsigned NOT NULL DEFAULT '0', + `ItemID` mediumint(8) unsigned NOT NULL DEFAULT '0', + `Sender` mediumint(8) unsigned NOT NULL DEFAULT '0', + `Subject` varchar(255) DEFAULT NULL, + `Text` text, + `MailTemplateID` mediumint(8) unsigned DEFAULT '0', + PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Loot System'; /*!40101 SET character_set_client = @saved_cs_client */; -- +-- Table structure for table `achievement_reward_locale` +-- + +DROP TABLE IF EXISTS `achievement_reward_locale`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `achievement_reward_locale` ( + `ID` mediumint(8) unsigned NOT NULL DEFAULT '0', + `Locale` varchar(4) NOT NULL, + `Subject` text, + `Text` text, + PRIMARY KEY (`ID`,`Locale`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- -- Table structure for table `areatrigger_involvedrelation` -- @@ -224,6 +240,23 @@ CREATE TABLE `broadcast_text` ( /*!40101 SET character_set_client = @saved_cs_client */; -- +-- Table structure for table `broadcast_text_locale` +-- + +DROP TABLE IF EXISTS `broadcast_text_locale`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `broadcast_text_locale` ( + `ID` mediumint(8) unsigned NOT NULL DEFAULT '0', + `locale` varchar(4) NOT NULL, + `MaleText` text, + `FemaleText` text, + `VerifiedBuild` smallint(5) DEFAULT '0', + PRIMARY KEY (`ID`,`locale`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- -- Table structure for table `command` -- @@ -591,6 +624,7 @@ CREATE TABLE `creature_template` ( `movementId` int(11) unsigned NOT NULL DEFAULT '0', `RegenHealth` tinyint(3) unsigned NOT NULL DEFAULT '1', `mechanic_immune_mask` int(10) unsigned NOT NULL DEFAULT '0', + `spell_school_immune_mask` int(3) unsigned NOT NULL DEFAULT '0', `flags_extra` int(10) unsigned NOT NULL DEFAULT '0', `ScriptName` char(64) NOT NULL DEFAULT '', `VerifiedBuild` smallint(5) DEFAULT '0', @@ -643,20 +677,37 @@ DROP TABLE IF EXISTS `creature_text`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `creature_text` ( - `entry` mediumint(8) unsigned NOT NULL DEFAULT '0', - `groupid` tinyint(3) unsigned NOT NULL DEFAULT '0', - `id` tinyint(3) unsigned NOT NULL DEFAULT '0', - `text` longtext, - `type` tinyint(3) unsigned NOT NULL DEFAULT '0', - `language` tinyint(3) unsigned NOT NULL DEFAULT '0', - `probability` float NOT NULL DEFAULT '0', - `emote` mediumint(8) unsigned NOT NULL DEFAULT '0', - `duration` mediumint(8) unsigned NOT NULL DEFAULT '0', - `sound` mediumint(8) unsigned NOT NULL DEFAULT '0', + `CreatureID` mediumint(8) unsigned NOT NULL DEFAULT '0', + `GroupID` tinyint(3) unsigned NOT NULL DEFAULT '0', + `ID` tinyint(3) unsigned NOT NULL DEFAULT '0', + `Text` longtext, + `Type` tinyint(3) unsigned NOT NULL DEFAULT '0', + `Language` tinyint(3) NOT NULL DEFAULT '0', + `Probability` float unsigned NOT NULL DEFAULT '0', + `Emote` mediumint(8) unsigned NOT NULL DEFAULT '0', + `Duration` mediumint(8) unsigned NOT NULL DEFAULT '0', + `Sound` mediumint(8) unsigned NOT NULL DEFAULT '0', `BroadcastTextId` mediumint(6) NOT NULL DEFAULT '0', `TextRange` tinyint(3) unsigned NOT NULL DEFAULT '0', `comment` varchar(255) DEFAULT '', - PRIMARY KEY (`entry`,`groupid`,`id`) + PRIMARY KEY (`CreatureID`,`GroupID`,`ID`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `creature_text_locale` +-- + +DROP TABLE IF EXISTS `creature_text_locale`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `creature_text_locale` ( + `CreatureID` mediumint(8) unsigned NOT NULL DEFAULT '0', + `GroupID` tinyint(3) unsigned NOT NULL DEFAULT '0', + `ID` tinyint(3) unsigned NOT NULL DEFAULT '0', + `Locale` varchar(4) NOT NULL, + `Text` text, + PRIMARY KEY (`CreatureID`,`GroupID`,`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; @@ -766,11 +817,12 @@ DROP TABLE IF EXISTS `game_event`; /*!40101 SET character_set_client = utf8 */; 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', + `start_time` timestamp NULL DEFAULT NULL COMMENT 'Absolute start date, the event will never start before', + `end_time` timestamp NULL DEFAULT NULL COMMENT 'Absolute end date, the event will never start after', `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', `announce` tinyint(3) unsigned DEFAULT '2' COMMENT '0 dont announce, 1 announce, 2 value from config', @@ -1008,7 +1060,7 @@ CREATE TABLE `game_tele` ( `map` smallint(5) unsigned NOT NULL DEFAULT '0', `name` varchar(100) NOT NULL DEFAULT '', PRIMARY KEY (`id`) -) ENGINE=MyISAM AUTO_INCREMENT=1429 DEFAULT CHARSET=utf8 COMMENT='Tele Command'; +) ENGINE=MyISAM AUTO_INCREMENT=1433 DEFAULT CHARSET=utf8 COMMENT='Tele Command'; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -1244,10 +1296,10 @@ DROP TABLE IF EXISTS `gossip_menu`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `gossip_menu` ( - `entry` smallint(5) unsigned NOT NULL DEFAULT '0', - `text_id` mediumint(8) unsigned NOT NULL DEFAULT '0', + `MenuID` smallint(5) unsigned NOT NULL DEFAULT '0', + `TextID` mediumint(8) unsigned NOT NULL DEFAULT '0', `VerifiedBuild` smallint(5) NOT NULL DEFAULT '0', - PRIMARY KEY (`entry`,`text_id`) + PRIMARY KEY (`MenuID`,`TextID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; @@ -1259,21 +1311,38 @@ DROP TABLE IF EXISTS `gossip_menu_option`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `gossip_menu_option` ( - `menu_id` smallint(5) unsigned NOT NULL DEFAULT '0', - `id` smallint(5) unsigned NOT NULL DEFAULT '0', - `option_icon` mediumint(8) unsigned NOT NULL DEFAULT '0', - `option_text` text, + `MenuID` smallint(5) unsigned NOT NULL DEFAULT '0', + `OptionID` smallint(5) unsigned NOT NULL DEFAULT '0', + `OptionIcon` mediumint(8) unsigned NOT NULL DEFAULT '0', + `OptionText` text, `OptionBroadcastTextID` mediumint(6) NOT NULL DEFAULT '0', - `option_id` tinyint(3) unsigned NOT NULL DEFAULT '0', - `npc_option_npcflag` int(10) unsigned NOT NULL DEFAULT '0', - `action_menu_id` int(10) unsigned NOT NULL DEFAULT '0', - `action_poi_id` mediumint(8) unsigned NOT NULL DEFAULT '0', - `box_coded` tinyint(3) unsigned NOT NULL DEFAULT '0', - `box_money` int(10) unsigned NOT NULL DEFAULT '0', - `box_text` text, + `OptionType` tinyint(3) unsigned NOT NULL DEFAULT '0', + `OptionNpcFlag` int(10) unsigned NOT NULL DEFAULT '0', + `ActionMenuID` int(10) unsigned NOT NULL DEFAULT '0', + `ActionPoiID` mediumint(8) unsigned NOT NULL DEFAULT '0', + `BoxCoded` tinyint(3) unsigned NOT NULL DEFAULT '0', + `BoxMoney` int(10) unsigned NOT NULL DEFAULT '0', + `BoxText` text, `BoxBroadcastTextID` mediumint(6) NOT NULL DEFAULT '0', `VerifiedBuild` smallint(5) NOT NULL DEFAULT '0', - PRIMARY KEY (`menu_id`,`id`) + PRIMARY KEY (`MenuID`,`OptionID`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `gossip_menu_option_locale` +-- + +DROP TABLE IF EXISTS `gossip_menu_option_locale`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `gossip_menu_option_locale` ( + `MenuID` smallint(6) unsigned NOT NULL DEFAULT '0', + `OptionID` smallint(6) unsigned NOT NULL DEFAULT '0', + `Locale` varchar(4) NOT NULL, + `OptionText` text, + `BoxText` text, + PRIMARY KEY (`MenuID`,`OptionID`,`Locale`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; @@ -1294,6 +1363,21 @@ CREATE TABLE `graveyard_zone` ( /*!40101 SET character_set_client = @saved_cs_client */; -- +-- Table structure for table `holiday_dates` +-- + +DROP TABLE IF EXISTS `holiday_dates`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `holiday_dates` ( + `id` int(10) unsigned NOT NULL, + `date_id` tinyint(3) unsigned NOT NULL, + `date_value` int(10) unsigned NOT NULL, + PRIMARY KEY (`id`,`date_id`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- -- Table structure for table `instance_encounters` -- @@ -1311,6 +1395,23 @@ CREATE TABLE `instance_encounters` ( /*!40101 SET character_set_client = @saved_cs_client */; -- +-- Table structure for table `instance_spawn_groups` +-- + +DROP TABLE IF EXISTS `instance_spawn_groups`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `instance_spawn_groups` ( + `instanceMapId` smallint(5) unsigned NOT NULL, + `bossStateId` tinyint(3) unsigned NOT NULL, + `bossStates` tinyint(3) unsigned NOT NULL, + `spawnGroupId` int(10) unsigned NOT NULL, + `flags` tinyint(3) unsigned NOT NULL, + PRIMARY KEY (`instanceMapId`,`bossStateId`,`spawnGroupId`,`bossStates`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- -- Table structure for table `instance_template` -- @@ -1380,6 +1481,22 @@ CREATE TABLE `item_set_names` ( /*!40101 SET character_set_client = @saved_cs_client */; -- +-- Table structure for table `item_set_names_locale` +-- + +DROP TABLE IF EXISTS `item_set_names_locale`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `item_set_names_locale` ( + `ID` mediumint(8) unsigned NOT NULL DEFAULT '0', + `locale` varchar(4) NOT NULL, + `Name` text, + `VerifiedBuild` smallint(5) DEFAULT '0', + PRIMARY KEY (`ID`,`locale`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- -- Table structure for table `item_template` -- @@ -1533,6 +1650,23 @@ CREATE TABLE `item_template` ( /*!40101 SET character_set_client = @saved_cs_client */; -- +-- Table structure for table `item_template_locale` +-- + +DROP TABLE IF EXISTS `item_template_locale`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `item_template_locale` ( + `ID` mediumint(8) unsigned NOT NULL DEFAULT '0', + `locale` varchar(4) NOT NULL, + `Name` text, + `Description` text, + `VerifiedBuild` smallint(5) DEFAULT '0', + PRIMARY KEY (`ID`,`locale`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- -- Table structure for table `lfg_dungeon_rewards` -- @@ -1583,413 +1717,6 @@ CREATE TABLE `linked_respawn` ( /*!40101 SET character_set_client = @saved_cs_client */; -- --- Table structure for table `locales_achievement_reward` --- - -DROP TABLE IF EXISTS `locales_achievement_reward`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `locales_achievement_reward` ( - `entry` mediumint(8) unsigned NOT NULL DEFAULT '0', - `subject_loc1` varchar(100) NOT NULL DEFAULT '', - `subject_loc2` varchar(100) NOT NULL DEFAULT '', - `subject_loc3` varchar(100) NOT NULL DEFAULT '', - `subject_loc4` varchar(100) NOT NULL DEFAULT '', - `subject_loc5` varchar(100) NOT NULL DEFAULT '', - `subject_loc6` varchar(100) NOT NULL DEFAULT '', - `subject_loc7` varchar(100) NOT NULL DEFAULT '', - `subject_loc8` varchar(100) NOT NULL DEFAULT '', - `text_loc1` text, - `text_loc2` text, - `text_loc3` text, - `text_loc4` text, - `text_loc5` text, - `text_loc6` text, - `text_loc7` text, - `text_loc8` text, - PRIMARY KEY (`entry`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Table structure for table `locales_broadcast_text` --- - -DROP TABLE IF EXISTS `locales_broadcast_text`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `locales_broadcast_text` ( - `ID` mediumint(8) unsigned NOT NULL DEFAULT '0', - `MaleText_loc1` longtext, - `MaleText_loc2` longtext, - `MaleText_loc3` longtext, - `MaleText_loc4` longtext, - `MaleText_loc5` longtext, - `MaleText_loc6` longtext, - `MaleText_loc7` longtext, - `MaleText_loc8` longtext, - `FemaleText_loc1` longtext, - `FemaleText_loc2` longtext, - `FemaleText_loc3` longtext, - `FemaleText_loc4` longtext, - `FemaleText_loc5` longtext, - `FemaleText_loc6` longtext, - `FemaleText_loc7` longtext, - `FemaleText_loc8` longtext, - `VerifiedBuild` smallint(5) DEFAULT '0', - PRIMARY KEY (`ID`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Table structure for table `locales_creature_text` --- - -DROP TABLE IF EXISTS `locales_creature_text`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `locales_creature_text` ( - `entry` mediumint(8) unsigned NOT NULL DEFAULT '0', - `groupid` tinyint(3) unsigned NOT NULL DEFAULT '0', - `id` tinyint(3) unsigned NOT NULL DEFAULT '0', - `text_loc1` text, - `text_loc2` text, - `text_loc3` text, - `text_loc4` text, - `text_loc5` text, - `text_loc6` text, - `text_loc7` text, - `text_loc8` text, - PRIMARY KEY (`entry`,`groupid`,`id`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Table structure for table `locales_gossip_menu_option` --- - -DROP TABLE IF EXISTS `locales_gossip_menu_option`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `locales_gossip_menu_option` ( - `menu_id` smallint(6) unsigned NOT NULL DEFAULT '0', - `id` smallint(6) unsigned NOT NULL DEFAULT '0', - `option_text_loc1` text, - `option_text_loc2` text, - `option_text_loc3` text, - `option_text_loc4` text, - `option_text_loc5` text, - `option_text_loc6` text, - `option_text_loc7` text, - `option_text_loc8` text, - `box_text_loc1` text, - `box_text_loc2` text, - `box_text_loc3` text, - `box_text_loc4` text, - `box_text_loc5` text, - `box_text_loc6` text, - `box_text_loc7` text, - `box_text_loc8` text, - PRIMARY KEY (`menu_id`,`id`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Table structure for table `locales_item` --- - -DROP TABLE IF EXISTS `locales_item`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `locales_item` ( - `entry` mediumint(8) unsigned NOT NULL DEFAULT '0', - `name_loc1` varchar(100) NOT NULL DEFAULT '', - `name_loc2` varchar(100) NOT NULL DEFAULT '', - `name_loc3` varchar(100) NOT NULL DEFAULT '', - `name_loc4` varchar(100) NOT NULL DEFAULT '', - `name_loc5` varchar(100) NOT NULL DEFAULT '', - `name_loc6` varchar(100) NOT NULL DEFAULT '', - `name_loc7` varchar(100) NOT NULL DEFAULT '', - `name_loc8` varchar(100) NOT NULL DEFAULT '', - `description_loc1` varchar(255) DEFAULT NULL, - `description_loc2` varchar(255) DEFAULT NULL, - `description_loc3` varchar(255) DEFAULT NULL, - `description_loc4` varchar(255) DEFAULT NULL, - `description_loc5` varchar(255) DEFAULT NULL, - `description_loc6` varchar(255) DEFAULT NULL, - `description_loc7` varchar(255) DEFAULT NULL, - `description_loc8` varchar(255) DEFAULT NULL, - `VerifiedBuild` smallint(5) DEFAULT '0', - PRIMARY KEY (`entry`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Table structure for table `locales_item_set_names` --- - -DROP TABLE IF EXISTS `locales_item_set_names`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `locales_item_set_names` ( - `entry` mediumint(8) unsigned NOT NULL DEFAULT '0', - `name_loc1` varchar(100) NOT NULL DEFAULT '', - `name_loc2` varchar(100) NOT NULL DEFAULT '', - `name_loc3` varchar(100) NOT NULL DEFAULT '', - `name_loc4` varchar(100) NOT NULL DEFAULT '', - `name_loc5` varchar(100) NOT NULL DEFAULT '', - `name_loc6` varchar(100) NOT NULL DEFAULT '', - `name_loc7` varchar(100) NOT NULL DEFAULT '', - `name_loc8` varchar(100) NOT NULL DEFAULT '', - `VerifiedBuild` smallint(5) DEFAULT '0', - PRIMARY KEY (`entry`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Table structure for table `locales_npc_text` --- - -DROP TABLE IF EXISTS `locales_npc_text`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `locales_npc_text` ( - `ID` mediumint(8) unsigned NOT NULL DEFAULT '0', - `Text0_0_loc1` longtext, - `Text0_0_loc2` longtext, - `Text0_0_loc3` longtext, - `Text0_0_loc4` longtext, - `Text0_0_loc5` longtext, - `Text0_0_loc6` longtext, - `Text0_0_loc7` longtext, - `Text0_0_loc8` longtext, - `Text0_1_loc1` longtext, - `Text0_1_loc2` longtext, - `Text0_1_loc3` longtext, - `Text0_1_loc4` longtext, - `Text0_1_loc5` longtext, - `Text0_1_loc6` longtext, - `Text0_1_loc7` longtext, - `Text0_1_loc8` longtext, - `Text1_0_loc1` longtext, - `Text1_0_loc2` longtext, - `Text1_0_loc3` longtext, - `Text1_0_loc4` longtext, - `Text1_0_loc5` longtext, - `Text1_0_loc6` longtext, - `Text1_0_loc7` longtext, - `Text1_0_loc8` longtext, - `Text1_1_loc1` longtext, - `Text1_1_loc2` longtext, - `Text1_1_loc3` longtext, - `Text1_1_loc4` longtext, - `Text1_1_loc5` longtext, - `Text1_1_loc6` longtext, - `Text1_1_loc7` longtext, - `Text1_1_loc8` longtext, - `Text2_0_loc1` longtext, - `Text2_0_loc2` longtext, - `Text2_0_loc3` longtext, - `Text2_0_loc4` longtext, - `Text2_0_loc5` longtext, - `Text2_0_loc6` longtext, - `Text2_0_loc7` longtext, - `Text2_0_loc8` longtext, - `Text2_1_loc1` longtext, - `Text2_1_loc2` longtext, - `Text2_1_loc3` longtext, - `Text2_1_loc4` longtext, - `Text2_1_loc5` longtext, - `Text2_1_loc6` longtext, - `Text2_1_loc7` longtext, - `Text2_1_loc8` longtext, - `Text3_0_loc1` longtext, - `Text3_0_loc2` longtext, - `Text3_0_loc3` longtext, - `Text3_0_loc4` longtext, - `Text3_0_loc5` longtext, - `Text3_0_loc6` longtext, - `Text3_0_loc7` longtext, - `Text3_0_loc8` longtext, - `Text3_1_loc1` longtext, - `Text3_1_loc2` longtext, - `Text3_1_loc3` longtext, - `Text3_1_loc4` longtext, - `Text3_1_loc5` longtext, - `Text3_1_loc6` longtext, - `Text3_1_loc7` longtext, - `Text3_1_loc8` longtext, - `Text4_0_loc1` longtext, - `Text4_0_loc2` longtext, - `Text4_0_loc3` longtext, - `Text4_0_loc4` longtext, - `Text4_0_loc5` longtext, - `Text4_0_loc6` longtext, - `Text4_0_loc7` longtext, - `Text4_0_loc8` longtext, - `Text4_1_loc1` longtext, - `Text4_1_loc2` longtext, - `Text4_1_loc3` longtext, - `Text4_1_loc4` longtext, - `Text4_1_loc5` longtext, - `Text4_1_loc6` longtext, - `Text4_1_loc7` longtext, - `Text4_1_loc8` longtext, - `Text5_0_loc1` longtext, - `Text5_0_loc2` longtext, - `Text5_0_loc3` longtext, - `Text5_0_loc4` longtext, - `Text5_0_loc5` longtext, - `Text5_0_loc6` longtext, - `Text5_0_loc7` longtext, - `Text5_0_loc8` longtext, - `Text5_1_loc1` longtext, - `Text5_1_loc2` longtext, - `Text5_1_loc3` longtext, - `Text5_1_loc4` longtext, - `Text5_1_loc5` longtext, - `Text5_1_loc6` longtext, - `Text5_1_loc7` longtext, - `Text5_1_loc8` longtext, - `Text6_0_loc1` longtext, - `Text6_0_loc2` longtext, - `Text6_0_loc3` longtext, - `Text6_0_loc4` longtext, - `Text6_0_loc5` longtext, - `Text6_0_loc6` longtext, - `Text6_0_loc7` longtext, - `Text6_0_loc8` longtext, - `Text6_1_loc1` longtext, - `Text6_1_loc2` longtext, - `Text6_1_loc3` longtext, - `Text6_1_loc4` longtext, - `Text6_1_loc5` longtext, - `Text6_1_loc6` longtext, - `Text6_1_loc7` longtext, - `Text6_1_loc8` longtext, - `Text7_0_loc1` longtext, - `Text7_0_loc2` longtext, - `Text7_0_loc3` longtext, - `Text7_0_loc4` longtext, - `Text7_0_loc5` longtext, - `Text7_0_loc6` longtext, - `Text7_0_loc7` longtext, - `Text7_0_loc8` longtext, - `Text7_1_loc1` longtext, - `Text7_1_loc2` longtext, - `Text7_1_loc3` longtext, - `Text7_1_loc4` longtext, - `Text7_1_loc5` longtext, - `Text7_1_loc6` longtext, - `Text7_1_loc7` longtext, - `Text7_1_loc8` longtext, - PRIMARY KEY (`ID`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Table structure for table `locales_quest` --- - -DROP TABLE IF EXISTS `locales_quest`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `locales_quest` ( - `Id` mediumint(8) unsigned NOT NULL DEFAULT '0', - `Title_loc1` text, - `Title_loc2` text, - `Title_loc3` text, - `Title_loc4` text, - `Title_loc5` text, - `Title_loc6` text, - `Title_loc7` text, - `Title_loc8` text, - `Details_loc1` text, - `Details_loc2` text, - `Details_loc3` text, - `Details_loc4` text, - `Details_loc5` text, - `Details_loc6` text, - `Details_loc7` text, - `Details_loc8` text, - `Objectives_loc1` text, - `Objectives_loc2` text, - `Objectives_loc3` text, - `Objectives_loc4` text, - `Objectives_loc5` text, - `Objectives_loc6` text, - `Objectives_loc7` text, - `Objectives_loc8` text, - `OfferRewardText_loc1` text, - `OfferRewardText_loc2` text, - `OfferRewardText_loc3` text, - `OfferRewardText_loc4` text, - `OfferRewardText_loc5` text, - `OfferRewardText_loc6` text, - `OfferRewardText_loc7` text, - `OfferRewardText_loc8` text, - `RequestItemsText_loc1` text, - `RequestItemsText_loc2` text, - `RequestItemsText_loc3` text, - `RequestItemsText_loc4` text, - `RequestItemsText_loc5` text, - `RequestItemsText_loc6` text, - `RequestItemsText_loc7` text, - `RequestItemsText_loc8` text, - `EndText_loc1` text, - `EndText_loc2` text, - `EndText_loc3` text, - `EndText_loc4` text, - `EndText_loc5` text, - `EndText_loc6` text, - `EndText_loc7` text, - `EndText_loc8` text, - `CompletedText_loc1` text, - `CompletedText_loc2` text, - `CompletedText_loc3` text, - `CompletedText_loc4` text, - `CompletedText_loc5` text, - `CompletedText_loc6` text, - `CompletedText_loc7` text, - `CompletedText_loc8` text, - `ObjectiveText1_loc1` text, - `ObjectiveText1_loc2` text, - `ObjectiveText1_loc3` text, - `ObjectiveText1_loc4` text, - `ObjectiveText1_loc5` text, - `ObjectiveText1_loc6` text, - `ObjectiveText1_loc7` text, - `ObjectiveText1_loc8` text, - `ObjectiveText2_loc1` text, - `ObjectiveText2_loc2` text, - `ObjectiveText2_loc3` text, - `ObjectiveText2_loc4` text, - `ObjectiveText2_loc5` text, - `ObjectiveText2_loc6` text, - `ObjectiveText2_loc7` text, - `ObjectiveText2_loc8` text, - `ObjectiveText3_loc1` text, - `ObjectiveText3_loc2` text, - `ObjectiveText3_loc3` text, - `ObjectiveText3_loc4` text, - `ObjectiveText3_loc5` text, - `ObjectiveText3_loc6` text, - `ObjectiveText3_loc7` text, - `ObjectiveText3_loc8` text, - `ObjectiveText4_loc1` text, - `ObjectiveText4_loc2` text, - `ObjectiveText4_loc3` text, - `ObjectiveText4_loc4` text, - `ObjectiveText4_loc5` text, - `ObjectiveText4_loc6` text, - `ObjectiveText4_loc7` text, - `ObjectiveText4_loc8` text, - `VerifiedBuild` smallint(5) DEFAULT '0', - PRIMARY KEY (`Id`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8; -/*!40101 SET character_set_client = @saved_cs_client */; - --- -- Table structure for table `mail_level_reward` -- @@ -2168,6 +1895,36 @@ CREATE TABLE `npc_text` ( /*!40101 SET character_set_client = @saved_cs_client */; -- +-- Table structure for table `npc_text_locale` +-- + +DROP TABLE IF EXISTS `npc_text_locale`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `npc_text_locale` ( + `ID` mediumint(8) unsigned NOT NULL DEFAULT '0', + `Locale` varchar(4) NOT NULL, + `Text0_0` longtext, + `Text0_1` longtext, + `Text1_0` longtext, + `Text1_1` longtext, + `Text2_0` longtext, + `Text2_1` longtext, + `Text3_0` longtext, + `Text3_1` longtext, + `Text4_0` longtext, + `Text4_1` longtext, + `Text5_0` longtext, + `Text5_1` longtext, + `Text6_0` longtext, + `Text6_1` longtext, + `Text7_0` longtext, + `Text7_1` longtext, + PRIMARY KEY (`ID`,`Locale`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- -- Table structure for table `npc_trainer` -- @@ -2717,6 +2474,41 @@ CREATE TABLE `quest_details` ( /*!40101 SET character_set_client = @saved_cs_client */; -- +-- Table structure for table `quest_greeting` +-- + +DROP TABLE IF EXISTS `quest_greeting`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `quest_greeting` ( + `ID` mediumint(8) unsigned NOT NULL DEFAULT '0', + `Type` tinyint(3) unsigned NOT NULL DEFAULT '0', + `GreetEmoteType` smallint(5) unsigned NOT NULL DEFAULT '0', + `GreetEmoteDelay` int(10) unsigned NOT NULL DEFAULT '0', + `Greeting` text, + `VerifiedBuild` smallint(5) NOT NULL DEFAULT '0', + PRIMARY KEY (`ID`,`Type`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `quest_greeting_locale` +-- + +DROP TABLE IF EXISTS `quest_greeting_locale`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `quest_greeting_locale` ( + `ID` mediumint(8) unsigned NOT NULL DEFAULT '0', + `Type` tinyint(3) unsigned NOT NULL DEFAULT '0', + `locale` varchar(4) NOT NULL, + `Greeting` text, + `VerifiedBuild` smallint(5) DEFAULT '0', + PRIMARY KEY (`ID`,`Type`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- -- Table structure for table `quest_mail_sender` -- @@ -2958,6 +2750,32 @@ CREATE TABLE `quest_template_addon` ( /*!40101 SET character_set_client = @saved_cs_client */; -- +-- Table structure for table `quest_template_locale` +-- + +DROP TABLE IF EXISTS `quest_template_locale`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `quest_template_locale` ( + `ID` mediumint(8) unsigned NOT NULL DEFAULT '0', + `locale` varchar(4) NOT NULL, + `Title` text, + `Details` text, + `Objectives` text, + `OfferRewardText` text, + `RequestItemsText` text, + `EndText` text, + `CompletedText` text, + `ObjectiveText1` text, + `ObjectiveText2` text, + `ObjectiveText3` text, + `ObjectiveText4` text, + `VerifiedBuild` smallint(5) DEFAULT '0', + PRIMARY KEY (`ID`,`locale`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- -- Table structure for table `reference_loot_template` -- @@ -3183,6 +3001,7 @@ CREATE TABLE `smart_scripts` ( `event_param2` int(10) unsigned NOT NULL DEFAULT '0', `event_param3` int(10) unsigned NOT NULL DEFAULT '0', `event_param4` int(10) unsigned NOT NULL DEFAULT '0', + `event_param5` int(10) unsigned NOT NULL DEFAULT '0', `action_type` tinyint(3) unsigned NOT NULL DEFAULT '0', `action_param1` int(10) unsigned NOT NULL DEFAULT '0', `action_param2` int(10) unsigned NOT NULL DEFAULT '0', @@ -3204,6 +3023,36 @@ CREATE TABLE `smart_scripts` ( /*!40101 SET character_set_client = @saved_cs_client */; -- +-- Table structure for table `spawn_group` +-- + +DROP TABLE IF EXISTS `spawn_group`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `spawn_group` ( + `groupId` int(10) unsigned NOT NULL, + `spawnType` tinyint(10) unsigned NOT NULL, + `spawnId` int(10) unsigned NOT NULL, + PRIMARY KEY (`groupId`,`spawnType`,`spawnId`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `spawn_group_template` +-- + +DROP TABLE IF EXISTS `spawn_group_template`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `spawn_group_template` ( + `groupId` int(10) unsigned NOT NULL, + `groupName` varchar(100) NOT NULL, + `groupFlags` int(10) unsigned NOT NULL DEFAULT '0', + PRIMARY KEY (`groupId`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- -- Table structure for table `spell_area` -- @@ -3734,14 +3583,14 @@ CREATE TABLE `vehicle_template_accessory` ( /*!40101 SET character_set_client = @saved_cs_client */; -- --- Temporary table structure for view `version` +-- Table structure for table `version` -- DROP TABLE IF EXISTS `version`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `version` ( - `core_version` varchar(120) NOT NULL DEFAULT '' COMMENT 'Core revision dumped at startup.', + `core_version` varchar(255) NOT NULL DEFAULT '' COMMENT 'Core revision dumped at startup.', `core_revision` varchar(120) DEFAULT NULL, `db_version` varchar(120) DEFAULT NULL COMMENT 'Version of world DB.', `cache_id` int(11) DEFAULT '0', @@ -3842,4 +3691,4 @@ CREATE TABLE `waypoints` ( /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2017-04-19 1:08:19 +-- Dump completed on 2018-02-18 19:49:40 |