WordPress.org

Make WordPress Core

Opened 3 years ago

Closed 3 years ago

Last modified 3 years ago

#19755 closed enhancement (maybelater)

Redundant blog_versions table

Reported by: johnbillion Owned by:
Milestone: Priority: normal
Severity: minor Version: 3.0
Component: Multisite Keywords: has-patch dev-feedback
Focuses: Cc:

Description

As part of the Multisite installation process, a blog_versions table is created. This table is never read from (except immediately prior to updating it), it's only ever inserted into or updated. It is not used to determine which blogs need to be upgraded.

This table was introduced in 3.0 when the WPMU schema was merged (#11644) and it appears the table has never been used in core and is therefore redundant and may as well be removed.

Attachments (1)

19755.patch (2.9 KB) - added by johnbillion 3 years ago.

Download all attachments as: .zip

Change History (5)

@johnbillion3 years ago

comment:1 @johnbillion3 years ago

  • Keywords has-patch dev-feedback added

Patch just in case, and because I've not done a patch which changes the DB schema before. Hopefully it's all present and correct.

comment:2 @ryan3 years ago

I believe wordpress.com and some other big multisite hosts use it for managing upgrades. That's not necessarily a reason the keep the table, but core might someday find blog_versions valuable if we ever improve the currently very lame network upgrade process.

comment:3 @nacin3 years ago

  • Milestone Awaiting Review deleted
  • Resolution set to maybelater
  • Status changed from new to closed

That's not necessarily a reason the keep the table, but core might someday find blog_versions valuable if we ever improve the currently very lame network upgrade process.

Agreed.

comment:4 @nacin3 years ago

  • Component changed from Database to Multisite
Note: See TracTickets for help on using tickets.