-- Table structure for table `wpinst_amelia_providers_to_daysoff`
--

CREATE TABLE `wpinst_amelia_providers_to_daysoff` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `userId` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `startDate` date NOT NULL,
  `endDate` date NOT NULL,
  `repeat` tinyint(1) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wpinst_amelia_providers_to_daysoff`
--

INSERT INTO `wpinst_amelia_providers_to_daysoff` VALUES (2,1,'Opération Grain de beauté','2023-03-02','2023-03-02',0),(3,1,'Anniversaire 80 ans pépé ','2023-06-17','2023-06-17',0),(4,1,'Absences','2023-11-11','2023-11-12',0),(5,1,'Absence','2023-11-19','2023-11-19',0),(6,1,'Absence','2023-12-03','2023-12-03',0),(7,1,'Absence','2023-12-09','2023-12-10',0),(8,1,'Vacences','2023-12-19','2023-12-28',0),(9,1,'Absence','2024-01-14','2024-01-14',0),(10,1,'Absence','2024-01-20','2024-01-21',0),(11,1,'Absence','2024-02-18','2024-02-18',0),(12,1,'Absence','2024-03-10','2024-03-11',0),(13,1,'Absence','2024-03-18','2024-03-18',0),(14,1,'Absence','2024-04-14','2024-04-15',0),(16,1,'Absence','2024-05-05','2024-05-06',0),(17,1,'Absence','2024-05-12','2024-05-13',0),(18,1,'Absence','2024-05-20','2024-05-20',0),(19,1,'Abscence','2024-06-02','2024-06-03',0),(20,1,'Abscence','2024-06-10','2024-06-10',0),(21,1,'Abscence','2024-06-23','2024-06-24',0),(22,1,'Abscence','2023-11-26','2023-11-26',0),(23,1,'Abscence','2023-12-02','2023-12-02',0);

--
-- Table structure for table `wpinst_amelia_providers_to_google_calendar`
--

CREATE TABLE `wpinst_amelia_providers_to_google_calendar` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `userId` int(11) NOT NULL,
  `token` text NOT NULL,
  `calendarId` text,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wpinst_amelia_providers_to_google_calendar`
--

INSERT INTO `wpinst_amelia_providers_to_google_calendar` VALUES (1,1,'{\"access_token\":\"ya29.a0AeDClZC78vt9sSeiIGxhg4aOonFZm6oeHrGwjebAPrKlW0B4E7r5ERq09wmZqGk_gdN-aSnguCmiqIy9NVI49Dy-n7TV7GhjAO51sp6RWHa6y5gd5W0yRgw2_lL2C9t84BbVXSa2_H0fEwXty_knhnNvvsrJ3LCSCjbHYPMi-esaCgYKAekSARESFQHGX2MieUb-rOwdtTq2IFpSJyXofA0178\",\"expires_in\":3599,\"refresh_token\":\"1\\/\\/03op-1UmZaZspCgYIARAAGAMSNwF-L9IrXVoxF8TFsLWsCPyrQZUeY8gJ0H19EHUk6YAY-3n65ppHgdoSZPxrq738phM9Zw3Oue0\",\"scope\":\"https:\\/\\/www.googleapis.com\\/auth\\/calendar\",\"token_type\":\"Bearer\",\"created\":1731951183}','thierry.parian@gmail.com');

--
-- Table structure for table `wpinst_amelia_providers_to_locations`
--

CREATE TABLE `wpinst_amelia_providers_to_locations` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `userId` int(11) NOT NULL,
  `locationId` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wpinst_amelia_providers_to_locations`
--

INSERT INTO `wpinst_amelia_providers_to_locations` VALUES (2,1,2);

--
-- Table structure for table `wpinst_amelia_providers_to_outlook_calendar`
--

CREATE TABLE `wpinst_amelia_providers_to_outlook_calendar` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `userId` int(11) NOT NULL,
  `token` text NOT NULL,
  `calendarId` text,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wpinst_amelia_providers_to_outlook_calendar`
--


--
-- Table structure for table `wpinst_amelia_providers_to_periods`
--

CREATE TABLE `wpinst_amelia_providers_to_periods` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `weekDayId` int(11) NOT NULL,
  `locationId` int(11) DEFAULT NULL,
  `startTime` time NOT NULL,
  `endTime` time NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wpinst_amelia_providers_to_periods`
--

INSERT INTO `wpinst_amelia_providers_to_periods` VALUES (8,8,2,'09:00:00','17:30:00'),(10,10,2,'09:00:00','17:30:00'),(11,11,2,'09:00:00','20:00:00');

--
-- Table structure for table `wpinst_amelia_providers_to_periods_location`
--

CREATE TABLE `wpinst_amelia_providers_to_periods_location` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `periodId` int(11) NOT NULL,
  `locationId` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wpinst_amelia_providers_to_periods_location`
--


--
-- Table structure for table `wpinst_amelia_providers_to_periods_services`
--

CREATE TABLE `wpinst_amelia_providers_to_periods_services` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `periodId` int(11) NOT NULL,
  `serviceId` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wpinst_amelia_providers_to_periods_services`
--


--
-- Table structure for table `wpinst_amelia_providers_to_services`
--

CREATE TABLE `wpinst_amelia_providers_to_services` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `userId` int(11) NOT NULL,
  `serviceId` int(11) NOT NULL,
  `price` double NOT NULL,
  `minCapacity` int(11) NOT NULL,
  `maxCapacity` int(11) NOT NULL,
  `customPricing` text,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=31 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wpinst_amelia_providers_to_services`
--

INSERT INTO `wpinst_amelia_providers_to_services` VALUES (9,1,9,60,1,1,'{\"enabled\":false,\"durations\":{}}'),(15,1,15,60,1,1,'{\"enabled\":false,\"durations\":{}}'),(19,1,19,20,1,1,'{\"enabled\":false,\"durations\":{}}'),(22,1,34,120,1,1,'{\"enabled\":false,\"durations\":{}}'),(23,1,35,120,1,1,'{\"enabled\":true,\"durations\":{\"5400\":{\"price\":90,\"rules\":[]}}}'),(24,1,24,30,1,1,'{\"enabled\":true,\"durations\":{\"2700\":{\"price\":45,\"rules\":[]},\"3600\":{\"price\":60,\"rules\":[]}}}'),(25,1,25,30,1,1,'{\"enabled\":true,\"durations\":{\"3600\":{\"price\":60,\"rules\":[]},\"5400\":{\"price\":90,\"rules\":[]},\"7200\":{\"price\":120,\"rules\":[]}}}'),(26,1,26,60,1,1,'{\"enabled\":false,\"durations\":{}}'),(27,1,36,60,1,1,'{\"enabled\":false,\"durations\":{}}'),(28,1,37,0,1,1,'{\"enabled\":false,\"durations\":{}}'),(29,1,38,0,1,1,'{\"enabled\":false,\"durations\":{}}'),(30,1,39,90,1,1,'{\"enabled\":false,\"durations\":{}}');

--
-- Table structure for table `wpinst_amelia_providers_to_specialdays`
--

CREATE TABLE `wpinst_amelia_providers_to_specialdays` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `userId` int(11) NOT NULL,
  `startDate` date NOT NULL,
  `endDate` date NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=37 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wpinst_amelia_providers_to_specialdays`
--

INSERT INTO `wpinst_amelia_providers_to_specialdays` VALUES (11,1,'2023-04-29','2023-04-29'),(13,1,'2023-06-17','2023-06-17'),(15,1,'2023-02-27','2023-02-27'),(16,1,'2023-03-21','2023-03-21'),(17,1,'2023-03-06','2023-03-06'),(18,1,'2023-03-07','2023-03-07'),(19,1,'2023-03-08','2023-03-08'),(20,1,'2023-03-13','2023-03-13'),(21,1,'2023-03-14','2023-03-14'),(22,1,'2023-03-15','2023-03-15'),(23,1,'2023-03-16','2023-03-16'),(24,1,'2023-03-17','2023-03-17'),(25,1,'2023-03-23','2023-03-23'),(26,1,'2023-03-24','2023-03-24'),(27,1,'2023-03-28','2023-03-28'),(28,1,'2023-03-30','2023-03-30'),(29,1,'2023-04-24','2023-04-24'),(31,1,'2023-06-16','2023-06-16'),(32,1,'2023-07-28','2023-07-28'),(33,1,'2023-08-21','2023-08-21'),(34,1,'2023-09-29','2023-09-29'),(35,1,'2023-10-20','2023-10-20'),(36,1,'2023-11-06','2023-11-06');

--
-- Table structure for table `wpinst_amelia_providers_to_specialdays_periods`
--

CREATE TABLE `wpinst_amelia_providers_to_specialdays_periods` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `specialDayId` int(11) NOT NULL,
  `locationId` int(11) DEFAULT NULL,
  `startTime` time NOT NULL,
  `endTime` time NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=37 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wpinst_amelia_providers_to_specialdays_periods`
--

INSERT INTO `wpinst_amelia_providers_to_specialdays_periods` VALUES (11,11,NULL,'09:00:00','14:00:00'),(13,13,NULL,'09:00:00','14:00:00'),(15,15,NULL,'09:00:00','19:00:00'),(16,16,NULL,'09:00:00','19:00:00'),(17,17,2,'16:00:00','20:00:00'),(18,18,2,'12:00:00','18:00:00'),(19,19,2,'13:00:00','18:00:00'),(20,20,2,'17:00:00','20:00:00'),(21,21,2,'16:00:00','18:00:00'),(22,22,2,'16:00:00','18:00:00'),(23,23,2,'15:00:00','18:00:00'),(24,24,2,'14:00:00','20:00:00'),(25,25,2,'09:00:00','12:00:00'),(26,26,2,'13:00:00','20:00:00'),(27,27,2,'14:00:00','18:00:00'),(28,28,2,'09:00:00','12:00:00'),(29,29,NULL,'09:00:00','19:00:00'),(31,31,NULL,'10:00:00','18:00:00'),(32,32,NULL,'10:00:00','18:00:00'),(33,33,NULL,'10:00:00','18:00:00'),(34,34,NULL,'10:00:00','18:00:00'),(35,35,NULL,'10:00:00','18:00:00'),(36,36,NULL,'10:00:00','18:00:00');

--
-- Table structure for table `wpinst_amelia_providers_to_specialdays_periods_location`
--

CREATE TABLE `wpinst_amelia_providers_to_specialdays_periods_location` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `periodId` int(11) NOT NULL,
  `locationId` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wpinst_amelia_providers_to_specialdays_periods_location`
--


--
-- Table structure for table `wpinst_amelia_providers_to_specialdays_periods_services`
--

CREATE TABLE `wpinst_amelia_providers_to_specialdays_periods_services` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `periodId` int(11) NOT NULL,
  `serviceId` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=324 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wpinst_amelia_providers_to_specialdays_periods_services`
--

INSERT INTO `wpinst_amelia_providers_to_specialdays_periods_services` VALUES (81,11,15),(87,11,9),(97,13,15),(103,13,9),(114,15,15),(115,15,9),(125,16,15),(126,16,9),(134,17,19),(135,17,15),(136,17,9),(144,18,19),(145,18,15),(146,18,9),(154,19,19),(155,19,15),(156,19,9),(164,20,19),(165,20,15),(166,20,9),(174,21,19),(175,21,15),(176,21,9),(184,22,19),(185,22,15),(186,22,9),(194,23,19),(195,23,15),(196,23,9),(204,24,19),(205,24,15),(206,24,9),(214,25,19),(215,25,15),(216,25,9),(224,26,15),(225,26,9),(233,26,19),(234,27,15),(235,27,9),(243,27,19),(244,28,15),(245,28,9),(253,28,19),(254,29,15),(255,29,9),(273,31,15),(274,31,9),(283,32,15),(284,32,9),(293,33,15),(294,33,9),(303,34,15),(304,34,9),(305,34,24),(306,34,25),(307,34,26),(308,34,34),(309,34,35),(310,35,15),(311,35,9),(312,35,24),(313,35,25),(314,35,26),(315,35,34),(316,35,35),(317,36,15),(318,36,9),(319,36,24),(320,36,25),(321,36,26),(322,36,34),(323,36,35);

