-- phpMyAdmin SQL Dump
-- version 4.8.4
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1:3306
-- Generation Time: Feb 27, 2022 at 10:33 AM
-- Server version: 5.7.24
-- PHP Version: 7.3.1

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


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `weevils_db`
--

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

--
-- Table structure for table `genus`
--

DROP TABLE IF EXISTS `genus`;
CREATE TABLE IF NOT EXISTS `genus` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `genus` varchar(100) NOT NULL,
  `user_id` int(10) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=24 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `genus`
--

INSERT INTO `genus` (`id`, `genus`, `user_id`) VALUES
(1, 'Blosyrodes', 1),
(2, 'Blosyrus', 1),
(3, 'Catapionus', 2),
(4, 'Cratopus', 3),
(5, 'Dermatoxenus', 5),
(6, 'Eustalida', 5),
(7, 'Episomus', 6),
(8, 'Lachnotarsus', 6),
(9, 'Parapionus', 6),
(10, 'Cyrtozemia', 7),
(11, 'Malosomus', 8),
(12, 'Opseorhinus', 8),
(13, 'Nothognathus', 9),
(14, 'Amphorygma', 10),
(15, 'Brachyxystus', 10),
(16, 'Catorygma', 10),
(17, 'Drepanoderes', 10),
(18, 'Pachyrhinus', 11),
(19, 'Sphingorrhinotus', 12),
(21, 'Eugnathus', 15),
(22, 'Trachyodes', 14),
(23, 'Trachyphloeosoma', 14);

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

--
-- Table structure for table `species_subt_genus_table`
--

DROP TABLE IF EXISTS `species_subt_genus_table`;
CREATE TABLE IF NOT EXISTS `species_subt_genus_table` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `species_subt` varchar(50) NOT NULL,
  `user_id` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=325 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `species_subt_genus_table`
--

