-- phpMyAdmin SQL Dump
-- version 5.1.1
-- https://www.phpmyadmin.net/
--
-- Hôte : 127.0.0.1
-- Généré le : ven. 11 mars 2022 à 11:34
-- 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 : `cartographie_jaugeage`
--

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

--
-- Structure de la table `info_jaugeage`
--

CREATE TABLE `info_jaugeage` (
  `Id` varchar(3) DEFAULT NULL,
  `Station` varchar(20) DEFAULT NULL,
  `Cours_d_eau` varchar(20) DEFAULT NULL,
  `Code_hydrologique` varchar(17) DEFAULT NULL,
  `Longitude` varchar(10) DEFAULT NULL,
  `Latitude` varchar(10) DEFAULT NULL,
  `Dernier_niveau` varchar(16) DEFAULT NULL,
  `Date_dernier_niveau` varchar(19) DEFAULT NULL,
  `Dernier_debit` varchar(16) DEFAULT NULL,
  `Date_dernier_debit` varchar(18) DEFAULT NULL,
  `Niveau_seuil_haut_important` varchar(27) DEFAULT NULL,
  `Niveau_seuil_haut_critique` varchar(26) DEFAULT NULL,
  `Niveau_seuil_bas_important` varchar(26) DEFAULT NULL,
  `Niveau_seuil_bas_critique` varchar(25) DEFAULT NULL,
  `Niveau_max_connu` varchar(16) DEFAULT NULL,
  `Debit_max_connu` varchar(15) DEFAULT NULL,
  `tension_seuil_bas_important` varchar(27) DEFAULT NULL,
  `Tension_seuil_bas_critique` varchar(26) DEFAULT NULL,
  `Delai_passage_critique` varchar(22) DEFAULT NULL,
  `Delai_passage_retard` varchar(20) DEFAULT NULL,
  `Delai_passage_normal` varchar(20) DEFAULT NULL,
  `Q2` varchar(2) DEFAULT NULL,
  `Q5` varchar(2) DEFAULT NULL,
  `Q10` varchar(3) DEFAULT NULL,
  `Niveau_min_connu` varchar(16) DEFAULT NULL,
  `Debit_min_connu` varchar(16) DEFAULT NULL,
  `dernier_passage` varchar(16) DEFAULT NULL,
  `Commentaires_dernier_passage` varchar(28) DEFAULT NULL,
  `dernier_jaugeage` varchar(16) DEFAULT NULL,
  `Derniere_tension` varchar(16) DEFAULT NULL,
  `Date_derniere_tension` varchar(21) DEFAULT NULL,
  `Tendance` varchar(8) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

INSERT INTO `info_jaugeage` (`Id`, `Station`, `Cours_d_eau`, `Code_hydrologique`, `Longitude`, `Latitude`, `Dernier_niveau`, `Date_dernier_niveau`, `Dernier_debit`, `Date_dernier_debit`, `Niveau_seuil_haut_important`, `Niveau_seuil_haut_critique`, `Niveau_seuil_bas_important`, `Niveau_seuil_bas_critique`, `Niveau_max_connu`, `Debit_max_connu`, `tension_seuil_bas_important`, `Tension_seuil_bas_critique`, `Delai_passage_critique`, `Delai_passage_retard`, `Delai_passage_normal`, `Q2`, `Q5`, `Q10`, `Niveau_min_connu`, `Debit_min_connu`, `dernier_passage`, `Commentaires_dernier_passage`, `dernier_jaugeage`, `Derniere_tension`, `Date_derniere_tension`, `Tendance`) VALUES
('1', 'Abbeville', 'Somme', 'E647091002', '1,8297673', '50,0945115', '0', '09/03/2022 08h30', '0', '09/03/2022 08h30', '', '', '', '', '', '', '12', '11,5', '40', '32', '24', '', '', '', '', '', '01/03/2022 08h30', 'bla bla', '', '', '01/03/2022 08h30', ''),
('2', 'Abbeville_scardon', 'Scardon', 'E648093401', '1,8270782', '50,114219', '0', '09/03/2022 08h30', '0', '09/03/2022 08h30', '', '', '', '', '', '', '12', '11,5', '40', '32', '24', '', '', '', '', '', '01/03/2022 08h30', 'bla bla', '', '', '01/03/2022 08h30', ''),
('3', 'AbbevilleMF', 'Somme', '80001001', '1,8332949', '50,1359402', '0', '09/03/2022 08h30', '0', '09/03/2022 08h30', '', '', '', '', '', '', '12', '11,5', '40', '32', '24', '', '', '', '', '', '01/03/2022 08h30', 'bla bla', '', '', '01/03/2022 08h30', ''),
('4', 'Aire_LysUS', 'Lys plaine', 'E361121001', '2,4351169', '50,6465537', '0', '09/03/2022 08h30', '0', '09/03/2022 08h30', '', '', '', '', '', '', '12', '11,5', '40', '32', '24', '', '', '', '', '', '01/03/2022 08h30', 'bla bla', '', '', '01/03/2022 08h30', ''),
('5', 'Airesurlalys-P', 'Lys plaine', '62014001', '2,4142911', '50,6459277', '0', '09/03/2022 08h30', '0', '09/03/2022 08h30', '', '', '', '', '', '', '12', '11,5', '40', '32', '24', '', '', '', '', '', '01/03/2022 08h30', 'bla bla', '', '', '01/03/2022 08h30', ''),
('6', 'Amblaincourt_GE', 'Aire', 'H610201001', '5,20845', '48,96411', '0', '09/03/2022 08h30', '0', '09/03/2022 08h30', '', '', '', '', '', '', '12', '11,5', '40', '32', '24', '', '', '', '', '', '01/03/2022 08h30', 'bla bla', '', '', '01/03/2022 08h30', ''),
('7', 'Ambleny', 'Ru du Retz', 'H652353201', '3,1886934', '49,3800656', '0', '09/03/2022 08h30', '0', '09/03/2022 08h30', '', '', '', '', '', '', '12', '11,5', '40', '32', '24', '', '', '', '', '', '01/03/2022 08h30', 'bla bla', '', '', '01/03/2022 08h30', ''),
('8', 'Arleux', 'Canal du Nord', 'E156371002', '3,10988', '50,2728319', '0', '09/03/2022 08h30', '0', '09/03/2022 08h30', '', '', '', '', '', '', '12', '11,5', '40', '32', '24', '', '', '', '', '', '01/03/2022 08h30', 'bla bla', '', '', '01/03/2022 08h30', ''),
('9', 'Arry', 'Maye', 'E649831501', '1,7250305', '50,2760087', '0', '09/03/2022 08h30', '0', '09/03/2022 08h30', '', '', '', '', '', '', '12', '11,5', '40', '32', '24', '', '', '', '', '', '01/03/2022 08h30', 'bla bla', '', '', '01/03/2022 08h30', ''),
('10', 'Asfeld_GE', 'Aisne vaux', 'H630101001', '4,12293', '49,48181', '0', '09/03/2022 08h30', '0', '09/03/2022 08h30', '', '', '', '', '', '', '12', '11,5', '40', '32', '24', '', '', '', '', '', '01/03/2022 08h30', 'bla bla', '', '', '01/03/2022 08h30', ''),
('11', 'Aulnoy', 'Rhonelle', 'E176601001', '3,5317071', '50,3299785', '0', '09/03/2022 08h30', '0', '09/03/2022 08h30', '', '', '', '', '', '', '12', '11,5', '40', '32', '24', '', '', '', '', '', '01/03/2022 08h30', 'bla bla', '', '', '01/03/2022 08h30', ''),
('12', 'Avesnes-P', 'Helpe majeure', '59035002', '3,927196', '50,1235502', '0', '09/03/2022 08h30', '0', '09/03/2022 08h30', '', '', '', '', '', '', '12', '11,5', '40', '32', '24', '', '', '', '', '', '01/03/2022 08h30', 'bla bla', '', '', '01/03/2022 08h30', ''),
('13', 'BainghenMF', 'Hem', '62076002', '1,9059621', '50,7507674', '0', '09/03/2022 08h30', '0', '09/03/2022 08h30', '', '', '', '', '', '', '12', '11,5', '40', '32', '24', '', '', '', '', '', '01/03/2022 08h30', 'bla bla', '', '', '01/03/2022 08h30', ''),
('14', 'Bambecque', 'Yser', 'E490571001', '2,5415063', '50,8990486', '0', '09/03/2022 08h30', '0', '09/03/2022 08h30', '', '', '', '', '', '', '12', '11,5', '40', '32', '24', '', '', '', '', '', '01/03/2022 08h30', 'bla bla', '', '', '01/03/2022 08h30', ''),
('15', 'Bavelincourt', 'Hallue', 'E639701001', '2,4581268', '49,9894778', '0', '09/03/2022 08h30', '0', '09/03/2022 08h30', '', '', '', '', '', '', '12', '11,5', '40', '32', '24', '', '', '', '', '', '01/03/2022 08h30', 'bla bla', '', '', '01/03/2022 08h30', ''),
('16', 'Beauvais', 'Th?rain', 'H774201001', '2,0839866', '49,4261201', '0', '09/03/2022 08h30', '0', '09/03/2022 08h30', '', '', '', '', '', '', '12', '11,5', '40', '32', '24', '', '', '', '', '', '01/03/2022 08h30', 'bla bla', '', '', '01/03/2022 08h30', ''),
('17', 'Berlaimont', 'Sambre', 'D016221001', '3,8173085', '50,2014656', '0', '09/03/2022 08h30', '0', '09/03/2022 08h30', '', '', '', '', '', '', '12', '11,5', '40', '32', '24', '', '', '', '', '', '01/03/2022 08h30', 'bla bla', '', '', '01/03/2022 08h30', ''),
('18', 'BernavilleMF', 'Somme', '80086002', '2,1798142', '50,1392725', '0', '09/03/2022 08h30', '0', '09/03/2022 08h30', '', '', '', '', '', '', '12', '11,5', '40', '32', '24', '', '', '', '', '', '01/03/2022 08h30', 'bla bla', '', '', '01/03/2022 08h30', ''),
('19', 'Berry au Bac BP', 'Aisne vaux', 'H632101101', '3,9004029', '49,4010505', '0', '09/03/2022 08h30', '0', '09/03/2022 08h30', '', '', '', '', '', '', '12', '11,5', '40', '32', '24', '', '', '', '', '', '01/03/2022 08h30', 'bla bla', '', '', '01/03/2022 08h30', ''),
('20', 'Berry au Bac RIGOLE', 'Aisne vaux', 'H632101203', '3,8986901', '49,3984025', '0', '09/03/2022 08h30', '0', '09/03/2022 08h30', '', '', '', '', '', '', '12', '11,5', '40', '32', '24', '', '', '', '', '', '01/03/2022 08h30', 'bla bla', '', '', '01/03/2022 08h30', ''),
('21', 'Bertinval_DRIEE', 'Ysieux', 'H224000501', '2,4158033', '49,1328717', '0', '09/03/2022 08h30', '0', '09/03/2022 08h30', '', '', '', '', '', '', '12', '11,5', '40', '32', '24', '', '', '', '', '', '01/03/2022 08h30', 'bla bla', '', '', '01/03/2022 08h30', ''),
('22', 'Bethune', 'Lawe', 'E366601001', '2,6368938', '50,5396537', '0', '09/03/2022 08h30', '0', '09/03/2022 08h30', '', '', '', '', '', '', '12', '11,5', '40', '32', '24', '', '', '', '', '', '01/03/2022 08h30', 'bla bla', '', '', '01/03/2022 08h30', ''),
('23', 'Beutin', 'Canche', 'E541000401', '1,7240162', '50,4901214', '0', '09/03/2022 08h30', '0', '09/03/2022 08h30', '', '', '', '', '', '', '12', '11,5', '40', '32', '24', '', '', '', '', '', '01/03/2022 08h30', 'bla bla', '', '', '01/03/2022 08h30', ''),
('24', 'Biermes_GE', 'Aisne ardennaise', 'H622102001', '4,39791', '49,49278', '0', '09/03/2022 08h30', '0', '09/03/2022 08h30', '', '', '', '', '', '', '12', '11,5', '40', '32', '24', '', '', '', '', '', '01/03/2022 08h30', 'bla bla', '', '', '01/03/2022 08h30', ''),
('25', 'BoismontCFUS', 'Somme', 'E649563001', '1,6878903', '50,1600723', '0', '09/03/2022 08h30', '0', '09/03/2022 08h30', '', '', '', '', '', '', '12', '11,5', '40', '32', '24', '', '', '', '', '', '01/03/2022 08h30', 'bla bla', '', '', '01/03/2022 08h30', ''),
('26', 'BoismontUS', 'Somme', 'E648093001', '1,6881841', '50,1606054', '0', '09/03/2022 08h30', '0', '09/03/2022 08h30', '', '', '', '', '', '', '12', '11,5', '40', '32', '24', '', '', '', '', '', '01/03/2022 08h30', 'bla bla', '', '', '01/03/2022 08h30', ''),
('27', 'Bollezeele', 'Yser', 'E490571101', '2,3485392', '50,8661368', '0', '09/03/2022 08h30', '0', '09/03/2022 08h30', '', '', '', '', '', '', '12', '11,5', '40', '32', '24', '', '', '', '', '', '01/03/2022 08h30', 'bla bla', '', '', '01/03/2022 08h30', ''),
('28', 'Bonnay', 'Ancre', 'E638607001', '2,5134743', '49,9360836', '0', '09/03/2022 08h30', '0', '09/03/2022 08h30', '', '', '', '', '', '', '12', '11,5', '40', '32', '24', '', '', '', '', '', '01/03/2022 08h30', 'bla bla', '', '', '01/03/2022 08h30', ''),
('29', 'Bonni?res', 'Th?rain', 'H770201001', '1,9649826', '49,5067858', '0', '09/03/2022 08h30', '0', '09/03/2022 08h30', '', '', '', '', '', '', '12', '11,5', '40', '32', '24', '', '', '', '', '', '01/03/2022 08h30', 'bla bla', '', '', '01/03/2022 08h30', ''),
('30', 'Bornel', 'Esches', 'H784301001', '2,2088994', '49,1976925', '0', '09/03/2022 08h30', '0', '09/03/2022 08h30', '', '', '', '', '', '', '12', '11,5', '40', '32', '24', '', '', '', '', '', '01/03/2022 08h30', 'bla bla', '', '', '01/03/2022 08h30', ''),
('31', 'Borre-P', 'Lys plaine', '59091001', '2,5760363', '50,7334053', '0', '09/03/2022 08h30', '0', '09/03/2022 08h30', '', '', '', '', '', '', '12', '11,5', '40', '32', '24', '', '', '', '', '', '01/03/2022 08h30', 'bla bla', '', '', '01/03/2022 08h30', ''),
('32', 'BoulogneMF', 'Liane', '62160001', '1,5989474', '50,7324379', '0', '09/03/2022 08h30', '0', '09/03/2022 08h30', '', '', '', '', '', '', '12', '11,5', '40', '32', '24', '', '', '', '', '', '01/03/2022 08h30', 'bla bla', '', '', '01/03/2022 08h30', ''),
('33', 'Bourthes-P', 'Aa', '62168001', '1,9326948', '50,6020555', '0', '09/03/2022 08h30', '0', '09/03/2022 08h30', '', '', '', '', '', '', '12', '11,5', '40', '32', '24', '', '', '', '', '', '01/03/2022 08h30', 'bla bla', '', '', '01/03/2022 08h30', ''),
('34', 'BousbecqueUS', 'Lys plaine', 'E381126501', '3,0737956', '50,7758644', '0', '09/03/2022 08h30', '0', '09/03/2022 08h30', '', '', '', '', '', '', '12', '11,5', '40', '32', '24', '', '', '', '', '', '01/03/2022 08h30', 'bla bla', '', '', '01/03/2022 08h30', ''),
('35', 'Bousignies', 'Courant de l\' h?pita', 'E237601001', '3,3593145', '50,4366533', '0', '09/03/2022 08h30', '0', '09/03/2022 08h30', '', '', '', '', '', '', '12', '11,5', '40', '32', '24', '', '', '', '', '', '01/03/2022 08h30', 'bla bla', '', '', '01/03/2022 08h30', ''),
('36', 'Bouvines', 'Marque', 'E334601001', '3,1820263', '50,5791034', '0', '09/03/2022 08h30', '0', '09/03/2022 08h30', '', '', '', '', '', '', '12', '11,5', '40', '32', '24', '', '', '', '', '', '01/03/2022 08h30', 'bla bla', '', '', '01/03/2022 08h30', ''),
('37', 'Bouy_GE', 'Vesle', 'H640201001', '4,35087', '49,08909', '0', '09/03/2022 08h30', '0', '09/03/2022 08h30', '', '', '', '', '', '', '12', '11,5', '40', '32', '24', '', '', '', '', '', '01/03/2022 08h30', 'bla bla', '', '', '01/03/2022 08h30', ''),
('38', 'Braine_GE', 'Vesle', 'H643201001', '3,5268', '49,33707', '0', '09/03/2022 08h30', '0', '09/03/2022 08h30', '', '', '', '', '', '', '12', '11,5', '40', '32', '24', '', '', '', '', '', '01/03/2022 08h30', 'bla bla', '', '', '01/03/2022 08h30', ''),
('39', 'Bray sur sommeUS', 'Somme', 'E635140201', '2,7182671', '49,9367177', '0', '09/03/2022 08h30', '0', '09/03/2022 08h30', '', '', '', '', '', '', '12', '11,5', '40', '32', '24', '', '', '', '', '', '01/03/2022 08h30', 'bla bla', '', '', '01/03/2022 08h30', ''),
('40', 'Brebieres', 'Scarpe amont', 'E207111003', '3,0320658', '50,334505', '0', '09/03/2022 08h30', '0', '09/03/2022 08h30', '', '', '', '', '', '', '12', '11,5', '40', '32', '24', '', '', '', '', '', '01/03/2022 08h30', 'bla bla', '', '', '01/03/2022 08h30', ''),
('41', 'Brimeux', 'Canche', 'E540031001', '1,8308383', '50,4482377', '0', '09/03/2022 08h30', '0', '09/03/2022 08h30', '', '', '', '', '', '', '12', '11,5', '40', '32', '24', '', '', '', '', '', '01/03/2022 08h30', 'bla bla', '', '', '01/03/2022 08h30', ''),
('42', 'Bruay', 'Lawe', 'E366060002', '2,544248', '50,4866226', '0', '09/03/2022 08h30', '0', '09/03/2022 08h30', '', '', '', '', '', '', '12', '11,5', '40', '32', '24', '', '', '', '', '', '01/03/2022 08h30', 'bla bla', '', '', '01/03/2022 08h30', ''),
('43', 'Bruay-P', 'Lawe', '62178004', '2,5424321', '50,4867236', '0', '09/03/2022 08h30', '0', '09/03/2022 08h30', '', '', '', '', '', '', '12', '11,5', '40', '32', '24', '', '', '', '', '', '01/03/2022 08h30', 'bla bla', '', '', '01/03/2022 08h30', ''),
('44', 'Bruay2', 'Lawe', 'E366060003', '2,544248', '50,4866226', '0', '09/03/2022 08h30', '0', '09/03/2022 08h30', '', '', '', '', '', '', '12', '11,5', '40', '32', '24', '', '', '', '', '', '01/03/2022 08h30', 'bla bla', '', '', '01/03/2022 08h30', ''),
('45', 'CalaisMF', '', '62548002', '1,9554515', '50,9597661', '0', '09/03/2022 08h30', '0', '09/03/2022 08h30', '', '', '', '', '', '', '12', '11,5', '40', '32', '24', '', '', '', '', '', '01/03/2022 08h30', 'bla bla', '', '', '01/03/2022 08h30', ''),
('46', 'Cardonnette_piezo', 'Somme', 'P000000001', '2,3597785', '49,9507009', '0', '09/03/2022 08h30', '0', '09/03/2022 08h30', '', '', '', '', '', '', '12', '11,5', '40', '32', '24', '', '', '', '', '', '01/03/2022 08h30', 'bla bla', '', '', '01/03/2022 08h30', ''),
('47', 'CayeuxsurmerMF', 'Somme', '80182003', '1,5204411', '50,1871016', '0', '09/03/2022 08h30', '0', '09/03/2022 08h30', '', '', '', '', '', '', '12', '11,5', '40', '32', '24', '', '', '', '', '', '01/03/2022 08h30', 'bla bla', '', '', '01/03/2022 08h30', ''),
('48', 'Chalon sur Vesle_GE', 'Vesle', 'H641202001', '3,92197', '49,27816', '0', '09/03/2022 08h30', '0', '09/03/2022 08h30', '', '', '', '', '', '', '12', '11,5', '40', '32', '24', '', '', '', '', '', '01/03/2022 08h30', 'bla bla', '', '', '01/03/2022 08h30', ''),
('49', 'Chatrice_GE', 'Ante', 'H602321001', '4,91182', '49,05258', '0', '09/03/2022 08h30', '0', '09/03/2022 08h30', '', '', '', '', '', '', '12', '11,5', '40', '32', '24', '', '', '', '', '', '01/03/2022 08h30', 'bla bla', '', '', '01/03/2022 08h30', ''),
('50', 'Chavignon', 'Ailette', 'H730202001', '3,5433443', '49,4823038', '0', '09/03/2022 08h30', '0', '09/03/2022 08h30', '', '', '', '', '', '', '12', '11,5', '40', '32', '24', '', '', '', '', '', '01/03/2022 08h30', 'bla bla', '', '', '01/03/2022 08h30', ''),
('51', 'Chevieres_GE', 'Aire', 'H616201001', '4,90338', '49,33399', '0', '09/03/2022 08h30', '0', '09/03/2022 08h30', '', '', '', '', '', '', '12', '11,5', '40', '32', '24', '', '', '', '', '', '01/03/2022 08h30', 'bla bla', '', '', '01/03/2022 08h30', ''),
('52', 'Choisies', 'Solre', 'D020602001', '4,0338419', '50,2086192', '0', '09/03/2022 08h30', '0', '09/03/2022 08h30', '', '', '', '', '', '', '12', '11,5', '40', '32', '24', '', '', '', '', '', '01/03/2022 08h30', 'bla bla', '', '', '01/03/2022 08h30', ''),
('53', 'Chouy', 'Ourcq', 'H552201001', '3,2493072', '49,1942868', '0', '09/03/2022 08h30', '0', '09/03/2022 08h30', '', '', '', '', '', '', '12', '11,5', '40', '32', '24', '', '', '', '', '', '01/03/2022 08h30', 'bla bla', '', '', '01/03/2022 08h30', ''),
('54', 'Clairoix', 'Aronde', 'H742371002', '2,8460493', '49,4419183', '0', '09/03/2022 08h30', '0', '09/03/2022 08h30', '', '', '', '', '', '', '12', '11,5', '40', '32', '24', '', '', '', '', '', '01/03/2022 08h30', 'bla bla', '', '', '01/03/2022 08h30', ''),
('55', 'Condren', 'Oise moyenne', 'H720101001', '3,2838517', '49,6273843', '0', '09/03/2022 08h30', '0', '09/03/2022 08h30', '', '', '', '', '', '', '12', '11,5', '40', '32', '24', '', '', '', '', '', '01/03/2022 08h30', 'bla bla', '', '', '01/03/2022 08h30', ''),
('56', 'Creil_DRIEE', 'Oise aval isarienne', 'H208000104', '2,4605079', '49,2556842', '0', '09/03/2022 08h30', '0', '09/03/2022 08h30', '', '', '', '', '', '', '12', '11,5', '40', '32', '24', '', '', '', '', '', '01/03/2022 08h30', 'bla bla', '', '', '01/03/2022 08h30', ''),
('57', 'Crevecoeur_piezo', 'Somme', 'P000000004', '2,0864545', '49,6039455', '0', '09/03/2022 08h30', '0', '09/03/2022 08h30', '', '', '', '', '', '', '12', '11,5', '40', '32', '24', '', '', '', '', '', '01/03/2022 08h30', 'bla bla', '', '', '01/03/2022 08h30', ''),
('58', 'Delettes', 'Lys amont', 'E351122001', '2,2150552', '50,6185143', '0', '09/03/2022 08h30', '0', '09/03/2022 08h30', '', '', '', '', '', '', '12', '11,5', '40', '32', '24', '', '', '', '', '', '01/03/2022 08h30', 'bla bla', '', '', '01/03/2022 08h30', ''),
('59', 'Delettes2', 'Lys amont', 'E351122002', '2,2150552', '50,6185143', '0', '09/03/2022 08h30', '0', '09/03/2022 08h30', '', '', '', '', '', '', '12', '11,5', '40', '32', '24', '', '', '', '', '', '01/03/2022 08h30', 'bla bla', '', '', '01/03/2022 08h30', ''),
('60', 'Denain', 'Selle ( Escaut )', 'E172601002', '3,3913149', '50,318365', '0', '09/03/2022 08h30', '0', '09/03/2022 08h30', '', '', '', '', '', '', '12', '11,5', '40', '32', '24', '', '', '', '', '', '01/03/2022 08h30', 'bla bla', '', '', '01/03/2022 08h30', ''),
('61', 'Desvres-P', 'Liane', '62268004', '1,8302543', '50,6709233', '0', '09/03/2022 08h30', '0', '09/03/2022 08h30', '', '', '', '', '', '', '12', '11,5', '40', '32', '24', '', '', '', '', '', '01/03/2022 08h30', 'bla bla', '', '', '01/03/2022 08h30', ''),
('62', 'Dommartin', 'Noye', 'E640754001', '2,3880032', '49,7961', '0', '09/03/2022 08h30', '0', '09/03/2022 08h30', '', '', '', '', '', '', '12', '11,5', '40', '32', '24', '', '', '', '', '', '01/03/2022 08h30', 'bla bla', '', '', '01/03/2022 08h30', ''),
('63', 'Dommartin-Damp_GE', 'Auve', 'H603321001', '4,8232', '49,06776', '0', '09/03/2022 08h30', '0', '09/03/2022 08h30', '', '', '', '', '', '', '12', '11,5', '40', '32', '24', '', '', '', '', '', '01/03/2022 08h30', 'bla bla', '', '', '01/03/2022 08h30', ''),
('64', 'Dompierre', 'Authie', 'E550572001', '1,9186331', '50,3045021', '0', '09/03/2022 08h30', '0', '09/03/2022 08h30', '', '', '', '', '', '', '12', '11,5', '40', '32', '24', '', '', '', '', '', '01/03/2022 08h30', 'bla bla', '', '', '01/03/2022 08h30', ''),
('65', 'Doulieu-P', 'Lys plaine', '59180001', '2,668268', '50,68365', '0', '09/03/2022 08h30', '0', '09/03/2022 08h30', '', '', '', '', '', '', '12', '11,5', '40', '32', '24', '', '', '', '', '', '01/03/2022 08h30', 'bla bla', '', '', '01/03/2022 08h30', ''),
('66', 'DouziesFL', 'Flamenne', 'D019701001', '3,9291912', '50,2806191', '0', '09/03/2022 08h30', '0', '09/03/2022 08h30', '', '', '', '', '', '', '12', '11,5', '40', '32', '24', '', '', '', '', '', '01/03/2022 08h30', 'bla bla', '', '', '01/03/2022 08h30', ''),
('67', 'Duisans', 'Gy', 'E201000301', '2,6781143', '50,3113112', '0', '09/03/2022 08h30', '0', '09/03/2022 08h30', '', '', '', '', '', '', '12', '11,5', '40', '32', '24', '', '', '', '', '', '01/03/2022 08h30', 'bla bla', '', '', '01/03/2022 08h30', ''),
('68', 'Eclusier VauxUS', 'Somme', 'E633095001', '2,7868217', '49,9375211', '0', '09/03/2022 08h30', '0', '09/03/2022 08h30', '', '', '', '', '', '', '12', '11,5', '40', '32', '24', '', '', '', '', '', '01/03/2022 08h30', 'bla bla', '', '', '01/03/2022 08h30', ''),
('69', 'Ecly_GE', 'Vaux', 'H623302001', '4,29523', '49,5385', '0', '09/03/2022 08h30', '0', '09/03/2022 08h30', '', '', '', '', '', '', '12', '11,5', '40', '32', '24', '', '', '', '', '', '01/03/2022 08h30', 'bla bla', '', '', '01/03/2022 08h30', ''),
('70', 'Elnes', 'Aa', 'E403653301', '2,1277543', '50,6919893', '0', '09/03/2022 08h30', '0', '09/03/2022 08h30', '', '', '', '', '', '', '12', '11,5', '40', '32', '24', '', '', '', '', '', '01/03/2022 08h30', 'bla bla', '', '', '01/03/2022 08h30', ''),
('71', 'Elnes2', 'Aa', 'E403653302', '2,1277543', '50,6919893', '0', '09/03/2022 08h30', '0', '09/03/2022 08h30', '', '', '', '', '', '', '12', '11,5', '40', '32', '24', '', '', '', '', '', '01/03/2022 08h30', 'bla bla', '', '', '01/03/2022 08h30', ''),
('72', 'Ennevelin', 'Marque', 'E334602201', '3,1384857', '50,543178', '0', '09/03/2022 08h30', '0', '09/03/2022 08h30', '', '', '', '', '', '', '12', '11,5', '40', '32', '24', '', '', '', '', '', '01/03/2022 08h30', 'bla bla', '', '', '01/03/2022 08h30', ''),
('73', 'EpehyMF', 'Somme', '80271002', '3,1188513', '50,0006113', '0', '09/03/2022 08h30', '0', '09/03/2022 08h30', '', '', '', '', '', '', '12', '11,5', '40', '32', '24', '', '', '', '', '', '01/03/2022 08h30', 'bla bla', '', '', '01/03/2022 08h30', ''),
('74', 'Eppesauvage-Mombliar', 'Helpe majeure', 'D015710101', '', '', '0', '09/03/2022 08h30', '0', '09/03/2022 08h30', '', '', '', '', '', '', '12', '11,5', '40', '32', '24', '', '', '', '', '', '01/03/2022 08h30', 'bla bla', '', '', '01/03/2022 08h30', ''),
('75', 'EppeSauvage2', 'Helpe majeure', 'D015658001', '4,1116234', '50,1202141', '0', '09/03/2022 08h30', '0', '09/03/2022 08h30', '', '', '', '', '', '', '12', '11,5', '40', '32', '24', '', '', '', '', '', '01/03/2022 08h30', 'bla bla', '', '', '01/03/2022 08h30', ''),
('76', 'Estree', 'Course', 'E541000101', '1,7885073', '50,4995401', '0', '09/03/2022 08h30', '0', '09/03/2022 08h30', '', '', '', '', '', '', '12', '11,5', '40', '32', '24', '', '', '', '', '', '01/03/2022 08h30', 'bla bla', '', '', '01/03/2022 08h30', '');

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

--
-- Structure de la table `info_jaugeage_old`
--

CREATE TABLE `info_jaugeage_old` (
  `Id` int(5) NOT NULL,
  `Station` varchar(30) NOT NULL,
  `Cours_d_eau` varchar(20) NOT NULL,
  `Code_hydrologique` varchar(10) NOT NULL,
  `Longitude` float NOT NULL,
  `Latitude` float NOT NULL,
  `Dernier_niveau` float NOT NULL,
  `Date_dernier_niveau` date NOT NULL,
  `Dernier_debit` float NOT NULL,
  `Date_dernier_debit` date NOT NULL,
  `Niveau_seuil_Haut_Important` float NOT NULL,
  `Niveau_seuil_Haut_Critique` float NOT NULL,
  `Niveau_seuil_Bas_Important` float NOT NULL,
  `Niveau_seuil_Bas_Critique` float NOT NULL,
  `Niveau_max_connu` float NOT NULL,
  `Debit_max_connu` float NOT NULL,
  `Tension_seuil_bas_important` float NOT NULL DEFAULT 12,
  `Tension_seuil_bas_critique` float NOT NULL DEFAULT 11.5,
  `Delai_passage_critique` int(2) NOT NULL DEFAULT 40,
  `Delai_passage_normal` int(2) NOT NULL DEFAULT 24,
  `Delai_passage_retard` int(2) NOT NULL DEFAULT 32,
  `Q2` float NOT NULL,
  `Q5` float NOT NULL,
  `Q10` float NOT NULL,
  `Niveau_min_connu` float NOT NULL,
  `Debit_min_connu` float NOT NULL,
  `Dernier_passage` date NOT NULL,
  `Commentaires_dernier_passage` longtext NOT NULL,
  `Dernier_jaugeage` datetime NOT NULL,
  `Derniere_tension` float NOT NULL,
  `Date_derniere_tension` datetime NOT NULL,
  `Tendance` varchar(10) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

INSERT INTO `info_jaugeage_old` (`Id`, `Station`, `Cours_d_eau`, `Code_hydrologique`, `Longitude`, `Latitude`, `Dernier_niveau`, `Date_dernier_niveau`, `Dernier_debit`, `Date_dernier_debit`, `Niveau_seuil_Haut_Important`, `Niveau_seuil_Haut_Critique`, `Niveau_seuil_Bas_Important`, `Niveau_seuil_Bas_Critique`, `Niveau_max_connu`, `Debit_max_connu`, `Tension_seuil_bas_important`, `Tension_seuil_bas_critique`, `Delai_passage_critique`, `Delai_passage_normal`, `Delai_passage_retard`, `Q2`, `Q5`, `Q10`, `Niveau_min_connu`, `Debit_min_connu`, `Dernier_passage`, `Commentaires_dernier_passage`, `Dernier_jaugeage`, `Derniere_tension`, `Date_derniere_tension`, `Tendance`) VALUES
(1, '', 'test', '', 0, 0, 0, '0000-00-00', 10, '0000-00-00', 0, 0, 0, 0, 0, 0, 12, 11.5, 40, 24, 32, 0, 0, 0, 0, 0, '0000-00-00', '', '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00', ''),
(2, 'test1', '', '', 0, 0, 0, '0000-00-00', 0, '0000-00-00', 0, 0, 0, 0, 0, 0, 12, 11.5, 40, 24, 32, 0, 0, 0, 0, 0, '0000-00-00', 'test com1 update', '2022-03-10 16:50:54', 0, '0000-00-00 00:00:00', ''),
(3, '$station', '', '', 0, 0, 0, '0000-00-00', 0, '0000-00-00', 0, 0, 0, 0, 0, 0, 12, 11.5, 40, 24, 32, 0, 0, 0, 0, 0, '0000-00-00', '$commentaire', '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00', ''),
(4, 'test', '', '', 0, 0, 0, '0000-00-00', 0, '0000-00-00', 0, 0, 0, 0, 0, 0, 12, 11.5, 40, 24, 32, 0, 0, 0, 0, 0, '0000-00-00', 'test com update', '2022-03-10 16:49:08', 0, '0000-00-00 00:00:00', ''),
(5, '$station', '$cours', '$code', 0, 0, 0, '0000-00-00', 0, '0000-00-00', 0, 0, 0, 0, 0, 0, 12, 11.5, 40, 24, 32, 0, 0, 0, 0, 0, '0000-00-00', '', '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00', '$tendance'),
(6, '$station', '$cours', '$code', 1, 2, 3, '0000-00-00', 4, '0000-00-00', 5, 6, 7, 8, 9, 10, 12, 11.5, 40, 24, 32, 13, 14, 15, 11, 12, '0000-00-00', '', '0000-00-00 00:00:00', 16, '0000-00-00 00:00:00', 'tendance'),
(7, 'test', 'cour_test', 'code_test', 1, 2, 3, '2022-03-10', 4, '2022-03-10', 5, 6, 7, 8, 9, 11, 12, 11.5, 40, 24, 32, 13, 14, 15, 10, 12, '0000-00-00', 'test com update', '2022-03-10 16:49:08', 16, '2022-03-10 16:18:01', 'Haute');

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

--
-- Structure de la table `synthese`
--

CREATE TABLE `synthese` (
  `Niveau_seuil_Haut_Important` int(3) NOT NULL,
  `Niveau_seuil_Haut_Critique` int(3) NOT NULL,
  `Niveau_seuil_Bas_Important` int(3) NOT NULL,
  `Niveau_seuil_Bas_Critique` int(3) NOT NULL,
  `Tension_seuil_bas_important` int(3) NOT NULL,
  `Tension_seuil_bas_critique` int(3) NOT NULL,
  `Delai_passage_critique` int(2) NOT NULL,
  `Delai_passage_normal` int(2) NOT NULL,
  `Delai_passage_retard` int(2) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Structure de la table `temp`
--

CREATE TABLE `temp` (
  `station` varchar(30) NOT NULL,
  `commentaire` varchar(25) NOT NULL,
  `jaugeage` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

INSERT INTO `temp` (`station`, `commentaire`, `jaugeage`) VALUES
('test', 'test com', '0000-00-00 00:00:00'),
('test', 'test com', '0000-00-00 00:00:00'),
('test', 'test com', '0000-00-00 00:00:00'),
('test1', 'test com1', '0000-00-00 00:00:00'),
('test1', 'test com1', '0000-00-00 00:00:00'),
('test', 'test com', '0000-00-00 00:00:00'),
('test', 'test com', '0000-00-00 00:00:00'),
('test', 'date', '0000-00-00 00:00:00'),
('test', '', '0000-00-00 00:00:00'),
('test', '', '0000-00-00 00:00:00'),
('test', '2022-03-09', '0000-00-00 00:00:00'),
('test', 'test com', '2022-03-09 00:00:00'),
('test', 'test com', '2022-03-09 00:00:00'),
('test', 'test com', '2022-03-09 16:58:26');

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

--
-- Index pour la table `info_jaugeage_old`
--
ALTER TABLE `info_jaugeage_old`
  ADD PRIMARY KEY (`Id`);

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

--
-- AUTO_INCREMENT pour la table `info_jaugeage_old`
--
ALTER TABLE `info_jaugeage_old`
  MODIFY `Id` int(5) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;
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 */;
