From 1ab415cc0657ac2f567438a7c421983f74cb00c9 Mon Sep 17 00:00:00 2001 From: Shauren Date: Fri, 30 Jul 2010 21:15:19 +0200 Subject: Fixed naming of SQL files --HG-- branch : trunk rename : sql/updates/9081_access_requirement.sql => sql/updates/9081_world_access_requirement.sql rename : sql/updates/9081_areatrigger_teleport.sql => sql/updates/9081_world_areatrigger_teleport.sql --- sql/updates/9081_access_requirement.sql | 12 ------------ sql/updates/9081_areatrigger_teleport.sql | 1 - sql/updates/9081_world_access_requirement.sql | 12 ++++++++++++ sql/updates/9081_world_areatrigger_teleport.sql | 1 + 4 files changed, 13 insertions(+), 13 deletions(-) delete mode 100644 sql/updates/9081_access_requirement.sql delete mode 100644 sql/updates/9081_areatrigger_teleport.sql create mode 100644 sql/updates/9081_world_access_requirement.sql create mode 100644 sql/updates/9081_world_areatrigger_teleport.sql (limited to 'sql') diff --git a/sql/updates/9081_access_requirement.sql b/sql/updates/9081_access_requirement.sql deleted file mode 100644 index da7e108636a..00000000000 --- a/sql/updates/9081_access_requirement.sql +++ /dev/null @@ -1,12 +0,0 @@ -ALTER TABLE `access_requirement` - DROP PRIMARY KEY, - CHANGE `id` `mapId` mediumint(8) unsigned NOT NULL FIRST, - ADD `difficulty` tinyint(3) unsigned NOT NULL DEFAULT '0' AFTER `mapId`, - DROP `heroic_level_min`, - DROP `heroic_key`, - DROP `heroic_key2`, - CHANGE `quest_done` `quest_done_A` mediumint(8) unsigned NOT NULL DEFAULT '0' AFTER `item2`, - CHANGE `heroic_quest_done` `quest_done_H` mediumint(8) unsigned NOT NULL DEFAULT '0' AFTER `quest_done_A`, - ADD `completed_achievement` mediumint(8) unsigned NOT NULL DEFAULT '0' AFTER `quest_done_H`, - DROP `heroic_quest_failed_text`, - ADD PRIMARY KEY(`mapId`,`difficulty`); diff --git a/sql/updates/9081_areatrigger_teleport.sql b/sql/updates/9081_areatrigger_teleport.sql deleted file mode 100644 index d8df8fafbf9..00000000000 --- a/sql/updates/9081_areatrigger_teleport.sql +++ /dev/null @@ -1 +0,0 @@ -ALTER TABLE `areatrigger_teleport` DROP `access_id`; diff --git a/sql/updates/9081_world_access_requirement.sql b/sql/updates/9081_world_access_requirement.sql new file mode 100644 index 00000000000..da7e108636a --- /dev/null +++ b/sql/updates/9081_world_access_requirement.sql @@ -0,0 +1,12 @@ +ALTER TABLE `access_requirement` + DROP PRIMARY KEY, + CHANGE `id` `mapId` mediumint(8) unsigned NOT NULL FIRST, + ADD `difficulty` tinyint(3) unsigned NOT NULL DEFAULT '0' AFTER `mapId`, + DROP `heroic_level_min`, + DROP `heroic_key`, + DROP `heroic_key2`, + CHANGE `quest_done` `quest_done_A` mediumint(8) unsigned NOT NULL DEFAULT '0' AFTER `item2`, + CHANGE `heroic_quest_done` `quest_done_H` mediumint(8) unsigned NOT NULL DEFAULT '0' AFTER `quest_done_A`, + ADD `completed_achievement` mediumint(8) unsigned NOT NULL DEFAULT '0' AFTER `quest_done_H`, + DROP `heroic_quest_failed_text`, + ADD PRIMARY KEY(`mapId`,`difficulty`); diff --git a/sql/updates/9081_world_areatrigger_teleport.sql b/sql/updates/9081_world_areatrigger_teleport.sql new file mode 100644 index 00000000000..d8df8fafbf9 --- /dev/null +++ b/sql/updates/9081_world_areatrigger_teleport.sql @@ -0,0 +1 @@ +ALTER TABLE `areatrigger_teleport` DROP `access_id`; -- cgit v1.2.3