Refreshed to match the new schema, trigger, and prepopulated LOCATION and URL tables.