[openmeetings] 02/02: [OPENMEETINGS-2567] some indicies are added

[so...@apache.org]

This is an automated email from the ASF dual-hosted git repository.

solomax pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/openmeetings.git

commit cce6d10b50e4db2f60ce308da45cef48a630f52a
Author: Maxim Solodovnik <so...@gmail.com>
AuthorDate: Tue Feb 23 11:33:14 2021 +0700

    [OPENMEETINGS-2567] some indicies are added
---
 .../main/java/org/apache/openmeetings/db/entity/user/Address.java    | 5 ++++-
 .../src/main/java/org/apache/openmeetings/db/entity/user/User.java   | 1 +
 2 files changed, 5 insertions(+), 1 deletion(-)

diff --git a/openmeetings-db/src/main/java/org/apache/openmeetings/db/entity/user/Address.java b/openmeetings-db/src/main/java/org/apache/openmeetings/db/entity/user/Address.java
index bf01604..b60cec8 100644
--- a/openmeetings-db/src/main/java/org/apache/openmeetings/db/entity/user/Address.java
+++ b/openmeetings-db/src/main/java/org/apache/openmeetings/db/entity/user/Address.java
@@ -23,6 +23,7 @@ import javax.persistence.Entity;
 import javax.persistence.GeneratedValue;
 import javax.persistence.GenerationType;
 import javax.persistence.Id;
+import javax.persistence.Index;
 import javax.persistence.Lob;
 import javax.persistence.Table;
 import javax.xml.bind.annotation.XmlElement;
@@ -32,7 +33,9 @@ import javax.xml.bind.annotation.XmlTransient;
 import org.apache.openmeetings.db.entity.HistoricalEntity;
 
 @Entity
-@Table(name = "address")
+@Table(name = "address", indexes = {
+		@Index(name = "email_idx", columnList = "email")
+})
 @XmlRootElement(name = "address")
 public class Address extends HistoricalEntity {
 	private static final long serialVersionUID = 1L;
diff --git a/openmeetings-db/src/main/java/org/apache/openmeetings/db/entity/user/User.java b/openmeetings-db/src/main/java/org/apache/openmeetings/db/entity/user/User.java
index a39b8c4..d93f90f 100644
--- a/openmeetings-db/src/main/java/org/apache/openmeetings/db/entity/user/User.java
+++ b/openmeetings-db/src/main/java/org/apache/openmeetings/db/entity/user/User.java
@@ -121,6 +121,7 @@ import org.apache.wicket.util.string.Strings;
 		@Index(name = "login_idx", columnList = "login")
 		, @Index(name = "lastname_idx", columnList = "lastname")
 		, @Index(name = "firstname_idx", columnList = "firstname")
+		, @Index(name = "type_idx", columnList = "type")
 })
 @XmlRootElement(name = USER_NODE)
 public class User extends HistoricalEntity {