diff options
Diffstat (limited to 'migrations/20241005021022_message.sql')
| -rw-r--r-- | migrations/20241005021022_message.sql | 22 |
1 files changed, 22 insertions, 0 deletions
diff --git a/migrations/20241005021022_message.sql b/migrations/20241005021022_message.sql new file mode 100644 index 0000000..189612c --- /dev/null +++ b/migrations/20241005021022_message.sql @@ -0,0 +1,22 @@ +create table message ( + id text + not null + primary key, + channel text + not null + references channel (id), + sender text + not null + references login (id), + sent_sequence bigint + unique + not null, + sent_at text + not null, + body text + not null +); + +create index message_sent_at +on message (sent_at); + |