diff options
Diffstat (limited to 'db/migrate/20230102131000_add_smtp_credentials_to_service_desk_settings.rb')
| -rw-r--r-- | db/migrate/20230102131000_add_smtp_credentials_to_service_desk_settings.rb | 28 |
1 files changed, 28 insertions, 0 deletions
diff --git a/db/migrate/20230102131000_add_smtp_credentials_to_service_desk_settings.rb b/db/migrate/20230102131000_add_smtp_credentials_to_service_desk_settings.rb new file mode 100644 index 00000000000..8d3e3860ceb --- /dev/null +++ b/db/migrate/20230102131000_add_smtp_credentials_to_service_desk_settings.rb @@ -0,0 +1,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 |