shop_order

CREATE TABLE shop_order (
  identifier            integer NOT NULL PRIMARY KEY,
  client                integer REFERENCES users(identifier),
  transaction           integer REFERENCES shop_transaction,
  item                  integer NOT NULL REFERENCES photo_item,
  pieces                numeric,
  date_of_creation      timestamp,
  date_of_last_edit     timestamp,
  download_counter      integer,
  download_expiry_date  date
);

• client references users(identifier)
• item references photo_item(identifier)
• transaction references shop_transaction(identifier)

None.

• shop_order_id_sequence

None.

• photo_shop_transaction_references

None.

Version 2.8

Version 2.33

= Version 2.8 =

CREATE TABLE shop_order (
  identifier            integer NOT NULL PRIMARY KEY,
  client                integer REFERENCES users(identifier),
  transaction           integer REFERENCES shop_transaction,
  item                  integer NOT NULL REFERENCES photo_item,
  pieces                numeric,
  date_of_creation      timestamp,
  date_of_last_edit     timestamp
);

= Version 2.19 =

ALTER TABLE shop_order ADD COLUMN download_counter integer;
ALTER TABLE shop_order ADD COLUMN download_expiry_date date;

= Version 2.34 =

DROP TABLE shop_order;

= Version 2.19 =

UPDATE shop_order SET download_counter = 0;
UPDATE shop_order SET download_expiry_date = now();