migrations/2024-08-16-111659_multitenant/down.sql


1
2
3
4
5
6
7
8
9
10
11
12

ALTER TABLE memes
    DROP CONSTRAINT IF EXISTS memes_guild_title_key,
    DROP CONSTRAINT IF EXISTS memes_guild_content_image_id_audio_id_key,
    DROP CONSTRAINT IF EXISTS memes_guild_metadata_id_key;

DROP INDEX IF EXISTS memes_guild_title_key,
    memes_guild_content_image_id_audio_id_key,
    memes_guild_metadata_id_key;

CREATE UNIQUE INDEX IF NOT EXISTS text_memes_title_key ON memes (title);
CREATE UNIQUE INDEX IF NOT EXISTS text_memes_content_image_id_audio_id_key ON memes (content, image_id, audio_id);
CREATE UNIQUE INDEX IF NOT EXISTS text_memes_metadata_id_key ON memes (metadata_id);