Skip to content

HTTPS clone URL

Subversion checkout URL

You can clone with HTTPS or Subversion.

Download ZIP
tree: c819ba284a
Fetching contributors…

Cannot retrieve contributors at this time

1035 lines (1034 sloc) 64.661 kb
# Logfile created on Sun Feb 21 16:52:38 -0800 2010 by /
SQL (0.2ms) select sqlite_version(*)
SQL (0.2ms)  SELECT name
FROM sqlite_master
WHERE type = 'table' AND NOT name = 'sqlite_sequence'

SQL (0.8ms) CREATE TABLE "states" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "abbr" varchar(255), "country" varchar(255), "type" varchar(255)) 
SQL (0.6ms) CREATE TABLE "cities" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "state_id" integer, "gnis_id" integer, "latitude" float, "longitude" float, "population_2000" integer) 
SQL (0.2ms)  SELECT name
FROM sqlite_master
WHERE type = 'table' AND NOT name = 'sqlite_sequence'

SQL (0.7ms) CREATE TABLE "schema_migrations" ("version" varchar(255) NOT NULL) 
SQL (0.6ms) CREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")
SQL (0.2ms)  SELECT name
FROM sqlite_master
WHERE type = 'table' AND NOT name = 'sqlite_sequence'

SQL (0.1ms) SELECT version FROM "schema_migrations"
SQL (0.6ms) INSERT INTO "schema_migrations" (version) VALUES ('0')
GeoinfoTest::State Load (0.3ms) SELECT * FROM "states" 
GeoinfoTest::City Load (0.2ms) SELECT * FROM "cities" 
SQL (0.2ms) select sqlite_version(*)
SQL (0.4ms)  SELECT name
FROM sqlite_master
WHERE type = 'table' AND NOT name = 'sqlite_sequence'

SQL (1.1ms) DROP TABLE "states"
SQL (0.6ms) CREATE TABLE "states" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "abbr" varchar(255), "country" varchar(255), "type" varchar(255)) 
SQL (0.0ms) SQLite3::SQLException: table "cities" already exists: CREATE TABLE "cities" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "state_id" integer, "gnis_id" integer, "latitude" float, "longitude" float, "population_2000" integer) 
SQL (0.2ms) select sqlite_version(*)
SQL (0.4ms)  SELECT name
FROM sqlite_master
WHERE type = 'table' AND NOT name = 'sqlite_sequence'

SQL (0.9ms) DROP TABLE "states"
SQL (0.6ms) CREATE TABLE "states" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "abbr" varchar(255), "country" varchar(255), "type" varchar(255)) 
SQL (0.0ms) SQLite3::SQLException: table "cities" already exists: CREATE TABLE "cities" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "state_id" integer, "gnis_id" integer, "latitude" float, "longitude" float, "population_2000" integer) 
SQL (0.2ms) select sqlite_version(*)
SQL (0.4ms)  SELECT name
FROM sqlite_master
WHERE type = 'table' AND NOT name = 'sqlite_sequence'

SQL (1.3ms) DROP TABLE "states"
SQL (0.6ms) CREATE TABLE "states" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "abbr" varchar(255), "country" varchar(255), "type" varchar(255)) 
SQL (0.0ms) SQLite3::SQLException: table "cities" already exists: CREATE TABLE "cities" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "state_id" integer, "gnis_id" integer, "latitude" float, "longitude" float, "population_2000" integer) 
SQL (0.2ms) select sqlite_version(*)
SQL (0.4ms)  SELECT name
FROM sqlite_master
WHERE type = 'table' AND NOT name = 'sqlite_sequence'

SQL (0.9ms) DROP TABLE "states"
SQL (0.6ms) CREATE TABLE "states" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "abbr" varchar(255), "country" varchar(255), "type" varchar(255)) 
SQL (0.2ms)  SELECT name
FROM sqlite_master
WHERE type = 'table' AND NOT name = 'sqlite_sequence'

SQL (0.6ms) DROP TABLE "cities"
SQL (0.6ms) CREATE TABLE "cities" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "state_id" integer, "gnis_id" integer, "latitude" float, "longitude" float, "population_2000" integer) 
SQL (0.2ms)  SELECT name
FROM sqlite_master
WHERE type = 'table' AND NOT name = 'sqlite_sequence'

SQL (0.1ms) SELECT version FROM "schema_migrations"
SQL (0.2ms) select sqlite_version(*)
SQL (0.4ms)  SELECT name
FROM sqlite_master
WHERE type = 'table' AND NOT name = 'sqlite_sequence'

SQL (0.7ms) DROP TABLE "states"
SQL (0.6ms) CREATE TABLE "states" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "abbr" varchar(255), "country" varchar(255), "type" varchar(255)) 
SQL (0.2ms)  SELECT name
FROM sqlite_master
WHERE type = 'table' AND NOT name = 'sqlite_sequence'

SQL (0.6ms) DROP TABLE "cities"
SQL (1.6ms) CREATE TABLE "cities" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "state_id" integer, "gnis_id" integer, "latitude" float, "longitude" float, "population_2000" integer) 
SQL (0.4ms)  SELECT name
FROM sqlite_master
WHERE type = 'table' AND NOT name = 'sqlite_sequence'

SQL (0.2ms) SELECT version FROM "schema_migrations"
GeoinfoTest::State Load (0.2ms) SELECT * FROM "states" 
GeoinfoTest::City Load (0.1ms) SELECT * FROM "cities" 
SQL (0.3ms) select sqlite_version(*)
SQL (0.4ms)  SELECT name
FROM sqlite_master
WHERE type = 'table' AND NOT name = 'sqlite_sequence'

SQL (0.9ms) DROP TABLE "states"
SQL (0.6ms) CREATE TABLE "states" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "abbr" varchar(255), "country" varchar(255), "type" varchar(255)) 
SQL (0.2ms)  SELECT name
FROM sqlite_master
WHERE type = 'table' AND NOT name = 'sqlite_sequence'

SQL (0.6ms) DROP TABLE "cities"
SQL (0.6ms) CREATE TABLE "cities" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "state_id" integer, "gnis_id" integer, "latitude" float, "longitude" float, "population_2000" integer) 
SQL (0.2ms)  SELECT name
FROM sqlite_master
WHERE type = 'table' AND NOT name = 'sqlite_sequence'

SQL (0.1ms) SELECT version FROM "schema_migrations"
SQL (0.2ms) select sqlite_version(*)
SQL (0.3ms)  SELECT name
FROM sqlite_master
WHERE type = 'table' AND NOT name = 'sqlite_sequence'

SQL (0.7ms) DROP TABLE "states"
SQL (0.6ms) CREATE TABLE "states" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "abbr" varchar(255), "country" varchar(255), "type" varchar(255)) 
SQL (0.2ms)  SELECT name
FROM sqlite_master
WHERE type = 'table' AND NOT name = 'sqlite_sequence'

SQL (0.6ms) DROP TABLE "cities"
SQL (0.6ms) CREATE TABLE "cities" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "state_id" integer, "gnis_id" integer, "latitude" float, "longitude" float, "population_2000" integer) 
SQL (0.2ms)  SELECT name
FROM sqlite_master
WHERE type = 'table' AND NOT name = 'sqlite_sequence'

