aboutsummaryrefslogtreecommitdiff
path: root/sql/base
diff options
context:
space:
mode:
authorNay <dnpd.dd@gmail.com>2012-08-08 03:42:48 +0100
committerNay <dnpd.dd@gmail.com>2012-08-08 03:42:48 +0100
commit7249992e28c6bf322bdfca9c4f037a22a06a3827 (patch)
treee29eb1898021228654bd3cfa7fbe5db82759114e /sql/base
parenta781555f94623072bf61044ee444fbc7a464d12a (diff)
DB: Rename characters' void_storage to character_void_storage
Core: Fix build (/slap subv) Also proper names for sql files
Diffstat (limited to 'sql/base')
-rw-r--r--sql/base/characters_database.sql60
1 files changed, 30 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`
--