Module de903581465c_create_table_for_upvoting_and_
|
|
1 """
2 Create table for upvoting and downvoting projects
3
4 Revision ID: de903581465c
5 Revises: 484a1d4dd424
6 Create Date: 2020-07-26 19:36:51.199148
7 """
8
9 import sqlalchemy as sa
10 from alembic import op
11
12
13 revision = 'de903581465c'
14 down_revision = '484a1d4dd424'
15
17 op.create_table(
18 'copr_score',
19 sa.Column('id', sa.Integer(), nullable=False),
20 sa.Column('copr_id', sa.Integer(), nullable=False),
21 sa.Column('user_id', sa.Integer(), nullable=False),
22 sa.Column('score', sa.Integer(), nullable=False),
23 sa.ForeignKeyConstraint(['copr_id'], ['copr.id'], ),
24 sa.ForeignKeyConstraint(['user_id'], ['user.id'], ),
25 sa.PrimaryKeyConstraint('id')
26 )
27 op.create_index(op.f('ix_copr_score_copr_id'), 'copr_score', ['copr_id'], unique=False)
28 op.create_unique_constraint('copr_score_copr_id_user_id_uniq', 'copr_score', ['copr_id', 'user_id'])
29
30
32 op.drop_constraint('copr_score_copr_id_user_id_uniq', 'copr_score', type_='unique')
33 op.drop_index(op.f('ix_copr_score_copr_id'), table_name='copr_score')
34 op.drop_table('copr_score')
35