
    JiV                     <    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)	zeadd sapras tables

Revision ID: sp01_add_sapras
Revises: hk01_no_shift_tipe
Create Date: 2026-04-14

    )opNsp01_add_saprashk01_no_shift_tipec                     t        j                  d       t        j                  dt        j                  dt        j
                         d      t        j                  dt        j
                         t        j                  dd	      d
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
                         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      d      t        j                  dt        j                  d      d      t        j                  dt        j                  d      d      t        j                  ddd             t        j                  dt        j                  dt        j
                         d      t        j                  dt        j
                         t        j                  d 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'             y )(Nz5ALTER TYPE modulenum ADD VALUE IF NOT EXISTS 'sapras'saprasidT)primary_keyspbu_idzmaster_spbu.idCASCADE)ondeleteF)nullableindextanggal)r   catatanstatus   pending)r   server_defaultuploaded_by_idzmaster_user.idzSET NULLuploaded_at)timezonereviewed_by_idreviewed_at
created_at
updated_atuq_sapras_tanggal)namesapras_item	sapras_idz	sapras.idkegiatani  foto_sebelum_urli  foto_sesudah_urlurutan0)r   executecreate_tablesaColumnInteger
ForeignKeyDateTextStringDateTimeUniqueConstraint     B/var/www/html/spbu.com/backend/alembic/versions/sp01_add_sapras.pyupgrader3      s   JJFGOO
		$

$7
		)RZZ\2==9IT]+^invz{
		)RWWY7
		)RWWY6
		(BIIbME)T
		"BJJL"--@P[e2fquv
		-d!;dK
		"BJJL"--@P[e2fquv
		-d!;dK
		,T :TJ
		,T :TJ
Iy7JK  OO
		$

$7
		+rzz|R]];QZ-[fkswx
		*biio>
		$biintD
		$biintD
		(BJJL5Mr1   c                  X    t        j                  d       t        j                  d       y )Nr   r   )r   
drop_tabler0   r1   r2   	downgrader6   0   s    MM- MM(r1   )returnN)__doc__alembicr   
sqlalchemyr'   revisiondown_revisionbranch_labels
depends_onr3   r6   r0   r1   r2   <module>r?      s0     $
>r1   