-- Table structure for table `noticias_arquivos`
--

CREATE TABLE `noticias_arquivos` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `codigo` varchar(25) NOT NULL,
  `path` text NOT NULL,
  `arquivo` text NOT NULL,
  `legenda` text DEFAULT NULL,
  `tipo` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `codigo` (`codigo`)
) ENGINE=MyISAM AUTO_INCREMENT=889 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `noticias_arquivos`
--

INSERT INTO `noticias_arquivos` (`id`, `codigo`, `path`, `arquivo`, `legenda`, `tipo`) VALUES (306,'0vRMU5t9zWf4qv8hsYgsSRihm','zHD/noticias/12/0vRMU5t9zWf4qv8hsYgsSRihm/imagens/','img4 (0209543001502445864).jpg',NULL,'imagem'),(305,'0vRMU5t9zWf4qv8hsYgsSRihm','zHD/noticias/12/0vRMU5t9zWf4qv8hsYgsSRihm/imagens/','img3 (0188581001502445864).jpg',NULL,'imagem'),(304,'0vRMU5t9zWf4qv8hsYgsSRihm','zHD/noticias/12/0vRMU5t9zWf4qv8hsYgsSRihm/imagens/','img2 (0914626001502445863).jpg',NULL,'imagem'),(303,'nkFfOid4pgAacsOjy1U2ASquH','zHD/noticias/12/nkFfOid4pgAacsOjy1U2ASquH/imagens/','img3 (0390870001502445729).jpg',NULL,'imagem'),(302,'nkFfOid4pgAacsOjy1U2ASquH','zHD/noticias/12/nkFfOid4pgAacsOjy1U2ASquH/imagens/','img4 (0388732001502445729).jpg',NULL,'imagem'),(301,'nkFfOid4pgAacsOjy1U2ASquH','zHD/noticias/12/nkFfOid4pgAacsOjy1U2ASquH/imagens/','img2 (0173663001502445729).jpg',NULL,'imagem'),(300,'nkFfOid4pgAacsOjy1U2ASquH','zHD/noticias/12/nkFfOid4pgAacsOjy1U2ASquH/imagens/','capa.jpg',NULL,'capa'),(298,'H5oCjW1nAeOm8dwTkhFvMKWcO','zHD/noticias/12/H5oCjW1nAeOm8dwTkhFvMKWcO/imagens/','img2 (0242609001502445224).jpg','Jovens ciclistas','imagem'),(299,'H5oCjW1nAeOm8dwTkhFvMKWcO','zHD/noticias/12/H5oCjW1nAeOm8dwTkhFvMKWcO/imagens/','img3 (0289656001502445224).jpg','Capoeira','imagem'),(831,'hHoFaacV6BZyjkLiN7eIYHBsB','zHD/noticias/1/hHoFaacV6BZyjkLiN7eIYHBsB/imagens/','0580267001681163114.jpg',NULL,'capa'),(881,'scBpHlOMvU3mY34M3otRu1UCQ','zHD/noticias/1/scBpHlOMvU3mY34M3otRu1UCQ/imagens/','0063480001706540713.jpg',NULL,'capa'),(882,'VwLai5ACHfita8blvbx3p9TOJ','zHD/noticias/1/VwLai5ACHfita8blvbx3p9TOJ/imagens/','0809545001684543891.jpg',NULL,'capa'),(296,'H5oCjW1nAeOm8dwTkhFvMKWcO','zHD/noticias/12/H5oCjW1nAeOm8dwTkhFvMKWcO/imagens/','capa.jpg',NULL,'capa'),(297,'H5oCjW1nAeOm8dwTkhFvMKWcO','zHD/noticias/12/H5oCjW1nAeOm8dwTkhFvMKWcO/imagens/','img4 (0208172001502445224).jpg','A vitória esperada','imagem'),(307,'WBW4OiRWVtpgBJvCZptwiMlG8','zHD/noticias/12/WBW4OiRWVtpgBJvCZptwiMlG8/imagens/','img2 (0208423001502446055).jpg',NULL,'imagem'),(308,'WBW4OiRWVtpgBJvCZptwiMlG8','zHD/noticias/12/WBW4OiRWVtpgBJvCZptwiMlG8/imagens/','img3 (0375633001502446055).jpg',NULL,'imagem'),(309,'WBW4OiRWVtpgBJvCZptwiMlG8','zHD/noticias/12/WBW4OiRWVtpgBJvCZptwiMlG8/imagens/','img4 (0417780001502446055).jpg',NULL,'imagem'),(310,'dRxlqLjQJIfcQ5b8EAEDqsVNk','zHD/noticias/12/dRxlqLjQJIfcQ5b8EAEDqsVNk/imagens/','img2 (0721146001502446326).jpg',NULL,'imagem'),(311,'dRxlqLjQJIfcQ5b8EAEDqsVNk','zHD/noticias/12/dRxlqLjQJIfcQ5b8EAEDqsVNk/imagens/','img5 (0793472001502446326).jpg',NULL,'imagem'),(312,'dRxlqLjQJIfcQ5b8EAEDqsVNk','zHD/noticias/12/dRxlqLjQJIfcQ5b8EAEDqsVNk/imagens/','img3 (0684401001502446326).jpg',NULL,'imagem'),(313,'dRxlqLjQJIfcQ5b8EAEDqsVNk','zHD/noticias/12/dRxlqLjQJIfcQ5b8EAEDqsVNk/imagens/','img4 (0816816001502446326).jpg',NULL,'imagem'),(314,'jd4tXsmYdexIfZR5A2iSxpj6R','zHD/noticias/12/jd4tXsmYdexIfZR5A2iSxpj6R/imagens/','capa.jpg',NULL,'capa'),(315,'jd4tXsmYdexIfZR5A2iSxpj6R','zHD/noticias/12/jd4tXsmYdexIfZR5A2iSxpj6R/imagens/','img2 (0539807001502446514).jpg',NULL,'imagem'),(316,'jd4tXsmYdexIfZR5A2iSxpj6R','zHD/noticias/12/jd4tXsmYdexIfZR5A2iSxpj6R/imagens/','img3 (0809492001502446514).jpg',NULL,'imagem'),(317,'jd4tXsmYdexIfZR5A2iSxpj6R','zHD/noticias/12/jd4tXsmYdexIfZR5A2iSxpj6R/imagens/','img4 (0613874001502446514).jpg',NULL,'imagem'),(318,'jd4tXsmYdexIfZR5A2iSxpj6R','zHD/noticias/12/jd4tXsmYdexIfZR5A2iSxpj6R/imagens/','img6 (0622052001502446514).jpg',NULL,'imagem'),(319,'jd4tXsmYdexIfZR5A2iSxpj6R','zHD/noticias/12/jd4tXsmYdexIfZR5A2iSxpj6R/arquivos/','refrigerante (0122719001502446572).pdf','Especialistas listam malefícios do refrigerante diet.','arquivo'),(325,'0vRMU5t9zWf4qv8hsYgsSRihm','zHD/noticias/12/0vRMU5t9zWf4qv8hsYgsSRihm/imagens/','capa.jpg',NULL,'capa'),(326,'WBW4OiRWVtpgBJvCZptwiMlG8','zHD/noticias/12/WBW4OiRWVtpgBJvCZptwiMlG8/imagens/','capa.jpg',NULL,'capa'),(327,'dRxlqLjQJIfcQ5b8EAEDqsVNk','zHD/noticias/1/dRxlqLjQJIfcQ5b8EAEDqsVNk/imagens/','0356261001683832841.jpg',NULL,'capa'),(884,'Tb65dD8GQF1OfCrYZkX81nMcS','zHD/noticias/1/Tb65dD8GQF1OfCrYZkX81nMcS/imagens/','0623169001706585865.jpg',NULL,'capa'),(885,'scBpHlOMvU3mY34M3otRu1UCQ','zHD/noticias/1/scBpHlOMvU3mY34M3otRu1UCQ/imagens/','EQUI01 (0572067001706591582).jpg',NULL,'imagem'),(867,'AYalNvRlRMWvMBPNsjvmzeWBy','zHD/noticias/1/AYalNvRlRMWvMBPNsjvmzeWBy/imagens/','0900640001684457986.jpg',NULL,'capa'),(348,'03hhD2dUwOxq6oJHTmE8c1UlX','zHD/noticias/12/03hhD2dUwOxq6oJHTmE8c1UlX/imagens/','0512567001522833660.jpg',NULL,'capa'),(359,'pa1Y6pKXTPAWBLeUmeFWoOxNf','zHD/noticias/1/pa1Y6pKXTPAWBLeUmeFWoOxNf/imagens/','0076699001683832414.jpg',NULL,'capa'),(630,'AIRHbATB9fHrnIjO8u3nvi91s','zHD/noticias/16/AIRHbATB9fHrnIjO8u3nvi91s/imagens/','0023442001601515682.jpg',NULL,'capa'),(629,'Ph85JeIp2am1dBVxfgOywcaPx','zHD/noticias/16/Ph85JeIp2am1dBVxfgOywcaPx/imagens/','0825397001601515548.jpg',NULL,'capa'),(628,'XDRSEqXA7cO26fxGs2ASuY5KO','zHD/noticias/16/XDRSEqXA7cO26fxGs2ASuY5KO/imagens/','0859310001601515441.jpg',NULL,'capa'),(366,'dxAzX2231SQwk7WxP1JTPte3i','zHD/noticias/17/dxAzX2231SQwk7WxP1JTPte3i/imagens/','0650668001537579436.jpg','Meio Ambiente','capa'),(367,'dxAzX2231SQwk7WxP1JTPte3i','zHD/noticias/17/dxAzX2231SQwk7WxP1JTPte3i/imagens/','mam2 (0212008001537579445).jpg','Meio Ambiente','imagem'),(368,'dxAzX2231SQwk7WxP1JTPte3i','zHD/noticias/17/dxAzX2231SQwk7WxP1JTPte3i/imagens/','mam5 (0458200001537579446).jpg','Meio Ambiente','imagem'),(369,'dxAzX2231SQwk7WxP1JTPte3i','zHD/noticias/17/dxAzX2231SQwk7WxP1JTPte3i/imagens/','mam3 (0523299001537579446).jpg','Meio Ambiente','imagem'),(370,'dxAzX2231SQwk7WxP1JTPte3i','zHD/noticias/17/dxAzX2231SQwk7WxP1JTPte3i/imagens/','mam1 (0501795001537579446).jpg','Meio Ambiente','imagem'),(371,'dxAzX2231SQwk7WxP1JTPte3i','zHD/noticias/17/dxAzX2231SQwk7WxP1JTPte3i/imagens/','mam4 (0611747001537579446).jpg','Meio Ambiente','imagem'),(372,'dxAzX2231SQwk7WxP1JTPte3i','zHD/noticias/17/dxAzX2231SQwk7WxP1JTPte3i/imagens/','mam6 (0705887001537579450).jpg','Meio Ambiente','imagem'),(373,'dxAzX2231SQwk7WxP1JTPte3i','zHD/noticias/17/dxAzX2231SQwk7WxP1JTPte3i/imagens/','mam7 (0613933001537579451).jpg','Meio Ambiente','imagem'),(374,'dxAzX2231SQwk7WxP1JTPte3i','zHD/noticias/17/dxAzX2231SQwk7WxP1JTPte3i/imagens/','mam8 (0615769001537579451).jpg','Meio Ambiente','imagem'),(375,'dxAzX2231SQwk7WxP1JTPte3i','zHD/noticias/17/dxAzX2231SQwk7WxP1JTPte3i/arquivos/','Sustentabilidade Ambiental (0239769001537579859).pdf','Sustentabilidade Ambiental','arquivo'),(376,'3tCgm8KKZnoI2dOVXeQYJn1vw','zHD/noticias/17/3tCgm8KKZnoI2dOVXeQYJn1vw/imagens/','0000534001537604547.jpg','Ceerrado','capa'),(377,'0TAlntrQnKMvMDgiSpcCEM6VY','zHD/noticias/17/0TAlntrQnKMvMDgiSpcCEM6VY/imagens/','0237832001537604982.jpg','Insetos','capa'),(378,'sUFlagTwO0uyjoZsPbfOv9RCw','zHD/noticias/17/sUFlagTwO0uyjoZsPbfOv9RCw/imagens/','0615721001537605219.jpg','Aquecimento','capa'),(379,'QIo6rLNCmPWF2kQsMm4zX5vPj','zHD/noticias/17/QIo6rLNCmPWF2kQsMm4zX5vPj/imagens/','0269616001537605517.jpg','Abelha polinizando uma flor  (SumikoPhoto/Thinkstock)','capa'),(380,'d9OWeXN45XaHqqPMxWijLlk9I','zHD/noticias/17/d9OWeXN45XaHqqPMxWijLlk9I/imagens/','0456714001537605821.jpg',NULL,'capa'),(381,'YUtFKmAAOcZp3n0VM2C5GqKI6','zHD/noticias/17/YUtFKmAAOcZp3n0VM2C5GqKI6/imagens/','0557695001537611011.jpg','Saco de lixo degradável','capa'),(382,'w47OSlChzg8nE55utdMscMej9','zHD/noticias/17/w47OSlChzg8nE55utdMscMej9/imagens/','0348186001537611214.jpg',NULL,'capa'),(383,'2EvvVkk2DDevg6n9gOZUwL1HR','zHD/noticias/17/2EvvVkk2DDevg6n9gOZUwL1HR/imagens/','0496399001537713296.jpg',NULL,'capa'),(384,'om9soIZlb8nXHDgbEPBTIzkUt','zHD/noticias/17/om9soIZlb8nXHDgbEPBTIzkUt/imagens/','0709216001537713600.jpg',NULL,'capa'),(385,'9WNxKPQPmYVIc5jrXuxkWIeHL','zHD/noticias/17/9WNxKPQPmYVIc5jrXuxkWIeHL/imagens/','0396191001537713779.jpg',NULL,'capa'),(403,'MONgmkez7k5VAE2l1QC0ggfd9','zHD/noticias/16/MONgmkez7k5VAE2l1QC0ggfd9/imagens/','0394514001537945681.jpg','Educação a Jovens e Adultos EJA','capa'),(404,'MONgmkez7k5VAE2l1QC0ggfd9','zHD/noticias/16/MONgmkez7k5VAE2l1QC0ggfd9/imagens/','img-escolas (0764466001537945704).jpg','Escolas do Município','imagem'),(405,'MONgmkez7k5VAE2l1QC0ggfd9','zHD/noticias/16/MONgmkez7k5VAE2l1QC0ggfd9/imagens/','img-escolas4 (0277681001537945705).jpg','Escolas do Município','imagem'),(406,'MONgmkez7k5VAE2l1QC0ggfd9','zHD/noticias/16/MONgmkez7k5VAE2l1QC0ggfd9/imagens/','img-escolas2 (0473762001537945705).jpg','Escolas do Município','imagem'),(407,'MONgmkez7k5VAE2l1QC0ggfd9','zHD/noticias/16/MONgmkez7k5VAE2l1QC0ggfd9/imagens/','img-escolas3 (0494895001537945705).jpg','Escolas do Município','imagem'),(408,'MONgmkez7k5VAE2l1QC0ggfd9','zHD/noticias/16/MONgmkez7k5VAE2l1QC0ggfd9/arquivos/','ilustrativo1 (0082702001537945765).pdf','Ilustrativo 1','arquivo'),(409,'MONgmkez7k5VAE2l1QC0ggfd9','zHD/noticias/16/MONgmkez7k5VAE2l1QC0ggfd9/arquivos/','ilustrativo2 (0320276001537945765).pdf','Ilustrativo 2','arquivo'),(410,'MONgmkez7k5VAE2l1QC0ggfd9','zHD/noticias/16/MONgmkez7k5VAE2l1QC0ggfd9/arquivos/','ilustrativo3 (0327954001537945765).pdf','Ilustrativo 3','arquivo'),(627,'tz0ZEn8ukQApdVM7oZgYFezev','zHD/noticias/16/tz0ZEn8ukQApdVM7oZgYFezev/imagens/','0275782001601515331.jpg',NULL,'capa'),(626,'Pjlh088WGNuvyet6D9YlLLZGN','zHD/noticias/16/Pjlh088WGNuvyet6D9YlLLZGN/imagens/','0800045001601515245.jpg',NULL,'capa'),(625,'bqhGPwALDiSNEApw6LMEz8cqh','zHD/noticias/16/bqhGPwALDiSNEApw6LMEz8cqh/imagens/','0936881001601515037.jpg',NULL,'capa'),(624,'wTc7PM3uWOI8zP0AQI1nwD0G2','zHD/noticias/16/wTc7PM3uWOI8zP0AQI1nwD0G2/imagens/','0180510001601514673.jpg',NULL,'capa'),(450,'zpJLd1kM5aVVBVhLAbyuSKDlK','zHD/noticias/16/zpJLd1kM5aVVBVhLAbyuSKDlK/imagens/','0699828001538248892.jpg',NULL,'capa'),(451,'EicXywMF39kOUYWR6PxYydgYe','zHD/noticias/16/EicXywMF39kOUYWR6PxYydgYe/imagens/','0768834001538249434.jpg',NULL,'capa'),(453,'T0dZforlxxW0Z37PexPc41GHO','zHD/noticias/23/T0dZforlxxW0Z37PexPc41GHO/imagens/','0357553001538413701.jpg','Publicações','capa'),(454,'T0dZforlxxW0Z37PexPc41GHO','zHD/noticias/23/T0dZforlxxW0Z37PexPc41GHO/imagens/','amb2 (0726227001538413716).jpg','Publicações','imagem'),(455,'T0dZforlxxW0Z37PexPc41GHO','zHD/noticias/23/T0dZforlxxW0Z37PexPc41GHO/imagens/','amb3 (0141695001538413717).jpg','Publicações','imagem'),(456,'T0dZforlxxW0Z37PexPc41GHO','zHD/noticias/23/T0dZforlxxW0Z37PexPc41GHO/imagens/','amb4 (0141080001538413717).jpg','Publicações','imagem'),(457,'T0dZforlxxW0Z37PexPc41GHO','zHD/noticias/23/T0dZforlxxW0Z37PexPc41GHO/imagens/','amb5 (0620059001538413717).jpg','Publicações','imagem'),(458,'T0dZforlxxW0Z37PexPc41GHO','zHD/noticias/23/T0dZforlxxW0Z37PexPc41GHO/arquivos/','ilustrativo2 (0218958001538413836).pdf','Ilustrativo 1','arquivo'),(459,'T0dZforlxxW0Z37PexPc41GHO','zHD/noticias/23/T0dZforlxxW0Z37PexPc41GHO/arquivos/','ilustrativo4 (0346312001538413836).pdf','Ilustrativo 2','arquivo'),(460,'T0dZforlxxW0Z37PexPc41GHO','zHD/noticias/23/T0dZforlxxW0Z37PexPc41GHO/arquivos/','ilustrativo3 (0348066001538413836).pdf','Ilustrativo 3','arquivo'),(461,'gehijf1wxuO2Etkt6oOf1RQda','zHD/noticias/23/gehijf1wxuO2Etkt6oOf1RQda/imagens/','0357684001538430534.jpg',NULL,'capa'),(462,'bo8OeomT2dWIHoCnf6IAbT3FW','zHD/noticias/23/bo8OeomT2dWIHoCnf6IAbT3FW/imagens/','0565074001538430581.jpg',NULL,'capa'),(463,'WGWNAqgHiGOzlqZ19zVo1plLc','zHD/noticias/23/WGWNAqgHiGOzlqZ19zVo1plLc/imagens/','0262168001538430644.jpg',NULL,'capa'),(464,'jVikGQJ5hyb2RvhtyI3pyQbvp','zHD/noticias/23/jVikGQJ5hyb2RvhtyI3pyQbvp/imagens/','0072642001538430689.jpg',NULL,'capa'),(465,'kSAQ2qJnxDvQw4uFmEF1Jvswd','zHD/noticias/23/kSAQ2qJnxDvQw4uFmEF1Jvswd/imagens/','0264182001538430917.jpg',NULL,'capa'),(466,'ZKXuZKPzYHp2jkadcuMXUJGH6','zHD/noticias/23/ZKXuZKPzYHp2jkadcuMXUJGH6/imagens/','0315597001538430969.jpg',NULL,'capa'),(467,'flzW4GZRQhZ6nRmqOkVwsaeg1','zHD/noticias/23/flzW4GZRQhZ6nRmqOkVwsaeg1/imagens/','0462070001538431028.jpg',NULL,'capa'),(631,'NeF1wqByLCh73tHh4IP8xC9zZ','zHD/noticias/16/NeF1wqByLCh73tHh4IP8xC9zZ/imagens/','0523394001601515833.jpg',NULL,'capa'),(473,'Kk7FNUNimJMY044zYaMpiRyQF','zHD/noticias/16/Kk7FNUNimJMY044zYaMpiRyQF/imagens/','0442084001539580762.jpg','Enem','capa'),(480,'3hgq7T5B9wrHF8ubEa7NSv2sv','zHD/noticias/12/3hgq7T5B9wrHF8ubEa7NSv2sv/imagens/','0008412001591346086.jpg',NULL,'capa'),(623,'033VlQMJAjvL73iUSN01sIoxu','zHD/noticias/25/033VlQMJAjvL73iUSN01sIoxu/imagens/','0331728001600590104.jpg',NULL,'capa'),(634,'U49694gTXmE40REYG2PNTd2wL','zHD/noticias/25/U49694gTXmE40REYG2PNTd2wL/imagens/','0746290001602479343.jpg',NULL,'capa'),(632,'LXSs6WLXfdMpDYemVprlBwYUE','zHD/noticias/16/LXSs6WLXfdMpDYemVprlBwYUE/imagens/','0164044001601515946.jpg',NULL,'capa'),(633,'SIzXjrvsWhA7TQPUjj1Ch118N','zHD/noticias/16/SIzXjrvsWhA7TQPUjj1Ch118N/imagens/','0093237001601516064.jpg',NULL,'capa'),(622,'fUSaZoKT4w8WbglvaZLKApHtR','zHD/noticias/25/fUSaZoKT4w8WbglvaZLKApHtR/imagens/','0514044001600589732.jpg',NULL,'capa'),(492,'RDp0ADw4RE6FJOJ7A6DJO0Bbi','zHD/noticias/25/RDp0ADw4RE6FJOJ7A6DJO0Bbi/imagens/','0576561001591673501.jpg',NULL,'capa'),(493,'0SWax5dT6Us11mJh7FgjyIYMG','zHD/noticias/25/0SWax5dT6Us11mJh7FgjyIYMG/imagens/','0175722001591850314.jpg',NULL,'capa'),(494,'C8E3Bx15GTJuONVXw7tp1fWJB','zHD/noticias/25/C8E3Bx15GTJuONVXw7tp1fWJB/imagens/','0429541001591674281.jpg',NULL,'capa'),(680,'oKgx8mWPongtjkML6k6zWG0ZU','zHD/noticias/16/oKgx8mWPongtjkML6k6zWG0ZU/arquivos/','Documento Ilustrativo 1 (0502797001610526306).pdf','Calendário Anual (ilustrativo)','arquivo'),(679,'oKgx8mWPongtjkML6k6zWG0ZU','zHD/noticias/16/oKgx8mWPongtjkML6k6zWG0ZU/arquivos/','Documento Ilustrativo 5 (0498780001610526306).pdf','Regimento Escolar (ilustrativo)','arquivo'),(635,'gD0mYIZHRGRhuLMfKGDkzXPxF','zHD/noticias/25/gD0mYIZHRGRhuLMfKGDkzXPxF/imagens/','0192957001602479542.jpg',NULL,'capa'),(636,'Nt7DUemVhCsTmpurVoovUV4FI','zHD/noticias/25/Nt7DUemVhCsTmpurVoovUV4FI/imagens/','0735474001602479737.jpg',NULL,'capa'),(637,'I2wu0mwqREBH5LlfRSdBqKoAU','zHD/noticias/25/I2wu0mwqREBH5LlfRSdBqKoAU/imagens/','0847699001602480056.jpg',NULL,'capa'),(682,'oKgx8mWPongtjkML6k6zWG0ZU','zHD/noticias/16/oKgx8mWPongtjkML6k6zWG0ZU/arquivos/','Documento Ilustrativo 1 (0482463001610526723).pdf','Agenda de Eventos (ilustrativo)','arquivo'),(683,'RACQBJobtV9dCZMa3S42sKSUR','zHD/noticias/4/RACQBJobtV9dCZMa3S42sKSUR/imagens/','0768389001677780827.jpg',NULL,'capa'),(684,'qc08SJ85BVtjGEgpZZ90MUVpl','zHD/noticias/4/qc08SJ85BVtjGEgpZZ90MUVpl/imagens/','0210353001675102297.jpg',NULL,'capa'),(685,'9kNE7qAm7LaOEefI4BZh8HwUc','zHD/noticias/4/9kNE7qAm7LaOEefI4BZh8HwUc/imagens/','0560976001675102151.jpg',NULL,'capa'),(648,'oKgx8mWPongtjkML6k6zWG0ZU','zHD/noticias/16/oKgx8mWPongtjkML6k6zWG0ZU/imagens/','0802735001603835272.jpg',NULL,'capa'),(649,'oKgx8mWPongtjkML6k6zWG0ZU','zHD/noticias/16/oKgx8mWPongtjkML6k6zWG0ZU/imagens/','Escola-Ilustrativo-6 (0879616001603835282).jpg',NULL,'imagem'),(650,'oKgx8mWPongtjkML6k6zWG0ZU','zHD/noticias/16/oKgx8mWPongtjkML6k6zWG0ZU/imagens/','Escola-Ilustrativo-7 (0947256001603835282).jpg',NULL,'imagem'),(659,'oKgx8mWPongtjkML6k6zWG0ZU','zHD/noticias/16/oKgx8mWPongtjkML6k6zWG0ZU/imagens/','equipe (0274317001603835662).jpg',NULL,'imagem'),(652,'oKgx8mWPongtjkML6k6zWG0ZU','zHD/noticias/16/oKgx8mWPongtjkML6k6zWG0ZU/imagens/','Escola-Ilustrativo-8 (0078077001603835283).jpg',NULL,'imagem'),(678,'oKgx8mWPongtjkML6k6zWG0ZU','zHD/noticias/16/oKgx8mWPongtjkML6k6zWG0ZU/arquivos/','Documento Ilustrativo 3 (0459472001610526306).pdf','Calendário de Provas (ilustrativo)','arquivo'),(677,'oKgx8mWPongtjkML6k6zWG0ZU','zHD/noticias/16/oKgx8mWPongtjkML6k6zWG0ZU/arquivos/','Documento Ilustrativo 2 (0423788001610526306).pdf','Regimento Interno (ilustrativo)','arquivo'),(589,'WMJmRG275FrChGT1xQhKm82jO','zHD/noticias/1/WMJmRG275FrChGT1xQhKm82jO/imagens/','0917031001683832550.jpg',NULL,'capa'),(591,'9e8fo1Ii07uednZEFYi980mZB','zHD/noticias/12/9e8fo1Ii07uednZEFYi980mZB/imagens/','0953553001593117231.jpg',NULL,'capa'),(662,'ns91D17g3x5XoUr1V4E9s5dIS','zHD/noticias/17/ns91D17g3x5XoUr1V4E9s5dIS/imagens/','0984539001604208019.jpg',NULL,'capa'),(663,'OHutpNMiTW66aCOIWflKzHGce','zHD/noticias/27/OHutpNMiTW66aCOIWflKzHGce/imagens/','0811869001607939520.jpg',NULL,'capa'),(664,'OHutpNMiTW66aCOIWflKzHGce','zHD/noticias/27/OHutpNMiTW66aCOIWflKzHGce/arquivos/','ilustrativo1 (0064482001607939849).pdf','Ata da Sessão  Ilustrativo','arquivo'),(665,'OHutpNMiTW66aCOIWflKzHGce','zHD/noticias/27/OHutpNMiTW66aCOIWflKzHGce/arquivos/','ilustrativo4 (0100134001607939849).pdf','Projeto de Lei  Ilustrativo','arquivo'),(666,'OHutpNMiTW66aCOIWflKzHGce','zHD/noticias/27/OHutpNMiTW66aCOIWflKzHGce/arquivos/','ilustrativo2 (0107043001607939849).pdf','Requerimento 1  Ilustrativo','arquivo'),(667,'OHutpNMiTW66aCOIWflKzHGce','zHD/noticias/27/OHutpNMiTW66aCOIWflKzHGce/arquivos/','ilustrativo3 (0166073001607939849).pdf','Requerimento 2  Ilustrativo','arquivo'),(668,'OHutpNMiTW66aCOIWflKzHGce','zHD/noticias/27/OHutpNMiTW66aCOIWflKzHGce/arquivos/','ilustrativo5 (0192620001607939849).pdf','Documentos Ilustrativo','arquivo'),(672,'qL6TGGUi6LvY7gL2IOKUJmxQO','zHD/noticias/4/qL6TGGUi6LvY7gL2IOKUJmxQO/imagens/','0918377001677781009.jpg',NULL,'capa'),(673,'qL6TGGUi6LvY7gL2IOKUJmxQO','zHD/noticias/16/qL6TGGUi6LvY7gL2IOKUJmxQO/imagens/','not-escola-sustentavel1 (0649491001610524671).jpg',NULL,'imagem'),(674,'qL6TGGUi6LvY7gL2IOKUJmxQO','zHD/noticias/16/qL6TGGUi6LvY7gL2IOKUJmxQO/imagens/','not-escola-sustentavel3 (0789980001610524671).jpg',NULL,'imagem'),(675,'qL6TGGUi6LvY7gL2IOKUJmxQO','zHD/noticias/16/qL6TGGUi6LvY7gL2IOKUJmxQO/imagens/','not-escola-sustentavel2 (0943410001610524671).jpg',NULL,'imagem'),(676,'qL6TGGUi6LvY7gL2IOKUJmxQO','zHD/noticias/16/qL6TGGUi6LvY7gL2IOKUJmxQO/imagens/','not-escola-sustentavel4 (0949386001610524671).jpg',NULL,'imagem'),(807,'wAdesA9GMKYyj63w906KpzZml','zHD/noticias/8/wAdesA9GMKYyj63w906KpzZml/imagens/','0616436001641841809.jpg',NULL,'capa'),(805,'KL712C7ywkMcTM9CiC444zXBm','zHD/noticias/8/KL712C7ywkMcTM9CiC444zXBm/imagens/','0118072001641772499.jpg',NULL,'capa'),(806,'ehJ9yHYHx0BabD2PDA52y3OuJ','zHD/noticias/8/ehJ9yHYHx0BabD2PDA52y3OuJ/imagens/','0105590001641773181.jpg',NULL,'capa'),(803,'ydV1JHxjOVA63akUxMhb42uoy','zHD/noticias/8/ydV1JHxjOVA63akUxMhb42uoy/imagens/','0434160001641493990.jpg',NULL,'capa'),(709,'kwpZM3GCnluyuOxRR50gTRucg','zHD/noticias/4/kwpZM3GCnluyuOxRR50gTRucg/imagens/','0313305001675101217.jpg',NULL,'capa'),(710,'kwpZM3GCnluyuOxRR50gTRucg','zHD/noticias/4/kwpZM3GCnluyuOxRR50gTRucg/arquivos/','Documento Ilustrativo 1 (0114990001619985547).pdf',NULL,'arquivo'),(711,'kwpZM3GCnluyuOxRR50gTRucg','zHD/noticias/4/kwpZM3GCnluyuOxRR50gTRucg/arquivos/','Documento Ilustrativo 3 (0240092001619985547).pdf',NULL,'arquivo'),(712,'kwpZM3GCnluyuOxRR50gTRucg','zHD/noticias/4/kwpZM3GCnluyuOxRR50gTRucg/arquivos/','Documento Ilustrativo 4 (0322194001619985547).pdf',NULL,'arquivo'),(713,'kwpZM3GCnluyuOxRR50gTRucg','zHD/noticias/4/kwpZM3GCnluyuOxRR50gTRucg/arquivos/','Documento Ilustrativo 2 (0468728001619985547).pdf',NULL,'arquivo'),(714,'kwpZM3GCnluyuOxRR50gTRucg','zHD/noticias/4/kwpZM3GCnluyuOxRR50gTRucg/arquivos/','Documento Ilustrativo 5 (0557990001619985547).pdf',NULL,'arquivo'),(715,'kwpZM3GCnluyuOxRR50gTRucg','zHD/noticias/4/kwpZM3GCnluyuOxRR50gTRucg/imagens/','img02 (0024715001619986439).jpg',NULL,'imagem'),(716,'kwpZM3GCnluyuOxRR50gTRucg','zHD/noticias/4/kwpZM3GCnluyuOxRR50gTRucg/imagens/','img03 (0176759001619986439).jpg',NULL,'imagem'),(717,'kwpZM3GCnluyuOxRR50gTRucg','zHD/noticias/4/kwpZM3GCnluyuOxRR50gTRucg/imagens/','img01 (0315521001619986439).jpg',NULL,'imagem'),(718,'kwpZM3GCnluyuOxRR50gTRucg','zHD/noticias/4/kwpZM3GCnluyuOxRR50gTRucg/imagens/','img04 (0496247001619986439).jpg',NULL,'imagem'),(719,'kwpZM3GCnluyuOxRR50gTRucg','zHD/noticias/4/kwpZM3GCnluyuOxRR50gTRucg/audios/','Hino Nacional com Coral (0480639001619986491).mp3',NULL,'audio'),(720,'kwpZM3GCnluyuOxRR50gTRucg','zHD/noticias/4/kwpZM3GCnluyuOxRR50gTRucg/audios/','Hino a Proclamação da republica com Coral (0752222001619986492).mp3',NULL,'audio'),(721,'kwpZM3GCnluyuOxRR50gTRucg','zHD/noticias/4/kwpZM3GCnluyuOxRR50gTRucg/audios/','Hino da Independencia com Coral (0991651001619986492).mp3',NULL,'audio'),(722,'kwpZM3GCnluyuOxRR50gTRucg','zHD/noticias/4/kwpZM3GCnluyuOxRR50gTRucg/audios/','Hino a Bandeira com Coral (0241138001619986493).mp3',NULL,'audio'),(723,'ljIObjr8G6mYU0RFWDjzorhvq','zHD/noticias/4/ljIObjr8G6mYU0RFWDjzorhvq/imagens/','0857571001675100966.jpg',NULL,'capa'),(724,'ljIObjr8G6mYU0RFWDjzorhvq','zHD/noticias/4/ljIObjr8G6mYU0RFWDjzorhvq/imagens/','img02 (0475066001619986846).jpg',NULL,'imagem'),(725,'ljIObjr8G6mYU0RFWDjzorhvq','zHD/noticias/4/ljIObjr8G6mYU0RFWDjzorhvq/imagens/','img01 (0637596001619986846).jpg',NULL,'imagem'),(726,'ljIObjr8G6mYU0RFWDjzorhvq','zHD/noticias/4/ljIObjr8G6mYU0RFWDjzorhvq/imagens/','img03 (0831879001619986846).jpg',NULL,'imagem'),(727,'ljIObjr8G6mYU0RFWDjzorhvq','zHD/noticias/4/ljIObjr8G6mYU0RFWDjzorhvq/imagens/','img06 (0000696001619986847).jpg',NULL,'imagem'),(728,'ljIObjr8G6mYU0RFWDjzorhvq','zHD/noticias/4/ljIObjr8G6mYU0RFWDjzorhvq/audios/','Hino Nacional com Coral (0735686001619986872).mp3',NULL,'audio'),(729,'ljIObjr8G6mYU0RFWDjzorhvq','zHD/noticias/4/ljIObjr8G6mYU0RFWDjzorhvq/audios/','Hino da Independencia com Coral (0200751001619986875).mp3',NULL,'audio'),(730,'ljIObjr8G6mYU0RFWDjzorhvq','zHD/noticias/4/ljIObjr8G6mYU0RFWDjzorhvq/audios/','Hino a Bandeira com Coral (0442577001619986875).mp3',NULL,'audio'),(731,'ljIObjr8G6mYU0RFWDjzorhvq','zHD/noticias/4/ljIObjr8G6mYU0RFWDjzorhvq/audios/','Hino a Proclamação da republica com Coral (0506536001619986875).mp3',NULL,'audio'),(732,'ljIObjr8G6mYU0RFWDjzorhvq','zHD/noticias/4/ljIObjr8G6mYU0RFWDjzorhvq/arquivos/','Hino Nacional com Coral (0709168001619986974).mp3',NULL,'arquivo'),(733,'ljIObjr8G6mYU0RFWDjzorhvq','zHD/noticias/4/ljIObjr8G6mYU0RFWDjzorhvq/arquivos/','Hino a Proclamação da republica com Coral (0214812001619986976).mp3',NULL,'arquivo'),(734,'ljIObjr8G6mYU0RFWDjzorhvq','zHD/noticias/4/ljIObjr8G6mYU0RFWDjzorhvq/arquivos/','Hino da Independencia com Coral (0424664001619986976).mp3',NULL,'arquivo'),(735,'ljIObjr8G6mYU0RFWDjzorhvq','zHD/noticias/4/ljIObjr8G6mYU0RFWDjzorhvq/arquivos/','Hino a Bandeira com Coral (0571904001619986976).mp3',NULL,'arquivo'),(820,'HxchOQmzqySZF14cXagAqO48H','zHD/noticias/4/HxchOQmzqySZF14cXagAqO48H/imagens/','0779443001677779869.jpg',NULL,'capa'),(788,'31mOdGHtHC4UjHvSUNDfy1rqe','zHD/noticias/8/31mOdGHtHC4UjHvSUNDfy1rqe/imagens/','0927458001630207743.jpg',NULL,'capa'),(759,'kNJSc6zEbFQ8X3ZihRvhPSB2B','zHD/noticias/4/kNJSc6zEbFQ8X3ZihRvhPSB2B/imagens/','0853599001675100751.jpg',NULL,'capa'),(760,'tvDWH3xN8iu7B3u37ZMuTtH90','zHD/noticias/4/tvDWH3xN8iu7B3u37ZMuTtH90/imagens/','0128159001675100605.jpg',NULL,'capa'),(761,'HNKVU2xB3FFQ5xQuX41dZbyZs','zHD/noticias/4/HNKVU2xB3FFQ5xQuX41dZbyZs/imagens/','0685962001675100306.jpg',NULL,'capa'),(815,'HNKVU2xB3FFQ5xQuX41dZbyZs','zHD/noticias/4/HNKVU2xB3FFQ5xQuX41dZbyZs/arquivos/','Documento Ilustrativo 2 (0878625001675190997).pdf','Doocumento2 (Ilustrativo) ','arquivo'),(816,'HNKVU2xB3FFQ5xQuX41dZbyZs','zHD/noticias/4/HNKVU2xB3FFQ5xQuX41dZbyZs/arquivos/','Documento Ilustrativo 3 (0880760001675190997).pdf','Doocumento3 (Ilustrativo) ','arquivo'),(814,'HNKVU2xB3FFQ5xQuX41dZbyZs','zHD/noticias/4/HNKVU2xB3FFQ5xQuX41dZbyZs/arquivos/','Documento Ilustrativo 1 (0861524001675190997).pdf','Doocumento1 (Ilustrativo) ','arquivo'),(767,'capKug9nEhpLXt1kdexJmItZ1','zHD/noticias/4/capKug9nEhpLXt1kdexJmItZ1/imagens/','0336403001675100155.jpg',NULL,'capa'),(818,'capKug9nEhpLXt1kdexJmItZ1','zHD/noticias/4/capKug9nEhpLXt1kdexJmItZ1/arquivos/','Documento Ilustrativo 1 (0568560001675191112).pdf','Documento1 (Ilustrativo)','arquivo'),(819,'capKug9nEhpLXt1kdexJmItZ1','zHD/noticias/4/capKug9nEhpLXt1kdexJmItZ1/arquivos/','Documento Ilustrativo 2 (0575002001675191112).pdf','Documento2 (Ilustrativo)','arquivo'),(817,'capKug9nEhpLXt1kdexJmItZ1','zHD/noticias/4/capKug9nEhpLXt1kdexJmItZ1/arquivos/','Documento Ilustrativo 3 (0557422001675191112).pdf','Documento3 (Ilustrativo)','arquivo'),(886,'scBpHlOMvU3mY34M3otRu1UCQ','zHD/noticias/1/scBpHlOMvU3mY34M3otRu1UCQ/imagens/','EQUI04 (0611193001706591582).jpg',NULL,'imagem'),(887,'scBpHlOMvU3mY34M3otRu1UCQ','zHD/noticias/1/scBpHlOMvU3mY34M3otRu1UCQ/imagens/','EQUI02 (0683654001706591582).jpg',NULL,'imagem'),(888,'scBpHlOMvU3mY34M3otRu1UCQ','zHD/noticias/1/scBpHlOMvU3mY34M3otRu1UCQ/imagens/','EQUI03 (0694410001706591582).jpg',NULL,'imagem'),(868,'AYalNvRlRMWvMBPNsjvmzeWBy','zHD/noticias/1/AYalNvRlRMWvMBPNsjvmzeWBy/arquivos/','Documento Ilustrativo 1 (0162491001683480137).pdf',NULL,'arquivo'),(869,'eRBf6GVFH3AKyiepzPr7OaFiQ','zHD/noticias/1/eRBf6GVFH3AKyiepzPr7OaFiQ/arquivos/','Documento Ilustrativo 1 (0706435001683480331).pdf',NULL,'arquivo'),(870,'mAPh4LUA2S6UhqrLvJDvIr08q','zHD/noticias/1/mAPh4LUA2S6UhqrLvJDvIr08q/imagens/','0337811001684457689.jpg',NULL,'capa'),(880,'eRBf6GVFH3AKyiepzPr7OaFiQ','zHD/noticias/1/eRBf6GVFH3AKyiepzPr7OaFiQ/imagens/','0041306001684457840.jpg',NULL,'capa');

