From 4151aba7656fb165c54f9b77553ce96f75a52d51 Mon Sep 17 00:00:00 2001 From: M.Gergo Date: Tue, 22 Sep 2020 14:30:03 +0200 Subject: Rev: 4683 --- .../mayor-naplo/install/module-naplo/mysql/intezmeny.sql | 12 ++++++------ 1 file changed, 6 insertions(+), 6 deletions(-) (limited to 'mayor-orig/mayor-naplo/install/module-naplo/mysql') 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ű', -- cgit v1.2.3