22 lines
600 B
Plaintext
22 lines
600 B
Plaintext
CREATE TABLE IF NOT EXISTS Users (
|
|
ID SERIAL,
|
|
lastname VARCHAR(32),
|
|
firstname VARCHAR(32),
|
|
middlename VARCHAR(32),
|
|
salty_password CHAR(60), --nodejs bcrypt.
|
|
chats INT[] -- to table Chats, column ID.
|
|
);
|
|
|
|
CREATE TABLE IF NOT EXISTS Chats (
|
|
ID SERIAL,
|
|
name VARCHAR(128), --chat name
|
|
admins INT[], -- to table Users, column ID.
|
|
messages INT[] -- ref to table Messages, column ID.
|
|
);
|
|
|
|
CREATE TABLE IF NOT EXISTS Messages (
|
|
ID SERIAL,
|
|
author_id INT, -- ref to table Users, column ID.
|
|
time_sent TIMESTAMP, -- yyyy.mm.dd hh:mm:ss.mmmmmm
|
|
content TEXT
|
|
); |