Heute (13.12.2005/15:50 Uhr) schrieb Mark Martinec ([EMAIL PROTECTED]), > Gary,
>> Keyname Type Cardinality Field >> PRIMARY PRIMARY 0 id >> id UNIQUE 0 id >> users_idx_email INDEX None email >> PRIMARY and INDEX keys should not both be set for column `id` >> >> Using "SERIAL PRIMARY KEY" appears to have created a new problem. >> It looks like it creates two indexes. >> >> Reverting back to: "INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY" >> solves the newly introduced problem, at least I think it does, >> as now I get: >> Keyname Type Cardinality Field >> PRIMARY PRIMARY 0 id >> users_idx_email INDEX None email > Thanks for pointing it out. You are right. The reason is probably > because SERIAL stands for BIGINT UNSIGNED NOT NULL AUTO_INCREMENT UNIQUE, However, it stands correctly in the "old" README.sql --snip -- MySQL notes: -- the attribute SERIAL was introduced with MySQL 4.1.0; -- with earlier versions one can use INT UNSIGNED NOT NULL AUTO_INCREMENT --snap > the culprit being the UNIQUE, which creates an index on its own, > and since the 'id' is already a primary key with an implicit index, > the 'id' field now has two indices. It is a waste of resources, > although is not harmful. > I modified the README.sql to reflect this: > http://www.ijs.si/software/amavisd/README.sql.txt > Mark -- Viele Grüße, Kind regards, Jim Knuth [EMAIL PROTECTED] ICQ #277289867 - VoIP: +49 (0) 322 212 044 67 Key ID: 0x1F78066F ---------- Zufalls-Zitat ---------- Ein Vorteil von Gruppensex ist, dass man ein Nickerchen machen kann wenn man will (allen Woody) ---------- Der Text hat nichts mit dem Empfänger der Mail zu tun ---------- Virus free. Checked by NOD32 Version 1.1320 Build 6438 12.12.2005 ------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Do you grep through log files for problems? Stop! Download the new AJAX search engine that makes searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! http://ads.osdn.com/?ad_idv37&alloc_id865&op=click _______________________________________________ AMaViS-user mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/amavis-user AMaViS-FAQ:http://www.amavis.org/amavis-faq.php3 AMaViS-HowTos:http://www.amavis.org/howto/
