aboutsummaryrefslogtreecommitdiffstats
path: root/mayor-orig/install/base
diff options
context:
space:
mode:
Diffstat (limited to 'mayor-orig/install/base')
-rw-r--r--mayor-orig/install/base/mysql/mayor-login.sql5
1 files changed, 4 insertions, 1 deletions
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;