U
    ŷi}                     @   s   U d Z ddlmZmZ ddlmZ ddlZddlm	Z	 dZ
eed< dZeedf ed	< dZeeee df ed
< dZeeee df ed< ddddZddddZdS )zsimplify_benefits_drop_transactions_and_balance

Revision ID: 10be32b8efd7
Revises: 9867676a4662
Create Date: 2026-03-16 12:52:48.592744

    )SequenceUnion)opN)
postgresqlZ10be32b8efd7revisionZ9867676a4662down_revisionbranch_labels
depends_on)returnc                   C   s&   t d t dd t dd d S )Nbenefit_transactionsbenefitsremaining_balancetotal_amount)r   
drop_tabledrop_column r   r   m/var/www/html/me.goteku.com/backend/alembic/versions/10be32b8efd7_simplify_benefits_drop_transactions_and_.pyupgrade   s    
r   c                   C   s6  t dtjdt ddd t dtjdt ddd t dtjdt dddtjdt dddtjd	t dddtjd
t dddtjdt dddtjdt dddtjdt dddtjdt dddtjdt	j
dddddtjdgdgdddtjd	gdgdddtjddd d S )Nr   r   F)autoincrementnullabler   r   idZ
benefit_idemployee_idtransaction_datedescriptiondebitcreditbalance
created_atT)timezonezbenefits.idZ$benefit_transactions_benefit_id_fkeyCASCADE)nameondeletezemployees.idZ%benefit_transactions_employee_id_fkeyZbenefit_transactions_pkey)r    )r   
add_columnsaColumnINTEGERcreate_tableVARCHARDATETEXTr   	TIMESTAMPForeignKeyConstraintPrimaryKeyConstraintr   r   r   r   	downgrade   s     r-   )__doc__typingr   r   alembicr   
sqlalchemyr#   Zsqlalchemy.dialectsr   r   str__annotations__r   r   r	   r   r-   r   r   r   r   <module>   s   