diff options
| author | M.Gergo | 2018-12-16 16:35:17 +0100 |
|---|---|---|
| committer | M.Gergo | 2018-12-16 16:35:17 +0100 |
| commit | e6988247360fa98b85915a38803d018dd353df00 (patch) | |
| tree | 24f42628f6cdaedacc06ce033378173a0e561be9 /mayor-orig/install | |
| parent | 2a219b9ea312fb88703a33ea2450e32af40be64a (diff) | |
| download | mayor-e6988247360fa98b85915a38803d018dd353df00.tar.gz mayor-e6988247360fa98b85915a38803d018dd353df00.zip | |
Rev: 4412
Diffstat (limited to 'mayor-orig/install')
| -rw-r--r-- | mayor-orig/install/base/mysql/mayor-login.sql | 5 | ||||
| -rw-r--r-- | mayor-orig/install/module-naplo/mysql/intezmeny.sql | 1 |
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; |