migrations/000144_add_not_null_constraints.up.sql

-- 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;