SF.net SVN: ledger-smb:[4212] branches/1.3/sql/Pg-database.sql

[..hidden..]

Revision: 4212
          http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=4212&view=rev
Author:   tshvr
Date:     2011-12-15 08:11:32 +0000 (Thu, 15 Dec 2011)
Log Message:
-----------
audittrail TG_RELNAME as tablename

Modified Paths:
--------------
    branches/1.3/sql/Pg-database.sql

Modified: branches/1.3/sql/Pg-database.sql
===================================================================
--- branches/1.3/sql/Pg-database.sql	2011-12-15 08:10:13 UTC (rev 4211)
+++ branches/1.3/sql/Pg-database.sql	2011-12-15 08:11:32 UTC (rev 4212)
@@ -1295,7 +1295,9 @@
 COMMENT ON TABLE ar IS
 $$ Summary/header information for AR transactions and sales invoices.
 Note that some constraints here are hard to enforce because we haven not gotten 
-to rewriting the relevant code here.$$;
+to rewriting the relevant code here.
+HV TODO drop entity_id
+$$;
 
 COMMENT ON COLUMN ar.invnumber IS
 $$ Text identifier for the invoice.  Must be unique.$$;
@@ -1378,7 +1380,9 @@
 COMMENT ON TABLE ap IS
 $$ Summary/header information for AP transactions and vendor invoices.
 Note that some constraints here are hard to enforce because we haven not gotten 
-to rewriting the relevant code here.$$;
+to rewriting the relevant code here.
+HV TODO drop entity_id
+$$;
 
 COMMENT ON COLUMN ap.invnumber IS
 $$ Text identifier for the invoice.  Must be unique.$$;
@@ -1923,8 +1927,8 @@
     t_reference := t_row.reference;
 END IF;
 
-INSERT INTO audittrail (trans_id, reference, action, person_id)
-values (t_row.id, t_reference, TG_OP, person__get_my_entity_id());
+INSERT INTO audittrail (trans_id,tablename,reference, action, person_id)
+values (t_row.id,TG_RELNAME,t_reference, TG_OP, person__get_my_entity_id());
 
 return null; -- AFTER TRIGGER ONLY, SAFE
 END;

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