X-Git-Url: http://wagnertech.de/gitweb/gitweb.cgi/mfinanz.git/blobdiff_plain/1ae7f9a1d11944a7e9c64ea791540b95db729e9a..48251373c2b436f9c922cb67c455d1f7f24e7a0c:/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 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;