SQLite format 3@  . O f $P HDNRd##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)%e[indexindex_roles_on_resource_type_and_resource_idrolesCREATE INDEX "index_roles_on_resource_type_and_resource_id" ON "roles" ("resource_type", "resource_id")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")]tablerolesrolesCREATE TABLE "roles" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "resource_type" varchar, "resource_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)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")f +tablepostsposts CREATE TABLE "posts" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" varchar, "title" varchar, "active" boolean DEFAULT 0 NOT NULL, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL) 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") ''Itablepaid_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 NOT NULL, "updated_at" datetime NOT NULL)\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")j/tablegroupsgroupsCREATE TABLE "groups" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar, "description" text, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "active" boolean DEFAULT 0 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 m$N y . I )AA Past Due Group2018-05-19 14:02:15.6621882018-05-19 14:02:15.662188I )AA Disabled Group2018-05-19 14:02:15.6407522018-05-19 14:02:15.640752E !AA Test Title2018-05-19 14:02:15.5160832018-05-19 14:02:15.516083E!AA Test Title2018-05-19 14:02:15.5002642018-05-19 14:02:15.500264E!AA Test Title2018-05-19 14:02:15.4857442018-05-19 14:02:15.485744E!AA Test Title2018-05-19 14:02:15.4688502018-05-19 14:02:15.468850E!AA Test Title2018-05-19 14:02:15.4477992018-05-19 14:02:15.447799F#AA Third Group2018-05-19 14:02:15.4304452018-05-19 14:02:15.430445G%AA Second Group2018-05-19 14:02:15.4143502018-05-19 14:02:15.414350I)AAInactive Group2018-05-19 14:02:15.3996792018-05-19 14:02:15.399679F#AA First Group2018-05-19 14:02:15.3219982018-05-19 14:02:15.321998              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.2018-05-19 14:01:50.3035612018-05-19 14:01:50.303561 /%oAAgroup-leader-planGroup LeaderFor leaders of single groups, with configuration.2018-05-19 14:01:49.7543902018-05-19 14:01:49.754390m#M AAno-ads-planNo AdsNo frills, just removes the ads.2018-05-19 14:01:49.2121262018-05-19 14:01:49.212126^7AAfree-planFreeCan't beat the price!2018-05-19 14:01:48.6966882018-05-19 14:01:48.696688w)SAAanonymous-planAnonymousWhat you can do without logging in.2018-05-19 14:01:48.1543042018-05-19 14:01:48.154304 /professional-plan/group-leader-plan#no-ads-plan free-plan) anonymous-plan %Professional%Group Leader No AdsFree  Anonymous  p(P x 0 T  R9 AA1No Longer Enabled Post2018-05-19 14:02:15.7039302018-05-19 14:02:15.703930N1 AA1Still Enabled Post2018-05-19 14:02:15.7000922018-05-19 14:02:15.700092I 'AA1Inactive Post2018-05-19 14:02:15.6961642018-05-19 14:02:15.696164G # AA1Active Post2018-05-19 14:02:15.6919652018-05-19 14:02:15.691965F ! AA1First Post2018-05-19 14:02:15.6870812018-05-19 14:02:15.687081F ! AA4Test Title2018-05-19 14:02:15.6367112018-05-19 14:02:15.636711F ! AA4Test Title2018-05-19 14:02:15.6328152018-05-19 14:02:15.632815F! AA4Test Title2018-05-19 14:02:15.6292352018-05-19 14:02:15.629235F! AA4Test Title2018-05-19 14:02:15.6244292018-05-19 14:02:15.624429F! AA4Test Title2018-05-19 14:02:15.6202072018-05-19 14:02:15.620207F! AA4Test Title2018-05-19 14:02:15.6165832018-05-19 14:02:15.616583F! AA4Test Title2018-05-19 14:02:15.6126722018-05-19 14:02:15.612672F! AA4Test Title2018-05-19 14:02:15.6088522018-05-19 14:02:15.608852F! AA4Test Title2018-05-19 14:02:15.6050622018-05-19 14:02:15.605062F! AA4Test Title2018-05-19 14:02:15.6012772018-05-19 14:02:15.601277                    111 1 1 4 4 4444444 4 q)Q y 1 F AAownerGroup 2018-05-19 14:02:15.6675242018-05-19 14:02:15.667524F AAownerGroup 2018-05-19 14:02:15.6489952018-05-19 14:02:15.648995F AAownerGroup 2018-05-19 14:02:15.5211562018-05-19 14:02:15.521156FAAownerGroup2018-05-19 14:02:15.5058082018-05-19 14:02:15.505808FAAownerGroup2018-05-19 14:02:15.4914292018-05-19 14:02:15.491429FAAownerGroup2018-05-19 14:02:15.4762002018-05-19 14:02:15.476200FAAownerGroup2018-05-19 14:02:15.4526392018-05-19 14:02:15.452639FAAownerGroup2018-05-19 14:02:15.4356452018-05-19 14:02:15.435645FAAownerGroup2018-05-19 14:02:15.4193862018-05-19 14:02:15.419386FAAownerGroup2018-05-19 14:02:15.4049462018-05-19 14:02:15.404946E AAownerGroup2018-05-19 14:02:15.3430042018-05-19 14:02:15.343004 <r`N<ownerGroup ownerGroup ownerGroup ownerGroupownerGroupownerGroupownerGroupownerGroupownerGroupownerGroup ownerGroup  owner owner owner owner owner owner owner owner owner owner owner ~~ Group Group Group Group Group Group Group Group Group Group  Group  tH  3M1Past Due Subscriberpast.due.subscriber7@example.com$2a$04$vU7JquvU99TyWCS022cP/OspNEe6AVh8YOHAmVDOeXlMWwhzTI5yCcus_CtIDGDlRRYb7qQ -G1Blank Subscriberblank.subscriber6@example.com$2a$04$WnViQRdw2yX8M44RruJ.hOERkHeziFt8o1v0qd1WOCHH0FI5umLdicus_CtIDnZlYIPmS4J;U1Professional Subscriberprofessional.subscriber5@example.com$2a$04$y4uDT1IB5kYJraZwOmL8peKflL/VMqSX4KkTzCwZezzkBjnXSR8Aecus_CtIDif0govos2H5O1Disabling Subscriberdisabling.subscriber4@example.com$2a$04$YCtkvcIamEDG.ohq7duGpedV6QBQ2OywbNd9ziMb3YCDBMzPk.F2ecus_CtIDgikVcWTXCN;U1Group Leader Subscribergroup.leader.subscriber3@example.com$2a$04$AMogzj3k.DvM3w1z.8OHv.AbYMFdYHaAEWA1l1DQ8p.9xHFOjoiQucus_CtIDSMh2C5Ayha /I1No Ads Subscriberno.ads.subscriber2@example.com$2a$04$7mDkd8M7qoKAAkmTqhOR/OTY.rYBAojmLUtTkLpvUsnKxTkNf1igqcus_CtIDYyIXnyPj26 +E1Free Subscriberfree.subscriber1@example.com$2a$04$rbggY6KSk3V0Fpp4y81wbeowrn5qTqqlMkZHBVATL6lfW9Fj2iZB6cus_CtIDHtVE72M4uJ #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              c O f $P HDNRn|E#indexindex_users_roles_on_role_idusers_rolesCREATE INDEX "index_users_roles_on_role_id" ON "users_roles" ("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)%e[indexindex_roles_on_resource_type_and_resource_idrolesCREATE INDEX "index_roles_on_resource_type_and_resource_id" ON "roles" ("resource_type", "resource_id")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")]tablerolesrolesCREATE TABLE "roles" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "resource_type" varchar, "resource_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)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")f +tablepostsposts CREATE TABLE "posts" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" varchar, "title" varchar, "active" boolean DEFAULT 0 NOT NULL, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL) 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") ''Itablepaid_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 NOT NULL, "updated_at" datetime NOT NULL)\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")j/tablegroupsgroupsCREATE TABLE "groups" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar, "description" text, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "active" boolean DEFAULT 0 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)      7W 9 4 9PN55?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_metadata x//tableschema_migrationsschema_migrationsCREATE TABLE "schema_migrations" ("version" varchar NOT NULL PRIMARY KEY)AU/indexsqlite_autoindex_schema_migrations_1schema_migrations|E#indexindex_users_roles_on_user_idusers_rolesCREATE INDEX "index_users_roles_on_user_id" ON "users_roles" ("user_id")]#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")|E#indexindex_users_roles_on_role_idusers_rolesCREATE INDEX "index_users_roles_on_role_id" ON "users_roles" ("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)%e[indexindex_roles_on_resource_type_and_resource_idrolesCREATE INDEX "index_roles_on_resource_type_and_resource_id" ON "roles" ("resource_type", "resource_id")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")]tablerolesrolesCREATE TABLE "roles" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "resource_type" varchar, "resource_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)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")      :p^L: )20160207184113 )20160207184114 )20150523010827)20160207184112)20150406154440)20150517175135)20150523010837)20170219225950)20160210165341)20150517175136)20170220001913 0|Vi0C)20160207184113 )20160207184114 )20150523010827 )20160207184112)20150406154440)20150517175135)20150523010837)20170219225950)20160210165341)20150517175136) 20170220001913 O##AAH#AAenvironmenttest2018-05-19 13:52:16.7153502018-05-19 13:52:16.720041 # environment