(1.4ms)  CREATE TABLE "schema_migrations" ("version" varchar NOT NULL) 
   (0.1ms)  select sqlite_version(*)
   (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 CreatePeople (20161006114509)
   (0.0ms)  begin transaction
   (0.3ms)  CREATE TABLE "people" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "first_name" varchar, "last_name" varchar, "sex" varchar(1), "date_of_birth" date, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL) 
  SQL (0.1ms)  INSERT INTO "schema_migrations" ("version") VALUES (?)  [["version", "20161006114509"]]
   (1.2ms)  commit transaction
Migrating to CreatePersonRelationships (20161006121212)
   (0.3ms)  begin transaction
   (0.4ms)  CREATE TABLE "person_relationships" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "person_from" integer, "person_to" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL) 
   (0.1ms)  CREATE  INDEX "relationships_person_lookup" ON "person_relationships" ("person_from", "person_to", "name")
  SQL (0.1ms)  INSERT INTO "schema_migrations" ("version") VALUES (?)  [["version", "20161006121212"]]
   (1.3ms)  commit transaction
  ActiveRecord::SchemaMigration Load (0.1ms)  SELECT "schema_migrations".* FROM "schema_migrations"
   (0.1ms)              SELECT sql
            FROM sqlite_master
            WHERE name='relationships_person_lookup' AND type='index'
            UNION ALL
            SELECT sql
            FROM sqlite_temp_master
            WHERE name='relationships_person_lookup' AND type='index'

   (1.2ms)  CREATE TABLE "schema_migrations" ("version" varchar NOT NULL) 
   (0.1ms)  select sqlite_version(*)
   (1.1ms)  CREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")
  ActiveRecord::SchemaMigration Load (0.1ms)  SELECT "schema_migrations".* FROM "schema_migrations"
Migrating to CreatePeople (20161006114509)
   (0.1ms)  begin transaction
   (0.4ms)  CREATE TABLE "people" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "first_name" varchar, "last_name" varchar, "sex" varchar(1), "date_of_birth" date, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL) 
  SQL (0.1ms)  INSERT INTO "schema_migrations" ("version") VALUES (?)  [["version", "20161006114509"]]
   (1.2ms)  commit transaction
Migrating to CreateGroups (20161006134459)
   (0.0ms)  begin transaction
   (0.3ms)  CREATE TABLE "groups" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "owner_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL) 
   (0.1ms)  CREATE  INDEX "groups_owner_lookup" ON "groups" ("owner_id")
  SQL (0.1ms)  INSERT INTO "schema_migrations" ("version") VALUES (?)  [["version", "20161006134459"]]
   (1.2ms)  commit transaction
Migrating to CreateGroupPeople (20161006134746)
   (0.0ms)  begin transaction
   (0.3ms)  CREATE TABLE "group_people" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "groups_id" integer, "people_id" integer, "join_date" date, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL) 
  SQL (0.1ms)  INSERT INTO "schema_migrations" ("version") VALUES (?)  [["version", "20161006134746"]]
   (1.1ms)  commit transaction
  ActiveRecord::SchemaMigration Load (0.1ms)  SELECT "schema_migrations".* FROM "schema_migrations"
   (0.1ms)              SELECT sql
            FROM sqlite_master
            WHERE name='groups_owner_lookup' AND type='index'
            UNION ALL
            SELECT sql
            FROM sqlite_temp_master
            WHERE name='groups_owner_lookup' AND type='index'

   (1.2ms)  CREATE TABLE "schema_migrations" ("version" varchar NOT NULL) 
   (0.1ms)  select sqlite_version(*)
   (1.1ms)  CREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")
  ActiveRecord::SchemaMigration Load (0.1ms)  SELECT "schema_migrations".* FROM "schema_migrations"
Migrating to CreatePeople (20161006114509)
   (0.0ms)  begin transaction
   (0.3ms)  CREATE TABLE "people" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "first_name" varchar, "last_name" varchar, "sex" varchar(1), "date_of_birth" date, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL) 
  SQL (0.2ms)  INSERT INTO "schema_migrations" ("version") VALUES (?)  [["version", "20161006114509"]]
   (1.1ms)  commit transaction
