id	summary	reporter	owner	description	type	status	component	version	severity	resolution	keywords	cc	stage	has_patch	needs_docs	needs_tests	needs_better_patch	easy	ui_ux
33120	Add OGC-compliant models for GeoDjango running on MySQL 8.0	Jeff Hitchcock	karthikeyaa-dev	"MySQL 8 introduced two new tables that allow the implementation of the `SpatialRefSys` and `GeometryColumns` models as well as related functions for adding new SRS entries to the database. Adding these two models and updating related functions to support them would be a good first step to improving GeoDjango's support for MySQL 8.

- Add `MySQLSpatialRefSys` model connecting to the `INFORMATION_SCHEMA.ST_GEOMETRY_COLUMNS` table (https://dev.mysql.com/doc/refman/8.0/en/information-schema-st-geometry-columns-table.html)
- Add `MySQLGeometryColumns` model connecting to the `INFORMATION_SCHEMA.ST_GEOMETRY_COLUMNS` table (https://dev.mysql.com/doc/refman/8.0/en/information-schema-st-geometry-columns-table.html)
- Enable `has_spatialrefsys_table` and `supports_add_srs_entry` backend features if MySQL version is greater than 8.0"	New feature	assigned	GIS	dev	Normal		mysql		Accepted	0	0	0	1	0	0