summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rw-r--r--lib/VNDB/DB/ULists.pm6
-rw-r--r--util/dump.sql2
-rw-r--r--util/updates/update_2.6.sql6
3 files changed, 10 insertions, 4 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 ]
);
}
diff --git a/util/dump.sql b/util/dump.sql
index 3667c3b5..fa29460f 100644
--- a/util/dump.sql
+++ b/util/dump.sql
@@ -326,7 +326,7 @@ CREATE TABLE votes (
vid integer NOT NULL DEFAULT 0,
uid integer NOT NULL DEFAULT 0,
vote integer NOT NULL DEFAULT 0,
- date bigint NOT NULL DEFAULT 0,
+ date timestamptz NOT NULL DEFAULT NOW(),
PRIMARY KEY(vid, uid)
);
diff --git a/util/updates/update_2.6.sql b/util/updates/update_2.6.sql
index f3760d6a..18e8aee0 100644
--- a/util/updates/update_2.6.sql
+++ b/util/updates/update_2.6.sql
@@ -70,6 +70,12 @@ ALTER TABLE threads_posts ALTER COLUMN edited DROP DEFAULT;
ALTER TABLE threads_posts ALTER COLUMN edited TYPE timestamptz USING CASE WHEN edited = 0 THEN NULL ELSE to_timestamp(edited) END;
+-- votes.date -> timestamptz
+ALTER TABLE votes ALTER COLUMN date DROP DEFAULT;
+ALTER TABLE votes ALTER COLUMN date TYPE timestamptz USING to_timestamp(date);
+ALTER TABLE votes ALTER COLUMN date SET DEFAULT NOW();
+
+
-- screenshots.status (smallint) -> screenshots.processed (boolean)
ALTER TABLE screenshots RENAME COLUMN status TO processed;
ALTER TABLE screenshots ALTER COLUMN processed DROP DEFAULT;