1 new commit in galaxy-central: https://bitbucket.org/galaxy/galaxy-central/changeset/599e16b18e34/ changeset: 599e16b18e34 user: jgoecks date: 2012-06-13 21:41:52 summary: Make migration script compatible with MySQL. affected #: 1 file diff -r ebd30e5e9120181833621fc9710c1066ad3f9aa7 -r 599e16b18e34267a9563f47b1acaa234165482ea lib/galaxy/model/migrate/versions/0095_hda_subsets.py --- a/lib/galaxy/model/migrate/versions/0095_hda_subsets.py +++ b/lib/galaxy/model/migrate/versions/0095_hda_subsets.py @@ -17,8 +17,8 @@ HistoryDatasetAssociationSubset_table = Table( "history_dataset_association_subset", metadata, Column( "id", Integer, primary_key=True ), - Column( "history_dataset_association_id", Integer, ForeignKey( "history_dataset_association.id" ), index=True ), - Column( "history_dataset_association_subset_id", Integer, ForeignKey( "history_dataset_association.id" ), index=True ), + Column( "history_dataset_association_id", Integer, ForeignKey( "history_dataset_association.id" ) ), + Column( "history_dataset_association_subset_id", Integer, ForeignKey( "history_dataset_association.id" ) ), Column( "location", Unicode(255), index=True) ) @@ -32,6 +32,16 @@ except Exception, e: print str(e) log.debug( "Creating history_dataset_association_subset table failed: %s" % str( e ) ) + + # Manually create indexes because they are too long for MySQL databases. + i1 = Index( "ix_hda_id", HistoryDatasetAssociationSubset_table.c.history_dataset_association_id ) + i2 = Index( "ix_hda_subset_id", HistoryDatasetAssociationSubset_table.c.history_dataset_association_subset_id ) + try: + i1.create() + i2.create() + except Exception, e: + print str(e) + log.debug( "Adding indices to table 'history_dataset_association_subset' table failed: %s" % str( e ) ) def downgrade(): metadata.reflect() 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.