[wp-trac] [WordPress Trac] #40357: dbDelta can't change primary keys, create AUTO_INCREMENT columns and doesn't make significant index changes

[WordPress Trac]

#40357: dbDelta can't change primary keys, create AUTO_INCREMENT columns and
doesn't make significant index changes
-------------------------------------------------+-------------------------
 Reporter:  stuporglue                           |       Owner:
     Type:  enhancement                          |      Status:  new
 Priority:  normal                               |   Milestone:  Awaiting
Component:  Database                             |  Review
 Severity:  normal                               |     Version:  trunk
 Keywords:  has-patch needs-testing needs-unit-  |  Resolution:
  tests                                          |     Focuses:
-------------------------------------------------+-------------------------
Changes (by johnjamesjacoby):

 * keywords:   => has-patch needs-testing needs-unit-tests


Comment:

 Hey @stuporglue, great second ticket here!

 cc @pento, who really loves working with `dbDelta()` ❤️

 I've noticed similar issues with many different types of `ALTER`s, where
 `dbDelta()` has internal conditions to support but seem to get skipped
 over in the majority of cases, so I'll try this patch out also and report
 back my results.

 If we get to a point where patches need massaging to make them ready for
 core (think of turning your `tests.php` to unit tests) I'll try to be a
 resource if you need one.

--
Ticket URL: <https://core.trac.wordpress.org/ticket/40357#comment:1>
WordPress Trac <https://core.trac.wordpress.org/>
WordPress publishing platform