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](http://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