custom table_name for table users with devise

[oto iashvili]

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