location: fix mysql schema and proto subscription