diff options
Diffstat (limited to 'sql/base')
| -rw-r--r-- | sql/base/auth_database.sql | 14 | ||||
| -rw-r--r-- | sql/base/characters_database.sql | 261 |
2 files changed, 251 insertions, 24 deletions
diff --git a/sql/base/auth_database.sql b/sql/base/auth_database.sql index a052a74c837..b9b9491b721 100644 --- a/sql/base/auth_database.sql +++ b/sql/base/auth_database.sql @@ -1,8 +1,8 @@ --- MySQL dump 10.13 Distrib 5.5.22, for Win64 (x86) +-- MySQL dump 10.13 Distrib 5.5.21, for Win64 (x86) -- --- Host: localhost Database: auth +-- Host: localhost Database: auth_4x -- ------------------------------------------------------ --- Server version 5.5.22 +-- Server version 5.5.21 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; @@ -36,7 +36,7 @@ CREATE TABLE `account` ( `locked` tinyint(3) unsigned NOT NULL DEFAULT '0', `last_login` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00', `online` tinyint(3) unsigned NOT NULL DEFAULT '0', - `expansion` tinyint(3) unsigned NOT NULL DEFAULT '2', + `expansion` tinyint(3) unsigned NOT NULL DEFAULT '3', `mutetime` bigint(20) NOT NULL DEFAULT '0', `locale` tinyint(3) unsigned NOT NULL DEFAULT '0', `os` varchar(3) NOT NULL DEFAULT '', @@ -199,7 +199,7 @@ CREATE TABLE `realmlist` ( `timezone` tinyint(3) unsigned NOT NULL DEFAULT '0', `allowedSecurityLevel` tinyint(3) unsigned NOT NULL DEFAULT '0', `population` float unsigned NOT NULL DEFAULT '0', - `gamebuild` int(10) unsigned NOT NULL DEFAULT '12340', + `gamebuild` int(10) unsigned NOT NULL DEFAULT '15595', PRIMARY KEY (`id`), UNIQUE KEY `idx_name` (`name`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='Realm System'; @@ -211,7 +211,7 @@ CREATE TABLE `realmlist` ( LOCK TABLES `realmlist` WRITE; /*!40000 ALTER TABLE `realmlist` DISABLE KEYS */; -INSERT INTO `realmlist` VALUES (1,'Trinity','127.0.0.1',8085,1,0,1,0,0,12340); +INSERT INTO `realmlist` VALUES (1,'Trinity','127.0.0.1',8085,1,0,1,0,0,15595); /*!40000 ALTER TABLE `realmlist` ENABLE KEYS */; UNLOCK TABLES; @@ -250,4 +250,4 @@ UNLOCK TABLES; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2012-03-28 18:26:06 +-- Dump completed on 2012-08-08 19:01:34 diff --git a/sql/base/characters_database.sql b/sql/base/characters_database.sql index 4a2d2951da3..a184e1f8a29 100644 --- a/sql/base/characters_database.sql +++ b/sql/base/characters_database.sql @@ -1,6 +1,6 @@ -- MySQL dump 10.13 Distrib 5.5.21, for Win64 (x86) -- --- Host: localhost Database: characters +-- Host: localhost Database: characters_4x -- ------------------------------------------------------ -- Server version 5.5.21 @@ -508,6 +508,67 @@ LOCK TABLES `character_battleground_random` WRITE; UNLOCK TABLES; -- +-- Table structure for table `character_cuf_profiles` +-- + +DROP TABLE IF EXISTS `character_cuf_profiles`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `character_cuf_profiles` ( + `guid` int(10) unsigned NOT NULL COMMENT 'Character Guid', + `id` tinyint(3) unsigned NOT NULL COMMENT 'Profile Id (0-4)', + `name` varchar(12) NOT NULL COMMENT 'Profile Name', + `frameHeight` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Profile Frame Height', + `frameWidth` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Profile Frame Width', + `sortBy` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'Frame Sort By', + `healthText` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'Frame Health Text', + `boolOptions` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Many Configurable Bool Options', + `unk146` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'Profile Unk Int8', + `unk147` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'Profile Unk Int8', + `unk148` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'Profile Unk Int8', + `unk150` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Profile Unk Int16', + `unk152` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Profile Unk Int16', + `unk154` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Profile Unk Int16', + PRIMARY KEY (`guid`,`id`), + KEY `index` (`id`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Dumping data for table `character_cuf_profiles` +-- + +LOCK TABLES `character_cuf_profiles` WRITE; +/*!40000 ALTER TABLE `character_cuf_profiles` DISABLE KEYS */; +/*!40000 ALTER TABLE `character_cuf_profiles` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `character_currency` +-- + +DROP TABLE IF EXISTS `character_currency`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `character_currency` ( + `guid` int(10) unsigned NOT NULL, + `currency` smallint(5) unsigned NOT NULL, + `total_count` int(10) unsigned NOT NULL, + `week_count` int(10) unsigned NOT NULL, + PRIMARY KEY (`guid`,`currency`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Dumping data for table `character_currency` +-- + +LOCK TABLES `character_currency` WRITE; +/*!40000 ALTER TABLE `character_currency` DISABLE KEYS */; +/*!40000 ALTER TABLE `character_currency` ENABLE KEYS */; +UNLOCK TABLES; + +-- -- Table structure for table `character_declinedname` -- @@ -624,6 +685,9 @@ CREATE TABLE `character_glyphs` ( `glyph4` smallint(5) unsigned DEFAULT '0', `glyph5` smallint(5) unsigned DEFAULT '0', `glyph6` smallint(5) unsigned DEFAULT '0', + `glyph7` smallint(5) unsigned DEFAULT '0', + `glyph8` smallint(5) unsigned DEFAULT '0', + `glyph9` smallint(5) unsigned DEFAULT '0', PRIMARY KEY (`guid`,`spec`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; @@ -738,7 +802,6 @@ CREATE TABLE `character_pet` ( `slot` tinyint(3) unsigned NOT NULL DEFAULT '0', `curhealth` int(10) unsigned NOT NULL DEFAULT '1', `curmana` int(10) unsigned NOT NULL DEFAULT '0', - `curhappiness` int(10) unsigned NOT NULL DEFAULT '0', `savetime` int(10) unsigned NOT NULL DEFAULT '0', `abdata` text, PRIMARY KEY (`id`), @@ -1058,8 +1121,6 @@ CREATE TABLE `character_stats` ( `maxpower3` int(10) unsigned NOT NULL DEFAULT '0', `maxpower4` int(10) unsigned NOT NULL DEFAULT '0', `maxpower5` int(10) unsigned NOT NULL DEFAULT '0', - `maxpower6` int(10) unsigned NOT NULL DEFAULT '0', - `maxpower7` int(10) unsigned NOT NULL DEFAULT '0', `strength` int(10) unsigned NOT NULL DEFAULT '0', `agility` int(10) unsigned NOT NULL DEFAULT '0', `stamina` int(10) unsigned NOT NULL DEFAULT '0', @@ -1120,6 +1181,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 `character_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` -- @@ -1130,12 +1221,13 @@ CREATE TABLE `characters` ( `guid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier', `account` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Account Identifier', `name` varchar(12) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, + `slot` tinyint(3) unsigned NOT NULL DEFAULT '0', `race` tinyint(3) unsigned NOT NULL DEFAULT '0', `class` tinyint(3) unsigned NOT NULL DEFAULT '0', `gender` tinyint(3) unsigned NOT NULL DEFAULT '0', `level` tinyint(3) unsigned NOT NULL DEFAULT '0', `xp` int(10) unsigned NOT NULL DEFAULT '0', - `money` int(10) unsigned NOT NULL DEFAULT '0', + `money` bigint(20) unsigned NOT NULL DEFAULT '0', `playerBytes` int(10) unsigned NOT NULL DEFAULT '0', `playerBytes2` int(10) unsigned NOT NULL DEFAULT '0', `playerFlags` int(10) unsigned NOT NULL DEFAULT '0', @@ -1156,6 +1248,7 @@ CREATE TABLE `characters` ( `rest_bonus` float NOT NULL DEFAULT '0', `resettalents_cost` int(10) unsigned NOT NULL DEFAULT '0', `resettalents_time` int(10) unsigned NOT NULL DEFAULT '0', + `talentTree` varchar(10) NOT NULL DEFAULT '0 0', `trans_x` float NOT NULL DEFAULT '0', `trans_y` float NOT NULL DEFAULT '0', `trans_z` float NOT NULL DEFAULT '0', @@ -1167,15 +1260,10 @@ CREATE TABLE `characters` ( `zone` smallint(5) unsigned NOT NULL DEFAULT '0', `death_expire_time` int(10) unsigned NOT NULL DEFAULT '0', `taxi_path` text, - `arenaPoints` int(10) unsigned NOT NULL DEFAULT '0', - `totalHonorPoints` int(10) unsigned NOT NULL DEFAULT '0', - `todayHonorPoints` int(10) unsigned NOT NULL DEFAULT '0', - `yesterdayHonorPoints` int(10) unsigned NOT NULL DEFAULT '0', `totalKills` int(10) unsigned NOT NULL DEFAULT '0', `todayKills` smallint(5) unsigned NOT NULL DEFAULT '0', `yesterdayKills` smallint(5) unsigned NOT NULL DEFAULT '0', `chosenTitle` int(10) unsigned NOT NULL DEFAULT '0', - `knownCurrencies` bigint(20) unsigned NOT NULL DEFAULT '0', `watchedFaction` int(10) unsigned NOT NULL DEFAULT '0', `drunk` tinyint(3) unsigned NOT NULL DEFAULT '0', `health` int(10) unsigned NOT NULL DEFAULT '0', @@ -1184,17 +1272,15 @@ CREATE TABLE `characters` ( `power3` int(10) unsigned NOT NULL DEFAULT '0', `power4` int(10) unsigned NOT NULL DEFAULT '0', `power5` int(10) unsigned NOT NULL DEFAULT '0', - `power6` int(10) unsigned NOT NULL DEFAULT '0', - `power7` int(10) unsigned NOT NULL DEFAULT '0', `latency` mediumint(8) unsigned NOT NULL DEFAULT '0', `speccount` tinyint(3) unsigned NOT NULL DEFAULT '1', `activespec` tinyint(3) unsigned NOT NULL DEFAULT '0', `exploredZones` longtext, `equipmentCache` longtext, - `ammoId` int(10) unsigned NOT NULL DEFAULT '0', `knownTitles` longtext, `actionBars` tinyint(3) unsigned NOT NULL DEFAULT '0', `grantableLevels` tinyint(3) unsigned NOT NULL DEFAULT '0', + `guildId` int(10) unsigned NOT NULL DEFAULT '0', `deleteInfos_Account` int(10) unsigned DEFAULT NULL, `deleteInfos_Name` varchar(12) DEFAULT NULL, `deleteDate` int(10) unsigned DEFAULT NULL, @@ -1234,7 +1320,6 @@ CREATE TABLE `corpse` ( `itemCache` text NOT NULL, `bytes1` int(10) unsigned NOT NULL DEFAULT '0', `bytes2` int(10) unsigned NOT NULL DEFAULT '0', - `guildId` int(10) unsigned NOT NULL DEFAULT '0', `flags` tinyint(3) unsigned NOT NULL DEFAULT '0', `dynFlags` tinyint(3) unsigned NOT NULL DEFAULT '0', `time` int(10) unsigned NOT NULL DEFAULT '0', @@ -1556,6 +1641,9 @@ CREATE TABLE `guild` ( `motd` varchar(128) NOT NULL DEFAULT '', `createdate` int(10) unsigned NOT NULL DEFAULT '0', `BankMoney` bigint(20) unsigned NOT NULL DEFAULT '0', + `level` int(10) unsigned DEFAULT '1', + `experience` bigint(20) unsigned DEFAULT '0', + `todayExperience` bigint(20) unsigned DEFAULT '0', PRIMARY KEY (`guildid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Guild System'; /*!40101 SET character_set_client = @saved_cs_client */; @@ -1570,6 +1658,57 @@ LOCK TABLES `guild` WRITE; UNLOCK TABLES; -- +-- Table structure for table `guild_achievement` +-- + +DROP TABLE IF EXISTS `guild_achievement`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `guild_achievement` ( + `guildId` int(10) unsigned NOT NULL, + `achievement` smallint(5) unsigned NOT NULL, + `date` int(10) unsigned NOT NULL DEFAULT '0', + `guids` text NOT NULL, + PRIMARY KEY (`guildId`,`achievement`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Dumping data for table `guild_achievement` +-- + +LOCK TABLES `guild_achievement` WRITE; +/*!40000 ALTER TABLE `guild_achievement` DISABLE KEYS */; +/*!40000 ALTER TABLE `guild_achievement` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `guild_achievement_progress` +-- + +DROP TABLE IF EXISTS `guild_achievement_progress`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `guild_achievement_progress` ( + `guildId` int(10) unsigned NOT NULL, + `criteria` smallint(5) unsigned NOT NULL, + `counter` int(10) unsigned NOT NULL, + `date` int(10) unsigned NOT NULL DEFAULT '0', + `completedGuid` int(10) unsigned NOT NULL DEFAULT '0', + PRIMARY KEY (`guildId`,`criteria`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Dumping data for table `guild_achievement_progress` +-- + +LOCK TABLES `guild_achievement_progress` WRITE; +/*!40000 ALTER TABLE `guild_achievement_progress` DISABLE KEYS */; +/*!40000 ALTER TABLE `guild_achievement_progress` ENABLE KEYS */; +UNLOCK TABLES; + +-- -- Table structure for table `guild_bank_eventlog` -- @@ -1715,6 +1854,62 @@ LOCK TABLES `guild_eventlog` WRITE; UNLOCK TABLES; -- +-- Table structure for table `guild_finder_applicant` +-- + +DROP TABLE IF EXISTS `guild_finder_applicant`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `guild_finder_applicant` ( + `guildId` int(10) unsigned DEFAULT NULL, + `playerGuid` int(10) unsigned DEFAULT NULL, + `availability` tinyint(3) unsigned DEFAULT '0', + `classRole` tinyint(3) unsigned DEFAULT '0', + `interests` tinyint(3) unsigned DEFAULT '0', + `comment` varchar(255) DEFAULT NULL, + `submitTime` int(10) unsigned DEFAULT NULL, + UNIQUE KEY `guildId` (`guildId`,`playerGuid`) +) ENGINE=InnoDB DEFAULT CHARSET=latin1; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Dumping data for table `guild_finder_applicant` +-- + +LOCK TABLES `guild_finder_applicant` WRITE; +/*!40000 ALTER TABLE `guild_finder_applicant` DISABLE KEYS */; +/*!40000 ALTER TABLE `guild_finder_applicant` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `guild_finder_guild_settings` +-- + +DROP TABLE IF EXISTS `guild_finder_guild_settings`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `guild_finder_guild_settings` ( + `guildId` int(10) unsigned NOT NULL, + `availability` tinyint(3) unsigned NOT NULL DEFAULT '0', + `classRoles` tinyint(3) unsigned NOT NULL DEFAULT '0', + `interests` tinyint(3) unsigned NOT NULL DEFAULT '0', + `level` tinyint(3) unsigned NOT NULL DEFAULT '1', + `listed` tinyint(3) unsigned NOT NULL DEFAULT '0', + `comment` varchar(255) DEFAULT NULL, + PRIMARY KEY (`guildId`) +) ENGINE=InnoDB DEFAULT CHARSET=latin1; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Dumping data for table `guild_finder_guild_settings` +-- + +LOCK TABLES `guild_finder_guild_settings` WRITE; +/*!40000 ALTER TABLE `guild_finder_guild_settings` DISABLE KEYS */; +/*!40000 ALTER TABLE `guild_finder_guild_settings` ENABLE KEYS */; +UNLOCK TABLES; + +-- -- Table structure for table `guild_member` -- @@ -1741,6 +1936,10 @@ CREATE TABLE `guild_member` ( `BankRemSlotsTab4` int(10) unsigned NOT NULL DEFAULT '0', `BankResetTimeTab5` int(10) unsigned NOT NULL DEFAULT '0', `BankRemSlotsTab5` int(10) unsigned NOT NULL DEFAULT '0', + `BankResetTimeTab6` int(10) unsigned NOT NULL DEFAULT '0', + `BankRemSlotsTab6` int(10) unsigned NOT NULL DEFAULT '0', + `BankResetTimeTab7` int(10) unsigned NOT NULL DEFAULT '0', + `BankRemSlotsTab7` int(10) unsigned NOT NULL DEFAULT '0', UNIQUE KEY `guid_key` (`guid`), KEY `guildid_key` (`guildid`), KEY `guildid_rank_key` (`guildid`,`rank`) @@ -1757,6 +1956,34 @@ LOCK TABLES `guild_member` WRITE; UNLOCK TABLES; -- +-- Table structure for table `guild_news_log` +-- + +DROP TABLE IF EXISTS `guild_news_log`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `guild_news_log` ( + `guild` int(10) unsigned NOT NULL, + `id` int(10) unsigned NOT NULL, + `eventType` int(10) unsigned NOT NULL, + `playerGuid` bigint(20) unsigned NOT NULL, + `data` int(10) unsigned NOT NULL, + `flags` int(10) unsigned NOT NULL, + `date` int(10) unsigned NOT NULL DEFAULT '0', + PRIMARY KEY (`guild`,`id`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Dumping data for table `guild_news_log` +-- + +LOCK TABLES `guild_news_log` WRITE; +/*!40000 ALTER TABLE `guild_news_log` DISABLE KEYS */; +/*!40000 ALTER TABLE `guild_news_log` ENABLE KEYS */; +UNLOCK TABLES; + +-- -- Table structure for table `guild_rank` -- @@ -1995,8 +2222,8 @@ CREATE TABLE `mail` ( `has_items` tinyint(3) unsigned NOT NULL DEFAULT '0', `expire_time` int(10) unsigned NOT NULL DEFAULT '0', `deliver_time` int(10) unsigned NOT NULL DEFAULT '0', - `money` int(10) unsigned NOT NULL DEFAULT '0', - `cod` int(10) unsigned NOT NULL DEFAULT '0', + `money` bigint(20) unsigned NOT NULL DEFAULT '0', + `cod` bigint(20) unsigned NOT NULL DEFAULT '0', `checked` tinyint(3) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `idx_receiver` (`receiver`) @@ -2278,4 +2505,4 @@ UNLOCK TABLES; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2012-09-08 15:27:29 +-- Dump completed on 2012-09-10 11:54:51 |