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