При первоначальной инициализации схемы MySQL порталом (Liferay Portal 6.2) в логе наблюдаются следующие ошибки создания индексов:
...
19:29:12,053 WARN [qtp401625763-22][BaseDB:457] Specified key was too long; max key length is 767 bytes: create index IX_7020130F on SCProductVersion (directDownloadURL);
19:29:12,055 ERROR [qtp401625763-22][BaseDB:464] create index IX_7020130F on SCProductVersion (directDownloadURL);
19:29:53,464 WARN [qtp401625763-22][BaseDB:457] Specified key was too long; max key length is 767 bytes: create index IX_89509087 on User_ (companyId, openId);
19:29:53,465 ERROR [qtp401625763-22][BaseDB:464] create index IX_89509087 on User_ (companyId, openId);
...
19:30:38,349 WARN [qtp401625763-22][BaseDB:457] Specified key was too long; max key length is 767 bytes: create index IX_5848F52D on Marketplace_Module (appId, bundleSymbolicName, bundleVersion);
19:30:38,350 ERROR [qtp401625763-22][BaseDB:464] create index IX_5848F52D on Marketplace_Module (appId, bundleSymbolicName, bundleVersion);
19:30:38,545 WARN [qtp401625763-22][BaseDB:457] Specified key was too long; max key length is 767 bytes: create index IX_DD03D499 on Marketplace_Module (bundleSymbolicName);
19:30:38,546 ERROR [qtp401625763-22][BaseDB:464] create index IX_DD03D499 on Marketplace_Module (bundleSymbolicName);
...
19:30:57,217 WARN [qtp401625763-22][BaseDB:457] BLOB/TEXT column 'name' used in key specification without a key length: create index IX_2C5184D4 on CalendarResource (companyId, name, active_);
19:30:57,737 WARN [qtp401625763-22][BaseDB:457] BLOB/TEXT column 'name' used in key specification without a key length: create index IX_B9EA8C92 on CalendarResource (groupId, name, active_);
...
19:31:28,770 WARN [qtp401625763-22][BaseDB:457] BLOB/TEXT column 'url' used in key specification without a key length: create unique index IX_A6A89EB1 on OpenSocial_Gadget (companyId, url);
...
полный лог файл прилагается.
Это можно поправить средствами Liferay или нужно писать дополнительный скрипт досоздающий индексы?
