20231005134337_add_account_id_to_tasks.down.sql

BEGIN;


Drop View if exists ready_tasks;

DROP INDEX if exists tasks_account_id;
alter table tasks drop column if exists account_id;


CREATE OR REPLACE VIEW ready_tasks AS
SELECT *
FROM tasks
WHERE started_at IS NULL
  AND (status != 'canceled' OR status is null)
  AND id NOT IN (
    SELECT task_id
    FROM task_dependencies JOIN tasks ON dependency_id = id
    WHERE finished_at IS NULL
)
ORDER BY queued_at ASC;

COMMIT;