"""init

Revision ID: 3b7e032d2384
Revises:
Create Date: 2021-10-01 02:25:02.820531

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

# revision identifiers, used by Alembic.
revision = "3b7e032d2384"
down_revision = None
branch_labels = None
depends_on = None


def upgrade():
    # ### commands auto generated by Alembic - please adjust! ###
    op.create_table(
        "prep",
        sa.Column("address", sqlmodel.sql.sqltypes.AutoString(), nullable=False),
        sa.Column("name", sqlmodel.sql.sqltypes.AutoString(), nullable=True),
        sa.Column("country", sqlmodel.sql.sqltypes.AutoString(), nullable=True),
        sa.Column("city", sqlmodel.sql.sqltypes.AutoString(), nullable=True),
        sa.Column("email", sqlmodel.sql.sqltypes.AutoString(), nullable=True),
        sa.Column("website", sqlmodel.sql.sqltypes.AutoString(), nullable=True),
        sa.Column("details", sqlmodel.sql.sqltypes.AutoString(), nullable=True),
        sa.Column("p2p_endpoint", sqlmodel.sql.sqltypes.AutoString(), nullable=True),
        sa.Column("node_address", sqlmodel.sql.sqltypes.AutoString(), nullable=True),
        sa.Column("status", sqlmodel.sql.sqltypes.AutoString(), nullable=True),
        sa.Column("penalty", sqlmodel.sql.sqltypes.AutoString(), nullable=True),
        sa.Column("grade", sqlmodel.sql.sqltypes.AutoString(), nullable=True),
        sa.Column("last_updated_block", sa.Integer(), nullable=True),
        sa.Column("last_updated_timestamp", sa.Integer(), nullable=True),
        sa.Column("created_block", sa.Integer(), nullable=True),
        sa.Column("created_timestamp", sa.Integer(), nullable=True),
        sa.Column("logo_256", sqlmodel.sql.sqltypes.AutoString(), nullable=True),
        sa.Column("logo_1024", sqlmodel.sql.sqltypes.AutoString(), nullable=True),
        sa.Column("logo_svg", sqlmodel.sql.sqltypes.AutoString(), nullable=True),
        sa.Column("steemit", sqlmodel.sql.sqltypes.AutoString(), nullable=True),
        sa.Column("twitter", sqlmodel.sql.sqltypes.AutoString(), nullable=True),
        sa.Column("youtube", sqlmodel.sql.sqltypes.AutoString(), nullable=True),
        sa.Column("facebook", sqlmodel.sql.sqltypes.AutoString(), nullable=True),
        sa.Column("github", sqlmodel.sql.sqltypes.AutoString(), nullable=True),
        sa.Column("reddit", sqlmodel.sql.sqltypes.AutoString(), nullable=True),
        sa.Column("keybase", sqlmodel.sql.sqltypes.AutoString(), nullable=True),
        sa.Column("telegram", sqlmodel.sql.sqltypes.AutoString(), nullable=True),
        sa.Column("wechat", sqlmodel.sql.sqltypes.AutoString(), nullable=True),
        sa.Column("api_endpoint", sqlmodel.sql.sqltypes.AutoString(), nullable=True),
        sa.Column("server_country", sqlmodel.sql.sqltypes.AutoString(), nullable=True),
        sa.Column("server_city", sqlmodel.sql.sqltypes.AutoString(), nullable=True),
        sa.Column("server_type", sqlmodel.sql.sqltypes.AutoString(), nullable=True),
        sa.PrimaryKeyConstraint("address"),
    )
    op.create_index(op.f("ix_prep_address"), "prep", ["address"], unique=False)
    # ### end Alembic commands ###


def downgrade():
    # ### commands auto generated by Alembic - please adjust! ###
    op.drop_index(op.f("ix_prep_address"), table_name="prep")
    op.drop_table("prep")
    # ### end Alembic commands ###

alembic.op.drop_table alembic.op.f sqlmodel.sql.sqltypes.AutoString sqlalchemy.PrimaryKeyConstraint sqlalchemy.Integer
[((3285, 3306), 'alembic.op.drop_table', 'op.drop_table', (['"""prep"""'], {}), "('prep')\n", (3298, 3306), False, 'from alembic import op\n'), ((2977, 3011), 'sqlalchemy.PrimaryKeyConstraint', 'sa.PrimaryKeyConstraint', (['"""address"""'], {}), "('address')\n", (3000, 3011), True, 'import sqlalchemy as sa\n'), ((3039, 3062), 'alembic.op.f', 'op.f', (['"""ix_prep_address"""'], {}), "('ix_prep_address')\n", (3043, 3062), False, 'from alembic import op\n'), ((3237, 3260), 'alembic.op.f', 'op.f', (['"""ix_prep_address"""'], {}), "('ix_prep_address')\n", (3241, 3260), False, 'from alembic import op\n'), ((429, 463), 'sqlmodel.sql.sqltypes.AutoString', 'sqlmodel.sql.sqltypes.AutoString', ([], {}), '()\n', (461, 463), False, 'import sqlmodel\n'), ((508, 542), 'sqlmodel.sql.sqltypes.AutoString', 'sqlmodel.sql.sqltypes.AutoString', ([], {}), '()\n', (540, 542), False, 'import sqlmodel\n'), ((589, 623), 'sqlmodel.sql.sqltypes.AutoString', 'sqlmodel.sql.sqltypes.AutoString', ([], {}), '()\n', (621, 623), False, 'import sqlmodel\n'), ((667, 701), 'sqlmodel.sql.sqltypes.AutoString', 'sqlmodel.sql.sqltypes.AutoString', ([], {}), '()\n', (699, 701), False, 'import sqlmodel\n'), ((746, 780), 'sqlmodel.sql.sqltypes.AutoString', 'sqlmodel.sql.sqltypes.AutoString', ([], {}), '()\n', (778, 780), False, 'import sqlmodel\n'), ((827, 861), 'sqlmodel.sql.sqltypes.AutoString', 'sqlmodel.sql.sqltypes.AutoString', ([], {}), '()\n', (859, 861), False, 'import sqlmodel\n'), ((908, 942), 'sqlmodel.sql.sqltypes.AutoString', 'sqlmodel.sql.sqltypes.AutoString', ([], {}), '()\n', (940, 942), False, 'import sqlmodel\n'), ((994, 1028), 'sqlmodel.sql.sqltypes.AutoString', 'sqlmodel.sql.sqltypes.AutoString', ([], {}), '()\n', (1026, 1028), False, 'import sqlmodel\n'), ((1080, 1114), 'sqlmodel.sql.sqltypes.AutoString', 'sqlmodel.sql.sqltypes.AutoString', ([], {}), '()\n', (1112, 1114), False, 'import sqlmodel\n'), ((1160, 1194), 'sqlmodel.sql.sqltypes.AutoString', 'sqlmodel.sql.sqltypes.AutoString', ([], {}), '()\n', (1192, 1194), False, 'import sqlmodel\n'), ((1241, 1275), 'sqlmodel.sql.sqltypes.AutoString', 'sqlmodel.sql.sqltypes.AutoString', ([], {}), '()\n', (1273, 1275), False, 'import sqlmodel\n'), ((1320, 1354), 'sqlmodel.sql.sqltypes.AutoString', 'sqlmodel.sql.sqltypes.AutoString', ([], {}), '()\n', (1352, 1354), False, 'import sqlmodel\n'), ((1412, 1424), 'sqlalchemy.Integer', 'sa.Integer', ([], {}), '()\n', (1422, 1424), True, 'import sqlalchemy as sa\n'), ((1486, 1498), 'sqlalchemy.Integer', 'sa.Integer', ([], {}), '()\n', (1496, 1498), True, 'import sqlalchemy as sa\n'), ((1551, 1563), 'sqlalchemy.Integer', 'sa.Integer', ([], {}), '()\n', (1561, 1563), True, 'import sqlalchemy as sa\n'), ((1620, 1632), 'sqlalchemy.Integer', 'sa.Integer', ([], {}), '()\n', (1630, 1632), True, 'import sqlalchemy as sa\n'), ((1680, 1714), 'sqlmodel.sql.sqltypes.AutoString', 'sqlmodel.sql.sqltypes.AutoString', ([], {}), '()\n', (1712, 1714), False, 'import sqlmodel\n'), ((1763, 1797), 'sqlmodel.sql.sqltypes.AutoString', 'sqlmodel.sql.sqltypes.AutoString', ([], {}), '()\n', (1795, 1797), False, 'import sqlmodel\n'), ((1845, 1879), 'sqlmodel.sql.sqltypes.AutoString', 'sqlmodel.sql.sqltypes.AutoString', ([], {}), '()\n', (1877, 1879), False, 'import sqlmodel\n'), ((1926, 1960), 'sqlmodel.sql.sqltypes.AutoString', 'sqlmodel.sql.sqltypes.AutoString', ([], {}), '()\n', (1958, 1960), False, 'import sqlmodel\n'), ((2007, 2041), 'sqlmodel.sql.sqltypes.AutoString', 'sqlmodel.sql.sqltypes.AutoString', ([], {}), '()\n', (2039, 2041), False, 'import sqlmodel\n'), ((2088, 2122), 'sqlmodel.sql.sqltypes.AutoString', 'sqlmodel.sql.sqltypes.AutoString', ([], {}), '()\n', (2120, 2122), False, 'import sqlmodel\n'), ((2170, 2204), 'sqlmodel.sql.sqltypes.AutoString', 'sqlmodel.sql.sqltypes.AutoString', ([], {}), '()\n', (2202, 2204), False, 'import sqlmodel\n'), ((2250, 2284), 'sqlmodel.sql.sqltypes.AutoString', 'sqlmodel.sql.sqltypes.AutoString', ([], {}), '()\n', (2282, 2284), False, 'import sqlmodel\n'), ((2330, 2364), 'sqlmodel.sql.sqltypes.AutoString', 'sqlmodel.sql.sqltypes.AutoString', ([], {}), '()\n', (2362, 2364), False, 'import sqlmodel\n'), ((2411, 2445), 'sqlmodel.sql.sqltypes.AutoString', 'sqlmodel.sql.sqltypes.AutoString', ([], {}), '()\n', (2443, 2445), False, 'import sqlmodel\n'), ((2493, 2527), 'sqlmodel.sql.sqltypes.AutoString', 'sqlmodel.sql.sqltypes.AutoString', ([], {}), '()\n', (2525, 2527), False, 'import sqlmodel\n'), ((2573, 2607), 'sqlmodel.sql.sqltypes.AutoString', 'sqlmodel.sql.sqltypes.AutoString', ([], {}), '()\n', (2605, 2607), False, 'import sqlmodel\n'), ((2659, 2693), 'sqlmodel.sql.sqltypes.AutoString', 'sqlmodel.sql.sqltypes.AutoString', ([], {}), '()\n', (2691, 2693), False, 'import sqlmodel\n'), ((2747, 2781), 'sqlmodel.sql.sqltypes.AutoString', 'sqlmodel.sql.sqltypes.AutoString', ([], {}), '()\n', (2779, 2781), False, 'import sqlmodel\n'), ((2832, 2866), 'sqlmodel.sql.sqltypes.AutoString', 'sqlmodel.sql.sqltypes.AutoString', ([], {}), '()\n', (2864, 2866), False, 'import sqlmodel\n'), ((2917, 2951), 'sqlmodel.sql.sqltypes.AutoString', 'sqlmodel.sql.sqltypes.AutoString', ([], {}), '()\n', (2949, 2951), False, 'import sqlmodel\n')]