--
-- Host: localhost    Database: icreated_snippets
-- ------------------------------------------------------


--
-- Table structure for table `wp_commentmeta`
--

CREATE TABLE `wp_commentmeta` (
  `meta_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `comment_id` bigint(20) unsigned NOT NULL DEFAULT '0',
  `meta_key` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `meta_value` longtext COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`meta_id`),
  KEY `comment_id` (`comment_id`),
  KEY `meta_key` (`meta_key`(191))
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `wp_commentmeta`
--


--
-- Table structure for table `wp_comments`
--

CREATE TABLE `wp_comments` (
  `comment_ID` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `comment_post_ID` bigint(20) unsigned NOT NULL DEFAULT '0',
  `comment_author` tinytext COLLATE utf8mb4_unicode_ci NOT NULL,
  `comment_author_email` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `comment_author_url` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `comment_author_IP` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `comment_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `comment_date_gmt` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `comment_content` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `comment_karma` int(11) NOT NULL DEFAULT '0',
  `comment_approved` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '1',
  `comment_agent` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `comment_type` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `comment_parent` bigint(20) unsigned NOT NULL DEFAULT '0',
  `user_id` bigint(20) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`comment_ID`),
  KEY `comment_post_ID` (`comment_post_ID`),
  KEY `comment_approved_date_gmt` (`comment_approved`,`comment_date_gmt`),
  KEY `comment_date_gmt` (`comment_date_gmt`),
  KEY `comment_parent` (`comment_parent`),
  KEY `comment_author_email` (`comment_author_email`(10))
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `wp_comments`
--

INSERT INTO `wp_comments` (`comment_ID`, `comment_post_ID`, `comment_author`, `comment_author_email`, `comment_author_url`, `comment_author_IP`, `comment_date`, `comment_date_gmt`, `comment_content`, `comment_karma`, `comment_approved`, `comment_agent`, `comment_type`, `comment_parent`, `user_id`) VALUES (1,1,'Mr WordPress','','https://wordpress.org/','','2016-07-25 23:48:18','2016-07-25 23:48:18','Hi, this is a comment.\nTo delete a comment, just log in and view the post&#039;s comments. There you will have the option to edit or delete them.',0,'1','','',0,0);

--
-- Table structure for table `wp_facetwp_index`
--

CREATE TABLE `wp_facetwp_index` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `post_id` int(10) unsigned DEFAULT NULL,
  `facet_name` varchar(255) DEFAULT NULL,
  `facet_source` varchar(255) DEFAULT NULL,
  `facet_value` text,
  `facet_display_value` text,
  `term_id` int(10) unsigned DEFAULT '0',
  `parent_id` int(10) unsigned DEFAULT '0',
  `depth` int(10) unsigned DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `facet_name_idx` (`facet_name`),
  KEY `facet_source_idx` (`facet_source`)
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wp_facetwp_index`
--

INSERT INTO `wp_facetwp_index` (`id`, `post_id`, `facet_name`, `facet_source`, `facet_value`, `facet_display_value`, `term_id`, `parent_id`, `depth`) VALUES (1,12,'cat','tax/snippet-category','php','PHP',4,0,0),(2,10,'cat','tax/snippet-category','forms','Forms',7,4,1),(3,8,'cat','tax/snippet-category','seo','SEO',6,4,1),(4,8,'cat','tax/snippet-category','tinymce','TinyMCE',5,4,1),(5,6,'cat','tax/snippet-category','php','PHP',4,0,0),(6,4,'cat','tax/snippet-category','css','CSS',2,0,0),(7,4,'cat','tax/snippet-category','navigation','Navigation',3,2,1);

--
-- Table structure for table `wp_links`
--

CREATE TABLE `wp_links` (
  `link_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `link_url` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `link_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `link_image` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `link_target` varchar(25) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `link_description` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `link_visible` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Y',
  `link_owner` bigint(20) unsigned NOT NULL DEFAULT '1',
  `link_rating` int(11) NOT NULL DEFAULT '0',
  `link_updated` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `link_rel` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `link_notes` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `link_rss` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`link_id`),
  KEY `link_visible` (`link_visible`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `wp_links`
--


--
-- Table structure for table `wp_options`
--

CREATE TABLE `wp_options` (
  `option_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `option_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `option_value` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `autoload` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'yes',
  PRIMARY KEY (`option_id`),
  UNIQUE KEY `option_name` (`option_name`),
  KEY `autoload` (`autoload`)
) ENGINE=MyISAM AUTO_INCREMENT=3977 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `wp_options`
--



--
-- Table structure for table `wp_postmeta`
--

CREATE TABLE `wp_postmeta` (
  `meta_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `post_id` bigint(20) unsigned NOT NULL DEFAULT '0',
  `meta_key` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `meta_value` longtext COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`meta_id`),
  KEY `post_id` (`post_id`),
  KEY `meta_key` (`meta_key`(191))
) ENGINE=MyISAM AUTO_INCREMENT=79 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `wp_postmeta`
--

