In principle sounds like it would work. I don't know the Roundcube data table structure well enough to know if these are the only changes you would require there, but in answer to your question about auto_increment you can use:
ALTER TABLE tbl AUTO_INCREMENT = 5;
To reset the auto_increment figure in table B at the end so any new records start numbering beyond the merged data.
Also see:
https://dev.mysql.com/doc/refman/5.7/en/example-auto-increment.html
Hope this helps.
Steve
On 06-09-2017 17:19, Jorge Bastos wrote:
Howdy,
I have two installs of RC, but I discovered something that already exists,
that is the possibility to have just one install, no matter the number of
servers that I have:
$config['default_host'] = 'mail.%s';
I know it was always there, but I was blind :)
I even can create a separated record for all domains to use an internal IP
if I want, but that's something I'll see if I have the need of, servers are
all in the same datacenter/switch for now.
Thing is, i have:
Install A
Install B
And i have users that have contacts on both sides, and the user ID's will
collide.
What I'm thinking to do it:
On install B
update users set user_id=user_id+10000;
update contacts set user_id=user_id+10000;
and then join this two tables to install A
the database schema is pretty simple, but I'd like an advice/confirmation on
this if possible, 'cause I don't know what will happen when the user_id will
reach the numbers that I incremented, will they collide or it'll check if
the number exists? (I know it's an autoincrement field)
I can always use a very very high value like user_id+100000000, but don't
like the solution,
Thanks in advanced :)
Jorge,
_______________________________________________
Roundcube Users mailing list
users@lists.roundcube.net
http://lists.roundcube.net/mailman/listinfo/users