
    k?i`                         U d Z ddlmZmZ ddlmZ ddlZdZe	e
d<   dZee	df   e
d<   dZee	ee	   df   e
d<   dZee	ee	   df   e
d	<   dd
ZddZy)z`Initial migration

Revision ID: b437aa017a0f
Revises: 
Create Date: 2025-12-15 02:01:24.777016

    )SequenceUnion)opNb437aa017a0frevisiondown_revisionbranch_labels
depends_onc                  e   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t        j
                         d      t        j                  dt        j                  ddddd      d      t        j                  dt        j                  dddd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       d!      t        j                  d"t        j                  d      d      t        j                  d             t        j                  t        j                  d#      ddgd$       t        j                  d%t        j                  dt        j                         d      t        j                  d&t        j
                         d      t        j                  d't        j                  d(d)d*d+d,      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                          d      t        j                  d2t        j                          d      t        j                  d3t        j                         d      t        j                  dt        j                  d      t        j                  d       d!      t        j                  d"t        j                  d      d      t        j                  d             t        j                  t        j                  d4      d%d-gd$       t        j                  t        j                  d5      d%dgd$       t        j                  d6t        j                  dt        j                         d      t        j                  d&t        j
                         d      t        j                  d7t        j                         d      t        j                  d8t        j
                         d      t        j                  d9t        j
                         d      t        j                  d:t        j                          d      t        j                  d3t        j                         d      t        j                  dt        j                  d      t        j                  d       d!      t        j                  d"t        j                  d      d      t        j                  d             t        j                  t        j                  d;      d6dgd$       t        j                  t        j                  d<      d6d&gd$       t        j                  d=t        j                  dt        j                         d      t        j                  d&t        j
                         d      t        j                  d7t        j                         d      t        j                  d>t        j
                         d      t        j                  d?t        j
                         d      t        j                  d@t        j                         d      t        j                  d3t        j                         d      t        j                  dt        j                  d      t        j                  d       d!      t        j                  d"t        j                  d      d      t        j                  d             t        j                  t        j                  dA      d=dgd$       t        j                  dBt        j                  dt        j                         d      t        j                  d.t        j
                         d      t        j                  d-t        j
                         d      t        j                  dCt        j
                         d      t        j                  dDt        j
                         d      t        j                  d/t        j
                         d      t        j                  d3t        j                         d      t        j                  dEt        j                         d      t        j                  dFt        j                         d      t        j                  dGt        j                         d      t        j                  dHt        j
                         d      t        j                  dt        j                  d      t        j                  d       d!      t        j                  d"t        j                  d      d      t        j                  d             t        j                  t        j                  dI      dBd-gd$       t        j                  t        j                  dJ      dBdgd$       t        j                  t        j                  dK      dBd.gd$       t        j                  dLt        j                  dt        j                         d      t        j                  dMt        j                         d      t        j                  d&t        j
                         d      t        j                  d7t        j                         d      t        j                  dNt        j                         d      t        j                  dOt        j                         d      t        j                  dPt        j                         d      t        j                  dQt        j
                         d      t        j                  dRt        j                         d      t        j                  d@t        j                         d      t        j                  d3t        j                         d      t        j                  dt        j                  d      t        j                  d       d!      t        j                  d"t        j                  d      d      t        j"                  dMgdSg      t        j                  d             t        j                  t        j                  dT      dLdgd$       t        j                  dUt        j                  dt        j                         d      t        j                  dVt        j                         d      t        j                  dt        j
                         d      t        j                  d7t        j                         d      t        j                  dWt        j                  dXdYdZd[d\d]d^d_d`	      d      t        j                  dat        j                  dbdcdddedfdg      d      t        j                  dht        j                         d      t        j                  dt        j
                         d      t        j                  d1t        j                          d      t        j                  d2t        j                          d      t        j                  dit        j                         d      t        j                  djt        j
                         d      t        j                  dkt        j
                         d      t        j                  dlt        j                         d      t        j                  dmt        j                         d      t        j                  dnt        j                          d      t        j                  dot        j                  dpdqddrds      d      t        j                  dt        j                  d      t        j                  d       d!      t        j                  d"t        j                  d      d      t        j                  dtt        j                  d      d      t        j"                  dVgdug      t        j                  d             t        j                  t        j                  dv      dUdgd$       t        j                  dwt        j                  dt        j                         d      t        j                  dxt        j                         d      t        j                  dVt        j                         d      t        j                  dyt        j                         d      t        j                  dt        j                  d      t        j                  d       d!      t        j"                  dxgdzg      t        j"                  dVgdug      t        j                  d      	       t        j                  t        j                  d{      dwdgd$       t        j                  d|t        j                  dt        j                         d      t        j                  dVt        j                         d      t        j                  dt        j
                         d      t        j                  d7t        j                         d      t        j                  d}t        j                  d~dddd_d      d      t        j                  dt        j
                         d      t        j                  dt        j
                         d      t        j                  d1t        j                          d      t        j                  d2t        j                          d      t        j                  dt        j                         d      t        j                  dt        j
                         d      t        j                  dot        j                  ddddd      d      t        j                  dt        j                         d      t        j                  dt        j                  d      t        j                  d       d!      t        j                  d"t        j                  d      d      t        j"                  dVgdug      t        j                  d             t        j                  t        j                  d      d|dgd$       t        j                  dt        j                  dt        j                         d      t        j                  dt        j                         d      t        j                  dt        j                         d      t        j                  dht        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"                  dgdg      t        j"                  dgdg      t        j                  d             t        j                  t        j                  d      ddgd$       t        j                  dt        j                  dt        j                         d      t        j                  dVt        j                         d      t        j                  dt        j
                         d      t        j                  dt        j
                         d      t        j                  dt        j
                         d      t        j                  dt        j                         d      t        j                  dt        j
                         d      t        j                  dt        j                         d      t        j                  dot        j                  ddddddd      d      t        j                  dt        j                  d      t        j                  d       d!      t        j                  d"t        j                  d      d      t        j                  dt        j                  d      d      t        j"                  dVgdug      t        j                  d             t        j                  t        j                  d      ddgd$       t        j                  t        j                  d      ddgd$       t        j                  dt        j                  dt        j                         d      t        j                  dVt        j                         d      t        j                  dt        j
                         d      t        j                  d7t        j                         d      t        j                  dWt        j                  ddddddd_d      d      t        j                  dht        j                          d      t        j                  dt        j
                         d      t        j                  dt        j                          d      t        j                  dt        j                         d      t        j                  dt        j
                         d      t        j                  d1t        j                          d      t        j                  d2t        j                          d      t        j                  dit        j                         d      t        j                  djt        j
                         d      t        j                  dkt        j
                         d      t        j                  dot        j                  dpdqddrds      d      t        j                  dt        j                  d      t        j                  d       d!      t        j                  d"t        j                  d      d      t        j                  dtt        j                  d      d      t        j"                  dVgdug      t        j                  d             t        j                  t        j                  d      ddgd$       t        j                  dt        j                  dt        j                         d      t        j                  dt        j                         d      t        j                  dt        j
                         d      t        j                  d7t        j                         d      t        j                  d@t        j                         d      t        j                  d3t        j                         d      t        j                  dt        j                  d      t        j                  d       d!      t        j                  d"t        j                  d      d      t        j"                  dgdg      t        j                  d             t        j                  t        j                  d      ddgd$       t        j                  dt        j                  dt        j                         d      t        j                  dt        j                         d      t        j                  dt        j                         d      t        j                  dt        j
                         d      t        j                  dht        j                         d      t        j                  d8t        j
                         d      t        j                  dt        j                         d      t        j                  dt        j                  d      t        j                  d       d!      t        j"                  dgdg      t        j"                  dgdg      t        j                  d             t        j                  t        j                  d      ddgd$       t        j                  dt        j                  dt        j                         d      t        j                  dt        j                         d      t        j                  dt        j                         d      t        j                  dt        j$                         d      t        j                  dt        j                          d      t        j                  dt        j                          d      t        j                  dt        j                         d      t        j                  dt        j                  d      t        j                  d       d!      t        j"                  dgdg      t        j"                  dgdg      t        j                  d             t        j                  t        j                  d      ddgd$       t        j                  dt        j                  dt        j                         d      t        j                  dVt        j                         d      t        j                  dt        j                         d      t        j                  dt        j                          d      t        j                  dt        j                         d      t        j                  dt        j                  d      t        j                  d       d!      t        j                  dt        j                  d      d      t        j                  dt        j                  d      t        j                  d       d!      t        j"                  dgdg      t        j"                  dVgdug      t        j                  d             t        j                  t        j                  dī      ddgd$       t        j                  dt        j                  dt        j                         d      t        j                  dt        j                         d      t        j                  dt        j
                         d      t        j                  dt        j                  ddddd̬      d      t        j                  dt        j
                         d      t        j                  dt        j                         d      t        j                  dt        j                         d      t        j                  dQt        j
                         d      t        j                  d@t        j                         d      t        j                  d3t        j                         d      t        j                  dt        j                  d      t        j                  d       d!      t        j                  d"t        j                  d      d      t        j"                  dgdg      t        j                  d             t        j                  t        j                  dѫ      ddgd$       t        j                  dt        j                  dt        j                         d      t        j                  dt        j                         d      t        j                  dt        j
                         d      t        j                  dt        j                         d      t        j                  d3t        j                         d      t        j                  dt        j                  d      t        j                  d       d!      t        j                  d"t        j                  d      d      t        j"                  dgdg      t        j                  d      t        j&                  dƫ             t        j                  t        j                  dԫ      ddgd$       t        j                  dt        j                  dt        j                         d      t        j                  dVt        j                         d      t        j                  dt        j                         d      t        j                  dt        j                         d      t        j                  dt        j                         d      t        j                  dt        j                  d      t        j                  d       d!      t        j                  dt        j                  d      d      t        j"                  dgdg      t        j"                  dVgdug      t        j                  d             t        j                  t        j                  d׫      ddgd$       t        j                  dt        j                  dt        j                         d      t        j                  dt        j                         d      t        j                  dVt        j                         d      t        j                  dt        j$                         d      t        j                  dt        j                         d      t        j                  dt        j                         d      t        j                  dt        j                  d      t        j                  d       d!      t        j                  dt        j                  d      d      t        j"                  dgdg      t        j"                  dVgdug      t        j                  d             t        j                  t        j                  dޫ      ddgd$       t        j                  dt        j                  dt        j                         d      t        j                  dt        j                         d      t        j                  dt        j                         d      t        j                  dt        j$                         d      t        j                  dt        j
                         d      t        j                  dt        j                         d      t        j                  d@t        j                         d      t        j                  d3t        j                         d      t        j                  dt        j                  d      t        j                  d       d!      t        j                  d"t        j                  d      d      t        j"                  dgdg      t        j                  d             t        j                  t        j                  d      ddgd$       t        j                  dt        j                  dt        j                         d      t        j                  dVt        j                         d      t        j                  dt        j                         d      t        j                  dt        j                         d      t        j                  dt        j                         d      t        j                  dt        j                  d      t        j                  d       d!      t        j                  dt        j                  d      d      t        j                  dt        j                         d      t        j"                  dgdg      t        j"                  dVgdug      t        j                  d             t        j                  t        j                  d      ddgd$       y )NeventsidF)nullabletitlecontentdate
start_hourend_hour
visio_linkTphotostateDRAFT	PUBLISHED	CANCELLED	COMPLETED
eventstate)name	frequencyONCEDAILYWEEKLYMONTHLYeventfrequency	is_publicregister_formmax_participantslocation
created_at)timezoneznow())server_defaultr   
updated_atix_events_id)uniquepartnersr   partner_typePHARMACYHEALTH_CENTERHOSPITALCLINICpartnertypeemailphonepasswordphysical_addresslatitude	longitude	is_activeix_partners_emailix_partners_idproductsdescriptiondosageform
unit_priceix_products_idix_products_namethemesiconcolororderix_themes_idusers
first_name	last_nameis_adminphone_verifiedemail_verifieddevice_tokenix_users_emailix_users_idix_users_phonediseasestheme_idsymptoms
prevention	treatment	thumbnailduration_minutesz	themes.idix_diseases_iddonation_listingsuser_idcategoryCLOTHING	FURNITUREELECTRONICSBOOKSTOYSFOODMEDICALOTHERdonationcategory	conditionNEWLIKE_NEWGOODFAIRPOORdonationconditionquantityphotoscontact_phonecontact_preferencerequires_pickupcan_deliverdelivery_radius_kmstatusACTIVESOLDEXPIREDlistingstatus
expires_atzusers.idix_donation_listings_idevent_registrationsevent_idregistration_dataz	events.idix_event_registrations_idhealth_reportsreport_typeEPIDEMICCONTAMINATIONACCIDENTSHORTAGEhealthreporttypehealth_center_name
event_datePENDINGVERIFIEDRESOLVEDREJECTEDhealthreportstatusadmin_commentix_health_reports_idpharmacy_stocks
partner_id
product_idzpartners.idzproducts.idix_pharmacy_stocks_idprescriptions	referenceprescription_filepatient_nameprescription_datedoctor_nameai_extracted_data
PROCESSINGFOUNDPARTIALLY_FOUND	NOT_FOUNDPAIDprescriptionstatussearch_completed_atix_prescriptions_idix_prescriptions_referencewaste_listingsPLASTICMETALPAPERGLASS
ELECTRONICORGANICwastecategoryunitpriceis_negotiableix_waste_listings_idchapters
disease_idzdiseases.idix_chapters_idprescription_productsprescription_idproduct_name_extractedfound_in_stockzprescriptions.idix_prescription_products_idprescription_searchesproducts_foundtotal_pricedistance_kmall_products_availableix_prescription_searches_iduser_disease_progressprogress_percentageis_completed
started_atcompleted_atlast_accessed_atix_user_disease_progress_idcapsules
chapter_idtypeVIDEOAUDIOTEXTPDFcapsuletypecontent_urltext_contentduration_secondszchapters.idix_capsules_idquizzespassing_scoreix_quizzes_iduser_chapter_progressquiz_passedix_user_chapter_progress_idquiz_attemptsquiz_idanswersscorepassedz
quizzes.idix_quiz_attempts_idquiz_questionsquestionoptionscorrect_answerexplanationix_quiz_questions_iduser_capsule_progress
capsule_idwatch_time_secondslast_position_secondszcapsules.idix_user_capsule_progress_id)r   create_tablesaColumnIntegerStringTextDateTimeEnumBooleanDateTimetextPrimaryKeyConstraintcreate_indexfFloatForeignKeyConstraintJSONUniqueConstraint     o/Users/theessential/Documents/Github/Lebenam/lebenam-backend/alembic/versions/b437aa017a0f_initial_migration.pyupgrader      s   OOHIIdBJJL51IIgryy{U3IIiU3IIfbggi%0IIlBGGI6IIj"'')e4IIlBIIK$7IIgryy{T2IIgrwww[+T`alpqIIk27767HiN^_jnoIIk2::<$7IIorwwy48II "**,>IIj"))+5IIlBKK6rwwwGWbfgIIlBKK6FD!#& OOBDD((TF5IOOJIIdBJJL51IIfbiikE2IInbggj/:x^klw|}IIgryy{U3IIgryy{T2IIj"))+6II "))+>IIj"((*t4IIk288:5IIk2::<$7IIlBKK6rwwwGWbfgIIlBKK6FD! OOBDD,-zG9TROOBDD)*JuMOOJIIdBJJL51IIfbiikE2IImRWWY6IIh		d3IIfbiikD1IIlBHHJ6IIk2::<$7IIlBKK6rwwwGWbfgIIlBKK6FD! OOBDD)*JuMOOBDD+,j6(5QOOHIIdBJJL51IIfbiikE2IImRWWY7IIfbiikD1IIgryy{T2IIgrzz|d3IIk2::<$7IIlBKK6rwwwGWbfgIIlBKK6FD! OOBDD((TF5IOOGIIdBJJL51IIgryy{U3IIgryy{T2IIlBIIK%8IIk299;7IIj"))+6IIk2::<$7IIj"**,6II

