"""add director/manager name+title to companies, wet_signature to surat

Revision ID: ffff_wet_signature
Revises: eeee_task_comment_attachment
Create Date: 2026-08-11
"""
from alembic import op
import sqlalchemy as sa

revision = 'ffff_wet_signature'
down_revision = 'eeee_task_comment_attachment'
branch_labels = None
depends_on = None


def upgrade() -> None:
    op.add_column('companies', sa.Column('director_name', sa.String(255), nullable=True))
    op.add_column('companies', sa.Column('director_title', sa.String(255), nullable=True))
    op.add_column('companies', sa.Column('manager_name', sa.String(255), nullable=True))
    op.add_column('companies', sa.Column('manager_title', sa.String(255), nullable=True))
    op.add_column('surat', sa.Column('wet_signature', sa.Boolean(), nullable=False, server_default=sa.false()))


def downgrade() -> None:
    op.drop_column('surat', 'wet_signature')
    op.drop_column('companies', 'manager_title')
    op.drop_column('companies', 'manager_name')
    op.drop_column('companies', 'director_title')
    op.drop_column('companies', 'director_name')