bin/bootstrap-mysql,bin/mysql-functions: new column `priority` in `build_assignments`

2 files changed, 3 insertions, 2 deletions

diff --git a/bin/bootstrap-mysql b/bin/bootstrap-mysql
index 193b0eb..ae51e25 100755
--- a/bin/bootstrap-mysql
+++ b/bin/bootstrap-mysql
@@ -82,6 +82,7 @@ if [ ! "$1" = 'slim' ]; then
       ' architecture SMALLINT :architectures' \
       ' is_blocked VARCHAR(128) NULL' \
       ' is_broken BIT' \
+      ' priority SMALLINT' \
       ' UNIQUE content package_source architecture' \
       'build_dependency_loops BIGINT' \
       ' loop MEDIUMINT' \
diff --git a/bin/mysql-functions b/bin/mysql-functions
index f3dcc5b..a17f7a2 100755
--- a/bin/mysql-functions
+++ b/bin/mysql-functions
@@ -310,8 +310,8 @@ mysql_generate_package_metadata() {
       fi
     } | \
       while read -r arch; do
-        printf 'INSERT IGNORE INTO `build_assignments` (`package_source`,`architecture`,`is_blocked`)'
-        printf ' SELECT `package_sources`.`id`,`architectures`.`id`,NULL'
+        printf 'INSERT IGNORE INTO `build_assignments` (`package_source`,`architecture`,`is_blocked`,`is_broken`,`priority`)'
+        printf ' SELECT `package_sources`.`id`,`architectures`.`id`,NULL,0,0'
         printf ' FROM `architectures` JOIN `package_sources`'
         printf ' WHERE `architectures`.`name` = from_base64("%s")' \
           "$(