aboutsummaryrefslogtreecommitdiffstats
path: root/src/manager/sqlite.sql
blob: c60025e0e348bbf02c17903ca7fc21fe592b769e (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
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
);