Roundcube Community Forum

News and Announcements => General Discussion => Topic started by: grpprod on January 15, 2013, 02:52:51 PM

Title: Empty database and preserve addressbooks
Post by: grpprod on January 15, 2013, 02:52:51 PM
Hi,
is it possible somehow to remove duplicates from roundcube database? And in general all data that are not used. It seems that almost all users have duplicate IDs (identities/identity_id), and of course only one is used.

As a different approach, we would be willing to empty RC database completely and start it from scratch. All we want to keep is addressbooks. Would this be possible?

Our system is single-identity ($rcmail_config['identities_level'] = 3)

Thank you
Title: Re: Empty database and preserve addressbooks
Post by: grpprod on January 22, 2013, 07:38:54 AM
Anyone for this?
Title: Re: Empty database and preserve addressbooks
Post by: SKaero on January 22, 2013, 12:08:53 PM
Not a problem I've run into before, you'd probably need to write a custom query to delete the extra records.