summaryrefslogtreecommitdiff
path: root/misc/database-layout.dump
diff options
context:
space:
mode:
authorErich Eckner <git@eckner.net>2018-06-15 11:30:00 +0200
committerErich Eckner <git@eckner.net>2018-06-15 11:35:35 +0200
commit8a253e4c6d7ce231c6d600669e3b2ff8d94dfadd (patch)
tree1051e7794e462f9e0acd924ff81dd67ff9384ff3 /misc/database-layout.dump
parent981f18f8bb89708d9efa4b06dbb2402fa26821fa (diff)
downloadbuilder-8a253e4c6d7ce231c6d600669e3b2ff8d94dfadd.tar.xz
new table `mirror_statuses`
Diffstat (limited to 'misc/database-layout.dump')
-rw-r--r--misc/database-layout.dump15
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,