"""create status table

Revision ID: eae2cc24e54
Revises: 306d3a6e33bc
Create Date: 2020-08-16 18:49:43.618303

"""

# revision identifiers, used by Alembic.
revision = 'eae2cc24e54'
down_revision = '306d3a6e33bc'
branch_labels = None
depends_on = None

from alembic import op
import sqlalchemy as sa
from sqlalchemy.dialects import postgresql


def upgrade():
    op.create_table('status',
                    sa.Column('created_on',
                              postgresql.TIMESTAMP(timezone=True),
                              autoincrement=False, nullable=True),
                    sa.Column('updated_on',
                              postgresql.TIMESTAMP(timezone=True),
                              autoincrement=False, nullable=True),
                    sa.Column('id', sa.INTEGER(), primary_key=True),
                    sa.Column('status', sa.VARCHAR(length=128), nullable=False),
                    sa.Column('display_name', sa.VARCHAR(length=128), nullable=False),
                    sa.Column('default', sa.Boolean(), nullable=False, server_default='0'))


def downgrade():
    op.drop_table('status')