File: /home/undanet/dump/db/portalempleo_wp_des_wp_usermeta.sql
CREATE DATABASE IF NOT EXISTS `portalempleo_wp_des` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci */ /*!80016 DEFAULT ENCRYPTION='N' */;
USE `portalempleo_wp_des`;
-- MySQL dump 10.13 Distrib 8.0.22, for Win64 (x86_64)
--
-- Host: SRVDESARROLLO Database: portalempleo_wp_des
-- ------------------------------------------------------
-- Server version 8.0.23
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!50503 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
--
-- Table structure for table `wp_usermeta`
--
DROP TABLE IF EXISTS `wp_usermeta`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `wp_usermeta` (
`umeta_id` bigint unsigned NOT NULL AUTO_INCREMENT,
`user_id` bigint unsigned NOT NULL DEFAULT '0',
`meta_key` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`meta_value` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
PRIMARY KEY (`umeta_id`),
KEY `user_id` (`user_id`),
KEY `meta_key` (`meta_key`(191))
) ENGINE=InnoDB AUTO_INCREMENT=2296 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `wp_usermeta`
--
LOCK TABLES `wp_usermeta` WRITE;
/*!40000 ALTER TABLE `wp_usermeta` DISABLE KEYS */;
INSERT INTO `wp_usermeta` VALUES (1,1,'nickname','root'),(2,1,'first_name','Admin'),(3,1,'last_name','Portal Empleo'),(4,1,'description',''),(5,1,'rich_editing','true'),(6,1,'syntax_highlighting','true'),(7,1,'comment_shortcuts','false'),(8,1,'admin_color','fresh'),(9,1,'use_ssl','0'),(10,1,'show_admin_bar_front','true'),(11,1,'locale',''),(12,1,'wp_capabilities','a:1:{s:13:\"administrator\";b:1;}'),(13,1,'wp_user_level','10'),(15,1,'show_welcome_panel','1'),(17,1,'wp_dashboard_quick_press_last_post_id','395'),(18,1,'nav_menu_recently_edited','3'),(19,1,'managenav-menuscolumnshidden','a:5:{i:0;s:11:\"link-target\";i:1;s:11:\"css-classes\";i:2;s:3:\"xfn\";i:3;s:11:\"description\";i:4;s:15:\"title-attribute\";}'),(20,1,'metaboxhidden_nav-menus','a:2:{i:0;s:12:\"add-post_tag\";i:1;s:15:\"add-post_format\";}'),(21,1,'wp_user-settings','libraryContent=browse&posts_list_mode=excerpt&editor=tinymce'),(22,1,'wp_user-settings-time','1611309177'),(23,1,'pll_filter_content',''),(24,1,'closedpostboxes_post','a:0:{}'),(25,1,'metaboxhidden_post','a:0:{}'),(26,1,'edit_post_per_page','20'),(27,1,'wp_managetoplevel_page_snippetscolumnshidden','a:1:{i:0;s:2:\"id\";}'),(28,1,'wpforms_dismissed','a:1:{s:15:\"lite-notice-bar\";i:1607087817;}'),(29,1,'account_status','approved'),(30,1,'um_member_directory_data','a:5:{s:14:\"account_status\";s:8:\"approved\";s:15:\"hide_in_members\";b:0;s:13:\"profile_photo\";b:1;s:11:\"cover_photo\";b:0;s:8:\"verified\";b:0;}'),(32,1,'_um_last_login','1620295934'),(33,1,'um_user_profile_url_slug_user_login','root'),(34,1,'um_account_secure_fields','a:4:{s:7:\"general\";a:4:{i:0;s:10:\"user_login\";i:1;s:10:\"first_name\";i:2;s:9:\"last_name\";i:3;s:10:\"user_email\";}s:8:\"password\";a:1:{i:0;s:13:\"user_password\";}s:7:\"privacy\";a:3:{i:0;s:15:\"profile_privacy\";i:1;s:15:\"profile_noindex\";i:2;s:15:\"hide_in_members\";}s:6:\"delete\";a:1:{i:0;s:20:\"single_user_password\";}}'),(46,1,'meta-box-order_page','a:3:{s:4:\"side\";s:32:\"um-admin-restrict-content,ml_box\";s:6:\"normal\";s:0:\"\";s:8:\"advanced\";s:0:\"\";}'),(77,2,'um_member_directory_data','a:5:{s:14:\"account_status\";s:8:\"approved\";s:15:\"hide_in_members\";b:0;s:13:\"profile_photo\";b:0;s:11:\"cover_photo\";b:0;s:8:\"verified\";b:0;}'),(108,1,'closedpostboxes_page','a:0:{}'),(109,1,'metaboxhidden_page','a:0:{}'),(110,4,'nickname','Marisol'),(111,4,'first_name',''),(112,4,'last_name',''),(113,4,'description',''),(114,4,'rich_editing','true'),(115,4,'syntax_highlighting','true'),(116,4,'comment_shortcuts','false'),(117,4,'admin_color','fresh'),(118,4,'use_ssl','0'),(119,4,'show_admin_bar_front','true'),(120,4,'locale',''),(121,4,'wp_capabilities','a:1:{s:6:\"editor\";b:1;}'),(122,4,'wp_user_level','7'),(123,4,'synced_gravatar_hashed_id','9de33fb06cc53c550d4404c3a195deb7'),(124,4,'um_member_directory_data','a:5:{s:14:\"account_status\";s:8:\"approved\";s:15:\"hide_in_members\";b:0;s:13:\"profile_photo\";b:1;s:11:\"cover_photo\";b:0;s:8:\"verified\";b:0;}'),(125,4,'submitted','a:8:{s:18:\"use_gdpr_agreement\";i:1610718549;s:7:\"form_id\";s:3:\"113\";s:10:\"um_request\";s:0:\"\";s:8:\"_wpnonce\";s:10:\"45e053f599\";s:16:\"_wp_http_referer\";s:23:\"/wordpress/es/register/\";s:10:\"user_email\";s:14:\"prueba@test.es\";s:10:\"user_login\";s:7:\"Marisol\";s:9:\"timestamp\";i:1610718548;}'),(126,4,'use_gdpr_agreement','1610718549'),(127,4,'form_id','113'),(128,4,'um_request',''),(129,4,'_wpnonce','45e053f599'),(130,4,'_wp_http_referer','/wordpress/es/register/'),(132,4,'timestamp','1610718548'),(133,4,'um_user_profile_url_slug_user_login','Marisol'),(135,4,'account_status','approved'),(137,4,'_um_last_login','1616401663'),(138,4,'description_en',''),(141,1,'um_user_profile_url_slug_user_id','1'),(142,4,'um_user_profile_url_slug_user_id','4'),(143,4,'um_account_secure_fields','a:4:{s:7:\"general\";a:4:{i:0;s:10:\"user_login\";i:1;s:10:\"first_name\";i:2;s:9:\"last_name\";i:3;s:10:\"user_email\";}s:8:\"password\";a:1:{i:0;s:13:\"user_password\";}s:7:\"privacy\";a:3:{i:0;s:15:\"profile_privacy\";i:1;s:15:\"profile_noindex\";i:2;s:15:\"hide_in_members\";}s:6:\"delete\";a:1:{i:0;s:20:\"single_user_password\";}}'),(144,1,'panoramic_review_notice_dismissed','true'),(146,1,'um_user_profile_url_slug_name_dash','jorge-ganoza'),(147,4,'um_user_profile_url_slug_name_dash','marisol'),(148,4,'profile_photo','profile_photo.png'),(149,4,'user_documento','1234567A'),(151,1,'community-events-location','a:1:{s:2:\"ip\";s:11:\"192.168.1.0\";}'),(152,1,'user_documento','112233445O'),(155,1,'description_en',''),(157,1,'profile_photo','profile_photo.png'),(426,14,'nickname','jganoza'),(427,14,'first_name','Jorge'),(428,14,'last_name','Ganoza Gómez'),(429,14,'description',''),(430,14,'rich_editing','true'),(431,14,'syntax_highlighting','true'),(432,14,'comment_shortcuts','false'),(433,14,'admin_color','fresh'),(434,14,'use_ssl','0'),(435,14,'show_admin_bar_front','true'),(436,14,'locale',''),(437,14,'wp_capabilities','a:1:{s:12:\"um_candidato\";b:1;}'),(438,14,'wp_user_level','0'),(439,14,'synced_gravatar_hashed_id','0306f73dfcaf756be31d9bb48d3ed91d'),(440,14,'um_member_directory_data','a:5:{s:14:\"account_status\";s:8:\"approved\";s:15:\"hide_in_members\";b:0;s:13:\"profile_photo\";b:0;s:11:\"cover_photo\";b:0;s:8:\"verified\";b:0;}'),(2142,14,'_um_last_login','1616673607'),(2143,14,'community-events-location','a:1:{s:2:\"ip\";s:11:\"192.168.1.0\";}'),(2145,14,'session_tokens','a:1:{s:64:\"9c911d428d32c35dd32ddf54e19abe1c7f401a392c5dc72d5a0d2fb2ed15cb70\";a:4:{s:10:\"expiration\";i:1616846407;s:2:\"ip\";s:12:\"192.168.1.64\";s:2:\"ua\";s:130:\"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/89.0.4389.90 Safari/537.36 Edg/89.0.774.57\";s:5:\"login\";i:1616673607;}}'),(2219,15,'_um_last_login','1619602342'),(2220,15,'um_user_profile_url_slug_user_login','jganoza'),(2221,15,'account_status','approved'),(2222,15,'um_member_directory_data','a:5:{s:14:\"account_status\";s:8:\"approved\";s:15:\"hide_in_members\";b:0;s:13:\"profile_photo\";b:1;s:11:\"cover_photo\";b:0;s:8:\"verified\";b:0;}'),(2223,14,'account_status','approved'),(2224,14,'um_user_profile_url_slug_user_login','jganoza_old'),(2225,16,'nickname','eflores'),(2226,16,'first_name','Eduardo'),(2227,16,'last_name','Flores González'),(2228,16,'description',''),(2229,16,'rich_editing','true'),(2230,16,'syntax_highlighting','true'),(2231,16,'comment_shortcuts','false'),(2232,16,'admin_color','fresh'),(2233,16,'use_ssl','0'),(2234,16,'show_admin_bar_front','true'),(2235,16,'locale',''),(2236,16,'wp_capabilities','a:1:{s:12:\"um_candidato\";b:1;}'),(2237,16,'wp_user_level','0'),(2238,16,'synced_gravatar_hashed_id','899323d5436fc69e80c543d045aa6199'),(2239,16,'um_member_directory_data','a:5:{s:14:\"account_status\";s:8:\"approved\";s:15:\"hide_in_members\";b:0;s:13:\"profile_photo\";b:0;s:11:\"cover_photo\";b:0;s:8:\"verified\";b:0;}'),(2241,16,'_um_last_login','1616675134'),(2242,16,'account_status','approved'),(2243,16,'um_user_profile_url_slug_user_login','eflores'),(2244,15,'description',''),(2245,15,'description_en',''),(2247,15,'um_account_secure_fields','a:0:{}'),(2248,15,'user_documento','1111111A'),(2249,15,'nickname','jganoza'),(2250,15,'first_name','Jorge'),(2251,15,'last_name','Ganoza Gómez'),(2252,15,'rich_editing','true'),(2253,15,'syntax_highlighting','true'),(2254,15,'comment_shortcuts','false'),(2255,15,'admin_color','fresh'),(2256,15,'use_ssl','0'),(2257,15,'show_admin_bar_front','true'),(2258,15,'locale',''),(2259,15,'wp_capabilities','a:1:{s:12:\"um_evaluador\";b:1;}'),(2260,15,'wp_user_level','0'),(2263,15,'profile_photo','profile_photo.png'),(2265,1,'session_tokens','a:2:{s:64:\"67315357a07cfb77a06435df70cb5f40e73cd6948053198a1eb31146cbc999aa\";a:4:{s:10:\"expiration\";i:1620373877;s:2:\"ip\";s:12:\"192.168.1.64\";s:2:\"ua\";s:115:\"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/89.0.4389.128 Safari/537.36\";s:5:\"login\";i:1620201077;}s:64:\"e086c03fab07314ec83f1b725026caa916e9f1abb6fc0ee19a8aa6a41b6ad320\";a:4:{s:10:\"expiration\";i:1620468733;s:2:\"ip\";s:12:\"192.168.1.90\";s:2:\"ua\";s:114:\"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/90.0.4430.93 Safari/537.36\";s:5:\"login\";i:1620295933;}}'),(2266,17,'nickname','macarmona'),(2267,17,'first_name','Miguel Ángel'),(2268,17,'last_name','Carmona Moreno'),(2269,17,'description',''),(2270,17,'rich_editing','true'),(2271,17,'syntax_highlighting','true'),(2272,17,'comment_shortcuts','false'),(2273,17,'admin_color','fresh'),(2274,17,'use_ssl','0'),(2275,17,'show_admin_bar_front','true'),(2276,17,'locale',''),(2277,17,'wp_capabilities','a:1:{s:12:\"um_evaluador\";b:1;}'),(2278,17,'wp_user_level','0'),(2279,17,'synced_gravatar_hashed_id','9a443291b411052c65f161e2f7b07744'),(2280,17,'um_member_directory_data','a:5:{s:14:\"account_status\";s:8:\"approved\";s:15:\"hide_in_members\";b:0;s:13:\"profile_photo\";b:0;s:11:\"cover_photo\";b:0;s:8:\"verified\";b:0;}'),(2282,17,'_um_last_login','1617959611'),(2283,17,'um_user_profile_url_slug_user_login','macarmona'),(2284,17,'um_account_secure_fields','a:0:{}'),(2286,17,'account_status','approved'),(2292,3,'um_member_directory_data','a:5:{s:14:\"account_status\";s:8:\"approved\";s:15:\"hide_in_members\";b:0;s:13:\"profile_photo\";b:0;s:11:\"cover_photo\";b:0;s:8:\"verified\";b:0;}'),(2293,3,'account_status','approved'),(2294,3,'um_user_profile_url_slug_user_login','aaaa'),(2295,15,'session_tokens','a:1:{s:64:\"5139b8f0cb72d4b15c2c56af05e81a6b365b604c105c95d59646ef3c89ab25c1\";a:4:{s:10:\"expiration\";i:1619775142;s:2:\"ip\";s:12:\"192.168.1.64\";s:2:\"ua\";s:115:\"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/89.0.4389.128 Safari/537.36\";s:5:\"login\";i:1619602342;}}');
/*!40000 ALTER TABLE `wp_usermeta` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
-- Dump completed on 2021-05-06 14:12:45