/*
 Navicat Premium Data Transfer

 Source Server         : LOCAL
 Source Server Type    : MySQL
 Source Server Version : 100136
 Source Host           : localhost:3306
 Source Schema         : api2

 Target Server Type    : MySQL
 Target Server Version : 100136
 File Encoding         : 65001

 Date: 14/08/2020 23:57:12
*/


-- ----------------------------
-- Table structure for categories
-- ----------------------------
CREATE TABLE `categories`  (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `deleted_at` timestamp(0) NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Compact;

-- ----------------------------
-- Records of categories
-- ----------------------------
INSERT INTO `categories` VALUES (1, 'prueba', NULL);

-- ----------------------------
-- Table structure for failed_jobs
-- ----------------------------
CREATE TABLE `failed_jobs`  (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `connection` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `queue` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `exception` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `failed_at` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0),
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Compact;

-- ----------------------------
-- Table structure for migrations
-- ----------------------------
CREATE TABLE `migrations`  (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `migration` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int(11) NOT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 13 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Compact;

-- ----------------------------
-- Records of migrations
-- ----------------------------
INSERT INTO `migrations` VALUES (1, '2014_10_12_000000_create_users_table', 1);
INSERT INTO `migrations` VALUES (2, '2019_08_19_000000_create_failed_jobs_table', 1);
INSERT INTO `migrations` VALUES (3, '2020_07_22_174718_create_categories_table', 1);
INSERT INTO `migrations` VALUES (4, '2016_06_01_000001_create_oauth_auth_codes_table', 2);
INSERT INTO `migrations` VALUES (5, '2016_06_01_000002_create_oauth_access_tokens_table', 2);
INSERT INTO `migrations` VALUES (6, '2016_06_01_000003_create_oauth_refresh_tokens_table', 2);
INSERT INTO `migrations` VALUES (7, '2016_06_01_000004_create_oauth_clients_table', 2);
INSERT INTO `migrations` VALUES (8, '2016_06_01_000005_create_oauth_personal_access_clients_table', 2);
INSERT INTO `migrations` VALUES (9, '2020_07_23_022213_create_pruebas_table', 3);
INSERT INTO `migrations` VALUES (10, '2020_07_23_024035_create_pruebas_table', 4);
INSERT INTO `migrations` VALUES (11, '2020_07_23_031402_create_pruebas_table', 5);
INSERT INTO `migrations` VALUES (12, '2020_07_24_024054_create_prueba2s_table', 6);

-- ----------------------------
-- Table structure for oauth_access_tokens
-- ----------------------------
CREATE TABLE `oauth_access_tokens`  (
  `id` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` bigint(20) UNSIGNED NULL DEFAULT NULL,
  `client_id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `scopes` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
  `revoked` tinyint(1) NOT NULL,
  `created_at` timestamp(0) NULL DEFAULT NULL,
  `updated_at` timestamp(0) NULL DEFAULT NULL,
  `expires_at` datetime(0) NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `oauth_access_tokens_user_id_index`(`user_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Compact;

-- ----------------------------
-- Records of oauth_access_tokens
-- ----------------------------
INSERT INTO `oauth_access_tokens` VALUES ('0175a1122217a9afb519f7d7e47470d41fe96c6abee05833ee3a67a8fb985646f86f36b428fec5a8', 37, 3, 'contactos', '[]', 0, '2020-07-27 02:08:09', '2020-07-27 02:08:09', '2021-07-27 02:08:09');
INSERT INTO `oauth_access_tokens` VALUES ('047f279d61e5eb14dba17f645f7c5584bb5459ac228e662eec6df7f5f13053eb3166a1d9511d2ef6', 37, 3, 'contactos', '[]', 0, '2020-07-26 00:07:33', '2020-07-26 00:07:33', '2021-07-26 00:07:33');
INSERT INTO `oauth_access_tokens` VALUES ('068f3bcdd66127eebffdb83e81d84683bba084dea7522f935f2829806cb551b4c1cc8443550144bc', 37, 3, 'contactos', '[]', 0, '2020-07-25 23:34:48', '2020-07-25 23:34:48', '2021-07-25 23:34:48');
INSERT INTO `oauth_access_tokens` VALUES ('092f314ecb10ff86a0f22a2c027941e71a8d97a8e3370d9994f6a5616dcb74602462b85adfe675c9', 1, 3, 'contactos', '[]', 0, '2020-07-26 18:24:43', '2020-07-26 18:24:43', '2021-07-26 18:24:43');
INSERT INTO `oauth_access_tokens` VALUES ('0c8d1eb50689f144ff4f9278f49cd2796cc6e17f88030ee8f339fa327975c0c3831c407e9ecb69a3', 37, 3, 'contactos', '[]', 0, '2020-08-09 15:59:19', '2020-08-09 15:59:19', '2021-08-09 15:59:19');
INSERT INTO `oauth_access_tokens` VALUES ('193f64ca4c36d47c410540e12780ee92592cdc4d7db954fa3102c965623b6b1defe997a8155d2196', 37, 3, 'contactos', '[]', 0, '2020-07-26 21:31:21', '2020-07-26 21:31:21', '2021-07-26 21:31:21');
INSERT INTO `oauth_access_tokens` VALUES ('1aa532cc172a7f1ad00259b80ba3f4f1e14bd0e7373401d0f2498296f60546e203a55ddbdc057321', 37, 3, 'contactos', '[]', 0, '2020-08-09 17:56:49', '2020-08-09 17:56:49', '2021-08-09 17:56:49');
INSERT INTO `oauth_access_tokens` VALUES ('1d5c722809e02621750a1ae6a25b5436c63363ebc223dbf5a6782006a019ddcb876506a80bee9667', 37, 3, 'contactos', '[]', 0, '2020-07-25 23:37:04', '2020-07-25 23:37:04', '2021-07-25 23:37:04');
INSERT INTO `oauth_access_tokens` VALUES ('1d836426c8f61cf9d63403031dc9583239cdc054f8118d96a9713757492a07b58a6d2bace6576294', 37, 3, 'contactos', '[]', 0, '2020-07-26 22:23:47', '2020-07-26 22:23:47', '2021-07-26 22:23:47');
INSERT INTO `oauth_access_tokens` VALUES ('208099d019baf54914b0129764ec1a3cd774c9c6024e5e5a58d9cd5f246d90feb531144a1ae6455d', 1, 3, 'contactos', '[]', 0, '2020-07-27 05:00:29', '2020-07-27 05:00:29', '2021-07-27 05:00:29');
INSERT INTO `oauth_access_tokens` VALUES ('22e639d1dcd27d5404fbe50e399c19b8838468ca781e795eb8952f8305fdeae303345720cbb7f2ae', 1, 3, 'contactos', '[]', 0, '2020-07-26 16:54:11', '2020-07-26 16:54:11', '2021-07-26 16:54:11');
INSERT INTO `oauth_access_tokens` VALUES ('23adafee66d916ce5f856c79436472766e66c638560c948bb0791fa6c49418c337ccf5cef79dd2d5', 35, 3, 'contactos', '[]', 0, '2020-08-09 15:57:52', '2020-08-09 15:57:52', '2021-08-09 15:57:52');
INSERT INTO `oauth_access_tokens` VALUES ('2a2689ef860d20178da8616f78ec74e21b2a8051e60c78899f428df00c8cb7ec912b4be066bbebf0', 37, 3, 'contactos', '[]', 0, '2020-07-26 22:25:36', '2020-07-26 22:25:36', '2021-07-26 22:25:36');
INSERT INTO `oauth_access_tokens` VALUES ('2a3a904da3b7fe54b1e5ee4745203cb495ad538ff9ebcb30f2f0cc8be916e831a1bcb384ccf9dd6a', 35, 3, 'contactos', '[]', 0, '2020-08-09 15:39:12', '2020-08-09 15:39:12', '2021-08-09 15:39:12');
INSERT INTO `oauth_access_tokens` VALUES ('2c1426122fa0eab6226a4f9b69bf7de9082b1b73d8411bd237443dcade326aeaef0907d7d9fe7843', 37, 3, 'contactos', '[]', 0, '2020-07-26 19:53:04', '2020-07-26 19:53:04', '2021-07-26 19:53:04');
INSERT INTO `oauth_access_tokens` VALUES ('2dab8945b8c412e6f7858fd0ad0fd7bd40d37e2d1d0ef84302dcc7c05335179c7ce3405666295530', 37, 3, 'contactos', '[]', 0, '2020-07-27 02:14:06', '2020-07-27 02:14:06', '2021-07-27 02:14:06');
INSERT INTO `oauth_access_tokens` VALUES ('2f230b97ab4a9fae58d4c04d8a3216a6ea88f510fb50a1af9e9c27f30fb82150861b83b290335815', 37, 3, 'contactos', '[]', 0, '2020-07-26 16:42:13', '2020-07-26 16:42:13', '2021-07-26 16:42:13');
INSERT INTO `oauth_access_tokens` VALUES ('2f3cf4b1886913bea4db3ecfcde7d9230a84c7221a57808365fbd072230ad8d1e04803ceaf37c8ec', 37, 3, 'contactos', '[]', 0, '2020-07-25 23:38:44', '2020-07-25 23:38:44', '2021-07-25 23:38:44');
INSERT INTO `oauth_access_tokens` VALUES ('32cebb84db27448527fa8ee158555281dfd34b6830308bfa466833a7a0818b3d41c8a68fc5a7713b', 1, 3, 'contactos', '[]', 0, '2020-07-27 04:32:18', '2020-07-27 04:32:18', '2021-07-27 04:32:18');
INSERT INTO `oauth_access_tokens` VALUES ('3c2444bb23d90ec34736413c358825a9ac4e4c73812113c5fc7bdb1f0363aaf517b78e689704c2b0', 1, 3, 'contactos', '[]', 0, '2020-07-26 18:46:33', '2020-07-26 18:46:33', '2021-07-26 18:46:33');
INSERT INTO `oauth_access_tokens` VALUES ('3d761b700119e5fbe11d68832ef73eb0f3a3308d41e4cb887fb8c381c18a6df47a83f866ac606054', 37, 3, 'contactos', '[]', 0, '2020-07-26 18:50:38', '2020-07-26 18:50:38', '2021-07-26 18:50:38');
INSERT INTO `oauth_access_tokens` VALUES ('43671a3155213c2f29216839ba03d4ae19be5cf9fc607b6ad46a689aa67b3e61f3beebc29621142e', 37, 3, 'contactos', '[]', 0, '2020-07-26 19:01:03', '2020-07-26 19:01:03', '2021-07-26 19:01:03');
INSERT INTO `oauth_access_tokens` VALUES ('4a2cdfc87551c42bb0be56018abdacf4f0c65103935b9b6f90c628b6f41198174d0324ebb5ff771d', 37, 3, 'contactos', '[]', 0, '2020-07-27 04:02:36', '2020-07-27 04:02:36', '2021-07-27 04:02:36');
INSERT INTO `oauth_access_tokens` VALUES ('507054d592d97dfd3d30e9495d3ebdd6c182cbff2e4d8734ae6dfe96e5541545476665fd29a1901d', 37, 3, 'contactos', '[]', 0, '2020-07-26 20:00:17', '2020-07-26 20:00:17', '2021-07-26 20:00:17');
INSERT INTO `oauth_access_tokens` VALUES ('50ad4e3bec2b181f37dc4a20f35265f41573a1e592e1f87f627c876e89f0af8ad9f539f9d7e59a92', 37, 3, 'contactos', '[]', 0, '2020-07-27 02:09:34', '2020-07-27 02:09:34', '2021-07-27 02:09:34');
INSERT INTO `oauth_access_tokens` VALUES ('55567df63f82a11a1b9be685a4139be223deb54aed9b00139389bd0e699f1b86f3b9b26f4389d75e', 35, 3, 'contactos', '[]', 0, '2020-08-09 15:03:23', '2020-08-09 15:03:23', '2021-08-09 15:03:23');
INSERT INTO `oauth_access_tokens` VALUES ('566854c23562550c24f6d7514ba7fbe9bf6b537fb38807b4607238f3c6e77104da5157b67f98da1b', 1, 3, 'contactos', '[]', 0, '2020-07-26 16:48:41', '2020-07-26 16:48:41', '2021-07-26 16:48:41');
INSERT INTO `oauth_access_tokens` VALUES ('5788861b2aa4e647075ee5ad736f3ff25ae46a1a4c4c556fad459149c46172ae4c2e4388c3710543', 37, 3, 'contactos', '[]', 0, '2020-07-26 05:42:30', '2020-07-26 05:42:30', '2021-07-26 05:42:30');
INSERT INTO `oauth_access_tokens` VALUES ('57dbff1e481d7771af64d30ea633ac3117eab0126475cdd2eb433d2eb4f6bc36c0f2ada41bb5fd80', 37, 3, 'contactos', '[]', 0, '2020-07-27 00:37:18', '2020-07-27 00:37:18', '2021-07-27 00:37:18');
INSERT INTO `oauth_access_tokens` VALUES ('5cfffaf9e04414554e10cc0bcfa331c660feda7298dee1ccb11a3ca1a6bf96e552aea0eee6c134a5', 37, 3, 'contactos', '[]', 0, '2020-07-26 06:08:27', '2020-07-26 06:08:27', '2021-07-26 06:08:27');
INSERT INTO `oauth_access_tokens` VALUES ('60cf072e09f49163c694c23f64e285e751f8b285d85de191f851f1b6e53c8ad963e9960991aa3dd7', 1, 3, 'contactos', '[]', 0, '2020-07-26 05:47:18', '2020-07-26 05:47:18', '2021-07-26 05:47:18');
INSERT INTO `oauth_access_tokens` VALUES ('6c4a96f2d22b381d6e3c2486463a64aa447dc82888e8f03add09f2132ed8091e5b2256e0d6151295', 37, 3, 'contactos', '[]', 0, '2020-07-26 05:08:14', '2020-07-26 05:08:14', '2021-07-26 05:08:14');
INSERT INTO `oauth_access_tokens` VALUES ('6d9cdf9d12ed6603d624cd7cd510b8becbad7a7e485d05c3cc704fb7e03fa65b4bc19127f1c83456', 37, 3, 'contactos', '[]', 0, '2020-07-26 18:48:56', '2020-07-26 18:48:56', '2021-07-26 18:48:56');
INSERT INTO `oauth_access_tokens` VALUES ('6e50760c1fa431c6fe94fd8c4b431ae2cdb99a1ea9f449d7714a4b20f133c37b387b71bc1dcd8f64', 37, 3, 'contactos', '[]', 0, '2020-07-26 19:13:44', '2020-07-26 19:13:44', '2021-07-26 19:13:44');
INSERT INTO `oauth_access_tokens` VALUES ('70608ce025641a14fb44b65d5daf5fb62f5a5457d5d73ec7e45847ae9f8b6f6183b296576ea5e413', 35, 3, 'contactos', '[]', 0, '2020-08-09 15:36:24', '2020-08-09 15:36:24', '2021-08-09 15:36:24');
INSERT INTO `oauth_access_tokens` VALUES ('7791c88591eba2dbc0e9643bc7e698a55a4979b7cb38311ac5722b1195e32efb2a0c1d4025c0d7fe', 1, 3, 'contactos', '[]', 0, '2020-07-27 02:04:43', '2020-07-27 02:04:43', '2021-07-27 02:04:43');
INSERT INTO `oauth_access_tokens` VALUES ('7a3ffff1af451a332218ee867f7479528dc91c53e080090cc8d9cc9ac83dcfdd83693fc7ffed4d48', 1, 3, 'contactos', '[]', 0, '2020-07-26 16:52:56', '2020-07-26 16:52:56', '2021-07-26 16:52:56');
INSERT INTO `oauth_access_tokens` VALUES ('7c7c3b19151cb960f1d66b03f8c303d3ec0f0e1b4148a625527863b7e2310287e48b57639379c529', 37, 3, 'contactos', '[]', 0, '2020-07-26 16:49:49', '2020-07-26 16:49:49', '2021-07-26 16:49:49');
INSERT INTO `oauth_access_tokens` VALUES ('819305a31c0eef868e4ead45b203fe831a0fc3fc5a3d597da8f71183e3ddf5eb151a40b53673e369', 37, 3, 'contactos', '[]', 0, '2020-07-26 21:39:18', '2020-07-26 21:39:18', '2021-07-26 21:39:18');
INSERT INTO `oauth_access_tokens` VALUES ('8605973e72980cb2dfb37fa645223590a781a509df5c2b583ade79a03c045c9119883e68394786f9', 37, 3, 'contactos', '[]', 0, '2020-07-26 17:12:19', '2020-07-26 17:12:19', '2021-07-26 17:12:19');
INSERT INTO `oauth_access_tokens` VALUES ('86886de2e1339b948a4ac018a43ad3d70960e649daf97098ecdfc81a3c95e20331cc0e9570b3ddf4', 1, 3, 'contactos', '[]', 0, '2020-07-27 05:05:19', '2020-07-27 05:05:19', '2021-07-27 05:05:19');
INSERT INTO `oauth_access_tokens` VALUES ('885b6372970a1c3a5e4aac51e297ab96b8d33ad5e74d92f8387475596a1822fe6569aa4ba495a195', 37, 3, 'contactos', '[]', 0, '2020-07-26 19:53:02', '2020-07-26 19:53:02', '2021-07-26 19:53:02');
INSERT INTO `oauth_access_tokens` VALUES ('896a334acc171f0d5ebe90f9eebba8621234ce8056c0e46f0dd355ceb7c7bd309dc785e96cf2bb44', 1, 3, 'contactos', '[]', 0, '2020-07-27 01:27:19', '2020-07-27 01:27:19', '2021-07-27 01:27:19');
INSERT INTO `oauth_access_tokens` VALUES ('8ded13e94983934543f21c2180febe6b792410a8aad30202b703a9cf188f1375dfbc468eb2120f82', 35, 3, 'contactos', '[]', 0, '2020-08-09 16:51:03', '2020-08-09 16:51:03', '2021-08-09 16:51:03');
INSERT INTO `oauth_access_tokens` VALUES ('95648b0b6369df68f9386b03d2808a8ebde81a84af112f1a0f5c62cec403960b5a7e9c094a2b7ed9', 1, 3, 'contactos', '[]', 0, '2020-07-27 01:31:40', '2020-07-27 01:31:40', '2021-07-27 01:31:40');
INSERT INTO `oauth_access_tokens` VALUES ('a303d366b30a0601632a7205ca27937e0461c1efa6447347a3486690b857be850adbaace04e0574b', 37, 3, 'contactos', '[]', 0, '2020-07-26 16:56:30', '2020-07-26 16:56:30', '2021-07-26 16:56:30');
INSERT INTO `oauth_access_tokens` VALUES ('a5ed962d6d3ce9338fe2c610034b0eb67e7d79586f4f169954e6a9ff8e3eb93d5117745309a9d3b0', 37, 3, 'contactos', '[]', 0, '2020-08-09 16:46:19', '2020-08-09 16:46:19', '2021-08-09 16:46:19');
INSERT INTO `oauth_access_tokens` VALUES ('a861277bdca5efa3b2e8338d09208401d72f7d78f571fed29180ee59530a25a49663901d0d75ddf3', 1, 3, 'contactos', '[]', 0, '2020-07-26 06:19:06', '2020-07-26 06:19:06', '2021-07-26 06:19:06');
INSERT INTO `oauth_access_tokens` VALUES ('a98244c947794c7ae1ad64fed26b7096c7e8190ec004c1db2372cd4fd613f23c1a179a3d271bb007', 37, 3, 'contactos', '[]', 0, '2020-07-26 18:48:54', '2020-07-26 18:48:54', '2021-07-26 18:48:54');
INSERT INTO `oauth_access_tokens` VALUES ('ab9e252ae83f2826adb8948ec2c3d17461acb55590db446dfaed95810e5b24a40202c0d393311d11', 37, 3, 'contactos', '[]', 0, '2020-07-26 16:50:09', '2020-07-26 16:50:09', '2021-07-26 16:50:09');
INSERT INTO `oauth_access_tokens` VALUES ('aeaf7bc7d0a3a706f0db646c9511574ebb6c6ec9c4aebfb8a5ede4546de97ad0b6f8108c0cfdbac5', 37, 3, 'contactos', '[]', 0, '2020-07-26 19:18:55', '2020-07-26 19:18:55', '2021-07-26 19:18:55');
INSERT INTO `oauth_access_tokens` VALUES ('af17b48d50c40ba8e600c7eb8a045f3c9800fb906c6f986cf54b238921bf0f46ae7f4cfa27ab1949', 35, 3, 'contactos', '[]', 0, '2020-08-09 15:25:11', '2020-08-09 15:25:11', '2021-08-09 15:25:11');
INSERT INTO `oauth_access_tokens` VALUES ('af4177438aeee7ea29990762767ba8c061a43e2fc4fe8bc34847fe55a6d3bf3278fb2d38656b9a81', 1, 3, 'contactos', '[]', 0, '2020-07-26 18:27:45', '2020-07-26 18:27:45', '2021-07-26 18:27:45');
INSERT INTO `oauth_access_tokens` VALUES ('b4ad5baed2de91170bff94107ee08735c37dcf7958c7298a962d0f5a8ba3c57cf1b6895dd2493cc5', 37, 3, 'contactos', '[]', 0, '2020-07-26 00:07:16', '2020-07-26 00:07:16', '2021-07-26 00:07:16');
INSERT INTO `oauth_access_tokens` VALUES ('b56c90c5ca7a1d4fa301eadcd8ee3f724cec345061b0dfeb9c43f212e37164623714d0082fc34de7', 37, 3, 'contactos', '[]', 0, '2020-07-26 19:12:57', '2020-07-26 19:12:57', '2021-07-26 19:12:57');
INSERT INTO `oauth_access_tokens` VALUES ('babcca15fdd10b69deec4bec2702abd8f3a5af01ce80e4795c79d2dc235a7c7de613ce8152d354a9', 37, 3, 'contactos', '[]', 0, '2020-07-26 22:14:55', '2020-07-26 22:14:55', '2021-07-26 22:14:55');
INSERT INTO `oauth_access_tokens` VALUES ('c371eac994d2676ccd71623047acdcc54b0e1ac1a68b6a58fcd29670a108eed05fdaadd975ea321f', 1, 3, 'contactos', '[]', 0, '2020-07-27 05:03:44', '2020-07-27 05:03:44', '2021-07-27 05:03:44');
INSERT INTO `oauth_access_tokens` VALUES ('ca718bb1284a4fa17f584777ffc001e4274782e85fe499c7e163cb0ed6b0c8cad66613d364ad054f', 35, 3, 'contactos', '[]', 0, '2020-08-09 15:38:36', '2020-08-09 15:38:36', '2021-08-09 15:38:36');
INSERT INTO `oauth_access_tokens` VALUES ('cc4b5c98f9ca3c0ae0f05475d7cfe6b3e9e2173b369c6b75733d40d42fa1ccccacf3de4ce28e31bc', 37, 3, 'contactos', '[]', 0, '2020-07-27 04:01:58', '2020-07-27 04:01:58', '2021-07-27 04:01:58');
INSERT INTO `oauth_access_tokens` VALUES ('ccf4d90188816317e1829ef9f8ac0533fc816e57f4ad13d0617336ab27dfe5ff37a432580bfd8c46', 37, 3, 'contactos', '[]', 0, '2020-07-26 17:08:10', '2020-07-26 17:08:10', '2021-07-26 17:08:10');
INSERT INTO `oauth_access_tokens` VALUES ('cdb6644589a23ce84cf924c3373cf77f5572a780c5a682bb80dc3a7e620f767669400580b26d69f0', 1, 3, 'contactos', '[]', 0, '2020-07-25 18:51:06', '2020-07-25 18:51:06', '2021-07-25 18:51:06');
INSERT INTO `oauth_access_tokens` VALUES ('d2322a1e489ea6e8c7a7c02675aad488e8ac22db0ba00d2e2b3878e66b89ccbb532f23d4d155ef8c', 1, 3, 'contactos', '[]', 0, '2020-07-26 16:41:53', '2020-07-26 16:41:53', '2021-07-26 16:41:53');
INSERT INTO `oauth_access_tokens` VALUES ('d58c7d7f40044b2c13d4f793132d854e2780cab50ae8ba90b18d413c6dc4f46828b113d883caa20f', 37, 3, 'contactos', '[]', 0, '2020-07-26 17:02:35', '2020-07-26 17:02:35', '2021-07-26 17:02:35');
INSERT INTO `oauth_access_tokens` VALUES ('d5f38b705ecd3c5f9d4ba64bd146a1db519ec5ebccd0cf2fe146b9abaaf9619ba8607e120ea8d1b6', 37, 3, 'contactos', '[]', 0, '2020-07-26 17:13:12', '2020-07-26 17:13:12', '2021-07-26 17:13:12');
INSERT INTO `oauth_access_tokens` VALUES ('d627e3e8fc648d81e2c086a4aa0ed8a6588af8ad9f22f1448c769643a33b83c1eac0bb9fc12cc389', 1, 3, 'contactos', '[]', 0, '2020-07-27 04:29:11', '2020-07-27 04:29:11', '2021-07-27 04:29:11');
INSERT INTO `oauth_access_tokens` VALUES ('d6c3504d7d1b39f3f7e3272070d23b6f59b7ff376751025b77361db6ef02ba3b7f397e58d964abe6', 1, 3, 'contactos', '[]', 0, '2020-07-26 16:49:15', '2020-07-26 16:49:15', '2021-07-26 16:49:15');
INSERT INTO `oauth_access_tokens` VALUES ('da0f3fb15fd4410da9d631fb82de34e3738c3dc70b154ee3aa98de11db3cf3f89d3cd0e6b346603d', 37, 3, 'contactos', '[]', 0, '2020-07-26 20:05:46', '2020-07-26 20:05:46', '2021-07-26 20:05:46');
INSERT INTO `oauth_access_tokens` VALUES ('db93c256496ef83bfd253195c12a57b9292e97b9ec5ae72b7f5ddbf5694c1105323e604ce164e360', 1, 3, 'contactos', '[]', 0, '2020-07-26 16:53:20', '2020-07-26 16:53:20', '2021-07-26 16:53:20');
INSERT INTO `oauth_access_tokens` VALUES ('dbac68a66f8cea5783b5725fd3b735e51156209fb45e3ac5bbe587eb5bd8aa7e704cae684333cebd', 37, 3, 'contactos', '[]', 0, '2020-07-25 23:39:37', '2020-07-25 23:39:37', '2021-07-25 23:39:37');
INSERT INTO `oauth_access_tokens` VALUES ('de0dfa6b9b14fab08610f640556cf45591189c31fcbc8ad2e558f7a8fd90d7514442fa73aa447da2', 35, 3, 'contactos', '[]', 0, '2020-08-09 15:21:27', '2020-08-09 15:21:27', '2021-08-09 15:21:27');
INSERT INTO `oauth_access_tokens` VALUES ('de10c53b8f0f40ee54c45a748344bbb431601cba19ba7ff506aaacf2e851bfed65cfe10926d6b1ba', 37, 3, 'contactos', '[]', 0, '2020-07-27 02:13:03', '2020-07-27 02:13:03', '2021-07-27 02:13:03');
INSERT INTO `oauth_access_tokens` VALUES ('dedb21953d9a62f880d641857f9e473824a54a3a75d0fcabf6cae3e3b34a2ecbbe4f7c8cf8a5d714', 35, 3, 'contactos', '[]', 0, '2020-08-09 15:04:06', '2020-08-09 15:04:06', '2021-08-09 15:04:06');
INSERT INTO `oauth_access_tokens` VALUES ('df18e228f422b4eb5fbcd9a2f473bcbe2f5bb97b941c1a22b8c1c5732e511bca36613f9c6fd1fb19', 1, 3, 'contactos', '[]', 0, '2020-07-27 04:31:51', '2020-07-27 04:31:51', '2021-07-27 04:31:51');
INSERT INTO `oauth_access_tokens` VALUES ('dfb547291d2d7d672a845da4a516e060eb2e4a67b8c39d369fc54e5e9273ce7bffc98ed36f3539ea', 35, 3, 'contactos', '[]', 0, '2020-08-09 15:28:33', '2020-08-09 15:28:33', '2021-08-09 15:28:33');
INSERT INTO `oauth_access_tokens` VALUES ('e1d6944a961703f08a0ac9c78366202f21289ac0f59e23c8f824f7acda733b00714be05240fae411', 37, 3, 'contactos', '[]', 0, '2020-08-09 16:05:40', '2020-08-09 16:05:40', '2021-08-09 16:05:40');
INSERT INTO `oauth_access_tokens` VALUES ('eb24f280d4b17250f0bbcdeb25a6311cb509581983eb94f552f7e9410d6a157dfc78e53a4746fcd0', 37, 3, 'contactos', '[]', 0, '2020-07-26 22:09:38', '2020-07-26 22:09:38', '2021-07-26 22:09:38');
INSERT INTO `oauth_access_tokens` VALUES ('f1ccc9354694668ee5081988092d07101e70a9f1c62ce4a0997697f0514836ddd0b6ef089a5143ff', 35, 3, 'contactos', '[]', 0, '2020-08-09 06:10:30', '2020-08-09 06:10:30', '2021-08-09 06:10:30');
INSERT INTO `oauth_access_tokens` VALUES ('f217324990c11460c5a345aa8087e9a01cfe80413bccec5e1c88f10d982937a3625e96c023ae48bc', 37, 3, 'contactos', '[]', 0, '2020-07-26 21:20:10', '2020-07-26 21:20:10', '2021-07-26 21:20:10');
INSERT INTO `oauth_access_tokens` VALUES ('f41aae272ab020c37ce803b00ca908152c08862dc72b0f38330b7ad966450ec7311c9763db43d81a', 37, 3, 'contactos', '[]', 0, '2020-07-27 02:01:27', '2020-07-27 02:01:27', '2021-07-27 02:01:27');
INSERT INTO `oauth_access_tokens` VALUES ('f73252ab706bb4bb934523d4753ef03644ef187ff1e492330118edb9f3ae25d25c1fddd4843a1a1a', 37, 3, 'contactos', '[]', 0, '2020-07-25 23:38:05', '2020-07-25 23:38:05', '2021-07-25 23:38:05');
INSERT INTO `oauth_access_tokens` VALUES ('f74f6ea9a81022fe49033579844ffeaabc57fadaa44662b9b9e821af32becc55a5a057820909459c', 37, 3, 'contactos', '[]', 0, '2020-07-27 01:28:25', '2020-07-27 01:28:25', '2021-07-27 01:28:25');
INSERT INTO `oauth_access_tokens` VALUES ('faa107dff75d8f15cd64e4a39aeaa8427d41252e0fd8500ec3864adb7c87adb01654f1919f34c4f5', 37, 3, 'contactos', '[]', 0, '2020-07-26 20:13:42', '2020-07-26 20:13:42', '2021-07-26 20:13:42');
INSERT INTO `oauth_access_tokens` VALUES ('fe7fd3e4808ad3a4ea51301ec05381bfbdf029c834cf60937126864b73d1637c233a0764944f004d', 37, 3, 'contactos', '[]', 0, '2020-07-26 18:29:12', '2020-07-26 18:29:12', '2021-07-26 18:29:12');

-- ----------------------------
-- Table structure for oauth_auth_codes
-- ----------------------------
CREATE TABLE `oauth_auth_codes`  (
  `id` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `client_id` bigint(20) UNSIGNED NOT NULL,
  `scopes` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
  `revoked` tinyint(1) NOT NULL,
  `expires_at` datetime(0) NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `oauth_auth_codes_user_id_index`(`user_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Compact;

-- ----------------------------
-- Table structure for oauth_clients
-- ----------------------------
CREATE TABLE `oauth_clients`  (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) UNSIGNED NULL DEFAULT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `secret` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `provider` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `redirect` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `personal_access_client` tinyint(1) NOT NULL,
  `password_client` tinyint(1) NOT NULL,
  `revoked` tinyint(1) NOT NULL,
  `created_at` timestamp(0) NULL DEFAULT NULL,
  `updated_at` timestamp(0) NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `oauth_clients_user_id_index`(`user_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Compact;

-- ----------------------------
-- Records of oauth_clients
-- ----------------------------
INSERT INTO `oauth_clients` VALUES (1, NULL, 'Laravel Personal Access Client', 'hrXdZGHWsO4VyFuba1yyvNajqyTVHFvxOY1a8ZvN', NULL, 'http://localhost', 1, 0, 0, '2020-07-23 00:10:35', '2020-07-23 00:10:35');
INSERT INTO `oauth_clients` VALUES (2, NULL, 'Laravel Password Grant Client', 'EK4yAieWZ3aBuvyORy8mSodn3TEO7WxhifdNx6Fe', 'users', 'http://localhost', 0, 1, 0, '2020-07-23 00:10:35', '2020-07-23 00:10:35');
INSERT INTO `oauth_clients` VALUES (3, NULL, 'contactos', 'ZIDrz2Jyc86nrpn9vxHtJ9b072qOBx3yjyi9rABt', NULL, 'http://localhost', 1, 0, 0, '2020-07-23 00:15:21', '2020-07-23 00:15:21');

-- ----------------------------
-- Table structure for oauth_personal_access_clients
-- ----------------------------
CREATE TABLE `oauth_personal_access_clients`  (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `client_id` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp(0) NULL DEFAULT NULL,
  `updated_at` timestamp(0) NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Compact;

-- ----------------------------
-- Records of oauth_personal_access_clients
-- ----------------------------
INSERT INTO `oauth_personal_access_clients` VALUES (1, 1, '2020-07-23 00:10:35', '2020-07-23 00:10:35');
INSERT INTO `oauth_personal_access_clients` VALUES (2, 3, '2020-07-23 00:15:21', '2020-07-23 00:15:21');

-- ----------------------------
-- Table structure for oauth_refresh_tokens
-- ----------------------------
CREATE TABLE `oauth_refresh_tokens`  (
  `id` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `access_token_id` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `revoked` tinyint(1) NOT NULL,
  `expires_at` datetime(0) NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `oauth_refresh_tokens_access_token_id_index`(`access_token_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Compact;

-- ----------------------------
-- Table structure for permissions
-- ----------------------------
CREATE TABLE `permissions`  (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 11 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Compact;

-- ----------------------------
-- Records of permissions
-- ----------------------------
INSERT INTO `permissions` VALUES (1, 'view_users');
INSERT INTO `permissions` VALUES (2, 'edit_users');
INSERT INTO `permissions` VALUES (3, 'view_roles');
INSERT INTO `permissions` VALUES (4, 'edit_roles');
INSERT INTO `permissions` VALUES (5, 'view_products');
INSERT INTO `permissions` VALUES (6, 'edit_products');
INSERT INTO `permissions` VALUES (7, 'view_orders');
INSERT INTO `permissions` VALUES (8, 'edit_orders');
INSERT INTO `permissions` VALUES (9, 'prueba');
INSERT INTO `permissions` VALUES (10, 'prueba');

-- ----------------------------
-- Table structure for prueba2s
-- ----------------------------
CREATE TABLE `prueba2s`  (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `deleted_at` timestamp(0) NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 37 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Compact;

-- ----------------------------
-- Records of prueba2s
-- ----------------------------
INSERT INTO `prueba2s` VALUES (1, 'p', NULL);
INSERT INTO `prueba2s` VALUES (2, 'prueba', NULL);
INSERT INTO `prueba2s` VALUES (3, 'uno', NULL);
INSERT INTO `prueba2s` VALUES (4, 'p', NULL);
INSERT INTO `prueba2s` VALUES (5, 'p', NULL);
INSERT INTO `prueba2s` VALUES (6, 'p', NULL);
INSERT INTO `prueba2s` VALUES (7, 'p', NULL);
INSERT INTO `prueba2s` VALUES (8, 'p', NULL);
INSERT INTO `prueba2s` VALUES (9, 'p', NULL);
INSERT INTO `prueba2s` VALUES (10, 'p', NULL);
INSERT INTO `prueba2s` VALUES (11, 'p', NULL);
INSERT INTO `prueba2s` VALUES (12, 'p', NULL);
INSERT INTO `prueba2s` VALUES (13, 'p', NULL);
INSERT INTO `prueba2s` VALUES (14, 'p', NULL);
INSERT INTO `prueba2s` VALUES (15, 'p', NULL);
INSERT INTO `prueba2s` VALUES (16, 'p', NULL);
INSERT INTO `prueba2s` VALUES (17, 'p', NULL);
INSERT INTO `prueba2s` VALUES (18, 'pp', NULL);
INSERT INTO `prueba2s` VALUES (19, 'p', NULL);
INSERT INTO `prueba2s` VALUES (20, 'p', NULL);
INSERT INTO `prueba2s` VALUES (21, 'p', NULL);
INSERT INTO `prueba2s` VALUES (22, 'p', NULL);
INSERT INTO `prueba2s` VALUES (23, 'p', NULL);
INSERT INTO `prueba2s` VALUES (24, 'p', NULL);
INSERT INTO `prueba2s` VALUES (25, 'p', NULL);
INSERT INTO `prueba2s` VALUES (26, 'p', NULL);
INSERT INTO `prueba2s` VALUES (27, 'p', NULL);
INSERT INTO `prueba2s` VALUES (28, 'p', NULL);
INSERT INTO `prueba2s` VALUES (29, 'p', NULL);
INSERT INTO `prueba2s` VALUES (30, 'p', NULL);
INSERT INTO `prueba2s` VALUES (31, 'p', NULL);
INSERT INTO `prueba2s` VALUES (32, 'p', NULL);
INSERT INTO `prueba2s` VALUES (33, 'p', NULL);
INSERT INTO `prueba2s` VALUES (34, 'p', NULL);
INSERT INTO `prueba2s` VALUES (35, 'p', NULL);
INSERT INTO `prueba2s` VALUES (36, 'p', NULL);

-- ----------------------------
-- Table structure for pruebas
-- ----------------------------
CREATE TABLE `pruebas`  (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `deleted_at` timestamp(0) NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Compact;

-- ----------------------------
-- Records of pruebas
-- ----------------------------
INSERT INTO `pruebas` VALUES (1, 'prueba', NULL);

-- ----------------------------
-- Table structure for role_permission
-- ----------------------------
CREATE TABLE `role_permission`  (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `role_id` bigint(20) UNSIGNED NOT NULL,
  `permission_id` bigint(20) UNSIGNED NOT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `role_permission_role_id_foreign`(`role_id`) USING BTREE,
  INDEX `role_permission_permission_id_foreign`(`permission_id`) USING BTREE,
  CONSTRAINT `role_permission_ibfk_1` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `role_permission_ibfk_2` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 53 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Compact;

-- ----------------------------
-- Records of role_permission
-- ----------------------------
INSERT INTO `role_permission` VALUES (16, 3, 1);
INSERT INTO `role_permission` VALUES (17, 3, 3);
INSERT INTO `role_permission` VALUES (18, 3, 5);
INSERT INTO `role_permission` VALUES (19, 3, 7);
INSERT INTO `role_permission` VALUES (20, 5, 1);
INSERT INTO `role_permission` VALUES (21, 5, 2);
INSERT INTO `role_permission` VALUES (22, 5, 3);
INSERT INTO `role_permission` VALUES (28, 6, 1);
INSERT INTO `role_permission` VALUES (29, 6, 4);
INSERT INTO `role_permission` VALUES (30, 6, 7);
INSERT INTO `role_permission` VALUES (39, 1, 1);
INSERT INTO `role_permission` VALUES (40, 1, 2);
INSERT INTO `role_permission` VALUES (41, 1, 3);
INSERT INTO `role_permission` VALUES (42, 1, 4);
INSERT INTO `role_permission` VALUES (43, 1, 5);
INSERT INTO `role_permission` VALUES (44, 1, 6);
INSERT INTO `role_permission` VALUES (45, 1, 7);
INSERT INTO `role_permission` VALUES (46, 1, 8);
INSERT INTO `role_permission` VALUES (47, 2, 1);
INSERT INTO `role_permission` VALUES (48, 2, 2);
INSERT INTO `role_permission` VALUES (49, 2, 5);
INSERT INTO `role_permission` VALUES (50, 2, 6);
INSERT INTO `role_permission` VALUES (51, 2, 7);
INSERT INTO `role_permission` VALUES (52, 2, 8);

-- ----------------------------
-- Table structure for roles
-- ----------------------------
CREATE TABLE `roles`  (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Compact;

-- ----------------------------
-- Records of roles
-- ----------------------------
INSERT INTO `roles` VALUES (1, 'Admin');
INSERT INTO `roles` VALUES (2, 'Editor');
INSERT INTO `roles` VALUES (3, 'Viewer');
INSERT INTO `roles` VALUES (5, 'prueba6');
INSERT INTO `roles` VALUES (6, 'prueba8');

-- ----------------------------
-- Table structure for users
-- ----------------------------
CREATE TABLE `users`  (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `email` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `email_verified_at` timestamp(0) NULL DEFAULT NULL,
  `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `remember_token` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `api_token` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `created_at` timestamp(0) NULL DEFAULT NULL,
  `updated_at` timestamp(0) NULL DEFAULT NULL,
  `cedula` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `first_name` varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `last_name` varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `estado` tinyint(1) NULL DEFAULT NULL,
  `role_id` bigint(20) UNSIGNED NULL DEFAULT NULL,
  `password_confirm` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `users_email_unique`(`email`) USING BTREE,
  INDEX `users_role_id_foreign`(`role_id`) USING BTREE,
  CONSTRAINT `users_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `api_admin`.`roles` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 46 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Compact;

-- ----------------------------
-- Records of users
-- ----------------------------
INSERT INTO `users` VALUES (3, 'Jompy1', 'john1@hotmail.es', NULL, '$2y$10$96eTifKHmcpq5BY/pFKLUe.QRwRc6wtl4y0GLZw/629gArfc9/6gG', 'string', NULL, NULL, NULL, NULL, '111', '222', NULL, 1, NULL);
INSERT INTO `users` VALUES (4, 'Jompy2', 'john2@hotmail.es', NULL, '$2y$10$zBn13rsC2Iu280dC7YaZmuGvPtbuGjTPcnb1mluElDeFD0Uvoylvi', 'string', NULL, NULL, NULL, NULL, '111', '222', NULL, 1, NULL);
INSERT INTO `users` VALUES (5, 'Jompy3', 'john3@hotmail.es', NULL, '$2y$10$apgoEFhBlWt9Wu9jLMlK9OoZOwURkR65Zp2.j9A2cLU3FNbtzM576', 'string', NULL, NULL, NULL, NULL, '111', '222', NULL, 1, NULL);
INSERT INTO `users` VALUES (7, 'Jompy4', 'john4@hotmail.es', NULL, '$2y$10$7cZTLtSfl64okd5vhACkSu5DLRLLUR1uFZEEU9FYNYoWPvlfvpKtC', 'string', NULL, NULL, NULL, NULL, '111', '222', NULL, 1, NULL);
INSERT INTO `users` VALUES (8, 'Jompy5', 'john5@hotmail.es', NULL, '$2y$10$OeQUOagfSZZkS8ymlOjO5.vvUkLMkSoShSeKh3IuUxtNQ2cdxNrTy', 'string', NULL, NULL, NULL, NULL, '111', '222', NULL, 1, NULL);
INSERT INTO `users` VALUES (9, 'Jompy5', 'john6@hotmail.es', NULL, '$2y$10$exGct3xux3oUNd22Afr/deA0budKbKqGjChUYsLTmkULrRS0zX64G', 'string', NULL, NULL, NULL, NULL, '111', '222', NULL, 1, NULL);
INSERT INTO `users` VALUES (10, 'Jompy5', 'john7@hotmail.es', NULL, '$2y$10$lKp8EBKPspXjX6gjg.DgHODl5Pcp0WIafMR88SB3iFJPgqTk5mmVS', 'string', NULL, NULL, NULL, NULL, '111', '222', NULL, 1, NULL);
INSERT INTO `users` VALUES (11, 'Jompy5', 'john8@hotmail.es', NULL, '$2y$10$yN/vZA3.pj9s8ieJNlocXeI953iFBy9hTYQcuje123LOUt0bbVqVO', 'string', NULL, NULL, NULL, NULL, '111', '222', NULL, 1, NULL);
INSERT INTO `users` VALUES (12, 'Jompy5', 'john9@hotmail.es', NULL, '$2y$10$ZJpcmBXGKleCa/Z7deyXDOIGo/jKORTxIShftBYRjiSEzQEprklge', 'string', NULL, NULL, NULL, NULL, '111', '222', NULL, 1, NULL);
INSERT INTO `users` VALUES (13, 'Jompy5', 'john11@hotmail.es', NULL, '$2y$10$WWsXw2vX7jFpD/uSqId/pO7M/XYIbSEUpnGOc0ZQTu9E5EsV3.Jya', 'string', NULL, NULL, NULL, NULL, '111', '222', NULL, 1, NULL);
INSERT INTO `users` VALUES (14, 'Jompy5', 'john12@hotmail.es', NULL, '$2y$10$bGMw4Nf8WdC87f6U0URlSevM/3mGiLPT9YJ3KzUDSpAHWmZAC8phe', 'string', NULL, NULL, NULL, NULL, '111', '222', NULL, 1, NULL);
INSERT INTO `users` VALUES (15, 'Jompy5', 'john13@hotmail.es', NULL, '$2y$10$zkAc7u4gTUb530X75KOS8uoSJCu8sx1yLnXWVCBQHdYrRVlwxg7gi', 'string', NULL, NULL, NULL, NULL, '111', '222', NULL, 1, NULL);
INSERT INTO `users` VALUES (16, 'Jompy5', 'john14@hotmail.es', NULL, '$2y$10$M15xaHeZanpxtiiU1/yte.JLOmqTA1JLHZBxGHlnDu3.saoNxUF8.', 'string', NULL, NULL, NULL, NULL, '111', '222', NULL, 1, NULL);
INSERT INTO `users` VALUES (17, 'Jompy5', 'john15@hotmail.es', NULL, '$2y$10$FkjxqT5po553h18f1G/GcONWQjNuH5QCHb.i7KM4H5N9hde0AQ6Kq', 'string', NULL, NULL, NULL, NULL, '111', '222', NULL, 1, NULL);
INSERT INTO `users` VALUES (18, 'Jompy5', 'john16@hotmail.es', NULL, '$2y$10$Y1tCU674Kb7BS9FUppFp8ub8OYI0R.mx.PnOekp4EdiE3fPJSalbu', 'string', NULL, NULL, NULL, NULL, '111', '222', NULL, 1, NULL);
INSERT INTO `users` VALUES (20, 'Jompy5', 'john18@hotmail.es', NULL, '$2y$10$cOTVtaGiD1uRaGQKeMPs.uPRTAQyB5nhu86BUm2sDMZa03lTVP86O', 'string', NULL, NULL, NULL, NULL, '111', '222', NULL, 1, NULL);
INSERT INTO `users` VALUES (22, 'Jompy5', 'john19@hotmail.es', NULL, '$2y$10$q2UQtda73f27utIF.ZDgQ.BfAiBoZzVxz8W3S44CLZI1ANhUK1Syu', 'string', NULL, NULL, NULL, NULL, '111', '222', NULL, 1, NULL);
INSERT INTO `users` VALUES (23, 'Jompy5', 'john21@hotmail.es', NULL, '$2y$10$9M4qXI/Hcitb6NEZCdaz3uuocdpUSmgx2XRj4mENIS3kNqBB2Xqqa', 'string', NULL, NULL, NULL, NULL, '111', '222', NULL, 1, NULL);
INSERT INTO `users` VALUES (24, 'Jompy5', 'john22@hotmail.es', NULL, '$2y$10$PkRDAJQSZVqgP.KCBvJEiu7SiZSHjn.cvgg8UZ.3cPcXQFKFzE2aa', 'string', NULL, NULL, NULL, NULL, '111', '222', NULL, 1, NULL);
INSERT INTO `users` VALUES (25, 'Jompy5', 'john23@hotmail.es', NULL, '$2y$10$.kFkngFSq0QzUDV7jIbT7u68F84UWfxWP2HvNFhhFVlxKC3WrQMMK', 'string', NULL, NULL, NULL, NULL, 'no 1111', '222', NULL, 1, NULL);
INSERT INTO `users` VALUES (32, NULL, 'patico@gmail.com', NULL, '$2y$10$P2hydETxYGzt5Me6bIKwH.A9LGhGIHoQH9NYhmW6Q8Wzm1Q8RA9/C', NULL, NULL, NULL, NULL, NULL, 'john j', 'john j', NULL, 2, NULL);
INSERT INTO `users` VALUES (35, NULL, 'patico2@gmail.com', NULL, '$2y$10$PS36kqJ4vdUncqlkCFqGqOcyA2KYW8AM1GVkNisffFTwzrLptKvqC', NULL, NULL, NULL, NULL, NULL, 'john j', 'john j', NULL, 2, '12345');
INSERT INTO `users` VALUES (37, NULL, 'john99@gmail.com', NULL, '$2y$10$PS36kqJ4vdUncqlkCFqGqOcyA2KYW8AM1GVkNisffFTwzrLptKvqC', NULL, NULL, NULL, NULL, NULL, 'JOhn Jairo', 'Obando Fernandez', NULL, 1, '12345');
INSERT INTO `users` VALUES (45, NULL, 'josnar@gmail.com', NULL, '$2y$10$PS36kqJ4vdUncqlkCFqGqOcyA2KYW8AM1GVkNisffFTwzrLptKvqC', NULL, NULL, NULL, NULL, NULL, 'cartigo', 'pinza', NULL, 2, NULL);

