text: """genomic contamination records
  
  Revision ID: 50d9eeb498c3
  Revises: 2d20e3ee280a
  Create Date: 2020-12-17 15:25:04.596627
  
  """
  from alembic import op
  import sqlalchemy as sa
  import rdr_service.model.utils
  
  
  from rdr_service.participant_enums import PhysicalMeasurementsStatus, QuestionnaireStatus, OrderStatus
  from rdr_service.participant_enums import WithdrawalStatus, WithdrawalReason, SuspensionStatus, QuestionnaireDefinitionStatus
  from rdr_service.participant_enums import EnrollmentStatus, Race, SampleStatus, OrganizationType, BiobankOrderStatus
  from rdr_service.participant_enums import OrderShipmentTrackingStatus, OrderShipmentStatus
  from rdr_service.participant_enums import MetricSetType, MetricsKey, GenderIdentity
  from rdr_service.genomic_enums import GenomicJob
  from rdr_service.model.base import add_table_history_table, drop_table_history_table
  from rdr_service.model.code import CodeType
  from rdr_service.model.site_enums import SiteStatus, EnrollingStatus, DigitalSchedulingStatus, ObsoleteStatus
  
  # revision identifiers, used by Alembic.
  revision = '50d9eeb498c3'
  down_revision = '2d20e3ee280a'
  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.create_table('genomic_sample_contamination',
      sa.Column('id', sa.Integer(), autoincrement=True, nullable=False),
      sa.Column('created', sa.DateTime(), nullable=True),
      sa.Column('modified', sa.DateTime(), nullable=True),
      sa.Column('sample_id', sa.String(length=80), nullable=False),
      sa.Column('failed_in_job', rdr_service.model.utils.Enum(GenomicJob), nullable=False),
      sa.ForeignKeyConstraint(['sample_id'], ['biobank_stored_sample.biobank_stored_sample_id'], ),
      sa.PrimaryKeyConstraint('id')
      )
      # ### end Alembic commands ###
  
  
  def downgrade_rdr():
      # ### commands auto generated by Alembic - please adjust! ###
      op.drop_table('genomic_sample_contamination')
      # ### 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 ###
  
  