diff options
| author | Alexis Reigel <mail@koffeinfrei.org> | 2017-07-25 20:31:34 +0200 |
|---|---|---|
| committer | Alexis Reigel <mail@koffeinfrei.org> | 2017-07-27 15:46:03 +0200 |
| commit | 14551424c9fd3a9401559e6d2da34be8d1fdd45c (patch) | |
| tree | a79d281a2bafb3cf0002f170a028297db95e5e4b /db | |
| parent | 07dbd5649ad18e4473c10ef8a1a70ea863b88cc4 (diff) | |
| download | gitlab-ce-14551424c9fd3a9401559e6d2da34be8d1fdd45c.tar.gz | |
add unique indexes to gpg_keys
Diffstat (limited to 'db')
| -rw-r--r-- | db/migrate/20170222111732_create_gpg_keys.rb | 3 | ||||
| -rw-r--r-- | db/schema.rb | 3 |
2 files changed, 4 insertions, 2 deletions
diff --git a/db/migrate/20170222111732_create_gpg_keys.rb b/db/migrate/20170222111732_create_gpg_keys.rb index ec619394f6a..541228e8735 100644 --- a/db/migrate/20170222111732_create_gpg_keys.rb +++ b/db/migrate/20170222111732_create_gpg_keys.rb @@ -12,7 +12,8 @@ class CreateGpgKeys < ActiveRecord::Migration t.text :key - t.index :primary_keyid, length: Gitlab::Database.mysql? ? 20 : nil + t.index :primary_keyid, unique: true, length: Gitlab::Database.mysql? ? 20 : nil + t.index :fingerprint, unique: true, length: Gitlab::Database.mysql? ? 20 : nil end end end diff --git a/db/schema.rb b/db/schema.rb index 1a7eb2ded76..2cc8b1624c0 100644 --- a/db/schema.rb +++ b/db/schema.rb @@ -549,7 +549,8 @@ ActiveRecord::Schema.define(version: 20170725145659) do t.text "key" end - add_index "gpg_keys", ["primary_keyid"], name: "index_gpg_keys_on_primary_keyid", using: :btree + add_index "gpg_keys", ["fingerprint"], name: "index_gpg_keys_on_fingerprint", unique: true, using: :btree + add_index "gpg_keys", ["primary_keyid"], name: "index_gpg_keys_on_primary_keyid", unique: true, using: :btree add_index "gpg_keys", ["user_id"], name: "index_gpg_keys_on_user_id", using: :btree create_table "gpg_signatures", force: :cascade do |t| |