db-bootstrap.sql

INSERT INTO public.peer (id, public_key) VALUES (1, 'uBY9wEYelwood2z4FjC8zNZy2LN/WY17/GVOrZEhyWE=');
INSERT INTO public.peer (id, public_key) VALUES (2, 'rwhW6Z1hxejVjfiaVXHWkb+kCYuflzv0zbSPPynjPXs=');
INSERT INTO public.peer (id, public_key) VALUES (3, '55h6JA2ZMPzaoa+iZU62JmqmtgK3ydj4YdT9HkkhnEQ=');
INSERT INTO public.peer (id, public_key) VALUES (4, 'i5AmQLLlPa4fQmfuHj7COCFwmwegI39WMfs/LIdzbFo=');
INSERT INTO public.client (peer_id, serial, psk, healthy, last_check) VALUES (1, 'serial1', 'psk1', true, '2020-03-26 12:26:32.000000');
INSERT INTO public.client (peer_id, serial, psk, healthy, last_check) VALUES (2, 'serial2', 'psk2', false, '2020-03-26 12:26:32.000000');
INSERT INTO public.gateway (peer_id, id, access_group_id, endpoint) VALUES (3, 1, '1234-asdf-aad', '35.228.118.232:51820');
INSERT INTO public.gateway (peer_id, id, access_group_id, endpoint) VALUES (4, 2, '1234-asdf-aad', '35.228.78.29:51820');
INSERT INTO public.ip (peer_id, ip) VALUES (1, '10.255.248.4');
INSERT INTO public.ip (peer_id, ip) VALUES (2, '10.255.248.5');
INSERT INTO public.ip (peer_id, ip) VALUES (3, '10.255.248.2');
INSERT INTO public.ip (peer_id, ip) VALUES (4, '10.255.248.3');
INSERT INTO public.routes (gateway_id, cidr) VALUES (1, '1.2.3.4/23');