]>
iEval git - app-web-oof.git/blob - db.sql
1 CREATE TABLE IF NOT EXISTS products (
2 product serial
PRIMARY KEY,
4 subtitle
TEXT NOT NULL,
8 freepost
BOOLEAN NOT NULL DEFAULT FALSE,
11 CONSTRAINT positive_stock
CHECK (stock
>= 0)
14 CREATE TABLE IF NOT EXISTS discounts (
15 discount
VARCHAR(20) PRIMARY KEY,
18 CONSTRAINT fraction_xor_flat
CHECK ((fraction
IS NULL AND flat
IS NOT NULL) OR (fraction
IS NOT NULL AND flat
IS NULL))
21 CREATE TABLE IF NOT EXISTS orders (
24 products JSON
NOT NULL,
26 discount
VARCHAR(20) REFERENCES discounts
UNIQUE,
31 first_name
VARCHAR(20) NOT NULL,
32 last_name
VARCHAR(20) NOT NULL,
33 email
VARCHAR(80) NOT NULL,
35 postcode
VARCHAR(10) NOT NULL,
36 address1
VARCHAR(32) NOT NULL,
40 safe_place
VARCHAR(32),
41 instructions
VARCHAR(32)
This page took 0.049345 seconds and 5 git commands to generate.