-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Host: localhost:3306
-- Tempo de geração: 17/07/2023 às 19:34
-- Versão do servidor: 5.7.42
-- 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: `mc2_kodular`
--

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

--
-- Estrutura para tabela `clientes`
--

CREATE TABLE `clientes` (
  `id` int(11) NOT NULL,
  `codigo` varchar(10) NOT NULL,
  `nomeCliente` varchar(30) NOT NULL,
  `periodo` varchar(10) NOT NULL,
  `dataVenc` varchar(10) NOT NULL,
  `obs` varchar(100) DEFAULT NULL,
  `chave` varchar(20) NOT NULL,
  `situacao` varchar(1) NOT NULL,
  `telefoneWZ` varchar(30) NOT NULL,
  `endereco` varchar(40) NOT NULL,
  `cep` varchar(8) NOT NULL,
  `cidade` varchar(20) NOT NULL,
  `uf` varchar(2) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Despejando dados para a tabela `clientes`
--

INSERT INTO `clientes` (`id`, `codigo`, `nomeCliente`, `periodo`, `dataVenc`, `obs`, `chave`, `situacao`, `telefoneWZ`, `endereco`, `cep`, `cidade`, `uf`) VALUES
(1, '4497', 'JC2 ', 'Trimestral', '30/09/2023', 'Junior do Caracas', '-', '0', '', '', '', '', ''),
(2, '5227', 'ABS 2 Edmilson', 'Trimestral', '30/09/2023', 'Barr Leme 1411', '-', '0', '', '', '', '', ''),
(3, '4108', 'New Marcelo', 'Trimestral', '30/09/2023', 'Marcelo 2', '-', '0', '', '', '', '', ''),
(4, '4273', 'Dias', 'Trimestral', '30/09/2023', '', '', '0', '', '', '', '', ''),
(5, '1103', 'Sylas Park', 'Trimestral', '20/09/2023', 'Pr Paulo Sylas', '-', '0', '', '', '', '', ''),
(6, '5216', 'ABS Edmilson', 'Trimestral', '20/09/2023', 'Rua Dr Quirino', '-', '0', '', '', '', '', ''),
(7, '4348', 'JC Junior', 'Trimestral', '20/09/2023', 'Rua Reg Feijo, 856 - Caio', '-', '0', '', '', '', '', ''),
(8, '4465', 'ZS', 'Trimestral', '20/09/2023', 'Silvio (era Reunidos)', '-', '0', '', '', '', '', ''),
(9, '4226', 'Premium Pk 2', 'Trimestral', '20/09/2023', 'Roberto Japones 2 (era 4224) ***', '-', '0', '', '', '', '', ''),
(10, '4829', 'Montoya', 'Trimestral', '10/09/2023', 'Juan', '-', '0', '', '', '', '', ''),
(11, '5998', 'BelveCamp', 'Semestral', '10/09/2022', 'Rua Bj Const, 1916 frente Cambui2 - Joselei', '-', '0', '', '', '', '', ''),
(12, '6705', 'K Park Francisco', 'Trimestral', '10/09/2023', 'Francisco (ao lado do Tom)', '-', '0', '', '', '', '', ''),
(13, '4272', 'MLG Park', 'Trimestral', '10/09/2023', 'Marco (era 4271 ***)', '-', '0', '', '', '', '', ''),
(14, '2049', 'Ecocamp 2 Barão', 'Trimestral', '10/10/2023', 'Barão de Jaguara', '', '0', '', '', '', '', ''),
(15, '4750', 'Casablanca 2', 'Trimestral', '30/08/2023', 'Wlamir', '-', '0', '', '', '', '', ''),
(16, '4271', 'JR Park', 'Trimestral', '30/08/2023', 'Gal Ozorio 800 Junior', '-', '0', '', '', '', '', ''),
(17, '7173', 'Family', 'Trimestral', '30/08/2023', 'Fernando', '-', '0', '', '', '', '', ''),
(18, '2866', 'Neia 2', 'Trimestral', '30/08/2023', 'Neia e Jeferson', '-', '0', '', '', '', '', ''),
(19, '4225', 'Ouro Verde', 'Semestral', '30/11/2023', 'Gilberto (era cod 4224 ***)', '-', '0', '', '', '', '', ''),
(20, '4224', 'Fenix', 'Trimestral', '30/08/2023', 'Adriano', '-', '0', '', '', '', '', ''),
(21, '6705', 'Caracas', 'Trimestral', '20/08/2023', 'com Caio', '-', '0', '', '', '', '', ''),
(22, '4750', 'Casablanca', 'Trimestral', '20/08/2023', 'Wlamir', '-', '0', '', '', '', '', ''),
(23, '1924', 'Camp Valet', 'Trimestral', '10/08/2023', '-', '-', '0', '', '', '', '', ''),
(24, '2205', 'Fabio', 'Trimestral', '10/08/2023', 'ex kirinus', '-', '0', '', '', '', '', ''),
(25, '5821', 'Bras Ferr Pent', 'Trimestral', '10/08/2023', 'Rua Ferreira Penteado - Caio', '-', '0', '', '', '', '', ''),
(26, '4020', 'Bras Ant Cez', 'Trimestral', '10/08/2023', 'Rua Antonio Cesarino, 481 - Caio', '-', '0', '', '', '', '', ''),
(27, '1843', 'Nogs Park', 'Trimestral', '10/08/2023', 'ao lado prefeitura', '-', '0', '', '', '', '', ''),
(28, '2554', 'ArcoIris', 'Trimestral', '10/08/2023', 'Sergio', '-', '0', '', '', '', '', ''),
(29, '2992', 'Bastos Israel', 'Trimestral', '10/08/2023', 'acima do Ruby - Israel', '-', '0', '', '', '', '', ''),
(30, '4372', 'Camp Park', 'Trimestral', '30/07/2023', 'outro do  Guido', '-', '0', '', '', '', '', ''),
(31, '4892', 'VR', 'Trimestral', '30/07/2023', 'Vanderlei\r\nPenido mudou para cod 4893', '-', '0', '', '', '', '', ''),
(32, '7090', 'Riachuelo Bosque', 'Trimestral', '30/07/2023', 'Rubens', '-', '0', '', '', '', '', ''),
(33, '1236', 'AlvCar', 'Trimestral', '30/07/2023', '-', '-', '0', '', '', '', '', ''),
(34, '5660', 'Cacau', 'Trimestral', '30/07/2023', '-', '-', '0', '', '', '', '', ''),
(35, '7552', 'ParkCar', 'Anual', '20/01/2024', 'Hugo argentino', '-', '0', '', '', '', '', ''),
(36, '1655', 'Ricar Park', 'Trimestral', '20/07/2023', 'Fabio', '-', '0', '', '', '', '', ''),
(37, '6188', 'Stop DQ Jarly', 'Trimestral', '20/07/2023', 'Jarly', '-', '0', '', '', '', '', ''),
(38, '7499', 'Poli Lav Rapido', 'Trimestral', '20/10/2023', 'Adriano', '', '0', '', '', '', '', ''),
(39, '6541', 'Cambui', 'Trimestral', '20/07/2023', '-', '-', '0', '', '', '', '', ''),
(40, '6705', 'Kpark Guido', 'Trimestral', '20/07/2023', 'Jpaulino, 617 Ceará ', '-', '0', '', '', '', '', ''),
(41, '1209', 'Mary', 'Trimestral', '20/10/2023', 'Tatiana esposa', '', '0', '', '', '', '', ''),
(42, '1662', 'E512', 'Trimestral', '20/10/2023', 'caetano.caetano512@gmail.com', '', '0', '', '', '', '', ''),
(43, '5773', 'Farah', 'Trimestral', '20/07/2023', 'Fon', '-', '0', '', '', '', '', ''),
(44, '7615', 'Triduo', 'Anual', '10/07/2024', 'Cartório Lincoln', '', '0', '', '', '', '', ''),
(45, '5683', 'Jc Park (Parcero)', 'Trimestral', '10/10/2023', '-', '', '0', '', '', '', '', ''),
(46, '2050', 'Ecocamp', 'Trimestral', '10/09/2023', 'Primeiro', '', '0', '', '', '', '', ''),
(47, '6711', 'Vinhedo', 'Trimestral', '10/10/2023', 'Rogerio', '', '0', '', '', '', '', ''),
(48, '1481', 'Tigão', 'Trimestral', '10/10/2023', 'Junior', '', '0', '', '', '', '', ''),
(49, '4670', 'Gira', 'Trimestral', '10/10/2023', '-', '', '0', '', '', '', '', ''),
(50, '1189', 'Samara', 'Trimestral', '10/10/2023', '-', '', '0', '', '', '', '', ''),
(52, '4893', 'Penido Park', 'Trimestral', '30/07/2023', 'Vander\r\nera 4892', '', '0', '', '', '', '', ''),
(53, '4227', 'Provec', 'Trimestral', '30/08/2023', 'Junior', '', '0', '', '', '', '', ''),
(54, '4228', 'Caromari', 'Trimestral', '30/08/2023', 'Mauro ', '', '0', '', '', '', '', '');

--
-- Índices para tabelas despejadas
--

--
-- Índices de tabela `clientes`
--
ALTER TABLE `clientes`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT para tabelas despejadas
--

--
-- AUTO_INCREMENT de tabela `clientes`
--
ALTER TABLE `clientes`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=57;
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 */;
