1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
|
# 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
|
