From d70d7160b4034ea3430a3c690923f2b3f46f5e06 Mon Sep 17 00:00:00 2001
From: Sebastian Reichel <sre@ring0.de>
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

