diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/7469_world_locales_quest.sql | 8 | ||||
| -rw-r--r-- | sql/updates/7469_world_quest_template.sql | 1 | ||||
| -rw-r--r-- | sql/world.sql | 10 |
3 files changed, 18 insertions, 1 deletions
diff --git a/sql/updates/7469_world_locales_quest.sql b/sql/updates/7469_world_locales_quest.sql new file mode 100644 index 00000000000..b5826709dff --- /dev/null +++ b/sql/updates/7469_world_locales_quest.sql @@ -0,0 +1,8 @@ +ALTER TABLE locales_quest ADD COLUMN CompletedText_loc1 text AFTER EndText_loc8; +ALTER TABLE locales_quest ADD COLUMN CompletedText_loc2 text AFTER CompletedText_loc1; +ALTER TABLE locales_quest ADD COLUMN CompletedText_loc3 text AFTER CompletedText_loc2; +ALTER TABLE locales_quest ADD COLUMN CompletedText_loc4 text AFTER CompletedText_loc3; +ALTER TABLE locales_quest ADD COLUMN CompletedText_loc5 text AFTER CompletedText_loc4; +ALTER TABLE locales_quest ADD COLUMN CompletedText_loc6 text AFTER CompletedText_loc5; +ALTER TABLE locales_quest ADD COLUMN CompletedText_loc7 text AFTER CompletedText_loc6; +ALTER TABLE locales_quest ADD COLUMN CompletedText_loc8 text AFTER CompletedText_loc7; diff --git a/sql/updates/7469_world_quest_template.sql b/sql/updates/7469_world_quest_template.sql new file mode 100644 index 00000000000..5a48ff5720d --- /dev/null +++ b/sql/updates/7469_world_quest_template.sql @@ -0,0 +1 @@ +ALTER TABLE quest_template CHANGE CompletionText CompletedText TEXT NULL DEFAULT NULL; diff --git a/sql/world.sql b/sql/world.sql index 41844b7b785..2dcb737b40c 100644 --- a/sql/world.sql +++ b/sql/world.sql @@ -3353,6 +3353,14 @@ CREATE TABLE `locales_quest` ( `EndText_loc6` text, `EndText_loc7` text, `EndText_loc8` text, + `CompletedText_loc1` text, + `CompletedText_loc2` text, + `CompletedText_loc3` text, + `CompletedText_loc4` text, + `CompletedText_loc5` text, + `CompletedText_loc6` text, + `CompletedText_loc7` text, + `CompletedText_loc8` text, `ObjectiveText1_loc1` text, `ObjectiveText1_loc2` text, `ObjectiveText1_loc3` text, @@ -4392,7 +4400,7 @@ CREATE TABLE `quest_template` ( `OfferRewardText` text DEFAULT NULL, `RequestItemsText` text DEFAULT NULL, `EndText` text DEFAULT NULL, - `CompletionText` text DEFAULT NULL, + `CompletedText` text DEFAULT NULL, `ObjectiveText1` text DEFAULT NULL, `ObjectiveText2` text DEFAULT NULL, `ObjectiveText3` text DEFAULT NULL, |