
    in                     <    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)	u   Rebuild penerimaan — drop old single-table structure, add header/item/foto tables.

Revision ID: i4d5e6f7a8b9
Revises: h3c4d5e6f7a8
Create Date: 2026-04-03
    )opNi4d5e6f7a8b9h3c4d5e6f7a8c                     t        j                  d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      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      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d      d      t	        j
                  dt	        j                  dd      d      t	        j
                  dt	        j                  dd      d      t	        j
                  dt	        j                  dd      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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
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      t	        j
                  d0t	        j                         d      t	        j
                  d1t	        j                  d2d3      d      t	        j
                  d4t	        j                  d5d6      d      t	        j
                  d7t	        j                  d2d3      d      t	        j
                  d8t	        j                  d5d6      d      t	        j
                  d9t	        j                  d5d6      d      t	        j                  d-gd:gd&'      t	        j                  d.gd;gd+'      t	        j                  d/gd<gd)'      t	        j                  d0gd=gd)'      t	        j                  d             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
                  dAt	        j                  dB      d      t	        j
                  dCt	        j                  dD      d      t	        j
                  d!t	        j                  d      t	        j                  d"      d#      t	        j                  d-gd:gd&'      t	        j                  d@gdEgd&'      t	        j                  d      
       t        j                   dFd?d-g       y )GNix_penerimaan_penebusan_id
penerimaan
table_nameix_penerimaan_spbu_tanggalidFnullablespbu_idpenebusan_idtanggaltgl_jam_keluar_terminalTtimezonejam_tibajam_berangkat	no_polisi   shipment_no2   nama_pengemudino_lod   density_obs      temp_obs      density_onstemp_onscatatancreated_by_id
created_atnow()server_defaultr   
updated_atmaster_spbu.idCASCADEondeletepenebusan.idRESTRICTmaster_user.idSET NULLpenerimaan_itempenerimaan_idpenebusan_item_id	produk_id	tangki_iddipstick_sebelum_mm
      volume_sebelum      dipstick_sesudah_mmvolume_sesudahvolume_diterimazpenerimaan.idzpenebusan_item.idzmaster_produk.idmaster_spbu_tangki.id ix_penerimaan_item_penerimaan_idpenerimaan_fotopenerimaan_item_idtipe   url  zpenerimaan_item.id ix_penerimaan_foto_penerimaan_id)r   
drop_index
drop_tablecreate_tablesaColumnIntegerDateDateTimeTimeStringTextNumerictextForeignKeyConstraintPrimaryKeyConstraintcreate_index     R/var/www/html/spbu.com/backend/alembic/versions/i4d5e6f7a8b9_rebuild_penerimaan.pyupgrader_      s?   MM.<HMM.<HMM, OO
		$

u5
		)RZZ\E:
		."**,? 			)RWWY7
		+R[[$-GRVW
		*bggi$7
		/2779t<
		+ryy}t<
		-2>
		"BGGI=
		'299S>D9 			-Aq!1DA
		*bjjA.>
		-Aq!1DA
		*bjjA.>
		)RWWY6
		/2::<$?
		,T :277SZK[fkl
		,T :277SZK[fkl
.>-?)T
 0>2BZX
 14D3EPZ[
%=@ OO0,I@VWOO0,@PQ OO
		$

u5
		/2::<%@
		%rzz|dC
		+rzz|e<
		+rzz|e<
		'B):UK
		"BJJr1$5F
		'B):UK
		"BJJr1$5F
		#RZZA%6G
 1O3DyY
!4 58K7LWab
0B/CjY
0G/HS]^
%%( OO68IOK\] OO
		$

u5
		/2::<%@
		&

tD
		&"))B-%8
		%3%8
		,T :277SZK[fkl
 1O3DyY
!5 69M8NYbc
% OO68IOK\]r]   c                     t        j                  dd       t        j                  d       t        j                  dd       t        j                  d       t        j                  d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
      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d      d
      t	        j
                  dt	        j                  dd      d
      t	        j
                  dt	        j                  dd      d
      t	        j
                  dt	        j                  dd      d
      t	        j
                  dt	        j                  dd      d
      t	        j
                  dt	        j                  dd      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&      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d0+      t	        j                  d	             t        j                   ddddg       t        j                   dddg       y )1NrK   rE   r	   rD   r5   r   r   r   r   Fr   r   r   r9   r   jamTno_segelr   r:   r;   r<   r=   r>   r?   r@   rA   rB   densityr   r    surat_jalan_urlrJ   r&   r'   r(   r   r)   r*   r,   r-   r.   r/   r1   r2   rC   r3   r4   )r   rL   rM   rN   rO   rP   rQ   rR   rT   rU   rW   rV   rS   rX   rY   rZ   r[   r\   r]   r^   	downgradere   c   s   MM4ARSMM#$MM4ARSMM#$MM.<HMM.<HMM, OO
		$

u5
		)RZZ\E:
		."**,?
		+rzz|e<
		)RWWY7
		%T2
		*biint<
		'B):UK
		"BJJr1$5F
		'B):UK
		"BJJr1$5F
		#RZZA%6G
		)RZZ1-=
		#RYYs^dC
		)RWWY6
		/2::<$?
		,T :277SZK[fkl
		,T :277SZK[fkl
.>-?)T
 0>2BZX
0G/HS]^
 14D3EPZ[
%14 OO0,I@VWOO0,@PQr]   )returnN)__doc__alembicr   
sqlalchemyrO   revisiondown_revisionbranch_labels
depends_onr_   re   r\   r]   r^   <module>rn      s4     
O^d'Rr]   