From a8d1d541d1f5592f334294da14198c843446c111 Mon Sep 17 00:00:00 2001 From: Holger Levsen Date: Sat, 14 Mar 2015 19:45:07 +0100 Subject: reproducible: rename 'sid' to 'unstable' --- 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 6014c449..7c41d516 100755 --- a/bin/reproducible_db_maintenance.py +++ b/bin/reproducible_db_maintenance.py @@ -330,6 +330,14 @@ schema_updates = { 'DROP TABLE stats_bugs', 'ALTER TABLE stats_bugs_tmp RENAME TO stats_bugs', 'INSERT INTO rb_schema VALUES ("8", "' + now + '")'], + 9: [ # rename "sid" to "unstable" + 'UPDATE sources SET suite = "unstable" WHERE suite = "sid"', + 'UPDATE stats_build SET suite = "unstable" WHERE suite = "sid"', + 'UPDATE stats_pkg_state SET suite = "unstable" WHERE suite = "sid"', + 'UPDATE stats_builds_per_day SET suite = "unstable" WHERE suite = "sid"', + 'UPDATE stats_builds_age SET suite = "unstable" WHERE suite = "sid"', + 'UPDATE stats_meta_pkg_state SET suite = "unstable" WHERE suite = "sid"', + 'INSERT INTO rb_schema VALUES ("9", "' + now + '")'], } -- cgit v1.2.3-54-g00ecf