wikicourse - move this flag to wiki course format plugin
filetemplate - the handling of files changed completely, was this considered? might be text field instead
migrated - migrated from what tables? The old content should be moved to some new tables I guess and this flag could be there - David Mudrak has similar problems in Workshop, maybe both could use the same approach to make things easier to understand
missing foreign keys info
userid - COMMENT="Edition author" ? it is the person who created the page, right?
version - this should link wiki_versions->id, the human readable version is there, right?
missign foreign keys info
subwikiid - why do we need it there? it links to wiki_pages which already contains this info, right?
format - wrong name, should be "contentformat"
why is there no "change summary" field like in mediawiki?
again foreign keys
is just a cache parsed from the latest version of each page, right?
subwikiid - why is it duplicated again, each page knows subwikiid
STATEMENTS section must be replaced by new code in db/install.php