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

Add genre collections

XMLWordPrintable

      To catalog your favorite genres for example.

       

      This needs a new table editor_collection_genre: 

       

      CREATE TABLE editor_collection_genre (
          collection INTEGER NOT NULL, -- PK, references editor_collection.id
          genre INTEGER NOT NULL, -- PK, references genre.id
          added TIMESTAMP WITH TIME ZONE DEFAULT NOW(),
          position INTEGER NOT NULL DEFAULT 0 CHECK (position >= 0),
          comment TEXT DEFAULT '' NOT NULL
      ); 

       

       

            reosarevok Nicolás Tamargo
            chaban chaban
            Votes:
            1 Vote for this issue
            Watchers:
            3 Start watching this issue

              Created:
              Updated:

                Version Package
                Schema change, 2024 Q2