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