BlackCat CMS Forum

Code: Alles auswählen

REATE TABLE IF NOT EXISTS `:prefix:mod_courseEntry` (
    `entryID` int(11) unsigned NOT NULL AUTO_INCREMENT,
    `courseID` int(11) unsigned NOT NULL,
    `content` text NULL,
    `text` text NULL,
    `modified` DATETIME NULL,
    `created` TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    `userID` int(11) unsigned NULL,
    `seoURL` varchar(255) NOT NULL DEFAULT '',
    `position` smallint(11) unsigned NULL DEFAULT '1',
    PRIMARY KEY (`entryID`),
    CONSTRAINT `courses` FOREIGN KEY (`courseID`) REFERENCES `:prefix:mod_course`(`courseID`) ON DELETE CASCADE,
    CONSTRAINT `user` FOREIGN KEY (`userID`) REFERENCES `:prefix:users`(`user_id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

Code: Alles auswählen

CREATE TRIGGER `courseEntryUpdate` BEFORE UPDATE ON `:prefix:mod_courseEntry` FOR EACH ROW
    IF NOT UPDATE(position) BEGIN
        SET NEW.modified = CURRENT_TIMESTAMP
    END;

Code: Alles auswählen

CREATE TRIGGER `courseEntryUpdate` BEFORE UPDATE ON `mod_courseentry` FOR EACH ROW
IF NEW.position != OLD.position THEN
		BEGIN
			SET NEW.modified = CURRENT_TIMESTAMP();
		END;
END IF

Code: Alles auswählen

BEGIN
	DECLARE mychanged INT DEFAULT 0;
	IF NEW.entryID != OLD.entryID OR NEW.courseID != OLD.courseID OR NEW.content != OLD.content
		THEN SET mychanged = 1;
	END IF;

	IF mychanged = 1 THEN
			SET NEW.modified = CURRENT_TIMESTAMP();
	END IF;
END

Code: Alles auswählen

DELIMITER //
DROP TRIGGER IF EXISTS `courseEntryUpdate`//
CREATE TRIGGER `courseEntryUpdate` BEFORE UPDATE ON `mod_courseentry` FOR EACH ROW BEGIN
	IF NEW.entryID != OLD.entryID OR NEW.text != OLD.text OR NEW.seoURL != OLD.seoURL
	THEN SET NEW.modified = CURRENT_TIMESTAMP;
	END IF;
END

Code: Alles auswählen

DELIMITER ;