Bump version and update Changes

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

diff --git a/db.sql b/db.sql
index 56edc0959d8cadfd863f976b076ee6c6f4da5254..1cd64f348aaa22c90270d0ac75d196036ba9f12b 100644 (file)
--- a/db.sql
+++ b/db.sql
@@ -1,11 +1,13 @@
 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,
+       model    TEXT,
+       brand    TEXT,
        CONSTRAINT positive_stock CHECK (stock >= 0)
 );
 
@@ -18,10 +20,13 @@ 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,
 
+       stripe_token TEXT,
+
        -- DELIVERY
        first_name   VARCHAR(20) NOT NULL,
        last_name    VARCHAR(20) NOT NULL,