From b29b962eecbbadecda4ad63e1c9a6d33710bcc05 Mon Sep 17 00:00:00 2001
From: Matthias Andreas Benkard <code@mail.matthias.benkard.de>
Date: Mon, 27 Feb 2012 20:50:31 +0100
Subject: Database schema: Use the TIMESTAMP WITH TIME ZONE type for
 timestamps.

---
 schema.sql | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

(limited to 'schema.sql')

diff --git a/schema.sql b/schema.sql
index 51d487e..c94ffcf 100644
--- a/schema.sql
+++ b/schema.sql
@@ -29,7 +29,7 @@ CREATE TABLE wiki_pages(
 CREATE TABLE wiki_page_revisions(
   id           SERIAL    NOT NULL,
   page         INTEGER   NOT NULL,
-  date         TIMESTAMP DEFAULT now(),
+  date         TIMESTAMP WITH TIME ZONE DEFAULT now(),
   title        VARCHAR,
   content      VARCHAR,
   author       INTEGER,
@@ -44,7 +44,7 @@ CREATE TABLE wiki_page_revisions(
 CREATE TABLE bookmarks(
   id          SERIAL    NOT NULL,
   owner       INTEGER,
-  date        TIMESTAMP DEFAULT now(),
+  date        TIMESTAMP WITH TIME ZONE DEFAULT now(),
   uri         VARCHAR   NOT NULL,
   title       VARCHAR,
   description VARCHAR,
-- 
cgit v1.2.3

