-- phpMyAdmin SQL Dump
-- version 3.5.7
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Oct 01, 2014 at 11:35 AM
-- Server version: 5.5.37-log
-- PHP Version: 5.3.23

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
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 utf8 */;

--
-- Database: `pijus_liogio1`
--

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

--
-- Table structure for table `Abonentas`
--

CREATE TABLE IF NOT EXISTS `Abonentas` (
  `abonentoID` int(11) NOT NULL AUTO_INCREMENT,
  `asmensID` int(11) NOT NULL,
  `planoID` int(11) NOT NULL,
  `papildomoInternetoPlanoID` int(11) DEFAULT NULL,
  `numeris` char(10) NOT NULL,
  `sutartiesPradzia` datetime NOT NULL,
  `sutartiesPabaiga` datetime DEFAULT NULL,
  PRIMARY KEY (`abonentoID`),
  KEY `asmensID` (`asmensID`),
  KEY `planoID` (`planoID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `Asmuo`
--

CREATE TABLE IF NOT EXISTS `Asmuo` (
  `asmensID` int(11) NOT NULL AUTO_INCREMENT,
  `miestoID` int(11) NOT NULL,
  `vardas` varchar(25) NOT NULL,
  `pavarde` varchar(20) NOT NULL,
  PRIMARY KEY (`asmensID`),
  KEY `miestoID` (`miestoID`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1805 ;

--
-- Dumping data for table `Asmuo`
--

INSERT INTO `Asmuo` (`asmensID`, `miestoID`, `vardas`, `pavarde`) VALUES
(1, 4, 'Hank', 'Aaron'),
(2, 90, 'Frank', 'Abagnale'),
(3, 90, 'Edward', 'Abbey'),
(4, 24, 'Reuben', 'Abel'),
(5, 24, 'Hal', 'Abelson'),
(6, 24, 'James', 'Abourezk'),
(7, 24, 'Creighton', 'Abrams'),
(8, 61, 'Jane', 'Ace'),
(9, 61, 'John', 'Acton'),
(10, 61, 'Abigail', 'Adams'),
(11, 61, 'Douglas', 'Adams'),
(12, 44, 'Henry', 'Adams'),
(13, 44, 'John', 'Adams'),
(14, 44, 'John Quincy', 'Adams'),
(15, 81, 'Samuel', 'Adams'),
(16, 81, 'Scott', 'Adams'),
(17, 81, 'Jane', 'Addams'),
(18, 81, 'Joseph', 'Addison'),
(19, 81, 'Theodor', 'Adorno'),
(20, 64, 'Alfred', 'Adler'),
(21, 64, 'Ben', 'Affleck'),
(22, 64, 'Keiko', 'Agena'),
(23, 64, 'Spiro', 'Agnew'),
(24, 101, 'Eden', 'Ahbez'),
(25, 101, 'Bertie', 'Ahern'),
(26, 101, 'James', 'Ah Koy'),
(27, 101, 'Clay', 'Aiken'),
(28, 101, 'Conrad', 'Aiken'),
(29, 35, 'Peter Jasper', 'Akinola'),
(30, 35, 'Jessica', 'Alba'),
(31, 35, 'Leone Battista', 'Alberti'),
(32, 18, 'Mitch', 'Albom'),
(33, 18, 'Louisa May', 'Alcott'),
(34, 18, 'Brian', 'Aldiss'),
(35, 18, 'Sherman', 'Alexie'),
(36, 18, 'Muqtada', 'al-Sadr'),
(37, 55, 'Muhammed Saeed', 'al-Sahaf'),
(38, 55, 'Hannes', 'Alfven'),
(39, 55, 'Buzz', 'Aldrin'),
(40, 55, 'Muhammad', 'Ali'),
(41, 55, 'Tariq', 'Ali'),
(42, 38, 'W. C.', 'Allee'),
(43, 38, 'Agnes', 'Allen'),
(44, 38, 'Fred', 'Allen'),
(45, 38, 'James', 'Allen'),
(46, 38, 'Steve', 'Allen'),
(47, 38, 'Woody', 'Allen'),
(48, 75, 'Alphonse', 'Allais'),
(49, 75, 'Aaron', 'Allston'),
(50, 75, 'Rolim', 'Amaro'),
(51, 75, 'Barbara', 'Amiel'),
(52, 75, 'Martin', 'Amis'),
(53, 75, 'Tori', 'Amos'),
(54, 9, 'Hans Christian', 'Andersen'),
(55, 9, 'Beth', 'Anderson'),
(56, 9, 'Sparky', 'Anderson'),
(57, 9, 'Aiven', 'Andrians'),
(58, 9, 'Ivo', 'Andric'),
(59, 96, 'Norman', 'Angell'),
(60, 96, 'Maya', 'Angelou'),
(61, 96, 'Piers', 'Anthony'),
(62, 96, 'Susan B.', 'Anthony'),
(63, 96, 'Laura', 'Antoniou'),
(64, 30, 'António Lobo', 'Antunes'),
(65, 30, 'Fiona', 'Apple'),
(66, 30, 'Thomas', 'Aquinas'),
(67, 30, 'Yasser', 'Arafat'),
(68, 30, 'Tom', 'Araya'),
(69, 30, 'John', 'Arbuthnot'),
(70, 13, 'Edwin', 'Armstrong'),
(71, 13, 'Louis', 'Armstrong'),
(72, 13, 'Neil', 'Armstrong'),
(73, 13, 'Hans', 'Arp'),
(74, 13, 'Alp', 'Arslan'),
(75, 50, 'Roger', 'Ascham'),
(76, 50, 'Arthur', 'Ashe'),
(77, 50, 'Baruch', 'Ashlag'),
(78, 50, 'Yehuda', 'Ashlag'),
(79, 50, 'Isaac', 'Asimov'),
(80, 50, 'Jacques', 'Attali'),
(81, 87, 'Mustafa Kemal', 'Atatürk'),
(82, 87, 'Margaret', 'Atwood'),
(83, 87, 'Wystan Hugh', 'Auden'),
(84, 87, 'Derek R.', 'Audette'),
(85, 87, 'Norman Ralph', 'Augustine'),
(86, 87, 'Jane', 'Austen'),
(87, 70, 'Alfred', 'Austin'),
(88, 70, 'J. L.', 'Austin'),
(89, 70, 'Stone Cold Steve', 'Austin'),
(90, 70, 'Meher', 'Baba'),
(91, 70, 'Tupeni', 'Baba'),
(92, 4, 'Charles', 'Babbage'),
(93, 4, 'Milton', 'Babbitt'),
(94, 4, 'Andrew', 'Bacevich'),
(95, 4, 'Richard', 'Bach'),
(96, 4, 'Gaston', 'Bachelard'),
(97, 4, 'Roselyne', 'Bachelot'),
(98, 90, 'Francis', 'Bacon'),
(99, 90, 'David', 'Baddiel'),
(100, 90, 'Sir Robert', 'Baden-Powell'),
(101, 90, 'Alain', 'Badiou'),
(102, 90, 'Michael', 'Badnarik'),
(103, 24, 'Joan', 'Baez'),
(104, 24, 'Walter', 'Bagehot'),
(105, 24, 'Philip James', 'Bailey'),
(106, 24, 'Bruce', 'Baillie'),
(107, 24, 'Frank', 'Bainimarama'),
(108, 24, 'Jack', 'Baker'),
(109, 61, 'Russell', 'Baker'),
(110, 61, 'Marjaney', 'Bakhtiari'),
(111, 61, 'Mikhail', 'Bakunin'),
(112, 61, 'Hugo', 'Ball'),
(113, 61, 'Steve', 'Ballmer'),
(114, 44, 'Honoré de', 'Balzac'),
(115, 44, 'Anne', 'Bancroft'),
(116, 44, 'Lester', 'Bangs'),
(117, 44, 'Devendra', 'Banhart'),
(118, 44, 'Ernie', 'Banks'),
(119, 44, 'Robert', 'Banks'),
(120, 44, 'Tony', 'Banks'),
(121, 81, 'Anna Letitia', 'Barbauld'),
(122, 81, 'William', 'Barclay'),
(123, 81, 'Clive', 'Barker'),
(124, 81, 'Charles', 'Barkley'),
(125, 81, 'John Perry', 'Barlow'),
(126, 64, 'Jack', 'Barnes'),
(127, 64, 'Julian', 'Barnes'),
(128, 64, 'J. M.', 'Barrie'),
(129, 64, 'Dave', 'Barry'),
(130, 64, 'Marion', 'Barry'),
(131, 64, 'Thomas V.', 'Bartholin'),
(132, 101, 'Bernard', 'Baruch'),
(133, 101, 'Heinz', 'Barwich'),
(134, 101, 'Frédéric', 'Bastiat'),
(135, 101, 'Charlie', 'Batch'),
(136, 101, 'Andy', 'Bathgate'),
(137, 101, 'Charles', 'Baudelaire'),
(138, 101, 'L. Frank', 'Baum'),
(139, 35, 'Timoci', 'Bavadra'),
(140, 35, 'Thomas Haynes', 'Bayly'),
(141, 35, 'André', 'Bazin'),
(142, 35, 'Roy', 'Bean'),
(143, 35, 'Charles A.', 'Beard'),
(144, 18, 'Glenn', 'Beck'),
(145, 18, 'Carl', 'Becker'),
(146, 18, 'Samuel', 'Beckett'),
(147, 18, 'Mick', 'Beddoes'),
(148, 18, 'Henry Ward', 'Beecher'),
(149, 55, 'Ludwig van', 'Beethoven'),
(150, 55, 'Menachem', 'Begin'),
(151, 55, 'Alexander Graham', 'Bell'),
(152, 55, 'Hilaire', 'Belloc'),
(153, 55, 'Saul', 'Bellow'),
(154, 75, 'Robert', 'Benchley'),
(155, 75, 'Peter', 'Benenson'),
(156, 75, 'David', 'Ben-Gurion'),
(157, 75, 'Walter', 'Benjamin'),
(158, 75, 'Tony', 'Benn'),
(159, 9, 'William Andrew Cicil', 'Bennett'),
(160, 9, 'Chester', 'Bennington'),
(161, 9, 'Leana', 'Benson'),
(162, 9, 'Silas', 'Bent'),
(163, 9, 'Lloyd', 'Bentsen'),
(164, 9, 'Edward V.', 'Berard'),
(165, 95, 'Ric', 'Berger'),
(166, 95, 'George E.', 'Bergman'),
(167, 95, 'Ingmar', 'Bergman'),
(168, 95, 'Luciano', 'Berio'),
(169, 95, 'Cyrano de', 'Bergerac'),
(170, 29, 'Milton', 'Berle'),
(171, 12, 'Irving', 'Berlin'),
(172, 12, 'Eric', 'Berne'),
(173, 12, 'Sandra', 'Bernhard'),
(174, 12, 'Yogi', 'Berra'),
(175, 12, 'Halle', 'Berry'),
(176, 49, 'Wendell', 'Berry'),
(177, 49, 'Erin', 'Bethea'),
(178, 49, 'Aneurin', 'Bevan'),
(179, 49, 'Ken', 'Bevel'),
(180, 49, 'Princess Elizabeth', 'Bibesco'),
(181, 86, 'Joseph', 'Biden'),
(182, 86, 'Ambrose', 'Bierce'),
(183, 86, 'Steve', 'Biko'),
(184, 86, 'Josh', 'Billings'),
(185, 86, 'Frank', 'Biondo'),
(186, 86, 'Augustine', 'Birrell'),
(187, 69, 'Robert', 'Blair'),
(188, 69, 'Tony', 'Blair'),
(189, 69, 'William', 'Blake'),
(190, 69, 'Art', 'Blakey'),
(191, 69, 'Jolene', 'Blalock'),
(192, 69, 'Mel', 'Blanc'),
(193, 3, 'Raymond', 'Blanc'),
(194, 3, 'Cate', 'Blanchett'),
(195, 3, 'Hans', 'Blix'),
(196, 3, 'Rebecca', 'Blood'),
(197, 3, 'Ancius', 'Boethius'),
(198, 3, 'Neil', 'Bogart'),
(199, 3, 'David', 'Bohm'),
(200, 89, 'Niels', 'Bohr'),
(201, 89, 'Nicholas', 'Boileau-Despreaux'),
(202, 89, 'Ratu Ovini', 'Bokini'),
(203, 89, 'Roberto', 'Bolano'),
(204, 89, 'Simón', 'Bol?var'),
(205, 23, 'Erma', 'Bombeck'),
(206, 23, 'Napoleon', 'Bonaparte'),
(207, 23, 'Dietrich', 'Bonhoeffer'),
(208, 23, 'Elena', 'Bonner'),
(209, 23, 'Louis E.', 'Boone'),
(210, 23, 'Daniel J.', 'Boorstin'),
(211, 60, 'William', 'Booth'),
(212, 60, 'Benjamin', 'Boretz'),
(213, 60, 'Jorge Luis', 'Borges'),
(214, 60, 'Norman', 'Borlaug'),
(215, 60, 'Subhash Chandra', 'Bose'),
(216, 60, 'John Collins', 'Bossidy'),
(217, 44, 'James', 'Boswell'),
(218, 44, 'Pik', 'Botha'),
(219, 44, 'Pierre', 'Boutroux'),
(220, 44, 'Elizabeth', 'Bowen'),
(221, 44, 'Bill', 'Bowerman'),
(222, 44, 'David', 'Bowie'),
(223, 81, 'Chester', 'Bowles'),
(224, 81, 'Paul', 'Bowles'),
(225, 81, 'Ralston', 'Bowles'),
(226, 81, 'George E. P.', 'Box'),
(227, 81, 'Peg', 'Bracken'),
(228, 81, 'Thomas', 'Bracken'),
(229, 64, 'Joseph', 'Brackett'),
(230, 64, 'Ray', 'Bradbury'),
(231, 64, 'Omar', 'Bradley'),
(232, 64, 'John', 'Braine'),
(233, 64, 'Max', 'Brand'),
(234, 64, 'Nathaniel', 'Branden'),
(235, 101, 'Marlon', 'Brando'),
(236, 101, 'Georges', 'Braque'),
(237, 101, 'Carol Moseley', 'Braun'),
(238, 101, 'Wernher von', 'Braun'),
(239, 101, 'Deborah', 'Bräutigam'),
(240, 101, 'Richard', 'Brautigan'),
(241, 35, 'Algirdas', 'Brazauskas'),
(242, 35, 'Bertolt', 'Brecht'),
(243, 35, 'Joe Bob', 'Briggs'),
(244, 35, 'Ashleigh', 'Brilliant'),
(245, 35, 'Joseph', 'Brodsky'),
(246, 35, 'Emily', 'Bront?'),
(247, 18, 'Gwendolyn', 'Brooks'),
(248, 18, 'Mel', 'Brooks'),
(249, 18, 'Dr. Joyce', 'Brothers'),
(250, 18, 'Heywood', 'Broun'),
(251, 18, 'Alton', 'Brown'),
(252, 18, 'Earle', 'Brown'),
(253, 55, 'Elizabeth', 'Brown'),
(254, 55, 'Julie', 'Brown'),
(255, 55, 'Sam', 'Brown'),
(256, 55, 'Harry', 'Browne'),
(257, 55, 'Sir Thomas', 'Browne'),
(258, 55, 'Elizabeth Barrett', 'Browning'),
(259, 38, 'Robert', 'Browning'),
(260, 38, 'Anatole', 'Broyard'),
(261, 38, 'Lenny', 'Bruce'),
(262, 38, 'Giordano', 'Bruno'),
(263, 38, 'Marcus Junius', 'Brutus'),
(264, 38, 'William Jennings', 'Bryan'),
(265, 75, 'William Cullen', 'Bryant'),
(266, 75, 'Bill', 'Bryson'),
(267, 75, 'Martin', 'Buber'),
(268, 75, 'John', 'Buchan'),
(269, 75, 'Pearl', 'Buck'),
(270, 9, 'Frank', 'Buckles'),
(271, 9, 'Gautama', 'Buddha'),
(272, 9, 'Warren', 'Buffett'),
(273, 9, 'Lois McMaster', 'Bujold'),
(274, 9, 'Sandra', 'Bullock'),
(275, 9, 'Poseci', 'Bune'),
(276, 95, 'Luis', 'Bu?uel'),
(277, 95, 'Michelangelo', 'Buonarroti'),
(278, 95, 'Edmund', 'Burke'),
(279, 95, 'Carol', 'Burnett'),
(280, 95, 'Daniel', 'Burnham'),
(281, 95, 'Frederick Russell', 'Burnham'),
(282, 29, 'Edward', 'Burns'),
(283, 29, 'Robert', 'Burns'),
(284, 29, 'John', 'Burroughs'),
(285, 29, 'William S.', 'Burroughs'),
(286, 29, 'Sir Richard Francis', 'Burton'),
(287, 12, 'Leo', 'Buscaglia'),
(288, 12, 'George H. W.', 'Bush'),
(289, 12, 'George W.', 'Bush'),
(290, 12, 'John Carder', 'Bush'),
(291, 12, 'Kate', 'Bush'),
(292, 49, 'Vannevar', 'Bush'),
(293, 49, 'Amir', 'Butler'),
(294, 49, 'Smedley', 'Butler'),
(295, 49, 'Dame Elizabeth', 'Butler Sloss'),
(296, 86, 'Tony', 'Buzan'),
(297, 86, 'Richard E.', 'Byrd'),
(298, 86, 'Robert', 'Byrd'),
(299, 69, 'David', 'Byrne'),
(300, 69, 'Robert', 'Byrne'),
(301, 69, 'Lord', 'Byron'),
(302, 69, 'James Branch', 'Cabell'),
(303, 69, 'Irving', 'Caesar'),
(304, 69, 'Julius', 'Caesar'),
(305, 3, 'John', 'Cage'),
(306, 3, 'Peter', 'Cain'),
(307, 3, 'James', 'Callaghan'),
(308, 3, 'John', 'Calvin'),
(309, 3, 'Julia', 'Cameron'),
(310, 89, 'Kirk', 'Cameron'),
(311, 89, 'Beatrice Stella', 'Campbell'),
(312, 89, 'Albert', 'Camus'),
(313, 89, 'James P.', 'Cannon'),
(314, 89, 'José', 'Canseco'),
(315, 23, 'Eric', 'Cantona'),
(316, 23, 'Cao', 'Cao'),
(317, 60, 'Karel', 'Čapek'),
(318, 60, 'Truman', 'Capote'),
(319, 60, 'Al', 'Capone'),
(320, 60, 'Orson Scott', 'Card'),
(321, 43, 'Giosue', 'Carducci'),
(322, 43, 'Mariah', 'Carey'),
(323, 43, 'Sandra', 'Carey'),
(324, 43, 'George', 'Carlin'),
(325, 43, 'Tucker', 'Carlson'),
(326, 43, 'Thomas', 'Carlyle'),
(327, 80, 'Andrew', 'Carnegie'),
(328, 80, 'Adam', 'Carolla'),
(329, 80, 'Alexis', 'Carrel'),
(330, 80, 'Jim', 'Carrey'),
(331, 80, 'Lewis', 'Carroll'),
(332, 80, 'Tom', 'Carroll'),
(333, 63, 'Rachel', 'Carson'),
(334, 63, 'Elliott', 'Carter'),
(335, 63, 'Howard', 'Carter'),
(336, 63, 'Jimmy', 'Carter'),
(337, 63, 'James', 'Carville'),
(338, 63, 'Pablo', 'Casals'),
(339, 100, 'Giacomo', 'Casanova'),
(340, 100, 'Johnny', 'Cash'),
(341, 100, 'Carlos', 'Castaneda'),
(342, 100, 'Fidel', 'Castro'),
(343, 100, 'Willa', 'Cather'),
(344, 100, 'Michael', 'Catt'),
(345, 34, 'Gaius Valerius', 'Catullus'),
(346, 34, 'Adi Asenaca', 'Caucau'),
(347, 34, 'Edith', 'Cavell'),
(348, 34, 'Dick', 'Cavett'),
(349, 34, 'Robert', 'Cecil'),
(350, 34, 'Miguel de', 'Cervantes'),
(351, 17, 'Oswald', 'Chambers'),
(352, 17, 'Raymond', 'Chandler'),
(353, 17, 'Sr.', 'Lon Chaney'),
(354, 17, 'William Ellery', 'Channing'),
(355, 17, 'Harry', 'Chapin'),
(356, 54, 'Colin', 'Chapman'),
(357, 54, 'Dave', 'Chappelle'),
(358, 54, 'Ray', 'Charles'),
(359, 54, 'Fran?ois-René de', 'Chateaubriand'),
(360, 54, 'Bruce', 'Chatwin'),
(361, 54, 'Geoffrey', 'Chaucer'),
(362, 37, 'Mahendra', 'Chaudhry'),
(363, 37, 'Cesar', 'Chavez'),
(364, 37, 'John', 'Cheever'),
(365, 37, 'C. J.', 'Cherryh'),
(366, 37, 'Gilbert Keith', 'Chesterton'),
(367, 37, 'Maurice', 'Chevalier'),
(368, 74, 'Leonardo', 'Chiariglione'),
(369, 74, 'Judy', 'Chicago'),
(370, 74, 'Julia', 'Child'),
(371, 74, 'Margaret', 'Cho'),
(372, 74, 'Rufus', 'Choate'),
(373, 74, 'Agatha', 'Christie'),
(374, 8, 'John', 'Chrysostom'),
(375, 8, 'Winston', 'Churchill'),
(376, 8, 'Madonna', 'Ciccone'),
(377, 8, 'Emile', 'Cioran'),
(378, 8, 'Tom', 'Clancy'),
(379, 95, 'Eric', 'Clapton'),
(380, 95, 'Frank A.', 'Clark'),
(381, 95, 'Ramsey', 'Clark'),
(382, 95, 'Wesley', 'Clark'),
(383, 95, 'Arthur C.', 'Clarke'),
(384, 95, 'Karl von', 'Clausewitz'),
(385, 95, 'Andrew Dice', 'Clay'),
(386, 28, 'Henry', 'Clay'),
(387, 28, 'Georges', 'Clemenceau'),
(388, 28, 'Bill', 'Clinton'),
(389, 28, 'Hillary', 'Clinton'),
(390, 28, 'Brian', 'Clough'),
(391, 28, 'Kurt Donald', 'Cobain'),
(392, 12, 'Johnnie', 'Cochran'),
(393, 12, 'Jean', 'Cocteau'),
(394, 12, 'Andrei', 'Codrescu'),
(395, 12, 'Catman', 'Cohen'),
(396, 12, 'Leonard', 'Cohen'),
(397, 12, 'Nick', 'Cohen'),
(398, 49, 'Richard', 'Cohen'),
(399, 49, 'Nat', 'Cole'),
(400, 49, 'Samuel Taylor', 'Coleridge'),
(401, 49, 'Camilla', 'Collett'),
(402, 49, 'Jeremy', 'Collier'),
(403, 49, 'Tim', 'Collins'),
(404, 86, 'Chris', 'Collison'),
(405, 86, 'Charles', 'Colson'),
(406, 86, 'James', 'Colten'),
(407, 86, 'Charles Caleb', 'Colton'),
(408, 86, 'John', 'Coltrane'),
(409, 86, 'Christopher', 'Columbus'),
(410, 69, 'Henry Steele', 'Commager'),
(411, 69, 'William', 'Congreve'),
(412, 69, 'Fred', 'Conlon'),
(413, 69, 'Cyril', 'Connolly'),
(414, 69, 'Joseph', 'Conrad'),
(415, 69, 'Anne', 'Conway'),
(416, 3, 'Simon', 'Conway Morris'),
(417, 3, 'Peter', 'Cook'),
(418, 3, 'Mason', 'Cooley'),
(419, 3, 'Calvin', 'Coolidge'),
(420, 3, 'Alice', 'Cooper'),
(421, 3, 'Diana', 'Cooper'),
(422, 89, 'Stewart', 'Copeland'),
(423, 89, 'Nicolaus', 'Copernicus'),
(424, 89, 'Aaron', 'Copland'),
(425, 89, 'Chick', 'Corea'),
(426, 89, 'Vernon', 'Corea'),
(427, 89, 'Peter', 'Corey'),
(428, 23, 'Billy', 'Corgan'),
(429, 23, 'Julio', 'Cortazar'),
(430, 23, 'Bill', 'Cosby'),
(431, 23, 'Ann', 'Coulter'),
(432, 23, 'Douglas', 'Coupland'),
(433, 23, 'Leonard H.', 'Courtney'),
(434, 60, 'Margaret', 'Courtney'),
(435, 60, 'Stephen', 'Covington'),
(436, 60, 'Noel', 'Coward'),
(437, 60, 'Abraham', 'Cowley'),
(438, 60, 'William', 'Cowper'),
(439, 60, 'Jim', 'Crace'),
(440, 60, 'Dinah', 'Craik'),
(441, 43, 'Dr. Frank', 'Crane'),
(442, 43, 'Stephen', 'Crane'),
(443, 43, 'Seymour', 'Cray'),
(444, 43, 'Francis', 'Crick'),
(445, 43, 'Barry', 'Crimmins'),
(446, 43, 'Robert X.', 'Cringely'),
(447, 80, 'Quentin', 'Crisp'),
(448, 80, 'Davy', 'Crockett'),
(449, 80, 'Oliver', 'Cromwell'),
(450, 80, 'David', 'Cross'),
(451, 80, 'Aleister', 'Crowley'),
(452, 80, 'Robert', 'Crumb'),
(453, 80, 'E. E.', 'Cummings'),
(454, 63, 'Allan', 'Cunningham'),
(455, 63, 'Ward', 'Cunningham'),
(456, 63, 'Marie', 'Curie'),
(457, 63, 'Richard J.', 'Daley'),
(458, 63, 'Salvador', 'Dali'),
(459, 63, 'Carson', 'Daly'),
(460, 100, 'Daniel', 'Daly'),
(461, 100, 'Johnny', 'Damon'),
(462, 100, 'Rodney', 'Dangerfield'),
(463, 100, 'Samuel', 'Daniel'),
(464, 100, 'Anthony', 'Daniels'),
(465, 34, 'Clarence', 'Darrow'),
(466, 34, 'Charles', 'Darwin'),
(467, 34, 'Dale', 'Dauten'),
(468, 34, 'Bette', 'Davis'),
(469, 34, 'Miles', 'Davis'),
(470, 34, 'Richard', 'Davisson'),
(471, 34, 'Richard', 'Dawkins'),
(472, 17, 'Carl', 'Day'),
(473, 17, 'Moshe', 'Dayan'),
(474, 17, 'Howard', 'Dean'),
(475, 17, 'James', 'Dean'),
(476, 17, 'John', 'Dean'),
(477, 17, 'Edward', 'de Bono'),
(478, 54, 'Eugene V.', 'Debs'),
(479, 54, 'Jack', 'Dee'),
(480, 54, 'Edgar', 'Degas'),
(481, 54, 'Ellen', 'DeGeneres'),
(482, 54, 'Eugene', 'Delacroix'),
(483, 54, 'Zack', 'de la Rocha'),
(484, 37, 'Tom', 'Delay'),
(485, 37, 'Brad', 'Delson'),
(486, 37, 'Anthony', 'de Mello'),
(487, 37, 'Jacques', 'de Molay'),
(488, 37, 'John', 'Denham'),
(489, 37, 'Chauncey', 'Depew'),
(490, 37, 'Theo', 'de Raadt'),
(491, 74, 'Jacques', 'Derrida'),
(492, 74, 'René', 'Descartes'),
(493, 74, 'Jackie', 'DeShannon'),
(494, 74, 'Paul', 'Desmond'),
(495, 74, 'David', 'Deutsch'),
(496, 74, 'Carl', 'Devine'),
(497, 8, 'Ron', 'DeWolfe'),
(498, 8, 'Caroline', 'Dhavernas'),
(499, 8, 'Leonardo', 'DiCaprio'),
(500, 8, 'Philip Kindred', 'Dick'),
(501, 8, 'Charles', 'Dickens'),
(502, 8, 'Emily', 'Dickinson'),
(503, 94, 'Leonard Eugene', 'Dickson'),
(504, 94, 'Denis', 'Diderot'),
(505, 94, 'Joan', 'Didion'),
(506, 94, 'Annie', 'Dillard'),
(507, 94, 'Paul', 'Dirac'),
(508, 94, 'Everett', 'Dirksen'),
(509, 28, 'Roy O.', 'Disney'),
(510, 28, 'Walt', 'Disney'),
(511, 28, 'Benjamin', 'Disraeli'),
(512, 28, 'Edsger', 'Dijkstra'),
(513, 28, 'Milovan', 'Djilas'),
(514, 28, 'James', 'Dobson'),
(515, 28, 'Snoop', 'Dogg'),
(516, 11, 'Peter', 'Doherty'),
(517, 11, 'Eric', 'Dolphy'),
(518, 11, 'Ignacy', 'Domeyko'),
(519, 11, 'Mark-Jason', 'Dominus'),
(520, 11, 'Stephen R.', 'Donaldson'),
(521, 11, 'John', 'Donne'),
(522, 48, 'Rael', 'Dornfest'),
(523, 48, 'Fyodor', 'Dostoevsky'),
(524, 48, 'Donald', 'Douglas'),
(525, 48, 'Kirk', 'Douglas'),
(526, 48, 'Tommy', 'Douglas'),
(527, 48, 'David', 'Douglass'),
(528, 85, 'Frederick', 'Douglass'),
(529, 85, 'Arthur Conan', 'Doyle'),
(530, 85, 'Nick', 'Drake'),
(531, 85, 'Theodore', 'Dreiser'),
(532, 85, 'Peter F.', 'Drucker'),
(533, 85, 'Hilary', 'Duff'),
(534, 68, 'Alexandre', 'Dumas'),
(535, 68, 'Kirsten', 'Dunst'),
(536, 68, 'Jimmy', 'Durante'),
(537, 68, 'Richard', 'Durbin'),
(538, 68, 'Gerald', 'Durrell'),
(539, 68, 'Denis', 'Dutton'),
(540, 2, 'Wayne', 'Dyer'),
(541, 2, 'Henry van', 'Dyke'),
(542, 2, 'Bob', 'Dylan'),
(543, 2, 'Freeman', 'Dyson'),
(544, 2, 'Jubal Anderson', 'Early'),
(545, 2, 'Clint', 'Eastwood'),
(546, 88, 'Shirin', 'Ebadi'),
(547, 88, 'Abba', 'Eban'),
(548, 88, 'Roger', 'Ebert'),
(549, 88, 'Bernie', 'Ecclestone'),
(550, 88, 'Damien', 'Echols'),
(551, 88, 'Meister', 'Eckhart'),
(552, 22, 'Arthur Stanley', 'Eddington'),
(553, 22, 'Thomas Alva', 'Edison'),
(554, 22, 'Edwin W.', 'Edwards'),
(555, 22, 'John', 'Edwards'),
(556, 22, 'Dave', 'Eggers'),
(557, 22, 'Paul R.', 'Ehrlich'),
(558, 59, 'Albert', 'Einstein'),
(559, 59, 'Dwight D.', 'Eisenhower'),
(560, 59, 'Ferdinand', 'Eisenstein'),
(561, 59, 'Mohamed', 'ElBaradei'),
(562, 59, 'Niles', 'Eldredge'),
(563, 59, 'George', 'Eliot'),
(564, 43, 'Thomas Stearns', 'Eliot'),
(565, 43, 'the Queen Mother', 'Elizabeth'),
(566, 43, 'Duke', 'Ellington'),
(567, 43, 'Cass', 'Elliot'),
(568, 43, 'Jim', 'Elliot'),
(569, 43, 'Harlan', 'Ellison'),
(570, 79, 'Paul', 'Eluard'),
(571, 79, 'Ralph Waldo', 'Emerson'),
(572, 79, 'Anke', 'Engelke'),
(573, 79, 'Paul', 'Erdös'),
(574, 79, 'Steven', 'Erikson'),
(575, 63, 'M. C.', 'Escher'),
(576, 63, 'Phil', 'Esposito'),
(577, 63, 'Gloria', 'Estefan'),
(578, 63, 'Carl', 'Everett'),
(579, 63, 'Bob', 'Ezrin'),
(580, 63, 'Dennis', 'Fakes'),
(581, 63, 'Nigel', 'Farage'),
(582, 100, 'Eleanor', 'Farjeon'),
(583, 100, 'Frances', 'Farmer'),
(584, 100, 'Fan', 'Noli'),
(585, 100, 'Daniel', 'Fatiaki'),
(586, 100, 'William', 'Faulkner'),
(587, 100, 'Brett', 'Favre'),
(588, 34, 'Guy', 'Fawkes'),
(589, 34, 'Roger', 'Federer'),
(590, 34, 'Jim', 'Feibig'),
(591, 34, 'Russ', 'Feingold'),
(592, 34, 'Morton', 'Feldman'),
(593, 34, 'Federico', 'Fellini'),
(594, 34, 'Adam', 'Ferguson'),
(595, 17, 'Miriam', 'Ferguson'),
(596, 17, 'Enrico', 'Fermi'),
(597, 17, 'Will', 'Ferrell'),
(598, 17, 'Marcelle', 'Ferron'),
(599, 17, 'Joseph', 'Fétis'),
(600, 17, 'Tina', 'Fey'),
(601, 54, 'Richard', 'Feynman'),
(602, 54, 'Henry', 'Fielding'),
(603, 54, 'W. C.', 'Fields'),
(604, 54, 'Albert', 'Finney'),
(605, 54, 'Shulamith', 'Firestone'),
(606, 54, 'Bobby', 'Fischer'),
(607, 37, 'Joschka', 'Fischer'),
(608, 37, 'Michael', 'Fish'),
(609, 37, 'Margaret', 'Fishback'),
(610, 37, 'Carrie', 'Fisher'),
(611, 37, 'Irving', 'Fiske'),
(612, 37, 'Franciszek', 'Fiszer'),
(613, 74, 'F. Scott', 'Fitzgerald'),
(614, 74, 'Patrick', 'Fitzgerald'),
(615, 74, 'Gustave', 'Flaubert'),
(616, 74, 'Larry', 'Flynt'),
(617, 74, 'Ferdinand', 'Foch'),
(618, 74, 'Mick', 'Foley'),
(619, 74, 'Margot', 'Fonteyn'),
(620, 8, 'Malcolm', 'Forbes'),
(621, 8, 'Gerald', 'Ford'),
(622, 8, 'Harrison', 'Ford'),
(623, 8, 'Henry', 'Ford'),
(624, 8, 'E. M.', 'Forster'),
(625, 8, 'Bruce', 'Forsyth'),
(626, 94, 'Charles', 'Fort'),
(627, 94, 'Harry Emerson', 'Fosdick'),
(628, 94, 'Sir Robert Sidney', 'Foster'),
(629, 94, 'Gene', 'Fowler'),
(630, 94, 'George', 'Fox'),
(631, 94, 'Virgil', 'Fox'),
(632, 28, 'Jeff', 'Foxworthy'),
(633, 28, 'Anatole', 'France'),
(634, 28, 'Terry', 'Francona'),
(635, 28, 'Richard', 'Franck'),
(636, 28, 'Anne', 'Frank'),
(637, 28, 'Benjamin', 'Franklin'),
(638, 11, 'Tommy', 'Franks'),
(639, 11, 'Michael', 'Franti'),
(640, 11, 'Jonathan', 'Franzen'),
(641, 11, 'Sigmund', 'Freud'),
(642, 11, 'Peter', 'Freund'),
(643, 11, 'Kinky', 'Friedman'),
(644, 48, 'Milton', 'Friedman'),
(645, 48, 'Nat', 'Friedman'),
(646, 48, 'Todd', 'Friel'),
(647, 48, 'Bill', 'Frist'),
(648, 48, 'Erich', 'Fromm'),
(649, 48, 'Robert', 'Frost'),
(650, 85, 'Mariella', 'Frostrup'),
(651, 85, 'J. William', 'Fulbright'),
(652, 85, 'Robert', 'Fulghum'),
(653, 85, 'Buckminster', 'Fuller'),
(654, 85, 'Margaret', 'Fuller'),
(655, 85, 'Zsa Zsa', 'Gabor'),
(656, 68, 'Peter', 'Gabriel'),
(657, 68, 'Yuri', 'Gagarin'),
(658, 68, 'Neil', 'Gaiman'),
(659, 68, 'John Kenneth', 'Galbraith'),
(660, 68, 'Galileo', 'Galilei'),
(661, 68, 'Fred', 'Gallagher'),
(662, 2, 'Vincent Actor', 'Gallo'),
(663, 2, 'George', 'Galloway'),
(664, 2, 'George', 'Gallup'),
(665, 2, 'Leopoldo', 'Galtieri'),
(666, 2, 'Indira', 'Gandhi'),
(667, 2, 'Mahatma', 'Gandhi'),
(668, 88, 'Cao', 'Gangchuan'),
(669, 88, 'Adi Ateca', 'Ganilau'),
(670, 88, 'Ratu Epeli', 'Ganilau'),
(671, 88, 'Ratu Sir Penaia', 'Ganilau'),
(672, 88, 'Carlos', 'Gardel'),
(673, 88, 'James A.', 'Garfield'),
(674, 22, 'Judy', 'Garland'),
(675, 22, 'Helen', 'Garner'),
(676, 22, 'William Lloyd', 'Garrison'),
(677, 22, 'Romain', 'Gary'),
(678, 22, 'Jean-Louis', 'Gassée'),
(679, 22, 'Bill', 'Gates'),
(680, 59, 'Antonio', 'Gaudi'),
(681, 59, 'Paul', 'Gauguin'),
(682, 59, 'Charles de', 'Gaulle'),
(683, 59, 'Jules de', 'Gaultier'),
(684, 59, 'Carl Friedrich', 'Gauss'),
(685, 59, 'John', 'Gay'),
(686, 42, 'Marvin', 'Gaye'),
(687, 42, 'Samir', 'Geagea'),
(688, 42, 'Solange', 'Gemayel'),
(689, 42, 'Jean', 'Genet'),
(690, 42, 'Dick', 'Gephardt'),
(691, 42, 'Frances', 'Gerety'),
(692, 79, 'David', 'Gergen'),
(693, 79, 'Alberto', 'Giacometti'),
(694, 79, 'Edward', 'Gibbon'),
(695, 79, 'Khalil', 'Gibran'),
(696, 79, 'William Ford', 'Gibson'),
(697, 79, 'André', 'Gide'),
(698, 62, 'W. S.', 'Gilbert'),
(699, 62, 'George', 'Gilder'),
(700, 62, 'Eric', 'Gill'),
(701, 62, 'John', 'Gilmore'),
(702, 62, 'Haim', 'Ginott'),
(703, 62, 'Jean', 'Giraudoux'),
(704, 62, 'Rudy', 'Giuliani'),
(705, 99, 'William Ewart', 'Gladstone'),
(706, 99, 'Jean-Luc', 'Godard'),
(707, 99, 'Earl of Wessex', 'Godwin'),
(708, 99, 'Mike', 'Godwin'),
(709, 99, 'Hermann', 'Goering'),
(710, 33, 'Johann Wolfgang von', 'Goethe'),
(711, 53, 'Vincent Willem Van', 'Gogh'),
(712, 53, 'Nikolai Vasilievich', 'Gogol'),
(713, 36, 'Jonah', 'Goldberg'),
(714, 36, 'William', 'Golding'),
(715, 36, 'Emma', 'Goldman'),
(716, 36, 'Oliver', 'Goldsmith'),
(717, 36, 'Andy', 'Goldsworthy'),
(718, 36, 'Barry', 'Goldwater'),
(719, 73, 'Samuel', 'Goldwyn'),
(720, 73, 'Ellen', 'Goodman'),
(721, 73, 'Maxim', 'Gorky'),
(722, 73, 'Hermann', 'Göring'),
(723, 73, 'Bill', 'Gothard'),
(724, 7, 'Stephen Jay', 'Gould'),
(725, 7, 'Francisco', 'Goya'),
(726, 7, 'Baltasar', 'Gracian'),
(727, 7, 'Lindsey', 'Graham'),
(728, 7, 'Paul', 'Graham'),
(729, 94, 'Antonio', 'Gramsci'),
(730, 94, 'Ulysses S.', 'Grant'),
(731, 94, 'Günter', 'Grass'),
(732, 94, 'Thomas', 'Gray'),
(733, 27, 'Horace', 'Greeley'),
(734, 27, 'Matthew', 'Green'),
(735, 27, 'Graham', 'Greene'),
(736, 27, 'Germaine', 'Greer'),
(737, 27, 'Stephen', 'Grellet'),
(738, 11, 'Zane', 'Grey'),
(739, 11, 'Alfred Whitney', 'Griswold'),
(740, 11, 'Erwin', 'Griswold'),
(741, 11, 'Josh', 'Groban'),
(742, 11, 'Matt', 'Groening'),
(743, 48, 'Andy', 'Grove'),
(744, 48, 'Robert', 'Grudin'),
(745, 48, 'Peter', 'Guber'),
(746, 48, 'Heinz', 'Guderian'),
(747, 48, 'Ernesto', 'Guevara'),
(748, 85, 'Sacha', 'Guitry'),
(749, 85, 'Bjork', 'Gundmundsdottir'),
(750, 85, 'G. I.', 'Gurdjieff'),
(751, 85, 'Gary', 'Gygax'),
(752, 85, 'Jake', 'Gyllenhaal'),
(753, 68, 'Alois', 'Haba'),
(754, 68, 'Frank', 'Hague'),
(755, 68, 'Alexander', 'Haig'),
(756, 68, 'Peter', 'Hain'),
(757, 68, 'George', 'Halas'),
(758, 68, 'Joe', 'Haldeman'),
(759, 2, 'Alex', 'Haley'),
(760, 2, 'Evelyn Beatrice', 'Hall'),
(761, 2, 'Richard', 'Halliburton'),
(762, 2, 'Tony', 'Halme'),
(763, 2, 'William', 'Halsey'),
(764, 2, 'Alexander', 'Hamilton'),
(765, 88, 'Gail', 'Hamilton'),
(766, 88, 'Laurell K.', 'Hamilton'),
(767, 88, 'Dag', 'Hammarskjöld'),
(768, 88, 'Charles', 'Handy'),
(769, 88, 'W. C.', 'Handy'),
(770, 22, 'Sean', 'Hannity'),
(771, 22, 'Stephen', 'Harper'),
(772, 22, 'Sam', 'Harris'),
(773, 22, 'William Torrey', 'Harris'),
(774, 22, 'George', 'Harrison'),
(775, 22, 'Lorenz', 'Hart'),
(776, 59, 'Owen', 'Hart'),
(777, 59, 'Paul', 'Harvey'),
(778, 59, 'Jaroslav', 'Hašek'),
(779, 59, 'Anne', 'Hathaway'),
(780, 59, 'Sybil', 'Hathaway'),
(781, 59, 'Roy', 'Hattersley'),
(782, 59, 'Vaclav', 'Havel'),
(783, 42, 'Davey', 'Havok'),
(784, 42, 'Stephen', 'Hawking'),
(785, 42, 'Nathaniel', 'Hawthorne'),
(786, 42, 'Teresa Nielson', 'Hayden'),
(787, 42, 'Friedrich', 'Hayek'),
(788, 42, 'Helen', 'Hayes'),
(789, 79, 'William', 'Hazlitt'),
(790, 79, 'Mitch', 'Hedberg'),
(791, 79, 'Chris', 'Hedges'),
(792, 79, 'Georg Friedrich Wilhelm', 'Hegel'),
(793, 79, 'Jascha', 'Heifetz'),
(794, 79, 'Carolyn', 'Heilbrun'),
(795, 62, 'Piet', 'Hein'),
(796, 62, 'Max', 'Heindel'),
(797, 62, 'Robert A.', 'Heinlein'),
(798, 62, 'Heinrich', 'Heine'),
(799, 62, 'Werner', 'Heisenberg'),
(800, 62, 'John', 'Held'),
(801, 99, 'Joseph', 'Heller'),
(802, 99, 'Lillian', 'Hellman'),
(803, 99, 'Ernest', 'Hemingway'),
(804, 99, 'Rickey', 'Henderson'),
(805, 99, 'Phil', 'Hendrie'),
(806, 99, 'Jimi', 'Hendrix'),
(807, 33, 'Ammon', 'Hennessey'),
(808, 33, 'Matthew', 'Henry'),
(809, 33, 'O.', 'Henry'),
(810, 33, 'Patrick', 'Henry'),
(811, 33, 'Audrey', 'Hepburn'),
(812, 33, 'Katherine', 'Hepburn'),
(813, 16, 'George', 'Herbert'),
(814, 16, 'Zbigniew', 'Herbert'),
(815, 16, 'Julian', 'Hernandez'),
(816, 16, 'John', 'Herschel'),
(817, 16, 'Roger D', 'Herzler'),
(818, 16, 'Werner', 'Herzog'),
(819, 53, 'Abraham Joshua', 'Heschel'),
(820, 53, 'Karl', 'Hess'),
(821, 53, 'Hermann', 'Hesse'),
(822, 53, 'Hugh', 'Hewitt'),
(823, 53, 'John', 'Heywood'),
(824, 53, 'Dan', 'Hibiki'),
(825, 36, 'Michael', 'Hickenbottom'),
(826, 36, 'Bill', 'Hicks'),
(827, 36, 'Dan', 'Hicks'),
(828, 36, 'Jim', 'Hightower'),
(829, 36, 'Nazim', 'Hikmet'),
(830, 73, 'Joe', 'Hill'),
(831, 73, 'Napoleon', 'Hill'),
(832, 73, 'Edmund', 'Hillary'),
(833, 73, 'Mary', 'Hirsch'),
(834, 73, 'Christopher', 'Hitchens'),
(835, 73, 'Alfred', 'Hitchcock'),
(836, 7, 'Thomas', 'Hobbes'),
(837, 7, 'Benjamin', 'Hoff'),
(838, 7, 'Eric', 'Hoffer'),
(839, 7, 'Abbie', 'Hoffman'),
(840, 7, 'Jessica', 'Hoffman'),
(841, 7, 'Douglas', 'Hofstadter'),
(842, 93, 'Richard', 'Hofstadter'),
(843, 93, 'Friedrich', 'Holderlin'),
(844, 93, 'Oliver Wendell', 'Holmes'),
(845, 93, 'Oliver Wendell', 'Holmes'),
(846, 93, 'Anatol', 'Holt'),
(847, 93, 'John', 'Holt'),
(848, 27, 'Soichiro', 'Honda'),
(849, 27, 'Herbert', 'Hoover'),
(850, 27, 'Bob', 'Hope'),
(851, 27, 'Gerard Manley', 'Hopkins'),
(852, 27, 'Edward', 'Hopper'),
(853, 27, 'Grace', 'Hopper'),
(854, 27, 'Jim', 'Horning'),
(855, 10, 'Harry', 'Houdini'),
(856, 10, 'Jinnah', 'House'),
(857, 10, 'A. E.', 'Housman'),
(858, 10, 'Julia Ward', 'Howe'),
(859, 10, 'James', 'Howell'),
(860, 10, 'Fred', 'Hoyle'),
(861, 47, 'Elbert', 'Hubbard'),
(862, 47, 'Kin', 'Hubbard'),
(863, 47, 'L. Ron', 'Hubbard'),
(864, 47, 'Mike', 'Huckabee'),
(865, 47, 'Tim', 'Huelskamp'),
(866, 47, 'Arianna', 'Huffington'),
(867, 84, 'Charles Evans', 'Hughes'),
(868, 84, 'Victor', 'Hugo'),
(869, 84, 'Bobby', 'Hull'),
(870, 84, 'Cordell', 'Hull'),
(871, 84, 'Alexander von', 'Humboldt'),
(872, 84, 'Wilhelm von', 'Humboldt'),
(873, 84, 'David', 'Hume'),
(874, 67, 'Friedensreich', 'Hundertwasser'),
(875, 67, 'William', 'Hung'),
(876, 67, 'J. McV.', 'Hunt'),
(877, 67, 'Zora Neale', 'Hurston'),
(878, 67, 'Saddam', 'Hussein'),
(879, 1, 'Francis', 'Hutcheson'),
(880, 1, 'Thomas', 'Hutchinson'),
(881, 1, 'James', 'Hutton'),
(882, 1, 'Aldous', 'Huxley'),
(883, 1, 'Julian', 'Huxley'),
(884, 1, 'Thomas Henry', 'Huxley'),
(885, 1, 'Christian', 'Huygens'),
(886, 87, 'Jack', 'Hyles'),
(887, 87, 'Matt', 'Hyson'),
(888, 87, 'Lee', 'Iacocca'),
(889, 87, 'Henrik', 'Ibsen'),
(890, 87, 'David', 'Icke'),
(891, 87, 'Eric', 'Idle'),
(892, 21, 'Ratu Josefa', 'Iloilo'),
(893, 21, 'William Ralph', 'Inge'),
(894, 21, 'Jean', 'Ingelow'),
(895, 21, 'Robert G.', 'Ingersoll'),
(896, 21, 'Eugene', 'Ionesco'),
(897, 58, 'Regina', 'Ip'),
(898, 58, 'Eddie', 'Irvine'),
(899, 58, 'Shintaro', 'Ishihara'),
(900, 58, 'Shigesato', 'Itoi'),
(901, 58, 'Eddie', 'Izzard'),
(902, 58, 'Anneli', 'Jäätteenmäki'),
(903, 42, 'Andrew', 'Jackson'),
(904, 42, 'Janet', 'Jackson'),
(905, 42, 'Jesse', 'Jackson'),
(906, 42, 'Michael', 'Jackson'),
(907, 42, 'Robert H.', 'Jackson'),
(908, 42, 'Bob', 'Jaffe'),
(909, 78, 'Alice', 'James'),
(910, 78, 'C. L. R.', 'James'),
(911, 78, 'Donald', 'James'),
(912, 78, 'Henry', 'James'),
(913, 78, 'Kevin', 'James'),
(914, 78, 'William', 'James'),
(915, 62, 'Leoš', 'Janaček'),
(916, 62, 'Randall', 'Jarrell'),
(917, 62, 'Jeff', 'Jarrett'),
(918, 62, 'Glenn', 'Jay'),
(919, 62, 'Alfred', 'Jarry'),
(920, 62, 'Robinson', 'Jeffers'),
(921, 99, 'Thomas', 'Jefferson'),
(922, 99, 'Fred', 'Jelinek'),
(923, 99, 'Henry', 'Jenner'),
(924, 99, 'Peter', 'Jennings'),
(925, 99, 'Derrick', 'Jensen'),
(926, 99, 'Hayley', 'Jensen'),
(927, 99, 'Derek', 'Jeter'),
(928, 33, 'Penn', 'Jillette'),
(929, 33, 'Steve', 'Jobs'),
(930, 33, 'Michael', 'Johns'),
(931, 33, 'Boris', 'Johnson'),
(932, 33, 'Lyndon', 'Johnson'),
(933, 33, 'Philip', 'Johnson'),
(934, 16, 'Samuel', 'Johnson'),
(935, 16, 'Susan', 'Johnson'),
(936, 16, 'Zach', 'Johnson'),
(937, 16, 'Angelina', 'Jolie'),
(938, 16, 'John Paul', 'Jones'),
(939, 16, 'Norah', 'Jones'),
(940, 53, 'Orlando', 'Jones'),
(941, 53, 'Erica', 'Jong'),
(942, 53, 'Ben', 'Jonson'),
(943, 53, 'Janis', 'Joplin'),
(944, 53, 'Sandra', 'Jordan'),
(945, 53, 'Chief', 'Joseph'),
(946, 36, 'Kedar', 'Joshi'),
(947, 36, 'Joseph', 'Joubert'),
(948, 36, 'James', 'Joyce'),
(949, 36, 'Benito', 'Juarez'),
(950, 36, 'Ashley', 'Judd'),
(951, 36, 'Frederic', 'Jueneman'),
(952, 36, 'Carl', 'Jung'),
(953, 73, 'Traudl', 'Junge'),
(954, 73, 'Bai', 'Juyi'),
(955, 73, 'Lech', 'Kaczynski'),
(956, 73, 'Pauline', 'Kael'),
(957, 73, 'Franz', 'Kafka'),
(958, 73, 'Frida', 'Kahlo'),
(959, 7, 'Subhash', 'Kak'),
(960, 7, 'APJ Abdul', 'Kalam'),
(961, 7, 'Immanuel', 'Kant'),
(962, 7, 'William', 'Kapell'),
(963, 7, 'Ryszard', 'Kapuściński'),
(964, 7, 'Ron', 'Karenga'),
(965, 93, 'Hamid', 'Karzai'),
(966, 93, 'Garry', 'Kasparov'),
(967, 93, 'Jonathan', 'Katz'),
(968, 93, 'Yasunari', 'Kawabata'),
(969, 93, 'Kurt', 'Kawohl'),
(970, 93, 'Alan', 'Kay'),
(971, 27, 'Ken', 'Kay'),
(972, 27, 'Nikos', 'Kazantzakis'),
(973, 27, 'John', 'Keats'),
(974, 27, 'Paul', 'Keating'),
(975, 27, 'Buster', 'Keaton'),
(976, 27, 'John', 'Keel'),
(977, 10, 'Charles', 'Keeping'),
(978, 10, 'Garrison', 'Keillor'),
(979, 10, 'Helen', 'Keller'),
(980, 10, 'Friedrich', 'Kellner'),
(981, 10, 'Walt', 'Kelly'),
(982, 10, 'Murray', 'Kempton'),
(983, 10, 'Lord', 'Kelvin'),
(984, 47, 'Alex', 'Kendrick'),
(985, 47, 'George F.', 'Kennan'),
(986, 47, 'Anthony', 'Kennedy'),
(987, 47, 'Edward', 'Kennedy'),
(988, 47, 'John F.', 'Kennedy'),
(989, 47, 'Robert', 'Kennedy'),
(990, 84, 'Robert F.', 'Kennedy'),
(991, 84, 'Robert Francis Jr.', 'Kennedy'),
(992, 84, 'Ro Teimumu', 'Kepa'),
(993, 84, 'Jack', 'Kerouac'),
(994, 84, 'John', 'Kerry'),
(995, 84, 'Teresa Heinz', 'Kerry'),
(996, 67, 'Ken', 'Kesey'),
(997, 67, 'Alan', 'Keyes'),
(998, 67, 'John Maynard', 'Keynes'),
(999, 67, 'Hafiz', 'Khan'),
(1000, 67, 'Nusrat Fateh Ali', 'Khan'),
(1001, 67, 'Shahrukh', 'Khan'),
(1002, 67, 'Genghis', 'Khan'),
(1003, 1, 'Omar', 'Khayyam'),
(1004, 1, 'Ruhollah', 'Khomeini'),
(1005, 1, 'Nikita', 'Khrushchev'),
(1006, 1, 'Soren Aabye', 'Kierkegaard'),
(1007, 1, 'Joyce', 'Kilmer'),
(1008, 1, 'Lemmy', 'Kilmister'),
(1009, 87, 'Robert', 'Kilroy-Silk'),
(1010, 87, 'Carole', 'King'),
(1011, 87, 'Coretta Scott', 'King'),
(1012, 87, 'Martin Luther', 'King'),
(1013, 87, 'Stephen', 'King'),
(1014, 87, 'William', 'King'),
(1015, 21, 'Charles', 'Kingsley'),
(1016, 21, 'Barbara', 'Kingsolver'),
(1017, 21, 'Alfred', 'Kinsey'),
(1018, 21, 'Klaus', 'Kinski'),
(1019, 21, 'Rudyard', 'Kipling'),
(1020, 21, 'Henry', 'Kissinger'),
(1021, 58, 'Zalmay', 'Khalilzad'),
(1022, 58, 'Kevin', 'Kline'),
(1023, 58, 'Friedrich Gottlieb', 'Klopstock'),
(1024, 58, 'Roger', 'Knapman'),
(1025, 58, 'Fletcher', 'Knebel'),
(1026, 58, 'Keira', 'Knightley'),
(1027, 41, 'Donald', 'Knuth'),
(1028, 41, 'Arthur', 'Koestler'),
(1029, 41, 'Jeff', 'Koons'),
(1030, 41, 'Dean R.', 'Koontz'),
(1031, 41, 'C. Everett', 'Koop'),
(1032, 41, 'Tony', 'Kornheiser'),
(1033, 78, 'Alan', 'Kotok'),
(1034, 78, 'Ernie', 'Kovacs'),
(1035, 78, 'Sidiq', 'Koya'),
(1036, 78, 'Karl', 'Kraus'),
(1037, 78, 'Lou', 'Krieger'),
(1038, 78, 'Robbie', 'Krieger'),
(1039, 61, 'Saul', 'Kripke'),
(1040, 61, 'Jiddu', 'Krishnamurti'),
(1041, 61, 'Kalki', 'Krishnamurthy'),
(1042, 61, 'Alexander', 'Kronrod'),
(1043, 61, 'John', 'Kruk'),
(1044, 61, 'Barbara', 'Kruger'),
(1045, 98, 'Ernst', 'Kruth'),
(1046, 98, 'Elisabeth', 'Kübler-Ross'),
(1047, 98, 'Lawrence', 'Kudlow'),
(1048, 32, 'Milan', 'Kundera'),
(1049, 32, 'Ted', 'Kulongoski'),
(1050, 32, 'Chiaki', 'Kuriyama'),
(1051, 32, 'Akira', 'Kurosawa'),
(1052, 32, 'Nicholas', 'Kurti'),
(1053, 32, 'Katherine', 'Kurtz'),
(1054, 15, 'Scott R.', 'Kurtz'),
(1055, 15, 'Emir', 'Kusturica'),
(1056, 15, 'Jean de', 'La Bruyere'),
(1057, 15, 'Tim', 'LaHaye'),
(1058, 15, 'Michael', 'Laitman'),
(1059, 15, 'Ratu Naiqama', 'Lalabalavu'),
(1060, 15, 'Charles', 'Lamb'),
(1061, 52, 'Ann', 'Landers'),
(1062, 52, 'Walter Savage', 'Landor'),
(1063, 52, 'Nathan', 'Lane'),
(1064, 52, 'Will Jr.', 'Lang'),
(1065, 52, 'Jack La', 'Lanne'),
(1066, 52, 'Pierre-Simon', 'Laplace'),
(1067, 35, 'Ring', 'Lardner'),
(1068, 35, 'Fran?ois de', 'La Rochefoucauld'),
(1069, 35, 'Tommy', 'Lasorda'),
(1070, 35, 'Mel', 'Lastman'),
(1071, 72, 'Charley', 'Lau'),
(1072, 72, 'Stan', 'Laurel'),
(1073, 72, 'Joanie', 'Laurer'),
(1074, 72, 'Mečys', 'Laurinkus'),
(1075, 72, 'Avril', 'Lavigne'),
(1076, 72, 'Jerry', 'Lawler'),
(1077, 6, 'Thomas Edward', 'Lawrence'),
(1078, 6, 'Stephen', 'Leacock'),
(1079, 6, 'Edward', 'Lear'),
(1080, 6, 'Timothy', 'Leary'),
(1081, 6, 'Romeo', 'LeBlanc'),
(1082, 6, 'Fran', 'Lebowitz'),
(1083, 6, 'Stanislaw Jerzy', 'Lec'),
(1084, 92, 'Ang', 'Lee'),
(1085, 92, 'Bruce', 'Lee'),
(1086, 92, 'Stan', 'Lee'),
(1087, 92, 'John', 'Lehman'),
(1088, 92, 'Fritz', 'Leiber'),
(1089, 26, 'Stanislaw', 'Lem'),
(1090, 26, 'Curtis', 'LeMay'),
(1091, 26, 'Vladimir', 'Lenin'),
(1092, 26, 'John', 'Lennon'),
(1093, 26, 'Jay', 'Leno'),
(1094, 26, 'Elmore', 'Leonard'),
(1095, 10, 'Penny', 'Lernoux'),
(1096, 10, 'Lawrence', 'Lessig'),
(1097, 10, 'Doris', 'Lessing'),
(1098, 10, 'David', 'Letterman'),
(1099, 10, 'Graeme', 'Leung'),
(1100, 10, 'Denise', 'Levertov'),
(1101, 10, 'Ada', 'Leverson'),
(1102, 47, 'Claude', 'Lévi-Strauss'),
(1103, 47, 'C. S.', 'Lewis'),
(1104, 47, 'Jenny', 'Lewis'),
(1105, 47, 'Sinclair', 'Lewis'),
(1106, 47, 'Georg Christoph', 'Lichtenberg'),
(1107, 47, 'G. Gordon', 'Liddy'),
(1108, 84, 'A. J.', 'Liebling'),
(1109, 84, 'Rush', 'Limbaugh'),
(1110, 84, 'Abraham', 'Lincoln'),
(1111, 84, 'Jesse Lauriston', 'Livermore'),
(1112, 84, 'Seth', 'Lloyd'),
(1113, 84, 'John', 'Locke'),
(1114, 67, 'Lindsay', 'Lohan'),
(1115, 67, 'Jack', 'London'),
(1116, 67, 'Earl', 'Long'),
(1117, 67, 'Huey P.', 'Long'),
(1118, 67, 'Henry Wadsworth', 'Longfellow'),
(1119, 1, 'Tristan J.', 'Loo'),
(1120, 1, 'General William', 'Looney'),
(1121, 1, 'Trent', 'Lott'),
(1122, 1, 'Joe', 'Louis'),
(1123, 1, 'Courtney', 'Love'),
(1124, 1, 'H. P.', 'Lovecraft'),
(1125, 87, 'Richard', 'Lovelace'),
(1126, 87, 'Amory', 'Lovins'),
(1127, 87, 'Christopher', 'Lowell'),
(1128, 87, 'John', 'Lubbock'),
(1129, 87, 'George', 'Lucas'),
(1130, 87, 'Arnold M.', 'Ludwig'),
(1131, 21, 'Martin', 'Luther'),
(1132, 21, 'Rosa', 'Luxemburg'),
(1133, 21, 'Peter', 'Lynch'),
(1134, 21, 'Steve', 'Lyons'),
(1135, 21, 'Wangari', 'Maathai'),
(1136, 21, 'Douglas', 'MacArthur'),
(1137, 21, 'Thomas Babington', 'Macaulay'),
(1138, 58, 'George', 'Macdonald'),
(1139, 58, 'Robert Roy', 'MacGregor'),
(1140, 58, 'Antonio', 'Machado'),
(1141, 58, 'Niccolo', 'Machiavelli'),
(1142, 58, 'Madonna', 'Madonna see Ciccone'),
(1143, 41, 'Ratu Joni', 'Madraiwiwi'),
(1144, 41, 'Bryan', 'Magee'),
(1145, 41, 'Bill', 'Maher'),
(1146, 41, 'Rob', 'Malda'),
(1147, 41, 'David', 'Mallet'),
(1148, 41, 'Matt', 'Malley'),
(1149, 41, 'Thomas', 'Malory'),
(1150, 78, 'Andre', 'Malraux'),
(1151, 78, 'Thomas', 'Malthus'),
(1152, 78, 'William', 'Manchester'),
(1153, 78, 'Nelson', 'Mandela'),
(1154, 78, 'Horace', 'Mann'),
(1155, 78, 'Thomas', 'Mann'),
(1156, 61, 'Karl', 'Mannheim'),
(1157, 61, 'Katherine', 'Mansfield'),
(1158, 61, 'Charles', 'Manson'),
(1159, 61, 'Marilyn', 'Manson'),
(1160, 61, 'Ratu Sir Kamisese', 'Mara'),
(1161, 61, 'Guglielmo', 'Marconi'),
(1162, 98, 'Ferdinand Edralin', 'Marcos'),
(1163, 98, 'Bob', 'Marley'),
(1164, 98, 'Christopher', 'Marlowe'),
(1165, 98, 'Constantine', 'Maroulis'),
(1166, 98, 'Don', 'Marquis'),
(1167, 98, 'George', 'Marshall'),
(1168, 32, 'Joshua Micah', 'Marshall'),
(1169, 32, 'Thomas R.', 'Marshall'),
(1170, 32, 'Yann', 'Martell'),
(1171, 32, 'José', 'Mart?'),
(1172, 32, 'Demetri', 'Martin'),
(1173, 32, 'John', 'Martin'),
(1174, 15, 'Judith', 'Martin'),
(1175, 15, 'Paul', 'Martin'),
(1176, 15, 'Steve', 'Martin'),
(1177, 15, 'Andrew', 'Marvell'),
(1178, 15, 'Groucho', 'Marx'),
(1179, 15, 'Karl', 'Marx'),
(1180, 15, 'Abraham', 'Maslow'),
(1181, 52, 'Petero', 'Mataca'),
(1182, 52, 'Francesco', 'Matarazzo'),
(1183, 52, 'Henri', 'Matisse'),
(1184, 52, 'Dave', 'Matthews'),
(1185, 52, 'William Somerset', 'Maugham'),
(1186, 35, 'Guy de', 'Maupassant'),
(1187, 35, 'Rollo', 'May'),
(1188, 35, 'Curtis', 'Mayfield'),
(1189, 35, 'Floyd', 'Mayweather'),
(1190, 35, 'Anthony', 'McAuliffe'),
(1191, 35, 'John', 'McCain'),
(1192, 72, 'Eugene', 'McCarthy'),
(1193, 72, 'Joseph', 'McCarthy'),
(1194, 72, 'Mary', 'McCarthy'),
(1195, 72, 'Paul', 'McCartney'),
(1196, 72, 'Susan', 'McClary'),
(1197, 72, 'Nellie', 'McClung'),
(1198, 6, 'William', 'McFee'),
(1199, 6, 'Bryant', 'McGill'),
(1200, 6, 'Patrick', 'McGoohan'),
(1201, 6, 'Al', 'McGuire'),
(1202, 92, 'Charles', 'McKay'),
(1203, 92, 'Loreena', 'McKennitt'),
(1204, 92, 'Marshall', 'McLuhan'),
(1205, 92, 'Vince', 'McMahon'),
(1206, 92, 'Steve', 'McNair'),
(1207, 26, 'Robert', 'McNamara'),
(1208, 26, 'Linda', 'McQuaig'),
(1209, 26, 'Margaret', 'Mead'),
(1210, 26, 'Evan', 'Mecham'),
(1211, 9, 'Michael', 'Medved'),
(1212, 9, 'Golda', 'Meir'),
(1213, 9, 'Katie', 'Melua'),
(1214, 9, 'Herman', 'Melville'),
(1215, 9, 'Alexander', 'Men'),
(1216, 46, 'H. L.', 'Mencken'),
(1217, 46, 'Natalie', 'Merchant'),
(1218, 46, 'Freddie', 'Mercury'),
(1219, 46, 'Rena', 'Mero'),
(1220, 46, 'Joseph', 'Merrick'),
(1221, 46, 'James', 'Michener'),
(1222, 83, 'Bette', 'Midler'),
(1223, 83, 'Ludwig', 'Mies van der Rohe'),
(1224, 83, 'Alyssa', 'Milano'),
(1225, 83, 'John Stuart', 'Mill'),
(1226, 83, 'Alex', 'Miller'),
(1227, 83, 'Arthur', 'Miller'),
(1228, 66, 'Bode', 'Miller'),
(1229, 66, 'Henry', 'Miller'),
(1230, 66, 'Ron', 'Miller'),
(1231, 66, 'Walter M.', 'Miller'),
(1232, 66, 'Spike', 'Milligan'),
(1233, 66, 'C. Wright', 'Mills'),
(1234, 103, 'A.A.', 'Milne'),
(1235, 103, 'Ceslaw', 'Milosz'),
(1236, 103, 'John', 'Milton'),
(1237, 103, 'Newton N.', 'Minow'),
(1238, 103, 'Ludwig von', 'Mises'),
(1239, 103, 'John', 'Mitchell'),
(1240, 86, 'Joni', 'Mitchell'),
(1241, 86, 'Shigeru', 'Miyamoto'),
(1242, 86, 'Nayla', 'Moawad'),
(1243, 86, 'René', 'Moawad'),
(1244, 86, 'Tevita', 'Momoedonu'),
(1245, 86, 'Jane', 'Monheit'),
(1246, 86, 'Marilyn', 'Monroe'),
(1247, 20, 'Michel de', 'Montaigne'),
(1248, 20, 'Charles de', 'Montesquieu'),
(1249, 20, 'Alan', 'Moore'),
(1250, 20, 'Dudley', 'Moore'),
(1251, 20, 'Michael', 'Moore'),
(1252, 57, 'Tim', 'Moore'),
(1253, 57, 'Evo', 'Morales'),
(1254, 57, 'Dylan', 'Moran'),
(1255, 57, 'Hannah', 'More'),
(1256, 57, 'St. Thomas', 'More'),
(1257, 57, 'Christian', 'Morgenstern'),
(1258, 57, 'Christopher', 'Morley'),
(1259, 40, 'Errol', 'Morris'),
(1260, 40, 'Mixmaster', 'Morris'),
(1261, 40, 'Jim', 'Morrison'),
(1262, 40, 'Robert', 'Morrison'),
(1263, 40, 'John', 'Mortimer'),
(1264, 40, 'Louis', 'Mountbatten'),
(1265, 77, 'Wolfgang Amadeus', 'Mozart'),
(1266, 77, 'Robert', 'Mugabe'),
(1267, 77, 'Holy Prophet', 'Muhammad'),
(1268, 77, 'John', 'Muir'),
(1269, 77, 'Megan', 'Mullally'),
(1270, 77, 'Dinah Maria', 'Mulock'),
(1271, 61, 'Lewis', 'Mumford'),
(1272, 61, 'Susie', 'Mumpfield'),
(1273, 61, 'Edvard', 'Munch'),
(1274, 61, 'Alice', 'Munro'),
(1275, 61, 'Edward R.', 'Murrow'),
(1276, 61, 'Benito', 'Mussolini'),
(1277, 98, 'Dave', 'Mustaine'),
(1278, 98, 'David', 'Myatt'),
(1279, 98, 'Vladimir', 'Nabokov'),
(1280, 98, 'Rabbi', 'Nachman'),
(1281, 98, 'Ralph', 'Nader'),
(1282, 98, 'Thomas', 'Nagel'),
(1283, 32, 'Richard', 'Naidu'),
(1284, 32, 'Adi Koila', 'Nailatikau'),
(1285, 32, 'Ratu Epeli Qaraninamu', 'Nailatikau'),
(1286, 32, 'Kathy', 'Najimy'),
(1287, 32, 'John Forbes', 'Nash'),
(1288, 32, 'Thomas', 'Nash'),
(1289, 15, 'Maciu', 'Navakasuasua'),
(1290, 15, 'Nicholas', 'Negroponte'),
(1291, 15, 'Hailey Anne', 'Nelson'),
(1292, 15, 'Horatio', 'Nelson'),
(1293, 15, 'Pablo', 'Neruda'),
(1294, 15, 'Bob', 'Newhart'),
(1295, 52, 'Isaac', 'Newton'),
(1296, 52, 'John', 'Newton'),
(1297, 52, 'Stevie', 'Nicks'),
(1298, 52, 'James', 'Nicoll'),
(1299, 52, 'Reinhold', 'Niebuhr'),
(1300, 52, 'Martin', 'Niemöller'),
(1301, 35, 'Friedrich', 'Nietzsche'),
(1302, 35, 'Florence', 'Nightingale'),
(1303, 35, 'Vaslav', 'Nijinsky'),
(1304, 35, 'Ana?s Nin', 'Nin'),
(1305, 72, 'Jacques', 'Ninio'),
(1306, 72, 'Sangeeta', 'Niranjan'),
(1307, 72, 'Larry', 'Niven'),
(1308, 72, 'Richard', 'Nixon'),
(1309, 72, 'Eli', 'Noam'),
(1310, 72, 'Joshua Abraham', 'Norton'),
(1311, 6, 'Ted', 'Nugent'),
(1312, 6, 'Duke', 'Nukem'),
(1313, 6, 'Gary', 'Null'),
(1314, 6, 'Abu', 'Nuwas'),
(1315, 6, 'Barack', 'Obama'),
(1316, 6, 'Conor', 'Oberst'),
(1317, 92, 'Conan', 'O''Brien'),
(1318, 92, 'Phil', 'Ochs'),
(1319, 92, 'Rosie', 'O''Donnell'),
(1320, 92, 'Adolf', 'Ogi'),
(1321, 92, 'David', 'Ogilvy'),
(1322, 92, 'Georgia', 'O''Keeffe'),
(1323, 26, 'Jamie', 'Oliver'),
(1324, 26, 'Robert T.', 'Oliver'),
(1325, 9, 'Ken', 'Olson'),
(1326, 9, 'Jacqueline Kennedy', 'Onassis'),
(1327, 9, 'William F.', 'Ondrick'),
(1328, 9, 'J. Robert', 'Oppenheimer'),
(1329, 9, 'Bill', 'O''Reilly'),
(1330, 46, 'P. J.', 'O''Rourke'),
(1331, 46, 'David', 'Ortiz'),
(1332, 46, 'George', 'Orwell'),
(1333, 46, 'Ozzy', 'Osbourne'),
(1334, 46, 'Arthur', 'O’Shaughnessy'),
(1335, 46, 'P. D.', 'Ouspensky'),
(1336, 83, 'Thomas', 'Overbury'),
(1337, 83, 'Jesse', 'Owens'),
(1338, 83, 'Dan', 'Owsen'),
(1339, 83, 'Larry', 'Page'),
(1340, 83, 'Satchel', 'Paige'),
(1341, 83, 'Thomas', 'Paine'),
(1342, 66, 'Chuck', 'Palahniuk'),
(1343, 66, 'Francis Turner', 'Palgrave'),
(1344, 66, 'Michael', 'Palin'),
(1345, 66, 'Olof', 'Palme'),
(1346, 66, 'Dorothy', 'Parker'),
(1347, 66, 'Dolly', 'Parton'),
(1348, 103, 'Blaise', 'Pascal'),
(1349, 103, 'Louis', 'Pasteur'),
(1350, 103, 'Walter', 'Pater'),
(1351, 103, 'Isabel', 'Paterson'),
(1352, 103, 'Saint', 'Patrick'),
(1353, 103, 'George S.', 'Patton'),
(1354, 86, 'Ron', 'Paul'),
(1355, 86, 'Wolfgang', 'Pauli'),
(1356, 86, 'Linus', 'Pauling'),
(1357, 86, 'Paul JJ', 'Payack'),
(1358, 86, 'Max', 'Payne'),
(1359, 86, 'John', 'Peel'),
(1360, 20, 'Charles', 'Peguy'),
(1361, 20, 'Charles Sanders', 'Peirce'),
(1362, 20, 'William', 'Penn'),
(1363, 20, 'Walker', 'Percy'),
(1364, 20, 'Shimon', 'Peres'),
(1365, 20, 'Andreas Paolo', 'Perger'),
(1366, 20, 'Richard', 'Perle'),
(1367, 57, 'Alan', 'Perlis'),
(1368, 57, 'Michael D.', 'Perry'),
(1369, 57, 'Oliver Hazard', 'Perry'),
(1370, 57, 'Fernando', 'Pessoa'),
(1371, 57, 'Dr. Laurence J.', 'Peter'),
(1372, 57, 'Gaius', 'Petronius'),
(1373, 40, 'Tom', 'Petty'),
(1374, 40, 'Michael', 'Phelps'),
(1375, 40, 'Duke of Edinburgh', 'Philip'),
(1376, 40, 'Emo', 'Philips'),
(1377, 40, 'Jean', 'Piaget'),
(1378, 40, 'Pablo', 'Picasso'),
(1379, 77, 'Josef', 'Pieper'),
(1380, 77, 'Steven', 'Pinker'),
(1381, 77, 'Roddy', 'Piper'),
(1382, 77, 'Fritiof Nilsson', 'Piraten'),
(1383, 77, 'Robert M.', 'Pirsig'),
(1384, 77, 'Sylvia', 'Plath'),
(1385, 60, 'Martha', 'Plimpton'),
(1386, 60, 'Edgar Allan', 'Poe'),
(1387, 60, 'Henri', 'Poincaré'),
(1388, 60, 'Roman', 'Polański'),
(1389, 60, 'Arthur', 'Ponsonby'),
(1390, 60, 'Alexander', 'Pope'),
(1391, 97, 'Karl', 'Popper'),
(1392, 97, 'Richard', 'Porson'),
(1393, 97, 'Jon', 'Postel'),
(1394, 97, 'Colin', 'Powell'),
(1395, 97, 'Terry', 'Pratchett'),
(1396, 97, 'Munshi', 'Premchand'),
(1397, 31, 'Elvis', 'Presley'),
(1398, 31, 'Joseph', 'Priestley'),
(1399, 31, 'P. J.', 'Proudhon'),
(1400, 31, 'Jade', 'Puget'),
(1401, 31, 'Hari', 'Punja'),
(1402, 31, 'Steve', 'Purcell'),
(1403, 31, 'Aleksandr', 'Pushkin'),
(1404, 14, 'Thomas', 'Pynchon'),
(1405, 14, 'Laisenia', 'Qarase'),
(1406, 14, 'Anthony', 'Quale'),
(1407, 14, 'Francis', 'Quarles'),
(1408, 14, 'Dan', 'Quayle'),
(1409, 14, 'Queen of Romania', 'Marie'),
(1410, 51, 'Willard van Orman', 'Quine'),
(1411, 51, 'Marcus Fabius', 'Quintilian'),
(1412, 51, 'Dan', 'Quisenberry'),
(1413, 51, 'Amitrajit', 'Raajan'),
(1414, 51, 'Fran?ois', 'Rabelais'),
(1415, 51, 'Yitzhak', 'Rabin'),
(1416, 34, 'Sitiveni', 'Rabuka'),
(1417, 34, 'Gilda', 'Radner'),
(1418, 34, 'Pramod', 'Rae'),
(1419, 34, 'Sir Walter', 'Raleigh'),
(1420, 34, 'Manny', 'Ramirez'),
(1421, 34, 'Ayn', 'Rand'),
(1422, 71, 'Leopold von', 'Ranke'),
(1423, 71, 'Arthur', 'Ransome'),
(1424, 71, 'Burton', 'Rascoe'),
(1425, 71, 'Jef', 'Raskin'),
(1426, 71, 'Asesela', 'Ravuvu'),
(1427, 71, 'Gene', 'Ray'),
(1428, 5, 'James Arthur', 'Ray'),
(1429, 5, 'Nancy', 'Reagan'),
(1430, 5, 'Ronald', 'Reagan'),
(1431, 5, 'Ron', 'Reagan'),
(1432, 5, 'Nigel', 'Rees'),
(1433, 5, 'Christopher', 'Reeve'),
(1434, 5, 'William', 'Rehnquist'),
(1435, 91, 'Wilhelm', 'Reich'),
(1436, 91, 'Harry', 'Reid'),
(1437, 91, 'George', 'Reisman'),
(1438, 91, 'Kenneth', 'Rexroth'),
(1439, 91, 'Condoleezza', 'Rice'),
(1440, 91, 'Keith', 'Richards'),
(1441, 25, 'Cardinal', 'Richelieu'),
(1442, 25, 'Hyman G.', 'Rickover'),
(1443, 25, 'Tim', 'Riley'),
(1444, 25, 'Rainer Maria', 'Rilke'),
(1445, 25, 'Arthur', 'Rimbaud'),
(1446, 25, 'Kelly', 'Ripa'),
(1447, 9, 'Scott', 'Ritter'),
(1448, 9, 'Joan', 'Rivers'),
(1449, 9, 'Anthony', 'Robbins'),
(1450, 9, 'Maximilien', 'Robespierre'),
(1451, 9, 'Jackie', 'Robinson'),
(1452, 9, 'Kim Stanley', 'Robinson'),
(1453, 46, 'Spider', 'Robinson'),
(1454, 46, 'John D.', 'Rockefeller'),
(1455, 46, 'Knute', 'Rockne'),
(1456, 46, 'Alex', 'Rodriguez'),
(1457, 46, 'Fred', 'Rogers'),
(1458, 46, 'Will', 'Rogers'),
(1459, 82, 'Ray', 'Romano'),
(1460, 82, 'Erwin', 'Rommel'),
(1461, 82, 'Eleanor', 'Roosevelt'),
(1462, 82, 'Franklin Delano', 'Roosevelt'),
(1463, 82, 'Theodore', 'Roosevelt'),
(1464, 82, 'Wayne', 'Rosing'),
(1465, 66, 'Geneen', 'Roth'),
(1466, 66, 'Philip', 'Roth'),
(1467, 66, 'Murray', 'Rothbard'),
(1468, 66, 'Baron', 'Rothschild'),
(1469, 66, 'Joseph', 'Roux'),
(1470, 66, 'Jean-Jacques', 'Rousseau'),
(1471, 103, 'Ratu Viliame', 'Rovabokola'),
(1472, 103, 'Arundhati', 'Roy'),
(1473, 103, 'Rita', 'Rudner'),
(1474, 103, 'Don Miguel', 'Ruiz'),
(1475, 103, 'Louis', 'Rukeyser'),
(1476, 103, 'Richard', 'Rumbold'),
(1477, 86, 'Jalal al-Din Muhammad', 'Rumi'),
(1478, 86, 'Donald', 'Rumsfeld'),
(1479, 86, 'Dustin', 'Runnels'),
(1480, 86, 'Willie', 'Rushton'),
(1481, 86, 'John', 'Ruskin'),
(1482, 86, 'Bertrand', 'Russell'),
(1483, 20, 'Nipsey', 'Russell'),
(1484, 20, 'Rosaland', 'Russell'),
(1485, 20, 'Babe', 'Ruth'),
(1486, 20, 'Ernest', 'Rutherford'),
(1487, 57, 'Ernesto', 'Sabato'),
(1488, 57, 'Donatien de', 'Sade'),
(1489, 57, 'Carl', 'Sagan'),
(1490, 57, 'Antoine de', 'Saint-Exupéry'),
(1491, 57, 'Louis de', 'Saint-Just'),
(1492, 57, 'Jonas', 'Salk'),
(1493, 40, 'J. D.', 'Salinger'),
(1494, 40, 'Margaret', 'Sanger'),
(1495, 40, 'José de', 'San Mart?n'),
(1496, 40, 'George', 'Santayana'),
(1497, 40, 'William', 'Saroyan'),
(1498, 77, 'Jean-Paul', 'Sartre'),
(1499, 77, 'Allen', 'Sarven'),
(1500, 77, 'Joe', 'Satriani'),
(1501, 77, 'Diane', 'Sawyer'),
(1502, 60, 'John Ralston', 'Saul'),
(1503, 60, 'John', 'Schaar'),
(1504, 60, 'Simon', 'Schama'),
(1505, 60, 'Friedrich von', 'Schiller'),
(1506, 60, 'Poul', 'Schlüter'),
(1507, 60, 'Bruce', 'Schneier'),
(1508, 97, 'Arthur', 'Schopenhauer'),
(1509, 97, 'Gerhard', 'Schröder'),
(1510, 97, 'Budd', 'Schulberg'),
(1511, 97, 'Charles M.', 'Schultz'),
(1512, 97, 'Albert', 'Schweitzer'),
(1513, 97, 'Jeremy', 'Seabrook'),
(1514, 31, 'Steven', 'Seagal'),
(1515, 31, 'David', 'Sedaris'),
(1516, 31, 'John', 'Sedgwick'),
(1517, 31, 'Lucy', 'Seigle'),
(1518, 31, 'George', 'Seldes'),
(1519, 31, 'Peter', 'Sellers'),
(1520, 14, 'Rod', 'Serling'),
(1521, 14, 'Miguel', 'Serrano'),
(1522, 14, 'Dr.', 'Seuss'),
(1523, 14, 'Israel', 'Shahak'),
(1524, 14, 'William', 'Shakespeare'),
(1525, 14, 'Tupac', 'Shakur'),
(1526, 14, 'Ravi', 'Shankar'),
(1527, 51, 'Al', 'Sharpton'),
(1528, 51, 'George Bernard', 'Shaw'),
(1529, 51, 'Hartley', 'Shawcross'),
(1530, 51, 'Barry', 'Sheck'),
(1531, 51, 'John', 'Shedd'),
(1532, 34, 'Mary Wollstonecraft', 'Shelley'),
(1533, 34, 'Percy Bysshe', 'Shelley'),
(1534, 34, 'Richard Brinsley', 'Sheridan'),
(1535, 34, 'William Tecumseh', 'Sherman'),
(1536, 34, 'Eduard', 'Shevardnadze'),
(1537, 34, 'Mike', 'Shinoda'),
(1538, 71, 'James', 'Shirley'),
(1539, 71, 'Arthur', 'Schopenhauer'),
(1540, 71, 'Mataji Nirmala', 'Shrivastava'),
(1541, 71, 'Jerry', 'Siegel'),
(1542, 71, 'Clifford D.', 'Simak'),
(1543, 71, 'Paul', 'Simon'),
(1544, 5, 'Jack', 'Simpson'),
(1545, 5, 'Jessica', 'Simpson'),
(1546, 5, 'Upton', 'Sinclair'),
(1547, 5, 'Isaac Bashevis', 'Singer'),
(1548, 5, 'Navjot Singh', 'Sidhu'),
(1549, 5, 'Raman Pratap', 'Singh'),
(1550, 91, 'Sir Vijay', 'Singh'),
(1551, 91, 'Edith', 'Sitwell'),
(1552, 91, 'Grace', 'Slick'),
(1553, 91, 'Yakov', 'Smirnoff'),
(1554, 91, 'Adam', 'Smith'),
(1555, 91, 'Anna Nicole', 'Smith'),
(1556, 25, 'Elliott', 'Smith'),
(1557, 25, 'Gordon', 'Smith'),
(1558, 25, 'Joseph', 'Smith'),
(1559, 25, 'Kevin', 'Smith'),
(1560, 25, 'Logan Pearsall', 'Smith'),
(1561, 25, 'Margaret Chase', 'Smith'),
(1562, 25, 'Sydney', 'Smith'),
(1563, 8, 'Tobias', 'Smollett'),
(1564, 8, 'Jan Christiaan', 'Smuts'),
(1565, 8, 'Jan L. A. van de', 'Snepscheut'),
(1566, 8, 'Carrie', 'Snow'),
(1567, 8, 'Joseph', 'Sobran'),
(1568, 45, 'Alexander', 'Solzhenitsyn'),
(1569, 45, 'Susan', 'Sontag'),
(1570, 45, 'Aaron', 'Sorkin'),
(1571, 45, 'George', 'Soros'),
(1572, 45, 'Thomas', 'Southerne'),
(1573, 45, 'Thomas', 'Sowell'),
(1574, 82, 'Max', 'Sparber'),
(1575, 82, 'Britney', 'Spears'),
(1576, 82, 'Jan van', 'Speijk'),
(1577, 82, 'Gerry', 'Spence'),
(1578, 82, 'Herbert', 'Spencer'),
(1579, 82, 'Steven', 'Spielberg'),
(1580, 82, 'Baruch', 'Spinoza'),
(1581, 65, 'Benjamin', 'Spock'),
(1582, 65, 'Joel', 'Spolsky'),
(1583, 65, 'Bruce', 'Springsteen'),
(1584, 65, 'Charles Haddon', 'Spurgeon'),
(1585, 65, 'Joseph', 'Stalin'),
(1586, 65, 'Richard M', 'Stallman'),
(1587, 102, 'Henry Morton', 'Stanley'),
(1588, 102, 'Elizabeth Cady', 'Stanton'),
(1589, 102, 'Ringo', 'Starr'),
(1590, 102, 'Vincent', 'Starrett'),
(1591, 102, 'Gertrude', 'Stein'),
(1592, 102, 'Herbert', 'Stein'),
(1593, 102, 'John', 'Steinbeck'),
(1594, 85, 'Gloria', 'Steinem'),
(1595, 85, 'Neal', 'Stephenson'),
(1596, 85, 'Bruce', 'Sterling'),
(1597, 85, 'Wallace', 'Stevens'),
(1598, 85, 'Adlai', 'Stevenson'),
(1599, 85, 'Robert Louis', 'Stevenson'),
(1600, 19, 'James', 'Stewart'),
(1601, 19, 'Jon', 'Stewart'),
(1602, 19, 'Ben', 'Stein'),
(1603, 19, 'Henry L.', 'Stimson'),
(1604, 19, 'Leopold', 'Stokowski'),
(1605, 19, 'I. F.', 'Stone'),
(1606, 56, 'Lucy', 'Stone'),
(1607, 56, 'W. Clement', 'Stone'),
(1608, 56, 'James R.', 'Stoner Jr.'),
(1609, 56, 'Tom', 'Stoppard'),
(1610, 56, 'Rex', 'Stout'),
(1611, 56, 'Madeleine', 'Stowe'),
(1612, 39, 'Lord', 'Stratford'),
(1613, 39, 'Richard', 'Strauss'),
(1614, 39, 'Igor', 'Stravinsky'),
(1615, 39, 'Bjarne', 'Stroustrup'),
(1616, 39, 'Theodore', 'Sturgeon'),
(1617, 39, 'Ratu Sir Lala', 'Sukuna'),
(1618, 39, 'Lucius Cornelius', 'Sulla'),
(1619, 76, 'Kiefer', 'Sutherland'),
(1620, 76, 'Alexander Vasilyevich', 'Suvorov'),
(1621, 76, 'Shunryu', 'Suzuka'),
(1622, 76, 'Emanuel', 'Swedenborg'),
(1623, 76, 'Skye', 'Sweetnam'),
(1624, 60, 'Jonathan', 'Swift'),
(1625, 60, 'Charles Algernon', 'Swinburne'),
(1626, 60, 'Charles', 'Swindoll'),
(1627, 60, 'Publilius', 'Syrus'),
(1628, 60, 'Leo', 'Szilard'),
(1629, 60, 'Rabindranath', 'Tagore'),
(1630, 60, 'Nassim Nicholas', 'Taleb'),
(1631, 97, 'Deborah', 'Tannen'),
(1632, 97, 'Sharon', 'Tate'),
(1633, 97, 'Kaliopate', 'Tavola'),
(1634, 97, 'Pyotr Ilyich', 'Tchaikovsky'),
(1635, 97, 'Pierre', 'Teilhard de Chardin'),
(1636, 30, 'Alfred', 'Tennyson'),
(1637, 30, 'Nikola', 'Tesla'),
(1638, 30, 'William', 'Thackeray'),
(1639, 30, 'Margaret', 'Thatcher'),
(1640, 30, 'Charlize', 'Theron'),
(1641, 30, 'Dorothy', 'Thompson'),
(1642, 14, 'Hunter S.', 'Thompson');
INSERT INTO `Asmuo` (`asmensID`, `miestoID`, `vardas`, `pavarde`) VALUES
(1643, 14, 'William', 'Thomson'),
(1644, 14, 'Henry David', 'Thoreau'),
(1645, 14, 'Ben', 'Throttle'),
(1646, 14, 'James', 'Thurber'),
(1647, 14, 'Josip Broz', 'Tito'),
(1648, 51, 'Alexis de', 'Tocqueville'),
(1649, 51, 'Tzvetan', 'Todorov'),
(1650, 51, 'Koichi', 'Tohei'),
(1651, 51, 'J. R. R.', 'Tolkien'),
(1652, 51, 'Leo', 'Tolstoy'),
(1653, 51, 'Lily', 'Tomlin'),
(1654, 51, 'Apisai', 'Tora'),
(1655, 34, 'Joe', 'Torre'),
(1656, 34, 'Linus', 'Torvalds'),
(1657, 34, 'Arnold', 'Toynbee'),
(1658, 34, 'Arnold Joseph', 'Toynbee'),
(1659, 34, 'James A.', 'Traficant'),
(1660, 71, 'Simon', 'Travaglia'),
(1661, 71, 'P. L.', 'Travers'),
(1662, 71, 'Anthony', 'Trollope'),
(1663, 71, 'Leon', 'Trotsky'),
(1664, 71, 'Pierre', 'Trudeau'),
(1665, 71, 'Harry S.', 'Truman'),
(1666, 5, 'Donald', 'Trump'),
(1667, 5, 'Sojourner', 'Truth'),
(1668, 5, 'Gideon', 'Tucker'),
(1669, 5, 'John', 'Tudor'),
(1670, 5, 'Manasa', 'Tugia'),
(1671, 5, 'Esala', 'Tuibua'),
(1672, 91, 'Ted', 'Turner'),
(1673, 91, 'Harry', 'Turtledove'),
(1674, 91, 'Desmond', 'Tutu'),
(1675, 91, 'Mark', 'Twain'),
(1676, 91, 'William Marcy', 'Tweed'),
(1677, 91, 'Frank', 'Tyger'),
(1678, 91, 'Kenneth', 'Tynan'),
(1679, 25, 'Tristan', 'Tzara'),
(1680, 25, 'Morihei', 'Ueshiba'),
(1681, 25, 'Miguel de', 'Unamuno'),
(1682, 25, 'John', 'Updike'),
(1683, 25, 'Peter', 'Ustinov'),
(1684, 25, 'Jack', 'Valenti'),
(1685, 8, 'Paul', 'Valéry'),
(1686, 8, 'Jack', 'Vance'),
(1687, 8, 'Vincent', 'Van Gogh'),
(1688, 8, 'Edgard', 'Varese'),
(1689, 8, 'Jesse', 'Ventura'),
(1690, 8, 'Ken', 'Venturi'),
(1691, 8, 'Gore', 'Vidal'),
(1692, 45, 'Swami', 'Vivekananda'),
(1693, 45, 'Paul', 'Vixie'),
(1694, 45, 'Theodore', 'Von Karman'),
(1695, 45, 'Kurt', 'Vonnegut'),
(1696, 45, 'Josefa', 'Vosanibola'),
(1697, 45, 'Norman D.', 'Vaughan'),
(1698, 82, 'Jane', 'Wagner'),
(1699, 82, 'Rufus', 'Wainwright'),
(1700, 82, 'Denis', 'Waitley'),
(1701, 82, 'Tom', 'Waits'),
(1702, 82, 'Tim', 'Walberg'),
(1703, 82, 'Jimbo', 'Wales'),
(1704, 65, 'Lech', 'Walesa'),
(1705, 65, 'Christopher', 'Walken'),
(1706, 65, 'Murray', 'Walker'),
(1707, 65, 'Larry', 'Wall'),
(1708, 65, 'Alan', 'Wallace'),
(1709, 65, 'David Foster', 'Wallace'),
(1710, 65, 'Josaia', 'Waqabaca'),
(1711, 102, 'Taito', 'Waradi'),
(1712, 102, 'Andy', 'Warhol'),
(1713, 102, 'Harold', 'Warner'),
(1714, 102, 'Earl', 'Warren'),
(1715, 102, 'Rick', 'Warren'),
(1716, 102, 'Robert Penn', 'Warren'),
(1717, 85, 'Booker T.', 'Washington'),
(1718, 85, 'George', 'Washington'),
(1719, 85, 'Martha', 'Washington'),
(1720, 85, 'Thomas J.', 'Watson'),
(1721, 85, 'Bill', 'Watterson'),
(1722, 19, 'Alan', 'Watts'),
(1723, 19, 'Evelyn', 'Waugh'),
(1724, 19, 'David', 'Weber'),
(1725, 19, 'Daniel', 'Webster'),
(1726, 19, 'Noah', 'Webster'),
(1727, 19, 'Simone', 'Weil'),
(1728, 19, 'David', 'Weinberger'),
(1729, 56, 'Jack', 'Welch'),
(1730, 56, 'Orson', 'Welles'),
(1731, 56, 'Arthur', 'Wellesley'),
(1732, 56, 'H. G.', 'Wells'),
(1733, 56, 'Paul', 'Wellstone'),
(1734, 56, 'John', 'Wesley'),
(1735, 39, 'Mae', 'West'),
(1736, 39, 'Morris', 'West'),
(1737, 39, 'Joss', 'Whedon'),
(1738, 39, 'Andrew Dickson', 'White'),
(1739, 76, 'E. B.', 'White'),
(1740, 76, 'Reggie', 'White'),
(1741, 76, 'T. H.', 'White'),
(1742, 59, 'Alfred North', 'Whitehead'),
(1743, 59, 'Walt', 'Whitman'),
(1744, 59, 'John Greenleaf', 'Whittier'),
(1745, 59, 'Elie', 'Wiesel'),
(1746, 59, 'Ken', 'Wilber'),
(1747, 59, 'William', 'Wilberforce'),
(1748, 96, 'Ella Wheeler', 'Wilcox'),
(1749, 96, 'Oscar', 'Wilde'),
(1750, 96, 'Thornton', 'Wilder'),
(1751, 96, 'Maurice', 'Wilkes'),
(1752, 96, 'Robin', 'Williams'),
(1753, 96, 'Roger', 'Williams'),
(1754, 30, 'Ted', 'Williams'),
(1755, 30, 'Tennessee', 'Williams'),
(1756, 30, 'Henry', 'Williamson'),
(1757, 30, 'Robert Anton', 'Wilson'),
(1758, 30, 'Brian', 'Wilson'),
(1759, 30, 'Colin', 'Wilson'),
(1760, 13, 'Flip', 'Wilson'),
(1761, 13, 'Ron', 'Wilson'),
(1762, 13, 'Woodrow', 'Wilson'),
(1763, 13, 'Oprah', 'Winfrey'),
(1764, 13, 'Michael', 'Winner'),
(1765, 13, 'William', 'Winter'),
(1766, 50, 'April', 'Winchell'),
(1767, 50, 'Walter', 'Winchell'),
(1768, 50, 'Ludwig', 'Wittgenstein'),
(1769, 50, 'P. G.', 'Wodehouse'),
(1770, 50, 'Christian', 'Wolff'),
(1771, 50, 'Paul', 'Wolfowitz'),
(1772, 33, 'Bob', 'Woodward'),
(1773, 33, 'Virginia', 'Woolf'),
(1774, 33, 'William', 'Wordsworth'),
(1775, 33, 'Steve', 'Wozniak'),
(1776, 33, 'Frank Lloyd', 'Wright'),
(1777, 33, 'Steven', 'Wright'),
(1778, 70, 'Wilbur', 'Wright'),
(1779, 70, 'Ron', 'Wyden'),
(1780, 70, 'Philip', 'Wylie'),
(1781, 70, 'Eugene S.', 'Wilson'),
(1782, 70, 'Isoroku', 'Yamamoto'),
(1783, 70, 'Edward', 'Yashinsky'),
(1784, 4, 'William Butler', 'Yeats'),
(1785, 4, 'Boris', 'Yeltsin'),
(1786, 4, 'Francis Parker', 'Yockey'),
(1787, 4, 'Thom', 'Yorke'),
(1788, 4, 'Takeo', 'Yoshida'),
(1789, 4, 'Cy', 'Young'),
(1790, 90, 'Edward', 'Young'),
(1791, 90, 'Neil', 'Young'),
(1792, 90, 'Tyler Shell', 'Young'),
(1793, 90, 'Henny', 'Youngman'),
(1794, 90, 'Marguerite', 'Yourcenar'),
(1795, 90, 'Lin', 'Yutang'),
(1796, 90, 'Stephanie', 'Zacharek'),
(1797, 24, 'Frank', 'Zappa'),
(1798, 24, 'Jamie', 'Zawinski'),
(1799, 24, 'Theodore', 'Zeldin'),
(1800, 24, 'Zig', 'Ziglar'),
(1801, 24, 'Philip', 'Zimmermann'),
(1802, 24, 'Kenneth', 'Zinck'),
(1803, 8, 'Howard', 'Zinn'),
(1804, 8, 'Emile', 'Zola');

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

--
-- Table structure for table `InternetoPlanas`
--

CREATE TABLE IF NOT EXISTS `InternetoPlanas` (
  `internetoPlanoID` int(11) NOT NULL AUTO_INCREMENT,
  `operatoriausID` int(11) NOT NULL,
  `intPlanoPavadinimas` varchar(25) NOT NULL,
  `kiekisMB` int(11) NOT NULL,
  `kaina` decimal(5,2) NOT NULL,
  `papildomaKaina` decimal(4,2) DEFAULT NULL,
  PRIMARY KEY (`internetoPlanoID`),
  KEY `operatoriausID` (`operatoriausID`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=21 ;

--
-- Dumping data for table `InternetoPlanas`
--

INSERT INTO `InternetoPlanas` (`internetoPlanoID`, `operatoriausID`, `intPlanoPavadinimas`, `kiekisMB`, `kaina`, `papildomaKaina`) VALUES
(1, 1, 'Iki 5MB', 5, 0.00, 0.00),
(2, 1, 'Iki 50MB', 50, 2.50, 0.00),
(3, 1, 'Iki 200MB', 200, 5.25, 0.00),
(4, 1, 'Iki 400MB', 400, 8.75, 0.00),
(5, 1, 'Iki 800MB', 800, 12.25, 0.00),
(6, 1, 'Iki 2GB', 2048, 17.50, 0.05),
(7, 2, '50MB telefone', 50, 2.06, 0.05),
(8, 2, '250MB telefone', 250, 6.55, 0.05),
(9, 2, '1GB telefone', 1024, 15.85, 0.05),
(10, 2, '4GB telefone', 4096, 29.65, 0.01),
(11, 2, 'Nemokamai 300MB', 300, 0.00, 0.00),
(12, 2, 'Nemokamai 1GB', 1024, 0.00, 0.00),
(13, 2, 'Nemokamai 2GB', 2048, 0.00, 0.00),
(14, 2, 'Nemokamai 4GB', 4096, 0.00, 0.00),
(15, 2, 'Nemokamai 10MB', 10, 0.00, 0.00),
(16, 2, 'Nemokamai 1,5GB', 1536, 0.00, 0.00),
(17, 3, 'Internetas 50MB', 50, 1.89, 0.50),
(18, 3, 'Internetas 250MB', 250, 5.89, 0.50),
(19, 3, 'Internetas 1GB', 1024, 14.00, 0.50),
(20, 3, 'Internetas 5GB', 5120, 29.00, 0.50);

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

--
-- Table structure for table `Lengvata`
--

CREATE TABLE IF NOT EXISTS `Lengvata` (
  `lengvatosID` int(11) NOT NULL AUTO_INCREMENT,
  `rinkinioID` int(11) NOT NULL,
  `kiekis` int(11) NOT NULL,
  `kaina` decimal(5,2) NOT NULL,
  PRIMARY KEY (`lengvatosID`),
  KEY `rinkinioID` (`rinkinioID`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=14 ;

--
-- Dumping data for table `Lengvata`
--

INSERT INTO `Lengvata` (`lengvatosID`, `rinkinioID`, `kiekis`, `kaina`) VALUES
(1, 1, 100, 0.00),
(2, 27, 100, 0.00),
(3, 32, 400, 0.00),
(4, 33, 10000, 0.00),
(5, 37, 150, 0.00),
(6, 38, 150, 0.00),
(7, 42, 150, 0.00),
(8, 43, 150, 0.00),
(9, 52, 50, 0.00),
(10, 57, 100, 0.00),
(11, 62, 300, 0.00),
(12, 67, 500, 0.00),
(13, 95, 300, 0.00);

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

--
-- Table structure for table `Miestas`
--

CREATE TABLE IF NOT EXISTS `Miestas` (
  `miestoID` int(11) NOT NULL AUTO_INCREMENT,
  `miestoPavadinimas` varchar(20) NOT NULL,
  PRIMARY KEY (`miestoID`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=104 ;

--
-- Dumping data for table `Miestas`
--

INSERT INTO `Miestas` (`miestoID`, `miestoPavadinimas`) VALUES
(1, 'Vilnius'),
(2, 'Kaunas'),
(3, 'KlaipÄ—da'),
(4, 'Å iauliai'),
(5, 'Panevėžys'),
(6, 'Alytus'),
(7, 'MarijampolÄ—'),
(8, 'Mažeikiai'),
(9, 'Jonava'),
(10, 'Utena'),
(11, 'KÄ—dainiai'),
(12, 'TelÅiai'),
(13, 'Visaginas'),
(14, 'TauragÄ—'),
(15, 'UkmergÄ—'),
(16, 'PlungÄ—'),
(17, 'Kretinga'),
(18, 'Å ilutÄ—'),
(19, 'RadviliÅkis'),
(20, 'Palanga'),
(21, 'Gargždai'),
(22, 'Druskininkai'),
(23, 'RokiÅkis'),
(24, 'Biržai'),
(25, 'ElektrÄ—nai'),
(26, 'Garliava'),
(27, 'KurÅÄ—nai'),
(28, 'Jurbarkas'),
(29, 'VilkaviÅkis'),
(30, 'Raseiniai'),
(31, 'AnykÅĨiai'),
(32, 'Lentvaris'),
(33, 'GrigiÅkÄ—s'),
(34, 'Naujoji AkmenÄ—'),
(35, 'Prienai'),
(36, 'JoniÅkis'),
(37, 'KelmÄ—'),
(38, 'VarÄ—na'),
(39, 'KaiÅiadorys'),
(40, 'Pasvalys'),
(41, 'KupiÅkis'),
(42, 'Zarasai'),
(43, 'Skuodas'),
(44, 'MolÄ—tai'),
(45, 'Kazlų Rūda'),
(46, 'Å irvintos'),
(47, 'ŠalĨininkai'),
(48, 'Å akiai'),
(49, 'PabradÄ—'),
(50, 'ŠvenĨionėliai'),
(51, 'Å ilalÄ—'),
(52, 'Ignalina'),
(53, 'NemenĨinė'),
(54, 'Kybartai'),
(55, 'ŠvenĨionys'),
(56, 'Pakruojis'),
(57, 'Trakai'),
(58, 'Vievis'),
(59, 'Kalvarija'),
(60, 'Lazdijai'),
(61, 'Neringa'),
(62, 'Rietavas'),
(63, 'Žiežmariai'),
(64, 'EiÅiÅkÄ—s'),
(65, 'Ariogala'),
(66, 'BirÅtonas'),
(67, 'Å eduva'),
(68, 'Venta'),
(69, 'TytuvÄ—nai'),
(70, 'AkmenÄ—'),
(71, 'RÅ«diÅkÄ—s'),
(72, 'Vilkija'),
(73, 'ViekÅniai'),
(74, 'PagÄ—giai'),
(75, 'Žagarė'),
(76, 'Ežerėlis'),
(77, 'Kudirkos Naumiestis'),
(78, 'GelgaudiÅkis'),
(79, 'SkaudvilÄ—'),
(80, 'Salantai'),
(81, 'Linkuva'),
(82, 'Simnas'),
(83, 'Ramygala'),
(84, 'PriekulÄ—'),
(85, 'Veisiejai'),
(86, 'Daugai'),
(87, 'JoniÅkÄ—lis'),
(88, 'Jieznas'),
(89, 'Obeliai'),
(90, 'Virbalis'),
(91, 'Varniai'),
(92, 'Seda'),
(93, 'Vabalninkas'),
(94, 'Baltoji VokÄ—'),
(95, 'SubaĨius'),
(96, 'DÅ«kÅtas'),
(97, 'PandÄ—lys'),
(98, 'Užventis'),
(99, 'Dusetos'),
(100, 'Kavarskas'),
(101, 'Smalininkai'),
(102, 'TroÅkÅ«nai'),
(103, 'PanemunÄ—');

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

--
-- Table structure for table `OperatoriausPapildomaPaslauga`
--

CREATE TABLE IF NOT EXISTS `OperatoriausPapildomaPaslauga` (
  `oprPapildomosPslgsID` int(11) NOT NULL AUTO_INCREMENT,
  `operatoriausID` int(11) NOT NULL,
  `papildomosPaslaugosID` int(11) NOT NULL,
  `kaina` decimal(5,2) NOT NULL,
  PRIMARY KEY (`oprPapildomosPslgsID`),
  KEY `operatoriausID` (`operatoriausID`),
  KEY `papildomosPaslaugosID` (`papildomosPaslaugosID`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=10 ;

--
-- Dumping data for table `OperatoriausPapildomaPaslauga`
--

INSERT INTO `OperatoriausPapildomaPaslauga` (`oprPapildomosPslgsID`, `operatoriausID`, `papildomosPaslaugosID`, `kaina`) VALUES
(1, 1, 1, 1.00),
(2, 1, 2, 1.00),
(3, 1, 3, 1.00),
(4, 2, 1, 1.00),
(5, 2, 2, 1.00),
(6, 2, 3, 1.00),
(7, 3, 1, 1.00),
(8, 3, 2, 1.00),
(9, 3, 3, 1.00);

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

--
-- Table structure for table `Operatorius`
--

CREATE TABLE IF NOT EXISTS `Operatorius` (
  `operatoriausID` int(11) NOT NULL AUTO_INCREMENT,
  `operatoriausPavadinimas` char(10) NOT NULL,
  PRIMARY KEY (`operatoriausID`),
  UNIQUE KEY `UQ_Operatorius_operatoriausPavadinimas` (`operatoriausPavadinimas`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;

--
-- Dumping data for table `Operatorius`
--

INSERT INTO `Operatorius` (`operatoriausID`, `operatoriausPavadinimas`) VALUES
(1, 'Bitė'),
(2, 'Omnitel'),
(3, 'Tele2');

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

--
-- Table structure for table `PapildomaPaslauga`
--

CREATE TABLE IF NOT EXISTS `PapildomaPaslauga` (
  `papildomosPaslaugosID` int(11) NOT NULL AUTO_INCREMENT,
  `papildomosPaslaugosPavadinimas` varchar(40) NOT NULL,
  PRIMARY KEY (`papildomosPaslaugosID`),
  UNIQUE KEY `UQ_PapildomaPaslauga_papildomosPaslaugosPavadinimas` (`papildomosPaslaugosPavadinimas`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;

--
-- Dumping data for table `PapildomaPaslauga`
--

INSERT INTO `PapildomaPaslauga` (`papildomosPaslaugosID`, `papildomosPaslaugosPavadinimas`) VALUES
(1, 'Mobilusis elektroninis parašas, Lt/mėn.'),
(3, 'Numerio nerodymas skambinant, Lt/mėn.'),
(2, 'Rūpestingi tėvai, Lt/mėn.');

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

--
-- Table structure for table `Paslauga`
--

CREATE TABLE IF NOT EXISTS `Paslauga` (
  `paslaugosID` int(11) NOT NULL AUTO_INCREMENT,
  `paslaugosPavadinimas` varchar(50) NOT NULL,
  PRIMARY KEY (`paslaugosID`),
  UNIQUE KEY `UQ_Paslauga_paslaugosPavadinimas` (`paslaugosPavadinimas`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=7 ;

--
-- Dumping data for table `Paslauga`
--

INSERT INTO `Paslauga` (`paslaugosID`, `paslaugosPavadinimas`) VALUES
(3, 'Multimedijos žinutės (MMS), Lt/MMS.'),
(1, 'Skambučiai į Lietuvos tinklus, Lt/min.'),
(4, 'Skambučiai į užsienio tinklus, Lt/min.'),
(2, 'Trumposios žinutės (SMS) į Lietuvos tinklus, Lt/SM'),
(5, 'Trumposios žinutės (SMS) į užsienio tinklus, Lt/SM'),
(6, 'Vaizdo skambutis, Lt/min.');

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

--
-- Table structure for table `PaslaugosKainaZonoje`
--

CREATE TABLE IF NOT EXISTS `PaslaugosKainaZonoje` (
  `operatoriausID` int(11) NOT NULL,
  `paslaugosID` int(11) NOT NULL,
  `zonosID` int(11) NOT NULL,
  `kaina` decimal(5,2) NOT NULL,
  `inicijuotaZonoje` tinyint(1) NOT NULL,
  PRIMARY KEY (`operatoriausID`,`paslaugosID`,`zonosID`),
  KEY `operatoriausID` (`operatoriausID`),
  KEY `paslaugosID` (`paslaugosID`),
  KEY `zonosID` (`zonosID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `PaslaugosKainaZonoje`
--

INSERT INTO `PaslaugosKainaZonoje` (`operatoriausID`, `paslaugosID`, `zonosID`, `kaina`, `inicijuotaZonoje`) VALUES
(1, 4, 1, 2.90, 0),
(1, 4, 2, 3.90, 0),
(1, 4, 3, 5.50, 0),
(1, 4, 4, 30.00, 0),
(2, 4, 1, 2.00, 0),
(2, 4, 2, 3.07, 0),
(2, 4, 3, 6.20, 0),
(2, 4, 4, 27.59, 0),
(3, 4, 1, 1.88, 0),
(3, 4, 2, 1.88, 0),
(3, 4, 3, 5.60, 0),
(3, 4, 4, 25.42, 0);

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

--
-- Table structure for table `Planas`
--

CREATE TABLE IF NOT EXISTS `Planas` (
  `planoID` int(11) NOT NULL AUTO_INCREMENT,
  `tipoID` int(11) NOT NULL,
  `operatoriausID` int(11) NOT NULL,
  `planoPavadinimas` varchar(30) NOT NULL,
  `kaina` decimal(4,2) NOT NULL,
  `internetoPlanoID` int(11) DEFAULT NULL,
  PRIMARY KEY (`planoID`),
  KEY `internetoPlanoID` (`internetoPlanoID`),
  KEY `operatoriausID` (`operatoriausID`),
  KEY `tipoID` (`tipoID`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=21 ;

--
-- Dumping data for table `Planas`
--

INSERT INTO `Planas` (`planoID`, `tipoID`, `operatoriausID`, `planoPavadinimas`, `kaina`, `internetoPlanoID`) VALUES
(1, 1, 1, 'Kartais', 9.00, NULL),
(2, 1, 1, 'Laisvė', 25.00, NULL),
(3, 1, 2, 'Išmaniems S', 28.00, 11),
(4, 1, 2, 'Išmaniems M', 33.00, 12),
(5, 1, 2, 'Išmaniems L', 39.00, 13),
(6, 1, 2, 'Išmaniems XL', 49.00, 14),
(7, 1, 2, 'Mano 9', 9.00, 15),
(8, 1, 2, 'Mano 19', 19.00, 15),
(9, 1, 2, 'Jauniems', 23.00, NULL),
(10, 1, 2, 'Naršymui', 23.00, 16),
(11, 1, 2, 'Neribotai', 23.00, NULL),
(12, 1, 3, 'Planas 50', 4.00, NULL),
(13, 1, 3, 'Planas 100', 8.00, NULL),
(14, 1, 3, 'Planas 300', 15.00, NULL),
(15, 1, 3, 'Planas 500', 18.00, NULL),
(16, 1, 3, 'Planas PIGIAU', 21.00, NULL),
(17, 1, 3, 'Planas PIGIAU + 1GB', 29.00, NULL),
(18, 1, 3, 'Planas PIGIAU + 3GB', 39.00, NULL),
(19, 1, 3, 'Planas PIGIAU + 5GB', 49.00, NULL),
(20, 1, 3, 'Planas Užsienis', 30.00, NULL);

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

--
-- Table structure for table `PlanoRinkinys`
--

CREATE TABLE IF NOT EXISTS `PlanoRinkinys` (
  `rinkinioID` int(11) NOT NULL AUTO_INCREMENT,
  `planoID` int(11) NOT NULL,
  `paslaugosID` int(11) NOT NULL,
  `kaina` decimal(4,2) NOT NULL,
  PRIMARY KEY (`rinkinioID`),
  KEY `paslaugosID` (`paslaugosID`),
  KEY `planoID` (`planoID`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=98 ;

--
-- Dumping data for table `PlanoRinkinys`
--

INSERT INTO `PlanoRinkinys` (`rinkinioID`, `planoID`, `paslaugosID`, `kaina`) VALUES
(1, 1, 1, 0.20),
(2, 1, 2, 0.20),
(3, 1, 3, 1.00),
(4, 2, 1, 0.00),
(5, 2, 2, 0.00),
(6, 2, 3, 1.00),
(7, 3, 1, 0.00),
(8, 3, 2, 0.00),
(9, 3, 3, 0.19),
(10, 3, 5, 0.46),
(11, 3, 6, 0.76),
(12, 4, 1, 0.00),
(13, 4, 2, 0.00),
(14, 4, 3, 0.19),
(15, 4, 5, 0.46),
(16, 4, 6, 0.76),
(17, 5, 1, 0.00),
(18, 5, 2, 0.00),
(19, 5, 3, 0.19),
(20, 5, 5, 0.46),
(21, 5, 6, 0.76),
(22, 6, 1, 0.00),
(23, 6, 2, 0.00),
(24, 6, 3, 0.19),
(25, 6, 5, 0.46),
(26, 6, 6, 0.76),
(27, 7, 1, 0.23),
(28, 7, 2, 0.19),
(29, 7, 3, 0.19),
(30, 7, 5, 0.46),
(31, 7, 6, 0.76),
(32, 8, 1, 0.23),
(33, 8, 2, 0.19),
(34, 8, 3, 0.19),
(35, 8, 5, 0.46),
(36, 8, 6, 0.76),
(37, 9, 1, 0.23),
(38, 9, 2, 0.19),
(39, 9, 3, 0.19),
(40, 9, 5, 0.46),
(41, 9, 6, 0.76),
(42, 10, 1, 0.23),
(43, 10, 2, 0.19),
(44, 10, 3, 0.19),
(45, 10, 5, 0.46),
(46, 10, 6, 0.76),
(47, 11, 1, 0.00),
(48, 11, 2, 0.00),
(49, 11, 3, 0.19),
(50, 11, 5, 0.46),
(51, 11, 6, 0.76),
(52, 12, 1, 0.22),
(53, 12, 2, 0.18),
(54, 12, 3, 0.35),
(55, 12, 5, 0.40),
(56, 12, 6, 0.35),
(57, 13, 1, 0.22),
(58, 13, 2, 0.18),
(59, 13, 3, 0.35),
(60, 13, 5, 0.40),
(61, 13, 6, 0.35),
(62, 14, 1, 0.22),
(63, 14, 2, 0.18),
(64, 14, 3, 0.35),
(65, 14, 5, 0.40),
(66, 14, 6, 0.35),
(67, 15, 1, 0.22),
(68, 15, 2, 0.18),
(69, 15, 3, 0.35),
(70, 15, 5, 0.40),
(71, 15, 6, 0.35),
(72, 16, 1, 0.00),
(73, 16, 2, 0.00),
(74, 16, 3, 0.35),
(75, 16, 5, 0.40),
(76, 16, 6, 0.35),
(77, 17, 1, 0.00),
(78, 17, 2, 0.00),
(79, 17, 3, 0.35),
(80, 17, 5, 0.40),
(81, 17, 6, 0.35),
(82, 18, 1, 0.00),
(83, 18, 2, 0.00),
(84, 18, 3, 0.35),
(85, 18, 5, 0.40),
(86, 18, 6, 0.35),
(87, 19, 1, 0.00),
(88, 19, 2, 0.00),
(89, 19, 3, 0.35),
(90, 19, 5, 0.40),
(91, 19, 6, 0.35),
(92, 20, 1, 0.22),
(93, 20, 2, 0.18),
(94, 20, 3, 0.35),
(95, 20, 4, 1.88),
(96, 20, 5, 0.40),
(97, 20, 6, 0.35);

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

--
-- Table structure for table `PlanoTipas`
--

CREATE TABLE IF NOT EXISTS `PlanoTipas` (
  `tipoID` int(11) NOT NULL AUTO_INCREMENT,
  `tipoPavadinimas` varchar(20) NOT NULL,
  PRIMARY KEY (`tipoID`),
  UNIQUE KEY `UQ_PlanoTipas_tipoPavadinimas` (`tipoPavadinimas`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;

--
-- Dumping data for table `PlanoTipas`
--

INSERT INTO `PlanoTipas` (`tipoID`, `tipoPavadinimas`) VALUES
(1, 'Privatiems'),
(2, 'Verslui');

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

--
-- Table structure for table `RysysInternetu`
--

CREATE TABLE IF NOT EXISTS `RysysInternetu` (
  `abonentoID` int(11) NOT NULL,
  `kiekisMB` decimal(5,2) NOT NULL,
  `rysioPradzia` datetime NOT NULL,
  `rysioPabaiga` datetime NOT NULL,
  KEY `abonentoID` (`abonentoID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `RysysP2P`
--

CREATE TABLE IF NOT EXISTS `RysysP2P` (
  `abonentoID` int(11) NOT NULL,
  `rysioInicializavimoVieta` char(6) DEFAULT NULL,
  `adresatoID` char(6) DEFAULT NULL,
  `paslaugosID` int(11) NOT NULL,
  `adresatoNumeris` varchar(15) NOT NULL,
  `rysioPradzia` datetime NOT NULL,
  `rysioPabaiga` datetime NOT NULL,
  KEY `abonentoID` (`abonentoID`),
  KEY `paslaugosID` (`paslaugosID`),
  KEY `rysioInicializavimoVieta` (`rysioInicializavimoVieta`,`adresatoID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `Salis`
--

CREATE TABLE IF NOT EXISTS `Salis` (
  `saliesKodas` char(6) NOT NULL,
  `zonosID` int(11) NOT NULL,
  `saliesPavadinimas` varchar(40) NOT NULL,
  KEY `zonosID` (`zonosID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `Salis`
--

INSERT INTO `Salis` (`saliesKodas`, `zonosID`, `saliesPavadinimas`) VALUES
('353', 1, 'Airija'),
('355', 1, 'Albanija'),
('376', 1, 'Andora'),
('43', 1, 'Austrija'),
('32', 1, 'Belgija'),
('387', 1, 'Bosnija ir Hercogovina'),
('359', 1, 'Bulgarija'),
('420', 1, 'Čekija'),
('45', 1, 'Danija'),
('44', 1, 'Didžioji Britanija'),
('372', 1, 'Estija'),
('30', 1, 'Graikija'),
('354', 1, 'Islandija'),
('34', 1, 'Ispanija'),
('39', 1, 'Italija'),
('382', 1, 'Juodkalnija'),
('357', 1, 'Kipras'),
('385', 1, 'Kroatija'),
('371', 1, 'Latvija'),
('48', 1, 'Lenkija'),
('423', 1, 'Lichtenšteinas'),
('352', 1, 'Liuksemburgas'),
('389', 1, 'Makedonija'),
('356', 1, 'Malta'),
('377', 1, 'Monakas'),
('47', 1, 'Norvegija'),
('31', 1, 'Olandija'),
('351', 1, 'Portugalija'),
('33', 1, 'Prancūzija'),
('40', 1, 'Rumunija'),
('378', 1, 'San Marinas'),
('381', 1, 'Serbija'),
('421', 1, 'Slovakija'),
('386', 1, 'Slovėnija'),
('358', 1, 'Suomija'),
('46', 1, 'Švedija'),
('41', 1, 'Šveicarija'),
('39', 1, 'Vatikanas'),
('36', 1, 'Vengrija'),
('49', 1, 'Vokietija'),
('374', 2, 'Armėnija'),
('994', 2, 'Azerbaidžanas'),
('375', 2, 'Baltarusija'),
('995', 2, 'Gruzija'),
('996', 2, 'Kirgizija'),
('373', 2, 'Moldova'),
('7', 2, 'Rusija'),
('992', 2, 'Tadžikistanas'),
('993', 2, 'Turkmenistanas'),
('380', 2, 'Ukraina'),
('998', 2, 'Uzbekistanas'),
('93', 3, 'Afganistanas'),
('213', 3, 'Alžyras'),
('684', 3, 'Amerikos Samoa'),
('244', 3, 'Angola'),
('1268', 3, 'Antigva ir Barbuda'),
('54', 3, 'Argentina'),
('297', 3, 'Aruba'),
('61', 3, 'Australija'),
('1242', 3, 'Bahamų salos'),
('973', 3, 'Bahreinas'),
('880', 3, 'Bangladešas'),
('1246', 3, 'Barbadosas'),
('501', 3, 'Belizas'),
('229', 3, 'Beninas'),
('1441', 3, 'Bermudų salos'),
('591', 3, 'Bolivija'),
('267', 3, 'Bostvana'),
('55', 3, 'Brazilija'),
('673', 3, 'Brunėjus'),
('226', 3, 'Burkina Fasas'),
('257', 3, 'Burundis'),
('975', 3, 'Butanas'),
('236', 3, 'Centrinės Afrikos Respublika'),
('235', 3, 'Čadas'),
('56', 3, 'Čilė'),
('247', 3, 'Dangun Žengimo salos'),
('1284', 3, 'Didžiosios Britanijos Mergelių Salos'),
('253', 3, 'Džibutis'),
('20', 3, 'Egiptas'),
('593', 3, 'Ekvadoras'),
('251', 3, 'Etiopija'),
('298', 3, 'Farerų salos'),
('679', 3, 'Fidžis'),
('63', 3, 'Filipinai'),
('241', 3, 'Gabonas'),
('592', 3, 'Gajana'),
('220', 3, 'Gambija'),
('233', 3, 'Gana'),
('1299', 3, 'Grenlandija'),
('509', 3, 'Haitis'),
('504', 3, 'Hondūras'),
('852', 3, 'Honkongas'),
('91', 3, 'Indija'),
('62', 3, 'Indonezija'),
('964', 3, 'Irakas'),
('98', 3, 'Iranas'),
('972', 3, 'Izraelis'),
('1876', 3, 'Jamaika'),
('81', 3, 'Japonija'),
('1', 3, 'JAV'),
('971', 3, 'Jungtiniai Arabų Emyratai'),
('855', 3, 'Kambodža'),
('237', 3, 'Kamerūnas'),
('86', 3, 'Kinija'),
('57', 3, 'Kolumbija'),
('53', 3, 'Kuba'),
('506', 3, 'Kosta Rika'),
('965', 3, 'Kuveitas'),
('961', 3, 'Libanas'),
('231', 3, 'Liberija'),
('218', 3, 'Libija'),
('261', 3, 'Madagaskaras'),
('60', 3, 'Malaizija'),
('212', 3, 'Marokas'),
('52', 3, 'Meksika'),
('976', 3, 'Mongolija'),
('258', 3, 'Mozambikas'),
('64', 3, 'Naujoji Zelandija'),
('234', 3, 'Nigerija'),
('227', 3, 'Nigeris'),
('92', 3, 'Pakistanas'),
('595', 3, 'Paragvajus'),
('51', 3, 'Peru'),
('27', 3, 'Pietų Afrikos Respublika'),
('82', 3, 'Pietų Korėja'),
('1787', 3, 'Puerto Rikas'),
('670', 3, 'Rytų Timoras'),
('250', 3, 'Ruanda'),
('503', 3, 'Salvadoras'),
('966', 3, 'Saudo Arabija'),
('65', 3, 'Singapūras'),
('963', 3, 'Sirija'),
('249', 3, 'Sudanas'),
('850', 3, 'Šiaurės Korėja'),
('94', 3, 'Šri Lanka'),
('66', 3, 'Tailandas'),
('886', 3, 'Taivanas'),
('228', 3, 'Togas'),
('1868', 3, 'Trinidadas ir Tobagas'),
('216', 3, 'Tunisas'),
('90', 3, 'Turkija'),
('256', 3, 'Uganda'),
('598', 3, 'Urugvajus'),
('58', 3, 'Venesuela'),
('84', 3, 'Vietnamas'),
('260', 3, 'Zambija'),
('263', 3, 'Zimbabvė'),
('238', 3, 'Kabo Verdė'),
('87', 4, 'Palydovinis Ryšys - 1'),
('881', 4, 'Palydovinis Ryšys - 2'),
('882', 4, 'Palydovinis Ryšys - 3');

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

--
-- Table structure for table `UzsakomaLengvata`
--

CREATE TABLE IF NOT EXISTS `UzsakomaLengvata` (
  `komplektoID` int(11) NOT NULL AUTO_INCREMENT,
  `rinkinioID` int(11) NOT NULL,
  `kiekis` int(11) NOT NULL,
  `kaina` decimal(5,2) NOT NULL,
  PRIMARY KEY (`komplektoID`),
  KEY `rinkinioID` (`rinkinioID`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=6 ;

--
-- Dumping data for table `UzsakomaLengvata`
--

INSERT INTO `UzsakomaLengvata` (`komplektoID`, `rinkinioID`, `kiekis`, `kaina`) VALUES
(1, 2, 70, 5.00),
(2, 2, 400, 7.50),
(3, 28, 10000, 4.00),
(4, 33, 10000, 4.00),
(5, 43, 10000, 1.00);

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

--
-- Table structure for table `UzsakytaLengvata`
--

CREATE TABLE IF NOT EXISTS `UzsakytaLengvata` (
  `abonentoID` int(11) NOT NULL,
  `komplektoID` int(11) NOT NULL,
  `uzsakymoData` datetime NOT NULL,
  `atsisakymoData` datetime DEFAULT NULL,
  KEY `komplektoID` (`komplektoID`),
  KEY `abonentoID` (`abonentoID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `UzsakytaPapildomaPaslauga`
--

CREATE TABLE IF NOT EXISTS `UzsakytaPapildomaPaslauga` (
  `abonentoID` int(11) NOT NULL,
  `oprPapildomosPslgsID` int(11) NOT NULL,
  `uzsakymoData` datetime NOT NULL,
  `atsisakymoData` datetime DEFAULT NULL,
  KEY `abonentoID` (`abonentoID`),
  KEY `oprPapildomosPslgsID` (`oprPapildomosPslgsID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `UzsakytasInternetoPlanas`
--

CREATE TABLE IF NOT EXISTS `UzsakytasInternetoPlanas` (
  `internetoPlanoID` int(11) NOT NULL,
  `abonentoID` int(11) NOT NULL,
  `uzsakymoData` datetime NOT NULL,
  `atsisakymoData` datetime DEFAULT NULL,
  KEY `abonentoID` (`abonentoID`),
  KEY `internetoPlanoID` (`internetoPlanoID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `Zona`
--

CREATE TABLE IF NOT EXISTS `Zona` (
  `zonosID` int(11) NOT NULL AUTO_INCREMENT,
  `zonosPavadinimas` varchar(40) NOT NULL,
  PRIMARY KEY (`zonosID`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;

--
-- Dumping data for table `Zona`
--

INSERT INTO `Zona` (`zonosID`, `zonosPavadinimas`) VALUES
(1, 'Europa (Zona 1)'),
(2, 'Rusija ir NVS šalys (Zona 2)'),
(3, 'Kitos šalys (Zona 3)'),
(4, 'Palydovinio ryšio abonentai (Zona 4)');

--
-- Constraints for dumped tables
--

--
-- Constraints for table `Abonentas`
--
ALTER TABLE `Abonentas`
  ADD CONSTRAINT `FK_Abonentas_Asmuo` FOREIGN KEY (`asmensID`) REFERENCES `Asmuo` (`asmensID`),
  ADD CONSTRAINT `FK_Abonentas_Planas` FOREIGN KEY (`planoID`) REFERENCES `Planas` (`planoID`);

--
-- Constraints for table `Asmuo`
--
ALTER TABLE `Asmuo`
  ADD CONSTRAINT `FK_Asmuo_Miestas` FOREIGN KEY (`miestoID`) REFERENCES `Miestas` (`miestoID`);

--
-- Constraints for table `InternetoPlanas`
--
ALTER TABLE `InternetoPlanas`
  ADD CONSTRAINT `FK_InternetoPlanas_Operatorius` FOREIGN KEY (`operatoriausID`) REFERENCES `Operatorius` (`operatoriausID`);

--
-- Constraints for table `Lengvata`
--
ALTER TABLE `Lengvata`
  ADD CONSTRAINT `FK_Lengvata_PlanoRinkinys` FOREIGN KEY (`rinkinioID`) REFERENCES `PlanoRinkinys` (`rinkinioID`);

--
-- Constraints for table `OperatoriausPapildomaPaslauga`
--
ALTER TABLE `OperatoriausPapildomaPaslauga`
  ADD CONSTRAINT `FK_OperatoriausPapildomaPaslauga_Operatorius` FOREIGN KEY (`operatoriausID`) REFERENCES `Operatorius` (`operatoriausID`),
  ADD CONSTRAINT `FK_OperatoriausPapildomaPaslauga_PapildomaPaslauga` FOREIGN KEY (`papildomosPaslaugosID`) REFERENCES `PapildomaPaslauga` (`papildomosPaslaugosID`);

--
-- Constraints for table `PaslaugosKainaZonoje`
--
ALTER TABLE `PaslaugosKainaZonoje`
  ADD CONSTRAINT `FK_PaslaugosKainaZonoje_Operatorius` FOREIGN KEY (`operatoriausID`) REFERENCES `Operatorius` (`operatoriausID`),
  ADD CONSTRAINT `FK_PaslaugosKainaZonoje_Paslauga` FOREIGN KEY (`paslaugosID`) REFERENCES `Paslauga` (`paslaugosID`),
  ADD CONSTRAINT `FK_PaslaugosKainaZonoje_Zona` FOREIGN KEY (`zonosID`) REFERENCES `Zona` (`zonosID`);

--
-- Constraints for table `Planas`
--
ALTER TABLE `Planas`
  ADD CONSTRAINT `FK_Planas_InternetoPlanas` FOREIGN KEY (`internetoPlanoID`) REFERENCES `InternetoPlanas` (`internetoPlanoID`),
  ADD CONSTRAINT `FK_Planas_Operatorius` FOREIGN KEY (`operatoriausID`) REFERENCES `Operatorius` (`operatoriausID`),
  ADD CONSTRAINT `FK_Planas_PlanoTipas` FOREIGN KEY (`tipoID`) REFERENCES `PlanoTipas` (`tipoID`);

--
-- Constraints for table `PlanoRinkinys`
--
ALTER TABLE `PlanoRinkinys`
  ADD CONSTRAINT `FK_PlanoRinkinys_Paslauga` FOREIGN KEY (`paslaugosID`) REFERENCES `Paslauga` (`paslaugosID`),
  ADD CONSTRAINT `FK_PlanoRinkinys_Planas` FOREIGN KEY (`planoID`) REFERENCES `Planas` (`planoID`);

--
-- Constraints for table `RysysInternetu`
--
ALTER TABLE `RysysInternetu`
  ADD CONSTRAINT `FK_RysysInternetu_Abonentas` FOREIGN KEY (`abonentoID`) REFERENCES `Abonentas` (`abonentoID`);

--
-- Constraints for table `RysysP2P`
--
ALTER TABLE `RysysP2P`
  ADD CONSTRAINT `FK_RysysP2P_Abonentas` FOREIGN KEY (`abonentoID`) REFERENCES `Abonentas` (`abonentoID`),
  ADD CONSTRAINT `FK_RysysP2P_Paslauga` FOREIGN KEY (`paslaugosID`) REFERENCES `Paslauga` (`paslaugosID`);

--
-- Constraints for table `Salis`
--
ALTER TABLE `Salis`
  ADD CONSTRAINT `FK_Salis_Zona` FOREIGN KEY (`zonosID`) REFERENCES `Zona` (`zonosID`);

--
-- Constraints for table `UzsakomaLengvata`
--
ALTER TABLE `UzsakomaLengvata`
  ADD CONSTRAINT `FK_UzsakomaLengvata_PlanoRinkinys` FOREIGN KEY (`rinkinioID`) REFERENCES `PlanoRinkinys` (`rinkinioID`);

--
-- Constraints for table `UzsakytaLengvata`
--
ALTER TABLE `UzsakytaLengvata`
  ADD CONSTRAINT `FK_UzsakytaLengvata_Abonentas` FOREIGN KEY (`abonentoID`) REFERENCES `Abonentas` (`abonentoID`),
  ADD CONSTRAINT `FK_UzsakytaLengvata_UzsakomaLengvata` FOREIGN KEY (`komplektoID`) REFERENCES `UzsakomaLengvata` (`komplektoID`);

--
-- Constraints for table `UzsakytaPapildomaPaslauga`
--
ALTER TABLE `UzsakytaPapildomaPaslauga`
  ADD CONSTRAINT `FK_UzsakytaPaslauga_Abonentas` FOREIGN KEY (`abonentoID`) REFERENCES `Abonentas` (`abonentoID`),
  ADD CONSTRAINT `FK_UzsakytaPaslauga_OperatoriausPapildomaPaslauga` FOREIGN KEY (`oprPapildomosPslgsID`) REFERENCES `OperatoriausPapildomaPaslauga` (`oprPapildomosPslgsID`);

--
-- Constraints for table `UzsakytasInternetoPlanas`
--
ALTER TABLE `UzsakytasInternetoPlanas`
  ADD CONSTRAINT `FK_UzsakytasInternetoPlanas_Abonentas` FOREIGN KEY (`abonentoID`) REFERENCES `Abonentas` (`abonentoID`),
  ADD CONSTRAINT `FK_UzsakytasInternetoPlanas_InternetoPlanas` FOREIGN KEY (`internetoPlanoID`) REFERENCES `InternetoPlanas` (`internetoPlanoID`);

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