lavkach3

1
"""initial
2

3
Revision ID: 1e8431842d98
4
Revises: 
5
Create Date: 2023-06-07 14:29:30.566708
6

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

11

12
# revision identifiers, used by Alembic.
13
revision = '1e8431842d98'
14
down_revision = None
15
branch_labels = None
16
depends_on = None
17

18

19
def upgrade():
20

21
    op.execute("create sequence storage_type_lsn_seq")
22
    op.execute("create sequence suggest_lsn_seq")
23
    op.execute("create sequence order_type_lsn_seq")
24
    op.execute("create sequence order_lsn_seq")
25
    op.execute("create sequence move_lsn_seq")
26
    op.execute("create sequence move_log_lsn_seq")
27
    op.execute("create sequence location_lsn_seq")
28
    op.execute("create sequence location_type_lsn_seq")
29
    op.execute("create sequence lot_lsn_seq")
30
    op.execute("create sequence product_storage_type_lsn_seq")
31
    op.execute("create sequence quant_lsn_seq")
32
    op.execute("create sequence bus_lsn_seq")
33
    op.execute("create sequence channel_lsn_seq")
34
    op.execute("create sequence product_lsn_seq")
35
    op.execute("create sequence product_category_lsn_seq")
36
    op.execute("create sequence permission_lsn_seq")
37
    op.execute("create sequence role_lsn_seq")
38
    op.execute("create sequence partner_lsn_seq")
39
    op.execute("create sequence uom_lsn_seq")
40
    op.execute("create sequence uom_category_lsn_seq")
41
    op.execute("create sequence company_lsn_seq")
42
    op.execute("create sequence user_lsn_seq")
43
    op.execute("create sequence store_lsn_seq")
44

45

46
def downgrade():
47
    # ### commands auto generated by Alembic - please adjust! ###
48
    # ### end Alembic commands ###
49
    op.execute("drop sequence storage_type_lsn_seq")
50
    op.execute("drop sequence suggest_lsn_seq")
51
    op.execute("drop sequence order_type_lsn_seq")
52
    op.execute("drop sequence order_lsn_seq")
53
    op.execute("drop sequence move_lsn_seq")
54
    op.execute("drop sequence move_log_lsn_seq")
55
    op.execute("drop sequence location_lsn_seq")
56
    op.execute("drop sequence location_type_lsn_seq")
57
    op.execute("drop sequence lot_lsn_seq")
58
    op.execute("drop sequence product_storage_type_lsn_seq")
59
    op.execute("drop sequence quant_lsn_seq")
60
    op.execute("drop sequence channel_lsn_seq")
61
    op.execute("drop sequence bus_lsn_seq")
62
    op.execute("drop sequence product_lsn_seq")
63
    op.execute("drop sequence product_category_lsn_seq")
64
    op.execute("drop sequence permission_lsn_seq")
65
    op.execute("drop sequence role_lsn_seq")
66
    op.execute("drop sequence partner_lsn_seq")
67
    op.execute("drop sequence uom_lsn_seq")
68
    op.execute("drop sequence uom_category_lsn_seq")
69
    op.execute("drop sequence company_lsn_seq")
70
    op.execute("drop sequence user_lsn_seq")
71
    op.execute("drop sequence contractor_lsn_seq")
72
    op.execute("drop sequence store_lsn_seq")
73

74