+
    DI˜js,  ã                   óê  a € 0 t $ ^ RIHt ^ RIHtHt ^ RIHt / RRR/bR/ RR	bR
RbRRbRRbRRbRRbRRbRRbRRbRRbRRbRRbRRbRR	bRRbRRbbR RR/bR!/ R"RbR#RbR$R	bR%RbR&RbRRbRRbRRbR'R	bR(R	bR)R	bR*R	bR+R	bR,RbR-R	bR.RbR/RbR0R	R1RR2R/CbR3/ R#RbR"RbR4RbR5R	bR6RbR$R	bR&RbR7RbR8RbR9R	bR:RbR;R	bR<R	bR=R	bR>RbR2RbbR?R"RR#RR6RR$R	R@RR&RRRRAR	RBRRCRRDRRER	RFRRGR	R2R/bRHR#RRRRRRIRRJR	RRRKR	RRRRRRRLR/bRMRNRROR/bRPRQRRRSRTRURRVRRWRRXRRYRRZR/bR[R\RR]RR^RR_RR`RRaRRbRRcR/bRdRURRVRReRRfRRgRRhRR\RR]R/bRi/ R#RbR5R	bR/RbR0R	bR&RbRRbRjRbRkRbRlRbRmR	bR:RbR;R	bR<R	bRnRbRGR	bR>RbR2RbbRoR#R/bRpR#R/bRqR#R/bRrR#R/btRs]	Rt&   RRuRRvRRR/RPRQRRRSRT/R!RwRRxRyRR/R3RzRR1RR{R/R?RzRR|R/RHRzRR}RRR/RiR~RRRR1RR{R/RoRzR/RpRzR/RqR~R/RrR~R//t
Rs]	R€&   RˆtR�]	R‚&   R‰tRƒ]	R„&   R… R† ltR‡# )Šé    )Úannotations)ÚinspectÚtext)ÚEngineÚusersÚfunctionality_accessz	JSON NULLÚrequisitionsÚrequisition_datez	DATE NULLÚreceived_fromzVARCHAR(160) NULLÚreceived_from_districtzVARCHAR(120) NULLÚreceived_from_rangeÚsender_nameÚsender_designationÚrequisition_itemsÚitem_descriptionz	TEXT NULLÚquantityzINT NULLÚestimated_costzDECIMAL(14,2) NULLÚprocurement_modeÚprocurement_mode_otherzVARCHAR(255) NULLÚbudget_headÚadministrative_approval_dateÚ administrative_approval_quantityÚlifecycle_stagezVARCHAR(80) NULLÚprocurement_casesÚtender_bidsÚ	serial_noÚprocurement_case_idÚtender_dateÚtender_itemsÚ	item_nameÚbid_published_dateÚbid_closed_dateÚtechnical_bid_opening_dateÚproduct_demo_dateÚtechnical_evaluation_dateÚtechnical_qualified_biddersÚfinancial_bid_opening_dateÚl1_bidder_nameÚcontract_numberÚcontract_dateÚamountÚremarksÚemdsÚemd_unique_idÚ
entry_dateÚtender_numberÚemd_formÚemd_noÚemd_dateÚissuing_branchÚbank_confirmation_dateÚexpiry_dateÚreturned_dateÚreturn_detailsÚsample_registersÚsample_itemsÚdemonstration_dateÚmakeÚmodelÚ
make_modelÚreceipt_dateÚrecipient_nameÚreturn_dateÚpurchase_ordersÚtender_reference_noÚtender_reference_dateÚprocess_initiate_dateÚunitÚgem_procurement_casesÚdelivery_delay_reasonÚdelivery_delay_document_pathÚitem_databaseÚ	item_typez(VARCHAR(80) NOT NULL DEFAULT 'Equipment'Ú	is_activezBOOLEAN NOT NULL DEFAULT TRUEÚname_enÚname_orÚitem_type_enÚitem_type_orÚdescription_enÚdescription_orÚbudget_headsÚdisplay_name_enÚdisplay_name_orÚcategory_name_enÚcategory_name_orÚexpenditure_head_enÚexpenditure_head_orÚitem_component_enÚitem_component_orÚofes_establishmentsÚdistrict_enÚdistrict_orÚrange_name_enÚrange_name_orÚperformance_securitiesÚbidder_nameÚsecurity_formÚsecurity_numberÚsecurity_dateÚwarranty_periodÚtechnical_evaluationsÚfinancial_evaluationsÚdelivery_acceptancesÚpayment_trackingzdict[str, dict[str, str]]ÚMASTER_FORMAT_COLUMNSÚ	demand_idÚrequested_byÚrequisition_idÚtitlezVARCHAR(200) NULLÚ	tender_idÚinstrument_noÚsample_descriptionÚpo_valueÚpo_idÚvendor_nameÚNULLABLE_EXISTING_COLUMNSz%tuple[tuple[str, str, int, str], ...]ÚMINIMUM_STRING_LENGTHSz tuple[tuple[str, str, str], ...]ÚINDEXESc               ó    € V ^8„  d   QhRRRR/# )é   Úenginer   ÚreturnÚNone© )Úformats   "Ú//var/www/html/proc/backend/app/db/migrations.pyÚ__annotate__r�   ñ   s   € ÷ 3ñ 3¨6ð 3°dñ 3ó    c                óH  a€ V P                   P                  R 8w  d   R# \        V 4      p\        VP	                  4       4      pV P                  4       ;_uu_ 4       p\        P                  4        Fy  w  rEWB9  d   K  VP                  V4       Uu0 uF  qfR,          kK  	  ppVP                  4        F2  w  opSV9  g   K  VP                  \        RV RS RV 24      4       K4  	  K{  	  \        P                  4        F½  w  rEWB9  d   K  VP                  V4       Uu/ uF  qfR,          VbK  	  ppVP                  4        Fu  w  opVP                  S4      pRVP                  4       9  p	Vf   K0  \        VP                  RR4      4      V	8w  g   KR  VP                  \        RV R	S RV 24      4       Kw  	  K¿  	  \         F‘  w  por¨WB9  d   K  \!        V3R
 lVP                  V4       4       R4      pV'       d   \#        VP                  R4      RR4      MRpVf   K`  Vf   Kf  Wº8  g   Kn  VP                  \        RV R	S RV 24      4       K“  	  V UUu/ uF*  pYAP%                  V4       Uu0 uF  qÌR,          kK  	  upbK,  	  ppp\&         FR  w  rNoWB9   g   K  WíP                  V\        4       4      9  g   K.  VP                  \        RV RV RS R24      4       KT  	  RRR4       R# u upi u upi u upi u uppi   + '       g   i     R# ; i)ÚmysqlNÚnamezALTER TABLE `z` ADD COLUMN `z` z	 NOT NULLÚnullableTz` MODIFY COLUMN `c              3  óF   <"  € T F  qR ,          S8X  g   K  Vx € K  	  R# 5i)r…   Nr~   )Ú.0ÚitemÚcolumn_names   & €r€   Ú	<genexpr>Ú1apply_master_format_migrations.<locals>.<genexpr>  s   øé € Ð^Ñ">˜$ÀvÅ,ÐR]ÑB]—’Ó">ùs   ƒ!—
!ÚtypeÚlengthzCREATE INDEX `z` ON `z` (`z`))Údialectr…   r   ÚsetÚget_table_namesÚbeginrk   ÚitemsÚget_columnsÚexecuter   rv   ÚgetÚupperÚboolrw   ÚnextÚgetattrÚget_indexesrx   )r{   Ú	inspectorÚexisting_tablesÚ
connectionÚtableÚcolumnsÚcolumnÚexisting_columnsÚ
definitionÚdesired_nullableÚminimum_lengthÚcurrent_lengthÚindexÚexisting_indexesÚ
index_namerŠ   s   &              @r€   Úapply_master_format_migrationsrª   ñ   s   ø€ Ø‡~�~×Ñ˜gÔ%Ùä˜“€IÜ˜)×3Ñ3Ó5Ó6€Oà	�‰�Œ˜:Ü3×9Ñ9Ö;‰NˆEØÔ+ÙØ=F×=RÑ=RÐSXÔ=YÓZÑ=Y°6 v§ Ñ=YÐÐZØ+2¯=©=®?Ñ'�˜ZØÐ&6Ö6Ø×&Ñ&Ü˜}¨U¨G°>À+ÀÈbÐQ[ÐP\Ð]Ó^öó ,;ñ	 <ô 8×=Ñ=Ö?‰NˆEØÔ+ÙØEN×EZÑEZÐ[`ÔEaÓbÑEa¸6 v¥°Ò 6ÑEaÐÐbØ+2¯=©=®?Ñ'�˜ZØ)×-Ñ-¨kÓ:�Ø#.°j×6FÑ6FÓ6HÑ#HÐ ØÔ%¬$¨v¯z©z¸*ÀdÓ/KÓ*LÐP`Ö*`Ø×&Ñ&Ü˜}¨U¨GÐ3DÀ[ÀMÐQSÐT^ÐS_Ð`Óaöó	 ,;ñ	 @÷ ?UÑ:ˆE�; ØÔ+ÙÜÜ^ )×"7Ñ"7¸Ô">Ó^ØóˆF÷ MSœW V§Z¡Z°Ó%7¸À4ÔHÐX\ˆNØÔ! nÔ&@À^ÖEdØ×"Ñ"Ü˜=¨¨Ð/@ÀÀÈRÐPZÈ|Ð\Ó]öñ ?Uñ )ô
á(�ð ×/DÑ/DÀUÔ/KÓLÑ/K e˜&—M�MÑ/KÑLÒLÙ(ð 	ñ 
÷ /6Ñ*ˆE˜{ØÖ'¨J×>RÑ>RÐSXÔZ]ÓZ_Ó>`Ö,`Ø×"Ñ"Ü˜>¨*¨°V¸E¸7À$À{ÀmÐSUÐVÓWöñ /6÷Q 
‰ùò  [ùò  cùò. Mùó
÷I 
�ˆús€   Á5LÂK;
Â!LÃALÄ!L 
Ä3=LÅ5LÆBLÈ(LÈ.LÈ6,LÉ"L

É:LÊL

ÊLÊ)LË	(LË;
LÌL

Ì
LÌL!	N))r   Úprocurement_case_noéÿ   zVARCHAR(255) NOT NULL))r   Úidx_tenders_serial_nor   )r   Úidx_tenders_procurement_case_idr   )r-   Úidx_emds_procurement_case_idr   )r-   Úidx_emds_serial_nor   )r-   Úidx_emds_tender_numberr0   )r9   Úidx_samples_tender_numberr0   )r9   Úidx_samples_procurement_case_idr   )r9   Úidx_samples_serial_nor   )rg   Ú!idx_tech_eval_procurement_case_idr   )rh   Ú idx_fin_eval_procurement_case_idr   )rB   Úidx_pos_procurement_case_idr   )ra   Úidx_ps_procurement_case_idr   )ra   Úidx_ps_contract_numberr)   )ri   Ú idx_delivery_procurement_case_idr   )rj   Ú idx_payments_procurement_case_idr   )Ú__conditional_annotations__Ú
__future__r   Ú
sqlalchemyr   r   Úsqlalchemy.enginer   rk   Ú__annotations__rv   rw   rx   rª   )r¼   s   @r€   Ú<module>rÁ      sá  øðß "Ð "ç $Ý $ð`4ØØ ðð`4ð ð Ø˜KðàÐ,ðð 	!Ð"5ðð 	Ð2ð	ð
 	Ð*ðð 	Ð1ðð 	˜[ðð 	˜Kðð 	�Jðð 	Ð.ðð 	Ð/ðð 	!Ð"5ðð 	Ð*ðð 	'¨ðð 	+¨Jðð  	Ð-ð!ð	`4ð, Ø Ð"5ðð-`4ð2 ð Ø�Zðà˜zðð 	�{ðð 	˜ð	ð
 	�[ðð 	�Jðð 	Ð.ðð 	Ð*ðð 	˜kðð 	˜;ðð 	% kðð 	˜[ðð 	$ [ðð 	& zðð 	% kðð  	Ð-ð!ð" 	Ð-ð#ð$ 	˜ØÐ&Ø�;ñ)ð3`4ð^ ð Ø˜zðà�Zðð 	Ð+ðð 	�kð	ð
 	Ð+ðð 	�{ðð 	�[ðð 	Ð&ðð 	Ð$ðð 	�Kðð 	Ð-ðð 	! +ðð 	�{ðð 	˜ðð 	˜+ðð  	�;ð!ð_`4ðB Ø�ZØ˜zØÐ+Ø�{Ø˜Ø�[Ø�JØ˜kØÐ#ØÐ$Ø�kØ˜ØÐ-Ø�{Ø�;ððC`4ðd Ø˜zØÐ/Ø Ð"5ØÐ1Ø ØÐ.Ø ØÐ*Ø˜KØ�JØÐ"ððe`4ð~ Ø Ø&Ð(;ðð`4ðF ØÐ?ØÐ4ØÐ&ØÐ&ØÐ*ØÐ*Ø˜+Ø˜+ð	ðG`4ðZ ØÐ.ØÐ.ØÐ/ØÐ/ØÐ2ØÐ2ØÐ0ØÐ0ð	ð[`4ðn ØÐ&ØÐ&ØÐ*ØÐ*ØÐ,ØÐ,ØÐ.ØÐ.ð	ðo`4ðB ð Ø˜zðà�kðð 	Ð-ðð 	˜ð	ð
 	�[ðð 	�Jðð 	Ð*ðð 	Ð+ðð 	Ð-ðð 	˜ðð 	Ð-ðð 	! +ðð 	�{ðð 	Ð.ðð 	�{ðð  	˜+ð!ð" 	�;ð#ðC`4ðh Ø˜zðði`4ðn Ø˜zððo`4ðt Ø˜zððu`4ðz Ø˜zðð{`4Ð Ð0ó `ðF Ø�ZØÐ+ØÐ*ðð
 ØÐ?ØÐ4ðð Ø˜*ØÐ$ØÐ*ðð
 Ø�ZØÐ&ØÐ+ðð
 Ø�ZØ˜kðð Ø�ZØÐ(ØÐ*ðð
 Ø�ØÐ*ØÐ&ØÐ+ð	ð Ø�Zðð Ø�Zðð Ø�ðð Ø�ððY/8Ð Ð4ó /ðbAÐ Ð=ó ð-€Ð	)ó ÷&3r‚   