From 4c6b313fae97ccb7eaae75b5d05881f10469e13d Mon Sep 17 00:00:00 2001
From: M.Gergo
Date: Tue, 31 Mar 2020 19:30:03 +0200
Subject: Rev: 4644

---
 mayor-orig/mayor-naplo/install/module-naplo/mysql/tanev.sql | 2 ++
 1 file changed, 2 insertions(+)

(limited to 'mayor-orig/mayor-naplo/install')

diff --git a/mayor-orig/mayor-naplo/install/module-naplo/mysql/tanev.sql b/mayor-orig/mayor-naplo/install/module-naplo/mysql/tanev.sql
index efe43f5d..f8d78259 100644
--- a/mayor-orig/mayor-naplo/install/module-naplo/mysql/tanev.sql
+++ b/mayor-orig/mayor-naplo/install/module-naplo/mysql/tanev.sql
@@ -148,8 +148,10 @@ CREATE TABLE `oraHazifeladat` (
   `oraId` int(10) unsigned DEFAULT NULL,
   `hazifeladatLeiras` text COLLATE utf8_hungarian_ci NOT NULL,
   `hazifeladatFeltoltesEngedely` tinyint(3) unsigned DEFAULT '0',
+  `hazifeladatHataridoDt` datetime DEFAULT NULL,
   PRIMARY KEY (`hazifeladatId`),
   UNIQUE KEY `oraId` (`oraId`),
+  KEY `hazifeladatHataridoDt` (`hazifeladatHataridoDt`),
   CONSTRAINT `oraHazifeladat_ibfk_1` FOREIGN KEY (`oraId`) REFERENCES `ora` (`oraId`) ON DELETE CASCADE ON UPDATE CASCADE
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_hungarian_ci;
 
-- 
cgit v1.2.3