summaryrefslogtreecommitdiff
path: root/util/dump.sql
diff options
context:
space:
mode:
authorYorhel <git@yorhel.nl>2009-08-08 16:09:47 +0200
committerYorhel <git@yorhel.nl>2009-08-08 16:09:47 +0200
commit5865bdbb0c0b9492d57af220bb00ee9d1f7eeed7 (patch)
tree81534ac58b0461d455d140c2709b0c517d06afbe /util/dump.sql
parent7c50eca82694cd1da0c77711be698d4f258289f4 (diff)
Improved handling of the timestamp columns in anime and session tables
Anything fetched from the DB to Perl should be converted to a UNIX timestamp, and everything that goes from Perl to the DB should be converted from a UNIX timestamp to a timestamptz data type. Also, when creating a session, don't rely on the fact that the expiration default happens to be the same as the cookie expiration time calculated in Perl. It's cleaner to calculate the date at one place and then use that everywhere else.
Diffstat (limited to 'util/dump.sql')
0 files changed, 0 insertions, 0 deletions