text: """
  Migration script to add a 'subindex' column to the run table.
  """
  
  from sqlalchemy import *
  from sqlalchemy.orm import *
  from migrate import *
  from migrate.changeset import *
  
  from galaxy.model.custom_types import *
  
  metadata = MetaData( migrate_engine )
  db_session = scoped_session( sessionmaker( bind=migrate_engine, autoflush=False, autocommit=True ) )
  
  def upgrade():
      print __doc__
      metadata.reflect()
      try:
          Run_table = Table( "run", metadata, autoload=True )
          c = Column( "subindex", TrimmedString( 255 ), index=True )
          c.create( Run_table )
          assert c is Run_table.c.subindex
      except Exception, e:
          print "Adding the subindex column to the run table failed: ", str( e )
  
  def downgrade():
      metadata.reflect()
      try:
          Run_table = Table( "run", metadata, autoload=True )
          Run_table.c.subindex.drop()
      except Exception, e:
          print "Dropping the subindex column from run table failed: ", str( e )
  