diff options
| author | Owen Jacobson <owen@grimoire.ca> | 2024-09-13 00:26:03 -0400 |
|---|---|---|
| committer | Owen Jacobson <owen@grimoire.ca> | 2024-09-13 02:42:27 -0400 |
| commit | 067e3da1900d052a416c56e1c047640aa23441ae (patch) | |
| tree | 8baad4240d2532216f2530f5c974479e557c675a /migrations/20240912145249_message.sql | |
| parent | 5d76d0712e07040d9aeeebccb189d75636a07c7a (diff) | |
Transmit messages via `/:chan/send` and `/:chan/events`.
Diffstat (limited to 'migrations/20240912145249_message.sql')
| -rw-r--r-- | migrations/20240912145249_message.sql | 17 |
1 files changed, 17 insertions, 0 deletions
diff --git a/migrations/20240912145249_message.sql b/migrations/20240912145249_message.sql new file mode 100644 index 0000000..ce9db0d --- /dev/null +++ b/migrations/20240912145249_message.sql @@ -0,0 +1,17 @@ +create table message ( + id text + not null + primary key, + channel text + not null + references channel (id), + sender text + not null + references login (id), + body text + not null, + sent_at text + not null +); + +create index message_sent_at on message (channel, sent_at); |