pkgsite/migrations/000084_new_documentation.up...

41 строка
1.6 KiB
PL/PgSQL

-- 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;
CREATE TABLE new_documentation (
id bigint PRIMARY KEY GENERATED ALWAYS AS IDENTITY,
unit_id INTEGER NOT NULL,
goos goos NOT NULL,
goarch goarch NOT NULL,
synopsis text NOT NULL,
source bytea,
UNIQUE (unit_id, goos, goarch),
FOREIGN KEY (unit_id) REFERENCES units(id) ON DELETE CASCADE
);
COMMENT ON TABLE new_documentation
IS 'TABLE documentation contains documentation for packages in the database.';
COMMENT ON COLUMN new_documentation.source
IS 'COLUMN source contains the encoded ast.Files for the package.';
ALTER TABLE documentation_symbols DROP COLUMN id;
ALTER TABLE documentation_symbols RENAME COLUMN id_bigint TO id;
ALTER TABLE documentation_symbols ADD PRIMARY KEY (id);
ALTER TABLE documentation_symbols ALTER COLUMN id ADD GENERATED ALWAYS AS IDENTITY;
ALTER TABLE documentation_symbols
ADD CONSTRAINT documentation_symbols_documentation_id_fkey
FOREIGN KEY (documentation_id)
REFERENCES new_documentation(id) ON DELETE CASCADE;
ALTER TABLE package_symbols DROP COLUMN id CASCADE;
ALTER TABLE package_symbols RENAME COLUMN id_bigint TO id;
ALTER TABLE package_symbols ADD PRIMARY KEY (id);
ALTER TABLE package_symbols ALTER COLUMN id ADD GENERATED ALWAYS AS IDENTITY;
ALTER TABLE documentation_symbols
ADD CONSTRAINT documentation_symbols_package_id_fkey
FOREIGN KEY (package_symbol_id)
REFERENCES package_symbols(id) ON DELETE CASCADE;
END;