HEX
Server: Apache/2.4.41 (Ubuntu)
System: Linux ip-172-31-42-149 5.15.0-1084-aws #91~20.04.1-Ubuntu SMP Fri May 2 07:00:04 UTC 2025 aarch64
User: ubuntu (1000)
PHP: 7.4.33
Disabled: pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wifcontinued,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_get_handler,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority,pcntl_async_signals,pcntl_unshare,
$ pwd: /home/ubuntu/aurora/
Upload Files
File: //home/ubuntu/aurora/usmp_main.sql
-- MySQL dump 10.19  Distrib 10.3.39-MariaDB, for debian-linux-gnu (aarch64)
--
-- Host: customers-notx.cuj4pfpdz4zw.us-east-2.rds.amazonaws.com    Database: usmp_main
-- ------------------------------------------------------
-- Server version	10.11.8-MariaDB-log

/*!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 */;
/*!40101 SET NAMES utf8mb4 */;
/*!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 */;

--
-- Current Database: `usmp_main`
--

/*!40000 DROP DATABASE IF EXISTS `usmp_main`*/;

CREATE DATABASE /*!32312 IF NOT EXISTS*/ `usmp_main` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci */;

USE `usmp_main`;

--
-- Table structure for table `corporate_identities`
--

DROP TABLE IF EXISTS `corporate_identities`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `corporate_identities` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `platform_name` varchar(191) NOT NULL,
  `logo` varchar(191) NOT NULL,
  `background_login` varchar(191) NOT NULL,
  `short_name` varchar(191) NOT NULL,
  `bar_color` varchar(191) NOT NULL,
  `icon_color` varchar(191) NOT NULL,
  `btnBox_color` varchar(191) NOT NULL,
  `btnBox_hover_color` varchar(191) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `corporate_identities`
--

