Bump version and update Changes

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

diff --git a/db.sql b/db.sql
index eaff6f267247e5ce77fdfbca403424ce3c0e5cf0..1cd64f348aaa22c90270d0ac75d196036ba9f12b 100644 (file)
--- 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,
        price    INT     NOT NULL,
        stock    INT     NOT NULL,
        freepost BOOLEAN NOT NULL DEFAULT FALSE,

+       model    TEXT,
+       brand    TEXT,

        CONSTRAINT positive_stock CHECK (stock >= 0)
 );
 
        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,
 
 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,
        products JSON NOT NULL,
        total    INT NOT NULL,
        discount VARCHAR(20) REFERENCES discounts UNIQUE,