(118.6ms) DROP DATABASE IF EXISTS "dummy_test"  (235.4ms) CREATE DATABASE "dummy_test" ENCODING = 'unicode'  (115.3ms) DROP DATABASE IF EXISTS "dummy_test"  (235.1ms) CREATE DATABASE "dummy_test" ENCODING = 'unicode' SQL (0.3ms) CREATE EXTENSION IF NOT EXISTS "plpgsql"  (5.4ms) CREATE TABLE "arms" ("id" serial primary key, "title" character varying(255) DEFAULT '', "is_social" boolean DEFAULT 'f', "created_at" timestamp, "updated_at" timestamp)  (2.9ms) CREATE TABLE "coach_assignments" ("id" serial primary key, "coach_id" integer NOT NULL, "participant_id" integer NOT NULL, "created_at" timestamp, "updated_at" timestamp)   (2.8ms) CREATE TABLE "groups" ("id" serial primary key, "title" character varying(255), "created_at" timestamp, "updated_at" timestamp, "arm_id" integer)  (2.9ms) CREATE TABLE "memberships" ("id" serial primary key, "group_id" integer NOT NULL, "participant_id" integer NOT NULL, "end_date" date, "start_date" date, "created_at" timestamp, "updated_at" timestamp)   (4.7ms) CREATE TABLE "participants" ("id" serial primary key, "email" character varying(255) DEFAULT '' NOT NULL, "phone_number" character varying(255), "study_id" character varying(255), "created_at" timestamp, "updated_at" timestamp, "display_name" character varying(255) DEFAULT '' NOT NULL, "contact_preference" character varying(255) DEFAULT '', "encrypted_password" character varying(255) DEFAULT '' NOT NULL, "reset_password_token" character varying(255), "reset_password_sent_at" timestamp, "remember_created_at" timestamp, "sign_in_count" integer DEFAULT 0 NOT NULL, "current_sign_in_at" timestamp, "last_sign_in_at" timestamp, "current_sign_in_ip" inet, "last_sign_in_ip" inet)  (1.4ms) CREATE UNIQUE INDEX "index_participants_on_email" ON "participants" USING btree ("email")  (1.1ms) CREATE UNIQUE INDEX "index_participants_on_phone_number" ON "participants" USING btree ("phone_number")  (1.1ms) CREATE UNIQUE INDEX "index_participants_on_reset_password_token" ON "participants" USING btree ("reset_password_token")  (1.2ms) CREATE UNIQUE INDEX "index_participants_on_study_id" ON "participants" USING btree ("study_id")  (2.5ms) CREATE TABLE "slideshow_anchors" ("id" serial primary key, "bit_core_slideshow_id" integer, "target_name" character varying(255), "created_at" timestamp, "updated_at" timestamp)   (2.5ms) CREATE TABLE "think_feel_do_dashboard_moderators" ("id" serial primary key, "group_id" integer NOT NULL, "user_id" integer NOT NULL, "created_at" timestamp, "updated_at" timestamp)  (3.1ms) CREATE TABLE "user_roles" ("id" serial primary key, "user_id" integer, "role_class_name" character varying(255), "created_at" timestamp, "updated_at" timestamp)   (4.3ms) CREATE TABLE "users" ("id" serial primary key, "email" character varying(255), "created_at" timestamp, "updated_at" timestamp, "is_admin" boolean DEFAULT 'f' NOT NULL, "encrypted_password" character varying(255) DEFAULT '' NOT NULL, "reset_password_token" character varying(255), "reset_password_sent_at" timestamp, "remember_created_at" timestamp, "sign_in_count" integer DEFAULT 0 NOT NULL, "current_sign_in_at" timestamp, "last_sign_in_at" timestamp, "current_sign_in_ip" inet, "last_sign_in_ip" inet)  (1.1ms) CREATE UNIQUE INDEX "index_users_on_email" ON "users" USING btree ("email")  (1.3ms) CREATE UNIQUE INDEX "index_users_on_reset_password_token" ON "users" USING btree ("reset_password_token")  (6.5ms) CREATE TABLE "schema_migrations" ("version" character varying(255) NOT NULL)   (2.1ms) CREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")  (0.4ms) SELECT version FROM "schema_migrations"  (0.6ms) INSERT INTO "schema_migrations" (version) VALUES ('20141203201524')  (0.5ms) INSERT INTO "schema_migrations" (version) VALUES ('20141020185953')  (0.4ms) INSERT INTO "schema_migrations" (version) VALUES ('20141020190822')  (0.4ms) INSERT INTO "schema_migrations" (version) VALUES ('20141020190824')  (0.4ms) INSERT INTO "schema_migrations" (version) VALUES ('20141020191622')  (0.4ms) INSERT INTO "schema_migrations" (version) VALUES ('20141020191754')  (0.5ms) INSERT INTO "schema_migrations" (version) VALUES ('20141104135632')  (0.4ms) INSERT INTO "schema_migrations" (version) VALUES ('20141104141420')  (0.4ms) INSERT INTO "schema_migrations" (version) VALUES ('20141107170701')  (0.4ms) INSERT INTO "schema_migrations" (version) VALUES ('20141111140835')  (0.4ms) INSERT INTO "schema_migrations" (version) VALUES ('20141120202053')  (0.3ms) INSERT INTO "schema_migrations" (version) VALUES ('20141121201134')  (0.4ms) INSERT INTO "schema_migrations" (version) VALUES ('20141125225148')  (0.3ms) INSERT INTO "schema_migrations" (version) VALUES ('20141125230628')  (0.4ms) INSERT INTO "schema_migrations" (version) VALUES ('20141126151510')  (0.3ms) INSERT INTO "schema_migrations" (version) VALUES ('20141203195016')  (0.4ms) INSERT INTO "schema_migrations" (version) VALUES ('20141105203408')  (0.4ms) INSERT INTO "schema_migrations" (version) VALUES ('20141106202954')  (0.4ms) INSERT INTO "schema_migrations" (version) VALUES ('20141106211650')  (2.6ms) CREATE TABLE "schema_migrations" ("version" character varying(255) NOT NULL)   (2.3ms) CREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version") ActiveRecord::SchemaMigration Load (0.5ms) SELECT "schema_migrations".* FROM "schema_migrations" Migrating to CreateParticipants (20141020185953)  (0.1ms) BEGIN  (6.0ms) CREATE TABLE "participants" ("id" serial primary key, "email" character varying(255) DEFAULT '' NOT NULL, "phone_number" character varying(255), "study_id" character varying(255), "created_at" timestamp, "updated_at" timestamp)   (1.1ms) CREATE UNIQUE INDEX "index_participants_on_email" ON "participants" ("email")  (0.9ms) CREATE UNIQUE INDEX "index_participants_on_phone_number" ON "participants" ("phone_number")  (1.0ms) CREATE UNIQUE INDEX "index_participants_on_study_id" ON "participants" ("study_id") SQL (1.2ms) INSERT INTO "schema_migrations" ("version") VALUES ($1) [["version", "20141020185953"]]  (0.6ms) COMMIT Migrating to CreateMemberships (20141020190822)  (0.3ms) BEGIN  (2.7ms) CREATE TABLE "memberships" ("id" serial primary key, "group_id" integer NOT NULL, "participant_id" integer NOT NULL, "end_date" date, "start_date" date, "created_at" timestamp, "updated_at" timestamp) SQL (0.2ms) INSERT INTO "schema_migrations" ("version") VALUES ($1) [["version", "20141020190822"]]  (0.5ms) COMMIT Migrating to CreateCoachAssignments (20141020190824)  (0.2ms) BEGIN  (2.7ms) CREATE TABLE "coach_assignments" ("id" serial primary key, "coach_id" integer NOT NULL, "participant_id" integer NOT NULL, "created_at" timestamp, "updated_at" timestamp) SQL (0.2ms) INSERT INTO "schema_migrations" ("version") VALUES ($1) [["version", "20141020190824"]]  (0.5ms) COMMIT Migrating to CreateUsers (20141020191622)  (0.2ms) BEGIN  (3.2ms) CREATE TABLE "users" ("id" serial primary key, "email" character varying(255), "created_at" timestamp, "updated_at" timestamp) SQL (0.3ms) INSERT INTO "schema_migrations" ("version") VALUES ($1) [["version", "20141020191622"]]  (0.4ms) COMMIT Migrating to CreateGroups (20141020191754)  (0.2ms) BEGIN  (2.4ms) CREATE TABLE "groups" ("id" serial primary key, "title" character varying(255), "created_at" timestamp, "updated_at" timestamp) SQL (0.2ms) INSERT INTO "schema_migrations" ("version") VALUES ($1) [["version", "20141020191754"]]  (0.5ms) COMMIT Migrating to AddColumnIsAdminToUsers (20141104135632)  (0.2ms) BEGIN  (3.0ms) ALTER TABLE "users" ADD COLUMN "is_admin" boolean DEFAULT 'f' NOT NULL SQL (0.3ms) INSERT INTO "schema_migrations" ("version") VALUES ($1) [["version", "20141104135632"]]  (0.9ms) COMMIT Migrating to CreateUserRoles (20141104141420)  (0.2ms) BEGIN  (3.5ms) CREATE TABLE "user_roles" ("id" serial primary key, "user_id" integer, "role_class_name" character varying(255), "created_at" timestamp, "updated_at" timestamp) SQL (0.2ms) INSERT INTO "schema_migrations" ("version") VALUES ($1) [["version", "20141104141420"]]  (1.3ms) COMMIT Migrating to CreateThinkFeelDoDashboardModerators (20141105203408)  (0.3ms) BEGIN  (2.3ms) CREATE TABLE "think_feel_do_dashboard_moderators" ("id" serial primary key, "group_id" integer NOT NULL, "user_id" integer NOT NULL, "created_at" timestamp, "updated_at" timestamp) SQL (0.3ms) INSERT INTO "schema_migrations" ("version") VALUES ($1) [["version", "20141105203408"]]  (0.4ms) COMMIT Migrating to AddColumnDisplayNameToParticipants (20141106202954)  (0.3ms) BEGIN  (8.5ms) ALTER TABLE "participants" ADD COLUMN "display_name" character varying(255) DEFAULT '' NOT NULL SQL (0.2ms) INSERT INTO "schema_migrations" ("version") VALUES ($1) [["version", "20141106202954"]]  (1.3ms) COMMIT Migrating to AddColumnContactPreferenceToParticipant (20141106211650)  (0.3ms) BEGIN  (5.3ms) ALTER TABLE "participants" ADD COLUMN "contact_preference" character varying(255) DEFAULT '' SQL (0.2ms) INSERT INTO "schema_migrations" ("version") VALUES ($1) [["version", "20141106211650"]]  (1.2ms) COMMIT Migrating to AddColumnsToUser (20141107170701)  (0.2ms) BEGIN  (1.8ms) ALTER TABLE "users" ADD COLUMN "password" character varying(255)  (0.7ms) ALTER TABLE "users" ADD COLUMN "password_confirmation" character varying(255) SQL (0.2ms) INSERT INTO "schema_migrations" ("version") VALUES ($1) [["version", "20141107170701"]]  (0.4ms) COMMIT Migrating to AddColumnsPasswordAndPasswordConfirmationToParticipants (20141111140835)  (0.1ms) BEGIN  (0.4ms) ALTER TABLE "participants" ADD COLUMN "password" character varying(255)  (0.3ms) ALTER TABLE "participants" ADD COLUMN "password_confirmation" character varying(255) SQL (0.2ms) INSERT INTO "schema_migrations" ("version") VALUES ($1) [["version", "20141111140835"]]  (0.4ms) COMMIT Migrating to CreateArms (20141120202053)  (0.1ms) BEGIN  (3.1ms) CREATE TABLE "arms" ("id" serial primary key, "title" character varying(255) DEFAULT '', "is_social" boolean DEFAULT 'f', "created_at" timestamp, "updated_at" timestamp) SQL (0.2ms) INSERT INTO "schema_migrations" ("version") VALUES ($1) [["version", "20141120202053"]]  (0.4ms) COMMIT Migrating to AddArmIdToGroups (20141121201134)  (0.3ms) BEGIN  (0.3ms) ALTER TABLE "groups" ADD COLUMN "arm_id" integer SQL (0.2ms) INSERT INTO "schema_migrations" ("version") VALUES ($1) [["version", "20141121201134"]]  (0.3ms) COMMIT Migrating to AddDeviseToUsers (20141125225148)  (0.1ms) BEGIN  (3.7ms) ALTER TABLE "users" ADD COLUMN "encrypted_password" character varying(255) DEFAULT '' NOT NULL  (0.2ms) ALTER TABLE "users" ADD COLUMN "reset_password_token" character varying(255)  (0.2ms) ALTER TABLE "users" ADD COLUMN "reset_password_sent_at" timestamp  (0.2ms) ALTER TABLE "users" ADD COLUMN "remember_created_at" timestamp  (3.5ms) ALTER TABLE "users" ADD COLUMN "sign_in_count" integer DEFAULT 0 NOT NULL  (0.3ms) ALTER TABLE "users" ADD COLUMN "current_sign_in_at" timestamp  (0.2ms) ALTER TABLE "users" ADD COLUMN "last_sign_in_at" timestamp  (0.2ms) ALTER TABLE "users" ADD COLUMN "current_sign_in_ip" inet  (0.2ms) ALTER TABLE "users" ADD COLUMN "last_sign_in_ip" inet  (0.9ms) CREATE UNIQUE INDEX "index_users_on_email" ON "users" ("email")  (1.1ms) CREATE UNIQUE INDEX "index_users_on_reset_password_token" ON "users" ("reset_password_token") SQL (0.2ms) INSERT INTO "schema_migrations" ("version") VALUES ($1) [["version", "20141125225148"]]  (1.8ms) COMMIT Migrating to CreateSlideshowAnchors (20141125230628)  (0.8ms) BEGIN  (3.2ms) CREATE TABLE "slideshow_anchors" ("id" serial primary key, "bit_core_slideshow_id" integer, "target_name" character varying(255), "created_at" timestamp, "updated_at" timestamp) SQL (0.2ms) INSERT INTO "schema_migrations" ("version") VALUES ($1) [["version", "20141125230628"]]  (0.5ms) COMMIT Migrating to RemoveColumnsPasswordAndPasswordConfirmationFromUsers (20141126151510)  (0.3ms) BEGIN  (0.5ms) ALTER TABLE "users" DROP "password"  (0.2ms) ALTER TABLE "users" DROP "password_confirmation" SQL (0.2ms) INSERT INTO "schema_migrations" ("version") VALUES ($1) [["version", "20141126151510"]]  (0.3ms) COMMIT Migrating to AddDeviseToParticipants (20141203195016)  (0.1ms) BEGIN  (5.1ms) ALTER TABLE "participants" ADD COLUMN "encrypted_password" character varying(255) DEFAULT '' NOT NULL  (0.3ms) ALTER TABLE "participants" ADD COLUMN "reset_password_token" character varying(255)  (0.2ms) ALTER TABLE "participants" ADD COLUMN "reset_password_sent_at" timestamp  (0.2ms) ALTER TABLE "participants" ADD COLUMN "remember_created_at" timestamp  (5.4ms) ALTER TABLE "participants" ADD COLUMN "sign_in_count" integer DEFAULT 0 NOT NULL  (0.6ms) ALTER TABLE "participants" ADD COLUMN "current_sign_in_at" timestamp  (0.2ms) ALTER TABLE "participants" ADD COLUMN "last_sign_in_at" timestamp  (0.2ms) ALTER TABLE "participants" ADD COLUMN "current_sign_in_ip" inet  (0.2ms) ALTER TABLE "participants" ADD COLUMN "last_sign_in_ip" inet  (1.0ms) CREATE UNIQUE INDEX "index_participants_on_reset_password_token" ON "participants" ("reset_password_token") SQL (0.2ms) INSERT INTO "schema_migrations" ("version") VALUES ($1) [["version", "20141203195016"]]  (2.5ms) COMMIT Migrating to RemovePasswordFromParticipants (20141203201524)  (0.4ms) BEGIN  (0.6ms) ALTER TABLE "participants" DROP "password"  (0.4ms) ALTER TABLE "participants" DROP "password_confirmation" SQL (1.0ms) INSERT INTO "schema_migrations" ("version") VALUES ($1) [["version", "20141203201524"]]  (0.5ms) COMMIT ActiveRecord::SchemaMigration Load (0.2ms) SELECT "schema_migrations".* FROM "schema_migrations"  (115.4ms) DROP DATABASE IF EXISTS "dummy_test"  (233.3ms) CREATE DATABASE "dummy_test" ENCODING = 'unicode'  (114.6ms) DROP DATABASE IF EXISTS "dummy_test"  (234.7ms) CREATE DATABASE "dummy_test" ENCODING = 'unicode' SQL (0.3ms) CREATE EXTENSION IF NOT EXISTS "plpgsql"  (5.5ms) CREATE TABLE "arms" ("id" serial primary key, "title" character varying(255) DEFAULT '', "is_social" boolean DEFAULT 'f', "created_at" timestamp, "updated_at" timestamp)  (3.1ms) CREATE TABLE "coach_assignments" ("id" serial primary key, "coach_id" integer NOT NULL, "participant_id" integer NOT NULL, "created_at" timestamp, "updated_at" timestamp)   (2.9ms) CREATE TABLE "groups" ("id" serial primary key, "title" character varying(255), "created_at" timestamp, "updated_at" timestamp, "arm_id" integer)  (3.2ms) CREATE TABLE "memberships" ("id" serial primary key, "group_id" integer NOT NULL, "participant_id" integer NOT NULL, "end_date" date, "start_date" date, "created_at" timestamp, "updated_at" timestamp)   (4.6ms) CREATE TABLE "participants" ("id" serial primary key, "email" character varying(255) DEFAULT '' NOT NULL, "phone_number" character varying(255), "study_id" character varying(255), "created_at" timestamp, "updated_at" timestamp, "display_name" character varying(255) DEFAULT '' NOT NULL, "contact_preference" character varying(255) DEFAULT '', "encrypted_password" character varying(255) DEFAULT '' NOT NULL, "reset_password_token" character varying(255), "reset_password_sent_at" timestamp, "remember_created_at" timestamp, "sign_in_count" integer DEFAULT 0 NOT NULL, "current_sign_in_at" timestamp, "last_sign_in_at" timestamp, "current_sign_in_ip" inet, "last_sign_in_ip" inet)  (1.3ms) CREATE UNIQUE INDEX "index_participants_on_email" ON "participants" USING btree ("email")  (1.1ms) CREATE UNIQUE INDEX "index_participants_on_phone_number" ON "participants" USING btree ("phone_number")  (1.2ms) CREATE UNIQUE INDEX "index_participants_on_reset_password_token" ON "participants" USING btree ("reset_password_token")  (1.1ms) CREATE UNIQUE INDEX "index_participants_on_study_id" ON "participants" USING btree ("study_id")  (2.5ms) CREATE TABLE "slideshow_anchors" ("id" serial primary key, "bit_core_slideshow_id" integer, "target_name" character varying(255), "created_at" timestamp, "updated_at" timestamp)   (2.7ms) CREATE TABLE "think_feel_do_dashboard_moderators" ("id" serial primary key, "group_id" integer NOT NULL, "user_id" integer NOT NULL, "created_at" timestamp, "updated_at" timestamp)  (2.5ms) CREATE TABLE "user_roles" ("id" serial primary key, "user_id" integer, "role_class_name" character varying(255), "created_at" timestamp, "updated_at" timestamp)   (4.7ms) CREATE TABLE "users" ("id" serial primary key, "email" character varying(255), "created_at" timestamp, "updated_at" timestamp, "is_admin" boolean DEFAULT 'f' NOT NULL, "encrypted_password" character varying(255) DEFAULT '' NOT NULL, "reset_password_token" character varying(255), "reset_password_sent_at" timestamp, "remember_created_at" timestamp, "sign_in_count" integer DEFAULT 0 NOT NULL, "current_sign_in_at" timestamp, "last_sign_in_at" timestamp, "current_sign_in_ip" inet, "last_sign_in_ip" inet)  (1.2ms) CREATE UNIQUE INDEX "index_users_on_email" ON "users" USING btree ("email")  (1.2ms) CREATE UNIQUE INDEX "index_users_on_reset_password_token" ON "users" USING btree ("reset_password_token")  (0.9ms) CREATE TABLE "schema_migrations" ("version" character varying(255) NOT NULL)   (1.1ms) CREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")  (0.3ms) SELECT version FROM "schema_migrations"  (0.5ms) INSERT INTO "schema_migrations" (version) VALUES ('20141203201524')  (0.5ms) INSERT INTO "schema_migrations" (version) VALUES ('20141020185953')  (0.4ms) INSERT INTO "schema_migrations" (version) VALUES ('20141020190822')  (0.4ms) INSERT INTO "schema_migrations" (version) VALUES ('20141020190824')  (0.3ms) INSERT INTO "schema_migrations" (version) VALUES ('20141020191622')  (0.4ms) INSERT INTO "schema_migrations" (version) VALUES ('20141020191754')  (0.3ms) INSERT INTO "schema_migrations" (version) VALUES ('20141104135632')  (0.3ms) INSERT INTO "schema_migrations" (version) VALUES ('20141104141420')  (0.3ms) INSERT INTO "schema_migrations" (version) VALUES ('20141107170701')  (0.3ms) INSERT INTO "schema_migrations" (version) VALUES ('20141111140835')  (0.3ms) INSERT INTO "schema_migrations" (version) VALUES ('20141120202053')  (0.3ms) INSERT INTO "schema_migrations" (version) VALUES ('20141121201134')  (0.3ms) INSERT INTO "schema_migrations" (version) VALUES ('20141125225148')  (0.3ms) INSERT INTO "schema_migrations" (version) VALUES ('20141125230628')  (0.2ms) INSERT INTO "schema_migrations" (version) VALUES ('20141126151510')  (0.2ms) INSERT INTO "schema_migrations" (version) VALUES ('20141203195016')  (0.3ms) INSERT INTO "schema_migrations" (version) VALUES ('20141105203408')  (0.2ms) INSERT INTO "schema_migrations" (version) VALUES ('20141106202954')  (0.3ms) INSERT INTO "schema_migrations" (version) VALUES ('20141106211650')  (2.6ms) CREATE TABLE "schema_migrations" ("version" character varying(255) NOT NULL)   (1.5ms) CREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version") ActiveRecord::SchemaMigration Load (0.4ms) SELECT "schema_migrations".* FROM "schema_migrations" Migrating to CreateParticipants (20141020185953)  (0.1ms) BEGIN  (4.6ms) CREATE TABLE "participants" ("id" serial primary key, "email" character varying(255) DEFAULT '' NOT NULL, "phone_number" character varying(255), "study_id" character varying(255), "created_at" timestamp, "updated_at" timestamp)   (1.0ms) CREATE UNIQUE INDEX "index_participants_on_email" ON "participants" ("email")  (1.1ms) CREATE UNIQUE INDEX "index_participants_on_phone_number" ON "participants" ("phone_number")  (1.0ms) CREATE UNIQUE INDEX "index_participants_on_study_id" ON "participants" ("study_id") SQL (0.4ms) INSERT INTO "schema_migrations" ("version") VALUES ($1) [["version", "20141020185953"]]  (0.6ms) COMMIT Migrating to CreateMemberships (20141020190822)  (0.3ms) BEGIN  (2.8ms) CREATE TABLE "memberships" ("id" serial primary key, "group_id" integer NOT NULL, "participant_id" integer NOT NULL, "end_date" date, "start_date" date, "created_at" timestamp, "updated_at" timestamp) SQL (0.2ms) INSERT INTO "schema_migrations" ("version") VALUES ($1) [["version", "20141020190822"]]  (0.5ms) COMMIT Migrating to CreateCoachAssignments (20141020190824)  (0.2ms) BEGIN  (2.4ms) CREATE TABLE "coach_assignments" ("id" serial primary key, "coach_id" integer NOT NULL, "participant_id" integer NOT NULL, "created_at" timestamp, "updated_at" timestamp) SQL (0.2ms) INSERT INTO "schema_migrations" ("version") VALUES ($1) [["version", "20141020190824"]]  (0.5ms) COMMIT Migrating to CreateUsers (20141020191622)  (0.2ms) BEGIN  (3.2ms) CREATE TABLE "users" ("id" serial primary key, "email" character varying(255), "created_at" timestamp, "updated_at" timestamp) SQL (0.2ms) INSERT INTO "schema_migrations" ("version") VALUES ($1) [["version", "20141020191622"]]  (0.4ms) COMMIT Migrating to CreateGroups (20141020191754)  (0.2ms) BEGIN  (2.4ms) CREATE TABLE "groups" ("id" serial primary key, "title" character varying(255), "created_at" timestamp, "updated_at" timestamp) SQL (0.2ms) INSERT INTO "schema_migrations" ("version") VALUES ($1) [["version", "20141020191754"]]  (0.4ms) COMMIT Migrating to AddColumnIsAdminToUsers (20141104135632)  (0.2ms) BEGIN  (2.8ms) ALTER TABLE "users" ADD COLUMN "is_admin" boolean DEFAULT 'f' NOT NULL SQL (0.2ms) INSERT INTO "schema_migrations" ("version") VALUES ($1) [["version", "20141104135632"]]  (1.0ms) COMMIT Migrating to CreateUserRoles (20141104141420)  (0.3ms) BEGIN  (8.0ms) CREATE TABLE "user_roles" ("id" serial primary key, "user_id" integer, "role_class_name" character varying(255), "created_at" timestamp, "updated_at" timestamp) SQL (0.2ms) INSERT INTO "schema_migrations" ("version") VALUES ($1) [["version", "20141104141420"]]  (0.4ms) COMMIT Migrating to CreateThinkFeelDoDashboardModerators (20141105203408)  (0.2ms) BEGIN  (4.2ms) CREATE TABLE "think_feel_do_dashboard_moderators" ("id" serial primary key, "group_id" integer NOT NULL, "user_id" integer NOT NULL, "created_at" timestamp, "updated_at" timestamp) SQL (0.4ms) INSERT INTO "schema_migrations" ("version") VALUES ($1) [["version", "20141105203408"]]  (0.6ms) COMMIT Migrating to AddColumnDisplayNameToParticipants (20141106202954)  (0.4ms) BEGIN  (6.3ms) ALTER TABLE "participants" ADD COLUMN "display_name" character varying(255) DEFAULT '' NOT NULL SQL (0.2ms) INSERT INTO "schema_migrations" ("version") VALUES ($1) [["version", "20141106202954"]]  (1.4ms) COMMIT Migrating to AddColumnContactPreferenceToParticipant (20141106211650)  (0.2ms) BEGIN  (5.8ms) ALTER TABLE "participants" ADD COLUMN "contact_preference" character varying(255) DEFAULT '' SQL (0.2ms) INSERT INTO "schema_migrations" ("version") VALUES ($1) [["version", "20141106211650"]]  (1.0ms) COMMIT Migrating to AddColumnsToUser (20141107170701)  (0.2ms) BEGIN  (1.7ms) ALTER TABLE "users" ADD COLUMN "password" character varying(255)  (0.4ms) ALTER TABLE "users" ADD COLUMN "password_confirmation" character varying(255) SQL (0.2ms) INSERT INTO "schema_migrations" ("version") VALUES ($1) [["version", "20141107170701"]]  (0.4ms) COMMIT Migrating to AddColumnsPasswordAndPasswordConfirmationToParticipants (20141111140835)  (0.1ms) BEGIN  (0.3ms) ALTER TABLE "participants" ADD COLUMN "password" character varying(255)  (0.2ms) ALTER TABLE "participants" ADD COLUMN "password_confirmation" character varying(255) SQL (0.2ms) INSERT INTO "schema_migrations" ("version") VALUES ($1) [["version", "20141111140835"]]  (0.3ms) COMMIT Migrating to CreateArms (20141120202053)  (0.1ms) BEGIN  (3.4ms) CREATE TABLE "arms" ("id" serial primary key, "title" character varying(255) DEFAULT '', "is_social" boolean DEFAULT 'f', "created_at" timestamp, "updated_at" timestamp) SQL (0.2ms) INSERT INTO "schema_migrations" ("version") VALUES ($1) [["version", "20141120202053"]]  (0.4ms) COMMIT Migrating to AddArmIdToGroups (20141121201134)  (0.2ms) BEGIN  (0.3ms) ALTER TABLE "groups" ADD COLUMN "arm_id" integer SQL (0.2ms) INSERT INTO "schema_migrations" ("version") VALUES ($1) [["version", "20141121201134"]]  (0.3ms) COMMIT Migrating to AddDeviseToUsers (20141125225148)  (0.1ms) BEGIN  (3.4ms) ALTER TABLE "users" ADD COLUMN "encrypted_password" character varying(255) DEFAULT '' NOT NULL  (0.2ms) ALTER TABLE "users" ADD COLUMN "reset_password_token" character varying(255)  (0.2ms) ALTER TABLE "users" ADD COLUMN "reset_password_sent_at" timestamp  (0.2ms) ALTER TABLE "users" ADD COLUMN "remember_created_at" timestamp  (3.5ms) ALTER TABLE "users" ADD COLUMN "sign_in_count" integer DEFAULT 0 NOT NULL  (0.2ms) ALTER TABLE "users" ADD COLUMN "current_sign_in_at" timestamp  (0.3ms) ALTER TABLE "users" ADD COLUMN "last_sign_in_at" timestamp  (0.3ms) ALTER TABLE "users" ADD COLUMN "current_sign_in_ip" inet  (0.3ms) ALTER TABLE "users" ADD COLUMN "last_sign_in_ip" inet  (1.2ms) CREATE UNIQUE INDEX "index_users_on_email" ON "users" ("email")  (2.0ms) CREATE UNIQUE INDEX "index_users_on_reset_password_token" ON "users" ("reset_password_token") SQL (0.3ms) INSERT INTO "schema_migrations" ("version") VALUES ($1) [["version", "20141125225148"]]  (1.6ms) COMMIT Migrating to CreateSlideshowAnchors (20141125230628)  (0.3ms) BEGIN  (2.6ms) CREATE TABLE "slideshow_anchors" ("id" serial primary key, "bit_core_slideshow_id" integer, "target_name" character varying(255), "created_at" timestamp, "updated_at" timestamp) SQL (0.2ms) INSERT INTO "schema_migrations" ("version") VALUES ($1) [["version", "20141125230628"]]  (0.4ms) COMMIT Migrating to RemoveColumnsPasswordAndPasswordConfirmationFromUsers (20141126151510)  (0.2ms) BEGIN  (0.5ms) ALTER TABLE "users" DROP "password"  (0.4ms) ALTER TABLE "users" DROP "password_confirmation" SQL (0.2ms) INSERT INTO "schema_migrations" ("version") VALUES ($1) [["version", "20141126151510"]]  (0.4ms) COMMIT Migrating to AddDeviseToParticipants (20141203195016)  (0.1ms) BEGIN  (5.7ms) ALTER TABLE "participants" ADD COLUMN "encrypted_password" character varying(255) DEFAULT '' NOT NULL  (0.3ms) ALTER TABLE "participants" ADD COLUMN "reset_password_token" character varying(255)  (0.2ms) ALTER TABLE "participants" ADD COLUMN "reset_password_sent_at" timestamp  (0.2ms) ALTER TABLE "participants" ADD COLUMN "remember_created_at" timestamp  (5.2ms) ALTER TABLE "participants" ADD COLUMN "sign_in_count" integer DEFAULT 0 NOT NULL  (0.4ms) ALTER TABLE "participants" ADD COLUMN "current_sign_in_at" timestamp  (0.2ms) ALTER TABLE "participants" ADD COLUMN "last_sign_in_at" timestamp  (0.2ms) ALTER TABLE "participants" ADD COLUMN "current_sign_in_ip" inet  (0.2ms) ALTER TABLE "participants" ADD COLUMN "last_sign_in_ip" inet  (1.3ms) CREATE UNIQUE INDEX "index_participants_on_reset_password_token" ON "participants" ("reset_password_token") SQL (0.2ms) INSERT INTO "schema_migrations" ("version") VALUES ($1) [["version", "20141203195016"]]  (2.2ms) COMMIT Migrating to RemovePasswordFromParticipants (20141203201524)  (0.4ms) BEGIN  (0.5ms) ALTER TABLE "participants" DROP "password"  (0.3ms) ALTER TABLE "participants" DROP "password_confirmation" SQL (0.2ms) INSERT INTO "schema_migrations" ("version") VALUES ($1) [["version", "20141203201524"]]  (0.3ms) COMMIT Migrating to AddHasWozToArm (20141214203919)  (0.1ms) BEGIN  (2.2ms) ALTER TABLE "arms" ADD COLUMN "has_woz" boolean DEFAULT 'f' SQL (0.2ms) INSERT INTO "schema_migrations" ("version") VALUES ($1) [["version", "20141214203919"]]  (0.6ms) COMMIT ActiveRecord::SchemaMigration Load (0.4ms) SELECT "schema_migrations".* FROM "schema_migrations"  (116.0ms) DROP DATABASE IF EXISTS "dummy_test"  (234.7ms) CREATE DATABASE "dummy_test" ENCODING = 'unicode'  (116.0ms) DROP DATABASE IF EXISTS "dummy_test"  (234.2ms) CREATE DATABASE "dummy_test" ENCODING = 'unicode' SQL (0.3ms) CREATE EXTENSION IF NOT EXISTS "plpgsql"  (5.6ms) CREATE TABLE "arms" ("id" serial primary key, "title" character varying(255) DEFAULT '', "is_social" boolean DEFAULT 'f', "created_at" timestamp, "updated_at" timestamp, "has_woz" boolean DEFAULT 'f')  (2.8ms) CREATE TABLE "coach_assignments" ("id" serial primary key, "coach_id" integer NOT NULL, "participant_id" integer NOT NULL, "created_at" timestamp, "updated_at" timestamp)   (2.9ms) CREATE TABLE "groups" ("id" serial primary key, "title" character varying(255), "created_at" timestamp, "updated_at" timestamp, "arm_id" integer)  (3.0ms) CREATE TABLE "memberships" ("id" serial primary key, "group_id" integer NOT NULL, "participant_id" integer NOT NULL, "end_date" date, "start_date" date, "created_at" timestamp, "updated_at" timestamp)   (5.0ms) CREATE TABLE "participants" ("id" serial primary key, "email" character varying(255) DEFAULT '' NOT NULL, "phone_number" character varying(255), "study_id" character varying(255), "created_at" timestamp, "updated_at" timestamp, "display_name" character varying(255) DEFAULT '' NOT NULL, "contact_preference" character varying(255) DEFAULT '', "encrypted_password" character varying(255) DEFAULT '' NOT NULL, "reset_password_token" character varying(255), "reset_password_sent_at" timestamp, "remember_created_at" timestamp, "sign_in_count" integer DEFAULT 0 NOT NULL, "current_sign_in_at" timestamp, "last_sign_in_at" timestamp, "current_sign_in_ip" inet, "last_sign_in_ip" inet)  (1.5ms) CREATE UNIQUE INDEX "index_participants_on_email" ON "participants" USING btree ("email")  (1.1ms) CREATE UNIQUE INDEX "index_participants_on_phone_number" ON "participants" USING btree ("phone_number")  (1.3ms) CREATE UNIQUE INDEX "index_participants_on_reset_password_token" ON "participants" USING btree ("reset_password_token")  (1.1ms) CREATE UNIQUE INDEX "index_participants_on_study_id" ON "participants" USING btree ("study_id")  (2.8ms) CREATE TABLE "slideshow_anchors" ("id" serial primary key, "bit_core_slideshow_id" integer, "target_name" character varying(255), "created_at" timestamp, "updated_at" timestamp)   (2.7ms) CREATE TABLE "think_feel_do_dashboard_moderators" ("id" serial primary key, "group_id" integer NOT NULL, "user_id" integer NOT NULL, "created_at" timestamp, "updated_at" timestamp)  (2.9ms) CREATE TABLE "user_roles" ("id" serial primary key, "user_id" integer, "role_class_name" character varying(255), "created_at" timestamp, "updated_at" timestamp)   (4.1ms) CREATE TABLE "users" ("id" serial primary key, "email" character varying(255), "created_at" timestamp, "updated_at" timestamp, "is_admin" boolean DEFAULT 'f' NOT NULL, "encrypted_password" character varying(255) DEFAULT '' NOT NULL, "reset_password_token" character varying(255), "reset_password_sent_at" timestamp, "remember_created_at" timestamp, "sign_in_count" integer DEFAULT 0 NOT NULL, "current_sign_in_at" timestamp, "last_sign_in_at" timestamp, "current_sign_in_ip" inet, "last_sign_in_ip" inet)  (1.1ms) CREATE UNIQUE INDEX "index_users_on_email" ON "users" USING btree ("email")  (1.2ms) CREATE UNIQUE INDEX "index_users_on_reset_password_token" ON "users" USING btree ("reset_password_token")  (0.9ms) CREATE TABLE "schema_migrations" ("version" character varying(255) NOT NULL)   (1.1ms) CREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")  (0.3ms) SELECT version FROM "schema_migrations"  (0.5ms) INSERT INTO "schema_migrations" (version) VALUES ('20141214203919')  (0.5ms) INSERT INTO "schema_migrations" (version) VALUES ('20141020185953')  (0.4ms) INSERT INTO "schema_migrations" (version) VALUES ('20141020190822')  (0.4ms) INSERT INTO "schema_migrations" (version) VALUES ('20141020190824')  (0.4ms) INSERT INTO "schema_migrations" (version) VALUES ('20141020191622')  (0.3ms) INSERT INTO "schema_migrations" (version) VALUES ('20141020191754')  (0.4ms) INSERT INTO "schema_migrations" (version) VALUES ('20141104135632')  (0.3ms) INSERT INTO "schema_migrations" (version) VALUES ('20141104141420')  (0.3ms) INSERT INTO "schema_migrations" (version) VALUES ('20141107170701')  (0.4ms) INSERT INTO "schema_migrations" (version) VALUES ('20141111140835')  (0.3ms) INSERT INTO "schema_migrations" (version) VALUES ('20141120202053')  (0.3ms) INSERT INTO "schema_migrations" (version) VALUES ('20141121201134')  (0.3ms) INSERT INTO "schema_migrations" (version) VALUES ('20141125225148')  (0.2ms) INSERT INTO "schema_migrations" (version) VALUES ('20141125230628')  (0.3ms) INSERT INTO "schema_migrations" (version) VALUES ('20141126151510')  (0.2ms) INSERT INTO "schema_migrations" (version) VALUES ('20141203195016')  (0.3ms) INSERT INTO "schema_migrations" (version) VALUES ('20141203201524')  (0.2ms) INSERT INTO "schema_migrations" (version) VALUES ('20141105203408')  (0.3ms) INSERT INTO "schema_migrations" (version) VALUES ('20141106202954')  (0.2ms) INSERT INTO "schema_migrations" (version) VALUES ('20141106211650')  (2.8ms) CREATE TABLE "schema_migrations" ("version" character varying(255) NOT NULL)   (1.9ms) CREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version") ActiveRecord::SchemaMigration Load (0.4ms) SELECT "schema_migrations".* FROM "schema_migrations" Migrating to CreateParticipants (20141020185953)  (0.1ms) BEGIN  (5.1ms) CREATE TABLE "participants" ("id" serial primary key, "email" character varying(255) DEFAULT '' NOT NULL, "phone_number" character varying(255), "study_id" character varying(255), "created_at" timestamp, "updated_at" timestamp)   (1.1ms) CREATE UNIQUE INDEX "index_participants_on_email" ON "participants" ("email")  (1.0ms) CREATE UNIQUE INDEX "index_participants_on_phone_number" ON "participants" ("phone_number")  (1.0ms) CREATE UNIQUE INDEX "index_participants_on_study_id" ON "participants" ("study_id") SQL (0.3ms) INSERT INTO "schema_migrations" ("version") VALUES ($1) [["version", "20141020185953"]]  (0.5ms) COMMIT Migrating to CreateMemberships (20141020190822)  (0.3ms) BEGIN  (2.5ms) CREATE TABLE "memberships" ("id" serial primary key, "group_id" integer NOT NULL, "participant_id" integer NOT NULL, "end_date" date, "start_date" date, "created_at" timestamp, "updated_at" timestamp) SQL (0.2ms) INSERT INTO "schema_migrations" ("version") VALUES ($1) [["version", "20141020190822"]]  (0.5ms) COMMIT Migrating to CreateCoachAssignments (20141020190824)  (0.2ms) BEGIN  (2.5ms) CREATE TABLE "coach_assignments" ("id" serial primary key, "coach_id" integer NOT NULL, "participant_id" integer NOT NULL, "created_at" timestamp, "updated_at" timestamp) SQL (0.2ms) INSERT INTO "schema_migrations" ("version") VALUES ($1) [["version", "20141020190824"]]  (0.4ms) COMMIT Migrating to CreateUsers (20141020191622)  (0.3ms) BEGIN  (2.4ms) CREATE TABLE "users" ("id" serial primary key, "email" character varying(255), "created_at" timestamp, "updated_at" timestamp) SQL (0.2ms) INSERT INTO "schema_migrations" ("version") VALUES ($1) [["version", "20141020191622"]]  (0.5ms) COMMIT Migrating to CreateGroups (20141020191754)  (0.2ms) BEGIN  (2.3ms) CREATE TABLE "groups" ("id" serial primary key, "title" character varying(255), "created_at" timestamp, "updated_at" timestamp) SQL (0.2ms) INSERT INTO "schema_migrations" ("version") VALUES ($1) [["version", "20141020191754"]]  (0.5ms) COMMIT Migrating to AddColumnIsAdminToUsers (20141104135632)  (0.2ms) BEGIN  (2.7ms) ALTER TABLE "users" ADD COLUMN "is_admin" boolean DEFAULT 'f' NOT NULL SQL (0.2ms) INSERT INTO "schema_migrations" ("version") VALUES ($1) [["version", "20141104135632"]]  (1.1ms) COMMIT Migrating to CreateUserRoles (20141104141420)  (0.3ms) BEGIN  (5.7ms) CREATE TABLE "user_roles" ("id" serial primary key, "user_id" integer, "role_class_name" character varying(255), "created_at" timestamp, "updated_at" timestamp) SQL (0.3ms) INSERT INTO "schema_migrations" ("version") VALUES ($1) [["version", "20141104141420"]]  (0.4ms) COMMIT Migrating to CreateThinkFeelDoDashboardModerators (20141105203408)  (0.3ms) BEGIN  (4.5ms) CREATE TABLE "think_feel_do_dashboard_moderators" ("id" serial primary key, "group_id" integer NOT NULL, "user_id" integer NOT NULL, "created_at" timestamp, "updated_at" timestamp) SQL (0.5ms) INSERT INTO "schema_migrations" ("version") VALUES ($1) [["version", "20141105203408"]]  (0.6ms) COMMIT Migrating to AddColumnDisplayNameToParticipants (20141106202954)  (0.6ms) BEGIN  (6.5ms) ALTER TABLE "participants" ADD COLUMN "display_name" character varying(255) DEFAULT '' NOT NULL SQL (0.2ms) INSERT INTO "schema_migrations" ("version") VALUES ($1) [["version", "20141106202954"]]  (1.0ms) COMMIT Migrating to AddColumnContactPreferenceToParticipant (20141106211650)  (0.2ms) BEGIN  (5.7ms) ALTER TABLE "participants" ADD COLUMN "contact_preference" character varying(255) DEFAULT '' SQL (0.3ms) INSERT INTO "schema_migrations" ("version") VALUES ($1) [["version", "20141106211650"]]  (1.1ms) COMMIT Migrating to AddColumnsToUser (20141107170701)  (0.2ms) BEGIN  (1.5ms) ALTER TABLE "users" ADD COLUMN "password" character varying(255)  (0.3ms) ALTER TABLE "users" ADD COLUMN "password_confirmation" character varying(255) SQL (0.2ms) INSERT INTO "schema_migrations" ("version") VALUES ($1) [["version", "20141107170701"]]  (0.4ms) COMMIT Migrating to AddColumnsPasswordAndPasswordConfirmationToParticipants (20141111140835)  (0.1ms) BEGIN  (0.6ms) ALTER TABLE "participants" ADD COLUMN "password" character varying(255)  (0.4ms) ALTER TABLE "participants" ADD COLUMN "password_confirmation" character varying(255) SQL (0.2ms) INSERT INTO "schema_migrations" ("version") VALUES ($1) [["version", "20141111140835"]]  (0.3ms) COMMIT Migrating to CreateArms (20141120202053)  (0.1ms) BEGIN  (2.9ms) CREATE TABLE "arms" ("id" serial primary key, "title" character varying(255) DEFAULT '', "is_social" boolean DEFAULT 'f', "created_at" timestamp, "updated_at" timestamp) SQL (0.2ms) INSERT INTO "schema_migrations" ("version") VALUES ($1) [["version", "20141120202053"]]  (0.4ms) COMMIT Migrating to AddArmIdToGroups (20141121201134)  (0.2ms) BEGIN  (0.3ms) ALTER TABLE "groups" ADD COLUMN "arm_id" integer SQL (0.2ms) INSERT INTO "schema_migrations" ("version") VALUES ($1) [["version", "20141121201134"]]  (0.3ms) COMMIT Migrating to AddDeviseToUsers (20141125225148)  (0.1ms) BEGIN  (3.7ms) ALTER TABLE "users" ADD COLUMN "encrypted_password" character varying(255) DEFAULT '' NOT NULL  (0.2ms) ALTER TABLE "users" ADD COLUMN "reset_password_token" character varying(255)  (0.2ms) ALTER TABLE "users" ADD COLUMN "reset_password_sent_at" timestamp  (0.2ms) ALTER TABLE "users" ADD COLUMN "remember_created_at" timestamp  (5.3ms) ALTER TABLE "users" ADD COLUMN "sign_in_count" integer DEFAULT 0 NOT NULL  (0.3ms) ALTER TABLE "users" ADD COLUMN "current_sign_in_at" timestamp  (0.3ms) ALTER TABLE "users" ADD COLUMN "last_sign_in_at" timestamp  (0.3ms) ALTER TABLE "users" ADD COLUMN "current_sign_in_ip" inet  (0.5ms) ALTER TABLE "users" ADD COLUMN "last_sign_in_ip" inet  (1.3ms) CREATE UNIQUE INDEX "index_users_on_email" ON "users" ("email")  (1.7ms) CREATE UNIQUE INDEX "index_users_on_reset_password_token" ON "users" ("reset_password_token") SQL (0.2ms) INSERT INTO "schema_migrations" ("version") VALUES ($1) [["version", "20141125225148"]]  (1.8ms) COMMIT Migrating to CreateSlideshowAnchors (20141125230628)  (0.4ms) BEGIN  (2.4ms) CREATE TABLE "slideshow_anchors" ("id" serial primary key, "bit_core_slideshow_id" integer, "target_name" character varying(255), "created_at" timestamp, "updated_at" timestamp) SQL (0.2ms) INSERT INTO "schema_migrations" ("version") VALUES ($1) [["version", "20141125230628"]]  (0.5ms) COMMIT Migrating to RemoveColumnsPasswordAndPasswordConfirmationFromUsers (20141126151510)  (0.2ms) BEGIN  (0.5ms) ALTER TABLE "users" DROP "password"  (0.2ms) ALTER TABLE "users" DROP "password_confirmation" SQL (0.2ms) INSERT INTO "schema_migrations" ("version") VALUES ($1) [["version", "20141126151510"]]  (0.4ms) COMMIT Migrating to AddDeviseToParticipants (20141203195016)  (0.1ms) BEGIN  (5.6ms) ALTER TABLE "participants" ADD COLUMN "encrypted_password" character varying(255) DEFAULT '' NOT NULL  (0.3ms) ALTER TABLE "participants" ADD COLUMN "reset_password_token" character varying(255)  (0.2ms) ALTER TABLE "participants" ADD COLUMN "reset_password_sent_at" timestamp  (0.2ms) ALTER TABLE "participants" ADD COLUMN "remember_created_at" timestamp  (7.2ms) ALTER TABLE "participants" ADD COLUMN "sign_in_count" integer DEFAULT 0 NOT NULL  (0.4ms) ALTER TABLE "participants" ADD COLUMN "current_sign_in_at" timestamp  (0.2ms) ALTER TABLE "participants" ADD COLUMN "last_sign_in_at" timestamp  (0.2ms) ALTER TABLE "participants" ADD COLUMN "current_sign_in_ip" inet  (0.2ms) ALTER TABLE "participants" ADD COLUMN "last_sign_in_ip" inet  (0.9ms) CREATE UNIQUE INDEX "index_participants_on_reset_password_token" ON "participants" ("reset_password_token") SQL (0.2ms) INSERT INTO "schema_migrations" ("version") VALUES ($1) [["version", "20141203195016"]]  (2.5ms) COMMIT Migrating to RemovePasswordFromParticipants (20141203201524)  (0.3ms) BEGIN  (0.4ms) ALTER TABLE "participants" DROP "password"  (0.2ms) ALTER TABLE "participants" DROP "password_confirmation" SQL (0.2ms) INSERT INTO "schema_migrations" ("version") VALUES ($1) [["version", "20141203201524"]]  (0.3ms) COMMIT Migrating to AddHasWozToArm (20141214203919)  (0.1ms) BEGIN  (2.1ms) ALTER TABLE "arms" ADD COLUMN "has_woz" boolean DEFAULT 'f' SQL (0.2ms) INSERT INTO "schema_migrations" ("version") VALUES ($1) [["version", "20141214203919"]]  (0.6ms) COMMIT ActiveRecord::SchemaMigration Load (0.4ms) SELECT "schema_migrations".* FROM "schema_migrations"  (118.2ms) DROP DATABASE IF EXISTS "dummy_test"  (235.1ms) CREATE DATABASE "dummy_test" ENCODING = 'unicode'  (112.0ms) DROP DATABASE IF EXISTS "dummy_test"  (239.2ms) CREATE DATABASE "dummy_test" ENCODING = 'unicode' SQL (0.3ms) CREATE EXTENSION IF NOT EXISTS "plpgsql"  (5.6ms) CREATE TABLE "arms" ("id" serial primary key, "title" character varying(255) DEFAULT '', "is_social" boolean DEFAULT 'f', "created_at" timestamp, "updated_at" timestamp, "has_woz" boolean DEFAULT 'f')  (2.7ms) CREATE TABLE "coach_assignments" ("id" serial primary key, "coach_id" integer NOT NULL, "participant_id" integer NOT NULL, "created_at" timestamp, "updated_at" timestamp)   (2.6ms) CREATE TABLE "groups" ("id" serial primary key, "title" character varying(255), "created_at" timestamp, "updated_at" timestamp, "arm_id" integer)  (2.9ms) CREATE TABLE "memberships" ("id" serial primary key, "group_id" integer NOT NULL, "participant_id" integer NOT NULL, "end_date" date, "start_date" date, "created_at" timestamp, "updated_at" timestamp)   (4.9ms) CREATE TABLE "participants" ("id" serial primary key, "email" character varying(255) DEFAULT '' NOT NULL, "phone_number" character varying(255), "study_id" character varying(255), "created_at" timestamp, "updated_at" timestamp, "display_name" character varying(255) DEFAULT '' NOT NULL, "contact_preference" character varying(255) DEFAULT '', "encrypted_password" character varying(255) DEFAULT '' NOT NULL, "reset_password_token" character varying(255), "reset_password_sent_at" timestamp, "remember_created_at" timestamp, "sign_in_count" integer DEFAULT 0 NOT NULL, "current_sign_in_at" timestamp, "last_sign_in_at" timestamp, "current_sign_in_ip" inet, "last_sign_in_ip" inet)  (1.6ms) CREATE UNIQUE INDEX "index_participants_on_email" ON "participants" USING btree ("email")  (1.2ms) CREATE UNIQUE INDEX "index_participants_on_phone_number" ON "participants" USING btree ("phone_number")  (1.3ms) CREATE UNIQUE INDEX "index_participants_on_reset_password_token" ON "participants" USING btree ("reset_password_token")  (1.1ms) CREATE UNIQUE INDEX "index_participants_on_study_id" ON "participants" USING btree ("study_id")  (3.3ms) CREATE TABLE "slideshow_anchors" ("id" serial primary key, "bit_core_slideshow_id" integer, "target_name" character varying(255), "created_at" timestamp, "updated_at" timestamp)   (2.7ms) CREATE TABLE "think_feel_do_dashboard_moderators" ("id" serial primary key, "group_id" integer NOT NULL, "user_id" integer NOT NULL, "created_at" timestamp, "updated_at" timestamp)  (2.7ms) CREATE TABLE "user_roles" ("id" serial primary key, "user_id" integer, "role_class_name" character varying(255), "created_at" timestamp, "updated_at" timestamp)   (4.0ms) CREATE TABLE "users" ("id" serial primary key, "email" character varying(255), "created_at" timestamp, "updated_at" timestamp, "is_admin" boolean DEFAULT 'f' NOT NULL, "encrypted_password" character varying(255) DEFAULT '' NOT NULL, "reset_password_token" character varying(255), "reset_password_sent_at" timestamp, "remember_created_at" timestamp, "sign_in_count" integer DEFAULT 0 NOT NULL, "current_sign_in_at" timestamp, "last_sign_in_at" timestamp, "current_sign_in_ip" inet, "last_sign_in_ip" inet)  (1.1ms) CREATE UNIQUE INDEX "index_users_on_email" ON "users" USING btree ("email")  (1.1ms) CREATE UNIQUE INDEX "index_users_on_reset_password_token" ON "users" USING btree ("reset_password_token")  (1.0ms) CREATE TABLE "schema_migrations" ("version" character varying(255) NOT NULL)   (1.2ms) CREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")  (0.5ms) SELECT version FROM "schema_migrations"  (0.6ms) INSERT INTO "schema_migrations" (version) VALUES ('20141214203919')  (0.5ms) INSERT INTO "schema_migrations" (version) VALUES ('20141020185953')  (0.3ms) INSERT INTO "schema_migrations" (version) VALUES ('20141020190822')  (0.4ms) INSERT INTO "schema_migrations" (version) VALUES ('20141020190824')  (0.3ms) INSERT INTO "schema_migrations" (version) VALUES ('20141020191622')  (0.3ms) INSERT INTO "schema_migrations" (version) VALUES ('20141020191754')  (0.3ms) INSERT INTO "schema_migrations" (version) VALUES ('20141104135632')  (0.3ms) INSERT INTO "schema_migrations" (version) VALUES ('20141104141420')  (0.3ms) INSERT INTO "schema_migrations" (version) VALUES ('20141107170701')  (0.3ms) INSERT INTO "schema_migrations" (version) VALUES ('20141111140835')  (0.3ms) INSERT INTO "schema_migrations" (version) VALUES ('20141120202053')  (0.2ms) INSERT INTO "schema_migrations" (version) VALUES ('20141121201134')  (0.3ms) INSERT INTO "schema_migrations" (version) VALUES ('20141125225148')  (0.4ms) INSERT INTO "schema_migrations" (version) VALUES ('20141125230628')  (0.3ms) INSERT INTO "schema_migrations" (version) VALUES ('20141126151510')  (0.2ms) INSERT INTO "schema_migrations" (version) VALUES ('20141203195016')  (0.2ms) INSERT INTO "schema_migrations" (version) VALUES ('20141203201524')  (0.2ms) INSERT INTO "schema_migrations" (version) VALUES ('20141105203408')  (0.3ms) INSERT INTO "schema_migrations" (version) VALUES ('20141106202954')  (0.3ms) INSERT INTO "schema_migrations" (version) VALUES ('20141106211650')  (2.6ms) CREATE TABLE "schema_migrations" ("version" character varying(255) NOT NULL)   (1.7ms) CREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version") ActiveRecord::SchemaMigration Load (0.4ms) SELECT "schema_migrations".* FROM "schema_migrations" Migrating to CreateParticipants (20141020185953)  (0.1ms) BEGIN  (4.6ms) CREATE TABLE "participants" ("id" serial primary key, "email" character varying(255) DEFAULT '' NOT NULL, "phone_number" character varying(255), "study_id" character varying(255), "created_at" timestamp, "updated_at" timestamp)   (1.2ms) CREATE UNIQUE INDEX "index_participants_on_email" ON "participants" ("email")  (0.9ms) CREATE UNIQUE INDEX "index_participants_on_phone_number" ON "participants" ("phone_number")  (1.0ms) CREATE UNIQUE INDEX "index_participants_on_study_id" ON "participants" ("study_id") SQL (0.4ms) INSERT INTO "schema_migrations" ("version") VALUES ($1) [["version", "20141020185953"]]  (0.6ms) COMMIT Migrating to CreateMemberships (20141020190822)  (0.3ms) BEGIN  (2.7ms) CREATE TABLE "memberships" ("id" serial primary key, "group_id" integer NOT NULL, "participant_id" integer NOT NULL, "end_date" date, "start_date" date, "created_at" timestamp, "updated_at" timestamp) SQL (0.2ms) INSERT INTO "schema_migrations" ("version") VALUES ($1) [["version", "20141020190822"]]  (0.5ms) COMMIT Migrating to CreateCoachAssignments (20141020190824)  (0.2ms) BEGIN  (2.3ms) CREATE TABLE "coach_assignments" ("id" serial primary key, "coach_id" integer NOT NULL, "participant_id" integer NOT NULL, "created_at" timestamp, "updated_at" timestamp) SQL (0.2ms) INSERT INTO "schema_migrations" ("version") VALUES ($1) [["version", "20141020190824"]]  (0.4ms) COMMIT Migrating to CreateUsers (20141020191622)  (0.2ms) BEGIN  (2.4ms) CREATE TABLE "users" ("id" serial primary key, "email" character varying(255), "created_at" timestamp, "updated_at" timestamp) SQL (0.2ms) INSERT INTO "schema_migrations" ("version") VALUES ($1) [["version", "20141020191622"]]  (0.5ms) COMMIT Migrating to CreateGroups (20141020191754)  (0.3ms) BEGIN  (2.2ms) CREATE TABLE "groups" ("id" serial primary key, "title" character varying(255), "created_at" timestamp, "updated_at" timestamp) SQL (0.2ms) INSERT INTO "schema_migrations" ("version") VALUES ($1) [["version", "20141020191754"]]  (0.4ms) COMMIT Migrating to AddColumnIsAdminToUsers (20141104135632)  (0.2ms) BEGIN  (2.6ms) ALTER TABLE "users" ADD COLUMN "is_admin" boolean DEFAULT 'f' NOT NULL SQL (0.2ms) INSERT INTO "schema_migrations" ("version") VALUES ($1) [["version", "20141104135632"]]  (0.9ms) COMMIT Migrating to CreateUserRoles (20141104141420)  (0.2ms) BEGIN  (5.6ms) CREATE TABLE "user_roles" ("id" serial primary key, "user_id" integer, "role_class_name" character varying(255), "created_at" timestamp, "updated_at" timestamp) SQL (0.2ms) INSERT INTO "schema_migrations" ("version") VALUES ($1) [["version", "20141104141420"]]  (0.4ms) COMMIT Migrating to CreateThinkFeelDoDashboardModerators (20141105203408)  (0.2ms) BEGIN  (2.1ms) CREATE TABLE "think_feel_do_dashboard_moderators" ("id" serial primary key, "group_id" integer NOT NULL, "user_id" integer NOT NULL, "created_at" timestamp, "updated_at" timestamp) SQL (0.2ms) INSERT INTO "schema_migrations" ("version") VALUES ($1) [["version", "20141105203408"]]  (0.3ms) COMMIT Migrating to AddColumnDisplayNameToParticipants (20141106202954)  (0.2ms) BEGIN  (5.0ms) ALTER TABLE "participants" ADD COLUMN "display_name" character varying(255) DEFAULT '' NOT NULL SQL (0.4ms) INSERT INTO "schema_migrations" ("version") VALUES ($1) [["version", "20141106202954"]]  (1.7ms) COMMIT Migrating to AddColumnContactPreferenceToParticipant (20141106211650)  (0.2ms) BEGIN  (8.6ms) ALTER TABLE "participants" ADD COLUMN "contact_preference" character varying(255) DEFAULT '' SQL (0.2ms) INSERT INTO "schema_migrations" ("version") VALUES ($1) [["version", "20141106211650"]]  (1.2ms) COMMIT Migrating to AddColumnsToUser (20141107170701)  (0.3ms) BEGIN  (1.6ms) ALTER TABLE "users" ADD COLUMN "password" character varying(255)  (0.3ms) ALTER TABLE "users" ADD COLUMN "password_confirmation" character varying(255) SQL (0.1ms) INSERT INTO "schema_migrations" ("version") VALUES ($1) [["version", "20141107170701"]]  (0.4ms) COMMIT Migrating to AddColumnsPasswordAndPasswordConfirmationToParticipants (20141111140835)  (0.1ms) BEGIN  (0.3ms) ALTER TABLE "participants" ADD COLUMN "password" character varying(255)  (0.3ms) ALTER TABLE "participants" ADD COLUMN "password_confirmation" character varying(255) SQL (0.2ms) INSERT INTO "schema_migrations" ("version") VALUES ($1) [["version", "20141111140835"]]  (0.4ms) COMMIT Migrating to CreateArms (20141120202053)  (0.1ms) BEGIN  (2.8ms) CREATE TABLE "arms" ("id" serial primary key, "title" character varying(255) DEFAULT '', "is_social" boolean DEFAULT 'f', "created_at" timestamp, "updated_at" timestamp) SQL (0.2ms) INSERT INTO "schema_migrations" ("version") VALUES ($1) [["version", "20141120202053"]]  (0.4ms) COMMIT Migrating to AddArmIdToGroups (20141121201134)  (0.2ms) BEGIN  (0.3ms) ALTER TABLE "groups" ADD COLUMN "arm_id" integer SQL (0.2ms) INSERT INTO "schema_migrations" ("version") VALUES ($1) [["version", "20141121201134"]]  (0.4ms) COMMIT Migrating to AddDeviseToUsers (20141125225148)  (0.1ms) BEGIN  (4.1ms) ALTER TABLE "users" ADD COLUMN "encrypted_password" character varying(255) DEFAULT '' NOT NULL  (0.3ms) ALTER TABLE "users" ADD COLUMN "reset_password_token" character varying(255)  (0.2ms) ALTER TABLE "users" ADD COLUMN "reset_password_sent_at" timestamp  (0.2ms) ALTER TABLE "users" ADD COLUMN "remember_created_at" timestamp  (3.9ms) ALTER TABLE "users" ADD COLUMN "sign_in_count" integer DEFAULT 0 NOT NULL  (0.3ms) ALTER TABLE "users" ADD COLUMN "current_sign_in_at" timestamp  (0.2ms) ALTER TABLE "users" ADD COLUMN "last_sign_in_at" timestamp  (0.2ms) ALTER TABLE "users" ADD COLUMN "current_sign_in_ip" inet  (0.2ms) ALTER TABLE "users" ADD COLUMN "last_sign_in_ip" inet  (0.9ms) CREATE UNIQUE INDEX "index_users_on_email" ON "users" ("email")  (0.9ms) CREATE UNIQUE INDEX "index_users_on_reset_password_token" ON "users" ("reset_password_token") SQL (0.2ms) INSERT INTO "schema_migrations" ("version") VALUES ($1) [["version", "20141125225148"]]  (1.1ms) COMMIT Migrating to CreateSlideshowAnchors (20141125230628)  (0.2ms) BEGIN  (2.2ms) CREATE TABLE "slideshow_anchors" ("id" serial primary key, "bit_core_slideshow_id" integer, "target_name" character varying(255), "created_at" timestamp, "updated_at" timestamp) SQL (0.2ms) INSERT INTO "schema_migrations" ("version") VALUES ($1) [["version", "20141125230628"]]  (0.4ms) COMMIT Migrating to RemoveColumnsPasswordAndPasswordConfirmationFromUsers (20141126151510)  (0.3ms) BEGIN  (0.8ms) ALTER TABLE "users" DROP "password"  (0.5ms) ALTER TABLE "users" DROP "password_confirmation" SQL (0.3ms) INSERT INTO "schema_migrations" ("version") VALUES ($1) [["version", "20141126151510"]]  (0.4ms) COMMIT Migrating to AddDeviseToParticipants (20141203195016)  (0.2ms) BEGIN  (6.6ms) ALTER TABLE "participants" ADD COLUMN "encrypted_password" character varying(255) DEFAULT '' NOT NULL  (0.3ms) ALTER TABLE "participants" ADD COLUMN "reset_password_token" character varying(255)  (0.2ms) ALTER TABLE "participants" ADD COLUMN "reset_password_sent_at" timestamp  (0.2ms) ALTER TABLE "participants" ADD COLUMN "remember_created_at" timestamp  (5.4ms) ALTER TABLE "participants" ADD COLUMN "sign_in_count" integer DEFAULT 0 NOT NULL  (0.4ms) ALTER TABLE "participants" ADD COLUMN "current_sign_in_at" timestamp  (0.2ms) ALTER TABLE "participants" ADD COLUMN "last_sign_in_at" timestamp  (0.2ms) ALTER TABLE "participants" ADD COLUMN "current_sign_in_ip" inet  (0.2ms) ALTER TABLE "participants" ADD COLUMN "last_sign_in_ip" inet  (1.0ms) CREATE UNIQUE INDEX "index_participants_on_reset_password_token" ON "participants" ("reset_password_token") SQL (0.2ms) INSERT INTO "schema_migrations" ("version") VALUES ($1) [["version", "20141203195016"]]  (1.9ms) COMMIT Migrating to RemovePasswordFromParticipants (20141203201524)  (0.3ms) BEGIN  (0.5ms) ALTER TABLE "participants" DROP "password"  (0.3ms) ALTER TABLE "participants" DROP "password_confirmation" SQL (0.4ms) INSERT INTO "schema_migrations" ("version") VALUES ($1) [["version", "20141203201524"]]  (0.5ms) COMMIT Migrating to AddHasWozToArm (20141214203919)  (0.1ms) BEGIN  (2.2ms) ALTER TABLE "arms" ADD COLUMN "has_woz" boolean DEFAULT 'f' SQL (0.2ms) INSERT INTO "schema_migrations" ("version") VALUES ($1) [["version", "20141214203919"]]  (0.7ms) COMMIT ActiveRecord::SchemaMigration Load (0.3ms) SELECT "schema_migrations".* FROM "schema_migrations"  (115.5ms) DROP DATABASE IF EXISTS "dummy_test"  (234.0ms) CREATE DATABASE "dummy_test" ENCODING = 'unicode'  (116.3ms) DROP DATABASE IF EXISTS "dummy_test"  (235.8ms) CREATE DATABASE "dummy_test" ENCODING = 'unicode' SQL (0.3ms) CREATE EXTENSION IF NOT EXISTS "plpgsql"  (6.0ms) CREATE TABLE "arms" ("id" serial primary key, "title" character varying(255) DEFAULT '', "is_social" boolean DEFAULT 'f', "created_at" timestamp, "updated_at" timestamp, "has_woz" boolean DEFAULT 'f')  (2.8ms) CREATE TABLE "coach_assignments" ("id" serial primary key, "coach_id" integer NOT NULL, "participant_id" integer NOT NULL, "created_at" timestamp, "updated_at" timestamp)   (2.6ms) CREATE TABLE "groups" ("id" serial primary key, "title" character varying(255), "created_at" timestamp, "updated_at" timestamp, "arm_id" integer)  (2.9ms) CREATE TABLE "memberships" ("id" serial primary key, "group_id" integer NOT NULL, "participant_id" integer NOT NULL, "end_date" date, "start_date" date, "created_at" timestamp, "updated_at" timestamp)   (5.1ms) CREATE TABLE "participants" ("id" serial primary key, "email" character varying(255) DEFAULT '' NOT NULL, "phone_number" character varying(255), "study_id" character varying(255), "created_at" timestamp, "updated_at" timestamp, "display_name" character varying(255) DEFAULT '' NOT NULL, "contact_preference" character varying(255) DEFAULT '', "encrypted_password" character varying(255) DEFAULT '' NOT NULL, "reset_password_token" character varying(255), "reset_password_sent_at" timestamp, "remember_created_at" timestamp, "sign_in_count" integer DEFAULT 0 NOT NULL, "current_sign_in_at" timestamp, "last_sign_in_at" timestamp, "current_sign_in_ip" inet, "last_sign_in_ip" inet)  (1.4ms) CREATE UNIQUE INDEX "index_participants_on_email" ON "participants" USING btree ("email")  (1.2ms) CREATE UNIQUE INDEX "index_participants_on_phone_number" ON "participants" USING btree ("phone_number")  (1.2ms) CREATE UNIQUE INDEX "index_participants_on_reset_password_token" ON "participants" USING btree ("reset_password_token")  (1.3ms) CREATE UNIQUE INDEX "index_participants_on_study_id" ON "participants" USING btree ("study_id")  (2.6ms) CREATE TABLE "slideshow_anchors" ("id" serial primary key, "bit_core_slideshow_id" integer, "target_name" character varying(255), "created_at" timestamp, "updated_at" timestamp)   (2.7ms) CREATE TABLE "think_feel_do_dashboard_moderators" ("id" serial primary key, "group_id" integer NOT NULL, "user_id" integer NOT NULL, "created_at" timestamp, "updated_at" timestamp)  (3.5ms) CREATE TABLE "user_roles" ("id" serial primary key, "user_id" integer, "role_class_name" character varying(255), "created_at" timestamp, "updated_at" timestamp)   (4.6ms) CREATE TABLE "users" ("id" serial primary key, "email" character varying(255), "created_at" timestamp, "updated_at" timestamp, "is_admin" boolean DEFAULT 'f' NOT NULL, "encrypted_password" character varying(255) DEFAULT '' NOT NULL, "reset_password_token" character varying(255), "reset_password_sent_at" timestamp, "remember_created_at" timestamp, "sign_in_count" integer DEFAULT 0 NOT NULL, "current_sign_in_at" timestamp, "last_sign_in_at" timestamp, "current_sign_in_ip" inet, "last_sign_in_ip" inet)  (1.3ms) CREATE UNIQUE INDEX "index_users_on_email" ON "users" USING btree ("email")  (1.2ms) CREATE UNIQUE INDEX "index_users_on_reset_password_token" ON "users" USING btree ("reset_password_token")  (1.0ms) CREATE TABLE "schema_migrations" ("version" character varying(255) NOT NULL)   (1.0ms) CREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")  (0.4ms) SELECT version FROM "schema_migrations"  (0.7ms) INSERT INTO "schema_migrations" (version) VALUES ('20141214203919')  (0.6ms) INSERT INTO "schema_migrations" (version) VALUES ('20141020185953')  (0.4ms) INSERT INTO "schema_migrations" (version) VALUES ('20141020190822')  (0.3ms) INSERT INTO "schema_migrations" (version) VALUES ('20141020190824')  (0.4ms) INSERT INTO "schema_migrations" (version) VALUES ('20141020191622')  (0.4ms) INSERT INTO "schema_migrations" (version) VALUES ('20141020191754')  (0.4ms) INSERT INTO "schema_migrations" (version) VALUES ('20141104135632')  (0.3ms) INSERT INTO "schema_migrations" (version) VALUES ('20141104141420')  (0.3ms) INSERT INTO "schema_migrations" (version) VALUES ('20141107170701')  (0.3ms) INSERT INTO "schema_migrations" (version) VALUES ('20141111140835')  (0.3ms) INSERT INTO "schema_migrations" (version) VALUES ('20141120202053')  (0.3ms) INSERT INTO "schema_migrations" (version) VALUES ('20141121201134')  (0.3ms) INSERT INTO "schema_migrations" (version) VALUES ('20141125225148')  (0.3ms) INSERT INTO "schema_migrations" (version) VALUES ('20141125230628')  (0.2ms) INSERT INTO "schema_migrations" (version) VALUES ('20141126151510')  (0.3ms) INSERT INTO "schema_migrations" (version) VALUES ('20141203195016')  (0.2ms) INSERT INTO "schema_migrations" (version) VALUES ('20141203201524')  (0.3ms) INSERT INTO "schema_migrations" (version) VALUES ('20141105203408')  (0.2ms) INSERT INTO "schema_migrations" (version) VALUES ('20141106202954')  (0.3ms) INSERT INTO "schema_migrations" (version) VALUES ('20141106211650')  (119.7ms) DROP DATABASE IF EXISTS "dummy_test"  (373.9ms) CREATE DATABASE "dummy_test" ENCODING = 'unicode'  (116.4ms) DROP DATABASE IF EXISTS "dummy_test"  (236.8ms) CREATE DATABASE "dummy_test" ENCODING = 'unicode' SQL (0.3ms) CREATE EXTENSION IF NOT EXISTS "plpgsql"  (7.7ms) CREATE TABLE "arms" ("id" serial primary key, "title" character varying(255) DEFAULT '', "is_social" boolean DEFAULT 'f', "created_at" timestamp, "updated_at" timestamp, "has_woz" boolean DEFAULT 'f')  (3.0ms) CREATE TABLE "coach_assignments" ("id" serial primary key, "coach_id" integer NOT NULL, "participant_id" integer NOT NULL, "created_at" timestamp, "updated_at" timestamp)   (2.8ms) CREATE TABLE "groups" ("id" serial primary key, "title" character varying(255), "created_at" timestamp, "updated_at" timestamp, "arm_id" integer, "moderator_id" integer)  (3.2ms) CREATE TABLE "memberships" ("id" serial primary key, "group_id" integer NOT NULL, "participant_id" integer NOT NULL, "end_date" date, "start_date" date, "created_at" timestamp, "updated_at" timestamp)   (5.6ms) CREATE TABLE "participants" ("id" serial primary key, "email" character varying(255) DEFAULT '' NOT NULL, "phone_number" character varying(255), "study_id" character varying(255), "created_at" timestamp, "updated_at" timestamp, "display_name" character varying(255) DEFAULT '', "contact_preference" character varying(255) DEFAULT '', "encrypted_password" character varying(255) DEFAULT '' NOT NULL, "reset_password_token" character varying(255), "reset_password_sent_at" timestamp, "remember_created_at" timestamp, "sign_in_count" integer DEFAULT 0 NOT NULL, "current_sign_in_at" timestamp, "last_sign_in_at" timestamp, "current_sign_in_ip" inet, "last_sign_in_ip" inet, "is_admin" boolean)  (1.4ms) CREATE UNIQUE INDEX "index_participants_on_email" ON "participants" USING btree ("email")  (1.1ms) CREATE UNIQUE INDEX "index_participants_on_phone_number" ON "participants" USING btree ("phone_number")  (1.4ms) CREATE UNIQUE INDEX "index_participants_on_reset_password_token" ON "participants" USING btree ("reset_password_token")  (1.2ms) CREATE UNIQUE INDEX "index_participants_on_study_id" ON "participants" USING btree ("study_id")  (2.8ms) CREATE TABLE "slideshow_anchors" ("id" serial primary key, "bit_core_slideshow_id" integer, "target_name" character varying(255), "created_at" timestamp, "updated_at" timestamp)   (4.0ms) CREATE TABLE "social_networking_profile_questions" ("id" serial primary key, "group_id" integer, "question_text" text, "created_at" timestamp, "updated_at" timestamp)  (2.9ms) CREATE TABLE "social_networking_profiles" ("id" serial primary key, "participant_id" integer, "icon_name" character varying(255), "active" boolean, "created_at" timestamp, "updated_at" timestamp)   (2.6ms) CREATE TABLE "user_roles" ("id" serial primary key, "user_id" integer, "role_class_name" character varying(255), "created_at" timestamp, "updated_at" timestamp)  (4.4ms) CREATE TABLE "users" ("id" serial primary key, "email" character varying(255), "created_at" timestamp, "updated_at" timestamp, "is_admin" boolean DEFAULT 'f' NOT NULL, "encrypted_password" character varying(255) DEFAULT '' NOT NULL, "reset_password_token" character varying(255), "reset_password_sent_at" timestamp, "remember_created_at" timestamp, "sign_in_count" integer DEFAULT 0 NOT NULL, "current_sign_in_at" timestamp, "last_sign_in_at" timestamp, "current_sign_in_ip" inet, "last_sign_in_ip" inet)   (1.2ms) CREATE UNIQUE INDEX "index_users_on_email" ON "users" USING btree ("email")  (1.3ms) CREATE UNIQUE INDEX "index_users_on_reset_password_token" ON "users" USING btree ("reset_password_token")  (1.0ms) CREATE TABLE "schema_migrations" ("version" character varying(255) NOT NULL)  (1.2ms) CREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")  (0.4ms) SELECT version FROM "schema_migrations"  (0.5ms) INSERT INTO "schema_migrations" (version) VALUES ('20141219032108')  (0.6ms) INSERT INTO "schema_migrations" (version) VALUES ('20141020185953')  (0.3ms) INSERT INTO "schema_migrations" (version) VALUES ('20141020190822')  (0.3ms) INSERT INTO "schema_migrations" (version) VALUES ('20141020190824')  (0.3ms) INSERT INTO "schema_migrations" (version) VALUES ('20141020191622')  (0.4ms) INSERT INTO "schema_migrations" (version) VALUES ('20141020191754')  (0.4ms) INSERT INTO "schema_migrations" (version) VALUES ('20141104135632')  (0.3ms) INSERT INTO "schema_migrations" (version) VALUES ('20141104141420')  (0.3ms) INSERT INTO "schema_migrations" (version) VALUES ('20141107170701')  (0.3ms) INSERT INTO "schema_migrations" (version) VALUES ('20141111140835')  (0.3ms) INSERT INTO "schema_migrations" (version) VALUES ('20141120202053')  (0.3ms) INSERT INTO "schema_migrations" (version) VALUES ('20141121201134')  (0.3ms) INSERT INTO "schema_migrations" (version) VALUES ('20141125225148')  (0.3ms) INSERT INTO "schema_migrations" (version) VALUES ('20141125230628')  (0.3ms) INSERT INTO "schema_migrations" (version) VALUES ('20141126151510')  (0.3ms) INSERT INTO "schema_migrations" (version) VALUES ('20141203195016')  (0.2ms) INSERT INTO "schema_migrations" (version) VALUES ('20141203201524')  (0.3ms) INSERT INTO "schema_migrations" (version) VALUES ('20141214203919')  (0.2ms) INSERT INTO "schema_migrations" (version) VALUES ('20141216165853')  (0.3ms) INSERT INTO "schema_migrations" (version) VALUES ('20141217180455')  (0.2ms) INSERT INTO "schema_migrations" (version) VALUES ('20141217200114')  (0.3ms) INSERT INTO "schema_migrations" (version) VALUES ('20141105203408')  (0.2ms) INSERT INTO "schema_migrations" (version) VALUES ('20141106202954')  (0.3ms) INSERT INTO "schema_migrations" (version) VALUES ('20141106211650')  (0.2ms) INSERT INTO "schema_migrations" (version) VALUES ('20141211143757')  (0.3ms) INSERT INTO "schema_migrations" (version) VALUES ('20141215203425')  (119.5ms) DROP DATABASE IF EXISTS "dummy_test"  (241.9ms) CREATE DATABASE "dummy_test" ENCODING = 'unicode'  (116.7ms) DROP DATABASE IF EXISTS "dummy_test"  (239.4ms) CREATE DATABASE "dummy_test" ENCODING = 'unicode' SQL (0.3ms) CREATE EXTENSION IF NOT EXISTS "plpgsql"  (5.7ms) CREATE TABLE "arms" ("id" serial primary key, "title" character varying(255) DEFAULT '', "is_social" boolean DEFAULT 'f', "created_at" timestamp, "updated_at" timestamp, "has_woz" boolean DEFAULT 'f')  (3.3ms) CREATE TABLE "coach_assignments" ("id" serial primary key, "coach_id" integer NOT NULL, "participant_id" integer NOT NULL, "created_at" timestamp, "updated_at" timestamp)   (3.0ms) CREATE TABLE "groups" ("id" serial primary key, "title" character varying(255), "created_at" timestamp, "updated_at" timestamp, "arm_id" integer, "moderator_id" integer)  (3.1ms) CREATE TABLE "memberships" ("id" serial primary key, "group_id" integer NOT NULL, "participant_id" integer NOT NULL, "end_date" date, "start_date" date, "created_at" timestamp, "updated_at" timestamp)   (5.0ms) CREATE TABLE "participants" ("id" serial primary key, "email" character varying(255) DEFAULT '' NOT NULL, "phone_number" character varying(255), "study_id" character varying(255), "created_at" timestamp, "updated_at" timestamp, "display_name" character varying(255) DEFAULT '', "contact_preference" character varying(255) DEFAULT '', "encrypted_password" character varying(255) DEFAULT '' NOT NULL, "reset_password_token" character varying(255), "reset_password_sent_at" timestamp, "remember_created_at" timestamp, "sign_in_count" integer DEFAULT 0 NOT NULL, "current_sign_in_at" timestamp, "last_sign_in_at" timestamp, "current_sign_in_ip" inet, "last_sign_in_ip" inet, "is_admin" boolean)  (1.4ms) CREATE UNIQUE INDEX "index_participants_on_email" ON "participants" USING btree ("email")  (1.2ms) CREATE UNIQUE INDEX "index_participants_on_phone_number" ON "participants" USING btree ("phone_number")  (1.1ms) CREATE UNIQUE INDEX "index_participants_on_reset_password_token" ON "participants" USING btree ("reset_password_token")  (1.2ms) CREATE UNIQUE INDEX "index_participants_on_study_id" ON "participants" USING btree ("study_id")  (2.5ms) CREATE TABLE "slideshow_anchors" ("id" serial primary key, "bit_core_slideshow_id" integer, "target_name" character varying(255), "created_at" timestamp, "updated_at" timestamp)   (4.5ms) CREATE TABLE "social_networking_profile_questions" ("id" serial primary key, "group_id" integer, "question_text" text, "created_at" timestamp, "updated_at" timestamp)  (3.4ms) CREATE TABLE "social_networking_profiles" ("id" serial primary key, "participant_id" integer, "icon_name" character varying(255), "active" boolean, "created_at" timestamp, "updated_at" timestamp)   (2.9ms) CREATE TABLE "user_roles" ("id" serial primary key, "user_id" integer, "role_class_name" character varying(255), "created_at" timestamp, "updated_at" timestamp)  (5.1ms) CREATE TABLE "users" ("id" serial primary key, "email" character varying(255), "created_at" timestamp, "updated_at" timestamp, "is_admin" boolean DEFAULT 'f' NOT NULL, "encrypted_password" character varying(255) DEFAULT '' NOT NULL, "reset_password_token" character varying(255), "reset_password_sent_at" timestamp, "remember_created_at" timestamp, "sign_in_count" integer DEFAULT 0 NOT NULL, "current_sign_in_at" timestamp, "last_sign_in_at" timestamp, "current_sign_in_ip" inet, "last_sign_in_ip" inet)   (1.4ms) CREATE UNIQUE INDEX "index_users_on_email" ON "users" USING btree ("email")  (1.3ms) CREATE UNIQUE INDEX "index_users_on_reset_password_token" ON "users" USING btree ("reset_password_token")  (1.0ms) CREATE TABLE "schema_migrations" ("version" character varying(255) NOT NULL)  (1.2ms) CREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")  (0.4ms) SELECT version FROM "schema_migrations"  (0.6ms) INSERT INTO "schema_migrations" (version) VALUES ('20141219032108')  (0.5ms) INSERT INTO "schema_migrations" (version) VALUES ('20141020185953')  (0.4ms) INSERT INTO "schema_migrations" (version) VALUES ('20141020190822')  (0.4ms) INSERT INTO "schema_migrations" (version) VALUES ('20141020190824')  (0.3ms) INSERT INTO "schema_migrations" (version) VALUES ('20141020191622')  (0.4ms) INSERT INTO "schema_migrations" (version) VALUES ('20141020191754')  (0.3ms) INSERT INTO "schema_migrations" (version) VALUES ('20141104135632')  (0.4ms) INSERT INTO "schema_migrations" (version) VALUES ('20141104141420')  (0.3ms) INSERT INTO "schema_migrations" (version) VALUES ('20141107170701')  (0.3ms) INSERT INTO "schema_migrations" (version) VALUES ('20141111140835')  (0.2ms) INSERT INTO "schema_migrations" (version) VALUES ('20141120202053')  (0.2ms) INSERT INTO "schema_migrations" (version) VALUES ('20141121201134')  (0.2ms) INSERT INTO "schema_migrations" (version) VALUES ('20141125225148')  (0.2ms) INSERT INTO "schema_migrations" (version) VALUES ('20141125230628')  (0.3ms) INSERT INTO "schema_migrations" (version) VALUES ('20141126151510')  (0.2ms) INSERT INTO "schema_migrations" (version) VALUES ('20141203195016')  (0.3ms) INSERT INTO "schema_migrations" (version) VALUES ('20141203201524')  (0.2ms) INSERT INTO "schema_migrations" (version) VALUES ('20141214203919')  (0.2ms) INSERT INTO "schema_migrations" (version) VALUES ('20141216165853')  (0.2ms) INSERT INTO "schema_migrations" (version) VALUES ('20141217180455')  (0.2ms) INSERT INTO "schema_migrations" (version) VALUES ('20141217200114')  (0.3ms) INSERT INTO "schema_migrations" (version) VALUES ('20141105203408')  (0.2ms) INSERT INTO "schema_migrations" (version) VALUES ('20141106202954')  (0.3ms) INSERT INTO "schema_migrations" (version) VALUES ('20141106211650')  (0.2ms) INSERT INTO "schema_migrations" (version) VALUES ('20141211143757')  (0.3ms) INSERT INTO "schema_migrations" (version) VALUES ('20141215203425')  (120.2ms) DROP DATABASE IF EXISTS "dummy_test"  (239.4ms) CREATE DATABASE "dummy_test" ENCODING = 'unicode'  (117.5ms) DROP DATABASE IF EXISTS "dummy_test"  (237.2ms) CREATE DATABASE "dummy_test" ENCODING = 'unicode' SQL (0.4ms) CREATE EXTENSION IF NOT EXISTS "plpgsql"  (5.7ms) CREATE TABLE "arms" ("id" serial primary key, "title" character varying(255) DEFAULT '', "is_social" boolean DEFAULT 'f', "created_at" timestamp, "updated_at" timestamp, "has_woz" boolean DEFAULT 'f')  (2.8ms) CREATE TABLE "coach_assignments" ("id" serial primary key, "coach_id" integer NOT NULL, "participant_id" integer NOT NULL, "created_at" timestamp, "updated_at" timestamp)   (2.8ms) CREATE TABLE "groups" ("id" serial primary key, "title" character varying(255), "created_at" timestamp, "updated_at" timestamp, "arm_id" integer, "moderator_id" integer)  (3.0ms) CREATE TABLE "memberships" ("id" serial primary key, "group_id" integer NOT NULL, "participant_id" integer NOT NULL, "end_date" date, "start_date" date, "created_at" timestamp, "updated_at" timestamp)   (5.8ms) CREATE TABLE "participants" ("id" serial primary key, "email" character varying(255) DEFAULT '' NOT NULL, "phone_number" character varying(255), "study_id" character varying(255), "created_at" timestamp, "updated_at" timestamp, "display_name" character varying(255) DEFAULT '', "contact_preference" character varying(255) DEFAULT '', "encrypted_password" character varying(255) DEFAULT '' NOT NULL, "reset_password_token" character varying(255), "reset_password_sent_at" timestamp, "remember_created_at" timestamp, "sign_in_count" integer DEFAULT 0 NOT NULL, "current_sign_in_at" timestamp, "last_sign_in_at" timestamp, "current_sign_in_ip" inet, "last_sign_in_ip" inet, "is_admin" boolean)  (1.5ms) CREATE UNIQUE INDEX "index_participants_on_email" ON "participants" USING btree ("email")  (1.6ms) CREATE UNIQUE INDEX "index_participants_on_phone_number" ON "participants" USING btree ("phone_number")  (1.4ms) CREATE UNIQUE INDEX "index_participants_on_reset_password_token" ON "participants" USING btree ("reset_password_token")  (1.2ms) CREATE UNIQUE INDEX "index_participants_on_study_id" ON "participants" USING btree ("study_id")  (2.9ms) CREATE TABLE "slideshow_anchors" ("id" serial primary key, "bit_core_slideshow_id" integer, "target_name" character varying(255), "created_at" timestamp, "updated_at" timestamp)   (4.3ms) CREATE TABLE "social_networking_profile_questions" ("id" serial primary key, "group_id" integer, "question_text" text, "created_at" timestamp, "updated_at" timestamp)  (2.9ms) CREATE TABLE "social_networking_profiles" ("id" serial primary key, "participant_id" integer, "icon_name" character varying(255), "active" boolean, "created_at" timestamp, "updated_at" timestamp)   (2.6ms) CREATE TABLE "social_networking_shared_items" ("id" serial primary key, "participant_id" integer, "is_public" boolean, "created_at" timestamp, "updated_at" timestamp)  (3.0ms) CREATE TABLE "user_roles" ("id" serial primary key, "user_id" integer, "role_class_name" character varying(255), "created_at" timestamp, "updated_at" timestamp)   (4.8ms) CREATE TABLE "users" ("id" serial primary key, "email" character varying(255), "created_at" timestamp, "updated_at" timestamp, "is_admin" boolean DEFAULT 'f' NOT NULL, "encrypted_password" character varying(255) DEFAULT '' NOT NULL, "reset_password_token" character varying(255), "reset_password_sent_at" timestamp, "remember_created_at" timestamp, "sign_in_count" integer DEFAULT 0 NOT NULL, "current_sign_in_at" timestamp, "last_sign_in_at" timestamp, "current_sign_in_ip" inet, "last_sign_in_ip" inet)  (1.5ms) CREATE UNIQUE INDEX "index_users_on_email" ON "users" USING btree ("email")  (1.2ms) CREATE UNIQUE INDEX "index_users_on_reset_password_token" ON "users" USING btree ("reset_password_token")  (1.1ms) CREATE TABLE "schema_migrations" ("version" character varying(255) NOT NULL)   (1.1ms) CREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")  (0.4ms) SELECT version FROM "schema_migrations"  (0.5ms) INSERT INTO "schema_migrations" (version) VALUES ('20141229160455')  (0.5ms) INSERT INTO "schema_migrations" (version) VALUES ('20141020185953')  (0.4ms) INSERT INTO "schema_migrations" (version) VALUES ('20141020190822')  (0.3ms) INSERT INTO "schema_migrations" (version) VALUES ('20141020190824')  (0.3ms) INSERT INTO "schema_migrations" (version) VALUES ('20141020191622')  (0.3ms) INSERT INTO "schema_migrations" (version) VALUES ('20141020191754')  (0.3ms) INSERT INTO "schema_migrations" (version) VALUES ('20141104135632')  (0.4ms) INSERT INTO "schema_migrations" (version) VALUES ('20141104141420')  (0.3ms) INSERT INTO "schema_migrations" (version) VALUES ('20141107170701')  (0.4ms) INSERT INTO "schema_migrations" (version) VALUES ('20141111140835')  (0.3ms) INSERT INTO "schema_migrations" (version) VALUES ('20141120202053')  (0.2ms) INSERT INTO "schema_migrations" (version) VALUES ('20141121201134')  (0.3ms) INSERT INTO "schema_migrations" (version) VALUES ('20141125225148')  (0.2ms) INSERT INTO "schema_migrations" (version) VALUES ('20141125230628')  (0.3ms) INSERT INTO "schema_migrations" (version) VALUES ('20141126151510')  (0.2ms) INSERT INTO "schema_migrations" (version) VALUES ('20141203195016')  (0.3ms) INSERT INTO "schema_migrations" (version) VALUES ('20141203201524')  (0.2ms) INSERT INTO "schema_migrations" (version) VALUES ('20141214203919')  (0.3ms) INSERT INTO "schema_migrations" (version) VALUES ('20141216165853')  (0.2ms) INSERT INTO "schema_migrations" (version) VALUES ('20141217180455')  (0.3ms) INSERT INTO "schema_migrations" (version) VALUES ('20141217200114')  (0.2ms) INSERT INTO "schema_migrations" (version) VALUES ('20141219032108')  (0.3ms) INSERT INTO "schema_migrations" (version) VALUES ('20141105203408')  (0.2ms) INSERT INTO "schema_migrations" (version) VALUES ('20141106202954')  (0.3ms) INSERT INTO "schema_migrations" (version) VALUES ('20141106211650')  (0.2ms) INSERT INTO "schema_migrations" (version) VALUES ('20141211143757')  (0.3ms) INSERT INTO "schema_migrations" (version) VALUES ('20141215203425')  (138.2ms) DROP DATABASE IF EXISTS "dummy_test"  (356.5ms) CREATE DATABASE "dummy_test" ENCODING = 'unicode' SQL (2.2ms) CREATE EXTENSION IF NOT EXISTS "plpgsql"  (15.9ms) CREATE TABLE "arms" ("id" serial primary key, "title" character varying(255) DEFAULT '', "is_social" boolean DEFAULT 'f', "created_at" timestamp, "updated_at" timestamp, "has_woz" boolean DEFAULT 'f')  (3.0ms) CREATE TABLE "coach_assignments" ("id" serial primary key, "coach_id" integer NOT NULL, "participant_id" integer NOT NULL, "created_at" timestamp, "updated_at" timestamp)   (2.7ms) CREATE TABLE "groups" ("id" serial primary key, "title" character varying(255), "created_at" timestamp, "updated_at" timestamp, "arm_id" integer, "moderator_id" integer)  (3.4ms) CREATE TABLE "memberships" ("id" serial primary key, "group_id" integer NOT NULL, "participant_id" integer NOT NULL, "end_date" date, "start_date" date, "created_at" timestamp, "updated_at" timestamp)   (5.2ms) CREATE TABLE "participants" ("id" serial primary key, "email" character varying(255) DEFAULT '' NOT NULL, "phone_number" character varying(255), "study_id" character varying(255), "created_at" timestamp, "updated_at" timestamp, "display_name" character varying(255) DEFAULT '', "contact_preference" character varying(255) DEFAULT '', "encrypted_password" character varying(255) DEFAULT '' NOT NULL, "reset_password_token" character varying(255), "reset_password_sent_at" timestamp, "remember_created_at" timestamp, "sign_in_count" integer DEFAULT 0 NOT NULL, "current_sign_in_at" timestamp, "last_sign_in_at" timestamp, "current_sign_in_ip" inet, "last_sign_in_ip" inet, "is_admin" boolean)  (1.6ms) CREATE UNIQUE INDEX "index_participants_on_email" ON "participants" USING btree ("email")  (1.3ms) CREATE UNIQUE INDEX "index_participants_on_phone_number" ON "participants" USING btree ("phone_number")  (1.3ms) CREATE UNIQUE INDEX "index_participants_on_reset_password_token" ON "participants" USING btree ("reset_password_token")  (1.2ms) CREATE UNIQUE INDEX "index_participants_on_study_id" ON "participants" USING btree ("study_id")  (2.9ms) CREATE TABLE "slideshow_anchors" ("id" serial primary key, "bit_core_slideshow_id" integer, "target_name" character varying(255), "created_at" timestamp, "updated_at" timestamp)   (3.7ms) CREATE TABLE "social_networking_profile_questions" ("id" serial primary key, "group_id" integer, "question_text" text, "created_at" timestamp, "updated_at" timestamp)  (3.1ms) CREATE TABLE "social_networking_profiles" ("id" serial primary key, "participant_id" integer, "icon_name" character varying(255), "active" boolean, "created_at" timestamp, "updated_at" timestamp)   (3.0ms) CREATE TABLE "social_networking_shared_items" ("id" serial primary key, "participant_id" integer, "is_public" boolean, "created_at" timestamp, "updated_at" timestamp)  (3.3ms) CREATE TABLE "user_roles" ("id" serial primary key, "user_id" integer, "role_class_name" character varying(255), "created_at" timestamp, "updated_at" timestamp)   (4.4ms) CREATE TABLE "users" ("id" serial primary key, "email" character varying(255), "created_at" timestamp, "updated_at" timestamp, "is_admin" boolean DEFAULT 'f' NOT NULL, "encrypted_password" character varying(255) DEFAULT '' NOT NULL, "reset_password_token" character varying(255), "reset_password_sent_at" timestamp, "remember_created_at" timestamp, "sign_in_count" integer DEFAULT 0 NOT NULL, "current_sign_in_at" timestamp, "last_sign_in_at" timestamp, "current_sign_in_ip" inet, "last_sign_in_ip" inet)  (1.3ms) CREATE UNIQUE INDEX "index_users_on_email" ON "users" USING btree ("email")  (1.2ms) CREATE UNIQUE INDEX "index_users_on_reset_password_token" ON "users" USING btree ("reset_password_token")  (1.1ms) CREATE TABLE "schema_migrations" ("version" character varying(255) NOT NULL)   (1.3ms) CREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")  (0.4ms) SELECT version FROM "schema_migrations"  (0.5ms) INSERT INTO "schema_migrations" (version) VALUES ('20141229160455')  (0.4ms) INSERT INTO "schema_migrations" (version) VALUES ('20141020185953')  (0.4ms) INSERT INTO "schema_migrations" (version) VALUES ('20141020190822')  (0.3ms) INSERT INTO "schema_migrations" (version) VALUES ('20141020190824')  (0.3ms) INSERT INTO "schema_migrations" (version) VALUES ('20141020191622')  (0.2ms) INSERT INTO "schema_migrations" (version) VALUES ('20141020191754')  (0.3ms) INSERT INTO "schema_migrations" (version) VALUES ('20141104135632')  (0.3ms) INSERT INTO "schema_migrations" (version) VALUES ('20141104141420')  (0.4ms) INSERT INTO "schema_migrations" (version) VALUES ('20141107170701')  (0.3ms) INSERT INTO "schema_migrations" (version) VALUES ('20141111140835')  (0.3ms) INSERT INTO "schema_migrations" (version) VALUES ('20141120202053')  (0.3ms) INSERT INTO "schema_migrations" (version) VALUES ('20141121201134')  (0.3ms) INSERT INTO "schema_migrations" (version) VALUES ('20141125225148')  (0.3ms) INSERT INTO "schema_migrations" (version) VALUES ('20141125230628')  (0.4ms) INSERT INTO "schema_migrations" (version) VALUES ('20141126151510')  (0.4ms) INSERT INTO "schema_migrations" (version) VALUES ('20141203195016')  (0.4ms) INSERT INTO "schema_migrations" (version) VALUES ('20141203201524')  (0.4ms) INSERT INTO "schema_migrations" (version) VALUES ('20141214203919')  (0.4ms) INSERT INTO "schema_migrations" (version) VALUES ('20141216165853')  (0.4ms) INSERT INTO "schema_migrations" (version) VALUES ('20141217180455')  (0.3ms) INSERT INTO "schema_migrations" (version) VALUES ('20141217200114')  (0.4ms) INSERT INTO "schema_migrations" (version) VALUES ('20141219032108')  (0.3ms) INSERT INTO "schema_migrations" (version) VALUES ('20141105203408')  (0.3ms) INSERT INTO "schema_migrations" (version) VALUES ('20141106202954')  (0.3ms) INSERT INTO "schema_migrations" (version) VALUES ('20141106211650')  (0.3ms) INSERT INTO "schema_migrations" (version) VALUES ('20141211143757')  (0.3ms) INSERT INTO "schema_migrations" (version) VALUES ('20141215203425')  (131.9ms) DROP DATABASE IF EXISTS "dummy_test"  (347.1ms) CREATE DATABASE "dummy_test" ENCODING = 'unicode' SQL (0.8ms) CREATE EXTENSION IF NOT EXISTS "plpgsql"  (16.5ms) CREATE TABLE "arms" ("id" serial primary key, "title" character varying(255) DEFAULT '', "is_social" boolean DEFAULT 'f', "created_at" timestamp, "updated_at" timestamp, "has_woz" boolean DEFAULT 'f')  (2.9ms) CREATE TABLE "coach_assignments" ("id" serial primary key, "coach_id" integer NOT NULL, "participant_id" integer NOT NULL, "created_at" timestamp, "updated_at" timestamp)   (2.7ms) CREATE TABLE "groups" ("id" serial primary key, "title" character varying(255), "created_at" timestamp, "updated_at" timestamp, "arm_id" integer, "moderator_id" integer)  (4.3ms) CREATE TABLE "memberships" ("id" serial primary key, "group_id" integer NOT NULL, "participant_id" integer NOT NULL, "end_date" date, "start_date" date, "created_at" timestamp, "updated_at" timestamp)   (6.4ms) CREATE TABLE "participants" ("id" serial primary key, "email" character varying(255) DEFAULT '' NOT NULL, "phone_number" character varying(255), "study_id" character varying(255), "created_at" timestamp, "updated_at" timestamp, "display_name" character varying(255) DEFAULT '', "contact_preference" character varying(255) DEFAULT '', "encrypted_password" character varying(255) DEFAULT '' NOT NULL, "reset_password_token" character varying(255), "reset_password_sent_at" timestamp, "remember_created_at" timestamp, "sign_in_count" integer DEFAULT 0 NOT NULL, "current_sign_in_at" timestamp, "last_sign_in_at" timestamp, "current_sign_in_ip" inet, "last_sign_in_ip" inet, "is_admin" boolean)  (1.5ms) CREATE UNIQUE INDEX "index_participants_on_email" ON "participants" USING btree ("email")  (1.3ms) CREATE UNIQUE INDEX "index_participants_on_phone_number" ON "participants" USING btree ("phone_number")  (1.2ms) CREATE UNIQUE INDEX "index_participants_on_reset_password_token" ON "participants" USING btree ("reset_password_token")  (1.2ms) CREATE UNIQUE INDEX "index_participants_on_study_id" ON "participants" USING btree ("study_id")  (3.7ms) CREATE TABLE "slideshow_anchors" ("id" serial primary key, "bit_core_slideshow_id" integer, "target_name" character varying(255), "created_at" timestamp, "updated_at" timestamp)   (3.9ms) CREATE TABLE "social_networking_profile_questions" ("id" serial primary key, "group_id" integer, "question_text" text, "created_at" timestamp, "updated_at" timestamp)  (3.0ms) CREATE TABLE "social_networking_profiles" ("id" serial primary key, "participant_id" integer, "icon_name" character varying(255), "active" boolean, "created_at" timestamp, "updated_at" timestamp)   (2.6ms) CREATE TABLE "social_networking_shared_items" ("id" serial primary key, "participant_id" integer, "is_public" boolean, "created_at" timestamp, "updated_at" timestamp)  (3.8ms) CREATE TABLE "user_roles" ("id" serial primary key, "user_id" integer, "role_class_name" character varying(255), "created_at" timestamp, "updated_at" timestamp)   (5.4ms) CREATE TABLE "users" ("id" serial primary key, "email" character varying(255), "created_at" timestamp, "updated_at" timestamp, "is_admin" boolean DEFAULT 'f' NOT NULL, "encrypted_password" character varying(255) DEFAULT '' NOT NULL, "reset_password_token" character varying(255), "reset_password_sent_at" timestamp, "remember_created_at" timestamp, "sign_in_count" integer DEFAULT 0 NOT NULL, "current_sign_in_at" timestamp, "last_sign_in_at" timestamp, "current_sign_in_ip" inet, "last_sign_in_ip" inet)  (1.1ms) CREATE UNIQUE INDEX "index_users_on_email" ON "users" USING btree ("email")  (1.0ms) CREATE UNIQUE INDEX "index_users_on_reset_password_token" ON "users" USING btree ("reset_password_token")  (1.1ms) CREATE TABLE "schema_migrations" ("version" character varying(255) NOT NULL)   (1.2ms) CREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")  (0.4ms) SELECT version FROM "schema_migrations"  (3.6ms) INSERT INTO "schema_migrations" (version) VALUES ('20141229160455')  (1.2ms) INSERT INTO "schema_migrations" (version) VALUES ('20141020185953')  (0.3ms) INSERT INTO "schema_migrations" (version) VALUES ('20141020190822')  (0.3ms) INSERT INTO "schema_migrations" (version) VALUES ('20141020190824')  (0.3ms) INSERT INTO "schema_migrations" (version) VALUES ('20141020191622')  (0.3ms) INSERT INTO "schema_migrations" (version) VALUES ('20141020191754')  (0.3ms) INSERT INTO "schema_migrations" (version) VALUES ('20141104135632')  (0.3ms) INSERT INTO "schema_migrations" (version) VALUES ('20141104141420')  (0.3ms) INSERT INTO "schema_migrations" (version) VALUES ('20141107170701')  (0.3ms) INSERT INTO "schema_migrations" (version) VALUES ('20141111140835')  (0.3ms) INSERT INTO "schema_migrations" (version) VALUES ('20141120202053')  (0.3ms) INSERT INTO "schema_migrations" (version) VALUES ('20141121201134')  (0.3ms) INSERT INTO "schema_migrations" (version) VALUES ('20141125225148')  (0.4ms) INSERT INTO "schema_migrations" (version) VALUES ('20141125230628')  (0.3ms) INSERT INTO "schema_migrations" (version) VALUES ('20141126151510')  (0.3ms) INSERT INTO "schema_migrations" (version) VALUES ('20141203195016')  (0.3ms) INSERT INTO "schema_migrations" (version) VALUES ('20141203201524')  (0.3ms) INSERT INTO "schema_migrations" (version) VALUES ('20141214203919')  (0.3ms) INSERT INTO "schema_migrations" (version) VALUES ('20141216165853')  (0.3ms) INSERT INTO "schema_migrations" (version) VALUES ('20141217180455')  (0.3ms) INSERT INTO "schema_migrations" (version) VALUES ('20141217200114')  (0.3ms) INSERT INTO "schema_migrations" (version) VALUES ('20141219032108')  (0.3ms) INSERT INTO "schema_migrations" (version) VALUES ('20141105203408')  (0.3ms) INSERT INTO "schema_migrations" (version) VALUES ('20141106202954')  (0.3ms) INSERT INTO "schema_migrations" (version) VALUES ('20141106211650')  (0.3ms) INSERT INTO "schema_migrations" (version) VALUES ('20141211143757')  (0.3ms) INSERT INTO "schema_migrations" (version) VALUES ('20141215203425')