Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

-need to review tables that keep patron data in this area

-folio_email... etc.


Purge Scripts

These are the 


UPDATE folio_circulation.loan__t__
SET user_id = NULL
WHERE __current = FALSE
  AND user_id IS NOT NULL
;



UPDATE folio_circulation.loan__ AS ln
SET jsonb = jsonb_set(ln.jsonb, '{userId}', 'null'::jsonb, true)
WHERE
  __current = FALSE

;

Questions


What is in the zzz_ tables in Metadb?  e.g., zzz___loan__t___

...