--
-- Table structure for table `noticias_entidades`
--

CREATE TABLE `noticias_entidades` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `usuario` int(11) NOT NULL,
  `noticia` int(11) NOT NULL,
  `entidade` int(11) NOT NULL,
  `data` datetime NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `noticia` (`noticia`),
  KEY `entidade` (`entidade`),
  KEY `usuario` (`usuario`)
) ENGINE=MyISAM AUTO_INCREMENT=57 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `noticias_entidades`
--

INSERT INTO `noticias_entidades` (`id`, `usuario`, `noticia`, `entidade`, `data`) VALUES (56,1,512,2,'2021-04-23 04:07:42');

--
-- Table structure for table `noticias_links`
--

CREATE TABLE `noticias_links` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `codigo` varchar(25) NOT NULL,
  `titulo` text DEFAULT NULL,
  `link` text NOT NULL,
  PRIMARY KEY (`id`),
  KEY `codigo` (`codigo`)
) ENGINE=MyISAM AUTO_INCREMENT=135 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `noticias_links`
--

INSERT INTO `noticias_links` (`id`, `codigo`, `titulo`, `link`) VALUES (110,'i4uWc37UT2dnN8yFoKXTuTWAd','LINK','haha!'),(111,'H5oCjW1nAeOm8dwTkhFvMKWcO','O lado invisível na performance de um atleta','http://tribunaexpresso.pt/opiniao/2016-09-21-O-lado-invisivel-da-performance-de-um-atleta-o-papel-dos-pais?platform=hootsuite'),(112,'H5oCjW1nAeOm8dwTkhFvMKWcO','A inatividade física custa caro','http://www1.folha.uol.com.br/colunas/drauziovarella/2016/10/1818437-a-inatividade-fisica-custou-para-o-mundo-us-675-bilhoes.shtml'),(113,'WBW4OiRWVtpgBJvCZptwiMlG8','Matéria do Globo Rural sobre água com açúcar.','http://revistagloborural.globo.com/Noticias/noticia/2015/01/agua-com-acucar-acalma.html'),(114,'xMFYTCNPx8JjHozmYfZpb94eh','Veja aqui o edital do concurso','http://www.prefeiturasonline.com.br/admtsp/concursos'),(115,'CHECBXyardxnU5fUjwm2Hsqjy','teste','http://google.com'),(116,'T0dZforlxxW0Z37PexPc41GHO','Google ','http://google.com'),(117,'SqzqsKVI3v2xM25CZDBVCPO1q','Google','http://google.com'),(118,'3hgq7T5B9wrHF8ubEa7NSv2sv','Aplicativo Link da loja (Android)','https://play.google.com/store/apps/details?id=br.gov.datasus.guardioes'),(119,'3hgq7T5B9wrHF8ubEa7NSv2sv','Aplicativo Link da loja (IOS)','https://apps.apple.com/br/app/coronav%C3%ADrus-sus/id1408008382'),(121,'jd4tXsmYdexIfZR5A2iSxpj6R','Google','https://google.com'),(122,'FdjhCLCXCB5Ja5PPnJ8gOU2DB','Ônibus Chines','https://www.youtube.com/watch?v=C09tsvuMYwo&feature=emb_logo'),(127,'PDHUmlu2DjQkVdQPKAmQdoppy','Google','https://google.com'),(128,'ljIObjr8G6mYU0RFWDjzorhvq','Google','https://google.com'),(129,'Wt4GJlsSHG6SEOJ4X1e0Bcjie','Google','https://google.com'),(130,'1pSm8EbXp9aTdXC5nOAA75Qja','Google','https://google.com'),(131,'QItusIdYEfppQUjyhJOAOGNUn','Ministério da Educação','http://portal.mec.gov.br/'),(132,'31mOdGHtHC4UjHvSUNDfy1rqe','Quero ser MEI','https://www.gov.br/empresas-e-negocios/pt-br/empreendedor/quero-ser-mei'),(133,'uzKieJUYqpivUSJP688M8B5Um','JP Web','https://jpweb.com.br');

