1 -- @tag: project_status_default_entries
2 -- @description: Standardeinträge für Projektstatus
3 -- @depends: project_bob_attributes_fix_project_status_table_name
5 INSERT INTO project_statuses (name, description, position) VALUES ('presales', 'Akquise', 1);
6 INSERT INTO project_statuses (name, description, position) VALUES ('planning', 'In Planung', 2);
7 INSERT INTO project_statuses (name, description, position) VALUES ('running', 'In Bearbeitung', 3);
8 INSERT INTO project_statuses (name, description, position) VALUES ('done', 'Fertiggestellt', 4);
11 SET project_status_id = (
14 WHERE name = 'running'
16 WHERE project_status_id IS NULL;
18 ALTER TABLE project ALTER COLUMN project_status_id SET NOT NULL;