alembic_migration_script_create_account_table_upgrade_downgrade.py

1"""create account table
2
3Revision ID: e93a0d64c61
4Revises: 
5Create Date: 2024-05-22 10:45:01.034563
6
7"""
8from alembic import op
9import sqlalchemy as sa
10
11
12# revision identifiers, used by Alembic.
13revision = 'e93a0d64c61'
14down_revision = None
15branch_labels = None
16depends_on = None
17
18def upgrade():
19    op.create_table(
20        'account',
21        sa.Column('id', sa.Integer, primary_key=True),
22        sa.Column('name', sa.String(50), nullable=False),
23        sa.Column('description', sa.Unicode(200)),
24    )
25
26def downgrade():
27    op.drop_table('account')