diff options
Diffstat (limited to 'misc/database-layout.dump')
| -rw-r--r-- | misc/database-layout.dump | 4 |
1 files changed, 2 insertions, 2 deletions
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`), |