X-Git-Url: http://git.ieval.ro/?a=blobdiff_plain;f=db.sql;fp=db.sql;h=d8691f4d5cafa479137ca5a2c27f2c3f5ef1ff26;hb=1576fc41a34d75269ba8408db99104855edbba11;hp=56edc0959d8cadfd863f976b076ee6c6f4da5254;hpb=6e33dd6846a44f56a5c8bd187f0a89e4893c7b4a;p=app-web-oof.git diff --git a/db.sql b/db.sql index 56edc09..d8691f4 100644 --- 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,