TransWar File Browser

Path: C:\

-- phpMyAdmin SQL Dump
-- version 5.2.0
-- https://www.phpmyadmin.net/
--
-- Host: localhost
-- Tempo de geração: 04-Nov-2024 às 14:24
-- 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 `login_logout`
--

CREATE TABLE `login_logout` (
  `ID` int NOT NULL,
  `LoginTime` datetime DEFAULT NULL,
  `LogoutTime` datetime DEFAULT NULL,
  `DriverName` varchar(100) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
  `VehicleAddress` int NOT NULL,
  `VehicleName` varchar(20) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
  `VehicleCode` int NOT NULL,
  `VehicleLicensePlate` varchar(20) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
  `DriverCPF` varchar(20) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

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

--
-- Estrutura da tabela `mcr_macro`
--

CREATE TABLE `mcr_macro` (
  `MCR_ID` int NOT NULL,
  `MCR_Number` int NOT NULL,
  `MCR_Name` varchar(50) CHARACTER SET latin1 COLLATE latin1_general_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

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

--
-- Estrutura da tabela `msg_retorno`
--

CREATE TABLE `msg_retorno` (
  `MSG_ID` int NOT NULL,
  `MSG_AccountNumber` int NOT NULL,
  `MSG_VehicleAddress` int NOT NULL,
  `MSG_VehicleCode` int NOT NULL,
  `MSG_VehicleName` varchar(20) COLLATE latin1_general_ci NOT NULL,
  `MSG_Priority` tinyint DEFAULT NULL,
  `MSG_Grmn` int NOT NULL,
  `MSG_Ignition` tinyint DEFAULT NULL,
  `MSG_MacroNumber` tinyint NOT NULL,
  `MSG_MacroVersion` tinyint DEFAULT NULL,
  `MSG_BinaryDatatype` tinyint DEFAULT NULL,
  `MSG_MsgSubtype` int DEFAULT NULL,
  `MSG_MessageTime` datetime DEFAULT NULL,
  `MSG_MessageText` varchar(4000) CHARACTER SET latin1 COLLATE latin1_general_ci DEFAULT NULL,
  `MSG_Latitude` decimal(9,6) DEFAULT NULL,
  `MSG_Longitude` decimal(9,6) DEFAULT NULL,
  `MSG_PositionTime` datetime DEFAULT NULL,
  `MSG_Landmark` varchar(255) CHARACTER SET latin1 COLLATE latin1_general_ci DEFAULT NULL,
  `MSG_TransmissionChannel` int DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

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

--
-- Estrutura da tabela `pos_historico`
--

CREATE TABLE `pos_historico` (
  `POS_ID` int NOT NULL,
  `POS_AccountNumber` int NOT NULL,
  `POS_VehicleName` varchar(20) COLLATE latin1_general_ci NOT NULL,
  `POS_VehicleAddress` int NOT NULL,
  `POS_VehicleCode` int NOT NULL,
  `POS_VehicleIgnition` tinyint DEFAULT NULL,
  `POS_Velocity` varchar(50) CHARACTER SET latin1 COLLATE latin1_general_ci DEFAULT NULL,
  `POS_Odometer` bigint DEFAULT NULL,
  `POS_Hourmeter` bigint DEFAULT NULL,
  `POS_Latitude` decimal(9,6) DEFAULT NULL,
  `POS_Longitude` decimal(9,6) DEFAULT NULL,
  `POS_Landmark` varchar(255) CHARACTER SET latin1 COLLATE latin1_general_ci DEFAULT NULL,
  `POS_UF` varchar(2) CHARACTER SET latin1 COLLATE latin1_general_ci DEFAULT NULL,
  `POS_CountryDescription` varchar(20) CHARACTER SET latin1 COLLATE latin1_general_ci DEFAULT NULL,
  `POS_PositionTime` datetime DEFAULT NULL,
  `POS_Direction` tinyint DEFAULT NULL,
  `POS_DirectionGPS` tinyint DEFAULT NULL,
  `POS_Distance` decimal(9,9) DEFAULT NULL,
  `POS_ReceivedTime` datetime DEFAULT NULL,
  `POS_TransmissionChannel` int DEFAULT NULL,
  `POS_County` varchar(50) CHARACTER SET latin1 COLLATE latin1_general_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

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

--
-- Estrutura da tabela `veiculos`
--

CREATE TABLE `veiculos` (
  `ID` int NOT NULL,
  `Name` varchar(20) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
  `Address` int NOT NULL,
  `Code` int NOT NULL,
  `TripName` varchar(20) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
  `LicensePlate` varchar(20) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Índices para tabelas despejadas
--

--
-- Índices para tabela `login_logout`
--
ALTER TABLE `login_logout`
  ADD PRIMARY KEY (`ID`,`VehicleCode`,`VehicleAddress`,`DriverName`);

--
-- Índices para tabela `mcr_macro`
--
ALTER TABLE `mcr_macro`
  ADD PRIMARY KEY (`MCR_ID`,`MCR_Number`),
  ADD UNIQUE KEY `MCR_ID_UNIQUE` (`MCR_ID`),
  ADD UNIQUE KEY `MCR_Number_UNIQUE` (`MCR_Number`);

--
-- Índices para tabela `msg_retorno`
--
ALTER TABLE `msg_retorno`
  ADD PRIMARY KEY (`MSG_ID`,`MSG_VehicleCode`,`MSG_MacroNumber`);

--
-- Índices para tabela `pos_historico`
--
ALTER TABLE `pos_historico`
  ADD PRIMARY KEY (`POS_ID`,`POS_VehicleCode`,`POS_VehicleName`);

--
-- Índices para tabela `veiculos`
--
ALTER TABLE `veiculos`
  ADD PRIMARY KEY (`ID`,`Code`,`Name`,`Address`);

--
-- AUTO_INCREMENT de tabelas despejadas
--

--
-- AUTO_INCREMENT de tabela `login_logout`
--
ALTER TABLE `login_logout`
  MODIFY `ID` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de tabela `mcr_macro`
--
ALTER TABLE `mcr_macro`
  MODIFY `MCR_ID` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de tabela `msg_retorno`
--
ALTER TABLE `msg_retorno`
  MODIFY `MSG_ID` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de tabela `pos_historico`
--
ALTER TABLE `pos_historico`
  MODIFY `POS_ID` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de tabela `veiculos`
--
ALTER TABLE `veiculos`
  MODIFY `ID` int NOT NULL AUTO_INCREMENT;
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 */;