SQL (0.1ms) SELECT version FROM "schema_migrations"
GeoinfoTest::State Load (0.2ms) SELECT * FROM "states" 
GeoinfoTest::City Load (0.1ms) SELECT * FROM "cities" 
SQL (0.2ms) select sqlite_version(*)
SQL (0.4ms)  SELECT name
FROM sqlite_master
WHERE type = 'table' AND NOT name = 'sqlite_sequence'

SQL (1.1ms) DROP TABLE "states"
SQL (0.6ms) CREATE TABLE "states" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "abbr" varchar(255), "country" varchar(255), "type" varchar(255)) 
SQL (0.5ms)  SELECT name
FROM sqlite_master
WHERE type = 'table' AND NOT name = 'sqlite_sequence'

SQL (0.7ms) DROP TABLE "cities"
SQL (0.6ms) CREATE TABLE "cities" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "state_id" integer, "gnis_id" integer, "latitude" float, "longitude" float, "population_2000" integer) 
SQL (0.3ms)  SELECT name
FROM sqlite_master
WHERE type = 'table' AND NOT name = 'sqlite_sequence'

SQL (0.1ms) SELECT version FROM "schema_migrations"
SQL (0.2ms) select sqlite_version(*)
SQL (0.4ms)  SELECT name
FROM sqlite_master
WHERE type = 'table' AND NOT name = 'sqlite_sequence'

SQL (0.7ms) DROP TABLE "states"
SQL (0.6ms) CREATE TABLE "states" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "abbr" varchar(255), "country" varchar(255), "type" varchar(255)) 
SQL (0.2ms)  SELECT name
FROM sqlite_master
WHERE type = 'table' AND NOT name = 'sqlite_sequence'

SQL (1.2ms) DROP TABLE "cities"
SQL (1.3ms) CREATE TABLE "cities" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "state_id" integer, "gnis_id" integer, "latitude" float, "longitude" float, "population_2000" integer) 
SQL (0.3ms)  SELECT name
FROM sqlite_master
WHERE type = 'table' AND NOT name = 'sqlite_sequence'

SQL (0.2ms) SELECT version FROM "schema_migrations"
SQL (0.2ms) select sqlite_version(*)
SQL (0.5ms)  SELECT name
FROM sqlite_master
WHERE type = 'table' AND NOT name = 'sqlite_sequence'

SQL (1.0ms) DROP TABLE "states"
SQL (0.9ms) CREATE TABLE "states" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "abbr" varchar(255), "country" varchar(255), "type" varchar(255)) 
SQL (0.3ms)  SELECT name
FROM sqlite_master
WHERE type = 'table' AND NOT name = 'sqlite_sequence'

SQL (0.7ms) DROP TABLE "cities"
SQL (0.7ms) CREATE TABLE "cities" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "state_id" integer, "gnis_id" integer, "latitude" float, "longitude" float, "population_2000" integer) 
SQL (0.2ms)  SELECT name
FROM sqlite_master
WHERE type = 'table' AND NOT name = 'sqlite_sequence'

SQL (0.1ms) SELECT version FROM "schema_migrations"
GeoinfoTest::State Load (0.2ms) SELECT * FROM "states" 
GeoinfoTest::City Load (0.1ms) SELECT * FROM "cities" 
SQL (0.3ms) select sqlite_version(*)
SQL (0.4ms)  SELECT name
FROM sqlite_master
WHERE type = 'table' AND NOT name = 'sqlite_sequence'

SQL (1.1ms) DROP TABLE "states"
SQL (0.9ms) CREATE TABLE "states" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "abbr" varchar(255), "country" varchar(255), "type" varchar(255)) 
SQL (0.3ms)  SELECT name
FROM sqlite_master
WHERE type = 'table' AND NOT name = 'sqlite_sequence'

SQL (0.6ms) DROP TABLE "cities"
SQL (0.6ms) CREATE TABLE "cities" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "state_id" integer, "gnis_id" integer, "latitude" float, "longitude" float, "population_2000" integer) 
SQL (0.2ms)  SELECT name
FROM sqlite_master
WHERE type = 'table' AND NOT name = 'sqlite_sequence'

SQL (0.1ms) SELECT version FROM "schema_migrations"
SQL (0.1ms) select sqlite_version(*)
SQL (0.3ms)  SELECT name
FROM sqlite_master
WHERE type = 'table' AND NOT name = 'sqlite_sequence'

SQL (0.8ms) DROP TABLE "states"
SQL (0.6ms) CREATE TABLE "states" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "abbr" varchar(255), "country" varchar(255), "type" varchar(255)) 
SQL (0.2ms)  SELECT name
FROM sqlite_master
WHERE type = 'table' AND NOT name = 'sqlite_sequence'

SQL (0.6ms) DROP TABLE "cities"
SQL (0.6ms) CREATE TABLE "cities" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "state_id" integer, "gnis_id" integer, "latitude" float, "longitude" float, "population_2000" integer) 
SQL (0.2ms)  SELECT name
FROM sqlite_master
WHERE type = 'table' AND NOT name = 'sqlite_sequence'

SQL (0.1ms) SELECT version FROM "schema_migrations"
SQL (0.2ms) select sqlite_version(*)
SQL (0.4ms)  SELECT name
FROM sqlite_master
WHERE type = 'table' AND NOT name = 'sqlite_sequence'

SQL (0.8ms) DROP TABLE "states"
SQL (0.7ms) CREATE TABLE "states" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "abbr" varchar(255), "country" varchar(255), "type" varchar(255)) 
SQL (0.3ms)  SELECT name
FROM sqlite_master
WHERE type = 'table' AND NOT name = 'sqlite_sequence'

SQL (0.6ms) DROP TABLE "cities"
SQL (0.6ms) CREATE TABLE "cities" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "state_id" integer, "gnis_id" integer, "latitude" float, "longitude" float, "population_2000" integer) 
SQL (0.2ms)  SELECT name
FROM sqlite_master
WHERE type = 'table' AND NOT name = 'sqlite_sequence'

SQL (0.3ms) SELECT version FROM "schema_migrations"
GeoinfoTest::State Load (0.1ms) SELECT * FROM "states" 
GeoinfoTest::City Load (0.1ms) SELECT * FROM "cities" 
SQL (0.2ms) select sqlite_version(*)
SQL (0.4ms)  SELECT name
FROM sqlite_master
WHERE type = 'table' AND NOT name = 'sqlite_sequence'

SQL (1.3ms) CREATE TABLE "geoinfo_states" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "abbr" varchar(255), "country" varchar(255), "type" varchar(255)) 
SQL (0.3ms)  SELECT name
FROM sqlite_master
WHERE type = 'table' AND NOT name = 'sqlite_sequence'

SQL (0.7ms) CREATE TABLE "geoinfo_cities" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "state_id" integer, "gnis_id" integer, "latitude" float, "longitude" float, "population_2000" integer) 
SQL (0.3ms)  SELECT name
FROM sqlite_master
WHERE type = 'table' AND NOT name = 'sqlite_sequence'

SQL (0.1ms) SELECT version FROM "schema_migrations"
SQL (0.2ms) select sqlite_version(*)
SQL (0.4ms)  SELECT name
FROM sqlite_master
WHERE type = 'table' AND NOT name = 'sqlite_sequence'

SQL (0.9ms) DROP TABLE "geoinfo_states"
SQL (0.7ms) CREATE TABLE "geoinfo_states" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "abbr" varchar(255), "country" varchar(255), "type" varchar(255)) 
SQL (0.3ms)  SELECT name
FROM sqlite_master
WHERE type = 'table' AND NOT name = 'sqlite_sequence'

