Add database index on treeIndex #4105

diff --git a/cdmlib-model/src/main/java/eu/etaxonomy/cdm/model/description/FeatureNode.java b/cdmlib-model/src/main/java/eu/etaxonomy/cdm/model/description/FeatureNode.java
index 0ac281a329a1ea899ff1a628f0f5192e060c4342..8c4e2f33954b551e552023d9de86d775e80b3bcc 100644 (file)
--- a/cdmlib-model/src/main/java/eu/etaxonomy/cdm/model/description/FeatureNode.java
+++ b/cdmlib-model/src/main/java/eu/etaxonomy/cdm/model/description/FeatureNode.java
@@ -37,6 +37,8 @@ import javax.xml.bind.annotation.XmlType;
 import org.apache.log4j.Logger;
 import org.hibernate.annotations.Cascade;
 import org.hibernate.annotations.CascadeType;
+import org.hibernate.annotations.Index;
+import org.hibernate.annotations.Table;
 import org.hibernate.envers.Audited;
 
 import eu.etaxonomy.cdm.model.common.ITreeNode;
@@ -69,6 +71,7 @@ import eu.etaxonomy.cdm.model.common.VersionableEntity;
 @XmlRootElement(name = "FeatureNode")
 @Entity
 @Audited
+@Table(appliesTo="FeatureNode", indexes = { @Index(name = "featureNodeTreeIndex", columnNames = { "treeIndex" }) })
 public class FeatureNode extends VersionableEntity implements ITreeNode<FeatureNode>, Cloneable {
        private static final Logger logger = Logger.getLogger(FeatureNode.class);
        

diff --git a/cdmlib-model/src/main/java/eu/etaxonomy/cdm/model/taxon/TaxonNode.java b/cdmlib-model/src/main/java/eu/etaxonomy/cdm/model/taxon/TaxonNode.java
index 26acac523cb0e653bcf74eaa2feee6008040b4bb..d1a8bd4daf78ae54ff14cf978b64b8a550a6eeb3 100644 (file)
--- a/cdmlib-model/src/main/java/eu/etaxonomy/cdm/model/taxon/TaxonNode.java
+++ b/cdmlib-model/src/main/java/eu/etaxonomy/cdm/model/taxon/TaxonNode.java
@@ -35,6 +35,8 @@ import javax.xml.bind.annotation.XmlType;
 import org.apache.log4j.Logger;\r
 import org.hibernate.annotations.Cascade;\r
 import org.hibernate.annotations.CascadeType;\r
+import org.hibernate.annotations.Index;\r
+import org.hibernate.annotations.Table;\r
 import org.hibernate.envers.Audited;\r
 import org.hibernate.search.annotations.ContainedIn;\r
 import org.hibernate.search.annotations.Indexed;\r
@@ -67,6 +69,7 @@ import eu.etaxonomy.cdm.model.reference.Reference;
 @Entity\r
 @Indexed(index = "eu.etaxonomy.cdm.model.taxon.TaxonNode")\r
 @Audited\r
+@Table(appliesTo="TaxonNode", indexes = { @Index(name = "taxonNodeTreeIndex", columnNames = { "treeIndex" }) })\r
 public class TaxonNode extends AnnotatableEntity implements ITaxonTreeNode, ITreeNode<TaxonNode>, Cloneable{\r
     private static final long serialVersionUID = -4743289894926587693L;\r
     private static final Logger logger = Logger.getLogger(TaxonNode.class);\r