// Add your reply above here
==================================================
Aaron Fuleki updated this ticket at November 15th, 2010 @ 08:19 PM
The use of `story_instance.cover_date` field confuses me. The field is duplicated in each instance record, and not just stored in the root `story` table record. It seems to me that since `cover_date` can't really change, it should be in the `story` table (like `expire_date`), and a timestamp for instance creation should go in the `story_instance` table.
However it's stored, it's critical for debugging (unless you *really* like `JOIN` statements), it should be consistent, and it should be logged as well.
--------------------------------------------------------------------------------
Assigned: Bugs (at bricolage)
State: new
Milestone: Future
View this ticket online: http://bricolage.lighthouseapp.com/projects/29601/tickets/65-add-timestamp-column-to-story_instance-table
Stop being notified of this ticket's changes: http://bricolage.lighthouseapp.com/projects/29601/tickets/65-add-timestamp-column-to-story_instance-table/watch
Update your Profile: http://bricolage.lighthouseapp.com/profile
Support: support@lighthouseapp.com or http://help.lighthouseapp.com
==================================================
Aaron Fuleki updated this ticket at November 15th, 2010 @ 08:19 PM
The use of `story_instance.cover_date` field confuses me. The field is duplicated in each instance record, and not just stored in the root `story` table record. It seems to me that since `cover_date` can't really change, it should be in the `story` table (like `expire_date`), and a timestamp for instance creation should go in the `story_instance` table.
However it's stored, it's critical for debugging (unless you *really* like `JOIN` statements), it should be consistent, and it should be logged as well.
--------------------------------------------------------------------------------
Assigned: Bugs (at bricolage)
State: new
Milestone: Future
View this ticket online: http://bricolage.lighthouseapp.com/projects/29601/tickets/65-add-timestamp-column-to-story_instance-table
Stop being notified of this ticket's changes: http://bricolage.lighthouseapp.com/projects/29601/tickets/65-add-timestamp-column-to-story_instance-table/watch
Update your Profile: http://bricolage.lighthouseapp.com/profile
Support: support@lighthouseapp.com or http://help.lighthouseapp.com