Script 55a07cb7bd68_add_table_for_pinnedcoprs_py
[hide private]
[frames] | no frames]

Source Code for Script 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   
17 -def upgrade():
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
35 -def downgrade():
36 op.drop_table('pinned_coprs')
37