Pflichtenhefttextblöcke (DB): Spalte "is_flagged"

diff --git a/SL/DB/MetaSetup/RequirementSpecTextBlock.pm b/SL/DB/MetaSetup/RequirementSpecTextBlock.pm
index adb203e71cb4bd014ff4b338064a2059a40c53e7..426fac092452b22ea95005cb616a38ea03ba465c 100644 (file)
--- a/SL/DB/MetaSetup/RequirementSpecTextBlock.pm
+++ b/SL/DB/MetaSetup/RequirementSpecTextBlock.pm
@@ -18,11 +18,19 @@ __PACKAGE__->meta->setup(
     output_position     => { type => 'integer', default => 1, not_null => 1 },
     itime               => { type => 'timestamp', default => 'now()', not_null => 1 },
     mtime               => { type => 'timestamp' },
     output_position     => { type => 'integer', default => 1, not_null => 1 },
     itime               => { type => 'timestamp', default => 'now()', not_null => 1 },
     mtime               => { type => 'timestamp' },

+    is_flagged          => { type => 'boolean', default => 'false', not_null => 1 },

   ],
 
   primary_key_columns => [ 'id' ],
 
   allow_inline_column_values => 1,
   ],
 
   primary_key_columns => [ 'id' ],
 
   allow_inline_column_values => 1,

+
+  foreign_keys => [
+    requirement_spec => {
+      class       => 'SL::DB::RequirementSpec',
+      key_columns => { requirement_spec_id => 'id' },
+    },
+  ],

 );
 
 1;
 );
 
 1;

diff --git a/SL/DB/RequirementSpecTextBlock.pm b/SL/DB/RequirementSpecTextBlock.pm
index b89eacccfc6ecc23a1f7126e86b1695d4bc9534c..1db8623138c803a69f8d6819134182104c8ca8a1 100644 (file)
--- a/SL/DB/RequirementSpecTextBlock.pm
+++ b/SL/DB/RequirementSpecTextBlock.pm
@@ -7,14 +7,6 @@ use SL::DB::Manager::RequirementSpecTextBlock;
 use SL::DB::Helper::ActsAsList;
 use SL::Locale::String;
 
 use SL::DB::Helper::ActsAsList;
 use SL::Locale::String;
 

-__PACKAGE__->meta->add_relationships(
-  requirement_spec => {
-    type           => 'one to many',
-    class          => 'SL::DB::RequirementSpec',
-    column_map     => { requirement_spec_id => 'id' },
-  },
-);
-

 __PACKAGE__->meta->initialize;
 
 __PACKAGE__->configure_acts_as_list(group_by => [qw(requirement_spec_id output_position)]);
 __PACKAGE__->meta->initialize;
 
 __PACKAGE__->configure_acts_as_list(group_by => [qw(requirement_spec_id output_position)]);

diff --git a/sql/Pg-upgrade2/requirement_specs.sql b/sql/Pg-upgrade2/requirement_specs.sql
index 9271732e4a5bec872a55f520a1e3a55f0380b9b5..86a3c50225016915444d3104f2034d1b3c9cd25a 100644 (file)
--- a/sql/Pg-upgrade2/requirement_specs.sql
+++ b/sql/Pg-upgrade2/requirement_specs.sql
@@ -189,6 +189,7 @@ CREATE TABLE requirement_spec_text_blocks (
        text                TEXT,
        position            INTEGER   NOT NULL,
        output_position     INTEGER   NOT NULL DEFAULT 1,
        text                TEXT,
        position            INTEGER   NOT NULL,
        output_position     INTEGER   NOT NULL DEFAULT 1,

+       is_flagged          BOOLEAN   NOT NULL DEFAULT FALSE,

        itime               TIMESTAMP NOT NULL DEFAULT now(),
        mtime               TIMESTAMP,
 
        itime               TIMESTAMP NOT NULL DEFAULT now(),
        mtime               TIMESTAMP,