fix api tests, fix error about duplicate subscriptions table name in sql due to message default_scope