alembic_migration_script_create_account_table_upgrade_downgrade.py

1"""create account table
2
3Revision ID: e93a0d64c097
4Revises: 
5Create Date: 2023-10-27 12:00:00.000000
6
7"""
8from typing import Sequence, Union
9
10from alembic import op
11import sqlalchemy as sa
12
13
14# revision identifiers, used by Alembic.
15revision: str = 'e93a0d64c097'
16down_revision: Union[str, None] = None
17branch_labels: Union[str, Sequence[str], None] = None
18depends_on: Union[str, Sequence[str], None] = None
19
20
21def upgrade() -> None:
22    op.create_table(
23        'account',
24        sa.Column('id', sa.Integer, primary_key=True),
25        sa.Column('name', sa.String(50), nullable=False),
26        sa.Column('description', sa.Unicode(200)),
27    )
28
29
30def downgrade() -> None:
31    op.drop_table('account')