INSERT INTO `species_subt_genus_table` (`id`, `species_subt`, `user_id`) VALUES
(107, 'Peltotrachelus rugipennis', 26),
(106, 'Peltotrachelus horridus', 26),
(105, 'Peltotrachelus cognatus', 26),
(104, 'Peltotrachelus maculosus', 26),
(103, 'Peltotrachelus albopubes', 26),
(102, 'Peltotrachelus pubes', 26),
(101, 'Peltotrachelus propinquus', 26),
(100, 'Peltotrachelus juvencus', 26),
(99, 'Parascaphus quardiscutellatus', 25),
(98, 'Parascaphus albosetosus', 25),
(97, 'Parascaphus orthoscapus', 25),
(96, 'Parascaphus dalbergiae', 25),
(95, 'Parascaphus vittacollis', 25),
(94, 'Parascaphus gobicollis', 25),
(93, 'Paramycter cuprescens', 24),
(92, 'Paramycter trivitticonis', 24),
(91, 'Paramycter setiepistomus', 24),
(90, 'Oedophrys rufiscutallatus', 23),
(89, 'Neomyllocerus dohertyi', 22),
(88, 'Neomyllocerus incultus', 22),
(87, 'Neomyllocerus inaptus', 22),
(86, 'Neomyllocerus pubeseens', 22),
(85, 'Neomyllocerus rectirostris', 22),
(84, 'Neomyllocerus moratus', 22),
(83, 'Neomyllocerus spinipectus', 22),
(82, 'Meionops aspersus', 21),
(81, 'Himachala squamifrons', 20),
(80, 'Himachala fulveascens', 20),
(79, 'Hypenephorus cylindricollis', 19),
(78, 'Hypenephorus inermis', 19),
(77, 'Hypenephorus albus', 19),
(76, 'Hirsutopes magaoculatus', 18),
(75, 'Hirsutopes andamanensis', 18),
(74, 'Himachala squamifrons', 17),
(73, 'Himachala fulveascens', 17),
(72, 'Hilaus chlorosquamosus', 16),
(71, 'Hilus bidentulus', 16),
(70, 'Hemerus virens', 15),
(69, 'Hamartus instabilis', 14),
(68, 'Eryngus fuscotarsis', 13),
(67, 'Epixynus clavus', 12),
(66, 'Epius minutus', 11),
(65, 'Epius megbalayensis', 11),
(64, 'Drymopboetus modestus', 10),
(63, 'Drymophoetus multicostatus', 10),
(62, 'Doliophron tenuicornis', 9),
(61, 'Doliophron gracilicornis', 9),
(60, 'Cyrtepistomus frontalis', 8),
(59, 'Cyrtepistomus championi', 8),
(58, 'Cyrtepistomus planus', 8),
(57, 'Cyrtepistomus vinctus', 8),
(56, 'Cyrtepistomus sulcifrons', 8),
(55, 'Cyrtepistomus chloris', 8),
(54, 'Cyrtepistomus lanatus', 8),
(53, 'Cyrterpistomus tuberculatus', 8),
(52, 'Cyrtepistomus rudis', 8),
(51, 'Cyrtepistomus varicolor', 8),
(50, 'Cyrtepistomus infidelis', 8),
(49, 'Cyrtepistomus himachalensis', 8),
(48, 'Cyrtepistomus jucundus', 8),
(47, 'Cyrtepistomus herbicola', 8),
(46, 'Cyrtepistomus pini', 8),
(45, 'Cyrtepistomus subcostatus', 8),
(44, 'Cyrtepistomus qularis', 8),
(43, 'Cyphicerus sticticus', 7),
(42, 'Cyphicerus longipilis', 7),
(41, 'Cyphicerus labifer', 7),
(40, 'Cyphicerus sesquilineis', 7),
(39, 'Cyphicerus ornatus', 7),
(38, 'Cyphicerus bidentipes', 7),
(37, 'Cyphicerus alsus', 7),
(36, 'Cyphicerus surdus', 7),
(35, 'Cyphicerus graniger', 7),
(34, 'Cyphicerus nudimalis', 7),
(33, 'Cyphicerus lineatus', 7),
(32, 'Cypicerus longicornis', 7),
(31, 'Cypbicerus novemlineatus', 7),
(30, 'Cyphicerus pardalis', 7),
(29, 'Cyphicerus passerinus', 7),
(28, 'Cyphicerus zizyphi', 7),
(27, 'Cyphicerus humeralis', 7),
(26, 'Cyphicerus necopinus', 7),
(25, 'Cyphicerus emarginatus', 7),
(24, 'Cyphicerinus andamanicus', 6),
(23, 'Cypbicerinus nepalensis', 6),
(22, 'Cyphicerinus hirsutus', 6),
(21, 'Cyphicerinus pannosus', 6),
(20, 'Cyphicerinus tectonae', 6),
(19, 'Crinorrhinus nebulosus', 5),
(18, 'Crinorrhinus sparsutus', 5),
(17, 'Crinorrhinus sartus', 5),
(16, 'Crinorrhinus griseus', 5),
(15, 'Crinorrhinus cuprisetus', 5),
(14, 'Crinorrhinus approximans', 5),
(13, 'Crinorrhinus foveifrons', 5),
(12, 'Aspidomycter lunatus', 4),
(11, 'Aspidomycter lsfroyi', 4),
(10, 'Aspidomycter laesicollis', 4),
(9, 'Amrikus glebossus', 3),
(8, 'Amrikus deplanatus', 3),
(7, 'Amblyrrbinus subrecticollis', 2),
(6, 'Amblyrrhinus cavirostris', 2),
(5, 'AmbIyrrhinus minuticornis', 2),
(4, 'Amblyrrhinus posticus', 2),
(3, 'Amblyrhinus poricollis', 2),
(2, 'Agrostes quadrinotatus', 1),
(1, 'Agrostes varisetis', 1),
(108, 'Pholicerus nigroderma', 27),
(109, 'Piezophrys hebes', 28),
(110, 'Piezophrys cruciatus', 28),
(111, 'Piezophrys superciliatns', 28),
(112, 'Piezophrys patuloepistomus', 28),
(113, 'Piezophrys subchloris', 28),
(114, 'Piezophrys alboscutellatus', 28),
(115, 'Piezophrys punctostriatus', 28),
(116, 'Platymycterus himalayanus', 29),
(117, 'Platymycterus feae', 29),
(118, 'Platymycterus deceptor', 29),
(119, 'Platymycterus moestus', 29),
(120, 'Platymycterus sjostedti', 29),
(121, 'Rhicnostomus terrenus', 30),
(122, 'Scaeorrhinus boops', 31),
(123, 'Scaeorrhinus tardus', 31),
(124, 'Tanyscapus compressus', 32),
(125, 'Taractor indicus', 33),
(126, 'Thalponomus theae', 34),
(127, 'Thalponomus ornatus', 34),
(128, 'Thlipsomerus darjeelingensis', 35),
(129, 'Thlipsomerus quadrimaculatus', 35),
(130, 'Thlipsomerus nigromaculatus', 35),
(131, 'Thlipsomerus albosquamosus', 35),
(132, 'Thlipsomerus foveicollis', 35),
(133, 'Thlipsomerus subcosticollis', 35),
(134, 'Thyraulus prasinus', 36),
(135, 'Thyraulus crinitus', 36),
(136, 'Acanthotrachelus griseus', 37),
(137, 'Acanthotrachelus sharpi', 37),
(138, 'Acanthotrachelus ventricosus', 37),
(139, 'Breviepistomus spinosus', 38),
(140, 'Gobinda frontosulcatus', 39),
(141, 'Heteroptochus devians', 40),
(142, 'Lagenolobus adspersus', 41),
(143, 'Lagenolobus borupi', 41),
(144, 'Lagenolobus impar', 41),
(145, 'Lagenolobus pubescens', 41),
(146, 'Lagenolobus tutus', 41),
(147, 'Nirala bengalensis', 42),
(148, 'Psidiopsis filicornis', 43),
(149, 'Tolmesis mollis', 44),
(150, 'Transptochus conrostris', 45),
(151, 'Transptochus vitticollis', 45),
(152, 'Arhines languidus', 46),
(153, 'Emperorrhinus defpoliator', 47),
(154, 'Holorrhynchus integrirostris', 48),
(159, 'Myllocerus Schoenherr', 49),
(160, 'Ptochus Schoenherr', 50),
(161, 'Stelorrhinus carinirostris', 51),
(162, 'Indophytoscapbus chandigarhensis', 52),
(163, 'Indophytoscapbus sensarmai', 52),
(164, 'Phytoscaphus triangularis', 53),
(165, 'Phytoscaphus egregius', 53),
(166, 'Phytoscaphus lineatus', 53),
(167, 'Phytoscaphus decorus', 53),
(168, 'Phytoscaphus tamarixus', 53),
(169, 'Phytoscaphus orthideres', 53),
(170, 'Phytoscaphus virgatus', 53),
(171, 'Phytoscaphus crispus', 53),
(172, 'Phytoscaphus tenuirostris', 53),
(173, 'Phytoscaphus fractivirgatus', 53),
(174, 'Phytoscaphus chlorolateralus', 53),
(175, 'Phytoscaphus liratirostris', 53),
(176, 'Phytoscaphus fuscofasciatus', 53),
(177, 'Phytoscaphus marshalli', 53),
(178, 'Phytoscaphus chloroticus', 53),
(179, 'Pseudphytoscaphus annuloscutellus', 54),
(180, 'Pseudphytoscaphus bovei', 54),
(181, 'Pseudphytoscaphus nubilus', 54),
(182, 'Pseudphytoscaphus shillongensis', 54),
(183, 'Pseudphytoscaphus manoji', 54),
(184, 'Anemeroides erinaceus', 55),
(185, 'Esamus (Esamus) andrewesi', 56),
(186, 'Krauseus agrestis', 57),
(187, 'Phacephorus bimaculatus', 58),
(188, 'Phaenoderus viridulus', 59),
(189, 'Scepticus noxius', 60),
(190, 'Scepticus nubifer', 60),
(191, 'Scepticus caesius', 60),
(192, 'Tanymecus chloroleucus', 61),
(193, 'Tanymecus sciurus', 61),
(194, 'Tanymecus chevrolati', 61),
(195, 'Tanymecus andrewesi', 61),
(196, 'Tanymecus pertusiventris', 61),
(197, 'Tanymecus hercules', 61),
(198, 'Tanymecus obscurus', 61),
(199, 'Tanymecus simplex', 61),
(200, 'Tanymecus xanthurus', 61),
(201, 'Tanymecus mixtus', 61),
(202, 'Tanymecus marginalis', 61),
(203, 'Tanymecus arenaceus', 61),
(204, 'Tanymecus lentus', 61),
(205, 'Tanymecus piger', 61),
(206, 'Tanymecus deceptor', 61),
(207, 'Tanymecus lefroyi', 61),
(208, 'Tanymecus lacordairei', 61),
(209, 'Tanymecus circumdatus', 61),
(210, 'Tanymecus albomarginatus', 61),
(211, 'Tanymecus versicolor', 61),
(212, 'Tanymecus longulus', 61),
(213, 'Tanymecus feae', 61),
(214, 'Tanymecus princeps', 61),
(215, 'Tanymecus hispidus', 61),
(216, 'Tanymecus hirticeps', 61),
(217, 'Tanymecus indicus', 61),
(218, 'Tanymecus tetricus', 61),
(219, 'Tanymecus parvus', 61),
(220, 'Tanymecus curviscapus', 61),
(221, 'Tanymecus modicus', 61),
(222, 'Tanymecus konbiranus', 61),
(223, 'Tanymecus agrestis', 61),
(224, 'Tanymecus lectus', 61),
(225, 'Tanymecus thompsoni', 61),
(226, 'Tanymecus tectonae', 61),
(227, 'Tanymecus bhagwani', 61),
(228, 'Tanymecus pseudomarginalis', 61),
(229, 'Achlainomus tabindus', 62),
(230, 'Achlainomus ebeninus', 62),
(231, 'Achlainomus fausti', 62),
(232, 'Achlainomus bazinus', 62),
(233, 'Atmetonychus peregrinus', 63),
(234, 'Burmotragus metallescens', 64),
(235, 'Hypomeces', 65),
(236, 'Indomias acutipennis', 66),
(237, 'Indomias ajaykumari', 66),
(238, 'Indomias albizziae', 66),
(239, 'Indomias anamalainus', 66),
(240, 'Indomias beesoni', 66),
(241, 'Indomias cretaceus', 66),
(242, 'Indomias decipiens', 66),
(243, 'Indomias dubeyi', 66),
(244, 'Indomias frater', 66),
(245, 'Indomias hispidus', 66),
(246, 'Indomias kriparami', 66),
(247, 'Indomias lividus', 66),
(248, 'Indomias maicykuttyae', 66),
(249, 'Indomias mangalai', 66),
(250, 'Indomias marshalli', 66),
(251, 'Indomias mayarami', 66),
(252, 'Indomias menoni', 66),
(253, 'Indomias perroteti', 66),
(254, 'Indomias praeteritus', 66),
(255, 'Indomias prasinus', 66),
(256, 'Indomias premlali', 66),
(257, 'Indomias rajendrani', 66),
(258, 'Indomias ramakrishnani', 66),
(259, 'Indomias sharanagoudai', 66),
(260, 'Indomias yercaudensis', 66),
(261, 'Lepidospyris albomaculatus', 67),
(262, 'Lepidospyris cretacea', 67),
(263, 'Lepidospyris demissa', 67),
(264, 'Leptomias angustatus', 69),
(265, 'Leptomias audax', 69),
(266, 'Leptomias bimaculatus', 69),
(267, 'Leptomias bipustulatus', 69),
(268, 'Leptomias bituberculatus', 69),
(269, 'Leptomias clavicrus', 69),
(270, 'Leptomias costatus', 69),
(271, 'Leptomias curtus', 69),
(272, 'Leptomias dilatipes', 69),
(273, 'Leptomias elongatulus', 69),
(274, 'Leptomias gibbus', 69),
(275, 'Leptomias indicus', 69),
(276, 'Leptomias invidus', 69),
(277, 'Leptomias jekeli', 69),
(278, 'Leptomias kashmirensis', 69),
(279, 'Leptomias kingdomwardi', 69),
(280, 'Leptomias lineostriatus', 69),
(281, 'Leptomias lobatus', 69),
(282, 'Leptomias marshalli', 69),
(283, 'Leptomias nigroguttatus', 69),
(284, 'Leptomias persimilis', 69),
(285, 'Leptomias pilosus', 69),
(286, 'Leptomias praetermissus', 69),
(289, 'Leptomias sabulosus', 69),
(290, 'Leptomias scrobicollis', 69),
(291, 'Leptomias setulosus', 69),
(292, 'Leptomias siahus', 69),
(293, 'Leptomias spinifer', 69),
(294, 'Leptomias stoliczkae', 69),
(295, 'Leptomias stultus', 69),
(296, 'Leptomias sulcicollis', 69),
(297, 'Leptomias undulans', 69),
(298, 'Leptomias verrucicollis', 69),
(299, 'Leptomias waltersi', 69),
(300, 'Pachynotus globulicollis', 70),
(301, 'Pachynotus mayarami', 70),
(302, 'Pachynotus kumaonensis', 70),
(303, 'Strophosomoides championi', 71),
(304, 'Strophosomoides fastigatus', 71),
(305, 'Strophosomoides gulmargensis', 71),
(306, 'Strophosomoides kumaonensis', 71),
(307, 'Strophosomoides niger', 71),
(308, 'Strophosomoides pahalgamensis', 71),
(309, 'Sympiezomias prasinus', 72),
(310, 'Sympiezomias praeteritus', 72),
(311, 'Sympiezomias frater', 72),
(312, 'Sympiezomias perroteti', 72),
(313, 'Sympiezomias acutipennis', 72),
(314, 'Sympiezomias hispidus', 72),
(315, 'Sympiezomias lividus', 72),
(316, 'Sympiezomias cretaceus', 72),
(317, 'Sympiezomias decipiens', 72),
(318, 'Sympiezomias sulphuratus', 72),
(319, 'Sympiezomias anamalainus', 72),
(320, 'Sympiezomias sulphuratus', 72),
(321, 'Sympiezomias similis', 72),
(322, 'Sympiezomias subserratipes', 72),
(323, 'Tylopholis ballardi', 73),
(324, 'Tylopholis obovata', 73);

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

