diff options
| author | Erich Eckner <git@eckner.net> | 2018-06-01 11:11:07 +0200 |
|---|---|---|
| committer | Erich Eckner <git@eckner.net> | 2018-06-01 11:11:07 +0200 |
| commit | 265d12032a1f1fb1b177444d86e90ace5c244c2a (patch) | |
| tree | 7c20326541b6a317aa529b2b5690ee9df97f0c47 | |
| parent | e0c167a65916bf995add39aec94f5f524af834e4 (diff) | |
| download | builder-265d12032a1f1fb1b177444d86e90ace5c244c2a.tar.xz | |
misc/database-layout.dump: `is_to_be_deleted` & `last_moved` moved finally
| -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`), |