wrote (most of?) the schema and executed it via mysqli::multi_query

front page template