diff options
author | M.Gergo | 2019-03-08 20:51:30 +0100 |
---|---|---|
committer | M.Gergo | 2019-03-08 20:51:30 +0100 |
commit | c76a004b0135786f2742283f8d5f917106f58bd8 (patch) | |
tree | 9d824a86cd5f92c45461d7b4f8160b27527b4f7d /mayor-orig/install/module-naplo | |
parent | 3dab26c6797b32926287f22a041380080551060b (diff) | |
download | mayor-c76a004b0135786f2742283f8d5f917106f58bd8.tar.gz mayor-c76a004b0135786f2742283f8d5f917106f58bd8.zip |
Rev: 4455
Diffstat (limited to 'mayor-orig/install/module-naplo')
-rw-r--r-- | mayor-orig/install/module-naplo/mysql/tanev.sql | 25 |
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, |