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

       

       

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

              Created:
              Updated:

                Version Package
                Schema change, 2024 Q2