summaryrefslogtreecommitdiffstats
path: root/sql/tables.sql
diff options
context:
space:
mode:
Diffstat (limited to 'sql/tables.sql')
-rw-r--r--sql/tables.sql1
1 files changed, 1 insertions, 0 deletions
diff --git a/sql/tables.sql b/sql/tables.sql
index fbe4d0e..1518ef2 100644
--- a/sql/tables.sql
+++ b/sql/tables.sql
@@ -9,5 +9,6 @@ CREATE TABLE IF NOT EXISTS supplier(id INTEGER PRIMARY KEY AUTOINCREMENT, name T
CREATE TABLE IF NOT EXISTS cashbox_diff(id INTEGER PRIMARY KEY AUTOINCREMENT, user INTEGER NOT NULL REFERENCES users, amount INTEGER NOT NULL, timestamp INTEGER NOT NULL DEFAULT 0);
CREATE TABLE IF NOT EXISTS ean_aliases (id INTEGER PRIMARY KEY NOT NULL, real_ean INTEGER NOT NULL REFERENCES products);
CREATE TABLE IF NOT EXISTS categories (id INTEGER PRIMARY KEY AUTOINCREMENT, name TEXT);
+CREATE TABLE IF NOT EXISTS rfid_users (rfid TEXT, user INTEGER NOT NULL REFERENCES users);
CREATE INDEX IF NOT EXISTS invoiceindex ON sales (user ASC, timestamp DESC);
COMMIT;