-- 32_content_render_engine.sql
-- Two render engines per template: After Effects (.aep, rendered by a node-agent)
-- and Remotion (code-based React composition). render_engine selects which; for
-- Remotion templates render_remotion_comp holds the composition id to render
-- (the .aep / render_aep_comp columns stay null for those).
--
-- Apply manually on the live DB (migrations are not auto-run):
--   docker exec -i <postgres> psql -U postgres -d flatrender < 32_content_render_engine.sql

ALTER TABLE content.projects
    ADD COLUMN IF NOT EXISTS render_engine TEXT NOT NULL DEFAULT 'AfterEffects';

ALTER TABLE content.projects
    ADD COLUMN IF NOT EXISTS render_remotion_comp TEXT;

-- Existing templates are all After Effects; the default already covers them.