-- @tag: delivery_terms
-- @description: Neue Tabelle und Spalten für Lieferbedingungen
-- @depends: release_3_0_0

CREATE TABLE delivery_terms (
       id                        integer        NOT NULL DEFAULT nextval('id'),
       description               text,
       description_long          text,
       sortkey                   integer        NOT NULL,
       itime                     timestamp      DEFAULT now(),
       mtime                     timestamp,

       PRIMARY KEY (id)
);

CREATE TRIGGER mtime_delivery_terms
    BEFORE UPDATE ON delivery_terms
    FOR EACH ROW
    EXECUTE PROCEDURE set_mtime();


ALTER TABLE oe                ADD COLUMN delivery_term_id integer;
ALTER TABLE oe                ADD FOREIGN KEY (delivery_term_id) REFERENCES delivery_terms(id);

ALTER TABLE delivery_orders   ADD COLUMN delivery_term_id integer;
ALTER TABLE delivery_orders   ADD FOREIGN KEY (delivery_term_id) REFERENCES delivery_terms(id);

ALTER TABLE ar                ADD COLUMN delivery_term_id integer;
ALTER TABLE ar                ADD FOREIGN KEY (delivery_term_id) REFERENCES delivery_terms(id);

ALTER TABLE ap                ADD COLUMN delivery_term_id integer;
ALTER TABLE ap                ADD FOREIGN KEY (delivery_term_id) REFERENCES delivery_terms(id);

ALTER TABLE customer          ADD COLUMN delivery_term_id integer;
ALTER TABLE customer          ADD FOREIGN KEY (delivery_term_id) REFERENCES delivery_terms(id);

ALTER TABLE vendor            ADD COLUMN delivery_term_id integer;
ALTER TABLE vendor            ADD FOREIGN KEY (delivery_term_id) REFERENCES delivery_terms(id);