Create a new channel as a copy of main.
Rename main to:
Delete main? This cannot be undone.
ALTER TABLE jobs DROP COLUMN repo_state, DROP COLUMN channel, DROP COLUMN script;