← back to Stayclaim

db/migrations/010_pd_film_openverse.sql

9 lines

-- Add 'openverse' to pd_film_image source enum.
-- Openverse aggregates 800M+ CC0/PDM images from Flickr Commons, Wikimedia,
-- museums, and government archives. Effectively covers the Flickr Commons
-- gap (which would otherwise require a Flickr API key).

ALTER TABLE pd_film_image DROP CONSTRAINT IF EXISTS pd_film_image_source_check;
ALTER TABLE pd_film_image ADD CONSTRAINT pd_film_image_source_check
  CHECK (source IN ('wikimedia','archive_org','loc','nara','mhdl','smithsonian','nypl','flickr_commons','openverse'));