diff options
| -rw-r--r-- | create_db.sql | 2 |
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'); |