SF.net SVN: ledger-smb: [2137] trunk

[..hidden..]

Revision: 2137
          http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=2137&view=rev
Author:   einhverfr
Date:     2008-05-12 12:13:22 -0700 (Mon, 12 May 2008)

Log Message:
-----------
Merging in fix for 1870069

Modified Paths:
--------------
    trunk/LedgerSMB/AA.pm
    trunk/sql/Pg-database.sql

Modified: trunk/LedgerSMB/AA.pm
===================================================================
--- trunk/LedgerSMB/AA.pm	2008-05-12 19:12:58 UTC (rev 2136)
+++ trunk/LedgerSMB/AA.pm	2008-05-12 19:13:22 UTC (rev 2137)
@@ -329,7 +329,7 @@
 
     # record last payment date in ar/ap table
     $form->{datepaid} = $form->{transdate} unless $form->{datepaid};
-    my $datepaid = ($paid) ? qq|'$form->{datepaid}'| : 'NOW';
+    my $datepaid = ($paid) ? qq|'$form->{datepaid}'| : undef;
 
 
     $query = qq|

Modified: trunk/sql/Pg-database.sql
===================================================================
--- trunk/sql/Pg-database.sql	2008-05-12 19:12:58 UTC (rev 2136)
+++ trunk/sql/Pg-database.sql	2008-05-12 19:13:22 UTC (rev 2137)
@@ -77,7 +77,9 @@
 CREATE TABLE transactions (
   id int PRIMARY KEY,
   table_name text,
-  locked_by int references "session" (session_id) ON DELETE SET NULL
+  locked_by int references "session" (session_id) ON DELETE SET NULL,
+  approved_by int references "users" (entity_id),
+  approved_at timestamp
 );
 
 COMMENT on TABLE transactions IS 
@@ -357,12 +359,14 @@
 projectnumber|1
 queue_payments|0
 poll_frequency|1
+separate_duties|1
 \.
 
 COMMENT ON TABLE defaults IS $$
 Note that poll_frequency is in seconds.  poll_frequency and queue_payments 
 are not exposed via the admin interface as they are advanced features best
-handled via DBAs.  $$;
+handled via DBAs.  Also, separate_duties is not yet included in the admin 
+interface.$$;
 -- */
 -- batch stuff
 


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