@@ -0,0 +1,1094 @@
+%22%22%22empty message%0A%0ARevision ID: 0081_noti_status_as_enum%0ARevises: 0080_fix_rate_start_date%0ACreate Date: 2017-05-02 14:50:04.070874%0A%0A%22%22%22%0A%0A# revision identifiers, used by Alembic.%0Arevision = '0081_noti_status_as_enum'%0Adown_revision = '0080_fix_rate_start_date'%0A%0Afrom alembic import op%0Aimport sqlalchemy as sa%0A%0A%0Adef upgrade():%0A    op.create_table('notification_status',%0A        sa.Column('name', sa.String(), nullable=False),%0A        sa.PrimaryKeyConstraint('name')%0A    )%0A%0A    op.execute('ALTER TABLE notifications ADD COLUMN notification_status text')%0A    op.execute('ALTER TABLE notification_history ADD COLUMN notification_status text')%0A%0A    op.create_index(op.f('ix_notifications_notification_status'), 'notifications', %5B'notification_status'%5D)%0A    op.create_index(op.f('ix_notification_history_notification_status'), 'notification_history', %5B'notification_status'%5D)%0A%0A%0Adef downgrade():%0A    op.execute('ALTER TABLE notifications DROP COLUMN notification_status')%0A    op.execute('ALTER TABLE notification_history DROP COLUMN notification_status')%0A    op.execute('DROP TABLE notification_status')%0A

add new notification_status_types static table