[wp-trac] [WordPress Trac] #29364: More logical table names for networks

[WordPress Trac]

#29364: More logical table names for networks
-----------------------------+------------------------
 Reporter:  igmoweb          |       Owner:
     Type:  feature request  |      Status:  closed
 Priority:  normal           |   Milestone:
Component:  Database         |     Version:  3.9.2
 Severity:  normal           |  Resolution:  wontfix
 Keywords:                   |     Focuses:  multisite
-----------------------------+------------------------
Changes (by pento):

 * status:  new => closed
 * resolution:   => wontfix
 * milestone:  Awaiting Review =>


Comment:

 We can't do this for a few reasons:

 * The vast majority of WordPress sites are single site installs, so we'd
 be increasing the complexity of the table names for most sites, without
 any real benefit for them.
 * There are many plugins that assume the table prefix is `wp_`. While this
 is incorrect of them, we don't want to push out an update that will
 intentionally break them, if we don't need to.
 * Instead of trying to figure out the table prefix, plugins can use
 `wpdb::get_blog_prefix()`, so they don't need to figure out what the
 correct prefix is.

 You mentioned some plugins that copied all network tables when cloning
 site ID = 1, do you have an example of that? It may be that the plugins
 can be optimised to skip the network tables, which are defined in
 `wpdb::$ms_global_tables`.

 Thanks for taking the time to make this suggestion, we're always happy to
 discuss ideas, even if they're not necessarily something we're able to do!
 :-)

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