text: """empty message
  
  Revision ID: cd8ac737a10c
  Revises: 30fe0e82d100
  Create Date: 2017-09-19 17:08:25.713307
  
  """
  from alembic import op
  import sqlalchemy as sa
  
  
  # revision identifiers, used by Alembic.
  revision = 'cd8ac737a10c'
  down_revision = '30fe0e82d100'
  branch_labels = None
  depends_on = None
  
  
  def upgrade():
      # ### commands auto generated by Alembic - please adjust! ###
      op.create_table('email_message',
      sa.Column('id', sa.Integer(), nullable=False),
      sa.Column('session_id', sa.Integer(), nullable=True),
      sa.Column('subject', sa.String(), nullable=True),
      sa.Column('content', sa.TEXT(), nullable=True),
      sa.Column('sent_date', sa.DateTime(), nullable=True),
      sa.Column('author_id', sa.Integer(), nullable=True),
      sa.ForeignKeyConstraint(['author_id'], ['participant.id'], ),
      sa.ForeignKeyConstraint(['session_id'], ['session.id'], ),
      sa.PrimaryKeyConstraint('id')
      )
      op.create_table('email_log',
      sa.Column('participant_id', sa.Integer(), nullable=False),
      sa.Column('email_message_id', sa.Integer(), nullable=False),
      sa.Column('tracking_code', sa.String(), nullable=True),
      sa.Column('opened', sa.Boolean(), nullable=True),
      sa.ForeignKeyConstraint(['email_message_id'], ['email_message.id'], ),
      sa.ForeignKeyConstraint(['participant_id'], ['participant.id'], ),
      sa.PrimaryKeyConstraint('participant_id', 'email_message_id')
      )
      # ### end Alembic commands ###
  
  
  def downgrade():
      # ### commands auto generated by Alembic - please adjust! ###
      op.drop_table('email_log')
      op.drop_table('email_message')
      # ### end Alembic commands ###
  