Script 55a07cb7bd68_add_table_for_pinnedcoprs_py
|
|
1 """
2 Add table for PinnedCoprs
3
4 Revision ID: 55a07cb7bd68
5 Revises: 2d8b4722918b
6 Create Date: 2019-06-24 22:18:20.411614
7 """
8
9 import sqlalchemy as sa
10 from alembic import op
11
12
13 revision = '55a07cb7bd68'
14 down_revision = '1f4e04bb3618'
15
16
18 op.create_table('pinned_coprs',
19 sa.Column('id', sa.Integer(), nullable=False),
20 sa.PrimaryKeyConstraint('id'),
21
22 sa.Column('copr_id', sa.Integer(), nullable=True),
23 sa.Column('user_id', sa.Integer(), nullable=True),
24 sa.Column('group_id', sa.Integer(), nullable=True),
25 sa.Column('position', sa.Integer(), nullable=False),
26
27 sa.ForeignKeyConstraint(['copr_id'], ['copr.id'], ),
28 sa.ForeignKeyConstraint(['group_id'], ['group.id'], ),
29 sa.ForeignKeyConstraint(['user_id'], ['user.id'], ),
30 )
31 op.create_index(op.f('ix_pinned_coprs_user_id'), 'pinned_coprs', ['user_id'], unique=False),
32 op.create_index(op.f('ix_pinned_coprs_group_id'), 'pinned_coprs', ['group_id'], unique=False),
33
34
36 op.drop_table('pinned_coprs')
37