-- @tag: oe_version
-- @description: Hilfstabelle für Versionierungen von Angeboten und Aufträgen
-- @depends: release_3_6_0
-- @ignore: 0
      CREATE TABLE oe_version (
        oe_id                   integer,
        version                 INTEGER NOT NULL,
        final_version           BOOLEAN DEFAULT FALSE,
        email_journal_id        integer,
        file_id                 integer,
        itime                   TIMESTAMP      DEFAULT now(),
        mtime                   TIMESTAMP,
        PRIMARY KEY (oe_id, version),
        FOREIGN KEY (oe_id)                    REFERENCES oe (id),
        FOREIGN KEY (email_journal_id)         REFERENCES email_journal (id),
        FOREIGN KEY (file_id)                  REFERENCES files (id));

CREATE TRIGGER mtime_oe_version BEFORE UPDATE ON oe_version FOR EACH ROW EXECUTE PROCEDURE set_mtime();