diff options
Diffstat (limited to 'sql/old/4.3.4')
26 files changed, 232 insertions, 0 deletions
diff --git a/sql/old/4.3.4/2012_07_10_00_characters_character_glyphs_434.sql b/sql/old/4.3.4/2012_07_10_00_characters_character_glyphs_434.sql new file mode 100644 index 00000000000..b8aba4d7798 --- /dev/null +++ b/sql/old/4.3.4/2012_07_10_00_characters_character_glyphs_434.sql @@ -0,0 +1,4 @@ +ALTER TABLE `character_glyphs` + ADD `glyph7` smallint(5) unsigned DEFAULT '0' AFTER `glyph6`, + ADD `glyph8` smallint(5) unsigned DEFAULT '0' AFTER `glyph7`, + ADD `glyph9` smallint(5) unsigned DEFAULT '0' AFTER `glyph8`; diff --git a/sql/old/4.3.4/2012_07_18_00_characters_characters_434.sql b/sql/old/4.3.4/2012_07_18_00_characters_characters_434.sql new file mode 100644 index 00000000000..159c3d85703 --- /dev/null +++ b/sql/old/4.3.4/2012_07_18_00_characters_characters_434.sql @@ -0,0 +1 @@ +ALTER TABLE `characters` DROP `guildId`; diff --git a/sql/old/4.3.4/2012_07_23_00_auth_realmlist_434.sql b/sql/old/4.3.4/2012_07_23_00_auth_realmlist_434.sql new file mode 100644 index 00000000000..121e97f5837 --- /dev/null +++ b/sql/old/4.3.4/2012_07_23_00_auth_realmlist_434.sql @@ -0,0 +1 @@ +UPDATE `realmlist` SET `gamebuild`=15595 WHERE `id`=1; diff --git a/sql/old/4.3.4/2012_07_24_00_characters_various_434.sql b/sql/old/4.3.4/2012_07_24_00_characters_various_434.sql new file mode 100644 index 00000000000..8b2bfd4f131 --- /dev/null +++ b/sql/old/4.3.4/2012_07_24_00_characters_various_434.sql @@ -0,0 +1,3 @@ +ALTER TABLE `characters` CHANGE `money` `money` bigint(20) unsigned NOT NULL DEFAULT '0'; +ALTER TABLE `mail` CHANGE `money` `money` bigint(20) unsigned NOT NULL DEFAULT '0'; +ALTER TABLE `mail` CHANGE `cod` `cod` bigint(20) unsigned NOT NULL DEFAULT '0'; diff --git a/sql/old/4.3.4/2012_07_30_00_characters_void_storage_434.sql b/sql/old/4.3.4/2012_07_30_00_characters_void_storage_434.sql new file mode 100644 index 00000000000..e8a47c5f91c --- /dev/null +++ b/sql/old/4.3.4/2012_07_30_00_characters_void_storage_434.sql @@ -0,0 +1,11 @@ +DROP TABLE IF EXISTS `void_storage`; +CREATE TABLE IF NOT EXISTS `void_storage` ( + `itemId` bigint(20) unsigned NOT NULL, + `playerGuid` int(10) unsigned NOT NULL, + `itemEntry` mediumint(8) unsigned NOT NULL, + `slot` tinyint(3) unsigned NOT NULL, + `creatorGuid` int(10) unsigned NOT NULL DEFAULT '0', + PRIMARY KEY (`itemId`), + UNIQUE KEY `idx_player_slot` (`playerGuid`,`slot`), + KEY `idx_player` (`playerGuid`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8; diff --git a/sql/old/4.3.4/2012_07_30_01_characters_void_storage_434.sql b/sql/old/4.3.4/2012_07_30_01_characters_void_storage_434.sql new file mode 100644 index 00000000000..cd2cb0f0b9e --- /dev/null +++ b/sql/old/4.3.4/2012_07_30_01_characters_void_storage_434.sql @@ -0,0 +1,2 @@ +ALTER TABLE `void_storage` ADD `randomProperty` int(10) unsigned NOT NULL DEFAULT '0'; +ALTER TABLE `void_storage` ADD `suffixFactor` int(10) unsigned NOT NULL DEFAULT '0'; diff --git a/sql/old/4.3.4/2012_08_01_00_characters_item_instance_434.sql b/sql/old/4.3.4/2012_08_01_00_characters_item_instance_434.sql new file mode 100644 index 00000000000..b87b781e293 --- /dev/null +++ b/sql/old/4.3.4/2012_08_01_00_characters_item_instance_434.sql @@ -0,0 +1,11 @@ +UPDATE `item_instance` SET `enchantments` = REPLACE(`enchantments`,' ',' '); +UPDATE `item_instance` SET `enchantments` = CONCAT(TRIM(`enchantments`),' '); + +UPDATE `item_instance` SET `enchantments` = CONCAT( + SUBSTRING_INDEX(`enchantments`, ' ', 7*3), + ' 0 0 0 0 0 0 0 0 0 ', + SUBSTRING_INDEX(`enchantments`, ' ', -(12-7)*3 - 1)) +WHERE (LENGTH(`enchantments`) - LENGTH(REPLACE(`enchantments`, ' ', ''))) = 12*3; + +UPDATE `item_instance` SET `enchantments` = REPLACE(`enchantments`,' ',' '); +UPDATE `item_instance` SET `enchantments` = CONCAT(TRIM(`enchantments`),' '); diff --git a/sql/old/4.3.4/2012_08_07_00_characters_characters_434.sql b/sql/old/4.3.4/2012_08_07_00_characters_characters_434.sql new file mode 100644 index 00000000000..e9bea82ad4b --- /dev/null +++ b/sql/old/4.3.4/2012_08_07_00_characters_characters_434.sql @@ -0,0 +1,2 @@ +UPDATE characters SET drunk = (drunk / 256) & 0xFF; +ALTER TABLE characters CHANGE drunk drunk tinyint(3) unsigned NOT NULL DEFAULT '0'; diff --git a/sql/old/4.3.4/2012_08_07_01_characters_void_storage_434.sql b/sql/old/4.3.4/2012_08_07_01_characters_void_storage_434.sql new file mode 100644 index 00000000000..8a68ba3740d --- /dev/null +++ b/sql/old/4.3.4/2012_08_07_01_characters_void_storage_434.sql @@ -0,0 +1 @@ +RENAME TABLE `void_storage` TO `character_void_storage`; diff --git a/sql/old/4.3.4/2012_08_15_01_world_spell_script_names_434.sql b/sql/old/4.3.4/2012_08_15_01_world_spell_script_names_434.sql new file mode 100644 index 00000000000..b280367c811 --- /dev/null +++ b/sql/old/4.3.4/2012_08_15_01_world_spell_script_names_434.sql @@ -0,0 +1,5 @@ +DELETE FROM `spell_script_names` WHERE `spell_id` IN (2912,5176,78674); +INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES +(2912, 'spell_dru_eclipse_energize'), +(5176, 'spell_dru_eclipse_energize'), +(78674, 'spell_dru_eclipse_energize'); diff --git a/sql/old/4.3.4/2012_08_20_00_world_quest_template_434.sql b/sql/old/4.3.4/2012_08_20_00_world_quest_template_434.sql new file mode 100644 index 00000000000..ddd447acc50 --- /dev/null +++ b/sql/old/4.3.4/2012_08_20_00_world_quest_template_434.sql @@ -0,0 +1 @@ +ALTER TABLE `quest_template` CHANGE `RequiredRaces` `RequiredRaces` mediumint(8) unsigned NOT NULL DEFAULT '0'; diff --git a/sql/old/4.3.4/2012_08_22_00_characters_characters_434.sql b/sql/old/4.3.4/2012_08_22_00_characters_characters_434.sql new file mode 100644 index 00000000000..087f6f894eb --- /dev/null +++ b/sql/old/4.3.4/2012_08_22_00_characters_characters_434.sql @@ -0,0 +1 @@ +ALTER TABLE `characters` ADD `slot` TINYINT UNSIGNED NOT NULL DEFAULT '0' AFTER `name`; diff --git a/sql/old/4.3.4/2012_08_23_00_characters_guild_member434.sql b/sql/old/4.3.4/2012_08_23_00_characters_guild_member434.sql new file mode 100644 index 00000000000..cdd4781c0c0 --- /dev/null +++ b/sql/old/4.3.4/2012_08_23_00_characters_guild_member434.sql @@ -0,0 +1,4 @@ +ALTER TABLE guild_member ADD BankResetTimeTab6 INT(10) unsigned DEFAULT '0' AFTER BankRemSlotsTab5; +ALTER TABLE guild_member ADD BankRemSlotsTab6 INT(10) unsigned DEFAULT '0' AFTER BankResetTimeTab6; +ALTER TABLE guild_member ADD BankResetTimeTab7 INT(10) unsigned DEFAULT '0' AFTER BankRemSlotsTab6; +ALTER TABLE guild_member ADD BankRemSlotsTab7 INT(10) unsigned DEFAULT '0' AFTER BankResetTimeTab7; diff --git a/sql/old/4.3.4/2012_08_26_00_world_spell_script_names_434.sql b/sql/old/4.3.4/2012_08_26_00_world_spell_script_names_434.sql new file mode 100644 index 00000000000..d9bb921bf8a --- /dev/null +++ b/sql/old/4.3.4/2012_08_26_00_world_spell_script_names_434.sql @@ -0,0 +1,3 @@ +DELETE FROM `spell_script_names` WHERE `spell_id`=15473; +INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES +(15473,'spell_pri_shadowform'); diff --git a/sql/old/4.3.4/2012_08_27_00_characters_guild_bank_eventlog.sql b/sql/old/4.3.4/2012_08_27_00_characters_guild_bank_eventlog.sql new file mode 100644 index 00000000000..c019bc81504 --- /dev/null +++ b/sql/old/4.3.4/2012_08_27_00_characters_guild_bank_eventlog.sql @@ -0,0 +1 @@ +DELETE FROM `guild_bank_eventlog` WHERE `EventType` IN (3,7) AND `TabId`=`DestTabId`; -- delete log entries of item moves within one tab diff --git a/sql/old/4.3.4/2012_09_03_00_characters_currency_434.sql b/sql/old/4.3.4/2012_09_03_00_characters_currency_434.sql new file mode 100644 index 00000000000..fd6b3aaff10 --- /dev/null +++ b/sql/old/4.3.4/2012_09_03_00_characters_currency_434.sql @@ -0,0 +1,8 @@ +DROP TABLE IF EXISTS `character_currency`; +CREATE TABLE `character_currency` ( + `guid` int(10) unsigned NOT NULL, + `currency` smallint(5) unsigned NOT NULL, + `total_count` int(10) unsigned NOT NULL, + `week_count` int(10) unsigned NOT NULL, + PRIMARY KEY (`guid`,`currency`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8; diff --git a/sql/old/4.3.4/2012_09_03_01_characters_currency_434.sql b/sql/old/4.3.4/2012_09_03_01_characters_currency_434.sql new file mode 100644 index 00000000000..8b44fa43bd3 --- /dev/null +++ b/sql/old/4.3.4/2012_09_03_01_characters_currency_434.sql @@ -0,0 +1,3 @@ +-- porting from characters table +INSERT INTO `character_currency` (`guid`, `currency`, `total_count`, `week_count`) SELECT `characters`.`guid`, 392, `characters`.`totalHonorPoints`, 0 FROM `characters` WHERE `characters`.`totalHonorPoints` > 0; +INSERT INTO `character_currency` (`guid`, `currency`, `total_count`, `week_count`) SELECT `characters`.`guid`, 390, `characters`.`conquestPoints`, 0 FROM `characters` WHERE `characters`.`conquestPoints` > 0; diff --git a/sql/old/4.3.4/2012_09_03_02_characters_characters_434.sql b/sql/old/4.3.4/2012_09_03_02_characters_characters_434.sql new file mode 100644 index 00000000000..db61cbb1c88 --- /dev/null +++ b/sql/old/4.3.4/2012_09_03_02_characters_characters_434.sql @@ -0,0 +1,2 @@ +ALTER TABLE `characters` DROP `conquestPoints`; +ALTER TABLE `characters` DROP `totalHonorPoints`; diff --git a/sql/old/4.3.4/2012_09_04_00_characters_character_cuf_profiles_434.sql b/sql/old/4.3.4/2012_09_04_00_characters_character_cuf_profiles_434.sql new file mode 100644 index 00000000000..394c0912601 --- /dev/null +++ b/sql/old/4.3.4/2012_09_04_00_characters_character_cuf_profiles_434.sql @@ -0,0 +1,19 @@ +DROP TABLE IF EXISTS `character_cuf_profiles`; +CREATE TABLE IF NOT EXISTS `character_cuf_profiles` ( + `guid` int(10) unsigned NOT NULL COMMENT 'Character Guid', + `id` tinyint(3) unsigned NOT NULL COMMENT 'Profile Id (0-4)', + `name` varchar(12) NOT NULL COMMENT 'Profile Name', + `frameHeight` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Profile Frame Height', + `frameWidth` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Profile Frame Width', + `sortBy` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'Frame Sort By', + `healthText` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'Frame Health Text', + `boolOptions` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Many Configurable Bool Options', + `unk146` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'Profile Unk Int8', + `unk147` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'Profile Unk Int8', + `unk148` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'Profile Unk Int8', + `unk150` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Profile Unk Int16', + `unk152` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Profile Unk Int16', + `unk154` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Profile Unk Int16', + PRIMARY KEY (`guid`,`id`), + KEY `index` (`id`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8; diff --git a/sql/old/4.3.4/2012_09_07_00_characters_guild_434.sql b/sql/old/4.3.4/2012_09_07_00_characters_guild_434.sql new file mode 100644 index 00000000000..31695bab93f --- /dev/null +++ b/sql/old/4.3.4/2012_09_07_00_characters_guild_434.sql @@ -0,0 +1,3 @@ +ALTER TABLE guild ADD `level` INT(10) unsigned DEFAULT '1' AFTER `BankMoney`; +ALTER TABLE guild ADD `experience` BIGINT(20) unsigned DEFAULT '0' AFTER `level`; +ALTER TABLE guild ADD `todayExperience` BIGINT(20) unsigned DEFAULT '0' AFTER `experience`; diff --git a/sql/old/4.3.4/2012_09_09_00_characters_guild_news_434.sql b/sql/old/4.3.4/2012_09_09_00_characters_guild_news_434.sql new file mode 100644 index 00000000000..78fa817678b --- /dev/null +++ b/sql/old/4.3.4/2012_09_09_00_characters_guild_news_434.sql @@ -0,0 +1,11 @@ +DROP TABLE IF EXISTS `guild_news_log`; +CREATE TABLE `guild_news_log` ( + `guild` int(10) unsigned NOT NULL, + `id` int(10) unsigned NOT NULL, + `eventType` int(10) unsigned NOT NULL, + `playerGuid` bigint(20) unsigned NOT NULL, + `data` int(10) unsigned NOT NULL, + `flags` int(10) unsigned NOT NULL, + `date` int(10) unsigned NOT NULL DEFAULT '0', + PRIMARY KEY (`guild`,`id`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8; diff --git a/sql/old/4.3.4/2012_09_09_00_world_guild_xp_for_level.sql b/sql/old/4.3.4/2012_09_09_00_world_guild_xp_for_level.sql new file mode 100644 index 00000000000..aa2ee143d53 --- /dev/null +++ b/sql/old/4.3.4/2012_09_09_00_world_guild_xp_for_level.sql @@ -0,0 +1,33 @@ +DROP TABLE IF EXISTS `guild_xp_for_level`; +CREATE TABLE `guild_xp_for_level` ( + `lvl` int(11) unsigned NOT NULL, + `xp_for_next_level` bigint(20) unsigned NOT NULL DEFAULT '0', + PRIMARY KEY (`lvl`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; + +INSERT INTO `guild_xp_for_level` VALUES +(1,16580000), +(2,18240000), +(3,19900000), +(4,21550000), +(5,23220000), +(6,24880000), +(7,26530000), +(8,28190000), +(9,29850000), +(10,31510000), +(11,33170000), +(12,34820000), +(13,36490000), +(14,38140000), +(15,39800000), +(16,41450000), +(17,43120000), +(18,44780000), +(19,46430000), +(20,48090000), +(21,49750000), +(22,51410000), +(23,53060000), +(24,54730000), +(25,56390000); diff --git a/sql/old/4.3.4/2012_09_09_01_world_spell_script_names.sql b/sql/old/4.3.4/2012_09_09_01_world_spell_script_names.sql new file mode 100644 index 00000000000..5c1701e45bd --- /dev/null +++ b/sql/old/4.3.4/2012_09_09_01_world_spell_script_names.sql @@ -0,0 +1,5 @@ +DELETE FROM `spell_script_names` WHERE `ScriptName` IN ('spell_warr_improved_spell_reflection', 'spell_warr_vigilance', 'spell_warr_charge', 'spell_warr_slam', 'spell_warr_execute', 'spell_warr_overpower'); +INSERT INTO `spell_script_names`(`spell_id`,`ScriptName`) VALUES +(100,'spell_warr_charge'), +(1464,'spell_warr_slam'), +(5308,'spell_warr_execute'); diff --git a/sql/old/4.3.4/2012_09_09_02_world_spell_script_names_434.sql b/sql/old/4.3.4/2012_09_09_02_world_spell_script_names_434.sql new file mode 100644 index 00000000000..a4304663d9c --- /dev/null +++ b/sql/old/4.3.4/2012_09_09_02_world_spell_script_names_434.sql @@ -0,0 +1,4 @@ +DELETE FROM `spell_script_names` WHERE `ScriptName` IN ('spell_warl_banish','spell_warl_create_healthstone','spell_warl_ritual_of_doom_effect'); +INSERT INTO `spell_script_names`(`spell_id`,`ScriptName`) VALUES +(710,'spell_warl_banish'), +(6201,'spell_warl_create_healthstone'); diff --git a/sql/old/4.3.4/2012_09_09_05_world_guild_rewards_434.sql b/sql/old/4.3.4/2012_09_09_05_world_guild_rewards_434.sql new file mode 100644 index 00000000000..b05b9d959c7 --- /dev/null +++ b/sql/old/4.3.4/2012_09_09_05_world_guild_rewards_434.sql @@ -0,0 +1,53 @@ +DROP TABLE IF EXISTS `guild_rewards`; +CREATE TABLE `guild_rewards` ( + `entry` int(10) unsigned NOT NULL DEFAULT '0', + `standing` tinyint(3) unsigned DEFAULT '0', + `racemask` int(11) DEFAULT '0', + `price` bigint(20) unsigned DEFAULT '0', + `achievement` int(10) unsigned DEFAULT '0', + PRIMARY KEY (`entry`) +) engine=MyISAM DEFAULT CHARSET=utf8; + +INSERT INTO `guild_rewards` values +(69209, 4, -1, 1250000, 0), +(69210, 5, -1, 2500000, 0), +(63353, 5, 946, 1500000, 4989), +(63352, 5, 2098253, 1500000, 4989), +(63207, 5, 946, 3000000, 4945), +(63206, 5, 2098253, 3000000, 4945), +(65274, 6, 946, 5000000, 5035), +(65360, 6, 2098253, 5000000, 5035), +(65362, 5, 946, 3000000, 5179), +(65364, 6, 946, 5000000, 5201), +(65361, 5, 2098253, 3000000, 5031), +(65363, 6, 2098253, 5000000, 5201), +(63138, 7, -1, 3000000, 5812), +(63398, 6, 0, 3000000, 5144), +(63359, 5, 2098253, 1500000, 4860), +(64398, 5, 2098253, 2000000, 5143), +(64399, 5, 2098253, 3000000, 5422), +(64400, 5, 946, 1500000, 4860), +(64401, 5, 946, 2000000, 5143), +(64402, 5, 946, 3000000, 5422), +(62800, 5, 0, 1500000, 5036), +(62799, 5, 0, 1500000, 5467), +(65435, 5, 0, 1500000, 5465), +(65498, 5, 0, 1500000, 5024), +(62286, 4, 0, 100000000, 4943), +(68136, 6, 2098253, 200000000, 5152), +(62287, 6, 946, 200000000, 5158), +(69892, 5, 0, 12000000, 4944), +(62038, 5, 0, 12000000, 4944), +(62039, 5, 0, 12000000, 4944), +(62040, 5, 0, 12000000, 4944), +(69887, 5, 0, 15000000, 4946), +(61958, 5, 0, 15000000, 4946), +(61942, 5, 0, 15000000, 4946), +(61937, 5, 0, 15000000, 4946), +(61936, 5, 0, 15000000, 4946), +(61935, 5, 0, 15000000, 4946), +(61931, 5, 0, 15000000, 4946), +(67107, 7, 946, 15000000, 5492), +(62298, 7, 2098253, 15000000, 4912), +(63125, 7, 0, 30000000, 4988), +(71033, 7, 0, 15000000, 5840); diff --git a/sql/old/4.3.4/2012_09_10_00_characters_guild_finder_434.sql b/sql/old/4.3.4/2012_09_10_00_characters_guild_finder_434.sql new file mode 100644 index 00000000000..d4d524e0bef --- /dev/null +++ b/sql/old/4.3.4/2012_09_10_00_characters_guild_finder_434.sql @@ -0,0 +1,40 @@ +/*!40101 SET NAMES utf8 */; + +/*!40101 SET SQL_MODE=''*/; + +/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_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 `guild_finder_applicant` */ + +DROP TABLE IF EXISTS `guild_finder_applicant`; + +CREATE TABLE `guild_finder_applicant` ( + `guildId` int(10) unsigned DEFAULT NULL, + `playerGuid` int(10) unsigned DEFAULT NULL, + `availability` tinyint(3) unsigned DEFAULT '0', + `classRole` tinyint(3) unsigned DEFAULT '0', + `interests` tinyint(3) unsigned DEFAULT '0', + `comment` varchar(255) DEFAULT NULL, + `submitTime` int(10) unsigned DEFAULT NULL, + UNIQUE KEY `guildId` (`guildId`,`playerGuid`) +) ENGINE=InnoDB DEFAULT CHARSET=latin1; + +/* Table structure for table `guild_finder_guild_settings` */ + +DROP TABLE IF EXISTS `guild_finder_guild_settings`; + +CREATE TABLE `guild_finder_guild_settings` ( + `guildId` int(10) unsigned NOT NULL, + `availability` tinyint(3) unsigned NOT NULL DEFAULT '0', + `classRoles` tinyint(3) unsigned NOT NULL DEFAULT '0', + `interests` tinyint(3) unsigned NOT NULL DEFAULT '0', + `level` tinyint(3) unsigned NOT NULL DEFAULT '1', + `listed` tinyint(3) unsigned NOT NULL DEFAULT '0', + `comment` varchar(255) DEFAULT NULL, + PRIMARY KEY (`guildId`) +) ENGINE=InnoDB DEFAULT CHARSET=latin1; + +/*!40101 SET SQL_MODE=@OLD_SQL_MODE */; +/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; +/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; |