From 2e72efd8d3b258451de7607c85303aacbc30572b Mon Sep 17 00:00:00 2001 From: Ethan Lee Date: Wed, 12 Nov 2025 21:34:49 +0000 Subject: migrations: create version_map (requested_version, module_path, resolved_version) For golang/go#76284 Change-Id: I4b2f5d3d3244265b638a35ca7782e8f8f6f79b07 Reviewed-on: https://go-review.googlesource.com/c/pkgsite/+/720040 Reviewed-by: Jonathan Amsterdam Reviewed-by: Robert Findley kokoro-CI: kokoro Auto-Submit: Ethan Lee LUCI-TryBot-Result: Go LUCI --- migrations/000155_add_index_to_version_map.down.sql | 9 +++++++++ migrations/000155_add_index_to_version_map.up.sql | 10 ++++++++++ 2 files changed, 19 insertions(+) create mode 100644 migrations/000155_add_index_to_version_map.down.sql create mode 100644 migrations/000155_add_index_to_version_map.up.sql diff --git a/migrations/000155_add_index_to_version_map.down.sql b/migrations/000155_add_index_to_version_map.down.sql new file mode 100644 index 00000000..23475b43 --- /dev/null +++ b/migrations/000155_add_index_to_version_map.down.sql @@ -0,0 +1,9 @@ +-- Copyright 2025 The Go Authors. All rights reserved. +-- Use of this source code is governed by a BSD-style +-- license that can be found in the LICENSE file. + +BEGIN; + +DROP INDEX IF EXISTS idx_version_map_requested_version_module_path_resolved_version; + +END; diff --git a/migrations/000155_add_index_to_version_map.up.sql b/migrations/000155_add_index_to_version_map.up.sql new file mode 100644 index 00000000..7ace1c29 --- /dev/null +++ b/migrations/000155_add_index_to_version_map.up.sql @@ -0,0 +1,10 @@ +-- Copyright 2025 The Go Authors. All rights reserved. +-- Use of this source code is governed by a BSD-style +-- license that can be found in the LICENSE file. + +BEGIN; + +CREATE INDEX idx_version_map_requested_version_module_path_resolved_version +ON version_map (requested_version, module_path, resolved_version); + +END; -- cgit v1.3