From be42a637e05b5679d0ddb2350ec031139d19b3bc Mon Sep 17 00:00:00 2001
From: linuxpoet <linuxpoet@4979c152-3d1c-0410-bac9-87ea11338e46>
Date: Thu, 21 Jun 2007 21:16:03 +0000
Subject: minor date style change

git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1296 4979c152-3d1c-0410-bac9-87ea11338e46
---
 sql/Pg-database.sql | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

diff --git a/sql/Pg-database.sql b/sql/Pg-database.sql
index bd710576..0a54c86f 100644
--- a/sql/Pg-database.sql
+++ b/sql/Pg-database.sql
@@ -79,8 +79,8 @@ CREATE TABLE location (
   country_id integer not null REFERENCES country(id),
   mail_code text not null check (mail_code ~ '[[:alnum:]_]'),
   created date not null,
-  active boolean not null default TRUE,
-  inactive_date date default null,
+  inactive_date timestamp default null,
+  active boolean not null default TRUE
   );  
 CREATE INDEX location_unique_class_idx ON location (id,location_class);
   
-- 
cgit v1.2.3