SQL (0.7ms) DROP TABLE "geoinfo_cities"
SQL (0.7ms) CREATE TABLE "geoinfo_cities" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "state_id" integer, "gnis_id" integer, "latitude" float, "longitude" float, "population_2000" integer) 
SQL (0.3ms)  SELECT name
FROM sqlite_master
WHERE type = 'table' AND NOT name = 'sqlite_sequence'

SQL (0.1ms) SELECT version FROM "schema_migrations"
SQL (0.2ms) select sqlite_version(*)
SQL (0.5ms)  SELECT name
FROM sqlite_master
WHERE type = 'table' AND NOT name = 'sqlite_sequence'

SQL (1.2ms) DROP TABLE "geoinfo_states"
SQL (0.8ms) CREATE TABLE "geoinfo_states" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "abbr" varchar(255), "country" varchar(255), "type" varchar(255)) 
SQL (0.3ms)  SELECT name
FROM sqlite_master
WHERE type = 'table' AND NOT name = 'sqlite_sequence'

SQL (0.8ms) DROP TABLE "geoinfo_cities"
SQL (0.7ms) CREATE TABLE "geoinfo_cities" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "state_id" integer, "gnis_id" integer, "latitude" float, "longitude" float, "population_2000" integer) 
SQL (0.3ms)  SELECT name
FROM sqlite_master
WHERE type = 'table' AND NOT name = 'sqlite_sequence'

SQL (0.1ms) SELECT version FROM "schema_migrations"
GeoinfoTest::State Load (0.2ms) SELECT * FROM "states" 
GeoinfoTest::City Load (0.1ms) SELECT * FROM "cities" 
SQL (0.2ms) select sqlite_version(*)
SQL (0.5ms)  SELECT name
FROM sqlite_master
WHERE type = 'table' AND NOT name = 'sqlite_sequence'

SQL (0.9ms) DROP TABLE "geoinfo_states"
SQL (0.6ms) CREATE TABLE "geoinfo_states" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "abbr" varchar(255), "country" varchar(255), "type" varchar(255)) 
SQL (0.3ms)  SELECT name
FROM sqlite_master
WHERE type = 'table' AND NOT name = 'sqlite_sequence'

SQL (1.1ms) DROP TABLE "geoinfo_cities"
SQL (1.3ms) CREATE TABLE "geoinfo_cities" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "state_id" integer, "gnis_id" integer, "latitude" float, "longitude" float, "population_2000" integer) 
SQL (0.9ms)  SELECT name
FROM sqlite_master
WHERE type = 'table' AND NOT name = 'sqlite_sequence'

SQL (0.3ms) SELECT version FROM "schema_migrations"
SQL (0.2ms) select sqlite_version(*)
SQL (0.4ms)  SELECT name
FROM sqlite_master
WHERE type = 'table' AND NOT name = 'sqlite_sequence'

SQL (0.9ms) DROP TABLE "geoinfo_states"
SQL (0.6ms) CREATE TABLE "geoinfo_states" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "abbr" varchar(255), "country" varchar(255), "type" varchar(255)) 
SQL (0.3ms)  SELECT name
FROM sqlite_master
WHERE type = 'table' AND NOT name = 'sqlite_sequence'

SQL (0.7ms) DROP TABLE "geoinfo_cities"
SQL (0.8ms) CREATE TABLE "geoinfo_cities" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "state_id" integer, "gnis_id" integer, "latitude" float, "longitude" float, "population_2000" integer) 
SQL (0.4ms)  SELECT name
FROM sqlite_master
WHERE type = 'table' AND NOT name = 'sqlite_sequence'

SQL (0.2ms) SELECT version FROM "schema_migrations"
SQL (0.2ms) select sqlite_version(*)
SQL (0.4ms)  SELECT name
FROM sqlite_master
WHERE type = 'table' AND NOT name = 'sqlite_sequence'

SQL (0.8ms) DROP TABLE "geoinfo_states"
SQL (0.8ms) CREATE TABLE "geoinfo_states" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "abbr" varchar(255), "country" varchar(255), "type" varchar(255)) 
SQL (0.4ms)  SELECT name
FROM sqlite_master
WHERE type = 'table' AND NOT name = 'sqlite_sequence'

SQL (1.3ms) DROP TABLE "geoinfo_cities"
SQL (2.3ms) CREATE TABLE "geoinfo_cities" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "state_id" integer, "gnis_id" integer, "latitude" float, "longitude" float, "population_2000" integer) 
SQL (0.4ms)  SELECT name
FROM sqlite_master
WHERE type = 'table' AND NOT name = 'sqlite_sequence'

SQL (0.1ms) SELECT version FROM "schema_migrations"
SQL (0.2ms) select sqlite_version(*)
SQL (0.4ms)  SELECT name
FROM sqlite_master
WHERE type = 'table' AND NOT name = 'sqlite_sequence'

SQL (0.8ms) DROP TABLE "geoinfo_states"
SQL (0.6ms) CREATE TABLE "geoinfo_states" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "abbr" varchar(255), "country" varchar(255), "type" varchar(255)) 
SQL (0.3ms)  SELECT name
FROM sqlite_master
WHERE type = 'table' AND NOT name = 'sqlite_sequence'

SQL (0.7ms) DROP TABLE "geoinfo_cities"
SQL (0.7ms) CREATE TABLE "geoinfo_cities" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "state_id" integer, "gnis_id" integer, "latitude" float, "longitude" float, "population_2000" integer) 
SQL (0.3ms)  SELECT name
FROM sqlite_master
WHERE type = 'table' AND NOT name = 'sqlite_sequence'

SQL (0.1ms) SELECT version FROM "schema_migrations"
GeoinfoTest::State Load (0.2ms) SELECT * FROM "states" 
GeoinfoTest::City Load (0.1ms) SELECT * FROM "cities" 
SQL (0.2ms) select sqlite_version(*)
SQL (0.5ms)  SELECT name
FROM sqlite_master
WHERE type = 'table' AND NOT name = 'sqlite_sequence'

SQL (0.9ms) DROP TABLE "geoinfo_states"
SQL (0.7ms) CREATE TABLE "geoinfo_states" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "abbr" varchar(255), "country" varchar(255), "type" varchar(255)) 
SQL (0.3ms)  SELECT name
FROM sqlite_master
WHERE type = 'table' AND NOT name = 'sqlite_sequence'

SQL (0.7ms) DROP TABLE "geoinfo_cities"
SQL (0.6ms) CREATE TABLE "geoinfo_cities" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "state_id" integer, "gnis_id" integer, "latitude" float, "longitude" float, "population_2000" integer) 
SQL (0.3ms)  SELECT name
FROM sqlite_master
WHERE type = 'table' AND NOT name = 'sqlite_sequence'

SQL (0.1ms) SELECT version FROM "schema_migrations"
SQL (0.2ms) select sqlite_version(*)
SQL (0.4ms)  SELECT name
FROM sqlite_master
WHERE type = 'table' AND NOT name = 'sqlite_sequence'

SQL (0.8ms) DROP TABLE "geoinfo_states"
SQL (0.7ms) CREATE TABLE "geoinfo_states" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "abbr" varchar(255), "country" varchar(255), "type" varchar(255)) 
SQL (0.3ms)  SELECT name
FROM sqlite_master
WHERE type = 'table' AND NOT name = 'sqlite_sequence'

