Dong Shin 04.13.2010

  • continue working on Funding Request editor
    • Save, Request, Send to BF34, Certify, Accept works (updates the status accordingly)
    • Date updates can now be saved
  • working on Triggers to store data logs (SQL’s)
    • mysql> delimiter $$
mysql> CREATE TRIGGER Employee_Trigger
    -> AFTER UPDATE ON employee
    -> FOR EACH ROW
    -> BEGIN
    -> INSERT into Employee_log
    -> (user_id, description)VALUES (user(),
    -> CONCAT('Id with ',NEW.id,' is modified ',
    -> ' from ',OLD.start_date, ' to ', NEW.start_date));
    ->  END$$
Query OK, 0 rows affected (0.00 sec)
    mysql> delimiter ;