Sha256: 9370c141d5c0a32e2d9f036b649ae2b794bf2dd9b82752d10ca9fc3e2b399c59

Contents?: true

Size: 1.99 KB

Versions: 79

Compression:

Stored size: 1.99 KB

Contents

class CreatePatrons < ActiveRecord::Migration
  def change
    create_table :patrons 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 :patron_type_id, :default => 1, :null => false
      t.integer :lock_version, :default => 0, :null => false
      t.text :note
      t.integer :creates_count, :default => 0, :null => false
      t.integer :realizes_count, :default => 0, :null => false
      t.integer :produces_count, :default => 0, :null => false
      t.integer :owns_count, :default => 0, :null => false
      #t.integer :resource_has_subjects_count, :default => 0, :null => false
      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 :patrons, :user_id, :unique => true
    add_index :patrons, :language_id
    add_index :patrons, :country_id
    add_index :patrons, :required_role_id
    add_index :patrons, :full_name
  end
end

Version data entries

79 entries across 78 versions & 2 rubygems

Version Path
enju_circulation-0.1.0.pre29 spec/dummy/db/migrate/001_create_patrons.rb
enju_circulation-0.1.0.pre29 spec/dummy/db/migrate/001_create_agents.rb
enju_library-0.1.0.pre24 spec/dummy/db/migrate/001_create_patrons.rb
enju_circulation-0.1.0.pre28 spec/dummy/db/migrate/001_create_patrons.rb
enju_circulation-0.1.0.pre27 spec/dummy/db/migrate/001_create_patrons.rb
enju_circulation-0.1.0.pre26 spec/dummy/db/migrate/001_create_patrons.rb
enju_library-0.1.0.pre23 spec/dummy/db/migrate/001_create_patrons.rb
enju_circulation-0.1.0.pre25 spec/dummy/db/migrate/001_create_patrons.rb
enju_circulation-0.1.0.pre24 spec/dummy/db/migrate/001_create_patrons.rb
enju_library-0.1.0.pre22 spec/dummy/db/migrate/001_create_patrons.rb
enju_circulation-0.1.0.pre23 spec/dummy/db/migrate/001_create_patrons.rb
enju_circulation-0.1.0.pre22 spec/dummy/db/migrate/001_create_patrons.rb
enju_library-0.1.0.pre21 spec/dummy/db/migrate/001_create_patrons.rb
enju_circulation-0.1.0.pre21 spec/dummy/db/migrate/001_create_patrons.rb
enju_circulation-0.1.0.pre20 spec/dummy/db/migrate/001_create_patrons.rb
enju_library-0.1.0.pre20 spec/dummy/db/migrate/001_create_patrons.rb
enju_library-0.1.0.pre19 spec/dummy/db/migrate/001_create_patrons.rb
enju_library-0.1.0.pre18 spec/dummy/db/migrate/001_create_patrons.rb
enju_circulation-0.1.0.pre19 spec/dummy/db/migrate/001_create_patrons.rb
enju_circulation-0.1.0.pre18 spec/dummy/db/migrate/001_create_patrons.rb