SQL (0.7ms) DROP TABLE "geoinfo_cities"
SQL (0.6ms) CREATE TABLE "geoinfo_cities" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "state_id" integer, "gnis_id" integer, "latitude" float, "longitude" float, "population_2000" integer) 
SQL (0.3ms)  SELECT name
FROM sqlite_master
WHERE type = 'table' AND NOT name = 'sqlite_sequence'

SQL (1.5ms) SELECT version FROM "schema_migrations"
SQL (0.2ms) select sqlite_version(*)
SQL (0.4ms)  SELECT name
FROM sqlite_master
WHERE type = 'table' AND NOT name = 'sqlite_sequence'

SQL (0.8ms) DROP TABLE "geoinfo_states"
SQL (0.7ms) CREATE TABLE "geoinfo_states" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "abbr" varchar(255), "country" varchar(255), "type" varchar(255)) 
SQL (0.3ms)  SELECT name
FROM sqlite_master
WHERE type = 'table' AND NOT name = 'sqlite_sequence'

SQL (0.7ms) DROP TABLE "geoinfo_cities"
SQL (0.7ms) CREATE TABLE "geoinfo_cities" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "state_id" integer, "gnis_id" integer, "latitude" float, "longitude" float, "population_2000" integer) 
SQL (0.3ms)  SELECT name
FROM sqlite_master
WHERE type = 'table' AND NOT name = 'sqlite_sequence'

SQL (0.1ms) SELECT version FROM "schema_migrations"
GeoinfoTest::State Load (0.1ms) SELECT * FROM "states" 
GeoinfoTest::City Load (0.1ms) SELECT * FROM "cities" 
SQL (0.2ms) select sqlite_version(*)
SQL (0.5ms)  SELECT name
FROM sqlite_master
WHERE type = 'table' AND NOT name = 'sqlite_sequence'

SQL (0.9ms) DROP TABLE "geoinfo_states"
SQL (0.7ms) CREATE TABLE "geoinfo_states" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "abbr" varchar(255), "country" varchar(255), "type" varchar(255)) 
SQL (0.3ms)  SELECT name
FROM sqlite_master
WHERE type = 'table' AND NOT name = 'sqlite_sequence'

SQL (0.7ms) DROP TABLE "geoinfo_cities"
SQL (0.8ms) CREATE TABLE "geoinfo_cities" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "state_id" integer, "gnis_id" integer, "latitude" float, "longitude" float, "population_2000" integer) 
SQL (0.3ms)  SELECT name
FROM sqlite_master
WHERE type = 'table' AND NOT name = 'sqlite_sequence'

SQL (0.1ms) SELECT version FROM "schema_migrations"
SQL (0.2ms) select sqlite_version(*)
SQL (0.4ms)  SELECT name
FROM sqlite_master
WHERE type = 'table' AND NOT name = 'sqlite_sequence'

SQL (0.8ms) DROP TABLE "geoinfo_states"
SQL (0.7ms) CREATE TABLE "geoinfo_states" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "abbr" varchar(255), "country" varchar(255), "type" varchar(255)) 
SQL (0.3ms)  SELECT name
FROM sqlite_master
WHERE type = 'table' AND NOT name = 'sqlite_sequence'

SQL (0.7ms) DROP TABLE "geoinfo_cities"
SQL (0.7ms) CREATE TABLE "geoinfo_cities" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "state_id" integer, "gnis_id" integer, "latitude" float, "longitude" float, "population_2000" integer) 
SQL (0.3ms)  SELECT name
FROM sqlite_master
WHERE type = 'table' AND NOT name = 'sqlite_sequence'

SQL (0.3ms) SELECT version FROM "schema_migrations"
SQL (0.2ms) select sqlite_version(*)
SQL (0.4ms)  SELECT name
FROM sqlite_master
WHERE type = 'table' AND NOT name = 'sqlite_sequence'

SQL (0.8ms) DROP TABLE "geoinfo_states"
SQL (0.7ms) CREATE TABLE "geoinfo_states" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "abbr" varchar(255), "country" varchar(255), "type" varchar(255)) 
SQL (0.5ms)  SELECT name
FROM sqlite_master
WHERE type = 'table' AND NOT name = 'sqlite_sequence'

SQL (1.2ms) DROP TABLE "geoinfo_cities"
SQL (1.4ms) CREATE TABLE "geoinfo_cities" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "state_id" integer, "gnis_id" integer, "latitude" float, "longitude" float, "population_2000" integer) 
SQL (0.4ms)  SELECT name
FROM sqlite_master
WHERE type = 'table' AND NOT name = 'sqlite_sequence'

SQL (1.9ms) SELECT version FROM "schema_migrations"
GeoinfoTest::State Load (0.2ms) SELECT * FROM "states" 
GeoinfoTest::City Load (0.1ms) SELECT * FROM "cities" 
SQL (0.2ms) select sqlite_version(*)
SQL (0.5ms)  SELECT name
FROM sqlite_master
WHERE type = 'table' AND NOT name = 'sqlite_sequence'

SQL (1.2ms) DROP TABLE "geoinfo_states"
SQL (1.5ms) CREATE TABLE "geoinfo_states" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "abbr" varchar(255), "country" varchar(255), "type" varchar(255)) 
SQL (0.4ms)  SELECT name
FROM sqlite_master
WHERE type = 'table' AND NOT name = 'sqlite_sequence'

SQL (0.9ms) DROP TABLE "geoinfo_cities"
SQL (0.9ms) CREATE TABLE "geoinfo_cities" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "state_id" integer, "gnis_id" integer, "latitude" float, "longitude" float, "population_2000" integer) 
SQL (0.3ms)  SELECT name
FROM sqlite_master
WHERE type = 'table' AND NOT name = 'sqlite_sequence'

SQL (0.2ms) SELECT version FROM "schema_migrations"
SQL (0.2ms) select sqlite_version(*)
SQL (0.5ms)  SELECT name
FROM sqlite_master
WHERE type = 'table' AND NOT name = 'sqlite_sequence'

SQL (0.9ms) DROP TABLE "geoinfo_states"
SQL (0.9ms) CREATE TABLE "geoinfo_states" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "abbr" varchar(255), "country" varchar(255), "type" varchar(255)) 
SQL (0.4ms)  SELECT name
FROM sqlite_master
WHERE type = 'table' AND NOT name = 'sqlite_sequence'

SQL (2.5ms) DROP TABLE "geoinfo_cities"
SQL (1.2ms) CREATE TABLE "geoinfo_cities" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "state_id" integer, "gnis_id" integer, "latitude" float, "longitude" float, "population_2000" integer) 
SQL (0.5ms)  SELECT name
FROM sqlite_master
WHERE type = 'table' AND NOT name = 'sqlite_sequence'

SQL (0.2ms) SELECT version FROM "schema_migrations"
SQL (0.2ms) select sqlite_version(*)
SQL (0.6ms)  SELECT name
FROM sqlite_master
WHERE type = 'table' AND NOT name = 'sqlite_sequence'

SQL (1.9ms) DROP TABLE "geoinfo_states"
SQL (1.0ms) CREATE TABLE "geoinfo_states" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "abbr" varchar(255), "country" varchar(255), "type" varchar(255)) 
SQL (0.4ms)  SELECT name
FROM sqlite_master
WHERE type = 'table' AND NOT name = 'sqlite_sequence'

