From c76a004b0135786f2742283f8d5f917106f58bd8 Mon Sep 17 00:00:00 2001 From: M.Gergo Date: Fri, 8 Mar 2019 20:51:30 +0100 Subject: Rev: 4455 --- mayor-orig/install/module-naplo/mysql/tanev.sql | 25 +++++++++++++++++++++++++ 1 file changed, 25 insertions(+) (limited to 'mayor-orig/install') diff --git a/mayor-orig/install/module-naplo/mysql/tanev.sql b/mayor-orig/install/module-naplo/mysql/tanev.sql index 0499a66c..23507fda 100644 --- a/mayor-orig/install/module-naplo/mysql/tanev.sql +++ b/mayor-orig/install/module-naplo/mysql/tanev.sql @@ -469,6 +469,31 @@ CREATE TABLE `hianyzasHozott` ( CONSTRAINT `hianyzasHozott_IBFK1` FOREIGN KEY (`diakId`) REFERENCES `%DB%`.`diak` (`diakId`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_hungarian_ci; +CREATE TABLE `hianyzasKreta` ( + `kretaHianyzasId` int(10) unsigned NOT NULL AUTO_INCREMENT, + `diakId` int(10) unsigned DEFAULT NULL, + `tankorId` int(10) unsigned DEFAULT NULL, + `kretaDiakNev` varchar(255) COLLATE utf8_hungarian_ci DEFAULT NULL, + `oId` bigint(20) unsigned DEFAULT NULL, + `dt` date DEFAULT NULL, + `ora` tinyint(3) unsigned DEFAULT NULL, + `kretaTankorNev` varchar(255) COLLATE utf8_hungarian_ci DEFAULT NULL, + `kretaTantargyNev` varchar(255) COLLATE utf8_hungarian_ci DEFAULT NULL, + `tipus` enum('hiányzás','késés','felszerelés hiány','felmentés','egyenruha hiány') COLLATE utf8_hungarian_ci DEFAULT NULL, + `perc` tinyint(3) unsigned DEFAULT NULL, + `kretaStatusz` enum('igen','nem') COLLATE utf8_hungarian_ci DEFAULT NULL, + `statusz` enum('igazolt','igazolatlan') COLLATE utf8_hungarian_ci DEFAULT NULL, + `kretaIgazolas` varchar(255) COLLATE utf8_hungarian_ci DEFAULT NULL, + `igazolas` enum('orvosi','szülői','osztályfőnöki','verseny','vizsga','igazgatói','hatósági','pályaválasztás','') COLLATE utf8_hungarian_ci DEFAULT NULL, + PRIMARY KEY (`kretaHianyzasId`), + KEY `hianyzasKreta_oId` (`oId`), + KEY `hianyzasKreta_diakId` (`diakId`), + KEY `hianyzasKreta_tankorId` (`tankorId`), + CONSTRAINT `hk_ibfk_1` FOREIGN KEY (`oId`) REFERENCES `intezmeny_vmg`.`diak` (`oId`) ON DELETE CASCADE ON UPDATE CASCADE, + CONSTRAINT `hk_ibfk_2` FOREIGN KEY (`diakId`) REFERENCES `intezmeny_vmg`.`diak` (`diakId`) ON DELETE CASCADE ON UPDATE CASCADE, + CONSTRAINT `hk_ibfk_3` FOREIGN KEY (`tankorId`) REFERENCES `intezmeny_vmg`.`tankor` (`tankorId`) ON DELETE CASCADE ON UPDATE CASCADE +) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_hungarian_ci; + CREATE TABLE `koszi` ( `kosziId` int(10) unsigned NOT NULL auto_increment, `kosziEsemenyId` int(10) unsigned NOT NULL, -- cgit v1.2.3