2 -- @description: Tabelle für Projekttypen
3 -- @depends: release_3_0_0
5 CREATE TABLE project_types (
7 position INTEGER NOT NULL,
13 INSERT INTO project_types (position, description) VALUES (1, 'Standard');
14 INSERT INTO project_types (position, description) VALUES (2, 'Festpreis');
15 INSERT INTO project_types (position, description) VALUES (3, 'Support');
17 ALTER TABLE project ADD COLUMN project_type_id INTEGER;
18 ALTER TABLE project ADD FOREIGN KEY (project_type_id) REFERENCES project_types (id);
20 UPDATE project SET project_type_id = (SELECT id FROM project_types WHERE description = 'Festpreis') WHERE type = 'Festpreis';
21 UPDATE project SET project_type_id = (SELECT id FROM project_types WHERE description = 'Support') WHERE type = 'Support';
22 UPDATE project SET project_type_id = (SELECT id FROM project_types WHERE description = 'Standard') WHERE project_type_id IS NULL;
24 ALTER TABLE project ALTER COLUMN project_type_id SET NOT NULL;
25 ALTER TABLE project DROP COLUMN type;