--
-- Host: ifgeyabnew.mysql.db    Database: ifgeyabnew
-- ------------------------------------------------------


--
-- Table structure for table `entrevue_posts`
--

CREATE TABLE `entrevue_posts` (
  `ID` bigint unsigned NOT NULL AUTO_INCREMENT,
  `post_author` bigint unsigned NOT NULL DEFAULT '0',
  `post_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `post_date_gmt` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `post_content` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `post_title` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `post_excerpt` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `post_status` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT 'publish',
  `comment_status` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT 'open',
  `ping_status` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT 'open',
  `post_password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `post_name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `to_ping` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `pinged` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `post_modified` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `post_modified_gmt` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `post_content_filtered` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `post_parent` bigint unsigned NOT NULL DEFAULT '0',
  `guid` varchar(255) COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
  `menu_order` int NOT NULL DEFAULT '0',
  `post_type` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT 'post',
  `post_mime_type` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `comment_count` bigint NOT NULL DEFAULT '0',
  PRIMARY KEY (`ID`),
  KEY `post_name` (`post_name`(191)),
  KEY `type_status_date` (`post_type`,`post_status`,`post_date`,`ID`),
  KEY `post_parent` (`post_parent`),
  KEY `post_author` (`post_author`),
  KEY `type_status_author` (`post_type`,`post_status`,`post_author`)
) ENGINE=InnoDB AUTO_INCREMENT=1000214494 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `entrevue_posts`
--
-- WHERE:  post_name IN ('about','politiques-de-confidentialite','editorial-policy','corrections-policy','mentions-legales','contact','faq','omar-harfouch','jerome-goulon-redactor') OR ID IN (79993,1000022637)

INSERT INTO `entrevue_posts` VALUES (79993,4,'2024-12-03 21:56:33','2024-12-03 21:56:33','','Omar-harfouch','','inherit','','closed','','omar-harfouch','','','2024-12-03 21:56:33','2024-12-03 21:56:33','',79990,'https://entrevue.fr/wp-content/uploads/2024/12/Omar-harfouch.jpg',0,'attachment','image/jpeg',0),(1000022637,4,'2023-10-09 11:29:04','2023-10-09 09:29:04','','Omar harfouch','','inherit','','closed','','omar-harfouch','','','2023-10-09 11:29:04','2023-10-09 09:29:04','',22635,'https://www.entrevue.fr/wp-content/uploads/2023/10/Omar-harfouch.jpg',0,'attachment','image/jpeg',0);