--
-- Table structure for table `species_table`
--

DROP TABLE IF EXISTS `species_table`;
CREATE TABLE IF NOT EXISTS `species_table` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `species` varchar(50) NOT NULL,
  `user_id` int(10) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=74 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `species_table`
--

INSERT INTO `species_table` (`id`, `species`, `user_id`) VALUES
(1, 'Blosyrodes nigricorporis', 1),
(2, 'Blosyrodes nodulipennis', 1),
(3, 'Blosyrodes nodulosus', 1),
(4, 'Blosyrodes quadrinodosus', 1),
(5, 'Blosyrodes tuberosus', 1),
(6, 'Blosyrodes testaceus', 1),
(7, 'Blosyrodes variegatus', 1),
(8, 'Blosyrus asellus', 2),
(9, 'Blosyrus bengalensis', 2),
(10, 'Blosyrus herthus', 2),
(11, 'Blosyrus inaequalis', 2),
(12, 'Blosyrus oniscus', 2),
(13, 'Blosyrus spongifer', 2),
(14, 'Blosyrus thompsoni', 2),
(15, 'Blosyrus unisulcatus', 2),
(16, 'Catapionus basilicus', 3),
(17, 'Catapionus semivittatus', 3),
(18, 'Cratopus adspersus', 4),
(19, 'Cratopus nicobarensis', 4),
(20, 'Dermatoxenus helleri', 5),
(21, 'Dermatoxenus indicus', 5),
(22, 'Eustalida bomfordi', 6),
(23, 'Episomus andrewesi', 7),
(24, 'Episomus appendiculatus', 7),
(25, 'Episomus arcuatus', 7),
(26, 'Episomus arduus', 7),
(28, 'Episomus arrogans', 7),
(29, 'Episomus avuncularius', 7),
(30, 'Episomus decipiens', 7),
(31, 'Episomus dejeani', 7),
(32, 'Episomus dohertyi', 7),
(33, 'Episomus fabriciusi', 7),
(34, 'Episomus figulus', 7),
(35, 'Episomus frenatus', 7),
(36, 'Episomus guttatus', 7),
(37, 'Episomus humeralis', 7),
(38, 'Episomus inermicollis', 7),
(39, 'Episomus irregularis', 7),
(40, 'Episomus lacerta', 7),
(41, 'Episomus manipurensis', 7),
(42, 'Episomus montanus', 7),
(43, 'Episomus nebulosus', 7),
(44, 'Episomus nilgirinus', 7),
(45, 'Episomus quadrimaculatus', 7),
(46, 'Episomus quatuornotatus', 7),
(47, 'Episomus obliquus', 7),
(48, 'Episomus obuncus', 7),
(49, 'Episomus raucus', 7),
(50, 'Episomus sagax', 7),
(51, 'Episomus uniformis', 7),
(52, 'Lachnotarsus steveni', 8),
(53, 'Parapionus varicolor', 9),
(54, 'Cyrtozemia dispar', 10),
(55, 'Cyrtozemia cognata', 10),
(56, 'Malosomus lineatus', 11),
(57, 'Malosomus andrewesi', 11),
(58, 'Opseorhinus globulus', 12),
(59, 'Nothognathus schoutedeni', 13),
(60, 'Nothognathus varius', 13),
(61, 'Amphorygma nilgirensis', 14),
(62, 'Brachyxystus subsignatus gulmargicus', 15),
(63, 'Brachyxystus subsignatus subsignatus', 15),
(64, 'Catorygma curvipes', 16),
(65, 'Catorygma spinipenne', 16),
(66, 'Drepanoderes viridifasciatus', 17),
(67, 'Pachyrhinus minutioculatus', 18),
(68, 'Sphingorrhinotus marussii kaschmirensis', 19),
(69, 'Sphingorrhinotus marussii marussii', 19),
(70, 'Eugnathus curvus', 21),
(71, 'Eugnathus intermedius', 21),
(72, 'Trachyodes horrescens', 22),
(73, 'Trachyphloeosoma alternatum', 23);

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

