From f736567a374e718574763f545b9cdea5d97d9ce0 Mon Sep 17 00:00:00 2001 From: Neo2003 Date: Thu, 9 Oct 2008 08:42:22 -0500 Subject: [svn] * Updated to 6743 and 685 Moved language id used by Arena to a higher place to solve conflicts Added the empty script folders --HG-- branch : trunk rename : 6731-680 => 6743-685 --- sql/characters.sql | 2478 ++++++++++++------------- sql/mangos.sql | 58 +- sql/updates/10_instantiated_battlegrounds.sql | 35 +- sql/updates/19_pack.sql | 4 - 4 files changed, 1297 insertions(+), 1278 deletions(-) delete mode 100644 sql/updates/19_pack.sql (limited to 'sql') diff --git a/sql/characters.sql b/sql/characters.sql index f42dfe764de..f695ac2fc55 100644 --- a/sql/characters.sql +++ b/sql/characters.sql @@ -1,1239 +1,1239 @@ --- MySQL dump 10.11 --- --- Host: localhost Database: characters --- ------------------------------------------------------ --- Server version 5.0.45-Debian_1ubuntu3.1-log - -/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; -/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; -/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; -/*!40101 SET NAMES utf8 */; -/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; -/*!40103 SET TIME_ZONE='+00:00' */; -/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; -/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; -/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; -/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; - --- --- Table structure for table `arena_team` --- - -DROP TABLE IF EXISTS `arena_team`; -CREATE TABLE `arena_team` ( - `arenateamid` int(10) unsigned NOT NULL default '0', - `name` char(255) NOT NULL, - `captainguid` int(10) unsigned NOT NULL default '0', - `type` tinyint(3) unsigned NOT NULL default '0', - `BackgroundColor` int(10) unsigned NOT NULL default '0', - `EmblemStyle` int(10) unsigned NOT NULL default '0', - `EmblemColor` int(10) unsigned NOT NULL default '0', - `BorderStyle` int(10) unsigned NOT NULL default '0', - `BorderColor` int(10) unsigned NOT NULL default '0', - PRIMARY KEY (`arenateamid`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; - --- --- Dumping data for table `arena_team` --- - -LOCK TABLES `arena_team` WRITE; -/*!40000 ALTER TABLE `arena_team` DISABLE KEYS */; -/*!40000 ALTER TABLE `arena_team` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `arena_team_member` --- - -DROP TABLE IF EXISTS `arena_team_member`; -CREATE TABLE `arena_team_member` ( - `arenateamid` int(10) unsigned NOT NULL default '0', - `guid` int(10) unsigned NOT NULL default '0', - `played_week` int(10) unsigned NOT NULL default '0', - `wons_week` int(10) unsigned NOT NULL default '0', - `played_season` int(10) unsigned NOT NULL default '0', - `wons_season` int(10) unsigned NOT NULL default '0', - `points_to_add` int(10) unsigned NOT NULL default '0' -) ENGINE=InnoDB DEFAULT CHARSET=utf8; - --- --- Dumping data for table `arena_team_member` --- - -LOCK TABLES `arena_team_member` WRITE; -/*!40000 ALTER TABLE `arena_team_member` DISABLE KEYS */; -/*!40000 ALTER TABLE `arena_team_member` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `arena_team_stats` --- - -DROP TABLE IF EXISTS `arena_team_stats`; -CREATE TABLE `arena_team_stats` ( - `arenateamid` int(10) unsigned NOT NULL default '0', - `rating` int(10) unsigned NOT NULL default '0', - `games` int(10) unsigned NOT NULL default '0', - `wins` int(10) unsigned NOT NULL default '0', - `played` int(10) unsigned NOT NULL default '0', - `wins2` int(10) unsigned NOT NULL default '0', - `rank` int(10) unsigned NOT NULL default '0', - PRIMARY KEY (`arenateamid`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; - --- --- Dumping data for table `arena_team_stats` --- - -LOCK TABLES `arena_team_stats` WRITE; -/*!40000 ALTER TABLE `arena_team_stats` DISABLE KEYS */; -/*!40000 ALTER TABLE `arena_team_stats` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `auctionhouse` --- - -DROP TABLE IF EXISTS `auctionhouse`; -CREATE TABLE `auctionhouse` ( - `id` int(11) unsigned NOT NULL default '0', - `auctioneerguid` int(11) unsigned NOT NULL default '0', - `itemguid` int(11) unsigned NOT NULL default '0', - `item_template` int(11) unsigned NOT NULL default '0' COMMENT 'Item Identifier', - `itemowner` int(11) unsigned NOT NULL default '0', - `buyoutprice` int(11) NOT NULL default '0', - `time` bigint(40) NOT NULL default '0', - `buyguid` int(11) unsigned NOT NULL default '0', - `lastbid` int(11) NOT NULL default '0', - `startbid` int(11) NOT NULL default '0', - `deposit` int(11) NOT NULL default '0', - `location` tinyint(3) unsigned NOT NULL default '3', - PRIMARY KEY (`id`), - UNIQUE KEY `item_guid` (`itemguid`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; - --- --- Dumping data for table `auctionhouse` --- - -LOCK TABLES `auctionhouse` WRITE; -/*!40000 ALTER TABLE `auctionhouse` DISABLE KEYS */; -/*!40000 ALTER TABLE `auctionhouse` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `bugreport` --- - -DROP TABLE IF EXISTS `bugreport`; -CREATE TABLE `bugreport` ( - `id` int(11) NOT NULL auto_increment COMMENT 'Identifier', - `type` varchar(255) NOT NULL default '', - `content` varchar(255) NOT NULL default '', - PRIMARY KEY (`id`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Debug System'; - --- --- Dumping data for table `bugreport` --- - -LOCK TABLES `bugreport` WRITE; -/*!40000 ALTER TABLE `bugreport` DISABLE KEYS */; -/*!40000 ALTER TABLE `bugreport` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `characters` --- - -DROP TABLE IF EXISTS `characters`; -CREATE TABLE `characters` ( - `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier', - `account` int(11) unsigned NOT NULL default '0' COMMENT 'Account Identifier', - `data` longtext, - `name` varchar(12) NOT NULL default '', - `race` tinyint(3) unsigned NOT NULL default '0', - `class` tinyint(3) unsigned NOT NULL default '0', - `position_x` float NOT NULL default '0', - `position_y` float NOT NULL default '0', - `position_z` float NOT NULL default '0', - `map` int(11) unsigned NOT NULL default '0' COMMENT 'Map Identifier', - `dungeon_difficulty` tinyint(1) unsigned NOT NULL DEFAULT '0', - `orientation` float NOT NULL default '0', - `taximask` longtext, - `online` tinyint(3) unsigned NOT NULL default '0', - `cinematic` tinyint(3) unsigned NOT NULL default '0', - `totaltime` int(11) unsigned NOT NULL default '0', - `leveltime` int(11) unsigned NOT NULL default '0', - `logout_time` bigint(20) unsigned NOT NULL default '0', - `is_logout_resting` tinyint(3) unsigned NOT NULL default '0', - `rest_bonus` float NOT NULL default '0', - `resettalents_cost` int(11) unsigned NOT NULL default '0', - `resettalents_time` bigint(20) unsigned NOT NULL default '0', - `trans_x` float NOT NULL default '0', - `trans_y` float NOT NULL default '0', - `trans_z` float NOT NULL default '0', - `trans_o` float NOT NULL default '0', - `transguid` bigint(20) unsigned NOT NULL default '0', - `gmstate` tinyint(3) unsigned NOT NULL default '0', - `stable_slots` tinyint(1) unsigned NOT NULL default '0', - `at_login` int(11) unsigned NOT NULL default '0', - `zone` int(11) unsigned NOT NULL default '0', - `death_expire_time` bigint(20) unsigned NOT NULL default '0', - `taxi_path` text, - PRIMARY KEY (`guid`), - KEY `idx_account` (`account`), - KEY `idx_online` (`online`), - KEY `idx_name` (`name`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System'; - --- --- Dumping data for table `characters` --- - -LOCK TABLES `characters` WRITE; -/*!40000 ALTER TABLE `characters` DISABLE KEYS */; -/*!40000 ALTER TABLE `characters` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `character_action` --- - -DROP TABLE IF EXISTS `character_action`; -CREATE TABLE `character_action` ( - `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier', - `button` tinyint(3) unsigned NOT NULL default '0', - `action` smallint(5) unsigned NOT NULL default '0', - `type` tinyint(3) unsigned NOT NULL default '0', - `misc` tinyint(3) unsigned NOT NULL default '0', - PRIMARY KEY (`guid`,`button`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System'; - --- --- Dumping data for table `character_action` --- - -LOCK TABLES `character_action` WRITE; -/*!40000 ALTER TABLE `character_action` DISABLE KEYS */; -/*!40000 ALTER TABLE `character_action` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `character_aura` --- - -DROP TABLE IF EXISTS `character_aura`; -CREATE TABLE `character_aura` ( - `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier', - `caster_guid` bigint(20) unsigned NOT NULL default '0' COMMENT 'Full Global Unique Identifier', - `spell` int(11) unsigned NOT NULL default '0', - `effect_index` int(11) unsigned NOT NULL default '0', - `amount` int(11) NOT NULL default '0', - `maxduration` int(11) NOT NULL default '0', - `remaintime` int(11) NOT NULL default '0', - `remaincharges` int(11) NOT NULL default '0', - PRIMARY KEY (`guid`,`spell`,`effect_index`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System'; - --- --- Dumping data for table `character_aura` --- - -LOCK TABLES `character_aura` WRITE; -/*!40000 ALTER TABLE `character_aura` DISABLE KEYS */; -/*!40000 ALTER TABLE `character_aura` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `character_declinedname` --- - -DROP TABLE IF EXISTS `character_declinedname`; -CREATE TABLE `character_declinedname` ( - `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier', - `genitive` varchar(15) NOT NULL default '', - `dative` varchar(15) NOT NULL default '', - `accusative` varchar(15) NOT NULL default '', - `instrumental` varchar(15) NOT NULL default '', - `prepositional` varchar(15) NOT NULL default '', - PRIMARY KEY (`guid`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC; - --- --- Dumping data for table `character_declinedname` --- - -LOCK TABLES `character_declinedname` WRITE; -/*!40000 ALTER TABLE `character_declinedname` DISABLE KEYS */; -/*!40000 ALTER TABLE `character_declinedname` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `character_gifts` --- - -DROP TABLE IF EXISTS `character_gifts`; -CREATE TABLE `character_gifts` ( - `guid` int(20) unsigned NOT NULL default '0', - `item_guid` int(11) unsigned NOT NULL default '0', - `entry` int(20) unsigned NOT NULL default '0', - `flags` int(20) unsigned NOT NULL default '0', - PRIMARY KEY (`item_guid`), - KEY `idx_guid` (`guid`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; - --- --- Dumping data for table `character_gifts` --- - -LOCK TABLES `character_gifts` WRITE; -/*!40000 ALTER TABLE `character_gifts` DISABLE KEYS */; -/*!40000 ALTER TABLE `character_gifts` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `character_homebind` --- - -DROP TABLE IF EXISTS `character_homebind`; -CREATE TABLE `character_homebind` ( - `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier', - `map` int(11) unsigned NOT NULL default '0' COMMENT 'Map Identifier', - `zone` int(11) unsigned NOT NULL default '0' COMMENT 'Zone Identifier', - `position_x` float NOT NULL default '0', - `position_y` float NOT NULL default '0', - `position_z` float NOT NULL default '0', - PRIMARY KEY (`guid`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System'; - --- --- Dumping data for table `character_homebind` --- - -LOCK TABLES `character_homebind` WRITE; -/*!40000 ALTER TABLE `character_homebind` DISABLE KEYS */; -/*!40000 ALTER TABLE `character_homebind` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `character_instance` --- - -DROP TABLE IF EXISTS `character_instance`; -CREATE TABLE `character_instance` ( - `guid` int(11) unsigned NOT NULL default '0', - `instance` int(11) unsigned NOT NULL default '0', - `permanent` tinyint(1) unsigned NOT NULL default '0', - PRIMARY KEY (`guid`,`instance`), - KEY `instance` (`instance`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; - --- --- Dumping data for table `character_instance` --- - -LOCK TABLES `character_instance` WRITE; -/*!40000 ALTER TABLE `character_instance` DISABLE KEYS */; -/*!40000 ALTER TABLE `character_instance` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `character_inventory` --- - -DROP TABLE IF EXISTS `character_inventory`; -CREATE TABLE `character_inventory` ( - `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier', - `bag` int(11) unsigned NOT NULL default '0', - `slot` tinyint(3) unsigned NOT NULL default '0', - `item` int(11) unsigned NOT NULL default '0' COMMENT 'Item Global Unique Identifier', - `item_template` int(11) unsigned NOT NULL default '0' COMMENT 'Item Identifier', - PRIMARY KEY (`item`), - KEY `idx_guid` (`guid`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System'; - --- --- Dumping data for table `character_inventory` --- - -LOCK TABLES `character_inventory` WRITE; -/*!40000 ALTER TABLE `character_inventory` DISABLE KEYS */; -/*!40000 ALTER TABLE `character_inventory` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `character_pet` --- - -DROP TABLE IF EXISTS `character_pet`; -CREATE TABLE `character_pet` ( - `id` int(11) unsigned NOT NULL default '0', - `entry` int(11) unsigned NOT NULL default '0', - `owner` int(11) unsigned NOT NULL default '0', - `modelid` int(11) unsigned default '0', - `CreatedBySpell` int(11) unsigned NOT NULL default '0', - `PetType` tinyint(3) unsigned NOT NULL default '0', - `level` int(11) unsigned NOT NULL default '1', - `exp` int(11) unsigned NOT NULL default '0', - `Reactstate` tinyint(1) unsigned NOT NULL default '0', - `loyaltypoints` int(11) NOT NULL default '0', - `loyalty` int(11) unsigned NOT NULL default '0', - `trainpoint` int(11) NOT NULL default '0', - `name` varchar(100) default 'Pet', - `renamed` tinyint(1) unsigned NOT NULL default '0', - `slot` int(11) unsigned NOT NULL default '0', - `curhealth` int(11) unsigned NOT NULL default '1', - `curmana` int(11) unsigned NOT NULL default '0', - `curhappiness` int(11) unsigned NOT NULL default '0', - `savetime` bigint(20) unsigned NOT NULL default '0', - `resettalents_cost` int(11) unsigned NOT NULL default '0', - `resettalents_time` bigint(20) unsigned NOT NULL default '0', - `abdata` longtext, - `teachspelldata` longtext, - PRIMARY KEY (`id`), - KEY `owner` (`owner`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Pet System'; - --- --- Dumping data for table `character_pet` --- - -LOCK TABLES `character_pet` WRITE; -/*!40000 ALTER TABLE `character_pet` DISABLE KEYS */; -/*!40000 ALTER TABLE `character_pet` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `character_pet_declinedname` --- - -DROP TABLE IF EXISTS `character_pet_declinedname`; -CREATE TABLE `character_pet_declinedname` ( - `id` int(11) unsigned NOT NULL default '0', - `owner` int(11) unsigned NOT NULL default '0', - `genitive` varchar(12) NOT NULL default '', - `dative` varchar(12) NOT NULL default '', - `accusative` varchar(12) NOT NULL default '', - `instrumental` varchar(12) NOT NULL default '', - `prepositional` varchar(12) NOT NULL default '', - PRIMARY KEY (`id`), - KEY owner_key (`owner`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC; - --- --- Dumping data for table `character_pet_declinedname` --- - -LOCK TABLES `character_pet_declinedname` WRITE; -/*!40000 ALTER TABLE `character_pet_declinedname` DISABLE KEYS */; -/*!40000 ALTER TABLE `character_pet_declinedname` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `character_queststatus` --- - -DROP TABLE IF EXISTS `character_queststatus`; -CREATE TABLE `character_queststatus` ( - `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier', - `quest` int(11) unsigned NOT NULL default '0' COMMENT 'Quest Identifier', - `status` int(11) unsigned NOT NULL default '0', - `rewarded` tinyint(1) unsigned NOT NULL default '0', - `explored` tinyint(1) unsigned NOT NULL default '0', - `timer` bigint(20) unsigned NOT NULL default '0', - `mobcount1` int(11) unsigned NOT NULL default '0', - `mobcount2` int(11) unsigned NOT NULL default '0', - `mobcount3` int(11) unsigned NOT NULL default '0', - `mobcount4` int(11) unsigned NOT NULL default '0', - `itemcount1` int(11) unsigned NOT NULL default '0', - `itemcount2` int(11) unsigned NOT NULL default '0', - `itemcount3` int(11) unsigned NOT NULL default '0', - `itemcount4` int(11) unsigned NOT NULL default '0', - PRIMARY KEY (`guid`,`quest`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System'; - --- --- Dumping data for table `character_queststatus` --- - -LOCK TABLES `character_queststatus` WRITE; -/*!40000 ALTER TABLE `character_queststatus` DISABLE KEYS */; -/*!40000 ALTER TABLE `character_queststatus` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `character_queststatus_daily` --- - -DROP TABLE IF EXISTS `character_queststatus_daily`; -CREATE TABLE `character_queststatus_daily` ( - `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier', - `quest` int(11) unsigned NOT NULL default '0' COMMENT 'Quest Identifier', - `time` bigint(20) unsigned NOT NULL default '0', - PRIMARY KEY (`guid`,`quest`), - KEY `idx_guid` (`guid`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System'; - --- --- Dumping data for table `character_queststatus_daily` --- - -LOCK TABLES `character_queststatus_daily` WRITE; -/*!40000 ALTER TABLE `character_queststatus_daily` DISABLE KEYS */; -/*!40000 ALTER TABLE `character_queststatus_daily` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `character_reputation` --- - -DROP TABLE IF EXISTS `character_reputation`; -CREATE TABLE `character_reputation` ( - `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier', - `faction` int(11) unsigned NOT NULL default '0', - `standing` int(11) NOT NULL default '0', - `flags` int(11) NOT NULL default '0', - PRIMARY KEY (`guid`,`faction`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System'; - --- --- Dumping data for table `character_reputation` --- - -LOCK TABLES `character_reputation` WRITE; -/*!40000 ALTER TABLE `character_reputation` DISABLE KEYS */; -/*!40000 ALTER TABLE `character_reputation` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `character_social` --- - -DROP TABLE IF EXISTS `character_social`; -CREATE TABLE `character_social` ( - `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Character Global Unique Identifier', - `friend` int(11) unsigned NOT NULL default '0' COMMENT 'Friend Global Unique Identifier', - `flags` tinyint(1) unsigned NOT NULL default '0' COMMENT 'Friend Flags', - `note` varchar(48) NOT NULL DEFAULT '' COMMENT 'Friend Note', - PRIMARY KEY (`guid`,`friend`,`flags`), - KEY `guid` (`guid`), - KEY `friend` (`friend`), - KEY `guid_flags` (`guid`,`flags`), - KEY `friend_flags` (`friend`,`flags`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System'; - --- --- Dumping data for table `character_social` --- - -LOCK TABLES `character_social` WRITE; -/*!40000 ALTER TABLE `character_social` DISABLE KEYS */; -/*!40000 ALTER TABLE `character_social` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `character_spell` --- - -DROP TABLE IF EXISTS `character_spell`; -CREATE TABLE `character_spell` ( - `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier', - `spell` int(11) unsigned NOT NULL default '0' COMMENT 'Spell Identifier', - `slot` int(11) unsigned NOT NULL default '0', - `active` tinyint(3) unsigned NOT NULL default '1', - `disabled` tinyint(3) unsigned NOT NULL default '0', - PRIMARY KEY (`guid`,`spell`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System'; - --- --- Dumping data for table `character_spell` --- - -LOCK TABLES `character_spell` WRITE; -/*!40000 ALTER TABLE `character_spell` DISABLE KEYS */; -/*!40000 ALTER TABLE `character_spell` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `character_spell_cooldown` --- - -DROP TABLE IF EXISTS `character_spell_cooldown`; -CREATE TABLE `character_spell_cooldown` ( - `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier, Low part', - `spell` int(11) unsigned NOT NULL default '0' COMMENT 'Spell Identifier', - `item` int(11) unsigned NOT NULL default '0' COMMENT 'Item Identifier', - `time` bigint(20) unsigned NOT NULL default '0', - PRIMARY KEY (`guid`,`spell`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; - --- --- Dumping data for table `character_spell_cooldown` --- - -LOCK TABLES `character_spell_cooldown` WRITE; -/*!40000 ALTER TABLE `character_spell_cooldown` DISABLE KEYS */; -/*!40000 ALTER TABLE `character_spell_cooldown` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `character_ticket` --- - -DROP TABLE IF EXISTS `character_ticket`; -CREATE TABLE `character_ticket` ( - `ticket_id` int(11) unsigned NOT NULL auto_increment, - `guid` int(11) unsigned NOT NULL default '0', - `ticket_text` text, - `ticket_lastchange` TIMESTAMP ON UPDATE CURRENT_TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, - PRIMARY KEY (`ticket_id`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System'; - --- --- Dumping data for table `character_ticket` --- - -LOCK TABLES `character_ticket` WRITE; -/*!40000 ALTER TABLE `character_ticket` DISABLE KEYS */; -/*!40000 ALTER TABLE `character_ticket` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `character_tutorial` --- - -DROP TABLE IF EXISTS `character_tutorial`; -CREATE TABLE `character_tutorial` ( - `account` bigint(20) unsigned NOT NULL auto_increment COMMENT 'Account Identifier', - `realmid` int(11) unsigned NOT NULL default '0' COMMENT 'Realm Identifier', - `tut0` int(11) unsigned NOT NULL default '0', - `tut1` int(11) unsigned NOT NULL default '0', - `tut2` int(11) unsigned NOT NULL default '0', - `tut3` int(11) unsigned NOT NULL default '0', - `tut4` int(11) unsigned NOT NULL default '0', - `tut5` int(11) unsigned NOT NULL default '0', - `tut6` int(11) unsigned NOT NULL default '0', - `tut7` int(11) unsigned NOT NULL default '0', - PRIMARY KEY (`account`,`realmid`), - KEY acc_key (`account`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System'; - --- --- Dumping data for table `character_tutorial` --- - -LOCK TABLES `character_tutorial` WRITE; -/*!40000 ALTER TABLE `character_tutorial` DISABLE KEYS */; -/*!40000 ALTER TABLE `character_tutorial` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `corpse` --- - -DROP TABLE IF EXISTS `corpse`; -CREATE TABLE `corpse` ( - `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier', - `player` int(11) unsigned NOT NULL default '0' COMMENT 'Character Global Unique Identifier', - `position_x` float NOT NULL default '0', - `position_y` float NOT NULL default '0', - `position_z` float NOT NULL default '0', - `orientation` float NOT NULL default '0', - `zone` int(11) unsigned NOT NULL default '38' COMMENT 'Zone Identifier', - `map` int(11) unsigned NOT NULL default '0' COMMENT 'Map Identifier', - `data` longtext, - `time` bigint(20) unsigned NOT NULL default '0', - `corpse_type` tinyint(3) unsigned NOT NULL default '0', - `instance` int(11) unsigned NOT NULL default '0', - PRIMARY KEY (`guid`), - KEY `idx_type` (`corpse_type`), - KEY `instance` (`instance`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Death System'; - --- --- Dumping data for table `corpse` --- - -LOCK TABLES `corpse` WRITE; -/*!40000 ALTER TABLE `corpse` DISABLE KEYS */; -/*!40000 ALTER TABLE `corpse` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `groups` --- - -DROP TABLE IF EXISTS `groups`; -CREATE TABLE `groups` ( - `leaderGuid` int(11) unsigned NOT NULL, - `mainTank` int(11) unsigned NOT NULL, - `mainAssistant` int(11) unsigned NOT NULL, - `lootMethod` tinyint(4) unsigned NOT NULL, - `looterGuid` int(11) unsigned NOT NULL, - `lootThreshold` tinyint(4) unsigned NOT NULL, - `icon1` int(11) unsigned NOT NULL, - `icon2` int(11) unsigned NOT NULL, - `icon3` int(11) unsigned NOT NULL, - `icon4` int(11) unsigned NOT NULL, - `icon5` int(11) unsigned NOT NULL, - `icon6` int(11) unsigned NOT NULL, - `icon7` int(11) unsigned NOT NULL, - `icon8` int(11) unsigned NOT NULL, - `isRaid` tinyint(1) unsigned NOT NULL, - `difficulty` tinyint(3) unsigned NOT NULL default '0', - PRIMARY KEY (`leaderGuid`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Groups'; - --- --- Dumping data for table `groups` --- - -LOCK TABLES `groups` WRITE; -/*!40000 ALTER TABLE `groups` DISABLE KEYS */; -/*!40000 ALTER TABLE `groups` ENABLE KEYS */; -UNLOCK TABLES; - --- ---------------------------- --- Table structure for group_instance --- ---------------------------- -DROP TABLE IF EXISTS `group_instance`; -CREATE TABLE `group_instance` ( - `leaderGuid` int(11) unsigned NOT NULL default '0', - `instance` int(11) unsigned NOT NULL default '0', - `permanent` tinyint(1) unsigned NOT NULL default '0', - PRIMARY KEY (`leaderGuid`,`instance`), - KEY `instance` (`instance`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; - --- --- Dumping data for table `group_instance` --- - -LOCK TABLES `group_instance` WRITE; -/*!40000 ALTER TABLE `group_instance` DISABLE KEYS */; -/*!40000 ALTER TABLE `group_instance` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `group_member` --- - -DROP TABLE IF EXISTS `group_member`; -CREATE TABLE `group_member` ( - `leaderGuid` int(11) unsigned NOT NULL, - `memberGuid` int(11) unsigned NOT NULL, - `assistant` tinyint(1) unsigned NOT NULL, - `subgroup` smallint(6) unsigned NOT NULL, - PRIMARY KEY (`leaderGuid`,`memberGuid`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Groups'; - --- --- Dumping data for table `group_member` --- - -LOCK TABLES `group_member` WRITE; -/*!40000 ALTER TABLE `group_member` DISABLE KEYS */; -/*!40000 ALTER TABLE `group_member` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `guild` --- - -DROP TABLE IF EXISTS `guild`; -CREATE TABLE `guild` ( - `guildid` int(6) unsigned NOT NULL default '0', - `name` varchar(255) NOT NULL default '', - `leaderguid` int(6) unsigned NOT NULL default '0', - `EmblemStyle` int(5) NOT NULL default '0', - `EmblemColor` int(5) NOT NULL default '0', - `BorderStyle` int(5) NOT NULL default '0', - `BorderColor` int(5) NOT NULL default '0', - `BackgroundColor` int(5) NOT NULL default '0', - `info` text NOT NULL, - `motd` varchar(255) NOT NULL default '', - `createdate` datetime default NULL, - `BankMoney` bigint(20) NOT NULL default '0', - PRIMARY KEY (`guildid`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Guild System'; - --- --- Dumping data for table `guild` --- - -LOCK TABLES `guild` WRITE; -/*!40000 ALTER TABLE `guild` DISABLE KEYS */; -/*!40000 ALTER TABLE `guild` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `guild_bank_eventlog` --- - -DROP TABLE IF EXISTS `guild_bank_eventlog`; -CREATE TABLE `guild_bank_eventlog` ( - `guildid` int(11) unsigned NOT NULL default '0', - `LogGuid` int(11) unsigned NOT NULL default '0', - `LogEntry` tinyint(1) unsigned NOT NULL default '0', - `TabId` tinyint(1) unsigned NOT NULL default '0', - `PlayerGuid` int(11) unsigned NOT NULL default '0', - `ItemOrMoney` int(11) unsigned NOT NULL default '0', - `ItemStackCount` tinyint(3) unsigned NOT NULL default '0', - `DestTabId` tinyint(1) unsigned NOT NULL default '0', - `TimeStamp` bigint(20) unsigned NOT NULL default '0', - PRIMARY KEY (`guildid`,`LogGuid`), - KEY `guildid_key` (`guildid`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; - --- --- Dumping data for table `guild_bank_eventlog` --- - -LOCK TABLES `guild_bank_eventlog` WRITE; -/*!40000 ALTER TABLE `guild_bank_eventlog` DISABLE KEYS */; -/*!40000 ALTER TABLE `guild_bank_eventlog` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `guild_bank_item` --- - -DROP TABLE IF EXISTS `guild_bank_item`; -CREATE TABLE `guild_bank_item` ( - `guildid` int(11) unsigned NOT NULL default '0', - `TabId` tinyint(1) unsigned NOT NULL default '0', - `SlotId` tinyint(3) unsigned NOT NULL default '0', - `item_guid` int(11) unsigned NOT NULL default '0', - `item_entry` int(11) unsigned NOT NULL default '0', - PRIMARY KEY (`guildid`,`tabid`,`slotid`), - KEY `guildid_key` (`guildid`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; - --- --- Dumping data for table `guild_bank_item` --- - -LOCK TABLES `guild_bank_item` WRITE; -/*!40000 ALTER TABLE `guild_bank_item` DISABLE KEYS */; -/*!40000 ALTER TABLE `guild_bank_item` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `guild_bank_right` --- - -DROP TABLE IF EXISTS `guild_bank_right`; -CREATE TABLE `guild_bank_right` ( - `guildid` int(11) unsigned NOT NULL default '0', - `TabId` tinyint(1) unsigned NOT NULL default '0', - `rid` int(11) unsigned NOT NULL default '0', - `gbright` tinyint(3) unsigned NOT NULL default '0', - `SlotPerDay` int(11) unsigned NOT NULL default '0', - PRIMARY KEY (`guildid`,`TabId`,`rid`), - KEY `guildid_key` (`guildid`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; - --- --- Dumping data for table `guild_bank_right` --- - -LOCK TABLES `guild_bank_right` WRITE; -/*!40000 ALTER TABLE `guild_bank_right` DISABLE KEYS */; -/*!40000 ALTER TABLE `guild_bank_right` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `guild_bank_tab` --- - -DROP TABLE IF EXISTS `guild_bank_tab`; -CREATE TABLE `guild_bank_tab` ( - `guildid` int(11) unsigned NOT NULL default '0', - `TabId` tinyint(1) unsigned NOT NULL default '0', - `TabName` varchar(100) NOT NULL default '', - `TabIcon` varchar(100) NOT NULL default '', - `TabText` varchar(500) NOT NULL default '', - PRIMARY KEY (`guildid`,`TabId`), - KEY `guildid_key` (`guildid`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; - --- --- Dumping data for table `guild_bank_tab` --- - -LOCK TABLES `guild_bank_tab` WRITE; -/*!40000 ALTER TABLE `guild_bank_tab` DISABLE KEYS */; -/*!40000 ALTER TABLE `guild_bank_tab` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `guild_eventlog` --- - -DROP TABLE IF EXISTS `guild_eventlog`; -CREATE TABLE `guild_eventlog` ( - `guildid` int(11) NOT NULL COMMENT 'Guild Identificator', - `LogGuid` int(11) NOT NULL COMMENT 'Log entry identificator', - `EventType` tinyint(1) NOT NULL COMMENT 'Event type', - `PlayerGuid1` int(11) NOT NULL COMMENT 'Player 1', - `PlayerGuid2` int(11) NOT NULL COMMENT 'Player 2', - `NewRank` tinyint(2) NOT NULL COMMENT 'New rank(in case promotion/demotion)', - `TimeStamp` bigint(20) NOT NULL COMMENT 'Event UNIX time' -) ENGINE = InnoDB DEFAULT CHARSET = latin1 COMMENT 'Guild Eventlog'; - --- --- Dumping data for table `guild_eventlog` --- - -LOCK TABLES `guild_eventlog` WRITE; -/*!40000 ALTER TABLE `guild_eventlog` DISABLE KEYS */; -/*!40000 ALTER TABLE `guild_eventlog` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `guild_member` --- - -DROP TABLE IF EXISTS `guild_member`; -CREATE TABLE `guild_member` ( - `guildid` int(6) unsigned NOT NULL default '0', - `guid` int(11) unsigned NOT NULL default '0', - `rank` tinyint(2) unsigned NOT NULL default '0', - `pnote` varchar(255) NOT NULL default '', - `offnote` varchar(255) NOT NULL default '', - `BankResetTimeMoney` int(11) unsigned NOT NULL default '0', - `BankRemMoney` int(11) unsigned NOT NULL default '0', - `BankResetTimeTab0` int(11) unsigned NOT NULL default '0', - `BankRemSlotsTab0` int(11) unsigned NOT NULL default '0', - `BankResetTimeTab1` int(11) unsigned NOT NULL default '0', - `BankRemSlotsTab1` int(11) unsigned NOT NULL default '0', - `BankResetTimeTab2` int(11) unsigned NOT NULL default '0', - `BankRemSlotsTab2` int(11) unsigned NOT NULL default '0', - `BankResetTimeTab3` int(11) unsigned NOT NULL default '0', - `BankRemSlotsTab3` int(11) unsigned NOT NULL default '0', - `BankResetTimeTab4` int(11) unsigned NOT NULL default '0', - `BankRemSlotsTab4` int(11) unsigned NOT NULL default '0', - `BankResetTimeTab5` int(11) unsigned NOT NULL default '0', - `BankRemSlotsTab5` int(11) unsigned NOT NULL default '0', - KEY `guildid_key` (`guildid`), - KEY `guildid_rank_key` (`guildid`,`rank`), - KEY `guid_key` (`guid`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Guild System'; - --- --- Dumping data for table `guild_member` --- - -LOCK TABLES `guild_member` WRITE; -/*!40000 ALTER TABLE `guild_member` DISABLE KEYS */; -/*!40000 ALTER TABLE `guild_member` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `guild_rank` --- - -DROP TABLE IF EXISTS `guild_rank`; -CREATE TABLE `guild_rank` ( - `guildid` int(6) unsigned NOT NULL default '0', - `rid` int(11) unsigned NOT NULL, - `rname` varchar(255) NOT NULL default '', - `rights` int(3) unsigned NOT NULL default '0', - `BankMoneyPerDay` int(11) unsigned NOT NULL default '0', - PRIMARY KEY (`guildid`,`rid`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Guild System'; - --- --- Dumping data for table `guild_rank` --- - -LOCK TABLES `guild_rank` WRITE; -/*!40000 ALTER TABLE `guild_rank` DISABLE KEYS */; -/*!40000 ALTER TABLE `guild_rank` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `instance` --- - -DROP TABLE IF EXISTS `instance`; -CREATE TABLE `instance` ( - `id` int(11) unsigned NOT NULL default '0', - `map` int(11) unsigned NOT NULL default '0', - `resettime` bigint(40) NOT NULL default '0', - `difficulty` tinyint(1) unsigned NOT NULL default '0', - `data` longtext, - PRIMARY KEY (`id`), - KEY `map` (`map`), - KEY `resettime` (`resettime`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; - --- --- Dumping data for table `instance` --- - -LOCK TABLES `instance` WRITE; -/*!40000 ALTER TABLE `instance` DISABLE KEYS */; -/*!40000 ALTER TABLE `instance` ENABLE KEYS */; -UNLOCK TABLES; - --- ---------------------------- --- Table structure for instance_reset --- ---------------------------- -DROP TABLE IF EXISTS `instance_reset`; -CREATE TABLE `instance_reset` ( - `mapid` int(11) unsigned NOT NULL default '0', - `resettime` bigint(40) NOT NULL default '0', - PRIMARY KEY (`mapid`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; - --- --- Dumping data for table `instance_reset` --- - -LOCK TABLES `instance_reset` WRITE; -/*!40000 ALTER TABLE `instance_reset` DISABLE KEYS */; -/*!40000 ALTER TABLE `instance_reset` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `item_instance` --- - -DROP TABLE IF EXISTS `item_instance`; -CREATE TABLE `item_instance` ( - `guid` int(11) unsigned NOT NULL default '0', - `owner_guid` int(11) unsigned NOT NULL default '0', - `data` longtext, - PRIMARY KEY (`guid`), - KEY `idx_owner_guid` (`owner_guid`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Item System'; - --- --- Dumping data for table `item_instance` --- - -LOCK TABLES `item_instance` WRITE; -/*!40000 ALTER TABLE `item_instance` DISABLE KEYS */; -/*!40000 ALTER TABLE `item_instance` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `item_text` --- - -DROP TABLE IF EXISTS `item_text`; -CREATE TABLE `item_text` ( - `id` int(11) unsigned NOT NULL default '0', - `text` longtext, - PRIMARY KEY (`id`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Item System'; - --- --- Dumping data for table `item_text` --- - -LOCK TABLES `item_text` WRITE; -/*!40000 ALTER TABLE `item_text` DISABLE KEYS */; -/*!40000 ALTER TABLE `item_text` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `mail` --- - -DROP TABLE IF EXISTS `mail`; -CREATE TABLE `mail` ( - `id` int(11) unsigned NOT NULL default '0' COMMENT 'Identifier', - `messageType` tinyint(3) unsigned NOT NULL default '0', - `stationery` tinyint(3) NOT NULL default '41', - `mailTemplateId` mediumint(8) unsigned NOT NULL default '0', - `sender` int(11) unsigned NOT NULL default '0' COMMENT 'Character Global Unique Identifier', - `receiver` int(11) unsigned NOT NULL default '0' COMMENT 'Character Global Unique Identifier', - `subject` longtext, - `itemTextId` int(11) unsigned NOT NULL default '0', - `has_items` tinyint(3) unsigned NOT NULL default '0', - `expire_time` bigint(40) NOT NULL default '0', - `deliver_time` bigint(40) NOT NULL default '0', - `money` int(11) unsigned NOT NULL default '0', - `cod` int(11) unsigned NOT NULL default '0', - `checked` tinyint(3) unsigned NOT NULL default '0', - PRIMARY KEY (`id`), - KEY `idx_receiver` (`receiver`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Mail System'; - --- --- Dumping data for table `mail` --- - -LOCK TABLES `mail` WRITE; -/*!40000 ALTER TABLE `mail` DISABLE KEYS */; -/*!40000 ALTER TABLE `mail` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `mail_items` --- - -DROP TABLE IF EXISTS `mail_items`; -CREATE TABLE `mail_items` ( - `mail_id` int(11) NOT NULL default '0', - `item_guid` int(11) NOT NULL default '0', - `item_template` int(11) NOT NULL default '0', - `receiver` int(11) unsigned NOT NULL default '0' COMMENT 'Character Global Unique Identifier', - PRIMARY KEY (`mail_id`,`item_guid`), - KEY `idx_receiver` (`receiver`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC; - --- --- Dumping data for table `mail_items` --- - -LOCK TABLES `mail_items` WRITE; -/*!40000 ALTER TABLE `mail_items` DISABLE KEYS */; -/*!40000 ALTER TABLE `mail_items` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `pet_aura` --- - -DROP TABLE IF EXISTS `pet_aura`; -CREATE TABLE `pet_aura` ( - `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier', - `caster_guid` bigint(20) unsigned NOT NULL default '0' COMMENT 'Full Global Unique Identifier', - `spell` int(11) unsigned NOT NULL default '0', - `effect_index` int(11) unsigned NOT NULL default '0', - `amount` int(11) NOT NULL default '0', - `maxduration` int(11) NOT NULL default '0', - `remaintime` int(11) NOT NULL default '0', - `remaincharges` int(11) NOT NULL default '0', - PRIMARY KEY (`guid`,`spell`,`effect_index`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Pet System'; - --- --- Dumping data for table `pet_aura` --- - -LOCK TABLES `pet_aura` WRITE; -/*!40000 ALTER TABLE `pet_aura` DISABLE KEYS */; -/*!40000 ALTER TABLE `pet_aura` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `pet_spell` --- - -DROP TABLE IF EXISTS `pet_spell`; -CREATE TABLE `pet_spell` ( - `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier', - `spell` int(11) unsigned NOT NULL default '0' COMMENT 'Spell Identifier', - `slot` int(11) unsigned NOT NULL default '0', - `active` int(11) unsigned NOT NULL default '0', - PRIMARY KEY (`guid`,`spell`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Pet System'; - --- --- Dumping data for table `pet_spell` --- - -LOCK TABLES `pet_spell` WRITE; -/*!40000 ALTER TABLE `pet_spell` DISABLE KEYS */; -/*!40000 ALTER TABLE `pet_spell` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `pet_spell_cooldown` --- - -DROP TABLE IF EXISTS `pet_spell_cooldown`; -CREATE TABLE `pet_spell_cooldown` ( - `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier, Low part', - `spell` int(11) unsigned NOT NULL default '0' COMMENT 'Spell Identifier', - `time` bigint(20) unsigned NOT NULL default '0', - PRIMARY KEY (`guid`,`spell`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; - --- --- Dumping data for table `pet_spell_cooldown` --- - -LOCK TABLES `pet_spell_cooldown` WRITE; -/*!40000 ALTER TABLE `pet_spell_cooldown` DISABLE KEYS */; -/*!40000 ALTER TABLE `pet_spell_cooldown` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `petition` --- - -DROP TABLE IF EXISTS `petition`; -CREATE TABLE `petition` ( - `ownerguid` int(10) unsigned NOT NULL, - `petitionguid` int(10) unsigned default '0', - `name` varchar(255) NOT NULL default '', - `type` int(10) unsigned NOT NULL default '0', - PRIMARY KEY (`ownerguid`,`type`), - UNIQUE KEY `index_ownerguid_petitionguid` (`ownerguid`,`petitionguid`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Guild System'; - --- --- Dumping data for table `petition` --- - -LOCK TABLES `petition` WRITE; -/*!40000 ALTER TABLE `petition` DISABLE KEYS */; -/*!40000 ALTER TABLE `petition` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `petition_sign` --- - -DROP TABLE IF EXISTS `petition_sign`; -CREATE TABLE `petition_sign` ( - `ownerguid` int(10) unsigned NOT NULL, - `petitionguid` int(11) unsigned NOT NULL default '0', - `playerguid` int(11) unsigned NOT NULL default '0', - `player_account` int(11) unsigned NOT NULL default '0', - `type` int(10) unsigned NOT NULL default '0', - PRIMARY KEY (`petitionguid`,`playerguid`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Guild System'; --- --- Dumping data for table `petition_sign` --- - -LOCK TABLES `petition_sign` WRITE; -/*!40000 ALTER TABLE `petition_sign` DISABLE KEYS */; -/*!40000 ALTER TABLE `petition_sign` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `saved_variables` --- -DROP TABLE IF EXISTS `saved_variables`; -CREATE TABLE `saved_variables` ( - `NextArenaPointDistributionTime` timestamp NOT NULL -) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Variable Saves'; - --- --- Dumping data for table `saved_variables` --- - -LOCK TABLES `saved_variables` WRITE; -/*!40000 ALTER TABLE `saved_variables` DISABLE KEYS */; -/*!40000 ALTER TABLE `saved_variables` ENABLE KEYS */; -UNLOCK TABLES; -/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; - -/*!40101 SET SQL_MODE=@OLD_SQL_MODE */; -/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; -/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; -/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; -/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; -/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; -/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; - --- Dump completed on 2008-01-10 11:37:06 +-- MySQL dump 10.11 +-- +-- Host: localhost Database: characters +-- ------------------------------------------------------ +-- Server version 5.0.45-Debian_1ubuntu3.1-log + +/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; +/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; +/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; +/*!40101 SET NAMES utf8 */; +/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; +/*!40103 SET TIME_ZONE='+00:00' */; +/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; +/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; +/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; +/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; + +-- +-- Table structure for table `arena_team` +-- + +DROP TABLE IF EXISTS `arena_team`; +CREATE TABLE `arena_team` ( + `arenateamid` int(10) unsigned NOT NULL default '0', + `name` char(255) NOT NULL, + `captainguid` int(10) unsigned NOT NULL default '0', + `type` tinyint(3) unsigned NOT NULL default '0', + `BackgroundColor` int(10) unsigned NOT NULL default '0', + `EmblemStyle` int(10) unsigned NOT NULL default '0', + `EmblemColor` int(10) unsigned NOT NULL default '0', + `BorderStyle` int(10) unsigned NOT NULL default '0', + `BorderColor` int(10) unsigned NOT NULL default '0', + PRIMARY KEY (`arenateamid`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8; + +-- +-- Dumping data for table `arena_team` +-- + +LOCK TABLES `arena_team` WRITE; +/*!40000 ALTER TABLE `arena_team` DISABLE KEYS */; +/*!40000 ALTER TABLE `arena_team` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `arena_team_member` +-- + +DROP TABLE IF EXISTS `arena_team_member`; +CREATE TABLE `arena_team_member` ( + `arenateamid` int(10) unsigned NOT NULL default '0', + `guid` int(10) unsigned NOT NULL default '0', + `played_week` int(10) unsigned NOT NULL default '0', + `wons_week` int(10) unsigned NOT NULL default '0', + `played_season` int(10) unsigned NOT NULL default '0', + `wons_season` int(10) unsigned NOT NULL default '0', + `points_to_add` int(10) unsigned NOT NULL default '0' +) ENGINE=InnoDB DEFAULT CHARSET=utf8; + +-- +-- Dumping data for table `arena_team_member` +-- + +LOCK TABLES `arena_team_member` WRITE; +/*!40000 ALTER TABLE `arena_team_member` DISABLE KEYS */; +/*!40000 ALTER TABLE `arena_team_member` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `arena_team_stats` +-- + +DROP TABLE IF EXISTS `arena_team_stats`; +CREATE TABLE `arena_team_stats` ( + `arenateamid` int(10) unsigned NOT NULL default '0', + `rating` int(10) unsigned NOT NULL default '0', + `games` int(10) unsigned NOT NULL default '0', + `wins` int(10) unsigned NOT NULL default '0', + `played` int(10) unsigned NOT NULL default '0', + `wins2` int(10) unsigned NOT NULL default '0', + `rank` int(10) unsigned NOT NULL default '0', + PRIMARY KEY (`arenateamid`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8; + +-- +-- Dumping data for table `arena_team_stats` +-- + +LOCK TABLES `arena_team_stats` WRITE; +/*!40000 ALTER TABLE `arena_team_stats` DISABLE KEYS */; +/*!40000 ALTER TABLE `arena_team_stats` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `auctionhouse` +-- + +DROP TABLE IF EXISTS `auctionhouse`; +CREATE TABLE `auctionhouse` ( + `id` int(11) unsigned NOT NULL default '0', + `auctioneerguid` int(11) unsigned NOT NULL default '0', + `itemguid` int(11) unsigned NOT NULL default '0', + `item_template` int(11) unsigned NOT NULL default '0' COMMENT 'Item Identifier', + `itemowner` int(11) unsigned NOT NULL default '0', + `buyoutprice` int(11) NOT NULL default '0', + `time` bigint(40) NOT NULL default '0', + `buyguid` int(11) unsigned NOT NULL default '0', + `lastbid` int(11) NOT NULL default '0', + `startbid` int(11) NOT NULL default '0', + `deposit` int(11) NOT NULL default '0', + `location` tinyint(3) unsigned NOT NULL default '3', + PRIMARY KEY (`id`), + UNIQUE KEY `item_guid` (`itemguid`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8; + +-- +-- Dumping data for table `auctionhouse` +-- + +LOCK TABLES `auctionhouse` WRITE; +/*!40000 ALTER TABLE `auctionhouse` DISABLE KEYS */; +/*!40000 ALTER TABLE `auctionhouse` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `bugreport` +-- + +DROP TABLE IF EXISTS `bugreport`; +CREATE TABLE `bugreport` ( + `id` int(11) NOT NULL auto_increment COMMENT 'Identifier', + `type` varchar(255) NOT NULL default '', + `content` varchar(255) NOT NULL default '', + PRIMARY KEY (`id`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Debug System'; + +-- +-- Dumping data for table `bugreport` +-- + +LOCK TABLES `bugreport` WRITE; +/*!40000 ALTER TABLE `bugreport` DISABLE KEYS */; +/*!40000 ALTER TABLE `bugreport` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `characters` +-- + +DROP TABLE IF EXISTS `characters`; +CREATE TABLE `characters` ( + `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier', + `account` int(11) unsigned NOT NULL default '0' COMMENT 'Account Identifier', + `data` longtext, + `name` varchar(12) NOT NULL default '', + `race` tinyint(3) unsigned NOT NULL default '0', + `class` tinyint(3) unsigned NOT NULL default '0', + `position_x` float NOT NULL default '0', + `position_y` float NOT NULL default '0', + `position_z` float NOT NULL default '0', + `map` int(11) unsigned NOT NULL default '0' COMMENT 'Map Identifier', + `dungeon_difficulty` tinyint(1) unsigned NOT NULL DEFAULT '0', + `orientation` float NOT NULL default '0', + `taximask` longtext, + `online` tinyint(3) unsigned NOT NULL default '0', + `cinematic` tinyint(3) unsigned NOT NULL default '0', + `totaltime` int(11) unsigned NOT NULL default '0', + `leveltime` int(11) unsigned NOT NULL default '0', + `logout_time` bigint(20) unsigned NOT NULL default '0', + `is_logout_resting` tinyint(3) unsigned NOT NULL default '0', + `rest_bonus` float NOT NULL default '0', + `resettalents_cost` int(11) unsigned NOT NULL default '0', + `resettalents_time` bigint(20) unsigned NOT NULL default '0', + `trans_x` float NOT NULL default '0', + `trans_y` float NOT NULL default '0', + `trans_z` float NOT NULL default '0', + `trans_o` float NOT NULL default '0', + `transguid` bigint(20) unsigned NOT NULL default '0', + `gmstate` int(11) unsigned NOT NULL default '0', + `stable_slots` tinyint(1) unsigned NOT NULL default '0', + `at_login` int(11) unsigned NOT NULL default '0', + `zone` int(11) unsigned NOT NULL default '0', + `death_expire_time` bigint(20) unsigned NOT NULL default '0', + `taxi_path` text, + PRIMARY KEY (`guid`), + KEY `idx_account` (`account`), + KEY `idx_online` (`online`), + KEY `idx_name` (`name`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System'; + +-- +-- Dumping data for table `characters` +-- + +LOCK TABLES `characters` WRITE; +/*!40000 ALTER TABLE `characters` DISABLE KEYS */; +/*!40000 ALTER TABLE `characters` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `character_action` +-- + +DROP TABLE IF EXISTS `character_action`; +CREATE TABLE `character_action` ( + `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier', + `button` tinyint(3) unsigned NOT NULL default '0', + `action` smallint(5) unsigned NOT NULL default '0', + `type` tinyint(3) unsigned NOT NULL default '0', + `misc` tinyint(3) unsigned NOT NULL default '0', + PRIMARY KEY (`guid`,`button`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System'; + +-- +-- Dumping data for table `character_action` +-- + +LOCK TABLES `character_action` WRITE; +/*!40000 ALTER TABLE `character_action` DISABLE KEYS */; +/*!40000 ALTER TABLE `character_action` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `character_aura` +-- + +DROP TABLE IF EXISTS `character_aura`; +CREATE TABLE `character_aura` ( + `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier', + `caster_guid` bigint(20) unsigned NOT NULL default '0' COMMENT 'Full Global Unique Identifier', + `spell` int(11) unsigned NOT NULL default '0', + `effect_index` int(11) unsigned NOT NULL default '0', + `amount` int(11) NOT NULL default '0', + `maxduration` int(11) NOT NULL default '0', + `remaintime` int(11) NOT NULL default '0', + `remaincharges` int(11) NOT NULL default '0', + PRIMARY KEY (`guid`,`spell`,`effect_index`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System'; + +-- +-- Dumping data for table `character_aura` +-- + +LOCK TABLES `character_aura` WRITE; +/*!40000 ALTER TABLE `character_aura` DISABLE KEYS */; +/*!40000 ALTER TABLE `character_aura` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `character_declinedname` +-- + +DROP TABLE IF EXISTS `character_declinedname`; +CREATE TABLE `character_declinedname` ( + `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier', + `genitive` varchar(15) NOT NULL default '', + `dative` varchar(15) NOT NULL default '', + `accusative` varchar(15) NOT NULL default '', + `instrumental` varchar(15) NOT NULL default '', + `prepositional` varchar(15) NOT NULL default '', + PRIMARY KEY (`guid`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC; + +-- +-- Dumping data for table `character_declinedname` +-- + +LOCK TABLES `character_declinedname` WRITE; +/*!40000 ALTER TABLE `character_declinedname` DISABLE KEYS */; +/*!40000 ALTER TABLE `character_declinedname` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `character_gifts` +-- + +DROP TABLE IF EXISTS `character_gifts`; +CREATE TABLE `character_gifts` ( + `guid` int(20) unsigned NOT NULL default '0', + `item_guid` int(11) unsigned NOT NULL default '0', + `entry` int(20) unsigned NOT NULL default '0', + `flags` int(20) unsigned NOT NULL default '0', + PRIMARY KEY (`item_guid`), + KEY `idx_guid` (`guid`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8; + +-- +-- Dumping data for table `character_gifts` +-- + +LOCK TABLES `character_gifts` WRITE; +/*!40000 ALTER TABLE `character_gifts` DISABLE KEYS */; +/*!40000 ALTER TABLE `character_gifts` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `character_homebind` +-- + +DROP TABLE IF EXISTS `character_homebind`; +CREATE TABLE `character_homebind` ( + `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier', + `map` int(11) unsigned NOT NULL default '0' COMMENT 'Map Identifier', + `zone` int(11) unsigned NOT NULL default '0' COMMENT 'Zone Identifier', + `position_x` float NOT NULL default '0', + `position_y` float NOT NULL default '0', + `position_z` float NOT NULL default '0', + PRIMARY KEY (`guid`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System'; + +-- +-- Dumping data for table `character_homebind` +-- + +LOCK TABLES `character_homebind` WRITE; +/*!40000 ALTER TABLE `character_homebind` DISABLE KEYS */; +/*!40000 ALTER TABLE `character_homebind` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `character_instance` +-- + +DROP TABLE IF EXISTS `character_instance`; +CREATE TABLE `character_instance` ( + `guid` int(11) unsigned NOT NULL default '0', + `instance` int(11) unsigned NOT NULL default '0', + `permanent` tinyint(1) unsigned NOT NULL default '0', + PRIMARY KEY (`guid`,`instance`), + KEY `instance` (`instance`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8; + +-- +-- Dumping data for table `character_instance` +-- + +LOCK TABLES `character_instance` WRITE; +/*!40000 ALTER TABLE `character_instance` DISABLE KEYS */; +/*!40000 ALTER TABLE `character_instance` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `character_inventory` +-- + +DROP TABLE IF EXISTS `character_inventory`; +CREATE TABLE `character_inventory` ( + `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier', + `bag` int(11) unsigned NOT NULL default '0', + `slot` tinyint(3) unsigned NOT NULL default '0', + `item` int(11) unsigned NOT NULL default '0' COMMENT 'Item Global Unique Identifier', + `item_template` int(11) unsigned NOT NULL default '0' COMMENT 'Item Identifier', + PRIMARY KEY (`item`), + KEY `idx_guid` (`guid`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System'; + +-- +-- Dumping data for table `character_inventory` +-- + +LOCK TABLES `character_inventory` WRITE; +/*!40000 ALTER TABLE `character_inventory` DISABLE KEYS */; +/*!40000 ALTER TABLE `character_inventory` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `character_pet` +-- + +DROP TABLE IF EXISTS `character_pet`; +CREATE TABLE `character_pet` ( + `id` int(11) unsigned NOT NULL default '0', + `entry` int(11) unsigned NOT NULL default '0', + `owner` int(11) unsigned NOT NULL default '0', + `modelid` int(11) unsigned default '0', + `CreatedBySpell` int(11) unsigned NOT NULL default '0', + `PetType` tinyint(3) unsigned NOT NULL default '0', + `level` int(11) unsigned NOT NULL default '1', + `exp` int(11) unsigned NOT NULL default '0', + `Reactstate` tinyint(1) unsigned NOT NULL default '0', + `loyaltypoints` int(11) NOT NULL default '0', + `loyalty` int(11) unsigned NOT NULL default '0', + `trainpoint` int(11) NOT NULL default '0', + `name` varchar(100) default 'Pet', + `renamed` tinyint(1) unsigned NOT NULL default '0', + `slot` int(11) unsigned NOT NULL default '0', + `curhealth` int(11) unsigned NOT NULL default '1', + `curmana` int(11) unsigned NOT NULL default '0', + `curhappiness` int(11) unsigned NOT NULL default '0', + `savetime` bigint(20) unsigned NOT NULL default '0', + `resettalents_cost` int(11) unsigned NOT NULL default '0', + `resettalents_time` bigint(20) unsigned NOT NULL default '0', + `abdata` longtext, + `teachspelldata` longtext, + PRIMARY KEY (`id`), + KEY `owner` (`owner`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Pet System'; + +-- +-- Dumping data for table `character_pet` +-- + +LOCK TABLES `character_pet` WRITE; +/*!40000 ALTER TABLE `character_pet` DISABLE KEYS */; +/*!40000 ALTER TABLE `character_pet` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `character_pet_declinedname` +-- + +DROP TABLE IF EXISTS `character_pet_declinedname`; +CREATE TABLE `character_pet_declinedname` ( + `id` int(11) unsigned NOT NULL default '0', + `owner` int(11) unsigned NOT NULL default '0', + `genitive` varchar(12) NOT NULL default '', + `dative` varchar(12) NOT NULL default '', + `accusative` varchar(12) NOT NULL default '', + `instrumental` varchar(12) NOT NULL default '', + `prepositional` varchar(12) NOT NULL default '', + PRIMARY KEY (`id`), + KEY owner_key (`owner`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC; + +-- +-- Dumping data for table `character_pet_declinedname` +-- + +LOCK TABLES `character_pet_declinedname` WRITE; +/*!40000 ALTER TABLE `character_pet_declinedname` DISABLE KEYS */; +/*!40000 ALTER TABLE `character_pet_declinedname` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `character_queststatus` +-- + +DROP TABLE IF EXISTS `character_queststatus`; +CREATE TABLE `character_queststatus` ( + `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier', + `quest` int(11) unsigned NOT NULL default '0' COMMENT 'Quest Identifier', + `status` int(11) unsigned NOT NULL default '0', + `rewarded` tinyint(1) unsigned NOT NULL default '0', + `explored` tinyint(1) unsigned NOT NULL default '0', + `timer` bigint(20) unsigned NOT NULL default '0', + `mobcount1` int(11) unsigned NOT NULL default '0', + `mobcount2` int(11) unsigned NOT NULL default '0', + `mobcount3` int(11) unsigned NOT NULL default '0', + `mobcount4` int(11) unsigned NOT NULL default '0', + `itemcount1` int(11) unsigned NOT NULL default '0', + `itemcount2` int(11) unsigned NOT NULL default '0', + `itemcount3` int(11) unsigned NOT NULL default '0', + `itemcount4` int(11) unsigned NOT NULL default '0', + PRIMARY KEY (`guid`,`quest`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System'; + +-- +-- Dumping data for table `character_queststatus` +-- + +LOCK TABLES `character_queststatus` WRITE; +/*!40000 ALTER TABLE `character_queststatus` DISABLE KEYS */; +/*!40000 ALTER TABLE `character_queststatus` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `character_queststatus_daily` +-- + +DROP TABLE IF EXISTS `character_queststatus_daily`; +CREATE TABLE `character_queststatus_daily` ( + `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier', + `quest` int(11) unsigned NOT NULL default '0' COMMENT 'Quest Identifier', + `time` bigint(20) unsigned NOT NULL default '0', + PRIMARY KEY (`guid`,`quest`), + KEY `idx_guid` (`guid`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System'; + +-- +-- Dumping data for table `character_queststatus_daily` +-- + +LOCK TABLES `character_queststatus_daily` WRITE; +/*!40000 ALTER TABLE `character_queststatus_daily` DISABLE KEYS */; +/*!40000 ALTER TABLE `character_queststatus_daily` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `character_reputation` +-- + +DROP TABLE IF EXISTS `character_reputation`; +CREATE TABLE `character_reputation` ( + `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier', + `faction` int(11) unsigned NOT NULL default '0', + `standing` int(11) NOT NULL default '0', + `flags` int(11) NOT NULL default '0', + PRIMARY KEY (`guid`,`faction`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System'; + +-- +-- Dumping data for table `character_reputation` +-- + +LOCK TABLES `character_reputation` WRITE; +/*!40000 ALTER TABLE `character_reputation` DISABLE KEYS */; +/*!40000 ALTER TABLE `character_reputation` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `character_social` +-- + +DROP TABLE IF EXISTS `character_social`; +CREATE TABLE `character_social` ( + `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Character Global Unique Identifier', + `friend` int(11) unsigned NOT NULL default '0' COMMENT 'Friend Global Unique Identifier', + `flags` tinyint(1) unsigned NOT NULL default '0' COMMENT 'Friend Flags', + `note` varchar(48) NOT NULL DEFAULT '' COMMENT 'Friend Note', + PRIMARY KEY (`guid`,`friend`,`flags`), + KEY `guid` (`guid`), + KEY `friend` (`friend`), + KEY `guid_flags` (`guid`,`flags`), + KEY `friend_flags` (`friend`,`flags`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System'; + +-- +-- Dumping data for table `character_social` +-- + +LOCK TABLES `character_social` WRITE; +/*!40000 ALTER TABLE `character_social` DISABLE KEYS */; +/*!40000 ALTER TABLE `character_social` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `character_spell` +-- + +DROP TABLE IF EXISTS `character_spell`; +CREATE TABLE `character_spell` ( + `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier', + `spell` int(11) unsigned NOT NULL default '0' COMMENT 'Spell Identifier', + `slot` int(11) unsigned NOT NULL default '0', + `active` tinyint(3) unsigned NOT NULL default '1', + `disabled` tinyint(3) unsigned NOT NULL default '0', + PRIMARY KEY (`guid`,`spell`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System'; + +-- +-- Dumping data for table `character_spell` +-- + +LOCK TABLES `character_spell` WRITE; +/*!40000 ALTER TABLE `character_spell` DISABLE KEYS */; +/*!40000 ALTER TABLE `character_spell` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `character_spell_cooldown` +-- + +DROP TABLE IF EXISTS `character_spell_cooldown`; +CREATE TABLE `character_spell_cooldown` ( + `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier, Low part', + `spell` int(11) unsigned NOT NULL default '0' COMMENT 'Spell Identifier', + `item` int(11) unsigned NOT NULL default '0' COMMENT 'Item Identifier', + `time` bigint(20) unsigned NOT NULL default '0', + PRIMARY KEY (`guid`,`spell`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8; + +-- +-- Dumping data for table `character_spell_cooldown` +-- + +LOCK TABLES `character_spell_cooldown` WRITE; +/*!40000 ALTER TABLE `character_spell_cooldown` DISABLE KEYS */; +/*!40000 ALTER TABLE `character_spell_cooldown` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `character_ticket` +-- + +DROP TABLE IF EXISTS `character_ticket`; +CREATE TABLE `character_ticket` ( + `ticket_id` int(11) unsigned NOT NULL auto_increment, + `guid` int(11) unsigned NOT NULL default '0', + `ticket_text` text, + `ticket_lastchange` TIMESTAMP ON UPDATE CURRENT_TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, + PRIMARY KEY (`ticket_id`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System'; + +-- +-- Dumping data for table `character_ticket` +-- + +LOCK TABLES `character_ticket` WRITE; +/*!40000 ALTER TABLE `character_ticket` DISABLE KEYS */; +/*!40000 ALTER TABLE `character_ticket` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `character_tutorial` +-- + +DROP TABLE IF EXISTS `character_tutorial`; +CREATE TABLE `character_tutorial` ( + `account` bigint(20) unsigned NOT NULL auto_increment COMMENT 'Account Identifier', + `realmid` int(11) unsigned NOT NULL default '0' COMMENT 'Realm Identifier', + `tut0` int(11) unsigned NOT NULL default '0', + `tut1` int(11) unsigned NOT NULL default '0', + `tut2` int(11) unsigned NOT NULL default '0', + `tut3` int(11) unsigned NOT NULL default '0', + `tut4` int(11) unsigned NOT NULL default '0', + `tut5` int(11) unsigned NOT NULL default '0', + `tut6` int(11) unsigned NOT NULL default '0', + `tut7` int(11) unsigned NOT NULL default '0', + PRIMARY KEY (`account`,`realmid`), + KEY acc_key (`account`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System'; + +-- +-- Dumping data for table `character_tutorial` +-- + +LOCK TABLES `character_tutorial` WRITE; +/*!40000 ALTER TABLE `character_tutorial` DISABLE KEYS */; +/*!40000 ALTER TABLE `character_tutorial` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `corpse` +-- + +DROP TABLE IF EXISTS `corpse`; +CREATE TABLE `corpse` ( + `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier', + `player` int(11) unsigned NOT NULL default '0' COMMENT 'Character Global Unique Identifier', + `position_x` float NOT NULL default '0', + `position_y` float NOT NULL default '0', + `position_z` float NOT NULL default '0', + `orientation` float NOT NULL default '0', + `zone` int(11) unsigned NOT NULL default '38' COMMENT 'Zone Identifier', + `map` int(11) unsigned NOT NULL default '0' COMMENT 'Map Identifier', + `data` longtext, + `time` bigint(20) unsigned NOT NULL default '0', + `corpse_type` tinyint(3) unsigned NOT NULL default '0', + `instance` int(11) unsigned NOT NULL default '0', + PRIMARY KEY (`guid`), + KEY `idx_type` (`corpse_type`), + KEY `instance` (`instance`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Death System'; + +-- +-- Dumping data for table `corpse` +-- + +LOCK TABLES `corpse` WRITE; +/*!40000 ALTER TABLE `corpse` DISABLE KEYS */; +/*!40000 ALTER TABLE `corpse` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `groups` +-- + +DROP TABLE IF EXISTS `groups`; +CREATE TABLE `groups` ( + `leaderGuid` int(11) unsigned NOT NULL, + `mainTank` int(11) unsigned NOT NULL, + `mainAssistant` int(11) unsigned NOT NULL, + `lootMethod` tinyint(4) unsigned NOT NULL, + `looterGuid` int(11) unsigned NOT NULL, + `lootThreshold` tinyint(4) unsigned NOT NULL, + `icon1` int(11) unsigned NOT NULL, + `icon2` int(11) unsigned NOT NULL, + `icon3` int(11) unsigned NOT NULL, + `icon4` int(11) unsigned NOT NULL, + `icon5` int(11) unsigned NOT NULL, + `icon6` int(11) unsigned NOT NULL, + `icon7` int(11) unsigned NOT NULL, + `icon8` int(11) unsigned NOT NULL, + `isRaid` tinyint(1) unsigned NOT NULL, + `difficulty` tinyint(3) unsigned NOT NULL default '0', + PRIMARY KEY (`leaderGuid`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Groups'; + +-- +-- Dumping data for table `groups` +-- + +LOCK TABLES `groups` WRITE; +/*!40000 ALTER TABLE `groups` DISABLE KEYS */; +/*!40000 ALTER TABLE `groups` ENABLE KEYS */; +UNLOCK TABLES; + +-- ---------------------------- +-- Table structure for group_instance +-- ---------------------------- +DROP TABLE IF EXISTS `group_instance`; +CREATE TABLE `group_instance` ( + `leaderGuid` int(11) unsigned NOT NULL default '0', + `instance` int(11) unsigned NOT NULL default '0', + `permanent` tinyint(1) unsigned NOT NULL default '0', + PRIMARY KEY (`leaderGuid`,`instance`), + KEY `instance` (`instance`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8; + +-- +-- Dumping data for table `group_instance` +-- + +LOCK TABLES `group_instance` WRITE; +/*!40000 ALTER TABLE `group_instance` DISABLE KEYS */; +/*!40000 ALTER TABLE `group_instance` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `group_member` +-- + +DROP TABLE IF EXISTS `group_member`; +CREATE TABLE `group_member` ( + `leaderGuid` int(11) unsigned NOT NULL, + `memberGuid` int(11) unsigned NOT NULL, + `assistant` tinyint(1) unsigned NOT NULL, + `subgroup` smallint(6) unsigned NOT NULL, + PRIMARY KEY (`leaderGuid`,`memberGuid`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Groups'; + +-- +-- Dumping data for table `group_member` +-- + +LOCK TABLES `group_member` WRITE; +/*!40000 ALTER TABLE `group_member` DISABLE KEYS */; +/*!40000 ALTER TABLE `group_member` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `guild` +-- + +DROP TABLE IF EXISTS `guild`; +CREATE TABLE `guild` ( + `guildid` int(6) unsigned NOT NULL default '0', + `name` varchar(255) NOT NULL default '', + `leaderguid` int(6) unsigned NOT NULL default '0', + `EmblemStyle` int(5) NOT NULL default '0', + `EmblemColor` int(5) NOT NULL default '0', + `BorderStyle` int(5) NOT NULL default '0', + `BorderColor` int(5) NOT NULL default '0', + `BackgroundColor` int(5) NOT NULL default '0', + `info` text NOT NULL, + `motd` varchar(255) NOT NULL default '', + `createdate` datetime default NULL, + `BankMoney` bigint(20) NOT NULL default '0', + PRIMARY KEY (`guildid`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Guild System'; + +-- +-- Dumping data for table `guild` +-- + +LOCK TABLES `guild` WRITE; +/*!40000 ALTER TABLE `guild` DISABLE KEYS */; +/*!40000 ALTER TABLE `guild` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `guild_bank_eventlog` +-- + +DROP TABLE IF EXISTS `guild_bank_eventlog`; +CREATE TABLE `guild_bank_eventlog` ( + `guildid` int(11) unsigned NOT NULL default '0', + `LogGuid` int(11) unsigned NOT NULL default '0', + `LogEntry` tinyint(1) unsigned NOT NULL default '0', + `TabId` tinyint(1) unsigned NOT NULL default '0', + `PlayerGuid` int(11) unsigned NOT NULL default '0', + `ItemOrMoney` int(11) unsigned NOT NULL default '0', + `ItemStackCount` tinyint(3) unsigned NOT NULL default '0', + `DestTabId` tinyint(1) unsigned NOT NULL default '0', + `TimeStamp` bigint(20) unsigned NOT NULL default '0', + PRIMARY KEY (`guildid`,`LogGuid`), + KEY `guildid_key` (`guildid`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8; + +-- +-- Dumping data for table `guild_bank_eventlog` +-- + +LOCK TABLES `guild_bank_eventlog` WRITE; +/*!40000 ALTER TABLE `guild_bank_eventlog` DISABLE KEYS */; +/*!40000 ALTER TABLE `guild_bank_eventlog` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `guild_bank_item` +-- + +DROP TABLE IF EXISTS `guild_bank_item`; +CREATE TABLE `guild_bank_item` ( + `guildid` int(11) unsigned NOT NULL default '0', + `TabId` tinyint(1) unsigned NOT NULL default '0', + `SlotId` tinyint(3) unsigned NOT NULL default '0', + `item_guid` int(11) unsigned NOT NULL default '0', + `item_entry` int(11) unsigned NOT NULL default '0', + PRIMARY KEY (`guildid`,`tabid`,`slotid`), + KEY `guildid_key` (`guildid`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8; + +-- +-- Dumping data for table `guild_bank_item` +-- + +LOCK TABLES `guild_bank_item` WRITE; +/*!40000 ALTER TABLE `guild_bank_item` DISABLE KEYS */; +/*!40000 ALTER TABLE `guild_bank_item` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `guild_bank_right` +-- + +DROP TABLE IF EXISTS `guild_bank_right`; +CREATE TABLE `guild_bank_right` ( + `guildid` int(11) unsigned NOT NULL default '0', + `TabId` tinyint(1) unsigned NOT NULL default '0', + `rid` int(11) unsigned NOT NULL default '0', + `gbright` tinyint(3) unsigned NOT NULL default '0', + `SlotPerDay` int(11) unsigned NOT NULL default '0', + PRIMARY KEY (`guildid`,`TabId`,`rid`), + KEY `guildid_key` (`guildid`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8; + +-- +-- Dumping data for table `guild_bank_right` +-- + +LOCK TABLES `guild_bank_right` WRITE; +/*!40000 ALTER TABLE `guild_bank_right` DISABLE KEYS */; +/*!40000 ALTER TABLE `guild_bank_right` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `guild_bank_tab` +-- + +DROP TABLE IF EXISTS `guild_bank_tab`; +CREATE TABLE `guild_bank_tab` ( + `guildid` int(11) unsigned NOT NULL default '0', + `TabId` tinyint(1) unsigned NOT NULL default '0', + `TabName` varchar(100) NOT NULL default '', + `TabIcon` varchar(100) NOT NULL default '', + `TabText` varchar(500) NOT NULL default '', + PRIMARY KEY (`guildid`,`TabId`), + KEY `guildid_key` (`guildid`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8; + +-- +-- Dumping data for table `guild_bank_tab` +-- + +LOCK TABLES `guild_bank_tab` WRITE; +/*!40000 ALTER TABLE `guild_bank_tab` DISABLE KEYS */; +/*!40000 ALTER TABLE `guild_bank_tab` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `guild_eventlog` +-- + +DROP TABLE IF EXISTS `guild_eventlog`; +CREATE TABLE `guild_eventlog` ( + `guildid` int(11) NOT NULL COMMENT 'Guild Identificator', + `LogGuid` int(11) NOT NULL COMMENT 'Log entry identificator', + `EventType` tinyint(1) NOT NULL COMMENT 'Event type', + `PlayerGuid1` int(11) NOT NULL COMMENT 'Player 1', + `PlayerGuid2` int(11) NOT NULL COMMENT 'Player 2', + `NewRank` tinyint(2) NOT NULL COMMENT 'New rank(in case promotion/demotion)', + `TimeStamp` bigint(20) NOT NULL COMMENT 'Event UNIX time' +) ENGINE = InnoDB DEFAULT CHARSET = latin1 COMMENT 'Guild Eventlog'; + +-- +-- Dumping data for table `guild_eventlog` +-- + +LOCK TABLES `guild_eventlog` WRITE; +/*!40000 ALTER TABLE `guild_eventlog` DISABLE KEYS */; +/*!40000 ALTER TABLE `guild_eventlog` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `guild_member` +-- + +DROP TABLE IF EXISTS `guild_member`; +CREATE TABLE `guild_member` ( + `guildid` int(6) unsigned NOT NULL default '0', + `guid` int(11) unsigned NOT NULL default '0', + `rank` tinyint(2) unsigned NOT NULL default '0', + `pnote` varchar(255) NOT NULL default '', + `offnote` varchar(255) NOT NULL default '', + `BankResetTimeMoney` int(11) unsigned NOT NULL default '0', + `BankRemMoney` int(11) unsigned NOT NULL default '0', + `BankResetTimeTab0` int(11) unsigned NOT NULL default '0', + `BankRemSlotsTab0` int(11) unsigned NOT NULL default '0', + `BankResetTimeTab1` int(11) unsigned NOT NULL default '0', + `BankRemSlotsTab1` int(11) unsigned NOT NULL default '0', + `BankResetTimeTab2` int(11) unsigned NOT NULL default '0', + `BankRemSlotsTab2` int(11) unsigned NOT NULL default '0', + `BankResetTimeTab3` int(11) unsigned NOT NULL default '0', + `BankRemSlotsTab3` int(11) unsigned NOT NULL default '0', + `BankResetTimeTab4` int(11) unsigned NOT NULL default '0', + `BankRemSlotsTab4` int(11) unsigned NOT NULL default '0', + `BankResetTimeTab5` int(11) unsigned NOT NULL default '0', + `BankRemSlotsTab5` int(11) unsigned NOT NULL default '0', + KEY `guildid_key` (`guildid`), + KEY `guildid_rank_key` (`guildid`,`rank`), + KEY `guid_key` (`guid`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Guild System'; + +-- +-- Dumping data for table `guild_member` +-- + +LOCK TABLES `guild_member` WRITE; +/*!40000 ALTER TABLE `guild_member` DISABLE KEYS */; +/*!40000 ALTER TABLE `guild_member` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `guild_rank` +-- + +DROP TABLE IF EXISTS `guild_rank`; +CREATE TABLE `guild_rank` ( + `guildid` int(6) unsigned NOT NULL default '0', + `rid` int(11) unsigned NOT NULL, + `rname` varchar(255) NOT NULL default '', + `rights` int(3) unsigned NOT NULL default '0', + `BankMoneyPerDay` int(11) unsigned NOT NULL default '0', + PRIMARY KEY (`guildid`,`rid`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Guild System'; + +-- +-- Dumping data for table `guild_rank` +-- + +LOCK TABLES `guild_rank` WRITE; +/*!40000 ALTER TABLE `guild_rank` DISABLE KEYS */; +/*!40000 ALTER TABLE `guild_rank` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `instance` +-- + +DROP TABLE IF EXISTS `instance`; +CREATE TABLE `instance` ( + `id` int(11) unsigned NOT NULL default '0', + `map` int(11) unsigned NOT NULL default '0', + `resettime` bigint(40) NOT NULL default '0', + `difficulty` tinyint(1) unsigned NOT NULL default '0', + `data` longtext, + PRIMARY KEY (`id`), + KEY `map` (`map`), + KEY `resettime` (`resettime`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8; + +-- +-- Dumping data for table `instance` +-- + +LOCK TABLES `instance` WRITE; +/*!40000 ALTER TABLE `instance` DISABLE KEYS */; +/*!40000 ALTER TABLE `instance` ENABLE KEYS */; +UNLOCK TABLES; + +-- ---------------------------- +-- Table structure for instance_reset +-- ---------------------------- +DROP TABLE IF EXISTS `instance_reset`; +CREATE TABLE `instance_reset` ( + `mapid` int(11) unsigned NOT NULL default '0', + `resettime` bigint(40) NOT NULL default '0', + PRIMARY KEY (`mapid`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8; + +-- +-- Dumping data for table `instance_reset` +-- + +LOCK TABLES `instance_reset` WRITE; +/*!40000 ALTER TABLE `instance_reset` DISABLE KEYS */; +/*!40000 ALTER TABLE `instance_reset` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `item_instance` +-- + +DROP TABLE IF EXISTS `item_instance`; +CREATE TABLE `item_instance` ( + `guid` int(11) unsigned NOT NULL default '0', + `owner_guid` int(11) unsigned NOT NULL default '0', + `data` longtext, + PRIMARY KEY (`guid`), + KEY `idx_owner_guid` (`owner_guid`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Item System'; + +-- +-- Dumping data for table `item_instance` +-- + +LOCK TABLES `item_instance` WRITE; +/*!40000 ALTER TABLE `item_instance` DISABLE KEYS */; +/*!40000 ALTER TABLE `item_instance` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `item_text` +-- + +DROP TABLE IF EXISTS `item_text`; +CREATE TABLE `item_text` ( + `id` int(11) unsigned NOT NULL default '0', + `text` longtext, + PRIMARY KEY (`id`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Item System'; + +-- +-- Dumping data for table `item_text` +-- + +LOCK TABLES `item_text` WRITE; +/*!40000 ALTER TABLE `item_text` DISABLE KEYS */; +/*!40000 ALTER TABLE `item_text` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `mail` +-- + +DROP TABLE IF EXISTS `mail`; +CREATE TABLE `mail` ( + `id` int(11) unsigned NOT NULL default '0' COMMENT 'Identifier', + `messageType` tinyint(3) unsigned NOT NULL default '0', + `stationery` tinyint(3) NOT NULL default '41', + `mailTemplateId` mediumint(8) unsigned NOT NULL default '0', + `sender` int(11) unsigned NOT NULL default '0' COMMENT 'Character Global Unique Identifier', + `receiver` int(11) unsigned NOT NULL default '0' COMMENT 'Character Global Unique Identifier', + `subject` longtext, + `itemTextId` int(11) unsigned NOT NULL default '0', + `has_items` tinyint(3) unsigned NOT NULL default '0', + `expire_time` bigint(40) NOT NULL default '0', + `deliver_time` bigint(40) NOT NULL default '0', + `money` int(11) unsigned NOT NULL default '0', + `cod` int(11) unsigned NOT NULL default '0', + `checked` tinyint(3) unsigned NOT NULL default '0', + PRIMARY KEY (`id`), + KEY `idx_receiver` (`receiver`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Mail System'; + +-- +-- Dumping data for table `mail` +-- + +LOCK TABLES `mail` WRITE; +/*!40000 ALTER TABLE `mail` DISABLE KEYS */; +/*!40000 ALTER TABLE `mail` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `mail_items` +-- + +DROP TABLE IF EXISTS `mail_items`; +CREATE TABLE `mail_items` ( + `mail_id` int(11) NOT NULL default '0', + `item_guid` int(11) NOT NULL default '0', + `item_template` int(11) NOT NULL default '0', + `receiver` int(11) unsigned NOT NULL default '0' COMMENT 'Character Global Unique Identifier', + PRIMARY KEY (`mail_id`,`item_guid`), + KEY `idx_receiver` (`receiver`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC; + +-- +-- Dumping data for table `mail_items` +-- + +LOCK TABLES `mail_items` WRITE; +/*!40000 ALTER TABLE `mail_items` DISABLE KEYS */; +/*!40000 ALTER TABLE `mail_items` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `pet_aura` +-- + +DROP TABLE IF EXISTS `pet_aura`; +CREATE TABLE `pet_aura` ( + `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier', + `caster_guid` bigint(20) unsigned NOT NULL default '0' COMMENT 'Full Global Unique Identifier', + `spell` int(11) unsigned NOT NULL default '0', + `effect_index` int(11) unsigned NOT NULL default '0', + `amount` int(11) NOT NULL default '0', + `maxduration` int(11) NOT NULL default '0', + `remaintime` int(11) NOT NULL default '0', + `remaincharges` int(11) NOT NULL default '0', + PRIMARY KEY (`guid`,`spell`,`effect_index`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Pet System'; + +-- +-- Dumping data for table `pet_aura` +-- + +LOCK TABLES `pet_aura` WRITE; +/*!40000 ALTER TABLE `pet_aura` DISABLE KEYS */; +/*!40000 ALTER TABLE `pet_aura` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `pet_spell` +-- + +DROP TABLE IF EXISTS `pet_spell`; +CREATE TABLE `pet_spell` ( + `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier', + `spell` int(11) unsigned NOT NULL default '0' COMMENT 'Spell Identifier', + `slot` int(11) unsigned NOT NULL default '0', + `active` int(11) unsigned NOT NULL default '0', + PRIMARY KEY (`guid`,`spell`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Pet System'; + +-- +-- Dumping data for table `pet_spell` +-- + +LOCK TABLES `pet_spell` WRITE; +/*!40000 ALTER TABLE `pet_spell` DISABLE KEYS */; +/*!40000 ALTER TABLE `pet_spell` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `pet_spell_cooldown` +-- + +DROP TABLE IF EXISTS `pet_spell_cooldown`; +CREATE TABLE `pet_spell_cooldown` ( + `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier, Low part', + `spell` int(11) unsigned NOT NULL default '0' COMMENT 'Spell Identifier', + `time` bigint(20) unsigned NOT NULL default '0', + PRIMARY KEY (`guid`,`spell`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8; + +-- +-- Dumping data for table `pet_spell_cooldown` +-- + +LOCK TABLES `pet_spell_cooldown` WRITE; +/*!40000 ALTER TABLE `pet_spell_cooldown` DISABLE KEYS */; +/*!40000 ALTER TABLE `pet_spell_cooldown` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `petition` +-- + +DROP TABLE IF EXISTS `petition`; +CREATE TABLE `petition` ( + `ownerguid` int(10) unsigned NOT NULL, + `petitionguid` int(10) unsigned default '0', + `name` varchar(255) NOT NULL default '', + `type` int(10) unsigned NOT NULL default '0', + PRIMARY KEY (`ownerguid`,`type`), + UNIQUE KEY `index_ownerguid_petitionguid` (`ownerguid`,`petitionguid`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Guild System'; + +-- +-- Dumping data for table `petition` +-- + +LOCK TABLES `petition` WRITE; +/*!40000 ALTER TABLE `petition` DISABLE KEYS */; +/*!40000 ALTER TABLE `petition` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `petition_sign` +-- + +DROP TABLE IF EXISTS `petition_sign`; +CREATE TABLE `petition_sign` ( + `ownerguid` int(10) unsigned NOT NULL, + `petitionguid` int(11) unsigned NOT NULL default '0', + `playerguid` int(11) unsigned NOT NULL default '0', + `player_account` int(11) unsigned NOT NULL default '0', + `type` int(10) unsigned NOT NULL default '0', + PRIMARY KEY (`petitionguid`,`playerguid`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Guild System'; +-- +-- Dumping data for table `petition_sign` +-- + +LOCK TABLES `petition_sign` WRITE; +/*!40000 ALTER TABLE `petition_sign` DISABLE KEYS */; +/*!40000 ALTER TABLE `petition_sign` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `saved_variables` +-- +DROP TABLE IF EXISTS `saved_variables`; +CREATE TABLE `saved_variables` ( + `NextArenaPointDistributionTime` timestamp NOT NULL +) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Variable Saves'; + +-- +-- Dumping data for table `saved_variables` +-- + +LOCK TABLES `saved_variables` WRITE; +/*!40000 ALTER TABLE `saved_variables` DISABLE KEYS */; +/*!40000 ALTER TABLE `saved_variables` ENABLE KEYS */; +UNLOCK TABLES; +/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; + +/*!40101 SET SQL_MODE=@OLD_SQL_MODE */; +/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; +/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; +/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; +/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; +/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; +/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; + +-- Dump completed on 2008-01-10 11:37:06 diff --git a/sql/mangos.sql b/sql/mangos.sql index 14e084afd5b..7692f776c65 100644 --- a/sql/mangos.sql +++ b/sql/mangos.sql @@ -210,7 +210,8 @@ INSERT INTO `command` VALUES ('event stop',2,'Syntax: .event stop #event_id\r\nStop event #event_id. Set start time for event to time in past that make current moment is event stop time (change not saved in DB).'), ('explorecheat',3,'Syntax: .explorecheat #flag\r\n\r\nReveal or hide all maps for the selected player. If no player is selected, hide or reveal maps to you.\r\n\r\nUse a #flag of value 1 to reveal, use a #flag value of 0 to hide all maps.'), ('flusharenapoints',3,'Syntax: .flusharenapoints\r\n\r\nUse it to distribute arena points based on arena team ratings, and start a new week.'), -('gm',1,'Syntax: .gm on/off\r\n\r\nEnable or Disable GM MODE'), +('gm',1,'Syntax: .gm [on/off]\r\n\r\nEnable or Disable in game GM MODE or show current state of on/off not provided.'), +('gm chat',1,'Syntax: .gm chat [on/off]\r\n\r\nEnable or disable chat GM MODE (show gm badge in messages) or show current state of on/off not provided.'), ('gm fly',3,'Syntax: .gm fly on/off\r\nEnable/disable gm fly mode.'), ('gm list',0,'Syntax: .gm list\r\n\r\nDisplay a list of available Game Masters.'), ('gm visible',1,'Syntax: .gm visible on/off\r\n\r\nOutput current visibility state or make GM visible(on) and invisible(off) for other players.'), @@ -352,7 +353,7 @@ INSERT INTO `command` VALUES ('save',0,'Syntax: .save\r\n\r\nSaves your character.'), ('saveall',1,'Syntax: .saveall\r\n\r\nSave all characters in game.'), ('security',3,'Syntax: .security $name #level\r\n\r\nSet the security level of player $name to a level of #level.\r\n\r\n#level may range from 0 to 5.'), -('sendmail',1,'Syntax: .sendmail #playername #subject #text\r\n\r\nSend a mail to a player. Note: subject may not contain spaces.'), +('sendmail',1,'Syntax: .sendmail #playername "#subject" "#text" itemid1[:count1] itemid2[:count2] ... itemidN[:countN]\r\n\r\nSend a mail to a player. Subject and mail text must be in "". If for itemid not provided related count values then expected 1, if count > max items in stack then items will be send in required amount stacks. All stacks amount in mail limited to 12.'), ('server info',0,'Syntax: .server info\r\n\r\nDisplay server version and the number of connected players.'), ('server idleshutdown',3,'Syntax: .server idleshutdown #delay|cancel\r\n\r\nShut the server down after #delay seconds if no active connections are present (no players) or cancel the restart/shutdown if cancel value is used.'), ('server idlerestart',3,'Syntax: .server idlerestart #delay|cancel\r\n\r\nRestart the server after #delay seconds if no active connections are present (no players) or cancel the restart/shutdown if cancel value is used.'), @@ -2137,6 +2138,8 @@ INSERT INTO `mangos_string` VALUES (49,'You must be at least level %u to enter.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (50,'You must be at least level %u and have item %s to enter.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (51,'Hello! Ready for some training?',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), +(52,'Invaid item count (%u) for item %u',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), +(53,'Mail can\'t have more %u item stacks',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (100,'Global notify: ',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (101,'Map: %u (%s) Zone: %u (%s) Area: %u (%s)\nX: %f Y: %f Z: %f Orientation: %f\ngrid[%u,%u]cell[%u,%u] InstanceID: %u\n ZoneX: %f ZoneY: %f\nGroundZ: %f FloorZ: %f Have height data (Map: %u VMap: %u)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (102,'%s is already being teleported.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), @@ -2339,6 +2342,10 @@ INSERT INTO `mangos_string` VALUES (329,' %s (GUID %u)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (330,'No players found!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (331,'Extended item cost %u not exist',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), +(332,'GM mode is ON',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), +(333,'GM mode is OFF',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), +(334,'GM Chat Badge is ON',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), +(335,'GM Chat Badge is OFF',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (400,'|cffff0000[System Message]:|rScripts reloaded',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (401,'You change security level of %s to %i.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (402,'%s changed your security level to %i.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), @@ -2578,22 +2585,37 @@ INSERT INTO `mangos_string` VALUES (710,'Away from Keyboard',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (711,'Your group is too large for this battleground. Please regroup to join.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (712,'Your group is too large for this arena. Please regroup to join.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), -(713,'Your group has members not in your arena team. Please regroup to join.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), -(714,'Your group does not have enough players to join this match.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), -(715,'The Gold Team wins!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), -(716,'The Green Team wins!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), -(717, 'There aren\'t enough players in this battleground. It will end soon unless some more players join to balance the fight.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), -(718, 'Your group has an offline member. Please remove him before joining.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), -(719, 'Your group has players from the opposing faction. You can\'t join the battleground as a group.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), -(720, 'Your group has players from different battleground brakets. You can\'t join as group.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), -(721, 'Someone in your party is already in this battleground queue. (S)he must leave it before joining as group.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), -(722, 'Someone in your party is Deserter. You can\'t join as group.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), -(723, 'Someone in your party is already in three battleground queues. You cannot join as group.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), -(724, 'You cannot teleport to a battleground or arena map.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), -(725, 'You cannot summon players to a battleground or arena map.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), -(726, 'You must be in GM mode to teleport to a player in a battleground.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), -(727, 'You cannot teleport to a battleground from another battleground. Please leave the current battleground first.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), -(728, 'Arena testing turned %s',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); +(713,'You must be level %u to join an arena team!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), +(714,'%s is not high enough level to join your team',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), +(715,'You don\'t meet Battleground level requirements',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), +(716,'Your arena team is full, %s cannot join it.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), +(730,'Your group has members not in your arena team. Please regroup to join.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), +(731,'Your group does not have enough players to join this match.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), +(732,'The Gold Team wins!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), +(733,'The Green Team wins!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), +(734, 'There aren\'t enough players in this battleground. It will end soon unless some more players join to balance the fight.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), +(735, 'Your group has an offline member. Please remove him before joining.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), +(736, 'Your group has players from the opposing faction. You can\'t join the battleground as a group.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), +(737, 'Your group has players from different battleground brakets. You can\'t join as group.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), +(738, 'Someone in your party is already in this battleground queue. (S)he must leave it before joining as group.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), +(739, 'Someone in your party is Deserter. You can\'t join as group.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), +(740, 'Someone in your party is already in three battleground queues. You cannot join as group.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), +(741, 'You cannot teleport to a battleground or arena map.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), +(742, 'You cannot summon players to a battleground or arena map.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), +(743, 'You must be in GM mode to teleport to a player in a battleground.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), +(744, 'You cannot teleport to a battleground from another battleground. Please leave the current battleground first.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), +(745, 'Arena testing turned %s',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), +(800,'Invalid name',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), +(801,'You do not have enough gold',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), +(802,'You do not have enough free slots',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), +(803,'Your partner does not have enough free bag slots',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), +(804,'You do not have permission to perform that function',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), +(805,'Unknown language',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), +(806,'You don\'t know that language',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), +(807,'Please provide character name',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), +(808,'Player %s not found or offline',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), +(809,'Account for character %s not found',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); + /*!40000 ALTER TABLE `mangos_string` ENABLE KEYS */; UNLOCK TABLES; diff --git a/sql/updates/10_instantiated_battlegrounds.sql b/sql/updates/10_instantiated_battlegrounds.sql index e32bc3f2824..c3234c3099e 100644 --- a/sql/updates/10_instantiated_battlegrounds.sql +++ b/sql/updates/10_instantiated_battlegrounds.sql @@ -15,24 +15,25 @@ INSERT INTO `command` (`name`, `security`, `help`) VALUES ('debug arena',3,'Syntax: .debug arena\r\n\r\n Toggles arena 1v1 or normal mode.'); -DELETE FROM mangos_string WHERE entry BETWEEN 711 AND 728; +DELETE FROM mangos_string WHERE entry IN (711,712); +DELETE FROM mangos_string WHERE entry BETWEEN 730 AND 745; INSERT INTO mangos_string (entry, content_default) VALUES (711,'Your group is too large for this battleground. Please regroup to join.'), (712,'Your group is too large for this arena. Please regroup to join.'), - (713,'Your group has members not in your arena team. Please regroup to join.'), - (714,'Your group does not have enough players to join this match.'), - (715,'The Gold Team wins!'), - (716,'The Green Team wins!'), - (717, 'There aren\'t enough players in this battleground. It will end soon unless some more players join to balance the fight.'), - (718, 'Your group has an offline member. Please remove him before joining.'), - (719, 'Your group has players from the opposing faction. You can\'t join the battleground as a group.'), - (720, 'Your group has players from different battleground brakets. You can\'t join as group.'), - (721, 'Someone in your party is already in this battleground queue. (S)he must leave it before joining as group.'), - (722, 'Someone in your party is Deserter. You can\'t join as group.'), - (723, 'Someone in your party is already in three battleground queues. You cannot join as group.'), - (724, 'You cannot teleport to a battleground or arena map.'), - (725, 'You cannot summon players to a battleground or arena map.'), - (726, 'You must be in GM mode to teleport to a player in a battleground.'), - (727, 'You cannot teleport to a battleground from another battleground. Please leave the current battleground first.'), - (728, 'Arena testing turned %s'); + (730,'Your group has members not in your arena team. Please regroup to join.'), + (731,'Your group does not have enough players to join this match.'), + (732,'The Gold Team wins!'), + (733,'The Green Team wins!'), + (734, 'There aren\'t enough players in this battleground. It will end soon unless some more players join to balance the fight.'), + (735, 'Your group has an offline member. Please remove him before joining.'), + (736, 'Your group has players from the opposing faction. You can\'t join the battleground as a group.'), + (737, 'Your group has players from different battleground brakets. You can\'t join as group.'), + (738, 'Someone in your party is already in this battleground queue. (S)he must leave it before joining as group.'), + (739, 'Someone in your party is Deserter. You can\'t join as group.'), + (740, 'Someone in your party is already in three battleground queues. You cannot join as group.'), + (741, 'You cannot teleport to a battleground or arena map.'), + (742, 'You cannot summon players to a battleground or arena map.'), + (743, 'You must be in GM mode to teleport to a player in a battleground.'), + (744, 'You cannot teleport to a battleground from another battleground. Please leave the current battleground first.'), + (745, 'Arena testing turned %s'); diff --git a/sql/updates/19_pack.sql b/sql/updates/19_pack.sql deleted file mode 100644 index 3a43f43a955..00000000000 --- a/sql/updates/19_pack.sql +++ /dev/null @@ -1,4 +0,0 @@ -ALTER TABLE `quest_template` ADD COLUMN `Method` tinyint(3) unsigned NOT NULL default '2' AFTER `entry`; -DELETE FROM mangos_string WHERE entry IN (331); -INSERT INTO mangos_string VALUES -(331,'Extended item cost %u not exist',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); -- cgit v1.2.3