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 >>>> [email protected] >>>> http://twister.fastxs.net/mailman/listinfo/dbmail-dev >>> _______________________________________________ >>> Dbmail-dev mailing list >>> [email protected] >>> 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 >> [email protected] >> http://twister.fastxs.net/mailman/listinfo/dbmail-dev > > _______________________________________________ > Dbmail-dev mailing list > [email protected] > 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 [email protected] http://twister.fastxs.net/mailman/listinfo/dbmail-dev
