migrations: drop unused columns
For golang/go#44142
Change-Id: I79d57d96f033197298d9f2219f6acaeeabcc873a
Reviewed-on: https://go-review.googlesource.com/c/pkgsite/+/349609
Trust: Julie Qiu <julie@golang.org>
Reviewed-by: Jamal Carvalho <jamal@golang.org>
diff --git a/migrations/000151_drop_unused_columns.down.sql b/migrations/000151_drop_unused_columns.down.sql
new file mode 100644
index 0000000..bb43efd
--- /dev/null
+++ b/migrations/000151_drop_unused_columns.down.sql
@@ -0,0 +1,14 @@
+-- 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_names ADD COLUMN tsv_name_tokens TSVECTOR;
+ALTER TABLE symbol_search_documents ADD COLUMN tsv_symbol_tokens TSVECTOR;
+
+CREATE TRIGGER set_symbol_names_tsv_name_tokens
+BEFORE INSERT OR UPDATE ON symbol_names
+FOR EACH ROW EXECUTE FUNCTION set_tsv_name_tokens();
+
+END;
diff --git a/migrations/000151_drop_unused_columns.up.sql b/migrations/000151_drop_unused_columns.up.sql
new file mode 100644
index 0000000..bc8310f
--- /dev/null
+++ b/migrations/000151_drop_unused_columns.up.sql
@@ -0,0 +1,11 @@
+-- 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;
+
+DROP TRIGGER set_symbol_names_tsv_name_tokens ON symbol_names;
+ALTER TABLE symbol_names DROP COLUMN tsv_name_tokens;
+ALTER TABLE symbol_search_documents DROP COLUMN tsv_symbol_tokens;
+
+END;