--
-- Table structure for table `wpinst_amelia_providers_to_timeouts`
--

CREATE TABLE `wpinst_amelia_providers_to_timeouts` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `weekDayId` int(11) NOT NULL,
  `startTime` time NOT NULL,
  `endTime` time NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wpinst_amelia_providers_to_timeouts`
--


--
-- Table structure for table `wpinst_amelia_providers_to_weekdays`
--

CREATE TABLE `wpinst_amelia_providers_to_weekdays` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `userId` int(11) NOT NULL,
  `dayIndex` tinyint(2) NOT NULL,
  `startTime` time NOT NULL,
  `endTime` time NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wpinst_amelia_providers_to_weekdays`
--

INSERT INTO `wpinst_amelia_providers_to_weekdays` VALUES (8,1,2,'09:00:00','17:30:00'),(10,1,4,'09:00:00','17:30:00'),(11,1,5,'09:00:00','20:00:00');

--
-- Table structure for table `wpinst_amelia_providers_views`
--

CREATE TABLE `wpinst_amelia_providers_views` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `userId` int(11) NOT NULL,
  `date` date NOT NULL,
  `views` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=72 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wpinst_amelia_providers_views`
--

INSERT INTO `wpinst_amelia_providers_views` VALUES (1,1,'2022-12-02',4),(2,1,'2022-12-05',2),(3,1,'2022-12-06',1),(4,1,'2022-12-07',1),(5,1,'2022-12-20',1),(6,1,'2022-12-22',1),(7,1,'2022-12-30',1),(8,1,'2023-01-03',1),(9,1,'2023-01-10',6),(10,1,'2023-02-02',1),(11,1,'2023-02-10',1),(12,1,'2023-02-13',2),(13,1,'2023-02-18',1),(14,1,'2023-02-22',1),(15,1,'2023-02-24',3),(16,1,'2023-02-26',1),(17,1,'2023-02-28',1),(18,1,'2023-03-01',1),(19,1,'2023-03-02',2),(20,1,'2023-03-03',3),(21,1,'2023-03-04',1),(22,1,'2023-03-06',2),(23,1,'2023-03-08',1),(24,1,'2023-03-09',1),(25,1,'2023-03-22',2),(26,1,'2023-03-31',2),(27,1,'2023-04-02',1),(28,1,'2023-04-04',1),(29,1,'2023-04-12',1),(30,1,'2023-04-20',2),(31,1,'2023-04-26',1),(32,1,'2023-05-06',1),(33,1,'2023-05-10',1),(34,1,'2023-05-15',1),(35,1,'2023-05-17',1),(36,1,'2023-05-31',1),(37,1,'2023-06-05',1),(38,1,'2023-06-06',1),(39,1,'2023-06-07',3),(40,1,'2023-07-04',1),(41,1,'2023-07-25',1),(42,1,'2023-08-06',1),(43,1,'2023-08-09',1),(44,1,'2023-10-09',1),(45,1,'2023-10-16',1),(46,1,'2023-11-09',1),(47,1,'2023-11-15',1),(48,1,'2023-11-21',1),(49,1,'2023-11-27',1),(50,1,'2023-12-01',1),(51,1,'2023-12-07',1),(52,1,'2023-12-25',1),(53,1,'2024-01-11',2),(54,1,'2024-03-27',1),(55,1,'2024-04-06',1),(56,1,'2024-04-24',2),(57,1,'2024-04-29',1),(58,1,'2024-05-14',1),(59,1,'2024-05-23',1),(60,1,'2024-06-13',4),(61,1,'2024-06-21',1),(62,1,'2024-06-26',1),(63,1,'2024-07-01',4),(64,1,'2024-07-10',1),(65,1,'2024-09-04',2),(66,1,'2024-10-27',1),(67,1,'2024-10-30',1),(68,1,'2024-11-10',1),(69,1,'2024-11-11',1),(70,1,'2024-11-14',1),(71,1,'2024-11-17',1);

--
-- Table structure for table `wpinst_amelia_resources`
--

CREATE TABLE `wpinst_amelia_resources` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL DEFAULT '',
  `quantity` int(11) DEFAULT '1',
  `shared` enum('service','location') DEFAULT NULL,
  `status` enum('hidden','visible','disabled') NOT NULL DEFAULT 'visible',
  `countAdditionalPeople` tinyint(1) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wpinst_amelia_resources`
--


--
-- Table structure for table `wpinst_amelia_resources_to_entities`
--

CREATE TABLE `wpinst_amelia_resources_to_entities` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `resourceId` int(11) NOT NULL,
  `entityId` int(11) NOT NULL,
  `entityType` enum('service','location','employee') NOT NULL DEFAULT 'service',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wpinst_amelia_resources_to_entities`
--


--
-- Table structure for table `wpinst_amelia_services`
--

CREATE TABLE `wpinst_amelia_services` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL DEFAULT '',
  `description` mediumtext,
  `color` varchar(255) NOT NULL DEFAULT '',
  `price` double NOT NULL,
  `status` enum('hidden','visible','disabled') NOT NULL DEFAULT 'visible',
  `categoryId` int(11) NOT NULL,
  `minCapacity` int(11) NOT NULL,
  `maxCapacity` int(11) NOT NULL,
  `duration` int(11) NOT NULL,
  `timeBefore` int(11) DEFAULT '0',
  `timeAfter` int(11) DEFAULT '0',
  `bringingAnyone` tinyint(1) DEFAULT '1',
  `priority` enum('least_expensive','most_expensive','least_occupied','most_occupied') NOT NULL,
  `pictureFullPath` varchar(767) DEFAULT NULL,
  `pictureThumbPath` varchar(767) DEFAULT NULL,
  `position` int(11) DEFAULT '0',
  `show` tinyint(1) DEFAULT '1',
  `aggregatedPrice` tinyint(1) DEFAULT '1',
  `settings` mediumtext,
  `recurringCycle` enum('disabled','all','daily','weekly','monthly') DEFAULT 'disabled',
  `recurringSub` enum('disabled','past','future','both') DEFAULT 'future',
  `recurringPayment` int(3) DEFAULT '0',
  `translations` text,
  `depositPayment` enum('disabled','fixed','percentage') DEFAULT 'disabled',
  `depositPerPerson` tinyint(1) DEFAULT '1',
  `deposit` double DEFAULT '0',
  `fullPayment` tinyint(1) DEFAULT '0',
  `mandatoryExtra` tinyint(1) DEFAULT '0',
  `minSelectedExtras` int(11) DEFAULT '0',
  `customPricing` text,
  `maxExtraPeople` int(11) DEFAULT NULL,
  `limitPerCustomer` text,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=40 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wpinst_amelia_services`
--

