<reponame>all-of-us/raw-data-repository<gh_stars>10-100
"""remove primary key from biobank_order_identifier_history
Revision ID: 7d63fbc6d9ca
Revises: <PASSWORD>
Create Date: 2019-08-20 10:33:02.458709
"""
from alembic import op

# revision identifiers, used by Alembic.
revision = '<KEY>'
down_revision = '<PASSWORD>'
branch_labels = None
depends_on = None


def upgrade(engine_name):
    globals()["upgrade_%s" % engine_name]()


def downgrade(engine_name):
    globals()["downgrade_%s" % engine_name]()



def upgrade_rdr():
    # ### commands auto generated by Alembic - please adjust! ###
    op.execute('ALTER TABLE biobank_order_identifier_history DROP PRIMARY KEY;')
    # ### end Alembic commands ###


def downgrade_rdr():
    # ### commands auto generated by Alembic - please adjust! ###
    op.execute('ALTER TABLE biobank_order_identifier_history ADD CONSTRAINT contacts_pk PRIMARY KEY (`system`, `value`, `version`);')
    # ### end Alembic commands ###


def upgrade_metrics():
    # ### commands auto generated by Alembic - please adjust! ###
    pass
    # ### end Alembic commands ###


def downgrade_metrics():
    # ### commands auto generated by Alembic - please adjust! ###
    pass
    # ### end Alembic commands ###

"""remove primary key from biobank_order_identifier_history
Revision ID: 7d63fbc6d9ca
Revises: <PASSWORD>
Create Date: 2019-08-20 10:33:02.458709
"""
from alembic import op

# revision identifiers, used by Alembic.
revision = '<KEY>'
down_revision = '<PASSWORD>'
branch_labels = None
depends_on = None


def upgrade(engine_name):
    globals()["upgrade_%s" % engine_name]()


def downgrade(engine_name):
    globals()["downgrade_%s" % engine_name]()



def upgrade_rdr():
    # ### commands auto generated by Alembic - please adjust! ###
    op.execute('ALTER TABLE biobank_order_identifier_history DROP PRIMARY KEY;')
    # ### end Alembic commands ###


def downgrade_rdr():
    # ### commands auto generated by Alembic - please adjust! ###
    op.execute('ALTER TABLE biobank_order_identifier_history ADD CONSTRAINT contacts_pk PRIMARY KEY (`system`, `value`, `version`);')
    # ### end Alembic commands ###


def upgrade_metrics():
    # ### commands auto generated by Alembic - please adjust! ###
    pass
    # ### end Alembic commands ###


def downgrade_metrics():
    # ### commands auto generated by Alembic - please adjust! ###
    pass
    # ### end Alembic commands ###
remove primary key from biobank_order_identifier_history Revision ID: 7d63fbc6d9ca Revises: <PASSWORD> Create Date: 2019-08-20 10:33:02.458709 # revision identifiers, used by Alembic. # ### commands auto generated by Alembic - please adjust! ### # ### end Alembic commands ### # ### commands auto generated by Alembic - please adjust! ### # ### end Alembic commands ### # ### commands auto generated by Alembic - please adjust! ### # ### end Alembic commands ### # ### commands auto generated by Alembic - please adjust! ### # ### end Alembic commands ###