new table `mirror_statuses`

1 files changed, 15 insertions, 0 deletions

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,