src/manager/sqlite.sql

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