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,
CONSTRAINT positive_stock CHECK (stock >= 0)
);