Details

    • Type: New Feature
    • Status: In Progress
    • Priority: Normal
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: Schema change, 2019 Q2
    • 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

          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: