Форуми / Craftwork / Server-side / merge the data base...

i'd like to know your opinion about this...

Trustmaster
#33341 28.02.2012 07:51

What you need to do is this:

INSERT IGNORE INTO `sed_groups_users` (`gru_userid`, `gru_groupid`)
    SELECT `user_id`, `user_maingrp` FROM `sed_users`;

This will add the main groups into sed_groups_users. After that you'll have to add secondary groups manually for each user.

May the Source be with you!