I've added the SQL scripts to the repository. They're in the SQLscripts folder

newSite.jsp now also adds the relevant entries to the database when creating a new site