summaryrefslogtreecommitdiff
path: root/db/migrate/20160610204157_add_deployments.rb
blob: 0e7e6e747a369c2aadf5c89c40341f31463b728e (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
26
27
28
# See http://doc.gitlab.com/ce/development/migration_style_guide.html
# for more information on how to write migrations for GitLab.

# rubocop:disable Migration/Datetime
class AddDeployments < ActiveRecord::Migration
  include Gitlab::Database::MigrationHelpers

  def change
    create_table :deployments, force: true do |t|
      t.integer  :iid,            null: false
      t.integer  :project_id,     null: false
      t.integer  :environment_id, null: false
      t.string   :ref,            null: false
      t.boolean  :tag,            null: false
      t.string   :sha,            null: false
      t.integer  :user_id
      t.integer  :deployable_id
      t.string   :deployable_type
      t.datetime :created_at
      t.datetime :updated_at
    end

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