summaryrefslogtreecommitdiff
path: root/sql-files/upgrade_svn12581.sql
blob: 9b487d5e18e565c54b51374f6e9a3ce8090f4022 (plain) (blame)
1
2
3
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`);