From e610a9f8ee63e8e536bc56f6a95f23128afb5243 Mon Sep 17 00:00:00 2001 From: Mattia Rizzolo Date: Sun, 3 May 2015 19:35:57 +0200 Subject: reproducible: new table (and new column on the schedule table) on the db where to take note of who schedule what --- bin/reproducible_db_maintenance.py | 8 ++++++++ 1 file changed, 8 insertions(+) (limited to 'bin/reproducible_db_maintenance.py') diff --git a/bin/reproducible_db_maintenance.py b/bin/reproducible_db_maintenance.py index 1bfddcff..74f37c21 100755 --- a/bin/reproducible_db_maintenance.py +++ b/bin/reproducible_db_maintenance.py @@ -365,6 +365,14 @@ schema_updates = { # IRC notification 'ALTER TABLE schedule ADD COLUMN notify TEXT', 'INSERT INTO rb_schema VALUES ("12", "' + now + '")'], + 13: [ # take note of the manual scheduling done, to limit people + '''CREATE TABLE manual_scheduler ( + id INTEGER PRIMARY KEY, + package_id INTEGER NOT NULL, + requester TEXT NOT NULL, + date_request INTEGER) NOT NULL''' + 'ALTER TABLE schedule ADD COLUMN scheduler TEXT' + 'INSERT INTO rb_schema VALUES ("12", "' + now + '")'], } -- cgit v1.2.3-54-g00ecf