-- phpMyAdmin SQL Dump
-- version OVH
-- https://www.phpmyadmin.net/
--
-- Hôte : aplpoeew2010.mysql.db
-- Généré le : dim. 18 juin 2023 à 23:04
-- Version du serveur : 5.7.42-log
-- Version de PHP : 7.4.33

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

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

--
-- Structure de la table `COTISATIONS_2023`
--

CREATE TABLE `COTISATIONS_2023` (
  `COT_INDEX` int(11) NOT NULL,
  `COT_SAISON` smallint(6) NOT NULL,
  `COT_ADHERENT` int(11) NOT NULL,
  `COT_STATUT` varchar(10) NOT NULL DEFAULT 'A_DEMANDER',
  `COT_DATE` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `COT_COMMANDE` int(9) NOT NULL,
  `COT_PARRAIN` int(11) NOT NULL,
  `COT_DATE_RECU` datetime NOT NULL DEFAULT '0000-00-00 00:00:00'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

INSERT INTO `COTISATIONS_2023` (`COT_INDEX`, `COT_SAISON`, `COT_ADHERENT`, `COT_STATUT`, `COT_DATE`, `COT_COMMANDE`, `COT_PARRAIN`, `COT_DATE_RECU`, `APP_URBANISATION`) VALUES
(113, 2023, 6876, 'ACCEPTEE', '2022-12-01 02:37:58', 20230117, 0, '2022-12-01 02:37:58', 'PLAGNE CENTRE'),
(6, 2023, 6898, 'ACCEPTEE', '2022-09-22 10:26:57', 20230005, 0, '2022-09-22 10:26:57', 'CHAMPAGNY'),
(91, 2023, 6903, 'ACCEPTEE', '2022-11-24 09:53:33', 20230092, 0, '2022-11-24 09:53:33', 'BELLE PLAGNE'),
(171, 2023, 6934, 'ACCEPTEE', '2022-12-20 15:22:15', 20230183, 0, '2022-12-20 15:22:15', 'CHAMPAGNY'),
(29, 2023, 100025, 'ACCEPTEE', '2022-11-11 00:09:50', 20230031, 0, '2022-11-11 00:09:50', 'PLAGNE CENTRE'),
(175, 2023, 100043, 'ACCEPTEE', '2022-12-19 11:54:50', 20230188, 0, '2022-12-19 11:54:50', 'PLAGNE CENTRE'),
(122, 2023, 100101, 'ACCEPTEE', '2022-12-01 14:25:49', 20230127, 0, '2022-12-01 14:25:49', 'PLAGNE CENTRE'),
(116, 2023, 100119, 'ACCEPTEE', '2022-12-01 02:37:59', 20230121, 0, '2022-12-01 02:37:59', 'PLAGNE CENTRE'),
(165, 2023, 100144, 'ACCEPTEE', '2022-12-16 15:33:10', 20230178, 0, '2022-12-16 15:33:10', 'PLAGNE CENTRE'),
(87, 2023, 100147, 'ACCEPTEE', '2022-11-21 21:41:49', 20230089, 0, '2022-11-21 21:41:49', 'PLAGNE CENTRE'),
(154, 2023, 100227, 'ACCEPTEE', '2022-12-11 23:35:36', 20230165, 0, '2022-12-11 23:35:36', 'PLAGNE CENTRE'),
(103, 2023, 100286, 'ACCEPTEE', '2022-11-24 09:53:35', 20230105, 0, '2022-11-24 09:53:35', 'PLAGNE CENTRE'),
(34, 2023, 100329, 'ACCEPTEE', '2022-11-07 11:52:11', 20230035, 0, '2022-11-07 11:52:11', 'PLAGNE CENTRE'),
(105, 2023, 100345, 'ACCEPTEE', '2022-12-08 18:33:12', 20230108, 0, '2022-12-08 18:33:12', 'PLAGNE BELLECOTE'),
(95, 2023, 100442, 'ACCEPTEE', '2022-11-24 09:53:34', 20230098, 0, '2022-11-24 09:53:34', 'PLAGNE CENTRE'),
(155, 2023, 100446, 'ACCEPTEE', '2022-12-11 23:35:37', 20230166, 0, '2022-12-11 23:35:37', 'PLAGNE CENTRE'),
(150, 2023, 100489, 'ACCEPTEE', '2022-12-11 17:56:08', 20230160, 0, '2022-12-11 17:56:08', 'PLAGNE CENTRE'),
(106, 2023, 100507, 'ACCEPTEE', '2022-11-28 09:01:09', 20230109, 0, '2022-11-28 09:01:09', 'PLAGNE SOLEIL'),
(38, 2023, 100568, 'ACCEPTEE', '2022-11-07 11:52:12', 20230040, 0, '2022-11-07 11:52:12', 'PLAGNE CENTRE'),
(50, 2023, 100633, 'ACCEPTEE', '2022-11-24 09:53:33', 20230054, 0, '2022-11-24 09:53:33', 'PLAGNE CENTRE'),
(101, 2023, 100647, 'ACCEPTEE', '2022-11-24 09:53:35', 20230104, 0, '2022-11-24 09:53:35', 'PLAGNE CENTRE'),
(151, 2023, 100862, 'ACCEPTEE', '2022-12-11 17:56:08', 20230161, 0, '2022-12-11 17:56:08', 'PLAGNE CENTRE'),
(30, 2023, 100868, 'ACCEPTEE', '2022-11-01 13:48:43', 20230032, 0, '2022-11-01 13:48:43', 'PLAGNE CENTRE'),
(47, 2023, 100888, 'ACCEPTEE', '2022-11-10 17:15:56', 20230050, 0, '2022-11-10 17:15:56', 'PLAGNE CENTRE'),
(145, 2023, 101030, 'ACCEPTEE', '2022-12-08 18:33:13', 20230154, 0, '2022-12-08 18:33:13', 'PLAGNE VILLAGES'),
(111, 2023, 101088, 'ACCEPTEE', '2022-11-28 10:00:42', 20230115, 0, '2022-11-28 10:00:42', 'PLAGNE CENTRE'),
(142, 2023, 101233, 'ACCEPTEE', '2022-12-08 18:33:13', 20230150, 0, '2022-12-08 18:33:13', 'AIME 2000'),
(159, 2023, 101452, 'ACCEPTEE', '2022-12-13 06:39:42', 20230172, 0, '2022-12-13 06:39:42', 'AIME 2000'),
(170, 2023, 101474, 'ACCEPTEE', '2022-12-16 15:33:10', 20230182, 0, '2022-12-16 15:33:10', 'AIME 2000'),
(161, 2023, 101824, 'ACCEPTEE', '2022-12-14 12:02:31', 20230174, 0, '2022-12-14 12:02:31', 'AIME 2000'),
(210, 2023, 101884, 'ACCEPTEE', '2023-02-21 16:23:56', 20230241, 0, '2023-02-21 16:23:56', 'AIME 2000'),
(180, 2023, 102232, 'ACCEPTEE', '2022-12-19 11:54:51', 20230195, 0, '2022-12-19 11:54:51', 'PLAGNE VILLAGES'),
(121, 2023, 102349, 'ACCEPTEE', '2022-12-01 02:38:00', 20230126, 0, '2022-12-01 02:38:00', 'PLAGNE VILLAGES'),
(88, 2023, 102403, 'ACCEPTEE', '2022-11-21 23:25:14', 20230090, 0, '2022-11-21 23:25:14', 'PLAGNE VILLAGES'),
(28, 2023, 102422, 'ACCEPTEE', '2022-11-01 13:48:43', 20230030, 0, '2022-11-01 13:48:43', 'PLAGNE VILLAGES'),
(134, 2023, 102459, 'ACCEPTEE', '2022-12-05 10:41:07', 20230142, 0, '2022-12-05 10:41:07', 'PLAGNE VILLAGES'),
(185, 2023, 102536, 'ACCEPTEE', '2022-12-26 09:32:05', 20230202, 0, '2022-12-26 09:32:05', 'PLAGNE VILLAGES'),
(9, 2023, 102607, 'ACCEPTEE', '2022-10-01 09:53:59', 20230007, 0, '2022-10-01 09:53:59', 'PLAGNE VILLAGES'),
(152, 2023, 103203, 'ACCEPTEE', '2022-12-11 17:56:08', 20230163, 0, '2022-12-11 17:56:08', 'PLAGNE BELLECOTE'),
(57, 2023, 103251, 'ACCEPTEE', '2022-11-18 15:49:29', 20230060, 0, '2022-11-18 15:49:29', 'PLAGNE BELLECOTE'),
(109, 2023, 103259, 'ACCEPTEE', '2022-12-11 17:56:07', 20230114, 0, '2022-12-11 17:56:07', 'PLAGNE BELLECOTE'),
(24, 2023, 103299, 'ACCEPTEE', '2022-10-21 16:17:44', 20230026, 0, '2022-10-21 16:17:44', 'BELLE PLAGNE'),
(157, 2023, 103304, 'ACCEPTEE', '2022-12-13 06:39:42', 20230168, 0, '2022-12-13 06:39:42', 'BELLE PLAGNE'),
(133, 2023, 103305, 'ACCEPTEE', '2022-12-08 18:33:12', 20230141, 0, '2022-12-08 18:33:12', 'BELLE PLAGNE'),
(205, 2023, 103324, 'ACCEPTEE', '2023-01-29 22:46:51', 20230231, 0, '2023-01-29 22:46:51', 'BELLE PLAGNE'),
(207, 2023, 103354, 'ACCEPTEE', '2023-02-08 06:59:40', 20230236, 0, '2023-02-08 06:59:40', 'BELLE PLAGNE'),
(32, 2023, 103601, 'ACCEPTEE', '2022-11-07 11:52:11', 20230034, 0, '2022-11-07 11:52:11', 'BELLE PLAGNE'),
(112, 2023, 103763, 'ACCEPTEE', '2022-12-08 18:33:12', 20230116, 0, '2022-12-08 18:33:12', 'LES COCHES'),
(5, 2023, 104526, 'ACCEPTEE', '2022-09-22 10:26:57', 20230004, 0, '2022-09-22 10:26:57', 'MONTCHAVIN'),
(149, 2023, 104531, 'ACCEPTEE', '2022-12-11 17:56:07', 20230159, 0, '2022-12-11 17:56:07', 'MONTCHAVIN'),
(90, 2023, 104547, 'ACCEPTEE', '2022-11-24 09:53:34', 20230094, 0, '2022-11-24 09:53:34', 'MONTCHAVIN'),
(176, 2023, 104567, 'ACCEPTEE', '2022-12-19 11:54:50', 20230189, 0, '2022-12-19 11:54:50', 'MONTCHAVIN'),
(209, 2023, 104580, 'ACCEPTEE', '2023-02-13 09:21:05', 20230237, 0, '2023-02-13 09:21:05', 'MONTCHAVIN'),
(137, 2023, 104934, 'ACCEPTEE', '2022-12-11 17:56:07', 20230132, 0, '2022-12-11 17:56:07', 'PLAGNE BELLECOTE'),
(144, 2023, 104938, 'ACCEPTEE', '2022-12-08 18:33:13', 20230153, 0, '2022-12-08 18:33:13', 'PLAGNE CENTRE'),
(59, 2023, 105347, 'ACCEPTEE', '2022-11-18 15:49:29', 20230063, 0, '2022-11-18 15:49:29', 'MONTCHAVIN'),
(117, 2023, 105494, 'ACCEPTEE', '2022-12-01 02:37:59', 20230122, 0, '2022-12-01 02:37:59', 'AIME 2000'),
(13, 2023, 105495, 'ACCEPTEE', '2022-10-12 21:33:00', 20230013, 0, '2022-10-12 21:33:00', 'PLAGNE CENTRE'),
(42, 2023, 105942, 'ACCEPTEE', '2022-11-12 09:27:02', 20230043, 0, '2022-11-12 09:27:02', 'BELLE PLAGNE'),
(146, 2023, 106020, 'ACCEPTEE', '2022-12-08 18:33:13', 20230155, 0, '2022-12-08 18:33:13', 'PLAGNE CENTRE'),
(211, 2023, 106289, 'ACCEPTEE', '2023-02-21 16:51:46', 20230242, 0, '2023-02-21 16:51:46', 'MONTCHAVIN'),
(48, 2023, 106857, 'ACCEPTEE', '2022-11-10 17:15:56', 20230051, 0, '2022-11-10 17:15:56', 'CHAMPAGNY'),
(98, 2023, 106930, 'ACCEPTEE', '2022-11-24 09:53:34', 20230101, 0, '2022-11-24 09:53:34', 'PLAGNE CENTRE'),
(83, 2023, 107210, 'ACCEPTEE', '2022-11-21 21:41:48', 20230085, 0, '2022-11-21 21:41:48', 'PLAGNE BELLECOTE'),
(71, 2023, 107291, 'ACCEPTEE', '2022-11-18 15:49:30', 20230075, 0, '2022-11-18 15:49:30', 'MONTCHAVIN'),
(197, 2023, 107328, 'ACCEPTEE', '2023-01-12 12:59:54', 20230216, 0, '2023-01-12 12:59:54', 'PLAGNE CENTRE'),
(127, 2023, 107501, 'ACCEPTEE', '2022-12-05 10:41:06', 20230135, 0, '2022-12-05 10:41:06', 'BELLE PLAGNE'),
(66, 2023, 107547, 'ACCEPTEE', '2022-11-18 15:49:30', 20230070, 0, '2022-11-18 15:49:30', 'PLAGNE VILLAGES'),
(184, 2023, 107568, 'ACCEPTEE', '2023-01-09 09:25:09', 20230201, 0, '2023-01-09 09:25:09', 'MONTCHAVIN'),
(208, 2023, 107589, 'ACCEPTEE', '2023-02-13 08:45:35', 20230236, 0, '2023-02-13 08:45:35', 'PLAGNE VILLAGES'),
(18, 2023, 107926, 'ACCEPTEE', '2022-11-07 11:52:11', 20230020, 0, '2022-11-07 11:52:11', 'PLAGNE BELLECOTE'),
(107, 2023, 107969, 'ACCEPTEE', '2022-11-28 09:01:09', 20230110, 0, '2022-11-28 09:01:09', 'PLAGNE CENTRE'),
(202, 2023, 107981, 'ACCEPTEE', '2023-01-23 09:25:31', 20230227, 0, '2023-01-23 09:25:31', 'BELLE PLAGNE'),
(68, 2023, 108112, 'ACCEPTEE', '2022-11-18 15:49:30', 20230072, 0, '2022-11-18 15:49:30', 'PLAGNE VILLAGES'),
(99, 2023, 108137, 'ACCEPTEE', '2022-11-24 09:53:34', 20230102, 0, '2022-11-24 09:53:34', 'AIME 2000'),
(92, 2023, 108139, 'ACCEPTEE', '2022-11-24 09:53:34', 20230095, 0, '2022-11-24 09:53:34', 'BELLE PLAGNE'),
(143, 2023, 108199, 'ACCEPTEE', '2022-12-08 18:33:13', 20230151, 0, '2022-12-08 18:33:13', 'MONTCHAVIN'),
(36, 2023, 108235, 'ACCEPTEE', '2022-11-18 15:49:28', 20230038, 0, '2022-11-18 15:49:28', 'PLAGNE CENTRE'),
(138, 2023, 108239, 'ACCEPTEE', '2022-12-06 14:16:58', 20230145, 0, '2022-12-06 14:16:58', 'BELLE PLAGNE'),
(14, 2023, 108242, 'ACCEPTEE', '2022-10-12 21:33:00', 20230014, 0, '2022-10-12 21:33:00', 'PLAGNE SOLEIL'),
(204, 2023, 108254, 'ACCEPTEE', '2023-01-29 22:46:51', 20230230, 0, '2023-01-29 22:46:51', 'CHAMPAGNY'),
(78, 2023, 108286, 'ACCEPTEE', '2022-11-21 21:41:48', 20230081, 0, '2022-11-21 21:41:48', 'BELLE PLAGNE'),
(177, 2023, 108306, 'ACCEPTEE', '2022-12-19 11:54:51', 20230193, 0, '2022-12-19 11:54:51', 'LES COCHES'),
(139, 2023, 108423, 'ACCEPTEE', '2022-12-06 14:16:58', 20230146, 0, '2022-12-06 14:16:58', 'BELLE PLAGNE'),
(136, 2023, 108551, 'ACCEPTEE', '2022-12-05 10:41:07', 20230144, 0, '2022-12-05 10:41:07', 'PLAGNE CENTRE'),
(94, 2023, 108553, 'ACCEPTEE', '2022-12-01 02:37:58', 20230097, 0, '2022-12-01 02:37:58', 'PLAGNE CENTRE'),
(70, 2023, 108573, 'ACCEPTEE', '2022-12-01 02:37:57', 20230074, 0, '2022-12-01 02:37:57', 'PLAGNE VILLAGES'),
(80, 2023, 108588, 'ACCEPTEE', '2022-11-28 09:01:09', 20230112, 0, '2022-11-28 09:01:09', 'PLAGNE VILLAGES'),
(181, 2023, 108631, 'ACCEPTEE', '2022-12-20 15:22:15', 20230196, 0, '2022-12-20 15:22:15', 'CHAMPAGNY'),
(45, 2023, 108663, 'ACCEPTEE', '2022-11-10 17:15:55', 20230048, 0, '2022-11-10 17:15:55', 'CHAMPAGNY'),
(100, 2023, 108683, 'ACCEPTEE', '2022-11-24 09:53:35', 20230103, 0, '2022-11-24 09:53:35', 'PLAGNE VILLAGES'),
(135, 2023, 108747, 'ACCEPTEE', '2023-01-04 14:28:42', 20230143, 0, '2023-01-04 14:28:42', 'AIME 2000'),
(4, 2023, 108749, 'ACCEPTEE', '2022-09-22 10:26:57', 20230003, 0, '2022-09-22 10:26:57', 'PLAGNE VILLAGES'),
(23, 2023, 108811, 'ACCEPTEE', '2022-10-21 16:17:44', 20230025, 0, '2022-10-21 16:17:44', 'PLAGNE VILLAGES'),
(7, 2023, 108879, 'ACCEPTEE', '2022-09-28 08:59:13', 20230006, 0, '2022-09-28 08:59:13', 'BELLE PLAGNE'),
(37, 2023, 108883, 'ACCEPTEE', '2022-11-07 11:52:12', 20230039, 0, '2022-11-07 11:52:12', 'BELLE PLAGNE'),
(156, 2023, 108918, 'ACCEPTEE', '2022-12-19 11:54:49', 20230167, 0, '2022-12-19 11:54:49', 'PLAGNE VILLAGES'),
(198, 2023, 108996, 'ACCEPTEE', '2023-01-09 09:25:09', 20230217, 0, '2023-01-09 09:25:09', 'AIME 2000'),
(199, 2023, 109019, 'ACCEPTEE', '2023-01-16 08:40:33', 20230223, 0, '2023-01-16 08:40:33', 'AIME 2000'),
(19, 2023, 14867530, 'ACCEPTEE', '2022-10-21 16:17:43', 20230021, 0, '2022-10-21 16:17:43', 'PLAGNE BELLECOTE'),
(141, 2023, 14867537, 'ACCEPTEE', '2022-12-08 18:33:13', 20230148, 0, '2022-12-08 18:33:13', 'BELLE PLAGNE'),
(35, 2023, 14867612, 'ACCEPTEE', '2022-11-07 11:52:12', 20230037, 0, '2022-11-07 11:52:12', 'AIME 2000'),
(8, 2023, 14867690, 'ACCEPTEE', '2022-10-01 09:53:59', 20230008, 0, '2022-10-01 09:53:59', 'MONTALBERT'),
(183, 2023, 14867692, 'ACCEPTEE', '2022-12-23 08:39:10', 20230200, 0, '2022-12-23 08:39:10', 'PLAGNE CENTRE'),
(172, 2023, 14867701, 'ACCEPTEE', '2022-12-16 15:33:11', 20230184, 0, '2022-12-16 15:33:11', 'MONTALBERT'),
(169, 2023, 14867708, 'ACCEPTEE', '2022-12-23 08:39:10', 20230198, 0, '2022-12-23 08:39:10', 'MONTALBERT'),
(163, 2023, 14867764, 'ACCEPTEE', '2022-12-20 15:22:15', 20230176, 0, '2022-12-20 15:22:15', 'CHAMPAGNY'),
(104, 2023, 14867769, 'ACCEPTEE', '2022-12-08 18:33:12', 20230106, 0, '2022-12-08 18:33:12', 'PLAGNE BELLECOTE'),
(41, 2023, 14867784, 'ACCEPTEE', '2022-11-12 09:27:02', 20230044, 0, '2022-11-12 09:27:02', 'PLAGNE CENTRE'),
(25, 2023, 14867812, 'ACCEPTEE', '2022-10-23 19:19:01', 20230027, 0, '2022-10-23 19:19:01', 'MONTCHAVIN'),
(158, 2023, 14867821, 'ACCEPTEE', '2022-12-13 06:39:42', 20230171, 0, '2022-12-13 06:39:42', 'BELLE PLAGNE'),
(167, 2023, 17052030, 'ACCEPTEE', '2022-12-19 11:54:50', 20230180, 0, '2022-12-19 11:54:50', 'BELLE PLAGNE'),
(60, 2023, 17052052, 'ACCEPTEE', '2022-11-18 15:49:29', 20230064, 0, '2022-11-18 15:49:29', 'BELLE PLAGNE'),
(188, 2023, 17052058, 'ACCEPTEE', '2022-12-31 00:08:51', 20230206, 0, '2022-12-31 00:08:51', 'PLAGNE LAUZE 1800'),
(20, 2023, 17052072, 'ACCEPTEE', '2022-10-21 16:17:44', 20230022, 0, '2022-10-21 16:17:44', 'PLAGNE CENTRE'),
(131, 2023, 19102052, 'ACCEPTEE', '2022-12-05 10:41:07', 20230138, 0, '2022-12-05 10:41:07', 'PLAGNE BELLECOTE'),
(73, 2023, 19102058, 'ACCEPTEE', '2022-12-13 06:39:41', 20230076, 0, '2022-12-13 06:39:41', 'MONTALBERT'),
(96, 2023, 19102060, 'ACCEPTEE', '2022-12-11 17:56:07', 20230099, 0, '2022-12-11 17:56:07', 'PLAGNE VILLAGES'),
(114, 2023, 19102065, 'ACCEPTEE', '2022-12-01 02:37:59', 20230118, 0, '2022-12-01 02:37:59', 'AIME 2000'),
(120, 2023, 19102147, 'ACCEPTEE', '2022-12-01 02:38:00', 20230125, 0, '2022-12-01 02:38:00', 'AIME 2000'),
(196, 2023, 19102153, 'ACCEPTEE', '2023-01-12 12:59:55', 20230222, 0, '2023-01-12 12:59:55', 'PLAGNE CENTRE'),
(58, 2023, 19102154, 'ACCEPTEE', '2022-11-18 15:49:29', 20230062, 0, '2022-11-18 15:49:29', 'PLAGNE BELLECOTE'),
(108, 2023, 19102186, 'ACCEPTEE', '2022-12-11 17:56:07', 20230113, 0, '2022-12-11 17:56:07', 'PLAGNE VILLAGES'),
(67, 2023, 19102202, 'ACCEPTEE', '2022-11-18 15:49:30', 20230071, 0, '2022-11-18 15:49:30', 'BELLE PLAGNE'),
(129, 2023, 19102209, 'ACCEPTEE', '2022-12-05 10:41:06', 20230136, 0, '2022-12-05 10:41:06', 'BELLE PLAGNE'),
(64, 2023, 19102238, 'ACCEPTEE', '2022-12-19 11:54:49', 20230068, 0, '2022-12-19 11:54:49', 'CHAMPAGNY'),
(178, 2023, 19102250, 'ACCEPTEE', '2022-12-19 11:54:51', 20230190, 0, '2022-12-19 11:54:51', 'LES COCHES'),
(168, 2023, 19102252, 'ACCEPTEE', '2022-12-16 15:33:10', 20230181, 0, '2022-12-16 15:33:10', 'PLAGNE BELLECOTE'),
(39, 2023, 19102263, 'ACCEPTEE', '2022-11-07 11:52:12', 20230041, 0, '2022-11-07 11:52:12', 'LES COCHES'),
(44, 2023, 19102265, 'ACCEPTEE', '2022-11-18 15:49:28', 20230047, 0, '2022-11-18 15:49:28', 'MONTCHAVIN'),
(55, 2023, 19102268, 'ACCEPTEE', '2022-11-18 15:49:29', 20230059, 0, '2022-11-18 15:49:29', 'PLAGNE VILLAGES'),
(26, 2023, 19102274, 'ACCEPTEE', '2022-11-01 13:48:42', 20230028, 0, '2022-11-01 13:48:42', 'PLAGNE SOLEIL'),
(125, 2023, 19102304, 'ACCEPTEE', '2022-12-02 14:02:36', 20230129, 0, '2022-12-02 14:02:36', 'PLAGNE VILLAGES'),
(118, 2023, 19102398, 'ACCEPTEE', '2022-12-03 11:23:46', 20230123, 0, '2022-12-03 11:23:46', 'PLAGNE CENTRE'),
(123, 2023, 19102401, 'ACCEPTEE', '2022-12-02 14:02:36', 20230128, 0, '2022-12-02 14:02:36', 'AIME 2000'),
(86, 2023, 19102442, 'ACCEPTEE', '2022-11-21 21:41:49', 20230088, 0, '2022-11-21 21:41:49', 'LES COCHES'),
(79, 2023, 19102446, 'ACCEPTEE', '2022-11-21 23:25:13', 20230082, 0, '2022-11-21 23:25:13', 'LES COCHES'),
(56, 2023, 19102470, 'ACCEPTEE', '2022-11-21 21:41:48', 20230061, 0, '2022-11-21 21:41:48', 'PLAGNE CENTRE'),
(46, 2023, 19102491, 'ACCEPTEE', '2022-11-10 17:15:55', 20230049, 0, '2022-11-10 17:15:55', 'AIME 2000'),
(61, 2023, 19102520, 'ACCEPTEE', '2022-11-18 15:49:29', 20230065, 0, '2022-11-18 15:49:29', 'AIME 2000'),
(10, 2023, 19102538, 'ACCEPTEE', '2022-11-11 00:09:50', 20230009, 0, '2022-11-11 00:09:50', 'BELLE PLAGNE'),
(85, 2023, 19102542, 'ACCEPTEE', '2022-12-23 08:39:10', 20230087, 0, '2022-12-23 08:39:10', 'AIME 2000'),
(160, 2023, 19102564, 'ACCEPTEE', '2022-12-13 06:39:42', 20230173, 0, '2022-12-13 06:39:42', 'AIME 2000'),
(82, 2023, 191020498, 'ACCEPTEE', '2022-11-21 21:41:48', 20230084, 0, '2022-11-21 21:41:48', 'CHAMPAGNY'),
(16, 2023, 191020510, 'ACCEPTEE', '2022-10-23 19:19:01', 20230017, 0, '2022-10-23 19:19:01', 'LES COCHES'),
(43, 2023, 191020555, 'ACCEPTEE', '2022-11-10 17:15:55', 20230045, 0, '2022-11-10 17:15:55', 'MONTALBERT'),
(40, 2023, 191020571, 'ACCEPTEE', '2022-11-10 17:15:55', 20230042, 0, '2022-11-10 17:15:55', 'BELLE PLAGNE'),
(212, 2023, 191020584, 'ACCEPTEE', '2023-03-05 09:50:43', 20230244, 0, '2023-03-05 09:50:43', 'PLAGNE CENTRE'),
(81, 2023, 191020599, 'ACCEPTEE', '2022-12-01 02:37:58', 20230083, 0, '2022-12-01 02:37:58', 'PLAGNE CENTRE'),
(69, 2023, 191020641, 'ACCEPTEE', '2022-11-18 15:49:30', 20230073, 0, '2022-11-18 15:49:30', 'MONTCHAVIN'),
(132, 2023, 191020669, 'ACCEPTEE', '2022-12-05 10:41:07', 20230140, 0, '2022-12-05 10:41:07', 'LES COCHES'),
(194, 2023, 191020679, 'ACCEPTEE', '2023-01-02 14:07:58', 20230214, 0, '2023-01-02 14:07:58', 'AIME 2000'),
(201, 2023, 191020758, 'ACCEPTEE', '2023-02-08 06:59:40', 20230225, 0, '2023-02-08 06:59:40', 'BELLE PLAGNE'),
(148, 2023, 191020774, 'ACCEPTEE', '2022-12-11 17:56:07', 20230158, 0, '2022-12-11 17:56:07', 'AIME 2000'),
(190, 2023, 191020799, 'ACCEPTEE', '2022-12-31 00:08:51', 20230209, 0, '2022-12-31 00:08:51', 'BELLE PLAGNE'),
(22, 2023, 191020830, 'ACCEPTEE', '2022-10-23 19:19:01', 20230024, 0, '2022-10-23 19:19:01', 'MONTCHAVIN'),
(119, 2023, 191020862, 'ACCEPTEE', '2022-12-31 00:08:50', 20230124, 0, '2022-12-31 00:08:50', 'CHAMPAGNY'),
(15, 2023, 191020869, 'ACCEPTEE', '2022-10-21 16:17:43', 20230016, 0, '2022-10-21 16:17:43', 'MONTCHAVIN'),
(147, 2023, 191020893, 'ACCEPTEE', '2022-12-11 17:56:07', 20230156, 0, '2022-12-11 17:56:07', 'PLAGNE CENTRE'),
(76, 2023, 191020933, 'ACCEPTEE', '2022-11-18 15:49:30', 20230078, 0, '2022-11-18 15:49:30', 'PLAGNE CENTRE'),
(31, 2023, 191021068, 'ACCEPTEE', '2022-12-01 14:25:48', 20230119, 0, '2022-12-01 14:25:48', 'PLAGNE CENTRE'),
(200, 2023, 191021074, 'ACCEPTEE', '2023-01-20 14:00:38', 20230224, 0, '2023-01-20 14:00:38', 'PLAGNE VILLAGES'),
(49, 2023, 191021129, 'ACCEPTEE', '2022-11-10 17:15:56', 20230053, 0, '2022-11-10 17:15:56', 'CHAMPAGNY'),
(130, 2023, 191021133, 'ACCEPTEE', '2022-12-05 10:41:07', 20230137, 0, '2022-12-05 10:41:06', 'BELLE PLAGNE'),
(192, 2023, 191021163, 'ACCEPTEE', '2023-01-09 09:25:09', 20230212, 0, '2023-01-09 09:25:09', 'CHAMPAGNY'),
(140, 2023, 191021165, 'ACCEPTEE', '2022-12-08 18:33:12', 20230147, 0, '2022-12-08 18:33:12', 'BELLENTRE'),
(128, 2023, 191021167, 'ACCEPTEE', '2022-12-03 11:23:47', 20230134, 0, '2022-12-03 11:23:47', 'BELLE PLAGNE'),
(186, 2023, 191021173, 'ACCEPTEE', '2022-12-27 18:06:14', 20230204, 0, '2022-12-27 18:06:14', 'PLAGNE CENTRE'),
(187, 2023, 191021174, 'ACCEPTEE', '2022-12-26 19:03:38', 20230205, 0, '0000-00-00 00:00:00', 'PLAGNE VILLAGES'),
(182, 2023, 191021180, 'ACCEPTEE', '2022-12-23 08:39:10', 20230197, 0, '2022-12-23 08:39:10', 'PLAGNE VILLAGES'),
(182, 2023, 191021180, 'ACCEPTEE', '2022-12-23 08:39:10', 20230197, 0, '2022-12-23 08:39:10', 'PLAGNE VILLAGES'),
(93, 2023, 191021212, 'ACCEPTEE', '2022-11-24 09:53:34', 20230096, 0, '2022-11-24 09:53:34', 'PLAGNE CENTRE'),
(193, 2023, 191021259, 'ACCEPTEE', '2023-01-04 14:28:42', 20230213, 0, '2023-01-04 14:28:42', 'PLAGNE BELLECOTE'),
(173, 2023, 191021305, 'ACCEPTEE', '2022-12-19 11:54:50', 20230185, 0, '2022-12-19 11:54:50', 'PLAGNE VILLAGES'),
(179, 2023, 191021350, 'ACCEPTEE', '2022-12-19 11:54:51', 20230191, 0, '2022-12-19 11:54:51', 'PLAGNE VILLAGES'),
(97, 2023, 191021415, 'ACCEPTEE', '2022-11-24 09:53:34', 20230100, 0, '2022-11-24 09:53:34', 'PLAGNE VILLAGES'),
(189, 2023, 191021421, 'ACCEPTEE', '2022-12-27 18:06:14', 20230207, 0, '2022-12-27 18:06:14', 'PLAGNE LAUZE 1800'),
(124, 2023, 191021434, 'ACCEPTEE', '2022-12-05 10:41:07', 20230139, 0, '2022-12-05 10:41:07', 'PLAGNE CENTRE'),
(195, 2023, 191021439, 'ACCEPTEE', '2023-01-10 08:53:21', 20230215, 0, '2023-01-10 08:53:21', 'PLAGNE VILLAGES'),
(174, 2023, 191021473, 'ACCEPTEE', '2022-12-19 11:54:50', 20230186, 0, '2022-12-19 11:54:50', 'BELLE PLAGNE'),
(63, 2023, 191021486, 'ACCEPTEE', '2022-11-18 15:49:29', 20230067, 0, '2022-11-18 15:49:29', 'PLAGNE VILLAGES'),
(126, 2023, 191021509, 'ACCEPTEE', '2022-12-02 14:02:36', 20230131, 0, '2022-12-02 14:02:36', 'PLAGNE CENTRE'),
(27, 2023, 191021518, 'ACCEPTEE', '2022-11-01 13:48:43', 20230029, 0, '2022-11-01 13:48:43', 'BELLE PLAGNE'),
(53, 2023, 191021524, 'ACCEPTEE', '2022-11-12 09:27:04', 20230057, 0, '2022-11-12 09:27:04', 'AIME 2000'),
(51, 2023, 191021537, 'ACCEPTEE', '2022-11-12 09:27:04', 20230055, 0, '2022-11-12 09:27:04', 'LES COCHES'),
(115, 2023, 191021613, 'ACCEPTEE', '2022-12-01 02:37:59', 20230120, 0, '2022-12-01 02:37:59', 'AIME 2000'),
(11, 2023, 191021620, 'ACCEPTEE', '2022-10-10 16:38:08', 20230010, 0, '2022-10-10 16:38:08', 'PLAGNE CENTRE'),
(54, 2023, 191021670, 'ACCEPTEE', '2022-11-18 15:49:28', 20230058, 0, '2022-11-18 15:49:28', 'PLAGNE CENTRE'),
(162, 2023, 191021675, 'ACCEPTEE', '2022-12-14 12:02:31', 20230175, 0, '2022-12-14 12:02:31', 'PLAGNE CENTRE'),
(1, 2023, 191021686, 'ACCEPTEE', '2022-09-22 10:26:57', 20230000, 0, '2022-09-22 10:26:57', 'PLAGNE SOLEIL'),
(52, 2023, 191021694, 'ACCEPTEE', '2022-11-12 09:27:04', 20230056, 0, '2022-11-12 09:27:04', 'AIME 2000'),
(65, 2023, 191021698, 'ACCEPTEE', '2022-11-18 15:49:30', 20230069, 0, '2022-11-18 15:49:30', 'PLAGNE CENTRE'),
(2, 2023, 191021711, 'ACCEPTEE', '2022-09-29 10:25:55', 20230001, 0, '2022-09-29 10:25:55', 'PLAGNE VILLAGES'),
(21, 2023, 191021717, 'ACCEPTEE', '2022-10-21 16:17:44', 20230023, 0, '2022-10-21 16:17:44', 'LES COCHES'),
(166, 2023, 191021731, 'ACCEPTEE', '2022-12-16 15:33:10', 20230179, 0, '2022-12-16 15:33:10', 'PLAGNE SOLEIL'),
(191, 2023, 191021734, 'ACCEPTEE', '2022-12-31 00:08:51', 20230210, 0, '2022-12-31 00:08:51', 'AIME 2000'),
(206, 2023, 191021736, 'ACCEPTEE', '2023-02-02 14:39:45', 20230233, 0, '2023-02-02 14:39:45', 'PLAGNE CENTRE');

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

--
-- Index pour la table `COTISATIONS_2023`
--
ALTER TABLE `COTISATIONS_2023`
  ADD PRIMARY KEY (`COT_INDEX`),
  ADD UNIQUE KEY `INDEX_UNIQUE` (`COT_SAISON`,`COT_ADHERENT`);

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

--
-- AUTO_INCREMENT pour la table `COTISATIONS_2023`
--
ALTER TABLE `COTISATIONS_2023`
  MODIFY `COT_INDEX` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=213;
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 */;
