diff options
author | Kamil Trzcinski <ayufan@ayufan.eu> | 2017-12-04 21:23:44 +0300 |
---|---|---|
committer | Kamil Trzcinski <ayufan@ayufan.eu> | 2017-12-04 22:21:49 +0300 |
commit | e58ce2b72eec6b92986884ee80b974b83134b7f4 (patch) | |
tree | c1d411e762f4a62d39a3b66dbebef394a844fc35 /db | |
parent | dd0e3412034bf9227c415455f230fe4b28439f2c (diff) |
Remove index on file_type
Diffstat (limited to 'db')
-rw-r--r-- | db/migrate/20170918072948_create_job_artifacts.rb | 4 | ||||
-rw-r--r-- | db/schema.rb | 2 |
2 files changed, 2 insertions, 4 deletions
diff --git a/db/migrate/20170918072948_create_job_artifacts.rb b/db/migrate/20170918072948_create_job_artifacts.rb index d6c6a228ed1..304b3fce5be 100644 --- a/db/migrate/20170918072948_create_job_artifacts.rb +++ b/db/migrate/20170918072948_create_job_artifacts.rb @@ -6,8 +6,8 @@ class CreateJobArtifacts < ActiveRecord::Migration def change create_table :ci_job_artifacts do |t| t.belongs_to :project, null: false, index: true, foreign_key: { on_delete: :cascade } - t.integer :job_id, null: false, index: true - t.integer :file_type, null: false, index: true + t.integer :job_id, null: false + t.integer :file_type, null: false t.integer :size, limit: 8 t.datetime_with_timezone :created_at, null: false diff --git a/db/schema.rb b/db/schema.rb index 64f67574b3f..de84d861530 100644 --- a/db/schema.rb +++ b/db/schema.rb @@ -330,9 +330,7 @@ ActiveRecord::Schema.define(version: 20171130145523) do t.string "file" end - add_index "ci_job_artifacts", ["file_type"], name: "index_ci_job_artifacts_on_file_type", using: :btree add_index "ci_job_artifacts", ["job_id", "file_type"], name: "index_ci_job_artifacts_on_job_id_and_file_type", unique: true, using: :btree - add_index "ci_job_artifacts", ["job_id"], name: "index_ci_job_artifacts_on_job_id", using: :btree add_index "ci_job_artifacts", ["project_id"], name: "index_ci_job_artifacts_on_project_id", using: :btree create_table "ci_pipeline_schedule_variables", force: :cascade do |t| |