reproducible: new table (and new column on the schedule table) on the db where to take note of who schedule what

1 files changed, 8 insertions, 0 deletions

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 + '")'],
 }