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