Files

17 lines
771 B
SQL
Raw Permalink Normal View History

-- 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.