migrations: add missing not null constraints
NOT NULL constraints are added to search_documents and
symbol_search_documents.
Change-Id: I56f783217977f51b6be9ce1ce20df69b6189372f
Reviewed-on: https://go-review.googlesource.com/c/pkgsite/+/345309
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/000144_add_not_null_constraints.down.sql b/migrations/000144_add_not_null_constraints.down.sql
new file mode 100644
index 0000000..23a6fe5
--- /dev/null
+++ b/migrations/000144_add_not_null_constraints.down.sql
@@ -0,0 +1,19 @@
+-- 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 search_documents ALTER COLUMN tsv_path_tokens DROP NOT NULL;
+ALTER TABLE symbol_search_documents ALTER COLUMN created_at DROP NOT NULL;
+ALTER TABLE symbol_search_documents ALTER COLUMN updated_at DROP NOT NULL;
+ALTER TABLE symbol_search_documents ALTER COLUMN updated_at DROP NOT NULL;
+ALTER TABLE symbol_search_documents ALTER COLUMN goos DROP NOT NULL;
+ALTER TABLE symbol_search_documents ALTER COLUMN goarch DROP NOT NULL;
+ALTER TABLE symbol_search_documents ALTER COLUMN goarch DROP NOT NULL;
+ALTER TABLE symbol_search_documents ALTER COLUMN package_name DROP NOT NULL;
+ALTER TABLE symbol_search_documents ALTER COLUMN package_path DROP NOT NULL;
+ALTER TABLE symbol_search_documents ALTER COLUMN uuid_package_name DROP NOT NULL;
+ALTER TABLE symbol_search_documents ALTER COLUMN uuid_package_path DROP NOT NULL;
+
+END;
diff --git a/migrations/000144_add_not_null_constraints.up.sql b/migrations/000144_add_not_null_constraints.up.sql
new file mode 100644
index 0000000..f812a4e
--- /dev/null
+++ b/migrations/000144_add_not_null_constraints.up.sql
@@ -0,0 +1,19 @@
+-- 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 search_documents ALTER COLUMN tsv_path_tokens SET NOT NULL;
+ALTER TABLE symbol_search_documents ALTER COLUMN created_at SET NOT NULL;
+ALTER TABLE symbol_search_documents ALTER COLUMN updated_at SET NOT NULL;
+ALTER TABLE symbol_search_documents ALTER COLUMN updated_at SET NOT NULL;
+ALTER TABLE symbol_search_documents ALTER COLUMN goos SET NOT NULL;
+ALTER TABLE symbol_search_documents ALTER COLUMN goarch SET NOT NULL;
+ALTER TABLE symbol_search_documents ALTER COLUMN goarch SET NOT NULL;
+ALTER TABLE symbol_search_documents ALTER COLUMN package_name SET NOT NULL;
+ALTER TABLE symbol_search_documents ALTER COLUMN package_path SET NOT NULL;
+ALTER TABLE symbol_search_documents ALTER COLUMN uuid_package_name SET NOT NULL;
+ALTER TABLE symbol_search_documents ALTER COLUMN uuid_package_path SET NOT NULL;
+
+END;
