[Qa-jenkins-scm] [jenkins.debian.net] 02/02: reproducible: db schema 8: add default value to stats_bugs to get a full 'done vs open bugs' graph

[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 f981271026761bb30fa05a2c754085b8e448f702
Author: Holger Levsen <holger at layer-acht.org>
Date:   Tue Mar 10 02:13:40 2015 +0100

    reproducible: db schema 8: add default value to stats_bugs to get a full 'done vs open bugs' graph
---
 bin/reproducible_db_maintenance.py | 36 ++++++++++++++++++++++++++++++++++++
 1 file changed, 36 insertions(+)

diff --git a/bin/reproducible_db_maintenance.py b/bin/reproducible_db_maintenance.py
index 74fd8e9..a2fc114 100755
--- a/bin/reproducible_db_maintenance.py
+++ b/bin/reproducible_db_maintenance.py
@@ -293,6 +293,42 @@ schema_updates = {
         'DROP TABLE results',
         'ALTER TABLE results_tmp RENAME TO results',
         'INSERT INTO rb_schema VALUES ("7", "' + now + '")'],
+    8: [ # add default value to stats_bugs to get a full 'done vs open bugs' graph
+        '''CREATE TABLE stats_bugs_tmp
+           (datum TEXT NOT NULL,
+            open_toolchain INTEGER DEFAULT '0',
+            done_toolchain INTEGER DEFAULT '0',
+            open_infrastructure INTEGER DEFAULT '0',
+            done_infrastructure INTEGER DEFAULT '0',
+            open_timestamps INTEGER DEFAULT '0',
+            done_timestamps INTEGER DEFAULT '0',
+            open_fileordering INTEGER DEFAULT '0',
+            done_fileordering INTEGER DEFAULT '0',
+            open_buildpath INTEGER DEFAULT '0',
+            done_buildpath INTEGER DEFAULT '0',
+            open_username INTEGER DEFAULT '0',
+            done_username INTEGER DEFAULT '0',
+            open_hostname INTEGER DEFAULT '0',
+            done_hostname INTEGER DEFAULT '0',
+            open_uname INTEGER DEFAULT '0',
+            done_uname INTEGER DEFAULT '0',
+            open_randomness INTEGER DEFAULT '0',
+            done_randomness INTEGER DEFAULT '0',
+            open_buildinfo INTEGER DEFAULT '0',
+            done_buildinfo INTEGER DEFAULT '0',
+            open_cpu INTEGER DEFAULT '0',
+            done_cpu INTEGER DEFAULT '0',
+            open_signatures INTEGER DEFAULT '0',
+            done_signatures INTEGER DEFAULT '0',
+            open_environment INTEGER DEFAULT '0',
+            one_environment INTEGER DEFAULT '0',
+            open_umask INTEGER DEFAULT '0',
+            done_umask INTEGER DEFAULT '0',
+            PRIMARY KEY (datum))''',
+        'INSERT INTO stats_bugs_tmp SELECT * FROM stats_bugs',
+        'DROP TABLE stats_bugs',
+        'ALTER TABLE stats_bugs_tmp RENAME TO stats_bugs',
+        'INSERT INTO rb_schema VALUES ("8", "' + now + '")'],
 }
 
 

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