Projekte: Status zum Pflichtfeld gemacht

diff --git a/SL/DB/MetaSetup/Project.pm b/SL/DB/MetaSetup/Project.pm
index 5b9926589afde4e2c2570db544aa75ba2c5abb31..9351a24b7aa2427cc8e22fa9677b7c7fdb2f4a0a 100644 (file)
--- a/SL/DB/MetaSetup/Project.pm
+++ b/SL/DB/MetaSetup/Project.pm
@@ -20,7 +20,7 @@ __PACKAGE__->meta->columns(
   itime                => { type => 'timestamp', default => 'now()' },
   mtime                => { type => 'timestamp' },
   order_value          => { type => 'numeric', default => '0', not_null => 1, precision => 5, scale => 15 },
   itime                => { type => 'timestamp', default => 'now()' },
   mtime                => { type => 'timestamp' },
   order_value          => { type => 'numeric', default => '0', not_null => 1, precision => 5, scale => 15 },

-  project_status_id    => { type => 'integer' },
+  project_status_id    => { type => 'integer', not_null => 1 },

   project_type_id      => { type => 'integer', not_null => 1 },
   projectnumber        => { type => 'text' },
   start_date           => { type => 'date' },
   project_type_id      => { type => 'integer', not_null => 1 },
   projectnumber        => { type => 'text' },
   start_date           => { type => 'date' },

diff --git a/sql/Pg-upgrade2/project_status_default_entries.sql b/sql/Pg-upgrade2/project_status_default_entries.sql
index 0a5e151ee71077b4756169f22ffa40f1f247fbe4..d4bd437f4472e9659add13a74791f694322b4f1a 100644 (file)
--- a/sql/Pg-upgrade2/project_status_default_entries.sql
+++ b/sql/Pg-upgrade2/project_status_default_entries.sql
@@ -6,3 +6,13 @@ INSERT INTO project_status (name, description, position) VALUES ('presales', 'Ak
 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_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);

+
+UPDATE project
+SET project_status_id = (
+  SELECT id
+  FROM project_status
+  WHERE name = 'running'
+)
+WHERE project_status_id IS NULL;
+
+ALTER TABLE project ALTER COLUMN project_status_id SET NOT NULL;