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
9 def upgrade(migrate_engine):
10 metadata = MetaData(bind=migrate_engine)
11 authorities = Table('authorities', metadata, autoload=True)
12 name_column = Column('name', String)
13 name_column.create(authorities)
16 def downgrade(migrate_engine):
17 metadata = MetaData(bind=migrate_engine)
18 authorities = Table('authorities', metadata, autoload=True)
19 authorities.c.name.drop()