Send patches - preferably formatted by git format-patch - to patches at archlinux32 dot org.
summaryrefslogtreecommitdiff
path: root/misc
diff options
context:
space:
mode:
authorErich Eckner <git@eckner.net>2018-06-15 12:07:31 +0200
committerErich Eckner <git@eckner.net>2018-06-15 12:07:31 +0200
commit331e7dca60916e65188060ad2a612c8341b69453 (patch)
tree91907c683c8a87db9c109ddc137b8e9d7a78a346 /misc
parent73edc40a119bef47a15d0048503281e05a0ee48b (diff)
misc/database-layout.dump: more keys
Diffstat (limited to 'misc')
-rw-r--r--misc/database-layout.dump4
1 files changed, 3 insertions, 1 deletions
diff --git a/misc/database-layout.dump b/misc/database-layout.dump
index 6aa09cb..a4eb3ff 100644
--- a/misc/database-layout.dump
+++ b/misc/database-layout.dump
@@ -588,7 +588,9 @@ mirror_statuses CREATE TABLE `mirror_statuses` (
`ipv4` bit(1) NOT NULL,
`ipv6` bit(1) NOT NULL,
`active` bit(1) NOT NULL,
- PRIMARY KEY (`id`)
+ PRIMARY KEY (`id`),
+ KEY `url` (`url`),
+ KEY `start` (`start`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci
package_sources CREATE TABLE `package_sources` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,