kivitendo/sql/Pg-upgrade2/delivery_terms.sql @ bf5e6c6a
| 03d3d025 | Bernd Bleßmann | -- @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);
|