ó i4Vdc@s:ddlmZddlmZdefd„ƒYZdS(iÿÿÿÿ(tBaseDatabaseSchemaEditor(t NOT_PROVIDEDtDatabaseSchemaEditorcBsžeZdZdZdZdZdZdZdZdZ dZ d Z d Z d Z d Zd „Zd„Zd„Zd„Zd„Zd„Zd„Zd„ZRS(s+RENAME TABLE %(old_table)s TO %(new_table)ssMODIFY %(column)s %(type)s NULLs#MODIFY %(column)s %(type)s NOT NULLsMODIFY %(column)s %(type)ssCALTER TABLE %(table)s CHANGE %(old_column)s %(new_column)s %(type)ss)ALTER TABLE %(table)s DROP INDEX %(name)ssnALTER TABLE %(table)s ADD CONSTRAINT %(name)s FOREIGN KEY (%(column)s) REFERENCES %(to_table)s (%(to_column)s)s/ALTER TABLE %(table)s DROP FOREIGN KEY %(name)ss DROP INDEX %(name)s ON %(table)ss MODIFY %(column)s %(type)s NULL;s$MODIFY %(column)s %(type)s NOT NULL;sGALTER TABLE %(table)s ADD CONSTRAINT %(name)s PRIMARY KEY (%(columns)s)s&ALTER TABLE %(table)s DROP PRIMARY KEYcCs"ddl}|j||jjƒS(Niÿÿÿÿ(tMySQLdb.converterstescapet converterst conversions(tselftvaluetMySQLdb((sm/var/www/html/phendo-backend/phendo_python/env/lib/python2.7/site-packages/django/db/backends/mysql/schema.pyt quote_values c CsF|j|jƒ}|d k oE|jƒddddddddhkS( s‡ MySQL doesn't accept default values for TEXT and BLOB types, and implicitly treats these columns as nullable. ttinyblobtblobt mediumblobtlongblobttinytextttextt mediumtexttlongtextN(tdb_typet connectiontNonetlower(RtfieldR((sm/var/www/html/phendo-backend/phendo_python/env/lib/python2.7/site-packages/django/db/backends/mysql/schema.pyt skip_default#s    cCs“tt|ƒj||ƒ|j|ƒr|jdtfkr|j|ƒ}|jdi|j |j j ƒd6|j |j ƒd6|gƒndS(Ns%UPDATE %(table)s SET %(column)s = %%sttabletcolumn( tsuperRt add_fieldRtdefaultRRteffective_defaulttexecutet quote_namet_metatdb_tableR(RtmodelRR((sm/var/www/html/phendo-backend/phendo_python/env/lib/python2.7/site-packages/django/db/backends/mysql/schema.pyR1s$ cCs”|jjj|jjƒ|jjƒ}|dkr~xH|jjD]7}|jr@|j r@|j ƒdkr@t |_q@q@Wnt t |ƒj |ƒS(NtInnoDBt ForeignKey(Rt introspectiontget_storage_enginetcursorR!R"t local_fieldstdb_indextuniquetget_internal_typetFalseRRt_model_indexes_sql(RR#tstorageR((sm/var/www/html/phendo-backend/phendo_python/env/lib/python2.7/site-packages/django/db/backends/mysql/schema.pyR.=s  %cGs|jj|dƒ}|jƒdkrt|j||jgdtƒ}|st|j|j||gddƒƒqtntt |ƒj |||ŒS(s— MySQL can remove an implicit FK index on a field when that field is covered by another index like a unique_together. "covered" here means that the more complex index starts like the simpler one. http://bugs.mysql.com/bug.php?id=37910 / Django ticket #24757 We check here before removing the [unique|index]_together if we have to recreate a FK index. iR%tindextsuffixt( R!t get_fieldR,t_constraint_namesRtTrueRt_create_index_sqlRRt_delete_composed_index(RR#tfieldstargst first_fieldtconstraint_names((sm/var/www/html/phendo-backend/phendo_python/env/lib/python2.7/site-packages/django/db/backends/mysql/schema.pyR7Is (cCs$|jr|d7}n |d7}|S(st Keep the null property of the old field. If it has changed, it will be handled separately. s NULLs NOT NULL(tnull(RRtnew_type((sm/var/www/html/phendo-backend/phendo_python/env/lib/python2.7/site-packages/django/db/backends/mysql/schema.pyt_set_field_new_type_null_statusYs   cCs1|j||ƒ}tt|ƒj||||ƒS(N(R>RRt_alter_column_type_sql(RRt old_fieldt new_fieldR=((sm/var/www/html/phendo-backend/phendo_python/env/lib/python2.7/site-packages/django/db/backends/mysql/schema.pyR?dscCs1|j||ƒ}tt|ƒj||||ƒS(N(R>RRt_rename_field_sql(RRR@RAR=((sm/var/www/html/phendo-backend/phendo_python/env/lib/python2.7/site-packages/django/db/backends/mysql/schema.pyRBhs(t__name__t __module__tsql_rename_tabletsql_alter_column_nulltsql_alter_column_not_nulltsql_alter_column_typetsql_rename_columntsql_delete_uniquet sql_create_fkt sql_delete_fktsql_delete_indextalter_string_set_nulltalter_string_drop_nullt sql_create_pkt sql_delete_pkR RRR.R7R>R?RB(((sm/var/www/html/phendo-backend/phendo_python/env/lib/python2.7/site-packages/django/db/backends/mysql/schema.pyRs*    N(tdjango.db.backends.base.schemaRtdjango.db.modelsRR(((sm/var/www/html/phendo-backend/phendo_python/env/lib/python2.7/site-packages/django/db/backends/mysql/schema.pyts