Skip to content

Instantly share code, notes, and snippets.

@lvnilesh
Created February 26, 2012 02:05
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save lvnilesh/1912272 to your computer and use it in GitHub Desktop.
Save lvnilesh/1912272 to your computer and use it in GitHub Desktop.
Index name 'index___migrated_message_participant_strings_on_migrated_message_id' on table '__migr..........strings' is too long; the limit is 64 characters.
[class.thencta.com] run: cd /var/rails/canvas; export GEM_HOME=/home/nilesh/gems; RAILS_ENV=production $GEM_HOME/bin/bundle exec rake db:initial_setup
[class.thencta.com] out: WARNING: 'require 'rake/rdoctask'' is deprecated. Please use 'require 'rdoc/task' (in RDoc 2.4.2[class.thencta.com] out:
[class.thencta.com] out: at /home/nilesh/gems/gems/rake-0.9.2.2/lib/rake/rdoctask.rb
[class.thencta.com] out: Please install RDoc 2.4.2+ to generate documentation.
[class.thencta.com] out: == InstallCustomFields: migrating ============================================
[class.thencta.com] out: -- create_table(:custom_fields, {:force=>true})
[class.thencta.com] out: -> 0.0498s
[class.thencta.com] out: -- add_index(:custom_fields, ["scoper_type", "scoper_id", "target_type", "name"], {:name=>"custom[class.thencta.com] out:
[class.thencta.com] out: -> 0.0084s
[class.thencta.com] out: -- create_table(:custom_field_values, {:force=>true})
[class.thencta.com] out: -> 0.0060s
[class.thencta.com] out: == InstallCustomFields: migrated (0.0646s) ===================================
[class.thencta.com] out:
[class.thencta.com] out: == InitCanvasDb: migrating ===================================================
[class.thencta.com] out: -- create_table("abstract_courses", {:force=>true})
[class.thencta.com] out: -> 0.0195s
[class.thencta.com] out: -- add_index("abstract_courses", ["college_id"], {:name=>"index_abstract_courses_on_college_id"})
[class.thencta.com] out: -> 0.0073s
[class.thencta.com] out: -- add_index("abstract_courses", ["department_id"], {:name=>"index_abstract_courses_on_department[class.thencta.com] out:
[class.thencta.com] out: -> 0.0075s
[class.thencta.com] out: -- add_index("abstract_courses", ["root_account_id", "sis_source_id"], {:name=>"index_abstract_co[class.thencta.com] out: and_sis_source_id"})
[class.thencta.com] out: -> 0.0076s
[class.thencta.com] out: -- add_index("abstract_courses", ["sis_source_id"], {:name=>"index_abstract_courses_on_sis_source[class.thencta.com] out:
[class.thencta.com] out: -> 0.0077s
[class.thencta.com] out: -- create_table("account_authorization_configs", {:force=>true})
[class.thencta.com] out: -> 0.0089s
[class.thencta.com] out: -- add_index("account_authorization_configs", ["account_id"], {:name=>"index_account_authorizatio[class.thencta.com] out: )
[class.thencta.com] out: -> 0.0077s
[class.thencta.com] out: -- create_table("account_reports")
[class.thencta.com] out: -> 0.0053s
[class.thencta.com] out: -- create_table("account_users", {:force=>true})
[class.thencta.com] out: -> 0.0050s
[class.thencta.com] out: -- add_index("account_users", ["account_id"], {:name=>"index_account_users_on_account_id"})
[class.thencta.com] out: -> 0.0063s
[class.thencta.com] out: -- add_index("account_users", ["user_id"], {:name=>"index_account_users_on_user_id"})
[class.thencta.com] out: -> 0.0073s
[class.thencta.com] out: -- create_table("accounts", {:force=>true})
[class.thencta.com] out: -> 0.0108s
[class.thencta.com] out: -- add_index("accounts", ["id", "type"], {:name=>"index_accounts_on_id_and_type"})
[class.thencta.com] out: -> 0.0079s
[class.thencta.com] out: -- add_index("accounts", ["name", "parent_account_id"], {:name=>"index_accounts_on_name_and_paren[class.thencta.com] out:
[class.thencta.com] out: -> 0.1585s
[class.thencta.com] out: -- add_index("accounts", ["parent_account_id", "root_account_id"], {:name=>"index_accounts_on_par[class.thencta.com] out: ccount_id"})
[class.thencta.com] out: -> 0.0167s
[class.thencta.com] out: -- add_index("accounts", ["root_account_id", "sis_source_id"], {:name=>"index_accounts_on_root_ac[class.thencta.com] out: d"})
[class.thencta.com] out: -> 0.0082s
[class.thencta.com] out: -- add_index("accounts", ["sis_source_id"], {:name=>"index_accounts_on_sis_source_id"})
[class.thencta.com] out: -> 0.0086s
[class.thencta.com] out: -- add_index("accounts", ["type"], {:name=>"index_accounts_on_type"})
[class.thencta.com] out: -> 0.0181s
[class.thencta.com] out: -- create_table("assessment_question_bank_users", {:force=>true})
[class.thencta.com] out: -> 0.0061s
[class.thencta.com] out: -- add_index("assessment_question_bank_users", ["assessment_question_bank_id"], {:name=>"assessme[class.thencta.com] out:
[class.thencta.com] out: -> 0.0062s
[class.thencta.com] out: -- add_index("assessment_question_bank_users", ["user_id"], {:name=>"assessment_qbu_u_id"})
[class.thencta.com] out: -> 0.0072s
[class.thencta.com] out: -- create_table("assessment_question_banks", {:force=>true})
[class.thencta.com] out: -> 0.0064s
[class.thencta.com] out: -- add_index("assessment_question_banks", ["context_id", "context_type"], {:name=>"index_on_aqb_o[class.thencta.com] out: type"})
[class.thencta.com] out: -> 0.0198s
[class.thencta.com] out: -- create_table("assessment_questions", {:force=>true})
[class.thencta.com] out: -> 0.0054s
[class.thencta.com] out: -- add_index("assessment_questions", ["assessment_question_bank_id", "position"], {:name=>"questi[class.thencta.com] out: )
[class.thencta.com] out: -> 0.0062s
[class.thencta.com] out: -- add_index("assessment_questions", ["context_id", "context_type"], {:name=>"index_assessment_qu[class.thencta.com] out: _context_type"})
[class.thencta.com] out: -> 0.0074s
[class.thencta.com] out: -- create_table("assessment_requests", {:force=>true})
[class.thencta.com] out: -> 0.0060s
[class.thencta.com] out: -- add_index("assessment_requests", ["assessor_asset_id", "assessor_asset_type"], {:name=>"aa_id_[class.thencta.com] out:
[class.thencta.com] out: -> 0.0214s
[class.thencta.com] out: -- add_index("assessment_requests", ["assessor_id"], {:name=>"index_assessment_requests_on_assess[class.thencta.com] out:
[class.thencta.com] out: -> 0.0071s
[class.thencta.com] out: -- add_index("assessment_requests", ["asset_id", "asset_type"], {:name=>"index_assessment_request[class.thencta.com] out: ype"})
[class.thencta.com] out: -> 0.0078s
[class.thencta.com] out: -- add_index("assessment_requests", ["rubric_assessment_id"], {:name=>"index_assessment_requests_[class.thencta.com] out: )
[class.thencta.com] out: -> 0.0088s
[class.thencta.com] out: -- add_index("assessment_requests", ["rubric_association_id"], {:name=>"index_assessment_requests[class.thencta.com] out: "})
[class.thencta.com] out: -> 0.0172s
[class.thencta.com] out: -- add_index("assessment_requests", ["user_id"], {:name=>"index_assessment_requests_on_user_id"})
[class.thencta.com] out: -> 0.0082s
[class.thencta.com] out: -- create_table("asset_user_accesses", {:force=>true})
[class.thencta.com] out: -> 0.0073s
[class.thencta.com] out: -- add_index("asset_user_accesses", ["context_id", "context_type"], {:name=>"index_asset_user_acc[class.thencta.com] out: ontext_type"})
[class.thencta.com] out: -> 0.0065s
[class.thencta.com] out: -- add_index("asset_user_accesses", ["user_id", "asset_code"], {:name=>"index_asset_user_accesses[class.thencta.com] out: e"})
[class.thencta.com] out: -> 0.0069s
[class.thencta.com] out: -- create_table("assignment_groups", {:force=>true})
[class.thencta.com] out: -> 0.0219s
[class.thencta.com] out: -- add_index("assignment_groups", ["cloned_item_id"], {:name=>"index_assignment_groups_on_cloned_[class.thencta.com] out:
[class.thencta.com] out: -> 0.2777s
[class.thencta.com] out: -- add_index("assignment_groups", ["context_code"], {:name=>"index_assignment_groups_on_context_c[class.thencta.com] out:
[class.thencta.com] out: -> 0.0082s
[class.thencta.com] out: -- add_index("assignment_groups", ["context_id", "context_type"], {:name=>"index_assignment_group[class.thencta.com] out: xt_type"})
[class.thencta.com] out: -> 0.0081s
[class.thencta.com] out: -- create_table("assignment_reminders", {:force=>true})
[class.thencta.com] out: -> 0.0052s
[class.thencta.com] out: -- add_index("assignment_reminders", ["assignment_id"], {:name=>"index_assignment_reminders_on_as[class.thencta.com] out:
[class.thencta.com] out: -> 0.0071s
[class.thencta.com] out: -- add_index("assignment_reminders", ["user_id"], {:name=>"index_assignment_reminders_on_user_id"[class.thencta.com] out:
[class.thencta.com] out: -> 0.0099s
[class.thencta.com] out: -- create_table("assignments", {:force=>true})
[class.thencta.com] out: -> 0.0114s
[class.thencta.com] out: -- add_index("assignments", ["assignment_group_id"], {:name=>"index_assignments_on_assignment_gro[class.thencta.com] out:
[class.thencta.com] out: -> 0.0072s
[class.thencta.com] out: -- add_index("assignments", ["cloned_item_id"], {:name=>"index_assignments_on_cloned_item_id"})
[class.thencta.com] out: -> 0.0092s
[class.thencta.com] out: -- add_index("assignments", ["context_code"], {:name=>"index_assignments_on_context_code"})
[class.thencta.com] out: -> 0.0177s
[class.thencta.com] out: -- add_index("assignments", ["context_id", "context_type"], {:name=>"index_assignments_on_context[class.thencta.com] out:
[class.thencta.com] out: -> 0.0090s
[class.thencta.com] out: -- add_index("assignments", ["due_at", "context_code"], {:name=>"index_assignments_on_due_at_and_[class.thencta.com] out:
[class.thencta.com] out: -> 0.0088s
[class.thencta.com] out: -- add_index("assignments", ["grading_standard_id"], {:name=>"index_assignments_on_grading_standa[class.thencta.com] out:
[class.thencta.com] out: -> 0.0091s
[class.thencta.com] out: -- add_index("assignments", ["workflow_state"], {:name=>"index_assignments_on_workflow_state"})
[class.thencta.com] out: -> 0.0139s
[class.thencta.com] out: -- create_table("attachment_associations", {:force=>true})
[class.thencta.com] out: -> 0.0057s
[class.thencta.com] out: -- add_index("attachment_associations", ["attachment_id"], {:name=>"index_attachment_associations[class.thencta.com] out:
[class.thencta.com] out: -> 0.0064s
[class.thencta.com] out: -- add_index("attachment_associations", ["context_id", "context_type"], {:name=>"attachment_assoc[class.thencta.com] out:
[class.thencta.com] out: -> 0.0079s
[class.thencta.com] out: -- create_table("attachments", {:force=>true})
[class.thencta.com] out: -> 0.0219s
[class.thencta.com] out: -- add_index("attachments", ["cloned_item_id"], {:name=>"index_attachments_on_cloned_item_id"})
[class.thencta.com] out: -> 0.0083s
[class.thencta.com] out: -- add_index("attachments", ["context_id", "context_type"], {:name=>"index_attachments_on_context[class.thencta.com] out:
[class.thencta.com] out: -> 0.0101s
[class.thencta.com] out: -- add_index("attachments", ["enrollment_id"], {:name=>"index_attachments_on_enrollment_id"})
[class.thencta.com] out: -> 0.0091s
[class.thencta.com] out: -- add_index("attachments", ["folder_id"], {:name=>"index_attachments_on_folder_id"})
[class.thencta.com] out: -> 0.0096s
[class.thencta.com] out: -- add_index("attachments", ["md5", "namespace"], {:name=>"index_attachments_on_md5_and_namespace[class.thencta.com] out:
[class.thencta.com] out: -> 0.0100s
[class.thencta.com] out: -- add_index("attachments", ["root_attachment_id"], {:name=>"index_attachments_on_root_attachment[class.thencta.com] out:
[class.thencta.com] out: -> 0.0214s
[class.thencta.com] out: -- add_index("attachments", ["scribd_account_id"], {:name=>"index_attachments_on_scribd_account_i[class.thencta.com] out:
[class.thencta.com] out: -> 0.0091s
[class.thencta.com] out: -- add_index("attachments", ["scribd_attempts", "scribd_mime_type_id", "workflow_state"], {:name=[class.thencta.com] out: kflow_state"})
[class.thencta.com] out: -> 0.0107s
[class.thencta.com] out: -- add_index("attachments", ["scribd_mime_type_id"], {:name=>"index_attachments_on_scribd_mime_ty[class.thencta.com] out:
[class.thencta.com] out: -> 0.0257s
[class.thencta.com] out: -- add_index("attachments", ["user_id"], {:name=>"index_attachments_on_user_id"})
[class.thencta.com] out: -> 0.0103s
[class.thencta.com] out: -- add_index("attachments", ["workflow_state", "updated_at"], {:name=>"index_attachments_on_workf[class.thencta.com] out: })
[class.thencta.com] out: -> 0.0109s
[class.thencta.com] out: -- create_table("authorization_codes", {:force=>true})
[class.thencta.com] out: -> 0.0156s
[class.thencta.com] out: -- add_index("authorization_codes", ["account_id"], {:name=>"index_authorization_codes_on_account[class.thencta.com] out:
[class.thencta.com] out: -> 0.0064s
[class.thencta.com] out: -- create_table("calendar_events", {:force=>true})
[class.thencta.com] out: -> 0.0071s
[class.thencta.com] out: -- add_index("calendar_events", ["cloned_item_id"], {:name=>"index_calendar_events_on_cloned_item[class.thencta.com] out:
[class.thencta.com] out: -> 0.0134s
[class.thencta.com] out: -- add_index("calendar_events", ["context_code"], {:name=>"index_calendar_events_on_context_code"[class.thencta.com] out:
[class.thencta.com] out: -> 0.0112s
[class.thencta.com] out: -- add_index("calendar_events", ["context_id", "context_type"], {:name=>"index_calendar_events_on[class.thencta.com] out: ype"})
[class.thencta.com] out: -> 0.0077s
[class.thencta.com] out: -- add_index("calendar_events", ["user_id"], {:name=>"index_calendar_events_on_user_id"})
[class.thencta.com] out: -> 0.0081s
[class.thencta.com] out: -- create_table("cloned_items", {:force=>true})
[class.thencta.com] out: -> 0.0055s
[class.thencta.com] out: -- add_index("cloned_items", ["original_item_id", "original_item_type"], {:name=>"cloned_items_or[class.thencta.com] out: )
[class.thencta.com] out: -> 0.0069s
[class.thencta.com] out: -- create_table("collaborations", {:force=>true})
[class.thencta.com] out: -> 0.0090s
[class.thencta.com] out: -- add_index("collaborations", ["context_id", "context_type"], {:name=>"index_collaborations_on_c[class.thencta.com] out: e"})
[class.thencta.com] out: -> 0.0066s
[class.thencta.com] out: -- add_index("collaborations", ["user_id"], {:name=>"index_collaborations_on_user_id"})
[class.thencta.com] out: -> 0.0077s
[class.thencta.com] out: -- create_table("collaborators", {:force=>true})
[class.thencta.com] out: -> 0.0059s
[class.thencta.com] out: -- add_index("collaborators", ["collaboration_id"], {:name=>"index_collaborators_on_collaboration[class.thencta.com] out:
[class.thencta.com] out: -> 0.0071s
[class.thencta.com] out: -- add_index("collaborators", ["user_id"], {:name=>"index_collaborators_on_user_id"})
[class.thencta.com] out: -> 0.0124s
[class.thencta.com] out: -- create_table("communication_channels", {:force=>true})
[class.thencta.com] out: -> 0.0060s
[class.thencta.com] out: -- add_index("communication_channels", ["path", "path_type"], {:name=>"index_communication_channe[class.thencta.com] out: })
[class.thencta.com] out: -> 0.0065s
[class.thencta.com] out: -- add_index("communication_channels", ["pseudonym_id"], {:name=>"index_communication_channels_on[class.thencta.com] out:
[class.thencta.com] out: -> 0.0072s
[class.thencta.com] out: -- add_index("communication_channels", ["user_id"], {:name=>"index_communication_channels_on_user[class.thencta.com] out:
[class.thencta.com] out: -> 0.0094s
[class.thencta.com] out: -- create_table("content_migrations", {:force=>true})
[class.thencta.com] out: -> 0.0199s
[class.thencta.com] out: -- create_table("content_tags", {:force=>true})
[class.thencta.com] out: -> 0.0080s
[class.thencta.com] out: -- add_index("content_tags", ["content_id", "content_type"], {:name=>"index_content_tags_on_conte[class.thencta.com] out:
[class.thencta.com] out: -> 0.0071s
[class.thencta.com] out: -- add_index("content_tags", ["context_id", "context_type"], {:name=>"index_content_tags_on_conte[class.thencta.com] out:
[class.thencta.com] out: -> 0.0085s
[class.thencta.com] out: -- add_index("content_tags", ["context_module_id"], {:name=>"index_content_tags_on_context_module[class.thencta.com] out:
[class.thencta.com] out: -> 0.0086s
[class.thencta.com] out: -- add_index("content_tags", ["workflow_state"], {:name=>"index_content_tags_on_workflow_state"})
[class.thencta.com] out: -> 0.0167s
[class.thencta.com] out: -- create_table("context_message_participants", {:force=>true})
[class.thencta.com] out: -> 0.0058s
[class.thencta.com] out: -- add_index("context_message_participants", ["context_message_id"], {:name=>"index_context_messa[class.thencta.com] out: t_message_id"})
[class.thencta.com] out: -> 0.0067s
[class.thencta.com] out: -- add_index("context_message_participants", ["user_id"], {:name=>"index_context_message_particip[class.thencta.com] out:
[class.thencta.com] out: -> 0.0078s
[class.thencta.com] out: -- create_table("context_messages", {:force=>true})
[class.thencta.com] out: -> 0.0062s
[class.thencta.com] out: -- add_index("context_messages", ["context_id", "context_type"], {:name=>"index_context_messages_[class.thencta.com] out: _type"})
[class.thencta.com] out: -> 0.0177s
[class.thencta.com] out: -- add_index("context_messages", ["root_context_message_id"], {:name=>"index_context_messages_on_[class.thencta.com] out: )
[class.thencta.com] out: -> 0.0073s
[class.thencta.com] out: -- add_index("context_messages", ["user_id"], {:name=>"index_context_messages_on_user_id"})
[class.thencta.com] out: -> 0.0070s
[class.thencta.com] out: -- create_table("context_module_progressions", {:force=>true})
[class.thencta.com] out: -> 0.0063s
[class.thencta.com] out: -- add_index("context_module_progressions", ["context_module_id"], {:name=>"index_context_module_[class.thencta.com] out: odule_id"})
[class.thencta.com] out: -> 0.0060s
[class.thencta.com] out: -- add_index("context_module_progressions", ["user_id", "context_module_id"], {:name=>"u_id_modul[class.thencta.com] out:
[class.thencta.com] out: -> 0.0152s
[class.thencta.com] out: -- create_table("context_modules", {:force=>true})
[class.thencta.com] out: -> 0.0069s
[class.thencta.com] out: -- add_index("context_modules", ["context_id", "context_type"], {:name=>"index_context_modules_on[class.thencta.com] out: ype"})
[class.thencta.com] out: -> 0.0088s
[class.thencta.com] out: -- create_table("course_account_associations", {:force=>true})
[class.thencta.com] out: -> 0.0062s
[class.thencta.com] out: -- add_index("course_account_associations", ["account_id", "depth"], {:name=>"index_course_accoun[class.thencta.com] out: _id_and_depth_id"})
[class.thencta.com] out: -> 0.0068s
[class.thencta.com] out: -- add_index("course_account_associations", ["course_id"], {:name=>"index_course_account_associat[class.thencta.com] out:
[class.thencta.com] out: -> 0.0249s
[class.thencta.com] out: -- create_table("course_imports", {:force=>true})
[class.thencta.com] out: -> 0.0068s
[class.thencta.com] out: -- create_table("course_sections", {:force=>true})
[class.thencta.com] out: -> 0.0069s
[class.thencta.com] out: -- add_index("course_sections", ["abstract_course_id"], {:name=>"index_course_sections_on_abstrac[class.thencta.com] out:
[class.thencta.com] out: -> 0.0071s
[class.thencta.com] out: -- add_index("course_sections", ["course_id"], {:name=>"index_course_sections_on_course_id"})
[class.thencta.com] out: -> 0.0071s
[class.thencta.com] out: -- add_index("course_sections", ["enrollment_term_id"], {:name=>"index_course_sections_on_enrollm[class.thencta.com] out:
[class.thencta.com] out: -> 0.0235s
[class.thencta.com] out: -- add_index("course_sections", ["root_account_id", "sis_source_id"], {:name=>"index_course_secti[class.thencta.com] out: d_sis_source_id"})
[class.thencta.com] out: -> 0.0084s
[class.thencta.com] out: -- add_index("course_sections", ["sis_cross_listed_section_id"], {:name=>"index_course_sections_o[class.thencta.com] out: n_id"})
[class.thencta.com] out: -> 0.0089s
[class.thencta.com] out: -- create_table("courses", {:force=>true})
[class.thencta.com] out: -> 0.0120s
[class.thencta.com] out: -- add_index("courses", ["abstract_course_id"], {:name=>"index_courses_on_abstract_course_id"})
[class.thencta.com] out: -> 0.0081s
[class.thencta.com] out: -- add_index("courses", ["account_id"], {:name=>"index_courses_on_account_id"})
[class.thencta.com] out: -> 0.0094s
[class.thencta.com] out: -- add_index("courses", ["enrollment_term_id"], {:name=>"index_courses_on_enrollment_term_id"})
[class.thencta.com] out: -> 0.0093s
[class.thencta.com] out: -- add_index("courses", ["grading_standard_id"], {:name=>"index_courses_on_grading_standard_id"})
[class.thencta.com] out: -> 0.0167s
[class.thencta.com] out: -- add_index("courses", ["moved_in_account_structure", "updated_at"], {:name=>"index_courses_on_m[class.thencta.com] out: _and_updated_at"})
[class.thencta.com] out: -> 0.0091s
[class.thencta.com] out: -- add_index("courses", ["root_account_id"], {:name=>"index_courses_on_root_account_id"})
[class.thencta.com] out: -> 0.0098s
[class.thencta.com] out: -- add_index("courses", ["wiki_id"], {:name=>"index_courses_on_wiki_id"})
[class.thencta.com] out: -> 0.0101s
[class.thencta.com] out: -- create_table("custom_field_values", {:force=>true})
[class.thencta.com] out: -> 0.0075s
[class.thencta.com] out: -- create_table("custom_fields", {:force=>true})
[class.thencta.com] out: -> 0.0068s
[class.thencta.com] out: -- create_table("delayed_messages", {:force=>true})
[class.thencta.com] out: -> 0.0068s
[class.thencta.com] out: -- add_index("delayed_messages", ["communication_channel_id", "workflow_state", "send_at"], {:nam[class.thencta.com] out:
[class.thencta.com] out: -> 0.0072s
[class.thencta.com] out: -- add_index("delayed_messages", ["send_at"], {:name=>"by_sent_at"})
[class.thencta.com] out: -> 0.0079s
[class.thencta.com] out: -- add_index("delayed_messages", ["workflow_state", "send_at"], {:name=>"ws_sa"})
[class.thencta.com] out: -> 0.0189s
[class.thencta.com] out: -- create_table("delayed_notifications", {:force=>true})
[class.thencta.com] out: -> 0.0062s
[class.thencta.com] out: -- add_index("delayed_notifications", ["workflow_state", "created_at"], {:name=>"index_delayed_no[class.thencta.com] out: tate_and_created_at"})
[class.thencta.com] out: -> 0.0065s
[class.thencta.com] out: -- create_table("developer_keys", {:force=>true})
[class.thencta.com] out: -> 0.0058s
[class.thencta.com] out: -- create_table("discussion_entries", {:force=>true})
[class.thencta.com] out: -> 0.0067s
[class.thencta.com] out: -- add_index("discussion_entries", ["attachment_id"], {:name=>"index_discussion_entries_on_attach[class.thencta.com] out:
[class.thencta.com] out: -> 0.0218s
[class.thencta.com] out: -- add_index("discussion_entries", ["discussion_topic_id"], {:name=>"index_discussion_entries_on_[class.thencta.com] out:
[class.thencta.com] out: -> 0.0078s
[class.thencta.com] out: -- add_index("discussion_entries", ["user_id"], {:name=>"index_discussion_entries_on_user_id"})
[class.thencta.com] out: -> 0.0072s
[class.thencta.com] out: -- create_table("discussion_topics", {:force=>true})
[class.thencta.com] out: -> 0.0099s
[class.thencta.com] out: -- add_index("discussion_topics", ["attachment_id"], {:name=>"index_discussion_topics_on_attachme[class.thencta.com] out:
[class.thencta.com] out: -> 0.0263s
[class.thencta.com] out: -- add_index("discussion_topics", ["cloned_item_id"], {:name=>"index_discussion_topics_on_cloned_[class.thencta.com] out:
[class.thencta.com] out: -> 0.0081s
[class.thencta.com] out: -- add_index("discussion_topics", ["context_code"], {:name=>"index_discussion_topics_on_context_c[class.thencta.com] out:
[class.thencta.com] out: -> 0.0072s
[class.thencta.com] out: -- add_index("discussion_topics", ["context_id", "context_type"], {:name=>"index_discussion_topic[class.thencta.com] out: xt_type"})
[class.thencta.com] out: -> 0.0085s
[class.thencta.com] out: -- add_index("discussion_topics", ["context_id", "position"], {:name=>"index_discussion_topics_on[class.thencta.com] out: })
[class.thencta.com] out: -> 0.0082s
[class.thencta.com] out: -- add_index("discussion_topics", ["id", "type"], {:name=>"index_discussion_topics_on_id_and_type[class.thencta.com] out:
[class.thencta.com] out: -> 0.0267s
[class.thencta.com] out: -- add_index("discussion_topics", ["root_topic_id"], {:name=>"index_discussion_topics_on_root_top[class.thencta.com] out:
[class.thencta.com] out: -> 0.0093s
[class.thencta.com] out: -- add_index("discussion_topics", ["user_id"], {:name=>"index_discussion_topics_on_user_id"})
[class.thencta.com] out: -> 0.0099s
[class.thencta.com] out: -- add_index("discussion_topics", ["workflow_state"], {:name=>"index_discussion_topics_on_workflo[class.thencta.com] out:
[class.thencta.com] out: -> 0.0254s
[class.thencta.com] out: -- create_table("enrollment_dates_overrides", {:force=>true})
[class.thencta.com] out: -> 0.0062s
[class.thencta.com] out: -- create_table("enrollment_terms", {:force=>true})
[class.thencta.com] out: -> 0.0060s
[class.thencta.com] out: -- add_index("enrollment_terms", ["root_account_id", "sis_source_id"], {:name=>"index_enrollment_[class.thencta.com] out: and_sis_source_id"})
[class.thencta.com] out: -> 0.0078s
[class.thencta.com] out: -- add_index("enrollment_terms", ["sis_source_id"], {:name=>"index_enrollment_terms_on_sis_source[class.thencta.com] out:
[class.thencta.com] out: -> 0.0080s
[class.thencta.com] out: -- create_table("enrollments", {:force=>true})
[class.thencta.com] out: -> 0.0187s
[class.thencta.com] out: -- add_index("enrollments", ["course_id", "workflow_state"], {:name=>"index_enrollments_on_course[class.thencta.com] out:
[class.thencta.com] out: -> 0.0074s
[class.thencta.com] out: -- add_index("enrollments", ["course_section_id"], {:name=>"index_enrollments_on_course_section_i[class.thencta.com] out:
[class.thencta.com] out: -> 0.0078s
[class.thencta.com] out: -- add_index("enrollments", ["id", "type"], {:name=>"index_enrollments_on_id_and_type"})
[class.thencta.com] out: -> 0.0076s
[class.thencta.com] out: -- add_index("enrollments", ["root_account_id"], {:name=>"index_enrollments_on_root_account_id"})
[class.thencta.com] out: -> 0.0086s
[class.thencta.com] out: -- add_index("enrollments", ["sis_source_id"], {:name=>"index_enrollments_on_sis_source_id"})
[class.thencta.com] out: -> 0.0108s
[class.thencta.com] out: -- add_index("enrollments", ["user_id"], {:name=>"index_enrollments_on_user_id"})
[class.thencta.com] out: -> 0.0088s
[class.thencta.com] out: -- add_index("enrollments", ["uuid"], {:name=>"index_enrollments_on_uuid"})
[class.thencta.com] out: -> 0.0087s
[class.thencta.com] out: -- add_index("enrollments", ["workflow_state"], {:name=>"index_enrollments_on_workflow_state"})
[class.thencta.com] out: -> 0.0093s
[class.thencta.com] out: -- create_table("eportfolio_categories", {:force=>true})
[class.thencta.com] out: -> 0.0174s
[class.thencta.com] out: -- add_index("eportfolio_categories", ["eportfolio_id"], {:name=>"index_eportfolio_categories_on_[class.thencta.com] out:
[class.thencta.com] out: -> 0.0066s
[class.thencta.com] out: -- create_table("eportfolio_entries", {:force=>true})
[class.thencta.com] out: -> 0.0068s
[class.thencta.com] out: -- add_index("eportfolio_entries", ["eportfolio_category_id"], {:name=>"index_eportfolio_entries_[class.thencta.com] out: "})
[class.thencta.com] out: -> 0.0071s
[class.thencta.com] out: -- add_index("eportfolio_entries", ["eportfolio_id"], {:name=>"index_eportfolio_entries_on_eportf[class.thencta.com] out:
[class.thencta.com] out: -> 0.0068s
[class.thencta.com] out: -- create_table("eportfolios", {:force=>true})
[class.thencta.com] out: -> 0.0147s
[class.thencta.com] out: -- add_index("eportfolios", ["user_id"], {:name=>"index_eportfolios_on_user_id"})
[class.thencta.com] out: -> 0.0061s
[class.thencta.com] out: -- create_table("error_reports", {:force=>true})
[class.thencta.com] out: -> 0.2475s
[class.thencta.com] out: -- add_index("error_reports", ["created_at"], {:name=>"error_reports_created_at"})
[class.thencta.com] out: -> 0.0076s
[class.thencta.com] out: -- add_index("error_reports", ["zendesk_ticket_id"], {:name=>"index_error_reports_on_zendesk_tick[class.thencta.com] out:
[class.thencta.com] out: -> 0.0069s
[class.thencta.com] out: -- create_table("external_feed_entries", {:force=>true})
[class.thencta.com] out: -> 0.0074s
[class.thencta.com] out: -- add_index("external_feed_entries", ["asset_id", "asset_type"], {:name=>"index_external_feed_en[class.thencta.com] out: et_type"})
[class.thencta.com] out: -> 0.0068s
[class.thencta.com] out: -- add_index("external_feed_entries", ["external_feed_id", "uuid"], {:name=>"external_feed_id_uui[class.thencta.com] out:
[class.thencta.com] out: -> 0.0096s
[class.thencta.com] out: -- add_index("external_feed_entries", ["user_id"], {:name=>"index_external_feed_entries_on_user_i[class.thencta.com] out:
[class.thencta.com] out: -> 0.0082s
[class.thencta.com] out: -- create_table("external_feeds", {:force=>true})
[class.thencta.com] out: -> 0.0068s
[class.thencta.com] out: -- add_index("external_feeds", ["context_id", "context_type"], {:name=>"index_external_feeds_on_c[class.thencta.com] out: e"})
[class.thencta.com] out: -> 0.0067s
[class.thencta.com] out: -- add_index("external_feeds", ["user_id"], {:name=>"index_external_feeds_on_user_id"})
[class.thencta.com] out: -> 0.0080s
[class.thencta.com] out: -- create_table("folders", {:force=>true})
[class.thencta.com] out: -> 0.0222s
[class.thencta.com] out: -- add_index("folders", ["cloned_item_id"], {:name=>"index_folders_on_cloned_item_id"})
[class.thencta.com] out: -> 0.0074s
[class.thencta.com] out: -- add_index("folders", ["context_id", "context_type"], {:name=>"index_folders_on_context_id_and_[class.thencta.com] out:
[class.thencta.com] out: -> 0.0072s
[class.thencta.com] out: -- add_index("folders", ["parent_folder_id"], {:name=>"index_folders_on_parent_folder_id"})
[class.thencta.com] out: -> 0.0084s
[class.thencta.com] out: -- create_table("gradebook_uploads", {:force=>true})
[class.thencta.com] out: -> 0.0058s
[class.thencta.com] out: -- add_index("gradebook_uploads", ["context_id", "context_type"], {:name=>"index_gradebook_upload[class.thencta.com] out: xt_type"})
[class.thencta.com] out: -> 0.0196s
[class.thencta.com] out: -- create_table("grading_standards", {:force=>true})
[class.thencta.com] out: -> 0.0059s
[class.thencta.com] out: -- add_index("grading_standards", ["context_code"], {:name=>"index_grading_standards_on_context_c[class.thencta.com] out:
[class.thencta.com] out: -> 0.0076s
[class.thencta.com] out: -- add_index("grading_standards", ["context_id", "context_type"], {:name=>"index_grading_standard[class.thencta.com] out: xt_type"})
[class.thencta.com] out: -> 0.0075s
[class.thencta.com] out: -- add_index("grading_standards", ["user_id"], {:name=>"index_grading_standards_on_user_id"})
[class.thencta.com] out: -> 0.0074s
[class.thencta.com] out: -- create_table("group_memberships", {:force=>true})
[class.thencta.com] out: -> 0.0165s
[class.thencta.com] out: -- add_index("group_memberships", ["group_id"], {:name=>"index_group_memberships_on_group_id"})
[class.thencta.com] out: -> 0.0069s
[class.thencta.com] out: -- add_index("group_memberships", ["user_id"], {:name=>"index_group_memberships_on_user_id"})
[class.thencta.com] out: -> 0.0070s
[class.thencta.com] out: -- add_index("group_memberships", ["workflow_state"], {:name=>"index_group_memberships_on_workflo[class.thencta.com] out:
[class.thencta.com] out: -> 0.0078s
[class.thencta.com] out: -- create_table("groups", {:force=>true})
[class.thencta.com] out: -> 0.0101s
[class.thencta.com] out: -- add_index("groups", ["account_id"], {:name=>"index_groups_on_account_id"})
[class.thencta.com] out: -> 0.0071s
[class.thencta.com] out: -- add_index("groups", ["context_id", "context_type"], {:name=>"index_groups_on_context_id_and_co[class.thencta.com] out:
[class.thencta.com] out: -> 0.0084s
[class.thencta.com] out: -- add_index("groups", ["id", "type"], {:name=>"index_groups_on_id_and_type"})
[class.thencta.com] out: -> 0.0079s
[class.thencta.com] out: -- add_index("groups", ["wiki_id"], {:name=>"index_groups_on_wiki_id"})
[class.thencta.com] out: -> 0.0086s
[class.thencta.com] out: -- add_index("groups", ["workflow_state"], {:name=>"index_groups_on_workflow_state"})
[class.thencta.com] out: -> 0.0126s
[class.thencta.com] out: -- create_table("hashtags", {:force=>true})
[class.thencta.com] out: -> 0.0060s
[class.thencta.com] out: -- create_table("inbox_items", {:force=>true})
[class.thencta.com] out: -> 0.0064s
[class.thencta.com] out: -- add_index("inbox_items", ["sender"], {:name=>"index_inbox_items_on_sender"})
[class.thencta.com] out: -> 0.0070s
[class.thencta.com] out: -- add_index("inbox_items", ["sender_id"], {:name=>"index_inbox_items_on_sender_id"})
[class.thencta.com] out: -> 0.0068s
[class.thencta.com] out: -- add_index("inbox_items", ["user_id"], {:name=>"index_inbox_items_on_user_id"})
[class.thencta.com] out: -> 0.0157s
[class.thencta.com] out: -- add_index("inbox_items", ["workflow_state"], {:name=>"index_inbox_items_on_workflow_state"})
[class.thencta.com] out: -> 0.0078s
[class.thencta.com] out: -- create_table("learning_outcome_groups", {:force=>true})
[class.thencta.com] out: -> 0.0068s
[class.thencta.com] out: -- create_table("learning_outcome_results", {:force=>true})
[class.thencta.com] out: -> 0.0083s
[class.thencta.com] out: -- add_index("learning_outcome_results", ["user_id", "content_tag_id"], {:unique=>true, :name=>"i[class.thencta.com] out: ults_on_user_id_and_content_tag_id"})
[class.thencta.com] out: -> 0.0199s
[class.thencta.com] out: -- create_table("learning_outcomes", {:force=>true})
[class.thencta.com] out: -> 0.0065s
[class.thencta.com] out: -- create_table("mailboxes", {:force=>true})
[class.thencta.com] out: -> 0.0058s
[class.thencta.com] out: -- add_index("mailboxes", ["handle"], {:name=>"index_mailboxes_on_handle"})
[class.thencta.com] out: -> 0.0073s
[class.thencta.com] out: -- add_index("mailboxes", ["mailboxable_entity_id", "mailboxable_entity_type"], {:name=>"me_id_an[class.thencta.com] out:
[class.thencta.com] out: -> 0.0080s
[class.thencta.com] out: -- create_table("mailboxes_pseudonyms", {:force=>true})
[class.thencta.com] out: -> 0.0202s
[class.thencta.com] out: -- create_table("media_objects", {:force=>true})
[class.thencta.com] out: -> 0.0066s
[class.thencta.com] out: -- add_index("media_objects", ["attachment_id"], {:name=>"index_media_objects_on_attachment_id"})
[class.thencta.com] out: -> 0.0079s
[class.thencta.com] out: -- add_index("media_objects", ["context_id", "context_type"], {:name=>"index_media_objects_on_con[class.thencta.com] out: })
[class.thencta.com] out: -> 0.0071s
[class.thencta.com] out: -- add_index("media_objects", ["media_id"], {:name=>"index_media_objects_on_media_id"})
[class.thencta.com] out: -> 0.0084s
[class.thencta.com] out: -- create_table("messages", {:force=>true})
[class.thencta.com] out: -> 0.0248s
[class.thencta.com] out: -- add_index("messages", ["asset_context_id", "asset_context_type"], {:name=>"index_messages_on_a[class.thencta.com] out: _context_type"})
[class.thencta.com] out: -> 0.0071s
[class.thencta.com] out: -- add_index("messages", ["communication_channel_id"], {:name=>"index_messages_on_communication_c[class.thencta.com] out:
[class.thencta.com] out: -> 0.0085s
[class.thencta.com] out: -- add_index("messages", ["context_id", "context_type", "notification_name", "to", "user_id"], {:[class.thencta.com] out: hed_message"})
[class.thencta.com] out: -> 0.0081s
[class.thencta.com] out: -- add_index("messages", ["notification_id"], {:name=>"index_messages_on_notification_id"})
[class.thencta.com] out: -> 0.0089s
[class.thencta.com] out: -- add_index("messages", ["notification_name", "workflow_state", "created_at"], {:name=>"index_me[class.thencta.com] out: me_workflow_state_created_at"})
[class.thencta.com] out: -> 0.0185s
[class.thencta.com] out: -- add_index("messages", ["sent_at", "to_email", "user_id", "notification_category"], {:name=>"in[class.thencta.com] out: nc"})
[class.thencta.com] out: -> 0.0093s
[class.thencta.com] out: -- add_index("messages", ["user_id", "to_email", "dispatch_at"], {:name=>"index_messages_user_id_[class.thencta.com] out:
[class.thencta.com] out: -> 0.0093s
[class.thencta.com] out: -- add_index("messages", ["workflow_state", "dispatch_at"], {:name=>"index_messages_on_workflow_s[class.thencta.com] out:
[class.thencta.com] out: -> 0.0100s
[class.thencta.com] out: -- create_table("notification_policies", {:force=>true})
[class.thencta.com] out: -> 0.0272s
[class.thencta.com] out: -- add_index("notification_policies", ["communication_channel_id"], {:name=>"index_notification_p[class.thencta.com] out: channel_id"})
[class.thencta.com] out: -> 0.0061s
[class.thencta.com] out: -- add_index("notification_policies", ["notification_id"], {:name=>"index_notification_policies_o[class.thencta.com] out:
[class.thencta.com] out: -> 0.0075s
[class.thencta.com] out: -- add_index("notification_policies", ["user_id"], {:name=>"index_notification_policies_on_user_i[class.thencta.com] out:
[class.thencta.com] out: -> 0.0079s
[class.thencta.com] out: -- create_table("notifications", {:force=>true})
[class.thencta.com] out: -> 0.0191s
[class.thencta.com] out: -- create_table("oauth_requests", {:force=>true})
[class.thencta.com] out: -> 0.0062s
[class.thencta.com] out: -- add_index("oauth_requests", ["user_id"], {:name=>"index_oauth_requests_on_user_id"})
[class.thencta.com] out: -> 0.0071s
[class.thencta.com] out: -- create_table("page_comments", {:force=>true})
[class.thencta.com] out: -> 0.0069s
[class.thencta.com] out: -- add_index("page_comments", ["page_id", "page_type"], {:name=>"index_page_comments_on_page_id_a[class.thencta.com] out:
[class.thencta.com] out: -> 0.0076s
[class.thencta.com] out: -- add_index("page_comments", ["user_id"], {:name=>"index_page_comments_on_user_id"})
[class.thencta.com] out: -> 0.0100s
[class.thencta.com] out: -- create_table("page_view_ranges", {:force=>true})
[class.thencta.com] out: -> 0.0073s
[class.thencta.com] out: -- add_index("page_view_ranges", ["context_id", "context_type", "start_at", "end_at"], {:name=>"b[class.thencta.com] out:
[class.thencta.com] out: -> 0.0067s
[class.thencta.com] out: -- add_index("page_view_ranges", ["workflow_state", "updated_at"], {:name=>"index_page_view_range[class.thencta.com] out: pdated_at"})
[class.thencta.com] out: -> 0.0085s
[class.thencta.com] out: -- create_table("page_views", {:force=>true, :id=>false})
[class.thencta.com] out: -> 0.0100s
[class.thencta.com] out: -- execute("ALTER TABLE page_views ADD PRIMARY KEY (request_id)")
[class.thencta.com] out: -> 0.0069s
[class.thencta.com] out: -- add_index("page_views", ["account_id"], {:name=>"index_page_views_on_account_id"})
[class.thencta.com] out: -> 0.0082s
[class.thencta.com] out: -- add_index("page_views", ["asset_user_access_id"], {:name=>"index_page_views_asset_user_access_[class.thencta.com] out:
[class.thencta.com] out: -> 0.0069s
[class.thencta.com] out: -- add_index("page_views", ["context_type", "context_id"], {:name=>"index_page_views_on_context_t[class.thencta.com] out:
[class.thencta.com] out: -> 0.0085s
[class.thencta.com] out: -- add_index("page_views", ["summarized", "created_at"], {:name=>"index_page_views_summarized_cre[class.thencta.com] out:
[class.thencta.com] out: -> 0.0216s
[class.thencta.com] out: -- add_index("page_views", ["user_id", "created_at"], {:name=>"index_page_views_on_user_id_and_cr[class.thencta.com] out:
[class.thencta.com] out: -> 0.0093s
[class.thencta.com] out: -- create_table("plugin_settings", {:force=>true})
[class.thencta.com] out: -> 0.0065s
[class.thencta.com] out: -- add_index("plugin_settings", ["name"], {:name=>"index_plugin_settings_on_name"})
[class.thencta.com] out: -> 0.0070s
[class.thencta.com] out: -- create_table("pseudonyms", {:force=>true})
[class.thencta.com] out: -> 0.0265s
[class.thencta.com] out: -- add_index("pseudonyms", ["account_id", "sis_source_id"], {:name=>"index_pseudonyms_on_account_[class.thencta.com] out:
[class.thencta.com] out: -> 0.0082s
[class.thencta.com] out: -- add_index("pseudonyms", ["communication_channel_id"], {:name=>"index_pseudonyms_on_communicati[class.thencta.com] out:
[class.thencta.com] out: -> 0.0088s
[class.thencta.com] out: -- add_index("pseudonyms", ["persistence_token"], {:name=>"index_pseudonyms_on_persistence_token"[class.thencta.com] out:
[class.thencta.com] out: -> 0.0087s
[class.thencta.com] out: -- add_index("pseudonyms", ["single_access_token"], {:name=>"index_pseudonyms_on_single_access_to[class.thencta.com] out:
[class.thencta.com] out: -> 0.0090s
[class.thencta.com] out: -- add_index("pseudonyms", ["unique_id"], {:name=>"index_pseudonyms_on_unique_id"})
[class.thencta.com] out: -> 0.0118s
[class.thencta.com] out: -- add_index("pseudonyms", ["user_id"], {:name=>"index_pseudonyms_on_user_id"})
[class.thencta.com] out: -> 0.0094s
[class.thencta.com] out: -- create_table("quiz_groups", {:force=>true})
[class.thencta.com] out: -> 0.0066s
[class.thencta.com] out: -- add_index("quiz_groups", ["quiz_id"], {:name=>"index_quiz_groups_on_quiz_id"})
[class.thencta.com] out: -> 0.0067s
[class.thencta.com] out: -- create_table("quiz_questions", {:force=>true})
[class.thencta.com] out: -> 0.0079s
[class.thencta.com] out: -- add_index("quiz_questions", ["assessment_question_id"], {:name=>"index_quiz_questions_on_asses[class.thencta.com] out:
[class.thencta.com] out: -> 0.0073s
[class.thencta.com] out: -- add_index("quiz_questions", ["quiz_group_id"], {:name=>"quiz_questions_quiz_group_id"})
[class.thencta.com] out: -> 0.0077s
[class.thencta.com] out: -- add_index("quiz_questions", ["quiz_id"], {:name=>"index_quiz_questions_on_quiz_id"})
[class.thencta.com] out: -> 0.0081s
[class.thencta.com] out: -- create_table("quiz_submission_snapshots", {:force=>true})
[class.thencta.com] out: -> 0.0108s
[class.thencta.com] out: -- add_index("quiz_submission_snapshots", ["quiz_submission_id"], {:name=>"index_quiz_submission_[class.thencta.com] out: ion_id"})
[class.thencta.com] out: -> 0.0062s
[class.thencta.com] out: -- create_table("quiz_submissions", {:force=>true})
[class.thencta.com] out: -> 0.0086s
[class.thencta.com] out: -- add_index("quiz_submissions", ["quiz_id", "user_id"], {:unique=>true, :name=>"index_quiz_submi[class.thencta.com] out: r_id"})
[class.thencta.com] out: -> 0.0080s
[class.thencta.com] out: -- add_index("quiz_submissions", ["submission_id"], {:name=>"index_quiz_submissions_on_submission[class.thencta.com] out:
[class.thencta.com] out: -> 0.0077s
[class.thencta.com] out: -- add_index("quiz_submissions", ["temporary_user_code"], {:name=>"index_quiz_submissions_on_temp[class.thencta.com] out:
[class.thencta.com] out: -> 0.0147s
[class.thencta.com] out: -- add_index("quiz_submissions", ["user_id"], {:name=>"index_quiz_submissions_on_user_id"})
[class.thencta.com] out: -> 0.0091s
[class.thencta.com] out: -- create_table("quizzes", {:force=>true})
[class.thencta.com] out: -> 0.0104s
[class.thencta.com] out: -- add_index("quizzes", ["assignment_id"], {:unique=>true, :name=>"index_quizzes_on_assignment_id[class.thencta.com] out:
[class.thencta.com] out: -> 0.0075s
[class.thencta.com] out: -- add_index("quizzes", ["cloned_item_id"], {:name=>"index_quizzes_on_cloned_item_id"})
[class.thencta.com] out: -> 0.0252s
[class.thencta.com] out: -- add_index("quizzes", ["context_id", "context_type"], {:name=>"index_quizzes_on_context_id_and_[class.thencta.com] out:
[class.thencta.com] out: -> 0.0085s
[class.thencta.com] out: -- create_table("report_snapshots", {:force=>true})
[class.thencta.com] out: -> 0.0063s
[class.thencta.com] out: -- create_table("role_overrides", {:force=>true})
[class.thencta.com] out: -> 0.0067s
[class.thencta.com] out: -- add_index("role_overrides", ["context_id", "context_type"], {:name=>"index_role_overrides_on_c[class.thencta.com] out: e"})
[class.thencta.com] out: -> 0.0070s
[class.thencta.com] out: -- create_table("rubric_assessments", {:force=>true})
[class.thencta.com] out: -> 0.0165s
[class.thencta.com] out: -- add_index("rubric_assessments", ["artifact_id", "artifact_type"], {:name=>"index_rubric_assess[class.thencta.com] out: artifact_type"})
[class.thencta.com] out: -> 0.0068s
[class.thencta.com] out: -- add_index("rubric_assessments", ["assessor_id"], {:name=>"index_rubric_assessments_on_assessor[class.thencta.com] out:
[class.thencta.com] out: -> 0.0079s
[class.thencta.com] out: -- add_index("rubric_assessments", ["rubric_association_id"], {:name=>"index_rubric_assessments_o[class.thencta.com] out: )
[class.thencta.com] out: -> 0.0082s
[class.thencta.com] out: -- add_index("rubric_assessments", ["rubric_id"], {:name=>"index_rubric_assessments_on_rubric_id"[class.thencta.com] out:
[class.thencta.com] out: -> 0.0078s
[class.thencta.com] out: -- add_index("rubric_assessments", ["user_id"], {:name=>"index_rubric_assessments_on_user_id"})
[class.thencta.com] out: -> 0.0170s
[class.thencta.com] out: -- create_table("rubric_associations", {:force=>true})
[class.thencta.com] out: -> 0.0077s
[class.thencta.com] out: -- add_index("rubric_associations", ["association_id", "association_type"], {:name=>"index_rubric[class.thencta.com] out: atype"})
[class.thencta.com] out: -> 0.0066s
[class.thencta.com] out: -- add_index("rubric_associations", ["context_code"], {:name=>"index_rubric_associations_on_conte[class.thencta.com] out:
[class.thencta.com] out: -> 0.0082s
[class.thencta.com] out: -- add_index("rubric_associations", ["context_id", "context_type"], {:name=>"index_rubric_associa[class.thencta.com] out: ontext_type"})
[class.thencta.com] out: -> 0.0071s
[class.thencta.com] out: -- add_index("rubric_associations", ["rubric_id"], {:name=>"index_rubric_associations_on_rubric_i[class.thencta.com] out:
[class.thencta.com] out: -> 0.0195s
[class.thencta.com] out: -- create_table("rubrics", {:force=>true})
[class.thencta.com] out: -> 0.0087s
[class.thencta.com] out: -- add_index("rubrics", ["context_code"], {:name=>"index_rubrics_on_context_code"})
[class.thencta.com] out: -> 0.0073s
[class.thencta.com] out: -- add_index("rubrics", ["context_id", "context_type"], {:name=>"index_rubrics_on_context_id_and_[class.thencta.com] out:
[class.thencta.com] out: -> 0.0089s
[class.thencta.com] out: -- add_index("rubrics", ["rubric_id"], {:name=>"index_rubrics_on_rubric_id"})
[class.thencta.com] out: -> 0.0074s
[class.thencta.com] out: -- add_index("rubrics", ["user_id"], {:name=>"index_rubrics_on_user_id"})
[class.thencta.com] out: -> 0.0118s
[class.thencta.com] out: -- create_table("scribd_accounts", {:force=>true})
[class.thencta.com] out: -> 0.0063s
[class.thencta.com] out: -- add_index("scribd_accounts", ["scribdable_id", "scribdable_type"], {:name=>"index_scribd_accou[class.thencta.com] out: scribdable_type"})
[class.thencta.com] out: -> 0.0074s
[class.thencta.com] out: -- create_table("scribd_mime_types", {:force=>true})
[class.thencta.com] out: -> 0.0060s
[class.thencta.com] out: -- add_index("scribd_mime_types", ["extension"], {:name=>"index_scribd_mime_types_on_extension"})
[class.thencta.com] out: -> 0.0072s
[class.thencta.com] out: -- create_table("sessions", {:force=>true})
[class.thencta.com] out: -> 0.0274s
[class.thencta.com] out: -- add_index("sessions", ["session_id"], {:name=>"index_sessions_on_session_id"})
[class.thencta.com] out: -> 0.2316s
[class.thencta.com] out: -- add_index("sessions", ["updated_at"], {:name=>"index_sessions_on_updated_at"})
[class.thencta.com] out: -> 0.0225s
[class.thencta.com] out: -- create_table("settings", {:force=>true})
[class.thencta.com] out: -> 0.0062s
[class.thencta.com] out: -- create_table("short_message_associations", {:force=>true})
[class.thencta.com] out: -> 0.0120s
[class.thencta.com] out: -- add_index("short_message_associations", ["context_id", "context_type"], {:name=>"index_short_m[class.thencta.com] out: ntext_id_and_context_type"})
[class.thencta.com] out: -> 0.0074s
[class.thencta.com] out: -- add_index("short_message_associations", ["short_message_id"], {:name=>"index_short_message_ass[class.thencta.com] out: e_id"})
[class.thencta.com] out: -> 0.0074s
[class.thencta.com] out: -- create_table("short_messages", {:force=>true})
[class.thencta.com] out: -> 0.0067s
[class.thencta.com] out: -- add_index("short_messages", ["user_id"], {:name=>"index_short_messages_on_user_id"})
[class.thencta.com] out: -> 0.0068s
[class.thencta.com] out: -- create_table("sis_batch_log_entries", {:force=>true})
[class.thencta.com] out: -> 0.0227s
[class.thencta.com] out: -- create_table("sis_batches", {:force=>true})
[class.thencta.com] out: -> 0.0070s
[class.thencta.com] out: -- create_table("sis_cross_listed_sections", {:force=>true})
[class.thencta.com] out: -> 0.0068s
[class.thencta.com] out: -- add_index("sis_cross_listed_sections", ["root_account_id", "sis_source_id"], {:name=>"cross_li[class.thencta.com] out:
[class.thencta.com] out: -> 0.0093s
[class.thencta.com] out: -- create_table("stream_item_instances", {:force=>true})
[class.thencta.com] out: -> 0.0086s
[class.thencta.com] out: -- create_table("stream_items", {:force=>true})
[class.thencta.com] out: -> 0.0068s
[class.thencta.com] out: -- add_index("stream_items", ["item_asset_string", "created_at"], {:name=>"index_stream_items_on_[class.thencta.com] out: ated_at"})
[class.thencta.com] out: -> 0.0071s
[class.thencta.com] out: -- add_index("stream_items", ["user_id", "context_code", "created_at"], {:name=>"uid_cc_ca"})
[class.thencta.com] out: -> 0.0078s
[class.thencta.com] out: -- add_index("stream_items", ["user_id", "created_at"], {:name=>"index_stream_items_on_user_id_cr[class.thencta.com] out:
[class.thencta.com] out: -> 0.0084s
[class.thencta.com] out: -- create_table("submission_comment_participants", {:force=>true})
[class.thencta.com] out: -> 0.0164s
[class.thencta.com] out: -- add_index("submission_comment_participants", ["submission_comment_id"], {:name=>"index_submiss[class.thencta.com] out: on_submission_comment_id"})
[class.thencta.com] out: -> 0.0065s
[class.thencta.com] out: -- add_index("submission_comment_participants", ["user_id"], {:name=>"index_submission_comment_pa[class.thencta.com] out:
[class.thencta.com] out: -> 0.0087s
[class.thencta.com] out: -- create_table("submission_comments", {:force=>true})
[class.thencta.com] out: -> 0.0086s
[class.thencta.com] out: -- add_index("submission_comments", ["assessment_request_id"], {:name=>"index_submission_comments[class.thencta.com] out: "})
[class.thencta.com] out: -> 0.0075s
[class.thencta.com] out: -- add_index("submission_comments", ["author_id"], {:name=>"index_submission_comments_on_author_i[class.thencta.com] out:
[class.thencta.com] out: -> 0.0102s
[class.thencta.com] out: -- add_index("submission_comments", ["context_id", "context_type"], {:name=>"index_submission_com[class.thencta.com] out: ontext_type"})
[class.thencta.com] out: -> 0.0073s
[class.thencta.com] out: -- add_index("submission_comments", ["recipient_id"], {:name=>"index_submission_comments_on_recip[class.thencta.com] out:
[class.thencta.com] out: -> 0.0086s
[class.thencta.com] out: -- add_index("submission_comments", ["submission_id"], {:name=>"index_submission_comments_on_subm[class.thencta.com] out:
[class.thencta.com] out: -> 0.0088s
[class.thencta.com] out: -- create_table("submissions", {:force=>true})
[class.thencta.com] out: -> 0.0202s
[class.thencta.com] out: -- add_index("submissions", ["assignment_id", "submission_type"], {:name=>"index_submissions_on_a[class.thencta.com] out: on_type"})
[class.thencta.com] out: -> 0.0079s
[class.thencta.com] out: -- add_index("submissions", ["attachment_id", "submission_type", "process_attempts"], {:name=>"ai[class.thencta.com] out: _attempts"})
[class.thencta.com] out: -> 0.0084s
[class.thencta.com] out: -- add_index("submissions", ["grader_id"], {:name=>"index_submissions_on_grader_id"})
[class.thencta.com] out: -> 0.0081s
[class.thencta.com] out: -- add_index("submissions", ["group_id"], {:name=>"index_submissions_on_group_id"})
[class.thencta.com] out: -> 0.0083s
[class.thencta.com] out: -- add_index("submissions", ["user_id", "assignment_id"], {:unique=>true, :name=>"index_submissio[class.thencta.com] out: ent_id"})
[class.thencta.com] out: -> 0.0152s
[class.thencta.com] out: -- add_index("submissions", ["user_id"], {:name=>"index_submissions_on_user_id"})
[class.thencta.com] out: -> 0.0094s
[class.thencta.com] out: -- create_table("thumbnails", {:force=>true})
[class.thencta.com] out: -> 0.0073s
[class.thencta.com] out: -- add_index("thumbnails", ["parent_id"], {:name=>"index_thumbnails_on_parent_id"})
[class.thencta.com] out: -> 0.0070s
[class.thencta.com] out: -- create_table("user_account_associations", {:force=>true})
[class.thencta.com] out: -> 0.0106s
[class.thencta.com] out: -- add_index("user_account_associations", ["account_id"], {:name=>"index_user_account_association[class.thencta.com] out:
[class.thencta.com] out: -> 0.0069s
[class.thencta.com] out: -- add_index("user_account_associations", ["user_id"], {:name=>"index_user_account_associations_o[class.thencta.com] out:
[class.thencta.com] out: -> 0.0074s
[class.thencta.com] out: -- create_table("user_notes", {:force=>true})
[class.thencta.com] out: -> 0.0067s
[class.thencta.com] out: -- add_index("user_notes", ["user_id", "workflow_state"], {:name=>"index_user_notes_on_user_id_an[class.thencta.com] out:
[class.thencta.com] out: -> 0.0069s
[class.thencta.com] out: -- create_table("user_services", {:force=>true})
[class.thencta.com] out: -> 0.0076s
[class.thencta.com] out: -- add_index("user_services", ["id", "type"], {:name=>"index_user_services_on_id_and_type"})
[class.thencta.com] out: -> 0.0072s
[class.thencta.com] out: -- add_index("user_services", ["user_id"], {:name=>"index_user_services_on_user_id"})
[class.thencta.com] out: -> 0.0078s
[class.thencta.com] out: -- create_table("users", {:force=>true})
[class.thencta.com] out: -> 0.0157s
[class.thencta.com] out: -- add_index("users", ["avatar_state", "avatar_image_updated_at"], {:name=>"index_users_on_avatar[class.thencta.com] out: pdated_at"})
[class.thencta.com] out: -> 0.0086s
[class.thencta.com] out: -- add_index("users", ["creation_unique_id", "creation_sis_batch_id"], {:name=>"users_sis_creatio[class.thencta.com] out:
[class.thencta.com] out: -> 0.0088s
[class.thencta.com] out: -- add_index("users", ["id", "type"], {:name=>"index_users_on_id_and_type"})
[class.thencta.com] out: -> 0.0094s
[class.thencta.com] out: -- add_index("users", ["moved_in_account_structure"], {:name=>"index_users_on_moved_in_account_st[class.thencta.com] out:
[class.thencta.com] out: -> 0.0183s
[class.thencta.com] out: -- add_index("users", ["sortable_name"], {:name=>"index_users_on_sortable_name"})
[class.thencta.com] out: -> 0.0104s
[class.thencta.com] out: -- add_index("users", ["uuid"], {:name=>"index_users_on_uuid"})
[class.thencta.com] out: -> 0.0102s
[class.thencta.com] out: -- create_table("versions", {:force=>true})
[class.thencta.com] out: -> 0.0215s
[class.thencta.com] out: -- add_index("versions", ["versionable_id", "versionable_type"], {:name=>"index_versions_on_versi[class.thencta.com] out: _type"})
[class.thencta.com] out: -> 0.0064s
[class.thencta.com] out: -- create_table("web_conference_participants", {:force=>true})
[class.thencta.com] out: -> 0.0066s
[class.thencta.com] out: -- add_index("web_conference_participants", ["user_id"], {:name=>"index_web_conference_participan[class.thencta.com] out:
[class.thencta.com] out: -> 0.0065s
[class.thencta.com] out: -- add_index("web_conference_participants", ["web_conference_id"], {:name=>"index_web_conference_[class.thencta.com] out: rence_id"})
[class.thencta.com] out: -> 0.0069s
[class.thencta.com] out: -- create_table("web_conferences", {:force=>true})
[class.thencta.com] out: -> 0.0149s
[class.thencta.com] out: -- add_index("web_conferences", ["context_id", "context_type"], {:name=>"index_web_conferences_on[class.thencta.com] out: ype"})
[class.thencta.com] out: -> 0.0069s
[class.thencta.com] out: -- add_index("web_conferences", ["user_id"], {:name=>"index_web_conferences_on_user_id"})
[class.thencta.com] out: -> 0.0071s
[class.thencta.com] out: -- create_table("wiki_namespaces", {:force=>true})
[class.thencta.com] out: -> 0.0069s
[class.thencta.com] out: -- add_index("wiki_namespaces", ["context_id", "context_type"], {:name=>"index_wiki_namespaces_on[class.thencta.com] out: ype"})
[class.thencta.com] out: -> 0.0079s
[class.thencta.com] out: -- add_index("wiki_namespaces", ["wiki_id"], {:name=>"index_wiki_namespaces_on_wiki_id"})
[class.thencta.com] out: -> 0.0247s
[class.thencta.com] out: -- create_table("wiki_page_comments", {:force=>true})
[class.thencta.com] out: -> 0.0074s
[class.thencta.com] out: -- add_index("wiki_page_comments", ["wiki_page_id", "workflow_state"], {:name=>"index_wiki_page_c[class.thencta.com] out: nd_workflow_state"})
[class.thencta.com] out: -> 0.0072s
[class.thencta.com] out: -- create_table("wiki_pages", {:force=>true})
[class.thencta.com] out: -> 0.0088s
[class.thencta.com] out: -- add_index("wiki_pages", ["cloned_item_id"], {:name=>"index_wiki_pages_on_cloned_item_id"})
[class.thencta.com] out: -> 0.0191s
[class.thencta.com] out: -- add_index("wiki_pages", ["user_id"], {:name=>"index_wiki_pages_on_user_id"})
[class.thencta.com] out: -> 0.0077s
[class.thencta.com] out: -- add_index("wiki_pages", ["wiki_id"], {:name=>"index_wiki_pages_on_wiki_id"})
[class.thencta.com] out: -> 0.0075s
[class.thencta.com] out: -- create_table("wikis", {:force=>true})
[class.thencta.com] out: -> 0.0064s
[class.thencta.com] out: == InitCanvasDb: migrated (4.4268s) ==========================================
[class.thencta.com] out:
[class.thencta.com] out: == CreateDelayedJobs: migrating ==============================================
[class.thencta.com] out: -- create_table(:delayed_jobs)
[class.thencta.com] out: -> 0.0172s
[class.thencta.com] out: -- add_index(:delayed_jobs, [:priority, :run_at], {:name=>"delayed_jobs_priority"})
[class.thencta.com] out: -> 0.0155s
[class.thencta.com] out: -- add_index(:delayed_jobs, [:queue], {:name=>"delayed_jobs_queue"})
[class.thencta.com] out: -> 0.1592s
[class.thencta.com] out: == CreateDelayedJobs: migrated (0.1923s) =====================================
[class.thencta.com] out:
[class.thencta.com] out: == AddExtraTimeToQuizSubmissions: migrating ==================================
[class.thencta.com] out: -- add_column(:quiz_submissions, :extra_time, :integer)
[class.thencta.com] out: -> 0.0141s
[class.thencta.com] out: -- add_column(:quiz_submissions, :manually_unlocked, :boolean)
[class.thencta.com] out: -> 0.0078s
[class.thencta.com] out: == AddExtraTimeToQuizSubmissions: migrated (0.0221s) =========================
[class.thencta.com] out:
[class.thencta.com] out: == AddIpFilterToQuizzes: migrating ===========================================
[class.thencta.com] out: -- add_column(:quizzes, :ip_filter, :string)
[class.thencta.com] out: -> 0.0093s
[class.thencta.com] out: == AddIpFilterToQuizzes: migrated (0.0094s) ==================================
[class.thencta.com] out:
[class.thencta.com] out: == AddAttachmentToContentMigration: migrating ================================
[class.thencta.com] out: -- add_column(:content_migrations, :exported_attachment_id, :integer, {:limit=>8})
[class.thencta.com] out: -> 0.0196s
[class.thencta.com] out: == AddAttachmentToContentMigration: migrated (0.0197s) =======================
[class.thencta.com] out:
[class.thencta.com] out: == AddDelayedJobsTag: migrating ==============================================
[class.thencta.com] out: -- add_column(:delayed_jobs, :tag, :string)
[class.thencta.com] out: -> 0.0171s
[class.thencta.com] out: -- add_index(:delayed_jobs, [:tag])
[class.thencta.com] out: -> 0.0215s
[class.thencta.com] out: == AddDelayedJobsTag: migrated (0.0388s) =====================================
[class.thencta.com] out:
[class.thencta.com] out: == CreateAccountNotifications: migrating =====================================
[class.thencta.com] out: -- create_table(:account_notifications)
[class.thencta.com] out: -> 0.0151s
[class.thencta.com] out: -- add_index(:account_notifications, [:account_id, :start_at])
[class.thencta.com] out: -> 0.0072s
[class.thencta.com] out: == CreateAccountNotifications: migrated (0.0225s) ============================
[class.thencta.com] out:
[class.thencta.com] out: == AddPodcastOptionsToDiscussionTopics: migrating ============================
[class.thencta.com] out: -- add_column(:discussion_topics, :podcast_enabled, :boolean)
[class.thencta.com] out: -> 0.0094s
[class.thencta.com] out: -- add_column(:discussion_topics, :podcast_has_student_posts, :boolean)
[class.thencta.com] out: -> 0.0180s
[class.thencta.com] out: == AddPodcastOptionsToDiscussionTopics: migrated (0.0277s) ===================
[class.thencta.com] out:
[class.thencta.com] out: == AddRequireInitialPostToDiscussionTopics: migrating ========================
[class.thencta.com] out: -- add_column(:discussion_topics, :require_initial_post, :boolean)
[class.thencta.com] out: -> 0.0095s
[class.thencta.com] out: == AddRequireInitialPostToDiscussionTopics: migrated (0.0096s) ===============
[class.thencta.com] out:
[class.thencta.com] out: == AddRestrictionOptionsToCoursesAndSections: migrating ======================
[class.thencta.com] out: -- add_column(:courses, :restrict_enrollments_to_course_dates, :boolean)
[class.thencta.com] out: -> 0.0100s
[class.thencta.com] out: -- add_column(:course_sections, :restrict_enrollments_to_section_dates, :boolean)
[class.thencta.com] out: -> 0.0245s
[class.thencta.com] out: -- add_column(:enrollment_terms, :ignore_term_date_restrictions, :boolean)
[class.thencta.com] out: -> 0.0066s
[class.thencta.com] out: == AddRestrictionOptionsToCoursesAndSections: migrated (0.0414s) =============
[class.thencta.com] out:
[class.thencta.com] out: == ChangeFudgePointsToFloat: migrating =======================================
[class.thencta.com] out: -- change_column(:quiz_submissions, :fudge_points, :float)
[class.thencta.com] out: -> 0.0111s
[class.thencta.com] out: == ChangeFudgePointsToFloat: migrated (0.0112s) ==============================
[class.thencta.com] out:
[class.thencta.com] out: == AddCrossListingInfo: migrating ============================================
[class.thencta.com] out: -- add_column(:course_sections, :account_id, :integer, {:limit=>8})
[class.thencta.com] out: -> 0.0251s
[class.thencta.com] out: == AddCrossListingInfo: migrated (0.0252s) ===================================
[class.thencta.com] out:
[class.thencta.com] out: == AddUngradedCountToAssignments: migrating ==================================
[class.thencta.com] out: -- add_column(:assignments, :needs_grading_count, :integer, {:default=>0})
[class.thencta.com] out: -> 0.0100s
[class.thencta.com] out: -- execute(" UPDATE assignments SET needs_grading_count = COALESCE((\n SELECT COUNT(*)\n FROM submissions s\n INNER JOIN enrollments e ON e.user_id = s.user_id AND e.workflow_state = 'active'\n WHERE s.assignment_id = assignments.id\n AND e.course_id = assignments.context_id\n AND (s.score IS NULL\n OR NOT grade_matches_current_submission\n OR s.workflow_state = 'submitted'\n [class.thencta.com] out: nding_review'\n )\n AND s.submission_type IS NOT NULL\n ), 0)\n")
[class.thencta.com] out: -> 0.0006s
[class.thencta.com] out: == AddUngradedCountToAssignments: migrated (0.0109s) =========================
[class.thencta.com] out:
[class.thencta.com] out: == CreateContextExternalTools: migrating =====================================
[class.thencta.com] out: -- create_table(:context_external_tools)
[class.thencta.com] out: -> 0.0061s
[class.thencta.com] out: == CreateContextExternalTools: migrated (0.0062s) ============================
[class.thencta.com] out:
[class.thencta.com] out: == AddAssociatedAssetToLearningOutcomeResults: migrating =====================
[class.thencta.com] out: -- add_column(:learning_outcome_results, :associated_asset_id, :integer, {:limit=>8})
[class.thencta.com] out: -> 0.0067s
[class.thencta.com] out: -- add_column(:learning_outcome_results, :associated_asset_type, :string)
[class.thencta.com] out: -> 0.0314s
[class.thencta.com] out: -- remove_index(:learning_outcome_results, [:user_id, :content_tag_id])
[class.thencta.com] out: -> 0.0147s
[class.thencta.com] out: -- add_index(:learning_outcome_results, [:user_id, :content_tag_id, :associated_asset_id, :associ[class.thencta.com] out: e=>true, :name=>"index_learning_outcome_results_association"})
[class.thencta.com] out: -> 0.0070s
[class.thencta.com] out: == AddAssociatedAssetToLearningOutcomeResults: migrated (0.0603s) ============
[class.thencta.com] out:
[class.thencta.com] out: == ChangeContextMessageViewedUserIdsSize: migrating ==========================
[class.thencta.com] out: -- change_column(:context_messages, :viewed_user_ids, :text)
[class.thencta.com] out: -> 0.0279s
[class.thencta.com] out: == ChangeContextMessageViewedUserIdsSize: migrated (0.0280s) =================
[class.thencta.com] out:
[class.thencta.com] out: == AddStreamItemInstancesIndex: migrating ====================================
[class.thencta.com] out: -- add_index("stream_item_instances", ["stream_item_id"])
[class.thencta.com] out: -> 0.0075s
[class.thencta.com] out: == AddStreamItemInstancesIndex: migrated (0.0077s) ===========================
[class.thencta.com] out:
[class.thencta.com] out: == AddCreatedAtToPageViewsIndex: migrating ===================================
[class.thencta.com] out: -- remove_index(:page_views, {:column=>:account_id})
[class.thencta.com] out: -> 0.0078s
[class.thencta.com] out: -- add_index(:page_views, [:account_id, :created_at])
[class.thencta.com] out: -> 0.0096s
[class.thencta.com] out: == AddCreatedAtToPageViewsIndex: migrated (0.0176s) ==========================
[class.thencta.com] out:
[class.thencta.com] out: == UngradedCountTriggers: migrating ==========================================
[class.thencta.com] out: -- create_trigger("enrollments_after_insert_row_when_new_workflow_state_active__tr", {:generated=[class.thencta.com] out:
[class.thencta.com] out: -> 0.0002s
[class.thencta.com] out: -- create_trigger("enrollments_after_update_row_when_new_workflow_state_old_wor_tr", {:generated=[class.thencta.com] out:
[class.thencta.com] out: -> 0.0002s
[class.thencta.com] out: -- create_trigger("submissions_after_update_row_tr", {:generated=>true})
[class.thencta.com] out: -> 0.0002s
[class.thencta.com] out: == UngradedCountTriggers: migrated (0.0348s) =================================
[class.thencta.com] out:
[class.thencta.com] out: == AddQuizRequireLockdownBrowser: migrating ==================================
[class.thencta.com] out: -- add_column(:quizzes, :require_lockdown_browser, :boolean)
[class.thencta.com] out: -> 0.0081s
[class.thencta.com] out: == AddQuizRequireLockdownBrowser: migrated (0.0082s) =========================
[class.thencta.com] out:
[class.thencta.com] out: == UngradedCountTriggers2: migrating =========================================
[class.thencta.com] out: -- drop_trigger("enrollments_after_insert_row_when_new_workflow_state_active__tr", "enrollments",[class.thencta.com] out:
[class.thencta.com] out: -> 0.0033s
[class.thencta.com] out: -- drop_trigger("enrollments_after_update_row_when_new_workflow_state_old_wor_tr", "enrollments",[class.thencta.com] out:
[class.thencta.com] out: -> 0.0006s
[class.thencta.com] out: -- drop_trigger("submissions_after_update_row_tr", "submissions", {:generated=>true})
[class.thencta.com] out: -> 0.0007s
[class.thencta.com] out: -- drop_trigger("submissions_after_update_row_when_old_submission_type_is_not_tr", "submissions",[class.thencta.com] out:
[class.thencta.com] out: -> 0.0004s
[class.thencta.com] out: -- create_trigger("enrollments_after_insert_row_when_new_workflow_state_active__tr", {:compatibil[class.thencta.com] out: )
[class.thencta.com] out: -> 0.0002s
[class.thencta.com] out: -- create_trigger("enrollments_after_update_row_when_new_workflow_state_old_wor_tr", {:compatibil[class.thencta.com] out: )
[class.thencta.com] out: -> 0.0002s
[class.thencta.com] out: -- create_trigger("submissions_after_update_row_tr", {:compatibility=>1, :generated=>true})
[class.thencta.com] out: -> 0.0002s
[class.thencta.com] out: == UngradedCountTriggers2: migrated (0.0348s) ================================
[class.thencta.com] out:
[class.thencta.com] out: == AddPositionToCommunicationChannelIndexes: migrating =======================
[class.thencta.com] out: -- remove_index(:communication_channels, {:column=>["user_id"]})
[class.thencta.com] out: -> 0.0077s
[class.thencta.com] out: -- add_index(:communication_channels, ["user_id", "position"])
[class.thencta.com] out: -> 0.0080s
[class.thencta.com] out: -- remove_index(:communication_channels, {:column=>["pseudonym_id"]})
[class.thencta.com] out: -> 0.0149s
[class.thencta.com] out: -- add_index(:communication_channels, ["pseudonym_id", "position"])
[class.thencta.com] out: -> 0.0083s
[class.thencta.com] out: == AddPositionToCommunicationChannelIndexes: migrated (0.0394s) ==============
[class.thencta.com] out:
[class.thencta.com] out: == StringColumnsToText: migrating ============================================
[class.thencta.com] out: -- change_column(:error_reports, :url, :text)
[class.thencta.com] out: -> 0.0102s
[class.thencta.com] out: -- change_column(:error_reports, :message, :text)
[class.thencta.com] out: -> 0.0102s
[class.thencta.com] out: -- change_column(:content_tags, :url, :text)
[class.thencta.com] out: -> 0.2096s
[class.thencta.com] out: -- change_column(:page_views, :user_agent, :text)
[class.thencta.com] out: -> 0.0113s
[class.thencta.com] out: == StringColumnsToText: migrated (0.2418s) ===================================
[class.thencta.com] out:
[class.thencta.com] out: == PostgresCompatFixes: migrating ============================================
[class.thencta.com] out: -- change_column(:attachments, :size, :bigint)
[class.thencta.com] out: -> 0.0159s
[class.thencta.com] out: -- change_column(:error_reports, :user_agent, :text)
[class.thencta.com] out: -> 0.0129s
[class.thencta.com] out: == PostgresCompatFixes: migrated (0.0290s) ===================================
[class.thencta.com] out:
[class.thencta.com] out: == AddOldMediaIdToMediaComments: migrating ===================================
[class.thencta.com] out: -- add_column(:media_objects, :old_media_id, :string)
[class.thencta.com] out: -> 0.0077s
[class.thencta.com] out: -- add_index(:media_objects, [:old_media_id])
[class.thencta.com] out: -> 0.0086s
[class.thencta.com] out: == AddOldMediaIdToMediaComments: migrated (0.0165s) ==========================
[class.thencta.com] out:
[class.thencta.com] out: == AllowLongCertificateFingerprint: migrating ================================
[class.thencta.com] out: -- change_column(:account_authorization_configs, :certificate_fingerprint, :text)
[class.thencta.com] out: -> 0.0130s
[class.thencta.com] out: == AllowLongCertificateFingerprint: migrated (0.0131s) =======================
[class.thencta.com] out:
[class.thencta.com] out: == VarcharsToText: migrating =================================================
[class.thencta.com] out: -- change_column(:assessment_question_banks, :title, :text)
[class.thencta.com] out: -> 0.0088s
[class.thencta.com] out: -- change_column(:assessment_questions, :name, :text)
[class.thencta.com] out: -> 0.0098s
[class.thencta.com] out: -- change_column(:asset_user_accesses, :display_name, :text)
[class.thencta.com] out: -> 0.1085s
[class.thencta.com] out: -- change_column(:attachments, :display_name, :text)
[class.thencta.com] out: -> 0.0159s
[class.thencta.com] out: -- change_column(:attachments, :filename, :text)
[class.thencta.com] out: -> 0.0157s
[class.thencta.com] out: -- change_column(:content_tags, :title, :text)
[class.thencta.com] out: -> 0.0123s
[class.thencta.com] out: -- change_column(:context_modules, :name, :text)
[class.thencta.com] out: -> 0.2494s
[class.thencta.com] out: -- change_column(:delayed_messages, :name_of_topic, :text)
[class.thencta.com] out: -> 0.0122s
[class.thencta.com] out: -- change_column(:messages, :from_name, :text)
[class.thencta.com] out: -> 0.0126s
[class.thencta.com] out: -- change_column(:messages, :subject, :text)
[class.thencta.com] out: -> 0.0272s
[class.thencta.com] out: -- change_column(:notifications, :sms_body, :text)
[class.thencta.com] out: -> 0.0083s
[class.thencta.com] out: -- change_column(:page_views, :url, :text)
[class.thencta.com] out: -> 0.0108s
[class.thencta.com] out: -- change_column(:users, :features_used, :text)
[class.thencta.com] out: -> 0.0209s
[class.thencta.com] out: -- change_column(:wiki_pages, :url, :text)
[class.thencta.com] out: -> 0.0103s
[class.thencta.com] out: == VarcharsToText: migrated (0.5243s) ========================================
[class.thencta.com] out:
[class.thencta.com] out: == AddContentExport: migrating ===============================================
[class.thencta.com] out: -- create_table(:content_exports)
[class.thencta.com] out: -> 0.0063s
[class.thencta.com] out: -- add_index(:content_exports, [:course_id])
[class.thencta.com] out: -> 0.0069s
[class.thencta.com] out: -- add_index(:content_exports, [:user_id])
[class.thencta.com] out: -> 0.0204s
[class.thencta.com] out: == AddContentExport: migrated (0.0340s) ======================================
[class.thencta.com] out:
[class.thencta.com] out: == WebConferenceSettings: migrating ==========================================
[class.thencta.com] out: -- add_column(:web_conferences, :settings, :text)
[class.thencta.com] out: -> 0.0072s
[class.thencta.com] out: == WebConferenceSettings: migrated (0.0073s) =================================
[class.thencta.com] out:
[class.thencta.com] out: == AddWorkflowStateToGradingStandards: migrating =============================
[class.thencta.com] out: -- add_column(:grading_standards, :workflow_state, :string)
[class.thencta.com] out: -> 0.0075s
[class.thencta.com] out: == AddWorkflowStateToGradingStandards: migrated (0.0139s) ====================
[class.thencta.com] out:
[class.thencta.com] out: == AddMigrationIdsForCcImporting: migrating ==================================
[class.thencta.com] out: -- add_column(:context_external_tools, :migration_id, :string)
[class.thencta.com] out: -> 0.0168s
[class.thencta.com] out: -- add_column(:external_feeds, :migration_id, :string)
[class.thencta.com] out: -> 0.0077s
[class.thencta.com] out: -- add_column(:grading_standards, :migration_id, :string)
[class.thencta.com] out: -> 0.0069s
[class.thencta.com] out: -- add_column(:learning_outcome_groups, :migration_id, :string)
[class.thencta.com] out: -> 0.0073s
[class.thencta.com] out: == AddMigrationIdsForCcImporting: migrated (0.0391s) =========================
[class.thencta.com] out:
[class.thencta.com] out: == AddGradePublishingStatusToEnrollments: migrating ==========================
[class.thencta.com] out: -- add_column(:enrollments, :grade_publishing_status, :string, {:default=>"unpublished"})
[class.thencta.com] out: -> 0.0163s
[class.thencta.com] out: -- add_column(:enrollments, :last_publish_attempt_at, :datetime)
[class.thencta.com] out: -> 0.0088s
[class.thencta.com] out: == AddGradePublishingStatusToEnrollments: migrated (0.0253s) =================
[class.thencta.com] out:
[class.thencta.com] out: == AddMediaCommentToContextMessage: migrating ================================
[class.thencta.com] out: -- add_column(:context_messages, :media_comment_id, :string)
[class.thencta.com] out: -> 0.0077s
[class.thencta.com] out: -- add_column(:context_messages, :media_comment_type, :string)
[class.thencta.com] out: -> 0.0071s
[class.thencta.com] out: == AddMediaCommentToContextMessage: migrated (0.0151s) =======================
[class.thencta.com] out:
[class.thencta.com] out: == AddLastCourseToCourseSection: migrating ===================================
[class.thencta.com] out: -- add_column(:course_sections, :last_course_id, :integer, {:limit=>8})
[class.thencta.com] out: -> 0.1116s
[class.thencta.com] out: == AddLastCourseToCourseSection: migrated (0.1118s) ==========================
[class.thencta.com] out:
[class.thencta.com] out: == AddQuizRequireLockdownBrowserForResults: migrating ========================
[class.thencta.com] out: -- add_column(:quizzes, :require_lockdown_browser_for_results, :boolean)
[class.thencta.com] out: -> 0.0091s
[class.thencta.com] out: == AddQuizRequireLockdownBrowserForResults: migrated (0.0092s) ===============
[class.thencta.com] out:
[class.thencta.com] out: == RenameLastCourseToNonxlistCourseInCourseSection: migrating ================
[class.thencta.com] out: -- rename_column(:course_sections, :last_course_id, :nonxlist_course_id)
[class.thencta.com] out: -> 0.0092s
[class.thencta.com] out: == RenameLastCourseToNonxlistCourseInCourseSection: migrated (0.0094s) =======
[class.thencta.com] out:
[class.thencta.com] out: == AddDelayedJobsMaxAttempts: migrating ======================================
[class.thencta.com] out: -- add_column(:delayed_jobs, :max_attempts, :integer)
[class.thencta.com] out: -> 0.0178s
[class.thencta.com] out: == AddDelayedJobsMaxAttempts: migrated (0.0180s) =============================
[class.thencta.com] out:
[class.thencta.com] out: == ExpandContentMigrationMigrationSettings: migrating ========================
[class.thencta.com] out: -- change_column(:content_migrations, :migration_settings, :text, {:limit=>512000})
[class.thencta.com] out: -> 0.0375s
[class.thencta.com] out: == ExpandContentMigrationMigrationSettings: migrated (0.0377s) ===============
[class.thencta.com] out:
[class.thencta.com] out: == AddDisabledToPluginSettings: migrating ====================================
[class.thencta.com] out: -- add_column(:plugin_settings, :disabled, :boolean)
[class.thencta.com] out: -> 0.0070s
[class.thencta.com] out: == AddDisabledToPluginSettings: migrated (0.0071s) ===========================
[class.thencta.com] out:
[class.thencta.com] out: == AddThumbnailUuid: migrating ===============================================
[class.thencta.com] out: -- add_column(:thumbnails, :uuid, :string)
[class.thencta.com] out: -> 0.0075s
[class.thencta.com] out: -- add_index(:thumbnails, [:id, :uuid])
[class.thencta.com] out: -> 0.0219s
[class.thencta.com] out: == AddThumbnailUuid: migrated (0.0314s) ======================================
[class.thencta.com] out:
[class.thencta.com] out: == AddErrorReportsDataHash: migrating ========================================
[class.thencta.com] out: -- add_column(:error_reports, :data, :text)
[class.thencta.com] out: -> 0.0081s
[class.thencta.com] out: == AddErrorReportsDataHash: migrated (0.0082s) ===============================
[class.thencta.com] out:
[class.thencta.com] out: == AddSisCommunicationChannelToPseudonyms: migrating =========================
[class.thencta.com] out: -- add_column(:pseudonyms, :sis_communication_channel_id, :integer, {:limit=>8})
[class.thencta.com] out: -> 0.0085s
[class.thencta.com] out: == AddSisCommunicationChannelToPseudonyms: migrated (0.0086s) ================
[class.thencta.com] out:
[class.thencta.com] out: == AddErrorReportCategory: migrating =========================================
[class.thencta.com] out: -- add_column(:error_reports, :category, :string)
[class.thencta.com] out: -> 0.0222s
[class.thencta.com] out: -- add_index(:error_reports, :category)
[class.thencta.com] out: -> 0.0074s
[class.thencta.com] out: == AddErrorReportCategory: migrated (0.0298s) ================================
[class.thencta.com] out:
[class.thencta.com] out: == AddStreamItemInstanceHidden: migrating ====================================
[class.thencta.com] out: -- add_column(:stream_item_instances, :hidden, :boolean, {:default=>false, :null=>false})
[class.thencta.com] out: -> 0.0067s
[class.thencta.com] out: -- add_index(:stream_item_instances, ["user_id", "hidden", "id", "stream_item_id"], {:name=>"inde[class.thencta.com] out: lobal"})
[class.thencta.com] out: -> 0.0067s
[class.thencta.com] out: -- add_index(:stream_item_instances, ["user_id", "context_code", "hidden", "id", "stream_item_id"[class.thencta.com] out: item_instances_context"})
[class.thencta.com] out: -> 0.0080s
[class.thencta.com] out: == AddStreamItemInstanceHidden: migrated (0.0219s) ===========================
[class.thencta.com] out:
[class.thencta.com] out: == AddTemplateCourseIdToCourses: migrating ===================================
[class.thencta.com] out: -- add_column(:courses, :template_course_id, :integer, {:limit=>8})
[class.thencta.com] out: -> 0.0209s
[class.thencta.com] out: -- add_index(:courses, [:template_course_id])
[class.thencta.com] out: -> 0.0102s
[class.thencta.com] out: == AddTemplateCourseIdToCourses: migrated (0.0313s) ==========================
[class.thencta.com] out:
[class.thencta.com] out: == CreateDelayedJobsTestStory: migrating =====================================
[class.thencta.com] out: == CreateDelayedJobsTestStory: migrated (0.0000s) ============================
[class.thencta.com] out:
[class.thencta.com] out: == AddDelayedJobsStrand: migrating ===========================================
[class.thencta.com] out: -- add_column(:delayed_jobs, :strand, :string)
[class.thencta.com] out: -> 0.0203s
[class.thencta.com] out: -- add_index(:delayed_jobs, :strand)
[class.thencta.com] out: -> 0.0184s
[class.thencta.com] out: == AddDelayedJobsStrand: migrated (0.0389s) ==================================
[class.thencta.com] out:
[class.thencta.com] out: == Conversations: migrating ==================================================
[class.thencta.com] out: -- create_table("conversations")
[class.thencta.com] out: -> 0.0157s
[class.thencta.com] out: -- add_index("conversations", ["private_hash"], {:unique=>true})
[class.thencta.com] out: -> 0.0069s
[class.thencta.com] out: -- create_table("conversation_participants")
[class.thencta.com] out: -> 0.0206s
[class.thencta.com] out: -- add_index("conversation_participants", ["conversation_id"])
[class.thencta.com] out: -> 0.0068s
[class.thencta.com] out: -- add_index("conversation_participants", ["user_id", "last_message_at"])
[class.thencta.com] out: -> 0.0076s
[class.thencta.com] out: -- create_table("conversation_messages")
[class.thencta.com] out: -> 0.0058s
[class.thencta.com] out: -- add_index("conversation_messages", ["conversation_id", "created_at"])
[class.thencta.com] out: -> 0.0082s
[class.thencta.com] out: -- create_table("conversation_message_participants")
[class.thencta.com] out: -> 0.0149s
[class.thencta.com] out: == Conversations: migrated (0.0873s) =========================================
[class.thencta.com] out:
[class.thencta.com] out: == AddSisBatchBatchMode: migrating ===========================================
[class.thencta.com] out: -- add_column(:sis_batches, :batch_mode, :boolean)
[class.thencta.com] out: -> 0.0068s
[class.thencta.com] out: -- add_column(:sis_batches, :batch_mode_term_id, :integer, {:limit=>8})
[class.thencta.com] out: -> 0.0071s
[class.thencta.com] out: == AddSisBatchBatchMode: migrated (0.0141s) ==================================
[class.thencta.com] out:
[class.thencta.com] out: == CreateAccessTokens: migrating =============================================
[class.thencta.com] out: -- create_table(:access_tokens)
[class.thencta.com] out: -> 0.0057s
[class.thencta.com] out: -- add_index(:access_tokens, [:token], {:unique=>true})
[class.thencta.com] out: -> 0.0068s
[class.thencta.com] out: -- add_column(:developer_keys, :user_id_int, :integer, {:limit=>8})
[class.thencta.com] out: -> 0.0190s
[class.thencta.com] out: -- execute(" UPDATE developer_keys SET user_id_int = CAST(user_id AS UNSIGNED) WHERE user_[class.thencta.com] out:
[class.thencta.com] out: -> 0.0003s
[class.thencta.com] out: -- remove_column(:developer_keys, :user_id)
[class.thencta.com] out: -> 0.0062s
[class.thencta.com] out: -- rename_column(:developer_keys, :user_id_int, :user_id)
[class.thencta.com] out: -> 0.0064s
[class.thencta.com] out: -- add_column(:developer_keys, :name, :string)
[class.thencta.com] out: -> 0.0070s
[class.thencta.com] out: == CreateAccessTokens: migrated (0.0521s) ====================================
[class.thencta.com] out:
[class.thencta.com] out: == AddParametersToAccountReports: migrating ==================================
[class.thencta.com] out: -- add_column(:account_reports, :parameters, :text)
[class.thencta.com] out: -> 0.0071s
[class.thencta.com] out: == AddParametersToAccountReports: migrated (0.0072s) =========================
[class.thencta.com] out:
[class.thencta.com] out: == RemoveQuizDataIds: migrating ==============================================
[class.thencta.com] out: == RemoveQuizDataIds: migrated (0.0015s) =====================================
[class.thencta.com] out:
[class.thencta.com] out: == CreateTriggerSubmissionsInsert: migrating =================================
[class.thencta.com] out: -- create_trigger("submissions_after_insert_row_tr", {:compatibility=>1, :generated=>true})
[class.thencta.com] out: -> 0.0002s
[class.thencta.com] out: == CreateTriggerSubmissionsInsert: migrated (0.0207s) ========================
[class.thencta.com] out:
[class.thencta.com] out: == CleanupDelayedJobsIndexes: migrating ======================================
[class.thencta.com] out: -- add_index(:delayed_jobs, ["priority", "run_at", "locked_at", "failed_at", "queue"], {:name=>"g[class.thencta.com] out:
[class.thencta.com] out: -> 0.0172s
[class.thencta.com] out: -- remove_index(:delayed_jobs, {:name=>"delayed_jobs_queue"})
[class.thencta.com] out: -> 0.0080s
[class.thencta.com] out: -- remove_index(:delayed_jobs, {:name=>"delayed_jobs_priority"})
[class.thencta.com] out: -> 0.0231s
[class.thencta.com] out: == CleanupDelayedJobsIndexes: migrated (0.0487s) =============================
[class.thencta.com] out:
[class.thencta.com] out: == ConversationTweaks: migrating =============================================
[class.thencta.com] out: -- add_column(:conversation_participants, :last_authored_at, :datetime)
[class.thencta.com] out: -> 0.0162s
[class.thencta.com] out: == ConversationTweaks: migrated (0.0163s) ====================================
[class.thencta.com] out:
[class.thencta.com] out: == AddGroupRootAccount: migrating ============================================
[class.thencta.com] out: -- add_column(:groups, :root_account_id, :integer, {:limit=>8})
[class.thencta.com] out: -> 0.0242s
[class.thencta.com] out: == AddGroupRootAccount: migrated (0.0248s) ===================================
[class.thencta.com] out:
[class.thencta.com] out: == AddGroupSisColumns: migrating =============================================
[class.thencta.com] out: -- add_column(:groups, :sis_source_id, :string)
[class.thencta.com] out: -> 0.0087s
[class.thencta.com] out: -- add_column(:groups, :sis_name, :string)
[class.thencta.com] out: -> 0.0084s
[class.thencta.com] out: -- add_column(:groups, :sis_batch_id, :string)
[class.thencta.com] out: -> 0.0083s
[class.thencta.com] out: -- add_column(:group_memberships, :sis_batch_id, :string)
[class.thencta.com] out: -> 0.0309s
[class.thencta.com] out: == AddGroupSisColumns: migrated (0.0568s) ====================================
[class.thencta.com] out:
[class.thencta.com] out: == RefactorAbstractCourses: migrating ========================================
[class.thencta.com] out: -- remove_column(:course_sections, :abstract_course_id)
[class.thencta.com] out: -> 0.0081s
[class.thencta.com] out: -- remove_index(:abstract_courses, :department_id)
[class.thencta.com] out: -> 0.0812s
[class.thencta.com] out: -- remove_column(:abstract_courses, :college_id)
[class.thencta.com] out: -> 0.0075s
[class.thencta.com] out: -- rename_column(:abstract_courses, :department_id, :account_id)
[class.thencta.com] out: -> 0.0074s
[class.thencta.com] out: -- rename_column(:abstract_courses, :course_code, :short_name)
[class.thencta.com] out: -> 0.0073s
[class.thencta.com] out: -- add_column(:abstract_courses, :enrollment_term_id, :integer, {:limit=>8})
[class.thencta.com] out: -> 0.0064s
[class.thencta.com] out: -- add_column(:abstract_courses, :sis_course_code, :string)
[class.thencta.com] out: -> 0.0075s
[class.thencta.com] out: -- add_column(:abstract_courses, :sis_name, :string)
[class.thencta.com] out: -> 0.0193s
[class.thencta.com] out: -- add_column(:abstract_courses, :workflow_state, :string)
[class.thencta.com] out: -> 0.0074s
[class.thencta.com] out: -- add_index(:abstract_courses, :account_id)
[class.thencta.com] out: -> 0.0079s
[class.thencta.com] out: -- add_index(:abstract_courses, :enrollment_term_id)
[class.thencta.com] out: -> 0.0080s
[class.thencta.com] out: == RefactorAbstractCourses: migrated (0.1750s) ===============================
[class.thencta.com] out:
[class.thencta.com] out: == MessageAttachmentsAndMediaObjects: migrating ==============================
[class.thencta.com] out: -- add_column(:conversations, :has_attachments, :boolean)
[class.thencta.com] out: -> 0.0072s
[class.thencta.com] out: -- add_column(:conversations, :has_media_objects, :boolean)
[class.thencta.com] out: -> 0.0276s
[class.thencta.com] out: -- add_column(:conversation_participants, :has_attachments, :boolean)
[class.thencta.com] out: -> 0.0070s
[class.thencta.com] out: -- add_column(:conversation_participants, :has_media_objects, :boolean)
[class.thencta.com] out: -> 0.0071s
[class.thencta.com] out: == MessageAttachmentsAndMediaObjects: migrated (0.0493s) =====================
[class.thencta.com] out:
[class.thencta.com] out: == AddStickyXlisting: migrating ==============================================
[class.thencta.com] out: -- add_column(:course_sections, :sticky_xlist, :boolean)
[class.thencta.com] out: -> 0.0088s
[class.thencta.com] out: == AddStickyXlisting: migrated (0.0089s) =====================================
[class.thencta.com] out:
[class.thencta.com] out: == OptimizeDelayedJobs: migrating ============================================
[class.thencta.com] out: -- create_table(:failed_jobs)
[class.thencta.com] out: -> 0.0147s
[class.thencta.com] out: -- remove_index(:delayed_jobs, {:name=>"get_delayed_jobs_index"})
[class.thencta.com] out: -> 0.0157s
[class.thencta.com] out: -- remove_index(:delayed_jobs, [:strand])
[class.thencta.com] out: -> 0.0074s
[class.thencta.com] out: -- add_index(:delayed_jobs, ["run_at", "queue", "locked_at", "strand", "priority"], {:name=>"inde[class.thencta.com] out: xt"})
[class.thencta.com] out: -> 0.0078s
[class.thencta.com] out: -- add_index(:delayed_jobs, ["strand", "id"], {:name=>"index_delayed_jobs_on_strand"})
[class.thencta.com] out: -> 0.0080s
[class.thencta.com] out: == OptimizeDelayedJobs: migrated (0.0555s) ===================================
[class.thencta.com] out:
[class.thencta.com] out: == ConvertStorageQuotasToBytes: migrating ====================================
[class.thencta.com] out: -- change_column("users", :storage_quota, :integer, {:limit=>8})
[class.thencta.com] out: -> 0.0392s
[class.thencta.com] out: -- change_column("accounts", :storage_quota, :integer, {:limit=>8})
[class.thencta.com] out: -> 0.0122s
[class.thencta.com] out: -- change_column("accounts", :default_storage_quota, :integer, {:limit=>8})
[class.thencta.com] out: -> 0.0517s
[class.thencta.com] out: -- change_column("courses", :storage_quota, :integer, {:limit=>8})
[class.thencta.com] out: -> 0.0140s
[class.thencta.com] out: -- change_column("groups", :storage_quota, :integer, {:limit=>8})
[class.thencta.com] out: -> 0.0123s
[class.thencta.com] out: == ConvertStorageQuotasToBytes: migrated (0.1329s) ===========================
[class.thencta.com] out:
[class.thencta.com] out: == DropOldStreamItemIndexes: migrating =======================================
[class.thencta.com] out: -- remove_index("stream_item_instances", {:name=>"index_stream_item_instances_with_context_code"}[class.thencta.com] out:
[class.thencta.com] out: -> 0.0006s
[class.thencta.com] out: == DropOldStreamItemIndexes: migrated (0.0008s) ==============================
[class.thencta.com] out:
[class.thencta.com] out: == AddRealUserIdToPageViews: migrating =======================================
[class.thencta.com] out: -- add_column(:page_views, :real_user_id, :integer, {:limit=>8})
[class.thencta.com] out: -> 0.0126s
[class.thencta.com] out: == AddRealUserIdToPageViews: migrated (0.0127s) ==============================
[class.thencta.com] out:
[class.thencta.com] out: == LocalePrefs: migrating ====================================================
[class.thencta.com] out: -- add_column(:users, :locale, :string)
[class.thencta.com] out: -> 0.0096s
[class.thencta.com] out: -- add_column(:users, :browser_locale, :string)
[class.thencta.com] out: -> 0.0093s
[class.thencta.com] out: -- add_column(:courses, :locale, :string)
[class.thencta.com] out: -> 0.0200s
[class.thencta.com] out: -- add_column(:accounts, :default_locale, :string)
[class.thencta.com] out: -> 0.0085s
[class.thencta.com] out: == LocalePrefs: migrated (0.0477s) ===========================================
[class.thencta.com] out:
[class.thencta.com] out: == CreateAlerts: migrating ===================================================
[class.thencta.com] out: -- create_table(:alerts)
[class.thencta.com] out: -> 0.0055s
[class.thencta.com] out: -- create_table(:alert_criteria)
[class.thencta.com] out: -> 0.0046s
[class.thencta.com] out: == CreateAlerts: migrated (0.0103s) ==========================================
[class.thencta.com] out:
[class.thencta.com] out: == MessageCounts: migrating ==================================================
[class.thencta.com] out: -- add_column(:conversation_participants, :message_count, :int, {:default=>0})
[class.thencta.com] out: -> 0.0146s
[class.thencta.com] out: -- execute(" UPDATE conversation_participants\n SET message_count = (\n SELECT COUNT(*)\n FROM conversation_messages, conversation_message_participants\n WHERE conversation_messages.conversation_id = conversation_participants.conversation_id\n AND NOT conversation_messages.generated\n AND conversation_messages.id = conversation_message_participants.conversation_message_id\n AND conversation_participant_id = conversati[class.thencta.com] out: \n")
[class.thencta.com] out: -> 0.0004s
[class.thencta.com] out: == MessageCounts: migrated (0.0153s) =========================================
[class.thencta.com] out:
[class.thencta.com] out: == MessageForwards: migrating ================================================
[class.thencta.com] out: -- add_column(:conversation_messages, :forwarded_message_ids, :text)
[class.thencta.com] out: -> 0.0078s
[class.thencta.com] out: == MessageForwards: migrated (0.0079s) =======================================
[class.thencta.com] out:
[class.thencta.com] out: == UnreadCounts: migrating ===================================================
[class.thencta.com] out: -- add_column(:users, :unread_conversations_count, :int, {:default=>0})
[class.thencta.com] out: -> 0.0097s
[class.thencta.com] out: -- execute(" UPDATE users\n SET unread_conversations_count = (\n SELECT COUNT(*)\n FROM conversation_participants\n WHERE workflow_state = 'unread'\n AND last_message_at IS NOT NULL\n [class.thencta.com] out: )\n")
[class.thencta.com] out: -> 0.0003s
[class.thencta.com] out: == UnreadCounts: migrated (0.0103s) ==========================================
[class.thencta.com] out:
[class.thencta.com] out: == LabelConversations: migrating =============================================
[class.thencta.com] out: -- add_column(:conversation_participants, :label, :string)
[class.thencta.com] out: -> 0.0188s
[class.thencta.com] out: == LabelConversations: migrated (0.0190s) ====================================
[class.thencta.com] out:
[class.thencta.com] out: == AddDeveloperKeyRedirectUri: migrating =====================================
[class.thencta.com] out: -- add_column(:developer_keys, :redirect_uri, :string)
[class.thencta.com] out: -> 0.0065s
[class.thencta.com] out: == AddDeveloperKeyRedirectUri: migrated (0.0066s) ============================
[class.thencta.com] out:
[class.thencta.com] out: == FixDuplicateDiscussions: migrating ========================================
[class.thencta.com] out: == FixDuplicateDiscussions: migrated (0.0016s) ===============================
[class.thencta.com] out:
[class.thencta.com] out: == AddSettingsToCourses: migrating ===========================================
[class.thencta.com] out: -- add_column(:courses, :settings, :text)
[class.thencta.com] out: -> 0.0142s
[class.thencta.com] out: == AddSettingsToCourses: migrated (0.0143s) ==================================
[class.thencta.com] out:
[class.thencta.com] out: == ConversationsHasAttachmentsNotNull: migrating =============================
[class.thencta.com] out: -- change_column_null(:conversations, :has_attachments, false, false)
[class.thencta.com] out: -> 0.0303s
[class.thencta.com] out: -- change_column_default(:conversations, :has_attachments, false)
[class.thencta.com] out: -> 0.0064s
[class.thencta.com] out: -- change_column_null(:conversations, :has_media_objects, false, false)
[class.thencta.com] out: -> 0.0095s
[class.thencta.com] out: -- change_column_default(:conversations, :has_media_objects, false)
[class.thencta.com] out: -> 0.0072s
[class.thencta.com] out: -- change_column_null(:conversation_participants, :has_attachments, false, false)
[class.thencta.com] out: -> 0.0207s
[class.thencta.com] out: -- change_column_default(:conversation_participants, :has_attachments, false)
[class.thencta.com] out: -> 0.0067s
[class.thencta.com] out: -- change_column_null(:conversation_participants, :has_media_objects, false, false)
[class.thencta.com] out: -> 0.0104s
[class.thencta.com] out: -- change_column_default(:conversation_participants, :has_media_objects, false)
[class.thencta.com] out: -> 0.0226s
[class.thencta.com] out: == ConversationsHasAttachmentsNotNull: migrated (0.1147s) ====================
[class.thencta.com] out:
[class.thencta.com] out: == NewInboxMediaComments: migrating ==========================================
[class.thencta.com] out: -- add_column(:conversation_messages, :media_comment_id, :string)
[class.thencta.com] out: -> 0.0068s
[class.thencta.com] out: -- add_column(:conversation_messages, :media_comment_type, :string)
[class.thencta.com] out: -> 0.0093s
[class.thencta.com] out: == NewInboxMediaComments: migrated (0.0163s) =================================
[class.thencta.com] out:
[class.thencta.com] out: == MessageMigration: migrating ===============================================
[class.thencta.com] out: -- add_index(:conversation_message_participants, [:conversation_participant_id, :conversation_mes[class.thencta.com] out: cmp_on_cpi_and_cmi})
[class.thencta.com] out: -> 0.0077s
[class.thencta.com] out: -- add_index(:inbox_items, [:asset_type, :asset_id])
[class.thencta.com] out: -> 0.0157s
[class.thencta.com] out: -- add_column(:conversation_messages, :context_message_id, :integer, {:limit=>8})
[class.thencta.com] out: -> 0.0072s
[class.thencta.com] out: -- add_column(:conversations, :migration_signature, :text)
[class.thencta.com] out: -> 0.0063s
[class.thencta.com] out: -- add_column(:conversations, :tmp_private_hash, :string)
[class.thencta.com] out: -> 0.0068s
[class.thencta.com] out: -- add_column(:conversation_message_participants, :unread, :boolean)
[class.thencta.com] out: -> 0.0067s
[class.thencta.com] out: -- execute(" CREATE TEMPORARY TABLE __migrated_messages engine=innodb\n SELECT\n id,\n user_id AS author_id,\n created_at,\n CASE WHEN subject IS NULL OR LOWER(SUBSTR(subject, 1, 4)) = 're: ' THEN body ELSE subject || '\\n\\n' || body END AS body,\n COALESCE(root_context_message_id, id) AS root_context_message_id,\n media_comment_id,\n media_comment_type,\n '' AS signature\n FROM\n [class.thencta.com] out:
[class.thencta.com] out: -> 0.0014s
[class.thencta.com] out: -- change_column(:__migrated_messages, :signature, :text)
[class.thencta.com] out: -> 0.0030s
[class.thencta.com] out: -- add_index(:__migrated_messages, :id)
[class.thencta.com] out: -> 0.0028s
[class.thencta.com] out: -- execute(" CREATE TEMPORARY TABLE __migrated_message_participants engine=innodb\n SELECT DISTINCT\n context_message_id AS migrated_message_id,\n user_id\n FROM\n context_message_par[class.thencta.com] out:
[class.thencta.com] out: -> 0.0010s
[class.thencta.com] out: -- add_index(:__migrated_message_participants, :migrated_message_id)
[class.thencta.com] out: -> 0.0031s
[class.thencta.com] out: -- execute(" CREATE TEMPORARY TABLE __migrated_message_participant_strings engine=innodb\n SELECT migrated_message_id, GROUP_CONCAT(DISTINCT user_id ORDER BY user_id) AS participants, COUNT(DISTINCT user_i[class.thencta.com] out: FROM __migrated_message_participants\n GROUP BY migrated_message_id\n")
[class.thencta.com] out: -> 0.0021s
[class.thencta.com] out: -- add_index(:__migrated_message_participant_strings, :migrated_message_id)
[class.thencta.com] out: rake aborted!
[class.thencta.com] out: An error has occurred, all later migrations canceled:
[class.thencta.com] out:
[class.thencta.com] out: Index name 'index___migrated_message_participant_strings_on_migrated_message_id' on table '__migr[class.thencta.com] out: strings' is too long; the limit is 64 characters.
[class.thencta.com] out:
[class.thencta.com] out: Tasks: TOP => db:initial_setup => db:migrate
[class.thencta.com] out: (See full trace by running task with --trace)
[class.thencta.com] out:
Fatal error: run() encountered an error (return code 1) while executing 'cd /var/rails/canvas; export GEM_HOME=/home/nilesh/gems; RAILS_ENV=production $GEM_HOME/bin/bundle exec rake db:initial_setup'
Aborting.
Disconnecting from class.thencta.com... done.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment