16 Nov
2006
16 Nov
'06
3:05 p.m.
Hi Nicolas,
I think the solution will be to have a primary key a simple unsigned int
outincrement field in the table and move the primary key as unique.
I will ask Anca to do this change as most probably it will be a good
idea to do it for the rest of the tables also.
regards,
Bogdan
Nicolas Palix wrote:
Hi,
The primary key of the watchers is too long with this version of MySQL:
"Specified key was too long; max key length is 1000 bytes"
Downgrading "[pw]_domain" from 128 to 96. Works.
CREATE TABLE `watchers` (
`p_user` varchar(64) NOT NULL,
`p_domain` varchar(96) NOT NULL,
`w_user` varchar(64) NOT NULL,
`w_domain` varchar(96) NOT NULL,
`subs_status` varchar(64) NOT NULL,
`reason` varchar(64) NOT NULL,
PRIMARY KEY (`p_user`,`p_domain`,`w_user`,`w_domain`)
) ENGINE=MyISAM;
Regards