-- phpMyAdmin SQL Dump
-- version 4.8.5
-- https://www.phpmyadmin.net/
--
-- Host: mysql
-- Generation Time: Mar 19, 2019 at 06:22 AM
-- Server version: 5.7.25
-- PHP Version: 7.2.14

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
START TRANSACTION;
SET time_zone = "+00:00";

--
-- Dumping data for table `rsp_depart_committees`
--

INSERT INTO `rsp_depart_committees` (`id`, `personnel_id`, `department_id`, `role_id`) VALUES
(1, 783, 1, 1),
(2, 143, 1, 2),
(3, 297, 1, 2),
(4, 254, 1, 2),
(5, 10, 2, 1),
(6, 104, 2, 2),
(7, 748, 2, 2),
(8, 787, 2, 2),
(9, 197, 2, 2),
(10, 219, 2, 2),
(11, 437, 3, 1),
(12, 816, 3, 2),
(13, 28, 3, 2),
(14, 193, 3, 2),
(15, 3, 4, 1),
(16, 500, 4, 2),
(17, 685, 4, 2),
(18, 406, 4, 2),
(19, 39, 4, 2),
(20, 151, 5, 2),
(21, 680, 5, 2),
(22, 97, 5, 2),
(23, 369, 5, 2),
(24, 743, 5, 2),
(25, 405, 5, 2),
(26, 778, 5, 2),
(27, 810, 5, 2),
(28, 222, 5, 2),
(29, 346, 5, 2),
(30, 208, 5, 2),
(31, 487, 6, 1),
(32, 799, 6, 2),
(33, 515, 6, 2),
(34, 686, 6, 2),
(35, 447, 6, 2),
(36, 216, 7, 1),
(37, 126, 7, 2),
(38, 251, 7, 2),
(39, 457, 7, 2),
(40, 182, 8, 1),
(41, 274, 8, 2),
(42, 101, 8, 2),
(43, 804, 8, 2),
(44, 187, 9, 1),
(45, 767, 9, 2),
(46, 707, 9, 2),
(47, 38, 9, 2),
(48, 807, 9, 2),
(49, 139, 10, 2),
(50, 202, 11, 1),
(51, 733, 11, 2),
(52, 689, 11, 2),
(53, 86, 11, 2),
(54, 319, 11, 2),
(55, 755, 11, 2),
(56, 802, 11, 2),
(57, 763, 11, 2),
(58, 363, 11, 2),
(59, 682, 11, 2),
(60, 386, 11, 2),
(61, 384, 11, 2),
(62, 250, 11, 2),
(63, 196, 12, 1),
(64, 288, 12, 2),
(65, 451, 12, 2),
(66, 518, 12, 2),
(67, 521, 12, 2),
(68, 681, 12, 2),
(69, 59, 12, 2),
(70, 435, 12, 2),
(71, 798, 12, 2),
(72, 469, 13, 1),
(73, 118, 13, 2),
(74, 855, 13, 2),
(75, 150, 13, 2),
(76, 140, 13, 2),
(77, 119, 13, 2),
(78, 432, 13, 2),
(79, 800, 13, 2),
(80, 95, 13, 2),
(81, 100, 14, 2),
(82, 775, 14, 2),
(83, 646, 14, 2),
(84, 287, 14, 2),
(85, 696, 14, 2),
(86, 243, 14, 2),
(87, 433, 14, 2),
(88, 895, 14, 2),
(89, 19, 15, 2),
(90, 455, 15, 2),
(91, 129, 15, 2),
(92, 418, 15, 2),
(93, 721, 15, 2),
(94, 20, 15, 2),
(95, 296, 15, 2),
(96, 285, 16, 1),
(97, 110, 16, 2),
(98, 312, 16, 2),
(99, 149, 16, 2),
(100, 454, 16, 2),
(101, 362, 16, 2),
(102, 393, 17, 2),
(103, 496, 17, 2),
(104, 272, 18, 1),
(105, 734, 18, 2),
(106, 227, 19, 2),
(107, 217, 19, 2),
(108, 218, 19, 2),
(109, 462, 20, 1),
(110, 812, 20, 2),
(111, 540, 20, 2),
(112, 148, 20, 2),
(113, 486, 21, 1),
(114, 63, 21, 2),
(115, 167, 21, 2),
(116, 358, 21, 2),
(117, 465, 21, 2),
(118, 476, 22, 1),
(119, 398, 22, 2),
(120, 49, 22, 2),
(121, 357, 22, 2),
(122, 181, 22, 2),
(123, 43, 23, 2),
(124, 361, 23, 2),
(125, 482, 23, 2),
(126, 76, 23, 2),
(127, 419, 24, 2),
(128, 66, 24, 2),
(129, 745, 24, 2),
(130, 446, 24, 2),
(131, 294, 24, 2),
(132, 511, 24, 2),
(133, 527, 24, 2),
(134, 491, 24, 2),
(135, 492, 24, 2),
(136, 372, 24, 2),
(137, 751, 24, 2),
(138, 205, 24, 2),
(139, 399, 24, 2),
(140, 85, 26, 1),
(141, 589, 26, 2),
(142, 483, 27, 2),
(143, 355, 27, 2),
(144, 240, 27, 2),
(145, 709, 27, 2),
(146, 176, 27, 2),
(147, 147, 27, 2),
(148, 180, 27, 2),
(149, 286, 27, 2),
(150, 224, 28, 1),
(151, 347, 28, 2),
(152, 98, 28, 2),
(153, 295, 29, 1),
(154, 394, 31, 1),
(155, 383, 31, 2),
(156, 389, 31, 2),
(157, 401, 31, 2),
(158, 773, 31, 2),
(159, 814, 31, 2),
(160, 422, 31, 2),
(161, 311, 31, 2),
(162, 700, 39, 2),
(163, 771, 39, 2),
(164, 772, 39, 2),
(165, 171, 39, 2),
(166, 503, 39, 2),
(167, 131, 39, 2),
(168, 459, 42, 1),
(169, 75, 42, 2),
(170, 78, 42, 2),
(171, 289, 43, 1),
(172, 54, 43, 2),
(173, 727, 43, 2),
(174, 338, 44, 1),
(175, 388, 44, 2),
(176, 678, 44, 2),
(177, 253, 44, 2),
(178, 12, 48, 2),
(179, 420, 55, 2),
(180, 70, 55, 2),
(181, 713, 56, 1),
(182, 309, 56, 2),
(183, 839, 56, 2),
(184, 280, 56, 2),
(185, 507, 56, 2),
(186, 164, 56, 2),
(187, 759, 56, 2),
(188, 58, 56, 2),
(189, 11, 56, 2),
(190, 512, 58, 1),
(191, 528, 61, 2),
(192, 22, 77, 2),
(193, 522, 79, 1),
(194, 71, 98, 2),
(195, 493, 98, 2),
(196, 416, 98, 2),
(197, 316, 98, 2),
(198, 124, 98, 2),
(199, 81, 98, 2),
(200, 173, 98, 2),
(201, 21, 98, 2),
(202, 497, 98, 2),
(203, 204, 98, 2),
(204, 354, 98, 2),
(205, 337, 98, 2),
(206, 120, 98, 2),
(207, 244, 98, 2),
(208, 225, 98, 2),
(209, 190, 98, 2),
(210, 201, 98, 2),
(211, 526, 98, 2),
(212, 456, 98, 2),
(213, 168, 98, 2),
(214, 412, 98, 2),
(215, 27, 98, 2),
(216, 31, 98, 2),
(217, 417, 98, 2),
(218, 414, 98, 2),
(219, 183, 98, 2),
(220, 266, 98, 2),
(221, 378, 98, 2),
(222, 30, 98, 2),
(223, 192, 98, 2),
(224, 425, 98, 2),
(225, 458, 98, 2),
(226, 203, 98, 2),
(227, 50, 98, 2),
(228, 332, 98, 2),
(229, 36, 98, 2),
(230, 270, 98, 2),
(231, 29, 98, 2),
(232, 377, 98, 2),
(233, 279, 98, 2),
(234, 466, 98, 2),
(235, 677, 98, 2),
(236, 57, 98, 2),
(237, 51, 98, 2),
(238, 695, 98, 2),
(239, 371, 98, 2),
(240, 467, 98, 2),
(241, 470, 98, 2),
(242, 172, 98, 2),
(243, 89, 98, 2),
(244, 114, 98, 2),
(245, 335, 98, 2),
(246, 537, 98, 2),
(247, 191, 98, 2),
(248, 546, 98, 2);

--
-- Indexes for dumped tables
--

--
-- Indexes for table `rsp_depart_committees`
--
ALTER TABLE `rsp_depart_committees`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `rsp_depart_committees_personnel_id_department_id_unique` (`personnel_id`,`department_id`),
  ADD KEY `rsp_depart_committees_personnel_id_index` (`personnel_id`),
  ADD KEY `rsp_depart_committees_department_id_index` (`department_id`),
  ADD KEY `rsp_depart_committees_role_id_index` (`role_id`);

