It seems that the wiki_pages table has one foreign key pointing to wiki_subwiki, while the correct table name is wiki_subwikis. Also, ideally, the wiki_subwikis table should be defined in the XML structure before the wiki_pages one, so if creation of schema is performed with foreign keys enabled, it will work (i.e. dependencies must be satisfied by a correct order in install.xml files).
To detect/reproduce this problem:
- Go to Admin -> Development -> XMLDB Editor
- Execute the "[ Check foreign keys] " facility.