bug_status view now returns unix epoch; bump db version

[debbugs.git] / sql / debbugs_schema.sql

diff --git a/sql/debbugs_schema.sql b/sql/debbugs_schema.sql
index 0b5b86e143900dd1146b73c35f0e31474f0feef3..f015d452d8727aac43e67b4bce6f5653bfa91993 100644 (file)
--- a/sql/debbugs_schema.sql
+++ b/sql/debbugs_schema.sql
@@ -574,9 +574,9 @@ CREATE VIEW bug_status --(id,bug_num,tags,subject,
                      WHERE bsp.bug=b.id) AS package
         ) AS package,
        b.submitter_full AS originator,
-       b.log_modified AS log_modified,
-       b.creation AS date,
-       b.last_modified AS last_modified,
+       EXTRACT(EPOCH FROM b.log_modified) AS log_modified,
+       EXTRACT(EPOCH FROM b.creation) AS date,
+       EXTRACT(EPOCH FROM b.last_modified) AS last_modified,
        b.done_full AS done,
        string_agg(bb.blocks::text,' ' ORDER BY bb.blocks) AS blocks,
        string_agg(bbb.bug::text,' ' ORDER BY bbb.bug) AS blockedby,