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

Add aliases for genres

XMLWordPrintable

    • Icon: New Feature New Feature
    • Resolution: Unresolved
    • Icon: Normal Normal
    • None
    • None
    • Edit system
    • None

      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)),
      )

            reosarevok Nicolás Tamargo
            reosarevok Nicolás Tamargo
            Votes:
            11 Vote for this issue
            Watchers:
            9 Start watching this issue

              Created:
              Updated:

                Version Package