Add free postage

[app-web-oof.git] / db.sql

diff --git a/db.sql b/db.sql
index d8691f4d5cafa479137ca5a2c27f2c3f5ef1ff26..eaff6f267247e5ce77fdfbca403424ce3c0e5cf0 100644 (file)
--- a/db.sql
+++ b/db.sql
@@ -1,10 +1,11 @@
 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)
 );