[wp-trac] [WordPress Trac] #49188: Add a check for tables structures.

[WordPress Trac]

#49188: Add a check for tables structures.
-------------------------+--------------------------------------
 Reporter:  xkon         |      Owner:  (none)
     Type:  enhancement  |     Status:  new
 Priority:  normal       |  Milestone:  Awaiting Review
Component:  Site Health  |    Version:
 Severity:  normal       |   Keywords:  2nd-opinion dev-feedback
  Focuses:               |
-------------------------+--------------------------------------
 While reading #47714, I had this idea as I've seen a lot of sites
 especially after migrations/restorations where the DB structures weren't
 implemented as planned and nobody noticed, leading into WordPress not
 being able to work properly.

 Core table structures shouldn't be altered I believe unless a database is
 customized in general so for the majority it should always be the same and
 as instructed by the installation (do tell me if I have this completely
 off :D).

 I believe that managing a test for core table structures would be of great
 benefit as migrations/restorations can't be avoided at some point & it
 would also be considered a critical issue.

 We could also create extra documentation to point at if there's a problem
 with some "copy, modify & paste" SQL to restore the structures as supposed
 to be.

 Any thoughts on this? There might be plugins out there doing this already
 but I do believe it could be a nice addition to Site Health for checking
 core-related tables.

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