-- https://www.phpmyadmin.net/
--
-- Tempo de geração: 24-Maio-2022 às 22:18
-- Versão do servidor: 5.7.38
-- versão do PHP: 7.4.29

START TRANSACTION;



--
-- Banco de dados: `mc2_kodular`
--

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

--
-- Estrutura da tabela `MPKconvenios`
--

CREATE TABLE `MPKconvenios` (
  `id` int(11) NOT NULL,
  `codEmp` varchar(13) NOT NULL,
  `codConv` varchar(13) NOT NULL,
  `nomeConv` varchar(15) NOT NULL,
  `contaConv` decimal(10,2) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- Estrutura da tabela `MPKempresas`
--

CREATE TABLE `MPKempresas` (
  `id` int(11) NOT NULL,
  `codEmp` varchar(13) NOT NULL,
  `nomeEmp` varchar(30) NOT NULL,
  `cnpj` varchar(20) NOT NULL COMMENT 'CNPJ com pontos',
  `inscMunic` varchar(10) NOT NULL COMMENT 'Inscrição Municipal',
  `periodo` varchar(1) NOT NULL DEFAULT 'X',
  `dtVenc` date NOT NULL,
  `dtPagto` date NOT NULL,
  `valorPago` decimal(10,2) NOT NULL,
  `taxaConv` decimal(10,4) NOT NULL,
  `situacao` varchar(1) NOT NULL DEFAULT '0',
  `chave` varchar(19) NOT NULL,
  `valor` decimal(10,2) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Extraindo dados da tabela `MPKempresas`
--

INSERT INTO `MPKempresas` (`id`, `codEmp`, `nomeEmp`, `cnpj`, `inscMunic`, `periodo`, `dtVenc`, `dtPagto`, `valorPago`, `taxaConv`, `situacao`, `chave`, `valor`) VALUES
(1, '1258', 'Estacionamento Nog', '', '', 'T', '0000-00-00', '0000-00-00', '0.00', '0.0000', '5', '', '0.00'),
(6, '1946', 'Park', '12.345.678/0001-01', '1234567', 'T', '0000-00-00', '0000-00-00', '0.00', '0.0000', '5', '', '0.00');

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

--
-- Estrutura da tabela `MPKfreq`
--

CREATE TABLE `MPKfreq` (
  `id` int(11) NOT NULL,
  `codEmp` varchar(13) NOT NULL,
  `placa` varchar(7) NOT NULL,
  `codModel` varchar(5) NOT NULL,
  `telCelular` varchar(14) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Extraindo dados da tabela `MPKfreq`
--

INSERT INTO `MPKfreq` (`id`, `codEmp`, `placa`, `codModel`, `telCelular`) VALUES
(67, '1946', 'NOG0001', '1', '13996708084'),
(66, '1946', 'NOG0014', '412', '19992021873'),
(65, '1946', 'NOG0012', '498', '19992023690'),
(64, '1946', 'NOG0012', '498', '19992021873'),
(63, '1946', 'NOG0010', '1', '19992021873'),
(62, '1946', 'NOG0010', '1', '19992029630'),
(61, '1946', 'NOG0012', '498', '13996708084'),
(60, '1946', 'NOG0010', '1', '19992021873'),
(59, '1946', 'NOG0002', '2', '19993319875'),
(68, '1946', 'ABC1234', '588', ''),
(69, '1946', 'NOG00X5', '2', ''),
(70, '1946', 'NOG2022', '1 ', ''),
(71, '1946', 'HGD7538', '89', '13991700912'),
(72, '1946', 'HFD5857', '588 ', ''),
(73, '1946', 'JCD9H85', '1 ', ''),
(74, '1946', 'ABC1X23', '2 ', '13991700912 '),
(75, '1946', 'JGD7538', '588 ', ''),
(76, '1946', 'JGE9583', '702 ', ''),
(77, '1946', 'IGE8475', '254 ', ''),
(78, '1946', 'IGE8475', '254 ', ''),
(79, '1946', 'JHF8527', '2 ', ''),
(80, '1946', 'UTE6G64', '345 ', '13991700912'),
(81, '1946', 'UVD7B46', '498 ', '13991700912'),
(82, '1946', 'IGE8483', '412 ', '13991700912'),
(83, '1946', 'JBS7G57', '1 ', '19992021873'),
(84, '1946', 'WONT857', '687 ', '13 9 9170-0912'),
(85, '1946', 'SDD8375', '345 ', '13991700912'),
(86, '1946', 'JGF7H83', '702 ', '19992021873'),
(87, '1946', 'KKK8537', '702 ', ''),
(88, '1946', 'JGE8475', '588 ', ''),
(89, '1946', 'IGD4947', '702 ', ''),
(90, '1946', 'JGE4989', '498 ', ''),
(91, '1946', 'XXS8G75', '498 ', ''),
(92, '1946', 'WES7H64', '345 ', ''),
(93, '1946', 'IAN6F64', '687 ', ''),
(94, '1946', 'EOV6G53', '254 ', ''),
(95, '1946', 'JVD9699', '702 ', ''),
(96, '1946', 'IGE7539', '2 ', ''),
(97, '1946', 'GDW6H20', '498 ', ''),
(98, '1946', 'DDD7622', '345 ', '');

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

--
-- Estrutura da tabela `MPKmodelos`
--

CREATE TABLE `MPKmodelos` (
  `id` int(11) NOT NULL,
  `codEmp` varchar(13) NOT NULL,
  `codModel` varchar(5) NOT NULL,
  `nomeModel` varchar(20) NOT NULL,
  `porte` varchar(1) NOT NULL COMMENT 'P M G X S'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Extraindo dados da tabela `MPKmodelos`
--

INSERT INTO `MPKmodelos` (`id`, `codEmp`, `codModel`, `nomeModel`, `porte`) VALUES
(1, '1946', '1', 'Tesla ModelX', 'G'),
(2, '1946', '2', 'Citroen X4 ', 'M'),
(3, '1946', '0', 'Criar novo modelo', '-'),
(4, '1946', '254', 'Ford Corcel II', 'P'),
(5, '1946', '412', 'Fiat Uno Premium', 'P'),
(6, '1946', '702', 'Ford Corsa', 'M'),
(7, '1946', '345', 'GM Alfa', 'X'),
(8, '1946', '588', 'Subaru Chinathon', 'G'),
(9, '1946', '687', 'Nog Xhfdg', 's'),
(10, '1946', '498', 'Ford Malibu', 'G'),
(11, '1946', '89', 'nogan - Supper xx', 'M');

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

--
-- Estrutura da tabela `MPKmovimento`
--

CREATE TABLE `MPKmovimento` (
  `id` int(11) NOT NULL,
  `codEmp` varchar(13) NOT NULL,
  `dtMovEnt` datetime NOT NULL,
  `dtMovSai` datetime NOT NULL,
  `placa` varchar(7) NOT NULL,
  `codModel` varchar(5) NOT NULL,
  `codUser` varchar(13) NOT NULL,
  `situacao` varchar(2) NOT NULL COMMENT '0=estacionado 1=avSaiu 2=cvSaiu',
  `local` varchar(10) NOT NULL COMMENT 'localização',
  `totalCv` decimal(10,2) NOT NULL,
  `servicos` decimal(10,2) NOT NULL,
  `total` decimal(10,2) NOT NULL,
  `codConv` varchar(5) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Extraindo dados da tabela `MPKmovimento`
--

INSERT INTO `MPKmovimento` (`id`, `codEmp`, `dtMovEnt`, `dtMovSai`, `placa`, `codModel`, `codUser`, `situacao`, `local`, `totalCv`, `servicos`, `total`, `codConv`) VALUES
(83, '1946', '2020-08-24 14:30:00', '2020-08-25 01:52:27', 'NOG0010', '2', '400', '1', '', '0.00', '0.00', '43.00', ''),
(82, '1946', '2020-08-24 12:00:00', '2020-08-25 01:52:04', 'NOG0001', '1', '400', '1', '', '0.00', '0.00', '49.00', ''),
(84, '1946', '2022-05-16 16:02:00', '2022-05-16 16:02:56', 'ABC1234', '588', '400', '1', '', '0.00', '0.00', '5.00', ''),
(85, '1946', '2022-05-16 21:17:00', '2022-05-21 23:25:24', 'NOG00X5', '2', '400', '1', '', '0.00', '0.00', '376.00', ''),
(86, '1946', '2022-05-19 15:41:00', '2022-05-19 18:15:20', 'NOG2022', '1 ', '400', '1', '', '0.00', '0.00', '16.00', ''),
(87, '1946', '2022-05-19 15:54:00', '2022-05-21 23:43:48', 'HGD7538', '89', '400', '1', '', '0.00', '0.00', '175.00', ''),
(88, '1946', '2022-05-19 20:08:00', '0000-00-00 00:00:00', 'HFD5857', '588 ', '400', '0', '', '0.00', '0.00', '0.00', ''),
(89, '1946', '2022-05-20 10:06:00', '0000-00-00 00:00:00', 'JCD9H85', '1 ', '400', '0', '', '0.00', '0.00', '0.00', ''),
(90, '1946', '2022-05-20 10:38:00', '2022-05-21 23:30:52', 'ABC1X23', '2 ', '400', '1', '', '0.00', '0.00', '118.00', ''),
(91, '1946', '2022-05-20 10:44:00', '0000-00-00 00:00:00', 'JGD7538', '588 ', '400', '0', '', '0.00', '0.00', '0.00', ''),
(92, '1946', '2022-05-20 10:48:00', '0000-00-00 00:00:00', 'JGE9583', '702 ', '400', '0', '', '0.00', '0.00', '0.00', ''),
(93, '1946', '2022-05-20 10:53:00', '0000-00-00 00:00:00', 'IGE8475', '254 ', '400', '0', '', '0.00', '0.00', '0.00', ''),
(94, '1946', '2022-05-20 10:53:00', '0000-00-00 00:00:00', 'IGE8475', '254 ', '400', '0', '', '0.00', '0.00', '0.00', ''),
(95, '1946', '2022-05-20 11:58:00', '0000-00-00 00:00:00', 'JHF8527', '2 ', '400', '0', '', '0.00', '0.00', '0.00', ''),
(96, '1946', '2022-05-20 12:13:00', '2022-05-22 00:03:14', 'UTE6G64', '345 ', '400', '1', '', '0.00', '0.00', '115.00', ''),
(97, '1946', '2022-05-20 12:15:00', '0000-00-00 00:00:00', 'UVD7B46', '498 ', '400', '0', '', '0.00', '0.00', '0.00', ''),
(98, '1946', '2022-05-20 12:29:00', '0000-00-00 00:00:00', 'IGE8483', '412 ', '400', '0', '', '0.00', '0.00', '0.00', ''),
(99, '1946', '2022-05-20 12:35:00', '0000-00-00 00:00:00', 'JBS7G57', '1 ', '400', '0', '', '0.00', '0.00', '0.00', ''),
(100, '1946', '2022-05-20 12:43:00', '2022-05-22 10:54:16', 'WONT857', '687 ', '400', '1', '', '0.00', '0.00', '148.00', ''),
(101, '1946', '2022-05-20 12:55:00', '2022-05-21 23:17:59', 'SDD8375', '345 ', '400', '1', '', '0.00', '0.00', '112.00', ''),
(102, '1946', '2022-05-20 17:43:00', '0000-00-00 00:00:00', 'JGF7H83', '702 ', '400', '0', '', '0.00', '0.00', '0.00', ''),
(103, '1946', '2022-05-22 11:34:00', '0000-00-00 00:00:00', 'KKK8537', '702 ', '400', '0', '', '0.00', '0.00', '0.00', ''),
(104, '1946', '2022-05-22 11:37:00', '0000-00-00 00:00:00', 'JGE8475', '588 ', '400', '0', '', '0.00', '0.00', '0.00', ''),
(105, '1946', '2022-05-22 11:55:00', '0000-00-00 00:00:00', 'IGD4947', '702 ', '400', '0', '', '0.00', '0.00', '0.00', ''),
(106, '1946', '2022-05-22 11:57:00', '0000-00-00 00:00:00', 'JGE4989', '498 ', '400', '0', '', '0.00', '0.00', '0.00', ''),
(107, '1946', '2022-05-22 12:02:00', '0000-00-00 00:00:00', 'XXS8G75', '498 ', '400', '0', '', '0.00', '0.00', '0.00', ''),
(108, '1946', '2022-05-22 12:10:00', '0000-00-00 00:00:00', 'WES7H64', '345 ', '400', '0', '', '0.00', '0.00', '0.00', ''),
(109, '1946', '2022-05-22 12:14:00', '0000-00-00 00:00:00', 'IAN6F64', '687 ', '400', '0', '', '0.00', '0.00', '0.00', ''),
(110, '1946', '2022-05-22 12:18:00', '0000-00-00 00:00:00', 'EOV6G53', '254 ', '400', '0', '', '0.00', '0.00', '0.00', ''),
(111, '1946', '2022-05-24 20:12:00', '0000-00-00 00:00:00', 'JVD9699', '702 ', '400', '0', '', '0.00', '0.00', '0.00', ''),
(112, '1946', '2022-05-24 21:39:00', '0000-00-00 00:00:00', 'IGE7539', '2 ', '400', '0', '', '0.00', '0.00', '0.00', ''),
(113, '1946', '2022-05-24 22:14:00', '0000-00-00 00:00:00', 'DDD7622', '345 ', '400', '0', '', '0.00', '0.00', '0.00', '');

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

--
-- Estrutura da tabela `MPKservicos`
--

CREATE TABLE `MPKservicos` (
  `id` int(11) NOT NULL,
  `codEmp` varchar(13) NOT NULL,
  `codServ` varchar(13) NOT NULL,
  `nomeServ` varchar(15) NOT NULL,
  `valorServ` decimal(10,2) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- Estrutura da tabela `MPKtabelas`
--

CREATE TABLE `MPKtabelas` (
  `id` int(11) NOT NULL,
  `codEmp` varchar(13) NOT NULL,
  `codTab` varchar(13) NOT NULL,
  `nomeTab` varchar(15) NOT NULL,
  `diasSemana` varchar(9) NOT NULL DEFAULT 'T' COMMENT 'T23456SDF',
  `porte` varchar(3) NOT NULL DEFAULT 'T' COMMENT '(T)odos P M G S X',
  `valor1aHora` decimal(10,2) NOT NULL,
  `tempo1aHora` int(11) NOT NULL,
  `valorDemais` decimal(10,2) NOT NULL,
  `tempoDemais` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Extraindo dados da tabela `MPKtabelas`
--

INSERT INTO `MPKtabelas` (`id`, `codEmp`, `codTab`, `nomeTab`, `diasSemana`, `porte`, `valor1aHora`, `tempo1aHora`, `valorDemais`, `tempoDemais`) VALUES
(17, '1946', '157', 'Parada Rápida', 'T', 'T', '10.00', 30, '0.00', 0),
(20, '1946', '632', 'Normal Peq/Med', 'T', 'PM', '10.00', 60, '3.00', 60),
(22, '1946', '769', 'Normal Gde', 'T', 'G', '15.00', 60, '5.00', 60),
(23, '1946', '633', 'Normal Moto', 'T', 'S', '8.00', 60, '3.00', 60),
(24, '1946', '769', 'Normal Xpecial', 'T', 'X', '20.00', 60, '10.00', 60);

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

--
-- Estrutura da tabela `SYStaxas`
--

CREATE TABLE `SYStaxas` (
  `id` int(11) NOT NULL,
  `nomeApp` varchar(15) NOT NULL,
  `taxaMes` decimal(10,2) NOT NULL,
  `taxaTrim` decimal(10,2) NOT NULL,
  `taxaSem` decimal(10,2) NOT NULL,
  `taxaAno` decimal(10,2) NOT NULL,
  `dtAtivacao` datetime NOT NULL,
  `dtLimite` datetime NOT NULL,
  `situacao` varchar(1) NOT NULL DEFAULT '0' COMMENT '0=prevista 1=ativo 9=cancelado'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Extraindo dados da tabela `SYStaxas`
--

INSERT INTO `SYStaxas` (`id`, `nomeApp`, `taxaMes`, `taxaTrim`, `taxaSem`, `taxaAno`, `dtAtivacao`, `dtLimite`, `situacao`) VALUES
(1, 'myParkFull', '5.00', '15.00', '30.00', '60.00', '2020-07-01 00:00:00', '2020-12-31 00:00:00', '1');

--
-- Índices para tabelas despejadas
--

--
-- Índices para tabela `MPKconvenios`
--
ALTER TABLE `MPKconvenios`
  ADD PRIMARY KEY (`id`);

--
-- Índices para tabela `MPKempresas`
--
ALTER TABLE `MPKempresas`
  ADD PRIMARY KEY (`id`);

--
-- Índices para tabela `MPKfreq`
--
ALTER TABLE `MPKfreq`
  ADD PRIMARY KEY (`id`);

--
-- Índices para tabela `MPKmodelos`
--
ALTER TABLE `MPKmodelos`
  ADD PRIMARY KEY (`id`);

--
-- Índices para tabela `MPKmovimento`
--
ALTER TABLE `MPKmovimento`
  ADD PRIMARY KEY (`id`);

--
-- Índices para tabela `MPKservicos`
--
ALTER TABLE `MPKservicos`
  ADD PRIMARY KEY (`id`);

--
-- Índices para tabela `MPKtabelas`
--
ALTER TABLE `MPKtabelas`
  ADD PRIMARY KEY (`id`);

--
-- Índices para tabela `SYStaxas`
--
ALTER TABLE `SYStaxas`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT de tabelas despejadas
--

--
-- AUTO_INCREMENT de tabela `MPKempresas`
--
ALTER TABLE `MPKempresas`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT de tabela `MPKfreq`
--
ALTER TABLE `MPKfreq`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=99;

--
-- AUTO_INCREMENT de tabela `MPKmodelos`
--
ALTER TABLE `MPKmodelos`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;

--
-- AUTO_INCREMENT de tabela `MPKmovimento`
--
ALTER TABLE `MPKmovimento`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=114;
COMMIT;

