diff options
| author | Julie Qiu <julie@golang.org> | 2021-02-22 17:07:15 +0000 |
|---|---|---|
| committer | Julie Qiu <julie@golang.org> | 2021-02-22 18:52:53 +0000 |
| commit | 25a7f2100b780df02c19f9eb45f7d7aab1a111ef (patch) | |
| tree | b0f5cb083987e6a032383bb634d15335725e477b | |
| parent | 11d4ef323a9a18870448c8291fe6666d9bae7134 (diff) | |
| download | go-x-pkgsite-25a7f2100b780df02c19f9eb45f7d7aab1a111ef.tar.xz | |
Revert "migrations: add documentation.id column"
This reverts commit 3a43854c9c02abc6b609ef56e973491f6e24d571.
Reason for revert: can't run ALTER TABLE documentation ADD COLUMN id INTEGER GENERATED ALWAYS AS IDENTITY PRIMARY KEY; see CL 294470
Change-Id: I3f95e44be2e5a5e196ede53cc41bd0912ef9a560
Reviewed-on: https://go-review.googlesource.com/c/pkgsite/+/295070
Trust: Julie Qiu <julie@golang.org>
Run-TryBot: Julie Qiu <julie@golang.org>
TryBot-Result: kokoro <noreply+kokoro@google.com>
Reviewed-by: Jamal Carvalho <jamal@golang.org>
| -rw-r--r-- | migrations/000069_add_documentation_id_column.down.sql | 12 | ||||
| -rw-r--r-- | migrations/000069_add_documentation_id_column.up.sql | 11 |
2 files changed, 0 insertions, 23 deletions
diff --git a/migrations/000069_add_documentation_id_column.down.sql b/migrations/000069_add_documentation_id_column.down.sql deleted file mode 100644 index 7d3a5f97..00000000 --- a/migrations/000069_add_documentation_id_column.down.sql +++ /dev/null @@ -1,12 +0,0 @@ --- 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 documentation DROP CONSTRAINT documentation_pkey; -DROP INDEX documentation_unit_id_goos_goarch_key; -ALTER TABLE documentation ADD PRIMARY KEY (unit_id, goos, goarch); -ALTER TABLE documentation DROP COLUMN id; - -END; diff --git a/migrations/000069_add_documentation_id_column.up.sql b/migrations/000069_add_documentation_id_column.up.sql deleted file mode 100644 index 3fc1f07d..00000000 --- a/migrations/000069_add_documentation_id_column.up.sql +++ /dev/null @@ -1,11 +0,0 @@ --- 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 documentation DROP CONSTRAINT documentation_pkey; -ALTER TABLE documentation ADD COLUMN id INTEGER GENERATED ALWAYS AS IDENTITY PRIMARY KEY; -CREATE UNIQUE INDEX documentation_unit_id_goos_goarch_key ON documentation (unit_id, goos, goarch); - -END; |