Second commit

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

diff --git a/db.sql b/db.sql
index 56edc0959d8cadfd863f976b076ee6c6f4da5254..d8691f4d5cafa479137ca5a2c27f2c3f5ef1ff26 100644 (file)
--- a/db.sql
+++ b/db.sql
@@ -3,7 +3,6 @@ CREATE TABLE IF NOT EXISTS products (
        title    TEXT   NOT NULL,
        subtitle TEXT   NOT NULL,
        summary  TEXT   NOT NULL,
-       pictures TEXT[]     NULL,
        price    INT    NOT NULL,
        stock    INT    NOT NULL,
        CONSTRAINT positive_stock CHECK (stock >= 0)
@@ -22,6 +21,8 @@ CREATE TABLE IF NOT EXISTS orders (
        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,