[Typo3-dev] Typo3 won't accept my UNIQUE KEY!

[tonym at bvrmc.org]

I want to add a unique key to my sql table to eliminate the possibility of
duplicates.

Once I add it, the information page says:
"Database status:	Table error!
Probably one or more required fields/tables are missing in the database!"
and
"Errors:	Some tables or fields are of wrong type!"

Also, it always says there is an update needed
"ALTER TABLE tx_tmlunchmenu_meals ADD UNIQUE KEY unmi (date,meal);"

Even though it has already been added (by typo) already.

This is my ext_tables.php (relevant)
CREATE TABLE tx_tmlunchmenu_meals (
	uid int(11) unsigned DEFAULT '0' NOT NULL auto_increment,
	pid int(11) unsigned DEFAULT '0' NOT NULL,
	tstamp int(11) unsigned DEFAULT '0' NOT NULL,
	crdate int(11) unsigned DEFAULT '0' NOT NULL,
	cruser_id int(11) unsigned DEFAULT '0' NOT NULL,
	meal int(11) unsigned DEFAULT '0' NOT NULL,
	date int(11) DEFAULT '0' NOT NULL,
	items blob NOT NULL,
	
	PRIMARY KEY (uid),
	KEY parent (pid),
	UNIQUE KEY unmi (date,meal)
);

So, why won't typo3 take my key? Did I forget to add something somewhere?
The only file I modified was ext_tables.php.

Tony Murray
Internet Specialist
Buena Vista Regional Medical Center
tonym at bvrmc.org


	********************************************
This message and accompanying documents are covered by the Electronic
Communications Privacy Act, 18 U.S.C. ?? 2510-2521, and contain information
intended for the specified individual (s) only. This information is
confidential. If you are not the intended recipient or an agent responsible
for delivering it to the intended recipient, you are hereby notified that
you have received the document in error and that any review, dissemination,
copying, or the taking of any action based on the contents of this is
strictly prohibited. If you have received this communication in error,
please notify us immediately by email, and delete the original message.
	*********************************************