User Tools

Site Tools


podoc:shop_order_sql_table

Database Table Description of "shop_order"

Name

shop_order

Description

Purpose

Schema

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
);

References tables

Is referenced by tables

None.

None.

None.

History

Used first

Version 2.8

Used last

Version 2.33

Schema change history

= 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;
Data change history

= Version 2.19 =

UPDATE shop_order SET download_counter = 0;
UPDATE shop_order SET download_expiry_date = now();
podoc/shop_order_sql_table.txt · Last modified: 2007/10/19 11:52 by Luud