import sqlalchemy as sa
from alembic import op

revision = '009'
down_revision = '008'
branch_labels = None
depends_on = None

def upgrade():
    op.add_column('tax_documents', sa.Column('superseded_by_doc_id', sa.Integer(), nullable=True), schema='data_center')
    op.add_column('tax_documents', sa.Column('superseded_by_doc_number', sa.String(200), nullable=True), schema='data_center')
    op.add_column('tax_documents', sa.Column('superseded_by_title', sa.Text(), nullable=True), schema='data_center')
    op.add_column('tax_documents', sa.Column('superseded_by_source_url', sa.Text(), nullable=True), schema='data_center')

def downgrade():
    op.drop_column('tax_documents', 'superseded_by_source_url', schema='data_center')
    op.drop_column('tax_documents', 'superseded_by_title', schema='data_center')
    op.drop_column('tax_documents', 'superseded_by_doc_number', schema='data_center')
    op.drop_column('tax_documents', 'superseded_by_doc_id', schema='data_center')