--
-- Table structure for table `noticias_secoes`
--

CREATE TABLE `noticias_secoes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `entidade` int(11) NOT NULL DEFAULT 0,
  `nome` varchar(250) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `entidade` (`entidade`)
) ENGINE=MyISAM AUTO_INCREMENT=75 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `noticias_secoes`
--

INSERT INTO `noticias_secoes` (`id`, `entidade`, `nome`) VALUES (6,1,'Publicações'),(8,4,'Diretorias'),(9,4,'Publicações'),(10,5,'Licenças Ambientais'),(28,4,'Escolas'),(12,23,'Publicações'),(13,23,'Quem Somos'),(17,2,'Publicações'),(26,5,'Notícias'),(30,6,'Sessões'),(31,4,'Projetos'),(44,8,'Notícias'),(38,4,'Ações Pedagógicas'),(39,4,'Conselho Municipal'),(40,4,'Educação Inclusiva'),(41,4,'Legislação da BNCC'),(42,4,'Proposta Educacional'),(43,4,'EAD Home'),(56,1,'Institucional'),(55,4,'Instituições'),(73,1,'Quem Somos'),(74,1,'Áreas de Atuação'),(72,1,'Tag'),(69,1,'Nossos Serviços');

--
-- Table structure for table `noticias_videos`
--

CREATE TABLE `noticias_videos` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `codigo` varchar(25) NOT NULL,
  `titulo` text DEFAULT NULL,
  `link` text NOT NULL,
  PRIMARY KEY (`id`),
  KEY `codigo` (`codigo`)
) ENGINE=MyISAM AUTO_INCREMENT=154 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `noticias_videos`
--

INSERT INTO `noticias_videos` (`id`, `codigo`, `titulo`, `link`) VALUES (111,'i4uWc37UT2dnN8yFoKXTuTWAd','Título do Vídeo','1Ngn3fZIK2E'),(112,'H5oCjW1nAeOm8dwTkhFvMKWcO','O esporte na vida da criança e adolescente','3luG6iJBaok'),(113,'H5oCjW1nAeOm8dwTkhFvMKWcO','A importância do esporte para a criança','yx1cGfwSBPQ'),(114,'WBW4OiRWVtpgBJvCZptwiMlG8','Água com açúcar acalma? ou verdade?','PmWyiIpDq_c'),(115,'WBW4OiRWVtpgBJvCZptwiMlG8','Água com açúcar acalma? Mito ou verdade?','PmWyiIpDq_c'),(116,'dRxlqLjQJIfcQ5b8EAEDqsVNk','Conheça melhor o mosquito da dengue','X8mcrkJSzIM'),(117,'jd4tXsmYdexIfZR5A2iSxpj6R','Regrigerante faz mal a saúde','jrt2Asc9LEY'),(137,'RDp0ADw4RE6FJOJ7A6DJO0Bbi','Sobre o Coronavírus','nz9at_gk8Rw'),(135,'FdjhCLCXCB5Ja5PPnJ8gOU2DB','Ônibus Chines ','C09tsvuMYwo'),(136,'FdjhCLCXCB5Ja5PPnJ8gOU2DB','Ônibus Chines','lPdl3uxW3aI'),(121,'3veWzrOxgmrWPJD5Lt1TKbIKZ','Como funciona uma ambulância','39Ixz-DdEt0'),(122,'whGkl2OqPeDG49ta15l4qN1tP','O interior e os equipamentos de uma ambulância','pBLxjmQm9A8'),(123,'kaUhp53kEQTlIw9YdPtUEPCH1','Leishmaniose, cuidados e prevenções','6u5eIY9rOXs'),(124,'kaUhp53kEQTlIw9YdPtUEPCH1','Saiba o que é leishmaniose','CCRY2Sp6dYw'),(125,'dxAzX2231SQwk7WxP1JTPte3i','Meio Ambiente','4H1R3dSLjnw'),(126,'3tCgm8KKZnoI2dOVXeQYJn1vw','O cerrado corre risco','ir_BSW6dGcc'),(127,'b2ZecCZa7I37KG6fw4FFRmFQf','Hallellujah - Handel - Orquestra Sinfônica Escola Municipal de Artes \"João Oscarito\"','Fn8Zx6JiruQ'),(128,'pIooH90kt81yoJ0sL4x1Vz2OC','Secretária destaca o empenho das escolas municipais rurais nas atividades do Agrinho','oMmS-T5jZwY'),(129,'MONgmkez7k5VAE2l1QC0ggfd9','Projeto ensina a alunos de escola municipal o processo de produção de calçados','8mTxAzZcIzw'),(130,'CHECBXyardxnU5fUjwm2Hsqjy','Vídeo','we9ZFdQebFE'),(131,'CHECBXyardxnU5fUjwm2Hsqjy','Vídeo 1','HClD3lWklLI'),(132,'T0dZforlxxW0Z37PexPc41GHO','Ilustrativo 1','TuHjgTg1KQk'),(133,'Kk7FNUNimJMY044zYaMpiRyQF','Preparativos para o Enem - Brasil Escola','5Bdqa5uV83w'),(134,'LBQhkyNRta3tcVitQPWLsKKVS','Tudo sobre o Corona Vírus','nz9at_gk8Rw'),(138,'ZAVwamrFCaBDNPbMzSt9auXmb','Aviões do Forró','Mzf0WNL7QzM'),(139,'bqhGPwALDiSNEApw6LMEz8cqh','Fusos horários','vgiY-3Qztnk'),(140,'OHutpNMiTW66aCOIWflKzHGce','Vídeo ilustrativo','n2iYCS3iWQQ'),(141,'qL6TGGUi6LvY7gL2IOKUJmxQO','Escola sustentável (ilustrativo)','seBFIjpgEKk'),(142,'6GrBZS6vjoM6OzXlV6PHqc7ZU','Cuidados a serem tomados com o Coronavírus','n0Y2zS-sz1E'),(143,'PDHUmlu2DjQkVdQPKAmQdoppy','Aula Online','E47iYrsDGvI'),(144,'PDHUmlu2DjQkVdQPKAmQdoppy','Aula de Redação para Enem - Ilustrativo','1-VxgZKqs34'),(145,'kwpZM3GCnluyuOxRR50gTRucg','Educação Infantil na BNCC','e-T6OrPwWMM'),(146,'ljIObjr8G6mYU0RFWDjzorhvq','Educação Infantil na BNCC','e-T6OrPwWMM'),(147,'Wt4GJlsSHG6SEOJ4X1e0Bcjie','Educação Infantil na BNCC','e-T6OrPwWMM'),(148,'uzKieJUYqpivUSJP688M8B5Um','Vídeo Ilustrativo','4FvKRbZeb1Q'),(151,'wmwOg7POfT9psWEfV6mPdfZFj','Vídeo ilustrativo','xRMng92zQdc'),(150,'emsSel9x3HhIksBIOvttNvdMP','Vídeo ilustrativo','ctIJWxRhWyY'),(153,'l6HiZ7WaYti921AiZAMRHwEJJ','vÍDEO iLUSTRATIVO','EJ0hxPKBs_k');

--
-- Table structure for table `ouvidoria`
--

CREATE TABLE `ouvidoria` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `anonimo` int(11) NOT NULL DEFAULT 0,
  `finalidade` int(11) DEFAULT NULL,
  `status` int(11) NOT NULL DEFAULT 0,
  `pessoa` varchar(20) DEFAULT NULL,
  `nome` varchar(200) DEFAULT NULL,
  `documento` varchar(200) DEFAULT NULL,
  `email` varchar(300) DEFAULT NULL,
  `telefone` varchar(300) DEFAULT NULL,
  `cep` varchar(300) DEFAULT NULL,
  `endereco` varchar(300) DEFAULT NULL,
  `bairro` varchar(300) DEFAULT NULL,
  `complemento` varchar(300) DEFAULT NULL,
  `cidade` varchar(300) DEFAULT NULL,
  `uf` varchar(300) DEFAULT NULL,
  `codigo` varchar(25) DEFAULT NULL,
  `titulo` text DEFAULT NULL,
  `texto` text DEFAULT NULL,
  `protocolo` varchar(8) NOT NULL,
  `data` timestamp NOT NULL DEFAULT current_timestamp(),
  `entidade` int(11) NOT NULL,
  `envio` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `entidade` (`entidade`),
  KEY `protocolo` (`protocolo`),
  KEY `documento` (`documento`)
) ENGINE=MyISAM AUTO_INCREMENT=479 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `ouvidoria`
--

INSERT INTO `ouvidoria` (`id`, `anonimo`, `finalidade`, `status`, `pessoa`, `nome`, `documento`, `email`, `telefone`, `cep`, `endereco`, `bairro`, `complemento`, `cidade`, `uf`, `codigo`, `titulo`, `texto`, `protocolo`, `data`, `entidade`, `envio`) VALUES (476,1,1,171,'PF','WEB RADIO BALADA BLACK PEL ','     ','baladablackpel@gmail.com','',NULL,'','     ',NULL,'','AC','84nRGNcCsczTe1k70wfdyKMNy','DIVULGA LINK ','CURTA BALADA BLACK DIARIAMENTE \r\n\r\nhttps://baladablackpel.com/\r\n\r\n','0ISTJOGJ','2023-03-07 05:26:00',1,0),(477,1,1,171,'PF','WEB RADIO BALADA BLACK PEL ','     ','baladablackpel@gmail.com','',NULL,'','     ',NULL,'','AC','jMk9rB91NffYJ9DCqGsFYvwaO','DIVULGA LINK ','CURTA BALADA BLACK DIARIAMENTE \r\n\r\nhttps://baladablackpel.com/\r\n\r\n','2JPCKFS3','2023-03-07 05:26:00',1,0),(478,1,1,171,'PF','Portal Universo Autista','     ','universoautista@outlook.com','',NULL,'','     ',NULL,'','AC','e88NWnYuZg5ubxv38aMlllr3E','Novo Portal Universo Autista','Conheça nossa novo portal.\r\nTudo sobre autismo em um só lugar!\r\n - Materiais adaptados pedagógicos\r\n- Estudos\r\n- Curso ABA 60h online\r\n- Noticias emtempo real\r\n- Muito mais...\r\nAcesse:\r\nhttps://universoautista.com.br','HIISVCN6','2023-03-09 14:43:03',1,0),(475,1,156,171,'PF','','','','',NULL,'','',NULL,'','','gZx1qNgtMZXYf1uhxNgw3jlTx','JPWEB TESTE','Lorem ipsão dolor sít amçet, consectetur adipiscing elit. Sed vehicula id odio quis rhoncus. Donec ullamcorper, lectus in dictum porta, urna nisl tincidunt metus, at iaculis nunc sem vitae diam. Etiam quam orci, volutpat a justo non, pretium condimentum felis. Duis id elementum arcu. Mauris pharetra dui molestie tortor imperdiet. ','demo','2023-02-24 04:19:14',1,0);

--
-- Table structure for table `ouvidoria_arquivos`
--

CREATE TABLE `ouvidoria_arquivos` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `codigo` varchar(25) NOT NULL,
  `path` text NOT NULL,
  `arquivo` text NOT NULL,
  `legenda` text DEFAULT NULL,
  `tipo` varchar(50) DEFAULT NULL,
  `data` date DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `codigo` (`codigo`)
) ENGINE=MyISAM AUTO_INCREMENT=800 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `ouvidoria_arquivos`
--

INSERT INTO `ouvidoria_arquivos` (`id`, `codigo`, `path`, `arquivo`, `legenda`, `tipo`, `data`) VALUES (632,'zLJMmTFRlnrUXt16AX1OXCRQt','zHD/ouvidoria/23/zLJMmTFRlnrUXt16AX1OXCRQt/arquivos/','ilustrativo5 (0151304001538687036).pdf',NULL,'arquivo','2018-10-04'),(631,'jQTtQbSoxoalfixuN0RNH40Xx','zHD/ouvidoria/23/jQTtQbSoxoalfixuN0RNH40Xx/arquivos/','ilustrativo12 (0828058001538685693).pdf',NULL,'arquivo','2018-10-04'),(630,'qPb1aWAUMZOAnyYC8n8NisGo6','zHD//23/qPb1aWAUMZOAnyYC8n8NisGo6/arquivos/','ilustrativo4 (0571776001538685600).pdf',NULL,'arquivo','2018-10-04'),(629,'qPb1aWAUMZOAnyYC8n8NisGo6','zHD//23/qPb1aWAUMZOAnyYC8n8NisGo6/arquivos/','ilustrativo11 (0571431001538685600).pdf',NULL,'arquivo','2018-10-04'),(628,'cvViVW2kqmkpnkWFFQzZiyslL','zHD/ouvidoria/23/cvViVW2kqmkpnkWFFQzZiyslL/arquivos/','ilustrativo5 (0452455001538666921).pdf',NULL,'arquivo','2018-10-04'),(633,'jDjXwBqsEqygQi4nhJDyFHgfl','zHD/ouvidoria/12/jDjXwBqsEqygQi4nhJDyFHgfl/arquivos/','rua-esburacada (0815011001569574393).jpg',NULL,'arquivo','2019-09-27'),(656,'vnQN9OzXqYTtSX24Z5K3bDIvi','zHD//12/vnQN9OzXqYTtSX24Z5K3bDIvi/arquivos/','agua (0693926001571938150).jpg',NULL,'arquivo','2019-10-24'),(635,'uM7aG0ZpB309aTcnVXmQk2Znf','zHD/ouvidoria/17/uM7aG0ZpB309aTcnVXmQk2Znf/arquivos/','agua (0378904001569985958).jpg',NULL,'arquivo','2019-10-02'),(636,'uM7aG0ZpB309aTcnVXmQk2Znf','zHD/ouvidoria/17/uM7aG0ZpB309aTcnVXmQk2Znf/arquivos/','ilustrativo1 (0395876001569985958).pdf',NULL,'arquivo','2019-10-02'),(637,'ZLB4LuP2Uw9gTSYxpJ4KHi0eQ','zHD/ouvidoria/17/ZLB4LuP2Uw9gTSYxpJ4KHi0eQ/arquivos/','agua (0181429001569986564).jpg',NULL,'arquivo','2019-10-02'),(638,'ZLB4LuP2Uw9gTSYxpJ4KHi0eQ','zHD/ouvidoria/17/ZLB4LuP2Uw9gTSYxpJ4KHi0eQ/arquivos/','ilustrativo1 (0182206001569986564).pdf',NULL,'arquivo','2019-10-02'),(639,'AU22UVfJA8QDWLw1MGLI4BeTd','zHD/ouvidoria/17/AU22UVfJA8QDWLw1MGLI4BeTd/arquivos/','agua (0630872001569987631).jpg',NULL,'arquivo','2019-10-02'),(640,'AU22UVfJA8QDWLw1MGLI4BeTd','zHD/ouvidoria/17/AU22UVfJA8QDWLw1MGLI4BeTd/arquivos/','ilustrativo1 (0631229001569987631).pdf',NULL,'arquivo','2019-10-02'),(641,'PMCv2sSCXe8xT1TjTDiCPWxAV','zHD/ouvidoria/17/PMCv2sSCXe8xT1TjTDiCPWxAV/arquivos/','agua (0189812001569989170).jpg',NULL,'arquivo','2019-10-02'),(642,'PMCv2sSCXe8xT1TjTDiCPWxAV','zHD/ouvidoria/17/PMCv2sSCXe8xT1TjTDiCPWxAV/arquivos/','ilustrativo1 (0190149001569989170).pdf',NULL,'arquivo','2019-10-02'),(643,'13AKwoQKKfLSAhwY98ULArEdu','zHD/ouvidoria/17/13AKwoQKKfLSAhwY98ULArEdu/arquivos/','agua (0129927001570006944).jpg',NULL,'arquivo','2019-10-02'),(644,'13AKwoQKKfLSAhwY98ULArEdu','zHD/ouvidoria/17/13AKwoQKKfLSAhwY98ULArEdu/arquivos/','ilustrativo1 (0202065001570006944).pdf',NULL,'arquivo','2019-10-02'),(645,'KCHwiF0uqhsAglkBlGuSYXyBL','zHD/ouvidoria/17/KCHwiF0uqhsAglkBlGuSYXyBL/arquivos/','agua (0512820001570078637).jpg',NULL,'arquivo','2019-10-03'),(646,'KCHwiF0uqhsAglkBlGuSYXyBL','zHD/ouvidoria/17/KCHwiF0uqhsAglkBlGuSYXyBL/arquivos/','ilustrativo1 (0584180001570078637).pdf',NULL,'arquivo','2019-10-03'),(647,'UYih3JmIJnN85JmLuEYy2Dxba','zHD/ouvidoria/17/UYih3JmIJnN85JmLuEYy2Dxba/arquivos/','agua (0454023001570303660).jpg',NULL,'arquivo','2019-10-05'),(648,'UYih3JmIJnN85JmLuEYy2Dxba','zHD/ouvidoria/17/UYih3JmIJnN85JmLuEYy2Dxba/arquivos/','ilustrativo1 (0465207001570303660).pdf',NULL,'arquivo','2019-10-05'),(649,'XzxdVn7EpHk2hCG8GiHt7YSiw','zHD/ouvidoria/17/XzxdVn7EpHk2hCG8GiHt7YSiw/arquivos/','agua (0205205001570601163).jpg',NULL,'arquivo','2019-10-09'),(650,'iSWS4Kskzgb17gSptethyle9y','zHD/ouvidoria/17/iSWS4Kskzgb17gSptethyle9y/arquivos/','agua (0297226001570797761).jpg',NULL,'arquivo','2019-10-11'),(651,'fwHi5gJY1hkVZqMsurW9RbiVT','zHD//12/fwHi5gJY1hkVZqMsurW9RbiVT/arquivos/','agua (0429079001571759305).jpg',NULL,'arquivo','2019-10-22'),(652,'fwHi5gJY1hkVZqMsurW9RbiVT','zHD//12/fwHi5gJY1hkVZqMsurW9RbiVT/arquivos/','ilustrativo1 (0434076001571759305).pdf',NULL,'arquivo','2019-10-22'),(653,'6uXizxZGtlwaw2o3lHRcnmkhH','zHD//12/6uXizxZGtlwaw2o3lHRcnmkhH/arquivos/','0709216001537713600not7 (0227955001571773885).jpg',NULL,'arquivo','2019-10-22'),(654,'6uXizxZGtlwaw2o3lHRcnmkhH','zHD//12/6uXizxZGtlwaw2o3lHRcnmkhH/arquivos/','edital-de-abertura-de-inscricoes (0228374001571773885).pdf',NULL,'arquivo','2019-10-22'),(655,'s2ScFOISwnfPO0IflK2OyEkcb','zHD/ouvidoria/12/s2ScFOISwnfPO0IflK2OyEkcb/arquivos/','agua (0871422001571936021).jpg',NULL,'arquivo','2019-10-24'),(657,'vnQN9OzXqYTtSX24Z5K3bDIvi','zHD//12/vnQN9OzXqYTtSX24Z5K3bDIvi/arquivos/','ilustrativo1 (0694618001571938150).pdf',NULL,'arquivo','2019-10-24'),(658,'uETgYR0cSMqleAYhML1r1QMSO','zHD/ouvidoria/12/uETgYR0cSMqleAYhML1r1QMSO/arquivos/','agua (0230470001571938279).jpg',NULL,'arquivo','2019-10-24'),(659,'uETgYR0cSMqleAYhML1r1QMSO','zHD/ouvidoria/12/uETgYR0cSMqleAYhML1r1QMSO/arquivos/','ilustrativo1 (0169579001571938288).pdf',NULL,'arquivo','2019-10-24'),(660,'h4aJrwqStAJIGLEmoV2VbX8bF','zHD//12/h4aJrwqStAJIGLEmoV2VbX8bF/arquivos/','queimadas (0704056001571940471).jpg',NULL,'arquivo','2019-10-24'),(661,'h4aJrwqStAJIGLEmoV2VbX8bF','zHD//12/h4aJrwqStAJIGLEmoV2VbX8bF/arquivos/','ilustrativo1 (0704936001571940471).pdf',NULL,'arquivo','2019-10-24'),(662,'Sv0iiHeti7mqbLNoEJ0pymNuJ','zHD//17/Sv0iiHeti7mqbLNoEJ0pymNuJ/arquivos/','agua (0472766001573087825).jpg',NULL,'arquivo','2019-11-06'),(663,'Sv0iiHeti7mqbLNoEJ0pymNuJ','zHD//17/Sv0iiHeti7mqbLNoEJ0pymNuJ/arquivos/','ilustrativo1 (0574331001573087825).pdf',NULL,'arquivo','2019-11-06'),(664,'jBiSY1ri0dXS3D9Qb5zfOoKQg','zHD//17/jBiSY1ri0dXS3D9Qb5zfOoKQg/arquivos/','agua (0100534001573406109).jpg',NULL,'arquivo','2019-11-10'),(665,'jBiSY1ri0dXS3D9Qb5zfOoKQg','zHD//17/jBiSY1ri0dXS3D9Qb5zfOoKQg/arquivos/','ilustrativo1 (0101178001573406109).pdf',NULL,'arquivo','2019-11-10'),(666,'FB99dE6NQtPKsIfbeuy1ZIyPJ','zHD//17/FB99dE6NQtPKsIfbeuy1ZIyPJ/arquivos/','agua (0464044001573406375).jpg',NULL,'arquivo','2019-11-10'),(667,'FB99dE6NQtPKsIfbeuy1ZIyPJ','zHD//17/FB99dE6NQtPKsIfbeuy1ZIyPJ/arquivos/','ilustrativo1 (0464458001573406375).pdf',NULL,'arquivo','2019-11-10'),(668,'uDVIyjnniB2bxvzh5PevP8KAk','zHD//17/uDVIyjnniB2bxvzh5PevP8KAk/arquivos/','agua (0589826001573411949).jpg',NULL,'arquivo','2019-11-10'),(669,'uDVIyjnniB2bxvzh5PevP8KAk','zHD//17/uDVIyjnniB2bxvzh5PevP8KAk/arquivos/','ilustrativo1 (0590622001573411949).pdf',NULL,'arquivo','2019-11-10'),(670,'Ciassn3YvtF76tOcJMPVPQwKe','zHD//17/Ciassn3YvtF76tOcJMPVPQwKe/arquivos/','agua (0801898001573412110).jpg',NULL,'arquivo','2019-11-10'),(671,'Ciassn3YvtF76tOcJMPVPQwKe','zHD//17/Ciassn3YvtF76tOcJMPVPQwKe/arquivos/','ilustrativo1 (0802632001573412110).pdf',NULL,'arquivo','2019-11-10'),(672,'N4vS39588z6q5SsGbhabYG2gA','zHD//12/N4vS39588z6q5SsGbhabYG2gA/arquivos/','temp-fogo (0253862001588936574).jpg',NULL,'arquivo','2020-05-08'),(673,'nIDu7O9P4riDWzB8axPg2GfrO','zHD//12/nIDu7O9P4riDWzB8axPg2GfrO/arquivos/','queimadas (0350941001591605877).jpg',NULL,'arquivo','2020-06-08'),(674,'aOtvqU26MRfzTRwnLYuEW22pJ','zHD//12/aOtvqU26MRfzTRwnLYuEW22pJ/arquivos/','queimadas (0440760001591605884).jpg',NULL,'arquivo','2020-06-08'),(675,'i82tJ27eVNTMQSTHXzDcmcxH7','zHD//25/i82tJ27eVNTMQSTHXzDcmcxH7/arquivos/','2020-sus (0519930001591919416).jpg',NULL,'arquivo','2020-06-11'),(676,'CIbcMglpHjbqUYhxq3LHkcwyM','zHD//25/CIbcMglpHjbqUYhxq3LHkcwyM/arquivos/','corona-mascara (0504055001591920359).jpg',NULL,'arquivo','2020-06-11'),(677,'NHdzTOxLW1x6n0g15egLGOdDx','zHD/ouvidoria/12/NHdzTOxLW1x6n0g15egLGOdDx/arquivos/','Documento Ilustrativo (0170055001598962078).pdf',NULL,'arquivo','2020-09-01'),(678,'QXw6OzSaRYl341NxTZjlkBo3X','zHD//17/QXw6OzSaRYl341NxTZjlkBo3X/arquivos/','Documento Ilustrativo (0107816001598962147).pdf',NULL,'arquivo','2020-09-01'),(679,'Ise7hR8kAv2ceTcpLwCgmt26D','zHD//17/Ise7hR8kAv2ceTcpLwCgmt26D/arquivos/','Documento Ilustrativo (0084170001598962211).pdf',NULL,'arquivo','2020-09-01'),(680,'zJjfvuf2sb33LNJusQfVCbNMF','zHD//17/zJjfvuf2sb33LNJusQfVCbNMF/arquivos/','Documento Ilustrativo (0802268001598966866).pdf',NULL,'arquivo','2020-09-01'),(681,'yckU7E9ToaZVvM13A1RVjVD9E','zHD//17/yckU7E9ToaZVvM13A1RVjVD9E/arquivos/','Documento Ilustrativo (0553417001598966907).pdf',NULL,'arquivo','2020-09-01'),(682,'E6W5FdmRO89i8U0agjLKAfTQe','zHD//17/E6W5FdmRO89i8U0agjLKAfTQe/arquivos/','Documento Ilustrativo (0931876001598966908).pdf',NULL,'arquivo','2020-09-01'),(683,'WpOcy6BXTDfvC6qxFrbnLyUL1','zHD//17/WpOcy6BXTDfvC6qxFrbnLyUL1/arquivos/','Documento Ilustrativo (0779165001598966911).pdf',NULL,'arquivo','2020-09-01'),(684,'Nywxalbt7V7qYyjYMClXBWFz9','zHD//17/Nywxalbt7V7qYyjYMClXBWFz9/arquivos/','Documento Ilustrativo (0315814001598966912).pdf',NULL,'arquivo','2020-09-01'),(685,'AwmuS8Mix0oN5jgTK60M5wmhh','zHD//17/AwmuS8Mix0oN5jgTK60M5wmhh/arquivos/','Documento Ilustrativo (0812038001598966912).pdf',NULL,'arquivo','2020-09-01'),(686,'Qxg1onEFBBHtOHcW9Aks46kRk','zHD//17/Qxg1onEFBBHtOHcW9Aks46kRk/arquivos/','Documento Ilustrativo (0879946001598985637).pdf',NULL,'arquivo','2020-09-01'),(687,'tOlDLx7MOylNBrADrJwR5J658','zHD//17/tOlDLx7MOylNBrADrJwR5J658/arquivos/','Documento Ilustrativo (0103182001598985745).pdf',NULL,'arquivo','2020-09-01'),(688,'4PZcYv96eGDkW3rgThCApFCzc','zHD//17/4PZcYv96eGDkW3rgThCApFCzc/arquivos/','Documento Ilustrativo (0333469001598985748).pdf',NULL,'arquivo','2020-09-01'),(689,'lQ7ilPt62sN1CByPJmRC1PMT6','zHD/ouvidoria/12/lQ7ilPt62sN1CByPJmRC1PMT6/arquivos/','Documento Ilustrativo (0711273001599043774).pdf',NULL,'arquivo','2020-09-02'),(690,'BtICyEupPkWHSlJAceLUdiLDz','zHD/ouvidoria/12/BtICyEupPkWHSlJAceLUdiLDz/arquivos/','Documento Ilustrativo (0506058001599045926).pdf',NULL,'arquivo','2020-09-02'),(691,'BtICyEupPkWHSlJAceLUdiLDz','zHD/ouvidoria/12/BtICyEupPkWHSlJAceLUdiLDz/arquivos/','Fogo na mata (0506450001599045926).jpg',NULL,'arquivo','2020-09-02'),(692,'T2stId4HACPENwNxoou44aJ7m','zHD/ouvidoria/12/T2stId4HACPENwNxoou44aJ7m/arquivos/','Documento Ilustrativo (0170404001599045993).pdf',NULL,'arquivo','2020-09-02'),(693,'T2stId4HACPENwNxoou44aJ7m','zHD/ouvidoria/12/T2stId4HACPENwNxoou44aJ7m/arquivos/','Fogo na mata (0171055001599045993).jpg',NULL,'arquivo','2020-09-02'),(694,'8cLCkU4hUeYsiO6xyulpIOczY','zHD/ouvidoria/12/8cLCkU4hUeYsiO6xyulpIOczY/arquivos/','Documento Ilustrativo (0298573001599046217).pdf',NULL,'arquivo','2020-09-02'),(695,'8cLCkU4hUeYsiO6xyulpIOczY','zHD/ouvidoria/12/8cLCkU4hUeYsiO6xyulpIOczY/arquivos/','Fogo na mata (0298939001599046217).jpg',NULL,'arquivo','2020-09-02'),(696,'HI00E9WZ7Lgog0OMwyAqQ1u26','zHD/ouvidoria/12/HI00E9WZ7Lgog0OMwyAqQ1u26/arquivos/','Documento Ilustrativo (0945028001599046287).pdf',NULL,'arquivo','2020-09-02'),(697,'HI00E9WZ7Lgog0OMwyAqQ1u26','zHD/ouvidoria/12/HI00E9WZ7Lgog0OMwyAqQ1u26/arquivos/','Fogo na mata (0945416001599046287).jpg',NULL,'arquivo','2020-09-02'),(751,'jvdTvyVcGtyWN2UxvTseyBVwD','zHD/ouvidoria/12/jvdTvyVcGtyWN2UxvTseyBVwD/arquivos/','agua (0632507001601231732).jpg',NULL,'arquivo','2020-09-27'),(699,'IISg7YSinRX9AXRYGZ3FoduxD','zHD/ouvidoria/12/IISg7YSinRX9AXRYGZ3FoduxD/arquivos/','Documento Ilustrativo (0275332001599046749).pdf',NULL,'arquivo','2020-09-02'),(700,'IISg7YSinRX9AXRYGZ3FoduxD','zHD/ouvidoria/12/IISg7YSinRX9AXRYGZ3FoduxD/arquivos/','Imagem Ilustrativa (0275693001599046749).jpg',NULL,'arquivo','2020-09-02'),(749,'zXaTtGMW2VEYzutA4TLYaSSF2','zHD/ouvidoria/12/zXaTtGMW2VEYzutA4TLYaSSF2/arquivos/','agua (0466420001601231527).jpg',NULL,'arquivo','2020-09-27'),(702,'afbFgWyd5keTuzssh5pBC11mW','zHD//25/afbFgWyd5keTuzssh5pBC11mW/arquivos/','Documento Ilustrativo (0827310001599133831).pdf',NULL,'arquivo','2020-09-03'),(703,'afbFgWyd5keTuzssh5pBC11mW','zHD//25/afbFgWyd5keTuzssh5pBC11mW/arquivos/','Imagem Ilustrativa (0827655001599133831).jpg',NULL,'arquivo','2020-09-03'),(704,'soEc5uxqpLkTb3dbuOc6UBrIR','zHD/ouvidoria/12/soEc5uxqpLkTb3dbuOc6UBrIR/arquivos/','2020-carta-de-servicos (0552133001600110850).jpg',NULL,'arquivo','2020-09-14'),(705,'T0MV2RnAC9f8ZpDDhY20TWqEq','zHD//25/T0MV2RnAC9f8ZpDDhY20TWqEq/arquivos/','2020-carta-de-servicos (0919982001600110922).jpg',NULL,'arquivo','2020-09-14'),(706,'T0MV2RnAC9f8ZpDDhY20TWqEq','zHD//25/T0MV2RnAC9f8ZpDDhY20TWqEq/arquivos/','2020-carta-de-servicos (0920303001600110922).jpg',NULL,'arquivo','2020-09-14'),(707,'VfpNXOdJV34whv3htdWYwYBTC','zHD/ouvidoria/12/VfpNXOdJV34whv3htdWYwYBTC/arquivos/','2020-carta-de-servicos (0818907001600111158).jpg',NULL,'arquivo','2020-09-14'),(708,'VfpNXOdJV34whv3htdWYwYBTC','zHD/ouvidoria/12/VfpNXOdJV34whv3htdWYwYBTC/arquivos/','2020-carta-de-servicos (0819505001600111158).jpg',NULL,'arquivo','2020-09-14'),(709,'Eh8cG4FYLzjQ2MKyLUCffFJlF','zHD/ouvidoria/12/Eh8cG4FYLzjQ2MKyLUCffFJlF/arquivos/','2020-carta-de-servicos (0815844001600126826).jpg',NULL,'arquivo','2020-09-14'),(710,'Eh8cG4FYLzjQ2MKyLUCffFJlF','zHD/ouvidoria/12/Eh8cG4FYLzjQ2MKyLUCffFJlF/arquivos/','2020-carta-de-servicos (0816201001600126826).jpg',NULL,'arquivo','2020-09-14'),(711,'pTqSW6rmh9WZGcEq3PqpvNz03','zHD//25/pTqSW6rmh9WZGcEq3PqpvNz03/arquivos/','2020-carta-de-servicos (0671944001600127514).jpg',NULL,'arquivo','2020-09-14'),(712,'pTqSW6rmh9WZGcEq3PqpvNz03','zHD//25/pTqSW6rmh9WZGcEq3PqpvNz03/arquivos/','2020-carta-de-servicos (0672276001600127514).jpg',NULL,'arquivo','2020-09-14'),(713,'piOFgjOdUIkQW9MF1Kehi4aBx','zHD//25/piOFgjOdUIkQW9MF1Kehi4aBx/arquivos/','2020-carta-de-servicos (0475176001600131931).jpg',NULL,'arquivo','2020-09-14'),(714,'HQxFqpqbLRY1U1G2E9AZ7dStk','zHD//17/HQxFqpqbLRY1U1G2E9AZ7dStk/arquivos/','2020-carta-de-servicos (0997611001600133478).jpg',NULL,'arquivo','2020-09-14'),(715,'KXL3YK7NSVZWxu3g6Kzik9gHV','zHD//25/KXL3YK7NSVZWxu3g6Kzik9gHV/arquivos/','2020-carta-de-servicos (0035343001600136584).jpg',NULL,'arquivo','2020-09-14'),(716,'KXL3YK7NSVZWxu3g6Kzik9gHV','zHD//25/KXL3YK7NSVZWxu3g6Kzik9gHV/arquivos/','2020-carta-de-servicos (0035679001600136584).jpg',NULL,'arquivo','2020-09-14'),(717,'dhzF9uVbeHADYh72GyuSywpMQ','zHD//17/dhzF9uVbeHADYh72GyuSywpMQ/arquivos/','2020-carta-de-servicos (0207604001600137355).jpg',NULL,'arquivo','2020-09-14'),(718,'toS9n4niuEK6gqqSlqtdTwqHH','zHD//25/toS9n4niuEK6gqqSlqtdTwqHH/arquivos/','2020-carta-de-servicos (0137636001600138344).jpg',NULL,'arquivo','2020-09-14'),(719,'yZRzJlsTb7lzyj0HJDqC11qKu','zHD//12/yZRzJlsTb7lzyj0HJDqC11qKu/arquivos/','2020-carta-de-servicos (0160389001600584715).jpg',NULL,'arquivo','2020-09-20'),(720,'yZRzJlsTb7lzyj0HJDqC11qKu','zHD//12/yZRzJlsTb7lzyj0HJDqC11qKu/arquivos/','2020-carta-de-servicos (0160736001600584715).jpg',NULL,'arquivo','2020-09-20'),(738,'t7K2uenLMFCoF7qnROtcUMD18','zHD/ouvidoria/12/t7K2uenLMFCoF7qnROtcUMD18/arquivos/','agua (0988859001601044248).jpg',NULL,'arquivo','2020-09-25'),(722,'77uAXMcteya43txGOZndwDmgp','zHD//25/77uAXMcteya43txGOZndwDmgp/arquivos/','2020-tabela-de-jogos (0751195001600590385).jpg',NULL,'arquivo','2020-09-20'),(723,'77uAXMcteya43txGOZndwDmgp','zHD//25/77uAXMcteya43txGOZndwDmgp/arquivos/','2020-carta-de-servicos (0751763001600590385).jpg',NULL,'arquivo','2020-09-20'),(757,'GZPT2f4JNx2wEOemND4GjKF3X','zHD//17/GZPT2f4JNx2wEOemND4GjKF3X/arquivos/','agua (0154028001601233982).jpg',NULL,'arquivo','2020-09-27'),(725,'tw8KMOEeZ2PWX1xWT3pbELVqj','zHD//17/tw8KMOEeZ2PWX1xWT3pbELVqj/arquivos/','2020-sus (0364640001600608876).jpg',NULL,'arquivo','2020-09-20'),(726,'tw8KMOEeZ2PWX1xWT3pbELVqj','zHD//17/tw8KMOEeZ2PWX1xWT3pbELVqj/arquivos/','2020-sus (0364913001600608876).jpg',NULL,'arquivo','2020-09-20'),(753,'nDfirLbLgvvSKTyugeizSxpT6','zHD//25/nDfirLbLgvvSKTyugeizSxpT6/arquivos/','agua (0821933001601233365).jpg',NULL,'arquivo','2020-09-27'),(728,'ZRCyWDtiFSnshEcO00Syq0Mrn','zHD//17/ZRCyWDtiFSnshEcO00Syq0Mrn/arquivos/','2020-tabela-de-jogos (0284808001600653380).jpg',NULL,'arquivo','2020-09-20'),(729,'vZl9i9SuDz0wdHDj2KQnjRxyQ','zHD//17/vZl9i9SuDz0wdHDj2KQnjRxyQ/arquivos/','agua (0987285001600675073).jpg',NULL,'arquivo','2020-09-21'),(730,'vZl9i9SuDz0wdHDj2KQnjRxyQ','zHD//17/vZl9i9SuDz0wdHDj2KQnjRxyQ/arquivos/','agua (0987738001600675073).jpg',NULL,'arquivo','2020-09-21'),(731,'cRpI0a84FB5SDu7hDg6JEj6SQ','zHD/ouvidoria/12/cRpI0a84FB5SDu7hDg6JEj6SQ/arquivos/','agua (0476892001600933452).jpg',NULL,'arquivo','2020-09-24'),(769,'heIMttpo2cKt1HmdUEqMCVP7c','zHD//12/heIMttpo2cKt1HmdUEqMCVP7c/arquivos/','agua (0016477001602510158).jpg',NULL,'arquivo','2020-10-12'),(733,'4YqJvGv8QNponN6myQSW0gwJG','zHD//25/4YqJvGv8QNponN6myQSW0gwJG/arquivos/','agua (0658677001600935087).jpg',NULL,'arquivo','2020-09-24'),(758,'olYsxjhy5XcWedaGmz7cAzUSB','zHD/ouvidoria/25/olYsxjhy5XcWedaGmz7cAzUSB/arquivos/','agua (0276794001601234105).jpg',NULL,'arquivo','2020-09-27'),(735,'QpZftvcIa01slZrXA5zNx268D','zHD//17/QpZftvcIa01slZrXA5zNx268D/arquivos/','agua (0366243001600935261).jpg',NULL,'arquivo','2020-09-24'),(754,'wmuFb9hYchtNczHZjjA8aa04u','zHD/ouvidoria/25/wmuFb9hYchtNczHZjjA8aa04u/arquivos/','agua (0727778001601233410).jpg',NULL,'arquivo','2020-09-27'),(737,'cIZeURvYrlPJpQfjiteXqzV5B','zHD/ouvidoria/12/cIZeURvYrlPJpQfjiteXqzV5B/arquivos/','agua (0490630001600944829).jpg',NULL,'arquivo','2020-09-24'),(740,'QX6dyMgyW6UP911GFPOdpVyNp','zHD/ouvidoria/12/QX6dyMgyW6UP911GFPOdpVyNp/arquivos/','agua (0899838001601044548).jpg',NULL,'arquivo','2020-09-25'),(771,'n55zBAa4c4HuxT3m8bprWXuY2','zHD/ouvidoria/12/n55zBAa4c4HuxT3m8bprWXuY2/arquivos/','agua (0400999001602537576).jpg',NULL,'arquivo','2020-10-12'),(742,'kFHmm4afi0xjILdQfKzPh05fG','zHD//17/kFHmm4afi0xjILdQfKzPh05fG/arquivos/','agua (0528780001601072179).jpg',NULL,'arquivo','2020-09-25'),(755,'F6zpENozxLSAnklTbdLmgEeMW','zHD//25/F6zpENozxLSAnklTbdLmgEeMW/arquivos/','agua (0339157001601233537).jpg',NULL,'arquivo','2020-09-27'),(744,'djSm7SCskHvUFTODTNfqLqjnX','zHD//17/djSm7SCskHvUFTODTNfqLqjnX/arquivos/','agua (0303707001601072763).jpg',NULL,'arquivo','2020-09-25'),(745,'oVdaNCs8wyc0hBcZIG8JzR2VW','zHD//17/oVdaNCs8wyc0hBcZIG8JzR2VW/arquivos/','agua (0005275001601116658).jpg',NULL,'arquivo','2020-09-26'),(756,'JAtbmzvJqjtk6mlMfPfHqlQdX','zHD//17/JAtbmzvJqjtk6mlMfPfHqlQdX/arquivos/','agua (0104013001601233954).jpg',NULL,'arquivo','2020-09-27'),(759,'0ysStG9BAQdEBQhTowU1KPhto','zHD/ouvidoria/12/0ysStG9BAQdEBQhTowU1KPhto/arquivos/','agua (0799682001601235033).jpg',NULL,'arquivo','2020-09-27'),(760,'gDFEokI1vSYkpCKGVCAll8XIL','zHD//25/gDFEokI1vSYkpCKGVCAll8XIL/arquivos/','agua (0631698001601235092).jpg',NULL,'arquivo','2020-09-27'),(761,'5spRCfsfl78DzQ6jH8fosd8Xf','zHD//17/5spRCfsfl78DzQ6jH8fosd8Xf/arquivos/','agua (0806252001601235157).jpg',NULL,'arquivo','2020-09-27'),(770,'DSwL5SVL8763BQSnoFDXHH2wR','zHD//25/DSwL5SVL8763BQSnoFDXHH2wR/arquivos/','agua (0948513001602537329).jpg',NULL,'arquivo','2020-10-12'),(763,'AfSsaWIUTfn0CUZpNs0fha0jj','zHD//25/AfSsaWIUTfn0CUZpNs0fha0jj/arquivos/','agua (0417088001601683611).jpg',NULL,'arquivo','2020-10-02'),(764,'b2hHLcvrkCShLAQ9JltsY1ppP','zHD/ouvidoria/12/b2hHLcvrkCShLAQ9JltsY1ppP/arquivos/','agua (0552160001602422552).jpg',NULL,'arquivo','2020-10-11'),(765,'VGt2RxH9AUmStJiHmua4M8uAd','zHD/ouvidoria/12/VGt2RxH9AUmStJiHmua4M8uAd/arquivos/','agua (0319390001602423867).jpg',NULL,'arquivo','2020-10-11'),(772,'wzNt8N4RvvnWkUBwGXgbMXldL','zHD/ouvidoria/12/wzNt8N4RvvnWkUBwGXgbMXldL/arquivos/','agua (0852037001602898087).jpg',NULL,'arquivo','2020-10-16'),(767,'WjLyqr4lGjDBEEVTSuy4DD0vO','zHD/ouvidoria/12/WjLyqr4lGjDBEEVTSuy4DD0vO/arquivos/','agua (0345658001602424991).jpg',NULL,'arquivo','2020-10-11'),(785,'zSxCoulLl02gBYDjlYHzzQm7B','zHD/ouvidoria/12/zSxCoulLl02gBYDjlYHzzQm7B/arquivos/','agua (0879574001603647375).jpg',NULL,'arquivo','2020-10-25'),(774,'Y4OXsJX3zvSDHADsDvSmPjv2u','zHD//12/Y4OXsJX3zvSDHADsDvSmPjv2u/arquivos/','agua (0120895001603128929).jpg',NULL,'arquivo','2020-10-19'),(776,'FZkcOtfgKuexNjIzlOXH8Gngp','zHD//12/FZkcOtfgKuexNjIzlOXH8Gngp/arquivos/','agua (0874987001603311122).jpg',NULL,'arquivo','2020-10-21'),(777,'DpZfzYj5YP6cMVjNscA0A8v9G','zHD//12/DpZfzYj5YP6cMVjNscA0A8v9G/arquivos/','agua (0319889001603311172).jpg',NULL,'arquivo','2020-10-21'),(778,'pUGurm7aAwyFTv2uhg65p3dq2','zHD//25/pUGurm7aAwyFTv2uhg65p3dq2/arquivos/','agua (0265644001603311373).jpg',NULL,'arquivo','2020-10-21'),(779,'i925Dn51T4P1q6tucrbKjxO25','zHD//17/i925Dn51T4P1q6tucrbKjxO25/arquivos/','agua (0416076001603311499).jpg',NULL,'arquivo','2020-10-21'),(780,'txB1dyF88W8Ulq3lhiokoOtZ1','zHD//12/txB1dyF88W8Ulq3lhiokoOtZ1/arquivos/','agua (0506653001603311869).jpg',NULL,'arquivo','2020-10-21'),(781,'voVH03sU1vyNgDmrsFmppfREY','zHD//12/voVH03sU1vyNgDmrsFmppfREY/arquivos/','agua (0478521001603378128).jpg',NULL,'arquivo','2020-10-22'),(782,'XJBeChZ0tb5ryCxqlWlKEc9rj','zHD//12/XJBeChZ0tb5ryCxqlWlKEc9rj/arquivos/','agua (0099931001603378385).jpg',NULL,'arquivo','2020-10-22'),(783,'rUXdiRs54nGyFsESinvCCYiPW','zHD//25/rUXdiRs54nGyFsESinvCCYiPW/arquivos/','agua (0433698001603378900).jpg',NULL,'arquivo','2020-10-22'),(784,'dYBkO5CGetYETHqW30psceKIb','zHD/ouvidoria/12/dYBkO5CGetYETHqW30psceKIb/arquivos/','agua (0000899001603647271).jpg',NULL,'arquivo','2020-10-25'),(786,'FjkC54hGXRMhQomwcEtm2zu8K','zHD/ouvidoria/12/FjkC54hGXRMhQomwcEtm2zu8K/arquivos/','agua (0053365001603647468).jpg',NULL,'arquivo','2020-10-25'),(787,'q4yzRVtgpaIOid7MzbAyPOxLB','zHD/ouvidoria/12/q4yzRVtgpaIOid7MzbAyPOxLB/arquivos/','agua (0216690001603647497).jpg',NULL,'arquivo','2020-10-25'),(788,'SPLOt3vgMu5xs2oarFMOxpGyZ','zHD//12/SPLOt3vgMu5xs2oarFMOxpGyZ/arquivos/','agua (0753210001603649015).jpg',NULL,'arquivo','2020-10-25'),(789,'QnWEj7wSwmmQJsk111F69KflN','zHD//12/QnWEj7wSwmmQJsk111F69KflN/arquivos/','agua (0327428001603650022).jpg',NULL,'arquivo','2020-10-25'),(790,'74Y2FiP4aO9iDQsS5HmozwpyE','zHD//25/74Y2FiP4aO9iDQsS5HmozwpyE/arquivos/','agua (0413158001603650325).jpg',NULL,'arquivo','2020-10-25'),(791,'lHMhHpHbn7JDhhPguOPfM0CnY','zHD/ouvidoria/25/lHMhHpHbn7JDhhPguOPfM0CnY/arquivos/','agua (0561907001603650364).jpg',NULL,'arquivo','2020-10-25'),(792,'XesJZTfH6WR1mZYqozJNzXAVg','zHD//17/XesJZTfH6WR1mZYqozJNzXAVg/arquivos/','agua (0292455001603650597).jpg',NULL,'arquivo','2020-10-25'),(793,'ItTRs7ALJIArtGGVa5dbmUKXZ','zHD/ouvidoria/1/ItTRs7ALJIArtGGVa5dbmUKXZ/arquivos/','PPA-VOTE-AQUI (0940462001641936628).jpg',NULL,'arquivo','2022-01-11'),(794,'46BV4msN2x5ccg66aqeLeWL8A','zHD/ouvidoria/1/46BV4msN2x5ccg66aqeLeWL8A/arquivos/','PPA-VOTE-AQUI (0936386001641936842).jpg',NULL,'arquivo','2022-01-11'),(795,'Z86neGzhDzNPsvF6hYjNZZGOJ','zHD/ouvidoria/1/Z86neGzhDzNPsvF6hYjNZZGOJ/arquivos/','PPA-VOTE-AQUI (0189805001641939551).jpg',NULL,'arquivo','2022-01-11'),(797,'E30sfQlM2SAgRD93rpOUarO2p','zHD//1/E30sfQlM2SAgRD93rpOUarO2p/arquivos/','Documentos Empresa FRANCISCO (0429354001648733864).pdf',NULL,'arquivo','2022-03-31'),(798,'gZx1qNgtMZXYf1uhxNgw3jlTx','zHD/ouvidoria/1/gZx1qNgtMZXYf1uhxNgw3jlTx/arquivos/','Documento Ilustrativo 1 (0697522001677212354).pdf',NULL,'arquivo','2023-02-24'),(799,'LrYk9scwmOZRfGwFZCSmtw6u3','zHD/ouvidoria/1/LrYk9scwmOZRfGwFZCSmtw6u3/arquivos/','Documento Ilustrativo 1 (0396237001677212530).pdf',NULL,'arquivo','2023-02-24');

--
-- Table structure for table `ouvidoria_finalidades`
--

CREATE TABLE `ouvidoria_finalidades` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nome` varchar(250) NOT NULL,
  `entidade` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `entidade` (`entidade`)
) ENGINE=MyISAM AUTO_INCREMENT=186 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `ouvidoria_finalidades`
--

