mirror of
https://github.com/ubicloud/ubicloud.git
synced 2025-10-05 22:31:57 +08:00
405fb09d85Adds a `version` column to PostgresServer and `desired_version` column to PostgresResource. With major version upgrades, version becomes a server-scoped attribute. In a future commit, will replace all references to postgres_resource.version with a variant of postgres_resource.representative_server.version.
25 lines
522 B
Ruby
25 lines
522 B
Ruby
# frozen_string_literal: true
|
|
|
|
Sequel.migration do
|
|
up do
|
|
alter_table(:postgres_server) do
|
|
add_column :version, :postgres_version, null: true
|
|
end
|
|
|
|
alter_table(:postgres_resource) do
|
|
add_column :desired_version, :postgres_version, null: true
|
|
end
|
|
|
|
run "UPDATE postgres_resource SET desired_version = version"
|
|
end
|
|
|
|
down do
|
|
alter_table(:postgres_server) do
|
|
drop_column :version
|
|
end
|
|
|
|
alter_table(:postgres_resource) do
|
|
drop_column :desired_version
|
|
end
|
|
end
|
|
end
|