"""sprint0_approval_columns

Revision ID: a39af587038a
Revises: fa7094d4cea7
Create Date: 2026-07-07 14:34:46.173619

"""
from typing import Sequence, Union

from alembic import op
import sqlalchemy as sa


# revision identifiers, used by Alembic.
revision: str = 'a39af587038a'
down_revision: Union[str, None] = 'fa7094d4cea7'
branch_labels: Union[str, Sequence[str], None] = None
depends_on: Union[str, Sequence[str], None] = None


def upgrade() -> None:
    # ### commands auto generated by Alembic - please adjust! ###
    op.add_column('debit_note', sa.Column('created_by', sa.UUID(), nullable=True))
    op.add_column('debit_note', sa.Column('approved_by', sa.UUID(), nullable=True))
    op.add_column('debit_note', sa.Column('approved_at', sa.DateTime(timezone=True), nullable=True))
    op.add_column('rm_purchase_order', sa.Column('created_by', sa.UUID(), nullable=True))
    op.add_column('rm_purchase_order', sa.Column('approved_by', sa.UUID(), nullable=True))
    op.add_column('rm_purchase_order', sa.Column('approved_at', sa.DateTime(timezone=True), nullable=True))
    op.add_column('rm_receiving_log', sa.Column('created_by', sa.UUID(), nullable=True))
    op.add_column('rm_receiving_log', sa.Column('approved_by', sa.UUID(), nullable=True))
    op.add_column('rm_receiving_log', sa.Column('approved_at', sa.DateTime(timezone=True), nullable=True))
    # ### end Alembic commands ###


def downgrade() -> None:
    # ### commands auto generated by Alembic - please adjust! ###
    op.drop_column('rm_receiving_log', 'approved_at')
    op.drop_column('rm_receiving_log', 'approved_by')
    op.drop_column('rm_receiving_log', 'created_by')
    op.drop_column('rm_purchase_order', 'approved_at')
    op.drop_column('rm_purchase_order', 'approved_by')
    op.drop_column('rm_purchase_order', 'created_by')
    op.drop_column('debit_note', 'approved_at')
    op.drop_column('debit_note', 'approved_by')
    op.drop_column('debit_note', 'created_by')
    # ### end Alembic commands ###