INSERT INTO `ouvidoria_finalidades` (`id`, `nome`, `entidade`) VALUES (1,'Críticas',1),(155,'Denúncias',1),(156,'Elogios',1),(157,'Reclamações',1),(158,'Solicitações',1),(159,'Sugestões',1),(161,'Críticas',1),(163,'Assunto A',4),(164,'Assunto B',4),(165,'Denúncia',23),(166,'Solicitação',23),(172,'Crimes contra a Fauna',5),(171,'Crimes contra a Flora',5),(173,'Críticas',2),(174,'Denúncias',2),(175,'Elogios',2),(176,'Reclamações',2),(177,'Solicitações',2),(178,'Sugestões',2),(179,'Crítica',5),(180,'Denúncias',5),(185,'Elogios',5),(182,'Reclamações',5),(183,'Solicitações',5),(184,'Sugestões',5);

--
-- Table structure for table `ouvidoria_respostas`
--

CREATE TABLE `ouvidoria_respostas` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ouvidoria` int(11) NOT NULL DEFAULT 0,
  `usuario` int(11) NOT NULL DEFAULT 0,
  `resposta` text NOT NULL,
  `codigo` varchar(25) NOT NULL,
  `data` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `data` (`data`),
  KEY `ouvidoria` (`ouvidoria`)
) ENGINE=MyISAM AUTO_INCREMENT=273 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `ouvidoria_respostas`
--

INSERT INTO `ouvidoria_respostas` (`id`, `ouvidoria`, `usuario`, `resposta`, `codigo`, `data`) VALUES (195,9734,1,'resposta teste 17.39','fbKDiuU9BLb0AO9tERDKFSvyP','2018-10-04 20:57:26'),(196,9735,1,'18.04','MqEIkstrg1spfz7JCkglaL9HP','2018-10-04 21:04:14'),(197,9736,1,'18.07','ma5iby1Knm31MBSkEpz1Ad1ip','2018-10-04 21:07:34'),(204,1,1,'Prezados José Carlos\r\nJá estamos providenciando nossa brigadas para resolver a situação.\r\nAgradecemos pela informação.','NEvG4zg79XI0P38ZHKyGkAIPg','2019-10-24 17:31:36'),(201,9771,1,'Prezado Marcos, Já encaminhamos nossas equipes de Fiscalização para verificar a sua denúncia. Agradecemos sua atenção.\r\n','IqM7LEOYMwb4uX9kEAB21lAMU','2019-10-03 05:08:13'),(202,9776,1,'Prezado Julio,\r\nLorem ipsão dolor sít amçet, consectetur adipiscing elit. Sed vehicula id odio quis rhoncus.\r\nDonec ullamcorper, lectus in dictum porta, urna nisl tincidunt metus, at iaculis nunc sem vit\r\ne diam. Etiam quam orci, volutpat a justo non, pretium condimentum felis. Duis id elementum arcu.\r\nMauris pharetra dui molestie tortor imperdiet. \r\nJoão da Silva Ouvidor','WY3pywuPOAcguxiDprrA4Bpdj','2019-10-06 13:37:19'),(265,333,1,'Lorem ipsão dolor sít amçet, consectetur adipiscing elit. Sed vehicula id odio quis rhoncus. Donec ullamcorper, lectus in dictum porta, urna nisl tincidunt metus, at iaculis nunc sem vitae diam.','zSxCoulLl02gBYDjlYHzzQm7B','2020-10-25 17:36:07'),(251,204,1,'TESTE','I2RtuAlpKuntiTkhA8u0D31fJ','2020-10-04 20:40:35'),(206,14,1,'Enviamos uma equipe de socorristas e uma equipe de peritos para o local para debelar oo incêndios e investigar.\r\nAgradecemos pelo seu aviso','D5vF8rVhlevbMzgQbieZa5jiz','2020-06-08 08:48:09'),(266,334,1,'Lorem ipsão dolor sít amçet, consectetur adipiscing elit. Sed vehicula id odio quis rhoncus. Donec ullamcorper, lectus in dictum porta, urna nisl tincidunt metus, at iaculis nunc sem vitae diam.','q4yzRVtgpaIOid7MzbAyPOxLB','2020-10-25 17:38:06'),(268,338,1,'Lorem ipsão dolor sít amçet, consectetur adipiscing elit. Sed vehicula id odio quis rhoncus. Donec ullamcorper, lectus in dictum porta, urna nisl tincidunt metus, at iaculis nunc sem vitae diam.','lHMhHpHbn7JDhhPguOPfM0CnY','2020-10-25 18:25:56'),(248,193,1,'Despacho ilustrativo Coronavírus - Lorem ipsão dolor sít amçet, consectetur adipiscing elit. Sed vehicula id odio quis rhoncus. Donec ullamcorper, lectus in dictum porta, urna nisl tincidunt metus, at iaculis nunc sem vitae diam. Etiam quam orci, volutpat a justo non, pretium condimentum felis. Duis id elementum arcu. Mauris pharetra dui molestie tortor imperdiet. ','wmuFb9hYchtNczHZjjA8aa04u','2020-09-27 19:03:24'),(249,194,1,'Despacho ilustrativo Coronavirus - Lorem ipsão dolor sít amçet, consectetur adipiscing elit. Sed vehicula id odio quis rhoncus. Donec ullamcorper, lectus in dictum porta, urna nisl tincidunt metus, at iaculis nunc sem vitae diam. Etiam quam orci, volutpat a justo non, pretium condimentum felis. Duis id elementum arcu. Mauris pharetra dui molestie tortor imperdiet. ','olYsxjhy5XcWedaGmz7cAzUSB','2020-09-27 19:14:58'),(267,333,1,'Lorem ipsão dolor sít amçet, consectetur adipiscing elit. Sed vehicula id odio quis rhoncus. Donec ullamcorper, lectus in dictum porta, urna nisl tincidunt metus, at iaculis nunc sem vitae diam.','9CC8GUpnZxtHzhrYYTSAQw2Zk','2020-10-25 17:44:58'),(253,209,1,'TESTE','rpaWoR2xzDA1dqrRvm75itx7n','2020-10-04 22:27:58'),(254,211,1,'TESTE','wBijZeoqtAEaLipSck49pZZUe','2020-10-04 22:28:33'),(272,475,1,'Lorem ipsão dolor sít amçet, consectetur adipiscing elit. Sed vehicula id odio quis rhoncus. Donec ullamcorper, lectus in dictum porta, urna nisl tincidunt metus, at iaculis nunc sem vitae diam. Etiam quam orci, volutpat a justo non, pretium condimentum felis. Duis id elementum arcu. Mauris pharetra dui molestie tortor imperdiet. \r\n\r\nLorem ipsão dolor sít amçet, consectetur adipiscing elit. Sed vehicula id odio quis rhoncus. Donec ullamcorper, lectus in dictum porta, urna nisl tincidunt metus, at iaculis nunc sem vitae diam. Etiam quam orci, volutpat a justo non, pretium condimentum felis. Duis id elementum arcu. Mauris pharetra dui molestie tortor imperdiet. ','LrYk9scwmOZRfGwFZCSmtw6u3','2023-02-24 04:22:01');

--
-- Table structure for table `ouvidoria_setup`
--

CREATE TABLE `ouvidoria_setup` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `url_consulta` text DEFAULT NULL,
  `email_email` varchar(100) DEFAULT NULL,
  `email_nome` varchar(100) DEFAULT NULL,
  `email_host` varchar(100) DEFAULT NULL,
  `email_login` varchar(100) DEFAULT NULL,
  `email_senha` varchar(100) DEFAULT NULL,
  `email_porta` varchar(100) DEFAULT NULL,
  `entidade` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `ouvidoria_setup`
--

INSERT INTO `ouvidoria_setup` (`id`, `url_consulta`, `email_email`, `email_nome`, `email_host`, `email_login`, `email_senha`, `email_porta`, `entidade`) VALUES (1,'https://transparencia.prefeiturasonline.com..br/ouvidoria/consulta/','noreply@prefeiturasonline.com.br','Ouvidoria','mail.prefeiturasonline.com.br','noreply@prefeiturasonline.com.br','user351351351','465',0),(2,'https://prefeiturasonline.com.br/web/pag.php?pg=ouvidoria/historico&protocolo=','noreply@prefeiturasonline.com.br','Ouvidoria Prefeituras Online','mail.prefeiturasonline.com.br','noreply@prefeiturasonline.com.br','user351351351','465',1),(3,'https://sema.prefeiturasonline.com.br/pag.php?pg=ouvidoria/historico&protocolo=','noreply@prefeiturasonline.com.br','Ouvidoria Meio Ambiente','mail.prefeiturasonline.com.br','noreply@prefeiturasonline.com.br','user351351351','465',5),(4,'https://coronavirus.prefeiturasonline.com.br/pag.php?pg=ouvidoria/historico&protocolo=','noreply@prefeiturasonline.com.br','Ouvidoria Coronavírus','mail.prefeiturasonline.com.br','noreply@prefeiturasonline.com.br','user351351351','465',2);

--
-- Table structure for table `ouvidoria_status`
--

CREATE TABLE `ouvidoria_status` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nome` varchar(250) NOT NULL,
  `entidade` int(11) NOT NULL DEFAULT 0,
  `padrao` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `entidade` (`entidade`)
) ENGINE=MyISAM AUTO_INCREMENT=173 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `ouvidoria_status`
--

