Hi all, I am also trying to get the big picture about mysql tables' relationships and about the way SOGo stores data. Three "default" tables for each user means a lot of tables in environments like - say - 500 users: has anyone already tried to "migrate" the database structure to three single tables, with an extra field to match the current user? Is there any configuration option to keep the data in a more-or-less fixed number of tables?
Thanks in advance for any help, suggestion and/or comment. Alberto On 28 June 2012 13:36, Nicolas - Lileo <nicolas.fa...@lileo.fr> wrote: > Hi all, > > I had to do some work in the mysql database where sogo keep his datas. > Anyway, i have a question about the way sogo organize the calendar and > addressbook datas. > I noticed that there are 3 tables for each personal calendar or each > personal addressbook. > 1 for acl, 1 for datas (quick) and 1 who has exactly the same structure if > it's a calendar or an addressbook. > > My question is what is the relationship between calendar tables and > adressbook table and basically how does it work? > > Thanks in advance > -- > Nicolas FABRE > -- users@sogo.nu https://inverse.ca/sogo/lists
