[Qa-jenkins-scm] [jenkins.debian.net] 04/06: reproducible: new table (and new column on the schedule table) on the db where to take note of who schedule what

[Holger Levsen]

This is an automated email from the git hooks/post-receive script.

holger pushed a commit to branch master
in repository jenkins.debian.net.

commit e610a9f8ee63e8e536bc56f6a95f23128afb5243
Author: Mattia Rizzolo <mattia at mapreri.org>
Date:   Sun May 3 19:35:57 2015 +0200

    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(+)

diff --git a/bin/reproducible_db_maintenance.py b/bin/reproducible_db_maintenance.py
index 1bfddcf..74f37c2 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 + '")'],
 }
 
 

-- 
Alioth's /usr/local/bin/git-commit-notice on /srv/git.debian.org/git/qa/jenkins.debian.net.git