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

[..hidden..]

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

Log Message:
-----------
added tracking capability to location. When implemented in 1.3, locations should not be deleted. Instead they are marked active/inactive and tracked

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

Modified: trunk/sql/Pg-database.sql
===================================================================
--- trunk/sql/Pg-database.sql	2007-06-21 21:01:38 UTC (rev 1294)
+++ trunk/sql/Pg-database.sql	2007-06-21 21:08:46 UTC (rev 1295)
@@ -77,8 +77,11 @@
   line_three text,
   city_province text check (city_province ~ '[[:alnum:]_]') NOT NULL,
   country_id integer not null REFERENCES country(id),
-  mail_code text not null check (mail_code ~ '[[:alnum:]_]'));
-  
+  mail_code text not null check (mail_code ~ '[[:alnum:]_]'),
+  created date not null,
+  active boolean not null default TRUE,
+  inactive_date date default null,
+  );  
 CREATE INDEX location_unique_class_idx ON location (id,location_class);
   
 CREATE TABLE company (


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