1 # this move is about adding a 'name' column in the 'authority' table
3 #from sfa.util.sfalogging import logger
5 from sqlalchemy import MetaData, Table, Column, String
6 from migrate.changeset.schema import create_column, drop_column
8 def upgrade(migrate_engine):
9 metadata = MetaData(bind = migrate_engine)
10 authorities = Table('authorities', metadata, autoload=True)
11 name_column = Column('name', String)
12 name_column.create(authorities)
14 def downgrade(migrate_engine):
15 metadata = MetaData(bind = migrate_engine)
16 authorities = Table('authorities', metadata, autoload=True)
17 authorities.c.name.drop()