API tools faq
paste
Advertisement
Guest User

Leave_management

a guest
Jan 17th, 2017
105
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 7.43 KB | None | 0 0
raw download clone embed print report
  1. -- phpMyAdmin SQL Dump
  2. -- version 4.5.1
  3. -- http://www.phpmyadmin.net
  4. --
  5. -- Host: 127.0.0.1
  6. -- Generation Time: Jan 17, 2017 at 06:00 PM
  7. -- Server version: 10.1.16-MariaDB
  8. -- PHP Version: 7.0.9
  9.  
  10. SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
  11. SET time_zone = "+00:00";
  12.  
  13.  
  14. /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
  15. /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
  16. /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
  17. /*!40101 SET NAMES utf8mb4 */;
  18.  
  19. --
  20. -- Database: `leave_management`
  21. --
  22.  
  23. -- --------------------------------------------------------
  24.  
  25. --
  26. -- Table structure for table `leave_query`
  27. --
  28.  
  29. CREATE TABLE `leave_query` (
  30. `id` int(11) NOT NULL,
  31. `userid` varchar(30) NOT NULL,
  32. `designation` varchar(100) NOT NULL,
  33. `department` varchar(100) NOT NULL,
  34. `staff_fullname` varchar(100) NOT NULL,
  35. `leave_start_date` date NOT NULL,
  36. `leave_end_date` date NOT NULL,
  37. `leave_type` varchar(100) NOT NULL,
  38. `leave_reason` varchar(200) NOT NULL,
  39. `total_leave` varchar(50) NOT NULL,
  40. `remain_leave` varchar(20) DEFAULT NULL,
  41. `hod_status` varchar(100) NOT NULL,
  42. `name` varchar(100) NOT NULL,
  43. `img_path` varchar(50) NOT NULL,
  44. `course_name_one` varchar(20) NOT NULL,
  45. `dateof_missed_class_one` varchar(10) DEFAULT NULL,
  46. `timeof_missed_date_one` varchar(20) NOT NULL,
  47. `dateof_taking_class_one` date NOT NULL,
  48. `timeof_taking_class_one` varchar(20) NOT NULL,
  49. `course_name_two` varchar(20) NOT NULL,
  50. `dateof_missed_class_two` date NOT NULL,
  51. `timeof_missed_date_two` varchar(20) NOT NULL,
  52. `dateof_taking_class_two` date NOT NULL,
  53. `timeof_taking_class_two` varchar(20) NOT NULL,
  54. `course_name_three` varchar(20) NOT NULL,
  55. `dateof_missed_class_three` date NOT NULL,
  56. `timeof_missed_date_three` varchar(20) NOT NULL,
  57. `dateof_taking_class_three` date NOT NULL,
  58. `timeof_taking_class_three` varchar(20) NOT NULL,
  59. `course_name_four` varchar(20) NOT NULL,
  60. `dateof_missed_class_four` date NOT NULL,
  61. `timeof_missed_date_four` varchar(20) NOT NULL,
  62. `dateof_taking_class_four` date NOT NULL,
  63. `timeof_taking_class_four` varchar(20) NOT NULL,
  64. `course_name_five` varchar(20) NOT NULL,
  65. `dateof_missed_class_five` date NOT NULL,
  66. `timeof_missed_date_five` varchar(20) NOT NULL,
  67. `dateof_taking_class_five` date NOT NULL,
  68. `timeof_taking_class_five` varchar(20) NOT NULL
  69. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  70.  
  71. --
  72. -- Dumping data for table `leave_query`
  73. --
  74.  
  75. INSERT INTO `leave_query` (`id`, `userid`, `designation`, `department`, `staff_fullname`, `leave_start_date`, `leave_end_date`, `leave_type`, `leave_reason`, `total_leave`, `remain_leave`, `hod_status`, `name`, `img_path`, `course_name_one`, `dateof_missed_class_one`, `timeof_missed_date_one`, `dateof_taking_class_one`, `timeof_taking_class_one`, `course_name_two`, `dateof_missed_class_two`, `timeof_missed_date_two`, `dateof_taking_class_two`, `timeof_taking_class_two`, `course_name_three`, `dateof_missed_class_three`, `timeof_missed_date_three`, `dateof_taking_class_three`, `timeof_taking_class_three`, `course_name_four`, `dateof_missed_class_four`, `timeof_missed_date_four`, `dateof_taking_class_four`, `timeof_taking_class_four`, `course_name_five`, `dateof_missed_class_five`, `timeof_missed_date_five`, `dateof_taking_class_five`, `timeof_taking_class_five`) VALUES
  76. (183, '125', 'Faculty Member', 'Department of CSE', 'Iffat Jahan Choudhury', '2017-01-17', '2017-01-18', 'Medical Leave', 'I have some problem.', '2', '12', 'Approved', 'uploads/Penguins.jpg', 'uploads/', 'CSE-1213', '2017-01-18', '11:00-12:30', '2017-01-21', '1:00-2:00', '', '0000-00-00', '', '0000-00-00', '', '', '0000-00-00', '', '0000-00-00', '', '', '0000-00-00', '', '0000-00-00', '', '', '0000-00-00', '', '0000-00-00', ''),
  77. (184, '127', 'Faculty Member', 'Department of CSE', 'Md. Saiful Ambia Chowdhury', '2017-01-23', '2017-01-25', 'Duty leave', 'Need it badly.', '3', '11', 'Not Approved', 'uploads/', 'uploads/', 'EEE-2111', '2017-01-24', '11:00-12:30', '2017-01-28', '9:30-11:00', '', '0000-00-00', '', '0000-00-00', '', '', '0000-00-00', '', '0000-00-00', '', '', '0000-00-00', '', '0000-00-00', '', '', '0000-00-00', '', '0000-00-00', ''),
  78. (185, '126', 'Faculty Member', 'Department of CSE', 'Md. Ebrahim Hossain', '2017-01-24', '2017-01-28', 'Duty leave', 'DDDDD', '5', '9', 'Not Approved', 'uploads/', 'uploads/', 'CSE-4111', '2017-01-26', '11:00-12:30', '2017-01-30', '12:30-1:00', 'EEE-4111', '2017-01-24', '11:00-12:30', '2017-01-30', '9:30-11:00', '', '0000-00-00', '', '0000-00-00', '', '', '0000-00-00', '', '0000-00-00', '', '', '0000-00-00', '', '0000-00-00', ''),
  79. (186, '125', 'Faculty Member', 'Department of CSE', 'Iffat Jahan Choudhury', '2017-01-18', '2017-01-20', 'Duty leave', 'I dont know', '3', '9', 'Not Approved', 'uploads/', 'uploads/', '', '', '', '0000-00-00', '', '', '0000-00-00', '', '0000-00-00', '', '', '0000-00-00', '', '0000-00-00', '', '', '0000-00-00', '', '0000-00-00', '', '', '0000-00-00', '', '0000-00-00', ''),
  80. (187, '125', 'Faculty Member', 'Department of CSE', 'Iffat Jahan Choudhury', '2017-01-01', '2017-01-24', 'Duty leave', 'DADA', '24', '-15', 'Not Approved', 'uploads/', 'uploads/', 'CSE - 1232', '2017-01-09', '3-5', '2017-01-19', '5-6', '', '0000-00-00', '', '0000-00-00', '', '', '0000-00-00', '', '0000-00-00', '', '', '0000-00-00', '', '0000-00-00', '', '', '0000-00-00', '', '0000-00-00', '');
  81.  
  82. -- --------------------------------------------------------
  83.  
  84. --
  85. -- Table structure for table `login_details`
  86. --
  87.  
  88. CREATE TABLE `login_details` (
  89. `id` int(11) NOT NULL,
  90. `hod_id` int(30) NOT NULL,
  91. `userid` varchar(30) NOT NULL,
  92. `department` varchar(50) NOT NULL,
  93. `designation` varchar(50) NOT NULL,
  94. `name` varchar(100) NOT NULL,
  95. `password` varchar(100) NOT NULL,
  96. `staff_fullname` varchar(100) NOT NULL,
  97. `email` varchar(50) NOT NULL,
  98. `leave_total` varchar(10) NOT NULL
  99. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  100.  
  101. --
  102. -- Dumping data for table `login_details`
  103. --
  104.  
  105. INSERT INTO `login_details` (`id`, `hod_id`, `userid`, `department`, `designation`, `name`, `password`, `staff_fullname`, `email`, `leave_total`) VALUES
  106. (20, 10, '122', 'Department of CSE', 'HOD', 'mak', '123', 'Md. Asaduzzaman Khan', 'mak@gmail.com', '14'),
  107. (23, 0, '125', 'Department of CSE', 'Faculty Member', 'iffat', '123456', 'Iffat Jahan Choudhury', 'iffat@gmail.com', '14'),
  108. (24, 0, '126', 'Department of CSE', 'Faculty Member', 'ebrahim', '654321', 'Md. Ebrahim Hossain', 'ebrahim@gmail.com', '14'),
  109. (25, 0, '127', 'Department of CSE', 'Faculty Member', 'saiful', '333', 'Md. Saiful Ambia Chowdhury', 'saiful@gmail.com', '14'),
  110. (26, 0, '128', 'Department of CSE', 'Faculty Member', 'mhb', '123321', 'Minhazul Haque Bhuiyan', 'mihaz@gmail.com', '14');
  111.  
  112. --
  113. -- Indexes for dumped tables
  114. --
  115.  
  116. --
  117. -- Indexes for table `leave_query`
  118. --
  119. ALTER TABLE `leave_query`
  120. ADD PRIMARY KEY (`id`);
  121.  
  122. --
  123. -- Indexes for table `login_details`
  124. --
  125. ALTER TABLE `login_details`
  126. ADD PRIMARY KEY (`id`);
  127.  
  128. --
  129. -- AUTO_INCREMENT for dumped tables
  130. --
  131.  
  132. --
  133. -- AUTO_INCREMENT for table `leave_query`
  134. --
  135. ALTER TABLE `leave_query`
  136. MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=188;
  137. --
  138. -- AUTO_INCREMENT for table `login_details`
  139. --
  140. ALTER TABLE `login_details`
  141. MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=27;
  142. /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
  143. /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
  144. /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!