37 lines
1.3 KiB
SQL
37 lines
1.3 KiB
SQL
-- Add down migration script here
|
|
DROP POLICY see_folder_extra_perms_user ON v2_job;
|
|
DROP POLICY see_own_path ON v2_job;
|
|
DROP POLICY see_member_path ON v2_job;
|
|
DROP POLICY see_own ON v2_job;
|
|
DROP POLICY see_member ON v2_job;
|
|
DROP POLICY admin_policy ON v2_job;
|
|
ALTER TABLE v2_job
|
|
DROP COLUMN created_at CASCADE,
|
|
DROP COLUMN created_by CASCADE,
|
|
DROP COLUMN permissioned_as CASCADE,
|
|
DROP COLUMN permissioned_as_email CASCADE,
|
|
DROP COLUMN kind CASCADE,
|
|
DROP COLUMN runnable_id CASCADE,
|
|
DROP COLUMN runnable_path CASCADE,
|
|
DROP COLUMN parent_job CASCADE,
|
|
DROP COLUMN root_job CASCADE,
|
|
DROP COLUMN script_lang CASCADE,
|
|
DROP COLUMN script_entrypoint_override CASCADE,
|
|
DROP COLUMN flow_step CASCADE,
|
|
DROP COLUMN flow_step_id CASCADE,
|
|
DROP COLUMN flow_innermost_root_job CASCADE,
|
|
DROP COLUMN trigger CASCADE,
|
|
DROP COLUMN trigger_kind CASCADE,
|
|
DROP COLUMN same_worker CASCADE,
|
|
DROP COLUMN visible_to_owner CASCADE,
|
|
DROP COLUMN concurrent_limit CASCADE,
|
|
DROP COLUMN concurrency_time_window_s CASCADE,
|
|
DROP COLUMN cache_ttl CASCADE,
|
|
DROP COLUMN timeout CASCADE,
|
|
DROP COLUMN priority CASCADE,
|
|
DROP COLUMN preprocessed CASCADE,
|
|
DROP COLUMN args CASCADE,
|
|
DROP COLUMN labels CASCADE,
|
|
DROP COLUMN pre_run_error CASCADE;
|
|
DROP TYPE job_trigger_kind;
|