INSERT INTO `ouvidoria_status` (`id`, `nome`, `entidade`, `padrao`) VALUES (1,'Respondido',1,0),(2,'Finalizado',1,0),(162,'Recebido',23,0),(163,'Finalizado',23,0),(164,'Pendente',23,0),(165,'Recebido',5,1),(166,'Respondido',5,0),(167,'Encerrado',5,0),(169,'Respondido',2,0),(170,'Finalizado',2,0),(171,'Recebido',1,1),(172,'Recebido',2,1);

--
-- Table structure for table `pesquisas`
--

CREATE TABLE `pesquisas` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `usuario` int(11) NOT NULL DEFAULT 0,
  `publico` int(11) NOT NULL DEFAULT 0,
  `titulo` text NOT NULL,
  `imagem` text DEFAULT NULL,
  `tag` text NOT NULL,
  `texto` text DEFAULT NULL,
  `secao` int(11) NOT NULL,
  `data` datetime DEFAULT current_timestamp(),
  `ignorar_ip` int(11) DEFAULT 0,
  `entidade` int(11) NOT NULL,
  `status` int(11) DEFAULT 1,
  PRIMARY KEY (`id`),
  KEY `entidade` (`entidade`)
) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `pesquisas`
--

INSERT INTO `pesquisas` (`id`, `usuario`, `publico`, `titulo`, `imagem`, `tag`, `texto`, `secao`, `data`, `ignorar_ip`, `entidade`, `status`) VALUES (3,1,1,'O que você pensa sobre o combate à COVID-19','zHD/pesquisas/12/0809501001593646695.jpg','oquevocepensasobreocombateacovid-19','Esta pesquisa foi criada para nortear os passos da Prefeitura com relação as medidas de segurança que deverão ser tomadas para combater o Coronavírus.\r\n\r\nParticipe, dê sua opinião !',4,'2021-04-13 00:00:00',1,1,1),(8,1,1,'Aquecimento global','zHD/pesquisas/5/0970954001619013576.jpg','aquecimentoglobal','Existe muita polêmica sobre o aquecimento global. Há cientistas que defendem a ideia que o planeta esta aquecendo. Outros mostram que isto é resultado dos ciclos solares e que o planeta irá passar agora por um período de resfriamento. O que pensam os cidadãos do nosso município?',10,'2021-04-21 00:00:00',1,5,1),(5,1,1,'Pesquisa sobre a quarentena','zHD/pesquisas/25/0429891001592852084.jpg','pesquisasobreaquarentena','O objetivo da pesquisa é conhecer a opinião do cidadão sobre a quarentena durante a pandemia do Coronavírus. Participe e nos ajude para que possamos decidir e tomar as ações necessárias.',5,'2020-06-10 00:00:00',0,2,1),(6,1,1,'Dê sua opinião sobre a volta às aulas','zHD/pesquisas/25/0481693001592852058.jpg','desuaopiniaosobreavoltaasaulas_1','Sua opinião é importante para decidirmos sobre a volta às aulas, participe e colabore para tomarmos as melhores decisões. O voto de todos é muito importante!',6,'2020-06-10 00:00:00',0,2,1),(7,1,1,'Como você está tendo acesso ao material escolar?','zHD/pesquisas/25/0481693001592852058.jpg','comovoceestatendoacessoaomaterialescolar','Sua opinião é importante para decidirmos sobre a volta às aulas, participe e colabore para tomarmos as melhores decisões. O voto de todos é muito importante!',9,'2020-06-10 00:00:00',1,4,1),(10,1,0,'TESTE',NULL,'teste','TESTE',9,'2021-06-16 00:00:00',0,4,0);

