make metadata storage pluggable

There is no difference between TINYTEXT and VARCHAR(255) in MySQL for our purposes, so let's use VARCHAR(255) instead to keep things simple.