641fb58fdaaa_biodata_user.py

"""Biodata user

Revision ID: 641fb58fdaaa
Revises: 074b33635316
Create Date: 2022-04-08 23:45:28.499799

"""
from alembic import op
import sqlalchemy as sa


# revision identifiers, used by Alembic.
revision = '641fb58fdaaa'
down_revision = '074b33635316'
branch_labels = None
depends_on = None


def upgrade():
    op.add_column('users', sa.Column('nama_lengkap', sa.String(64)))
    op.add_column('users', sa.Column('tempat_lahir', sa.String(64)))
    op.add_column('users', sa.Column('tgl_lahir', sa.Date))
    op.add_column('users', sa.Column('alamat', sa.String(128)))
    op.add_column('users', sa.Column('rt', sa.Integer))
    op.add_column('users', sa.Column('rw', sa.Integer))
    op.add_column('users', sa.Column('kelurahan', sa.String(64)))
    op.add_column('users', sa.Column('kecamatan', sa.String(64)))
    op.add_column('users', sa.Column('kabupaten', sa.String(64)))
    op.add_column('users', sa.Column('provinsi', sa.String(64)))


def downgrade():
    pass