-- MySQL dump 10.13 Distrib 8.0.45, for Linux (x86_64) -- -- Host: localhost Database: altalosc_24siete -- ------------------------------------------------------ -- Server version 8.0.45-cll-lve /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!50503 SET NAMES 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 */; -- -- Table structure for table `account` -- DROP TABLE IF EXISTS `account`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `account` ( `idAccount` int NOT NULL AUTO_INCREMENT, `user` varchar(100) COLLATE utf8mb4_general_ci NOT NULL, `password` varchar(100) COLLATE utf8mb4_general_ci NOT NULL, `checked` tinyint NOT NULL, `state` tinyint NOT NULL, `category` varchar(10) COLLATE utf8mb4_general_ci NOT NULL, `role_idRole` int NOT NULL, `visible` tinyint NOT NULL, PRIMARY KEY (`idAccount`), KEY `fk_account_role1_idx` (`role_idRole`), CONSTRAINT `fk_account_role1` FOREIGN KEY (`role_idRole`) REFERENCES `role` (`idRole`) ) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `account` -- LOCK TABLES `account` WRITE; /*!40000 ALTER TABLE `account` DISABLE KEYS */; INSERT INTO `account` VALUES (1,'maestro','$2a$10$Wwa6XvTj5.Ol9/Tx7o0LxucZemBOxiaZluup2TRfqLL6jakGW7L1K',0,1,'Principal',5,1),(2,'super','$2a$10$kQ5aAH/Snw7lKLDj7A31S.jj4Vp.YB0fnR3yjOpnUJU3vDEtPjG1a',0,1,'Principal',1,1),(5,'mireya@gmail.com','$2a$10$3F3/HaoNXcxFNeK/KcFGnOl2ncHe5xL1aKePOgyuml5GPyUUzwnXO',0,1,'Principal',1,1),(6,'karla@gmail.com','$2a$10$XAcqgpqB0f9xvjaCl1turOGbWGIM1EEireJZsOdcakwWPjY73gz8G',0,1,'Secundario',1,1),(7,'micaela@gmail.com','$2a$10$jce.Q.oVY/kzmUdLYtXl5.6Fwpgo70dEIpjT9fbZTeGHHxbf0g5Jy',0,1,'Principal',2,1),(8,'60636754','$2a$10$FRBcBjn95Jx0yMj/8xOcM.fn3OdL1SbuFjXluTuc0nbtR1qE9nnAe',0,1,'Principal',4,1),(9,'soraya@gmail.com','$2a$10$BB2dJmTspMx9SSoBf//C6Ojga5J/zT3VwwD52Fkh4MRi0xZFaJGNq',0,1,'Secundario',1,1),(10,'alexandrairusta@gmail.com','$2a$10$4jR.hQThRlKcqz1.Jq3ZYO51YC3gZa2V7LQ0pi/I/sFebEDz.LtDK',0,1,'Principal',4,1),(11,'mishelcastro@gmail.com','$2a$10$u/.XhrAtCGxOmykD6QgM1uGcAIZpt9h1gJd5b9o4LemPPueHF3PrW',0,1,'Principal',2,1),(12,'efrain','$2a$10$IxdVq7RPDfTj0boHnlq6.eXvzmtRwMNHEbWa4MvNnrC6EHo3lklW2',0,1,'Principal',3,1),(13,'efra','$2a$10$dRpyuUZidtwXLTd/jPm0LeEJY10WmwMzNlSjAhxXoXftjnHtjg9LG',0,1,'Principal',3,1),(14,'kevin','$2a$10$CV8RqMNY6We/w5fCrV5jW.fHMuyAuQgv8ux8X/9JcPYn5Or/xskHW',0,1,'Principal',3,1),(15,'sasha','$2a$10$PNSKDwtElKla6s35yEZrPu3Pokd0rMg62/uQk2VH5m2ER7auL0yJa',0,1,'Principal',3,1); /*!40000 ALTER TABLE `account` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `account_has_jurisdiction` -- DROP TABLE IF EXISTS `account_has_jurisdiction`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `account_has_jurisdiction` ( `account_idAccount` int NOT NULL, `jurisdiction_idJurisdiction` int NOT NULL, PRIMARY KEY (`account_idAccount`,`jurisdiction_idJurisdiction`), KEY `fk_account_has_jurisdiction_jurisdiction1_idx` (`jurisdiction_idJurisdiction`), KEY `fk_account_has_jurisdiction_account1_idx` (`account_idAccount`), CONSTRAINT `fk_account_has_jurisdiction_account1` FOREIGN KEY (`account_idAccount`) REFERENCES `account` (`idAccount`), CONSTRAINT `fk_account_has_jurisdiction_jurisdiction1` FOREIGN KEY (`jurisdiction_idJurisdiction`) REFERENCES `jurisdiction` (`idJurisdiction`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `account_has_jurisdiction` -- LOCK TABLES `account_has_jurisdiction` WRITE; /*!40000 ALTER TABLE `account_has_jurisdiction` DISABLE KEYS */; INSERT INTO `account_has_jurisdiction` VALUES (5,1),(6,1),(7,1),(8,1),(9,1),(10,1),(11,1),(12,1),(13,1),(14,1),(15,1); /*!40000 ALTER TABLE `account_has_jurisdiction` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `account_has_person` -- DROP TABLE IF EXISTS `account_has_person`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `account_has_person` ( `account_idAccount` int NOT NULL, `person_idPerson` int NOT NULL, PRIMARY KEY (`account_idAccount`,`person_idPerson`), KEY `fk_account_has_person_person1_idx` (`person_idPerson`), KEY `fk_account_has_person_account1_idx` (`account_idAccount`), CONSTRAINT `fk_account_has_employee_employee1` FOREIGN KEY (`person_idPerson`) REFERENCES `person` (`idPerson`), CONSTRAINT `fk_account_has_person_account1` FOREIGN KEY (`account_idAccount`) REFERENCES `account` (`idAccount`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `account_has_person` -- LOCK TABLES `account_has_person` WRITE; /*!40000 ALTER TABLE `account_has_person` DISABLE KEYS */; INSERT INTO `account_has_person` VALUES (1,1),(2,2),(5,5),(6,6),(7,7),(8,8),(9,9),(10,10),(11,11),(12,12),(13,13),(14,14),(15,15); /*!40000 ALTER TABLE `account_has_person` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `accountbankcollection` -- DROP TABLE IF EXISTS `accountbankcollection`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `accountbankcollection` ( `idAccountBankCollection` int NOT NULL AUTO_INCREMENT, `date` date NOT NULL, `bankImage` text COLLATE utf8mb4_general_ci NOT NULL, `account_idAccount` int NOT NULL, PRIMARY KEY (`idAccountBankCollection`), KEY `fk_account_bank_driver1_idx` (`account_idAccount`), CONSTRAINT `fk_account_bank_account1` FOREIGN KEY (`account_idAccount`) REFERENCES `account` (`idAccount`) ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `accountbankcollection` -- LOCK TABLES `accountbankcollection` WRITE; /*!40000 ALTER TABLE `accountbankcollection` DISABLE KEYS */; INSERT INTO `accountbankcollection` VALUES (1,'2026-05-17','/resources/images/bankMaster/1779054016038-900w-u-E_UBz_d68.png',1),(2,'2026-05-18','/resources/images/bankSuper/1779126272548-320w-e9RLKQV58po.png',5),(3,'2026-05-21','/resources/images/bankSuper/1779372007056-320w-e9RLKQV58po.png',6),(4,'2026-05-24','/resources/images/bankAdministrator/1779629112411-furNuevoImpreso.jpg',7),(5,'2026-05-24','/resources/images/bankSuper/defaultPhoto.jpg',9),(6,'2026-05-24','/resources/images/bankAdministrator/defaultPhoto.jpg',11); /*!40000 ALTER TABLE `accountbankcollection` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `assignmentfees` -- DROP TABLE IF EXISTS `assignmentfees`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `assignmentfees` ( `idAssignmentFees` int NOT NULL AUTO_INCREMENT, `dateAssignment` date DEFAULT NULL, `timeAssignment` time DEFAULT NULL, `fees_idFees` int NOT NULL, `driver_idDriver` int NOT NULL, PRIMARY KEY (`idAssignmentFees`), KEY `fk_assignmentFees_fees1_idx` (`fees_idFees`), KEY `fk_assignmentFees_driver1_idx` (`driver_idDriver`), CONSTRAINT `fk_assignmentFees_driver1` FOREIGN KEY (`driver_idDriver`) REFERENCES `driver` (`idDriver`), CONSTRAINT `fk_assignmentFees_fees1` FOREIGN KEY (`fees_idFees`) REFERENCES `fees` (`idFees`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `assignmentfees` -- LOCK TABLES `assignmentfees` WRITE; /*!40000 ALTER TABLE `assignmentfees` DISABLE KEYS */; INSERT INTO `assignmentfees` VALUES (1,'2026-05-24','18:09:57',1,1); /*!40000 ALTER TABLE `assignmentfees` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `balance` -- DROP TABLE IF EXISTS `balance`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `balance` ( `idBalance` int NOT NULL AUTO_INCREMENT, `currentBalance` decimal(10,2) NOT NULL, `account_idAccount` int NOT NULL, PRIMARY KEY (`idBalance`), KEY `fk_balance_account1_idx` (`account_idAccount`), CONSTRAINT `fk_balance_account1` FOREIGN KEY (`account_idAccount`) REFERENCES `account` (`idAccount`) ) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `balance` -- LOCK TABLES `balance` WRITE; /*!40000 ALTER TABLE `balance` DISABLE KEYS */; INSERT INTO `balance` VALUES (1,0.00,2),(4,0.00,5),(5,470.00,6),(6,450.00,7),(7,15.13,8),(8,0.00,9),(9,0.00,10),(10,0.00,11),(11,0.00,12),(12,0.00,13),(13,0.00,14),(14,54.87,15); /*!40000 ALTER TABLE `balance` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `balancehistory` -- DROP TABLE IF EXISTS `balancehistory`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `balancehistory` ( `idBalanceHistory` int NOT NULL AUTO_INCREMENT, `date` date DEFAULT NULL, `time` time NOT NULL, `amount` decimal(10,2) NOT NULL, `transaction` varchar(100) COLLATE utf8mb4_general_ci NOT NULL, `balance_idBalance` int NOT NULL, `description` text COLLATE utf8mb4_general_ci NOT NULL, PRIMARY KEY (`idBalanceHistory`), KEY `fk_balanceHistory_balance1_idx` (`balance_idBalance`), CONSTRAINT `fk_balanceHistory_balance1` FOREIGN KEY (`balance_idBalance`) REFERENCES `balance` (`idBalance`) ) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `balancehistory` -- LOCK TABLES `balancehistory` WRITE; /*!40000 ALTER TABLE `balancehistory` DISABLE KEYS */; INSERT INTO `balancehistory` VALUES (1,'2026-05-24','07:44:12',1000.00,'Recarga',5,'Sin descripción'),(2,'2026-05-24','07:57:50',500.00,'Recarga',6,'Sin descripción'),(3,'2026-05-24','07:57:50',500.00,'Recarga',5,'Recarga de saldo por solicitud de administrador'),(4,'2026-05-24','09:01:54',50.00,'Recarga',14,'Sin descripción'),(5,'2026-05-24','09:01:54',50.00,'Recarga',6,'Recarga de saldo por solicitud de administrador'),(6,'2026-05-24','09:02:40',5.00,'Pago de habilitación',14,'Sin descripción'),(7,'2026-05-24','09:13:43',30.00,'Recarga',7,'Sin descripción'),(8,'2026-05-24','09:13:43',30.00,'Recarga',5,'Recarga de saldo por solicitud de administrador'),(9,'2026-05-24','09:39:15',14.87,'Pago de carrera',7,'Descuento de saldo por pago de carrera terminada'),(10,'2026-05-24','09:39:15',14.87,'Pago de carrera',14,'Abono a saldo por pago de carrera terminada'),(11,'2026-05-24','18:03:28',5.00,'Pago de habilitación',14,'Sin descripción'),(12,'2026-05-24','18:09:57',5.00,'Pago de habilitación',14,'Pago hecho en efectivo.'); /*!40000 ALTER TABLE `balancehistory` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `categories` -- DROP TABLE IF EXISTS `categories`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `categories` ( `idCategories` int NOT NULL AUTO_INCREMENT, `denomination` varchar(70) COLLATE utf8mb4_general_ci NOT NULL, `description` text COLLATE utf8mb4_general_ci, `status` tinyint(1) NOT NULL, `visible` tinyint DEFAULT NULL, `company_idCompany` int NOT NULL, PRIMARY KEY (`idCategories`), KEY `fk_category_company_idx` (`company_idCompany`), CONSTRAINT `fk_categories_company` FOREIGN KEY (`company_idCompany`) REFERENCES `company` (`idCompany`) ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `categories` -- LOCK TABLES `categories` WRITE; /*!40000 ALTER TABLE `categories` DISABLE KEYS */; INSERT INTO `categories` VALUES (1,'Taxi','Transporte terreste urbano',1,1,1),(2,'Moto','Transporte terrestre agil en 2 ruedas',1,1,1),(3,'Camioneta','Transporte de carga',0,1,1),(4,'Carretilla','Transporte de carga',0,0,1); /*!40000 ALTER TABLE `categories` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `company` -- DROP TABLE IF EXISTS `company`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `company` ( `idCompany` int NOT NULL AUTO_INCREMENT, `name` varchar(100) COLLATE utf8mb4_general_ci NOT NULL, `businessAcronym` varchar(30) COLLATE utf8mb4_general_ci NOT NULL, `address` varchar(100) COLLATE utf8mb4_general_ci NOT NULL, `country` varchar(70) COLLATE utf8mb4_general_ci NOT NULL, `city` varchar(70) COLLATE utf8mb4_general_ci NOT NULL, `codeCountry` varchar(10) COLLATE utf8mb4_general_ci NOT NULL, `eMail` varchar(70) COLLATE utf8mb4_general_ci DEFAULT NULL, `cellular` varchar(8) COLLATE utf8mb4_general_ci DEFAULT NULL, `phone` varchar(10) COLLATE utf8mb4_general_ci DEFAULT NULL, `status` tinyint NOT NULL, `visible` tinyint DEFAULT NULL, `enabled` tinyint NOT NULL, `dateEnabled` date DEFAULT NULL, `dateNextDisabled` date DEFAULT NULL, PRIMARY KEY (`idCompany`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `company` -- LOCK TABLES `company` WRITE; /*!40000 ALTER TABLE `company` DISABLE KEYS */; INSERT INTO `company` VALUES (1,'Radio Movil 24-7','RM/247','Av. Villazon # 1777','Bolivia','Sacaba','+591','radio-247@gmail.com','76546541','465465464',1,1,1,'2026-05-16','2026-05-16'); /*!40000 ALTER TABLE `company` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `company_has_generalfees` -- DROP TABLE IF EXISTS `company_has_generalfees`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `company_has_generalfees` ( `company_idCompany` int NOT NULL, `generalFees_idGeneralFees` int NOT NULL, PRIMARY KEY (`company_idCompany`,`generalFees_idGeneralFees`), KEY `fk_company_has_generalFess1_idx` (`generalFees_idGeneralFees`), KEY `fk_company_has_generalFess2_idx` (`company_idCompany`), CONSTRAINT `fk_company_has_generalFees_1` FOREIGN KEY (`company_idCompany`) REFERENCES `company` (`idCompany`), CONSTRAINT `fk_company_has_generalFees_2` FOREIGN KEY (`generalFees_idGeneralFees`) REFERENCES `generalfees` (`idGeneralFees`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `company_has_generalfees` -- LOCK TABLES `company_has_generalfees` WRITE; /*!40000 ALTER TABLE `company_has_generalfees` DISABLE KEYS */; INSERT INTO `company_has_generalfees` VALUES (1,1); /*!40000 ALTER TABLE `company_has_generalfees` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `company_has_person` -- DROP TABLE IF EXISTS `company_has_person`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `company_has_person` ( `company_idCompany` int NOT NULL, `person_idPerson` int NOT NULL, PRIMARY KEY (`company_idCompany`,`person_idPerson`), KEY `fk_company_has_person_person1_idx` (`person_idPerson`), KEY `fk_company_has_person_company1_idx` (`company_idCompany`), CONSTRAINT `fk_company_has_person_company1` FOREIGN KEY (`company_idCompany`) REFERENCES `company` (`idCompany`), CONSTRAINT `fk_company_has_person_person1` FOREIGN KEY (`person_idPerson`) REFERENCES `person` (`idPerson`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `company_has_person` -- LOCK TABLES `company_has_person` WRITE; /*!40000 ALTER TABLE `company_has_person` DISABLE KEYS */; INSERT INTO `company_has_person` VALUES (1,1),(1,5),(1,6),(1,7),(1,11); /*!40000 ALTER TABLE `company_has_person` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `digitalcardbusiness` -- DROP TABLE IF EXISTS `digitalcardbusiness`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `digitalcardbusiness` ( `idDigitalCardBusiness` int NOT NULL AUTO_INCREMENT, `denominationBusiness` varchar(170) COLLATE utf8mb4_general_ci NOT NULL, `descriptionBusiness` varchar(170) COLLATE utf8mb4_general_ci NOT NULL, `location` varchar(170) COLLATE utf8mb4_general_ci NOT NULL, `fileCar` varchar(170) COLLATE utf8mb4_general_ci NOT NULL, `fileBrand` varchar(170) COLLATE utf8mb4_general_ci NOT NULL, `company_idCompany` int NOT NULL, PRIMARY KEY (`idDigitalCardBusiness`), KEY `fk_digital_card_business1_idx` (`company_idCompany`), CONSTRAINT `fk_digital_card_business1` FOREIGN KEY (`company_idCompany`) REFERENCES `company` (`idCompany`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `digitalcardbusiness` -- LOCK TABLES `digitalcardbusiness` WRITE; /*!40000 ALTER TABLE `digitalcardbusiness` DISABLE KEYS */; INSERT INTO `digitalcardbusiness` VALUES (1,'Radio Movil 24/7','Empresa de transporte urbano seguro.','Av. Villazon','/resources/images/card/1779055201087-logo.png','/resources/images/card/1779055201089-priusc.png',1); /*!40000 ALTER TABLE `digitalcardbusiness` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `digitalcardcontact` -- DROP TABLE IF EXISTS `digitalcardcontact`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `digitalcardcontact` ( `idDigitalCardContact` int NOT NULL AUTO_INCREMENT, `denomination` varchar(70) COLLATE utf8mb4_general_ci NOT NULL, `type` varchar(70) COLLATE utf8mb4_general_ci NOT NULL, `dataValue` varchar(170) COLLATE utf8mb4_general_ci NOT NULL, `company_idCompany` int NOT NULL, PRIMARY KEY (`idDigitalCardContact`), KEY `fk_contact_company1_idx` (`company_idCompany`), CONSTRAINT `fk_contact_company1` FOREIGN KEY (`company_idCompany`) REFERENCES `company` (`idCompany`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `digitalcardcontact` -- LOCK TABLES `digitalcardcontact` WRITE; /*!40000 ALTER TABLE `digitalcardcontact` DISABLE KEYS */; INSERT INTO `digitalcardcontact` VALUES (1,'Facebook','Link','https://www.facebook.com',1); /*!40000 ALTER TABLE `digitalcardcontact` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `digitalcardservices` -- DROP TABLE IF EXISTS `digitalcardservices`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `digitalcardservices` ( `idDigitalCardServices` int NOT NULL AUTO_INCREMENT, `title` varchar(170) COLLATE utf8mb4_general_ci NOT NULL, `description` text COLLATE utf8mb4_general_ci NOT NULL, `link` text COLLATE utf8mb4_general_ci NOT NULL, `company_idCompany` int NOT NULL, PRIMARY KEY (`idDigitalCardServices`), KEY `fk_digital_card_services_company1_idx` (`company_idCompany`), CONSTRAINT `fk_digital_card_services_company1` FOREIGN KEY (`company_idCompany`) REFERENCES `company` (`idCompany`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `digitalcardservices` -- LOCK TABLES `digitalcardservices` WRITE; /*!40000 ALTER TABLE `digitalcardservices` DISABLE KEYS */; INSERT INTO `digitalcardservices` VALUES (1,'Taxi Seguro','Transporte seguro','https://tutaxi.altalos.com/',1); /*!40000 ALTER TABLE `digitalcardservices` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `driver` -- DROP TABLE IF EXISTS `driver`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `driver` ( `idDriver` int NOT NULL AUTO_INCREMENT, `code` varchar(100) COLLATE utf8mb4_general_ci NOT NULL, `driverAcronym` varchar(30) COLLATE utf8mb4_general_ci NOT NULL, `driverLicense` varchar(17) COLLATE utf8mb4_general_ci NOT NULL, `category` varchar(10) COLLATE utf8mb4_general_ci NOT NULL, `mobileNumber` int NOT NULL, `person_idPerson` int NOT NULL, `status` tinyint NOT NULL, `company_idCompany` int NOT NULL, `enabled` tinyint NOT NULL, `dateEnabled` date NOT NULL, `timeEnabled` time NOT NULL, PRIMARY KEY (`idDriver`), KEY `fk_driver_person1_idx` (`person_idPerson`), KEY `fk_driver_company1_idx` (`company_idCompany`), CONSTRAINT `fk_driver_company1` FOREIGN KEY (`company_idCompany`) REFERENCES `company` (`idCompany`), CONSTRAINT `fk_driver_person1` FOREIGN KEY (`person_idPerson`) REFERENCES `person` (`idPerson`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `driver` -- LOCK TABLES `driver` WRITE; /*!40000 ALTER TABLE `driver` DISABLE KEYS */; INSERT INTO `driver` VALUES (1,'2713-20260524084531e8037ff0-a09d-4030-b839-785cfe89dc77','','65465','M',1,15,1,1,1,'2026-05-24','18:09:57'); /*!40000 ALTER TABLE `driver` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `driverchangedrequest` -- DROP TABLE IF EXISTS `driverchangedrequest`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `driverchangedrequest` ( `idDriverChangedRequest` int NOT NULL AUTO_INCREMENT, `dateRequest` date NOT NULL, `timeRequest` time NOT NULL, `statusRequest` tinyint NOT NULL, `observationRequest` text COLLATE utf8mb4_general_ci, `driverLicence` varchar(17) COLLATE utf8mb4_general_ci DEFAULT NULL, `category` varchar(10) COLLATE utf8mb4_general_ci DEFAULT NULL, `mobileNumber` int DEFAULT NULL, `driver_idDriver` int NOT NULL, `visible` tinyint NOT NULL, PRIMARY KEY (`idDriverChangedRequest`), KEY `fk_vehicleChangedRequest_driver1_idx` (`driver_idDriver`), CONSTRAINT `fk_vehicleChangedRequest_driver1` FOREIGN KEY (`driver_idDriver`) REFERENCES `driver` (`idDriver`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `driverchangedrequest` -- LOCK TABLES `driverchangedrequest` WRITE; /*!40000 ALTER TABLE `driverchangedrequest` DISABLE KEYS */; INSERT INTO `driverchangedrequest` VALUES (1,'2026-05-24','09:03:04',1,'Cambios aprobados','65465','M',1,1,1); /*!40000 ALTER TABLE `driverchangedrequest` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `fees` -- DROP TABLE IF EXISTS `fees`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `fees` ( `idFees` int NOT NULL AUTO_INCREMENT, `code` varchar(100) COLLATE utf8mb4_general_ci NOT NULL, `denomination` varchar(70) COLLATE utf8mb4_general_ci NOT NULL, `duration` varchar(17) COLLATE utf8mb4_general_ci NOT NULL, `type` varchar(70) COLLATE utf8mb4_general_ci NOT NULL, `amount` decimal(10,2) NOT NULL, `startTime` time NOT NULL, `endTime` time NOT NULL, `date` date NOT NULL, `time` time NOT NULL, `status` tinyint NOT NULL, `visible` tinyint NOT NULL, `company_idCompany` int NOT NULL, `categories_idCategories` int NOT NULL, PRIMARY KEY (`idFees`), KEY `fk_fees_company1_idx` (`company_idCompany`), KEY `fk_fees_categories1_idx` (`categories_idCategories`), CONSTRAINT `fk_fees_categories1` FOREIGN KEY (`categories_idCategories`) REFERENCES `categories` (`idCategories`), CONSTRAINT `fk_fees_company1` FOREIGN KEY (`company_idCompany`) REFERENCES `company` (`idCompany`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `fees` -- LOCK TABLES `fees` WRITE; /*!40000 ALTER TABLE `fees` DISABLE KEYS */; INSERT INTO `fees` VALUES (1,'3047-202605240811205ea8600e-26c1-434e-bd7e-ec5a401e1154','Regular','24','Hora (s)',5.00,'00:00:00','00:00:00','2026-05-24','08:11:20',1,1,1,1),(2,'3070-202605240812077bead091-70e4-4350-aab5-45212fb87c59','Tarde','6','Hora (s)',2.00,'12:00:00','18:00:00','2026-05-24','08:12:07',1,1,1,1); /*!40000 ALTER TABLE `fees` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `feestaximeter` -- DROP TABLE IF EXISTS `feestaximeter`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `feestaximeter` ( `idFeesTaximeter` int NOT NULL AUTO_INCREMENT, `denomination` varchar(70) COLLATE utf8mb4_general_ci NOT NULL, `priceBase` decimal(10,2) NOT NULL, `pricePerKilometer` decimal(10,2) NOT NULL, `pricePerMinute` decimal(10,2) NOT NULL, `night` decimal(10,2) NOT NULL, `company_idCompany` int NOT NULL, `category_idCategory` int NOT NULL, PRIMARY KEY (`idFeesTaximeter`), KEY `fk_feestaximeter_company1_idx` (`company_idCompany`), KEY `fk_feestaximeter_category1_idx` (`category_idCategory`), CONSTRAINT `fk_feestaximeter_category1` FOREIGN KEY (`category_idCategory`) REFERENCES `categories` (`idCategories`), CONSTRAINT `fk_feestaximeter_company1` FOREIGN KEY (`company_idCompany`) REFERENCES `company` (`idCompany`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `feestaximeter` -- LOCK TABLES `feestaximeter` WRITE; /*!40000 ALTER TABLE `feestaximeter` DISABLE KEYS */; INSERT INTO `feestaximeter` VALUES (1,'Regular',10.00,1.00,1.00,5.00,1,1); /*!40000 ALTER TABLE `feestaximeter` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `filiationrequest` -- DROP TABLE IF EXISTS `filiationrequest`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `filiationrequest` ( `idFiliationRequest` int NOT NULL AUTO_INCREMENT, `date` date NOT NULL, `time` time NOT NULL, `status` tinyint NOT NULL, `observation` text COLLATE utf8mb4_general_ci, `account_idAccount` int NOT NULL, `company_idCompany` int NOT NULL, `visible` tinyint NOT NULL, PRIMARY KEY (`idFiliationRequest`), KEY `fk_requestRegistration_account1_idx` (`account_idAccount`), KEY `fk_requestRegistration_company1_idx` (`company_idCompany`), CONSTRAINT `fk_requestRegistration_account1` FOREIGN KEY (`account_idAccount`) REFERENCES `account` (`idAccount`), CONSTRAINT `fk_requestRegistration_company1` FOREIGN KEY (`company_idCompany`) REFERENCES `company` (`idCompany`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `filiationrequest` -- LOCK TABLES `filiationrequest` WRITE; /*!40000 ALTER TABLE `filiationrequest` DISABLE KEYS */; INSERT INTO `filiationrequest` VALUES (1,'2026-05-24','08:38:48',1,NULL,15,1,1); /*!40000 ALTER TABLE `filiationrequest` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `generalfees` -- DROP TABLE IF EXISTS `generalfees`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `generalfees` ( `idGeneralFees` int NOT NULL AUTO_INCREMENT, `code` varchar(100) COLLATE utf8mb4_general_ci NOT NULL, `denomination` varchar(70) COLLATE utf8mb4_general_ci NOT NULL, `duration` varchar(17) COLLATE utf8mb4_general_ci NOT NULL, `type` varchar(70) COLLATE utf8mb4_general_ci NOT NULL, `amount` decimal(10,2) NOT NULL, `date` date NOT NULL, `time` time NOT NULL, `status` tinyint NOT NULL, `categories_idCategories` int NOT NULL, `visible` tinyint NOT NULL, PRIMARY KEY (`idGeneralFees`), KEY `fk_generalfees_categories1_idx` (`categories_idCategories`), CONSTRAINT `fk_generalfees_categories1` FOREIGN KEY (`categories_idCategories`) REFERENCES `categories` (`idCategories`) ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `generalfees` -- LOCK TABLES `generalfees` WRITE; /*!40000 ALTER TABLE `generalfees` DISABLE KEYS */; INSERT INTO `generalfees` VALUES (1,'f1b42f3dc56bdf0be00fcfbe9a2198cc6e4235f45a0d0053904180c2abf6f118','Tarifa general','24','Hora (s)',2.00,'2025-07-30','10:00:00',1,1,1),(2,'3841-20260517155907396af0a3-2115-48f7-8155-44e9c8f35dd5','Semanal','1','Semanas',10.00,'2026-05-17','15:59:07',1,1,1),(3,'7787-202605171600121b5396f0-da90-4c84-aae3-38895468e0e4','Nocturno','8','Horas',1.00,'2026-05-17','16:00:12',0,1,1),(4,'6027-202605171601067dffafd9-1fe4-4760-b770-52859ce9cff6','Mtutino','6','Horas',2.00,'2026-05-17','16:01:06',0,1,0); /*!40000 ALTER TABLE `generalfees` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `jurisdiction` -- DROP TABLE IF EXISTS `jurisdiction`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `jurisdiction` ( `idJurisdiction` int NOT NULL AUTO_INCREMENT, `country` varchar(45) COLLATE utf8mb4_general_ci NOT NULL, `departament` varchar(45) COLLATE utf8mb4_general_ci NOT NULL, `city` varchar(45) COLLATE utf8mb4_general_ci NOT NULL, `state` tinyint NOT NULL, `hidden` tinyint NOT NULL, PRIMARY KEY (`idJurisdiction`) ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `jurisdiction` -- LOCK TABLES `jurisdiction` WRITE; /*!40000 ALTER TABLE `jurisdiction` DISABLE KEYS */; INSERT INTO `jurisdiction` VALUES (1,'Bolivia','Cochabamba','Cochabamba',1,0),(2,'Bolivia','Cochabamba','Sacaba',1,0),(3,'Bolivia','Cochabamba','Quillacollo',0,0),(4,'Bolivia','Cochabamba','Colomi',0,1); /*!40000 ALTER TABLE `jurisdiction` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `multimedia` -- DROP TABLE IF EXISTS `multimedia`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `multimedia` ( `idMultimedia` int NOT NULL AUTO_INCREMENT, `file` varchar(170) COLLATE utf8mb4_general_ci NOT NULL, `type` varchar(30) COLLATE utf8mb4_general_ci NOT NULL, PRIMARY KEY (`idMultimedia`) ) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `multimedia` -- LOCK TABLES `multimedia` WRITE; /*!40000 ALTER TABLE `multimedia` DISABLE KEYS */; INSERT INTO `multimedia` VALUES (1,'/resources/images/profiles/1779050564918-imagenes-de-perfil-geniales-4co57dtwk64fb7lv.jpg','image'),(2,'/resources/images/profiles/defaultPhoto.jpg','image'),(3,'/resources/images/profiles/defaultPhoto.jpg','image'),(4,'/resources/images/profiles/1779626832180-portada-foto-perfil-redes-sociales-consejos.jpg','image'),(5,'/resources/images/profiles/1779627257360-gritando-emocionado-al-frente_1187-362465.jpg','image'),(6,'/resources/images/profiles/1779631962740-hombre-guapo-joven-sentado-suelo-contando-diez-dedos_1368-201745.jpg','image'),(7,'/resources/images/profiles/defaultPhoto.jpg','image'),(8,'/resources/images/profiles/defaultPhoto.jpg','image'),(9,'/resources/images/profiles/defaultPhoto.jpg','image'),(10,'/resources/images/profiles/defaultPhoto.jpg','image'),(11,'/resources/images/profiles/defaultPhoto.jpg','image'),(12,'/resources/images/profiles/defaultPhoto.jpg','image'),(13,'/resources/images/profiles/1779630044398-TAXI.jpg','image'); /*!40000 ALTER TABLE `multimedia` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `person` -- DROP TABLE IF EXISTS `person`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `person` ( `idPerson` int NOT NULL AUTO_INCREMENT, `code` varchar(100) COLLATE utf8mb4_general_ci NOT NULL, `names` varchar(70) COLLATE utf8mb4_general_ci NOT NULL, `surnames` varchar(70) COLLATE utf8mb4_general_ci NOT NULL, `identificationDocument` varchar(17) COLLATE utf8mb4_general_ci NOT NULL, `cellular` varchar(8) COLLATE utf8mb4_general_ci NOT NULL, `country` varchar(30) COLLATE utf8mb4_general_ci NOT NULL, `codeCountry` varchar(7) COLLATE utf8mb4_general_ci NOT NULL, `city` varchar(70) COLLATE utf8mb4_general_ci NOT NULL, `address` varchar(100) COLLATE utf8mb4_general_ci NOT NULL, `eMail` varchar(70) COLLATE utf8mb4_general_ci DEFAULT NULL, PRIMARY KEY (`idPerson`) ) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `person` -- LOCK TABLES `person` WRITE; /*!40000 ALTER TABLE `person` DISABLE KEYS */; INSERT INTO `person` VALUES (1,'a8196-20250509072358143898f5-4d8b-4dbd-a1f6-5624236060a4','Elmer','E.','4563258','65487879','Bolivia','+591','Cochabamba','Sacaba','elmer@gmail.com'),(2,'s6303-2025042408515071af6a0d-bbd8-400e-8520-2111aae8ad20','Super','Super administrador','','77925037','Bolivia','+591','','','super@gmail.com'),(5,'m2565-20260517180034cfb6dff3-9fd2-448b-97c9-9281f135156e','Mireya','Castro','51547777','66666666','Bolivia','+591','Cochabamba','Av. San Martin','mireya@gmail.com'),(6,'k6320-2026051718015131ce2168-13a6-4493-9fa7-e12427e00f4c','Karla','Castro','542222222','62544444','Bolivia','+591','Sacaba','Calle Bolivar','karla@gmail.com'),(7,'m8451-202605171804294cfdac2d-db6f-4d03-8c0a-fd6d20792b25','Micaela','Sandi','412222222','62211111','Bolivia','+591','Quillacollo','Calle Sucre','micaela@gmail.com'),(8,'67853-2026051811592703e9ccc3-2f59-4155-b491-de3bcd0f3ec4','Nineth','','','60636754','Bolivia','+591','','',''),(9,'s9025-20260524074611bfd29c5b-f1b9-41e3-ade5-58587f5f5b1d','Soraya','Vargas','5411111222','63255555','Bolivia','+591','Quillacollo','Calle Bolivar','soraya@gmail.com'),(10,'a1205-202605240815519b7b3657-e21d-43c3-a576-5fb8afa363e3','Alexandra','Irusta','','66666661','Bolivia','+591','','','alexandrairusta@gmail.com'),(11,'m7017-2026052408170091cd3d83-4714-4e95-87c3-ede894fbcbe1','Mishel','Castro Montana','21222111111','62111120','Bolivia','+591','Cochabamba','Calle Sucre','mishelcastro@gmail.com'),(12,'e6371-20260524082629c4617395-1831-4c4d-86b4-7a7a3e41e715','Efrain','Sandi','','63221110','Bolivia','+591','','','efrain@gmail.com'),(13,'e4301-20260524082938af45efee-d0fc-41d0-8126-d0c9e5417657','efra','Sandi Isla','','61122003','Bolivia','+591','','','efra@gmail.com'),(14,'k9211-20260524083725677aeac5-a8ea-4ab9-ad4b-98ab7ffc2b50','Kevin','Montana','','74441111','Bolivia','+591','','','kevin@gmail.com'),(15,'s6554-202605240838483fa41698-3600-430e-84ec-bed950ca37f0','Sasha','Bernabe','','77925037','Bolivia','+591','','','sasha@gmail.com'); /*!40000 ALTER TABLE `person` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `person_has_multimedia` -- DROP TABLE IF EXISTS `person_has_multimedia`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `person_has_multimedia` ( `person_idPerson` int NOT NULL, `multimedia_idMultimedia` int NOT NULL, PRIMARY KEY (`person_idPerson`,`multimedia_idMultimedia`), KEY `fk_person_has_multimedia_multimedia1_idx` (`multimedia_idMultimedia`), KEY `fk_person_has_multimedia_person1_idx` (`person_idPerson`), CONSTRAINT `fk_person_has_multimedia_multimedia1` FOREIGN KEY (`multimedia_idMultimedia`) REFERENCES `multimedia` (`idMultimedia`), CONSTRAINT `fk_person_has_multimedia_person1` FOREIGN KEY (`person_idPerson`) REFERENCES `person` (`idPerson`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `person_has_multimedia` -- LOCK TABLES `person_has_multimedia` WRITE; /*!40000 ALTER TABLE `person_has_multimedia` DISABLE KEYS */; INSERT INTO `person_has_multimedia` VALUES (1,1),(2,2),(5,3),(6,4),(7,5),(8,6),(9,7),(10,8),(11,9),(12,10),(13,11),(14,12),(15,13); /*!40000 ALTER TABLE `person_has_multimedia` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `photovehicle` -- DROP TABLE IF EXISTS `photovehicle`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `photovehicle` ( `idPhotoVehicle` int NOT NULL AUTO_INCREMENT, `front` varchar(170) COLLATE utf8mb4_general_ci NOT NULL, `left` varchar(170) COLLATE utf8mb4_general_ci NOT NULL, `right` varchar(170) COLLATE utf8mb4_general_ci NOT NULL, `back` varchar(170) COLLATE utf8mb4_general_ci NOT NULL, `vehicle_idVehicle` int NOT NULL, PRIMARY KEY (`idPhotoVehicle`), KEY `fk_photo_vehicle_vehicle1_idx` (`vehicle_idVehicle`), CONSTRAINT `fk_photo_vehicle_vehicle1` FOREIGN KEY (`vehicle_idVehicle`) REFERENCES `vehicle` (`idVehicle`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `photovehicle` -- LOCK TABLES `photovehicle` WRITE; /*!40000 ALTER TABLE `photovehicle` DISABLE KEYS */; INSERT INTO `photovehicle` VALUES (1,'/resources/images/vehicles/1779630714883-e94e7ac4-1260-47e8-8f9e-a10d308f418b.jpg','/resources/images/vehicles/1779630736625-istockphoto-492362277-612x612.jpg','/resources/images/vehicles/1779630725506-taxi.png','/resources/images/vehicles/1779630749124-taxi.png',1); /*!40000 ALTER TABLE `photovehicle` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `photovehiclechangedrequest` -- DROP TABLE IF EXISTS `photovehiclechangedrequest`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `photovehiclechangedrequest` ( `idPhotoVehicleChangedRequest` int NOT NULL, `front` varchar(170) COLLATE utf8mb4_general_ci NOT NULL, `left` varchar(170) COLLATE utf8mb4_general_ci NOT NULL, `right` varchar(170) COLLATE utf8mb4_general_ci NOT NULL, `back` varchar(170) COLLATE utf8mb4_general_ci NOT NULL, `driver_idDriver` int NOT NULL, PRIMARY KEY (`idPhotoVehicleChangedRequest`), KEY `fk_photovehicle_copy1_driver1_idx` (`driver_idDriver`), CONSTRAINT `fk_photovehicle_copy1_driver1` FOREIGN KEY (`driver_idDriver`) REFERENCES `driver` (`idDriver`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `photovehiclechangedrequest` -- LOCK TABLES `photovehiclechangedrequest` WRITE; /*!40000 ALTER TABLE `photovehiclechangedrequest` DISABLE KEYS */; /*!40000 ALTER TABLE `photovehiclechangedrequest` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `qrcollection` -- DROP TABLE IF EXISTS `qrcollection`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `qrcollection` ( `idQRCollection` int NOT NULL AUTO_INCREMENT, `date` date NOT NULL, `qrImage` text COLLATE utf8mb4_general_ci NOT NULL, `qrDateValidity` date NOT NULL, `account_idAccount` int NOT NULL, PRIMARY KEY (`idQRCollection`), KEY `fk_qrcollection_driver1_idx` (`account_idAccount`), CONSTRAINT `fk_qrcollection_account1` FOREIGN KEY (`account_idAccount`) REFERENCES `account` (`idAccount`) ) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `qrcollection` -- LOCK TABLES `qrcollection` WRITE; /*!40000 ALTER TABLE `qrcollection` DISABLE KEYS */; INSERT INTO `qrcollection` VALUES (1,'2026-05-17','/resources/images/qrMaster/1779053119548-10-size.jpg','2026-08-29',1),(2,'2026-05-16','/resources/images/qrSuper/defaultPhoto.jpg','2026-05-16',2),(4,'2026-05-18','/resources/images/qrSuper/1779126257698-Commons_QR_code.png','2026-05-30',5),(5,'2026-05-21','/resources/images/qrSuper/1779371985237-Commons_QR_code.png','2026-05-31',6),(6,'2026-05-24','/resources/images/qrAdministrator/1779629011668-codigo-qr-900x600.jpg','2026-05-28',7),(7,'2026-05-24','/resources/images/qrSuper/defaultPhoto.jpg','2026-05-24',9),(8,'2026-05-24','/resources/images/qrAdministrator/defaultPhoto.jpg','2026-05-24',11); /*!40000 ALTER TABLE `qrcollection` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `races` -- DROP TABLE IF EXISTS `races`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `races` ( `idRaces` int NOT NULL AUTO_INCREMENT, `date` date NOT NULL, `time` time NOT NULL, `numberRace` int NOT NULL, `originLatitude` varchar(170) COLLATE utf8mb4_general_ci NOT NULL, `originLength` varchar(170) COLLATE utf8mb4_general_ci NOT NULL, `destinationLatitude` varchar(177) COLLATE utf8mb4_general_ci NOT NULL, `destinationLength` varchar(177) COLLATE utf8mb4_general_ci NOT NULL, `price` decimal(10,2) NOT NULL, `status` varchar(70) COLLATE utf8mb4_general_ci NOT NULL, `observation` text COLLATE utf8mb4_general_ci NOT NULL, `driver_idDriver` int NOT NULL, `account_idAccount` int NOT NULL, `visible` tinyint NOT NULL, PRIMARY KEY (`idRaces`), KEY `fk_races_driver1_idx` (`driver_idDriver`), KEY `fk_races_account1_idx` (`account_idAccount`), CONSTRAINT `fk_races_account1` FOREIGN KEY (`account_idAccount`) REFERENCES `account` (`idAccount`), CONSTRAINT `fk_races_driver1` FOREIGN KEY (`driver_idDriver`) REFERENCES `driver` (`idDriver`) ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `races` -- LOCK TABLES `races` WRITE; /*!40000 ALTER TABLE `races` DISABLE KEYS */; INSERT INTO `races` VALUES (1,'2026-05-24','09:15:23',1,'-17.38449','-66.10802','-17.39251','-66.06784',20.33,'Cancelado','Sin observaciones',1,8,1),(2,'2026-05-24','09:17:30',2,'-17.37875','-66.11627','-17.38940','-66.07385',24.89,'Cancelado','Sin observaciones',1,8,1),(3,'2026-05-24','09:19:23',3,'-17.38403','-66.10080','-17.38632','-66.08801',20.50,'Cancelado','Sin observaciones',1,8,1),(4,'2026-05-24','09:25:04',4,'-17.37745','-66.10856','-17.37794','-66.10092',14.87,'Terminada','Sin observaciones',1,8,1),(5,'2026-05-24','09:39:35',5,'-17.38416','-66.10648','-17.38907','-66.08364',20.61,'Cancelado','Sin observaciones',1,8,1),(6,'2026-05-24','09:41:39',6,'-17.38413','-66.09178','-17.38527','-66.09770',13.31,'Cancelado','Sin observaciones',1,8,1); /*!40000 ALTER TABLE `races` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `rechargerequest` -- DROP TABLE IF EXISTS `rechargerequest`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `rechargerequest` ( `idRechargeRequest` int NOT NULL AUTO_INCREMENT, `date` date NOT NULL, `time` time NOT NULL, `amount` decimal(10,2) DEFAULT NULL, `voucher` text COLLATE utf8mb4_general_ci, `status` tinyint NOT NULL, `paymentDate` date NOT NULL, `paymentMethod` varchar(70) COLLATE utf8mb4_general_ci NOT NULL, `description` text COLLATE utf8mb4_general_ci, `observation` text COLLATE utf8mb4_general_ci, `account_idAccount` int NOT NULL, `visible` tinyint NOT NULL, `approved` tinyint NOT NULL, PRIMARY KEY (`idRechargeRequest`), KEY `fk_rechargeRequest_driver1_idx` (`account_idAccount`), CONSTRAINT `fk_rechargeRequest_account1` FOREIGN KEY (`account_idAccount`) REFERENCES `account` (`idAccount`) ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `rechargerequest` -- LOCK TABLES `rechargerequest` WRITE; /*!40000 ALTER TABLE `rechargerequest` DISABLE KEYS */; INSERT INTO `rechargerequest` VALUES (1,'2026-05-24','07:43:10',1000.00,'/resources/images/vouchers/1779626590678-furNuevo.jpg',1,'2026-05-29','Pago por Código QR','Sin descripción','Pago verificado, su solicitud ha sido procesada.',6,1,1),(2,'2026-05-24','07:53:55',500.00,'/resources/images/vouchers/1779627235443-furNuevoImpreso.jpg',1,'2026-05-22','Pago por Código QR','Sin descripción','Pago verificado, su solicitud ha sido procesada.',7,1,1),(3,'2026-05-24','09:01:11',50.00,'/resources/images/vouchers/1779631271417-furNuevo.jpg',1,'2026-05-21','Pago por Código QR','Sin descripción','Pago verificado, su solicitud ha sido procesada.',15,1,1),(4,'2026-05-24','09:12:19',30.00,'/resources/images/vouchers/1779631939031-furNuevoImpreso.jpg',1,'2026-05-22','Pago por Código QR','Sin descripción','Pago verificado, su solicitud ha sido procesada.',8,1,1); /*!40000 ALTER TABLE `rechargerequest` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `reservation` -- DROP TABLE IF EXISTS `reservation`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `reservation` ( `idReservation` int NOT NULL AUTO_INCREMENT, `dateReservation` date NOT NULL, `timeReservation` time NOT NULL, `numberReservation` int NOT NULL, `originLatitude` varchar(170) COLLATE utf8mb4_general_ci NOT NULL, `originLength` varchar(170) COLLATE utf8mb4_general_ci NOT NULL, `destinationLatitude` varchar(177) COLLATE utf8mb4_general_ci NOT NULL, `destinationLength` varchar(177) COLLATE utf8mb4_general_ci NOT NULL, `price` decimal(10,2) NOT NULL, `status` varchar(70) COLLATE utf8mb4_general_ci NOT NULL, `observation` text COLLATE utf8mb4_general_ci NOT NULL, `driver_idDriver` int NOT NULL, `account_idAccount` int NOT NULL, `visible` tinyint NOT NULL, PRIMARY KEY (`idReservation`), KEY `fk_reservation_driver1_idx` (`driver_idDriver`), KEY `fk_reservation_account1_idx` (`account_idAccount`), CONSTRAINT `fk_reservation_account1` FOREIGN KEY (`account_idAccount`) REFERENCES `account` (`idAccount`), CONSTRAINT `fk_reservation_driver1` FOREIGN KEY (`driver_idDriver`) REFERENCES `driver` (`idDriver`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `reservation` -- LOCK TABLES `reservation` WRITE; /*!40000 ALTER TABLE `reservation` DISABLE KEYS */; /*!40000 ALTER TABLE `reservation` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `role` -- DROP TABLE IF EXISTS `role`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `role` ( `idRole` int NOT NULL AUTO_INCREMENT, `denomination` varchar(30) COLLATE utf8mb4_general_ci NOT NULL, `description` varchar(100) COLLATE utf8mb4_general_ci NOT NULL, PRIMARY KEY (`idRole`) ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `role` -- LOCK TABLES `role` WRITE; /*!40000 ALTER TABLE `role` DISABLE KEYS */; INSERT INTO `role` VALUES (1,'Super administrador','Cuenta del encargado de vialidad.'),(2,'Administrador','Propietario de la empresa externa registrada.'),(3,'Conductor','Propietario del móvil registrado en alguna empresa.'),(4,'Cliente','Pasajero de alguna empresa registrada.'),(5,'Maestro','Cuenta del propietario de la plataforma.'); /*!40000 ALTER TABLE `role` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `vehicle` -- DROP TABLE IF EXISTS `vehicle`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `vehicle` ( `idVehicle` int NOT NULL AUTO_INCREMENT, `plateNumber` varchar(17) COLLATE utf8mb4_general_ci NOT NULL, `model` varchar(100) COLLATE utf8mb4_general_ci NOT NULL, `brand` varchar(100) COLLATE utf8mb4_general_ci NOT NULL, `color` varchar(70) COLLATE utf8mb4_general_ci NOT NULL, `type` varchar(10) COLLATE utf8mb4_general_ci NOT NULL, `driver_idDriver` int NOT NULL, PRIMARY KEY (`idVehicle`), KEY `fk_vehicle_driver1_idx` (`driver_idDriver`), CONSTRAINT `fk_vehicle_driver1` FOREIGN KEY (`driver_idDriver`) REFERENCES `driver` (`idDriver`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `vehicle` -- LOCK TABLES `vehicle` WRITE; /*!40000 ALTER TABLE `vehicle` DISABLE KEYS */; INSERT INTO `vehicle` VALUES (1,'4521ABC','2026','Toyota','Rojo','Taxi',1); /*!40000 ALTER TABLE `vehicle` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `vehiclechangedrequest` -- DROP TABLE IF EXISTS `vehiclechangedrequest`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `vehiclechangedrequest` ( `idVehicleChangedRequest` int NOT NULL AUTO_INCREMENT, `dateRequest` date NOT NULL, `timeRequest` time NOT NULL, `statusRequest` tinyint NOT NULL, `observation` text COLLATE utf8mb4_general_ci NOT NULL, `plateNumber` varchar(17) COLLATE utf8mb4_general_ci NOT NULL, `model` varchar(100) COLLATE utf8mb4_general_ci NOT NULL, `brand` varchar(100) COLLATE utf8mb4_general_ci NOT NULL, `color` varchar(70) COLLATE utf8mb4_general_ci NOT NULL, `type` varchar(10) COLLATE utf8mb4_general_ci NOT NULL, `driver_idDriver` int NOT NULL, `visible` tinyint NOT NULL, PRIMARY KEY (`idVehicleChangedRequest`), KEY `fk_vehicleChangedRequest_driver2_idx` (`driver_idDriver`), CONSTRAINT `fk_vehicleChangedRequest_driver2` FOREIGN KEY (`driver_idDriver`) REFERENCES `driver` (`idDriver`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `vehiclechangedrequest` -- LOCK TABLES `vehiclechangedrequest` WRITE; /*!40000 ALTER TABLE `vehiclechangedrequest` DISABLE KEYS */; INSERT INTO `vehiclechangedrequest` VALUES (1,'2026-05-24','08:48:59',0,'Pendiente','4521ABC','2026','Toyota','Rojo','Taxi',1,1); /*!40000 ALTER TABLE `vehiclechangedrequest` ENABLE KEYS */; UNLOCK TABLES; /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; -- Dump completed on 2026-05-24 18:51:33