-- phpMyAdmin SQL Dump
-- version 4.9.0.1
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Sep 02, 2019 at 08:12 AM
-- Server version: 10.4.6-MariaDB
-- PHP Version: 7.3.8

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


/*!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 utf8mb4 */;

--
-- Database: `hris`
--

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

--
-- Table structure for table `plantilla_personnels`
--

CREATE TABLE `plantilla_personnels` (
  `id` int(10) UNSIGNED NOT NULL,
  `personnel_id` int(10) UNSIGNED DEFAULT NULL,
  `plantilla_id` int(10) UNSIGNED DEFAULT NULL,
  `date_vacant` date DEFAULT NULL,
  `remarks_id` int(10) UNSIGNED DEFAULT NULL,
  `reason` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `active` smallint(6) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `plantilla_personnels`
--

INSERT INTO `plantilla_personnels` (`id`, `personnel_id`, `plantilla_id`, `date_vacant`, `remarks_id`, `reason`, `active`) VALUES
(1, 512, 1, NULL, NULL, NULL, 0),
(2, 508, 2, NULL, NULL, NULL, 0),
(3, 133, 3, NULL, NULL, NULL, 0),
(4, 718, 4, NULL, NULL, NULL, 0),
(5, 706, 5, NULL, NULL, NULL, 0),
(6, 195, 6, NULL, NULL, NULL, 0),
(7, 163, 7, NULL, NULL, NULL, 0),
(8, 509, 8, NULL, NULL, NULL, 0),
(9, 522, 9, NULL, NULL, NULL, 0),
(10, 256, 10, NULL, NULL, NULL, 0),
(11, 108, 11, NULL, NULL, NULL, 0),
(12, 423, 12, NULL, NULL, NULL, 0),
(13, 356, 13, NULL, NULL, NULL, 0),
(14, 189, 14, NULL, NULL, NULL, 0),
(15, 1058, 15, NULL, NULL, NULL, 0),
(16, 106, 16, NULL, NULL, NULL, 0),
(17, 509, 17, NULL, NULL, NULL, 0),
(18, 73, 18, NULL, NULL, NULL, 0),
(19, 214, 19, NULL, NULL, NULL, 0),
(20, 379, 20, NULL, NULL, NULL, 0),
(21, 163, 21, NULL, NULL, NULL, 0),
(22, 898, 22, NULL, NULL, NULL, 0),
(23, 712, 23, NULL, NULL, NULL, 0),
(24, 692, 24, NULL, NULL, NULL, 0),
(25, 44, 25, NULL, NULL, NULL, 0),
(26, 37, 26, NULL, NULL, NULL, 0),
(27, 156, 27, NULL, NULL, NULL, 0),
(28, 434, 28, NULL, NULL, NULL, 0),
(29, 299, 29, NULL, NULL, NULL, 0),
(30, NULL, 30, NULL, NULL, NULL, 0),
(31, NULL, 31, NULL, NULL, NULL, 0),
(32, 663, 32, NULL, NULL, NULL, 0),
(33, 233, 33, NULL, NULL, NULL, 0),
(34, 395, 34, NULL, NULL, NULL, 0),
(35, 345, 35, NULL, NULL, NULL, 0),
(36, 813, 36, NULL, NULL, NULL, 0),
(37, 710, 37, NULL, NULL, NULL, 0),
(38, NULL, 38, NULL, NULL, NULL, 0),
(39, 514, 39, NULL, NULL, NULL, 0),
(40, 1067, 40, NULL, NULL, NULL, 0),
(41, 107, 41, NULL, NULL, NULL, 0),
(42, NULL, 42, NULL, NULL, NULL, 0),
(43, NULL, 43, NULL, NULL, NULL, 0),
(44, 365, 44, NULL, NULL, NULL, 0),
(45, 947, 45, NULL, NULL, NULL, 0),
(46, 581, 46, NULL, NULL, NULL, 0),
(47, NULL, 47, NULL, NULL, NULL, 0),
(48, 1037, 48, NULL, NULL, NULL, 0),
(49, 267, 49, NULL, NULL, NULL, 0),
(50, 585, 50, NULL, NULL, NULL, 0),
(51, 436, 51, NULL, NULL, NULL, 0),
(52, 502, 52, NULL, NULL, NULL, 0),
(53, NULL, 53, NULL, NULL, NULL, 0),
(54, 568, 54, NULL, NULL, NULL, 0),
(55, 593, 55, NULL, NULL, NULL, 0),
(56, 1015, 56, NULL, NULL, NULL, 0),
(57, 671, 57, NULL, NULL, NULL, 0),
(58, 644, 58, NULL, NULL, NULL, 0),
(59, 248, 59, NULL, NULL, NULL, 0),
(60, 658, 60, NULL, NULL, NULL, 0),
(61, 221, 61, NULL, NULL, NULL, 0),
(62, 135, 62, NULL, NULL, NULL, 0),
(63, 42, 63, NULL, NULL, NULL, 0),
(64, 542, 64, NULL, NULL, NULL, 0),
(65, 52, 65, NULL, NULL, NULL, 0),
(66, 914, 66, NULL, NULL, NULL, 0),
(67, 220, 67, NULL, NULL, NULL, 0),
(68, 620, 68, NULL, NULL, NULL, 0),
(69, 155, 69, NULL, NULL, NULL, 0),
(70, 277, 70, NULL, NULL, NULL, 0),
(71, 186, 71, NULL, NULL, NULL, 0),
(72, 198, 72, NULL, NULL, NULL, 0),
(73, 1017, 73, NULL, NULL, NULL, 0),
(74, 808, 74, NULL, NULL, NULL, 0),
(75, 1021, 75, NULL, NULL, NULL, 0),
(76, 566, 76, NULL, NULL, NULL, 0),
(77, 334, 77, NULL, NULL, NULL, 0),
(78, 489, 78, NULL, NULL, NULL, 0),
(79, 262, 79, NULL, NULL, NULL, 0),
(80, 477, 80, NULL, NULL, NULL, 0),
(81, 353, 81, NULL, NULL, NULL, 0),
(82, 539, 82, NULL, NULL, NULL, 0),
(83, 47, 83, NULL, NULL, NULL, 0),
(84, 310, 84, NULL, NULL, NULL, 0),
(85, 534, 85, NULL, NULL, NULL, 0),
(86, 177, 86, NULL, NULL, NULL, 0),
(87, 4, 87, NULL, NULL, NULL, 0),
(88, 373, 88, NULL, NULL, NULL, 0),
(89, 375, 89, NULL, NULL, NULL, 0),
(90, 238, 90, NULL, NULL, NULL, 0),
(91, 207, 91, NULL, NULL, NULL, 0),
(92, 48, 92, NULL, NULL, NULL, 0),
(93, NULL, 93, NULL, NULL, NULL, 0),
(94, NULL, 94, NULL, NULL, NULL, 0),
(95, NULL, 95, NULL, NULL, NULL, 0),
(96, 666, 96, NULL, NULL, NULL, 0),
(97, NULL, 97, NULL, NULL, NULL, 0),
(98, 329, 98, NULL, NULL, NULL, 0),
(99, 780, 99, NULL, NULL, NULL, 0),
(100, 313, 100, NULL, NULL, NULL, 0),
(101, 554, 101, NULL, NULL, NULL, 0),
(102, NULL, 102, NULL, NULL, NULL, 0),
(103, NULL, 103, NULL, NULL, NULL, 0),
(104, 258, 104, NULL, NULL, NULL, 0),
(105, 863, 105, NULL, NULL, NULL, 0),
(106, 96, 106, NULL, NULL, NULL, 0),
(107, 200, 107, NULL, NULL, NULL, 0),
(108, 239, 108, NULL, NULL, NULL, 0),
(109, 407, 109, NULL, NULL, NULL, 0),
(110, 232, 110, NULL, NULL, NULL, 0),
(111, 194, 111, NULL, NULL, NULL, 0),
(112, 330, 112, NULL, NULL, NULL, 0),
(113, 74, 113, NULL, NULL, NULL, 0),
(114, 331, 114, NULL, NULL, NULL, 0),
(115, 601, 115, NULL, NULL, NULL, 0),
(116, 498, 116, NULL, NULL, NULL, 0),
(117, 899, 117, NULL, NULL, NULL, 0),
(118, 26, 118, NULL, NULL, NULL, 0),
(119, 501, 119, NULL, NULL, NULL, 0),
(120, 90, 120, NULL, NULL, NULL, 0),
(121, 552, 121, NULL, NULL, NULL, 0),
(122, 608, 122, NULL, NULL, NULL, 0),
(123, 333, 123, NULL, NULL, NULL, 0),
(124, NULL, 124, NULL, NULL, NULL, 0),
(125, 387, 125, NULL, NULL, NULL, 0),
(126, NULL, 126, NULL, NULL, NULL, 0),
(127, 448, 127, NULL, NULL, NULL, 0),
(128, 427, 128, NULL, NULL, NULL, 0),
(129, 428, 129, NULL, NULL, NULL, 0),
(130, 1072, 130, NULL, NULL, NULL, 0),
(131, 80, 131, NULL, NULL, NULL, 0),
(132, 615, 132, NULL, NULL, NULL, 0),
(133, 859, 133, NULL, NULL, NULL, 0),
(134, 64, 134, NULL, NULL, NULL, 0),
(135, 585, 135, NULL, NULL, NULL, 0),
(136, NULL, 136, NULL, NULL, NULL, 0),
(137, 725, 137, NULL, NULL, NULL, 0),
(138, NULL, 138, NULL, NULL, NULL, 0),
(139, 137, 139, NULL, NULL, NULL, 0),
(140, 726, 140, NULL, NULL, NULL, 0),
(141, NULL, 141, NULL, NULL, NULL, 0),
(142, 1046, 142, NULL, NULL, NULL, 0),
(143, 784, 143, NULL, NULL, NULL, 0),
(144, 559, 144, NULL, NULL, NULL, 0),
(145, NULL, 145, NULL, NULL, NULL, 0),
(146, 162, 146, NULL, NULL, NULL, 0),
(147, 242, 147, NULL, NULL, NULL, 0),
(148, 257, 148, NULL, NULL, NULL, 0),
(149, 942, 149, NULL, NULL, NULL, 0),
(150, 982, 150, NULL, NULL, NULL, 0),
(151, NULL, 151, NULL, NULL, NULL, 0),
(152, 35, 152, NULL, NULL, NULL, 0),
(153, 627, 153, NULL, NULL, NULL, 0),
(154, 784, 154, NULL, NULL, NULL, 0),
(155, 88, 155, NULL, NULL, NULL, 0),
(156, 579, 156, NULL, NULL, NULL, 0),
(157, 348, 157, NULL, NULL, NULL, 0),
(158, 112, 158, NULL, NULL, NULL, 0),
(159, 520, 159, NULL, NULL, NULL, 0),
(160, 5, 160, NULL, NULL, NULL, 0),
(161, 121, 161, NULL, NULL, NULL, 0),
(162, 396, 162, NULL, NULL, NULL, 0),
(163, 631, 163, NULL, NULL, NULL, 0),
(164, NULL, 164, NULL, NULL, NULL, 0),
(165, NULL, 165, NULL, NULL, NULL, 0),
(166, 56, 166, NULL, NULL, NULL, 0),
(167, NULL, 167, NULL, NULL, NULL, 0),
(168, 854, 168, NULL, NULL, NULL, 0),
(169, 618, 169, NULL, NULL, NULL, 0),
(170, 697, 170, NULL, NULL, NULL, 0),
(171, 282, 171, NULL, NULL, NULL, 0),
(172, 984, 172, NULL, NULL, NULL, 0),
(173, 777, 173, NULL, NULL, NULL, 0),
(174, 794, 174, NULL, NULL, NULL, 0),
(175, 951, 175, NULL, NULL, NULL, 0),
(176, 820, 176, NULL, NULL, NULL, 0),
(177, 779, 177, NULL, NULL, NULL, 0),
(178, 569, 178, NULL, NULL, NULL, 0),
(179, 1049, 179, NULL, NULL, NULL, 0),
(180, 1029, 180, NULL, NULL, NULL, 0),
(181, 1036, 181, NULL, NULL, NULL, 0),
(182, NULL, 182, NULL, NULL, NULL, 0),
(183, 902, 183, NULL, NULL, NULL, 0),
(184, NULL, 184, NULL, NULL, NULL, 0),
(185, 1062, 185, NULL, NULL, NULL, 0),
(186, 903, 186, NULL, NULL, NULL, 0),
(187, 991, 187, NULL, NULL, NULL, 0),
(188, 896, 188, NULL, NULL, NULL, 0),
(189, 452, 189, NULL, NULL, NULL, 0),
(190, NULL, 190, NULL, NULL, NULL, 0),
(191, 628, 191, NULL, NULL, NULL, 0),
(192, 494, 192, NULL, NULL, NULL, 0),
(193, 821, 193, NULL, NULL, NULL, 0),
(194, NULL, 194, NULL, NULL, NULL, 0),
(195, 564, 195, NULL, NULL, NULL, 0),
(196, 573, 196, NULL, NULL, NULL, 0),
(197, 410, 197, NULL, NULL, NULL, 0),
(198, NULL, 198, NULL, NULL, NULL, 0),
(199, NULL, 199, NULL, NULL, NULL, 0),
(200, 385, 200, NULL, NULL, NULL, 0),
(201, 632, 201, NULL, NULL, NULL, 0),
(202, 555, 202, NULL, NULL, NULL, 0),
(203, 990, 203, NULL, NULL, NULL, 0),
(204, NULL, 204, NULL, NULL, NULL, 0),
(205, 634, 205, NULL, NULL, NULL, 0),
(206, 850, 206, NULL, NULL, NULL, 0),
(207, 551, 207, NULL, NULL, NULL, 0),
(208, 390, 208, NULL, NULL, NULL, 0),
(209, 623, 209, NULL, NULL, NULL, 0),
(210, 619, 210, NULL, NULL, NULL, 0),
(211, 562, 211, NULL, NULL, NULL, 0),
(212, 611, 212, NULL, NULL, NULL, 0),
(213, 1045, 213, NULL, NULL, NULL, 0),
(214, 567, 214, NULL, NULL, NULL, 0),
(215, NULL, 215, NULL, NULL, NULL, 0),
(216, NULL, 216, NULL, NULL, NULL, 0),
(217, NULL, 217, NULL, NULL, NULL, 0),
(218, 708, 218, NULL, NULL, NULL, 0),
(219, 578, 219, NULL, NULL, NULL, 0),
(220, NULL, 220, NULL, NULL, NULL, 0),
(221, 464, 221, NULL, NULL, NULL, 0),
(222, 612, 222, NULL, NULL, NULL, 0),
(223, 630, 223, NULL, NULL, NULL, 0),
(224, 846, 224, NULL, NULL, NULL, 0),
(225, 511, 225, '2019-08-31', NULL, NULL, 1),
(226, 354, 226, NULL, NULL, NULL, 0),
(227, 459, 227, NULL, NULL, NULL, 0),
(228, 222, 228, NULL, NULL, NULL, 0),
(229, 302, 229, NULL, NULL, NULL, 0),
(230, 519, 230, NULL, NULL, NULL, 0),
(231, 66, 231, NULL, NULL, NULL, 0),
(232, NULL, 232, NULL, NULL, NULL, 0),
(233, 491, 233, NULL, NULL, NULL, 0),
(234, 54, 234, NULL, NULL, NULL, 0),
(235, 476, 235, NULL, NULL, NULL, 0),
(236, 104, 236, NULL, NULL, NULL, 0),
(237, 383, 237, NULL, NULL, NULL, 0),
(238, 30, 238, NULL, NULL, NULL, 0),
(239, 311, 239, NULL, NULL, NULL, 0),
(240, NULL, 240, NULL, NULL, NULL, 0),
(241, 110, 241, NULL, NULL, NULL, 0),
(242, 217, 242, NULL, NULL, NULL, 0),
(243, NULL, 243, NULL, NULL, NULL, 0),
(244, 251, 244, NULL, NULL, NULL, 0),
(245, 422, 245, NULL, NULL, NULL, 0),
(246, 383, 246, NULL, NULL, NULL, 0),
(247, 104, 247, NULL, NULL, NULL, 0),
(248, 139, 248, NULL, NULL, NULL, 0),
(249, 537, 249, NULL, NULL, NULL, 0),
(250, 243, 250, NULL, NULL, NULL, 0),
(251, 192, 251, NULL, NULL, NULL, 0),
(252, 783, 252, NULL, NULL, NULL, 0),
(253, 193, 253, NULL, NULL, NULL, 0),
(254, 496, 254, NULL, NULL, NULL, 0),
(255, 285, 255, NULL, NULL, NULL, 0),
(256, 487, 256, NULL, NULL, NULL, 0),
(257, 270, 257, NULL, NULL, NULL, 0),
(258, 253, 258, NULL, NULL, NULL, 0),
(259, 205, 259, NULL, NULL, NULL, 0),
(260, 167, 260, NULL, NULL, NULL, 0),
(261, 388, 261, NULL, NULL, NULL, 0),
(262, 97, 262, NULL, NULL, NULL, 0),
(263, 389, 263, NULL, NULL, NULL, 0),
(264, 204, 264, NULL, NULL, NULL, 0),
(265, 346, 265, NULL, NULL, NULL, 0),
(266, NULL, 266, NULL, NULL, NULL, 0),
(267, 129, 267, NULL, NULL, NULL, 0),
(268, 38, 268, NULL, NULL, NULL, 0),
(269, 349, 269, NULL, NULL, NULL, 0),
(270, 49, 270, NULL, NULL, NULL, 0),
(271, 20, 271, NULL, NULL, NULL, 0),
(272, 455, 272, NULL, NULL, NULL, 0),
(273, 294, 273, NULL, NULL, NULL, 0),
(274, 119, 274, NULL, NULL, NULL, 0),
(275, 3, 275, NULL, NULL, NULL, 0),
(276, 71, 276, NULL, NULL, NULL, 0),
(277, 453, 277, NULL, NULL, NULL, 0),
(278, NULL, 278, NULL, NULL, NULL, 0),
(279, NULL, 279, NULL, NULL, NULL, 0),
(280, 297, 280, NULL, NULL, NULL, 0),
(281, 19, 281, NULL, NULL, NULL, 0),
(282, 266, 282, NULL, NULL, NULL, 0),
(283, 101, 283, NULL, NULL, NULL, 0),
(284, 818, 284, NULL, NULL, NULL, 0),
(285, 151, 285, NULL, NULL, NULL, 0),
(286, 319, 286, NULL, NULL, NULL, 0),
(287, 164, 287, NULL, NULL, NULL, 0),
(288, 437, 288, NULL, NULL, NULL, 0),
(289, 456, 289, NULL, NULL, NULL, 0),
(290, 295, 290, NULL, NULL, NULL, 0),
(291, 296, 291, NULL, NULL, NULL, 0),
(292, 45, 292, NULL, NULL, NULL, 0),
(293, 157, 293, NULL, NULL, NULL, 0),
(294, 230, 294, NULL, NULL, NULL, 0),
(295, 433, 295, NULL, NULL, NULL, 0),
(296, NULL, 296, NULL, NULL, NULL, 0),
(297, 223, 297, NULL, NULL, NULL, 0),
(298, 430, 298, NULL, NULL, NULL, 0),
(299, 323, 299, NULL, NULL, NULL, 0),
(300, 127, 300, NULL, NULL, NULL, 0),
(301, 486, 301, NULL, NULL, NULL, 0),
(302, 76, 302, NULL, NULL, NULL, 0),
(303, 196, 303, NULL, NULL, NULL, 0),
(304, 312, 304, NULL, NULL, NULL, 0),
(305, 417, 305, NULL, NULL, NULL, 0),
(306, 369, 306, NULL, NULL, NULL, 0),
(307, 289, 307, NULL, NULL, NULL, 0),
(308, 197, 308, NULL, NULL, NULL, 0),
(309, 405, 309, NULL, NULL, NULL, 0),
(310, 401, 310, NULL, NULL, NULL, 0),
(311, 118, 311, NULL, NULL, NULL, 0),
(312, 10, 312, NULL, NULL, NULL, 0),
(313, 143, 313, NULL, NULL, NULL, 0),
(314, 182, 314, NULL, NULL, NULL, 0),
(315, 435, 315, NULL, NULL, NULL, 0),
(316, 394, 316, NULL, NULL, NULL, 0),
(317, 338, 317, NULL, NULL, NULL, 0),
(318, 100, 318, NULL, NULL, NULL, 0),
(319, 85, 319, NULL, NULL, NULL, 0),
(320, 11, 320, NULL, NULL, NULL, 0),
(321, 39, 321, NULL, NULL, NULL, 0),
(322, 280, 322, NULL, NULL, NULL, 0),
(323, NULL, 323, NULL, NULL, NULL, 0),
(324, 895, 324, NULL, NULL, NULL, 0),
(325, 528, 325, NULL, NULL, NULL, 0),
(326, 454, 326, NULL, NULL, NULL, 0),
(327, 140, 327, NULL, NULL, NULL, 0),
(328, 250, 328, NULL, NULL, NULL, 0),
(329, NULL, 329, NULL, NULL, NULL, 0),
(330, NULL, 330, NULL, NULL, NULL, 0),
(331, 28, 331, NULL, NULL, NULL, 0),
(332, NULL, 332, NULL, NULL, NULL, 0),
(333, 406, 333, NULL, NULL, NULL, 0),
(334, 362, 334, NULL, NULL, NULL, 0),
(335, 447, 335, NULL, NULL, NULL, 0),
(336, 589, 336, NULL, NULL, NULL, 0),
(337, 187, 337, NULL, NULL, NULL, 0),
(338, 420, 338, NULL, NULL, NULL, 0),
(339, 503, 339, NULL, NULL, NULL, 0),
(340, 219, 340, NULL, NULL, NULL, 0),
(341, 451, 341, NULL, NULL, NULL, 0),
(342, 98, 342, NULL, NULL, NULL, 0),
(343, 646, 343, NULL, NULL, NULL, 0),
(344, NULL, 344, NULL, NULL, NULL, 0),
(345, 95, 345, NULL, NULL, NULL, 0),
(346, 778, 346, NULL, NULL, NULL, 0),
(347, 721, 347, NULL, NULL, NULL, 0),
(348, 773, 348, NULL, NULL, NULL, 0),
(349, 208, 349, NULL, NULL, NULL, 0),
(350, NULL, 350, NULL, NULL, NULL, 0),
(351, 398, 351, NULL, NULL, NULL, 0),
(352, 418, 352, NULL, NULL, NULL, 0),
(353, 814, 353, NULL, NULL, NULL, 0),
(354, 645, 354, NULL, NULL, NULL, 0),
(355, 171, 355, NULL, NULL, NULL, 0),
(356, 386, 356, NULL, NULL, NULL, 0),
(357, 202, 357, NULL, NULL, NULL, 0),
(358, 43, 358, NULL, NULL, NULL, 0),
(359, 510, 359, NULL, NULL, NULL, 0),
(360, 355, 360, NULL, NULL, NULL, 0),
(361, 767, 361, NULL, NULL, NULL, 0),
(362, 274, 362, NULL, NULL, NULL, 0),
(363, NULL, 363, NULL, NULL, NULL, 0),
(364, 59, 364, NULL, NULL, NULL, 0),
(365, 147, 365, NULL, NULL, NULL, 0),
(366, 288, 366, NULL, NULL, NULL, 0),
(367, 86, 367, NULL, NULL, NULL, 0),
(368, 743, 368, NULL, NULL, NULL, 0),
(369, 500, 369, NULL, NULL, NULL, 0),
(370, 515, 370, NULL, NULL, NULL, 0),
(371, 798, 371, NULL, NULL, NULL, 0),
(372, 696, 372, NULL, NULL, NULL, 0),
(373, 441, 373, NULL, NULL, NULL, 0),
(374, 58, 374, NULL, NULL, NULL, 0),
(375, 772, 375, NULL, NULL, NULL, 0),
(376, 507, 376, NULL, NULL, NULL, 0),
(377, NULL, 377, NULL, NULL, NULL, 0),
(378, NULL, 378, NULL, NULL, NULL, 0),
(379, 751, 379, NULL, NULL, NULL, 0),
(380, 472, 380, NULL, NULL, NULL, 0),
(381, 662, 381, NULL, NULL, NULL, 0),
(382, 306, 382, NULL, NULL, NULL, 0),
(383, 72, 383, NULL, NULL, NULL, 0),
(384, 759, 384, NULL, NULL, NULL, 0),
(385, NULL, 385, NULL, NULL, NULL, 0),
(386, 745, 386, NULL, NULL, NULL, 0),
(387, 518, 387, NULL, NULL, NULL, 0),
(388, 521, 388, NULL, NULL, NULL, 0),
(389, 1052, 389, NULL, NULL, NULL, 0),
(390, NULL, 390, NULL, NULL, NULL, 0),
(391, 228, 391, NULL, NULL, NULL, 0),
(392, NULL, 392, NULL, NULL, NULL, 0),
(393, NULL, 393, NULL, NULL, NULL, 0),
(394, 286, 394, NULL, NULL, NULL, 0),
(395, NULL, 395, NULL, NULL, NULL, 0),
(396, 682, 396, NULL, NULL, NULL, 0),
(397, 700, 397, NULL, NULL, NULL, 0),
(398, 686, 398, NULL, NULL, NULL, 0),
(399, NULL, 399, NULL, NULL, NULL, 0),
(400, 799, 400, NULL, NULL, NULL, 0),
(401, NULL, 401, NULL, NULL, NULL, 0),
(402, 775, 402, NULL, NULL, NULL, 0),
(403, 713, 403, NULL, NULL, NULL, 0),
(404, 763, 404, NULL, NULL, NULL, 0),
(405, NULL, 405, NULL, NULL, NULL, 0),
(406, 787, 406, NULL, NULL, NULL, 0),
(407, 674, 407, NULL, NULL, NULL, 0),
(408, 685, 408, NULL, NULL, NULL, 0),
(409, 734, 409, NULL, NULL, NULL, 0),
(410, NULL, 410, NULL, NULL, NULL, 0),
(411, 707, 411, NULL, NULL, NULL, 0),
(412, 148, 412, NULL, NULL, NULL, 0),
(413, 363, 413, NULL, NULL, NULL, 0),
(414, 748, 414, NULL, NULL, NULL, 0),
(415, NULL, 415, NULL, NULL, NULL, 0),
(416, 800, 416, NULL, NULL, NULL, 0),
(417, 1032, 417, NULL, NULL, NULL, 0),
(418, 131, 418, NULL, NULL, NULL, 0),
(419, 678, 419, NULL, NULL, NULL, 0),
(420, NULL, 420, NULL, NULL, NULL, 0),
(421, 1034, 421, NULL, NULL, NULL, 0),
(422, 733, 422, NULL, NULL, NULL, 0),
(423, 368, 423, NULL, NULL, NULL, 0),
(424, 1071, 424, NULL, NULL, NULL, 0),
(425, 1025, 425, NULL, NULL, NULL, 0),
(426, NULL, 426, NULL, NULL, NULL, 0),
(427, 1060, 427, NULL, NULL, NULL, 0),
(428, 884, 428, NULL, NULL, NULL, 0),
(429, 1055, 429, NULL, NULL, NULL, 0),
(430, 885, 430, NULL, NULL, NULL, 0),
(431, 1042, 431, NULL, NULL, NULL, 0),
(432, 1027, 432, NULL, NULL, NULL, 0),
(433, 894, 433, NULL, NULL, NULL, 0),
(434, NULL, 434, NULL, NULL, NULL, 0),
(435, NULL, 435, NULL, NULL, NULL, 0),
(436, 1065, 436, NULL, NULL, NULL, 0),
(437, 909, 437, NULL, NULL, NULL, 0),
(438, 199, 438, NULL, NULL, NULL, 0),
(439, 1038, 439, NULL, NULL, NULL, 0),
(440, 714, 440, NULL, NULL, NULL, 0),
(441, 841, 441, NULL, NULL, NULL, 0),
(442, 836, 442, NULL, NULL, NULL, 0),
(443, 966, 443, NULL, NULL, NULL, 0),
(444, 969, 444, NULL, NULL, NULL, 0),
(445, 1011, 445, NULL, NULL, NULL, 0),
(446, 224, 446, NULL, NULL, NULL, 0),
(447, NULL, 447, NULL, NULL, NULL, 0),
(448, 911, 448, NULL, NULL, NULL, 0),
(449, 768, 449, NULL, NULL, NULL, 0),
(450, 728, 450, NULL, NULL, NULL, 0),
(451, 717, 451, NULL, NULL, NULL, 0),
(452, 1009, 452, NULL, NULL, NULL, 0),
(453, 917, 453, NULL, NULL, NULL, 0),
(454, NULL, 454, NULL, NULL, NULL, 0),
(455, 715, 455, NULL, NULL, NULL, 0),
(456, 1054, 456, NULL, NULL, NULL, 0),
(457, 1006, 457, NULL, NULL, NULL, 0),
(458, 755, 458, NULL, NULL, NULL, 0),
(459, 716, 459, NULL, NULL, NULL, 0),
(460, 983, 460, NULL, NULL, NULL, 0),
(461, 922, 461, NULL, NULL, NULL, 0),
(462, 753, 462, NULL, NULL, NULL, 0),
(463, 837, 463, NULL, NULL, NULL, 0),
(464, NULL, 464, NULL, NULL, NULL, 0),
(465, NULL, 465, NULL, NULL, NULL, 0),
(466, 994, 466, NULL, NULL, NULL, 0),
(467, NULL, 467, NULL, NULL, NULL, 0),
(468, NULL, 468, NULL, NULL, NULL, 0),
(469, 60, 469, NULL, NULL, NULL, 0),
(470, 766, 470, NULL, NULL, NULL, 0),
(471, NULL, 471, NULL, NULL, NULL, 0),
(472, 762, 472, NULL, NULL, NULL, 0),
(473, NULL, 473, NULL, NULL, NULL, 0),
(474, NULL, 474, NULL, NULL, NULL, 0),
(475, 961, 475, NULL, NULL, NULL, 0),
(476, 1075, 476, NULL, NULL, NULL, 0),
(477, 855, 477, NULL, NULL, NULL, 0),
(478, NULL, 478, NULL, NULL, NULL, 0),
(479, NULL, 479, NULL, NULL, NULL, 0),
(480, 842, 480, NULL, NULL, NULL, 0),
(481, NULL, 481, NULL, NULL, NULL, 0),
(482, 812, 482, NULL, NULL, NULL, 0),
(483, NULL, 483, NULL, NULL, NULL, 0),
(484, 1010, 484, NULL, NULL, NULL, 0),
(485, NULL, 485, NULL, NULL, NULL, 0),
(486, NULL, 486, NULL, NULL, NULL, 0),
(487, NULL, 487, NULL, NULL, NULL, 0),
(488, NULL, 488, NULL, NULL, NULL, 0),
(489, 824, 489, NULL, NULL, NULL, 0),
(490, 937, 490, NULL, NULL, NULL, 0),
(491, NULL, 491, NULL, NULL, NULL, 0),
(492, 806, 492, NULL, NULL, NULL, 0),
(493, 823, 493, NULL, NULL, NULL, 0),
(494, 929, 494, NULL, NULL, NULL, 0),
(495, NULL, 495, NULL, NULL, NULL, 0),
(496, 996, 496, NULL, NULL, NULL, 0),
(497, 1053, 497, NULL, NULL, NULL, 0),
(498, NULL, 498, NULL, NULL, NULL, 0),
(499, NULL, 499, NULL, NULL, NULL, 0),
(500, 828, 500, NULL, NULL, NULL, 0),
(501, 835, 501, NULL, NULL, NULL, 0),
(502, 1001, 502, NULL, NULL, NULL, 0),
(503, 758, 503, NULL, NULL, NULL, 0),
(504, NULL, 504, NULL, NULL, NULL, 0),
(505, 649, 505, NULL, NULL, NULL, 0),
(506, 843, 506, NULL, NULL, NULL, 0),
(507, 1059, 507, NULL, NULL, NULL, 0),
(508, 791, 508, NULL, NULL, NULL, 0),
(509, 830, 509, NULL, NULL, NULL, 0),
(510, 676, 510, NULL, NULL, NULL, 0),
(511, 1051, 511, NULL, NULL, NULL, 0),
(512, 988, 512, NULL, NULL, NULL, 0),
(513, 789, 513, NULL, NULL, NULL, 0),
(514, 839, 514, NULL, NULL, NULL, 0),
(515, NULL, 515, NULL, NULL, NULL, 0),
(516, 1008, 516, NULL, NULL, NULL, 0),
(517, NULL, 517, NULL, NULL, NULL, 0),
(518, 797, 518, NULL, NULL, NULL, 0),
(519, 840, 519, NULL, NULL, NULL, 0),
(520, 867, 520, NULL, NULL, NULL, 0),
(521, 1003, 521, NULL, NULL, NULL, 0),
(522, 462, 522, NULL, NULL, NULL, 0),
(523, NULL, 523, NULL, NULL, NULL, 0),
(524, 887, 524, NULL, NULL, NULL, 0),
(525, 976, 525, NULL, NULL, NULL, 0),
(526, 811, 526, NULL, NULL, NULL, 0),
(527, 869, 527, NULL, NULL, NULL, 0),
(528, 960, 528, NULL, NULL, NULL, 0),
(529, 684, 529, NULL, NULL, NULL, 0),
(530, 868, 530, NULL, NULL, NULL, 0),
(531, 1000, 531, NULL, NULL, NULL, 0),
(532, 760, 532, NULL, NULL, NULL, 0),
(533, 810, 533, NULL, NULL, NULL, 0),
(534, NULL, 534, NULL, NULL, NULL, 0),
(535, 1064, 535, NULL, NULL, NULL, 0),
(536, 188, 536, NULL, NULL, NULL, 0),
(537, 473, 537, NULL, NULL, NULL, 0),
(538, 804, 538, NULL, NULL, NULL, 0),
(539, 870, 539, NULL, NULL, NULL, 0),
(540, 1016, 540, NULL, NULL, NULL, 0),
(541, 744, 541, NULL, NULL, NULL, 0),
(542, 809, 542, NULL, NULL, NULL, 0),
(543, 877, 543, NULL, NULL, NULL, 0),
(544, 920, 544, NULL, NULL, NULL, 0),
(545, 807, 545, NULL, NULL, NULL, 0),
(546, 400, 546, NULL, NULL, NULL, 0),
(547, 918, 547, NULL, NULL, NULL, 0),
(548, 690, 548, NULL, NULL, NULL, 0),
(549, 805, 549, NULL, NULL, NULL, 0),
(550, 874, 550, NULL, NULL, NULL, 0),
(551, 913, 551, NULL, NULL, NULL, 0),
(552, 875, 552, NULL, NULL, NULL, 0),
(553, 1024, 553, NULL, NULL, NULL, 0),
(554, 1066, 554, NULL, NULL, NULL, 0),
(555, 876, 555, NULL, NULL, NULL, 0),
(556, 1056, 556, NULL, NULL, NULL, 0),
(557, 709, 557, NULL, NULL, NULL, 0),
(558, 872, 558, NULL, NULL, NULL, 0),
(559, 977, 559, NULL, NULL, NULL, 0),
(560, 871, 560, NULL, NULL, NULL, 0),
(561, 949, 561, NULL, NULL, NULL, 0),
(562, NULL, 562, NULL, NULL, NULL, 0),
(563, 963, 563, NULL, NULL, NULL, 0),
(564, 384, 564, NULL, NULL, NULL, 0),
(565, 882, 565, NULL, NULL, NULL, 0),
(566, 948, 566, NULL, NULL, NULL, 0),
(567, 891, 567, NULL, NULL, NULL, 0),
(568, 950, 568, NULL, NULL, NULL, 0),
(569, 880, 569, NULL, NULL, NULL, 0),
(570, NULL, 570, NULL, NULL, NULL, 0),
(571, 881, 571, NULL, NULL, NULL, 0),
(572, 956, 572, NULL, NULL, NULL, 0),
(573, 8, 573, NULL, NULL, NULL, 0),
(574, NULL, 574, NULL, NULL, NULL, 0),
(575, NULL, 575, NULL, NULL, NULL, 0),
(576, 62, 576, NULL, NULL, NULL, 0),
(577, 893, 577, NULL, NULL, NULL, 0),
(578, 998, 578, NULL, NULL, NULL, 0),
(579, 694, 579, NULL, NULL, NULL, 0),
(580, 681, 580, NULL, NULL, NULL, 0),
(581, 892, 581, NULL, NULL, NULL, 0),
(582, 1041, 582, NULL, NULL, NULL, 0),
(583, 703, 583, NULL, NULL, NULL, 0),
(584, 908, 584, NULL, NULL, NULL, 0),
(585, 1044, 585, NULL, NULL, NULL, 0),
(586, 900, 586, NULL, NULL, NULL, 0),
(587, NULL, 587, NULL, NULL, NULL, 0),
(588, NULL, 588, NULL, NULL, NULL, 0),
(589, 905, 589, NULL, NULL, NULL, 0),
(590, NULL, 590, NULL, NULL, NULL, 0),
(591, 240, 591, NULL, NULL, NULL, 0),
(592, 907, 592, NULL, NULL, NULL, 0),
(593, 979, 593, NULL, NULL, NULL, 0),
(594, 993, 594, NULL, NULL, NULL, 0),
(595, NULL, 595, NULL, NULL, NULL, 0),
(596, 992, 596, NULL, NULL, NULL, 0),
(597, 723, 597, NULL, NULL, NULL, 0),
(598, 997, 598, NULL, NULL, NULL, 0),
(599, 739, 599, NULL, NULL, NULL, 0),
(600, 980, 600, NULL, NULL, NULL, 0),
(601, 1020, 601, NULL, NULL, NULL, 0),
(602, 1014, 602, NULL, NULL, NULL, 0),
(603, 1022, 603, NULL, NULL, NULL, 0),
(604, NULL, 604, NULL, NULL, NULL, 0),
(605, 838, 605, NULL, NULL, NULL, 0),
(606, NULL, 606, NULL, NULL, NULL, 0),
(607, NULL, 607, NULL, NULL, NULL, 0),
(608, 1004, 608, NULL, NULL, NULL, 0),
(609, 1012, 609, NULL, NULL, NULL, 0),
(610, 1078, 610, NULL, NULL, NULL, 0),
(611, 1048, 611, NULL, NULL, NULL, 0),
(612, 986, 612, NULL, NULL, NULL, 0),
(613, 975, 613, NULL, NULL, NULL, 0),
(614, 1040, 614, NULL, NULL, NULL, 0),
(615, 1057, 615, NULL, NULL, NULL, 0),
(616, 958, 616, NULL, NULL, NULL, 0),
(617, NULL, 617, NULL, NULL, NULL, 0),
(618, 971, 618, NULL, NULL, NULL, 0),
(619, 978, 619, NULL, NULL, NULL, 0),
(620, 698, 620, NULL, NULL, NULL, 0),
(621, 968, 621, NULL, NULL, NULL, 0),
(622, 989, 622, NULL, NULL, NULL, 0),
(623, 1030, 623, NULL, NULL, NULL, 0),
(624, 965, 624, NULL, NULL, NULL, 0),
(625, 495, 625, NULL, NULL, NULL, 0),
(626, 438, 626, NULL, NULL, NULL, 0),
(627, 23, 627, NULL, NULL, NULL, 0),
(628, 402, 628, NULL, NULL, NULL, 0),
(629, 111, 629, NULL, NULL, NULL, 0),
(630, 298, 630, NULL, NULL, NULL, 0),
(631, 255, 631, NULL, NULL, NULL, 0),
(632, 516, 632, NULL, NULL, NULL, 0),
(633, 154, 633, NULL, NULL, NULL, 0),
(634, NULL, 634, NULL, NULL, NULL, 0),
(635, 178, 635, NULL, NULL, NULL, 0),
(636, 122, 636, NULL, NULL, NULL, 0),
(637, 344, 637, NULL, NULL, NULL, 0),
(638, 484, 638, NULL, NULL, NULL, 0),
(639, 897, 639, NULL, NULL, NULL, 0),
(640, 638, 640, NULL, NULL, NULL, 0),
(641, 7, 641, NULL, NULL, NULL, 0),
(642, 613, 642, NULL, NULL, NULL, 0),
(643, 860, 643, NULL, NULL, NULL, 0),
(644, 801, 644, NULL, NULL, NULL, 0),
(645, 954, 645, NULL, NULL, NULL, 0),
(646, 314, 646, NULL, NULL, NULL, 0),
(647, 271, 647, NULL, NULL, NULL, 0),
(648, 904, 648, NULL, NULL, NULL, 0),
(649, 102, 649, NULL, NULL, NULL, 0),
(650, 480, 650, NULL, NULL, NULL, 0),
(651, 291, 651, NULL, NULL, NULL, 0),
(652, 340, 652, NULL, NULL, NULL, 0),
(653, 69, 653, NULL, NULL, NULL, 0),
(654, 138, 654, NULL, NULL, NULL, 0),
(655, NULL, 655, NULL, NULL, NULL, 0),
(656, 211, 656, NULL, NULL, NULL, 0),
(657, 411, 657, NULL, NULL, NULL, 0),
(658, 374, 658, NULL, NULL, NULL, 0),
(659, 790, 659, NULL, NULL, NULL, 0),
(660, 597, 660, NULL, NULL, NULL, 0),
(661, 99, 661, NULL, NULL, NULL, 0),
(662, 815, 662, NULL, NULL, NULL, 0),
(663, NULL, 663, NULL, NULL, NULL, 0),
(664, NULL, 664, NULL, NULL, NULL, 0),
(665, NULL, 665, NULL, NULL, NULL, 0),
(666, NULL, 666, NULL, NULL, NULL, 0),
(667, NULL, 667, NULL, NULL, NULL, 0),
(668, 366, 668, NULL, NULL, NULL, 0),
(669, NULL, 669, NULL, NULL, NULL, 0),
(670, NULL, 670, NULL, NULL, NULL, 0),
(671, NULL, 671, NULL, NULL, NULL, 0),
(672, NULL, 672, NULL, NULL, NULL, 0),
(673, NULL, 673, NULL, NULL, NULL, 0),
(674, NULL, 674, NULL, NULL, NULL, 0),
(675, NULL, 675, NULL, NULL, NULL, 0),
(676, 1026, 676, NULL, NULL, NULL, 0),
(677, NULL, 677, NULL, NULL, NULL, 0),
(678, NULL, 678, NULL, NULL, NULL, 0),
(679, NULL, 679, NULL, NULL, NULL, 0),
(680, NULL, 680, NULL, NULL, NULL, 0),
(681, NULL, 681, NULL, NULL, NULL, 0),
(682, NULL, 682, NULL, NULL, NULL, 0),
(683, NULL, 683, NULL, NULL, NULL, 0),
(684, NULL, 684, NULL, NULL, NULL, 0),
(685, NULL, 685, NULL, NULL, NULL, 0),
(686, NULL, 686, NULL, NULL, NULL, 0),
(687, NULL, 687, NULL, NULL, NULL, 0),
(688, NULL, 688, NULL, NULL, NULL, 0),
(689, NULL, 689, NULL, NULL, NULL, 0),
(690, NULL, 690, NULL, NULL, NULL, 0),
(691, NULL, 691, NULL, NULL, NULL, 0),
(692, NULL, 692, NULL, NULL, NULL, 0),
(693, NULL, 693, NULL, NULL, NULL, 0),
(694, NULL, 694, NULL, NULL, NULL, 0),
(695, NULL, 695, NULL, NULL, NULL, 0),
(696, NULL, 696, NULL, NULL, NULL, 0),
(697, NULL, 697, NULL, NULL, NULL, 0),
(698, NULL, 698, NULL, NULL, NULL, 0),
(699, NULL, 699, NULL, NULL, NULL, 0),
(700, NULL, 700, NULL, NULL, NULL, 0),
(701, NULL, 701, NULL, NULL, NULL, 0),
(702, NULL, 702, NULL, NULL, NULL, 0),
(703, NULL, 703, NULL, NULL, NULL, 0),
(704, NULL, 704, NULL, NULL, NULL, 0),
(705, NULL, 705, NULL, NULL, NULL, 0),
(706, NULL, 706, NULL, NULL, NULL, 0),
(707, NULL, 707, NULL, NULL, NULL, 0),
(708, NULL, 708, NULL, NULL, NULL, 0),
(709, NULL, 709, NULL, NULL, NULL, 0),
(710, NULL, 710, NULL, NULL, NULL, 0),
(711, NULL, 711, NULL, NULL, NULL, 0),
(712, NULL, 712, NULL, NULL, NULL, 0),
(713, NULL, 713, NULL, NULL, NULL, 0),
(714, NULL, 714, NULL, NULL, NULL, 0),
(715, NULL, 715, NULL, NULL, NULL, 0),
(716, NULL, 716, NULL, NULL, NULL, 0),
(717, NULL, 717, NULL, NULL, NULL, 0),
(718, NULL, 718, NULL, NULL, NULL, 0),
(719, NULL, 719, NULL, NULL, NULL, 0),
(720, NULL, 720, NULL, NULL, NULL, 0),
(721, NULL, 721, NULL, NULL, NULL, 0),
(722, NULL, 722, NULL, NULL, NULL, 0),
(723, NULL, 723, NULL, NULL, NULL, 0),
(724, NULL, 724, NULL, NULL, NULL, 0),
(725, NULL, 725, NULL, NULL, NULL, 0),
(726, NULL, 726, NULL, NULL, NULL, 0),
(727, NULL, 727, NULL, NULL, NULL, 0),
(728, NULL, 728, NULL, NULL, NULL, 0),
(729, NULL, 729, NULL, NULL, NULL, 0),
(730, NULL, 730, NULL, NULL, NULL, 0),
(731, NULL, 731, NULL, NULL, NULL, 0),
(732, NULL, 732, NULL, NULL, NULL, 0),
(733, NULL, 733, NULL, NULL, NULL, 0),
(734, NULL, 734, NULL, NULL, NULL, 0),
(735, NULL, 735, NULL, NULL, NULL, 0),
(736, NULL, 736, NULL, NULL, NULL, 0),
(737, NULL, 737, NULL, NULL, NULL, 0),
(738, NULL, 738, NULL, NULL, NULL, 0),
(739, 1031, 739, NULL, NULL, NULL, 0),
(740, NULL, 740, NULL, NULL, NULL, 0),
(741, NULL, 741, NULL, NULL, NULL, 0),
(742, NULL, 742, NULL, NULL, NULL, 0),
(743, NULL, 743, NULL, NULL, NULL, 0),
(744, NULL, 744, NULL, NULL, NULL, 0),
(745, 752, 745, NULL, NULL, NULL, 0),
(746, NULL, 746, NULL, NULL, NULL, 0),
(747, NULL, 747, NULL, NULL, NULL, 0),
(748, NULL, 748, NULL, NULL, NULL, 0),
(749, NULL, 749, NULL, NULL, NULL, 0),
(750, NULL, 750, NULL, NULL, NULL, 0),
(751, NULL, 751, NULL, NULL, NULL, 0),
(752, NULL, 752, NULL, NULL, NULL, 0),
(753, NULL, 753, NULL, NULL, NULL, 0),
(754, NULL, 754, NULL, NULL, NULL, 0),
(755, NULL, 755, NULL, NULL, NULL, 0),
(756, NULL, 756, NULL, NULL, NULL, 0),
(757, NULL, 757, NULL, NULL, NULL, 0),
(758, NULL, 758, NULL, NULL, NULL, 0),
(759, NULL, 759, NULL, NULL, NULL, 0),
(760, NULL, 760, NULL, NULL, NULL, 0),
(761, NULL, 761, NULL, NULL, NULL, 0),
(762, NULL, 762, NULL, NULL, NULL, 0),
(763, NULL, 763, NULL, NULL, NULL, 0),
(764, NULL, 764, NULL, NULL, NULL, 0),
(765, NULL, 765, NULL, NULL, NULL, 0),
(766, NULL, 766, NULL, NULL, NULL, 0),
(767, NULL, 767, NULL, NULL, NULL, 0),
(768, NULL, 768, NULL, NULL, NULL, 0),
(769, NULL, 769, NULL, NULL, NULL, 0),
(770, NULL, 770, NULL, NULL, NULL, 0),
(771, NULL, 771, NULL, NULL, NULL, 0),
(772, NULL, 772, NULL, NULL, NULL, 0),
(773, NULL, 773, NULL, NULL, NULL, 0),
(774, NULL, 774, NULL, NULL, NULL, 0),
(775, NULL, 775, NULL, NULL, NULL, 0),
(776, NULL, 776, NULL, NULL, NULL, 0),
(777, NULL, 777, NULL, NULL, NULL, 0),
(778, NULL, 778, NULL, NULL, NULL, 0),
(779, 389, 779, NULL, NULL, NULL, 0),
(780, NULL, 780, NULL, NULL, NULL, 0),
(781, 959, 781, NULL, NULL, NULL, 0),
(782, NULL, 782, NULL, NULL, NULL, 0),
(783, NULL, 783, NULL, NULL, NULL, 0),
(784, NULL, 784, NULL, NULL, NULL, 0),
(785, NULL, 785, NULL, NULL, NULL, 0),
(786, NULL, 786, NULL, NULL, NULL, 0),
(787, NULL, 787, NULL, NULL, NULL, 0),
(788, NULL, 788, NULL, NULL, NULL, 0),
(789, NULL, 789, NULL, NULL, NULL, 0),
(790, NULL, 790, NULL, NULL, NULL, 0),
(791, 1069, 791, NULL, NULL, NULL, 0),
(792, 115, 792, NULL, NULL, NULL, 0),
(793, NULL, 793, NULL, NULL, NULL, 0),
(794, NULL, 794, NULL, NULL, NULL, 0),
(795, NULL, 795, NULL, NULL, NULL, 0),
(796, NULL, 796, NULL, NULL, NULL, 0),
(797, NULL, 797, NULL, NULL, NULL, 0),
(798, NULL, 798, NULL, NULL, NULL, 0),
(799, NULL, 799, NULL, NULL, NULL, 0),
(800, NULL, 800, NULL, NULL, NULL, 0),
(801, NULL, 801, NULL, NULL, NULL, 0),
(802, NULL, 802, NULL, NULL, NULL, 0),
(803, NULL, 803, NULL, NULL, NULL, 0),
(804, NULL, 804, NULL, NULL, NULL, 0),
(805, NULL, 805, NULL, NULL, NULL, 0),
(806, NULL, 806, NULL, NULL, NULL, 0),
(807, NULL, 807, NULL, NULL, NULL, 0),
(808, NULL, 808, NULL, NULL, NULL, 0),
(809, NULL, 809, NULL, NULL, NULL, 0),
(810, NULL, 810, NULL, NULL, NULL, 0),
(811, NULL, 811, NULL, NULL, NULL, 0),
(812, NULL, 812, NULL, NULL, NULL, 0),
(813, NULL, 813, NULL, NULL, NULL, 0),
(814, NULL, 814, NULL, NULL, NULL, 0),
(815, NULL, 815, NULL, NULL, NULL, 0),
(816, NULL, 816, NULL, NULL, NULL, 0),
(817, NULL, 817, NULL, NULL, NULL, 0),
(818, 1, 818, NULL, NULL, NULL, 0),
(819, NULL, 819, NULL, NULL, NULL, 0),
(820, NULL, 820, NULL, NULL, NULL, 0),
(821, NULL, 821, NULL, NULL, NULL, 0),
(822, NULL, 822, NULL, NULL, NULL, 0),
(823, NULL, 823, NULL, NULL, NULL, 0),
(824, NULL, 824, NULL, NULL, NULL, 0),
(825, NULL, 825, NULL, NULL, NULL, 0),
(826, NULL, 826, NULL, NULL, NULL, 0),
(827, NULL, 827, NULL, NULL, NULL, 0),
(828, NULL, 828, NULL, NULL, NULL, 0),
(829, NULL, 829, NULL, NULL, NULL, 0),
(830, NULL, 830, NULL, NULL, NULL, 0),
(831, NULL, 831, NULL, NULL, NULL, 0),
(832, NULL, 832, NULL, NULL, NULL, 0),
(833, NULL, 833, NULL, NULL, NULL, 0),
(834, NULL, 834, NULL, NULL, NULL, 0),
(835, NULL, 835, NULL, NULL, NULL, 0),
(836, NULL, 836, NULL, NULL, NULL, 0),
(837, 834, 837, NULL, NULL, NULL, 0),
(838, NULL, 838, NULL, NULL, NULL, 0),
(839, NULL, 839, NULL, NULL, NULL, 0),
(840, NULL, 840, NULL, NULL, NULL, 0),
(841, NULL, 841, NULL, NULL, NULL, 0),
(842, NULL, 842, NULL, NULL, NULL, 0),
(843, NULL, 843, NULL, NULL, NULL, 0),
(844, NULL, 844, NULL, NULL, NULL, 0),
(845, NULL, 845, NULL, NULL, NULL, 0),
(846, NULL, 846, NULL, NULL, NULL, 0),
(847, NULL, 847, NULL, NULL, NULL, 0),
(848, NULL, 848, NULL, NULL, NULL, 0),
(849, NULL, 849, NULL, NULL, NULL, 0),
(850, NULL, 850, NULL, NULL, NULL, 0),
(851, NULL, 851, NULL, NULL, NULL, 0),
(852, NULL, 852, NULL, NULL, NULL, 0),
(853, NULL, 853, NULL, NULL, NULL, 0),
(854, NULL, 854, NULL, NULL, NULL, 0),
(855, NULL, 855, NULL, NULL, NULL, 0),
(856, NULL, 856, NULL, NULL, NULL, 0),
(857, NULL, 857, NULL, NULL, NULL, 0),
(858, NULL, 858, NULL, NULL, NULL, 0),
(859, NULL, 859, NULL, NULL, NULL, 0),
(860, NULL, 860, NULL, NULL, NULL, 0),
(861, NULL, 861, NULL, NULL, NULL, 0),
(862, NULL, 862, NULL, NULL, NULL, 0),
(863, NULL, 863, NULL, NULL, NULL, 0),
(864, NULL, 864, NULL, NULL, NULL, 0),
(865, NULL, 865, NULL, NULL, NULL, 0),
(866, NULL, 866, NULL, NULL, NULL, 0),
(867, NULL, 867, NULL, NULL, NULL, 0),
(868, NULL, 868, NULL, NULL, NULL, 0),
(869, NULL, 869, NULL, NULL, NULL, 0),
(870, NULL, 870, NULL, NULL, NULL, 0),
(871, NULL, 871, NULL, NULL, NULL, 0),
(872, NULL, 872, NULL, NULL, NULL, 0),
(873, NULL, 873, NULL, NULL, NULL, 0),
(874, NULL, 874, NULL, NULL, NULL, 0),
(875, NULL, 875, NULL, NULL, NULL, 0),
(876, NULL, 876, NULL, NULL, NULL, 0),
(877, NULL, 877, NULL, NULL, NULL, 0),
(878, NULL, 878, NULL, NULL, NULL, 0),
(879, NULL, 879, NULL, NULL, NULL, 0),
(880, NULL, 880, NULL, NULL, NULL, 0),
(881, NULL, 881, NULL, NULL, NULL, 0),
(882, NULL, 882, NULL, NULL, NULL, 0),
(883, NULL, 883, NULL, NULL, NULL, 0),
(884, NULL, 884, NULL, NULL, NULL, 0),
(885, NULL, 885, NULL, NULL, NULL, 0),
(886, NULL, 886, NULL, NULL, NULL, 0),
(887, NULL, 887, NULL, NULL, NULL, 0),
(888, NULL, 888, NULL, NULL, NULL, 0),
(889, NULL, 889, NULL, NULL, NULL, 0),
(890, NULL, 890, NULL, NULL, NULL, 0),
(891, NULL, 891, NULL, NULL, NULL, 0),
(892, NULL, 892, NULL, NULL, NULL, 0),
(893, 276, 893, NULL, NULL, NULL, 0),
(894, NULL, 894, NULL, NULL, NULL, 0),
(895, NULL, 895, NULL, NULL, NULL, 0),
(896, NULL, 896, NULL, NULL, NULL, 0),
(897, NULL, 897, NULL, NULL, NULL, 0),
(898, NULL, 898, NULL, NULL, NULL, 0),
(899, NULL, 899, NULL, NULL, NULL, 0),
(900, NULL, 900, NULL, NULL, NULL, 0),
(901, NULL, 901, NULL, NULL, NULL, 0),
(902, NULL, 902, NULL, NULL, NULL, 0),
(903, NULL, 903, NULL, NULL, NULL, 0),
(904, NULL, 904, NULL, NULL, NULL, 0),
(905, NULL, 905, NULL, NULL, NULL, 0),
(906, 492, 906, NULL, NULL, NULL, 0),
(907, 491, 907, NULL, NULL, NULL, 0),
(908, 526, 908, NULL, NULL, NULL, 0),
(909, 482, 909, NULL, NULL, NULL, 0),
(910, 126, 910, NULL, NULL, NULL, 0),
(911, 446, 911, NULL, NULL, NULL, 0),
(912, 419, 912, NULL, NULL, NULL, 0),
(913, 265, 913, NULL, NULL, NULL, 0),
(914, NULL, 914, NULL, NULL, NULL, 0),
(915, 22, 915, NULL, NULL, NULL, 0),
(916, 63, 916, NULL, NULL, NULL, 0),
(917, NULL, 917, NULL, NULL, NULL, 0),
(918, 372, 918, NULL, NULL, NULL, 0),
(919, 12, 919, NULL, NULL, NULL, 0),
(920, 179, 920, NULL, NULL, NULL, 0),
(921, 465, 921, NULL, NULL, NULL, 0),
(922, 227, 922, NULL, NULL, NULL, 0),
(923, 287, 923, NULL, NULL, NULL, 0),
(924, 181, 924, NULL, NULL, NULL, 0),
(925, 70, 925, NULL, NULL, NULL, 0),
(926, 457, 926, NULL, NULL, NULL, 0),
(927, 540, 927, NULL, NULL, NULL, 0),
(928, 711, 928, NULL, NULL, NULL, 0),
(929, 237, 929, NULL, NULL, NULL, 0),
(930, 218, 930, NULL, NULL, NULL, 0),
(931, 14, 931, NULL, NULL, NULL, 0),
(932, NULL, 932, NULL, NULL, NULL, 0),
(933, 273, 933, NULL, NULL, NULL, 0),
(934, 858, 934, NULL, NULL, NULL, 0),
(935, 421, 935, NULL, NULL, NULL, 0),
(936, 770, 936, NULL, NULL, NULL, 0),
(937, 109, 937, NULL, NULL, NULL, 0),
(938, 642, 938, NULL, NULL, NULL, 0),
(939, 511, 939, '2019-08-31', NULL, NULL, 1),
(940, 399, 940, NULL, NULL, NULL, 0),
(941, 49, 941, NULL, NULL, NULL, 0),
(942, 75, 942, NULL, NULL, NULL, 0),
(943, NULL, 943, NULL, NULL, NULL, 0),
(944, 1068, 944, NULL, NULL, NULL, 0),
(945, 483, 945, NULL, NULL, NULL, 0),
(946, 150, 946, NULL, NULL, NULL, 0),
(947, 1005, 947, NULL, NULL, NULL, 0),
(948, 544, 948, NULL, NULL, NULL, 0),
(949, 382, 949, NULL, NULL, NULL, 0),
(950, 545, 950, NULL, NULL, NULL, 0),
(951, 141, 951, NULL, NULL, NULL, 0),
(952, 536, 952, NULL, NULL, NULL, 0),
(953, NULL, 953, NULL, NULL, NULL, 0),
(954, 113, 954, NULL, NULL, NULL, 0),
(955, NULL, 955, NULL, NULL, NULL, 0),
(956, NULL, 956, NULL, NULL, NULL, 0),
(957, NULL, 957, NULL, NULL, NULL, 0),
(958, 231, 958, NULL, NULL, NULL, 0),
(959, 796, 959, NULL, NULL, NULL, 0),
(960, 300, 960, NULL, NULL, NULL, 0),
(961, 152, 961, NULL, NULL, NULL, 0),
(962, 781, 962, NULL, NULL, NULL, 0),
(963, 701, 963, NULL, NULL, NULL, 0),
(964, 796, 964, NULL, NULL, NULL, 0),
(965, 1023, 965, NULL, NULL, NULL, 0),
(966, 380, 966, NULL, NULL, NULL, 0),
(967, NULL, 967, NULL, NULL, NULL, 0),
(968, 541, 968, NULL, NULL, NULL, 0),
(969, 788, 969, NULL, NULL, NULL, 0),
(970, 24, 970, NULL, NULL, NULL, 0),
(971, 415, 971, NULL, NULL, NULL, 0),
(972, 324, 972, NULL, NULL, NULL, 0),
(973, 599, 973, NULL, NULL, NULL, 0),
(974, 9, 974, NULL, NULL, NULL, 0),
(975, 445, 975, NULL, NULL, NULL, 0),
(976, 560, 976, NULL, NULL, NULL, 0),
(977, 565, 977, NULL, NULL, NULL, 0),
(978, 53, 978, NULL, NULL, NULL, 0),
(979, 259, 979, NULL, NULL, NULL, 0),
(980, 93, 980, NULL, NULL, NULL, 0),
(981, NULL, 981, NULL, NULL, NULL, 0),
(985, 1081, 2, NULL, NULL, NULL, 0),
(986, 511, 1, NULL, NULL, NULL, 0);

--
-- Indexes for dumped tables
--

--
-- Indexes for table `plantilla_personnels`
--
ALTER TABLE `plantilla_personnels`
  ADD PRIMARY KEY (`id`),
  ADD KEY `plantilla_personnels_personnel_id_foreign` (`personnel_id`),
  ADD KEY `plantilla_personnels_plantilla_id_foreign` (`plantilla_id`),
  ADD KEY `plantilla_personnels_remarks_id_foreign` (`remarks_id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `plantilla_personnels`
--
ALTER TABLE `plantilla_personnels`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=987;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `plantilla_personnels`
--
ALTER TABLE `plantilla_personnels`
  ADD CONSTRAINT `plantilla_personnels_personnel_id_foreign` FOREIGN KEY (`personnel_id`) REFERENCES `personnel` (`id`),
  ADD CONSTRAINT `plantilla_personnels_plantilla_id_foreign` FOREIGN KEY (`plantilla_id`) REFERENCES `plantillas` (`id`),
  ADD CONSTRAINT `plantilla_personnels_remarks_id_foreign` FOREIGN KEY (`remarks_id`) REFERENCES `plantilla_remarks` (`id`);
COMMIT;

/*!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 */;
