SQLite format 3@  -  4 oZ]do}krHkIiindexindex_openstax_accounts_group_owners_on_user_idopenstax_accounts_group_ownersCREATE INDEX "index_openstax_accounts_group_owners_on_user_id" ON "openstax_accounts_group_owners" ("user_id")vI)indexindex_openstax_accounts_group_owners_on_group_id_and_user_idopenstax_accounts_group_ownersCREATE UNIQUE INDEX "index_openstax_accounts_group_owners_on_group_id_and_user_id" ON "openstax_accounts_group_owners" ("group_id", "user_id")IItableopenstax_accounts_group_ownersopenstax_accounts_group_ownersCREATE TABLE "openstax_accounts_group_owners" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "group_id" integer NOT NULL, "user_id" integer NOT NULL, "created_at" datetime, "updated_at" datetime)oMindexindex_openstax_accounts_group_nestings_on_member_group_idopenstax_accounts_group_nestingsCREATE UNIQUE INDEX "index_openstax_accounts_group_nestings_on_member_group_id" ON "openstax_accounts_group_nestings" ("member_group_id")r Mindexindex_openstax_accounts_group_nestings_on_container_group_idopenstax_accounts_group_nestingsCREATE INDEX "index_openstax_accounts_group_nestings_on_container_group_id" ON "openstax_accounts_group_nestings" ("container_group_id")' MMAtableopenstax_accounts_group_nestingsopenstax_accounts_group_nestings CREATE TABLE "openstax_accounts_group_nestings" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "member_group_id" integer NOT NULL, "container_group_id" integer NOT NULL, "created_at" datetime, "updated_at" datetime)L mKmindexindex_openstax_accounts_group_members_on_user_idopenstax_accounts_group_members CREATE INDEX "index_openstax_accounts_group_members_on_user_id" ON "openstax_accounts_group_members" ("user_id")z K-indexindex_openstax_accounts_group_members_on_group_id_and_user_idopenstax_accounts_group_members CREATE UNIQUE INDEX "index_openstax_accounts_group_members_on_group_id_and_user_id" ON "openstax_accounts_group_members" ("group_id", "user_id") KKtableopenstax_accounts_group_membersopenstax_accounts_group_members CREATE TABLE "openstax_accounts_group_members" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "group_id" integer NOT NULL, "user_id" integer NOT NULL, "created_at" datetime, "updated_at" datetime)BeAkindexindex_openstax_accounts_accounts_on_usernameopenstax_accounts_accounts CREATE UNIQUE INDEX "index_openstax_accounts_accounts_on_username" ON "openstax_accounts_accounts" ("username")NmA{indexindex_openstax_accounts_accounts_on_openstax_uidopenstax_accounts_accountsCREATE UNIQUE INDEX "index_openstax_accounts_accounts_on_openstax_uid" ON "openstax_accounts_accounts" ("openstax_uid")>gAaindexindex_openstax_accounts_accounts_on_last_nameopenstax_accounts_accountsCREATE INDEX "index_openstax_accounts_accounts_on_last_name" ON "openstax_accounts_accounts" ("last_name")>gAaindexindex_openstax_accounts_accounts_on_full_nameopenstax_accounts_accountsCREATE INDEX "index_openstax_accounts_accounts_on_full_name" ON "openstax_accounts_accounts" ("full_name")AiAeindexindex_openstax_accounts_accounts_on_first_nameopenstax_accounts_accountsCREATE INDEX "index_openstax_accounts_accounts_on_first_name" ON "openstax_accounts_accounts" ("first_name")NmA{indexindex_openstax_accounts_accounts_on_access_tokenopenstax_accounts_accountsCREATE UNIQUE INDEX "index_openstax_accounts_accounts_on_access_token" ON "openstax_accounts_accounts" ("access_token")P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)AA)tableopenstax_accounts_accountsopenstax_accounts_accountsCREATE TABLE "openstax_accounts_accounts" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "openstax_uid" integer NOT NULL, "username" varchar(255) NOT NULL, "access_token" varchar(255), "first_name" varchar(255), "last_name" varchar(255), "full_name" varchar(255), "title" varchar(255), "created_at" datetime, "updated_at" date                   ]] A  X ) do}krHkIiindexindex_openstax_accounts_group_owners_on_user_idopenstax_accoHkIiindexindex_openstax_accounts_group_owners_on_user_idopenstax_accounts_group_ownersCREATE INDEX "index_openstax_accounts_group_owners_on_user_id" ON "openstax_accounts_group_owners" ("user_id")vI)indexindex_openstax_accounts_group_owners_on_group_id_and_user_idopenstax_accounts_group_ownersCREATE UNIQUE INDEX "index_openstax_accounts_group_owners_on_group_id_and_user_id" ON "openstax_accounts_group_owners" ("group_id", "user_id")IItableopenstax_accounts_group_ownersopenstax_accounts_group_ownersCREATE TABLE "openstax_accounts_group_owners" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "group_id" integer NOT NULL, "user_id" integer NOT NULL, "created_at" datetime, "updated_at" datetime)oMindexindex_openstax_accounts_group_nestings_on_member_group_idopenstax_accounts_group_nestingsCREATE UNIQUE INDEX "index_openstax_accounts_group_nestings_on_member_group_id" ON "openstax_accounts_group_nestings" ("member_group_id")r Mindexindex_openstax_accounts_group_nestings_on_container_group_idopenstax_accounts_group_nestingsCREATE INDEX "index_openstax_accounts_group_nestings_on_container_group_id" ON "openstax_accounts_group_nestings" ("container_group_id")' MMAtableopenstax_accounts_group_nestingsopenstax_accounts_group_nestings CREATE TABLE "openstax_accounts_group_nestings" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "member_group_id" integer NOT NULL, "container_group_id" integer NOT NULL, "created_at" datetime, "updated_at" datetime)L mKmindexindex_openstax_accounts_group_members_on_user_idopenstax_accounts_group_members CREATE INDEX "index_openstax_accounts_group_members_on_user_id" ON "openstax_accounts_group_members" ("user_id")AA)tableopenstax_accounts_accountsopenstax_accounts_accountsCREATE TABLE "openstax_accounts_accounts" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "openstax_uid" integer NOT NULL, "username" varchar(255) NOT NULL, "access_token" varchar(255), "first_name" varchar(255), "last_name" varchar(255), "full_name" varchar(255), "title" varchar(255), "created_at" datetime, "updated_at" datetime)P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)NmA{indexindex_openstax_accounts_accounts_on_access_tokenopenstax_accounts_accountsCREATE UNIQUE INDEX "index_openstax_accounts_accounts_on_access_token" ON "openstax_accounts_accounts" ("access_token")AiAeindexindex_openstax_accounts_accounts_on_first_nameopenstax_accounts_accountsCREATE INDEX "index_openstax_accounts_accounts_on_first_name" ON "openstax_accounts_accounts" ("first_name")>gAaindexindex_openstax_accounts_accounts_on_full_nameopenstax_accounts_accountsCREATE INDEX "index_openstax_accounts_accounts_on_full_name" ON "openstax_accounts_accounts" ("full_name")>gAaindexindex_openstax_accounts_accounts_on_last_nameopenstax_accounts_accountsCREATE INDEX "index_openstax_accounts_accounts_on_last_name" ON "openstax_accounts_accounts" ("last_name")NmA{indexindex_openstax_accounts_accounts_on_openstax_uidopenstax_accounts_accountsCREATE UNIQUE INDEX "index_openstax_accounts_accounts_on_openstax_uid" ON "openstax_accounts_accounts" ("openstax_uid")BeAkindexindex_openstax_accounts_accounts_on_usernameopenstax_accounts_accounts CREATE UNIQUE INDEX "index_openstax_accounts_accounts_on_username" ON "openstax_accounts_accounts" ("username") KKtableopenstax_accounts_group_membersopenstax_accounts_group_members CREATE TABLE "openstax_accounts_group_members" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "group_id" integer NOT NULL, "user_id" integer NOT NULL, "created_at" datetime, "updated_at" datetime)z K-indexindex_openstax_accounts_group_members_on_group_id_and_user_idopenstax_accounts_group_members CREATE UNIQUE INDEX "index_openstax_accounts_group_members_on_group_id_and_user_id" ON "openstax_accounts_group_members" ("group_id", "user_id")  &]!8=//indexunique_schema_migrationsschema_migrationsCREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")q//tableschema_migrationsschema_migrationsCREATE TABLE "schema_migrations" ("version" varchar(255) NOT NULL)t?indexindex_users_on_account_idusersCREATE UNIQUE INDEX "index_users_on_account_id" ON "users" ("account_id")*3tableusersusersCREATE TABLE "users" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "account_id" integer NOT NULL, "created_at" datetime, "updated_at" datetime).c!eindexindex_ownerships_on_owner_id_and_owner_typeownershipsCREATE UNIQUE INDEX "index_ownerships_on_owner_id_and_owner_type" ON "ownerships" ("owner_id", "owner_type")[!!tableownershipsownershipsCREATE TABLE "ownerships" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "owner_id" integer NOT NULL, "owner_type" varchar(255) NOT NULL, "created_at" datetime, "updated_at" datetime)Fi=sindexindex_openstax_accounts_groups_on_openstax_uidopenstax_accounts_groupsCREATE UNIQUE INDEX "index_openstax_accounts_groups_on_openstax_uid" ON "openstax_accounts_groups" ("openstax_uid")6c=Yindexindex_openstax_accounts_groups_on_is_publicopenstax_accounts_groupsCREATE INDEX "index_openstax_accounts_groups_on_is_public" ON "openstax_accounts_groups" ("is_public")L mKmindexindex_openstax_accounts_group_members_on_user_idopenstax_accounts_group_members CREATE INDEX "index_openstax_accounts_group_members_on_user_id" ON "openstax_accounts_group_members" ("user_id")' MMAtableopenstax_accounts_group_nestingsopenstax_accounts_group_nestings CREATE TABLE "openstax_accounts_group_nestings" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "member_group_id" integer NOT NULL, "container_group_id" integer NOT NULL, "created_at" datetime, "updated_at" datetime)r Mindexindex_openstax_accounts_group_nestings_on_container_group_idopenstax_accounts_group_nestingsCREATE INDEX "index_openstax_accounts_group_nestings_on_container_group_id" ON "openstax_accounts_group_nestings" ("container_group_id")oMindexindex_openstax_accounts_group_nestings_on_member_group_idopenstax_accounts_group_nestingsCREATE UNIQUE INDEX "index_openstax_accounts_group_nestings_on_member_group_id" ON "openstax_accounts_group_nestings" ("member_group_id")IItableopenstax_accounts_group_ownersopenstax_accounts_group_ownersCREATE TABLE "openstax_accounts_group_owners" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "group_id" integer NOT NULL, "user_id" integer NOT NULL, "created_at" datetime, "updated_at" datetime)vI)indexindex_openstax_accounts_group_owners_on_group_id_and_user_idopenstax_accounts_group_ownersCREATE UNIQUE INDEX "index_openstax_accounts_group_owners_on_group_id_and_user_id" ON "openstax_accounts_group_owners" ("group_id", "user_id")HkIiindexindex_openstax_accounts_group_owners_on_user_idopenstax_accounts_group_ownersCREATE INDEX "index_openstax_accounts_group_owners_on_user_id" ON "openstax_accounts_group_owners" ("user_id")h==ctableopenstax_accounts_groupsopenstax_accounts_groupsCREATE TABLE "openstax_accounts_groups" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "openstax_uid" integer NOT NULL, "is_public" boolean DEFAULT 'f' NOT NULL, "name" varchar(255), "cached_subtree_group_ids" text, "cached_supertree_group_ids" text, "created_at" datetime, "updated_at" datetime)       4321056 432105 6