diff options
author | Sebastian Reichel <sre@ring0.de> | 2012-05-24 14:43:21 +0200 |
---|---|---|
committer | Sebastian Reichel <sre@ring0.de> | 2012-05-24 14:43:21 +0200 |
commit | 88be417bd75f35f9b7a4edffb7a267cb0505f9d5 (patch) | |
tree | 993abe03fcba693539fe8543c9f0e51d8322e066 /create_db.sql | |
parent | 17e95acf5a8c64e38225a45e53ed1cbe9e104aa4 (diff) | |
download | serial-barcode-scanner-88be417bd75f35f9b7a4edffb7a267cb0505f9d5.tar.bz2 |
change user table layout
Diffstat (limited to 'create_db.sql')
-rw-r--r-- | create_db.sql | 2 |
1 files changed, 1 insertions, 1 deletions
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'); |