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

Create a genre table in the DB and populate it with existing genres

    XMLWordPrintable

    Details

    • Type: Task
    • Status: Closed
    • Priority: Normal
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: Schema change, 2019 Q2
    • Component/s: None
    • Labels:
      None

      Description

      For MBS-9491, we need a table:

      CREATE TABLE genre ( -- replicate (verbose)
          id                  SERIAL, -- PK
          gid                 UUID NOT NULL,
          name                VARCHAR NOT NULL,
          comment             VARCHAR(255) NOT NULL DEFAULT '',
          edits_pending       INTEGER NOT NULL DEFAULT 0 CHECK (edits_pending >=0)
      );
      

        Attachments

          Issue Links

            Activity

              People

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

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Packages

                  Version Package
                  Schema change, 2019 Q2