summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorErich Eckner <git@eckner.net>2018-06-01 11:11:07 +0200
committerErich Eckner <git@eckner.net>2018-06-01 11:11:07 +0200
commit265d12032a1f1fb1b177444d86e90ace5c244c2a (patch)
tree7c20326541b6a317aa529b2b5690ee9df97f0c47
parente0c167a65916bf995add39aec94f5f524af834e4 (diff)
downloadbuilder-265d12032a1f1fb1b177444d86e90ace5c244c2a.tar.xz
misc/database-layout.dump: `is_to_be_deleted` & `last_moved` moved finally
-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`),