added a query to update the site_prefix_code