| 1 | -- Schedules pause in a repository with no push for 60 days, and wait an |
| 2 | -- hour after billing refused to start one of the workflow's scheduled jobs. |
| 3 | |
| 4 | -- When the repository last had a push, at a day's resolution; written on |
| 5 | -- pushes to repositories with a scheduled workflow. Workflows already here |
| 6 | -- start counting now. |
| 7 | ALTER TABLE workflows ADD COLUMN pushed_at TEXT; |
| 8 | UPDATE workflows SET pushed_at = strftime('%Y-%m-%dT%H:%M:%fZ', 'now') WHERE crons != '[]'; |
| 9 | |
| 10 | -- Until when its schedule waits: set when billing refused a job of one of |
| 11 | -- its scheduled runs. |
| 12 | ALTER TABLE workflows ADD COLUMN schedule_refused_until TEXT; |