29 lines
1.5 KiB
Ruby
29 lines
1.5 KiB
Ruby
# frozen_string_literal: true
|
|
|
|
class AddSmtpCredentialsToServiceDeskSettings < Gitlab::Database::Migration[2.1]
|
|
def up
|
|
# rubocop:disable Migration/AddLimitToTextColumns
|
|
# limit is added in 20230102131100_add_text_limits_to_smtp_credentials_on_service_desk_settings.rb
|
|
add_column :service_desk_settings, :custom_email_enabled, :boolean, default: false, null: false
|
|
# Unique constraint/index is added in 20230102131050_add_unique_constraint_for_custom_email_to_...
|
|
add_column :service_desk_settings, :custom_email, :text
|
|
add_column :service_desk_settings, :custom_email_smtp_address, :text
|
|
add_column :service_desk_settings, :custom_email_smtp_port, :integer
|
|
add_column :service_desk_settings, :custom_email_smtp_username, :text
|
|
# Encrypted attribute via attr_encrypted needs these two columns
|
|
add_column :service_desk_settings, :encrypted_custom_email_smtp_password, :binary
|
|
add_column :service_desk_settings, :encrypted_custom_email_smtp_password_iv, :binary
|
|
# rubocop:enable Migration/AddLimitToTextColumns
|
|
end
|
|
|
|
def down
|
|
remove_column :service_desk_settings, :custom_email_enabled
|
|
remove_column :service_desk_settings, :custom_email
|
|
remove_column :service_desk_settings, :custom_email_smtp_address
|
|
remove_column :service_desk_settings, :custom_email_smtp_port
|
|
remove_column :service_desk_settings, :custom_email_smtp_username
|
|
remove_column :service_desk_settings, :encrypted_custom_email_smtp_password
|
|
remove_column :service_desk_settings, :encrypted_custom_email_smtp_password_iv
|
|
end
|
|
end
|