sql/Pg-upgrade2/custom_variable_partsgroups.sql

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