sql/Pg-upgrade2/requirement_spec_predefined_texts_for_sections.sql

   1 -- @tag: requirement_spec_predefined_texts_for_sections
   2 -- @description: Verwendung von vordefinierten Pflichtenhefttextblöcken bei Abschnitten
   3 -- @depends: requirement_specs
   4 ALTER TABLE requirement_spec_predefined_texts ADD COLUMN useable_for_text_blocks BOOLEAN;
   5 ALTER TABLE requirement_spec_predefined_texts ADD COLUMN useable_for_sections    BOOLEAN;
   6
   7 UPDATE requirement_spec_predefined_texts
   8 SET useable_for_text_blocks = TRUE, useable_for_sections = FALSE;
   9
  10 ALTER TABLE requirement_spec_predefined_texts ALTER COLUMN useable_for_text_blocks SET DEFAULT FALSE;
  11 ALTER TABLE requirement_spec_predefined_texts ALTER COLUMN useable_for_sections    SET DEFAULT FALSE;
  12
  13 ALTER TABLE requirement_spec_predefined_texts ALTER COLUMN useable_for_text_blocks SET NOT NULL;
  14 ALTER TABLE requirement_spec_predefined_texts ALTER COLUMN useable_for_sections    SET NOT NULL;