--
-- Table structure for table `pesquisas_opcoes`
--

CREATE TABLE `pesquisas_opcoes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ordem` int(11) NOT NULL DEFAULT 0,
  `pesquisa` int(11) NOT NULL DEFAULT 0,
  `titulo` text NOT NULL,
  `tipo` varchar(50) NOT NULL,
  `json` text DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `enquete` (`pesquisa`)
) ENGINE=MyISAM AUTO_INCREMENT=34 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `pesquisas_opcoes`
--

INSERT INTO `pesquisas_opcoes` (`id`, `ordem`, `pesquisa`, `titulo`, `tipo`, `json`) VALUES (6,1,3,'Você é a favor o lockdown?','opcoes','{\"0\":\"Sou a favor.\",\"1\":\"Sou contra.\"}'),(29,2,3,'Escreva a sua sugestão de medidas que deveriam ser tomadas.','texto','null'),(8,3,3,'Qual sua opinião sobre o tratamento precoce?','opcoes','{\"0\":\"Sou a favor.\",\"1\":\"Sou contra.\"}'),(9,4,3,'Qual sua opinião sobre o direito de ir e vir das pessoas durante a pandemia?','texto','null'),(31,1,8,'Deixe sua opinião sobre este tema?','texto','null'),(30,1,8,'Você acredita no aquecimento global?','sim-nao','{\"0\":\"Sim\",\"1\":\"N\\u00e3o\"}'),(16,1,5,'Você é a favor da quarentena?','sim-nao','{\"0\":\"Sim\",\"1\":\"N\\u00e3o\"}'),(17,1,5,'Você acha que ela resulta em diminuição dos riscos?','sim-nao','{\"0\":\"Sim\",\"1\":\"N\\u00e3o\"}'),(18,1,5,'Deixe um comentário sobre este assunto.','texto','null'),(19,1,6,'Você é da região urbana ou rural?','opcoes','{\"0\":\"Urbana\",\"1\":\"Rural\"}'),(20,1,6,'Você acha que devemos voltar às aulas ou outras opções?','opcoes','{\"0\":\"Voltar \\u00e0s aulas.\",\"1\":\"Disponibilizar aulas pela Internet.\",\"2\":\"Fornecer aulas impressas para estudar em casa.\",\"3\":\"Aguardar at\\u00e9 que seja poss\\u00edvel voltar sem usar outros m\\u00e9todos.\"}'),(22,1,6,'Se quiser faça suas observações.','texto','null'),(23,1,7,'Você é pai, responsável ou aluno?','opcoes','{\"0\":\"Pai.\",\"1\":\"Respons\\u00e1vel.\",\"2\":\"Aluno.\"}'),(24,2,7,'Você mora na área urbana ou rural?','opcoes','{\"0\":\"Rural\",\"1\":\"Urbana\"}'),(33,4,7,'Seu acesso à Internet permite você assistir a vídeos?','sim-nao','{\"0\":\"Sim\",\"1\":\"N\\u00e3o\"}'),(26,3,7,'Você tem acesso à Internet em sua casa?','sim-nao','{\"0\":\"Sim\",\"1\":\"N\\u00e3o\"}'),(27,5,7,'Como você tem acesso ao conteúdo escolar? ','opcoes','{\"0\":\"A dist\\u00e2ncia pela Internet\",\"1\":\"Vou buscar o conte\\u00fado na escola\",\"2\":\"Recebo material em casa\",\"3\":\"Nenhuma das op\\u00e7\\u00f5es\"}'),(32,6,7,'Você tem um dispositivo para acessar a Internet? Qual?','opcoes','{\"0\":\"Computador\",\"1\":\"Notebook\",\"2\":\"Celular\",\"3\":\"N\\u00e3o tenho nenhum\"}'),(28,7,7,'Você acha que o ensino a distância resolve a impossibilidade de aulas presenciais? Deixe uma sugestão sobre a melhor forma de atender suas necessidades de ensino neste momento.','texto','null');

