mirror of
https://github.com/System-End/plura.git
synced 2026-04-19 19:45:08 +00:00
c6135a629d
When a message is created or deleted, a log entry is created in the database. This will later be used to track who created which messages and provide the ability to edit and delete messages in the future
6 lines
196 B
SQL
6 lines
196 B
SQL
-- Add migration script here
|
|
CREATE TABLE message_logs (
|
|
id INTEGER NOT NULL PRIMARY KEY,
|
|
member_id INTEGER NOT NULL REFERENCES members (id),
|
|
message_id TEXT UNIQUE NOT NULL
|
|
) STRICT;
|