Converted votes.date to timestamptz and use NOW() as default

1 files changed, 3 insertions, 3 deletions

diff --git a/lib/VNDB/DB/ULists.pm b/lib/VNDB/DB/ULists.pm
index 1a1efecd..34bdc2aa 100644
--- a/lib/VNDB/DB/ULists.pm
+++ b/lib/VNDB/DB/ULists.pm
@@ -158,7 +158,7 @@ sub dbVoteGet {
   );
 
   my @select = (
-    qw|n.vid n.vote n.date n.uid|,
+    qw|n.vid n.vote n.uid|, q|extract('epoch' from n.date) as date|,
     $o{what} =~ /user/ ? ('u.username') : (),
     $o{what} =~ /vn/ ? (qw|vr.title vr.original|) : (),
   );
@@ -214,9 +214,9 @@ sub dbVoteAdd {
     $vote, $vid, $uid
   ) || $self->dbExec(q|
     INSERT INTO votes
-      (vid, uid, vote, date)
+      (vid, uid, vote)
       VALUES (!l)|,
-    [ $vid, $uid, $vote, time ]
+    [ $vid, $uid, $vote ]
   );
 }