Class: CreateGeoips

Inherits:
ActiveRecord::Migration
  • Object
show all
Defined in:
lib/generators/geoip/templates/migration.rb

Class Method Summary collapse

Class Method Details

.down ⇒ Object 



20
21
22
 
# File 'lib/generators/geoip/templates/migration.rb', line 20

def self.down
  drop_table :geoips
end

.up ⇒ Object 



4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
 
# File 'lib/generators/geoip/templates/migration.rb', line 4

def self.up
  create_table :geoips, id: false do |t|
    t.string :ip_from_string, null: false, limit: 15
    t.string :ip_to_string, null: false, limit: 15
    t.integer :ip_from, null: false, limit: 8
    t.integer :ip_to, null: false, limit: 8
    t.string :country_code, null: false, limit: 2
    t.string :country_name, null: false, limit: 64
  end

  execute "ALTER TABLE geoips ADD CONSTRAINT geoips_pkey PRIMARY KEY(ip_from, ip_to);"

  add_index :geoips, :ip_from, unique: true
  add_index :geoips, :ip_to, unique: true
end