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

XMLWordPrintable

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

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

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

              Created:
              Updated:
              Resolved:

                Version Package
                Schema change, 2019 Q2