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

[..hidden..]

Revision: 5159
          http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=5159&view=rev
Author:   einhverfr
Date:     2012-10-15 07:40:16 +0000 (Mon, 15 Oct 2012)
Log Message:
-----------
applying Berend Tober's patch for database schema

Modified Paths:
--------------
    trunk/UI/Contact/divs/credit.html
    trunk/sql/Pg-database.sql

Modified: trunk/UI/Contact/divs/credit.html
===================================================================
--- trunk/UI/Contact/divs/credit.html	2012-10-15 07:37:38 UTC (rev 5158)
+++ trunk/UI/Contact/divs/credit.html	2012-10-15 07:40:16 UTC (rev 5159)
@@ -20,9 +20,9 @@
         { col_id = 'meta_number', type = 'href', name = text("Number"), 
           href_base = "$script?action=get&" }
         { col_id = 'description', type = 'text', name = text("Description") }
-        { col_id = 'credit_limit', type = 'text', name = text('Credit Limit') }
-        { col_id = 'start_date', type = 'text', name = text('Start Date') }
-        { col_id = 'end_date', type = 'text', name = text('End Date') }
+        { col_id = 'creditlimit', type = 'text', name = text('Credit Limit') }
+        { col_id = 'startdate', type = 'text', name = text('Start Date') }
+        { col_id = 'enddate', type = 'text', name = text('End Date') }
     ], #'
     tbody = {rows = credit_list}; ?>
     <form id="credit_form" name="credit_form" method="post" 

Modified: trunk/sql/Pg-database.sql
===================================================================
--- trunk/sql/Pg-database.sql	2012-10-15 07:37:38 UTC (rev 5158)
+++ trunk/sql/Pg-database.sql	2012-10-15 07:40:16 UTC (rev 5159)
@@ -1234,7 +1234,7 @@
 CREATE TABLE business_unit_jl (
     entry_id int references journal_line(id),
     bu_class int references business_unit_class(id),
-    bu_id int references business_unit(id) NOT NULL.
+    bu_id int references business_unit(id) NOT NULL,
     PRIMARY KEY(entry_id, bu_class)
 );
 

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