SQLite format 3@ $$-æûû ( d £ â ,gRU†\guqoM‚indexindex_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")rM‚indexindex_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")‚'MMƒAtableopenstax_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, "updated_at" datetime)L mKmindexindex_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")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")‚ KKƒtableopenstax_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)B eAkindexindex_openstax_accounts_accounts_on_usernameopenstax_accounts_accounts CREATE UNIQUE INDEX "index_openstax_accounts_accounts_on_username" ON "openstax_accounts_accounts" ("username")b A‚indexindex_openstax_accounts_accounts_on_salesforce_contact_idopenstax_accounts_accounts CREATE INDEX "index_openstax_accounts_accounts_on_salesforce_contact_id" ON "openstax_accounts_accounts" ("salesforce_contact_id")NmA{indexindex_openstax_accounts_accounts_on_openstax_uidopenstax_accounts_accounts CREATE 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")MqAuindexindex_openstax_accounts_accounts_on_faculty_statusopenstax_accounts_accountsCREATE INDEX "index_openstax_accounts_accounts_on_faculty_status" ON "openstax_accounts_accounts" ("faculty_status")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)ƒbAA†Otableopenstax_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, "faculty_status" integer DEFAULT 0 NOT NULL, "salesforce_contact_id" varchar(                  gg L ž o ?  Ä …V;ü   Ý  üîƒbAA†Otableopenstax_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, "faculty_status" integer DEFAULT 0 NOT NULL, "salesforce_contact_id" varchar(255))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")MqAuindexindex_openstax_accounts_accounts_on_faculty_statusopenstax_accounts_accountsCREATE INDEX "index_openstax_accounts_accounts_on_faculty_status" ON "openstax_accounts_accounts" ("faculty_status")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_accounts CREATE UNIQUE INDEX "index_openstax_accounts_accounts_on_openstax_uid" ON "openstax_accounts_accounts" ("openstax_uid")b A‚indexindex_ƒbAA†Otableopenstax_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, "faculty_status" integer DEFAULT 0 NOT NULL, "salesforce_contact_id" varchar(255))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")MqAuindexindex_openstax_accounts_accounts_on_faculty_statusopenstax_accounts_accountsCREATE INDEX "index_openstax_accounts_accounts_on_faculty_status" ON "openstax_accounts_accounts" ("faculty_status")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_accounts CREATE UNIQUE INDEX "index_openstax_accounts_accounts_on_openstax_uid" ON "openstax_accounts_accounts" ("openstax_uid")b A‚indexindex_openstax_accounts_accounts_on_salesforce_contact_idopenstax_accounts_accounts CREATE INDEX "index_openstax_accounts_accounts_on_salesforce_contact_id" ON "openstax_accounts_accounts" ("salesforce_contact_id")B eAkindexindex_openstax_accounts_accounts_on_usernameopenstax_accounts_accounts CREATE UNIQUE INDEX "index_openstax_accounts_accounts_on_username" ON "openstax_accounts_accounts" ("username")  œ   ä   õ8ÍKm¼™&œ=//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")‚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)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")‚ KKƒtableopenstax_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")L mKmindexindex_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")‚'MMƒAtableopenstax_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, "updated_at" datetime)rM‚indexindex_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")oM‚indexindex_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")‚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, "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")         ÍøðëæáÜ×ÒÍ 654321010001001 ÅéãïøÝ×ÑËÅ6 5432101000 1001