buildmaster/build-list.php: display upstream_flag_date, too

1 files changed, 9 insertions, 0 deletions

diff --git a/buildmaster/build-list.php b/buildmaster/build-list.php
index 96d2dac..8e48c17 100644
--- a/buildmaster/build-list.php
+++ b/buildmaster/build-list.php
@@ -239,6 +239,13 @@ $columns = array(
     "sort" => "blocked",
     "title" => "block reason"
   ),
+  "upstream_flag_date" => array(
+    "label" => "Upstream Flag Date",
+    "mysql_name" => "upstream_flag_date",
+    "mysql_query" => "IF(`ba_q`.`upstream_flag_date`=\"0000-00-00 00:00:00\",NULL,`ba_q`.`upstream_flag_date`)",
+    "sort" => "blocked",
+    "title" => "block reason"
+  ),
   "build_slave" => array(
     "label" => "Build Slave",
     "mysql_name" => "build_slave",
@@ -283,6 +290,7 @@ mysql_run_query(
   '`uses_upstream` BIT,' .
   '`uses_modification` BIT,' .
   '`commit_time` TIMESTAMP,' .
+  '`upstream_flag_date` TIMESTAMP,' .
   '`package_repository` VARCHAR(64),' .
   '`git_repository` VARCHAR(64),' .
   '`arch` VARCHAR(16),' .
@@ -304,6 +312,7 @@ mysql_run_query(
   '`package_sources`.`uses_upstream`,' .
   '`package_sources`.`uses_modification`,' .
   '`package_sources`.`commit_time`,' .
+  '`package_sources`.`upstream_flag_date`,' .
   '`upstream_repositories`.`name`,' .
   '`git_repositories`.`name`,' .
   '`architectures`.`name`' .