--
-- Host: localhost    Database: semecct
-- ------------------------------------------------------


--
-- Table structure for table `carta_servicos`
--

CREATE TABLE `carta_servicos` (
  `id` int NOT NULL AUTO_INCREMENT,
  `path` varchar(255) NOT NULL,
  `data` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `carta_servicos`
--

INSERT INTO `carta_servicos` VALUES (1,'/storage/docs/cartadeservico/cartadeservico.pdf','2025-01-27');

--
-- Table structure for table `departamentos`
--

CREATE TABLE `departamentos` (
  `id` int NOT NULL AUTO_INCREMENT,
  `tipo` varchar(255) NOT NULL,
  `nome` varchar(255) NOT NULL,
  `contato` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `responsavel` varchar(255) NOT NULL,
  `foto` varchar(255) DEFAULT NULL,
  `logradouro` varchar(255) NOT NULL,
  `bairro` varchar(255) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `nome` (`nome`),
  UNIQUE KEY `responsavel` (`responsavel`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `departamentos`
--


--
-- Table structure for table `dialogs`
--

CREATE TABLE `dialogs` (
  `id` int NOT NULL AUTO_INCREMENT,
  `record_id` int NOT NULL,
  `user_id` int NOT NULL,
  `protocol` bigint NOT NULL,
  `text` text NOT NULL,
  `origin` varchar(255) NOT NULL,
  `date` varchar(30) NOT NULL,
  `last` int DEFAULT NULL,
  `next` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=188 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `dialogs`
--

INSERT INTO `dialogs` VALUES (76,44,1,37863586609,'<b>Demora</b> no atendimento','c','2025-01-27',NULL,NULL),(77,44,1,37863586609,'Pedimos desculpas','p','2025-01-24',NULL,NULL),(78,44,1,37863586609,'Só pra aparecer','p','2025-01-24',NULL,NULL),(79,44,1,37863586609,'teste usuario','c','27-01-2025',NULL,NULL),(80,44,1,37863586609,'agora daqui','p','27-01-2025',NULL,NULL),(81,44,1,37863586609,'usuario','c','27-01-2025',NULL,NULL),(82,44,1,37863586609,'como prefeitura','p','27-01-2025',NULL,NULL),(83,44,1,37863586609,'mensagem da prefeitura','p','27-01-2025',NULL,NULL),(84,44,1,37863586609,'mensagem do usuario','c','27-01-2025',NULL,NULL),(85,44,1,37863586609,'Beleza, testando\r\n','p','27-01-2025',NULL,NULL),(86,44,1,37863586609,'ve se aparece ai','c','27-01-2025',NULL,NULL),(87,45,1,79757725772,'reclamação de negligencia','c','2025-01-27',NULL,NULL),(112,44,1,37863586609,'digitando','c','29-01-2025',NULL,NULL),(113,44,1,37863586609,'mais uma','c','29-01-2025',NULL,NULL),(114,44,1,37863586609,'sgsgb','c','29-01-2025',NULL,NULL),(115,44,1,37863586609,'mensagem da prefeitura','p','29-01-2025',NULL,NULL),(116,44,1,37863586609,'mensagem do usuario','c','29-01-2025',NULL,NULL),(117,46,1,38948868445,'omissao','c','2025-01-29',NULL,NULL),(118,46,1,38948868445,'problema resolvido','p','29-01-2025',NULL,NULL),(119,47,1,72914972393,'tyeste','c','2025-02-03',NULL,NULL),(120,48,1,25347879639,'fsedfsfsf','c','2025-02-03',NULL,NULL),(121,49,1,70050541487,'Teste','c','2025-02-10',NULL,NULL),(122,50,1,66340542222,'teste','c','2025-02-10',NULL,NULL),(123,51,1,79425175737,'teste','c','2025-02-10',NULL,NULL),(124,52,1,62558695798,'teste','c','2025-02-10',NULL,NULL),(125,53,1,87085089505,'teste','c','2025-02-10',NULL,NULL),(126,54,1,17209158042,'teste','c','2025-02-10',NULL,NULL),(127,55,1,27553739496,'teste','c','2025-02-10',NULL,NULL),(128,56,1,48027606172,'pessimo','c','2025-02-10',NULL,NULL),(129,57,1,54918600004,'pefiegweg','c','2025-02-10',NULL,NULL),(132,60,1,57284715137,'Denuncia de teste','c','2025-02-11',NULL,NULL),(133,61,1,11747745793,'','c','2025-02-11',NULL,NULL),(134,62,1,28212842121,'','c','2025-02-11',NULL,NULL),(135,63,1,64690963535,'','c','2025-02-11',NULL,NULL),(136,64,1,86563426571,'','c','2025-02-11',NULL,NULL),(137,65,1,94569091493,'','c','2025-02-11',NULL,NULL),(138,66,1,25174740400,'Problema no atendimento','c','2025-02-11',NULL,NULL),(139,44,1,37863586609,'outra mensagem','p','11-02-2025',NULL,NULL),(140,67,1,94124078059,'','c','2025-02-12',NULL,NULL),(141,68,1,31046314030,'','c','2025-02-12',NULL,NULL),(142,69,1,56777843070,'wgwgweg','c','2025-02-12',NULL,NULL),(143,70,1,93411963137,'wrgwrgwrgwrg','c','2025-02-12',NULL,NULL),(144,71,1,86546469109,'sadasdasdvsdv','c','2025-02-12',NULL,NULL),(145,72,1,74680000742,'sgsgsssr','c','2025-02-12',NULL,NULL),(146,73,1,17548128728,'wrgwgwrgqaergh','c','2025-02-12',NULL,NULL),(147,74,1,22174931073,'wefgwegweg','c','2025-02-12',NULL,NULL),(148,75,1,85861214311,'avasvbsbwrbg','c','2025-02-12',NULL,NULL),(149,76,1,66394732628,'rywrj','c','2025-02-12',NULL,NULL),(150,77,1,85889854659,'wewegwegweg','c','2025-02-12',NULL,NULL),(151,78,1,64762802972,'tmtm','c','2025-02-12',NULL,NULL),(152,79,1,59590114682,'chovendo muito','c','2025-02-12',NULL,NULL),(153,79,1,59590114682,'outra mensagem','p','12-02-2025',NULL,NULL),(154,80,1,13950787163,'','c','2025-02-13',NULL,NULL),(155,81,1,87304252438,'','c','2025-02-13',NULL,NULL),(156,82,1,15058823723,'','c','2025-02-14',NULL,NULL),(157,83,1,22423158066,'','c','2025-02-14',NULL,NULL),(158,84,1,68778342603,'','c','2025-02-14',NULL,NULL),(159,85,1,96353849117,'','c','2025-02-14',NULL,NULL),(160,86,1,43451780389,'teste','c','2025-02-17',NULL,NULL),(161,87,1,80052108335,'teste','c','2025-02-17',NULL,NULL),(162,88,1,59728467454,'rtsretwet','c','2025-02-17',NULL,NULL),(163,89,1,61122813335,'rewrgewrhbqaerbhqerbh','c','2025-02-17',NULL,NULL),(164,90,1,57711721634,'w4gqaergqergqerg','c','2025-02-17',NULL,NULL),(165,91,1,25424518335,'srherherherh','c','2025-02-17',NULL,NULL),(166,92,1,87819126530,'srherherherh','c','2025-02-17',NULL,NULL),(167,93,1,52925220754,'wegwegwegwegweg','c','2025-02-17',NULL,NULL),(168,94,1,87713179544,'aefAEFSEGF','c','2025-02-17',NULL,NULL),(169,95,1,42161779382,'wrgwrgwrg','c','2025-02-17',NULL,NULL),(170,96,1,30803800519,'wsrgwerg','c','2025-02-17',NULL,NULL),(171,97,1,95815027015,'qefqefqef','c','2025-02-17',NULL,NULL),(172,98,1,99006361726,'sadsdvsdv','c','2025-02-17',NULL,NULL),(173,99,1,60028302586,'wgwgweg','c','2025-02-18',NULL,NULL),(174,100,1,57217415758,'Teste','c','2025-02-18',NULL,NULL),(175,101,1,39232290751,'Teste','c','2025-02-18',NULL,NULL),(176,101,1,39232290751,'Outra mensagem','p','18-02-2025',NULL,NULL),(177,102,1,79643602737,'dasdsadasdsaasd','c','2025-02-21',NULL,NULL),(178,103,1,32192335726,'dasdsadasdsaasd','c','2025-02-21',NULL,NULL),(179,104,1,58318372337,'eeeeeeee','c','2025-02-24',NULL,NULL),(180,104,1,58318372337,'mensagem de teste','p','24-02-2025',NULL,NULL),(181,105,1,40449840760,'hfgjytjtgyjtygjy','c','2025-02-25',NULL,NULL),(182,106,1,53415196055,'Mensagem de Teste','c','2025-02-26',NULL,NULL),(183,106,1,53415196055,'Resposta da Prefeitura','p','26-02-2025',NULL,NULL),(184,106,1,53415196055,'Outra mensagem de resposta','p','26-02-2025',NULL,NULL),(185,107,1,25580465908,'asdasda','c','2025-02-26',NULL,NULL),(186,107,1,25580465908,'dfsdf','p','26-02-2025',NULL,NULL),(187,108,1,80207156146,'oi','c','2025-02-27',NULL,NULL);

--
-- Table structure for table `events`
--

CREATE TABLE `events` (
  `idevents` int NOT NULL AUTO_INCREMENT,
  `titulo` longtext NOT NULL,
  `corpo` longtext NOT NULL,
  `foto` varchar(45) NOT NULL,
  `data_evento` datetime DEFAULT NULL,
  `data_piblicacao` datetime DEFAULT NULL,
  `local` varchar(55) DEFAULT NULL,
  `data_final` time DEFAULT NULL,
  PRIMARY KEY (`idevents`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `events`
--

INSERT INTO `events` VALUES (2,'Evento #01 a','asasasas','asdasdjmnsk,','2025-01-11 20:03:00','2025-01-17 18:58:45','Rua de exemplo, nº 0, Centro, Arraial do Cabo',NULL),(3,'Evento #01 sdgfsdg','wwwwwwww','asdasdjmnsk,','2025-01-22 15:58:00','2025-01-17 18:59:07','Rua de exemplo, nº 0, Centro, Arraial do Cabo',NULL);

--
-- Table structure for table `galery`
--

CREATE TABLE `galery` (
  `idgalery` int NOT NULL,
  `foto` varchar(45) DEFAULT NULL,
  `data_foto` datetime DEFAULT NULL,
  `titulo` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`idgalery`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `galery`
--


--
-- Table structure for table `licitacao`
--

CREATE TABLE `licitacao` (
  `idlicitacao` int NOT NULL AUTO_INCREMENT,
  `numero` varchar(45) DEFAULT NULL,
  `tipo` varchar(455) DEFAULT NULL,
  `data_abertura` datetime DEFAULT NULL,
  `local_abertura` varchar(455) DEFAULT NULL,
  `valor_estimado` varchar(455) DEFAULT NULL,
  `valor_real` varchar(455) DEFAULT NULL,
  `descricao` varchar(555) DEFAULT NULL,
  `andamento` varchar(45) DEFAULT NULL,
  `ultima_modificacao` datetime DEFAULT NULL,
  `informaçoes` varchar(455) DEFAULT NULL,
  `exercicio` varchar(45) DEFAULT NULL,
  `cpf-cnpj` varchar(45) DEFAULT NULL,
  `credor` varchar(455) DEFAULT NULL,
  PRIMARY KEY (`idlicitacao`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `licitacao`
--

INSERT INTO `licitacao` VALUES (1,'65151/2025','MENOR PREÇO GLOBAL','2025-03-05 15:48:00','Prefeitura','1000000','1000000','sdfsdfsdsfsd','FRACASSADO','2025-03-05 19:49:44','asdasdasdsd','','','');

--
-- Table structure for table `news`
--

CREATE TABLE `news` (
  `idnews` int NOT NULL AUTO_INCREMENT,
  `titulo` varchar(200) NOT NULL,
  `corpo` longtext,
  `foto` varchar(1000) DEFAULT NULL,
  `data_noticia` datetime DEFAULT NULL,
  `data_publicacao` datetime DEFAULT NULL,
  `resumo` varchar(1000) DEFAULT NULL,
  `legenda` varchar(200) DEFAULT NULL,
  `tag` varchar(150) DEFAULT NULL,
  PRIMARY KEY (`idnews`),
  KEY `secrataria_tag` (`tag`),
  CONSTRAINT `secrataria_tag` FOREIGN KEY (`tag`) REFERENCES `secretarias_autarquias` (`nome`)
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `news`
--

INSERT INTO `news` VALUES (7,'Animais que assustaram banhistas em praia de Arraial do Cabo são baleias de rara aparição no Rio','\"\\\"{\\\\\\\"time\\\\\\\":1737560997184,\\\\\\\"blocks\\\\\\\":[{\\\\\\\"id\\\\\\\":\\\\\\\"ugjtgVpAd_\\\\\\\",\\\\\\\"type\\\\\\\":\\\\\\\"paragraph\\\\\\\",\\\\\\\"data\\\\\\\":{\\\\\\\"text\\\\\\\":\\\\\\\"As tr\\\\u00eas baleias que assustaram banhistas no \\\\u00faltimo s\\\\u00e1bado na Prainha, em Arraial do Cabo, na Regi\\\\u00e3o dos Lagos, ao serem confundidas com tubar\\\\u00f5es, s\\\\u00e3o de esp\\\\u00e9cies de rara apari\\\\u00e7\\\\u00e3o no estado do Rio. Segundo a prefeitura do munic\\\\u00edpio, especialistas que analisaram as imagens apontam que os animais se tratam de cachalote-an\\\\u00e3o ou cachalote-pigmeu. Um ocean\\\\u00f3grafo ouvido pelo GLOBO explica as caracter\\\\u00edsticas das duas esp\\\\u00e9cies e o motivo pelo qual as manchas vermelhas que circundaram os animais foram confundidas com sangue.\\\\\\\"}}],\\\\\\\"version\\\\\\\":\\\\\\\"2.30.7\\\\\\\"}\\\"\"','https://jpimg.com.br/uploads/2023/01/baleias-arraial-300x170.png','2025-01-23 03:03:00','2025-01-22 15:49:57','As três baleias que assustaram banhistas no último sábado na Prainha, em Arraial do Cabo, na Região dos Lagos, ao serem confundidas com tubarões, são de espécies de rara aparição no estado do Rio. Segundo a prefeitura do município, especialistas que analisaram as imagens apontam que os animais se tratam de cachalote-anão ou cachalote-pigmeu. Um oceanógrafo ouvido pelo GLOBO explica as características das duas espécies e o motivo pelo qual as manchas vermelhas que circundaram os animais foram confundidas com sangue.',NULL,NULL),(8,'Réveillon em Arraial do Cabo: Com 100% de lotação, cidade terá shows de Toni Garrido, Xande de Pilares e Yasmim Santos','\"\\\"{\\\\\\\"time\\\\\\\":1737561086856,\\\\\\\"blocks\\\\\\\":[{\\\\\\\"id\\\\\\\":\\\\\\\"YvF9fE6Pjh\\\\\\\",\\\\\\\"type\\\\\\\":\\\\\\\"header\\\\\\\",\\\\\\\"data\\\\\\\":{\\\\\\\"text\\\\\\\":\\\\\\\"R\\\\u00e9veillon em Arraial do Cabo: Com 100% de lota\\\\u00e7\\\\u00e3o, cidade ter\\\\u00e1 shows de Toni Garrido, Xande de Pilares e Yasmim Santos\\\\\\\",\\\\\\\"level\\\\\\\":2}}],\\\\\\\"version\\\\\\\":\\\\\\\"2.30.7\\\\\\\"}\\\"\"','https://s2-g1.glbimg.com/B2_ZS87Tp_OwCwwkw5DWjP6e5ug=/0x0:1600x1066/984x0/smart/filters:strip_icc()/i.s3.glbimg.com/v1/AUTH_59edd422c0c84a879bd37670ae4f538a/internal_photos/bs/2023/K/U/SCmAUYScabhlWCQTBjfA/whatsapp-image-2023-12-26-at-15.24.42.jpeg','2025-01-22 04:04:00','2025-01-22 15:51:26','doidera',NULL,NULL),(9,'Banhistas mergulham em \'mar encantado\' de águas fluorescentes em Arraial do Cabo;','\"\\\"{\\\\\\\"time\\\\\\\":1737562975440,\\\\\\\"blocks\\\\\\\":[{\\\\\\\"id\\\\\\\":\\\\\\\"0FqavFmwjn\\\\\\\",\\\\\\\"type\\\\\\\":\\\\\\\"paragraph\\\\\\\",\\\\\\\"data\\\\\\\":{\\\\\\\"text\\\\\\\":\\\\\\\"Banhistas mergulham em \'mar encantado\' de \\\\u00e1guas fluorescentes em Arraial do Cabo;\\\\\\\"}}],\\\\\\\"version\\\\\\\":\\\\\\\"2.30.7\\\\\\\"}\\\"\"','https://s2-g1.glbimg.com/RgYlEZ5dA1Rl3m6gh_D8rJGnGp0=/0x0:1705x863/984x0/smart/filters:strip_icc()/i.s3.glbimg.com/v1/AUTH_59edd422c0c84a879bd37670ae4f538a/internal_photos/bs/2024/g/P/7a2er7SBOEILYDxhclKQ/banhistas-experimentaram-mergulho-em-mar-com-aguas-fluorescentes-em-arraial-do-cabo.png','2024-12-10 00:00:00','2025-01-22 16:22:55','Banhistas mergulham em \'mar encantado\' de águas fluorescentes em Arraial do Cabo;',NULL,NULL),(10,'MPF recorre contra licença de turismo náutico para políticos em Arraial do Cabo','\"\\\"{\\\\\\\"time\\\\\\\":1737563086826,\\\\\\\"blocks\\\\\\\":[{\\\\\\\"id\\\\\\\":\\\\\\\"lgtnt_aA87\\\\\\\",\\\\\\\"type\\\\\\\":\\\\\\\"paragraph\\\\\\\",\\\\\\\"data\\\\\\\":{\\\\\\\"text\\\\\\\":\\\\\\\"O Minist\\\\u00e9rio P\\\\u00fablico Federal (MPF) recorreu ao Tribunal Regional Federal da 2\\\\u00aa Regi\\\\u00e3o (TRF2) para manter a decis\\\\u00e3o administrativa do Instituto Chico Mendes de Conserva\\\\u00e7\\\\u00e3o da Biodiversidade (ICMBio) que revoga a licen\\\\u00e7a de turismo n\\\\u00e1utico concedida ao presidente do Instituto de Pesca de&nbsp;<a href=\\\\\\\\\\\\\\\"https:\\\\\\/\\\\\\/g1.globo.com\\\\\\/rj\\\\\\/regiao-dos-lagos\\\\\\/cidade\\\\\\/arraial-do-cabo\\\\\\/\\\\\\\\\\\\\\\">Arraial do Cabo<\\\\\\/a>&nbsp;(FIPAC), e ao atual secret\\\\u00e1rio municipal de governo na Reserva Extrativista Marinha (RESEXMar) me Arraial do Cabo, na Regi\\\\u00e3o dos Lagos do Rio.\\\\\\\"}},{\\\\\\\"id\\\\\\\":\\\\\\\"AkGTW1btzV\\\\\\\",\\\\\\\"type\\\\\\\":\\\\\\\"paragraph\\\\\\\",\\\\\\\"data\\\\\\\":{\\\\\\\"text\\\\\\\":\\\\\\\"Segundo o MPF, essas autoriza\\\\u00e7\\\\u00f5es n\\\\u00e3o est\\\\u00e3o de acordo com os objetivos da unidade de conserva\\\\u00e7\\\\u00e3o, beneficiando pol\\\\u00edticos e aqueles que ocupam cargos p\\\\u00fablicos prejudicando pescadores tradicionais, leg\\\\u00edtimos benefici\\\\u00e1rios da reserva.\\\\\\\"}},{\\\\\\\"id\\\\\\\":\\\\\\\"7aPPNDZnrx\\\\\\\",\\\\\\\"type\\\\\\\":\\\\\\\"paragraph\\\\\\\",\\\\\\\"data\\\\\\\":{\\\\\\\"text\\\\\\\":\\\\\\\"De acordo com o MPF, o caso foi agravado pela concess\\\\u00e3o de licen\\\\u00e7as a pessoas em posi\\\\u00e7\\\\u00f5es privilegiadas. Ambos, n\\\\u00e3o atendem aos crit\\\\u00e9rios da categoria B, destinada exclusivamente a pescadores tradicionais cuja subsist\\\\u00eancia depende diretamente do mar.\\\\\\\"}},{\\\\\\\"id\\\\\\\":\\\\\\\"lizc3tUh7x\\\\\\\",\\\\\\\"type\\\\\\\":\\\\\\\"paragraph\\\\\\\",\\\\\\\"data\\\\\\\":{\\\\\\\"text\\\\\\\":\\\\\\\"O benefici\\\\u00e1rio da categoria \\\\\\\\\\\\\\\"B\\\\\\\\\\\\\\\" deve ser de fam\\\\u00edlia extrativista tradicional do munic\\\\u00edpio ou morador de Arraial do Cabo h\\\\u00e1 mais de 20 anos que viveu ou vive da pesca e ainda depende do mar, podendo fazer turismo ou ter outra atividade profissional, \\\\u00e9 o que est\\\\u00e1 definido na Portaria ICMBIO n.\\\\u00ba 613\\\\\\/2022.\\\\\\\"}},{\\\\\\\"id\\\\\\\":\\\\\\\"pf9OM-xV3u\\\\\\\",\\\\\\\"type\\\\\\\":\\\\\\\"paragraph\\\\\\\",\\\\\\\"data\\\\\\\":{\\\\\\\"text\\\\\\\":\\\\\\\"O recurso do MPF enfatiza que, depois de anos sem emiss\\\\u00e3o de novas licen\\\\u00e7as, os beneficiados foram justamente figuras com responsabilidades pol\\\\u00edticas e administrativas sobre a Marina dos Pescadores.\\\\\\\"}},{\\\\\\\"id\\\\\\\":\\\\\\\"1yeX3KXzRp\\\\\\\",\\\\\\\"type\\\\\\\":\\\\\\\"paragraph\\\\\\\",\\\\\\\"data\\\\\\\":{\\\\\\\"text\\\\\\\":\\\\\\\"\\\\u201cO que ocorreu foi a obten\\\\u00e7\\\\u00e3o in\\\\u00e9dita de licen\\\\u00e7as para a utiliza\\\\u00e7\\\\u00e3o da RESEXMar por pessoas em situa\\\\u00e7\\\\u00e3o de privil\\\\u00e9gio nos cargos de ger\\\\u00eancia, administra\\\\u00e7\\\\u00e3o e fiscaliza\\\\u00e7\\\\u00e3o sobre as atividades da Marina dos Pescadores\\\\u201d, ressalta trecho do recurso apresentado pelo MPF.\\\\\\\"}},{\\\\\\\"id\\\\\\\":\\\\\\\"x57BvUDz6c\\\\\\\",\\\\\\\"type\\\\\\\":\\\\\\\"paragraph\\\\\\\",\\\\\\\"data\\\\\\\":{\\\\\\\"text\\\\\\\":\\\\\\\"O procurador da Rep\\\\u00fablica Leandro Mitidieri destacou que a quest\\\\u00e3o vai al\\\\u00e9m de aspectos administrativos. Ele refor\\\\u00e7ou que as normas constitucionais e os marcos legais que regulamentam as unidades de conserva\\\\u00e7\\\\u00e3o visam a preservar os direitos das comunidades tradicionais.\\\\\\\"}},{\\\\\\\"id\\\\\\\":\\\\\\\"4rhEBCJw7O\\\\\\\",\\\\\\\"type\\\\\\\":\\\\\\\"paragraph\\\\\\\",\\\\\\\"data\\\\\\\":{\\\\\\\"text\\\\\\\":\\\\\\\"\\\\u201cAs unidades de conserva\\\\u00e7\\\\u00e3o, como a reserva extrativista, t\\\\u00eam como benefici\\\\u00e1rios os integrantes do povo tradicional da \\\\u00e1rea, os pescadores. Permitir desvios desse prop\\\\u00f3sito compromete os objetivos do Sistema Nacional de Unidades de Conserva\\\\u00e7\\\\u00e3o e prejudica a subsist\\\\u00eancia das comunidades que a reserva deveria proteger\\\\u201d, afirmou Mitidieri.\\\\\\\"}},{\\\\\\\"id\\\\\\\":\\\\\\\"k102uYNYiB\\\\\\\",\\\\\\\"type\\\\\\\":\\\\\\\"paragraph\\\\\\\",\\\\\\\"data\\\\\\\":{\\\\\\\"text\\\\\\\":\\\\\\\"Apesar da revoga\\\\u00e7\\\\u00e3o da licen\\\\u00e7a pelo ICMBio, o presidente do FIPAC obteve liminar judicial em primeira inst\\\\u00e2ncia que suspendeu o ato administrativo e manteve v\\\\u00e1lida sua autoriza\\\\u00e7\\\\u00e3o para o turismo n\\\\u00e1utico na RESEXMar at\\\\u00e9 decis\\\\u00e3o definitiva.\\\\\\\"}},{\\\\\\\"id\\\\\\\":\\\\\\\"54e-9ZCuHq\\\\\\\",\\\\\\\"type\\\\\\\":\\\\\\\"paragraph\\\\\\\",\\\\\\\"data\\\\\\\":{\\\\\\\"text\\\\\\\":\\\\\\\"O MPF argumenta que tal decis\\\\u00e3o liminar pode perpetuar o desvirtuamento da unidade de conserva\\\\u00e7\\\\u00e3o, j\\\\u00e1 afetada por problemas hist\\\\u00f3ricos como a superlota\\\\u00e7\\\\u00e3o de embarca\\\\u00e7\\\\u00f5es, o arrendamento irregular de licen\\\\u00e7as e a exclus\\\\u00e3o de pescadores tradicionais do processo de concess\\\\u00e3o.\\\\\\\"}},{\\\\\\\"id\\\\\\\":\\\\\\\"SO_oUpYQiN\\\\\\\",\\\\\\\"type\\\\\\\":\\\\\\\"paragraph\\\\\\\",\\\\\\\"data\\\\\\\":{\\\\\\\"text\\\\\\\":\\\\\\\"O caso segue aguardando an\\\\u00e1lise do TRF2.\\\\\\\"}},{\\\\\\\"id\\\\\\\":\\\\\\\"ZlqDQC8Zxe\\\\\\\",\\\\\\\"type\\\\\\\":\\\\\\\"paragraph\\\\\\\",\\\\\\\"data\\\\\\\":{\\\\\\\"text\\\\\\\":\\\\\\\"A decis\\\\u00e3o poder\\\\u00e1 impactar a gest\\\\u00e3o futura da RESEXMar e os crit\\\\u00e9rios para concess\\\\u00e3o de autoriza\\\\u00e7\\\\u00f5es, refor\\\\u00e7ando o compromisso com a prote\\\\u00e7\\\\u00e3o das comunidades tradicionais e o equil\\\\u00edbrio das atividades econ\\\\u00f4micas na unidade de conserva\\\\u00e7\\\\u00e3o.\\\\\\\"}}],\\\\\\\"version\\\\\\\":\\\\\\\"2.30.7\\\\\\\"}\\\"\"','https://s2-g1.glbimg.com/bLBnLL2B5ui96uN-czv7d_2A0DA=/0x0:960x540/984x0/smart/filters:strip_icc()/i.s3.glbimg.com/v1/AUTH_59edd422c0c84a879bd37670ae4f538a/internal_photos/bs/2019/Z/R/AlFYLeSzW0zqTWh6AGdQ/nota1.4.jpg','2024-12-27 00:00:00','2025-01-22 16:24:46','MPF recorre contra licença de turismo náutico para políticos em Arraial do Cabo',NULL,NULL),(11,'De camarão a tainha: as espécies encontradas na maior laguna hipersalina do mundo','\"\\\"{\\\\\\\"time\\\\\\\":1737563152585,\\\\\\\"blocks\\\\\\\":[{\\\\\\\"id\\\\\\\":\\\\\\\"UauHx5Obwe\\\\\\\",\\\\\\\"type\\\\\\\":\\\\\\\"header\\\\\\\",\\\\\\\"data\\\\\\\":{\\\\\\\"text\\\\\\\":\\\\\\\"De camar\\\\u00e3o a tainha: as esp\\\\u00e9cies encontradas na maior laguna hipersalina do mundo\\\\\\\",\\\\\\\"level\\\\\\\":2}}],\\\\\\\"version\\\\\\\":\\\\\\\"2.30.7\\\\\\\"}\\\"\"','https://s2-g1.glbimg.com/tqAk-OzVxNsrhJfpgTfwfyrqoBU=/0x1800:2268x3205/984x0/smart/filters:strip_icc()/i.s3.glbimg.com/v1/AUTH_59edd422c0c84a879bd37670ae4f538a/internal_photos/bs/2024/P/x/rEkSYGQWO0cfwAzRgeWw/lagoa.jpeg','2024-11-30 00:00:00','2025-01-22 16:25:52','De camarão a tainha: as espécies encontradas na maior laguna hipersalina do mundo',NULL,NULL),(12,'Elefantes-marinhos aparecem em rio de Casimiro de Abreu e em praia de Búzios, no RJ','\"\\\"{\\\\\\\"time\\\\\\\":1737563228440,\\\\\\\"blocks\\\\\\\":[{\\\\\\\"id\\\\\\\":\\\\\\\"4kNXaGk1fQ\\\\\\\",\\\\\\\"type\\\\\\\":\\\\\\\"paragraph\\\\\\\",\\\\\\\"data\\\\\\\":{\\\\\\\"text\\\\\\\":\\\\\\\"Elefantes-marinhos aparecem em rio de Casimiro de Abreu e em praia de B\\\\u00fazios, no RJ\\\\\\\"}}],\\\\\\\"version\\\\\\\":\\\\\\\"2.30.7\\\\\\\"}\\\"\"','https://s2-g1.glbimg.com/DpPi0AARwK-F_ylbgDzn6YMEc6E=/0x0:1030x600/984x0/smart/filters:strip_icc()/i.s3.glbimg.com/v1/AUTH_59edd422c0c84a879bd37670ae4f538a/internal_photos/bs/2024/L/M/LegJiqTOOTLuSXlKQAxQ/1729533631963391.jpg','2024-12-18 00:00:00','2025-01-22 16:27:08','Elefantes-marinhos aparecem em rio de Casimiro de Abreu e em praia de Búzios, no RJ',NULL,NULL),(13,'Para realizar sonho de conhecer praia do RJ, ciclista mineiro pedala 700 km','\"{\\\"time\\\":1738764935091,\\\"blocks\\\":[{\\\"id\\\":\\\"RSPtXRw7Tg\\\",\\\"type\\\":\\\"header\\\",\\\"data\\\":{\\\"text\\\":\\\"Para realizar sonho de conhecer praia do RJ, ciclista mineiro pedala 700&nbsp;km\\\",\\\"level\\\":2}}],\\\"version\\\":\\\"2.30.7\\\"}\"','https://s2-g1.glbimg.com/tKq9pa8NojZccSAM7NYBBOovt2A=/0x0:811x657/1008x0/smart/filters:strip_icc()/i.s3.glbimg.com/v1/AUTH_59edd422c0c84a879bd37670ae4f538a/internal_photos/bs/2025/5/8/6AmY7gThqhJfoU2sm3AQ/capturar.jpg','2025-01-22 00:00:00','2025-02-05 14:15:35','Para realizar sonho de conhecer praia do RJ, ciclista mineiro pedala 700 km',NULL,NULL),(14,'Família confirma que corpo encontrado por pescadores é de turista mineiro que desapareceu em Arraial do Cabo','\"{\\\"time\\\":1737656441609,\\\"blocks\\\":[{\\\"id\\\":\\\"cv5T98PbP3\\\",\\\"type\\\":\\\"paragraph\\\",\\\"data\\\":{\\\"text\\\":\\\"Familiares confirmaram que&nbsp;<a href=\\\\\\\"https:\\/\\/g1.globo.com\\/rj\\/regiao-dos-lagos\\/noticia\\/2025\\/01\\/06\\/pescadores-encontram-corpo-no-mar-em-meio-a-buscas-dos-bombeiros-por-turista-que-desapareceu-em-arraial-do-cabo.ghtml\\\\\\\">o corpo encontrado por pescadores no começo da tarde desta segunda-feira (6)<\\/a>, entre&nbsp;<a href=\\\\\\\"https:\\/\\/g1.globo.com\\/rj\\/regiao-dos-lagos\\/cidade\\/arraial-do-cabo\\/\\\\\\\">Arraial do Cabo<\\/a>&nbsp;e&nbsp;<a href=\\\\\\\"https:\\/\\/g1.globo.com\\/rj\\/regiao-dos-lagos\\/cidade\\/cabo-frio\\/\\\\\\\">Cabo Frio<\\/a>, na Região dos Lagos do Rio, é do turista mineiro Marcelo da Mota Batalha, de 44 anos.\\\"}},{\\\"id\\\":\\\"CCIFEzsxhA\\\",\\\"type\\\":\\\"paragraph\\\",\\\"data\\\":{\\\"text\\\":\\\"Ele estava&nbsp;<a href=\\\\\\\"https:\\/\\/g1.globo.com\\/rj\\/regiao-dos-lagos\\/noticia\\/2025\\/01\\/05\\/bombeiros-fazem-buscas-por-turista-que-desapareceu-em-arraial-do-cabo.ghtml\\\\\\\">sendo procurado desde a última quinta-feira (2)<\\/a>, quando desapareceu enquanto nadava na Prainha, em Arraial do Cabo. O corpo foi visto próximo à Ilha do Papagaio. Os bombeiros foram acionados e a família fez o reconhecimento.\\\"}},{\\\"id\\\":\\\"NMuWB1fLUx\\\",\\\"type\\\":\\\"paragraph\\\",\\\"data\\\":{\\\"text\\\":\\\"O corpo foi encaminhado para o Instituto Médico Legal de Cabo Frio.\\\"}},{\\\"id\\\":\\\"zAdhYl7TAN\\\",\\\"type\\\":\\\"paragraph\\\",\\\"data\\\":{\\\"text\\\":\\\"Marcelo era natural de Ubá, em Minas Gerais, e estava de férias em Arraial do Cabo. Ele estava com o irmão quando saiu para nadar, mas não voltou.\\\"}},{\\\"id\\\":\\\"LnCEUaE7vo\\\",\\\"type\\\":\\\"paragraph\\\",\\\"data\\\":{\\\"text\\\":\\\"“Nós procuramos por ele até por volta de dez horas da noite. No outro dia, eu retornei e não consegui achá-lo”, disse o irmão, Elisson da Mota, na ocasião.\\\"}},{\\\"id\\\":\\\"h23l-g2zQM\\\",\\\"type\\\":\\\"paragraph\\\",\\\"data\\\":{\\\"text\\\":\\\"As buscas pelo turista contaram com militares do Corpo de Bombeiros de Cabo Frio e Macaé. A operação recebeu ainda o apoio de mergulhadores da Barra da Tijuca, na Zona Oeste do Rio de Janeiro.\\\"}}],\\\"version\\\":\\\"2.30.7\\\"}\"','https://s2-g1.glbimg.com/2ggCbLlbbzF4quWeahZeUZczqmw=/0x0:979x893/984x0/smart/filters:strip_icc()/i.s3.glbimg.com/v1/AUTH_59edd422c0c84a879bd37670ae4f538a/internal_photos/bs/2025/H/j/h2BC0xQZ6AV4m2WNIhbg/o-mineiro-marcelo-da-mota-batalha-de-44-anos-desapareceu-quando-nadava-na-regiao-da-prainha-em-arraial-do-cabo.png','2025-01-23 00:00:00','2025-01-23 18:20:41','Família confirma que corpo encontrado por pescadores é de turista mineiro que desapareceu em Arraial do Cabo',NULL,NULL),(15,'Consórcio Intermunicipal Lagos São João elege Fabinho do Cidadania, prefeito de Iguaba Grande, como presidente','\"{\\\"time\\\":1738083968465,\\\"blocks\\\":[{\\\"id\\\":\\\"GFtXHDHIFv\\\",\\\"type\\\":\\\"paragraph\\\",\\\"data\\\":{\\\"text\\\":\\\"O Consórcio Municipal Lagos São João tem um novo presidente eleito. Fabinho do Cidadania, prefeito de&nbsp;<a href=\\\\\\\"https:\\/\\/g1.globo.com\\/rj\\/regiao-dos-lagos\\/cidade\\/iguaba-grande\\/\\\\\\\">Iguaba Grande<\\/a>, na Região dos Lagos, foi eleito na manhã desta sexta-feira (24) durante reunião anual do consórcio em um clube do município.\\\"}},{\\\"id\\\":\\\"wMYgBiQRDh\\\",\\\"type\\\":\\\"paragraph\\\",\\\"data\\\":{\\\"text\\\":\\\"Estiveram presentes representantes de órgãos do governo e prefeituras, empresas, organizações não governamentais e moradores da Região.\\\"}},{\\\"id\\\":\\\"RqdVB4uwY8\\\",\\\"type\\\":\\\"paragraph\\\",\\\"data\\\":{\\\"text\\\":\\\"O evento teve como objetivo debater sobre os projetos do consórcio e eleger o novo presidente.\\\"}},{\\\"id\\\":\\\"WxOy7hNwgT\\\",\\\"type\\\":\\\"paragraph\\\",\\\"data\\\":{\\\"text\\\":\\\"O Consórcio Intermunicipal Lagos São João atua há 25 anos, com o objetivo de unir governos, entidades da sociedade civil e empresas para fortalecer a gestão compartilhada do meio ambiente.\\\"}},{\\\"id\\\":\\\"zUuR7MPd9B\\\",\\\"type\\\":\\\"paragraph\\\",\\\"data\\\":{\\\"text\\\":\\\"No momento, é composto por 13 municípios em todo o estado:&nbsp;<a href=\\\\\\\"https:\\/\\/g1.globo.com\\/rj\\/regiao-dos-lagos\\/cidade\\/araruama\\/\\\\\\\">Araruama<\\/a>,&nbsp;<a href=\\\\\\\"https:\\/\\/g1.globo.com\\/rj\\/regiao-dos-lagos\\/cidade\\/armacao-de-buzios\\/\\\\\\\">Armação dos Búzios<\\/a>,&nbsp;<a href=\\\\\\\"https:\\/\\/g1.globo.com\\/rj\\/regiao-dos-lagos\\/cidade\\/arraial-do-cabo\\/\\\\\\\">Arraial do Cabo<\\/a>,&nbsp;<a href=\\\\\\\"https:\\/\\/g1.globo.com\\/rj\\/regiao-dos-lagos\\/cidade\\/cabo-frio\\/\\\\\\\">Cabo Frio<\\/a>,&nbsp;<a href=\\\\\\\"https:\\/\\/g1.globo.com\\/rj\\/regiao-serrana\\/cidade\\/cachoeiras-de-macacu\\/\\\\\\\">Cachoeiras de Macacu<\\/a>,&nbsp;<a href=\\\\\\\"https:\\/\\/g1.globo.com\\/rj\\/regiao-dos-lagos\\/cidade\\/casimiro-de-abreu\\/\\\\\\\">Casimiro de Abreu<\\/a>, Iguaba Grande,&nbsp;<a href=\\\\\\\"https:\\/\\/g1.globo.com\\/rj\\/regiao-dos-lagos\\/cidade\\/marica\\/\\\\\\\">Maricá<\\/a>,&nbsp;<a href=\\\\\\\"https:\\/\\/g1.globo.com\\/rj\\/regiao-dos-lagos\\/cidade\\/rio-bonito\\/\\\\\\\">Rio Bonito<\\/a>,&nbsp;<a href=\\\\\\\"https:\\/\\/g1.globo.com\\/rj\\/regiao-dos-lagos\\/cidade\\/rio-das-ostras\\/\\\\\\\">Rio das Ostras<\\/a>,&nbsp;<a href=\\\\\\\"https:\\/\\/g1.globo.com\\/rj\\/regiao-dos-lagos\\/cidade\\/sao-pedro-da-aldeia\\/\\\\\\\">São Pedro da Aldeia<\\/a>,&nbsp;<a href=\\\\\\\"https:\\/\\/g1.globo.com\\/rj\\/regiao-dos-lagos\\/cidade\\/saquarema\\/\\\\\\\">Saquarema<\\/a>&nbsp;e&nbsp;<a href=\\\\\\\"https:\\/\\/g1.globo.com\\/rj\\/regiao-dos-lagos\\/cidade\\/silva-jardim\\/\\\\\\\">Silva Jardim<\\/a>.\\\"}},{\\\"id\\\":\\\"zc-QX986fQ\\\",\\\"type\\\":\\\"paragraph\\\",\\\"data\\\":{\\\"text\\\":\\\"A entidade atua em ações como o apoio técnico às prefeituras, implementação de políticas públicas de recursos hídricos, articulação para o desassoreamento de canais e lagoas costeiras, apoio aos Planos Municipais de Saneamento Básico, conservação e Recuperação da Mata Atlântica, monitoramento da qualidade da água e entre outros.\\\"}},{\\\"id\\\":\\\"9vfNNdRtYy\\\",\\\"type\\\":\\\"paragraph\\\",\\\"data\\\":{\\\"text\\\":\\\"Uma das principais missões é a recuperação e manutenção da Lagoa de Araruama, que também faz parte do Sistema Estadual de Gestão dos Recursos Hídricos, através das bacias hidrográficas em sua área de atuação.\\\"}}],\\\"version\\\":\\\"2.30.7\\\"}\"','https://s2-g1.glbimg.com/NQp6crGAstuD2MpLD0WFRBnMApA=/0x0:540x300/984x0/smart/filters:strip_icc()/i.s3.glbimg.com/v1/AUTH_59edd422c0c84a879bd37670ae4f538a/internal_photos/bs/2025/F/n/BB0AQrT82YwBQyPQXqog/0beb134d-c0ed-4255-9107-d531f084da82.jpg','2025-01-24 00:00:00','2025-01-28 17:06:08','Reunião anual do consórcio ocorreu na manhã desta sexta-feira (24) em um clube de Iguaba Grande.',NULL,NULL);

--
-- Table structure for table `records`
--

CREATE TABLE `records` (
  `id` int NOT NULL AUTO_INCREMENT,
  `user_id` int NOT NULL,
  `protocol` bigint NOT NULL,
  `text` text NOT NULL,
  `employees` varchar(255) DEFAULT NULL,
  `complaint` tinyint(1) NOT NULL,
  `type` varchar(255) NOT NULL,
  `local` varchar(255) NOT NULL,
  `date` varchar(30) NOT NULL,
  `status` int NOT NULL DEFAULT '2',
  `nota` int NOT NULL,
  `dialog_status` int NOT NULL DEFAULT '0',
  `prazo` varchar(30) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=109 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `records`
--

INSERT INTO `records` VALUES (98,2,99006361726,'sadsdvsdv','',1,'Abastecimento','Prefeitura','2025-02-17',2,0,0,'2025-03-09'),(99,2,60028302586,'wgwgweg','',1,'Abono salarial','Saúde','2025-02-18',2,0,0,'2025-03-10'),(100,2,57217415758,'Teste','',1,'Água','Educação','2025-02-18',2,0,0,'2025-03-10'),(101,2,39232290751,'Teste','',1,'Água','Educação','2025-02-18',2,0,0,'2025-03-10'),(102,2,79643602737,'dasdsadasdsaasd','',1,'Agendamento de Consultas','Saúde','2025-02-21',2,0,0,NULL),(103,2,32192335726,'dasdsadasdsaasd','',1,'Agendamento de Consultas','Saúde','2025-02-21',2,0,0,NULL),(104,2,58318372337,'eeeeeeee','',1,'Agendamento','Eventos','2025-02-24',2,0,0,'2025-03-16'),(105,2,40449840760,'hfgjytjtgyjtygjy','',1,'Alimentação Animal','Educação','2025-02-25',2,0,0,NULL),(106,2,53415196055,'Mensagem de Teste','',1,'Acesso à informação','Prefeitura','2025-02-26',2,0,0,'2025-03-18'),(107,2,25580465908,'asdasda','',1,'afa','Eventos','2025-02-26',2,0,0,'2025-03-18'),(108,2,80207156146,'oi','',3,'Agricultura Familiar','Prefeitura','2025-02-27',2,0,0,'2025-03-19');

--
-- Table structure for table `records_files`
--

CREATE TABLE `records_files` (
  `id` int NOT NULL AUTO_INCREMENT,
  `user_id` int NOT NULL,
  `protocol` bigint NOT NULL,
  `path` text NOT NULL,
  `origin` varchar(255) NOT NULL,
  `date` varchar(30) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `records_files`
--


--
-- Table structure for table `secretarias_autarquias`
--

CREATE TABLE `secretarias_autarquias` (
  `idsecretarias_autarquias` int NOT NULL AUTO_INCREMENT,
  `nome` varchar(150) DEFAULT NULL,
  `local` varchar(255) DEFAULT NULL,
  `numero` varchar(45) DEFAULT NULL,
  `email` varchar(100) DEFAULT NULL,
  `horario_start` time DEFAULT NULL,
  `horario_end` time DEFAULT NULL,
  `secretario` varchar(150) DEFAULT NULL,
  `logo` varchar(45) DEFAULT NULL,
  `dia_funcionamento` varchar(45) DEFAULT NULL,
  `descricao` varchar(255) DEFAULT NULL,
  `zap` varchar(45) DEFAULT NULL,
  `tags` varchar(455) DEFAULT NULL,
  PRIMARY KEY (`idsecretarias_autarquias`),
  UNIQUE KEY `nome_UNIQUE` (`nome`),
  KEY `secretrio` (`secretario`),
  CONSTRAINT `secretrio` FOREIGN KEY (`secretario`) REFERENCES `secretario_presidente` (`nome`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `secretarias_autarquias`
--

INSERT INTO `secretarias_autarquias` VALUES (7,'Secretaria de Educação, Cultura, Ciência, Tecnologia, Esporte e Lazer','Rua Projetada e, 41, Prainha, Arrraial do cabo','(02)23442-0152','cienciaetecnologia@edu.arraial.rj.gov.br','08:00:00','17:00:00','Bernado Martins de Alcântara Veiga da Silva','/storage/img/logos/secretarias/semecct.png','Seg á Sex','Secretaria responsalvel pelo setor tecnologico da educação da prefeitura municipal de arraial do cabo.','','Educação, Cultura, Ciência, Tecnologia, Esporte, Lazer'),(10,'Secretaria de Teste','Outro endereço','(33)33333-3333','danielferrangel.98@gmail.com','04:00:00','08:00:00','fulanaça','/storage/img/logos/secretarias/mulher.jfif','sdas','sadasd','(32) 22222-2222','Educação, Cultura, Ciência, Tecnologia, Esporte, Lazer');

--
-- Table structure for table `secretario_presidente`
--

CREATE TABLE `secretario_presidente` (
  `idsecretario` int NOT NULL AUTO_INCREMENT,
  `nome` varchar(150) DEFAULT NULL,
  `numero` varchar(45) DEFAULT NULL,
  `email` varchar(45) DEFAULT NULL,
  `foto` varchar(500) DEFAULT NULL,
  PRIMARY KEY (`idsecretario`),
  UNIQUE KEY `nome_UNIQUE` (`nome`)
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `secretario_presidente`
--

INSERT INTO `secretario_presidente` VALUES (17,'Bernado Martins de Alcântara Veiga da Silva',NULL,NULL,'/storage/img/secretarios/secretariao bernado.jpg'),(24,'fulanaça',NULL,NULL,'/storage/img/secretarios/mulher.jfif');

--
-- Table structure for table `servicos_departamentos`
--

CREATE TABLE `servicos_departamentos` (
  `id` int NOT NULL AUTO_INCREMENT,
  `id_entidade` int DEFAULT NULL,
  `nome` varchar(150) DEFAULT NULL,
  `link` text,
  `icon` varchar(255) DEFAULT NULL,
  `digital` tinyint(1) DEFAULT (0),
  `contato` text,
  `responsavel` varchar(255) DEFAULT NULL,
  `setor` varchar(255) NOT NULL,
  `logradouro` varchar(255) DEFAULT NULL,
  `bairro` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `idsecretaria_idx` (`id_entidade`),
  KEY `nome_secretaria_idx` (`setor`),
  CONSTRAINT `idsecretaria` FOREIGN KEY (`id_entidade`) REFERENCES `secretarias_autarquias` (`idsecretarias_autarquias`),
  CONSTRAINT `nome_secretaria` FOREIGN KEY (`setor`) REFERENCES `secretarias_autarquias` (`nome`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `servicos_departamentos`
--

INSERT INTO `servicos_departamentos` VALUES (1,NULL,'Aula de Capeira','magnet:?xt=urn:btih:FA3A7D8D36DA3546330D2AFC1564C1C6775F8774&tr=http%3A%2F%2Fbt2.t-ru.org%2Fann%3Fmagnet&dn=Mount%20and%20Blade%20II%20(2)%3A%20Bannerlord%20%5BL%5D%20%5BRUS%20%2B%20ENG%20%2B%2010%20%2F%20ENG%5D%20(2022)%20(1.2.9.34019%20%2B%201%20DLC)%20%5BGOG%5D','<i class=\"fa-regular fa-clipboard fa-2xl\"></i>',0,'(65) 16510-6844','Caiao','Secretaria de Educação, Cultura, Ciência, Tecnologia, Esporte e Lazer','rua dos feio','praia do fonseca'),(3,NULL,'Calendário Escolar','https://transparencia.arraial.modernizacao.com.br/webrun/form.jsp?sys=LAI&action=openform&formID=500000678','<i class=\"fa-solid fa-calendar-days fa-2xl\"></i>',1,'(02) 23442-0152','Secretaria','Secretaria de Educação, Cultura, Ciência, Tecnologia, Esporte e Lazer','Praça do Sindicato','Centro'),(4,NULL,'Cardápio das Escolas','https://transparencia.arraial.modernizacao.com.br/webrun/form.jsp?sys=LAI&action=openform&formID=500000679','<i class=\"fa-solid fa-utensils fa-2xl\"></i>',1,'(02) 23442-0152','Secretaria','Secretaria de Educação, Cultura, Ciência, Tecnologia, Esporte e Lazer','Praça do Sindicato','Centro');

--
-- Table structure for table `servicos_prefeitura`
--

CREATE TABLE `servicos_prefeitura` (
  `id` int NOT NULL AUTO_INCREMENT,
  `nome` varchar(255) NOT NULL,
  `link` text NOT NULL,
  `icon` varchar(255) NOT NULL,
  `digital` tinyint(1) DEFAULT (0),
  `contato` text NOT NULL,
  `responsavel` varchar(255) NOT NULL,
  `setor` varchar(255) NOT NULL,
  `logradouro` varchar(255) NOT NULL,
  `bairro` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `servicos_prefeitura`
--



--
-- Host: localhost    Database: diario
-- ------------------------------------------------------


--
-- Table structure for table `assinaturas`
--

CREATE TABLE `assinaturas` (
  `id` int NOT NULL AUTO_INCREMENT,
  `responsavel` varchar(45) DEFAULT NULL,
  `subsecao` int DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id_UNIQUE` (`id`),
  KEY `subsecao_idx` (`subsecao`),
  CONSTRAINT `subsecao` FOREIGN KEY (`subsecao`) REFERENCES `subsecoes` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `assinaturas`
--


--
-- Table structure for table `comap`
--

CREATE TABLE `comap` (
  `idcomap` int NOT NULL AUTO_INCREMENT,
  `L/C` int DEFAULT NULL,
  `portaria` int DEFAULT NULL,
  PRIMARY KEY (`idcomap`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `comap`
--


--
-- Table structure for table `diarios`
--

CREATE TABLE `diarios` (
  `id` int NOT NULL AUTO_INCREMENT,
  `edicao` int NOT NULL,
  `data` date DEFAULT NULL,
  `pathdocumento` varchar(255) DEFAULT NULL,
  `publicado` tinyint DEFAULT NULL,
  `horaPublicacao` time DEFAULT NULL,
  `extra` tinyint DEFAULT NULL,
  `visitas` int DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id_UNIQUE` (`id`),
  UNIQUE KEY `edicao_UNIQUE` (`edicao` DESC),
  UNIQUE KEY `pathdocumento_UNIQUE` (`pathdocumento`)
) ENGINE=InnoDB AUTO_INCREMENT=50 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `diarios`
--

INSERT INTO `diarios` VALUES (1,0,NULL,NULL,NULL,NULL,NULL,NULL),(40,1,'2025-02-27',NULL,1,'10:36:33',0,NULL);

--
-- Table structure for table `executivo`
--

CREATE TABLE `executivo` (
  `idexecutivo` int NOT NULL AUTO_INCREMENT,
  `L/C` int DEFAULT NULL,
  `leis` int DEFAULT NULL,
  `decretos` int DEFAULT NULL,
  `portaria` int DEFAULT NULL,
  `atos` int DEFAULT NULL,
  `diverosos` int DEFAULT NULL,
  `resolucoes` int DEFAULT NULL,
  `oficios` int DEFAULT NULL,
  `extratos` int DEFAULT NULL,
  `concursos` int DEFAULT NULL,
  PRIMARY KEY (`idexecutivo`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `executivo`
--


--
-- Table structure for table `fipac`
--

CREATE TABLE `fipac` (
  `idfipac` int NOT NULL AUTO_INCREMENT,
  `L/C` int DEFAULT NULL,
  `resolucoes` int DEFAULT NULL,
  `extratos` int DEFAULT NULL,
  `processoadm` int DEFAULT NULL,
  PRIMARY KEY (`idfipac`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `fipac`
--


--
-- Table structure for table `idac`
--

CREATE TABLE `idac` (
  `L/C` int DEFAULT NULL,
  `portaria` int DEFAULT NULL,
  `atos` int DEFAULT NULL,
  `extratos` int DEFAULT NULL,
  `ididac` int NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`ididac`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `idac`
--


--
-- Table structure for table `ipc`
--

CREATE TABLE `ipc` (
  `idipc` int NOT NULL AUTO_INCREMENT,
  `portaria` int DEFAULT NULL,
  `diverosos` int DEFAULT NULL,
  PRIMARY KEY (`idipc`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `ipc`
--


--
-- Table structure for table `secoes`
--

CREATE TABLE `secoes` (
  `id` int NOT NULL AUTO_INCREMENT,
  `tipo` varchar(155) NOT NULL,
  `diario` int DEFAULT NULL,
  `data` date DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id_UNIQUE` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=70 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `secoes`
--

INSERT INTO `secoes` VALUES (49,'COMAP',40,'2025-02-27'),(69,'IDAC',40,'2025-02-27');

--
-- Table structure for table `setores`
--

CREATE TABLE `setores` (
  `idsetores` int NOT NULL AUTO_INCREMENT,
  `idcomap` int DEFAULT NULL,
  `idexecultivo` int DEFAULT NULL,
  `idfipac` int DEFAULT NULL,
  `ididac` int DEFAULT NULL,
  `idipc` int DEFAULT NULL,
  PRIMARY KEY (`idsetores`),
  KEY `idexecultivo_idx` (`idexecultivo`),
  KEY `idcomap_idx` (`idcomap`),
  KEY `idfipac_idx` (`idfipac`),
  KEY `ididac_idx` (`ididac`),
  KEY `idipc_idx` (`idipc`),
  CONSTRAINT `idcomap` FOREIGN KEY (`idcomap`) REFERENCES `comap` (`idcomap`),
  CONSTRAINT `idexecultivo` FOREIGN KEY (`idexecultivo`) REFERENCES `executivo` (`idexecutivo`),
  CONSTRAINT `idfipac` FOREIGN KEY (`idfipac`) REFERENCES `fipac` (`idfipac`),
  CONSTRAINT `ididac` FOREIGN KEY (`ididac`) REFERENCES `idac` (`ididac`),
  CONSTRAINT `idipc` FOREIGN KEY (`idipc`) REFERENCES `ipc` (`idipc`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `setores`
--


--
-- Table structure for table `subsecoes`
--

CREATE TABLE `subsecoes` (
  `id` int NOT NULL AUTO_INCREMENT,
  `titulo` text NOT NULL,
  `descricao` longtext,
  `data` date DEFAULT NULL,
  `status` varchar(45) DEFAULT NULL,
  `setor` varchar(45) NOT NULL,
  `tiposubsecao` varchar(45) DEFAULT NULL,
  `numeroPLE` int DEFAULT NULL,
  `conteudo` json DEFAULT NULL,
  `secao` int DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id_UNIQUE` (`id`),
  KEY `numeroPLE` (`numeroPLE`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=104 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `subsecoes`
--

INSERT INTO `subsecoes` VALUES (83,'teste','ehetheheth','2025-02-27','Finalizado','COMAP','Licitações e contratos',0,'{\"time\": \"1740747525803\", \"blocks\": [{\"id\": \"rT_sAkKPtn\", \"data\": {\"text\": \"conteudo\"}, \"type\": \"paragraph\"}], \"version\": \"2.31.0-rc.7\"}',49),(102,'portaria','descricao','2025-02-27','Finalizado','IDAC','Portarias',1,NULL,69),(103,'teste',NULL,'2025-02-27','Criado','IDAC','Licitações e contratos',0,NULL,NULL);


