X-Git-Url: http://git.ieval.ro/?a=blobdiff_plain;f=db.sql;h=eaff6f267247e5ce77fdfbca403424ce3c0e5cf0;hb=0c3c4e708d0264e803583a4ac497e8e8e519b128;hp=56edc0959d8cadfd863f976b076ee6c6f4da5254;hpb=6e33dd6846a44f56a5c8bd187f0a89e4893c7b4a;p=app-web-oof.git

diff --git a/db.sql b/db.sql
index 56edc09..eaff6f2 100644
--- a/db.sql
+++ b/db.sql
@@ -1,11 +1,11 @@
 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)
 );
 
@@ -22,6 +22,8 @@ CREATE TABLE IF NOT EXISTS orders (
 	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,