diff options
Diffstat (limited to 'mayor-orig/install/base/mysql')
| -rw-r--r-- | mayor-orig/install/base/mysql/mayor-login.sql | 5 |
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; |