spec/dummy/db/test.sqlite3 in openstax_accounts-7.2.0 vs spec/dummy/db/test.sqlite3 in openstax_accounts-7.3.0

- old
+ new

@@ -1,31 +1,31 @@ -SQLite format 3@ $$-æûû ( d -£ â ,gRU†\guq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")rM‚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 mKmindexindex_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 -eAkindexindex_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")>gAaindexindex_openstax_accounts_accounts_on_last_nameopenstax_accounts_accountsCREATE INDEX "index_openstax_accounts_accounts_on_last_name" ON "openstax_accounts_accounts" ("last_name")>gAaindexindex_openstax_accounts_accounts_on_full_nameopenstax_accounts_accountsCREATE INDEX "index_openstax_accounts_accounts_on_full_name" ON "openstax_accounts_accounts" ("full_name")AiAeindexindex_openstax_accounts_accounts_on_first_nameopenstax_accounts_accountsCREATE INDEX "index_openstax_accounts_accounts_on_first_name" ON "openstax_accounts_accounts" ("first_name")MqAuindexindex_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( -   +SQLite format 3@ 1 -æûû 0 _ š +É + Dƒ B‰be–r‚!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)LmKmindexindex_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_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)> +gAaindexindex_openstax_accounts_accounts_on_full_nameopenstax_accounts_accounts CREATE INDEX "index_openstax_accounts_accounts_on_full_name" ON "openstax_accounts_accounts" ("full_name")> gAaindexindex_openstax_accounts_accounts_on_last_nameopenstax_accounts_accounts +CREATE INDEX "index_openstax_accounts_accounts_on_last_name" ON "openstax_accounts_accounts" ("last_name")AiAeindexindex_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")BeAkindexindex_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)ƒAA…tableopenstax_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 876543210 + ¹ûõ¹ïéãÝ×ÑË1001 1000 +8 7654321 0        - -       -  -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")MqAuindexindex_openstax_accounts_accounts_on_faculty_statusopenstax_accounts_accountsCREATE INDEX "index_openstax_accounts_accounts_on_faculty_status" ON "openstax_accounts_accounts" ("faculty_status")AiAeindexindex_openstax_accounts_accounts_on_first_nameopenstax_accounts_accountsCREATE INDEX "index_openstax_accounts_accounts_on_first_name" ON "openstax_accounts_accounts" ("first_name")>gAaindexindex_openstax_accounts_accounts_on_full_nameopenstax_accounts_accountsCREATE INDEX "index_openstax_accounts_accounts_on_full_name" ON "openstax_accounts_accounts" ("full_name")>gAaindexindex_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")MqAuindexindex_openstax_accounts_accounts_on_faculty_statusopenstax_accounts_accountsCREATE INDEX "index_openstax_accounts_accounts_on_faculty_status" ON "openstax_accounts_accounts" ("faculty_status")AiAeindexindex_openstax_accounts_accounts_on_first_nameopenstax_accounts_accountsCREATE INDEX "index_openstax_accounts_accounts_on_first_name" ON "openstax_accounts_accounts" ("first_name")>gAaindexindex_openstax_accounts_accounts_on_full_nameopenstax_accounts_accountsCREATE INDEX "index_openstax_accounts_accounts_on_full_name" ON "openstax_accounts_accounts" ("full_name")>gAaindexindex_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 -eAkindexindex_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)HkIiindexindex_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 mKmindexindex_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)rM‚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)vI‚)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")   + ¥¥ï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")ƒAA…tableopenstax_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")BeAkindexindex_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)zK‚-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")LmKmindexindex_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)vI‚)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")HkIiindexindex_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")‚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) + $À²§i : ÿ +Ð ” U  æËŠÕ$C< ‚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)bA‚indexindex_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")MqAuindexindex_openstax_accounts_accounts_on_faculty_statusopenstax_accounts_accountsCREATE INDEX "index_openstax_accounts_accounts_on_faculty_status" ON "openstax_accounts_accounts" ("faculty_status")>gAaindexindex_openstax_accounts_accounts_on_full_nameopenstax_accounts_accounts CREATE INDEX "index_op.#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)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")rM‚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")ƒ?AA† tableopenstax_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)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")BeAkindexindex_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")AiAeindexindex_openstax_accounts_accounts_on_first_nameopenstax_accounts_accounts CREATE INDEX "index_openstax_accounts_accounts_on_first_name" ON "openstax_accounts_accounts" ("first_name")>gAaindexindex_openstax_accounts_accounts_on_last_nameopenstax_accounts_accounts +CREATE INDEX "index_openstax_accounts_accounts_on_last_name" ON "openstax_accounts_accounts" ("last_name")>gAaindexindex_openstax_accounts_accounts_on_full_nameopenstax_accounts_accounts CREATE INDEX "index_openstax_accounts_accounts_on_full_name" ON "openstax_accounts_accounts" ("full_name")MqAuindexindex_openstax_accounts_accounts_on_faculty_statusopenstax_accounts_accountsCREATE INDEX "index_openstax_accounts_accounts_on_faculty_status" ON "openstax_accounts_accounts" ("faculty_status")bA‚indexindex_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")< ‚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")   + + + +     -  - ÍøðëæáÜ×ÒÍ 654321010001001 - ÅéãïøÝ×ÑËÅ6 5432101000 1001 + \ No newline at end of file