import sqlite3


def migrate(conn: sqlite3.Connection):
    _ = conn.execute("""
        CREATE INDEX IF NOT EXISTS idx_posts_service_user_identifier
        ON posts (service, user, identifier);
    """)
    _ = conn.execute("""
        CREATE UNIQUE INDEX IF NOT EXISTS ux_mappings_original_mapped
        ON mappings (original, mapped);
    """)