X-Git-Url: http://git.ieval.ro/?a=blobdiff_plain;f=db.sql;h=b75393541c351806d651a4e6237061881a6b89a1;hb=06dc23e9eec3a128b566725ae146f11a0f729d99;hp=eaff6f267247e5ce77fdfbca403424ce3c0e5cf0;hpb=8bbff1bcc40acc652541fcda101bda44de264921;p=app-web-oof.git diff --git a/db.sql b/db.sql index eaff6f2..b753935 100644 --- a/db.sql +++ b/db.sql @@ -18,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,