13 lines
407 B
SQL
13 lines
407 B
SQL
CREATE TABLE IF NOT EXISTS messages
|
|
( channel TEXT
|
|
, nick TEXT NOT NULL
|
|
, event TEXT NOT NULL
|
|
, message TEXT
|
|
, tags TEXT DEFAULT '{}'
|
|
, ts GENERATED ALWAYS AS (json_extract(tags, '$.time'))
|
|
);
|
|
|
|
CREATE INDEX IF NOT EXISTS messages_channel_nick ON messages(channel, nick);
|
|
CREATE INDEX IF NOT EXISTS messages_channel ON messages(channel);
|
|
CREATE INDEX IF NOT EXISTS messages_ts ON messages(ts);
|