INSERT INTO `wp_postmeta` (`meta_id`, `post_id`, `meta_key`, `meta_value`) VALUES (1,2,'_wp_page_template','default'),(2,4,'_edit_last','1'),(3,4,'_edit_lock','1574817855:1'),(4,4,'_syntaxhighlighter_encoded','1'),(5,6,'_edit_last','1'),(6,6,'_edit_lock','1469501247:1'),(7,6,'_syntaxhighlighter_encoded','1'),(8,8,'_edit_last','1'),(9,8,'_edit_lock','1469501181:1'),(10,10,'_edit_last','1'),(11,10,'_edit_lock','1476687522:1'),(12,10,'_syntaxhighlighter_encoded','1'),(13,12,'_edit_last','1'),(14,12,'_edit_lock','1572242555:1'),(15,12,'_syntaxhighlighter_encoded','1'),(16,2,'_edit_lock','1469506984:1'),(17,2,'_edit_last','1'),(18,16,'_edit_last','1'),(19,16,'_edit_lock','1469506986:1'),(20,16,'_search-filter-fields','a:2:{i:0;a:3:{s:4:\"type\";s:6:\"search\";s:7:\"heading\";s:0:\"\";s:11:\"placeholder\";s:10:\"Search …\";}i:1;a:16:{s:4:\"type\";s:8:\"taxonomy\";s:10:\"input_type\";s:8:\"checkbox\";s:7:\"heading\";s:0:\"\";s:15:\"all_items_label\";s:0:\"\";s:10:\"show_count\";i:1;s:10:\"hide_empty\";i:0;s:12:\"hierarchical\";i:1;s:16:\"include_children\";i:1;s:10:\"drill_down\";i:0;s:20:\"sync_include_exclude\";i:1;s:9:\"combo_box\";i:0;s:8:\"operator\";s:2:\"or\";s:8:\"order_by\";s:7:\"default\";s:9:\"order_dir\";s:3:\"asc\";s:11:\"exclude_ids\";s:0:\"\";s:13:\"taxonomy_name\";s:16:\"snippet-category\";}}'),(21,16,'_search-filter-settings','a:27:{s:26:\"use_template_manual_toggle\";i:0;s:17:\"enable_auto_count\";i:1;s:25:\"auto_count_deselect_emtpy\";i:0;s:20:\"template_name_manual\";s:10:\"search.php\";s:9:\"page_slug\";s:6:\"search\";s:10:\"post_types\";a:1:{s:7:\"snippet\";i:1;}s:11:\"post_status\";a:1:{s:7:\"publish\";i:1;}s:13:\"scroll_to_pos\";s:1:\"0\";s:16:\"custom_scroll_to\";s:0:\"\";s:16:\"scroll_on_action\";s:3:\"all\";s:14:\"maintain_state\";i:1;s:27:\"treat_child_posts_as_parent\";i:0;s:11:\"auto_submit\";i:1;s:18:\"display_results_as\";s:7:\"archive\";s:15:\"update_ajax_url\";i:1;s:17:\"only_results_ajax\";i:1;s:11:\"ajax_target\";s:8:\"#content\";s:11:\"results_url\";s:0:\"\";s:19:\"ajax_links_selector\";s:13:\".pagination a\";s:16:\"results_per_page\";i:10;s:16:\"exclude_post_ids\";s:0:\"\";s:14:\"field_relation\";s:3:\"and\";s:15:\"default_sort_by\";s:1:\"0\";s:16:\"default_sort_dir\";s:4:\"desc\";s:16:\"default_meta_key\";s:10:\"_edit_last\";s:17:\"default_sort_type\";s:7:\"numeric\";s:19:\"taxonomies_settings\";a:5:{s:8:\"category\";a:2:{s:15:\"include_exclude\";s:7:\"include\";s:3:\"ids\";s:0:\"\";}s:8:\"post_tag\";a:2:{s:15:\"include_exclude\";s:7:\"include\";s:3:\"ids\";s:0:\"\";}s:11:\"post_format\";a:2:{s:15:\"include_exclude\";s:7:\"include\";s:3:\"ids\";s:0:\"\";}s:16:\"snippet-category\";a:2:{s:15:\"include_exclude\";s:7:\"include\";s:3:\"ids\";s:0:\"\";}s:11:\"snippet-tag\";a:2:{s:15:\"include_exclude\";s:7:\"include\";s:3:\"ids\";s:0:\"\";}}}'),(22,31,'_edit_last','1'),(23,31,'_edit_lock','1470094842:1'),(24,34,'_edit_last','1'),(25,34,'_edit_lock','1572242566:1'),(26,38,'_edit_last','1'),(27,38,'_edit_lock','1641795538:1'),(28,44,'_edit_last','1'),(29,44,'_edit_lock','1472174012:1'),(30,49,'_edit_last','1'),(31,49,'_edit_lock','1473829762:1'),(32,51,'_edit_last','1'),(33,51,'_edit_lock','1474334298:1'),(34,54,'_edit_last','1'),(35,54,'_edit_lock','1572242711:1'),(36,59,'_edit_last','1'),(37,59,'_edit_lock','1477024999:1'),(38,60,'_edit_last','1'),(39,60,'_edit_lock','1598424421:1'),(40,62,'_edit_last','1'),(41,62,'_edit_lock','1548138738:1'),(42,65,'_edit_last','1'),(43,65,'_edit_lock','1590557405:1'),(44,69,'_edit_last','1'),(45,69,'_edit_lock','1569461251:1'),(46,72,'_edit_last','1'),(47,72,'_edit_lock','1499406246:1'),(48,76,'_edit_last','1'),(49,76,'_edit_lock','1501481101:1'),(50,82,'_edit_last','1'),(51,82,'_edit_lock','1550189749:1'),(52,86,'_edit_last','1'),(53,86,'_edit_lock','1625184640:1'),(54,90,'_edit_last','1'),(55,90,'_edit_lock','1567486044:1'),(56,92,'_edit_last','1'),(57,92,'_edit_lock','1505976519:1'),(58,97,'_edit_last','1'),(59,97,'_edit_lock','1531438908:1'),(60,102,'_edit_last','1'),(61,102,'_edit_lock','1523598381:1'),(62,106,'_edit_last','1'),(63,106,'_edit_lock','1548138799:1'),(64,109,'_edit_last','1'),(65,109,'_edit_lock','1562914141:1'),(66,113,'_edit_last','1'),(67,113,'_edit_lock','1531438596:1'),(68,118,'_oembed_b94a6349722160b47f518f883e8800d3','{{unknown}}'),(69,118,'_edit_last','1'),(70,118,'_edit_lock','1620953305:1'),(71,121,'_edit_last','1'),(72,121,'_edit_lock','1535525153:1'),(73,124,'_edit_last','1'),(74,124,'_edit_lock','1539043786:1'),(75,126,'_edit_last','1'),(76,126,'_edit_lock','1548197387:1'),(77,131,'_edit_last','1'),(78,131,'_edit_lock','1584419124:1');

