problems with relationships between sites and structure within legacy database, this commit requires an update to the sql build