diff options
| author | Nay <dnpd.dd@gmail.com> | 2012-08-08 03:42:48 +0100 |
|---|---|---|
| committer | Nay <dnpd.dd@gmail.com> | 2012-08-08 03:42:48 +0100 |
| commit | 7249992e28c6bf322bdfca9c4f037a22a06a3827 (patch) | |
| tree | e29eb1898021228654bd3cfa7fbe5db82759114e /sql/base | |
| parent | a781555f94623072bf61044ee444fbc7a464d12a (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.sql | 60 |
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` -- |
