summaryrefslogtreecommitdiff
path: root/bin/mysql-functions
diff options
context:
space:
mode:
authorErich Eckner <git@eckner.net>2018-01-17 14:54:32 +0100
committerErich Eckner <git@eckner.net>2018-01-17 14:54:32 +0100
commit041139bd471096ddc6be8c8b80c0f5619238dc7a (patch)
tree99f274d58889c141aeb7ed16ab3c958b365e24e8 /bin/mysql-functions
parent677ed896b4c2232756068dc5c8e96f398350a341 (diff)
downloadbuilder-041139bd471096ddc6be8c8b80c0f5619238dc7a.tar.xz
bin/mysql-functions, bin/bootstrap-mysql: move `is_blocked` from `binary_packages` to `build_assignments`
Diffstat (limited to 'bin/mysql-functions')
-rwxr-xr-xbin/mysql-functions7
1 files changed, 3 insertions, 4 deletions
diff --git a/bin/mysql-functions b/bin/mysql-functions
index c37ebbb..1d1169b 100755
--- a/bin/mysql-functions
+++ b/bin/mysql-functions
@@ -284,8 +284,8 @@ mysql_generate_package_metadata() {
fi
} | \
while read -r arch; do
- printf 'INSERT IGNORE INTO `build_assignments` (`package_source`,`architecture`)'
- printf ' SELECT `package_sources`.`id`,`architectures`.`id`'
+ printf 'INSERT IGNORE INTO `build_assignments` (`package_source`,`architecture`,`is_blocked`)'
+ printf ' SELECT `package_sources`.`id`,`architectures`.`id`,0'
printf ' FROM `architectures` JOIN `package_sources`'
printf ' WHERE `architectures`.`name` = from_base64("%s")' \
"$(
@@ -429,7 +429,6 @@ mysql_generate_package_metadata() {
'sub_pkgrel' \
'pkgname' \
'has_issues' \
- 'is_blocked' \
'is_tested'
printf ') SELECT '
printf '`%s`.`id`,' \
@@ -442,7 +441,7 @@ mysql_generate_package_metadata() {
"${pkgrel}" \
"${sub_pkgrel}" \
"${pkgname}"
- printf '0,0,0 FROM'
+ printf '0,0 FROM'
printf ' `%s` JOIN' \
'repositories' \
'architectures' \