bin/bootstrap-mysql: create `files` and `file_providers`, too

1 files changed, 10 insertions, 1 deletions

diff --git a/bin/bootstrap-mysql b/bin/bootstrap-mysql
index 8806fe2..80727c8 100755
--- a/bin/bootstrap-mysql
+++ b/bin/bootstrap-mysql
@@ -70,6 +70,7 @@ if [ ! "$1" = 'slim' ]; then
       ' is_to_be_deleted BIT' \
       ' pkgname VARCHAR(64)' \
       ' architecture SMALLINT :architectures' \
+      ' sha512sum NULL' \
       ' UNIQUE content build_assignment sub_pkgrel pkgname architecture repository' \
       ' UNIQUE file_name pkgname epoch pkgver pkgrel sub_pkgrel architecture repository' \
       'repositories MEDIUMINT' \
@@ -163,7 +164,15 @@ if [ ! "$1" = 'slim' ]; then
       ' locked_tasks_count MEDIUMINT' \
       ' blocked_tasks_count MEDIUMINT' \
       ' next_tasks_count MEDIUMINT' \
-      ' UNIQUE date'
+      ' UNIQUE date' \
+      'files BIGINT' \
+      ' path TEXT' \
+      ' name TEXT' \
+      ' name_hash VARCHAR(128)' \
+      ' absolute_name_hash VARCHAR(128)' \
+      'file_providers BIGINT' \
+      ' package BIGINT :binary_packages' \
+      ' file BIGINT :files'
   )
 
   # shellcheck disable=SC2016