Sha256: 0b5b7b731ca18fb1aa23cda671bb002982449dd6d11871db3cf724befc52bdf9

Contents?: true

Size: 859 Bytes

Versions: 27

Compression:

Stored size: 859 Bytes

Contents

class CreateOffices < ActiveRecord::Migration
  def change
    create_table :offices, options: 'DEFAULT CHARSET=utf8' do |t|
      t.string :office_key, null: false
      t.string :office_identifier, null: false
      t.string :level
      t.string :office_code_identifier
      t.string :name, null: false
      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

27 entries across 27 versions & 1 rubygems

Version Path
reso-0.1.5.7 lib/generators/reso/templates/create_offices.rb
reso-0.1.5.6 lib/generators/reso/templates/create_offices.rb
reso-0.1.5.5 lib/generators/reso/templates/create_offices.rb
reso-0.1.5.4 lib/generators/reso/templates/create_offices.rb
reso-0.1.5.3 lib/generators/reso/templates/create_offices.rb
reso-0.1.5.2 lib/generators/reso/templates/create_offices.rb
reso-0.1.5.1 lib/generators/reso/templates/create_offices.rb
reso-0.1.5.0 lib/generators/reso/templates/create_offices.rb
reso-0.1.4.10 lib/generators/reso/templates/create_offices.rb
reso-0.1.4.9 lib/generators/reso/templates/create_offices.rb
reso-0.1.4.8 lib/generators/reso/templates/create_offices.rb
reso-0.1.4.7 lib/generators/reso/templates/create_offices.rb
reso-0.1.4.6 lib/generators/reso/templates/create_offices.rb
reso-0.1.4.5 lib/generators/reso/templates/create_offices.rb
reso-0.1.4.4 lib/generators/reso/templates/create_offices.rb
reso-0.1.4.3 lib/generators/reso/templates/create_offices.rb
reso-0.1.4.2 lib/generators/reso/templates/create_offices.rb
reso-0.1.4.1 lib/generators/reso/templates/create_offices.rb
reso-0.1.4.0 lib/generators/reso/templates/create_offices.rb
reso-0.1.3.1 lib/generators/reso/templates/create_offices.rb