summaryrefslogtreecommitdiff
path: root/sql-files/upgrade_svn12581.sql
blob: 8953b02a22b154a9a2879bf29700bada0c6382b6 (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`);