From 8f8fc390374681cd537e4216f0366d6fe8a6c73c Mon Sep 17 00:00:00 2001
From: M.Gergo
Date: Fri, 7 Sep 2018 22:27:52 +0200
Subject: Rev: 4358

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

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

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;
-- 
cgit v1.2.3