Advertisement
cododigital

MySQL 8 Export

Feb 17th, 2020
542
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 35.97 KB | None | 0 0
  1. -- MySQL dump 10.13  Distrib 8.0.19, for Linux (x86_64)
  2. --
  3. -- Host: localhost    Database: wordpress-codo-digital
  4. -- ------------------------------------------------------
  5. -- Server version   8.0.19
  6.  
  7. /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
  8. /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
  9. /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
  10. /*!50503 SET NAMES utf8mb4 */;
  11. /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
  12. /*!40103 SET TIME_ZONE='+00:00' */;
  13. /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
  14. /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
  15. /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
  16. /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
  17.  
  18. --
  19. -- Table structure for table `wp_commentmeta`
  20. --
  21.  
  22. --
  23. -- Table structure for table `wp_options`
  24. --
  25.  
  26. DROP TABLE IF EXISTS `wp_options`;
  27. /*!40101 SET @saved_cs_client     = @@character_set_client */;
  28. /*!50503 SET character_set_client = utf8mb4 */;
  29. CREATE TABLE `wp_options` (
  30.   `option_id` bigint unsigned NOT NULL AUTO_INCREMENT,
  31.   `option_name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  32.   `option_value` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,
  33.   `autoload` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'yes',
  34.   PRIMARY KEY (`option_id`),
  35.   UNIQUE KEY `option_name` (`option_name`),
  36.   KEY `autoload` (`autoload`)
  37. ) ENGINE=InnoDB AUTO_INCREMENT=49778 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
  38. /*!40101 SET character_set_client = @saved_cs_client */;
  39.  
  40. --
  41. -- Table structure for table `wp_users`
  42. --
  43.  
  44. DROP TABLE IF EXISTS `wp_users`;
  45. /*!40101 SET @saved_cs_client     = @@character_set_client */;
  46. /*!50503 SET character_set_client = utf8mb4 */;
  47. CREATE TABLE `wp_users` (
  48.   `ID` bigint unsigned NOT NULL AUTO_INCREMENT,
  49.   `user_login` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  50.   `user_pass` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  51.   `user_nicename` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  52.   `user_email` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  53.   `user_url` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  54.   `user_registered` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  55.   `user_activation_key` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  56.   `user_status` int NOT NULL DEFAULT '0',
  57.   `display_name` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  58.   PRIMARY KEY (`ID`),
  59.   KEY `user_login_key` (`user_login`),
  60.   KEY `user_nicename` (`user_nicename`),
  61.   KEY `user_email` (`user_email`)
  62. ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
  63. /*!40101 SET character_set_client = @saved_cs_client */;
  64.  
  65. --
  66. -- Dumping data for table `wp_users`
  67. --
  68.  
  69. LOCK TABLES `wp_users` WRITE;
  70. /*!40000 ALTER TABLE `wp_users` DISABLE KEYS */;
  71. /*!40000 ALTER TABLE `wp_users` ENABLE KEYS */;
  72. UNLOCK TABLES;
  73.  
  74.  
  75.  
  76. --
  77. -- Table structure for table `wp_usermeta`
  78. --
  79.  
  80. DROP TABLE IF EXISTS `wp_usermeta`;
  81. /*!40101 SET @saved_cs_client     = @@character_set_client */;
  82. /*!50503 SET character_set_client = utf8mb4 */;
  83. CREATE TABLE `wp_usermeta` (
  84.   `umeta_id` bigint unsigned NOT NULL AUTO_INCREMENT,
  85.   `user_id` bigint unsigned NOT NULL DEFAULT '0',
  86.   `meta_key` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  87.   `meta_value` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci,
  88.   PRIMARY KEY (`umeta_id`),
  89.   KEY `user_id` (`user_id`),
  90.   KEY `meta_key` (`meta_key`(191))
  91. ) ENGINE=InnoDB AUTO_INCREMENT=79 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
  92. /*!40101 SET character_set_client = @saved_cs_client */;
  93.  
  94. --
  95. -- Dumping data for table `wp_usermeta`
  96. --
  97.  
  98. LOCK TABLES `wp_usermeta` WRITE;
  99. /*!40000 ALTER TABLE `wp_usermeta` DISABLE KEYS */;
  100. /*!40000 ALTER TABLE `wp_usermeta` ENABLE KEYS */;
  101. UNLOCK TABLES;
  102.  
  103. --
  104. -- Dumping data for table `wp_options`
  105. --
  106.  
  107. LOCK TABLES `wp_options` WRITE;
  108. /*!40000 ALTER TABLE `wp_options` DISABLE KEYS */;
  109. /*!40000 ALTER TABLE `wp_options` ENABLE KEYS */;
  110. UNLOCK TABLES;
  111.  
  112. DROP TABLE IF EXISTS `wp_commentmeta`;
  113. /*!40101 SET @saved_cs_client     = @@character_set_client */;
  114. /*!50503 SET character_set_client = utf8mb4 */;
  115. CREATE TABLE `wp_commentmeta` (
  116.   `meta_id` bigint unsigned NOT NULL AUTO_INCREMENT,
  117.   `comment_id` bigint unsigned NOT NULL DEFAULT '0',
  118.   `meta_key` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  119.   `meta_value` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci,
  120.   PRIMARY KEY (`meta_id`),
  121.   KEY `comment_id` (`comment_id`),
  122.   KEY `meta_key` (`meta_key`(191))
  123. ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
  124. /*!40101 SET character_set_client = @saved_cs_client */;
  125.  
  126. --
  127. -- Dumping data for table `wp_commentmeta`
  128. --
  129.  
  130. LOCK TABLES `wp_commentmeta` WRITE;
  131. /*!40000 ALTER TABLE `wp_commentmeta` DISABLE KEYS */;
  132. /*!40000 ALTER TABLE `wp_commentmeta` ENABLE KEYS */;
  133. UNLOCK TABLES;
  134.  
  135. --
  136. -- Table structure for table `wp_comments`
  137. --
  138.  
  139. DROP TABLE IF EXISTS `wp_comments`;
  140. /*!40101 SET @saved_cs_client     = @@character_set_client */;
  141. /*!50503 SET character_set_client = utf8mb4 */;
  142. CREATE TABLE `wp_comments` (
  143.   `comment_ID` bigint unsigned NOT NULL AUTO_INCREMENT,
  144.   `comment_post_ID` bigint unsigned NOT NULL DEFAULT '0',
  145.   `comment_author` tinytext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,
  146.   `comment_author_email` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  147.   `comment_author_url` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  148.   `comment_author_IP` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  149.   `comment_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  150.   `comment_date_gmt` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  151.   `comment_content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,
  152.   `comment_karma` int NOT NULL DEFAULT '0',
  153.   `comment_approved` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '1',
  154.   `comment_agent` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  155.   `comment_type` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  156.   `comment_parent` bigint unsigned NOT NULL DEFAULT '0',
  157.   `user_id` bigint unsigned NOT NULL DEFAULT '0',
  158.   PRIMARY KEY (`comment_ID`),
  159.   KEY `comment_post_ID` (`comment_post_ID`),
  160.   KEY `comment_approved_date_gmt` (`comment_approved`,`comment_date_gmt`),
  161.   KEY `comment_date_gmt` (`comment_date_gmt`),
  162.   KEY `comment_parent` (`comment_parent`),
  163.   KEY `comment_author_email` (`comment_author_email`(10))
  164. ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
  165. /*!40101 SET character_set_client = @saved_cs_client */;
  166.  
  167. --
  168. -- Dumping data for table `wp_comments`
  169. --
  170.  
  171. LOCK TABLES `wp_comments` WRITE;
  172. /*!40000 ALTER TABLE `wp_comments` DISABLE KEYS */;
  173. /*!40000 ALTER TABLE `wp_comments` ENABLE KEYS */;
  174. UNLOCK TABLES;
  175.  
  176.  
  177.  
  178. --
  179. -- Table structure for table `wp_links`
  180. --
  181.  
  182. DROP TABLE IF EXISTS `wp_links`;
  183. /*!40101 SET @saved_cs_client     = @@character_set_client */;
  184. /*!50503 SET character_set_client = utf8mb4 */;
  185. CREATE TABLE `wp_links` (
  186.   `link_id` bigint unsigned NOT NULL AUTO_INCREMENT,
  187.   `link_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  188.   `link_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  189.   `link_image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  190.   `link_target` varchar(25) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  191.   `link_description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  192.   `link_visible` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'Y',
  193.   `link_owner` bigint unsigned NOT NULL DEFAULT '1',
  194.   `link_rating` int NOT NULL DEFAULT '0',
  195.   `link_updated` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  196.   `link_rel` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  197.   `link_notes` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,
  198.   `link_rss` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  199.   PRIMARY KEY (`link_id`),
  200.   KEY `link_visible` (`link_visible`)
  201. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
  202. /*!40101 SET character_set_client = @saved_cs_client */;
  203.  
  204. --
  205. -- Dumping data for table `wp_links`
  206. --
  207.  
  208. LOCK TABLES `wp_links` WRITE;
  209. /*!40000 ALTER TABLE `wp_links` DISABLE KEYS */;
  210. /*!40000 ALTER TABLE `wp_links` ENABLE KEYS */;
  211. UNLOCK TABLES;
  212.  
  213. --
  214. -- Table structure for table `wp_ewwwio_images`
  215. --
  216.  
  217. --
  218. -- Table structure for table `wp_postmeta`
  219. --
  220.  
  221. DROP TABLE IF EXISTS `wp_postmeta`;
  222. /*!40101 SET @saved_cs_client     = @@character_set_client */;
  223. /*!50503 SET character_set_client = utf8mb4 */;
  224. CREATE TABLE `wp_postmeta` (
  225.   `meta_id` bigint unsigned NOT NULL AUTO_INCREMENT,
  226.   `post_id` bigint unsigned NOT NULL DEFAULT '0',
  227.   `meta_key` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  228.   `meta_value` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci,
  229.   PRIMARY KEY (`meta_id`),
  230.   KEY `post_id` (`post_id`),
  231.   KEY `meta_key` (`meta_key`(191))
  232. ) ENGINE=InnoDB AUTO_INCREMENT=507 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
  233. /*!40101 SET character_set_client = @saved_cs_client */;
  234.  
  235. --
  236. -- Dumping data for table `wp_postmeta`
  237. --
  238.  
  239. LOCK TABLES `wp_postmeta` WRITE;
  240. /*!40000 ALTER TABLE `wp_postmeta` DISABLE KEYS */;
  241. /*!40000 ALTER TABLE `wp_postmeta` ENABLE KEYS */;
  242. UNLOCK TABLES;
  243.  
  244. --
  245. -- Table structure for table `wp_posts`
  246. --
  247.  
  248. DROP TABLE IF EXISTS `wp_posts`;
  249. /*!40101 SET @saved_cs_client     = @@character_set_client */;
  250. /*!50503 SET character_set_client = utf8mb4 */;
  251. CREATE TABLE `wp_posts` (
  252.   `ID` bigint unsigned NOT NULL AUTO_INCREMENT,
  253.   `post_author` bigint unsigned NOT NULL DEFAULT '0',
  254.   `post_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  255.   `post_date_gmt` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  256.   `post_content` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,
  257.   `post_title` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,
  258.   `post_excerpt` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,
  259.   `post_status` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'publish',
  260.   `comment_status` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'open',
  261.   `ping_status` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'open',
  262.   `post_password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  263.   `post_name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  264.   `to_ping` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,
  265.   `pinged` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,
  266.   `post_modified` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  267.   `post_modified_gmt` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  268.   `post_content_filtered` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,
  269.   `post_parent` bigint unsigned NOT NULL DEFAULT '0',
  270.   `guid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  271.   `menu_order` int NOT NULL DEFAULT '0',
  272.   `post_type` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'post',
  273.   `post_mime_type` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  274.   `comment_count` bigint NOT NULL DEFAULT '0',
  275.   PRIMARY KEY (`ID`),
  276.   KEY `post_name` (`post_name`(191)),
  277.   KEY `type_status_date` (`post_type`,`post_status`,`post_date`,`ID`),
  278.   KEY `post_parent` (`post_parent`),
  279.   KEY `post_author` (`post_author`)
  280. ) ENGINE=InnoDB AUTO_INCREMENT=411 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
  281. /*!40101 SET character_set_client = @saved_cs_client */;
  282.  
  283. --
  284. -- Dumping data for table `wp_posts`
  285. --
  286.  
  287. LOCK TABLES `wp_posts` WRITE;
  288. /*!40000 ALTER TABLE `wp_posts` DISABLE KEYS */;
  289. /*!40000 ALTER TABLE `wp_posts` ENABLE KEYS */;
  290. UNLOCK TABLES;
  291.  
  292.  
  293. --
  294. -- Table structure for table `wp_term_relationships`
  295. --
  296.  
  297. DROP TABLE IF EXISTS `wp_term_relationships`;
  298. /*!40101 SET @saved_cs_client     = @@character_set_client */;
  299. /*!50503 SET character_set_client = utf8mb4 */;
  300. CREATE TABLE `wp_term_relationships` (
  301.   `object_id` bigint unsigned NOT NULL DEFAULT '0',
  302.   `term_taxonomy_id` bigint unsigned NOT NULL DEFAULT '0',
  303.   `term_order` int NOT NULL DEFAULT '0',
  304.   PRIMARY KEY (`object_id`,`term_taxonomy_id`),
  305.   KEY `term_taxonomy_id` (`term_taxonomy_id`)
  306. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
  307. /*!40101 SET character_set_client = @saved_cs_client */;
  308.  
  309. --
  310. -- Dumping data for table `wp_term_relationships`
  311. --
  312.  
  313. LOCK TABLES `wp_term_relationships` WRITE;
  314. /*!40000 ALTER TABLE `wp_term_relationships` DISABLE KEYS */;
  315. /*!40000 ALTER TABLE `wp_term_relationships` ENABLE KEYS */;
  316. UNLOCK TABLES;
  317.  
  318. --
  319. -- Table structure for table `wp_term_taxonomy`
  320. --
  321.  
  322. DROP TABLE IF EXISTS `wp_term_taxonomy`;
  323. /*!40101 SET @saved_cs_client     = @@character_set_client */;
  324. /*!50503 SET character_set_client = utf8mb4 */;
  325. CREATE TABLE `wp_term_taxonomy` (
  326.   `term_taxonomy_id` bigint unsigned NOT NULL AUTO_INCREMENT,
  327.   `term_id` bigint unsigned NOT NULL DEFAULT '0',
  328.   `taxonomy` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  329.   `description` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,
  330.   `parent` bigint unsigned NOT NULL DEFAULT '0',
  331.   `count` bigint NOT NULL DEFAULT '0',
  332.   PRIMARY KEY (`term_taxonomy_id`),
  333.   UNIQUE KEY `term_id_taxonomy` (`term_id`,`taxonomy`),
  334.   KEY `taxonomy` (`taxonomy`)
  335. ) ENGINE=InnoDB AUTO_INCREMENT=111 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
  336. /*!40101 SET character_set_client = @saved_cs_client */;
  337.  
  338. --
  339. -- Dumping data for table `wp_term_taxonomy`
  340. --
  341.  
  342. LOCK TABLES `wp_term_taxonomy` WRITE;
  343. /*!40000 ALTER TABLE `wp_term_taxonomy` DISABLE KEYS */;
  344. /*!40000 ALTER TABLE `wp_term_taxonomy` ENABLE KEYS */;
  345. UNLOCK TABLES;
  346.  
  347. --
  348. -- Table structure for table `wp_termmeta`
  349. --
  350.  
  351. DROP TABLE IF EXISTS `wp_termmeta`;
  352. /*!40101 SET @saved_cs_client     = @@character_set_client */;
  353. /*!50503 SET character_set_client = utf8mb4 */;
  354. CREATE TABLE `wp_termmeta` (
  355.   `meta_id` bigint unsigned NOT NULL AUTO_INCREMENT,
  356.   `term_id` bigint unsigned NOT NULL DEFAULT '0',
  357.   `meta_key` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  358.   `meta_value` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci,
  359.   PRIMARY KEY (`meta_id`),
  360.   KEY `term_id` (`term_id`),
  361.   KEY `meta_key` (`meta_key`(191))
  362. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
  363. /*!40101 SET character_set_client = @saved_cs_client */;
  364.  
  365. --
  366. -- Dumping data for table `wp_termmeta`
  367. --
  368.  
  369. LOCK TABLES `wp_termmeta` WRITE;
  370. /*!40000 ALTER TABLE `wp_termmeta` DISABLE KEYS */;
  371. /*!40000 ALTER TABLE `wp_termmeta` ENABLE KEYS */;
  372. UNLOCK TABLES;
  373.  
  374. --
  375. -- Table structure for table `wp_terms`
  376. --
  377.  
  378. DROP TABLE IF EXISTS `wp_terms`;
  379. /*!40101 SET @saved_cs_client     = @@character_set_client */;
  380. /*!50503 SET character_set_client = utf8mb4 */;
  381. CREATE TABLE `wp_terms` (
  382.   `term_id` bigint unsigned NOT NULL AUTO_INCREMENT,
  383.   `name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  384.   `slug` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  385.   `term_group` bigint NOT NULL DEFAULT '0',
  386.   PRIMARY KEY (`term_id`),
  387.   KEY `slug` (`slug`(191)),
  388.   KEY `name` (`name`(191))
  389. ) ENGINE=InnoDB AUTO_INCREMENT=111 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
  390. /*!40101 SET character_set_client = @saved_cs_client */;
  391.  
  392. --
  393. -- Dumping data for table `wp_terms`
  394. --
  395.  
  396. LOCK TABLES `wp_terms` WRITE;
  397. /*!40000 ALTER TABLE `wp_terms` DISABLE KEYS */;
  398. /*!40000 ALTER TABLE `wp_terms` ENABLE KEYS */;
  399. UNLOCK TABLES;
  400.  
  401. -- Table structure for table `wp_yoast_seo_links`
  402. --
  403.  
  404. DROP TABLE IF EXISTS `wp_yoast_seo_links`;
  405. /*!40101 SET @saved_cs_client     = @@character_set_client */;
  406. /*!50503 SET character_set_client = utf8mb4 */;
  407. CREATE TABLE `wp_yoast_seo_links` (
  408.   `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  409.   `url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,
  410.   `post_id` bigint unsigned NOT NULL,
  411.   `target_post_id` bigint unsigned NOT NULL,
  412.   `type` varchar(8) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,
  413.   PRIMARY KEY (`id`),
  414.   KEY `link_direction` (`post_id`,`type`)
  415. ) ENGINE=InnoDB AUTO_INCREMENT=35 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
  416. /*!40101 SET character_set_client = @saved_cs_client */;
  417.  
  418. --
  419. -- Dumping data for table `wp_yoast_seo_links`
  420. --
  421.  
  422. LOCK TABLES `wp_yoast_seo_links` WRITE;
  423. /*!40000 ALTER TABLE `wp_yoast_seo_links` DISABLE KEYS */;
  424. /*!40000 ALTER TABLE `wp_yoast_seo_links` ENABLE KEYS */;
  425. UNLOCK TABLES;
  426.  
  427. --
  428. -- Table structure for table `wp_yoast_seo_meta`
  429. --
  430. --
  431. DROP TABLE IF EXISTS `wp_yoast_seo_meta`;
  432. /*!40101 SET @saved_cs_client     = @@character_set_client */;
  433. /*!50503 SET character_set_client = utf8mb4 */;
  434. CREATE TABLE `wp_yoast_seo_meta` (
  435.   `object_id` bigint unsigned NOT NULL,
  436.   `internal_link_count` int unsigned DEFAULT NULL,
  437.   `incoming_link_count` int unsigned DEFAULT NULL,
  438.   UNIQUE KEY `object_id` (`object_id`)
  439. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
  440. /*!40101 SET character_set_client = @saved_cs_client */;
  441.  
  442.  
  443. DROP TABLE IF EXISTS `wp_ewwwio_images`;
  444. /*!40101 SET @saved_cs_client     = @@character_set_client */;
  445. /*!50503 SET character_set_client = utf8mb4 */;
  446. CREATE TABLE `wp_ewwwio_images` (
  447.   `id` int unsigned NOT NULL AUTO_INCREMENT,
  448.   `attachment_id` bigint unsigned DEFAULT NULL,
  449.   `gallery` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  450.   `resize` varchar(75) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  451.   `path` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,
  452.   `converted` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,
  453.   `results` varchar(75) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,
  454.   `image_size` int unsigned DEFAULT NULL,
  455.   `orig_size` int unsigned DEFAULT NULL,
  456.   `backup` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  457.   `level` int unsigned DEFAULT NULL,
  458.   `pending` tinyint(1) NOT NULL DEFAULT '0',
  459.   `updates` int unsigned DEFAULT NULL,
  460.   `updated` timestamp NULL DEFAULT '1971-01-01 00:00:00' ON UPDATE CURRENT_TIMESTAMP,
  461.   `trace` blob,
  462.   UNIQUE KEY `id` (`id`),
  463.   KEY `path` (`path`(191)),
  464.   KEY `attachment_info` (`gallery`(3),`attachment_id`)
  465. ) ENGINE=InnoDB AUTO_INCREMENT=546 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
  466. /*!40101 SET character_set_client = @saved_cs_client */;
  467.  
  468. --
  469. -- Dumping data for table `wp_ewwwio_images`
  470. --
  471.  
  472. LOCK TABLES `wp_ewwwio_images` WRITE;
  473. /*!40000 ALTER TABLE `wp_ewwwio_images` DISABLE KEYS */;
  474. /*!40000 ALTER TABLE `wp_ewwwio_images` ENABLE KEYS */;
  475. UNLOCK TABLES;
  476.  
  477. --
  478. -- Table structure for table `wp_ewwwio_queue`
  479. --
  480.  
  481. DROP TABLE IF EXISTS `wp_ewwwio_queue`;
  482. /*!40101 SET @saved_cs_client     = @@character_set_client */;
  483. /*!50503 SET character_set_client = utf8mb4 */;
  484. CREATE TABLE `wp_ewwwio_queue` (
  485.   `attachment_id` bigint unsigned DEFAULT NULL,
  486.   `gallery` varchar(10) DEFAULT NULL,
  487.   `scanned` tinyint(1) NOT NULL DEFAULT '0',
  488.   KEY `attachment_info` (`gallery`(3),`attachment_id`)
  489. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  490. /*!40101 SET character_set_client = @saved_cs_client */;
  491.  
  492. --
  493. -- Dumping data for table `wp_ewwwio_queue`
  494. --
  495.  
  496. LOCK TABLES `wp_ewwwio_queue` WRITE;
  497. /*!40000 ALTER TABLE `wp_ewwwio_queue` DISABLE KEYS */;
  498. /*!40000 ALTER TABLE `wp_ewwwio_queue` ENABLE KEYS */;
  499. UNLOCK TABLES;
  500.  
  501. --
  502. -- Table structure for table `wp_gf_addon_feed`
  503. --
  504.  
  505. DROP TABLE IF EXISTS `wp_gf_addon_feed`;
  506. /*!40101 SET @saved_cs_client     = @@character_set_client */;
  507. /*!50503 SET character_set_client = utf8mb4 */;
  508. CREATE TABLE `wp_gf_addon_feed` (
  509.   `id` mediumint unsigned NOT NULL AUTO_INCREMENT,
  510.   `form_id` mediumint unsigned NOT NULL,
  511.   `is_active` tinyint(1) NOT NULL DEFAULT '1',
  512.   `feed_order` mediumint unsigned NOT NULL DEFAULT '0',
  513.   `meta` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci,
  514.   `addon_slug` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  515.   `event_type` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  516.   PRIMARY KEY (`id`),
  517.   KEY `addon_form` (`addon_slug`,`form_id`)
  518. ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
  519. /*!40101 SET character_set_client = @saved_cs_client */;
  520.  
  521. --
  522. -- Dumping data for table `wp_gf_addon_feed`
  523. --
  524.  
  525. LOCK TABLES `wp_gf_addon_feed` WRITE;
  526. /*!40000 ALTER TABLE `wp_gf_addon_feed` DISABLE KEYS */;
  527. /*!40000 ALTER TABLE `wp_gf_addon_feed` ENABLE KEYS */;
  528. UNLOCK TABLES;
  529.  
  530. --
  531. -- Table structure for table `wp_gf_draft_submissions`
  532. --
  533.  
  534. DROP TABLE IF EXISTS `wp_gf_draft_submissions`;
  535. /*!40101 SET @saved_cs_client     = @@character_set_client */;
  536. /*!50503 SET character_set_client = utf8mb4 */;
  537. CREATE TABLE `wp_gf_draft_submissions` (
  538.   `uuid` char(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,
  539.   `email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  540.   `form_id` mediumint unsigned NOT NULL,
  541.   `date_created` datetime NOT NULL,
  542.   `ip` varchar(39) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,
  543.   `source_url` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,
  544.   `submission` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,
  545.   PRIMARY KEY (`uuid`),
  546.   KEY `form_id` (`form_id`)
  547. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
  548. /*!40101 SET character_set_client = @saved_cs_client */;
  549.  
  550. --
  551. -- Dumping data for table `wp_gf_draft_submissions`
  552. --
  553.  
  554. LOCK TABLES `wp_gf_draft_submissions` WRITE;
  555. /*!40000 ALTER TABLE `wp_gf_draft_submissions` DISABLE KEYS */;
  556. /*!40000 ALTER TABLE `wp_gf_draft_submissions` ENABLE KEYS */;
  557. UNLOCK TABLES;
  558.  
  559. --
  560. -- Table structure for table `wp_gf_entry`
  561. --
  562.  
  563. DROP TABLE IF EXISTS `wp_gf_entry`;
  564. /*!40101 SET @saved_cs_client     = @@character_set_client */;
  565. /*!50503 SET character_set_client = utf8mb4 */;
  566. CREATE TABLE `wp_gf_entry` (
  567.   `id` int unsigned NOT NULL AUTO_INCREMENT,
  568.   `form_id` mediumint unsigned NOT NULL,
  569.   `post_id` bigint unsigned DEFAULT NULL,
  570.   `date_created` datetime NOT NULL,
  571.   `date_updated` datetime DEFAULT NULL,
  572.   `is_starred` tinyint(1) NOT NULL DEFAULT '0',
  573.   `is_read` tinyint(1) NOT NULL DEFAULT '0',
  574.   `ip` varchar(39) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,
  575.   `source_url` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  576.   `user_agent` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  577.   `currency` varchar(5) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  578.   `payment_status` varchar(15) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  579.   `payment_date` datetime DEFAULT NULL,
  580.   `payment_amount` decimal(19,2) DEFAULT NULL,
  581.   `payment_method` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  582.   `transaction_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  583.   `is_fulfilled` tinyint(1) DEFAULT NULL,
  584.   `created_by` bigint unsigned DEFAULT NULL,
  585.   `transaction_type` tinyint(1) DEFAULT NULL,
  586.   `status` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'active',
  587.   PRIMARY KEY (`id`),
  588.   KEY `form_id` (`form_id`),
  589.   KEY `form_id_status` (`form_id`,`status`)
  590. ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
  591. /*!40101 SET character_set_client = @saved_cs_client */;
  592.  
  593. --
  594. -- Dumping data for table `wp_gf_entry`
  595. --
  596.  
  597. LOCK TABLES `wp_gf_entry` WRITE;
  598. /*!40000 ALTER TABLE `wp_gf_entry` DISABLE KEYS */;
  599. /*!40000 ALTER TABLE `wp_gf_entry` ENABLE KEYS */;
  600. UNLOCK TABLES;
  601.  
  602. --
  603. -- Table structure for table `wp_gf_entry_meta`
  604. --
  605.  
  606. DROP TABLE IF EXISTS `wp_gf_entry_meta`;
  607. /*!40101 SET @saved_cs_client     = @@character_set_client */;
  608. /*!50503 SET character_set_client = utf8mb4 */;
  609. CREATE TABLE `wp_gf_entry_meta` (
  610.   `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  611.   `form_id` mediumint unsigned NOT NULL DEFAULT '0',
  612.   `entry_id` bigint unsigned NOT NULL,
  613.   `meta_key` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  614.   `meta_value` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci,
  615.   `item_index` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  616.   PRIMARY KEY (`id`),
  617.   KEY `meta_key` (`meta_key`(191)),
  618.   KEY `entry_id` (`entry_id`),
  619.   KEY `meta_value` (`meta_value`(191))
  620. ) ENGINE=InnoDB AUTO_INCREMENT=42 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
  621. /*!40101 SET character_set_client = @saved_cs_client */;
  622.  
  623. --
  624. -- Dumping data for table `wp_gf_entry_meta`
  625. --
  626.  
  627. LOCK TABLES `wp_gf_entry_meta` WRITE;
  628. /*!40000 ALTER TABLE `wp_gf_entry_meta` DISABLE KEYS */;
  629. /*!40000 ALTER TABLE `wp_gf_entry_meta` ENABLE KEYS */;
  630. UNLOCK TABLES;
  631.  
  632. --
  633. -- Table structure for table `wp_gf_entry_notes`
  634. --
  635.  
  636. DROP TABLE IF EXISTS `wp_gf_entry_notes`;
  637. /*!40101 SET @saved_cs_client     = @@character_set_client */;
  638. /*!50503 SET character_set_client = utf8mb4 */;
  639. CREATE TABLE `wp_gf_entry_notes` (
  640.   `id` int unsigned NOT NULL AUTO_INCREMENT,
  641.   `entry_id` int unsigned NOT NULL,
  642.   `user_name` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  643.   `user_id` bigint DEFAULT NULL,
  644.   `date_created` datetime NOT NULL,
  645.   `value` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci,
  646.   `note_type` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  647.   `sub_type` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  648.   PRIMARY KEY (`id`),
  649.   KEY `entry_id` (`entry_id`),
  650.   KEY `entry_user_key` (`entry_id`,`user_id`)
  651. ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
  652. /*!40101 SET character_set_client = @saved_cs_client */;
  653.  
  654. --
  655. -- Dumping data for table `wp_gf_entry_notes`
  656. --
  657.  
  658. LOCK TABLES `wp_gf_entry_notes` WRITE;
  659. /*!40000 ALTER TABLE `wp_gf_entry_notes` DISABLE KEYS */;
  660. /*!40000 ALTER TABLE `wp_gf_entry_notes` ENABLE KEYS */;
  661. UNLOCK TABLES;
  662.  
  663. --
  664. -- Table structure for table `wp_gf_form`
  665. --
  666.  
  667. DROP TABLE IF EXISTS `wp_gf_form`;
  668. /*!40101 SET @saved_cs_client     = @@character_set_client */;
  669. /*!50503 SET character_set_client = utf8mb4 */;
  670. CREATE TABLE `wp_gf_form` (
  671.   `id` mediumint unsigned NOT NULL AUTO_INCREMENT,
  672.   `title` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,
  673.   `date_created` datetime NOT NULL,
  674.   `date_updated` datetime DEFAULT NULL,
  675.   `is_active` tinyint(1) NOT NULL DEFAULT '1',
  676.   `is_trash` tinyint(1) NOT NULL DEFAULT '0',
  677.   PRIMARY KEY (`id`)
  678. ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
  679. /*!40101 SET character_set_client = @saved_cs_client */;
  680.  
  681. --
  682. -- Dumping data for table `wp_gf_form`
  683. --
  684.  
  685. LOCK TABLES `wp_gf_form` WRITE;
  686. /*!40000 ALTER TABLE `wp_gf_form` DISABLE KEYS */;
  687. /*!40000 ALTER TABLE `wp_gf_form` ENABLE KEYS */;
  688. UNLOCK TABLES;
  689.  
  690. --
  691. -- Table structure for table `wp_gf_form_meta`
  692. --
  693.  
  694. DROP TABLE IF EXISTS `wp_gf_form_meta`;
  695. /*!40101 SET @saved_cs_client     = @@character_set_client */;
  696. /*!50503 SET character_set_client = utf8mb4 */;
  697. CREATE TABLE `wp_gf_form_meta` (
  698.   `form_id` mediumint unsigned NOT NULL,
  699.   `display_meta` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci,
  700.   `entries_grid_meta` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci,
  701.   `confirmations` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci,
  702.   `notifications` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci,
  703.   PRIMARY KEY (`form_id`)
  704. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
  705. /*!40101 SET character_set_client = @saved_cs_client */;
  706.  
  707. --
  708. -- Dumping data for table `wp_gf_form_meta`
  709. --
  710.  
  711. LOCK TABLES `wp_gf_form_meta` WRITE;
  712. /*!40000 ALTER TABLE `wp_gf_form_meta` DISABLE KEYS */;
  713. /*!40000 ALTER TABLE `wp_gf_form_meta` ENABLE KEYS */;
  714. UNLOCK TABLES;
  715.  
  716. --
  717. -- Table structure for table `wp_gf_form_revisions`
  718. --
  719.  
  720. DROP TABLE IF EXISTS `wp_gf_form_revisions`;
  721. /*!40101 SET @saved_cs_client     = @@character_set_client */;
  722. /*!50503 SET character_set_client = utf8mb4 */;
  723. CREATE TABLE `wp_gf_form_revisions` (
  724.   `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  725.   `form_id` mediumint unsigned NOT NULL,
  726.   `display_meta` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci,
  727.   `date_created` datetime NOT NULL,
  728.   PRIMARY KEY (`id`),
  729.   KEY `date_created` (`date_created`),
  730.   KEY `form_id` (`form_id`)
  731. ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
  732. /*!40101 SET character_set_client = @saved_cs_client */;
  733.  
  734. --
  735. -- Dumping data for table `wp_gf_form_revisions`
  736. --
  737.  
  738. LOCK TABLES `wp_gf_form_revisions` WRITE;
  739. /*!40000 ALTER TABLE `wp_gf_form_revisions` DISABLE KEYS */;
  740. /*!40000 ALTER TABLE `wp_gf_form_revisions` ENABLE KEYS */;
  741. UNLOCK TABLES;
  742.  
  743. --
  744. -- Table structure for table `wp_gf_form_view`
  745. --
  746.  
  747. DROP TABLE IF EXISTS `wp_gf_form_view`;
  748. /*!40101 SET @saved_cs_client     = @@character_set_client */;
  749. /*!50503 SET character_set_client = utf8mb4 */;
  750. CREATE TABLE `wp_gf_form_view` (
  751.   `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  752.   `form_id` mediumint unsigned NOT NULL,
  753.   `date_created` datetime NOT NULL,
  754.   `ip` char(15) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  755.   `count` mediumint unsigned NOT NULL DEFAULT '1',
  756.   PRIMARY KEY (`id`),
  757.   KEY `date_created` (`date_created`),
  758.   KEY `form_id` (`form_id`)
  759. ) ENGINE=InnoDB AUTO_INCREMENT=116 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
  760. /*!40101 SET character_set_client = @saved_cs_client */;
  761.  
  762. --
  763. -- Dumping data for table `wp_gf_form_view`
  764. --
  765.  
  766. LOCK TABLES `wp_gf_form_view` WRITE;
  767. /*!40000 ALTER TABLE `wp_gf_form_view` DISABLE KEYS */;
  768. /*!40000 ALTER TABLE `wp_gf_form_view` ENABLE KEYS */;
  769. UNLOCK TABLES;
  770.  
  771. --
  772. -- Table structure for table `wp_oses_clicks`
  773. --
  774.  
  775. DROP TABLE IF EXISTS `wp_oses_clicks`;
  776. /*!40101 SET @saved_cs_client     = @@character_set_client */;
  777. /*!50503 SET character_set_client = utf8mb4 */;
  778. CREATE TABLE `wp_oses_clicks` (
  779.   `email_click_id` bigint NOT NULL AUTO_INCREMENT,
  780.   `email_id` bigint NOT NULL,
  781.   `email_click_url` varchar(255) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  782.   `email_click_count` int DEFAULT '0',
  783.   `email_first_click_date` datetime DEFAULT NULL,
  784.   `email_last_click_date` datetime DEFAULT NULL,
  785.   PRIMARY KEY (`email_click_id`),
  786.   KEY `email_id` (`email_id`)
  787. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
  788. /*!40101 SET character_set_client = @saved_cs_client */;
  789.  
  790. --
  791. -- Dumping data for table `wp_oses_clicks`
  792. --
  793.  
  794. LOCK TABLES `wp_oses_clicks` WRITE;
  795. /*!40000 ALTER TABLE `wp_oses_clicks` DISABLE KEYS */;
  796. /*!40000 ALTER TABLE `wp_oses_clicks` ENABLE KEYS */;
  797. UNLOCK TABLES;
  798.  
  799. --
  800. -- Table structure for table `wp_oses_emails`
  801. --
  802.  
  803. DROP TABLE IF EXISTS `wp_oses_emails`;
  804. /*!40101 SET @saved_cs_client     = @@character_set_client */;
  805. /*!50503 SET character_set_client = utf8mb4 */;
  806. CREATE TABLE `wp_oses_emails` (
  807.   `email_id` bigint NOT NULL AUTO_INCREMENT,
  808.   `subsite_id` bigint DEFAULT NULL,
  809.   `email_to` text COLLATE utf8mb4_unicode_520_ci NOT NULL,
  810.   `email_subject` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  811.   `email_message` longtext COLLATE utf8mb4_unicode_520_ci NOT NULL,
  812.   `email_headers` longtext COLLATE utf8mb4_unicode_520_ci NOT NULL,
  813.   `email_attachments` longtext COLLATE utf8mb4_unicode_520_ci NOT NULL,
  814.   `email_status` varchar(20) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  815.   `email_open_count` int DEFAULT '0',
  816.   `email_first_open_date` datetime DEFAULT NULL,
  817.   `email_last_open_date` datetime DEFAULT NULL,
  818.   `email_created` datetime NOT NULL,
  819.   `email_sent` datetime DEFAULT NULL,
  820.   `email_parent` bigint DEFAULT NULL,
  821.   `auto_retries` int DEFAULT '0',
  822.   `manual_retries` int DEFAULT '0',
  823.   PRIMARY KEY (`email_id`),
  824.   KEY `email_subject` (`email_subject`)
  825. ) ENGINE=InnoDB AUTO_INCREMENT=65 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
  826. /*!40101 SET character_set_client = @saved_cs_client */;
  827.  
  828. --
  829. -- Dumping data for table `wp_oses_emails`
  830. --
  831.  
  832. LOCK TABLES `wp_oses_emails` WRITE;
  833. /*!40000 ALTER TABLE `wp_oses_emails` DISABLE KEYS */;
  834. /*!40000 ALTER TABLE `wp_oses_emails` ENABLE KEYS */;
  835. UNLOCK TABLES;
  836.  
  837.  
  838.  
  839. --
  840. -- Table structure for table `wp_w3tc_cdn_pathmap`
  841. --
  842.  
  843. DROP TABLE IF EXISTS `wp_w3tc_cdn_pathmap`;
  844. /*!40101 SET @saved_cs_client     = @@character_set_client */;
  845. /*!50503 SET character_set_client = utf8mb4 */;
  846. CREATE TABLE `wp_w3tc_cdn_pathmap` (
  847.   `path` text COLLATE utf8mb4_unicode_520_ci NOT NULL,
  848.   `path_hash` varchar(32) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL,
  849.   `type` tinyint(1) NOT NULL DEFAULT '0',
  850.   `remote_id` varchar(200) CHARACTER SET ascii COLLATE ascii_general_ci DEFAULT NULL,
  851.   PRIMARY KEY (`path_hash`),
  852.   KEY `remote_id` (`remote_id`)
  853. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
  854. /*!40101 SET character_set_client = @saved_cs_client */;
  855.  
  856. --
  857. -- Dumping data for table `wp_w3tc_cdn_pathmap`
  858. --
  859.  
  860. LOCK TABLES `wp_w3tc_cdn_pathmap` WRITE;
  861. /*!40000 ALTER TABLE `wp_w3tc_cdn_pathmap` DISABLE KEYS */;
  862. /*!40000 ALTER TABLE `wp_w3tc_cdn_pathmap` ENABLE KEYS */;
  863. UNLOCK TABLES;
  864.  
  865. --
  866. -- Table structure for table `wp_w3tc_cdn_queue`
  867. --
  868.  
  869. DROP TABLE IF EXISTS `wp_w3tc_cdn_queue`;
  870. /*!40101 SET @saved_cs_client     = @@character_set_client */;
  871. /*!50503 SET character_set_client = utf8mb4 */;
  872. CREATE TABLE `wp_w3tc_cdn_queue` (
  873.   `id` int unsigned NOT NULL AUTO_INCREMENT,
  874.   `local_path` varchar(500) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  875.   `remote_path` varchar(500) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  876.   `command` tinyint unsigned NOT NULL DEFAULT '0' COMMENT '1 - Upload, 2 - Delete, 3 - Purge',
  877.   `last_error` varchar(150) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  878.   `date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  879.   PRIMARY KEY (`id`),
  880.   KEY `date` (`date`)
  881. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
  882. /*!40101 SET character_set_client = @saved_cs_client */;
  883.  
  884. --
  885. -- Dumping data for table `wp_w3tc_cdn_queue`
  886. --
  887.  
  888. LOCK TABLES `wp_w3tc_cdn_queue` WRITE;
  889. /*!40000 ALTER TABLE `wp_w3tc_cdn_queue` DISABLE KEYS */;
  890. /*!40000 ALTER TABLE `wp_w3tc_cdn_queue` ENABLE KEYS */;
  891. UNLOCK TABLES;
  892.  
  893.  
  894. --
  895. -- Dumping data for table `wp_yoast_seo_meta`
  896. --
  897.  
  898. LOCK TABLES `wp_yoast_seo_meta` WRITE;
  899. /*!40000 ALTER TABLE `wp_yoast_seo_meta` DISABLE KEYS */;
  900. /*!40000 ALTER TABLE `wp_yoast_seo_meta` ENABLE KEYS */;
  901. UNLOCK TABLES;
  902. /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
  903.  
  904. /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
  905. /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
  906. /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
  907. /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
  908. /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
  909. /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
  910. /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
  911.  
  912. -- Dump completed on 2020-02-14  8:35:13
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement