IP : 3.147.60.192Hostname : host45.registrar-servers.comKernel : Linux host45.registrar-servers.com 4.18.0-513.18.1.lve.2.el8.x86_64 #1 SMP Sat Mar 30 15:36:11 UTC 2024 x86_64Disable Function : None :) OS : Linux
PATH:
/
home/
../
var/
lib/
../
softaculous/
redax/
../
piwik/
../
moodle44/
../
selfoss/
selfoss.sql/
/
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; SET time_zone = "+00:00";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */;
-- -- Triggers `[[dbprefix]]items` -- DROP TRIGGER IF EXISTS `[[dbprefix]]items_insert_trigger`; DELIMITER // CREATE TRIGGER `[[dbprefix]]items_insert_trigger` BEFORE INSERT ON `[[dbprefix]]items` FOR EACH ROW BEGIN SET NEW.updatetime = NOW(); SET NEW.lastseen = NOW(); END // DELIMITER ; DROP TRIGGER IF EXISTS `[[dbprefix]]items_update_trigger`; DELIMITER // CREATE TRIGGER `[[dbprefix]]items_update_trigger` BEFORE UPDATE ON `[[dbprefix]]items` FOR EACH ROW BEGIN IF ( OLD.unread <> NEW.unread OR OLD.starred <> NEW.starred ) THEN SET NEW.updatetime = NOW(); END IF; END // DELIMITER ;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;