title: How to write triggers in Magento?
body: <p>I need to write the triggers in Magento module. The trigger codes works fine in MySQL but if the same is written in Magento Installer scripts it doesn't work. 
  Can someone let me know how we can use trigger in Magento. </p>
  
  <p>Trigger code:</p>
  
  <pre><code>DELIMITER ;;
  CREATE TRIGGER `insert_user_trigger` BEFORE INSERT ON `sitealluser` FOR EACH ROW
  BEGIN
      SET NEW.designs_created_at = NOW();
  END;;
  DELIMITER ;
  </code></pre>