"""add versions Revision ID: 1f746c93e8fd Revises:39fa82d3168e Create Date: 2015-02-06 03:46:14.342310 """ # revision identifiers, used by Alembic. revision = '1f746c93e8fd' down_revision = '39fa82d3168e' from alembic import op import sqlalchemy as sa def upgrade(): op.drop_column('message', 'version') op.add_column('message', sa.Column('version', sa.Integer(), server_default='0', nullable=False)) op.add_column('thread', sa.Column('version', sa.Integer(), server_default='0', nullable=True)) def downgrade(): op.drop_column('message', 'version') op.add_column('message', sa.Column('version', sa.BINARY(), nullable=True)) op.drop_column('thread', 'version')