"""Add permissions column to admins table

Revision ID: 0003
Revises: 0002
Create Date: 2024-06-01 01:00:00.000000

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

# revision identifiers, used by Alembic.
revision = '0003'
down_revision = '0002'
branch_labels = None
depends_on = None

def upgrade():
    # Add permissions column as JSON type, nullable
    op.add_column('admins', sa.Column('permissions', mysql.JSON(), nullable=True))

def downgrade():
    # Remove permissions column
    op.drop_column('admins', 'permissions')