--- federation stuff starting here
-INSERT INTO roles (role_id, name) VALUES (3000, 'peer');
-
-CREATE TABLE peers (
- peer_id serial PRIMARY KEY, -- identifier
- peername text NOT NULL, -- free text
- peer_url text NOT NULL, -- the url of that peer's API
- person_id integer REFERENCES persons NOT NULL, -- the account we use for logging in
-
- deleted boolean NOT NULL DEFAULT false
-) WITH OIDS;
-
-CREATE TABLE foreign_nodes (
- foreign_node_id serial PRIMARY KEY, -- identifier
- hostname text NOT NULL,
- boot_state text NOT NULL,
- peer_id integer REFERENCES peers NOT NULL,
-
- deleted boolean NOT NULL DEFAULT false
-) WITH OIDS;