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

Add aliases for genres

    XMLWordPrintable

    Details

    • Type: New Feature
    • Status: In Progress
    • Priority: Normal
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: Schema Change
    • Labels:
      None

      Description

      Genres should have aliases, so that "hiphop", "hip hop" and "hip-hop" are all understood as the same genre.

      CREATE TABLE genre_alias ( – replicate (verbose)
      id SERIAL,
      genre INTEGER NOT NULL, – references genre.id
      name VARCHAR NOT NULL,
      locale TEXT,
      edits_pending INTEGER NOT NULL DEFAULT 0 CHECK (edits_pending >= 0),
      last_updated TIMESTAMP WITH TIME ZONE DEFAULT NOW(),
      primary_for_locale BOOLEAN NOT NULL DEFAULT false,
      CONSTRAINT primary_check CHECK ((locale IS NULL AND primary_for_locale IS FALSE) OR (locale IS NOT NULL)),
      )

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                reosarevok Nicolás Tamargo
                Reporter:
                reosarevok Nicolás Tamargo
              • Votes:
                2 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:

                  Packages

                  Version Package