1 UP_SQL = """ 2 ALTER TABLE host_queue_entries ADD COLUMN started_on datetime NULL; 3 ALTER TABLE jobs ADD COLUMN max_runtime_hrs integer NOT NULL; 4 -- conservative value for existing jobs, to make sure they don't get 5 -- unexpectedly timed out. 6 UPDATE jobs SET max_runtime_hrs = timeout; 7 """ 8 9 DOWN_SQL = """ 10 ALTER TABLE jobs DROP COLUMN max_runtime_hrs; 11 ALTER TABLE host_queue_entries DROP COLUMN started_on; 12 """ 13
