Mercurial > hg > savane-forge
changeset 339:8710b49dd7cc
Tracker: import message ids
author | Sylvain Beucler <beuc@beuc.net> |
---|---|
date | Tue, 24 Aug 2010 23:34:55 +0200 |
parents | 514de37e0bcf |
children | bd527a3a0c68 |
files | migrate_old_savane.sql |
diffstat | 1 files changed, 15 insertions(+), 0 deletions(-) [+] |
line wrap: on
line diff
--- a/migrate_old_savane.sql +++ b/migrate_old_savane.sql @@ -579,6 +579,9 @@ FROM temp_bugs_field_usage JOIN savane_old.bugs_field USING (bug_field_id) WHERE group_id != 100; +-- TODO: import 'patch' +-- TODO: import 'support' +-- TODO: import 'task' DROP TABLE temp_bugs_field_usage; DROP TABLE temp_task_field_usage; @@ -605,6 +608,9 @@ order_id, status, email_ad, send_all_flag FROM savane_old.bugs_field_value JOIN savane_old.bugs_field USING (bug_field_id); +-- TODO: import 'patch' +-- TODO: import 'support' +-- TODO: import 'task' -- Specify "default" differently UPDATE tracker_fieldchoice SET group_id=NULL WHERE group_id=100; @@ -654,3 +660,12 @@ -- Specify "default" differently UPDATE tracker_item SET assigned_to_id=NULL WHERE assigned_to_id=100; UPDATE tracker_item SET submitted_by_id=NULL WHERE submitted_by_id=100; + +-- Message IDs +TRUNCATE tracker_itemmsgid; +INSERT INTO tracker_itemmsgid + (item_id, msg_id) + SELECT tracker_item.internal_id, msg_id + FROM savane_old.trackers_msgid JOIN tracker_item + ON (savane_old.trackers_msgid.item_id = tracker_item.public_bugs_id + AND savane_old.trackers_msgid.artifact = tracker_item.tracker_id);