Sha256: ac57a1b8af751da38e4265e4baeaa411aac0f6010343f999b7d27f50fb42adbf

Contents?: true

Size: 712 Bytes

Versions: 11

Compression:

Stored size: 712 Bytes

Contents

class CreateDeathMasterFileTable < ActiveRecord::Migration
  
  def self.up
    create_table :death_master_files do |t|
      t.string :social_security_number
      t.string  :last_name
      t.string  :name_suffix
      t.string :first_name
      t.string :middle_name
      t.string :verify_proof_code
      t.date  :date_of_death
      t.date  :date_of_birth
      t.string  :state_of_residence
      t.string :last_known_zip_residence
      t.string :last_known_zip_payment
      t.time_stamps
      t.date :as_of
    end
    add_index :death_master_files, :social_security_number, :unique => true
    add_index :death_master_files, :as_of
  end

  def self.down
    drop_table :death_master_files
  end
end

Version data entries

11 entries across 11 versions & 2 rubygems

Version Path
kevintyll-ssn_validator-1.0.0 generators/death_master_file_migration/templates/migration.rb
kevintyll-ssn_validator-1.0.1 generators/death_master_file_migration/templates/migration.rb
kevintyll-ssn_validator-1.0.2 generators/death_master_file_migration/templates/migration.rb
kevintyll-ssn_validator-1.0.3 generators/death_master_file_migration/templates/migration.rb
ssn_validator-1.0.11 generators/death_master_file_migration/templates/migration.rb
ssn_validator-1.0.10 generators/death_master_file_migration/templates/migration.rb
ssn_validator-1.0.9 generators/death_master_file_migration/templates/migration.rb
ssn_validator-1.0.8 generators/death_master_file_migration/templates/migration.rb
ssn_validator-1.0.7 generators/death_master_file_migration/templates/migration.rb
ssn_validator-1.0.6 generators/death_master_file_migration/templates/migration.rb
ssn_validator-1.0.4 generators/death_master_file_migration/templates/migration.rb