CREATE DATABASE IF NOT EXISTS `Waspnet_Courier` /*!40100 DEFAULT CHARACTER SET utf8 COLLATE utf8_bin */ /*!80016 DEFAULT ENCRYPTION='N' */; USE `Waspnet_Courier`; -- MySQL dump 10.13 Distrib 8.0.20, for Win64 (x86_64) -- -- Host: localhost Database: Waspnet_Courier -- ------------------------------------------------------ -- Server version 8.0.18 /*!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 `AccountingExpirations` -- DROP TABLE IF EXISTS `AccountingExpirations`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `AccountingExpirations` ( `ID` varchar(38) NOT NULL, `IdInvoice` varchar(38) DEFAULT NULL, `IdCreditNote` varchar(38) DEFAULT NULL, `Date` datetime NOT NULL, `Amount` decimal(19,8) NOT NULL DEFAULT '0.00000000', `Closed` tinyint(1) NOT NULL DEFAULT '0', `LastUpdate` datetime NOT NULL, `Version` int(11) NOT NULL, `Note` text, `IdSupplierInvoice` varchar(38) DEFAULT NULL, `IdSupplierCreditNote` varchar(38) DEFAULT NULL, `IdDebitNote` varchar(38) DEFAULT NULL, `IdSupplierDebitNote` varchar(38) DEFAULT NULL, PRIMARY KEY (`ID`), KEY `FK_AccountingExpiration_Invoice_idx` (`IdInvoice`), KEY `FK_AccountingExpiration_CreditNote_idx` (`IdCreditNote`), KEY `FK_AccountingExpiration_DebitNote` (`IdDebitNote`), KEY `FK_AccountingExpiration_SupplierCreditNote` (`IdSupplierCreditNote`), KEY `FK_AccountingExpiration_SupplierInvoice` (`IdSupplierInvoice`), KEY `FK_AccountingExpiration_SupplierDebitNote` (`IdSupplierDebitNote`), CONSTRAINT `FK_AccountingExpiration_CreditNote` FOREIGN KEY (`IdCreditNote`) REFERENCES `creditnotes` (`ID`) ON DELETE CASCADE, CONSTRAINT `FK_AccountingExpiration_DebitNote` FOREIGN KEY (`IdDebitNote`) REFERENCES `debitnotes` (`ID`) ON DELETE CASCADE, CONSTRAINT `FK_AccountingExpiration_Invoice` FOREIGN KEY (`IdInvoice`) REFERENCES `invoices` (`ID`) ON DELETE CASCADE, CONSTRAINT `FK_AccountingExpiration_SupplierCreditNote` FOREIGN KEY (`IdSupplierCreditNote`) REFERENCES `suppliercreditnotes` (`ID`) ON DELETE CASCADE, CONSTRAINT `FK_AccountingExpiration_SupplierDebitNote` FOREIGN KEY (`IdSupplierDebitNote`) REFERENCES `supplierdebitnotes` (`ID`) ON DELETE CASCADE, CONSTRAINT `FK_AccountingExpiration_SupplierInvoice` FOREIGN KEY (`IdSupplierInvoice`) REFERENCES `supplierinvoices` (`ID`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `Accounts` -- DROP TABLE IF EXISTS `Accounts`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `Accounts` ( `ID` varchar(38) NOT NULL, `IdProfile` varchar(38) NOT NULL, `DisplayedName` varchar(255) NOT NULL, `UserName` varchar(255) NOT NULL, `Password` varchar(255) DEFAULT NULL, `Enabled` tinyint(1) DEFAULT '0', `LastAccess` datetime DEFAULT NULL, `ChangePasswordNextLogon` tinyint(1) DEFAULT '0', `LastChangePassword` datetime DEFAULT NULL, `Version` int(11) NOT NULL DEFAULT '0', `LastUpdate` datetime NOT NULL, `Mail` varchar(255) DEFAULT NULL, PRIMARY KEY (`ID`), UNIQUE KEY `UserName` (`UserName`), KEY `FK_Profile_idx` (`IdProfile`), CONSTRAINT `FK_Profile` FOREIGN KEY (`IdProfile`) REFERENCES `profiles` (`ID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `AdminAreas` -- DROP TABLE IF EXISTS `AdminAreas`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `AdminAreas` ( `ID` int(11) NOT NULL, `Code` varchar(5) NOT NULL, `Description` varchar(50) NOT NULL, `SortOrder` int(11) DEFAULT NULL, `IsGroup` tinyint(1) NOT NULL DEFAULT '0', `IsHidden` tinyint(1) DEFAULT NULL, PRIMARY KEY (`ID`), UNIQUE KEY `Code` (`Code`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `AdminAreasGroups` -- DROP TABLE IF EXISTS `AdminAreasGroups`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `AdminAreasGroups` ( `IdAdminAreaGroup` int(11) NOT NULL, `IdAdminArea` int(11) NOT NULL, PRIMARY KEY (`IdAdminAreaGroup`,`IdAdminArea`), KEY `FK_AdminArea_idx` (`IdAdminArea`), CONSTRAINT `FK_AdminArea` FOREIGN KEY (`IdAdminArea`) REFERENCES `adminareas` (`ID`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `FK_AdminAreaGroup` FOREIGN KEY (`IdAdminAreaGroup`) REFERENCES `adminareas` (`ID`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `Areas` -- DROP TABLE IF EXISTS `Areas`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `Areas` ( `ID` varchar(38) NOT NULL, `Code` varchar(3) NOT NULL, `Description` varchar(50) NOT NULL, `IdAdminArea` int(11) NOT NULL, `DefaultRate` decimal(19,4) DEFAULT NULL, `Note` longtext, `LastUpdate` datetime NOT NULL, `Version` int(11) NOT NULL, PRIMARY KEY (`ID`), UNIQUE KEY `Code` (`Code`), KEY `Description` (`Description`), KEY `FK_AdminArea_Areas_idx` (`IdAdminArea`), CONSTRAINT `FK_AdminArea_Areas` FOREIGN KEY (`IdAdminArea`) REFERENCES `adminareas` (`ID`) ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `AreasDefaultExtras` -- DROP TABLE IF EXISTS `AreasDefaultExtras`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `AreasDefaultExtras` ( `Id` varchar(38) NOT NULL, `IdArea` varchar(38) NOT NULL, `IdExtraType` int(11) NOT NULL, `Rate` decimal(10,2) NOT NULL, `Notes` varchar(500) DEFAULT NULL, `ApplyOnlyOnce` tinyint(1) NOT NULL DEFAULT '0', `LastUpdate` datetime NOT NULL, `Version` int(11) NOT NULL, PRIMARY KEY (`Id`), KEY `fk_areasdefaultextras_areas_idx` (`IdArea`), KEY `fk_areasdefaultextras_extratypes_idx` (`IdExtraType`), CONSTRAINT `fk_areasdefaultextras_areas` FOREIGN KEY (`IdArea`) REFERENCES `areas` (`ID`), CONSTRAINT `fk_areasdefaultextras_extratypes` FOREIGN KEY (`IdExtraType`) REFERENCES `extratypes` (`ID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `AreasTransporters` -- DROP TABLE IF EXISTS `AreasTransporters`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `AreasTransporters` ( `ID` varchar(38) NOT NULL, `IdArea` varchar(38) NOT NULL, `IdTransporter` varchar(38) NOT NULL, `FromDate` datetime DEFAULT NULL, `ToDate` datetime DEFAULT NULL, `Rate` decimal(19,4) DEFAULT NULL, `UseDefaultRate` tinyint(1) DEFAULT '0', `PackListExportType` varchar(255) DEFAULT NULL, `RepliesImportType` varchar(255) DEFAULT NULL, `Note` longtext, `LastUpdate` datetime NOT NULL, `Version` int(11) NOT NULL, PRIMARY KEY (`ID`), KEY `FromDate` (`FromDate`), KEY `ToDate` (`ToDate`), KEY `FK_Transporter_AreasTransporters_idx` (`IdTransporter`), KEY `FK_Area_AreasTransporters_idx` (`IdArea`), CONSTRAINT `FK_Area_AreasTransporters` FOREIGN KEY (`IdArea`) REFERENCES `areas` (`ID`) ON DELETE CASCADE, CONSTRAINT `FK_Transporter_AreasTransporters` FOREIGN KEY (`IdTransporter`) REFERENCES `transporters` (`ID`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `Banks` -- DROP TABLE IF EXISTS `Banks`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `Banks` ( `ID` varchar(38) NOT NULL, `Description` varchar(50) NOT NULL, `Agency` varchar(2000) DEFAULT NULL, `IBAN` varchar(50) NOT NULL, `SWIFT` varchar(50) DEFAULT NULL, `IsDefault` tinyint(1) DEFAULT '0', `GC_Code` varchar(50) DEFAULT '0', `SortOrder` int(11) DEFAULT NULL, `LastUpdate` datetime NOT NULL, `Version` int(11) NOT NULL, PRIMARY KEY (`ID`), UNIQUE KEY `Description` (`Description`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `CAPs` -- DROP TABLE IF EXISTS `CAPs`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `CAPs` ( `Istat` varchar(10) NOT NULL, `City` varchar(50) DEFAULT NULL, `Province` varchar(2) DEFAULT NULL, `Country` varchar(30) DEFAULT NULL, `CAP` varchar(5) DEFAULT NULL, `IdArea` varchar(38) DEFAULT NULL, `CodZona` varchar(45) DEFAULT NULL, PRIMARY KEY (`Istat`), UNIQUE KEY `UK_CAP` (`City`,`Province`,`Country`,`CAP`), KEY `City` (`City`), KEY `CAP` (`CAP`), KEY `FK_IdArea_idx` (`IdArea`), CONSTRAINT `FK_IdArea` FOREIGN KEY (`IdArea`) REFERENCES `areas` (`ID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `CashReceiptPackages` -- DROP TABLE IF EXISTS `CashReceiptPackages`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `CashReceiptPackages` ( `ID` varchar(38) NOT NULL, `IdCashReceipt` varchar(38) NOT NULL, `IdPackage` varchar(38) NOT NULL, `COD_Amount` decimal(19,4) NOT NULL DEFAULT '0.0000', `COD_PayType` varchar(50) NOT NULL, `COD_Note` longtext, `PA_Amount` decimal(19,4) NOT NULL DEFAULT '0.0000', `PA_PayType` varchar(50) NOT NULL, `PA_Note` longtext, `LastUpdate` datetime NOT NULL, `Version` int(11) NOT NULL, `CheckType` varchar(50) NOT NULL DEFAULT 'NONE', `CanDeposit` tinyint(1) NOT NULL DEFAULT '0', `CheckNumber` varchar(50) DEFAULT NULL, `CheckBankName` varchar(250) DEFAULT NULL, `CheckBankPlace` varchar(500) DEFAULT NULL, PRIMARY KEY (`ID`), KEY `FK_Package_CashReceiptPackages_idx` (`IdPackage`), KEY `FK_CashReceipt_CashReceiptPackages_idx` (`IdCashReceipt`), CONSTRAINT `FK_CashReceipt_CashReceiptPackages` FOREIGN KEY (`IdCashReceipt`) REFERENCES `cashreceipts` (`ID`) ON DELETE CASCADE, CONSTRAINT `FK_Package_CashReceiptPackages` FOREIGN KEY (`IdPackage`) REFERENCES `packages` (`ID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `CashReceipts` -- DROP TABLE IF EXISTS `CashReceipts`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `CashReceipts` ( `ID` varchar(38) NOT NULL, `Number` int(11) NOT NULL, `Date` datetime NOT NULL, `IdTransporter` varchar(38) NOT NULL, `LastUpdate` datetime NOT NULL, `Version` int(11) NOT NULL, `Status` varchar(50) NOT NULL DEFAULT 'Approved', `PrintingNumber` int(11) DEFAULT NULL, `PrintingDate` datetime DEFAULT NULL, `IdDriver` varchar(38) DEFAULT NULL, PRIMARY KEY (`ID`), KEY `Date` (`Date`), KEY `Number` (`Number`), KEY `FK_Transporter_CashReceipts_idx` (`IdTransporter`), KEY `FK_Driver_CashReceipts_idx` (`IdDriver`), CONSTRAINT `FK_Driver_CashReceipts` FOREIGN KEY (`IdDriver`) REFERENCES `drivers` (`ID`), CONSTRAINT `FK_Transporter_CashReceipts` FOREIGN KEY (`IdTransporter`) REFERENCES `transporters` (`ID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `CashReturnPackages` -- DROP TABLE IF EXISTS `CashReturnPackages`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `CashReturnPackages` ( `ID` varchar(38) NOT NULL, `IdCashReturn` varchar(38) NOT NULL, `IdCashReceiptPackage` varchar(38) NOT NULL, `Amount` decimal(19,4) NOT NULL DEFAULT '0.0000', `PayType` varchar(50) NOT NULL, `Note` longtext, `LastUpdate` datetime NOT NULL, `Version` int(11) NOT NULL, `TransactionNumber` varchar(250) DEFAULT NULL, `IdExportEventSession` varchar(38) DEFAULT NULL, `ExportEventStatus` tinyint(3) DEFAULT NULL, `ExportEventSentDate` datetime DEFAULT NULL, PRIMARY KEY (`ID`), KEY `FK_CashReceiptPackage_CashReturnPackages_idx` (`IdCashReceiptPackage`), KEY `FK_CashReturn_CashReturnPackages_idx` (`IdCashReturn`), KEY `IDX_IdExportEventSession` (`IdExportEventSession`), CONSTRAINT `FK_CashReceiptPackage_CashReturnPackages` FOREIGN KEY (`IdCashReceiptPackage`) REFERENCES `cashreceiptpackages` (`ID`), CONSTRAINT `FK_CashReturn_CashReturnPackages` FOREIGN KEY (`IdCashReturn`) REFERENCES `cashreturns` (`ID`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `CashReturns` -- DROP TABLE IF EXISTS `CashReturns`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `CashReturns` ( `ID` varchar(38) NOT NULL, `Number` int(11) NOT NULL, `Date` datetime NOT NULL, `Note` longtext, `IdPublisher` varchar(38) NOT NULL, `LastUpdate` datetime NOT NULL, `Version` int(11) NOT NULL, `Status` varchar(50) NOT NULL DEFAULT 'ToApprove', `NoteHidden` longtext, `ReturnType` varchar(50) NOT NULL DEFAULT 'Cash', `SentDate` datetime DEFAULT NULL, PRIMARY KEY (`ID`), KEY `Date` (`Date`), KEY `Number` (`Number`), KEY `FK_Publisher_CashReturns_idx` (`IdPublisher`), CONSTRAINT `FK_Publisher_CashReturns` FOREIGN KEY (`IdPublisher`) REFERENCES `publishers` (`ID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `CashReturnsBanknotes` -- DROP TABLE IF EXISTS `CashReturnsBanknotes`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `CashReturnsBanknotes` ( `ID` varchar(38) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, `IdCashReturn` varchar(38) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, `IdCurrencyBanknote` varchar(38) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, `Version` int(11) NOT NULL, `LastUpdate` datetime NOT NULL, `Amount` int(11) DEFAULT NULL, PRIMARY KEY (`ID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `Cooperatives` -- DROP TABLE IF EXISTS `Cooperatives`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `Cooperatives` ( `ID` varchar(38) NOT NULL, `Code` varchar(10) DEFAULT NULL, `Name` varchar(50) DEFAULT NULL, `EMail` varchar(255) DEFAULT NULL, `Phone` varchar(255) DEFAULT NULL, `Note` longtext, `Deleted` tinyint(1) DEFAULT '0', `LastUpdate` datetime NOT NULL, `Version` int(11) NOT NULL, `Address` varchar(250) DEFAULT NULL, `City` varchar(50) DEFAULT NULL, `ZipCode` varchar(5) DEFAULT NULL, `Country` varchar(2) DEFAULT NULL, `State` varchar(3) DEFAULT NULL, `Register` varchar(250) DEFAULT NULL, `PIva` varchar(13) DEFAULT NULL, `CF` varchar(16) DEFAULT NULL, PRIMARY KEY (`ID`), UNIQUE KEY `Code` (`Code`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `CooperativesBillings` -- DROP TABLE IF EXISTS `CooperativesBillings`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `CooperativesBillings` ( `ID` varchar(38) NOT NULL, `BillDate` datetime NOT NULL, `IdCooperative` varchar(38) NOT NULL, `ToDate` datetime DEFAULT NULL, `LastUpdate` datetime NOT NULL, `Version` int(11) NOT NULL, PRIMARY KEY (`ID`), KEY `BillDate` (`BillDate`), KEY `FK_Cooperative_CooperativesBillings_idx` (`IdCooperative`), CONSTRAINT `FK_Cooperative_CooperativesBillings` FOREIGN KEY (`IdCooperative`) REFERENCES `cooperatives` (`ID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `CooperativesBillingsPackages` -- DROP TABLE IF EXISTS `CooperativesBillingsPackages`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `CooperativesBillingsPackages` ( `ID` varchar(38) NOT NULL, `IdOutPackage` varchar(38) DEFAULT NULL, `IdCooperativeBilling` varchar(38) NOT NULL, `BaseRate` decimal(19,4) DEFAULT NULL, `PackageRate` decimal(19,4) DEFAULT NULL, `ReDelivery` tinyint(1) DEFAULT '0', `LastUpdate` datetime NOT NULL, `Version` int(11) NOT NULL, `Weight` int(11) DEFAULT NULL, `Boxes` int(11) DEFAULT '1', `Pallets` int(11) DEFAULT NULL, `Volume` decimal(19,4) DEFAULT NULL, `UnitType` varchar(50) DEFAULT NULL, `Quantity` decimal(19,4) NOT NULL DEFAULT '1.0000', `IdMerge` varchar(38) DEFAULT NULL, `ErrorDescription` longtext, `IdPackageType` int(11) DEFAULT NULL, PRIMARY KEY (`ID`), KEY `FK_CooperativesBilling_CooperativesBillingsPackages_idx` (`IdCooperativeBilling`), KEY `FK_OutPackage_CooperativesBillingsPackages_idx` (`IdOutPackage`), KEY `FK_PackageTypes_CooperativesBillingsPackages` (`IdPackageType`), CONSTRAINT `FK_CooperativesBilling_CooperativesBillingsPackages` FOREIGN KEY (`IdCooperativeBilling`) REFERENCES `cooperativesbillings` (`ID`) ON DELETE CASCADE, CONSTRAINT `FK_OutPackage_CooperativesBillingsPackages` FOREIGN KEY (`IdOutPackage`) REFERENCES `outpackages` (`ID`) ON DELETE CASCADE, CONSTRAINT `FK_PackageTypes_CooperativesBillingsPackages` FOREIGN KEY (`IdPackageType`) REFERENCES `packagetypes` (`ID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `CooperativesRates` -- DROP TABLE IF EXISTS `CooperativesRates`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `CooperativesRates` ( `ID` varchar(38) NOT NULL, `IdCooperative` varchar(38) DEFAULT NULL, `FromDate` datetime NOT NULL, `ToDate` datetime NOT NULL, `MergeForReceiverInDate` tinyint(1) DEFAULT '0', `IgnoreReceiverNameWhileMerge` tinyint(1) DEFAULT NULL, `IgnoreSenderGroupWhileMerge` tinyint(1) DEFAULT NULL, `UnitsToIgnore` int(11) NOT NULL DEFAULT '14', `Description` varchar(50) DEFAULT NULL, `VolumeWeight` decimal(19,4) DEFAULT '0.0000', `BoxesWeight` decimal(19,4) DEFAULT '0.0000', `PalletsWeight` decimal(19,4) DEFAULT '0.0000', `LastUpdate` datetime NOT NULL, `Version` int(11) NOT NULL, `ReDeliveryChangeType` varchar(1) DEFAULT '%', `ReDeliveryChangeVal` decimal(19,4) DEFAULT '100.0000', PRIMARY KEY (`ID`), KEY `IDX_TransportersRates_ToDate` (`ToDate`), KEY `IDX_TransportersRates_FromDate` (`FromDate`), KEY `FK_Cooperative_CooperativesRates_idx` (`IdCooperative`), CONSTRAINT `FK_Cooperative_CooperativesRates` FOREIGN KEY (`IdCooperative`) REFERENCES `cooperatives` (`ID`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `CooperativesRatesBases` -- DROP TABLE IF EXISTS `CooperativesRatesBases`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `CooperativesRatesBases` ( `ID` varchar(38) NOT NULL, `IdCooperativeRate` varchar(38) NOT NULL, `Rate` decimal(19,4) DEFAULT NULL, `LastUpdate` datetime NOT NULL, `Version` int(11) NOT NULL, `MinVal` decimal(19,4) DEFAULT NULL, `MaxVal` decimal(19,4) DEFAULT NULL, `UnitGap` decimal(19,4) DEFAULT NULL, `UnitType` varchar(45) NOT NULL DEFAULT 'Boxes', `RoundToUnitGap` tinyint(1) NOT NULL DEFAULT '0', `IdPackageType` int(11) DEFAULT NULL, PRIMARY KEY (`ID`), KEY `FK_CooperativesRates_CooperativesRatesBases_idx` (`IdCooperativeRate`), KEY `FK_PackageTypes_CooperativesRatesBases_idx` (`IdPackageType`), CONSTRAINT `FK_CooperativesRates_CooperativesRatesBases` FOREIGN KEY (`IdCooperativeRate`) REFERENCES `cooperativesrates` (`ID`) ON DELETE CASCADE, CONSTRAINT `FK_PackageTypes_CooperativesRatesBases` FOREIGN KEY (`IdPackageType`) REFERENCES `packagetypes` (`ID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `CooperativesRatesPublisherSenders` -- DROP TABLE IF EXISTS `CooperativesRatesPublisherSenders`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `CooperativesRatesPublisherSenders` ( `ID` varchar(38) NOT NULL, `IdCooperativeRate` varchar(38) NOT NULL, `IdPublisher` varchar(38) NOT NULL, `IdPublisherSender` varchar(38) DEFAULT NULL, `LastUpdate` datetime NOT NULL, `Version` int(11) NOT NULL, PRIMARY KEY (`ID`), KEY `FK_CooperativesRates_CooperativesRatesPublisherSenders_idx` (`IdCooperativeRate`), KEY `FK_Publishers_CooperativesRatesPublisherSenders_idx` (`IdPublisher`), KEY `FK_PublishersSenders_CooperativesRatesPublisherSenders_idx` (`IdPublisherSender`), CONSTRAINT `FK_CooperativesRates_CooperativesRatesPublisherSenders` FOREIGN KEY (`IdCooperativeRate`) REFERENCES `cooperativesrates` (`ID`) ON DELETE CASCADE, CONSTRAINT `FK_PublishersSenders_CooperativesRatesPublisherSenders` FOREIGN KEY (`IdPublisherSender`) REFERENCES `publisherssenders` (`ID`), CONSTRAINT `FK_Publishers_CooperativesRatesPublisherSenders` FOREIGN KEY (`IdPublisher`) REFERENCES `publishers` (`ID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `CreditNoteDetails` -- DROP TABLE IF EXISTS `CreditNoteDetails`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `CreditNoteDetails` ( `ID` varchar(38) NOT NULL, `IdCreditNote` varchar(38) NOT NULL, `Code` varchar(50) DEFAULT NULL, `Description` longtext, `IdTaxType` varchar(38) NOT NULL, `UnitAmount` decimal(19,8) DEFAULT NULL, `FixedAmount` decimal(19,8) DEFAULT NULL, `Quantity` decimal(19,8) DEFAULT NULL, `UnitType` varchar(50) DEFAULT NULL, `DiscountPerc_01` decimal(19,8) DEFAULT NULL, `DiscountPerc_02` decimal(19,8) DEFAULT NULL, `DiscountPerc_03` decimal(19,8) DEFAULT NULL, `DiscountVal` decimal(19,8) DEFAULT NULL, `LastUpdate` datetime NOT NULL, `Version` int(11) NOT NULL, `RowAmount` decimal(19,8) NOT NULL, `TaxAmount` decimal(19,8) NOT NULL, `DetailGroup` varchar(100) DEFAULT NULL, `IdPackage` varchar(38) DEFAULT NULL, PRIMARY KEY (`ID`), KEY `CreditNoteDetail_CreditNote` (`IdCreditNote`), KEY `FK_CreditNoteDetail_TaxType` (`IdTaxType`), KEY `FK_CreditNoteDetail_Package_idx` (`IdPackage`), CONSTRAINT `FK_CreditNoteDetail_CreditNote` FOREIGN KEY (`IdCreditNote`) REFERENCES `creditnotes` (`ID`) ON DELETE CASCADE, CONSTRAINT `FK_CreditNoteDetail_Package` FOREIGN KEY (`IdPackage`) REFERENCES `packages` (`ID`), CONSTRAINT `FK_CreditNoteDetail_TaxType` FOREIGN KEY (`IdTaxType`) REFERENCES `taxtypes` (`ID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `CreditNotes` -- DROP TABLE IF EXISTS `CreditNotes`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `CreditNotes` ( `ID` varchar(38) NOT NULL, `DocumentType` varchar(50) DEFAULT NULL, `NumberPrefix` varchar(10) DEFAULT NULL, `Number` int(11) DEFAULT NULL, `NumberYear` int(11) DEFAULT NULL, `NumberSuffix` varchar(10) DEFAULT NULL, `Date` datetime NOT NULL, `IdPublisher` varchar(38) DEFAULT NULL, `HeaderText` longtext, `ReceiverText` longtext, `PIVA` varchar(30) DEFAULT NULL, `CF` varchar(50) DEFAULT NULL, `IdTaxType` varchar(38) NOT NULL, `IdPaymentType` varchar(38) NOT NULL, `IdBank` varchar(38) DEFAULT NULL, `DiscountPerc_01` decimal(19,8) NOT NULL DEFAULT '0.00000000', `DiscountPerc_02` decimal(19,8) NOT NULL DEFAULT '0.00000000', `DiscountPerc_03` decimal(19,8) NOT NULL DEFAULT '0.00000000', `DiscountVal` decimal(19,8) NOT NULL DEFAULT '0.00000000', `FixedCost` decimal(19,8) NOT NULL DEFAULT '0.00000000', `BoxCost` decimal(19,8) NOT NULL DEFAULT '0.00000000', `TransportCost` decimal(19,8) NOT NULL DEFAULT '0.00000000', `TransportNote` longtext, `Note` longtext, `LastUpdate` datetime NOT NULL, `Version` int(11) NOT NULL, `PrePaymentAmount` decimal(19,4) DEFAULT NULL, `TotalAmount` decimal(19,8) DEFAULT NULL, `TaxAmount` decimal(19,8) DEFAULT NULL, `SentDate` datetime DEFAULT NULL, `Status` varchar(50) DEFAULT NULL, `PIVAState` varchar(2) DEFAULT NULL, `CompanyName` varchar(200) DEFAULT NULL, `LastName` varchar(100) DEFAULT NULL, `FirstName` varchar(100) DEFAULT NULL, `Address` varchar(250) DEFAULT NULL, `CivicNumber` varchar(20) DEFAULT NULL, `ZipCode` varchar(10) DEFAULT NULL, `City` varchar(50) DEFAULT NULL, `Country` varchar(5) DEFAULT NULL, `State` varchar(5) DEFAULT NULL, `DestinationCode` varchar(20) DEFAULT NULL, `PEC` varchar(250) DEFAULT NULL, PRIMARY KEY (`ID`), UNIQUE KEY `Number` (`NumberPrefix`,`Number`,`NumberYear`), KEY `FK_CreditNote_Publisher` (`IdPublisher`), KEY `FK_CreditNote_TaxType` (`IdTaxType`), KEY `FK_CreditNote_PaymentType` (`IdPaymentType`), KEY `FK_CreditNote_Bank` (`IdBank`), CONSTRAINT `FK_CreditNote_Bank` FOREIGN KEY (`IdBank`) REFERENCES `banks` (`ID`), CONSTRAINT `FK_CreditNote_PaymentType` FOREIGN KEY (`IdPaymentType`) REFERENCES `paymenttypes` (`ID`), CONSTRAINT `FK_CreditNote_Publisher` FOREIGN KEY (`IdPublisher`) REFERENCES `publishers` (`ID`), CONSTRAINT `FK_CreditNote_TaxType` FOREIGN KEY (`IdTaxType`) REFERENCES `taxtypes` (`ID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `Currencies` -- DROP TABLE IF EXISTS `Currencies`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `Currencies` ( `ID` varchar(38) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, `Name` varchar(100) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, `IsDefault` tinyint(1) NOT NULL, `Version` int(11) NOT NULL, `LastUpdate` datetime NOT NULL, PRIMARY KEY (`ID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `CurrencyBanknotes` -- DROP TABLE IF EXISTS `CurrencyBanknotes`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `CurrencyBanknotes` ( `ID` varchar(38) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, `IdCurrency` varchar(38) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, `Description` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, `Value` decimal(10,2) NOT NULL, `Version` int(11) NOT NULL, `LastUpdate` datetime NOT NULL, PRIMARY KEY (`ID`), KEY `fk_currency_currencyBanknotes_idx` (`IdCurrency`), CONSTRAINT `fk_currency_currencyBanknotes` FOREIGN KEY (`IdCurrency`) REFERENCES `currencies` (`ID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `DebitNoteDetails` -- DROP TABLE IF EXISTS `DebitNoteDetails`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `DebitNoteDetails` ( `ID` varchar(38) NOT NULL, `IdDebitNote` varchar(38) NOT NULL, `Code` varchar(50) DEFAULT NULL, `Description` longtext, `IdTaxType` varchar(38) NOT NULL, `UnitAmount` decimal(19,8) DEFAULT NULL, `FixedAmount` decimal(19,8) DEFAULT NULL, `Quantity` decimal(19,8) DEFAULT NULL, `UnitType` varchar(50) DEFAULT NULL, `DiscountPerc_01` decimal(19,8) DEFAULT NULL, `DiscountPerc_02` decimal(19,8) DEFAULT NULL, `DiscountPerc_03` decimal(19,8) DEFAULT NULL, `DiscountVal` decimal(19,8) DEFAULT NULL, `LastUpdate` datetime NOT NULL, `Version` int(11) NOT NULL, `RowAmount` decimal(19,8) NOT NULL, `TaxAmount` decimal(19,8) NOT NULL, `DetailGroup` varchar(100) DEFAULT NULL, `IdPackage` varchar(38) DEFAULT NULL, PRIMARY KEY (`ID`), KEY `DebitNoteDetail_DebitNote` (`IdDebitNote`), KEY `FK_DebitNoteDetail_TaxType` (`IdTaxType`), KEY `FK_DebitNoteDetail_Package_idx` (`IdPackage`), CONSTRAINT `FK_DebitNoteDetail_DebitNote` FOREIGN KEY (`IdDebitNote`) REFERENCES `debitnotes` (`ID`) ON DELETE CASCADE, CONSTRAINT `FK_DebitNoteDetail_Package` FOREIGN KEY (`IdPackage`) REFERENCES `packages` (`ID`), CONSTRAINT `FK_DebitNoteDetail_TaxType` FOREIGN KEY (`IdTaxType`) REFERENCES `taxtypes` (`ID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `DebitNotes` -- DROP TABLE IF EXISTS `DebitNotes`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `DebitNotes` ( `ID` varchar(38) NOT NULL, `DocumentType` varchar(50) DEFAULT NULL, `NumberPrefix` varchar(10) DEFAULT NULL, `Number` int(11) DEFAULT NULL, `NumberYear` int(11) DEFAULT NULL, `NumberSuffix` varchar(10) DEFAULT NULL, `Date` datetime NOT NULL, `IdPublisher` varchar(38) DEFAULT NULL, `HeaderText` longtext, `ReceiverText` longtext, `PIVA` varchar(30) DEFAULT NULL, `CF` varchar(50) DEFAULT NULL, `IdTaxType` varchar(38) NOT NULL, `IdPaymentType` varchar(38) NOT NULL, `IdBank` varchar(38) DEFAULT NULL, `DiscountPerc_01` decimal(19,8) NOT NULL DEFAULT '0.00000000', `DiscountPerc_02` decimal(19,8) NOT NULL DEFAULT '0.00000000', `DiscountPerc_03` decimal(19,8) NOT NULL DEFAULT '0.00000000', `DiscountVal` decimal(19,8) NOT NULL DEFAULT '0.00000000', `FixedCost` decimal(19,8) NOT NULL DEFAULT '0.00000000', `BoxCost` decimal(19,8) NOT NULL DEFAULT '0.00000000', `TransportCost` decimal(19,8) NOT NULL DEFAULT '0.00000000', `TransportNote` longtext, `Note` longtext, `LastUpdate` datetime NOT NULL, `Version` int(11) NOT NULL, `PrePaymentAmount` decimal(19,4) DEFAULT NULL, `TotalAmount` decimal(19,8) DEFAULT NULL, `TaxAmount` decimal(19,8) DEFAULT NULL, `SentDate` datetime DEFAULT NULL, `Status` varchar(50) DEFAULT NULL, `PIVAState` varchar(2) DEFAULT NULL, `CompanyName` varchar(200) DEFAULT NULL, `LastName` varchar(100) DEFAULT NULL, `FirstName` varchar(100) DEFAULT NULL, `Address` varchar(250) DEFAULT NULL, `CivicNumber` varchar(20) DEFAULT NULL, `ZipCode` varchar(10) DEFAULT NULL, `City` varchar(50) DEFAULT NULL, `Country` varchar(5) DEFAULT NULL, `State` varchar(5) DEFAULT NULL, `DestinationCode` varchar(20) DEFAULT NULL, `PEC` varchar(250) DEFAULT NULL, PRIMARY KEY (`ID`), UNIQUE KEY `Number` (`NumberPrefix`,`Number`,`NumberYear`), KEY `FK_DebitNote_Publisher` (`IdPublisher`), KEY `FK_DebitNote_TaxType` (`IdTaxType`), KEY `FK_DebitNote_PaymentType` (`IdPaymentType`), KEY `FK_DebitNote_Bank` (`IdBank`), CONSTRAINT `FK_DebitNote_Bank` FOREIGN KEY (`IdBank`) REFERENCES `banks` (`ID`), CONSTRAINT `FK_DebitNote_PaymentType` FOREIGN KEY (`IdPaymentType`) REFERENCES `paymenttypes` (`ID`), CONSTRAINT `FK_DebitNote_Publisher` FOREIGN KEY (`IdPublisher`) REFERENCES `publishers` (`ID`), CONSTRAINT `FK_DebitNote_TaxType` FOREIGN KEY (`IdTaxType`) REFERENCES `taxtypes` (`ID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `DeletedObjects` -- DROP TABLE IF EXISTS `DeletedObjects`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `DeletedObjects` ( `ID` varchar(38) NOT NULL, `Type` varchar(255) NOT NULL, `Assembly` varchar(255) NOT NULL, PRIMARY KEY (`ID`), KEY `Type` (`Type`), KEY `Assembly` (`Assembly`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `DeliveryDateCodes` -- DROP TABLE IF EXISTS `DeliveryDateCodes`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `DeliveryDateCodes` ( `ID` varchar(38) NOT NULL, `Code` varchar(45) NOT NULL, `Description` varchar(50) NOT NULL, `SortOrder` int(11) DEFAULT NULL, `LastUpdate` datetime NOT NULL, `Version` int(11) NOT NULL, PRIMARY KEY (`ID`), UNIQUE KEY `Code_UNIQUE` (`Code`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `DeliveryDateTypes` -- DROP TABLE IF EXISTS `DeliveryDateTypes`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `DeliveryDateTypes` ( `ID` varchar(38) NOT NULL, `Code` varchar(45) NOT NULL, `Description` varchar(50) NOT NULL, `SortOrder` int(11) DEFAULT NULL, `LastUpdate` datetime NOT NULL, `Version` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `DeliveryTypes` -- DROP TABLE IF EXISTS `DeliveryTypes`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `DeliveryTypes` ( `ID` int(11) NOT NULL, `Code` varchar(2) NOT NULL, `Description` varchar(50) NOT NULL, `SortOrder` int(11) DEFAULT NULL, PRIMARY KEY (`ID`), UNIQUE KEY `Code` (`Code`), KEY `IDX_SortOrder` (`SortOrder`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- 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, `ExcludeFromEuroQ` tinyint(1) DEFAULT 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`), CONSTRAINT `fk_drivers_vehicles` FOREIGN KEY (`IdDefaultVehicle`) REFERENCES `vehicles` (`ID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; ALTER DATABASE `Waspnet_Courier` CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci ; /*!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 = utf8mb4 */ ; /*!50003 SET character_set_results = utf8mb4 */ ; /*!50003 SET collation_connection = utf8mb4_0900_ai_ci */ ; /*!50003 SET @saved_sql_mode = @@sql_mode */ ; /*!50003 SET sql_mode = 'STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION' */ ; DELIMITER ;; /*!50003 CREATE*/ /*!50017 DEFINER=`waspnet`@`%`*/ /*!50003 TRIGGER `Drivers_AFTER_INSERT` AFTER INSERT ON `drivers` FOR EACH ROW BEGIN INSERT INTO `Drivers_History` (`ID`, `FirstName`, `LastName`, `Username`, `Password`, `WebAccessEnabled`, `Email`, `LicenseNumber`, `BirthDate`, `Version`, `LastUpdate`, `IdDefaultVehicle`, `IdTransporter`, `ExcludeFromEuroQ` ) 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`, new.`ExcludeFromEuroQ` ); 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 */ ; ALTER DATABASE `Waspnet_Courier` CHARACTER SET utf8 COLLATE utf8_bin ; ALTER DATABASE `Waspnet_Courier` CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci ; /*!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 = utf8mb4 */ ; /*!50003 SET character_set_results = utf8mb4 */ ; /*!50003 SET collation_connection = utf8mb4_0900_ai_ci */ ; /*!50003 SET @saved_sql_mode = @@sql_mode */ ; /*!50003 SET sql_mode = 'STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION' */ ; DELIMITER ;; /*!50003 CREATE*/ /*!50017 DEFINER=`waspnet`@`%`*/ /*!50003 TRIGGER `Drivers_AFTER_UPDATE` AFTER UPDATE ON `drivers` FOR EACH ROW BEGIN INSERT INTO `Drivers_History` (`ID`, `FirstName`, `LastName`, `Username`, `Password`, `WebAccessEnabled`, `Email`, `LicenseNumber`, `BirthDate`, `Version`, `LastUpdate`, `IdDefaultVehicle`, `IdTransporter`, `ExcludeFromEuroQ` ) 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`, new.`ExcludeFromEuroQ` ); 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 */ ; ALTER DATABASE `Waspnet_Courier` CHARACTER SET utf8 COLLATE utf8_bin ; -- -- 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, `ExcludeFromEuroQ` tinyint(1) DEFAULT NULL, PRIMARY KEY (`HistorizationNumber`), KEY `IDX_ID_Session` (`ID`,`IdSynchronizationSession`), KEY `IDX_SyncSession` (`IdSynchronizationSession`,`SynchronizationDate`), KEY `IDX_ID_History` (`ID`,`HistorizationNumber`), KEY `IDX_MaxHistory` (`IdSynchronizationSession`,`HistorizationNumber`) ) ENGINE=InnoDB AUTO_INCREMENT=106 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `EPalReceiptPackages` -- DROP TABLE IF EXISTS `EPalReceiptPackages`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `EPalReceiptPackages` ( `ID` varchar(38) NOT NULL, `IdEPalReceipt` varchar(38) NOT NULL, `IdPackage` varchar(38) NOT NULL, `Amount` int(11) NOT NULL DEFAULT '0', `Note` longtext, `LastUpdate` datetime NOT NULL, `Version` int(11) NOT NULL, PRIMARY KEY (`ID`), KEY `FK_Package_EPalReceiptPackages_idx` (`IdPackage`), KEY `FK_EPalReceipt_EPalReceiptPackages_idx` (`IdEPalReceipt`), CONSTRAINT `FK_EPalReceipt_EPalReceiptPackages` FOREIGN KEY (`IdEPalReceipt`) REFERENCES `epalreceipts` (`ID`) ON DELETE CASCADE, CONSTRAINT `FK_Package_EPalReceiptPackages` FOREIGN KEY (`IdPackage`) REFERENCES `packages` (`ID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `EPalReceipts` -- DROP TABLE IF EXISTS `EPalReceipts`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `EPalReceipts` ( `ID` varchar(38) NOT NULL, `Number` int(11) NOT NULL, `Date` datetime NOT NULL, `IdTransporter` varchar(38) NOT NULL, `LastUpdate` datetime NOT NULL, `Version` int(11) NOT NULL, `Status` varchar(50) NOT NULL DEFAULT 'Approved', `PrintingNumber` int(11) DEFAULT NULL, `PrintingDate` datetime DEFAULT NULL, PRIMARY KEY (`ID`), KEY `Date` (`Date`), KEY `Number` (`Number`), KEY `FK_Transporter_EPalReceipts_idx` (`IdTransporter`), CONSTRAINT `FK_Transporter_EPalReceipts` FOREIGN KEY (`IdTransporter`) REFERENCES `transporters` (`ID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `EPalReturnPackages` -- DROP TABLE IF EXISTS `EPalReturnPackages`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `EPalReturnPackages` ( `ID` varchar(38) NOT NULL, `IdEPalReturn` varchar(38) NOT NULL, `IdEPalReceiptPackage` varchar(38) NOT NULL, `Amount` int(11) NOT NULL DEFAULT '0', `Note` longtext, `LastUpdate` datetime NOT NULL, `Version` int(11) NOT NULL, PRIMARY KEY (`ID`), KEY `FK_EPalReceiptPackage_EPalReturnPackages_idx` (`IdEPalReceiptPackage`), KEY `FK_EPalReturn_EPalReturnPackages_idx` (`IdEPalReturn`), CONSTRAINT `FK_EPalReceiptPackage_EPalReturnPackages` FOREIGN KEY (`IdEPalReceiptPackage`) REFERENCES `epalreceiptpackages` (`ID`), CONSTRAINT `FK_EPalReturn_EPalReturnPackages` FOREIGN KEY (`IdEPalReturn`) REFERENCES `epalreturns` (`ID`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `EPalReturns` -- DROP TABLE IF EXISTS `EPalReturns`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `EPalReturns` ( `ID` varchar(38) NOT NULL, `Number` int(11) NOT NULL, `Date` datetime NOT NULL, `Note` longtext, `IdPublisher` varchar(38) NOT NULL, `LastUpdate` datetime NOT NULL, `Version` int(11) NOT NULL, `Status` varchar(50) NOT NULL DEFAULT 'ToApprove', `NoteHidden` longtext, `EPalLostPerc` decimal(19,8) DEFAULT NULL, `Amount` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`ID`), KEY `Date` (`Date`), KEY `Number` (`Number`), KEY `FK_Publisher_EPalReturns_idx` (`IdPublisher`), CONSTRAINT `FK_Publisher_EPalReturns` FOREIGN KEY (`IdPublisher`) REFERENCES `publishers` (`ID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `EventType_IssuerTypes` -- DROP TABLE IF EXISTS `EventType_IssuerTypes`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `EventType_IssuerTypes` ( `IdEventType` int(11) NOT NULL, `IdIssuerType` int(11) NOT NULL, PRIMARY KEY (`IdEventType`,`IdIssuerType`), KEY `FK_EventType_EventType_idx` (`IdEventType`), KEY `FK_EventType_IssuerType_idx` (`IdIssuerType`), CONSTRAINT `FK_EventType_EventIssuer` FOREIGN KEY (`IdEventType`) REFERENCES `eventtypes` (`ID`) ON DELETE CASCADE, CONSTRAINT `FK_EventType_IssuerType` FOREIGN KEY (`IdIssuerType`) REFERENCES `issuertypes` (`ID`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `EventType_IssueTypes` -- DROP TABLE IF EXISTS `EventType_IssueTypes`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `EventType_IssueTypes` ( `IdEventType` int(11) NOT NULL, `IdIssueType` int(11) NOT NULL, `GenerateReturn` tinyint(1) DEFAULT NULL, PRIMARY KEY (`IdEventType`,`IdIssueType`), KEY `FK_EventType_EventType_idx` (`IdEventType`), KEY `FK_EventType_IssueType_idx` (`IdIssueType`), CONSTRAINT `FK_EventType_EventIssue` FOREIGN KEY (`IdEventType`) REFERENCES `eventtypes` (`ID`) ON DELETE CASCADE, CONSTRAINT `FK_EventType_IssueType` FOREIGN KEY (`IdIssueType`) REFERENCES `issuetypes` (`ID`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `EventTypes` -- DROP TABLE IF EXISTS `EventTypes`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `EventTypes` ( `ID` int(11) NOT NULL, `Code` varchar(5) COLLATE utf8_bin NOT NULL, `Description` varchar(50) COLLATE utf8_bin NOT NULL, PRIMARY KEY (`ID`), UNIQUE KEY `Code` (`Code`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `ExtraTypes` -- DROP TABLE IF EXISTS `ExtraTypes`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `ExtraTypes` ( `ID` int(11) NOT NULL, `Code` varchar(5) NOT NULL, `Description` varchar(50) NOT NULL, `SortOrder` int(11) DEFAULT NULL, `ExcludeFromEuroQ` tinyint(1) DEFAULT NULL, `ApplyOnShipping` tinyint(1) DEFAULT NULL, `ApplyOnBooking` tinyint(1) DEFAULT NULL, `ApplyOnReturn` tinyint(1) DEFAULT NULL, PRIMARY KEY (`ID`), UNIQUE KEY `Code` (`Code`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `FreeRowTypes` -- DROP TABLE IF EXISTS `FreeRowTypes`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `FreeRowTypes` ( `ID` int(11) NOT NULL, `Code` varchar(5) NOT NULL, `Description` varchar(50) NOT NULL, `SortOrder` int(11) DEFAULT NULL, PRIMARY KEY (`ID`), UNIQUE KEY `Code` (`Code`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `Identities` -- DROP TABLE IF EXISTS `Identities`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `Identities` ( `ObjectType` varchar(255) NOT NULL, `Year` int(11) NOT NULL, `Identity` int(11) DEFAULT NULL, PRIMARY KEY (`ObjectType`,`Year`), KEY `Identity` (`Identity`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `InPackLists` -- DROP TABLE IF EXISTS `InPackLists`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `InPackLists` ( `ID` varchar(38) NOT NULL, `Number` int(11) NOT NULL, `Date` datetime NOT NULL, `IdPublisher` varchar(38) NOT NULL, `FromWeb` tinyint(1) DEFAULT '0', `Status` varchar(50) NOT NULL DEFAULT 'Approved', `Changed` tinyint(1) DEFAULT '0', `LastUpdate` datetime NOT NULL, `Version` int(11) NOT NULL, `FileHash` varchar(256) DEFAULT NULL, `IdSender` varchar(38) DEFAULT NULL, `Note` varchar(2000) DEFAULT NULL, `TripReference` varchar(250) DEFAULT NULL, `IdOutPackList` varchar(38) DEFAULT NULL, `StatusDate` datetime DEFAULT NULL, PRIMARY KEY (`ID`), UNIQUE KEY `UK_FileHash` (`IdPublisher`,`IdSender`,`FileHash`), KEY `IDX_Status` (`Status`), KEY `IDX_Number` (`Number`), KEY `IDX_Date` (`Date`), KEY `FK_Publisher_InPackLists_idx` (`IdPublisher`), KEY `FK_Sender_InPackLists_idx` (`IdSender`), KEY `FK_OutPackLists_InPackLists_idx` (`IdOutPackList`), CONSTRAINT `FK_OutPackLists_InPackLists` FOREIGN KEY (`IdOutPackList`) REFERENCES `outpacklists` (`ID`), CONSTRAINT `FK_Publisher_InPackLists` FOREIGN KEY (`IdPublisher`) REFERENCES `publishers` (`ID`), CONSTRAINT `FK_Sender_InPackLists` FOREIGN KEY (`IdSender`) REFERENCES `publisherssenders` (`ID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `InStockPackages` -- DROP TABLE IF EXISTS `InStockPackages`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `InStockPackages` ( `ID` varchar(38) NOT NULL, `IdInStockPackList` varchar(38) DEFAULT NULL, `IdPackage` varchar(38) NOT NULL, `IdExportEventSession` varchar(38) DEFAULT NULL, `ExportEventStatus` tinyint(3) unsigned DEFAULT NULL, `ExportEventSentDate` datetime DEFAULT NULL, `LastUpdate` datetime NOT NULL, `Version` int(11) NOT NULL, PRIMARY KEY (`ID`), KEY `FK_Package_InStockPackages_idx` (`IdPackage`), KEY `FK_InStockPackList_InStockPackages_idx` (`IdInStockPackList`), KEY `IDX_IdExportEventSession` (`IdExportEventSession`), KEY `IDX_UpdateEventToSend_InStockPackages` (`IdExportEventSession`,`ExportEventSentDate`), CONSTRAINT `FK_InStockPackList_InStockPackages` FOREIGN KEY (`IdInStockPackList`) REFERENCES `instockpacklists` (`ID`) ON DELETE CASCADE, CONSTRAINT `FK_Package_InStockPackages` FOREIGN KEY (`IdPackage`) REFERENCES `packages` (`ID`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Temporary view structure for view `instockpackages_publisher` -- DROP TABLE IF EXISTS `instockpackages_publisher`; /*!50001 DROP VIEW IF EXISTS `instockpackages_publisher`*/; SET @saved_cs_client = @@character_set_client; /*!50503 SET character_set_client = utf8mb4 */; /*!50001 CREATE VIEW `instockpackages_publisher` AS SELECT 1 AS `ID`, 1 AS `IdPublisher`, 1 AS `IdExportEventSession`, 1 AS `ExportEventSentDate`*/; SET character_set_client = @saved_cs_client; -- -- Table structure for table `InStockPackLists` -- DROP TABLE IF EXISTS `InStockPackLists`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `InStockPackLists` ( `ID` varchar(38) NOT NULL, `Number` int(11) NOT NULL, `Date` datetime NOT NULL, `IdPublisher` varchar(38) NOT NULL, `LastUpdate` datetime NOT NULL, `Version` int(11) NOT NULL, `SentDate` datetime DEFAULT NULL, PRIMARY KEY (`ID`), KEY `Date` (`Date`), KEY `Number` (`Number`), KEY `FK_Publisher_InStockPackLists_idx` (`IdPublisher`), CONSTRAINT `FK_Publisher_InStockPackLists` FOREIGN KEY (`IdPublisher`) REFERENCES `publishers` (`ID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `InvoiceDetails` -- DROP TABLE IF EXISTS `InvoiceDetails`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `InvoiceDetails` ( `ID` varchar(38) NOT NULL, `IdInvoice` varchar(38) NOT NULL, `Code` varchar(50) DEFAULT NULL, `Description` longtext, `Id_PB_Package` varchar(38) DEFAULT NULL, `Id_PB_InStockPackage` varchar(38) DEFAULT NULL, `Id_PB_ReturnedPackage` varchar(38) DEFAULT NULL, `IdTaxType` varchar(38) NOT NULL, `UnitAmount` decimal(19,8) DEFAULT NULL, `FixedAmount` decimal(19,8) DEFAULT NULL, `Quantity` decimal(19,8) DEFAULT NULL, `UnitType` varchar(50) DEFAULT NULL, `DiscountPerc_01` decimal(19,8) DEFAULT NULL, `DiscountPerc_02` decimal(19,8) DEFAULT NULL, `DiscountPerc_03` decimal(19,8) DEFAULT NULL, `DiscountVal` decimal(19,8) DEFAULT NULL, `LastUpdate` datetime NOT NULL, `Version` int(11) NOT NULL, `RowAmount` decimal(19,8) NOT NULL, `TaxAmount` decimal(19,8) NOT NULL, `DetailGroup` varchar(100) DEFAULT NULL, `IdPackage` varchar(38) DEFAULT NULL, PRIMARY KEY (`ID`), KEY `FK_InvoiceDetail_Invoice` (`IdInvoice`), KEY `FK_InvoiceDetail_TaxType` (`IdTaxType`), KEY `FK_InvoiceDetail_PublishersBillingsPackages_idx` (`Id_PB_Package`), KEY `FK_InvoiceDetail_PublishersBillingsReturnedPackages_idx` (`Id_PB_ReturnedPackage`), KEY `FK_InvoiceDetail_PublishersBillingsInStockPackages_idx` (`Id_PB_InStockPackage`), KEY `FK_InvoiceDetail_Package_idx` (`IdPackage`), CONSTRAINT `FK_InvoiceDetail_Invoice` FOREIGN KEY (`IdInvoice`) REFERENCES `invoices` (`ID`) ON DELETE CASCADE, CONSTRAINT `FK_InvoiceDetail_Package` FOREIGN KEY (`IdPackage`) REFERENCES `packages` (`ID`), CONSTRAINT `FK_InvoiceDetail_PublishersBillingsInStockPackages` FOREIGN KEY (`Id_PB_InStockPackage`) REFERENCES `publishersbillingsinstockpackages` (`ID`) ON DELETE CASCADE, CONSTRAINT `FK_InvoiceDetail_PublishersBillingsPackages` FOREIGN KEY (`Id_PB_Package`) REFERENCES `publishersbillingspackages` (`ID`) ON DELETE CASCADE, CONSTRAINT `FK_InvoiceDetail_PublishersBillingsReturnedPackages` FOREIGN KEY (`Id_PB_ReturnedPackage`) REFERENCES `publishersbillingsreturnedpackages` (`ID`) ON DELETE CASCADE, CONSTRAINT `FK_InvoiceDetail_TaxType` FOREIGN KEY (`IdTaxType`) REFERENCES `taxtypes` (`ID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `Invoices` -- DROP TABLE IF EXISTS `Invoices`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `Invoices` ( `ID` varchar(38) NOT NULL, `DocumentType` varchar(50) DEFAULT NULL, `NumberPrefix` varchar(10) DEFAULT NULL, `Number` int(11) DEFAULT NULL, `NumberYear` int(11) DEFAULT NULL, `Date` datetime NOT NULL, `IdPublisher` varchar(38) DEFAULT NULL, `HeaderText` longtext, `ReceiverText` longtext, `PIVA` varchar(30) DEFAULT NULL, `CF` varchar(50) DEFAULT NULL, `IdTaxType` varchar(38) NOT NULL, `IdPaymentType` varchar(38) NOT NULL, `IdBank` varchar(38) DEFAULT NULL, `DiscountPerc_01` decimal(19,8) NOT NULL DEFAULT '0.00000000', `DiscountPerc_02` decimal(19,8) NOT NULL DEFAULT '0.00000000', `DiscountPerc_03` decimal(19,8) NOT NULL DEFAULT '0.00000000', `DiscountVal` decimal(19,8) NOT NULL DEFAULT '0.00000000', `FixedCost` decimal(19,8) NOT NULL DEFAULT '0.00000000', `BoxCost` decimal(19,8) NOT NULL DEFAULT '0.00000000', `TransportCost` decimal(19,8) NOT NULL DEFAULT '0.00000000', `TransportNote` longtext, `Note` longtext, `LastUpdate` datetime NOT NULL, `Version` int(11) NOT NULL, `PrePaymentAmount` decimal(19,4) DEFAULT NULL, `TotalAmount` decimal(19,8) DEFAULT NULL, `TaxAmount` decimal(19,8) DEFAULT NULL, `SentDate` datetime DEFAULT NULL, `Status` varchar(50) DEFAULT NULL, `PIVAState` varchar(2) DEFAULT NULL, `CompanyName` varchar(200) DEFAULT NULL, `LastName` varchar(100) DEFAULT NULL, `FirstName` varchar(100) DEFAULT NULL, `Address` varchar(250) DEFAULT NULL, `CivicNumber` varchar(20) DEFAULT NULL, `ZipCode` varchar(10) DEFAULT NULL, `City` varchar(50) DEFAULT NULL, `Country` varchar(5) DEFAULT NULL, `State` varchar(5) DEFAULT NULL, `DestinationCode` varchar(20) DEFAULT NULL, `PEC` varchar(250) DEFAULT NULL, PRIMARY KEY (`ID`), UNIQUE KEY `Number` (`NumberPrefix`,`Number`,`NumberYear`), KEY `FK_Invoice_Publisher` (`IdPublisher`), KEY `FK_Invoice_TaxType` (`IdTaxType`), KEY `FK_Invoice_PaymentType` (`IdPaymentType`), KEY `FK_Invoice_Bank` (`IdBank`), CONSTRAINT `FK_Invoice_Bank` FOREIGN KEY (`IdBank`) REFERENCES `banks` (`ID`), CONSTRAINT `FK_Invoice_PaymentType` FOREIGN KEY (`IdPaymentType`) REFERENCES `paymenttypes` (`ID`), CONSTRAINT `FK_Invoice_Publisher` FOREIGN KEY (`IdPublisher`) REFERENCES `publishers` (`ID`), CONSTRAINT `FK_Invoice_TaxType` FOREIGN KEY (`IdTaxType`) REFERENCES `taxtypes` (`ID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `IssuerTypes` -- DROP TABLE IF EXISTS `IssuerTypes`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `IssuerTypes` ( `ID` int(11) NOT NULL, `Code` varchar(5) COLLATE utf8_bin NOT NULL, `Description` varchar(50) COLLATE utf8_bin NOT NULL, `SpecifyPublisher` tinyint(1) DEFAULT NULL, `SpecifyTransporter` tinyint(1) DEFAULT NULL, `SpecifyCooperative` tinyint(1) DEFAULT NULL, `SpecifyWarehouse` tinyint(1) DEFAULT NULL, PRIMARY KEY (`ID`), UNIQUE KEY `Code` (`Code`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `IssueTypes` -- DROP TABLE IF EXISTS `IssueTypes`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `IssueTypes` ( `ID` int(11) NOT NULL, `Code` varchar(5) COLLATE utf8_bin NOT NULL, `Description` varchar(50) COLLATE utf8_bin NOT NULL, PRIMARY KEY (`ID`), UNIQUE KEY `Code` (`Code`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `MailAttachments` -- DROP TABLE IF EXISTS `MailAttachments`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `MailAttachments` ( `ID` varchar(38) NOT NULL, `IdDocument` varchar(38) NOT NULL, `FileName` varchar(200) NOT NULL, `FileContent` longblob NOT NULL, `LastUpdate` datetime NOT NULL, `Version` int(11) NOT NULL, PRIMARY KEY (`ID`), KEY `IDX_IdDocument` (`IdDocument`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `Menus` -- DROP TABLE IF EXISTS `Menus`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `Menus` ( `ID` varchar(50) NOT NULL, `IdOwnerMenu` varchar(50) DEFAULT NULL, `Description` varchar(50) NOT NULL, `Order` int(11) NOT NULL DEFAULT '0', `Level` int(11) NOT NULL DEFAULT '0', `Page` varchar(255) DEFAULT NULL, `LastUpdate` datetime NOT NULL, `Version` int(10) unsigned NOT NULL, PRIMARY KEY (`ID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `Months` -- DROP TABLE IF EXISTS `Months`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `Months` ( `ID` int(11) NOT NULL, `Code` varchar(3) NOT NULL, `Description` varchar(45) DEFAULT NULL, PRIMARY KEY (`ID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `OutPackages` -- DROP TABLE IF EXISTS `OutPackages`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `OutPackages` ( `ID` varchar(38) NOT NULL, `IdOutPackList` varchar(38) NOT NULL, `IdPackage` varchar(38) NOT NULL, `IdSubStatus` varchar(38) DEFAULT NULL, `IdArea` varchar(38) DEFAULT NULL, `Linked` tinyint(1) DEFAULT '0', `Order` int(11) NOT NULL, `LastUpdate` datetime NOT NULL, `Version` int(11) NOT NULL, `OutOfReachConfirmedBy` varchar(38) DEFAULT NULL, `TransporterRate` decimal(19,4) DEFAULT NULL, `PublisherRate` decimal(19,4) DEFAULT NULL, `StatusDate` datetime DEFAULT NULL, `StatusNotes` longtext, `ETA` datetime DEFAULT NULL, `ReturnDate` datetime DEFAULT NULL, `ArchivedDate` datetime DEFAULT NULL, PRIMARY KEY (`ID`), KEY `FK_Package_OutPackages_idx` (`IdPackage`), KEY `FK_OutPackList_OutPackages_idx` (`IdOutPackList`), KEY `FK_Area_OutPackages_idx` (`IdArea`), KEY `FK_PublishersSendersPackageSubStatus_OutPackages_idx` (`IdSubStatus`), KEY `IDX_IdOutPackList_IdPackage` (`IdOutPackList`,`IdPackage`), KEY `IDX_Linked` (`Linked`), CONSTRAINT `FK_Area_OutPackages` FOREIGN KEY (`IdArea`) REFERENCES `areas` (`ID`), CONSTRAINT `FK_OutPackList_OutPackages` FOREIGN KEY (`IdOutPackList`) REFERENCES `outpacklists` (`ID`) ON DELETE CASCADE, CONSTRAINT `FK_Package_OutPackages` FOREIGN KEY (`IdPackage`) REFERENCES `packages` (`ID`) ON DELETE CASCADE, CONSTRAINT `FK_PublishersSendersPackageSubStatus_OutPackages` FOREIGN KEY (`IdSubStatus`) REFERENCES `packagesubstatus` (`ID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; ALTER DATABASE `Waspnet_Courier` CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci ; /*!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 = utf8mb4 */ ; /*!50003 SET character_set_results = utf8mb4 */ ; /*!50003 SET collation_connection = utf8mb4_0900_ai_ci */ ; /*!50003 SET @saved_sql_mode = @@sql_mode */ ; /*!50003 SET sql_mode = 'STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION' */ ; DELIMITER ;; /*!50003 CREATE*/ /*!50017 DEFINER=`waspnet`@`%`*/ /*!50003 TRIGGER `OutPackages_AFTER_INSERT` AFTER INSERT ON `outpackages` FOR EACH ROW BEGIN INSERT INTO `OutPackages_History` (`ID`, `IdOutPackList`, `IdPackage`, `IdArea`, `IdSubStatus`, `StatusDate`, `StatusNotes`, `Linked`, `Order`, `LastUpdate`, `Version`, `OutOfReachConfirmedBy`, `PublisherRate`, `TransporterRate`, `ETA`, `ReturnDate` ) VALUES ( NEW.ID, NEW.IdOutPackList, NEW.IdPackage, NEW.IdArea, NEW.IdSubStatus, NEW.StatusDate, NEW.StatusNotes, NEW.Linked, NEW.Order, NEW.LastUpdate, NEW.Version, NEW.OutOfReachConfirmedBy, NEW.PublisherRate, NEW.TransporterRate, NEW.ETA, NEW.ReturnDate ); 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 */ ; ALTER DATABASE `Waspnet_Courier` CHARACTER SET utf8 COLLATE utf8_bin ; ALTER DATABASE `Waspnet_Courier` CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci ; /*!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 = utf8mb4 */ ; /*!50003 SET character_set_results = utf8mb4 */ ; /*!50003 SET collation_connection = utf8mb4_0900_ai_ci */ ; /*!50003 SET @saved_sql_mode = @@sql_mode */ ; /*!50003 SET sql_mode = 'STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION' */ ; DELIMITER ;; /*!50003 CREATE*/ /*!50017 DEFINER=`waspnet`@`%`*/ /*!50003 TRIGGER `OutPackages_AFTER_UPDATE` AFTER UPDATE ON `outpackages` FOR EACH ROW BEGIN INSERT INTO `OutPackages_History` (`ID`, `IdOutPackList`, `IdPackage`, `IdArea`, `IdSubStatus`, `StatusDate`, `StatusNotes`, `Linked`, `Order`, `LastUpdate`, `Version`, `OutOfReachConfirmedBy`, `PublisherRate`, `TransporterRate`, `ETA`, `ReturnDate` ) VALUES ( NEW.ID, NEW.IdOutPackList, NEW.IdPackage, NEW.IdArea, NEW.IdSubStatus, NEW.StatusDate, NEW.StatusNotes, NEW.Linked, NEW.Order, NEW.LastUpdate, NEW.Version, NEW.OutOfReachConfirmedBy, NEW.PublisherRate, NEW.TransporterRate, NEW.ETA, NEW.ReturnDate ); 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 */ ; ALTER DATABASE `Waspnet_Courier` CHARACTER SET utf8 COLLATE utf8_bin ; -- -- Table structure for table `OutPackages_History` -- DROP TABLE IF EXISTS `OutPackages_History`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `OutPackages_History` ( `HistorizationNumber` bigint(20) NOT NULL AUTO_INCREMENT, `ID` varchar(38) NOT NULL, `IdOutPackList` varchar(38) DEFAULT NULL, `IdPackage` varchar(38) NOT NULL, `IdSubStatus` varchar(38) DEFAULT NULL, `StatusDate` datetime DEFAULT NULL, `StatusNotes` longtext, `IdArea` varchar(38) DEFAULT NULL, `Linked` tinyint(1) DEFAULT '0', `Order` int(11) NOT NULL, `LastUpdate` datetime NOT NULL, `Version` int(11) NOT NULL, `OutOfReachConfirmedBy` varchar(38) DEFAULT NULL, `TransporterRate` decimal(19,4) DEFAULT NULL, `PublisherRate` decimal(19,4) DEFAULT NULL, `IdSynchronizationSession` varchar(38) DEFAULT NULL, `SynchronizationDate` datetime DEFAULT NULL, `ETA` datetime DEFAULT NULL, `ReturnDate` datetime DEFAULT NULL, `ArchivedDate` datetime DEFAULT NULL, PRIMARY KEY (`HistorizationNumber`), KEY `FK_Package_OutPackages_History_idx` (`IdPackage`), KEY `FK_OutPackList_OutPackages_History_idx` (`IdOutPackList`), KEY `FK_Area_OutPackages_History_idx` (`IdArea`), KEY `IDX_ID_Session` (`ID`,`IdSynchronizationSession`), KEY `IDX_SyncSession` (`IdSynchronizationSession`,`SynchronizationDate`), KEY `IDX_ID_History` (`ID`,`HistorizationNumber`), KEY `IDX_MaxHistory` (`IdSynchronizationSession`,`HistorizationNumber`), KEY `IDX_HistoryGroup` (`HistorizationNumber`,`IdOutPackList`,`IdPackage`,`StatusDate`,`Linked`,`LastUpdate`), KEY `IDX_Linked` (`Linked`) ) ENGINE=InnoDB AUTO_INCREMENT=119762 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `OutPackLists` -- DROP TABLE IF EXISTS `OutPackLists`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `OutPackLists` ( `ID` varchar(38) NOT NULL, `Type` varchar(50) NOT NULL, `Number` int(11) NOT NULL, `Date` datetime NOT NULL, `IdTransporter` varchar(38) NOT NULL, `IdVehicle` varchar(38) NOT NULL, `IdDriver` varchar(38) DEFAULT NULL, `Status` varchar(50) NOT NULL, `IsFirstTrip` tinyint(1) NOT NULL, `TransporterRentalRate` decimal(19,4) DEFAULT '0.0000', `TransporterExtraRate` decimal(19,4) DEFAULT NULL, `Note` varchar(2000) DEFAULT NULL, `PublisherRate` decimal(19,4) NOT NULL, `TransporterRate` decimal(19,4) NOT NULL, `IdCreatorAccount` varchar(38) DEFAULT NULL, `CreationDate` datetime DEFAULT NULL, `IdUpdaterAccount` varchar(38) DEFAULT NULL, `LastUpdate` datetime NOT NULL, `ChangedBy` varchar(2000) DEFAULT NULL, `Version` int(11) NOT NULL, `Deleted` tinyint(1) NOT NULL DEFAULT '0', `StatusDate` datetime DEFAULT NULL, `StatusChangeNotes` varchar(500) DEFAULT NULL, `Latitude` decimal(10,0) DEFAULT NULL, `Longitude` decimal(10,0) DEFAULT NULL, `VolumeRounded` decimal(19,4) DEFAULT NULL, PRIMARY KEY (`ID`), KEY `FK_Vehicle_OutPackLists_idx` (`IdVehicle`), KEY `FK_Transporter_OutPackLists_idx` (`IdTransporter`), KEY `IDX_OutPackList_Date` (`Date`), KEY `IDX_OutPackList_Number` (`Number`), KEY `IDX_OutPackList_ID_IdTransporter_Deleted` (`ID`,`Type`,`IdTransporter`,`IdVehicle`,`IsFirstTrip`,`TransporterRentalRate`,`TransporterExtraRate`,`Deleted`), KEY `FK_Driver_OutPackList_idx` (`IdDriver`,`IdTransporter`), KEY `IDX_SortPrder` (`Date` DESC,`Number` DESC), KEY `IDX_Deleted` (`Deleted`), CONSTRAINT `FK_Driver_OutPackList` FOREIGN KEY (`IdDriver`) REFERENCES `drivers` (`ID`), CONSTRAINT `FK_OutPackList_Vehicle` FOREIGN KEY (`IdVehicle`) REFERENCES `vehicles` (`ID`), CONSTRAINT `FK_Transporter_OutPackLists` FOREIGN KEY (`IdTransporter`) REFERENCES `transporters` (`ID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; ALTER DATABASE `Waspnet_Courier` CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci ; /*!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 = utf8mb4 */ ; /*!50003 SET character_set_results = utf8mb4 */ ; /*!50003 SET collation_connection = utf8mb4_0900_ai_ci */ ; /*!50003 SET @saved_sql_mode = @@sql_mode */ ; /*!50003 SET sql_mode = 'STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION' */ ; DELIMITER ;; /*!50003 CREATE*/ /*!50017 DEFINER=`waspnet`@`%`*/ /*!50003 TRIGGER `OutPackLists_AFTER_INSERT` AFTER INSERT ON `outpacklists` FOR EACH ROW BEGIN INSERT INTO `OutPackLists_History` (`Id`, `Type`, `Number`, `Date`, `IdTransporter`, `IdVehicle`, `IdDriver`, `Status`, `IsFirstTrip`, `Note`, `PublisherRate`, `TransporterRate`, `TransporterRentalRate`, `TransporterExtraRate`, `IsPassiveConfirmation`, `IdCreatorAccount`, `CreationDate`, `IdUpdaterAccount`, `LastUpdate`, `ChangedBy`, `Version`, `Deleted`, `StatusDate`, `StatusChangeNotes`, `Latitude`, `Longitude`) VALUES ( NEW.ID, NEW.Type, NEW.Number, NEW.Date, NEW.IdTransporter, NEW.IdVehicle, NEW.IdDriver, NEW.Status, NEW.IsFirstTrip, NEW.Note, NEW.PublisherRate, NEW.TransporterRate, NEW.TransporterRentalRate, NEW.TransporterExtraRate, IFNULL(NEW.TransporterRate, 0) > IFNULL(NEW.PublisherRate, 0), NEW.IdCreatorAccount, NEW.CreationDate, NEW.IdUpdaterAccount, NEW.LastUpdate, NEW.ChangedBy, NEW.Version, NEW.Deleted, NEW.StatusDate, NEW.StatusChangeNotes, NEW.Latitude, NEW.Longitude ); 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 */ ; ALTER DATABASE `Waspnet_Courier` CHARACTER SET utf8 COLLATE utf8_bin ; ALTER DATABASE `Waspnet_Courier` CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci ; /*!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 = utf8mb4 */ ; /*!50003 SET character_set_results = utf8mb4 */ ; /*!50003 SET collation_connection = utf8mb4_0900_ai_ci */ ; /*!50003 SET @saved_sql_mode = @@sql_mode */ ; /*!50003 SET sql_mode = 'STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION' */ ; DELIMITER ;; /*!50003 CREATE*/ /*!50017 DEFINER=`waspnet`@`%`*/ /*!50003 TRIGGER `OutPackLists_AFTER_UPDATE` AFTER UPDATE ON `outpacklists` FOR EACH ROW BEGIN INSERT INTO `OutPackLists_History` (`Id`, `Type`, `Number`, `Date`, `IdTransporter`, `IdVehicle`, `IdDriver`, `Status`, `IsFirstTrip`, `Note`, `PublisherRate`, `TransporterRate`, `TransporterRentalRate`, `TransporterExtraRate`, `IsPassiveConfirmation`, `IdCreatorAccount`, `CreationDate`, `IdUpdaterAccount`, `LastUpdate`, `ChangedBy`, `Version`, `Deleted`, `StatusDate`, `StatusChangeNotes`, `Latitude`, `Longitude`) VALUES ( NEW.ID, NEW.Type, NEW.Number, NEW.Date, NEW.IdTransporter, NEW.IdVehicle, NEW.IdDriver, NEW.Status, NEW.IsFirstTrip, NEW.Note, NEW.PublisherRate, NEW.TransporterRate, NEW.TransporterRentalRate, NEW.TransporterExtraRate, IFNULL(NEW.TransporterRate, 0) > IFNULL(NEW.PublisherRate, 0), NEW.IdCreatorAccount, NEW.CreationDate, NEW.IdUpdaterAccount, NEW.LastUpdate, NEW.ChangedBy, NEW.Version, NEW.Deleted, NEW.StatusDate, NEW.StatusChangeNotes, NEW.Latitude, NEW.Longitude ); 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 */ ; ALTER DATABASE `Waspnet_Courier` CHARACTER SET utf8 COLLATE utf8_bin ; -- -- Table structure for table `OutPackLists_History` -- DROP TABLE IF EXISTS `OutPackLists_History`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `OutPackLists_History` ( `HistorizationNumber` bigint(20) NOT NULL AUTO_INCREMENT, `Id` varchar(38) NOT NULL, `Type` varchar(50) NOT NULL, `Number` int(11) NOT NULL, `Date` datetime NOT NULL, `IdTransporter` varchar(38) NOT NULL, `IdVehicle` varchar(38) NOT NULL, `IdDriver` varchar(38) DEFAULT NULL, `Status` varchar(50) NOT NULL, `IsFirstTrip` tinyint(1) NOT NULL, `Note` varchar(2000) DEFAULT NULL, `PublisherRate` decimal(19,4) DEFAULT NULL, `TransporterRate` decimal(19,4) DEFAULT NULL, `TransporterRentalRate` decimal(19,4) DEFAULT NULL, `TransporterExtraRate` decimal(19,4) DEFAULT NULL, `IsPassiveConfirmation` tinyint(1) DEFAULT NULL, `IdCreatorAccount` varchar(38) DEFAULT NULL, `CreationDate` datetime DEFAULT NULL, `IdUpdaterAccount` varchar(38) DEFAULT NULL, `LastUpdate` datetime NOT NULL, `ChangedBy` varchar(2000) DEFAULT NULL, `Version` int(11) NOT NULL, `Deleted` tinyint(1) NOT NULL DEFAULT '0', `StatusDate` datetime DEFAULT NULL, `StatusChangeNotes` varchar(500) DEFAULT NULL, `IdSynchronizationSession` varchar(38) DEFAULT NULL, `SynchronizationDate` datetime DEFAULT NULL, `Latitude` decimal(10,0) DEFAULT NULL, `Longitude` decimal(10,0) DEFAULT NULL, `IdInPackList` varchar(38) DEFAULT NULL, `VolumeRounded` decimal(19,4) DEFAULT NULL, PRIMARY KEY (`HistorizationNumber`), KEY `IDX_OutPackList_History_Transporters` (`IdTransporter`), KEY `IDX_OutPackList_History_Vehicle` (`IdVehicle`), KEY `IDX_OutPackList_History_Driver` (`IdDriver`), KEY `IDX_ID_Session` (`Id`,`IdSynchronizationSession`), KEY `IDX_SyncSession` (`IdSynchronizationSession`,`SynchronizationDate`), KEY `IDX_ID_History` (`Id`,`HistorizationNumber`), KEY `IDX_MaxHistory` (`IdSynchronizationSession`,`HistorizationNumber`), KEY `IDX_IsPassiveConfirmation` (`Id`,`IsPassiveConfirmation`) ) ENGINE=InnoDB AUTO_INCREMENT=17109 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `OutPackListsExtras` -- DROP TABLE IF EXISTS `OutPackListsExtras`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `OutPackListsExtras` ( `ID` varchar(38) NOT NULL, `IdOutPackList` varchar(38) NOT NULL, `IdExtraType` int(11) NOT NULL, `Rate` decimal(10,2) NOT NULL DEFAULT '0.00', `Notes` varchar(500) DEFAULT NULL, `CreationDate` datetime DEFAULT NULL, `LastUpdate` datetime NOT NULL, `Version` int(11) NOT NULL, `IdUpdaterAccount` varchar(38) DEFAULT NULL, `IdCreatorAccount` varchar(38) DEFAULT NULL, `ChangedBy` varchar(2000) DEFAULT NULL, `IdArea` varchar(38) DEFAULT NULL, PRIMARY KEY (`ID`), KEY `FK_OutPackLists_OutPackListsExtras_idx` (`IdOutPackList`), KEY `FK_ExtraTypes_OutPackListsExtras_idx` (`IdExtraType`), KEY `FK_Areas_OutPackListExtras_idx` (`IdArea`), CONSTRAINT `FK_Areas_OutPackListExtras` FOREIGN KEY (`IdArea`) REFERENCES `areas` (`ID`), CONSTRAINT `FK_ExtraTypes_OutPackListsExtras` FOREIGN KEY (`IdExtraType`) REFERENCES `extratypes` (`ID`), CONSTRAINT `FK_OutPackLists_OutPackListsExtras` FOREIGN KEY (`IdOutPackList`) REFERENCES `outpacklists` (`ID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `OutPackListsStats` -- DROP TABLE IF EXISTS `OutPackListsStats`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `OutPackListsStats` ( `ID` varchar(38) NOT NULL, `IdOutPackList` varchar(38) NOT NULL, `IdPackage` varchar(38) NOT NULL, `StopID` varchar(38) DEFAULT NULL, `Boxes` int(11) DEFAULT '1', `Weight` int(11) DEFAULT NULL, `Pallets` int(11) DEFAULT NULL, `Volume` decimal(19,4) DEFAULT NULL, `CODs` decimal(19,4) DEFAULT NULL, `TransporterRate` decimal(19,4) DEFAULT NULL, `PublisherRate` decimal(19,4) DEFAULT NULL, `LastUpdate` datetime NOT NULL, `Version` int(11) NOT NULL, `StopRate` decimal(19,4) DEFAULT NULL, `IdAdminArea` int(11) DEFAULT NULL, `PenaltyRate` decimal(19,4) DEFAULT NULL, PRIMARY KEY (`ID`), KEY `FK_Stats_OutPackList_idx` (`IdOutPackList`), KEY `FK_Stats_Package_idx` (`IdPackage`), CONSTRAINT `FK_Stats_OutPackList` FOREIGN KEY (`IdOutPackList`) REFERENCES `outpacklists` (`ID`) ON DELETE CASCADE, CONSTRAINT `FK_Stats_Package` FOREIGN KEY (`IdPackage`) REFERENCES `packages` (`ID`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `PackagePDCs` -- DROP TABLE IF EXISTS `PackagePDCs`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `PackagePDCs` ( `ID` varchar(38) NOT NULL, `IdPackage` varchar(38) NOT NULL, `FileName` varchar(200) NOT NULL, `PDF` longblob, `PDF_ArchivePath` varchar(255) DEFAULT NULL, `LastUpdate` datetime NOT NULL, `Version` int(11) NOT NULL, PRIMARY KEY (`ID`), KEY `FK_Package_PackagePDCs_idx` (`IdPackage`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `Packages` -- DROP TABLE IF EXISTS `Packages`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `Packages` ( `ID` varchar(38) NOT NULL, `IdPublisher` varchar(38) NOT NULL, `IdSender` varchar(38) DEFAULT NULL, `IdPayer` varchar(38) DEFAULT NULL, `ReceiverAsPayer` tinyint(1) NOT NULL DEFAULT '0', `Number` int(11) DEFAULT NULL, `Year` int(11) DEFAULT NULL, `IdInPackList` varchar(38) DEFAULT NULL, `LoadingDate` datetime DEFAULT NULL, `IdTransporter` varchar(38) DEFAULT NULL, `IdTransporterWEB` varchar(38) DEFAULT NULL, `Status` varchar(50) NOT NULL, `StatusWEB` varchar(50) DEFAULT NULL, `IdSubStatus` varchar(38) DEFAULT NULL, `StatusDate` datetime DEFAULT NULL, `StatusDateWEB` datetime DEFAULT NULL, `Note` longtext, `NoteWEB` longtext, `Weight` int(11) DEFAULT NULL, `DeclaredWeight` int(11) DEFAULT NULL, `Boxes` int(11) DEFAULT '1', `Pallets` int(11) DEFAULT NULL, `Volume` decimal(19,4) DEFAULT NULL, `EPal` int(11) NOT NULL DEFAULT '0', `CashOnDeliveryType` varchar(50) DEFAULT NULL, `CashOnDelivery` decimal(19,4) DEFAULT NULL, `PackAmount` decimal(19,4) DEFAULT NULL, `ContentType` varchar(2000) DEFAULT NULL, `ReceiverName` varchar(250) DEFAULT NULL, `ReceiverAddress` varchar(250) DEFAULT NULL, `ReceiverZipCode` varchar(6) DEFAULT NULL, `ReceiverCity` varchar(50) DEFAULT NULL, `ReceiverProvince` varchar(250) DEFAULT NULL, `ReceiverContacts` varchar(250) DEFAULT NULL, `IdDeliveryType` int(11) DEFAULT NULL, `IdPackageType` int(11) DEFAULT NULL, `IdArea` varchar(38) DEFAULT NULL, `PublisherReference` varchar(255) DEFAULT NULL, `SenderReference` varchar(255) DEFAULT NULL, `PublisherNote` longtext, `IdParent` varchar(38) DEFAULT NULL, `IdPublisherAgent` varchar(38) DEFAULT NULL, `IdOriginalPack` varchar(38) DEFAULT NULL, `IdInStockPack` varchar(38) DEFAULT NULL, `InsuranceType` varchar(50) DEFAULT NULL, `InsuranceValue` decimal(19,4) DEFAULT NULL, `ExtraRate` decimal(19,4) DEFAULT NULL, `RentalRate` decimal(19,4) DEFAULT NULL, `TransporterExtraRate` decimal(19,4) DEFAULT NULL, `TransporterRentalRate` decimal(19,4) DEFAULT NULL, `MandatoryDate` datetime DEFAULT NULL, `MandatoryDateType` varchar(50) DEFAULT NULL, `ReceiverTrackingMails` varchar(5000) DEFAULT NULL, `TrackingToSend` tinyint(1) DEFAULT '0', `PA_Amount` decimal(19,4) DEFAULT NULL, `PRE_Amount` decimal(19,4) DEFAULT NULL, `RegistrationDate` datetime DEFAULT NULL, `ChangedBy` varchar(2000) DEFAULT NULL, `IdCreatorAccount` varchar(38) DEFAULT NULL, `IdUpdaterAccount` varchar(38) DEFAULT NULL, `CreationDate` datetime DEFAULT NULL, `LastUpdate` datetime NOT NULL, `Version` int(11) NOT NULL, `Latitude` decimal(10,5) DEFAULT NULL, `Longitude` decimal(10,5) DEFAULT NULL, `ETA` datetime DEFAULT NULL, `SignerFullName` varchar(100) DEFAULT NULL, `ExportEventClosingStateReached` bit(1) DEFAULT NULL, `InStockDays` int(11) DEFAULT NULL, `RequireCheps` tinyint(1) NOT NULL, `Cheps` int(11) DEFAULT NULL, `InternalNotes` longtext, `ReceiverCode` varchar(255) DEFAULT NULL, PRIMARY KEY (`ID`), KEY `IDX_Publisher_Year_Number` (`IdPublisher`,`Year`,`Number`), KEY `FK_Publisher_Packages_idx` (`IdPublisher`), KEY `FK_Area_Packages_idx` (`IdArea`), KEY `FK_DeliveryType_Packages` (`IdDeliveryType`), KEY `FK_InStockPack_Packages` (`IdInStockPack`), KEY `FK_OriginalPack_Packages` (`IdOriginalPack`), KEY `FK_PackageType_Packages` (`IdPackageType`), KEY `FK_Parent_Packages` (`IdParent`), KEY `FK_Transporter_Packages` (`IdTransporter`), KEY `FK_TransporterWEB_Packages` (`IdTransporterWEB`), KEY `FK_InPackList_Packages_idx` (`IdInPackList`), KEY `IDX_IdPublisherAgent` (`IdPublisherAgent`), KEY `IDX_LoadingDate` (`LoadingDate`), KEY `IDX_Number` (`Number`), KEY `IDX_Status` (`Status`), KEY `IDX_StatusWEB` (`StatusWEB`), KEY `IDX_Year` (`Year`), KEY `IDX_Address` (`ReceiverAddress`,`ReceiverCity`,`ReceiverProvince`), KEY `FK_Payer_Packages` (`IdPayer`), KEY `FK_PublisherSender_Packages_idx` (`IdSender`), KEY `IDX_SenderReference` (`SenderReference`), KEY `IDX_PublisherReference` (`PublisherReference`), KEY `FK_PackegeSubStatus_idx` (`IdSubStatus`) /*!80000 INVISIBLE */, KEY `IDX_PackagePublisher` (`ID`,`IdPublisher`), KEY `IDX_PackageForPubisher` (`ID`,`IdPublisher`), CONSTRAINT `FK_Area_Packages` FOREIGN KEY (`IdArea`) REFERENCES `areas` (`ID`), CONSTRAINT `FK_DeliveryType_Packages` FOREIGN KEY (`IdDeliveryType`) REFERENCES `deliverytypes` (`ID`), CONSTRAINT `FK_InPackList_Packages` FOREIGN KEY (`IdInPackList`) REFERENCES `inpacklists` (`ID`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `FK_InStockPack_Packages` FOREIGN KEY (`IdInStockPack`) REFERENCES `packages` (`ID`) ON DELETE CASCADE, CONSTRAINT `FK_OriginalPack_Packages` FOREIGN KEY (`IdOriginalPack`) REFERENCES `packages` (`ID`) ON DELETE CASCADE, CONSTRAINT `FK_PackageType_Packages` FOREIGN KEY (`IdPackageType`) REFERENCES `packagetypes` (`ID`), CONSTRAINT `FK_PackegeSubStatus` FOREIGN KEY (`IdSubStatus`) REFERENCES `packagesubstatus` (`ID`), CONSTRAINT `FK_Parent_Packages` FOREIGN KEY (`IdParent`) REFERENCES `packages` (`ID`), CONSTRAINT `FK_Payer_Packages` FOREIGN KEY (`IdPayer`) REFERENCES `publishers` (`ID`), CONSTRAINT `FK_PublisherSender_Packages` FOREIGN KEY (`IdSender`) REFERENCES `publisherssenders` (`ID`), CONSTRAINT `FK_Publisher_Packages` FOREIGN KEY (`IdPublisher`) REFERENCES `publishers` (`ID`), CONSTRAINT `FK_TransporterWEB_Packages` FOREIGN KEY (`IdTransporterWEB`) REFERENCES `transporters` (`ID`), CONSTRAINT `FK_Transporter_Packages` FOREIGN KEY (`IdTransporter`) REFERENCES `transporters` (`ID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; ALTER DATABASE `Waspnet_Courier` CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci ; /*!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 = utf8mb4 */ ; /*!50003 SET character_set_results = utf8mb4 */ ; /*!50003 SET collation_connection = utf8mb4_general_ci */ ; /*!50003 SET @saved_sql_mode = @@sql_mode */ ; /*!50003 SET sql_mode = '' */ ; DELIMITER ;; /*!50003 CREATE*/ /*!50017 DEFINER=`waspnet`@`%`*/ /*!50003 TRIGGER `Packages_AFTER_INSERT` AFTER INSERT ON `packages` FOR EACH ROW BEGIN INSERT INTO `Packages_History` ( `ID`, `IdPublisher`, `IdSender`, `IdPayer`, `ReceiverAsPayer`, `Number`, `Year`, `IdInPackList`, `LoadingDate`, `IdTransporter`, `IdTransporterWEB`, `Status`, `IdSubStatus`, `StatusDate`, `Note`, `Weight`, `DeclaredWeight`, `Boxes`, `Pallets`, `Volume`, `EPal`, `CashOnDeliveryType`, `CashOnDelivery`, `PackAmount`, `ContentType`, `ReceiverName`, `ReceiverAddress`, `ReceiverZipCode`, `ReceiverCity`, `ReceiverProvince`, `ReceiverContacts`, `IdDeliveryType`, `IdPackageType`, `IdArea`, `PublisherReference`, `SenderReference`, `PublisherNote`, `IdParent`, `IdPublisherAgent`, `IdOriginalPack`, `IdInStockPack`, `InsuranceType`, `InsuranceValue`, `ExtraRate`, `RentalRate`, `TransporterExtraRate`, `TransporterRentalRate`, `MandatoryDate`, `MandatoryDateType`, `ReceiverTrackingMails`, `TrackingToSend`, `PA_Amount`, `PRE_Amount`, `ChangedBy`, `RegistrationDate`, `IdCreatorAccount`, `CreationDate`, `IdUpdaterAccount`, `LastUpdate`, `Version`, `Deleted`, `Latitude`, `Longitude`, `ETA`, SignerFullName, ExportEventClosingStateReached ) VALUES ( NEW.ID, NEW.IdPublisher, NEW.IdSender, NEW.IdPayer, NEW.ReceiverAsPayer, NEW.Number, NEW.Year, NEW.IdInPackList, NEW.LoadingDate, NEW.IdTransporter, NEW.IdTransporterWEB, NEW.Status, NEW.IdSubStatus, NEW.StatusDate, NEW.Note, NEW.Weight, NEW.DeclaredWeight, NEW.Boxes, NEW.Pallets, NEW.Volume, NEW.EPal, NEW.CashOnDeliveryType, NEW.CashOnDelivery, NEW.PackAmount, NEW.ContentType, NEW.ReceiverName, NEW.ReceiverAddress, NEW.ReceiverZipCode, NEW.ReceiverCity, NEW.ReceiverProvince, NEW.ReceiverContacts, NEW.IdDeliveryType, NEW.IdPackageType, NEW.IdArea, NEW.PublisherReference, NEW.SenderReference, NEW.PublisherNote, NEW.IdParent, NEW.IdPublisherAgent, NEW.IdOriginalPack, NEW.IdInStockPack, NEW.InsuranceType, NEW.InsuranceValue, NEW.ExtraRate, NEW.RentalRate, NEW.TransporterExtraRate, NEW.TransporterRentalRate, NEW.MandatoryDate, NEW.MandatoryDateType, NEW.ReceiverTrackingMails, NEW.TrackingToSend, NEW.PA_Amount, NEW.PRE_Amount, NEW.ChangedBy, NEW.RegistrationDate, NEW.IdCreatorAccount, NEW.CreationDate, NEW.IdUpdaterAccount, NEW.LastUpdate, NEW.Version, 0, NEW.Latitude, NEW.Longitude, NEW.ETA, new.SignerFullName, new.ExportEventClosingStateReached ); 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 */ ; ALTER DATABASE `Waspnet_Courier` CHARACTER SET utf8 COLLATE utf8_bin ; ALTER DATABASE `Waspnet_Courier` CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci ; /*!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 = utf8mb4 */ ; /*!50003 SET character_set_results = utf8mb4 */ ; /*!50003 SET collation_connection = utf8mb4_general_ci */ ; /*!50003 SET @saved_sql_mode = @@sql_mode */ ; /*!50003 SET sql_mode = '' */ ; DELIMITER ;; /*!50003 CREATE*/ /*!50017 DEFINER=`waspnet`@`%`*/ /*!50003 TRIGGER `Packages_AFTER_UPDATE` AFTER UPDATE ON `packages` FOR EACH ROW BEGIN INSERT INTO `Packages_History` ( `ID`, `IdPublisher`, `IdSender`, `IdPayer`, `ReceiverAsPayer`, `Number`, `Year`, `IdInPackList`, `LoadingDate`, `IdTransporter`, `IdTransporterWEB`, `Status`, `IdSubStatus`, `StatusDate`, `Note`, `Weight`, `DeclaredWeight`, `Boxes`, `Pallets`, `Volume`, `EPal`, `CashOnDeliveryType`, `CashOnDelivery`, `PackAmount`, `ContentType`, `ReceiverName`, `ReceiverAddress`, `ReceiverZipCode`, `ReceiverCity`, `ReceiverProvince`, `ReceiverContacts`, `IdDeliveryType`, `IdPackageType`, `IdArea`, `PublisherReference`, `SenderReference`, `PublisherNote`, `IdParent`, `IdPublisherAgent`, `IdOriginalPack`, `IdInStockPack`, `InsuranceType`, `InsuranceValue`, `ExtraRate`, `RentalRate`, `TransporterExtraRate`, `TransporterRentalRate`, `MandatoryDate`, `MandatoryDateType`, `ReceiverTrackingMails`, `TrackingToSend`, `PA_Amount`, `PRE_Amount`, `ChangedBy`, `RegistrationDate`, `IdCreatorAccount`, `CreationDate`, `IdUpdaterAccount`, `LastUpdate`, `Version`, `Deleted`, `Latitude`, `Longitude`, `ETA`, SignerFullName, ExportEventClosingStateReached ) VALUES ( NEW.ID, NEW.IdPublisher, NEW.IdSender, NEW.IdPayer, NEW.ReceiverAsPayer, NEW.Number, NEW.Year, NEW.IdInPackList, NEW.LoadingDate, NEW.IdTransporter, NEW.IdTransporterWEB, NEW.Status, NEW.IdSubStatus, NEW.StatusDate, NEW.Note, NEW.Weight, NEW.DeclaredWeight, NEW.Boxes, NEW.Pallets, NEW.Volume, NEW.EPal, NEW.CashOnDeliveryType, NEW.CashOnDelivery, NEW.PackAmount, NEW.ContentType, NEW.ReceiverName, NEW.ReceiverAddress, NEW.ReceiverZipCode, NEW.ReceiverCity, NEW.ReceiverProvince, NEW.ReceiverContacts, NEW.IdDeliveryType, NEW.IdPackageType, NEW.IdArea, NEW.PublisherReference, NEW.SenderReference, NEW.PublisherNote, NEW.IdParent, NEW.IdPublisherAgent, NEW.IdOriginalPack, NEW.IdInStockPack, NEW.InsuranceType, NEW.InsuranceValue, NEW.ExtraRate, NEW.RentalRate, NEW.TransporterExtraRate, NEW.TransporterRentalRate, NEW.MandatoryDate, NEW.MandatoryDateType, NEW.ReceiverTrackingMails, NEW.TrackingToSend, NEW.PA_Amount, NEW.PRE_Amount, NEW.ChangedBy, NEW.RegistrationDate, NEW.IdCreatorAccount, NEW.CreationDate, NEW.IdUpdaterAccount, NEW.LastUpdate, NEW.Version, 0, NEW.Latitude, NEW.Longitude, NEW.ETA, new.SignerFullName, new.ExportEventClosingStateReached ); 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 */ ; ALTER DATABASE `Waspnet_Courier` CHARACTER SET utf8 COLLATE utf8_bin ; ALTER DATABASE `Waspnet_Courier` CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci ; /*!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 = utf8mb4 */ ; /*!50003 SET character_set_results = utf8mb4 */ ; /*!50003 SET collation_connection = utf8mb4_general_ci */ ; /*!50003 SET @saved_sql_mode = @@sql_mode */ ; /*!50003 SET sql_mode = '' */ ; DELIMITER ;; /*!50003 CREATE*/ /*!50017 DEFINER=`waspnet`@`%`*/ /*!50003 TRIGGER `Packages_AFTER_DELETE` AFTER DELETE ON `packages` FOR EACH ROW BEGIN INSERT INTO `Packages_History` ( `ID`, `IdPublisher`, `IdSender`, `IdPayer`, `ReceiverAsPayer`, `Number`, `Year`, `IdInPackList`, `LoadingDate`, `IdTransporter`, `IdTransporterWEB`, `Status`, `IdSubStatus`, `StatusDate`, `Note`, `Weight`, `DeclaredWeight`, `Boxes`, `Pallets`, `Volume`, `EPal`, `CashOnDeliveryType`, `CashOnDelivery`, `PackAmount`, `ContentType`, `ReceiverName`, `ReceiverAddress`, `ReceiverZipCode`, `ReceiverCity`, `ReceiverProvince`, `ReceiverContacts`, `IdDeliveryType`, `IdPackageType`, `IdArea`, `PublisherReference`, `SenderReference`, `PublisherNote`, `IdParent`, `IdPublisherAgent`, `IdOriginalPack`, `IdInStockPack`, `InsuranceType`, `InsuranceValue`, `ExtraRate`, `RentalRate`, `TransporterExtraRate`, `TransporterRentalRate`, `MandatoryDate`, `MandatoryDateType`, `ReceiverTrackingMails`, `TrackingToSend`, `PA_Amount`, `PRE_Amount`, `ChangedBy`, `RegistrationDate`, `IdCreatorAccount`, `CreationDate`, `IdUpdaterAccount`, `LastUpdate`, `Version`, `Deleted`, `Latitude`, `Longitude`, `ETA`, SignerFullName, ExportEventClosingStateReached ) VALUES ( OLD.ID, OLD.IdPublisher, OLD.IdSender, OLD.IdPayer, OLD.ReceiverAsPayer, OLD.Number, OLD.Year, OLD.IdInPackList, OLD.LoadingDate, OLD.IdTransporter, OLD.IdTransporterWEB, OLD.Status, OLD.IdSubStatus, OLD.StatusDate, OLD.Note, OLD.Weight, OLD.DeclaredWeight, OLD.Boxes, OLD.Pallets, OLD.Volume, OLD.EPal, OLD.CashOnDeliveryType, OLD.CashOnDelivery, OLD.PackAmount, OLD.ContentType, OLD.ReceiverName, OLD.ReceiverAddress, OLD.ReceiverZipCode, OLD.ReceiverCity, OLD.ReceiverProvince, OLD.ReceiverContacts, OLD.IdDeliveryType, OLD.IdPackageType, OLD.IdArea, OLD.PublisherReference, OLD.SenderReference, OLD.PublisherNote, OLD.IdParent, OLD.IdPublisherAgent, OLD.IdOriginalPack, OLD.IdInStockPack, OLD.InsuranceType, OLD.InsuranceValue, OLD.ExtraRate, OLD.RentalRate, OLD.TransporterExtraRate, OLD.TransporterRentalRate, OLD.MandatoryDate, OLD.MandatoryDateType, OLD.ReceiverTrackingMails, OLD.TrackingToSend, OLD.PA_Amount, OLD.PRE_Amount, OLD.ChangedBy, OLD.RegistrationDate, OLD.IdCreatorAccount, OLD.CreationDate, OLD.IdUpdaterAccount, OLD.LastUpdate, OLD.Version, 1, OLD.Latitude, OLD.Longitude, OLD.ETA, old.SignerFullName, old.ExportEventClosingStateReached ); 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 */ ; ALTER DATABASE `Waspnet_Courier` CHARACTER SET utf8 COLLATE utf8_bin ; -- -- Table structure for table `Packages_History` -- DROP TABLE IF EXISTS `Packages_History`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `Packages_History` ( `HistorizationNumber` bigint(20) NOT NULL AUTO_INCREMENT, `ID` varchar(38) NOT NULL, `IdPublisher` varchar(38) NOT NULL, `IdSender` varchar(38) DEFAULT NULL, `IdPayer` varchar(38) DEFAULT NULL, `ReceiverAsPayer` tinyint(1) DEFAULT '0', `Number` int(11) DEFAULT NULL, `Year` int(11) NOT NULL, `IdInPackList` varchar(38) DEFAULT NULL, `LoadingDate` datetime DEFAULT NULL, `IdTransporter` varchar(38) DEFAULT NULL, `IdTransporterWEB` varchar(38) DEFAULT NULL, `Status` varchar(50) DEFAULT NULL, `IdSubStatus` varchar(38) DEFAULT NULL, `StatusDate` datetime DEFAULT NULL, `Note` longtext, `Weight` int(11) DEFAULT NULL, `DeclaredWeight` int(11) DEFAULT NULL, `Boxes` int(11) DEFAULT '1', `Pallets` int(11) DEFAULT NULL, `Volume` decimal(19,4) DEFAULT NULL, `EPal` int(11) DEFAULT '0', `CashOnDeliveryType` varchar(50) DEFAULT NULL, `CashOnDelivery` decimal(19,4) DEFAULT NULL, `PackAmount` decimal(19,4) DEFAULT NULL, `ContentType` varchar(2000) DEFAULT NULL, `ReceiverName` varchar(250) DEFAULT NULL, `ReceiverAddress` varchar(250) DEFAULT NULL, `ReceiverZipCode` varchar(6) DEFAULT NULL, `ReceiverCity` varchar(50) DEFAULT NULL, `ReceiverProvince` varchar(250) DEFAULT NULL, `ReceiverContacts` varchar(250) DEFAULT NULL, `IdDeliveryType` int(11) DEFAULT NULL, `IdPackageType` int(11) DEFAULT NULL, `IdArea` varchar(38) DEFAULT NULL, `PublisherReference` varchar(255) DEFAULT NULL, `SenderReference` varchar(255) DEFAULT NULL, `PublisherNote` longtext, `IdParent` varchar(38) DEFAULT NULL, `IdPublisherAgent` varchar(38) DEFAULT NULL, `IdOriginalPack` varchar(38) DEFAULT NULL, `IdInStockPack` varchar(38) DEFAULT NULL, `InsuranceType` varchar(50) DEFAULT NULL, `InsuranceValue` decimal(19,4) DEFAULT NULL, `ExtraRate` decimal(19,4) DEFAULT NULL, `RentalRate` decimal(19,4) DEFAULT NULL, `TransporterExtraRate` decimal(19,4) DEFAULT NULL, `TransporterRentalRate` decimal(19,4) DEFAULT NULL, `MandatoryDate` datetime DEFAULT NULL, `MandatoryDateType` varchar(50) DEFAULT NULL, `ReceiverTrackingMails` varchar(5000) DEFAULT NULL, `TrackingToSend` tinyint(1) DEFAULT '0', `PA_Amount` decimal(19,4) DEFAULT NULL, `PRE_Amount` decimal(19,4) DEFAULT NULL, `ChangedBy` varchar(2000) DEFAULT NULL, `RegistrationDate` datetime DEFAULT NULL, `IdCreatorAccount` varchar(38) DEFAULT NULL, `CreationDate` datetime DEFAULT NULL, `IdUpdaterAccount` varchar(38) DEFAULT NULL, `LastUpdate` datetime DEFAULT NULL, `Version` int(11) NOT NULL, `Deleted` tinyint(1) NOT NULL DEFAULT '0', `IdSynchronizationSession` varchar(38) DEFAULT NULL, `SynchronizationDate` datetime DEFAULT NULL, `StatusWEB` varchar(50) DEFAULT NULL, `StatusDateWEB` datetime DEFAULT NULL, `NoteWEB` longtext, `Latitude` decimal(10,5) DEFAULT NULL, `Longitude` decimal(10,5) DEFAULT NULL, `ETA` datetime DEFAULT NULL, `SignerFullName` varchar(50) DEFAULT NULL, `IdExportEventSession` varchar(38) DEFAULT NULL, `ExportEventStatus` tinyint(3) unsigned DEFAULT NULL, `ExportEventSentDate` datetime DEFAULT NULL, `ExportEventClosingStateReached` bit(1) DEFAULT NULL, `RequireCheps` tinyint(1) NOT NULL, `Cheps` int(11) DEFAULT NULL, `InStockDays` int(11) DEFAULT NULL, `InternalNotes` longtext, `ReceiverCode` varchar(255) DEFAULT NULL, PRIMARY KEY (`HistorizationNumber`,`Version`,`Deleted`), KEY `IDX_ID_Session` (`ID`,`IdSynchronizationSession`), KEY `IDX_SyncSession` (`IdSynchronizationSession`,`SynchronizationDate`), KEY `IDX_ID_History` (`ID`,`HistorizationNumber`), KEY `IDX_MaxHistory` (`IdSynchronizationSession`,`HistorizationNumber`), KEY `IDX_IdExportEventSession` (`IdExportEventSession`) /*!80000 INVISIBLE */, KEY `IDX_StartSessionExport` (`IdSynchronizationSession`,`SynchronizationDate`), KEY `IDX_History_Package_ID` (`ID`), KEY `IDX_History_Package_IdOriginal` (`IdOriginalPack`), KEY `IDX_UpdateEventToSend_Packages_History` (`IdExportEventSession`,`ExportEventSentDate`,`IdPublisher`) ) ENGINE=InnoDB AUTO_INCREMENT=126372 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `PackagesBoxes` -- DROP TABLE IF EXISTS `PackagesBoxes`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `PackagesBoxes` ( `ID` varchar(38) NOT NULL, `IdPackage` varchar(38) NOT NULL, `IdPackageType` int(11) DEFAULT NULL, `Number` int(11) NOT NULL, `Code` varchar(250) DEFAULT NULL, `InternalBarCode` varchar(250) DEFAULT NULL, `Status` varchar(50) NOT NULL, `Note` longtext, `Length` int(11) DEFAULT '0', `Width` int(11) DEFAULT '0', `Height` int(11) DEFAULT '0', `Weight` int(11) DEFAULT '0', `ChangedBy` varchar(2000) DEFAULT NULL, `IdCreatorAccount` varchar(38) DEFAULT NULL, `IdUpdaterAccount` varchar(38) DEFAULT NULL, `CreationDate` datetime DEFAULT NULL, `LastUpdate` datetime NOT NULL, `Version` int(11) NOT NULL, `PackageVersion` int(11) DEFAULT NULL, PRIMARY KEY (`ID`), UNIQUE KEY `UK_Package_BoxNumber` (`IdPackage`,`Number`), KEY `FK_Package_PackagesBoxes_idx` (`IdPackage`), KEY `FK_PackageType_PackagesBoxes_idx` (`IdPackageType`), CONSTRAINT `FK_Package_PackagesBoxes` FOREIGN KEY (`IdPackage`) REFERENCES `packages` (`ID`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT; /*!40101 SET character_set_client = @saved_cs_client */; ALTER DATABASE `Waspnet_Courier` CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci ; /*!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=`waspnet`@`%`*/ /*!50003 TRIGGER `PackagesBoxes_AFTER_INSERT` AFTER INSERT ON `packagesboxes` FOR EACH ROW BEGIN INSERT INTO `PackagesBoxes_History` ( `ID`, `IdPackage`, `IdPackageType`, `Number`, `Code`, `InternalBarCode`, `Status`, `Note`, `Length`, `Width`, `Height`, `Weight`, `ChangedBy`, `IdCreatorAccount`, `IdUpdaterAccount`, `CreationDate`, `LastUpdate`, `Version`, `PackageVersion`, `Deleted`) VALUES ( NEW.ID, NEW.IdPackage, NEW.IdPackageType, NEW.Number, NEW.Code, New.InternalBarCode, NEW.Status, NEW.Note, NEW.Length, NEW.Width, NEW.Height, NEW.Weight, NEW.ChangedBy, NEW.IdCreatorAccount, NEW.IdUpdaterAccount, NEW.CreationDate, NEW.LastUpdate, NEW.Version, NEW.PackageVersion, 0); 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 */ ; ALTER DATABASE `Waspnet_Courier` CHARACTER SET utf8 COLLATE utf8_bin ; ALTER DATABASE `Waspnet_Courier` CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci ; /*!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=`waspnet`@`%`*/ /*!50003 TRIGGER `PackagesBoxes_AFTER_UPDATE` AFTER UPDATE ON `packagesboxes` FOR EACH ROW BEGIN INSERT INTO `PackagesBoxes_History` ( `ID`, `IdPackage`, `IdPackageType`, `Number`, `Code`, `InternalBarCode`, `Status`, `Note`, `Length`, `Width`, `Height`, `Weight`, `ChangedBy`, `IdCreatorAccount`, `IdUpdaterAccount`, `CreationDate`, `LastUpdate`, `Version`, `PackageVersion`, `Deleted`) VALUES ( NEW.ID, NEW.IdPackage, NEW.IdPackageType, NEW.Number, NEW.Code, NEW.InternalBarCode, NEW.Status, NEW.Note, NEW.Length, NEW.Width, NEW.Height, NEW.Weight, NEW.ChangedBy, NEW.IdCreatorAccount, NEW.IdUpdaterAccount, NEW.CreationDate, NEW.LastUpdate, NEW.Version, NEW.PackageVersion, 0); 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 */ ; ALTER DATABASE `Waspnet_Courier` CHARACTER SET utf8 COLLATE utf8_bin ; ALTER DATABASE `Waspnet_Courier` CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci ; /*!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=`waspnet`@`%`*/ /*!50003 TRIGGER `PackagesBoxes_AFTER_DELETE` AFTER DELETE ON `packagesboxes` FOR EACH ROW BEGIN INSERT INTO `PackagesBoxes_History` ( `ID`, `IdPackage`, `IdPackageType`, `Number`, `Code`, `InternalBarCode`, `Status`, `Note`, `Length`, `Width`, `Height`, `Weight`, `ChangedBy`, `IdCreatorAccount`, `IdUpdaterAccount`, `CreationDate`, `LastUpdate`, `Version`, `PackageVersion`, `Deleted`) VALUES ( OLD.ID, OLD.IdPackage, OLD.IdPackageType, OLD.Number, OLD.Code, OLD.InternalBarCode, OLD.Status, OLD.Note, OLD.Length, OLD.Width, OLD.Height, OLD.Weight, OLD.ChangedBy, OLD.IdCreatorAccount, OLD.IdUpdaterAccount, OLD.CreationDate, OLD.LastUpdate, OLD.Version, OLD.PackageVersion, 1); 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 */ ; ALTER DATABASE `Waspnet_Courier` CHARACTER SET utf8 COLLATE utf8_bin ; -- -- Table structure for table `PackagesBoxes_History` -- DROP TABLE IF EXISTS `PackagesBoxes_History`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `PackagesBoxes_History` ( `HistorizationNumber` bigint(20) NOT NULL AUTO_INCREMENT, `ID` varchar(38) NOT NULL, `IdPackage` varchar(38) NOT NULL, `IdPackageType` int(11) DEFAULT NULL, `Number` int(11) NOT NULL, `Code` varchar(250) DEFAULT NULL, `InternalBarCode` varchar(250) DEFAULT NULL, `Status` varchar(50) NOT NULL, `Note` longtext, `Length` int(11) DEFAULT '0', `Width` int(11) DEFAULT '0', `Height` int(11) DEFAULT '0', `Weight` int(11) DEFAULT '0', `ChangedBy` varchar(2000) DEFAULT NULL, `IdCreatorAccount` varchar(38) DEFAULT NULL, `IdUpdaterAccount` varchar(38) DEFAULT NULL, `CreationDate` datetime DEFAULT NULL, `LastUpdate` datetime NOT NULL, `Version` int(11) NOT NULL, `PackageVersion` int(11) NOT NULL DEFAULT '0', `Deleted` tinyint(1) NOT NULL DEFAULT '0', `IdSynchronizationSession` varchar(38) DEFAULT NULL, `SynchronizationDate` datetime DEFAULT NULL, `IdExportEventSession` varchar(38) DEFAULT NULL, `ExportEventStatus` tinyint(3) unsigned DEFAULT NULL, `ExportEventSentDate` datetime DEFAULT NULL, `ExportEventClosingStateReached` bit(1) DEFAULT NULL, PRIMARY KEY (`HistorizationNumber`,`PackageVersion`,`Deleted`), KEY `Package_PackagesBoxes_History_idx` (`IdPackage`), KEY `PackageType_PackagesBoxes_History_idx` (`IdPackageType`), KEY `IDX_ID_Session` (`ID`,`IdSynchronizationSession`), KEY `IDX_SyncSession` (`IdSynchronizationSession`,`SynchronizationDate`), KEY `IDX_ID_History` (`ID`,`HistorizationNumber`), KEY `IDX_MaxHistory` (`IdSynchronizationSession`,`HistorizationNumber`), KEY `IDX_IdExportEventSession` (`IdExportEventSession`), KEY `IDX_Synchronization` (`ID`,`IdSynchronizationSession`,`SynchronizationDate`) ) ENGINE=InnoDB AUTO_INCREMENT=2684730 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `PackagesDeliveryDateChanges` -- DROP TABLE IF EXISTS `PackagesDeliveryDateChanges`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `PackagesDeliveryDateChanges` ( `ID` varchar(38) NOT NULL, `IdPackage` varchar(38) NOT NULL, `IdDeliveryDateCode` varchar(38) NOT NULL, `IdPublisherSenderDeliveryDateCode` varchar(38) DEFAULT NULL, `OldDate` datetime NOT NULL, `NewDate` datetime NOT NULL, `TransmissionDate` datetime DEFAULT NULL, `Notes` varchar(2000) DEFAULT NULL, `IdUpdaterAccount` varchar(38) DEFAULT NULL, `IdCreatorAccount` varchar(38) DEFAULT NULL, `LastUpdate` datetime NOT NULL, `CreationDate` datetime DEFAULT NULL, `ChangedBy` varchar(2000) DEFAULT NULL, `Version` int(11) NOT NULL, `IdExportEventSession` varchar(38) DEFAULT NULL, `ExportEventStatus` tinyint(3) unsigned DEFAULT NULL, `ExportEventSentDate` datetime DEFAULT NULL, `ExportEventClosingStateReached` bit(1) DEFAULT NULL, PRIMARY KEY (`ID`), KEY `FK_IdPackage_PackageDeliveryDateChange_idx` (`IdPackage`), KEY `FK_DeliveryDateCode_PackageDeliveryDateCodeChange_idx` (`IdDeliveryDateCode`), KEY `FK_PublisherSenderDeliveryDateCode_DeliveryDateChange_idx` (`IdPublisherSenderDeliveryDateCode`), KEY `IDX_IdExportEventSession` (`IdExportEventSession`), KEY `IDX_UpdateEventToSend_PackagesDeliveryDateChanges` (`IdExportEventSession`,`ExportEventSentDate`,`ID`), CONSTRAINT `FK_DeliveryDateCode_PackageDeliveryDateCodeChange` FOREIGN KEY (`IdDeliveryDateCode`) REFERENCES `deliverydatecodes` (`ID`), CONSTRAINT `FK_Package_PackageDeliveryDateChange` FOREIGN KEY (`IdPackage`) REFERENCES `packages` (`ID`), CONSTRAINT `FK_PublisherSenderDeliveryDateCode_DeliveryDateChange` FOREIGN KEY (`IdPublisherSenderDeliveryDateCode`) REFERENCES `publisherssendersdeliverydatecodes` (`ID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `PackagesExportData` -- DROP TABLE IF EXISTS `PackagesExportData`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `PackagesExportData` ( `ID` varchar(38) NOT NULL, `IdPackage` varchar(38) NOT NULL, `Data` mediumtext, `LastUpdate` datetime NOT NULL, `Version` int(11) NOT NULL, PRIMARY KEY (`ID`), KEY `FK_Package_PackagePDCs_idx` (`IdPackage`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `PackagesExtras` -- DROP TABLE IF EXISTS `PackagesExtras`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `PackagesExtras` ( `ID` varchar(38) NOT NULL, `IdPackage` varchar(38) NOT NULL, `IdExtraType` int(11) NOT NULL, `Date` datetime DEFAULT NULL, `ForPublisher` tinyint(1) NOT NULL DEFAULT '1', `ForTransporter` tinyint(1) NOT NULL DEFAULT '1', `Note` longtext, `ChangedBy` varchar(2000) DEFAULT NULL, `IdCreatorAccount` varchar(38) DEFAULT NULL, `IdUpdaterAccount` varchar(38) DEFAULT NULL, `CreationDate` datetime DEFAULT NULL, `LastUpdate` datetime NOT NULL, `Version` int(11) NOT NULL, `PackageVersion` int(11) DEFAULT NULL, `Rate` decimal(10,2) NOT NULL DEFAULT '0.00', PRIMARY KEY (`ID`), KEY `FK_Package_PackagesExtras_idx` (`IdPackage`), KEY `FK_ExtraType_PackagesExtras_idx` (`IdExtraType`), CONSTRAINT `FK_ExtraType_PackagesExtras` FOREIGN KEY (`IdExtraType`) REFERENCES `extratypes` (`ID`), CONSTRAINT `FK_Package_PackagesExtras` FOREIGN KEY (`IdPackage`) REFERENCES `packages` (`ID`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; /*!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 = utf8mb4 */ ; /*!50003 SET character_set_results = utf8mb4 */ ; /*!50003 SET collation_connection = utf8mb4_0900_ai_ci */ ; /*!50003 SET @saved_sql_mode = @@sql_mode */ ; /*!50003 SET sql_mode = 'STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION' */ ; DELIMITER ;; /*!50003 CREATE*/ /*!50017 DEFINER=`waspnet`@`%`*/ /*!50003 TRIGGER `PackagesExtras_AFTER_INSERT` AFTER INSERT ON `packagesextras` FOR EACH ROW BEGIN INSERT INTO `PackagesExtras_History` ( `ID`, `IdPackage`, `IdExtraType`, `Date`, `ForPublisher`, `ForTransporter`, `Note`, `ChangedBy`, `IdCreatorAccount`, `IdUpdaterAccount`, `CreationDate`, `LastUpdate`, `Version`, `PackageVersion`, `Deleted`, `Rate`) VALUES ( NEW.ID, NEW.IdPackage, NEW.IdExtraType, NEW.Date, NEW.ForPublisher, NEW.ForTransporter, NEW.Note, NEW.ChangedBy, NEW.IdCreatorAccount, NEW.IdUpdaterAccount, NEW.CreationDate, NEW.LastUpdate, NEW.Version, NEW.PackageVersion, 0, NEW.Rate); 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 = utf8mb4 */ ; /*!50003 SET character_set_results = utf8mb4 */ ; /*!50003 SET collation_connection = utf8mb4_0900_ai_ci */ ; /*!50003 SET @saved_sql_mode = @@sql_mode */ ; /*!50003 SET sql_mode = 'STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION' */ ; DELIMITER ;; /*!50003 CREATE*/ /*!50017 DEFINER=`waspnet`@`%`*/ /*!50003 TRIGGER `PackagesExtras_AFTER_UPDATE` AFTER UPDATE ON `packagesextras` FOR EACH ROW BEGIN INSERT INTO `PackagesExtras_History` ( `ID`, `IdPackage`, `IdExtraType`, `Date`, `ForPublisher`, `ForTransporter`, `Note`, `ChangedBy`, `IdCreatorAccount`, `IdUpdaterAccount`, `CreationDate`, `LastUpdate`, `Version`, `PackageVersion`, `Deleted`, `Rate`) VALUES ( NEW.ID, NEW.IdPackage, NEW.IdExtraType, NEW.Date, NEW.ForPublisher, NEW.ForTransporter, NEW.Note, NEW.ChangedBy, NEW.IdCreatorAccount, NEW.IdUpdaterAccount, NEW.CreationDate, NEW.LastUpdate, NEW.Version, NEW.PackageVersion, 0, NEW.Rate); 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 = utf8mb4 */ ; /*!50003 SET character_set_results = utf8mb4 */ ; /*!50003 SET collation_connection = utf8mb4_0900_ai_ci */ ; /*!50003 SET @saved_sql_mode = @@sql_mode */ ; /*!50003 SET sql_mode = 'STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION' */ ; DELIMITER ;; /*!50003 CREATE*/ /*!50017 DEFINER=`waspnet`@`%`*/ /*!50003 TRIGGER `PackagesExtras_AFTER_DELETE` AFTER DELETE ON `packagesextras` FOR EACH ROW BEGIN INSERT INTO `PackagesExtras_History` ( `ID`, `IdPackage`, `IdExtraType`, `Date`, `ForPublisher`, `ForTransporter`, `Note`, `ChangedBy`, `IdCreatorAccount`, `IdUpdaterAccount`, `CreationDate`, `LastUpdate`, `Version`, `PackageVersion`, `Deleted`, `Rate`) VALUES ( OLD.ID, OLD.IdPackage, OLD.IdExtraType, OLD.Date, OLD.ForPublisher, OLD.ForTransporter, OLD.Note, OLD.ChangedBy, OLD.IdCreatorAccount, OLD.IdUpdaterAccount, OLD.CreationDate, OLD.LastUpdate, OLD.Version, OLD.PackageVersion, 1, OLD.Rate); 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 `PackagesExtras_History` -- DROP TABLE IF EXISTS `PackagesExtras_History`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `PackagesExtras_History` ( `HistorizationNumber` bigint(20) NOT NULL AUTO_INCREMENT, `ID` varchar(38) NOT NULL, `IdPackage` varchar(38) NOT NULL, `IdExtraType` int(11) NOT NULL, `Date` datetime DEFAULT NULL, `ForPublisher` tinyint(1) NOT NULL DEFAULT '1', `ForTransporter` tinyint(1) NOT NULL DEFAULT '1', `Note` longtext, `ChangedBy` varchar(2000) DEFAULT NULL, `IdCreatorAccount` varchar(38) DEFAULT NULL, `IdUpdaterAccount` varchar(38) DEFAULT NULL, `CreationDate` datetime DEFAULT NULL, `LastUpdate` datetime NOT NULL, `Version` int(11) NOT NULL, `PackageVersion` int(11) NOT NULL, `Deleted` tinyint(1) NOT NULL DEFAULT '0', `Rate` decimal(10,2) NOT NULL DEFAULT '0.00', PRIMARY KEY (`HistorizationNumber`,`ID`,`PackageVersion`,`Deleted`), KEY `Package_PackagesExtras_idx` (`IdPackage`), KEY `ExtraType_PackagesExtras_idx` (`IdExtraType`), KEY `IDX_ID_History` (`ID`,`HistorizationNumber`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `PackagesHoles` -- DROP TABLE IF EXISTS `PackagesHoles`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `PackagesHoles` ( `IdPublisher` varchar(38) NOT NULL, `NumberFrom` int(11) NOT NULL, `NumberTo` int(11) NOT NULL, `Year` int(11) NOT NULL, PRIMARY KEY (`IdPublisher`,`NumberFrom`,`NumberTo`,`Year`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `PackagesIssues` -- DROP TABLE IF EXISTS `PackagesIssues`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `PackagesIssues` ( `ID` varchar(38) NOT NULL, `IdPackage` varchar(38) NOT NULL, `Number` int(11) DEFAULT '0', `Date` datetime NOT NULL, `IdEventType` int(11) NOT NULL, `IdIssueType` int(11) NOT NULL, `IdIssuerType` int(11) NOT NULL, `ItemCode` varchar(50) DEFAULT NULL, `Boxes` int(11) DEFAULT '0', `Weight` int(11) DEFAULT '0', `Volume` decimal(19,4) DEFAULT '0.0000', `Pallets` int(11) DEFAULT '0', `Note` longtext, `IdReturnPackage` varchar(38) DEFAULT NULL, `ChangedBy` varchar(2000) DEFAULT NULL, `IdCreatorAccount` varchar(38) DEFAULT NULL, `IdUpdaterAccount` varchar(38) DEFAULT NULL, `CreationDate` datetime DEFAULT NULL, `LastUpdate` datetime NOT NULL, `Version` int(11) NOT NULL, `PackageVersion` int(11) DEFAULT NULL, `Locked` tinyint(1) NOT NULL DEFAULT '0', PRIMARY KEY (`ID`), KEY `FK_Package_PackagesIssues_idx` (`IdPackage`), KEY `FK_ReturnPackage_PackagesIssues_idx` (`IdReturnPackage`), KEY `FK_EventType_PackagesIssues_idx` (`IdEventType`), KEY `FK_IssueType_PackagesIssues_idx` (`IdIssueType`), KEY `FK_IssuerType_PackagesIssues_idx` (`IdIssuerType`), CONSTRAINT `FK_EventType_PackagesIssues` FOREIGN KEY (`IdEventType`) REFERENCES `eventtypes` (`ID`), CONSTRAINT `FK_IssueType_PackagesIssues` FOREIGN KEY (`IdIssueType`) REFERENCES `issuetypes` (`ID`), CONSTRAINT `FK_IssuerType_PackagesIssues` FOREIGN KEY (`IdIssuerType`) REFERENCES `issuertypes` (`ID`), CONSTRAINT `FK_Package_PackagesIssues` FOREIGN KEY (`IdPackage`) REFERENCES `packages` (`ID`) ON DELETE CASCADE, CONSTRAINT `FK_ReturnPackage_PackagesIssues` FOREIGN KEY (`IdReturnPackage`) REFERENCES `packages` (`ID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `PackagesItems` -- DROP TABLE IF EXISTS `PackagesItems`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `PackagesItems` ( `ID` varchar(38) NOT NULL, `IdPackage` varchar(38) NOT NULL, `Group` varchar(250) DEFAULT NULL, `Location` varchar(10) DEFAULT NULL, `Code` varchar(50) DEFAULT NULL, `ProductionLot` varchar(50) DEFAULT NULL, `Boxes` int(11) DEFAULT '0', `Weight` int(11) DEFAULT '0', `Volume` decimal(19,4) DEFAULT '0.0000', `Description` varchar(50) DEFAULT NULL, `Note` longtext, `ChangedBy` varchar(2000) DEFAULT NULL, `IdCreatorAccount` varchar(38) DEFAULT NULL, `IdUpdaterAccount` varchar(38) DEFAULT NULL, `CreationDate` datetime DEFAULT NULL, `LastUpdate` datetime NOT NULL, `Version` int(11) NOT NULL, PRIMARY KEY (`ID`), KEY `FK_Package_PackagesItems_idx` (`IdPackage`), CONSTRAINT `FK_Package_PackagesItems` FOREIGN KEY (`IdPackage`) REFERENCES `packages` (`ID`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `PackagesRequests` -- DROP TABLE IF EXISTS `PackagesRequests`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `PackagesRequests` ( `ID` varchar(38) NOT NULL, `IdPackage` varchar(38) NOT NULL, `IdTransporter` varchar(38) DEFAULT NULL, `Status` varchar(50) NOT NULL, `StatusDate` datetime DEFAULT NULL, `Note` longtext, `LastUpdate` datetime NOT NULL, `Version` int(11) NOT NULL, PRIMARY KEY (`ID`), KEY `FK_Package_PackagesRequests_idx` (`IdPackage`), KEY `FK_Transporter_PackagesRequests` (`IdTransporter`), CONSTRAINT `FK_Package_PackagesRequests` FOREIGN KEY (`IdPackage`) REFERENCES `packages` (`ID`), CONSTRAINT `FK_Transporter_PackagesRequests` FOREIGN KEY (`IdTransporter`) REFERENCES `transporters` (`ID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `PackageSubStatus` -- DROP TABLE IF EXISTS `PackageSubStatus`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `PackageSubStatus` ( `ID` varchar(38) NOT NULL, `IdPackageType` int(11) NOT NULL, `Status` varchar(50) NOT NULL, `Description` varchar(50) NOT NULL, `Note` varchar(2000) DEFAULT NULL, `IsDefault` tinyint(1) DEFAULT '0', `EnablePublisherBilling` tinyint(1) DEFAULT '0', `EnableTransporterBilling` tinyint(1) DEFAULT '0', `EnableCoopBilling` tinyint(1) DEFAULT '0', `EnableTransporterInStock` tinyint(1) DEFAULT NULL, `EnableTransporterReturn` tinyint(1) DEFAULT NULL, `IsUnloadStart` tinyint(1) NOT NULL DEFAULT '0', `IsUnloadEnd` tinyint(1) NOT NULL DEFAULT '0', `IsInternal` tinyint(1) NOT NULL DEFAULT '0', `ApplyCOD` tinyint(1) NOT NULL DEFAULT '0', `ApplyPenalty` tinyint(1) NOT NULL DEFAULT '0', `SortOrder` int(11) DEFAULT NULL, `LastUpdate` datetime NOT NULL, `Version` int(11) NOT NULL, `AutoReload` tinyint(1) DEFAULT '0', `HideInOutPackListPrint` tinyint(1) NOT NULL DEFAULT '0', PRIMARY KEY (`ID`), UNIQUE KEY `UK_SubStatus` (`Status`,`Description`), KEY `fk_packagetypes_packagesubstatus_idx` (`IdPackageType`), KEY `IDX_PSS_EnableTransporterBilling` (`EnableTransporterBilling`), KEY `IDX_PSS_EnableTransporterInStock` (`EnableTransporterInStock`), KEY `IDX_PSS_EnableTransporterReturn` (`EnableTransporterReturn`), KEY `IDX_PSS_ApplyPenalty` (`ApplyPenalty`), CONSTRAINT `fk_packagetypes_packagesubstatus` FOREIGN KEY (`IdPackageType`) REFERENCES `packagetypes` (`ID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; ALTER DATABASE `Waspnet_Courier` CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci ; /*!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 = utf8mb4 */ ; /*!50003 SET character_set_results = utf8mb4 */ ; /*!50003 SET collation_connection = utf8mb4_0900_ai_ci */ ; /*!50003 SET @saved_sql_mode = @@sql_mode */ ; /*!50003 SET sql_mode = 'STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION' */ ; DELIMITER ;; /*!50003 CREATE*/ /*!50017 DEFINER=`waspnet`@`%`*/ /*!50003 TRIGGER `PackageSubStatus_AFTER_INSERT` AFTER INSERT ON `packagesubstatus` FOR EACH ROW BEGIN INSERT INTO `PackageSubStatus_History` (`ID`, `IdPackageType`, `Status`, `Description`, `Note`, `IsDefault`, `EnablePublisherBilling`, `EnableTransporterBilling`, `EnableCoopBilling`, `EnableTransporterInStock`, `EnableTransporterReturn`, `ApplyCOD`, `ApplyPenalty`, `SortOrder`, `LastUpdate`, `Version`, `IsUnloadStart`, `IsUnloadEnd`, `IsInternal` ) VALUES ( new.`ID`, new.`IdPackageType`, new.`Status`, new.`Description`, new.`Note`, new.`IsDefault`, new.`EnablePublisherBilling`, new.`EnableTransporterBilling`, new.`EnableCoopBilling`, new.`EnableTransporterInStock`, new.`EnableTransporterReturn`, new.`ApplyCOD`, new.`ApplyPenalty`, new.`SortOrder`, new.`LastUpdate`, new.`Version`, new.`IsUnloadStart`, new.`IsUnloadEnd`, new.`IsInternal` ); 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 */ ; ALTER DATABASE `Waspnet_Courier` CHARACTER SET utf8 COLLATE utf8_bin ; ALTER DATABASE `Waspnet_Courier` CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci ; /*!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 = utf8mb4 */ ; /*!50003 SET character_set_results = utf8mb4 */ ; /*!50003 SET collation_connection = utf8mb4_0900_ai_ci */ ; /*!50003 SET @saved_sql_mode = @@sql_mode */ ; /*!50003 SET sql_mode = 'STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION' */ ; DELIMITER ;; /*!50003 CREATE*/ /*!50017 DEFINER=`waspnet`@`%`*/ /*!50003 TRIGGER `PackageSubStatus_AFTER_UPDATE` AFTER UPDATE ON `packagesubstatus` FOR EACH ROW BEGIN INSERT INTO `PackageSubStatus_History` (`ID`, `Status`, `IdPackageType`, `Description`, `Note`, `IsDefault`, `EnablePublisherBilling`, `EnableTransporterBilling`, `EnableCoopBilling`, `EnableTransporterInStock`, `EnableTransporterReturn`, `ApplyCOD`, `ApplyPenalty`, `SortOrder`, `LastUpdate`, `Version`, `IsUnloadStart`, `IsUnloadEnd`, `IsInternal` ) VALUES ( new.`ID`, new.`Status`, new.`IdPackageType`, new.`Description`, new.`Note`, new.`IsDefault`, new.`EnablePublisherBilling`, new.`EnableTransporterBilling`, new.`EnableCoopBilling`, new.`EnableTransporterInStock`, new.`EnableTransporterReturn`, new.`ApplyCOD`, new.`ApplyPenalty`, new.`SortOrder`, new.`LastUpdate`, new.`Version`, new.`IsUnloadStart`, new.`IsUnloadEnd`, new.`IsInternal` ); 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 */ ; ALTER DATABASE `Waspnet_Courier` CHARACTER SET utf8 COLLATE utf8_bin ; -- -- Table structure for table `PackageSubStatus_History` -- DROP TABLE IF EXISTS `PackageSubStatus_History`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `PackageSubStatus_History` ( `HistorizationNumber` bigint(20) NOT NULL AUTO_INCREMENT, `ID` varchar(38) NOT NULL, `Status` varchar(50) NOT NULL, `Description` varchar(50) NOT NULL, `Note` varchar(2000) DEFAULT NULL, `IsDefault` tinyint(1) DEFAULT '0', `EnablePublisherBilling` tinyint(1) DEFAULT '0', `EnableTransporterBilling` tinyint(1) DEFAULT '0', `EnableCoopBilling` tinyint(1) DEFAULT '0', `EnableTransporterInStock` tinyint(1) DEFAULT NULL, `EnableTransporterReturn` tinyint(1) DEFAULT NULL, `IsUnloadStart` tinyint(1) NOT NULL DEFAULT '0', `IsUnloadEnd` tinyint(1) NOT NULL DEFAULT '0', `IsInternal` tinyint(1) NOT NULL DEFAULT '0', `ApplyCOD` tinyint(1) DEFAULT '0', `ApplyPenalty` tinyint(1) DEFAULT '0', `SortOrder` int(11) DEFAULT NULL, `LastUpdate` datetime NOT NULL, `Version` int(11) NOT NULL, `IdSynchronizationSession` varchar(38) DEFAULT NULL, `SynchronizationDate` datetime DEFAULT NULL, `IdPackageType` int(11) NOT NULL, `AutoReload` tinyint(1) DEFAULT '0', `HideInOutPackListPrint` tinyint(1) NOT NULL DEFAULT '0', PRIMARY KEY (`HistorizationNumber`), KEY `IDX_ID_Session` (`ID`,`IdSynchronizationSession`), KEY `IDX_SyncSession` (`IdSynchronizationSession`,`SynchronizationDate`), KEY `IDX_ID_History` (`ID`,`HistorizationNumber`), KEY `IDX_MaxHistory` (`IdSynchronizationSession`,`HistorizationNumber`) ) ENGINE=InnoDB AUTO_INCREMENT=381 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `PackageTypes` -- DROP TABLE IF EXISTS `PackageTypes`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `PackageTypes` ( `ID` int(11) NOT NULL, `Code` varchar(5) NOT NULL, `Description` varchar(50) NOT NULL, `SortOrder` int(11) DEFAULT NULL, `IsBooking` tinyint(1) NOT NULL DEFAULT '0', `IsReturn` tinyint(1) NOT NULL DEFAULT '0', `ExcludeFromEuroQ` tinyint(1) DEFAULT NULL, `IsShipping` tinyint(1) DEFAULT NULL, PRIMARY KEY (`ID`), UNIQUE KEY `Code` (`Code`), KEY `IDX_IsBooking` (`IsBooking`), KEY `IDX_SortOrder` (`SortOrder`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `PalletMovements` -- DROP TABLE IF EXISTS `PalletMovements`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `PalletMovements` ( `ID` varchar(38) NOT NULL, `Number` int(11) NOT NULL, `DateTime` datetime NOT NULL, `IdInPackList` varchar(38) DEFAULT NULL, `IdPublisher` varchar(38) DEFAULT NULL, `IdPublisherSender` varchar(38) DEFAULT NULL, `IdOutPackList` varchar(38) DEFAULT NULL, `IdTransporter` varchar(38) DEFAULT NULL, `IdVehicle` varchar(38) DEFAULT NULL, `IdDriver` varchar(38) DEFAULT NULL, `Version` int(11) NOT NULL, `LastUpdate` datetime NOT NULL, `Reference` varchar(500) DEFAULT NULL, `Notes` varchar(500) DEFAULT NULL, `ManualMovementType` varchar(50) DEFAULT NULL, PRIMARY KEY (`ID`), KEY `a_idx` (`IdInPackList`), KEY `FK_Publishers_PalletMovements_idx` (`IdPublisher`), KEY `FK_PublishersSenders_PalletMovements_idx` (`IdPublisherSender`), KEY `FK_OutPackLists_PalletMovements_idx` (`IdOutPackList`), KEY `FK_Transporters_PalletMovements_idx` (`IdTransporter`), KEY `FK_Vehicles_PalletMovements_idx` (`IdVehicle`), KEY `FK_Drivers_PalletMovements_idx` (`IdDriver`), CONSTRAINT `FK_Drivers_PalletMovements` FOREIGN KEY (`IdDriver`) REFERENCES `drivers` (`ID`), CONSTRAINT `FK_InPackList_PalletMovements` FOREIGN KEY (`IdInPackList`) REFERENCES `inpacklists` (`ID`), CONSTRAINT `FK_OutPackLists_PalletMovements` FOREIGN KEY (`IdOutPackList`) REFERENCES `outpacklists` (`ID`), CONSTRAINT `FK_PublishersSenders_PalletMovements` FOREIGN KEY (`IdPublisherSender`) REFERENCES `publisherssenders` (`ID`), CONSTRAINT `FK_Publishers_PalletMovements` FOREIGN KEY (`IdPublisher`) REFERENCES `publishers` (`ID`), CONSTRAINT `FK_Transporters_PalletMovements` FOREIGN KEY (`IdTransporter`) REFERENCES `transporters` (`ID`), CONSTRAINT `FK_Vehicles_PalletMovements` FOREIGN KEY (`IdVehicle`) REFERENCES `vehicles` (`ID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `PalletMovementsDetails` -- DROP TABLE IF EXISTS `PalletMovementsDetails`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `PalletMovementsDetails` ( `ID` varchar(38) NOT NULL, `IdPalletMovement` varchar(38) NOT NULL, `IdPalletType` int(11) NOT NULL, `Amount` int(11) NOT NULL, `MovementType` varchar(50) NOT NULL, `Version` int(11) NOT NULL, `LastUpdate` datetime NOT NULL, `IdCreatorAccount` varchar(38) DEFAULT NULL, `CreationDate` datetime DEFAULT NULL, `IdUpdaterAccount` varchar(38) DEFAULT NULL, `ChangedBy` varchar(2000) DEFAULT NULL, PRIMARY KEY (`ID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `PalletTypes` -- DROP TABLE IF EXISTS `PalletTypes`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `PalletTypes` ( `ID` int(11) NOT NULL, `Code` varchar(5) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, `Description` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, `SortOrder` int(11) NOT NULL DEFAULT '0', `IsDamaged` tinyint(1) NOT NULL DEFAULT '0', `IsEPal` tinyint(1) NOT NULL DEFAULT '0', `IsChep` tinyint(1) NOT NULL DEFAULT '0', `Rate` decimal(19,4) NOT NULL DEFAULT '0.0000', UNIQUE KEY `Code_UNIQUE` (`Code`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `PAReturnPackages` -- DROP TABLE IF EXISTS `PAReturnPackages`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `PAReturnPackages` ( `ID` varchar(38) NOT NULL, `IdPAReturn` varchar(38) NOT NULL, `IdCashReceiptPackage` varchar(38) NOT NULL, `Amount` decimal(19,4) NOT NULL DEFAULT '0.0000', `PayType` varchar(50) NOT NULL, `Note` longtext, `LastUpdate` datetime NOT NULL, `Version` int(11) NOT NULL, PRIMARY KEY (`ID`), KEY `FK_CashReceiptPackage_PAReturnPackages_idx` (`IdCashReceiptPackage`), KEY `FK_PAReturn_PAReturnPackages_idx` (`IdPAReturn`), CONSTRAINT `FK_CashReceiptPackage_PAReturnPackages` FOREIGN KEY (`IdCashReceiptPackage`) REFERENCES `cashreceiptpackages` (`ID`), CONSTRAINT `FK_PAReturn_PAReturnPackages` FOREIGN KEY (`IdPAReturn`) REFERENCES `pareturns` (`ID`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `PAReturns` -- DROP TABLE IF EXISTS `PAReturns`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `PAReturns` ( `ID` varchar(38) NOT NULL, `Number` int(11) NOT NULL, `Date` datetime NOT NULL, `Note` longtext, `IdPublisher` varchar(38) NOT NULL, `LastUpdate` datetime NOT NULL, `Version` int(11) NOT NULL, PRIMARY KEY (`ID`), KEY `Date` (`Date`), KEY `Number` (`Number`), KEY `FK_Publisher_PAReturns_idx` (`IdPublisher`), CONSTRAINT `FK_Publisher_PAReturns` FOREIGN KEY (`IdPublisher`) REFERENCES `publishers` (`ID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `PartPayments` -- DROP TABLE IF EXISTS `PartPayments`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `PartPayments` ( `ID` varchar(38) NOT NULL, `IdAccountingExpiration` varchar(38) NOT NULL, `Date` datetime NOT NULL, `Amount` decimal(19,8) NOT NULL DEFAULT '0.00000000', `Note` longtext, `LastUpdate` datetime NOT NULL, `Version` int(11) NOT NULL, PRIMARY KEY (`ID`), KEY `FK_PartPayment_AccountingExpiration` (`IdAccountingExpiration`), CONSTRAINT `FK_PartPayment_AccountingExpiration` FOREIGN KEY (`IdAccountingExpiration`) REFERENCES `accountingexpirations` (`ID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `PaymentTypes` -- DROP TABLE IF EXISTS `PaymentTypes`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `PaymentTypes` ( `ID` varchar(38) NOT NULL, `Description` varchar(50) NOT NULL, `Note` varchar(2000) DEFAULT NULL, `Expiration_01_GG` int(11) DEFAULT NULL, `Expiration_01_PercTax` decimal(19,4) DEFAULT NULL, `Expiration_01_PercAmount` decimal(19,4) DEFAULT NULL, `Expiration_02_GG` int(11) DEFAULT NULL, `Expiration_02_PercTax` decimal(19,4) DEFAULT NULL, `Expiration_02_PercAmount` decimal(19,4) DEFAULT NULL, `Expiration_03_GG` int(11) DEFAULT NULL, `Expiration_03_PercTax` decimal(19,4) DEFAULT NULL, `Expiration_03_PercAmount` decimal(19,4) DEFAULT NULL, `Expiration_04_GG` int(11) DEFAULT NULL, `Expiration_04_PercTax` decimal(19,4) DEFAULT NULL, `Expiration_04_PercAmount` decimal(19,4) DEFAULT NULL, `Expiration_05_GG` int(11) DEFAULT NULL, `Expiration_05_PercTax` decimal(19,4) DEFAULT NULL, `Expiration_05_PercAmount` decimal(19,4) DEFAULT NULL, `IsDefault` tinyint(1) DEFAULT '0', `GC_Code` varchar(50) DEFAULT '0', `SortOrder` int(11) DEFAULT NULL, `LastUpdate` datetime NOT NULL, `Version` int(11) NOT NULL, `EndOfMonth` tinyint(1) DEFAULT NULL, PRIMARY KEY (`ID`), UNIQUE KEY `Description` (`Description`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `PendingTransmissions` -- DROP TABLE IF EXISTS `PendingTransmissions`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `PendingTransmissions` ( `ID` varchar(38) NOT NULL, `IdPackage` varchar(38) NOT NULL, `Locked` tinyint(1) NOT NULL DEFAULT '1', `IdExportEventSession` varchar(38) DEFAULT NULL, `ExportEventSentDate` datetime DEFAULT NULL, `Version` int(11) NOT NULL DEFAULT '0', `LastUpdate` datetime NOT NULL, PRIMARY KEY (`ID`), KEY `fk_packages_pendingtransmissions` (`IdPackage`), KEY `IDX_IdExportEventSession` (`IdExportEventSession`), CONSTRAINT `fk_packages_pendingtransmissions` FOREIGN KEY (`IdPackage`) REFERENCES `packages` (`ID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `Permissions` -- DROP TABLE IF EXISTS `Permissions`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `Permissions` ( `ID` varchar(100) NOT NULL, `IdMenu` varchar(50) DEFAULT NULL, `Description` varchar(100) DEFAULT NULL, `Order` int(11) DEFAULT NULL, PRIMARY KEY (`ID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `PreReceiptPackages` -- DROP TABLE IF EXISTS `PreReceiptPackages`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `PreReceiptPackages` ( `ID` varchar(38) NOT NULL, `IdPreReceipt` varchar(38) NOT NULL, `IdPackage` varchar(38) NOT NULL, `PRE_Amount` decimal(19,4) NOT NULL DEFAULT '0.0000', `PRE_PayType` varchar(50) NOT NULL, `PRE_Note` longtext, `LastUpdate` datetime NOT NULL, `Version` int(11) NOT NULL, PRIMARY KEY (`ID`), KEY `FK_Package_PreReceiptPackages_idx` (`IdPackage`), KEY `FK_PreReceipt_PreReceiptPackages_idx` (`IdPreReceipt`), CONSTRAINT `FK_Package_PreReceiptPackages` FOREIGN KEY (`IdPackage`) REFERENCES `packages` (`ID`), CONSTRAINT `FK_PreReceipt_PreReceiptPackages` FOREIGN KEY (`IdPreReceipt`) REFERENCES `prereceipts` (`ID`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `PreReceipts` -- DROP TABLE IF EXISTS `PreReceipts`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `PreReceipts` ( `ID` varchar(38) NOT NULL, `Number` int(11) NOT NULL, `Date` datetime NOT NULL, `IdTransporter` varchar(38) DEFAULT NULL, `LastUpdate` datetime NOT NULL, `Version` int(11) NOT NULL, `Status` varchar(50) NOT NULL DEFAULT 'Approved', `PrintingNumber` int(11) DEFAULT NULL, `PrintingDate` datetime DEFAULT NULL, PRIMARY KEY (`ID`), KEY `Date` (`Date`), KEY `Number` (`Number`), KEY `FK_Transporter_PreReceipts_idx` (`IdTransporter`), CONSTRAINT `FK_Transporter_PreReceipts` FOREIGN KEY (`IdTransporter`) REFERENCES `transporters` (`ID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `Profiles` -- DROP TABLE IF EXISTS `Profiles`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `Profiles` ( `ID` varchar(38) NOT NULL, `Description` varchar(255) NOT NULL, `Level` int(11) DEFAULT NULL, `IsManaged` tinyint(1) DEFAULT '0', `Version` int(11) NOT NULL, `LastUpdate` datetime NOT NULL, PRIMARY KEY (`ID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `ProfilesPermissions` -- DROP TABLE IF EXISTS `ProfilesPermissions`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `ProfilesPermissions` ( `IdProfile` varchar(38) NOT NULL, `IdPermission` varchar(255) NOT NULL, `CanAccess` tinyint(1) DEFAULT '0', `CanCreate` tinyint(1) DEFAULT '0', `CanRead` tinyint(1) DEFAULT '0', `CanDelete` tinyint(1) DEFAULT '0', `CanUpdate` tinyint(1) DEFAULT '0', `Version` int(11) NOT NULL DEFAULT '0', `LastUpdate` datetime NOT NULL, PRIMARY KEY (`IdProfile`,`IdPermission`), KEY `FK_Permission` (`IdPermission`), CONSTRAINT `FK_Permission` FOREIGN KEY (`IdPermission`) REFERENCES `permissions` (`ID`), CONSTRAINT `FK_Profile_ProfilesPermissions` FOREIGN KEY (`IdProfile`) REFERENCES `profiles` (`ID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `PublisherPayments` -- DROP TABLE IF EXISTS `PublisherPayments`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `PublisherPayments` ( `ID` varchar(38) NOT NULL, `IdPublisher` varchar(38) NOT NULL, `Date` datetime NOT NULL, `Amount` decimal(19,8) NOT NULL DEFAULT '0.00000000', `CoinType` varchar(50) NOT NULL, `Note` longtext, `Suspended` tinyint(1) NOT NULL DEFAULT '0', `LastUpdate` datetime NOT NULL, `Version` int(11) NOT NULL, PRIMARY KEY (`ID`), KEY `FK_Publisher_Payment_idx` (`IdPublisher`), CONSTRAINT `FK_Publisher_Payment` FOREIGN KEY (`IdPublisher`) REFERENCES `publishers` (`ID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `Publishers` -- DROP TABLE IF EXISTS `Publishers`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `Publishers` ( `ID` varchar(38) NOT NULL, `Code` varchar(10) DEFAULT NULL, `Name` varchar(50) DEFAULT NULL, `EMail` varchar(255) DEFAULT NULL, `Phone` varchar(255) DEFAULT NULL, `Note` longtext, `LabelsCount` varchar(255) DEFAULT NULL, `Deleted` tinyint(1) DEFAULT '0', `PackListImportType` varchar(255) DEFAULT NULL, `LastUpdate` datetime NOT NULL, `Version` int(11) NOT NULL, `ReferenceTemplate` varchar(2000) DEFAULT NULL, `OnlyProvinces` varchar(2000) DEFAULT NULL, `SynchronizeOnCash` tinyint(1) DEFAULT '0', `FtpAddress` varchar(2000) DEFAULT NULL, `FtpRemoteFolder` varchar(2000) DEFAULT NULL, `FtpUsername` varchar(2000) DEFAULT NULL, `FtpPassword` varchar(2000) DEFAULT NULL, `FtpArchiveRemoteFolder` varchar(2000) DEFAULT NULL, `PartnerCode` varchar(250) DEFAULT NULL, `PIVA` varchar(30) DEFAULT NULL, `CF` varchar(50) DEFAULT NULL, `InvoiceHeader` longtext, `DocumentReceiver` longtext, `IsCustomer` tinyint(1) DEFAULT '1', `IsSupplier` tinyint(1) DEFAULT '0', `AutoApproveInPackList` tinyint(1) DEFAULT '0', `PIVAState` varchar(2) DEFAULT NULL, `CompanyName` varchar(200) DEFAULT NULL, `LastName` varchar(100) DEFAULT NULL, `FirstName` varchar(100) DEFAULT NULL, `Address` varchar(250) DEFAULT NULL, `CivicNumber` varchar(20) DEFAULT NULL, `ZipCode` varchar(10) DEFAULT NULL, `City` varchar(50) DEFAULT NULL, `Country` varchar(5) DEFAULT NULL, `State` varchar(5) DEFAULT NULL, `DestinationCode` varchar(20) DEFAULT NULL, `PEC` varchar(250) DEFAULT NULL, `RequireUnload` tinyint(1) DEFAULT NULL, `RequirePerBoxReply` tinyint(1) DEFAULT NULL, `RequireETA` tinyint(1) DEFAULT NULL, PRIMARY KEY (`ID`), UNIQUE KEY `Code_UNIQUE` (`Code`), KEY `IDX_ID_Code` (`ID`,`Code`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Se non è null, invece di eliminare i file dall''ftp dopo averli scaricati li sposta nella cartella Archive'; /*!40101 SET character_set_client = @saved_cs_client */; ALTER DATABASE `Waspnet_Courier` CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci ; /*!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 = utf8mb4 */ ; /*!50003 SET character_set_results = utf8mb4 */ ; /*!50003 SET collation_connection = utf8mb4_0900_ai_ci */ ; /*!50003 SET @saved_sql_mode = @@sql_mode */ ; /*!50003 SET sql_mode = 'STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION' */ ; DELIMITER ;; /*!50003 CREATE*/ /*!50017 DEFINER=`waspnet`@`%`*/ /*!50003 TRIGGER `Publishers_AFTER_INSERT` AFTER INSERT ON `publishers` FOR EACH ROW BEGIN INSERT INTO `Publishers_History` (`ID`, `Code`, `Name`, `EMail`, `Phone`, `Note`, `LabelsCount`, `Deleted`, `PackListImportType`, `LastUpdate`, `Version`, `ReferenceTemplate`, `OnlyProvinces`, `SynchronizeOnCash`, `FtpAddress`, `FtpRemoteFolder`, `FtpUsername`, `FtpPassword`, `PartnerCode`, `PIVA`, `CF`, `InvoiceHeader`, `DocumentReceiver`, `IsCustomer`, `IsSupplier`, `AutoApproveInPackList`, `PIVAState`, `CompanyName`, `LastName`, `FirstName`, `Address`, `CivicNumber`, `ZipCode`, `City`, `Country`, `State`, `DestinationCode`, `PEC`, `FtpArchiveRemoteFolder`, `RequirePerBoxReply`, `RequireUnload` ) VALUES ( new.`ID`, new.`Code`, new.`Name`, new.`EMail`, new.`Phone`, new.`Note`, new.`LabelsCount`, new.`Deleted`, new.`PackListImportType`, new.`LastUpdate`, new.`Version`, new.`ReferenceTemplate`, new.`OnlyProvinces`, new.`SynchronizeOnCash`, new.`FtpAddress`, new.`FtpRemoteFolder`, new.`FtpUsername`, new.`FtpPassword`, new.`PartnerCode`, new.`PIVA`, new.`CF`, new.`InvoiceHeader`, new.`DocumentReceiver`, new.`IsCustomer`, new.`IsSupplier`, new.`AutoApproveInPackList`, new.`PIVAState`, new.`CompanyName`, new.`LastName`, new.`FirstName`, new.`Address`, new.`CivicNumber`, new.`ZipCode`, new.`City`, new.`Country`, new.`State`, new.`DestinationCode`, new.`PEC`, new.`FtpArchiveRemoteFolder`, new.`RequirePerBoxReply`, new.`RequireUnload` ); 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 */ ; ALTER DATABASE `Waspnet_Courier` CHARACTER SET utf8 COLLATE utf8_bin ; ALTER DATABASE `Waspnet_Courier` CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci ; /*!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 = utf8mb4 */ ; /*!50003 SET character_set_results = utf8mb4 */ ; /*!50003 SET collation_connection = utf8mb4_0900_ai_ci */ ; /*!50003 SET @saved_sql_mode = @@sql_mode */ ; /*!50003 SET sql_mode = 'STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION' */ ; DELIMITER ;; /*!50003 CREATE*/ /*!50017 DEFINER=`waspnet`@`%`*/ /*!50003 TRIGGER `Publishers_AFTER_UPDATE` AFTER UPDATE ON `publishers` FOR EACH ROW BEGIN INSERT INTO `Publishers_History` (`ID`, `Code`, `Name`, `EMail`, `Phone`, `Note`, `LabelsCount`, `Deleted`, `PackListImportType`, `LastUpdate`, `Version`, `ReferenceTemplate`, `OnlyProvinces`, `SynchronizeOnCash`, `FtpAddress`, `FtpRemoteFolder`, `FtpUsername`, `FtpPassword`, `PartnerCode`, `PIVA`, `CF`, `InvoiceHeader`, `DocumentReceiver`, `IsCustomer`, `IsSupplier`, `AutoApproveInPackList`, `PIVAState`, `CompanyName`, `LastName`, `FirstName`, `Address`, `CivicNumber`, `ZipCode`, `City`, `Country`, `State`, `DestinationCode`, `PEC`, `FtpArchiveRemoteFolder`, `RequirePerBoxReply`, `RequireUnload` ) VALUES ( new.`ID`, new.`Code`, new.`Name`, new.`EMail`, new.`Phone`, new.`Note`, new.`LabelsCount`, new.`Deleted`, new.`PackListImportType`, new.`LastUpdate`, new.`Version`, new.`ReferenceTemplate`, new.`OnlyProvinces`, new.`SynchronizeOnCash`, new.`FtpAddress`, new.`FtpRemoteFolder`, new.`FtpUsername`, new.`FtpPassword`, new.`PartnerCode`, new.`PIVA`, new.`CF`, new.`InvoiceHeader`, new.`DocumentReceiver`, new.`IsCustomer`, new.`IsSupplier`, new.`AutoApproveInPackList`, new.`PIVAState`, new.`CompanyName`, new.`LastName`, new.`FirstName`, new.`Address`, new.`CivicNumber`, new.`ZipCode`, new.`City`, new.`Country`, new.`State`, new.`DestinationCode`, new.`PEC`, new.`FtpArchiveRemoteFolder`, new.`RequirePerBoxReply`, new.`RequireUnload` ); 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 */ ; ALTER DATABASE `Waspnet_Courier` CHARACTER SET utf8 COLLATE utf8_bin ; -- -- Table structure for table `Publishers_History` -- DROP TABLE IF EXISTS `Publishers_History`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `Publishers_History` ( `HistorizationNumber` bigint(20) NOT NULL AUTO_INCREMENT, `ID` varchar(38) NOT NULL, `Code` varchar(10) DEFAULT NULL, `Name` varchar(50) DEFAULT NULL, `EMail` varchar(255) DEFAULT NULL, `Phone` varchar(255) DEFAULT NULL, `Note` longtext, `LabelsCount` varchar(255) DEFAULT NULL, `Deleted` tinyint(1) DEFAULT '0', `PackListImportType` varchar(255) DEFAULT NULL, `LastUpdate` datetime NOT NULL, `Version` int(11) NOT NULL, `ReferenceTemplate` varchar(2000) DEFAULT NULL, `OnlyProvinces` varchar(2000) DEFAULT NULL, `SynchronizeOnCash` tinyint(1) DEFAULT '0', `FtpAddress` varchar(2000) DEFAULT NULL, `FtpRemoteFolder` varchar(2000) DEFAULT NULL, `FtpUsername` varchar(2000) DEFAULT NULL, `FtpPassword` varchar(2000) DEFAULT NULL, `PartnerCode` varchar(250) DEFAULT NULL, `PIVA` varchar(30) DEFAULT NULL, `CF` varchar(50) DEFAULT NULL, `InvoiceHeader` longtext, `DocumentReceiver` longtext, `IsCustomer` tinyint(1) DEFAULT '1', `IsSupplier` tinyint(1) DEFAULT '0', `AutoApproveInPackList` tinyint(1) DEFAULT '0', `PIVAState` varchar(2) DEFAULT NULL, `CompanyName` varchar(200) DEFAULT NULL, `LastName` varchar(100) DEFAULT NULL, `FirstName` varchar(100) DEFAULT NULL, `Address` varchar(250) DEFAULT NULL, `CivicNumber` varchar(20) DEFAULT NULL, `ZipCode` varchar(10) DEFAULT NULL, `City` varchar(50) DEFAULT NULL, `Country` varchar(5) DEFAULT NULL, `State` varchar(5) DEFAULT NULL, `DestinationCode` varchar(20) DEFAULT NULL, `PEC` varchar(250) DEFAULT NULL, `IdSynchronizationSession` varchar(38) DEFAULT NULL, `SynchronizationDate` datetime DEFAULT NULL, `FtpArchiveRemoteFolder` varchar(2000) DEFAULT NULL, `RequireUnload` tinyint(1) DEFAULT NULL, `RequirePerBoxReply` tinyint(1) DEFAULT NULL, `RequireETA` tinyint(1) DEFAULT NULL, PRIMARY KEY (`HistorizationNumber`), KEY `IDX_ID_Session` (`ID`,`IdSynchronizationSession`), KEY `IDX_SyncSession` (`IdSynchronizationSession`,`SynchronizationDate`), KEY `IDX_ID_History` (`ID`,`HistorizationNumber`), KEY `IDX_MaxHistory` (`IdSynchronizationSession`,`HistorizationNumber`) ) ENGINE=InnoDB AUTO_INCREMENT=314 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `PublishersBillings` -- DROP TABLE IF EXISTS `PublishersBillings`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `PublishersBillings` ( `ID` varchar(38) NOT NULL, `BillDate` datetime NOT NULL, `IdPublisher` varchar(38) NOT NULL, `PackagesRange` longtext, `ReDeliveredPackagesRange` longtext, `ToNumber` int(11) DEFAULT NULL, `ToDate` datetime DEFAULT NULL, `LastUpdate` datetime NOT NULL, `Version` int(11) NOT NULL, `HidePackagesRange` tinyint(1) DEFAULT '0', PRIMARY KEY (`ID`), KEY `BillDate` (`BillDate`), KEY `FK_Publisher_PublishersBillings_idx` (`IdPublisher`), CONSTRAINT `FK_Publisher_PublishersBillings` FOREIGN KEY (`IdPublisher`) REFERENCES `publishers` (`ID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `PublishersBillingsInStockPackages` -- DROP TABLE IF EXISTS `PublishersBillingsInStockPackages`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `PublishersBillingsInStockPackages` ( `ID` varchar(38) NOT NULL, `IdPackage` varchar(38) DEFAULT NULL, `IdPublisherBilling` varchar(38) NOT NULL, `InStockRate` decimal(19,4) DEFAULT NULL, `LastUpdate` datetime NOT NULL, `Version` int(11) NOT NULL, `CashOnDeliveryRate` decimal(19,4) DEFAULT NULL, PRIMARY KEY (`ID`), KEY `FK_PublisherBilling_PublishersBillingsInStockPackages_idx` (`IdPublisherBilling`), KEY `FK_Package_PublishersBillingsInStockPackages_idx` (`IdPackage`), CONSTRAINT `FK_Package_PublishersBillingsInStockPackages` FOREIGN KEY (`IdPackage`) REFERENCES `packages` (`ID`) ON DELETE CASCADE, CONSTRAINT `FK_PublisherBilling_PublishersBillingsInStockPackages` FOREIGN KEY (`IdPublisherBilling`) REFERENCES `publishersbillings` (`ID`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `PublishersBillingsPackages` -- DROP TABLE IF EXISTS `PublishersBillingsPackages`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `PublishersBillingsPackages` ( `ID` varchar(38) NOT NULL, `IdPackage` varchar(38) DEFAULT NULL, `IdPublisherBilling` varchar(38) NOT NULL, `IdDeliveryType` int(11) DEFAULT NULL, `IdPackageType` int(11) DEFAULT NULL, `IdAdminArea` int(11) DEFAULT NULL, `BaseRate` decimal(19,4) DEFAULT NULL, `DeliveryRate` decimal(19,4) DEFAULT NULL, `PackageRate` decimal(19,4) DEFAULT NULL, `InsuranceRate` decimal(19,4) DEFAULT NULL, `CashOnDeliveryRate` decimal(19,4) DEFAULT NULL, `PDCRate` decimal(19,4) DEFAULT NULL, `ReDelivery` tinyint(1) DEFAULT '0', `LastUpdate` datetime NOT NULL, `Version` int(11) NOT NULL, `Weight` int(11) DEFAULT NULL, `Boxes` int(11) DEFAULT '1', `Pallets` int(11) DEFAULT NULL, `Volume` decimal(19,4) DEFAULT NULL, `UnitType` varchar(50) DEFAULT NULL, `ExtraRate` decimal(19,4) DEFAULT NULL, `Quantity` decimal(19,4) NOT NULL DEFAULT '1.0000', `ExtrasDescription` longtext, `IdMerge` varchar(38) DEFAULT NULL, `ErrorDescription` longtext, PRIMARY KEY (`ID`), KEY `FK_PublishersBilling_PublishersBillingsPackages_idx` (`IdPublisherBilling`), KEY `FK_PackageType_PublishersBillingsPackages_idx` (`IdPackageType`), KEY `FK_Package_PublishersBillingsPackages_idx` (`IdPackage`), KEY `FK_DeliveryType_PublishersBillingsPackages_idx` (`IdDeliveryType`), KEY `FK_AdminArea_PublishersBillingsPackages_idx` (`IdAdminArea`), CONSTRAINT `FK_AdminArea_PublishersBillingsPackages` FOREIGN KEY (`IdAdminArea`) REFERENCES `adminareas` (`ID`) ON UPDATE CASCADE, CONSTRAINT `FK_DeliveryType_PublishersBillingsPackages` FOREIGN KEY (`IdDeliveryType`) REFERENCES `deliverytypes` (`ID`), CONSTRAINT `FK_PackageType_PublishersBillingsPackages` FOREIGN KEY (`IdPackageType`) REFERENCES `packagetypes` (`ID`), CONSTRAINT `FK_Package_PublishersBillingsPackages` FOREIGN KEY (`IdPackage`) REFERENCES `packages` (`ID`) ON DELETE CASCADE, CONSTRAINT `FK_PublishersBilling_PublishersBillingsPackages` FOREIGN KEY (`IdPublisherBilling`) REFERENCES `publishersbillings` (`ID`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `PublishersBillingsReturnedPackages` -- DROP TABLE IF EXISTS `PublishersBillingsReturnedPackages`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `PublishersBillingsReturnedPackages` ( `ID` varchar(38) NOT NULL, `IdPackage` varchar(38) DEFAULT NULL, `IdPublisherBilling` varchar(38) NOT NULL, `ReturnedRate` decimal(19,4) DEFAULT NULL, `LastUpdate` datetime NOT NULL, `Version` int(11) NOT NULL, PRIMARY KEY (`ID`), KEY `FK_PublishersBilling_PublishersBillingsReturnedPackages_idx` (`IdPublisherBilling`), KEY `FK_Package_PublishersBillingsReturnedPackages_idx` (`IdPackage`), CONSTRAINT `FK_Package_PublishersBillingsReturnedPackages` FOREIGN KEY (`IdPackage`) REFERENCES `packages` (`ID`) ON DELETE CASCADE, CONSTRAINT `FK_PublishersBilling_PublishersBillingsReturnedPackages` FOREIGN KEY (`IdPublisherBilling`) REFERENCES `publishersbillings` (`ID`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `PublishersExtraInfo` -- DROP TABLE IF EXISTS `PublishersExtraInfo`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `PublishersExtraInfo` ( `ID` varchar(38) NOT NULL, `IdTaxType` varchar(38) DEFAULT NULL, `IdPaymentType` varchar(38) DEFAULT NULL, `IdBank` varchar(38) DEFAULT NULL, `DiscountPerc_01` decimal(19,8) NOT NULL DEFAULT '0.00000000', `DiscountPerc_02` decimal(19,8) NOT NULL DEFAULT '0.00000000', `DiscountPerc_03` decimal(19,8) NOT NULL DEFAULT '0.00000000', `DiscountVal` decimal(19,8) NOT NULL DEFAULT '0.00000000', `FixedCost` decimal(19,8) NOT NULL DEFAULT '0.00000000', `LastUpdate` datetime NOT NULL, `Version` int(11) NOT NULL, `EPalLostPerc` decimal(19,8) DEFAULT NULL, `DocsReceiverMails` varchar(500) DEFAULT NULL, `CashReturnReceiverMails` varchar(500) DEFAULT NULL, `InStockPackReceiverMails` varchar(500) DEFAULT NULL, `TypeDeliveryDateRequired` tinyint(1) DEFAULT '0', `CodeDeliveryDateRequired` tinyint(1) DEFAULT '0', `NoteDeliveryDateRequired` tinyint(1) DEFAULT '0', PRIMARY KEY (`ID`), CONSTRAINT `FK_PublishersExtraInfo_Publisher` FOREIGN KEY (`ID`) REFERENCES `publishers` (`ID`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `PublishersPackageStatuses` -- DROP TABLE IF EXISTS `PublishersPackageStatuses`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `PublishersPackageStatuses` ( `ID` varchar(38) NOT NULL, `InternalStatus` varchar(50) NOT NULL, `ExternalCode` varchar(50) NOT NULL, `ExternalDescription` varchar(100) DEFAULT NULL, `Version` int(11) NOT NULL, `LastUpdate` datetime NOT NULL, `IdPublisher` varchar(38) NOT NULL, `IdPublisherSender` varchar(38) DEFAULT NULL, KEY `fk_PublishersPackageStatuses_Publishers_idx` (`IdPublisher`), KEY `fk_PublishersPackageStatuses_PublisherSender_idx` (`IdPublisherSender`), CONSTRAINT `fk_PublishersPackageStatuses_PublisherSender` FOREIGN KEY (`IdPublisherSender`) REFERENCES `publisherssenders` (`ID`), CONSTRAINT `fk_PublishersPackageStatuses_Publishers` FOREIGN KEY (`IdPublisher`) REFERENCES `publishers` (`ID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `PublishersRates` -- DROP TABLE IF EXISTS `PublishersRates`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `PublishersRates` ( `ID` varchar(38) NOT NULL, `IdPublisher` varchar(38) DEFAULT NULL, `IdSender` varchar(45) DEFAULT NULL, `FromDate` datetime NOT NULL, `ToDate` datetime NOT NULL, `InsuranceValuePer` decimal(19,4) DEFAULT NULL, `InsuranceValueMin` decimal(19,4) DEFAULT NULL, `InsuranceValueMinVal` decimal(19,4) DEFAULT NULL, `InsuranceValueMaxVal` decimal(19,4) DEFAULT NULL, `InsuranceBoxesVal` decimal(19,4) DEFAULT NULL, `InsuranceBoxesMinVal` decimal(19,4) DEFAULT NULL, `InsuranceBoxesMaxVal` decimal(19,4) DEFAULT NULL, `InsuranceDeliveryVal` decimal(19,4) DEFAULT NULL, `InsuranceDeliveryMinVal` decimal(19,4) DEFAULT NULL, `InsuranceDeliveryMaxVal` decimal(19,4) DEFAULT NULL, `CashOnDeliveryPer` decimal(19,4) DEFAULT NULL, `CashOnDeliveryMinVal` decimal(19,4) DEFAULT NULL, `ReturnedVal` decimal(19,4) DEFAULT NULL, `InStockVal` decimal(19,4) DEFAULT NULL, `ReDeliveryChangeType` varchar(1) DEFAULT '%', `ReDeliveryChangeVal` decimal(19,4) DEFAULT '100.0000', `InsuranceBaseVal` decimal(19,4) DEFAULT NULL, `PDCVal` decimal(19,4) DEFAULT NULL, `MergeForReceiverInDate` tinyint(1) DEFAULT '0', `UnitsToIgnore` int(11) NOT NULL DEFAULT '14', `LastUpdate` datetime NOT NULL, `Version` int(11) NOT NULL, `HidePackagesRange` tinyint(1) DEFAULT '0', `HasDefaultRates` tinyint(1) DEFAULT '0', `PDC_T0` decimal(19,4) DEFAULT '0.0000', `PDC_B6M` decimal(19,4) DEFAULT '0.0000', `PDC_A6M` decimal(19,4) DEFAULT '0.0000', `TelephoneNotice` decimal(19,4) DEFAULT '0.0000', `VolumeWeight` decimal(19,4) DEFAULT '0.0000', `BoxesWeight` decimal(19,4) DEFAULT '0.0000', `PalletsWeight` decimal(19,4) DEFAULT '0.0000', `InsuranceBaseAdminAreas` varchar(200) DEFAULT NULL, `Description` varchar(50) DEFAULT NULL, `CashOnDeliveryMaxVal` decimal(19,4) DEFAULT NULL, `ReturnedChangeType` varchar(1) DEFAULT '€', `PackAmountPerc` decimal(19,4) DEFAULT '0.0000', `PackAmountMin` decimal(19,4) DEFAULT '0.0000', `PackAmountMax` decimal(19,4) DEFAULT '0.0000', `EPalRate` decimal(19,8) NOT NULL DEFAULT '0.00000000', `StorageRate` decimal(19,4) DEFAULT NULL, `StorageWeight` decimal(19,4) DEFAULT NULL, `IgnoreReceiverNameWhileMerge` tinyint(1) DEFAULT NULL, `OnlyReplies` tinyint(1) DEFAULT '0', `IgnoreSenderGroupWhileMerge` tinyint(1) DEFAULT NULL, `MergeCOD` tinyint(1) DEFAULT NULL, `MinVolume` decimal(19,4) DEFAULT NULL, PRIMARY KEY (`ID`), KEY `IDX_PublishersRates_ToDate` (`ToDate`), KEY `IDX_PublishersRates_FromDate` (`FromDate`), KEY `FK_Publisher_PublishersRates_idx` (`IdPublisher`), KEY `FK_Sender_PublishersRates_idx` (`IdSender`), CONSTRAINT `FK_Publisher_PublishersRates` FOREIGN KEY (`IdPublisher`) REFERENCES `publishers` (`ID`) ON DELETE CASCADE, CONSTRAINT `FK_Sender_PublishersRates` FOREIGN KEY (`IdSender`) REFERENCES `publisherssenders` (`ID`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `PublishersRatesBases` -- DROP TABLE IF EXISTS `PublishersRatesBases`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `PublishersRatesBases` ( `ID` varchar(38) NOT NULL, `IdPublisherRate` varchar(38) NOT NULL, `IdPackageType` int(11) NOT NULL, `IdAdminArea` int(11) DEFAULT NULL, `Rate` decimal(19,4) DEFAULT NULL, `LastUpdate` datetime NOT NULL, `Version` int(11) NOT NULL, `MinVal` decimal(19,4) DEFAULT NULL, `MaxVal` decimal(19,4) DEFAULT NULL, `UnitGap` decimal(19,4) DEFAULT NULL, `UnitType` varchar(45) NOT NULL DEFAULT 'Boxes', `ApplyCOD` tinyint(4) NOT NULL DEFAULT '1', `RoundToUnitGap` tinyint(1) NOT NULL DEFAULT '0', PRIMARY KEY (`ID`), KEY `FK_PublisherRate_PublishersRatesBases_idx` (`IdPublisherRate`), KEY `FK_PackageType_PublishersRatesBases_idx` (`IdPackageType`), KEY `FK_AdminArea_PublishersRatesBases_idx` (`IdAdminArea`), CONSTRAINT `FK_AdminArea_PublishersRatesBases` FOREIGN KEY (`IdAdminArea`) REFERENCES `adminareas` (`ID`) ON UPDATE CASCADE, CONSTRAINT `FK_PackageType_PublishersRatesBases` FOREIGN KEY (`IdPackageType`) REFERENCES `packagetypes` (`ID`), CONSTRAINT `FK_PublisherRate_PublishersRatesBases` FOREIGN KEY (`IdPublisherRate`) REFERENCES `publishersrates` (`ID`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `PublishersRatesDeliveryTypes` -- DROP TABLE IF EXISTS `PublishersRatesDeliveryTypes`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `PublishersRatesDeliveryTypes` ( `ID` varchar(38) NOT NULL, `IdPublisherRate` varchar(38) NOT NULL, `IdPackageType` int(11) DEFAULT NULL, `IdAdminArea` int(11) DEFAULT NULL, `IdDeliveryType` int(11) DEFAULT NULL, `ChangeType` varchar(1) DEFAULT NULL, `ChangeValue` decimal(19,4) DEFAULT NULL, `LastUpdate` datetime NOT NULL, `Version` int(11) NOT NULL, `ApplyOnReDelivery` tinyint(4) DEFAULT NULL, PRIMARY KEY (`ID`), UNIQUE KEY `UK_PublishersRatesDeliveryTypes` (`IdPublisherRate`,`IdPackageType`,`IdAdminArea`,`IdDeliveryType`), KEY `FK_PublisherRate_PublishersRatesDeliveryTypes_idx` (`IdPublisherRate`), KEY `FK_PackageType_PublishersRatesDeliveryTypes_idx` (`IdPackageType`), KEY `FK_DeliveryType_PublishersRatesDeliveryTypes_idx` (`IdDeliveryType`), KEY `FK_AdminArea_PublishersRatesDeliveryTypes_idx` (`IdAdminArea`), CONSTRAINT `FK_AdminArea_PublishersRatesDeliveryTypes` FOREIGN KEY (`IdAdminArea`) REFERENCES `adminareas` (`ID`) ON UPDATE CASCADE, CONSTRAINT `FK_DeliveryType_PublishersRatesDeliveryTypes` FOREIGN KEY (`IdDeliveryType`) REFERENCES `deliverytypes` (`ID`), CONSTRAINT `FK_PackageType_PublishersRatesDeliveryTypes` FOREIGN KEY (`IdPackageType`) REFERENCES `packagetypes` (`ID`), CONSTRAINT `FK_PublisherRate_PublishersRatesDeliveryTypes` FOREIGN KEY (`IdPublisherRate`) REFERENCES `publishersrates` (`ID`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `PublishersRatesExtraTypes` -- DROP TABLE IF EXISTS `PublishersRatesExtraTypes`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `PublishersRatesExtraTypes` ( `ID` varchar(38) NOT NULL, `IdPublisherRate` varchar(38) NOT NULL, `IdExtraType` int(11) DEFAULT NULL, `ExtraValue` decimal(19,4) DEFAULT NULL, `LastUpdate` datetime NOT NULL, `Version` int(11) NOT NULL, `ChangeType` varchar(5) NOT NULL DEFAULT '€', PRIMARY KEY (`ID`), UNIQUE KEY `UK_PublishersRatesExtraTypes` (`IdPublisherRate`,`IdExtraType`), KEY `FK_ExtraType_PublishersRatesExtraTypes_idx` (`IdExtraType`), KEY `FK_PublishersRates_PublishersRatesExtraTypes_idx` (`IdPublisherRate`), CONSTRAINT `FK_ExtraType_PublishersRatesExtraTypes` FOREIGN KEY (`IdExtraType`) REFERENCES `extratypes` (`ID`) ON DELETE CASCADE, CONSTRAINT `FK_PublishersRates_PublishersRatesExtraTypes` FOREIGN KEY (`IdPublisherRate`) REFERENCES `publishersrates` (`ID`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `PublishersReceivers` -- DROP TABLE IF EXISTS `PublishersReceivers`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `PublishersReceivers` ( `ID` varchar(38) NOT NULL, `IdPublisher` varchar(38) NOT NULL, `ReceiverName` varchar(50) DEFAULT NULL, `ReceiverAddress` varchar(50) DEFAULT NULL, `ReceiverZipCode` varchar(6) DEFAULT NULL, `ReceiverCity` varchar(50) DEFAULT NULL, `ReceiverProvince` varchar(250) DEFAULT NULL, `ReceiverGroupCode` varchar(50) DEFAULT NULL, `LastUpdate` datetime NOT NULL, `Version` int(11) NOT NULL, PRIMARY KEY (`ID`), UNIQUE KEY `Code` (`ReceiverName`,`ReceiverAddress`,`ReceiverZipCode`,`ReceiverCity`,`ReceiverProvince`), KEY `IDX_Code` (`IdPublisher`,`ReceiverName`,`ReceiverAddress`,`ReceiverZipCode`,`ReceiverCity`,`ReceiverProvince`), KEY `FK_Publisher_Receivers_idx` (`IdPublisher`), CONSTRAINT `FK_Publisher_Receivers` FOREIGN KEY (`IdPublisher`) REFERENCES `publishers` (`ID`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `PublishersSenders` -- DROP TABLE IF EXISTS `PublishersSenders`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `PublishersSenders` ( `ID` varchar(38) NOT NULL, `IdPublisher` varchar(38) NOT NULL, `Code` varchar(50) NOT NULL, `ImportReferenceCodes` varchar(250) DEFAULT NULL, `Name` varchar(255) DEFAULT NULL, `Note` longtext, `IdDefaultPackageType` int(11) DEFAULT NULL, `PackListImportType` varchar(255) DEFAULT NULL, `LastUpdate` datetime NOT NULL, `Version` int(11) NOT NULL, `ReferenceTemplate` varchar(2000) DEFAULT NULL, `OnlyProvinces` varchar(2000) DEFAULT NULL, `Address` varchar(50) DEFAULT NULL, `ZipCode` varchar(6) DEFAULT NULL, `City` varchar(50) DEFAULT NULL, `Province` varchar(250) DEFAULT NULL, `Contacts` varchar(250) DEFAULT NULL, `Group` varchar(255) DEFAULT NULL, `RequireUnload` tinyint(1) DEFAULT NULL, `RequirePerBoxReply` tinyint(1) DEFAULT NULL, `RequireETA` tinyint(1) DEFAULT NULL, `Tag` varchar(100) DEFAULT NULL, PRIMARY KEY (`ID`), UNIQUE KEY `Code_UNIQUE` (`IdPublisher`,`Code`), KEY `FK_Publisher_Senders_idx` (`IdPublisher`), KEY `FK_PackageTypes_Senders_idx` (`IdDefaultPackageType`), CONSTRAINT `FK_PackageTypes_Senders` FOREIGN KEY (`IdDefaultPackageType`) REFERENCES `packagetypes` (`ID`), CONSTRAINT `FK_Publisher_Senders` FOREIGN KEY (`IdPublisher`) REFERENCES `publishers` (`ID`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 PACK_KEYS=0 ROW_FORMAT=COMPACT; /*!40101 SET character_set_client = @saved_cs_client */; ALTER DATABASE `Waspnet_Courier` CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci ; /*!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 = utf8mb4 */ ; /*!50003 SET character_set_results = utf8mb4 */ ; /*!50003 SET collation_connection = utf8mb4_0900_ai_ci */ ; /*!50003 SET @saved_sql_mode = @@sql_mode */ ; /*!50003 SET sql_mode = 'STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION' */ ; DELIMITER ;; /*!50003 CREATE*/ /*!50017 DEFINER=`waspnet`@`%`*/ /*!50003 TRIGGER `PublishersSenders_AFTER_INSERT` AFTER INSERT ON `publisherssenders` FOR EACH ROW BEGIN INSERT INTO `PublishersSenders_History` (`ID`, `IdPublisher`, `Code`, `ImportReferenceCodes`, `Name`, `Note`, `IdDefaultPackageType`, `PackListImportType`, `LastUpdate`, `Version`, `ReferenceTemplate`, `OnlyProvinces`, `Address`, `ZipCode`, `City`, `Province`, `Contacts`, `Group`, `RequirePerBoxReply`, `RequireUnload` ) VALUES ( new.`ID`, new.`IdPublisher`, new.`Code`, new.`ImportReferenceCodes`, new.`Name`, new.`Note`, new.`IdDefaultPackageType`, new.`PackListImportType`, new.`LastUpdate`, new.`Version`, new.`ReferenceTemplate`, new.`OnlyProvinces`, new.`Address`, new.`ZipCode`, new.`City`, new.`Province`, new.`Contacts`, new.`Group`, new.`RequirePerBoxReply`, new.`RequireUnload` ); 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 */ ; ALTER DATABASE `Waspnet_Courier` CHARACTER SET utf8 COLLATE utf8_bin ; ALTER DATABASE `Waspnet_Courier` CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci ; /*!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 = utf8mb4 */ ; /*!50003 SET character_set_results = utf8mb4 */ ; /*!50003 SET collation_connection = utf8mb4_0900_ai_ci */ ; /*!50003 SET @saved_sql_mode = @@sql_mode */ ; /*!50003 SET sql_mode = 'STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION' */ ; DELIMITER ;; /*!50003 CREATE*/ /*!50017 DEFINER=`waspnet`@`%`*/ /*!50003 TRIGGER `PublishersSenders_AFTER_UPDATE` AFTER UPDATE ON `publisherssenders` FOR EACH ROW BEGIN INSERT INTO `PublishersSenders_History` (`ID`, `IdPublisher`, `Code`, `ImportReferenceCodes`, `Name`, `Note`, `IdDefaultPackageType`, `PackListImportType`, `LastUpdate`, `Version`, `ReferenceTemplate`, `OnlyProvinces`, `Address`, `ZipCode`, `City`, `Province`, `Contacts`, `Group`, `RequirePerBoxReply`, `RequireUnload` ) VALUES ( new.`ID`, new.`IdPublisher`, new.`Code`, new.`ImportReferenceCodes`, new.`Name`, new.`Note`, new.`IdDefaultPackageType`, new.`PackListImportType`, new.`LastUpdate`, new.`Version`, new.`ReferenceTemplate`, new.`OnlyProvinces`, new.`Address`, new.`ZipCode`, new.`City`, new.`Province`, new.`Contacts`, new.`Group`, new.`RequirePerBoxReply`, new.`RequireUnload` ); 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 */ ; ALTER DATABASE `Waspnet_Courier` CHARACTER SET utf8 COLLATE utf8_bin ; -- -- Table structure for table `PublishersSenders_History` -- DROP TABLE IF EXISTS `PublishersSenders_History`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `PublishersSenders_History` ( `HistorizationNumber` bigint(20) NOT NULL AUTO_INCREMENT, `ID` varchar(38) NOT NULL, `IdPublisher` varchar(38) NOT NULL, `Code` varchar(50) NOT NULL, `ImportReferenceCodes` varchar(250) DEFAULT NULL, `Name` varchar(255) DEFAULT NULL, `Note` longtext, `IdDefaultPackageType` int(11) DEFAULT NULL, `PackListImportType` varchar(255) DEFAULT NULL, `LastUpdate` datetime NOT NULL, `Version` int(11) NOT NULL, `ReferenceTemplate` varchar(2000) DEFAULT NULL, `OnlyProvinces` varchar(2000) DEFAULT NULL, `Address` varchar(50) DEFAULT NULL, `ZipCode` varchar(6) DEFAULT NULL, `City` varchar(50) DEFAULT NULL, `Province` varchar(250) DEFAULT NULL, `Contacts` varchar(250) DEFAULT NULL, `IdSynchronizationSession` varchar(38) DEFAULT NULL, `SynchronizationDate` datetime DEFAULT NULL, `Group` varchar(255) DEFAULT NULL, `RequireUnload` tinyint(1) DEFAULT NULL, `RequirePerBoxReply` tinyint(1) DEFAULT NULL, `RequireETA` tinyint(1) DEFAULT NULL, `Tag` varchar(100) DEFAULT NULL, PRIMARY KEY (`HistorizationNumber`), KEY `IDX_ID_Session` (`ID`,`IdSynchronizationSession`), KEY `IDX_SyncSession` (`IdSynchronizationSession`,`SynchronizationDate`), KEY `IDX_ID_History` (`ID`,`HistorizationNumber`), KEY `IDX_MaxHistory` (`IdSynchronizationSession`,`HistorizationNumber`) ) ENGINE=InnoDB AUTO_INCREMENT=1159 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `PublishersSendersDeliveryDateCodes` -- DROP TABLE IF EXISTS `PublishersSendersDeliveryDateCodes`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `PublishersSendersDeliveryDateCodes` ( `ID` varchar(38) NOT NULL, `IdPublisher` varchar(38) NOT NULL, `IdPublisherSender` varchar(38) DEFAULT NULL, `IdDeliveryDateCode` varchar(38) NOT NULL, `Code` varchar(50) DEFAULT NULL, `Description` longtext, `NotesRequired` tinyint(1) NOT NULL DEFAULT '0', `Send` tinyint(1) NOT NULL DEFAULT '0', `LastUpdate` datetime NOT NULL, `Version` int(11) NOT NULL, PRIMARY KEY (`ID`), KEY `fk_PublishersSendersDeliveryDateCodes_publisher_idx` (`IdPublisher`), KEY `fk_PublishersSendersDeliveryDateCodes_publisherSender_idx` (`IdPublisherSender`), KEY `fk_PublishersSendersDeliveryDateCodes_deliveryDateCode_idx` (`IdDeliveryDateCode`), CONSTRAINT `fk_PublishersSendersDeliveryDateCodes_deliveryDateCode` FOREIGN KEY (`IdDeliveryDateCode`) REFERENCES `deliverydatecodes` (`ID`), CONSTRAINT `fk_PublishersSendersDeliveryDateCodes_publisher` FOREIGN KEY (`IdPublisher`) REFERENCES `publishers` (`ID`) ON DELETE CASCADE, CONSTRAINT `fk_PublishersSendersDeliveryDateCodes_publisherSender` FOREIGN KEY (`IdPublisherSender`) REFERENCES `publisherssenders` (`ID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `PublishersSendersPackageSubStatus` -- DROP TABLE IF EXISTS `PublishersSendersPackageSubStatus`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `PublishersSendersPackageSubStatus` ( `ID` varchar(38) NOT NULL, `IdPublisher` varchar(38) NOT NULL, `IdPublisherSender` varchar(38) DEFAULT NULL, `IdPackageSubStatus` varchar(38) NOT NULL, `Code` varchar(50) DEFAULT NULL, `Description` longtext, `Send` tinyint(1) NOT NULL DEFAULT '0', `IsPodImageRequired` tinyint(1) NOT NULL DEFAULT '0', `IsPerBoxReplyRequired` tinyint(1) NOT NULL DEFAULT '0', `IsReceiverSignRequired` tinyint(1) NOT NULL DEFAULT '0', `AreNotesRequired` tinyint(1) NOT NULL DEFAULT '0', `ExportEventClosingStatus` bit(1) NOT NULL DEFAULT b'0', `AddPendingTransmission` tinyint(1) NOT NULL DEFAULT '0', `LastUpdate` datetime NOT NULL, `Version` int(11) NOT NULL, PRIMARY KEY (`ID`), KEY `fk_PublishersSendersPackageSubStatus_publisher_idx` (`IdPublisher`), KEY `fk_PublishersSendersPackageSubStatus_publisherSender_idx` (`IdPublisherSender`), KEY `fk_PublishersSendersPackageSubStatus_subStatus_idx` (`IdPackageSubStatus`), CONSTRAINT `fk_PublishersSendersPackageSubStatus_publisher` FOREIGN KEY (`IdPublisher`) REFERENCES `publishers` (`ID`) ON DELETE CASCADE ON UPDATE RESTRICT, CONSTRAINT `fk_PublishersSendersPackageSubStatus_publisherSender` FOREIGN KEY (`IdPublisherSender`) REFERENCES `publisherssenders` (`ID`) ON DELETE CASCADE ON UPDATE RESTRICT, CONSTRAINT `fk_PublishersSendersPackageSubStatus_subStatus` FOREIGN KEY (`IdPackageSubStatus`) REFERENCES `packagesubstatus` (`ID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; ALTER DATABASE `Waspnet_Courier` CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci ; /*!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 = utf8mb4 */ ; /*!50003 SET character_set_results = utf8mb4 */ ; /*!50003 SET collation_connection = utf8mb4_0900_ai_ci */ ; /*!50003 SET @saved_sql_mode = @@sql_mode */ ; /*!50003 SET sql_mode = 'STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION' */ ; DELIMITER ;; /*!50003 CREATE*/ /*!50017 DEFINER=`waspnet`@`%`*/ /*!50003 TRIGGER `PublishersSendersPackageSubStatus_AFTER_INSERT` AFTER INSERT ON `publisherssenderspackagesubstatus` FOR EACH ROW BEGIN INSERT INTO `PublishersSendersPackageSubStatus_History` (`ID`, `IdPublisher`, `IdPublisherSender`, `IdPackageSubStatus`, `Code`, `Description`, `Send`, `IsPodImageRequired`, `IsPerBoxReplyRequired`, `IsReceiverSignRequired`, `AreNotesRequired`, `ExportEventClosingStatus`, `LastUpdate`, `Version`) VALUES (new.`ID`, new.`IdPublisher`, new.`IdPublisherSender`, new.`IdPackageSubStatus`, new.`Code`, new.`Description`, new.`Send`, new.`IsPodImageRequired`, new.`IsPerBoxReplyRequired`, new.`IsReceiverSignRequired`, new.`AreNotesRequired`, new.`ExportEventClosingStatus`, new.`LastUpdate`, new.`Version`); 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 */ ; ALTER DATABASE `Waspnet_Courier` CHARACTER SET utf8 COLLATE utf8_bin ; ALTER DATABASE `Waspnet_Courier` CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci ; /*!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 = utf8mb4 */ ; /*!50003 SET character_set_results = utf8mb4 */ ; /*!50003 SET collation_connection = utf8mb4_0900_ai_ci */ ; /*!50003 SET @saved_sql_mode = @@sql_mode */ ; /*!50003 SET sql_mode = 'STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION' */ ; DELIMITER ;; /*!50003 CREATE*/ /*!50017 DEFINER=`waspnet`@`%`*/ /*!50003 TRIGGER `PublishersSendersPackageSubStatus_AFTER_UPDATE` AFTER UPDATE ON `publisherssenderspackagesubstatus` FOR EACH ROW BEGIN INSERT INTO `PublishersSendersPackageSubStatus_History` (`ID`, `IdPublisher`, `IdPublisherSender`, `IdPackageSubStatus`, `Code`, `Description`, `Send`, `IsPodImageRequired`, `IsPerBoxReplyRequired`, `IsReceiverSignRequired`, `AreNotesRequired`, `ExportEventClosingStatus`, `LastUpdate`, `Version`) VALUES (new.`ID`, new.`IdPublisher`, new.`IdPublisherSender`, new.`IdPackageSubStatus`, new.`Code`, new.`Description`, new.`Send`, new.`IsPodImageRequired`, new.`IsPerBoxReplyRequired`, new.`IsReceiverSignRequired`, new.`AreNotesRequired`, new.`ExportEventClosingStatus`, new.`LastUpdate`, new.`Version`); 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 */ ; ALTER DATABASE `Waspnet_Courier` CHARACTER SET utf8 COLLATE utf8_bin ; -- -- Table structure for table `PublishersSendersPackageSubStatus_History` -- DROP TABLE IF EXISTS `PublishersSendersPackageSubStatus_History`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `PublishersSendersPackageSubStatus_History` ( `HistorizationNumber` bigint(20) NOT NULL AUTO_INCREMENT, `ID` varchar(38) NOT NULL, `IdPublisher` varchar(38) NOT NULL, `IdPublisherSender` varchar(38) DEFAULT NULL, `IdPackageSubStatus` varchar(38) NOT NULL, `Code` varchar(50) DEFAULT NULL, `Description` longtext, `Send` tinyint(1) NOT NULL DEFAULT '0', `IsPodImageRequired` tinyint(1) NOT NULL DEFAULT '0', `IsPerBoxReplyRequired` tinyint(1) NOT NULL DEFAULT '0', `IsReceiverSignRequired` tinyint(1) NOT NULL DEFAULT '0', `AreNotesRequired` tinyint(1) NOT NULL DEFAULT '0', `ExportEventClosingStatus` bit(1) NOT NULL DEFAULT b'0', `LastUpdate` datetime NOT NULL, `Version` int(11) NOT NULL, `IdSynchronizationSession` varchar(38) DEFAULT NULL, `SynchronizationDate` datetime DEFAULT NULL, `AddPendingTransmission` tinyint(1) NOT NULL DEFAULT '0', PRIMARY KEY (`HistorizationNumber`), KEY `IDX_ID_Session` (`ID`,`IdSynchronizationSession`), KEY `IDX_SyncSession` (`IdSynchronizationSession`,`SynchronizationDate`), KEY `IDX_ID_History` (`ID`,`HistorizationNumber`), KEY `IDX_MaxHistory` (`IdSynchronizationSession`,`HistorizationNumber`) ) ENGINE=InnoDB AUTO_INCREMENT=1676 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `ReturnedPackages` -- DROP TABLE IF EXISTS `ReturnedPackages`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `ReturnedPackages` ( `ID` varchar(38) NOT NULL, `IdReturnedPackList` varchar(38) DEFAULT NULL, `IdPackage` varchar(38) NOT NULL, `LastUpdate` datetime NOT NULL, `Version` int(11) NOT NULL, PRIMARY KEY (`ID`), KEY `FK_ReturnedPackList_ReturnedPackages_idx` (`IdReturnedPackList`), KEY `FK_Package_ReturnedPackages_idx` (`IdPackage`), CONSTRAINT `FK_Package_ReturnedPackages` FOREIGN KEY (`IdPackage`) REFERENCES `packages` (`ID`) ON DELETE CASCADE, CONSTRAINT `FK_ReturnedPackList_ReturnedPackages` FOREIGN KEY (`IdReturnedPackList`) REFERENCES `returnedpacklists` (`ID`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `ReturnedPackLists` -- DROP TABLE IF EXISTS `ReturnedPackLists`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `ReturnedPackLists` ( `ID` varchar(38) NOT NULL, `Number` int(11) NOT NULL, `Date` datetime NOT NULL, `IdPublisher` varchar(38) NOT NULL, `LastUpdate` datetime NOT NULL, `Version` int(11) NOT NULL, PRIMARY KEY (`ID`), KEY `Date` (`Date`), KEY `Number` (`Number`), KEY `FK_Publisher_ReturnedPackLists_idx` (`IdPublisher`), CONSTRAINT `FK_Publisher_ReturnedPackLists` FOREIGN KEY (`IdPublisher`) REFERENCES `publishers` (`ID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `SupplierCreditNoteDetails` -- DROP TABLE IF EXISTS `SupplierCreditNoteDetails`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `SupplierCreditNoteDetails` ( `ID` varchar(38) NOT NULL, `IdSupplierCreditNote` varchar(38) NOT NULL, `Code` varchar(50) DEFAULT NULL, `Description` longtext, `IdTaxType` varchar(38) NOT NULL, `UnitAmount` decimal(19,8) DEFAULT NULL, `FixedAmount` decimal(19,8) DEFAULT NULL, `Quantity` decimal(19,8) DEFAULT NULL, `UnitType` varchar(50) DEFAULT NULL, `DiscountPerc_01` decimal(19,8) DEFAULT NULL, `DiscountPerc_02` decimal(19,8) DEFAULT NULL, `DiscountPerc_03` decimal(19,8) DEFAULT NULL, `DiscountVal` decimal(19,8) DEFAULT NULL, `LastUpdate` datetime NOT NULL, `Version` int(11) NOT NULL, `RowAmount` decimal(19,8) NOT NULL, `TaxAmount` decimal(19,8) NOT NULL, `DetailGroup` varchar(100) DEFAULT NULL, `IdPackage` varchar(38) DEFAULT NULL, PRIMARY KEY (`ID`), KEY `SupplierCreditNoteDetail_SupplierCreditNote` (`IdSupplierCreditNote`), KEY `FK_SupplierCreditNoteDetail_TaxType` (`IdTaxType`), KEY `FK_SupplierCreditNoteDetail_Package_idx` (`IdPackage`), CONSTRAINT `FK_SupplierCreditNoteDetail_Package` FOREIGN KEY (`IdPackage`) REFERENCES `packages` (`ID`), CONSTRAINT `FK_SupplierCreditNoteDetail_SupplierCreditNote` FOREIGN KEY (`IdSupplierCreditNote`) REFERENCES `suppliercreditnotes` (`ID`) ON DELETE CASCADE, CONSTRAINT `FK_SupplierCreditNoteDetail_TaxType` FOREIGN KEY (`IdTaxType`) REFERENCES `taxtypes` (`ID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `SupplierCreditNotes` -- DROP TABLE IF EXISTS `SupplierCreditNotes`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `SupplierCreditNotes` ( `ID` varchar(38) NOT NULL, `DocumentType` varchar(50) DEFAULT NULL, `Number` varchar(50) NOT NULL, `Date` datetime NOT NULL, `IdPublisher` varchar(38) DEFAULT NULL, `IdTaxType` varchar(38) NOT NULL, `IdPaymentType` varchar(38) NOT NULL, `DiscountPerc_01` decimal(19,8) NOT NULL DEFAULT '0.00000000', `DiscountPerc_02` decimal(19,8) NOT NULL DEFAULT '0.00000000', `DiscountPerc_03` decimal(19,8) NOT NULL DEFAULT '0.00000000', `DiscountVal` decimal(19,8) NOT NULL DEFAULT '0.00000000', `FixedCost` decimal(19,8) NOT NULL DEFAULT '0.00000000', `BoxCost` decimal(19,8) NOT NULL DEFAULT '0.00000000', `TransportCost` decimal(19,8) NOT NULL DEFAULT '0.00000000', `TransportNote` longtext, `Note` longtext, `LastUpdate` datetime NOT NULL, `Version` int(11) NOT NULL, `PrePaymentAmount` decimal(19,4) DEFAULT NULL, `TotalAmount` decimal(19,8) DEFAULT NULL, `TaxAmount` decimal(19,8) DEFAULT NULL, `Status` varchar(50) DEFAULT NULL, PRIMARY KEY (`ID`), UNIQUE KEY `Number` (`IdPublisher`,`Number`), KEY `FK_SupplierCreditNote_Publisher` (`IdPublisher`), KEY `FK_SupplierCreditNote_TaxType` (`IdTaxType`), KEY `FK_SupplierCreditNote_PaymentType` (`IdPaymentType`), CONSTRAINT `FK_SupplierCreditNote_PaymentType` FOREIGN KEY (`IdPaymentType`) REFERENCES `paymenttypes` (`ID`), CONSTRAINT `FK_SupplierCreditNote_Publisher` FOREIGN KEY (`IdPublisher`) REFERENCES `publishers` (`ID`), CONSTRAINT `FK_SupplierCreditNote_TaxType` FOREIGN KEY (`IdTaxType`) REFERENCES `taxtypes` (`ID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `SupplierDebitNoteDetails` -- DROP TABLE IF EXISTS `SupplierDebitNoteDetails`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `SupplierDebitNoteDetails` ( `ID` varchar(38) NOT NULL, `IdSupplierDebitNote` varchar(38) NOT NULL, `Code` varchar(50) DEFAULT NULL, `Description` longtext, `IdTaxType` varchar(38) NOT NULL, `UnitAmount` decimal(19,8) DEFAULT NULL, `FixedAmount` decimal(19,8) DEFAULT NULL, `Quantity` decimal(19,8) DEFAULT NULL, `UnitType` varchar(50) DEFAULT NULL, `DiscountPerc_01` decimal(19,8) DEFAULT NULL, `DiscountPerc_02` decimal(19,8) DEFAULT NULL, `DiscountPerc_03` decimal(19,8) DEFAULT NULL, `DiscountVal` decimal(19,8) DEFAULT NULL, `LastUpdate` datetime NOT NULL, `Version` int(11) NOT NULL, `RowAmount` decimal(19,8) NOT NULL, `TaxAmount` decimal(19,8) NOT NULL, `DetailGroup` varchar(100) DEFAULT NULL, `IdPackage` varchar(38) DEFAULT NULL, PRIMARY KEY (`ID`), KEY `SupplierDebitNoteDetail_SupplierDebitNote` (`IdSupplierDebitNote`), KEY `FK_SupplierDebitNoteDetail_TaxType` (`IdTaxType`), KEY `FK_SupplierDebitNoteDetail_Package_idx` (`IdPackage`), CONSTRAINT `FK_SupplierDebitNoteDetail_Package` FOREIGN KEY (`IdPackage`) REFERENCES `packages` (`ID`), CONSTRAINT `FK_SupplierDebitNoteDetail_SupplierDebitNote` FOREIGN KEY (`IdSupplierDebitNote`) REFERENCES `supplierdebitnotes` (`ID`) ON DELETE CASCADE, CONSTRAINT `FK_SupplierDebitNoteDetail_TaxType` FOREIGN KEY (`IdTaxType`) REFERENCES `taxtypes` (`ID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `SupplierDebitNotes` -- DROP TABLE IF EXISTS `SupplierDebitNotes`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `SupplierDebitNotes` ( `ID` varchar(38) NOT NULL, `DocumentType` varchar(50) DEFAULT NULL, `Number` varchar(50) NOT NULL, `Date` datetime NOT NULL, `IdPublisher` varchar(38) DEFAULT NULL, `IdTaxType` varchar(38) NOT NULL, `IdPaymentType` varchar(38) NOT NULL, `DiscountPerc_01` decimal(19,8) NOT NULL DEFAULT '0.00000000', `DiscountPerc_02` decimal(19,8) NOT NULL DEFAULT '0.00000000', `DiscountPerc_03` decimal(19,8) NOT NULL DEFAULT '0.00000000', `DiscountVal` decimal(19,8) NOT NULL DEFAULT '0.00000000', `FixedCost` decimal(19,8) NOT NULL DEFAULT '0.00000000', `BoxCost` decimal(19,8) NOT NULL DEFAULT '0.00000000', `TransportCost` decimal(19,8) NOT NULL DEFAULT '0.00000000', `TransportNote` longtext, `Note` longtext, `LastUpdate` datetime NOT NULL, `Version` int(11) NOT NULL, `PrePaymentAmount` decimal(19,4) DEFAULT NULL, `TotalAmount` decimal(19,8) DEFAULT NULL, `TaxAmount` decimal(19,8) DEFAULT NULL, `Status` varchar(50) DEFAULT NULL, PRIMARY KEY (`ID`), UNIQUE KEY `Number` (`IdPublisher`,`Number`), KEY `FK_SupplierDebitNote_Publisher` (`IdPublisher`), KEY `FK_SupplierDebitNote_TaxType` (`IdTaxType`), KEY `FK_SupplierDebitNote_PaymentType` (`IdPaymentType`), CONSTRAINT `FK_SupplierDebitNote_PaymentType` FOREIGN KEY (`IdPaymentType`) REFERENCES `paymenttypes` (`ID`), CONSTRAINT `FK_SupplierDebitNote_Publisher` FOREIGN KEY (`IdPublisher`) REFERENCES `publishers` (`ID`), CONSTRAINT `FK_SupplierDebitNote_TaxType` FOREIGN KEY (`IdTaxType`) REFERENCES `taxtypes` (`ID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `SupplierInvoiceDetails` -- DROP TABLE IF EXISTS `SupplierInvoiceDetails`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `SupplierInvoiceDetails` ( `ID` varchar(38) NOT NULL, `IdSupplierInvoice` varchar(38) NOT NULL, `Code` varchar(50) DEFAULT NULL, `Description` longtext, `IdTaxType` varchar(38) NOT NULL, `UnitAmount` decimal(19,8) DEFAULT NULL, `FixedAmount` decimal(19,8) DEFAULT NULL, `Quantity` decimal(19,8) DEFAULT NULL, `UnitType` varchar(50) DEFAULT NULL, `DiscountPerc_01` decimal(19,8) DEFAULT NULL, `DiscountPerc_02` decimal(19,8) DEFAULT NULL, `DiscountPerc_03` decimal(19,8) DEFAULT NULL, `DiscountVal` decimal(19,8) DEFAULT NULL, `LastUpdate` datetime NOT NULL, `Version` int(11) NOT NULL, `RowAmount` decimal(19,8) NOT NULL, `TaxAmount` decimal(19,8) NOT NULL, `DetailGroup` varchar(100) DEFAULT NULL, `IdPackage` varchar(38) DEFAULT NULL, PRIMARY KEY (`ID`), KEY `SupplierInvoiceDetail_SupplierInvoice` (`IdSupplierInvoice`), KEY `FK_SupplierInvoiceDetail_TaxType` (`IdTaxType`), KEY `FK_SupplierInvoiceDetail_Package_idx` (`IdPackage`), CONSTRAINT `FK_SupplierInvoiceDetail_Package` FOREIGN KEY (`IdPackage`) REFERENCES `packages` (`ID`), CONSTRAINT `FK_SupplierInvoiceDetail_SupplierInvoice` FOREIGN KEY (`IdSupplierInvoice`) REFERENCES `supplierinvoices` (`ID`) ON DELETE CASCADE, CONSTRAINT `FK_SupplierInvoiceDetail_TaxType` FOREIGN KEY (`IdTaxType`) REFERENCES `taxtypes` (`ID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `SupplierInvoices` -- DROP TABLE IF EXISTS `SupplierInvoices`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `SupplierInvoices` ( `ID` varchar(38) NOT NULL, `DocumentType` varchar(50) DEFAULT NULL, `Number` varchar(50) NOT NULL, `Date` datetime NOT NULL, `IdPublisher` varchar(38) DEFAULT NULL, `IdTaxType` varchar(38) NOT NULL, `IdPaymentType` varchar(38) NOT NULL, `DiscountPerc_01` decimal(19,8) NOT NULL DEFAULT '0.00000000', `DiscountPerc_02` decimal(19,8) NOT NULL DEFAULT '0.00000000', `DiscountPerc_03` decimal(19,8) NOT NULL DEFAULT '0.00000000', `DiscountVal` decimal(19,8) NOT NULL DEFAULT '0.00000000', `FixedCost` decimal(19,8) NOT NULL DEFAULT '0.00000000', `BoxCost` decimal(19,8) NOT NULL DEFAULT '0.00000000', `TransportCost` decimal(19,8) NOT NULL DEFAULT '0.00000000', `TransportNote` longtext, `Note` longtext, `LastUpdate` datetime NOT NULL, `Version` int(11) NOT NULL, `PrePaymentAmount` decimal(19,4) DEFAULT NULL, `TotalAmount` decimal(19,8) DEFAULT NULL, `TaxAmount` decimal(19,8) DEFAULT NULL, `Status` varchar(50) DEFAULT NULL, PRIMARY KEY (`ID`), UNIQUE KEY `Number` (`IdPublisher`,`Number`), KEY `FK_SupplierInvoice_Publisher` (`IdPublisher`), KEY `FK_SupplierInvoice_TaxType` (`IdTaxType`), KEY `FK_SupplierInvoice_PaymentType` (`IdPaymentType`), CONSTRAINT `FK_SupplierInvoice_PaymentType` FOREIGN KEY (`IdPaymentType`) REFERENCES `paymenttypes` (`ID`), CONSTRAINT `FK_SupplierInvoice_Publisher` FOREIGN KEY (`IdPublisher`) REFERENCES `publishers` (`ID`), CONSTRAINT `FK_SupplierInvoice_TaxType` FOREIGN KEY (`IdTaxType`) REFERENCES `taxtypes` (`ID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `TaxTypes` -- DROP TABLE IF EXISTS `TaxTypes`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `TaxTypes` ( `ID` varchar(38) NOT NULL, `Code` varchar(10) NOT NULL, `Description` varchar(50) NOT NULL, `Tax` decimal(19,4) NOT NULL DEFAULT '0.0000', `IsDefault` tinyint(1) DEFAULT '0', `Note` longtext, `GC_Code` varchar(50) DEFAULT '0', `SortOrder` int(11) DEFAULT NULL, `LastUpdate` datetime NOT NULL, `Version` int(11) NOT NULL, PRIMARY KEY (`ID`), UNIQUE KEY `Code` (`Code`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `Transporters` -- DROP TABLE IF EXISTS `Transporters`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `Transporters` ( `ID` varchar(38) NOT NULL, `Code` varchar(10) DEFAULT NULL, `Name` varchar(50) DEFAULT NULL, `EMail` varchar(255) DEFAULT NULL, `Phone` varchar(255) DEFAULT NULL, `PackListExportType` varchar(255) DEFAULT NULL, `RepliesImportType` varchar(255) DEFAULT NULL, `AutoReplyDays` int(11) DEFAULT '0', `Note` longtext, `Deleted` tinyint(1) DEFAULT '0', `LastUpdate` datetime NOT NULL, `Version` int(11) NOT NULL, `IsDriver` tinyint(1) DEFAULT '0', `IsExcludedFromInvoice` tinyint(1) DEFAULT '0', `SynchronizeOnCash` tinyint(1) DEFAULT '0', `IsXpPartner` tinyint(1) DEFAULT '0', `Address` varchar(250) DEFAULT NULL, `City` varchar(50) DEFAULT NULL, `ZipCode` varchar(5) DEFAULT NULL, `Country` varchar(2) DEFAULT NULL, `State` varchar(3) DEFAULT NULL, `Register` varchar(250) DEFAULT NULL, `PIva` varchar(13) DEFAULT NULL, `CF` varchar(16) DEFAULT NULL, PRIMARY KEY (`ID`), UNIQUE KEY `Code` (`Code`), KEY `IDX_Transp_OutPackList` (`ID`,`Code`,`Name`,`Register`,`PIva`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; ALTER DATABASE `Waspnet_Courier` CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci ; /*!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 = utf8mb4 */ ; /*!50003 SET character_set_results = utf8mb4 */ ; /*!50003 SET collation_connection = utf8mb4_0900_ai_ci */ ; /*!50003 SET @saved_sql_mode = @@sql_mode */ ; /*!50003 SET sql_mode = 'STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION' */ ; DELIMITER ;; /*!50003 CREATE*/ /*!50017 DEFINER=`waspnet`@`%`*/ /*!50003 TRIGGER `Transporters_AFTER_INSERT` AFTER INSERT ON `transporters` FOR EACH ROW BEGIN INSERT INTO `Transporters_History` (`ID`, `Code`, `Name`, `EMail`, `Phone`, `PackListExportType`, `RepliesImportType`, `AutoReplyDays`, `Note`, `Deleted`, `LastUpdate`, `Version`, `IsDriver`, `IsExcludedFromInvoice`, `SynchronizeOnCash`, `IsXpPartner`, `Address`, `City`, `ZipCode`, `Country`, `State`, `Register`, `PIva`, `CF`) VALUES (new.`ID`, new.`Code`, new.`Name`, new.`EMail`, new.`Phone`, new.`PackListExportType`, new.`RepliesImportType`, new.`AutoReplyDays`, new.`Note`, new.`Deleted`, new.`LastUpdate`, new.`Version`, new.`IsDriver`, new.`IsExcludedFromInvoice`, new.`SynchronizeOnCash`, new.`IsXpPartner`, new.`Address`, new.`City`, new.`ZipCode`, new.`Country`, new.`State`, new.`Register`, new.`PIva`, new.`CF`); 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 */ ; ALTER DATABASE `Waspnet_Courier` CHARACTER SET utf8 COLLATE utf8_bin ; ALTER DATABASE `Waspnet_Courier` CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci ; /*!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 = utf8mb4 */ ; /*!50003 SET character_set_results = utf8mb4 */ ; /*!50003 SET collation_connection = utf8mb4_0900_ai_ci */ ; /*!50003 SET @saved_sql_mode = @@sql_mode */ ; /*!50003 SET sql_mode = 'STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION' */ ; DELIMITER ;; /*!50003 CREATE*/ /*!50017 DEFINER=`waspnet`@`%`*/ /*!50003 TRIGGER `Transporters_AFTER_UPDATE` AFTER UPDATE ON `transporters` FOR EACH ROW BEGIN INSERT INTO `Transporters_History` (`ID`, `Code`, `Name`, `EMail`, `Phone`, `PackListExportType`, `RepliesImportType`, `AutoReplyDays`, `Note`, `Deleted`, `LastUpdate`, `Version`, `IsDriver`, `IsExcludedFromInvoice`, `SynchronizeOnCash`, `IsXpPartner`, `Address`, `City`, `ZipCode`, `Country`, `State`, `Register`, `PIva`, `CF`) VALUES (new.`ID`, new.`Code`, new.`Name`, new.`EMail`, new.`Phone`, new.`PackListExportType`, new.`RepliesImportType`, new.`AutoReplyDays`, new.`Note`, new.`Deleted`, new.`LastUpdate`, new.`Version`, new.`IsDriver`, new.`IsExcludedFromInvoice`, new.`SynchronizeOnCash`, new.`IsXpPartner`, new.`Address`, new.`City`, new.`ZipCode`, new.`Country`, new.`State`, new.`Register`, new.`PIva`, new.`CF`); 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 */ ; ALTER DATABASE `Waspnet_Courier` CHARACTER SET utf8 COLLATE utf8_bin ; -- -- Table structure for table `Transporters_History` -- DROP TABLE IF EXISTS `Transporters_History`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `Transporters_History` ( `HistorizationNumber` bigint(20) NOT NULL AUTO_INCREMENT, `ID` varchar(38) NOT NULL, `Code` varchar(10) DEFAULT NULL, `Name` varchar(50) DEFAULT NULL, `EMail` varchar(255) DEFAULT NULL, `Phone` varchar(255) DEFAULT NULL, `PackListExportType` varchar(255) DEFAULT NULL, `RepliesImportType` varchar(255) DEFAULT NULL, `AutoReplyDays` int(11) DEFAULT '0', `Note` longtext, `Deleted` tinyint(1) DEFAULT '0', `LastUpdate` datetime NOT NULL, `Version` int(11) NOT NULL, `IsDriver` tinyint(1) DEFAULT '0', `IsExcludedFromInvoice` tinyint(1) DEFAULT '0', `SynchronizeOnCash` tinyint(1) DEFAULT '0', `IsXpPartner` tinyint(1) DEFAULT '0', `Address` varchar(250) DEFAULT NULL, `City` varchar(50) DEFAULT NULL, `ZipCode` varchar(5) DEFAULT NULL, `Country` varchar(2) DEFAULT NULL, `State` varchar(3) DEFAULT NULL, `Register` varchar(250) DEFAULT NULL, `PIva` varchar(13) DEFAULT NULL, `CF` varchar(16) DEFAULT NULL, `IdSynchronizationSession` varchar(38) DEFAULT NULL, `SynchronizationDate` datetime DEFAULT NULL, PRIMARY KEY (`HistorizationNumber`), KEY `IDX_ID_Session` (`ID`,`IdSynchronizationSession`), KEY `IDX_SyncSession` (`IdSynchronizationSession`,`SynchronizationDate`), KEY `IDX_ID_History` (`ID`,`HistorizationNumber`), KEY `IDX_MaxHistory` (`IdSynchronizationSession`,`HistorizationNumber`) ) ENGINE=InnoDB AUTO_INCREMENT=153 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `TransportersBillings` -- DROP TABLE IF EXISTS `TransportersBillings`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `TransportersBillings` ( `ID` varchar(38) NOT NULL, `BillDate` datetime NOT NULL, `IdTransporter` varchar(38) NOT NULL, `PackagesRange` longtext, `ReDeliveredPackagesRange` longtext, `ToNumber` int(11) DEFAULT NULL, `ToDate` datetime DEFAULT NULL, `LastUpdate` datetime NOT NULL, `Version` int(11) NOT NULL, `HidePackagesRange` tinyint(1) DEFAULT '0', `IdDriver` varchar(38) DEFAULT NULL, `IdVehicle` varchar(38) DEFAULT NULL, PRIMARY KEY (`ID`), KEY `BillDate` (`BillDate`), KEY `FK_Transporter_TransportersBillings_idx` (`IdTransporter`), KEY `FK_Driver_TransportersBillings_idx` (`IdDriver`), KEY `FK_Vehicle_TransportersBillings_idx` (`IdVehicle`), CONSTRAINT `FK_Driver_TransportersBillings` FOREIGN KEY (`IdDriver`) REFERENCES `drivers` (`ID`), CONSTRAINT `FK_Transporter_TransportersBillings` FOREIGN KEY (`IdTransporter`) REFERENCES `transporters` (`ID`), CONSTRAINT `FK_Vehicle_TransportersBillings` FOREIGN KEY (`IdVehicle`) REFERENCES `vehicles` (`ID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `TransportersBillingsInStockPackages` -- DROP TABLE IF EXISTS `TransportersBillingsInStockPackages`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `TransportersBillingsInStockPackages` ( `ID` varchar(38) NOT NULL, `IdOutPackage` varchar(38) DEFAULT NULL, `IdTransporterBilling` varchar(38) NOT NULL, `InStockRate` decimal(19,4) DEFAULT NULL, `LastUpdate` datetime NOT NULL, `Version` int(11) NOT NULL, `CashOnDeliveryRate` decimal(19,4) DEFAULT NULL, `RateReferenceDate` datetime DEFAULT NULL, `ErrorDescription` longtext, PRIMARY KEY (`ID`), KEY `FK_TransporterBilling_TransportersBillingsInStockPackages_idx` (`IdTransporterBilling`), KEY `FK_OutPackage_TransportersBillingsInStockPackages_idx` (`IdOutPackage`), CONSTRAINT `FK_Package_TransportersBillingsInStockPackages` FOREIGN KEY (`IdOutPackage`) REFERENCES `outpackages` (`ID`), CONSTRAINT `FK_TransporterBilling_TransportersBillingsInStockPackages` FOREIGN KEY (`IdTransporterBilling`) REFERENCES `transportersbillings` (`ID`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `TransportersBillingsPackages` -- DROP TABLE IF EXISTS `TransportersBillingsPackages`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `TransportersBillingsPackages` ( `ID` varchar(38) NOT NULL, `IdOutPackage` varchar(38) DEFAULT NULL, `IdTransporterBilling` varchar(38) NOT NULL, `IdDeliveryType` int(11) DEFAULT NULL, `IdPackageType` int(11) DEFAULT NULL, `IdAdminArea` int(11) DEFAULT NULL, `BaseRate` decimal(19,4) DEFAULT NULL, `DeliveryRate` decimal(19,4) DEFAULT NULL, `PackageRate` decimal(19,4) DEFAULT NULL, `InsuranceRate` decimal(19,4) DEFAULT NULL, `CashOnDeliveryRate` decimal(19,4) DEFAULT NULL, `PDCRate` decimal(19,4) DEFAULT NULL, `ReDelivery` tinyint(1) DEFAULT '0', `LastUpdate` datetime NOT NULL, `Version` int(11) NOT NULL, `Weight` int(11) DEFAULT NULL, `Boxes` int(11) DEFAULT '1', `Pallets` int(11) DEFAULT NULL, `Volume` decimal(19,4) DEFAULT NULL, `UnitType` varchar(50) DEFAULT NULL, `ExtraRate` decimal(19,4) DEFAULT NULL, `Quantity` decimal(19,4) NOT NULL DEFAULT '1.0000', `RateReferenceDate` datetime DEFAULT NULL, `ExtrasDescription` longtext, `ErrorDescription` longtext, `StopID` varchar(38) DEFAULT NULL, `StopRate` decimal(19,4) DEFAULT NULL, `PenaltyRate` decimal(19,4) DEFAULT NULL, `IdMerge` varchar(38) DEFAULT NULL, `TripIdAdminArea` int(11) DEFAULT NULL, PRIMARY KEY (`ID`), KEY `FK_TransportersBilling_TransportersBillingsPackages_idx` (`IdTransporterBilling`), KEY `FK_PackageType_TransportersBillingsPackages_idx` (`IdPackageType`), KEY `FK_DeliveryType_TransportersBillingsPackages_idx` (`IdDeliveryType`), KEY `FK_AdminArea_TransportersBillingsPackages_idx` (`IdAdminArea`), KEY `FK_OutPackage_TransportersBillingsPackages_idx` (`IdOutPackage`), CONSTRAINT `FK_AdminArea_TransportersBillingsPackages` FOREIGN KEY (`IdAdminArea`) REFERENCES `adminareas` (`ID`) ON UPDATE CASCADE, CONSTRAINT `FK_DeliveryType_TransportersBillingsPackages` FOREIGN KEY (`IdDeliveryType`) REFERENCES `deliverytypes` (`ID`), CONSTRAINT `FK_OutPackage_TransportersBillingsPackages` FOREIGN KEY (`IdOutPackage`) REFERENCES `outpackages` (`ID`), CONSTRAINT `FK_PackageType_TransportersBillingsPackages` FOREIGN KEY (`IdPackageType`) REFERENCES `packagetypes` (`ID`), CONSTRAINT `FK_TransportersBilling_TransportersBillingsPackages` FOREIGN KEY (`IdTransporterBilling`) REFERENCES `transportersbillings` (`ID`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `TransportersBillingsReturnedPackages` -- DROP TABLE IF EXISTS `TransportersBillingsReturnedPackages`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `TransportersBillingsReturnedPackages` ( `ID` varchar(38) NOT NULL, `IdOutPackage` varchar(38) DEFAULT NULL, `IdTransporterBilling` varchar(38) NOT NULL, `RateReferenceDate` datetime DEFAULT NULL, `ReturnedRate` decimal(19,4) DEFAULT NULL, `LastUpdate` datetime NOT NULL, `Version` int(11) NOT NULL, `ErrorDescription` longtext, PRIMARY KEY (`ID`), KEY `FK_TransportersBilling_TransportersBillingsReturnedPackages_idx` (`IdTransporterBilling`), KEY `FK_OutPackage_TransportersBillingsReturnedPackages_idx` (`IdOutPackage`), CONSTRAINT `FK_OutPackage_TransportersBillingsReturnedPackages` FOREIGN KEY (`IdOutPackage`) REFERENCES `outpackages` (`ID`), CONSTRAINT `FK_TransportersBilling_TransportersBillingsReturnedPackages` FOREIGN KEY (`IdTransporterBilling`) REFERENCES `transportersbillings` (`ID`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `TransportersExpirations` -- DROP TABLE IF EXISTS `TransportersExpirations`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `TransportersExpirations` ( `ID` varchar(38) NOT NULL, `IdTransporter` varchar(38) NOT NULL, `Description` varchar(255) DEFAULT NULL, `Date` datetime DEFAULT NULL, `Marked` tinyint(1) DEFAULT '0', `LastUpdate` datetime NOT NULL, `Version` int(11) NOT NULL, PRIMARY KEY (`ID`), KEY `FK_Transporter_TransportersExpirations_idx` (`IdTransporter`), CONSTRAINT `FK_Transporter_TransportersExpirations` FOREIGN KEY (`IdTransporter`) REFERENCES `transporters` (`ID`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `TransportersRates` -- DROP TABLE IF EXISTS `TransportersRates`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `TransportersRates` ( `ID` varchar(38) NOT NULL, `IdTransporter` varchar(38) DEFAULT NULL, `IdVehicleType` varchar(38) DEFAULT NULL, `IdVehicle` varchar(38) DEFAULT NULL, `IdDriver` varchar(38) DEFAULT NULL, `IdPublisher` varchar(38) DEFAULT NULL, `IdSender` varchar(38) DEFAULT NULL, `FromDate` datetime NOT NULL, `ToDate` datetime NOT NULL, `InsuranceValuePer` decimal(19,4) DEFAULT NULL, `InsuranceValueMin` decimal(19,4) DEFAULT NULL, `InsuranceValueMinVal` decimal(19,4) DEFAULT NULL, `InsuranceValueMaxVal` decimal(19,4) DEFAULT NULL, `InsuranceBoxesVal` decimal(19,4) DEFAULT NULL, `InsuranceBoxesMinVal` decimal(19,4) DEFAULT NULL, `InsuranceBoxesMaxVal` decimal(19,4) DEFAULT NULL, `InsuranceDeliveryVal` decimal(19,4) DEFAULT NULL, `InsuranceDeliveryMinVal` decimal(19,4) DEFAULT NULL, `InsuranceDeliveryMaxVal` decimal(19,4) DEFAULT NULL, `CashOnDeliveryPer` decimal(19,4) DEFAULT NULL, `CashOnDeliveryMinVal` decimal(19,4) DEFAULT NULL, `ReturnedVal` decimal(19,4) DEFAULT NULL, `InStockVal` decimal(19,4) DEFAULT NULL, `NotFirstDeliveryDiscountType` varchar(1) DEFAULT '%', `NotFirstDeliveryDiscountVal` decimal(19,4) DEFAULT '0.0000', `InsuranceBaseVal` decimal(19,4) DEFAULT NULL, `PDCVal` decimal(19,4) DEFAULT NULL, `MergeForOutPackList` tinyint(1) DEFAULT '0', `MergeForReceiverInDate` tinyint(1) DEFAULT '0', `UnitsToIgnore` int(11) NOT NULL DEFAULT '14', `LastUpdate` datetime NOT NULL, `Version` int(11) NOT NULL, `HidePackagesRange` tinyint(1) DEFAULT '0', `HasDefaultRates` tinyint(1) DEFAULT '0', `VolumeWeight` decimal(19,4) DEFAULT '0.0000', `BoxesWeight` decimal(19,4) DEFAULT '0.0000', `PalletsWeight` decimal(19,4) DEFAULT '0.0000', `InsuranceBaseAdminAreas` varchar(200) DEFAULT NULL, `Description` varchar(50) DEFAULT NULL, `CashOnDeliveryMaxVal` decimal(19,4) DEFAULT NULL, `ReturnedChangeType` varchar(1) DEFAULT '€', `PackAmountPerc` decimal(19,4) DEFAULT '0.0000', `PackAmountMin` decimal(19,4) DEFAULT '0.0000', `PackAmountMax` decimal(19,4) DEFAULT '0.0000', `EPalRate` decimal(19,8) NOT NULL DEFAULT '0.00000000', `StorageRate` decimal(19,4) DEFAULT NULL, `StorageWeight` decimal(19,4) DEFAULT NULL, `IgnoreReceiverNameWhileMerge` tinyint(1) DEFAULT NULL, `IgnoreSenderGroupWhileMerge` tinyint(1) DEFAULT NULL, `MergeCOD` tinyint(1) DEFAULT NULL, `MinVolume` decimal(19,4) DEFAULT NULL, `StopRate` decimal(19,4) DEFAULT NULL, `PenaltyFirstLimitValue` decimal(19,4) DEFAULT NULL, `PenaltyFirstLimitType` varchar(50) DEFAULT NULL, `PenaltyFirstValue` decimal(19,4) DEFAULT NULL, `PenaltyFirstValueType` varchar(50) DEFAULT NULL, `PenaltyFirstApplyOn` varchar(50) DEFAULT NULL, `PenaltySecondLimitValue` decimal(19,4) DEFAULT NULL, `PenaltySecondLimitType` varchar(50) DEFAULT NULL, `PenaltySecondValue` decimal(19,4) DEFAULT NULL, `PenaltySecondValueType` varchar(50) DEFAULT NULL, `PenaltySecondApplyOn` varchar(50) DEFAULT NULL, `PenaltyOverValue` decimal(19,4) DEFAULT NULL, `PenaltyOverValueType` varchar(50) DEFAULT NULL, `PenaltyOverApplyOn` varchar(50) DEFAULT NULL, `ReDeliveryChangeType` varchar(1) DEFAULT '%', `ReDeliveryChangeVal` decimal(19,4) DEFAULT NULL, `IgnoreMergeOnBooking` tinyint(1) DEFAULT NULL, PRIMARY KEY (`ID`), KEY `IDX_TransportersRates_ToDate` (`ToDate`), KEY `IDX_TransportersRates_FromDate` (`FromDate`), KEY `FK_Transporter_TransportersRates_idx` (`IdTransporter`), KEY `FK_VehicleType_TransportersRates_idx` (`IdVehicleType`), KEY `FK_Vehicle_TransportersRates_idx` (`IdVehicle`), KEY `FK_Driver_TransportersRates_idx` (`IdDriver`), KEY `FK_Publisher_TransportersRates_idx` (`IdPublisher`), KEY `FK_Sender_TransportersRates_idx` (`IdSender`), CONSTRAINT `FK_Driver_TransportersRates` FOREIGN KEY (`IdDriver`) REFERENCES `drivers` (`ID`), CONSTRAINT `FK_Publisher_TransportersRates` FOREIGN KEY (`IdPublisher`) REFERENCES `publishers` (`ID`), CONSTRAINT `FK_Sender_TransportersRates` FOREIGN KEY (`IdSender`) REFERENCES `publisherssenders` (`ID`), CONSTRAINT `FK_Transporter_TransportersRates` FOREIGN KEY (`IdTransporter`) REFERENCES `transporters` (`ID`) ON DELETE CASCADE, CONSTRAINT `FK_VehicleType_TransportersRates` FOREIGN KEY (`IdVehicleType`) REFERENCES `vehicletypes` (`ID`), CONSTRAINT `FK_Vehicle_TransportersRates` FOREIGN KEY (`IdVehicle`) REFERENCES `vehicles` (`ID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `TransportersRatesBases` -- DROP TABLE IF EXISTS `TransportersRatesBases`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `TransportersRatesBases` ( `ID` varchar(38) NOT NULL, `IdTransporterRate` varchar(38) NOT NULL, `IdPackageType` int(11) NOT NULL, `IdAdminArea` int(11) DEFAULT NULL, `Rate` decimal(19,4) DEFAULT NULL, `LastUpdate` datetime NOT NULL, `Version` int(11) NOT NULL, `MinVal` decimal(19,4) DEFAULT NULL, `MaxVal` decimal(19,4) DEFAULT NULL, `UnitGap` decimal(19,4) DEFAULT NULL, `UnitType` varchar(45) NOT NULL DEFAULT 'Boxes', `ApplyCOD` tinyint(4) NOT NULL DEFAULT '1', `RoundToUnitGap` tinyint(1) NOT NULL DEFAULT '0', `NotFirstDeliveryRate` decimal(19,4) DEFAULT NULL, PRIMARY KEY (`ID`), KEY `FK_TransportersRates_TransportersRatesBases_idx` (`IdTransporterRate`), KEY `FK_AdminAreasRates_TransportersRatesBases_idx` (`IdAdminArea`), KEY `FK_PackageTypes_TransportersRatesBases_idx` (`IdPackageType`), CONSTRAINT `FK_AdminAreasRates_TransportersRatesBases` FOREIGN KEY (`IdAdminArea`) REFERENCES `adminareas` (`ID`), CONSTRAINT `FK_PackageTypes_TransportersRatesBases` FOREIGN KEY (`IdPackageType`) REFERENCES `packagetypes` (`ID`), CONSTRAINT `FK_TransportersRates_TransportersRatesBases` FOREIGN KEY (`IdTransporterRate`) REFERENCES `transportersrates` (`ID`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `TransportersRatesDeliveryTypes` -- DROP TABLE IF EXISTS `TransportersRatesDeliveryTypes`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `TransportersRatesDeliveryTypes` ( `ID` varchar(38) NOT NULL, `IdTransporterRate` varchar(38) NOT NULL, `IdPackageType` int(11) DEFAULT NULL, `IdAdminArea` int(11) DEFAULT NULL, `IdDeliveryType` int(11) DEFAULT NULL, `ChangeType` varchar(1) DEFAULT NULL, `ChangeValue` decimal(19,4) DEFAULT NULL, `LastUpdate` datetime NOT NULL, `Version` int(11) NOT NULL, `ApplyOnReDelivery` tinyint(4) DEFAULT NULL, `ApplyOneTime` tinyint(4) DEFAULT '0', PRIMARY KEY (`ID`), UNIQUE KEY `UK_TransportersRatesDeliveryTypes` (`IdTransporterRate`,`IdPackageType`,`IdAdminArea`,`IdDeliveryType`), KEY `FK_IdPackageType_TRDT_idx` (`IdPackageType`), KEY `FK_IdAdminArea_TRDT_idx` (`IdAdminArea`), KEY `FK_IdDeliveryType_TRDT_idx` (`IdDeliveryType`), KEY `FK_IdTransporterRate_TRDT_idx` (`IdTransporterRate`), CONSTRAINT `FK_IdAdminArea_TRDT` FOREIGN KEY (`IdAdminArea`) REFERENCES `adminareas` (`ID`), CONSTRAINT `FK_IdDeliveryType_TRDT` FOREIGN KEY (`IdDeliveryType`) REFERENCES `deliverytypes` (`ID`), CONSTRAINT `FK_IdPackageType_TRDT` FOREIGN KEY (`IdPackageType`) REFERENCES `packagetypes` (`ID`), CONSTRAINT `FK_IdTransporterRate_TRDT` FOREIGN KEY (`IdTransporterRate`) REFERENCES `transportersrates` (`ID`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `TransportersRatesExtraTypes` -- DROP TABLE IF EXISTS `TransportersRatesExtraTypes`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `TransportersRatesExtraTypes` ( `ID` varchar(38) NOT NULL, `IdTransporterRate` varchar(38) NOT NULL, `IdExtraType` int(11) DEFAULT NULL, `ExtraValue` decimal(19,4) DEFAULT NULL, `LastUpdate` datetime NOT NULL, `Version` int(11) NOT NULL, `ChangeType` varchar(5) NOT NULL DEFAULT '€', PRIMARY KEY (`ID`), UNIQUE KEY `UK_TransportersRatesExtraTypes` (`IdTransporterRate`,`IdExtraType`), KEY `FK_ExtraType_TransportersRatesExtraTypes_idx` (`IdExtraType`), CONSTRAINT `FK_ExtraType_TransportersRatesExtraTypes` FOREIGN KEY (`IdExtraType`) REFERENCES `extratypes` (`ID`), CONSTRAINT `FK_TransporterRate_TransportersRatesExtraTypes` FOREIGN KEY (`IdTransporterRate`) REFERENCES `transportersrates` (`ID`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `Vehicles` -- DROP TABLE IF EXISTS `Vehicles`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `Vehicles` ( `ID` varchar(38) NOT NULL, `Code` varchar(15) NOT NULL, `Description` varchar(50) NOT NULL, `IdVehicleType` varchar(38) NOT NULL, `Note` longtext, `LastUpdate` datetime NOT NULL, `Version` int(11) NOT NULL, `GasCombinedCycle` decimal(19,4) DEFAULT NULL, `Km` int(11) DEFAULT NULL, `HaveTrailer` tinyint(4) DEFAULT NULL, `HaveTailgate` tinyint(4) DEFAULT NULL, `MaxVolume` decimal(19,4) DEFAULT NULL, `MaxWeight` decimal(19,4) DEFAULT NULL, `Axles` int(11) DEFAULT NULL, `MaxPallets` int(11) DEFAULT NULL, PRIMARY KEY (`ID`), UNIQUE KEY `Code` (`Code`), KEY `Description` (`Description`), KEY `fk_vehicle_vehicleTypes_idx` (`IdVehicleType`), CONSTRAINT `fk_vehicle_vehicleType` FOREIGN KEY (`IdVehicleType`) REFERENCES `vehicletypes` (`ID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `VehiclesExpirations` -- DROP TABLE IF EXISTS `VehiclesExpirations`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `VehiclesExpirations` ( `ID` varchar(38) NOT NULL, `IdVehicle` varchar(38) NOT NULL, `Description` varchar(255) DEFAULT NULL, `Date` datetime DEFAULT NULL, `Marked` tinyint(1) DEFAULT '0', `LastUpdate` datetime NOT NULL, `Version` int(11) NOT NULL, PRIMARY KEY (`ID`), KEY `FK_Vehicle_VehiclesExpirations_idx` (`IdVehicle`), CONSTRAINT `FK_Vehicle_VehiclesExpirations` FOREIGN KEY (`IdVehicle`) REFERENCES `vehicles` (`ID`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `VehiclesTransporters` -- DROP TABLE IF EXISTS `VehiclesTransporters`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `VehiclesTransporters` ( `ID` varchar(38) NOT NULL, `IdVehicle` varchar(38) NOT NULL, `IdTransporter` varchar(38) NOT NULL, `FromDate` datetime DEFAULT NULL, `ToDate` datetime DEFAULT NULL, `Note` longtext, `LastUpdate` datetime NOT NULL, `Version` int(11) NOT NULL, PRIMARY KEY (`ID`), UNIQUE KEY `UK_VehicleTransporter` (`IdVehicle`,`IdTransporter`), KEY `FromDate` (`FromDate`), KEY `ToDate` (`ToDate`), KEY `FK_Vehicle_VehiclesTransporters_idx` (`IdVehicle`), KEY `FK_Vehicles_Transporters_idx` (`IdTransporter`), CONSTRAINT `FK_Vehicles_Transporters` FOREIGN KEY (`IdTransporter`) REFERENCES `transporters` (`ID`) ON DELETE CASCADE, CONSTRAINT `FK_Vehicles_VehicleTransporter` FOREIGN KEY (`IdVehicle`) REFERENCES `vehicles` (`ID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `VehicleTypes` -- DROP TABLE IF EXISTS `VehicleTypes`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `VehicleTypes` ( `ID` varchar(38) NOT NULL, `Code` varchar(50) NOT NULL, `Description` varchar(150) DEFAULT NULL, `Version` int(11) NOT NULL, `LastUpdate` datetime NOT NULL, `Deleted` tinyint(1) NOT NULL DEFAULT '0', PRIMARY KEY (`ID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `XpCodes` -- DROP TABLE IF EXISTS `XpCodes`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `XpCodes` ( `ID` varchar(38) NOT NULL, `XpCode` varchar(20) NOT NULL, `Hash` varchar(200) NOT NULL, PRIMARY KEY (`ID`), KEY `XpCode` (`XpCode`), KEY `FK_Packages_XpCodes_idx` (`ID`), CONSTRAINT `FK_Packages_XpCodes` FOREIGN KEY (`ID`) REFERENCES `packages` (`ID`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping events for database 'Waspnet_Courier' -- -- -- Dumping routines for database 'Waspnet_Courier' -- -- -- Final view structure for view `instockpackages_publisher` -- /*!50001 DROP VIEW IF EXISTS `instockpackages_publisher`*/; /*!50001 SET @saved_cs_client = @@character_set_client */; /*!50001 SET @saved_cs_results = @@character_set_results */; /*!50001 SET @saved_col_connection = @@collation_connection */; /*!50001 SET character_set_client = utf8mb4 */; /*!50001 SET character_set_results = utf8mb4 */; /*!50001 SET collation_connection = utf8mb4_0900_ai_ci */; /*!50001 CREATE ALGORITHM=UNDEFINED */ /*!50013 DEFINER=`waspnet`@`%` SQL SECURITY DEFINER */ /*!50001 VIEW `instockpackages_publisher` AS select `instockpackages`.`ID` AS `ID`,`packages`.`IdPublisher` AS `IdPublisher`,`instockpackages`.`IdExportEventSession` AS `IdExportEventSession`,`instockpackages`.`ExportEventSentDate` AS `ExportEventSentDate` from (`instockpackages` join `packages` on((`instockpackages`.`IdPackage` = `packages`.`ID`))) where ((`instockpackages`.`IdExportEventSession` is null) and (`instockpackages`.`ExportEventSentDate` is null)) */; /*!50001 SET character_set_client = @saved_cs_client */; /*!50001 SET character_set_results = @saved_cs_results */; /*!50001 SET collation_connection = @saved_col_connection */; /*!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 2020-09-08 9:40:26