
    i                     <    d Z ddlmZ ddlZdZdZdZdZddZ	ddZ
y)	zAdd stock_adjustment and stock_adjustment_item tables.

Revision ID: f1a2b3c4d5e6
Revises: e5f6a1b2c3d4
Create Date: 2026-04-02
    )opNf1a2b3c4d5e6e5f6a1b2c3d4c                  
   t        j                  dt        j                  dt        j                         d      t        j                  dt        j                         d      t        j                  dt        j                         d      t        j                  dt        j
                         d      t        j                  dt        j                  d	
      dd      t        j                  dt        j                         d      t        j                  dt        j                  d      d      t        j                  dt        j                         d      t        j                  dt        j                  d      d      t        j                  dt        j                         d      t        j                  dt        j                         d      t        j                  dt        j                         d      t        j                  dt        j                  d      d      t        j                  dt        j                  d      t        j                  d      d      t        j                  dt        j                  d      t        j                  d      d      t        j                  dgdgd      t        j                  dgdgd      t        j                  dgd gd!      t        j                  dgd gd!      t        j                  dgd gd!      t        j                  d      t        j                  dddd"#             t        j                  d$dddg       t        j                  d%ddg       t        j                  d&ddg       t        j                  d't        j                  dt        j                         d      t        j                  d(t        j                         d      t        j                  d)t        j                         d      t        j                  d*t        j                  d+d,-      d      t        j                  d.t        j                  d/d0-      d      t        j                  d1t        j                  d+d,-      d      t        j                  d2t        j                  d/d0-      d      t        j                  d3t        j                  d/d0-      d      t        j                  d(gd4gd      t        j                  d)gd5gd      t        j                  d             t        j                  d6d'd(g       y )7Nstock_adjustmentidF)nullablespbu_idshift_idtanggalstatus   )lengthdraft)r	   server_defaultsubmitted_by_idTsubmitted_at)timezonereviewed_by_idreviewed_atcatatan_reviewunlock_reasonrecalled_by_idrecalled_at
created_atznow())r   r	   
updated_atzmaster_spbu.idCASCADE)ondeletezmaster_spbu_shift.idRESTRICTzmaster_user.idzSET NULLuq_stock_adj_spbu_shift_tanggal)nameix_stock_adj_spbu_tanggalix_stock_adjustment_spbu_idix_stock_adjustment_shift_idstock_adjustment_itemstock_adjustment_id	tangki_iddipstick_manual_mm
      )	precisionscalevolume_manual_liter      dipstick_digital_mmvolume_digital_litervolume_final_literzstock_adjustment.idzmaster_spbu_tangki.idix_stock_adj_item_adj_id)r   create_tablesaColumnIntegerDateStringDateTimeTexttextForeignKeyConstraintPrimaryKeyConstraintUniqueConstraintcreate_indexNumeric     [/var/www/html/spbu.com/backend/alembic/versions/f1a2b3c4d5e6_add_stock_adjustment_tables.pyupgraderE      s   OO
		$

u5
		)RZZ\E:
		*bjjlU;
		)RWWY7
		(BIIR05QXY
		#RZZ\DA
		."++t"<tL
		"BJJL4@
		-d!;dK
		"BGGI=
		/2779t<
		"BJJL4@
		-d!;dK
		,T :277SZK[fjk
		,T :277SZK[fjk
.>-?)T
/E.FQ[\
!2 36F5GR\]
!1 25E4FQ[\
!1 25E4FQ[\
%
Iz9Cde/2 OO/1CiQZE[\OO13E	{SOO24FUOO
		$

u5
		'F
		+rzz|e<
		&

Rq(ITXY
		'b)JUYZ
		'b)JUYZ
		("**r*KVZ[
		&

Rq(ITXY
!6 7:O9P[de
0G/HS]^
% OO.0GJ_I`arC   c                     t        j                  dd       t        j                  d       t        j                  dd       t        j                  dd       t        j                  dd       t        j                  d       y )Nr3   r%   )
table_namer$   r   r#   r"   )r   
drop_index
drop_tablerB   rC   rD   	downgraderJ   @   s\    MM,9PQMM)*MM0=OPMM/<NOMM-:LMMM$%rC   )returnN)__doc__alembicr   
sqlalchemyr5   revisiondown_revisionbranch_labels
depends_onrE   rJ   rB   rC   rD   <module>rS      s2     
,b^&rC   