INSERT INTO `uni_tabla_log` (tabla,frissitve) VALUES ('global_domain','{DATUM_MOST}');DROP TRIGGER IF EXISTS `trg_global_domain_ai`;CREATE TRIGGER `TR_global_domain_AI` AFTER INSERT ON `global_domain` FOR EACH ROW UPDATE `uni_tabla_log` SET frissitve=NOW() WHERE tabla='global_domain';DROP TRIGGER IF EXISTS `trg_global_domain_ai`;CREATE TRIGGER `TR_global_domain_AI` AFTER UPDATE ON `global_domain` FOR EACH ROW UPDATE `uni_tabla_log` SET frissitve=NOW() WHERE tabla='global_domain';DROP TRIGGER IF EXISTS `trg_global_domain_ai`;CREATE TRIGGER `TR_global_domain_AI` AFTER DELETE ON `global_domain` FOR EACH ROW DELETE `uni_tabla_log` SET frissitve=NOW() WHERE tabla='global_domain';INSERT INTO `uni_tabla_log` (tabla,frissitve) VALUES ('global_domain','{DATUM_MOST}');DROP TRIGGER IF EXISTS `trg_global_domain_ai`;CREATE TRIGGER `TR_global_domain_AI` AFTER INSERT ON `global_domain` FOR EACH ROW UPDATE `uni_tabla_log` SET frissitve=NOW() WHERE tabla='global_domain';DROP TRIGGER IF EXISTS `trg_global_domain_ai`;CREATE TRIGGER `TR_global_domain_AI` AFTER UPDATE ON `global_domain` FOR EACH ROW UPDATE `uni_tabla_log` SET frissitve=NOW() WHERE tabla='global_domain';DROP TRIGGER IF EXISTS `trg_global_domain_ai`;CREATE TRIGGER `TR_global_domain_AI` AFTER DELETE ON `global_domain` FOR EACH ROW DELETE `uni_tabla_log` SET frissitve=NOW() WHERE tabla='global_domain';INSERT INTO `uni_tabla_log` (tabla,frissitve) VALUES ('uni_szotarak','{DATUM_MOST}');DROP TRIGGER IF EXISTS `trg_uni_szotarak_ai`;CREATE TRIGGER `TR_uni_szotarak_AI` AFTER INSERT ON `uni_szotarak` FOR EACH ROW UPDATE `uni_tabla_log` SET frissitve=NOW() WHERE tabla='uni_szotarak';DROP TRIGGER IF EXISTS `trg_uni_szotarak_ai`;CREATE TRIGGER `TR_uni_szotarak_AI` AFTER UPDATE ON `uni_szotarak` FOR EACH ROW UPDATE `uni_tabla_log` SET frissitve=NOW() WHERE tabla='uni_szotarak';DROP TRIGGER IF EXISTS `trg_uni_szotarak_ai`;CREATE TRIGGER `TR_uni_szotarak_AI` AFTER DELETE ON `uni_szotarak` FOR EACH ROW DELETE `uni_tabla_log` SET frissitve=NOW() WHERE tabla='uni_szotarak';INSERT INTO `uni_tabla_log` (tabla,frissitve) VALUES ('global_ws_egyseg','{DATUM_MOST}');DROP TRIGGER IF EXISTS `trg_global_ws_egyseg_ai`;CREATE TRIGGER `TR_global_ws_egyseg_AI` AFTER INSERT ON `global_ws_egyseg` FOR EACH ROW UPDATE `uni_tabla_log` SET frissitve=NOW() WHERE tabla='global_ws_egyseg';DROP TRIGGER IF EXISTS `trg_global_ws_egyseg_ai`;CREATE TRIGGER `TR_global_ws_egyseg_AI` AFTER UPDATE ON `global_ws_egyseg` FOR EACH ROW UPDATE `uni_tabla_log` SET frissitve=NOW() WHERE tabla='global_ws_egyseg';DROP TRIGGER IF EXISTS `trg_global_ws_egyseg_ai`;CREATE TRIGGER `TR_global_ws_egyseg_AI` AFTER DELETE ON `global_ws_egyseg` FOR EACH ROW DELETE `uni_tabla_log` SET frissitve=NOW() WHERE tabla='global_ws_egyseg';INSERT INTO `uni_tabla_log` (tabla,frissitve) VALUES ('global_ws_afa','{DATUM_MOST}');DROP TRIGGER IF EXISTS `trg_global_ws_afa_ai`;CREATE TRIGGER `TR_global_ws_afa_AI` AFTER INSERT ON `global_ws_afa` FOR EACH ROW UPDATE `uni_tabla_log` SET frissitve=NOW() WHERE tabla='global_ws_afa';DROP TRIGGER IF EXISTS `trg_global_ws_afa_ai`;CREATE TRIGGER `TR_global_ws_afa_AI` AFTER UPDATE ON `global_ws_afa` FOR EACH ROW UPDATE `uni_tabla_log` SET frissitve=NOW() WHERE tabla='global_ws_afa';DROP TRIGGER IF EXISTS `trg_global_ws_afa_ai`;CREATE TRIGGER `TR_global_ws_afa_AI` AFTER DELETE ON `global_ws_afa` FOR EACH ROW DELETE `uni_tabla_log` SET frissitve=NOW() WHERE tabla='global_ws_afa';
?
Nyomtatási lehetőségek
? FEJLESZTÉS ALATT! / UNDER CONSTRUCTION! ONDEPU CMS