max key length is 1000 bytes
CREATE TABLE `_modules` (
`rid` int( 12 ) NOT NULL AUTO_INCREMENT ,
`module_name` varchar( 200 ) DEFAULT NULL ,
`module_controller` varchar( 200 ) DEFAULT NULL ,
`descr` text,
`owner_users_rid` int( 12 ) DEFAULT NULL ,
`createDT` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ,
`modifyDT` timestamp NULL DEFAULT NULL ,
`modifier_users_rid` int( 12 ) DEFAULT NULL ,
`archive` tinyint( 1 ) DEFAULT '0',
PRIMARY KEY ( `rid` ) ,
UNIQUE KEY `item_name` ( `module_name` , `module_controller` ) ,
KEY `FK__menu_items1` ( `modifier_users_rid` ) ,
KEY `FK__menu_items2` ( `owner_users_rid` ) ,
CONSTRAINT `FK__modules_1` FOREIGN KEY ( `modifier_users_rid` ) REFERENCES `_users` ( `rid` ) ON UPDATE CASCADE ,
CONSTRAINT `FK__modules_2` FOREIGN KEY ( `owner_users_rid` ) REFERENCES `_users` ( `rid` ) ON UPDATE CASCADE
) ENGINE = InnoDB AUTO_INCREMENT =40 DEFAULT CHARSET = utf8;

MySQL said: Documentation
#1071 - Specified key was too long; max key length is 1000 bytes 
max key length is 1000 bytes
===

CREATE TABLE `_modules` (
`rid` int( 12 ) NOT NULL AUTO_INCREMENT ,
`module_name` varchar( 200 ) DEFAULT NULL ,
`module_controller` varchar( 200 ) DEFAULT NULL ,
`descr` text,
`owner_users_rid` int( 12 ) DEFAULT NULL ,
`createDT` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ,
`modifyDT` timestamp NULL DEFAULT NULL ,
`modifier_users_rid` int( 12 ) DEFAULT NULL ,
`archive` tinyint( 1 ) DEFAULT '0',
PRIMARY KEY ( `rid` ) ,
UNIQUE KEY `item_name` ( `module_name` , `module_controller` ) ,
KEY `FK__menu_items1` ( `modifier_users_rid` ) ,
KEY `FK__menu_items2` ( `owner_users_rid` ) ,
CONSTRAINT `FK__modules_1` FOREIGN KEY ( `modifier_users_rid` ) REFERENCES `_users` ( `rid` ) ON UPDATE CASCADE ,
CONSTRAINT `FK__modules_2` FOREIGN KEY ( `owner_users_rid` ) REFERENCES `_users` ( `rid` ) ON UPDATE CASCADE
) ENGINE = InnoDB AUTO_INCREMENT =40 DEFAULT CHARSET = utf8;

MySQL said: Documentation
#1071 - Specified key was too long; max key length is 1000 bytes 