SF.net SVN: ledger-smb:[5024] trunk/sql/Pg-database.sql

[..hidden..]

Revision: 5024
          http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=5024&view=rev
Author:   einhverfr
Date:     2012-07-23 07:23:56 +0000 (Mon, 23 Jul 2012)
Log Message:
-----------
Setting acc_trans.amount not null in database schema

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

Modified: trunk/sql/Pg-database.sql
===================================================================
--- trunk/sql/Pg-database.sql	2012-07-21 12:54:00 UTC (rev 5023)
+++ trunk/sql/Pg-database.sql	2012-07-23 07:23:56 UTC (rev 5024)
@@ -1410,7 +1410,7 @@
 CREATE TABLE acc_trans (
   trans_id int NOT NULL REFERENCES transactions(id),
   chart_id int NOT NULL REFERENCES  account(id),
-  amount NUMERIC,
+  amount NUMERIC NOT NULL,
   transdate date DEFAULT current_date,
   source text,
   cleared bool DEFAULT 'f',

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