INSERT INTO `wpinst_amelia_services` VALUES (9,'Consultation(s) de suivi','<!-- Content --><p>En tant que votre thérapeute dévoué, je suis là pour vous accompagner dans chaque étape de votre cheminement vers le bien-être. Les séances de suivi thérapeutique sont des moments privilégiés où nous continuons à travailler ensemble pour atteindre vos objectifs de santé. Chaque séance est une opportunité de discuter de votre progrès, de résoudre des défis éventuels et d\'ajuster notre plan de traitement pour vous assurer une amélioration constante. Votre bien-être est ma priorité, et ces séances sont dédiées à votre santé et à votre épanouissement. Investissez dans votre mieux-être, séance après séance.</p>','#4ac9d8',60,'visible',15,1,1,3600,NULL,NULL,1,'least_expensive','https://www.institut-phenix-energetique.fr/wp-content/uploads/2023/11/comment-choisir-un-bon-acupuncteur-a-sorgues-avignon-et-carpentras-8.jpg','https://www.institut-phenix-energetique.fr/wp-content/uploads/2023/11/comment-choisir-un-bon-acupuncteur-a-sorgues-avignon-et-carpentras-8-150x150.jpg',6,1,1,'{\"payments\":{\"paymentLinks\":{\"enabled\":false,\"changeBookingStatus\":false,\"redirectUrl\":null}},\"zoom\":{\"enabled\":false},\"lessonSpace\":{\"enabled\":false},\"activation\":{\"version\":\"7.1\"},\"general\":{\"defaultAppointmentStatus\":\"approved\",\"minimumTimeRequirementPriorToCanceling\":null,\"minimumTimeRequirementPriorToRescheduling\":null,\"minimumTimeRequirementPriorToBooking\":null,\"redirectUrlAfterAppointment\":\"https:\\/\\/www.institut-phenix-energetique.fr\\/contact\\/confirmation-rendez-vous\\/\"}}','all','both',0,NULL,'disabled',1,0,0,0,NULL,'{\"enabled\":false,\"durations\":{}}',NULL,'{\"enabled\":false,\"numberOfApp\":null,\"period\":null,\"timeFrame\":null,\"from\":null}'),(15,'1ère Consultation','<!-- Content --><p>Lors de notre première consultation thérapeutique, je vous accueille chaleureusement pour comprendre vos besoins uniques. C\'est le point de départ d\'un voyage vers le bien-être. Nous prendrons le temps d\'écouter vos préoccupations et de discuter de vos objectifs de santé. Ensemble, nous élaborerons un plan personnalisé pour atteindre l\'équilibre physique et émotionnel. C\'est l\'opportunité de créer un partenariat thérapeutique qui vous guidera vers une meilleure qualité de vie. Votre bien-être commence ici.</p>','#4ac9d8',60,'visible',15,1,1,5400,NULL,NULL,1,'least_expensive','https://www.institut-phenix-energetique.fr/wp-content/uploads/2023/11/comment-choisir-un-bon-acupuncteur-a-sorgues-avignon-et-carpentras-3.jpeg','https://www.institut-phenix-energetique.fr/wp-content/uploads/2023/11/comment-choisir-un-bon-acupuncteur-a-sorgues-avignon-et-carpentras-3-150x150.jpeg',5,1,1,'{\"payments\":{\"stripe\":{\"enabled\":false},\"paymentLinks\":{\"enabled\":false,\"changeBookingStatus\":false,\"redirectUrl\":null}},\"zoom\":{\"enabled\":false},\"lessonSpace\":{\"enabled\":false},\"activation\":{\"version\":\"7.1\"},\"general\":{\"defaultAppointmentStatus\":\"approved\",\"minimumTimeRequirementPriorToCanceling\":null,\"minimumTimeRequirementPriorToRescheduling\":null,\"minimumTimeRequirementPriorToBooking\":null,\"redirectUrlAfterAppointment\":\"https:\\/\\/www.institut-phenix-energetique.fr\\/contact\\/confirmation-rendez-vous\\/\"}}','disabled','future',0,NULL,'disabled',1,0,0,0,NULL,'{\"enabled\":false,\"durations\":{}}',NULL,'{\"enabled\":true,\"numberOfApp\":0,\"period\":0,\"timeFrame\":\"month\",\"from\":\"bookingDate\"}'),(19,'Soin de reiki à distance','<!-- Content --><p>Notre séance de soin Reiki à distance vous offre l\'opportunité de recevoir une énergie bienfaisante où que vous soyez. Sans quitter votre lieu de confort, vous serez enveloppé(e) dans les douces vibrations du Reiki, favorisant la détente, la guérison et l\'harmonie intérieure. Grâce à cette expérience, vous pouvez rétablir l\'équilibre énergétique, libérer le stress et stimuler votre vitalité. Laissez-vous emporter par l\'énergie bienveillante, où que vous soyez dans le monde. Votre bien-être commence ici, même à distance.</p>','#023473',20,'visible',18,1,1,600,300,300,1,'least_expensive','https://www.institut-phenix-energetique.fr/wp-content/uploads/2023/01/guerison.jpg','https://www.institut-phenix-energetique.fr/wp-content/uploads/2023/01/guerison-150x150.jpg',12,1,1,'{\"payments\":{\"onSite\":false,\"paymentLinks\":{\"enabled\":false,\"changeBookingStatus\":false,\"redirectUrl\":null}},\"zoom\":{\"enabled\":false},\"lessonSpace\":{\"enabled\":false},\"general\":{\"defaultAppointmentStatus\":\"approved\",\"minimumTimeRequirementPriorToCanceling\":null,\"minimumTimeRequirementPriorToBooking\":null,\"minimumTimeRequirementPriorToRescheduling\":null,\"redirectUrlAfterAppointment\":\"https:\\/\\/www.institut-phenix-energetique.fr\\/contact\\/confirmation-rendez-vous\\/\"},\"activation\":{\"version\":\"7.1\"}}','disabled','future',0,NULL,'disabled',1,0,0,0,NULL,'{\"enabled\":false,\"durations\":{}}',NULL,'{\"enabled\":false,\"numberOfApp\":null,\"period\":null,\"timeFrame\":null,\"from\":null}'),(24,'Massage Tui Na','<!-- Content --><p>Le massage Tui Na bien-être est une ancienne pratique chinoise qui harmonise le corps et l\'esprit. Avec des mouvements fluides et des pressions ciblées, il libère les tensions, stimule la circulation d\'énergie et favorise une profonde détente. Laissez-vous emporter dans un univers de calme et de rééquilibrage, où le stress s\'envole et la vitalité reprend son cours naturel</p>','#4ac9d8',30,'visible',20,1,1,1800,NULL,NULL,1,'least_expensive','https://www.institut-phenix-energetique.fr/wp-content/uploads/2023/08/Homme-Stress-Anxiete-5.jpeg','https://www.institut-phenix-energetique.fr/wp-content/uploads/2023/08/Homme-Stress-Anxiete-5-150x150.jpeg',7,1,1,'{\"payments\":{\"onSite\":false,\"paymentLinks\":{\"enabled\":false,\"changeBookingStatus\":false,\"redirectUrl\":null}},\"general\":{\"minimumTimeRequirementPriorToCanceling\":null,\"minimumTimeRequirementPriorToRescheduling\":null,\"minimumTimeRequirementPriorToBooking\":null,\"redirectUrlAfterAppointment\":\"https:\\/\\/www.institut-phenix-energetique.fr\\/contact\\/confirmation-rendez-vous\\/\"},\"zoom\":{\"enabled\":false},\"lessonSpace\":{\"enabled\":false},\"activation\":{\"version\":\"7.1\"}}','disabled','future',0,NULL,'disabled',1,30,1,0,NULL,'{\"enabled\":true,\"durations\":{\"2700\":{\"price\":45,\"rules\":[]},\"3600\":{\"price\":60,\"rules\":[]}}}',NULL,'{\"enabled\":false,\"numberOfApp\":null,\"period\":null,\"timeFrame\":null,\"from\":null}'),(25,'Massage énergétique intuitif','<!-- Content --><p>Le massage énergétique intuitif est une expérience revitalisante qui va au-delà de la simple détente. Ce massage unique réveille votre énergie vitale, libérant les blocages et rétablissant l\'harmonie dans votre corps. Les mouvements fluides et les pressions douces permettent à l\'énergie de circuler librement, vous procurant une profonde sensation de bien-être. Laissez-vous envelopper par une vague d\'énergie positive qui nourrit à la fois le corps et l\'esprit, vous laissant revigoré(e) et équilibré(e). Plongez dans une expérience énergétique qui élève votre vitalité intérieure.</p>','#4ac9d8',30,'visible',20,1,1,1800,NULL,NULL,1,'least_expensive','https://www.institut-phenix-energetique.fr/wp-content/uploads/2023/01/LE-MASSAGE-TUI-NA-scaled.jpg','https://www.institut-phenix-energetique.fr/wp-content/uploads/2023/01/LE-MASSAGE-TUI-NA-150x150.jpg',8,1,1,'{\"payments\":{\"onSite\":false,\"paymentLinks\":{\"enabled\":false,\"changeBookingStatus\":false,\"redirectUrl\":null}},\"general\":{\"minimumTimeRequirementPriorToCanceling\":null,\"minimumTimeRequirementPriorToRescheduling\":null,\"minimumTimeRequirementPriorToBooking\":null,\"redirectUrlAfterAppointment\":\"https:\\/\\/www.institut-phenix-energetique.fr\\/contact\\/confirmation-rendez-vous\\/\"},\"zoom\":{\"enabled\":false},\"lessonSpace\":{\"enabled\":false},\"activation\":{\"version\":\"7.8.2\"},\"googleMeet\":{\"enabled\":false}}','all','future',0,NULL,'disabled',1,30,1,0,NULL,'{\"enabled\":true,\"durations\":{\"3600\":{\"price\":60,\"rules\":[]},\"5400\":{\"price\":90,\"rules\":[]},\"7200\":{\"price\":120,\"rules\":[]}}}',NULL,'{\"enabled\":false,\"numberOfApp\":1,\"timeFrame\":\"day\",\"period\":1,\"from\":\"bookingDate\"}'),(26,'Reiki','<!-- Content --><p>Lors d\'une séance de Reiki bien-être, vous plongez dans une expérience de détente profonde. Les mains expertes du praticien canalisent l\'énergie universelle pour rétablir l\'harmonie dans votre corps et votre esprit. Les tensions se dissipent, laissant place à un sentiment de paix intérieure. Cette pratique douce favorise l\'équilibre énergétique, apaise le mental et vous laisse revitalisé(e) et apaisé(e). Découvrez la puissance de la guérison énergétique pour cultiver votre bien-être intérieur.</p>','#4ac9d8',60,'visible',20,1,1,3600,NULL,NULL,1,'least_expensive','https://www.institut-phenix-energetique.fr/wp-content/uploads/2022/11/photo-encart1.png','https://www.institut-phenix-energetique.fr/wp-content/uploads/2022/11/photo-encart1-150x150.png',9,1,1,'{\"payments\":{\"onSite\":false,\"paymentLinks\":{\"enabled\":false,\"changeBookingStatus\":false,\"redirectUrl\":null}},\"general\":{\"minimumTimeRequirementPriorToCanceling\":null,\"minimumTimeRequirementPriorToRescheduling\":null,\"minimumTimeRequirementPriorToBooking\":null,\"redirectUrlAfterAppointment\":\"https:\\/\\/www.institut-phenix-energetique.fr\\/contact\\/confirmation-rendez-vous\\/\"},\"zoom\":{\"enabled\":false},\"lessonSpace\":{\"enabled\":false},\"activation\":{\"version\":\"7.1\"}}','all','both',0,NULL,'disabled',1,30,0,0,NULL,'{\"enabled\":false,\"durations\":{}}',NULL,'{\"enabled\":false,\"numberOfApp\":0,\"period\":0,\"timeFrame\":null,\"from\":null}'),(34,'1ère Séance','<!-- Content --><p>Lors de notre première consultation en acupuncture esthétique, nous vous invitons à explorer le pouvoir de la beauté naturelle. Nous discuterons de vos objectifs esthétiques et des améliorations que vous souhaitez apporter à votre apparence. Ensemble, nous élaborerons un plan personnalisé pour vous aider à révéler la meilleure version de vous-même. L\'acupuncture esthétique, douce et non invasive, stimule la régénération de la peau et favorise une apparence radieuse. Découvrez comment vous pouvez rayonner naturellement. Votre voyage vers une beauté épanouie commence ici.</p>','#4ac9d8',120,'visible',21,1,1,7200,NULL,600,1,'least_expensive','https://www.institut-phenix-energetique.fr/wp-content/uploads/2023/01/craniopuncture.jpg','https://www.institut-phenix-energetique.fr/wp-content/uploads/2023/01/craniopuncture-150x150.jpg',10,1,1,'{\"payments\":{\"onSite\":false,\"paymentLinks\":{\"enabled\":false,\"changeBookingStatus\":false,\"redirectUrl\":null}},\"general\":{\"minimumTimeRequirementPriorToCanceling\":null,\"minimumTimeRequirementPriorToRescheduling\":null,\"minimumTimeRequirementPriorToBooking\":null,\"redirectUrlAfterAppointment\":\"https:\\/\\/www.institut-phenix-energetique.fr\\/contact\\/confirmation-rendez-vous\\/\"},\"zoom\":{\"enabled\":false},\"lessonSpace\":{\"enabled\":false},\"activation\":{\"version\":\"7.1\"}}','disabled','future',0,NULL,'fixed',1,40,1,0,NULL,'{\"enabled\":false,\"durations\":{}}',NULL,'{\"enabled\":true,\"numberOfApp\":1,\"period\":0,\"timeFrame\":\"year\",\"from\":\"dateBooked\"}'),(35,'Séance(s) de suivi','<!-- Content --><p>Au cours de notre consultation de suivi en acupuncture esthétique, nous prenons soin de votre beauté naturelle de manière constante. Nous réévaluons vos progrès et ajustons notre plan personnalisé pour vous aider à atteindre vos objectifs esthétiques. L\'acupuncture esthétique, tout en douceur, soutient la régénération de votre peau pour une apparence radieuse et naturelle. Profitez de l\'entretien régulier de votre beauté, car chaque séance vous rapproche de votre meilleure version. Votre chemin vers une beauté épanouie se poursuit ici.</p>','#4ac9d8',120,'visible',21,1,1,7200,NULL,600,1,'least_expensive','https://www.institut-phenix-energetique.fr/wp-content/uploads/2023/08/Femme-Acupuncture-Esthetique-1.jpeg','https://www.institut-phenix-energetique.fr/wp-content/uploads/2023/08/Femme-Acupuncture-Esthetique-1-150x150.jpeg',11,1,1,'{\"payments\":{\"onSite\":false,\"paymentLinks\":{\"enabled\":false,\"changeBookingStatus\":false,\"redirectUrl\":null}},\"general\":{\"minimumTimeRequirementPriorToCanceling\":null,\"minimumTimeRequirementPriorToRescheduling\":null,\"minimumTimeRequirementPriorToBooking\":null,\"redirectUrlAfterAppointment\":\"https:\\/\\/www.institut-phenix-energetique.fr\\/contact\\/confirmation-rendez-vous\\/\"},\"zoom\":{\"enabled\":false},\"lessonSpace\":{\"enabled\":false},\"activation\":{\"version\":\"7.1\"}}','all','both',0,NULL,'fixed',1,40,1,0,NULL,'{\"enabled\":true,\"durations\":{\"5400\":{\"price\":90,\"rules\":[]}}}',NULL,'{\"enabled\":false,\"numberOfApp\":0,\"period\":0,\"timeFrame\":null,\"from\":null}'),(36,'Consultation pour arrêt du tabac','<!-- Content --><p>Vous avez pris la décision de dire <strong>adieu à la cigarette</strong>, félicitations ! Notre <strong>séance d\'acupuncture</strong> pour <strong>arrêter de fumer</strong> est conçue pour vous aider à atteindre cet objectif avec aisance et détermination.</p><p><br></p><p><strong>Comment ça fonctionne</strong> :</p><ol><li>L\'acupuncture stimule des points spécifiques pour réduire les envies de fumer.</li><li>Elle favorise la libération d\'endorphines, vous procurant une sensation de bien-être.</li><li>Elle réduit le stress et l\'anxiété souvent liés au sevrage tabagique.</li></ol><p><br></p><p><strong>Votre engagement est la clé</strong>, mais nous serons à vos côtés à chaque étape de ce voyage vers une vie sans tabac. Ensemble, nous pouvons faire de cette séance le premier pas vers une santé plus radieuse et une liberté retrouvée. Contactez-nous aujourd\'hui pour planifier votre séance d\'acupuncture pour arrêter de fumer et reprenez le contrôle de votre vie ! </p>','#1788FB',60,'visible',22,1,1,3600,NULL,NULL,1,'least_expensive','https://www.institut-phenix-energetique.fr/wp-content/uploads/2023/01/stop-tabac-1.jpg','https://www.institut-phenix-energetique.fr/wp-content/uploads/2023/01/stop-tabac-1-150x150.jpg',4,1,1,'{\"payments\":{\"onSite\":false,\"paymentLinks\":{\"enabled\":false,\"changeBookingStatus\":false,\"redirectUrl\":null}},\"general\":{\"minimumTimeRequirementPriorToCanceling\":null,\"minimumTimeRequirementPriorToRescheduling\":null,\"redirectUrlAfterAppointment\":\"https:\\/\\/www.institut-phenix-energetique.fr\\/contact\\/confirmation-rendez-vous\\/\",\"minimumTimeRequirementPriorToBooking\":null},\"zoom\":{\"enabled\":false},\"lessonSpace\":{\"enabled\":false},\"activation\":{\"version\":\"7.1\"}}','disabled','future',0,NULL,'fixed',1,20,1,0,NULL,'{\"enabled\":false,\"durations\":{}}',NULL,'{\"enabled\":false,\"numberOfApp\":1,\"timeFrame\":\"day\",\"period\":1,\"from\":\"bookingDate\"}'),(37,'Appel initial','','#1788FB',0,'visible',23,1,1,1800,NULL,NULL,1,'least_expensive',NULL,NULL,3,0,1,'{\"payments\":{\"paymentLinks\":{\"enabled\":false,\"changeBookingStatus\":false,\"redirectUrl\":null},\"onSite\":true,\"payPal\":{\"enabled\":false},\"stripe\":{\"enabled\":true},\"mollie\":{\"enabled\":false},\"razorpay\":{\"enabled\":false}},\"general\":{\"minimumTimeRequirementPriorToCanceling\":null,\"minimumTimeRequirementPriorToRescheduling\":null,\"minimumTimeRequirementPriorToBooking\":null},\"zoom\":{\"enabled\":false},\"lessonSpace\":{\"enabled\":false}}','disabled','future',0,NULL,'disabled',1,0,0,0,NULL,'{\"enabled\":false,\"durations\":{}}',NULL,'{\"enabled\":false,\"numberOfApp\":1,\"timeFrame\":\"day\",\"period\":1,\"from\":\"bookingDate\"}'),(38,'Appel Gratuit 15 min','<!-- Content --><p>Appel de 15 min Gratuit pour faire Connaissance et découvrir les services</p>','#1788FB',0,'visible',23,1,1,900,NULL,NULL,1,'least_expensive',NULL,NULL,2,1,1,'{\"payments\":{\"paymentLinks\":{\"enabled\":false,\"changeBookingStatus\":false,\"redirectUrl\":null},\"onSite\":true,\"payPal\":{\"enabled\":false},\"stripe\":{\"enabled\":true},\"mollie\":{\"enabled\":false},\"razorpay\":{\"enabled\":false}},\"general\":{\"minimumTimeRequirementPriorToCanceling\":null,\"minimumTimeRequirementPriorToRescheduling\":null,\"minimumTimeRequirementPriorToBooking\":null,\"redirectUrlAfterAppointment\":\"https:\\/\\/www.institut-phenix-energetique.fr\\/contact\\/confirmation-rendez-vous-telephonique\\/\"},\"zoom\":{\"enabled\":false},\"lessonSpace\":{\"enabled\":false},\"activation\":{\"version\":\"6.6\"}}','disabled','future',0,NULL,'disabled',1,0,0,0,NULL,'{\"enabled\":false,\"durations\":{}}',NULL,'{\"enabled\":false,\"numberOfApp\":1,\"timeFrame\":\"day\",\"period\":1,\"from\":\"bookingDate\"}'),(39,'Massage au Bambou Chaud (ONTAKE)','\n<p>\n  <strong>\n    <em>\n      <u>Massage traditionnel Japonais à la fois très relaxant et tonifiant.</u>\n    </em>\n  </strong>\n</p>\n<p>Lors de ce massage corps entier, vous serez massé(e) à l\'aide d\'un bambou creux, dans lequel se consume de la bourre d\'armoise.</p>\n<p>L\'armoise est une plante de la pharmacopée chinoise et japonaise, traditionnellement utilisée pour la moxibustion. Sa fréquence de rayonnement apporte à la chaleur qu\'elle prodigue un pouvoir tonifiant hors du commun. Les huiles essentielles déposées sur votre corps lors de la combustion viendront renforcer votre énergie.</p>\n<p>Allier à l\'expertise du professionnelle qui emploiera les gestes adéquats pour chaque parties de votre corps selon ses besoins de tonification ou de dispersion et vous obtenez un massage bien-être particulièrement efficace.</p>\n','#1788FB',90,'visible',20,1,1,3600,NULL,NULL,1,'least_expensive','https://www.institut-phenix-energetique.fr/wp-content/uploads/2024/02/Bambou-chaud.jpeg','https://www.institut-phenix-energetique.fr/wp-content/uploads/2024/02/Bambou-chaud-150x150.jpeg',1,1,1,'{\"payments\":{\"onSite\":false,\"paymentLinks\":{\"enabled\":false,\"changeBookingStatus\":false,\"redirectUrl\":null}},\"general\":{\"minimumTimeRequirementPriorToCanceling\":null,\"minimumTimeRequirementPriorToRescheduling\":null,\"minimumTimeRequirementPriorToBooking\":null},\"zoom\":{\"enabled\":false},\"lessonSpace\":{\"enabled\":false},\"activation\":{\"version\":\"7.1\"}}','disabled','future',0,NULL,'fixed',1,30,1,0,NULL,'{\"enabled\":false,\"durations\":{}}',NULL,'{\"enabled\":false,\"numberOfApp\":1,\"timeFrame\":\"day\",\"period\":1,\"from\":\"bookingDate\"}');