t<II

t<IInbiikD9IIlBKK6rwwwGWbfgIIlBKK6FD!  OOBDD)*GgYtLOOBDD'4&GOOBDD)*GgYtLOOJIIdBJJL51IIj"**,7IIfbiikE2IImRWWY7IIj"'')d3IIlBGGI5IIk2779t4IIk299;6II "**,>IIgrzz|d3IIk2::<$7IIlBKK6rwwwGWbfgIIlBKK6FZL;-:D!" OOBDD)*JuMOO'IIdBJJL51IIi6IIgryy{U3IImRWWY7IIj"''*k='SY[aclnu  }O  P  [`  aIIk2775*fffSfgrwxIIj"**,6IIj"))+6IIj"((*t4IIk288:5IIh	D1IIoryy{T:II"BIIK$?II=IImRZZ\D9II"BHHJ>IIh&+y_jnoIIlBKK6rwwwGWbfgIIlBKK6FIIlBKK6FYK*8D!-0 OOBDD235H4&Y^_OO)IIdBJJL51IIj"**,7IIi6II!2779t<IIlBKK6rwwwGWbfgZL;-:YK*8D!	 OOBDD457Ltf]bcOO$IIdBJJL51IIi6IIgryy{U3IImRWWY7IImRWWZ*jZahz{  GL  MII"BIIK%@IIj"))+6IIj"((*t4IIk288:5IIlBKKME:IIgryy{T2IIh	:z:ThitxyIIorwwy48IIlBKK6rwwwGWbfgIIlBKK6FYK*8D!#& OOBDD/02BTFSXYOO%IIdBJJL51IIlBJJL59IIlBJJL59IIj"**,7IIlBHHJ7IIlBKK6rwwwGWbfgIIlBKK6F\N]O>\N]O>D! OOBDD013DtfUZ[OOOIIdBJJL51IIi6IIk299;7II!299;?IInbiikD9II!2;;=4@IImRYY[48II!2779t<IIhg7H+W]_j  rF  G  RV  WIIlBKK6rwwwGWbfgIIlBKK6FII#R[[$%?$OYK*8D!  OOBDD./4&QVWOOBDD56+_cdOO$IIdBJJL51IIi6IIgryy{U3IImRWWY7IIj"'')WgwV_aho~  KP  QIIj"((*u5IIfbiikE2IIgrxxzD1IIorzz|d;IIj"))+6IIj"((*t4IIk288:5IIh	D1IIoryy{T:II"BIIK$?IIh&+y_jnoIIlBKK6rwwwGWbfgIIlBKK6FIIlBKK6FYK*8D!+. OOBDD/02BTFSXYOOJIIdBJJL51IIlBJJL59IIgryy{U3IImRWWY6IIgrzz|d3IIk2::<$7IIlBKK6rwwwGWbfgIIlBKK6F\N]O>D! OOBDD)*JuMOO+IIdBJJL51II>IIlBJJL48II&		eDIIj"**,7IIh		d3II

t<IIlBKK6rwwwGWbfg./2D1EH\N]O>D! OOBDD679PSWRXafgOO+IIdBJJL51II>IIlBJJL59II	E:IImRXXZ%8IImRXXZ$7II&

tDIIlBKK6rwwwGWbfg\N]O>./2D1EHD! OOBDD679PSWRXafgOO+IIdBJJL51IIi6IIlBJJL59II#RXXZ$?IInbjjlT:IIlBKK6rwwwGWbfgIInbkk484HII "++t"<RWWU\M]hlm\N]O>YK*8D! OOBDD679PSWRXafgOOJIIdBJJL51IIlBJJL59IIgryy{U3IIfbgggwMR]bcIImRYY[48IInbggi$7II "**,>IIk299;6IIgrzz|d3IIk2::<$7IIlBKK6rwwwGWbfgIIlBKK6F\N]O>D!  OOBDD)*JuMOOIIIdBJJL51IIlBJJL59IIgryy{U3IIorzz|d;IIk2::<$7IIlBKK6rwwwGWbfgIIlBKK6F\N]O>D!% OOBDD)9tfUKOO+IIdBJJL51IIi6IIlBJJL59IInbjjlT:IImRZZ\D9IIlBKK6rwwwGWbfgIInbkk484H\N]O>YK*8D! OOBDD679PSWRXafgOOOIIdBJJL51IIi6IIi6IIiU3IIgrzz|e4IIh

u5IIlBKK6rwwwGWbfgIInbkk485IYK,:YK*8D! OOBDD./4&QVWOO$IIdBJJL51IIi6IIj"'')e4IIiU3II		e<IImRWWY6IIgrzz|d3IIk2::<$7IIlBKK6rwwwGWbfgIIlBKK6FYK,:D! OOBDD/02BTFSXYOO+IIdBJJL51IIi6IIlBJJL59IInbjjlT:II"BJJL4@IIlBKK6rwwwGWbfgIInbkk484HII%rzz|dC\N]O>YK*8D! OOBDD679PSWRXafgr   c                  |   t        j                  t        j                  d      d       t        j                  d       t        j                  t        j                  d      d       t        j                  d       t        j                  t        j                  d      d       t        j                  d       t        j                  t        j                  d      d	       t        j                  d	       t        j                  t        j                  d
      d       t        j                  d       t        j                  t        j                  d      d       t        j                  d       t        j                  t        j                  d      d       t        j                  d       t        j                  t        j                  d      d       t        j                  d       t        j                  t        j                  d      d       t        j                  d       t        j                  t        j                  d      d       t        j                  d       t        j                  t        j                  d      d       t        j                  d       t        j                  t        j                  d      d       t        j                  t        j                  d      d       t        j                  d       t        j                  t        j                  d      d       t        j                  d       t        j                  t        j                  d      d       t        j                  d       t        j                  t        j                  d      d        t        j                  d        t        j                  t        j                  d!      d"       t        j                  d"       t        j                  t        j                  d#      d$       t        j                  d$       t        j                  t        j                  d%      d&       t        j                  t        j                  d'      d&       t        j                  t        j                  d(      d&       t        j                  d&       t        j                  t        j                  d)      d*       t        j                  d*       t        j                  t        j                  d+      d,       t        j                  t        j                  d-      d,       t        j                  d,       t        j                  t        j                  d.      d/       t        j                  t        j                  d0      d/       t        j                  d/       t        j                  t        j                  d1      d2       t        j                  d2       y )3Nr   r   )
table_namer   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r|   r{   r[   rZ   rS   rR   rI   rQ   rP   rH   rD   rC   r=   rB   r<   r-   r;   r+   r   )r   
drop_indexr   
drop_tabler   r   r   	downgrader  {  s   MM"$$45BYZMM)*MM"$$-.;KLMM"#MM"$$,-/JMM/"MM"$$45BYZMM)*MM"$$'I>MM)MM"$$'(Z@MM*MM"$$45BYZMM)*MM"$$45BYZMM)*MM"$$45BYZMM)*MM"$$'(Z@MM*MM"$$-.;KLMM"#MM"$$34QMM"$$,-/JMM/"MM"$$./<MNMM#$MM"$$-.;KLMM"#MM"$$23@UVMM'(MM"$$01>QRMM%&MM"$$'(Z@MM*MM"$$'(W=MM"$$}%':MM"$$'(W=MM'MM"$$~&8<MM(MM"$$)*zBMM"$$'(Z@MM*MM"$$'(Z@MM"$$*+
CMM*MM"$$~&8<MM(r   )returnN)__doc__typingr   r   alembicr   
sqlalchemyr   r   str__annotations__r   r	   r
   r   r  r   r   r   <module>r     su    #   # "&uS$Y &15uS(3--. 5.2
E#x}d*+ 2bhL2r   