aboutsummaryrefslogtreecommitdiff
path: root/sql/base
diff options
context:
space:
mode:
Diffstat (limited to 'sql/base')
-rw-r--r--sql/base/auth_database.sql14
-rw-r--r--sql/base/characters_database.sql113
2 files changed, 104 insertions, 23 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 bbd5a70e933..21d61d6796c 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
@@ -624,6 +624,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 +741,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 +1060,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 +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 `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 +1160,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) NOT NULL DEFAULT '',
+ `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 +1187,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 +1199,12 @@ 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',
+ `conquestPoints` 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 +1213,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 +1261,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',
@@ -1568,6 +1594,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`
--
@@ -1739,6 +1816,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`)
@@ -1993,8 +2074,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`)
@@ -2276,4 +2357,4 @@ UNLOCK TABLES;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
--- Dump completed on 2012-03-25 21:14:19
+-- Dump completed on 2012-08-08 18:51:30