old_contents: """rdr_created and modifed for biobank_stored_samples
  
  Revision ID: 7490afb4beb3
  Revises: 27b812b403cc
  Create Date: 2020-01-13 12:04:12.201081
  
  """
  from alembic import op
  import sqlalchemy as sa
  from sqlalchemy.dialects import mysql
  
  # revision identifiers, used by Alembic.
  revision = '7490afb4beb3'
  down_revision = '27b812b403cc'
  branch_labels = None
  depends_on = None
  
  
  def upgrade(engine_name):
      globals()["upgrade_%s" % engine_name]()
  
  
  def downgrade(engine_name):
      globals()["downgrade_%s" % engine_name]()
  
  
  
  def upgrade_rdr():
      # ### commands auto generated by Alembic - please adjust! ###
      op.add_column('biobank_stored_sample', sa.Column('modified', sa.DateTime(), nullable=True))
      op.add_column('biobank_stored_sample', sa.Column('rdr_created', sa.DateTime(), nullable=True))
  
      # Timestamp columns
      op.alter_column('biobank_stored_sample', 'rdr_created',
                      existing_type=mysql.DATETIME(fsp=6),
                      nullable=True,
                      existing_server_default=sa.text(u'current_timestamp(6)'))
      op.alter_column('biobank_stored_sample', 'modified',
                      existing_type=mysql.DATETIME(fsp=6),
                      nullable=True,
                      existing_server_default=sa.text(
                          u'current_timestamp(6) ON UPDATE current_timestamp(6)'))
  
  
  def downgrade_rdr():
      # ### commands auto generated by Alembic - please adjust! ###
      op.drop_column('biobank_stored_sample', 'rdr_created')
      op.drop_column('biobank_stored_sample', 'modified')
      # ### end Alembic commands ###
  
  
  def upgrade_metrics():
      # ### commands auto generated by Alembic - please adjust! ###
      pass
      # ### end Alembic commands ###
  
  
  def downgrade_metrics():
      # ### commands auto generated by Alembic - please adjust! ###
      pass
      # ### end Alembic commands ###
  
  
new_contents: """rdr_created and modifed for biobank_stored_samples
  
  Revision ID: 7490afb4beb3
  Revises: f4316bf05797
  Create Date: 2020-01-13 12:04:12.201081
  
  """
  from alembic import op
  import sqlalchemy as sa
  from sqlalchemy.dialects import mysql
  
  # revision identifiers, used by Alembic.
  revision = '7490afb4beb3'
  down_revision = 'f4316bf05797'
  branch_labels = None
  depends_on = None
  
  
  def upgrade(engine_name):
      globals()["upgrade_%s" % engine_name]()
  
  
  def downgrade(engine_name):
      globals()["downgrade_%s" % engine_name]()
  
  
  
  def upgrade_rdr():
      # ### commands auto generated by Alembic - please adjust! ###
      op.add_column('biobank_stored_sample', sa.Column('modified', sa.DateTime(), nullable=True))
      op.add_column('biobank_stored_sample', sa.Column('rdr_created', sa.DateTime(), nullable=True))
  
      # Timestamp columns
      op.alter_column('biobank_stored_sample', 'rdr_created',
                      existing_type=mysql.DATETIME(fsp=6),
                      nullable=True,
                      existing_server_default=sa.text(u'current_timestamp(6)'))
      op.alter_column('biobank_stored_sample', 'modified',
                      existing_type=mysql.DATETIME(fsp=6),
                      nullable=True,
                      existing_server_default=sa.text(
                          u'current_timestamp(6) ON UPDATE current_timestamp(6)'))
  
  
  def downgrade_rdr():
      # ### commands auto generated by Alembic - please adjust! ###
      op.drop_column('biobank_stored_sample', 'rdr_created')
      op.drop_column('biobank_stored_sample', 'modified')
      # ### end Alembic commands ###
  
  
  def upgrade_metrics():
      # ### commands auto generated by Alembic - please adjust! ###
      pass
      # ### end Alembic commands ###
  
  
  def downgrade_metrics():
      # ### commands auto generated by Alembic - please adjust! ###
      pass
      # ### end Alembic commands ###
  
  
subject: fix revision head issue (#1529)