diff options
author | Sebastian Reichel <sre@ring0.de> | 2012-05-16 21:57:44 +0200 |
---|---|---|
committer | Sebastian Reichel <sre@ring0.de> | 2012-05-16 21:57:44 +0200 |
commit | 40db69e78d55eceeb0d6ea851ff756e2508bd618 (patch) | |
tree | cf031ea13836844021eb347ebe519983378a754f | |
parent | a3e950e76313585942e1ea3abf2c013d8e04c0e6 (diff) | |
download | serial-barcode-scanner-40db69e78d55eceeb0d6ea851ff756e2508bd618.tar.bz2 |
add database creation script
-rw-r--r-- | Makefile | 3 | ||||
-rw-r--r-- | create_db.sql | 34 | ||||
-rw-r--r-- | shop.db | bin | 3072 -> 0 bytes |
3 files changed, 37 insertions, 0 deletions
@@ -4,6 +4,9 @@ PREFIX=/usr/local barcode-scanner: main.vala device.vala db.vala valac-0.16 --output $@ --pkg posix --pkg linux --pkg libsoup-2.4 --pkg sqlite3 $^ +shop.db: create_db.sql + sqlite3 shop.db < create_db.sql + install: barcode-scanner install -m755 barcode-scanner $(DESTDIR)$(PREFIX)/bin/barcode-scanner diff --git a/create_db.sql b/create_db.sql new file mode 100644 index 0000000..2d4716b --- /dev/null +++ b/create_db.sql @@ -0,0 +1,34 @@ +CREATE TABLE products (id INTEGER, name TEXT); +CREATE TABLE purchases (user INTEGER, product INTEGER, timestamp INTEGER); +BEGIN TRANSACTION; +INSERT INTO products VALUES(4029764001807,'Club Mate'); +INSERT INTO products VALUES(5449000017888,'Coka Cola'); +INSERT INTO products VALUES(5449000017895,'Coka Cola Light'); +INSERT INTO products VALUES(5449000134264,'Coka Cola Zero'); +INSERT INTO products VALUES(5449000017918,'Fanta'); +INSERT INTO products VALUES(5449000017932,'Sprite'); +INSERT INTO products VALUES(4104450004383,'Limette'); +INSERT INTO products VALUES(4104450005878,'Vilsa Classic'); +INSERT INTO products VALUES(5000159407236,'Mars'); +INSERT INTO products VALUES(5000159407397,'Snickers'); +INSERT INTO products VALUES(5000159418539,'Balisto Jogurt Beeren Mix'); +INSERT INTO products VALUES(7613032625474,'Lion'); +INSERT INTO products VALUES(7613032850340,'KitKat Chunky'); +INSERT INTO products VALUES(40084015,'Duplo'); +INSERT INTO products VALUES(40358802,'Knoppers'); +INSERT INTO products VALUES(40084107,'Ü-Ei'); +INSERT INTO products VALUES(40114606,'KitKat'); +INSERT INTO products VALUES(40111315,'Twix'); +INSERT INTO products VALUES(4003586000491,'Chips Frisch Oriento'); +INSERT INTO products VALUES(8690504018568,'Üker Sesamsticks'); +INSERT INTO products VALUES(4001686216125,'Haribo Salino'); +INSERT INTO products VALUES(4001686312025,'Haribo Schnuller'); +INSERT INTO products VALUES(4001686150689,'Haribo Konfekt'); +INSERT INTO products VALUES(4001686128244,'Haribo Staffeten'); +INSERT INTO products VALUES(4001686390085,'Haribo Phantasia'); +INSERT INTO products VALUES(4001686310229,'Haribo Weinland'); +INSERT INTO products VALUES(4001686386613,'Haribo Saftgoldbären'); +INSERT INTO products VALUES(4001686301265,'Haribo Goldbären'); +INSERT INTO products VALUES(4001686313046,'Haribo Saure Bohnen'); +INSERT INTO products VALUES(4001686720028,'Haribo Colorado Mini'); +COMMIT; diff --git a/shop.db b/shop.db Binary files differdeleted file mode 100644 index 32c95eb..0000000 --- a/shop.db +++ /dev/null |