INSERT INTO permission(nom, description, createdAt, updatedAt) VALUES('user_add', 'Ajouter un utilisateur', now(), now());
INSERT INTO permission(nom, description, createdAt, updatedAt) VALUES('user_update', "Mettre à jour l'utilisateur", now(), now());
INSERT INTO permission(nom, description, createdAt, updatedAt) VALUES('user_get', 'Obtenir un utilisateur', now(), now());
INSERT INTO permission(nom, description, createdAt, updatedAt) VALUES('user_get_all', 'Get All User', now(), now());
INSERT INTO permission(nom, description, createdAt, updatedAt) VALUES('user_delete', "Supprimer l'utilisateur", now(), now());
INSERT INTO permission(nom, description, createdAt, updatedAt) VALUES('role_add', 'Ajouter un rôle', now(), now());
INSERT INTO permission(nom, description, createdAt, updatedAt) VALUES('role_update', 'Mettre à jour le rôle', now(), now());
INSERT INTO permission(nom, description, createdAt, updatedAt) VALUES('role_get', 'Obtenir un rôle', now(), now());
INSERT INTO permission(nom, description, createdAt, updatedAt) VALUES('role_get_all', 'Obtenez tous les rôles', now(), now());
INSERT INTO permission(nom, description, createdAt, updatedAt) VALUES('role_delete', 'Supprimer le rôle', now(), now());
INSERT INTO permission(nom, description, createdAt, updatedAt) VALUES('permissions_add', 'Ajouter une autorisation', now(), now());
INSERT INTO permission(nom, description, createdAt, updatedAt) VALUES('permissions_update', "Mettre à jour l'autorisation", now(), now());
INSERT INTO permission(nom, description, createdAt, updatedAt) VALUES('permissions_get', 'Get Permission', now(), now());
INSERT INTO permission(nom, description, createdAt, updatedAt) VALUES('permissions_get_all', 'Obtenez toutes les autorisations', now(), now());
INSERT INTO permission(nom, description, createdAt, updatedAt) VALUES('permissions_delete', "Supprimer l'autorisation", now(), now());

INSERT INTO role(nom, description,privileges, createdAt, updatedAt) VALUES('admin', 'System Admin ','1,2,3,4,5,6,7,8,9,10,11,12,13,14,15', now(), now());
INSERT INTO role(nom, description,privileges, createdAt, updatedAt) VALUES('user', 'Utilisacteur ','2,4,8,9,12', now(), now());
INSERT INTO role(nom, description,privileges, createdAt, updatedAt) VALUES('abonne', 'Abonne','', now(), now());

INSERT INTO role_permission(roleId,permissionId,createdAt,updatedAt)
VALUES
(1, 1, now(), now()),
(1, 2, now(), now()),
(1, 3, now(), now()),
(1, 4, now(), now()),
(1, 5, now(), now()),
(1, 6, now(), now()),
(1, 7, now(), now()),
(1, 8, now(), now()),
(1, 9, now(), now()),
(1, 10, now(), now()),
(1, 11, now(), now()),
(1, 12, now(), now()),
(1, 13, now(), now()),
(1, 14, now(), now()),
(1, 15, now(), now()),
(2, 2, now(), now()),
(2, 4, now(), now()),
(2, 8, now(), now()),
(2, 9, now(), now()),
(2, 12, now(), now());


INSERT INTO `type_notification` (`id`, `libelle`, `createdAt`, `updatedAt`, `deletedAt`, `canal`) VALUES
(1, 'Notification de redevance', '2024-01-04 19:35:42.574686', '2024-01-04 19:35:42.574686', NULL, 'sms'),
(2, 'Notification de paiement abonnement', '2024-01-04 19:35:59.545962', '2024-01-04 19:35:59.545962', NULL, 'sms'),
(3, 'Notification de paiement redevance', '2024-01-04 19:36:11.328259', '2024-01-04 19:36:11.328259', NULL, 'sms'),
(4, 'Notification de paiement service', '2024-01-04 19:36:23.696604', '2024-01-04 19:36:23.696604', NULL, 'sms'),
(5, 'Notification de demande d\'abonnement', '2024-01-04 19:36:33.529190', '2024-01-04 19:36:33.529190', NULL, 'sms'),
(6, 'Notification de demande de transfert', '2024-01-04 19:36:52.843529', '2024-01-04 19:36:52.843529', NULL, 'sms'),
(7, 'Notification de demande de cession', '2024-01-04 19:37:00.699765', '2024-01-04 19:37:00.699765', NULL, 'sms'),
(8, 'Notification de demande d\'attestation', '2024-01-04 19:37:08.942409', '2024-01-04 19:37:08.942409', NULL, 'sms'),
(9, 'Notification de demande de résiliation', '2024-01-04 19:37:19.382193', '2024-01-04 19:37:19.382193', NULL, 'sms'),
(10, 'Notification de demande de partage d\'abonnement', '2024-01-04 19:37:29.126311', '2024-01-04 19:37:29.126311', NULL, 'sms'),
(11, 'Notification de demande de changement de clé', '2024-01-04 19:37:40.599110', '2024-01-04 19:37:40.599110', NULL, 'sms'),
(12, 'Notification de demande de réclamation', '2024-01-04 19:37:51.599524', '2024-01-04 19:37:51.599524', NULL, 'sms'),
(13, 'Notification de vœux', '2024-01-04 19:38:02.428454', '2024-01-04 19:38:54.000000', '2024-01-04 19:38:54.000000', 'sms'),
(14, 'Notification d\'envoi de réception d\'un colis', '2024-01-04 19:38:30.919401', '2024-01-04 19:38:44.000000', NULL, 'sms'),
(15, 'Notification de campagne', '2024-01-04 19:38:30.919401', '2024-01-04 19:38:44.000000', NULL, 'sms');

