aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
Diffstat (limited to 'sql')
-rw-r--r--sql/base/characters_database.sql60
-rw-r--r--sql/updates/characters/2012_07_10_00_characters_character_glyphs_434.sql (renamed from sql/updates/characters/2012_07_10_00_characters_character_glyphs.sql)0
-rw-r--r--sql/updates/characters/2012_08_07_00_characters_characters_434.sql (renamed from sql/updates/characters/2012_08_07_00_characters_characters.sql)0
-rw-r--r--sql/updates/characters/2012_08_07_01_characters_void_storage_434.sql1
-rw-r--r--sql/updates/world/2012_08_05_02_world_command_434.sql (renamed from sql/updates/world/2012_08_05_02_world_command.sql)0
-rw-r--r--sql/updates/world/2012_08_06_00_world_classlevelstats_434.sql (renamed from sql/updates/world/2012_08_06_00_world_classlevelstats.sql)0
-rw-r--r--sql/updates/world/2012_08_06_00_world_command_434.sql (renamed from sql/updates/world/2012_08_06_00_world_command.sql)0
-rw-r--r--sql/updates/world/2012_08_06_01_world_classlevelstats_434.sql (renamed from sql/updates/world/2012_08_06_01_world_classlevelstats.sql)0
-rw-r--r--sql/updates/world/2012_08_08_00_world_creature_template_434.sql (renamed from sql/updates/world/2012_08_08_00_world_creature_template.sql)0
9 files changed, 31 insertions, 30 deletions
diff --git a/sql/base/characters_database.sql b/sql/base/characters_database.sql
index e7e68407156..addebff5aa5 100644
--- a/sql/base/characters_database.sql
+++ b/sql/base/characters_database.sql
@@ -1120,6 +1120,36 @@ LOCK TABLES `character_talent` WRITE;
UNLOCK TABLES;
--
+-- Table structure for table `character_void_storage`
+--
+
+DROP TABLE IF EXISTS `character_void_storage`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `character_void_storage` (
+ `itemId` bigint(20) unsigned NOT NULL,
+ `playerGuid` int(10) unsigned NOT NULL,
+ `itemEntry` mediumint(8) unsigned NOT NULL,
+ `slot` tinyint(3) unsigned NOT NULL,
+ `creatorGuid` int(10) unsigned NOT NULL DEFAULT '0',
+ `randomProperty` int(10) unsigned NOT NULL DEFAULT '0',
+ `suffixFactor` int(10) unsigned NOT NULL DEFAULT '0',
+ PRIMARY KEY (`itemId`),
+ UNIQUE KEY `idx_player_slot` (`playerGuid`,`slot`),
+ KEY `idx_player` (`playerGuid`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `character_void_storage`
+--
+
+LOCK TABLES `void_storage` WRITE;
+/*!40000 ALTER TABLE `character_void_storage` DISABLE KEYS */;
+/*!40000 ALTER TABLE `character_void_storage` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
-- Table structure for table `characters`
--
@@ -2266,36 +2296,6 @@ LOCK TABLES `reserved_name` WRITE;
UNLOCK TABLES;
--
--- Table structure for table `void_storage`
---
-
-DROP TABLE IF EXISTS `void_storage`;
-/*!40101 SET @saved_cs_client = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
-CREATE TABLE `void_storage` (
- `itemId` bigint(20) unsigned NOT NULL,
- `playerGuid` int(10) unsigned NOT NULL,
- `itemEntry` mediumint(8) unsigned NOT NULL,
- `slot` tinyint(3) unsigned NOT NULL,
- `creatorGuid` int(10) unsigned NOT NULL DEFAULT '0',
- `randomProperty` int(10) unsigned NOT NULL DEFAULT '0',
- `suffixFactor` int(10) unsigned NOT NULL DEFAULT '0',
- PRIMARY KEY (`itemId`),
- UNIQUE KEY `idx_player_slot` (`playerGuid`,`slot`),
- KEY `idx_player` (`playerGuid`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-/*!40101 SET character_set_client = @saved_cs_client */;
-
---
--- Dumping data for table `void_storage`
---
-
-LOCK TABLES `void_storage` WRITE;
-/*!40000 ALTER TABLE `void_storage` DISABLE KEYS */;
-/*!40000 ALTER TABLE `void_storage` ENABLE KEYS */;
-UNLOCK TABLES;
-
---
-- Table structure for table `warden_action`
--
diff --git a/sql/updates/characters/2012_07_10_00_characters_character_glyphs.sql b/sql/updates/characters/2012_07_10_00_characters_character_glyphs_434.sql
index b8aba4d7798..b8aba4d7798 100644
--- a/sql/updates/characters/2012_07_10_00_characters_character_glyphs.sql
+++ b/sql/updates/characters/2012_07_10_00_characters_character_glyphs_434.sql
diff --git a/sql/updates/characters/2012_08_07_00_characters_characters.sql b/sql/updates/characters/2012_08_07_00_characters_characters_434.sql
index e9bea82ad4b..e9bea82ad4b 100644
--- a/sql/updates/characters/2012_08_07_00_characters_characters.sql
+++ b/sql/updates/characters/2012_08_07_00_characters_characters_434.sql
diff --git a/sql/updates/characters/2012_08_07_01_characters_void_storage_434.sql b/sql/updates/characters/2012_08_07_01_characters_void_storage_434.sql
new file mode 100644
index 00000000000..8a68ba3740d
--- /dev/null
+++ b/sql/updates/characters/2012_08_07_01_characters_void_storage_434.sql
@@ -0,0 +1 @@
+RENAME TABLE `void_storage` TO `character_void_storage`;
diff --git a/sql/updates/world/2012_08_05_02_world_command.sql b/sql/updates/world/2012_08_05_02_world_command_434.sql
index 69fd621c457..69fd621c457 100644
--- a/sql/updates/world/2012_08_05_02_world_command.sql
+++ b/sql/updates/world/2012_08_05_02_world_command_434.sql
diff --git a/sql/updates/world/2012_08_06_00_world_classlevelstats.sql b/sql/updates/world/2012_08_06_00_world_classlevelstats_434.sql
index e6038374508..e6038374508 100644
--- a/sql/updates/world/2012_08_06_00_world_classlevelstats.sql
+++ b/sql/updates/world/2012_08_06_00_world_classlevelstats_434.sql
diff --git a/sql/updates/world/2012_08_06_00_world_command.sql b/sql/updates/world/2012_08_06_00_world_command_434.sql
index 50628aaa589..50628aaa589 100644
--- a/sql/updates/world/2012_08_06_00_world_command.sql
+++ b/sql/updates/world/2012_08_06_00_world_command_434.sql
diff --git a/sql/updates/world/2012_08_06_01_world_classlevelstats.sql b/sql/updates/world/2012_08_06_01_world_classlevelstats_434.sql
index 6fe7ad67994..6fe7ad67994 100644
--- a/sql/updates/world/2012_08_06_01_world_classlevelstats.sql
+++ b/sql/updates/world/2012_08_06_01_world_classlevelstats_434.sql
diff --git a/sql/updates/world/2012_08_08_00_world_creature_template.sql b/sql/updates/world/2012_08_08_00_world_creature_template_434.sql
index 1e934b9f612..1e934b9f612 100644
--- a/sql/updates/world/2012_08_08_00_world_creature_template.sql
+++ b/sql/updates/world/2012_08_08_00_world_creature_template_434.sql