Uploaded image for project: 'MusicBrainz Server'
  1. MusicBrainz Server
  2. MBS-7638

CreateIndexes for instruments wrongly looks at label tables

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Normal
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: Schema change, 2014-11-17
    • Component/s: None
    • Labels:
      None

      Description

      CREATE INDEX edit_instrument_idx ON edit_label (label);
      CREATE UNIQUE INDEX l_area_instrument_idx_uniq ON l_area_label (entity0, entity1, link, link_order);
      CREATE UNIQUE INDEX l_artist_instrument_idx_uniq ON l_artist_label (entity0, entity1, link, link_order);
      CREATE INDEX l_area_instrument_idx_entity1 ON l_area_label (entity1);
      CREATE INDEX l_artist_instrument_idx_entity1 ON l_artist_label (entity1);

        Attachments

          Activity

            People

            • Assignee:
              ianmcorvidae Ian McEwen
              Reporter:
              reosarevok Nicolás Tamargo
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Due:
                Created:
                Updated:
                Resolved:

                Packages

                Version Package
                Schema change, 2014-11-17