Sha256: 59caa3530179ebdea8734c522cb32bd2fad69bb9a21cd5da0478fe6c7e794c15
Contents?: true
Size: 1.66 KB
Versions: 9
Compression:
Stored size: 1.66 KB
Contents
class CreatePatrons < ActiveRecord::Migration
def change
create_table :agents do |t|
t.integer :user_id
t.string :last_name
t.string :middle_name
t.string :first_name
t.string :last_name_transcription
t.string :middle_name_transcription
t.string :first_name_transcription
t.string :corporate_name
t.string :corporate_name_transcription
t.string :full_name
t.text :full_name_transcription
t.text :full_name_alternative
t.timestamps
t.datetime :deleted_at
t.string :zip_code_1
t.string :zip_code_2
t.text :address_1
t.text :address_2
t.text :address_1_note
t.text :address_2_note
t.string :telephone_number_1
t.string :telephone_number_2
t.string :fax_number_1
t.string :fax_number_2
t.text :other_designation
t.text :place
t.string :postal_code
t.text :street
t.text :locality
t.text :region
t.datetime :date_of_birth
t.datetime :date_of_death
t.integer :language_id, :default => 1, :null => false
t.integer :country_id, :default => 1, :null => false
t.integer :agent_type_id, :default => 1, :null => false
t.integer :lock_version, :default => 0, :null => false
t.text :note
t.integer :required_role_id, :default => 1, :null => false
t.integer :required_score, :default => 0, :null => false
t.string :state
t.text :email
t.text :url
end
add_index :agents, :user_id, :unique => true
add_index :agents, :language_id
add_index :agents, :country_id
add_index :agents, :required_role_id
add_index :agents, :full_name
end
end
Version data entries
9 entries across 9 versions & 1 rubygems