lavkach3

1
"""init2
2

3
Revision ID: 7c3c9e87f204
4
Revises: 6ea1b38aba41
5
Create Date: 2024-10-20 09:49:19.439688
6

7
"""
8
from alembic import op
9
import sqlalchemy as sa
10
import sqlalchemy_utils
11

12

13
# revision identifiers, used by Alembic.
14
revision = '7c3c9e87f204'
15
down_revision = '6ea1b38aba41'
16
branch_labels = None
17
depends_on = None
18

19

20
def upgrade():
21
    # ### commands auto generated by Alembic - please adjust! ###
22
    op.add_column('bus', sa.Column('user_id', sa.Uuid(), nullable=True))
23
    op.create_index(op.f('ix_bus_user_id'), 'bus', ['user_id'], unique=False)
24
    op.drop_index('ix_user_store_id', table_name='user')
25
    op.drop_constraint('user_store_id_fkey', 'user', type_='foreignkey')
26
    op.drop_column('user', 'store_id')
27
    # ### end Alembic commands ###
28

29

30
def downgrade():
31
    # ### commands auto generated by Alembic - please adjust! ###
32
    op.add_column('user', sa.Column('store_id', sa.UUID(), autoincrement=False, nullable=True))
33
    op.create_foreign_key('user_store_id_fkey', 'user', 'store', ['store_id'], ['id'])
34
    op.create_index('ix_user_store_id', 'user', ['store_id'], unique=False)
35
    op.drop_index(op.f('ix_bus_user_id'), table_name='bus')
36
    op.drop_column('bus', 'user_id')
37
    # ### end Alembic commands ###