I’m using CTimestampBehavior in a class. I update the class’s table using
Token::model()->updateByPk($tokenKeys, array('is_valid'=>0));
When I check the DB, the rows that being update has their "create_time" updated, not "update_time". Is this an expected behavior or is it a bug?
Alright, it is my bad. I set CURRENT_TIMESTAMP as the default value in MySQL for create_time. But then “update_time” wouldn’t want to update when I use updateByPk(), is this an expected behavior?
when you use TIMESTAMP you have to set attributes in mysql to on update CURRENT_TIMESTAMP, but my advice is to use time in numbers as interger couse is faster