20160610204157_add_deployments.rb 959 Bytes
Newer Older
1 2 3 4 5 6 7
# See http://doc.gitlab.com/ce/development/migration_style_guide.html
# for more information on how to write migrations for GitLab.
class AddDeployments < ActiveRecord::Migration
  include Gitlab::Database::MigrationHelpers

  def change
    create_table :deployments, force: true do |t|
Kamil Trzcinski's avatar
Kamil Trzcinski committed
8
      t.integer  :iid,            null: false
9 10
      t.integer  :project_id,     null: false
      t.integer  :environment_id, null: false
Kamil Trzcinski's avatar
Kamil Trzcinski committed
11 12 13
      t.string   :ref,            null: false
      t.boolean  :tag,            null: false
      t.string   :sha,            null: false
14
      t.integer  :user_id
15 16
      t.integer  :deployable_id
      t.string   :deployable_type
17 18 19 20 21
      t.datetime :created_at
      t.datetime :updated_at
    end

    add_index :deployments, :project_id
22
    add_index :deployments, [:project_id, :iid], unique: true
23 24 25 26
    add_index :deployments, [:project_id, :environment_id]
    add_index :deployments, [:project_id, :environment_id, :iid]
  end
end