Manually building the database

General questions
1

I need to manually build the database for Piwik 2.40 via phpmyadmin? Where can I find the SQL statements please?

2

See the SQL update statement in: matomo/core/Updates at master · matomo-org/matomo · GitHub

and in: matomo/Mysql.php at master · matomo-org/matomo · GitHub