diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/base/characters_database.sql | 60 | ||||
| -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.sql | 1 | ||||
| -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 |
