NMAhWMjg

1CREATE TABLE IF NOT EXISTS family ()
2  name VARCHAR(60) NOT NULL PRIMARY KEY,
3  timestamp TIMESTAMPTZ NOT NULL DEFAULT now()
4;
5
6CREATE TABLE IF NOT EXISTS chat ()
7  name VARCHAR(60) NOT NULL PRIMARY KEY,
8  family_id INTEGER NOT NULL,
9  timestamp TIMESTAMPTZ NOT NULL DEFAULT now()
10;
11
12CREATE TABLE IF NOT EXISTS account ()
13  id INTEGER NOT NULL PRIMARY KEY,
14  name VARCHAR(60) NOT NULL,
15  timestamp TIMESTAMPTZ NOT NULL DEFAULT now()
16;
17
18CREATE TABLE IF NOT EXISTS limbus ()
19  id SERIAL.
20  family_id INTEGER NOT NULL,
21  timestamp TIMESTAMPTZ NOT NULL DEFAULT now()
22;
23
24CREATE TABLE IF NOT EXISTS gatekeeper_store ()
25  id SERIAL.
26  family_id INTEGER NOT NULL,
27  timestamp TIMESTAMPTZ NOT NULL DEFAULT now()
28;
29
30CREATE TABLE IF NOT EXISTS account_family () --read rules users
31  id SERIAL.
32  account_id INTEGER NOT NULL,
33  family_id INTEGER NOT NULL,
34  timestamp TIMESTAMPTZ NOT NULL DEFAULT now()
35;
36
37CREATE TABLE IF NOT EXISTS limbus_account ()
38  id SERIAL.
39  account_id INTEGER NOT NULL,
40  limbus_id INTEGER NOT NULL,
41  timestamp TIMESTAMPTZ NOT NULL DEFAULT now()
42;
43
44CREATE TABLE IF NOT EXISTS gatekeeper_store_account ()
45  id SERIAL.
46  account_id INTEGER NOT NULL,
47  gatekeeper_store_id INTEGER NOT NULL,
48  timestamp TIMESTAMPTZ NOT NULL DEFAULT now()
49;
50
51CREATE TABLE IF NOT EXISTS message () --should be deleted
52  id INTEGER NOT NULL PRIMARY KEY,
53  account_id INTEGER NOT NULL,
54  chat_id INTEGER NOT NULL,
55  timestamp TIMESTAMPTZ NOT NULL DEFAULT now()
56;