"""add_in_user_numeric_id

Revision ID: ee667dfd950d
Revises: ac95633efe60
Create Date: 2020-09-21 14:17:12.465367

"""

# revision identifiers, used by Alembic.
revision = 'ee667dfd950d'
down_revision = 'ac95633efe60'
branch_labels = None
depends_on = None

from alembic import op
import sqlalchemy as sa


def upgrade():
    op.add_column('in_user', sa.Column('numeric_id', sa.BigInteger(), sa.Computed("(page_data->'entry_data'->'ProfilePage'->0->'user'->>'id')::bigint", ), nullable=True))

    op.create_index(op.f('ix_in_user_numeric_id'), 'in_user', ['numeric_id'], unique=False)

def downgrade():
    # ### commands auto generated by Alembic - please adjust! ###
    op.drop_index(op.f('ix_in_user_numeric_id'), table_name='in_user')
    op.drop_column('in_user', 'numeric_id')