-- phpMyAdmin SQL Dump -- version 5.2.1 -- https://www.phpmyadmin.net/ -- -- Host: localhost:3306 -- Tempo de geração: 06/11/2023 às 08:51 -- Versão do servidor: 5.7.44 -- Versão do PHP: 8.1.16 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; START TRANSACTION; SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8mb4 */; -- -- Banco de dados: `papelzer_comar` -- -- -------------------------------------------------------- -- -- Estrutura para tabela `documentos` -- CREATE TABLE `documentos` ( `id` int(10) UNSIGNED NOT NULL, `url` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `local` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `processo_id` int(10) UNSIGNED NOT NULL DEFAULT '0', `dados_id` int(10) UNSIGNED NOT NULL DEFAULT '0', `tipo_id` int(11) NOT NULL DEFAULT '0', `account_id` int(10) UNSIGNED NOT NULL, `token` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `nome` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `tipo_documento` int(10) NOT NULL DEFAULT '0' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Despejando dados para a tabela `documentos` -- INSERT INTO `documentos` (`id`, `url`, `local`, `processo_id`, `dados_id`, `tipo_id`, `account_id`, `token`, `nome`, `created_at`, `updated_at`, `tipo_documento`) VALUES (3175, 'upload/papelzero/codanorte/fce/arquivos/169166876916007.pdf', '', 2, 212, 10000, 4, 'XXXXXXXXXX', '', '2023-06-22 13:18:16', '2023-08-10 11:59:29', 1), (3327, 'upload/papelzero/codanorte/fce/arquivos/11581326001688128475.pdf', '', 2, 212, 9994, 4, 'XXXXXXXXXX', '', '2023-06-30 03:00:00', '2023-06-30 12:34:35', 0), (3328, 'portais/sacramento/fce/certificado_XXXXXXXXXX.pdf', '', 2, 212, 10003, 4, 'XXXXXXXXXX', 'Certificado', '2023-06-30 12:34:35', '2023-06-30 12:34:35', 0), (3329, 'portais/sacramento/fce/certificado_11728_XXXXXXXXXX.pdf', '', 2, 212, 10003, 4, 'XXXXXXXXXX', 'Certificado', '2023-06-30 12:39:40', '2023-06-30 12:39:40', 0), (3348, 'portais/sacramento/fce/fob_XXXXXXXXXX.pdf', '', 3, 425, 10001, 4, 'XXXXXXXXXX', 'FOB', '2023-06-30 17:55:49', '2023-06-30 17:55:49', 0), (3349, 'portais/sacramento/fce/fob_XXXXXXXXXX.pdf', '', 3, 425, 10001, 4, 'XXXXXXXXXX', 'FOB', '2023-06-30 17:58:20', '2023-06-30 17:58:20', 0), (3406, 'upload/papelzero/codanorte/fce/arquivos/69331689267367.pdf', '', 2, 212, 10000, 4, 'XXXXXXXXXX', '', '2023-07-13 16:56:07', '2023-07-13 16:56:07', 0), (3407, 'portais/sacramento/fce/fob_XXXXXXXXXX.pdf', '', 2, 212, 10001, 4, 'XXXXXXXXXX', 'FOB', '2023-07-13 16:56:07', '2023-07-13 16:56:07', 0), (3408, 'portais/sacramento/fce/fob_XXXXXXXXXX.pdf', '', 2, 212, 10001, 4, 'XXXXXXXXXX', 'FOB', '2023-07-13 16:59:05', '2023-07-13 16:59:05', 0), (3409, 'upload/papelzero/codanorte/fce/arquivos/386811689268168.pdf', '', 3, 422, 10000, 4, 'XXXXXXXXXX', '', '2023-07-13 17:09:28', '2023-07-13 17:09:28', 0), (3410, 'portais/sacramento/fce/fob_XXXXXXXXXX.pdf', '', 3, 422, 10001, 4, 'XXXXXXXXXX', 'FOB', '2023-07-13 17:09:28', '2023-07-13 17:09:28', 0), (3411, 'upload/papelzero/codanorte/fce/arquivos/837081689268288.pdf', '', 3, 422, 10000, 4, 'XXXXXXXXXX', '', '2023-07-13 17:11:28', '2023-07-13 17:11:28', 0), (3412, 'portais/sacramento/fce/fob_XXXXXXXXXX.pdf', '', 3, 422, 10001, 4, 'XXXXXXXXXX', 'FOB', '2023-07-13 17:11:28', '2023-07-13 17:11:28', 0), (3413, 'upload/papelzero/codanorte/fce/arquivos/350131689268409.pdf', '', 3, 422, 10000, 4, 'XXXXXXXXXX', '', '2023-07-13 17:13:29', '2023-07-13 17:13:29', 0), (3414, 'portais/sacramento/fce/fob_XXXXXXXXXX.pdf', '', 3, 422, 10001, 4, 'XXXXXXXXXX', 'FOB', '2023-07-13 17:13:29', '2023-07-13 17:13:29', 0), (3416, 'upload/papelzero/codanorte/fce/arquivos/618101689269088.pdf', '', 3, 422, 10000, 4, 'XXXXXXXXXX', '', '2023-07-13 17:24:48', '2023-07-13 17:24:48', 0), (3417, 'portais/sacramento/fce/fob_XXXXXXXXXX.pdf', '', 3, 422, 10001, 4, 'XXXXXXXXXX', 'FOB', '2023-07-13 17:24:48', '2023-07-13 17:24:48', 0), (3489, 'upload/papelzero/codanorte/fce/arquivos/941021689774009.svg', '', 3, 422, 10117, 4, 'XXXXXXXXXX', '', '2023-07-19 13:40:09', '2023-07-19 13:40:09', 0), (3589, 'upload/papelzero/codanorte/fce/arquivos/19949598131690894402.pdf', '', 2, 212, 9996, 4, 'XXXXXXXXXX', '', '2023-08-01 12:53:22', '2023-08-01 12:53:22', 0), (3590, 'upload/papelzero/codanorte/fce/arquivos/847441690894495.pdf', '', 2, 212, 10000, 4, 'XXXXXXXXXX', '', '2023-08-01 12:54:55', '2023-08-01 12:54:55', 0), (3591, 'portais/sacramento/fce/fob_XXXXXXXXXX.pdf', '', 2, 212, 10001, 4, 'XXXXXXXXXX', 'FOB', '2023-08-01 12:54:55', '2023-08-01 12:54:55', 0), (3592, 'upload/papelzero/codanorte/fce/arquivos/16098454601690894525.pdf', '', 2, 212, 9995, 4, 'XXXXXXXXXX', '', '2023-08-01 03:00:00', '2023-08-01 12:55:25', 0), (3593, 'upload/papelzero/codanorte/fce/arquivos/15211159961690894546.pdf', '', 2, 212, 9997, 4, 'XXXXXXXXXX', '', '2023-08-01 12:55:46', '2023-08-01 12:55:46', 0), (3706, 'upload/papelzero/codanorte/fce/arquivos/683401691604036.pdf', '', 2, 236, 10000, 2, 'XXXXXXXXXX', '', '2023-08-09 18:00:36', '2023-08-09 18:00:36', 0), (3707, 'portais/licenciamento/fce/fob_XXXXXXXXXX.pdf', '', 2, 236, 10001, 2, 'XXXXXXXXXX', 'FOB', '2023-08-09 18:00:36', '2023-08-09 18:00:36', 0), (3708, 'upload/papelzero/codanorte/fce/arquivos/957261691604333.pdf', '', 2, 236, 10000, 2, 'XXXXXXXXXX', '', '2023-08-09 18:05:33', '2023-08-09 18:05:33', 0), (3709, 'portais/licenciamento/fce/fob_XXXXXXXXXX.pdf', '', 2, 236, 10001, 2, 'XXXXXXXXXX', 'FOB', '2023-08-09 18:05:33', '2023-08-09 18:05:33', 0), (3779, 'upload/papelzero/codanorte/fce/arquivos/18992988651692031776.pdf', '', 2, 212, 9995, 4, 'XXXXXXXXXX', '', '2023-08-14 03:00:00', '2023-08-14 16:49:36', 0), (3780, 'upload/papelzero/codanorte/fce/arquivos/5559163921692032708.pdf', '', 2, 212, 9997, 4, 'XXXXXXXXXX', '', '2023-08-14 17:05:08', '2023-08-14 17:05:08', 0), (3781, 'upload/papelzero/codanorte/fce/arquivos/17841823761692034219.pdf', '', 2, 212, 9996, 4, 'XXXXXXXXXX', '', '2023-08-14 17:30:19', '2023-08-14 17:30:19', 0), (4146, 'portais/sacramento/fce/certificado_16700_XXXXXXXXXX.pdf', '', 3, 563, 10003, 4, 'XXXXXXXXXX', 'Certificado', '2023-09-14 16:36:27', '2023-09-14 17:16:03', 0), (4184, 'upload/papelzero/codanorte/fce/arquivos/848831695060889.pdf', '', 2, 212, 10000, 4, 'XXXXXXXXXX', '', '2023-09-18 18:14:49', '2023-09-18 18:14:49', 0), (4185, 'portais/sacramento/fce/fob_XXXXXXXXXX.pdf', '', 2, 212, 10001, 4, 'XXXXXXXXXX', 'FOB', '2023-09-18 18:14:49', '2023-09-18 18:14:49', 0), (4294, 'upload/papelzero/codanorte/fce/arquivos/1927430151695905443.sql', '', 2, 212, 9995, 4, 'XXXXXXXXXX', '', '2023-10-04 03:00:00', '2023-09-28 12:50:43', 0), (4295, 'upload/papelzero/codanorte/fce/arquivos/6957839181695905484.sql', '', 2, 212, 9997, 4, 'XXXXXXXXXX', '', '2023-09-28 12:51:24', '2023-09-28 12:51:24', 0), (4296, 'upload/papelzero/codanorte/fce/arquivos/15361551611695905563.docx', '', 2, 212, 9996, 4, 'XXXXXXXXXX', '', '2023-09-28 12:52:43', '2023-09-28 12:52:43', 0), (4297, 'upload/papelzero/codanorte/fce/arquivos/678371695905888.docx', '', 2, 212, 10000, 4, 'XXXXXXXXXX', '', '2023-09-28 12:58:08', '2023-09-28 12:58:08', 0), (4298, 'portais/sacramento/fce/fob_XXXXXXXXXX.pdf', '', 2, 212, 10001, 4, 'XXXXXXXXXX', 'FOB', '2023-09-28 12:58:08', '2023-09-28 12:58:08', 0), (4299, 'upload/papelzero/codanorte/fce/arquivos/11058420011695905991.docx', '', 2, 212, 9995, 4, 'XXXXXXXXXX', '', '2023-10-03 03:00:00', '2023-09-28 12:59:51', 0), (4300, 'upload/papelzero/codanorte/fce/arquivos/18081222601695906160.sql', '', 2, 212, 9995, 4, 'XXXXXXXXXX', '', '2023-10-11 03:00:00', '2023-09-28 13:02:40', 0), (4301, 'upload/papelzero/codanorte/fce/arquivos/15883795581695906628.docx', '', 2, 212, 9995, 4, 'XXXXXXXXXX', '', '2023-10-11 03:00:00', '2023-09-28 13:10:28', 0), (4302, 'upload/papelzero/codanorte/fce/arquivos/4803144401695906701.docx', '', 2, 212, 9997, 4, 'XXXXXXXXXX', '', '2023-09-28 13:11:41', '2023-09-28 13:11:41', 0), (4303, 'upload/papelzero/codanorte/fce/arquivos/4671451181695906739.docx', '', 2, 212, 9996, 4, 'XXXXXXXXXX', '', '2023-09-28 13:12:19', '2023-09-28 13:12:19', 0), (4304, 'portais/sacramento/fce/fob_XXXXXXXXXX.pdf', '', 3, 563, 10001, 4, 'XXXXXXXXXX', 'FOB', '2023-09-28 13:42:07', '2023-09-28 13:42:07', 0); -- -- Índices para tabelas despejadas -- -- -- Índices de tabela `documentos` -- ALTER TABLE `documentos` ADD PRIMARY KEY (`id`); -- -- AUTO_INCREMENT para tabelas despejadas -- -- -- AUTO_INCREMENT de tabela `documentos` -- ALTER TABLE `documentos` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4680; COMMIT; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;