spec/dummy/log/development.log in social_framework-0.0.2 vs spec/dummy/log/development.log in social_framework-0.0.3

- old
+ new

@@ -87384,5 +87384,1613 @@ UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_social_framework_users_on_email' AND type='index'  +  (0.1ms) begin transaction + SocialFramework::User Exists (0.1ms) SELECT 1 AS one FROM "social_framework_users" WHERE "social_framework_users"."email" = 'u1@email.com' LIMIT 1 + SQL (0.3ms) INSERT INTO "social_framework_users" ("username", "email", "encrypted_password", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?) [["username", "u1"], ["email", "u1@email.com"], ["encrypted_password", "$2a$10$us6w5quhBjDm7we00JY7n.pt01MmTXdnu39QLGp7pi.EcwYbFmzpG"], ["created_at", "2016-06-04 12:29:09.830058"], ["updated_at", "2016-06-04 12:29:09.830058"]] +  (152.2ms) commit transaction +  (0.1ms) begin transaction + SocialFramework::User Exists (0.1ms) SELECT 1 AS one FROM "social_framework_users" WHERE "social_framework_users"."email" = 'u2@email.com' LIMIT 1 + SQL (0.2ms) INSERT INTO "social_framework_users" ("username", "email", "encrypted_password", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?) [["username", "u2"], ["email", "u2@email.com"], ["encrypted_password", "$2a$10$pBvw6H2T3oqLaSO86yC7duiv0tl8r7CUw/G74AmrtZWa6d0TAul.m"], ["created_at", "2016-06-04 12:29:10.057805"], ["updated_at", "2016-06-04 12:29:10.057805"]] +  (146.9ms) commit transaction +  (0.1ms) begin transaction + SocialFramework::User Exists (0.1ms) SELECT 1 AS one FROM "social_framework_users" WHERE "social_framework_users"."email" = 'u3@email.com' LIMIT 1 + SQL (0.2ms) INSERT INTO "social_framework_users" ("username", "email", "encrypted_password", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?) [["username", "u3"], ["email", "u3@email.com"], ["encrypted_password", "$2a$10$jAn1u7vpN5r2l30WBpxTNu9W4ZyWOkCZhUQKdnUBG8OtEH/TmjPn6"], ["created_at", "2016-06-04 12:29:10.282940"], ["updated_at", "2016-06-04 12:29:10.282940"]] +  (143.9ms) commit transaction +  (0.1ms) begin transaction + SocialFramework::User Exists (0.1ms) SELECT 1 AS one FROM "social_framework_users" WHERE "social_framework_users"."email" = 'u4@email.com' LIMIT 1 + SQL (0.2ms) INSERT INTO "social_framework_users" ("username", "email", "encrypted_password", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?) [["username", "u4"], ["email", "u4@email.com"], ["encrypted_password", "$2a$10$itFEhdlrNyaE7dvLtzVSGuVu7J78VP9gqOTCCdeKzYwdXm7cSbDYS"], ["created_at", "2016-06-04 12:29:10.501810"], ["updated_at", "2016-06-04 12:29:10.501810"]] +  (125.1ms) commit transaction +  (0.1ms) begin transaction + SocialFramework::User Exists (0.1ms) SELECT 1 AS one FROM "social_framework_users" WHERE "social_framework_users"."email" = 'u5@email.com' LIMIT 1 + SQL (0.2ms) INSERT INTO "social_framework_users" ("username", "email", "encrypted_password", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?) [["username", "u5"], ["email", "u5@email.com"], ["encrypted_password", "$2a$10$z7S/Wbb8DS.UxDDNt3MjB.leeAo9TSLjJkewobbuw5R0OJ/YUFAdS"], ["created_at", "2016-06-04 12:29:10.703947"], ["updated_at", "2016-06-04 12:29:10.703947"]] +  (145.1ms) commit transaction + SocialFramework::Schedule Load (0.1ms) SELECT "social_framework_schedules".* FROM "social_framework_schedules" WHERE "social_framework_schedules"."user_id" = 1 LIMIT 1 +  (0.1ms) begin transaction + SQL (0.2ms) INSERT INTO "social_framework_schedules" ("user_id", "created_at", "updated_at") VALUES (?, ?, ?) [["user_id", 1], ["created_at", "2016-06-04 12:29:10.870875"], ["updated_at", "2016-06-04 12:29:10.870875"]] +  (135.0ms) commit transaction +  (0.2ms) SELECT COUNT(*) FROM "social_framework_events" INNER JOIN "social_framework_participant_events" ON "social_framework_participant_events"."event_id" = "social_framework_events"."id" WHERE (social_framework_participant_events.schedule_id = 1 AND social_framework_participant_events.confirmed = 't' AND social_framework_events.start < '2016-06-05 02:59:59.000000' AND social_framework_events.finish > '2016-06-04 12:29:10.850456') +  (0.1ms) begin transaction + SQL (0.2ms) INSERT INTO "social_framework_events" ("title", "start", "finish", "description", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?) [["title", "event1"], ["start", "2016-06-04 12:29:10.850456"], ["finish", "2016-06-05 02:59:59.000000"], ["description", ""], ["created_at", "2016-06-04 12:29:11.024281"], ["updated_at", "2016-06-04 12:29:11.024281"]] +  (126.1ms) commit transaction +  (0.1ms) begin transaction + SQL (0.5ms) INSERT INTO "social_framework_participant_events" ("event_id", "schedule_id", "confirmed", "role") VALUES (?, ?, ?, ?) [["event_id", 1], ["schedule_id", 1], ["confirmed", "t"], ["role", "creator"]] +  (141.9ms) commit transaction + SocialFramework::User Load (0.4ms) SELECT "social_framework_users".* FROM "social_framework_users" WHERE "social_framework_users"."id" = ? LIMIT 1 [["id", 1]] +The SocialFramework::User haven't the attribute title + SocialFramework::User Load (0.1ms) SELECT "social_framework_users".* FROM "social_framework_users" WHERE "social_framework_users"."id" = ? LIMIT 1 [["id", 1]] + SocialFramework::Edge Load (0.2ms) SELECT "social_framework_edges".* FROM "social_framework_edges" WHERE ((origin_id = 1 AND bidirectional = 'f') OR + (bidirectional = 't' AND (origin_id = 1 OR destiny_id = 1))) + SocialFramework::User Load (0.1ms) SELECT "social_framework_users".* FROM "social_framework_users" WHERE "social_framework_users"."id" = ? LIMIT 1 [["id", 1]] + SocialFramework::Schedule Load (0.1ms) SELECT "social_framework_schedules".* FROM "social_framework_schedules" WHERE "social_framework_schedules"."user_id" = 1 LIMIT 1 + SocialFramework::Event Load (0.2ms) SELECT "social_framework_events".* FROM "social_framework_events" INNER JOIN "social_framework_participant_events" ON "social_framework_participant_events"."event_id" = "social_framework_events"."id" WHERE (social_framework_participant_events.schedule_id = 1 AND social_framework_participant_events.confirmed = 't') ORDER BY "social_framework_events"."start" DESC +The SocialFramework::Event haven't the attribute username +The SocialFramework::Event haven't the attribute email + SocialFramework::User Load (0.1ms) SELECT "social_framework_users".* FROM "social_framework_users" WHERE "social_framework_users"."id" = ? LIMIT 1 [["id", 1]] +The SocialFramework::User haven't the attribute title + SocialFramework::User Load (0.2ms) SELECT "social_framework_users".* FROM "social_framework_users" WHERE "social_framework_users"."id" = ? LIMIT 1 [["id", 1]] + SocialFramework::Edge Load (0.4ms) SELECT "social_framework_edges".* FROM "social_framework_edges" WHERE ((origin_id = 1 AND bidirectional = 'f') OR + (bidirectional = 't' AND (origin_id = 1 OR destiny_id = 1))) + SocialFramework::User Load (0.1ms) SELECT "social_framework_users".* FROM "social_framework_users" WHERE "social_framework_users"."id" = ? LIMIT 1 [["id", 1]] + SocialFramework::Schedule Load (0.2ms) SELECT "social_framework_schedules".* FROM "social_framework_schedules" WHERE "social_framework_schedules"."user_id" = 1 LIMIT 1 + SocialFramework::Event Load (0.2ms) SELECT "social_framework_events".* FROM "social_framework_events" INNER JOIN "social_framework_participant_events" ON "social_framework_participant_events"."event_id" = "social_framework_events"."id" WHERE (social_framework_participant_events.schedule_id = 1 AND social_framework_participant_events.confirmed = 't') ORDER BY "social_framework_events"."start" DESC +The SocialFramework::Event haven't the attribute username +The SocialFramework::Event haven't the attribute email + SocialFramework::User Load (0.2ms) SELECT "social_framework_users".* FROM "social_framework_users" WHERE "social_framework_users"."id" = ? LIMIT 1 [["id", 1]] +The SocialFramework::User haven't the attribute title + SocialFramework::User Load (0.1ms) SELECT "social_framework_users".* FROM "social_framework_users" WHERE "social_framework_users"."id" = ? LIMIT 1 [["id", 1]] + SocialFramework::Edge Load (0.2ms) SELECT "social_framework_edges".* FROM "social_framework_edges" WHERE ((origin_id = 1 AND bidirectional = 'f') OR + (bidirectional = 't' AND (origin_id = 1 OR destiny_id = 1))) + SocialFramework::User Load (0.1ms) SELECT "social_framework_users".* FROM "social_framework_users" WHERE "social_framework_users"."id" = ? LIMIT 1 [["id", 1]] + SocialFramework::Schedule Load (0.2ms) SELECT "social_framework_schedules".* FROM "social_framework_schedules" WHERE "social_framework_schedules"."user_id" = 1 LIMIT 1 + SocialFramework::Event Load (0.3ms) SELECT "social_framework_events".* FROM "social_framework_events" INNER JOIN "social_framework_participant_events" ON "social_framework_participant_events"."event_id" = "social_framework_events"."id" WHERE (social_framework_participant_events.schedule_id = 1 AND social_framework_participant_events.confirmed = 't') ORDER BY "social_framework_events"."start" DESC +The SocialFramework::Event haven't the attribute username +The SocialFramework::Event haven't the attribute email + SocialFramework::User Load (0.2ms) SELECT "social_framework_users".* FROM "social_framework_users" WHERE "social_framework_users"."id" = ? LIMIT 1 [["id", 1]] +The SocialFramework::User haven't the attribute title + SocialFramework::User Load (0.3ms) SELECT "social_framework_users".* FROM "social_framework_users" WHERE "social_framework_users"."id" = ? LIMIT 1 [["id", 1]] + SocialFramework::Edge Load (0.3ms) SELECT "social_framework_edges".* FROM "social_framework_edges" WHERE ((origin_id = 1 AND bidirectional = 'f') OR + (bidirectional = 't' AND (origin_id = 1 OR destiny_id = 1))) + SocialFramework::User Load (0.1ms) SELECT "social_framework_users".* FROM "social_framework_users" WHERE "social_framework_users"."id" = ? LIMIT 1 [["id", 1]] + SocialFramework::Schedule Load (0.3ms) SELECT "social_framework_schedules".* FROM "social_framework_schedules" WHERE "social_framework_schedules"."user_id" = 1 LIMIT 1 + SocialFramework::Event Load (0.5ms) SELECT "social_framework_events".* FROM "social_framework_events" INNER JOIN "social_framework_participant_events" ON "social_framework_participant_events"."event_id" = "social_framework_events"."id" WHERE (social_framework_participant_events.schedule_id = 1 AND social_framework_participant_events.confirmed = 't') ORDER BY "social_framework_events"."start" DESC +The SocialFramework::Event haven't the attribute username +The SocialFramework::Event haven't the attribute email + SocialFramework::User Load (0.2ms) SELECT "social_framework_users".* FROM "social_framework_users" WHERE "social_framework_users"."id" = ? LIMIT 1 [["id", 1]] +The SocialFramework::User haven't the attribute title + SocialFramework::User Load (0.2ms) SELECT "social_framework_users".* FROM "social_framework_users" WHERE "social_framework_users"."id" = ? LIMIT 1 [["id", 1]] + SocialFramework::Edge Load (0.5ms) SELECT "social_framework_edges".* FROM "social_framework_edges" WHERE ((origin_id = 1 AND bidirectional = 'f') OR + (bidirectional = 't' AND (origin_id = 1 OR destiny_id = 1))) + SocialFramework::User Load (0.3ms) SELECT "social_framework_users".* FROM "social_framework_users" WHERE "social_framework_users"."id" = ? LIMIT 1 [["id", 1]] + SocialFramework::Schedule Load (0.2ms) SELECT "social_framework_schedules".* FROM "social_framework_schedules" WHERE "social_framework_schedules"."user_id" = 1 LIMIT 1 + SocialFramework::Event Load (0.3ms) SELECT "social_framework_events".* FROM "social_framework_events" INNER JOIN "social_framework_participant_events" ON "social_framework_participant_events"."event_id" = "social_framework_events"."id" WHERE (social_framework_participant_events.schedule_id = 1 AND social_framework_participant_events.confirmed = 't') ORDER BY "social_framework_events"."start" DESC +The SocialFramework::Event haven't the attribute username +The SocialFramework::Event haven't the attribute email + SocialFramework::User Load (0.2ms) SELECT "social_framework_users".* FROM "social_framework_users" WHERE "social_framework_users"."id" = ? LIMIT 1 [["id", 1]] +The SocialFramework::User haven't the attribute title + SocialFramework::User Load (0.2ms) SELECT "social_framework_users".* FROM "social_framework_users" WHERE "social_framework_users"."id" = ? LIMIT 1 [["id", 1]] + SocialFramework::Edge Load (0.4ms) SELECT "social_framework_edges".* FROM "social_framework_edges" WHERE ((origin_id = 1 AND bidirectional = 'f') OR + (bidirectional = 't' AND (origin_id = 1 OR destiny_id = 1))) + SocialFramework::User Load (0.2ms) SELECT "social_framework_users".* FROM "social_framework_users" WHERE "social_framework_users"."id" = ? LIMIT 1 [["id", 1]] + SocialFramework::Schedule Load (0.3ms) SELECT "social_framework_schedules".* FROM "social_framework_schedules" WHERE "social_framework_schedules"."user_id" = 1 LIMIT 1 + SocialFramework::Event Load (0.4ms) SELECT "social_framework_events".* FROM "social_framework_events" INNER JOIN "social_framework_participant_events" ON "social_framework_participant_events"."event_id" = "social_framework_events"."id" WHERE (social_framework_participant_events.schedule_id = 1 AND social_framework_participant_events.confirmed = 't') ORDER BY "social_framework_events"."start" DESC +The SocialFramework::Event haven't the attribute username +The SocialFramework::Event haven't the attribute email + SocialFramework::User Load (0.3ms) SELECT "social_framework_users".* FROM "social_framework_users" WHERE "social_framework_users"."id" = ? LIMIT 1 [["id", 1]] +The SocialFramework::User haven't the attribute title + SocialFramework::User Load (0.2ms) SELECT "social_framework_users".* FROM "social_framework_users" WHERE "social_framework_users"."id" = ? LIMIT 1 [["id", 1]] + SocialFramework::Edge Load (0.4ms) SELECT "social_framework_edges".* FROM "social_framework_edges" WHERE ((origin_id = 1 AND bidirectional = 'f') OR + (bidirectional = 't' AND (origin_id = 1 OR destiny_id = 1))) + SocialFramework::User Load (0.2ms) SELECT "social_framework_users".* FROM "social_framework_users" WHERE "social_framework_users"."id" = ? LIMIT 1 [["id", 1]] + SocialFramework::Schedule Load (0.2ms) SELECT "social_framework_schedules".* FROM "social_framework_schedules" WHERE "social_framework_schedules"."user_id" = 1 LIMIT 1 + SocialFramework::Event Load (0.2ms) SELECT "social_framework_events".* FROM "social_framework_events" INNER JOIN "social_framework_participant_events" ON "social_framework_participant_events"."event_id" = "social_framework_events"."id" WHERE (social_framework_participant_events.schedule_id = 1 AND social_framework_participant_events.confirmed = 't') ORDER BY "social_framework_events"."start" DESC +The SocialFramework::Event haven't the attribute username +The SocialFramework::Event haven't the attribute email +The SocialFramework::User haven't the attribute title +The SocialFramework::Event haven't the attribute username +The SocialFramework::Event haven't the attribute email +The SocialFramework::User haven't the attribute title +The SocialFramework::Event haven't the attribute username +The SocialFramework::Event haven't the attribute email +The SocialFramework::User haven't the attribute title +The SocialFramework::Event haven't the attribute username +The SocialFramework::Event haven't the attribute email +The SocialFramework::User haven't the attribute title +The SocialFramework::Event haven't the attribute username +The SocialFramework::Event haven't the attribute email +The SocialFramework::User haven't the attribute title +The SocialFramework::Event haven't the attribute username +The SocialFramework::Event haven't the attribute email + SocialFramework::User Load (0.2ms) SELECT "social_framework_users".* FROM "social_framework_users" WHERE "social_framework_users"."id" = ? LIMIT 1 [["id", 1]] +The SocialFramework::User haven't the attribute title + SocialFramework::User Load (0.1ms) SELECT "social_framework_users".* FROM "social_framework_users" WHERE "social_framework_users"."id" = ? LIMIT 1 [["id", 1]] + SocialFramework::Edge Load (0.2ms) SELECT "social_framework_edges".* FROM "social_framework_edges" WHERE ((origin_id = 1 AND bidirectional = 'f') OR + (bidirectional = 't' AND (origin_id = 1 OR destiny_id = 1))) + SocialFramework::User Load (0.1ms) SELECT "social_framework_users".* FROM "social_framework_users" WHERE "social_framework_users"."id" = ? LIMIT 1 [["id", 1]] + SocialFramework::Schedule Load (0.1ms) SELECT "social_framework_schedules".* FROM "social_framework_schedules" WHERE "social_framework_schedules"."user_id" = 1 LIMIT 1 + SocialFramework::Event Load (0.2ms) SELECT "social_framework_events".* FROM "social_framework_events" INNER JOIN "social_framework_participant_events" ON "social_framework_participant_events"."event_id" = "social_framework_events"."id" WHERE (social_framework_participant_events.schedule_id = 1 AND social_framework_participant_events.confirmed = 't') ORDER BY "social_framework_events"."start" DESC +The SocialFramework::Event haven't the attribute username +The SocialFramework::Event haven't the attribute email + SocialFramework::User Load (0.4ms) SELECT "social_framework_users".* FROM "social_framework_users" WHERE "social_framework_users"."id" = ? LIMIT 1 [["id", 1]] + SocialFramework::Schedule Load (0.2ms) SELECT "social_framework_schedules".* FROM "social_framework_schedules" WHERE "social_framework_schedules"."user_id" = 1 LIMIT 1 + SocialFramework::Schedule Load (0.4ms) SELECT "social_framework_schedules".* FROM "social_framework_schedules" WHERE "social_framework_schedules"."user_id" = 1 LIMIT 1 +  (144.7ms) CREATE TABLE "schema_migrations" ("version" varchar NOT NULL)  +  (0.1ms) select sqlite_version(*) +  (133.0ms) CREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version") + ActiveRecord::SchemaMigration Load (0.2ms) SELECT "schema_migrations".* FROM "schema_migrations" +Migrating to DeviseCreateSocialFrameworkUsers (20160129004111) +  (0.1ms) begin transaction +  (0.4ms) CREATE TABLE "social_framework_users" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "username" varchar NOT NULL, "email" varchar NOT NULL, "encrypted_password" varchar NOT NULL, "reset_password_token" varchar, "reset_password_sent_at" datetime, "remember_created_at" datetime, "sign_in_count" integer DEFAULT 0 NOT NULL, "current_sign_in_at" datetime, "last_sign_in_at" datetime, "current_sign_in_ip" varchar, "last_sign_in_ip" varchar, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL) +  (0.2ms) CREATE UNIQUE INDEX "index_social_framework_users_on_email" ON "social_framework_users" ("email") +  (0.1ms) SELECT sql + FROM sqlite_master + WHERE name='index_social_framework_users_on_email' AND type='index' + UNION ALL + SELECT sql + FROM sqlite_temp_master + WHERE name='index_social_framework_users_on_email' AND type='index' + +  (0.1ms) CREATE UNIQUE INDEX "index_social_framework_users_on_username" ON "social_framework_users" ("username") +  (0.1ms) SELECT sql + FROM sqlite_master + WHERE name='index_social_framework_users_on_username' AND type='index' + UNION ALL + SELECT sql + FROM sqlite_temp_master + WHERE name='index_social_framework_users_on_username' AND type='index' + +  (0.1ms)  SELECT sql + FROM sqlite_master + WHERE name='index_social_framework_users_on_email' AND type='index' + UNION ALL + SELECT sql + FROM sqlite_temp_master + WHERE name='index_social_framework_users_on_email' AND type='index' + +  (0.1ms) CREATE UNIQUE INDEX "index_social_framework_users_on_reset_password_token" ON "social_framework_users" ("reset_password_token") + SQL (0.1ms) INSERT INTO "schema_migrations" ("version") VALUES (?) [["version", "20160129004111"]] +  (126.8ms) commit transaction +Migrating to CreateSocialFrameworkEdges (20160226123409) +  (0.1ms) begin transaction +  (0.6ms) CREATE TABLE "social_framework_edges" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "origin_id" integer NOT NULL, "destiny_id" integer NOT NULL, "label" varchar NOT NULL, "bidirectional" boolean DEFAULT 't' NOT NULL, "active" boolean DEFAULT 'f' NOT NULL, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL) +  (0.3ms) CREATE INDEX "index_social_framework_edges_on_origin_id" ON "social_framework_edges" ("origin_id") +  (0.2ms) SELECT sql + FROM sqlite_master + WHERE name='index_social_framework_edges_on_origin_id' AND type='index' + UNION ALL + SELECT sql + FROM sqlite_temp_master + WHERE name='index_social_framework_edges_on_origin_id' AND type='index' + +  (0.1ms) CREATE INDEX "index_social_framework_edges_on_destiny_id" ON "social_framework_edges" ("destiny_id") + SQL (0.1ms) INSERT INTO "schema_migrations" ("version") VALUES (?) [["version", "20160226123409"]] +  (105.3ms) commit transaction +Migrating to CreateSocialFrameworkSchedules (20160406131316) +  (0.1ms) begin transaction +  (0.6ms) CREATE TABLE "social_framework_schedules" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer NOT NULL, "user_type" varchar NOT NULL, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)  +  (0.4ms) CREATE UNIQUE INDEX "index_social_framework_schedules_on_user_id" ON "social_framework_schedules" ("user_id") + SQL (0.3ms) INSERT INTO "schema_migrations" ("version") VALUES (?) [["version", "20160406131316"]] +  (105.6ms) commit transaction +Migrating to CreateSocialFrameworkEvents (20160406133419) +  (0.1ms) begin transaction +  (0.7ms) CREATE TABLE "social_framework_events" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar NOT NULL, "description" varchar, "start" datetime, "finish" datetime, "particular" boolean DEFAULT 'f', "route_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL) + SQL (0.3ms) INSERT INTO "schema_migrations" ("version") VALUES (?) [["version", "20160406133419"]] +  (117.5ms) commit transaction +Migrating to CreateSocialFrameworkEventsSchedules (20160406134250) +  (0.1ms) begin transaction +  (0.6ms) CREATE TABLE "social_framework_events_schedules" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "schedule_id" integer NOT NULL, "event_id" integer NOT NULL) +  (0.5ms) CREATE INDEX "index_social_framework_events_schedules_on_schedule_id" ON "social_framework_events_schedules" ("schedule_id") +  (0.2ms) SELECT sql + FROM sqlite_master + WHERE name='index_social_framework_events_schedules_on_schedule_id' AND type='index' + UNION ALL + SELECT sql + FROM sqlite_temp_master + WHERE name='index_social_framework_events_schedules_on_schedule_id' AND type='index' + +  (0.3ms) CREATE INDEX "index_social_framework_events_schedules_on_event_id" ON "social_framework_events_schedules" ("event_id") + SQL (0.2ms) INSERT INTO "schema_migrations" ("version") VALUES (?) [["version", "20160406134250"]] +  (115.7ms) commit transaction +Migrating to CreateSocialFrameworkParticipantEvents (20160406165523) +  (0.1ms) begin transaction +  (0.5ms) CREATE TABLE "social_framework_participant_events" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "event_id" integer NOT NULL, "schedule_id" integer NOT NULL, "confirmed" boolean DEFAULT 'f', "role" varchar DEFAULT 'participant')  +  (0.3ms) CREATE INDEX "index_social_framework_participant_events_on_event_id" ON "social_framework_participant_events" ("event_id") +  (0.2ms)  SELECT sql + FROM sqlite_master + WHERE name='index_social_framework_participant_events_on_event_id' AND type='index' + UNION ALL + SELECT sql + FROM sqlite_temp_master + WHERE name='index_social_framework_participant_events_on_event_id' AND type='index' + +  (0.2ms) CREATE INDEX "index_social_framework_participant_events_on_schedule_id" ON "social_framework_participant_events" ("schedule_id") + SQL (0.1ms) INSERT INTO "schema_migrations" ("version") VALUES (?) [["version", "20160406165523"]] +  (105.4ms) commit transaction +Migrating to CreateSocialFrameworkRoutes (20160516122239) +  (0.2ms) begin transaction +  (0.6ms) CREATE TABLE "social_framework_routes" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar NOT NULL, "distance" integer NOT NULL, "mode_of_travel" varchar DEFAULT 'driving' NOT NULL, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL) +  (0.3ms) CREATE TABLE "social_framework_routes_users" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer NOT NULL, "route_id" integer NOT NULL)  +  (0.3ms) CREATE INDEX "index_social_framework_routes_users_on_user_id" ON "social_framework_routes_users" ("user_id") +  (0.2ms)  SELECT sql + FROM sqlite_master + WHERE name='index_social_framework_routes_users_on_user_id' AND type='index' + UNION ALL + SELECT sql + FROM sqlite_temp_master + WHERE name='index_social_framework_routes_users_on_user_id' AND type='index' + +  (0.3ms) CREATE INDEX "index_social_framework_routes_users_on_route_id" ON "social_framework_routes_users" ("route_id") +  (0.2ms)  SELECT sql + FROM sqlite_master + WHERE name='index_social_framework_routes_users_on_route_id' AND type='index' + UNION ALL + SELECT sql + FROM sqlite_temp_master + WHERE name='index_social_framework_routes_users_on_route_id' AND type='index' + +  (0.2ms) SELECT sql + FROM sqlite_master + WHERE name='index_social_framework_routes_users_on_user_id' AND type='index' + UNION ALL + SELECT sql + FROM sqlite_temp_master + WHERE name='index_social_framework_routes_users_on_user_id' AND type='index' + +  (0.4ms) CREATE UNIQUE INDEX "index_social_framework_routes_users_on_user_id_and_route_id" ON "social_framework_routes_users" ("user_id", "route_id") + SQL (0.2ms) INSERT INTO "schema_migrations" ("version") VALUES (?) [["version", "20160516122239"]] +  (111.7ms) commit transaction +Migrating to CreateSocialFrameworkLocations (20160516122649) +  (0.1ms) begin transaction +  (0.3ms) CREATE TABLE "social_framework_locations" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "route_id" integer NOT NULL, "latitude" decimal NOT NULL, "longitude" decimal NOT NULL, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)  + SQL (0.1ms) INSERT INTO "schema_migrations" ("version") VALUES (?) [["version", "20160516122649"]] +  (109.4ms) commit transaction + ActiveRecord::SchemaMigration Load (0.1ms) SELECT "schema_migrations".* FROM "schema_migrations" +  (0.1ms)  SELECT sql + FROM sqlite_master + WHERE name='index_social_framework_edges_on_destiny_id' AND type='index' + UNION ALL + SELECT sql + FROM sqlite_temp_master + WHERE name='index_social_framework_edges_on_destiny_id' AND type='index' + +  (0.1ms) SELECT sql + FROM sqlite_master + WHERE name='index_social_framework_edges_on_origin_id' AND type='index' + UNION ALL + SELECT sql + FROM sqlite_temp_master + WHERE name='index_social_framework_edges_on_origin_id' AND type='index' + +  (0.1ms)  SELECT sql + FROM sqlite_master + WHERE name='index_social_framework_events_schedules_on_event_id' AND type='index' + UNION ALL + SELECT sql + FROM sqlite_temp_master + WHERE name='index_social_framework_events_schedules_on_event_id' AND type='index' + +  (0.1ms) SELECT sql + FROM sqlite_master + WHERE name='index_social_framework_events_schedules_on_schedule_id' AND type='index' + UNION ALL + SELECT sql + FROM sqlite_temp_master + WHERE name='index_social_framework_events_schedules_on_schedule_id' AND type='index' + +  (0.1ms)  SELECT sql + FROM sqlite_master + WHERE name='index_social_framework_participant_events_on_schedule_id' AND type='index' + UNION ALL + SELECT sql + FROM sqlite_temp_master + WHERE name='index_social_framework_participant_events_on_schedule_id' AND type='index' + +  (0.1ms) SELECT sql + FROM sqlite_master + WHERE name='index_social_framework_participant_events_on_event_id' AND type='index' + UNION ALL + SELECT sql + FROM sqlite_temp_master + WHERE name='index_social_framework_participant_events_on_event_id' AND type='index' + +  (0.1ms)  SELECT sql + FROM sqlite_master + WHERE name='index_social_framework_routes_users_on_user_id_and_route_id' AND type='index' + UNION ALL + SELECT sql + FROM sqlite_temp_master + WHERE name='index_social_framework_routes_users_on_user_id_and_route_id' AND type='index' + +  (0.1ms) SELECT sql + FROM sqlite_master + WHERE name='index_social_framework_routes_users_on_route_id' AND type='index' + UNION ALL + SELECT sql + FROM sqlite_temp_master + WHERE name='index_social_framework_routes_users_on_route_id' AND type='index' + +  (0.1ms)  SELECT sql + FROM sqlite_master + WHERE name='index_social_framework_routes_users_on_user_id' AND type='index' + UNION ALL + SELECT sql + FROM sqlite_temp_master + WHERE name='index_social_framework_routes_users_on_user_id' AND type='index' + +  (0.1ms) SELECT sql + FROM sqlite_master + WHERE name='index_social_framework_schedules_on_user_id' AND type='index' + UNION ALL + SELECT sql + FROM sqlite_temp_master + WHERE name='index_social_framework_schedules_on_user_id' AND type='index' + +  (0.1ms)  SELECT sql + FROM sqlite_master + WHERE name='index_social_framework_users_on_reset_password_token' AND type='index' + UNION ALL + SELECT sql + FROM sqlite_temp_master + WHERE name='index_social_framework_users_on_reset_password_token' AND type='index' + +  (0.1ms) SELECT sql + FROM sqlite_master + WHERE name='index_social_framework_users_on_username' AND type='index' + UNION ALL + SELECT sql + FROM sqlite_temp_master + WHERE name='index_social_framework_users_on_username' AND type='index' + +  (0.1ms)  SELECT sql + FROM sqlite_master + WHERE name='index_social_framework_users_on_email' AND type='index' + UNION ALL + SELECT sql + FROM sqlite_temp_master + WHERE name='index_social_framework_users_on_email' AND type='index' + +  (0.1ms) begin transaction + SocialFramework::User Exists (0.1ms) SELECT 1 AS one FROM "social_framework_users" WHERE "social_framework_users"."email" = 'u1@email.com' LIMIT 1 + SQL (0.3ms) INSERT INTO "social_framework_users" ("username", "email", "encrypted_password", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?) [["username", "u1"], ["email", "u1@email.com"], ["encrypted_password", "$2a$10$v54KM75qWIHIDhjSLOIsn.4gCKWeM1ABe1x2VrvJhOHk4JKrLccGi"], ["created_at", "2016-06-08 16:48:31.224993"], ["updated_at", "2016-06-08 16:48:31.224993"]] +  (89.1ms) commit transaction + SocialFramework::Schedule Load (0.1ms) SELECT "social_framework_schedules".* FROM "social_framework_schedules" WHERE "social_framework_schedules"."user_id" = 1 LIMIT 1 +  (0.1ms) begin transaction + SQL (0.2ms) INSERT INTO "social_framework_schedules" ("user_id", "created_at", "updated_at") VALUES (?, ?, ?) [["user_id", 1], ["created_at", "2016-06-08 16:48:40.193333"], ["updated_at", "2016-06-08 16:48:40.193333"]] +  (0.1ms) rollback transaction + SocialFramework::Schedule Load (0.4ms) SELECT "social_framework_schedules".* FROM "social_framework_schedules" WHERE "social_framework_schedules"."user_id" = 1 LIMIT 1 +  (0.1ms) begin transaction + SQL (0.4ms) INSERT INTO "social_framework_schedules" ("user_id", "created_at", "updated_at") VALUES (?, ?, ?) [["user_id", 1], ["created_at", "2016-06-08 16:48:58.398905"], ["updated_at", "2016-06-08 16:48:58.398905"]] +  (0.1ms) rollback transaction + SocialFramework::Schedule Load (0.3ms) SELECT "social_framework_schedules".* FROM "social_framework_schedules" WHERE "social_framework_schedules"."user_id" = 1 LIMIT 1 +  (0.1ms) begin transaction + SQL (0.4ms) INSERT INTO "social_framework_schedules" ("user_id", "created_at", "updated_at") VALUES (?, ?, ?) [["user_id", 1], ["created_at", "2016-06-08 16:49:00.119725"], ["updated_at", "2016-06-08 16:49:00.119725"]] +  (0.1ms) rollback transaction +  (110.2ms) CREATE TABLE "schema_migrations" ("version" varchar NOT NULL)  +  (0.2ms) select sqlite_version(*) +  (76.4ms) CREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version") + ActiveRecord::SchemaMigration Load (0.2ms) SELECT "schema_migrations".* FROM "schema_migrations" +Migrating to DeviseCreateSocialFrameworkUsers (20160129004111) +  (0.2ms) begin transaction +  (0.4ms) CREATE TABLE "social_framework_users" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "username" varchar NOT NULL, "email" varchar NOT NULL, "encrypted_password" varchar NOT NULL, "reset_password_token" varchar, "reset_password_sent_at" datetime, "remember_created_at" datetime, "sign_in_count" integer DEFAULT 0 NOT NULL, "current_sign_in_at" datetime, "last_sign_in_at" datetime, "current_sign_in_ip" varchar, "last_sign_in_ip" varchar, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL) +  (0.3ms) CREATE UNIQUE INDEX "index_social_framework_users_on_email" ON "social_framework_users" ("email") +  (0.1ms) SELECT sql + FROM sqlite_master + WHERE name='index_social_framework_users_on_email' AND type='index' + UNION ALL + SELECT sql + FROM sqlite_temp_master + WHERE name='index_social_framework_users_on_email' AND type='index' + +  (0.2ms) CREATE UNIQUE INDEX "index_social_framework_users_on_username" ON "social_framework_users" ("username") +  (0.1ms) SELECT sql + FROM sqlite_master + WHERE name='index_social_framework_users_on_username' AND type='index' + UNION ALL + SELECT sql + FROM sqlite_temp_master + WHERE name='index_social_framework_users_on_username' AND type='index' + +  (0.1ms)  SELECT sql + FROM sqlite_master + WHERE name='index_social_framework_users_on_email' AND type='index' + UNION ALL + SELECT sql + FROM sqlite_temp_master + WHERE name='index_social_framework_users_on_email' AND type='index' + +  (0.2ms) CREATE UNIQUE INDEX "index_social_framework_users_on_reset_password_token" ON "social_framework_users" ("reset_password_token") + SQL (0.1ms) INSERT INTO "schema_migrations" ("version") VALUES (?) [["version", "20160129004111"]] +  (122.4ms) commit transaction +Migrating to CreateSocialFrameworkEdges (20160226123409) +  (0.1ms) begin transaction +  (0.7ms) CREATE TABLE "social_framework_edges" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "origin_id" integer NOT NULL, "destiny_id" integer NOT NULL, "label" varchar NOT NULL, "bidirectional" boolean DEFAULT 't' NOT NULL, "active" boolean DEFAULT 'f' NOT NULL, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL) +  (0.3ms) CREATE INDEX "index_social_framework_edges_on_origin_id" ON "social_framework_edges" ("origin_id") +  (0.2ms) SELECT sql + FROM sqlite_master + WHERE name='index_social_framework_edges_on_origin_id' AND type='index' + UNION ALL + SELECT sql + FROM sqlite_temp_master + WHERE name='index_social_framework_edges_on_origin_id' AND type='index' + +  (0.3ms) CREATE INDEX "index_social_framework_edges_on_destiny_id" ON "social_framework_edges" ("destiny_id") + SQL (0.2ms) INSERT INTO "schema_migrations" ("version") VALUES (?) [["version", "20160226123409"]] +  (125.1ms) commit transaction +Migrating to CreateSocialFrameworkSchedules (20160406131316) +  (0.1ms) begin transaction +  (0.6ms) CREATE TABLE "social_framework_schedules" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer NOT NULL, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)  +  (0.5ms) CREATE UNIQUE INDEX "index_social_framework_schedules_on_user_id" ON "social_framework_schedules" ("user_id") + SQL (0.2ms) INSERT INTO "schema_migrations" ("version") VALUES (?) [["version", "20160406131316"]] +  (94.3ms) commit transaction +Migrating to CreateSocialFrameworkEvents (20160406133419) +  (0.1ms) begin transaction +  (0.7ms) CREATE TABLE "social_framework_events" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar NOT NULL, "description" varchar, "start" datetime, "finish" datetime, "particular" boolean DEFAULT 'f', "route_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL) + SQL (0.2ms) INSERT INTO "schema_migrations" ("version") VALUES (?) [["version", "20160406133419"]] +  (119.0ms) commit transaction +Migrating to CreateSocialFrameworkEventsSchedules (20160406134250) +  (0.3ms) begin transaction +  (0.6ms) CREATE TABLE "social_framework_events_schedules" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "schedule_id" integer NOT NULL, "event_id" integer NOT NULL) +  (0.3ms) CREATE INDEX "index_social_framework_events_schedules_on_schedule_id" ON "social_framework_events_schedules" ("schedule_id") +  (0.1ms) SELECT sql + FROM sqlite_master + WHERE name='index_social_framework_events_schedules_on_schedule_id' AND type='index' + UNION ALL + SELECT sql + FROM sqlite_temp_master + WHERE name='index_social_framework_events_schedules_on_schedule_id' AND type='index' + +  (0.2ms) CREATE INDEX "index_social_framework_events_schedules_on_event_id" ON "social_framework_events_schedules" ("event_id") + SQL (0.1ms) INSERT INTO "schema_migrations" ("version") VALUES (?) [["version", "20160406134250"]] +  (116.5ms) commit transaction +Migrating to CreateSocialFrameworkParticipantEvents (20160406165523) +  (0.1ms) begin transaction +  (0.6ms) CREATE TABLE "social_framework_participant_events" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "event_id" integer NOT NULL, "schedule_id" integer NOT NULL, "confirmed" boolean DEFAULT 'f', "role" varchar DEFAULT 'participant')  +  (0.3ms) CREATE INDEX "index_social_framework_participant_events_on_event_id" ON "social_framework_participant_events" ("event_id") +  (0.2ms)  SELECT sql + FROM sqlite_master + WHERE name='index_social_framework_participant_events_on_event_id' AND type='index' + UNION ALL + SELECT sql + FROM sqlite_temp_master + WHERE name='index_social_framework_participant_events_on_event_id' AND type='index' + +  (0.4ms) CREATE INDEX "index_social_framework_participant_events_on_schedule_id" ON "social_framework_participant_events" ("schedule_id") + SQL (0.2ms) INSERT INTO "schema_migrations" ("version") VALUES (?) [["version", "20160406165523"]] +  (115.5ms) commit transaction +Migrating to CreateSocialFrameworkRoutes (20160516122239) +  (0.1ms) begin transaction +  (0.7ms) CREATE TABLE "social_framework_routes" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar NOT NULL, "distance" integer NOT NULL, "mode_of_travel" varchar DEFAULT 'driving' NOT NULL, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL) +  (0.3ms) CREATE TABLE "social_framework_routes_users" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer NOT NULL, "route_id" integer NOT NULL)  +  (0.3ms) CREATE INDEX "index_social_framework_routes_users_on_user_id" ON "social_framework_routes_users" ("user_id") +  (0.2ms)  SELECT sql + FROM sqlite_master + WHERE name='index_social_framework_routes_users_on_user_id' AND type='index' + UNION ALL + SELECT sql + FROM sqlite_temp_master + WHERE name='index_social_framework_routes_users_on_user_id' AND type='index' + +  (0.4ms) CREATE INDEX "index_social_framework_routes_users_on_route_id" ON "social_framework_routes_users" ("route_id") +  (0.1ms)  SELECT sql + FROM sqlite_master + WHERE name='index_social_framework_routes_users_on_route_id' AND type='index' + UNION ALL + SELECT sql + FROM sqlite_temp_master + WHERE name='index_social_framework_routes_users_on_route_id' AND type='index' + +  (0.1ms) SELECT sql + FROM sqlite_master + WHERE name='index_social_framework_routes_users_on_user_id' AND type='index' + UNION ALL + SELECT sql + FROM sqlite_temp_master + WHERE name='index_social_framework_routes_users_on_user_id' AND type='index' + +  (0.2ms) CREATE UNIQUE INDEX "index_social_framework_routes_users_on_user_id_and_route_id" ON "social_framework_routes_users" ("user_id", "route_id") + SQL (0.1ms) INSERT INTO "schema_migrations" ("version") VALUES (?) [["version", "20160516122239"]] +  (125.2ms) commit transaction +Migrating to CreateSocialFrameworkLocations (20160516122649) +  (0.1ms) begin transaction +  (0.5ms) CREATE TABLE "social_framework_locations" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "route_id" integer NOT NULL, "latitude" decimal NOT NULL, "longitude" decimal NOT NULL, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)  + SQL (0.2ms) INSERT INTO "schema_migrations" ("version") VALUES (?) [["version", "20160516122649"]] +  (118.3ms) commit transaction + ActiveRecord::SchemaMigration Load (0.2ms) SELECT "schema_migrations".* FROM "schema_migrations" +  (0.3ms)  SELECT sql + FROM sqlite_master + WHERE name='index_social_framework_edges_on_destiny_id' AND type='index' + UNION ALL + SELECT sql + FROM sqlite_temp_master + WHERE name='index_social_framework_edges_on_destiny_id' AND type='index' + +  (0.2ms) SELECT sql + FROM sqlite_master + WHERE name='index_social_framework_edges_on_origin_id' AND type='index' + UNION ALL + SELECT sql + FROM sqlite_temp_master + WHERE name='index_social_framework_edges_on_origin_id' AND type='index' + +  (0.1ms)  SELECT sql + FROM sqlite_master + WHERE name='index_social_framework_events_schedules_on_event_id' AND type='index' + UNION ALL + SELECT sql + FROM sqlite_temp_master + WHERE name='index_social_framework_events_schedules_on_event_id' AND type='index' + +  (0.1ms) SELECT sql + FROM sqlite_master + WHERE name='index_social_framework_events_schedules_on_schedule_id' AND type='index' + UNION ALL + SELECT sql + FROM sqlite_temp_master + WHERE name='index_social_framework_events_schedules_on_schedule_id' AND type='index' + +  (0.1ms)  SELECT sql + FROM sqlite_master + WHERE name='index_social_framework_participant_events_on_schedule_id' AND type='index' + UNION ALL + SELECT sql + FROM sqlite_temp_master + WHERE name='index_social_framework_participant_events_on_schedule_id' AND type='index' + +  (0.1ms) SELECT sql + FROM sqlite_master + WHERE name='index_social_framework_participant_events_on_event_id' AND type='index' + UNION ALL + SELECT sql + FROM sqlite_temp_master + WHERE name='index_social_framework_participant_events_on_event_id' AND type='index' + +  (0.1ms)  SELECT sql + FROM sqlite_master + WHERE name='index_social_framework_routes_users_on_user_id_and_route_id' AND type='index' + UNION ALL + SELECT sql + FROM sqlite_temp_master + WHERE name='index_social_framework_routes_users_on_user_id_and_route_id' AND type='index' + +  (0.1ms) SELECT sql + FROM sqlite_master + WHERE name='index_social_framework_routes_users_on_route_id' AND type='index' + UNION ALL + SELECT sql + FROM sqlite_temp_master + WHERE name='index_social_framework_routes_users_on_route_id' AND type='index' + +  (0.1ms)  SELECT sql + FROM sqlite_master + WHERE name='index_social_framework_routes_users_on_user_id' AND type='index' + UNION ALL + SELECT sql + FROM sqlite_temp_master + WHERE name='index_social_framework_routes_users_on_user_id' AND type='index' + +  (0.1ms) SELECT sql + FROM sqlite_master + WHERE name='index_social_framework_schedules_on_user_id' AND type='index' + UNION ALL + SELECT sql + FROM sqlite_temp_master + WHERE name='index_social_framework_schedules_on_user_id' AND type='index' + +  (0.1ms)  SELECT sql + FROM sqlite_master + WHERE name='index_social_framework_users_on_reset_password_token' AND type='index' + UNION ALL + SELECT sql + FROM sqlite_temp_master + WHERE name='index_social_framework_users_on_reset_password_token' AND type='index' + +  (0.1ms) SELECT sql + FROM sqlite_master + WHERE name='index_social_framework_users_on_username' AND type='index' + UNION ALL + SELECT sql + FROM sqlite_temp_master + WHERE name='index_social_framework_users_on_username' AND type='index' + +  (0.1ms)  SELECT sql + FROM sqlite_master + WHERE name='index_social_framework_users_on_email' AND type='index' + UNION ALL + SELECT sql + FROM sqlite_temp_master + WHERE name='index_social_framework_users_on_email' AND type='index' + +  (0.1ms) begin transaction + SocialFramework::User Exists (0.1ms) SELECT 1 AS one FROM "social_framework_users" WHERE "social_framework_users"."email" = 'u1@email.com' LIMIT 1 + SQL (0.3ms) INSERT INTO "social_framework_users" ("username", "email", "encrypted_password", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?) [["username", "u1"], ["email", "u1@email.com"], ["encrypted_password", "$2a$10$Q.hvLPAseiuSnD9wflYTde2SCRDSSE4CX4yLgusvdAhBd/rqg/eCa"], ["created_at", "2016-06-08 16:49:57.731905"], ["updated_at", "2016-06-08 16:49:57.731905"]] +  (237.5ms) commit transaction + SocialFramework::Schedule Load (0.1ms) SELECT "social_framework_schedules".* FROM "social_framework_schedules" WHERE "social_framework_schedules"."user_id" = 1 LIMIT 1 +  (0.1ms) begin transaction + SQL (0.4ms) INSERT INTO "social_framework_schedules" ("user_id", "created_at", "updated_at") VALUES (?, ?, ?) [["user_id", 1], ["created_at", "2016-06-08 16:49:59.839460"], ["updated_at", "2016-06-08 16:49:59.839460"]] +  (134.0ms) commit transaction + SocialFramework::Schedule Load (0.3ms) SELECT "social_framework_schedules".* FROM "social_framework_schedules" WHERE "social_framework_schedules"."user_id" = 1 LIMIT 1 +  (120.0ms) CREATE TABLE "schema_migrations" ("version" varchar NOT NULL)  +  (0.2ms) select sqlite_version(*) +  (65.5ms) CREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version") + ActiveRecord::SchemaMigration Load (0.2ms) SELECT "schema_migrations".* FROM "schema_migrations" +Migrating to DeviseCreateSocialFrameworkUsers (20160129004111) +  (0.1ms) begin transaction +  (0.3ms) CREATE TABLE "social_framework_users" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "username" varchar NOT NULL, "email" varchar NOT NULL, "encrypted_password" varchar NOT NULL, "reset_password_token" varchar, "reset_password_sent_at" datetime, "remember_created_at" datetime, "sign_in_count" integer DEFAULT 0 NOT NULL, "current_sign_in_at" datetime, "last_sign_in_at" datetime, "current_sign_in_ip" varchar, "last_sign_in_ip" varchar, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL) +  (0.2ms) CREATE UNIQUE INDEX "index_social_framework_users_on_email" ON "social_framework_users" ("email") +  (0.1ms) SELECT sql + FROM sqlite_master + WHERE name='index_social_framework_users_on_email' AND type='index' + UNION ALL + SELECT sql + FROM sqlite_temp_master + WHERE name='index_social_framework_users_on_email' AND type='index' + +  (0.1ms) CREATE UNIQUE INDEX "index_social_framework_users_on_username" ON "social_framework_users" ("username") +  (0.1ms) SELECT sql + FROM sqlite_master + WHERE name='index_social_framework_users_on_username' AND type='index' + UNION ALL + SELECT sql + FROM sqlite_temp_master + WHERE name='index_social_framework_users_on_username' AND type='index' + +  (0.1ms)  SELECT sql + FROM sqlite_master + WHERE name='index_social_framework_users_on_email' AND type='index' + UNION ALL + SELECT sql + FROM sqlite_temp_master + WHERE name='index_social_framework_users_on_email' AND type='index' + +  (0.1ms) CREATE UNIQUE INDEX "index_social_framework_users_on_reset_password_token" ON "social_framework_users" ("reset_password_token") + SQL (0.1ms) INSERT INTO "schema_migrations" ("version") VALUES (?) [["version", "20160129004111"]] +  (61.9ms) commit transaction +Migrating to CreateSocialFrameworkEdges (20160226123409) +  (0.1ms) begin transaction +  (0.6ms) CREATE TABLE "social_framework_edges" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "origin_id" integer NOT NULL, "destiny_id" integer NOT NULL, "label" varchar NOT NULL, "bidirectional" boolean DEFAULT 't' NOT NULL, "active" boolean DEFAULT 'f' NOT NULL, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL) +  (0.3ms) CREATE INDEX "index_social_framework_edges_on_origin_id" ON "social_framework_edges" ("origin_id") +  (0.2ms) SELECT sql + FROM sqlite_master + WHERE name='index_social_framework_edges_on_origin_id' AND type='index' + UNION ALL + SELECT sql + FROM sqlite_temp_master + WHERE name='index_social_framework_edges_on_origin_id' AND type='index' + +  (0.3ms) CREATE INDEX "index_social_framework_edges_on_destiny_id" ON "social_framework_edges" ("destiny_id") + SQL (0.2ms) INSERT INTO "schema_migrations" ("version") VALUES (?) [["version", "20160226123409"]] +  (115.1ms) commit transaction +Migrating to CreateSocialFrameworkSchedules (20160406131316) +  (0.1ms) begin transaction +  (0.5ms) CREATE TABLE "social_framework_schedules" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer NOT NULL, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)  +  (0.5ms) CREATE UNIQUE INDEX "index_social_framework_schedules_on_user_id" ON "social_framework_schedules" ("user_id") + SQL (0.2ms) INSERT INTO "schema_migrations" ("version") VALUES (?) [["version", "20160406131316"]] +  (116.6ms) commit transaction +Migrating to CreateSocialFrameworkEvents (20160406133419) +  (0.1ms) begin transaction +  (0.6ms) CREATE TABLE "social_framework_events" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar NOT NULL, "description" varchar, "start" datetime, "finish" datetime, "particular" boolean DEFAULT 'f', "route_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL) + SQL (0.2ms) INSERT INTO "schema_migrations" ("version") VALUES (?) [["version", "20160406133419"]] +  (118.0ms) commit transaction +Migrating to CreateSocialFrameworkEventsSchedules (20160406134250) +  (0.1ms) begin transaction +  (0.5ms) CREATE TABLE "social_framework_events_schedules" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "schedule_id" integer NOT NULL, "event_id" integer NOT NULL) +  (0.4ms) CREATE INDEX "index_social_framework_events_schedules_on_schedule_id" ON "social_framework_events_schedules" ("schedule_id") +  (0.2ms) SELECT sql + FROM sqlite_master + WHERE name='index_social_framework_events_schedules_on_schedule_id' AND type='index' + UNION ALL + SELECT sql + FROM sqlite_temp_master + WHERE name='index_social_framework_events_schedules_on_schedule_id' AND type='index' + +  (0.3ms) CREATE INDEX "index_social_framework_events_schedules_on_event_id" ON "social_framework_events_schedules" ("event_id") + SQL (0.2ms) INSERT INTO "schema_migrations" ("version") VALUES (?) [["version", "20160406134250"]] +  (116.1ms) commit transaction +Migrating to CreateSocialFrameworkParticipantEvents (20160406165523) +  (0.1ms) begin transaction +  (0.3ms) CREATE TABLE "social_framework_participant_events" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "event_id" integer NOT NULL, "schedule_id" integer NOT NULL, "confirmed" boolean DEFAULT 'f', "role" varchar DEFAULT 'participant')  +  (0.1ms) CREATE INDEX "index_social_framework_participant_events_on_event_id" ON "social_framework_participant_events" ("event_id") +  (0.1ms)  SELECT sql + FROM sqlite_master + WHERE name='index_social_framework_participant_events_on_event_id' AND type='index' + UNION ALL + SELECT sql + FROM sqlite_temp_master + WHERE name='index_social_framework_participant_events_on_event_id' AND type='index' + +  (0.2ms) CREATE INDEX "index_social_framework_participant_events_on_schedule_id" ON "social_framework_participant_events" ("schedule_id") + SQL (0.1ms) INSERT INTO "schema_migrations" ("version") VALUES (?) [["version", "20160406165523"]] +  (286.9ms) commit transaction +Migrating to CreateSocialFrameworkRoutes (20160516122239) +  (0.1ms) begin transaction +  (0.7ms) CREATE TABLE "social_framework_routes" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar NOT NULL, "distance" integer NOT NULL, "mode_of_travel" varchar DEFAULT 'driving' NOT NULL, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL) +  (0.3ms) CREATE TABLE "social_framework_routes_users" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer NOT NULL, "route_id" integer NOT NULL)  +  (0.3ms) CREATE INDEX "index_social_framework_routes_users_on_user_id" ON "social_framework_routes_users" ("user_id") +  (0.2ms)  SELECT sql + FROM sqlite_master + WHERE name='index_social_framework_routes_users_on_user_id' AND type='index' + UNION ALL + SELECT sql + FROM sqlite_temp_master + WHERE name='index_social_framework_routes_users_on_user_id' AND type='index' + +  (0.3ms) CREATE INDEX "index_social_framework_routes_users_on_route_id" ON "social_framework_routes_users" ("route_id") +  (0.2ms)  SELECT sql + FROM sqlite_master + WHERE name='index_social_framework_routes_users_on_route_id' AND type='index' + UNION ALL + SELECT sql + FROM sqlite_temp_master + WHERE name='index_social_framework_routes_users_on_route_id' AND type='index' + +  (0.2ms) SELECT sql + FROM sqlite_master + WHERE name='index_social_framework_routes_users_on_user_id' AND type='index' + UNION ALL + SELECT sql + FROM sqlite_temp_master + WHERE name='index_social_framework_routes_users_on_user_id' AND type='index' + +  (0.4ms) CREATE UNIQUE INDEX "index_social_framework_routes_users_on_user_id_and_route_id" ON "social_framework_routes_users" ("user_id", "route_id") + SQL (0.2ms) INSERT INTO "schema_migrations" ("version") VALUES (?) [["version", "20160516122239"]] +  (134.6ms) commit transaction +Migrating to CreateSocialFrameworkLocations (20160516122649) +  (0.1ms) begin transaction +  (0.5ms) CREATE TABLE "social_framework_locations" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "route_id" integer NOT NULL, "latitude" decimal NOT NULL, "longitude" decimal NOT NULL, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)  + SQL (0.2ms) INSERT INTO "schema_migrations" ("version") VALUES (?) [["version", "20160516122649"]] +  (118.4ms) commit transaction + ActiveRecord::SchemaMigration Load (0.2ms) SELECT "schema_migrations".* FROM "schema_migrations" +  (0.2ms)  SELECT sql + FROM sqlite_master + WHERE name='index_social_framework_edges_on_destiny_id' AND type='index' + UNION ALL + SELECT sql + FROM sqlite_temp_master + WHERE name='index_social_framework_edges_on_destiny_id' AND type='index' + +  (0.3ms) SELECT sql + FROM sqlite_master + WHERE name='index_social_framework_edges_on_origin_id' AND type='index' + UNION ALL + SELECT sql + FROM sqlite_temp_master + WHERE name='index_social_framework_edges_on_origin_id' AND type='index' + +  (0.2ms)  SELECT sql + FROM sqlite_master + WHERE name='index_social_framework_events_schedules_on_event_id' AND type='index' + UNION ALL + SELECT sql + FROM sqlite_temp_master + WHERE name='index_social_framework_events_schedules_on_event_id' AND type='index' + +  (0.2ms) SELECT sql + FROM sqlite_master + WHERE name='index_social_framework_events_schedules_on_schedule_id' AND type='index' + UNION ALL + SELECT sql + FROM sqlite_temp_master + WHERE name='index_social_framework_events_schedules_on_schedule_id' AND type='index' + +  (0.2ms)  SELECT sql + FROM sqlite_master + WHERE name='index_social_framework_participant_events_on_schedule_id' AND type='index' + UNION ALL + SELECT sql + FROM sqlite_temp_master + WHERE name='index_social_framework_participant_events_on_schedule_id' AND type='index' + +  (0.2ms) SELECT sql + FROM sqlite_master + WHERE name='index_social_framework_participant_events_on_event_id' AND type='index' + UNION ALL + SELECT sql + FROM sqlite_temp_master + WHERE name='index_social_framework_participant_events_on_event_id' AND type='index' + +  (0.1ms)  SELECT sql + FROM sqlite_master + WHERE name='index_social_framework_routes_users_on_user_id_and_route_id' AND type='index' + UNION ALL + SELECT sql + FROM sqlite_temp_master + WHERE name='index_social_framework_routes_users_on_user_id_and_route_id' AND type='index' + +  (0.1ms) SELECT sql + FROM sqlite_master + WHERE name='index_social_framework_routes_users_on_route_id' AND type='index' + UNION ALL + SELECT sql + FROM sqlite_temp_master + WHERE name='index_social_framework_routes_users_on_route_id' AND type='index' + +  (0.1ms)  SELECT sql + FROM sqlite_master + WHERE name='index_social_framework_routes_users_on_user_id' AND type='index' + UNION ALL + SELECT sql + FROM sqlite_temp_master + WHERE name='index_social_framework_routes_users_on_user_id' AND type='index' + +  (0.1ms) SELECT sql + FROM sqlite_master + WHERE name='index_social_framework_schedules_on_user_id' AND type='index' + UNION ALL + SELECT sql + FROM sqlite_temp_master + WHERE name='index_social_framework_schedules_on_user_id' AND type='index' + +  (0.1ms)  SELECT sql + FROM sqlite_master + WHERE name='index_social_framework_users_on_reset_password_token' AND type='index' + UNION ALL + SELECT sql + FROM sqlite_temp_master + WHERE name='index_social_framework_users_on_reset_password_token' AND type='index' + +  (0.1ms) SELECT sql + FROM sqlite_master + WHERE name='index_social_framework_users_on_username' AND type='index' + UNION ALL + SELECT sql + FROM sqlite_temp_master + WHERE name='index_social_framework_users_on_username' AND type='index' + +  (0.1ms)  SELECT sql + FROM sqlite_master + WHERE name='index_social_framework_users_on_email' AND type='index' + UNION ALL + SELECT sql + FROM sqlite_temp_master + WHERE name='index_social_framework_users_on_email' AND type='index' + +  (0.1ms) begin transaction + SocialFramework::User Exists (0.1ms) SELECT 1 AS one FROM "social_framework_users" WHERE "social_framework_users"."email" = 'u1@email.com' LIMIT 1 + SQL (0.3ms) INSERT INTO "social_framework_users" ("username", "email", "encrypted_password", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?) [["username", "u1"], ["email", "u1@email.com"], ["encrypted_password", "$2a$10$WqziORFOy2s6980KDgiSFOgowru1oyJz48do7z5/C/ACDKujA2Jxa"], ["created_at", "2016-06-08 16:53:10.969454"], ["updated_at", "2016-06-08 16:53:10.969454"]] +  (92.7ms) commit transaction + SocialFramework::Schedule Load (0.1ms) SELECT "social_framework_schedules".* FROM "social_framework_schedules" WHERE "social_framework_schedules"."user_type" = 'SocialFramework::User' AND "social_framework_schedules"."user_id" = 1 LIMIT 1 + SocialFramework::User Load (0.2ms) SELECT "social_framework_users".* FROM "social_framework_users" WHERE "social_framework_users"."id" = ? LIMIT 1 [["id", 1]] + SocialFramework::Schedule Load (0.2ms) SELECT "social_framework_schedules".* FROM "social_framework_schedules" WHERE "social_framework_schedules"."user_id" = 1 LIMIT 1 +  (0.1ms) begin transaction + SQL (0.3ms) INSERT INTO "social_framework_schedules" ("user_id", "created_at", "updated_at") VALUES (?, ?, ?) [["user_id", 1], ["created_at", "2016-06-08 16:58:01.134568"], ["updated_at", "2016-06-08 16:58:01.134568"]] +  (117.4ms) commit transaction + SocialFramework::Schedule Load (0.5ms) SELECT "social_framework_schedules".* FROM "social_framework_schedules" WHERE "social_framework_schedules"."user_id" = 1 LIMIT 1 + SocialFramework::Schedule Load (0.4ms) SELECT "social_framework_schedules".* FROM "social_framework_schedules" WHERE "social_framework_schedules"."user_id" = 1 LIMIT 1 + SocialFramework::Schedule Load (2.6ms) SELECT "social_framework_schedules".* FROM "social_framework_schedules" WHERE "social_framework_schedules"."user_id" = 1 LIMIT 1 + SocialFramework::Schedule Load (2.9ms) SELECT "social_framework_schedules".* FROM "social_framework_schedules" WHERE "social_framework_schedules"."user_id" = 1 LIMIT 1 + SocialFramework::User Load (0.3ms) SELECT "social_framework_users".* FROM "social_framework_users" WHERE "social_framework_users"."id" = ? LIMIT 1 [["id", 1]] + SocialFramework::User Load (0.2ms) SELECT "social_framework_users".* FROM "social_framework_users" WHERE "social_framework_users"."id" = ? LIMIT 1 [["id", 1]] +  (93.2ms) CREATE TABLE "schema_migrations" ("version" varchar NOT NULL)  +  (0.2ms) select sqlite_version(*) +  (109.8ms) CREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version") + ActiveRecord::SchemaMigration Load (0.1ms) SELECT "schema_migrations".* FROM "schema_migrations" +Migrating to DeviseCreateSocialFrameworkUsers (20160129004111) +  (0.1ms) begin transaction +  (0.4ms) CREATE TABLE "social_framework_users" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "username" varchar NOT NULL, "email" varchar NOT NULL, "encrypted_password" varchar NOT NULL, "reset_password_token" varchar, "reset_password_sent_at" datetime, "remember_created_at" datetime, "sign_in_count" integer DEFAULT 0 NOT NULL, "current_sign_in_at" datetime, "last_sign_in_at" datetime, "current_sign_in_ip" varchar, "last_sign_in_ip" varchar, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL) +  (0.2ms) CREATE UNIQUE INDEX "index_social_framework_users_on_email" ON "social_framework_users" ("email") +  (0.1ms) SELECT sql + FROM sqlite_master + WHERE name='index_social_framework_users_on_email' AND type='index' + UNION ALL + SELECT sql + FROM sqlite_temp_master + WHERE name='index_social_framework_users_on_email' AND type='index' + +  (0.1ms) CREATE UNIQUE INDEX "index_social_framework_users_on_username" ON "social_framework_users" ("username") +  (0.1ms) SELECT sql + FROM sqlite_master + WHERE name='index_social_framework_users_on_username' AND type='index' + UNION ALL + SELECT sql + FROM sqlite_temp_master + WHERE name='index_social_framework_users_on_username' AND type='index' + +  (0.1ms)  SELECT sql + FROM sqlite_master + WHERE name='index_social_framework_users_on_email' AND type='index' + UNION ALL + SELECT sql + FROM sqlite_temp_master + WHERE name='index_social_framework_users_on_email' AND type='index' + +  (0.1ms) CREATE UNIQUE INDEX "index_social_framework_users_on_reset_password_token" ON "social_framework_users" ("reset_password_token") + SQL (0.1ms) INSERT INTO "schema_migrations" ("version") VALUES (?) [["version", "20160129004111"]] +  (84.5ms) commit transaction +Migrating to CreateSocialFrameworkEdges (20160226123409) +  (0.1ms) begin transaction +  (0.6ms) CREATE TABLE "social_framework_edges" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "origin_id" integer NOT NULL, "destiny_id" integer NOT NULL, "label" varchar NOT NULL, "bidirectional" boolean DEFAULT 't' NOT NULL, "active" boolean DEFAULT 'f' NOT NULL, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL) +  (0.3ms) CREATE INDEX "index_social_framework_edges_on_origin_id" ON "social_framework_edges" ("origin_id") +  (0.2ms) SELECT sql + FROM sqlite_master + WHERE name='index_social_framework_edges_on_origin_id' AND type='index' + UNION ALL + SELECT sql + FROM sqlite_temp_master + WHERE name='index_social_framework_edges_on_origin_id' AND type='index' + +  (0.3ms) CREATE INDEX "index_social_framework_edges_on_destiny_id" ON "social_framework_edges" ("destiny_id") + SQL (0.2ms) INSERT INTO "schema_migrations" ("version") VALUES (?) [["version", "20160226123409"]] +  (93.0ms) commit transaction +Migrating to CreateSocialFrameworkSchedules (20160406131316) +  (0.1ms) begin transaction +  (0.5ms) CREATE TABLE "social_framework_schedules" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer NOT NULL, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)  +  (0.5ms) CREATE UNIQUE INDEX "index_social_framework_schedules_on_user_id" ON "social_framework_schedules" ("user_id") + SQL (0.2ms) INSERT INTO "schema_migrations" ("version") VALUES (?) [["version", "20160406131316"]] +  (272.5ms) commit transaction +Migrating to CreateSocialFrameworkEvents (20160406133419) +  (0.1ms) begin transaction +  (0.6ms) CREATE TABLE "social_framework_events" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar NOT NULL, "description" varchar, "start" datetime, "finish" datetime, "particular" boolean DEFAULT 'f', "route_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL) + SQL (0.2ms) INSERT INTO "schema_migrations" ("version") VALUES (?) [["version", "20160406133419"]] +  (160.6ms) commit transaction +Migrating to CreateSocialFrameworkEventsSchedules (20160406134250) +  (0.2ms) begin transaction +  (0.5ms) CREATE TABLE "social_framework_events_schedules" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "schedule_id" integer NOT NULL, "event_id" integer NOT NULL) +  (0.4ms) CREATE INDEX "index_social_framework_events_schedules_on_schedule_id" ON "social_framework_events_schedules" ("schedule_id") +  (0.2ms) SELECT sql + FROM sqlite_master + WHERE name='index_social_framework_events_schedules_on_schedule_id' AND type='index' + UNION ALL + SELECT sql + FROM sqlite_temp_master + WHERE name='index_social_framework_events_schedules_on_schedule_id' AND type='index' + +  (0.3ms) CREATE INDEX "index_social_framework_events_schedules_on_event_id" ON "social_framework_events_schedules" ("event_id") + SQL (0.2ms) INSERT INTO "schema_migrations" ("version") VALUES (?) [["version", "20160406134250"]] +  (128.3ms) commit transaction +Migrating to CreateSocialFrameworkParticipantEvents (20160406165523) +  (0.1ms) begin transaction +  (0.3ms) CREATE TABLE "social_framework_participant_events" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "event_id" integer NOT NULL, "schedule_id" integer NOT NULL, "confirmed" boolean DEFAULT 'f', "role" varchar DEFAULT 'participant')  +  (0.1ms) CREATE INDEX "index_social_framework_participant_events_on_event_id" ON "social_framework_participant_events" ("event_id") +  (0.1ms)  SELECT sql + FROM sqlite_master + WHERE name='index_social_framework_participant_events_on_event_id' AND type='index' + UNION ALL + SELECT sql + FROM sqlite_temp_master + WHERE name='index_social_framework_participant_events_on_event_id' AND type='index' + +  (0.2ms) CREATE INDEX "index_social_framework_participant_events_on_schedule_id" ON "social_framework_participant_events" ("schedule_id") + SQL (0.1ms) INSERT INTO "schema_migrations" ("version") VALUES (?) [["version", "20160406165523"]] +  (141.6ms) commit transaction +Migrating to CreateSocialFrameworkRoutes (20160516122239) +  (0.2ms) begin transaction +  (0.6ms) CREATE TABLE "social_framework_routes" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar NOT NULL, "distance" integer NOT NULL, "mode_of_travel" varchar DEFAULT 'driving' NOT NULL, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL) +  (0.3ms) CREATE TABLE "social_framework_routes_users" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer NOT NULL, "route_id" integer NOT NULL)  +  (0.1ms) CREATE INDEX "index_social_framework_routes_users_on_user_id" ON "social_framework_routes_users" ("user_id") +  (0.1ms)  SELECT sql + FROM sqlite_master + WHERE name='index_social_framework_routes_users_on_user_id' AND type='index' + UNION ALL + SELECT sql + FROM sqlite_temp_master + WHERE name='index_social_framework_routes_users_on_user_id' AND type='index' + +  (0.1ms) CREATE INDEX "index_social_framework_routes_users_on_route_id" ON "social_framework_routes_users" ("route_id") +  (0.1ms)  SELECT sql + FROM sqlite_master + WHERE name='index_social_framework_routes_users_on_route_id' AND type='index' + UNION ALL + SELECT sql + FROM sqlite_temp_master + WHERE name='index_social_framework_routes_users_on_route_id' AND type='index' + +  (0.1ms) SELECT sql + FROM sqlite_master + WHERE name='index_social_framework_routes_users_on_user_id' AND type='index' + UNION ALL + SELECT sql + FROM sqlite_temp_master + WHERE name='index_social_framework_routes_users_on_user_id' AND type='index' + +  (0.2ms) CREATE UNIQUE INDEX "index_social_framework_routes_users_on_user_id_and_route_id" ON "social_framework_routes_users" ("user_id", "route_id") + SQL (0.1ms) INSERT INTO "schema_migrations" ("version") VALUES (?) [["version", "20160516122239"]] +  (115.5ms) commit transaction +Migrating to CreateSocialFrameworkLocations (20160516122649) +  (0.1ms) begin transaction +  (0.5ms) CREATE TABLE "social_framework_locations" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "route_id" integer NOT NULL, "latitude" decimal NOT NULL, "longitude" decimal NOT NULL, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)  + SQL (0.2ms) INSERT INTO "schema_migrations" ("version") VALUES (?) [["version", "20160516122649"]] +  (118.1ms) commit transaction + ActiveRecord::SchemaMigration Load (0.2ms) SELECT "schema_migrations".* FROM "schema_migrations" +  (0.2ms)  SELECT sql + FROM sqlite_master + WHERE name='index_social_framework_edges_on_destiny_id' AND type='index' + UNION ALL + SELECT sql + FROM sqlite_temp_master + WHERE name='index_social_framework_edges_on_destiny_id' AND type='index' + +  (0.1ms) SELECT sql + FROM sqlite_master + WHERE name='index_social_framework_edges_on_origin_id' AND type='index' + UNION ALL + SELECT sql + FROM sqlite_temp_master + WHERE name='index_social_framework_edges_on_origin_id' AND type='index' + +  (0.1ms)  SELECT sql + FROM sqlite_master + WHERE name='index_social_framework_events_schedules_on_event_id' AND type='index' + UNION ALL + SELECT sql + FROM sqlite_temp_master + WHERE name='index_social_framework_events_schedules_on_event_id' AND type='index' + +  (0.1ms) SELECT sql + FROM sqlite_master + WHERE name='index_social_framework_events_schedules_on_schedule_id' AND type='index' + UNION ALL + SELECT sql + FROM sqlite_temp_master + WHERE name='index_social_framework_events_schedules_on_schedule_id' AND type='index' + +  (0.1ms)  SELECT sql + FROM sqlite_master + WHERE name='index_social_framework_participant_events_on_schedule_id' AND type='index' + UNION ALL + SELECT sql + FROM sqlite_temp_master + WHERE name='index_social_framework_participant_events_on_schedule_id' AND type='index' + +  (0.1ms) SELECT sql + FROM sqlite_master + WHERE name='index_social_framework_participant_events_on_event_id' AND type='index' + UNION ALL + SELECT sql + FROM sqlite_temp_master + WHERE name='index_social_framework_participant_events_on_event_id' AND type='index' + +  (0.1ms)  SELECT sql + FROM sqlite_master + WHERE name='index_social_framework_routes_users_on_user_id_and_route_id' AND type='index' + UNION ALL + SELECT sql + FROM sqlite_temp_master + WHERE name='index_social_framework_routes_users_on_user_id_and_route_id' AND type='index' + +  (0.1ms) SELECT sql + FROM sqlite_master + WHERE name='index_social_framework_routes_users_on_route_id' AND type='index' + UNION ALL + SELECT sql + FROM sqlite_temp_master + WHERE name='index_social_framework_routes_users_on_route_id' AND type='index' + +  (0.1ms)  SELECT sql + FROM sqlite_master + WHERE name='index_social_framework_routes_users_on_user_id' AND type='index' + UNION ALL + SELECT sql + FROM sqlite_temp_master + WHERE name='index_social_framework_routes_users_on_user_id' AND type='index' + +  (0.1ms) SELECT sql + FROM sqlite_master + WHERE name='index_social_framework_schedules_on_user_id' AND type='index' + UNION ALL + SELECT sql + FROM sqlite_temp_master + WHERE name='index_social_framework_schedules_on_user_id' AND type='index' + +  (0.1ms)  SELECT sql + FROM sqlite_master + WHERE name='index_social_framework_users_on_reset_password_token' AND type='index' + UNION ALL + SELECT sql + FROM sqlite_temp_master + WHERE name='index_social_framework_users_on_reset_password_token' AND type='index' + +  (0.1ms) SELECT sql + FROM sqlite_master + WHERE name='index_social_framework_users_on_username' AND type='index' + UNION ALL + SELECT sql + FROM sqlite_temp_master + WHERE name='index_social_framework_users_on_username' AND type='index' + +  (0.1ms)  SELECT sql + FROM sqlite_master + WHERE name='index_social_framework_users_on_email' AND type='index' + UNION ALL + SELECT sql + FROM sqlite_temp_master + WHERE name='index_social_framework_users_on_email' AND type='index' + +  (0.1ms) begin transaction + SocialFramework::User Exists (0.1ms) SELECT 1 AS one FROM "social_framework_users" WHERE "social_framework_users"."email" = 'u1@email.com' LIMIT 1 + SQL (0.3ms) INSERT INTO "social_framework_users" ("username", "email", "encrypted_password", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?) [["username", "u1"], ["email", "u1@email.com"], ["encrypted_password", "$2a$10$AUaQhyPpudOu/bEdnz9egu5.OReRVymJ./mP3xSphyLed5ujLiIke"], ["created_at", "2016-06-08 17:02:06.138573"], ["updated_at", "2016-06-08 17:02:06.138573"]] +  (112.0ms) commit transaction + SocialFramework::Schedule Load (0.2ms) SELECT "social_framework_schedules".* FROM "social_framework_schedules" WHERE "social_framework_schedules"."user_id" = 1 LIMIT 1 +  (0.1ms) begin transaction + SQL (0.2ms) INSERT INTO "social_framework_schedules" ("user_id", "created_at", "updated_at") VALUES (?, ?, ?) [["user_id", 1], ["created_at", "2016-06-08 17:02:08.940419"], ["updated_at", "2016-06-08 17:02:08.940419"]] +  (124.3ms) commit transaction +  (155.0ms) CREATE TABLE "schema_migrations" ("version" varchar NOT NULL)  +  (0.2ms) select sqlite_version(*) +  (98.9ms) CREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version") + ActiveRecord::SchemaMigration Load (0.2ms) SELECT "schema_migrations".* FROM "schema_migrations" +Migrating to DeviseCreateSocialFrameworkUsers (20160129004111) +  (0.1ms) begin transaction +  (0.8ms) CREATE TABLE "social_framework_users" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "username" varchar NOT NULL, "email" varchar NOT NULL, "encrypted_password" varchar NOT NULL, "reset_password_token" varchar, "reset_password_sent_at" datetime, "remember_created_at" datetime, "sign_in_count" integer DEFAULT 0 NOT NULL, "current_sign_in_at" datetime, "last_sign_in_at" datetime, "current_sign_in_ip" varchar, "last_sign_in_ip" varchar, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL) +  (0.5ms) CREATE UNIQUE INDEX "index_social_framework_users_on_email" ON "social_framework_users" ("email") +  (0.2ms) SELECT sql + FROM sqlite_master + WHERE name='index_social_framework_users_on_email' AND type='index' + UNION ALL + SELECT sql + FROM sqlite_temp_master + WHERE name='index_social_framework_users_on_email' AND type='index' + +  (0.3ms) CREATE UNIQUE INDEX "index_social_framework_users_on_username" ON "social_framework_users" ("username") +  (0.2ms) SELECT sql + FROM sqlite_master + WHERE name='index_social_framework_users_on_username' AND type='index' + UNION ALL + SELECT sql + FROM sqlite_temp_master + WHERE name='index_social_framework_users_on_username' AND type='index' + +  (0.1ms)  SELECT sql + FROM sqlite_master + WHERE name='index_social_framework_users_on_email' AND type='index' + UNION ALL + SELECT sql + FROM sqlite_temp_master + WHERE name='index_social_framework_users_on_email' AND type='index' + +  (0.3ms) CREATE UNIQUE INDEX "index_social_framework_users_on_reset_password_token" ON "social_framework_users" ("reset_password_token") + SQL (0.1ms) INSERT INTO "schema_migrations" ("version") VALUES (?) [["version", "20160129004111"]] +  (85.4ms) commit transaction +Migrating to CreateSocialFrameworkEdges (20160226123409) +  (0.1ms) begin transaction +  (0.3ms) CREATE TABLE "social_framework_edges" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "origin_id" integer NOT NULL, "destiny_id" integer NOT NULL, "label" varchar NOT NULL, "bidirectional" boolean DEFAULT 't' NOT NULL, "active" boolean DEFAULT 'f' NOT NULL, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL) +  (0.1ms) CREATE INDEX "index_social_framework_edges_on_origin_id" ON "social_framework_edges" ("origin_id") +  (0.2ms) SELECT sql + FROM sqlite_master + WHERE name='index_social_framework_edges_on_origin_id' AND type='index' + UNION ALL + SELECT sql + FROM sqlite_temp_master + WHERE name='index_social_framework_edges_on_origin_id' AND type='index' + +  (0.2ms) CREATE INDEX "index_social_framework_edges_on_destiny_id" ON "social_framework_edges" ("destiny_id") + SQL (0.2ms) INSERT INTO "schema_migrations" ("version") VALUES (?) [["version", "20160226123409"]] +  (73.6ms) commit transaction +Migrating to CreateSocialFrameworkSchedules (20160406131316) +  (0.1ms) begin transaction +  (0.6ms) CREATE TABLE "social_framework_schedules" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer NOT NULL, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)  +  (0.4ms) CREATE UNIQUE INDEX "index_social_framework_schedules_on_user_id" ON "social_framework_schedules" ("user_id") + SQL (0.2ms) INSERT INTO "schema_migrations" ("version") VALUES (?) [["version", "20160406131316"]] +  (95.0ms) commit transaction +Migrating to CreateSocialFrameworkEvents (20160406133419) +  (0.1ms) begin transaction +  (0.6ms) CREATE TABLE "social_framework_events" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar NOT NULL, "description" varchar, "start" datetime, "finish" datetime, "particular" boolean DEFAULT 'f', "route_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL) + SQL (0.2ms) INSERT INTO "schema_migrations" ("version") VALUES (?) [["version", "20160406133419"]] +  (96.0ms) commit transaction +Migrating to CreateSocialFrameworkEventsSchedules (20160406134250) +  (0.1ms) begin transaction +  (0.5ms) CREATE TABLE "social_framework_events_schedules" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "schedule_id" integer NOT NULL, "event_id" integer NOT NULL) +  (0.4ms) CREATE INDEX "index_social_framework_events_schedules_on_schedule_id" ON "social_framework_events_schedules" ("schedule_id") +  (0.2ms) SELECT sql + FROM sqlite_master + WHERE name='index_social_framework_events_schedules_on_schedule_id' AND type='index' + UNION ALL + SELECT sql + FROM sqlite_temp_master + WHERE name='index_social_framework_events_schedules_on_schedule_id' AND type='index' + +  (0.4ms) CREATE INDEX "index_social_framework_events_schedules_on_event_id" ON "social_framework_events_schedules" ("event_id") + SQL (0.3ms) INSERT INTO "schema_migrations" ("version") VALUES (?) [["version", "20160406134250"]] +  (137.7ms) commit transaction +Migrating to CreateSocialFrameworkParticipantEvents (20160406165523) +  (0.1ms) begin transaction +  (0.7ms) CREATE TABLE "social_framework_participant_events" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "event_id" integer NOT NULL, "schedule_id" integer NOT NULL, "confirmed" boolean DEFAULT 'f', "role" varchar DEFAULT 'participant')  +  (0.3ms) CREATE INDEX "index_social_framework_participant_events_on_event_id" ON "social_framework_participant_events" ("event_id") +  (0.2ms)  SELECT sql + FROM sqlite_master + WHERE name='index_social_framework_participant_events_on_event_id' AND type='index' + UNION ALL + SELECT sql + FROM sqlite_temp_master + WHERE name='index_social_framework_participant_events_on_event_id' AND type='index' + +  (0.4ms) CREATE INDEX "index_social_framework_participant_events_on_schedule_id" ON "social_framework_participant_events" ("schedule_id") + SQL (0.1ms) INSERT INTO "schema_migrations" ("version") VALUES (?) [["version", "20160406165523"]] +  (115.3ms) commit transaction +Migrating to CreateSocialFrameworkRoutes (20160516122239) +  (0.1ms) begin transaction +  (0.6ms) CREATE TABLE "social_framework_routes" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar NOT NULL, "distance" integer NOT NULL, "mode_of_travel" varchar DEFAULT 'driving' NOT NULL, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL) +  (0.3ms) CREATE TABLE "social_framework_routes_users" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer NOT NULL, "route_id" integer NOT NULL)  +  (0.3ms) CREATE INDEX "index_social_framework_routes_users_on_user_id" ON "social_framework_routes_users" ("user_id") +  (0.2ms)  SELECT sql + FROM sqlite_master + WHERE name='index_social_framework_routes_users_on_user_id' AND type='index' + UNION ALL + SELECT sql + FROM sqlite_temp_master + WHERE name='index_social_framework_routes_users_on_user_id' AND type='index' + +  (0.3ms) CREATE INDEX "index_social_framework_routes_users_on_route_id" ON "social_framework_routes_users" ("route_id") +  (0.1ms)  SELECT sql + FROM sqlite_master + WHERE name='index_social_framework_routes_users_on_route_id' AND type='index' + UNION ALL + SELECT sql + FROM sqlite_temp_master + WHERE name='index_social_framework_routes_users_on_route_id' AND type='index' + +  (0.2ms) SELECT sql + FROM sqlite_master + WHERE name='index_social_framework_routes_users_on_user_id' AND type='index' + UNION ALL + SELECT sql + FROM sqlite_temp_master + WHERE name='index_social_framework_routes_users_on_user_id' AND type='index' + +  (0.2ms) CREATE UNIQUE INDEX "index_social_framework_routes_users_on_user_id_and_route_id" ON "social_framework_routes_users" ("user_id", "route_id") + SQL (0.1ms) INSERT INTO "schema_migrations" ("version") VALUES (?) [["version", "20160516122239"]] +  (157.4ms) commit transaction +Migrating to CreateSocialFrameworkLocations (20160516122649) +  (0.1ms) begin transaction +  (0.5ms) CREATE TABLE "social_framework_locations" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "route_id" integer NOT NULL, "latitude" decimal NOT NULL, "longitude" decimal NOT NULL, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)  + SQL (0.2ms) INSERT INTO "schema_migrations" ("version") VALUES (?) [["version", "20160516122649"]] +  (107.5ms) commit transaction + ActiveRecord::SchemaMigration Load (0.2ms) SELECT "schema_migrations".* FROM "schema_migrations" +  (0.2ms)  SELECT sql + FROM sqlite_master + WHERE name='index_social_framework_edges_on_destiny_id' AND type='index' + UNION ALL + SELECT sql + FROM sqlite_temp_master + WHERE name='index_social_framework_edges_on_destiny_id' AND type='index' + +  (0.2ms) SELECT sql + FROM sqlite_master + WHERE name='index_social_framework_edges_on_origin_id' AND type='index' + UNION ALL + SELECT sql + FROM sqlite_temp_master + WHERE name='index_social_framework_edges_on_origin_id' AND type='index' + +  (0.2ms)  SELECT sql + FROM sqlite_master + WHERE name='index_social_framework_events_schedules_on_event_id' AND type='index' + UNION ALL + SELECT sql + FROM sqlite_temp_master + WHERE name='index_social_framework_events_schedules_on_event_id' AND type='index' + +  (0.1ms) SELECT sql + FROM sqlite_master + WHERE name='index_social_framework_events_schedules_on_schedule_id' AND type='index' + UNION ALL + SELECT sql + FROM sqlite_temp_master + WHERE name='index_social_framework_events_schedules_on_schedule_id' AND type='index' + +  (0.3ms)  SELECT sql + FROM sqlite_master + WHERE name='index_social_framework_participant_events_on_schedule_id' AND type='index' + UNION ALL + SELECT sql + FROM sqlite_temp_master + WHERE name='index_social_framework_participant_events_on_schedule_id' AND type='index' + +  (0.2ms) SELECT sql + FROM sqlite_master + WHERE name='index_social_framework_participant_events_on_event_id' AND type='index' + UNION ALL + SELECT sql + FROM sqlite_temp_master + WHERE name='index_social_framework_participant_events_on_event_id' AND type='index' + +  (0.1ms)  SELECT sql + FROM sqlite_master + WHERE name='index_social_framework_routes_users_on_user_id_and_route_id' AND type='index' + UNION ALL + SELECT sql + FROM sqlite_temp_master + WHERE name='index_social_framework_routes_users_on_user_id_and_route_id' AND type='index' + +  (0.1ms) SELECT sql + FROM sqlite_master + WHERE name='index_social_framework_routes_users_on_route_id' AND type='index' + UNION ALL + SELECT sql + FROM sqlite_temp_master + WHERE name='index_social_framework_routes_users_on_route_id' AND type='index' + +  (0.1ms)  SELECT sql + FROM sqlite_master + WHERE name='index_social_framework_routes_users_on_user_id' AND type='index' + UNION ALL + SELECT sql + FROM sqlite_temp_master + WHERE name='index_social_framework_routes_users_on_user_id' AND type='index' + +  (0.1ms) SELECT sql + FROM sqlite_master + WHERE name='index_social_framework_schedules_on_user_id' AND type='index' + UNION ALL + SELECT sql + FROM sqlite_temp_master + WHERE name='index_social_framework_schedules_on_user_id' AND type='index' + +  (0.1ms)  SELECT sql + FROM sqlite_master + WHERE name='index_social_framework_users_on_reset_password_token' AND type='index' + UNION ALL + SELECT sql + FROM sqlite_temp_master + WHERE name='index_social_framework_users_on_reset_password_token' AND type='index' + +  (0.1ms) SELECT sql + FROM sqlite_master + WHERE name='index_social_framework_users_on_username' AND type='index' + UNION ALL + SELECT sql + FROM sqlite_temp_master + WHERE name='index_social_framework_users_on_username' AND type='index' + +  (0.1ms)  SELECT sql + FROM sqlite_master + WHERE name='index_social_framework_users_on_email' AND type='index' + UNION ALL + SELECT sql + FROM sqlite_temp_master + WHERE name='index_social_framework_users_on_email' AND type='index' + +  (0.1ms) begin transaction + SocialFramework::User Exists (0.1ms) SELECT 1 AS one FROM "social_framework_users" WHERE "social_framework_users"."email" = 'u1@email.com' LIMIT 1 + SQL (0.3ms) INSERT INTO "social_framework_users" ("username", "email", "encrypted_password", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?) [["username", "u1"], ["email", "u1@email.com"], ["encrypted_password", "$2a$10$7hFoqlc1B6qt8lhia4lqYOpe09kRkKZdMd.ZBhTmqRWQYMlWFJVdu"], ["created_at", "2016-06-08 17:19:04.184078"], ["updated_at", "2016-06-08 17:19:04.184078"]] +  (148.8ms) commit transaction + SocialFramework::Schedule Load (0.1ms) SELECT "social_framework_schedules".* FROM "social_framework_schedules" WHERE "social_framework_schedules"."user_id" = 1 LIMIT 1 +  (0.1ms) begin transaction + SQL (0.2ms) INSERT INTO "social_framework_schedules" ("user_id", "created_at", "updated_at") VALUES (?, ?, ?) [["user_id", 1], ["created_at", "2016-06-08 17:19:09.797738"], ["updated_at", "2016-06-08 17:19:09.797738"]] +  (127.5ms) commit transaction + SocialFramework::User Load (0.2ms) SELECT "social_framework_users".* FROM "social_framework_users" WHERE "social_framework_users"."id" = ? LIMIT 1 [["id", 1]] + SocialFramework::Schedule Load (0.3ms) SELECT "social_framework_schedules".* FROM "social_framework_schedules" WHERE "social_framework_schedules"."user_id" = 1 LIMIT 1 + SocialFramework::Schedule2 Load (0.2ms) SELECT "social_framework_schedules".* FROM "social_framework_schedules" WHERE "social_framework_schedules"."user_id" = 1 LIMIT 1 +  (161.1ms) CREATE TABLE "schema_migrations" ("version" varchar NOT NULL)  +  (0.1ms) select sqlite_version(*) +  (132.9ms) CREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version") + ActiveRecord::SchemaMigration Load (0.2ms) SELECT "schema_migrations".* FROM "schema_migrations" +Migrating to DeviseCreateSocialFrameworkUsers (20160129004111) +  (0.1ms) begin transaction +  (0.6ms) CREATE TABLE "social_framework_users" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "username" varchar NOT NULL, "email" varchar NOT NULL, "encrypted_password" varchar NOT NULL, "reset_password_token" varchar, "reset_password_sent_at" datetime, "remember_created_at" datetime, "sign_in_count" integer DEFAULT 0 NOT NULL, "current_sign_in_at" datetime, "last_sign_in_at" datetime, "current_sign_in_ip" varchar, "last_sign_in_ip" varchar, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL) +  (0.3ms) CREATE UNIQUE INDEX "index_social_framework_users_on_email" ON "social_framework_users" ("email") +  (0.1ms) SELECT sql + FROM sqlite_master + WHERE name='index_social_framework_users_on_email' AND type='index' + UNION ALL + SELECT sql + FROM sqlite_temp_master + WHERE name='index_social_framework_users_on_email' AND type='index' + +  (0.2ms) CREATE UNIQUE INDEX "index_social_framework_users_on_username" ON "social_framework_users" ("username") +  (0.1ms) SELECT sql + FROM sqlite_master + WHERE name='index_social_framework_users_on_username' AND type='index' + UNION ALL + SELECT sql + FROM sqlite_temp_master + WHERE name='index_social_framework_users_on_username' AND type='index' + +  (0.1ms)  SELECT sql + FROM sqlite_master + WHERE name='index_social_framework_users_on_email' AND type='index' + UNION ALL + SELECT sql + FROM sqlite_temp_master + WHERE name='index_social_framework_users_on_email' AND type='index' + +  (0.2ms) CREATE UNIQUE INDEX "index_social_framework_users_on_reset_password_token" ON "social_framework_users" ("reset_password_token") + SQL (0.2ms) INSERT INTO "schema_migrations" ("version") VALUES (?) [["version", "20160129004111"]] +  (169.5ms) commit transaction +Migrating to CreateSocialFrameworkEdges (20160226123409) +  (0.1ms) begin transaction +  (0.6ms) CREATE TABLE "social_framework_edges" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "origin_id" integer NOT NULL, "destiny_id" integer NOT NULL, "label" varchar NOT NULL, "bidirectional" boolean DEFAULT 't' NOT NULL, "active" boolean DEFAULT 'f' NOT NULL, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL) +  (0.3ms) CREATE INDEX "index_social_framework_edges_on_origin_id" ON "social_framework_edges" ("origin_id") +  (0.1ms) SELECT sql + FROM sqlite_master + WHERE name='index_social_framework_edges_on_origin_id' AND type='index' + UNION ALL + SELECT sql + FROM sqlite_temp_master + WHERE name='index_social_framework_edges_on_origin_id' AND type='index' + +  (0.2ms) CREATE INDEX "index_social_framework_edges_on_destiny_id" ON "social_framework_edges" ("destiny_id") + SQL (0.3ms) INSERT INTO "schema_migrations" ("version") VALUES (?) [["version", "20160226123409"]] +  (138.5ms) commit transaction +Migrating to CreateSocialFrameworkSchedules (20160406131316) +  (0.1ms) begin transaction +  (0.5ms) CREATE TABLE "social_framework_schedules" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer NOT NULL, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)  +  (0.5ms) CREATE UNIQUE INDEX "index_social_framework_schedules_on_user_id" ON "social_framework_schedules" ("user_id") + SQL (0.1ms) INSERT INTO "schema_migrations" ("version") VALUES (?) [["version", "20160406131316"]] +  (151.1ms) commit transaction +Migrating to CreateSocialFrameworkEvents (20160406133419) +  (0.2ms) begin transaction +  (0.8ms) CREATE TABLE "social_framework_events" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar NOT NULL, "description" varchar, "start" datetime, "finish" datetime, "particular" boolean DEFAULT 'f', "route_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL) + SQL (0.2ms) INSERT INTO "schema_migrations" ("version") VALUES (?) [["version", "20160406133419"]] +  (150.9ms) commit transaction +Migrating to CreateSocialFrameworkEventsSchedules (20160406134250) +  (0.2ms) begin transaction +  (0.6ms) CREATE TABLE "social_framework_events_schedules" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "schedule_id" integer NOT NULL, "event_id" integer NOT NULL) +  (0.4ms) CREATE INDEX "index_social_framework_events_schedules_on_schedule_id" ON "social_framework_events_schedules" ("schedule_id") +  (0.2ms) SELECT sql + FROM sqlite_master + WHERE name='index_social_framework_events_schedules_on_schedule_id' AND type='index' + UNION ALL + SELECT sql + FROM sqlite_temp_master + WHERE name='index_social_framework_events_schedules_on_schedule_id' AND type='index' + +  (0.3ms) CREATE INDEX "index_social_framework_events_schedules_on_event_id" ON "social_framework_events_schedules" ("event_id") + SQL (0.2ms) INSERT INTO "schema_migrations" ("version") VALUES (?) [["version", "20160406134250"]] +  (170.8ms) commit transaction +Migrating to CreateSocialFrameworkParticipantEvents (20160406165523) +  (0.1ms) begin transaction +  (0.3ms) CREATE TABLE "social_framework_participant_events" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "event_id" integer NOT NULL, "schedule_id" integer NOT NULL, "confirmed" boolean DEFAULT 'f', "role" varchar DEFAULT 'participant')  +  (0.1ms) CREATE INDEX "index_social_framework_participant_events_on_event_id" ON "social_framework_participant_events" ("event_id") +  (0.1ms)  SELECT sql + FROM sqlite_master + WHERE name='index_social_framework_participant_events_on_event_id' AND type='index' + UNION ALL + SELECT sql + FROM sqlite_temp_master + WHERE name='index_social_framework_participant_events_on_event_id' AND type='index' + +  (0.2ms) CREATE INDEX "index_social_framework_participant_events_on_schedule_id" ON "social_framework_participant_events" ("schedule_id") + SQL (0.1ms) INSERT INTO "schema_migrations" ("version") VALUES (?) [["version", "20160406165523"]] +  (130.7ms) commit transaction +Migrating to CreateSocialFrameworkRoutes (20160516122239) +  (0.1ms) begin transaction +  (0.6ms) CREATE TABLE "social_framework_routes" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar NOT NULL, "distance" integer NOT NULL, "mode_of_travel" varchar DEFAULT 'driving' NOT NULL, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL) +  (0.5ms) CREATE TABLE "social_framework_routes_users" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer NOT NULL, "route_id" integer NOT NULL)  +  (0.3ms) CREATE INDEX "index_social_framework_routes_users_on_user_id" ON "social_framework_routes_users" ("user_id") +  (0.2ms)  SELECT sql + FROM sqlite_master + WHERE name='index_social_framework_routes_users_on_user_id' AND type='index' + UNION ALL + SELECT sql + FROM sqlite_temp_master + WHERE name='index_social_framework_routes_users_on_user_id' AND type='index' + +  (0.3ms) CREATE INDEX "index_social_framework_routes_users_on_route_id" ON "social_framework_routes_users" ("route_id") +  (0.2ms)  SELECT sql + FROM sqlite_master + WHERE name='index_social_framework_routes_users_on_route_id' AND type='index' + UNION ALL + SELECT sql + FROM sqlite_temp_master + WHERE name='index_social_framework_routes_users_on_route_id' AND type='index' + +  (0.2ms) SELECT sql + FROM sqlite_master + WHERE name='index_social_framework_routes_users_on_user_id' AND type='index' + UNION ALL + SELECT sql + FROM sqlite_temp_master + WHERE name='index_social_framework_routes_users_on_user_id' AND type='index' + +  (0.5ms) CREATE UNIQUE INDEX "index_social_framework_routes_users_on_user_id_and_route_id" ON "social_framework_routes_users" ("user_id", "route_id") + SQL (0.2ms) INSERT INTO "schema_migrations" ("version") VALUES (?) [["version", "20160516122239"]] +  (146.5ms) commit transaction +Migrating to CreateSocialFrameworkLocations (20160516122649) +  (0.1ms) begin transaction +  (0.3ms) CREATE TABLE "social_framework_locations" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "route_id" integer NOT NULL, "latitude" decimal NOT NULL, "longitude" decimal NOT NULL, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)  + SQL (0.2ms) INSERT INTO "schema_migrations" ("version") VALUES (?) [["version", "20160516122649"]] +  (153.8ms) commit transaction + ActiveRecord::SchemaMigration Load (0.2ms) SELECT "schema_migrations".* FROM "schema_migrations" +  (0.3ms)  SELECT sql + FROM sqlite_master + WHERE name='index_social_framework_edges_on_destiny_id' AND type='index' + UNION ALL + SELECT sql + FROM sqlite_temp_master + WHERE name='index_social_framework_edges_on_destiny_id' AND type='index' + +  (0.1ms) SELECT sql + FROM sqlite_master + WHERE name='index_social_framework_edges_on_origin_id' AND type='index' + UNION ALL + SELECT sql + FROM sqlite_temp_master + WHERE name='index_social_framework_edges_on_origin_id' AND type='index' + +  (0.1ms)  SELECT sql + FROM sqlite_master + WHERE name='index_social_framework_events_schedules_on_event_id' AND type='index' + UNION ALL + SELECT sql + FROM sqlite_temp_master + WHERE name='index_social_framework_events_schedules_on_event_id' AND type='index' + +  (0.1ms) SELECT sql + FROM sqlite_master + WHERE name='index_social_framework_events_schedules_on_schedule_id' AND type='index' + UNION ALL + SELECT sql + FROM sqlite_temp_master + WHERE name='index_social_framework_events_schedules_on_schedule_id' AND type='index' + +  (0.2ms)  SELECT sql + FROM sqlite_master + WHERE name='index_social_framework_participant_events_on_schedule_id' AND type='index' + UNION ALL + SELECT sql + FROM sqlite_temp_master + WHERE name='index_social_framework_participant_events_on_schedule_id' AND type='index' + +  (0.1ms) SELECT sql + FROM sqlite_master + WHERE name='index_social_framework_participant_events_on_event_id' AND type='index' + UNION ALL + SELECT sql + FROM sqlite_temp_master + WHERE name='index_social_framework_participant_events_on_event_id' AND type='index' + +  (0.1ms)  SELECT sql + FROM sqlite_master + WHERE name='index_social_framework_routes_users_on_user_id_and_route_id' AND type='index' + UNION ALL + SELECT sql + FROM sqlite_temp_master + WHERE name='index_social_framework_routes_users_on_user_id_and_route_id' AND type='index' + +  (0.1ms) SELECT sql + FROM sqlite_master + WHERE name='index_social_framework_routes_users_on_route_id' AND type='index' + UNION ALL + SELECT sql + FROM sqlite_temp_master + WHERE name='index_social_framework_routes_users_on_route_id' AND type='index' + +  (0.1ms)  SELECT sql + FROM sqlite_master + WHERE name='index_social_framework_routes_users_on_user_id' AND type='index' + UNION ALL + SELECT sql + FROM sqlite_temp_master + WHERE name='index_social_framework_routes_users_on_user_id' AND type='index' + +  (0.1ms) SELECT sql + FROM sqlite_master + WHERE name='index_social_framework_schedules_on_user_id' AND type='index' + UNION ALL + SELECT sql + FROM sqlite_temp_master + WHERE name='index_social_framework_schedules_on_user_id' AND type='index' + +  (0.2ms)  SELECT sql + FROM sqlite_master + WHERE name='index_social_framework_users_on_reset_password_token' AND type='index' + UNION ALL + SELECT sql + FROM sqlite_temp_master + WHERE name='index_social_framework_users_on_reset_password_token' AND type='index' + +  (0.2ms) SELECT sql + FROM sqlite_master + WHERE name='index_social_framework_users_on_username' AND type='index' + UNION ALL + SELECT sql + FROM sqlite_temp_master + WHERE name='index_social_framework_users_on_username' AND type='index' + +  (0.1ms)  SELECT sql + FROM sqlite_master + WHERE name='index_social_framework_users_on_email' AND type='index' + UNION ALL + SELECT sql + FROM sqlite_temp_master + WHERE name='index_social_framework_users_on_email' AND type='index' + +  (0.1ms) begin transaction + SocialFramework::User Exists (0.2ms) SELECT 1 AS one FROM "social_framework_users" WHERE "social_framework_users"."email" = 'u1@email.com' LIMIT 1 + SQL (0.3ms) INSERT INTO "social_framework_users" ("username", "email", "encrypted_password", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?) [["username", "u1"], ["email", "u1@email.com"], ["encrypted_password", "$2a$10$af/RKfCsJqLnEmcPkWSXa.j3JkbU0lrn0f/e024/Byi5.UnjmX7Dm"], ["created_at", "2016-06-08 22:31:03.613905"], ["updated_at", "2016-06-08 22:31:03.613905"]] +  (134.1ms) commit transaction + SocialFramework::Schedule Load (0.4ms) SELECT "social_framework_schedules".* FROM "social_framework_schedules" WHERE "social_framework_schedules"."user_id" = 1 LIMIT 1 +  (0.1ms) begin transaction + SQL (0.3ms) INSERT INTO "social_framework_schedules" ("user_id", "created_at", "updated_at") VALUES (?, ?, ?) [["user_id", 1], ["created_at", "2016-06-08 22:31:11.393344"], ["updated_at", "2016-06-08 22:31:11.393344"]] +  (195.3ms) commit transaction + SocialFramework::Schedule2 Load (0.3ms) SELECT "social_framework_schedules".* FROM "social_framework_schedules" WHERE "social_framework_schedules"."user_id" = 1 LIMIT 1