There is several actions that we can take to simplify the db usage and maintenance. The first low hanging fruit is the removal of empty tables.

node_node_ngrams2
nodes_nodes
nodescontexts_nodescontexts
rights

The second one is to improve the naming of the migration files (<incremental_id>_what_it_does.sql) and apply the patches on top of <0>_schema.sql stripped from the instructions which are already in the migration files. We would apply those in order to inialize a new db.