"""Added Executive Compensation Table

Revision ID: 41350e71ae8c
Revises: 20b5109967bf
Create Date: 2017-04-14 08:06:01.597691

"""

# revision identifiers, used by Alembic.
revision = '41350e71ae8c'
down_revision = '20b5109967bf'
branch_labels = None
depends_on = None

from alembic import op
import sqlalchemy as sa


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


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





def upgrade_data_broker():
    ### commands auto generated by Alembic - please adjust! ###
    op.create_table('executive_compensation',
    sa.Column('created_at', sa.DateTime(), nullable=True),
    sa.Column('updated_at', sa.DateTime(), nullable=True),
    sa.Column('executive_compensation_id', sa.Integer(), nullable=False),
    sa.Column('awardee_or_recipient_uniqu', sa.Text(), nullable=True),
    sa.Column('ultimate_parent_unique_ide', sa.Text(), nullable=True),
    sa.Column('ultimate_parent_legal_enti', sa.Text(), nullable=True),
    sa.Column('high_comp_officer1_full_na', sa.Text(), nullable=True),
    sa.Column('high_comp_officer1_amount', sa.Text(), nullable=True),
    sa.Column('high_comp_officer2_full_na', sa.Text(), nullable=True),
    sa.Column('high_comp_officer2_amount', sa.Text(), nullable=True),
    sa.Column('high_comp_officer3_full_na', sa.Text(), nullable=True),
    sa.Column('high_comp_officer3_amount', sa.Text(), nullable=True),
    sa.Column('high_comp_officer4_full_na', sa.Text(), nullable=True),
    sa.Column('high_comp_officer4_amount', sa.Text(), nullable=True),
    sa.Column('high_comp_officer5_full_na', sa.Text(), nullable=True),
    sa.Column('high_comp_officer5_amount', sa.Text(), nullable=True),
    sa.PrimaryKeyConstraint('executive_compensation_id')
    )
    ### end Alembic commands ###


def downgrade_data_broker():
    ### commands auto generated by Alembic - please adjust! ###
    op.drop_table('executive_compensation')
    ### end Alembic commands ###

