Misunderstood SQL syntax. Need to revert to registering 'list' type.
It's in a good state now, just need to populate the rest of the tables.