--
-- Host: localhost    Database: palinoteca
-- ------------------------------------------------------


--
-- Table structure for table `autores`
--

CREATE TABLE `autores` (
  `id` int(11) NOT NULL auto_increment,
  `nome` varchar(250) NOT NULL,
  `nomeabnt` varchar(250) NOT NULL,
  `ativo` tinyint(1) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `autores`
--

INSERT INTO `autores` VALUES (2,'Luiz Cezar Alves','Alves, L. C.',1),(3,'Mayara dos Reis Monteiro','Monteiro, M. R.',1),(4,'Dandara C. do Nascimento','Nascimento, D. C.',0),(5,'Giliane Gessica Rasbold','Rasbold, G. G.',1),(6,'Mauro Parolin','Parolin, M.',1),(7,'Janaina Silva Rossi Pereira','Pereira, J. S. R.',0),(8,'Marcelo Galeazzi Caxambu','Caxambu, M. G.',1),(9,'Luiz Carlos Ruiz Pessenda','Pessenda, L. C. R.',1),(10,'Bruno Augusto Candelari','Candelari, B. A.',1),(11,'Daiany Golovati','Golavati, D.',0),(12,'Manoela dos Anjos Coelho','Coelho, M. A.',0),(13,'Sandra Betineli','Betineli, S.',0),(14,'Michael Vinicius de Sordi','Sordi, M. V.',0),(15,'Mayra Stevanato','Stevanato, M.',1),(16,'Jean Carlos Rasbold','Rasbold, J.C.',1);

--
-- Table structure for table `autores_especies`
--

CREATE TABLE `autores_especies` (
  `id` int(11) NOT NULL auto_increment,
  `autor_id` int(11) NOT NULL,
  `especie_id` int(11) NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `fk_autores_especies_especies` (`especie_id`),
  KEY `fk_autores_especies_autores` (`autor_id`),
  CONSTRAINT `fk_autores_especies_autores` FOREIGN KEY (`autor_id`) REFERENCES `autores` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `fk_autores_especies_especies` FOREIGN KEY (`especie_id`) REFERENCES `especies` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `autores_especies`
--

INSERT INTO `autores_especies` VALUES (34,2,100),(35,4,100),(36,2,101),(37,4,101),(38,2,102),(39,3,102),(40,4,102),(41,2,103),(42,3,103),(43,4,103),(44,2,104),(45,3,104),(46,4,104),(47,2,105),(48,3,105),(49,4,105),(50,2,106),(51,3,106),(52,4,106),(53,2,107),(54,3,107),(55,4,107),(56,2,108),(57,3,108),(58,4,108),(66,2,16),(67,3,16),(68,2,31),(69,3,31),(70,6,115),(71,6,116),(73,6,118),(74,6,119),(75,5,120),(76,6,120),(77,8,120),(78,5,121),(79,6,121),(80,8,121),(81,6,122),(82,2,17),(83,3,17),(84,4,17),(85,7,17),(86,2,15),(87,3,15),(88,4,15),(89,2,61),(90,3,61),(91,4,61),(92,2,25),(93,3,25),(94,4,25),(95,4,16),(96,2,18),(97,3,18),(98,4,18),(99,2,19),(100,3,19),(101,4,19),(102,2,20),(103,3,20),(104,4,20),(105,2,62),(106,5,62),(107,3,63),(108,5,63),(109,2,66),(110,3,66),(111,4,66),(112,2,46),(113,3,46),(114,4,46),(115,2,21),(116,3,21),(117,4,21),(118,2,36),(119,3,36),(120,4,36),(121,2,54),(122,3,54),(123,4,54),(124,2,55),(125,3,55),(126,4,55),(127,2,33),(128,3,33),(129,4,33),(130,2,52),(131,3,52),(132,4,52),(133,2,22),(134,3,22),(135,4,22),(136,2,67),(137,3,67),(138,4,67),(139,3,64),(140,5,64),(141,2,34),(142,3,34),(143,4,34),(144,2,37),(145,3,37),(146,4,37),(147,3,32),(148,5,32),(149,2,56),(150,3,56),(151,4,56),(152,2,14),(153,3,14),(154,4,14),(155,2,60),(156,3,60),(157,4,60),(158,2,26),(159,3,26),(160,4,26),(161,2,30),(162,3,30),(163,2,27),(164,3,27),(165,2,42),(166,3,42),(167,4,42),(168,2,38),(169,3,38),(170,4,38),(171,2,71),(172,3,71),(173,4,71),(174,2,48),(175,3,48),(176,4,48),(177,2,53),(178,3,53),(179,2,57),(180,3,57),(181,2,47),(182,3,47),(183,4,47),(184,2,49),(185,3,49),(186,4,49),(187,2,44),(188,3,44),(189,2,39),(190,3,39),(191,2,40),(192,3,40),(193,2,45),(194,3,45),(195,2,28),(196,3,28),(197,2,43),(198,3,43),(199,2,35),(200,3,35),(201,2,23),(202,3,23),(203,2,41),(204,3,41),(205,2,68),(206,3,68),(207,2,69),(208,3,69),(209,2,24),(210,3,24),(211,2,29),(212,3,29),(215,2,50),(216,3,50),(217,2,51),(218,3,51),(219,2,70),(220,3,70),(221,2,59),(222,3,59),(223,2,123),(224,3,123),(225,4,123),(226,2,124),(227,3,124),(228,2,125),(229,3,125),(230,4,125),(231,2,126),(232,3,126),(233,4,126),(234,2,127),(235,3,127),(236,4,127),(237,2,128),(238,3,128),(239,4,128),(240,2,129),(241,3,129),(242,4,129),(243,2,130),(244,3,130),(245,4,130),(246,2,131),(247,3,131),(248,4,131),(249,2,132),(250,3,132),(251,4,132),(252,2,133),(253,3,133),(254,4,133),(255,2,134),(256,3,134),(257,4,134),(258,2,135),(259,3,135),(260,4,135),(261,3,136),(262,5,136),(263,6,136),(264,8,136),(265,9,136),(278,3,141),(279,5,141),(280,8,141),(281,3,142),(282,5,142),(283,8,142),(284,3,143),(285,5,143),(286,8,143),(287,3,144),(288,5,144),(289,8,144),(290,2,145),(291,3,145),(292,4,145),(293,5,145),(294,8,145),(295,3,146),(296,7,146),(297,8,146),(298,3,147),(299,7,147),(300,3,148),(301,7,148),(302,8,148),(303,2,149),(304,3,149),(305,4,149),(306,2,150),(307,3,150),(308,4,150),(309,2,151),(310,3,151),(311,5,151),(312,2,152),(313,3,152),(314,5,152),(315,2,153),(316,3,153),(317,5,153),(318,2,154),(319,3,154),(320,5,154),(321,2,155),(322,3,155),(323,5,155),(324,2,156),(325,3,156),(326,5,156),(327,2,157),(328,3,157),(329,5,157),(330,2,158),(331,3,158),(332,5,158),(333,2,159),(334,3,159),(335,5,159),(336,2,160),(337,3,160),(338,5,160),(339,2,161),(340,3,161),(341,5,161),(342,2,162),(343,3,162),(344,5,162),(345,2,163),(346,3,163),(347,5,163),(348,2,164),(349,3,164),(350,5,164),(351,2,165),(352,3,165),(353,5,165),(354,3,166),(355,7,166),(356,3,167),(357,7,167),(358,3,168),(359,7,168),(360,8,168),(361,3,169),(362,7,169),(363,8,169),(364,3,170),(365,7,170),(366,8,170),(367,3,171),(368,7,171),(369,8,171),(370,3,172),(371,7,172),(372,3,173),(373,7,173),(374,3,174),(375,7,174),(376,8,174),(377,3,175),(378,7,175),(379,2,176),(380,3,176),(381,6,176),(382,8,176),(383,2,177),(384,3,177),(385,6,177),(386,8,177),(387,2,178),(388,3,178),(389,6,178),(390,8,178),(391,2,179),(392,3,179),(393,6,179),(394,8,179),(395,3,180),(396,5,180),(397,6,180),(398,8,180),(399,3,181),(400,6,181),(401,8,181),(402,3,182),(403,6,182),(404,8,182),(405,3,183),(406,6,183),(407,8,183),(408,3,184),(409,4,184),(410,6,184),(411,8,184),(412,3,185),(413,6,185),(414,8,185),(415,3,186),(416,5,186),(417,6,186),(418,7,186),(419,8,186),(420,3,187),(421,6,187),(422,12,187),(423,3,188),(424,6,188),(425,10,188),(426,3,189),(427,6,189),(428,11,189),(429,3,190),(430,6,190),(431,14,190),(432,3,191),(433,6,191),(434,12,191),(435,3,192),(436,6,192),(437,13,192),(438,3,193),(439,6,193),(440,10,193),(441,3,194),(442,6,194),(443,13,194),(444,3,195),(445,6,195),(446,14,195),(449,3,197),(450,16,197),(451,3,198),(452,16,198),(453,3,199),(454,16,199),(455,3,200),(456,16,200),(457,3,201),(458,16,201),(459,3,202),(460,16,202);

--
-- Table structure for table `especies`
--

CREATE TABLE `especies` (
  `id` int(11) NOT NULL auto_increment,
  `descricao` varchar(100) NOT NULL,
  `familia_id` int(11) NOT NULL,
  `arquivo` varchar(150) NOT NULL,
  `download` int(11) NOT NULL,
  `view` int(11) NOT NULL,
  `tamanho` int(11) NOT NULL,
  `created` datetime NOT NULL,
  `projeto_id` int(11) NOT NULL,
  `tipo_id` int(11) NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `fk_especies_familias` (`familia_id`),
  KEY `fk_especies_projetos` (`projeto_id`),
  KEY `fk_especies_tipos` (`tipo_id`),
  CONSTRAINT `fk_especies_familias` FOREIGN KEY (`familia_id`) REFERENCES `familias` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `fk_especies_projetos` FOREIGN KEY (`projeto_id`) REFERENCES `projetos` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `fk_especies_tipos` FOREIGN KEY (`tipo_id`) REFERENCES `tipos` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `especies`
--

INSERT INTO `especies` VALUES (14,'Froelichia procera',4,'14.jpg',17,191,2470652,'2012-08-24 09:24:17',2,4),(15,'Anacardium humile',5,'15.jpg',14,140,1730426,'2012-08-24 09:26:15',2,4),(16,'Annona coriaceae',6,'16.jpg',12,76,2319748,'2012-08-24 09:58:19',2,4),(17,'Allagoptera campestris',7,'17.jpg',11,109,2015314,'2012-08-24 10:00:17',2,4),(18,'Aspilia reflexa',1,'18.jpg',13,118,2504608,'2012-08-24 10:01:04',2,4),(19,'Baccharis crispa',1,'19.jpg',17,123,580153,'2012-08-24 10:01:43',2,4),(20,'Bidens pilosa',1,'20.jpg',16,112,1931472,'2012-08-24 10:02:29',2,4),(21,'Calea parvifolia',1,'21.jpg',11,77,2093920,'2012-08-24 10:02:59',2,4),(22,'Chamomilla reticulata',1,'22.jpg',9,65,2223771,'2012-08-24 10:03:48',2,4),(23,'Senecio brasiliensis',1,'23.jpg',10,88,1889423,'2012-08-24 10:04:22',2,4),(24,'Sphagneticola trilobata',1,'24.jpg',8,61,2549606,'2012-08-24 10:04:55',2,4),(25,'Anemopaegma prostratum',8,'25.jpg',10,69,2554890,'2012-08-24 10:05:41',2,4),(26,'Handroanthus albus',8,'26.jpg',8,56,2133413,'2012-08-24 10:06:21',2,4),(27,'Jacaranda oxyphylla',8,'27.jpg',5,51,1802054,'2012-08-24 10:07:03',2,4),(28,'Pyrostegia venusta',8,'28.jpg',6,59,2491441,'2012-08-24 10:07:33',2,4),(29,'Sphatodea campanulata',8,'29.jpg',5,48,2646962,'2012-08-24 10:08:36',2,4),(30,'Heliotropium transalpinum',9,'30.jpg',7,72,1901698,'2012-08-24 10:09:52',2,4),(31,'Aechmea distichantha',10,'31.jpg',6,98,2224859,'2012-08-24 10:11:08',2,4),(32,'Dyckia tuberosa',10,'32.jpg',8,61,2179653,'2012-08-24 10:12:03',2,4),(33,'Caryocar brasiliense',11,'33.jpg',11,79,2604290,'2012-08-24 10:12:37',2,4),(34,'Dalechampia tricophila',12,'34.jpg',5,80,2461354,'2012-08-24 10:13:22',2,4),(35,'Sapium glandulosum',12,'35.jpg',3,89,2639417,'2012-08-24 10:14:01',2,4),(36,'Calliandra brevipes',13,'36.jpg',6,86,1752458,'2012-08-24 10:15:39',2,4),(37,'Delonix regia',13,'37.jpg',4,77,2453870,'2012-08-24 10:16:17',2,4),(38,'Leucaena leucocephala',13,'38.jpg',8,75,1778175,'2012-08-24 10:16:47',2,4),(39,'Poincianella pluviosa',13,'39.jpg',3,68,2170393,'2012-08-24 10:17:20',2,4),(40,'Poiretia latifolia',13,'40.jpg',3,67,2431992,'2012-08-24 10:18:08',2,4),(41,'Sisyrunchium desiflorum',14,'41.jpg',4,40,2189207,'2012-08-24 10:19:13',2,4),(42,'Leonotis nepetifolia',15,'42.jpg',3,35,2003408,'2012-08-24 10:20:17',2,4),(43,'Salvia aliciae',15,'43.jpg',4,43,2292992,'2012-08-24 10:20:43',2,4),(44,'Persea americana',16,'44.jpg',6,55,1956046,'2012-08-24 10:21:13',2,4),(45,'Punica granatum',17,'45.jpg',4,41,2140999,'2012-08-24 10:22:33',2,4),(46,'Byrsonima intermedia',18,'46.jpg',5,53,2020215,'2012-08-24 10:23:12',2,4),(47,'Peixotoa reticulata',18,'47.jpg',4,53,2278180,'2012-08-24 10:23:53',2,4),(48,'Malvaviscus arboreus',19,'48.jpg',53,109,2150581,'2012-08-24 10:24:34',2,4),(49,'Peltae polymorpha',19,'49.jpg',3,53,2499787,'2012-08-24 10:25:11',2,4),(50,'Tibouchina cerastifolia',20,'50.jpg',4,53,1936565,'2012-08-24 10:25:45',2,4),(51,'Tibouchina granulosa',20,'51.jpg',4,42,598119,'2012-08-24 10:26:27',2,4),(52,'Cedrela fissilis',21,'52.jpg',4,67,2177021,'2012-08-24 10:27:01',2,4),(53,'Melia azedarach',21,'53.jpg',3,40,1704577,'2012-08-24 10:27:39',2,4),(54,'Campomanesia sessiliflora',22,'54.jpg',9,85,2270208,'2012-08-24 10:28:19',2,4),(55,'Campomanesia xanthocarpa',22,'55.jpg',7,72,1891503,'2012-08-24 10:28:56',2,4),(56,'Eugenia uniflora',22,'56.jpg',4,104,2296626,'2012-08-24 10:29:25',2,4),(57,'Myrcia laruotteana',22,'57.jpg',3,69,1133225,'2012-08-24 10:33:12',2,4),(58,'Ligustrum lucidum',23,'58.jpg',9,58,2517483,'2012-08-24 10:33:59',2,4),(59,'Zea mays',24,'59.jpg',5,93,2525396,'2012-08-24 10:34:36',2,4),(60,'Grevillea robusta',25,'60.jpg',4,71,2092793,'2012-08-24 10:35:19',2,4),(61,'Anemia phyllitidis',26,'61.jpg',16,77,2573090,'2012-08-24 10:36:10',2,2),(62,'Blechnum binervatum',27,'62.jpg',6,37,2787494,'2012-08-24 10:37:02',2,2),(63,'Blechnum polypodioides',27,'63.jpg',8,40,2260956,'2012-08-24 10:37:45',2,2),(64,'Cyathea atrovirens',28,'64.jpg',6,62,2229040,'2012-08-24 10:38:23',2,2),(66,'Borreira tenella',30,'66.jpg',8,90,2097900,'2012-08-24 10:40:09',2,4),(67,'Coccocypselum condalia',30,'67.jpg',5,108,2138279,'2012-08-24 10:40:50',2,4),(68,'Solanum lycocarpum',31,'68.jpg',4,91,2077124,'2012-08-24 10:41:42',2,4),(69,'Solanum mauritianum',31,'69.jpg',4,61,1629444,'2012-08-24 10:42:12',2,4),(70,'Typha domingensis',32,'70.jpg',4,36,1575452,'2012-08-24 10:44:36',2,4),(71,'Lippia lupulina',33,'71.jpg',5,59,2394621,'2012-08-24 10:45:14',2,4),(100,'Pachystachys lutea',39,'100.jpg',6273,230,2423326,'2012-08-31 09:21:39',2,4),(101,'Serjania fuscifolia',41,'101.jpg',9,62,2567600,'2012-08-31 09:24:25',2,4),(102,'Plumbago auriculata',40,'102.jpg',10,37,2349492,'2012-08-31 09:25:24',2,4),(103,'Tabebuia roseo-alba',8,'103.jpg',14,64,2362871,'2012-08-31 09:33:33',2,4),(104,'Centratherum punctatum',1,'104.jpg',14,71,2205873,'2012-08-31 09:45:17',2,3),(105,'Tithonia diversifolia',1,'105.jpg',14,74,2226120,'2012-08-31 09:46:01',2,3),(106,'Hibiscus rosa-sinensis',19,'106.jpg',5,87,2661792,'2012-08-31 09:49:05',2,4),(107,'Pavonia sepium',19,'107.jpg',5,63,2050576,'2012-08-31 09:49:49',2,4),(108,'Eriobotrya japonica',42,'108.jpg',5,55,2374163,'2012-08-31 09:51:38',2,4),(115,'Corvospongila seckti',36,'115.jpg',3,71,1452019,'2012-09-05 09:15:52',2,1),(116,'Dosilia pydanieli',37,'116.jpg',63,140,1604774,'2012-09-05 09:16:21',2,1),(118,'Oncosclera navicella',36,'118.jpg',5,41,1448274,'2012-09-05 09:18:12',2,1),(119,'Trochospongilla repens',37,'119.JPG',8,55,1614316,'2012-09-05 09:18:36',2,1),(120,'Bulbostylis juncoides',35,'120.jpg',17,79,1447755,'2012-09-05 09:37:05',2,3),(121,'Cyperus giganteus',35,'121.jpg',8,75,1316708,'2012-09-05 09:41:12',2,3),(122,'Metania spinata',38,'122.jpg',14,109,1888923,'2012-09-05 09:55:00',2,1),(123,'Cochlospermum regium',43,'123.jpg',10,58,2294703,'2012-09-10 09:43:48',2,4),(124,'Bauhinia  forficata',13,'124.jpg',9,1,2632386,'2012-09-13 11:08:58',2,4),(125,'Blechnum brasiliense',27,'125.jpg',6,49,2283337,'2012-09-13 11:15:30',2,2),(126,'Byrsonima bachybotrya',18,'126.jpg',8,64,2641365,'2012-09-13 11:16:59',2,4),(127,'Ludwigia cf peruviana',46,'127.jpg',2,40,2809604,'2012-09-13 11:18:45',2,4),(128,'Paspalum dasytrichum',24,'128.jpg',4,83,2727958,'2012-09-13 11:19:34',2,4),(129,'Piper gaudichaudianum',47,'129.jpg',4,48,2369619,'2012-09-13 11:21:15',2,4),(130,'Polygala lycopodioides',44,'130.jpg',4,46,2317905,'2012-09-13 11:22:02',2,4),(131,'Senna pendula',13,'131.jpg',5,82,2601687,'2012-09-13 11:22:55',2,4),(132,'Symplocos tenuifolia',45,'132.jpg',3,32,2239552,'2012-09-13 11:25:40',2,4),(133,'Salvia splendens',15,'133.jpg',3,34,2628466,'2012-09-13 11:26:57',2,4),(134,'Largestroemia indica',17,'134.jpg',6,40,2521293,'2012-09-13 11:30:05',2,4),(135,'Plinia trunciflora',22,'135.jpg',4,68,2403447,'2012-09-13 11:31:10',2,4),(136,'Butia paraguayensis',34,'136.jpg',18,196,1876266,'2012-09-13 11:33:31',2,3),(141,'Mangifera indica',5,'141.jpg',14,149,2344371,'2012-09-20 13:55:21',2,4),(142,'Pteris vittata',51,'142.jpg',4,37,2720826,'2012-09-20 13:59:40',2,2),(143,'Pecluma recurvata',49,'143.jpg',4,33,2364398,'2012-09-20 14:00:17',2,2),(144,'Serpocaulon triseriale',49,'144.jpg',4,29,2669255,'2012-09-20 14:01:11',2,2),(145,'Thelypteris rivulariodoides',29,'145.jpg',6,32,2452841,'2012-09-20 14:02:30',2,2),(146,'Urochloa brizantha',24,'146.jpg',4,61,2665244,'2012-09-20 14:10:49',2,4),(147,'Setaria vulpiseta',24,'147.jpg',3,59,2207953,'2012-09-20 14:12:15',2,4),(148,'Flocospa glabrata',52,'148.jpg',4,37,2679898,'2012-09-20 14:13:38',2,4),(149,'Acacia paniculata',13,'149.jpg',19,151,2451036,'2012-09-26 09:41:43',2,4),(150,'Senegalia nitidifolia',13,'150.jpg',3,64,2555018,'2012-09-26 09:42:15',2,4),(151,'Schinus molle',5,'151.jpg',18,108,2208176,'2012-09-26 10:21:27',2,4),(152,'Nerium oleander',53,'152.jpg',8,78,2517507,'2012-09-26 10:23:45',2,4),(153,'Tabernaemontana catharinensis',53,'153.jpg',10,74,2588170,'2012-09-26 10:24:29',2,4),(154,'Cuspidaria convoluta',8,'154.jpg',6,56,2713701,'2012-09-26 10:27:11',2,4),(155,'Handroanthus chrysotrichus',8,'155.jpg',8,45,2661843,'2012-09-26 10:27:58',2,4),(156,'Ipomoea alba',54,'156.jpg',6,70,2694736,'2012-09-26 10:28:44',2,4),(157,'Anadenanthera peregrina',13,'157.jpg',7,91,2614658,'2012-09-26 10:29:38',2,4),(158,'Rhododendron simsii',55,'158.jpg',6,65,2325898,'2012-09-26 10:30:54',2,4),(159,'Serjania multiflora',41,'159.jpg',4,52,1978306,'2012-10-03 10:43:29',2,4),(160,'Dichorisandra densiflora',52,'160.jpg',5,53,2015219,'2012-10-03 10:44:27',2,4),(161,'Hybanthus communis',57,'161.jpg',4,63,1899956,'2012-10-03 10:45:02',2,4),(162,'Solanum sisymbriifolium',31,'162.jpg',5,76,2016792,'2012-10-03 10:46:44',2,4),(163,'Microgramma squamulosa',49,'163.jpg',6,26,2068262,'2012-10-03 10:47:50',2,2),(164,'Vochysia tucanorum',56,'164.jpg',7,45,1970262,'2012-10-03 10:49:33',2,4),(165,'Fridericia florida',8,'165.jpg',6,42,1809869,'2012-10-03 10:53:41',2,4),(166,'Euterpe edulis',7,'166.jpg',13,86,1992017,'2012-10-16 15:17:15',2,4),(167,'Syagrus romanzoffiana',7,'167.jpg',13,89,2121318,'2012-10-16 15:18:23',2,4),(168,'Mutisia speciosa',1,'168.jpg',8,69,2358736,'2012-11-05 17:26:27',2,4),(169,'Solidago chilensis',1,'169.jpg',7,56,2510371,'2012-11-05 17:27:45',2,4),(170,'Vernonanthura petiolaris',1,'170.jpg',6,63,2397860,'2012-11-05 17:28:53',2,4),(171,'Jacaranda puberula',8,'171.jpg',3,45,2494032,'2012-11-05 17:29:57',2,4),(172,'Parodia carambeiensis',58,'172.jpg',8,71,2523728,'2012-11-05 17:31:33',2,4),(173,'Aegiphila brachiata',15,'173.jpg',5,53,2435989,'2012-11-05 17:32:22',2,4),(174,'Pleopeltis hirsutissima',49,'174.jpg',3,24,2533188,'2012-11-05 17:33:39',2,2),(175,'Daphnopsis racemosa',59,'175.jpg',3,27,2542491,'2012-11-05 17:36:01',2,4),(176,'Aegiphila verticillata',15,'176.jpg',6,48,17317601,'2012-12-08 09:11:52',2,4),(177,'Annona dioica',6,'177.jpg',10,61,22231689,'2012-12-10 13:47:41',2,4),(178,'Leptolobium elegans',13,'178.jpg',2,102,18129854,'2012-12-10 13:53:55',2,4),(179,'Myrcia splendens',22,'179.jpg',5,68,17794104,'2012-12-10 14:02:29',2,4),(180,'Campyloneuron nitidium',49,'180.jpg',6,25,2734389,'2012-12-18 15:12:32',2,2),(181,'Campyloneuron austrobrasilianum',49,'181.jpg',4,30,14957473,'2013-01-30 19:10:28',2,2),(182,'Microgramma lindbergii',49,'182.jpg',6,25,15446037,'2013-01-31 08:41:15',2,2),(183,'Niphidium crassifolium',49,'183.jpg',3,25,15860163,'2013-01-31 08:46:25',2,2),(184,'Niphidium rufosquamatum',49,'184.jpg',38,67,15580773,'2013-01-31 08:48:52',2,2),(185,'Butia eriospatha',7,'185.jpg',11,92,16137516,'2013-01-31 08:52:16',2,3),(186,'Geonoma schottiana',34,'186.jpg',5,60,11128072,'2013-03-21 14:32:39',2,3),(187,'Nectandra grandiflora',16,'187.jpg',3,35,14617102,'2013-04-03 16:23:12',2,4),(188,'Ocotea pulchella',16,'188.jpg',3,23,16534927,'2013-04-03 16:25:23',2,4),(189,'Nectandra megapotamica',16,'189.jpg',3,20,16285435,'2013-04-03 16:27:48',2,4),(190,'Ocotea variabilis',16,'190.jpg',3,30,17454864,'2013-04-03 16:29:55',2,4),(191,'Ocotea puberula',16,'191.jpg',8,30,14734559,'2013-04-03 16:34:11',2,4),(192,'Cariniana estrellensis',60,'192.jpg',6,34,19037415,'2013-04-03 16:37:05',2,4),(193,'Nectandra lanceolata',16,'193.jpg',3,28,15907655,'2013-04-03 16:39:46',2,4),(194,'Psittacanthus cordatus',61,'194.jpg',3,38,18161178,'2013-04-03 16:42:40',2,4),(195,'Leonorus japonicus',15,'195.jpg',3,43,14183424,'2013-04-03 16:44:41',2,4),(197,'Rhipsalis cereuscula',58,'197.jpg',5,38,1048023,'2016-01-22 15:18:12',2,4),(198,'Bilbergia nutans',10,'198.jpg',3,33,1068799,'2016-01-28 10:13:22',2,4),(199,'Tillandsia pohliana',10,'199.jpg',3,26,7055215,'2016-01-28 10:14:17',2,4),(200,'Tillandsia tenuifolia',10,'200.jpg',3,25,1173844,'2016-01-28 10:15:05',2,4),(201,'Aechmea nudicaulis',10,'201.jpg',3,27,668849,'2016-01-28 10:15:38',2,4),(202,'Epiphyllum phyllanthus',58,'202.jpg',4,18,965827,'2016-01-28 10:16:23',2,4);

--
-- Table structure for table `familias`
--

CREATE TABLE `familias` (
  `id` int(11) NOT NULL auto_increment,
  `descricao` varchar(100) NOT NULL,
  `grupo_id` int(11) NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `fk_familias_grupos` (`grupo_id`),
  CONSTRAINT `fk_familias_grupos` FOREIGN KEY (`grupo_id`) REFERENCES `grupos` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `familias`
--

INSERT INTO `familias` VALUES (1,'Asteraceae',1),(4,'Amaranthaceae',1),(5,'Anacardiaceae',1),(6,'Annonaceae',1),(7,'Arecaceae',1),(8,'Bignoniaceae',1),(9,'Boraginaceae',1),(10,'Bromeliaceae',1),(11,'Caryocaraceae',1),(12,'Euphorbiaceae',1),(13,'Fabaceae',1),(14,'Iridaceae',1),(15,'Lamiaceae',1),(16,'Lauraceae',1),(17,'Lythraceae',1),(18,'Malpighiaceae',1),(19,'Malvaceae',1),(20,'Melastomataceae',1),(21,'Meliaceae',1),(22,'Myrtaceae',1),(23,'Oleaceae',1),(24,'Poaceae',1),(25,'Proteaceae',1),(26,'Anemiaceae',1),(27,'Blechnaceae',1),(28,'Cyatheaceae',1),(29,'Thelypteridaceae',1),(30,'Rubiaceae',1),(31,'Solanaceae',1),(32,'Typhaceae',1),(33,'Verbenaceae',1),(34,'Arecaceae',3),(35,'Cyperaceae',3),(36,'Potamolepidae',2),(37,'Spongillidae',2),(38,'Metaniidae',2),(39,'Acanthaceae',1),(40,'Plumbaginaceae',1),(41,'Sapindaceae',1),(42,'Rosaceae',1),(43,'Bixaceae',1),(44,'Polygalaceae',1),(45,'Symplocaceae',1),(46,'Onagraceae',1),(47,'Piperaceae',1),(49,'Polypodiaceae',1),(51,'Pteridaceae',1),(52,'Commelinaceae',1),(53,'Apocynaceae',1),(54,'Convolvulaceae',1),(55,'Ericaceae',1),(56,'Vochysiaceae',1),(57,'Violaceae',1),(58,'Cactaceae',1),(59,'Thymelaeaceae',1),(60,'Lecythidaceae',1),(61,'Loranthaceae',1),(62,'Brassicaceae',1);

--
-- Table structure for table `grupos`
--

CREATE TABLE `grupos` (
  `id` int(11) NOT NULL auto_increment,
  `descricao` varchar(100) character set latin1 NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `grupos`
--

INSERT INTO `grupos` VALUES (1,'Palinoteca'),(2,'Espongoteca'),(3,'Fitoteca');

--
-- Table structure for table `projetos`
--

CREATE TABLE `projetos` (
  `id` int(11) NOT NULL auto_increment,
  `descricao` varchar(250) NOT NULL,
  `financiamento` varchar(250) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `projetos`
--

INSERT INTO `projetos` VALUES (2,'Paleoclimas e Paleoambientes do Quaternário Paranaense','CNPq (Processo 400442/2010-8)');

--
-- Table structure for table `tipos`
--

CREATE TABLE `tipos` (
  `id` int(11) NOT NULL auto_increment,
  `descricao` varchar(50) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `tipos`
--

INSERT INTO `tipos` VALUES (1,'Espícula'),(2,'Esporo'),(3,'Fitólito'),(4,'Pólen');

--
-- Dumping routines for database 'palinoteca'
--
DELIMITER ;;
DELIMITER ;


