[Dovecot] MySQL table for use with dict et quota

mikael mikael at pirio.org
Mon Jul 24 01:05:19 EEST 2006


In your "http://wiki.dovecot.org/Quota/Dict" documentation, the table to create is :

   create table quota (
     path varchar(255) not null primary key,
     username varchar(255) not null,
     current integer
   );


"path" field is the primary key. But when i see the SELECT queries, "path" is always used 
('quota/storage') and username too. I don't understand... If "path" is the primary key, it 
must be unique in quota table ?

Perhaps the table would be like this :

   create table quota (
     path varchar(255) not null,
     username varchar(255) not null,
     current integer,
     primary key (path, username)
   );

No ?

I start to have a headache... :D
2 days with dovecot quota, and no fully working results :'(

Please, help me :)
-- 
Mikaël


More information about the dovecot mailing list