1 new commit in galaxy-central: https://bitbucket.org/galaxy/galaxy-central/changeset/4809c1f1265d/ changeset: 4809c1f1265d user: natefoo date: 2012-09-17 20:23:00 summary: I missed some missing indexes... affected #: 1 file diff -r 8c5b336f17620cf5e32c42f6a9443351edc41b78 -r 4809c1f1265d27420472b230fce282995aae02d8 lib/galaxy/model/migrate/versions/0106_add_missing_indexes.py --- a/lib/galaxy/model/migrate/versions/0106_add_missing_indexes.py +++ b/lib/galaxy/model/migrate/versions/0106_add_missing_indexes.py @@ -20,21 +20,40 @@ db_session = scoped_session( sessionmaker( bind=migrate_engine, autoflush=False, autocommit=True ) ) indexes = ( - ( "ix_metadata_file_lda_id", 'metadata_file', 'lda_id' ), # 0003 - ( "ix_history_importable", 'history', 'importable' ), # 0007 - ( "ix_sample_bar_code", 'sample', 'bar_code' ), # 0009 - ( "ix_request_type_deleted", 'request_type', 'deleted' ), # 0012 - ( "ix_galaxy_user_username", 'galaxy_user', 'username' ), # 0014 - ( "ix_form_definition_type", 'form_definition', 'type' ), # 0019 - ( "ix_form_definition_layout", 'form_definition', 'layout' ), # 0019 - ( "ix_job_library_folder_id", 'job', 'library_folder_id' ), # 0020 - ( "ix_galaxy_user_form_values_id", 'galaxy_user', 'form_values_id' ), # 0025 - ( "ix_sample_library_id", 'sample', 'library_id' ), # 0037 - ( "ix_sample_folder_id", 'sample', 'folder_id' ), # 0037 - ( "ix_request_notification", 'request', 'notification' ), # 0057 - ( "ix_sd_external_service_id", 'sample_dataset', 'external_service_id' ), # 0068 - ( "ix_job_handler", 'job', 'handler' ), # 0094 - ( "ix_galaxy_user_email", 'galaxy_user', 'email' ) # 0106 + ( "ix_metadata_file_lda_id", 'metadata_file', 'lda_id' ), # 0003 + ( "ix_history_importable", 'history', 'importable' ), # 0007 + ( "ix_sample_bar_code", 'sample', 'bar_code' ), # 0009 + ( "ix_request_type_deleted", 'request_type', 'deleted' ), # 0012 + ( "ix_galaxy_user_username", 'galaxy_user', 'username' ), # 0014 + ( "ix_form_definition_type", 'form_definition', 'type' ), # 0019 + ( "ix_form_definition_layout", 'form_definition', 'layout' ), # 0019 + ( "ix_job_library_folder_id", 'job', 'library_folder_id' ), # 0020 + ( "ix_page_published", 'page', 'published' ), # 0023 + ( "ix_page_deleted", 'page', 'deleted' ), # 0023 + ( "ix_galaxy_user_form_values_id", 'galaxy_user', 'form_values_id' ), # 0025 + ( "ix_lia_deleted", 'library_info_association', 'deleted' ), # 0036 + ( "ix_lfia_deleted", 'library_folder_info_association', 'deleted' ), # 0036 + ( "ix_lddia_deleted", 'library_dataset_dataset_info_association', 'deleted' ), # 0036 + ( "ix_sample_library_id", 'sample', 'library_id' ), # 0037 + ( "ix_sample_folder_id", 'sample', 'folder_id' ), # 0037 + ( "ix_lia_inheritable", 'library_info_association', 'inheritable' ), # 0038 + ( "ix_lfia_inheritable", 'library_folder_info_association', 'inheritable' ), # 0038 + ( "ix_job_imported", 'job', 'imported' ), # 0051 + ( "ix_request_notification", 'request', 'notification' ), # 0057 + ( "ix_sd_external_service_id", 'sample_dataset', 'external_service_id' ), # 0068 + ( "ix_icda_ldda_parent_id", 'implicitly_converted_dataset_association', 'ldda_parent_id' ), # 0073 + ( "ix_library_dataset_purged", 'library_dataset', 'purged' ), # 0074 + ( "ix_run_subindex", 'run', 'subindex' ), # 0075 + ( "ix_history_dataset_association_purged", 'history_dataset_association', 'purged' ), # 0078 + ( "ix_galaxy_user_disk_usage", 'galaxy_user', 'disk_usage' ), # 0078 + ( "ix_galaxy_session_disk_usage", 'galaxy_session', 'disk_usage' ), # 0078 + ( "ix_icda_ldda_id", 'implicitly_converted_dataset_association', 'ldda_id' ), # 0084 + ( "ix_tsr_includes_datatypes", 'tool_shed_repository', 'includes_datatypes' ), # 0086 + ( "ix_dataset_object_store_id", 'dataset', 'object_store_id' ), # 0089 + ( "ix_job_object_store_id", 'job', 'object_store_id' ), # 0089 + ( "ix_metadata_file_object_store_id", 'metadata_file', 'object_store_id' ), # 0089 + ( "ix_job_handler", 'job', 'handler' ), # 0094 + ( "ix_galaxy_user_email", 'galaxy_user', 'email' ) # 0106 ) def upgrade(): Repository URL: https://bitbucket.org/galaxy/galaxy-central/ -- This is a commit notification from bitbucket.org. You are receiving this because you have the service enabled, addressing the recipient of this email.