def do_upgrade():
op.drop_table(u'wtgTAG_usergroup')
op.add_column('wtgTAG', db.Column(
'group_access_rights', mysql.INTEGER(display_width=2), nullable=False))
op.add_column(
'wtgTAG', db.Column('id_usergroup', mysql.INTEGER(display_width=15),
server_default='0', nullable=True))
op.add_column('wtgTAG_bibrec', db.Column(
'annotation', db.Text(convert_unicode=True), nullable=True))
def do_upgrade():
"""Migrate format references."""
op.add_column('collection_format',
db.Column('format', db.String(length=10), nullable=False))
run_sql('UPDATE collection_format cf JOIN format f ON f.id = cf.id_format '
'SET cf.format = f.code')
op.drop_constraint(None, 'collection_format', type_='primary')
op.create_primary_key(None, 'collection_format',
['id_collection', 'format'])
op.drop_column('collection_format', 'id_format')
op.drop_table('formatname')
op.drop_table('format')
def do_upgrade():
"""Migrate format references."""
op.add_column('collection_format',
db.Column('format', db.String(length=10), nullable=False))
run_sql('UPDATE collection_format cf JOIN format f ON f.id = cf.id_format '
'SET cf.format = f.code')
op.drop_constraint(None, 'collection_format', type_='primary')
op.create_primary_key(None, 'collection_format',
['id_collection', 'format'])
op.drop_column('collection_format', 'id_format')
op.drop_table('formatname')
op.drop_table('format')
def do_upgrade():
op.drop_table(u'wtgTAG_usergroup')
op.add_column(
'wtgTAG',
db.Column('group_access_rights',
mysql.INTEGER(display_width=2),
nullable=False))
op.add_column(
'wtgTAG',
db.Column('id_usergroup',
mysql.INTEGER(display_width=15),
server_default='0',
nullable=True))
op.add_column(
'wtgTAG_bibrec',
db.Column('annotation', db.Text(convert_unicode=True), nullable=True))
def do_upgrade():
op.drop_table(u'depDRAFT')
op.drop_table(u'depWORKFLOW')
op.drop_table(u'bibdoc_bibdoc_backup_newdatamodel')
op.drop_table(u'bibdoc_backup_newdatamodel')
def do_upgrade():
op.drop_table(u'depDRAFT')
op.drop_table(u'depWORKFLOW')
op.drop_table(u'bibdoc_bibdoc_backup_newdatamodel')
op.drop_table(u'bibdoc_backup_newdatamodel')
