[TYPO3-english] Composite keys in ext_tables.sql
Viktor Livakivskyi
invisible.kinder at gmail.com
Wed Jun 26 17:04:31 CEST 2013
Hi, List.
Is there a way to manage komposite kayes for MySQL so Install Tool wouldn't complain, that definition is wrong and proposes to remove and recreate the key?
I have following in my ext_tables.sql:
CREATE TABLE tx_pxmytable (
uid int(11) NOT NULL auto_increment,
pid int(11) DEFAULT '0' NOT NULL,
entity_uid int(11) DEFAULT '0' NOT NULL,
user_uid int(11) DEFAULT '0' NOT NULL,
PRIMARY KEY (uid),
KEY parent (pid),
KEY entity (entity_uid, user_uid)
);
Install Tool complains about this line:
KEY entity (entity_uid, user_uid)
More information about the TYPO3-english
mailing list