-- phpMyAdmin SQL Dump
-- version 5.2.0
-- https://www.phpmyadmin.net/
--
-- Host: localhost:3306
-- Generation Time: Oct 25, 2023 at 02:18 PM
-- Server version: 8.0.30
-- PHP Version: 8.1.10

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 */;

--
-- Database: `senvion_transfert`
--

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

--
-- Table structure for table `document_interne`
--

CREATE TABLE `document_interne` (
  `id` int NOT NULL,
  `libelle` varchar(255) NOT NULL,
  `id_compte` int NOT NULL,
  `id_parc` int NOT NULL,
  `id_machine` int NOT NULL,
  `date` date NOT NULL,
  `date_insert` datetime NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `document_interne`
--

INSERT INTO `document_interne` (`id`, `libelle`, `id_compte`, `id_parc`, `id_machine`, `date`, `date_insert`) VALUES
(2804, 'Ladder check 7yo', 33, 195, 0, '2023-08-09', '2023-08-09 14:14:16'),
(2794, 'ladder ', 573, 33, 0, '2023-06-23', '2023-06-23 15:30:37'),
(2795, 'TO101', 573, 33, 0, '2023-06-23', '2023-06-23 15:32:13'),
(2796, 'ladder', 573, 36, 0, '2023-06-23', '2023-06-23 16:06:13'),
(2797, 'to101', 573, 36, 0, '2023-06-23', '2023-06-23 16:08:03'),
(2821, '11 yr- Windvane', 141, 12, 0, '2023-08-29', '2023-08-29 16:15:53'),
(2822, '9yr- ladder check', 141, 148, 0, '2023-08-29', '2023-08-29 16:37:00'),
(2823, '9yr-testing CMBB', 141, 148, 0, '2023-08-29', '2023-08-29 16:37:36'),
(2864, 'CHE-10 years ladder check', 131, 44, 0, '2023-10-02', '2023-10-02 10:51:59'),
(2862, 'CHE-TO101-10 years maintenance', 131, 44, 0, '2023-10-02', '2023-10-02 10:51:21'),
(2863, 'CHE-TO102-10 years maintenance', 131, 44, 0, '2023-10-02', '2023-10-02 10:51:37'),
(2773, 'ladder', 573, 337, 0, '2023-03-28', '2023-03-28 14:28:53'),
(2774, 'TO101', 573, 337, 0, '2023-03-28', '2023-03-28 14:36:11'),
(2775, '12th years maintenance-ladder check', 94, 3, 0, '2023-03-30', '2023-03-30 14:17:28'),
(2155, '3th years maintenance-TO 101', 94, 314, 0, '2021-06-21', '2021-06-21 13:44:57'),
(2780, '6 years converter maintenance', 22, 323, 0, '2023-04-26', '2023-04-26 15:22:59'),
(2781, 'Teterchen-18 year maintenance-TO FR101', 31, 42, 0, '2023-04-26', '2023-04-26 15:55:08'),
(2015, '3th years maintenance-Ladder inspection', 94, 293, 0, '2021-03-08', '2021-03-08 15:18:00'),
(2014, '3th years maintenance-TO083', 94, 293, 0, '2021-03-08', '2021-03-08 15:02:35'),
(1891, '3 year ladder check', 24, 289, 0, '2020-11-13', '2020-11-13 12:37:19'),
(1892, '3 year To 101', 24, 289, 0, '2020-11-13', '2020-11-13 12:38:11'),
(2016, '3th years maintenance-Wind vane alignment', 94, 293, 0, '2021-03-08', '2021-03-08 15:20:03'),
(2018, '10 years maintenance-TO 101 prc I+II+III', 22, 53, 0, '2021-03-10', '2021-03-10 16:51:21'),
(2019, '10 years maintenance-TO 101 parc IV+V ', 22, 53, 0, '2021-03-10', '2021-03-10 16:52:03'),
(2020, ' 	10 years maintenance-Ladder check parc I+II+III ', 22, 53, 0, '2021-03-10', '2021-03-10 16:54:01'),
(2021, ' 	10 years maintenance-Ladder check parc IV+V ', 22, 53, 0, '2021-03-10', '2021-03-10 16:54:45'),
(2777, 'LADDER', 573, 337, 0, '2023-04-11', '2023-04-11 16:20:14'),
(2778, 'TO101', 573, 337, 0, '2023-04-12', '2023-04-12 09:04:51'),
(1583, 'TO101', 24, 11, 0, '2019-11-28', '2019-11-28 10:29:58'),
(2783, 'LADDER', 573, 371, 0, '2023-05-02', '2023-05-02 12:40:32'),
(1584, 'Test CMBB', 24, 11, 0, '2019-11-28', '2019-11-28 10:30:17'),
(2788, 'Le haut des ailes ext-15 year converter maintenance', 31, 40, 0, '2023-05-17', '2023-05-17 10:38:12'),
(2785, 'Tests CMBB-Langres Sud-Park 3-12.5 years maintenance', 131, 53, 0, '2023-05-04', '2023-05-04 13:31:32'),
(2786, 'WTR 637 Charmois 12 - 91439', 502, 57, 0, '2023-05-12', '2023-05-12 13:48:53'),
(2787, 'Teterchen-18 year converter maintenance', 31, 42, 0, '2023-05-17', '2023-05-17 10:37:31'),
(2865, 'CHE-CMBB tests-10 years maintenance', 131, 44, 0, '2023-10-02', '2023-10-02 10:52:26'),
(2802, 'ladder', 573, 32, 0, '2023-07-26', '2023-07-26 10:23:06'),
(2803, 'TO101', 573, 32, 0, '2023-07-26', '2023-07-26 10:26:07'),
(2838, '9 Years Maintenance Ladder Inspection', 94, 132, 0, '2023-08-30', '2023-08-30 11:28:19'),
(2839, '9 Years Maintenance Testing The CMBB System', 94, 132, 0, '2023-08-30', '2023-08-30 11:29:00'),
(2840, '9 Years Maintenance Wind Vane Alignment', 94, 132, 0, '2023-08-30', '2023-08-30 11:29:29'),
(2841, '13 years maintenance- Ladder check', 94, 20, 0, '2023-08-30', '2023-08-30 13:37:29'),
(2842, '13 years maintenance- TO 101', 94, 20, 0, '2023-08-30', '2023-08-30 13:39:11'),
(2843, 'Testing the CMBB system', 94, 20, 0, '2023-08-30', '2023-08-30 13:39:49'),
(2824, '9yr-Windvane', 141, 148, 0, '2023-08-29', '2023-08-29 16:38:12'),
(2825, '9yr-testing CMBB', 141, 147, 0, '2023-08-29', '2023-08-29 16:42:04'),
(2826, '9yr-Windvane', 141, 147, 0, '2023-08-29', '2023-08-29 16:42:27'),
(2827, '9yr-Ladder check', 141, 147, 0, '2023-08-29', '2023-08-29 16:42:54'),
(2828, '6yr-ladder check', 141, 318, 0, '2023-08-29', '2023-08-29 16:44:57'),
(2829, '13yr-ladder check', 141, 15, 0, '2023-08-29', '2023-08-29 16:47:14'),
(2830, '13yr-windvane', 141, 15, 0, '2023-08-29', '2023-08-29 16:47:35'),
(2831, '6yr-Ladder check', 141, 289, 0, '2023-08-29', '2023-08-29 16:54:03'),
(2832, '6yr-windvane', 141, 289, 0, '2023-08-29', '2023-08-29 16:59:17'),
(2833, '6yr-ladder check', 141, 292, 0, '2023-08-29', '2023-08-29 17:00:10'),
(2834, '6yr-windvane', 141, 292, 0, '2023-08-29', '2023-08-29 17:01:04'),
(2835, '12th year maintenance-Ladder inspection', 94, 23, 0, '2023-08-30', '2023-08-30 10:55:21'),
(2836, '12th year maintenance-Testing the CMBB system', 94, 23, 0, '2023-08-30', '2023-08-30 11:00:25'),
(2837, '12th year maintenance-Windvane aligment', 94, 23, 0, '2023-08-30', '2023-08-30 11:01:18'),
(2844, 'LADDER', 573, 35, 0, '2023-09-08', '2023-09-08 12:18:16'),
(2845, 'TO101', 573, 35, 0, '2023-09-08', '2023-09-08 12:19:57'),
(2846, 'CMBB_Slip ring_modification_Fierville Airan', 350, 90, 0, '2023-09-13', '2023-09-13 16:08:13'),
(2808, 'Tests CMBB Langres Sud-12,5 years maintenance-Parcs IV & V', 131, 53, 0, '2023-08-28', '2023-08-28 15:01:09'),
(2818, '9 Years Maintenance Wind Vane Alignment', 94, 332, 0, '2023-08-29', '2023-08-29 11:40:46'),
(2805, 'TO101 7yo Mas Cabardes', 33, 195, 0, '2023-08-09', '2023-08-09 14:15:33'),
(2806, 'TO 101 15yo', 33, 112, 0, '2023-08-10', '2023-08-10 10:59:06'),
(2807, 'Ladder check 15yo ', 33, 112, 0, '2023-08-10', '2023-08-10 10:59:36'),
(2819, '11,5 years maintenance-Testing the CMBB system', 94, 18, 0, '2023-08-29', '2023-08-29 14:20:31'),
(2820, '11,5th year maintenance-Testing the CMBB system', 94, 18, 0, '2023-08-29', '2023-08-29 14:56:52'),
(2857, 'Delouze-11 years converter maintenance', 131, 59, 0, '2023-09-22', '2023-09-22 14:34:43'),
(2856, 'Chermisey - 10 Years converter maintenance', 131, 44, 0, '2023-09-22', '2023-09-22 14:33:19'),
(2854, 'Dampierre-II-10 years converter maintenance', 131, 333, 0, '2023-09-22', '2023-09-22 14:30:13'),
(2850, 'Montbray_Return Sheet CMBB Test', 350, 136, 0, '2023-09-19', '2023-09-19 10:00:52'),
(2848, 'TO101', 573, 30, 0, '2023-09-18', '2023-09-18 15:24:21'),
(2849, 'LADDER', 573, 30, 0, '2023-09-18', '2023-09-18 15:25:26'),
(2851, 'Montbray_9 year maintenance-Ladder Check', 350, 136, 0, '2023-09-19', '2023-09-19 10:01:24'),
(2852, 'Mont famillot-E1-8th-Ladder+TO101+CMBB', 655, 169, 0, '2023-09-21', '2023-09-21 13:18:54'),
(2855, 'Baudignecourt-12 years lift maintenance', 131, 56, 0, '2023-09-22', '2023-09-22 14:32:56'),
(2776, '12th years maintenance-TO 101', 94, 3, 0, '2023-03-30', '2023-03-30 14:17:42'),
(2867, 'Tramomarina 8y Global', 655, 175, 0, '2023-10-06', '2023-10-06 15:48:45'),
(2866, 'L?vigny - Converter Maintenance - 2023', 131, 49, 0, '2023-10-05', '2023-10-05 14:19:10'),
(2858, 'Les Eparmonts-Ladder check-14 years maintenance', 131, 45, 0, '2023-09-28', '2023-09-28 14:22:34'),
(2860, 'Les Eparmonts-TO1O1-14 years maintenance', 131, 45, 0, '2023-09-28', '2023-09-28 14:23:29'),
(2859, 'Les Eparmonts-TO1O2-14 years maintenance', 131, 45, 0, '2023-09-28', '2023-09-28 14:23:03'),
(2784, 'TO0101', 573, 371, 0, '2023-05-02', '2023-05-02 12:41:49'),
(2779, 'Tests CMBB-Langres Sud-Park 2-12.5 years maintenance', 131, 53, 0, '2023-04-19', '2023-04-19 16:46:38'),
(2782, 'T?terchen-18 year maintenance-Ladder control', 31, 42, 0, '2023-04-26', '2023-04-26 16:15:26'),
(2789, 'Assac 11yo Ladder check', 33, 335, 0, '2023-06-08', '2023-06-08 13:25:38'),
(2790, 'Assac 11yo TO101', 33, 335, 0, '2023-06-08', '2023-06-08 13:26:24'),
(2791, 'Assac 11yo Return Sheet CMBB Test', 33, 335, 0, '2023-06-08', '2023-06-08 13:27:09'),
(2792, '7th years maintenance- Ladder check', 94, 216, 0, '2023-06-12', '2023-06-12 11:27:32'),
(2793, '7th years maintenance-TO 101', 94, 216, 0, '2023-06-12', '2023-06-12 11:27:52'),
(2801, 'ladder', 573, 31, 0, '2023-07-10', '2023-07-10 15:27:50'),
(2800, 'to101', 573, 31, 0, '2023-07-10', '2023-07-10 15:24:42'),
(2810, '5 years maintenance-Ladder check', 94, 314, 0, '2023-08-29', '2023-08-29 10:56:14'),
(2811, '5 years maintenance-TO 101', 94, 314, 0, '2023-08-29', '2023-08-29 10:57:30'),
(2812, '12 years partial maintenance-Crane and Hoist Pre Use Inspection Feb 2021', 94, 22, 0, '2023-08-29', '2023-08-29 11:16:59'),
(2813, '9 Years Maintenance Ladder Inspection', 94, 332, 0, '2023-08-29', '2023-08-29 11:37:36'),
(2814, '9 Years Maintenance Ladder Inspection', 94, 331, 0, '2023-08-29', '2023-08-29 11:38:06'),
(2815, '9 Years Maintenance Testing the CMBB system', 94, 331, 0, '2023-08-29', '2023-08-29 11:38:50'),
(2816, '9 Years Maintenance Testing the CMBB system', 94, 332, 0, '2023-08-29', '2023-08-29 11:39:10'),
(2817, '9 Years Maintenance Wind Vane Alignment', 94, 331, 0, '2023-08-29', '2023-08-29 11:40:28');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `document_interne`
--
ALTER TABLE `document_interne`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `document_interne`
--
ALTER TABLE `document_interne`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2868;
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 */;