I have a database where one table is users, users can know other users so that there will be a many to many relation of which users know what other users. ActiveRecord assumes the names in the join table is the table+_id. If I was gonna follow ActiveRecords naming this would be:
create table users_users(
user_id int,
user_id int,
primary key(user_id, user_id)
);
Now that obviously won't work, so how do I deal with this?