diff options
| author | M.Gergo | 2021-02-20 03:22:41 +0100 |
|---|---|---|
| committer | M.Gergo | 2021-02-20 03:22:41 +0100 |
| commit | e472633f696d7e913b36875b258f4d45167388cc (patch) | |
| tree | e91387703cbcca7835f452d162fb27a4eac8ab50 /mayor-orig/mayor-naplo/install | |
| parent | cf6a58003f47139501a2907f8a4bc400b23fda66 (diff) | |
| parent | fb24a50c54d5776468e49def08aea44c4077eb47 (diff) | |
| download | mayor-e472633f696d7e913b36875b258f4d45167388cc.tar.gz mayor-e472633f696d7e913b36875b258f4d45167388cc.zip | |
Az eredeti forráskódok frissítve a http://mayor.hu -ról
Diffstat (limited to 'mayor-orig/mayor-naplo/install')
| -rw-r--r-- | mayor-orig/mayor-naplo/install/module-naplo/mysql/intezmeny.sql | 12 |
1 files changed, 6 insertions, 6 deletions
diff --git a/mayor-orig/mayor-naplo/install/module-naplo/mysql/intezmeny.sql b/mayor-orig/mayor-naplo/install/module-naplo/mysql/intezmeny.sql index 1912a862..8254eb20 100644 --- a/mayor-orig/mayor-naplo/install/module-naplo/mysql/intezmeny.sql +++ b/mayor-orig/mayor-naplo/install/module-naplo/mysql/intezmeny.sql @@ -68,10 +68,10 @@ CREATE TABLE `telephely` ( CREATE TABLE `szulo` ( `szuloId` int(10) unsigned NOT NULL AUTO_INCREMENT, - `nevElotag` varchar(8) COLLATE utf8_hungarian_ci NOT NULL DEFAULT '', + `nevElotag` varchar(8) COLLATE utf8_hungarian_ci DEFAULT '', `csaladinev` varchar(64) COLLATE utf8_hungarian_ci NOT NULL DEFAULT '', `utonev` varchar(64) COLLATE utf8_hungarian_ci NOT NULL DEFAULT '', - `szuleteskoriNevElotag` varchar(8) COLLATE utf8_hungarian_ci NOT NULL DEFAULT '', + `szuleteskoriNevElotag` varchar(8) COLLATE utf8_hungarian_ci DEFAULT '', `szuleteskoriCsaladinev` varchar(32) COLLATE utf8_hungarian_ci NOT NULL DEFAULT '', `szuleteskoriUtonev` varchar(32) COLLATE utf8_hungarian_ci NOT NULL DEFAULT '', `nem` enum('fiú','lány') COLLATE utf8_hungarian_ci DEFAULT NULL, @@ -102,10 +102,10 @@ CREATE TABLE `diak` ( `adoazonosito` bigint(10) unsigned zerofill DEFAULT NULL, `szemelyiIgazolvanySzam` varchar(16) COLLATE utf8_hungarian_ci DEFAULT NULL, `tartozkodasiOkiratSzam` varchar(16) COLLATE utf8_hungarian_ci DEFAULT NULL, - `viseltNevElotag` varchar(8) COLLATE utf8_hungarian_ci NOT NULL DEFAULT '', + `viseltNevElotag` varchar(8) COLLATE utf8_hungarian_ci DEFAULT '', `viseltCsaladinev` varchar(64) COLLATE utf8_hungarian_ci NOT NULL DEFAULT '', `viseltUtonev` varchar(64) COLLATE utf8_hungarian_ci NOT NULL DEFAULT '', - `szuleteskoriNevElotag` varchar(8) COLLATE utf8_hungarian_ci NOT NULL DEFAULT '', + `szuleteskoriNevElotag` varchar(8) COLLATE utf8_hungarian_ci DEFAULT '', `szuleteskoriCsaladinev` varchar(64) COLLATE utf8_hungarian_ci NOT NULL DEFAULT '', `szuleteskoriUtonev` varchar(64) COLLATE utf8_hungarian_ci NOT NULL DEFAULT '', `szuletesiHely` varchar(32) COLLATE utf8_hungarian_ci DEFAULT NULL, @@ -263,7 +263,7 @@ CREATE TABLE `tanar` ( `oId` bigint(20) unsigned DEFAULT NULL, `beDt` date DEFAULT NULL, `kiDt` date DEFAULT NULL, - `viseltNevElotag` varchar(8) COLLATE utf8_hungarian_ci DEFAULT NULL, + `viseltNevElotag` varchar(8) COLLATE utf8_hungarian_ci DEFAULT '', `viseltCsaladinev` varchar(64) COLLATE utf8_hungarian_ci NOT NULL DEFAULT '', `viseltUtonev` varchar(64) COLLATE utf8_hungarian_ci NOT NULL DEFAULT '', `szuletesiHely` varchar(16) COLLATE utf8_hungarian_ci DEFAULT NULL, @@ -271,7 +271,7 @@ CREATE TABLE `tanar` ( `dn` varchar(128) COLLATE utf8_hungarian_ci DEFAULT NULL, `szuleteskoriUtonev` varchar(64) COLLATE utf8_hungarian_ci NOT NULL DEFAULT '', `szuleteskoriCsaladinev` varchar(64) COLLATE utf8_hungarian_ci NOT NULL DEFAULT '', - `szuleteskoriNevElotag` varchar(8) COLLATE utf8_hungarian_ci NOT NULL DEFAULT '', + `szuleteskoriNevElotag` varchar(8) COLLATE utf8_hungarian_ci DEFAULT '', `hetiMunkaora` decimal(3,1) DEFAULT '0.0', `NEKAzonosito` varchar(16) COLLATE utf8_hungarian_ci DEFAULT NULL, `statusz` enum('határozatlan idejű','határozott idejű','tartósan távol','jogviszonya lezárva','külső óraadó') COLLATE utf8_hungarian_ci DEFAULT 'határozatlan idejű', |