-- https://www.phpmyadmin.net/
--
-- Hôte : 127.0.0.1
-- Généré le : mer. 01 mars 2023 à 00:48
-- Version du serveur : 10.4.22-MariaDB
-- Version de PHP : 8.1.2

START TRANSACTION;



--
-- Base de données : `structurea_db`
--

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

--
-- Structure de la table `accidents`
--

CREATE TABLE `accidents` (
  `id` int(11) NOT NULL,
  `victime` int(11) NOT NULL,
  `type_accident` varchar(250) NOT NULL,
  `description` varchar(250) NOT NULL,
  `soin` varchar(250) NOT NULL,
  `materiel` varchar(250) NOT NULL,
  `evacution` varchar(10) NOT NULL,
  `hopital` varchar(250) DEFAULT NULL,
  `date` date NOT NULL,
  `created_by` int(11) NOT NULL,
  `created_at` date NOT NULL,
  `updated_by` int(11) NOT NULL,
  `updated_at` date NOT NULL,
  `statut` int(1) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Déchargement des données de la table `accidents`
--

INSERT INTO `accidents` (`id`, `victime`, `type_accident`, `description`, `soin`, `materiel`, `evacution`, `hopital`, `date`, `created_by`, `created_at`, `updated_by`, `updated_at`, `statut`) VALUES
(1, 3, 'Blessure par marteau', 'Il s\'est cassé le doigt avec un marteau', 'Premier secours', 'Marteau', '', NULL, '2023-02-08', 1, '2023-02-18', 1, '2023-02-18', 1),
(2, 9, 'Coup de marteau piqueur', 'Coup de marteau piqueur sur le pieds', 'Admission à l\'hôpital par ambulance', 'Marteau piqueur multifonction', '', NULL, '2023-02-07', 1, '2023-02-18', 1, '2023-02-18', 0),
(3, 5, 'Blessure par marteau', 'Il s\'est cassé le doigt avec un marteau', 'Premier secours', 'Marteau', '', NULL, '2023-02-06', 1, '2023-02-19', 1, '2023-02-19', 1);

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

--
-- Structure de la table `approvisionnements`
--

CREATE TABLE `approvisionnements` (
  `id` int(11) NOT NULL,
  `fournisseur` int(11) NOT NULL,
  `liste_articles` varchar(250) NOT NULL,
  `montant_total` decimal(14,2) NOT NULL DEFAULT 0.00,
  `montant_restant` decimal(14,2) NOT NULL DEFAULT 0.00,
  `created_by` int(11) NOT NULL,
  `created_at` date NOT NULL,
  `updated_by` int(11) NOT NULL,
  `updated_at` date NOT NULL,
  `statut` int(1) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Déchargement des données de la table `approvisionnements`
--

INSERT INTO `approvisionnements` (`id`, `fournisseur`, `liste_articles`, `montant_total`, `montant_restant`, `created_by`, `created_at`, `updated_by`, `updated_at`, `statut`) VALUES
(1, 1, '14, 8', '90500.00', '0.00', 4, '2023-02-20', 4, '2023-02-20', 1),
(2, 4, '13, 9', '120800.00', '120800.00', 4, '2023-02-20', 1, '2023-02-25', 1),
(3, 5, '12', '15000.00', '11000.00', 4, '2023-02-20', 4, '2023-02-20', 0);

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

--
-- Structure de la table `chantiers`
--

CREATE TABLE `chantiers` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `code_chantier` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `adresse` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL,
  `client` int(11) NOT NULL,
  `gestionnaire_chantier` int(11) NOT NULL,
  `chef_chantier` int(11) DEFAULT NULL,
  `liste_chefs_equipes` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `liste_personnels` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `liste_materiels` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `date_debut` date DEFAULT NULL,
  `date_fin` date DEFAULT NULL,
  `achever` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'NON',
  `created_by` int(11) NOT NULL,
  `updated_by` int(11) NOT NULL,
  `statut` int(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Déchargement des données de la table `chantiers`
--

INSERT INTO `chantiers` (`id`, `code_chantier`, `description`, `adresse`, `client`, `gestionnaire_chantier`, `chef_chantier`, `liste_chefs_equipes`, `liste_personnels`, `liste_materiels`, `date_debut`, `date_fin`, `achever`, `created_by`, `updated_by`, `statut`, `created_at`, `updated_at`) VALUES
(1, 'Chantier Tokoin 1', 'Chantier Tokoin 1', 'Tokoin tamé', 1, 6, 3, '', ',1,2', ',6,8,9,12,13,14', NULL, NULL, '', 1, 0, 1, '2023-02-10 18:48:33', '2023-02-12 12:15:35'),
(2, 'CHT/2023/02/12/1', 'Réseau Adidoadin Burval', 'Adidoadin Concorde', 3, 6, 3, '', '2', '', NULL, NULL, '', 0, 0, 0, '2023-02-12 09:16:32', '2023-02-23 12:59:32'),
(3, 'CHT/2023/02/12/1', 'Réseau ANASAP', 'Avedzi', 3, 6, 3, '', ',1,2', ',6,8,9,12,13,14', NULL, NULL, '', 0, 0, 1, '2023-02-12 11:14:00', '2023-02-12 12:16:39'),
(4, 'CHT/2023/02/18/999', 'AUCUN CHANTIER', 'AUCUNE ADRESSE', 1, 7, 5, '', '', '', NULL, NULL, '', 4, 4, 1, '2023-02-18 17:59:28', '2023-02-18 17:59:28'),
(5, 'CHT/2023/02/23/1', 'Réseau Lomnava', 'Lomnava', 2, 1, 2, '', '', '', '2023-02-23', '2023-03-12', 'NON', 1, 1, 1, '2023-02-23 13:07:57', '2023-02-23 13:08:55');

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

--
-- Structure de la table `clients`
--

CREATE TABLE `clients` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `nom` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `telephone` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `num_tva` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT 'N/A',
  `adresse` varchar(150) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `categorie` varchar(150) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `observation` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT '-',
  `created_by` int(11) NOT NULL,
  `updated_by` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `statut` int(1) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Déchargement des données de la table `clients`
--

INSERT INTO `clients` (`id`, `nom`, `description`, `telephone`, `email`, `num_tva`, `adresse`, `categorie`, `observation`, `created_by`, `updated_by`, `created_at`, `updated_at`, `statut`) VALUES
(1, 'ETS PALMARES TECH SECUDOC', 'PALMARES TECH SECUDOC, prestataire de services informatiques ', '+228 91 89 17 18', 'venant@palmarestech.com', 'N/A', 'Tokoin - Ramco', 'Entreprise', 'Meilleur prestataire', 0, 0, '2023-02-09 09:25:27', '2023-02-09 09:26:33', 1),
(2, 'BB LOME', 'Echelle en Aluminium dépliable de 10m', '+22870349710', 'contact@bblome.tg', 'N/A', 'Lomé, quartier Agoè-cacavéli', 'Quincaillerie', 'Mauvais', 0, 0, '2023-02-09 09:27:17', '2023-02-09 09:27:32', 1),
(3, 'Koffi', 'client 1', '+22870349710', 'contact@eli.com', 'N/A', 'Lomé, Agoè Kossigan', 'Entreprise', 'Un très bon client', 0, 1, '2023-02-10 21:53:21', '2023-02-25 17:47:22', 1),
(4, 'Kokou', NULL, '+22898623901', 'rayalougba@rea.tg', NULL, 'Baguida plantation', NULL, NULL, 1, 1, '2023-02-28 14:32:30', '2023-02-28 14:37:46', 1);

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

--
-- Structure de la table `collaborateurs`
--

CREATE TABLE `collaborateurs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `nom` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `telephone` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `adresse` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `type` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_by` int(11) DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `statut` int(1) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Déchargement des données de la table `collaborateurs`
--

INSERT INTO `collaborateurs` (`id`, `created_at`, `updated_at`, `nom`, `description`, `telephone`, `email`, `adresse`, `type`, `created_by`, `updated_by`, `statut`) VALUES
(1, '2023-02-22 21:03:41', '2023-02-22 22:35:43', 'Kokou', NULL, '+22898623901', 'rayalougba@rea.tg', 'Baguida plantation', 'LOCATAIRE', 1, 1, 1),
(2, '2023-02-22 22:34:24', '2023-02-22 22:34:24', 'Patrick', 'Patrick Gbohun', '+22898623901', 'patrice@gmail.com', 'Adetikopé', 'PROPRIETAIRE', 1, 1, 1),
(3, '2023-02-22 22:35:13', '2023-02-22 22:35:13', 'Patrick', 'Patrick Gbohun', '+22898623901', 'patrice@gmail.com', 'Adetikopé', 'LOCATAIRE', 1, 1, 1);

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

--
-- Structure de la table `commandes`
--

CREATE TABLE `commandes` (
  `id` int(11) UNSIGNED NOT NULL,
  `code_commande` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `article` int(11) NOT NULL,
  `quantite` decimal(14,2) NOT NULL,
  `prix` decimal(14,2) DEFAULT NULL,
  `remise` decimal(14,2) DEFAULT NULL,
  `description` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `date_commande` date NOT NULL,
  `date_livraison` date DEFAULT NULL,
  `fournisseur` int(11) NOT NULL,
  `client` int(11) NOT NULL DEFAULT 1,
  `etat` int(1) NOT NULL DEFAULT 0 COMMENT '0:en attente, 1:livré',
  `created_by` int(11) NOT NULL,
  `updated_by` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `statut` int(1) NOT NULL DEFAULT 1 COMMENT '0:supprimé, 1:actif, 2:inactif'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Déchargement des données de la table `commandes`
--

INSERT INTO `commandes` (`id`, `code_commande`, `article`, `quantite`, `prix`, `remise`, `description`, `date_commande`, `date_livraison`, `fournisseur`, `client`, `etat`, `created_by`, `updated_by`, `created_at`, `updated_at`, `statut`) VALUES
(1, 'CMD/2023/02/09-14/42/42GG', 8, '30.00', NULL, NULL, 'Commande de Switch Layer 3', '2023-02-09', '2023-02-16', 1, 1, 0, 0, 0, '2023-02-09 14:42:42', '2023-02-09 17:20:05', 1),
(2, 'CMD-001-2023-02-09', 9, '10.00', NULL, NULL, 'Switch CISCO modulable', '2023-02-11', '2023-02-19', 1, 1, 1, 0, 0, '2023-02-09 16:48:02', '2023-02-09 16:48:02', 1),
(3, 'CMD-001-2023-02-09', 8, '34.00', NULL, NULL, 'Echelle en Aluminium dépliable de 10m', '2023-02-01', '2023-02-11', 1, 1, 1, 0, 0, '2023-02-09 16:59:27', '2023-02-09 16:59:40', 0),
(4, 'CMD/2023/02/10/5', 12, '2.00', NULL, NULL, 'Pince à sertir', '2023-02-10', '2023-02-12', 4, 3, 0, 0, 0, '2023-02-10 21:55:31', '2023-02-10 21:56:05', 1),
(5, 'CMD/2023/02/11/1', 14, '3.00', '1500.00', NULL, 'Commande de connecteur RJ45', '2023-02-11', '2023-02-11', 2, 3, 0, 0, 1, '2023-02-11 21:01:38', '2023-02-23 00:20:45', 1),
(6, 'CMD/2023/02/23/2', 15, '2.00', '24000.00', '0.00', 'Testeur de connectivité de câbles réseaux analogique', '2023-02-23', '2023-02-23', 1, 1, 1, 1, 1, '2023-02-23 09:38:04', '2023-02-23 09:52:52', 1),
(7, 'CMD/2023/02/25/1', 17, '5.20', '12800.99', '0.01', 'Fournisseur d\'outils et de matériau de construction (quincaillerie)', '2023-02-25', '2023-02-26', 2, 2, 1, 1, 1, '2023-02-25 15:51:19', '2023-02-25 17:46:33', 1);

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

--
-- Structure de la table `commande_materiau`
--

CREATE TABLE `commande_materiau` (
  `id` int(11) NOT NULL,
  `commande` int(11) NOT NULL,
  `materiau` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Structure de la table `contraventions`
--

CREATE TABLE `contraventions` (
  `id` int(11) NOT NULL,
  `type` varchar(150) NOT NULL,
  `qui` int(11) NOT NULL,
  `quand` date NOT NULL,
  `pourquoi` varchar(250) NOT NULL,
  `montant` decimal(14,2) NOT NULL,
  `reference` varchar(150) NOT NULL,
  `payer` varchar(10) NOT NULL,
  `created_by` int(11) NOT NULL,
  `created_at` date NOT NULL,
  `updated_by` int(11) NOT NULL,
  `updated_at` date NOT NULL,
  `statut` int(1) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Déchargement des données de la table `contraventions`
--

INSERT INTO `contraventions` (`id`, `type`, `qui`, `quand`, `pourquoi`, `montant`, `reference`, `payer`, `created_by`, `created_at`, `updated_by`, `updated_at`, `statut`) VALUES
(1, 'EXCES DE VITESSE', 7, '2023-02-18', 'Excès de vitesse', '5000.00', 'CTR-X43/8976', 'OUI', 4, '2023-02-20', 4, '2023-02-20', 1),
(2, 'EXCES DE VITESSE', 2, '2023-01-31', 'Excès de vitesse', '10.00', 'CTR-X43/8976', 'NON', 1, '2023-02-20', 1, '2023-02-20', 0);

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

--
-- Structure de la table `emprunts`
--

CREATE TABLE `emprunts` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `code_emprunt` varchar(30) COLLATE utf8mb4_unicode_ci NOT NULL,
  `proprietaire` int(11) NOT NULL,
  `acquerant` int(11) NOT NULL,
  `materiel` int(11) NOT NULL,
  `quantite_louer` decimal(14,2) NOT NULL,
  `description` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `date_emprunt` date NOT NULL,
  `date_prevue_restitution` date NOT NULL,
  `quantite_restituer` decimal(14,2) DEFAULT 0.00,
  `date_restitution` date DEFAULT NULL,
  `restitution` int(1) DEFAULT 0,
  `created_by` int(11) NOT NULL,
  `updated_by` int(11) NOT NULL,
  `statut` int(1) NOT NULL DEFAULT 1,
  `created_at` date DEFAULT NULL,
  `updated_at` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Déchargement des données de la table `emprunts`
--

INSERT INTO `emprunts` (`id`, `code_emprunt`, `proprietaire`, `acquerant`, `materiel`, `quantite_louer`, `description`, `date_emprunt`, `date_prevue_restitution`, `quantite_restituer`, `date_restitution`, `restitution`, `created_by`, `updated_by`, `statut`, `created_at`, `updated_at`) VALUES
(1, 'CHT/2023/02/10/1', 3, 1, 6, '5.00', 'Echelle en Aluminium dépliable de 10m', '2023-02-10', '2023-02-17', '0.00', NULL, 0, 0, 0, 0, '2023-02-10', '2023-02-10'),
(2, 'CHT/2023/02/10/1', 3, 1, 6, '6.00', 'Echelle en Aluminium dépliable de 10m', '2023-02-10', '2023-02-17', '0.00', NULL, NULL, 0, 0, 0, '2023-02-10', '2023-02-10'),
(3, 'LCT/2023/02/10/2', 3, 1, 8, '0.00', 'Location de perceuse', '2023-02-10', '2023-02-17', '0.00', NULL, NULL, 0, 0, 0, '2023-02-10', '2023-02-22'),
(4, 'LCT/2023/02/10/2', 3, 1, 8, '5.00', 'Location de perceuse', '2023-02-10', '2023-02-17', '0.00', NULL, 0, 0, 0, 1, '2023-02-10', '2023-02-10'),
(5, 'LCT/2023/02/11/1', 2, 1, 14, '13.00', 'Location de rallonges', '2023-02-11', '2023-02-12', '0.00', NULL, NULL, 0, 1, 1, '2023-02-11', '2023-02-22'),
(6, 'LCT/2023/02/11/1', 3, 1, 14, '1.00', NULL, '2023-02-11', '2023-02-11', '0.00', NULL, 0, 0, 0, 0, '2023-02-11', '2023-02-11'),
(7, 'LCT/2023/02/11/1', 3, 1, 14, '2.00', NULL, '2023-02-11', '2023-02-13', '0.00', NULL, 0, 0, 0, 0, '2023-02-11', '2023-02-11'),
(8, 'LCT/2023/02/11/1', 2, 2, 14, '2.00', 'Location pour Brigite', '2023-02-11', '2023-02-13', '1.00', NULL, NULL, 0, 4, 1, '2023-02-11', '2023-02-18');

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

--
-- Structure de la table `failed_jobs`
--

CREATE TABLE `failed_jobs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `uuid` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `connection` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `queue` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `exception` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Structure de la table `fournisseurs`
--

CREATE TABLE `fournisseurs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `nom` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `telephone` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `num_tva` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT 'N/A',
  `adresse` varchar(150) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `categorie` varchar(150) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `observation` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT '-',
  `created_by` int(11) NOT NULL,
  `updated_by` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `statut` int(1) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Déchargement des données de la table `fournisseurs`
--

INSERT INTO `fournisseurs` (`id`, `nom`, `description`, `telephone`, `email`, `num_tva`, `adresse`, `categorie`, `observation`, `created_by`, `updated_by`, `created_at`, `updated_at`, `statut`) VALUES
(1, 'Ets ELI & FILS', 'Fournisseur d\'outils et de matériau de construction (quincaillerie)', '+22870349710', 'contact@eli.com', 'N/A', 'Lomé, Agoè Kossigan', 'Quincaillerie', 'Bien', 0, 0, '2023-02-09 08:05:55', '2023-02-09 09:13:54', 1),
(2, 'Ets BABAGAN', 'Fournisseur d\'outils et de matériau de construction (quincaillerie)', '+22870349710', 'contact@eli.com', 'N/A', 'Lomé, Agoè Kossigan', 'Matériau de construction', 'Excellent', 0, 0, '2023-02-09 08:32:17', '2023-02-09 16:50:20', 1),
(3, 'Ets ELI &amp; FILS', 'Fournisseur d\'outils et de matériau de construction (quincaillerie)', '+22870349710', 'contact@eli.com', 'N/A', 'Lomé, Agoè Kossigan', 'Matériau de construction', 'Mauvais', 0, 0, '2023-02-09 08:33:15', '2023-02-09 09:14:10', 0),
(4, 'Ets Le Sud', 'Fournisseur d\'equipement réseau', '+22870349710', 'contact@bblome.tg', 'N/A', 'Lomé, quartier Agoè-cacavéli', 'Reseau', 'Bien', 0, 0, '2023-02-10 21:52:06', '2023-02-13 00:07:57', 1),
(5, 'Ets OKLM', 'Ets OKLM', '+22898623901', 'rayalougba@rea.tg', 'N/A', 'Baguida plantation', 'Quincaillerie', 'Assez-bien', 3, 1, '2023-02-17 19:38:30', '2023-02-25 17:46:45', 1),
(6, 'Kokou', NULL, '+22898623901', 'rayalougba@rea.tg', 'N/A', 'Baguida plantation', NULL, NULL, 1, 1, '2023-02-28 14:33:08', '2023-02-28 14:40:10', 1);

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

--
-- Structure de la table `locations`
--

CREATE TABLE `locations` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `code_location` varchar(30) COLLATE utf8mb4_unicode_ci NOT NULL,
  `autorite` int(11) NOT NULL,
  `acquerant` int(11) NOT NULL,
  `chantier` int(11) NOT NULL,
  `materiel` int(11) NOT NULL,
  `quantite_louer` decimal(14,2) NOT NULL,
  `description` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `date_location` date NOT NULL,
  `date_prevue_restitution` date NOT NULL,
  `quantite_restituer` decimal(14,2) DEFAULT 0.00,
  `date_restitution` date DEFAULT NULL,
  `restitution` int(1) DEFAULT 0,
  `created_by` int(11) NOT NULL,
  `updated_by` int(11) NOT NULL,
  `statut` int(1) NOT NULL DEFAULT 1,
  `created_at` date DEFAULT NULL,
  `updated_at` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Déchargement des données de la table `locations`
--

INSERT INTO `locations` (`id`, `code_location`, `autorite`, `acquerant`, `chantier`, `materiel`, `quantite_louer`, `description`, `date_location`, `date_prevue_restitution`, `quantite_restituer`, `date_restitution`, `restitution`, `created_by`, `updated_by`, `statut`, `created_at`, `updated_at`) VALUES
(1, 'CHT/2023/02/10/1', 3, 1, 1, 6, '5.00', 'Echelle en Aluminium dépliable de 10m', '2023-02-10', '2023-02-17', '0.00', NULL, 0, 0, 0, 0, '2023-02-10', '2023-02-10'),
(2, 'CHT/2023/02/10/1', 3, 1, 1, 6, '6.00', 'Echelle en Aluminium dépliable de 10m', '2023-02-10', '2023-02-17', '0.00', NULL, NULL, 0, 0, 0, '2023-02-10', '2023-02-10'),
(3, 'LCT/2023/02/10/2', 3, 1, 1, 8, '0.00', 'Location de perceuse', '2023-02-10', '2023-02-17', '0.00', NULL, NULL, 0, 0, 1, '2023-02-10', '2023-02-11'),
(4, 'LCT/2023/02/10/2', 3, 1, 1, 8, '5.00', 'Location de perceuse', '2023-02-10', '2023-02-17', '0.00', NULL, 0, 0, 0, 1, '2023-02-10', '2023-02-10'),
(5, 'LCT/2023/02/11/1', 2, 1, 1, 14, '13.00', 'Location de rallonges', '2023-02-11', '2023-02-12', '0.00', NULL, NULL, 0, 3, 1, '2023-02-11', '2023-02-17'),
(6, 'LCT/2023/02/11/1', 3, 1, 1, 14, '1.00', NULL, '2023-02-11', '2023-02-11', '0.00', NULL, 0, 0, 0, 0, '2023-02-11', '2023-02-11'),
(7, 'LCT/2023/02/11/1', 3, 1, 1, 14, '2.00', NULL, '2023-02-11', '2023-02-13', '0.00', NULL, 0, 0, 0, 0, '2023-02-11', '2023-02-11'),
(8, 'LCT/2023/02/11/1', 1, 2, 1, 14, '2.00', 'Location pour Brigite', '2023-02-11', '2023-02-13', '1.00', NULL, NULL, 0, 1, 1, '2023-02-11', '2023-02-22');

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

--
-- Structure de la table `materiaus`
--

CREATE TABLE `materiaus` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `nom` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `quantite` decimal(14,2) NOT NULL DEFAULT 0.00,
  `type` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'OUTIL',
  `created_by` int(11) NOT NULL,
  `updated_by` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `statut` int(1) NOT NULL DEFAULT 1 COMMENT '0:supprimé, 1:actif'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Déchargement des données de la table `materiaus`
--

INSERT INTO `materiaus` (`id`, `nom`, `description`, `quantite`, `type`, `created_by`, `updated_by`, `created_at`, `updated_at`, `statut`) VALUES
(4, 'Planche 6 m', 'Planche 6 m', '38.00', 'OUTIL', 0, 0, '2023-02-06 10:48:59', '2023-02-07 19:15:08', 0),
(6, 'TRUELLE', 'TRUELLE POUR MACON', '10.00', 'OUTIL', 0, 0, '2023-02-06 13:37:13', '2023-02-10 19:55:23', 1),
(8, 'perceuse', 'perceuse', '55.00', 'OUTIL', 0, 0, '2023-02-07 18:19:38', '2023-02-11 21:19:22', 1),
(9, 'Switch C3221', 'Switch CISCO modulable', '27.00', 'OUTIL', 0, 0, '2023-02-07 18:21:12', '2023-02-22 22:36:45', 1),
(10, 'Cle USB 16 Go', 'Cle USB 3.0 NB 16 Go', '4.00', 'OUTIL', 0, 0, '2023-02-07 18:34:23', '2023-02-07 19:14:30', 0),
(11, 'Commande câble', 'Echelle en Aluminium dépliable de 10m', '30.00', 'OUTIL', 0, 0, '2023-02-07 19:10:43', '2023-02-07 19:14:18', 0),
(12, 'Pince à sertir', 'Pince à sertir', '7.00', 'OUTIL', 0, 0, '2023-02-10 21:54:03', '2023-02-10 21:56:06', 1),
(13, 'Racgnac', 'Clé à manche bisens', '10.00', 'OUTIL', 0, 0, '2023-02-11 01:10:06', '2023-02-22 22:17:46', 1),
(14, 'Connecteur RJ45', 'Connecteur RJ45', '124.00', 'MATERIAU', 0, 0, '2023-02-11 20:24:23', '2023-02-23 00:20:45', 1),
(15, 'Testeur Analogique', 'Testeur de connectivité de câbles réseaux analogique', '32.00', 'MATERIAU', 0, 0, '2023-02-12 21:20:54', '2023-02-23 09:52:25', 1),
(16, 'Testeur Numérique', 'Testeur de connectivité de câbles réseaux numérique', '25.00', 'MATERIAU', 0, 0, '2023-02-12 21:22:37', '2023-02-12 21:22:37', 1),
(17, 'test', 'test', '1.00', 'MATERIAU', 0, 0, '2023-02-12 21:23:55', '2023-02-13 00:06:16', 1);

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

--
-- Structure de la table `migrations`
--

CREATE TABLE `migrations` (
  `id` int(10) UNSIGNED NOT NULL,
  `migration` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Déchargement des données de la table `migrations`
--

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(1, '2014_10_12_000000_create_users_table', 1),
(2, '2014_10_12_100000_create_password_resets_table', 1),
(3, '2019_08_19_000000_create_failed_jobs_table', 1),
(4, '2019_12_14_000001_create_personal_access_tokens_table', 1),
(5, '2023_02_05_010400_create_commandes_table', 1),
(6, '2023_02_05_010956_create_materiaus_table', 1),
(7, '2023_02_05_012517_create_fournisseurs_table', 1),
(8, '2023_02_05_012721_create_clients_table', 1),
(9, '2023_02_05_012835_create_chantiers_table', 1),
(10, '2023_02_05_012930_create_locations_table', 1),
(11, '2023_02_05_013045_create_personnels_table', 1);

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

--
-- Structure de la table `outils`
--

CREATE TABLE `outils` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `nom` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `quantite` decimal(14,2) NOT NULL,
  `created_by` int(11) NOT NULL,
  `updated_by` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `statut` int(1) NOT NULL DEFAULT 1 COMMENT '0:supprimé, 1:actif'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Déchargement des données de la table `outils`
--

INSERT INTO `outils` (`id`, `nom`, `description`, `quantite`, `created_by`, `updated_by`, `created_at`, `updated_at`, `statut`) VALUES
(4, 'Planche 6 m', 'Planche 6 m', '38.00', 0, 0, '2023-02-06 10:48:59', '2023-02-07 19:15:08', 0),
(6, 'TRUELLE', 'TRUELLE POUR MACON', '14.00', 0, 0, '2023-02-06 13:37:13', '2023-02-07 22:00:02', 1),
(8, 'perceuse', 'perceuse', '21.00', 0, 0, '2023-02-07 18:19:38', '2023-02-08 22:23:36', 1),
(9, 'Switch C3221', 'Switch CISCO modulable', '28.00', 0, 0, '2023-02-07 18:21:12', '2023-02-07 18:37:30', 1),
(10, 'Cle USB 16 Go', 'Cle USB 3.0 NB 16 Go', '4.00', 0, 0, '2023-02-07 18:34:23', '2023-02-07 19:14:30', 0),
(11, 'Commande câble', 'Echelle en Aluminium dépliable de 10m', '30.00', 0, 0, '2023-02-07 19:10:43', '2023-02-07 19:14:18', 0),
(12, 'Pince à sertir', 'Pince à sertir', '5.00', 0, 0, '2023-02-08 22:24:27', '2023-02-08 22:24:27', 1);

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

--
-- Structure de la table `parametres`
--

CREATE TABLE `parametres` (
  `id` int(11) NOT NULL,
  `nom` varchar(30) NOT NULL,
  `valeur` varchar(30) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Déchargement des données de la table `parametres`
--

INSERT INTO `parametres` (`id`, `nom`, `valeur`) VALUES
(3, 'NOTIFICATION', '1'),
(4, 'SEUIL_RUPTURE', '10'),
(5, 'DEVISE', 'F CFA'),
(6, 'HEURE_MAX_HEBDOMADAIRE', '37');

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

--
-- Structure de la table `payements`
--

CREATE TABLE `payements` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `nom` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL,
  `domaine` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `type_personnel` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `fonction` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `grade` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'PERSONNEL',
  `heure_total` decimal(11,2) DEFAULT 0.00,
  `heure_sup` decimal(11,2) DEFAULT 0.00,
  `created_by` int(11) DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `statut` int(1) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Déchargement des données de la table `payements`
--

INSERT INTO `payements` (`id`, `created_at`, `updated_at`, `nom`, `domaine`, `type_personnel`, `fonction`, `grade`, `heure_total`, `heure_sup`, `created_by`, `updated_by`, `statut`) VALUES
(1, '2023-02-02 19:14:58', '2023-02-28 19:14:58', 'KABO Elise', NULL, 'CONTRATUEL', 'SECRETAIRE', 'PERSONNEL', '31.00', '0.00', 1, NULL, 1),
(2, '2023-02-28 19:15:17', '2023-02-28 20:08:16', 'KABO Elise', NULL, 'CONTRATUEL', 'SECRETAIRE', 'PERSONNEL', '0.00', '1.00', 1, NULL, 0),
(3, '2023-02-28 19:15:18', '2023-02-28 20:14:43', 'KABO Elise', NULL, 'CONTRATUEL', 'SECRETAIRE', 'PERSONNEL', '0.00', '0.00', 1, NULL, 0),
(4, '2023-02-28 20:15:19', '2023-02-28 20:15:19', 'KINI Emile', NULL, 'INTERIMAIRE', 'TECHNICIEN RESEAU', 'PERSONNEL', '37.00', '0.00', 1, NULL, 1),
(5, '2023-02-28 20:15:25', '2023-02-28 20:15:25', 'KINI Emile', NULL, 'INTERIMAIRE', 'TECHNICIEN RESEAU', 'PERSONNEL', '0.00', '19.00', 1, NULL, 1),
(6, '2023-02-28 20:16:08', '2023-02-28 20:39:59', 'KINI Emile', NULL, 'INTERIMAIRE', 'TECHNICIEN RESEAU', 'PERSONNEL', '0.00', '0.00', 1, NULL, 0),
(7, '2023-02-28 20:34:30', '2023-02-28 20:39:51', 'KINI Emile', NULL, 'INTERIMAIRE', 'TECHNICIEN RESEAU', 'PERSONNEL', '37.00', '0.00', 1, NULL, 0),
(8, '2023-02-28 20:34:55', '2023-02-28 20:39:42', 'KINI Emile', NULL, 'INTERIMAIRE', 'TECHNICIEN RESEAU', 'PERSONNEL', '0.00', '110.50', 1, NULL, 0);

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

--
-- Structure de la table `personnels`
--

CREATE TABLE `personnels` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `nom` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL,
  `prenom` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL,
  `date_naissance` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `genre` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL,
  `telephone` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `adresse` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `domaine` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `type_personnel` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `type_contrat` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `superieur` int(11) NOT NULL,
  `fonction` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL,
  `specialite` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL,
  `mutuelle` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `grade` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'PERSONNEL',
  `heure_lun` decimal(11,2) DEFAULT 0.00,
  `heure_mar` decimal(11,2) DEFAULT 0.00,
  `heure_mer` decimal(11,2) DEFAULT 0.00,
  `heure_jeu` decimal(11,2) DEFAULT 0.00,
  `heure_ven` decimal(11,2) DEFAULT 0.00,
  `heure_sam` decimal(11,2) DEFAULT 0.00,
  `heure_dim` decimal(11,2) DEFAULT 0.00,
  `heure_total` decimal(11,2) DEFAULT 0.00,
  `heure_sup` decimal(11,2) DEFAULT 0.00,
  `justification_lun` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `justification_mar` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `justification_mer` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `justification_jeu` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `justification_ven` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `justification_sam` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `justification_dim` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `date_prise_service` date DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `statut` int(1) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Déchargement des données de la table `personnels`
--

INSERT INTO `personnels` (`id`, `created_at`, `updated_at`, `nom`, `prenom`, `date_naissance`, `genre`, `telephone`, `email`, `adresse`, `domaine`, `type_personnel`, `type_contrat`, `superieur`, `fonction`, `specialite`, `mutuelle`, `grade`, `heure_lun`, `heure_mar`, `heure_mer`, `heure_jeu`, `heure_ven`, `heure_sam`, `heure_dim`, `heure_total`, `heure_sup`, `justification_lun`, `justification_mar`, `justification_mer`, `justification_jeu`, `justification_ven`, `justification_sam`, `justification_dim`, `date_prise_service`, `created_by`, `updated_by`, `statut`) VALUES
(1, '2023-02-12 08:51:42', '2023-02-13 13:21:23', 'PATRON', 'LE BOSS', '1961-02-27', '24', '90 12 06 73', 'contact@rea.tg', 'Résidence', 'Administration', 'CONTRATUEL', 'CDI', 1, 'RESPONSABLE SSI', 'Administration', 'INAM', 'RESPONSABLE EXECUTION', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-02-12', 1, 0, 1),
(2, '2023-02-13 12:47:35', '2023-02-13 13:14:16', 'KALI', 'Brigitte', '1990-03-16', '24', '+22870349710', 'contact@bblome.tg', 'Lomé, quartier Agoè-cacavéli', 'Informatique', 'CONTRATUEL', 'CDI', 1, 'ADMIN SYSTEME', 'Cybersécurité', 'INAM', 'CHEF CHANTIER', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2023-01-30', 0, 0, 1),
(3, '2023-02-13 14:04:27', '2023-02-28 19:20:55', 'KABO', 'Elise', '1978-09-18', 'FEMININ', '+228 91 76 29 03', 'kabo@rea.tg', 'Adamavo, Lomé', 'Administration', 'CONTRATUEL', 'CDD', 1, 'SECRETAIRE', 'Sécrétaire', 'WAGES', 'PERSONNEL', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2023-01-30', 0, 0, 0),
(4, '2023-02-13 14:08:51', '2023-02-28 23:15:49', 'KINI', 'Emile', '1997-02-19', 'MASCULIN', '+22891762903', 'kabo@rea.tg', 'Amadahome, Lomé', 'Informatique', 'INTERIMAIRE', 'CDI', 2, 'TECHNICIEN RESEAU', 'Réseau-télécam', 'UMECTO', 'PERSONNEL', '0.00', '8.00', '0.00', '0.00', '0.00', '0.00', '0.00', '8.00', '0.00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2023-01-31', 0, 0, 1),
(5, '2023-02-13 14:10:49', '2023-02-13 14:10:49', 'HAKLO', 'Abigael', '1989-01-31', 'FEMININ', '+22898623901', 'rayalougba@rea.tg', 'Baguida plantation', 'Informatique', 'CONTRATUEL', 'CDD', 3, 'DEVELOPPEUR MOBILE', 'Développement mobile', 'WAGES', 'CHEF CHANTIER', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2023-01-31', 0, 0, 1),
(6, '2023-02-13 14:10:50', '2023-02-13 14:12:08', 'ATTISSO', 'Remi', '1989-01-31', 'MASCULIN', '+22898623901', 'rayalougba@rea.tg', 'Baguida plantation', 'Informatique', 'CONTRATUEL', 'CDD', 2, 'DEVELOPPEUR MOBILE', 'Développement mobile', 'WAGES', 'CHEF EQUIPE', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2023-01-31', 0, 0, 1),
(7, '2023-02-13 14:10:51', '2023-02-13 14:13:09', 'MOZOU', 'Rebecca', '1989-01-31', 'FEMININ', '+22898623901', 'rayalougba@rea.tg', 'Baguida plantation', 'Informatique', 'CONTRATUEL', 'CDD', 3, 'TECHNICIEN SYSTEME', 'Développement mobile', 'CNSS', 'GESTIONNAIRE CHANTIER', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2023-01-31', 0, 0, 1),
(8, '2023-02-13 14:10:52', '2023-02-13 14:13:53', 'ALI', 'Abdoul', '1989-01-31', 'MASCULIN', '+22898623901', 'rayalougba@rea.tg', 'Baguida plantation', 'Informatique', 'CONTRATUEL', 'CDD', 2, 'RESPONSABLE COMMUNICATION', 'Développement mobile', 'FUCEC', 'CHEF EQUIPE', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2023-01-31', 0, 0, 1),
(9, NULL, '2023-02-28 23:46:48', 'KPADENOU', 'Luc', '1993-02-10', 'MASCULIN', '+228 90 12 06 73', 'Kpade@gmail.com', 'Avepozo', 'Cloud', 'CONTRATUEL', 'CDI', 2, 'ADMIN SYSTEME', 'Cloud computing', 'INAM', 'PERSONNEL', '0.00', '3.00', '0.00', '0.00', '0.00', '0.00', '0.00', '3.00', '0.00', NULL, 'ABSENCE MALADIE', NULL, NULL, NULL, NULL, NULL, '2022-03-10', NULL, 1, 1);

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

--
-- Structure de la table `pointages`
--

CREATE TABLE `pointages` (
  `id` int(11) NOT NULL,
  `personnel` int(11) NOT NULL,
  `chef` int(11) NOT NULL,
  `date` date NOT NULL,
  `nombre_heure` int(11) DEFAULT 0,
  `nombre_minute` int(11) DEFAULT 0,
  `justification` varchar(250) DEFAULT NULL,
  `solder` int(1) NOT NULL DEFAULT 0,
  `created_by` int(11) NOT NULL,
  `updated_by` int(11) NOT NULL,
  `created_at` date NOT NULL,
  `updated_at` date NOT NULL,
  `statut` int(1) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Déchargement des données de la table `pointages`
--

INSERT INTO `pointages` (`id`, `personnel`, `chef`, `date`, `nombre_heure`, `nombre_minute`, `justification`, `solder`, `created_by`, `updated_by`, `created_at`, `updated_at`, `statut`) VALUES
(1, 2, 2, '2023-02-12', 7, 30, NULL, 0, 0, 0, '2023-02-12', '2023-02-12', 0),
(2, 1, 2, '2023-02-13', 45, 30, NULL, 0, 0, 0, '2023-02-12', '2023-02-13', 1),
(3, 3, 2, '2023-02-13', 26, NULL, NULL, 0, 0, 0, '2023-02-13', '2023-02-13', 1),
(4, 3, 2, '2023-02-15', 5, 30, NULL, 0, 0, 0, '2023-02-15', '2023-02-15', 1),
(5, 9, 3, '2023-02-16', 49, NULL, NULL, 0, 3, 3, '2023-02-16', '2023-02-16', 1),
(6, 3, 3, '2023-02-16', 28, NULL, NULL, 0, 3, 3, '2023-02-16', '2023-02-16', 1),
(7, 3, 1, '2023-02-23', 41, NULL, NULL, 0, 3, 1, '2023-02-16', '2023-02-23', 1),
(8, 4, 1, '2023-02-23', 40, NULL, NULL, 0, 4, 1, '2023-02-19', '2023-02-23', 1),
(9, 4, 1, '2023-02-23', 42, NULL, NULL, 0, 4, 1, '2023-02-19', '2023-02-23', 1),
(10, 4, 1, '2023-02-28', 7, NULL, NULL, 0, 1, 1, '2023-02-28', '2023-02-28', 1),
(11, 4, 1, '2023-02-28', 7, 30, NULL, 0, 1, 1, '2023-02-28', '2023-02-28', 1),
(12, 4, 1, '2023-02-28', 140, NULL, NULL, 0, 1, 1, '2023-02-28', '2023-02-28', 1),
(13, 9, 1, '2023-02-28', 1, NULL, NULL, 0, 1, 1, '2023-02-28', '2023-02-28', 1),
(14, 9, 1, '2023-02-28', 1, NULL, NULL, 0, 1, 1, '2023-02-28', '2023-02-28', 1),
(15, 4, 1, '2023-02-28', 1, NULL, NULL, 0, 1, 1, '2023-02-28', '2023-02-28', 1),
(16, 4, 1, '2023-02-28', 5, NULL, NULL, 0, 1, 1, '2023-02-28', '2023-02-28', 1),
(17, 9, 1, '2023-02-28', NULL, 30, NULL, 0, 1, 1, '2023-02-28', '2023-02-28', 1),
(18, 4, 1, '2023-02-28', NULL, NULL, 'VACANCE', 0, 1, 1, '2023-02-28', '2023-02-28', 1),
(19, 9, 1, '2023-02-28', NULL, 30, NULL, 0, 1, 1, '2023-02-28', '2023-02-28', 1),
(20, 4, 1, '2023-02-28', NULL, NULL, NULL, 0, 1, 1, '2023-02-28', '2023-02-28', 1),
(21, 4, 1, '2023-02-28', NULL, NULL, NULL, 0, 1, 1, '2023-02-28', '2023-02-28', 1),
(22, 4, 1, '2023-02-28', 1, NULL, NULL, 0, 1, 1, '2023-02-28', '2023-02-28', 1),
(23, 4, 1, '2023-02-28', NULL, NULL, NULL, 0, 1, 1, '2023-02-28', '2023-02-28', 1),
(24, 9, 1, '2023-02-28', NULL, NULL, NULL, 0, 1, 1, '2023-02-28', '2023-02-28', 1),
(25, 4, 1, '2023-02-28', NULL, NULL, NULL, 0, 1, 1, '2023-02-28', '2023-02-28', 1),
(26, 4, 1, '2023-02-28', NULL, NULL, NULL, 0, 1, 1, '2023-02-28', '2023-02-28', 1),
(27, 4, 1, '2023-02-28', NULL, NULL, NULL, 0, 1, 1, '2023-02-28', '2023-02-28', 1),
(28, 4, 1, '2023-02-28', 1, NULL, NULL, 0, 1, 1, '2023-02-28', '2023-02-28', 1),
(29, 9, 1, '2023-02-28', NULL, NULL, 'VACANCE', 0, 1, 1, '2023-02-28', '2023-02-28', 1),
(30, 9, 1, '2023-02-28', NULL, NULL, 'ABSENCE MALADIE', 0, 1, 1, '2023-02-28', '2023-02-28', 1),
(31, 9, 1, '2023-02-28', NULL, NULL, 'ABSENCE MALADIE', 0, 1, 1, '2023-02-28', '2023-02-28', 1);

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

--
-- Structure de la table `prets`
--

CREATE TABLE `prets` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `code_pret` varchar(30) COLLATE utf8mb4_unicode_ci NOT NULL,
  `autorite` int(11) NOT NULL,
  `acquerant` int(11) NOT NULL,
  `materiel` int(11) NOT NULL,
  `quantite_louer` decimal(14,2) NOT NULL,
  `description` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `date_pret` date NOT NULL,
  `date_prevue_restitution` date NOT NULL,
  `quantite_restituer` decimal(14,2) DEFAULT 0.00,
  `date_restitution` date DEFAULT NULL,
  `restitution` int(1) DEFAULT 0,
  `created_by` int(11) NOT NULL,
  `updated_by` int(11) NOT NULL,
  `statut` int(1) NOT NULL DEFAULT 1,
  `created_at` date DEFAULT NULL,
  `updated_at` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Déchargement des données de la table `prets`
--

INSERT INTO `prets` (`id`, `code_pret`, `autorite`, `acquerant`, `materiel`, `quantite_louer`, `description`, `date_pret`, `date_prevue_restitution`, `quantite_restituer`, `date_restitution`, `restitution`, `created_by`, `updated_by`, `statut`, `created_at`, `updated_at`) VALUES
(1, 'CHT/2023/02/10/1', 3, 1, 6, '5.00', 'Echelle en Aluminium dépliable de 10m', '2023-02-10', '2023-02-17', '0.00', NULL, 0, 0, 0, 0, '2023-02-10', '2023-02-10'),
(2, 'CHT/2023/02/10/1', 3, 1, 6, '6.00', 'Echelle en Aluminium dépliable de 10m', '2023-02-10', '2023-02-17', '0.00', NULL, NULL, 0, 0, 0, '2023-02-10', '2023-02-10'),
(3, 'LCT/2023/02/10/2', 3, 1, 8, '0.00', 'Location de perceuse', '2023-02-10', '2023-02-17', '0.00', NULL, NULL, 0, 0, 0, '2023-02-10', '2023-02-22'),
(4, 'LCT/2023/02/10/2', 3, 1, 8, '5.00', 'Location de perceuse', '2023-02-10', '2023-02-17', '0.00', NULL, 0, 0, 0, 1, '2023-02-10', '2023-02-10'),
(5, 'LCT/2023/02/11/1', 2, 1, 14, '13.00', 'Location de rallonges', '2023-02-11', '2023-02-12', '0.00', NULL, NULL, 0, 3, 0, '2023-02-11', '2023-02-22'),
(6, 'LCT/2023/02/11/1', 3, 1, 14, '1.00', NULL, '2023-02-11', '2023-02-11', '0.00', NULL, 0, 0, 0, 0, '2023-02-11', '2023-02-11'),
(7, 'LCT/2023/02/11/1', 3, 1, 14, '2.00', NULL, '2023-02-11', '2023-02-13', '0.00', NULL, 0, 0, 0, 0, '2023-02-11', '2023-02-11'),
(8, 'LCT/2023/02/11/1', 2, 2, 14, '2.00', 'Location pour Brigite', '2023-02-11', '2023-02-13', '1.00', NULL, NULL, 0, 4, 1, '2023-02-11', '2023-02-18'),
(9, 'PRT/2023/02/22/1', 1, 1, 13, '2.00', 'pret 400k', '2023-02-17', '2023-02-21', '0.00', NULL, 0, 1, 1, 1, '2023-02-22', '2023-02-22'),
(10, 'PRT/2023/02/22/2', 1, 3, 9, '1.00', 'Switch CISCO modulable', '2023-02-01', '2023-02-23', '0.00', NULL, NULL, 1, 1, 1, '2023-02-22', '2023-02-22');

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

--
-- Structure de la table `service_clients`
--

CREATE TABLE `service_clients` (
  `id` int(11) NOT NULL,
  `client` int(11) NOT NULL,
  `service` varchar(250) NOT NULL,
  `date_debut` date NOT NULL,
  `date_fin` date DEFAULT NULL,
  `cout` decimal(14,2) NOT NULL,
  `type_payement` varchar(50) NOT NULL,
  `etat_payement` varchar(50) NOT NULL,
  `date_payement` date DEFAULT NULL,
  `created_by` int(11) NOT NULL,
  `created_at` date NOT NULL,
  `updated_by` int(11) NOT NULL,
  `updated_at` date NOT NULL,
  `statut` int(1) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Déchargement des données de la table `service_clients`
--

INSERT INTO `service_clients` (`id`, `client`, `service`, `date_debut`, `date_fin`, `cout`, `type_payement`, `etat_payement`, `date_payement`, `created_by`, `created_at`, `updated_by`, `updated_at`, `statut`) VALUES
(1, 2, 'Audit de SI', '2023-02-09', '2023-02-10', '110000.00', 'AVANCE', 'EN ATTENTE', '2023-02-19', 4, '2023-02-20', 1, '2023-02-25', 1),
(2, 3, 'Audit de SI', '2023-02-02', '2023-02-04', '11.00', 'CASH', 'EN ATTENTE', '2023-03-10', 1, '2023-02-20', 1, '2023-02-20', 0);

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

--
-- Structure de la table `type_utilitaires`
--

CREATE TABLE `type_utilitaires` (
  `id` int(11) NOT NULL,
  `nom` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Déchargement des données de la table `type_utilitaires`
--

INSERT INTO `type_utilitaires` (`id`, `nom`) VALUES
(9, 'ETAT_FINITION'),
(1, 'FONCTION'),
(3, 'GENRE'),
(2, 'GRADE'),
(6, 'MUTUELLE'),
(7, 'ROLE'),
(12, 'TYPE_COLLABORATEUR'),
(5, 'TYPE_CONTRAT'),
(10, 'TYPE_CONTRAVENTION'),
(11, 'TYPE_OUI_NON'),
(8, 'TYPE_PAYEMENT'),
(4, 'TYPE_PERSONNEL');

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

--
-- Structure de la table `utilitaires`
--

CREATE TABLE `utilitaires` (
  `id` int(11) NOT NULL,
  `type` varchar(100) NOT NULL,
  `nom` varchar(250) NOT NULL,
  `description` varchar(250) DEFAULT NULL,
  `created_by` int(11) NOT NULL,
  `updated_by` int(11) NOT NULL,
  `created_at` date NOT NULL,
  `updated_at` date NOT NULL,
  `statut` int(1) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Déchargement des données de la table `utilitaires`
--

INSERT INTO `utilitaires` (`id`, `type`, `nom`, `description`, `created_by`, `updated_by`, `created_at`, `updated_at`, `statut`) VALUES
(4, 'MUTUELLE', 'AUCUN', 'AUCUNE MUTUELLE', 0, 0, '2023-02-13', '2023-02-13', 1),
(5, 'MUTUELLE', 'AUTRE', NULL, 0, 0, '2023-02-13', '2023-02-13', 1),
(6, 'MUTUELLE', 'NSIA', NULL, 0, 0, '2023-02-13', '2023-02-13', 1),
(7, 'MUTUELLE', 'SALAM', NULL, 0, 0, '2023-02-13', '2023-02-13', 1),
(8, 'MUTUELLE', 'CNSS', NULL, 0, 0, '2023-02-13', '2023-02-13', 1),
(9, 'MUTUELLE', 'INAM', NULL, 0, 0, '2023-02-13', '2023-02-13', 1),
(10, 'MUTUELLE', 'COCEC', NULL, 0, 0, '2023-02-13', '2023-02-13', 1),
(11, 'MUTUELLE', 'UMECTO', NULL, 0, 0, '2023-02-13', '2023-02-13', 1),
(12, 'MUTUELLE', 'WAGES', NULL, 0, 0, '2023-02-13', '2023-02-13', 1),
(13, 'MUTUELLE', 'FUCEC', NULL, 0, 0, '2023-02-13', '2023-02-13', 1),
(14, 'GRADE', 'PERSONNEL', NULL, 0, 0, '2023-02-13', '2023-02-13', 1),
(15, 'GRADE', 'CHEF EQUIPE', NULL, 0, 0, '2023-02-13', '2023-02-13', 1),
(16, 'GRADE', 'CHEF CHANTIER', NULL, 0, 0, '2023-02-13', '2023-02-13', 1),
(17, 'GRADE', 'GESTIONNAIRE CHANTIER', NULL, 0, 0, '2023-02-13', '2023-02-18', 0),
(18, 'GRADE', 'RESPONSABLE EXECUTION', NULL, 0, 0, '2023-02-13', '2023-02-13', 1),
(19, 'GRADE', 'AUTRE', NULL, 0, 0, '2023-02-13', '2023-02-13', 0),
(20, 'TYPE_CONTRAT', 'CDD', NULL, 0, 0, '2023-02-13', '2023-02-13', 1),
(21, 'TYPE_CONTRAT', 'CDI', NULL, 0, 0, '2023-02-13', '2023-02-13', 1),
(22, 'TYPE_PERSONNEL', 'INTERIMAIRE', NULL, 0, 0, '2023-02-13', '2023-02-13', 1),
(23, 'TYPE_PERSONNEL', 'CONTRATUEL', NULL, 0, 0, '2023-02-13', '2023-02-13', 1),
(24, 'GENRE', 'MASCULIN', NULL, 0, 0, '2023-02-13', '2023-02-13', 1),
(25, 'GENRE', 'FEMININ', NULL, 0, 0, '2023-02-13', '2023-02-13', 1),
(26, 'GENRE', 'AUTRE', NULL, 0, 0, '2023-02-13', '2023-02-13', 1),
(27, 'FONCTION', 'ADMIN SYSTEME', NULL, 0, 0, '2023-02-13', '2023-02-13', 1),
(28, 'FONCTION', 'ADMIN RESEAU', NULL, 0, 0, '2023-02-13', '2023-02-13', 1),
(29, 'FONCTION', 'TECHNICIEN SYSTEME', NULL, 0, 0, '2023-02-13', '2023-02-13', 1),
(30, 'FONCTION', 'TECHNICIEN RESEAU', NULL, 0, 0, '2023-02-13', '2023-02-13', 1),
(31, 'FONCTION', 'PROGRAMMEUR', NULL, 0, 0, '2023-02-13', '2023-02-13', 1),
(32, 'FONCTION', 'DEVELOPPEUR WEB', NULL, 0, 0, '2023-02-13', '2023-02-13', 1),
(33, 'FONCTION', 'DEVELOPPEUR MOBILE', NULL, 0, 0, '2023-02-13', '2023-02-13', 1),
(34, 'FONCTION', 'DEVELOPPEUR FULLSTACK', NULL, 0, 0, '2023-02-13', '2023-02-13', 1),
(35, 'FONCTION', 'DEVELOPPEUR DESKTOP', 'Déceloppeur Desktop', 0, 0, '2023-02-13', '2023-02-13', 1),
(36, 'FONCTION', 'TECHNICIEN SSI', 'Technicien chargé de la sécurité du SI', 0, 0, '2023-02-13', '2023-02-13', 1),
(37, 'FONCTION', 'CÂBLEUR', 'Câbleur réseau', 0, 0, '2023-02-13', '2023-02-13', 1),
(38, 'FONCTION', 'ELECTRICIEN', 'Electricien', 0, 0, '2023-02-13', '2023-02-13', 1),
(39, 'FONCTION', 'SECRETAIRE', 'Sécrétaire', 0, 0, '2023-02-13', '2023-02-13', 1),
(40, 'FONCTION', 'RESPONSABLE COMMUNICATION', 'Responsable de la communication', 0, 0, '2023-02-13', '2023-02-13', 1),
(41, 'FONCTION', 'RESPONSABLE SSI', 'Responsable de la sécurité du système d\'information', 0, 0, '2023-02-13', '2023-02-13', 1),
(42, 'FONCTION', 'ADMIN BD', 'ADNIN BD', 0, 0, '2023-02-15', '2023-02-15', 1),
(43, 'GRADE', 'BOSS', 'Le Directeur Général (DG)', 2, 1, '2023-02-18', '2023-02-18', 1),
(44, 'ROLE', 'BOSS', 'Le Directeur Général (DG)', 1, 1, '2023-02-18', '2023-02-18', 1),
(45, 'ROLE', 'RESPONSABLE EXECUTION', 'Responsable d\'exécution', 1, 1, '2023-02-18', '2023-02-18', 1),
(46, 'ROLE', 'COMPTABLE', 'Comptable', 1, 1, '2023-02-18', '2023-02-18', 1),
(47, 'ROLE', 'GESTIONNAIRE CHANTIER', 'GESTIONNAIRE DE CHANTIER', 1, 1, '2023-02-18', '2023-02-18', 0),
(48, 'ROLE', 'CHEF CHANTIER', 'CHEF CHANTIER', 1, 1, '2023-02-18', '2023-02-18', 1),
(49, 'ROLE', 'CHEF EQUIPE', 'CHEF D\'EQUIPE', 1, 1, '2023-02-18', '2023-02-18', 1),
(50, 'ROLE', 'PERSONNEL', 'Personnel ouvrier ou administratif', 1, 1, '2023-02-18', '2023-02-18', 1),
(51, 'ROLE', 'SERVICE TECHNIQUE', 'Service technique', 4, 4, '2023-02-19', '2023-02-19', 1),
(52, 'TYPE_PAYEMENT', 'CASH', 'En totalité, instantanément', 4, 4, '2023-02-20', '2023-02-20', 1),
(53, 'TYPE_PAYEMENT', 'AVANCE', 'En plusieurs partie', 4, 4, '2023-02-20', '2023-02-20', 1),
(54, 'ETAT_FINITION', 'EN ATTENTE', 'En attente de traitement', 4, 4, '2023-02-20', '2023-02-20', 1),
(55, 'ETAT_FINITION', 'PARTIEL', 'Traité partiellement', 4, 4, '2023-02-20', '2023-02-20', 1),
(56, 'ETAT_FINITION', 'TERMINER', 'Traitement entièrement effectué', 4, 4, '2023-02-20', '2023-02-20', 1),
(57, 'TYPE_CONTRAVENTION', 'EXCES DE VITESSE', 'EXCES DE VITESSE', 4, 4, '2023-02-20', '2023-02-20', 1),
(58, 'TYPE_OUI_NON', 'OUI', 'OUI', 1, 1, '2023-02-22', '2023-02-22', 1),
(59, 'TYPE_OUI_NON', 'NON', 'NON', 1, 1, '2023-02-22', '2023-02-22', 1),
(60, 'TYPE_COLLABORATEUR', 'LOCATAIRE', 'LOCATAIRE', 1, 1, '2023-02-22', '2023-02-22', 1),
(61, 'TYPE_COLLABORATEUR', 'PROPRIETAIRE', 'PROPRIETAIRE', 1, 1, '2023-02-22', '2023-02-22', 1);

--
-- Index pour les tables déchargées
--

--
-- Index pour la table `accidents`
--
ALTER TABLE `accidents`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `approvisionnements`
--
ALTER TABLE `approvisionnements`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `chantiers`
--
ALTER TABLE `chantiers`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `clients`
--
ALTER TABLE `clients`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `collaborateurs`
--
ALTER TABLE `collaborateurs`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `commandes`
--
ALTER TABLE `commandes`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `commande_materiau`
--
ALTER TABLE `commande_materiau`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `contraventions`
--
ALTER TABLE `contraventions`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `emprunts`
--
ALTER TABLE `emprunts`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `failed_jobs`
--
ALTER TABLE `failed_jobs`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`);

--
-- Index pour la table `fournisseurs`
--
ALTER TABLE `fournisseurs`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `locations`
--
ALTER TABLE `locations`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `materiaus`
--
ALTER TABLE `materiaus`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `migrations`
--
ALTER TABLE `migrations`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `outils`
--
ALTER TABLE `outils`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `parametres`
--
ALTER TABLE `parametres`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `payements`
--
ALTER TABLE `payements`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `personnels`
--
ALTER TABLE `personnels`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `pointages`
--
ALTER TABLE `pointages`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `prets`
--
ALTER TABLE `prets`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `service_clients`
--
ALTER TABLE `service_clients`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `type_utilitaires`
--
ALTER TABLE `type_utilitaires`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `nom` (`nom`);

--
-- Index pour la table `utilitaires`
--
ALTER TABLE `utilitaires`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT pour les tables déchargées
--

--
-- AUTO_INCREMENT pour la table `accidents`
--
ALTER TABLE `accidents`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT pour la table `approvisionnements`
--
ALTER TABLE `approvisionnements`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT pour la table `chantiers`
--
ALTER TABLE `chantiers`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT pour la table `clients`
--
ALTER TABLE `clients`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT pour la table `collaborateurs`
--
ALTER TABLE `collaborateurs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT pour la table `commandes`
--
ALTER TABLE `commandes`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT pour la table `contraventions`
--
ALTER TABLE `contraventions`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT pour la table `emprunts`
--
ALTER TABLE `emprunts`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT pour la table `failed_jobs`
--
ALTER TABLE `failed_jobs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `fournisseurs`
--
ALTER TABLE `fournisseurs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT pour la table `locations`
--
ALTER TABLE `locations`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT pour la table `materiaus`
--
ALTER TABLE `materiaus`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=18;

--
-- AUTO_INCREMENT pour la table `migrations`
--
ALTER TABLE `migrations`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;

--
-- AUTO_INCREMENT pour la table `outils`
--
ALTER TABLE `outils`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;

--
-- AUTO_INCREMENT pour la table `parametres`
--
ALTER TABLE `parametres`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT pour la table `payements`
--
ALTER TABLE `payements`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT pour la table `personnels`
--
ALTER TABLE `personnels`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- AUTO_INCREMENT pour la table `pointages`
--
ALTER TABLE `pointages`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=32;

--
-- AUTO_INCREMENT pour la table `prets`
--
ALTER TABLE `prets`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;

--
-- AUTO_INCREMENT pour la table `service_clients`
--
ALTER TABLE `service_clients`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT pour la table `type_utilitaires`
--
ALTER TABLE `type_utilitaires`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;

--
-- AUTO_INCREMENT pour la table `utilitaires`
--
ALTER TABLE `utilitaires`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=62;
COMMIT;

