X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=sql%2FPg-upgrade2%2Fproject_status_default_entries.sql;h=5120b6ad919187171b065a852c1a686796bce6e1;hb=d1d70f4ad540f4d57d1b577b337b6db38074e223;hp=d4bd437f4472e9659add13a74791f694322b4f1a;hpb=1ae7f9a1d11944a7e9c64ea791540b95db729e9a;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 d4bd437f4..5120b6ad9 100644 --- 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;