From 8a253e4c6d7ce231c6d600669e3b2ff8d94dfadd Mon Sep 17 00:00:00 2001 From: Erich Eckner Date: Fri, 15 Jun 2018 11:30:00 +0200 Subject: new table `mirror_statuses` --- misc/database-layout.dump | 15 +++++++++++++++ 1 file changed, 15 insertions(+) (limited to 'misc/database-layout.dump') diff --git a/misc/database-layout.dump b/misc/database-layout.dump index d84af0d..6aa09cb 100644 --- a/misc/database-layout.dump +++ b/misc/database-layout.dump @@ -575,6 +575,21 @@ install_targets CREATE TABLE `install_targets` ( PRIMARY KEY (`id`), UNIQUE KEY `name` (`name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci +mirror_statuses CREATE TABLE `mirror_statuses` ( + `id` bigint(20) NOT NULL AUTO_INCREMENT, + `protocol` varchar(8) COLLATE utf8mb4_unicode_ci NOT NULL, + `url` varchar(128) COLLATE utf8mb4_unicode_ci NOT NULL, + `country` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL, + `country_code` varchar(4) COLLATE utf8mb4_unicode_ci NOT NULL, + `last_sync` bigint(20) NOT NULL, + `start` float NOT NULL, + `stop` float NOT NULL, + `isos` bit(1) NOT NULL, + `ipv4` bit(1) NOT NULL, + `ipv6` bit(1) NOT NULL, + `active` bit(1) NOT NULL, + PRIMARY KEY (`id`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci package_sources CREATE TABLE `package_sources` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `pkgbase` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL, -- cgit v1.2.3-70-g09d2