From 40db69e78d55eceeb0d6ea851ff756e2508bd618 Mon Sep 17 00:00:00 2001
From: Sebastian Reichel <sre@ring0.de>
Date: Wed, 16 May 2012 21:57:44 +0200
Subject: add database creation script

---
 Makefile      |   3 +++
 create_db.sql |  34 ++++++++++++++++++++++++++++++++++
 shop.db       | Bin 3072 -> 0 bytes
 3 files changed, 37 insertions(+)
 create mode 100644 create_db.sql
 delete mode 100644 shop.db

diff --git a/Makefile b/Makefile
index c1ad962..a5fff6e 100644
--- a/Makefile
+++ b/Makefile
@@ -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
deleted file mode 100644
index 32c95eb..0000000
Binary files a/shop.db and /dev/null differ
-- 
cgit v1.2.3