SQLite format 3@ jj. _ v FN0:>6AU/indexsqlite_autoindex_schema_migrations_1schema_migrations]#Kindexindex_users_roles_on_user_id_and_role_idusers_rolesCREATE INDEX "index_users_roles_on_user_id_and_role_id" ON "users_roles" ("user_id", "role_id")d##tableusers_rolesusers_rolesCREATE TABLE "users_roles" ("user_id" integer, "role_id" integer)SGindexindex_users_on_reset_password_tokenusersCREATE UNIQUE INDEX "index_users_on_reset_password_token" ON "users" ("reset_password_token")e5 indexindex_users_on_emailusersCREATE UNIQUE INDEX "index_users_on_email" ON "users" ("email")sEtableusersusersCREATE TABLE "users" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "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, "stripe_id" varchar, "coupon_code" varchar)Z3yindexindex_roles_on_namerolesCREATE INDEX "index_roles_on_name" ON "roles" ("name")?w}indexindex_roles_on_name_and_resource_type_and_resource_idrolesCREATE INDEX "index_roles_on_name_and_resource_type_and_resource_id" ON "roles" ("name", "resource_type", "resource_id")KutablerolesrolesCREATE TABLE "roles" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "resource_type" varchar, "resource_id" integer, "created_at" datetime, "updated_at" datetime)d9indexindex_posts_on_user_idpostsCREATE INDEX "index_posts_on_user_id" ON "posts" ("user_id")a 7indexindex_posts_on_activepostsCREATE INDEX "index_posts_on_active" ON "posts" ("active")V  tablepostsposts CREATE TABLE "posts" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" varchar, "title" varchar, "active" boolean DEFAULT 'f' NOT NULL, "created_at" datetime, "updated_at" datetime) E'+indexindex_paid_up_plans_on_titlepaid_up_plans CREATE UNIQUE INDEX "index_paid_up_plans_on_title" ON "paid_up_plans" ("title") M';indexindex_paid_up_plans_on_stripe_idpaid_up_plans CREATE UNIQUE INDEX "index_paid_up_plans_on_stripe_id" ON "paid_up_plans" ("stripe_id")s ''%tablepaid_up_planspaid_up_plans CREATE TABLE "paid_up_plans" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "stripe_id" varchar, "title" varchar, "description" text, "sort_order" integer, "created_at" datetime, "updated_at" datetime)\yGindexindex_paid_up_plan_feature_settings_on_paid_up_plan_idpaid_up_plan_feature_settings CREATE INDEX "index_paid_up_plan_feature_settings_on_paid_up_plan_id" ON "paid_up_plan_feature_settings" ("paid_up_plan_id")DiGeindexindex_paid_up_plan_feature_settings_on_featurepaid_up_plan_feature_settingsCREATE INDEX "index_paid_up_plan_feature_settings_on_feature" ON "paid_up_plan_feature_settings" ("feature")fGGKtablepaid_up_plan_feature_settingspaid_up_plan_feature_settingsCREATE TABLE "paid_up_plan_feature_settings" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "paid_up_plan_id" integer, "feature" varchar, "setting" integer)e9indexindex_groups_on_activegroupsCREATE INDEX "index_groups_on_active" ON "groups" ("active")ZtablegroupsgroupsCREATE TABLE "groups" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar, "description" text, "created_at" datetime, "updated_at" datetime, "active" boolean DEFAULT 'f' NOT NULL)l= indexindex_doodads_on_user_iddoodadsCREATE INDEX "index_doodads_on_user_id" ON "doodads" ("user_id")P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq) tabledoodadsdoodadsCREATE TABLE "doodads" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" varchar, "name" varchar, "description"  VxgV 4Test Name 4Test Name4Test Name4Test Name4Test Name4Test Name4Test Name4Test Name4Test Name4Test Name  posts doodads groups posts roles users!Gpaid_up_plan_feature_settings 'paid_up_plans 4 4 4444444 4 k!H p $ J )AAPast Due Group2017-10-11 19:36:14.7466552017-10-11 19:36:14.746655tJ )AADisabled Group2017-10-11 19:36:14.7298732017-10-11 19:36:14.729873tF !AATest Title2017-10-11 19:36:14.6176952017-10-11 19:36:14.617695tF!AATest Title2017-10-11 19:36:14.6036082017-10-11 19:36:14.603608tF!AATest Title2017-10-11 19:36:14.5876752017-10-11 19:36:14.587675tF!AATest Title2017-10-11 19:36:14.5714592017-10-11 19:36:14.571459tF!AATest Title2017-10-11 19:36:14.5506062017-10-11 19:36:14.550606tG#AAThird Group2017-10-11 19:36:14.5347572017-10-11 19:36:14.534757tH%AASecond Group2017-10-11 19:36:14.5127122017-10-11 19:36:14.512712tJ)AAInactive Group2017-10-11 19:36:14.4985542017-10-11 19:36:14.498554fG#AAFirst Group2017-10-11 19:36:14.4171782017-10-11 19:36:14.417178t t t t ttttttf t WxeW posts doodads; groups;  ad_free posts doodads groups  ad_free posts  ad_free posts  posts doodads groups ad_free posts doodads groups ad_free posts ad_free posts       }'* }* /%+AAprofessional-planProfessionalDesigned for professionals with unlimited groups, a calendar and configuration.2017-10-11 19:35:50.5883252017-10-11 19:35:50.588325 /%oAAgroup-leader-planGroup LeaderFor leaders of single groups, with configuration.2017-10-11 19:35:50.0517642017-10-11 19:35:50.051764m#M AAno-ads-planNo AdsNo frills, just removes the ads.2017-10-11 19:35:49.5449712017-10-11 19:35:49.544971^7AAfree-planFreeCan't beat the price!2017-10-11 19:35:49.0073552017-10-11 19:35:49.007355w)SAAanonymous-planAnonymousWhat you can do without logging in.2017-10-11 19:35:48.4799782017-10-11 19:35:48.479978 /professional-plan/group-leader-plan#no-ads-plan free-plan) anonymous-plan %Professional%Group Leader No AdsFree  Anonymous  n%J o & G S9AA1No Longer Enabled Postt2017-10-11 19:36:14.7817692017-10-11 19:36:14.781769O1AA1Still Enabled Postt2017-10-11 19:36:14.7778902017-10-11 19:36:14.777890J 'AA1Inactive Postf2017-10-11 19:36:14.7739782017-10-11 19:36:14.773978H #AA1Active Postt2017-10-11 19:36:14.7701762017-10-11 19:36:14.770176G !AA1First Postt2017-10-11 19:36:14.7663922017-10-11 19:36:14.766392G !AA4Test Titlet2017-10-11 19:36:14.7261082017-10-11 19:36:14.726108G !AA4Test Titlet2017-10-11 19:36:14.7223402017-10-11 19:36:14.722340G!AA4Test Titlet2017-10-11 19:36:14.7185442017-10-11 19:36:14.718544G!AA4Test Titlet2017-10-11 19:36:14.7144302017-10-11 19:36:14.714430G!AA4Test Titlet2017-10-11 19:36:14.7105902017-10-11 19:36:14.710590G!AA4Test Titlet2017-10-11 19:36:14.7067552017-10-11 19:36:14.706755G!AA4Test Titlet2017-10-11 19:36:14.7026912017-10-11 19:36:14.702691G!AA4Test Titlet2017-10-11 19:36:14.6988982017-10-11 19:36:14.698898G!AA4Test Titlet2017-10-11 19:36:14.6951412017-10-11 19:36:14.695141G!AA4Test Titlet2017-10-11 19:36:14.6909932017-10-11 19:36:14.690993 ttf t t t t ttttttt t 111 1 1 4 4 4444444 4 q)Q y 1 F AAownerGroup 2017-10-11 19:36:14.7514852017-10-11 19:36:14.751485F AAownerGroup 2017-10-11 19:36:14.7374942017-10-11 19:36:14.737494F AAownerGroup 2017-10-11 19:36:14.6230372017-10-11 19:36:14.623037FAAownerGroup2017-10-11 19:36:14.6084572017-10-11 19:36:14.608457FAAownerGroup2017-10-11 19:36:14.5941902017-10-11 19:36:14.594190FAAownerGroup2017-10-11 19:36:14.5766132017-10-11 19:36:14.576613FAAownerGroup2017-10-11 19:36:14.5561512017-10-11 19:36:14.556151FAAownerGroup2017-10-11 19:36:14.5404162017-10-11 19:36:14.540416FAAownerGroup2017-10-11 19:36:14.5189972017-10-11 19:36:14.518997FAAownerGroup2017-10-11 19:36:14.5036042017-10-11 19:36:14.503604E AAownerGroup2017-10-11 19:36:14.4380492017-10-11 19:36:14.438049 <r`N<ownerGroup ownerGroup ownerGroup ownerGroupownerGroupownerGroupownerGroupownerGroupownerGroupownerGroup ownerGroup  owner owner owner owner owner owner owner owner owner owner owner  tH  3M1Past Due Subscriberpast.due.subscriber7@example.com$2a$04$Xe/mrAYihlLJM4L4u2mP1e0y1D26GJqu09d1OYjwINx.yP/UTwXcicus_BYxvrXgEAHTU2i -G1Blank Subscriberblank.subscriber6@example.com$2a$04$ddoHPrCQ8T1fMRCL69AvwehwIW7ojfFOYteG1Dt.k6FSnGCjlOv9ecus_BYxvVOPPB2oKkT;U1Professional Subscriberprofessional.subscriber5@example.com$2a$04$pYkRUqQuZkyiDvGA0N5aIeQZLLdLwAA0Tttc1YK50kKMGhdXXjNbScus_BYxvbtuneOuAbu5O1Disabling Subscriberdisabling.subscriber4@example.com$2a$04$iOBsQRQ4q7J.w/kxkpVHTeQWXG1DdOgxwUcVgIVmxVKIe1H8ARc3ucus_BYxvEI08CC6bwB;U1Group Leader Subscribergroup.leader.subscriber3@example.com$2a$04$h2sdfToyCJZKLSbl1ESk4OCZ.HSBxJejm3NIaIAwtPou4mQH7nCcycus_BYxvL6QiRWwESh /I1No Ads Subscriberno.ads.subscriber2@example.com$2a$04$bOB0oQx2WVJmLcz3BZpsN.5QwFUNkOtHFl9qJ4bEgLGIxEOHSUSsucus_BYxvtXkDff8lhv +E1Free Subscriberfree.subscriber1@example.com$2a$04$dgL7oMhfRy9B6C3OnuAtnOzT8i2lgKTpD0LP5Xu0qSpjpB1YrXyCWcus_BYxvo1UfnYaKhb #nE$Mpast.due.subscriber7@example.com!Gblank.subscriber6@example.com(Uprofessional.subscriber5@example.com%Odisabling.subscriber4@example.com(Ugroup.leader.subscriber3@example.com"Ino.ads.subscriber2@example.comE free.subscriber1@example.com               :p^L: )20170219225950 )20160210165341 )20160207184114)20160207184113)20160207184112)20150523010837)20150523010827)20150517175136)20150517175135)20150406154440)20170220001913 0|iVC0)20170219225950 )20160210165341 )20160207184114 )20160207184113)20160207184112)20150523010837)20150523010827)20150517175136)20150517175135)20150406154440) 20170220001913 c _ v FN0:>6q.x//tableschema_migrationsschema_migrationsCREATE TABLE "schema_migrations" ("version" varchar NOT NULL PRIMARY KEY)AU/indexsqlite_autoindex_schema_migrations_1schema_migrations]#Kindexindex_users_roles_on_user_id_and_role_idusers_rolesCREATE INDEX "index_users_roles_on_user_id_and_role_id" ON "users_roles" ("user_id", "role_id")d##tableusers_rolesusers_rolesCREATE TABLE "users_roles" ("user_id" integer, "role_id" integer)SGindexindex_users_on_reset_password_tokenusersCREATE UNIQUE INDEX "index_users_on_reset_password_token" ON "users" ("reset_password_token")e5 indexindex_users_on_emailusersCREATE UNIQUE INDEX "index_users_on_email" ON "users" ("email")sEtableusersusersCREATE TABLE "users" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "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, "stripe_id" varchar, "coupon_code" varchar)Z3yindexindex_roles_on_namerolesCREATE INDEX "index_roles_on_name" ON "roles" ("name")?w}indexindex_roles_on_name_and_resource_type_and_resource_idrolesCREATE INDEX "index_roles_on_name_and_resource_type_and_resource_id" ON "roles" ("name", "resource_type", "resource_id")KutablerolesrolesCREATE TABLE "roles" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "resource_type" varchar, "resource_id" integer, "created_at" datetime, "updated_at" datetime)d9indexindex_posts_on_user_idpostsCREATE INDEX "index_posts_on_user_id" ON "posts" ("user_id")a 7indexindex_posts_on_activepostsCREATE INDEX "index_posts_on_active" ON "posts" ("active")V  tablepostsposts CREATE TABLE "posts" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" varchar, "title" varchar, "active" boolean DEFAULT 'f' NOT NULL, "created_at" datetime, "updated_at" datetime) E'+indexindex_paid_up_plans_on_titlepaid_up_plans CREATE UNIQUE INDEX "index_paid_up_plans_on_title" ON "paid_up_plans" ("title") M';indexindex_paid_up_plans_on_stripe_idpaid_up_plans CREATE UNIQUE INDEX "index_paid_up_plans_on_stripe_id" ON "paid_up_plans" ("stripe_id")s ''%tablepaid_up_planspaid_up_plans CREATE TABLE "paid_up_plans" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "stripe_id" varchar, "title" varchar, "description" text, "sort_order" integer, "created_at" datetime, "updated_at" datetime)\yGindexindex_paid_up_plan_feature_settings_on_paid_up_plan_idpaid_up_plan_feature_settings CREATE INDEX "index_paid_up_plan_feature_settings_on_paid_up_plan_id" ON "paid_up_plan_feature_settings" ("paid_up_plan_id")DiGeindexindex_paid_up_plan_feature_settings_on_featurepaid_up_plan_feature_settingsCREATE INDEX "index_paid_up_plan_feature_settings_on_feature" ON "paid_up_plan_feature_settings" ("feature")fGGKtablepaid_up_plan_feature_settingspaid_up_plan_feature_settingsCREATE TABLE "paid_up_plan_feature_settings" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "paid_up_plan_id" integer, "feature" varchar, "setting" integer)e9indexindex_groups_on_activegroupsCREATE INDEX "index_groups_on_active" ON "groups" ("active")ZtablegroupsgroupsCREATE TABLE "groups" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar, "description" text, "created_at" datetime, "updated_at" datetime, "active" boolean DEFAULT 'f' NOT NULL)l= indexindex_doodads_on_user_iddoodadsCREATE INDEX "index_doodads_on_user_id" ON "doodads" ("user_id")P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq) tabledoodadsdoodadsCREATE TABLE "doodads" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" varchar, "name" varchar, "description" text) O##AAenvironmentdevelopment2017-10-11 15:15:06.0480982017-10-11 15:15:06.048098 # environment r7i K U Y QrCN55?tablear_internal_metadataar_internal_metadataCREATE TABLE "ar_internal_metadata" ("key" varchar NOT NULL PRIMARY KEY, "value" varchar, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)G[5indexsqlite_autoindex_ar_internal_metadata_1ar_internal_metadataAU/indexsqlite_autoindex_schema_migrations_1schema_migrationsx//tableschema_migrationsschema_migrationsCREATE TABLE "schema_migrations" ("version" varchar NOT NULL PRIMARY KEY)]#Kindexindex_users_roles_on_user_id_and_role_idusers_rolesCREATE INDEX "index_users_roles_on_user_id_and_role_id" ON "users_roles" ("user_id", "role_id")d##tableusers_rolesusers_rolesCREATE TABLE "users_roles" ("user_id" integer, "role_id" integer)SGindexindex_users_on_reset_password_tokenusersCREATE UNIQUE INDEX "index_users_on_reset_password_token" ON "users" ("reset_password_token")e5 indexindex_users_on_emailusersCREATE UNIQUE INDEX "index_users_on_email" ON "users" ("email")sEtableusersusersCREATE TABLE "users" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "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, "stripe_id" varchar, "coupon_code" varchar)Z3yindexindex_roles_on_namerolesCREATE INDEX "index_roles_on_name" ON "roles" ("name")?w}indexindex_roles_on_name_and_resource_type_and_resource_idrolesCREATE INDEX "index_roles_on_name_and_resource_type_and_resource_id" ON "roles" ("name", "resource_type", "resource_id")KutablerolesrolesCREATE TABLE "roles" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "resource_type" varchar, "resource_id" integer, "created_at" datetime, "updated_at" datetime)d9indexindex_posts_on_user_idpostsCREATE INDEX "index_posts_on_user_id" ON "posts" ("user_id")a 7indexindex_posts_on_activepostsCREATE INDEX "index_posts_on_active" ON "posts" ("active")