diff options
Diffstat (limited to 'sql-files/upgrade_svn12581.sql')
| -rw-r--r-- | sql-files/upgrade_svn12581.sql | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/sql-files/upgrade_svn12581.sql b/sql-files/upgrade_svn12581.sql index ce2ffd989..9b487d5e1 100644 --- a/sql-files/upgrade_svn12581.sql +++ b/sql-files/upgrade_svn12581.sql @@ -1,3 +1,3 @@ -ALTER TABLE `quest_objective` ADD COLUMN `char_id` INTEGER UNSIGNED NOT NULL AFTER `num`,
- DROP PRIMARY KEY,
+ALTER TABLE `quest_objective` ADD COLUMN `char_id` INTEGER UNSIGNED NOT NULL AFTER `num`, + DROP PRIMARY KEY, ADD PRIMARY KEY USING BTREE(`quest_id`, `num`, `char_id`);
\ No newline at end of file |