diff options
| author | Shauren <none@none> | 2010-09-16 19:58:06 +0200 |
|---|---|---|
| committer | Shauren <none@none> | 2010-09-16 19:58:06 +0200 |
| commit | 05ccd476be9bf9047aff2d4ff8f5fc5d02dc81f1 (patch) | |
| tree | 1f13fc2d565d955aa3c354d54cf8c81ff3ad7f96 /sql | |
| parent | 502a81372078b3ec864ea98969f8afa9c53fd4dc (diff) | |
Core/Quests: Added index column for quest poi points forcing them to load in certain order
--HG--
branch : trunk
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/base/world_database.sql | 1 | ||||
| -rw-r--r-- | sql/updates/9958_world_quest_poi_points.sql | 1 |
2 files changed, 2 insertions, 0 deletions
diff --git a/sql/base/world_database.sql b/sql/base/world_database.sql index e73a3b1aab4..607278675fb 100644 --- a/sql/base/world_database.sql +++ b/sql/base/world_database.sql @@ -16255,6 +16255,7 @@ DROP TABLE IF EXISTS `quest_poi_points`; CREATE TABLE `quest_poi_points` ( `questId` int(10) UNSIGNED NOT NULL DEFAULT '0', `id` int(10) UNSIGNED NOT NULL DEFAULT '0', + `idx` int(10) unsigned NOT NULL DEFAULT '0', `x` int(10) NOT NULL DEFAULT '0', `y` int(10) NOT NULL DEFAULT '0', KEY `questId_id` (`questId`,`id`) diff --git a/sql/updates/9958_world_quest_poi_points.sql b/sql/updates/9958_world_quest_poi_points.sql new file mode 100644 index 00000000000..fa1962878a0 --- /dev/null +++ b/sql/updates/9958_world_quest_poi_points.sql @@ -0,0 +1 @@ +ALTER TABLE `quest_poi_points` ADD COLUMN `idx` int(10) unsigned NOT NULL DEFAULT '0' AFTER `id`; |