(139.1ms)  DROP DATABASE IF EXISTS "dummy_test"
   (465.6ms)  CREATE DATABASE "dummy_test" ENCODING = 'unicode'
  SQL (0.7ms)  CREATE EXTENSION IF NOT EXISTS "plpgsql"
   (9.3ms)  CREATE TABLE "activities" ("id" serial primary key, "participant_id" integer NOT NULL, "created_at" timestamp NOT NULL, "updated_at" timestamp NOT NULL) 
   (7.4ms)  CREATE TABLE "arms" ("id" serial primary key, "title" character varying DEFAULT '' NOT NULL, "is_social" boolean DEFAULT 'f' NOT NULL, "has_woz" boolean DEFAULT 'f') 
   (7.1ms)  CREATE TABLE "participants" ("id" serial primary key, "email" character varying, "phone_number" character varying, "contact_preference" character varying, "study_id" character varying) 
   (7.4ms)  CREATE TABLE "social_networking_comments" ("id" serial primary key, "participant_id" integer NOT NULL, "text" character varying(1000) NOT NULL, "item_id" integer NOT NULL, "item_type" character varying NOT NULL, "created_at" timestamp, "updated_at" timestamp) 
   (2.3ms)  CREATE  INDEX  "index_social_networking_comments_on_item_id_and_item_type" ON "social_networking_comments" USING btree ("item_id", "item_type")
   (6.4ms)  CREATE TABLE "social_networking_goals" ("id" serial primary key, "description" character varying(1000) NOT NULL, "participant_id" integer NOT NULL, "due_on" date, "created_at" timestamp, "updated_at" timestamp, "completed_at" timestamp, "deleted_at" timestamp) 
   (7.4ms)  CREATE TABLE "social_networking_likes" ("id" serial primary key, "participant_id" integer NOT NULL, "item_id" integer NOT NULL, "item_type" character varying NOT NULL, "created_at" timestamp, "updated_at" timestamp) 
   (1.8ms)  CREATE  INDEX  "index_social_networking_likes_on_item_id_and_item_type" ON "social_networking_likes" USING btree ("item_id", "item_type")
   (2.3ms)  CREATE UNIQUE INDEX  "one_like_per_item" ON "social_networking_likes" USING btree ("participant_id", "item_id", "item_type")
   (4.8ms)  CREATE TABLE "social_networking_nudges" ("id" serial primary key, "initiator_id" integer NOT NULL, "recipient_id" integer NOT NULL, "created_at" timestamp, "updated_at" timestamp) 
   (2.0ms)  CREATE  INDEX  "index_social_networking_nudges_on_created_at" ON "social_networking_nudges" USING btree ("created_at")
   (1.7ms)  CREATE  INDEX  "index_social_networking_nudges_on_initiator_id" ON "social_networking_nudges" USING btree ("initiator_id")
   (2.1ms)  CREATE  INDEX  "index_social_networking_nudges_on_recipient_id" ON "social_networking_nudges" USING btree ("recipient_id")
   (6.2ms)  CREATE TABLE "social_networking_on_the_mind_statements" ("id" serial primary key, "description" character varying(1000) NOT NULL, "participant_id" integer NOT NULL, "created_at" timestamp, "updated_at" timestamp) 
   (2.9ms)  CREATE  INDEX  "on_the_mind_created_at" ON "social_networking_on_the_mind_statements" USING btree ("created_at")
   (1.7ms)  CREATE  INDEX  "on_the_mind_participant" ON "social_networking_on_the_mind_statements" USING btree ("participant_id")
   (6.5ms)  CREATE TABLE "social_networking_profile_answers" ("id" serial primary key, "social_networking_profile_question_id" integer NOT NULL, "order" integer, "answer_text" character varying(1000) NOT NULL, "created_at" timestamp, "updated_at" timestamp, "social_networking_profile_id" integer) 
   (2.3ms)  CREATE UNIQUE INDEX  "profile_answers_unique" ON "social_networking_profile_answers" USING btree ("social_networking_profile_id", "social_networking_profile_question_id")
   (6.0ms)  CREATE TABLE "social_networking_profile_questions" ("id" serial primary key, "question_text" character varying NOT NULL, "created_at" timestamp, "updated_at" timestamp) 
   (7.6ms)  CREATE TABLE "social_networking_profiles" ("id" serial primary key, "participant_id" integer NOT NULL, "created_at" timestamp, "updated_at" timestamp, "icon_name" character varying, "active" boolean DEFAULT 'f' NOT NULL) 
   (6.5ms)  CREATE TABLE "social_networking_shared_items" ("id" serial primary key, "item_id" integer NOT NULL, "item_type" character varying NOT NULL, "created_at" timestamp, "updated_at" timestamp, "is_public" boolean DEFAULT 't' NOT NULL, "action_type" character varying DEFAULT '' NOT NULL, "item_label" character varying, "participant_id" integer) 
   (3.7ms)  CREATE  INDEX  "index_social_networking_shared_items_on_created_at" ON "social_networking_shared_items" USING btree ("created_at")
   (1.8ms)  CREATE  INDEX  "index_social_networking_shared_items_on_participant_id" ON "social_networking_shared_items" USING btree ("participant_id")
   (4.3ms)  ALTER TABLE "social_networking_comments" ADD CONSTRAINT "fk_comments_participants"
