"""'initial'

Revision ID: 8a306fbc733a
Revises: 
Create Date: 2017-08-30 20:49:19.291984

"""
from alembic import op
import sqlalchemy as sa

# revision identifiers, used by Alembic.
revision='8a306fbc733a'
down_revision=None
branch_labels=None
depends_on=None


def upgrade():
    # ### commands auto generated by Alembic - please adjust! ###
    op.create_table('mylog',
                    sa.Column('id',sa.Integer(),nullable=False),
                    sa.Column('time',sa.DateTime(),nullable=True),
                    sa.Column('ipaddr',sa.String(length=64),nullable=True),
                    sa.Column('ipinfo',sa.String(length=64),nullable=True),
                    sa.PrimaryKeyConstraint('id')
                    )
    op.create_table('roles',
                    sa.Column('id',sa.Integer(),nullable=False),
                    sa.Column('name',sa.String(length=64),nullable=True),
                    sa.PrimaryKeyConstraint('id'),
                    sa.UniqueConstraint('name')
                    )
    op.create_table('users',
                    sa.Column('id',sa.Integer(),nullable=False),
                    sa.Column('email',sa.String(length=64),nullable=True),
                    sa.Column('username',sa.String(length=64),nullable=True),
                    sa.Column('password_hash',sa.String(length=128),nullable=True),
                    sa.Column('role_id',sa.Integer(),nullable=True),
                    sa.ForeignKeyConstraint(['role_id'],['roles.id'],),
                    sa.PrimaryKeyConstraint('id')
                    )
    op.create_index(op.f('ix_users_email'),'users',['email'],unique=True)
    op.create_index(op.f('ix_users_username'),'users',['username'],unique=True)
    # ### end Alembic commands ###


def downgrade():
    # ### commands auto generated by Alembic - please adjust! ###
    op.drop_index(op.f('ix_users_username'),table_name='users')
    op.drop_index(op.f('ix_users_email'),table_name='users')
    op.drop_table('users')
    op.drop_table('roles')
    op.drop_table('mylog')
    # ### end Alembic commands ###
