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/08/20 23:42:15 UTC
svn commit: r687477 -
/portals/jetspeed-2/portal/branches/JS2-869/jetspeed-portal-resources/src/main/ddl-schema/registry-schema.xml
Author: ate
Date: Wed Aug 20 14:42:14 2008
New Revision: 687477
URL: http://svn.apache.org/viewvc?rev=687477&view=rev
Log:
adding missing unique index for prefs(application_name,portlet_name,name) which also covers the previous non-unique index on only (application_name,portlet_name)
Modified:
portals/jetspeed-2/portal/branches/JS2-869/jetspeed-portal-resources/src/main/ddl-schema/registry-schema.xml
Modified: portals/jetspeed-2/portal/branches/JS2-869/jetspeed-portal-resources/src/main/ddl-schema/registry-schema.xml
URL: http://svn.apache.org/viewvc/portals/jetspeed-2/portal/branches/JS2-869/jetspeed-portal-resources/src/main/ddl-schema/registry-schema.xml?rev=687477&r1=687476&r2=687477&view=diff
==============================================================================
--- portals/jetspeed-2/portal/branches/JS2-869/jetspeed-portal-resources/src/main/ddl-schema/registry-schema.xml (original)
+++ portals/jetspeed-2/portal/branches/JS2-869/jetspeed-portal-resources/src/main/ddl-schema/registry-schema.xml Wed Aug 20 14:42:14 2008
@@ -151,10 +151,19 @@
<column name="PORTLET_NAME" required="true" size="80" type="VARCHAR"/>
<column name="NAME" required="true" size="254" type="VARCHAR"/>
+ <!-- non-unique index on APPLICATION_NAME,PORTLET_NAME shouldn't be needed as its already
+ "covered" by unique index on APPLICATION_NAME,PORTLET_NAME,NAME
<index name="IX_PORTLET_PREFERENCE">
<index-column name="APPLICATION_NAME"/>
<index-column name="PORTLET_NAME"/>
</index>
+ -->
+ <unique name="UIX_PORTLET_PREFERENCE">
+ <unique-column name="APPLICATION_NAME"/>
+ <unique-column name="PORTLET_NAME"/>
+ <unique-column name="NAME"/>
+ </unique>
+
</table>
<table name="PORTLET_PREFERENCE_VALUE">
---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-dev-unsubscribe@portals.apache.org
For additional commands, e-mail: jetspeed-dev-help@portals.apache.org