PartPicker: auch nach ungültigen oder allen Artikeln suchen können.

[mfinanz.git] / sql / Pg-upgrade2 / project_status_default_entries.sql

diff --git a/sql/Pg-upgrade2/project_status_default_entries.sql b/sql/Pg-upgrade2/project_status_default_entries.sql
index d4bd437f4472e9659add13a74791f694322b4f1a..5120b6ad919187171b065a852c1a686796bce6e1 100644 (file)
--- a/sql/Pg-upgrade2/project_status_default_entries.sql
+++ b/sql/Pg-upgrade2/project_status_default_entries.sql
@@ -1,16 +1,16 @@
 -- @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_status
+  FROM project_statuses
   WHERE name = 'running'
 )
 WHERE project_status_id IS NULL;