Sha256: f4dedfc84e4bad0278298318b017844c0046a699dfdc167ff8fa7c9075e7adf4

Contents?: true

Size: 833 Bytes

Versions: 11

Compression:

Stored size: 833 Bytes

Contents

class CreateOffices < ActiveRecord::Migration
  def change
    create_table :offices, options: 'DEFAULT CHARSET=utf8' do |t|
      t.string :office_key
      t.string :office_identifier, null: false
      t.string :level
      t.string :office_code_identifier
      t.string :name
      t.string :franchise_affiliation
      t.string :corporate_name
      t.string :broker_identifier
      t.string :main_office_identifier
      t.string :phone_number
      t.string :office_fax
      t.string :office_email
      t.string :website
      t.boolean :idx_office_participation_yn
      t.string :main_office_key
      t.string :main_office_mlsid
      t.string :office_broker_key
      t.string :office_broker_mlsid

      t.timestamps
    end
    add_index :offices, :name
    add_index :offices, [:office_identifier, :name]

  end
end

Version data entries

11 entries across 11 versions & 1 rubygems

Version Path
reso-0.1.6.7 lib/generators/reso/templates/create_offices.rb
reso-0.1.6.6 lib/generators/reso/templates/create_offices.rb
reso-0.1.6.5 lib/generators/reso/templates/create_offices.rb
reso-0.1.6.4 lib/generators/reso/templates/create_offices.rb
reso-0.1.6.3 lib/generators/reso/templates/create_offices.rb
reso-0.1.6.2 lib/generators/reso/templates/create_offices.rb
reso-0.1.6.1 lib/generators/reso/templates/create_offices.rb
reso-0.1.6 lib/generators/reso/templates/create_offices.rb
reso-0.1.5.11 lib/generators/reso/templates/create_offices.rb
reso-0.1.5.10 lib/generators/reso/templates/create_offices.rb
reso-0.1.5.9 lib/generators/reso/templates/create_offices.rb