ó ®â0_c@s:ddlmZddlmZdefd„ƒYZdS(iÿÿÿÿ(tBaseDatabaseSchemaEditor(t NOT_PROVIDEDtDatabaseSchemaEditorcBs’eZdZdZdZdZdZdZdZdZ dZ d Z d Z d „Z d „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)ss,ALTER TABLE %(table)s DROP COLUMN %(column)ssCALTER TABLE %(table)s CHANGE %(old_column)s %(new_column)s %(type)ss)ALTER TABLE %(table)s DROP INDEX %(name)ss/ALTER TABLE %(table)s DROP FOREIGN KEY %(name)ss DROP INDEX %(name)s ON %(table)ssGALTER 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((sA/tmp/pip-unpacked-wheel-BAJOf3/django/db/backends/mysql/schema.pyt quote_values c CsI|j|jƒ}|d k oH|jƒddddddddd h kS( s‚ MySQL doesn't accept default values for some data types and implicitly treats these columns as nullable. ttinyblobtblobt mediumblobtlongblobttinytextttextt mediumtexttlongtexttjsonN(tdb_typet connectiontNonetlower(RtfieldR((sA/tmp/pip-unpacked-wheel-BAJOf3/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((sA/tmp/pip-unpacked-wheel-BAJOf3/django/db/backends/mysql/schema.pyR/s$ cCswtt|ƒj||ƒ}|jjj|jjƒ|jjƒ}|dkrs|rs|j ƒdkrs|j rst S|S(NtInnoDBt ForeignKey( RRt_field_should_be_indexedRt introspectiontget_storage_enginetcursorR"R#tget_internal_typet db_constrainttFalse(RR$Rt create_indextstorage((sA/tmp/pip-unpacked-wheel-BAJOf3/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_namesRtTrueR t_create_index_sqlRRt_delete_composed_index(RR$tfieldstargst first_fieldtconstraint_names((sA/tmp/pip-unpacked-wheel-BAJOf3/django/db/backends/mysql/schema.pyR7Js (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((sA/tmp/pip-unpacked-wheel-BAJOf3/django/db/backends/mysql/schema.pyt_set_field_new_type_null_statusZs   cCs1|j||ƒ}tt|ƒj||||ƒS(N(R>RRt_alter_column_type_sql(RRt old_fieldt new_fieldR=((sA/tmp/pip-unpacked-wheel-BAJOf3/django/db/backends/mysql/schema.pyR?escCs1|j||ƒ}tt|ƒj||||ƒS(N(R>RRt_rename_field_sql(RRR@RAR=((sA/tmp/pip-unpacked-wheel-BAJOf3/django/db/backends/mysql/schema.pyRBis(t__name__t __module__tsql_rename_tabletsql_alter_column_nulltsql_alter_column_not_nulltsql_alter_column_typetsql_delete_columntsql_rename_columntsql_delete_uniquet sql_delete_fktsql_delete_indext sql_create_pkt sql_delete_pkR RRR'R7R>R?RB(((sA/tmp/pip-unpacked-wheel-BAJOf3/django/db/backends/mysql/schema.pyRs&     N(tdjango.db.backends.base.schemaRtdjango.db.modelsRR(((sA/tmp/pip-unpacked-wheel-BAJOf3/django/db/backends/mysql/schema.pyts