"""add_database_uri_index

Revision ID: f63e893f566a
Revises: 48a00920d007
Create Date: 2023-07-17 11:06:03.390626

"""
from alembic import op
import sqlalchemy as sa
from sqlalchemy.dialects import mysql

# revision identifiers, used by Alembic.
revision = 'f63e893f566a'
down_revision = '48a00920d007'
branch_labels = None
depends_on = None


def upgrade() -> None:
    # ### commands auto generated by Alembic - please adjust! ###
    op.add_column('context', sa.Column('database_uri', sa.String(length=1024), nullable=True))
    op.alter_column('context', 'data',
               existing_type=mysql.LONGTEXT(),
               nullable=False)
    op.create_index(op.f('ix_context_database_uri'), 'context', [sa.text('database_uri(200)')], unique=False)
    # ### end Alembic commands ###


def downgrade() -> None:
    # ### commands auto generated by Alembic - please adjust! ###
    op.drop_index(op.f('ix_context_database_uri'), table_name='context')
    op.alter_column('context', 'data',
               existing_type=mysql.LONGTEXT(),
               nullable=True)
    op.drop_column('context', 'database_uri')
    # ### end Alembic commands ###