Pflichtenhefte: type_id darf nicht NULL sein

diff --git a/SL/DB/MetaSetup/RequirementSpec.pm b/SL/DB/MetaSetup/RequirementSpec.pm
index 448816a88d21124d8e3eab7d940eb5a3a7d26af1..667f39a6bf67126990d6e106597da6b70cf03e04 100644 (file)
--- a/SL/DB/MetaSetup/RequirementSpec.pm
+++ b/SL/DB/MetaSetup/RequirementSpec.pm
@@ -22,7 +22,7 @@ __PACKAGE__->meta->columns(
   status_id               => { type => 'integer' },
   time_estimation         => { type => 'numeric', default => '0', not_null => 1, precision => 12, scale => 2 },
   title                   => { type => 'text', not_null => 1 },
   status_id               => { type => 'integer' },
   time_estimation         => { type => 'numeric', default => '0', not_null => 1, precision => 12, scale => 2 },
   title                   => { type => 'text', not_null => 1 },

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

   working_copy_id         => { type => 'integer' },
 );
 
   working_copy_id         => { type => 'integer' },
 );
 

diff --git a/sql/Pg-upgrade2/requirement_spec_type_for_template_fix.sql b/sql/Pg-upgrade2/requirement_spec_type_for_template_fix.sql
new file mode 100644 (file)
index 0000000..a786439
--- /dev/null
+++ b/sql/Pg-upgrade2/requirement_spec_type_for_template_fix.sql
@@ -0,0 +1,11 @@
+-- @tag: requirement_spec_type_for_template_fix
+-- @description: requirement_spec_type_for_template_fix
+-- @depends: requirement_spec_types_number_formats
+UPDATE requirement_specs
+SET type_id = (
+  SELECT MIN(id)
+  FROM requirement_spec_types
+)
+WHERE type_id IS NULL;
+
+ALTER TABLE requirement_specs ALTER COLUMN type_id SET NOT NULL;