diff options
author | Johannes Rudolph <johannes.rudolph@gmx.com> | 2018-02-12 23:16:11 +0100 |
---|---|---|
committer | Sebastian Reichel <sre@ring0.de> | 2018-06-28 01:53:40 +0200 |
commit | c70d626e473c8cbdbd87125a256ca221c0c3fa23 (patch) | |
tree | b865181b45bbe4a6beba7e8045ec9d98d18d9b41 /sql | |
parent | 764c39f4facfe42d926cd952dcf0f7e2768097a8 (diff) | |
download | serial-barcode-scanner-c70d626e473c8cbdbd87125a256ca221c0c3fa23.tar.bz2 |
Add RFID support
Diffstat (limited to 'sql')
-rw-r--r-- | sql/tables.sql | 1 |
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; |