FOREIGN KEY ("participant_id")
  REFERENCES "participants" ("id")

   (3.4ms)  ALTER TABLE "social_networking_goals" ADD CONSTRAINT "fk_goals_participants"
FOREIGN KEY ("participant_id")
  REFERENCES "participants" ("id")

   (2.5ms)  ALTER TABLE "social_networking_likes" ADD CONSTRAINT "fk_likes_participants"
FOREIGN KEY ("participant_id")
  REFERENCES "participants" ("id")

   (3.0ms)  ALTER TABLE "social_networking_nudges" ADD CONSTRAINT "fk_nudges_initiators"
FOREIGN KEY ("initiator_id")
  REFERENCES "participants" ("id")

   (2.3ms)  ALTER TABLE "social_networking_nudges" ADD CONSTRAINT "fk_nudges_recipients"
FOREIGN KEY ("recipient_id")
  REFERENCES "participants" ("id")

   (2.6ms)  ALTER TABLE "social_networking_on_the_mind_statements" ADD CONSTRAINT "fk_on_the_mind_participants"
FOREIGN KEY ("participant_id")
  REFERENCES "participants" ("id")

   (3.2ms)  ALTER TABLE "social_networking_profile_answers" ADD CONSTRAINT "fk_profile_answers_profile_questions"
FOREIGN KEY ("social_networking_profile_question_id")
  REFERENCES "social_networking_profile_questions" ("id")

   (2.7ms)  ALTER TABLE "social_networking_profile_answers" ADD CONSTRAINT "fk_profile_answers_profiles"
FOREIGN KEY ("social_networking_profile_id")
  REFERENCES "social_networking_profiles" ("id")

   (2.4ms)  ALTER TABLE "social_networking_profiles" ADD CONSTRAINT "fk_profiles_participants"
