+
    2Æ—jv'  ã            '      ól  a € 0 t $ ^ RIHt ^ RIHtHt ^ RIHt 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	RRRR/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R.R	R/RR0R/CR1/ R!RbR RbR2RbR3R	bR4RbR"R	bR$RbR5RbR6RbR7R	bR8RbR9R	bR:R	bR;R	bR<RbR0RbR=R RR!RR4RR"R	R>RR$RRRR?R	R@RRARRBRRCR	RDRRER	R0R/RFR!RRRRGRRHR	RRRIR	RRRRRRRJR/
RKRLRRMR/RNRORPRQRRRSRRTRRURRVRRWRRXR/RYRZRR[RR\RR]RR^RR_RR`RRaR/RbRSRRTRRcRRdRReRRfRRZRR[R/Rg/ R!RbR3R	bR-RbR.R	bR$RbRRbRhRbRiRbRjRbRkR	bR8RbR9R	bR:R	bRlRbRER	bR<RbR0RbRmR!R/RnR!R/RoR!R/RpR!R//tRq]	Rr&   RRsRRtRRR/RNRORPRQRR/RRuRRvRwRR/R1RxRR/RRyR/R=RxRRzR/RFRxRR{RRR/RgR|RR}RR/RRyR//t
Rq]	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Úbudget_headzVARCHAR(255) NULLÚadministrative_approval_dateÚ administrative_approval_quantityÚlifecycle_stagezVARCHAR(80) NULLÚ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, 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   € ÷ &ñ &¨6ð &°dñ &ó    c                ó
  € V P                   P                  R 8w  d   R# \        V 4      p\        VP	                  4       4      pV P                  4       ;_uu_ 4       p\        P                  4        Fw  w  rEWB9  d   K  VP                  V4       Uu0 uF  qfR,          kK  	  ppVP                  4        F0  w  r‰W‡9  g   K  VP                  \        RV RV RV	 24      4       K2  	  Ky  	  \        P                  4        F¼  w  rEWB9  d   K  VP                  V4       Uu/ uF  qfR,          VbK  	  ppVP                  4        Ft  w  r‰VP                  V4      pRV	P                  4       9  p
Vf   K/  \        VP                  RR4      4      V
8w  g   KQ  VP                  \        RV R	V RV	 24      4       Kv  	  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  rMpWB9   g   K  WÜP                  V\        4       4      9  g   K.  VP                  \        R
V RV RV 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 `zCREATE INDEX `z` ON `z` (`z`))Údialectr‚   r   ÚsetÚget_table_namesÚbeginri   ÚitemsÚget_columnsÚexecuter   rt   ÚgetÚupperÚboolÚget_indexesru   )rx   Ú	inspectorÚexisting_tablesÚ
connectionÚtableÚcolumnsÚcolumnÚexisting_columnsÚcolumn_nameÚ
definitionÚdesired_nullableÚindexÚexisting_indexesÚ
index_names   &             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¯=©=®?Ñ'�ØÖ6Ø×&Ñ&Ü˜}¨U¨G°>À+ÀÈbÐQ[ÐP\Ð]Ó^öó ,;ñ	 <ô 8×=Ñ=Ö?‰NˆEØÔ+ÙØEN×EZÑEZÐ[`ÔEaÓbÑEa¸6 v¥°Ò 6ÑEaÐÐbØ+2¯=©=®?Ñ'�Ø)×-Ñ-¨kÓ:�Ø#.°j×6FÑ6FÓ6HÑ#HÐ ØÔ%¬$¨v¯z©z¸*ÀdÓ/KÓ*LÐP`Ö*`Ø×&Ñ&Ü˜}¨U¨GÐ3DÀ[ÀMÐQSÐT^ÐS_Ð`Óaöó	 ,;ñ	 @ñ )ô
á(�ð ×/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÷7 
‰ùò  [ùò  cùò Mùó
÷/ 
�ˆúsm   Á5I1ÂI
Â I1Â?AI1ÄI!
Ä0<I1Å1I1Æ0I1ÇI+
ÇI&Ç,I+
Ç3I1È
I1È*(I1É
I1É&I+
É+I1É1J	N))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_numberr.   )r7   Úidx_samples_tender_numberr.   )r7   Úidx_samples_procurement_case_idr   )r7   Úidx_samples_serial_nor   )re   Ú!idx_tech_eval_procurement_case_idr   )rf   Ú idx_fin_eval_procurement_case_idr   )r@   Úidx_pos_procurement_case_idr   )r_   Úidx_ps_procurement_case_idr   )r_   Úidx_ps_contract_numberr'   )rg   Ú idx_delivery_procurement_case_idr   )rh   Ú idx_payments_procurement_case_idr   )Ú__conditional_annotations__Ú
__future__r   Ú
sqlalchemyr   r   Úsqlalchemy.enginer   ri   Ú__annotations__rt   ru   rœ   )r¬   s   @r}   Ú<module>r±      s–  øðß "Ð "ç $Ý $ð Ø ðð Ø˜KØÐ,Ø Ð"5ØÐ2ØÐ*ØÐ1Ø˜[Ø˜KØ�JØÐ.ØÐ/ØÐ*Ø&¨Ø*¨JØÐ-ðð" ð Ø�Zðà˜zðð 	�{ðð 	˜ð	ð
 	�[ðð 	�Jðð 	Ð.ðð 	Ð*ðð 	˜kðð 	˜;ðð 	% kðð 	˜[ðð 	$ [ðð 	& zðð 	% kðð  	Ð-ð!ð" 	Ð-ð#ð$ 	˜ØÐ&Ø�;ñ)ð, ð Ø˜zðà�Zðð 	Ð+ðð 	�kð	ð
 	Ð+ðð 	�{ðð 	�[ðð 	Ð&ðð 	Ð$ðð 	�Kðð 	Ð-ðð 	! +ðð 	�{ðð 	˜ðð 	˜+ðð  	�;ð!ð$ Ø�ZØ˜zØÐ+Ø�{Ø˜Ø�[Ø�JØ˜kØÐ#ØÐ$Ø�kØ˜ØÐ-Ø�{Ø�;ðð" Ø˜zØÐ/ØÐ1Ø ØÐ.Ø ØÐ*Ø˜KØ�JØÐ"ðð Ø Ø&Ð(;ðð ØÐ?ØÐ4ØÐ&ØÐ&ØÐ*ØÐ*Ø˜+Ø˜+ð	ð ØÐ.ØÐ.ØÐ/ØÐ/ØÐ2ØÐ2ØÐ0ØÐ0ð	ð ØÐ&ØÐ&ØÐ*ØÐ*ØÐ,ØÐ,ØÐ.ØÐ.ð	ð ð Ø˜zðà�kðð 	Ð-ðð 	˜ð	ð
 	�[ðð 	�Jðð 	Ð*ðð 	Ð+ðð 	Ð-ðð 	˜ðð 	Ð-ðð 	! +ðð 	�{ðð 	Ð.ðð 	�{ðð  	˜+ð!ð" 	�;ð#ð& Ø˜zðð Ø˜zðð Ø˜zðð Ø˜zððq[4Ð Ð0ó [ð| Ø�ZØÐ+ØÐ*ðð
 ØÐ?ØÐ4ðð Ø˜*ØÐ$ØÐ*ðð
 Ø�ZØÐ&ØÐ+ðð
 Ø�ZØ˜kðð Ø�ZØÐ(ØÐ*ðð
 Ø�ØÐ*ØÐ&ØÐ+ð	ð;#8Ð Ð4ó #ðJ-€Ð	)ó ÷&&r   