amrapali DataBase Leaked #TrojanFM #GForce Pakistan

DataBase leaked by #TrojanFM #GForce Pakistan
Greetz:- #Mr.Instinct, #Keyboard005, #XTAM4, #Sea Monster!!!


http://www.amrapali.ac.in




-- phpMyAdmin SQL Dump
-- version 3.2.4
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Apr 10, 2014 at 04:32 PM
-- Server version: 5.1.41
-- PHP Version: 5.3.1

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Database: `lms`
--

-- --------------------------------------------------------

--
-- Table structure for table `associate_course`
--

CREATE TABLE IF NOT EXISTS `associate_course` (
  `ID` varchar(11) CHARACTER SET utf8 NOT NULL,
  `COURSE_ID` varchar(15) CHARACTER SET utf8 NOT NULL,
  `EMP_ID` varchar(15) CHARACTER SET utf8 NOT NULL,
  PRIMARY KEY (`ID`),
  KEY `COURSE_ID` (`COURSE_ID`,`EMP_ID`),
  KEY `EMP_ID` (`EMP_ID`),
  KEY `COURSE_ID_2` (`COURSE_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `associate_course`
--


-- --------------------------------------------------------

--
-- Table structure for table `associate_design`
--

CREATE TABLE IF NOT EXISTS `associate_design` (
  `ID` varchar(15) CHARACTER SET utf8 NOT NULL,
  `STATUS_` varchar(30) CHARACTER SET utf8 NOT NULL,
  `DATE_` date NOT NULL,
  `EMP_ID` varchar(15) CHARACTER SET utf8 NOT NULL,
  `DESIG_ID` varchar(11) CHARACTER SET utf8 NOT NULL,
  PRIMARY KEY (`ID`),
  KEY `EMP_ID` (`EMP_ID`,`DESIG_ID`),
  KEY `DESIG_ID` (`DESIG_ID`),
  KEY `EMP_ID_2` (`EMP_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `associate_design`
--


-- --------------------------------------------------------

--
-- Table structure for table `college`
--

CREATE TABLE IF NOT EXISTS `college` (
  `CLG_ID` varchar(10) CHARACTER SET utf8 NOT NULL,
  `CLG_NAME` varchar(250) CHARACTER SET utf8 NOT NULL,
  `ABREV` varchar(30) CHARACTER SET utf8 NOT NULL,
  PRIMARY KEY (`CLG_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `college`
--

INSERT INTO `college` (`CLG_ID`, `CLG_NAME`, `ABREV`) VALUES
('1', 'aimca', 'aimca');

-- --------------------------------------------------------

--
-- Table structure for table `course`
--

CREATE TABLE IF NOT EXISTS `course` (
  `COURSE_ID` int(11) NOT NULL,
  `COURSE_NAME` varchar(150) NOT NULL,
  `ABREV` varchar(8) NOT NULL,
  `UNIV_ID` varchar(11) CHARACTER SET utf8 NOT NULL,
  KEY `UNIV_ID` (`UNIV_ID`),
  KEY `UNIV_ID_2` (`UNIV_ID`),
  KEY `UNIV_ID_3` (`UNIV_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `course`
--

INSERT INTO `course` (`COURSE_ID`, `COURSE_NAME`, `ABREV`, `UNIV_ID`) VALUES
(6, 'mca', 'mca', '1');

-- --------------------------------------------------------

--
-- Table structure for table `designation_master`
--

CREATE TABLE IF NOT EXISTS `designation_master` (
  `DESIG_ID` varchar(15) CHARACTER SET utf8 NOT NULL,
  `DOC` varchar(50) CHARACTER SET utf8 NOT NULL,
  PRIMARY KEY (`DESIG_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `designation_master`
--


-- --------------------------------------------------------

--
-- Table structure for table `emp_address_detail`
--

CREATE TABLE IF NOT EXISTS `emp_address_detail` (
  `ADR_ID` int(11) NOT NULL AUTO_INCREMENT,
  `ADDRESS` varchar(150) CHARACTER SET utf8 NOT NULL,
  `STREET` varchar(100) CHARACTER SET utf8 NOT NULL,
  `CITY` varchar(100) CHARACTER SET utf8 NOT NULL,
  `PIN_CODE` varchar(15) CHARACTER SET utf8 NOT NULL,
  `DISTRIC` varchar(150) CHARACTER SET utf8 NOT NULL,
  `STATE` varchar(150) CHARACTER SET utf8 COLLATE utf8_hungarian_ci NOT NULL,
  `COUNTRY` varchar(150) CHARACTER SET utf8 NOT NULL,
  `EMP_ID` varchar(15) CHARACTER SET utf8 NOT NULL,
  PRIMARY KEY (`ADR_ID`),
  KEY `EMP_ID` (`EMP_ID`),
  KEY `EMP_ID_2` (`EMP_ID`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;

--
-- Dumping data for table `emp_address_detail`
--

INSERT INTO `emp_address_detail` (`ADR_ID`, `ADDRESS`, `STREET`, `CITY`, `PIN_CODE`, `DISTRIC`, `STATE`, `COUNTRY`, `EMP_ID`) VALUES
(1, 'sgdgshj', 'TILAK NAGAR', 'BEGUSARAI', '851101', 'BEGUSARAI', 'BIHAR', 'INDIA', 'F009'),
(2, 'sgdgshj', 'TILAK NAGAR', 'BEGUSARAI', '851101', 'BEGUSARAI', 'BIHAR', 'INDIA', 'F010'),
(3, 'sgdhjsagdg', 'TILAK NAGAR', 'BEGUSARAI', '851101', 'BEGUSARAI', 'BIHAR', 'INDIA', 'F011'),
(4, 'jdgjhgsdaj', 'TILAK NAGAR', 'BEGUSARAI', '851101', 'BEGUSARAI', 'BIHAR', 'INDIA', 'F012');

-- --------------------------------------------------------

--
-- Table structure for table `emp_contact_detail`
--

CREATE TABLE IF NOT EXISTS `emp_contact_detail` (
  `CNT_ID` int(11) NOT NULL AUTO_INCREMENT,
  `MOBILE` varchar(20) CHARACTER SET utf8 NOT NULL,
  `PHONE` varchar(20) CHARACTER SET utf8 NOT NULL,
  `EMAIL` varchar(200) CHARACTER SET utf8 NOT NULL,
  `EMP_ID` varchar(15) CHARACTER SET utf8 NOT NULL,
  PRIMARY KEY (`CNT_ID`),
  KEY `EMP_ID` (`EMP_ID`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;

--
-- Dumping data for table `emp_contact_detail`
--

INSERT INTO `emp_contact_detail` (`CNT_ID`, `MOBILE`, `PHONE`, `EMAIL`, `EMP_ID`) VALUES
(1, '8410852003', '0', '[email protected]', 'F009'),
(2, '8410852003', '0', '[email protected]', 'F010'),
(3, '8410852003', '0', '[email protected]', 'F011'),
(4, '8410852003', '0', '[email protected]', 'F012');

-- --------------------------------------------------------

--
-- Table structure for table `emp_pers_detail`
--

CREATE TABLE IF NOT EXISTS `emp_pers_detail` (
  `EMP_ID` varchar(15) CHARACTER SET utf8 NOT NULL,
  `FIRST_NAME` varchar(100) CHARACTER SET utf8 NOT NULL,
  `SECOND_NAME` varchar(100) CHARACTER SET utf8 NOT NULL,
  `LAST_NAME` varchar(100) CHARACTER SET utf8 NOT NULL,
  `DOB` varchar(25) CHARACTER SET utf8 NOT NULL,
  `USER_NAME` varchar(30) CHARACTER SET utf8 NOT NULL COMMENT 'Default value should be Guest',
  PRIMARY KEY (`EMP_ID`),
  KEY `USER_NAME` (`USER_NAME`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `emp_pers_detail`
--

INSERT INTO `emp_pers_detail` (`EMP_ID`, `FIRST_NAME`, `SECOND_NAME`, `LAST_NAME`, `DOB`, `USER_NAME`) VALUES
('F008', 'ASPANDAN', 'KR ', 'SRIVASTVA', '', 'aspandan123'),
('F009', 'sadsad', '', 'SRIVASTVA', '', 'aspandan123'),
('F010', 'sadsad', '', 'SRIVASTVA', '//', 'aspandan123'),
('F011', 'ASPANDAN', 'KR ', 'SRIVASTVA', '//', 'aspandan123'),
('F012', 'sadsad', 'KR ', 'SRIVASTVA', '2/2/1901', 'aspandan1235'),
('FOO7', 'NITIN ', '', 'DEEPAK', '13/11/52', 'nitin');

-- --------------------------------------------------------

--
-- Table structure for table `emp_qualification`
--

CREATE TABLE IF NOT EXISTS `emp_qualification` (
  `QUALI_ID` int(11) NOT NULL AUTO_INCREMENT,
  `QUALIFICATION` varchar(150) CHARACTER SET utf8 NOT NULL,
  `EXPERIENCE` varchar(10) CHARACTER SET utf8 NOT NULL COMMENT 'In Months',
  `EMP_ID` varchar(15) CHARACTER SET utf8 NOT NULL,
  PRIMARY KEY (`QUALI_ID`),
  KEY `EMP_ID` (`EMP_ID`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;

--
-- Dumping data for table `emp_qualification`
--

INSERT INTO `emp_qualification` (`QUALI_ID`, `QUALIFICATION`, `EXPERIENCE`, `EMP_ID`) VALUES
(1, 'BCA', '', 'F009'),
(2, 'BCA', '', 'F010'),
(3, 'BCA', '5', 'F011'),
(4, 'BCA', '2 YRS.', 'F012');

-- --------------------------------------------------------

--
-- Table structure for table `joining_detail`
--

CREATE TABLE IF NOT EXISTS `joining_detail` (
  `JNG_ID` int(11) NOT NULL AUTO_INCREMENT,
  `DOJ` varchar(25) CHARACTER SET utf8 NOT NULL,
  `EMP_ID` varchar(15) CHARACTER SET utf8 NOT NULL,
  PRIMARY KEY (`JNG_ID`),
  KEY `EMP_ID` (`EMP_ID`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;

--
-- Dumping data for table `joining_detail`
--

INSERT INTO `joining_detail` (`JNG_ID`, `DOJ`, `EMP_ID`) VALUES
(1, '//', 'F009'),
(2, '1/1/2014', 'F010'),
(3, '1/1/2014', 'F011'),
(4, '1/2/2014', 'F012');

-- --------------------------------------------------------

--
-- Table structure for table `leave_approved`
--

CREATE TABLE IF NOT EXISTS `leave_approved` (
  `LV_APPROVED_ID` int(11) NOT NULL AUTO_INCREMENT,
  `TRAN_ID` int(11) NOT NULL,
  `APPROVED_BY` varchar(50) CHARACTER SET utf8 NOT NULL,
  PRIMARY KEY (`LV_APPROVED_ID`),
  KEY `TRAN_ID` (`TRAN_ID`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `leave_approved`
--

INSERT INTO `leave_approved` (`LV_APPROVED_ID`, `TRAN_ID`, `APPROVED_BY`) VALUES
(1, 1, 'mkp');

-- --------------------------------------------------------

--
-- Table structure for table `leave_cancelled`
--

CREATE TABLE IF NOT EXISTS `leave_cancelled` (
  `LV_CANCELLED_ID` int(11) NOT NULL AUTO_INCREMENT,
  `TRAN_ID` int(11) NOT NULL,
  `REASON_OF_CANCLE` text NOT NULL,
  `CANCEL_BY` varchar(50) CHARACTER SET utf8 NOT NULL,
  PRIMARY KEY (`LV_CANCELLED_ID`),
  KEY `TRAN_ID` (`TRAN_ID`),
  KEY `TRAN_ID_2` (`TRAN_ID`),
  KEY `TRAN_ID_3` (`TRAN_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `leave_cancelled`
--


-- --------------------------------------------------------

--
-- Table structure for table `leave_detail`
--

CREATE TABLE IF NOT EXISTS `leave_detail` (
  `LEAVE_ID` int(11) NOT NULL AUTO_INCREMENT,
  `LEAVE_CATEGORY` varchar(200) CHARACTER SET utf8 NOT NULL,
  `ABBREVIATION` varchar(25) CHARACTER SET utf8 NOT NULL,
  `ELIGIBILITY` int(11) NOT NULL COMMENT 'IN YEARS',
  `QUANTITY` varchar(10) CHARACTER SET utf8 NOT NULL,
  `DETAIL_IF_ANY` text NOT NULL,
  PRIMARY KEY (`LEAVE_ID`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;

--
-- Dumping data for table `leave_detail`
--

INSERT INTO `leave_detail` (`LEAVE_ID`, `LEAVE_CATEGORY`, `ABBREVIATION`, `ELIGIBILITY`, `QUANTITY`, `DETAIL_IF_ANY`) VALUES
(1, 'casual leave', 'cl', 0, '12', 'x'),
(2, 'Medical Leave 1', 'ml-1', 0, '5', 'x'),
(3, 'Medical Leave 2', 'ml-2', 2, '7', 'x'),
(4, 'Earned Leave', 'el', 0, '0', 'x');

-- --------------------------------------------------------

--
-- Table structure for table `leave_status`
--

CREATE TABLE IF NOT EXISTS `leave_status` (
  `LV_STATUS_ID` int(11) NOT NULL AUTO_INCREMENT,
  `LV_STATUS` varchar(100) CHARACTER SET utf8 NOT NULL COMMENT 'Pending,rejected,approved',
  PRIMARY KEY (`LV_STATUS_ID`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;

--
-- Dumping data for table `leave_status`
--

INSERT INTO `leave_status` (`LV_STATUS_ID`, `LV_STATUS`) VALUES
(4, 'PENDING'),
(5, 'APPROVED'),
(6, 'REJECTED');

-- --------------------------------------------------------

--
-- Table structure for table `leave_summary`
--

CREATE TABLE IF NOT EXISTS `leave_summary` (
  `LV_SUM_ID` int(11) NOT NULL AUTO_INCREMENT,
  `EMP_ID` varchar(15) CHARACTER SET utf8 NOT NULL,
  `LEAVE_ID` int(11) NOT NULL,
  `TOTAL_LEAVE` int(11) NOT NULL,
  `OBTAINED_LEAVE` int(11) NOT NULL,
  `LEFT_LEAVE` int(11) NOT NULL COMMENT 'Automatically ',
  `CANCELLED_LEAVE` int(11) NOT NULL,
  `YEAR` varchar(10) CHARACTER SET utf8 NOT NULL,
  PRIMARY KEY (`LV_SUM_ID`),
  KEY `EMP_ID` (`EMP_ID`),
  KEY `LEAVE_ID` (`LEAVE_ID`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `leave_summary`
--

INSERT INTO `leave_summary` (`LV_SUM_ID`, `EMP_ID`, `LEAVE_ID`, `TOTAL_LEAVE`, `OBTAINED_LEAVE`, `LEFT_LEAVE`, `CANCELLED_LEAVE`, `YEAR`) VALUES
(1, 'FOO7', 1, 12, 1, 11, 0, '2014');

-- --------------------------------------------------------

--
-- Table structure for table `leave_transaction`
--

CREATE TABLE IF NOT EXISTS `leave_transaction` (
  `TRAN_ID` int(11) NOT NULL AUTO_INCREMENT,
  `EMP_ID` varchar(15) CHARACTER SET utf8 NOT NULL,
  `LEAVE_ID` int(11) NOT NULL,
  `DATE_FROM` varchar(25) CHARACTER SET utf8 NOT NULL,
  `DATE_TO` varchar(25) CHARACTER SET utf8 NOT NULL,
  `REASON` text NOT NULL,
  `QTY` int(11) NOT NULL,
  `LV_STATUS_ID` int(11) NOT NULL,
  PRIMARY KEY (`TRAN_ID`),
  KEY `EMP_ID` (`EMP_ID`),
  KEY `EMP_ID_2` (`EMP_ID`),
  KEY `LEAVE_ID` (`LEAVE_ID`),
  KEY `EMP_ID_3` (`EMP_ID`),
  KEY `LEAVE_ID_2` (`LEAVE_ID`),
  KEY `EMP_ID_4` (`EMP_ID`),
  KEY `LEAVE_ID_3` (`LEAVE_ID`),
  KEY `EMP_ID_5` (`EMP_ID`),
  KEY `LEAVE_ID_4` (`LEAVE_ID`),
  KEY `LV_STATUS_ID` (`LV_STATUS_ID`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `leave_transaction`
--

INSERT INTO `leave_transaction` (`TRAN_ID`, `EMP_ID`, `LEAVE_ID`, `DATE_FROM`, `DATE_TO`, `REASON`, `QTY`, `LV_STATUS_ID`) VALUES
(1, 'FOO7', 1, '12/04/2014', '15/4/2014', 'PERSONAL', 4, 5);

-- --------------------------------------------------------

--
-- Table structure for table `university`
--

CREATE TABLE IF NOT EXISTS `university` (
  `UNIV_ID` varchar(11) CHARACTER SET utf8 NOT NULL,
  `UNIV_NAME` varchar(250) CHARACTER SET utf8 NOT NULL,
  `ABREV` varchar(50) CHARACTER SET utf8 NOT NULL,
  PRIMARY KEY (`UNIV_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `university`
--

INSERT INTO `university` (`UNIV_ID`, `UNIV_NAME`, `ABREV`) VALUES
('1', 'utu', 'utu');

-- --------------------------------------------------------

--
-- Table structure for table `user_login`
--

CREATE TABLE IF NOT EXISTS `user_login` (
  `USER_NAME` varchar(30) CHARACTER SET utf8 NOT NULL,
  `PASSWORD` varchar(20) CHARACTER SET utf8 NOT NULL,
  `CLG_ID` int(11) NOT NULL,
  `CRS_ID` int(11) NOT NULL,
  `STATUS_ID` int(11) NOT NULL,
  PRIMARY KEY (`USER_NAME`),
  KEY `STATUS_ID` (`STATUS_ID`),
  KEY `DEPT_ID` (`CLG_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `user_login`
--

INSERT INTO `user_login` (`USER_NAME`, `PASSWORD`, `CLG_ID`, `CRS_ID`, `STATUS_ID`) VALUES
('admin', '123', 0, 0, 1),
('aspandan123', '123', 0, 0, 5),
('aspandan1235', '123', 0, 0, 6),
('mkp', '123', 0, 0, 2),
('mks', '123', 0, 0, 3),
('nitin', '123', 0, 0, 5);

-- --------------------------------------------------------

--
-- Table structure for table `user_status`
--

CREATE TABLE IF NOT EXISTS `user_status` (
  `STATUS_ID` int(11) NOT NULL AUTO_INCREMENT,
  `STATUS` varchar(25) CHARACTER SET utf8 NOT NULL,
  PRIMARY KEY (`STATUS_ID`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;

--
-- Dumping data for table `user_status`
--

INSERT INTO `user_status` (`STATUS_ID`, `STATUS`) VALUES
(1, 'ADMIN'),
(2, 'DIRECTOR'),
(3, 'COURSE COORDINATOR'),
(4, 'HEAD OF DEPARTMENT'),
(5, 'FACULTY'),
(6, 'GUEST');

--
-- Constraints for dumped tables
--

--
-- Constraints for table `associate_course`
--
ALTER TABLE `associate_course`
  ADD CONSTRAINT `associate_course_ibfk_1` FOREIGN KEY (`COURSE_ID`) REFERENCES `associate_course` (`COURSE_ID`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `associate_course_ibfk_2` FOREIGN KEY (`EMP_ID`) REFERENCES `emp_pers_detail` (`EMP_ID`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `associate_design`
--
ALTER TABLE `associate_design`
  ADD CONSTRAINT `associate_design_ibfk_1` FOREIGN KEY (`EMP_ID`) REFERENCES `emp_pers_detail` (`EMP_ID`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `associate_design_ibfk_2` FOREIGN KEY (`DESIG_ID`) REFERENCES `designation_master` (`DESIG_ID`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `course`
--
ALTER TABLE `course`
  ADD CONSTRAINT `course_ibfk_1` FOREIGN KEY (`UNIV_ID`) REFERENCES `university` (`UNIV_ID`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `emp_address_detail`
--
ALTER TABLE `emp_address_detail`
  ADD CONSTRAINT `emp_address_detail_ibfk_1` FOREIGN KEY (`EMP_ID`) REFERENCES `emp_pers_detail` (`EMP_ID`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `emp_contact_detail`
--
ALTER TABLE `emp_contact_detail`
  ADD CONSTRAINT `emp_contact_detail_ibfk_1` FOREIGN KEY (`EMP_ID`) REFERENCES `emp_pers_detail` (`EMP_ID`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `emp_pers_detail`
--
ALTER TABLE `emp_pers_detail`
  ADD CONSTRAINT `emp_pers_detail_ibfk_1` FOREIGN KEY (`USER_NAME`) REFERENCES `user_login` (`USER_NAME`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `emp_qualification`
--
ALTER TABLE `emp_qualification`
  ADD CONSTRAINT `emp_qualification_ibfk_1` FOREIGN KEY (`EMP_ID`) REFERENCES `emp_pers_detail` (`EMP_ID`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `joining_detail`
--
ALTER TABLE `joining_detail`
  ADD CONSTRAINT `joining_detail_ibfk_1` FOREIGN KEY (`EMP_ID`) REFERENCES `emp_pers_detail` (`EMP_ID`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `leave_approved`
--
ALTER TABLE `leave_approved`
  ADD CONSTRAINT `leave_approved_ibfk_1` FOREIGN KEY (`TRAN_ID`) REFERENCES `leave_transaction` (`TRAN_ID`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `leave_cancelled`
--
ALTER TABLE `leave_cancelled`
  ADD CONSTRAINT `leave_cancelled_ibfk_1` FOREIGN KEY (`TRAN_ID`) REFERENCES `leave_transaction` (`TRAN_ID`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `leave_summary`
--
ALTER TABLE `leave_summary`
  ADD CONSTRAINT `leave_summary_ibfk_1` FOREIGN KEY (`EMP_ID`) REFERENCES `emp_pers_detail` (`EMP_ID`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `leave_summary_ibfk_2` FOREIGN KEY (`LEAVE_ID`) REFERENCES `leave_detail` (`LEAVE_ID`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `leave_transaction`
--
ALTER TABLE `leave_transaction`
  ADD CONSTRAINT `leave_transaction_ibfk_1` FOREIGN KEY (`EMP_ID`) REFERENCES `emp_pers_detail` (`EMP_ID`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `leave_transaction_ibfk_2` FOREIGN KEY (`LEAVE_ID`) REFERENCES `leave_detail` (`LEAVE_ID`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `leave_transaction_ibfk_3` FOREIGN KEY (`LV_STATUS_ID`) REFERENCES `leave_status` (`LV_STATUS_ID`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `user_login`
--
ALTER TABLE `user_login`
  ADD CONSTRAINT `user_login_ibfk_1` FOREIGN KEY (`STATUS_ID`) REFERENCES `user_status` (`STATUS_ID`) ON DELETE CASCADE ON UPDATE CASCADE;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;