SQLite format 3@ !5- 0 _  D Bber!II=tableopenstax_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 NOT NULL, "updated_at" datetime NOT NULL)LmKmindexindex_openstax_accounts_group_members_on_user_idopenstax_accounts_group_membersCREATE INDEX "index_openstax_accounts_group_members_on_user_id" ON "openstax_accounts_group_members" ("user_id")zK-indexindex_openstax_accounts_group_members_on_group_id_and_user_idopenstax_accounts_group_membersCREATE UNIQUE INDEX "index_openstax_accounts_group_members_on_group_id_and_user_id" ON "openstax_accounts_group_members" ("group_id", "user_id")$KK?tableopenstax_accounts_group_membersopenstax_accounts_group_membersCREATE 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 NOT NULL, "updated_at" datetime NOT NULL)6 c=Yindexindex_openstax_accounts_groups_on_is_publicopenstax_accounts_groupsCREATE INDEX "index_openstax_accounts_groups_on_is_public" ON "openstax_accounts_groups" ("is_public")F i=sindexindex_openstax_accounts_groups_on_openstax_uidopenstax_accounts_groups CREATE UNIQUE INDEX "index_openstax_accounts_groups_on_openstax_uid" ON "openstax_accounts_groups" ("openstax_uid")u ==}tableopenstax_accounts_groupsopenstax_accounts_groups CREATE 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, "cached_subtree_group_ids" text, "cached_supertree_group_ids" text, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)> gAaindexindex_openstax_accounts_accounts_on_full_nameopenstax_accounts_accounts CREATE INDEX "index_openstax_accounts_accounts_on_full_name" ON "openstax_accounts_accounts" ("full_name")> gAaindexindex_openstax_accounts_accounts_on_last_nameopenstax_accounts_accounts CREATE INDEX "index_openstax_accounts_accounts_on_last_name" ON "openstax_accounts_accounts" ("last_name")AiAeindexindex_openstax_accounts_accounts_on_first_nameopenstax_accounts_accounts CREATE 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")BeAkindexindex_openstax_accounts_accounts_on_usernameopenstax_accounts_accountsCREATE 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")P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)AAtableopenstax_accounts_accountsopenstax_accounts_accountsCREATE TABLE "openstax_accounts_accounts" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "openstax_uid" integer NOT NULL, "username" varchar NOT NULL, "access_token" varchar, "first_name" varchar, "last_name" varchar, "full_name" varchar, "title" varchar, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)=//indexunique_schema_migrationsschema_migrationsCREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")l//tableschema_migrationsschema_migrationsCREATE TABLE "schema_migrations" ("version" varchar NOT   1001 1000 9 876543210 1001 1000 9 8 7654321 0                 g0     l//tableschema_migrationsschema_migrationsCREATE TABLE "schema_migrations" ("version" varchar NOT NULL)=//indexunique_schema_migrationsschema_migrationsCREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")AAtableopenstax_accounts_accountsopenstax_accounts_accountsCREATE TABLE "openstax_accounts_accounts" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "openstax_uid" integer NOT NULL, "username" varchar NOT NULL, "access_token" varchar, "first_name" varchar, "last_name" varchar, "full_name" varchar, "title" varchar, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)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_accountsCREATE UNIQUE INDEX "index_openstax_accounts_accountsl//tableschema_migrationsschema_migrationsCREATE TABLE "schema_migrations" ("version" varchar NOT NULL)=//indexunique_schema_migrationsschema_migrationsCREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)u ==}tableopenstax_accounts_groupsopenstax_accounts_groups CREATE 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, "cached_subtree_group_ids" text, "cached_supertree_group_ids" text, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)F i=sindexindex_openstax_accounts_groups_on_openstax_uidopenstax_accounts_groups CREATE UNIQUE INDEX "index_openstax_accounts_groups_on_openstax_uid" ON "openstax_accounts_groups" ("openstax_uid")6 c=Yindexindex_openstax_accounts_groups_on_is_publicopenstax_accounts_groupsCREATE INDEX "index_openstax_accounts_groups_on_is_public" ON "openstax_accounts_groups" ("is_public")$KK?tableopenstax_accounts_group_membersopenstax_accounts_group_membersCREATE 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 NOT NULL, "updated_at" datetime NOT NULL)zK-indexindex_openstax_accounts_group_members_on_group_id_and_user_idopenstax_accounts_group_membersCREATE UNIQUE INDEX "index_openstax_accounts_group_members_on_group_id_and_user_id" ON "openstax_accounts_group_members" ("group_id", "user_id")LmKmindexindex_openstax_accounts_group_members_on_user_idopenstax_accounts_group_membersCREATE INDEX "index_openstax_accounts_group_members_on_user_id" ON "openstax_accounts_group_members" ("user_id")!II=tableopenstax_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 NOT NULL, "updated_at" datetime NOT NULL)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")9MMetableopenstax_accounts_group_nestingsopenstax_accounts_group_nestingsCREATE 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 NOT NULL, "updated_at" datetime NOT NULL)    { L  bGW"76 ]A[indexindex_openstax_accounts_accounts_on_uuidopenstax_accounts_accountsCREATE UNIQUE INDEX "index_openstax_accounts_accounts_on_uuid" ON "openstax_accounts_accounts" ("uuid")AA)tableopenstax_accounts_accountsopenstax_accounts_accountsCREATE TABLE "openstax_accounts_accounts" ("id" INTEGER PRIMARY KEY AUTOINCREMEN.%c!eindexindex_ownerships_on_owner_id_and_owner_typeownerships!CREATE UNIQUE INDEX "index_ownerships_on_owner_id_and_owner_type" ON "ownerships" ("owner_id", "owner_type")h$!!tableownershipsownerships CREATE TABLE "ownerships" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "owner_id" integer NOT NULL, "owner_type" varchar NOT NULL, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)t#?indexindex_users_on_account_idusersCREATE UNIQUE INDEX "index_users_on_account_id" ON "users" ("account_id")<"WtableusersusersCREATE TABLE "users" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "account_id" integer NOT NULL, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)/!]AMindexindex_openstax_accounts_accounts_on_roleopenstax_accounts_accountsCREATE INDEX "index_openstax_accounts_accounts_on_role" ON "openstax_accounts_accounts" ("role")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")rMindexindex_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")rAAotableopenstax_accounts_accountsopenstax_accounts_accountsCREATE TABLE "openstax_accounts_accounts" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "openstax_uid" integer, "username" varchar, "access_token" varchar, "first_name" varchar, "last_name" varchar, "full_name" varchar, "title" varchar, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "faculty_status" integer DEFAULT 0 NOT NULL, "salesforce_contact_id" varchar, "uuid" varchar, "role" integer DEFAULT 0 NOT NULL)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_accountsCREATE UNIQUE INDEX "index_openstax_accounts_accounts_on_username" ON "openstax_accounts_accounts" ("username")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_accounts CREATE INDEX "index_openstax_accounts_accounts_on_first_name" ON "openstax_accounts_accounts" ("first_name")>gAaindexindex_openstax_accounts_accounts_on_last_nameopenstax_accounts_accounts CREATE INDEX "index_openstax_accounts_accounts_on_last_name" ON "openstax_accounts_accounts" ("last_name")>gAaindexindex_openstax_accounts_accounts_on_full_nameopenstax_accounts_accounts CREATE INDEX "index_openstax_accounts_accounts_on_full_name" ON "openstax_accounts_accounts" ("full_name")MqAuindexindex_openstax_accounts_accounts_on_faculty_statusopenstax_accounts_accountsCREATE INDEX "index_openstax_accounts_accounts_on_faculty_status" ON "openstax_accounts_accounts" ("faculty_status")bAindexindex_openstax_accounts_accounts_on_salesforce_contact_idopenstax_accounts_accountsCREATE INDEX "index_openstax_accounts_accounts_on_salesforce_contact_id" ON "openstax_accounts_accounts" ("salesforce_contact_id")6 ]A[indexindex_openstax_accounts_accounts_on_uuidopenstax_accounts_accountsCREATE UNIQUE INDEX "index_openstax_accounts_accounts_on_uuid" ON "openstax_accounts_accounts" ("uuid")