shop_item_generator_rule

CREATE TABLE shop_item_generator_rule (
  identifier             integer NOT NULL PRIMARY KEY,
  users                  integer NOT NULL REFERENCES users(identifier),
  shop_item              integer NOT NULL REFERENCES shop_item(identifier),
  price                  numeric,
  currency               integer REFERENCES currency(identifier),
  comment                text,
  date_of_creation       timestamp,
  date_of_last_edit      timestamp
);

• currency references currency(identifier)
• shop_item references shop_item(identifier)
• users references users(identifier)

None.

• shop_item_generator_rule_id_sequence

None.

None.

• view_shop_item_generator_rule

Version 2.26

Version 2.33

= Version 2.26 =

CREATE TABLE shop_item_generator_rule (
  identifier             integer NOT NULL PRIMARY KEY,
  users                  integer NOT NULL REFERENCES users(identifier),
  shop_item              integer NOT NULL REFERENCES shop_item(identifier),
  price                  numeric,
  currency               integer REFERENCES currency(identifier),
  comment                text,
  date_of_creation       timestamp,
  date_of_last_edit      timestamp
);

= Version 2.34 =

DROP TABLE shop_item_generator_rule;