--
-- Table structure for table `wp_search_filter_cache`
--

CREATE TABLE `wp_search_filter_cache` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `post_id` bigint(20) NOT NULL,
  `post_parent_id` bigint(20) NOT NULL,
  `field_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `field_value` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `field_value_num` bigint(20) DEFAULT NULL,
  `field_parent_num` bigint(20) DEFAULT NULL,
  `term_parent_id` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `field_name_index` (`field_name`(250)),
  KEY `field_value_index` (`field_value`(250)),
  KEY `field_value_num_index` (`field_value_num`)
) ENGINE=MyISAM AUTO_INCREMENT=153 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `wp_search_filter_cache`
--

INSERT INTO `wp_search_filter_cache` (`id`, `post_id`, `post_parent_id`, `field_name`, `field_value`, `field_value_num`, `field_parent_num`, `term_parent_id`) VALUES (8,12,0,'_sft_snippet-category','',4,NULL,0),(53,10,0,'_sft_snippet-tag','',8,NULL,0),(11,8,0,'_sft_snippet-category','',6,NULL,4),(12,8,0,'_sft_snippet-category','',5,NULL,4),(13,6,0,'_sft_snippet-category','',4,NULL,0),(16,4,0,'_sft_snippet-category','',2,NULL,0),(17,4,0,'_sft_snippet-category','',3,NULL,2),(22,31,0,'_sft_snippet-category','',4,NULL,0),(25,34,0,'_sft_snippet-category','',4,NULL,0),(37,44,0,'_sft_snippet-category','',3,NULL,2),(36,44,0,'_sft_snippet-category','',2,NULL,0),(43,49,0,'_sft_snippet-category','',4,NULL,0),(42,49,0,'_sft_snippet-category','',2,NULL,0),(46,51,0,'_sft_snippet-category','',11,NULL,0),(49,54,0,'_sft_snippet-category','',4,NULL,0),(52,10,0,'_sft_snippet-category','',7,NULL,4),(56,60,0,'_sft_snippet-category','',12,NULL,0),(59,62,0,'_sft_snippet-category','',9,NULL,0),(63,65,0,'','',NULL,NULL,NULL),(67,69,0,'','',NULL,NULL,NULL),(70,72,0,'_sft_snippet-category','',4,NULL,0),(71,75,0,'','',NULL,NULL,NULL),(75,76,0,'_sft_snippet-category','',4,NULL,0),(76,80,0,'','',NULL,NULL,NULL),(77,81,0,'','',NULL,NULL,NULL),(144,82,0,'','',NULL,NULL,NULL),(149,86,0,'_sft_snippet-category','',13,NULL,0),(148,86,0,'_sft_snippet-category','',15,NULL,0),(89,89,0,'','',NULL,NULL,NULL),(92,90,0,'_sft_snippet-category','',4,NULL,0),(97,92,0,'_sft_snippet-category','',14,NULL,0),(100,97,0,'','',NULL,NULL,NULL),(101,101,0,'','',NULL,NULL,NULL),(105,102,0,'','',NULL,NULL,NULL),(120,106,0,'_sft_snippet-category','',9,NULL,0),(119,106,0,'_sft_snippet-category','',14,NULL,0),(118,106,0,'_sft_snippet-category','',2,NULL,0),(116,109,0,'_sft_snippet-category','',14,NULL,0),(117,109,0,'_sft_snippet-category','',9,NULL,0),(128,113,0,'_sft_snippet-category','',4,NULL,0),(131,118,0,'_sft_snippet-category','',7,NULL,4),(132,118,0,'_sft_snippet-category','',14,NULL,0),(135,121,0,'_sft_snippet-category','',9,NULL,0),(137,124,0,'','',NULL,NULL,NULL),(143,126,0,'_sft_snippet-category','',2,NULL,0),(147,131,0,'_sft_snippet-category','',14,NULL,0),(150,86,0,'_sft_snippet-category','',14,NULL,0),(152,38,0,'_sft_snippet-category','',10,NULL,9);

--
-- Table structure for table `wp_search_filter_term_results`
--

CREATE TABLE `wp_search_filter_term_results` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `field_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `field_value` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `field_value_num` bigint(20) DEFAULT NULL,
  `result_ids` text COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  KEY `field_name_index` (`field_name`(250)),
  KEY `field_value_index` (`field_value`(250)),
  KEY `field_value_num_index` (`field_value`(250))
) ENGINE=MyISAM AUTO_INCREMENT=60 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `wp_search_filter_term_results`
--

