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

[..hidden..]

Revision: 3551
          http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=3551&view=rev
Author:   einhverfr
Date:     2011-07-21 06:12:57 +0000 (Thu, 21 Jul 2011)

Log Message:
-----------
Asset report approval manu

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

Added Paths:
-----------
    trunk/sql/upgrade/3551-asset-approval-menu.sql

Modified: trunk/sql/Pg-database.sql
===================================================================
--- trunk/sql/Pg-database.sql	2011-07-20 23:39:49 UTC (rev 3550)
+++ trunk/sql/Pg-database.sql	2011-07-21 06:12:57 UTC (rev 3551)
@@ -2239,8 +2239,9 @@
 -- Name: menu_node_id_seq; Type: SEQUENCE SET; Schema: public; Owner: ledgersmb
 --
 
-SELECT pg_catalog.setval('menu_node_id_seq', 226, true);
+SELECT pg_catalog.setval('menu_node_id_seq', 240, true);
 
+
 --
 -- Data for Name: menu_node; Type: TABLE DATA; Schema: public; Owner: ledgersmb
 --
@@ -2473,6 +2474,8 @@
 237	Net Book Value	236	1
 238	Disposal	229	5
 236	Reports	229	11
+239	Depreciation	236	2
+240	Disposal	236	3
 \.
 
 --
@@ -2525,14 +2528,13 @@
 -- Name: menu_attribute_id_seq; Type: SEQUENCE SET; Schema: public; Owner: ledgersmb
 --
 
-SELECT pg_catalog.setval('menu_attribute_id_seq', 615, true);
+SELECT pg_catalog.setval('menu_attribute_id_seq', 641, true);
 
 
 --
 -- Data for Name: menu_attribute; Type: TABLE DATA; Schema: public; Owner: postgres
 --
 
-
 COPY menu_attribute (node_id, attribute, value, id) FROM stdin;
 26	outstanding	1	584
 205	menu	1	574
@@ -3122,10 +3124,20 @@
 234	depreciation	1	629
 238	action	new_report	636
 238	module	asset.pl	635
+239	module	asset.pl	637
+239	action	search_reports	638
+239	depreciation	1	639
+240	module	asset.pl	640
+240	action	search_reports	641
 \.
 
+
 --
+-- PostgreSQL database dump complete
+--
 
+--
+
 CREATE TABLE menu_acl (
     id serial NOT NULL,
     role_name character varying,

Added: trunk/sql/upgrade/3551-asset-approval-menu.sql
===================================================================
--- trunk/sql/upgrade/3551-asset-approval-menu.sql	                        (rev 0)
+++ trunk/sql/upgrade/3551-asset-approval-menu.sql	2011-07-21 06:12:57 UTC (rev 3551)
@@ -0,0 +1,29 @@
+BEGIN;
+
+SELECT setval('menu_node_id_seq', max(id)) from menu_node;
+SELECT setval('menu_attribute_id_seq', max(id)) from menu_attribute;
+
+SELECT * FROM menu_insert(236, 2, 'Depreciation');
+
+INSERT INTO menu_attribute(node_id, attribute, value)
+VALUES (currval('menu_node_id_seq')::int, 'module', 'asset.pl');
+INSERT INTO menu_attribute(node_id, attribute, value)
+VALUES (currval('menu_node_id_seq')::int, 'action', 'search_reports');
+INSERT INTO menu_attribute(node_id, attribute, value)
+VALUES (currval('menu_node_id_seq')::int, 'depreciation', '1');
+
+INSERT INTO menu_acl(node_id, acl_type, role_name)
+values (currval('menu_node_id_seq')::int, 'allow', 
+        'lsmb_' || current_database() || '__assets_approve');
+
+SELECT * FROM menu_insert(236, 3, 'Disposal');
+
+INSERT INTO menu_attribute(node_id, attribute, value)
+VALUES (currval('menu_node_id_seq')::int, 'module', 'asset.pl');
+INSERT INTO menu_attribute(node_id, attribute, value)
+VALUES (currval('menu_node_id_seq')::int, 'action', 'search_reports');
+INSERT INTO menu_acl(node_id, acl_type, role_name)
+values (currval('menu_node_id_seq')::int, 'allow', 
+        'lsmb_' || current_database() || '__assets_approve');
+
+COMMIT;


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