--
-- Table structure for table `pesquisas_respostas`
--

CREATE TABLE `pesquisas_respostas` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `pesquisa` int(11) NOT NULL DEFAULT 0,
  `formulario` varchar(25) NOT NULL,
  `json` text DEFAULT NULL,
  `ip` varchar(50) NOT NULL,
  `data` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `enquete` (`pesquisa`),
  KEY `ip` (`ip`),
  KEY `data` (`data`),
  KEY `formulario` (`formulario`)
) ENGINE=MyISAM AUTO_INCREMENT=34 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `pesquisas_respostas`
--

INSERT INTO `pesquisas_respostas` (`id`, `pesquisa`, `formulario`, `json`, `ip`, `data`) VALUES (8,4,'9slrcjJ2Q4JuOI8vaQjoakodT','{\"12\":\"Regular\",\"13\":\"Sim\",\"14\":\"Meios Digitais\",\"15\":\"Parab\\u00e9ns pela iniciativa.\",\"10\":\"Pai\",\"11\":\"Urbana\"}','177.235.112.213','2020-05-28 23:13:35'),(7,4,'guOFxf0xLoSjBDdikMBzsPQR3','{\"10\":\"Pai\",\"11\":\"Urbana\",\"12\":\"Regular\",\"13\":\"Sim\",\"14\":\"Atividades Impressas\",\"15\":\"xD\"}','187.32.137.101','2020-05-26 00:28:55'),(9,4,'LAp52hlbgZl0jnydFpXG5eKyj','{\"12\":\"Regular\",\"13\":\"N\\u00e3o\",\"14\":\"Atividades Impressas\",\"15\":\"Acho melhor perder este ano.\",\"10\":\"Pai\",\"11\":\"Rural\"}','177.235.112.213','2020-05-28 23:14:43'),(10,4,'VfTaXBFIAWlJw7otVREoWMN6g','{\"10\":\"Pai\",\"11\":\"Urbana\",\"13\":\"N\\u00e3o\",\"12\":\"Educa\\u00e7\\u00e3o Especial\",\"14\":\"Redes Sociais\",\"15\":\"\"}','177.235.112.213','2020-05-29 00:44:38'),(11,4,'c4BufmKxnWM6k7ZcpP5OsdRI8','{\"10\":\"Pai\",\"11\":\"Urbana\",\"13\":\"Sim\",\"12\":\"Educa\\u00e7\\u00e3o Ind\\u00edgenas\",\"14\":\"Plataformas Virtuais\",\"15\":\"\"}','177.235.112.213','2020-05-29 00:45:22'),(12,4,'GQwqAEux60sFWGQygGd4umta4','{\"10\":\"Pai\",\"11\":\"Urbana\",\"13\":\"Sim\",\"12\":\"Educa\\u00e7\\u00e3o Especial\",\"14\":\"V\\u00eddeo Aulas\",\"15\":\"\"}','177.235.112.213','2020-05-29 00:46:02'),(13,4,'aQeDgJvkwSbhAzzGSTltbbap6','{\"10\":\"Aluno\",\"11\":\"Urbana\",\"13\":\"Sim\",\"12\":\"Regular\",\"14\":\"Atividades Impressas\",\"15\":\"\"}','177.235.112.213','2020-05-29 00:47:01'),(14,3,'76ABaDq9Z0BF6qdC62MJdcP7q','{\"6\":\"N\\u00e3o\",\"7\":\"Manter isolamento de pessoas do grupo de risco e liberar o restante.\",\"8\":\"Deve ser usada com acompanhamento m\\u00e9dico\",\"9\":\"\"}','177.235.112.213','2020-05-29 00:53:14'),(15,3,'IawEUShbo3UlEqEwVfaeWcBli','{\"6\":\"Sim\",\"7\":\"Manter isolamento de pessoas do grupo de risco e liberar o restante.\",\"8\":\"N\\u00e3o tenho opini\\u00e3o\",\"9\":\"\"}','177.235.112.213','2020-05-29 00:54:53'),(16,3,'f6rYxMoesCmsqKbhJ1F1uEAUm','{\"6\":\"N\\u00e3o\",\"7\":\"Manter tudo funcionando com protocolos de seguran\\u00e7a.\",\"8\":\"N\\u00e3o deve ser usada\",\"9\":\"\"}','177.235.112.213','2020-05-29 00:56:19'),(17,5,'gujP08Znjyy6EyxPiXh1vtx4t','{\"16\":\"Sim\",\"17\":\"Sim\",\"18\":\"\"}','177.235.112.213','2020-06-17 04:22:10'),(18,7,'AcODjAS0ncCMCzT7pdt5UYc4y','{\"23\":\"Pai.\",\"24\":\"Urbana\",\"25\":\"Pela Internet.\",\"26\":\"Sim\",\"27\":\"Internet\",\"28\":\"Espero o retorno \\u00e0s aulas imediatamente\"}','177.235.119.118','2020-10-26 17:10:01'),(19,6,'fbUBFKgMRaPRiDlDnMrZVnmMW','{\"19\":\"Urbana\",\"20\":\"Voltar \\u00e0s aulas.\",\"22\":\"\"}','177.235.118.144','2021-04-16 04:57:20'),(20,5,'Ce9PnU6eS7jZQOGh9bT0xSBfL','{\"16\":\"Sim\",\"17\":\"Sim\",\"18\":\"\"}','177.235.118.144','2021-04-19 19:09:31'),(21,5,'2zX0oj1tpj0sdqT45tWsb9bHw','{\"16\":\"Sim\",\"17\":\"Sim\",\"18\":\"\"}','177.191.246.224','2021-04-19 19:10:01'),(22,5,'2zX0oj1tpj0sdqT45tWsb9bHw','{\"16\":\"Sim\",\"17\":\"Sim\",\"18\":\"\"}','177.191.234.11','2021-04-19 19:23:53'),(23,6,'7mVDCG32SBkJ5us2WtkMLPouV','{\"19\":\"Rural\",\"20\":\"Disponibilizar aulas pela Internet.\",\"22\":\"\"}','177.191.234.11','2021-04-19 19:34:03'),(24,8,'dPpF1Z09zaBStbpxQSWa8a3JO','{\"31\":\"\",\"30\":\"N\\u00e3o\"}','177.235.118.144','2021-04-21 14:00:39'),(25,8,'b0ZY7tUADr7qEt2LgpRCNq6Rl','{\"31\":\"\",\"30\":\"Sim\"}','177.235.118.144','2021-04-21 14:03:13'),(26,8,'b0ZY7tUADr7qEt2LgpRCNq6Rl','{\"31\":\"\",\"30\":\"Sim\"}','177.235.118.144','2021-04-21 14:03:52'),(27,8,'b0ZY7tUADr7qEt2LgpRCNq6Rl','{\"31\":\"\\u00c9 um tema pol\\u00eamico e precisa ser melhor avaliado.\",\"30\":\"Sim\"}','177.235.118.144','2021-04-21 14:04:33'),(28,8,'rWQPO8psTtYEPXtPcrXefaCCk','{\"31\":\"\",\"30\":\"Sim\"}','177.235.118.144','2021-04-21 22:57:44'),(29,8,'rWQPO8psTtYEPXtPcrXefaCCk','{\"31\":\"\",\"30\":\"Sim\"}','177.235.118.144','2021-04-21 22:58:02'),(30,8,'DuVY9Tk9To2g7nd7WiUw5bD7F','{\"31\":\"\",\"30\":\"Sim\"}','177.235.118.144','2021-04-21 23:00:28'),(31,3,'TaEu2jHC1dtHL2e7z89IVYwoL','{\"6\":\"Sou contra.\",\"29\":\"\",\"8\":\"Sou a favor.\",\"9\":\"\"}','177.235.118.144','2021-04-23 07:33:11'),(32,7,'flkSBquPyMoBLgxC3Oi660Rkk','{\"23\":\"Respons\\u00e1vel.\",\"24\":\"Urbana\",\"25\":\"Pela Internet.\",\"26\":\"Sim\",\"27\":\"impressa \",\"28\":\"tudo hoje esta funcionando com restri\\u00e7\\u00e3o s\\u00f3 nao a educa\\u00e7\\u00e3o . da qual o cidad\\u00e3o perde mais uma vez a oportunidade de evoluir \\r\\n\"}','168.90.124.57','2021-04-29 13:14:16'),(33,3,'it9L56cRY2DTcx9qPWFRhDLfS','{\"6\":\"Sou a favor.\",\"29\":\"\",\"8\":\"Sou a favor.\",\"9\":\"\"}','168.121.105.169','2023-03-21 19:27:55');