INSERT INTO `cle_type_notification` (`id`, `cle`, `valeur`, `createdAt`, `updatedAt`, `deletedAt`, `typeNotificationId`) VALUES
(1, '[[dateRedevance]]', 'date de la redevance', '2024-01-04 19:42:40.880763', '2024-01-04 19:42:40.880763', NULL, 1),
(2, '[[refAbo]]', 'reference de l\'abonnement', '2024-01-04 19:43:10.393699', '2024-01-04 19:43:10.393699', NULL, 2),
(3, '[[refAbo]]', 'reference de l\'abonnement', '2024-01-04 19:43:33.327495', '2024-01-04 19:43:33.327495', NULL, 3),
(4, '[[refAbo]]', 'reference de l\'abonnement', '2024-01-04 19:43:52.815808', '2024-01-04 19:43:52.815808', NULL, 4),
(5, '[[id]]', 'identifiant de la demande', '2024-01-04 19:44:19.102763', '2024-01-04 19:44:19.102763', NULL, 5),
(6, '[[id]]', 'identifiant de la demande', '2024-01-04 19:44:40.974653', '2024-01-04 19:44:40.974653', NULL, 6),
(7, '[[id]]', 'identifiant de la demande', '2024-01-04 19:45:04.121343', '2024-01-04 19:45:04.121343', NULL, 7),
(8, '[[id]]', 'identifiant de la demande', '2024-01-04 19:45:24.083878', '2024-01-04 19:45:24.083878', NULL, 8),
(9, '[[id]]', 'identifiant de la demande', '2024-01-04 19:45:46.822462', '2024-01-04 19:45:46.822462', NULL, 9),
(10, '[[id]]', 'identifiant de la demande', '2024-01-04 19:46:06.580419', '2024-01-04 19:46:06.580419', NULL, 10),
(11, '[[id]]', 'identifiant de la demande', '2024-01-04 19:46:21.838674', '2024-01-04 19:46:21.838674', NULL, 11),
(12, '[[id]]', 'identifiant de la demande', '2024-01-04 19:46:34.942558', '2024-01-04 19:46:34.942558', NULL, 12),
(13, '[[id]]', 'identifiant du colis', '2024-01-04 19:47:10.326985', '2024-01-04 19:47:10.326985', NULL, 14),
(14, '[[refRedevance]]', 'reference de la redevance', '2024-01-04 19:52:52.021633', '2024-01-04 19:52:52.021633', NULL, 1),
(15, '[[annee]]', 'annee de redevance', '2024-01-04 19:53:11.726039', '2024-01-04 19:53:11.726039', NULL, 1),
(16, '[[Abonnement:refAbo]]', 'reference de l\'abonnement', '2024-01-04 19:53:36.293571', '2024-01-04 19:53:36.293571', NULL, 1),
(17, '[[arrieres]]', 'montant des arrièrés', '2024-01-04 19:55:12.846598', '2024-01-04 19:55:12.846598', NULL, 1),
(18, '[[montant]]', 'le loyer annuel', '2024-01-04 19:55:45.443250', '2024-01-04 19:55:45.443250', NULL, 1),
(19, '[[Abonnement:montant]]', 'le montant de l\'abonnement', '2024-01-04 19:56:04.002182', '2024-01-04 19:56:04.002182', NULL, 1),
(20, '[[montantPaye]]', 'montant payée', '2024-01-04 19:57:15.830007', '2024-01-04 19:57:15.830007', NULL, 2),
(21, '[[montantRestant]]', 'montant restant du', '2024-01-04 19:58:05.868119', '2024-01-04 19:58:05.868119', NULL, 2),
(22, '[[montantPaye]]', 'montant payée', '2024-01-04 19:58:37.441767', '2024-01-04 19:58:37.441767', NULL, 3),
(23, '[[montantRestant]]', 'montant restant du', '2024-01-04 19:59:19.381243', '2024-01-04 19:59:19.381243', NULL, 3),
(24, '[[montantPaye]]', 'montant payée', '2024-01-04 19:59:37.315526', '2024-01-04 19:59:37.315526', NULL, 4),
(25, '[[montantRestant]]', 'montant restant du', '2024-01-04 19:59:57.904755', '2024-01-04 19:59:57.904755', NULL, 4),
(26, '[[refDemande]]', 'reference de la demande', '2024-01-04 20:00:28.274446', '2024-01-04 20:00:28.274446', NULL, 5),
(27, '[[dateDemande]]', 'date de la demande', '2024-01-04 20:00:42.551860', '2024-01-04 20:00:42.551860', NULL, 5),
(28, '[[status]]', 'status de la demande', '2024-01-04 20:00:57.624695', '2024-01-04 20:00:57.624695', NULL, 5),
(29, '[[nom]]', 'nom de l\'agence ou de la nouvelle agence', '2024-01-04 20:01:31.492971', '2024-01-04 20:01:31.492971', NULL, 5),
(30, '[[Typedemande:libelle]]', 'libelle type demande', '2024-01-04 20:01:44.662709', '2024-01-04 20:01:44.662709', NULL, 5),
(31, '[[code]]', 'categorie d\'abonné', '2024-01-04 20:02:04.546289', '2024-01-04 20:02:04.546289', NULL, 5),
(32, '[[Abonnement:refAbo]]', 'reference d\'abonnement', '2024-01-04 20:02:19.423308', '2024-01-04 20:02:19.423308', NULL, 5),
(33, '[[nomCompletBeneficiaire]]', 'nom de l\'abonné', '2024-01-04 20:02:32.295563', '2024-01-04 20:02:32.295563', NULL, 5),
(34, '[[telephoneBeneficiaire]]', 'telephone de l\'abonné', '2024-01-04 20:02:44.352812', '2024-01-04 20:02:44.352812', NULL, 5),
(35, '[[SecteurActivite:libelle]]', 'le libelle du secteur d\'activité de l\'abonné', '2024-01-04 20:03:03.869217', '2024-01-04 20:03:03.869217', NULL, 5),
(36, '[[montant]]', 'montant de la demande', '2024-01-04 20:03:23.253920', '2024-01-04 20:03:23.253920', NULL, 5),
(37, '[[status]]', 'le status de ma demande qui est accepté ou rejeté (champ a completer dans la base)', '2024-01-04 20:03:52.350149', '2024-01-04 20:03:52.350149', NULL, 5),
(38, '[[refDemande]]', 'reference de la demande', '2024-01-04 20:06:04.930887', '2024-01-04 20:06:04.930887', NULL, 6),
(39, '[[dateDemande]]', 'date de la demande', '2024-01-04 20:06:19.756252', '2024-01-04 20:06:19.756252', NULL, 6),
(40, '[[status]]', 'status de la demande', '2024-01-04 20:06:37.481059', '2024-01-04 20:06:37.481059', NULL, 6),
(41, '[[nom]]', 'nom de l\'agence ou de la nouvelle agence', '2024-01-04 20:06:57.834100', '2024-01-04 20:06:57.834100', NULL, 6),
(42, '[[Typedemande:libelle]]', 'libelle type demande', '2024-01-04 20:07:11.060750', '2024-01-04 20:07:11.060750', NULL, 6),
(43, '[[code]]', 'categorie d\'abonné', '2024-01-04 20:07:25.490685', '2024-01-04 20:07:25.490685', NULL, 6),
(44, '[[Abonnement:refAbo]]', 'reference d\'abonnement', '2024-01-04 20:07:40.909308', '2024-01-04 20:07:40.909308', NULL, 6),
(45, '[[nomCompletBeneficiaire]]', 'nom de l\'abonné', '2024-01-04 20:07:55.719979', '2024-01-04 20:07:55.719979', NULL, 6),
(46, '[[telephoneBeneficiaire]]', 'telephone de l\'abonné', '2024-01-04 20:08:10.659312', '2024-01-04 20:08:10.659312', NULL, 6),
(47, '[[SecteurActivite:libelle]]', 'le libelle du secteur d\'activité de l\'abonné', '2024-01-04 20:08:31.950920', '2024-01-04 20:08:31.950920', NULL, 6),
(48, '[[montant]]', 'montant de la demande', '2024-01-04 20:08:44.313817', '2024-01-04 20:08:44.313817', NULL, 6),
(49, '[[status]]', 'le status de ma demande qui est accepté ou rejeté (champ a completer dans la base)', '2024-01-04 20:09:00.044361', '2024-01-04 20:09:00.044361', NULL, 6),
(50, '[[refDemande]]', 'reference de la demande', '2024-01-04 20:09:21.196919', '2024-01-04 20:09:21.196919', NULL, 7),
(51, '[[dateDemande]]', 'date de la demande', '2024-01-04 20:09:35.233477', '2024-01-04 20:09:35.233477', NULL, 7),
(52, '[[status]]', 'status de la demande', '2024-01-04 20:09:48.746518', '2024-01-04 20:09:48.746518', NULL, 7),
(53, '[[nom]]', 'nom de l\'agence ou de la nouvelle agence', '2024-01-04 20:10:02.243980', '2024-01-04 20:10:02.243980', NULL, 7),
(54, '[[Typedemande:libelle]]', 'libelle type demande', '2024-01-04 20:10:13.450864', '2024-01-04 20:10:13.450864', NULL, 7),
(55, '[[code]]', 'categorie d\'abonné', '2024-01-04 20:10:25.296930', '2024-01-04 20:10:25.296930', NULL, 7),
(56, '[[Abonnement:refAbo]]', 'reference d\'abonnement', '2024-01-04 20:10:41.688733', '2024-01-04 20:10:41.688733', NULL, 7),
(57, '[[nomCompletBeneficiaire]]', 'nom de l\'abonné', '2024-01-04 20:10:58.060437', '2024-01-04 20:10:58.060437', NULL, 7),
(58, '[[telephoneBeneficiaire]]', 'telephone de l\'abonné', '2024-01-04 20:11:11.517071', '2024-01-04 20:11:11.517071', NULL, 7),
(59, '[[SecteurActivite:libelle]]', 'e libelle du secteur d\'activité de l\'abonné', '2024-01-04 20:11:33.833088', '2024-01-04 20:11:33.833088', NULL, 7),
(60, '[[montant]]', 'montant de la demande', '2024-01-04 20:11:47.237119', '2024-01-04 20:11:47.237119', NULL, 7),
(61, '[[status]]', 'le status de ma demande qui est accepté ou rejeté (champ a completer dans la base)', '2024-01-04 20:11:59.484624', '2024-01-04 20:11:59.484624', NULL, 7),
(62, '[[refDemande]]', 'reference de la demande', '2024-01-04 20:12:17.199591', '2024-01-04 20:12:17.199591', NULL, 8),
(63, '[[dateDemande]]', 'date de la demande', '2024-01-04 20:12:33.632419', '2024-01-04 20:12:33.632419', NULL, 8),
(64, '[[status]]', 'status de la demande', '2024-01-04 20:12:49.204690', '2024-01-04 20:12:49.204690', NULL, 8),
(65, '[[nom]]', 'nom de l\'agence ou de la nouvelle agence', '2024-01-04 20:13:02.209079', '2024-01-04 20:13:02.209079', NULL, 8),
(66, '[[Typedemande:libelle]]', 'libelle type demande', '2024-01-04 20:13:16.453010', '2024-01-04 20:13:16.453010', NULL, 8),
(67, '[[code]]', 'categorie d\'abonné', '2024-01-04 20:13:30.015201', '2024-01-04 20:13:30.015201', NULL, 8),
(68, '[[Abonnement:refAbo]]', 'reference d\'abonnement', '2024-01-04 20:13:43.864398', '2024-01-04 20:13:43.864398', NULL, 8),
(69, '[[nomCompletBeneficiaire]]', 'nom de l\'abonné', '2024-01-04 20:14:03.569058', '2024-01-04 20:14:03.569058', NULL, 8),
(70, '[[telephoneBeneficiaire]]', 'telephone de l\'abonné', '2024-01-04 20:14:24.286229', '2024-01-04 20:14:24.286229', NULL, 8),
(71, '[[SecteurActivite:libelle]]', 'le libelle du secteur d\'activité de l\'abonné [[montant]]: montant de la demande', '2024-01-04 20:14:39.869867', '2024-01-04 20:14:39.869867', NULL, 8),
(72, '[[status]]', 'le status de ma demande qui est accepté ou rejeté (champ a completer dans la base)', '2024-01-04 20:14:55.205568', '2024-01-04 20:14:55.205568', NULL, 8),
(73, '[[refDemande]] ', 'reference de la demande', '2024-01-04 20:15:33.757165', '2024-01-04 20:15:33.757165', NULL, 9),
(74, '[[dateDemande]]', ' date de la demande', '2024-01-04 20:16:03.290812', '2024-01-04 20:16:03.290812', NULL, 9),
(75, '[[status]]', 'status de la demande', '2024-01-04 20:16:22.777555', '2024-01-04 20:16:22.777555', NULL, 9),
(76, '[[nom]]', 'nom de l\'agence ou de la nouvelle agence', '2024-01-04 20:16:45.426932', '2024-01-04 20:16:45.426932', NULL, 9),
(77, '[[Typedemande:libelle]]', 'libelle type demande', '2024-01-04 20:17:05.128177', '2024-01-04 20:17:05.128177', NULL, 9),
(78, '[[code]]', 'categorie d\'abonné', '2024-01-04 20:17:24.439635', '2024-01-04 20:17:24.439635', NULL, 9),
(79, '[[Abonnement:refAbo]]', 'reference d\'abonnement', '2024-01-04 20:17:38.562761', '2024-01-04 20:17:38.562761', NULL, 9),
(80, '[[nomCompletBeneficiaire]]', 'nom de l\'abonné', '2024-01-04 20:17:55.163000', '2024-01-04 20:17:55.163000', NULL, 9),
(81, '[[telephoneBeneficiaire]]', 'telephone de l\'abonné', '2024-01-04 20:18:08.755994', '2024-01-04 20:18:08.755994', NULL, 9),
(82, '[[SecteurActivite:libelle]]', 'le libelle du secteur d\'activité de l\'abonné', '2024-01-04 20:18:23.653907', '2024-01-04 20:18:23.653907', NULL, 9),
(83, '[[montant]]', 'montant de la demande', '2024-01-04 20:18:36.708584', '2024-01-04 20:18:36.708584', NULL, 9),
(84, '[[status]]', 'le status de ma demande qui est accepté ou rejeté (champ a completer dans la base)', '2024-01-04 20:18:52.576567', '2024-01-04 20:18:52.576567', NULL, 9),
(85, '[[refDemande]]', 'reference de la demande', '2024-01-04 20:19:16.112121', '2024-01-04 20:19:16.112121', NULL, 10),
(86, '[[dateDemande]]', 'date de la demande', '2024-01-04 20:19:40.143432', '2024-01-04 20:19:40.143432', NULL, 10),
(87, '[[status]]', 'status de la demande', '2024-01-04 20:20:02.928778', '2024-01-04 20:20:02.928778', NULL, 10),
(88, '[[nom]]', 'nom de l\'agence ou de la nouvelle agence', '2024-01-04 20:20:17.923802', '2024-01-04 20:20:17.923802', NULL, 10),
(89, '[[Typedemande:libelle]]', 'libelle type demande', '2024-01-04 20:20:36.811286', '2024-01-04 20:20:36.811286', NULL, 10),
(90, '[[code]]', 'categorie d\'abonné', '2024-01-04 20:20:52.265126', '2024-01-04 20:20:52.265126', NULL, 10),
(91, '[[Abonnement:refAbo]]', 'reference d\'abonnement', '2024-01-04 20:21:14.472749', '2024-01-04 20:21:14.472749', NULL, 10),
(92, '[[nomCompletBeneficiaire]]', 'nom de l\'abonné', '2024-01-04 20:21:35.612070', '2024-01-04 20:21:35.612070', NULL, 10),
(93, '[[telephoneBeneficiaire]]', 'telephone de l\'abonné', '2024-01-04 20:21:56.054057', '2024-01-04 20:21:56.054057', NULL, 10),
(94, '[[SecteurActivite:libelle]]', 'le libelle du secteur d\'activité de l\'abonné', '2024-01-04 20:22:16.901567', '2024-01-04 20:22:16.901567', NULL, 10),
(95, '[[montant]]', 'montant de la demande', '2024-01-04 20:22:34.255573', '2024-01-04 20:22:34.255573', NULL, 10),
(96, '[[status]]', 'le status de ma demande qui est accepté ou rejeté (champ a completer dans la base)', '2024-01-04 20:22:50.619130', '2024-01-04 20:22:50.619130', NULL, 10),
(97, '[[refDemande]]', 'reference de la demande', '2024-01-04 20:23:11.119285', '2024-01-04 20:23:11.119285', NULL, 11),
(98, '[[dateDemande]]', 'date de la demande', '2024-01-04 20:23:29.662868', '2024-01-04 20:23:29.662868', NULL, 11),
(99, '[[status]]', 'status de la demande', '2024-01-04 20:23:49.316615', '2024-01-04 20:23:49.316615', NULL, 11),
(100, '[[nom]]', 'nom de l\'agence ou de la nouvelle agence', '2024-01-04 20:24:05.344374', '2024-01-04 20:24:28.000000', NULL, 11),
(101, '[[Typedemande:libelle]]', 'libelle type demande', '2024-01-04 20:26:17.692239', '2024-01-04 20:26:17.692239', NULL, 11),
(102, '[[code]]', 'categorie d\'abonné', '2024-01-04 20:26:32.817803', '2024-01-04 20:26:32.817803', NULL, 11),
(103, '[[Abonnement:refAbo]]', 'reference d\'abonnement', '2024-01-04 20:26:56.448210', '2024-01-04 20:26:56.448210', NULL, 11),
(104, '[[nomCompletBeneficiaire]]', 'nom de l\'abonné', '2024-01-04 20:27:09.329995', '2024-01-04 20:27:09.329995', NULL, 11),
(105, '[[telephoneBeneficiaire]]', 'telephone de l\'abonné', '2024-01-04 20:27:24.077096', '2024-01-04 20:27:24.077096', NULL, 11),
(106, '[[SecteurActivite:libelle]]', 'le libelle du secteur d\'activité de l\'abonné', '2024-01-04 20:27:46.937638', '2024-01-04 20:27:46.937638', NULL, 11),
(107, '[[montant]]', 'montant de la demande', '2024-01-04 20:28:02.819207', '2024-01-04 20:28:02.819207', NULL, 11),
(108, '[[status]] ', 'le status de ma demande qui est accepté ou rejeté (champ a completer dans la base)', '2024-01-04 20:28:42.214594', '2024-01-04 20:28:42.214594', NULL, 11),
(109, '[[refDemande]]', 'reference de la demande', '2024-01-04 20:29:03.981240', '2024-01-04 20:29:03.981240', NULL, 12),
(110, '[[dateDemande]]', 'date de la demande', '2024-01-04 20:29:20.680817', '2024-01-04 20:29:20.680817', NULL, 12),
(111, '[[status]]', 'status de la demande', '2024-01-04 20:29:41.516048', '2024-01-04 20:29:41.516048', NULL, 12),
(112, '[[nom]]', 'nom de l\'agence ou de la nouvelle agence', '2024-01-04 20:29:58.520305', '2024-01-04 20:29:58.520305', NULL, 12),
(113, '[[Typedemande:libelle]]', 'libelle type demande', '2024-01-04 20:30:28.392264', '2024-01-04 20:30:28.392264', NULL, 12),
(114, '[[code]]', 'categorie d\'abonné', '2024-01-04 20:30:44.998155', '2024-01-04 20:30:44.998155', NULL, 12),
(115, '[[Abonnement:refAbo]]', 'reference d\'abonnement', '2024-01-04 20:31:04.677911', '2024-01-04 20:31:04.677911', NULL, 12),
(116, '[[nomCompletBeneficiaire]]', 'nom de l\'abonné', '2024-01-04 20:31:21.969086', '2024-01-04 20:31:21.969086', NULL, 12),
(117, '[[telephoneBeneficiaire]]', 'telephone de l\'abonné', '2024-01-04 20:31:46.349773', '2024-01-04 20:31:46.349773', NULL, 12),
(118, '[[SecteurActivite:libelle]]', 'le libelle du secteur d\'activité de l\'abonné [[montant]]: montant de la demande', '2024-01-04 20:32:03.529656', '2024-01-04 20:32:03.529656', NULL, 12),
(119, '[[status]]', 'le status de ma demande qui est accepté ou rejeté (champ a completer dans la base)', '2024-01-04 20:32:18.134571', '2024-01-04 20:32:18.134571', NULL, 12),
(120, '[[refColis]]', 'référence du colis', '2024-01-04 20:32:44.725175', '2024-01-04 20:32:44.725175', NULL, 14),
(121, '[[estLivre]]', 'statut du colis', '2024-01-04 20:32:58.639613', '2024-01-04 20:32:58.639613', NULL, 14),
(122, '[[Abonnement:Abonne:telephone]]', 'téléphone de l\'abonnement', '2024-01-04 20:33:15.536890', '2024-01-04 20:33:15.536890', NULL, 14),
(123, '[[montant]]', 'montant de la demande', '2024-01-04 20:56:07.553026', '2024-01-04 20:56:07.553026', NULL, 8),
(124, '[[montant]]', 'montant de la demande', '2024-01-04 20:57:49.052786', '2024-01-04 20:57:49.052786', NULL, 12);








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

