From d70d7160b4034ea3430a3c690923f2b3f46f5e06 Mon Sep 17 00:00:00 2001 From: Sebastian Reichel Date: Sun, 20 May 2012 10:15:34 +0200 Subject: add price and user table to create_db.sql --- create_db.sql | 2 ++ 1 file changed, 2 insertions(+) (limited to 'create_db.sql') 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'); -- cgit v1.2.3