portals-jetspeed-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From a..@apache.org
Subject svn commit: r687477 - /portals/jetspeed-2/portal/branches/JS2-869/jetspeed-portal-resources/src/main/ddl-schema/registry-schema.xml
Date Wed, 20 Aug 2008 21:42:15 GMT
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


Mime
View raw message