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

[..hidden..]

Revision: 3308
          http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=3308&view=rev
Author:   einhverfr
Date:     2011-06-21 15:17:19 +0000 (Tue, 21 Jun 2011)

Log Message:
-----------
Defaults for employee search

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

Added Paths:
-----------
    trunk/sql/upgrade/3008-menu_update.sql

Modified: trunk/sql/Pg-database.sql
===================================================================
--- trunk/sql/Pg-database.sql	2011-06-21 14:41:12 UTC (rev 3307)
+++ trunk/sql/Pg-database.sql	2011-06-21 15:17:19 UTC (rev 3308)
@@ -2138,7 +2138,7 @@
 
 
 --
--- Data for Name: menu_attribute; Type: TABLE DATA; Schema: public; Owner: ledgersmb
+-- Data for Name: menu_attribute; Type: TABLE DATA; Schema: public; Owner: postgres
 --
 
 COPY menu_attribute (node_id, attribute, value, id) FROM stdin;
@@ -2253,9 +2253,6 @@
 47	menu	1	112
 48	module	employee.pl	113
 48	action	add	114
-49	l_first_name	1	115
-49	module	employee.pl	116
-49	l_employeenumber	1	118
 49	action	search	117
 50	menu	1	119
 51	module	oe.pl	120
@@ -2299,6 +2296,7 @@
 68	action	add	157
 69	module	oe.pl	159
 69	action	add	160
+49	module	employee.pl	118
 68	type	sales_quotation	158
 69	type	request_quotation	161
 70	menu	1	162
@@ -2702,9 +2700,14 @@
 221	action	search_users	604
 222	module	admin.pl	605
 222	action	list_sessions	606
+49	l_last_name	1	115
+49	l_employeenumber	1	116
+49	l_first_name	1	613
+49	l_id	1	614
+49	l_startdate	1	615
+49	l_enddate	1	616
 \.
 
-
 --
 
 CREATE TABLE menu_acl (

Added: trunk/sql/upgrade/3008-menu_update.sql
===================================================================
--- trunk/sql/upgrade/3008-menu_update.sql	                        (rev 0)
+++ trunk/sql/upgrade/3008-menu_update.sql	2011-06-21 15:17:19 UTC (rev 3308)
@@ -0,0 +1,9 @@
+
+insert into menu_attribute (node_id, attribute, value)
+values (49, 'l_first_name', '1'); 
+insert into menu_attribute (node_id, attribute, value)
+values (49, 'l_id', '1'); 
+insert into menu_attribute (node_id, attribute, value)
+values (49, 'l_startdate', '1'); 
+insert into menu_attribute (node_id, attribute, value)
+values (49, 'l_enddate', '1'); 


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