<reponame>minsukkahng/pokr.kr<filename>alembic/versions/40d44f5e7b69_add_party_id_column_to_cosponsorship_.py
"""add party_id column to cosponsorship table

Revision ID: 40d44f5e7b69
Revises: <PASSWORD>
Create Date: 2014-07-16 19:37:44.977381

"""

# revision identifiers, used by Alembic.
revision = '40d44f5e7b69'
down_revision = '<PASSWORD>'

from alembic import op
import sqlalchemy as sa

def upgrade():
    ### commands auto generated by Alembic - please adjust! ###
    op.add_column('cosponsorship', sa.Column('party_id', sa.Integer(), nullable=True))
    op.create_index(op.f('ix_cosponsorship_party_id'), 'cosponsorship', ['party_id'], unique=False)


def downgrade():
    op.drop_index(op.f('ix_cosponsorship_party_id'), table_name='cosponsorship')
    op.drop_column('cosponsorship', 'party_id')


"""add party_id column to cosponsorship table

Revision ID: 40d44f5e7b69
Revises: <PASSWORD>
Create Date: 2014-07-16 19:37:44.977381

"""

# revision identifiers, used by Alembic.
revision = '40d44f5e7b69'
down_revision = '<PASSWORD>'

from alembic import op
import sqlalchemy as sa

def upgrade():
    ### commands auto generated by Alembic - please adjust! ###
    op.add_column('cosponsorship', sa.Column('party_id', sa.Integer(), nullable=True))
    op.create_index(op.f('ix_cosponsorship_party_id'), 'cosponsorship', ['party_id'], unique=False)


def downgrade():
    op.drop_index(op.f('ix_cosponsorship_party_id'), table_name='cosponsorship')
    op.drop_column('cosponsorship', 'party_id')
add party_id column to cosponsorship table  Revision ID: 40d44f5e7b69 Revises: <PASSWORD> Create Date: 2014-07-16 19:37:44.977381 # revision identifiers, used by Alembic. ### commands auto generated by Alembic - please adjust! ###