Script 3f4966a9cc0_add_group_table_py
|
|
1 """Add group table
2
3 Revision ID: 3f4966a9cc0
4 Revises: 3b4cfc666d14
5 Create Date: 2015-09-24 10:14:06.291886
6
7 """
8
9
10 revision = '3f4966a9cc0'
11 down_revision = '3b4cfc666d14'
12
13 from alembic import op
14 import sqlalchemy as sa
15
16
18 op.create_table('group',
19 sa.Column('id', sa.Integer(), nullable=False),
20 sa.Column('name', sa.String(length=127), nullable=True),
21 sa.Column('fas_name', sa.String(length=127), nullable=True),
22 sa.PrimaryKeyConstraint('id')
23 )
24 op.add_column('copr',
25 sa.Column('group_id', sa.Integer(), nullable=True)
26 )
27
28
30 op.drop_table('group')
31 op.drop_column('copr', 'group_id')
32