-- phpMyAdmin SQL Dump
-- version 5.0.1
-- https://www.phpmyadmin.net/
--
-- Hôte : 127.0.0.1
-- Généré le : mar. 12 août 2025 à 04:00
-- Version du serveur :  10.4.11-MariaDB
-- Version de PHP : 7.2.28

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
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 : `bdalertetest`
--

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

--
-- Structure de la table `alertes`
--

CREATE TABLE `alertes` (
  `id` int(11) NOT NULL,
  `contenualerte` tinytext COLLATE utf8_unicode_ci DEFAULT NULL,
  `datealerte` date DEFAULT NULL,
  `gpsalerte` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `nomagent` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `matricule` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `fonction` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `contact` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `directionregionale_id` int(11) DEFAULT NULL,
  `zone_id` int(11) DEFAULT NULL,
  `statut` tinyint(1) DEFAULT NULL,
  `observation` tinytext COLLATE utf8_unicode_ci DEFAULT NULL,
  `datecalerte` date NOT NULL,
  `objetalerte_id` int(11) DEFAULT NULL,
  `autreobjet` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `annee` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `statutvalide` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `statutautorise` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `photoalerte` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `emaillanceur` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `statutlanceur` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

INSERT INTO `alertes` (`id`, `contenualerte`, `datealerte`, `gpsalerte`, `nomagent`, `matricule`, `fonction`, `contact`, `directionregionale_id`, `zone_id`, `statut`, `observation`, `datecalerte`, `objetalerte_id`, `autreobjet`, `annee`, `statutvalide`, `statutautorise`, `photoalerte`, `emaillanceur`, `statutlanceur`) VALUES
(83, '0000', '2025-05-08', NULL, 'VITO JC', NULL, 'AD', '0707000000', 4, 58, NULL, 'ACCORD', '2025-05-28', 3, NULL, '2025', 'Autorisé', NULL, '28052025193208.jpeg', NULL, NULL),
(84, '3333', '2025-05-28', NULL, 'VITO JC', NULL, 'AD', '0707000000', 4, 31, NULL, NULL, '2025-05-28', 8, 'CANADA', '2025', 'Recevable', NULL, '28052025203753.jpeg', NULL, NULL),
(85, 'MATIN', '2025-05-29', NULL, 'VITO JC 10', NULL, 'AD 100', '0707000001', 11, 59, NULL, NULL, '2025-05-30', 2, NULL, '2025', 'Recevable', NULL, NULL, NULL, NULL),
(86, 'C BON', '2025-08-11', NULL, 'VITO JC 100000', '1000Q', 'AD 100000', '0707000000', 11, 58, 1, NULL, '2025-08-11', 3, NULL, '2025', NULL, NULL, NULL, 'rmockey@yahoo', 'OUI'),
(87, 'SUITE', '2025-08-09', NULL, 'VITO JC 100000', '1000Q', 'AD 100000', '0707000000', 1, 25, 1, NULL, '2025-08-11', 2, NULL, '2025', NULL, NULL, NULL, 'rmockey@', 'OUI'),
(88, 'SUITE 2', '2025-08-09', NULL, 'VITO JC 100000', '1000Q', 'AD 100000', '0707000000', 1, 25, 1, NULL, '2025-08-11', 2, NULL, '2025', NULL, NULL, NULL, 'rmockey@', 'OUI'),
(89, 'SUITE 3', '2025-08-09', NULL, 'VITO JC 100000', '1000Q', 'AD 100000', '0707000000', 1, 25, 1, NULL, '2025-08-11', 2, NULL, '2025', NULL, NULL, NULL, NULL, 'OUI'),
(90, 'SUITE 3', '2025-08-09', NULL, 'VITO JC 100000', '1000Q', 'AD 100000', '0707000000', 1, 25, 1, NULL, '2025-08-11', 2, NULL, '2025', NULL, NULL, NULL, 'rmockey@yahoo', 'OUI'),
(91, 'csdcvdxw', '2025-08-04', NULL, 'VITO JC 100000', '1000Q', 'AD 100000', '0707000000', 4, 28, 1, NULL, '2025-08-11', 1, NULL, '2025', NULL, NULL, NULL, 'rmockey@yahoo', 'NON'),
(92, 'csdcvdxw', '2025-08-04', NULL, 'VITO JC 100000', '1000Q', 'AD 100000', '0707000000', 4, 28, 1, NULL, '2025-08-11', 1, NULL, '2025', NULL, NULL, NULL, 'rmockey@yahoo', 'NON'),
(93, 'dfd', '2025-07-31', NULL, 'VITO JC 100000', '1000Q', 'AD 100000', '0707000000', 1, 25, 1, NULL, '2025-08-11', 4, NULL, '2025', NULL, NULL, NULL, 'rmockey@yahoo', 'OUI'),
(94, 'dvds', '2025-08-05', NULL, 'VITO JC 100000', NULL, 'AD 100000', '0707000000', 1, 25, 1, 'A TOI DGA', '2025-08-11', 3, NULL, '2025', 'Recevable', NULL, NULL, 'rmockey@yaho.fr', 'OUI'),
(95, 'QQQ', '2025-07-29', NULL, 'QQQQQQQQSSSSSSSSSSSS', '0000000000000000000', 'SWW', '0707000000', 7, 56, 1, NULL, '2025-08-12', 8, 'SHERBROOKE', '2025', NULL, NULL, NULL, 'michelinegohouo@gmail.com', 'NON');

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

--
-- Index pour la table `alertes`
--
ALTER TABLE `alertes`
  ADD PRIMARY KEY (`id`),
  ADD KEY `IDX_DD01B8CC2BC623C1` (`directionregionale_id`),
  ADD KEY `IDX_DD01B8CC9F2C3FAB` (`zone_id`),
  ADD KEY `IDX_DD01B8CCB38B047B` (`objetalerte_id`);

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

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

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

--
-- Contraintes pour la table `alertes`
--
ALTER TABLE `alertes`
  ADD CONSTRAINT `FK_DD01B8CC2BC623C1` FOREIGN KEY (`directionregionale_id`) REFERENCES `direction_regionale` (`id`),
  ADD CONSTRAINT `FK_DD01B8CC9F2C3FAB` FOREIGN KEY (`zone_id`) REFERENCES `zone` (`id`),
  ADD CONSTRAINT `FK_DD01B8CCB38B047B` FOREIGN KEY (`objetalerte_id`) REFERENCES `objet_alerte` (`id`);
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 */;
