Jim wrote:
> 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
Using what you have now on the three I tried: users, mailaddr, policy
I get from phpmyadmin:
Indexes:
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:
Indexes:
Keyname Type Cardinality Field
PRIMARY PRIMARY 0 id
users_idx_email INDEX None email
I am not an SQL person, but I assume this is more desirable than the
former.
Gary V
-------------------------------------------------------
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_id=7637&alloc_id=16865&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/
