20160610204157_add_deployments.rb 946 Bytes
Newer Older
1 2 3 4 5 6 7 8
# 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
9
      t.integer  :iid,            null: false
10 11
      t.integer  :project_id,     null: false
      t.integer  :environment_id, null: false
Kamil Trzcinski's avatar
Kamil Trzcinski committed
12 13 14
      t.string   :ref,            null: false
      t.boolean  :tag,            null: false
      t.string   :sha,            null: false
15
      t.integer  :user_id
16 17
      t.integer  :deployable_id
      t.string   :deployable_type
18 19 20 21 22 23 24 25 26 27
      t.datetime :created_at
      t.datetime :updated_at
    end

    add_index :deployments, :project_id
    add_index :deployments, [:project_id, :iid]
    add_index :deployments, [:project_id, :environment_id]
    add_index :deployments, [:project_id, :environment_id, :iid]
  end
end