Roundcube Community Forum

 

ok to add identity via mysql

Started by boxyball, January 08, 2016, 11:23:40 AM

Previous topic - Next topic

boxyball

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.

JohnDoh

yes that should be fine. all you need to do is make sure you get user_id right.
Roundcube Plugins: Contextmenu, SpamAssassin Prefs, and more...

boxyball

#2
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.