INSERT INTO `wp_search_filter_term_results` (`id`, `field_name`, `field_value`, `field_value_num`, `result_ids`) VALUES (55,'_sft_snippet-category','2',NULL,'4,44,49,106,126'),(48,'_sft_snippet-category','4',NULL,'12,6,31,34,49,54,72,76,90,113'),(3,'_sft_snippet-category','5',NULL,'8'),(4,'_sft_snippet-category','6',NULL,'8'),(11,'_sft_snippet-category','10',NULL,'38'),(15,'_sft_snippet-category','3',NULL,'4,44'),(20,'_sft_snippet-category','11',NULL,'51'),(25,'_sft_snippet-tag','8',NULL,'10'),(26,'_sft_snippet-category','12',NULL,'60'),(58,'_sft_snippet-category','13',NULL,'86'),(51,'_sft_snippet-category','9',NULL,'62,106,109,121'),(52,'_sft_snippet-category','7',NULL,'10,118'),(57,'_sft_snippet-category','14',NULL,'92,106,109,118,131,86'),(59,'_sft_snippet-category','15',NULL,'86');

--
-- Table structure for table `wp_term_relationships`
--

CREATE TABLE `wp_term_relationships` (
  `object_id` bigint(20) unsigned NOT NULL DEFAULT '0',
  `term_taxonomy_id` bigint(20) unsigned NOT NULL DEFAULT '0',
  `term_order` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`object_id`,`term_taxonomy_id`),
  KEY `term_taxonomy_id` (`term_taxonomy_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `wp_term_relationships`
--

INSERT INTO `wp_term_relationships` (`object_id`, `term_taxonomy_id`, `term_order`) VALUES (1,1,0),(4,2,0),(4,3,0),(6,4,0),(8,5,0),(8,6,0),(10,7,0),(10,8,0),(12,4,0),(31,4,0),(34,4,0),(38,10,0),(44,2,0),(44,3,0),(49,2,0),(49,4,0),(51,11,0),(54,4,0),(59,1,0),(60,12,0),(62,9,0),(72,4,0),(76,4,0),(86,13,0),(126,2,0),(90,4,0),(92,14,0),(106,2,0),(106,14,0),(106,9,0),(109,14,0),(109,9,0),(113,4,0),(118,14,0),(118,7,0),(121,9,0),(86,14,0),(131,14,0),(86,15,0);

--
-- Table structure for table `wp_term_taxonomy`
--

CREATE TABLE `wp_term_taxonomy` (
  `term_taxonomy_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `term_id` bigint(20) unsigned NOT NULL DEFAULT '0',
  `taxonomy` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `description` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `parent` bigint(20) unsigned NOT NULL DEFAULT '0',
  `count` bigint(20) NOT NULL DEFAULT '0',
  PRIMARY KEY (`term_taxonomy_id`),
  UNIQUE KEY `term_id_taxonomy` (`term_id`,`taxonomy`),
  KEY `taxonomy` (`taxonomy`)
) ENGINE=MyISAM AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `wp_term_taxonomy`
--