Migrating to CreateGroups (20161006134459)
   (0.0ms)  begin transaction
   (0.3ms)  CREATE TABLE "groups" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "owner_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL) 
   (0.1ms)  CREATE  INDEX "groups_owner_lookup" ON "groups" ("owner_id")
  SQL (0.2ms)  INSERT INTO "schema_migrations" ("version") VALUES (?)  [["version", "20161006134459"]]
   (1.2ms)  commit transaction
Migrating to CreateGroupPeople (20161006134746)
   (0.0ms)  begin transaction
   (0.3ms)  CREATE TABLE "group_people" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "group_id" integer, "person_id" integer, "join_date" date, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL) 
   (0.1ms)  CREATE  INDEX "group_people_lookup" ON "group_people" ("group_id", "person_id", "join_date")
  SQL (0.1ms)  INSERT INTO "schema_migrations" ("version") VALUES (?)  [["version", "20161006134746"]]
   (1.1ms)  commit transaction
  ActiveRecord::SchemaMigration Load (0.1ms)  SELECT "schema_migrations".* FROM "schema_migrations"
   (0.1ms)              SELECT sql
            FROM sqlite_master
            WHERE name='group_people_lookup' AND type='index'
            UNION ALL
            SELECT sql
            FROM sqlite_temp_master
            WHERE name='group_people_lookup' AND type='index'

   (0.1ms)              SELECT sql
            FROM sqlite_master
            WHERE name='groups_owner_lookup' AND type='index'
            UNION ALL
            SELECT sql
            FROM sqlite_temp_master
            WHERE name='groups_owner_lookup' AND type='index'

   (1.6ms)  CREATE TABLE "schema_migrations" ("version" varchar NOT NULL) 
   (0.1ms)  select sqlite_version(*)
   (1.1ms)  CREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")
  ActiveRecord::SchemaMigration Load (0.1ms)  SELECT "schema_migrations".* FROM "schema_migrations"
Migrating to CreatePeople (20161006114509)
   (0.0ms)  begin transaction
   (0.3ms)  CREATE TABLE "people" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "first_name" varchar, "last_name" varchar, "sex" varchar(1), "date_of_birth" date, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL) 
  SQL (0.1ms)  INSERT INTO "schema_migrations" ("version") VALUES (?)  [["version", "20161006114509"]]
   (1.2ms)  commit transaction
Migrating to CreateGroups (20161006134459)
   (0.0ms)  begin transaction
   (0.3ms)  CREATE TABLE "groups" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "owner_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL) 
   (0.1ms)  CREATE  INDEX "groups_owner_lookup" ON "groups" ("owner_id")
  SQL (0.1ms)  INSERT INTO "schema_migrations" ("version") VALUES (?)  [["version", "20161006134459"]]
   (1.0ms)  commit transaction
Migrating to CreateGroupPeople (20161006134746)
   (0.0ms)  begin transaction
   (0.3ms)  CREATE TABLE "group_people" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "group_id" integer, "person_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL) 
   (0.3ms)  CREATE UNIQUE INDEX "group_people_lookup" ON "group_people" ("group_id", "person_id")
  SQL (0.1ms)  INSERT INTO "schema_migrations" ("version") VALUES (?)  [["version", "20161006134746"]]
   (1.7ms)  commit transaction
  ActiveRecord::SchemaMigration Load (0.1ms)  SELECT "schema_migrations".* FROM "schema_migrations"
   (0.1ms)              SELECT sql
            FROM sqlite_master
            WHERE name='group_people_lookup' AND type='index'
            UNION ALL
            SELECT sql
            FROM sqlite_temp_master
            WHERE name='group_people_lookup' AND type='index'

   (0.1ms)              SELECT sql
            FROM sqlite_master
            WHERE name='groups_owner_lookup' AND type='index'
            UNION ALL
            SELECT sql
            FROM sqlite_temp_master
            WHERE name='groups_owner_lookup' AND type='index'