aboutsummaryrefslogtreecommitdiff
path: root/sql/base
diff options
context:
space:
mode:
Diffstat (limited to 'sql/base')
-rw-r--r--sql/base/auth_database.sql51
-rw-r--r--sql/base/characters_database.sql72
-rw-r--r--sql/base/dev/world_database.sql114
3 files changed, 118 insertions, 119 deletions
diff --git a/sql/base/auth_database.sql b/sql/base/auth_database.sql
index ffcd11d5257..61c08d40e26 100644
--- a/sql/base/auth_database.sql
+++ b/sql/base/auth_database.sql
@@ -16,29 +16,6 @@
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
--
--- Table structure for table `secret_digest`
---
-
-DROP TABLE IF EXISTS `secret_digest`;
-/*!40101 SET @saved_cs_client = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
-CREATE TABLE `secret_digest` (
- `id` int(10) unsigned not null,
- `digest` varchar(100) not null,
- PRIMARY KEY (`id`)
-) ENGINE=InnoDB;
-/*!40101 SET character_set_client = @saved_cs_client */;
-
---
--- Dumping data for table `secret_digest`
---
-
-LOCK TABLES `secret_digest` WRITE;
-/*!40000 ALTER TABLE `secret_digest` DISABLE KEYS */;
-/*!40000 ALTER TABLE `secret_digest` ENABLE KEYS */;
-UNLOCK TABLES;
-
---
-- Table structure for table `account`
--
@@ -1756,6 +1733,29 @@ INSERT INTO `realmlist` VALUES
UNLOCK TABLES;
--
+-- Table structure for table `secret_digest`
+--
+
+DROP TABLE IF EXISTS `secret_digest`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `secret_digest` (
+ `id` int(10) unsigned NOT NULL,
+ `digest` varchar(100) NOT NULL,
+ PRIMARY KEY (`id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `secret_digest`
+--
+
+LOCK TABLES `secret_digest` WRITE;
+/*!40000 ALTER TABLE `secret_digest` DISABLE KEYS */;
+/*!40000 ALTER TABLE `secret_digest` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
-- Table structure for table `updates`
--
@@ -1832,7 +1832,8 @@ INSERT INTO `updates` VALUES
('2019_07_16_00_auth.sql','36CB53A9EBD64BFDCF7030083E36E534F1753773','ARCHIVED','2019-07-16 00:00:00',0),
('2019_07_17_00_auth.sql','4F983F039904894ACC483BE885676C5F0A18F06B','ARCHIVED','2019-07-17 00:00:00',0),
('2019_08_10_00_auth.sql','E936802893474BB9B459D01BB5F181F54EDF0653','ARCHIVED','2019-08-10 00:00:00',0),
-('2019_08_10_01_auth.sql','C58357260F0C70DA226A71F7E05DE2C49AAEFD74','ARCHIVED','2019-08-10 00:00:00',0);
+('2019_08_10_01_auth.sql','C58357260F0C70DA226A71F7E05DE2C49AAEFD74','ARCHIVED','2019-08-10 00:00:00',0),
+('2019_08_16_00_auth.sql','99CF9C250EFBBD703DF0A2D1BDEB1E46D1063EE9','ARCHIVED','2019-08-16 06:25:07',0);
/*!40000 ALTER TABLE `updates` ENABLE KEYS */;
UNLOCK TABLES;
@@ -1934,4 +1935,4 @@ SET character_set_client = @saved_cs_client;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
--- Dump completed on 2019-07-15 5:57:44
+-- Dump completed on 2019-08-16 6:25:10
diff --git a/sql/base/characters_database.sql b/sql/base/characters_database.sql
index 668c8adb45f..b786a9e588f 100644
--- a/sql/base/characters_database.sql
+++ b/sql/base/characters_database.sql
@@ -115,29 +115,29 @@ CREATE TABLE `addons` (
LOCK TABLES `addons` WRITE;
/*!40000 ALTER TABLE `addons` DISABLE KEYS */;
INSERT INTO `addons` VALUES
-('Blizzard_AchievementUI', 1276933997),
-('Blizzard_ArenaUI', 1276933997),
-('Blizzard_AuctionUI', 1276933997),
-('Blizzard_BarbershopUI', 1276933997),
-('Blizzard_BattlefieldMinimap', 1276933997),
-('Blizzard_BindingUI', 1276933997),
-('Blizzard_Calendar', 1276933997),
-('Blizzard_CombatLog', 1276933997),
-('Blizzard_CombatText', 1276933997),
-('Blizzard_DebugTools', 1276933997),
-('Blizzard_GlyphUI', 1276933997),
-('Blizzard_GMChatUI', 1276933997),
-('Blizzard_GMSurveyUI', 1276933997),
-('Blizzard_GuildBankUI', 1276933997),
-('Blizzard_InspectUI', 1276933997),
-('Blizzard_ItemSocketingUI', 1276933997),
-('Blizzard_MacroUI', 1276933997),
-('Blizzard_RaidUI', 1276933997),
-('Blizzard_TalentUI', 1276933997),
-('Blizzard_TimeManager', 1276933997),
-('Blizzard_TokenUI', 1276933997),
-('Blizzard_TradeSkillUI', 1276933997),
-('Blizzard_TrainerUI', 1276933997);
+('Blizzard_AchievementUI',1276933997),
+('Blizzard_ArenaUI',1276933997),
+('Blizzard_AuctionUI',1276933997),
+('Blizzard_BarbershopUI',1276933997),
+('Blizzard_BattlefieldMinimap',1276933997),
+('Blizzard_BindingUI',1276933997),
+('Blizzard_Calendar',1276933997),
+('Blizzard_CombatLog',1276933997),
+('Blizzard_CombatText',1276933997),
+('Blizzard_DebugTools',1276933997),
+('Blizzard_GlyphUI',1276933997),
+('Blizzard_GMChatUI',1276933997),
+('Blizzard_GMSurveyUI',1276933997),
+('Blizzard_GuildBankUI',1276933997),
+('Blizzard_InspectUI',1276933997),
+('Blizzard_ItemSocketingUI',1276933997),
+('Blizzard_MacroUI',1276933997),
+('Blizzard_RaidUI',1276933997),
+('Blizzard_TalentUI',1276933997),
+('Blizzard_TimeManager',1276933997),
+('Blizzard_TokenUI',1276933997),
+('Blizzard_TradeSkillUI',1276933997),
+('Blizzard_TrainerUI',1276933997);
/*!40000 ALTER TABLE `addons` ENABLE KEYS */;
UNLOCK TABLES;
@@ -2610,7 +2610,7 @@ INSERT INTO `updates` VALUES
('2015_10_28_00_characters.sql','622A9CA8FCE690429EBE23BA071A37C7A007BF8B','ARCHIVED','2015-10-19 14:32:22',0),
('2015_10_29_00_characters_335.sql','4555A7F35C107E54C13D74D20F141039ED42943E','ARCHIVED','2015-10-29 17:05:43',0),
('2015_11_03_00_characters.sql','CC045717B8FDD9733351E52A5302560CD08AAD57','ARCHIVED','2015-10-12 15:23:33',0),
-('2015_11_07_00_characters.sql','0ACDD35EC9745231BCFA701B78056DEF94D0CC53','ARCHIVED','2016-04-11 00:42:36',94),
+('2015_11_07_00_characters.sql','0ACDD35EC9745231BCFA701B78056DEF94D0CC53','ARCHIVED','2016-04-11 00:42:36',0),
('2016_02_10_00_characters.sql','F1B4DA202819CABC7319A4470A2D224A34609E97','ARCHIVED','2016-02-10 00:00:00',0),
('2016_03_13_2016_01_05_00_characters.sql','0EAD24977F40DE2476B4567DA2B477867CC0DA1A','ARCHIVED','2016-03-13 20:03:56',0),
('2016_04_11_00_characters.sql','0ACDD35EC9745231BCFA701B78056DEF94D0CC53','ARCHIVED','2016-04-11 03:18:17',0),
@@ -2635,8 +2635,8 @@ INSERT INTO `updates` VALUES
('2019_07_14_00_characters.sql','A141F4F15BDF0320483921429871D4C572BD7E2D','ARCHIVED','2019-07-04 00:00:00',0),
('2019_07_15_00_characters.sql','5BCF35896BB36A306CE79CF1E3F1945FAF9019D9','ARCHIVED','2019-07-15 00:00:00',0),
('2019_07_15_01_characters.sql','5D383B026AB9EDE7114F249D206DE7E432E19468','ARCHIVED','2019-07-15 00:00:00',0),
-('2019_07_16_00_characters.sql','76AE193EFA3129FA1702BF7B6FA7C4127B543BDF','ARCHIVED','2019-07-16 00:00:00',0);
-
+('2019_07_16_00_characters.sql','76AE193EFA3129FA1702BF7B6FA7C4127B543BDF','ARCHIVED','2019-07-16 00:00:00',0),
+('2019_08_16_00_characters.sql','7E21060060513C9504107C4A06B106166CC0768E','ARCHIVED','2019-08-16 06:25:07',0);
/*!40000 ALTER TABLE `updates` ENABLE KEYS */;
UNLOCK TABLES;
@@ -2725,11 +2725,11 @@ INSERT INTO `worldstates` VALUES
(11,0,NULL),
(12,0,NULL),
(13,0,NULL),
-(14,1476626581,NULL),
-(15,1476626581,NULL),
+(14,0,NULL),
+(15,0,NULL),
(16,0,NULL),
(17,0,NULL),
-(18,1476626581,NULL),
+(18,0,NULL),
(19,0,NULL),
(20,0,NULL),
(21,0,NULL),
@@ -2738,14 +2738,14 @@ INSERT INTO `worldstates` VALUES
(24,0,NULL),
(25,0,NULL),
(26,0,NULL),
-(27,1476626581,NULL),
+(27,0,NULL),
(28,0,NULL),
(29,0,NULL),
(30,0,NULL),
(31,0,NULL),
(32,0,NULL),
(33,0,NULL),
-(34,1476626581,NULL),
+(34,0,NULL),
(35,0,NULL),
(36,0,NULL),
(37,0,NULL),
@@ -2771,9 +2771,9 @@ INSERT INTO `worldstates` VALUES
(57,0,NULL),
(58,0,NULL),
(59,0,NULL),
-(60,1476626581,NULL),
+(60,0,NULL),
(61,0,NULL),
-(62,1476626581,NULL),
+(62,0,NULL),
(63,0,NULL),
(64,0,NULL),
(65,0,NULL),
@@ -2781,9 +2781,9 @@ INSERT INTO `worldstates` VALUES
(67,0,NULL),
(68,0,NULL),
(69,0,NULL),
-(3781,9000000,NULL),
+(3781,0,NULL),
(3801,0,NULL),
-(3802,1,NULL),
+(3802,0,NULL),
(20001,0,'NextArenaPointDistributionTime'),
(20002,0,'NextWeeklyQuestResetTime'),
(20003,0,'NextBGRandomDailyResetTime'),
@@ -2803,4 +2803,4 @@ UNLOCK TABLES;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
--- Dump completed on 2019-07-15 5:57:44
+-- Dump completed on 2019-08-16 6:25:11
diff --git a/sql/base/dev/world_database.sql b/sql/base/dev/world_database.sql
index 32d12d9dcb5..82243763ca4 100644
--- a/sql/base/dev/world_database.sql
+++ b/sql/base/dev/world_database.sql
@@ -2262,6 +2262,21 @@ CREATE TABLE `player_levelstats` (
/*!40101 SET character_set_client = @saved_cs_client */;
--
+-- Table structure for table `player_totem_model`
+--
+
+DROP TABLE IF EXISTS `player_totem_model`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `player_totem_model` (
+ `TotemSlot` tinyint(3) unsigned NOT NULL,
+ `RaceId` tinyint(3) unsigned NOT NULL,
+ `DisplayId` int(10) unsigned NOT NULL DEFAULT '0',
+ PRIMARY KEY (`TotemSlot`,`RaceId`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
-- Table structure for table `player_xp_for_level`
--
@@ -2415,68 +2430,19 @@ CREATE TABLE `points_of_interest_locale` (
/*!40101 SET character_set_client = @saved_cs_client */;
--
--- Table structure for table `pool_creature`
+-- Table structure for table `pool_members`
--
-DROP TABLE IF EXISTS `pool_creature`;
+DROP TABLE IF EXISTS `pool_members`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
-CREATE TABLE `pool_creature` (
- `guid` int(10) unsigned NOT NULL DEFAULT '0',
- `pool_entry` mediumint(8) unsigned NOT NULL DEFAULT '0',
- `chance` float unsigned NOT NULL DEFAULT '0',
- `description` varchar(255) DEFAULT NULL,
- PRIMARY KEY (`guid`),
- KEY `idx_guid` (`guid`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-/*!40101 SET character_set_client = @saved_cs_client */;
-
---
--- Table structure for table `pool_gameobject`
---
-
-DROP TABLE IF EXISTS `pool_gameobject`;
-/*!40101 SET @saved_cs_client = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
-CREATE TABLE `pool_gameobject` (
- `guid` int(10) unsigned NOT NULL DEFAULT '0',
- `pool_entry` mediumint(8) unsigned NOT NULL DEFAULT '0',
- `chance` float unsigned NOT NULL DEFAULT '0',
- `description` varchar(255) DEFAULT NULL,
- PRIMARY KEY (`guid`),
- KEY `idx_guid` (`guid`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-/*!40101 SET character_set_client = @saved_cs_client */;
-
---
--- Table structure for table `pool_pool`
---
-
-DROP TABLE IF EXISTS `pool_pool`;
-/*!40101 SET @saved_cs_client = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
-CREATE TABLE `pool_pool` (
- `pool_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
- `mother_pool` mediumint(8) unsigned NOT NULL DEFAULT '0',
- `chance` float NOT NULL DEFAULT '0',
- `description` varchar(255) DEFAULT NULL,
- PRIMARY KEY (`pool_id`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-/*!40101 SET character_set_client = @saved_cs_client */;
-
---
--- Table structure for table `pool_quest`
---
-
-DROP TABLE IF EXISTS `pool_quest`;
-/*!40101 SET @saved_cs_client = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
-CREATE TABLE `pool_quest` (
- `entry` int(10) unsigned NOT NULL DEFAULT '0',
- `pool_entry` mediumint(8) unsigned NOT NULL DEFAULT '0',
+CREATE TABLE `pool_members` (
+ `type` smallint(10) unsigned NOT NULL,
+ `spawnId` int(10) unsigned NOT NULL,
+ `poolSpawnId` int(10) unsigned NOT NULL,
+ `chance` double unsigned NOT NULL,
`description` varchar(255) DEFAULT NULL,
- PRIMARY KEY (`entry`),
- KEY `idx_guid` (`entry`)
+ PRIMARY KEY (`type`,`spawnId`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
@@ -2669,6 +2635,37 @@ CREATE TABLE `quest_poi_points` (
/*!40101 SET character_set_client = @saved_cs_client */;
--
+-- Table structure for table `quest_pool_members`
+--
+
+DROP TABLE IF EXISTS `quest_pool_members`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `quest_pool_members` (
+ `questId` int(10) unsigned NOT NULL,
+ `poolId` int(10) unsigned NOT NULL,
+ `poolIndex` tinyint(2) unsigned NOT NULL COMMENT 'Multiple quests with the same index will always spawn together!',
+ `description` varchar(255) DEFAULT NULL,
+ PRIMARY KEY (`questId`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `quest_pool_template`
+--
+
+DROP TABLE IF EXISTS `quest_pool_template`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `quest_pool_template` (
+ `poolId` mediumint(8) unsigned NOT NULL,
+ `numActive` int(10) unsigned NOT NULL COMMENT 'Number of indices to have active at any time',
+ `description` varchar(255) DEFAULT NULL,
+ PRIMARY KEY (`poolId`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
-- Table structure for table `quest_request_items`
--
@@ -2952,6 +2949,7 @@ CREATE TABLE `script_spline_chain_meta` (
`splineId` tinyint(3) unsigned NOT NULL,
`expectedDuration` int(10) unsigned NOT NULL,
`msUntilNext` int(10) unsigned NOT NULL,
+ `velocity` float unsigned DEFAULT '0',
PRIMARY KEY (`entry`,`chainId`,`splineId`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
@@ -3844,4 +3842,4 @@ CREATE TABLE `waypoints` (
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
--- Dump completed on 2019-07-15 5:57:44
+-- Dump completed on 2019-08-16 6:25:11