Created
February 26, 2012 02:05
-
-
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.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode 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