[wp-trac] [WordPress Trac] #63661: Display admin error message if AUTO_INCREMENT attribute is missing on WP core tables

[WordPress Trac]

#63661: Display admin error message if AUTO_INCREMENT attribute is missing on WP
core tables
----------------------------+-----------------------------
 Reporter:  bangelov        |      Owner:  (none)
     Type:  enhancement     |     Status:  new
 Priority:  normal          |  Milestone:  Awaiting Review
Component:  Database        |    Version:
 Severity:  normal          |   Keywords:
  Focuses:  administration  |
----------------------------+-----------------------------
 WordPress relies on the AUTO_INCREMENT attribute on core database tables
 to function correctly. When this attribute is missing, it can lead to
 issues with data integrity and data creation.

 For example:
 DB Migration - by default AWS DMS’s Basic Schema Copy will not preserve
 the AUTO_INCREMENT (identity) property on your target tables. It only
 creates the tables and primary-key definitions; things like secondary
 indexes, foreign-key constraints and auto-increment attributes are skipped
 during the load

 To improve user experience and prevent potential issues, it would be
 beneficial to add an admin notice that detects and alerts site
 administrators if any core tables are missing the AUTO_INCREMENT
 attribute. This proactive warning would guide administrators to correct
 their database schema, ensuring WordPress operates smoothly

-- 
Ticket URL: <https://core.trac.wordpress.org/ticket/63661>
WordPress Trac <https://core.trac.wordpress.org/>
WordPress publishing platform