he@SSKrSSKrSSKJr SSKJr SSKJr SSKJrJ r J r J r J r J r SSKJrJrJr SSKJrJrJr SSKJr SS KJrJr SS KJr \R:"S 5rS rS r Sr!"SS5r"g)N)datetime)settings) FieldError)Columns ExpressionsForeignKeyName IndexName StatementTable) names_digestsplit_identifier truncate_name) NOT_PROVIDED DeferrableIndex)Query)TransactionManagementErroratomic)timezonezdjango.db.backends.schemacURnUR(agUR(aURS/:XagURUR;$)zn When altering the given field, must constraints on its model from the given relation be temporarily dropped? FNT)field many_to_many primary_key to_fieldsname)relation altered_fieldrs P/var/www/html/env/lib/python3.13/site-packages/django/db/backends/base/schema.py_is_relevant_relationrsG NNE   U__%>    00c r[URRSSSSS9[R"S5S9$)NFT)forwardreverseinclude_hiddeninclude_parentsr)key)sorted_meta _get_fieldsoperator attrgettermodels r_all_related_fieldsr.(sB  !     ' r c#^^# [U4Sj[TR55U4Sj[TR555nUH2up4X44v [URUR5ShvN M4 gN 7f)Nc3N># UHn[UT5(dMUv M g7fNr).0obj old_fields r +_related_non_m2m_objects..9$ ;$S)4 C;% %c3N># UHn[UT5(dMUv M g7fr1r2)r3r4 new_fields rr6r7>r8r9)zipr.r-_related_non_m2m_objects remote_field)r5r;related_fieldsold_relnew_rels`` rr=r=5s *9??;  *9??; N++      + sA6B:B; Bc 0\rSrSrSrSrSrSrSrSr Sr S r S r S r S rS r\rSrSrSrSrSrSrSrSr\rSr\rSrSrSr\rSr Sr!Sr"Sr#Sr$\r%Sr&Sr'S r(SrS!jr)S"r*S#r+SsS%jr,S&r-S'r.S(r/StS)jr0S*r1S+r2S,r3S-r4S.r5S/r6\7S05r8S1r9S2r:S3r;S4rS7r?S8r@S9rAS:rBS;rCS<rDS=rES>rFS?rGS@rHSArIStSBjrJSCrKStSDjrLSErMStSFjrNStSGjrOSHrPSIrQSJrRSKrSSuSMjrTSvSNjrUSOrVSPrWSSSLSLSS$SS$SSSSQ. SRjrXSvSSjrYSTrZSUr[SVr\SWr]SvSXjr^SYr_SZr`S[raS\rbS]rcS^rdS_reS`rfSargSwSbjrhSxScjriSySdjrjSzSejrkSxSfjrlSgrmShrnSiroSjrpS{SkjrqStSljrrSmrsSnrtS|SojruSsSpjrvSqrwg)}BaseDatabaseSchemaEditorLz This class and its subclasses are responsible for emitting schema-changing statements to the databases - model creation/removal/alteration, field renaming, index fiddling, and so on. z'CREATE TABLE %(table)s (%(definition)s)z1ALTER TABLE %(old_table)s RENAME TO %(new_table)sz7ALTER TABLE %(table)s SET TABLESPACE %(new_tablespace)szDROP TABLE %(table)s CASCADEz:ALTER TABLE %(table)s ADD COLUMN %(column)s %(definition)sz!ALTER TABLE %(table)s %(changes)sz2ALTER COLUMN %(column)s TYPE %(type)s%(collation)sz%ALTER COLUMN %(column)s DROP NOT NULLz$ALTER COLUMN %(column)s SET NOT NULLz/ALTER COLUMN %(column)s SET DEFAULT %(default)sz$ALTER COLUMN %(column)s DROP DEFAULTz4ALTER TABLE %(table)s DROP COLUMN %(column)s CASCADEzDALTER TABLE %(table)s RENAME COLUMN %(old_column)s TO %(new_column)szFUPDATE %(table)s SET %(column)s = %(default)s WHERE %(column)s IS NULLz"UNIQUE (%(columns)s)%(deferrable)szCHECK (%(check)s)z.ALTER TABLE %(table)s DROP CONSTRAINT %(name)sz"CONSTRAINT %(name)s %(constraint)sz?ALTER TABLE %(table)s ADD CONSTRAINT %(name)s CHECK (%(check)s)zbALTER TABLE %(table)s ADD CONSTRAINT %(name)s UNIQUE%(nulls_distinct)s (%(columns)s)%(deferrable)sz|ALTER TABLE %(table)s ADD CONSTRAINT %(name)s FOREIGN KEY (%(column)s) REFERENCES %(to_table)s (%(to_column)s)%(deferrable)sNzQCREATE INDEX %(name)s ON %(table)s (%(columns)s)%(include)s%(extra)s%(condition)szaCREATE UNIQUE INDEX %(name)s ON %(table)s (%(columns)s)%(include)s%(nulls_distinct)s%(condition)sz/ALTER INDEX %(old_name)s RENAME TO %(new_name)szDROP INDEX %(name)szGALTER TABLE %(table)s ADD CONSTRAINT %(name)s PRIMARY KEY (%(columns)s)zDROP PROCEDURE %(procedure)sz)COMMENT ON TABLE %(table)s IS %(comment)sz5COMMENT ON COLUMN %(table)s.%(column)s IS %(comment)scXlX lUR(a/UlURRR=(a UUlgr1) connection collect_sql collected_sqlfeaturescan_rollback_ddlatomic_migration)selfrFrGrs r__init__!BaseDatabaseSchemaEditor.__init__s;$&   !#D  $ 8 8 I I Tfr c/UlUR(a>[URR5UlURR 5 U$r1) deferred_sqlrKrrFalias __enter__)rLs rrR"BaseDatabaseSchemaEditor.__enter__s>   !6!67DK KK ! ! # r cUc%URHnURUS5 M UR(aURR XU5 ggr1)rPexecuterKr__exit__)rLexc_type exc_value tracebacksqls rrV!BaseDatabaseSchemaEditor.__exit__sH  (( S$')  KK i @ !r c UR(dKURR(a0URRR(d [ S5e[ U5n[RSXX!S.S9 UR(aUR5RS5(aSOSnUb?URRU[[URU55-U-5 gURRX-5 gURR!5nUR#X5 SSS5 g!,(df  g=f)z:Execute the given SQL statement, with optional parameters.ziExecuting DDL statements while in a transaction on databases that can't perform a rollback is prohibited.z%s; (params %r))paramsrZ)extra;N)rGrFin_atomic_blockrIrJrstrloggerdebugrstripendswithrHappendtuplemap quote_valuecursorrU)rLrZr^endingrls rrU BaseDatabaseSchemaEditor.executes   //OO,,==,?  #h sV2P     ::<0055R3F!""))5T%5%5v!>??6I""))#,7'')Vs+*))s 2E  EcLURRRU5$r1)rFops quote_name)rLrs rrq#BaseDatabaseSchemaEditor.quote_names""--d33r c^^TRRHYnUVs/sHnTRRU5PM nnTRR TR TU55 M[ /n/nTRR GHsnTRTU5upxUcMURTRS9n U S(aUSTRU --- nURTRS9n U (aUSU -- nURU5 UR(Ga"UR(GaURRRR n URRRRURR"5R$n TR&(a7USTR&TR)U 5TR)U 5S.--- nOQTRR*R,(a,TRR TR/TUS55 UR TR)UR$5<SU<35 UR15S;dGM TRR2R5TRR UR$5n U (dGMXTRRU 5 GMv /nU(aITRR6H.nTRR UR9TT55 M0 O0URUU4SjTRR655 TR:TR)TRR 5S R=S /UQUQ755S .-nTRR>(aHTRR2RATRR>5nU(aUSU-- nUU4$s snf) z-Take a model and return its table definition.rFcheck z %s)to_table to_column_fk_%(to_table)s_%(to_column)s) AutoField BigAutoFieldSmallAutoFieldc3H># UHnURTT5v M g7fr1)constraint_sql)r3 constraintr-rLs rr65BaseDatabaseSchemaEditor.table_sql..s(#"9J))%66"9s", c3J# UHnU(dM [U5v M g7fr1)rc)r3 statements rr6rs"$!AII!As ##)table definition)!r(unique_together get_fieldrPrh_create_unique_sql local_fields column_sql db_parametersrFsql_check_constraintdb_type_suffixextendr> db_constraintr-db_table field_namecolumnsql_create_inline_fkrqrIsupports_foreign_keys_create_fk_sqlget_internal_typerp autoinc_sql constraints create_sqlsql_create_tablejoin db_tablespacetablespace_sql)rLr- field_namesrfields column_sqlsr^r extra_params db_paramscol_type_suffixrwrxrconstraint_sqlsrrZrs`` r table_sql"BaseDatabaseSchemaEditor.table_sqls!;;66K@KL uekk++E2 FL    $ $T%<%)>ud)KL6  " "#"'++"9"9# ##__U[[%9%9:))$!A;!A!A$'   ;; $ $!__00?? ))Ns^++F{oMs%Qc## Uv URS5=n(aURU5v URRR(a.UR (aUR UR 5v URnUR[La-URU5upSU 3v URU 5 SnU=(a< URU5(+=(a U=(a URU5(+nU(axURU5n U bdSURU5-n URRR (aXR#U 5-v OU v UR%U 5 UR&(a8UR((d'URRR*(aSnUR,(a)UR/U5upURU5 U v O5U(dSv O)URRR0(dSv UR((aSv OUR2(aSv UR4=(d UR6R4nU(a_URRR8(a9UR2(a'URR:R=USS 9v gggg7f) N collationzDEFAULT FTzNOT NULLNULLz PRIMARY KEYUNIQUE)inline)get _collate_sqlrFrIsupports_comments_inline db_comment _comment_sqlnull db_defaultrdb_default_sqlr skip_defaultskip_default_on_altereffective_default_column_default_sqlrequires_literal_defaultsprepare_defaultrhempty_strings_allowedr!interprets_empty_strings_as_nulls generated_column_generated_sqlimplied_column_nulluniquerr(supports_tablespacesrpr)rLcolumn_db_typer^r-rfield_db_paramsinclude_defaultrr default_sqldefault_params default_valuecolumn_default generated_sqlgenerated_params tablespaces r_iter_column_sql)BaseDatabaseSchemaEditor._iter_column_sql/sQ'++K8 89 8##I. . ?? # # < <AQAQ##E$4$45 5zz   < /*.*=*=e*D 'K[M* * MM. )#O  =%%e,, = ;$44U; <   2259M(!+d.F.Fu.M!M??++EE)+?+? +NNN((MM-0  ' '%%((JJD ??.2.H.H.O +M MM* +  ))==L     \\N((EEKK,E,E ((== //%%44Z4M M> sLLc URURS9nUSnUcg/nSRURUUUUUU55U4$)zn Return the column definition for a field. The field must already have had set_attributes_from_name() called. rttypeNNrv)rrFrr)rLr-rrrrr^s rr#BaseDatabaseSchemaEditor.column_sqlrsn  ---I(0  ! HH%%"##     r cg)zi Some backends don't accept default values for certain columns types (i.e. MySQL longtext and longblob). Fr\rLrs rr%BaseDatabaseSchemaEditor.skip_default r cg)z Some backends don't accept default values for certain columns types (i.e. MySQL longtext and longblob) in the ALTER COLUMN statement. Fr\rs rr.BaseDatabaseSchemaEditor.skip_default_on_alterrr c[S5e)zE Only used for backends which have requires_literal_defaults feature zsubclasses of BaseDatabaseSchemaEditor for backends which have requires_literal_defaults must provide a prepare_default() methodNotImplementedErrorrLvalues rr(BaseDatabaseSchemaEditor.prepare_defaults" P  r cg)zx Return the SQL to use in a DEFAULT clause. The resulting string should contain a '%s' placeholder for a default value. %sr\rs rr,BaseDatabaseSchemaEditor._column_default_sqls r cv^SSKJn URn[X25(aTR U5OSn[ UR S9nURTRS9nURU5upxTRRR(aU[U4SjU55-n/nXG-U4$)z;Return the sql and params for the field's database default.r)Valuez(%s)r,rtc3F># UHnTRU5v M g7fr1)rr3prLs rr6:BaseDatabaseSchemaEditor.db_default_sql..s I&Q!5!5a!8!8&!) django.db.models.expressionsr_db_default_expression isinstancerrr- get_compilerrFcompilerIrri) rLrrrrZquerycompilerrr^s ` rr'BaseDatabaseSchemaEditor.db_default_sqls611 /9*/L/LD $ $U +RX EKK(%%%A&..z: ?? # # = = 5 I& II IKF &((r c^URTR5up#UR(aSOSnTRRR(aU[ U4SjU55-nSnSUSU3U4$)z3Return the SQL to use in a GENERATED ALWAYS clause.STOREDVIRTUALc3F># UHnTRU5v M g7fr1rkrs rr6ABaseDatabaseSchemaEditor._column_generated_sql..s!3XQWAD4D4DQ4G4GQWrr\zGENERATED ALWAYS AS (z) )rrF db_persistrIrri)rLrexpression_sqlr^persistency_sqls` rr.BaseDatabaseSchemaEditor._column_generated_sqlsq!&!4!4T__!E&+&6&6(I ?? # # = =+e3XQW3X.XXNF&~&6b8IJFRRr cNUR5(aUR5nU$UR(aSnU$UR(d?UR(a.UR (aUR 5S:XaSnU$SnU$[USS5(d[USS5(arUR 5nUS:Xa[R"5nU$[R"5nUS:XaUR5nU$US :XaUR5nU$SnU$) N BinaryFieldr raauto_nowF auto_now_add DateTimeField DateField TimeField) has_default get_defaultrrblankrrgetattrrnowrdatetime)rdefault internal_types r_effective_default+BaseDatabaseSchemaEditor._effective_defaults     '')G('__G$# 0K0K&&(M9UJ . .'%QV2W2W!335M/",,.#,,. K/%llnG  #k1%llnGGr cXURURU5UR5$)z2Return a field's effective database default value.)get_db_prep_saver rFrs rr*BaseDatabaseSchemaEditor.effective_defaults$%%d&=&=e&DdooVVr c[5e)a( Return a quoted version of the value so it's safe to use in an SQL string. This is not safe against injection from user code; it is intended only for use in making SQL scripts or preparing default values for particularly tricky backends (defaults are not user-defined, though, so this is safe). rrs rrk$BaseDatabaseSchemaEditor.quote_values "##r c URU5up#URX#=(d S5 URRR(aUR R (a'URUSUR R 5 URRR(dwUR RH]nUR(dMURURS9nUSnUR"URXXdR56 M_ URRURU55 UR R HYnUR"R$R R&(dM4UR)UR"R$5 M[ g)zZ Create a table and any accompanying indexes or unique constraints for the given `model`. Nrtr)rrUrFrIsupports_commentsr(db_table_commentalter_db_table_commentrrrr_alter_column_comment_sqlrPr_model_indexes_sqllocal_many_to_manyr>through auto_created create_model)rLr-rZr^rr field_types rr%BaseDatabaseSchemaEditor.create_modelsQ nnU+  S.D) ?? # # 5 5{{++++E49U9UV??++DD"[[55E'''*/*=*='++>+&5V%<  !;; %j:J:J 6   !8!8!?@[[33E!!))//<<<!!%"4"4"<"<=4r cdURRHYnURRRR(dM4UR URR5 M[ UR URSURURR50-5 [UR5Han[U[5(dMURURR5(dMFURRU5 Mc g)z!Delete a model from the database.rN)r(rr>rr delete_modelrUsql_delete_tablerqrlistrPrr references_tableremove)rLr-rrZs rr%BaseDatabaseSchemaEditor.delete_models[[33E!!))//<<<!!%"4"4"<"<=4  ! !)=)=>  ))*C#y))c.B.B $$//!!((- +r cUR(a&URRR(dgUR UR X5SS9 g)zAdd an index on a model.Nr^)contains_expressionsrFrIsupports_expression_indexesrUrrLr-indexs r add_index"BaseDatabaseSchemaEditor.add_index)s@  & &OO,,HH U%%e24 @r cUR(a&URRR(dgUR UR X55 g)zRemove an index from a model.N)r%rFrIr&rU remove_sqlr's r remove_index%BaseDatabaseSchemaEditor.remove_index4s:  & &OO,,HH U%%e23r cURRR(a5URUR XR UR 5SS9 gUR X5 URX5 g)Nr$)rFrIcan_rename_indexrU_rename_index_sqlrr-r))rLr- old_index new_indexs r rename_index%BaseDatabaseSchemaEditor.rename_index=s] ?? # # 4 4 LL&&unninnM     e / NN5 ,r cVURX5nU(aURUSS9 gg)zAdd a constraint to a model.Nr$)rrUrLr-rrZs radd_constraint'BaseDatabaseSchemaEditor.add_constraintGs,##E0  LLTL * r cXURX5nU(aURU5 gg)z!Remove a constraint from a model.N)r,rUr7s rremove_constraint*BaseDatabaseSchemaEditor.remove_constraintOs&##E0  LL  r cUVs1sHn[U5iM nnUVs1sHn[U5iM nnURU5H$nURUUSSS.UR5 M& URU5HMnUVs/sHoRR U5PM nnUR URX55 MO gs snfs snfs snf)z Deal with a model changing its unique_together. The input unique_togethers must be doubly-nested, not the single-nested ["foo", "bar"] format. TF)rrN)ri difference_delete_composed_indexsql_delete_uniquer(rrUr) rLr-old_unique_togethernew_unique_togetherroldsnewsrrs ralter_unique_together.BaseDatabaseSchemaEditor.alter_unique_togetherUs -@@,?&f ,?@,?@,?&f ,?@ood+F  ' '6&&  , ??40K@KL ukk++E2 FL LL00? @1A@MsCC$Cc UVs1sHn[U5iM nnUVs1sHn[U5iM nnURU5H$nURUUSSS.UR5 M& URU5HLnUVs/sHoRR U5PM nnUR URXSS95 MN gs snfs snfs snf)z Deal with a model changing its index_together. The input index_togethers must be doubly-nested, not the single-nested ["foo", "bar"] format. TF)r(r_idx)rsuffixN)rir>r?sql_delete_indexr(rrU_create_index_sql) rLr-old_index_togethernew_index_togetherrrCrDrrs ralter_index_together-BaseDatabaseSchemaEditor.alter_index_togetherjs -??,>&f ,>?,>?,>&f ,>?ood+F  ' '%0%%  , ??40K@KL ukk++E2 FL LL//V/T U1@?MsCC$Cc PURRVs1sHoURiM nnURRVs1sHoURiM nnUVs/sH'oRR U5R PM) n nUR "UU 4SXg-0UD6n URS5SLabU (a[URRR(a6[URURRU SS95n X;aU /n [U 5S:waD[S[U 5<SURR<S S R!U 5<S 35eUR#UR%XAU S 55 gs snfs snfs snf) NexcluderTFquoteFound wrong number (z) of constraints for (r)r)r(rrindexesrr_constraint_namesrrFrI*allows_multiple_constraints_on_same_fieldsrc_unique_constraint_namerlen ValueErrorrrU_delete_constraint_sql) rLr-rconstraint_kwargsrZrmeta_constraint_namesmeta_index_namesrcolumnsconstraint_names default_names rr?/BaseDatabaseSchemaEditor._delete_composed_indexs.3kk.E.E! .E OO.E ! ?Dkk>Q>QR>Q OO>QRDJKF5;;((/66FK11   *<     ! !( +t 3 ((SS,,U[[-A-A7RW,XL/$0>  A %()KK((IIg&   T00=Ma=PQR?! SKsFF#.F#cX#:XdGURRR(a#UR5UR5:XagUR UR UR U5UR U5S.-5 URH+n[U[5(dMURX#5 M- g)z#Rename the table a model points to.N) old_table new_table) rFrIignores_table_name_caselowerrUsql_rename_tablerqrPrr rename_table_references)rLr- old_db_table new_db_tablerZs ralter_db_table'BaseDatabaseSchemaEditor.alter_db_tables  ' OO $ $ < <""$ (:(:(<<   ! !!__\:!__\:  $$C#y))++LG%r c,UR(aURRR(a]UR URUR UR R5URU=(d S5S.-5 ggg)Nra)rcomment) sql_alter_table_commentrFrIrrUrqr(rrk)rLr-old_db_table_commentnew_db_table_comments rr/BaseDatabaseSchemaEditor.alter_db_table_commentso  ' 'DOO,D,D,V,V LL,,!__U[[-A-AB#//0D0JK -W 'r cURURURURR5URU5URU5S.-5 g)z)Move a model's table between tablespaces.)rold_tablespacenew_tablespaceN)rUsql_retablespace_tablerqr(r)rLr-old_db_tablespacenew_db_tablespaces ralter_db_tablespace,BaseDatabaseSchemaEditor.alter_db_tablespacesQ  ' ')=)=>"&//2C"D"&//2C"D  r c  UR(aTURRRR(a%UR URR5$UR XSS9up4UcgURURS9=n(aUSU3- nURURS9nUS(aUSURU--- nUR(GaURRR(GaUR(GaxSnUR(Ga9URRRR nURRRR#URR$5R&n [)URR 5upUSURUR+XU5U (aSUR-U 5-OS UR-UR&5UR-U5UR-U 5URR.R15S .--- nO+UR2R5UR7XU55 UR8UR-URR 5UR-UR&5US .-n UR;X=(d S5 UR<[>LaURAU5(dlURCU5bZUREUSUSS 9upURFUR-URR 5U S .-n UR;X5 URH(axURRRJ(aSURRRL(d.USnUR:"UROXXRH56 UR2RQURSX55 URRRT(aURRW5 gg)zw Create a field on a model. Usually involves adding a column, but may involve adding a table instead (for M2M fields). T)rNrtrvruryz%s.ra)r namespacerrwrx deferrable)rrrdroprchangesr),rr>rr(rrrrrFrrrIrrsql_create_column_inline_fkr-rrrrr _fk_constraint_namerqrpdeferrable_sqlrPrhrsql_create_columnrUrrrr_alter_column_default_sqlsql_alter_columnrrrrr_field_indexes_sqlconnection_persists_old_columnsclose)rLr-rrr^rrconstraint_suffixrwrxr_rZ changes_sqlrs r add_field"BaseDatabaseSchemaEditor.add_fields   %"4"4"<"<"B"B"O"O$$U%7%7%?%?@ @!__U4_P   #22doo2N N? N Ao./ /J''4??'C W  # 9 9I EE EJ    ((>>>### @ /// --3399BB!..44::DD&&11& 0 0D0DE cD$D$D 44UCTU>G ::R"ooell; $ 9!%!;"&//"5"5"D"D"F H %   !!((''6GH$$__U[[%9%9:ooell3$(   S.D)    ,..u55&&u-9"&"@"@tU#A# K'')=)=>&+C LL %   ((::OO,,EE"6*J LL//*.>.>    !8!8!FG ?? # # C C OO ! ! # Dr cUR(aTURRRR(a%UR URR5$UR URS9ScgUR(aDURXR/SS9nUH#nURURX55 M% URURURR5URUR5S.-nURU5 URRR (aURR#5 [%UR&5Hln[)U[*5(dMUR-URRUR5(dMQUR&R/U5 Mn g)zm Remove a field from a model. Usually involves deleting a column, but for M2Ms may involve deleting a table. rtrNT foreign_key)rr)rr>rr(rrrrFrYrrU_delete_fk_sqlsql_delete_columnrqrrIrrrrPrr references_columnr!)rLr-rfk_namesfk_namerZs r remove_field%BaseDatabaseSchemaEditor.remove_field!su   %"4"4"<"<"B"B"O"O$$U%7%7%?%?@ @   $//  :6 B J    --ell^QU-VH# T00@A$$$__U[[%9%9:ooell3(   S ?? # # C C OO ! ! #))*C#y))c.C.C $$ell//!!((- +r c URX#5(dgURURS9nUSnURURS9nUSnSn Uc URbUc!URc[ SU<SU<S35eUcUcURR (aURR (apURR R R(aAURR R R(aURXX45$UcUcURR (azURR (a_URR R R(d0URR R R(dgUbUc[ SU<SU<S35eURUR:wd+UR(aURUR:waS n OLUR(a;URUR5n URUR5n X:gn U (a[ S US 35eURUUUUUUUU5 g![a S n N=f=f) z Allow a field's type, uniqueness, nullability, default, column, constraints, etc. to be modified. `old_field` is required to compute the necessary changes. If `strict` is True, raise errors if the old column does not match `old_field` precisely. NrtrFzCannot alter field z into zT - they do not properly define db_type (are you using a badly-written custom field?)zr - they are not compatible types (you cannot alter to or from M2M fields, or add or remove through= on M2M fields)Tz7Modifying GeneratedFields is not supported - the field z6 must be removed and re-added with the new definition.)_field_should_be_alteredrrFr>r]rr(r_alter_many_to_manyrrrr _alter_field) rLr-r5r;strict old_db_paramsold_type new_db_paramsnew_typemodifying_generated_field old_field_sql new_field_sqls r alter_field$BaseDatabaseSchemaEditor.alter_fieldAsy,,YBB !//4??/K  (!//4??/K  ($)!  !7!7!?  !7!7!?i)    &&..**22**2288EE**2288EE++EiP P   &&..**22!..66<<II!..66<<II   !1.7 C   I$7$7 7   I$8$8I?$F F  sA AAc  [5n URRR(aUR(aUR (aUR UUS1S9(aURXR/SS9n U(aM[U 5S:wa>[S[U 5<SURR<SUR<35eU H?n U RUR45 URURX55 MA UR (aUR (aUR#X#5(aURR$V s1sHoR&iM n n URUUR/SS U S 9nU(aM[U5S:wa>[S[U5<S URR<SUR<35eUH#nURUR)X55 M% UR+S 5nUR+S 5nURRR=(a\ UR,=(a UR,=(d UR =(a UR =(a XE:g=(d UU:gnU(ay[/X#5HjunnURUR0UR2R/SS9nUH.n URURUR0U 55 M0 Ml UR4(aUR (dUR4(aUR (aURR6Vs1sHnUR&iM nnURUUR/S[8R:US 9nUH$nURUR=UU55 M& UR?X&5nUR?X75nUU:waU(aURR$V s1sHoR&iM n n URUUR/SU S9nU(aM[U5S:wa>[S[U5<SURR<SUR<35eUH#nURURAX55 M% URUR:waURURCURRX#U55 URDHUn[GU[H5(dMURKURRURUR5 MW /n/n/nURMURS9n URMURS9n!XE:wdKU U!:wdEUU:wd?URRRN(aSURPURP:wa9URSXX5UU5un"n#URUU"5 URWU#5 URX[ZLaOURX[ZLdURXURX:wa!URUUR]XU55 O3URX[ZLa URUUR]XUSS95 S n$UR^(aUR^(dwURX[ZLadURaU5n%URaU5n&URcU5(d,U%U&:wa&U&b#Sn$URUUReXU55 UR^UR^:wa*URgXU5n"U"(aURUU"5 URi5=(d URX[ZL=(a$ UR^=(a UR^(+n'U(dU(GaU'(dUU- nURRRj(a9U(a2[m[oU65unn(SRqU5[sU(/54/nUHKunn(URURtURwURR5US.-U(5 MM U'(aURX[ZLaSn)W&/n(OURyU5un)n(URURzURwURR5URwUR5U)S.-U(5 UHKunn(URURtURwURR5US.-U(5 MM U(aUHunn(URUU(5 M UR,(a"UR,(dUR}X5 URX#5(a!URURX/55 UR4(aUR (aAUR4(a0UR (dURURX/S95 /n*U(aU*RW[/X#55 UR#X#5(a:URURX55 U*RW[/X#55 U*GHun+nUR2RURS9n,U,Sn-U,R+S 5n.U+R2RURS9n/U/R+S 5n0URSUR0U+R2UR2U-U0U.5un"n#URURtURwUR0RR5U"SS.-U"S5 U#Hunn(URUU(5 M GM! URRR(alUR(a[U (d"UR(aUR (d2UR (a!URURXS55 U(a_U*HYun1n2U2R2R (dM#URURU2R0U2R2S55 M[ UU:wa[U(aTURURRUR/SS9nURURXUS55 U$(a[UReXUSS9un3n(URtURwURR5U3S.-nURUU(5 URRR(aURR5 ggs sn fs snfs sn f)z3Perform a "physical" (non-ManyToMany) field update.r)ignoreTrrTrUz!) of foreign key constraints for .F)rrrQz) of unique constraints for r)r(type_rQ)rurQz) of check constraints for rtrNrrr)rrrrrrry_fk_checkrIru)IsetrFrIrr>rrrYrr\r]r(raddrUrr_field_became_primary_keyrr_delete_unique_sqlrrr= related_modelrdb_indexrXrrI_delete_index_sqlr_delete_check_sql_rename_field_sqlrPrr rename_column_referencesrrr_alter_column_type_sqlrhrrr"_alter_column_database_default_sqlrrrr_alter_column_null_sqlrsupports_combined_altersrir<rsumrrqrsql_update_with_default_delete_primary_key_unique_should_be_addedrrK_create_primary_key_sqlrr_create_index_name_create_check_sqlrr)4rLr-r5r;rrrrr fks_droppedrrrr`rcconstraint_name old_collation new_collationdrop_foreign_keys_old_relrA rel_fk_namesr(ra index_names index_name old_db_check new_db_checkrZactions null_actions post_actionsold_type_suffixnew_type_suffixfragment other_actionsneeds_database_default old_default new_defaultfour_way_default_alterationr^rrels_to_updater@ rel_db_paramsrel_type rel_collationold_rel_db_paramsold_rel_collationrrelrs4 rr%BaseDatabaseSchemaEditor._alter_fieldsJ e OO $ $ : :&&''--$~. --(()t.H#h-1, H  ,,!(( $!1!1 34 T00@A$     D$B$B9$X$X38++2I2I%2IJ2I "% $55!!"!- 6  #./14 ,- ,,!(( $4 T44ULM$4&))+6 %))+6 OO $ $ : : M&&@9+@+@;$$9)9)9 M &KM],J  &>i%S!'#55))GMM,@,@+At 6   ,GLL!4!4W5J5JG!TU , &T"   $$''9+;+;9> 8K8KL8Ku 8K L00!!"ll( 1K*  T33E:FG * ++IE ++IE < 'L27++2I2I%2IJ2I "% $55!!"- 6   #./14 ,- ,,!(( $4 T33EKL$4   y// / LL&&KK(()  ((c9--00 ,,i.>.> @P@P)   #22doo2N#22doo2N  /1 -((::((I,@,@@'+&A&A)}m' #Hm NN8 $    .   | 3$$ 4''9+?+??;;EiX ! ! 5 NN77id8 "' NNNN$$ 400;K00;K..y99;.+)-&225YO >>Y^^ +225YOH##H-  ! ! # Oy';';<'O'6~~4inn"4 $ l.<'''@@W#CM2 V IIcNCO<=& V ))!%1E1E!F#&   '+''<7"&K)]F*.*=*=i*H'K 00!%1E1E!F"&//)2B2B"C#. $0KCLL--%)__U[[5I5I%J'*  $0 + V S&) ,  )>)>  $ $U 3  ' ' = = LL00 D E##y'7'7""$$ LL//k/J K   ! !":9"P Q  ) )) ? ? LL55eG H  ! !":9"P Q . GW#MM774??7SM$V,H)--k:M ' ; ;t ; W  1 5 5k B &*&A&A%%  ! ' #Hm LL%%!__W-B-B-H-H-Q-QR'{    - V S&) --!/4 OO $ $ : :&&9#9#9AXAX'' LL##E6VW  (399***LL++C,=,=syy%P) < 'L"55 $$y'7'7&86O LL&&u}W?UV  ""&"@"@)$#A# K'')=)=>&+C LLf % ?? # # C C OO ! ! # DK %t M&%s-y7 y<zc@URRR(aUR(agUR URS9nUR (a UR O URnUURUR5USS.-/4$)z Hook to specialize column null alteration. Return a (sql, params) fragment to set a column to null or non-null as required by new_field, or None if no changes are required. Nrtr)rr) rFrIrrrrsql_alter_column_nullsql_alter_column_not_nullrqr)rLr-r5r;rrZs rr/BaseDatabaseSchemaEditor._alter_column_null_sqls OO $ $ F F// %33t3OM>>**33  "ooi.>.>?)&1   r cURU5nURU5nU/nU(a/nO8URRR(aUR U5n/nUR URS9nU(a+UR(a URn OURn O URn U URUR5USUS.-U4$)z Hook to specialize column default alteration. Return a (sql, params) fragment to add or drop (depending on the drop argument) a default to new_field's column. rtrrrr) rrrFrIrrrr sql_alter_column_no_default_nullsql_alter_column_no_defaultsql_alter_column_defaultrqr) rLr-r5r;rrrr^rrZs rr2BaseDatabaseSchemaEditor._alter_column_default_sql0s,,Y7 **95 F __ % % ? ?**;7GF!//4??/K ~~;;66//C //)*:*:;%f-"    r cU(aURnSn/nOURnURU5upgURURS9nUUR UR 5USUS.-U4$)z Hook to specialize column database default alteration. Return a (sql, params) fragment to add or drop (depending on the drop argument) a default to new_field's column. rartrr)rrrrrFrqr) rLr-r5r;rrZrr^rs rr;BaseDatabaseSchemaEditor._alter_column_database_default_sqlVs 22CKF//C"&"5"5i"@ K!//4??/K //)*:*:;%f-&    r c</nURXeURR5=n(aSU3nOSnSn URRR (aUR (d}URUR:wa7URXXCR5upU (aURX45 UR(aURUR5n URURUR5UUU S.-/4U4$)a\ Hook to specialize column type alteration for different backends, for cases when a creation type is different to an alteration type (e.g. SERIAL in PostgreSQL, PostGIS fields). Return a 2-tuple of: an SQL fragment of (sql, params) to insert into an ALTER TABLE statement and a list of extra (sql, params) tuples to run once the field is altered. rvra)rrrrr)rr(rrFrIrrrrrhrsql_alter_column_typerqr) rLr-r5r;rrrr collate_sql comment_sqlrZr^s rr/BaseDatabaseSchemaEditor._alter_column_type_sqlrs ++ %++*>*>  ; k]+KK ?? # # 5 5i>T>T##y';';;#<<h0D0D !((#7##"// 0D0DE **"ooi.>.>?$!,*     r cURURURR5URUR5UR U5S.-/4$)N)rrrr)sql_alter_column_commentrqr(rrr)rLr-r;rnew_db_comments rr2BaseDatabaseSchemaEditor._alter_column_comment_sqlsZ  ) ))=)=>//)*:*:;,,^<    r c6URU=(d S5$)Nrar)rLrrs rr%BaseDatabaseSchemaEditor._comment_sqls 2..r cURRRRURRRR:wawUR URRURRRRURRRR5 UR URRURRRR UR55URRRR UR555 UR URRURRRR UR55URRRR UR555 g)z*Alter M2Ms to repoint their to= endpoints.N) r>rr(rrorrm2m_reverse_field_namem2m_field_name)rLr-r5r;rs rr,BaseDatabaseSchemaEditor._alter_many_to_manys  " " * * 0 0 9 9%%--33<< =   &&..&&..44==&&..44==    " " * *  " " * * 0 0 : :002   " " * * 0 0 : :002     " " * *  " " * * 0 0 : :9;S;S;U V  " " * * 0 0 : :9;S;S;U V  r rac[U5upA[U/UQ7SS06<U<3nURRR 5=(d SnU<SSR U5<SU<3n[ U5U::aU$[ U5US- :aUSUS-nU[ U5- S-S- nUSU<SSR U5SU<SU<3nUS S:XdUS R5(aS USS -nU$) z Generate a unique name for an index/unique constraint. The name is divided into 3 parts: the table name, the column names, and a unique digest and suffix. lengthrNrTrzD%s)r r rFrpmax_name_lengthrr\isdigit) rL table_name column_namesrIrhash_suffix_part max_lengthr other_lengths rr+BaseDatabaseSchemaEditor._create_index_names)4   =l =1 =  __((88:Ac #-sxx /EGWX z?j (   :> 1/0A*/B "S)9%::q@1D } % HH\ "=L 1   a=C :a=#8#8#:#:CR0Jr ctUc[U5S:Xa$USR(aUSRnOW[R(a[RnO1URR(aURRnUb(SUR R RU5-$g)NrTrrvra)r\rrDEFAULT_INDEX_TABLESPACEr(rFrpr)rLr-rrs r_get_index_tablespace_sql2BaseDatabaseSchemaEditor._get_index_tablespace_sqls  6{aF1I$;$; &q 7 7 22 ( A A ** % 9 9  $,,;;MJJ Jr cU(aSU-$g)Nz WHERE rar\)rL conditions r_index_condition_sql-BaseDatabaseSchemaEditor._index_condition_sqls y( (r cU(a%URRR(dg[S[ UR R X R5S9$)Nraz INCLUDE (%(columns)s))rb)rFrIsupports_covering_indexesr rr(rrq)rLr-rbs r_index_include_sql+BaseDatabaseSchemaEditor._index_include_sqlsBdoo66PP $EKK00'??K  r ) rrrIusingr col_suffixesrZ opclassesrinclude expressionsc 2^^U=(d /nU =(d /n [USS9RTRS9n TRXUS9nUVs/sHoRPM nnU=(d TR nUR RnUU4Sjn[U[UTR5[UUUU5UU(aTRUUXy5O[UXTR5UTRU 5TR!X5S9$s snf)z Return the SQL statement to create the index for one or several fields or expressions. `sql` can be specified if the syntax differs from the standard (GIS indexes, ...). F alias_colsrt)rcP>TcTR"U0UD6mTRT5$r1)rrq)argskwargsrrLs rcreate_index_nameEBaseDatabaseSchemaEditor._create_index_sql..create_index_name(s,|..????4( (r )rrr&rbr_rr))rrrFrrsql_create_indexr(rr r rqr _index_columnsrrkr r$)rLr-rrrIr&rr'rZr(rr)r*rrrrbr3rr1s` ` rrK*BaseDatabaseSchemaEditor._create_index_sqls*2!'R 51>>? 77 8 .44VE<& __W-33 __V, ))*C#y))c.B.B//!!((- + r c[UR[URRUR 5UR U5UR U5S9$)N)rold_namenew_name)r sql_rename_indexr r(rrq)rLr-r<r=s rr1*BaseDatabaseSchemaEditor._rename_index_sqlOsH  ! ! ,,doo>__X.__X.   r c,[XURUS9$)N)r')rrq)rLrrbr'r(s rr4'BaseDatabaseSchemaEditor._index_columnsWsut\RRr cURR(a6URR(dURR(a/$/nURRH#nUR UR X55 M% URRH[nUR(a'URRR(dM;URURX55 M] U$)zb Return a list of all index SQL statements (field indexes, Meta.indexes) for the specified model. )r(managedproxyswappedrrrrXr%rFrIr&rhr)rLr-outputrr(s rr+BaseDatabaseSchemaEditor._model_indexes_sqlZs {{""ekk&7&75;;;N;NI[[--E MM$11%? @.[[((E..??++GGG e..u;< )  r ct/nURX5(aURURX/S95 U$)zD Return a list of all index SQL statements for the specified field. r)_field_should_be_indexedrhrK)rLr-rrFs rr+BaseDatabaseSchemaEditor._field_indexes_sqlms;  ( ( 6 6 MM$00w0G H r cVUR(dUR(dgU=(d [5nUR5upEpgUR5upHpURUR5Hn UR U S5 M URUR5Hn U R U S5 M UR (dUR(aUR(azURRRRURRRR:Xa$UR SS5 U R SS5 URS5(a\U RS5(aFURU5URU5:Xa"UR S5 U R S5 URUR5URUR5:g=(d XVU4XU 4:g$)NFtor)concreter deconstructunion non_db_attrspoprr>r-r(rrrrqr) rLr5r;rrold_pathold_args old_kwargsnew_pathnew_args new_kwargsattrs rr1BaseDatabaseSchemaEditor._field_should_be_alteredvs!!)*<*<35,5,A,A,C)X,5,A,A,C)XLL!7!78D NN4 &9LL!7!78D NN4 &9&&&&&&&&,,22;;%%++11::; NN4 & NN4 & NN< ( (|,,##I.$2E2Ei2PP NN< ( NN< (y//0DOO   5  R* -(j1Q Q Rr cJUR=(a UR(+$r1)rrrLr-rs rrI1BaseDatabaseSchemaEditor._field_should_be_indexeds~~2ell"22r cJUR(+=(a UR$r1rrLr5r;s rr2BaseDatabaseSchemaEditor._field_became_primary_keys(((BY-B-BBr cUR(+=(a7 UR=(a$ UR(+=(d UR$r1)rrr_s rr0BaseDatabaseSchemaEditor._unique_should_be_addeds?%% % @   @%%%>)>)> r cURURU5URUR5URUR5US.-$)N)r old_column new_columnr)sql_rename_columnrqr)rLrr5r;rs rr*BaseDatabaseSchemaEditor._rename_field_sqlsM%%__U+//)*:*:;//)*:*:; )   r c [URRUR5nUR XU5n[ URRUR /UR5n[URRRRUR5n[ URRRRURR /UR5nURRR5n [URUUUUUU S9$)N)rrrrwrxr)r r(rrqrrr target_fieldr-rFrprr sql_create_fk) rLr-rrIrrrrwrxrs rr'BaseDatabaseSchemaEditor._create_fk_sqlsekk**DOO<''f=-- ~tO++1177@@$//R    $ $ * * 3 3    & & ' OO __((779    !  r c^U4Sjn[URRUR/[ UR R RR5SUR R/UU5$)NcF>TRTR"U0UD65$r1rqrr/r0rLs rcreate_fk_nameDBaseDatabaseSchemaEditor._fk_constraint_name..create_fk_names"??4#:#:D#KF#KL Lr rT)rr(rrr rir-)rLr-rrIrps` rr,BaseDatabaseSchemaEditor._fk_constraint_namesk M KK \\N U//55;;DD Ea H    & & '     r c:URURX5$r1)r^ sql_delete_fkrLr-rs rr'BaseDatabaseSchemaEditor._delete_fk_sql**4+=+=uKKr c`UcgU[R:XagU[R:Xagg)Nraz DEFERRABLE INITIALLY DEFERREDz DEFERRABLE INITIALLY IMMEDIATE)rDEFERRED IMMEDIATE)rLrs r_deferrable_constraint_sql3BaseDatabaseSchemaEditor._deferrable_constraint_sqls2   ,, ,3 -- -4 .r cUSLagUSLagg)NFz NULLS NOT DISTINCTTz NULLS DISTINCTrar\)rLnulls_distincts r _unique_index_nulls_distinct_sql9BaseDatabaseSchemaEditor._unique_index_nulls_distinct_sqls U "( t #$r cU(+=(d URRR=(a U(+=(d URRR=(a U(+=(d URRR=(a` U(+=(d URRR =(a+ USL=(d URRR $r1)rFrIsupports_partial_indexes&supports_deferrable_unique_constraintsr#r&*supports_nulls_distinct_unique_constraints)rLrrr)r*r~s r_unique_supported*BaseDatabaseSchemaEditor._unique_supporteds] Odoo66OO S??++RR  R 8 8 R R  W4??#;#;#W#W $&W??++VV r c URUUUUU S9(dgU(dU(dU(d U(dU b9URUUUUUUUU S9n U (aURRU 5 gURSR UV s/sHoR U R5PM sn 5URU5S.-n URUR U5U S.-$s sn f)Nrrr)r*r~)rrr)r(r*r~r)rbrrr) rrrPrhsql_unique_constraintrrqrr{sql_constraint) rLr-rrrrr)r(r*r~rZrrs r _unique_sql$BaseDatabaseSchemaEditor._unique_sqls%%!#) &  )))##'-* C!!((-//yyV!TVE//%,,"?V!TU99*E3  ""OOD)$&   "Us $C, c URUUUUU S9(dg[USS9RURS9n URR n UV s/sHoR PM n n UcURXSS9nOURU5nU(dU(dU(dU(a URnO URnU (aURXSUS9n O[XXR5n [U[XR5UU UR!U5UR#U5UR%X5UR'U 5S 9$s sn f) NrFr,rtTrRr\)r'r()rrrbrrr)r~)rrrrFr(rrr[rqsql_create_unique_indexsql_create_uniquer4rrkr r r r{r$r)rLr-rrrrr)r(r*r~rrrrbrZs rr+BaseDatabaseSchemaEditor._create_unique_sql0sN%%!#) & 51>>?  $$-34VE<TRTR"U0UD65$r1rnros rcreate_unique_nameLBaseDatabaseSchemaEditor._unique_constraint_name..create_unique_namefs"t'>'>'O'OPPr _uniq)rr )rLrrbrSrs` rr[0BaseDatabaseSchemaEditor._unique_constraint_namecs*  Q"&!8!8 2DEEr c URUUUUUS9(dgU(dU(dU(dU(a URn O URn URXU5$)Nr)rrJr@r^) rLr-rrrr)r(r*r~rZs rr+BaseDatabaseSchemaEditor._delete_unique_sqlns]%%!#) &  9 ''C((C**3t<&   r cURRR(dgURURX5$r1)rFrIrr^sql_delete_checkrus rr*BaseDatabaseSchemaEditor._delete_check_sqls1''HH**4+@+@%NNr c[U[URRUR5UR U5S9$)Nr7)r r r(rrq)rLtemplater-rs rr^/BaseDatabaseSchemaEditor._delete_constraint_sqls6  ,,doo>&  r c |UbUV s/sHn URRR(aPURRR [ XRR R555O$URRR U 5PM nn URR5n URRRXRR5n SSS5 /n W R5HupUb X.S:XdMUb USU:waM Ub USU:waM.Ub USU:waM<Ub USU:waMJUb US(dMYUb USU:waMgU (aX;dMuU RU 5 M U $s sn f!,(df  N=f) z@Return all constraint names matching the columns and conditions.Nrbrrr(rurr)rFrItruncates_names introspectionidentifier_converterrrprrlget_constraintsr(ritemsrh)rLr-rrrr(rrurrQrrlrresultinfodicts rrY*BaseDatabaseSchemaEditor._constraint_namess  #) )D//??OO11FF%dOO,?,?,O,O,QR66KKDQ R )  __ # # %//77GG ,,K&)//1ND#| 7J'J%(8*<*F*x /F+/U$'):e)C$'):e)C*8M3J$&)9U)B$"5MM$'2  ? & %sB$F(:F-- F;cURUSS9nU(a?[U5S:wa0[S[U5<SURR<35eUH#nUR UR X55 M% g)NTr^rTrUz) of PK constraints for )rYr\r]r(rrU_delete_primary_key_sql)rLr-rrcrs rr,BaseDatabaseSchemaEditor._delete_primary_keysu11%T1J c*+q0()KK((  0O LL55eM N 0r c `[UR[URRUR 5UR UR URRUR/SS95[URRUR/UR 5S9$)N_pkr)rrrb) r sql_create_pkr r(rrqrrrr[s rr0BaseDatabaseSchemaEditor._create_primary_key_sqls    ,,doo>''KK((5<<.( EKK005<<.$//R  r c:URURX5$r1)r^ sql_delete_pkrus rr0BaseDatabaseSchemaEditor._delete_primary_key_sqlrwr c<U(aSURU5-$S$)NzCOLLATE ra)rq)rLrrrs rr%BaseDatabaseSchemaEditor._collate_sqls:CzDOOI66KKr cURURU5SRU5S.-nURU5 g)N,) procedure param_types)sql_delete_procedurerqrrU)rLprocedure_namerrZs rremove_procedure)BaseDatabaseSchemaEditor.remove_procedures=''888K0+   Sr )rrKrGrHrFrP)FT)r\)F)rar1)NNNNN)NNNNNN)NNNNNNN)T)NNNNNNNNr)x__name__ __module__ __qualname____firstlineno____doc__rrkrzrrrrrrrrrrrfrrrsql_delete_constraintrrrrr@rjrrrtr3rr>rJrrrrsrrMrRrVrUrqrrrrrrrrr staticmethodr rrkrrr)r-r4r8r;rErNr?rorr}rrrrrrrrrrrrrrr r$rKrr1r4rrrrIrrrrrrr{rrrrr[rrrrr^rYrrrrr__static_attributes__r\r rrCrCLsYAJV5T:PC FP"H'B$NN QA.L9NX, ?. @ "&)M 9  BI, R*M9IVUA,>4\@ANF 6 )&S2W$!>F.* A4-+ A*V* SDH&  V$p.@Q f (r$h :$ N16 8, \  / @@     4 l$ S&#RJ3C   *  L5  :2 p1 f F=2  O  -^ O  LLr rC)#loggingr*r django.confrdjango.core.exceptionsr!django.db.backends.ddl_referencesrrrr r r django.db.backends.utilsr r rdjango.db.modelsrrrdjango.db.models.sqlrdjango.db.transactionrr django.utilsr getLoggerrdrr.r=rCr\r rrsb -SR<<&D!   6 7 1  .jjr