summaryrefslogtreecommitdiff
path: root/db/migrate/20220913043728_create_user_phone_number_validations.rb
blob: 21a5b4d55191769a6f4077c0e26625ed953c02a7 (plain)
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
29
# frozen_string_literal: true

class CreateUserPhoneNumberValidations < Gitlab::Database::Migration[2.0]
  enable_lock_retries!

  def up
    create_table :user_phone_number_validations, id: false do |t|
      t.references :user, primary_key: true, default: nil, type: :bigint, index: false,
                          foreign_key: { on_delete: :cascade }

      t.datetime_with_timezone :validated_at
      t.timestamps_with_timezone null: false

      t.integer :international_dial_code, null: false, limit: 1
      t.integer :verification_attempts, null: false, default: 0, limit: 1
      t.integer :risk_score, null: false, default: 0, limit: 1

      t.text :country, null: false, limit: 3
      t.text :phone_number, null: false, limit: 12
      t.text :telesign_reference_xid, limit: 255

      t.index [:international_dial_code, :phone_number], name: :index_user_phone_validations_on_dial_code_phone_number
    end
  end

  def down
    drop_table :user_phone_number_validations
  end
end