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

[..hidden..]

Revision: 5538
          http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=5538&view=rev
Author:   einhverfr
Date:     2013-01-11 07:50:20 +0000 (Fri, 11 Jan 2013)
Log Message:
-----------
Menu changes for entry of inventry adjustments

Modified Paths:
--------------
    trunk/sql/Pg-database.sql
    trunk/sql/modules/Roles.sql
    trunk/sql/modules/menu_rebuild.sql

Modified: trunk/sql/Pg-database.sql
===================================================================
--- trunk/sql/Pg-database.sql	2013-01-11 07:40:11 UTC (rev 5537)
+++ trunk/sql/Pg-database.sql	2013-01-11 07:50:20 UTC (rev 5538)
@@ -2639,6 +2639,7 @@
 114	Inventory Activity	85	2
 11	Import AR Batch	249	3
 13	Import AP Batch	250	3
+16	Enter Inventory	77	14
 206	Batches	205	1
 14	Search	19	2
 12	Add Contact	19	3
@@ -2849,9 +2850,8 @@
 98	Timecards	0	14
 \.
 
+
 --
--- Name: menu_node_parent_key; Type: CONSTRAINT; Schema: public; Owner: ledgersmb; Tablespace: 
---
 
 ALTER TABLE ONLY menu_node
     ADD CONSTRAINT menu_node_parent_key UNIQUE (parent, "position");
@@ -3503,6 +3503,8 @@
 13	type	ap_multi	175
 11	multi	1	176
 13	multi	1	177
+16	module	inventory.pl	178
+16	action	enter_adjust	179
 \.
 
 

Modified: trunk/sql/modules/Roles.sql
===================================================================
--- trunk/sql/modules/Roles.sql	2013-01-11 07:40:11 UTC (rev 5537)
+++ trunk/sql/modules/Roles.sql	2013-01-11 07:50:20 UTC (rev 5538)
@@ -627,8 +627,6 @@
 GRANT SELECT ON oe TO "lsmb_<?lsmb dbname ?>__pos_enter";
 
 INSERT INTO menu_acl (node_id, acl_type, role_name)
-values (16, 'allow', 'lsmb_<?lsmb dbname ?>__pos_enter');
-INSERT INTO menu_acl (node_id, acl_type, role_name)
 values (17, 'allow', 'lsmb_<?lsmb dbname ?>__pos_enter');
 INSERT INTO menu_acl (node_id, acl_type, role_name)
 values (18, 'allow', 'lsmb_<?lsmb dbname ?>__pos_enter');
@@ -644,8 +642,6 @@
 GRANT ALL ON acc_trans_entry_id_seq TO "lsmb_<?lsmb dbname ?>__close_till";
 
 INSERT INTO menu_acl (node_id, acl_type, role_name)
-values (16, 'allow', 'lsmb_<?lsmb dbname ?>__close_till');
-INSERT INTO menu_acl (node_id, acl_type, role_name)
 values (20, 'allow', 'lsmb_<?lsmb dbname ?>__close_till');
 
 
@@ -657,8 +653,6 @@
  TO "lsmb_<?lsmb dbname ?>__list_all_open";
 
 INSERT INTO menu_acl (node_id, acl_type, role_name)
-values (16, 'allow', 'lsmb_<?lsmb dbname ?>__list_all_open');
-INSERT INTO menu_acl (node_id, acl_type, role_name)
 values (18, 'allow', 'lsmb_<?lsmb dbname ?>__list_all_open');
 
 
@@ -859,6 +853,8 @@
 
 INSERT INTO menu_acl (node_id, acl_type, role_name)
 values (6, 'allow',  'lsmb_<?lsmb dbname ?>__inventory_reports');
+INSERT INTO menu_acl (node_id, acl_type, role_name)
+values (16, 'allow',  'lsmb_<?lsmb dbname ?>__inventory_reports');
 
 CREATE ROLE "lsmb_<?lsmb dbname ?>__pricegroup_create"
 WITH INHERIT NOLOGIN

Modified: trunk/sql/modules/menu_rebuild.sql
===================================================================
--- trunk/sql/modules/menu_rebuild.sql	2013-01-11 07:40:11 UTC (rev 5537)
+++ trunk/sql/modules/menu_rebuild.sql	2013-01-11 07:50:20 UTC (rev 5538)
@@ -204,7 +204,6 @@
 -- Data for Name: menu_acl; Type: TABLE DATA; Schema: public; Owner: postgres
 --
 
-
 --
 -- Name: menu_acl_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
 --
@@ -812,6 +811,8 @@
 13	type	ap_multi	175
 11	multi	1	176
 13	multi	1	177
+16	module	inventory.pl	178
+16	action	enter_adjust	179
 \.
 
 
@@ -836,6 +837,7 @@
 114	Inventory Activity	85	2
 11	Import AR Batch	249	3
 13	Import AP Batch	250	3
+16	Enter Inventory	77	14
 206	Batches	205	1
 14	Search	19	2
 12	Add Contact	19	3

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