Module ac5917e5c4fe_make_copr_dirs_unique_by_ownername
|
|
1 """make copr_dirs unique by ownername
2
3 Revision ID: ac5917e5c4fe
4 Revises: 887cbbd6575e
5 Create Date: 2018-07-19 11:45:57.228628
6
7 """
8
9
10 revision = 'ac5917e5c4fe'
11 down_revision = '887cbbd6575e'
12
13 from alembic import op
14 import sqlalchemy as sa
15
16
18 op.add_column('copr_dir', sa.Column('ownername', sa.Text(), nullable=False))
19 op.create_index(op.f('ix_copr_dir_ownername'), 'copr_dir', ['ownername'], unique=False)
20 op.create_unique_constraint('ownername_copr_dir_uniq', 'copr_dir', ['ownername', 'name'])
21 op.drop_constraint(u'copr_dir_copr_id_name_uniq', 'copr_dir', type_='unique')
22
23
25 op.create_unique_constraint(u'copr_dir_copr_id_name_uniq', 'copr_dir', ['copr_id', 'name'])
26 op.drop_constraint('ownername_copr_dir_uniq', 'copr_dir', type_='unique')
27 op.drop_index(op.f('ix_copr_dir_ownername'), table_name='copr_dir')
28 op.drop_column('copr_dir', 'ownername')
29