When looking at the structure of the
customer_entity table, I noticed the
created_at field has this attribute:
on update CURRENT_TIMESTAMP. So every time the row is updated, the
created_at timestamp changes.
It seems like this attribute should exist on the
updated_at field, not the
created_at field. I know it's rare that this table is directly modified due to the EAV structure, but it still seems wrong to ever modify the
Is there a reason for this table structure, or is it just a bug?
Edit: I found a confirmed bug report from Magento for this. Issue #27944. Unfortunately, you must log in to view it. http://www.magentocommerce.com/bug-tracking/issue?issue=13882