From e6988247360fa98b85915a38803d018dd353df00 Mon Sep 17 00:00:00 2001
From: M.Gergo
Date: Sun, 16 Dec 2018 16:35:17 +0100
Subject: Rev: 4412

---
 mayor-orig/install/base/mysql/mayor-login.sql | 5 ++++-
 1 file changed, 4 insertions(+), 1 deletion(-)

(limited to 'mayor-orig/install/base/mysql/mayor-login.sql')

diff --git a/mayor-orig/install/base/mysql/mayor-login.sql b/mayor-orig/install/base/mysql/mayor-login.sql
index bd81c318..d0f12845 100644
--- a/mayor-orig/install/base/mysql/mayor-login.sql
+++ b/mayor-orig/install/base/mysql/mayor-login.sql
@@ -177,5 +177,8 @@ CREATE TABLE `eduroam` (
     `eduroamUID` varchar(32)  COLLATE utf8_hungarian_ci NOT NULL,
     `eduroamPASSWORD` varchar(128) COLLATE utf8_hungarian_ci NOT NULL,
     `eduroamAFFILIATION` ENUM ('staff','faculty','student','') DEFAULT '',
-    `modositasDt` datetime DEFAULT NULL
+    `eduroamDOMAIN` varchar(128) COLLATE utf8_hungarian_ci NOT NULL,
+    `modositasDt` datetime DEFAULT NULL,
+  UNIQUE KEY `eduroamUID` (`eduroamUID`),
+  UNIQUE KEY `userAccount` (`userAccount`,`policy`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_hungarian_ci;
-- 
cgit v1.2.3