INSERT INTO `wp_term_taxonomy` (`term_taxonomy_id`, `term_id`, `taxonomy`, `description`, `parent`, `count`) VALUES (1,1,'category','',0,1),(2,2,'snippet-category','',0,5),(3,3,'snippet-category','',2,2),(4,4,'snippet-category','',0,10),(5,5,'snippet-category','',4,1),(6,6,'snippet-category','',4,1),(7,7,'snippet-category','',4,2),(8,8,'snippet-tag','',0,1),(9,9,'snippet-category','',0,4),(10,10,'snippet-category','',9,1),(11,11,'snippet-category','',0,1),(12,12,'snippet-category','',0,1),(13,13,'snippet-category','',0,1),(14,14,'snippet-category','',0,6),(15,15,'snippet-category','',0,1);

--
-- Table structure for table `wp_termmeta`
--

CREATE TABLE `wp_termmeta` (
  `meta_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `term_id` bigint(20) unsigned NOT NULL DEFAULT '0',
  `meta_key` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `meta_value` longtext COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`meta_id`),
  KEY `term_id` (`term_id`),
  KEY `meta_key` (`meta_key`(191))
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `wp_termmeta`
--


--
-- Table structure for table `wp_terms`
--

CREATE TABLE `wp_terms` (
  `term_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `slug` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `term_group` bigint(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`term_id`),
  KEY `slug` (`slug`(191)),
  KEY `name` (`name`(191))
) ENGINE=MyISAM AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `wp_terms`
--

