spec/dummy/db/development.sqlite3 in coalescing_panda-3.1.11 vs spec/dummy/db/development.sqlite3 in coalescing_panda-3.1.12

- old
+ new

@@ -1,36 +1,32 @@ -SQLite format 3@ &)'&-% 0 3s]I??tablecoalescing_panda_sectionscoalescing_panda_sectionsCREATE TABLE "coalescing_panda_sections" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "coalescing_panda_course_id" integer, "name" varchar(255), "canvas_section_id" varchar(255), "sis_id" varchar(255), "workflow_state" varchar(255), "start_at" datetime, "end_at" datetime, "created_at" datetime, "updated_at" datetime)-]=Mindexindex_coalescing_panda_courses_on_sis_idcoalescing_panda_coursesCREATE INDEX "index_coalescing_panda_courses_on_sis_id" ON "coalescing_panda_courses" ("sis_id")Kq=uindexindex_coalescing_panda_courses_on_canvas_course_idcoalescing_panda_coursesCREATE INDEX "index_coalescing_panda_courses_on_canvas_course_id" ON "coalescing_panda_courses" ("canvas_course_id") 1=Eindexindex_courses_termcoalescing_panda_coursesCREATE INDEX "index_courses_term" ON "coalescing_panda_courses" ("coalescing_panda_term_id") 7=Yindexindex_courses_accountcoalescing_panda_courses CREATE INDEX "index_courses_account" ON "coalescing_panda_courses" ("coalescing_panda_lti_account_id")H ==#tablecoalescing_panda_coursescoalescing_panda_courses CREATE TABLE "coalescing_panda_courses" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "coalescing_panda_lti_account_id" integer, "coalescing_panda_term_id" integer, "name" varchar(255), "canvas_course_id" varchar(255), "sis_id" varchar(255), "start_at" datetime, "conclude_at" datetime, "workflow_state" varchar(255), "course_code" varchar(255), "created_at" datetime, "updated_at" datetime)% +SQLite format 3@ @)U@-% 0 3s]I??tablecoalescing_panda_sectionscoalescing_panda_sectionsCREATE TABLE "coalescing_panda_sections" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "coalescing_panda_course_id" integer, "name" varchar(255), "canvas_section_id" varchar(255), "sis_id" varchar(255), "workflow_state" varchar(255), "start_at" datetime, "end_at" datetime, "created_at" datetime, "updated_at" datetime)-]=Mindexindex_coalescing_panda_courses_on_sis_idcoalescing_panda_coursesCREATE INDEX "index_coalescing_panda_courses_on_sis_id" ON "coalescing_panda_courses" ("sis_id")Kq=uindexindex_coalescing_panda_courses_on_canvas_course_idcoalescing_panda_coursesCREATE INDEX "index_coalescing_panda_courses_on_canvas_course_id" ON "coalescing_panda_courses" ("canvas_course_id") 1=Eindexindex_courses_termcoalescing_panda_coursesCREATE INDEX "index_courses_term" ON "coalescing_panda_courses" ("coalescing_panda_term_id") 7=Yindexindex_courses_accountcoalescing_panda_courses CREATE INDEX "index_courses_account" ON "coalescing_panda_courses" ("coalescing_panda_lti_account_id")H ==#tablecoalescing_panda_coursescoalescing_panda_courses CREATE TABLE "coalescing_panda_courses" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "coalescing_panda_lti_account_id" integer, "coalescing_panda_term_id" integer, "name" varchar(255), "canvas_course_id" varchar(255), "sis_id" varchar(255), "start_at" datetime, "conclude_at" datetime, "workflow_state" varchar(255), "course_code" varchar(255), "created_at" datetime, "updated_at" datetime)% Y9Eindexindex_coalescing_panda_terms_on_sis_idcoalescing_panda_terms CREATE INDEX "index_coalescing_panda_terms_on_sis_id" ON "coalescing_panda_terms" ("sis_id")= i9eindexindex_coalescing_panda_terms_on_canvas_term_idcoalescing_panda_terms -CREATE INDEX "index_coalescing_panda_terms_on_canvas_term_id" ON "coalescing_panda_terms" ("canvas_term_id")99;tablecoalescing_panda_termscoalescing_panda_terms CREATE TABLE "coalescing_panda_terms" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "coalescing_panda_lti_account_id" integer, "name" varchar(255), "code" varchar(255), "sis_id" varchar(255), "canvas_term_id" varchar(255), "start_at" datetime, "end_at" datetime, "workflow_state" varchar(255), "created_at" datetime, "updated_at" datetime)gGGMtablecoalescing_panda_lti_accountscoalescing_panda_lti_accountsCREATE TABLE "coalescing_panda_lti_accounts" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "key" varchar(255), "secret" varchar(255), "oauth2_client_id" varchar(255), "oauth2_client_key" varchar(255), "created_at" datetime, "updated_at" datetime, "settings" text)vCCstablecoalescing_panda_lti_noncescoalescing_panda_lti_noncesCREATE TABLE "coalescing_panda_lti_nonces" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "coalescing_panda_lti_account_id" integer, "nonce" varchar(255), "timestamp" datetime)lGG+tablecoalescing_panda_lti_accountscoalescing_panda_lti_accountsCREATE TABLE "coalescing_pandaj??ctablecoalescing_panda_sessionscoalescing_panda_sessionsCREATE TABLE "coalescing_panda_sessions" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "token" varchar(255), "data" text, "created_at" datetime, "updated_at" datetime)P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq),OOGtablecoalescing_panda_canvas_api_authscoalescing_panda_canvas_api_authsCREATE TABLE "coalescing_panda_canvas_api_auths" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" varchar(255), "api_domain" varchar(255), "api_token" varchar(255), "created_at" datetime, "updated_at" datetime)=//indexunique_schema_migrationsschema_migrationsCREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")q//tableschema_migrationsschema_migrationsCREATE TABLE "schema_migrations" ("version" varchar(255) p^L:()20141125185516)20141124160857)20141121174846 )20141120205729 )20141120153135 )20141120152546 +CREATE INDEX "index_coalescing_panda_terms_on_canvas_term_id" ON "coalescing_panda_terms" ("canvas_term_id")99;tablecoalescing_panda_termscoalescing_panda_terms CREATE TABLE "coalescing_panda_terms" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "coalescing_panda_lti_account_id" integer, "name" varchar(255), "code" varchar(255), "sis_id" varchar(255), "canvas_term_id" varchar(255), "start_at" datetime, "end_at" datetime, "workflow_state" varchar(255), "created_at" datetime, "updated_at" datetime)gGGMtablecoalescing_panda_lti_accountscoalescing_panda_lti_accountsCREATE TABLE "coalescing_panda_lti_accounts" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "key" varchar(255), "secret" varchar(255), "oauth2_client_id" varchar(255), "oauth2_client_key" varchar(255), "created_at" datetime, "updated_at" datetime, "settings" text)vCCstablecoalescing_panda_lti_noncescoalescing_panda_lti_noncesCREATE TABLE "coalescing_panda_lti_nonces" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "coalescing_panda_lti_account_id" integer, "nonce" varchar(255), "timestamp" datetime)lGG+tablecoalescing_panda_lti_accountscoalescing_panda_lti_accountsCREATE TABLE "coalescing_pandaj??ctablecoalescing_panda_sessionscoalescing_panda_sessionsCREATE TABLE "coalescing_panda_sessions" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "token" varchar(255), "data" text, "created_at" datetime, "updated_at" datetime)P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq),OOGtablecoalescing_panda_canvas_api_authscoalescing_panda_canvas_api_authsCREATE TABLE "coalescing_panda_canvas_api_auths" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" varchar(255), "api_domain" varchar(255), "api_token" varchar(255), "created_at" datetime, "updated_at" datetime)=//indexunique_schema_migrationsschema_migrationsCREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")q//tableschema_migrationsschema_migrationsCREATE TABLE "schema_migrations" ("version" varchar(255)7+ p^L:()20141124160857)20141121174846 )20141120205729 )20141120153135 )20141120152546 )20141120152458 )20141120151940)20141120151432)20141119225721)20141119225319)20140904223159)20140722210735)20131119165343)20131118211442)20131114150001 -|iVC0 -)20141125185516)20141124160857)20141121174846)20141120205729 )20141120153135 )20141120152546 )20141120152458 -)20141120151940 )20141120151432)20141119225721)20141119225319)20140904223159)20140722210735)20131119165343)20131118211442) 20131114150001  0gL Ecoalescing_panda_assignmentsE coalescing_panda_submissions! coalescing_panda_assignments9coalescing_panda_terms9 coalescing_panda_usersE coalescing_panda_enrollments? coalescing_panda_sections= coalescing_panda_courses coalescing_panda_term!Gcoalescing_panda_lti_accounts fffN -AAakdsghatealskjdg2014-11-20 18:18:47.6438472014-11-20 18:18:47.643847JAAtest: -aa -a2014-11-20 18:04:55.8142722014-11-20 18:04:55.814272   {{A AA2014-11-20 18:17:54.7566242014-11-20 18:24:53.230834@ AA2014-11-20 18:05:05.3268582014-11-20 18:05:05.326858 - - C AA2014-11-20 18:05:14.1275262014-11-20 18:25:59.347263 -  -  - - ? AA2014-11-20 18:11:52.4151462014-11-20 18:15:23.402196 - ebMF 3 - . 2 q//tableschema_migrationsschema_migrationsCREATE TABLE "schema_migrations" ("version" varchar(255) NOT NULL)=//indexunique_schema_migrationsschema_migrationsCREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version"),OOGtablecoalescing_panda_canvas_api_authscoalescing_panda_canvas_api_authsCREATE TABLE "coalescing_panda_canvas_api_auths" ("id" INTEGER PRIMARY KEY GGtablecoalescing_panda_lti_accountscoalescing_panda_lti_accountsCREATE TABLE "coalescing_panda_lti_accounts" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "key" varchar(255), "secret" varchar(255), "oauth2_client_id" varchar(255), "oauth2_client_key" varchar(255), "created_at" datetime, "updated_at" datetime, "settings" text, "canvas_account_id" varchar(255))q//tableschema_migrationsschema_migrationsCREATE TABLE "schema_migrations" ("version" varchar(255) NOT NULL)=//indexunique_schema_migrationsschema_migrationsCREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version"),OOGtablecoalescing_panda_canvas_api_authscoalescing_panda_canvas_api_authsCREATE TABLE "coalescing_panda_canvas_api_auths" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" varchar(255), "api_domain" varchar(255), "api_token" varchar(255), "created_at" datetime, "updated_at" datetime)P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)jGGMtablecoalescing_panda_lti_accountscoalescing_panda_lti_accountsCREATE TABLE "coalescing_panda_lti_accounts" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "key" varchar(255), "secret" varchar(255), "oauth2_client_id" varchar(255), "oauth2_client_key" varchar(255), "created_at" datetime, "updated_at" datetime, "settings" text)vCCstablecoalescing_panda_lti_noncescoalescing_panda_lti_noncesCREATE TABLE "coalescing_panda_lti_nonces" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "coalescing_panda_lti_account_id" integer, "nonce" varchar(255), "timestamp" datetime)j??ctablecoalescing_panda_sessionscoalescing_panda_sessionsCREATE TABLE "coalescing_panda_sessions" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "token" varchar(255), "data" text, "created_at" datetime, "updated_at" datetime)99;tablecoalescing_panda_termscoalescing_panda_terms CREATE TABLE "coalescing_panda_terms" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "coalescing_panda_lti_account_id" integer, "name" varchar(255), "code" varchar(255), "sis_id" varchar(255), "canvas_term_id" varchar(255), "start_at" datetime, "end_at" datetime, "workflow_state" varchar(255), "created_at" datetime, "updated_at" datetime)= i9eindexindex_coalescing_panda_terms_on_canvas_term_idcoalescing_panda_terms -CREATE INDEX "index_coalescing_panda_terms_on_canvas_term_id" ON "coalescing_panda_terms" ("canvas_term_id")% -Y9Eindexindex_coalescing_panda_terms_on_sis_idcoalescing_panda_terms CREATE INDEX "index_coalescing_panda_terms_on_sis_id" ON "coalescing_panda_terms" ("sis_id")H ==#tablecoalescing_panda_coursescoalescing_panda_courses CREATE TABLE "coalescing_panda_courses" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "coalescing_panda_lti_account_id" integer, "coalescing_panda_term_id" integer, "name" varchar(255), "canvas_course_id" varchar(255), "sis_id" varchar(255), "start_at" datetime, "conclude_at" datetime, "workflow_state" varchar(255), "course_code" varchar(255), "created_at" datetime, "updated_at" datetime) 7=Yindexindex_courses_accountcoalescing_panda_courses CREATE INDEX "index_courses_account" ON "coalescing_panda_courses" ("coalescing_panda_lti_account_id") 1=Eindexindex_courses_termcoalescing_panda_coursesCREATE INDEX "index_courses_term" ON "coalescing_panda_courses" ("coalescing_panda_term_id")Kq=uindexindex_coalescing_panda_courses_on_canvas_course_idcoalescing_panda_coursesCREATE INDEX "index_coalescing_panda_courses_on_canvas_course_id" ON "coalescing_panda_courses" ("canvas_course_id") - BBwh= - x c #@ |p=i9eindexindex_coalescing_panda_users_on_EE?tablRu?}indexindex_coalescing_panda_sections_on_canvas_section_idcoalescing_panda_sectionsCREATE INDEX "index_coalescing_panda_sections_on_canvas_section_id" ON "coalescing_panda_sections" ("canvas_section_id")1_?Qindexindex_coalescing_panda_sections_on_sis_idcoalescing_panda_sectionsCREATE INDEX "index_coalescing_panda_sections_on_sis_id" ON "coalescing_panda_sections" ("sis_id")XEE3tablecoalescing_panda_assignmentscoalescing_panda_assignmentsCREATE TABLE "coalescing_panda_assignments" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "coalescing_panda_course_id" integer, "name" varchar(255), "description" varchar(255), "canvas_assignment_id" varchar(255), "sis_id" varchar(255), "workflow_state" varchar(255), "points_possible" float, "due_at" datetime, "unlock_at" datetime, "lock_at" datetime, "created_at" datetime, "updated_at" datetime))=E]indexindex_assignments_coursecoalescing-]=Mindexindex_coalescing_panda_courses_on_sis_idcoalescing_panda_coursesCREATE INDEX "index_coalescing_panda_courses_on_sis_id" ON "coalescing_panda_courses" ("sis_id")??tablecoalescing_panda_sectionscoalescing_panda_sectionsCREATE TABLE "coalescing_panda_sections" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "coalescing_panda_course_id" integer, "name" varchar(255), "canvas_section_id" varchar(255), "sis_id" varchar(255), "workflow_state" varchar(255), "start_at" datetime, "end_at" datetime, "created_at" datetime, "updated_at" datetime)n?!indexindex_coalescing_panda_sections_on_coalescing_panda_course_idcoalescing_panda_sectionsCREATE INDEX "index_coalescing_panda_sections_on_coalescing_panda_course_id" ON "coalescing_panda_sections" ("coalescing_panda_course_id")Ru?}indexindex_coalescing_panda_sections_on_canvas_section_idcoalescing_panda_sectionsCREATE INDEX "index_coalescing_panda_sections_on_canvas_section_id" ON "coalescing_panda_sections" ("canvas_section_id")1_?Qindexindex_coalescing_panda_sections_on_sis_idcoalescing_panda_sectionsCREATE INDEX "index_coalescing_panda_sections_on_sis_id" ON "coalescing_panda_sections" ("sis_id")XEE3tablecoalescing_panda_assignmentscoalescing_panda_assignmentsCREATE TABLE "coalescing_panda_assignments" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "coalescing_panda_course_id" integer, "name" varchar(255), "description" varchar(255), "canvas_assignment_id" varchar(255), "sis_id" varchar(255), "workflow_state" varchar(255), "points_possible" float, "due_at" datetime, "unlock_at" datetime, "lock_at" datetime, "created_at" datetime, "updated_at" datetime))=E]indexindex_assignments_coursecoalescing_panda_assignmentsCREATE INDEX "index_assignments_course" ON "coalescing_panda_assignments" ("coalescing_panda_course_id")hEindexindex_coalescing_panda_assignments_on_canvas_assignment_idcoalescing_panda_assignmentsCREATE INDEX "index_coalescing_panda_assignments_on_canvas_assignment_id" ON "coalescing_panda_assignments" ("canvas_assignment_id")=eE]indexindex_coalescing_panda_assignments_on_sis_idcoalescing_panda_assignmentsCREATE INDEX "index_coalescing_panda_assignments_on_sis_id" ON "coalescing_panda_assignments" ("sis_id")99tablecoalescing_panda_userscoalescing_panda_usersCREATE TABLE "coalescing_panda_users" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "coalescing_panda_lti_account_id" integer, "name" varchar(255), "email" varchar(255), "roles" varchar(255), "workflow_state" varchar(255), "sis_id" varchar(255), "canvas_user_id" varchar(255), "created_at" datetime, "updated_at" datetime)39Qindexindex_users_accountcoalescing_panda_usersCREATE INDEX "index_users_account" ON "coalescing_panda_users" ("coalescing_panda_lti_account_id")=i9eindexindex_coalescing_panda_users_on_canvas_user_idcoalescing_panda_usersCREATE INDEX "index_coalescing_panda_users_on_canvas_user_id" ON "coalescing_panda_users" ("canvas_user_id") - xxB AA2014-11-20 18:31:07.3317122014-11-20 18:31:57.300070B AA2014-11-20 18:26:23.7333592014-11-20 18:26:23.733359 -  - - @ AA2014-11-20 18:17:01.2873262014-11-20 18:20:37.460713 -  - - A AA2014-11-20 18:29:38.6574682014-11-20 18:32:12.573150 -   - ? AA2014-11-20 18:15:59.4189002014-11-20 18:17:15.057689 - - Z  - 2qh3EEitablecoalescing_panda_enrollmentscoalescing_panda_enrollments"CREATE TABLE "coalescing_panda_enrollments" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "coalescing_panda_user_id" integer, "coalescing_panda_section_id" integer, "workflow_state" varchar(255), "sis_id" varchar(255), "canvas_enrollment_id" varchar(255), "start_at" datetime, "end_at" datetime, "created_at" datetime, "updated_at" datetime, "type" varchar(255)){%7%'indexdelayed_jobs_prioritydelayed_jobs)CREATE INDEX "delayed_jobs_priority" ON "delayed_jobs" ("priority", "run_at") $%%Utabledelayed_jobsdelayed_jobs(CREATE TABLE "delayed_jobs" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "priority" integer DEFAULT 0 NOT NULL, "attempts" integer DEFAULT 0 NOT NULL, "handler" text NOT NULL, "last_error" text, "run_at" datetime, "locked_at" datetime, "failed_at" datetime, "locked_by" varchar(255), "queue" varchar(255), "created_at" datetime, "updated_at" datetime)&#KKCtablecoalescing_panda_canvas_batchescoalescing_panda_canvas_batches'CREATE TABLE "coalescing_panda_canvas_batches" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "percent_complete" float DEFAULT 0.0, "status" varchar(255), "message" text, "created_at" datetime, "updated_at" datetime)="eE]indexindex_coalescing_panda_enrollments_on_sis_idcoalescing_panda_enrollments&CREATE INDEX "index_coalescing_panda_enrollments_on_sis_id" ON "coalescing_panda_enrollments" ("sis_id")%Y9Eindexindex_coalescing_panda_users_on_sis_idcoalescing_panda_usersCREATE INDEX "index_coalescing_panda_users_on_sis_id" ON "coalescing_panda_users" ("sis_id");EEytablecoalescing_panda_submissionscoalescing_panda_submissionsCREATE TABLE "coalescing_panda_submissions" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "coalescing_panda_user_id" integer, "coalescing_panda_assignment_id" integer, "url" varchar(255), "grade" varchar(255), "score" varchar(255), "submitted_at" datetime, "workflow_state" varchar(255), "canvas_submission_id" varchar(255), "created_at" datetime, "updated_at" datetime)cWE7indexindex_submissions_user_and_assignmentcoalescing_panda_submissions CREATE INDEX "index_submissions_user_and_assignment" ON "coalescing_panda_submissions" ("coalescing_panda_user_id", "coalescing_panda_assignment_id")hEindexindex_coalescing_panda_submissions_on_canvas_submission_idcoalescing_panda_submissions!CREATE INDEX "index_coalescing_panda_submissions_on_canvas_submission_id" ON "coalescing_panda_submissions" ("canvas_submission_id")EE?tablecoalescing_panda_enrollmentscoalescing_panda_enrollments"CREATE TABLE "coalescing_panda_enrollments" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "coalescing_panda_user_id" integer, "coalescing_panda_section_id" integer, "workflow_state" varchar(255), "sis_id" varchar(255), "canvas_enrollment_id" varchar(255), "start_at" datetime, "end_at" datetime, "created_at" datetime, "updated_at" datetime)` WE1indexindex_enrollments_user_and_assignmentcoalescing_panda_enrollments#CREATE INDEX "index_enrollments_user_and_assignment" ON "coalescing_panda_enrollments" ("coalescing_panda_user_id", "coalescing_panda_section_id")h!Eindexindex_coalescing_panda_enrollments_on_canvas_enrollment_idcoalescing_panda_enrollments$CREATE INDEX "index_coalescing_panda_enrollments_on_canvas_enrollment_id" ON "coalescing_panda_enrollments" ("canvas_enrollment_id") -   - +|iVC0 +)20141124160857)20141121174846)20141120205729 )20141120153135 )20141120152546 )20141120152458 +)20141120151940 )20141120151432)20141119225721)20141119225319)20140904223159)20140722210735)20131119165343)20131118211442) 20131114150001       + + +  + + + +  +    v Q <  q//tableschema_migrationsschema_migrationsCREATE TABLE "schema_migrations" ("version" varchar(255) NOT NULL)=//indexunique_schema_migrationsschema_migrationsCREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version"),OOGtablecoalescing_panda_canvas_api_authscoalescing_panda_canvas_api_authsCREATE TABLE "coalescing_panda_canvas_api_auths" ("id" INTEGER PRIMARY KEY GGtablecoalescing_panda_lti_accountscoalescing_panda_lti_accountsCREATEq//tableschema_migrationsschema_migrationsCREATE TABLE "schema_migrations" ("version" varchar(255) NOT NUq//tableschema_migrationsschema_migrationsCREATE TABLE "schema_migrations" ("version" varchar(255) NOT NULL)=//indexunique_schema_migrationsschema_migrationsCREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)99tablecoalescing_panda_userscoalescing_panda_usersCREATE TABLE "coalescing_panda_users" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "coalescing_panda_lti_account_id" integer, "name" varchar(255), "email" varchar(255), "roles" varchar(255), "workflow_state" varchar(255), "sis_id" varchar(255), "canvas_user_id" varchar(255), "created_at" datetime, "updated_at" datetime)39Qindexindex_users_accountcoalescing_panda_usersCREATE INDEX "index_users_account" ON "coalescing_panda_users" ("coalescing_panda_lti_account_id")i9eindexindex_coalescing_panda_users_on_canvas_user_idcoalescing_panda_usersCREATE INDEX "index_coalescing_panda_users_on_canvas_user_id" ON "coalescing_panda_users" ("canvas_user_id")Y9Eindexindex_coalescing_panda_users_on_sis_idcoalescing_panda_usersCREATE INDEX "index_coalescing_panda_users_on_sis_id" ON "coalescing_panda_users" ("sis_id")%%Utabledelayed_jobsdelayed_jobs(CREATE TABLE "delayed_jobs" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "priority" integer DEFAULT 0 NOT NULL, "attempts" integer DEFAULT 0 NOT NULL, "handler" text NOT NULL, "last_error" text, "run_at" datetime, "locked_at" datetime, "failed_at" datetime, "locked_by" varchar(255), "queue" varchar(255), "created_at" datetime, "updated_at" datetime)}7%'indexdelayed_jobs_prioritydelayed_jobs)CREATE INDEX "delayed_jobs_priority" ON "delayed_jobs" ("priority", "run_at")X&EE3tablecoalescing_panda_assignmentscoalescing_panda_assignmentsCREATE TABLE "coalescing_panda_assignments" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "coalescing_panda_course_id" integer, "name" varchar(255), "description" varchar(255), "canvas_assignment_id" varchar(255), "sis_id" varchar(255), "workflow_state" varchar(255), "points_possible" float, "due_at" datetime, "unlock_at" datetime, "lock_at" datetime, "created_at" datetime, "updated_at" datetime)h'Eindexindex_coalescing_panda_assignments_on_canvas_assignment_idcoalescing_panda_assignmentsCREATE INDEX "index_coalescing_panda_assignments_on_canvas_assignment_id" ON "coalescing_panda_assignments" ("canvas_assignment_id"))(=E]indexindex_assignments_coursecoalescing_panda_assignmentsCREATE INDEX "index_assignments_course" ON "coalescing_panda_assignments" ("coalescing_panda_course_id")=)eE]indexindex_coalescing_panda_assignments_on_sis_idcoalescing_panda_assignmentsCREATE INDEX "index_coalescing_panda_assignments_on_sis_id" ON "coalescing_panda_assignments" ("sis_id"),*OOGtablecoalescing_panda_canvas_api_authscoalescing_panda_canvas_api_authsCREATE TABLE "coalescing_panda_canvas_api_auths" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" varchar(255), "api_domain" varchar(255), "api_token" varchar(255), "created_at" datetime, "updated_at" datetime)&+KKCtablecoalescing_panda_canvas_batchescoalescing_panda_canvas_batches'CREATE TABLE "coalescing_panda_canvas_batches" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "percent_complete" float DEFAULT 0.0, "status" varchar(255), "message" text, "created_at" datetime, "updated_at" datetime) + EE h +S 6 { |p=i9eindexindex_coalescing_panda_users_on_EE?tablRu?}indexindex_coalescing_panda_sections_on_canvas_section_idcoalescing_panda_sectionsCREATE INDEX "index_coalescing_panda_sections_on_canvas_section_id" ON "coalescing_panda_sections" ("canvas_section_id")1_?Qindexindex_coalescing_panda_sections_on_sis_idcoalescing_panda_sectionsCREATE INDEX "index_coalescing_panda_sections_on_sis_id" ON "coalescing_panda_sections" ("sis_id")XEE3tablecoalescing_panda_assignmentscoalescing_panda_assignmentsCREATE TABLE "coalescing_panda_assignments" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "coalescing_panda_course_id" integer, "n39Qindexindex_users_accountcoalescing_panda_usersCREATE IH,==#tablecoalescing_panda_coursescoalescing_panda_courses CREATE TABLE "coalescing_panda_courses" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "coalescing_panda_lti_account_id" integer, "coalescing_panda_term_id" integer, "name" varchar(255), "canvas_course_id" varchar(255), "sis_id" varchar(255), "start_at" datetime, "conclude_at" datetime, "workflow_state" varchar(255), "course_code" varchar(255), "created_at" datetime, "updated_at" datetime)K-q=uindexindex_coalescing_panda_courses_on_canvas_course_idcoalescing_panda_courses CREATE INDEX "index_coalescing_panda_courses_on_canvas_course_id" ON "coalescing_panda_courses" ("canvas_course_id") .7=Yindexindex_courses_accountcoalescing_panda_coursesCREATE INDEX "index_courses_account" ON "coalescing_panda_courses" ("coalescing_panda_lti_account_id")/1=Eindexindex_courses_termcoalescing_panda_coursesCREATE INDEX "index_courses_term" ON "coalescing_panda_courses" ("coalescing_panda_term_id")-0]=Mindexindex_coalescing_panda_courses_on_sis_idcoalescing_panda_coursesCREATE INDEX "index_coalescing_panda_courses_on_sis_id" ON "coalescing_panda_courses" ("sis_id")1EE?tablecoalescing_panda_enrollmentscoalescing_panda_enrollments"CREATE TABLE "coalescing_panda_enrollments" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "coalescing_panda_user_id" integer, "coalescing_panda_section_id" integer, "workflow_state" varchar(255), "sis_id" varchar(255), "canvas_enrollment_id" varchar(255), "start_at" datetime, "end_at" datetime, "created_at" datetime, "updated_at" datetime)h2Eindexindex_coalescing_panda_enrollments_on_canvas_enrollment_idcoalescing_panda_enrollments#CREATE INDEX "index_coalescing_panda_enrollments_on_canvas_enrollment_id" ON "coalescing_panda_enrollments" ("canvas_enrollment_id")`3WE1indexindex_enrollments_user_and_assignmentcoalescing_panda_enrollments$CREATE INDEX "index_enrollments_user_and_assignment" ON "coalescing_panda_enrollments" ("coalescing_panda_user_id", "coalescing_panda_section_id")=4eE]indexindex_coalescing_panda_enrollments_on_sis_idcoalescing_panda_enrollments&CREATE INDEX "index_coalescing_panda_enrollments_on_sis_id" ON "coalescing_panda_enrollments" ("sis_id") 5GGtablecoalescing_panda_lti_accountscoalescing_panda_lti_accountsCREATE TABLE "coalescing_panda_lti_accounts" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "key" varchar(255), "secret" varchar(255), "oauth2_client_id" varchar(255), "oauth2_client_key" varchar(255), "created_at" datetime, "updated_at" datetime, "settings" text, "canvas_account_id" varchar(255))v6CCstablecoalescing_panda_lti_noncescoalescing_panda_lti_noncesCREATE TABLE "coalescing_panda_lti_nonces" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "coalescing_panda_lti_account_id" integer, "nonce" varchar(255), "timestamp" datetime)7??tablecoalescing_panda_sectionscoalescing_panda_sectionsCREATE TABLE "coalescing_panda_sections" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "coalescing_panda_course_id" integer, "name" varchar(255), "canvas_section_id" varchar(255), "sis_id" varchar(255), "workflow_state" varchar(255), "start_at" datetime, "end_at" datetime, "created_at" datetime, "updated_at" datetime) +  + + +  + + +  + +   + + wL = + m2=)eE]indexindex_coalescingn9?!indexindex_coalescing_panda_sect{G7%'indexdelayed_jobs_prioritydelayed_jobs)CREATE INDEX "delayed_jobs_priority" ON "delayed_jobs" ("priority", "run_at") F%%Utabledelayed_jobsdelayed_jobs(CREATE TABLE "delayed_jobs" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "priority" integer DEFAULT 0 NOT NULL, "attempts" integer DEFAULT 0 NOT NULL, "handler" text NOT NULL, "last_error" text, "run_at" datetime, "locked_at" datetime, "failed_at" datetime, "locked_by" varchar(255), "queue" varchar(255), "created_at" datetime, "updated_at" datetime)%EY9Eindexindex_coalescing_panda_users_on_sis_idcoalescing_panda_usersCREATE INDEX "index_coalescing_panda_users_on_sis_id" ON "coalescing_panda_users" ("sis_id")D39Qindexindex_users_accountcoalescing_panda_usersCREATE INDEX "index_users_account" ON "coalescing_panda_users" ("coalescing_panda_lti_account_id")=Ci9eindexindex_coalescing_panda_users_on_canvas_user_idcoalescing_panda_usersCREATE INDEX "index_coalescing_panda_users_on_canvas_user_id" ON "coalescing_panda_users" ("canvas_user_id")B99tablecoalescing_panda_userscoalescing_panda_usersCREATE TABLE "coalescing_panda_users" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "coalescing_panda_lti_account_id" integer, "name" varchar(255), "email" varchar(255), "roles" varchar(255), "workflow_state" varchar(255), "sis_id" varchar(255), "canvas_user_id" varchar(255), "created_at" datetime, "updated_at" datetime)%AY9Eindexindex_coalescing_panda_terms_on_sis_idcoalescing_panda_terms CREATE INDEX "index_coalescing_panda_terms_on_sis_id" ON "coalescing_panda_terms" ("sis_id")=@i9eindexindex_coalescing_panda_terms_on_canvas_term_idcoalescing_panda_terms +CREATE INDEX "index_coalescing_panda_terms_on_canvas_term_id" ON "coalescing_panda_terms" ("canvas_term_id")R8u?}indexindex_coalescing_panda_sections_on_canvas_section_idcoalescing_panda_sectionsCREATE INDEX "index_coalescing_panda_sections_on_canvas_section_id" ON "coalescing_panda_sections" ("canvas_section_id")n9?!indexindex_coalescing_panda_sections_on_coalescing_panda_course_idcoalescing_panda_sectionsCREATE INDEX "index_coalescing_panda_sections_on_coalescing_panda_course_id" ON "coalescing_panda_sections" ("coalescing_panda_course_id")1:_?Qindexindex_coalescing_panda_sections_on_sis_idcoalescing_panda_sectionsCREATE INDEX "index_coalescing_panda_sections_on_sis_id" ON "coalescing_panda_sections" ("sis_id")j;??ctablecoalescing_panda_sessionscoalescing_panda_sessionsCREATE TABLE "coalescing_panda_sessions" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "token" varchar(255), "data" text, "created_at" datetime, "updated_at" datetime);<EEytablecoalescing_panda_submissionscoalescing_panda_submissionsCREATE TABLE "coalescing_panda_submissions" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "coalescing_panda_user_id" integer, "coalescing_panda_assignment_id" integer, "url" varchar(255), "grade" varchar(255), "score" varchar(255), "submitted_at" datetime, "workflow_state" varchar(255), "canvas_submission_id" varchar(255), "created_at" datetime, "updated_at" datetime)h=Eindexindex_coalescing_panda_submissions_on_canvas_submission_idcoalescing_panda_submissions CREATE INDEX "index_coalescing_panda_submissions_on_canvas_submission_id" ON "coalescing_panda_submissions" ("canvas_submission_id")c>WE7indexindex_submissions_user_and_assignmentcoalescing_panda_submissions!CREATE INDEX "index_submissions_user_and_assignment" ON "coalescing_panda_submissions" ("coalescing_panda_user_id", "coalescing_panda_assignment_id")?99;tablecoalescing_panda_termscoalescing_panda_terms CREATE TABLE "coalescing_panda_terms" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "coalescing_panda_lti_account_id" integer, "name" varchar(255), "code" varchar(255), "sis_id" varchar(255), "canvas_term_id" varchar(255), "start_at" datetime, "end_at" datetime, "workflow_state" varchar(255), "created_at" datetime, "updated_at" datetime) +$#"   +( \ No newline at end of file