--
-- Table structure for table `wpinst_amelia_services_views`
--

CREATE TABLE `wpinst_amelia_services_views` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `serviceId` int(11) NOT NULL,
  `date` date NOT NULL,
  `views` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=80 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wpinst_amelia_services_views`
--

INSERT INTO `wpinst_amelia_services_views` VALUES (4,19,'2022-12-06',1),(5,15,'2022-12-07',1),(6,15,'2022-12-20',1),(7,15,'2022-12-22',1),(9,15,'2023-01-03',1),(10,15,'2023-01-10',1),(11,19,'2023-01-10',3),(18,9,'2023-02-22',1),(19,15,'2023-02-24',2),(20,9,'2023-02-24',1),(22,9,'2023-02-28',1),(23,15,'2023-03-01',1),(24,15,'2023-03-02',2),(25,9,'2023-03-03',3),(27,15,'2023-03-06',2),(28,9,'2023-03-08',1),(29,15,'2023-03-09',1),(32,9,'2023-03-31',2),(33,15,'2023-04-02',1),(34,9,'2023-04-04',1),(35,9,'2023-04-12',1),(36,9,'2023-04-20',2),(37,9,'2023-04-26',1),(38,15,'2023-05-06',1),(39,9,'2023-05-10',1),(41,9,'2023-05-17',1),(42,15,'2023-05-31',1),(43,9,'2023-06-05',1),(45,15,'2023-06-07',3),(46,9,'2023-07-04',1),(47,9,'2023-07-25',1),(49,9,'2023-08-09',1),(50,38,'2023-10-09',1),(51,38,'2023-10-16',1),(52,38,'2023-11-09',1),(53,25,'2023-11-15',1),(54,38,'2023-11-21',1),(55,15,'2023-11-27',1),(56,38,'2023-12-01',1),(57,19,'2023-12-07',1),(58,15,'2023-12-25',1),(59,9,'2024-01-11',2),(60,26,'2024-03-27',1),(61,15,'2024-04-06',1),(62,15,'2024-04-24',1),(63,9,'2024-04-24',1),(64,9,'2024-04-29',1),(65,9,'2024-05-14',1),(66,15,'2024-05-23',1),(67,38,'2024-06-13',4),(68,26,'2024-06-21',1),(69,15,'2024-06-26',1),(70,15,'2024-07-01',2),(71,9,'2024-07-01',2),(72,34,'2024-07-10',1),(73,9,'2024-09-04',2),(74,34,'2024-10-27',1),(75,15,'2024-10-30',1),(76,34,'2024-11-10',1),(77,15,'2024-11-11',1),(78,26,'2024-11-14',1),(79,26,'2024-11-17',1);

--
-- Table structure for table `wpinst_amelia_taxes`
--

CREATE TABLE `wpinst_amelia_taxes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `amount` double NOT NULL,
  `type` enum('percentage','fixed') NOT NULL,
  `status` enum('hidden','visible') NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wpinst_amelia_taxes`
--


--
-- Table structure for table `wpinst_amelia_taxes_to_entities`
--

CREATE TABLE `wpinst_amelia_taxes_to_entities` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `taxId` int(11) NOT NULL,
  `entityId` int(11) NOT NULL,
  `entityType` enum('service','extra','event','package') NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wpinst_amelia_taxes_to_entities`
--


--
-- Table structure for table `wpinst_amelia_users`
--

