"""initial3

Revision ID: 01b6c8ce3965
Revises: <PASSWORD>
Create Date: 2021-11-01 04:29:57.210756

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


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


def upgrade():
    # ### commands auto generated by Alembic - please adjust! ###
    op.add_column('images', sa.Column('size_x', sa.Float(), nullable=False))
    op.add_column('images', sa.Column('size_y', sa.Float(), nullable=False))
    op.create_index(op.f('ix_images_size_x'), 'images', ['size_x'], unique=False)
    op.create_index(op.f('ix_images_size_y'), 'images', ['size_y'], unique=False)
    op.add_column('listings', sa.Column('url', sqlmodel.sql.sqltypes.AutoString(), nullable=False))
    op.create_index(op.f('ix_listings_url'), 'listings', ['url'], unique=False)
    # ### end Alembic commands ###


def downgrade():
    # ### commands auto generated by Alembic - please adjust! ###
    op.drop_index(op.f('ix_listings_url'), table_name='listings')
    op.drop_column('listings', 'url')
    op.drop_index(op.f('ix_images_size_y'), table_name='images')
    op.drop_index(op.f('ix_images_size_x'), table_name='images')
    op.drop_column('images', 'size_y')
    op.drop_column('images', 'size_x')
    # ### end Alembic commands ###

alembic.op.f alembic.op.drop_column sqlalchemy.Float sqlmodel.sql.sqltypes.AutoString
[((1075, 1108), 'alembic.op.drop_column', 'op.drop_column', (['"""listings"""', '"""url"""'], {}), "('listings', 'url')\n", (1089, 1108), False, 'from alembic import op\n'), ((1243, 1277), 'alembic.op.drop_column', 'op.drop_column', (['"""images"""', '"""size_y"""'], {}), "('images', 'size_y')\n", (1257, 1277), False, 'from alembic import op\n'), ((1282, 1316), 'alembic.op.drop_column', 'op.drop_column', (['"""images"""', '"""size_x"""'], {}), "('images', 'size_x')\n", (1296, 1316), False, 'from alembic import op\n'), ((561, 585), 'alembic.op.f', 'op.f', (['"""ix_images_size_x"""'], {}), "('ix_images_size_x')\n", (565, 585), False, 'from alembic import op\n'), ((643, 667), 'alembic.op.f', 'op.f', (['"""ix_images_size_y"""'], {}), "('ix_images_size_y')\n", (647, 667), False, 'from alembic import op\n'), ((825, 848), 'alembic.op.f', 'op.f', (['"""ix_listings_url"""'], {}), "('ix_listings_url')\n", (829, 848), False, 'from alembic import op\n'), ((1023, 1046), 'alembic.op.f', 'op.f', (['"""ix_listings_url"""'], {}), "('ix_listings_url')\n", (1027, 1046), False, 'from alembic import op\n'), ((1127, 1151), 'alembic.op.f', 'op.f', (['"""ix_images_size_y"""'], {}), "('ix_images_size_y')\n", (1131, 1151), False, 'from alembic import op\n'), ((1192, 1216), 'alembic.op.f', 'op.f', (['"""ix_images_size_x"""'], {}), "('ix_images_size_x')\n", (1196, 1216), False, 'from alembic import op\n'), ((435, 445), 'sqlalchemy.Float', 'sa.Float', ([], {}), '()\n', (443, 445), True, 'import sqlalchemy as sa\n'), ((512, 522), 'sqlalchemy.Float', 'sa.Float', ([], {}), '()\n', (520, 522), True, 'import sqlalchemy as sa\n'), ((752, 786), 'sqlmodel.sql.sqltypes.AutoString', 'sqlmodel.sql.sqltypes.AutoString', ([], {}), '()\n', (784, 786), False, 'import sqlmodel\n')]