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 <jba@google.com>
Reviewed-by: Robert Findley <rfindley@google.com>
kokoro-CI: kokoro <noreply+kokoro@google.com>
Auto-Submit: Ethan Lee <ethanalee@google.com>
LUCI-TryBot-Result: Go LUCI <golang-scoped@luci-project-accounts.iam.gserviceaccount.com>

2 files changed, 19 insertions, 0 deletions

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;