Fixed #23538 -- Added SchemaEditor for MySQL GIS.

Thanks Claude Paroz for suggestions and review.

1 files changed, 10 insertions, 0 deletions

diff --git a/django/db/backends/mysql/introspection.py b/django/db/backends/mysql/introspection.py
index 8b7ff3c1e5..47bb92859a 100644
--- a/django/db/backends/mysql/introspection.py
+++ b/django/db/backends/mysql/introspection.py
@@ -127,6 +127,16 @@ class DatabaseIntrospection(BaseDatabaseIntrospection):
                 indexes[row[4]]['unique'] = True
         return indexes
 
+    def get_storage_engine(self, cursor, table_name):
+        """
+        Retrieves the storage engine for a given table.
+        """
+        cursor.execute(
+            "SELECT engine "
+            "FROM information_schema.tables "
+            "WHERE table_name = %s", [table_name])
+        return cursor.fetchone()[0]
+
     def get_constraints(self, cursor, table_name):
         """
         Retrieves any constraints or keys (unique, pk, fk, check, index) across one or more columns.