summaryrefslogtreecommitdiffstats
path: root/db/old_migrations/patch-maintenance-cron.sql
blob: bc51b881bc4f82a080e96b74839756bc7d81ca92 (plain)
1
2
3
4
5
6
7
8
9
10
11
-- You should not modify if this have pushed to Github, unless it does serious wrong with the db.
BEGIN TRANSACTION;

DROP TABLE maintenance_timeslot;

-- 999 characters. https://stackoverflow.com/questions/46134830/maximum-length-for-cron-job
ALTER TABLE maintenance ADD cron TEXT;
ALTER TABLE maintenance ADD timezone VARCHAR(255);
ALTER TABLE maintenance ADD duration INTEGER;

COMMIT;