diff options
author | Yorhel <git@yorhel.nl> | 2009-10-09 11:45:32 +0200 |
---|---|---|
committer | Yorhel <git@yorhel.nl> | 2009-10-09 11:47:54 +0200 |
commit | d43ae33a587743fc0916930e0a39f561f3174a69 (patch) | |
tree | db92a9126357b5cfc826a9506cfe89a6da98bda2 /util/updates | |
parent | 9b379e376cbafc8408d8ff3318a39ca2631f510a (diff) |
Added producer role (developer/publisher) to DB and release editor
They aren't displayed on the site yet, though.
Diffstat (limited to 'util/updates')
-rw-r--r-- | util/updates/update_2.8.sql | 5 |
1 files changed, 5 insertions, 0 deletions
diff --git a/util/updates/update_2.8.sql b/util/updates/update_2.8.sql index df5221ee..2993467c 100644 --- a/util/updates/update_2.8.sql +++ b/util/updates/update_2.8.sql @@ -54,3 +54,8 @@ ALTER TABLE releases_media ALTER COLUMN medium DROP DEFAULT; ALTER TABLE releases_media ALTER COLUMN medium TYPE medium USING TRIM(both ' ' from medium)::medium; +-- Differentiate between publishers and developers +ALTER TABLE releases_producers ADD COLUMN developer boolean NOT NULL DEFAULT FALSE; +ALTER TABLE releases_producers ADD COLUMN publisher boolean NOT NULL DEFAULT TRUE; +ALTER TABLE releases_producers ADD CHECK(developer OR publisher); + |