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 - 500

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 2012

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 the

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 tables,

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 :

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

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