Hi, If you see the tables, they have same name except acl and quick add as suffix. This is the relation.
Vikas On Thu, 28 Jun 2012 21:35:41 +0530 wrote > Hi, really? This is unbelievable. Are we back in 1970? Do people know what a ER diagramm is (special focus should be on the R here ;-)? Am 28.06.2012 16:54, schrieb Nicolas - Lileo: Hi, thanks for the answer, Actually i checked the foreign key relations and there is no relationships between tables... Cheers Nicolas FABRE Tél : 09 72 29 97 47 Tél : 02 28 08 75 24 LILEO 1 rue du Tonkin - 44000 NANTES http://www.lileo.fr Le 28/06/2012 14:18, Buddy Butterfly a écrit: Hi, if this is a proper db model then the relationships should be visible in the foreign key relations ;-) Am 28.06.2012 13:36, schrieb Nicolas - Lileo: 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 With Regards, Vikas Sinha-- users@sogo.nu https://inverse.ca/sogo/lists