summaryrefslogtreecommitdiffstats
path: root/sql
diff options
context:
space:
mode:
authorSebastian Reichel <sre@ring0.de>2012-12-08 23:26:48 +0100
committerSebastian Reichel <sre@ring0.de>2012-12-08 23:26:48 +0100
commitb57876577516c00693ab36970a746f986bc37b66 (patch)
treee9bddb2f1711ef16383c898e89cbdf63e65e9169 /sql
parent8477671a17482cd1560bf8a7bbcef21d68a43181 (diff)
downloadserial-barcode-scanner-b57876577516c00693ab36970a746f986bc37b66.tar.bz2
sqlite: false -> 0
Diffstat (limited to 'sql')
-rw-r--r--sql/tables.sql2
1 files changed, 1 insertions, 1 deletions
diff --git a/sql/tables.sql b/sql/tables.sql
index c4a43d4..a208467 100644
--- a/sql/tables.sql
+++ b/sql/tables.sql
@@ -4,5 +4,5 @@ CREATE TABLE IF NOT EXISTS sells (user INTEGER NOT NULL REFERENCES users, produc
CREATE TABLE IF NOT EXISTS restock (user INTEGER NOT NULL REFERENCES users, product INTEGER NOT NULL REFERENCES products, amount INTEGER NOT NULL DEFAULT 0, timestamp INTEGER NOT NULL DEFAULT 0, price INTEGER NOT NULL DEFAULT 0);
CREATE TABLE IF NOT EXISTS prices (product INTEGER NOT NULL REFERENCES products, valid_from INTEGER NOT NULL DEFAULT 0, memberprice INTEGER NOT NULL DEFAULT 0, guestprice INTEGER NOT NULL DEFAULT 0);
CREATE TABLE IF NOT EXISTS 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);
-CREATE TABLE IF NOT EXISTS authentication(user INTEGER PRIMARY KEY NOT NULL REFERENCES users, password TEXT, session CHARACTER(20), superuser BOOLEAN NOT NULL DEFAULT false, disabled BOOLEAN NOT NULL DEFAULT false);
+CREATE TABLE IF NOT EXISTS authentication(user INTEGER PRIMARY KEY NOT NULL REFERENCES users, password TEXT, session CHARACTER(20), superuser BOOLEAN NOT NULL DEFAULT 0, disabled BOOLEAN NOT NULL DEFAULT 0);
COMMIT;