"""remove asset lifecycle fields

Revision ID: 537d2b83a6e9
Revises: e10a3008c34f
Create Date: 2026-09-09 14:34:02.526539

"""
from typing import Sequence, Union

from alembic import op
import sqlalchemy as sa
from sqlalchemy.dialects import postgresql

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


def upgrade() -> None:
    op.drop_column('maintenance_asset', 'purchase_price')
    op.drop_column('maintenance_asset', 'purchase_date')
    op.drop_column('maintenance_asset', 'useful_life_years')
    op.drop_column('maintenance_asset', 'salvage_value')

def downgrade() -> None:
    op.add_column('maintenance_asset', sa.Column('salvage_value', sa.NUMERIC(precision=14, scale=2), autoincrement=False, nullable=True))
    op.add_column('maintenance_asset', sa.Column('useful_life_years', sa.INTEGER(), autoincrement=False, nullable=True))
    op.add_column('maintenance_asset', sa.Column('purchase_date', sa.DATE(), autoincrement=False, nullable=True))
    op.add_column('maintenance_asset', sa.Column('purchase_price', sa.NUMERIC(precision=14, scale=2), autoincrement=False, nullable=True))