CREATE DATABASE IF NOT EXISTS `Waspnet_Courier` /*!40100 DEFAULT CHARACTER SET utf8 COLLATE utf8_bin */; USE `Waspnet_Courier`; -- MySQL dump 10.13 Distrib 8.0.18, for Win64 (x86_64) -- -- Host: 10.251.0.15 Database: Waspnet_Courier -- ------------------------------------------------------ -- Server version 5.7.22 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!50503 SET NAMES utf8 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- -- Table structure for table `Drivers` -- DROP TABLE IF EXISTS `Drivers`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `Drivers` ( `ID` varchar(38) NOT NULL, `FirstName` varchar(100) NOT NULL, `LastName` varchar(100) NOT NULL, `Username` varchar(250) DEFAULT NULL, `Password` varchar(500) DEFAULT NULL, `WebAccessEnabled` tinyint(1) DEFAULT NULL, `Email` varchar(250) DEFAULT NULL, `LicenseNumber` varchar(20) DEFAULT NULL, `BirthDate` datetime NOT NULL, `Version` int(11) NOT NULL, `LastUpdate` datetime NOT NULL, `IdDefaultVehicle` varchar(38) DEFAULT NULL, `IdTransporter` varchar(38) NOT NULL, PRIMARY KEY (`ID`), KEY `fk_drivers_vehicles_idx` (`IdDefaultVehicle`), KEY `fk_drivers_transporters_idx` (`IdTransporter`), CONSTRAINT `fk_drivers_transporters` FOREIGN KEY (`IdTransporter`) REFERENCES `Transporters` (`ID`) ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT `fk_drivers_vehicles` FOREIGN KEY (`IdDefaultVehicle`) REFERENCES `Vehicles` (`ID`) ON DELETE NO ACTION ON UPDATE NO ACTION ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `Drivers` -- LOCK TABLES `Drivers` WRITE; /*!40000 ALTER TABLE `Drivers` DISABLE KEYS */; INSERT INTO `Drivers` VALUES ('{205C2349-8274-42A2-8758-23660FABEE73}','Auriemma','Francesco','fauriemma','pPqaxnstCaA=',0,'','AY8656362','1982-05-28 00:00:00',7,'2019-11-21 16:54:18',NULL,'{08F011A8-2089-4601-952B-D33909EE27F5}'),('{38A86244-BFE3-46F0-9026-54B23E2FBBC3}','Fabio','Villani','fvillani3','pPqaxnstCaA=',0,'','NA5036806','1994-04-21 00:00:00',6,'2019-11-04 10:29:51','{0160D195-FED8-4AD2-88D2-51958174EFFB}','{D4AE9777-739E-4549-A9C6-B438CAC020E0}'),('{68C56A2C-E35D-452C-B229-55C1A473FAF8}','Test1','Test2','','pPqaxnstCaA=',0,'','Patente','2019-11-21 00:00:00',4,'2019-11-21 16:43:49','{0C1E4982-2019-4E6E-910A-24ACA97D87D6}','{D4AE9777-739E-4549-A9C6-B438CAC020E0}'),('{E5BD9059-36FD-4AF2-8C1F-B25CCE40C8C4}','Giuseppe','Pistoia','gpistoia','lCWt+i0x8wEgPOMTfJP6nw==',1,'','','2019-11-09 00:00:00',1,'2019-11-09 00:55:22',NULL,'{D4AE9777-739E-4549-A9C6-B438CAC020E0}'); /*!40000 ALTER TABLE `Drivers` ENABLE KEYS */; UNLOCK TABLES; /*!50003 SET @saved_cs_client = @@character_set_client */ ; /*!50003 SET @saved_cs_results = @@character_set_results */ ; /*!50003 SET @saved_col_connection = @@collation_connection */ ; /*!50003 SET character_set_client = utf8 */ ; /*!50003 SET character_set_results = utf8 */ ; /*!50003 SET collation_connection = utf8_general_ci */ ; /*!50003 SET @saved_sql_mode = @@sql_mode */ ; /*!50003 SET sql_mode = '' */ ; DELIMITER ;; /*!50003 CREATE*/ /*!50017 DEFINER=`root`@`%`*/ /*!50003 TRIGGER `Waspnet_Courier`.`Drivers_AFTER_INSERT` AFTER INSERT ON `Drivers` FOR EACH ROW BEGIN INSERT INTO `Waspnet_Courier`.`Drivers_History` (`ID`, `FirstName`, `LastName`, `Username`, `Password`, `WebAccessEnabled`, `Email`, `LicenseNumber`, `BirthDate`, `Version`, `LastUpdate`, `IdDefaultVehicle`, `IdTransporter` ) VALUES ( new.`ID`, new.`FirstName`, new.`LastName`, new.`Username`, new.`Password`, new.`WebAccessEnabled`, new.`Email`, new.`LicenseNumber`, new.`BirthDate`, new.`Version`, new.`LastUpdate`, new.`IdDefaultVehicle`, new.`IdTransporter` ); END */;; DELIMITER ; /*!50003 SET sql_mode = @saved_sql_mode */ ; /*!50003 SET character_set_client = @saved_cs_client */ ; /*!50003 SET character_set_results = @saved_cs_results */ ; /*!50003 SET collation_connection = @saved_col_connection */ ; /*!50003 SET @saved_cs_client = @@character_set_client */ ; /*!50003 SET @saved_cs_results = @@character_set_results */ ; /*!50003 SET @saved_col_connection = @@collation_connection */ ; /*!50003 SET character_set_client = utf8 */ ; /*!50003 SET character_set_results = utf8 */ ; /*!50003 SET collation_connection = utf8_general_ci */ ; /*!50003 SET @saved_sql_mode = @@sql_mode */ ; /*!50003 SET sql_mode = '' */ ; DELIMITER ;; /*!50003 CREATE*/ /*!50017 DEFINER=`root`@`%`*/ /*!50003 TRIGGER `Waspnet_Courier`.`Drivers_AFTER_UPDATE` AFTER UPDATE ON `Drivers` FOR EACH ROW BEGIN INSERT INTO `Waspnet_Courier`.`Drivers_History` (`ID`, `FirstName`, `LastName`, `Username`, `Password`, `WebAccessEnabled`, `Email`, `LicenseNumber`, `BirthDate`, `Version`, `LastUpdate`, `IdDefaultVehicle`, `IdTransporter` ) VALUES ( new.`ID`, new.`FirstName`, new.`LastName`, new.`Username`, new.`Password`, new.`WebAccessEnabled`, new.`Email`, new.`LicenseNumber`, new.`BirthDate`, new.`Version`, new.`LastUpdate`, new.`IdDefaultVehicle`, new.`IdTransporter` ); END */;; DELIMITER ; /*!50003 SET sql_mode = @saved_sql_mode */ ; /*!50003 SET character_set_client = @saved_cs_client */ ; /*!50003 SET character_set_results = @saved_cs_results */ ; /*!50003 SET collation_connection = @saved_col_connection */ ; -- -- Table structure for table `Drivers_History` -- DROP TABLE IF EXISTS `Drivers_History`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `Drivers_History` ( `HistorizationNumber` bigint(20) NOT NULL AUTO_INCREMENT, `ID` varchar(38) NOT NULL, `FirstName` varchar(100) NOT NULL, `LastName` varchar(100) NOT NULL, `Username` varchar(250) DEFAULT NULL, `Password` varchar(500) DEFAULT NULL, `WebAccessEnabled` tinyint(1) DEFAULT NULL, `Email` varchar(250) DEFAULT NULL, `LicenseNumber` varchar(20) DEFAULT NULL, `BirthDate` datetime NOT NULL, `Version` int(11) NOT NULL, `LastUpdate` datetime NOT NULL, `IdDefaultVehicle` varchar(38) DEFAULT NULL, `IdSynchronizationSession` varchar(38) DEFAULT NULL, `SynchronizationDate` datetime DEFAULT NULL, `IdTransporter` varchar(38) DEFAULT NULL, PRIMARY KEY (`HistorizationNumber`) ) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `Drivers_History` -- LOCK TABLES `Drivers_History` WRITE; /*!40000 ALTER TABLE `Drivers_History` DISABLE KEYS */; INSERT INTO `Drivers_History` VALUES (1,'{38A86244-BFE3-46F0-9026-54B23E2FBBC3}','Fabio','Villani','fvillani','pPqaxnstCaA=',0,'','NA5036806','1994-04-21 00:00:00',6,'2019-10-15 16:42:12','{0160D195-FED8-4AD2-88D2-51958174EFFB}',NULL,'2019-11-06 09:28:19',NULL),(2,'{38A86244-BFE3-46F0-9026-54B23E2FBBC3}','Fabio','Villani','fvillani2','pPqaxnstCaA=',0,'','NA5036806','1994-04-21 00:00:00',6,'2019-10-15 16:42:12','{0160D195-FED8-4AD2-88D2-51958174EFFB}',NULL,'2019-11-06 09:28:19',NULL),(3,'{38A86244-BFE3-46F0-9026-54B23E2FBBC3}','Fabio','Villani','fvillani3','pPqaxnstCaA=',0,'','NA5036806','1994-04-21 00:00:00',6,'2019-10-15 16:42:12','{0160D195-FED8-4AD2-88D2-51958174EFFB}',NULL,'2019-11-06 09:28:19',NULL),(4,'{205C2349-8274-42A2-8758-23660FABEE73}','Auriemma','Francesco','fauriemma',NULL,NULL,NULL,'AY8656362','1982-05-28 00:00:00',4,'2019-10-15 14:42:28','{0C1E4982-2019-4E6E-910A-24ACA97D87D6}',NULL,'2019-11-06 09:28:19',NULL),(5,'{205C2349-8274-42A2-8758-23660FABEE73}','Auriemma','Francesco','fauriemma',NULL,NULL,NULL,'AY8656362','1982-05-28 00:00:00',4,'2019-11-04 10:29:51','{0C1E4982-2019-4E6E-910A-24ACA97D87D6}',NULL,'2019-11-06 09:28:19',NULL),(6,'{38A86244-BFE3-46F0-9026-54B23E2FBBC3}','Fabio','Villani','fvillani3','pPqaxnstCaA=',0,'','NA5036806','1994-04-21 00:00:00',6,'2019-11-04 10:29:51','{0160D195-FED8-4AD2-88D2-51958174EFFB}',NULL,'2019-11-06 09:28:19',NULL),(7,'{205C2349-8274-42A2-8758-23660FABEE73}','Auriemma','Francesco','fauriemma',NULL,NULL,NULL,'AY8656362','1982-05-28 00:00:00',4,'2019-11-04 10:29:51','{0C1E4982-2019-4E6E-910A-24ACA97D87D6}',NULL,'2019-11-06 09:28:19',NULL),(8,'{38A86244-BFE3-46F0-9026-54B23E2FBBC3}','Fabio','Villani','fvillani3','pPqaxnstCaA=',0,'','NA5036806','1994-04-21 00:00:00',6,'2019-11-04 10:29:51','{0160D195-FED8-4AD2-88D2-51958174EFFB}',NULL,'2019-11-06 09:28:19',NULL),(9,'{205C2349-8274-42A2-8758-23660FABEE73}','Auriemma','Francesco','fauriemma',NULL,NULL,NULL,'AY8656362','1982-05-28 00:00:00',4,'2019-11-04 10:29:51','{0C1E4982-2019-4E6E-910A-24ACA97D87D6}',NULL,'2019-11-06 09:28:19',NULL),(10,'{38A86244-BFE3-46F0-9026-54B23E2FBBC3}','Fabio','Villani','fvillani3','pPqaxnstCaA=',0,'','NA5036806','1994-04-21 00:00:00',6,'2019-11-04 10:29:51','{0160D195-FED8-4AD2-88D2-51958174EFFB}',NULL,'2019-11-06 09:28:19',NULL),(11,'{E5BD9059-36FD-4AF2-8C1F-B25CCE40C8C4}','Giuseppe','Pistoia','gpistoia','lCWt+i0x8wEgPOMTfJP6nw==',1,'','','2019-11-09 00:00:00',1,'2019-11-09 00:55:22',NULL,NULL,'2019-11-11 15:14:12',NULL),(12,'{205C2349-8274-42A2-8758-23660FABEE73}','Auriemma','Francesco','fauriemma',NULL,NULL,NULL,'AY8656362','1982-05-28 00:00:00',4,'2019-11-04 10:29:51','{0C1E4982-2019-4E6E-910A-24ACA97D87D6}',NULL,'2019-11-22 08:26:48',NULL),(13,'{38A86244-BFE3-46F0-9026-54B23E2FBBC3}','Fabio','Villani','fvillani3','pPqaxnstCaA=',0,'','NA5036806','1994-04-21 00:00:00',6,'2019-11-04 10:29:51','{0160D195-FED8-4AD2-88D2-51958174EFFB}',NULL,'2019-11-22 08:26:48',NULL),(14,'{E5BD9059-36FD-4AF2-8C1F-B25CCE40C8C4}','Giuseppe','Pistoia','gpistoia','lCWt+i0x8wEgPOMTfJP6nw==',1,'','','2019-11-09 00:00:00',1,'2019-11-09 00:55:22',NULL,NULL,'2019-11-22 08:26:48',NULL),(15,'{68C56A2C-E35D-452C-B229-55C1A473FAF8}','Test1','Test2','','pPqaxnstCaA=',0,'','Patente','2019-11-21 00:00:00',1,'2019-11-21 16:35:47','{0C1E4982-2019-4E6E-910A-24ACA97D87D6}',NULL,'2019-11-22 08:26:48',NULL),(16,'{68C56A2C-E35D-452C-B229-55C1A473FAF8}','Test1','Test2','','pPqaxnstCaA=',0,'','Patente','2019-11-21 00:00:00',2,'2019-11-21 16:43:02','{0C1E4982-2019-4E6E-910A-24ACA97D87D6}',NULL,'2019-11-22 08:26:48',NULL),(17,'{68C56A2C-E35D-452C-B229-55C1A473FAF8}','Test1','Test2','','pPqaxnstCaA=',0,'','Patente','2019-11-21 00:00:00',3,'2019-11-21 16:43:30','{0160D195-FED8-4AD2-88D2-51958174EFFB}',NULL,'2019-11-22 08:26:48',NULL),(18,'{68C56A2C-E35D-452C-B229-55C1A473FAF8}','Test1','Test2','','pPqaxnstCaA=',0,'','Patente','2019-11-21 00:00:00',4,'2019-11-21 16:43:49','{0C1E4982-2019-4E6E-910A-24ACA97D87D6}',NULL,'2019-11-22 08:26:48',NULL),(19,'{205C2349-8274-42A2-8758-23660FABEE73}','Auriemma','Francesco','fauriemma','pPqaxnstCaA=',0,'','AY8656362','1982-05-28 00:00:00',5,'2019-11-21 16:53:53',NULL,NULL,'2019-11-22 08:26:48',NULL),(20,'{205C2349-8274-42A2-8758-23660FABEE73}','Auriemma','Francesco','fauriemma','pPqaxnstCaA=',0,'','AY8656362','1982-05-28 00:00:00',6,'2019-11-21 16:54:07','{6C18C4DF-9913-4E22-8103-170967086857}',NULL,'2019-11-22 08:26:48',NULL),(21,'{205C2349-8274-42A2-8758-23660FABEE73}','Auriemma','Francesco','fauriemma','pPqaxnstCaA=',0,'','AY8656362','1982-05-28 00:00:00',7,'2019-11-21 16:54:18',NULL,NULL,'2019-11-22 08:26:48',NULL); /*!40000 ALTER TABLE `Drivers_History` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping events for database 'Waspnet_Courier' -- -- -- Dumping routines for database 'Waspnet_Courier' -- /*!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 2019-11-26 14:27:10