SF.net SVN: ledger-smb:[2805] addons/1.3/assets/trunk/sql/modules

[..hidden..]

Revision: 2805
          http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=2805&view=rev
Author:   einhverfr
Date:     2009-12-07 17:26:14 +0000 (Mon, 07 Dec 2009)

Log Message:
-----------
Minor bug fixes

Modified Paths:
--------------
    addons/1.3/assets/trunk/sql/modules/Assets-tables.sql
    addons/1.3/assets/trunk/sql/modules/Assets.sql

Modified: addons/1.3/assets/trunk/sql/modules/Assets-tables.sql
===================================================================
--- addons/1.3/assets/trunk/sql/modules/Assets-tables.sql	2009-12-07 17:00:19 UTC (rev 2804)
+++ addons/1.3/assets/trunk/sql/modules/Assets-tables.sql	2009-12-07 17:26:14 UTC (rev 2805)
@@ -53,11 +53,11 @@
 
 CREATE TABLE asset_note (
     asset_id int not null references asset_item (id),
-    check (note_class = 3)
+    check (note_class = 4)
 ) inherits (note);
 
-INSERT INTO note_class (id, class) values (3, 'Asset');
-ALTER TABLE asset_note alter column note_class default 3;
+INSERT INTO note_class (id, class) values (4, 'Asset');
+ALTER TABLE asset_note alter column note_class default 4;
 
 CREATE TABLE asset_report_class (
 	id int not null unique,

Modified: addons/1.3/assets/trunk/sql/modules/Assets.sql
===================================================================
--- addons/1.3/assets/trunk/sql/modules/Assets.sql	2009-12-07 17:00:19 UTC (rev 2804)
+++ addons/1.3/assets/trunk/sql/modules/Assets.sql	2009-12-07 17:26:14 UTC (rev 2805)
@@ -357,5 +357,5 @@
 RETURNS asset_note AS
 $$
 INSERT INTO asset_note (asset_id, subject, note) values ($1, $2, $3);
-SELECT * FROM asset_note WHERE note_id = currval('note_id_seq');
+SELECT * FROM asset_note WHERE id = currval('note_id_seq');
 $$ language sql;


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