feat: store msg types inside message_type table and add messages_by_type function

feat: store msg types inside message_type table and add messages_by_type function #780