diff options
Diffstat (limited to 'mayor-orig/install/base/mysql/mayor-login.sql')
| -rw-r--r-- | mayor-orig/install/base/mysql/mayor-login.sql | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/mayor-orig/install/base/mysql/mayor-login.sql b/mayor-orig/install/base/mysql/mayor-login.sql index 556b28cc..bd81c318 100644 --- a/mayor-orig/install/base/mysql/mayor-login.sql +++ b/mayor-orig/install/base/mysql/mayor-login.sql @@ -171,3 +171,11 @@ CREATE TABLE loginLog_a ( flag tinyint(3) unsigned default NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE utf8_hungarian_ci; +CREATE TABLE `eduroam` ( + `userAccount` varchar(64) COLLATE utf8_hungarian_ci NOT NULL, + `policy` enum('public','parent','private') COLLATE utf8_hungarian_ci DEFAULT NULL, + `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 +) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_hungarian_ci; |