migrations: add symbols.module_path_id and symbols.package_path_id
The symbols.series_id and symbols.v1path_id are changes to
symbols.module_path_id and symbols.package_path_id.
For each symbol in a package, we care about how it changes relevant to
the module that it is in, but not across major versions or nested
modules.
Change-Id: I014e219dc79ad8bd67e6e746e9b8d8e3952ee1ef
Reviewed-on: https://go-review.googlesource.com/c/pkgsite/+/290514
Trust: Julie Qiu <julie@golang.org>
Run-TryBot: Julie Qiu <julie@golang.org>
TryBot-Result: kokoro <noreply+kokoro@google.com>
Reviewed-by: Jonathan Amsterdam <jba@google.com>
diff --git a/migrations/000064_change_symbol_table_columns.down.sql b/migrations/000064_change_symbol_table_columns.down.sql
new file mode 100644
index 0000000..2e0737f
--- /dev/null
+++ b/migrations/000064_change_symbol_table_columns.down.sql
@@ -0,0 +1,10 @@
+-- Copyright 2021 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;
+
+ALTER TABLE symbol_history RENAME module_path_id TO series_id;
+ALTER TABLE symbol_history RENAME package_path_id TO v1path_id;
+
+END;
diff --git a/migrations/000064_change_symbol_table_columns.up.sql b/migrations/000064_change_symbol_table_columns.up.sql
new file mode 100644
index 0000000..ef42d92
--- /dev/null
+++ b/migrations/000064_change_symbol_table_columns.up.sql
@@ -0,0 +1,10 @@
+-- Copyright 2021 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;
+
+ALTER TABLE symbol_history RENAME series_id TO module_path_id;
+ALTER TABLE symbol_history RENAME v1path_id TO package_path_id;
+
+END;
