G3d8NUPQ

1CREATE TABLE IF NOT EXISTS supervisor (
2  id           SERIAL PRIMARY KEY,
3  Application  TEXT NOT NULL DEFAULT '',
4  Environment  TEXT NOT NULL DEFAULT ''
5);
6
7CREATE TABLE IF NOT EXISTS service_group (
8  id     SERIAL PRIMARY KEY,
9  name  TEXT    NOT NULL
10);
11
12CREATE TABLE IF NOT EXISTS service (
13  id       SERIAL PRIMARY KEY,
14  origin   TEXT NOT NULL,
15  name     TEXT NOT NULL,
16  version  TEXT NOT NULL,
17  release  TEXT NOT NULL,
18  status   TEXT NOT NULL,
19  health   TEXT NOT NULL,
20  group_id TEXT NOT NULL REFERENCES service_group (id) ON DELETE CASCADE,
21  sup_id   TEXT NOT NULL REFERENCES supervisor (id)    ON DELETE CASCADE
22);
23
24CREATE UNIQUE INDEX service_id_idx
25ON service (sup_id, origin, name);