summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rw-r--r--misc/database-layout.dump4
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`),