[PHPwestoz] [OT] MySQL UNIQUE INDEX

[Timothy White <weirdo@tigris.org>]

I know this isn't PHP but hopefully one of you guys will know the answer 
(and it is for a PHP project)
I am trying to create a table that has a primary key and a unique key 
based on different columns.
The query is:
CREATE TABLE library (
ID INT UNSIGNED NOT NULL AUTO_INCREMENT,
Filename TEXT NOT NULL,
Artist TEXT NULL,
Title TEXT NULL,
Album TEXT NULL,
FID TEXT(40) NOT NULL,
PRIMARY KEY ID (ID),
INDEX UID (FID)
) TYPE = MyISAM COMMENT ='';
And the error is:
ERROR 1170 (42000): BLOB/TEXT column 'FID' used in key specification 
without a key length
I can't find anything in the manual that tells me how to get around this.

Thanks

Tim

--
Tim White - Use the Fox, Luke!
PGP/GPG id: 602E944D, Pub Key Serv: subkeys.pgp.net
Fingerprint: 04C2 9682 B7B2 3006 009D  A9F3 067E EDCD 602E 944D
Hi! I'm a .signature virus! Copy me into your ~/.signature to help me spread!
--