SsnValidator::SsnHighGroupCode Load (0.7ms) SELECT "ssn_validator_ssn_high_group_codes".* FROM "ssn_validator_ssn_high_group_codes" WHERE "ssn_validator_ssn_high_group_codes"."area" = '666' AND (as_of <= '2013-09-15') ORDER BY as_of DESC LIMIT 1 SQLite3::SQLException: no such table: ssn_validator_ssn_high_group_codes: SELECT "ssn_validator_ssn_high_group_codes".* FROM "ssn_validator_ssn_high_group_codes" WHERE "ssn_validator_ssn_high_group_codes"."area" = '666' AND (as_of <= '2013-09-15') ORDER BY as_of DESC LIMIT 1  (1.8ms) CREATE TABLE "ssn_validator_ssn_high_group_codes" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "as_of" date, "area" varchar(255), "group" varchar(255), "created_at" datetime, "updated_at" datetime)   (1.6ms) CREATE INDEX "idx_area" ON "ssn_validator_ssn_high_group_codes" ("area")  (1.5ms) CREATE INDEX "idx_area_as_of" ON "ssn_validator_ssn_high_group_codes" ("area", "as_of")  (1.6ms) CREATE TABLE "ssn_validator_death_master_files" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "social_security_number" varchar(255), "last_name" varchar(255), "name_suffix" varchar(255), "first_name" varchar(255), "middle_name" varchar(255), "verify_proof_code" varchar(255), "date_of_death" date, "date_of_birth" date, "state_of_residence" varchar(255), "last_known_zip_residence" varchar(255), "last_known_zip_payment" varchar(255), "created_at" datetime, "updated_at" datetime, "as_of" date)  (1.5ms) CREATE UNIQUE INDEX "idx_ssn" ON "ssn_validator_death_master_files" ("social_security_number")  (1.5ms) CREATE INDEX "idx_as_of" ON "ssn_validator_death_master_files" ("as_of")  (1.7ms) CREATE TABLE "schema_migrations" ("version" varchar(255) NOT NULL)   (1.4ms) CREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")  (0.1ms) SELECT version FROM "schema_migrations"  (1.4ms) INSERT INTO "schema_migrations" (version) VALUES ('1')  (1.7ms) CREATE TABLE "schema_migrations" ("version" varchar(255) NOT NULL)   (1.2ms) CREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version") ActiveRecord::SchemaMigration Load (0.1ms) SELECT "schema_migrations".* FROM "schema_migrations" Migrating to CreateSsnValidatorDeathMasterFiles (20130914201438)  (0.1ms) begin transaction  (0.5ms) CREATE TABLE "death_master_files" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "social_security_number" varchar(255), "last_name" varchar(255), "name_suffix" varchar(255), "first_name" varchar(255), "middle_name" varchar(255), "verify_proof_code" varchar(255), "date_of_death" date, "date_of_birth" date, "state_of_residence" varchar(255), "last_known_zip_residence" varchar(255), "last_known_zip_payment" varchar(255), "created_at" datetime, "updated_at" datetime, "as_of" date)   (0.5ms) CREATE UNIQUE INDEX "idx_ssn" ON "death_master_files" ("social_security_number")  (0.2ms) CREATE INDEX "idx_as_of" ON "death_master_files" ("as_of") SQL (0.3ms) INSERT INTO "schema_migrations" ("version") VALUES (?) [["version", "20130914201438"]]  (1.2ms) commit transaction Migrating to CreateSsnHighGroupCodes (20130914201538)  (0.1ms) begin transaction  (0.4ms) CREATE TABLE "ssn_high_group_codes" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "as_of" date, "area" varchar(255), "group" varchar(255), "created_at" datetime, "updated_at" datetime)   (0.2ms) CREATE INDEX "idx_area" ON "ssn_high_group_codes" ("area")  (0.2ms) CREATE INDEX "idx_area_as_of" ON "ssn_high_group_codes" ("area", "as_of") SQL (0.2ms) INSERT INTO "schema_migrations" ("version") VALUES (?) [["version", "20130914201538"]]  (1.0ms) commit transaction ActiveRecord::SchemaMigration Load (0.1ms) SELECT "schema_migrations".* FROM "schema_migrations"  (1.6ms) CREATE TABLE "schema_migrations" ("version" varchar(255) NOT NULL)   (1.6ms) CREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version") ActiveRecord::SchemaMigration Load (0.1ms) SELECT "schema_migrations".* FROM "schema_migrations" Migrating to CreateSsnValidatorDeathMasterFiles (20130914201438)  (0.1ms) begin transaction  (0.5ms) CREATE TABLE "death_master_files" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "social_security_number" varchar(255), "last_name" varchar(255), "name_suffix" varchar(255), "first_name" varchar(255), "middle_name" varchar(255), "verify_proof_code" varchar(255), "date_of_death" date, "date_of_birth" date, "state_of_residence" varchar(255), "last_known_zip_residence" varchar(255), "last_known_zip_payment" varchar(255), "created_at" datetime, "updated_at" datetime, "as_of" date)   (0.4ms) CREATE UNIQUE INDEX "idx_ssn" ON "death_master_files" ("social_security_number")  (0.1ms) CREATE INDEX "idx_as_of" ON "death_master_files" ("as_of") SQL (0.2ms) INSERT INTO "schema_migrations" ("version") VALUES (?) [["version", "20130914201438"]]  (1.7ms) commit transaction Migrating to CreateSsnHighGroupCodes (20130914201538)  (0.1ms) begin transaction  (0.4ms) CREATE TABLE "ssn_high_group_codes" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "as_of" date, "area" varchar(255), "group" varchar(255), "created_at" datetime, "updated_at" datetime)   (0.2ms) CREATE INDEX "idx_area" ON "ssn_high_group_codes" ("area")  (0.1ms) CREATE INDEX "idx_area_as_of" ON "ssn_high_group_codes" ("area", "as_of") SQL (0.1ms) INSERT INTO "schema_migrations" ("version") VALUES (?) [["version", "20130914201538"]]  (1.5ms) commit transaction ActiveRecord::SchemaMigration Load (0.1ms) SELECT "schema_migrations".* FROM "schema_migrations"  (1.8ms) DROP TABLE "death_master_files"  (1.5ms) CREATE TABLE "death_master_files" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "social_security_number" varchar(255), "last_name" varchar(255), "name_suffix" varchar(255), "first_name" varchar(255), "middle_name" varchar(255), "verify_proof_code" varchar(255), "date_of_death" date, "date_of_birth" date, "state_of_residence" varchar(255), "last_known_zip_residence" varchar(255), "last_known_zip_payment" varchar(255), "created_at" datetime, "updated_at" datetime, "as_of" date)  (1.4ms) CREATE INDEX "idx_as_of" ON "death_master_files" ("as_of")  (1.3ms) CREATE UNIQUE INDEX "idx_ssn" ON "death_master_files" ("social_security_number")  (1.9ms) DROP TABLE "ssn_high_group_codes"  (1.2ms) CREATE TABLE "ssn_high_group_codes" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "as_of" date, "area" varchar(255), "group" varchar(255), "created_at" datetime, "updated_at" datetime)  (1.2ms) CREATE INDEX "idx_area_as_of" ON "ssn_high_group_codes" ("area", "as_of")  (1.2ms) CREATE INDEX "idx_area" ON "ssn_high_group_codes" ("area")  (0.1ms) SELECT version FROM "schema_migrations"