File: //home/ubuntu/aurora/realcartagena_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: realcartagena_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: `realcartagena_main`
--
/*!40000 DROP DATABASE IF EXISTS `realcartagena_main`*/;
CREATE DATABASE /*!32312 IF NOT EXISTS*/ `realcartagena_main` /*!40100 DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci */;
USE `realcartagena_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,'REAL CARTAGENA 🟡🟢','https://fanaticadas.s3.amazonaws.com/sportscrowd/realcartagena/web_customization/teamLogo.png','https://fanaticadas.s3.amazonaws.com/sportscrowd/default/web_customization/background.svg','MIL','#19203D','#2B4E98','#19203D','#2B4E98','2021-05-01 21:47:42','2021-05-01 21:47:42');
/*!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',4);
/*!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.0.0','1.0.0','com.co.fanaticadas.sportscrowd.realcartagena','123456',1,NULL,NULL,NULL,NULL,NULL,'2021-05-01 21:47:42','2021-05-01 21:47:42');
/*!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 ('secretaria.admin@envigadofc.co','$2y$10$TzBnkdd2ebO8u.N6/C.KMewBxhCt7/9OR70ectvNzc6ckkRwJPk5S','2022-12-12 00:52:15'),('manuelrojas7111@gmail.com','$2y$10$TTNGcz7EMOfGvFx5VV5.jOZ9i72AL0lZ0a7XJJ6GlD8vuY3rYlRee','2022-12-12 16:16:15'),('katherine.gallego@outlook.es','$2y$10$l0bsgt9RGNSNq7M4/oIDpeOEkiylhCEppawPal9.GbqCZpF1dsEQe','2022-12-17 22:07:03'),('dmoreno0428@gmail.com','$2y$10$cmAbTsovBbq.72trILIZpuOumTQm6JiQD0OzvPeSvDRsAa07KRlLi','2022-12-18 01:59:14'),('Nrestre26@gmail.com','$2y$10$yiJk9Pvxv4SxRm3M6UYiY.mjqef9el7Nn/H255pdAIvRUuOpCnKpa','2022-12-19 17:04:16'),('elianaalejandra0724@gmail.com','$2y$10$LPD.DbchEk8LYdUOMTyGU.E2D02sANSCjUYbgsYhCxIefrtoiUUE6','2022-12-20 03:14:39'),('natacarranza@gmail.com','$2y$10$UyCg9DkI788Uu3eiLdb.2uBj.C492z..cNPaKUxsNnEabpGjL3yKe','2022-12-20 19:16:34'),('aleja220593@gmail.com','$2y$10$luC6sEhc6fi71rK3h10MK.pNb4OTJW/eInrXuSgZCaJo3yUglhrJi','2022-12-27 15:31:46'),('millonariosacademia@gmail.com','$2y$10$pM1K.MEc6wwVgjl2qqbZPeqdSAyftRd8EfukU/IbwbEgTglumPr.K','2023-04-13 18:24:52'),('maribeldiazbenito@gmail.com','$2y$10$lHrrO4bdtV5Io0O3Kz8UWOgFhF7SXTK847msFGUC0CPxCKcXcQKFC','2023-06-28 15:28:41'),('franciscriollopadilla@gmail.com','$2y$10$NLcawUbs0h8k1uLmEobf/uM/2xiN0sNaIgJkTgSgMlYyMIDYAdpEK','2023-06-28 16:00:32'),('arvarcas@hotmail.com','$2y$10$iIFz/cPRl9bjTgh9x8kWJeY67JFqZN/7C5bFZAOvE3/Q2RJy8Fx4O','2023-06-29 19:57:52'),('julisgomez28@gmail.com','$2y$10$coeEk6tsWXsZN2a85A1fU.GJdnj2.aDqrF0K9t5qH8sq7.omRlq12','2023-07-09 23:31:27'),('beto80nc1@hotmail.com','$2y$10$UbrW7S9K/E.0QEJaeq/okeocr2foiQKxGnWu17czIO0nBUeuqVyS.','2023-07-10 15:43:12'),('fredysierra042@gmail.com','$2y$10$2XVWRzKNQADoCfj4Sb16hegfLXOtsUzRbKLf7Ah9eNFvvI1zmzkBG','2023-07-11 15:59:59'),('claudia.largo.4035@gmail.com','$2y$10$YmQKcOu.nlAr4UtvSTBZ.ejqz7stzbjPZc1kivt2izcisI5ID7WpG','2023-07-13 19:35:52'),('erickestebansaldana@gmail.com','$2y$10$Fw5r9wvt7JUX8hczN4gFhOL5YsJB1qTZa0P0X.Ko4nxBfxkQa3OLe','2023-07-14 00:59:15'),('yirehl415@gmail.com','$2y$10$UkQ9LaxlBhJP6NvSoPaGgeZAf2IqqZW.2PElySJBRJxH18sdVW1NS','2023-07-18 23:15:46'),('cgarcia@tingenieria.com','$2y$10$DwlYORqlBKjIGDswP01qMejX..tsgDozi9NaAYBaG/qA9d.al1V3O','2023-07-19 01:29:32'),('adrianasotoalvarez75@hotmail.com.co','$2y$10$iYWEjF4lAbkTjzPh1Wz3Te/eE3b4DSJy2D.7.TZ42mwrCdalBOFTm','2023-07-19 19:35:47'),('ferchocorrea33@hotmail.com','$2y$10$4acIG0nKL20slMZRhMOPz.LbeAcoc1CzTMdPOmmWIqRdN5ARoTr8.','2023-07-19 22:45:55'),('rosaargenis@hotmail.com','$2y$10$qCF6w481XfpPnFffXQnf7.UcXt8YcS4UlAfiNilB5zoVqDNpaNVzG','2023-07-24 23:40:58'),('yhussepy@hotmail.com','$2y$10$KpRVBETFZ7dT/cPs65ohpe0xoYajEKUHJ1/nGlw510j3bKDHbdu.u','2023-07-25 14:26:14'),('saravillautista@gmail.com','$2y$10$p.Xxk5X7ChzMVfa5buN2tOtrfvvuengHz7GyGouzc5Q8RQZ6oMgJC','2023-07-25 16:29:25'),('mican.santiago18@gmail.com','$2y$10$fRSBrJj8rQ73QWTB7.CZ.uhZXrNSeOIDxHGaE.8Vg/NGygA2qwys.','2023-07-25 17:01:58'),('hector2278@hotmail.com','$2y$10$8ZbVVQFD5FOhOuWFh02lMOH7Ui3Js7PMgV9p4qdr3wG2yyAkIdo4.','2023-07-26 15:17:18'),('maox80@yahoo.com','$2y$10$AYgF64lVNjhWvYjhuvvnrOViFAdXQFvoXaWXBC7hUZWz54qzdbbNm','2023-07-26 18:53:17'),('vivianpaolamoreno@hotmail.com','$2y$10$FVSCoezG6BlGFVH/2rV1Ve7VaT98vwDBCuALBhfEF4mqaZTZq4YcC','2023-07-26 19:05:59'),('chavitocho8@outlook.com','$2y$10$QCtNQ3h0P0rRdQJe2IVDIORwx3q1.7ZjSMhQ35b1rHB9zcWClj/za','2023-07-28 12:12:33'),('fredyehg@yahoo.es','$2y$10$fRynEIdVPqbct66ghBCbReQprzG648HKfpY/Z7ge7A1IPa5ILQ4Ai','2023-07-28 17:03:19'),('kevincastrotorres5555@gmail.com','$2y$10$Cs7m39WTpF19eNly9fZN5uKZBvvK5jtoiBrzmGpO/yzEm.6LJvTxS','2023-07-29 03:09:29'),('santyalvarez032312@gmail.com','$2y$10$I29PRaMVUeSqzewaA0I91uiPnk6gMtWmrEFOTgUWZAHrCpaOeaDCS','2023-07-29 13:26:37'),('sebasamayamillos@gmail.com','$2y$10$uMtsaMWB//0bzn3XlSegR.kNaZNaehCSc.A6HyBmDRbhz87GEkvX2','2023-07-29 20:11:52'),('libardolopez2008@hotmail.com','$2y$10$gJepvpH/xgayXTsmIwbReu/lnKQRnDYU4Lfin06VBAeRl5M.oiS/.','2023-07-29 20:15:24'),('manuelalexandercamacho.1993@gmail.com','$2y$10$EQlEFPkpuZ4G.MDinFd2CO2xGxqqax/dJFlJlx19tfEv9wwm9KFCy','2023-08-01 03:55:25'),('gevigaro@hotmail.com','$2y$10$IEmOUZAN3XwhHAd5PfVKK.jlafJuzFKa0rq8oQI19JOBrAmL5QyN2','2023-08-01 18:24:14'),('yormarycardenasroa@gmail.com','$2y$10$E2xBPUVJUbkThsylcux/c.mlnGlpCEZO2iH3MFW8pncdYSNCFj9dm','2023-08-02 13:30:50'),('kate245gonzalez@gmail.com','$2y$10$Yyp4YCBYlux4p8Aqyzl/n..3xCdS0NuR4SZ/DCWmDz86A5Cekk9qC','2023-08-02 23:19:59'),('kinito27@hotmail.com','$2y$10$fqqrypDqrJr4W5UNOZ5yQenogp8.vxpKiZ/8dUdiPEJMRbFomewCu','2023-08-04 03:29:38'),('gonzalesilva1@gmail.com','$2y$10$TwJK7Q2STgqgqx48bKzuPuuMFBOgKniag8N2pIISRpzTsKfbfiXO6','2023-08-04 23:03:57'),('fesalimentos@gmail.com','$2y$10$Avl2lij8S0ksErHXLym3hODTAFi2Ipt/0HrJeiS33DMWy/3ydB4s2','2023-08-05 15:02:51'),('oscar.ponce.45@hotmail.com','$2y$10$3fQ9OZkFWTNR/dxE4fMbLOYEp15lixEJZrGd.Fmkh5/.tg4AVs4Pu','2023-08-05 22:41:32'),('rafaelcastrosanchez10@gmail.com','$2y$10$51723OhtJDm2fEG.yaXzVOdSf.v3U741CNrVLmad1HhpA.DqWQ4di','2023-08-05 23:42:30'),('galindo1250@hotmail.com','$2y$10$GdHeGF76TN7bJMJjrOSuGO9jbtWLd5J.IgmnbP4o7vqe5dgLSrSNq','2023-08-07 01:27:27'),('saraladino51@gmail.com','$2y$10$2IbiCBuq9bpkip6jeEPZt.x3FcDuTtxkSRTIY8bQv6zHsK7U64812','2023-08-07 17:27:36'),('jorivasro@hotmail.es','$2y$10$zWfvBl47cYj8LhCOh4z2iO0rixv7KhqCO1Cv522sqoZfImSkUk.ym','2023-08-07 22:14:14'),('eliana2017.2104bog@gmail.com','$2y$10$HUVYHNT.YZRYiLa4OIScX.IRHe4RQoHF19N6pf0Dbf4eDQwAty1tK','2023-08-09 01:42:48'),('cesar1010179140@gmail.com','$2y$10$7AJ6lRZJty6CJ2cLXnDub.kuueo6Q8xb.Sfg7vmis9WqHxNODkF5.','2023-08-09 11:26:10'),('jahernane@gmail.com','$2y$10$vxl28hzJweDf.ZPCe5ia4OtdP3JkvTiAi8Oo0sgokg4/6DyoAxkC.','2023-08-09 14:55:58'),('am0872279@gmail.com','$2y$10$o1YQUhJTz//MsJQNIXZDMOdQv4ntYXXQWbgsIVMofgpWmwCR.FCGC','2023-08-09 16:40:07'),('carolinaperaza03@icloud.com','$2y$10$lE2Mbd7yn9SOpH3Jsaj1.eP1IWBIJisMvBhmsIHRpufgd66O/qiwy','2023-08-09 19:47:10'),('nubiaar978@yahoo.com','$2y$10$HLqSVxZQIT6cp2NWBycRCu4z9BGo7IObWXlcbEL0FoFzG.l5g//pS','2023-08-10 10:17:24'),('jcamilo0179@gmail.com','$2y$10$EJKOc.hYD20gguLVPStWi.49bWa7teqVQQ6rbpxzqlJ9EnukBd5NO','2023-08-10 20:38:43'),('latellyjr@gmail.com','$2y$10$RuIAgxc26OVWvyrwQy2Ty.64f.LwrRIuTZswiSlkcg6ivYyvheUeC','2023-08-10 23:59:55'),('titorojasroj@gmail.com','$2y$10$70oUQd8g2i4hs7SAOCZm0eW5cifJCEzRd4jHx6DkP4XgB362ysrB2','2023-08-11 21:48:29'),('jorge.diaz1822@hotmail.com','$2y$10$hKNILhp8HYSJin8OeIjYUuQkXJXAKcIftQan4.ppMEpBJJdH//Xve','2023-08-12 12:39:37'),('adrianamilgranados@gmail.com','$2y$10$/cDAn9iDf.vKTugdINxdNO9B.Sg54SUlIBsJz5Sw5shfiH05jqI6K','2023-08-12 13:39:50'),('paolirris07@hotmail.com','$2y$10$8AjODSe33LNYt.Uk6TRnC.r77EligwNnzBLlXyn6Jpb1vMmIVRSYO','2023-08-12 20:17:17'),('mosqueraluisjobino@gmail.com','$2y$10$kTwfZMRqmBkJPo18hiweF.MKFD2F8z1a7yZ6HBOCl6Qh2Hqy/DpAy','2023-08-14 19:37:27'),('Andret0918@gmail.com','$2y$10$3Po7B6k9rrEQJFLU9lv4deJw30dcv.ZjemrB8y7sk2N3SoPCLrTAy','2023-08-15 15:28:25'),('sandrapatriciamr73@hotmail.com','$2y$10$cTkXbCN2omYMMmGvmIngjOa.4xyNKAHM3K1hWLyGIxitMEsRCqCzq','2023-08-15 15:46:23'),('sandrapatriciamr73@gmail.com','$2y$10$cogBkIEIc6U/JNoEH51DpO2EEdqlFTeJGWHofzjITg5G1zDBlFQZ2','2023-08-15 19:27:09'),('caperezagudelo@gmail.com','$2y$10$oFuJ.YSe6YiRUhkWfByVmuMads93yPcQ6l3ANBhiSuNZSOg/eyO0e','2023-08-15 23:46:08'),('sebasgdw123@gmail.com','$2y$10$lG2ylQ.P5HgnOptYRVtVz.I/UXs4OyDUtgnvfRDAbSQaQSyZHYJDe','2023-08-16 22:22:28'),('castellanosandra2630@gmail.com','$2y$10$9rk8sj.zP0KnphtV7zWUUODfbBVr9snawF76uCJB6F1NX1BcB4CcC','2023-08-18 20:25:10'),('draximenaavila@gmail.com','$2y$10$6wkbxFJ/zk.6BmC88qTR2OVJDsuHFZTFOkzqTt53f.kR/Qf.93PG2','2023-08-18 22:04:59'),('wilmerbp2013@gmail.com','$2y$10$XdNaXpyJ0ZK9AUBxqm6qoeEcHC2h20fmM/R3C8NA4E1gTOIdVR2zS','2023-08-19 01:15:23'),('osneycelisocampo@gmail.com','$2y$10$g/RG59NcHBiQKIVPa9KRGOXrrIOfcFHsugmbLifBCWbqFhlTnn96G','2023-08-19 03:54:10'),('gabrielarcangelro3@gmail.com','$2y$10$P47DVSJLo6iLFxcIsw769.AuRrKezWtsqI4Z4lh1WSXBmbFT/TJ4.','2023-08-19 12:48:12'),('overdocar.colon@gmail.com','$2y$10$.9Msa9TgFrjdY.2hCFf5BOBL2iMex/nkMqNBhPKJFB.iMEnyDUfPq','2023-08-19 20:10:32'),('stivenurbano7@gmail.com','$2y$10$XEW/PiKHWr6UNyXzZ0A8cunS7xRLsOcrDmrrEzXwYEgZbMNkL/S2W','2023-08-23 21:59:37'),('damiranda77@hotmail.com','$2y$10$ZFhC0PeAz6zv5aMwIfSMieXLO7E384GIQ98LP9CFjNsXoE6.NFlC6','2023-08-24 01:43:58'),('af9727450@gmail.com','$2y$10$GGikJM3CmibG0RyJpwLH2uezY9nQIj2QO2xtGogEd9083MBMyPmna','2023-08-25 02:12:27'),('dimimol4213@gmail.com','$2y$10$2VTt6JrUi9dPnhCit.xryuVQcBOgpwhdDg5fbYqELo0YrhjEBlhla','2023-08-25 02:27:24'),('clinicasorthodoncia@gmail.com','$2y$10$ArTSBLYNNDRl.dA9a794H.dryeXLwk3lfRN1Aq9cI.5o7.46nV7ma','2023-08-25 11:02:14'),('margarita.0227@hotmail.com','$2y$10$2Yw3xtB9uuPsJ2mYlY9dbevTeCNHXuNa1shWXte9hO4tSQaLGIaeq','2023-08-26 22:41:20'),('paulavalbuena1119@gmail.com','$2y$10$xacY3lSO6r1hjwd6NgJDuuRxq0XkJJtcr7XV7UWziWkNGUdSsNOqK','2023-08-26 23:45:12'),('jeloagupa_15@hotmail.com','$2y$10$kDsm35ifp9tpbERUraRnq.ZwrAaHPoHbxIrfIHqf75F.4UygzdNwm','2023-08-27 00:24:10'),('segurostodos@hotmail.com','$2y$10$a93pQAUUBKsAZ2ZHXpfG2OukVJw6AE/5jLPtE5vdyLA7wEW9OFTqq','2023-08-27 12:04:36'),('dillancarvajal@olayista.com','$2y$10$1mR4R0HKU78w3nH.rc92auWED7D0NStK92pp2hoAQ3ZpbMXDOocfa','2023-08-28 17:46:47'),('anece1971@gmail.com','$2y$10$fGFN3VCExilc5hQ/ngty.uTMPAc2t3ZXurl47bco2SoefThPTnkk6','2023-08-28 20:14:09'),('jenifergonzalez391@gmail.com','$2y$10$pxXIsDJE5xqvDBmaaItsSeV.x/Aa4l6Ds0mR14CeLkcU.d.6ZKvYG','2023-08-29 18:56:37'),('bray.pache@gmail.com','$2y$10$Jkkni8jt6AaNFfYo/3MC8.TXnxEn2/m1JcSSjvlNgsYUK8tyuyGzK','2023-08-30 12:30:00'),('sanmidre2006@hotmail.com','$2y$10$cjqiivMnl/qFYv6fjfF3ZOSK9erNDyBsgTOg3GKfh3pSO2phHOV36','2023-08-30 13:09:39'),('jonathansteeddk@gmail.com','$2y$10$qwayRwCXfwEA708ZYfW42uKsucBb5VyEVyyamK.BJVrkF4/ApFZ7q','2023-08-30 15:35:48'),('franaruiz@hotmail.com','$2y$10$EP7tYs/q6I3M0EoAxfBodO4AN6.b1wq9.L.N5nIChrDCyQ00.DIRC','2023-08-30 21:18:42'),('mauriciobernala@gmail.com','$2y$10$TS9riKsOD9EHwbynFBcJZOisHnDzEjRCN/EY12zPAGVpfbnIjnUEa','2023-08-31 15:53:37'),('malgarafa@hotmail.com','$2y$10$0KbknBuvKBU.lIoVM5OYWO/vlG443m/TrUVASXpAD6X8igLYZP246','2023-08-31 22:58:30'),('josesales88@hotmail.com','$2y$10$EWMvYCDDVhch4UrpbI/lEOYvxrsQeYvOi5Es8aU4uerF2y/.Ljd2W','2023-09-02 16:01:12'),('pipeyesteban1227@gmail.com','$2y$10$Rjod9l6jGE1eqgdOZ2mF.uuETMAZozOTSszTGTW5CGPrtHWUvOyoS','2023-09-03 14:58:10'),('karittho@hotmail.com','$2y$10$nk/fQYBPSUMUdvaF7EGmG.prLdJ3BT/0wuN.FJAmKBWc0B8q0glxy','2023-09-05 01:25:40'),('pedronel82@hotmail.com','$2y$10$SFoDMKmcz71FXTpdORJr1uMjz/67KT2SAlr9kUBy0KTsF6dQUU9.i','2023-09-05 19:23:43'),('sanmidre1985@hotmail.com','$2y$10$rPhNCbeh2jYqYexiWhierOhnACy4AQgNb01Dlesg2Sab4wbbkBJRe','2023-09-06 15:20:24'),('niodiana@yahoo.es','$2y$10$/4WHf30jFUDspkI8wk.PCejUT484XCTJvaWQ6qNzReSQJxS33sBBW','2023-09-08 10:55:46'),('jgonzalzruiz@gmail.com','$2y$10$jQ5UF3rFiR9cTW4BQXuz2e1W7iws3GOMSanm4okkkFJUab.ApO1T6','2023-09-10 22:34:55'),('liamc1561@gmail.com','$2y$10$o4Xm5jkgfnL56XQbjq49T.Q7vTEke0oi2ifFLlQEBwbd3O2mOT8kS','2023-09-11 23:20:42'),('rozostella@hotmail.com','$2y$10$zd3HOUtbmJA9VvSSmssquuPfDwUcg29kPUGIv0kD.7ecaBF5ep8aC','2023-09-12 15:54:59'),('miguelgonzalezb74@gmail.com','$2y$10$rFmBhDmXw9iRectorDGLa.JYTPEOEG2MwELNNAnE5rfFlrWNOzvMW','2023-09-13 00:14:24'),('danimatallana0112@gmail.com','$2y$10$P8WpoKKnPIrt1rx96dvip.96BNdGfBk3JOuAerb5Om3E24q6Qnnna','2023-09-16 01:41:25'),('malgarrafa@hotmail.com','$2y$10$RP4a0kZ84AG9on6plkQeTOa8ijQ/qCXasBAB.3/rex2B9Y1hboloG','2023-09-17 15:10:08'),('lorenasam2609@gmail.com','$2y$10$jAZ0SLyRAtAqNRFR4NqVKuOIRWvPeLr81DkYJNzD8a37ZWL3YGW5i','2023-09-18 13:06:06'),('Rasec_1976@hotmail.com','$2y$10$kSccebM.9sZRhBjUORadwe3O2SRlrGg/ZqOX/GI26koKcmIoGOXgy','2023-09-19 02:08:51'),('taticaespe@hotmail.com','$2y$10$itfb73bYo93nR3x1P.fcSuiBmEW6/n0P18y8k/wU0qfwehQki9UYa','2023-09-19 20:28:58'),('dapaonana@hotmail.com','$2y$10$hd7nov5RN8HaZny4jQHtqeF4c9lVIFbBzqNP6gr2uaS8SpS4QfV12','2023-09-21 20:57:47'),('sandrashd@hotmail.com','$2y$10$dq9.s4P3T16CNV1wLOGIH.ru.1DF6vlhGiA6EpPoLDkZQmq.ZAFqO','2023-09-21 21:44:03'),('amanda6garzon@gmail.com','$2y$10$GqwPCezusd9KHAICe5JbAeILY8UmUqb36zHaqYkIv.wjwg8lIHG7a','2023-09-22 03:53:12'),('25juancho96@gmail.com','$2y$10$PLb/UaMwKCw2CPrA5TZ4w.EdSvWb2f/gj6VKxKQEnBdBHGk71qt2i','2023-09-22 23:58:46'),('yolandararo@hotmail.com','$2y$10$nFKV0KxkVPe/tDcoMEmBqeL1b4weIycLsKnIMf3Qlj6dypLX1f406','2023-09-23 13:28:03'),('valentinaduque332@gmail.com','$2y$10$UJUtdE9zt2Zo.39KW6PnsO8MelrHXINCWwf2lrHogXkpy.grnyu3e','2023-09-25 21:14:25'),('jahvier_64@hotmail.com','$2y$10$ki7Msedrn/QKz20c4Lm4/epXTCuYAbzpWn4xbCF.ZaCWcZ2VPduOK','2023-09-26 11:14:59'),('cesar_cor13@hotmail.com','$2y$10$NBK1PDrwlg./.D83c.pjO..Zr9rhf78Kt7m2J.T8Byf7u9amVleSG','2023-09-26 18:37:10'),('gilbertjavier10@gmail.com','$2y$10$r96L1QLJd6cKtUreP4Iup.ittgRr7jbKDt.9tNYisQnj4RJiXIBUq','2023-09-27 00:49:55'),('alherc@gmail.com','$2y$10$ghlS4.piUcKV5HGyD3gDReEaDSc4q6RLm1GActGuBDdQzo1tAfeIW','2023-09-27 20:57:38'),('jhoanrojas2013@outlook.com','$2y$10$acliro7/qgsujZw6qzDRM.Gccdh2HD2vvF.T.9Ay5kpLX70MdVTyu','2023-09-29 13:57:02'),('samuelfferrero@gmail.com','$2y$10$K3SnujT2NJMCZtLNauuP6O8DC1b3UA9bD5wo9DsK.ph3ddJsnhYTi','2023-09-29 14:30:27'),('brayan201817@hotmail.com','$2y$10$WZD46v.IpvAuWm6RrE657eXiuMlQd2RhAKiCzV8aUJTlZR3v4A6RC','2023-09-30 11:07:10'),('yeisonfcg@gmail.com','$2y$10$bpA4xTApehfqICi8DIZ5TOGrLPzUutxytyaDDZrQqpAfv9/k9OMFe','2023-09-30 12:08:54'),('andypicsys97@gmail.com','$2y$10$UwDoPaMx.WKlbenTSNJuy.XuZHs.MIs1uiEcn1qs1JoaZZt6H0RQS','2023-10-03 16:27:13'),('nicolaslozano2019@gmail.com','$2y$10$T0u1vFWi1SBLfQJ22lpXh.VWViOgRuxQwIPLvmvut1LCRTGLshGhi','2023-10-05 06:38:20'),('locktomi1421@gmail.com','$2y$10$SjHtNDtCW/xUzw8gL6WGI.AToZH.tBom8nN9B/US576nfYB4yB32y','2023-10-07 04:12:58'),('luisdejesus1953@gmail.com','$2y$10$kW62nHWIYrZaRmqMkAoKfOP.GFnclNufUAvM1ap2xrk1jmCpIpSZu','2023-10-07 18:37:14'),('isacami1221@gmail.com','$2y$10$KIMNmHw3d4.7NNG1aMY6aORCSfnz9mWvUWAnA9k3Y.onwiSWXYdiC','2024-09-10 07:59:33'),('isacami99@outlook.es','$2y$10$YDRe8CVsJQAJn.LsbLi/nuQOKhdEqGqW58X6sadKHur63DFYh12xi','2024-09-10 08:00:21');
/*!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=5 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,'Cartagena',1,'https://realcartagena.sports-crowd.com/api','https://realcartagena.sports-crowd.com','https://fanaticadas.s3.amazonaws.com/sportscrowd/realcartagena/','cali-db',0,'2021-05-01 21:47:42','2021-05-01 21:47:42');
/*!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 AUTO_INCREMENT=16 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 */;
INSERT INTO `term_clients` VALUES (1,1,1,1,NULL,'2021-05-01 21:47:42','2021-05-01 21:47:42'),(2,1,1,2,NULL,'2021-05-01 21:47:42','2021-05-01 21:47:42'),(3,1,1,5,NULL,'2022-05-12 19:22:56','2022-05-12 19:22:56'),(4,1,1,6,NULL,'2022-05-27 22:07:33','2022-05-27 22:07:33'),(5,1,1,7,NULL,'2022-05-31 21:01:53','2022-05-31 21:01:53'),(6,1,1,8,NULL,'2022-07-14 21:36:06','2022-07-14 21:36:06'),(7,1,1,9,NULL,'2022-08-23 13:48:18','2022-08-23 13:48:18'),(8,1,1,10,NULL,'2022-08-25 15:09:26','2022-08-25 15:09:26'),(9,1,1,11,NULL,'2022-08-25 15:10:01','2022-08-25 15:10:01'),(10,1,1,10,NULL,'2024-09-04 00:00:10','2024-09-04 00:00:10'),(11,1,1,11,NULL,'2024-09-07 19:29:31','2024-09-07 19:29:31'),(12,1,1,12,NULL,'2024-09-08 10:04:00','2024-09-08 10:04:00'),(13,1,1,13,NULL,'2024-09-08 16:38:20','2024-09-08 16:38:20'),(14,1,1,14,NULL,'2024-09-09 07:03:01','2024-09-09 07:03:01'),(15,1,1,15,NULL,'2024-09-15 21:43:25','2024-09-15 21:43:25');
/*!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/millonarios/public/terminos_y_condiciones_millonarios.pdf','1',1,'2021-05-01 21:47:42','2021-05-01 21:47:42');
/*!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=16 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,'2021-05-01 21:47:42','2021-05-01 21:47:42'),(2,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,NULL,1,2,NULL,'2021-05-01 21:47:42','2021-05-01 21:47:42'),(3,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,NULL,1,3,NULL,'2021-05-01 21:47:42','2021-05-01 21:47:42'),(8,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,1,1,NULL,NULL,8,NULL,'2022-07-14 21:36:06','2022-07-14 21:36:06'),(9,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,1,1,NULL,NULL,9,NULL,'2022-08-23 13:48:18','2022-08-23 13:48:18'),(10,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,1,1,NULL,NULL,10,NULL,'2024-09-04 00:00:10','2024-09-04 00:00:10'),(11,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,1,1,NULL,NULL,11,NULL,'2024-09-07 19:29:31','2024-09-07 19:29:31'),(12,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,1,1,NULL,NULL,12,NULL,'2024-09-08 10:04:00','2024-09-08 10:04:00'),(13,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,1,1,NULL,NULL,13,NULL,'2024-09-08 16:38:20','2024-09-08 16:38:20'),(14,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,1,1,NULL,NULL,14,NULL,'2024-09-09 07:03:01','2024-09-09 07:03:01'),(15,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,1,1,NULL,NULL,15,NULL,'2024-09-15 21:43:25','2024-09-15 21:43:25');
/*!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`)
) ENGINE=InnoDB AUTO_INCREMENT=16 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$LFNNHjLHp6R0.GcgHDFepOjbUxIFyZ7bzDiWcxGnxfgoiEOXPyKce',NULL,NULL,1,NULL,NULL,'2021-05-01 21:47:42','2021-05-01 21:47:42'),(2,'Invitado',' Invitado','123456','123456',1,0,0,'invitado@invitado.com.co','$2y$10$XfNll/R7da5b6iydPmt53.M3tRZrZfQG7Y/e5jKWKmGFcU0oS2oeO',NULL,NULL,4,NULL,NULL,'2021-05-01 21:47:42','2021-05-01 21:47:42'),(3,'Técnico',' Aliansap','1234567','1234567',1,0,0,'tecnico@aliansap.com.co','$2y$10$2S6wsa1TrsR4Ji50jwbuh.QSkN.SR.ekP3n1/OqdXQH0/aQGx1xkC',NULL,NULL,6,NULL,NULL,'2021-05-01 21:47:42','2021-05-01 21:47:42'),(8,'Test','SC','123456789','3162844777',1,0,0,'test@test.com','$2y$10$jRcZ4UpqnMkp5N9.iIX6b.WsOQfzLPgS5N1qg7MumN05NPuYYuoim',NULL,NULL,4,NULL,NULL,'2022-07-14 21:36:06','2023-08-02 19:05:18'),(9,'LUZ','GARCIA','12345','3024069368',1,0,0,'stella.garcia@teky.com.co','$2y$10$FZytUj7BUaV7.AlrplWWXuDSuuJQxWubwdcV0p7MbiCt7E7QLUFK6',NULL,NULL,1,NULL,NULL,'2022-08-23 13:48:18','2022-08-23 13:48:18'),(10,'Daniela','Grajales Tabares',NULL,'3193321725',1,0,0,'dgrajalest25@gmail.com','$2y$10$JZoMj8Xx.QwwwIJJreRjbedNiAhJrGqNN.l4/xRWQLDKY1Zh4ughS',NULL,NULL,4,NULL,NULL,'2024-09-04 00:00:10','2024-09-04 00:00:10'),(11,'Vanessa','Contreras','444545','4545454544',1,0,0,'vanessa.contreras@fanaticadas.co','$2y$10$MxmTsWV0cBrYIOL5eQb8u.NpS2Nqp6YfGMkXeeEVPZx4DTGh4FyiO',NULL,NULL,1,NULL,NULL,'2024-09-07 19:29:31','2024-09-07 19:29:31'),(12,'Junior','Castellar',NULL,'11111',1,0,0,'prueba1@gmail.com','$2y$10$VWNI3tNClQaZ93d1LhZ.f.YjQhKm.7mTm74Nu4VSb1VHxvISuTFhG',NULL,NULL,4,NULL,NULL,'2024-09-08 10:04:00','2024-09-08 10:04:00'),(13,'vanessa','contreras',NULL,'3163082222',1,0,0,'isacami99@outlook.es','$2y$10$6pTMnrzXNCh5wJsxW/NEZ.5oaPMsHPcL5igqRy26FI/k0zO9ew./O',NULL,NULL,4,NULL,NULL,'2024-09-08 16:38:20','2024-09-08 16:38:20'),(14,'CAMILO','prueba cb clave','45774545','4575458',1,0,0,'isacami1221@gmail.com','$2y$10$W8MuVo/e09SvYg7pzglLHuCebgZUUEO6Wj0Yg3fymjnA/N4mU5/PO',NULL,NULL,2,NULL,NULL,'2024-09-09 07:03:01','2024-09-09 07:03:01'),(15,'Isaac Junior','Castellar lopez',NULL,'555555',1,0,0,'jisaac197@gmail.com','$2y$10$v9gSqr94Q2GNiXSNJEDjouMLyLvQy8KnC.xa.ocsFEl0XRTkhG58G',NULL,NULL,4,NULL,'VpGTaNNABNS1XAhgBpVMeW2cdtPfCdkMI0zhXJvXxrglVdrSRixer8br2Nel','2024-09-15 21:43:25','2024-09-15 22:07:02');
/*!40000 ALTER TABLE `users` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Dumping routines for database 'realcartagena_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 3:49:01