Add aliases for genres

XMLWordPrintable

    • Type: New Feature
    • Resolution: Unresolved
    • Priority: Normal
    • None
    • Affects Version/s: None
    • Component/s: 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)),
      )

        There are no Sub-Tasks for this issue.

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

              Created:
              Updated:

                Version Package