1 -- @tag: custom_variable_partsgroups
2 -- @description: Beziehung zwischen cvar configs und partsgroups für Filter nach Warengruppen
3 -- @depends: release_3_1_0
5 CREATE TABLE custom_variable_config_partsgroups (
6 custom_variable_config_id integer NOT NULL,
7 partsgroup_id integer NOT NULL,
9 itime timestamp DEFAULT now(),
12 FOREIGN KEY (custom_variable_config_id) REFERENCES custom_variable_configs(id),
13 FOREIGN KEY (partsgroup_id) REFERENCES partsgroup(id),
15 PRIMARY KEY(custom_variable_config_id, partsgroup_id)
18 CREATE TRIGGER mtime_custom_variable_config_partsgroups BEFORE UPDATE ON custom_variable_config_partsgroups
19 FOR EACH ROW EXECUTE PROCEDURE set_mtime();