CREATE TABLE `wpinst_amelia_users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `status` enum('hidden','visible','disabled') NOT NULL DEFAULT 'visible',
  `type` enum('customer','provider','manager','admin') NOT NULL,
  `externalId` bigint(20) DEFAULT NULL,
  `firstName` varchar(255) NOT NULL DEFAULT '',
  `lastName` varchar(255) NOT NULL DEFAULT '',
  `email` varchar(255) DEFAULT NULL,
  `birthday` date DEFAULT NULL,
  `phone` varchar(63) DEFAULT NULL,
  `gender` enum('male','female') DEFAULT NULL,
  `note` text,
  `description` text,
  `pictureFullPath` varchar(767) DEFAULT NULL,
  `pictureThumbPath` varchar(767) DEFAULT NULL,
  `password` varchar(128) DEFAULT NULL,
  `usedTokens` text,
  `zoomUserId` varchar(255) DEFAULT NULL,
  `countryPhoneIso` varchar(2) DEFAULT NULL,
  `translations` text,
  `timeZone` varchar(255) DEFAULT NULL,
  `badgeId` int(11) DEFAULT NULL,
  `stripeConnect` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`),
  UNIQUE KEY `email` (`email`)
) ENGINE=InnoDB AUTO_INCREMENT=83 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wpinst_amelia_users`
--

INSERT INTO `wpinst_amelia_users` VALUES (1,'visible','provider',NULL,'THIERRY','PARIAN','no-reply@institut-phenix-energetique.fr',NULL,'+33615245210',NULL,NULL,'<!-- Content --><p>Responsable de Formation en Reiki.</p><p>Praticien et Formateur en Médecine Traditionnelle Chinoise, </p><p>Praticien en Yamamoto New Scalp Acupuncture (YNSA), Acupuncture Esthétique,  et Lithothérapie Chinoise.</p>','https://www.institut-phenix-energetique.fr/wp-content/uploads/2022/12/Moi.jpg','https://www.institut-phenix-energetique.fr/wp-content/uploads/2022/12/Moi-150x150.jpg','$2y$10$1tHY4SqndJXFU6rPzjbsJevt5YwwsCRd.uz1a455Rxr3E4PD8mtT2',NULL,NULL,'fr',NULL,NULL,NULL,NULL),(6,'visible','customer',5,'Marie-Jeanne','Cruchon-Dupeyrat','mjcd04@orange.fr',NULL,'+33687298802',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fr','{\"defaultLanguage\":\"fr_FR\"}',NULL,NULL,NULL),(8,'visible','customer',6,'Claire','Canal','camalo.alisson1@outlook.fr',NULL,'+33644877934',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'{\"defaultLanguage\":\"fr_FR\"}',NULL,NULL,NULL),(9,'visible','customer',7,'Marie-Christine','DEHOVE','dehovemchristine@gmail.com',NULL,'+33663368046',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'{\"defaultLanguage\":\"fr_FR\"}',NULL,NULL,NULL),(10,'visible','customer',8,'Isabelle','Sellier','isabellesellier48@gmail.com',NULL,'0643053935',NULL,NULL,NULL,NULL,NULL,'$2y$10$AXbhlCyBNG5GEgrBjiDPL.g55EScvvZhlHpSHS9spQyNgWXEap.e.','{\"1680887532\":\"eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwczpcL1wvd3d3Lmluc3RpdHV0LXBoZW5peC1lbmVyZ2V0aXF1ZS5mciIsImlhdCI6MTY3ODI5NTUxMCwiZW1haWwiOiJpc2FiZWxsZXNlbGxpZXI0OEBnbWFpbC5jb20iLCJ3cCI6NCwiZXhwIjoxNjgwODg3NTEwfQ.fMy4wVPY-HRaPBCwt6PJNohdYs1c-S49YzmllazX3mg\"}',NULL,NULL,'{\"defaultLanguage\":\"fr_FR\"}',NULL,NULL,NULL),(11,'visible','customer',9,'Mireille','Pouchol','mireille2pouchol@gmail.com',NULL,'+33683580685',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fr','{\"defaultLanguage\":\"fr_FR\"}',NULL,NULL,NULL),(12,'visible','manager',10,'Vanessa','FERAUD','laportevanessa@hotmail.fr',NULL,'+33648669217',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'{\"defaultLanguage\":\"fr_FR\"}',NULL,NULL,NULL),(13,'visible','manager',11,'Irène','LATIL','cecile.latil@orange.fr',NULL,'+33629211121',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'{\"defaultLanguage\":\"fr_FR\"}',NULL,NULL,NULL),(14,'visible','customer',NULL,'Claire','Harel',NULL,NULL,'+33767746714',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fr','{\"defaultLanguage\":\"fr_FR\"}',NULL,NULL,NULL),(15,'visible','customer',12,'Manon','LATIL','manonlatil84@gmail.com',NULL,'+33625005657',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'{\"defaultLanguage\":\"fr_FR\"}',NULL,NULL,NULL),(16,'visible','customer',13,'Mireille','PERQUE','mireille-perque@orange.fr',NULL,'+33785590767',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'{\"defaultLanguage\":\"fr_FR\"}',NULL,NULL,NULL),(17,'visible','customer',NULL,'Irène','LATIL',NULL,NULL,'+33629211121',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'{\"defaultLanguage\":\"fr_FR\"}',NULL,NULL,NULL),(18,'visible','customer',NULL,'Irène','LATIL',NULL,NULL,'+33629211121',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'{\"defaultLanguage\":\"fr_FR\"}',NULL,NULL,NULL),(19,'visible','customer',NULL,'Irène','LATIL',NULL,NULL,'+33629211121','female',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fr','{\"defaultLanguage\":\"fr_FR\"}',NULL,NULL,NULL),(20,'visible','customer',14,'Margot','Daridan','dess.margot@gmail.com',NULL,'+33785350475',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'{\"defaultLanguage\":\"fr_FR\"}',NULL,NULL,NULL),(24,'visible','customer',16,'Christelle','Rey','christelle.rey8@hotmail.fr',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fr','{\"defaultLanguage\":\"fr_FR\"}',NULL,NULL,NULL),(25,'visible','customer',17,'Jessica','LAURENT','jessicalaurent@gmx.fr',NULL,'+33695444047','female',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fr','{\"defaultLanguage\":\"fr_FR\"}',NULL,NULL,NULL),(26,'visible','customer',18,'Adeline','Degrange','adeline.degrange84@gmail.com',NULL,'+33617683766',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'{\"defaultLanguage\":\"fr_FR\"}',NULL,NULL,NULL),(27,'visible','customer',19,'jessica','Laurent','tite.tika23@gmail.com',NULL,'+33695444047',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'{\"defaultLanguage\":\"fr_FR\"}',NULL,NULL,NULL),(28,'visible','customer',20,'Marjorie','DAVID','mimi.margot13@gmail.com',NULL,'+33610758413',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fr','{\"defaultLanguage\":\"fr_FR\"}',NULL,NULL,NULL),(29,'visible','customer',21,'Odile','Morel','odmorel@gmail.com',NULL,'+33609914890',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fr','{\"defaultLanguage\":\"fr_FR\"}',NULL,NULL,NULL),(30,'visible','customer',22,'Annick','Proix','annick.proix@laposte.net',NULL,'+33685483219',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'{\"defaultLanguage\":\"fr_FR\"}',NULL,NULL,NULL),(32,'visible','customer',23,'Claire','Silvestre','clairette.mimi@hotmail.fr',NULL,'+33671507278',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fr','{\"defaultLanguage\":\"fr_FR\"}',NULL,NULL,NULL),(33,'visible','customer',24,'Olivier','VITALE','oliviervitale@cerp-rouen.fr',NULL,'+33608879657',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'{\"defaultLanguage\":\"fr_FR\"}',NULL,NULL,NULL),(35,'visible','customer',25,'Audrey','Gonzalez','audreyjc.gonzalez@laposte.net',NULL,'+33617386638',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fr','{\"defaultLanguage\":\"fr_FR\"}',NULL,NULL,NULL),(36,'visible','customer',NULL,'Thierry','PARIAN','thierry.parian@gmail.com',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fr',NULL,NULL,NULL,NULL),(37,'visible','customer',26,'arnaud','mirande','arnaud.mirande78@gmail.com',NULL,'+33630086804',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'{\"defaultLanguage\":\"fr_FR\"}',NULL,NULL,NULL),(38,'visible','customer',27,'Marie-Jeanne','Cruchon-Dupeyrat','mjcd04@icloud.com',NULL,'+33687298802',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'{\"defaultLanguage\":\"fr_FR\"}',NULL,NULL,NULL),(39,'visible','customer',28,'Nelly','Schneider','neschneider@laposte.net',NULL,'+33611529301',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'{\"defaultLanguage\":\"fr_FR\"}',NULL,NULL,NULL),(40,'visible','customer',52,'Bruno','MARQUES','caninanacapoeira@hotmail.com',NULL,'+33670137040','male',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fr','{\"defaultLanguage\":\"fr_FR\"}',NULL,NULL,NULL),(41,'visible','customer',30,'Pierrette','LE GALL','pierrette.legall@free.fr',NULL,'+33609174607',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fr','{\"defaultLanguage\":\"fr_FR\"}',NULL,NULL,NULL),(45,'visible','customer',31,'Nathalie','Honnorat','nathalie.ho@laposte.net',NULL,'+33644073165',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fr','{\"defaultLanguage\":\"fr_FR\"}',NULL,NULL,NULL),(46,'visible','customer',NULL,'Yohann','GALLU','yohann.13008@gmail.com','1991-02-10','+33658144338','male',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fr','{\"defaultLanguage\":\"fr_FR\"}',NULL,NULL,NULL),(47,'visible','customer',32,'Jennifer','Martinez','martinezjennifer1@live.fr',NULL,'+33636141945',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'{\"defaultLanguage\":\"fr_FR\"}',NULL,NULL,NULL),(48,'visible','customer',34,'Françoise','DUCASSE','ducasse.francoise@hotmail.fr',NULL,'+33681225474','female',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fr','{\"defaultLanguage\":\"fr_FR\"}',NULL,NULL,NULL),(49,'visible','customer',NULL,'Anne','VESPERINI','anne.vesperini04@gmail.com','1963-10-16','+33689160905','female',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fr','{\"defaultLanguage\":\"fr_FR\"}',NULL,NULL,NULL),(50,'visible','customer',35,'Amandine','AGACHE','agacheamandine@hotmail.fr','1975-06-16','+33603240214','female',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fr','{\"defaultLanguage\":\"fr_FR\"}',NULL,NULL,NULL),(52,'visible','customer',36,'Bénédicte','Parc','bpbellis42@gmail.com',NULL,'+33622647164',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fr','{\"defaultLanguage\":\"fr_FR\"}',NULL,NULL,NULL),(53,'visible','customer',37,'Annick','SALDO','dupuyannick@gmail.com',NULL,'+33623185415','female',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fr','{\"defaultLanguage\":\"fr_FR\"}',NULL,NULL,NULL),(54,'visible','customer',38,'Sylvain','DELBAERE','delbaeresylvain1@gmail.com','1989-02-18','+33625501001','male',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fr','{\"defaultLanguage\":\"fr_FR\"}',NULL,NULL,NULL),(55,'visible','customer',39,'Sezer','AKBULUT','akbulut.sezer7@gmail.com','1996-03-04','+33626283200','male',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fr','{\"defaultLanguage\":\"fr_FR\"}',NULL,NULL,NULL),(56,'visible','customer',40,'Frederic','Pereira','fredericpereira86@gmail.com',NULL,'+33784530437',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'{\"defaultLanguage\":\"fr_FR\"}',NULL,NULL,NULL),(57,'visible','customer',41,'Hulya','GUVEN','s.akbas@live.fr','1971-01-01','+33621930281','female',NULL,NULL,NULL,NULL,NULL,'{\"1703423688\":\"eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwczpcL1wvd3d3Lmluc3RpdHV0LXBoZW5peC1lbmVyZ2V0aXF1ZS5mciIsImlhdCI6MTcwMDgzMTY2OCwiZW1haWwiOiJzLmFrYmFzQGxpdmUuZnIiLCJ3cCI6NCwiZXhwIjoxNzAzNDIzNjY4fQ.rv5ni-LmyMolGN61WR3jL2JTmRpg8gG0s55QSvzUZIQ\"}',NULL,'fr','{\"defaultLanguage\":\"fr_FR\"}',NULL,NULL,NULL),(58,'visible','customer',42,'Nassera','LAGOUNE','nassera.lagoune@gmail.com',NULL,'+33664521322',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'{\"defaultLanguage\":\"fr_FR\"}',NULL,NULL,NULL),(59,'visible','customer',43,'Khadija','HIMMES','himkhadija@yahoo.fr',NULL,'+33603071445','female',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fr','{\"defaultLanguage\":\"fr_FR\"}',NULL,NULL,NULL),(60,'visible','customer',45,'Malory','MARINELLO','malory.marinello@gmail.com','1974-09-24','+33661949401','female',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fr','{\"defaultLanguage\":\"fr_FR\"}',NULL,NULL,NULL),(61,'visible','customer',46,'Christophe','SELLIER','capm.sellier@gmail.com',NULL,'+33684448941','male',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fr','{\"defaultLanguage\":\"fr_FR\"}',NULL,NULL,NULL),(62,'visible','customer',47,'Bastien','TRAVAGLINI','groupe-tfi@hotmail.com','1993-12-01','+33614337742','male',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fr','{\"defaultLanguage\":\"fr_FR\"}',NULL,NULL,NULL),(63,'visible','customer',48,'Juliette','Di NUNZO','juliette06600@gmail.com','1997-09-09','+33643068179','female',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fr','{\"defaultLanguage\":\"fr_FR\"}',NULL,NULL,NULL),(64,'visible','customer',49,'Rachel','FERNANDEZ CRUZ','cruzferrachel@outlook.fr','1978-07-04','+33749096202','female',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fr','{\"defaultLanguage\":\"fr_FR\"}',NULL,NULL,NULL),(65,'visible','customer',50,'Mathieu','GREGOIRE','mathieugregoire@free.fr',NULL,'+33610553352',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'{\"defaultLanguage\":\"fr_FR\"}',NULL,NULL,NULL),(66,'visible','customer',51,'Isabelle','BEFVE','isabelledfr@orange.fr',NULL,'+33680376417',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'{\"defaultLanguage\":\"fr_FR\"}',NULL,NULL,NULL),(67,'visible','customer',53,'Marie-pascale','Léonard','pascaleleo76@gmail.com',NULL,'+33662227636',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'{\"defaultLanguage\":\"fr_FR\"}',NULL,NULL,NULL),(68,'visible','customer',55,'Yassine','ZAABOUL','yassine.zaaboul84@gmail.com',NULL,'+33698471657','male','Mail et Numéro de madame',NULL,NULL,NULL,NULL,NULL,NULL,'fr','{\"defaultLanguage\":\"fr_FR\"}',NULL,NULL,NULL),(69,'visible','customer',56,'Carole','GRENIER','gr.carole@wanadoo.fr',NULL,'+33660722297','female','Rdv pour son petit Fils Kayden GRASSO (01/09/2020)',NULL,NULL,NULL,NULL,NULL,NULL,'fr','{\"defaultLanguage\":\"fr_FR\"}',NULL,NULL,NULL),(70,'visible','customer',57,'Sabine','North','north.sabine@gmail.com','1969-09-22','+33625611964','female',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fr','{\"defaultLanguage\":\"fr_FR\"}',NULL,NULL,NULL),(71,'visible','customer',58,'Emeline','Blanc','mathiline@aol.com',NULL,'+33762634262','female',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fr','{\"defaultLanguage\":\"fr_FR\"}',NULL,NULL,NULL),(73,'visible','customer',54,'Latifa','NADAH','nadah.latifa@gmail.com',NULL,'+33698471657','female',NULL,NULL,NULL,NULL,'$2y$10$wVYxTq5EBB9WK7OL67HCbO6xbXMRP9R/ONrckNUd.78TMch/rVcCS','{\"1721999233\":\"eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwczpcL1wvd3d3Lmluc3RpdHV0LXBoZW5peC1lbmVyZ2V0aXF1ZS5mciIsImlhdCI6MTcxOTQwNzE5MywiZW1haWwiOiJuYWRhaC5sYXRpZmFAZ21haWwuY29tIiwid3AiOjQsImV4cCI6MTcyMTk5OTE5M30.qsDm98H-cOqk_zFLHC3D0J5ocDXc9U163OhV6tJ-aJk\"}',NULL,'fr','{\"defaultLanguage\":\"fr_FR\"}',NULL,NULL,NULL),(74,'visible','customer',59,'Solange','FAUCHET','sofauchet@gmail.com',NULL,'+33626953320',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'{\"defaultLanguage\":\"fr_FR\"}',NULL,NULL,NULL),(76,'visible','customer',61,'Laïla','NAJJARI','laila-najjari@outlook.fr',NULL,'+33603821409','female','Amie Gaëlle',NULL,NULL,NULL,NULL,NULL,NULL,'fr','{\"defaultLanguage\":\"fr_FR\"}',NULL,NULL,NULL),(77,'visible','customer',62,'Camille','ROUX','kaugoumy@yahoo.fr',NULL,'+33698758686','female',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fr','{\"defaultLanguage\":\"fr_FR\"}',NULL,NULL,NULL),(78,'visible','customer',NULL,'Pascale','De SOUSA CORREIA',NULL,NULL,'+33674164364','female',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fr','{\"defaultLanguage\":\"fr_FR\"}',NULL,NULL,NULL),(79,'visible','customer',63,'Aline','MILAN','milali@orange.fr',NULL,'+33645455641','female',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fr','{\"defaultLanguage\":\"fr_FR\"}',NULL,NULL,NULL),(80,'visible','customer',64,'Marine','FEID','marinef04180@hotmail.fr',NULL,'+33630222348','female',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fr','{\"defaultLanguage\":\"fr_FR\"}',NULL,NULL,NULL),(81,'visible','customer',65,'Virginie','JOUANNE','jouanne.virginie1975@gmail.com',NULL,'+33615490102','female',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fr','{\"defaultLanguage\":\"fr_FR\"}',NULL,NULL,NULL),(82,'visible','customer',66,'Yohan','DE BESSÉ','y2bc@live.fr',NULL,'+33617823536',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'{\"defaultLanguage\":\"fr_FR\"}',NULL,NULL,NULL);

--
-- Table structure for table `wpinst_aryo_activity_log`
--

CREATE TABLE `wpinst_aryo_activity_log` (
  `histid` int(11) NOT NULL AUTO_INCREMENT,
  `user_caps` varchar(70) NOT NULL DEFAULT 'guest',
  `action` varchar(255) NOT NULL,
  `object_type` varchar(255) NOT NULL,
  `object_subtype` varchar(255) NOT NULL DEFAULT '',
  `object_name` varchar(255) NOT NULL,
  `object_id` int(11) NOT NULL DEFAULT '0',
  `user_id` int(11) NOT NULL DEFAULT '0',
  `hist_ip` varchar(55) NOT NULL DEFAULT '127.0.0.1',
  `hist_time` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`histid`)
) ENGINE=InnoDB AUTO_INCREMENT=3714 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wpinst_aryo_activity_log`
--

