change all FK constraints to ON DELETE CASCADE.  Except updated_by,
which is set to DEFAULT
set default for "updated_by" to COrE Agency.