-- https://www.phpmyadmin.net/
--
-- Hôte : 127.0.0.1:3306
-- Généré le : sam. 11 juin 2022 à 15:04
-- Version du serveur : 8.0.21
-- Version de PHP : 7.4.9

START TRANSACTION;



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

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

--
-- Structure de la table `file`
--

CREATE TABLE IF NOT EXISTS `file` (
  `file_extension` char(4) NOT NULL,
  `type_mime` varchar(255) NOT NULL,
  `type` varchar(255) NOT NULL,
  `color` varchar(255) NOT NULL,
  `bootstrap_icon` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  PRIMARY KEY (`file_extension`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

INSERT INTO `file` (`file_extension`, `type_mime`, `type`, `color`, `bootstrap_icon`) VALUES
('csv', 'text/csv', 'Fichier CSV', 'green', 'bi bi-file-earmark-excel'),
('doc', 'application/vnd.msword', 'Document Word', 'blue', 'bi bi-file-earmark-word'),
('docx', 'application/vnd.openxmlformats-officedocument.wordprocessingml.document', 'Document Word', 'blue', 'bi bi-file-earmark-word'),
('jpeg', 'image/jpeg', 'Fichier JPG', 'blue', 'bi bi-file-earmark-image'),
('jpg', 'image/jpeg', 'Fichier JPG', 'blue', 'bi bi-file-earmark-image'),
('mp4', 'video/mp4', 'Ficher MP4', 'blue', 'bi bi-file-earmark-play'),
('odp', 'application/vnd.oasis.opendocument.presentation', 'Presentation OpenDocument', 'orange', 'bi bi-file-earmark-ppt'),
('ods', 'application/vnd.oasis.opendocument.spreadsheet', 'Feuille de calcul OpenDocument', 'green', 'bi bi-file-earmark-excel'),
('odt', 'application/vnd.oasis.opendocument.text', 'Texte OpenDocument', 'blue', 'bi bi-file-earmark-word'),
('pdf', 'application/pdf', 'Fichier PDF', 'red', 'bi bi-file-earmark-pdf'),
('ppt', 'application/vnd.ms-powerpoint', 'Fichier PowerPoint', 'orange', 'bi bi-file-earmark-ppt'),
('pptx', 'application/vnd.openxmlformats-officedocument.presentationml.presentation', 'Fichier PowerPoint', 'orange', 'bi bi-file-earmark-ppt'),
('rar', 'application/x-rar-compressed', 'Archive compressé', 'orange', 'bi bi-file-earmark-zip'),
('txt', 'text/plain', 'Fichier Texte', 'black', 'bi bi-file-earmark-text'),
('xls', 'application/vnd.ms-excel', 'Feuille de calcul Excel', 'green', 'bi bi-file-earmark-excel'),
('xlsx', 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet', 'Feuille de calcul Excel', 'green', 'bi bi-file-earmark-excel'),
('zip', 'application/zip', 'Archive compressé', 'orange', 'bi bi-file-earmark-zip');

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

--
-- Structure de la table `files`
--

CREATE TABLE IF NOT EXISTS `files` (
  `id_file` int NOT NULL AUTO_INCREMENT,
  `directory` varchar(255) NOT NULL,
  `file_name` varchar(255) NOT NULL,
  `folder_file` enum('folder','file') NOT NULL,
  `extension` varchar(5) DEFAULT NULL,
  `size` bigint UNSIGNED DEFAULT NULL,
  `date` datetime NOT NULL,
  `id_file_parent` int DEFAULT NULL,
  `id_usage` varchar(50) NOT NULL,
  PRIMARY KEY (`id_file`),
  KEY `id_file_parent` (`id_file_parent`),
  KEY `id_usage` (`id_usage`)
) ENGINE=InnoDB AUTO_INCREMENT=90 DEFAULT CHARSET=utf8;

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

--
-- Structure de la table `files_usage`
--

CREATE TABLE IF NOT EXISTS `files_usage` (
  `id_usage` varchar(50) NOT NULL,
  `nom` varchar(255) NOT NULL,
  `base_dir` varchar(255) NOT NULL,
  `date_last_modified` datetime NOT NULL,
  `interval_upd` int NOT NULL,
  PRIMARY KEY (`id_usage`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

INSERT INTO `files_usage` (`id_usage`, `nom`, `base_dir`, `date_last_modified`, `interval_upd`) VALUES
('backup', 'Fichiers pour les sauvegardes', '/backup/grand_hotel/', '2022-06-11 13:35:29', 300);

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

--
-- Structure de la table `gh_chambres`
--

CREATE TABLE IF NOT EXISTS `gh_chambres` (
  `id_chambre` int NOT NULL AUTO_INCREMENT,
  `id_hotel` int NOT NULL,
  `taille` int NOT NULL,
  `etage` int NOT NULL,
  PRIMARY KEY (`id_chambre`),
  KEY `id_hotel` (`id_hotel`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Structure de la table `gh_clients`
--

CREATE TABLE IF NOT EXISTS `gh_clients` (
  `id_client` int NOT NULL AUTO_INCREMENT,
  `nom` varchar(100) NOT NULL,
  `prenom` varchar(100) NOT NULL,
  `email` varchar(100) NOT NULL,
  PRIMARY KEY (`id_client`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

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

INSERT INTO `gh_clients` (`id_client`, `nom`, `prenom`, `email`) VALUES
(1, 'Tanguy', 'David', 'datanguy@cnam.re'),
(2, 'Lebeau', 'Amélie', 'lbcr974@gmail.com');

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

--
-- Structure de la table `gh_hotels`
--

CREATE TABLE IF NOT EXISTS `gh_hotels` (
  `id_hotel` int NOT NULL AUTO_INCREMENT,
  `nom_hotel` varchar(255) NOT NULL,
  `adresse` varchar(255) NOT NULL,
  `code_postal` varchar(10) NOT NULL,
  `ville` varchar(50) NOT NULL,
  PRIMARY KEY (`id_hotel`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;

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

INSERT INTO `gh_hotels` (`id_hotel`, `nom_hotel`, `adresse`, `code_postal`, `ville`) VALUES
(1, 'Central Hotel', ' 37, rue de la Compagnie', '97478', 'Saint Denis'),
(2, 'Hôtel Select', '1 Bis Rue Des Lataniers', '97400', 'Saint-Denis'),
(3, 'Tulip inn Sainte Clotilde', '31 Avenue Leconte de Lisle', '97490', 'Saint-Denis');

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

--
-- Structure de la table `libraries`
--

CREATE TABLE IF NOT EXISTS `libraries` (
  `id_library` int NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL,
  `type` enum('JS+CSS','PHP') NOT NULL,
  PRIMARY KEY (`id_library`)
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8;

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

INSERT INTO `libraries` (`id_library`, `name`, `type`) VALUES
(1, 'jquery', 'JS+CSS'),
(2, 'jqueryui', 'JS+CSS'),
(3, 'twitter-bootstrap', 'JS+CSS'),
(4, 'jquery-validate', 'JS+CSS'),
(5, 'bootstrap-icons', 'JS+CSS'),
(6, 'font-awesome', 'JS+CSS'),
(7, 'fancybox', 'JS+CSS'),
(8, 'jquery.tablesorter', 'JS+CSS'),
(10, 'tinymce', 'JS+CSS'),
(11, 'dayjs', 'JS+CSS'),
(15, 'fullcalendar', 'JS+CSS'),
(16, 'Chart.js', 'JS+CSS'),
(18, 'PHPWord', 'PHP'),
(20, 'PhpSpreadsheet', 'PHP'),
(21, 'PHPMailer', 'PHP'),
(22, 'TCPDF', 'PHP');

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

--
-- Structure de la table `libraries_files`
--

CREATE TABLE IF NOT EXISTS `libraries_files` (
  `id_library_file` int NOT NULL AUTO_INCREMENT,
  `id_library` int NOT NULL,
  `description` varchar(100) DEFAULT NULL,
  `type` enum('js','css') DEFAULT NULL,
  PRIMARY KEY (`id_library_file`),
  KEY `id_library` (`id_library`)
) ENGINE=InnoDB AUTO_INCREMENT=59 DEFAULT CHARSET=utf8;

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

INSERT INTO `libraries_files` (`id_library_file`, `id_library`, `description`, `type`) VALUES
(1, 1, NULL, 'js'),
(2, 2, NULL, 'js'),
(3, 2, 'french_date_picker', 'js'),
(4, 2, NULL, 'css'),
(5, 3, NULL, 'js'),
(6, 3, NULL, 'css'),
(7, 4, NULL, 'js'),
(8, 5, NULL, 'css'),
(9, 6, NULL, 'css'),
(10, 7, NULL, 'js'),
(11, 7, NULL, 'css'),
(12, 8, NULL, 'js'),
(13, 8, 'widget', 'js'),
(14, 8, NULL, 'css'),
(16, 10, NULL, 'js'),
(25, 15, NULL, 'css'),
(29, 15, NULL, 'js'),
(30, 15, 'locale', 'js'),
(35, 18, '', NULL),
(37, 21, NULL, NULL),
(38, 21, NULL, NULL),
(39, 21, NULL, NULL),
(40, 22, '', ''),
(55, 16, '', 'js'),
(56, 11, '', 'js'),
(57, 11, 'fr', 'js'),
(58, 20, NULL, NULL);

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

--
-- Structure de la table `libraries_version`
--

CREATE TABLE IF NOT EXISTS `libraries_version` (
  `id_library_version` int NOT NULL AUTO_INCREMENT,
  `id_library_file` int NOT NULL,
  `src` varchar(255) NOT NULL,
  `version` varchar(20) NOT NULL,
  `integrity` varchar(255) NOT NULL,
  `active` tinyint(1) NOT NULL,
  PRIMARY KEY (`id_library_version`),
  KEY `id_library` (`id_library_file`)
) ENGINE=InnoDB AUTO_INCREMENT=68 DEFAULT CHARSET=utf8;

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

INSERT INTO `libraries_version` (`id_library_version`, `id_library_file`, `src`, `version`, `integrity`, `active`) VALUES
(1, 1, '/lib/jquery/1.12.4/jquery.min.js', '1.12.4', 'sha256-ZosEbRLbNQzLpnKIkEdrPv7lOy9C27hHQ+Xp8a4MxAQ=', 0),
(2, 1, '/lib/jquery/2.2.4/jquery.min.js', '2.2.4', 'sha256-BbhdlvQf/xTY9gja0Dq3HiwQF8LaCRTXxZKRutelT44=', 0),
(3, 1, '/lib/jquery/3.6.0/jquery.min.js', '3.6.0', 'sha512-894YE6QWD5I59HgZOGReFYm4dnWc1Qt5NtvYSaNcOP+u1T9qYdvdihz0PPSiiqn/+/3e7Jo4EaG7TubfWGUrMQ==', 1),
(4, 2, '/lib/jqueryui/1.13.1/jquery-ui.min.js', '1.13.1', '', 1),
(5, 3, '/lib/jqueryui/jquery.ui.datepicker-fr.js', '', '', 1),
(6, 4, '/lib/jqueryui/1.13.1/jquery-ui.min.css', '1.13.1', '', 1),
(7, 5, '/lib/twitter-bootstrap/5.1.3/js/bootstrap.min.js', '5.1.3', '', 1),
(8, 6, '/lib/twitter-bootstrap/5.1.3/css/bootstrap.min.css', '5.1.3', '', 1),
(9, 7, '/lib/jquery-validate/1.19.3/dist/jquery.validate.min.js', '1.19.3', '', 1),
(10, 8, '/lib/bootstrap-icons/1.8.3/font/bootstrap-icons.css', '1.8.3', '', 1),
(11, 9, '/lib/font-awesome/4.7.0/css/font-awesome.min.css', '4.7.0', '', 1),
(12, 10, '/lib/fancybox/3.5.7/dist/jquery.fancybox.min.js', '3.5.7', '', 0),
(13, 10, '/lib/fancybox/4.0.27/dist/fancybox.umd.js', '4.0.27', '', 1),
(14, 11, '/lib/fancybox/3.5.7/dist/jquery.fancybox.min.css', '3.5.7', '', 0),
(15, 11, '/lib/fancybox/4.0.27/dist/fancybox.css', '4.0.27', '', 1),
(16, 12, '/lib/jquery.tablesorter/2.32.1/dist/js/jquery.tablesorter.min.js', '2.32.1', '', 1),
(17, 13, '/lib/jquery.tablesorter/2.32.1/dist/js/jquery.tablesorter.widgets.min.js', '2.32.1', '', 1),
(18, 14, '/lib/jquery.tablesorter/2.32.1/dist/css/theme.bootstrap.min.css', '2.32.1', '', 1),
(20, 16, '/lib/tinymce/6.0.1/js/tinymce/tinymce.min.js', '6.0.1', '', 1),
(31, 25, '/lib/fullcalendar/5.11.0/lib/main.min.css', '5.11.0', '', 1),
(35, 29, '/lib/fullcalendar/5.11.0/lib/main.min.js', '5.11.0', '', 1),
(36, 30, '/lib/fullcalendar/5.11.0/lib/locales-all.min.js', '5.11.0', '', 1),
(41, 35, '/lib/PHPWord/0.17.0/index.php', '0.17.0', '', 1),
(43, 37, '/lib/PHPMailer/6.6.0/src/Exception.php', '6.6.0', '', 1),
(44, 38, '/lib/PHPMailer/6.6.0/src/PHPMailer.php', '6.6.0', '', 1),
(45, 39, '/lib/PHPMailer/6.6.0/src/SMTP.php', '6.6.0', '', 1),
(47, 40, '/lib/tcpdf/6.4.4/tcpdf.php', '6.4.4', '', 1),
(49, 40, '/lib/tcpdf/6.2.13/tcpdf.php', '6.2.13', '', 0),
(63, 55, '/lib/Chart.js/3.8.0/dist/chart.min.js', '3.8.0', '', 1),
(64, 56, '/lib/dayjs/1.11.2/dayjs.min.js', '1.11.2', '', 1),
(65, 57, '/lib/dayjs/1.11.2/fr.min.js', '1.11.2', '', 1),
(67, 58, '/lib/PhpSpreadsheet/1.23.0/vendor/autoload.php', '1.23.0', '', 1);

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

--
-- Structure de la table `log_php_error`
--

CREATE TABLE IF NOT EXISTS `log_php_error` (
  `id_log_php` int NOT NULL AUTO_INCREMENT,
  `datetime` datetime NOT NULL,
  `type_error` varchar(50) NOT NULL,
  `error` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  PRIMARY KEY (`id_log_php`)
) ENGINE=InnoDB AUTO_INCREMENT=981 DEFAULT CHARSET=utf8;

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

INSERT INTO `log_php_error` (`id_log_php`, `datetime`, `type_error`, `error`) VALUES
(951, '2022-05-21 06:36:48', 'PHP Warning', ' PHP Warning:  Undefined variable $in in C:\\wamp64\\www\\grand_hotel\\base\\service_informatique\\libraries\\version\\active.php on line 23\r PHP Stack trace:\r\n PHP   1. {main}() C:\\wamp64\\www\\grand_hotel\\base\\service_informatique\\libraries\\version\\active.php:0\r\n'),
(952, '2022-06-11 13:19:06', 'PHP Warning', ' PHP Warning:  require(C:/wamp64/www/grand_hotel/base/config/dbconfig.inc.php): failed to open stream: No such file or directory in C:\\wamp64\\www\\tourisme\\base\\authentification\\login_form.php on line 6\r PHP Stack trace:\r\n PHP   1. {main}() C:\\wamp64\\www\\tourisme\\base\\authentification\\login_form.php:0\r\n'),
(953, '2022-06-11 13:19:06', 'PHP Fatal error', ' PHP Fatal error:  require(): Failed opening required \'C:/wamp64/www/grand_hotel/base/config/dbconfig.inc.php\' (include_path=\'.;C:\\php\\pear\') in C:\\wamp64\\www\\tourisme\\base\\authentification\\login_form.php on line 6\r PHP Stack trace:\r\n PHP   1. {main}() C:\\wamp64\\www\\tourisme\\base\\authentification\\login_form.php:0\r\n'),
(954, '2022-06-11 13:35:29', 'PHP Warning', ' PHP Warning:  scandir(C:/wamp64/www/backup/grand_hotel/,C:/wamp64/www/backup/grand_hotel/): Le fichier spécifié est introuvable. (code: 2) in C:\\wamp64\\www\\tourisme\\base\\service_informatique\\file_cabinet\\scan_files.php on line 55\r PHP Stack trace:\r\n PHP   1. {main}() C:\\wamp64\\www\\tourisme\\base\\service_informatique\\file_cabinet\\scan_files.php:0\r\n PHP   2. scan_recursive() C:\\wamp64\\www\\tourisme\\base\\service_informatique\\file_cabinet\\scan_files.php:45\r\n PHP   3. scandir() C:\\wamp64\\www\\tourisme\\base\\service_informatique\\file_cabinet\\scan_files.php:55\r\n'),
(955, '2022-06-11 13:35:29', 'PHP Warning', ' PHP Warning:  scandir(C:/wamp64/www/backup/grand_hotel/): failed to open dir: No such file or directory in C:\\wamp64\\www\\tourisme\\base\\service_informatique\\file_cabinet\\scan_files.php on line 55\r PHP Stack trace:\r\n PHP   1. {main}() C:\\wamp64\\www\\tourisme\\base\\service_informatique\\file_cabinet\\scan_files.php:0\r\n PHP   2. scan_recursive() C:\\wamp64\\www\\tourisme\\base\\service_informatique\\file_cabinet\\scan_files.php:45\r\n PHP   3. scandir() C:\\wamp64\\www\\tourisme\\base\\service_informatique\\file_cabinet\\scan_files.php:55\r\n'),
(956, '2022-06-11 13:35:29', 'PHP Warning', ' PHP Warning:  scandir(): (errno 2): No such file or directory in C:\\wamp64\\www\\tourisme\\base\\service_informatique\\file_cabinet\\scan_files.php on line 55\r PHP Stack trace:\r\n PHP   1. {main}() C:\\wamp64\\www\\tourisme\\base\\service_informatique\\file_cabinet\\scan_files.php:0\r\n PHP   2. scan_recursive() C:\\wamp64\\www\\tourisme\\base\\service_informatique\\file_cabinet\\scan_files.php:45\r\n PHP   3. scandir() C:\\wamp64\\www\\tourisme\\base\\service_informatique\\file_cabinet\\scan_files.php:55\r\n'),
(957, '2022-06-11 13:35:36', 'PHP Warning', ' PHP Warning:  unlink(C:\\wamp64\\www\\backup	ourisme\\application	ourisme.zip): No such file or directory in C:\\wamp64\\www\\tourisme\\base\\service_informatique\\base_de_donnee\\backup_files.php on line 19\r PHP Stack trace:\r\n PHP   1. {main}() C:\\wamp64\\www\\tourisme\\base\\service_informatique\\base_de_donnee\\backup_files.php:0\r\n PHP   2. unlink() C:\\wamp64\\www\\tourisme\\base\\service_informatique\\base_de_donnee\\backup_files.php:19\r\n'),
(958, '2022-06-11 13:39:36', 'PHP Warning', ' PHP Warning:  unlink(C:\\wamp64\\www\\backup	ourisme\\application	ourisme.zip): No such file or directory in C:\\wamp64\\www\\tourisme\\base\\service_informatique\\base_de_donnee\\backup_files.php on line 19\r PHP Stack trace:\r\n PHP   1. {main}() C:\\wamp64\\www\\tourisme\\base\\service_informatique\\base_de_donnee\\backup_files.php:0\r\n PHP   2. unlink() C:\\wamp64\\www\\tourisme\\base\\service_informatique\\base_de_donnee\\backup_files.php:19\r\n'),
(959, '2022-06-11 13:39:44', 'PHP Warning', ' PHP Warning:  unlink(C:\\wamp64\\www\\backup	ourisme\\application	ourisme.zip): No such file or directory in C:\\wamp64\\www\\tourisme\\base\\service_informatique\\base_de_donnee\\backup_files.php on line 19\r PHP Stack trace:\r\n PHP   1. {main}() C:\\wamp64\\www\\tourisme\\base\\service_informatique\\base_de_donnee\\backup_files.php:0\r\n PHP   2. unlink() C:\\wamp64\\www\\tourisme\\base\\service_informatique\\base_de_donnee\\backup_files.php:19\r\n'),
(960, '2022-06-11 13:41:30', 'PHP Warning', ' PHP Warning:  unlink(C:\\wamp64\\www\\backup	ourisme\\application	ourisme.zip): No such file or directory in C:\\wamp64\\www\\tourisme\\base\\service_informatique\\base_de_donnee\\backup_files.php on line 19\r PHP Stack trace:\r\n PHP   1. {main}() C:\\wamp64\\www\\tourisme\\base\\service_informatique\\base_de_donnee\\backup_files.php:0\r\n PHP   2. unlink() C:\\wamp64\\www\\tourisme\\base\\service_informatique\\base_de_donnee\\backup_files.php:19\r\n'),
(961, '2022-06-11 13:41:56', 'PHP Warning', ' PHP Warning:  unlink(C:\\wamp64\\www\\backup	ourisme\\application	ourisme.zip): No such file or directory in C:\\wamp64\\www\\tourisme\\base\\service_informatique\\base_de_donnee\\backup_files.php on line 19\r PHP Stack trace:\r\n PHP   1. {main}() C:\\wamp64\\www\\tourisme\\base\\service_informatique\\base_de_donnee\\backup_files.php:0\r\n PHP   2. unlink() C:\\wamp64\\www\\tourisme\\base\\service_informatique\\base_de_donnee\\backup_files.php:19\r\n'),
(962, '2022-06-11 13:42:01', 'PHP Warning', ' PHP Warning:  unlink(C:\\wamp64\\www\\backup	ourisme\\application	ourisme.zip): No such file or directory in C:\\wamp64\\www\\tourisme\\base\\service_informatique\\base_de_donnee\\backup_files.php on line 19\r PHP Stack trace:\r\n PHP   1. {main}() C:\\wamp64\\www\\tourisme\\base\\service_informatique\\base_de_donnee\\backup_files.php:0\r\n PHP   2. unlink() C:\\wamp64\\www\\tourisme\\base\\service_informatique\\base_de_donnee\\backup_files.php:19\r\n'),
(963, '2022-06-11 13:42:46', 'PHP Warning', ' PHP Warning:  unlink(C:\\wamp64\\www\\backup	ourisme\\application	ourisme.zip): No such file or directory in C:\\wamp64\\www\\tourisme\\base\\service_informatique\\base_de_donnee\\backup_files.php on line 19\r PHP Stack trace:\r\n PHP   1. {main}() C:\\wamp64\\www\\tourisme\\base\\service_informatique\\base_de_donnee\\backup_files.php:0\r\n PHP   2. unlink() C:\\wamp64\\www\\tourisme\\base\\service_informatique\\base_de_donnee\\backup_files.php:19\r\n'),
(964, '2022-06-11 13:47:26', 'PHP Warning', ' PHP Warning:  unlink(C:\\wamp64\\www\\backup	ourisme\\application	ourisme.zip): No such file or directory in C:\\wamp64\\www\\tourisme\\base\\service_informatique\\base_de_donnee\\backup_files.php on line 19\r PHP Stack trace:\r\n PHP   1. {main}() C:\\wamp64\\www\\tourisme\\base\\service_informatique\\base_de_donnee\\backup_files.php:0\r\n PHP   2. unlink() C:\\wamp64\\www\\tourisme\\base\\service_informatique\\base_de_donnee\\backup_files.php:19\r\n'),
(965, '2022-06-11 13:48:11', 'PHP Parse error', ' PHP Parse error:  syntax error, unexpected \'unlink\' (T_STRING) in C:\\wamp64\\www\\tourisme\\base\\service_informatique\\base_de_donnee\\backup_files.php on line 19\r'),
(966, '2022-06-11 13:48:29', 'PHP Warning', ' PHP Warning:  unlink(C:\\wamp64\\www\\backup	ourisme\\application	ourisme.zip): No such file or directory in C:\\wamp64\\www\\tourisme\\base\\service_informatique\\base_de_donnee\\backup_files.php on line 19\r PHP Stack trace:\r\n PHP   1. {main}() C:\\wamp64\\www\\tourisme\\base\\service_informatique\\base_de_donnee\\backup_files.php:0\r\n PHP   2. unlink() C:\\wamp64\\www\\tourisme\\base\\service_informatique\\base_de_donnee\\backup_files.php:19\r\n'),
(967, '2022-06-11 13:48:39', 'PHP Warning', ' PHP Warning:  unlink(C:\\wamp64\\www\\backup	ourisme\\applicationc	ourisme.zip): No such file or directory in C:\\wamp64\\www\\tourisme\\base\\service_informatique\\base_de_donnee\\backup_files.php on line 19\r PHP Stack trace:\r\n PHP   1. {main}() C:\\wamp64\\www\\tourisme\\base\\service_informatique\\base_de_donnee\\backup_files.php:0\r\n PHP   2. unlink() C:\\wamp64\\www\\tourisme\\base\\service_informatique\\base_de_donnee\\backup_files.php:19\r\n'),
(968, '2022-06-11 13:48:53', 'PHP Warning', ' PHP Warning:  unlink(C:\\wamp64\\www\\backup	ourisme\\applicationc	ourisme.zip): No such file or directory in C:\\wamp64\\www\\tourisme\\base\\service_informatique\\base_de_donnee\\backup_files.php on line 19\r PHP Stack trace:\r\n PHP   1. {main}() C:\\wamp64\\www\\tourisme\\base\\service_informatique\\base_de_donnee\\backup_files.php:0\r\n PHP   2. unlink() C:\\wamp64\\www\\tourisme\\base\\service_informatique\\base_de_donnee\\backup_files.php:19\r\n'),
(969, '2022-06-11 13:48:55', 'PHP Warning', ' PHP Warning:  unlink(C:\\wamp64\\www\\backup	ourisme\\applicationc	ourisme.zip): No such file or directory in C:\\wamp64\\www\\tourisme\\base\\service_informatique\\base_de_donnee\\backup_files.php on line 19\r PHP Stack trace:\r\n PHP   1. {main}() C:\\wamp64\\www\\tourisme\\base\\service_informatique\\base_de_donnee\\backup_files.php:0\r\n PHP   2. unlink() C:\\wamp64\\www\\tourisme\\base\\service_informatique\\base_de_donnee\\backup_files.php:19\r\n'),
(970, '2022-06-11 13:49:15', 'PHP Warning', ' PHP Warning:  unlink(C:\\wamp64\\www\\backup	ourisme\\application	ourisme.zip): No such file or directory in C:\\wamp64\\www\\tourisme\\base\\service_informatique\\base_de_donnee\\backup_files.php on line 19\r PHP Stack trace:\r\n PHP   1. {main}() C:\\wamp64\\www\\tourisme\\base\\service_informatique\\base_de_donnee\\backup_files.php:0\r\n PHP   2. unlink() C:\\wamp64\\www\\tourisme\\base\\service_informatique\\base_de_donnee\\backup_files.php:19\r\n'),
(971, '2022-06-11 13:49:34', 'PHP Warning', ' PHP Warning:  unlink(C:\\wamp64\\www\\backup	ourisme\\application	ourisme.zip): No such file or directory in C:\\wamp64\\www\\tourisme\\base\\service_informatique\\base_de_donnee\\backup_files.php on line 19\r PHP Stack trace:\r\n PHP   1. {main}() C:\\wamp64\\www\\tourisme\\base\\service_informatique\\base_de_donnee\\backup_files.php:0\r\n PHP   2. unlink() C:\\wamp64\\www\\tourisme\\base\\service_informatique\\base_de_donnee\\backup_files.php:19\r\n'),
(972, '2022-06-11 14:22:39', 'PHP Fatal error', ' PHP Fatal error:  Uncaught mysqli_sql_exception: Base \'traffic_aerienx\' inconnue in C:\\wamp64\\www\\traffic_aerien\\lib\\lib.db.inc.php:7'),
(973, '2022-06-11 14:35:55', 'PHP Warning', ' PHP Warning:  require(C:/wamp64/www/traffic_aerien/config/dbconfig.inc.php): failed to open stream: No such file or directory in C:\\wamp64\\www\\tourisme\\base\\traffic_aerien\\config\\crud\\index.php on line 7\r PHP Stack trace:\r\n PHP   1. {main}() C:\\wamp64\\www\\tourisme\\base\\traffic_aerien\\config\\crud\\index.php:0\r\n'),
(974, '2022-06-11 14:35:55', 'PHP Fatal error', ' PHP Fatal error:  require(): Failed opening required \'C:/wamp64/www/traffic_aerien/config/dbconfig.inc.php\' (include_path=\'.;C:\\php\\pear\') in C:\\wamp64\\www\\tourisme\\base\\traffic_aerien\\config\\crud\\index.php on line 7\r PHP Stack trace:\r\n PHP   1. {main}() C:\\wamp64\\www\\tourisme\\base\\traffic_aerien\\config\\crud\\index.php:0\r\n'),
(975, '2022-06-11 14:45:10', 'PHP Warning', ' PHP Warning:  require(C:/wamp64/www/tourisme/config/dbconfig.inc.php): failed to open stream: No such file or directory in C:\\wamp64\\www\\tourisme\\base\\traffic_aerien\\config\\crud\\index.php on line 7\r PHP Stack trace:\r\n PHP   1. {main}() C:\\wamp64\\www\\tourisme\\base\\traffic_aerien\\config\\crud\\index.php:0\r\n'),
(976, '2022-06-11 14:45:10', 'PHP Fatal error', ' PHP Fatal error:  require(): Failed opening required \'C:/wamp64/www/tourisme/config/dbconfig.inc.php\' (include_path=\'.;C:\\php\\pear\') in C:\\wamp64\\www\\tourisme\\base\\traffic_aerien\\config\\crud\\index.php on line 7\r PHP Stack trace:\r\n PHP   1. {main}() C:\\wamp64\\www\\tourisme\\base\\traffic_aerien\\config\\crud\\index.php:0\r\n'),
(977, '2022-06-11 14:47:34', 'PHP Warning', ' PHP Warning:  require(C:\\wamp64\\www\\tourisme\\base\\traffic_aerien\\config\\header.inc.php): failed to open stream: No such file or directory in C:\\wamp64\\www\\tourisme\\base\\traffic_aerien\\config\\crud\\index.php on line 14\r PHP Stack trace:\r\n PHP   1. {main}() C:\\wamp64\\www\\tourisme\\base\\traffic_aerien\\config\\crud\\index.php:0\r\n'),
(978, '2022-06-11 14:47:34', 'PHP Fatal error', ' PHP Fatal error:  require(): Failed opening required \'C:/wamp64/www/tourisme/base/traffic_aerien/config/header.inc.php\' (include_path=\'.;C:\\php\\pear\') in C:\\wamp64\\www\\tourisme\\base\\traffic_aerien\\config\\crud\\index.php on line 14\r PHP Stack trace:\r\n PHP   1. {main}() C:\\wamp64\\www\\tourisme\\base\\traffic_aerien\\config\\crud\\index.php:0\r\n'),
(979, '2022-06-11 14:48:13', 'PHP Warning', ' PHP Warning:  require(C:/wamp64/www/tourisme/base/traffic_aerien/config/header.inc.php): failed to open stream: No such file or directory in C:\\wamp64\\www\\tourisme\\base\\traffic_aerien\\config\\crud\\index.php on line 14\r PHP Stack trace:\r\n PHP   1. {main}() C:\\wamp64\\www\\tourisme\\base\\traffic_aerien\\config\\crud\\index.php:0\r\n'),
(980, '2022-06-11 14:48:13', 'PHP Fatal error', ' PHP Fatal error:  require(): Failed opening required \'C:/wamp64/www/tourisme/base/traffic_aerien/config/header.inc.php\' (include_path=\'.;C:\\php\\pear\') in C:\\wamp64\\www\\tourisme\\base\\traffic_aerien\\config\\crud\\index.php on line 14\r PHP Stack trace:\r\n PHP   1. {main}() C:\\wamp64\\www\\tourisme\\base\\traffic_aerien\\config\\crud\\index.php:0\r\n');

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

--
-- Structure de la table `log_sql_error`
--

CREATE TABLE IF NOT EXISTS `log_sql_error` (
  `id_log_sql_error` int NOT NULL AUTO_INCREMENT,
  `datetime` datetime NOT NULL,
  `query` mediumtext CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `error` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `errno` int NOT NULL,
  `id_personnel` int DEFAULT NULL,
  `adresse_ip_client` varchar(15) NOT NULL,
  `file` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  PRIMARY KEY (`id_log_sql_error`),
  KEY `adresse_ip_client` (`adresse_ip_client`),
  KEY `id_personnel` (`id_personnel`),
  KEY `errno` (`errno`),
  KEY `datetime` (`datetime`) USING BTREE,
  KEY `error` (`error`) USING BTREE,
  KEY `file` (`file`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=337 DEFAULT CHARSET=utf8;

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

INSERT INTO `log_sql_error` (`id_log_sql_error`, `datetime`, `query`, `error`, `errno`, `id_personnel`, `adresse_ip_client`, `file`) VALUES
(154, '2022-05-17 15:19:56', 'SELECT * FROM vente_modeles', 'La table \'base_grand_hotel.vente_modeles\' n\'existe pas', 1146, 1, '::1', '/grand_hotel/base/config/crud/index.php?table_name=vente_modeles&title=Mod%C3%A8les&id_ss_menu=248'),
(156, '2022-05-17 20:21:12', 'SELECT * FROM hotels', 'La table \'base_grand_hotel.hotels\' n\'existe pas', 1146, 1, '::1', '/grand_hotel/base/reservation/json.php?'),
(157, '2022-06-11 14:56:19', 'SELECT * FROM ta_vols', 'La table \'base_tourisme.ta_vols\' n\'existe pas', 1146, 1, '192.168.4.2', '/tourisme/base/config/crud/index.php?table_name=ta_vols&title=Vols&id_menu=8'),
(158, '2022-06-11 14:56:19', 'SELECT DISTINCT(id_compagnie) FROM ta_vols', 'La table \'base_tourisme.ta_vols\' n\'existe pas', 1146, 1, '192.168.4.2', '/tourisme/base/config/crud/index.php?table_name=ta_vols&title=Vols&id_menu=8'),
(159, '2022-06-11 14:57:38', 'SELECT * FROM vols', 'La table \'base_tourisme.vols\' n\'existe pas', 1146, 1, '192.168.4.2', '/tourisme/base/config/crud/index.php?table_name=vols&title=Vols&id_menu=8'),
(160, '2022-06-11 14:57:39', 'SELECT *\r\n		FROM vols\r\n		WHERE 1=1 \r\n		', 'La table \'base_tourisme.vols\' n\'existe pas', 1146, 0, '192.168.4.2', '/tourisme/base/config/crud/json.php?title=Vols&table_name=vols'),
(161, '2022-06-11 14:59:02', 'SELECT * FROM aeroports WHERE id_aeroport=\'5\'', 'La table \'base_tourisme.aeroports\' n\'existe pas', 1146, 0, '192.168.4.2', '/tourisme/base/config/crud/json.php?title=Vols&table_name=ta_vols&id_compagnie=2'),
(162, '2022-06-11 14:59:02', 'SELECT * FROM aeroports WHERE id_aeroport=\'8\'', 'La table \'base_tourisme.aeroports\' n\'existe pas', 1146, 0, '192.168.4.2', '/tourisme/base/config/crud/json.php?title=Vols&table_name=ta_vols&id_compagnie=1'),
(163, '2022-06-11 14:59:02', 'SELECT * FROM aeroports WHERE id_aeroport=\'5\'', 'La table \'base_tourisme.aeroports\' n\'existe pas', 1146, 0, '192.168.4.2', '/tourisme/base/config/crud/json.php?title=Vols&table_name=ta_vols&id_compagnie=2'),
(164, '2022-06-11 14:59:02', 'SELECT * FROM aeroports WHERE id_aeroport=\'7\'', 'La table \'base_tourisme.aeroports\' n\'existe pas', 1146, 0, '192.168.4.2', '/tourisme/base/config/crud/json.php?title=Vols&table_name=ta_vols&id_compagnie=3'),
(165, '2022-06-11 14:59:02', 'SELECT * FROM aeroports WHERE id_aeroport=\'5\'', 'La table \'base_tourisme.aeroports\' n\'existe pas', 1146, 0, '192.168.4.2', '/tourisme/base/config/crud/json.php?title=Vols&table_name=ta_vols&id_compagnie=2'),
(166, '2022-06-11 14:59:02', 'SELECT * FROM aeroports WHERE id_aeroport=\'8\'', 'La table \'base_tourisme.aeroports\' n\'existe pas', 1146, 0, '192.168.4.2', '/tourisme/base/config/crud/json.php?title=Vols&table_name=ta_vols&id_compagnie=1'),
(167, '2022-06-11 14:59:02', 'SELECT * FROM aeroports WHERE id_aeroport=\'2\'', 'La table \'base_tourisme.aeroports\' n\'existe pas', 1146, 0, '192.168.4.2', '/tourisme/base/config/crud/json.php?title=Vols&table_name=ta_vols&id_compagnie=3'),
(168, '2022-06-11 14:59:02', 'SELECT * FROM aeroports WHERE id_aeroport=\'4\'', 'La table \'base_tourisme.aeroports\' n\'existe pas', 1146, 0, '192.168.4.2', '/tourisme/base/config/crud/json.php?title=Vols&table_name=ta_vols&id_compagnie=4'),
(169, '2022-06-11 14:59:02', 'SELECT * FROM aeroports WHERE id_aeroport=\'5\'', 'La table \'base_tourisme.aeroports\' n\'existe pas', 1146, 0, '192.168.4.2', '/tourisme/base/config/crud/json.php?title=Vols&table_name=ta_vols&id_compagnie=2'),
(170, '2022-06-11 14:59:02', 'SELECT * FROM aeroports WHERE id_aeroport=\'3\'', 'La table \'base_tourisme.aeroports\' n\'existe pas', 1146, 0, '192.168.4.2', '/tourisme/base/config/crud/json.php?title=Vols&table_name=ta_vols&id_compagnie=3'),
(171, '2022-06-11 14:59:02', 'SELECT * FROM aeroports WHERE id_aeroport=\'5\'', 'La table \'base_tourisme.aeroports\' n\'existe pas', 1146, 0, '192.168.4.2', '/tourisme/base/config/crud/json.php?title=Vols&table_name=ta_vols&id_compagnie=2'),
(172, '2022-06-11 14:59:02', 'SELECT * FROM aeroports WHERE id_aeroport=\'2\'', 'La table \'base_tourisme.aeroports\' n\'existe pas', 1146, 0, '192.168.4.2', '/tourisme/base/config/crud/json.php?title=Vols&table_name=ta_vols&id_compagnie=3'),
(173, '2022-06-11 14:59:02', 'SELECT * FROM aeroports WHERE id_aeroport=\'8\'', 'La table \'base_tourisme.aeroports\' n\'existe pas', 1146, 0, '192.168.4.2', '/tourisme/base/config/crud/json.php?title=Vols&table_name=ta_vols&id_compagnie=4'),
(174, '2022-06-11 14:59:02', 'SELECT * FROM aeroports WHERE id_aeroport=\'5\'', 'La table \'base_tourisme.aeroports\' n\'existe pas', 1146, 0, '192.168.4.2', '/tourisme/base/config/crud/json.php?title=Vols&table_name=ta_vols&id_compagnie=3'),
(175, '2022-06-11 14:59:02', 'SELECT * FROM aeroports WHERE id_aeroport=\'5\'', 'La table \'base_tourisme.aeroports\' n\'existe pas', 1146, 0, '192.168.4.2', '/tourisme/base/config/crud/json.php?title=Vols&table_name=ta_vols&id_compagnie=2'),
(176, '2022-06-11 14:59:02', 'SELECT * FROM aeroports WHERE id_aeroport=\'5\'', 'La table \'base_tourisme.aeroports\' n\'existe pas', 1146, 0, '192.168.4.2', '/tourisme/base/config/crud/json.php?title=Vols&table_name=ta_vols&id_compagnie=2'),
(177, '2022-06-11 14:59:02', 'SELECT * FROM aeroports WHERE id_aeroport=\'5\'', 'La table \'base_tourisme.aeroports\' n\'existe pas', 1146, 0, '192.168.4.2', '/tourisme/base/config/crud/json.php?title=Vols&table_name=ta_vols&id_compagnie=3'),
(178, '2022-06-11 14:59:02', 'SELECT * FROM aeroports WHERE id_aeroport=\'8\'', 'La table \'base_tourisme.aeroports\' n\'existe pas', 1146, 0, '192.168.4.2', '/tourisme/base/config/crud/json.php?title=Vols&table_name=ta_vols&id_compagnie=6'),
(179, '2022-06-11 14:59:02', 'SELECT * FROM aeroports WHERE id_aeroport=\'5\'', 'La table \'base_tourisme.aeroports\' n\'existe pas', 1146, 0, '192.168.4.2', '/tourisme/base/config/crud/json.php?title=Vols&table_name=ta_vols&id_compagnie=2'),
(180, '2022-06-11 14:59:02', 'SELECT * FROM aeroports WHERE id_aeroport=\'1\'', 'La table \'base_tourisme.aeroports\' n\'existe pas', 1146, 0, '192.168.4.2', '/tourisme/base/config/crud/json.php?title=Vols&table_name=ta_vols&id_compagnie=5'),
(181, '2022-06-11 14:59:02', 'SELECT * FROM aeroports WHERE id_aeroport=\'8\'', 'La table \'base_tourisme.aeroports\' n\'existe pas', 1146, 0, '192.168.4.2', '/tourisme/base/config/crud/json.php?title=Vols&table_name=ta_vols&id_compagnie=6'),
(182, '2022-06-11 14:59:02', 'SELECT * FROM aeroports WHERE id_aeroport=\'2\'', 'La table \'base_tourisme.aeroports\' n\'existe pas', 1146, 0, '192.168.4.2', '/tourisme/base/config/crud/json.php?title=Vols&table_name=ta_vols&id_compagnie=3'),
(183, '2022-06-11 14:59:02', 'SELECT * FROM aeroports WHERE id_aeroport=\'5\'', 'La table \'base_tourisme.aeroports\' n\'existe pas', 1146, 0, '192.168.4.2', '/tourisme/base/config/crud/json.php?title=Vols&table_name=ta_vols&id_compagnie=2'),
(184, '2022-06-11 14:59:02', 'SELECT * FROM aeroports WHERE id_aeroport=\'1\'', 'La table \'base_tourisme.aeroports\' n\'existe pas', 1146, 0, '192.168.4.2', '/tourisme/base/config/crud/json.php?title=Vols&table_name=ta_vols&id_compagnie=5'),
(185, '2022-06-11 14:59:02', 'SELECT * FROM aeroports WHERE id_aeroport=\'5\'', 'La table \'base_tourisme.aeroports\' n\'existe pas', 1146, 0, '192.168.4.2', '/tourisme/base/config/crud/json.php?title=Vols&table_name=ta_vols&id_compagnie=3'),
(186, '2022-06-11 14:59:02', 'SELECT * FROM aeroports WHERE id_aeroport=\'5\'', 'La table \'base_tourisme.aeroports\' n\'existe pas', 1146, 0, '192.168.4.2', '/tourisme/base/config/crud/json.php?title=Vols&table_name=ta_vols&id_compagnie=2'),
(187, '2022-06-11 14:59:02', 'SELECT * FROM aeroports WHERE id_aeroport=\'5\'', 'La table \'base_tourisme.aeroports\' n\'existe pas', 1146, 0, '192.168.4.2', '/tourisme/base/config/crud/json.php?title=Vols&table_name=ta_vols&id_compagnie=3'),
(188, '2022-06-11 14:59:02', 'SELECT * FROM aeroports WHERE id_aeroport=\'6\'', 'La table \'base_tourisme.aeroports\' n\'existe pas', 1146, 0, '192.168.4.2', '/tourisme/base/config/crud/json.php?title=Vols&table_name=ta_vols&id_compagnie=3'),
(189, '2022-06-11 14:59:02', 'SELECT * FROM aeroports WHERE id_aeroport=\'3\'', 'La table \'base_tourisme.aeroports\' n\'existe pas', 1146, 0, '192.168.4.2', '/tourisme/base/config/crud/json.php?title=Vols&table_name=ta_vols&id_compagnie=3'),
(190, '2022-06-11 14:59:02', 'SELECT * FROM aeroports WHERE id_aeroport=\'7\'', 'La table \'base_tourisme.aeroports\' n\'existe pas', 1146, 0, '192.168.4.2', '/tourisme/base/config/crud/json.php?title=Vols&table_name=ta_vols&id_compagnie=3'),
(191, '2022-06-11 14:59:09', 'SELECT * FROM aeroports WHERE id_aeroport=\'8\'', 'La table \'base_tourisme.aeroports\' n\'existe pas', 1146, 0, '192.168.4.2', '/tourisme/base/config/crud/json.php?title=Vols&table_name=ta_vols&id_compagnie=1'),
(192, '2022-06-11 14:59:09', 'SELECT * FROM aeroports WHERE id_aeroport=\'7\'', 'La table \'base_tourisme.aeroports\' n\'existe pas', 1146, 0, '192.168.4.2', '/tourisme/base/config/crud/json.php?title=Vols&table_name=ta_vols&id_compagnie=3'),
(193, '2022-06-11 14:59:09', 'SELECT * FROM aeroports WHERE id_aeroport=\'5\'', 'La table \'base_tourisme.aeroports\' n\'existe pas', 1146, 0, '192.168.4.2', '/tourisme/base/config/crud/json.php?title=Vols&table_name=ta_vols&id_compagnie=2'),
(194, '2022-06-11 14:59:09', 'SELECT * FROM aeroports WHERE id_aeroport=\'5\'', 'La table \'base_tourisme.aeroports\' n\'existe pas', 1146, 0, '192.168.4.2', '/tourisme/base/config/crud/json.php?title=Vols&table_name=ta_vols&id_compagnie=2'),
(195, '2022-06-11 14:59:09', 'SELECT * FROM aeroports WHERE id_aeroport=\'5\'', 'La table \'base_tourisme.aeroports\' n\'existe pas', 1146, 0, '192.168.4.2', '/tourisme/base/config/crud/json.php?title=Vols&table_name=ta_vols&id_compagnie=2'),
(196, '2022-06-11 14:59:09', 'SELECT * FROM aeroports WHERE id_aeroport=\'8\'', 'La table \'base_tourisme.aeroports\' n\'existe pas', 1146, 0, '192.168.4.2', '/tourisme/base/config/crud/json.php?title=Vols&table_name=ta_vols&id_compagnie=1'),
(197, '2022-06-11 14:59:09', 'SELECT * FROM aeroports WHERE id_aeroport=\'2\'', 'La table \'base_tourisme.aeroports\' n\'existe pas', 1146, 0, '192.168.4.2', '/tourisme/base/config/crud/json.php?title=Vols&table_name=ta_vols&id_compagnie=3'),
(198, '2022-06-11 14:59:09', 'SELECT * FROM aeroports WHERE id_aeroport=\'5\'', 'La table \'base_tourisme.aeroports\' n\'existe pas', 1146, 0, '192.168.4.2', '/tourisme/base/config/crud/json.php?title=Vols&table_name=ta_vols&id_compagnie=2'),
(199, '2022-06-11 14:59:09', 'SELECT * FROM aeroports WHERE id_aeroport=\'3\'', 'La table \'base_tourisme.aeroports\' n\'existe pas', 1146, 0, '192.168.4.2', '/tourisme/base/config/crud/json.php?title=Vols&table_name=ta_vols&id_compagnie=3'),
(200, '2022-06-11 14:59:09', 'SELECT * FROM aeroports WHERE id_aeroport=\'5\'', 'La table \'base_tourisme.aeroports\' n\'existe pas', 1146, 0, '192.168.4.2', '/tourisme/base/config/crud/json.php?title=Vols&table_name=ta_vols&id_compagnie=2'),
(201, '2022-06-11 14:59:09', 'SELECT * FROM aeroports WHERE id_aeroport=\'2\'', 'La table \'base_tourisme.aeroports\' n\'existe pas', 1146, 0, '192.168.4.2', '/tourisme/base/config/crud/json.php?title=Vols&table_name=ta_vols&id_compagnie=3'),
(202, '2022-06-11 14:59:09', 'SELECT * FROM aeroports WHERE id_aeroport=\'5\'', 'La table \'base_tourisme.aeroports\' n\'existe pas', 1146, 0, '192.168.4.2', '/tourisme/base/config/crud/json.php?title=Vols&table_name=ta_vols&id_compagnie=2'),
(203, '2022-06-11 14:59:09', 'SELECT * FROM aeroports WHERE id_aeroport=\'5\'', 'La table \'base_tourisme.aeroports\' n\'existe pas', 1146, 0, '192.168.4.2', '/tourisme/base/config/crud/json.php?title=Vols&table_name=ta_vols&id_compagnie=3'),
(204, '2022-06-11 14:59:09', 'SELECT * FROM aeroports WHERE id_aeroport=\'5\'', 'La table \'base_tourisme.aeroports\' n\'existe pas', 1146, 0, '192.168.4.2', '/tourisme/base/config/crud/json.php?title=Vols&table_name=ta_vols&id_compagnie=2'),
(205, '2022-06-11 14:59:09', 'SELECT * FROM aeroports WHERE id_aeroport=\'5\'', 'La table \'base_tourisme.aeroports\' n\'existe pas', 1146, 0, '192.168.4.2', '/tourisme/base/config/crud/json.php?title=Vols&table_name=ta_vols&id_compagnie=3'),
(206, '2022-06-11 14:59:09', 'SELECT * FROM aeroports WHERE id_aeroport=\'5\'', 'La table \'base_tourisme.aeroports\' n\'existe pas', 1146, 0, '192.168.4.2', '/tourisme/base/config/crud/json.php?title=Vols&table_name=ta_vols&id_compagnie=2'),
(207, '2022-06-11 14:59:09', 'SELECT * FROM aeroports WHERE id_aeroport=\'2\'', 'La table \'base_tourisme.aeroports\' n\'existe pas', 1146, 0, '192.168.4.2', '/tourisme/base/config/crud/json.php?title=Vols&table_name=ta_vols&id_compagnie=3'),
(208, '2022-06-11 14:59:09', 'SELECT * FROM aeroports WHERE id_aeroport=\'5\'', 'La table \'base_tourisme.aeroports\' n\'existe pas', 1146, 0, '192.168.4.2', '/tourisme/base/config/crud/json.php?title=Vols&table_name=ta_vols&id_compagnie=2'),
(209, '2022-06-11 14:59:09', 'SELECT * FROM aeroports WHERE id_aeroport=\'5\'', 'La table \'base_tourisme.aeroports\' n\'existe pas', 1146, 0, '192.168.4.2', '/tourisme/base/config/crud/json.php?title=Vols&table_name=ta_vols&id_compagnie=3'),
(210, '2022-06-11 14:59:09', 'SELECT * FROM aeroports WHERE id_aeroport=\'4\'', 'La table \'base_tourisme.aeroports\' n\'existe pas', 1146, 0, '192.168.4.2', '/tourisme/base/config/crud/json.php?title=Vols&table_name=ta_vols&id_compagnie=4'),
(211, '2022-06-11 14:59:09', 'SELECT * FROM aeroports WHERE id_aeroport=\'5\'', 'La table \'base_tourisme.aeroports\' n\'existe pas', 1146, 0, '192.168.4.2', '/tourisme/base/config/crud/json.php?title=Vols&table_name=ta_vols&id_compagnie=2'),
(212, '2022-06-11 14:59:09', 'SELECT * FROM aeroports WHERE id_aeroport=\'5\'', 'La table \'base_tourisme.aeroports\' n\'existe pas', 1146, 0, '192.168.4.2', '/tourisme/base/config/crud/json.php?title=Vols&table_name=ta_vols&id_compagnie=3'),
(213, '2022-06-11 14:59:09', 'SELECT * FROM aeroports WHERE id_aeroport=\'1\'', 'La table \'base_tourisme.aeroports\' n\'existe pas', 1146, 0, '192.168.4.2', '/tourisme/base/config/crud/json.php?title=Vols&table_name=ta_vols&id_compagnie=5'),
(214, '2022-06-11 14:59:09', 'SELECT * FROM aeroports WHERE id_aeroport=\'8\'', 'La table \'base_tourisme.aeroports\' n\'existe pas', 1146, 0, '192.168.4.2', '/tourisme/base/config/crud/json.php?title=Vols&table_name=ta_vols&id_compagnie=6'),
(215, '2022-06-11 14:59:09', 'SELECT * FROM aeroports WHERE id_aeroport=\'8\'', 'La table \'base_tourisme.aeroports\' n\'existe pas', 1146, 0, '192.168.4.2', '/tourisme/base/config/crud/json.php?title=Vols&table_name=ta_vols&id_compagnie=4'),
(216, '2022-06-11 14:59:09', 'SELECT * FROM aeroports WHERE id_aeroport=\'6\'', 'La table \'base_tourisme.aeroports\' n\'existe pas', 1146, 0, '192.168.4.2', '/tourisme/base/config/crud/json.php?title=Vols&table_name=ta_vols&id_compagnie=3'),
(217, '2022-06-11 14:59:09', 'SELECT * FROM aeroports WHERE id_aeroport=\'1\'', 'La table \'base_tourisme.aeroports\' n\'existe pas', 1146, 0, '192.168.4.2', '/tourisme/base/config/crud/json.php?title=Vols&table_name=ta_vols&id_compagnie=5'),
(218, '2022-06-11 14:59:09', 'SELECT * FROM aeroports WHERE id_aeroport=\'3\'', 'La table \'base_tourisme.aeroports\' n\'existe pas', 1146, 0, '192.168.4.2', '/tourisme/base/config/crud/json.php?title=Vols&table_name=ta_vols&id_compagnie=3'),
(219, '2022-06-11 14:59:09', 'SELECT * FROM aeroports WHERE id_aeroport=\'7\'', 'La table \'base_tourisme.aeroports\' n\'existe pas', 1146, 0, '192.168.4.2', '/tourisme/base/config/crud/json.php?title=Vols&table_name=ta_vols&id_compagnie=3'),
(220, '2022-06-11 14:59:09', 'SELECT * FROM aeroports WHERE id_aeroport=\'8\'', 'La table \'base_tourisme.aeroports\' n\'existe pas', 1146, 0, '192.168.4.2', '/tourisme/base/config/crud/json.php?title=Vols&table_name=ta_vols&id_compagnie=6'),
(221, '2022-06-11 14:59:12', 'SELECT * FROM ta_compagnies', 'La table \'base_tourisme.ta_compagnies\' n\'existe pas', 1146, 1, '192.168.4.2', '/tourisme/base/config/crud/index.php?table_name=ta_compagnies&title=Vols&id_menu=9'),
(222, '2022-06-11 14:59:13', 'SELECT *\r\n		FROM ta_compagnies\r\n		WHERE 1=1 \r\n		', 'La table \'base_tourisme.ta_compagnies\' n\'existe pas', 1146, 0, '192.168.4.2', '/tourisme/base/config/crud/json.php?title=Vols&table_name=ta_compagnies'),
(223, '2022-06-11 15:00:12', 'SELECT * FROM ta_compagnies', 'La table \'base_tourisme.ta_compagnies\' n\'existe pas', 1146, 1, '192.168.4.2', '/tourisme/base/config/crud/index.php?table_name=ta_compagnies&title=Vols&id_menu=9'),
(224, '2022-06-11 15:00:12', 'SELECT *\r\n		FROM ta_compagnies\r\n		WHERE 1=1 \r\n		', 'La table \'base_tourisme.ta_compagnies\' n\'existe pas', 1146, 0, '192.168.4.2', '/tourisme/base/config/crud/json.php?title=Vols&table_name=ta_compagnies'),
(225, '2022-06-11 15:00:33', 'SELECT compagnies.nom FROM ta_compagnies WHERE ta_compagnies.id_compagnie=\'1\'', 'La table \'base_tourisme.ta_compagnies\' n\'existe pas', 1146, 1, '192.168.4.2', '/tourisme/base/config/crud/index.php?table_name=ta_vols&title=Vols&id_menu=8'),
(226, '2022-06-11 15:00:33', 'SELECT compagnies.nom FROM ta_compagnies WHERE ta_compagnies.id_compagnie=\'2\'', 'La table \'base_tourisme.ta_compagnies\' n\'existe pas', 1146, 1, '192.168.4.2', '/tourisme/base/config/crud/index.php?table_name=ta_vols&title=Vols&id_menu=8'),
(227, '2022-06-11 15:00:33', 'SELECT compagnies.nom FROM ta_compagnies WHERE ta_compagnies.id_compagnie=\'3\'', 'La table \'base_tourisme.ta_compagnies\' n\'existe pas', 1146, 1, '192.168.4.2', '/tourisme/base/config/crud/index.php?table_name=ta_vols&title=Vols&id_menu=8'),
(228, '2022-06-11 15:00:33', 'SELECT compagnies.nom FROM ta_compagnies WHERE ta_compagnies.id_compagnie=\'4\'', 'La table \'base_tourisme.ta_compagnies\' n\'existe pas', 1146, 1, '192.168.4.2', '/tourisme/base/config/crud/index.php?table_name=ta_vols&title=Vols&id_menu=8'),
(229, '2022-06-11 15:00:33', 'SELECT compagnies.nom FROM ta_compagnies WHERE ta_compagnies.id_compagnie=\'5\'', 'La table \'base_tourisme.ta_compagnies\' n\'existe pas', 1146, 1, '192.168.4.2', '/tourisme/base/config/crud/index.php?table_name=ta_vols&title=Vols&id_menu=8'),
(230, '2022-06-11 15:00:33', 'SELECT compagnies.nom FROM ta_compagnies WHERE ta_compagnies.id_compagnie=\'6\'', 'La table \'base_tourisme.ta_compagnies\' n\'existe pas', 1146, 1, '192.168.4.2', '/tourisme/base/config/crud/index.php?table_name=ta_vols&title=Vols&id_menu=8'),
(231, '2022-06-11 15:00:34', 'SELECT * FROM ta_compagnies WHERE id_compagnie=\'1\'', 'La table \'base_tourisme.ta_compagnies\' n\'existe pas', 1146, 0, '192.168.4.2', '/tourisme/base/config/crud/json.php?title=Vols&table_name=ta_vols&id_compagnie=1'),
(232, '2022-06-11 15:00:34', 'SELECT * FROM ta_compagnies WHERE id_compagnie=\'2\'', 'La table \'base_tourisme.ta_compagnies\' n\'existe pas', 1146, 0, '192.168.4.2', '/tourisme/base/config/crud/json.php?title=Vols&table_name=ta_vols&id_compagnie=2'),
(233, '2022-06-11 15:00:34', 'SELECT * FROM ta_compagnies WHERE id_compagnie=\'1\'', 'La table \'base_tourisme.ta_compagnies\' n\'existe pas', 1146, 0, '192.168.4.2', '/tourisme/base/config/crud/json.php?title=Vols&table_name=ta_vols&id_compagnie=1'),
(234, '2022-06-11 15:00:34', 'SELECT * FROM ta_compagnies WHERE id_compagnie=\'2\'', 'La table \'base_tourisme.ta_compagnies\' n\'existe pas', 1146, 0, '192.168.4.2', '/tourisme/base/config/crud/json.php?title=Vols&table_name=ta_vols&id_compagnie=2'),
(235, '2022-06-11 15:00:34', 'SELECT * FROM ta_compagnies WHERE id_compagnie=\'3\'', 'La table \'base_tourisme.ta_compagnies\' n\'existe pas', 1146, 0, '192.168.4.2', '/tourisme/base/config/crud/json.php?title=Vols&table_name=ta_vols&id_compagnie=3'),
(236, '2022-06-11 15:00:34', 'SELECT * FROM ta_compagnies WHERE id_compagnie=\'3\'', 'La table \'base_tourisme.ta_compagnies\' n\'existe pas', 1146, 0, '192.168.4.2', '/tourisme/base/config/crud/json.php?title=Vols&table_name=ta_vols&id_compagnie=3'),
(237, '2022-06-11 15:00:34', 'SELECT * FROM ta_compagnies WHERE id_compagnie=\'3\'', 'La table \'base_tourisme.ta_compagnies\' n\'existe pas', 1146, 0, '192.168.4.2', '/tourisme/base/config/crud/json.php?title=Vols&table_name=ta_vols&id_compagnie=3'),
(238, '2022-06-11 15:00:34', 'SELECT * FROM ta_compagnies WHERE id_compagnie=\'3\'', 'La table \'base_tourisme.ta_compagnies\' n\'existe pas', 1146, 0, '192.168.4.2', '/tourisme/base/config/crud/json.php?title=Vols&table_name=ta_vols&id_compagnie=3'),
(239, '2022-06-11 15:00:34', 'SELECT * FROM ta_compagnies WHERE id_compagnie=\'3\'', 'La table \'base_tourisme.ta_compagnies\' n\'existe pas', 1146, 0, '192.168.4.2', '/tourisme/base/config/crud/json.php?title=Vols&table_name=ta_vols&id_compagnie=3'),
(240, '2022-06-11 15:00:34', 'SELECT * FROM ta_compagnies WHERE id_compagnie=\'3\'', 'La table \'base_tourisme.ta_compagnies\' n\'existe pas', 1146, 0, '192.168.4.2', '/tourisme/base/config/crud/json.php?title=Vols&table_name=ta_vols&id_compagnie=3'),
(241, '2022-06-11 15:00:34', 'SELECT * FROM ta_compagnies WHERE id_compagnie=\'2\'', 'La table \'base_tourisme.ta_compagnies\' n\'existe pas', 1146, 0, '192.168.4.2', '/tourisme/base/config/crud/json.php?title=Vols&table_name=ta_vols&id_compagnie=2'),
(242, '2022-06-11 15:00:34', 'SELECT * FROM ta_compagnies WHERE id_compagnie=\'3\'', 'La table \'base_tourisme.ta_compagnies\' n\'existe pas', 1146, 0, '192.168.4.2', '/tourisme/base/config/crud/json.php?title=Vols&table_name=ta_vols&id_compagnie=3'),
(243, '2022-06-11 15:00:34', 'SELECT * FROM ta_compagnies WHERE id_compagnie=\'2\'', 'La table \'base_tourisme.ta_compagnies\' n\'existe pas', 1146, 0, '192.168.4.2', '/tourisme/base/config/crud/json.php?title=Vols&table_name=ta_vols&id_compagnie=2'),
(244, '2022-06-11 15:00:34', 'SELECT * FROM ta_compagnies WHERE id_compagnie=\'3\'', 'La table \'base_tourisme.ta_compagnies\' n\'existe pas', 1146, 0, '192.168.4.2', '/tourisme/base/config/crud/json.php?title=Vols&table_name=ta_vols&id_compagnie=3'),
(245, '2022-06-11 15:00:34', 'SELECT * FROM ta_compagnies WHERE id_compagnie=\'2\'', 'La table \'base_tourisme.ta_compagnies\' n\'existe pas', 1146, 0, '192.168.4.2', '/tourisme/base/config/crud/json.php?title=Vols&table_name=ta_vols&id_compagnie=2'),
(246, '2022-06-11 15:00:34', 'SELECT * FROM ta_compagnies WHERE id_compagnie=\'3\'', 'La table \'base_tourisme.ta_compagnies\' n\'existe pas', 1146, 0, '192.168.4.2', '/tourisme/base/config/crud/json.php?title=Vols&table_name=ta_vols&id_compagnie=3'),
(247, '2022-06-11 15:00:34', 'SELECT * FROM ta_compagnies WHERE id_compagnie=\'2\'', 'La table \'base_tourisme.ta_compagnies\' n\'existe pas', 1146, 0, '192.168.4.2', '/tourisme/base/config/crud/json.php?title=Vols&table_name=ta_vols&id_compagnie=2'),
(248, '2022-06-11 15:00:34', 'SELECT * FROM ta_compagnies WHERE id_compagnie=\'3\'', 'La table \'base_tourisme.ta_compagnies\' n\'existe pas', 1146, 0, '192.168.4.2', '/tourisme/base/config/crud/json.php?title=Vols&table_name=ta_vols&id_compagnie=3'),
(249, '2022-06-11 15:00:34', 'SELECT * FROM ta_compagnies WHERE id_compagnie=\'3\'', 'La table \'base_tourisme.ta_compagnies\' n\'existe pas', 1146, 0, '192.168.4.2', '/tourisme/base/config/crud/json.php?title=Vols&table_name=ta_vols&id_compagnie=3'),
(250, '2022-06-11 15:00:34', 'SELECT * FROM ta_compagnies WHERE id_compagnie=\'2\'', 'La table \'base_tourisme.ta_compagnies\' n\'existe pas', 1146, 0, '192.168.4.2', '/tourisme/base/config/crud/json.php?title=Vols&table_name=ta_vols&id_compagnie=2'),
(251, '2022-06-11 15:00:34', 'SELECT * FROM ta_compagnies WHERE id_compagnie=\'2\'', 'La table \'base_tourisme.ta_compagnies\' n\'existe pas', 1146, 0, '192.168.4.2', '/tourisme/base/config/crud/json.php?title=Vols&table_name=ta_vols&id_compagnie=2'),
(252, '2022-06-11 15:00:34', 'SELECT * FROM ta_compagnies WHERE id_compagnie=\'3\'', 'La table \'base_tourisme.ta_compagnies\' n\'existe pas', 1146, 0, '192.168.4.2', '/tourisme/base/config/crud/json.php?title=Vols&table_name=ta_vols&id_compagnie=3'),
(253, '2022-06-11 15:00:34', 'SELECT * FROM ta_compagnies WHERE id_compagnie=\'2\'', 'La table \'base_tourisme.ta_compagnies\' n\'existe pas', 1146, 0, '192.168.4.2', '/tourisme/base/config/crud/json.php?title=Vols&table_name=ta_vols&id_compagnie=2'),
(254, '2022-06-11 15:00:34', 'SELECT * FROM ta_compagnies WHERE id_compagnie=\'2\'', 'La table \'base_tourisme.ta_compagnies\' n\'existe pas', 1146, 0, '192.168.4.2', '/tourisme/base/config/crud/json.php?title=Vols&table_name=ta_vols&id_compagnie=2'),
(255, '2022-06-11 15:00:34', 'SELECT * FROM ta_compagnies WHERE id_compagnie=\'6\'', 'La table \'base_tourisme.ta_compagnies\' n\'existe pas', 1146, 0, '192.168.4.2', '/tourisme/base/config/crud/json.php?title=Vols&table_name=ta_vols&id_compagnie=6'),
(256, '2022-06-11 15:00:34', 'SELECT * FROM ta_compagnies WHERE id_compagnie=\'5\'', 'La table \'base_tourisme.ta_compagnies\' n\'existe pas', 1146, 0, '192.168.4.2', '/tourisme/base/config/crud/json.php?title=Vols&table_name=ta_vols&id_compagnie=5'),
(257, '2022-06-11 15:00:34', 'SELECT * FROM ta_compagnies WHERE id_compagnie=\'6\'', 'La table \'base_tourisme.ta_compagnies\' n\'existe pas', 1146, 0, '192.168.4.2', '/tourisme/base/config/crud/json.php?title=Vols&table_name=ta_vols&id_compagnie=6'),
(258, '2022-06-11 15:00:34', 'SELECT * FROM ta_compagnies WHERE id_compagnie=\'5\'', 'La table \'base_tourisme.ta_compagnies\' n\'existe pas', 1146, 0, '192.168.4.2', '/tourisme/base/config/crud/json.php?title=Vols&table_name=ta_vols&id_compagnie=5'),
(259, '2022-06-11 15:00:34', 'SELECT * FROM ta_compagnies WHERE id_compagnie=\'4\'', 'La table \'base_tourisme.ta_compagnies\' n\'existe pas', 1146, 0, '192.168.4.2', '/tourisme/base/config/crud/json.php?title=Vols&table_name=ta_vols&id_compagnie=4'),
(260, '2022-06-11 15:00:34', 'SELECT * FROM ta_compagnies WHERE id_compagnie=\'4\'', 'La table \'base_tourisme.ta_compagnies\' n\'existe pas', 1146, 0, '192.168.4.2', '/tourisme/base/config/crud/json.php?title=Vols&table_name=ta_vols&id_compagnie=4'),
(261, '2022-06-11 15:00:52', 'SELECT * FROM ta_compagnies', 'La table \'base_tourisme.ta_compagnies\' n\'existe pas', 1146, 1, '192.168.4.2', '/tourisme/base/config/crud/index.php?table_name=ta_compagnies&title=Vols&id_menu=9'),
(262, '2022-06-11 15:00:52', 'SELECT *\r\n		FROM ta_compagnies\r\n		WHERE 1=1 \r\n		', 'La table \'base_tourisme.ta_compagnies\' n\'existe pas', 1146, 0, '192.168.4.2', '/tourisme/base/config/crud/json.php?title=Vols&table_name=ta_compagnies'),
(263, '2022-06-11 15:01:15', 'SELECT compagnies.nom FROM ta_compagnies WHERE ta_compagnies.id_compagnie=\'1\'', 'La table \'base_tourisme.ta_compagnies\' n\'existe pas', 1146, 1, '192.168.4.2', '/tourisme/base/config/crud/index.php?table_name=ta_vols&title=Vols&id_menu=8'),
(264, '2022-06-11 15:01:15', 'SELECT compagnies.nom FROM ta_compagnies WHERE ta_compagnies.id_compagnie=\'2\'', 'La table \'base_tourisme.ta_compagnies\' n\'existe pas', 1146, 1, '192.168.4.2', '/tourisme/base/config/crud/index.php?table_name=ta_vols&title=Vols&id_menu=8'),
(265, '2022-06-11 15:01:15', 'SELECT compagnies.nom FROM ta_compagnies WHERE ta_compagnies.id_compagnie=\'3\'', 'La table \'base_tourisme.ta_compagnies\' n\'existe pas', 1146, 1, '192.168.4.2', '/tourisme/base/config/crud/index.php?table_name=ta_vols&title=Vols&id_menu=8'),
(266, '2022-06-11 15:01:15', 'SELECT compagnies.nom FROM ta_compagnies WHERE ta_compagnies.id_compagnie=\'4\'', 'La table \'base_tourisme.ta_compagnies\' n\'existe pas', 1146, 1, '192.168.4.2', '/tourisme/base/config/crud/index.php?table_name=ta_vols&title=Vols&id_menu=8'),
(267, '2022-06-11 15:01:15', 'SELECT compagnies.nom FROM ta_compagnies WHERE ta_compagnies.id_compagnie=\'5\'', 'La table \'base_tourisme.ta_compagnies\' n\'existe pas', 1146, 1, '192.168.4.2', '/tourisme/base/config/crud/index.php?table_name=ta_vols&title=Vols&id_menu=8'),
(268, '2022-06-11 15:01:15', 'SELECT compagnies.nom FROM ta_compagnies WHERE ta_compagnies.id_compagnie=\'6\'', 'La table \'base_tourisme.ta_compagnies\' n\'existe pas', 1146, 1, '192.168.4.2', '/tourisme/base/config/crud/index.php?table_name=ta_vols&title=Vols&id_menu=8'),
(269, '2022-06-11 15:01:15', 'SELECT * FROM ta_compagnies WHERE id_compagnie=\'1\'', 'La table \'base_tourisme.ta_compagnies\' n\'existe pas', 1146, 0, '192.168.4.2', '/tourisme/base/config/crud/json.php?title=Vols&table_name=ta_vols&id_compagnie=1'),
(270, '2022-06-11 15:01:15', 'SELECT * FROM ta_compagnies WHERE id_compagnie=\'3\'', 'La table \'base_tourisme.ta_compagnies\' n\'existe pas', 1146, 0, '192.168.4.2', '/tourisme/base/config/crud/json.php?title=Vols&table_name=ta_vols&id_compagnie=3'),
(271, '2022-06-11 15:01:15', 'SELECT * FROM ta_compagnies WHERE id_compagnie=\'2\'', 'La table \'base_tourisme.ta_compagnies\' n\'existe pas', 1146, 0, '192.168.4.2', '/tourisme/base/config/crud/json.php?title=Vols&table_name=ta_vols&id_compagnie=2'),
(272, '2022-06-11 15:01:15', 'SELECT * FROM ta_compagnies WHERE id_compagnie=\'2\'', 'La table \'base_tourisme.ta_compagnies\' n\'existe pas', 1146, 0, '192.168.4.2', '/tourisme/base/config/crud/json.php?title=Vols&table_name=ta_vols&id_compagnie=2'),
(273, '2022-06-11 15:01:15', 'SELECT * FROM ta_compagnies WHERE id_compagnie=\'3\'', 'La table \'base_tourisme.ta_compagnies\' n\'existe pas', 1146, 0, '192.168.4.2', '/tourisme/base/config/crud/json.php?title=Vols&table_name=ta_vols&id_compagnie=3'),
(274, '2022-06-11 15:01:15', 'SELECT * FROM ta_compagnies WHERE id_compagnie=\'1\'', 'La table \'base_tourisme.ta_compagnies\' n\'existe pas', 1146, 0, '192.168.4.2', '/tourisme/base/config/crud/json.php?title=Vols&table_name=ta_vols&id_compagnie=1'),
(275, '2022-06-11 15:01:15', 'SELECT * FROM ta_compagnies WHERE id_compagnie=\'3\'', 'La table \'base_tourisme.ta_compagnies\' n\'existe pas', 1146, 0, '192.168.4.2', '/tourisme/base/config/crud/json.php?title=Vols&table_name=ta_vols&id_compagnie=3'),
(276, '2022-06-11 15:01:15', 'SELECT * FROM ta_compagnies WHERE id_compagnie=\'2\'', 'La table \'base_tourisme.ta_compagnies\' n\'existe pas', 1146, 0, '192.168.4.2', '/tourisme/base/config/crud/json.php?title=Vols&table_name=ta_vols&id_compagnie=2'),
(277, '2022-06-11 15:01:15', 'SELECT * FROM ta_compagnies WHERE id_compagnie=\'3\'', 'La table \'base_tourisme.ta_compagnies\' n\'existe pas', 1146, 0, '192.168.4.2', '/tourisme/base/config/crud/json.php?title=Vols&table_name=ta_vols&id_compagnie=3'),
(278, '2022-06-11 15:01:15', 'SELECT * FROM ta_compagnies WHERE id_compagnie=\'2\'', 'La table \'base_tourisme.ta_compagnies\' n\'existe pas', 1146, 0, '192.168.4.2', '/tourisme/base/config/crud/json.php?title=Vols&table_name=ta_vols&id_compagnie=2'),
(279, '2022-06-11 15:01:15', 'SELECT * FROM ta_compagnies WHERE id_compagnie=\'3\'', 'La table \'base_tourisme.ta_compagnies\' n\'existe pas', 1146, 0, '192.168.4.2', '/tourisme/base/config/crud/json.php?title=Vols&table_name=ta_vols&id_compagnie=3'),
(280, '2022-06-11 15:01:15', 'SELECT * FROM ta_compagnies WHERE id_compagnie=\'2\'', 'La table \'base_tourisme.ta_compagnies\' n\'existe pas', 1146, 0, '192.168.4.2', '/tourisme/base/config/crud/json.php?title=Vols&table_name=ta_vols&id_compagnie=2'),
(281, '2022-06-11 15:01:15', 'SELECT * FROM ta_compagnies WHERE id_compagnie=\'3\'', 'La table \'base_tourisme.ta_compagnies\' n\'existe pas', 1146, 0, '192.168.4.2', '/tourisme/base/config/crud/json.php?title=Vols&table_name=ta_vols&id_compagnie=3'),
(282, '2022-06-11 15:01:15', 'SELECT * FROM ta_compagnies WHERE id_compagnie=\'2\'', 'La table \'base_tourisme.ta_compagnies\' n\'existe pas', 1146, 0, '192.168.4.2', '/tourisme/base/config/crud/json.php?title=Vols&table_name=ta_vols&id_compagnie=2'),
(283, '2022-06-11 15:01:15', 'SELECT * FROM ta_compagnies WHERE id_compagnie=\'3\'', 'La table \'base_tourisme.ta_compagnies\' n\'existe pas', 1146, 0, '192.168.4.2', '/tourisme/base/config/crud/json.php?title=Vols&table_name=ta_vols&id_compagnie=3'),
(284, '2022-06-11 15:01:15', 'SELECT * FROM ta_compagnies WHERE id_compagnie=\'2\'', 'La table \'base_tourisme.ta_compagnies\' n\'existe pas', 1146, 0, '192.168.4.2', '/tourisme/base/config/crud/json.php?title=Vols&table_name=ta_vols&id_compagnie=2'),
(285, '2022-06-11 15:01:15', 'SELECT * FROM ta_compagnies WHERE id_compagnie=\'3\'', 'La table \'base_tourisme.ta_compagnies\' n\'existe pas', 1146, 0, '192.168.4.2', '/tourisme/base/config/crud/json.php?title=Vols&table_name=ta_vols&id_compagnie=3'),
(286, '2022-06-11 15:01:15', 'SELECT * FROM ta_compagnies WHERE id_compagnie=\'2\'', 'La table \'base_tourisme.ta_compagnies\' n\'existe pas', 1146, 0, '192.168.4.2', '/tourisme/base/config/crud/json.php?title=Vols&table_name=ta_vols&id_compagnie=2'),
(287, '2022-06-11 15:01:15', 'SELECT * FROM ta_compagnies WHERE id_compagnie=\'4\'', 'La table \'base_tourisme.ta_compagnies\' n\'existe pas', 1146, 0, '192.168.4.2', '/tourisme/base/config/crud/json.php?title=Vols&table_name=ta_vols&id_compagnie=4'),
(288, '2022-06-11 15:01:15', 'SELECT * FROM ta_compagnies WHERE id_compagnie=\'3\'', 'La table \'base_tourisme.ta_compagnies\' n\'existe pas', 1146, 0, '192.168.4.2', '/tourisme/base/config/crud/json.php?title=Vols&table_name=ta_vols&id_compagnie=3'),
(289, '2022-06-11 15:01:15', 'SELECT * FROM ta_compagnies WHERE id_compagnie=\'2\'', 'La table \'base_tourisme.ta_compagnies\' n\'existe pas', 1146, 0, '192.168.4.2', '/tourisme/base/config/crud/json.php?title=Vols&table_name=ta_vols&id_compagnie=2'),
(290, '2022-06-11 15:01:15', 'SELECT * FROM ta_compagnies WHERE id_compagnie=\'4\'', 'La table \'base_tourisme.ta_compagnies\' n\'existe pas', 1146, 0, '192.168.4.2', '/tourisme/base/config/crud/json.php?title=Vols&table_name=ta_vols&id_compagnie=4'),
(291, '2022-06-11 15:01:15', 'SELECT * FROM ta_compagnies WHERE id_compagnie=\'2\'', 'La table \'base_tourisme.ta_compagnies\' n\'existe pas', 1146, 0, '192.168.4.2', '/tourisme/base/config/crud/json.php?title=Vols&table_name=ta_vols&id_compagnie=2'),
(292, '2022-06-11 15:01:15', 'SELECT * FROM ta_compagnies WHERE id_compagnie=\'3\'', 'La table \'base_tourisme.ta_compagnies\' n\'existe pas', 1146, 0, '192.168.4.2', '/tourisme/base/config/crud/json.php?title=Vols&table_name=ta_vols&id_compagnie=3'),
(293, '2022-06-11 15:01:15', 'SELECT * FROM ta_compagnies WHERE id_compagnie=\'3\'', 'La table \'base_tourisme.ta_compagnies\' n\'existe pas', 1146, 0, '192.168.4.2', '/tourisme/base/config/crud/json.php?title=Vols&table_name=ta_vols&id_compagnie=3'),
(294, '2022-06-11 15:01:15', 'SELECT * FROM ta_compagnies WHERE id_compagnie=\'3\'', 'La table \'base_tourisme.ta_compagnies\' n\'existe pas', 1146, 0, '192.168.4.2', '/tourisme/base/config/crud/json.php?title=Vols&table_name=ta_vols&id_compagnie=3'),
(295, '2022-06-11 15:01:15', 'SELECT * FROM ta_compagnies WHERE id_compagnie=\'5\'', 'La table \'base_tourisme.ta_compagnies\' n\'existe pas', 1146, 0, '192.168.4.2', '/tourisme/base/config/crud/json.php?title=Vols&table_name=ta_vols&id_compagnie=5'),
(296, '2022-06-11 15:01:15', 'SELECT * FROM ta_compagnies WHERE id_compagnie=\'5\'', 'La table \'base_tourisme.ta_compagnies\' n\'existe pas', 1146, 0, '192.168.4.2', '/tourisme/base/config/crud/json.php?title=Vols&table_name=ta_vols&id_compagnie=5'),
(297, '2022-06-11 15:01:15', 'SELECT * FROM ta_compagnies WHERE id_compagnie=\'6\'', 'La table \'base_tourisme.ta_compagnies\' n\'existe pas', 1146, 0, '192.168.4.2', '/tourisme/base/config/crud/json.php?title=Vols&table_name=ta_vols&id_compagnie=6'),
(298, '2022-06-11 15:01:15', 'SELECT * FROM ta_compagnies WHERE id_compagnie=\'6\'', 'La table \'base_tourisme.ta_compagnies\' n\'existe pas', 1146, 0, '192.168.4.2', '/tourisme/base/config/crud/json.php?title=Vols&table_name=ta_vols&id_compagnie=6'),
(299, '2022-06-11 15:01:33', 'SELECT ta_compagnies.nom FROM ta_compagnies WHERE ta_compagnies.id_compagnie=\'1\'', 'La table \'base_tourisme.ta_compagnies\' n\'existe pas', 1146, 1, '192.168.4.2', '/tourisme/base/config/crud/index.php?table_name=ta_vols&title=Vols&id_menu=8'),
(300, '2022-06-11 15:01:33', 'SELECT ta_compagnies.nom FROM ta_compagnies WHERE ta_compagnies.id_compagnie=\'2\'', 'La table \'base_tourisme.ta_compagnies\' n\'existe pas', 1146, 1, '192.168.4.2', '/tourisme/base/config/crud/index.php?table_name=ta_vols&title=Vols&id_menu=8'),
(301, '2022-06-11 15:01:33', 'SELECT ta_compagnies.nom FROM ta_compagnies WHERE ta_compagnies.id_compagnie=\'3\'', 'La table \'base_tourisme.ta_compagnies\' n\'existe pas', 1146, 1, '192.168.4.2', '/tourisme/base/config/crud/index.php?table_name=ta_vols&title=Vols&id_menu=8'),
(302, '2022-06-11 15:01:33', 'SELECT ta_compagnies.nom FROM ta_compagnies WHERE ta_compagnies.id_compagnie=\'4\'', 'La table \'base_tourisme.ta_compagnies\' n\'existe pas', 1146, 1, '192.168.4.2', '/tourisme/base/config/crud/index.php?table_name=ta_vols&title=Vols&id_menu=8'),
(303, '2022-06-11 15:01:33', 'SELECT ta_compagnies.nom FROM ta_compagnies WHERE ta_compagnies.id_compagnie=\'5\'', 'La table \'base_tourisme.ta_compagnies\' n\'existe pas', 1146, 1, '192.168.4.2', '/tourisme/base/config/crud/index.php?table_name=ta_vols&title=Vols&id_menu=8'),
(304, '2022-06-11 15:01:33', 'SELECT ta_compagnies.nom FROM ta_compagnies WHERE ta_compagnies.id_compagnie=\'6\'', 'La table \'base_tourisme.ta_compagnies\' n\'existe pas', 1146, 1, '192.168.4.2', '/tourisme/base/config/crud/index.php?table_name=ta_vols&title=Vols&id_menu=8'),
(305, '2022-06-11 15:01:33', 'SELECT * FROM ta_compagnies WHERE id_compagnie=\'2\'', 'La table \'base_tourisme.ta_compagnies\' n\'existe pas', 1146, 0, '192.168.4.2', '/tourisme/base/config/crud/json.php?title=Vols&table_name=ta_vols&id_compagnie=2'),
(306, '2022-06-11 15:01:33', 'SELECT * FROM ta_compagnies WHERE id_compagnie=\'1\'', 'La table \'base_tourisme.ta_compagnies\' n\'existe pas', 1146, 0, '192.168.4.2', '/tourisme/base/config/crud/json.php?title=Vols&table_name=ta_vols&id_compagnie=1'),
(307, '2022-06-11 15:01:33', 'SELECT * FROM ta_compagnies WHERE id_compagnie=\'2\'', 'La table \'base_tourisme.ta_compagnies\' n\'existe pas', 1146, 0, '192.168.4.2', '/tourisme/base/config/crud/json.php?title=Vols&table_name=ta_vols&id_compagnie=2'),
(308, '2022-06-11 15:01:33', 'SELECT * FROM ta_compagnies WHERE id_compagnie=\'1\'', 'La table \'base_tourisme.ta_compagnies\' n\'existe pas', 1146, 0, '192.168.4.2', '/tourisme/base/config/crud/json.php?title=Vols&table_name=ta_vols&id_compagnie=1'),
(309, '2022-06-11 15:01:33', 'SELECT * FROM ta_compagnies WHERE id_compagnie=\'2\'', 'La table \'base_tourisme.ta_compagnies\' n\'existe pas', 1146, 0, '192.168.4.2', '/tourisme/base/config/crud/json.php?title=Vols&table_name=ta_vols&id_compagnie=2'),
(310, '2022-06-11 15:01:33', 'SELECT * FROM ta_compagnies WHERE id_compagnie=\'3\'', 'La table \'base_tourisme.ta_compagnies\' n\'existe pas', 1146, 0, '192.168.4.2', '/tourisme/base/config/crud/json.php?title=Vols&table_name=ta_vols&id_compagnie=3'),
(311, '2022-06-11 15:01:33', 'SELECT * FROM ta_compagnies WHERE id_compagnie=\'2\'', 'La table \'base_tourisme.ta_compagnies\' n\'existe pas', 1146, 0, '192.168.4.2', '/tourisme/base/config/crud/json.php?title=Vols&table_name=ta_vols&id_compagnie=2'),
(312, '2022-06-11 15:01:33', 'SELECT * FROM ta_compagnies WHERE id_compagnie=\'3\'', 'La table \'base_tourisme.ta_compagnies\' n\'existe pas', 1146, 0, '192.168.4.2', '/tourisme/base/config/crud/json.php?title=Vols&table_name=ta_vols&id_compagnie=3'),
(313, '2022-06-11 15:01:33', 'SELECT * FROM ta_compagnies WHERE id_compagnie=\'2\'', 'La table \'base_tourisme.ta_compagnies\' n\'existe pas', 1146, 0, '192.168.4.2', '/tourisme/base/config/crud/json.php?title=Vols&table_name=ta_vols&id_compagnie=2'),
(314, '2022-06-11 15:01:33', 'SELECT * FROM ta_compagnies WHERE id_compagnie=\'3\'', 'La table \'base_tourisme.ta_compagnies\' n\'existe pas', 1146, 0, '192.168.4.2', '/tourisme/base/config/crud/json.php?title=Vols&table_name=ta_vols&id_compagnie=3'),
(315, '2022-06-11 15:01:33', 'SELECT * FROM ta_compagnies WHERE id_compagnie=\'2\'', 'La table \'base_tourisme.ta_compagnies\' n\'existe pas', 1146, 0, '192.168.4.2', '/tourisme/base/config/crud/json.php?title=Vols&table_name=ta_vols&id_compagnie=2'),
(316, '2022-06-11 15:01:33', 'SELECT * FROM ta_compagnies WHERE id_compagnie=\'3\'', 'La table \'base_tourisme.ta_compagnies\' n\'existe pas', 1146, 0, '192.168.4.2', '/tourisme/base/config/crud/json.php?title=Vols&table_name=ta_vols&id_compagnie=3'),
(317, '2022-06-11 15:01:33', 'SELECT * FROM ta_compagnies WHERE id_compagnie=\'2\'', 'La table \'base_tourisme.ta_compagnies\' n\'existe pas', 1146, 0, '192.168.4.2', '/tourisme/base/config/crud/json.php?title=Vols&table_name=ta_vols&id_compagnie=2'),
(318, '2022-06-11 15:01:33', 'SELECT * FROM ta_compagnies WHERE id_compagnie=\'3\'', 'La table \'base_tourisme.ta_compagnies\' n\'existe pas', 1146, 0, '192.168.4.2', '/tourisme/base/config/crud/json.php?title=Vols&table_name=ta_vols&id_compagnie=3'),
(319, '2022-06-11 15:01:33', 'SELECT * FROM ta_compagnies WHERE id_compagnie=\'2\'', 'La table \'base_tourisme.ta_compagnies\' n\'existe pas', 1146, 0, '192.168.4.2', '/tourisme/base/config/crud/json.php?title=Vols&table_name=ta_vols&id_compagnie=2'),
(320, '2022-06-11 15:01:33', 'SELECT * FROM ta_compagnies WHERE id_compagnie=\'3\'', 'La table \'base_tourisme.ta_compagnies\' n\'existe pas', 1146, 0, '192.168.4.2', '/tourisme/base/config/crud/json.php?title=Vols&table_name=ta_vols&id_compagnie=3'),
(321, '2022-06-11 15:01:33', 'SELECT * FROM ta_compagnies WHERE id_compagnie=\'2\'', 'La table \'base_tourisme.ta_compagnies\' n\'existe pas', 1146, 0, '192.168.4.2', '/tourisme/base/config/crud/json.php?title=Vols&table_name=ta_vols&id_compagnie=2'),
(322, '2022-06-11 15:01:33', 'SELECT * FROM ta_compagnies WHERE id_compagnie=\'2\'', 'La table \'base_tourisme.ta_compagnies\' n\'existe pas', 1146, 0, '192.168.4.2', '/tourisme/base/config/crud/json.php?title=Vols&table_name=ta_vols&id_compagnie=2'),
(323, '2022-06-11 15:01:33', 'SELECT * FROM ta_compagnies WHERE id_compagnie=\'3\'', 'La table \'base_tourisme.ta_compagnies\' n\'existe pas', 1146, 0, '192.168.4.2', '/tourisme/base/config/crud/json.php?title=Vols&table_name=ta_vols&id_compagnie=3'),
(324, '2022-06-11 15:01:33', 'SELECT * FROM ta_compagnies WHERE id_compagnie=\'3\'', 'La table \'base_tourisme.ta_compagnies\' n\'existe pas', 1146, 0, '192.168.4.2', '/tourisme/base/config/crud/json.php?title=Vols&table_name=ta_vols&id_compagnie=3'),
(325, '2022-06-11 15:01:33', 'SELECT * FROM ta_compagnies WHERE id_compagnie=\'3\'', 'La table \'base_tourisme.ta_compagnies\' n\'existe pas', 1146, 0, '192.168.4.2', '/tourisme/base/config/crud/json.php?title=Vols&table_name=ta_vols&id_compagnie=3'),
(326, '2022-06-11 15:01:33', 'SELECT * FROM ta_compagnies WHERE id_compagnie=\'3\'', 'La table \'base_tourisme.ta_compagnies\' n\'existe pas', 1146, 0, '192.168.4.2', '/tourisme/base/config/crud/json.php?title=Vols&table_name=ta_vols&id_compagnie=3'),
(327, '2022-06-11 15:01:33', 'SELECT * FROM ta_compagnies WHERE id_compagnie=\'3\'', 'La table \'base_tourisme.ta_compagnies\' n\'existe pas', 1146, 0, '192.168.4.2', '/tourisme/base/config/crud/json.php?title=Vols&table_name=ta_vols&id_compagnie=3'),
(328, '2022-06-11 15:01:33', 'SELECT * FROM ta_compagnies WHERE id_compagnie=\'3\'', 'La table \'base_tourisme.ta_compagnies\' n\'existe pas', 1146, 0, '192.168.4.2', '/tourisme/base/config/crud/json.php?title=Vols&table_name=ta_vols&id_compagnie=3'),
(329, '2022-06-11 15:01:33', 'SELECT * FROM ta_compagnies WHERE id_compagnie=\'4\'', 'La table \'base_tourisme.ta_compagnies\' n\'existe pas', 1146, 0, '192.168.4.2', '/tourisme/base/config/crud/json.php?title=Vols&table_name=ta_vols&id_compagnie=4'),
(330, '2022-06-11 15:01:33', 'SELECT * FROM ta_compagnies WHERE id_compagnie=\'5\'', 'La table \'base_tourisme.ta_compagnies\' n\'existe pas', 1146, 0, '192.168.4.2', '/tourisme/base/config/crud/json.php?title=Vols&table_name=ta_vols&id_compagnie=5'),
(331, '2022-06-11 15:01:33', 'SELECT * FROM ta_compagnies WHERE id_compagnie=\'5\'', 'La table \'base_tourisme.ta_compagnies\' n\'existe pas', 1146, 0, '192.168.4.2', '/tourisme/base/config/crud/json.php?title=Vols&table_name=ta_vols&id_compagnie=5'),
(332, '2022-06-11 15:01:33', 'SELECT * FROM ta_compagnies WHERE id_compagnie=\'6\'', 'La table \'base_tourisme.ta_compagnies\' n\'existe pas', 1146, 0, '192.168.4.2', '/tourisme/base/config/crud/json.php?title=Vols&table_name=ta_vols&id_compagnie=6'),
(333, '2022-06-11 15:01:33', 'SELECT * FROM ta_compagnies WHERE id_compagnie=\'4\'', 'La table \'base_tourisme.ta_compagnies\' n\'existe pas', 1146, 0, '192.168.4.2', '/tourisme/base/config/crud/json.php?title=Vols&table_name=ta_vols&id_compagnie=4'),
(334, '2022-06-11 15:01:33', 'SELECT * FROM ta_compagnies WHERE id_compagnie=\'6\'', 'La table \'base_tourisme.ta_compagnies\' n\'existe pas', 1146, 0, '192.168.4.2', '/tourisme/base/config/crud/json.php?title=Vols&table_name=ta_vols&id_compagnie=6'),
(335, '2022-06-11 15:01:38', 'SELECT * FROM ta_compagnies', 'La table \'base_tourisme.ta_compagnies\' n\'existe pas', 1146, 1, '192.168.4.2', '/tourisme/base/config/crud/index.php?table_name=ta_compagnies&title=Vols&id_menu=9'),
(336, '2022-06-11 15:01:39', 'SELECT *\r\n		FROM ta_compagnies\r\n		WHERE 1=1 \r\n		', 'La table \'base_tourisme.ta_compagnies\' n\'existe pas', 1146, 0, '192.168.4.2', '/tourisme/base/config/crud/json.php?title=Vols&table_name=ta_compagnies');

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

--
-- Structure de la table `log_sql_numrows`
--

CREATE TABLE IF NOT EXISTS `log_sql_numrows` (
  `id_log_sql_numrow` int NOT NULL AUTO_INCREMENT,
  `datetime` datetime NOT NULL,
  `line` int NOT NULL,
  `field` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `id_personnel` int DEFAULT NULL,
  `adresse_ip_client` varchar(15) NOT NULL,
  `file` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  PRIMARY KEY (`id_log_sql_numrow`),
  KEY `date_heure` (`datetime`),
  KEY `adresse_ip_client` (`adresse_ip_client`),
  KEY `id_personnel` (`id_personnel`),
  KEY `file` (`file`) USING BTREE,
  KEY `field` (`field`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=89 DEFAULT CHARSET=utf8;

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

--
-- Structure de la table `personnel_services`
--

CREATE TABLE IF NOT EXISTS `personnel_services` (
  `id_personnel` int NOT NULL,
  `id_service` int NOT NULL,
  PRIMARY KEY (`id_personnel`,`id_service`),
  KEY `id_service` (`id_service`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

INSERT INTO `personnel_services` (`id_personnel`, `id_service`) VALUES
(1, 1),
(1, 2),
(1, 3),
(1, 4);

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

--
-- Structure de la table `services`
--

CREATE TABLE IF NOT EXISTS `services` (
  `id_service` int NOT NULL AUTO_INCREMENT,
  `service` varchar(40) NOT NULL,
  `url` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id_service`),
  KEY `service` (`service`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

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

INSERT INTO `services` (`id_service`, `service`, `url`) VALUES
(1, 'Administrateur', '/tourisme/base/config/crud/index.php?table_name=personnel_services&title=Modèles'),
(2, 'Réservation', NULL),
(3, 'Informatique', NULL),
(4, 'Traffice aérien', NULL);

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

--
-- Structure de la table `services_menus`
--

CREATE TABLE IF NOT EXISTS `services_menus` (
  `id_menu` int NOT NULL AUTO_INCREMENT,
  `id_service` int NOT NULL,
  `menu` varchar(255) NOT NULL,
  `url` varchar(255) NOT NULL,
  PRIMARY KEY (`id_menu`),
  KEY `id_service` (`id_service`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;

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

INSERT INTO `services_menus` (`id_menu`, `id_service`, `menu`, `url`) VALUES
(1, 2, 'Hotels', '/tourisme/base/config/crud/index.php?table_name=gh_hotels&title=Hotels'),
(2, 2, 'Clients', '/tourisme/base/config/crud/index.php?table_name=gh_clients&title=Clients'),
(3, 2, 'Hotels', '/tourisme/base/reservation/index.php'),
(4, 3, 'Monitoring', '/tourisme/base/service_informatique/monitoring/index.php'),
(5, 3, 'Bibliothèques', '/tourisme/base/service_informatique/libraries/index.php'),
(6, 3, '<i class=\"bi bi-server fa-lg\"></i>', '/tourisme/base/service_informatique/base_de_donnee/index.php'),
(7, 3, 'Sauvegarde', '/tourisme/base/service_informatique/file_cabinet/index.php?id_usage=backup'),
(8, 4, 'Vols', '/tourisme/base/config/crud/index.php?table_name=ta_vols&title=Vols'),
(9, 4, 'Compagnies', '/tourisme/base/config/crud/index.php?table_name=ta_compagnies&title=Vols'),
(10, 4, 'Aéroports', '/tourisme/base/config/crud/index.php?table_name=ta_aeroports&title=Vols');

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

--
-- Structure de la table `services_ss_menus`
--

CREATE TABLE IF NOT EXISTS `services_ss_menus` (
  `id_ss_menu` int NOT NULL AUTO_INCREMENT,
  `id_menu` int NOT NULL,
  `ss_menu` varchar(255) NOT NULL,
  `categorie` varchar(255) NOT NULL,
  `url` varchar(255) NOT NULL,
  PRIMARY KEY (`id_ss_menu`),
  KEY `id_menu` (`id_menu`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Structure de la table `ta_aeroports`
--

CREATE TABLE IF NOT EXISTS `ta_aeroports` (
  `id_aeroport` int NOT NULL AUTO_INCREMENT,
  `nom` varchar(100) NOT NULL,
  `iata_code` char(3) NOT NULL,
  PRIMARY KEY (`id_aeroport`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;

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

INSERT INTO `ta_aeroports` (`id_aeroport`, `nom`, `iata_code`) VALUES
(1, 'Antananarivo', 'TNR'),
(2, 'Dzaoudzi', 'DZA'),
(3, 'Johannesbourg', 'JNB'),
(4, 'Marseille', 'MRS'),
(5, 'Maurice', 'MRU'),
(6, 'Nosy-Be', 'NOS'),
(7, 'Paris CDG', 'CDG'),
(8, 'Paris Orly', 'ORY');

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

--
-- Structure de la table `ta_compagnies`
--

CREATE TABLE IF NOT EXISTS `ta_compagnies` (
  `id_compagnie` int UNSIGNED NOT NULL AUTO_INCREMENT,
  `nom` varchar(50) NOT NULL,
  `pdg` varchar(50) DEFAULT NULL,
  `nb_appareil` int UNSIGNED NOT NULL,
  `pays` varchar(50) NOT NULL,
  `remarque` text,
  `logo` varchar(50) DEFAULT NULL,
  `url` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id_compagnie`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;

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

INSERT INTO `ta_compagnies` (`id_compagnie`, `nom`, `pdg`, `nb_appareil`, `pays`, `remarque`, `logo`, `url`) VALUES
(1, 'Air France', 'Jean-Cyril Spinetta', 364, 'France', NULL, 'air_france.png', 'http://www.airfrance.fr/'),
(2, 'Air Mauritius', 'Arjoon Sudhoo', 5, 'Ile maurice', NULL, 'air_mauritius.png', 'http://www.airmauritius.com/'),
(3, 'Air Austral', 'Gérard Etheve', 6, 'France', NULL, 'air_austral.png', 'http://www.airaustral.com/'),
(4, 'Air Bourbon', 'Erik Lazarus', 1, 'France', 'Faillite', 'air_bourbon.svg', 'http://www.airbourbon.com/'),
(5, 'Air Madagascar', NULL, 12, 'Madagascar', NULL, 'air_madagascar.png', 'http://www.airmadagascar.mg/'),
(6, 'Corsair', 'Ralf Corsten', 9, 'France', NULL, 'corsair.png', 'http://www.corsair.fr/'),
(7, 'Air Seychelles', NULL, 8, 'Seychelles', NULL, 'air_seychelles.png', 'http://www.air-seychelles.fr/');

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

--
-- Structure de la table `ta_vols`
--

CREATE TABLE IF NOT EXISTS `ta_vols` (
  `id_vol` int UNSIGNED NOT NULL AUTO_INCREMENT,
  `type_avion` varchar(50) NOT NULL,
  `id_compagnie` int UNSIGNED NOT NULL,
  `numero_vol` varchar(10) NOT NULL,
  `de_vers` int NOT NULL,
  `arrivee_depart` enum('Arrivée','Départ') NOT NULL,
  `horaire` datetime NOT NULL,
  `observation` text,
  PRIMARY KEY (`id_vol`),
  KEY `vols_Index1` (`numero_vol`),
  KEY `vols_FKIndex1` (`id_compagnie`),
  KEY `de_vers` (`de_vers`)
) ENGINE=InnoDB AUTO_INCREMENT=33 DEFAULT CHARSET=utf8;

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

INSERT INTO `ta_vols` (`id_vol`, `type_avion`, `id_compagnie`, `numero_vol`, `de_vers`, `arrivee_depart`, `horaire`, `observation`) VALUES
(1, 'B747', 6, 'SS911', 8, 'Départ', '2004-11-28 08:05:00', 'A décollé'),
(2, 'ATR42', 2, 'MK213', 5, 'Départ', '2004-11-28 10:00:00', 'A décollé'),
(3, 'B737', 3, 'UU203', 2, 'Départ', '2004-11-28 10:50:00', 'A décollé'),
(4, 'B737', 3, 'UU371', 3, 'Départ', '2004-11-28 11:05:00', 'A décollé'),
(5, 'ATR42', 2, 'MK223', 5, 'Départ', '2004-11-28 12:30:00', NULL),
(6, 'ATR72', 2, 'MK231', 5, 'Départ', '2004-11-28 13:00:00', NULL),
(7, 'B737', 3, 'UU210', 2, 'Départ', '2004-11-28 13:45:00', NULL),
(8, 'A319', 2, 'MK229', 5, 'Départ', '2004-11-28 14:55:00', NULL),
(9, 'ATR72', 3, 'UU104', 5, 'Départ', '2004-11-28 15:20:00', NULL),
(10, 'B737', 3, 'UU108', 5, 'Départ', '2004-11-28 17:00:00', NULL),
(11, 'B737', 5, 'MD191', 1, 'Départ', '2004-11-28 17:15:00', NULL),
(12, 'ATR42', 2, 'MK251', 5, 'Départ', '2004-11-28 17:50:00', NULL),
(13, 'B777', 3, 'UU975', 7, 'Départ', '2004-11-28 21:00:00', NULL),
(14, 'B747', 1, 'AF679', 8, 'Départ', '2004-11-28 21:45:00', NULL),
(15, 'A340', 4, 'ZN322', 8, 'Départ', '2004-11-28 22:00:00', 'Annulé'),
(16, 'B747', 6, 'SS910', 8, 'Arrivée', '2004-11-28 05:35:00', 'Est arrivé'),
(17, 'ATR42', 2, 'MK212', 5, 'Arrivée', '2004-11-28 09:30:00', 'Est arrivé'),
(18, 'B777', 3, 'UU974', 7, 'Arrivée', '2004-11-28 09:50:00', 'Est arrivé'),
(19, 'B747', 1, 'AF680', 8, 'Arrivée', '2004-11-28 10:15:00', 'xEst arrivé'),
(20, 'ATR42', 2, 'MK222', 5, 'Arrivée', '2004-11-28 12:00:00', 'Est arrivé'),
(21, 'A340', 4, 'ZN324', 4, 'Arrivée', '2004-11-28 12:15:00', 'Annulé'),
(22, 'ATR72', 2, 'MK230', 5, 'Arrivée', '2004-11-28 12:25:00', NULL),
(23, 'A319', 2, 'MK228', 5, 'Arrivée', '2004-11-28 14:05:00', NULL),
(24, 'ATR72', 3, 'UU105', 5, 'Arrivée', '2004-11-28 14:30:00', NULL),
(25, 'B737', 3, 'UU204', 2, 'Arrivée', '2004-11-28 15:50:00', NULL),
(26, 'B737', 5, 'MD190', 1, 'Arrivée', '2004-11-28 16:15:00', NULL),
(27, 'ATR42', 2, 'MK250', 5, 'Arrivée', '2004-11-28 17:20:00', NULL),
(28, 'B737', 3, 'UU109', 5, 'Arrivée', '2004-11-28 19:05:00', NULL),
(29, 'B737', 3, 'UU210', 6, 'Arrivée', '2004-11-28 20:00:00', NULL),
(30, 'B737', 3, 'UU372', 3, 'Arrivée', '2004-11-28 20:15:00', NULL);

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

--
-- Contraintes pour la table `files`
--
ALTER TABLE `files`
  ADD CONSTRAINT `files_ibfk_1` FOREIGN KEY (`id_file_parent`) REFERENCES `files` (`id_file`) ON UPDATE CASCADE,
  ADD CONSTRAINT `files_ibfk_2` FOREIGN KEY (`id_usage`) REFERENCES `files_usage` (`id_usage`) ON UPDATE CASCADE;

--
-- Contraintes pour la table `gh_chambres`
--
ALTER TABLE `gh_chambres`
  ADD CONSTRAINT `gh_chambres_ibfk_1` FOREIGN KEY (`id_hotel`) REFERENCES `gh_hotels` (`id_hotel`) ON DELETE RESTRICT ON UPDATE CASCADE;

--
-- Contraintes pour la table `libraries_files`
--
ALTER TABLE `libraries_files`
  ADD CONSTRAINT `libraries_files_ibfk_1` FOREIGN KEY (`id_library`) REFERENCES `libraries` (`id_library`) ON UPDATE CASCADE;

--
-- Contraintes pour la table `libraries_version`
--
ALTER TABLE `libraries_version`
  ADD CONSTRAINT `libraries_version_ibfk_1` FOREIGN KEY (`id_library_file`) REFERENCES `libraries_files` (`id_library_file`) ON UPDATE CASCADE;

--
-- Contraintes pour la table `personnel_services`
--
ALTER TABLE `personnel_services`
  ADD CONSTRAINT `personnel_services_ibfk_1` FOREIGN KEY (`id_personnel`) REFERENCES `personnel` (`id_personnel`) ON UPDATE CASCADE,
  ADD CONSTRAINT `personnel_services_ibfk_2` FOREIGN KEY (`id_service`) REFERENCES `services` (`id_service`) ON UPDATE CASCADE;

--
-- Contraintes pour la table `services_menus`
--
ALTER TABLE `services_menus`
  ADD CONSTRAINT `services_menus_ibfk_1` FOREIGN KEY (`id_service`) REFERENCES `services` (`id_service`) ON DELETE RESTRICT ON UPDATE CASCADE;

--
-- Contraintes pour la table `services_ss_menus`
--
ALTER TABLE `services_ss_menus`
  ADD CONSTRAINT `services_ss_menus_ibfk_1` FOREIGN KEY (`id_menu`) REFERENCES `services_menus` (`id_menu`) ON DELETE RESTRICT ON UPDATE CASCADE;

--
-- Contraintes pour la table `ta_vols`
--
ALTER TABLE `ta_vols`
  ADD CONSTRAINT `ta_vols_ibfk_1` FOREIGN KEY (`id_compagnie`) REFERENCES `ta_compagnies` (`id_compagnie`) ON UPDATE CASCADE,
  ADD CONSTRAINT `ta_vols_ibfk_2` FOREIGN KEY (`de_vers`) REFERENCES `ta_aeroports` (`id_aeroport`) ON UPDATE CASCADE;
COMMIT;

