reproducible: save the schedule message in the db and show it in the "test history" table

1 files changed, 4 insertions, 0 deletions

diff --git a/bin/reproducible_db_maintenance.py b/bin/reproducible_db_maintenance.py
index 9bed6591..3eb87192 100755
--- a/bin/reproducible_db_maintenance.py
+++ b/bin/reproducible_db_maintenance.py
@@ -546,6 +546,10 @@ schema_updates = {
         'DROP TABLE schedule',
         'ALTER TABLE schedule_tmp RENAME TO schedule',
         'INSERT INTO rb_schema VALUES ("25", "' + now + '")'],
+    26: [ # add a column to the schedule table to save the schedule message
+        'ALTER TABLE schedule ADD COLUMN message TEXT',
+        'ALTER TABLE stats_build ADD COLUMN schedule_message TEXT NOT NULL DEFAULT ""',
+        'INSERT INTO rb_schema VALUES ("26", "' + now + '")'],
 }