INSERT INTO `region` (`id`, `libelle`, `code`, `createdAt`, `updatedAt`, `deletedAt`, `userCreationId`) VALUES
(1, 'REGION 1', 'REG', 'CURRENT_TIMESTAMP(6).000000', 'CURRENT_TIMESTAMP(6).000000', NULL, NULL);


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

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

INSERT INTO `commune` (`id`, `code`, `createdAt`, `updatedAt`, `deletedAt`, `regionId`, `userCreationId`, `libelle`) VALUES
(1, 'BKA', '2024-01-14 06:43:24.117951', '2024-01-26 12:42:58.631023', NULL, 1, NULL, 'Banikoara'),
(2, 'GOG', '2024-01-14 06:43:24.129982', '2024-01-26 12:44:19.184321', NULL, 1, NULL, 'Gogounou'),
(3, 'KAN', '2024-01-14 06:43:24.138967', '2024-01-26 12:44:19.184321', NULL, 1, NULL, 'Kandi'),
(4, 'KAR:', '2024-01-14 06:43:24.147664', '2024-01-26 12:44:19.184321', NULL, 1, NULL, 'Karimama'),
(5, 'MAL', '2024-01-14 06:43:24.159117', '2024-01-26 12:44:19.184321', NULL, 1, NULL, 'Malanville'),
(6, 'SEG', '2024-01-14 06:43:24.168794', '2024-01-26 12:44:19.184321', NULL, 1, NULL, 'Segbana'),
(7, 'BOU', '2024-01-14 06:43:24.178831', '2024-01-26 12:44:19.184321', NULL, 1, NULL, 'Boukoumbé'),
(8, 'COB', '2024-01-14 06:43:24.189699', '2024-01-26 12:44:19.184321', NULL, 1, NULL, 'Cobly'),
(9, 'KER', '2024-01-14 06:43:24.198502', '2024-01-26 12:44:19.184321', NULL, 1, NULL, 'Kérou'),
(10, 'KOU', '2024-01-14 06:43:24.208126', '2024-01-26 12:44:19.184321', NULL, 1, NULL, 'Kouandé'),
(11, 'MAT', '2024-01-14 06:43:24.218812', '2024-01-26 12:44:19.184321', NULL, 1, NULL, 'Matéri'),
(12, 'NAT', '2024-01-14 06:43:24.230676', '2024-01-26 12:44:19.184321', NULL, 1, NULL, 'Natitingou'),
(13, 'PEH', '2024-01-14 06:43:24.242499', '2024-01-26 12:44:19.184321', NULL, 1, NULL, 'Péhunco'),
(14, 'TAN', '2024-01-14 06:43:24.251494', '2024-01-26 12:44:19.184321', NULL, 1, NULL, 'Tanguiéta'),
(15, 'TOU', '2024-01-14 06:43:24.261814', '2024-01-26 12:44:19.184321', NULL, 1, NULL, 'Toucountouna'),
(16, 'ACA', '2024-01-14 06:43:24.272769', '2024-01-26 12:44:19.184321', NULL, 1, NULL, 'Abomey-Calavi'),
(17, 'ALL', '2024-01-14 06:43:24.280622', '2024-01-26 12:44:19.184321', NULL, 1, NULL, 'Allada'),
(18, 'KPO', '2024-01-14 06:43:24.288949', '2024-01-26 12:44:19.184321', NULL, 1, NULL, 'Kpomassè'),
(19, 'OUI', '2024-01-14 06:43:24.295917', '2024-01-26 12:44:19.184321', NULL, 1, NULL, 'Ouidah'),
(20, 'SOA', '2024-01-14 06:43:24.306520', '2024-01-26 12:44:19.184321', NULL, 1, NULL, 'Sô-Ava'),
(21, 'TOF', '2024-01-14 06:43:24.314160', '2024-01-26 12:44:19.184321', NULL, 1, NULL, 'Toffo'),
(22, 'TOR', '2024-01-14 06:43:24.324566', '2024-01-26 12:44:19.184321', NULL, 1, NULL, 'Tori-Bossito'),
(23, 'ZE', '2024-01-14 06:43:24.335863', '2024-01-26 12:44:19.184321', NULL, 1, NULL, 'Zè'),
(24, 'BEM', '2024-01-14 06:43:24.345717', '2024-01-26 12:44:19.184321', NULL, 1, NULL, 'Bembéréké'),
(25, 'KAL', '2024-01-14 06:43:24.355000', '2024-01-26 12:44:19.184321', NULL, 1, NULL, 'Kalalé'),
(26, 'NDA', '2024-01-14 06:43:24.361351', '2024-01-26 12:44:19.184321', NULL, 1, NULL, 'NDali'),
(27, 'NIK', '2024-01-14 06:43:24.370930', '2024-01-26 12:44:19.184321', NULL, 1, NULL, 'Nikki'),
(28, 'PAR', '2024-01-14 06:43:24.380581', '2024-01-26 12:44:19.184321', NULL, 1, NULL, 'Parakou'),
(29, 'PER', '2024-01-14 06:43:24.390116', '2024-01-26 12:44:19.184321', NULL, 1, NULL, 'Pèrèrè'),
(30, 'SIN', '2024-01-14 06:43:24.398103', '2024-01-26 12:44:19.184321', NULL, 1, NULL, 'Sinendé'),
(31, 'TCH', '2024-01-14 06:43:24.409262', '2024-01-26 12:44:19.184321', NULL, 1, NULL, 'Tchaourou'),
(32, 'BAN', '2024-01-14 06:43:24.417567', '2024-01-26 12:44:19.184321', NULL, 1, NULL, 'Bantè'),
(33, 'DAZ', '2024-01-14 06:43:24.426742', '2024-01-26 12:44:19.184321', NULL, 1, NULL, 'Dassa-Zoumé'),
(34, 'GLA', '2024-01-14 06:43:24.436593', '2024-01-26 12:44:19.184321', NULL, 1, NULL, 'Glazoué'),
(35, 'OUE', '2024-01-14 06:43:24.445705', '2024-01-26 12:44:19.184321', NULL, 1, NULL, 'Ouèssè'),
(36, 'SVL', '2024-01-14 06:43:24.455297', '2024-01-26 12:44:19.184321', NULL, 1, NULL, 'Savalou'),
(37, 'SAV', '2024-01-14 06:43:24.462658', '2024-01-26 12:44:19.184321', NULL, 1, NULL, 'Savè'),
(38, 'APL', '2024-01-14 06:43:24.470988', '2024-01-26 12:44:19.184321', NULL, 1, NULL, 'Aplahoué'),
(39, 'DJA', '2024-01-14 06:43:24.479240', '2024-01-26 12:44:19.184321', NULL, 1, NULL, 'Djakotomey'),
(40, 'DOG', '2024-01-14 06:43:24.488269', '2024-01-26 12:44:19.184321', NULL, 1, NULL, 'Dogbo'),
(41, 'KLO', '2024-01-14 06:43:24.497275', '2024-01-26 12:44:19.184321', NULL, 1, NULL, 'Klouékanmè'),
(42, 'LAL', '2024-01-14 06:43:24.506946', '2024-01-26 12:44:19.184321', NULL, 1, NULL, 'Lalo'),
(43, 'TOV', '2024-01-14 06:43:24.516290', '2024-01-26 12:44:19.184321', NULL, 1, NULL, 'Toviklin'),
(44, 'BAS', '2024-01-14 06:43:24.525122', '2024-01-26 12:44:19.184321', NULL, 1, NULL, 'Bassila'),
(45, 'COP', '2024-01-14 06:43:24.532679', '2024-01-26 12:44:19.184321', NULL, 1, NULL, 'Copargo'),
(46, 'DJO', '2024-01-14 06:43:24.541101', '2024-01-26 12:44:19.184321', NULL, 1, NULL, 'Djougou'),
(47, 'OUA', '2024-01-14 06:43:24.549636', '2024-01-26 12:44:19.184321', NULL, 1, NULL, 'Ouaké'),
(48, 'COT', '2024-01-14 06:43:24.558326', '2024-01-26 12:44:19.184321', NULL, 1, NULL, 'Cotonou'),
(49, 'ATH', '2024-01-14 06:43:24.565352', '2024-01-26 12:44:19.184321', NULL, 1, NULL, 'Athiémé'),
(50, 'BOP', '2024-01-14 06:43:24.575745', '2024-01-26 12:44:19.184321', NULL, 1, NULL, 'Bopa'),
(51, 'COM', '2024-01-14 06:43:24.583163', '2024-01-26 12:44:19.184321', NULL, 1, NULL, 'Comè'),
(52, 'GRA', '2024-01-14 06:43:24.590610', '2024-01-26 12:44:19.184321', NULL, 1, NULL, 'Grand-Popo'),
(53, 'HOU', '2024-01-14 06:43:24.597941', '2024-01-26 12:44:19.184321', NULL, 1, NULL, 'Houéyogbé'),
(54, 'LOK', '2024-01-14 06:43:24.606308', '2024-01-26 12:44:19.184321', NULL, 1, NULL, 'Lokossa'),
(55, 'AJA', '2024-01-14 06:43:24.613946', '2024-01-26 12:44:19.184321', NULL, 1, NULL, 'Adjarra'),
(56, 'ADN', '2024-01-14 06:43:24.623379', '2024-01-26 12:44:19.184321', NULL, 1, NULL, 'Adjohoun'),
(57, 'AGU', '2024-01-14 06:43:24.631183', '2024-01-26 12:44:19.184321', NULL, 1, NULL, 'Aguégués'),
(58, 'AKP', '2024-01-14 06:43:24.643178', '2024-01-26 12:44:19.184321', NULL, 1, NULL, 'Akpro-Missérété'),
(59, 'AVR', '2024-01-14 06:43:24.652434', '2024-01-26 12:44:19.184321', NULL, 1, NULL, 'Avrankou'),
(60, 'BON', '2024-01-14 06:43:24.660749', '2024-01-26 12:44:19.184321', NULL, 1, NULL, 'Bonou'),
(61, 'DAN', '2024-01-14 06:43:24.670057', '2024-01-26 12:44:19.184321', NULL, 1, NULL, 'Dangbo'),
(62, 'POR', '2024-01-14 06:43:24.677711', '2024-01-26 12:44:19.184321', NULL, 1, NULL, 'Porto-Novo'),
(63, 'SEM', '2024-01-14 06:43:24.686561', '2024-01-26 12:44:19.184321', NULL, 1, NULL, 'Sèmè-Kpodji'),
(64, 'ADO', '2024-01-14 06:43:24.695555', '2024-01-26 12:44:19.184321', NULL, 1, NULL, 'Adja-Ouèrè'),
(65, 'IFA', '2024-01-14 06:43:24.704976', '2024-01-26 12:44:19.184321', NULL, 1, NULL, 'Ifangni'),
(66, 'KET', '2024-01-14 06:43:24.715402', '2024-01-26 12:44:19.184321', NULL, 1, NULL, 'Kétou'),
(67, 'POB', '2024-01-14 06:43:24.723422', '2024-01-26 12:44:19.184321', NULL, 1, NULL, 'Pobè'),
(68, 'SAK', '2024-01-14 06:43:24.731052', '2024-01-26 12:44:19.184321', NULL, 1, NULL, 'Sakété'),
(69, 'ABO', '2024-01-14 06:43:24.739448', '2024-01-26 12:44:19.184321', NULL, 1, NULL, 'Abomey'),
(70, 'AGB', '2024-01-14 06:43:24.747693', '2024-01-26 12:44:19.184321', NULL, 1, NULL, 'Agbangnizoun'),
(71, 'BOH', '2024-01-14 06:43:24.762480', '2024-01-26 12:44:19.184321', NULL, 1, NULL, 'Bohicon'),
(72, 'COV', '2024-01-14 06:43:24.771025', '2024-01-26 12:44:19.184321', NULL, 1, NULL, 'Covè'),
(73, 'DJI', '2024-01-14 06:43:24.781535', '2024-01-26 12:44:19.184321', NULL, 1, NULL, 'Djidja'),
(74, 'OUH', '2024-01-14 06:43:24.792002', '2024-01-26 12:44:19.184321', NULL, 1, NULL, 'Ouinhi'),
(75, 'ZAK', '2024-01-14 06:43:24.799729', '2024-01-26 12:44:19.184321', NULL, 1, NULL, 'Za-Kpota'),
(76, 'ZAG', '2024-01-14 06:43:24.809945', '2024-01-26 12:44:19.184321', NULL, 1, NULL, 'Zagnanado'),
(77, 'ZOG', '2024-01-14 06:43:24.817101', '2024-01-26 12:44:19.184321', NULL, 1, NULL, 'Zogbodomey');


