comparison migrate_old_savane.sql @ 308:006f6c019bc8

Field usage admin
author Sylvain Beucler <beuc@beuc.net>
date Sun, 15 Aug 2010 15:32:04 +0200
parents b503430e963a
children e80f63d8ddc3
comparison
equal deleted inserted replaced
307:b503430e963a 308:006f6c019bc8
590 conv_field_ids.new, group_id, use_it, show_on_add, show_on_add_members, place, 590 conv_field_ids.new, group_id, use_it, show_on_add, show_on_add_members, place,
591 custom_label, custom_description, custom_display_size, custom_empty_ok, 591 custom_label, custom_description, custom_display_size, custom_empty_ok,
592 IFNULL(custom_keep_history, 0), transition_default_auth 592 IFNULL(custom_keep_history, 0), transition_default_auth
593 FROM temp_bugs_field_usage JOIN conv_field_ids 593 FROM temp_bugs_field_usage JOIN conv_field_ids
594 ON (bug_field_id = old AND tracker_id = 'bugs'); 594 ON (bug_field_id = old AND tracker_id = 'bugs');
595 -- Specify "default" differently
596 UPDATE tracker_fieldusage SET group_id=NULL WHERE group_id=100;
595 DROP TABLE temp_bugs_field_usage; 597 DROP TABLE temp_bugs_field_usage;