Arthur Poulet
c9fde074c0
* Remove mongodb (this database and the lib suck so much) * Update in the readme the database installation * Add migrations for users, points, messages, groups Note: Must be improved (FK, IX, ...) * Update database and add Sql requests
13 lines
230 B
SQL
13 lines
230 B
SQL
-- +micrate Up
|
|
CREATE TABLE messages (
|
|
id SERIAL PRIMARY KEY,
|
|
author TEXT NOT NULL,
|
|
dest TEXT NOT NULL,
|
|
content TEXT NOT NULL,
|
|
created_at TIMESTAMP NOT NULL,
|
|
read_at TIMESTAMP
|
|
);
|
|
|
|
-- +micrate Down
|
|
DROP TABLE messages;
|