UP_SQL = """
|
ALTER TABLE host_queue_entries ADD COLUMN started_on datetime NULL;
|
ALTER TABLE jobs ADD COLUMN max_runtime_hrs integer NOT NULL;
|
-- conservative value for existing jobs, to make sure they don't get
|
-- unexpectedly timed out.
|
UPDATE jobs SET max_runtime_hrs = timeout;
|
"""
|
|
DOWN_SQL = """
|
ALTER TABLE jobs DROP COLUMN max_runtime_hrs;
|
ALTER TABLE host_queue_entries DROP COLUMN started_on;
|
"""
|
