1 -- @tag: customer_additional_billing_addresses
2 -- @description: Kundenstammdaten: zusätzliche Rechnungsadressen
3 -- @depends: release_3_5_8
4 CREATE TABLE additional_billing_addresses (
19 default_address BOOLEAN NOT NULL DEFAULT FALSE,
21 itime TIMESTAMP NOT NULL DEFAULT now(),
22 mtime TIMESTAMP NOT NULL DEFAULT now(),
25 FOREIGN KEY (customer_id) REFERENCES customer (id)
28 CREATE TRIGGER mtime_additional_billing_addresses
29 BEFORE UPDATE ON additional_billing_addresses
30 FOR EACH ROW EXECUTE PROCEDURE set_mtime();
33 ADD COLUMN billing_address_id INTEGER,
34 ADD FOREIGN KEY (billing_address_id)
35 REFERENCES additional_billing_addresses (id);
37 ALTER TABLE delivery_orders
38 ADD COLUMN billing_address_id INTEGER,
39 ADD FOREIGN KEY (billing_address_id)
40 REFERENCES additional_billing_addresses (id);
43 ADD COLUMN billing_address_id INTEGER,
44 ADD FOREIGN KEY (billing_address_id)
45 REFERENCES additional_billing_addresses (id);