
USE `akura`;



--
-- Dumping data for table `TAB`
--

INSERT INTO `TAB` (TAB_ID,NAME,PARENT_TAB_ID,MODULE_ID,INDEX_NO,MODIFIED_TIME) VALUES (50,'Leave Approval Process',1,1,5,'2012-09-04 07:17:16');


--
-- Dumping data for table `PAGE`
--

INSERT INTO `PAGE` (PAGE_ID,NAME,URL,TAB_ID,INDEX_NO,MODIFIED_TIME) VALUES (92,'Annual Student Attendance Report','annualStudentAttendanceReport.htm',30,2,'2012-09-04 07:17:16'),(93,'Leave Approval Process','leaveApprovalProcess.htm',50,1,'2012-09-04 07:17:16'),(94,'Manage Employment Status','manageEmploymentStatus.htm',26,46,'2012-09-04 07:17:16');


--
-- Dumping data for table `PRIVILEGE`
--

INSERT INTO `PRIVILEGE` (PRIVILEGE_ID,NAME,PAGE_ID,MODIFIED_TIME) VALUES (292,'Terminate Student',9,'2012-09-04 07:17:16'),(293,'Activate Student',9,'2012-09-04 07:17:16'),(294,'Annual Student Attendance Report',92,'2012-09-04 07:17:16'),(295,'Leave Approval Process',93,'2012-09-04 07:17:16'),(296,'View Employment Status',94,'2012-09-04 07:17:16'),(297,'Save or Update a Employment Status',94,'2012-09-04 07:17:16'),(298,'Delete Employment Status',94,'2012-09-04 07:17:16');


--
-- Dumping data for table `ROLE_PRIVILEGE`
--

INSERT INTO `ROLE_PRIVILEGE` (USER_ROLE_ID,PRIVILEGE_ID,MODIFIED_TIME) VALUES (1,292,'2012-09-04 07:17:45'),(1,293,'2012-09-04 07:17:45'),(1,294,'2012-09-04 07:17:45'),(1,295,'2012-09-04 07:17:45'),(1,296,'2012-09-04 07:17:45'),(1,297,'2012-09-04 07:17:45'),(1,298,'2012-09-04 07:17:45');

--
-- Dumping data for table `ROLE_TAB`
--

INSERT INTO `ROLE_TAB` (TAB_ID,USER_ROLE_ID,MODIFIED_TIME) VALUES (50,1,'2012-09-04 07:17:45');


--
-- Dumping data for table `PRIVILEGE_DEPENDENCY`
--

INSERT INTO `PRIVILEGE_DEPENDENCY` (PRIVILEGE_ID,DEPENDENCY_ID,MODIFIED_TIME) VALUES (292,29,'2012-09-04 07:18:48'),(293,29,'2012-09-04 07:18:48'),(255,33,'2012-09-04 07:18:48'),(33,255,'2012-09-04 07:18:48'),(294,196,'2012-09-04 07:18:48'),(295,74,'2012-09-04 07:18:48'),(296,74,'2012-09-04 07:18:48'),(297,296,'2012-09-04 07:18:48'),(298,74,'2012-09-04 07:18:48'),(299,296,'2012-09-04 07:18:48'),(280,279,'2012-09-04 07:18:48'),(281,279,'2012-09-04 07:18:48');

--
-- Dumping data for table `PRIVILEGE`
--

UPDATE `PRIVILEGE` 
SET `NAME`='Add/Edit Staff Member Page' 
WHERE `PRIVILEGE_ID`='3';

--
-- Dumping data for table `ROLE_PRIVILEGE`
--

INSERT INTO `ROLE_PRIVILEGE` (USER_ROLE_ID,PRIVILEGE_ID,MODIFIED_TIME) VALUES (2,15,'2012-09-04 07:17:45');




