|
Revision 3712, 408 bytes
(checked in by martin, 5 months ago)
|
replaced the example manager database by a sql script
|
| Line | |
|---|
| 1 |
|
|---|
| 2 |
CREATE TABLE users ( |
|---|
| 3 |
username TEXT, password TEXT |
|---|
| 4 |
); |
|---|
| 5 |
|
|---|
| 6 |
CREATE TABLE gateways ( |
|---|
| 7 |
name TEXT, |
|---|
| 8 |
port INTEGER, |
|---|
| 9 |
address text |
|---|
| 10 |
); |
|---|
| 11 |
|
|---|
| 12 |
CREATE TABLE user_gateway ( |
|---|
| 13 |
user INTEGER, |
|---|
| 14 |
gateway INTEGER |
|---|
| 15 |
); |
|---|
| 16 |
|
|---|
| 17 |
INSERT INTO users VALUES( |
|---|
| 18 |
'strongSwan', |
|---|
| 19 |
'44092c0394d3661bd3c3587f43e48729836bdf6e' -- strongSwan |
|---|
| 20 |
); |
|---|
| 21 |
|
|---|
| 22 |
INSERT INTO gateways VALUES( |
|---|
| 23 |
'Local Unix', |
|---|
| 24 |
0, |
|---|
| 25 |
'/var/run/charon.xml' |
|---|
| 26 |
); |
|---|
| 27 |
|
|---|
| 28 |
INSERT INTO user_gateway VALUES( |
|---|
| 29 |
1,1 |
|---|
| 30 |
); |
|---|
