Heute (13.12.2005/02:09 Uhr) schrieb Mark Martinec ([EMAIL PROTECTED]), > Jim,
>> I use mysql 4.0.24 and phpMyAdmin told me by creating (for >> example): >> CREATE TABLE users ( >> id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY, >> priority integer NOT NULL DEFAULT '7', >> policy_id integer unsigned NOT NULL DEFAULT '1', >> email varchar(255) NOT NULL, >> fullname varchar(255) DEFAULT NULL, >> local char(1), >> KEY email (email) >> ); >> CREATE UNIQUE INDEX users_idx_email ON users (email); >> --snap >> >> UNIQUE and INDEX keys should not both be set for column `email` >> >> And now I`ve creating the table without the last column (CREATE >> UNIQUE INDEX users_idx_email ON users (email);). And all work >> fine. AND - I`ve tuning mysql in my.cnf. ;) > That's fine. Use either KEY in the CREATE TABLE, > or CREATE ...INDEX, but not both. then it`s wrong in the README!? ;) Or how can I understand this? > Mark -- Viele Grüße, Kind regards, Jim Knuth [EMAIL PROTECTED] ICQ #277289867 - VoIP: +49 (0) 322 212 044 67 Key ID: 0x1F78066F ---------- Zufalls-Zitat ---------- Aus Liebe zu dir hab ich auf MICH verzichtet, es wäre besser gewesen, ich hätte aus Liebe zu mir auf DICH verzichtet. ---------- 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 AMaViS-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/amavis-user AMaViS-FAQ:http://www.amavis.org/amavis-faq.php3 AMaViS-HowTos:http://www.amavis.org/howto/