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