[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