Sha256: 90674a4f5250addd2f3926a8867d05bb358dae382392b6673ad7a3400f9d47bb

Contents?: true

Size: 1.19 KB

Versions: 129

Compression:

Stored size: 1.19 KB

Contents

class CreateCountries < ActiveRecord::Migration[4.2]

  # ISO 3166 is the International Standard for country codes.
  #
  # ISO 3166-1:2006 Codes for the representation of names of countries and their subdivisions - Part 1: 
  # Country codes which is what most users know as ISO's country codes. First published in 1974, it is has since 
  # then become one of the world's most popular and most widely used standard solution for coding country names. 
  # It contains a two-letter code which is recommended as the general purpose code, a three-letter code which has 
  # better mnenomic properties and a numeric-3 code which can be useful if script independence of the codes is important.
  #
  # http://www.iso.org/iso/country_codes/background_on_iso_3166/what_is_iso_3166.htm

  def change
    create_table :countries do |t|
      t.string :name,         size: 80, null: false
      t.text :display_name
      t.string :alpha_2,      size: 2
      t.string :alpha_3,      size: 3
      t.string :numeric_3, size: 3
      t.text :note
      t.integer :position
    end
    add_index :countries, :name
    add_index :countries, :alpha_2
    add_index :countries, :alpha_3
    add_index :countries, :numeric_3
  end
end

Version data entries

129 entries across 129 versions & 19 rubygems

Version Path
enju_biblio-0.3.18 db/migrate/20081025083323_create_countries.rb
enju_biblio-0.3.17 db/migrate/20081025083323_create_countries.rb
enju_biblio-0.3.16 db/migrate/20081025083323_create_countries.rb
enju_circulation-0.3.11 spec/dummy/db/migrate/20081025083323_create_countries.rb
enju_biblio-0.3.15 db/migrate/20081025083323_create_countries.rb
enju_library-0.3.11 spec/dummy/db/migrate/20081025083323_create_countries.rb
enju_ndl-0.3.3 spec/dummy/db/migrate/20081025083323_create_countries.rb
enju_nii-0.3.2 spec/dummy/db/migrate/20081025083323_create_countries.rb
enju_loc-0.3.1 spec/dummy/db/migrate/20081025083323_create_countries.rb
enju_subject-0.3.4 spec/dummy/db/migrate/20081025083323_create_countries.rb
enju_circulation-0.3.10 spec/dummy/db/migrate/20081025083323_create_countries.rb
enju_library-0.3.10 spec/dummy/db/migrate/20081025083323_create_countries.rb
enju_biblio-0.3.14 db/migrate/20081025083323_create_countries.rb
enju_message-0.3.4 spec/dummy/db/migrate/20081025083323_create_countries.rb
enju_event-0.3.5 spec/dummy/db/migrate/20081025083323_create_countries.rb
enju_bookmark-0.3.2 spec/dummy/db/migrate/20081025083323_create_countries.rb
enju_seed-0.3.6 spec/dummy/db/migrate/20081025083323_create_countries.rb
enju_biblio-0.3.13 db/migrate/20081025083323_create_countries.rb
enju_circulation-0.3.9 spec/dummy/db/migrate/20081025083323_create_countries.rb
enju_biblio-0.3.12 db/migrate/20081025083323_create_countries.rb