diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/base/characters_database.sql | 2 | ||||
| -rw-r--r-- | sql/base/world_database.sql | 14 | ||||
| -rw-r--r-- | sql/updates/9081_access_requirement.sql | 12 | ||||
| -rw-r--r-- | sql/updates/9081_areatrigger_teleport.sql | 1 | ||||
| -rw-r--r-- | sql/updates/9081_characters_characters.sql | 1 |
5 files changed, 21 insertions, 9 deletions
diff --git a/sql/base/characters_database.sql b/sql/base/characters_database.sql index 16ed16de332..7bd03bffb07 100644 --- a/sql/base/characters_database.sql +++ b/sql/base/characters_database.sql @@ -342,7 +342,7 @@ CREATE TABLE `characters` ( `position_z` float NOT NULL default '0', `map` int(11) unsigned NOT NULL default '0' COMMENT 'Map Identifier', `instance_id` int(11) unsigned NOT NULL default '0', - `dungeon_difficulty` tinyint(1) unsigned NOT NULL default '0', + `instance_mode_mask` tinyint(2) unsigned NOT NULL default '0', `orientation` float NOT NULL default '0', `taximask` longtext, `online` tinyint(3) unsigned NOT NULL default '0', diff --git a/sql/base/world_database.sql b/sql/base/world_database.sql index 7720b40f901..efca1c78603 100644 --- a/sql/base/world_database.sql +++ b/sql/base/world_database.sql @@ -25,20 +25,18 @@ DROP TABLE IF EXISTS `access_requirement`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `access_requirement` ( - `id` bigint(20) unsigned NOT NULL COMMENT 'Identifier', + `mapId` mediumint(8) unsigned NOT NULL, + `difficulty` tinyint(3) unsigned NOT NULL DEFAULT '0', `level_min` tinyint(3) unsigned NOT NULL DEFAULT '0', - `heroic_level_min` tinyint(3) unsigned NOT NULL DEFAULT '0', `level_max` tinyint(3) unsigned NOT NULL DEFAULT '0', `item` mediumint(8) unsigned NOT NULL DEFAULT '0', `item2` mediumint(8) unsigned NOT NULL DEFAULT '0', - `heroic_key` mediumint(8) unsigned NOT NULL DEFAULT '0', - `heroic_key2` mediumint(8) unsigned NOT NULL DEFAULT '0', - `quest_done` mediumint(8) unsigned NOT NULL DEFAULT '0', + `quest_done_A` mediumint(8) unsigned NOT NULL DEFAULT '0', + `quest_done_H` mediumint(8) unsigned NOT NULL DEFAULT '0', + `completed_achievement` mediumint(8) unsigned NOT NULL DEFAULT '0', `quest_failed_text` text, - `heroic_quest_done` mediumint(8) unsigned NOT NULL DEFAULT '0', - `heroic_quest_failed_text` text, `comment` text, - PRIMARY KEY (`id`) + PRIMARY KEY (`mapId`,`difficulty`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Access Requirements'; /*!40101 SET character_set_client = @saved_cs_client */; diff --git a/sql/updates/9081_access_requirement.sql b/sql/updates/9081_access_requirement.sql new file mode 100644 index 00000000000..da7e108636a --- /dev/null +++ b/sql/updates/9081_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_areatrigger_teleport.sql b/sql/updates/9081_areatrigger_teleport.sql new file mode 100644 index 00000000000..d8df8fafbf9 --- /dev/null +++ b/sql/updates/9081_areatrigger_teleport.sql @@ -0,0 +1 @@ +ALTER TABLE `areatrigger_teleport` DROP `access_id`; diff --git a/sql/updates/9081_characters_characters.sql b/sql/updates/9081_characters_characters.sql new file mode 100644 index 00000000000..1e7b32e47a5 --- /dev/null +++ b/sql/updates/9081_characters_characters.sql @@ -0,0 +1 @@ +ALTER TABLE `characters` CHANGE `dungeon_difficulty` `instance_mode_mask` tinyint(2) UNSIGNED NOT NULL DEFAULT 0 AFTER `instance_id`; |