Custom table_name for table users with devise

Rails
1

Hi
for my app, I have several tables for users (franceusers, belgiumusers,
…) and I would like to use one or another depending on domain
I tried with table_name_prefix and table_name but it seems to not work

class User < ActiveRecord::Base
rolify

Include default devise modules. Others available are:

:token_authenticatable, :confirmable,

:lockable, :timeoutable and :omniauthable

devise :database_authenticatable, :registerable, #:confirmable,
:recoverable, :rememberable, :trackable, :validatable

def self.table_name
debugger
‘franceusers’
end

def self.table_name_prefix
debugger
‘france’
end

thanks to debugger, I can see that is called but not
self.table_name_prefix. And even if self.table_name if called, devise
search users in tables users instead of franceusers

in console
User.table_name => “franceusers”
User.table_name_prefix => “france”

more weird, im also using activeadmin, and when I browse users list, I
have
an error :

Mysql2::Error: Unknown column ‘franceusers.id’ in ‘order clause’: SELECT
users.* FROM users ORDER BY franceusers.id desc LIMIT 30 OFFSET
0

it seems it can find table_prefix for field but not for FROM.

do I do anything bad ? is there another way to change users table name ?

thanks

merci