From 0a1661c353b65730bb905a17a165185dfbb32577 Mon Sep 17 00:00:00 2001
From: Erich Eckner <git@eckner.net>
Date: Tue, 6 Feb 2018 10:34:28 +0100
Subject: bin/bootstrap-mysql, bin/mysql-functions: new column
 `is_to_be_deleted` in `binary_packages`

---
 bin/bootstrap-mysql | 5 +++--
 1 file changed, 3 insertions(+), 2 deletions(-)

(limited to 'bin/bootstrap-mysql')

diff --git a/bin/bootstrap-mysql b/bin/bootstrap-mysql
index 116b6c7..5acc2e2 100755
--- a/bin/bootstrap-mysql
+++ b/bin/bootstrap-mysql
@@ -61,6 +61,7 @@ if [ ! "$1" = 'slim' ]; then
       ' sub_pkgrel MEDIUMINT' \
       ' has_issues BIT' \
       ' is_tested BIT' \
+      ' is_to_be_deleted BIT' \
       ' pkgname VARCHAR(64)' \
       ' architecture SMALLINT :architectures' \
       ' UNIQUE content build_assignment sub_pkgrel pkgname architecture repository' \
@@ -562,7 +563,7 @@ if [ -s "${tmp_dir}/new-stable-packages" ]; then
       s/,$/;/
     ' "${tmp_dir}/new-stable-packages"
     # shellcheck disable=SC2016
-    printf 'INSERT IGNORE INTO `binary_packages` (`pkgname`,`epoch`,`pkgver`,`pkgrel`,`sub_pkgrel`,`architecture`,`repository`,`build_assignment`,`has_issues`,`is_tested`)'
+    printf 'INSERT IGNORE INTO `binary_packages` (`pkgname`,`epoch`,`pkgver`,`pkgrel`,`sub_pkgrel`,`architecture`,`repository`,`build_assignment`,`has_issues`,`is_tested`,`is_to_be_deleted`)'
     printf ' SELECT '
     # shellcheck disable=SC2016
     printf '`stable_packages`.`%s`,' \
@@ -576,7 +577,7 @@ if [ -s "${tmp_dir}/new-stable-packages" ]; then
       'architectures' \
       'repositories'
     # shellcheck disable=SC2016
-    printf -- '-`build_assignment`,0,1 FROM `stable_packages`'
+    printf -- '-`build_assignment`,0,1,0 FROM `stable_packages`'
     # shellcheck disable=SC2016
     printf ' JOIN `%s` ON `stable_packages`.`%s`=`%s`.`name`' \
       'repositories' 'repository' 'repositories' \
-- 
cgit v1.2.3-70-g09d2