-
Improvement
-
Resolution: Fixed
-
Normal
-
None
-
None
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 );