8d76ed25a315_dat_subjek_pajak.py

"""dat_subjek_pajak

Revision ID: 8d76ed25a315
Revises: 30611cbc119e
Create Date: 2023-02-20 22:40:25.225733

"""

# revision identifiers, used by Alembic.
revision = '8d76ed25a315'
down_revision = '30611cbc119e'
branch_labels = None
depends_on = None

from alembic import op
import sqlalchemy as sa


def upgrade():
    schema = 'pbb'
    context = op.get_context()
    helpers = context.opts['helpers']
    if not helpers.table_has_column('dat_subjek_pajak', 'email_wp', schema):
        op.add_column('dat_subjek_pajak',
                      sa.Column('email_wp', sa.String(64)), schema=schema)
    if not helpers.table_has_column('dat_subjek_pajak', 'hp_wp', schema):
        op.add_column('dat_subjek_pajak',
                      sa.Column('hp_wp', sa.String(16)), schema=schema)


def downgrade():
    pass