
    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 rekonsiliasi_harian and rekonsiliasi_tangki tables.

Revision ID: p2f3a4b5c6d7
Revises: o1e2f3a4b5c6
Create Date: 2026-04-03
    )opNp2f3a4b5c6d7o1e2f3a4b5c6c                  ~   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	
      t        j                  dt        j                  d      d	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                         t        j                  j                         d	      t        j                  dt        j                         t        j                  j                         d	      t        j                  ddd      
       t        j                  dddg       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!d"      d	d#      t        j                  d$t        j                  d!d"      d	d#      t        j                  d%t        j                  d!d"      d	d#      t        j                  d&t        j                  d!d"      d	d#      t        j                  d't        j                  d!d"      d	d#      t        j                  d(t        j                  d!d"      d	d#      t        j                  d)t        j                  d!d"      d	d#      t        j                  d*t        j                  d!d"      d	d#      t        j                  ddd+             y ),Nrekonsiliasi_harianidT)primary_keyspbu_idzmaster_spbu.idCASCADE)ondeleteF)nullabletanggalstatus   pending)r   server_default	run_by_idzmaster_user.idzSET NULLapproved_by_id
created_at)r   r   
updated_atuq_rekonsiliasi_spbu_tanggal)nameix_rekonsiliasi_spbu_idrekonsiliasi_tangkirekonsiliasi_harian_idzrekonsiliasi_harian.id	tangki_idzmaster_spbu_tangki.idRESTRICT	stok_awal      0
penerimaanpemindahan_inpemindahan_out	penjualanstok_teoritisstok_aktuallossesuq_rekonsiliasi_tangki)r   create_tablesaColumnInteger
ForeignKeyDateStringDateTimefuncnowUniqueConstraintcreate_indexNumeric     W/var/www/html/spbu.com/backend/alembic/versions/p2f3a4b5c6d7_add_rekonsiliasi_harian.pyupgrader:      s   OO
		$

$7
		)RZZ\-- 09E 	" 			)RWWY7
		(BIIbME!*	,
		+rzz|-- 0:F	! 			"BJJL-- 0:F	! 			,bggkkm 	"
		,bggkkm 	"
Iy!?	A', OO-/DK! OO
		$

$7
		*BJJL-- 89M 	" 			+rzz|-- 7*M 	" 			+rzz"a05!$	&
		,

2q 1E!$	&
		/2::b!#4u!$	&
		"BJJr1$5!$	&
		+rzz"a05!$	&
		/2::b!#4u!$	&
		-B!2U!$	&
		(BJJr1-!$	&
4k!9	;3r8   c                  X    t        j                  d       t        j                  d       y )Nr   r   )r   
drop_tabler7   r8   r9   	downgrader=   H   s    MM'(MM'(r8   )returnN)__doc__alembicr   
sqlalchemyr+   revisiondown_revisionbranch_labels
depends_onr:   r=   r7   r8   r9   <module>rF      s1     
5p)r8   