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
> [email protected]
> http://lists.roundcube.net/mailman/listinfo/users
_______________________________________________
Roundcube Users mailing list
[email protected]
http://lists.roundcube.net/mailman/listinfo/users
