19 """make q member uniqueid autoinc
21 Revision ID: 5139253c0423
23 Create Date: 2014-07-29 16:26:51.184981
28 revision =
'5139253c0423'
29 down_revision =
'1758e8bbf6b'
31 from alembic
import op
32 import sqlalchemy
as sa
38 op.drop_column(
'queue_members',
'uniqueid')
39 op.add_column(
'queue_members', sa.Column(name=
'uniqueid', type_=sa.Integer,
40 nullable=
False, unique=
True))
44 op.alter_column(table_name=
'queue_members', column_name=
'uniqueid',
45 existing_type=sa.Integer, existing_nullable=
False,
52 if op.get_context().bind.dialect.name ==
'mssql':
53 op.drop_constraint(
'uq_queue_members_uniqueid',
'queue_members')
54 op.drop_column(
'queue_members',
'uniqueid')
55 op.add_column(
'queue_members', sa.Column(name=
'uniqueid', type_=sa.String(80), nullable=
False))