INSERT INTO `wp_terms` (`term_id`, `name`, `slug`, `term_group`) VALUES (1,'Uncategorized','uncategorized',0),(2,'CSS','css',0),(3,'Navigation','navigation',0),(4,'PHP','php',0),(5,'TinyMCE','tinymce',0),(6,'SEO','seo',0),(7,'Forms','forms',0),(8,'gravity forms','gravity-forms',0),(9,'Javascript','javascript',0),(10,'SEO','seo-javascript',0),(11,'Page Header','page-header',0),(12,'Admin','admin',0),(13,'Bricks','bricks',0),(14,'Gravity Forms','gravity-forms',0),(15,'ACF','acf',0);

--
-- Table structure for table `wp_usermeta`
--

CREATE TABLE `wp_usermeta` (
  `umeta_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) unsigned NOT NULL DEFAULT '0',
  `meta_key` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `meta_value` longtext COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`umeta_id`),
  KEY `user_id` (`user_id`),
  KEY `meta_key` (`meta_key`(191))
) ENGINE=MyISAM AUTO_INCREMENT=23 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `wp_usermeta`
--

INSERT INTO `wp_usermeta` (`umeta_id`, `user_id`, `meta_key`, `meta_value`) VALUES (1,1,'nickname','icreate'),(2,1,'first_name',''),(3,1,'last_name',''),(4,1,'description',''),(5,1,'rich_editing','true'),(6,1,'comment_shortcuts','false'),(7,1,'admin_color','fresh'),(8,1,'use_ssl','0'),(9,1,'show_admin_bar_front','true'),(10,1,'wp_capabilities','a:1:{s:13:\"administrator\";b:1;}'),(11,1,'wp_user_level','10'),(12,1,'dismissed_wp_pointers',''),(13,1,'show_welcome_panel','0'),(14,1,'session_tokens','a:1:{s:64:\"36e91aaa61622e4af151e5a8a17adb388f5039da4a614a04198e51b7b992ee1d\";a:4:{s:10:\"expiration\";i:1641958960;s:2:\"ip\";s:15:\"180.150.105.207\";s:2:\"ua\";s:115:\"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/96.0.4664.110 Safari/537.36\";s:5:\"login\";i:1641786160;}}'),(15,1,'wp_dashboard_quick_press_last_post_id','155'),(16,1,'wp_user-settings','hidetb=1&editor=tinymce&posts_list_mode=list'),(17,1,'wp_user-settings-time','1562555046'),(18,1,'search-filter-show-welcome-notice','1'),(20,1,'metaboxhidden_snippet','a:1:{i:0;s:7:\"slugdiv\";}'),(19,1,'closedpostboxes_snippet','a:0:{}'),(21,1,'community-events-location','a:1:{s:2:\"ip\";s:13:\"180.150.105.0\";}'),(22,1,'edit_snippet_per_page','40');

--
-- Dumping routines for database 'icreated_snippets'
--


