sql: refactor to split out indexes and triggers

This is the first step towards having different sets of indexes between the
master and read-only replicas.