1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
|
ALTER TABLE artifact_group_selection_box_list RENAME TO artifact_extra_field_list;
ALTER TABLE artifact_extra_field_list RENAME COLUMN selection_box_name TO field_name;
ALTER TABLE artifact_extra_field_list ADD COLUMN field_type INT;
ALTER TABLE artifact_extra_field_list ALTER COLUMN field_type SET DEFAULT 1;
ALTER TABLE artifact_extra_field_list ADD COLUMN attribute1 INT;
ALTER TABLE artifact_extra_field_list ALTER COLUMN attribute1 SET DEFAULT 0;
ALTER TABLE artifact_extra_field_list ADD COLUMN attribute2 INT;
ALTER TABLE artifact_extra_field_list ALTER COLUMN attribute2 SET DEFAULT 0;
UPDATE artifact_extra_field_list SET field_type=1,attribute1=0,attribute2=0; --set all to pop-up box
ALTER TABLE artifact_group_selection_box_options RENAME TO artifact_extra_field_elements;
ALTER TABLE artifact_extra_field_elements RENAME COLUMN box_options_name TO element_name;
ALTER TABLE artifact_extra_field_data ADD COLUMN field_data text;
UPDATE artifact_extra_field_data SET field_data=choice_id;
ALTER TABLE artifact_extra_field_data DROP COLUMN choice_id;
ALTER TABLE artifact_extra_field_data ADD COLUMN extra_field_id int;
ALTER TABLE artifact_extra_field_data ALTER COLUMN extra_field_id SET DEFAULT 0;
update artifact_extra_field_data SET extra_field_id=0;
ALTER TABLE artifact_extra_field_list RENAME COLUMN id TO extra_field_id;
ALTER TABLE artifact_extra_field_elements RENAME COLUMN artifact_box_id TO extra_field_id;
ALTER TABLE artifact_extra_field_elements RENAME COLUMN id TO element_id;
ALTER TABLE artifact_extra_field_data RENAME COLUMN id TO data_id;
|
