kivitendo/sql/Pg-upgrade2/price_rules.sql @ 3d1e5731
| 9589ecd7 | Sven Schöling | -- @tag: price_rules
|
|
-- @description: Preismatrix Tabellen
|
|||
-- @depends: release_3_1_0
|
|||
CREATE TABLE price_rules (
|
|||
id SERIAL PRIMARY KEY,
|
|||
name TEXT,
|
|||
type TEXT,
|
|||
priority INTEGER NOT NULL DEFAULT 3,
|
|||
price NUMERIC(15,5),
|
|||
discount NUMERIC(15,5),
|
|||
obsolete BOOLEAN NOT NULL DEFAULT FALSE,
|
|||
itime TIMESTAMP,
|
|||
mtime TIMESTAMP
|
|||
);
|
|||
CREATE TABLE price_rule_items (
|
|||
id SERIAL PRIMARY KEY,
|
|||
price_rules_id INTEGER NOT NULL,
|
|||
type TEXT,
|
|||
op TEXT,
|
|||
custom_variable_configs_id INTEGER,
|
|||
value_text TEXT,
|
|||
value_int INTEGER,
|
|||
value_date DATE,
|
|||
value_num NUMERIC(15,5),
|
|||
itime TIMESTAMP,
|
|||
mtime TIMESTAMP,
|
|||
FOREIGN KEY (price_rules_id) REFERENCES price_rules (id),
|
|||
FOREIGN KEY (custom_variable_configs_id) REFERENCES custom_variable_configs (id)
|
|||
);
|
|||
CREATE TRIGGER mtime_price_rules BEFORE UPDATE ON price_rules FOR EACH ROW EXECUTE PROCEDURE set_mtime();
|
|||
CREATE TRIGGER mtime_price_rule_items BEFORE UPDATE ON price_rule_items FOR EACH ROW EXECUTE PROCEDURE set_mtime();
|