From 82246d368ae584eb0426e1cc69b721fa5c08e58c Mon Sep 17 00:00:00 2001 From: Erich Eckner Date: Sun, 25 Mar 2018 14:46:55 +0200 Subject: bin/bootstrap-mysql: create `files` and `file_providers`, too --- bin/bootstrap-mysql | 11 ++++++++++- 1 file changed, 10 insertions(+), 1 deletion(-) 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 -- cgit v1.2.3-54-g00ecf