@@ -0,0 +1,1196 @@
+%22%22%22Remove agreement_returned_at, countersigned_at and agreement_details%0A   columns from supplier_framework table as they are no longer used%0A%0ARevision ID: 780%0ARevises: 770%0ACreate Date: 2016-11-07 10:14:00.000000%0A%0A%22%22%22%0A%0A# revision identifiers, used by Alembic.%0Arevision = '780'%0Adown_revision = '770'%0A%0Afrom alembic import op%0Aimport sqlalchemy as sa%0A%0A%0Adef upgrade():%0A    op.drop_column('supplier_frameworks', 'agreement_returned_at')%0A    op.drop_column('supplier_frameworks', 'countersigned_at')%0A    op.drop_column('supplier_frameworks', 'agreement_details')%0A%0A%0Adef downgrade():%0A    # Downgrade reinstates the columns but does not populate them with data.%0A    # These fields could be populated with data from the %22current framework agreement%22 after being reinstated.%0A    # That would be better (or at least more easily) done by a script than by this migration if necessary.%0A    op.add_column('supplier_frameworks', sa.Column('agreement_returned_at', sa.DateTime(), nullable=True))%0A    op.add_column('supplier_frameworks', sa.Column('countersigned_at', sa.DateTime(), nullable=True))%0A    op.add_column('supplier_frameworks', sa.Column('agreement_details', sa.dialects.postgresql.JSON(), nullable=True))%0A

Add migration to drop now-unused supplier_framework columns