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`

Files: 
CommentFileSizeAuthor
#4 1491314-04-openlayers.dropdupindex.patch1.02 KBmgifford
PASSED: [[SimpleTest]]: [MySQL] 236 pass(es).
[ View ]
#3 1491314-03-openlayers.dropdupindex.patch983 bytesekes
PASSED: [[SimpleTest]]: [MySQL] 238 pass(es).
[ View ]

Comments

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.

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

Status:Active» Needs review
StatusFileSize
new983 bytes
PASSED: [[SimpleTest]]: [MySQL] 238 pass(es).
[ View ]

Small patch to do this.

Version:7.x-2.x-dev» 7.x-3.x-dev
StatusFileSize
new1.02 KB
PASSED: [[SimpleTest]]: [MySQL] 236 pass(es).
[ View ]

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.

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.