SQL (0.9ms) DROP TABLE "geoinfo_cities"
SQL (1.0ms) CREATE TABLE "geoinfo_cities" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "state_id" integer, "gnis_id" integer, "latitude" float, "longitude" float, "population_2000" integer) 
SQL (0.3ms)  SELECT name
FROM sqlite_master
WHERE type = 'table' AND NOT name = 'sqlite_sequence'

SQL (0.1ms) SELECT version FROM "schema_migrations"
GeoinfoTest::State Load (0.8ms) SELECT * FROM "states" 
GeoinfoTest::City Load (0.2ms) SELECT * FROM "cities" 
SQL (0.2ms) select sqlite_version(*)
SQL (0.5ms)  SELECT name
FROM sqlite_master
WHERE type = 'table' AND NOT name = 'sqlite_sequence'

SQL (1.5ms) DROP TABLE "geoinfo_states"
SQL (1.1ms) CREATE TABLE "geoinfo_states" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "abbr" varchar(255), "country" varchar(255), "type" varchar(255)) 
SQL (0.4ms)  SELECT name
FROM sqlite_master
WHERE type = 'table' AND NOT name = 'sqlite_sequence'

SQL (1.0ms) DROP TABLE "geoinfo_cities"
SQL (1.0ms) CREATE TABLE "geoinfo_cities" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "state_id" integer, "gnis_id" integer, "latitude" float, "longitude" float, "population_2000" integer) 
SQL (0.3ms)  SELECT name
FROM sqlite_master
WHERE type = 'table' AND NOT name = 'sqlite_sequence'

SQL (0.2ms) SELECT version FROM "schema_migrations"
SQL (0.2ms) select sqlite_version(*)
SQL (0.5ms)  SELECT name
FROM sqlite_master
WHERE type = 'table' AND NOT name = 'sqlite_sequence'

SQL (1.0ms) DROP TABLE "geoinfo_states"
SQL (1.5ms) CREATE TABLE "geoinfo_states" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "abbr" varchar(255), "country" varchar(255), "type" varchar(255)) 
SQL (1.9ms)  SELECT name
FROM sqlite_master
WHERE type = 'table' AND NOT name = 'sqlite_sequence'

SQL (1.0ms) DROP TABLE "geoinfo_cities"
SQL (1.1ms) CREATE TABLE "geoinfo_cities" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "state_id" integer, "gnis_id" integer, "latitude" float, "longitude" float, "population_2000" integer) 
SQL (0.4ms)  SELECT name
FROM sqlite_master
WHERE type = 'table' AND NOT name = 'sqlite_sequence'

SQL (0.2ms) SELECT version FROM "schema_migrations"
SQL (1.1ms) select sqlite_version(*)
SQL (0.5ms)  SELECT name
FROM sqlite_master
WHERE type = 'table' AND NOT name = 'sqlite_sequence'

SQL (1.1ms) DROP TABLE "geoinfo_states"
SQL (1.0ms) CREATE TABLE "geoinfo_states" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "abbr" varchar(255), "country" varchar(255), "type" varchar(255)) 
SQL (0.4ms)  SELECT name
FROM sqlite_master
WHERE type = 'table' AND NOT name = 'sqlite_sequence'

SQL (4.5ms) DROP TABLE "geoinfo_cities"
SQL (1.2ms) CREATE TABLE "geoinfo_cities" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "state_id" integer, "gnis_id" integer, "latitude" float, "longitude" float, "population_2000" integer) 
SQL (0.4ms)  SELECT name
FROM sqlite_master
WHERE type = 'table' AND NOT name = 'sqlite_sequence'

SQL (0.3ms) SELECT version FROM "schema_migrations"
GeoinfoTest::State Load (0.2ms) SELECT * FROM "states" 
GeoinfoTest::City Load (0.1ms) SELECT * FROM "cities" 
SQL (0.2ms) select sqlite_version(*)
SQL (0.5ms)  SELECT name
FROM sqlite_master
WHERE type = 'table' AND NOT name = 'sqlite_sequence'

SQL (1.1ms) DROP TABLE "geoinfo_states"
SQL (0.8ms) CREATE TABLE "geoinfo_states" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "abbr" varchar(255), "country" varchar(255), "type" varchar(255)) 
SQL (0.3ms)  SELECT name
FROM sqlite_master
WHERE type = 'table' AND NOT name = 'sqlite_sequence'

SQL (0.7ms) DROP TABLE "geoinfo_cities"
SQL (0.7ms) CREATE TABLE "geoinfo_cities" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "state_id" integer, "gnis_id" integer, "latitude" float, "longitude" float, "population_2000" integer) 
SQL (0.3ms)  SELECT name
FROM sqlite_master
WHERE type = 'table' AND NOT name = 'sqlite_sequence'

SQL (0.1ms) SELECT version FROM "schema_migrations"
SQL (0.2ms) select sqlite_version(*)
SQL (0.4ms)  SELECT name
FROM sqlite_master
WHERE type = 'table' AND NOT name = 'sqlite_sequence'

SQL (0.8ms) DROP TABLE "geoinfo_states"
SQL (0.7ms) CREATE TABLE "geoinfo_states" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "abbr" varchar(255), "country" varchar(255), "type" varchar(255)) 
SQL (0.3ms)  SELECT name
FROM sqlite_master
WHERE type = 'table' AND NOT name = 'sqlite_sequence'

SQL (0.7ms) DROP TABLE "geoinfo_cities"
SQL (0.7ms) CREATE TABLE "geoinfo_cities" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "state_id" integer, "gnis_id" integer, "latitude" float, "longitude" float, "population_2000" integer) 
SQL (0.3ms)  SELECT name
FROM sqlite_master
WHERE type = 'table' AND NOT name = 'sqlite_sequence'

SQL (0.1ms) SELECT version FROM "schema_migrations"
SQL (0.7ms) select sqlite_version(*)
SQL (0.4ms)  SELECT name
FROM sqlite_master
WHERE type = 'table' AND NOT name = 'sqlite_sequence'

SQL (0.8ms) DROP TABLE "geoinfo_states"
SQL (0.8ms) CREATE TABLE "geoinfo_states" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "abbr" varchar(255), "country" varchar(255), "type" varchar(255)) 
SQL (0.3ms)  SELECT name
FROM sqlite_master
WHERE type = 'table' AND NOT name = 'sqlite_sequence'

SQL (0.9ms) DROP TABLE "geoinfo_cities"
SQL (0.7ms) CREATE TABLE "geoinfo_cities" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "state_id" integer, "gnis_id" integer, "latitude" float, "longitude" float, "population_2000" integer) 
SQL (0.4ms)  SELECT name
FROM sqlite_master
WHERE type = 'table' AND NOT name = 'sqlite_sequence'

SQL (0.1ms) SELECT version FROM "schema_migrations"
GeoinfoTest::State Load (0.3ms) SELECT * FROM "states" 
GeoinfoTest::City Load (0.1ms) SELECT * FROM "cities" 
SQL (0.2ms) select sqlite_version(*)
SQL (0.5ms)  SELECT name
FROM sqlite_master
WHERE type = 'table' AND NOT name = 'sqlite_sequence'

