old_contents: """create rsinfrastructure
  
  Revision ID: 42122ee941b2
  Revises: 564cf69874b
  Create Date: 2017-03-12 10:35:43.033119
  
  """
  
  # revision identifiers, used by Alembic.
  revision = '42122ee941b2'
  down_revision = '564cf69874b'
  branch_labels = None
  depends_on = None
  
  from sqlalchemy.dialects import postgresql
  from alembic import op
  import sqlalchemy as sa
  import datetime
  
  
  def _get_date():
      return datetime.datetime.now()
  
  
  def upgrade():
      op.create_table('rsinfrastructure',
                      sa.Column('id', sa.Integer, primary_key=True, nullable=False),
                      sa.Column('ip_addr', postgresql.INET, unique=True, nullable=False),
                      sa.Column('host_name', sa.Text),
                      sa.Column('svc_user_id', sa.Integer, sa.ForeignKey('svc_users.id')),
                      sa.Column('os_version', sa.Text),
                      sa.Column('license_level', sa.Text),
                      sa.Column('system_serial_number', sa.Text, unique=True),
                      sa.Column('model_number', sa.Text),
                      sa.Column('last_investigation', sa.TIMESTAMP(timezone=False)),
                      sa.Column('created_at', sa.TIMESTAMP(timezone=False), default=_get_date),
                      sa.Column('updated_at', sa.TIMESTAMP(timezone=False), onupdate=_get_date))
  
  
  def downgrade():
      op.drop_table('rsinfrastructure')
  
new_contents: """create rsinfrastructure
  
  Revision ID: 42122ee941b2
  Revises: 564cf69874b
  Create Date: 2017-03-12 10:35:43.033119
  
  """
  
  # revision identifiers, used by Alembic.
  revision = '42122ee941b2'
  down_revision = '564cf69874b'
  branch_labels = None
  depends_on = None
  
  from sqlalchemy.dialects import postgresql
  from alembic import op
  import sqlalchemy as sa
  import datetime
  
  
  def _get_date():
      return datetime.datetime.now()
  
  
  def upgrade():
      op.create_table('rsinfrastructure',
                      sa.Column('id', sa.Integer, primary_key=True, nullable=False),
                      sa.Column('perception_product_uuid', postgresql.UUID, nullable=False),
                      sa.Column('ip_addr', postgresql.INET, unique=True, nullable=False),
                      sa.Column('host_name', sa.Text),
                      sa.Column('svc_user_id', sa.Integer, sa.ForeignKey('svc_users.id')),
                      sa.Column('created_at', sa.TIMESTAMP(timezone=False), default=_get_date),
                      sa.Column('updated_at', sa.TIMESTAMP(timezone=False), onupdate=_get_date))
  
  
  def downgrade():
      op.drop_table('rsinfrastructure')
  
subject: add perception_product_uuid and remove os_version, license_level, system_serial_number, model_number, last_investigation.