← back to Stayclaim

db/migrations/011_pd_film_met_dpla.sql

7 lines

-- Add 'met' and 'dpla' to pd_film_image source enum.
--   met  — Metropolitan Museum of Art Open Access (CC0, no key)
--   dpla — Digital Public Library of America (free key emailed to Steve)
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','met','dpla'));