
    i                     D    d Z ddlmZ ddlZdZdZdZdZg dZ	d	dZ
d	dZy)
zsAdd expense_kategori and expenses tables.

Revision ID: k6f7a8b9c0d1
Revises: j5e6f7a8b9c0
Create Date: 2026-04-03
    )opNk6f7a8b9c0d1j5e6f7a8b9c0)zGaji KaryawanzATK & Administrasi
InventariszBiaya ListrikWifiMaintenance	TransportzKonsumsi AMTKeamananzOps AngkutanPPHz
Biaya Bankz	Lain-lainBPJSzInsentif Pasti Pasc                     t        j                  dt        j                  dt        j                         d      t        j                  dt        j                         t        j
                  dd      d	      t        j                  d
t        j                  d      d      t        j                  dt        j                         dd      t        j                  dt        j                         dd      t        j                  d             t        j                  dddg       t        j                  t        j                  dt        j                  dt        j                        t        j                  d
t        j                        t        j                  dt        j                        t        j                  dt        j                              t        t              D  cg c]  \  } }d || dz   d	d c}}        t        j                  dt        j                  dt        j                         d      t        j                  dt        j                         t        j
                  dd      d      t        j                  dt        j                         t        j
                  dd      d	      t        j                  dt        j                         d      t        j                  dt        j                         t        j
                  dd      d      t        j                  dt        j                          d	      t        j                  dt        j"                  dd      d      t        j                  dt        j                  d       d	      t        j                  d!t        j                         t        j
                  d"d#      d	      t        j                  d$t        j$                  d	%      t        j&                  d&      d'      t        j                  d             t        j                  d(dddg       t        j                  d)ddg       y c c}} w )*Nexpense_kategoriidF)nullablespbu_idzmaster_spbu.idCASCADE)ondeleteTnamad   urutan0)r   server_default	is_activetrueix_expense_kategori_spbu_id   )r   r   r   r   expenseslaporan_shift_idzlaporan_shift.idtanggalkategori_idzexpense_kategori.idRESTRICT
keteranganjumlah      	bukti_urli  created_by_idzmaster_user.idzSET NULL
created_at)timezoneznow())r   r   ix_expenses_spbu_id_tanggalix_expenses_laporan_shift_id)r   create_tablesaColumnInteger
ForeignKeyStringBooleanPrimaryKeyConstraintcreate_indexbulk_inserttablecolumn	enumerateKATEGORI_DEFAULTDateTextNumericDateTimetext)ir   s     L/var/www/html/spbu.com/backend/alembic/versions/k6f7a8b9c0d1_add_expenses.pyupgraderA      s   OO
		$

u5
		)RZZ\2==9IT]+^imn
		&"))C.59
		(BJJL5M
		+rzz|eFS
% OO13E	{S NN
#IIi,IIfbii(IIh

+IIk2::.		
 ""23	53WQ 41q5t	L3	5	 OO
		$

u5
		)RZZ\2==9IT]+^ino
		$bjjlBMMBT_h4itxy
		)RWWY7
		-r}}=R]g/hsxy
		,	D9
		(BJJr1->
		+ryy~=
		/2::<?OZd1eptu
		,T :277SZK[fkl
% OO1:	9?UVOO2JAS@TU'	5s   )Q+c                      t        j                  dd       t        j                  dd       t        j                  d       t        j                  dd       t        j                  d       y )Nr+   r   )
table_namer*   r   r   )r   
drop_index
drop_table     r@   	downgraderH   B   sI    MM0ZHMM/JGMM*MM/<NOMM$%rG   )returnN)__doc__alembicr   
sqlalchemyr-   revisiondown_revisionbranch_labels
depends_onr9   rA   rH   rF   rG   r@   <module>rQ      s:     
 'VT&rG   