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);