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