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

[..hidden..]

Revision: 3319
          http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=3319&view=rev
Author:   einhverfr
Date:     2011-06-24 07:04:54 +0000 (Fri, 24 Jun 2011)

Log Message:
-----------
Adding not null constraint to avoid bug 3323461

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

Added Paths:
-----------
    trunk/sql/upgrade/3319-taxtable.-change.sql

Modified: trunk/sql/Pg-database.sql
===================================================================
--- trunk/sql/Pg-database.sql	2011-06-24 01:12:45 UTC (rev 3318)
+++ trunk/sql/Pg-database.sql	2011-06-24 07:04:54 UTC (rev 3319)
@@ -1152,7 +1152,7 @@
   chart_id int,
   rate numeric,
   taxnumber text,
-  validto timestamp default 'infinity',
+  validto timestamp not null default 'infinity',
   pass integer DEFAULT 0 NOT NULL,
   taxmodule_id int DEFAULT 1 NOT NULL,
   FOREIGN KEY (chart_id) REFERENCES  account(id),

Added: trunk/sql/upgrade/3319-taxtable.-change.sql
===================================================================
--- trunk/sql/upgrade/3319-taxtable.-change.sql	                        (rev 0)
+++ trunk/sql/upgrade/3319-taxtable.-change.sql	2011-06-24 07:04:54 UTC (rev 3319)
@@ -0,0 +1 @@
+ALTER TABLE tax alter column validto set not null;


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