SQLite format 3@  -  pp)20150523010840)20150523010839)20150523010838)20150523010837)20150523010827)20150517175136)20150517175135)20150406154440 i|i)20150523010840)20150523010839)20150523010838)20150523010837)20150523010827)20150517175136)20150517175135) 20150406154440      !!\tableusersusersCREATE 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)3AtablegroupsgroupsCREATE TABLE "groups" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar, "description" text, "created_at" datetime, "updated_at" datetime)P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)=//indexunique_schema_migrationsschema_migrationsCREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")l//tableschema_migrationsschema_migrationsCREATE TABLE "schema_migrations" ("version" varchar NOT NULL) iitp> tabledoodadsdoodadsCREATE TABLE "doodads" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" varchar, "name" varchar, "description" text)l= indexindex_doodads_on_user_iddoodadsCREATE INDEX "index_doodads_on_user_id" ON "doodads" ("user_id")e5 indexindex_users_on_emailusers CREATE UNIQUE INDEX "index_users_on_email" ON "users" ("email") SGindexindex_users_on_reset_password_tokenusers CREATE UNIQUE INDEX "index_users_on_reset_password_token" ON "users" ("reset_password_token")K utablerolesroles CREATE TABLE "roles" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "resource_id" integer, "resource_type" varchar, "created_at" datetime, "updated_at" datetime)d ##tableusers_rolesusers_rolesCREATE TABLE "users_roles" ("user_id" integer, "role_id" integer)Z 3yindexindex_roles_on_namerolesCREATE INDEX "index_roles_on_name" ON "roles" ("name")       X9? 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")]#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")^GG;tablepaid_up_plan_feature_settingspaid_up_plan_feature_settingsCREATE TABLE "paid_up_plan_feature_settings" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "plan_id" integer, "feature" varchar, "setting" integer)DiGeindexindex_paid_up_plan_feature_settings_on_plan_idpaid_up_plan_feature_settingsCREATE INDEX "index_paid_up_plan_feature_settings_on_plan_id" ON "paid_up_plan_feature_settings" ("plan_id")      'C 'M';indexindex_paid_up_plans_on_stripe_idpaid_up_plansCREATE UNIQUE INDEX "index_paid_up_plans_on_stripe_id" ON "paid_up_plans" ("stripe_id")E'+indexindex_paid_up_plans_on_titlepaid_up_plansCREATE UNIQUE INDEX "index_paid_up_plans_on_title" ON "paid_up_plans" ("title")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")s''%tablepaid_up_planspaid_up_plansCREATE 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)