-- phpMyAdmin SQL Dump -- version 5.1.1 -- https://www.phpmyadmin.net/ -- -- Hôte : 127.0.0.1 -- Généré le : sam. 25 fév. 2023 à 21:13 -- Version du serveur : 10.4.22-MariaDB -- Version de PHP : 8.1.2 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 */; -- -- 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 NOT NULL, `adresse` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL, `categorie` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL, `observation` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL 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`, `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', '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', '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', 'Lomé, Agoè Kossigan', 'Entreprise', 'Un très bon client', 0, 1, '2023-02-10 21:53:21', '2023-02-25 17:47:22', 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 NOT NULL, `adresse` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL, `categorie` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL, `observation` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL 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`, `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', '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', '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 & FILS', 'Fournisseur d\'outils et de matériau de construction (quincaillerie)', '+22870349710', 'contact@eli.com', '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', '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', 'Baguida plantation', 'Quincaillerie', 'Assez-bien', 3, 1, '2023-02-17 19:38:30', '2023-02-25 17:46:45', 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'); -- -------------------------------------------------------- -- -- Structure de la table `password_resets` -- CREATE TABLE `password_resets` ( `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `token` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Déchargement des données de la table `password_resets` -- INSERT INTO `password_resets` (`email`, `token`, `created_at`) VALUES ('admin@softui.com', '$2y$10$Vvp9deoMxcEayvPSqWfZuufQyv3Rg0rgYeRR.7P68T1vD.IwnkPde', '2023-02-07 06:38:16'); -- -------------------------------------------------------- -- -- Structure de la table `personal_access_tokens` -- CREATE TABLE `personal_access_tokens` ( `id` bigint(20) UNSIGNED NOT NULL, `tokenable_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `tokenable_id` bigint(20) UNSIGNED NOT NULL, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `token` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL, `abilities` text COLLATE utf8mb4_unicode_ci DEFAULT NULL, `last_used_at` timestamp NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- 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, `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`, `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', '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', '2023-01-30', 0, 0, 1), (3, '2023-02-13 14:04:27', '2023-02-23 01:31:25', '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', '31.00', '0.00', '0.00', '0.00', '31.00', '1.00', '2023-01-30', 0, 0, 1), (4, '2023-02-13 14:08:51', '2023-02-23 01:31:05', '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', '0.00', '0.00', '43.00', '0.00', '0.00', '0.00', '43.00', '6.00', '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', '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', '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', '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', '2023-01-31', 0, 0, 1), (9, NULL, '2023-02-25 20:10:36', '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', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '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, `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`, `solder`, `created_by`, `updated_by`, `created_at`, `updated_at`, `statut`) VALUES (1, 2, 2, '2023-02-12', 7, 30, 0, 0, 0, '2023-02-12', '2023-02-12', 0), (2, 1, 2, '2023-02-13', 45, 30, 0, 0, 0, '2023-02-12', '2023-02-13', 1), (3, 3, 2, '2023-02-13', 26, NULL, 0, 0, 0, '2023-02-13', '2023-02-13', 1), (4, 3, 2, '2023-02-15', 5, 30, 0, 0, 0, '2023-02-15', '2023-02-15', 1), (5, 9, 3, '2023-02-16', 49, NULL, 0, 3, 3, '2023-02-16', '2023-02-16', 1), (6, 3, 3, '2023-02-16', 28, NULL, 0, 3, 3, '2023-02-16', '2023-02-16', 1), (7, 3, 1, '2023-02-23', 41, NULL, 0, 3, 1, '2023-02-16', '2023-02-23', 1), (8, 4, 1, '2023-02-23', 40, NULL, 0, 4, 1, '2023-02-19', '2023-02-23', 1), (9, 4, 1, '2023-02-23', 42, NULL, 0, 4, 1, '2023-02-19', '2023-02-23', 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 `users` -- CREATE TABLE `users` ( `id` bigint(20) UNSIGNED NOT NULL, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `password` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `phone` bigint(20) DEFAULT NULL, `location` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `about_me` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `role` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'PERSONNEL', `remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `first_connect` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'OUI', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL 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 `users` -- INSERT INTO `users` (`id`, `name`, `email`, `password`, `phone`, `location`, `about_me`, `role`, `remember_token`, `first_connect`, `created_at`, `updated_at`, `created_by`, `updated_by`, `statut`) VALUES (1, 'admin', 'admin@softui.com', '$2y$10$K7bsQ4KWIW7TA9hqfXxpB.E5uYttpmiqNefTbaWnVLVHQNOK7MBFC', NULL, NULL, NULL, 'BOSS', NULL, 'NON', '2023-02-06 06:07:21', '2023-02-22 18:38:08', 1, 1, 1), (2, 'Save WILSON', 'adjetewilson184@gmail.com', '$2y$10$cBHZUQDlxaXBnUJf19EIZ.0j/2HIpYkDsZtsarbjJLkbCNKmcStOy', 97087661, 'Lomé Adetikopé', 'Ingénieur en cybersécurité', 'RESPONSABLE EXECUTION', NULL, 'OUI', '2023-02-06 06:12:00', '2023-02-15 08:34:25', 1, 1, 1), (3, 'TCHASSIM Pascal', 'pascal@gmail.com', '$2y$10$EIniASk7XaMw3EiUSad1oeXStxobrYWP89w4spE63u.DUJeCjhHU6', 22891762903, 'Vakpossito', NULL, 'PERSONNEL', NULL, 'NON', '2023-02-15 15:49:55', '2023-02-24 10:03:10', 1, 1, 1), (4, 'Nathan WILSON', 'nathan@gmail.com', '$2y$10$5/jL.rEaFYC.XfekrsuY.uexYoHfy8k.qpNB4cfSnKiJwkaXOr3aq', 98206703, 'Segbe', NULL, 'COMPTABLE', NULL, 'NON', '2023-02-18 10:48:16', '2023-02-22 13:07:46', 1, 1, 1), (5, 'Patrice AMEZOU', 'patrice@gmail.com', '$2y$10$bzuZ.QnR38J3PyFd3H//Eu3dKjNM9ZexlAXXTJhj6TRXiMAG55OIa', 93678293, 'Adetikopé', NULL, 'SERVICE TECHNIQUE', NULL, 'NON', '2023-02-19 19:46:45', '2023-02-22 12:40:20', 4, 4, 1); -- -------------------------------------------------------- -- -- 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 `password_resets` -- ALTER TABLE `password_resets` ADD KEY `password_resets_email_index` (`email`); -- -- Index pour la table `personal_access_tokens` -- ALTER TABLE `personal_access_tokens` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `personal_access_tokens_token_unique` (`token`), ADD KEY `personal_access_tokens_tokenable_type_tokenable_id_index` (`tokenable_type`,`tokenable_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 `users` -- ALTER TABLE `users` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `users_email_unique` (`email`); -- -- 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=4; -- -- 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=6; -- -- 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=6; -- -- AUTO_INCREMENT pour la table `personal_access_tokens` -- ALTER TABLE `personal_access_tokens` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT pour la table `personnels` -- ALTER TABLE `personnels` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1000000007; -- -- AUTO_INCREMENT pour la table `pointages` -- ALTER TABLE `pointages` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10; -- -- 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 `users` -- ALTER TABLE `users` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6; -- -- AUTO_INCREMENT pour la table `utilitaires` -- ALTER TABLE `utilitaires` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=62; 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 */;