forked from mirror/mautrix-discord
26 lines
837 B
SQL
26 lines
837 B
SQL
-- v22 (compatible with v19+): Allow non-unique mxc URIs in file cache
|
|
CREATE TABLE new_discord_file (
|
|
url TEXT,
|
|
encrypted BOOLEAN,
|
|
mxc TEXT NOT NULL,
|
|
|
|
id TEXT,
|
|
emoji_name TEXT,
|
|
|
|
size BIGINT NOT NULL,
|
|
width INTEGER,
|
|
height INTEGER,
|
|
mime_type TEXT NOT NULL,
|
|
decryption_info jsonb,
|
|
timestamp BIGINT NOT NULL,
|
|
|
|
PRIMARY KEY (url, encrypted)
|
|
);
|
|
|
|
INSERT INTO new_discord_file (url, encrypted, mxc, id, emoji_name, size, width, height, mime_type, decryption_info, timestamp)
|
|
SELECT url, encrypted, mxc, id, emoji_name, size, width, height, mime_type, decryption_info, timestamp FROM discord_file;
|
|
|
|
DROP TABLE discord_file;
|
|
ALTER TABLE new_discord_file RENAME TO discord_file;
|
|
|
|
CREATE INDEX discord_file_mxc_idx ON discord_file (mxc);
|