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

[..hidden..]

Revision: 4107
          http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=4107&view=rev
Author:   einhverfr
Date:     2011-11-27 22:54:32 +0000 (Sun, 27 Nov 2011)
Log Message:
-----------
Installation sugar for budgetting addon

Added Paths:
-----------
    addons/1.3/budgetting/trunk/sql/modules/Budgetting-roles.sql
    addons/1.3/budgetting/trunk/sql/modules/Budgetting_install.sql
    addons/1.3/budgetting/trunk/sql/modules/LOADORDER.budgetting

Removed Paths:
-------------
    addons/1.3/budgetting/trunk/sql/modules/budgetting-roles.sql

Copied: addons/1.3/budgetting/trunk/sql/modules/Budgetting-roles.sql (from rev 3928, addons/1.3/budgetting/trunk/sql/modules/budgetting-roles.sql)
===================================================================
--- addons/1.3/budgetting/trunk/sql/modules/Budgetting-roles.sql	                        (rev 0)
+++ addons/1.3/budgetting/trunk/sql/modules/Budgetting-roles.sql	2011-11-27 22:54:32 UTC (rev 4107)
@@ -0,0 +1,21 @@
+--TODO
+CREATE ROLE "lsmb_<?lsmb dbname ?>__budget_enter" WITH INHERIT NOLOGIN;
+CREATE ROLE "lsmb_<?lsmb dbname ?>__budget_approve" WITH INHERIT NOLOGIN;
+CREATE ROLE "lsmb_<?lsmb dbname ?>__budget_obsolete" WITH INHERIT NOLOGIN;
+
+GRANT SELECT 
+ON budget_info, budget_line, budget_to_department, budget_to_project
+TO public;
+
+GRANT INSERT 
+ON budget_info, budget_line, budget_to_department, budget_to_project 
+TO "lsmb_<?lsmb dbname ?>__budget_enter";
+
+GRANT UPDATE (approved_at, approved_by) on budget_info 
+TO "lsmb_<?lsmb dbname ?>__budget_approve";
+
+GRANT UPDATE (obsolete_at, obsolete_by) on budget_info
+TO "lsmb_<?lsmb dbname ?>__budget_obsolete";
+
+GRANT EXECUTE ON FUNCTION budget__reject(in_id int) 
+TO "lsmb_<?lsmb dbname ?>__budget_approve";

Added: addons/1.3/budgetting/trunk/sql/modules/Budgetting_install.sql
===================================================================
--- addons/1.3/budgetting/trunk/sql/modules/Budgetting_install.sql	                        (rev 0)
+++ addons/1.3/budgetting/trunk/sql/modules/Budgetting_install.sql	2011-11-27 22:54:32 UTC (rev 4107)
@@ -0,0 +1,2 @@
+\i budgetting_tables.sql
+\i budgetting_menu.sql

Added: addons/1.3/budgetting/trunk/sql/modules/LOADORDER.budgetting
===================================================================
--- addons/1.3/budgetting/trunk/sql/modules/LOADORDER.budgetting	                        (rev 0)
+++ addons/1.3/budgetting/trunk/sql/modules/LOADORDER.budgetting	2011-11-27 22:54:32 UTC (rev 4107)
@@ -0,0 +1 @@
+Budgetting.sql

Deleted: addons/1.3/budgetting/trunk/sql/modules/budgetting-roles.sql
===================================================================
--- addons/1.3/budgetting/trunk/sql/modules/budgetting-roles.sql	2011-11-27 18:37:56 UTC (rev 4106)
+++ addons/1.3/budgetting/trunk/sql/modules/budgetting-roles.sql	2011-11-27 22:54:32 UTC (rev 4107)
@@ -1,21 +0,0 @@
---TODO
-CREATE ROLE "lsmb_<?lsmb dbname ?>__budget_enter" WITH INHERIT NOLOGIN;
-CREATE ROLE "lsmb_<?lsmb dbname ?>__budget_approve" WITH INHERIT NOLOGIN;
-CREATE ROLE "lsmb_<?lsmb dbname ?>__budget_obsolete" WITH INHERIT NOLOGIN;
-
-GRANT SELECT 
-ON budget_info, budget_line, budget_to_department, budget_to_project
-TO public;
-
-GRANT INSERT 
-ON budget_info, budget_line, budget_to_department, budget_to_project 
-TO "lsmb_<?lsmb dbname ?>__budget_enter";
-
-GRANT UPDATE (approved_at, approved_by) on budget_info 
-TO "lsmb_<?lsmb dbname ?>__budget_approve";
-
-GRANT UPDATE (obsolete_at, obsolete_by) on budget_info
-TO "lsmb_<?lsmb dbname ?>__budget_obsolete";
-
-GRANT EXECUTE ON FUNCTION budget__reject(in_id int) 
-TO "lsmb_<?lsmb dbname ?>__budget_approve";

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