SF.net SVN: ledger-smb:[5316] trunk/sql

[..hidden..]

Revision: 5316
          http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=5316&view=rev
Author:   einhverfr
Date:     2012-12-07 06:51:23 +0000 (Fri, 07 Dec 2012)
Log Message:
-----------
Finalizing stored proc mapping structure for payroll deduction classes

Payroll is about as far as I can take it here without working with someone who has current workflow needs.  Recommend further fleshing it out during beta at this point.

Modified Paths:
--------------
    trunk/sql/Pg-database.sql
    trunk/sql/modules/Fixes.sql

Modified: trunk/sql/Pg-database.sql
===================================================================
--- trunk/sql/Pg-database.sql	2012-12-07 06:38:35 UTC (rev 5315)
+++ trunk/sql/Pg-database.sql	2012-12-07 06:51:23 UTC (rev 5316)
@@ -967,6 +967,7 @@
    id int not null,
    country_id int not null references country(id),
    label text not null,
+   stored_proc_name name not null,
    unique (id, country_id),
    primary key (country_id, label)
 );

Modified: trunk/sql/modules/Fixes.sql
===================================================================
--- trunk/sql/modules/Fixes.sql	2012-12-07 06:38:35 UTC (rev 5315)
+++ trunk/sql/modules/Fixes.sql	2012-12-07 06:51:23 UTC (rev 5316)
@@ -107,3 +107,9 @@
 $$ This view is used by cash basis reports to determine the fraction of a
 transaction to be counted.$$;
 COMMIT;
+
+BEGIN;
+
+ALTER TABLE payrol_deduction_class ADD stored_proc_name name not null;
+
+COMMIT;

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