Rev: 4455

1 files changed, 25 insertions, 0 deletions

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,