summaryrefslogtreecommitdiffstats
path: root/sql/tables.sql
diff options
context:
space:
mode:
authorSebastian Reichel <sre@ring0.de>2012-12-08 23:35:33 +0100
committerSebastian Reichel <sre@ring0.de>2012-12-08 23:35:33 +0100
commit79b7424746c7636cd23a7869169431afa6941b06 (patch)
tree820a40d120a62e6f5b9b081b40e3e266d4c7a323 /sql/tables.sql
parentb57876577516c00693ab36970a746f986bc37b66 (diff)
downloadserial-barcode-scanner-79b7424746c7636cd23a7869169431afa6941b06.tar.bz2
rename table sells -> sales
Diffstat (limited to 'sql/tables.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 a208467..21f007b 100644
--- a/sql/tables.sql
+++ b/sql/tables.sql
@@ -1,6 +1,6 @@
BEGIN TRANSACTION;
CREATE TABLE IF NOT EXISTS products (id INTEGER PRIMARY KEY NOT NULL, name TEXT, amount INTEGER NOT NULL DEFAULT 0);
-CREATE TABLE IF NOT EXISTS sells (user INTEGER NOT NULL REFERENCES users, product INTEGER NOT NULL REFERENCES products, timestamp INTEGER NOT NULL DEFAULT 0);
+CREATE TABLE IF NOT EXISTS sales (user INTEGER NOT NULL REFERENCES users, product INTEGER NOT NULL REFERENCES products, timestamp INTEGER NOT NULL DEFAULT 0);
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);