LOCK TABLES `corporate_identities` WRITE;
/*!40000 ALTER TABLE `corporate_identities` DISABLE KEYS */;
INSERT INTO `corporate_identities` VALUES (1,'DIM','https://s3.us-east-2.amazonaws.com/b001-si/bikenow/Logoclients/logo_dim.png','https://s3.us-east-2.amazonaws.com/b001-si/bikenow/Logoclients/si-background_login.svg','DIM','#c60216','#1c4577','#203491','#09185f','2020-09-29 17:21:32','2020-09-29 17:21:32');
/*!40000 ALTER TABLE `corporate_identities` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `migrations`
--

DROP TABLE IF EXISTS `migrations`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `migrations` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `migration` varchar(191) NOT NULL,
  `batch` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `migrations`
--

LOCK TABLES `migrations` WRITE;
/*!40000 ALTER TABLE `migrations` DISABLE KEYS */;
INSERT INTO `migrations` VALUES (1,'2014_10_12_000000_create_users_table',1),(2,'2014_10_12_000004_create_corporate_identities_table',1),(3,'2014_10_12_000023_create_terms_table',1),(4,'2014_10_12_000024_create_term_clients_table',1),(5,'2014_10_12_000049_create_user_informations_table',1),(6,'2014_10_12_000050_create_service_cities_table',1),(7,'2014_10_12_000051_create_parameters_table',1),(8,'2014_10_12_100000_create_password_resets_table',1),(9,'2016_06_01_000001_create_oauth_auth_codes_table',1),(10,'2016_06_01_000002_create_oauth_access_tokens_table',1),(11,'2016_06_01_000003_create_oauth_refresh_tokens_table',1),(12,'2016_06_01_000004_create_oauth_clients_table',1),(13,'2016_06_01_000005_create_oauth_personal_access_clients_table',1),(14,'2019_02_20_205054_add_sucursal_products',1),(15,'2023_03_23_125336_add_softdelete_user_informations_table',2),(16,'2023_05_11_202150_create_seeders_table',3),(17,'2024_05_09_152451_change_phone_to_users_table',3);
/*!40000 ALTER TABLE `migrations` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `oauth_access_tokens`
--

DROP TABLE IF EXISTS `oauth_access_tokens`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `oauth_access_tokens` (
  `id` varchar(100) NOT NULL,
  `user_id` bigint(20) DEFAULT NULL,
  `client_id` int(10) unsigned NOT NULL,
  `name` varchar(191) DEFAULT NULL,
  `scopes` text DEFAULT NULL,
  `revoked` tinyint(1) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `expires_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `oauth_access_tokens_user_id_index` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `oauth_access_tokens`
--

LOCK TABLES `oauth_access_tokens` WRITE;
/*!40000 ALTER TABLE `oauth_access_tokens` DISABLE KEYS */;
/*!40000 ALTER TABLE `oauth_access_tokens` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `oauth_auth_codes`
--

DROP TABLE IF EXISTS `oauth_auth_codes`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `oauth_auth_codes` (
  `id` varchar(100) NOT NULL,
  `user_id` bigint(20) NOT NULL,
  `client_id` int(10) unsigned NOT NULL,
  `scopes` text DEFAULT NULL,
  `revoked` tinyint(1) NOT NULL,
  `expires_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `oauth_auth_codes`
--

LOCK TABLES `oauth_auth_codes` WRITE;
/*!40000 ALTER TABLE `oauth_auth_codes` DISABLE KEYS */;
/*!40000 ALTER TABLE `oauth_auth_codes` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `oauth_clients`
--

DROP TABLE IF EXISTS `oauth_clients`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `oauth_clients` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) DEFAULT NULL,
  `name` varchar(191) NOT NULL,
  `secret` varchar(100) NOT NULL,
  `redirect` text NOT NULL,
  `personal_access_client` tinyint(1) NOT NULL,
  `password_client` tinyint(1) NOT NULL,
  `revoked` tinyint(1) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `oauth_clients_user_id_index` (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `oauth_clients`
--

LOCK TABLES `oauth_clients` WRITE;
/*!40000 ALTER TABLE `oauth_clients` DISABLE KEYS */;
INSERT INTO `oauth_clients` VALUES (1,NULL,'api password','fT5p4x6gBX50f16u5y5EydDTdOKystD2WMQ2TWEW','http://localhost',0,1,0,NULL,NULL);
/*!40000 ALTER TABLE `oauth_clients` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `oauth_personal_access_clients`
--

DROP TABLE IF EXISTS `oauth_personal_access_clients`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `oauth_personal_access_clients` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `client_id` int(10) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `oauth_personal_access_clients_client_id_index` (`client_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `oauth_personal_access_clients`
--

LOCK TABLES `oauth_personal_access_clients` WRITE;
/*!40000 ALTER TABLE `oauth_personal_access_clients` DISABLE KEYS */;
/*!40000 ALTER TABLE `oauth_personal_access_clients` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `oauth_refresh_tokens`
--

DROP TABLE IF EXISTS `oauth_refresh_tokens`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `oauth_refresh_tokens` (
  `id` varchar(100) NOT NULL,
  `access_token_id` varchar(100) NOT NULL,
  `revoked` tinyint(1) NOT NULL,
  `expires_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `oauth_refresh_tokens_access_token_id_index` (`access_token_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `oauth_refresh_tokens`
--

LOCK TABLES `oauth_refresh_tokens` WRITE;
/*!40000 ALTER TABLE `oauth_refresh_tokens` DISABLE KEYS */;
/*!40000 ALTER TABLE `oauth_refresh_tokens` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `parameters`
--

DROP TABLE IF EXISTS `parameters`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `parameters` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `minimum_required_android` varchar(191) NOT NULL,
  `minimum_required_ios` varchar(191) NOT NULL,
  `android_play_store` varchar(191) NOT NULL,
  `ios_app_store` varchar(191) NOT NULL,
  `term_id` int(11) NOT NULL,
  `end_version` varchar(191) DEFAULT NULL,
  `end_version_home` varchar(191) DEFAULT NULL,
  `image_end_version` varchar(191) DEFAULT NULL,
  `text_end_version` varchar(191) DEFAULT NULL,
  `link_end_version` varchar(191) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `parameters`
--

LOCK TABLES `parameters` WRITE;
/*!40000 ALTER TABLE `parameters` DISABLE KEYS */;
INSERT INTO `parameters` VALUES (1,'1.1.30','1.1.30','com.co.aliansap.dim','id1539782397',1,NULL,NULL,NULL,NULL,NULL,'2020-09-29 17:21:32','2020-09-29 17:21:32');
/*!40000 ALTER TABLE `parameters` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `password_resets`
--

DROP TABLE IF EXISTS `password_resets`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `password_resets` (
  `email` varchar(191) NOT NULL,
  `token` varchar(191) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  KEY `password_resets_email_index` (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `password_resets`
--

LOCK TABLES `password_resets` WRITE;
/*!40000 ALTER TABLE `password_resets` DISABLE KEYS */;
INSERT INTO `password_resets` VALUES ('camizulu7@hotmail.com','$2y$10$03Za.Cbjxaybzpm6mgT1j.PdLkZKEprdQR8hacyTCaekOCMC7Ofua','2021-10-07 16:18:30');
/*!40000 ALTER TABLE `password_resets` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `seeders`
--

DROP TABLE IF EXISTS `seeders`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `seeders` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `seeder` varchar(191) NOT NULL,
  `batch` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `seeders`
--

LOCK TABLES `seeders` WRITE;
/*!40000 ALTER TABLE `seeders` DISABLE KEYS */;
INSERT INTO `seeders` VALUES (1,'DefaultSeeder',0);
/*!40000 ALTER TABLE `seeders` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `service_cities`
--

DROP TABLE IF EXISTS `service_cities`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `service_cities` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) NOT NULL,
  `active` tinyint(1) NOT NULL,
  `url_api` varchar(191) NOT NULL,
  `url_admin` varchar(191) NOT NULL,
  `url_gallery` varchar(191) NOT NULL,
  `name_database` varchar(191) NOT NULL,
  `sucursal_products` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `service_cities`
--

LOCK TABLES `service_cities` WRITE;
/*!40000 ALTER TABLE `service_cities` DISABLE KEYS */;
INSERT INTO `service_cities` VALUES (1,'Lima',1,'https://usmp.sports-crowd.com/api','https://usmp.sports-crowd.com','https://s3.us-east-2.amazonaws.com/b001-si/bikenow/usmp/','cali-db',0,'2020-09-29 17:21:32','2020-09-29 17:21:32');
/*!40000 ALTER TABLE `service_cities` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `term_clients`
--

DROP TABLE IF EXISTS `term_clients`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `term_clients` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `accepted` tinyint(1) NOT NULL,
  `term_id` int(10) unsigned NOT NULL,
  `user_id` int(10) unsigned NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `term_clients_term_id_foreign` (`term_id`),
  KEY `term_clients_user_id_foreign` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `term_clients`
--

LOCK TABLES `term_clients` WRITE;
/*!40000 ALTER TABLE `term_clients` DISABLE KEYS */;
/*!40000 ALTER TABLE `term_clients` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `terms`
--

DROP TABLE IF EXISTS `terms`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `terms` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `url` varchar(191) NOT NULL,
  `version` varchar(191) NOT NULL,
  `active` tinyint(1) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `terms`
--

LOCK TABLES `terms` WRITE;
/*!40000 ALTER TABLE `terms` DISABLE KEYS */;
INSERT INTO `terms` VALUES (1,'https://b001-si.s3.us-east-2.amazonaws.com/bikenow/usmp/public/terminos_condiciones_san+martin.pdf','1',1,'2020-09-29 17:21:32','2020-09-29 17:21:32');
/*!40000 ALTER TABLE `terms` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `user_informations`
--

DROP TABLE IF EXISTS `user_informations`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `user_informations` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `photo` varchar(191) DEFAULT NULL,
  `photo_social` varchar(191) DEFAULT NULL,
  `social_id` varchar(191) DEFAULT NULL,
  `social_provider` varchar(191) DEFAULT NULL,
  `social_token` varchar(191) DEFAULT NULL,
  `plate` varchar(191) DEFAULT NULL,
  `version` varchar(191) DEFAULT NULL,
  `model` varchar(191) DEFAULT NULL,
  `uid_phone` varchar(191) DEFAULT NULL,
  `url_avatar` varchar(191) DEFAULT NULL,
  `sex` enum('F','M','I','') DEFAULT NULL,
  `dob` date DEFAULT NULL,
  `referred_code` varchar(191) DEFAULT NULL COMMENT 'es el codigo usuario',
  `referred_user_code` varchar(191) DEFAULT NULL COMMENT 'el codigo del otro usuario que me refiere',
  `referred_finish_date` datetime DEFAULT NULL COMMENT 'es la fecha maxima para redimir el codigo',
  `is_initial` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'indica si es la primera vez que el usuario hace login por defecto si esta en false se debe mostrar una ventana para cambiarla',
  `is_tutorial_viewed` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'indica si el usuario ya ha visto el tutorial',
  `is_habeas_data_viewed` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'indica si el usuario acepto terminos y condiciones',
  `courier_company_id` int(10) unsigned DEFAULT NULL,
  `sucursal_id` int(10) unsigned DEFAULT NULL,
  `user_id` int(10) unsigned DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `user_informations`
--

LOCK TABLES `user_informations` WRITE;
/*!40000 ALTER TABLE `user_informations` DISABLE KEYS */;
INSERT INTO `user_informations` VALUES (1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,NULL,1,1,NULL,'2020-09-29 17:21:32','2020-09-29 17:21:32'),(2,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,NULL,1,2,NULL,'2020-09-29 17:21:32','2020-09-29 17:21:32'),(3,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,NULL,1,3,NULL,'2020-09-29 17:21:32','2020-09-29 17:21:32'),(8,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,1,1,NULL,NULL,8,NULL,'2020-11-05 05:28:00','2020-11-05 05:28:00'),(9,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,1,1,NULL,2,9,NULL,'2020-11-06 15:03:53','2020-11-06 15:03:53'),(10,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,1,1,NULL,NULL,10,NULL,'2022-05-05 12:19:15','2022-05-05 12:19:15'),(11,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,1,1,NULL,NULL,11,NULL,'2022-05-06 19:52:45','2022-05-06 19:52:45'),(12,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,1,1,NULL,NULL,12,NULL,'2022-05-10 13:01:07','2022-05-10 13:01:07'),(13,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,1,1,NULL,NULL,13,NULL,'2022-05-11 20:15:35','2022-05-11 20:15:35'),(14,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,1,1,NULL,NULL,14,NULL,'2022-05-11 20:52:28','2022-05-11 20:52:28'),(15,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,1,1,NULL,NULL,15,NULL,'2022-07-01 16:30:33','2022-07-01 16:30:33'),(16,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,1,1,NULL,NULL,16,NULL,'2022-07-01 17:24:12','2022-07-01 17:24:12'),(17,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,1,1,NULL,NULL,17,NULL,'2022-07-02 19:06:47','2022-07-02 19:06:47'),(18,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,1,1,NULL,NULL,18,NULL,'2022-08-31 20:15:46','2022-08-31 20:15:46'),(19,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,1,1,NULL,NULL,19,NULL,'2022-09-16 14:26:45','2022-09-16 14:26:45'),(20,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,1,1,NULL,NULL,20,NULL,'2022-09-26 14:23:56','2022-09-26 14:23:56');
/*!40000 ALTER TABLE `user_informations` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `users`
--

DROP TABLE IF EXISTS `users`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `users` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `first_name` varchar(191) NOT NULL,
  `last_name` varchar(191) DEFAULT NULL,
  `document` varchar(191) DEFAULT NULL,
  `phone` varchar(191) DEFAULT NULL,
  `active` tinyint(1) NOT NULL DEFAULT 1,
  `online` tinyint(1) NOT NULL DEFAULT 0,
  `multiple_session` tinyint(1) NOT NULL DEFAULT 0,
  `email` varchar(191) DEFAULT NULL,
  `password` varchar(191) NOT NULL,
  `last_session` varchar(191) DEFAULT NULL,
  `pns_id` varchar(191) DEFAULT NULL COMMENT 'es el id que le asigna la plataforma de notificaciones push al usuario',
  `rol_id` int(10) unsigned NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `remember_token` varchar(100) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `users_email_unique` (`email`)
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `users`
--

LOCK TABLES `users` WRITE;
/*!40000 ALTER TABLE `users` DISABLE KEYS */;
INSERT INTO `users` VALUES (1,'AlianSAP',' Consulting','99999999',' 3064475',1,0,0,'superadmin@aliansap.com.co','$2y$10$G0sMw0FTpbiUWIN0UQXNUuHpUC7MAwbXXuTRw68SIWGQqZE1qSZcu',NULL,NULL,1,NULL,NULL,'2020-09-29 17:21:32','2020-09-29 17:21:32'),(2,'Invitado',' Invitado','123456','123456',1,0,0,'invitado@invitado.com.co','$2y$10$5A73vzrBIT8ZYW/fCrOYC.Bi9ZdCynmsj8aDlEmS/HJkXUQMVkaDO',NULL,NULL,4,NULL,NULL,'2020-09-29 17:21:32','2020-09-29 17:21:32'),(3,'Técnico',' Aliansap','1234567','1234567',1,0,0,'tecnico@aliansap.com.co','$2y$10$k8uNiz3O.pGelXmIxRgzHuzY4Hz1zE6q6Ld9wFXFSVvIA9eP.snJy',NULL,NULL,6,NULL,NULL,'2020-09-29 17:21:32','2020-09-29 17:21:32'),(8,'Dim','Test',NULL,'315632589',1,0,0,'test@test.com','$2y$10$MlozPf8tAQslztfoSpd9r.ax0.9FFuBSoZPbZ7l1n6NQ8bwQhevu6',NULL,NULL,4,NULL,NULL,'2020-11-05 05:28:00','2020-11-05 05:28:00'),(9,'Francisco','Restrepo','123456789','3162844777',1,0,0,'francisco.restrepo@aliansap.com.co','$2y$10$seqRQdimdsb2Kwmql933muzq2v6wpo/91dKntSPG1mut85WqDqyvy',NULL,NULL,1,NULL,NULL,'2020-11-06 15:03:53','2020-11-06 15:03:53'),(10,'johan','Padilla',NULL,'61356864',1,0,0,'johan.padilla@allup.com.co','$2y$10$D2RgkHIXl4wOE3SnWTwlzeJu0Q2Rkn3Tx2NLIg7zXA7eRbVhe1j.K',NULL,NULL,4,NULL,NULL,'2022-05-05 12:19:15','2022-05-05 12:19:15'),(11,'Francisco','Restrepo',NULL,'3162844777',1,0,0,'frestrepo84@gmail.com','$2y$10$DDo/4im4H8WXH3K/kvRkOeGcR37RwbFnB7Qbccu5cZlwtW3iu/5JC',NULL,NULL,4,NULL,NULL,'2022-05-06 19:52:45','2022-05-06 19:52:45'),(12,'johan','padilla cuéllar',NULL,'310646264',1,0,0,'johan@gmail.com','$2y$10$0UW/67aHC/eLqKWIplHnzuOhaWy/Xg3jdbMAn8AiYebPIMOjVl3P6',NULL,NULL,4,NULL,NULL,'2022-05-10 13:01:07','2022-05-10 13:01:07'),(13,'luz a','fa',NULL,'3125643853',1,0,0,'luz@gmail.com','$2y$10$m/CD9u929nw2jABMH1DWqOuhm2Bef3LriepYsqdGl67uOQ9kp26m.',NULL,NULL,4,NULL,NULL,'2022-05-11 20:15:35','2022-05-11 20:15:35'),(14,'juan','alcazar',NULL,'3125633653',1,0,0,'juan@gmail.com','$2y$10$fdwL02cQU2jyxHwrNVQY4uZ/rMUSjGbrB1gchBx8z.cC76DSzY60W',NULL,NULL,4,NULL,NULL,'2022-05-11 20:52:28','2022-05-11 20:52:28'),(15,'Alvaro','Barco Andrade',NULL,'990289139',1,0,0,'abarcoa@usmp.pe','$2y$10$mzOXTRuXlnWxopN44BDYNOY.EPbmQNbP05JLEak9jq1JvD79Uvyj6',NULL,NULL,4,NULL,NULL,'2022-07-01 16:30:33','2022-07-01 16:30:33'),(16,'Carla Valeria','Redhead Alvarado',NULL,'953222143',1,0,0,'carlaredhead667@gmail.com','$2y$10$08W0XSkf0VobtHXTXmtOseGpZkUD38Pg3AaqPAm68Qo9TAGsyrY7G',NULL,NULL,4,NULL,NULL,'2022-07-01 17:24:12','2022-07-01 17:24:12'),(17,'Sve','Chang',NULL,'986185776',1,0,0,'svelivchang@gmail.com','$2y$10$/08u9IgiFKWF4ZSDsVIby.U98hz27g7MR7sy033REjC.EsIjf7.yO',NULL,NULL,4,NULL,NULL,'2022-07-02 19:06:47','2022-07-02 19:06:47'),(18,'lazlo','pacheco pretell',NULL,'975152987',1,0,0,'lazlopapre10@gmail.com','$2y$10$D5mCYSVoTaFM.Wn.BDqs6.Ej68oE2YLxcD6GVr.qVYtkAQiGUfp3.',NULL,NULL,4,NULL,NULL,'2022-08-31 20:15:46','2022-08-31 20:15:46'),(19,'FRANCISCO','RESTREPO','940745859','3162844777',1,0,0,'francisco.restrepo@teky.com.co','$2y$10$gU0aZ2GdINUBlxXzEFn.duLBQ0jLxZK5knNuu7D.ILwx9Ukh8jONW',NULL,NULL,1,NULL,NULL,'2022-09-16 14:26:45','2022-09-16 14:26:45'),(20,'Álvaro samuel','Casahuillca Castillo',NULL,'939927714',1,0,0,'samuel_ghost000@hotmail.com','$2y$10$2mWbMOY8ApFb8ONzKz400u8tx3O7BCAQneFCC/Tb1TzZPlLQsfQPq',NULL,NULL,4,NULL,NULL,'2022-09-26 14:23:56','2022-09-26 14:23:56');
/*!40000 ALTER TABLE `users` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Dumping routines for database 'usmp_main'
--
/*!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 2024-10-19  4:04:56
@ Telegram