@@ -0,0 +1,3405 @@
+%22%22%22remove award, number of pages, and isbn%0A%0ARevision ID: 223f67eabc3%0ARevises: 4357a0df68d%0ACreate Date: 2014-09-29 18:39:26.556967%0A%0A%22%22%22%0Afrom alembic import op%0Aimport sqlalchemy as sa%0Afrom sqlalchemy.dialects import postgresql%0A%0A# revision identifiers, used by Alembic.%0Arevision = '223f67eabc3'%0Adown_revision = '4357a0df68d'%0A%0A%0Adef upgrade():%0A    op.drop_table('award_winners')%0A    op.drop_table('work_awards')%0A    op.drop_table('awards')%0A    op.drop_column('works', 'number_of_pages')%0A    op.drop_column('works', 'isbn')%0A%0A%0Adef downgrade():%0A    op.add_column('works',%0A                  sa.Column('isbn',%0A                            sa.VARCHAR(),%0A                            autoincrement=False,%0A                            nullable=True))%0A    op.add_column('works',%0A                  sa.Column('number_of_pages',%0A                            sa.INTEGER(),%0A                            autoincrement=False,%0A                            nullable=True))%0A    op.create_table(%0A        'awards',%0A        sa.Column('id',%0A                  sa.INTEGER(),%0A                  server_default=%22nextval('awards_id_seq'::regclass)%22,%0A                  nullable=False),%0A        sa.Column('name',%0A                  sa.VARCHAR(),%0A                  autoincrement=False,%0A                  nullable=False),%0A        sa.Column('created_at',%0A                  postgresql.TIMESTAMP(timezone=True),%0A                  autoincrement=False,%0A                  nullable=False),%0A        sa.PrimaryKeyConstraint('id', name='awards_pkey')%0A    )%0A    op.create_table(%0A        'work_awards',%0A        sa.Column('work_id',%0A                  sa.INTEGER(),%0A                  autoincrement=False,%0A                  nullable=False),%0A        sa.Column('award_id',%0A                  sa.INTEGER(),%0A                  autoincrement=False,%0A                  nullable=False),%0A        sa.Column('created_at',%0A                  postgresql.TIMESTAMP(timezone=True),%0A                  autoincrement=False,%0A                  nullable=False),%0A        sa.ForeignKeyConstraint(%5B'award_id'%5D,%0A                                %5B'awards.id'%5D,%0A                                name='work_awards_award_id_fkey'),%0A        sa.ForeignKeyConstraint(%5B'work_id'%5D,%0A                                %5B'works.id'%5D,%0A                                name='work_awards_work_id_fkey'),%0A        sa.PrimaryKeyConstraint('work_id',%0A                                'award_id',%0A                                name='work_awards_pkey')%0A    )%0A    op.create_table(%0A        'award_winners',%0A        sa.Column('person_id',%0A                  sa.INTEGER(),%0A                  autoincrement=False,%0A                  nullable=False),%0A        sa.Column('award_id',%0A                  sa.INTEGER(),%0A                  autoincrement=False,%0A                  nullable=False),%0A        sa.Column('created_at',%0A                  postgresql.TIMESTAMP(timezone=True),%0A                  autoincrement=False,%0A                  nullable=False),%0A        sa.ForeignKeyConstraint(%5B'award_id'%5D,%0A                                %5B'awards.id'%5D,%0A                                name='award_winners_award_id_fkey'),%0A        sa.ForeignKeyConstraint(%5B'person_id'%5D,%0A                                %5B'people.id'%5D,%0A                                name='award_winners_person_id_fkey'),%0A        sa.PrimaryKeyConstraint('person_id',%0A                                'award_id',%0A                                name='award_winners_pkey')%0A    )%0A

add migration script for removed schema