You are viewing a plain text version of this content. The canonical link for it is here.
Posted to jetspeed-dev@portals.apache.org by at...@apache.org on 2008/09/24 09:22:43 UTC
svn commit: r698443 -
/portals/jetspeed-2/portal/branches/security-refactoring/jetspeed-portal-resources/src/main/ddl-schema/security-schema.xml
Author: ate
Date: Wed Sep 24 00:22:42 2008
New Revision: 698443
URL: http://svn.apache.org/viewvc?rev=698443&view=rev
Log:
Replacing security attribute index on both name and value by an index on name alone.
MySQL cannot handle indexes which key is more than 1000 bytes in total... so was breaking on this index definition.
The additional benefit of an index on both name and value probably wouldn't be very significant anyway.
Modified:
portals/jetspeed-2/portal/branches/security-refactoring/jetspeed-portal-resources/src/main/ddl-schema/security-schema.xml
Modified: portals/jetspeed-2/portal/branches/security-refactoring/jetspeed-portal-resources/src/main/ddl-schema/security-schema.xml
URL: http://svn.apache.org/viewvc/portals/jetspeed-2/portal/branches/security-refactoring/jetspeed-portal-resources/src/main/ddl-schema/security-schema.xml?rev=698443&r1=698442&r2=698443&view=diff
==============================================================================
--- portals/jetspeed-2/portal/branches/security-refactoring/jetspeed-portal-resources/src/main/ddl-schema/security-schema.xml (original)
+++ portals/jetspeed-2/portal/branches/security-refactoring/jetspeed-portal-resources/src/main/ddl-schema/security-schema.xml Wed Sep 24 00:22:42 2008
@@ -74,9 +74,8 @@
<column name="PRINCIPAL_ID" primaryKey="true" required="true" type="INTEGER"/>
<column name="ATTR_NAME" primaryKey="true" required="true" size="200" type="VARCHAR"/>
<column name="ATTR_VALUE" size="1000" type="VARCHAR"/>
- <index name="IX_NAMEVALUE_LOOKUP">
+ <index name="IX_NAME_LOOKUP">
<index-column name="ATTR_NAME"/>
- <index-column name="ATTR_VALUE"/>
</index>
<foreign-key foreignTable="SECURITY_PRINCIPAL" name="FK_PRINCIPAL_ATTR" onDelete="cascade">
<reference foreign="PRINCIPAL_ID" local="PRINCIPAL_ID"/>
---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-dev-unsubscribe@portals.apache.org
For additional commands, e-mail: jetspeed-dev-help@portals.apache.org