-- Replace codeSnippet with headScripts and bodyScripts -- headScripts: placed at end of (GTM container, analytics init) -- bodyScripts: placed at start of (GTM noscript, early tracking) -- Add new columns (idempotent) DO $$ BEGIN IF NOT EXISTS ( SELECT 1 FROM information_schema.columns WHERE table_name = 'Dealer' AND column_name = 'headScripts' ) THEN ALTER TABLE "Dealer" ADD COLUMN "headScripts" TEXT; END IF; END $$; DO $$ BEGIN IF NOT EXISTS ( SELECT 1 FROM information_schema.columns WHERE table_name = 'Dealer' AND column_name = 'bodyScripts' ) THEN ALTER TABLE "Dealer" ADD COLUMN "bodyScripts" TEXT; END IF; END $$; -- Drop old column (idempotent) DO $$ BEGIN IF EXISTS ( SELECT 1 FROM information_schema.columns WHERE table_name = 'Dealer' AND column_name = 'codeSnippet' ) THEN ALTER TABLE "Dealer" DROP COLUMN "codeSnippet"; END IF; END $$;