
    ]i	                     <    d Z ddlZddlmZ dZdZdZdZddZ	ddZ
y)	zbadd housekeeping tables

Revision ID: c5d6e7f8a9b0
Revises: b4c5d6e7f8a9
Create Date: 2026-04-10

    N)opc5d6e7f8a9b0b4c5d6e7f8a9c                     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
                         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                  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      t        j                  j                               t        j                  dt        j                  d      t        j                  j                               t        j                  d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
      t        j                  d$t        j
                         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%             y )+Nz;ALTER TYPE modulenum ADD VALUE IF NOT EXISTS 'housekeeping'housekeepingidT)primary_keyspbu_idzmaster_spbu.idCASCADE)ondeleteF)nullableindexshift_idzmaster_spbu_shift.id)r   tanggalstatus   pending)r   server_defaultuploaded_by_idzmaster_user.idzSET NULLuploaded_at)timezonereviewed_by_idreviewed_at
created_at)r   
updated_atuq_housekeeping)namehousekeeping_itemhousekeeping_idzhousekeeping.id	deskripsiurutan0housekeeping_fototipe
   foto_urli  )r   executecreate_tablesaColumnInteger
ForeignKeyDateStringDateTimefuncnowUniqueConstraintText     P/var/www/html/spbu.com/backend/alembic/versions/c5d6e7f8a9b0_add_housekeeping.pyupgrader7      s   JJLMOO
		$

$7
		)RZZ\2==9IT]+^invz{
		*bjjlBMM:P[d,epuv
		)RWWY7
		(BIIbME)T
		"BJJL"--@P[e2fquv
		-d!;dK
		"BJJL"--@P[e2fquv
		-d!;dK
		,T :277;;=Y
		,T :277;;=Y
Iz9CTU  OO
		$

$7
		#RZZ\2==AR]f3grw  @D  	E
		+rwwy59
		(BJJL5M OO
		$

$7
		#RZZ\2==AR]f3grw  @D  	E
		&"))B-%8
		*biinu=
		(BJJL5Mr5   c                      t        j                  d       t        j                  d       t        j                  d       y )Nr#   r   r   )r   
drop_tabler4   r5   r6   	downgrader:   6   s(    MM%&MM%&MM.!r5   )returnN)__doc__
sqlalchemyr)   alembicr   revisiondown_revisionbranch_labels
depends_onr7   r:   r4   r5   r6   <module>rC      s1     
"J"r5   