aboutsummaryrefslogtreecommitdiffstats
path: root/mayor-orig/install/base/mysql
diff options
context:
space:
mode:
authorM.Gergo2018-09-07 22:27:52 +0200
committerM.Gergo2018-09-07 22:27:52 +0200
commit8f8fc390374681cd537e4216f0366d6fe8a6c73c (patch)
tree6d19efd3593a0383a48cdac7f78cd0e2ef6fa761 /mayor-orig/install/base/mysql
parent63edef615f7828cb0f57bf9ba128a90eb4fe07e0 (diff)
downloadmayor-8f8fc390374681cd537e4216f0366d6fe8a6c73c.tar.gz
mayor-8f8fc390374681cd537e4216f0366d6fe8a6c73c.zip
Rev: 4358
Diffstat (limited to 'mayor-orig/install/base/mysql')
-rw-r--r--mayor-orig/install/base/mysql/mayor-login.sql8
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;