replaced the example manager database by a sql script

1 files changed, 30 insertions, 0 deletions

diff --git a/src/manager/sqlite.sql b/src/manager/sqlite.sql
new file mode 100644
index 000000000..c60025e0e
--- /dev/null
+++ b/src/manager/sqlite.sql
@@ -0,0 +1,30 @@
+
+CREATE TABLE users (
+	username TEXT, password TEXT
+);
+
+CREATE TABLE gateways (
+	name TEXT,
+	port INTEGER,
+	address text
+);
+
+CREATE TABLE user_gateway (
+	user INTEGER,
+	gateway INTEGER
+);
+
+INSERT INTO users VALUES(
+	'strongSwan',
+	'44092c0394d3661bd3c3587f43e48729836bdf6e' -- strongSwan
+);
+
+INSERT INTO gateways VALUES(
+	'Local Unix',
+	0,
+	'/var/run/charon.xml'
+);
+
+INSERT INTO user_gateway VALUES(
+	1,1
+);