← Back to team overview

dhis2-devs team mailing list archive

[Branch ~dhis2-devs-core/dhis2/trunk] Rev 18992: Added index usermessage_userid and usermessage_isread

 

------------------------------------------------------------
revno: 18992
committer: Lars Helge Overland <larshelge@xxxxxxxxx>
branch nick: dhis2
timestamp: Thu 2015-04-23 14:28:34 +0200
message:
  Added index usermessage_userid and usermessage_isread
modified:
  dhis-2/dhis-services/dhis-service-core/src/main/java/org/hisp/dhis/message/DefaultMessageService.java
  dhis-2/dhis-services/dhis-service-core/src/main/resources/org/hisp/dhis/message/hibernate/UserMessage.hbm.xml


--
lp:dhis2
https://code.launchpad.net/~dhis2-devs-core/dhis2/trunk

Your team DHIS 2 developers is subscribed to branch lp:dhis2.
To unsubscribe from this branch go to https://code.launchpad.net/~dhis2-devs-core/dhis2/trunk/+edit-subscription
=== modified file 'dhis-2/dhis-services/dhis-service-core/src/main/java/org/hisp/dhis/message/DefaultMessageService.java'
--- dhis-2/dhis-services/dhis-service-core/src/main/java/org/hisp/dhis/message/DefaultMessageService.java	2015-03-27 18:24:40 +0000
+++ dhis-2/dhis-services/dhis-service-core/src/main/java/org/hisp/dhis/message/DefaultMessageService.java	2015-04-23 12:28:34 +0000
@@ -313,7 +313,7 @@
 
         MessageConversation mc = messageConversationStore.getByUid( uid );
 
-        if( mc == null )
+        if ( mc == null )
         {
             return null;
         }

=== modified file 'dhis-2/dhis-services/dhis-service-core/src/main/resources/org/hisp/dhis/message/hibernate/UserMessage.hbm.xml'
--- dhis-2/dhis-services/dhis-service-core/src/main/resources/org/hisp/dhis/message/hibernate/UserMessage.hbm.xml	2012-02-14 20:27:19 +0000
+++ dhis-2/dhis-services/dhis-service-core/src/main/resources/org/hisp/dhis/message/hibernate/UserMessage.hbm.xml	2015-04-23 12:28:34 +0000
@@ -15,9 +15,9 @@
     <property name="key" column="usermessagekey"/>
 
     <many-to-one name="user" class="org.hisp.dhis.user.User" column="userid" 
-	  foreign-key="fk_usermessage_user" not-null="true" />
+	  foreign-key="fk_usermessage_user" not-null="true" index="usermessage_userid" />
 
-    <property name="read" column="isread" not-null="true" />
+    <property name="read" column="isread" not-null="true" index="usermessage_isread" />
 
 	<property name="followUp" column="isfollowup" not-null="false" />