From 265d12032a1f1fb1b177444d86e90ace5c244c2a Mon Sep 17 00:00:00 2001 From: Erich Eckner Date: Fri, 1 Jun 2018 11:11:07 +0200 Subject: misc/database-layout.dump: `is_to_be_deleted` & `last_moved` moved finally --- misc/database-layout.dump | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) (limited to 'misc') diff --git a/misc/database-layout.dump b/misc/database-layout.dump index 6d0c060..2693d70 100644 --- a/misc/database-layout.dump +++ b/misc/database-layout.dump @@ -342,9 +342,7 @@ binary_packages CREATE TABLE `binary_packages` ( `is_tested` bit(1) NOT NULL, `pkgname` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL, `architecture` smallint(6) NOT NULL, - `is_to_be_deleted` bit(1) NOT NULL, `sha512sum` varchar(128) COLLATE utf8mb4_unicode_ci DEFAULT NULL, - `last_moved` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`), UNIQUE KEY `file_name` (`pkgname`,`epoch`,`pkgver`,`pkgrel`,`sub_pkgrel`,`architecture`), UNIQUE KEY `content` (`build_assignment`,`sub_pkgrel`,`pkgname`,`architecture`), @@ -356,6 +354,8 @@ binary_packages_in_repositories CREATE TABLE `binary_packages_in_repositories` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `package` bigint(20) NOT NULL, `repository` mediumint(9) NOT NULL, + `last_moved` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, + `is_to_be_deleted` bit(1) NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `content` (`package`,`repository`), KEY `binary_packages_in_repositories_ibfk_2` (`repository`), -- cgit v1.2.3