SQLite format 3@ " -   ^p^ )20160530123314)20160516122649)20160516122239)20160406165523)20160406134250)20160406133419)20160406131316)20160226123409)20160129004111 V|iV)20160530123314 )20160516122649)20160516122239)20160406165523)20160406134250)20160406133419)20160406131316)20160226123409) 20160129004111   aaYl//tableschema_migrationsschema_migrationsCREATE TABLE "schema_migrations" ("version" varchar NOT NULL)=//indexunique_schema_migrationsschema_migrationsCREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")R99?tablesocial_framework_userssocial_framework_usersCREATE TABLE "social_framework_users" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "username" varchar DEFAULT '' NOT NULL, "email" varchar DEFAULT '' NOT NULL, "encrypted_password" varchar DEFAULT '' NOT NULL, "reset_password_token" varchar, "reset_password_sent_at" datetime, "remember_created_at" datetime, "sign_in_count" integer DEFAULT 0 NOT NULL, "current_sign_in_at" datetime, "last_sign_in_at" datetime, "current_sign_in_ip" varchar, "last_sign_in_ip" varchar, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)  GG)W9Oindexindex_social_framework_users_on_emailsocial_framework_usersCREATE UNIQUE INDEX "index_social_framework_users_on_email" ON "social_framework_users" ("email")2]9[indexindex_social_framework_users_on_usernamesocial_framework_users CREATE UNIQUE INDEX "index_social_framework_users_on_username" ON "social_framework_users" ("username")Vu9 indexindex_social_framework_users_on_reset_password_tokensocial_framework_users CREATE UNIQUE INDEX "index_social_framework_users_on_reset_password_token" ON "social_framework_users" ("reset_password_token")|99tablesocial_framework_edgessocial_framework_edges CREATE TABLE "social_framework_edges" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "origin_id" integer NOT NULL, "destiny_id" integer NOT NULL, "label" varchar NOT NULL, "bidirectional" boolean DEFAULT 't' NOT NULL, "active" boolean DEFAULT 'f' NOT NULL, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)     C>. _9Qindexindex_social_framework_edges_on_origin_idsocial_framework_edges CREATE INDEX "index_social_framework_edges_on_origin_id" ON "social_framework_edges" ("origin_id")1 a9Uindexindex_social_framework_edges_on_destiny_idsocial_framework_edgesCREATE INDEX "index_social_framework_edges_on_destiny_id" ON "social_framework_edges" ("destiny_id")x AA{tablesocial_framework_schedulessocial_framework_schedulesCREATE TABLE "social_framework_schedules" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer NOT NULL, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)? cAgindexindex_social_framework_schedules_on_user_idsocial_framework_schedulesCREATE UNIQUE INDEX "index_social_framework_schedules_on_user_id" ON "social_framework_schedules" ("user_id")     ,_ ;;Utablesocial_framework_eventssocial_framework_eventsCREATE TABLE "social_framework_events" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar NOT NULL, "description" varchar, "start" datetime, "finish" datetime, "particular" boolean DEFAULT 'f', "route_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)nOOKtablesocial_framework_events_schedulessocial_framework_events_schedulesCREATE TABLE "social_framework_events_schedules" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "schedule_id" integer NOT NULL, "event_id" integer NOT NULL)`yOindexindex_social_framework_events_schedules_on_schedule_idsocial_framework_events_schedulesCREATE INDEX "index_social_framework_events_schedules_on_schedule_id" ON "social_framework_events_schedules" ("schedule_id")    3WsOyindexindex_social_framework_events_schedules_on_event_idsocial_framework_events_schedulesCREATE INDEX "index_social_framework_events_schedules_on_event_id" ON "social_framework_events_schedules" ("event_id");SS]tablesocial_framework_participant_eventssocial_framework_participant_eventsCREATE TABLE "social_framework_participant_events" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "event_id" integer NOT NULL, "schedule_id" integer NOT NULL, "confirmed" boolean DEFAULT 'f', "role" varchar DEFAULT 'participant')_wSindexindex_social_framework_participant_events_on_event_idsocial_framework_participant_eventsCREATE INDEX "index_social_framework_participant_events_on_event_id" ON "social_framework_participant_events" ("event_id")h}S indexindex_social_framework_participant_events_on_schedule_idsocial_framework_participant_eventsCREATE INDEX "index_social_framework_participant_events_on_schedule_id" ON "social_framework_participant_events" ("schedule_id")     LLo6?;;tablesocial_framework_routessocial_framework_routesCREATE TABLE "social_framework_routes" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar NOT NULL, "distance" integer NOT NULL, "mode_of_travel" varchar DEFAULT 'driving' NOT NULL, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)^GG;tablesocial_framework_routes_userssocial_framework_routes_usersCREATE TABLE "social_framework_routes_users" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer NOT NULL, "route_id" integer NOT NULL)DiGeindexindex_social_framework_routes_users_on_user_idsocial_framework_routes_usersCREATE INDEX "index_social_framework_routes_users_on_user_id" ON "social_framework_routes_users" ("user_id")GkGiindexindex_social_framework_routes_users_on_route_idsocial_framework_routes_usersCREATE INDEX "index_social_framework_routes_users_on_route_id" ON "social_framework_routes_users" ("route_id")     rG%indexindex_social_framework_routes_users_on_user_id_and_route_idsocial_framework_routes_usersCREATE UNIQUE INDEX "index_social_framework_routes_users_on_user_id_and_route_id" ON "social_framework_routes_users" ("user_id", "route_id")4AAstablesocial_framework_locationssocial_framework_locations!CREATE TABLE "social_framework_locations" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "route_id" integer NOT NULL, "latitude" decimal NOT NULL, "longitude" decimal NOT NULL, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)4=={tablesocial_framework_repeatssocial_framework_repeats"CREATE TABLE "social_framework_repeats" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "event_id" integer NOT NULL, "type" varchar NOT NULL, "frequency" integer DEFAULT 1 NOT NULL, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)