aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
Diffstat (limited to 'sql')
-rw-r--r--sql/base/characters_database.sql10
-rw-r--r--sql/updates/characters/2015_01_22_00_characters.sql9
-rw-r--r--sql/updates/characters/2015_01_26_00_characters.sql5
-rw-r--r--sql/updates/world/2015_01_22_00_world.sql135
4 files changed, 152 insertions, 7 deletions
diff --git a/sql/base/characters_database.sql b/sql/base/characters_database.sql
index 0528f355c81..55c71d4bc58 100644
--- a/sql/base/characters_database.sql
+++ b/sql/base/characters_database.sql
@@ -1795,8 +1795,6 @@ CREATE TABLE `guild` (
`createdate` int(10) unsigned NOT NULL DEFAULT '0',
`BankMoney` bigint(20) unsigned NOT NULL DEFAULT '0',
`level` int(10) unsigned DEFAULT '1',
- `experience` bigint(20) unsigned DEFAULT '0',
- `todayExperience` bigint(20) unsigned DEFAULT '0',
PRIMARY KEY (`guildid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Guild System';
/*!40101 SET character_set_client = @saved_cs_client */;
@@ -1932,8 +1930,8 @@ CREATE TABLE `guild_bank_right` (
`guildid` bigint(20) unsigned NOT NULL DEFAULT '0',
`TabId` tinyint(3) unsigned NOT NULL DEFAULT '0',
`rid` tinyint(3) unsigned NOT NULL DEFAULT '0',
- `gbright` tinyint(3) unsigned NOT NULL DEFAULT '0',
- `SlotPerDay` int(10) unsigned NOT NULL DEFAULT '0',
+ `gbright` tinyint(3) NOT NULL DEFAULT '0',
+ `SlotPerDay` int(10) NOT NULL DEFAULT '0',
PRIMARY KEY (`guildid`,`TabId`,`rid`),
KEY `guildid_key` (`guildid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
@@ -2610,8 +2608,7 @@ CREATE TABLE `petition` (
`ownerguid` bigint(20) unsigned NOT NULL,
`petitionguid` bigint(20) unsigned DEFAULT '0',
`name` varchar(24) NOT NULL,
- `type` tinyint(3) unsigned NOT NULL DEFAULT '0',
- PRIMARY KEY (`ownerguid`,`type`),
+ PRIMARY KEY (`ownerguid`),
UNIQUE KEY `index_ownerguid_petitionguid` (`ownerguid`,`petitionguid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Guild System';
/*!40101 SET character_set_client = @saved_cs_client */;
@@ -2637,7 +2634,6 @@ CREATE TABLE `petition_sign` (
`petitionguid` bigint(20) unsigned NOT NULL DEFAULT '0',
`playerguid` bigint(20) unsigned NOT NULL DEFAULT '0',
`player_account` int(10) unsigned NOT NULL DEFAULT '0',
- `type` tinyint(3) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`petitionguid`,`playerguid`),
KEY `Idx_playerguid` (`playerguid`),
KEY `Idx_ownerguid` (`ownerguid`)
diff --git a/sql/updates/characters/2015_01_22_00_characters.sql b/sql/updates/characters/2015_01_22_00_characters.sql
new file mode 100644
index 00000000000..1ed83e4e762
--- /dev/null
+++ b/sql/updates/characters/2015_01_22_00_characters.sql
@@ -0,0 +1,9 @@
+ALTER TABLE `guild` DROP COLUMN `experience`, DROP COLUMN `todayExperience`;
+
+ALTER TABLE `guild_bank_right` MODIFY COLUMN `gbright` mediumint(3) NOT NULL DEFAULT 0; -- temp type, can hold all values
+UPDATE `guild_bank_right` SET `gbright` = -1 WHERE `gbright` = 255;
+ALTER TABLE `guild_bank_right` MODIFY COLUMN `gbright` tinyint(3) NOT NULL DEFAULT 0;
+
+ALTER TABLE `guild_bank_right` MODIFY COLUMN `SlotPerDay` bigint(10) NOT NULL DEFAULT 0; -- temp type, can hold all values
+UPDATE `guild_bank_right` SET `SlotPerDay` = -1 WHERE `SlotPerDay` = 4294967295;
+ALTER TABLE `guild_bank_right` MODIFY COLUMN `SlotPerDay` int(10) NOT NULL DEFAULT 0;
diff --git a/sql/updates/characters/2015_01_26_00_characters.sql b/sql/updates/characters/2015_01_26_00_characters.sql
new file mode 100644
index 00000000000..b2530013944
--- /dev/null
+++ b/sql/updates/characters/2015_01_26_00_characters.sql
@@ -0,0 +1,5 @@
+DELETE FROM `petition` WHERE `type` NOT IN(10); -- delete all non guild petitions
+ALTER TABLE `petition` DROP COLUMN `type`, DROP PRIMARY KEY, ADD PRIMARY KEY (`ownerguid`);
+
+DELETE FROM `petition_sign` WHERE `type` NOT IN(10); -- delete all non guild petition signs
+ALTER TABLE `petition_sign` DROP COLUMN `type`;
diff --git a/sql/updates/world/2015_01_22_00_world.sql b/sql/updates/world/2015_01_22_00_world.sql
new file mode 100644
index 00000000000..4a23527e5aa
--- /dev/null
+++ b/sql/updates/world/2015_01_22_00_world.sql
@@ -0,0 +1,135 @@
+DROP TABLE `guild_xp_for_level` IF EXISTS;
+
+ALTER TABLE `guild_rewards` CHANGE COLUMN `entry` `ItemID` mediumint(8) UNSIGNED NOT NULL DEFAULT 0;
+ALTER TABLE `guild_rewards` CHANGE COLUMN `standing` `MinGuildRep` tinyint(3) UNSIGNED NULL DEFAULT 0;
+ALTER TABLE `guild_rewards` CHANGE COLUMN `racemask` `RaceMask` int(11) NULL DEFAULT 0;
+ALTER TABLE `guild_rewards` CHANGE COLUMN `price` `Cost` bigint(20) UNSIGNED NULL DEFAULT 0;
+ALTER TABLE `guild_rewards` DROP COLUMN `achievement`;
+
+TRUNCATE TABLE `guild_rewards`;
+INSERT IGNORE INTO `guild_rewards` (`ItemID`, `MinGuildRep`, `RaceMask`, `Cost`) VALUES
+(89194, 5, -1, 1500000),
+(89195, 7, -1, 2000000),
+(114968, 6, 0, 3000000),
+(116666, 7, -1, 40000000),
+(63206, 5, 18875469, 3000000),
+(63207, 5, 33555378, 3000000),
+(65435, 5, 0, 1500000),
+(85666, 7, -1, 30000000),
+(67107, 7, 33555378, 15000000),
+(69887, 4, 0, 15000000),
+(69888, 5, -1, 17500000),
+(69892, 4, 0, 12000000),
+(71033, 7, 0, 15000000),
+(65498, 5, 0, 1500000),
+(120352, 7, 0, 1000000),
+(64398, 5, 18875469, 2000000),
+(64399, 5, 18875469, 3000000),
+(64400, 5, 33555378, 1500000),
+(64401, 5, 33555378, 2000000),
+(64402, 5, 33555378, 3000000),
+(61931, 4, 0, 15000000),
+(61935, 4, 0, 15000000),
+(61936, 4, 0, 15000000),
+(61937, 4, 0, 15000000),
+(61942, 4, 0, 15000000),
+(65274, 6, 33555378, 5000000),
+(61958, 4, 0, 15000000),
+(85508, 5, -1, 1000000),
+(85509, 5, -1, 1000000),
+(85510, 5, -1, 1000000),
+(63352, 5, 18875469, 1500000),
+(63353, 5, 33555378, 1500000),
+(62799, 5, 0, 1500000),
+(62800, 5, 0, 1500000),
+(63359, 5, 18875469, 1500000),
+(69209, 4, -1, 1250000),
+(69210, 5, -1, 2500000),
+(62286, 4, 0, 100000000),
+(62287, 6, 33555378, 200000000),
+(63398, 6, 0, 3000000),
+(63125, 7, 0, 30000000),
+(62298, 7, 18875469, 15000000),
+(62023, 5, -1, 17500000),
+(62024, 5, -1, 17500000),
+(62025, 5, -1, 17500000),
+(62026, 5, -1, 17500000),
+(62027, 5, -1, 17500000),
+(62029, 5, -1, 17500000),
+(63138, 7, -1, 3000000),
+(65360, 6, 18875469, 5000000),
+(65361, 5, 18875469, 3000000),
+(62038, 4, 0, 12000000),
+(65362, 5, 33555378, 3000000),
+(62039, 4, 0, 12000000),
+(65363, 6, 18875469, 5000000),
+(62040, 4, 0, 12000000),
+(65364, 6, 33555378, 5000000),
+(68136, 6, 18875469, 200000000),
+(89190, 5, -1, 1500000),
+(89191, 7, -1, 2000000),
+(89192, 5, -1, 1500000),
+(89193, 7, -1, 2000000);
+
+DROP TABLE IF EXISTS `guild_rewards_req_achievements`;
+CREATE TABLE `guild_rewards_req_achievements` (
+ `ItemID` mediumint(8) unsigned NOT NULL DEFAULT '0',
+ `AchievementRequired` mediumint(8) unsigned DEFAULT '0',
+ PRIMARY KEY (`ItemID`,`AchievementRequired`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+
+INSERT IGNORE INTO `guild_rewards_req_achievements` (`ItemID`, `AchievementRequired`) VALUES
+(89194, 6681),
+(89190, 6681),
+(89192, 6681),
+(89191, 6644),
+(89191, 6664),
+(89193, 6644),
+(89193, 6664),
+(89195, 6644),
+(89195, 6664),
+(114968, 9651),
+(116666, 9669),
+(65435, 5465),
+(85666, 6682),
+(69888, 6626),
+(62023, 6626),
+(62024, 6626),
+(62025, 6626),
+(62026, 6626),
+(62027, 6626),
+(62029, 6626),
+(71033, 5840),
+(65498, 5024),
+(120352, 9388),
+(64398, 5143),
+(64401, 5143),
+(64399, 5422),
+(64402, 5422),
+(64400, 4860),
+(63359, 4860),
+(65274, 5035),
+(65360, 5035),
+(85508, 7448),
+(85509, 7448),
+(85510, 7448),
+(85508, 7449),
+(85509, 7449),
+(85510, 7449),
+(63352, 4989),
+(63353, 4989),
+(62799, 5467),
+(62800, 5036),
+(62286, 5196),
+(62287, 5158),
+(62287, 4949),
+(68136, 5152),
+(68136, 4949),
+(65361, 5031),
+(65362, 5179),
+(65363, 5201),
+(65364, 5201),
+(63398, 5144),
+(63125, 4988),
+(63138, 5812),
+(63138, 5892);