PageRenderTime 58ms CodeModel.GetById 21ms RepoModel.GetById 0ms app.codeStats 1ms

/db/lab.sql

https://gitlab.com/cserobiul/BITM-LabMs-New
SQL | 286 lines | 153 code | 41 blank | 92 comment | 0 complexity | 15bb5795d26dee84cf8b17541ac03470 MD5 | raw file
    

  1. -- phpMyAdmin SQL Dump
    2. 

  2. -- version 4.4.14
    3. 

  3. -- http://www.phpmyadmin.net
    4. 

  4. --
    5. 

  5. -- Host: 127.0.0.1
    6. 

  6. -- Generation Time: Aug 14, 2016 at 10:07 AM
    7. 

  7. -- Server version: 5.6.26
    8. 

  8. -- PHP Version: 5.6.12
    9. 

  9. 

  10. SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
    11. 

  11. SET time_zone = "+00:00";
    12. 

  12. 

  13. 

  14. /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
    15. 

  15. /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
    16. 

  16. /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
    17. 

  17. /*!40101 SET NAMES utf8mb4 */;
    18. 

  18. 

  19. --
    20. 

  20. -- Database: `lab`
    21. 

  21. --
    22. 

  22. 

  23. -- --------------------------------------------------------
    24. 

  24. 

  25. --
    26. 

  26. -- Table structure for table `courses`
    27. 

  27. --
    28. 

  28. 

  29. CREATE TABLE IF NOT EXISTS `courses` (
    30. 

  30.   `id` int(11) NOT NULL,
    31. 

  31.   `unique_id` varchar(111) NOT NULL,
    32. 

  32.   `title` varchar(111) NOT NULL,
    33. 

  33.   `duration` varchar(255) NOT NULL,
    34. 

  34.   `description` varchar(500) NOT NULL,
    35. 

  35.   `course_type` varchar(50) NOT NULL,
    36. 

  36.   `course_fee` varchar(111) NOT NULL,
    37. 

  37.   `is_active` int(10) NOT NULL,
    38. 

  38.   `created` datetime NOT NULL,
    39. 

  39.   `updated` datetime NOT NULL,
    40. 

  40.   `deleted` datetime NOT NULL
    41. 

  41. ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;
    42. 

  42. 

  43. --
    44. 

  44. -- Dumping data for table `courses`
    45. 

  45. --
    46. 

  46. 

  47. INSERT INTO `courses` (`id`, `unique_id`, `title`, `duration`, `description`, `course_type`, `course_fee`, `is_active`, `created`, `updated`, `deleted`) VALUES
    48. 

  48. (1, '57906272d0888', 'Web App Development', '3 month,144 hours', 'it''s basically php course', 'free', '00', 1, '2016-08-08 02:08:12', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
    49. 

  49. (2, '346324685676h7', 'Computer IT Support', '3 month, 144 hours', 'hmm', 'free', '00', 1, '2016-08-08 00:04:11', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
    50. 

  50. (3, '84832sd8384d6d', 'Core java', '90 Days, 150 Hours', 'Object-oriented Programming\n', 'paid', '15000', 1, '2016-08-08 02:06:05', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
    51. 

  51. (4, '57a677689eaf6', 'Graphics Design', '90 days, 150 hours', 'hmm', 'free', '00', 1, '2016-08-09 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
    52. 

  52. 

  53. -- --------------------------------------------------------
    54. 

  54. 

  55. --
    56. 

  56. -- Table structure for table `course_trainer_lab_mapping`
    57. 

  57. --
    58. 

  58. 

  59. CREATE TABLE IF NOT EXISTS `course_trainer_lab_mapping` (
    60. 

  60.   `id` int(11) NOT NULL,
    61. 

  61.   `course_id` varchar(111) NOT NULL,
    62. 

  62.   `batch_no` varchar(111) NOT NULL,
    63. 

  63.   `lead_trainer` varchar(111) NOT NULL,
    64. 

  64.   `asst_trainer` varchar(111) NOT NULL,
    65. 

  65.   `lab_asst` varchar(111) NOT NULL,
    66. 

  66.   `lab_id` varchar(111) NOT NULL,
    67. 

  67.   `start_date` date NOT NULL,
    68. 

  68.   `ending_date` date NOT NULL,
    69. 

  69.   `start_time` varchar(111) NOT NULL,
    70. 

  70.   `ending_time` varchar(111) NOT NULL,
    71. 

  71.   `day` varchar(111) NOT NULL,
    72. 

  72.   `is_delete` int(1) NOT NULL,
    73. 

  73.   `assigned_by` varchar(255) NOT NULL,
    74. 

  74.   `created` datetime NOT NULL,
    75. 

  75.   `updated` datetime NOT NULL,
    76. 

  76.   `deleted` datetime NOT NULL
    77. 

  77. ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;
    78. 

  78. 

  79. --
    80. 

  80. -- Dumping data for table `course_trainer_lab_mapping`
    81. 

  81. --
    82. 

  82. 

  83. INSERT INTO `course_trainer_lab_mapping` (`id`, `course_id`, `batch_no`, `lead_trainer`, `asst_trainer`, `lab_asst`, `lab_id`, `start_date`, `ending_date`, `start_time`, `ending_time`, `day`, `is_delete`, `assigned_by`, `created`, `updated`, `deleted`) VALUES
    84. 

  84. (1, '57906272d0888', '28', '78d7s87d8sds', '93c9394777', 'd7f8d78f7d8', '402', '2016-05-16', '2016-08-16', '18.00', '21.00', '3', 0, 'arif', '2016-08-02 00:00:00', '2016-08-12 23:20:00', '0000-00-00 00:00:00'),
    85. 

  85. (2, '84832sd8384d6d', '12', '8dfd8f8d7f87d8', 'c7834838v838h', 'd8fd8f8d6f6d', '404', '2016-05-17', '2016-08-14', '13.30', '17.30', '3', 0, 'arif', '2016-08-09 00:00:00', '2016-08-14 01:18:00', '0000-00-00 00:00:00'),
    86. 

  86. (3, '57906272d0888', '27', '78d7s87d8sds', '93c9394777', 'd7f8d78f7d8', '402', '2016-05-16', '2016-08-16', '13.30', '17.30', '2', 0, 'arif', '2016-05-11 00:00:00', '2016-08-12 23:17:00', '0000-00-00 00:00:00'),
    87. 

  87. (4, '57a677689eaf6', '29', 'f8sd78f7sd87f8', 'c7834838v838h', 'd8fd8f8d6f6d', '403', '2016-05-11', '2016-08-15', '8.00', '11.00', '3', 0, 'arif', '0000-00-00 00:00:00', '2016-08-13 00:24:00', '0000-00-00 00:00:00'),
    88. 

  88. (5, '84832sd8384d6d', '12', '8dfd8f8d7f87d8', 'c7834838v838h', 'd8fd8f8d6f6d', '403', '2016-07-06', '2016-08-24', '8.00', '12.00', '2', 0, 'arif', '2016-08-14 11:24:00', '2016-08-14 01:18:00', '0000-00-00 00:00:00'),
    89. 

  89. (6, '57906272d0888', '27', '78d7s87d8sds', '93c9394777', 'd7f8d78f7d8', '402', '2016-08-19', '2016-08-19', '15.00', '17.00', '1', 0, 'arif', '2016-08-14 11:46:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
    90. 

  90. 

  91. -- --------------------------------------------------------
    92. 

  92. 

  93. --
    94. 

  94. -- Table structure for table `installed_softwares`
    95. 

  95. --
    96. 

  96. 

  97. CREATE TABLE IF NOT EXISTS `installed_softwares` (
    98. 

  98.   `id` int(11) NOT NULL,
    99. 

  99.   `labinfo_id` int(111) NOT NULL,
    100. 

  100.   `software_title` varchar(111) NOT NULL,
    101. 

  101.   `version` varchar(111) NOT NULL,
    102. 

  102.   `software_type` varchar(111) NOT NULL,
    103. 

  103.   `created` datetime NOT NULL,
    104. 

  104.   `updated` datetime NOT NULL,
    105. 

  105.   `deleted` datetime NOT NULL
    106. 

  106. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
    107. 

  107. 

  108. -- --------------------------------------------------------
    109. 

  109. 

  110. --
    111. 

  111. -- Table structure for table `labinfo`
    112. 

  112. --
    113. 

  113. 

  114. CREATE TABLE IF NOT EXISTS `labinfo` (
    115. 

  115.   `id` int(11) NOT NULL,
    116. 

  116.   `course_id` varchar(100) NOT NULL,
    117. 

  117.   `lab_no` varchar(111) NOT NULL,
    118. 

  118.   `seat_capacity` varchar(111) NOT NULL,
    119. 

  119.   `projector_resolution` varchar(111) NOT NULL,
    120. 

  120.   `ac_status` varchar(111) NOT NULL,
    121. 

  121.   `pc_configuration` varchar(255) NOT NULL,
    122. 

  122.   `os` varchar(255) NOT NULL,
    123. 

  123.   `trainer_pc_configuration` varchar(255) NOT NULL,
    124. 

  124.   `table_capacity` varchar(100) NOT NULL,
    125. 

  125.   `internet_speed` varchar(100) NOT NULL,
    126. 

  126.   `created` datetime NOT NULL,
    127. 

  127.   `updated` datetime NOT NULL,
    128. 

  128.   `deleted` datetime NOT NULL
    129. 

  129. ) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=latin1;
    130. 

  130. 

  131. --
    132. 

  132. -- Dumping data for table `labinfo`
    133. 

  133. --
    134. 

  134. 

  135. INSERT INTO `labinfo` (`id`, `course_id`, `lab_no`, `seat_capacity`, `projector_resolution`, `ac_status`, `pc_configuration`, `os`, `trainer_pc_configuration`, `table_capacity`, `internet_speed`, `created`, `updated`, `deleted`) VALUES
    136. 

  136. (16, '57a677689eaf6', '405', '30', '1024x768', '1', 'a:4:{s:9:"processor";s:10:"Core 2 Due";s:3:"ram";s:4:"2 gb";s:5:"brand";s:4:"Dell";s:2:"os";s:11:"Windows 8.1";}', '', 'a:4:{s:9:"processor";s:7:"Core I5";s:3:"ram";s:4:"4 gb";s:5:"brand";s:4:"Dell";s:2:"os";s:3:"Mac";}', '20', '5 MB', '2016-08-10 09:43:25', '2016-08-10 14:58:51', '0000-00-00 00:00:00'),
    137. 

  137. (17, '57906272d0888', '402', '35', '1024x768', '2', 'a:4:{s:9:"processor";s:7:"Core I5";s:3:"ram";s:4:"2 gb";s:5:"brand";s:4:"Dell";s:2:"os";s:11:"Windows 8.1";}', '', 'a:4:{s:9:"processor";s:7:"Core I7";s:3:"ram";s:4:"8 gb";s:5:"brand";s:7:"Sumsang";s:2:"os";s:3:"Mac";}', '15', '2 MB', '2016-08-10 15:01:32', '2016-08-10 15:02:26', '0000-00-00 00:00:00'),
    138. 

  138. (18, '346324685676h7', '401', '32', '1024x768', '4', 'a:4:{s:9:"processor";s:10:"Core 2 Due";s:3:"ram";s:4:"2 GB";s:5:"brand";s:7:"Sumsang";s:2:"os";s:9:"Windows 8";}', '', 'a:4:{s:9:"processor";s:7:"Celeron";s:3:"ram";s:4:"4 GB";s:5:"brand";s:7:"Sumsang";s:2:"os";s:3:"Mac";}', '20', '1 MB', '2016-08-11 05:33:46', '2016-08-14 10:04:20', '0000-00-00 00:00:00'),
    139. 

  139. (19, '84832sd8384d6d', '403', '30', '1024x768', '2', 'a:4:{s:9:"processor";s:11:"Core 2 Quad";s:3:"ram";s:4:"2 GB";s:5:"brand";s:7:"Sumsang";s:2:"os";s:9:"Windows 8";}', '', 'a:4:{s:9:"processor";s:7:"Celeron";s:3:"ram";s:4:"2 GB";s:5:"brand";s:4:"Dell";s:2:"os";s:3:"Mac";}', '15', '2 MB', '2016-08-11 05:35:06', '2016-08-14 10:00:45', '0000-00-00 00:00:00'),
    140. 

  140. (20, '57906272d0888', '404', '30', '1024x768', '2', 'a:4:{s:9:"processor";s:7:"Core I5";s:3:"ram";s:4:"4 gb";s:5:"brand";s:7:"Sumsang";s:2:"os";s:10:"Windows 10";}', '', 'a:4:{s:9:"processor";s:7:"Core I7";s:3:"ram";s:4:"8 gb";s:5:"brand";N;s:2:"os";s:3:"Mac";}', '18', '2 MB', '2016-08-11 05:35:50', '2016-08-14 06:09:19', '0000-00-00 00:00:00'),
    141. 

  141. (21, '57a677689eaf6', '503', '32', '1024x768', '2', 'a:4:{s:9:"processor";s:10:"core 2 due";s:3:"ram";s:4:"2 gb";s:5:"brand";s:7:"sumsang";s:2:"os";s:9:"windows 8";}', '', 'a:4:{s:9:"processor";s:7:"core i5";s:3:"ram";s:4:"4 gb";s:5:"brand";s:7:"sumsang";s:2:"os";s:3:"mac";}', '12', '1 MB', '2016-08-14 10:07:12', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
    142. 

  142. 

  143. -- --------------------------------------------------------
    144. 

  144. 

  145. --
    146. 

  146. -- Table structure for table `trainers`
    147. 

  147. --
    148. 

  148. 

  149. CREATE TABLE IF NOT EXISTS `trainers` (
    150. 

  150.   `id` int(11) NOT NULL,
    151. 

  151.   `unique_id` varchar(111) NOT NULL,
    152. 

  152.   `full_name` varchar(111) NOT NULL,
    153. 

  153.   `edu_status` varchar(255) NOT NULL,
    154. 

  154.   `team` varchar(111) NOT NULL,
    155. 

  155.   `course_name` varchar(111) NOT NULL,
    156. 

  156.   `trainer_level` varchar(111) NOT NULL,
    157. 

  157.   `image` varchar(255) NOT NULL,
    158. 

  158.   `phone` varchar(20) NOT NULL,
    159. 

  159.   `email` varchar(111) NOT NULL,
    160. 

  160.   `address` varchar(255) NOT NULL,
    161. 

  161.   `gender` varchar(20) NOT NULL,
    162. 

  162.   `web` varchar(111) NOT NULL,
    163. 

  163.   `created` datetime NOT NULL,
    164. 

  164.   `updated` datetime NOT NULL,
    165. 

  165.   `deleted` datetime NOT NULL
    166. 

  166. ) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;
    167. 

  167. 

  168. --
    169. 

  169. -- Dumping data for table `trainers`
    170. 

  170. --
    171. 

  171. 

  172. INSERT INTO `trainers` (`id`, `unique_id`, `full_name`, `edu_status`, `team`, `course_name`, `trainer_level`, `image`, `phone`, `email`, `address`, `gender`, `web`, `created`, `updated`, `deleted`) VALUES
    173. 

  173. (1, '78d7s87d8sds', 'Jadid sir', 'm.sc in cse', 'code breaker', '57906272d0888', '1', '', '01890098909', 'jadid@gmail.com', 'dhaka', 'male', 'hmm.com', '2016-08-09 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
    174. 

  174. (2, '93c9394777', 'sumon mahmud', 'b.sc in cse', 'code breaker', '57906272d0888', '2', '', '01909909009', 'sumon@gmail.com', 'dhaka', 'male', 'hmm2.com', '2016-08-09 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
    175. 

  175. (3, 'd7f8d78f7d8', 'sayem morshed', 'diploma in computer', 'code breaker', '57906272d0888', '3', '', '01000000000', 'sayem@gmail.com', 'dhaka', 'male', 'hmm3.com', '2016-08-09 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
    176. 

  176. (4, 'c7834838v838h', 'sahara khatun', 'b.sc in cse', 'div vill', '84832sd8384d6d', '2', '', '01909879098', 'sahara@gmail.com', 'dhaka', 'female', 'hmm4.com', '2016-08-10 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
    177. 

  177. (5, 'f8sd78f7sd87f8', 'Madar Teresa', 'm.sc in cse', 'code breaker', '57906272d0888', '1', '', '01987000099', 'terasa@gmail.com', 'dhaka', 'female', 'hmm.com', '2016-08-09 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
    178. 

  178. (6, '8dfd8f8d7f87d8', 'Md Mustak', 'm.sc in cse', 'inigma', '84832sd8384d6d', '1', '', '01909909009', 'muskta@hotmail.com', 'dhaka', 'male', 'hmm.com', '2016-08-10 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
    179. 

  179. (7, 'd8fd8f8d6f6d', 'Monika', 'diploma in computer', 'div vill', '84832sd8384d6d', '3', '', '01909000999', 'monika@gmail.com', 'dhaka', 'female', 'hmm.com', '2016-08-11 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
    180. 

  180. 

  181. -- --------------------------------------------------------
    182. 

  182. 

  183. --
    184. 

  184. -- Table structure for table `users`
    185. 

  185. --
    186. 

  186. 

  187. CREATE TABLE IF NOT EXISTS `users` (
    188. 

  188.   `id` int(11) NOT NULL,
    189. 

  189.   `unique_id` varchar(111) NOT NULL,
    190. 

  190.   `full_name` varchar(111) NOT NULL,
    191. 

  191.   `username` varchar(50) NOT NULL,
    192. 

  192.   `email` varchar(111) NOT NULL,
    193. 

  193.   `password` varchar(20) NOT NULL,
    194. 

  194.   `image` varchar(255) NOT NULL,
    195. 

  195.   `is_active` int(10) NOT NULL,
    196. 

  196.   `is_admin` int(10) NOT NULL,
    197. 

  197.   `is_delete` int(10) NOT NULL,
    198. 

  198.   `created` datetime NOT NULL,
    199. 

  199.   `updated` datetime NOT NULL,
    200. 

  200.   `deleted` datetime NOT NULL
    201. 

  201. ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
    202. 

  202. 

  203. --
    204. 

  204. -- Dumping data for table `users`
    205. 

  205. --
    206. 

  206. 

  207. INSERT INTO `users` (`id`, `unique_id`, `full_name`, `username`, `email`, `password`, `image`, `is_active`, `is_admin`, `is_delete`, `created`, `updated`, `deleted`) VALUES
    208. 

  208. (1, '57a67863e76dc', 'Ariful Haque', 'arif', 'arif@hotmail.com', 'aaa', '', 1, 1, 0, '2016-08-08 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
    209. 

  209. 

  210. --
    211. 

  211. -- Indexes for dumped tables
    212. 

  212. --
    213. 

  213. 

  214. --
    215. 

  215. -- Indexes for table `courses`
    216. 

  216. --
    217. 

  217. ALTER TABLE `courses`
    218. 

  218.   ADD PRIMARY KEY (`id`);
    219. 

  219. 

  220. --
    221. 

  221. -- Indexes for table `course_trainer_lab_mapping`
    222. 

  222. --
    223. 

  223. ALTER TABLE `course_trainer_lab_mapping`
    224. 

  224.   ADD PRIMARY KEY (`id`);
    225. 

  225. 

  226. --
    227. 

  227. -- Indexes for table `installed_softwares`
    228. 

  228. --
    229. 

  229. ALTER TABLE `installed_softwares`
    230. 

  230.   ADD PRIMARY KEY (`id`);
    231. 

  231. 

  232. --
    233. 

  233. -- Indexes for table `labinfo`
    234. 

  234. --
    235. 

  235. ALTER TABLE `labinfo`
    236. 

  236.   ADD PRIMARY KEY (`id`);
    237. 

  237. 

  238. --
    239. 

  239. -- Indexes for table `trainers`
    240. 

  240. --
    241. 

  241. ALTER TABLE `trainers`
    242. 

  242.   ADD PRIMARY KEY (`id`);
    243. 

  243. 

  244. --
    245. 

  245. -- Indexes for table `users`
    246. 

  246. --
    247. 

  247. ALTER TABLE `users`
    248. 

  248.   ADD PRIMARY KEY (`id`);
    249. 

  249. 

  250. --
    251. 

  251. -- AUTO_INCREMENT for dumped tables
    252. 

  252. --
    253. 

  253. 

  254. --
    255. 

  255. -- AUTO_INCREMENT for table `courses`
    256. 

  256. --
    257. 

  257. ALTER TABLE `courses`
    258. 

  258.   MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=5;
    259. 

  259. --
    260. 

  260. -- AUTO_INCREMENT for table `course_trainer_lab_mapping`
    261. 

  261. --
    262. 

  262. ALTER TABLE `course_trainer_lab_mapping`
    263. 

  263.   MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=7;
    264. 

  264. --
    265. 

  265. -- AUTO_INCREMENT for table `installed_softwares`
    266. 

  266. --
    267. 

  267. ALTER TABLE `installed_softwares`
    268. 

  268.   MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
    269. 

  269. --
    270. 

  270. -- AUTO_INCREMENT for table `labinfo`
    271. 

  271. --
    272. 

  272. ALTER TABLE `labinfo`
    273. 

  273.   MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=22;
    274. 

  274. --
    275. 

  275. -- AUTO_INCREMENT for table `trainers`
    276. 

  276. --
    277. 

  277. ALTER TABLE `trainers`
    278. 

  278.   MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=8;
    279. 

  279. --
    280. 

  280. -- AUTO_INCREMENT for table `users`
    281. 

  281. --
    282. 

  282. ALTER TABLE `users`
    283. 

  283.   MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;
    284. 

  284. /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
    285. 

  285. /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
    286. 

  286. /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
    287. 

  287.