SQL (0.9ms) DROP TABLE "geoinfo_states"
SQL (0.7ms) CREATE TABLE "geoinfo_states" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "abbr" varchar(255), "country" varchar(255), "type" varchar(255)) 
SQL (0.3ms)  SELECT name
FROM sqlite_master
WHERE type = 'table' AND NOT name = 'sqlite_sequence'

SQL (0.7ms) DROP TABLE "geoinfo_cities"
SQL (0.6ms) CREATE TABLE "geoinfo_cities" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "state_id" integer, "gnis_id" integer, "latitude" float, "longitude" float, "population_2000" integer) 
SQL (0.3ms)  SELECT name
FROM sqlite_master
WHERE type = 'table' AND NOT name = 'sqlite_sequence'

SQL (0.1ms) SELECT version FROM "schema_migrations"
SQL (0.2ms) select sqlite_version(*)
SQL (0.4ms)  SELECT name
FROM sqlite_master
WHERE type = 'table' AND NOT name = 'sqlite_sequence'

SQL (0.8ms) DROP TABLE "geoinfo_states"
SQL (0.7ms) CREATE TABLE "geoinfo_states" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "abbr" varchar(255), "country" varchar(255), "type" varchar(255)) 
SQL (0.3ms)  SELECT name
FROM sqlite_master
WHERE type = 'table' AND NOT name = 'sqlite_sequence'

SQL (0.7ms) DROP TABLE "geoinfo_cities"
SQL (0.7ms) CREATE TABLE "geoinfo_cities" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "state_id" integer, "gnis_id" integer, "latitude" float, "longitude" float, "population_2000" integer) 
SQL (0.3ms)  SELECT name
FROM sqlite_master
WHERE type = 'table' AND NOT name = 'sqlite_sequence'

SQL (0.2ms) SELECT version FROM "schema_migrations"
SQL (0.7ms) select sqlite_version(*)
SQL (0.4ms)  SELECT name
FROM sqlite_master
WHERE type = 'table' AND NOT name = 'sqlite_sequence'

SQL (0.8ms) DROP TABLE "geoinfo_states"
SQL (0.7ms) CREATE TABLE "geoinfo_states" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "abbr" varchar(255), "country" varchar(255), "type" varchar(255)) 
SQL (0.3ms)  SELECT name
FROM sqlite_master
WHERE type = 'table' AND NOT name = 'sqlite_sequence'

SQL (0.7ms) DROP TABLE "geoinfo_cities"
SQL (0.7ms) CREATE TABLE "geoinfo_cities" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "state_id" integer, "gnis_id" integer, "latitude" float, "longitude" float, "population_2000" integer) 
SQL (0.3ms)  SELECT name
FROM sqlite_master
WHERE type = 'table' AND NOT name = 'sqlite_sequence'

SQL (0.1ms) SELECT version FROM "schema_migrations"
GeoinfoTest::State Load (0.2ms) SELECT * FROM "states" 
GeoinfoTest::City Load (0.1ms) SELECT * FROM "cities" 
SQL (0.2ms) select sqlite_version(*)
SQL (0.5ms)  SELECT name
FROM sqlite_master
WHERE type = 'table' AND NOT name = 'sqlite_sequence'

SQL (1.0ms) DROP TABLE "geoinfo_states"
SQL (0.7ms) CREATE TABLE "geoinfo_states" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "abbr" varchar(255), "country" varchar(255), "type" varchar(255)) 
SQL (0.3ms)  SELECT name
FROM sqlite_master
WHERE type = 'table' AND NOT name = 'sqlite_sequence'

SQL (0.7ms) DROP TABLE "geoinfo_cities"
SQL (0.7ms) CREATE TABLE "geoinfo_cities" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "state_id" integer, "gnis_id" integer, "latitude" float, "longitude" float, "population_2000" integer) 
SQL (0.3ms)  SELECT name
FROM sqlite_master
WHERE type = 'table' AND NOT name = 'sqlite_sequence'

SQL (0.1ms) SELECT version FROM "schema_migrations"
SQL (0.2ms) select sqlite_version(*)
SQL (0.4ms)  SELECT name
FROM sqlite_master
WHERE type = 'table' AND NOT name = 'sqlite_sequence'

SQL (0.9ms) DROP TABLE "geoinfo_states"
SQL (0.7ms) CREATE TABLE "geoinfo_states" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "abbr" varchar(255), "country" varchar(255), "type" varchar(255)) 
SQL (0.3ms)  SELECT name
FROM sqlite_master
WHERE type = 'table' AND NOT name = 'sqlite_sequence'

SQL (0.7ms) DROP TABLE "geoinfo_cities"
SQL (0.6ms) CREATE TABLE "geoinfo_cities" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "state_id" integer, "gnis_id" integer, "latitude" float, "longitude" float, "population_2000" integer) 
SQL (0.3ms)  SELECT name
FROM sqlite_master
WHERE type = 'table' AND NOT name = 'sqlite_sequence'

SQL (0.1ms) SELECT version FROM "schema_migrations"
SQL (0.7ms) select sqlite_version(*)
SQL (0.5ms)  SELECT name
FROM sqlite_master
WHERE type = 'table' AND NOT name = 'sqlite_sequence'

SQL (0.8ms) DROP TABLE "geoinfo_states"
SQL (0.7ms) CREATE TABLE "geoinfo_states" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "abbr" varchar(255), "country" varchar(255), "type" varchar(255)) 
SQL (0.3ms)  SELECT name
FROM sqlite_master
WHERE type = 'table' AND NOT name = 'sqlite_sequence'

SQL (0.7ms) DROP TABLE "geoinfo_cities"
SQL (1.0ms) CREATE TABLE "geoinfo_cities" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "state_id" integer, "gnis_id" integer, "latitude" float, "longitude" float, "population_2000" integer) 
SQL (0.4ms)  SELECT name
FROM sqlite_master
WHERE type = 'table' AND NOT name = 'sqlite_sequence'

SQL (0.3ms) SELECT version FROM "schema_migrations"
GeoinfoTest::State Load (0.2ms) SELECT * FROM "states" 
GeoinfoTest::City Load (0.1ms) SELECT * FROM "cities" 
SQL (0.2ms) select sqlite_version(*)
SQL (0.6ms)  SELECT name
FROM sqlite_master
WHERE type = 'table' AND NOT name = 'sqlite_sequence'

SQL (0.9ms) DROP TABLE "geoinfo_states"
SQL (0.7ms) CREATE TABLE "geoinfo_states" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "abbr" varchar(255), "country" varchar(255), "type" varchar(255)) 
SQL (0.3ms)  SELECT name
FROM sqlite_master
WHERE type = 'table' AND NOT name = 'sqlite_sequence'

SQL (0.7ms) DROP TABLE "geoinfo_cities"
SQL (0.7ms) CREATE TABLE "geoinfo_cities" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "state_id" integer, "gnis_id" integer, "latitude" float, "longitude" float, "population_2000" integer) 
SQL (0.3ms)  SELECT name
FROM sqlite_master
WHERE type = 'table' AND NOT name = 'sqlite_sequence'

SQL (0.1ms) SELECT version FROM "schema_migrations"
SQL (0.2ms) select sqlite_version(*)
SQL (0.4ms)  SELECT name
FROM sqlite_master
WHERE type = 'table' AND NOT name = 'sqlite_sequence'

