bugs/install/db_install/01_triggers/project_insert.sql

DROP TRIGGER IF EXISTS `project_insert`;
CREATE TRIGGER `project_insert`
BEFORE INSERT ON `projects`
FOR EACH ROW BEGIN
	IF new.name REGEXP '^[[:alpha:]]' THEN
		SET new.date_modified = NOW();
	ELSE
		SIGNAL SQLSTATE '45000'
		SET MESSAGE_TEXT = 'Project names must start with a letter';
	END IF;
END;