BEGIN;

ALTER TABLE market_sube_fotograflari
    ALTER COLUMN market_subesi_id DROP NOT NULL,
    ADD COLUMN IF NOT EXISTS gecici_market_id uuid;

DO $$
BEGIN
    IF NOT EXISTS (
        SELECT 1 FROM pg_constraint WHERE conname = 'fk_market_sube_fotograflari_gecici_market'
    ) THEN
        ALTER TABLE market_sube_fotograflari
            ADD CONSTRAINT fk_market_sube_fotograflari_gecici_market
                FOREIGN KEY (gecici_market_id) REFERENCES gecici_marketler(id) ON DELETE CASCADE;
    END IF;
END $$;

CREATE INDEX IF NOT EXISTS ix_market_sube_fotograflari_gecici_market
    ON market_sube_fotograflari (gecici_market_id, olusturulma_tarihi);

COMMIT;