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;
7 UPDATE requirement_spec_predefined_texts
8 SET useable_for_text_blocks = TRUE, useable_for_sections = FALSE;
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;
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;