X-Git-Url: http://git.ieval.ro/?a=blobdiff_plain;f=db.sql;h=b75393541c351806d651a4e6237061881a6b89a1;hb=18be372d0e707ca97b1dfa596917884d0f382e3a;hp=d8691f4d5cafa479137ca5a2c27f2c3f5ef1ff26;hpb=1576fc41a34d75269ba8408db99104855edbba11;p=app-web-oof.git

diff --git a/db.sql b/db.sql
index d8691f4..b753935 100644
--- 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)
 );
 
@@ -17,6 +18,7 @@ CREATE TABLE IF NOT EXISTS discounts (
 
 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,