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

git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1295 4979c152-3d1c-0410-bac9-87ea11338e46

1 files changed, 5 insertions, 2 deletions

diff --git a/sql/Pg-database.sql b/sql/Pg-database.sql
index cab04b00..bd710576 100644
--- a/sql/Pg-database.sql
+++ b/sql/Pg-database.sql
@@ -77,8 +77,11 @@ CREATE TABLE location (
   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 (