Re: [SOGo] to better understand Sogo

2012-07-03 Thread Christian Mack
Hello Alberto Federico Turelli On 2012-06-28 14:48, Alberto Federico Turelli wrote: > 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

Re: [SOGo] to better understand Sogo

2012-06-29 Thread Nicolas - Lileo
alright but what is the purpose to have relations between calendar and adressbook? Cheers *Nicolas FABRE* Le 29/06/2012 06:16, vikas sinha a écrit : > 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 20

Re: Re: [SOGo] to better understand Sogo

2012-06-28 Thread vikas sinha
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 diagram

Re: [SOGo] to better understand Sogo

2012-06-28 Thread Buddy Butterfly
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 bet

Re: [SOGo] to better understand Sogo

2012-06-28 Thread 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 : > > H

Re: [SOGo] to better understand Sogo

2012-06-28 Thread Alberto Federico Turelli
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 table

Re: [SOGo] to better understand Sogo

2012-06-28 Thread Buddy Butterfly
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 t

[SOGo] to better understand Sogo

2012-06-28 Thread 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 w