WordPress.org

Make WordPress Core

Opened 6 years ago

Closed 6 years ago

#17188 closed enhancement (fixed)

Remove blog_id column from wp_options

Reported by: scribu Owned by: ryan
Milestone: 3.4 Priority: normal
Severity: normal Version:
Component: Database Keywords: has-patch
Focuses: Cc:

Description

The wp_options table still contains a blog_id column.

Given the current multisite schema, it's totally useless now.

Reference: [1601]

Attachments (2)

17188.diff​ (504 bytes) - added by scribu 6 years ago.
17188.patch​ (787 bytes) - added by barry 6 years ago.

Download all attachments as: .zip

Change History (8)

@scribu
6 years ago

#1 @westi
6 years ago

  • Milestone changed from 3.2 to Future Release

No schema changes in 3.2

Moving to Future Release.

#2 @ryan
6 years ago

  • Milestone changed from Future Release to 3.4

#3 @ryan
6 years ago

  • Owner set to ryan
  • Resolution set to fixed
  • Status changed from new to closed

In [19793]:

Remove blog_id column from wp_options. Props scribu. fixes #17188

@barry
6 years ago

#4 @barry
6 years ago

  • Resolution fixed deleted
  • Status changed from closed to reopened

Patched attached to handle the schema update.

#5 @scribu
6 years ago

Regarding 17188.patch​, is it really necessary? I thought we just left old columns floating around.

#6 @ryan
6 years ago

  • Resolution set to fixed
  • Status changed from reopened to closed

In [19798]:

Drop the blog_id column from the options table during upgrade. Props barry. fixes #17188

Note: See TracTickets for help on using tickets.