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

[..hidden..]

Revision: 3537
          http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=3537&view=rev
Author:   einhverfr
Date:     2011-07-16 03:38:29 +0000 (Sat, 16 Jul 2011)

Log Message:
-----------
Correcting issue with fixed asset note not saving properly

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

Added Paths:
-----------
    trunk/sql/upgrade/3537-note-table.sql

Modified: trunk/sql/Pg-database.sql
===================================================================
--- trunk/sql/Pg-database.sql	2011-07-16 03:28:38 UTC (rev 3536)
+++ trunk/sql/Pg-database.sql	2011-07-16 03:38:29 UTC (rev 3537)
@@ -843,7 +843,7 @@
 CREATE TABLE note (id serial primary key, 
                    note_class integer not null references note_class(id), 
                    note text not null, 
-                   vector tsvector not null, 
+                   vector tsvector not null default '', 
                    created timestamp not null default now(),
                    created_by text DEFAULT SESSION_USER,
                    ref_key integer not null,

Added: trunk/sql/upgrade/3537-note-table.sql
===================================================================
--- trunk/sql/upgrade/3537-note-table.sql	                        (rev 0)
+++ trunk/sql/upgrade/3537-note-table.sql	2011-07-16 03:38:29 UTC (rev 3537)
@@ -0,0 +1,2 @@
+alter table note alter column vector set default '';
+


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