-- Remove only the temporary products relation created by the Phase 6
-- compatibility preflight. Never drop a real product-intelligence table.
DO $$
DECLARE
  is_placeholder BOOLEAN := false;
BEGIN
  IF to_regclass('public.products') IS NOT NULL THEN
    is_placeholder := obj_description('public.products'::regclass, 'pg_class') = 'toknext_phase6_placeholder';
  END IF;

  IF is_placeholder THEN
    DROP INDEX IF EXISTS "products_name_fts";
    IF EXISTS (
      SELECT 1
      FROM pg_constraint
      WHERE conname = 'product_score_history_productId_fkey'
        AND conrelid = 'public.product_score_history'::regclass
    ) THEN
      ALTER TABLE "product_score_history"
        DROP CONSTRAINT "product_score_history_productId_fkey";
    END IF;
    DROP TABLE "products";
  END IF;
END $$;