FOREIGN KEY ("participant_id")
  REFERENCES "participants" ("id")

   (3.1ms)  CREATE TABLE "schema_migrations" ("version" character varying NOT NULL) 
   (2.4ms)  CREATE UNIQUE INDEX  "unique_schema_migrations" ON "schema_migrations"  ("version")
   (0.7ms)  SELECT version FROM "schema_migrations"
   (1.1ms)  INSERT INTO "schema_migrations" (version) VALUES ('20160308201931')
   (1.3ms)  INSERT INTO "schema_migrations" (version) VALUES ('1')
   (0.6ms)  INSERT INTO "schema_migrations" (version) VALUES ('2')
   (0.6ms)  INSERT INTO "schema_migrations" (version) VALUES ('3')
   (0.5ms)  INSERT INTO "schema_migrations" (version) VALUES ('5')
   (0.5ms)  INSERT INTO "schema_migrations" (version) VALUES ('6')
   (0.5ms)  INSERT INTO "schema_migrations" (version) VALUES ('8')
   (0.6ms)  INSERT INTO "schema_migrations" (version) VALUES ('20150309210518')
   (0.5ms)  INSERT INTO "schema_migrations" (version) VALUES ('20140827154926')
   (0.5ms)  INSERT INTO "schema_migrations" (version) VALUES ('20140827154939')
   (0.6ms)  INSERT INTO "schema_migrations" (version) VALUES ('20140827154953')
   (0.5ms)  INSERT INTO "schema_migrations" (version) VALUES ('20140904201719')
   (0.5ms)  INSERT INTO "schema_migrations" (version) VALUES ('20140910123000')
   (0.5ms)  INSERT INTO "schema_migrations" (version) VALUES ('20140911193832')
   (0.6ms)  INSERT INTO "schema_migrations" (version) VALUES ('20140915185648')
   (0.6ms)  INSERT INTO "schema_migrations" (version) VALUES ('20140915190627')
   (1.2ms)  INSERT INTO "schema_migrations" (version) VALUES ('20140915190633')
   (0.7ms)  INSERT INTO "schema_migrations" (version) VALUES ('20140916163621')
   (0.6ms)  INSERT INTO "schema_migrations" (version) VALUES ('20140917151905')
   (0.6ms)  INSERT INTO "schema_migrations" (version) VALUES ('20140930141007')
   (0.6ms)  INSERT INTO "schema_migrations" (version) VALUES ('20141001130941')
   (0.8ms)  INSERT INTO "schema_migrations" (version) VALUES ('20141003191233')
   (0.6ms)  INSERT INTO "schema_migrations" (version) VALUES ('20141006200325')
   (0.6ms)  INSERT INTO "schema_migrations" (version) VALUES ('20141007141541')
   (0.5ms)  INSERT INTO "schema_migrations" (version) VALUES ('20141008150325')
   (0.5ms)  INSERT INTO "schema_migrations" (version) VALUES ('20141015222822')
   (0.5ms)  INSERT INTO "schema_migrations" (version) VALUES ('20141016015415')
   (0.5ms)  INSERT INTO "schema_migrations" (version) VALUES ('20141016164443')
   (0.5ms)  INSERT INTO "schema_migrations" (version) VALUES ('20141106102625')
   (0.5ms)  INSERT INTO "schema_migrations" (version) VALUES ('20141106104713')
   (0.5ms)  INSERT INTO "schema_migrations" (version) VALUES ('20141223203142')
   (0.5ms)  INSERT INTO "schema_migrations" (version) VALUES ('20141223203721')
   (0.5ms)  INSERT INTO "schema_migrations" (version) VALUES ('20150317173959')
   (0.5ms)  INSERT INTO "schema_migrations" (version) VALUES ('20150317174425')
   (0.5ms)  INSERT INTO "schema_migrations" (version) VALUES ('20150317180057')
   (0.5ms)  INSERT INTO "schema_migrations" (version) VALUES ('20150318133032')
   (0.6ms)  INSERT INTO "schema_migrations" (version) VALUES ('20150318133127')
   (0.6ms)  INSERT INTO "schema_migrations" (version) VALUES ('20150318133353')
   (0.6ms)  INSERT INTO "schema_migrations" (version) VALUES ('20150327143224')
   (0.8ms)  INSERT INTO "schema_migrations" (version) VALUES ('20150327143244')
   (0.6ms)  INSERT INTO "schema_migrations" (version) VALUES ('20150327185721')
   (0.5ms)  INSERT INTO "schema_migrations" (version) VALUES ('20150327185856')
   (0.5ms)  INSERT INTO "schema_migrations" (version) VALUES ('20150327185919')
   (0.5ms)  INSERT INTO "schema_migrations" (version) VALUES ('20151211204425')