X-Git-Url: http://git.ieval.ro/?p=app-web-oof.git;a=blobdiff_plain;f=db.sql;h=1cd64f348aaa22c90270d0ac75d196036ba9f12b;hp=eaff6f267247e5ce77fdfbca403424ce3c0e5cf0;hb=HEAD;hpb=8bbff1bcc40acc652541fcda101bda44de264921

diff --git a/db.sql b/db.sql
index eaff6f2..1cd64f3 100644
--- a/db.sql
+++ b/db.sql
@@ -6,6 +6,8 @@ CREATE TABLE IF NOT EXISTS products (
 	price    INT     NOT NULL,
 	stock    INT     NOT NULL,
 	freepost BOOLEAN NOT NULL DEFAULT FALSE,
+	model    TEXT,
+	brand    TEXT,
 	CONSTRAINT positive_stock CHECK (stock >= 0)
 );
 
@@ -18,6 +20,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,