Oki. Can you add the index to the "2_3_4-2_3_5.mysql" file? :)
> -----Original Message----- > From: [EMAIL PROTECTED] [mailto:dbmail-dev- > [EMAIL PROTECTED] On Behalf Of Paul J Stevens > Sent: sábado, 6 de Dezembro de 2008 15:35 > To: DBMAIL Developers Mailinglist > Subject: Re: [Dbmail-dev] Bug #737 & 738 > > correct. > > Jorge Bastos wrote: > > Paul, > > In the sql script "2_3_4-2_3_5.mysql" there's: > > > > --- > > alter table dbmail_mailboxes add seq bigint default 0 not null; > > alter table dbmail_mailboxes drop mtime; > > > > alter table dbmail_users modify column passwd varchar(130) not null; > > --- > > > > And in the full script the creation of the dbmail_mailboxes table > > > > --- > > CREATE TABLE dbmail_mailboxes ( > > mailbox_idnr bigint(21) NOT NULL auto_increment, > > owner_idnr bigint(21) NOT NULL default '0', > > name varchar(255) NOT NULL default '', > > seen_flag tinyint(1) NOT NULL default '0', > > answered_flag tinyint(1) NOT NULL default '0', > > deleted_flag tinyint(1) NOT NULL default '0', > > flagged_flag tinyint(1) NOT NULL default '0', > > recent_flag tinyint(1) NOT NULL default '0', > > draft_flag tinyint(1) NOT NULL default '0', > > no_inferiors tinyint(1) NOT NULL default '0', > > no_select tinyint(1) NOT NULL default '0', > > permission tinyint(1) default '2', > > seq bigint(21) not null default '0', > > PRIMARY KEY (mailbox_idnr), > > INDEX name_index (name), > > INDEX owner_idnr_index (owner_idnr), > > INDEX seq_index (seq), > > UNIQUE INDEX owner_idnr_name_index (owner_idnr, name), > > FOREIGN KEY owner_idnr_fk (owner_idnr) > > REFERENCES dbmail_users (user_idnr) ON DELETE CASCADE > ON > > UPDATE CASCADE > > ) ENGINE=InnoDB DEFAULT CHARSET=utf8; > > --- > > > > > > My question is, if in the creation of the table there's an index for > the seq > > column, in the partial script should exist also? > > > > > > > > > >> -----Original Message----- > >> From: [EMAIL PROTECTED] [mailto:dbmail-dev- > >> [EMAIL PROTECTED] On Behalf Of Paul J Stevens > >> Sent: sábado, 6 de Dezembro de 2008 13:53 > >> To: DBMAIL Developers Mailinglist > >> Subject: Re: [Dbmail-dev] Bug #737 & 738 > >> > >> Jorge Bastos wrote: > >>> Hum i saw on git "flush buffer on write event". > >>> Nothing related to my issue, right? > >> Wrong again. That one should hopefully fix your issue with pop3d. > >> > >>> > >>> > >>>> -----Original Message----- > >>>> From: [EMAIL PROTECTED] [mailto:dbmail-dev- > >>>> [EMAIL PROTECTED] On Behalf Of Paul Stevens > >>>> Sent: sexta-feira, 5 de Dezembro de 2008 19:50 > >>>> To: DBMAIL Developers Mailinglist > >>>> Subject: Re: [Dbmail-dev] Bug #737 & 738 > >>>> > >>>> Jorge Bastos wrote: > >>>>> Paul, > >>>>> That's my issue also right? > >>>> Nope. > >>>> > >>>> -- > >>>> > ________________________________________________________________ > >>>> Paul Stevens paul at > nfg.nl > >>>> NET FACILITIES GROUP GPG/PGP: > 1024D/11F8CD31 > >>>> The > Netherlands________________________________http://www.nfg.nl > >>>> _______________________________________________ > >>>> Dbmail-dev mailing list > >>>> Dbmail-dev@dbmail.org > >>>> http://twister.fastxs.net/mailman/listinfo/dbmail-dev > >>> _______________________________________________ > >>> Dbmail-dev mailing list > >>> Dbmail-dev@dbmail.org > >>> http://twister.fastxs.net/mailman/listinfo/dbmail-dev > >>> > >> > >> -- > >> ________________________________________________________________ > >> Paul Stevens paul at nfg.nl > >> NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31 > >> The Netherlands________________________________http://www.nfg.nl > >> _______________________________________________ > >> Dbmail-dev mailing list > >> Dbmail-dev@dbmail.org > >> http://twister.fastxs.net/mailman/listinfo/dbmail-dev > > > > _______________________________________________ > > Dbmail-dev mailing list > > Dbmail-dev@dbmail.org > > http://twister.fastxs.net/mailman/listinfo/dbmail-dev > > > > > -- > ________________________________________________________________ > Paul Stevens paul at nfg.nl > NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31 > The Netherlands________________________________http://www.nfg.nl > _______________________________________________ > Dbmail-dev mailing list > Dbmail-dev@dbmail.org > http://twister.fastxs.net/mailman/listinfo/dbmail-dev _______________________________________________ Dbmail-dev mailing list Dbmail-dev@dbmail.org http://twister.fastxs.net/mailman/listinfo/dbmail-dev
