TransWar File Browser

Path: C:\

-- phpMyAdmin SQL Dump
-- version 5.2.0
-- https://www.phpmyadmin.net/
--
-- Host: localhost
-- Tempo de geração: 12-Dez-2024 às 04:11
-- Versão do servidor: 8.0.30
-- versão do PHP: 7.4.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: `autotrac`
--

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

--
-- Estrutura da tabela `autotrac_veiculo`
--

CREATE TABLE `autotrac_veiculo` (
  `veiculo` int NOT NULL,
  `nome` varchar(255) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
  `numero` int NOT NULL,
  `apelido` varchar(255) CHARACTER SET latin1 COLLATE latin1_general_ci DEFAULT NULL,
  `placa` varchar(20) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
  `autorizado_data` datetime DEFAULT NULL,
  `autorizado_por` varchar(255) CHARACTER SET latin1 COLLATE latin1_general_ci DEFAULT NULL,
  `removido_data` datetime DEFAULT NULL,
  `removido_por` varchar(255) CHARACTER SET latin1 COLLATE latin1_general_ci DEFAULT NULL,
  `status` int NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Extraindo dados da tabela `autotrac_veiculo`
--

INSERT INTO `autotrac_veiculo` (`veiculo`, `nome`, `numero`, `apelido`, `placa`, `autorizado_data`, `autorizado_por`, `removido_data`, `removido_por`, `status`) VALUES
(479558, 'FOH7859', 276364, '', 'FOH7859', '2024-10-21 12:43:21', 'Paulo Faria', NULL, '', 0),
(479878, 'KQY3J35', 276838, '', 'KQY3J35', '2024-10-21 12:43:06', 'Paulo Faria', NULL, '', 0),
(479891, 'AYS1932', 276845, '', 'AYS1932', '2024-10-24 21:10:34', 'Paulo Faria', '2024-10-24 14:18:58', 'Paulo Faria', 0),
(479950, 'FCM8E30', 276231, '', 'FCM8E30', '2024-10-21 12:43:34', 'Paulo Faria', NULL, '', 0),
(480169, 'DJC2604', 276366, '', 'DJC2604', '2024-10-21 12:27:38', 'Paulo Faria', NULL, '', 0),
(480215, 'CUB2500', 276728, '', 'CUB2500', '2024-10-21 12:25:55', 'Paulo Faria', NULL, '', 0),
(480269, 'DMI3335', 276352, '', 'DMI3335', '2024-10-21 12:45:18', 'Paulo Faria', NULL, '', 0),
(480401, 'DVT1H84', 276835, '', 'DVT1H84', '2024-10-21 12:41:58', 'Paulo Faria', NULL, '', 0),
(480409, 'CYN4057', 276365, '', 'CYN4057', '2024-10-21 16:47:31', 'Paulo Faria', NULL, '', 0),
(480448, 'CCU4F99', 276236, '', 'CCU4F99', '2024-10-21 12:22:25', 'Paulo Faria', NULL, '', 0),
(480472, 'FWL3887', 276234, '', 'FWL3887', '2024-10-21 16:47:34', 'Paulo Faria', NULL, '', 0),
(480481, 'DBB4604', 276854, '', 'DBB4604', '2024-10-21 16:47:34', 'Paulo Faria', NULL, '', 0),
(480483, 'FFW4790', 276759, '', 'FFW4790', '2024-10-21 16:47:36', 'Paulo Faria', NULL, '', 0),
(480810, 'EGK0846', 276847, '', 'EGK0846', '2024-10-21 16:47:33', 'Paulo Faria', NULL, '', 0),
(480818, 'FSH7J70', 276292, '', 'FSH7J70', '2024-10-21 16:47:36', 'Paulo Faria', NULL, '', 0),
(480852, 'DTD5483', 276858, '', 'DTD5483', '2024-10-21 16:47:40', 'Paulo Faria', NULL, '', 0),
(480872, 'DBB5418', 276229, '', 'DBB5418', '2024-10-21 16:47:39', 'Paulo Faria', NULL, '', 0),
(480910, 'CYN4060', 276336, '', 'CYN4060', '2024-10-16 01:53:24', 'Paulo Faria', NULL, '', 0),
(480949, 'CYN4058', 276795, '', 'CYN4058', '2024-10-21 16:47:32', 'Paulo Faria', NULL, '', 0),
(481307, 'QQB8A49', 276290, '', 'QQB8A49', '2024-10-21 12:54:12', 'Paulo Faria', NULL, '', 0),
(481359, 'DIV0213', 276844, '', 'DIV0213', '2024-10-21 16:47:34', 'Paulo Faria', NULL, '', 0),
(481423, 'CVP8571', 276286, '', 'CVP8571', '2024-10-21 16:47:32', 'Paulo Faria', NULL, '', 0),
(481466, 'BZB7166', 276401, '', 'BZB7166', '2024-10-21 16:47:32', 'Paulo Faria', NULL, '', 0),
(481506, 'FZN6A31', 276304, '', 'FZN6A31', '2024-10-21 16:47:34', 'Paulo Faria', NULL, '', 0),
(481530, 'CJH4D71', 276346, '', 'CJH4D71', '2024-10-21 16:47:32', 'Paulo Faria', NULL, '', 0),
(481581, 'GCB8048', 276768, '', 'GCB8048', '2024-10-21 16:47:42', 'Paulo Faria', NULL, '', 0),
(481763, 'JRG8614', 276293, '', 'JRG8614', '2024-10-23 22:33:00', 'Paulo Faria', NULL, '', 0),
(481785, 'GAH6G75', 276465, '', 'GAH6G75', '2024-10-23 22:32:52', 'Paulo Faria', NULL, '', 0),
(481828, 'DBB6361', 276736, '', 'DBB6361', '2024-10-23 22:32:51', 'Paulo Faria', NULL, '', 0),
(481829, 'CSK2G25', 276423, '', 'CSK2G25', '2024-10-23 22:32:49', 'Paulo Faria', NULL, '', 0),
(481853, 'LRG6H72', 276471, '', 'LRG6H72', '2024-10-28 19:39:27', 'Paulo Faria', NULL, '', 0),
(481867, 'DBB3150', 276792, '', 'DBB3150', '2024-10-28 19:39:14', 'Paulo Faria', NULL, '', 0),
(481893, 'FLM8C56', 276783, '', 'FLM8C56', '2024-10-28 19:39:15', 'Paulo Faria', NULL, '', 0),
(481979, 'CVN9310', 276427, '', 'CVN9310', '2024-10-28 19:39:14', 'Paulo Faria', NULL, '', 0),
(482019, 'OKQ6D96', 276855, '', 'OKQ6D96', '2024-10-31 10:34:30', 'Paulo Faria', NULL, '', 0),
(482025, 'FWP7H03', 276797, '', 'FWP7H03', '2024-10-31 10:34:27', 'Paulo Faria', NULL, '', 0),
(482045, 'EFV5B88', 276351, '', 'EFV5B88', '2024-10-31 10:34:19', 'Paulo Faria', NULL, '', 0),
(482066, 'JAV8G15', 276430, '', 'JAV8G15', '2024-10-31 10:34:29', 'Paulo Faria', NULL, '', 0),
(482109, 'GHX9D53', 276230, '', 'GHX9D53', '2024-11-03 15:41:39', 'Paulo Faria', '2024-11-03 15:39:40', 'Paulo Faria', 0),
(482136, 'ATP1C61', 276342, '', 'ATP1C61', '2024-11-02 10:06:50', 'Paulo Faria', NULL, '', 0),
(482166, 'JOT3J81', 276654, '', 'JOT3J81', '2024-11-02 10:06:59', 'Paulo Faria', NULL, '', 0),
(482242, 'NMH7E95', 276338, '', 'NMH7E95', '2024-11-14 03:07:38', 'Paulo Faria', NULL, '', 0),
(482263, 'CUB3249', 276376, '', 'CUB3249', '2024-11-14 03:07:47', 'Paulo Faria', NULL, '', 0),
(482314, 'FWK7987', 276386, '', 'FWK7987', '2024-11-14 03:07:36', 'Paulo Faria', NULL, '', 0),
(482376, 'JAV9G35', 276371, '', 'JAV9G35', '2024-11-14 03:07:37', 'Paulo Faria', NULL, '', 0),
(482427, 'AYP2472', 276791, '', 'AYP2472', '2024-11-14 03:07:31', 'Paulo Faria', NULL, '', 0),
(482510, 'EFO7C61', 276424, '', 'EFO7C61', '2024-11-14 03:07:34', 'Paulo Faria', NULL, '', 0),
(482544, 'MLU0B86', 276310, '', 'MLU0B86', '2024-11-14 03:07:55', 'Paulo Faria', NULL, '', 0),
(482582, 'RVO2H23', 276232, '', 'RVO2H23', '2024-11-14 03:07:38', 'Paulo Faria', NULL, '', 0),
(482635, 'JAI2A55', 276412, '', 'JAI2A55', '2024-11-25 18:29:15', 'Paulo Faria', NULL, '', 0),
(482641, 'CVN9324', 276363, '', 'CVN9324', '2024-11-25 18:29:09', 'Paulo Faria', NULL, '', 0),
(482702, 'OHI8H19', 276818, '', 'OHI8H19', '2024-11-25 18:29:12', 'Paulo Faria', NULL, '', 0),
(482727, 'FFW4750', 275405, '', 'FFW4750', '2024-11-25 18:29:12', 'Paulo Faria', NULL, '', 0),
(482773, 'DKI3741', 276296, '', 'DKI3741', '2024-11-25 18:29:10', 'Paulo Faria', NULL, '', 0),
(482779, 'DKI3748', 276400, '', 'DKI3748', '2024-11-25 18:29:11', 'Paulo Faria', NULL, '', 0),
(482788, 'FQD3F12', 276266, '', 'FQD3F12', '2024-11-25 18:29:13', 'Paulo Faria', NULL, '', 0),
(482806, 'DVS5346', 276350, '', 'DVS5346', '2024-11-25 18:29:11', 'Paulo Faria', NULL, '', 0),
(482833, 'GAT5678', 276772, '', 'GAT5678', '2024-11-25 18:29:16', 'Paulo Faria', NULL, '', 0),
(482841, 'CQH3298', 276339, '', 'CQH3298', '2024-11-25 18:29:10', 'Paulo Faria', NULL, '', 0),
(482855, 'JAT3B86', 276428, '', 'JAT3B86', '2024-11-25 18:29:15', 'Paulo Faria', NULL, '', 0),
(482963, 'PUV3C29', 276358, '', 'PUV3C29', '2024-11-28 08:03:04', 'Paulo Faria', NULL, '', 0),
(483000, 'DPE5844', 276220, '', 'DPE5844', '2024-11-28 08:02:50', 'Paulo Faria', NULL, '', 0),
(483163, 'CUA7967', 276839, '', 'CUA7967', '2024-12-02 18:45:28', 'Paulo Faria', NULL, '', 0),
(483168, 'JYB9E58', 276362, '', 'JYB9E58', '2024-12-02 18:45:44', 'Paulo Faria', NULL, '', 0),
(483323, 'DJB5035', 276770, '', 'DJB5035', '2024-12-11 19:56:18', 'Paulo Faria', '2024-12-11 19:45:39', 'Paulo Faria', 0);

--
-- Índices para tabelas despejadas
--

--
-- Índices para tabela `autotrac_veiculo`
--
ALTER TABLE `autotrac_veiculo`
  ADD PRIMARY KEY (`veiculo`),
  ADD UNIQUE KEY `idx_placa` (`placa`),
  ADD UNIQUE KEY `codigo_UNIQUE` (`veiculo`) USING BTREE,
  ADD KEY `idx_nome` (`nome`);
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 */;