Roundcube Community Forum

News and Announcements => General Discussion => Topic started by: boxyball on January 08, 2016, 11:23:40 AM

Title: ok to add identity via mysql
Post by: boxyball on January 08, 2016, 11:23:40 AM
I have identity access level set to 3 - one identity with possibility to edit all params but not email address.
I don't want users adding identities.
Most users are on a primary domain, however some users are on other domains.
Can I just add records to the identities table as I see fit to change identities and even add some for certain users?
In other words, does the identities table have relationships to other tables that if I add/subtract to it then I will break something else?
Thanks in advance.
Title: Re: ok to add identity via mysql
Post by: JohnDoh on January 09, 2016, 03:53:41 AM
yes that should be fine. all you need to do is make sure you get user_id right.
Title: Re: ok to add identity via mysql
Post by: boxyball on January 11, 2016, 02:57:29 PM
Thanks.  And if I want to delete an identity, can I just delete the record or do I have to do something with the del field?
Nevermind ... I just came across the cleandb script ... I will flag the record with a 1 in the del field and also add cleandb to cron.daily.
Problem ... cleandb seems to work for contacts and contactgroups but not identities. 
I changed del field in identities table from zero to one and ran cleandb and identity did not get deleted.
Nevermind ... I see that cleandb deletes stuff modified over two days ago.