SQL (0.8ms) DROP TABLE "geoinfo_states"
SQL (0.7ms) CREATE TABLE "geoinfo_states" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "abbr" varchar(255), "country" varchar(255), "type" varchar(255)) 
SQL (0.3ms)  SELECT name
FROM sqlite_master
WHERE type = 'table' AND NOT name = 'sqlite_sequence'

SQL (0.7ms) DROP TABLE "geoinfo_cities"
SQL (0.7ms) CREATE TABLE "geoinfo_cities" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "state_id" integer, "gnis_id" integer, "latitude" float, "longitude" float, "population_2000" integer) 
SQL (0.3ms)  SELECT name
FROM sqlite_master
WHERE type = 'table' AND NOT name = 'sqlite_sequence'

SQL (0.1ms) SELECT version FROM "schema_migrations"
SQL (0.7ms) select sqlite_version(*)
SQL (0.4ms)  SELECT name
FROM sqlite_master
WHERE type = 'table' AND NOT name = 'sqlite_sequence'

SQL (0.8ms) DROP TABLE "geoinfo_states"
SQL (0.7ms) CREATE TABLE "geoinfo_states" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "abbr" varchar(255), "country" varchar(255), "type" varchar(255)) 
SQL (0.3ms)  SELECT name
FROM sqlite_master
WHERE type = 'table' AND NOT name = 'sqlite_sequence'

SQL (0.7ms) DROP TABLE "geoinfo_cities"
SQL (0.7ms) CREATE TABLE "geoinfo_cities" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "state_id" integer, "gnis_id" integer, "latitude" float, "longitude" float, "population_2000" integer) 
SQL (0.3ms)  SELECT name
FROM sqlite_master
WHERE type = 'table' AND NOT name = 'sqlite_sequence'

SQL (0.1ms) SELECT version FROM "schema_migrations"
GeoinfoTest::State Load (0.2ms) SELECT * FROM "states" 
GeoinfoTest::City Load (0.1ms) SELECT * FROM "cities" 
SQL (0.2ms) select sqlite_version(*)
SQL (0.4ms)  SELECT name
FROM sqlite_master
WHERE type = 'table' AND NOT name = 'sqlite_sequence'

SQL (0.9ms) DROP TABLE "geoinfo_states"
SQL (0.7ms) CREATE TABLE "geoinfo_states" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "abbr" varchar(255), "country" varchar(255), "type" varchar(255)) 
SQL (0.3ms)  SELECT name
FROM sqlite_master
WHERE type = 'table' AND NOT name = 'sqlite_sequence'

SQL (0.7ms) DROP TABLE "geoinfo_cities"
SQL (0.7ms) CREATE TABLE "geoinfo_cities" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "state_id" integer, "gnis_id" integer, "latitude" float, "longitude" float, "population_2000" integer) 
SQL (0.3ms)  SELECT name
FROM sqlite_master
WHERE type = 'table' AND NOT name = 'sqlite_sequence'

SQL (0.1ms) SELECT version FROM "schema_migrations"
SQL (0.2ms) select sqlite_version(*)
SQL (0.6ms)  SELECT name
FROM sqlite_master
WHERE type = 'table' AND NOT name = 'sqlite_sequence'

SQL (1.1ms) DROP TABLE "geoinfo_states"
SQL (0.8ms) CREATE TABLE "geoinfo_states" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "abbr" varchar(255), "country" varchar(255), "type" varchar(255)) 
SQL (0.3ms)  SELECT name
FROM sqlite_master
WHERE type = 'table' AND NOT name = 'sqlite_sequence'

SQL (0.7ms) DROP TABLE "geoinfo_cities"
SQL (0.7ms) CREATE TABLE "geoinfo_cities" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "state_id" integer, "gnis_id" integer, "latitude" float, "longitude" float, "population_2000" integer) 
SQL (0.3ms)  SELECT name
FROM sqlite_master
WHERE type = 'table' AND NOT name = 'sqlite_sequence'

SQL (0.1ms) SELECT version FROM "schema_migrations"
SQL (0.2ms) select sqlite_version(*)
SQL (0.4ms)  SELECT name
FROM sqlite_master
WHERE type = 'table' AND NOT name = 'sqlite_sequence'

SQL (0.8ms) DROP TABLE "geoinfo_states"
SQL (0.7ms) CREATE TABLE "geoinfo_states" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "abbr" varchar(255), "country" varchar(255), "type" varchar(255)) 
SQL (0.3ms)  SELECT name
FROM sqlite_master
WHERE type = 'table' AND NOT name = 'sqlite_sequence'

SQL (0.7ms) DROP TABLE "geoinfo_cities"
SQL (0.6ms) CREATE TABLE "geoinfo_cities" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "state_id" integer, "gnis_id" integer, "latitude" float, "longitude" float, "population_2000" integer) 
SQL (0.3ms)  SELECT name
FROM sqlite_master
WHERE type = 'table' AND NOT name = 'sqlite_sequence'

SQL (0.1ms) SELECT version FROM "schema_migrations"
GeoinfoTest::State Load (0.2ms) SELECT * FROM "states" 
GeoinfoTest::City Load (0.1ms) SELECT * FROM "cities" 
SQL (0.2ms) select sqlite_version(*)
SQL (0.5ms)  SELECT name
FROM sqlite_master
WHERE type = 'table' AND NOT name = 'sqlite_sequence'

SQL (0.9ms) DROP TABLE "geoinfo_states"
SQL (0.7ms) CREATE TABLE "geoinfo_states" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "abbr" varchar(255), "country" varchar(255), "type" varchar(255)) 
SQL (0.3ms)  SELECT name
FROM sqlite_master
WHERE type = 'table' AND NOT name = 'sqlite_sequence'

SQL (0.8ms) DROP TABLE "geoinfo_cities"
SQL (0.7ms) CREATE TABLE "geoinfo_cities" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "state_id" integer, "gnis_id" integer, "latitude" float, "longitude" float, "population_2000" integer) 
SQL (0.3ms)  SELECT name
FROM sqlite_master
WHERE type = 'table' AND NOT name = 'sqlite_sequence'

SQL (0.1ms) SELECT version FROM "schema_migrations"
SQL (0.2ms) select sqlite_version(*)
SQL (0.4ms)  SELECT name
FROM sqlite_master
WHERE type = 'table' AND NOT name = 'sqlite_sequence'

SQL (0.8ms) DROP TABLE "geoinfo_states"
SQL (0.7ms) CREATE TABLE "geoinfo_states" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "abbr" varchar(255), "country" varchar(255), "type" varchar(255)) 
SQL (0.3ms)  SELECT name
FROM sqlite_master
WHERE type = 'table' AND NOT name = 'sqlite_sequence'

SQL (0.7ms) DROP TABLE "geoinfo_cities"
SQL (0.7ms) CREATE TABLE "geoinfo_cities" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "state_id" integer, "gnis_id" integer, "latitude" float, "longitude" float, "population_2000" integer) 
SQL (0.3ms)  SELECT name
FROM sqlite_master
WHERE type = 'table' AND NOT name = 'sqlite_sequence'

SQL (0.1ms) SELECT version FROM "schema_migrations"
SQL (0.2ms) select sqlite_version(*)
SQL (0.4ms)  SELECT name
FROM sqlite_master
WHERE type = 'table' AND NOT name = 'sqlite_sequence'

