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
);
|