projekt kivitendo

-- @tag: project_bob_attributes

-- @description: Projekte: Zusätzliche Tabellen und Spalten

-- @depends:  project_customer_type_valid

-- changes over bob:

-- no scon/support_contract values here

CREATE TRIGGER mtime_project_roles             BEFORE UPDATE ON project_roles              FOR EACH ROW EXECUTE PROCEDURE set_mtime();

CREATE TRIGGER mtime_project_participants      BEFORE UPDATE ON project_participants       FOR EACH ROW EXECUTE PROCEDURE set_mtime();

CREATE TRIGGER mtime_project_phase_paticipants BEFORE UPDATE ON project_phase_participants FOR EACH ROW EXECUTE PROCEDURE set_mtime();

-- @tag: project_types

-- @description: Tabelle für Projekttypen

-- @depends: release_3_0_0

CREATE TABLE project_types (

       id                       SERIAL,

       position                 INTEGER NOT NULL,

-- @tag: requirement_specs

-- @description: Pflichtenhefte

-- @depends: release_3_0_0

-- Nur für Entwicklungszwecke:

-- @tag: requirement_specs_section_templates

-- @description: requirement_specs_section_templates

-- @depends: release_3_0_0 requirement_specs

ALTER TABLE requirement_specs ALTER COLUMN type_id     DROP NOT NULL;

ALTER TABLE requirement_specs ALTER COLUMN status_id   DROP NOT NULL;