80J6JNhi

1ALTER TABLE `corpse` CHANGE COLUMN `phaseMask` `phaseMask` smallint(5) unsigned NOT NULL DEFAULT '1';
2
3-- Update arena_team table
4ALTER TABLE `arena_team`
5CHANGE `arenateamid` `arenaTeamId` INT(10) UNSIGNED DEFAULT '0' NOT NULL,
6CHANGE `captainguid` `captainGuid` INT(10) UNSIGNED DEFAULT '0' NOT NULL,
7CHANGE `BackgroundColor` `backgroundColor` INT(10) UNSIGNED DEFAULT '0' NOT NULL,
8CHANGE `EmblemStyle` `emblemStyle` TINYINT(3) UNSIGNED DEFAULT '0' NOT NULL,
9CHANGE `EmblemColor` `emblemColor` INT(10) UNSIGNED DEFAULT '0' NOT NULL,
10CHANGE `BorderStyle` `borderStyle` TINYINT(3) UNSIGNED DEFAULT '0' NOT NULL,
11CHANGE `BorderColor` `borderColor` INT(10) UNSIGNED DEFAULT '0' NOT NULL,
12ADD COLUMN `rating` SMALLINT(5) UNSIGNED NOT NULL AFTER `type`,
13ADD COLUMN `seasonGames` SMALLINT(5) UNSIGNED DEFAULT '0' NOT NULL AFTER `rating`,
14ADD COLUMN `seasonWins` SMALLINT(5) UNSIGNED DEFAULT '0' NOT NULL AFTER `seasonGames`,
15ADD COLUMN `weekGames` SMALLINT(5) UNSIGNED DEFAULT '0' NOT NULL AFTER `seasonWins`,
16ADD COLUMN `weekWins` SMALLINT(5) UNSIGNED DEFAULT '0' NOT NULL AFTER `weekGames`,
17ADD COLUMN `rank` INT(10) UNSIGNED NOT NULL AFTER `weekWins`;
18
19-- Move data from arena_team_stats to new columns in arena_team
20UPDATE `arena_team` a, `arena_team_stats` s SET
21`a`.`rating` = `s`.`rating`,
22`a`.`seasonGames` = `s`.`played`,
23`a`.`seasonWins` = `s`.`wins2`,
24`a`.`weekGames` = `s`.`games`,
25`a`.`weekWins` = `s`.`wins`,
26`a`.`rank` = `s`.`rank`
27WHERE `a`.`arenaTeamId` = `s`.`arenateamid`;
28
29-- Remove arena_team_stats table
30DROP TABLE `arena_team_stats`;
31
32-- Update arena_team_member table
33ALTER TABLE `arena_team_member`
34CHANGE `arenateamid` `arenaTeamId` INT(10) UNSIGNED DEFAULT '0' NOT NULL,
35CHANGE `played_week` `weekGames` SMALLINT(5) UNSIGNED DEFAULT '0' NOT NULL,
36CHANGE `wons_week` `weekWins` SMALLINT(5) UNSIGNED DEFAULT '0' NOT NULL,
37CHANGE `played_season` `seasonGames` SMALLINT(5) UNSIGNED DEFAULT '0' NOT NULL,
38CHANGE `wons_season` `seasonWins` SMALLINT(5) UNSIGNED DEFAULT '0' NOT NULL,
39ADD COLUMN `personalRating` SMALLINT(5) UNSIGNED DEFAULT '0' NOT NULL AFTER `seasonWins`;
40
41-- Update character_arena_stats table
42ALTER TABLE `character_arena_stats`
43CHANGE `personal_rating` `personalRating` SMALLINT(5) NOT NULL,
44CHANGE `matchmaker_rating` `matchMakerRating` SMALLINT(5) NOT NULL;
45
46
47ALTER TABLE `arena_team_member`
48DROP COLUMN `personalRating`;
49
50
51ALTER TABLE `character_battleground_data`
52    CHANGE `instance_id` `instanceId` int(10) unsigned NOT NULL COMMENT 'Instance Identifier',
53    CHANGE `join_map` `joinMapId` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Map Identifier',
54    CHANGE `join_x` `joinX` float NOT NULL DEFAULT '0',
55    CHANGE `join_y` `joinY` float NOT NULL DEFAULT '0',
56    CHANGE `join_z` `joinZ` float NOT NULL DEFAULT '0',
57    CHANGE `join_o` `joinO` float NOT NULL DEFAULT '0',
58    CHANGE `taxi_start` `taxiStart` int(10) unsigned NOT NULL DEFAULT '0',
59    CHANGE `taxi_end` `taxiEnd` int(10) unsigned NOT NULL DEFAULT '0',
60    CHANGE `mount_spell` `mountSpell` mediumint(8) unsigned NOT NULL DEFAULT '0';
61	
62ALTER TABLE `character_homebind`
63    CHANGE `map` `mapId` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Map Identifier',
64    CHANGE `zone` `zoneId` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Zone Identifier',
65    CHANGE `position_x` `posX` float NOT NULL DEFAULT '0',
66    CHANGE `position_y` `posY` float NOT NULL DEFAULT '0',
67    CHANGE `position_z` `posZ` float NOT NULL DEFAULT '0';
68	
69	
70ALTER TABLE `arena_team`
71CHANGE `rating` `rating` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
72CHANGE `rank` `rank` INT(10) UNSIGNED NOT NULL DEFAULT '0';
73
74
75ALTER TABLE `arena_team_member`
76ADD COLUMN `personalRating` SMALLINT(5) NOT NULL DEFAULT '0' AFTER guid;
77
78UPDATE arena_team_member
79INNER JOIN character_arena_stats ON arena_team_member.guid = character_arena_stats.guid
80INNER JOIN arena_team ON arena_team.arenaTeamId = arena_team_member.arenaTeamId AND (slot = 0 AND TYPE = 2 OR slot = 1 AND TYPE = 3 OR slot = 2 AND TYPE = 5)
81SET arena_team_member.personalRating = character_arena_stats.personalRating;
82
83ALTER TABLE `character_arena_stats`
84DROP COLUMN `personalRating`;
85
86ALTER TABLE `corpse`
87    CHANGE `guid` `corpseGuid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier',
88    CHANGE `player` `guid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Character Global Unique Identifier',
89    CHANGE `map` `mapId` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Map Identifier',
90    CHANGE `position_x` `posX` float NOT NULL DEFAULT '0',
91    CHANGE `position_y` `posY` float NOT NULL DEFAULT '0',
92    CHANGE `position_z` `posZ` float NOT NULL DEFAULT '0',
93    CHANGE `guild` `guildId` int(10) unsigned NOT NULL DEFAULT '0',
94    CHANGE `corpse_type` `corpseType` tinyint(3) unsigned NOT NULL DEFAULT '0',
95    CHANGE `instance` `instanceId` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Instance Identifier';
96	
97ALTER TABLE `creature_respawn`
98    CHANGE `respawntime` `respawnTime` int(10) unsigned NOT NULL DEFAULT '0',
99    CHANGE `instance` `instanceId` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Instance Identifier';
100	
101ALTER TABLE `gameobject_respawn`
102    CHANGE `respawntime` `respawnTime` int(10) unsigned NOT NULL DEFAULT '0',
103    CHANGE `instance` `instanceId` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Instance Identifier';
104	
105UPDATE `characters` SET `equipmentCache`=CONCAT(`equipmentCache`,"0 0 0 0 0 0 0 0 ") WHERE (CHAR_LENGTH(`equipmentCache`) - CHAR_LENGTH(REPLACE(`equipmentCache`, ' ', ''))) = 38;
106
107ALTER TABLE `corpse` CHANGE COLUMN `phaseMask` `phaseMask` smallint(5) unsigned NOT NULL DEFAULT '1';
108
109ALTER TABLE `character_banned` CHANGE COLUMN `guid` `guid` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier';
110ALTER TABLE `guild_rank` CHANGE `rname` `rname` VARCHAR(20) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT '' NOT NULL;
111ALTER TABLE `character_stats` ADD `resilience` INT UNSIGNED NOT NULL DEFAULT 0;
112ALTER TABLE `mail_items`
113DROP PRIMARY KEY,
114ADD PRIMARY KEY(`item_guid`),
115ADD KEY `idx_mail_id` (`mail_id`);
116
117ALTER TABLE `character_pet`
118ADD KEY `idx_slot` (`slot`);
119
120ALTER TABLE `character_pet`
121DROP COLUMN `resettalents_cost`,
122DROP COLUMN `resettalents_time`;
123ALTER TABLE `characters` ADD COLUMN `grantableLevels` tinyint(3) unsigned NOT NULL DEFAULT '0' AFTER `actionBars`;
124ALTER TABLE `character_queststatus` ADD `playercount` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0';
125
126
127UPDATE characters SET knownTitles = CONCAT(
128SUBSTRING_INDEX(SUBSTRING_INDEX(knownTitles, ' ', 1), ' ', -1), ' ',
129SUBSTRING_INDEX(SUBSTRING_INDEX(knownTitles, ' ', 2), ' ', -1), ' ',
130SUBSTRING_INDEX(SUBSTRING_INDEX(knownTitles, ' ', 3), ' ', -1), ' ',
131(SUBSTRING_INDEX(SUBSTRING_INDEX(knownTitles, ' ', 4), ' ', -1) | 512) &~256, ' ',
132SUBSTRING_INDEX(SUBSTRING_INDEX(knownTitles, ' ', 5), ' ', -1), ' ',
133SUBSTRING_INDEX(SUBSTRING_INDEX(knownTitles, ' ', 6), ' ', -1))
134WHERE SUBSTRING_INDEX(SUBSTRING_INDEX(knownTitles, ' ', 4), ' ', -1) & 256 AND gender = 0;
135
136
137DROP TABLE IF EXISTS `gm_tickets`;
138/*!40101 SET @saved_cs_client     = @@character_set_client */;
139/*!40101 SET character_set_client = utf8 */;
140CREATE TABLE `gm_tickets` (
141  `ticketId` int(10) unsigned NOT NULL AUTO_INCREMENT,
142  `guid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier of ticket creator',
143  `name` varchar(12) NOT NULL COMMENT 'Name of ticket creator',
144  `message` text NOT NULL,
145  `createTime` int(10) unsigned NOT NULL DEFAULT '0',
146  `mapId` smallint(5) unsigned NOT NULL DEFAULT '0',
147  `posX` float NOT NULL DEFAULT '0',
148  `posY` float NOT NULL DEFAULT '0',
149  `posZ` float NOT NULL DEFAULT '0',
150  `lastModifiedTime` int(10) unsigned NOT NULL DEFAULT '0',
151  `closedBy` int(10) NOT NULL DEFAULT '0',
152  `assignedTo` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'GUID of admin to whom ticket is assigned',
153  `comment` text NOT NULL,
154  `completed` tinyint(3) unsigned NOT NULL DEFAULT '0',
155  `escalated` tinyint(3) unsigned NOT NULL DEFAULT '0',
156  `viewed` tinyint(3) unsigned NOT NULL DEFAULT '0',
157  PRIMARY KEY (`ticketId`)
158) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Player System';
159/*!40101 SET character_set_client = @saved_cs_client */;
160
161
162DROP TABLE IF EXISTS `lag_reports`;
163/*!40101 SET @saved_cs_client     = @@character_set_client */;
164/*!40101 SET character_set_client = utf8 */;
165CREATE TABLE `lag_reports` (
166  `reportId` int(10) unsigned NOT NULL AUTO_INCREMENT,
167  `guid` int(10) unsigned NOT NULL DEFAULT '0',
168  `lagType` tinyint(3) unsigned NOT NULL DEFAULT '0',
169  `mapId` smallint(5) unsigned NOT NULL DEFAULT '0',
170  `posX` float NOT NULL DEFAULT '0',
171  `posY` float NOT NULL DEFAULT '0',
172  `posZ` float NOT NULL DEFAULT '0',
173  PRIMARY KEY (`reportId`)
174) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Player System';
175/*!40101 SET character_set_client = @saved_cs_client */;
176
177DROP TABLE IF EXISTS `gm_surveys`;
178/*!40101 SET @saved_cs_client     = @@character_set_client */;
179/*!40101 SET character_set_client = utf8 */;
180CREATE TABLE `gm_surveys` (
181  `surveyId` int(10) unsigned NOT NULL AUTO_INCREMENT,
182  `guid` int(10) unsigned NOT NULL DEFAULT '0',
183  `mainSurvey` int(10) unsigned NOT NULL DEFAULT '0',
184  `overallComment` longtext NOT NULL,
185  `createTime` int(10) unsigned NOT NULL DEFAULT '0',
186  PRIMARY KEY (`surveyId`)
187) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Player System';
188/*!40101 SET character_set_client = @saved_cs_client */;
189
190
191
192DROP TABLE IF EXISTS `players_reports_status`;
193
194CREATE TABLE `players_reports_status` (
195  `guid` int(10) unsigned NOT NULL DEFAULT '0',
196  `creation_time` int(10) unsigned NOT NULL DEFAULT '0',
197  `average` float NOT NULL DEFAULT '0',
198  `total_reports` bigint(20) unsigned NOT NULL DEFAULT '0',
199  `speed_reports` bigint(20) unsigned NOT NULL DEFAULT '0',
200  `fly_reports` bigint(20) unsigned NOT NULL DEFAULT '0',
201  `jump_reports` bigint(20) unsigned NOT NULL DEFAULT '0',
202  `waterwalk_reports` bigint(20) unsigned NOT NULL DEFAULT '0',
203  `teleportplane_reports` bigint(20) unsigned NOT NULL DEFAULT '0',
204  `climb_reports` bigint(20) unsigned NOT NULL DEFAULT '0',
205  PRIMARY KEY (`guid`)
206) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='';
207
208DROP TABLE IF EXISTS `daily_players_reports`;
209CREATE TABLE `daily_players_reports` (
210  `guid` int(10) unsigned NOT NULL DEFAULT '0',
211  `creation_time` int(10) unsigned NOT NULL DEFAULT '0',
212  `average` float NOT NULL DEFAULT '0',
213  `total_reports` bigint(20) unsigned NOT NULL DEFAULT '0',
214  `speed_reports` bigint(20) unsigned NOT NULL DEFAULT '0',
215  `fly_reports` bigint(20) unsigned NOT NULL DEFAULT '0',
216  `jump_reports` bigint(20) unsigned NOT NULL DEFAULT '0',
217  `waterwalk_reports` bigint(20) unsigned NOT NULL DEFAULT '0',
218  `teleportplane_reports` bigint(20) unsigned NOT NULL DEFAULT '0',
219  `climb_reports` bigint(20) unsigned NOT NULL DEFAULT '0',
220  PRIMARY KEY (`guid`)
221) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='';