"""add meta fields

Revision ID: 44d5319b188d
Revises: e987f7203cb5
Create Date: 2026-04-21 09:50:13.396402

"""
from alembic import op
import sqlalchemy as sa


# revision identifiers, used by Alembic.
revision = '44d5319b188d'
down_revision = 'e987f7203cb5'
branch_labels = None
depends_on = None


def upgrade():
    # ### commands auto generated by Alembic - please adjust! ###
    op.add_column('cmf_attachment', sa.Column('metadata_doc_id', sa.String(length=64), nullable=True))
    op.add_column('cmf_attachment', sa.Column('metadata_text', sa.String(), nullable=True))
    op.add_column('cmf_attachment', sa.Column('metadata_version', sa.String(length=32), nullable=True))
    op.add_column('cmf_attachment', sa.Column('metadata_status', sa.String(length=32), nullable=True))
    op.add_column('cmf_attachment', sa.Column('metadata_link', sa.String(length=4096), nullable=True))
    # ### end Alembic commands ###


def downgrade():
    # ### commands auto generated by Alembic - please adjust! ###
    op.drop_column('cmf_attachment', 'metadata_link')
    op.drop_column('cmf_attachment', 'metadata_status')
    op.drop_column('cmf_attachment', 'metadata_version')
    op.drop_column('cmf_attachment', 'metadata_text')
    op.drop_column('cmf_attachment', 'metadata_doc_id')
    # ### end Alembic commands ###