wehub-resource-sync
75f3dd141c
CodeQL / Analyze (go) (push) Has been cancelled
CodeQL / Analyze (actions) (push) Has been cancelled
CodeQL / Analyze (javascript-typescript) (push) Has been cancelled
CI and Release / lint-frontend (push) Has been cancelled
CI and Release / dockerfile-scan (push) Has been cancelled
CI and Release / test-frontend (push) Has been cancelled
CI and Release / lint-verification-agent (push) Has been cancelled
CI and Release / test-verification-agent (push) Has been cancelled
CI and Release / e2e-verification-agent (push) Has been cancelled
CI and Release / test-backend (push) Has been cancelled
CI and Release / build-dev-image (push) Has been cancelled
CI and Release / push-dev-image (push) Has been cancelled
CI and Release / build-image (push) Has been cancelled
CI and Release / build-verification-image (push) Has been cancelled
CI and Release / determine-version (push) Has been cancelled
CI and Release / push-image (push) Has been cancelled
CI and Release / push-verification-image (12) (push) Has been cancelled
CI and Release / lint-backend (push) Has been cancelled
CI and Release / push-verification-image (17) (push) Has been cancelled
CI and Release / push-verification-image (18) (push) Has been cancelled
CI and Release / release (push) Has been cancelled
CI and Release / publish-helm-chart (push) Has been cancelled
CI and Release / push-verification-image (13) (push) Has been cancelled
CI and Release / push-verification-image (14) (push) Has been cancelled
CI and Release / push-verification-image (15) (push) Has been cancelled
CI and Release / push-verification-image (16) (push) Has been cancelled
36 lines
857 B
SQL
36 lines
857 B
SQL
-- +goose Up
|
|
-- +goose StatementBegin
|
|
|
|
ALTER TABLE postgresql_databases
|
|
ADD COLUMN ssl_mode TEXT NOT NULL DEFAULT 'disable',
|
|
ADD COLUMN ssl_client_cert TEXT NOT NULL DEFAULT '',
|
|
ADD COLUMN ssl_client_key TEXT NOT NULL DEFAULT '',
|
|
ADD COLUMN ssl_root_cert TEXT NOT NULL DEFAULT '';
|
|
|
|
UPDATE postgresql_databases
|
|
SET ssl_mode = 'require'
|
|
WHERE is_https = TRUE;
|
|
|
|
ALTER TABLE postgresql_databases
|
|
DROP COLUMN is_https;
|
|
|
|
-- +goose StatementEnd
|
|
|
|
-- +goose Down
|
|
-- +goose StatementBegin
|
|
|
|
ALTER TABLE postgresql_databases
|
|
ADD COLUMN is_https BOOLEAN NOT NULL DEFAULT FALSE;
|
|
|
|
UPDATE postgresql_databases
|
|
SET is_https = TRUE
|
|
WHERE ssl_mode <> 'disable';
|
|
|
|
ALTER TABLE postgresql_databases
|
|
DROP COLUMN ssl_mode,
|
|
DROP COLUMN ssl_client_cert,
|
|
DROP COLUMN ssl_client_key,
|
|
DROP COLUMN ssl_root_cert;
|
|
|
|
-- +goose StatementEnd
|