16 lines
387 B
PL/PgSQL
16 lines
387 B
PL/PgSQL
BEGIN;
|
|
|
|
ALTER TABLE roster_items ADD COLUMN annotations TEXT;
|
|
|
|
ALTER TABLE chat_history ADD COLUMN server_msg_id TEXT;
|
|
ALTER TABLE chat_history ADD COLUMN remote_msg_id TEXT;
|
|
ALTER TABLE chat_history ADD COLUMN participant_id TEXT;
|
|
|
|
CREATE INDEX IF NOT EXISTS chat_history_account_jid_server_msg_id_idx on chat_history (
|
|
account, server_msg_id
|
|
);
|
|
|
|
COMMIT;
|
|
|
|
PRAGMA user_version = 11;
|