aboutsummaryrefslogtreecommitdiffstats
path: root/mayor-orig/install
diff options
context:
space:
mode:
authorM.Gergo2019-03-08 20:51:30 +0100
committerM.Gergo2019-03-08 20:51:30 +0100
commitc76a004b0135786f2742283f8d5f917106f58bd8 (patch)
tree9d824a86cd5f92c45461d7b4f8160b27527b4f7d /mayor-orig/install
parent3dab26c6797b32926287f22a041380080551060b (diff)
downloadmayor-c76a004b0135786f2742283f8d5f917106f58bd8.tar.gz
mayor-c76a004b0135786f2742283f8d5f917106f58bd8.zip
Rev: 4455
Diffstat (limited to 'mayor-orig/install')
-rw-r--r--mayor-orig/install/module-naplo/mysql/tanev.sql25
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,