SF.net SVN: ledger-smb:[3314] trunk/sql/upgrade/3313-role-updates.sql

[..hidden..]

Revision: 3314
          http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=3314&view=rev
Author:   einhverfr
Date:     2011-06-22 13:47:09 +0000 (Wed, 22 Jun 2011)

Log Message:
-----------
Removing need for preprocess on role update file since this just updates menu acls.

Modified Paths:
--------------
    trunk/sql/upgrade/3313-role-updates.sql

Modified: trunk/sql/upgrade/3313-role-updates.sql
===================================================================
--- trunk/sql/upgrade/3313-role-updates.sql	2011-06-22 13:33:55 UTC (rev 3313)
+++ trunk/sql/upgrade/3313-role-updates.sql	2011-06-22 13:47:09 UTC (rev 3314)
@@ -1,4 +1,4 @@
 
 INSERT INTO menu_acl (node_id, acl_type, role_name)
-SELECT id, 'allow', 'lsmb_<?lsmb dbname ?>__tax_form_save'
-  FROM menu_node WHERE parent_id = 217 and position in (2,3);
+SELECT id, 'allow', 'lsmb_' || current_database() ||'__tax_form_save'
+  FROM menu_node WHERE parent = 217 and position in (2,3);


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