M7CS9win

1create table if not exists server_instance (
2    id text not null,
3    active timestamp,
4    primary key (id)
5);
6
7create table if not exists group_instance (
8    id serial not null,
9    created_by text not null,
10    primary key (id)
11);
12
13create table if not exists user_server (
14    user_id text not null,
15    server_id text not null,
16    primary key (user_id, server_id),
17    foreign key (server_id) references server_instance(id)
18);
19
20create table if not exists group_server (
21    group_id integer not null,
22    server_id text not null,
23    primary key (group_id, server_id),
24    foreign key (group_id) references group_instance(id),
25    foreign key (server_id) references server_instance(id)
26);
27
28create table if not exists command (
29    id bigserial not null,
30    body text not null,
31    type text not null,
32    running boolean not null,
33    user_id text not null,
34    server_id text not null,
35    primary key (id),
36    foreign key (server_id) references server_instance(id)
37);