Details
-
Type:
Task
-
Status: Closed
-
Priority:
Normal
-
Resolution: Fixed
-
Affects Version/s: None
-
Fix Version/s: Schema change, 2019 Q2
-
Component/s: Schema Change
-
Labels:None
Description
For MBS-10062 we need a table:
CREATE TABLE genre_alias ( -- replicate (verbose) id SERIAL, genre INTEGER NOT NULL, -- references genre.id name VARCHAR NOT NULL, locale TEXT, edits_pending INTEGER NOT NULL DEFAULT 0 CHECK (edits_pending >= 0), last_updated TIMESTAMP WITH TIME ZONE DEFAULT NOW(), primary_for_locale BOOLEAN NOT NULL DEFAULT FALSE, CONSTRAINT primary_check CHECK ((locale IS NULL AND primary_for_locale IS FALSE) OR (locale IS NOT NULL)) );
Attachments
Issue Links
- is a dependency of
-
MBS-10062 Add aliases for genres
-
- In Progress
-