"""add case_number, completed_date, received_date; remove division, bureau, resident_weapon_used on BPD UOF table Revision ID: 77ad8047becf Revises: 43c4c512514 Create Date: 2017-01-09 23:48:43.764788 """ # revision identifiers, used by Alembic. revision = '77ad8047becf' down_revision = '43c4c512514' from alembic import op import sqlalchemy as sa def upgrade(): op.add_column('use_of_force_incidents_bpd', sa.Column('case_number', sa.String(length=128), nullable=True)) op.add_column('use_of_force_incidents_bpd', sa.Column('completed_date', sa.DateTime(), nullable=True)) op.add_column('use_of_force_incidents_bpd', sa.Column('received_date', sa.DateTime(), nullable=True)) op.drop_column('use_of_force_incidents_bpd', 'division') op.drop_column('use_of_force_incidents_bpd', 'bureau') op.drop_column('use_of_force_incidents_bpd', 'resident_weapon_used') def downgrade(): op.add_column('use_of_force_incidents_bpd', sa.Column('resident_weapon_used', sa.VARCHAR(length=255), autoincrement=False, nullable=True)) op.add_column('use_of_force_incidents_bpd', sa.Column('bureau', sa.VARCHAR(length=255), autoincrement=False, nullable=True)) op.add_column('use_of_force_incidents_bpd', sa.Column('division', sa.VARCHAR(length=255), autoincrement=False, nullable=True)) op.drop_column('use_of_force_incidents_bpd', 'received_date') op.drop_column('use_of_force_incidents_bpd', 'completed_date') op.drop_column('use_of_force_incidents_bpd', 'case_number')