aboutsummaryrefslogtreecommitdiffstats
path: root/mayor-orig/install
diff options
context:
space:
mode:
authorM.Gergo2018-12-16 16:35:17 +0100
committerM.Gergo2018-12-16 16:35:17 +0100
commite6988247360fa98b85915a38803d018dd353df00 (patch)
tree24f42628f6cdaedacc06ce033378173a0e561be9 /mayor-orig/install
parent2a219b9ea312fb88703a33ea2450e32af40be64a (diff)
downloadmayor-e6988247360fa98b85915a38803d018dd353df00.tar.gz
mayor-e6988247360fa98b85915a38803d018dd353df00.zip
Rev: 4412
Diffstat (limited to 'mayor-orig/install')
-rw-r--r--mayor-orig/install/base/mysql/mayor-login.sql5
-rw-r--r--mayor-orig/install/module-naplo/mysql/intezmeny.sql1
2 files changed, 5 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;
diff --git a/mayor-orig/install/module-naplo/mysql/intezmeny.sql b/mayor-orig/install/module-naplo/mysql/intezmeny.sql
index ce4fcbd3..5947c72f 100644
--- a/mayor-orig/install/module-naplo/mysql/intezmeny.sql
+++ b/mayor-orig/install/module-naplo/mysql/intezmeny.sql
@@ -283,6 +283,7 @@ CREATE TABLE `tanar` (
`titulus` varchar(32) COLLATE utf8_hungarian_ci DEFAULT '',
`titulusRovid` varchar(10) COLLATE utf8_hungarian_ci DEFAULT '',
`email` varchar(64) COLLATE utf8_hungarian_ci DEFAULT '',
+ `kretaNev` varchar(64) COLLATE utf8_hungarian_ci DEFAULT NULL,
PRIMARY KEY (`tanarId`),
UNIQUE KEY `tanarOid` (`oId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_hungarian_ci;