"""add unlocked_by_id + unlocked_at to laporan_shift and stock_adjustment

Revision ID: c5f6g7h8i9j0
Revises: b4e5f6g7h8i9
Create Date: 2026-04-12

"""
from alembic import op
import sqlalchemy as sa

revision = 'c5f6g7h8i9j0'
down_revision = 'b4e5f6g7h8i9'
branch_labels = None
depends_on = None


def upgrade() -> None:
    op.add_column('laporan_shift',
        sa.Column('unlocked_by_id', sa.Integer(), sa.ForeignKey('master_user.id', ondelete='SET NULL'), nullable=True)
    )
    op.add_column('laporan_shift',
        sa.Column('unlocked_at', sa.DateTime(timezone=True), nullable=True)
    )
    op.add_column('stock_adjustment',
        sa.Column('unlocked_by_id', sa.Integer(), sa.ForeignKey('master_user.id', ondelete='SET NULL'), nullable=True)
    )
    op.add_column('stock_adjustment',
        sa.Column('unlocked_at', sa.DateTime(timezone=True), nullable=True)
    )


def downgrade() -> None:
    op.drop_column('laporan_shift', 'unlocked_at')
    op.drop_column('laporan_shift', 'unlocked_by_id')
    op.drop_column('stock_adjustment', 'unlocked_at')
    op.drop_column('stock_adjustment', 'unlocked_by_id')