MySQL trigger - Joomla 3.x: Общие вопросы

DROP TRIGGER IF EXISTS `#__petition_number`;
CREATE TRIGGER `#__petition_number` BEFORE INSERT ON `#__aepetitions` FOR EACH ROW BEGIN declare auto_increment_id int default 0; select auto_increment INTO auto_increment_id from information_schema.tables where table_name = '#__aepetitions' and table_schema = database(); SET new.title = CONCAT('EP-',auto_increment_id,'-',DATE_FORMAT(CURDATE(),'%d%m%y')); SET new.alias = CONCAT('EP-',auto_increment_id,'-',DATE_FORMAT(CURDATE(),'%d%m%y')); END;