"""
Migration script to add a notify column to the request table.
"""

from sqlalchemy import *
from migrate import *
from migrate.changeset import *

import logging
log = logging.getLogger( __name__ )

metadata = MetaData( migrate_engine )

def upgrade():
    print __doc__
    metadata.reflect()
    
    Request_table = Table( "request", metadata, autoload=True )
    c = Column( "notify", Boolean, default=False  )
    c.create( Request_table )
    assert c is Request_table.c.notify

def downgrade():
    pass