WordPress.org

Make WordPress Core

Opened 4 years ago

Closed 3 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 4 years ago.
17188.patch​ (787 bytes) - added by barry 3 years ago.

Download all attachments as: .zip

Change History (8)

@scribu — 4 years ago

comment:1 @westi — 4 years ago

  • Milestone changed from 3.2 to Future Release

No schema changes in 3.2

Moving to Future Release.

comment:2 @ryan — 3 years ago

  • Milestone changed from Future Release to 3.4

comment:3 @ryan — 3 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 — 3 years ago

comment:4 @barry — 3 years ago

  • Resolution fixed deleted
  • Status changed from closed to reopened

Patched attached to handle the schema update.

comment:5 @scribu — 3 years ago

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

comment:6 @ryan — 3 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.