From 0a64797432f7b67fc56f033a63d580f950eaf690 Mon Sep 17 00:00:00 2001
From: Roland Haeder <roland@mxchange.org>
Date: Mon, 12 Oct 2015 18:19:53 +0200
Subject: [PATCH] created unique index on login name

---
 .../jusercore/model/user/LoginUser.java        | 18 ++++++++++++------
 1 file changed, 12 insertions(+), 6 deletions(-)

diff --git a/src/org/mxchange/jusercore/model/user/LoginUser.java b/src/org/mxchange/jusercore/model/user/LoginUser.java
index 17829cc..1ca353e 100644
--- a/src/org/mxchange/jusercore/model/user/LoginUser.java
+++ b/src/org/mxchange/jusercore/model/user/LoginUser.java
@@ -46,12 +46,18 @@ import org.mxchange.jusercore.model.user.status.UserAccountStatus;
 @Entity (name = "users")
 @Table (
 		name = "users",
-		indexes =
-		@Index (
-				name = "confirmation_key",
-				unique = true,
-				columnList = "user_confirm_key"
-		)
+		indexes = {
+			@Index (
+					name = "confirmation_key",
+					unique = true,
+					columnList = "user_confirm_key"
+			),
+			@Index (
+					name = "user_name",
+					unique = true,
+					columnList = "user_name"
+			)
+		}
 )
 @NamedQueries (
 		{
-- 
2.39.5