SQLite format 3@ ,5-# ( 4 L d1B1_?Qindexindex_coalescing_panda_sections_on_sis_idcoalescing_panda_sectionsCREATE INDEX "index_coalescing_panda_sections_on_sis_id" ON "coalescing_panda_sections" ("sis_id")97? indexindex_sections_coursecoalescing_panda_sectionsCREATE UNIQUE INDEX "index_sections_course" ON "coalescing_panda_sections" ("coalescing_panda_course_id", "canvas_section_id")??tablecoalescing_panda_sectionscoalescing_panda_sectionsCREATE TABLE "coalescing_panda_sections" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "coalescing_panda_course_id" integer NOT NULL, "name" varchar, "canvas_section_id" varchar NOT NULL, "sis_id" varchar, "workflow_state" varchar, "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"). 1={indexindex_courses_termcoalescing_panda_coursesCREATE UNIQUE INDEX "index_courses_term" ON "coalescing_panda_courses" ("coalescing_panda_term_id", "canvas_course_id"); 7=indexindex_courses_accountcoalescing_panda_courses CREATE UNIQUE INDEX "index_courses_account" ON "coalescing_panda_courses" ("coalescing_panda_lti_account_id", "canvas_course_id")A ==tablecoalescing_panda_coursescoalescing_panda_courses CREATE TABLE "coalescing_panda_courses" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "coalescing_panda_lti_account_id" integer NOT NULL, "coalescing_panda_term_id" integer, "name" varchar, "canvas_course_id" varchar NOT NULL, "sis_id" varchar, "start_at" datetime, "conclude_at" datetime, "workflow_state" varchar, "course_code" varchar, "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")1 39indexindex_terms_accountcoalescing_panda_terms CREATE UNIQUE INDEX "index_terms_account" ON "coalescing_panda_terms" ("canvas_term_id", "coalescing_panda_lti_account_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 NOT NULL, "name" varchar, "code" varchar, "sis_id" varchar, "canvas_term_id" varchar NOT NULL, "start_at" datetime, "end_at" datetime, "workflow_state" varchar, "created_at" datetime, "updated_at" datetime)e??Ytablecoalescing_panda_sessionscoalescing_panda_sessionsCREATE TABLE "coalescing_panda_sessions" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "token" varchar, "data" text, "created_at" datetime, "updated_at" datetime)qCCitablecoalescing_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, "timestamp" datetime)kGGUtablecoalescing_panda_lti_accountscoalescing_panda_lti_accountsCREATE TABLE "coalescing_panda_lti_accounts" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "key" varchar, "secret" varchar, "oauth2_client_id" varchar, "oauth2_client_key" varchar, "canvas_account_id" varchar, "settings" text, "created_at" datetime, "updated_at" datetime)P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)OO)tablecoalescing_panda_canvas_api_authscoalescing_panda_canvas_api_authsCREATE TABLE "coalescing_panda_canvas_api_auths" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" varchar, "api_domain" varchar, "api_token" varchar, "created_at" datetime, "updated_at" datetime)=//indexunique_schema_migrationsschema_migrationsCREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")l//tableschema_migrationsschema_migrationsCREATE TABLE "schema_migrations" ("version" varchar p^L:(tbP>,)20150811140030)20150714205405)20150709192717)20150708192717)20150602205257)20150526144713)20150506192717)20150506183335)20150210180516)20150107205413)20150107205405)20150106180131)20150106175418)20141208221740 )20141124160857 )20141121174846 )20141120153135 )20141120152546 )20141120152458)20141120151940)20141120151432)20141119225721)20141119225319)20140904223159)20131119165343)20131118211442)20131114150001 |iVC0 r_L9&)20150811140030)20150714205405)20150709192717)20150708192717)20150602205257)20150526144713)20150506192717)20150506183335)20150210180516)20150107205413)20150107205405)20150106180131)20150106175418)20141208221740)20141124160857 )20141121174846 )20141120153135 )20141120152546 )20141120152458 )20141120151940)20141120151432)20141119225721)20141119225319)20140904223159)20131119165343)20131118211442) 20131114150001                 lh > ^  }L_?Qindexindex_coalescing_panda_sections_on_sis_idcoalescing_panda_sectionsCREATE INDEX "ll//tableschema_migrationsschema_migrationsCREATE TABLE "schema_migrations" ("version" varchar NOT NULL)=//indexunique_schema_migrationsschema_migrationsCREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")OO)tablecoalescing_panda_canvas_api_authscoalescing_panda_canvas_api_authsCREATE TABLE "coalescing_panda_canvas_l//tableschema_migrationsschema_migrationsCREATE TABLE "schema_migrations" ("version" varchar NOT NULL)=//indexunique_schema_migrationsschema_migrationsCREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")OO)tablecoalescing_panda_canvas_api_authscoalescing_panda_canvas_api_authsCREATE TABLE "coalescing_panda_canvas_api_auths" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" varchar, "api_domain" varchar, "api_token" varchar, "created_at" datetime, "updated_at" datetime)P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)kGGUtablecoalescing_panda_lti_accountscoalescing_panda_lti_accountsCREATE TABLE "coalescing_panda_lti_accounts" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "key" varchar, "secret" varchar, "oauth2_client_id" varchar, "oauth2_client_key" varchar, "canvas_account_id" varchar, "settings" text, "created_at" datetime, "updated_at" datetime)qCCitablecoalescing_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, "timestamp" datetime)e??Ytablecoalescing_panda_sessionscoalescing_panda_sessionsCREATE TABLE "coalescing_panda_sessions" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "token" varchar, "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 NOT NULL, "name" varchar, "code" varchar, "sis_id" varchar, "canvas_term_id" varchar NOT NULL, "start_at" datetime, "end_at" datetime, "workflow_state" varchar, "created_at" datetime, "updated_at" datetime)1 39indexindex_terms_accountcoalescing_panda_terms CREATE UNIQUE INDEX "index_terms_account" ON "coalescing_panda_terms" ("canvas_term_id", "coalescing_panda_lti_account_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")A ==tablecoalescing_panda_coursescoalescing_panda_courses CREATE TABLE "coalescing_panda_courses" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "coalescing_panda_lti_account_id" integer NOT NULL, "coalescing_panda_term_id" integer, "name" varchar, "canvas_course_id" varchar NOT NULL, "sis_id" varchar, "start_at" datetime, "conclude_at" datetime, "workflow_state" varchar, "course_code" varchar, "created_at" datetime, "updated_at" datetime); 7=indexindex_courses_accountcoalescing_panda_courses CREATE UNIQUE INDEX "index_courses_account" ON "coalescing_panda_courses" ("coalescing_panda_lti_account_id", "canvas_course_id"). 1={indexindex_courses_termcoalescing_panda_coursesCREATE UNIQUE INDEX "index_courses_term" ON "coalescing_panda_courses" ("coalescing_panda_term_id", "canvas_course_id")-]=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 NOT NULL, "name" varchar, "canvas_section_id" varchar NOT NULL, "sis_id" varchar, "workflow_state" varchar, "start_at" datetime, "end_at" datetime, "created_at" datetime, "updated_at" datetime) O eD e 3.C{99)tablecoalescing_panda_userscoalescing_panda_usersCREATE TABLE "coalescing_panda_users" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "coalescing_panda_lti_account_id" integer NOT NULL, "name" varchar, "email" varchar, "roles" varchar, "workflow_state" varchar, "sis_id" varchar, "canvas_user_id" varchar NOT NULL, "created_at" datetime, "updated_at" datetime, "login_id" varchar)EE'tablecoalescing_panda_assignmentscoalescing_panda_assignmentsCREATE TABLE "coalescing_panda_assignments" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "coalescing_panda_course_id" integer NOT NULL, "name" varchar, "description" text, "canvas_assignment_id" varchar NOT NULL, "workflow_state" varchar, "points_possible" float, "due_at" datetime, "unlock_at" datetime, "lock_at" datetime, "created_at" datetime, "updated_at" datetime, "submission_types" text, "group_category_id" integer, "grade_group_students_individually" boolean, "published" boolean, "coalescing_panda_assignment_group_id" integer, "coalescing_panda_group_category_id" integer)tQE_indexindex_enrollments_user_and_sectioncoalescing_panda_enrollmentsCREATE UNIQUE INDEX "index_enrollments_user_and_section" ON "coalescing_panda_enrollments" ("coalescing_panda_user_id", "coalescing_panda_section_id", "enrollment_type")EEE tablecoalescing_panda_enrollmentscoalescing_panda_enrollmentsCREATE TABLE "coalescing_panda_enrollments" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "coalescing_panda_user_id" integer NOT NULL, "coalescing_panda_section_id" integer NOT NULL, "workflow_state" varchar, "sis_id" varchar, "canvas_enrollment_id" varchar NOT NULL, "enrollment_type" varchar, "start_at" datetime, "end_at" datetime, "created_at" datetime, "updated_at" datetime)hEindexindex_coalescing_panda_submissions_on_canvas_submission_idcoalescing_panda_submissionsCREATE INDEX "index_coalescing_panda_submissions_on_canvas_submission_id" ON "coalescing_panda_submissions" ("canvas_submission_id")WEuindexindex_submissions_user_and_assignmentcoalescing_panda_submissionsCREATE UNIQUE INDEX "index_submissions_user_and_assignment" ON "coalescing_panda_submissions" ("coalescing_panda_user_id", "coalescing_panda_assignment_id", "canvas_submission_id")=EE}tablecoalescing_panda_submissionscoalescing_panda_submissionsCREATE TABLE "coalescing_panda_submissions" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "coalescing_panda_user_id" integer NOT NULL, "coalescing_panda_assignment_id" integer NOT NULL, "url" varchar, "grade" varchar, "score" varchar, "submitted_at" datetime, "workflow_state" varchar, "canvas_submission_id" varchar NOT NULL, "created_at" datetime, "updated_at" datetime)%Y9Eindexindex_coalescing_panda_users_on_sis_idcoalescing_panda_usersCREATE INDEX "index_coalescing_panda_users_on_sis_id" ON "coalescing_panda_users" ("sis_id")139indexindex_users_accountcoalescing_panda_usersCREATE UNIQUE INDEX "index_users_account" ON "coalescing_panda_users" ("coalescing_panda_lti_account_id", "canvas_user_id")v99tablecoalescing_panda_userscoalescing_panda_usersCREATE TABLE "coalescing_panda_users" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "coalescing_panda_lti_account_id" integer NOT NULL, "name" varchar, "email" varchar, "roles" varchar, "workflow_state" varchar, "sis_id" varchar, "canvas_user_id" varchar NOT NULL, "created_at" datetime, "updated_at" datetime)H=Eindexindex_assignments_coursecoalescing_panda_assignmentsCREATE UNIQUE INDEX "index_assignments_course" ON "coalescing_panda_assignments" ("coalescing_panda_course_id", "canvas_assignment_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")97? indexindex_sections_coursecoalescing_panda_sectionsCREATE UNIQUE INDEX "index_sections_course" ON "coalescing_panda_sections" ("coalescing_panda_course_id", "canvas_section_id")              @ 1  s}* ;;ktablecoalescing_panda_groupscoalescing_panda_groups$CREATE TABLE "coalescing_panda_groups" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "context_id" integer, "context_type" varchar, "description" varchar, "group_category_id" varchar, "canvas_group_id" varchar, "name" varchar, "members_count" integer, "created_at" datetime, "updated_at" datetime, "leader_id" integer, "coalescing_panda_group_category_id" integer)a(kOindexindex_group_categories_context_and_context_typecoalescing_panda_group_categories,CREATE INDEX "index_group_categories_context_and_context_type" ON "coalescing_panda_group_categories" ("context_id", "context_type")A'OOqtablecoalescing_panda_group_categoriescoalescing_panda_group_categories+CREATE TABLE "coalescing_panda_group_categories" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "context_id" integer, "context_type" varchar, "canvas_group_category_id" integer, "name" varchar, "created_at" datetime, "updated_at" datetime)f&IQ?indexindex_assignment_group_contextcoalescing_panda_assignment_groups*CREATE UNIQUE INDEX "index_assignment_group_context" ON "coalescing_panda_assignment_groups" ("canvas_assignment_group_id", "context_id", "context_type")d%GQ=indexindex_assignment_group_coursecoalescing_panda_assignment_groups)CREATE UNIQUE INDEX "index_assignment_group_course" ON "coalescing_panda_assignment_groups" ("coalescing_panda_course_id", "canvas_assignment_group_id")9$QQ]tablecoalescing_panda_assignment_groupscoalescing_panda_assignment_groups(CREATE TABLE "coalescing_panda_assignment_groups" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "coalescing_panda_course_id" integer NOT NULL, "context_id" integer, "context_type" varchar, "canvas_assignment_group_id" varchar, "name" varchar, "position" integer, "group_weight" float, "workflow_state" varchar, "created_at" datetime, "updated_at" datetime)s#YQIindexindex_group_memberships_user_and_groupcoalescing_panda_group_memberships'CREATE UNIQUE INDEX "index_group_memberships_user_and_group" ON "coalescing_panda_group_memberships" ("coalescing_panda_group_id", "coalescing_panda_user_id")"QQktablecoalescing_panda_group_membershipscoalescing_panda_group_memberships&CREATE TABLE "coalescing_panda_group_memberships" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "coalescing_panda_group_id" integer, "coalescing_panda_user_id" integer, "canvas_group_membership_id" varchar, "workflow_state" varchar, "created_at" datetime, "updated_at" datetime, "moderator" boolean);!O;yindexindex_groups_context_and_group_idcoalescing_panda_groups%CREATE UNIQUE INDEX "index_groups_context_and_group_id" ON "coalescing_panda_groups" ("context_id", "canvas_group_id"){7%'indexdelayed_jobs_prioritydelayed_jobs"CREATE INDEX "delayed_jobs_priority" ON "delayed_jobs" ("priority", "run_at")%%Atabledelayed_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, "queue" varchar, "created_at" datetime, "updated_at" datetime) KK tablecoalescing_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, "message" text, "created_at" datetime, "updated_at" datetime, "context_id" integer, "context_type" varchar, "coalescing_panda_lti_account_id" integer, "options" text)=eE]indexindex_coalescing_panda_enrollments_on_sis_idcoalescing_panda_enrollmentsCREATE INDEX "index_coalescing_panda_enrollments_on_sis_id" ON "coalescing_panda_enrollments" ("sis_id")