"""first commit for prod
Revision ID: 5e04dbf30fb0
Revises:
Create Date: 2020-05-17 16:16:53.416294
"""
import sqlalchemy as sa
from alembic import op
from sqlalchemy.dialects import postgresql
# revision identifiers, used by Alembic.
revision = '5e04dbf30fb0'
down_revision = None
branch_labels = None
depends_on = None
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table('unavailable_room_report',
sa.Column('record_id', sa.Integer(), nullable=False),
sa.Column('room_id', sa.String(), nullable=True),
sa.Column('date', sa.Date(), nullable=True),
sa.Column('time', sa.String(length=4), nullable=True),
sa.Column('reporter', sa.String(length=15), nullable=True),
sa.Column('reporter_type', sa.String(), nullable=True),
sa.PrimaryKeyConstraint('record_id'),
sa.UniqueConstraint('room_id', 'date', 'time', 'reporter', 'reporter_type', name='unavailable_room_report_uniq')
)
op.drop_index('idx_token', table_name='calendar_tokens')
op.alter_column('identity_verify_requests', 'create_time',
existing_type=postgresql.TIMESTAMP(timezone=True),
nullable=True)
op.create_index(op.f('ix_simple_passwords_time'), 'simple_passwords', ['time'], unique=False)
op.drop_index('idx_host_time', table_name='visit_tracks')
op.create_index('idx_host_time', 'visit_tracks', ['host_id', 'last_visit_time'], unique=False)
# ### end Alembic commands ###
def downgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.drop_index('idx_host_time', table_name='visit_tracks')
op.create_index('idx_host_time', 'visit_tracks', ['host_id', 'last_visit_time'], unique=True)
op.drop_index(op.f('ix_simple_passwords_time'), table_name='simple_passwords')
op.alter_column('identity_verify_requests', 'create_time',
existing_type=postgresql.TIMESTAMP(timezone=True),
nullable=False)
op.create_index('idx_token', 'calendar_tokens', ['token'], unique=True)
op.drop_table('unavailable_room_report')
# ### end Alembic commands ###
