SF.net SVN: ledger-smb: [1296] trunk/sql/Pg-database.sql

[..hidden..]

Revision: 1296
          http://svn.sourceforge.net/ledger-smb/?rev=1296&view=rev
Author:   linuxpoet
Date:     2007-06-21 14:16:03 -0700 (Thu, 21 Jun 2007)

Log Message:
-----------
minor date style change

Modified Paths:
--------------
    trunk/sql/Pg-database.sql

Modified: trunk/sql/Pg-database.sql
===================================================================
--- trunk/sql/Pg-database.sql	2007-06-21 21:08:46 UTC (rev 1295)
+++ trunk/sql/Pg-database.sql	2007-06-21 21:16:03 UTC (rev 1296)
@@ -79,8 +79,8 @@
   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);
   


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.