SQL (Pertemuan 11)
Kasus :
Sebuah perguruan tinggi akan menyelanggarakan Kuliah Kerja Nyata (KKN). KKN kali ini berada di 5 kecamatan, Setiap kecamatan memiliki 4 sampai 6 desa. Setiap desa dapat berisi 15-17 mahasiswa dari berbagai program studi. Namun setelah memilih desa mahasiswa TIDAK DAPAT merubah desa yang telah di pilih. sistem juga harus mencatan nilai dari setiap mahasiswa di akhir pelaksanaan KKN. (Database yang sudah ada 1000 data)
-- phpMyAdmin SQL Dump
-- version 5.2.0
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Dec 11, 2022 at 02:55 PM
-- Server version: 10.4.25-MariaDB
-- PHP Version: 7.4.30
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
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: `db_kkn`
--
-- --------------------------------------------------------
--
-- Table structure for table `desa`
--
CREATE TABLE `desa` (
`idDesa` int(11) NOT NULL,
`NamaDesa` varchar(45) NOT NULL,
`AlamatDesa` varchar(45) DEFAULT NULL,
`idKecamatan` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
-- --------------------------------------------------------
--
-- Table structure for table `kecamatan`
--
CREATE TABLE `kecamatan` (
`idKecamatan` int(11) NOT NULL,
`NamaKecamatan` varchar(45) NOT NULL,
`KepalaKecamatan` varchar(45) DEFAULT NULL,
`AlamatKecamatan` varchar(45) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
-- --------------------------------------------------------
--
-- Table structure for table `kelompok_kkn`
--
CREATE TABLE `kelompok_kkn` (
`idKELOMPOK_KKN` int(11) NOT NULL,
`DESA_idDesa` int(11) NOT NULL,
`periode_periode` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
-- --------------------------------------------------------
--
-- Table structure for table `mahasiswa`
--
CREATE TABLE `mahasiswa` (
`nim` int(11) NOT NULL,
`Nama` varchar(45) NOT NULL,
`NoHp` varchar(45) DEFAULT NULL,
`PRODI_KodeProdi` varchar(45) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--
-- Dumping data for table `mahasiswa`
--
INSERT INTO `mahasiswa` (`nim`, `Nama`, `NoHp`, `PRODI_KodeProdi`) VALUES
(1, 'Gabe Berrie', '+7-442-436-3407', 'TI'),
(2, 'Morly Macallam', '+685-297-893-8000', 'IF'),
(3, 'Ignace Paternoster', '+967-772-212-3076', 'IF'),
(4, 'Doyle Chattington', '+420-766-757-9128', 'TM'),
(5, 'Andie Odeson', '+93-395-303-8648', 'TM'),
(6, 'Mame Sycamore', '+62-439-397-0379', 'IF'),
(7, 'Teressa Crispin', '+86-117-720-0817', 'TM'),
(8, 'Bud Rainard', '+7-260-575-6000', 'SI'),
(9, 'Ashley Couthard', '+56-671-625-8776', 'SI'),
(10, 'Susann Grevile', '+1-337-396-9225', 'IF'),
(11, 'Lion Castellaccio', '+62-814-618-8685', 'TM'),
(12, 'Bill Gornal', '+86-717-324-6142', 'IF'),
(13, 'Tedi Skeete', '+86-523-625-2090', 'TI'),
(14, 'Giffard Legerwood', '+1-334-792-7240', 'IF'),
(15, 'Averyl Breming', '+62-728-352-6260', 'SI'),
(16, 'Terese Flude', '+1-561-792-6854', 'TM'),
(17, 'Leigh Neames', '+507-362-610-5033', 'TM'),
(18, 'Les Pawellek', '+55-109-808-3469', 'TI'),
(19, 'Babbette Preedy', '+62-168-639-4249', 'TI'),
(20, 'Selle Brixey', '+1-904-389-3532', 'IF'),
(21, 'Roxana Labden', '+33-756-588-0025', 'IF'),
(22, 'Klaus Rainville', '+966-525-580-6355', 'TI'),
(23, 'Tammie Capelow', '+27-671-107-4587', 'TM'),
(24, 'Modestia Scolland', '+84-512-517-7562', 'SI'),
(25, 'Paolo Gaitley', '+976-806-816-9696', 'TM'),
(26, 'Josselyn Robertsson', '+48-525-450-1272', 'IF'),
(27, 'Izak Duprey', '+48-124-117-4633', 'SI'),
(28, 'Gil Prujean', '+1-602-457-8756', 'SI'),
(29, 'Darwin Routley', '+420-383-638-2055', 'SI'),
(30, 'Pammy Welbeck', '+994-276-871-0059', 'IF'),
(31, 'Arabelle Darque', '+48-978-281-5736', 'IF'),
(32, 'Farrell Rasher', '+960-696-344-9730', 'TM'),
(33, 'Baird Moralis', '+55-237-376-2658', 'IF'),
(34, 'Marilyn Fausch', '+86-412-856-5362', 'SI'),
(35, 'Annabela Goncalo', '+48-557-531-9497', 'SI'),
(36, 'Sharla Kilfedder', '+93-566-480-6288', 'SI'),
(37, 'Colin Nulty', '+93-390-882-2911', 'TI'),
(38, 'Harmony Bachelar', '+52-261-460-2657', 'SI'),
(39, 'Kristi Eilhersen', '+52-155-697-7661', 'TI'),
(40, 'Casandra O\' Neligan', '+358-629-505-5732', 'SI'),
(41, 'Helyn Johanchon', '+86-694-624-8544', 'SI'),
(42, 'Tallie Allitt', '+420-437-755-7971', 'TI'),
(43, 'Toinette Edmed', '+967-785-123-9187', 'IF'),
(44, 'Aigneis Dibben', '+62-744-681-5083', 'IF'),
(45, 'Pinchas Cantos', '+62-245-296-8157', 'SI'),
(46, 'Bren Kunes', '+33-471-902-0536', 'TM'),
(47, 'Flory Bilbee', '+62-801-964-4499', 'IF'),
(48, 'Niki Bernardot', '+62-308-717-8344', 'TM'),
(49, 'Pippa Chesney', '+62-552-342-0574', 'TM'),
(50, 'Adams Percival', '+212-640-782-8599', 'IF'),
(51, 'Brittney Palumbo', '+352-392-932-1949', 'TM'),
(52, 'Selena Scrowton', '+86-541-210-9361', 'TI'),
(53, 'Reyna Glantz', '+264-680-957-6548', 'TM'),
(54, 'Marylinda Reyna', '+54-446-733-2289', 'SI'),
(55, 'Miran Fattorini', '+62-683-538-4986', 'TI'),
(56, 'Zollie Sharpous', '+381-474-367-4584', 'TM'),
(57, 'Jewell Petrushka', '+212-407-788-8338', 'TI'),
(58, 'Bendite Wharf', '+53-635-580-0330', 'SI'),
(59, 'Trevar Fergusson', '+598-808-817-6805', 'IF'),
(60, 'Ange Andrew', '+62-326-636-3059', 'SI'),
(61, 'Abagael Burwell', '+86-998-339-2760', 'IF'),
(62, 'Brena Roxby', '+420-286-686-8065', 'SI'),
(63, 'Roxana Bengall', '+84-396-413-1460', 'SI'),
(64, 'Jannelle Yarham', '+62-103-612-4501', 'TI'),
(65, 'Ariana Passman', '+86-611-857-4308', 'TM'),
(66, 'Filippa Briat', '+7-680-422-8833', 'SI'),
(67, 'Falito Gainsburgh', '+86-989-704-4773', 'TM'),
(68, 'Gallagher Profit', '+86-900-747-4796', 'TI'),
(69, 'Sherye Withringten', '+36-956-242-5076', 'IF'),
(70, 'Morgen Mingaye', '+46-112-717-2394', 'TI'),
(71, 'Hadria Jensen', '+66-221-476-1164', 'IF'),
(72, 'Brittne Clough', '+86-356-834-0670', 'TI'),
(73, 'Vale Alman', '+57-493-109-6817', 'SI'),
(74, 'Joannes Hewson', '+353-582-278-8600', 'SI'),
(75, 'Scotty Queree', '+354-160-864-0759', 'TI'),
(76, 'Erica Creelman', '+52-893-600-9403', 'IF'),
(77, 'Ephrem Filipiak', '+62-180-703-5290', 'TI'),
(78, 'Ginny Piatkow', '+55-141-547-0868', 'TM'),
(79, 'Normie Hamel', '+33-549-701-1337', 'IF'),
(80, 'Jemmy Forlong', '+7-420-161-7505', 'TM'),
(81, 'Esmaria Southerns', '+51-220-526-2827', 'TM'),
(82, 'Jehanna Massel', '+81-907-415-8415', 'TM'),
(83, 'Pierette Cheng', '+7-310-471-1768', 'TM'),
(84, 'Jessy Dearing', '+62-609-193-6070', 'IF'),
(85, 'Emmy Merrell', '+62-950-916-5107', 'TI'),
(86, 'Herschel Wastling', '+223-701-304-5990', 'TI'),
(87, 'Holmes Dominick', '+351-116-168-3068', 'TI'),
(88, 'Marilee Patkin', '+380-190-761-6225', 'SI'),
(89, 'Manolo Hawkyens', '+86-782-875-4925', 'TM'),
(90, 'Sollie Busst', '+263-302-972-3480', 'TI'),
(91, 'Neda Filppetti', '+224-367-581-4286', 'IF'),
(92, 'Frants Furneaux', '+66-212-676-5852', 'IF'),
(93, 'Rahel Macari', '+7-839-146-1564', 'TI'),
(94, 'Morgana Paridge', '+55-422-673-6296', 'IF'),
(95, 'Wye Gethings', '+1-863-726-1211', 'TI'),
(96, 'Brinn Benduhn', '+62-899-914-1423', 'TM'),
(97, 'Launce Guidelli', '+46-377-500-7864', 'TM'),
(98, 'Michele Kingham', '+86-323-779-2897', 'SI'),
(99, 'Ailey MacNeely', '+48-196-109-6649', 'SI'),
(100, 'Brady Durrant', '+351-897-628-8311', 'IF'),
(101, 'Nan Lehrle', '+27-878-580-2770', 'TI'),
(102, 'Wanids Earngy', '+48-572-386-2708', 'SI'),
(103, 'Quent Pither', '+48-378-245-1761', 'TM'),
(104, 'Katlin Wison', '+86-643-614-7058', 'SI'),
(105, 'Umeko Maddie', '+86-529-848-8201', 'SI'),
(106, 'Alasteir Emes', '+81-136-167-4208', 'SI'),
(107, 'Karlotte Janaud', '+33-716-491-7008', 'SI'),
(108, 'Gerty Gatman', '+46-378-481-6379', 'TI'),
(109, 'Morlee Windham', '+261-941-819-9549', 'TI'),
(110, 'Kayne Durgan', '+48-938-150-5117', 'SI'),
(111, 'Stormy Caston', '+86-783-715-4264', 'TM'),
(112, 'Meghann Collihole', '+7-215-364-4984', 'IF'),
(113, 'Dasie Yakebovich', '+972-814-263-8571', 'IF'),
(114, 'Ad Witz', '+86-983-150-8835', 'IF'),
(115, 'Wilhelmina Beeble', '+51-894-961-5244', 'TM'),
(116, 'Rica Clulow', '+86-524-335-3491', 'TI'),
(117, 'Tucker Scoffins', '+507-527-676-8819', 'TI'),
(118, 'Morley Scandrett', '+62-751-779-9670', 'TI'),
(119, 'Ariella Clemes', '+46-840-602-5848', 'SI'),
(120, 'Janenna Leupoldt', '+86-308-203-4528', 'TM'),
(121, 'Jock Heartfield', '+961-249-244-6065', 'IF'),
(122, 'Any Rogger', '+353-304-532-1249', 'IF'),
(123, 'Zsazsa O\'Codihie', '+86-996-227-7268', 'IF'),
(124, 'Carree Mercik', '+354-126-757-0407', 'TI'),
(125, 'Kelcey Hallor', '+86-104-618-4196', 'TI'),
(126, 'Riordan Hargitt', '+976-714-674-3194', 'SI'),
(127, 'Urbano Hardaway', '+420-786-931-6735', 'TI'),
(128, 'Jodee Cornils', '+55-284-371-6344', 'TM'),
(129, 'Loretta Rzehor', '+60-240-673-4114', 'IF'),
(130, 'Suellen Belchem', '+55-162-162-5918', 'IF'),
(131, 'Darby Gilbanks', '+30-676-969-3108', 'IF'),
(132, 'Brok Izen', '+86-518-468-0330', 'IF'),
(133, 'Jennilee Pablos', '+86-986-535-8799', 'TM'),
(134, 'Putnam Monday', '+1-423-185-6416', 'TI'),
(135, 'Ingemar Grayshon', '+1-931-517-4139', 'IF'),
(136, 'Hildegarde Durbyn', '+52-956-688-0943', 'TI'),
(137, 'Guglielma Gasticke', '+86-585-632-8369', 'SI'),
(138, 'Henrie Olyff', '+62-211-818-9168', 'TM'),
(139, 'Ronnie Freen', '+46-455-175-7291', 'IF'),
(140, 'Pearla Laurens', '+7-485-776-8901', 'TM'),
(141, 'Thekla Rexworthy', '+63-518-707-0246', 'SI'),
(142, 'Jodi Renols', '+62-376-535-2321', 'SI'),
(143, 'Bili Willisch', '+63-291-471-5239', 'TM'),
(144, 'Briny Blasius', '+1-818-137-7350', 'TI'),
(145, 'Natale Keighly', '+967-431-152-9428', 'TM'),
(146, 'Audi Bemlott', '+502-672-185-6075', 'TI'),
(147, 'Dory Fibben', '+49-350-359-1583', 'SI'),
(148, 'Cosette Tink', '+62-936-445-9754', 'IF'),
(149, 'Casey Onyon', '+55-102-202-0879', 'TI'),
(150, 'Agna Toffel', '+55-293-325-9621', 'TI'),
(151, 'Maura Boddington', '+30-528-529-4459', 'IF'),
(152, 'Nicholas Dominey', '+351-596-996-0938', 'TM'),
(153, 'Lilas Bramall', '+52-996-730-9427', 'SI'),
(154, 'Alysa Cummine', '+380-207-243-4471', 'SI'),
(155, 'Britte Di Biasi', '+63-196-240-9578', 'IF'),
(156, 'Mirella Tebbit', '+54-945-832-8213', 'TI'),
(157, 'Brennan Befroy', '+52-333-880-3661', 'TM'),
(158, 'Georgette Scoullar', '+86-993-368-6615', 'SI'),
(159, 'Beck Yokelman', '+351-853-594-1811', 'TI'),
(160, 'Patrica Blasius', '+60-478-724-6525', 'SI'),
(161, 'Consolata Buessen', '+86-789-222-1252', 'TM'),
(162, 'Obadias Surridge', '+351-242-942-7514', 'SI'),
(163, 'Kathe Mc Mechan', '+7-936-382-6507', 'TM'),
(164, 'Crysta Pursglove', '+58-913-950-4884', 'TI'),
(165, 'Hagan Lythgoe', '+62-468-410-8569', 'TI'),
(166, 'Alix Marty', '+62-714-793-9524', 'TI'),
(167, 'Kort Chessun', '+62-201-885-8863', 'TM'),
(168, 'Rodolph Saladine', '+977-698-829-8025', 'TM'),
(169, 'Bettine Twort', '+33-429-456-3688', 'SI'),
(170, 'Mason Dosdale', '+52-918-983-2787', 'IF'),
(171, 'Carmen Di Boldi', '+86-535-248-3709', 'SI'),
(172, 'Tonye Crowthe', '+506-181-638-1949', 'SI'),
(173, 'Marie-ann Illston', '+49-433-143-6437', 'SI'),
(174, 'Gunilla Massot', '+86-132-749-6023', 'TI'),
(175, 'Weylin Smitheram', '+351-143-791-6959', 'IF'),
(176, 'Kasper Weblin', '+86-822-774-1228', 'IF'),
(177, 'Fanny Rispin', '+63-281-890-8917', 'IF'),
(178, 'Othelia Wolfenden', '+55-889-868-3679', 'IF'),
(179, 'Archibald Clemo', '+46-374-334-7841', 'TM'),
(180, 'Janaya Shufflebotham', '+46-554-732-1348', 'TI'),
(181, 'Jeramie Dentith', '+48-869-119-2779', 'TI'),
(182, 'Kaye Townsend', '+62-597-629-5616', 'SI'),
(183, 'Corinne Queree', '+86-896-734-2596', 'TI'),
(184, 'Bobbi Stirgess', '+977-152-314-2497', 'TM'),
(185, 'Thorndike Joskowitz', '+1-295-253-2322', 'SI'),
(186, 'Conny Egel', '+86-273-353-5380', 'IF'),
(187, 'Gladys De Maine', '+269-973-692-5482', 'SI'),
(188, 'Ruperto Hendin', '+7-151-362-6075', 'SI'),
(189, 'Peter Trigg', '+86-908-121-3056', 'TM'),
(190, 'Datha Bore', '+48-583-878-4145', 'TM'),
(191, 'Pacorro Turford', '+86-784-201-9211', 'SI'),
(192, 'Heriberto McNess', '+63-756-450-8827', 'TI'),
(193, 'Rycca Blincko', '+33-339-489-1741', 'IF'),
(194, 'Kessiah Massie', '+355-232-924-7804', 'TI'),
(195, 'Georgetta Petrillo', '+63-742-804-7549', 'IF'),
(196, 'Paulette Auty', '+57-233-686-6058', 'IF'),
(197, 'Isobel Barde', '+33-949-293-2479', 'TM'),
(198, 'Solly O\'Dougherty', '+62-865-826-5146', 'SI'),
(199, 'Elyse Sliman', '+86-512-876-5375', 'TI'),
(200, 'Emlyn Khadir', '+62-145-165-5969', 'IF'),
(201, 'Yolane Duthie', '+352-114-869-9911', 'IF'),
(202, 'Nanete Pennoni', '+62-504-303-2305', 'SI'),
(203, 'Yasmin Portugal', '+62-129-397-4339', 'IF'),
(204, 'Doll Allright', '+63-708-554-5954', 'TI'),
(205, 'Darcie Kalinowsky', '+48-112-380-4482', 'IF'),
(206, 'Therine Comley', '+62-222-426-2080', 'TI'),
(207, 'Hagan Ors', '+265-957-333-3097', 'TM'),
(208, 'Kassia Deschlein', '+55-451-527-9751', 'IF'),
(209, 'Dorrie Gibby', '+1-653-464-3289', 'SI'),
(210, 'Pete Emney', '+7-856-928-6358', 'SI'),
(211, 'Gusta Helsby', '+7-602-815-8524', 'SI'),
(212, 'Shurwood Duchan', '+7-330-325-8097', 'TM'),
(213, 'Marlo Bourdas', '+7-400-150-4085', 'TI'),
(214, 'Margie Riseborough', '+964-266-653-9055', 'SI'),
(215, 'Gerrard Pennycord', '+55-201-595-0689', 'IF'),
(216, 'Margarita Caseley', '+420-301-441-8371', 'TI'),
(217, 'Dmitri Doore', '+93-565-718-9099', 'SI'),
(218, 'Randy Burnsall', '+242-171-754-1503', 'TI'),
(219, 'Collie Colin', '+62-560-980-8599', 'SI'),
(220, 'Glenden Kulic', '+81-120-280-2918', 'TM'),
(221, 'Alyson Fleg', '+86-442-437-8123', 'TM'),
(222, 'Terrel Barkshire', '+691-269-486-8711', 'SI'),
(223, 'Pamella Toombes', '+995-388-102-1545', 'TI'),
(224, 'Ladonna Slimme', '+7-285-817-3522', 'SI'),
(225, 'Dwight Moncaster', '+86-493-847-5511', 'TI'),
(226, 'Matti Yeiles', '+86-898-218-7102', 'TI'),
(227, 'Kristyn Lassetter', '+62-439-137-9383', 'SI'),
(228, 'Brigid Dorrington', '+86-337-522-0583', 'TM'),
(229, 'Austine Fishpond', '+7-386-632-6214', 'IF'),
(230, 'Frank Pitrasso', '+47-724-441-7818', 'IF'),
(231, 'Perkin Casetti', '+57-191-130-8654', 'TI'),
(232, 'Christie Dahlberg', '+63-470-530-5974', 'TI'),
(233, 'Fidelia Gardiner', '+86-357-737-9559', 'SI'),
(234, 'Kassia Lympenie', '+506-125-193-6180', 'SI'),
(235, 'Marylou Creedland', '+62-830-537-0407', 'TM'),
(236, 'Heriberto Presnail', '+62-456-924-4382', 'IF'),
(237, 'Saul Kleinhaus', '+62-257-181-0879', 'TM'),
(238, 'Reinaldos Antowski', '+55-358-959-4467', 'TM'),
(239, 'Lorrie Truckell', '+94-374-189-5692', 'SI'),
(240, 'Dur Smaleman', '+86-165-489-8499', 'SI'),
(241, 'Brendan Zaczek', '+502-514-931-8777', 'TI'),
(242, 'Lotti Beckford', '+86-311-477-1087', 'TM'),
(243, 'Christy Cary', '+49-270-353-5030', 'TI'),
(244, 'Tiff Fitzackerley', '+86-355-964-0698', 'SI'),
(245, 'Glyn Langsdon', '+63-741-238-1506', 'TI'),
(246, 'Petronia Willcock', '+86-535-653-9265', 'IF'),
(247, 'Freedman Toppes', '+62-581-858-0991', 'TM'),
(248, 'Sheffy Serot', '+55-382-192-7364', 'IF'),
(249, 'Jonis Jacquemard', '+63-502-685-6446', 'SI'),
(250, 'Yorgos Raft', '+62-365-328-2669', 'TI'),
(251, 'Fanechka Ferrulli', '+237-247-476-1860', 'IF'),
(252, 'Rockie Dabernott', '+33-565-230-5105', 'IF'),
(253, 'Conrado Perocci', '+967-135-945-7813', 'TI'),
(254, 'Algernon Lebell', '+1-353-208-6147', 'TI'),
(255, 'Lucas Sneaker', '+505-107-427-1821', 'TM'),
(256, 'Beilul Dunkerley', '+242-305-830-5321', 'TI'),
(257, 'Vale Bellinger', '+62-310-525-8378', 'TI'),
(258, 'Audry Caush', '+351-813-589-0252', 'TM'),
(259, 'Gayler Wheldon', '+30-333-770-5296', 'TI'),
(260, 'Theodora Mallard', '+855-339-387-8715', 'IF'),
(261, 'Lucio Mival', '+63-169-551-7023', 'TI'),
(262, 'Michele Bradmore', '+86-926-504-3558', 'TI'),
(263, 'Sosanna Vala', '+62-141-474-9852', 'TM'),
(264, 'Cthrine Herculson', '+82-195-624-9380', 'IF'),
(265, 'Reggie Ginnane', '+351-340-177-3298', 'SI'),
(266, 'Modesta Bingell', '+7-445-261-2581', 'TI'),
(267, 'Bar Jimeno', '+57-934-600-0995', 'TI'),
(268, 'Tanney Bench', '+7-408-168-1128', 'TM'),
(269, 'Berenice MacPhaden', '+1-813-521-7766', 'TM'),
(270, 'Obadias Farnhill', '+86-262-579-8038', 'IF'),
(271, 'Arley aManger', '+53-979-234-4474', 'TM'),
(272, 'Sue Markson', '+86-100-990-5445', 'TI'),
(273, 'Harli Spilisy', '+351-499-981-8958', 'TI'),
(274, 'Mitchel Pallent', '+7-157-520-9668', 'TI'),
(275, 'Mina Fratczak', '+86-433-619-5893', 'TI'),
(276, 'Mureil Waddy', '+62-854-358-7519', 'IF'),
(277, 'Tailor Tearney', '+81-910-802-5462', 'TI'),
(278, 'Huntley Amerighi', '+48-667-979-1867', 'IF'),
(279, 'Vivianne Vondrys', '+380-227-342-3063', 'SI'),
(280, 'Andriana Menicomb', '+86-801-994-7307', 'SI'),
(281, 'Juditha Hailes', '+27-868-999-9257', 'TI'),
(282, 'Nollie Skunes', '+380-866-618-5201', 'IF'),
(283, 'Aldrich Darlington', '+33-342-188-9707', 'SI'),
(284, 'Lindsey Gomer', '+62-269-589-6151', 'IF'),
(285, 'Vilma Blencowe', '+62-504-682-4732', 'SI'),
(286, 'Tabby Dumbare', '+62-958-361-5401', 'TM'),
(287, 'Rodolphe Croley', '+389-237-760-2201', 'TI'),
(288, 'Angus Hailwood', '+598-927-156-2493', 'SI'),
(289, 'Esra Loosmore', '+54-190-917-6379', 'SI'),
(290, 'Lauralee Pillinger', '+63-808-549-3500', 'SI'),
(291, 'Cosme Carme', '+507-274-124-1998', 'TI'),
(292, 'Luz Olkowicz', '+64-121-782-9761', 'TM'),
(293, 'Bernadette Benini', '+7-336-564-7945', 'TM'),
(294, 'Una Gleadhell', '+63-943-593-6343', 'TM'),
(295, 'Hildagard Stooders', '+47-815-787-9682', 'SI'),
(296, 'Artie Reese', '+7-192-162-8490', 'SI'),
(297, 'Morlee Tolemache', '+55-366-495-7551', 'TI'),
(298, 'Inigo Hanway', '+242-320-886-2081', 'TM'),
(299, 'Monah Damsell', '+48-835-982-9439', 'IF'),
(300, 'Dennie MacCracken', '+351-109-714-7248', 'TM'),
(301, 'Dulcie MacAlpine', '+62-559-277-3823', 'SI'),
(302, 'Farly Fishley', '+1-202-353-1990', 'IF'),
(303, 'Joeann Keilty', '+86-901-757-0052', 'IF'),
(304, 'Alistair Libbe', '+7-457-196-1783', 'SI'),
(305, 'Peyter Amber', '+86-404-807-6968', 'SI'),
(306, 'Letitia Brogini', '+63-808-117-0073', 'TI'),
(307, 'Turner Giveen', '+351-829-494-1620', 'SI'),
(308, 'Dewain Mansell', '+358-157-466-3301', 'IF'),
(309, 'Sissy Louedey', '+237-113-162-5277', 'TM'),
(310, 'Giacopo Reinhardt', '+1-297-481-9413', 'IF'),
(311, 'Fonz Tomlett', '+33-117-951-1038', 'IF'),
(312, 'Almeta Duke', '+81-879-218-8618', 'TI'),
(313, 'Joli Dreng', '+48-105-434-5050', 'TM'),
(314, 'Kally Bimson', '+86-946-892-4163', 'IF'),
(315, 'Ruby Bater', '+505-182-158-8969', 'TI'),
(316, 'Haskell Boggis', '+52-965-186-3015', 'TI'),
(317, 'Helene Worley', '+92-989-484-5057', 'IF'),
(318, 'Vinnie Lambert', '+64-738-260-1577', 'SI'),
(319, 'Ebba Willshire', '+359-347-328-5357', 'SI'),
(320, 'Elia Ebsworth', '+358-141-828-1256', 'TM'),
(321, 'Brewer Slaney', '+98-744-731-5116', 'SI'),
(322, 'Myrtia Sisland', '+48-919-653-5475', 'SI'),
(323, 'Omero Feaveer', '+381-536-255-2560', 'IF'),
(324, 'Emmye Perago', '+62-603-255-0465', 'IF'),
(325, 'Erinn Dundendale', '+48-227-189-9313', 'TM'),
(326, 'Toddy Mulleary', '+86-572-488-9279', 'TM'),
(327, 'Ham Jenny', '+7-282-982-1538', 'TI'),
(328, 'Delphinia Bril', '+351-158-673-0087', 'TM'),
(329, 'Si Alvar', '+691-147-520-4452', 'IF'),
(330, 'Penny Layne', '+86-408-344-5991', 'IF'),
(331, 'Minnaminnie Lethieulier', '+225-814-341-4423', 'IF'),
(332, 'Lelah Holbury', '+86-849-731-1591', 'IF'),
(333, 'Martynne Cammell', '+62-293-990-7430', 'SI'),
(334, 'Maighdiln Lawley', '+261-638-253-8168', 'TI'),
(335, 'Doll Proudley', '+962-765-498-4330', 'TI'),
(336, 'Miquela Ochiltree', '+48-364-742-7126', 'SI'),
(337, 'Cesaro Sherrott', '+86-434-894-1604', 'TI'),
(338, 'Jodie Wantling', '+7-437-175-8747', 'SI'),
(339, 'Gusti Kurth', '+48-579-695-2496', 'IF'),
(340, 'Carley Dmisek', '+86-275-479-8964', 'TM'),
(341, 'Terrill Costa', '+33-341-493-9901', 'SI'),
(342, 'Zena Spratt', '+504-876-392-5963', 'TI'),
(343, 'Jaclyn Fipp', '+212-186-987-9866', 'IF'),
(344, 'Melisenda Goakes', '+54-994-518-5193', 'IF'),
(345, 'Packston Roughley', '+86-971-163-5547', 'SI'),
(346, 'Demeter Collerd', '+58-904-195-9590', 'IF'),
(347, 'Merle Alldridge', '+54-468-997-6480', 'TI'),
(348, 'Rosanne Habbert', '+351-802-600-6518', 'TM'),
(349, 'Daphene Naile', '+86-664-386-3417', 'SI'),
(350, 'Quent Lorenc', '+57-819-647-7354', 'SI'),
(351, 'Sallyanne Dyas', '+1-300-412-9856', 'TI'),
(352, 'Georas Jeaneau', '+57-132-869-9462', 'SI'),
(353, 'Cairistiona Stores', '+86-565-289-2294', 'SI'),
(354, 'Germana Yurenin', '+1-202-249-8714', 'SI'),
(355, 'Ottilie Potell', '+64-619-865-0606', 'IF'),
(356, 'Arch Forker', '+358-185-615-4988', 'SI'),
(357, 'Donaugh O\'Dogherty', '+226-717-668-9476', 'IF'),
(358, 'Blinny Cicullo', '+359-154-177-5680', 'TI'),
(359, 'Jobina Boud', '+86-863-877-8019', 'TI'),
(360, 'Augustina Town', '+351-491-124-4308', 'TM'),
(361, 'Benson Weatherburn', '+86-256-169-2843', 'SI'),
(362, 'Shana Scutter', '+86-916-353-2462', 'IF'),
(363, 'Gardy Speaks', '+33-931-478-3754', 'SI'),
(364, 'Jefferson Rheam', '+86-613-751-2977', 'IF'),
(365, 'Laural Blackmuir', '+351-712-993-7108', 'TM'),
(366, 'Boote Leffek', '+212-897-354-9938', 'SI'),
(367, 'Dominik Gynn', '+380-164-555-2865', 'TM'),
(368, 'Lizzy Butterfint', '+82-179-650-7454', 'SI'),
(369, 'Cassius Pickthorne', '+48-734-761-3564', 'TM'),
(370, 'Brandi Robilart', '+33-319-326-1859', 'TI'),
(371, 'Tyrus Tellenbrok', '+86-582-747-3120', 'IF'),
(372, 'Patty Smissen', '+62-852-865-2251', 'TI'),
(373, 'Catie Mole', '+55-141-526-5495', 'SI'),
(374, 'Whitman Farny', '+64-863-916-7381', 'SI'),
(375, 'Tomlin Fayre', '+33-621-843-1285', 'TI'),
(376, 'Joey Gaynor', '+46-625-889-8495', 'IF'),
(377, 'Dorris Kitcher', '+231-512-886-2540', 'TI'),
(378, 'Suzanne Battrum', '+351-141-533-3511', 'IF'),
(379, 'Hervey Danslow', '+506-822-609-6967', 'IF'),
(380, 'Haslett Tuffey', '+98-611-147-9817', 'TI'),
(381, 'Thane Aurelius', '+54-848-464-5166', 'TM'),
(382, 'Albrecht MacKeever', '+62-611-638-9323', 'TI'),
(383, 'Fleming Stollenbecker', '+86-262-859-6835', 'SI'),
(384, 'Merrel Seckom', '+46-258-987-2377', 'TI'),
(385, 'Allegra Brittle', '+62-763-371-5857', 'TM'),
(386, 'Sean Rohlfs', '+7-565-408-6169', 'TM'),
(387, 'Shandra Hardware', '+33-569-751-1706', 'TI'),
(388, 'Emelda Guihen', '+30-287-719-6254', 'TM'),
(389, 'Laurent McLagain', '+52-479-825-0282', 'TM'),
(390, 'Dorette Suff', '+62-464-157-3547', 'SI'),
(391, 'Lethia Lanceter', '+86-858-469-0025', 'TI'),
(392, 'Edward Chaunce', '+64-668-409-1682', 'SI'),
(393, 'Ignacius Ducket', '+220-734-872-7204', 'SI'),
(394, 'Nigel Selkirk', '+420-240-721-2499', 'IF'),
(395, 'Tammy Statter', '+33-666-270-1808', 'TI'),
(396, 'Ruy Cristofvao', '+380-637-919-4094', 'SI'),
(397, 'Ted Stendell', '+7-441-800-6210', 'TI'),
(398, 'Marji Luddy', '+51-744-525-2641', 'TM'),
(399, 'Alana Beggini', '+86-533-257-6902', 'SI'),
(400, 'Leonore Atterley', '+33-700-266-7512', 'IF'),
(401, 'Ivar Perigo', '+7-298-573-0701', 'TI'),
(402, 'Brod Krolik', '+86-286-120-6529', 'SI'),
(403, 'Paddy Brookfield', '+51-102-747-8783', 'TI'),
(404, 'Lucine Bester', '+62-265-726-4386', 'TI'),
(405, 'Pansy Flintoft', '+63-768-493-5718', 'TI'),
(406, 'Margaretta Prettyjohns', '+86-784-434-4081', 'IF'),
(407, 'Abigale Trude', '+54-351-597-6841', 'TM'),
(408, 'Carrissa Beevers', '+46-516-823-7949', 'SI'),
(409, 'Rebeca Signorelli', '+46-341-307-4911', 'TI'),
(410, 'Yvette Dutnall', '+86-379-999-5470', 'TI'),
(411, 'Denney Philliskirk', '+86-716-631-0680', 'TI'),
(412, 'Lyndsie O\'Crowley', '+351-963-885-7266', 'TI'),
(413, 'Chere Burnyeat', '+62-202-294-2249', 'TI'),
(414, 'Lillis O\'Currine', '+62-884-922-7436', 'TM'),
(415, 'Dorris Jennick', '+359-642-295-2212', 'TM'),
(416, 'Delphinia Masterton', '+86-813-929-8011', 'IF'),
(417, 'Terrijo Fairhurst', '+86-774-826-1025', 'IF'),
(418, 'Syd Meenan', '+86-247-264-1280', 'SI'),
(419, 'Agace Bubear', '+86-928-319-6233', 'TI'),
(420, 'Meryl Alvarez', '+46-444-312-8844', 'TM'),
(421, 'Genovera Myhan', '+62-108-952-1596', 'IF'),
(422, 'Lind Phythean', '+64-989-299-2827', 'TI'),
(423, 'Vita Holdren', '+48-695-262-6597', 'TM'),
(424, 'Gaultiero Chetter', '+63-289-410-8574', 'SI'),
(425, 'Gisele Baynes', '+62-781-494-3599', 'SI'),
(426, 'Eryn Colton', '+86-355-627-0986', 'TM'),
(427, 'Ruby Bocken', '+55-299-953-3502', 'IF'),
(428, 'Brier MacKenney', '+62-287-598-2607', 'TI'),
(429, 'Tiff Gwinn', '+375-924-305-3982', 'TM'),
(430, 'Zea Bollins', '+51-802-593-6354', 'TM'),
(431, 'Cleveland Childers', '+63-448-700-4172', 'SI'),
(432, 'Gustav Ibbetson', '+63-502-884-0940', 'TM'),
(433, 'Dorri Aizikovitz', '+86-364-559-8732', 'TI'),
(434, 'Perry Symington', '+48-788-223-7322', 'TI'),
(435, 'Kissiah Ourry', '+48-781-338-0917', 'IF'),
(436, 'Leisha Geertz', '+55-611-545-4558', 'TM'),
(437, 'Dawna Crufts', '+62-568-843-4668', 'TM'),
(438, 'Minor Afield', '+62-174-722-3425', 'SI'),
(439, 'Sallie Borkett', '+55-155-619-7263', 'TI'),
(440, 'Kelcie Olver', '+351-415-227-8778', 'SI'),
(441, 'Michele Tourner', '+86-576-317-4753', 'IF'),
(442, 'Tate Cornehl', '+48-932-410-5950', 'IF'),
(443, 'Nathalia Derrington', '+55-262-129-9862', 'TI'),
(444, 'Nannette Francklin', '+62-995-654-0403', 'IF'),
(445, 'Maxy Skelhorn', '+86-711-474-2759', 'SI'),
(446, 'Sherilyn Devine', '+55-969-489-7023', 'SI'),
(447, 'Etienne Sandy', '+7-855-356-9603', 'TI'),
(448, 'Bekki Marrows', '+86-645-789-6835', 'TM'),
(449, 'Datha Allery', '+86-551-621-2817', 'TM'),
(450, 'Fidelia Roddy', '+55-423-794-9222', 'SI'),
(451, 'Jennica Killingback', '+62-130-276-6786', 'TM'),
(452, 'Leda Reeday', '+62-119-492-6693', 'IF'),
(453, 'Katerina Porritt', '+84-848-490-5727', 'SI'),
(454, 'Rafferty Pucker', '+228-884-479-1225', 'SI'),
(455, 'Caldwell Rennicks', '+94-771-684-2999', 'SI'),
(456, 'Anselma Welsh', '+63-778-929-3161', 'TM'),
(457, 'Eve Floris', '+86-830-496-8712', 'SI'),
(458, 'Sascha Liddiatt', '+256-303-265-0628', 'TM'),
(459, 'Jackie Ilyasov', '+46-923-847-7359', 'IF'),
(460, 'Dorian Montfort', '+7-651-539-9068', 'TI'),
(461, 'Ivan Wasselin', '+55-100-637-8574', 'IF'),
(462, 'Karney Mapston', '+7-616-113-1856', 'TI'),
(463, 'Clarice Staddart', '+66-155-270-5687', 'TI'),
(464, 'Lucie Chavez', '+351-337-259-7113', 'SI'),
(465, 'Kelcie Rulf', '+57-770-307-2933', 'TM'),
(466, 'Base Batthew', '+54-743-119-7930', 'SI'),
(467, 'Wynn Sunderland', '+86-594-367-0678', 'TM'),
(468, 'Stephenie Dobbie', '+55-176-483-6726', 'IF'),
(469, 'Janith Carlile', '+255-619-812-8451', 'SI'),
(470, 'Dalila Kristoffersson', '+374-298-558-8928', 'TM'),
(471, 'Quintin Rand', '+52-696-224-2595', 'IF'),
(472, 'Philbert Scutcheon', '+1-898-489-9347', 'IF'),
(473, 'Tyrus Torrie', '+504-721-582-0043', 'TI'),
(474, 'Anthea Brodley', '+593-669-450-9230', 'TM'),
(475, 'Helena Dowty', '+63-627-226-4771', 'IF'),
(476, 'Torin Barbosa', '+60-268-602-8681', 'IF'),
(477, 'Diann Newark', '+33-935-618-6266', 'TM'),
(478, 'Dyan Wheldon', '+55-629-386-1391', 'IF'),
(479, 'Munmro Vasentsov', '+351-112-417-6115', 'TM'),
(480, 'Hersch Littley', '+992-873-794-1519', 'SI'),
(481, 'Araldo Tomblett', '+351-395-754-2033', 'SI'),
(482, 'Diena Gertz', '+62-933-330-3326', 'TM'),
(483, 'Falito Rickeard', '+504-501-551-5856', 'IF'),
(484, 'Ximenes Pulbrook', '+81-873-917-8522', 'TM'),
(485, 'Isidor Gebhard', '+62-262-745-7066', 'SI'),
(486, 'Aeriel Donnelly', '+46-109-928-5270', 'SI'),
(487, 'Nathalie Scotts', '+351-349-849-9871', 'SI'),
(488, 'Antony Oats', '+965-311-947-3469', 'IF'),
(489, 'Beulah Lafranconi', '+420-656-708-5623', 'TM'),
(490, 'Thornton Beart', '+86-500-275-1024', 'SI'),
(491, 'Pepillo Cockshott', '+370-467-662-7525', 'SI'),
(492, 'Henry Clamp', '+86-310-353-6820', 'SI'),
(493, 'Elsbeth Ambler', '+260-459-815-1181', 'IF'),
(494, 'Rubetta Perryman', '+251-867-726-9945', 'TI'),
(495, 'Hamilton Chudleigh', '+86-641-611-2784', 'IF'),
(496, 'Matteo Fattore', '+385-252-865-4276', 'IF'),
(497, 'Tuesday Sympson', '+52-887-481-1388', 'TM'),
(498, 'Lauri Clapp', '+30-539-677-1856', 'TM'),
(499, 'Ruddy Yelland', '+48-254-657-6993', 'TI'),
(500, 'Sigfrid Umbers', '+46-900-704-5327', 'TI'),
(501, 'Leland Deeny', '+46-806-408-6625', 'TI'),
(502, 'Lorrie Zywicki', '+225-835-430-9576', 'TI'),
(503, 'Thain Levene', '+86-747-590-2053', 'TM'),
(504, 'Mord Louder', '+502-685-580-7109', 'IF'),
(505, 'Velvet Canete', '+7-525-826-6742', 'TI'),
(506, 'Kingsley Yezafovich', '+355-158-325-5615', 'SI'),
(507, 'Travers Otridge', '+251-421-797-5172', 'SI'),
(508, 'Marjorie De Freyne', '+223-672-728-0443', 'TI'),
(509, 'Anthia Killen', '+7-159-806-0447', 'TM'),
(510, 'Park Benitti', '+86-517-201-2208', 'SI'),
(511, 'Nadiya Peeke-Vout', '+86-395-560-4816', 'SI'),
(512, 'Thomas Durnford', '+256-807-829-8826', 'SI'),
(513, 'Leonore Harsant', '+51-399-803-3516', 'TI'),
(514, 'Denna Duchenne', '+1-190-698-5061', 'IF'),
(515, 'Washington Grierson', '+46-728-797-5923', 'TI'),
(516, 'Cinnamon Wylie', '+7-605-114-5129', 'IF'),
(517, 'Lavena Vardy', '+971-717-413-9520', 'IF'),
(518, 'Rollins Ambrois', '+55-159-485-8476', 'SI'),
(519, 'Flory Fayerman', '+967-284-524-1450', 'IF'),
(520, 'Dominica Wingatt', '+63-460-781-7661', 'SI'),
(521, 'Gipsy Bourton', '+63-667-465-6657', 'TM'),
(522, 'Zackariah Puxley', '+46-569-295-7932', 'IF'),
(523, 'Corie Marini', '+86-213-697-6785', 'SI'),
(524, 'Dominga Westmore', '+351-983-375-4205', 'IF'),
(525, 'Lucian Gooder', '+62-227-665-5468', 'SI'),
(526, 'Gunilla Shiel', '+86-317-803-2811', 'TM'),
(527, 'Moria Esberger', '+351-610-398-8295', 'TM'),
(528, 'Gae Davitashvili', '+48-124-395-5671', 'TM'),
(529, 'Franzen Woodhams', '+55-605-637-5659', 'IF'),
(530, 'Alisha Rewan', '+1-521-853-6304', 'SI'),
(531, 'Zsazsa Lethby', '+57-196-314-8760', 'IF'),
(532, 'Cosette Henriksson', '+389-922-188-9102', 'SI'),
(533, 'Elisabetta Stoddart', '+92-507-736-3142', 'IF'),
(534, 'Wood Niaves', '+33-390-815-4356', 'TM'),
(535, 'Blanca Brotherheed', '+33-666-364-5358', 'IF'),
(536, 'Lilyan Cuttelar', '+48-657-903-3362', 'TI'),
(537, 'Anny McGonnell', '+351-631-768-1751', 'TM'),
(538, 'Janet Shimmin', '+57-562-317-4475', 'TM'),
(539, 'Velvet Deaton', '+389-593-327-9109', 'SI'),
(540, 'Rochell MacKeever', '+48-209-369-3972', 'SI'),
(541, 'Sayre Daniele', '+48-163-723-5104', 'SI'),
(542, 'Bethany Cree', '+357-897-590-0633', 'TM'),
(543, 'Anissa Beyn', '+355-854-420-7202', 'TI'),
(544, 'Meriel Cloney', '+48-654-915-5604', 'TM'),
(545, 'Garreth Elliston', '+86-582-299-8463', 'TI'),
(546, 'Suzanna Putnam', '+972-687-794-9548', 'SI'),
(547, 'Zachary Marchant', '+1-775-305-1736', 'IF'),
(548, 'Raimund Crayker', '+7-140-574-1592', 'SI'),
(549, 'Conney Martinie', '+57-592-767-7698', 'TI'),
(550, 'Renell Piken', '+62-756-825-9182', 'IF'),
(551, 'Audra Grodden', '+970-423-448-7529', 'TI'),
(552, 'Chalmers Kagan', '+86-748-726-8944', 'TM'),
(553, 'Sibbie Ivanenkov', '+970-689-973-7119', 'IF'),
(554, 'Jerald Holt', '+7-775-930-1177', 'TI'),
(555, 'Atlanta Withnall', '+62-595-654-6213', 'IF'),
(556, 'Corty Sliman', '+86-906-150-1571', 'TI'),
(557, 'Roth Huxstep', '+1-318-560-7571', 'TM'),
(558, 'Hertha Forbes', '+62-339-904-6571', 'IF'),
(559, 'Buddie Connow', '+1-707-804-0890', 'IF'),
(560, 'Wain Chartre', '+86-870-982-8133', 'TI'),
(561, 'El Luckie', '+27-811-626-5658', 'IF'),
(562, 'Zondra Heims', '+81-293-797-3848', 'IF'),
(563, 'Quentin Kelling', '+1-319-730-2628', 'TM'),
(564, 'Tilly Gully', '+94-908-404-5673', 'TI'),
(565, 'Shirlee Reggiani', '+420-625-649-2323', 'TI'),
(566, 'Reiko Liston', '+960-945-870-6928', 'IF'),
(567, 'Pauli Bellhanger', '+46-443-672-4613', 'TM'),
(568, 'Felicio Gyngell', '+84-896-458-5431', 'SI'),
(569, 'Derwin Veeler', '+86-207-210-6533', 'TM'),
(570, 'Leora Whissell', '+380-762-978-1128', 'TM'),
(571, 'Gladi Milius', '+62-756-180-6720', 'TM'),
(572, 'Heda Shepstone', '+94-849-598-8946', 'TI'),
(573, 'Maynord Varns', '+57-431-642-7236', 'TI'),
(574, 'Annabelle Waddington', '+48-893-541-9918', 'TM'),
(575, 'Fax Risley', '+46-961-251-2459', 'SI'),
(576, 'Moria McCuis', '+86-904-187-9346', 'SI'),
(577, 'Sallyanne Dike', '+46-869-635-6925', 'IF'),
(578, 'Annora Curnow', '+57-352-325-0471', 'SI'),
(579, 'Peta Cleynman', '+55-145-665-5313', 'IF'),
(580, 'Elset Ungerer', '+63-902-414-5086', 'TM'),
(581, 'Ondrea Dominetti', '+386-598-134-7081', 'TI'),
(582, 'Mildrid Collie', '+380-687-620-4761', 'SI'),
(583, 'Doralin Dibble', '+55-129-464-9343', 'IF'),
(584, 'Burch Pigot', '+375-603-628-0062', 'IF'),
(585, 'Boothe Sparey', '+86-410-957-5174', 'IF'),
(586, 'Zollie Denk', '+48-660-396-6292', 'SI'),
(587, 'Illa Ferminger', '+357-560-175-9869', 'SI'),
(588, 'Remus Greenman', '+54-595-896-7732', 'SI'),
(589, 'Rosetta Doughtery', '+46-882-740-2926', 'SI'),
(590, 'Ronny Carolan', '+48-976-408-8445', 'SI'),
(591, 'Arv Kleinber', '+57-801-169-0802', 'TM'),
(592, 'Pammie Nuscha', '+7-119-613-8973', 'IF'),
(593, 'Darryl Byford', '+1-407-724-7918', 'TM'),
(594, 'Lance Albers', '+62-168-738-8951', 'IF'),
(595, 'Bertine Davers', '+62-271-404-9959', 'SI'),
(596, 'Edeline Clewley', '+92-355-754-7496', 'TM'),
(597, 'Deina Wreak', '+55-316-372-5397', 'IF'),
(598, 'Danit Fleckno', '+86-945-498-9427', 'TM'),
(599, 'Luis Skerman', '+33-621-877-5807', 'TM'),
(600, 'Christie Waldren', '+34-725-166-5571', 'IF'),
(601, 'Laureen Crepel', '+86-498-405-5969', 'TM'),
(602, 'Jakob Albert', '+46-994-348-4391', 'SI'),
(603, 'Shirleen Dy', '+212-885-605-6370', 'SI'),
(604, 'Kurt Gillies', '+995-113-662-0666', 'SI'),
(605, 'Hercules Hannaway', '+86-293-124-7549', 'SI'),
(606, 'Willis Fildery', '+7-464-403-8937', 'IF'),
(607, 'Gabey Coulston', '+49-649-705-6742', 'TI'),
(608, 'Seumas Sansbury', '+7-845-774-7481', 'TM'),
(609, 'Bren Stolberger', '+382-743-172-5297', 'SI'),
(610, 'Jaimie Headland', '+49-406-968-2716', 'TM'),
(611, 'Doro Cockshott', '+86-756-879-1175', 'TI'),
(612, 'Bevvy Longland', '+86-817-672-9958', 'SI'),
(613, 'Renard Handscombe', '+63-164-310-0344', 'TI'),
(614, 'Drake Kabsch', '+1-531-306-8544', 'IF'),
(615, 'Dorthea Shearsby', '+86-365-450-0732', 'SI'),
(616, 'Northrup Cahani', '+593-194-603-1931', 'TI'),
(617, 'Venus De Bischof', '+63-615-543-5273', 'SI'),
(618, 'Gunter McAlinden', '+33-956-527-7226', 'TI'),
(619, 'Tod Warrender', '+351-386-356-7354', 'SI'),
(620, 'Jessamyn Wardall', '+86-977-433-1771', 'TM'),
(621, 'Goraud Simonot', '+63-549-522-0730', 'IF'),
(622, 'Ruddy McNee', '+62-753-613-7845', 'IF'),
(623, 'Ike Tuison', '+386-666-603-7799', 'SI'),
(624, 'Basia Fortnam', '+49-354-543-9843', 'TI'),
(625, 'Giorgio Euels', '+269-176-339-8791', 'IF'),
(626, 'Olly Lucus', '+262-361-270-4557', 'TM'),
(627, 'Tallie Bisley', '+62-344-924-8830', 'IF'),
(628, 'Rosalinda Meadows', '+1-585-191-4716', 'IF'),
(629, 'Borden Pyford', '+86-698-739-0214', 'TI'),
(630, 'August Littrik', '+255-420-647-3965', 'TM'),
(631, 'Theodore Quare', '+48-366-809-7054', 'IF'),
(632, 'Aarika Leatham', '+351-888-831-4506', 'TM'),
(633, 'Adamo Gumly', '+62-550-155-3754', 'SI'),
(634, 'Garry Viveash', '+49-173-197-7906', 'IF'),
(635, 'Elliott Barnsley', '+86-560-319-3714', 'TM'),
(636, 'Laurena Towsey', '+504-135-424-4055', 'IF'),
(637, 'Glennie Pantlin', '+63-605-219-0095', 'SI'),
(638, 'Carter Murrill', '+380-159-453-4393', 'TM'),
(639, 'Rosco Wesley', '+86-819-123-6273', 'SI'),
(640, 'Ondrea Tape', '+82-119-253-9773', 'TM'),
(641, 'Corby Bilsland', '+86-560-540-7537', 'TM'),
(642, 'Kim Walby', '+967-460-272-1047', 'TM'),
(643, 'Jinny O\'Kinedy', '+380-116-178-4965', 'SI'),
(644, 'Ive Winspare', '+1-212-331-8452', 'IF'),
(645, 'Carmen O\'Sesnane', '+62-829-488-0156', 'TM'),
(646, 'Foster Ropars', '+62-396-398-0697', 'SI'),
(647, 'Marji Eake', '+225-632-184-1083', 'TI'),
(648, 'Milli Beviss', '+62-881-342-8152', 'TM'),
(649, 'Cyndia Weems', '+381-608-287-7338', 'TI'),
(650, 'Niels Ibarra', '+62-995-286-8387', 'IF'),
(651, 'Allene MacLeod', '+420-755-470-3576', 'IF'),
(652, 'Roland Floodgate', '+372-158-460-2503', 'TI'),
(653, 'Binnie Kindred', '+1-650-599-2051', 'IF'),
(654, 'Truman Izakoff', '+373-509-177-3719', 'TI'),
(655, 'Seka Clarae', '+62-292-965-1550', 'TM'),
(656, 'Ursulina Northcott', '+48-145-199-7841', 'TI'),
(657, 'Jeanne Furzer', '+1-832-398-6568', 'IF'),
(658, 'Claretta McCleverty', '+86-102-958-1601', 'TM'),
(659, 'Deeanne Seagood', '+86-210-753-3673', 'SI'),
(660, 'Iain Welds', '+994-169-521-0272', 'SI'),
(661, 'Linn Fountain', '+86-544-286-8654', 'SI'),
(662, 'Paul McDuffy', '+63-209-910-9028', 'TM'),
(663, 'Kile MacKomb', '+62-401-821-0745', 'SI'),
(664, 'Charlean Haldane', '+1-215-926-1283', 'TM'),
(665, 'Alika Clemson', '+86-103-200-0541', 'IF'),
(666, 'Sileas Gravenor', '+261-562-315-0598', 'SI'),
(667, 'Johnath Laminman', '+237-243-393-8064', 'IF'),
(668, 'Merla Zipsell', '+95-883-612-8150', 'TM'),
(669, 'Garik Scrange', '+63-670-141-4282', 'TI'),
(670, 'Burton Tattersall', '+385-433-603-5842', 'TM'),
(671, 'Jobyna Tanman', '+48-150-791-5603', 'SI'),
(672, 'Terrance Targett', '+63-306-573-9590', 'TM'),
(673, 'Ingelbert oldey', '+82-381-521-6438', 'TI'),
(674, 'Michelle Piggens', '+63-174-756-3805', 'TI'),
(675, 'Julianne Raylton', '+33-273-596-7678', 'TI'),
(676, 'Mathe Kenright', '+62-615-149-3564', 'TM'),
(677, 'Yvonne Roggeman', '+57-830-756-9240', 'TM'),
(678, 'Jeniffer Habble', '+48-843-817-2523', 'TI'),
(679, 'Kalle Prinne', '+420-437-298-0446', 'TI'),
(680, 'Pansy Marsters', '+591-659-796-4432', 'IF'),
(681, 'Hilde Harwood', '+380-651-867-7741', 'TI'),
(682, 'Andra Pert', '+39-900-603-3308', 'TI'),
(683, 'Tybie Janikowski', '+420-420-378-2699', 'IF'),
(684, 'Velvet Ausello', '+20-855-441-2123', 'TI'),
(685, 'Zacharie Stonall', '+963-497-236-0635', 'TM'),
(686, 'Anatola Velti', '+7-493-393-2688', 'SI'),
(687, 'Wileen Dunstone', '+30-794-298-3376', 'TI'),
(688, 'Bartram Dysert', '+86-547-590-5025', 'TI'),
(689, 'Ella De la Yglesia', '+62-409-364-8621', 'TI'),
(690, 'Abrahan Adenet', '+33-886-607-1514', 'SI'),
(691, 'Hillery Allsopp', '+39-941-847-3958', 'IF'),
(692, 'Miner Gwilliams', '+62-102-549-9815', 'IF'),
(693, 'Natalee Kinningley', '+63-753-423-4729', 'IF'),
(694, 'Aaren Peddar', '+375-905-844-5627', 'TI'),
(695, 'Margaret Mc Ilwrick', '+30-203-703-1394', 'IF'),
(696, 'Federico Hacun', '+62-851-361-1635', 'IF'),
(697, 'Willi Redholls', '+994-444-488-2634', 'TI'),
(698, 'Homer Twidle', '+49-704-832-8927', 'IF'),
(699, 'Elva Pelerin', '+48-912-536-0901', 'IF'),
(700, 'Adamo Ingarfill', '+86-270-554-8849', 'SI'),
(701, 'Lammond Renhard', '+47-504-202-8410', 'IF'),
(702, 'Mario Getcliffe', '+86-158-186-8886', 'IF'),
(703, 'Megen Clapison', '+380-602-909-6075', 'TI'),
(704, 'Obediah Bidewell', '+55-170-819-9212', 'TM'),
(705, 'Svend Leed', '+62-763-104-5893', 'SI'),
(706, 'Binky Orrey', '+381-665-296-5402', 'IF'),
(707, 'Brandi Rowney', '+86-646-483-2076', 'SI'),
(708, 'Marta Reven', '+244-974-119-5567', 'TI'),
(709, 'Lion Freckingham', '+86-520-515-4538', 'IF'),
(710, 'Rennie Lehrmann', '+30-710-875-1905', 'TM'),
(711, 'Emmy Huske', '+33-903-777-1281', 'IF'),
(712, 'Griz Barkworth', '+86-987-108-1851', 'SI'),
(713, 'Curcio Vasilchenko', '+976-332-648-7183', 'SI'),
(714, 'Nickie Brumen', '+86-433-421-5496', 'IF'),
(715, 'Doris Myerscough', '+66-201-125-6643', 'TM'),
(716, 'Darlleen Seelbach', '+691-675-572-6483', 'TI'),
(717, 'Rollie Orwin', '+380-815-390-4201', 'IF'),
(718, 'Bea Woolveridge', '+48-931-843-8167', 'SI'),
(719, 'Godwin Toffaloni', '+86-145-472-4907', 'IF'),
(720, 'Delilah Dodsley', '+54-970-747-9304', 'IF'),
(721, 'Willabella Melato', '+212-113-102-0630', 'IF'),
(722, 'Margi Deary', '+63-140-139-7536', 'TM'),
(723, 'Brade Piddock', '+7-890-853-2417', 'TI'),
(724, 'Tally Medlen', '+86-254-629-9927', 'SI'),
(725, 'Chariot Chalmers', '+86-110-749-1061', 'SI'),
(726, 'Florri Busst', '+62-269-904-8784', 'TM'),
(727, 'Magnum Summerskill', '+359-863-544-7471', 'IF'),
(728, 'Rem Standingford', '+7-114-221-9706', 'SI'),
(729, 'Becka Brimley', '+55-180-917-6694', 'TM'),
(730, 'Althea Charlot', '+63-857-499-4416', 'IF'),
(731, 'Denna Castel', '+86-641-908-2434', 'IF'),
(732, 'Gerrard Taysbil', '+62-688-940-0009', 'SI'),
(733, 'Leda Norvel', '+46-368-419-2431', 'SI'),
(734, 'Carolee Kenningham', '+7-778-422-5118', 'IF'),
(735, 'Robby Rigden', '+62-214-723-7195', 'TI'),
(736, 'Ashley Plumridege', '+261-527-436-5473', 'SI'),
(737, 'Bendicty Macveigh', '+48-353-509-3621', 'SI'),
(738, 'Tiena Gladwell', '+55-246-861-3227', 'SI'),
(739, 'Roderigo Phizakarley', '+46-845-152-7421', 'TI'),
(740, 'Elissa Barnet', '+251-385-248-8215', 'TM'),
(741, 'Augusto Blades', '+46-498-745-7704', 'IF'),
(742, 'Myrlene Tarver', '+98-187-467-3525', 'TM'),
(743, 'Josee Belchamber', '+691-348-107-0588', 'TM'),
(744, 'Marius Rosenthaler', '+94-827-149-9695', 'IF'),
(745, 'Jessalyn Steinhammer', '+86-412-238-1328', 'IF'),
(746, 'Wynnie Lawey', '+86-178-139-9285', 'SI'),
(747, 'Loydie Cary', '+593-617-110-3113', 'SI'),
(748, 'Bronson Hearsey', '+81-207-531-4885', 'IF'),
(749, 'Harriet Gatheridge', '+48-788-928-4206', 'TM'),
(750, 'Giusto Shank', '+86-629-942-7466', 'TM'),
(751, 'Amitie Staig', '+62-363-713-2795', 'SI'),
(752, 'Camala Mordecai', '+7-733-535-8854', 'TI'),
(753, 'Mateo Dwight', '+967-751-784-0330', 'SI'),
(754, 'Shalna Breazeall', '+86-168-943-3942', 'IF'),
(755, 'Cass Bullingham', '+86-170-135-0160', 'TM'),
(756, 'Etta Cowderoy', '+351-699-402-4742', 'TM'),
(757, 'Cortney Rizziello', '+86-466-451-2659', 'IF'),
(758, 'Ichabod Stainer', '+48-418-339-3692', 'TM'),
(759, 'Ferdinand Victor', '+57-794-873-9669', 'TI'),
(760, 'Ephrayim Livzey', '+7-666-448-5522', 'IF'),
(761, 'Anne Plewman', '+1-405-263-5941', 'TI'),
(762, 'Perkin Rauprich', '+967-228-866-8976', 'TI'),
(763, 'Goldy Bellefant', '+351-280-400-2767', 'IF'),
(764, 'Ame Christoffels', '+380-285-979-1781', 'IF'),
(765, 'Corine Oret', '+86-872-941-3741', 'IF'),
(766, 'Von Abethell', '+229-112-827-3442', 'TI'),
(767, 'Bobina Cluley', '+7-945-136-1966', 'TI'),
(768, 'Scot Tonkes', '+46-585-433-4019', 'TM'),
(769, 'Shoshana Pentony', '+62-452-513-9030', 'TI'),
(770, 'Dalston Frodsham', '+86-983-812-4429', 'IF'),
(771, 'Grannie Abramsky', '+420-549-147-9777', 'TI'),
(772, 'Guenna Hatherleigh', '+86-704-709-8079', 'SI'),
(773, 'Aaron Jurn', '+386-111-854-7181', 'TM'),
(774, 'Gregorio Rothon', '+240-912-877-2535', 'IF'),
(775, 'Monty Petrillo', '+55-899-999-6141', 'TI'),
(776, 'Lawry Ghidetti', '+7-839-622-1611', 'IF'),
(777, 'Llywellyn Whitney', '+62-450-909-1595', 'IF'),
(778, 'Staci Toffetto', '+84-544-419-2734', 'TM'),
(779, 'Isa Karslake', '+976-782-735-5557', 'TM'),
(780, 'Patin Barlee', '+373-974-425-7600', 'SI'),
(781, 'Dorthy Haynesford', '+505-357-308-3231', 'TI'),
(782, 'Orsa Garrity', '+62-944-324-0179', 'TM'),
(783, 'Tabbie Scrannage', '+33-591-194-5447', 'TM'),
(784, 'Thia Lettuce', '+254-760-935-1596', 'IF'),
(785, 'Cyndia MacNaughton', '+86-116-317-4671', 'TI'),
(786, 'Feliza Townley', '+86-643-728-8060', 'TI'),
(787, 'Donnie Linck', '+82-177-650-4346', 'SI'),
(788, 'Northrop Lindner', '+86-967-753-4902', 'SI'),
(789, 'Sharline O\'Shevlan', '+66-501-807-9557', 'TI'),
(790, 'Pansy Drezzer', '+234-967-846-8605', 'TI'),
(791, 'Druci Baudain', '+34-947-988-4460', 'SI'),
(792, 'Luise Yankeev', '+1-251-278-8883', 'SI'),
(793, 'Nickie McCague', '+86-541-734-5058', 'TM'),
(794, 'Camellia Abel', '+62-415-876-5948', 'SI'),
(795, 'Cherey McWilliams', '+55-254-369-4802', 'TM'),
(796, 'Eleonore Tsar', '+86-349-609-9862', 'TI'),
(797, 'Faulkner Bocking', '+420-856-966-8653', 'TM'),
(798, 'Glenna Ruddom', '+970-407-666-9606', 'TI'),
(799, 'Lyell Gerrelt', '+48-957-803-8408', 'TM'),
(800, 'Gaile Andrat', '+507-870-257-4035', 'TM'),
(801, 'Yovonnda Goldie', '+1-948-678-0749', 'TI'),
(802, 'Erda Lorrie', '+86-592-508-6249', 'SI'),
(803, 'Iseabal Kingaby', '+967-932-666-3910', 'TM'),
(804, 'Bella Kleinmintz', '+33-998-211-1587', 'IF'),
(805, 'Damien Prise', '+33-542-869-3000', 'IF'),
(806, 'Willi Jolliss', '+62-813-988-1197', 'SI'),
(807, 'Carr Delamar', '+48-396-699-7729', 'TI'),
(808, 'Sasha Galiford', '+1-223-754-2304', 'IF'),
(809, 'Burty Groundwator', '+504-190-189-4769', 'SI'),
(810, 'Estell Clutterham', '+86-675-846-9507', 'IF'),
(811, 'Tamra Whitman', '+353-721-827-9057', 'IF'),
(812, 'Chad Carlisi', '+506-239-873-4979', 'TI'),
(813, 'Wynne Antonio', '+92-211-302-0401', 'TM'),
(814, 'Justus Kilpatrick', '+380-636-878-3556', 'TI'),
(815, 'Alexine Doyle', '+351-443-771-1792', 'TI'),
(816, 'Lyda Gainor', '+591-978-431-3685', 'SI'),
(817, 'Lyda Stockell', '+63-719-581-9835', 'IF'),
(818, 'Jarred Ouldcott', '+242-976-774-7872', 'TI'),
(819, 'Thomasine Wornum', '+62-588-365-7886', 'SI'),
(820, 'Paulette Szwandt', '+66-271-593-7147', 'TI'),
(821, 'Noni Spofforth', '+382-620-292-5361', 'TI'),
(822, 'Travis Freen', '+92-589-980-5492', 'TM'),
(823, 'Karolina Rennock', '+372-222-267-1938', 'SI'),
(824, 'Emilio Chuter', '+86-961-802-6541', 'TM'),
(825, 'Jo-anne Syce', '+86-840-915-0026', 'IF'),
(826, 'Sheryl Pere', '+33-758-659-7235', 'SI'),
(827, 'Ian McGannon', '+86-708-697-9907', 'TM'),
(828, 'Talya Pigford', '+1-531-237-1433', 'TI'),
(829, 'Jocelyne Atwill', '+381-390-244-6862', 'TM'),
(830, 'Wilmette Adami', '+57-103-455-3859', 'TM'),
(831, 'Coleen Hutt', '+7-542-458-6573', 'IF'),
(832, 'Millicent Ingley', '+63-545-991-0162', 'TI'),
(833, 'Celinda Bonsey', '+33-810-267-0211', 'IF'),
(834, 'Fidelio Quinnelly', '+1-965-537-0441', 'IF'),
(835, 'Flossy Cogzell', '+237-853-161-7793', 'SI'),
(836, 'Jenn Totton', '+86-220-874-6190', 'IF'),
(837, 'Tabbatha Sloss', '+86-440-609-8108', 'SI'),
(838, 'Libbie Cornbill', '+62-812-608-9932', 'IF'),
(839, 'Giraud Gallard', '+212-229-508-8755', 'SI'),
(840, 'Matty Maine', '+503-200-257-9915', 'TM'),
(841, 'Judas Melior', '+86-552-952-3391', 'TI'),
(842, 'Craggie Seacombe', '+1-812-631-3731', 'TM'),
(843, 'Bobby Mangion', '+86-232-899-1112', 'SI'),
(844, 'Shae Heasley', '+7-254-934-8157', 'TM'),
(845, 'Shawn Kett', '+86-741-931-5429', 'SI'),
(846, 'Debee Jerche', '+86-872-404-0993', 'TM'),
(847, 'Abbye Spinas', '+353-122-343-1315', 'TI'),
(848, 'Rodd Clericoates', '+27-147-915-4900', 'TI'),
(849, 'Joelly Bilham', '+234-929-386-1933', 'SI'),
(850, 'Rhona Tollfree', '+7-435-232-2036', 'TI'),
(851, 'Culver Zannuto', '+86-726-251-2251', 'IF'),
(852, 'Diandra Gillespey', '+48-579-512-8356', 'TM'),
(853, 'Janeczka Penberthy', '+55-440-967-0973', 'SI'),
(854, 'Karolina Ciottoi', '+234-686-229-8696', 'IF'),
(855, 'Willy Densumbe', '+86-640-766-1556', 'SI'),
(856, 'Caesar Tolle', '+351-736-266-2246', 'TI'),
(857, 'Jonis Simm', '+86-850-625-1235', 'TM'),
(858, 'Angie Scipsey', '+86-343-771-4212', 'TI'),
(859, 'Carla Artus', '+386-485-344-7277', 'TM'),
(860, 'Izabel Riquet', '+46-764-549-6287', 'IF'),
(861, 'Gustav Jack', '+62-897-516-8069', 'IF'),
(862, 'Fara Cressey', '+385-367-977-0532', 'TI'),
(863, 'Farly McQuade', '+86-323-726-3825', 'TI'),
(864, 'Parker Gunny', '+82-407-250-4186', 'TM'),
(865, 'Esmaria Burk', '+62-448-602-0179', 'TM'),
(866, 'Philly Fincken', '+81-754-384-7860', 'SI'),
(867, 'Sherwynd Tisor', '+63-760-288-9382', 'IF'),
(868, 'Gerry Spearett', '+358-792-505-3897', 'IF'),
(869, 'Brigit O\'Caherny', '+351-595-553-1737', 'SI'),
(870, 'Ame Latore', '+7-488-491-0893', 'IF'),
(871, 'Alain Attow', '+234-839-535-1214', 'TM'),
(872, 'Ninetta Courtliff', '+1-319-465-2954', 'IF'),
(873, 'Abby Kemery', '+33-109-770-7861', 'TI'),
(874, 'Minor Orrow', '+856-148-765-7995', 'SI'),
(875, 'Madelena Brandt', '+57-331-259-7689', 'TM'),
(876, 'Eb Chastenet', '+7-477-278-6675', 'SI'),
(877, 'Reade Towll', '+86-345-462-2565', 'TM'),
(878, 'Gwenore Oxterby', '+372-611-524-2134', 'TM'),
(879, 'Tait Duesbury', '+55-669-245-6878', 'IF'),
(880, 'Lory Hanington', '+963-792-750-6914', 'TI'),
(881, 'Berry Brafferton', '+30-855-788-9084', 'TM'),
(882, 'Raimund Lubman', '+7-609-673-0268', 'TI'),
(883, 'Hermina Flounders', '+86-745-745-3915', 'IF'),
(884, 'Dottie Abrahm', '+81-158-257-3146', 'IF'),
(885, 'Iris Ralfe', '+385-771-379-9802', 'TI'),
(886, 'Karly Simmgen', '+86-859-657-1561', 'TI'),
(887, 'George Fawlkes', '+351-743-848-9075', 'TI'),
(888, 'Sergeant Ranyelld', '+36-683-202-5363', 'TM'),
(889, 'Christean Jansey', '+62-598-675-3110', 'TI'),
(890, 'Gerty Fosher', '+27-765-294-8725', 'SI'),
(891, 'Eal Rylands', '+86-452-302-4383', 'IF'),
(892, 'Brig Ossulton', '+351-108-221-4061', 'SI'),
(893, 'Ransom Tavener', '+380-764-405-1301', 'TM'),
(894, 'Artemis Keener', '+509-474-141-0961', 'SI'),
(895, 'Horatia Glyne', '+57-858-685-6601', 'SI'),
(896, 'Wallie Fissenden', '+86-828-392-6180', 'TI'),
(897, 'Catherin Mebius', '+63-111-680-7586', 'SI'),
(898, 'Gail Scotson', '+970-115-598-1178', 'TM'),
(899, 'Stephana Slucock', '+62-923-611-4882', 'SI'),
(900, 'Audre Ville', '+52-399-798-1163', 'TI'),
(901, 'Leonie Hurdidge', '+61-167-483-9633', 'TI'),
(902, 'Rodd Blancowe', '+504-252-582-2398', 'TM'),
(903, 'Maye Jennins', '+48-493-762-0181', 'IF'),
(904, 'Jeanette Tudball', '+62-440-486-2180', 'SI'),
(905, 'Hal Margram', '+62-474-859-6573', 'TI'),
(906, 'Kippie Pickersgill', '+30-605-482-2901', 'TM'),
(907, 'Casar Lodo', '+54-726-456-0899', 'IF'),
(908, 'Lilian Pittendreigh', '+86-329-956-3440', 'IF'),
(909, 'Yoshi Yate', '+33-833-431-8439', 'SI'),
(910, 'Kirbie Cowx', '+63-702-141-7143', 'SI'),
(911, 'Kaspar Padefield', '+1-625-305-3483', 'IF'),
(912, 'Sammy Steer', '+218-861-548-6845', 'IF'),
(913, 'Cristian Masdon', '+31-837-931-3506', 'TI'),
(914, 'Ambrosi Southcoat', '+86-426-139-3557', 'TI'),
(915, 'Sandi Billie', '+55-736-487-9404', 'TI'),
(916, 'Bendite Delafont', '+591-194-172-7302', 'TM'),
(917, 'Sid Murden', '+380-495-254-4015', 'TI'),
(918, 'Kort Freeburn', '+86-884-999-6065', 'IF'),
(919, 'Gisela Commucci', '+63-466-967-4634', 'TI'),
(920, 'Corrie Heims', '+46-259-281-1199', 'TM'),
(921, 'Blair Andrys', '+1-628-521-8026', 'TM'),
(922, 'Honey Indge', '+1-405-611-5269', 'TI'),
(923, 'Ollie Ledekker', '+86-785-191-3876', 'IF'),
(924, 'Godiva Marzelle', '+1-421-433-2109', 'SI'),
(925, 'Duky Sare', '+86-945-716-3578', 'SI'),
(926, 'Lavina Maylour', '+380-282-398-4403', 'SI'),
(927, 'Lee Kirkman', '+66-484-949-3013', 'IF'),
(928, 'Happy O\'Bradane', '+234-639-653-3286', 'TM'),
(929, 'Camile Seniour', '+63-143-643-1158', 'TI'),
(930, 'Juliane Passingham', '+374-142-237-8799', 'IF'),
(931, 'Lesley Spencley', '+230-710-880-3069', 'TM'),
(932, 'Virginie O\' Gara', '+86-364-119-1738', 'SI'),
(933, 'Tannie Dassindale', '+7-211-510-9716', 'TM'),
(934, 'Emmalee Craik', '+86-680-436-6205', 'TM'),
(935, 'Hobie Holttom', '+1-446-628-7300', 'TM'),
(936, 'Knox McSweeney', '+86-531-120-3456', 'SI'),
(937, 'Myron Gheraldi', '+86-316-272-9042', 'IF'),
(938, 'Jeramey Messitt', '+54-501-922-3731', 'TI'),
(939, 'Marigold Eisikowitch', '+351-480-815-3838', 'TI'),
(940, 'Auroora McOnie', '+267-772-605-3816', 'TI'),
(941, 'Obed Alleyn', '+86-877-356-1686', 'SI'),
(942, 'Viole Troughton', '+81-942-969-5058', 'TI'),
(943, 'Kim Casserley', '+507-233-643-2499', 'TI'),
(944, 'Briney O\'Giany', '+86-354-756-1614', 'TM'),
(945, 'Carolynn De Ortega', '+381-848-258-3113', 'IF'),
(946, 'Correy Boorn', '+504-641-518-3464', 'IF'),
(947, 'Happy Jilliss', '+86-934-852-5709', 'SI'),
(948, 'Nelson Bram', '+355-604-231-9922', 'TM'),
(949, 'Meade Bloxsom', '+7-616-908-2132', 'SI'),
(950, 'Kathrine Hutcheson', '+62-652-541-6417', 'IF'),
(951, 'Duncan Joder', '+51-969-403-9371', 'SI'),
(952, 'Ines Yoselevitch', '+66-416-556-9127', 'TM'),
(953, 'Ash Durnan', '+967-955-544-4131', 'TI'),
(954, 'Glendon Dutch', '+7-367-652-9973', 'IF'),
(955, 'Ree De Simoni', '+86-647-721-5427', 'TI'),
(956, 'Blondell McNeilly', '+380-345-779-5648', 'IF'),
(957, 'Lorelle Densun', '+355-851-647-2092', 'TM'),
(958, 'Benito Laudham', '+62-649-180-2322', 'TM'),
(959, 'D\'arcy Romi', '+33-204-447-8133', 'SI'),
(960, 'Kevin McIllrick', '+55-159-137-2960', 'IF'),
(961, 'Beatrice Perrottet', '+86-137-438-9209', 'SI'),
(962, 'Kirby Thaim', '+216-456-699-8842', 'IF'),
(963, 'Marissa Ghioni', '+86-596-392-6154', 'IF'),
(964, 'Krishnah Whelpdale', '+86-617-546-0674', 'SI'),
(965, 'Yorker Pittam', '+420-955-246-0362', 'TM'),
(966, 'Constantine Wasselin', '+86-220-713-8317', 'TI'),
(967, 'Rafaelita Janodet', '+880-293-378-7690', 'TI'),
(968, 'Dorian Male', '+46-700-550-2879', 'TM'),
(969, 'Shaine Saberton', '+86-556-719-7000', 'SI'),
(970, 'Carolus Lettson', '+62-535-935-9781', 'SI'),
(971, 'Ezequiel Loxdale', '+998-235-260-8651', 'TM'),
(972, 'Roger Dome', '+44-113-747-4303', 'IF'),
(973, 'Hewie Lawler', '+62-743-451-1180', 'TI'),
(974, 'Derry Gillett', '+7-450-479-8735', 'SI'),
(975, 'Tyson Balchen', '+55-768-619-4495', 'TI'),
(976, 'Andreas Gallichan', '+66-865-351-7235', 'TI'),
(977, 'Rafa Jillions', '+351-743-622-0414', 'TM'),
(978, 'Alicea Ryrie', '+234-641-157-0485', 'TI'),
(979, 'Paddy Chastenet', '+55-387-843-4980', 'IF'),
(980, 'Letty Laste', '+94-488-307-0973', 'TI'),
(981, 'Rockey Loude', '+62-907-735-3321', 'IF'),
(982, 'Rorie Rioch', '+1-316-249-2325', 'IF'),
(983, 'Cthrine Terry', '+212-104-196-4268', 'TM'),
(984, 'Nick Cottill', '+63-980-416-6115', 'SI'),
(985, 'Prudy Boughtflower', '+27-950-376-8451', 'IF'),
(986, 'Kevyn Chmarny', '+55-705-581-0071', 'TM'),
(987, 'Read Kesteven', '+62-127-533-6724', 'IF'),
(988, 'Livvie Deakes', '+1-802-807-5583', 'TM'),
(989, 'Jory Aveline', '+86-578-808-9193', 'IF'),
(990, 'Jameson Twohig', '+33-637-486-3376', 'SI'),
(991, 'Gabriele Sundin', '+86-620-933-6564', 'IF'),
(992, 'Fredelia Kelledy', '+63-700-756-6476', 'SI'),
(993, 'Sallyanne Scutchin', '+86-762-714-5079', 'TI'),
(994, 'Carline Tancock', '+86-154-631-6274', 'TI'),
(995, 'Hi Severwright', '+380-976-290-7144', 'TM'),
(996, 'Florie Goford', '+86-445-226-1059', 'IF'),
(997, 'Miguelita Pyford', '+86-333-904-7202', 'TI'),
(998, 'Agna Welbeck', '+53-328-823-6279', 'TI'),
(999, 'Carey Tattam', '+375-871-830-0638', 'TI'),
(1000, 'Cordelia Elford', '+48-945-560-7715', 'IF');
-- --------------------------------------------------------
--
-- Table structure for table `periode`
--
CREATE TABLE `periode` (
`periode` int(11) NOT NULL,
`tanggal_open_daftar` date DEFAULT NULL,
`tanggal_close_daftar` date DEFAULT NULL,
`tanggal_input_nilai` date DEFAULT NULL,
`tanggal_tutup_nilai` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
-- --------------------------------------------------------
--
-- Table structure for table `prodi`
--
CREATE TABLE `prodi` (
`KodeProdi` varchar(45) NOT NULL,
`NamaProdi` varchar(45) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--
-- Indexes for dumped tables
--
--
-- Indexes for table `desa`
--
ALTER TABLE `desa`
ADD PRIMARY KEY (`idDesa`),
ADD KEY `fk_DESA_KECAMATAN_idx` (`idKecamatan`);
--
-- Indexes for table `kecamatan`
--
ALTER TABLE `kecamatan`
ADD PRIMARY KEY (`idKecamatan`);
--
-- Indexes for table `kelompok_kkn`
--
ALTER TABLE `kelompok_kkn`
ADD PRIMARY KEY (`idKELOMPOK_KKN`),
ADD UNIQUE KEY `periode_periode_UNIQUE` (`periode_periode`),
ADD UNIQUE KEY `DESA_idDesa_UNIQUE` (`DESA_idDesa`),
ADD KEY `fk_KELOMPOK_KKN_DESA1_idx` (`DESA_idDesa`);
--
-- Indexes for table `mahasiswa`
--
ALTER TABLE `mahasiswa`
ADD PRIMARY KEY (`nim`),
ADD KEY `fk_MAHASISWA_PRODI1_idx` (`PRODI_KodeProdi`);
--
-- Indexes for table `periode`
--
ALTER TABLE `periode`
ADD PRIMARY KEY (`periode`);
--
-- Indexes for table `prodi`
--
ALTER TABLE `prodi`
ADD PRIMARY KEY (`KodeProdi`);
--
-- AUTO_INCREMENT for dumped tables
--
--
-- AUTO_INCREMENT for table `desa`
--
ALTER TABLE `desa`
MODIFY `idDesa` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `kecamatan`
--
ALTER TABLE `kecamatan`
MODIFY `idKecamatan` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `kelompok_kkn`
--
ALTER TABLE `kelompok_kkn`
MODIFY `idKELOMPOK_KKN` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `mahasiswa`
--
ALTER TABLE `mahasiswa`
MODIFY `nim` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1001;
--
-- AUTO_INCREMENT for table `periode`
--
ALTER TABLE `periode`
MODIFY `periode` int(11) NOT NULL AUTO_INCREMENT;
--
-- Constraints for dumped tables
--
--
-- Constraints for table `desa`
--
ALTER TABLE `desa`
ADD CONSTRAINT `fk_DESA_KECAMATAN` FOREIGN KEY (`idKecamatan`) REFERENCES `kecamatan` (`idKecamatan`) ON DELETE NO ACTION ON UPDATE NO ACTION;
--
-- Constraints for table `kelompok_kkn`
--
ALTER TABLE `kelompok_kkn`
ADD CONSTRAINT `fk_KELOMPOK_KKN_DESA1` FOREIGN KEY (`DESA_idDesa`) REFERENCES `desa` (`idDesa`) ON DELETE NO ACTION ON UPDATE NO ACTION,
ADD CONSTRAINT `fk_KELOMPOK_KKN_periode` FOREIGN KEY (`periode_periode`) REFERENCES `periode` (`periode`) ON DELETE NO ACTION ON UPDATE NO ACTION;
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 */;
FILE SQL
Komentar
Posting Komentar