-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Hôte : localhost
-- Généré le : mar. 10 oct. 2023 à 15:35
-- Version du serveur : 8.0.33
-- Version de PHP : 8.2.8

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

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

--
-- Structure de la table `activity`
--

CREATE TABLE `activity` (
  `act_id` int NOT NULL,
  `par_id` int DEFAULT NULL,
  `act_code` varchar(2) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `act_nameFr` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `act_active` tinyint(1) DEFAULT '1',
  `act_createdDate` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `use_idCreator` int DEFAULT NULL,
  `act_updatedDate` datetime DEFAULT NULL,
  `use_idUpdater` int DEFAULT NULL,
  `act_deleted` varchar(1) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT '0',
  `act_correspondance` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `act_nameEn` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `act_estAmountProQuo` double(8,2) DEFAULT NULL,
  `act_estAmountProReq` double(8,2) DEFAULT NULL,
  `act_travaux` tinyint UNSIGNED DEFAULT NULL,
  `act_type` char(1) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `act_color` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `act_colorText` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `act_forPreventive` int NOT NULL DEFAULT '1',
  `act_forCurative` int NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

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

INSERT INTO `activity` (`act_id`, `par_id`, `act_code`, `act_nameFr`, `act_active`, `act_createdDate`, `use_idCreator`, `act_updatedDate`, `use_idUpdater`, `act_deleted`, `act_correspondance`, `act_nameEn`, `act_estAmountProQuo`, `act_estAmountProReq`, `act_travaux`, `act_type`, `act_color`, `act_colorText`, `act_forPreventive`, `act_forCurative`) VALUES
(3, NULL, NULL, 'Preventif majeur année 1', 1, '2023-04-14 14:28:39', NULL, '2023-06-15 09:35:28', 412, '0', NULL, NULL, NULL, NULL, NULL, NULL, '#00fffb', '#000000', 1, 1),
(4, NULL, NULL, 'Preventif majeur année 2', 1, '2023-04-14 14:28:39', NULL, '2023-06-15 09:38:40', 412, '0', NULL, NULL, NULL, NULL, NULL, NULL, '#00ffff', '#000000', 1, 1),
(5, NULL, NULL, 'Preventif majeur année 3', 1, '2023-04-14 14:28:39', NULL, '2023-06-15 09:48:31', 412, '0', NULL, NULL, NULL, NULL, NULL, NULL, '#00ffff', '#000000', 1, 1),
(6, NULL, NULL, 'Preventif majeur année 4', 1, '2023-04-14 14:28:39', NULL, '2023-06-15 09:48:44', 412, '0', NULL, NULL, NULL, NULL, NULL, NULL, '#00ffff', '#000000', 1, 1),
(7, NULL, NULL, 'Preventif majeur année 5', 1, '2023-04-14 14:28:39', NULL, '2023-06-15 09:49:15', 412, '0', NULL, NULL, NULL, NULL, NULL, NULL, '#00ffff', '#000000', 1, 1),
(8, NULL, NULL, 'Preventif majeur année 6', 1, '2023-04-14 14:28:39', NULL, '2023-06-15 09:48:58', 412, '0', NULL, NULL, NULL, NULL, NULL, NULL, '#00ffff', '#000000', 1, 1),
(9, NULL, NULL, 'Preventif majeur année 7', 1, '2023-04-14 14:28:39', NULL, '2023-06-15 09:49:36', 412, '0', NULL, NULL, NULL, NULL, NULL, NULL, '#00ffff', '#000000', 1, 1),
(10, NULL, NULL, 'Preventif majeur année 8', 1, '2023-04-14 14:28:39', NULL, '2023-06-15 09:49:50', 412, '0', NULL, NULL, NULL, NULL, NULL, NULL, '#00fbff', '#000000', 1, 1),
(11, NULL, NULL, 'Preventif majeur année 9', 1, '2023-04-14 14:28:39', NULL, '2023-06-15 09:50:01', 412, '0', NULL, NULL, NULL, NULL, NULL, NULL, '#00ffff', '#000000', 1, 1),
(12, NULL, NULL, 'Preventif majeur année 10', 1, '2023-04-14 14:28:39', NULL, '2023-06-15 09:35:45', 412, '0', NULL, NULL, NULL, NULL, NULL, NULL, '#33ffff', '#000000', 1, 1),
(13, NULL, NULL, 'Preventif majeur année 11', 1, '2023-04-14 14:28:39', NULL, '2023-06-15 09:35:57', 412, '0', NULL, NULL, NULL, NULL, NULL, NULL, '#00ffff', '#000000', 1, 1),
(14, NULL, NULL, 'Preventif majeur année 12', 1, '2023-04-14 14:28:39', NULL, '2023-06-15 09:36:09', 412, '0', NULL, NULL, NULL, NULL, NULL, NULL, '#00fbff', '#000000', 1, 1),
(15, NULL, NULL, 'Preventif majeur année 13', 1, '2023-04-14 14:28:39', NULL, '2023-06-15 09:36:24', 412, '0', NULL, NULL, NULL, NULL, NULL, NULL, '#00ffff', '#000000', 1, 1),
(16, NULL, NULL, 'Preventif majeur année 14', 1, '2023-04-14 14:28:39', NULL, '2023-06-15 09:36:36', 412, '0', NULL, NULL, NULL, NULL, NULL, NULL, '#00fbff', '#000000', 1, 1),
(17, NULL, NULL, 'Preventif majeur année 15', 1, '2023-04-14 14:28:39', NULL, '2023-06-15 09:36:49', 412, '0', NULL, NULL, NULL, NULL, NULL, NULL, '#00ffff', '#000000', 1, 1),
(18, NULL, NULL, 'Preventif majeur année 16', 1, '2023-04-14 14:28:39', NULL, '2023-06-15 09:37:10', 412, '0', NULL, NULL, NULL, NULL, NULL, NULL, '#00ffff', '#000000', 1, 1),
(19, NULL, NULL, 'Preventif majeur année 17', 1, '2023-04-14 14:28:39', NULL, '2023-06-15 09:37:27', 412, '0', NULL, NULL, NULL, NULL, NULL, NULL, '#00fffb', '#000000', 1, 1),
(20, NULL, NULL, 'Preventif majeur année 18', 1, '2023-04-14 14:28:39', NULL, '2023-06-15 09:37:54', 412, '0', NULL, NULL, NULL, NULL, NULL, NULL, '#00ffff', '#000000', 1, 1),
(21, NULL, NULL, 'Preventif majeur année 19', 1, '2023-04-14 14:28:39', NULL, '2023-06-15 09:38:24', 412, '0', NULL, NULL, NULL, NULL, NULL, NULL, '#00ffff', '#000000', 1, 1),
(22, NULL, NULL, 'Preventif majeur année 20', 1, '2023-04-14 14:28:39', NULL, '2023-06-15 09:39:07', 412, '0', NULL, NULL, NULL, NULL, NULL, NULL, '#00ffff', '#000000', 1, 1),
(23, NULL, NULL, 'Preventif mineur année 1', 1, '2023-04-14 14:28:39', NULL, '2023-06-15 10:01:23', 412, '0', NULL, NULL, NULL, NULL, NULL, NULL, '#940000', '#ffffff', 1, 1),
(24, NULL, NULL, 'Preventif mineur année 22', 1, '2023-04-14 14:28:39', NULL, '2023-07-04 11:05:22', 412, '0', NULL, NULL, NULL, NULL, NULL, NULL, '#940000', '#ffffff', 1, 1),
(25, NULL, NULL, 'Preventif mineur année 3', 1, '2023-04-14 14:28:39', NULL, '2023-06-15 11:37:21', 412, '0', NULL, NULL, NULL, NULL, NULL, NULL, '#940000', '#ffffff', 1, 1),
(26, NULL, NULL, 'Preventif mineur année 4', 1, '2023-04-14 14:28:39', NULL, '2023-06-15 11:37:39', 412, '0', NULL, NULL, NULL, NULL, NULL, NULL, '#940000', '#ffffff', 1, 1),
(27, NULL, NULL, 'Preventif mineur année 5', 1, '2023-04-14 14:28:39', NULL, '2023-06-15 11:37:51', 412, '0', NULL, NULL, NULL, NULL, NULL, NULL, '#940000', '#ffffff', 1, 1),
(28, NULL, NULL, 'Preventif mineur année 6', 1, '2023-04-14 14:28:39', NULL, '2023-06-15 11:38:04', 412, '0', NULL, NULL, NULL, NULL, NULL, NULL, '#940000', '#ffffff', 1, 1),
(29, NULL, NULL, 'Preventif mineur année 7', 1, '2023-04-14 14:28:39', NULL, '2023-06-15 11:38:24', 412, '0', NULL, NULL, NULL, NULL, NULL, NULL, '#940000', '#ffffff', 1, 1),
(30, NULL, NULL, 'Preventif mineur année 8', 1, '2023-04-14 14:28:39', NULL, '2023-06-15 11:38:41', 412, '0', NULL, NULL, NULL, NULL, NULL, NULL, '#940000', '#ffffff', 1, 1),
(31, NULL, NULL, 'Preventif mineur année 9', 1, '2023-04-14 14:28:39', NULL, '2023-06-15 11:25:35', 412, '0', NULL, NULL, NULL, NULL, NULL, NULL, '#940000', '#ffffff', 1, 1),
(32, NULL, NULL, 'Preventif mineur année 10', 1, '2023-04-14 14:28:39', NULL, '2023-06-15 11:23:57', 412, '0', NULL, NULL, NULL, NULL, NULL, NULL, '#940000', '#ffffff', 1, 1),
(33, NULL, NULL, 'Preventif mineur année 11', 1, '2023-04-14 14:28:39', NULL, '2023-06-15 11:25:00', 412, '0', NULL, NULL, NULL, NULL, NULL, NULL, '#940000', '#ffffff', 1, 1),
(34, NULL, NULL, 'Preventif mineur année 12', 1, '2023-04-14 14:28:39', NULL, '2023-06-15 11:25:09', 412, '0', NULL, NULL, NULL, NULL, NULL, NULL, '#940000', '#ffffff', 1, 1),
(35, NULL, NULL, 'Preventif mineur année 13', 1, '2023-04-14 14:28:39', NULL, '2023-06-15 11:25:22', 412, '0', NULL, NULL, NULL, NULL, NULL, NULL, '#940000', '#ffffff', 1, 1),
(36, NULL, NULL, 'Preventif mineur année 14', 1, '2023-04-14 14:28:39', NULL, '2023-06-15 11:26:49', 412, '0', NULL, NULL, NULL, NULL, NULL, NULL, '#940000', '#ffffff', 1, 1),
(37, NULL, NULL, 'Preventif mineur année 15', 1, '2023-04-14 14:28:39', NULL, '2023-06-15 11:26:04', 412, '0', NULL, NULL, NULL, NULL, NULL, NULL, '#940000', '#ffffff', 1, 1),
(38, NULL, NULL, 'Preventif mineur année 16', 1, '2023-04-14 14:28:39', NULL, '2023-06-15 11:26:56', 412, '0', NULL, NULL, NULL, NULL, NULL, NULL, '#940000', '#ffffff', 1, 1),
(39, NULL, NULL, 'Preventif mineur année 17', 1, '2023-04-14 14:28:39', NULL, '2023-06-15 11:27:12', 412, '0', NULL, NULL, NULL, NULL, NULL, NULL, '#940000', '#ffffff', 1, 1),
(40, NULL, NULL, 'Preventif mineur année 18', 1, '2023-04-14 14:28:39', NULL, '2023-06-15 11:27:22', 412, '0', NULL, NULL, NULL, NULL, NULL, NULL, '#940000', '#ffffff', 1, 1),
(41, NULL, NULL, 'Preventif mineur année 19', 1, '2023-04-14 14:28:39', NULL, '2023-06-15 11:25:53', 412, '0', NULL, NULL, NULL, NULL, NULL, NULL, '#940000', '#ffffff', 1, 1),
(42, NULL, NULL, 'Contrôle reglementaire 6m', 1, '2023-04-14 14:28:39', NULL, '2023-06-15 09:30:36', 412, '0', NULL, NULL, NULL, NULL, NULL, NULL, '#b9ff33', '#000000', 1, 1),
(43, NULL, NULL, 'Inspection pales', 1, '2023-04-14 14:28:39', NULL, '2023-06-15 09:32:15', 412, '0', NULL, NULL, NULL, NULL, NULL, NULL, '#0037ff', '#ffffff', 1, 1),
(44, NULL, NULL, 'Correctif pales', 1, '2023-04-14 14:28:39', NULL, '2023-06-15 09:31:31', 412, '0', NULL, NULL, NULL, NULL, NULL, NULL, '#0037ff', '#ffffff', 1, 1),
(45, NULL, NULL, 'Vidange GB', 1, '2023-04-14 14:28:39', NULL, '2023-06-15 11:24:49', 412, '0', NULL, NULL, NULL, NULL, NULL, NULL, '#320a5a', '#ffffff', 1, 1),
(46, NULL, NULL, 'Vidange GH', 1, '2023-04-14 14:28:39', NULL, '2023-06-15 11:24:37', 412, '0', NULL, NULL, NULL, NULL, NULL, NULL, '#320a5a', '#ffffff', 1, 1),
(47, NULL, NULL, 'Preventif MT', 1, '2023-04-14 14:28:39', NULL, '2023-06-15 09:31:12', 412, '0', NULL, NULL, NULL, NULL, NULL, NULL, '#ffff00', '#000000', 1, 1),
(48, NULL, NULL, 'Correctif MT', 1, '2023-04-14 14:28:39', NULL, '2023-06-15 09:30:53', 412, '0', NULL, NULL, NULL, NULL, NULL, NULL, '#ffff00', '#000000', 1, 1),
(49, NULL, NULL, 'Modification design', 1, '2023-04-14 14:28:39', NULL, '2023-06-15 09:39:25', 412, '0', NULL, NULL, NULL, NULL, NULL, NULL, '#ffae00', '#000000', 1, 1),
(50, NULL, NULL, 'Travaux planifiés', 1, '2023-04-14 14:28:39', NULL, '2023-06-15 11:40:37', 412, '0', NULL, NULL, NULL, NULL, NULL, NULL, '#00ff00', '#000000', 1, 1),
(51, NULL, NULL, 'Inspection', 1, '2023-04-14 14:28:39', NULL, '2023-06-15 11:39:52', 412, '0', NULL, NULL, NULL, NULL, NULL, NULL, '#ffa8ef', '#000000', 1, 1),
(52, NULL, NULL, 'Contrôle reglementaire annuel', 1, '2023-04-14 14:28:39', NULL, '2023-06-15 09:28:22', 412, '0', NULL, NULL, NULL, NULL, NULL, NULL, '#b9ff33', '#000000', 1, 1),
(53, NULL, NULL, 'Serrage', 1, '2023-04-14 14:28:39', NULL, '2023-06-15 11:41:18', 412, '0', NULL, NULL, NULL, NULL, NULL, NULL, '#7b00a8', '#ffffff', 1, 1),
(54, NULL, NULL, 'Maintenance Lift', 1, '2023-04-14 14:28:39', NULL, '2023-06-15 11:39:10', 412, '0', NULL, NULL, NULL, NULL, NULL, NULL, '#00ffc8', '#000000', 1, 1),
(55, NULL, NULL, 'Grand Correctif', 1, '2023-04-14 14:28:39', NULL, '2023-06-15 09:34:29', 412, '0', NULL, NULL, NULL, NULL, NULL, NULL, '#ff0000', '#ffffff', 1, 1),
(56, NULL, NULL, 'Travaux planifiés 2', 1, '2023-06-23 07:38:56', 421, '2023-06-23 09:38:56', NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, '#b9ffb8', '#000000', 0, 0),
(57, NULL, NULL, 'Travaux planifiés 3', 1, '2023-06-23 07:39:21', 421, '2023-06-23 09:39:21', NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, '#026b00', '#ffffff', 0, 0),
(58, NULL, NULL, 'Maintenance Viroles', 1, '2023-07-04 07:07:52', 412, '2023-07-04 09:07:52', NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, '#ffff00', '#000000', 0, 0),
(59, NULL, NULL, 'Maintenance Convertisseur', 1, '2023-07-04 07:08:17', 412, '2023-07-04 09:08:17', NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, '#ffff00', '#000000', 0, 0),
(61, NULL, NULL, 'Preventif majeur année 21', 1, '2023-07-04 09:02:49', 412, '2023-07-04 11:08:12', 412, '0', NULL, NULL, NULL, NULL, NULL, NULL, '#00ffff', '#000000', 1, 0),
(62, NULL, NULL, 'Preventif majeur année 22', 1, '2023-07-04 09:03:03', 412, '2023-07-04 11:08:05', 412, '0', NULL, NULL, NULL, NULL, NULL, NULL, '#00ffff', '#000000', 1, 0),
(63, NULL, NULL, 'Preventif majeur année 23', 1, '2023-07-04 09:03:16', 412, '2023-07-04 11:07:58', 412, '0', NULL, NULL, NULL, NULL, NULL, NULL, '#00ffff', '#000000', 1, 0),
(64, NULL, NULL, 'Preventif majeur année 24', 1, '2023-07-04 09:03:29', 412, '2023-07-04 11:07:51', 412, '0', NULL, NULL, NULL, NULL, NULL, NULL, '#00ffff', '#000000', 1, 0),
(66, NULL, NULL, 'Preventif majeur année 25', 1, '2023-07-04 09:03:44', 412, '2023-07-04 11:07:37', 412, '0', NULL, NULL, NULL, NULL, NULL, NULL, '#00ffff', '#000000', 1, 0),
(67, NULL, NULL, 'Preventif mineur année 20', 1, '2023-07-04 09:04:42', 412, '2023-07-04 11:06:28', 412, '0', NULL, NULL, NULL, NULL, NULL, NULL, '#910000', '#ffffff', 1, 0),
(68, NULL, NULL, 'Preventif mineur année 21', 1, '2023-07-04 09:04:52', 412, '2023-07-04 11:06:21', 412, '0', NULL, NULL, NULL, NULL, NULL, NULL, '#910000', '#ffffff', 1, 0),
(69, NULL, NULL, 'Preventif mineur année 23', 1, '2023-07-04 09:05:05', 412, '2023-07-04 11:07:13', 412, '0', NULL, NULL, NULL, NULL, NULL, NULL, '#910000', '#ffffff', 1, 0),
(70, NULL, NULL, 'Preventif mineur année 25', 1, '2023-07-04 09:05:53', 412, '2023-07-04 11:06:45', 412, '0', NULL, NULL, NULL, NULL, NULL, NULL, '#910000', '#ffffff', 1, 0),
(71, NULL, NULL, 'Preventif mineur année 24', 1, '2023-07-04 09:06:12', 412, '2023-07-04 11:07:01', 412, '0', NULL, NULL, NULL, NULL, NULL, NULL, '#940000', '#ffffff', 1, 0),
(72, NULL, NULL, 'HSS Bearing replacement', 1, '2023-07-19 12:26:15', 417, '2023-07-19 14:26:29', 417, '0', NULL, NULL, NULL, NULL, NULL, NULL, '#f53d3d', '#000000', 0, 0),
(73, NULL, NULL, 'Maintenance HT', 1, '2023-07-19 12:48:02', 417, '2023-07-19 14:48:02', NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, '#eb811e', '#000000', 0, 0),
(74, NULL, NULL, 'Limpet Failure', 1, '2023-07-19 12:53:31', 417, '2023-07-19 14:53:31', NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, '#b9ac18', '#000000', 0, 0),
(75, NULL, NULL, 'Lift failure', 1, '2023-07-19 13:19:18', 417, '2023-07-19 15:19:44', 417, '0', NULL, NULL, NULL, NULL, NULL, NULL, '#4430df', '#f1eeee', 0, 0),
(76, NULL, NULL, 'Life line replacement', 1, '2023-07-19 13:28:25', 417, '2023-07-19 15:28:25', NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, '#38c2cc', '#000000', 0, 0),
(77, NULL, NULL, 'WTR', 1, '2023-07-19 13:39:07', 417, '2023-07-19 15:39:07', NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, '#3722d3', '#eceaea', 0, 0),
(78, NULL, NULL, 'Limpet Maintenance', 1, '2023-07-24 07:45:29', 417, '2023-07-24 09:45:47', 417, '0', NULL, NULL, NULL, NULL, NULL, NULL, '#9a31d3', '#a3a0a6', 0, 0),
(79, NULL, NULL, 'Préventif mineur année 2', 1, '2023-07-28 12:23:20', 412, '2023-07-28 14:23:20', NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, '#910000', '#ffffff', 1, 0),
(80, NULL, 'CR', 'Coupure Réseau', 1, '2023-08-21 12:24:58', 416, '2023-08-21 14:24:58', NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, '#f0a119', '#000000', 1, 0),
(81, NULL, NULL, 'Inspection + Cleaning Generator', 1, '2023-09-13 12:14:56', 416, '2023-09-13 14:14:56', NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, '#f20deb', '#000000', 1, 0),
(82, NULL, NULL, 'Bridage 0KW', 1, '2023-09-28 09:17:11', 416, '2023-09-28 11:17:11', NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, '#fcff33', '#000000', 1, 0),
(83, NULL, NULL, 'Contrôle par Bureau Véritas / Socotec', 1, '2023-10-02 05:46:44', 416, '2023-10-02 07:46:44', NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, '#04fb2d', '#000000', 1, 0),
(84, NULL, NULL, 'Generator Bearing Replacement', 1, '2023-10-03 13:18:39', 416, '2023-10-03 15:18:39', NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, '#050df0', '#000000', 1, 0);

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

--
-- Index pour la table `activity`
--
ALTER TABLE `activity`
  ADD PRIMARY KEY (`act_id`),
  ADD KEY `intStaGro_id` (`par_id`);

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

--
-- AUTO_INCREMENT pour la table `activity`
--
ALTER TABLE `activity`
  MODIFY `act_id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=85;
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 */;