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

[..hidden..]

Revision: 6308
          http://sourceforge.net/p/ledger-smb/code/6308
Author:   einhverfr
Date:     2013-11-22 11:08:22 +0000 (Fri, 22 Nov 2013)
Log Message:
-----------
Correcting schema changes due to new remark field and new crdate fields.

Modified Paths:
--------------
    trunk/LedgerSMB/DBObject/Payment.pm
    trunk/sql/Pg-database.sql
    trunk/sql/modules/Fixes.sql

Modified: trunk/LedgerSMB/DBObject/Payment.pm
===================================================================
--- trunk/LedgerSMB/DBObject/Payment.pm	2013-11-22 01:52:39 UTC (rev 6307)
+++ trunk/LedgerSMB/DBObject/Payment.pm	2013-11-22 11:08:22 UTC (rev 6308)
@@ -814,6 +814,16 @@
 return @{$self->{available_overpayment_amount}};
 }
 
+=item overpayment_reverse($payment_id, $batch_id);
+
+=cut
+
+sub overpayment_reverse {
+    my ($self, $payment, $batch_id) = @_;
+    __PACKAGE__->call_procedure({procname => 'payment__reverse_overpayment',
+                                     args => [] });
+}
+
 =item init
 
 Initializes the num2text system

Modified: trunk/sql/Pg-database.sql
===================================================================
--- trunk/sql/Pg-database.sql	2013-11-22 01:52:39 UTC (rev 6307)
+++ trunk/sql/Pg-database.sql	2013-11-22 11:08:22 UTC (rev 6308)
@@ -1650,6 +1650,7 @@
   force_closed bool,
   description text,
   is_return bool default false,
+  crdate date,
   unique(invnumber) -- probably a good idea as per Erik's request --CT
 );
 
@@ -1734,6 +1735,7 @@
   terms int2 DEFAULT 0,
   description text,
   force_closed bool,
+  crdate date,
   entity_credit_account int references entity_credit_account(id) NOT NULL
 );
 

Modified: trunk/sql/modules/Fixes.sql
===================================================================
--- trunk/sql/modules/Fixes.sql	2013-11-22 01:52:39 UTC (rev 6307)
+++ trunk/sql/modules/Fixes.sql	2013-11-22 11:08:22 UTC (rev 6308)
@@ -294,3 +294,10 @@
 $$ language plpgsql security definer;
 
 COMMIT;
+BEGIN;
+ALTER TABLE ar ADD COLUMN crdate date;
+ALTER TABLE ap ADD COLUMN crdate date;
+ALTER TABLE entity_bank_account ADD COLUMN  remark text;
+
+COMMIT;
+

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


------------------------------------------------------------------------------
Shape the Mobile Experience: Free Subscription
Software experts and developers: Be at the forefront of tech innovation.
Intel(R) Software Adrenaline delivers strategic insight and game-changing 
conversations that shape the rapidly evolving mobile landscape. Sign up now. 
http://pubads.g.doubleclick.net/gampad/clk?id=63431311&iu=/4140/ostg.clktrk
_______________________________________________
Ledger-smb-commits mailing list
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-commits