INSERT INTO `wpinst_aryo_activity_log` VALUES (3658,'guest','updated','Plugins','7.8.2','Amelia',0,0,'127.0.0.1',1729608648),(3659,'guest','updated','Plugins','20241019','GA Google Analytics',0,0,'127.0.0.1',1729608648),(3660,'guest','updated','Plugins','3.92.0','MetaSlider',0,0,'127.0.0.1',1729608648),(3661,'guest','updated','Plugins','2.33.0','MetaSlider Pro',0,0,'127.0.0.1',1729608648),(3662,'guest','updated','Plugins','1.138.0','Site Kit by Google',0,0,'127.0.0.1',1729608648),(3663,'guest','updated','Plugins','2.5.61','Supreme Modules Lite - Divi Theme, Extra Theme and Divi Builder',0,0,'127.0.0.1',1729608648),(3664,'guest','updated','Plugins','1.9.17.1','WPS Hide Login',0,0,'127.0.0.1',1729608648),(3665,'guest','updated','Plugins','23.7','Yoast SEO',0,0,'127.0.0.1',1729608648),(3666,'guest','deactivated','Plugins','7.8.2','Amelia',0,0,'52.143.158.57',1729609210),(3667,'guest','activated','Plugins','7.8.2','Amelia',0,0,'52.143.158.57',1729609214),(3668,'guest','logged_in','Users','Session','contactinstitutphenixenergetique-fr',2,2,'92.184.104.193',1729611499),(3669,'administrator','registered','Users','Profile','milaliorange-fr',63,2,'92.184.104.193',1729611620),(3670,'administrator','updated','Users','Profile','milaliorange-fr',63,2,'92.184.104.193',1729611620),(3671,'administrator','sent','Emails','Core','[Institut Phénix énergétique] Détails de connexion',0,2,'92.184.104.193',1729611621),(3672,'administrator','updated','Users','Profile','milaliorange-fr',63,2,'92.184.104.193',1729611621),(3673,'guest','sent','Emails','Core','[Institut Phénix énergétique] Mot de passe changé',0,0,'86.221.66.209',1729675793),(3674,'guest','logged_in','Users','Session','milaliorange-fr',63,63,'86.221.66.209',1729675874),(3675,'wpamelia-customer','updated','Users','Profile','milaliorange-fr',63,63,'86.221.66.209',1729676197),(3676,'wpamelia-customer','sent','Emails','Core','[Institut Phénix énergétique] Réinitialisation du mot de passe',0,63,'86.221.66.209',1729676197),(3677,'guest','logged_in','Users','Session','contactinstitutphenixenergetique-fr',2,2,'2.9.82.234',1729761274),(3678,'guest','logged_in','Users','Session','contactinstitutphenixenergetique-fr',2,2,'2.9.82.234',1729761275),(3679,'administrator','registered','Users','Profile','marinef04180hotmail-fr',64,2,'2.9.82.234',1729761384),(3680,'administrator','updated','Users','Profile','marinef04180hotmail-fr',64,2,'2.9.82.234',1729761384),(3681,'administrator','sent','Emails','Core','[Institut Phénix énergétique] Détails de connexion',0,2,'2.9.82.234',1729761384),(3682,'guest','sent','Emails','Unknown','Votre résumé hebdomadaire de WP Mail SMTP pour www.institut-phenix-energetique.fr',0,0,'20.188.60.194',1729908011),(3683,'guest','updated','Users','Profile','milaliorange-fr',63,0,'86.221.66.209',1730111402),(3684,'guest','sent','Emails','Core','[Institut Phénix énergétique] Réinitialisation du mot de passe',0,0,'86.221.66.209',1730111402),(3685,'guest','failed_login','Users','Session','milali@orange.fr',0,0,'86.221.66.209',1730111453),(3686,'guest','updated','Users','Profile','milaliorange-fr',63,0,'86.221.66.209',1730111792),(3687,'guest','sent','Emails','Core','[Institut Phénix énergétique] Réinitialisation du mot de passe',0,0,'86.221.66.209',1730111793),(3688,'guest','sent','Emails','Core','[Institut Phénix énergétique] Mot de passe changé',0,0,'86.221.66.209',1730114402),(3689,'guest','logged_in','Users','Session','milaliorange-fr',63,63,'86.221.66.209',1730114446),(3690,'guest','logged_in','Users','Session','contactinstitutphenixenergetique-fr',2,2,'2.9.82.234',1730401114),(3691,'administrator','registered','Users','Profile','jouanne-virginie1975gmail-com',65,2,'2.9.82.234',1730401996),(3692,'administrator','updated','Users','Profile','jouanne-virginie1975gmail-com',65,2,'2.9.82.234',1730401996),(3693,'administrator','sent','Emails','Core','[Institut Phénix énergétique] Détails de connexion',0,2,'2.9.82.234',1730401997),(3694,'administrator','updated','Users','Profile','jouanne-virginie1975gmail-com',65,2,'2.9.82.234',1730401997),(3695,'guest','sent','Emails','Unknown','Votre résumé hebdomadaire de WP Mail SMTP pour www.institut-phenix-energetique.fr',0,0,'20.188.60.194',1730510109),(3696,'guest','logged_in','Users','Session','contactinstitutphenixenergetique-fr',2,2,'2.9.82.234',1730765602),(3697,'guest','logged_in','Users','Session','contactinstitutphenixenergetique-fr',2,2,'2.9.82.234',1730765603),(3698,'guest','sent','Emails','Unknown','Votre résumé hebdomadaire de WP Mail SMTP pour www.institut-phenix-energetique.fr',0,0,'20.216.158.214',1731115251),(3699,'guest','logged_in','Users','Session','contactinstitutphenixenergetique-fr',2,2,'2.9.82.234',1731151843),(3700,'guest','logged_in','Users','Session','contactinstitutphenixenergetique-fr',2,2,'2.9.82.234',1731151844),(3701,'guest','registered','Users','Profile','y2bclive-fr',66,0,'88.125.102.56',1731359435),(3702,'guest','updated','Users','Profile','y2bclive-fr',66,0,'88.125.102.56',1731359435),(3703,'guest','sent','Emails','Core','[Institut Phénix énergétique] Détails de connexion',0,0,'88.125.102.56',1731359436),(3704,'guest','sent','Emails','Core','[Institut Phénix énergétique] Mot de passe changé',0,0,'88.125.102.56',1731359588),(3705,'guest','logged_in','Users','Session','contactinstitutphenixenergetique-fr',2,2,'92.184.112.218',1731427326),(3706,'guest','logged_in','Users','Session','contactinstitutphenixenergetique-fr',2,2,'2.9.82.234',1731516655),(3707,'guest','logged_in','Users','Session','contactinstitutphenixenergetique-fr',2,2,'2.9.82.234',1731516656),(3708,'administrator','updated','Core','','WordPress Updated',0,2,'2.9.82.234',1731516965),(3709,'guest','failed_login','Users','Session','Thierry',0,0,'92.184.100.87',1731595997),(3710,'guest','logged_in','Users','Session','contactinstitutphenixenergetique-fr',2,2,'92.184.100.87',1731596008),(3711,'guest','logged_in','Users','Session','contactinstitutphenixenergetique-fr',2,2,'92.184.100.36',1731600852),(3712,'guest','logged_in','Users','Session','contactinstitutphenixenergetique-fr',2,2,'92.184.102.233',1731698412),(3713,'guest','sent','Emails','Unknown','Votre résumé hebdomadaire de WP Mail SMTP pour www.institut-phenix-energetique.fr',0,0,'20.188.60.194',1731720610);

