SQLite format 3@ )!)-æûû  T “ Ò Oj¥ìÅÈù½È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")‚9MMƒetableopenstax_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)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 ]A[indexindex_openstax_accounts_accounts_on_uuidopenstax_accounts_accounts CREATE UNIQUE INDEX "index_openstax_accounts_accounts_on_uuid" ON "openstax_accounts_accounts" ("uuid")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")/ ]AMindexindex_openstax_accounts_accounts_on_roleopenstax_accounts_accounts CREATE INDEX "index_openstax_accounts_accounts_on_role" ON "openstax_accounts_accounts" ("role")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)ƒrAA†otableopenstax_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                    ùùî@á¥f ' ø ª T 41½ÈrM‚indexindex_openstax_accounts_grrM‚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")‚9MMƒetableopenstax_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)ƒrAA†otableopenstax_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)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")/ ]AMindexindex_openstax_accounts_accounts_on_roleopenstax_accounts_accounts CREATE INDEX "index_openstax_accounts_accounts_on_role" ON "openstax_accounts_accounts" ("role")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")6 ]A[indexindex_openstax_accounts_accounts_on_uuidopenstax_accounts_accounts CREATE UNIQUE INDEX "index_openstax_accounts_accounts_on_uuid" ON "openstax_accounts_accounts" ("uuid")‚$ 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") 2*f[Mq j 5 ­ f /ËŠ¼2î/<‚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).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")h!!ƒtableownershipsownershipsCREATE 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)Fi=sindexindex_openstax_accounts_groups_on_openstax_uidopenstax_accounts_groupsCREATE UNIQUE INDEX "index_openstax_accounts_groups_on_openstax_uid" ON "openstax_=//indexunique_schema_migrationsschema_migrations!CREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")l//tableschema_migrationsschema_migrations CREATE TABLE "schema_migrations" ("version" varchar NOT NULL)‚9MMƒetableopenstax_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)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 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")‚u==„}tableopenstax_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, "cached_subtree_group_ids" text, "cached_supertree_group_ids" text, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)6c=Yindexindex_openstax_accounts_groups_on_is_publicopenstax_accounts_groupsCREATE INDEX "index_openstax_accounts_groups_on_is_public" ON "openstax_accounts_groups" ("is_public")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")h!!ƒtableownershipsownershipsCREATE 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).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")<‚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)t?indexindex_users_on_account_idusersCREATE UNIQUE INDEX "index_users_on_account_id" ON "users" ("account_id")           ¾øðëæáÜ×ÒÍÈþ 9 8 7 654321010001001 ³éãïøÝ×ÑËÅ¿¹³9 8 7 6 5432101000 1001