X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=sql%2FPg-upgrade2%2Fproject_status_default_entries.sql;h=5120b6ad919187171b065a852c1a686796bce6e1;hb=fa0c33348c090ddc68edb8ca9131c70fd1365095;hp=0a5e151ee71077b4756169f22ffa40f1f247fbe4;hpb=73816905c58dc0b2bcfde5dc27011c3cc483faa6;p=kivitendo-erp.git

diff --git a/sql/Pg-upgrade2/project_status_default_entries.sql b/sql/Pg-upgrade2/project_status_default_entries.sql
index 0a5e151ee..5120b6ad9 100644
--- a/sql/Pg-upgrade2/project_status_default_entries.sql
+++ b/sql/Pg-upgrade2/project_status_default_entries.sql
@@ -1,8 +1,18 @@
 -- @tag: project_status_default_entries
 -- @description: Standardeinträge für Projektstatus
--- @depends: project_bob_attributes
+-- @depends: project_bob_attributes_fix_project_status_table_name
 
-INSERT INTO project_status (name, description, position) VALUES ('presales', 'Akquise',        1);
-INSERT INTO project_status (name, description, position) VALUES ('planning', 'In Planung',     2);
-INSERT INTO project_status (name, description, position) VALUES ('running',  'In Bearbeitung', 3);
-INSERT INTO project_status (name, description, position) VALUES ('done',     'Fertiggestellt', 4);
+INSERT INTO project_statuses (name, description, position) VALUES ('presales', 'Akquise',        1);
+INSERT INTO project_statuses (name, description, position) VALUES ('planning', 'In Planung',     2);
+INSERT INTO project_statuses (name, description, position) VALUES ('running',  'In Bearbeitung', 3);
+INSERT INTO project_statuses (name, description, position) VALUES ('done',     'Fertiggestellt', 4);
+
+UPDATE project
+SET project_status_id = (
+  SELECT id
+  FROM project_statuses
+  WHERE name = 'running'
+)
+WHERE project_status_id IS NULL;
+
+ALTER TABLE project ALTER COLUMN project_status_id SET NOT NULL;