--
-- Table structure for table `subfamilies`
--

DROP TABLE IF EXISTS `subfamilies`;
CREATE TABLE IF NOT EXISTS `subfamilies` (
  `id` int(10) NOT NULL,
  `family` varchar(500) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `subfamilies`
--

INSERT INTO `subfamilies` (`id`, `family`) VALUES
(1, 'Curculioninae'),
(2, 'Bagoinae'),
(3, 'Baridinae'),
(4, 'Brachyceropseinae'),
(5, 'Ceutorhynchinae'),
(6, 'Conoderinae'),
(7, 'Cossoninae'),
(8, 'Crytorhynchinae'),
(9, 'Cyclominae'),
(10, '<blink>Entimiane</blink>'),
(11, 'Hyperinae'),
(12, 'Lixinae'),
(13, 'Mesoptiliinae'),
(14, 'Molytinae'),
(15, 'Orobitidinae'),
(16, 'Xiphasphidinae');

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

--
-- Table structure for table `subtribe`
--

DROP TABLE IF EXISTS `subtribe`;
CREATE TABLE IF NOT EXISTS `subtribe` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `subtribe` varchar(100) NOT NULL,
  `user_id` int(10) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `subtribe`
--

INSERT INTO `subtribe` (`id`, `subtribe`, `user_id`) VALUES
(1, 'Cyphicerini Lacordaire, 1863', 4),
(2, 'Acanthotrachelina Marshall, 1944', 4),
(3, 'Mylacorrhinina Reitter, 1913', 4),
(4, 'Phytoscaphina Lacordaire, 1863', 4),
(5, 'Tanymecina Lacordaire, 1863', 13),
(6, 'Prazomiina Reitter, 1913', 13);

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

--
-- Table structure for table `subtr_genus`
--

DROP TABLE IF EXISTS `subtr_genus`;
CREATE TABLE IF NOT EXISTS `subtr_genus` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `subtr_genus` varchar(100) NOT NULL,
  `user_id` int(10) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=74 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `subtr_genus`
--

INSERT INTO `subtr_genus` (`id`, `subtr_genus`, `user_id`) VALUES
(16, 'Hilaus', 1),
(17, 'Himachala', 1),
(18, 'Hirsutopes', 1),
(19, 'Hypenephorus', 1),
(20, 'Marshalla', 1),
(21, 'Meionops', 1),
(22, 'Neomyllocerus', 1),
(23, 'Oedophrys', 1),
(24, 'Paramycter', 1),
(25, 'Parascaphus', 1),
(26, 'Peltotrachelus', 1),
(27, 'Pholicerus', 1),
(28, 'Piezophrys', 1),
(29, 'Platymycterus', 1),
(30, 'Rhicnostomus', 1),
(31, 'Scaeorrhinus', 1),
(32, 'Tanyscapus', 1),
(33, 'Taractor', 1),
(34, 'Thalponomus', 1),
(35, 'Thlipsomerus', 1),
(36, 'Thyraulus', 1),
(37, 'Acanthotrachelus', 2),
(38, 'Breviepistomus', 2),
(39, 'Gobinda', 2),
(40, 'Heteroptochus', 2),
(41, 'Lagenolobus', 2),
(42, 'Nirala', 2),
(43, 'Psidiopsis', 2),
(44, 'Tolmesis', 2),
(45, 'Transptochus', 2),
(46, 'Arhines', 3),
(47, 'Emperorrhinus', 3),
(48, 'Holorrhynchus', 3),
(49, 'Myllocerus', 3),
(50, 'Ptochus', 3),
(51, 'Stelorrhinus', 3),
(52, 'Indophytoscaphus', 4),
(53, 'Phytoscaphus', 4),
(54, 'Pseudphytoscaphus', 4),
(55, 'Anemeroides', 5),
(56, 'Esamas', 5),
(57, 'Krauseus', 5),
(58, 'Phacephorus', 5),
(59, 'Phaenoderus', 5),
(60, 'Scepticus', 5),
(61, 'Tanymecus', 5),
(15, 'Hemerus', 1),
(14, 'Hamartus', 1),
(13, 'Eryngus', 1),
(12, 'Epixynus', 1),
(11, 'Epius', 1),
(10, 'Drymophoetus', 1),
(9, 'Doliophron', 1),
(8, 'Cyrtepistomus', 1),
(7, 'Cyphicerus', 1),
(6, 'Cyphicerinus', 1),
(5, 'Crinorrhinus', 1),
(4, 'Aspidomycter', 1),
(3, 'Amrikus', 1),
(2, 'Amblyrhinus', 1),
(1, 'Agrostes', 1),
(62, 'Achlainomus', 6),
(63, 'Atmetonychus', 6),
(64, 'Burmotragus', 6),
(65, 'Hyperomias', 6),
(66, 'Indomias', 6),
(67, 'Lepidospyris', 6),
(68, 'Lepropus', 6),
(69, 'Leptomias', 6),
(70, 'Pachynotus', 6),
(71, 'Strophosomoides', 6),
(72, 'Sympiezomias', 6),
(73, 'Tylopholis', 6);

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

--
-- Table structure for table `tribe`
--

DROP TABLE IF EXISTS `tribe`;
CREATE TABLE IF NOT EXISTS `tribe` (
  `id` int(50) NOT NULL,
  `tribe` varchar(50) NOT NULL,
  `subtribe` varchar(50) NOT NULL,
  `user_id` int(10) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tribe`
--

INSERT INTO `tribe` (`id`, `tribe`, `subtribe`, `user_id`) VALUES
(1, 'Blosyrini Lacordaire, 1863', '', 10),
(2, 'Cneorbinini Lacordaire, 1863', '', 10),
(3, 'Cratopini Hustache, 1919', '', 10),
(4, 'Cyphicerini Lacordaire, 1863', 'Cyphicerina Lacordaire, 1863', 10),
(5, 'Dermatodini Emden, 1936', '', 10),
(6, 'Episomini Lacordaire, 1863', '', 10),
(7, 'Laparocerini Lacordaire, 1863', '', 10),
(8, 'Myorhinini Marseul, 1863', '', 10),
(9, 'Nothognathini Marshall, 1916', '', 10),
(10, 'Phyllobiini Schoenberr, 1826', '', 10),
(11, 'polydrusini Schoenherr, 1823', '', 10),
(12, 'Psallidiini Lacordaire, 1863', '', 10),
(13, 'Tanymecini Lacordaire, 1863', '', 10),
(14, 'Trachyphloeini Lacordaire, 1863', '', 10),
(15, 'Sitonini Gistel, 1856', '', 10);
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 */;
