"""Initial Migration3

Revision ID: 849d12c13c8a
Revises:
Create Date: 2021-12-19 17:06:36.345137

"""
import sqlalchemy as sa
import sqlmodel
from alembic import op

# revision identifiers, used by Alembic.
revision = '849d12<PASSWORD>'
down_revision = None
branch_labels = None
depends_on = None


def upgrade():
    # ### commands auto generated by Alembic - please adjust! ###
    op.create_table(
        'user', sa.Column('id', sa.Integer(), nullable=True),
        sa.Column('username', sqlmodel.sql.sqltypes.AutoString(), nullable=False),
        sa.Column('email', sqlmodel.sql.sqltypes.AutoString(), nullable=False),
        sa.Column('password_hashed', sqlmodel.sql.sqltypes.AutoString(), nullable=False),
        sa.Column('is_admin', sa.Boolean(), nullable=False), sa.Column('is_disabled', sa.Boolean(), nullable=False),
        sa.Column('is_verified', sa.Boolean(), nullable=False), sa.PrimaryKeyConstraint('id', 'username', 'email')
    )
    op.create_index(op.f('ix_user_email'), 'user', ['email'], unique=False)
    op.create_index(op.f('ix_user_id'), 'user', ['id'], unique=False)
    op.create_index(op.f('ix_user_is_admin'), 'user', ['is_admin'], unique=False)
    op.create_index(op.f('ix_user_is_disabled'), 'user', ['is_disabled'], unique=False)
    op.create_index(op.f('ix_user_is_verified'), 'user', ['is_verified'], unique=False)
    op.create_index(op.f('ix_user_password_hashed'), 'user', ['password_hashed'], unique=False)
    op.create_index(op.f('ix_user_username'), 'user', ['username'], unique=False)
    # ### end Alembic commands ###


def downgrade():
    # ### commands auto generated by Alembic - please adjust! ###
    op.drop_index(op.f('ix_user_username'), table_name='user')
    op.drop_index(op.f('ix_user_password_hashed'), table_name='user')
    op.drop_index(op.f('ix_user_is_verified'), table_name='user')
    op.drop_index(op.f('ix_user_is_disabled'), table_name='user')
    op.drop_index(op.f('ix_user_is_admin'), table_name='user')
    op.drop_index(op.f('ix_user_id'), table_name='user')
    op.drop_index(op.f('ix_user_email'), table_name='user')
    op.drop_table('user')
    # ### end Alembic commands ###

sqlmodel.sql.sqltypes.AutoString sqlalchemy.Integer alembic.op.drop_table sqlalchemy.PrimaryKeyConstraint alembic.op.f sqlalchemy.Boolean
[((2106, 2127), 'alembic.op.drop_table', 'op.drop_table', (['"""user"""'], {}), "('user')\n", (2119, 2127), False, 'from alembic import op\n'), ((898, 948), 'sqlalchemy.PrimaryKeyConstraint', 'sa.PrimaryKeyConstraint', (['"""id"""', '"""username"""', '"""email"""'], {}), "('id', 'username', 'email')\n", (921, 948), True, 'import sqlalchemy as sa\n'), ((975, 996), 'alembic.op.f', 'op.f', (['"""ix_user_email"""'], {}), "('ix_user_email')\n", (979, 996), False, 'from alembic import op\n'), ((1051, 1069), 'alembic.op.f', 'op.f', (['"""ix_user_id"""'], {}), "('ix_user_id')\n", (1055, 1069), False, 'from alembic import op\n'), ((1121, 1145), 'alembic.op.f', 'op.f', (['"""ix_user_is_admin"""'], {}), "('ix_user_is_admin')\n", (1125, 1145), False, 'from alembic import op\n'), ((1203, 1230), 'alembic.op.f', 'op.f', (['"""ix_user_is_disabled"""'], {}), "('ix_user_is_disabled')\n", (1207, 1230), False, 'from alembic import op\n'), ((1291, 1318), 'alembic.op.f', 'op.f', (['"""ix_user_is_verified"""'], {}), "('ix_user_is_verified')\n", (1295, 1318), False, 'from alembic import op\n'), ((1379, 1410), 'alembic.op.f', 'op.f', (['"""ix_user_password_hashed"""'], {}), "('ix_user_password_hashed')\n", (1383, 1410), False, 'from alembic import op\n'), ((1475, 1499), 'alembic.op.f', 'op.f', (['"""ix_user_username"""'], {}), "('ix_user_username')\n", (1479, 1499), False, 'from alembic import op\n'), ((1675, 1699), 'alembic.op.f', 'op.f', (['"""ix_user_username"""'], {}), "('ix_user_username')\n", (1679, 1699), False, 'from alembic import op\n'), ((1738, 1769), 'alembic.op.f', 'op.f', (['"""ix_user_password_hashed"""'], {}), "('ix_user_password_hashed')\n", (1742, 1769), False, 'from alembic import op\n'), ((1808, 1835), 'alembic.op.f', 'op.f', (['"""ix_user_is_verified"""'], {}), "('ix_user_is_verified')\n", (1812, 1835), False, 'from alembic import op\n'), ((1874, 1901), 'alembic.op.f', 'op.f', (['"""ix_user_is_disabled"""'], {}), "('ix_user_is_disabled')\n", (1878, 1901), False, 'from alembic import op\n'), ((1940, 1964), 'alembic.op.f', 'op.f', (['"""ix_user_is_admin"""'], {}), "('ix_user_is_admin')\n", (1944, 1964), False, 'from alembic import op\n'), ((2003, 2021), 'alembic.op.f', 'op.f', (['"""ix_user_id"""'], {}), "('ix_user_id')\n", (2007, 2021), False, 'from alembic import op\n'), ((2060, 2081), 'alembic.op.f', 'op.f', (['"""ix_user_email"""'], {}), "('ix_user_email')\n", (2064, 2081), False, 'from alembic import op\n'), ((434, 446), 'sqlalchemy.Integer', 'sa.Integer', ([], {}), '()\n', (444, 446), True, 'import sqlalchemy as sa\n'), ((494, 528), 'sqlmodel.sql.sqltypes.AutoString', 'sqlmodel.sql.sqltypes.AutoString', ([], {}), '()\n', (526, 528), False, 'import sqlmodel\n'), ((574, 608), 'sqlmodel.sql.sqltypes.AutoString', 'sqlmodel.sql.sqltypes.AutoString', ([], {}), '()\n', (606, 608), False, 'import sqlmodel\n'), ((664, 698), 'sqlmodel.sql.sqltypes.AutoString', 'sqlmodel.sql.sqltypes.AutoString', ([], {}), '()\n', (696, 698), False, 'import sqlmodel\n'), ((747, 759), 'sqlalchemy.Boolean', 'sa.Boolean', ([], {}), '()\n', (757, 759), True, 'import sqlalchemy as sa\n'), ((803, 815), 'sqlalchemy.Boolean', 'sa.Boolean', ([], {}), '()\n', (813, 815), True, 'import sqlalchemy as sa\n'), ((867, 879), 'sqlalchemy.Boolean', 'sa.Boolean', ([], {}), '()\n', (877, 879), True, 'import sqlalchemy as sa\n')]