class CreateJusyos
Public Class Methods
down()
click to toggle source
# File lib/generators/dl_jusyo_jp/templates/migrations/create_jusyos.rb, line 35 def self.down drop_table "#{DlJusyoJp::ADDRESS_DOWNLOAD_TABLE}" end
up()
click to toggle source
# File lib/generators/dl_jusyo_jp/templates/migrations/create_jusyos.rb, line 2 def self.up create_table "#{DlJusyoJp::ADDRESS_DOWNLOAD_TABLE}" do |t| t.string :address_code, limit: 9 t.string :prefecture_code, limit: 2 t.string :city_code, limit: 5 t.string :town_code, limit: 9 t.string :zip_code, limit: 8 t.string :is_place, limit: 1 t.string :is_deleted, limit: 1 t.string :prefecture_name t.string :prefecture_name_kana t.string :city_name t.string :city_name_kana t.string :town_name t.string :town_name_kana t.string :town_name_plus t.string :kyoto_name t.string :town_detail t.string :town_detail_kana t.string :memo t.string :place_name t.string :place_name_kana t.string :place_address t.string :new_address_code end add_index "#{DlJusyoJp::ADDRESS_DOWNLOAD_TABLE}", :address_code, name: 'i_address_code' add_index "#{DlJusyoJp::ADDRESS_DOWNLOAD_TABLE}", :prefecture_code, name: 'i_prefecture_code' add_index "#{DlJusyoJp::ADDRESS_DOWNLOAD_TABLE}", :city_code, name: 'i_city_code' add_index "#{DlJusyoJp::ADDRESS_DOWNLOAD_TABLE}", :town_code, name: 'i_town_code' add_index "#{DlJusyoJp::ADDRESS_DOWNLOAD_TABLE}", :zip_code, name: 'i_zip_code' end