-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Hôte : localhost:3306
-- Généré le : lun. 25 nov. 2024 à 09:41
-- Version du serveur : 8.0.40-cll-lve
-- Version de PHP : 8.3.13

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 : `sallecfq_db_agraf_final`
--

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

--
-- Structure de la table `articlechantier_matiere_fournisseur`
--

CREATE TABLE `articlechantier_matiere_fournisseur` (
  `id` bigint UNSIGNED NOT NULL,
  `article_chantier_id` bigint UNSIGNED NOT NULL,
  `num_bon` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `matierepremiere_id` bigint UNSIGNED NOT NULL,
  `fournisseur_id` bigint UNSIGNED NOT NULL,
  `qte` double NOT NULL,
  `prix` double NOT NULL,
  `unite` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `articlechantier_matiere_fournisseur` (`id`, `article_chantier_id`, `num_bon`, `matierepremiere_id`, `fournisseur_id`, `qte`, `prix`, `unite`, `created_at`, `updated_at`) VALUES
(1, 1, '1234', 1, 7, 10, 100, 'kg', '2024-05-04 11:56:16', '2024-05-04 11:56:16'),
(2, 4, '2121s', 1, 7, 11, 11, '11', '2024-05-05 11:37:42', '2024-05-05 11:37:42'),
(4, 4, '122', 1, 7, 100, 1000, 'kg', '2024-05-05 11:38:34', '2024-05-05 11:38:34'),
(5, 4, '122', 2, 7, 100, 1000, 'sac', '2024-05-05 11:39:00', '2024-05-05 11:39:00'),
(8, 10, '1236', 5, 6, 10, 120, 'kg', '2024-05-06 10:34:58', '2024-05-06 10:34:58'),
(7, 1, '5675', 1, 6, 20, 100, 'fayage', '2024-05-06 10:22:47', '2024-05-06 10:22:47'),
(10, 10, '1245', 2, 7, 20, 100, 'sac', '2024-05-06 10:35:54', '2024-05-06 10:35:54'),
(12, 10, '124', 4, 6, 10, 200, 'tonne', '2024-05-06 10:36:32', '2024-05-06 10:36:32'),
(13, 12, '4589', 1, 8, 10, 160, 'kg', '2024-05-06 10:37:43', '2024-05-06 10:37:43'),
(14, 13, '357', 2, 12, 100, 100, 'sac', '2024-05-06 11:01:41', '2024-05-06 11:01:41'),
(15, 14, '122', 1, 8, 10, 100, 'kg', '2024-05-06 11:02:29', '2024-05-06 11:02:29'),
(16, 14, '123', 3, 13, 10, 200, 'kg', '2024-05-06 11:03:07', '2024-05-06 11:03:07'),
(18, 15, '5689', 1, 11, 5, 100, 'kg', '2024-05-06 11:05:30', '2024-05-06 11:05:30'),
(19, 15, '1245', 4, 7, 5, 120, 'kg', '2024-05-06 11:06:12', '2024-05-06 11:06:12'),
(20, 16, '4567', 1, 7, 100, 200, 'kg', '2024-05-06 20:53:04', '2024-05-06 20:53:04'),
(21, 1, '3456', 1, 7, 12, 200, 'tonne', '2024-05-24 18:30:14', '2024-05-24 18:30:14'),
(22, 15, '1257', 5, 7, 10, 90, 'kg', '2024-05-25 09:29:44', '2024-05-25 09:29:44'),
(24, 16, '876', 2, 8, 10, 100, 'Sac', '2024-05-27 18:00:38', '2024-05-27 18:00:38'),
(26, 16, '5678', 5, 13, 100, 150, 'Kg', '2024-05-27 18:01:24', '2024-05-27 18:01:24'),
(29, 22, '345', 1, 7, 13, 100, 'kg', '2024-06-06 04:21:05', '2024-06-06 04:21:05'),
(30, 22, '123', 3, 7, 10, 100, 'fayage', '2024-06-06 04:24:09', '2024-06-06 04:24:09');

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

--
-- Structure de la table `articles`
--

CREATE TABLE `articles` (
  `id` bigint UNSIGNED NOT NULL,
  `designation` varchar(300) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `ref` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `unites` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `articles` (`id`, `designation`, `ref`, `unites`, `created_at`, `updated_at`) VALUES
(7, 'Fondation Sous-Sol :\r\nFouille en puits ou en rigole y/c évacuation ou mise en remblai, Béton de propreté, Maçonnerie de moellons, Béton armé en fondation y/c aciers, Blocage en pierre sèche, Forme de 0,10 en béton légèrement armé + Fourniture et pose de buses de Ø200 internes et regards internes.', '01/001', 'M2', '2024-04-02 22:05:19', '2024-06-06 21:11:06'),
(8, 'Dalles Sous Sol en m2 couvert:\r\nBéton armé en élévation y/c aciers, Cloison en agglos ou en briques, Enduit lisse au ciment, Dalle hourdis et pose de faux cadres.', '02/001', 'M2', '2024-04-02 22:06:47', '2024-04-02 22:06:47'),
(9, 'Dalles Rez de chaussée en m2 couvert:\r\nBéton armé en élévation y/c aciers, Cloison en agglos ou en briques, Enduit lisse au ciment, Dalle hourdis et pose de faux cadres.', '03/001', 'M2', '2024-04-02 22:07:20', '2024-04-02 22:07:20'),
(10, 'Dalles ETAGE en m2 couvert:\r\nBéton armé en élévation y/c aciers, Cloison en agglos ou en briques, Enduit lisse au ciment, Dalle hourdis et pose de faux cadres.', '04/001', 'M2', '2024-04-02 22:07:49', '2024-04-02 22:07:49'),
(11, 'Cage des escaliers en m2 couvert:\r\nBéton armé en élévation y/c aciers, Cloison en agglos ou en briques, Enduit lisse au ciment, Dalle hourdis et pose de faux cadres.', '05/001', 'M2', '2024-04-02 22:08:18', '2024-04-02 22:08:18'),
(12, 'Construction de murs en agglos de 20cm.', '10/001', 'M2', '2024-04-02 22:08:46', '2024-04-02 22:08:46'),
(13, 'Enduit lisse en ciment.', '10/002', 'M2', '2024-04-02 22:09:19', '2024-04-02 22:09:19'),
(14, 'Construction de chaînage et poteaux en BA y/c aciers', '10/003', 'ML', '2024-04-02 22:09:58', '2024-04-02 22:09:58'),
(15, 'Peinture vinylique sur murs', '20/001', 'M2', '2024-04-02 22:10:25', '2024-04-02 22:10:25'),
(16, 'Réparation de carreaux anti acide sur sol y/c grattage et évacuation à la DP.', '40/001', 'M2', '2024-04-17 10:08:34', '2024-04-17 10:08:34'),
(17, 'Pose de grillage récupéré sur porte entre MMP et Salle de soufflage.', '10/004', 'FT', '2024-04-17 10:08:59', '2024-04-17 10:08:59'),
(18, 'Confection de porte grillagé pour entré du MMP.', '10/005', 'FT', '2024-04-17 10:09:28', '2024-04-17 10:09:28'),
(19, 'Réparation et mise enmarche des deux portes sectionnelle pour l\'entré du MPF.', '40/002', 'FT', '2024-04-17 10:09:52', '2024-04-17 10:09:52'),
(22, 'Réparation de porte sectionnelle du magasin sucre y/c fourniture de pièces endommagées.', '40/003', 'FT', '2024-05-05 10:21:58', '2024-05-05 10:21:58');

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

--
-- Structure de la table `article_chantier`
--

CREATE TABLE `article_chantier` (
  `id` bigint UNSIGNED NOT NULL,
  `article_id` bigint UNSIGNED NOT NULL,
  `chantier_id` bigint UNSIGNED NOT NULL,
  `prix_estime` double NOT NULL DEFAULT '0',
  `tva` double NOT NULL DEFAULT '20',
  `qte` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `article_chantier` (`id`, `article_id`, `chantier_id`, `prix_estime`, `tva`, `qte`, `created_at`, `updated_at`) VALUES
(1, 7, 1, 30000, 20, '0', NULL, '2024-06-06 21:06:34'),
(10, 8, 1, 30000, 20, '0', NULL, '2024-05-06 11:53:38'),
(13, 10, 1, 5000, 20, '0', NULL, '2024-05-06 11:56:44'),
(4, 7, 2, 200, 20, '0', NULL, '2024-06-06 03:53:50'),
(5, 8, 2, 1000, 20, '0', NULL, '2024-06-06 03:54:30'),
(12, 9, 1, 10500, 20, '0', NULL, '2024-05-06 11:54:44'),
(14, 11, 1, 20000, 20, '0', NULL, '2024-05-06 11:54:19'),
(15, 12, 1, 30000, 20, '0', NULL, '2024-06-06 04:02:28'),
(16, 7, 3, 1000, 20, '0', NULL, '2024-05-06 20:52:27'),
(17, 8, 3, 2000, 20, '0', NULL, '2024-05-06 20:52:02'),
(18, 9, 3, 4500, 20, '0', NULL, '2024-05-06 20:52:11'),
(19, 11, 3, 1000, 20, '0', NULL, '2024-06-06 03:55:56'),
(22, 12, 3, 1000, 20, '0', NULL, '2024-06-06 04:21:36'),
(25, 10, 3, 0, 20, '0', NULL, NULL),
(27, 7, 5, 0, 20, '0', NULL, NULL),
(28, 11, 5, 0, 20, '0', NULL, NULL),
(29, 14, 1, 0, 20, '0', NULL, NULL),
(30, 11, 7, 0, 20, '0', NULL, NULL),
(31, 9, 7, 0, 20, '0', NULL, NULL),
(32, 22, 1, 0, 20, '0', NULL, NULL);

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

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

CREATE TABLE `chantiers` (
  `id` bigint UNSIGNED NOT NULL,
  `nom` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `localisation` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `nom_client` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `date_debut` date NOT NULL,
  `date_estimee` date DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `chantiers` (`id`, `nom`, `localisation`, `nom_client`, `date_debut`, `date_estimee`, `created_at`, `updated_at`) VALUES
(1, 'R+2', 'route mouzzaar', 'Ahmed beiassa', '2024-04-28', '2024-05-05', '2024-05-04 11:37:00', '2024-05-25 09:08:20'),
(2, 'R+3', 'saada', 'amina', '2024-02-04', '2024-05-03', '2024-05-04 11:39:37', '2024-05-05 11:23:24'),
(3, 'appartement', 'ain chekaf', 'saida', '2024-05-04', '2024-09-28', '2024-05-04 12:09:45', '2024-08-01 09:53:45'),
(5, 'route sefrou', 'route sefrou', 'lehssen', '2024-09-09', NULL, '2024-09-02 17:52:04', '2024-09-02 17:52:04'),
(6, 'mustapha LG elouazzani', 'SAADA', 'ziyad', '2024-09-26', '2024-09-29', '2024-09-26 09:31:50', '2024-09-26 09:31:50'),
(7, 'villa najah', 'SAADA', 'ziyad', '2024-11-14', '2024-12-06', '2024-11-14 10:33:19', '2024-11-14 10:33:19');

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

--
-- Structure de la table `detail_article_chantier`
--

CREATE TABLE `detail_article_chantier` (
  `id` bigint UNSIGNED NOT NULL,
  `article_chantier_id` bigint UNSIGNED NOT NULL,
  `designation` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `qte` double NOT NULL,
  `prix` double NOT NULL,
  `tva` double NOT NULL DEFAULT '20',
  `unites` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `detail_article_chantier` (`id`, `article_chantier_id`, `designation`, `qte`, `prix`, `tva`, `unites`, `created_at`, `updated_at`) VALUES
(1, 2, 'Béton armé en élévation y/c aciers', 80, 100, 1, 'm2', '2024-05-04 11:47:59', '2024-05-04 11:47:59'),
(2, 3, 'detail 3', 20, 100, 1, 'm2', '2024-05-04 11:51:13', '2024-05-04 11:51:13'),
(3, 3, 'detail 4', 2, 50, 1, 'm2', '2024-05-04 11:51:30', '2024-05-04 11:51:30'),
(5, 1, 'maconnerie de moellons en fondation/', 3, 250, 1, 'm3', '2024-05-06 09:22:45', '2024-05-06 09:22:45'),
(6, 1, 'Béton armé pour Chaînage, Voile, Poteaux et \nescaliers/', 9, 2200, 1, 'm3', '2024-05-06 09:26:34', '2024-05-06 09:26:34'),
(7, 13, 'Enduit lisse en ciment/', 10, 100, 1, 'm2', '2024-05-06 11:55:56', '2024-05-06 11:55:56');

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

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

CREATE TABLE `failed_jobs` (
  `id` bigint UNSIGNED NOT NULL,
  `uuid` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `connection` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `queue` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `exception` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

CREATE TABLE `fournisseurs` (
  `id` bigint UNSIGNED NOT NULL,
  `reseau_social` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `nom_contact` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `telephone` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `adresse` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `fournisseurs` (`id`, `reseau_social`, `nom_contact`, `email`, `telephone`, `adresse`, `created_at`, `updated_at`) VALUES
(7, 'ZALAGH PLANCHE', 'zakaria', 'zakaria@gmail.com', '+21261234577', 'atlass', '2024-04-02 22:35:06', '2024-06-06 21:11:30'),
(6, 'ZAKI FER', 'kaoutar ahaggach', 'kaoutarahggach@gmail.com', '+212612345654', 'Atlass', '2024-04-02 22:34:39', '2024-04-02 22:34:39'),
(8, 'SOFABEME', 'Ilyass', 'Ilyass@gmail.com', '+212612345656', 'tanger', '2024-04-02 22:35:34', '2024-04-14 21:51:48'),
(11, 'COFIA', 'COFIA', 'cofia@gmail.com', '+212618923', 'Narjiss', '2024-04-14 21:19:08', '2024-04-14 21:19:08'),
(12, 'SAMSAC', 'SAMSAC', 'samsac@gmail.com', '+2125768977', 'Narjis', '2024-04-14 21:19:47', '2024-06-06 21:12:29'),
(13, 'SONAJIB', 'SONAJIB', 'sonajib@gmail.com', '+212976543265', 'Narjiss', '2024-04-14 21:20:50', '2024-04-14 21:21:09');

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

--
-- Structure de la table `matierespremieres`
--

CREATE TABLE `matierespremieres` (
  `id` bigint UNSIGNED NOT NULL,
  `designation` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `matierespremieres` (`id`, `designation`, `created_at`, `updated_at`) VALUES
(1, 'fer n 12', '2024-03-30 11:35:09', '2024-04-02 22:42:29'),
(2, 'ciment', '2024-03-30 11:35:15', '2024-03-30 11:35:15'),
(3, 'Sable', '2024-04-02 22:38:51', '2024-04-02 22:38:51'),
(4, 'fer n 6', '2024-04-02 22:41:06', '2024-04-02 22:41:06'),
(5, 'pointe n 6', '2024-04-02 22:43:01', '2024-04-02 22:43:01'),
(7, 'matiertest', '2024-05-25 10:50:56', '2024-05-25 10:50:56'),
(8, 'sable g taille 44', '2024-11-14 10:31:45', '2024-11-14 10:31:45');

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

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

CREATE TABLE `migrations` (
  `id` int UNSIGNED NOT NULL,
  `migration` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int NOT NULL
) ENGINE=MyISAM 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_100000_create_password_reset_tokens_table', 1),
(2, '2019_08_19_000000_create_failed_jobs_table', 1),
(3, '2019_12_14_000001_create_personal_access_tokens_table', 1),
(4, '2024_03_12_212356_create_matierespremieres_table', 1),
(5, '2024_03_13_144236_create_articles_table', 1),
(6, '2024_03_13_171206_create_ouvriers_table', 1),
(7, '2024_03_23_204111_create_ouvrier_chantier_table', 1),
(8, '2024_03_31_101057_create_articlechantier_matiere_fournisseur_table', 1),
(9, '2024_04_06_111814_create_mode_reglement_table', 1),
(10, '2024_04_06_111824_create_reglement_table', 1),
(11, '2024_04_08_111814_create_users_table', 1),
(12, '2024_04_08_212303_create_fournisseurs_table', 1),
(13, '2024_04_12_154159_create_chantiers_table', 1),
(14, '2024_04_26_221527_create_detail_article_chantier_table', 1),
(15, '2024_04_30_153745_create_article_chantier_table', 1);

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

--
-- Structure de la table `mode_reglement`
--

CREATE TABLE `mode_reglement` (
  `id` bigint UNSIGNED NOT NULL,
  `mode` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `mode_reglement` (`id`, `mode`, `created_at`, `updated_at`) VALUES
(1, 'espèce', '2024-04-09 13:41:09', '2024-05-05 10:37:35'),
(5, 'chèque', '2024-05-05 10:36:42', '2024-05-05 10:37:44'),
(3, 'carte bancaire', '2024-04-09 13:41:27', '2024-05-05 10:34:58'),
(4, 'le paiement mobile', '2024-05-05 10:32:51', '2024-05-05 10:32:51');

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

--
-- Structure de la table `ouvriers`
--

CREATE TABLE `ouvriers` (
  `id` bigint UNSIGNED NOT NULL,
  `nom` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `prenom` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `statut` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `salaire_journalier` double NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `ouvriers` (`id`, `nom`, `prenom`, `statut`, `salaire_journalier`, `created_at`, `updated_at`) VALUES
(12, 'AIT YAHYA', 'MOHAMED', 'Ouvriér', 100, '2024-05-05 10:29:33', '2024-05-05 10:29:33'),
(3, 'EL-AMRANI', 'MOUNIM', 'ouvriér', 100, '2024-04-02 22:46:22', '2024-04-02 22:47:17'),
(5, 'AGRAF', 'HICHAM', 'cadre', 200, '2024-04-02 22:47:46', '2024-04-02 22:47:46'),
(6, 'AGRAF', 'MOHAMED', 'cadre', 200, '2024-04-02 22:48:16', '2024-04-02 22:48:16'),
(7, 'AGRA', 'MY EL HASSAN', 'cadre', 200, '2024-04-02 22:48:46', '2024-04-02 22:48:46'),
(8, 'ABDAOUI', 'MOHAMED', 'chef', 150, '2024-04-02 22:49:45', '2024-04-02 23:25:08'),
(9, 'abdeaziz', 'abde el aziz', 'ouvrier', 90, '2024-04-03 23:08:47', '2024-04-17 10:13:18'),
(10, 'JAMAAI', 'MOHAMED', 'ouvrier', 90, '2024-04-10 20:19:16', '2024-04-17 10:14:18'),
(11, 'ahaggach', 'kaoutar', 'cadre', 100, '2024-05-05 10:24:51', '2024-05-05 10:24:51');

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

--
-- Structure de la table `ouvrier_chantier`
--

CREATE TABLE `ouvrier_chantier` (
  `id` bigint UNSIGNED NOT NULL,
  `chantier_id` bigint UNSIGNED NOT NULL,
  `ouvrier_id` bigint UNSIGNED NOT NULL,
  `date_debut` date NOT NULL,
  `date_fin` date NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `ouvrier_chantier` (`id`, `chantier_id`, `ouvrier_id`, `date_debut`, `date_fin`, `created_at`, `updated_at`) VALUES
(1, 2, 4, '2024-05-04', '2024-05-06', '2024-05-04 12:02:24', '2024-05-04 12:02:24'),
(2, 2, 4, '2024-05-04', '2024-05-06', '2024-05-04 12:02:35', '2024-05-04 12:02:35'),
(3, 2, 4, '2024-05-04', '2024-05-06', '2024-05-04 12:03:08', '2024-05-04 12:03:08'),
(4, 2, 4, '2024-05-04', '2024-05-06', '2024-05-04 12:03:31', '2024-05-04 12:03:31'),
(5, 2, 4, '2024-05-04', '2024-05-06', '2024-05-04 12:06:33', '2024-05-04 12:06:33'),
(6, 2, 4, '2024-05-04', '2024-05-06', '2024-05-04 12:07:09', '2024-05-04 12:07:09'),
(9, 1, 4, '2024-05-04', '2024-05-05', '2024-05-04 12:09:08', '2024-05-04 12:09:08'),
(8, 2, 9, '2024-05-01', '2024-06-08', '2024-05-04 12:08:25', '2024-05-04 12:08:25'),
(10, 1, 12, '2024-05-06', '2024-05-23', '2024-05-06 09:55:13', '2024-05-06 09:55:13'),
(11, 1, 3, '2024-05-06', '2024-05-08', '2024-05-06 10:19:31', '2024-05-06 10:19:31'),
(12, 1, 6, '2024-05-06', '2024-05-08', '2024-05-06 11:00:38', '2024-05-06 11:00:38'),
(13, 1, 9, '2024-05-10', '2024-05-16', '2024-05-06 11:00:55', '2024-05-06 11:00:55'),
(14, 3, 12, '2024-05-25', '2024-05-28', '2024-05-25 09:16:29', '2024-05-25 09:16:29'),
(15, 2, 8, '2024-06-05', '2024-06-08', '2024-06-06 03:54:59', '2024-06-06 03:54:59'),
(16, 1, 11, '2024-06-06', '2024-06-25', '2024-06-06 06:40:03', '2024-06-06 06:40:03'),
(17, 2, 6, '2024-09-25', '2024-10-05', '2024-10-02 13:55:16', '2024-10-02 13:55:16'),
(18, 2, 11, '2024-09-24', '2024-09-28', '2024-10-02 13:55:44', '2024-10-02 13:55:44'),
(19, 7, 12, '2024-11-14', '2024-11-21', '2024-11-14 10:33:52', '2024-11-14 10:33:52');

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

--
-- Structure de la table `password_reset_tokens`
--

CREATE TABLE `password_reset_tokens` (
  `email` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `token` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `password_reset_tokens` (`email`, `token`, `created_at`) VALUES
('kaoutarahggach@gmail.com', 'S0zCmi8yldRp5TkVXpgspCr5RxGvVaa6OsDjcSQUrbxb75p2JyLRkGJNR3gd', '2024-07-18 21:33:36');

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

--
-- Structure de la table `personal_access_tokens`
--

CREATE TABLE `personal_access_tokens` (
  `id` bigint UNSIGNED NOT NULL,
  `tokenable_type` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `tokenable_id` bigint UNSIGNED NOT NULL,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `token` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `abilities` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `last_used_at` timestamp NULL DEFAULT NULL,
  `expires_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Structure de la table `reglement`
--

CREATE TABLE `reglement` (
  `id` bigint UNSIGNED NOT NULL,
  `date` date NOT NULL,
  `montant` double NOT NULL,
  `fournisseur_id` bigint UNSIGNED NOT NULL,
  `chantier_id` bigint UNSIGNED NOT NULL,
  `mode_id` bigint UNSIGNED NOT NULL,
  `num_cheque` double NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `reglement` (`id`, `date`, `montant`, `fournisseur_id`, `chantier_id`, `mode_id`, `num_cheque`, `created_at`, `updated_at`) VALUES
(1, '2024-05-04', 100, 7, 1, 1, 0, '2024-05-04 11:57:45', '2024-05-04 11:57:45'),
(2, '2024-05-04', 1000, 6, 1, 5, 1234567, '2024-05-06 12:54:10', '2024-05-06 12:54:10'),
(3, '2024-05-06', 4200, 6, 1, 4, 0, '2024-05-06 13:21:45', '2024-05-06 13:21:45'),
(4, '2024-06-06', 6800, 7, 1, 5, 98765, '2024-06-06 06:40:50', '2024-06-06 06:40:50');

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

--
-- Structure de la table `users`
--

CREATE TABLE `users` (
  `id` bigint UNSIGNED NOT NULL,
  `nom` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `prenom` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `password` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `photo` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `is_admin` tinyint(1) NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `users` (`id`, `nom`, `prenom`, `email`, `password`, `photo`, `is_admin`, `created_at`, `updated_at`) VALUES
(1, 'ahaggach', 'kaoutar', 'kaoutarahggach@gmail.com', '$2y$12$aZfU.z7vzCCYA8UxswvkMu0MwF2SBHZOMS2I6uoWepTqLTkX5oaa.', '1.jpg', 1, '2024-04-09 13:23:58', '2024-07-18 21:04:29'),
(2, 'agraf', 'rachid', 'rachid@gmail.com', '$2y$12$aZfU.z7vzCCYA8UxswvkMu0MwF2SBHZOMS2I6uoWepTqLTkX5oaa.', '2.png', 1, '2024-04-09 13:23:58', '2024-06-06 14:59:16'),
(3, 'agraf', 'hicham', 'hicham@gmail.com', '$2y$12$5IEniddxADzuN5WUsY/FKOpUh9bEahvKVop6rCmmDAFfT82GUcNFm', '3.png', 0, '2024-04-09 13:23:58', '2024-06-06 15:00:27'),
(9, 'Admin', 'Admin', 'admin@gmail.com', '$2y$12$aZfU.z7vzCCYA8UxswvkMu0MwF2SBHZOMS2I6uoWepTqLTkX5oaa.', '9.jpg', 1, '2024-05-26 18:30:55', '2024-05-26 18:30:55');

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

--
-- Index pour la table `articlechantier_matiere_fournisseur`
--
ALTER TABLE `articlechantier_matiere_fournisseur`
  ADD PRIMARY KEY (`id`),
  ADD KEY `articlechantier_matiere_fournisseur_article_chantier_id_foreign` (`article_chantier_id`),
  ADD KEY `articlechantier_matiere_fournisseur_matierepremiere_id_foreign` (`matierepremiere_id`),
  ADD KEY `articlechantier_matiere_fournisseur_fournisseur_id_foreign` (`fournisseur_id`);

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

--
-- Index pour la table `article_chantier`
--
ALTER TABLE `article_chantier`
  ADD PRIMARY KEY (`id`),
  ADD KEY `article_chantier_article_id_foreign` (`article_id`),
  ADD KEY `article_chantier_chantier_id_foreign` (`chantier_id`);

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

--
-- Index pour la table `detail_article_chantier`
--
ALTER TABLE `detail_article_chantier`
  ADD PRIMARY KEY (`id`),
  ADD KEY `detail_article_chantier_article_chantier_id_foreign` (`article_chantier_id`);

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

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

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

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

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

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

--
-- Index pour la table `ouvrier_chantier`
--
ALTER TABLE `ouvrier_chantier`
  ADD PRIMARY KEY (`id`),
  ADD KEY `ouvrier_chantier_chantier_id_foreign` (`chantier_id`),
  ADD KEY `ouvrier_chantier_ouvrier_id_foreign` (`ouvrier_id`);

--
-- Index pour la table `personal_access_tokens`
--
ALTER TABLE `personal_access_tokens`
  ADD PRIMARY KEY (`id`),
  ADD KEY `64` (`tokenable_type`,`tokenable_id`);

--
-- Index pour la table `reglement`
--
ALTER TABLE `reglement`
  ADD PRIMARY KEY (`id`),
  ADD KEY `reglement_fournisseur_id_foreign` (`fournisseur_id`),
  ADD KEY `reglement_chantier_id_foreign` (`chantier_id`),
  ADD KEY `reglement_mode_id_foreign` (`mode_id`);

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

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

--
-- AUTO_INCREMENT pour la table `articlechantier_matiere_fournisseur`
--
ALTER TABLE `articlechantier_matiere_fournisseur`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=31;

--
-- AUTO_INCREMENT pour la table `articles`
--
ALTER TABLE `articles`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=24;

--
-- AUTO_INCREMENT pour la table `article_chantier`
--
ALTER TABLE `article_chantier`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=33;

--
-- AUTO_INCREMENT pour la table `chantiers`
--
ALTER TABLE `chantiers`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT pour la table `detail_article_chantier`
--
ALTER TABLE `detail_article_chantier`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

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

--
-- AUTO_INCREMENT pour la table `fournisseurs`
--
ALTER TABLE `fournisseurs`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16;

--
-- AUTO_INCREMENT pour la table `matierespremieres`
--
ALTER TABLE `matierespremieres`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT pour la table `migrations`
--
ALTER TABLE `migrations`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16;

--
-- AUTO_INCREMENT pour la table `mode_reglement`
--
ALTER TABLE `mode_reglement`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT pour la table `ouvriers`
--
ALTER TABLE `ouvriers`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;

--
-- AUTO_INCREMENT pour la table `ouvrier_chantier`
--
ALTER TABLE `ouvrier_chantier`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=20;

--
-- AUTO_INCREMENT pour la table `personal_access_tokens`
--
ALTER TABLE `personal_access_tokens`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `reglement`
--
ALTER TABLE `reglement`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT pour la table `users`
--
ALTER TABLE `users`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;
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 */;