Just saw this in phpMyAdmin and figured it would be worth mentioning.

Problems with indexes of table `openlayers_layers`
Problems with indexes of table `openlayers_styles`

CommentFileSizeAuthor
#4 1491314-04-openlayers.dropdupindex.patch1.02 KBmgifford
#3 1491314-03-openlayers.dropdupindex.patch983 bytesekes

Comments

zzolo’s picture

zzolo commented
Title: The indexes PRIMARY and name seem to be equal and one of them could possibly be removed. » Redundant indexes on Styles and Layers tables
Version: 7.x-3.x-dev » 7.x-2.x-dev
Category: bug » task

Thanks, @mgifford. This is redundant. But it will need an update function to go with it, so not making it a priority at the moment.

mgifford’s picture

mgifford
he/him
Primary language English
commented

Yup.. Just as a todo for the next release point or something. It might have a small performance impact, but other than that.

ekes’s picture

ekes commented
Status: Active » Needs review
StatusFileSize
new 1491314-03-openlayers.dropdupindex.patch983 bytes

Small patch to do this.

mgifford’s picture

mgifford
he/him
Primary language English
commented
Version: 7.x-2.x-dev » 7.x-3.x-dev
StatusFileSize
new 1491314-04-openlayers.dropdupindex.patch1.02 KB

Looks good. I just did a fresh install from the git repo 7.x-3.x and it worked. I reworked this patch so it can be applied with git rather than patch.

pol’s picture

pol
Location Brussels
commented
Status: Needs review » Fixed

Thanks @ekes & @mgifford, committed to 7.x-2.x & 7.x-3.x ;-)

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.