CREATE TABLE IF NOT EXISTS products (
- product serial PRIMARY KEY,
- title TEXT NOT NULL,
- subtitle TEXT NOT NULL,
- summary TEXT NOT NULL,
- price INT NOT NULL,
- stock INT NOT NULL,
+ product serial PRIMARY KEY,
+ title TEXT NOT NULL,
+ subtitle TEXT NOT NULL,
+ summary TEXT NOT NULL,
+ price INT NOT NULL,
+ stock INT NOT NULL,
+ freepost BOOLEAN NOT NULL DEFAULT FALSE,
+ model TEXT,
+ brand TEXT,
CONSTRAINT positive_stock CHECK (stock >= 0)
);
CREATE TABLE IF NOT EXISTS orders (
id TEXT PRIMARY KEY,
+ date BIGINT NOT NULL,
products JSON NOT NULL,
total INT NOT NULL,
discount VARCHAR(20) REFERENCES discounts UNIQUE,