summaryrefslogtreecommitdiff
path: root/db/migrate/20170613154149_create_gpg_signatures.rb
blob: abef13a7a0b646d10728c2ee3dda57e3c6f96961 (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
class CreateGpgSignatures < ActiveRecord::Migration
  include Gitlab::Database::MigrationHelpers

  DOWNTIME = false

  def change
    create_table :gpg_signatures do |t|
      t.timestamps_with_timezone null: false

      t.references :project, index: true, foreign_key: { on_delete: :cascade }
      t.references :gpg_key, index: true, foreign_key: { on_delete: :nullify }

      t.boolean :valid_signature

      t.binary :commit_sha
      t.binary :gpg_key_primary_keyid

      t.text :gpg_key_user_name
      t.text :gpg_key_user_email

      t.index :commit_sha, unique: true, length: mysql_compatible_index_length
      t.index :gpg_key_primary_keyid, length: mysql_compatible_index_length
    end
  end
end