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