← back to Stayclaim

db/migrations/009_pd_film_more_sources.sql

12 lines

-- Extend pd_film_image.source enum to include the 4 new PD adapters:
--   mhdl           — Media History Digital Library (lantern.mediahist.org)
--   smithsonian    — Smithsonian Open Access
--   nypl           — NYPL Digital Collections (Billy Rose Theatre etc.)
--   flickr_commons — Flickr Commons (institutional "no known copyright restrictions")
--
-- The existing CHECK constraint is dropped and recreated with the wider enum.

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'));