SQL (0.9ms) DROP TABLE "geoinfo_states"
SQL (0.8ms) CREATE TABLE "geoinfo_states" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "abbr" varchar(255), "country" varchar(255), "type" varchar(255)) 
SQL (0.3ms)  SELECT name
FROM sqlite_master
WHERE type = 'table' AND NOT name = 'sqlite_sequence'

SQL (0.7ms) DROP TABLE "geoinfo_cities"
SQL (0.6ms) CREATE TABLE "geoinfo_cities" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "state_id" integer, "gnis_id" integer, "latitude" float, "longitude" float, "population_2000" integer) 
SQL (0.3ms)  SELECT name
FROM sqlite_master
WHERE type = 'table' AND NOT name = 'sqlite_sequence'

SQL (0.1ms) SELECT version FROM "schema_migrations"
GeoinfoTest::State Load (0.2ms) SELECT * FROM "states" 
GeoinfoTest::City Load (0.1ms) SELECT * FROM "cities" 
SQL (0.2ms) select sqlite_version(*)
SQL (0.4ms)  SELECT name
FROM sqlite_master
WHERE type = 'table' AND NOT name = 'sqlite_sequence'

SQL (1.1ms) DROP TABLE "geoinfo_states"
SQL (0.8ms) CREATE TABLE "geoinfo_states" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "abbr" varchar(255), "country" varchar(255), "type" varchar(255)) 
SQL (0.3ms)  SELECT name
FROM sqlite_master
WHERE type = 'table' AND NOT name = 'sqlite_sequence'

SQL (0.7ms) DROP TABLE "geoinfo_cities"
SQL (0.7ms) CREATE TABLE "geoinfo_cities" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "state_id" integer, "gnis_id" integer, "latitude" float, "longitude" float, "population_2000" integer) 
SQL (0.3ms)  SELECT name
FROM sqlite_master
WHERE type = 'table' AND NOT name = 'sqlite_sequence'

SQL (0.1ms) SELECT version FROM "schema_migrations"
SQL (0.2ms) select sqlite_version(*)
SQL (0.6ms)  SELECT name
FROM sqlite_master
WHERE type = 'table' AND NOT name = 'sqlite_sequence'

SQL (2.0ms) DROP TABLE "geoinfo_states"
SQL (13.4ms) CREATE TABLE "geoinfo_states" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "abbr" varchar(255), "country" varchar(255), "type" varchar(255)) 
SQL (0.6ms)  SELECT name
FROM sqlite_master
WHERE type = 'table' AND NOT name = 'sqlite_sequence'

SQL (3.8ms) DROP TABLE "geoinfo_cities"
SQL (4.5ms) CREATE TABLE "geoinfo_cities" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "state_id" integer, "gnis_id" integer, "latitude" float, "longitude" float, "population_2000" integer) 
SQL (0.4ms)  SELECT name
FROM sqlite_master
WHERE type = 'table' AND NOT name = 'sqlite_sequence'

SQL (0.2ms) SELECT version FROM "schema_migrations"
SQL (0.2ms) select sqlite_version(*)
SQL (0.4ms)  SELECT name
FROM sqlite_master
WHERE type = 'table' AND NOT name = 'sqlite_sequence'

SQL (0.8ms) DROP TABLE "geoinfo_states"
SQL (0.8ms) CREATE TABLE "geoinfo_states" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "abbr" varchar(255), "country" varchar(255), "type" varchar(255)) 
SQL (0.3ms)  SELECT name
FROM sqlite_master
WHERE type = 'table' AND NOT name = 'sqlite_sequence'

SQL (0.7ms) DROP TABLE "geoinfo_cities"
SQL (0.8ms) CREATE TABLE "geoinfo_cities" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "state_id" integer, "gnis_id" integer, "latitude" float, "longitude" float, "population_2000" integer) 
SQL (0.3ms)  SELECT name
FROM sqlite_master
WHERE type = 'table' AND NOT name = 'sqlite_sequence'

SQL (0.2ms) SELECT version FROM "schema_migrations"
GeoinfoTest::State Load (0.2ms) SELECT * FROM "states" 
GeoinfoTest::City Load (0.1ms) SELECT * FROM "cities" 
SQL (0.2ms) select sqlite_version(*)
SQL (0.4ms)  SELECT name
FROM sqlite_master
WHERE type = 'table' AND NOT name = 'sqlite_sequence'

SQL (0.9ms) DROP TABLE "geoinfo_states"
SQL (0.7ms) CREATE TABLE "geoinfo_states" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "abbr" varchar(255), "country" varchar(255), "type" varchar(255)) 
SQL (0.3ms)  SELECT name
FROM sqlite_master
WHERE type = 'table' AND NOT name = 'sqlite_sequence'

SQL (0.8ms) DROP TABLE "geoinfo_cities"
SQL (0.8ms) CREATE TABLE "geoinfo_cities" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "state_id" integer, "gnis_id" integer, "latitude" float, "longitude" float, "population_2000" integer) 
SQL (0.3ms)  SELECT name
FROM sqlite_master
WHERE type = 'table' AND NOT name = 'sqlite_sequence'

SQL (0.1ms) SELECT version FROM "schema_migrations"
SQL (0.2ms) select sqlite_version(*)
SQL (0.5ms)  SELECT name
FROM sqlite_master
WHERE type = 'table' AND NOT name = 'sqlite_sequence'

SQL (1.1ms) DROP TABLE "geoinfo_states"
SQL (1.0ms) CREATE TABLE "geoinfo_states" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "abbr" varchar(255), "country" varchar(255), "type" varchar(255)) 
SQL (4.2ms)  SELECT name
FROM sqlite_master
WHERE type = 'table' AND NOT name = 'sqlite_sequence'

SQL (1.5ms) DROP TABLE "geoinfo_cities"
SQL (1.9ms) CREATE TABLE "geoinfo_cities" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "state_id" integer, "gnis_id" integer, "latitude" float, "longitude" float, "population_2000" integer) 
SQL (0.5ms)  SELECT name
FROM sqlite_master
WHERE type = 'table' AND NOT name = 'sqlite_sequence'

SQL (0.2ms) SELECT version FROM "schema_migrations"
SQL (0.2ms) select sqlite_version(*)
SQL (0.4ms)  SELECT name
FROM sqlite_master
WHERE type = 'table' AND NOT name = 'sqlite_sequence'

SQL (1.1ms) DROP TABLE "geoinfo_states"
SQL (0.7ms) CREATE TABLE "geoinfo_states" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "abbr" varchar(255), "country" varchar(255), "type" varchar(255)) 
SQL (0.3ms)  SELECT name
FROM sqlite_master
WHERE type = 'table' AND NOT name = 'sqlite_sequence'

SQL (0.7ms) DROP TABLE "geoinfo_cities"
SQL (0.7ms) CREATE TABLE "geoinfo_cities" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "state_id" integer, "gnis_id" integer, "latitude" float, "longitude" float, "population_2000" integer) 
SQL (0.3ms)  SELECT name
FROM sqlite_master
WHERE type = 'table' AND NOT name = 'sqlite_sequence'

SQL (0.1ms) SELECT version FROM "schema_migrations"
GeoinfoTest::State Load (0.2ms) SELECT * FROM "states" 
GeoinfoTest::City Load (0.1ms) SELECT * FROM "cities" 
Jump to Line
Something went wrong with that request. Please try again.