--
-- Table structure for table `wpinst_cff_facebook_feed_locator`
--

CREATE TABLE `wpinst_cff_facebook_feed_locator` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `feed_id` varchar(50) NOT NULL DEFAULT '',
  `post_id` bigint(20) unsigned NOT NULL,
  `html_location` varchar(50) NOT NULL DEFAULT 'unknown',
  `shortcode_atts` longtext NOT NULL,
  `last_update` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `feed_id` (`feed_id`),
  KEY `post_id` (`post_id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wpinst_cff_facebook_feed_locator`
--

INSERT INTO `wpinst_cff_facebook_feed_locator` VALUES (1,'*1',1991,'content','{\"feed\":\"1\"}','2024-11-16 23:24:53'),(2,'*1',0,'content','{\"feed\":\"1\"}','2024-08-30 07:28:50'),(3,'*1',1797,'unknown','{\"feed\":\"1\"}','2023-11-02 15:24:24'),(4,'*1',1558,'unknown','{\"feed\":\"1\"}','2024-02-14 13:29:41');

--
-- Table structure for table `wpinst_cff_feed_caches`
--

CREATE TABLE `wpinst_cff_feed_caches` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `feed_id` bigint(20) unsigned NOT NULL DEFAULT '1',
  `cache_key` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  `cache_value` longtext COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `cron_update` varchar(20) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'yes',
  `last_updated` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `feed_id` (`feed_id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `wpinst_cff_feed_caches`
--

INSERT INTO `wpinst_cff_feed_caches` VALUES (1,1,'posts_backup','[encoded data, 63964 characters]','','2024-01-26 10:50:44'),(2,1,'posts','[encoded data, 44056 characters]','yes','2024-11-19 09:00:15'),(3,1,'header','Njxi8nYG928YNYdjGq9YIm13Tk5GRGhTV1h0L3pSdVR5R3RQUmhjUEhFSzhuT24wY3d6N2VQRWhKWGRlR2N5Q21mU3VQYkNoY0UvaEluU2Z5RHVhZnYxcjhkbmJLY0I4V01XRjdqTG1zUGFRYlZBenlsUHJGbCtqU1RsM1lsOUZOSmRSNzJvRmQyWndHamdYZHZhc1ltVHZFalRYdURDNHAxZWRJWGkxdnpHeUllamZCQnBxUXh6Zk95UDJ6S0hRbEViQVpkcDJNTXNFUTB2cEZxbG5EVGhjZUVjNnl5K2hjVFUxN1BnTzd3ME9SdEJtN2tUTXZxY2lkemE3RExCT3dOYmhZTGY3VitEWmxCaXl5Z2ZrQk4zRUswM1lGeld1WmQreUJXdGFQOTE0aTh2aDZsN0JvQ0NDcXhuTHc0OENIRHBHVGdmREJhU3FuSWdqb1dYMEVtODZhbWRNaVNhenl0Sm9pTmhSUTFENXN5UldmSWFBbllBRWJlcUZXazBuRUJjbVJyU01uNHBOcXB2UCtyb1JlU2VqU2RhOThIcWhTdE15VktvcmlLNG4wRVNmSTVIOUpMTkpDWThOUSs5b2o2VStUK2tSSVl3eVRJSHdvSlJVQ25VRFBkZ2cyYllDK3NOcGdySklQbzEzNzcwc0lGSFRvb0tnYzYxdjNWVVVqN2pkS0VzL1Q1NnJMTDA0OGRnQmh1QWF1NHlEN2ZLa1B0T3RySDk3Q1lleDJSNm9OUkRlVytPczJWYyt6bFhyaDBVcXBLdTJ4Mm0yYWtnSTB4UU5tTGlTL1pzT1JQZFZiY09DUTFISWhzdGNVb2tac1lBUW9YeVdNbEo3OVdjaHp5L0tzWldIbHQ3dXBPZHFjNFpYcVEvbzgwaHVpMkc3OFpqa1F4cWFjRW1zSEsrTUt2TWhyVlBNdGJlNmo4ekE1ZUZyWHVvYXhkbXY5ajhocVo1MXVDOE5HNC9LV2lSOTNsWWRjb3p5TjNIcHp4SURyUFVTK3ZOVDVYUzIvSm56UUdUVEZPdGNtUnhVcDMzMVBhMjhFQm1QOHJoMHUrZ1p6RU1sYmhPblJPM1BLWUZnKzZKTXByU3F5RkN5cHFlVlN2NWpRcWQyR09HOUx4azRPVVdBN0ZIdW5NVDlLa3dlOXM0QWNrcXhSVU9USzRvZTc4cXZZY2taWjI3aTVkOEc1VXcxbmVlY2xjbC9PZ2ZhQURWcUk3MlFIOGpQbEVMckFjNzV1Kyt3ZHVkc2s0VndzZjloeHVNOXZaMmRubXNVeUVuR0RPVmF4Q2lqekRGaEpnT1hZSy9GSk1wSDRNMzVVOGRFUlJTSlFSR3ozQmNWMm9NUEpSK1FMR1RNWXhNK1FmN24wYkQxVDRQNG1wdkZVcnlsK3czL2lkNjFkeDFFWHVJZHA5cytKQXh1S3J4emhVcUJDejl6cGRRaDlSMjc3M08vQTFQM3RqMmxZWWhqUjl5Rk5RUldKbGNsK3lydVhvTUtWalF1Y1NRVTBKUVpJOHFBVEErNCtxc1dtakFZYmdlbGhKU2ZWbFcxUjZUZTRVcVFvcFRqdFNwenRER1F4c1p5OEVQYXpPaGRMUnA2dWFFR2M4dlpnTDRZUy8zMUJwVHVZNDJvUmx3VGpGYWFIWVNsU0tLcTFtVWJ2QjNkZDdXZm5YaGlpOFkzM2pSQ1dQdmlMZS9Kd0h4ejB6SkFMdUJvU3VZVzhZWXByeUNnaDlHMHpJbGIvUlFwaUpMTnBRNFBVbXVkTnFSVlhNVjhLUGx4cDhPWHkvNS9wczdVWWdxSnd3TDJyeFJvNHk0RmtpcmJ6NzkrdFFZWk9OczEzNlVwK0x4R01BanAyanI5S2xEVnV4YmhLME40NTdtWDNyL1VsdzhTTnhEcnVDRi9uNnYxSDh6cGx0OXZORXgxK3BLVUt3eS8xWkh2OWlqZkFpL2I3OGFScDZ0K1RPbzlrUG9XSVZmd3dDOTZMWk12Q3ZnbDZWemRHL0JaTnFtNmFXZ00rNlBWK3NyRHpPbXBsM0pBQ0JFSngzcGtDQ29IMElDWFRLQkVKc2tUeU83M0hjaDhNMU5tazlQN05BMEg5UlA5U2dKVHVTOFJid1IyYk5KVm1iTjhVb1loakEwTnZYQ29FSElXWSs1MVdiQXdSMnNVWmNMSVp6U3JBbi84eDNzSDR3QWxVZVN2aldPeHQvSGdYZlI4Q2NIN2h1cnk1WWQ2WTNaUmFnbklidkcvYUJZUnM4NFc2N2F2bzJmWDM1VGQrdEtUaHZaWVdCbmpUMnFRREM4WlltOEdKeEVHN0ZxUURGTlNFa241K0w3YjhUSzh4SjNnOStZbElEY0ZMODVqaDBFVnkydk5sdXNhWEllc2hLVmFSd2tFMVdQTEl1TzVERlFzWGpxV2ZQcSsvRHB0U3RGczlHcXRtWm03bGJQTm1yQUFoZXdVdnBqOFpscllVS2hnM2tYZkNQMjBBOG5xc25xcm42cElEcnFlSmpJeE82Y0RhTUF4WXRnanZEOTMrSE5OT1RtdHlaNS9DTEpwUHJCVGJWTWNFS2NFbGd4S1Q4K05RQWYrWWI4Mk1XYkdwMkxHVUgxd3E4dUsvRnhJQkJ3Wm1iQ2dIbno2MjNKNDhaazgvSFJHYitwRnpwUlZSYkNEU2xHSzhMaEF4MXA2QzVHWmlSNVF5Ly9ZNlhrR2pSMDZ5NjZFZTlnZitBUU1VTHVudWwwZFhRRUQ1M0F5cVl4QURKUUliTWYwWDFTenhqZHRaSkY1NDZ2RDd4L3BHUFg0dkx2TVpTMThPa3FvYVVmVXJ1TWNjYXNRb2hJc3hBVDg1NkU4Sy9sbmJSb25xdz09','yes','2024-11-19 09:00:15'),(4,1,'resized_images','','','2024-11-16 23:24:55'),(5,1,'meta','','','2024-09-20 13:23:55'),(6,1,'posts_2','','','2023-11-02 21:21:53'),(7,1,'meta_2','','','2023-11-02 21:21:55');

--
-- Table structure for table `wpinst_cff_feeds`
--

CREATE TABLE `wpinst_cff_feeds` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `feed_name` text COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `feed_title` text COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `settings` longtext COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `author` bigint(20) unsigned NOT NULL DEFAULT '1',
  `status` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  `last_modified` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `author` (`author`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `wpinst_cff_feeds`
--

INSERT INTO `wpinst_cff_feeds` VALUES (1,'Institut Phénix Energétique','','{\"sources\":\"108138480677805\",\"ownaccesstoken\":\"true\",\"pagetoken\":\"\",\"id\":\"108138480677805\",\"pagetype\":\"page\",\"num\":\"3\",\"limit\":\"\",\"eventspostlimit\":\"250\",\"others\":\"\",\"showpostsby\":\"me\",\"cachetype\":\"background\",\"cachetime\":\"1\",\"cacheunit\":\"hours\",\"locale\":\"en_US\",\"storytags\":\"false\",\"ajax\":\"\",\"offset\":\"\",\"account\":\"\",\"width\":\"100%\",\"widthresp\":\"\",\"height\":\"\",\"padding\":\"\",\"bgcolor\":\"#\",\"showauthor\":\"\",\"showauthornew\":\"true\",\"class\":\"\",\"type\":[\"links\",\"events\",\"videos\",\"photos\",\"albums\",\"statuses\"],\"gdpr\":\"auto\",\"loadiframes\":\"false\",\"eventsource\":\"eventspage\",\"eventoffset\":\"6\",\"eventimage\":\"full\",\"pastevents\":\"false\",\"albumsource\":\"photospage\",\"showalbumtitle\":\"true\",\"showalbumnum\":\"false\",\"albumcols\":\"4\",\"photosource\":\"photospage\",\"photocols\":\"4\",\"videosource\":\"videospage\",\"showvideoname\":\"true\",\"showvideodesc\":\"false\",\"videocols\":\"4\",\"playlist\":\"\",\"disablelightbox\":\"off\",\"filter\":\"\",\"exfilter\":\"\",\"layout\":\"fullwidth\",\"enablenarrow\":\"on\",\"oneimage\":\"\",\"mediaposition\":\"above\",\"mediaside\":\"left\",\"include\":\"text,desc,sharedlinks,date,media,medialink,eventtitle,eventdetails,social,link,likebox\",\"exclude\":\"\",\"masonry\":\"\",\"masonrycols\":\"\",\"masonrycolsmobile\":\"\",\"masonryjs\":\"true\",\"cols\":\"3\",\"colsmobile\":\"1\",\"colsjs\":\"true\",\"nummobile\":\"3\",\"poststyle\":\"boxed\",\"postbgcolor\":\"#FFFFFF\",\"postcorners\":\"2\",\"boxshadow\":\"on\",\"textformat\":\"p\",\"textsize\":\"inherit\",\"textweight\":\"inherit\",\"textcolor\":\"#\",\"textlinkcolor\":\"#\",\"textlink\":\"\",\"posttags\":\"on\",\"linkhashtags\":\"on\",\"lightboxcomments\":\"on\",\"authorsize\":\"inherit\",\"authorcolor\":\"#\",\"descsize\":\"12\",\"descweight\":\"inherit\",\"desccolor\":\"#\",\"linktitleformat\":\"p\",\"linktitlesize\":\"inherit\",\"linkdescsize\":\"inherit\",\"linkurlsize\":\"12\",\"linkdesccolor\":\"#\",\"linktitlecolor\":\"#\",\"linkurlcolor\":\"#\",\"linkbgcolor\":\"#\",\"linkbordercolor\":\"#\",\"disablelinkbox\":\"off\",\"eventtitleformat\":\"p\",\"eventtitlesize\":\"inherit\",\"eventtitleweight\":\"inherit\",\"eventtitlecolor\":\"#\",\"eventtitlelink\":\"true\",\"eventdatesize\":\"inherit\",\"eventdateweight\":\"inherit\",\"eventdatecolor\":\"#\",\"eventdatepos\":\"below\",\"eventdateformat\":\"14\",\"eventdatecustom\":\"\",\"timezoneoffset\":\"false\",\"cff_enqueue_with_shortcode\":\"false\",\"eventdetailssize\":\"inherit\",\"eventdetailsweight\":\"inherit\",\"eventdetailscolor\":\"#\",\"eventlinkcolor\":\"#\",\"datepos\":\"author\",\"datesize\":\"inherit\",\"dateweight\":\"inherit\",\"datecolor\":\"#\",\"dateformat\":\"1\",\"datecustom\":\"\",\"timezone\":\"America\\/Chicago\",\"beforedate\":\"\",\"afterdate\":\"\",\"linksize\":\"inherit\",\"linkweight\":\"inherit\",\"linkcolor\":\"#\",\"linktotimeline\":\"false\",\"buttoncolor\":\"\",\"buttonhovercolor\":\"\",\"buttontextcolor\":\"\",\"buttontext\":\"D\\u00e9couvrez plus d\'actualit\\u00e9s\",\"facebooklinktext\":\"\",\"sharelinktext\":\"\",\"iconstyle\":\"light\",\"socialtextcolor\":\"#\",\"socialbgcolor\":\"#\",\"sociallinkcolor\":\"#\",\"expandcomments\":\"\",\"commentsnum\":\"4\",\"hidecommentimages\":\"\",\"loadcommentsjs\":\"false\",\"salesposts\":\"false\",\"textlength\":\"400\",\"desclength\":\"200\",\"showlikebox\":\"off\",\"likeboxpos\":\"bottom\",\"likeboxoutside\":\"\",\"likeboxcolor\":\"\",\"likeboxtextcolor\":\"blue\",\"likeboxwidth\":\"\",\"likeboxfaces\":\"\",\"likeboxborder\":\"\",\"likeboxcover\":\"on\",\"likeboxsmallheader\":\"off\",\"likeboxhidebtn\":\"\",\"credit\":\"\",\"textissue\":\"\",\"disablesvgs\":\"\",\"restrictedpage\":\"\",\"hidesupporterposts\":\"\",\"privategroup\":\"false\",\"nofollow\":\"true\",\"albumordertype\":\"default\",\"timelinepag\":\"date\",\"gridpag\":\"auto\",\"disableresize\":\"false\",\"showheader\":\"on\",\"headertype\":\"visual\",\"headercover\":\"on\",\"headeravatar\":\"\",\"headername\":\"on\",\"headerbio\":\"on\",\"headercoverheight\":\"200\",\"headerlikes\":\"\",\"headeroutside\":\"off\",\"headertext\":\"Facebook Posts\",\"headerbg\":\"#\",\"headerpadding\":\"\",\"headertextsize\":\"inherit\",\"headertextweight\":\"inherit\",\"headertextcolor\":\"#\",\"headericon\":\"facebook-square\",\"headericoncolor\":\"#\",\"headericonsize\":\"28\",\"headerinc\":\"\",\"headerexclude\":\"\",\"loadmore\":\"on\",\"fulllinkimages\":\"on\",\"linkimagesize\":\"largesquare\",\"postimagesize\":\"large\",\"videoheight\":\"\",\"videoaction\":\"post\",\"videoplayer\":\"standard\",\"sepcolor\":\"#ddd\",\"sepsize\":\"1\",\"photostext\":\"photos\",\"showfacebooklink\":\"true\",\"showsharelink\":\"true\",\"multifeedactive\":\"false\",\"daterangeactive\":\"false\",\"featuredpostactive\":\"false\",\"albumactive\":\"false\",\"masonryactive\":\"false\",\"carouselactive\":\"false\",\"reviewsactive\":\"false\",\"from\":\"\",\"until\":\"\",\"daterangefromtype\":\"specific\",\"daterangefromspecific\":\"\",\"daterangefromrelative\":\"\",\"daterangeuntiltype\":\"specific\",\"daterangeuntilspecific\":\"\",\"daterangeuntilrelative\":\"\",\"featuredpost\":\"\",\"album\":\"\",\"daterange\":\"off\",\"lightbox\":\"\",\"reviewsrated\":\"1,2,3,4,5\",\"starsize\":\"12\",\"hidenegative\":\"\",\"reviewslinktext\":\"\",\"reviewshidenotext\":\"\",\"reviewsmethod\":\"all\",\"feedtype\":\"timeline\",\"likeboxcustomwidth\":\"\",\"colstablet\":\"2\",\"feedlayout\":\"masonry\",\"colorpalette\":\"inherit\",\"custombgcolor1\":\"\",\"custombgcolor2\":\"\",\"textcolor1\":\"\",\"textcolor2\":\"\",\"customlinkcolor\":\"\",\"posttextcolor\":\"\",\"misctextcolor\":\"\",\"misclinkcolor\":\"\",\"headericonenabled\":\"on\",\"lightboxbgcolor\":\"\",\"lightboxtextcolor\":\"\",\"lightboxlinkcolor\":\"\",\"beforedateenabled\":\"off\",\"afterdateenabled\":\"off\",\"showpoststypes\":\"all\",\"headerbiosize\":\"inherit\",\"headerbiocolor\":\"#\",\"apipostlimit\":\"auto\",\"carouselheight\":\"tallest\",\"carouseldesktop_cols\":\"1\",\"carouselmobile_cols\":\"1\",\"carouselnavigation\":\"none\",\"carouselpagination\":\"true\",\"carouselautoplay\":\"false\",\"carouselinterval\":\"5000\",\"feedtemplate\":\"widget\",\"nonce\":\"7130535343\"}',2,'publish','2023-11-02 15:43:47');

--
-- Table structure for table `wpinst_cff_feeds_posts`
--

CREATE TABLE `wpinst_cff_feeds_posts` (
  `record_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `id` int(11) unsigned NOT NULL,
  `feed_id` varchar(1000) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`record_id`),
  KEY `feed_id` (`feed_id`(100))
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `wpinst_cff_feeds_posts`
--

INSERT INTO `wpinst_cff_feeds_posts` VALUES (1,1,'cff_10813848067780081384806778054mefr0000'),(2,2,'cff_10813848067780081384806778054mefr0000'),(3,2,'cff_10813848067780081384806778059mefr0000'),(4,1,'cff_10813848067780081384806778059mefr0000'),(5,3,'cff_10813848067780081384806778059mefr0000'),(6,4,'cff_10813848067780081384806778059mefr0000'),(7,5,'cff_10813848067780081384806778059mefr0000'),(8,6,'cff_10813848067780081384806778059mefr0000'),(9,2,'cff_10813848067780081384806778055meen0000'),(10,1,'cff_10813848067780081384806778055meen0000'),(11,3,'cff_10813848067780081384806778055meen0000'),(12,7,'cff_10813848067780081384806778055meen0000'),(13,8,'cff_10813848067780081384806778055meen0000'),(14,9,'cff_10813848067780081384806778055meen0000'),(15,10,'cff_10813848067780081384806778055meen0000'),(16,11,'cff_10813848067780081384806778055meen0000'),(17,12,'cff_10813848067780081384806778055meen0000'),(18,13,'cff_10813848067780081384806778055meen0000');

--
-- Table structure for table `wpinst_cff_posts`
--

CREATE TABLE `wpinst_cff_posts` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `facebook_id` varchar(1000) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  `created_on` datetime DEFAULT NULL,
  `last_requested` date DEFAULT NULL,
  `time_stamp` datetime DEFAULT NULL,
  `json_data` longtext COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `media_id` varchar(1000) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  `sizes` varchar(1000) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  `aspect_ratio` decimal(4,2) NOT NULL DEFAULT '0.00',
  `images_done` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `wpinst_cff_posts`
--

INSERT INTO `wpinst_cff_posts` VALUES (1,'108138480677805_887814889479714','2023-10-31 15:28:08','2023-10-31','2023-10-13 17:00:45','[encoded data, 14524 characters]','108138480677805_887814889479714','[400,250,700]',1.00,1),(2,'108138480677805_898922915035578','2023-10-31 21:39:06','2023-10-31','2023-10-31 17:47:49','[encoded data, 16872 characters]','108138480677805_898922915035578','[400,250]',1.00,1),(3,'108138480677805_887035012891035','2023-11-02 15:30:12','2023-11-02','2023-10-12 17:00:22','[encoded data, 15500 characters]','108138480677805_887035012891035','[400,250]',1.00,1),(4,'108138480677805_886374912957045','2023-11-02 15:30:13','2023-11-02','2023-10-11 17:00:30','[encoded data, 17528 characters]','108138480677805_886374912957045','[400,250]',1.00,1),(5,'108138480677805_883141799947023','2023-11-02 15:30:13','2023-11-02','2023-10-06 17:00:15','[encoded data, 12552 characters]','108138480677805_883141799947023','[400,250]',1.00,1),(6,'108138480677805_875851384050352','2023-11-02 15:30:14','2023-11-02','2023-10-06 10:56:10','[encoded data, 5080 characters]','108138480677805_875851384050352','[400,250]',1.00,1),(7,'108138480677805_905233734404496','2023-11-13 13:36:40','2023-11-13','2023-11-11 19:00:32','[encoded data, 11404 characters]','108138480677805_905233734404496','[400,250]',1.00,1),(8,'108138480677805_904588467802356','2023-11-13 13:36:41','2023-11-13','2023-11-10 18:01:53','[encoded data, 16640 characters]','108138480677805_904588467802356','[400,250]',1.00,1),(9,'108138480677805_904031654524704','2023-11-13 13:36:41','2023-11-13','2023-11-09 19:00:42','[encoded data, 16648 characters]','108138480677805_904031654524704','[400,250]',1.00,1),(10,'108138480677805_961469208780948','2024-02-14 12:20:30','2024-02-14','2024-02-06 17:00:48','[encoded data, 11216 characters]','108138480677805_961469208780948','[400,250]',1.00,1),(11,'108138480677805_953736149554254','2024-02-14 12:20:30','2024-02-14','2024-01-26 09:54:05','[encoded data, 12464 characters]','108138480677805_953736149554254','[400,250]',1.00,1),(12,'108138480677805_966830431578159','2024-02-14 13:28:04','2024-02-14','2024-02-14 12:06:44','[encoded data, 16632 characters]','108138480677805_966830431578159','[400,250]',1.00,1),(13,'108138480677805_967497114844824','2024-02-21 03:48:53','2024-02-21','2024-02-15 12:00:25','[encoded data, 6384 characters]','108138480677805_967497114844824','[400,250]',1.00,1);

--