--
-- Table structure for table `pesquisas_secoes`
--

CREATE TABLE `pesquisas_secoes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nome` varchar(250) NOT NULL,
  `entidade` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `entidade` (`entidade`)
) ENGINE=MyISAM AUTO_INCREMENT=12 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `pesquisas_secoes`
--

INSERT INTO `pesquisas_secoes` (`id`, `nome`, `entidade`) VALUES (3,'Volta às aulas',1),(4,'Coronavírus',1),(5,'Pesquisa sobre a quarentena',2),(6,'Volta às aulas',2),(7,'teste',2),(8,'Pesquisas',1),(9,'Pesquisas',4),(10,'Pesquisas',5);

--
-- Table structure for table `popup`
--

CREATE TABLE `popup` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `usuario` int(11) NOT NULL DEFAULT 0,
  `titulo` text NOT NULL,
  `link` text DEFAULT NULL,
  `tag` text NOT NULL,
  `texto` text DEFAULT NULL,
  `codigo` varchar(25) NOT NULL,
  `secao` int(11) NOT NULL,
  `data` datetime DEFAULT current_timestamp(),
  `entidade` int(11) NOT NULL,
  `imagem` int(11) DEFAULT 0,
  `status` int(11) DEFAULT 1,
  `contador` int(11) DEFAULT 0,
  `app_id` int(11) DEFAULT 0,
  `app_alvo` int(11) DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `app_alvo` (`app_alvo`),
  KEY `app_id` (`app_id`),
  KEY `contador` (`contador`),
  KEY `entidade` (`entidade`)
) ENGINE=MyISAM AUTO_INCREMENT=416 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `popup`
--

INSERT INTO `popup` (`id`, `usuario`, `titulo`, `link`, `tag`, `texto`, `codigo`, `secao`, `data`, `entidade`, `imagem`, `status`, `contador`, `app_id`, `app_alvo`) VALUES (415,1,'Educação',NULL,'educacao',NULL,'dUU46sNjKaU0MZOmYdxa5IZCj',158,'2023-02-02 00:00:00',4,0,1,109,0,0),(407,1,'Padrão',NULL,'padrao',NULL,'5XkS9YOz989g1ExzKye0DSc7R',159,'2018-09-26 00:00:00',5,0,1,1067,0,0),(411,1,'Institucional',NULL,'institucional',NULL,'lMdfg4LUPtqJo9yjs3n4zoAdc',157,'2020-07-04 00:00:00',1,0,1,2474,0,0),(412,1,'Doe sangue, você também pode precisar.',NULL,'doesanguevocetambempodeprecisar.',NULL,'oxKxWcgbi2k9ah2AgEK9X0DCa',161,'2020-09-12 00:00:00',2,0,1,1036,0,0);

--
-- Table structure for table `popup_arquivos`
--

CREATE TABLE `popup_arquivos` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `codigo` varchar(25) NOT NULL,
  `path` text NOT NULL,
  `arquivo` text NOT NULL,
  `legenda` text DEFAULT NULL,
  `tipo` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `codigo` (`codigo`)
) ENGINE=MyISAM AUTO_INCREMENT=376 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `popup_arquivos`
--

INSERT INTO `popup_arquivos` (`id`, `codigo`, `path`, `arquivo`, `legenda`, `tipo`) VALUES (362,'oxKxWcgbi2k9ah2AgEK9X0DCa','zHD/popup/25/oxKxWcgbi2k9ah2AgEK9X0DCa/','campanha-doesangue (0861499001599927926).jpg','Doe sangue','imagem'),(361,'5XkS9YOz989g1ExzKye0DSc7R','zHD/popup/17/5XkS9YOz989g1ExzKye0DSc7R/','popup (0728489001599700892).jpg',NULL,'imagem'),(369,'TleO0v5e1qOrUbuASddLXdfK7','zHD/popup/4/TleO0v5e1qOrUbuASddLXdfK7/','popup1 (0970501001620847885).jpg',NULL,'imagem'),(370,'TleO0v5e1qOrUbuASddLXdfK7','zHD/popup/4/TleO0v5e1qOrUbuASddLXdfK7/','POPUP-EDU (0210614001675357365).jpg',NULL,'imagem'),(371,'dUU46sNjKaU0MZOmYdxa5IZCj','zHD/popup/4/dUU46sNjKaU0MZOmYdxa5IZCj/','POPUP-EDU (0104656001675370761).jpg',NULL,'imagem'),(375,'lMdfg4LUPtqJo9yjs3n4zoAdc','zHD/popup/1/lMdfg4LUPtqJo9yjs3n4zoAdc/','POPUP-GERAL2 (0082771001693633815).jpg',NULL,'imagem');

--
-- Table structure for table `popup_secoes`
--

CREATE TABLE `popup_secoes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nome` varchar(250) NOT NULL,
  `entidade` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `entidade` (`entidade`)
) ENGINE=MyISAM AUTO_INCREMENT=162 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `popup_secoes`
--

INSERT INTO `popup_secoes` (`id`, `nome`, `entidade`) VALUES (157,'Home',1),(158,'Home',4),(159,'Home',5),(160,'Institucional',1),(161,'Institucional',2);

--
-- Table structure for table `popup_setup`
--

CREATE TABLE `popup_setup` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `abertura` int(11) NOT NULL,
  `intervalo` int(11) NOT NULL DEFAULT 0,
  `cache` int(11) NOT NULL DEFAULT 0,
  `entidade` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=165 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `popup_setup`
--

INSERT INTO `popup_setup` (`id`, `abertura`, `intervalo`, `cache`, `entidade`) VALUES (155,0,60,0,1),(156,15,600,0,14),(157,0,180,0,5),(158,0,180,0,4),(159,15,600,0,23),(160,15,600,0,1),(161,0,180,0,2),(162,15,600,0,3),(163,15,600,0,6),(164,15,600,0,8);

--
-- Table structure for table `videos`
--

CREATE TABLE `videos` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `data` timestamp NOT NULL DEFAULT current_timestamp(),
  `secao` int(11) NOT NULL DEFAULT 0,
  `titulo` text NOT NULL,
  `descricao` text DEFAULT NULL,
  `codigo` varchar(100) NOT NULL,
  `entidade` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `entidade` (`entidade`)
) ENGINE=MyISAM AUTO_INCREMENT=101 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `videos`
--

INSERT INTO `videos` (`id`, `data`, `secao`, `titulo`, `descricao`, `codigo`, `entidade`) VALUES (91,'2021-04-23 03:00:00',1,'10 Mistérios de Detetive Que Apenas o 1% Mais Atento Conseguirá Resolver','','51cI-01iTy8',1),(89,'2021-04-23 03:00:00',1,'Enigmas de Detetives','','wtElfFXhJWA',1),(100,'2023-04-12 03:00:00',1,'Vídeo Ilustrativo','','S800sEVgFGI',1),(53,'2018-09-22 03:00:00',5,'Preservação Ambiental','','DHqMmFzAjP8',5),(54,'2018-09-22 03:00:00',5,'Ecologia, Meio ambiente e Sustentabilidade','','wbVnv5KhcIQ',5),(55,'2018-09-22 03:00:00',5,'Meio ambiente na educação infantil','','2oTkb7jx2Ak',5),(56,'2018-09-22 03:00:00',5,'Meio Ambiente - Educação e Consciência Ambiental','','MuGp1IQR9T8',5),(57,'2018-09-22 03:00:00',5,'O Cerrado corre risco','','ir_BSW6dGcc',5),(58,'2018-10-01 03:00:00',7,'É natal','Lorem ipsão dolor sít amçet, consectetur adipiscing elit. Sed vehicula id odio quis rhoncus. Donec ullamcorper, lectus in dictum porta, urna nisl tincidunt metus, at iaculis nunc sem vitae diam. Etiam quam orci, volutpat a justo non, pretium condimentum felis. Duis id elementum arcu. Mauris pharetra dui molestie tortor imperdiet. ','VEif6kU3qnE',23),(59,'2018-10-01 03:00:00',6,'Festa do no Município','Lorem ipsão dolor sít amçet, consectetur adipiscing elit. Sed vehicula id odio quis rhoncus. Donec ullamcorper, lectus in dictum porta, urna nisl tincidunt metus, at iaculis nunc sem vitae diam. Etiam quam orci, volutpat a justo non, pretium condimentum felis. Duis id elementum arcu. Mauris pharetra dui molestie tortor imperdiet. ','HKXQxP_OwDw',23),(60,'2018-10-13 03:00:00',4,'Banda Filarmônica Itajaí 1','','xW9e-9NCm-M',4),(76,'2020-11-01 03:00:00',5,'Luiz Carlos Molion - Aquecimento Global (Parte 1)','','OnPdU-PY16A',5),(61,'2018-10-13 03:00:00',4,'Banda Filarmônica Itajaí 2','','iwE_1ZR-gOY',4),(75,'2020-11-01 03:00:00',5,'Terrorismo climático - Palestra do Prof Luiz Carlos Molion - Parte 1','','9PLAPeTRSEo',5),(90,'2021-04-23 03:00:00',1,'Como economizar água','','ClcluFPSi0Y',1),(69,'2020-06-10 03:00:00',9,'Água no planta','','XrdgBK5SlDY',2),(70,'2020-06-10 03:00:00',9,'Como se proteger do COVID19','','AeR3-YVx5PM',2),(71,'2020-06-10 03:00:00',9,'Melhorar a imunidade','','iTzQ5w3kGWw',2),(72,'2020-06-10 03:00:00',9,'Descubra a importância da água','','TcIHhOCeMBg',2),(73,'2020-09-29 03:00:00',4,'O que é cultura','','o2XKjnxYMxk',4),(74,'2020-09-29 03:00:00',4,'Estações do ano','','GnJdnzOp7a4',4),(77,'2020-11-01 03:00:00',5,'Luiz Carlos Molion - Aquecimento Global (Parte 2)','','u5MJYpSsGk0',5),(78,'2020-11-01 03:00:00',5,'Luiz Carlos Molion - Aquecimento Global (Parte 3)','','G-VhC2nG5hQ',5),(79,'2020-11-01 03:00:00',5,'Luiz Carlos Molion - Aquecimento Global (Parte 4)','','PCbWPxWUOg8',5),(80,'2020-11-01 03:00:00',5,'Luiz Carlos Molion - Aquecimento Global (Parte 5)','','60EIlmMnI1I',5),(81,'2020-11-01 03:00:00',5,' Luiz Carlos Molion - Aquecimento Global (Parte 6)','','QuFRLiYZ3WE',5),(92,'2021-06-27 03:00:00',4,'BNCC Juventudes e projetos de vida','','Vc4qHyvuqD4',4),(95,'2021-09-04 03:00:00',13,'A força da nossa gente 1','','PAHtHbwFOoI',8),(96,'2021-09-04 03:00:00',13,'A força da nossa gente 2','','aP22CmWybk8',8),(97,'2021-09-04 03:00:00',13,'A força da nossa gente 3','','nkj4h6F3vcY',8),(99,'2021-09-04 03:00:00',13,'Pronampe: crédito barato para os pequenos negócios','','0wOZSiftnGs',8);

--
-- Table structure for table `videos_secoes`
--

CREATE TABLE `videos_secoes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `entidade` int(11) NOT NULL DEFAULT 0,
  `nome` varchar(250) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `entidade` (`entidade`)
) ENGINE=MyISAM AUTO_INCREMENT=14 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `videos_secoes`
--

INSERT INTO `videos_secoes` (`id`, `entidade`, `nome`) VALUES (1,1,'Vídeos'),(13,8,'Vídeos'),(3,1,'Vídeos'),(4,4,'Vídeos'),(5,5,'Vídeos'),(6,23,'Eventos'),(7,23,'Vídeos'),(9,2,'Vídeos'),(10,2,'Vídeos'),(11,2,'xD');

--
-- Dumping events for database 'jpwnet_detetives'
--

--
-- Dumping routines for database 'jpwnet_detetives'
--


