From 88be417bd75f35f9b7a4edffb7a267cb0505f9d5 Mon Sep 17 00:00:00 2001 From: Sebastian Reichel Date: Thu, 24 May 2012 14:43:21 +0200 Subject: change user table layout --- create_db.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'create_db.sql') diff --git a/create_db.sql b/create_db.sql index 8540b70..d622718 100644 --- a/create_db.sql +++ b/create_db.sql @@ -2,7 +2,7 @@ CREATE TABLE products (id INTEGER PRIMARY KEY NOT NULL, name TEXT, amount INTEGE 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); +CREATE TABLE users (id INTEGER PRIMARY KEY NOT NULL, email TEXT, firstname TEXT NOT NULL, lastname TEXT NOT NULL, gender TEXT, street TEXT, plz INTEGER, city 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