add price and user table to create_db.sql

1 files changed, 2 insertions, 0 deletions

diff --git a/create_db.sql b/create_db.sql
index 3c18327..8540b70 100644
--- a/create_db.sql
+++ b/create_db.sql
@@ -1,6 +1,8 @@
 CREATE TABLE products (id INTEGER PRIMARY KEY NOT NULL, name TEXT, amount INTEGER NOT NULL DEFAULT 0);
 CREATE TABLE purchases (user INTEGER NOT NULL DEFAULT 0, product INTEGER NOT NULL DEFAULT 0, timestamp INTEGER NOT NULL DEFAULT 0);
 CREATE TABLE restock (user INTEGER NOT NULL DEFAULT 0, product INTEGER NOT NULL DEFAULT 0, amount INTEGER NOT NULL DEFAULT 0, timestamp INTEGER NOT NULL DEFAULT 0);
+CREATE TABLE prices (product INTEGER NOT NULL DEFAULT 0, valid_from INTEGER NOT NULL DEFAULT 0, memberprice INTEGER NOT NULL DEFAULT 0, guestprice INTEGER NOT NULL DEFAULT 0);
+CREATE TABLE users (id INTEGER PRIMARY KEY NOT NULL, username TEXT, firstname TEXT NOT NULL, lastname TEXT NOT NULL, street TEXT, city TEXT, email TEXT);
 BEGIN TRANSACTION;
 INSERT INTO products (id, name) VALUES(4029764001807,'Club Mate');
 INSERT INTO products (id, name) VALUES(5449000017888,'Coka Cola');