CREATE TABLE IF NOT EXISTS products (
- product serial PRIMARY KEY,
- title TEXT NOT NULL,
- subtitle TEXT NOT NULL,
- summary TEXT NOT NULL,
- pictures TEXT[] 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,
CONSTRAINT positive_stock CHECK (stock >= 0)
);
total INT NOT NULL,
discount VARCHAR(20) REFERENCES discounts UNIQUE,
+ stripe_token TEXT,
+
-- DELIVERY
first_name VARCHAR(20) NOT NULL,
last_name VARCHAR(20) NOT NULL,