hugopl/reviewit

class CreateTables < ActiveRecord::Migration
  def change
    create_table(:users) do |t|
      ## Database authenticatable
      t.string :name,               null: false
      t.string :email,              null: false, default: ''
      t.string :encrypted_password, null: false, default: ''

      ## Recoverable
      t.string   :reset_password_token
      t.datetime :reset_password_sent_at

      ## Rememberable
      t.datetime :remember_created_at

      ## Trackable
      t.integer  :sign_in_count, default: 0, null: false
      t.datetime :current_sign_in_at
      t.datetime :last_sign_in_at
      t.string   :current_sign_in_ip
      t.string   :last_sign_in_ip

      t.string   :api_token, unique: true

      t.timestamps
    end

    add_index :users, :email,                unique: true
    add_index :users, :reset_password_token, unique: true

    create_table :projects do |t|
      t.string :name, unique: true, null: false
      t.string :description, default: '', null: false
      t.string :repository, null: false
      t.string :linter,     default: '', null: false
      t.timestamps
    end

    create_table :projects_users, id: false do |t|
      t.references :project, index: true, null: false
      t.references :user,    index: true, null: false
    end

    add_index :projects_users, %i(project_id user_id), unique: true

    create_table :merge_requests do |t|
      t.references :project,  index: true
      t.belongs_to :author,   index: true, class_name: 'User'
      t.belongs_to :reviewer, index: true, class_name: 'User'
      t.integer :status,      default: 0, null: false
      t.string :target_branch, null: false
      t.string :subject, null: false
      t.timestamps
    end

    create_table :patches do |t|
      t.references :merge_request, index: true
      t.text       :description,   default: ''
      t.text       :commit_message, null: false
      t.text       :diff,          default: '', null: false
      t.boolean    :linter_ok,     default: false, null: false
      t.text       :integration_log
      t.timestamps
    end

    create_table :comments do |t|
      t.references :user,    null: false
      t.references :patch,   index: true
      t.text       :content, default: '', null: false
      t.integer    :location, default: 0
      t.timestamps
    end
  end
end