Untitled

altervisi0n

May 6th, 2025

250

Never

Add comment

Not a member of Pastebin yet? Sign Up, it unlocks many cool features!

MySQL 215.48 KB | None | 0 0

raw download clone embed print report

-- MySQL Script generated by MySQL Workbench
-- Tue Mar 25 16:11:13 2025
-- Model: New Model Version: 1.0
-- MySQL Workbench Forward Engineering
SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION';
-- -----------------------------------------------------
-- Schema mydb
-- -----------------------------------------------------
-- -----------------------------------------------------
-- Schema mydb
-- -----------------------------------------------------
CREATE SCHEMA IF NOT EXISTS `mydb` DEFAULT CHARACTER SET utf8 ;
USE `mydb` ;
-- -----------------------------------------------------
-- Table `mydb`.`OrderStatuses`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `mydb`.`OrderStatuses` (
`StatusID` INT NOT NULL AUTO_INCREMENT,
`StatusName` VARCHAR(50) NULL,
PRIMARY KEY (`StatusID`))
ENGINE = InnoDB;
-- -----------------------------------------------------
-- Table `mydb`.`Customers`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `mydb`.`Customers` (
`CustomerID` INT NOT NULL AUTO_INCREMENT,
`Name` VARCHAR(255) NULL,
`ContactInfo` VARCHAR(255) NULL,
`Adress` VARCHAR(255) NULL,
PRIMARY KEY (`CustomerID`))
ENGINE = InnoDB;
-- -----------------------------------------------------
-- Table `mydb`.`Orders`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `mydb`.`Orders` (
`OrderID` INT NOT NULL AUTO_INCREMENT,
`OrderDate` TIMESTAMP NULL,
`TotalAmount` DECIMAL(10,2) NULL,
`OrderStatuses_StatusID` INT NOT NULL,
`Customers_CustomerID` INT NOT NULL,
PRIMARY KEY (`OrderID`),
INDEX `fk_Orders_OrderStatuses1_idx` (`OrderStatuses_StatusID` ASC) VISIBLE,
INDEX `fk_Orders_Customers1_idx` (`Customers_CustomerID` ASC) VISIBLE,
CONSTRAINT `fk_Orders_OrderStatuses1`
FOREIGN KEY (`OrderStatuses_StatusID`)
REFERENCES `mydb`.`OrderStatuses` (`StatusID`)
ON DELETE NO ACTION
ON UPDATE NO ACTION,
CONSTRAINT `fk_Orders_Customers1`
FOREIGN KEY (`Customers_CustomerID`)
REFERENCES `mydb`.`Customers` (`CustomerID`)
ON DELETE NO ACTION
ON UPDATE NO ACTION)
ENGINE = InnoDB;
-- -----------------------------------------------------
-- Table `mydb`.`ProductsCategories`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `mydb`.`ProductsCategories` (
`ProductCategoryID` INT NOT NULL AUTO_INCREMENT,
`CategoryName` VARCHAR(100) NULL,
PRIMARY KEY (`ProductCategoryID`))
ENGINE = InnoDB;
-- -----------------------------------------------------
-- Table `mydb`.`Products`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `mydb`.`Products` (
`ProductID` INT NOT NULL AUTO_INCREMENT,
`Name` VARCHAR(255) NULL,
`Description` TEXT NULL,
`ProductsCategories_ProductCategoryID` INT NOT NULL,
PRIMARY KEY (`ProductID`),
INDEX `fk_Products_ProductsCategories1_idx` (`ProductsCategories_ProductCategoryID` ASC) VISIBLE,
CONSTRAINT `fk_Products_ProductsCategories1`
FOREIGN KEY (`ProductsCategories_ProductCategoryID`)
REFERENCES `mydb`.`ProductsCategories` (`ProductCategoryID`)
ON DELETE NO ACTION
ON UPDATE NO ACTION)
ENGINE = InnoDB;
-- -----------------------------------------------------
-- Table `mydb`.`OrderDetails`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `mydb`.`OrderDetails` (
`OrderDetailID` INT NOT NULL AUTO_INCREMENT,
`Price` DECIMAL(10,2) NULL,
`Orders_OrderID` INT NOT NULL,
`Products_ProductID` INT NOT NULL,
PRIMARY KEY (`OrderDetailID`),
INDEX `fk_OrderDetails_Orders1_idx` (`Orders_OrderID` ASC) VISIBLE,
INDEX `fk_OrderDetails_Products1_idx` (`Products_ProductID` ASC) VISIBLE,
CONSTRAINT `fk_OrderDetails_Orders1`
FOREIGN KEY (`Orders_OrderID`)
REFERENCES `mydb`.`Orders` (`OrderID`)
ON DELETE NO ACTION
ON UPDATE NO ACTION,
CONSTRAINT `fk_OrderDetails_Products1`
FOREIGN KEY (`Products_ProductID`)
REFERENCES `mydb`.`Products` (`ProductID`)
ON DELETE NO ACTION
ON UPDATE NO ACTION)
ENGINE = InnoDB;
-- -----------------------------------------------------
-- Table `mydb`.`CustomersContacts`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `mydb`.`CustomersContacts` (
`ContactID` INT NOT NULL AUTO_INCREMENT,
`ContactType` ENUM('Телефон', 'Почта') NULL,
`Value` VARCHAR(255) NULL,
`Customers_CustomerID` INT NOT NULL,
PRIMARY KEY (`ContactID`),
INDEX `fk_CustomersContacts_Customers1_idx` (`Customers_CustomerID` ASC) VISIBLE,
CONSTRAINT `fk_CustomersContacts_Customers1`
FOREIGN KEY (`Customers_CustomerID`)
REFERENCES `mydb`.`Customers` (`CustomerID`)
ON DELETE NO ACTION
ON UPDATE NO ACTION)
ENGINE = InnoDB;
-- -----------------------------------------------------
-- Table `mydb`.`Quotes`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `mydb`.`Quotes` (
`QuoteID` INT NOT NULL AUTO_INCREMENT,
`QuoteDate` TIMESTAMP NULL,
`TotalCost` DECIMAL(10,2) NULL,
`Customers_CustomerID` INT NOT NULL,
PRIMARY KEY (`QuoteID`),
INDEX `fk_Quotes_Customers1_idx` (`Customers_CustomerID` ASC) VISIBLE,
CONSTRAINT `fk_Quotes_Customers1`
FOREIGN KEY (`Customers_CustomerID`)
REFERENCES `mydb`.`Customers` (`CustomerID`)
ON DELETE NO ACTION
ON UPDATE NO ACTION)
ENGINE = InnoDB;
-- -----------------------------------------------------
-- Table `mydb`.`QuoteDetails`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `mydb`.`QuoteDetails` (
`QuoteDetailID` INT NOT NULL AUTO_INCREMENT,
`Quantity` INT NULL,
`Price` DECIMAL(10,2) NULL,
`Quotes_QuoteID` INT NOT NULL,
`Products_ProductID` INT NOT NULL,
PRIMARY KEY (`QuoteDetailID`),
INDEX `fk_QuoteDetails_Quotes1_idx` (`Quotes_QuoteID` ASC) VISIBLE,
INDEX `fk_QuoteDetails_Products1_idx` (`Products_ProductID` ASC) VISIBLE,
CONSTRAINT `fk_QuoteDetails_Quotes1`
FOREIGN KEY (`Quotes_QuoteID`)
REFERENCES `mydb`.`Quotes` (`QuoteID`)
ON DELETE NO ACTION
ON UPDATE NO ACTION,
CONSTRAINT `fk_QuoteDetails_Products1`
FOREIGN KEY (`Products_ProductID`)
REFERENCES `mydb`.`Products` (`ProductID`)
ON DELETE NO ACTION
ON UPDATE NO ACTION)
ENGINE = InnoDB;
-- -----------------------------------------------------
-- Table `mydb`.`ProductionOrders`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `mydb`.`ProductionOrders` (
`ProductionOrderID` INT NOT NULL AUTO_INCREMENT,
`StartDate` TIMESTAMP NULL,
`EndDate` TIMESTAMP NULL,
`Status` VARCHAR(45) NULL,
PRIMARY KEY (`ProductionOrderID`))
ENGINE = InnoDB;
-- -----------------------------------------------------
-- Table `mydb`.`ProductionSteps`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `mydb`.`ProductionSteps` (
`StepID` INT NOT NULL AUTO_INCREMENT,
`StepName` VARCHAR(100) NULL,
`Description` TEXT NULL,
PRIMARY KEY (`StepID`))
ENGINE = InnoDB;
-- -----------------------------------------------------
-- Table `mydb`.`ProductionOrderSteps`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `mydb`.`ProductionOrderSteps` (
`OrderStepID` INT NOT NULL AUTO_INCREMENT,
`Status` VARCHAR(45) NULL,
`ProductionSteps_StepID` INT NOT NULL,
`ProductionOrders_ProductionOrderID` INT NOT NULL,
PRIMARY KEY (`OrderStepID`),
INDEX `fk_ProductionOrderSteps_ProductionSteps1_idx` (`ProductionSteps_StepID` ASC) VISIBLE,
INDEX `fk_ProductionOrderSteps_ProductionOrders1_idx` (`ProductionOrders_ProductionOrderID` ASC) VISIBLE,
CONSTRAINT `fk_ProductionOrderSteps_ProductionSteps1`
FOREIGN KEY (`ProductionSteps_StepID`)
REFERENCES `mydb`.`ProductionSteps` (`StepID`)
ON DELETE NO ACTION
ON UPDATE NO ACTION,
CONSTRAINT `fk_ProductionOrderSteps_ProductionOrders1`
FOREIGN KEY (`ProductionOrders_ProductionOrderID`)
REFERENCES `mydb`.`ProductionOrders` (`ProductionOrderID`)
ON DELETE NO ACTION
ON UPDATE NO ACTION)
ENGINE = InnoDB;
-- -----------------------------------------------------
-- Table `mydb`.`Materials`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `mydb`.`Materials` (
`MaterialID` INT NOT NULL AUTO_INCREMENT,
`Name` VARCHAR(255) NULL,
`UnitOfMeasure` VARCHAR(45) NULL,
`PricePerUnit` DECIMAL(10,2) NULL,
PRIMARY KEY (`MaterialID`))
ENGINE = InnoDB;
-- -----------------------------------------------------
-- Table `mydb`.`MaterialUsage`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `mydb`.`MaterialUsage` (
`UsageID` INT NOT NULL AUTO_INCREMENT,
`Quantity` INT NULL,
`Materials_MaterialID` INT NOT NULL,
`Orders_OrderID` INT NOT NULL,
PRIMARY KEY (`UsageID`),
INDEX `fk_MaterialUsage_Materials1_idx` (`Materials_MaterialID` ASC) VISIBLE,
INDEX `fk_MaterialUsage_Orders1_idx` (`Orders_OrderID` ASC) VISIBLE,
CONSTRAINT `fk_MaterialUsage_Materials1`
FOREIGN KEY (`Materials_MaterialID`)
REFERENCES `mydb`.`Materials` (`MaterialID`)
ON DELETE NO ACTION
ON UPDATE NO ACTION,
CONSTRAINT `fk_MaterialUsage_Orders1`
FOREIGN KEY (`Orders_OrderID`)
REFERENCES `mydb`.`Orders` (`OrderID`)
ON DELETE NO ACTION
ON UPDATE NO ACTION)
ENGINE = InnoDB;
-- -----------------------------------------------------
-- Table `mydb`.`Equipment`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `mydb`.`Equipment` (
`EquipmentID` INT NOT NULL AUTO_INCREMENT,
`Name` VARCHAR(255) NULL,
`Model` VARCHAR(100) NULL,
`PurchaseDate` TIMESTAMP NULL,
`Equipmentcol` VARCHAR(45) NULL,
PRIMARY KEY (`EquipmentID`))
ENGINE = InnoDB;
-- -----------------------------------------------------
-- Table `mydb`.`EquipmentMaintenance`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `mydb`.`EquipmentMaintenance` (
`MaintenanceID` INT NOT NULL AUTO_INCREMENT,
`MaintenanceDate` TIMESTAMP NULL,
`Description` TEXT NULL,
`Equipment_EquipmentID` INT NOT NULL,
PRIMARY KEY (`MaintenanceID`),
INDEX `fk_EquipmentMaintenance_Equipment1_idx` (`Equipment_EquipmentID` ASC) VISIBLE,
CONSTRAINT `fk_EquipmentMaintenance_Equipment1`
FOREIGN KEY (`Equipment_EquipmentID`)
REFERENCES `mydb`.`Equipment` (`EquipmentID`)
ON DELETE NO ACTION
ON UPDATE NO ACTION)
ENGINE = InnoDB;
-- -----------------------------------------------------
-- Table `mydb`.`Warehouses`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `mydb`.`Warehouses` (
`WarehouseID` INT NOT NULL AUTO_INCREMENT,
`Name` VARCHAR(255) NULL,
`Address` VARCHAR(255) NULL,
PRIMARY KEY (`WarehouseID`))
ENGINE = InnoDB;
-- -----------------------------------------------------
-- Table `mydb`.`Stocks`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `mydb`.`Stocks` (
`StockID` INT NOT NULL AUTO_INCREMENT,
`Quantity` INT NULL,
`Warehouses_WarehouseID` INT NOT NULL,
`Materials_MaterialID` INT NOT NULL,
PRIMARY KEY (`StockID`),
INDEX `fk_Stocks_Warehouses1_idx` (`Warehouses_WarehouseID` ASC) VISIBLE,
INDEX `fk_Stocks_Materials1_idx` (`Materials_MaterialID` ASC) VISIBLE,
CONSTRAINT `fk_Stocks_Warehouses1`
FOREIGN KEY (`Warehouses_WarehouseID`)
REFERENCES `mydb`.`Warehouses` (`WarehouseID`)
ON DELETE NO ACTION
ON UPDATE NO ACTION,
CONSTRAINT `fk_Stocks_Materials1`
FOREIGN KEY (`Materials_MaterialID`)
REFERENCES `mydb`.`Materials` (`MaterialID`)
ON DELETE NO ACTION
ON UPDATE NO ACTION)
ENGINE = InnoDB;
-- -----------------------------------------------------
-- Table `mydb`.`StockMovements`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `mydb`.`StockMovements` (
`StockMovementsID` INT NOT NULL AUTO_INCREMENT,
`OperationType` ENUM('Приход', 'Расход') NULL,
`Quantity` INT NULL,
`Materials_MaterialID` INT NOT NULL,
`Warehouses_WarehouseID` INT NOT NULL,
PRIMARY KEY (`StockMovementsID`),
INDEX `fk_StockMovements_Materials1_idx` (`Materials_MaterialID` ASC) VISIBLE,
INDEX `fk_StockMovements_Warehouses1_idx` (`Warehouses_WarehouseID` ASC) VISIBLE,
CONSTRAINT `fk_StockMovements_Materials1`
FOREIGN KEY (`Materials_MaterialID`)
REFERENCES `mydb`.`Materials` (`MaterialID`)
ON DELETE NO ACTION
ON UPDATE NO ACTION,
CONSTRAINT `fk_StockMovements_Warehouses1`
FOREIGN KEY (`Warehouses_WarehouseID`)
REFERENCES `mydb`.`Warehouses` (`WarehouseID`)
ON DELETE NO ACTION
ON UPDATE NO ACTION)
ENGINE = InnoDB;
-- -----------------------------------------------------
-- Table `mydb`.`Suppliers`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `mydb`.`Suppliers` (
`SupplierID` INT NOT NULL AUTO_INCREMENT,
`Name` VARCHAR(255) NULL,
`ContactInfo` VARCHAR(255) NULL,
PRIMARY KEY (`SupplierID`))
ENGINE = InnoDB;
-- -----------------------------------------------------
-- Table `mydb`.`SupplierContacts`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `mydb`.`SupplierContacts` (
`ContactID` INT NOT NULL AUTO_INCREMENT,
`ContactType` ENUM('Телефон', 'Почта') NULL,
`Value` VARCHAR(255) NULL,
`Suppliers_SupplierID` INT NOT NULL,
PRIMARY KEY (`ContactID`),
INDEX `fk_SupplierContacts_Suppliers1_idx` (`Suppliers_SupplierID` ASC) VISIBLE,
CONSTRAINT `fk_SupplierContacts_Suppliers1`
FOREIGN KEY (`Suppliers_SupplierID`)
REFERENCES `mydb`.`Suppliers` (`SupplierID`)
ON DELETE NO ACTION
ON UPDATE NO ACTION)
ENGINE = InnoDB;
-- -----------------------------------------------------
-- Table `mydb`.`PurchaseOrders`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `mydb`.`PurchaseOrders` (
`PurchaseOrderID` INT NOT NULL AUTO_INCREMENT,
`OrderDate` TIMESTAMP NULL,
`Status` VARCHAR(45) NULL,
`Suppliers_SupplierID` INT NOT NULL,
PRIMARY KEY (`PurchaseOrderID`),
INDEX `fk_PurchaseOrders_Suppliers1_idx` (`Suppliers_SupplierID` ASC) VISIBLE,
CONSTRAINT `fk_PurchaseOrders_Suppliers1`
FOREIGN KEY (`Suppliers_SupplierID`)
REFERENCES `mydb`.`Suppliers` (`SupplierID`)
ON DELETE NO ACTION
ON UPDATE NO ACTION)
ENGINE = InnoDB;
-- -----------------------------------------------------
-- Table `mydb`.`PurchaseOrderDetails`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `mydb`.`PurchaseOrderDetails` (
`PurchaseDetailID` INT NOT NULL AUTO_INCREMENT,
`Quantity` INT NULL,
`Price` DECIMAL(10,2) NULL,
`PurchaseOrders_PurchaseOrderID` INT NOT NULL,
`Materials_MaterialID` INT NOT NULL,
PRIMARY KEY (`PurchaseDetailID`),
INDEX `fk_PurchaseOrderDetails_PurchaseOrders1_idx` (`PurchaseOrders_PurchaseOrderID` ASC) VISIBLE,
INDEX `fk_PurchaseOrderDetails_Materials1_idx` (`Materials_MaterialID` ASC) VISIBLE,
CONSTRAINT `fk_PurchaseOrderDetails_PurchaseOrders1`
FOREIGN KEY (`PurchaseOrders_PurchaseOrderID`)
REFERENCES `mydb`.`PurchaseOrders` (`PurchaseOrderID`)
ON DELETE NO ACTION
ON UPDATE NO ACTION,
CONSTRAINT `fk_PurchaseOrderDetails_Materials1`
FOREIGN KEY (`Materials_MaterialID`)
REFERENCES `mydb`.`Materials` (`MaterialID`)
ON DELETE NO ACTION
ON UPDATE NO ACTION)
ENGINE = InnoDB;
-- -----------------------------------------------------
-- Table `mydb`.`Invoices`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `mydb`.`Invoices` (
`InvoiceID` INT NOT NULL AUTO_INCREMENT,
`InvoiceDate` TIMESTAMP NULL,
`Amount` DECIMAL(10,2) NULL,
PRIMARY KEY (`InvoiceID`))
ENGINE = InnoDB;
-- -----------------------------------------------------
-- Table `mydb`.`Payments`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `mydb`.`Payments` (
`PaymentID` INT NOT NULL AUTO_INCREMENT,
`PaymentDate` TIMESTAMP NULL,
`Amount` DECIMAL(10,2) NULL,
`PaymentMethod` VARCHAR(45) NULL,
`Invoices_InvoiceID` INT NOT NULL,
PRIMARY KEY (`PaymentID`),
INDEX `fk_Payments_Invoices1_idx` (`Invoices_InvoiceID` ASC) VISIBLE,
CONSTRAINT `fk_Payments_Invoices1`
FOREIGN KEY (`Invoices_InvoiceID`)
REFERENCES `mydb`.`Invoices` (`InvoiceID`)
ON DELETE NO ACTION
ON UPDATE NO ACTION)
ENGINE = InnoDB;
-- -----------------------------------------------------
-- Table `mydb`.`ExpenseCategories`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `mydb`.`ExpenseCategories` (
`ExpenseCategoryID` INT NOT NULL AUTO_INCREMENT,
`CategoryName` VARCHAR(100) NULL,
PRIMARY KEY (`ExpenseCategoryID`))
ENGINE = InnoDB;
-- -----------------------------------------------------
-- Table `mydb`.`Expenses`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `mydb`.`Expenses` (
`ExpenseID` INT NOT NULL AUTO_INCREMENT,
`ExpenseDate` TIMESTAMP NULL,
`Amount` DECIMAL(10,2) NULL,
`ExpenseCategories_ExpenseCategoryID` INT NOT NULL,
PRIMARY KEY (`ExpenseID`),
INDEX `fk_Expenses_ExpenseCategories1_idx` (`ExpenseCategories_ExpenseCategoryID` ASC) VISIBLE,
CONSTRAINT `fk_Expenses_ExpenseCategories1`
FOREIGN KEY (`ExpenseCategories_ExpenseCategoryID`)
REFERENCES `mydb`.`ExpenseCategories` (`ExpenseCategoryID`)
ON DELETE NO ACTION
ON UPDATE NO ACTION)
ENGINE = InnoDB;
-- -----------------------------------------------------
-- Table `mydb`.`Accounts`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `mydb`.`Accounts` (
`AccountID` INT NOT NULL AUTO_INCREMENT,
`AccountName` VARCHAR(255) NULL,
`Balance` DECIMAL(10,2) NULL,
PRIMARY KEY (`AccountID`))
ENGINE = InnoDB;
-- -----------------------------------------------------
-- Table `mydb`.`AccountTransactions`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `mydb`.`AccountTransactions` (
`TransactionID` INT NOT NULL AUTO_INCREMENT,
`TransactionDate` TIMESTAMP NULL,
`Amount` DECIMAL(10,2) NULL,
`TransactionType` ENUM('Доход', 'Расход') NULL,
`Accounts_AccountID` INT NOT NULL,
PRIMARY KEY (`TransactionID`),
INDEX `fk_AccountTransactions_Accounts1_idx` (`Accounts_AccountID` ASC) VISIBLE,
CONSTRAINT `fk_AccountTransactions_Accounts1`
FOREIGN KEY (`Accounts_AccountID`)
REFERENCES `mydb`.`Accounts` (`AccountID`)
ON DELETE NO ACTION
ON UPDATE NO ACTION)
ENGINE = InnoDB;
-- -----------------------------------------------------
-- Table `mydb`.`Departments`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `mydb`.`Departments` (
`DepartmentID` INT NOT NULL AUTO_INCREMENT,
`DepartmentName` VARCHAR(100) NULL,
PRIMARY KEY (`DepartmentID`))
ENGINE = InnoDB;
-- -----------------------------------------------------
-- Table `mydb`.`Employees`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `mydb`.`Employees` (
`EmployeeID` INT NOT NULL AUTO_INCREMENT,
`Name` VARCHAR(255) NULL,
`Position` VARCHAR(100) NULL,
`ContactInfo` VARCHAR(255) NULL,
PRIMARY KEY (`EmployeeID`))
ENGINE = InnoDB;
-- -----------------------------------------------------
-- Table `mydb`.`Salaries`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `mydb`.`Salaries` (
`SalaryID` INT NOT NULL AUTO_INCREMENT,
`SalaryDate` DATE NULL,
`Amount` DECIMAL(10,2) NULL,
`Employees_EmployeeID` INT NOT NULL,
PRIMARY KEY (`SalaryID`),
INDEX `fk_Salaries_Employees1_idx` (`Employees_EmployeeID` ASC) VISIBLE,
CONSTRAINT `fk_Salaries_Employees1`
FOREIGN KEY (`Employees_EmployeeID`)
REFERENCES `mydb`.`Employees` (`EmployeeID`)
ON DELETE NO ACTION
ON UPDATE NO ACTION)
ENGINE = InnoDB;
-- -----------------------------------------------------
-- Table `mydb`.`WorkSchedules`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `mydb`.`WorkSchedules` (
`ScheduleID` INT NOT NULL AUTO_INCREMENT,
`WorkDate` TIMESTAMP NULL,
`StartTime` TIME NULL,
`EndTime` TIME NULL,
`Employees_EmployeeID` INT NOT NULL,
PRIMARY KEY (`ScheduleID`),
INDEX `fk_WorkSchedules_Employees1_idx` (`Employees_EmployeeID` ASC) VISIBLE,
CONSTRAINT `fk_WorkSchedules_Employees1`
FOREIGN KEY (`Employees_EmployeeID`)
REFERENCES `mydb`.`Employees` (`EmployeeID`)
ON DELETE NO ACTION
ON UPDATE NO ACTION)
ENGINE = InnoDB;
-- -----------------------------------------------------
-- Table `mydb`.`EmployeeDepartments`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `mydb`.`EmployeeDepartments` (
`EmployeeDepartmentID` INT NOT NULL AUTO_INCREMENT,
`Departments_DepartmentID` INT NOT NULL,
`Employees_EmployeeID` INT NOT NULL,
PRIMARY KEY (`EmployeeDepartmentID`),
INDEX `fk_EmployeeDepartments_Departments1_idx` (`Departments_DepartmentID` ASC) VISIBLE,
INDEX `fk_EmployeeDepartments_Employees1_idx` (`Employees_EmployeeID` ASC) VISIBLE,
CONSTRAINT `fk_EmployeeDepartments_Departments1`
FOREIGN KEY (`Departments_DepartmentID`)
REFERENCES `mydb`.`Departments` (`DepartmentID`)
ON DELETE NO ACTION
ON UPDATE NO ACTION,
CONSTRAINT `fk_EmployeeDepartments_Employees1`
FOREIGN KEY (`Employees_EmployeeID`)
REFERENCES `mydb`.`Employees` (`EmployeeID`)
ON DELETE NO ACTION
ON UPDATE NO ACTION)
ENGINE = InnoDB;
-- -----------------------------------------------------
-- Table `mydb`.`Reports`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `mydb`.`Reports` (
`ReportID` INT NOT NULL AUTO_INCREMENT,
`ReportName` VARCHAR(255) NULL,
`CreationDate` TIMESTAMP NULL,
`ReportType` VARCHAR(100) NULL,
PRIMARY KEY (`ReportID`))
ENGINE = InnoDB;
-- -----------------------------------------------------
-- Table `mydb`.`ReportData`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `mydb`.`ReportData` (
`ReportDataID` INT NOT NULL AUTO_INCREMENT,
`Metric` VARCHAR(255) NULL,
`Value` DECIMAL(10,2) NULL,
`Reports_ReportID` INT NOT NULL,
PRIMARY KEY (`ReportDataID`),
INDEX `fk_ReportData_Reports1_idx` (`Reports_ReportID` ASC) VISIBLE,
CONSTRAINT `fk_ReportData_Reports1`
FOREIGN KEY (`Reports_ReportID`)
REFERENCES `mydb`.`Reports` (`ReportID`)
ON DELETE NO ACTION
ON UPDATE NO ACTION)
ENGINE = InnoDB;
-- -----------------------------------------------------
-- Table `mydb`.`KPIs`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `mydb`.`KPIs` (
`KpiID` INT NOT NULL AUTO_INCREMENT,
`KPIName` VARCHAR(255) NULL,
`TargetValue` DECIMAL(10,2) NULL,
`ActualValue` DECIMAL(10,2) NULL,
PRIMARY KEY (`KpiID`))
ENGINE = InnoDB;
-- -----------------------------------------------------
-- Table `mydb`.`SalesAnalytics`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `mydb`.`SalesAnalytics` (
`SaleAnalyticsID` INT NOT NULL AUTO_INCREMENT,
`SaleDate` TIMESTAMP NULL,
`Quantity` INT NULL,
`Revenue` DECIMAL(10,2) NULL,
`Products_ProductID` INT NOT NULL,
PRIMARY KEY (`SaleAnalyticsID`),
INDEX `fk_SalesAnalytics_Products1_idx` (`Products_ProductID` ASC) VISIBLE,
CONSTRAINT `fk_SalesAnalytics_Products1`
FOREIGN KEY (`Products_ProductID`)
REFERENCES `mydb`.`Products` (`ProductID`)
ON DELETE NO ACTION
ON UPDATE NO ACTION)
ENGINE = InnoDB;
-- -----------------------------------------------------
-- Table `mydb`.`ProductionAnalytics`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `mydb`.`ProductionAnalytics` (
`ProdAnalyticsID` INT NOT NULL AUTO_INCREMENT,
`ProductionDate` TIMESTAMP NULL,
`Quantity` INT NULL,
`Costs` DECIMAL(10,2) NULL,
`Products_ProductID` INT NOT NULL,
PRIMARY KEY (`ProdAnalyticsID`),
INDEX `fk_ProductionAnalytics_Products1_idx` (`Products_ProductID` ASC) VISIBLE,
CONSTRAINT `fk_ProductionAnalytics_Products1`
FOREIGN KEY (`Products_ProductID`)
REFERENCES `mydb`.`Products` (`ProductID`)
ON DELETE NO ACTION
ON UPDATE NO ACTION)
ENGINE = InnoDB;
-- -----------------------------------------------------
-- Table `mydb`.`InventoryAnalytics`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `mydb`.`InventoryAnalytics` (
`InvAnalyticsID` INT NOT NULL AUTO_INCREMENT,
`AnalysisDate` TIMESTAMP NULL,
`Quantity` INT NULL,
`Costs` DECIMAL(10,2) NULL,
`Materials_MaterialID` INT NOT NULL,
PRIMARY KEY (`InvAnalyticsID`),
INDEX `fk_InventoryAnalytics_Materials1_idx` (`Materials_MaterialID` ASC) VISIBLE,
CONSTRAINT `fk_InventoryAnalytics_Materials1`
FOREIGN KEY (`Materials_MaterialID`)
REFERENCES `mydb`.`Materials` (`MaterialID`)
ON DELETE NO ACTION
ON UPDATE NO ACTION)
ENGINE = InnoDB;
USE `mydb` ;
-- -----------------------------------------------------
-- Placeholder table for view `mydb`.`view1`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `mydb`.`view1` (`id` INT);
-- -----------------------------------------------------
-- Placeholder table for view `mydb`.`PopularProducts`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `mydb`.`PopularProducts` (`Name` INT, `UsageCount` INT);
-- -----------------------------------------------------
-- Placeholder table for view `mydb`.`ActiveOrders`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `mydb`.`ActiveOrders` (`OrderID` INT, `CustomerName` INT, `OrderDate` INT, `TotalAmount` INT, `Status` INT);
-- -----------------------------------------------------
-- Placeholder table for view `mydb`.`LowStockMaterials`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `mydb`.`LowStockMaterials` (`MaterialID` INT, `Name` INT, `StockQuantity` INT);
-- -----------------------------------------------------
-- View `mydb`.`view1`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `mydb`.`view1`;
USE `mydb`;
-- -----------------------------------------------------
-- View `mydb`.`PopularProducts`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `mydb`.`PopularProducts`;
USE `mydb`;
CREATE OR REPLACE VIEW PopularProducts AS
SELECT
p.Name,
COUNT(od.Products_ProductID) AS UsageCount
FROM OrderDetails od
JOIN Products p ON od.Products_ProductID = p.ProductID
GROUP BY od.Products_ProductID
ORDER BY UsageCount DESC
LIMIT 10;
/*
CREATE FUNCTION CalculateOrderTotal(OrderID INT) RETURNS DECIMAL(10, 2)
BEGIN
DECLARE TotGenerateOrdersReportal DECIMAL(10, 2);
SELECT SUM(m.PricePerUnit * od.Quantity) INTO Total
FROM OrderDetails od
JOIN Products p ON od.Products_ProductID = p.ProductID
WHERE od.OrderID = OrderID;
RETURN IFNULL(Total, 0.00);
END;*/
-- -----------------------------------------------------
-- View `mydb`.`ActiveOrders`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `mydb`.`ActiveOrders`;
USE `mydb`;
CREATE OR REPLACE VIEW ActiveOrders AS
SELECT
o.OrderID,
c.Name AS CustomerName,
o.OrderDate,
o.TotalAmount,
os.StatusName AS Status
FROM Orders o
JOIN Customers c ON o.customers_CustomerID = c.CustomerID
JOIN OrderStatuses os ON o.OrderStatuses_StatusID = os.StatusID
WHERE os.StatusName = 'Active';
/*
USE `mydb`;
CREATE PROCEDURE GenerateOrdersReport (IN StartDate DATE, IN EndDate DATE)
BEGIN
SELECT
o.OrderID,
c.Name AS CustomerName,
o.OrderDate,
o.TotalAmount,
os.StatusName
FROM Orders o
JOIN Customers c ON o.Customers_CustomerID = c.CustomerID
JOIN OrderStatuses os ON o.OrderStatuses_StatusID = os.StatusID
WHERE o.OrderDate BETWEEN StartDate AND EndDate
END;
*/
-- -----------------------------------------------------
-- View `mydb`.`LowStockMaterials`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `mydb`.`LowStockMaterials`;
USE `mydb`;
CREATE OR REPLACE VIEW LowStockMaterials AS
SELECT
m.MaterialID,
m.Name,
mu.Quantity AS StockQuantity
FROM Materials m
JOIN MaterialUsage mu ON m.MaterialID = mu.Materials_MaterialID
WHERE mu.Quantity < 10;
/*
USE `mydb`;
CREATE FUNCTION IsMaterialAvailable(MaterialID INT, RequiredQuantity INT) RETURNS BOOLEAN
BEGIN
DECLARE AvailableQuantity INT;
SELECT Quantity INTO AvailableQuantity
FROM Stocks
WHERE Materials_MaterialID = MaterialID;
RETURN AvailableQuantity >= RequiredQuantity;
END;
*/
USE `mydb`;
DELIMITER $$
USE `mydb`$$
CREATE TRIGGER `LogCustomerUpdates`
AFTER UPDATE ON `Customers`
FOR EACH ROW
BEGIN
-- Логируем изменения имени клиента
IF OLD.Name <> NEW.Name THEN
INSERT INTO Reports (ReportName, CreationDate, ReportType)
VALUES (
CONCAT('Customer name changed from "', OLD.Name, '" to "', NEW.Name, '".'),
NOW(),
'Update'
);
END IF;
-- Логируем изменения контактной информации
IF OLD.ContactInfo <> NEW.ContactInfo THEN
INSERT INTO Reports (ReportName, CreationDate, ReportType)
VALUES (
CONCAT('Customer contact info changed for ID ', OLD.CustomerID),
NOW(),
'Update'
);
END IF;
END;$$
USE `mydb`$$
CREATE DEFINER = CURRENT_USER TRIGGER `mydb`.`Materials_BEFORE_INSERT`
BEFORE INSERT ON `Materials`
FOR EACH ROW
BEGIN
-- Проверяем, что цена больше нуля
IF NEW.PricePerUnit <= 0 THEN
-- Записываем ошибку в таблицу Reports
INSERT INTO Reports (ReportName, CreationDate, ReportType)
VALUES (
CONCAT('Error: Invalid price value for material with ID ', NEW.MaterialID),
NOW(),
'Error'
);
-- Генерируем ошибку для отмены вставки
SIGNAL SQLSTATE '45000'
SET MESSAGE_TEXT = 'Price must be greater than zero.';
END IF;
END$$
USE `mydb`$$
CREATE DEFINER = CURRENT_USER TRIGGER `mydb`.`Stocks_AFTER_INSERT` AFTER INSERT ON `Stocks` FOR EACH ROW
BEGIN
INSERT INTO StockMovements (OperationType, Quantity, Materials_MaterialID, Warehouses_WarehouseID)
VALUES ('Приход', NEW.Quantity, NEW.Materials_MaterialID, NEW.Warehouses_WarehouseID);
END$$
USE `mydb`$$
CREATE DEFINER = CURRENT_USER TRIGGER `mydb`.`Stocks_BEFORE_INSERT` BEFORE INSERT ON `Stocks` FOR EACH ROW
BEGIN
DECLARE CurrentStock INT;
-- Проверяем текущее количество товаров на складе
SELECT COALESCE(SUM(Quantity), 0) INTO CurrentStock
FROM Stocks
WHERE Warehouses_WarehouseID = NEW.Warehouses_WarehouseID;
IF (CurrentStock + NEW.Quantity) > 100000000 THEN
SIGNAL SQLSTATE '45000'
SET MESSAGE_TEXT = 'Warehouse capacity exceeded. Cannot add more items.';
END IF;
END$$
USE `mydb`$$
CREATE DEFINER = CURRENT_USER TRIGGER `mydb`.`Suppliers_BEFORE_DELETE` BEFORE DELETE ON `Suppliers` FOR EACH ROW
BEGIN
SIGNAL SQLSTATE '45000'
SET MESSAGE_TEXT = 'Deleting suppliers is not allowed.';
END$$
USE `mydb`$$
CREATE DEFINER = CURRENT_USER TRIGGER `mydb`.`Employees_AFTER_UPDATE` AFTER UPDATE ON `Employees` FOR EACH ROW
BEGIN
END$$
DELIMITER ;
SET SQL_MODE=@OLD_SQL_MODE;
SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;
-- -----------------------------------------------------
-- Data for table `mydb`.`OrderStatuses`
-- -----------------------------------------------------
START TRANSACTION;
USE `mydb`;
INSERT INTO `mydb`.`OrderStatuses` (`StatusID`, `StatusName`) VALUES (1, 'In Processing');
INSERT INTO `mydb`.`OrderStatuses` (`StatusID`, `StatusName`) VALUES (2, 'In Production');
INSERT INTO `mydb`.`OrderStatuses` (`StatusID`, `StatusName`) VALUES (3, 'Completed');
INSERT INTO `mydb`.`OrderStatuses` (`StatusID`, `StatusName`) VALUES (4, 'Cancelled');
INSERT INTO `mydb`.`OrderStatuses` (`StatusID`, `StatusName`) VALUES (5, 'Shipped');
INSERT INTO `mydb`.`OrderStatuses` (`StatusID`, `StatusName`) VALUES (6, 'Delivered');
INSERT INTO `mydb`.`OrderStatuses` (`StatusID`, `StatusName`) VALUES (7, 'On Hold');
INSERT INTO `mydb`.`OrderStatuses` (`StatusID`, `StatusName`) VALUES (8, 'Returned');
INSERT INTO `mydb`.`OrderStatuses` (`StatusID`, `StatusName`) VALUES (9, 'Pending Payment');
INSERT INTO `mydb`.`OrderStatuses` (`StatusID`, `StatusName`) VALUES (10, 'Confirmed');
COMMIT;
-- -----------------------------------------------------
-- Data for table `mydb`.`Customers`
-- -----------------------------------------------------
START TRANSACTION;
USE `mydb`;
INSERT INTO `mydb`.`Customers` (`CustomerID`, `Name`, `ContactInfo`, `Adress`) VALUES (101, 'Ivan Ivanov', 'Phone: +79001234567', 'Lenin St.');
INSERT INTO `mydb`.`Customers` (`CustomerID`, `Name`, `ContactInfo`, `Adress`) VALUES (102, 'Petr Petrov', 'Email: [email protected]', 'Pushkin St.');
INSERT INTO `mydb`.`Customers` (`CustomerID`, `Name`, `ContactInfo`, `Adress`) VALUES (103, 'Anna Sidorova', 'Phone: +79001234568', 'Gagarin St.');
INSERT INTO `mydb`.`Customers` (`CustomerID`, `Name`, `ContactInfo`, `Adress`) VALUES (104, 'Mikhail Kuznetsov', 'Email: [email protected]', 'Mira St.');
INSERT INTO `mydb`.`Customers` (`CustomerID`, `Name`, `ContactInfo`, `Adress`) VALUES (105, 'Elena Morozova', 'Phone: +79001234569', 'Sovetskaya St.');
INSERT INTO `mydb`.`Customers` (`CustomerID`, `Name`, `ContactInfo`, `Adress`) VALUES (106, 'Dmitry Nikolaev', 'Email: [email protected]', 'Central St.');
INSERT INTO `mydb`.`Customers` (`CustomerID`, `Name`, `ContactInfo`, `Adress`) VALUES (107, 'Olga Fedorova', 'Phone: +79001234570', 'Naberezhnaya St.');
INSERT INTO `mydb`.`Customers` (`CustomerID`, `Name`, `ContactInfo`, `Adress`) VALUES (108, 'Andrey Alekseev', 'Email: [email protected]', 'Zarechnaya St.');
INSERT INTO `mydb`.`Customers` (`CustomerID`, `Name`, `ContactInfo`, `Adress`) VALUES (109, 'Maria Smirnova', 'Phone: +79001234571', 'Yuzhnaya St.');
INSERT INTO `mydb`.`Customers` (`CustomerID`, `Name`, `ContactInfo`, `Adress`) VALUES (110, 'Sergey Vasiliev', 'Email: [email protected]', 'Severnaya St.');
INSERT INTO `mydb`.`Customers` (`CustomerID`, `Name`, `ContactInfo`, `Adress`) VALUES (111, 'Tatyana Kovaleva', 'Phone: +79001234572', 'Vostochnaya St.');
INSERT INTO `mydb`.`Customers` (`CustomerID`, `Name`, `ContactInfo`, `Adress`) VALUES (112, 'Alexander Mikhailov', 'Email: [email protected]', 'Zapadnaya St.');
INSERT INTO `mydb`.`Customers` (`CustomerID`, `Name`, `ContactInfo`, `Adress`) VALUES (113, 'Darya Egorova', 'Phone: +79001234573', 'Pervomayskaya St.');
INSERT INTO `mydb`.`Customers` (`CustomerID`, `Name`, `ContactInfo`, `Adress`) VALUES (114, 'Igor Pavlov', 'Email: [email protected]', 'Krasnaya St.');
INSERT INTO `mydb`.`Customers` (`CustomerID`, `Name`, `ContactInfo`, `Adress`) VALUES (115, 'Ekaterina Sokolova', 'Phone: +79001234574', 'Bolshaya St.');
INSERT INTO `mydb`.`Customers` (`CustomerID`, `Name`, `ContactInfo`, `Adress`) VALUES (116, 'Artem Zakharyov', 'Email: [email protected]', 'Malaya St.');
INSERT INTO `mydb`.`Customers` (`CustomerID`, `Name`, `ContactInfo`, `Adress`) VALUES (117, 'Anastasia Belova', 'Phone: +79001234575', 'Lesnaya St.');
INSERT INTO `mydb`.`Customers` (`CustomerID`, `Name`, `ContactInfo`, `Adress`) VALUES (118, 'Maxim Grigoryev', 'Email: [email protected]', 'Polevaya St.');
INSERT INTO `mydb`.`Customers` (`CustomerID`, `Name`, `ContactInfo`, `Adress`) VALUES (119, 'Victoria Romanova', 'Phone: +79001234576', 'Gornaya St.');
INSERT INTO `mydb`.`Customers` (`CustomerID`, `Name`, `ContactInfo`, `Adress`) VALUES (120, 'Vladimir Shevchenko', 'Email: [email protected]', 'Rechnaya St.');
INSERT INTO `mydb`.`Customers` (`CustomerID`, `Name`, `ContactInfo`, `Adress`) VALUES (121, 'Natalya Kuznetsova', 'Phone: +79001234577', 'Sadovaya St.');
INSERT INTO `mydb`.`Customers` (`CustomerID`, `Name`, `ContactInfo`, `Adress`) VALUES (122, 'Dmitry Lebedev', 'Email: [email protected]', 'Parkovaya St.');
INSERT INTO `mydb`.`Customers` (`CustomerID`, `Name`, `ContactInfo`, `Adress`) VALUES (123, 'Elena Orlova', 'Phone: +79001234578', 'Shkolnaya St.');
INSERT INTO `mydb`.`Customers` (`CustomerID`, `Name`, `ContactInfo`, `Adress`) VALUES (124, 'Andrey Semenov', 'Email: [email protected]', 'Tsvetochnaya St.');
INSERT INTO `mydb`.`Customers` (`CustomerID`, `Name`, `ContactInfo`, `Adress`) VALUES (125, 'Mikhail Kovalev', 'Phone: +79001234579', 'Stroiteley St.');
INSERT INTO `mydb`.`Customers` (`CustomerID`, `Name`, `ContactInfo`, `Adress`) VALUES (126, 'Anna Volkova', 'Email: [email protected]', 'Trudovaya St.');
INSERT INTO `mydb`.`Customers` (`CustomerID`, `Name`, `ContactInfo`, `Adress`) VALUES (127, 'Ivan Morozov', 'Phone: +79001234580', 'Proletarskaya St.');
INSERT INTO `mydb`.`Customers` (`CustomerID`, `Name`, `ContactInfo`, `Adress`) VALUES (128, 'Artem Nikitin', 'Email: [email protected]', 'Zavodskaya St.');
INSERT INTO `mydb`.`Customers` (`CustomerID`, `Name`, `ContactInfo`, `Adress`) VALUES (129, 'Sergey Fedorov', 'Phone: +79001234581', 'Beregovaya St.');
INSERT INTO `mydb`.`Customers` (`CustomerID`, `Name`, `ContactInfo`, `Adress`) VALUES (130, 'Olga Andreyeva', 'Email: [email protected]', 'Lugovaya St.');
INSERT INTO `mydb`.`Customers` (`CustomerID`, `Name`, `ContactInfo`, `Adress`) VALUES (131, 'Dmitry Kozlov', 'Phone: +79001234582', 'Novaya St.');
INSERT INTO `mydb`.`Customers` (`CustomerID`, `Name`, `ContactInfo`, `Adress`) VALUES (132, 'Maria Vasilieva', 'Email: [email protected]', 'Staraya St.');
INSERT INTO `mydb`.`Customers` (`CustomerID`, `Name`, `ContactInfo`, `Adress`) VALUES (133, 'Alexander Popov', 'Phone: +79001234583', 'Chistaya St.');
INSERT INTO `mydb`.`Customers` (`CustomerID`, `Name`, `ContactInfo`, `Adress`) VALUES (134, 'Igor Sokolov', 'Email: [email protected]', 'Dachnaya St.');
INSERT INTO `mydb`.`Customers` (`CustomerID`, `Name`, `ContactInfo`, `Adress`) VALUES (135, 'Darya Zaitseva', 'Phone: +79001234584', 'Lugovaya St.');
INSERT INTO `mydb`.`Customers` (`CustomerID`, `Name`, `ContactInfo`, `Adress`) VALUES (136, 'Mikhail Belyaev', 'Email: [email protected]', 'Sosnovaya St.');
INSERT INTO `mydb`.`Customers` (`CustomerID`, `Name`, `ContactInfo`, `Adress`) VALUES (137, 'Ekaterina Krylova', 'Phone: +79001234585', 'Yablonevaya St.');
INSERT INTO `mydb`.`Customers` (`CustomerID`, `Name`, `ContactInfo`, `Adress`) VALUES (138, 'Artem Gusev', 'Email: [email protected]', 'Vishnevaya St.');
INSERT INTO `mydb`.`Customers` (`CustomerID`, `Name`, `ContactInfo`, `Adress`) VALUES (139, 'Anastasia Makarova', 'Phone: +79001234586', 'Chereshevaya St.');
INSERT INTO `mydb`.`Customers` (`CustomerID`, `Name`, `ContactInfo`, `Adress`) VALUES (140, 'Maxim Novikov', 'Email: [email protected]', 'Grushevaya St.');
INSERT INTO `mydb`.`Customers` (`CustomerID`, `Name`, `ContactInfo`, `Adress`) VALUES (141, 'Dmitry Volkov', 'Phone: +79001234587', 'Persikovaya St.');
INSERT INTO `mydb`.`Customers` (`CustomerID`, `Name`, `ContactInfo`, `Adress`) VALUES (142, 'Olga Kudryavtseva', 'Email: [email protected]', 'Abrikosovaya St.');
INSERT INTO `mydb`.`Customers` (`CustomerID`, `Name`, `ContactInfo`, `Adress`) VALUES (143, 'Alexander Lazarev', 'Phone: +79001234588', 'Vinogradnaya St.');
INSERT INTO `mydb`.`Customers` (`CustomerID`, `Name`, `ContactInfo`, `Adress`) VALUES (144, 'Andrey Medvedev', 'Email: [email protected]', 'Klubnichnaya St.');
INSERT INTO `mydb`.`Customers` (`CustomerID`, `Name`, `ContactInfo`, `Adress`) VALUES (145, 'Elena Yermakova', 'Phone: +79001234589', 'Malinovaya St.');
INSERT INTO `mydb`.`Customers` (`CustomerID`, `Name`, `ContactInfo`, `Adress`) VALUES (146, 'Sergey Danilov', 'Email: [email protected]', 'Smorodinovaya St.');
INSERT INTO `mydb`.`Customers` (`CustomerID`, `Name`, `ContactInfo`, `Adress`) VALUES (147, 'Maria Zhukova', 'Phone: +79001234590', 'Klyukvennaya St.');
INSERT INTO `mydb`.`Customers` (`CustomerID`, `Name`, `ContactInfo`, `Adress`) VALUES (148, 'Dmitry Karpov', 'Email: [email protected]', 'Brusnichnaya St.');
INSERT INTO `mydb`.`Customers` (`CustomerID`, `Name`, `ContactInfo`, `Adress`) VALUES (149, 'Anna Filippova', 'Phone: +79001234591', 'Oblepikhovaya St.');
INSERT INTO `mydb`.`Customers` (`CustomerID`, `Name`, `ContactInfo`, `Adress`) VALUES (150, 'Mikhail Stepanov', 'Email: [email protected]', 'Ryabinovaya St.');
COMMIT;
-- -----------------------------------------------------
-- Data for table `mydb`.`Orders`
-- -----------------------------------------------------
START TRANSACTION;
USE `mydb`;
INSERT INTO `mydb`.`Orders` (`OrderID`, `OrderDate`, `TotalAmount`, `OrderStatuses_StatusID`, `Customers_CustomerID`) VALUES (1, '2023-01-05 10:00:00', 450.00, 1, 101);
INSERT INTO `mydb`.`Orders` (`OrderID`, `OrderDate`, `TotalAmount`, `OrderStatuses_StatusID`, `Customers_CustomerID`) VALUES (2, '2023-01-06 11:00:00', 1200.50, 2, 102);
INSERT INTO `mydb`.`Orders` (`OrderID`, `OrderDate`, `TotalAmount`, `OrderStatuses_StatusID`, `Customers_CustomerID`) VALUES (3, '2023-01-07 12:00:00', 890.75, 1, 103);
INSERT INTO `mydb`.`Orders` (`OrderID`, `OrderDate`, `TotalAmount`, `OrderStatuses_StatusID`, `Customers_CustomerID`) VALUES (4, '2023-01-08 13:00:00', 250.00, 3, 104);
INSERT INTO `mydb`.`Orders` (`OrderID`, `OrderDate`, `TotalAmount`, `OrderStatuses_StatusID`, `Customers_CustomerID`) VALUES (5, '2023-01-09 14:00:00', 670.25, 1, 105);
INSERT INTO `mydb`.`Orders` (`OrderID`, `OrderDate`, `TotalAmount`, `OrderStatuses_StatusID`, `Customers_CustomerID`) VALUES (6, '2023-01-10 15:00:00', 1500.00, 2, 106);
INSERT INTO `mydb`.`Orders` (`OrderID`, `OrderDate`, `TotalAmount`, `OrderStatuses_StatusID`, `Customers_CustomerID`) VALUES (7, '2023-01-11 16:00:00', 340.50, 1, 107);
INSERT INTO `mydb`.`Orders` (`OrderID`, `OrderDate`, `TotalAmount`, `OrderStatuses_StatusID`, `Customers_CustomerID`) VALUES (8, '2023-01-12 17:00:00', 950.00, 3, 108);
INSERT INTO `mydb`.`Orders` (`OrderID`, `OrderDate`, `TotalAmount`, `OrderStatuses_StatusID`, `Customers_CustomerID`) VALUES (9, '2023-01-13 18:00:00', 780.00, 1, 109);
INSERT INTO `mydb`.`Orders` (`OrderID`, `OrderDate`, `TotalAmount`, `OrderStatuses_StatusID`, `Customers_CustomerID`) VALUES (10, '2023-01-14 19:00:00', 1100.75, 2, 110);
INSERT INTO `mydb`.`Orders` (`OrderID`, `OrderDate`, `TotalAmount`, `OrderStatuses_StatusID`, `Customers_CustomerID`) VALUES (11, '2023-01-15 20:00:00', 500.00, 1, 111);
INSERT INTO `mydb`.`Orders` (`OrderID`, `OrderDate`, `TotalAmount`, `OrderStatuses_StatusID`, `Customers_CustomerID`) VALUES (12, '2023-01-16 21:00:00', 1300.50, 3, 112);
INSERT INTO `mydb`.`Orders` (`OrderID`, `OrderDate`, `TotalAmount`, `OrderStatuses_StatusID`, `Customers_CustomerID`) VALUES (13, '2023-01-17 22:00:00', 450.00, 1, 113);
INSERT INTO `mydb`.`Orders` (`OrderID`, `OrderDate`, `TotalAmount`, `OrderStatuses_StatusID`, `Customers_CustomerID`) VALUES (14, '2023-01-18 23:00:00', 890.75, 2, 114);
INSERT INTO `mydb`.`Orders` (`OrderID`, `OrderDate`, `TotalAmount`, `OrderStatuses_StatusID`, `Customers_CustomerID`) VALUES (15, '2023-01-19 00:00:00', 250.00, 1, 115);
INSERT INTO `mydb`.`Orders` (`OrderID`, `OrderDate`, `TotalAmount`, `OrderStatuses_StatusID`, `Customers_CustomerID`) VALUES (16, '2023-01-20 01:00:00', 670.25, 3, 116);
INSERT INTO `mydb`.`Orders` (`OrderID`, `OrderDate`, `TotalAmount`, `OrderStatuses_StatusID`, `Customers_CustomerID`) VALUES (17, '2023-01-21 02:00:00', 1500.00, 1, 117);
INSERT INTO `mydb`.`Orders` (`OrderID`, `OrderDate`, `TotalAmount`, `OrderStatuses_StatusID`, `Customers_CustomerID`) VALUES (18, '2023-01-22 03:00:00', 340.50, 2, 118);
INSERT INTO `mydb`.`Orders` (`OrderID`, `OrderDate`, `TotalAmount`, `OrderStatuses_StatusID`, `Customers_CustomerID`) VALUES (19, '2023-01-23 04:00:00', 950.00, 1, 119);
INSERT INTO `mydb`.`Orders` (`OrderID`, `OrderDate`, `TotalAmount`, `OrderStatuses_StatusID`, `Customers_CustomerID`) VALUES (20, '2023-01-24 05:00:00', 780.00, 3, 120);
INSERT INTO `mydb`.`Orders` (`OrderID`, `OrderDate`, `TotalAmount`, `OrderStatuses_StatusID`, `Customers_CustomerID`) VALUES (21, '2023-01-25 06:00:00', 1100.75, 1, 121);
INSERT INTO `mydb`.`Orders` (`OrderID`, `OrderDate`, `TotalAmount`, `OrderStatuses_StatusID`, `Customers_CustomerID`) VALUES (22, '2023-01-26 07:00:00', 500.00, 2, 122);
INSERT INTO `mydb`.`Orders` (`OrderID`, `OrderDate`, `TotalAmount`, `OrderStatuses_StatusID`, `Customers_CustomerID`) VALUES (23, '2023-01-27 08:00:00', 1300.50, 1, 123);
INSERT INTO `mydb`.`Orders` (`OrderID`, `OrderDate`, `TotalAmount`, `OrderStatuses_StatusID`, `Customers_CustomerID`) VALUES (24, '2023-01-28 09:00:00', 450.00, 3, 124);
INSERT INTO `mydb`.`Orders` (`OrderID`, `OrderDate`, `TotalAmount`, `OrderStatuses_StatusID`, `Customers_CustomerID`) VALUES (25, '2023-01-29 10:00:00', 890.75, 1, 125);
INSERT INTO `mydb`.`Orders` (`OrderID`, `OrderDate`, `TotalAmount`, `OrderStatuses_StatusID`, `Customers_CustomerID`) VALUES (26, '2023-01-30 11:00:00', 250.00, 2, 126);
INSERT INTO `mydb`.`Orders` (`OrderID`, `OrderDate`, `TotalAmount`, `OrderStatuses_StatusID`, `Customers_CustomerID`) VALUES (27, '2023-01-31 12:00:00', 670.25, 1, 127);
INSERT INTO `mydb`.`Orders` (`OrderID`, `OrderDate`, `TotalAmount`, `OrderStatuses_StatusID`, `Customers_CustomerID`) VALUES (28, '2023-02-01 13:00:00', 1500.00, 3, 128);
INSERT INTO `mydb`.`Orders` (`OrderID`, `OrderDate`, `TotalAmount`, `OrderStatuses_StatusID`, `Customers_CustomerID`) VALUES (29, '2023-02-02 14:00:00', 340.50, 1, 129);
INSERT INTO `mydb`.`Orders` (`OrderID`, `OrderDate`, `TotalAmount`, `OrderStatuses_StatusID`, `Customers_CustomerID`) VALUES (30, '2023-02-03 15:00:00', 950.00, 2, 130);
INSERT INTO `mydb`.`Orders` (`OrderID`, `OrderDate`, `TotalAmount`, `OrderStatuses_StatusID`, `Customers_CustomerID`) VALUES (31, '2023-02-04 16:00:00', 780.00, 1, 131);
INSERT INTO `mydb`.`Orders` (`OrderID`, `OrderDate`, `TotalAmount`, `OrderStatuses_StatusID`, `Customers_CustomerID`) VALUES (32, '2023-02-05 17:00:00', 1100.75, 3, 132);
INSERT INTO `mydb`.`Orders` (`OrderID`, `OrderDate`, `TotalAmount`, `OrderStatuses_StatusID`, `Customers_CustomerID`) VALUES (33, '2023-02-06 18:00:00', 500.00, 1, 133);
INSERT INTO `mydb`.`Orders` (`OrderID`, `OrderDate`, `TotalAmount`, `OrderStatuses_StatusID`, `Customers_CustomerID`) VALUES (34, '2023-02-07 19:00:00', 1300.50, 2, 134);
INSERT INTO `mydb`.`Orders` (`OrderID`, `OrderDate`, `TotalAmount`, `OrderStatuses_StatusID`, `Customers_CustomerID`) VALUES (35, '2023-02-08 20:00:00', 450.00, 1, 135);
INSERT INTO `mydb`.`Orders` (`OrderID`, `OrderDate`, `TotalAmount`, `OrderStatuses_StatusID`, `Customers_CustomerID`) VALUES (36, '2023-02-09 21:00:00', 890.75, 3, 136);
INSERT INTO `mydb`.`Orders` (`OrderID`, `OrderDate`, `TotalAmount`, `OrderStatuses_StatusID`, `Customers_CustomerID`) VALUES (37, '2023-02-10 22:00:00', 250.00, 1, 137);
INSERT INTO `mydb`.`Orders` (`OrderID`, `OrderDate`, `TotalAmount`, `OrderStatuses_StatusID`, `Customers_CustomerID`) VALUES (38, '2023-02-11 23:00:00', 670.25, 2, 138);
INSERT INTO `mydb`.`Orders` (`OrderID`, `OrderDate`, `TotalAmount`, `OrderStatuses_StatusID`, `Customers_CustomerID`) VALUES (39, '2023-02-12 00:00:00', 1500.00, 1, 139);
INSERT INTO `mydb`.`Orders` (`OrderID`, `OrderDate`, `TotalAmount`, `OrderStatuses_StatusID`, `Customers_CustomerID`) VALUES (40, '2023-02-13 01:00:00', 340.50, 3, 140);
INSERT INTO `mydb`.`Orders` (`OrderID`, `OrderDate`, `TotalAmount`, `OrderStatuses_StatusID`, `Customers_CustomerID`) VALUES (41, '2023-02-14 02:00:00', 950.00, 1, 141);
INSERT INTO `mydb`.`Orders` (`OrderID`, `OrderDate`, `TotalAmount`, `OrderStatuses_StatusID`, `Customers_CustomerID`) VALUES (42, '2023-02-15 03:00:00', 780.00, 2, 142);
INSERT INTO `mydb`.`Orders` (`OrderID`, `OrderDate`, `TotalAmount`, `OrderStatuses_StatusID`, `Customers_CustomerID`) VALUES (43, '2023-02-16 04:00:00', 1100.75, 1, 143);
INSERT INTO `mydb`.`Orders` (`OrderID`, `OrderDate`, `TotalAmount`, `OrderStatuses_StatusID`, `Customers_CustomerID`) VALUES (44, '2023-02-17 05:00:00', 500.00, 3, 144);
INSERT INTO `mydb`.`Orders` (`OrderID`, `OrderDate`, `TotalAmount`, `OrderStatuses_StatusID`, `Customers_CustomerID`) VALUES (45, '2023-02-18 06:00:00', 1300.50, 1, 145);
INSERT INTO `mydb`.`Orders` (`OrderID`, `OrderDate`, `TotalAmount`, `OrderStatuses_StatusID`, `Customers_CustomerID`) VALUES (46, '2023-02-19 07:00:00', 450.00, 2, 146);
INSERT INTO `mydb`.`Orders` (`OrderID`, `OrderDate`, `TotalAmount`, `OrderStatuses_StatusID`, `Customers_CustomerID`) VALUES (47, '2023-02-20 08:00:00', 890.75, 1, 147);
INSERT INTO `mydb`.`Orders` (`OrderID`, `OrderDate`, `TotalAmount`, `OrderStatuses_StatusID`, `Customers_CustomerID`) VALUES (48, '2023-02-21 09:00:00', 250.00, 3, 148);
INSERT INTO `mydb`.`Orders` (`OrderID`, `OrderDate`, `TotalAmount`, `OrderStatuses_StatusID`, `Customers_CustomerID`) VALUES (49, '2023-02-22 10:00:00', 670.25, 1, 149);
INSERT INTO `mydb`.`Orders` (`OrderID`, `OrderDate`, `TotalAmount`, `OrderStatuses_StatusID`, `Customers_CustomerID`) VALUES (50, '2023-02-23 11:00:00', 1500.00, 2, 150);
COMMIT;
-- -----------------------------------------------------
-- Data for table `mydb`.`ProductsCategories`
-- -----------------------------------------------------
START TRANSACTION;
USE `mydb`;
INSERT INTO `mydb`.`ProductsCategories` (`ProductCategoryID`, `CategoryName`) VALUES (1, 'Windows');
INSERT INTO `mydb`.`ProductsCategories` (`ProductCategoryID`, `CategoryName`) VALUES (2, 'Doors');
INSERT INTO `mydb`.`ProductsCategories` (`ProductCategoryID`, `CategoryName`) VALUES (3, 'Glass Systems');
COMMIT;
-- -----------------------------------------------------
-- Data for table `mydb`.`Products`
-- -----------------------------------------------------
START TRANSACTION;
USE `mydb`;
INSERT INTO `mydb`.`Products` (`ProductID`, `Name`, `Description`, `ProductsCategories_ProductCategoryID`) VALUES (201, 'Double Glazed Window', 'Energy-efficient window with double glazing', 1);
INSERT INTO `mydb`.`Products` (`ProductID`, `Name`, `Description`, `ProductsCategories_ProductCategoryID`) VALUES (202, 'Triple Glazed Window', 'High insulation window with triple glazing', 1);
INSERT INTO `mydb`.`Products` (`ProductID`, `Name`, `Description`, `ProductsCategories_ProductCategoryID`) VALUES (203, 'Sliding Door', 'Large sliding door for balconies', 2);
INSERT INTO `mydb`.`Products` (`ProductID`, `Name`, `Description`, `ProductsCategories_ProductCategoryID`) VALUES (204, 'French Window', 'Classic design window with two opening sashes', 1);
INSERT INTO `mydb`.`Products` (`ProductID`, `Name`, `Description`, `ProductsCategories_ProductCategoryID`) VALUES (205, 'Balcony Door', 'Standard balcony door with single glazing', 2);
INSERT INTO `mydb`.`Products` (`ProductID`, `Name`, `Description`, `ProductsCategories_ProductCategoryID`) VALUES (206, 'Folding Window', 'Space-saving folding window system', 1);
INSERT INTO `mydb`.`Products` (`ProductID`, `Name`, `Description`, `ProductsCategories_ProductCategoryID`) VALUES (207, 'Custom Window', 'Customizable window design', 1);
INSERT INTO `mydb`.`Products` (`ProductID`, `Name`, `Description`, `ProductsCategories_ProductCategoryID`) VALUES (208, 'Security Door', 'Reinforced door with advanced locking mechanism', 2);
INSERT INTO `mydb`.`Products` (`ProductID`, `Name`, `Description`, `ProductsCategories_ProductCategoryID`) VALUES (209, 'Skylight Window', 'Roof-mounted window for natural light', 1);
INSERT INTO `mydb`.`Products` (`ProductID`, `Name`, `Description`, `ProductsCategories_ProductCategoryID`) VALUES (210, 'Soundproof Window', 'Window designed to reduce noise', 1);
INSERT INTO `mydb`.`Products` (`ProductID`, `Name`, `Description`, `ProductsCategories_ProductCategoryID`) VALUES (211, 'Thermal Insulated Window', 'Window optimized for thermal insulation', 1);
INSERT INTO `mydb`.`Products` (`ProductID`, `Name`, `Description`, `ProductsCategories_ProductCategoryID`) VALUES (212, 'Aluminum Frame Window', 'Durable window with aluminum frame', 1);
INSERT INTO `mydb`.`Products` (`ProductID`, `Name`, `Description`, `ProductsCategories_ProductCategoryID`) VALUES (213, 'PVC Frame Window', 'Cost-effective PVC framed window', 1);
INSERT INTO `mydb`.`Products` (`ProductID`, `Name`, `Description`, `ProductsCategories_ProductCategoryID`) VALUES (214, 'Steel Reinforced Door', 'Heavy-duty door with steel reinforcement', 2);
INSERT INTO `mydb`.`Products` (`ProductID`, `Name`, `Description`, `ProductsCategories_ProductCategoryID`) VALUES (215, 'Glass Partition Wall', 'Interior glass partition wall', 3);
INSERT INTO `mydb`.`Products` (`ProductID`, `Name`, `Description`, `ProductsCategories_ProductCategoryID`) VALUES (216, 'Curtain Wall System', 'Large glass facade system', 3);
INSERT INTO `mydb`.`Products` (`ProductID`, `Name`, `Description`, `ProductsCategories_ProductCategoryID`) VALUES (217, 'Security Glass Window', 'Window with laminated security glass', 1);
INSERT INTO `mydb`.`Products` (`ProductID`, `Name`, `Description`, `ProductsCategories_ProductCategoryID`) VALUES (218, 'UV Protected Window', 'Window with UV protection coating', 1);
INSERT INTO `mydb`.`Products` (`ProductID`, `Name`, `Description`, `ProductsCategories_ProductCategoryID`) VALUES (219, 'Energy Saving Window', 'Window with low-emissivity glass', 1);
INSERT INTO `mydb`.`Products` (`ProductID`, `Name`, `Description`, `ProductsCategories_ProductCategoryID`) VALUES (220, 'Acoustic Insulated Window', 'Window designed for sound insulation', 1);
INSERT INTO `mydb`.`Products` (`ProductID`, `Name`, `Description`, `ProductsCategories_ProductCategoryID`) VALUES (221, 'Fixed Glass Panel', 'Non-opening decorative glass panel', 3);
INSERT INTO `mydb`.`Products` (`ProductID`, `Name`, `Description`, `ProductsCategories_ProductCategoryID`) VALUES (222, 'Swing Door', 'Standard swing door with handle', 2);
INSERT INTO `mydb`.`Products` (`ProductID`, `Name`, `Description`, `ProductsCategories_ProductCategoryID`) VALUES (223, 'Automatic Sliding Door', 'Automatic door system for commercial use', 2);
INSERT INTO `mydb`.`Products` (`ProductID`, `Name`, `Description`, `ProductsCategories_ProductCategoryID`) VALUES (224, 'Folding Sliding Door', 'Combination of folding and sliding mechanisms', 2);
INSERT INTO `mydb`.`Products` (`ProductID`, `Name`, `Description`, `ProductsCategories_ProductCategoryID`) VALUES (225, 'Fire Rated Window', 'Window with fire-resistant glass', 1);
INSERT INTO `mydb`.`Products` (`ProductID`, `Name`, `Description`, `ProductsCategories_ProductCategoryID`) VALUES (226, 'Decorative Window', 'Window with artistic patterns', 1);
INSERT INTO `mydb`.`Products` (`ProductID`, `Name`, `Description`, `ProductsCategories_ProductCategoryID`) VALUES (227, 'Skylight Dome', 'Dome-shaped skylight for roofs', 1);
INSERT INTO `mydb`.`Products` (`ProductID`, `Name`, `Description`, `ProductsCategories_ProductCategoryID`) VALUES (228, 'Wooden Frame Window', 'Window with wooden frame finish', 1);
INSERT INTO `mydb`.`Products` (`ProductID`, `Name`, `Description`, `ProductsCategories_ProductCategoryID`) VALUES (229, 'Composite Frame Window', 'Window with composite material frame', 1);
INSERT INTO `mydb`.`Products` (`ProductID`, `Name`, `Description`, `ProductsCategories_ProductCategoryID`) VALUES (230, 'Glass Balustrade', 'Glass railing system for balconies', 3);
INSERT INTO `mydb`.`Products` (`ProductID`, `Name`, `Description`, `ProductsCategories_ProductCategoryID`) VALUES (231, 'Laminated Glass Window', 'Window with safety laminated glass', 1);
INSERT INTO `mydb`.`Products` (`ProductID`, `Name`, `Description`, `ProductsCategories_ProductCategoryID`) VALUES (232, 'Tinted Glass Window', 'Window with tinted glass for privacy', 1);
INSERT INTO `mydb`.`Products` (`ProductID`, `Name`, `Description`, `ProductsCategories_ProductCategoryID`) VALUES (233, 'Low Iron Glass Window', 'Window with extra-clear low-iron glass', 1);
INSERT INTO `mydb`.`Products` (`ProductID`, `Name`, `Description`, `ProductsCategories_ProductCategoryID`) VALUES (234, 'Reflective Glass Window', 'Window with reflective coating', 1);
INSERT INTO `mydb`.`Products` (`ProductID`, `Name`, `Description`, `ProductsCategories_ProductCategoryID`) VALUES (235, 'Insulated Glass Unit', 'Double-glazed unit with argon gas filling', 1);
INSERT INTO `mydb`.`Products` (`ProductID`, `Name`, `Description`, `ProductsCategories_ProductCategoryID`) VALUES (236, 'Frameless Glass Door', 'Modern frameless glass door', 2);
INSERT INTO `mydb`.`Products` (`ProductID`, `Name`, `Description`, `ProductsCategories_ProductCategoryID`) VALUES (237, 'Sliding Patio Door', 'Large sliding door for patios', 2);
INSERT INTO `mydb`.`Products` (`ProductID`, `Name`, `Description`, `ProductsCategories_ProductCategoryID`) VALUES (238, 'Frosted Glass Window', 'Window with frosted glass for privacy', 1);
INSERT INTO `mydb`.`Products` (`ProductID`, `Name`, `Description`, `ProductsCategories_ProductCategoryID`) VALUES (239, 'Heat Strengthened Glass', 'Window with heat-strengthened glass', 1);
INSERT INTO `mydb`.`Products` (`ProductID`, `Name`, `Description`, `ProductsCategories_ProductCategoryID`) VALUES (240, 'Vacuum Insulated Glass', 'Window with vacuum-insulated glass', 1);
INSERT INTO `mydb`.`Products` (`ProductID`, `Name`, `Description`, `ProductsCategories_ProductCategoryID`) VALUES (241, 'Electric Awning Window', 'Window with electric awning mechanism', 1);
INSERT INTO `mydb`.`Products` (`ProductID`, `Name`, `Description`, `ProductsCategories_ProductCategoryID`) VALUES (242, 'Sliding Folding Door', 'Door with sliding and folding mechanism', 2);
INSERT INTO `mydb`.`Products` (`ProductID`, `Name`, `Description`, `ProductsCategories_ProductCategoryID`) VALUES (243, 'Glass Facade System', 'Large-scale glass facade system', 3);
INSERT INTO `mydb`.`Products` (`ProductID`, `Name`, `Description`, `ProductsCategories_ProductCategoryID`) VALUES (244, 'Structural Glazing System', 'Frameless structural glazing system', 3);
INSERT INTO `mydb`.`Products` (`ProductID`, `Name`, `Description`, `ProductsCategories_ProductCategoryID`) VALUES (245, 'Solar Control Window', 'Window with solar control coating', 1);
INSERT INTO `mydb`.`Products` (`ProductID`, `Name`, `Description`, `ProductsCategories_ProductCategoryID`) VALUES (246, 'Noise Reduction Window', 'Window designed for noise reduction', 1);
INSERT INTO `mydb`.`Products` (`ProductID`, `Name`, `Description`, `ProductsCategories_ProductCategoryID`) VALUES (247, 'Energy Efficient Door', 'Thermally efficient door system', 2);
INSERT INTO `mydb`.`Products` (`ProductID`, `Name`, `Description`, `ProductsCategories_ProductCategoryID`) VALUES (248, 'Glass Canopy', 'Decorative glass canopy for entrances', 3);
INSERT INTO `mydb`.`Products` (`ProductID`, `Name`, `Description`, `ProductsCategories_ProductCategoryID`) VALUES (249, 'Glass Floor Panel', 'Walkable glass floor panel', 3);
INSERT INTO `mydb`.`Products` (`ProductID`, `Name`, `Description`, `ProductsCategories_ProductCategoryID`) VALUES (250, 'Glass Staircase', 'Modern glass staircase system', 3);
COMMIT;
-- -----------------------------------------------------
-- Data for table `mydb`.`OrderDetails`
-- -----------------------------------------------------
START TRANSACTION;
USE `mydb`;
INSERT INTO `mydb`.`OrderDetails` (`OrderDetailID`, `Price`, `Orders_OrderID`, `Products_ProductID`) VALUES (1, 225.00, 1, 201);
INSERT INTO `mydb`.`OrderDetails` (`OrderDetailID`, `Price`, `Orders_OrderID`, `Products_ProductID`) VALUES (2, 400.17, 2, 202);
INSERT INTO `mydb`.`OrderDetails` (`OrderDetailID`, `Price`, `Orders_OrderID`, `Products_ProductID`) VALUES (3, 890.75, 3, 203);
INSERT INTO `mydb`.`OrderDetails` (`OrderDetailID`, `Price`, `Orders_OrderID`, `Products_ProductID`) VALUES (4, 50.00, 4, 204);
INSERT INTO `mydb`.`OrderDetails` (`OrderDetailID`, `Price`, `Orders_OrderID`, `Products_ProductID`) VALUES (5, 335.13, 5, 205);
INSERT INTO `mydb`.`OrderDetails` (`OrderDetailID`, `Price`, `Orders_OrderID`, `Products_ProductID`) VALUES (6, 375.00, 6, 206);
INSERT INTO `mydb`.`OrderDetails` (`OrderDetailID`, `Price`, `Orders_OrderID`, `Products_ProductID`) VALUES (7, 113.50, 7, 207);
INSERT INTO `mydb`.`OrderDetails` (`OrderDetailID`, `Price`, `Orders_OrderID`, `Products_ProductID`) VALUES (8, 475.00, 8, 208);
INSERT INTO `mydb`.`OrderDetails` (`OrderDetailID`, `Price`, `Orders_OrderID`, `Products_ProductID`) VALUES (9, 195.00, 9, 209);
INSERT INTO `mydb`.`OrderDetails` (`OrderDetailID`, `Price`, `Orders_OrderID`, `Products_ProductID`) VALUES (10, 366.92, 10, 210);
INSERT INTO `mydb`.`OrderDetails` (`OrderDetailID`, `Price`, `Orders_OrderID`, `Products_ProductID`) VALUES (11, 500.00, 11, 211);
INSERT INTO `mydb`.`OrderDetails` (`OrderDetailID`, `Price`, `Orders_OrderID`, `Products_ProductID`) VALUES (12, 260.10, 12, 212);
INSERT INTO `mydb`.`OrderDetails` (`OrderDetailID`, `Price`, `Orders_OrderID`, `Products_ProductID`) VALUES (13, 125.00, 13, 213);
INSERT INTO `mydb`.`OrderDetails` (`OrderDetailID`, `Price`, `Orders_OrderID`, `Products_ProductID`) VALUES (14, 296.67, 14, 214);
INSERT INTO `mydb`.`OrderDetails` (`OrderDetailID`, `Price`, `Orders_OrderID`, `Products_ProductID`) VALUES (15, 167.50, 15, 215);
INSERT INTO `mydb`.`OrderDetails` (`OrderDetailID`, `Price`, `Orders_OrderID`, `Products_ProductID`) VALUES (16, 335.13, 16, 216);
INSERT INTO `mydb`.`OrderDetails` (`OrderDetailID`, `Price`, `Orders_OrderID`, `Products_ProductID`) VALUES (17, 300.00, 17, 217);
INSERT INTO `mydb`.`OrderDetails` (`OrderDetailID`, `Price`, `Orders_OrderID`, `Products_ProductID`) VALUES (18, 113.50, 18, 218);
INSERT INTO `mydb`.`OrderDetails` (`OrderDetailID`, `Price`, `Orders_OrderID`, `Products_ProductID`) VALUES (19, 237.50, 19, 219);
INSERT INTO `mydb`.`OrderDetails` (`OrderDetailID`, `Price`, `Orders_OrderID`, `Products_ProductID`) VALUES (20, 390.00, 20, 220);
INSERT INTO `mydb`.`OrderDetails` (`OrderDetailID`, `Price`, `Orders_OrderID`, `Products_ProductID`) VALUES (21, 366.92, 21, 221);
INSERT INTO `mydb`.`OrderDetails` (`OrderDetailID`, `Price`, `Orders_OrderID`, `Products_ProductID`) VALUES (22, 500.00, 22, 222);
INSERT INTO `mydb`.`OrderDetails` (`OrderDetailID`, `Price`, `Orders_OrderID`, `Products_ProductID`) VALUES (23, 260.10, 23, 223);
INSERT INTO `mydb`.`OrderDetails` (`OrderDetailID`, `Price`, `Orders_OrderID`, `Products_ProductID`) VALUES (24, 125.00, 24, 224);
INSERT INTO `mydb`.`OrderDetails` (`OrderDetailID`, `Price`, `Orders_OrderID`, `Products_ProductID`) VALUES (25, 296.67, 25, 225);
INSERT INTO `mydb`.`OrderDetails` (`OrderDetailID`, `Price`, `Orders_OrderID`, `Products_ProductID`) VALUES (26, 167.50, 26, 226);
INSERT INTO `mydb`.`OrderDetails` (`OrderDetailID`, `Price`, `Orders_OrderID`, `Products_ProductID`) VALUES (27, 335.13, 27, 227);
INSERT INTO `mydb`.`OrderDetails` (`OrderDetailID`, `Price`, `Orders_OrderID`, `Products_ProductID`) VALUES (28, 300.00, 28, 228);
INSERT INTO `mydb`.`OrderDetails` (`OrderDetailID`, `Price`, `Orders_OrderID`, `Products_ProductID`) VALUES (29, 113.50, 29, 229);
INSERT INTO `mydb`.`OrderDetails` (`OrderDetailID`, `Price`, `Orders_OrderID`, `Products_ProductID`) VALUES (30, 237.50, 30, 230);
INSERT INTO `mydb`.`OrderDetails` (`OrderDetailID`, `Price`, `Orders_OrderID`, `Products_ProductID`) VALUES (31, 390.00, 31, 231);
INSERT INTO `mydb`.`OrderDetails` (`OrderDetailID`, `Price`, `Orders_OrderID`, `Products_ProductID`) VALUES (32, 366.92, 32, 232);
INSERT INTO `mydb`.`OrderDetails` (`OrderDetailID`, `Price`, `Orders_OrderID`, `Products_ProductID`) VALUES (33, 500.00, 33, 233);
INSERT INTO `mydb`.`OrderDetails` (`OrderDetailID`, `Price`, `Orders_OrderID`, `Products_ProductID`) VALUES (34, 260.10, 34, 234);
INSERT INTO `mydb`.`OrderDetails` (`OrderDetailID`, `Price`, `Orders_OrderID`, `Products_ProductID`) VALUES (35, 125.00, 35, 235);
INSERT INTO `mydb`.`OrderDetails` (`OrderDetailID`, `Price`, `Orders_OrderID`, `Products_ProductID`) VALUES (36, 296.67, 36, 236);
INSERT INTO `mydb`.`OrderDetails` (`OrderDetailID`, `Price`, `Orders_OrderID`, `Products_ProductID`) VALUES (37, 167.50, 37, 237);
INSERT INTO `mydb`.`OrderDetails` (`OrderDetailID`, `Price`, `Orders_OrderID`, `Products_ProductID`) VALUES (38, 335.13, 38, 238);
INSERT INTO `mydb`.`OrderDetails` (`OrderDetailID`, `Price`, `Orders_OrderID`, `Products_ProductID`) VALUES (39, 300.00, 39, 239);
INSERT INTO `mydb`.`OrderDetails` (`OrderDetailID`, `Price`, `Orders_OrderID`, `Products_ProductID`) VALUES (40, 113.50, 40, 240);
INSERT INTO `mydb`.`OrderDetails` (`OrderDetailID`, `Price`, `Orders_OrderID`, `Products_ProductID`) VALUES (41, 237.50, 41, 241);
INSERT INTO `mydb`.`OrderDetails` (`OrderDetailID`, `Price`, `Orders_OrderID`, `Products_ProductID`) VALUES (42, 390.00, 42, 242);
INSERT INTO `mydb`.`OrderDetails` (`OrderDetailID`, `Price`, `Orders_OrderID`, `Products_ProductID`) VALUES (43, 366.92, 43, 243);
INSERT INTO `mydb`.`OrderDetails` (`OrderDetailID`, `Price`, `Orders_OrderID`, `Products_ProductID`) VALUES (44, 500.00, 44, 244);
INSERT INTO `mydb`.`OrderDetails` (`OrderDetailID`, `Price`, `Orders_OrderID`, `Products_ProductID`) VALUES (45, 260.10, 45, 245);
INSERT INTO `mydb`.`OrderDetails` (`OrderDetailID`, `Price`, `Orders_OrderID`, `Products_ProductID`) VALUES (46, 125.00, 46, 246);
INSERT INTO `mydb`.`OrderDetails` (`OrderDetailID`, `Price`, `Orders_OrderID`, `Products_ProductID`) VALUES (47, 296.67, 47, 247);
INSERT INTO `mydb`.`OrderDetails` (`OrderDetailID`, `Price`, `Orders_OrderID`, `Products_ProductID`) VALUES (48, 167.50, 48, 248);
INSERT INTO `mydb`.`OrderDetails` (`OrderDetailID`, `Price`, `Orders_OrderID`, `Products_ProductID`) VALUES (49, 335.13, 49, 249);
INSERT INTO `mydb`.`OrderDetails` (`OrderDetailID`, `Price`, `Orders_OrderID`, `Products_ProductID`) VALUES (50, 300.00, 50, 250);
COMMIT;
-- -----------------------------------------------------
-- Data for table `mydb`.`CustomersContacts`
-- -----------------------------------------------------
START TRANSACTION;
USE `mydb`;
INSERT INTO `mydb`.`CustomersContacts` (`ContactID`, `Customers_CustomerID`, `ContactType`, `Value`)
VALUES
(1, 101, 'Телефон', '+79001234567'),
(2, 102, 'Почта', '[email protected]'),
(3, 103, 'Телефон', '+79001234568'),
(4, 104, 'Почта', '[email protected]'),
(5, 105, 'Телефон', '+79001234569'),
(6, 106, 'Почта', '[email protected]'),
(7, 107, 'Телефон', '+79001234570'),
(8, 108, 'Почта', '[email protected]'),
(9, 109, 'Телефон', '+79001234571'),
(10, 110, 'Почта', '[email protected]'),
(11, 111, 'Телефон', '+79001234572'),
(12, 112, 'Почта', '[email protected]'),
(13, 113, 'Телефон', '+79001234573'),
(14, 114, 'Почта', '[email protected]'),
(15, 115, 'Телефон', '+79001234574'),
(16, 116, 'Почта', '[email protected]'),
(17, 117, 'Телефон', '+79001234575'),
(18, 118, 'Почта', '[email protected]'),
(19, 119, 'Телефон', '+79001234576'),
(20, 120, 'Почта', '[email protected]'),
(21, 121, 'Телефон', '+79001234577'),
(22, 122, 'Почта', '[email protected]'),
(23, 123, 'Телефон', '+79001234578'),
(24, 124, 'Почта', '[email protected]'),
(25, 125, 'Телефон', '+79001234579'),
(26, 126, 'Почта', '[email protected]'),
(27, 127, 'Телефон', '+79001234580'),
(28, 128, 'Почта', '[email protected]'),
(29, 129, 'Телефон', '+79001234581'),
(30, 130, 'Почта', '[email protected]'),
(31, 131, 'Телефон', '+79001234582'),
(32, 132, 'Почта', '[email protected]'),
(33, 133, 'Телефон', '+79001234583'),
(34, 134, 'Почта', '[email protected]'),
(35, 135, 'Телефон', '+79001234584'),
(36, 136, 'Почта', '[email protected]'),
(37, 137, 'Телефон', '+79001234585'),
(38, 138, 'Почта', '[email protected]'),
(39, 139, 'Телефон', '+79001234586'),
(40, 140, 'Почта', '[email protected]'),
(41, 141, 'Телефон', '+79001234587'),
(42, 142, 'Почта', '[email protected]'),
(43, 143, 'Телефон', '+79001234588'),
(44, 144, 'Почта', '[email protected]'),
(45, 145, 'Телефон', '+79001234589'),
(46, 146, 'Почта', '[email protected]'),
(47, 147, 'Телефон', '+79001234590'),
(48, 148, 'Почта', '[email protected]'),
(49, 149, 'Телефон', '+79001234591'),
(50, 150, 'Почта', '[email protected]');
COMMIT;
-- -----------------------------------------------------
-- Data for table `mydb`.`Quotes`
-- -----------------------------------------------------
START TRANSACTION;
USE `mydb`;
INSERT INTO `mydb`.`Quotes` (`QuoteID`, `QuoteDate`, `TotalCost`, `Customers_CustomerID`) VALUES (1, '2023-01-01 00:00:00', 500.00, 101);
INSERT INTO `mydb`.`Quotes` (`QuoteID`, `QuoteDate`, `TotalCost`, `Customers_CustomerID`) VALUES (2, '2023-01-02 00:00:00', 750.00, 102);
INSERT INTO `mydb`.`Quotes` (`QuoteID`, `QuoteDate`, `TotalCost`, `Customers_CustomerID`) VALUES (3, '2023-01-03 00:00:00', 1000.00, 103);
INSERT INTO `mydb`.`Quotes` (`QuoteID`, `QuoteDate`, `TotalCost`, `Customers_CustomerID`) VALUES (4, '2023-01-04 00:00:00', 600.00, 104);
INSERT INTO `mydb`.`Quotes` (`QuoteID`, `QuoteDate`, `TotalCost`, `Customers_CustomerID`) VALUES (5, '2023-01-05 00:00:00', 800.00, 105);
INSERT INTO `mydb`.`Quotes` (`QuoteID`, `QuoteDate`, `TotalCost`, `Customers_CustomerID`) VALUES (6, '2023-01-06 00:00:00', 900.00, 106);
INSERT INTO `mydb`.`Quotes` (`QuoteID`, `QuoteDate`, `TotalCost`, `Customers_CustomerID`) VALUES (7, '2023-01-07 00:00:00', 1200.00, 107);
INSERT INTO `mydb`.`Quotes` (`QuoteID`, `QuoteDate`, `TotalCost`, `Customers_CustomerID`) VALUES (8, '2023-01-08 00:00:00', 1500.00, 108);
INSERT INTO `mydb`.`Quotes` (`QuoteID`, `QuoteDate`, `TotalCost`, `Customers_CustomerID`) VALUES (9, '2023-01-09 00:00:00', 1800.00, 109);
INSERT INTO `mydb`.`Quotes` (`QuoteID`, `QuoteDate`, `TotalCost`, `Customers_CustomerID`) VALUES (10, '2023-01-10 00:00:00', 2000.00, 110);
INSERT INTO `mydb`.`Quotes` (`QuoteID`, `QuoteDate`, `TotalCost`, `Customers_CustomerID`) VALUES (11, '2023-01-11 00:00:00', 2200.00, 101);
INSERT INTO `mydb`.`Quotes` (`QuoteID`, `QuoteDate`, `TotalCost`, `Customers_CustomerID`) VALUES (12, '2023-01-12 00:00:00', 2500.00, 102);
INSERT INTO `mydb`.`Quotes` (`QuoteID`, `QuoteDate`, `TotalCost`, `Customers_CustomerID`) VALUES (13, '2023-01-13 00:00:00', 2800.00, 103);
INSERT INTO `mydb`.`Quotes` (`QuoteID`, `QuoteDate`, `TotalCost`, `Customers_CustomerID`) VALUES (14, '2023-01-14 00:00:00', 3000.00, 104);
INSERT INTO `mydb`.`Quotes` (`QuoteID`, `QuoteDate`, `TotalCost`, `Customers_CustomerID`) VALUES (15, '2023-01-15 00:00:00', 3200.00, 105);
INSERT INTO `mydb`.`Quotes` (`QuoteID`, `QuoteDate`, `TotalCost`, `Customers_CustomerID`) VALUES (16, '2023-01-16 00:00:00', 3500.00, 106);
INSERT INTO `mydb`.`Quotes` (`QuoteID`, `QuoteDate`, `TotalCost`, `Customers_CustomerID`) VALUES (17, '2023-01-17 00:00:00', 3800.00, 107);
INSERT INTO `mydb`.`Quotes` (`QuoteID`, `QuoteDate`, `TotalCost`, `Customers_CustomerID`) VALUES (18, '2023-01-18 00:00:00', 4000.00, 108);
INSERT INTO `mydb`.`Quotes` (`QuoteID`, `QuoteDate`, `TotalCost`, `Customers_CustomerID`) VALUES (19, '2023-01-19 00:00:00', 4200.00, 109);
INSERT INTO `mydb`.`Quotes` (`QuoteID`, `QuoteDate`, `TotalCost`, `Customers_CustomerID`) VALUES (20, '2023-01-20 00:00:00', 4500.00, 110);
INSERT INTO `mydb`.`Quotes` (`QuoteID`, `QuoteDate`, `TotalCost`, `Customers_CustomerID`) VALUES (21, '2023-01-21 00:00:00', 4800.00, 101);
INSERT INTO `mydb`.`Quotes` (`QuoteID`, `QuoteDate`, `TotalCost`, `Customers_CustomerID`) VALUES (22, '2023-01-22 00:00:00', 5000.00, 102);
INSERT INTO `mydb`.`Quotes` (`QuoteID`, `QuoteDate`, `TotalCost`, `Customers_CustomerID`) VALUES (23, '2023-01-23 00:00:00', 5200.00, 103);
INSERT INTO `mydb`.`Quotes` (`QuoteID`, `QuoteDate`, `TotalCost`, `Customers_CustomerID`) VALUES (24, '2023-01-24 00:00:00', 5500.00, 104);
INSERT INTO `mydb`.`Quotes` (`QuoteID`, `QuoteDate`, `TotalCost`, `Customers_CustomerID`) VALUES (25, '2023-01-25 00:00:00', 5800.00, 105);
INSERT INTO `mydb`.`Quotes` (`QuoteID`, `QuoteDate`, `TotalCost`, `Customers_CustomerID`) VALUES (26, '2023-01-26 00:00:00', 6000.00, 106);
INSERT INTO `mydb`.`Quotes` (`QuoteID`, `QuoteDate`, `TotalCost`, `Customers_CustomerID`) VALUES (27, '2023-01-27 00:00:00', 6200.00, 107);
INSERT INTO `mydb`.`Quotes` (`QuoteID`, `QuoteDate`, `TotalCost`, `Customers_CustomerID`) VALUES (28, '2023-01-28 00:00:00', 6500.00, 108);
INSERT INTO `mydb`.`Quotes` (`QuoteID`, `QuoteDate`, `TotalCost`, `Customers_CustomerID`) VALUES (29, '2023-01-29 00:00:00', 6800.00, 109);
INSERT INTO `mydb`.`Quotes` (`QuoteID`, `QuoteDate`, `TotalCost`, `Customers_CustomerID`) VALUES (30, '2023-01-30 00:00:00', 7000.00, 110);
INSERT INTO `mydb`.`Quotes` (`QuoteID`, `QuoteDate`, `TotalCost`, `Customers_CustomerID`) VALUES (31, '2023-02-01 00:00:00', 7200.00, 101);
INSERT INTO `mydb`.`Quotes` (`QuoteID`, `QuoteDate`, `TotalCost`, `Customers_CustomerID`) VALUES (32, '2023-02-02 00:00:00', 7500.00, 102);
INSERT INTO `mydb`.`Quotes` (`QuoteID`, `QuoteDate`, `TotalCost`, `Customers_CustomerID`) VALUES (33, '2023-02-03 00:00:00', 7800.00, 103);
INSERT INTO `mydb`.`Quotes` (`QuoteID`, `QuoteDate`, `TotalCost`, `Customers_CustomerID`) VALUES (34, '2023-02-04 00:00:00', 8000.00, 104);
INSERT INTO `mydb`.`Quotes` (`QuoteID`, `QuoteDate`, `TotalCost`, `Customers_CustomerID`) VALUES (35, '2023-02-05 00:00:00', 8200.00, 105);
INSERT INTO `mydb`.`Quotes` (`QuoteID`, `QuoteDate`, `TotalCost`, `Customers_CustomerID`) VALUES (36, '2023-02-06 00:00:00', 8500.00, 106);
INSERT INTO `mydb`.`Quotes` (`QuoteID`, `QuoteDate`, `TotalCost`, `Customers_CustomerID`) VALUES (37, '2023-02-07 00:00:00', 8800.00, 107);
INSERT INTO `mydb`.`Quotes` (`QuoteID`, `QuoteDate`, `TotalCost`, `Customers_CustomerID`) VALUES (38, '2023-02-08 00:00:00', 9000.00, 108);
INSERT INTO `mydb`.`Quotes` (`QuoteID`, `QuoteDate`, `TotalCost`, `Customers_CustomerID`) VALUES (39, '2023-02-09 00:00:00', 9200.00, 109);
INSERT INTO `mydb`.`Quotes` (`QuoteID`, `QuoteDate`, `TotalCost`, `Customers_CustomerID`) VALUES (40, '2023-02-10 00:00:00', 9500.00, 110);
INSERT INTO `mydb`.`Quotes` (`QuoteID`, `QuoteDate`, `TotalCost`, `Customers_CustomerID`) VALUES (41, '2023-02-11 00:00:00', 9800.00, 101);
INSERT INTO `mydb`.`Quotes` (`QuoteID`, `QuoteDate`, `TotalCost`, `Customers_CustomerID`) VALUES (42, '2023-02-12 00:00:00', 10000.00, 102);
INSERT INTO `mydb`.`Quotes` (`QuoteID`, `QuoteDate`, `TotalCost`, `Customers_CustomerID`) VALUES (43, '2023-02-13 00:00:00', 10200.00, 103);
INSERT INTO `mydb`.`Quotes` (`QuoteID`, `QuoteDate`, `TotalCost`, `Customers_CustomerID`) VALUES (44, '2023-02-14 00:00:00', 10500.00, 104);
INSERT INTO `mydb`.`Quotes` (`QuoteID`, `QuoteDate`, `TotalCost`, `Customers_CustomerID`) VALUES (45, '2023-02-15 00:00:00', 10800.00, 105);
INSERT INTO `mydb`.`Quotes` (`QuoteID`, `QuoteDate`, `TotalCost`, `Customers_CustomerID`) VALUES (46, '2023-02-16 00:00:00', 11000.00, 106);
INSERT INTO `mydb`.`Quotes` (`QuoteID`, `QuoteDate`, `TotalCost`, `Customers_CustomerID`) VALUES (47, '2023-02-17 00:00:00', 11200.00, 107);
INSERT INTO `mydb`.`Quotes` (`QuoteID`, `QuoteDate`, `TotalCost`, `Customers_CustomerID`) VALUES (48, '2023-02-18 00:00:00', 11500.00, 108);
INSERT INTO `mydb`.`Quotes` (`QuoteID`, `QuoteDate`, `TotalCost`, `Customers_CustomerID`) VALUES (49, '2023-02-19 00:00:00', 11800.00, 109);
INSERT INTO `mydb`.`Quotes` (`QuoteID`, `QuoteDate`, `TotalCost`, `Customers_CustomerID`) VALUES (50, '2023-02-20 00:00:00', 12000.00, 110);
COMMIT;
-- -----------------------------------------------------
-- Data for table `mydb`.`QuoteDetails`
-- -----------------------------------------------------
START TRANSACTION;
USE `mydb`;
INSERT INTO `mydb`.`QuoteDetails` (`QuoteDetailID`, `Quantity`, `Price`, `Quotes_QuoteID`, `Products_ProductID`) VALUES (1, 2, 100.00, 1, 201);
INSERT INTO `mydb`.`QuoteDetails` (`QuoteDetailID`, `Quantity`, `Price`, `Quotes_QuoteID`, `Products_ProductID`) VALUES (2, 3, 150.00, 1, 202);
INSERT INTO `mydb`.`QuoteDetails` (`QuoteDetailID`, `Quantity`, `Price`, `Quotes_QuoteID`, `Products_ProductID`) VALUES (3, 1, 200.00, 2, 203);
INSERT INTO `mydb`.`QuoteDetails` (`QuoteDetailID`, `Quantity`, `Price`, `Quotes_QuoteID`, `Products_ProductID`) VALUES (4, 4, 250.00, 2, 204);
INSERT INTO `mydb`.`QuoteDetails` (`QuoteDetailID`, `Quantity`, `Price`, `Quotes_QuoteID`, `Products_ProductID`) VALUES (5, 2, 300.00, 3, 205);
INSERT INTO `mydb`.`QuoteDetails` (`QuoteDetailID`, `Quantity`, `Price`, `Quotes_QuoteID`, `Products_ProductID`) VALUES (6, 3, 350.00, 3, 206);
INSERT INTO `mydb`.`QuoteDetails` (`QuoteDetailID`, `Quantity`, `Price`, `Quotes_QuoteID`, `Products_ProductID`) VALUES (7, 1, 400.00, 4, 207);
INSERT INTO `mydb`.`QuoteDetails` (`QuoteDetailID`, `Quantity`, `Price`, `Quotes_QuoteID`, `Products_ProductID`) VALUES (8, 4, 450.00, 4, 208);
INSERT INTO `mydb`.`QuoteDetails` (`QuoteDetailID`, `Quantity`, `Price`, `Quotes_QuoteID`, `Products_ProductID`) VALUES (9, 2, 500.00, 5, 209);
INSERT INTO `mydb`.`QuoteDetails` (`QuoteDetailID`, `Quantity`, `Price`, `Quotes_QuoteID`, `Products_ProductID`) VALUES (10, 3, 550.00, 5, 210);
INSERT INTO `mydb`.`QuoteDetails` (`QuoteDetailID`, `Quantity`, `Price`, `Quotes_QuoteID`, `Products_ProductID`) VALUES (11, 1, 600.00, 6, 211);
INSERT INTO `mydb`.`QuoteDetails` (`QuoteDetailID`, `Quantity`, `Price`, `Quotes_QuoteID`, `Products_ProductID`) VALUES (12, 4, 650.00, 6, 212);
INSERT INTO `mydb`.`QuoteDetails` (`QuoteDetailID`, `Quantity`, `Price`, `Quotes_QuoteID`, `Products_ProductID`) VALUES (13, 2, 700.00, 7, 213);
INSERT INTO `mydb`.`QuoteDetails` (`QuoteDetailID`, `Quantity`, `Price`, `Quotes_QuoteID`, `Products_ProductID`) VALUES (14, 3, 750.00, 7, 214);
INSERT INTO `mydb`.`QuoteDetails` (`QuoteDetailID`, `Quantity`, `Price`, `Quotes_QuoteID`, `Products_ProductID`) VALUES (15, 1, 800.00, 8, 215);
INSERT INTO `mydb`.`QuoteDetails` (`QuoteDetailID`, `Quantity`, `Price`, `Quotes_QuoteID`, `Products_ProductID`) VALUES (16, 4, 850.00, 8, 216);
INSERT INTO `mydb`.`QuoteDetails` (`QuoteDetailID`, `Quantity`, `Price`, `Quotes_QuoteID`, `Products_ProductID`) VALUES (17, 2, 900.00, 9, 217);
INSERT INTO `mydb`.`QuoteDetails` (`QuoteDetailID`, `Quantity`, `Price`, `Quotes_QuoteID`, `Products_ProductID`) VALUES (18, 3, 950.00, 9, 218);
INSERT INTO `mydb`.`QuoteDetails` (`QuoteDetailID`, `Quantity`, `Price`, `Quotes_QuoteID`, `Products_ProductID`) VALUES (19, 1, 1000.00, 10, 219);
INSERT INTO `mydb`.`QuoteDetails` (`QuoteDetailID`, `Quantity`, `Price`, `Quotes_QuoteID`, `Products_ProductID`) VALUES (20, 4, 1050.00, 10, 220);
INSERT INTO `mydb`.`QuoteDetails` (`QuoteDetailID`, `Quantity`, `Price`, `Quotes_QuoteID`, `Products_ProductID`) VALUES (21, 2, 1100.00, 11, 221);
INSERT INTO `mydb`.`QuoteDetails` (`QuoteDetailID`, `Quantity`, `Price`, `Quotes_QuoteID`, `Products_ProductID`) VALUES (22, 3, 1150.00, 11, 222);
INSERT INTO `mydb`.`QuoteDetails` (`QuoteDetailID`, `Quantity`, `Price`, `Quotes_QuoteID`, `Products_ProductID`) VALUES (23, 1, 1200.00, 12, 223);
INSERT INTO `mydb`.`QuoteDetails` (`QuoteDetailID`, `Quantity`, `Price`, `Quotes_QuoteID`, `Products_ProductID`) VALUES (24, 4, 1250.00, 12, 224);
INSERT INTO `mydb`.`QuoteDetails` (`QuoteDetailID`, `Quantity`, `Price`, `Quotes_QuoteID`, `Products_ProductID`) VALUES (25, 2, 1300.00, 13, 225);
INSERT INTO `mydb`.`QuoteDetails` (`QuoteDetailID`, `Quantity`, `Price`, `Quotes_QuoteID`, `Products_ProductID`) VALUES (26, 3, 1350.00, 13, 226);
INSERT INTO `mydb`.`QuoteDetails` (`QuoteDetailID`, `Quantity`, `Price`, `Quotes_QuoteID`, `Products_ProductID`) VALUES (27, 1, 1400.00, 14, 227);
INSERT INTO `mydb`.`QuoteDetails` (`QuoteDetailID`, `Quantity`, `Price`, `Quotes_QuoteID`, `Products_ProductID`) VALUES (28, 4, 1450.00, 14, 228);
INSERT INTO `mydb`.`QuoteDetails` (`QuoteDetailID`, `Quantity`, `Price`, `Quotes_QuoteID`, `Products_ProductID`) VALUES (29, 2, 1500.00, 15, 229);
INSERT INTO `mydb`.`QuoteDetails` (`QuoteDetailID`, `Quantity`, `Price`, `Quotes_QuoteID`, `Products_ProductID`) VALUES (30, 3, 1550.00, 15, 230);
INSERT INTO `mydb`.`QuoteDetails` (`QuoteDetailID`, `Quantity`, `Price`, `Quotes_QuoteID`, `Products_ProductID`) VALUES (31, 1, 1600.00, 16, 231);
INSERT INTO `mydb`.`QuoteDetails` (`QuoteDetailID`, `Quantity`, `Price`, `Quotes_QuoteID`, `Products_ProductID`) VALUES (32, 4, 1650.00, 16, 232);
INSERT INTO `mydb`.`QuoteDetails` (`QuoteDetailID`, `Quantity`, `Price`, `Quotes_QuoteID`, `Products_ProductID`) VALUES (33, 2, 1700.00, 17, 233);
INSERT INTO `mydb`.`QuoteDetails` (`QuoteDetailID`, `Quantity`, `Price`, `Quotes_QuoteID`, `Products_ProductID`) VALUES (34, 3, 1750.00, 17, 234);
INSERT INTO `mydb`.`QuoteDetails` (`QuoteDetailID`, `Quantity`, `Price`, `Quotes_QuoteID`, `Products_ProductID`) VALUES (35, 1, 1800.00, 18, 235);
INSERT INTO `mydb`.`QuoteDetails` (`QuoteDetailID`, `Quantity`, `Price`, `Quotes_QuoteID`, `Products_ProductID`) VALUES (36, 4, 1850.00, 18, 236);
INSERT INTO `mydb`.`QuoteDetails` (`QuoteDetailID`, `Quantity`, `Price`, `Quotes_QuoteID`, `Products_ProductID`) VALUES (37, 2, 1900.00, 19, 237);
INSERT INTO `mydb`.`QuoteDetails` (`QuoteDetailID`, `Quantity`, `Price`, `Quotes_QuoteID`, `Products_ProductID`) VALUES (38, 3, 1950.00, 19, 238);
INSERT INTO `mydb`.`QuoteDetails` (`QuoteDetailID`, `Quantity`, `Price`, `Quotes_QuoteID`, `Products_ProductID`) VALUES (39, 1, 2000.00, 20, 239);
INSERT INTO `mydb`.`QuoteDetails` (`QuoteDetailID`, `Quantity`, `Price`, `Quotes_QuoteID`, `Products_ProductID`) VALUES (40, 4, 2050.00, 20, 240);
INSERT INTO `mydb`.`QuoteDetails` (`QuoteDetailID`, `Quantity`, `Price`, `Quotes_QuoteID`, `Products_ProductID`) VALUES (41, 2, 2100.00, 21, 241);
INSERT INTO `mydb`.`QuoteDetails` (`QuoteDetailID`, `Quantity`, `Price`, `Quotes_QuoteID`, `Products_ProductID`) VALUES (42, 3, 2150.00, 21, 242);
INSERT INTO `mydb`.`QuoteDetails` (`QuoteDetailID`, `Quantity`, `Price`, `Quotes_QuoteID`, `Products_ProductID`) VALUES (43, 1, 2200.00, 22, 243);
INSERT INTO `mydb`.`QuoteDetails` (`QuoteDetailID`, `Quantity`, `Price`, `Quotes_QuoteID`, `Products_ProductID`) VALUES (44, 4, 2250.00, 22, 244);
INSERT INTO `mydb`.`QuoteDetails` (`QuoteDetailID`, `Quantity`, `Price`, `Quotes_QuoteID`, `Products_ProductID`) VALUES (45, 2, 2300.00, 23, 245);
INSERT INTO `mydb`.`QuoteDetails` (`QuoteDetailID`, `Quantity`, `Price`, `Quotes_QuoteID`, `Products_ProductID`) VALUES (46, 3, 2350.00, 23, 246);
INSERT INTO `mydb`.`QuoteDetails` (`QuoteDetailID`, `Quantity`, `Price`, `Quotes_QuoteID`, `Products_ProductID`) VALUES (47, 1, 2400.00, 24, 247);
INSERT INTO `mydb`.`QuoteDetails` (`QuoteDetailID`, `Quantity`, `Price`, `Quotes_QuoteID`, `Products_ProductID`) VALUES (48, 4, 2450.00, 24, 248);
INSERT INTO `mydb`.`QuoteDetails` (`QuoteDetailID`, `Quantity`, `Price`, `Quotes_QuoteID`, `Products_ProductID`) VALUES (49, 2, 2500.00, 25, 249);
INSERT INTO `mydb`.`QuoteDetails` (`QuoteDetailID`, `Quantity`, `Price`, `Quotes_QuoteID`, `Products_ProductID`) VALUES (50, 3, 2550.00, 25, 250);
COMMIT;
-- -----------------------------------------------------
-- Data for table `mydb`.`ProductionOrders`
-- -----------------------------------------------------
START TRANSACTION;
USE `mydb`;
INSERT INTO `mydb`.`ProductionOrders` (`ProductionOrderID`, `StartDate`, `EndDate`, `Status`) VALUES (1, '2023-01-05 08:00:00', '2023-01-06 16:00:00', 'In Progress');
INSERT INTO `mydb`.`ProductionOrders` (`ProductionOrderID`, `StartDate`, `EndDate`, `Status`) VALUES (2, '2023-01-07 09:00:00', '2023-01-08 17:00:00', 'Completed');
INSERT INTO `mydb`.`ProductionOrders` (`ProductionOrderID`, `StartDate`, `EndDate`, `Status`) VALUES (3, '2023-01-09 10:00:00', '2023-01-10 18:00:00', 'In Progress');
INSERT INTO `mydb`.`ProductionOrders` (`ProductionOrderID`, `StartDate`, `EndDate`, `Status`) VALUES (4, '2023-01-11 11:00:00', '2023-01-12 19:00:00', 'Completed');
INSERT INTO `mydb`.`ProductionOrders` (`ProductionOrderID`, `StartDate`, `EndDate`, `Status`) VALUES (5, '2023-01-13 12:00:00', '2023-01-14 20:00:00', 'In Progress');
INSERT INTO `mydb`.`ProductionOrders` (`ProductionOrderID`, `StartDate`, `EndDate`, `Status`) VALUES (6, '2023-01-15 13:00:00', '2023-01-16 21:00:00', 'Completed');
INSERT INTO `mydb`.`ProductionOrders` (`ProductionOrderID`, `StartDate`, `EndDate`, `Status`) VALUES (7, '2023-01-17 14:00:00', '2023-01-18 22:00:00', 'In Progress');
INSERT INTO `mydb`.`ProductionOrders` (`ProductionOrderID`, `StartDate`, `EndDate`, `Status`) VALUES (8, '2023-01-19 15:00:00', '2023-01-20 23:00:00', 'Completed');
INSERT INTO `mydb`.`ProductionOrders` (`ProductionOrderID`, `StartDate`, `EndDate`, `Status`) VALUES (9, '2023-01-21 16:00:00', '2023-01-22 00:00:00', 'In Progress');
INSERT INTO `mydb`.`ProductionOrders` (`ProductionOrderID`, `StartDate`, `EndDate`, `Status`) VALUES (10, '2023-01-23 17:00:00', '2023-01-24 01:00:00', 'Completed');
COMMIT;
-- -----------------------------------------------------
-- Data for table `mydb`.`ProductionSteps`
-- -----------------------------------------------------
START TRANSACTION;
USE `mydb`;
INSERT INTO `mydb`.`ProductionSteps` (`StepID`, `StepName`, `Description`) VALUES (1, 'Cutting', 'Cutting glass and frames to required sizes');
INSERT INTO `mydb`.`ProductionSteps` (`StepID`, `StepName`, `Description`) VALUES (2, 'Assembly', 'Assembling the frame and installing glass panels');
INSERT INTO `mydb`.`ProductionSteps` (`StepID`, `StepName`, `Description`) VALUES (3, 'Sealing', 'Applying sealant and ensuring airtightness');
INSERT INTO `mydb`.`ProductionSteps` (`StepID`, `StepName`, `Description`) VALUES (4, 'Finishing', 'Final inspection and quality control');
INSERT INTO `mydb`.`ProductionSteps` (`StepID`, `StepName`, `Description`) VALUES (5, 'Packaging', 'Packaging the finished product for delivery');
COMMIT;
-- -----------------------------------------------------
-- Data for table `mydb`.`ProductionOrderSteps`
-- -----------------------------------------------------
START TRANSACTION;
USE `mydb`;
INSERT INTO `mydb`.`ProductionOrderSteps` (`OrderStepID`, `Status`, `ProductionSteps_StepID`, `ProductionOrders_ProductionOrderID`) VALUES (1, 'In Progress', 1, 1);
INSERT INTO `mydb`.`ProductionOrderSteps` (`OrderStepID`, `Status`, `ProductionSteps_StepID`, `ProductionOrders_ProductionOrderID`) VALUES (2, 'Completed', 2, 1);
INSERT INTO `mydb`.`ProductionOrderSteps` (`OrderStepID`, `Status`, `ProductionSteps_StepID`, `ProductionOrders_ProductionOrderID`) VALUES (3, 'In Progress', 3, 2);
INSERT INTO `mydb`.`ProductionOrderSteps` (`OrderStepID`, `Status`, `ProductionSteps_StepID`, `ProductionOrders_ProductionOrderID`) VALUES (4, 'Completed', 4, 2);
INSERT INTO `mydb`.`ProductionOrderSteps` (`OrderStepID`, `Status`, `ProductionSteps_StepID`, `ProductionOrders_ProductionOrderID`) VALUES (5, 'In Progress', 5, 3);
INSERT INTO `mydb`.`ProductionOrderSteps` (`OrderStepID`, `Status`, `ProductionSteps_StepID`, `ProductionOrders_ProductionOrderID`) VALUES (6, 'Completed', 1, 3);
INSERT INTO `mydb`.`ProductionOrderSteps` (`OrderStepID`, `Status`, `ProductionSteps_StepID`, `ProductionOrders_ProductionOrderID`) VALUES (7, 'In Progress', 2, 4);
INSERT INTO `mydb`.`ProductionOrderSteps` (`OrderStepID`, `Status`, `ProductionSteps_StepID`, `ProductionOrders_ProductionOrderID`) VALUES (8, 'Completed', 3, 4);
INSERT INTO `mydb`.`ProductionOrderSteps` (`OrderStepID`, `Status`, `ProductionSteps_StepID`, `ProductionOrders_ProductionOrderID`) VALUES (9, 'In Progress', 4, 5);
INSERT INTO `mydb`.`ProductionOrderSteps` (`OrderStepID`, `Status`, `ProductionSteps_StepID`, `ProductionOrders_ProductionOrderID`) VALUES (10, 'Completed', 5, 5);
INSERT INTO `mydb`.`ProductionOrderSteps` (`OrderStepID`, `Status`, `ProductionSteps_StepID`, `ProductionOrders_ProductionOrderID`) VALUES (11, 'In Progress', 1, 6);
INSERT INTO `mydb`.`ProductionOrderSteps` (`OrderStepID`, `Status`, `ProductionSteps_StepID`, `ProductionOrders_ProductionOrderID`) VALUES (12, 'Completed', 2, 6);
INSERT INTO `mydb`.`ProductionOrderSteps` (`OrderStepID`, `Status`, `ProductionSteps_StepID`, `ProductionOrders_ProductionOrderID`) VALUES (13, 'In Progress', 3, 7);
INSERT INTO `mydb`.`ProductionOrderSteps` (`OrderStepID`, `Status`, `ProductionSteps_StepID`, `ProductionOrders_ProductionOrderID`) VALUES (14, 'Completed', 4, 7);
INSERT INTO `mydb`.`ProductionOrderSteps` (`OrderStepID`, `Status`, `ProductionSteps_StepID`, `ProductionOrders_ProductionOrderID`) VALUES (15, 'In Progress', 5, 8);
INSERT INTO `mydb`.`ProductionOrderSteps` (`OrderStepID`, `Status`, `ProductionSteps_StepID`, `ProductionOrders_ProductionOrderID`) VALUES (16, 'Completed', 1, 8);
INSERT INTO `mydb`.`ProductionOrderSteps` (`OrderStepID`, `Status`, `ProductionSteps_StepID`, `ProductionOrders_ProductionOrderID`) VALUES (17, 'In Progress', 2, 9);
INSERT INTO `mydb`.`ProductionOrderSteps` (`OrderStepID`, `Status`, `ProductionSteps_StepID`, `ProductionOrders_ProductionOrderID`) VALUES (18, 'Completed', 3, 9);
INSERT INTO `mydb`.`ProductionOrderSteps` (`OrderStepID`, `Status`, `ProductionSteps_StepID`, `ProductionOrders_ProductionOrderID`) VALUES (19, 'In Progress', 4, 10);
INSERT INTO `mydb`.`ProductionOrderSteps` (`OrderStepID`, `Status`, `ProductionSteps_StepID`, `ProductionOrders_ProductionOrderID`) VALUES (20, 'Completed', 5, 10);
COMMIT;
-- -----------------------------------------------------
-- Data for table `mydb`.`Materials`
-- -----------------------------------------------------
START TRANSACTION;
USE `mydb`;
INSERT INTO `mydb`.`Materials` (`MaterialID`, `Name`, `UnitOfMeasure`, `PricePerUnit`) VALUES (101, 'Glass', 'Square Meter', 50.00);
INSERT INTO `mydb`.`Materials` (`MaterialID`, `Name`, `UnitOfMeasure`, `PricePerUnit`) VALUES (102, 'Frame', 'Piece', 30.00);
INSERT INTO `mydb`.`Materials` (`MaterialID`, `Name`, `UnitOfMeasure`, `PricePerUnit`) VALUES (103, 'Sealant', 'Meter', 10.00);
INSERT INTO `mydb`.`Materials` (`MaterialID`, `Name`, `UnitOfMeasure`, `PricePerUnit`) VALUES (104, 'Hardware Set', 'Piece', 25.00);
INSERT INTO `mydb`.`Materials` (`MaterialID`, `Name`, `UnitOfMeasure`, `PricePerUnit`) VALUES (105, 'Adhesive', 'Liter', 15.00);
INSERT INTO `mydb`.`Materials` (`MaterialID`, `Name`, `UnitOfMeasure`, `PricePerUnit`) VALUES (106, 'Insulating Film', 'Square Meter', 20.00);
INSERT INTO `mydb`.`Materials` (`MaterialID`, `Name`, `UnitOfMeasure`, `PricePerUnit`) VALUES (107, 'Spacer', 'Piece', 5.00);
INSERT INTO `mydb`.`Materials` (`MaterialID`, `Name`, `UnitOfMeasure`, `PricePerUnit`) VALUES (108, 'Paint', 'Liter', 35.00);
INSERT INTO `mydb`.`Materials` (`MaterialID`, `Name`, `UnitOfMeasure`, `PricePerUnit`) VALUES (109, 'Protective Coating', 'Square Meter', 12.00);
INSERT INTO `mydb`.`Materials` (`MaterialID`, `Name`, `UnitOfMeasure`, `PricePerUnit`) VALUES (110, 'Corner Key', 'Piece', 3.00);
INSERT INTO `mydb`.`Materials` (`MaterialID`, `Name`, `UnitOfMeasure`, `PricePerUnit`) VALUES (111, 'Drainage System', 'Piece', 40.00);
INSERT INTO `mydb`.`Materials` (`MaterialID`, `Name`, `UnitOfMeasure`, `PricePerUnit`) VALUES (112, 'Mounting Tape', 'Roll', 8.00);
INSERT INTO `mydb`.`Materials` (`MaterialID`, `Name`, `UnitOfMeasure`, `PricePerUnit`) VALUES (113, 'Gasket', 'Meter', 7.00);
INSERT INTO `mydb`.`Materials` (`MaterialID`, `Name`, `UnitOfMeasure`, `PricePerUnit`) VALUES (114, 'Reinforcement Profile', 'Piece', 18.00);
INSERT INTO `mydb`.`Materials` (`MaterialID`, `Name`, `UnitOfMeasure`, `PricePerUnit`) VALUES (115, 'Thermal Insulation', 'Square Meter', 22.00);
INSERT INTO `mydb`.`Materials` (`MaterialID`, `Name`, `UnitOfMeasure`, `PricePerUnit`) VALUES (116, 'Soundproofing Material', 'Square Meter', 25.00);
INSERT INTO `mydb`.`Materials` (`MaterialID`, `Name`, `UnitOfMeasure`, `PricePerUnit`) VALUES (117, 'UV Protection Film', 'Square Meter', 18.00);
INSERT INTO `mydb`.`Materials` (`MaterialID`, `Name`, `UnitOfMeasure`, `PricePerUnit`) VALUES (118, 'Structural Glue', 'Tube', 12.00);
INSERT INTO `mydb`.`Materials` (`MaterialID`, `Name`, `UnitOfMeasure`, `PricePerUnit`) VALUES (119, 'Window Handle', 'Piece', 10.00);
INSERT INTO `mydb`.`Materials` (`MaterialID`, `Name`, `UnitOfMeasure`, `PricePerUnit`) VALUES (120, 'Locking Mechanism', 'Piece', 30.00);
INSERT INTO `mydb`.`Materials` (`MaterialID`, `Name`, `UnitOfMeasure`, `PricePerUnit`) VALUES (121, 'Hinge', 'Piece', 15.00);
INSERT INTO `mydb`.`Materials` (`MaterialID`, `Name`, `UnitOfMeasure`, `PricePerUnit`) VALUES (122, 'Weatherproof Seal', 'Meter', 9.00);
INSERT INTO `mydb`.`Materials` (`MaterialID`, `Name`, `UnitOfMeasure`, `PricePerUnit`) VALUES (123, 'Decorative Strip', 'Meter', 6.00);
INSERT INTO `mydb`.`Materials` (`MaterialID`, `Name`, `UnitOfMeasure`, `PricePerUnit`) VALUES (124, 'Glazing Bead', 'Piece', 4.00);
INSERT INTO `mydb`.`Materials` (`MaterialID`, `Name`, `UnitOfMeasure`, `PricePerUnit`) VALUES (125, 'Aluminum Profile', 'Piece', 45.00);
INSERT INTO `mydb`.`Materials` (`MaterialID`, `Name`, `UnitOfMeasure`, `PricePerUnit`) VALUES (126, 'PVC Profile', 'Piece', 35.00);
INSERT INTO `mydb`.`Materials` (`MaterialID`, `Name`, `UnitOfMeasure`, `PricePerUnit`) VALUES (127, 'Steel Reinforcement', 'Piece', 50.00);
INSERT INTO `mydb`.`Materials` (`MaterialID`, `Name`, `UnitOfMeasure`, `PricePerUnit`) VALUES (128, 'Composite Panel', 'Square Meter', 60.00);
INSERT INTO `mydb`.`Materials` (`MaterialID`, `Name`, `UnitOfMeasure`, `PricePerUnit`) VALUES (129, 'Acoustic Membrane', 'Square Meter', 30.00);
INSERT INTO `mydb`.`Materials` (`MaterialID`, `Name`, `UnitOfMeasure`, `PricePerUnit`) VALUES (130, 'Solar Control Film', 'Square Meter', 28.00);
INSERT INTO `mydb`.`Materials` (`MaterialID`, `Name`, `UnitOfMeasure`, `PricePerUnit`) VALUES (131, 'Low Iron Glass', 'Square Meter', 65.00);
INSERT INTO `mydb`.`Materials` (`MaterialID`, `Name`, `UnitOfMeasure`, `PricePerUnit`) VALUES (132, 'Tinted Glass', 'Square Meter', 70.00);
INSERT INTO `mydb`.`Materials` (`MaterialID`, `Name`, `UnitOfMeasure`, `PricePerUnit`) VALUES (133, 'Reflective Glass', 'Square Meter', 75.00);
INSERT INTO `mydb`.`Materials` (`MaterialID`, `Name`, `UnitOfMeasure`, `PricePerUnit`) VALUES (134, 'Heat Strengthened Glass', 'Square Meter', 80.00);
INSERT INTO `mydb`.`Materials` (`MaterialID`, `Name`, `UnitOfMeasure`, `PricePerUnit`) VALUES (135, 'Vacuum Insulated Glass', 'Square Meter', 100.00);
INSERT INTO `mydb`.`Materials` (`MaterialID`, `Name`, `UnitOfMeasure`, `PricePerUnit`) VALUES (136, 'Electric Motor', 'Piece', 120.00);
INSERT INTO `mydb`.`Materials` (`MaterialID`, `Name`, `UnitOfMeasure`, `PricePerUnit`) VALUES (137, 'Awning Mechanism', 'Piece', 90.00);
INSERT INTO `mydb`.`Materials` (`MaterialID`, `Name`, `UnitOfMeasure`, `PricePerUnit`) VALUES (138, 'Sliding Track', 'Meter', 25.00);
INSERT INTO `mydb`.`Materials` (`MaterialID`, `Name`, `UnitOfMeasure`, `PricePerUnit`) VALUES (139, 'Noise Reduction Film', 'Square Meter', 30.00);
INSERT INTO `mydb`.`Materials` (`MaterialID`, `Name`, `UnitOfMeasure`, `PricePerUnit`) VALUES (140, 'Energy Efficient Film', 'Square Meter', 35.00);
INSERT INTO `mydb`.`Materials` (`MaterialID`, `Name`, `UnitOfMeasure`, `PricePerUnit`) VALUES (141, 'Glass Reinforcement Rod', 'Meter', 15.00);
INSERT INTO `mydb`.`Materials` (`MaterialID`, `Name`, `UnitOfMeasure`, `PricePerUnit`) VALUES (142, 'Structural Silicone', 'Tube', 20.00);
INSERT INTO `mydb`.`Materials` (`MaterialID`, `Name`, `UnitOfMeasure`, `PricePerUnit`) VALUES (143, 'Glass Finishing Strip', 'Meter', 10.00);
INSERT INTO `mydb`.`Materials` (`MaterialID`, `Name`, `UnitOfMeasure`, `PricePerUnit`) VALUES (144, 'Glass Spacer Bar', 'Piece', 5.00);
INSERT INTO `mydb`.`Materials` (`MaterialID`, `Name`, `UnitOfMeasure`, `PricePerUnit`) VALUES (145, 'Glass Edge Protector', 'Piece', 8.00);
INSERT INTO `mydb`.`Materials` (`MaterialID`, `Name`, `UnitOfMeasure`, `PricePerUnit`) VALUES (146, 'Glass Cleaning Solution', 'Liter', 12.00);
INSERT INTO `mydb`.`Materials` (`MaterialID`, `Name`, `UnitOfMeasure`, `PricePerUnit`) VALUES (147, 'Glass Polishing Compound', 'Kilogram', 25.00);
INSERT INTO `mydb`.`Materials` (`MaterialID`, `Name`, `UnitOfMeasure`, `PricePerUnit`) VALUES (148, 'Glass Cutting Wheel', 'Piece', 20.00);
INSERT INTO `mydb`.`Materials` (`MaterialID`, `Name`, `UnitOfMeasure`, `PricePerUnit`) VALUES (149, 'Glass Drilling Bit', 'Piece', 30.00);
INSERT INTO `mydb`.`Materials` (`MaterialID`, `Name`, `UnitOfMeasure`, `PricePerUnit`) VALUES (150, 'Glass Clamps', 'Piece', 18.00);
COMMIT;
-- -----------------------------------------------------
-- Data for table `mydb`.`MaterialUsage`
-- -----------------------------------------------------
START TRANSACTION;
USE `mydb`;
INSERT INTO `mydb`.`MaterialUsage` (`UsageID`, `Quantity`, `Materials_MaterialID`, `Orders_OrderID`) VALUES (1, 5, 101, 1);
INSERT INTO `mydb`.`MaterialUsage` (`UsageID`, `Quantity`, `Materials_MaterialID`, `Orders_OrderID`) VALUES (2, 10, 102, 2);
INSERT INTO `mydb`.`MaterialUsage` (`UsageID`, `Quantity`, `Materials_MaterialID`, `Orders_OrderID`) VALUES (3, 3, 103, 3);
INSERT INTO `mydb`.`MaterialUsage` (`UsageID`, `Quantity`, `Materials_MaterialID`, `Orders_OrderID`) VALUES (4, 7, 104, 4);
INSERT INTO `mydb`.`MaterialUsage` (`UsageID`, `Quantity`, `Materials_MaterialID`, `Orders_OrderID`) VALUES (5, 2, 105, 5);
INSERT INTO `mydb`.`MaterialUsage` (`UsageID`, `Quantity`, `Materials_MaterialID`, `Orders_OrderID`) VALUES (6, 8, 106, 6);
INSERT INTO `mydb`.`MaterialUsage` (`UsageID`, `Quantity`, `Materials_MaterialID`, `Orders_OrderID`) VALUES (7, 4, 107, 7);
INSERT INTO `mydb`.`MaterialUsage` (`UsageID`, `Quantity`, `Materials_MaterialID`, `Orders_OrderID`) VALUES (8, 6, 108, 8);
INSERT INTO `mydb`.`MaterialUsage` (`UsageID`, `Quantity`, `Materials_MaterialID`, `Orders_OrderID`) VALUES (9, 5, 109, 9);
INSERT INTO `mydb`.`MaterialUsage` (`UsageID`, `Quantity`, `Materials_MaterialID`, `Orders_OrderID`) VALUES (10, 9, 110, 10);
INSERT INTO `mydb`.`MaterialUsage` (`UsageID`, `Quantity`, `Materials_MaterialID`, `Orders_OrderID`) VALUES (11, 3, 111, 11);
INSERT INTO `mydb`.`MaterialUsage` (`UsageID`, `Quantity`, `Materials_MaterialID`, `Orders_OrderID`) VALUES (12, 7, 112, 12);
INSERT INTO `mydb`.`MaterialUsage` (`UsageID`, `Quantity`, `Materials_MaterialID`, `Orders_OrderID`) VALUES (13, 2, 113, 13);
INSERT INTO `mydb`.`MaterialUsage` (`UsageID`, `Quantity`, `Materials_MaterialID`, `Orders_OrderID`) VALUES (14, 8, 114, 14);
INSERT INTO `mydb`.`MaterialUsage` (`UsageID`, `Quantity`, `Materials_MaterialID`, `Orders_OrderID`) VALUES (15, 4, 115, 15);
INSERT INTO `mydb`.`MaterialUsage` (`UsageID`, `Quantity`, `Materials_MaterialID`, `Orders_OrderID`) VALUES (16, 6, 116, 16);
INSERT INTO `mydb`.`MaterialUsage` (`UsageID`, `Quantity`, `Materials_MaterialID`, `Orders_OrderID`) VALUES (17, 5, 117, 17);
INSERT INTO `mydb`.`MaterialUsage` (`UsageID`, `Quantity`, `Materials_MaterialID`, `Orders_OrderID`) VALUES (18, 9, 118, 18);
INSERT INTO `mydb`.`MaterialUsage` (`UsageID`, `Quantity`, `Materials_MaterialID`, `Orders_OrderID`) VALUES (19, 3, 119, 19);
INSERT INTO `mydb`.`MaterialUsage` (`UsageID`, `Quantity`, `Materials_MaterialID`, `Orders_OrderID`) VALUES (20, 7, 120, 20);
INSERT INTO `mydb`.`MaterialUsage` (`UsageID`, `Quantity`, `Materials_MaterialID`, `Orders_OrderID`) VALUES (21, 2, 121, 21);
INSERT INTO `mydb`.`MaterialUsage` (`UsageID`, `Quantity`, `Materials_MaterialID`, `Orders_OrderID`) VALUES (22, 8, 122, 22);
INSERT INTO `mydb`.`MaterialUsage` (`UsageID`, `Quantity`, `Materials_MaterialID`, `Orders_OrderID`) VALUES (23, 4, 123, 23);
INSERT INTO `mydb`.`MaterialUsage` (`UsageID`, `Quantity`, `Materials_MaterialID`, `Orders_OrderID`) VALUES (24, 6, 124, 24);
INSERT INTO `mydb`.`MaterialUsage` (`UsageID`, `Quantity`, `Materials_MaterialID`, `Orders_OrderID`) VALUES (25, 5, 125, 25);
INSERT INTO `mydb`.`MaterialUsage` (`UsageID`, `Quantity`, `Materials_MaterialID`, `Orders_OrderID`) VALUES (26, 9, 126, 26);
INSERT INTO `mydb`.`MaterialUsage` (`UsageID`, `Quantity`, `Materials_MaterialID`, `Orders_OrderID`) VALUES (27, 3, 127, 27);
INSERT INTO `mydb`.`MaterialUsage` (`UsageID`, `Quantity`, `Materials_MaterialID`, `Orders_OrderID`) VALUES (28, 7, 128, 28);
INSERT INTO `mydb`.`MaterialUsage` (`UsageID`, `Quantity`, `Materials_MaterialID`, `Orders_OrderID`) VALUES (29, 2, 129, 29);
INSERT INTO `mydb`.`MaterialUsage` (`UsageID`, `Quantity`, `Materials_MaterialID`, `Orders_OrderID`) VALUES (30, 8, 130, 30);
INSERT INTO `mydb`.`MaterialUsage` (`UsageID`, `Quantity`, `Materials_MaterialID`, `Orders_OrderID`) VALUES (31, 4, 101, 31);
INSERT INTO `mydb`.`MaterialUsage` (`UsageID`, `Quantity`, `Materials_MaterialID`, `Orders_OrderID`) VALUES (32, 6, 102, 32);
INSERT INTO `mydb`.`MaterialUsage` (`UsageID`, `Quantity`, `Materials_MaterialID`, `Orders_OrderID`) VALUES (33, 5, 103, 33);
INSERT INTO `mydb`.`MaterialUsage` (`UsageID`, `Quantity`, `Materials_MaterialID`, `Orders_OrderID`) VALUES (34, 9, 104, 34);
INSERT INTO `mydb`.`MaterialUsage` (`UsageID`, `Quantity`, `Materials_MaterialID`, `Orders_OrderID`) VALUES (35, 3, 105, 35);
INSERT INTO `mydb`.`MaterialUsage` (`UsageID`, `Quantity`, `Materials_MaterialID`, `Orders_OrderID`) VALUES (36, 7, 106, 36);
INSERT INTO `mydb`.`MaterialUsage` (`UsageID`, `Quantity`, `Materials_MaterialID`, `Orders_OrderID`) VALUES (37, 2, 107, 37);
INSERT INTO `mydb`.`MaterialUsage` (`UsageID`, `Quantity`, `Materials_MaterialID`, `Orders_OrderID`) VALUES (38, 8, 108, 38);
INSERT INTO `mydb`.`MaterialUsage` (`UsageID`, `Quantity`, `Materials_MaterialID`, `Orders_OrderID`) VALUES (39, 4, 109, 39);
INSERT INTO `mydb`.`MaterialUsage` (`UsageID`, `Quantity`, `Materials_MaterialID`, `Orders_OrderID`) VALUES (40, 6, 110, 40);
INSERT INTO `mydb`.`MaterialUsage` (`UsageID`, `Quantity`, `Materials_MaterialID`, `Orders_OrderID`) VALUES (41, 5, 111, 41);
INSERT INTO `mydb`.`MaterialUsage` (`UsageID`, `Quantity`, `Materials_MaterialID`, `Orders_OrderID`) VALUES (42, 9, 112, 42);
INSERT INTO `mydb`.`MaterialUsage` (`UsageID`, `Quantity`, `Materials_MaterialID`, `Orders_OrderID`) VALUES (43, 3, 113, 43);
INSERT INTO `mydb`.`MaterialUsage` (`UsageID`, `Quantity`, `Materials_MaterialID`, `Orders_OrderID`) VALUES (44, 7, 114, 44);
INSERT INTO `mydb`.`MaterialUsage` (`UsageID`, `Quantity`, `Materials_MaterialID`, `Orders_OrderID`) VALUES (45, 2, 115, 45);
INSERT INTO `mydb`.`MaterialUsage` (`UsageID`, `Quantity`, `Materials_MaterialID`, `Orders_OrderID`) VALUES (46, 8, 116, 46);
INSERT INTO `mydb`.`MaterialUsage` (`UsageID`, `Quantity`, `Materials_MaterialID`, `Orders_OrderID`) VALUES (47, 4, 117, 47);
INSERT INTO `mydb`.`MaterialUsage` (`UsageID`, `Quantity`, `Materials_MaterialID`, `Orders_OrderID`) VALUES (48, 6, 118, 48);
INSERT INTO `mydb`.`MaterialUsage` (`UsageID`, `Quantity`, `Materials_MaterialID`, `Orders_OrderID`) VALUES (49, 5, 119, 49);
INSERT INTO `mydb`.`MaterialUsage` (`UsageID`, `Quantity`, `Materials_MaterialID`, `Orders_OrderID`) VALUES (50, 9, 120, 50);
COMMIT;
-- -----------------------------------------------------
-- Data for table `mydb`.`Equipment`
-- -----------------------------------------------------
START TRANSACTION;
USE `mydb`;
INSERT INTO `mydb`.`Equipment` (`EquipmentID`, `Name`, `Model`, `PurchaseDate`, `Equipmentcol`) VALUES (1, 'Drilling Machine', 'DM-100', '2022-01-01 00:00:00', 'Red');
INSERT INTO `mydb`.`Equipment` (`EquipmentID`, `Name`, `Model`, `PurchaseDate`, `Equipmentcol`) VALUES (2, 'Cutting Machine', 'CM-200', '2022-02-01 00:00:00', 'Blue');
INSERT INTO `mydb`.`Equipment` (`EquipmentID`, `Name`, `Model`, `PurchaseDate`, `Equipmentcol`) VALUES (3, 'Sealing Machine', 'SM-300', '2022-03-01 00:00:00', 'Green');
INSERT INTO `mydb`.`Equipment` (`EquipmentID`, `Name`, `Model`, `PurchaseDate`, `Equipmentcol`) VALUES (4, 'Assembly Line', 'AL-400', '2022-04-01 00:00:00', 'Yellow');
INSERT INTO `mydb`.`Equipment` (`EquipmentID`, `Name`, `Model`, `PurchaseDate`, `Equipmentcol`) VALUES (5, 'Inspection Tool', 'IT-500', '2022-05-01 00:00:00', 'Orange');
COMMIT;
-- -----------------------------------------------------
-- Data for table `mydb`.`EquipmentMaintenance`
-- -----------------------------------------------------
START TRANSACTION;
USE `mydb`;
INSERT INTO `mydb`.`EquipmentMaintenance` (`MaintenanceID`, `MaintenanceDate`, `Description`, `Equipment_EquipmentID`) VALUES (1, '2022-06-01 00:00:00', 'Routine check and oiling', 1);
INSERT INTO `mydb`.`EquipmentMaintenance` (`MaintenanceID`, `MaintenanceDate`, `Description`, `Equipment_EquipmentID`) VALUES (2, '2022-07-01 00:00:00', 'Belt replacement', 2);
INSERT INTO `mydb`.`EquipmentMaintenance` (`MaintenanceID`, `MaintenanceDate`, `Description`, `Equipment_EquipmentID`) VALUES (3, '2022-08-01 00:00:00', 'Sealant application', 3);
INSERT INTO `mydb`.`EquipmentMaintenance` (`MaintenanceID`, `MaintenanceDate`, `Description`, `Equipment_EquipmentID`) VALUES (4, '2022-09-01 00:00:00', 'Calibration', 4);
INSERT INTO `mydb`.`EquipmentMaintenance` (`MaintenanceID`, `MaintenanceDate`, `Description`, `Equipment_EquipmentID`) VALUES (5, '2022-10-01 00:00:00', 'Filter cleaning', 5);
COMMIT;
-- -----------------------------------------------------
-- Data for table `mydb`.`Warehouses`
-- -----------------------------------------------------
START TRANSACTION;
USE `mydb`;
INSERT INTO `mydb`.`Warehouses` (`WarehouseID`, `Name`, `Address`) VALUES (1, 'Warehouse A', 'Lenina str.');
INSERT INTO `mydb`.`Warehouses` (`WarehouseID`, `Name`, `Address`) VALUES (2, 'Warehouse B', 'Moskovskiy pros. 34');
INSERT INTO `mydb`.`Warehouses` (`WarehouseID`, `Name`, `Address`) VALUES (3, 'Warehouse C', 'Pushkina str.');
INSERT INTO `mydb`.`Warehouses` (`WarehouseID`, `Name`, `Address`) VALUES (4, 'Warehouse D', 'Kalinina str.');
INSERT INTO `mydb`.`Warehouses` (`WarehouseID`, `Name`, `Address`) VALUES (5, 'Warehouse E', 'Chkalova str.');
INSERT INTO `mydb`.`Warehouses` (`WarehouseID`, `Name`, `Address`) VALUES (6, 'Warehouse F', 'Horkova str.');
INSERT INTO `mydb`.`Warehouses` (`WarehouseID`, `Name`, `Address`) VALUES (7, 'Warehouse G', 'Stroitelei str.');
INSERT INTO `mydb`.`Warehouses` (`WarehouseID`, `Name`, `Address`) VALUES (8, 'Warehouse H', 'Lugovaya str.');
INSERT INTO `mydb`.`Warehouses` (`WarehouseID`, `Name`, `Address`) VALUES (9, 'Warehouse I', 'Komsomoltcev str.');
INSERT INTO `mydb`.`Warehouses` (`WarehouseID`, `Name`, `Address`) VALUES (10, 'Warehouse J', 'Octyabrskaya str.');
COMMIT;
-- -----------------------------------------------------
-- Data for table `mydb`.`Stocks`
-- -----------------------------------------------------
START TRANSACTION;
USE `mydb`;
INSERT INTO `mydb`.`Stocks` (`StockID`, `Quantity`, `Warehouses_WarehouseID`, `Materials_MaterialID`) VALUES (1, 100, 1, 101);
INSERT INTO `mydb`.`Stocks` (`StockID`, `Quantity`, `Warehouses_WarehouseID`, `Materials_MaterialID`) VALUES (2, 150, 1, 102);
INSERT INTO `mydb`.`Stocks` (`StockID`, `Quantity`, `Warehouses_WarehouseID`, `Materials_MaterialID`) VALUES (3, 200, 2, 103);
INSERT INTO `mydb`.`Stocks` (`StockID`, `Quantity`, `Warehouses_WarehouseID`, `Materials_MaterialID`) VALUES (4, 120, 2, 104);
INSERT INTO `mydb`.`Stocks` (`StockID`, `Quantity`, `Warehouses_WarehouseID`, `Materials_MaterialID`) VALUES (5, 80, 3, 105);
INSERT INTO `mydb`.`Stocks` (`StockID`, `Quantity`, `Warehouses_WarehouseID`, `Materials_MaterialID`) VALUES (6, 110, 3, 106);
INSERT INTO `mydb`.`Stocks` (`StockID`, `Quantity`, `Warehouses_WarehouseID`, `Materials_MaterialID`) VALUES (7, 90, 4, 107);
INSERT INTO `mydb`.`Stocks` (`StockID`, `Quantity`, `Warehouses_WarehouseID`, `Materials_MaterialID`) VALUES (8, 130, 4, 108);
INSERT INTO `mydb`.`Stocks` (`StockID`, `Quantity`, `Warehouses_WarehouseID`, `Materials_MaterialID`) VALUES (9, 140, 5, 109);
INSERT INTO `mydb`.`Stocks` (`StockID`, `Quantity`, `Warehouses_WarehouseID`, `Materials_MaterialID`) VALUES (10, 160, 5, 110);
INSERT INTO `mydb`.`Stocks` (`StockID`, `Quantity`, `Warehouses_WarehouseID`, `Materials_MaterialID`) VALUES (11, 170, 6, 111);
INSERT INTO `mydb`.`Stocks` (`StockID`, `Quantity`, `Warehouses_WarehouseID`, `Materials_MaterialID`) VALUES (12, 180, 6, 112);
INSERT INTO `mydb`.`Stocks` (`StockID`, `Quantity`, `Warehouses_WarehouseID`, `Materials_MaterialID`) VALUES (13, 190, 7, 113);
INSERT INTO `mydb`.`Stocks` (`StockID`, `Quantity`, `Warehouses_WarehouseID`, `Materials_MaterialID`) VALUES (14, 210, 7, 114);
INSERT INTO `mydb`.`Stocks` (`StockID`, `Quantity`, `Warehouses_WarehouseID`, `Materials_MaterialID`) VALUES (15, 220, 8, 115);
INSERT INTO `mydb`.`Stocks` (`StockID`, `Quantity`, `Warehouses_WarehouseID`, `Materials_MaterialID`) VALUES (16, 230, 8, 116);
INSERT INTO `mydb`.`Stocks` (`StockID`, `Quantity`, `Warehouses_WarehouseID`, `Materials_MaterialID`) VALUES (17, 240, 9, 117);
INSERT INTO `mydb`.`Stocks` (`StockID`, `Quantity`, `Warehouses_WarehouseID`, `Materials_MaterialID`) VALUES (18, 250, 9, 118);
INSERT INTO `mydb`.`Stocks` (`StockID`, `Quantity`, `Warehouses_WarehouseID`, `Materials_MaterialID`) VALUES (19, 260, 10, 119);
INSERT INTO `mydb`.`Stocks` (`StockID`, `Quantity`, `Warehouses_WarehouseID`, `Materials_MaterialID`) VALUES (20, 270, 10, 120);
INSERT INTO `mydb`.`Stocks` (`StockID`, `Quantity`, `Warehouses_WarehouseID`, `Materials_MaterialID`) VALUES (21, 280, 1, 121);
INSERT INTO `mydb`.`Stocks` (`StockID`, `Quantity`, `Warehouses_WarehouseID`, `Materials_MaterialID`) VALUES (22, 290, 1, 122);
INSERT INTO `mydb`.`Stocks` (`StockID`, `Quantity`, `Warehouses_WarehouseID`, `Materials_MaterialID`) VALUES (23, 300, 2, 123);
INSERT INTO `mydb`.`Stocks` (`StockID`, `Quantity`, `Warehouses_WarehouseID`, `Materials_MaterialID`) VALUES (24, 310, 2, 124);
INSERT INTO `mydb`.`Stocks` (`StockID`, `Quantity`, `Warehouses_WarehouseID`, `Materials_MaterialID`) VALUES (25, 320, 3, 125);
INSERT INTO `mydb`.`Stocks` (`StockID`, `Quantity`, `Warehouses_WarehouseID`, `Materials_MaterialID`) VALUES (26, 330, 3, 126);
INSERT INTO `mydb`.`Stocks` (`StockID`, `Quantity`, `Warehouses_WarehouseID`, `Materials_MaterialID`) VALUES (27, 340, 4, 127);
INSERT INTO `mydb`.`Stocks` (`StockID`, `Quantity`, `Warehouses_WarehouseID`, `Materials_MaterialID`) VALUES (28, 350, 4, 128);
INSERT INTO `mydb`.`Stocks` (`StockID`, `Quantity`, `Warehouses_WarehouseID`, `Materials_MaterialID`) VALUES (29, 360, 5, 129);
INSERT INTO `mydb`.`Stocks` (`StockID`, `Quantity`, `Warehouses_WarehouseID`, `Materials_MaterialID`) VALUES (30, 370, 5, 130);
INSERT INTO `mydb`.`Stocks` (`StockID`, `Quantity`, `Warehouses_WarehouseID`, `Materials_MaterialID`) VALUES (31, 380, 6, 131);
INSERT INTO `mydb`.`Stocks` (`StockID`, `Quantity`, `Warehouses_WarehouseID`, `Materials_MaterialID`) VALUES (32, 390, 6, 132);
INSERT INTO `mydb`.`Stocks` (`StockID`, `Quantity`, `Warehouses_WarehouseID`, `Materials_MaterialID`) VALUES (33, 400, 7, 133);
INSERT INTO `mydb`.`Stocks` (`StockID`, `Quantity`, `Warehouses_WarehouseID`, `Materials_MaterialID`) VALUES (34, 410, 7, 134);
INSERT INTO `mydb`.`Stocks` (`StockID`, `Quantity`, `Warehouses_WarehouseID`, `Materials_MaterialID`) VALUES (35, 420, 8, 135);
INSERT INTO `mydb`.`Stocks` (`StockID`, `Quantity`, `Warehouses_WarehouseID`, `Materials_MaterialID`) VALUES (36, 430, 8, 136);
INSERT INTO `mydb`.`Stocks` (`StockID`, `Quantity`, `Warehouses_WarehouseID`, `Materials_MaterialID`) VALUES (37, 440, 9, 137);
INSERT INTO `mydb`.`Stocks` (`StockID`, `Quantity`, `Warehouses_WarehouseID`, `Materials_MaterialID`) VALUES (38, 450, 9, 138);
INSERT INTO `mydb`.`Stocks` (`StockID`, `Quantity`, `Warehouses_WarehouseID`, `Materials_MaterialID`) VALUES (39, 460, 10, 139);
INSERT INTO `mydb`.`Stocks` (`StockID`, `Quantity`, `Warehouses_WarehouseID`, `Materials_MaterialID`) VALUES (40, 470, 10, 140);
INSERT INTO `mydb`.`Stocks` (`StockID`, `Quantity`, `Warehouses_WarehouseID`, `Materials_MaterialID`) VALUES (41, 480, 1, 141);
INSERT INTO `mydb`.`Stocks` (`StockID`, `Quantity`, `Warehouses_WarehouseID`, `Materials_MaterialID`) VALUES (42, 490, 1, 142);
INSERT INTO `mydb`.`Stocks` (`StockID`, `Quantity`, `Warehouses_WarehouseID`, `Materials_MaterialID`) VALUES (43, 500, 2, 143);
INSERT INTO `mydb`.`Stocks` (`StockID`, `Quantity`, `Warehouses_WarehouseID`, `Materials_MaterialID`) VALUES (44, 510, 2, 144);
INSERT INTO `mydb`.`Stocks` (`StockID`, `Quantity`, `Warehouses_WarehouseID`, `Materials_MaterialID`) VALUES (45, 520, 3, 145);
INSERT INTO `mydb`.`Stocks` (`StockID`, `Quantity`, `Warehouses_WarehouseID`, `Materials_MaterialID`) VALUES (46, 530, 3, 146);
INSERT INTO `mydb`.`Stocks` (`StockID`, `Quantity`, `Warehouses_WarehouseID`, `Materials_MaterialID`) VALUES (47, 540, 4, 147);
INSERT INTO `mydb`.`Stocks` (`StockID`, `Quantity`, `Warehouses_WarehouseID`, `Materials_MaterialID`) VALUES (48, 550, 4, 148);
INSERT INTO `mydb`.`Stocks` (`StockID`, `Quantity`, `Warehouses_WarehouseID`, `Materials_MaterialID`) VALUES (49, 560, 5, 149);
INSERT INTO `mydb`.`Stocks` (`StockID`, `Quantity`, `Warehouses_WarehouseID`, `Materials_MaterialID`) VALUES (50, 570, 5, 150);
COMMIT;
/*
-- -----------------------------------------------------
-- Data for table `mydb`.`StockMovements`
-- -----------------------------------------------------
START TRANSACTION;
USE `mydb`;
INSERT INTO `mydb`.`StockMovements` (`StockMovementsID`, `OperationType`, `Quantity`, `Materials_MaterialID`, `Warehouses_WarehouseID`)
VALUES
(1, 'Приход', 10, 101, 1),
(2, 'Расход', 15, 102, 1),
(3, 'Приход', 20, 103, 2),
(4, 'Расход', 12, 104, 2),
(5, 'Приход', 8, 105, 3),
(6, 'Расход', 11, 106, 3),
(7, 'Приход', 9, 107, 4),
(8, 'Расход', 13, 108, 4),
(9, 'Приход', 14, 109, 5),
(10, 'Расход', 16, 110, 5),
(11, 'Приход', 17, 111, 6),
(12, 'Расход', 18, 112, 6),
(13, 'Приход', 19, 113, 7),
(14, 'Расход', 21, 114, 7),
(15, 'Приход', 22, 115, 8),
(16, 'Расход', 23, 116, 8),
(17, 'Приход', 24, 117, 9),
(18, 'Расход', 25, 118, 9),
(19, 'Приход', 26, 119, 10),
(20, 'Расход', 27, 120, 10),
(21, 'Приход', 28, 121, 1),
(22, 'Расход', 29, 122, 1),
(23, 'Приход', 30, 123, 2),
(24, 'Расход', 31, 124, 2),
(25, 'Приход', 32, 125, 3),
(26, 'Расход', 33, 126, 3),
(27, 'Приход', 34, 127, 4),
(28, 'Расход', 35, 128, 4),
(29, 'Приход', 36, 129, 5),
(30, 'Расход', 37, 130, 5),
(31, 'Приход', 38, 131, 6),
(32, 'Расход', 39, 132, 6),
(33, 'Приход', 40, 133, 7),
(34, 'Расход', 41, 134, 7),
(35, 'Приход', 42, 135, 8),
(36, 'Расход', 43, 136, 8),
(37, 'Приход', 44, 137, 9),
(38, 'Расход', 45, 138, 9),
(39, 'Приход', 46, 139, 10),
(40, 'Расход', 47, 140, 10),
(41, 'Приход', 48, 141, 1),
(42, 'Расход', 49, 142, 1),
(43, 'Приход', 50, 143, 2),
(44, 'Расход', 51, 144, 2),
(45, 'Приход', 52, 145, 3),
(46, 'Расход', 53, 146, 3),
(47, 'Приход', 54, 147, 4),
(48, 'Расход', 55, 148, 4),
(49, 'Приход', 56, 149, 5),
(50, 'Расход', 57, 150, 5);
COMMIT;
*/
-- -----------------------------------------------------
-- Data for table `mydb`.`Suppliers`
-- -----------------------------------------------------
START TRANSACTION;
USE `mydb`;
INSERT INTO `mydb`.`Suppliers` (`SupplierID`, `Name`, `ContactInfo`) VALUES (1, 'GlassMaster', 'Phone: +79002345678');
INSERT INTO `mydb`.`Suppliers` (`SupplierID`, `Name`, `ContactInfo`) VALUES (2, 'FrameWorks', 'Email: [email protected]');
INSERT INTO `mydb`.`Suppliers` (`SupplierID`, `Name`, `ContactInfo`) VALUES (3, 'SealantSolutions', 'Phone: +79003456789');
INSERT INTO `mydb`.`Suppliers` (`SupplierID`, `Name`, `ContactInfo`) VALUES (4, 'HardwareHub', 'Email: [email protected]');
INSERT INTO `mydb`.`Suppliers` (`SupplierID`, `Name`, `ContactInfo`) VALUES (5, 'AdhesiveExperts', 'Phone: +79004567890');
INSERT INTO `mydb`.`Suppliers` (`SupplierID`, `Name`, `ContactInfo`) VALUES (6, 'InsulationInnovations', 'Email: [email protected]');
INSERT INTO `mydb`.`Suppliers` (`SupplierID`, `Name`, `ContactInfo`) VALUES (7, 'SpacerSystems', 'Phone: +79005678901');
INSERT INTO `mydb`.`Suppliers` (`SupplierID`, `Name`, `ContactInfo`) VALUES (8, 'PaintPartners', 'Email: [email protected]');
INSERT INTO `mydb`.`Suppliers` (`SupplierID`, `Name`, `ContactInfo`) VALUES (9, 'CoatingCompany', 'Phone: +79006789012');
INSERT INTO `mydb`.`Suppliers` (`SupplierID`, `Name`, `ContactInfo`) VALUES (10, 'ReinforcementResources', 'Email: [email protected]');
COMMIT;
-- -----------------------------------------------------
-- Data for table `mydb`.`SupplierContacts`
-- -----------------------------------------------------
START TRANSACTION;
USE `mydb`;
INSERT INTO `mydb`.`SupplierContacts` (`ContactID`, `ContactType`, `Value`, `Suppliers_SupplierID`) VALUES (1, 'Телефон', '+79002345678', 1);
INSERT INTO `mydb`.`SupplierContacts` (`ContactID`, `ContactType`, `Value`, `Suppliers_SupplierID`) VALUES (2, 'Почта', '[email protected]', 2);
INSERT INTO `mydb`.`SupplierContacts` (`ContactID`, `ContactType`, `Value`, `Suppliers_SupplierID`) VALUES (3, 'Телефон', '+79003456789', 3);
INSERT INTO `mydb`.`SupplierContacts` (`ContactID`, `ContactType`, `Value`, `Suppliers_SupplierID`) VALUES (4, 'Почта', '[email protected]', 4);
INSERT INTO `mydb`.`SupplierContacts` (`ContactID`, `ContactType`, `Value`, `Suppliers_SupplierID`) VALUES (5, 'Телефон', '+79004567890', 5);
INSERT INTO `mydb`.`SupplierContacts` (`ContactID`, `ContactType`, `Value`, `Suppliers_SupplierID`) VALUES (6, 'Почта', '[email protected]', 6);
INSERT INTO `mydb`.`SupplierContacts` (`ContactID`, `ContactType`, `Value`, `Suppliers_SupplierID`) VALUES (7, 'Телефон', '+79005678901', 7);
INSERT INTO `mydb`.`SupplierContacts` (`ContactID`, `ContactType`, `Value`, `Suppliers_SupplierID`) VALUES (8, 'Почта', '[email protected]', 8);
INSERT INTO `mydb`.`SupplierContacts` (`ContactID`, `ContactType`, `Value`, `Suppliers_SupplierID`) VALUES (9, 'Телефон', '+79006789012', 9);
INSERT INTO `mydb`.`SupplierContacts` (`ContactID`, `ContactType`, `Value`, `Suppliers_SupplierID`) VALUES (10, 'ПочтаOrderID', '[email protected]', 10);
COMMIT;
-- -----------------------------------------------------
-- Data for table `mydb`.`PurchaseOrders`
-- -----------------------------------------------------
START TRANSACTION;
USE `mydb`;
INSERT INTO `mydb`.`PurchaseOrders` (`PurchaseOrderID`, `OrderDate`, `Status`, `Suppliers_SupplierID`) VALUES (1, '2023-01-01 00:00:00', 'Processing', 1);
INSERT INTO `mydb`.`PurchaseOrders` (`PurchaseOrderID`, `OrderDate`, `Status`, `Suppliers_SupplierID`) VALUES (2, '2023-01-02 00:00:00', 'Completed', 2);
INSERT INTO `mydb`.`PurchaseOrders` (`PurchaseOrderID`, `OrderDate`, `Status`, `Suppliers_SupplierID`) VALUES (3, '2023-01-03 00:00:00', 'Processing', 3);
INSERT INTO `mydb`.`PurchaseOrders` (`PurchaseOrderID`, `OrderDate`, `Status`, `Suppliers_SupplierID`) VALUES (4, '2023-01-04 00:00:00', 'Completed', 4);
INSERT INTO `mydb`.`PurchaseOrders` (`PurchaseOrderID`, `OrderDate`, `Status`, `Suppliers_SupplierID`) VALUES (5, '2023-01-05 00:00:00', 'Processing', 5);
INSERT INTO `mydb`.`PurchaseOrders` (`PurchaseOrderID`, `OrderDate`, `Status`, `Suppliers_SupplierID`) VALUES (6, '2023-01-06 00:00:00', 'Completed', 6);
INSERT INTO `mydb`.`PurchaseOrders` (`PurchaseOrderID`, `OrderDate`, `Status`, `Suppliers_SupplierID`) VALUES (7, '2023-01-07 00:00:00', 'Processing', 7);
INSERT INTO `mydb`.`PurchaseOrders` (`PurchaseOrderID`, `OrderDate`, `Status`, `Suppliers_SupplierID`) VALUES (8, '2023-01-08 00:00:00', 'Completed', 8);
INSERT INTO `mydb`.`PurchaseOrders` (`PurchaseOrderID`, `OrderDate`, `Status`, `Suppliers_SupplierID`) VALUES (9, '2023-01-09 00:00:00', 'Processing', 9);
INSERT INTO `mydb`.`PurchaseOrders` (`PurchaseOrderID`, `OrderDate`, `Status`, `Suppliers_SupplierID`) VALUES (10, '2023-01-10 00:00:00', 'Completed', 10);
COMMIT;
-- -----------------------------------------------------
-- Data for table `mydb`.`PurchaseOrderDetails`
-- -----------------------------------------------------
START TRANSACTION;
USE `mydb`;
INSERT INTO `mydb`.`PurchaseOrderDetails` (`PurchaseDetailID`, `Quantity`, `Price`, `PurchaseOrders_PurchaseOrderID`, `Materials_MaterialID`) VALUES (1, 10, 50.00, 1, 101);
INSERT INTO `mydb`.`PurchaseOrderDetails` (`PurchaseDetailID`, `Quantity`, `Price`, `PurchaseOrders_PurchaseOrderID`, `Materials_MaterialID`) VALUES (2, 15, 75.00, 2, 102);
INSERT INTO `mydb`.`PurchaseOrderDetails` (`PurchaseDetailID`, `Quantity`, `Price`, `PurchaseOrders_PurchaseOrderID`, `Materials_MaterialID`) VALUES (3, 20, 100.00, 3, 103);
INSERT INTO `mydb`.`PurchaseOrderDetails` (`PurchaseDetailID`, `Quantity`, `Price`, `PurchaseOrders_PurchaseOrderID`, `Materials_MaterialID`) VALUES (4, 12, 60.00, 4, 104);
INSERT INTO `mydb`.`PurchaseOrderDetails` (`PurchaseDetailID`, `Quantity`, `Price`, `PurchaseOrders_PurchaseOrderID`, `Materials_MaterialID`) VALUES (5, 8, 40.00, 5, 105);
INSERT INTO `mydb`.`PurchaseOrderDetails` (`PurchaseDetailID`, `Quantity`, `Price`, `PurchaseOrders_PurchaseOrderID`, `Materials_MaterialID`) VALUES (6, 11, 55.00, 6, 106);
INSERT INTO `mydb`.`PurchaseOrderDetails` (`PurchaseDetailID`, `Quantity`, `Price`, `PurchaseOrders_PurchaseOrderID`, `Materials_MaterialID`) VALUES (7, 9, 45.00, 7, 107);
INSERT INTO `mydb`.`PurchaseOrderDetails` (`PurchaseDetailID`, `Quantity`, `Price`, `PurchaseOrders_PurchaseOrderID`, `Materials_MaterialID`) VALUES (8, 13, 65.00, 8, 108);
INSERT INTO `mydb`.`PurchaseOrderDetails` (`PurchaseDetailID`, `Quantity`, `Price`, `PurchaseOrders_PurchaseOrderID`, `Materials_MaterialID`) VALUES (9, 14, 70.00, 9, 109);
INSERT INTO `mydb`.`PurchaseOrderDetails` (`PurchaseDetailID`, `Quantity`, `Price`, `PurchaseOrders_PurchaseOrderID`, `Materials_MaterialID`) VALUES (10, 16, 80.00, 10, 110);
INSERT INTO `mydb`.`PurchaseOrderDetails` (`PurchaseDetailID`, `Quantity`, `Price`, `PurchaseOrders_PurchaseOrderID`, `Materials_MaterialID`) VALUES (11, 17, 85.00, 1, 111);
INSERT INTO `mydb`.`PurchaseOrderDetails` (`PurchaseDetailID`, `Quantity`, `Price`, `PurchaseOrders_PurchaseOrderID`, `Materials_MaterialID`) VALUES (12, 18, 90.00, 2, 112);
INSERT INTO `mydb`.`PurchaseOrderDetails` (`PurchaseDetailID`, `Quantity`, `Price`, `PurchaseOrders_PurchaseOrderID`, `Materials_MaterialID`) VALUES (13, 19, 95.00, 3, 113);
INSERT INTO `mydb`.`PurchaseOrderDetails` (`PurchaseDetailID`, `Quantity`, `Price`, `PurchaseOrders_PurchaseOrderID`, `Materials_MaterialID`) VALUES (14, 21, 105.00, 4, 114);
INSERT INTO `mydb`.`PurchaseOrderDetails` (`PurchaseDetailID`, `Quantity`, `Price`, `PurchaseOrders_PurchaseOrderID`, `Materials_MaterialID`) VALUES (15, 22, 110.00, 5, 115);
INSERT INTO `mydb`.`PurchaseOrderDetails` (`PurchaseDetailID`, `Quantity`, `Price`, `PurchaseOrders_PurchaseOrderID`, `Materials_MaterialID`) VALUES (16, 23, 115.00, 6, 116);
INSERT INTO `mydb`.`PurchaseOrderDetails` (`PurchaseDetailID`, `Quantity`, `Price`, `PurchaseOrders_PurchaseOrderID`, `Materials_MaterialID`) VALUES (17, 24, 120.00, 7, 117);
INSERT INTO `mydb`.`PurchaseOrderDetails` (`PurchaseDetailID`, `Quantity`, `Price`, `PurchaseOrders_PurchaseOrderID`, `Materials_MaterialID`) VALUES (18, 25, 125.00, 8, 118);
INSERT INTO `mydb`.`PurchaseOrderDetails` (`PurchaseDetailID`, `Quantity`, `Price`, `PurchaseOrders_PurchaseOrderID`, `Materials_MaterialID`) VALUES (19, 26, 130.00, 9, 119);
INSERT INTO `mydb`.`PurchaseOrderDetails` (`PurchaseDetailID`, `Quantity`, `Price`, `PurchaseOrders_PurchaseOrderID`, `Materials_MaterialID`) VALUES (20, 27, 135.00, 10, 120);
INSERT INTO `mydb`.`PurchaseOrderDetails` (`PurchaseDetailID`, `Quantity`, `Price`, `PurchaseOrders_PurchaseOrderID`, `Materials_MaterialID`) VALUES (21, 28, 140.00, 1, 121);
INSERT INTO `mydb`.`PurchaseOrderDetails` (`PurchaseDetailID`, `Quantity`, `Price`, `PurchaseOrders_PurchaseOrderID`, `Materials_MaterialID`) VALUES (22, 29, 145.00, 2, 122);
INSERT INTO `mydb`.`PurchaseOrderDetails` (`PurchaseDetailID`, `Quantity`, `Price`, `PurchaseOrders_PurchaseOrderID`, `Materials_MaterialID`) VALUES (23, 30, 150.00, 3, 123);
INSERT INTO `mydb`.`PurchaseOrderDetails` (`PurchaseDetailID`, `Quantity`, `Price`, `PurchaseOrders_PurchaseOrderID`, `Materials_MaterialID`) VALUES (24, 31, 155.00, 4, 124);
INSERT INTO `mydb`.`PurchaseOrderDetails` (`PurchaseDetailID`, `Quantity`, `Price`, `PurchaseOrders_PurchaseOrderID`, `Materials_MaterialID`) VALUES (25, 32, 160.00, 5, 125);
INSERT INTO `mydb`.`PurchaseOrderDetails` (`PurchaseDetailID`, `Quantity`, `Price`, `PurchaseOrders_PurchaseOrderID`, `Materials_MaterialID`) VALUES (26, 33, 165.00, 6, 126);
INSERT INTO `mydb`.`PurchaseOrderDetails` (`PurchaseDetailID`, `Quantity`, `Price`, `PurchaseOrders_PurchaseOrderID`, `Materials_MaterialID`) VALUES (27, 34, 170.00, 7, 127);
INSERT INTO `mydb`.`PurchaseOrderDetails` (`PurchaseDetailID`, `Quantity`, `Price`, `PurchaseOrders_PurchaseOrderID`, `Materials_MaterialID`) VALUES (28, 35, 175.00, 8, 128);
INSERT INTO `mydb`.`PurchaseOrderDetails` (`PurchaseDetailID`, `Quantity`, `Price`, `PurchaseOrders_PurchaseOrderID`, `Materials_MaterialID`) VALUES (29, 36, 180.00, 9, 129);
INSERT INTO `mydb`.`PurchaseOrderDetails` (`PurchaseDetailID`, `Quantity`, `Price`, `PurchaseOrders_PurchaseOrderID`, `Materials_MaterialID`) VALUES (30, 37, 185.00, 10, 130);
INSERT INTO `mydb`.`PurchaseOrderDetails` (`PurchaseDetailID`, `Quantity`, `Price`, `PurchaseOrders_PurchaseOrderID`, `Materials_MaterialID`) VALUES (31, 38, 190.00, 1, 131);
INSERT INTO `mydb`.`PurchaseOrderDetails` (`PurchaseDetailID`, `Quantity`, `Price`, `PurchaseOrders_PurchaseOrderID`, `Materials_MaterialID`) VALUES (32, 39, 195.00, 2, 132);
INSERT INTO `mydb`.`PurchaseOrderDetails` (`PurchaseDetailID`, `Quantity`, `Price`, `PurchaseOrders_PurchaseOrderID`, `Materials_MaterialID`) VALUES (33, 40, 200.00, 3, 133);
INSERT INTO `mydb`.`PurchaseOrderDetails` (`PurchaseDetailID`, `Quantity`, `Price`, `PurchaseOrders_PurchaseOrderID`, `Materials_MaterialID`) VALUES (34, 41, 205.00, 4, 134);
INSERT INTO `mydb`.`PurchaseOrderDetails` (`PurchaseDetailID`, `Quantity`, `Price`, `PurchaseOrders_PurchaseOrderID`, `Materials_MaterialID`) VALUES (35, 42, 210.00, 5, 135);
INSERT INTO `mydb`.`PurchaseOrderDetails` (`PurchaseDetailID`, `Quantity`, `Price`, `PurchaseOrders_PurchaseOrderID`, `Materials_MaterialID`) VALUES (36, 43, 215.00, 6, 136);
INSERT INTO `mydb`.`PurchaseOrderDetails` (`PurchaseDetailID`, `Quantity`, `Price`, `PurchaseOrders_PurchaseOrderID`, `Materials_MaterialID`) VALUES (37, 44, 220.00, 7, 137);
INSERT INTO `mydb`.`PurchaseOrderDetails` (`PurchaseDetailID`, `Quantity`, `Price`, `PurchaseOrders_PurchaseOrderID`, `Materials_MaterialID`) VALUES (38, 45, 225.00, 8, 138);
INSERT INTO `mydb`.`PurchaseOrderDetails` (`PurchaseDetailID`, `Quantity`, `Price`, `PurchaseOrders_PurchaseOrderID`, `Materials_MaterialID`) VALUES (39, 46, 230.00, 9, 139);
INSERT INTO `mydb`.`PurchaseOrderDetails` (`PurchaseDetailID`, `Quantity`, `Price`, `PurchaseOrders_PurchaseOrderID`, `Materials_MaterialID`) VALUES (40, 47, 235.00, 10, 140);
INSERT INTO `mydb`.`PurchaseOrderDetails` (`PurchaseDetailID`, `Quantity`, `Price`, `PurchaseOrders_PurchaseOrderID`, `Materials_MaterialID`) VALUES (41, 48, 240.00, 1, 141);
INSERT INTO `mydb`.`PurchaseOrderDetails` (`PurchaseDetailID`, `Quantity`, `Price`, `PurchaseOrders_PurchaseOrderID`, `Materials_MaterialID`) VALUES (42, 49, 245.00, 2, 142);
INSERT INTO `mydb`.`PurchaseOrderDetails` (`PurchaseDetailID`, `Quantity`, `Price`, `PurchaseOrders_PurchaseOrderID`, `Materials_MaterialID`) VALUES (43, 50, 250.00, 3, 143);
INSERT INTO `mydb`.`PurchaseOrderDetails` (`PurchaseDetailID`, `Quantity`, `Price`, `PurchaseOrders_PurchaseOrderID`, `Materials_MaterialID`) VALUES (44, 51, 255.00, 4, 144);
INSERT INTO `mydb`.`PurchaseOrderDetails` (`PurchaseDetailID`, `Quantity`, `Price`, `PurchaseOrders_PurchaseOrderID`, `Materials_MaterialID`) VALUES (45, 52, 260.00, 5, 145);
INSERT INTO `mydb`.`PurchaseOrderDetails` (`PurchaseDetailID`, `Quantity`, `Price`, `PurchaseOrders_PurchaseOrderID`, `Materials_MaterialID`) VALUES (46, 53, 265.00, 6, 146);
INSERT INTO `mydb`.`PurchaseOrderDetails` (`PurchaseDetailID`, `Quantity`, `Price`, `PurchaseOrders_PurchaseOrderID`, `Materials_MaterialID`) VALUES (47, 54, 270.00, 7, 147);
INSERT INTO `mydb`.`PurchaseOrderDetails` (`PurchaseDetailID`, `Quantity`, `Price`, `PurchaseOrders_PurchaseOrderID`, `Materials_MaterialID`) VALUES (48, 55, 275.00, 8, 148);
INSERT INTO `mydb`.`PurchaseOrderDetails` (`PurchaseDetailID`, `Quantity`, `Price`, `PurchaseOrders_PurchaseOrderID`, `Materials_MaterialID`) VALUES (49, 56, 280.00, 9, 149);
INSERT INTO `mydb`.`PurchaseOrderDetails` (`PurchaseDetailID`, `Quantity`, `Price`, `PurchaseOrders_PurchaseOrderID`, `Materials_MaterialID`) VALUES (50, 57, 285.00, 10, 150);
COMMIT;
-- -----------------------------------------------------
-- Data for table `mydb`.`Invoices`
-- -----------------------------------------------------
START TRANSACTION;
USE `mydb`;
INSERT INTO `mydb`.`Invoices` (`InvoiceID`, `InvoiceDate`, `Amount`) VALUES (1, '2023-01-01 00:00:00', 500.00);
INSERT INTO `mydb`.`Invoices` (`InvoiceID`, `InvoiceDate`, `Amount`) VALUES (2, '2023-01-02 00:00:00', 1000.00);
INSERT INTO `mydb`.`Invoices` (`InvoiceID`, `InvoiceDate`, `Amount`) VALUES (3, '2023-01-03 00:00:00', 750.00);
INSERT INTO `mydb`.`Invoices` (`InvoiceID`, `InvoiceDate`, `Amount`) VALUES (4, '2023-01-04 00:00:00', 1200.00);
INSERT INTO `mydb`.`Invoices` (`InvoiceID`, `InvoiceDate`, `Amount`) VALUES (5, '2023-01-05 00:00:00', 600.00);
INSERT INTO `mydb`.`Invoices` (`InvoiceID`, `InvoiceDate`, `Amount`) VALUES (6, '2023-01-06 00:00:00', 1500.00);
INSERT INTO `mydb`.`Invoices` (`InvoiceID`, `InvoiceDate`, `Amount`) VALUES (7, '2023-01-07 00:00:00', 800.00);
INSERT INTO `mydb`.`Invoices` (`InvoiceID`, `InvoiceDate`, `Amount`) VALUES (8, '2023-01-08 00:00:00', 1300.00);
INSERT INTO `mydb`.`Invoices` (`InvoiceID`, `InvoiceDate`, `Amount`) VALUES (9, '2023-01-09 00:00:00', 650.00);
INSERT INTO `mydb`.`Invoices` (`InvoiceID`, `InvoiceDate`, `Amount`) VALUES (10, '2023-01-10 00:00:00', 1600.00);
INSERT INTO `mydb`.`Invoices` (`InvoiceID`, `InvoiceDate`, `Amount`) VALUES (11, '2023-01-11 00:00:00', 850.00);
INSERT INTO `mydb`.`Invoices` (`InvoiceID`, `InvoiceDate`, `Amount`) VALUES (12, '2023-01-12 00:00:00', 1400.00);
INSERT INTO `mydb`.`Invoices` (`InvoiceID`, `InvoiceDate`, `Amount`) VALUES (13, '2023-01-13 00:00:00', 700.00);
INSERT INTO `mydb`.`Invoices` (`InvoiceID`, `InvoiceDate`, `Amount`) VALUES (14, '2023-01-14 00:00:00', 1700.00);
INSERT INTO `mydb`.`Invoices` (`InvoiceID`, `InvoiceDate`, `Amount`) VALUES (15, '2023-01-15 00:00:00', 900.00);
INSERT INTO `mydb`.`Invoices` (`InvoiceID`, `InvoiceDate`, `Amount`) VALUES (16, '2023-01-16 00:00:00', 1800.00);
INSERT INTO `mydb`.`Invoices` (`InvoiceID`, `InvoiceDate`, `Amount`) VALUES (17, '2023-01-17 00:00:00', 950.00);
INSERT INTO `mydb`.`Invoices` (`InvoiceID`, `InvoiceDate`, `Amount`) VALUES (18, '2023-01-18 00:00:00', 1900.00);
INSERT INTO `mydb`.`Invoices` (`InvoiceID`, `InvoiceDate`, `Amount`) VALUES (19, '2023-01-19 00:00:00', 1000.00);
INSERT INTO `mydb`.`Invoices` (`InvoiceID`, `InvoiceDate`, `Amount`) VALUES (20, '2023-01-20 00:00:00', 2000.00);
INSERT INTO `mydb`.`Invoices` (`InvoiceID`, `InvoiceDate`, `Amount`) VALUES (21, '2023-01-21 00:00:00', 1050.00);
INSERT INTO `mydb`.`Invoices` (`InvoiceID`, `InvoiceDate`, `Amount`) VALUES (22, '2023-01-22 00:00:00', 2100.00);
INSERT INTO `mydb`.`Invoices` (`InvoiceID`, `InvoiceDate`, `Amount`) VALUES (23, '2023-01-23 00:00:00', 1100.00);
INSERT INTO `mydb`.`Invoices` (`InvoiceID`, `InvoiceDate`, `Amount`) VALUES (24, '2023-01-24 00:00:00', 2200.00);
INSERT INTO `mydb`.`Invoices` (`InvoiceID`, `InvoiceDate`, `Amount`) VALUES (25, '2023-01-25 00:00:00', 1150.00);
INSERT INTO `mydb`.`Invoices` (`InvoiceID`, `InvoiceDate`, `Amount`) VALUES (26, '2023-01-26 00:00:00', 2300.00);
INSERT INTO `mydb`.`Invoices` (`InvoiceID`, `InvoiceDate`, `Amount`) VALUES (27, '2023-01-27 00:00:00', 1200.00);
INSERT INTO `mydb`.`Invoices` (`InvoiceID`, `InvoiceDate`, `Amount`) VALUES (28, '2023-01-28 00:00:00', 2400.00);
INSERT INTO `mydb`.`Invoices` (`InvoiceID`, `InvoiceDate`, `Amount`) VALUES (29, '2023-01-29 00:00:00', 1250.00);
INSERT INTO `mydb`.`Invoices` (`InvoiceID`, `InvoiceDate`, `Amount`) VALUES (30, '2023-01-30 00:00:00', 2500.00);
INSERT INTO `mydb`.`Invoices` (`InvoiceID`, `InvoiceDate`, `Amount`) VALUES (31, '2023-01-31 00:00:00', 1300.00);
INSERT INTO `mydb`.`Invoices` (`InvoiceID`, `InvoiceDate`, `Amount`) VALUES (32, '2023-02-01 00:00:00', 2600.00);
INSERT INTO `mydb`.`Invoices` (`InvoiceID`, `InvoiceDate`, `Amount`) VALUES (33, '2023-02-02 00:00:00', 1350.00);
INSERT INTO `mydb`.`Invoices` (`InvoiceID`, `InvoiceDate`, `Amount`) VALUES (34, '2023-02-03 00:00:00', 2700.00);
INSERT INTO `mydb`.`Invoices` (`InvoiceID`, `InvoiceDate`, `Amount`) VALUES (35, '2023-02-04 00:00:00', 1400.00);
INSERT INTO `mydb`.`Invoices` (`InvoiceID`, `InvoiceDate`, `Amount`) VALUES (36, '2023-02-05 00:00:00', 2800.00);
INSERT INTO `mydb`.`Invoices` (`InvoiceID`, `InvoiceDate`, `Amount`) VALUES (37, '2023-02-06 00:00:00', 1450.00);
INSERT INTO `mydb`.`Invoices` (`InvoiceID`, `InvoiceDate`, `Amount`) VALUES (38, '2023-02-07 00:00:00', 2900.00);
INSERT INTO `mydb`.`Invoices` (`InvoiceID`, `InvoiceDate`, `Amount`) VALUES (39, '2023-02-08 00:00:00', 1500.00);
INSERT INTO `mydb`.`Invoices` (`InvoiceID`, `InvoiceDate`, `Amount`) VALUES (40, '2023-02-09 00:00:00', 3000.00);
INSERT INTO `mydb`.`Invoices` (`InvoiceID`, `InvoiceDate`, `Amount`) VALUES (41, '2023-02-10 00:00:00', 1550.00);
INSERT INTO `mydb`.`Invoices` (`InvoiceID`, `InvoiceDate`, `Amount`) VALUES (42, '2023-02-11 00:00:00', 3100.00);
INSERT INTO `mydb`.`Invoices` (`InvoiceID`, `InvoiceDate`, `Amount`) VALUES (43, '2023-02-12 00:00:00', 1600.00);
INSERT INTO `mydb`.`Invoices` (`InvoiceID`, `InvoiceDate`, `Amount`) VALUES (44, '2023-02-13 00:00:00', 3200.00);
INSERT INTO `mydb`.`Invoices` (`InvoiceID`, `InvoiceDate`, `Amount`) VALUES (45, '2023-02-14 00:00:00', 1650.00);
INSERT INTO `mydb`.`Invoices` (`InvoiceID`, `InvoiceDate`, `Amount`) VALUES (46, '2023-02-15 00:00:00', 3300.00);
INSERT INTO `mydb`.`Invoices` (`InvoiceID`, `InvoiceDate`, `Amount`) VALUES (47, '2023-02-16 00:00:00', 1700.00);
INSERT INTO `mydb`.`Invoices` (`InvoiceID`, `InvoiceDate`, `Amount`) VALUES (48, '2023-02-17 00:00:00', 3400.00);
INSERT INTO `mydb`.`Invoices` (`InvoiceID`, `InvoiceDate`, `Amount`) VALUES (49, '2023-02-18 00:00:00', 1750.00);
INSERT INTO `mydb`.`Invoices` (`InvoiceID`, `InvoiceDate`, `Amount`) VALUES (50, '2023-02-19 00:00:00', 3500.00);
COMMIT;
-- -----------------------------------------------------
-- Data for table `mydb`.`Payments`
-- -----------------------------------------------------
START TRANSACTION;
USE `mydb`;
INSERT INTO `mydb`.`Payments` (`PaymentID`, `PaymentDate`, `Amount`, `PaymentMethod`, `Invoices_InvoiceID`) VALUES (1, '2023-01-01 00:00:00', 100.00, 'Cash', 1);
INSERT INTO `mydb`.`Payments` (`PaymentID`, `PaymentDate`, `Amount`, `PaymentMethod`, `Invoices_InvoiceID`) VALUES (2, '2023-01-02 00:00:00', 200.00, 'Credit Card', 2);
INSERT INTO `mydb`.`Payments` (`PaymentID`, `PaymentDate`, `Amount`, `PaymentMethod`, `Invoices_InvoiceID`) VALUES (3, '2023-01-03 00:00:00', 150.00, 'Debit Card', 3);
INSERT INTO `mydb`.`Payments` (`PaymentID`, `PaymentDate`, `Amount`, `PaymentMethod`, `Invoices_InvoiceID`) VALUES (4, '2023-01-04 00:00:00', 300.00, 'Bank Transfer', 4);
INSERT INTO `mydb`.`Payments` (`PaymentID`, `PaymentDate`, `Amount`, `PaymentMethod`, `Invoices_InvoiceID`) VALUES (5, '2023-01-05 00:00:00', 250.00, 'Cash', 5);
INSERT INTO `mydb`.`Payments` (`PaymentID`, `PaymentDate`, `Amount`, `PaymentMethod`, `Invoices_InvoiceID`) VALUES (6, '2023-01-06 00:00:00', 400.00, 'Credit Card', 6);
INSERT INTO `mydb`.`Payments` (`PaymentID`, `PaymentDate`, `Amount`, `PaymentMethod`, `Invoices_InvoiceID`) VALUES (7, '2023-01-07 00:00:00', 350.00, 'Debit Card', 7);
INSERT INTO `mydb`.`Payments` (`PaymentID`, `PaymentDate`, `Amount`, `PaymentMethod`, `Invoices_InvoiceID`) VALUES (8, '2023-01-08 00:00:00', 500.00, 'Bank Transfer', 8);
INSERT INTO `mydb`.`Payments` (`PaymentID`, `PaymentDate`, `Amount`, `PaymentMethod`, `Invoices_InvoiceID`) VALUES (9, '2023-01-09 00:00:00', 450.00, 'Cash', 9);
INSERT INTO `mydb`.`Payments` (`PaymentID`, `PaymentDate`, `Amount`, `PaymentMethod`, `Invoices_InvoiceID`) VALUES (10, '2023-01-10 00:00:00', 600.00, 'Credit Card', 10);
INSERT INTO `mydb`.`Payments` (`PaymentID`, `PaymentDate`, `Amount`, `PaymentMethod`, `Invoices_InvoiceID`) VALUES (11, '2023-01-11 00:00:00', 550.00, 'Debit Card', 11);
INSERT INTO `mydb`.`Payments` (`PaymentID`, `PaymentDate`, `Amount`, `PaymentMethod`, `Invoices_InvoiceID`) VALUES (12, '2023-01-12 00:00:00', 700.00, 'Bank Transfer', 12);
INSERT INTO `mydb`.`Payments` (`PaymentID`, `PaymentDate`, `Amount`, `PaymentMethod`, `Invoices_InvoiceID`) VALUES (13, '2023-01-13 00:00:00', 650.00, 'Cash', 13);
INSERT INTO `mydb`.`Payments` (`PaymentID`, `PaymentDate`, `Amount`, `PaymentMethod`, `Invoices_InvoiceID`) VALUES (14, '2023-01-14 00:00:00', 800.00, 'Credit Card', 14);
INSERT INTO `mydb`.`Payments` (`PaymentID`, `PaymentDate`, `Amount`, `PaymentMethod`, `Invoices_InvoiceID`) VALUES (15, '2023-01-15 00:00:00', 750.00, 'Debit Card', 15);
INSERT INTO `mydb`.`Payments` (`PaymentID`, `PaymentDate`, `Amount`, `PaymentMethod`, `Invoices_InvoiceID`) VALUES (16, '2023-01-16 00:00:00', 900.00, 'Bank Transfer', 16);
INSERT INTO `mydb`.`Payments` (`PaymentID`, `PaymentDate`, `Amount`, `PaymentMethod`, `Invoices_InvoiceID`) VALUES (17, '2023-01-17 00:00:00', 850.00, 'Cash', 17);
INSERT INTO `mydb`.`Payments` (`PaymentID`, `PaymentDate`, `Amount`, `PaymentMethod`, `Invoices_InvoiceID`) VALUES (18, '2023-01-18 00:00:00', 1000.00, 'Credit Card', 18);
INSERT INTO `mydb`.`Payments` (`PaymentID`, `PaymentDate`, `Amount`, `PaymentMethod`, `Invoices_InvoiceID`) VALUES (19, '2023-01-19 00:00:00', 950.00, 'Debit Card', 19);
INSERT INTO `mydb`.`Payments` (`PaymentID`, `PaymentDate`, `Amount`, `PaymentMethod`, `Invoices_InvoiceID`) VALUES (20, '2023-01-20 00:00:00', 1100.00, 'Bank Transfer', 20);
INSERT INTO `mydb`.`Payments` (`PaymentID`, `PaymentDate`, `Amount`, `PaymentMethod`, `Invoices_InvoiceID`) VALUES (21, '2023-01-21 00:00:00', 1050.00, 'Cash', 21);
INSERT INTO `mydb`.`Payments` (`PaymentID`, `PaymentDate`, `Amount`, `PaymentMethod`, `Invoices_InvoiceID`) VALUES (22, '2023-01-22 00:00:00', 1200.00, 'Credit Card', 22);
INSERT INTO `mydb`.`Payments` (`PaymentID`, `PaymentDate`, `Amount`, `PaymentMethod`, `Invoices_InvoiceID`) VALUES (23, '2023-01-23 00:00:00', 1150.00, 'Debit Card', 23);
INSERT INTO `mydb`.`Payments` (`PaymentID`, `PaymentDate`, `Amount`, `PaymentMethod`, `Invoices_InvoiceID`) VALUES (24, '2023-01-24 00:00:00', 1300.00, 'Bank Transfer', 24);
INSERT INTO `mydb`.`Payments` (`PaymentID`, `PaymentDate`, `Amount`, `PaymentMethod`, `Invoices_InvoiceID`) VALUES (25, '2023-01-25 00:00:00', 1250.00, 'Cash', 25);
INSERT INTO `mydb`.`Payments` (`PaymentID`, `PaymentDate`, `Amount`, `PaymentMethod`, `Invoices_InvoiceID`) VALUES (26, '2023-01-26 00:00:00', 1400.00, 'Credit Card', 26);
INSERT INTO `mydb`.`Payments` (`PaymentID`, `PaymentDate`, `Amount`, `PaymentMethod`, `Invoices_InvoiceID`) VALUES (27, '2023-01-27 00:00:00', 1350.00, 'Debit Card', 27);
INSERT INTO `mydb`.`Payments` (`PaymentID`, `PaymentDate`, `Amount`, `PaymentMethod`, `Invoices_InvoiceID`) VALUES (28, '2023-01-28 00:00:00', 1500.00, 'Bank Transfer', 28);
INSERT INTO `mydb`.`Payments` (`PaymentID`, `PaymentDate`, `Amount`, `PaymentMethod`, `Invoices_InvoiceID`) VALUES (29, '2023-01-29 00:00:00', 1450.00, 'Cash', 29);
INSERT INTO `mydb`.`Payments` (`PaymentID`, `PaymentDate`, `Amount`, `PaymentMethod`, `Invoices_InvoiceID`) VALUES (30, '2023-01-30 00:00:00', 1600.00, 'Credit Card', 30);
INSERT INTO `mydb`.`Payments` (`PaymentID`, `PaymentDate`, `Amount`, `PaymentMethod`, `Invoices_InvoiceID`) VALUES (31, '2023-01-31 00:00:00', 1550.00, 'Debit Card', 31);
INSERT INTO `mydb`.`Payments` (`PaymentID`, `PaymentDate`, `Amount`, `PaymentMethod`, `Invoices_InvoiceID`) VALUES (32, '2023-02-01 00:00:00', 1700.00, 'Bank Transfer', 32);
INSERT INTO `mydb`.`Payments` (`PaymentID`, `PaymentDate`, `Amount`, `PaymentMethod`, `Invoices_InvoiceID`) VALUES (33, '2023-02-02 00:00:00', 1650.00, 'Cash', 33);
INSERT INTO `mydb`.`Payments` (`PaymentID`, `PaymentDate`, `Amount`, `PaymentMethod`, `Invoices_InvoiceID`) VALUES (34, '2023-02-03 00:00:00', 1800.00, 'Credit Card', 34);
INSERT INTO `mydb`.`Payments` (`PaymentID`, `PaymentDate`, `Amount`, `PaymentMethod`, `Invoices_InvoiceID`) VALUES (35, '2023-02-04 00:00:00', 1750.00, 'Debit Card', 35);
INSERT INTO `mydb`.`Payments` (`PaymentID`, `PaymentDate`, `Amount`, `PaymentMethod`, `Invoices_InvoiceID`) VALUES (36, '2023-02-05 00:00:00', 1900.00, 'Bank Transfer', 36);
INSERT INTO `mydb`.`Payments` (`PaymentID`, `PaymentDate`, `Amount`, `PaymentMethod`, `Invoices_InvoiceID`) VALUES (37, '2023-02-06 00:00:00', 1850.00, 'Cash', 37);
INSERT INTO `mydb`.`Payments` (`PaymentID`, `PaymentDate`, `Amount`, `PaymentMethod`, `Invoices_InvoiceID`) VALUES (38, '2023-02-07 00:00:00', 2000.00, 'Credit Card', 38);
INSERT INTO `mydb`.`Payments` (`PaymentID`, `PaymentDate`, `Amount`, `PaymentMethod`, `Invoices_InvoiceID`) VALUES (39, '2023-02-08 00:00:00', 1950.00, 'Debit Card', 39);
INSERT INTO `mydb`.`Payments` (`PaymentID`, `PaymentDate`, `Amount`, `PaymentMethod`, `Invoices_InvoiceID`) VALUES (40, '2023-02-09 00:00:00', 2100.00, 'Bank Transfer', 40);
INSERT INTO `mydb`.`Payments` (`PaymentID`, `PaymentDate`, `Amount`, `PaymentMethod`, `Invoices_InvoiceID`) VALUES (41, '2023-02-10 00:00:00', 2050.00, 'Cash', 41);
INSERT INTO `mydb`.`Payments` (`PaymentID`, `PaymentDate`, `Amount`, `PaymentMethod`, `Invoices_InvoiceID`) VALUES (42, '2023-02-11 00:00:00', 2200.00, 'Credit Card', 42);
INSERT INTO `mydb`.`Payments` (`PaymentID`, `PaymentDate`, `Amount`, `PaymentMethod`, `Invoices_InvoiceID`) VALUES (43, '2023-02-12 00:00:00', 2150.00, 'Debit Card', 43);
INSERT INTO `mydb`.`Payments` (`PaymentID`, `PaymentDate`, `Amount`, `PaymentMethod`, `Invoices_InvoiceID`) VALUES (44, '2023-02-13 00:00:00', 2300.00, 'Bank Transfer', 44);
INSERT INTO `mydb`.`Payments` (`PaymentID`, `PaymentDate`, `Amount`, `PaymentMethod`, `Invoices_InvoiceID`) VALUES (45, '2023-02-14 00:00:00', 2250.00, 'Cash', 45);
INSERT INTO `mydb`.`Payments` (`PaymentID`, `PaymentDate`, `Amount`, `PaymentMethod`, `Invoices_InvoiceID`) VALUES (46, '2023-02-15 00:00:00', 2400.00, 'Credit Card', 46);
INSERT INTO `mydb`.`Payments` (`PaymentID`, `PaymentDate`, `Amount`, `PaymentMethod`, `Invoices_InvoiceID`) VALUES (47, '2023-02-16 00:00:00', 2350.00, 'Debit Card', 47);
INSERT INTO `mydb`.`Payments` (`PaymentID`, `PaymentDate`, `Amount`, `PaymentMethod`, `Invoices_InvoiceID`) VALUES (48, '2023-02-17 00:00:00', 2500.00, 'Bank Transfer', 48);
INSERT INTO `mydb`.`Payments` (`PaymentID`, `PaymentDate`, `Amount`, `PaymentMethod`, `Invoices_InvoiceID`) VALUES (49, '2023-02-18 00:00:00', 2450.00, 'Cash', 49);
INSERT INTO `mydb`.`Payments` (`PaymentID`, `PaymentDate`, `Amount`, `PaymentMethod`, `Invoices_InvoiceID`) VALUES (50, '2023-02-19 00:00:00', 2600.00, 'Credit Card', 50);
COMMIT;
-- -----------------------------------------------------
-- Data for table `mydb`.`ExpenseCategories`
-- -----------------------------------------------------
START TRANSACTION;
USE `mydb`;
INSERT INTO `mydb`.`ExpenseCategories` (`ExpenseCategoryID`, `CategoryName`) VALUES (1, 'Raw Materials');
INSERT INTO `mydb`.`ExpenseCategories` (`ExpenseCategoryID`, `CategoryName`) VALUES (2, 'Employee Salaries');
INSERT INTO `mydb`.`ExpenseCategories` (`ExpenseCategoryID`, `CategoryName`) VALUES (3, 'Utilities');
INSERT INTO `mydb`.`ExpenseCategories` (`ExpenseCategoryID`, `CategoryName`) VALUES (4, 'Rent');
INSERT INTO `mydb`.`ExpenseCategories` (`ExpenseCategoryID`, `CategoryName`) VALUES (5, 'Marketing');
INSERT INTO `mydb`.`ExpenseCategories` (`ExpenseCategoryID`, `CategoryName`) VALUES (6, 'Travel');
INSERT INTO `mydb`.`ExpenseCategories` (`ExpenseCategoryID`, `CategoryName`) VALUES (7, 'Training');
INSERT INTO `mydb`.`ExpenseCategories` (`ExpenseCategoryID`, `CategoryName`) VALUES (8, 'Insurance');
INSERT INTO `mydb`.`ExpenseCategories` (`ExpenseCategoryID`, `CategoryName`) VALUES (9, 'Maintenance');
INSERT INTO `mydb`.`ExpenseCategories` (`ExpenseCategoryID`, `CategoryName`) VALUES (10, 'Office Supplies');
COMMIT;
-- -----------------------------------------------------
-- Data for table `mydb`.`Expenses`
-- -----------------------------------------------------
START TRANSACTION;
USE `mydb`;
INSERT INTO `mydb`.`Expenses` (`ExpenseID`, `ExpenseDate`, `Amount`, `ExpenseCategories_ExpenseCategoryID`) VALUES (1, '2023-01-01 00:00:00', 100.00, 1);
INSERT INTO `mydb`.`Expenses` (`ExpenseID`, `ExpenseDate`, `Amount`, `ExpenseCategories_ExpenseCategoryID`) VALUES (2, '2023-01-02 00:00:00', 200.00, 2);
INSERT INTO `mydb`.`Expenses` (`ExpenseID`, `ExpenseDate`, `Amount`, `ExpenseCategories_ExpenseCategoryID`) VALUES (3, '2023-01-03 00:00:00', 150.00, 3);
INSERT INTO `mydb`.`Expenses` (`ExpenseID`, `ExpenseDate`, `Amount`, `ExpenseCategories_ExpenseCategoryID`) VALUES (4, '2023-01-04 00:00:00', 300.00, 4);
INSERT INTO `mydb`.`Expenses` (`ExpenseID`, `ExpenseDate`, `Amount`, `ExpenseCategories_ExpenseCategoryID`) VALUES (5, '2023-01-05 00:00:00', 250.00, 5);
INSERT INTO `mydb`.`Expenses` (`ExpenseID`, `ExpenseDate`, `Amount`, `ExpenseCategories_ExpenseCategoryID`) VALUES (6, '2023-01-06 00:00:00', 400.00, 6);
INSERT INTO `mydb`.`Expenses` (`ExpenseID`, `ExpenseDate`, `Amount`, `ExpenseCategories_ExpenseCategoryID`) VALUES (7, '2023-01-07 00:00:00', 350.00, 7);
INSERT INTO `mydb`.`Expenses` (`ExpenseID`, `ExpenseDate`, `Amount`, `ExpenseCategories_ExpenseCategoryID`) VALUES (8, '2023-01-08 00:00:00', 500.00, 8);
INSERT INTO `mydb`.`Expenses` (`ExpenseID`, `ExpenseDate`, `Amount`, `ExpenseCategories_ExpenseCategoryID`) VALUES (9, '2023-01-09 00:00:00', 450.00, 9);
INSERT INTO `mydb`.`Expenses` (`ExpenseID`, `ExpenseDate`, `Amount`, `ExpenseCategories_ExpenseCategoryID`) VALUES (10, '2023-01-10 00:00:00', 600.00, 10);
INSERT INTO `mydb`.`Expenses` (`ExpenseID`, `ExpenseDate`, `Amount`, `ExpenseCategories_ExpenseCategoryID`) VALUES (11, '2023-01-11 00:00:00', 110.00, 1);
INSERT INTO `mydb`.`Expenses` (`ExpenseID`, `ExpenseDate`, `Amount`, `ExpenseCategories_ExpenseCategoryID`) VALUES (12, '2023-01-12 00:00:00', 220.00, 2);
INSERT INTO `mydb`.`Expenses` (`ExpenseID`, `ExpenseDate`, `Amount`, `ExpenseCategories_ExpenseCategoryID`) VALUES (13, '2023-01-13 00:00:00', 160.00, 3);
INSERT INTO `mydb`.`Expenses` (`ExpenseID`, `ExpenseDate`, `Amount`, `ExpenseCategories_ExpenseCategoryID`) VALUES (14, '2023-01-14 00:00:00', 320.00, 4);
INSERT INTO `mydb`.`Expenses` (`ExpenseID`, `ExpenseDate`, `Amount`, `ExpenseCategories_ExpenseCategoryID`) VALUES (15, '2023-01-15 00:00:00', 260.00, 5);
INSERT INTO `mydb`.`Expenses` (`ExpenseID`, `ExpenseDate`, `Amount`, `ExpenseCategories_ExpenseCategoryID`) VALUES (16, '2023-01-16 00:00:00', 420.00, 6);
INSERT INTO `mydb`.`Expenses` (`ExpenseID`, `ExpenseDate`, `Amount`, `ExpenseCategories_ExpenseCategoryID`) VALUES (17, '2023-01-17 00:00:00', 360.00, 7);
INSERT INTO `mydb`.`Expenses` (`ExpenseID`, `ExpenseDate`, `Amount`, `ExpenseCategories_ExpenseCategoryID`) VALUES (18, '2023-01-18 00:00:00', 520.00, 8);
INSERT INTO `mydb`.`Expenses` (`ExpenseID`, `ExpenseDate`, `Amount`, `ExpenseCategories_ExpenseCategoryID`) VALUES (19, '2023-01-19 00:00:00', 460.00, 9);
INSERT INTO `mydb`.`Expenses` (`ExpenseID`, `ExpenseDate`, `Amount`, `ExpenseCategories_ExpenseCategoryID`) VALUES (20, '2023-01-20 00:00:00', 620.00, 10);
INSERT INTO `mydb`.`Expenses` (`ExpenseID`, `ExpenseDate`, `Amount`, `ExpenseCategories_ExpenseCategoryID`) VALUES (21, '2023-01-21 00:00:00', 120.00, 1);
INSERT INTO `mydb`.`Expenses` (`ExpenseID`, `ExpenseDate`, `Amount`, `ExpenseCategories_ExpenseCategoryID`) VALUES (22, '2023-01-22 00:00:00', 240.00, 2);
INSERT INTO `mydb`.`Expenses` (`ExpenseID`, `ExpenseDate`, `Amount`, `ExpenseCategories_ExpenseCategoryID`) VALUES (23, '2023-01-23 00:00:00', 170.00, 3);
INSERT INTO `mydb`.`Expenses` (`ExpenseID`, `ExpenseDate`, `Amount`, `ExpenseCategories_ExpenseCategoryID`) VALUES (24, '2023-01-24 00:00:00', 340.00, 4);
INSERT INTO `mydb`.`Expenses` (`ExpenseID`, `ExpenseDate`, `Amount`, `ExpenseCategories_ExpenseCategoryID`) VALUES (25, '2023-01-25 00:00:00', 270.00, 5);
INSERT INTO `mydb`.`Expenses` (`ExpenseID`, `ExpenseDate`, `Amount`, `ExpenseCategories_ExpenseCategoryID`) VALUES (26, '2023-01-26 00:00:00', 440.00, 6);
INSERT INTO `mydb`.`Expenses` (`ExpenseID`, `ExpenseDate`, `Amount`, `ExpenseCategories_ExpenseCategoryID`) VALUES (27, '2023-01-27 00:00:00', 370.00, 7);
INSERT INTO `mydb`.`Expenses` (`ExpenseID`, `ExpenseDate`, `Amount`, `ExpenseCategories_ExpenseCategoryID`) VALUES (28, '2023-01-28 00:00:00', 540.00, 8);
INSERT INTO `mydb`.`Expenses` (`ExpenseID`, `ExpenseDate`, `Amount`, `ExpenseCategories_ExpenseCategoryID`) VALUES (29, '2023-01-29 00:00:00', 470.00, 9);
INSERT INTO `mydb`.`Expenses` (`ExpenseID`, `ExpenseDate`, `Amount`, `ExpenseCategories_ExpenseCategoryID`) VALUES (30, '2023-01-30 00:00:00', 640.00, 10);
INSERT INTO `mydb`.`Expenses` (`ExpenseID`, `ExpenseDate`, `Amount`, `ExpenseCategories_ExpenseCategoryID`) VALUES (31, '2023-01-31 00:00:00', 130.00, 1);
INSERT INTO `mydb`.`Expenses` (`ExpenseID`, `ExpenseDate`, `Amount`, `ExpenseCategories_ExpenseCategoryID`) VALUES (32, '2023-02-01 00:00:00', 260.00, 2);
INSERT INTO `mydb`.`Expenses` (`ExpenseID`, `ExpenseDate`, `Amount`, `ExpenseCategories_ExpenseCategoryID`) VALUES (33, '2023-02-02 00:00:00', 180.00, 3);
INSERT INTO `mydb`.`Expenses` (`ExpenseID`, `ExpenseDate`, `Amount`, `ExpenseCategories_ExpenseCategoryID`) VALUES (34, '2023-02-03 00:00:00', 360.00, 4);
INSERT INTO `mydb`.`Expenses` (`ExpenseID`, `ExpenseDate`, `Amount`, `ExpenseCategories_ExpenseCategoryID`) VALUES (35, '2023-02-04 00:00:00', 280.00, 5);
INSERT INTO `mydb`.`Expenses` (`ExpenseID`, `ExpenseDate`, `Amount`, `ExpenseCategories_ExpenseCategoryID`) VALUES (36, '2023-02-05 00:00:00', 460.00, 6);
INSERT INTO `mydb`.`Expenses` (`ExpenseID`, `ExpenseDate`, `Amount`, `ExpenseCategories_ExpenseCategoryID`) VALUES (37, '2023-02-06 00:00:00', 380.00, 7);
INSERT INTO `mydb`.`Expenses` (`ExpenseID`, `ExpenseDate`, `Amount`, `ExpenseCategories_ExpenseCategoryID`) VALUES (38, '2023-02-07 00:00:00', 560.00, 8);
INSERT INTO `mydb`.`Expenses` (`ExpenseID`, `ExpenseDate`, `Amount`, `ExpenseCategories_ExpenseCategoryID`) VALUES (39, '2023-02-08 00:00:00', 480.00, 9);
INSERT INTO `mydb`.`Expenses` (`ExpenseID`, `ExpenseDate`, `Amount`, `ExpenseCategories_ExpenseCategoryID`) VALUES (40, '2023-02-09 00:00:00', 660.00, 10);
INSERT INTO `mydb`.`Expenses` (`ExpenseID`, `ExpenseDate`, `Amount`, `ExpenseCategories_ExpenseCategoryID`) VALUES (41, '2023-02-10 00:00:00', 140.00, 1);
INSERT INTO `mydb`.`Expenses` (`ExpenseID`, `ExpenseDate`, `Amount`, `ExpenseCategories_ExpenseCategoryID`) VALUES (42, '2023-02-11 00:00:00', 280.00, 2);
INSERT INTO `mydb`.`Expenses` (`ExpenseID`, `ExpenseDate`, `Amount`, `ExpenseCategories_ExpenseCategoryID`) VALUES (43, '2023-02-12 00:00:00', 190.00, 3);
INSERT INTO `mydb`.`Expenses` (`ExpenseID`, `ExpenseDate`, `Amount`, `ExpenseCategories_ExpenseCategoryID`) VALUES (44, '2023-02-13 00:00:00', 380.00, 4);
INSERT INTO `mydb`.`Expenses` (`ExpenseID`, `ExpenseDate`, `Amount`, `ExpenseCategories_ExpenseCategoryID`) VALUES (45, '2023-02-14 00:00:00', 290.00, 5);
INSERT INTO `mydb`.`Expenses` (`ExpenseID`, `ExpenseDate`, `Amount`, `ExpenseCategories_ExpenseCategoryID`) VALUES (46, '2023-02-15 00:00:00', 480.00, 6);
INSERT INTO `mydb`.`Expenses` (`ExpenseID`, `ExpenseDate`, `Amount`, `ExpenseCategories_ExpenseCategoryID`) VALUES (47, '2023-02-16 00:00:00', 390.00, 7);
INSERT INTO `mydb`.`Expenses` (`ExpenseID`, `ExpenseDate`, `Amount`, `ExpenseCategories_ExpenseCategoryID`) VALUES (48, '2023-02-17 00:00:00', 580.00, 8);
INSERT INTO `mydb`.`Expenses` (`ExpenseID`, `ExpenseDate`, `Amount`, `ExpenseCategories_ExpenseCategoryID`) VALUES (49, '2023-02-18 00:00:00', 500.00, 9);
INSERT INTO `mydb`.`Expenses` (`ExpenseID`, `ExpenseDate`, `Amount`, `ExpenseCategories_ExpenseCategoryID`) VALUES (50, '2023-02-19 00:00:00', 680.00, 10);
COMMIT;
-- -----------------------------------------------------
-- Data for table `mydb`.`Accounts`
-- -----------------------------------------------------
START TRANSACTION;
USE `mydb`;
INSERT INTO `mydb`.`Accounts` (`AccountID`, `AccountName`, `Balance`) VALUES (1, 'Sales Account', 10000.00);
INSERT INTO `mydb`.`Accounts` (`AccountID`, `AccountName`, `Balance`) VALUES (2, 'Purchase Account', 5000.00);
INSERT INTO `mydb`.`Accounts` (`AccountID`, `AccountName`, `Balance`) VALUES (3, 'Payroll Account', 3000.00);
INSERT INTO `mydb`.`Accounts` (`AccountID`, `AccountName`, `Balance`) VALUES (4, 'General Fund', 2000.00);
INSERT INTO `mydb`.`Accounts` (`AccountID`, `AccountName`, `Balance`) VALUES (5, 'Marketing Budget', 1500.00);
INSERT INTO `mydb`.`Accounts` (`AccountID`, `AccountName`, `Balance`) VALUES (6, 'Research and Development', 2500.00);
INSERT INTO `mydb`.`Accounts` (`AccountID`, `AccountName`, `Balance`) VALUES (7, 'Inventory Account', 3500.00);
INSERT INTO `mydb`.`Accounts` (`AccountID`, `AccountName`, `Balance`) VALUES (8, 'Fixed Assets', 4000.00);
INSERT INTO `mydb`.`Accounts` (`AccountID`, `AccountName`, `Balance`) VALUES (9, 'Loan Account', 5500.00);
INSERT INTO `mydb`.`Accounts` (`AccountID`, `AccountName`, `Balance`) VALUES (10, 'Investment Account', 6000.00);
INSERT INTO `mydb`.`Accounts` (`AccountID`, `AccountName`, `Balance`) VALUES (11, 'Operating Expenses', 7000.00);
INSERT INTO `mydb`.`Accounts` (`AccountID`, `AccountName`, `Balance`) VALUES (12, 'Depreciation Account', 8000.00);
INSERT INTO `mydb`.`Accounts` (`AccountID`, `AccountName`, `Balance`) VALUES (13, 'Tax Account', 9000.00);
INSERT INTO `mydb`.`Accounts` (`AccountID`, `AccountName`, `Balance`) VALUES (14, 'Insurance Account', 10000.00);
INSERT INTO `mydb`.`Accounts` (`AccountID`, `AccountName`, `Balance`) VALUES (15, 'Rent Account', 11000.00);
INSERT INTO `mydb`.`Accounts` (`AccountID`, `AccountName`, `Balance`) VALUES (16, 'Utilities Account', 12000.00);
INSERT INTO `mydb`.`Accounts` (`AccountID`, `AccountName`, `Balance`) VALUES (17, 'Travel Account', 13000.00);
INSERT INTO `mydb`.`Accounts` (`AccountID`, `AccountName`, `Balance`) VALUES (18, 'Training Account', 14000.00);
INSERT INTO `mydb`.`Accounts` (`AccountID`, `AccountName`, `Balance`) VALUES (19, 'Entertainment Account', 15000.00);
INSERT INTO `mydb`.`Accounts` (`AccountID`, `AccountName`, `Balance`) VALUES (20, 'Charitable Contributions', 16000.00);
INSERT INTO `mydb`.`Accounts` (`AccountID`, `AccountName`, `Balance`) VALUES (21, 'Employee Benefits', 17000.00);
INSERT INTO `mydb`.`Accounts` (`AccountID`, `AccountName`, `Balance`) VALUES (22, 'Office Supplies', 18000.00);
INSERT INTO `mydb`.`Accounts` (`AccountID`, `AccountName`, `Balance`) VALUES (23, 'Computer Equipment', 19000.00);
INSERT INTO `mydb`.`Accounts` (`AccountID`, `AccountName`, `Balance`) VALUES (24, 'Furniture and Fixtures', 20000.00);
INSERT INTO `mydb`.`Accounts` (`AccountID`, `AccountName`, `Balance`) VALUES (25, 'Vehicles', 21000.00);
INSERT INTO `mydb`.`Accounts` (`AccountID`, `AccountName`, `Balance`) VALUES (26, 'Leasehold Improvements', 22000.00);
INSERT INTO `mydb`.`Accounts` (`AccountID`, `AccountName`, `Balance`) VALUES (27, 'Patents and Trademarks', 23000.00);
INSERT INTO `mydb`.`Accounts` (`AccountID`, `AccountName`, `Balance`) VALUES (28, 'Goodwill', 24000.00);
INSERT INTO `mydb`.`Accounts` (`AccountID`, `AccountName`, `Balance`) VALUES (29, 'Long-Term Investments', 25000.00);
INSERT INTO `mydb`.`Accounts` (`AccountID`, `AccountName`, `Balance`) VALUES (30, 'Retained Earnings', 26000.00);
INSERT INTO `mydb`.`Accounts` (`AccountID`, `AccountName`, `Balance`) VALUES (31, 'Common Stock', 27000.00);
INSERT INTO `mydb`.`Accounts` (`AccountID`, `AccountName`, `Balance`) VALUES (32, 'Preferred Stock', 28000.00);
INSERT INTO `mydb`.`Accounts` (`AccountID`, `AccountName`, `Balance`) VALUES (33, 'Dividends Payable', 29000.00);
INSERT INTO `mydb`.`Accounts` (`AccountID`, `AccountName`, `Balance`) VALUES (34, 'Accrued Liabilities', 30000.00);
INSERT INTO `mydb`.`Accounts` (`AccountID`, `AccountName`, `Balance`) VALUES (35, 'Unearned Revenue', 31000.00);
INSERT INTO `mydb`.`Accounts` (`AccountID`, `AccountName`, `Balance`) VALUES (36, 'Deferred Tax Liability', 32000.00);
INSERT INTO `mydb`.`Accounts` (`AccountID`, `AccountName`, `Balance`) VALUES (37, 'Contingent Liabilities', 33000.00);
INSERT INTO `mydb`.`Accounts` (`AccountID`, `AccountName`, `Balance`) VALUES (38, 'Provision for Doubtful Debts', 34000.00);
INSERT INTO `mydb`.`Accounts` (`AccountID`, `AccountName`, `Balance`) VALUES (39, 'Provision for Warranty Costs', 35000.00);
INSERT INTO `mydb`.`Accounts` (`AccountID`, `AccountName`, `Balance`) VALUES (40, 'Provision for Restructuring Costs', 36000.00);
INSERT INTO `mydb`.`Accounts` (`AccountID`, `AccountName`, `Balance`) VALUES (41, 'Provision for Environmental Costs', 37000.00);
INSERT INTO `mydb`.`Accounts` (`AccountID`, `AccountName`, `Balance`) VALUES (42, 'Provision for Legal Claims', 38000.00);
INSERT INTO `mydb`.`Accounts` (`AccountID`, `AccountName`, `Balance`) VALUES (43, 'Provision for Pension Costs', 39000.00);
INSERT INTO `mydb`.`Accounts` (`AccountID`, `AccountName`, `Balance`) VALUES (44, 'Provision for Post-Employment Benefits', 40000.00);
INSERT INTO `mydb`.`Accounts` (`AccountID`, `AccountName`, `Balance`) VALUES (45, 'Provision for Long-Term Care Costs', 41000.00);
INSERT INTO `mydb`.`Accounts` (`AccountID`, `AccountName`, `Balance`) VALUES (46, 'Provision for Asset Retirement Costs', 42000.00);
INSERT INTO `mydb`.`Accounts` (`AccountID`, `AccountName`, `Balance`) VALUES (47, 'Provision for Asset Impairment Costs', 43000.00);
INSERT INTO `mydb`.`Accounts` (`AccountID`, `AccountName`, `Balance`) VALUES (48, 'Provision for Asset Disposal Costs', 44000.00);
INSERT INTO `mydb`.`Accounts` (`AccountID`, `AccountName`, `Balance`) VALUES (49, 'Provision for Asset Write-Down Costs', 45000.00);
INSERT INTO `mydb`.`Accounts` (`AccountID`, `AccountName`, `Balance`) VALUES (50, 'Provision for Asset Revaluation Costs', 46000.00);
COMMIT;
-- -----------------------------------------------------
-- Data for table `mydb`.`AccountTransactions`
-- -----------------------------------------------------
START TRANSACTION;
USE `mydb`;
INSERT INTO `mydb`.`AccountTransactions` (`TransactionID`, `TransactionDate`, `Amount`, `TransactionType`, `Accounts_AccountID`)
VALUES
(1, '2023-01-01 00:00:00', 100.00, 'Доход', 1),
(2, '2023-01-02 00:00:00', 200.00, 'Расход', 2),
(3, '2023-01-03 00:00:00', 150.00, 'Доход', 3),
(4, '2023-01-04 00:00:00', 300.00, 'Расход', 4),
(5, '2023-01-05 00:00:00', 250.00, 'Доход', 5),
(6, '2023-01-06 00:00:00', 400.00, 'Расход', 6),
(7, '2023-01-07 00:00:00', 350.00, 'Доход', 7),
(8, '2023-01-08 00:00:00', 500.00, 'Расход', 8),
(9, '2023-01-09 00:00:00', 450.00, 'Доход', 9),
(10, '2023-01-10 00:00:00', 600.00, 'Расход', 10),
(11, '2023-01-11 00:00:00', 550.00, 'Доход', 11),
(12, '2023-01-12 00:00:00', 700.00, 'Расход', 12),
(13, '2023-01-13 00:00:00', 650.00, 'Доход', 13),
(14, '2023-01-14 00:00:00', 800.00, 'Расход', 14),
(15, '2023-01-15 00:00:00', 750.00, 'Доход', 15),
(16, '2023-01-16 00:00:00', 900.00, 'Расход', 16),
(17, '2023-01-17 00:00:00', 850.00, 'Доход', 17),
(18, '2023-01-18 00:00:00', 1000.00, 'Расход', 18),
(19, '2023-01-19 00:00:00', 950.00, 'Доход', 19),
(20, '2023-01-20 00:00:00', 1100.00, 'Расход', 20),
(21, '2023-01-21 00:00:00', 1050.00, 'Доход', 21),
(22, '2023-01-22 00:00:00', 1200.00, 'Расход', 22),
(23, '2023-01-23 00:00:00', 1150.00, 'Доход', 23),
(24, '2023-01-24 00:00:00', 1300.00, 'Расход', 24),
(25, '2023-01-25 00:00:00', 1250.00, 'Доход', 25),
(26, '2023-01-26 00:00:00', 1400.00, 'Расход', 26),
(27, '2023-01-27 00:00:00', 1350.00, 'Доход', 27),
(28, '2023-01-28 00:00:00', 1500.00, 'Расход', 28),
(29, '2023-01-29 00:00:00', 1450.00, 'Доход', 29),
(30, '2023-01-30 00:00:00', 1600.00, 'Расход', 30),
(31, '2023-01-31 00:00:00', 1550.00, 'Доход', 31),
(32, '2023-02-01 00:00:00', 1700.00, 'Расход', 32),
(33, '2023-02-02 00:00:00', 1650.00, 'Доход', 33),
(34, '2023-02-03 00:00:00', 1800.00, 'Расход', 34),
(35, '2023-02-04 00:00:00', 1750.00, 'Доход', 35),
(36, '2023-02-05 00:00:00', 1900.00, 'Расход', 36),
(37, '2023-02-06 00:00:00', 1850.00, 'Доход', 37),
(38, '2023-02-07 00:00:00', 2000.00, 'Расход', 38),
(39, '2023-02-08 00:00:00', 1950.00, 'Доход', 39),
(40, '2023-02-09 00:00:00', 2100.00, 'Расход', 40),
(41, '2023-02-10 00:00:00', 2050.00, 'Доход', 41),
(42, '2023-02-11 00:00:00', 2200.00, 'Расход', 42),
(43, '2023-02-12 00:00:00', 2150.00, 'Доход', 43),
(44, '2023-02-13 00:00:00', 2300.00, 'Расход', 44),
(45, '2023-02-14 00:00:00', 2250.00, 'Доход', 45),
(46, '2023-02-15 00:00:00', 2400.00, 'Расход', 46),
(47, '2023-02-16 00:00:00', 2350.00, 'Доход', 47),
(48, '2023-02-17 00:00:00', 2500.00, 'Расход', 48),
(49, '2023-02-18 00:00:00', 2450.00, 'Доход', 49),
(50, '2023-02-19 00:00:00', 2600.00, 'Расход', 50);
COMMIT;
-- -----------------------------------------------------
-- Data for table `mydb`.`Departments`
-- -----------------------------------------------------
START TRANSACTION;
USE `mydb`;
INSERT INTO `mydb`.`Departments` (`DepartmentID`, `DepartmentName`) VALUES (1, 'Production');
INSERT INTO `mydb`.`Departments` (`DepartmentID`, `DepartmentName`) VALUES (2, 'Finance');
INSERT INTO `mydb`.`Departments` (`DepartmentID`, `DepartmentName`) VALUES (3, 'HR');
INSERT INTO `mydb`.`Departments` (`DepartmentID`, `DepartmentName`) VALUES (4, 'Marketing');
INSERT INTO `mydb`.`Departments` (`DepartmentID`, `DepartmentName`) VALUES (5, 'IT');
COMMIT;
-- -----------------------------------------------------
-- Data for table `mydb`.`Employees`
-- -----------------------------------------------------
START TRANSACTION;
USE `mydb`;
INSERT INTO `mydb`.`Employees` (`EmployeeID`, `Name`, `Position`, `ContactInfo`) VALUES (1, 'Artem Vladimirov', 'Engineer', '[email protected]');
INSERT INTO `mydb`.`Employees` (`EmployeeID`, `Name`, `Position`, `ContactInfo`) VALUES (2, 'Sofia Kozlova', 'Technician', '[email protected]');
INSERT INTO `mydb`.`Employees` (`EmployeeID`, `Name`, `Position`, `ContactInfo`) VALUES (3, 'Daniil Morozov', 'Technician', '[email protected]');
INSERT INTO `mydb`.`Employees` (`EmployeeID`, `Name`, `Position`, `ContactInfo`) VALUES (4, 'Anastasia Volkova', 'Accountant', '[email protected]');
INSERT INTO `mydb`.`Employees` (`EmployeeID`, `Name`, `Position`, `ContactInfo`) VALUES (5, 'Mikhail Ivanov', 'HR Specialist', '[email protected]');
INSERT INTO `mydb`.`Employees` (`EmployeeID`, `Name`, `Position`, `ContactInfo`) VALUES (6, 'Yulia Petrova', 'Designer', '[email protected]');
INSERT INTO `mydb`.`Employees` (`EmployeeID`, `Name`, `Position`, `ContactInfo`) VALUES (7, 'Roman Sidorov', 'Analyst', '[email protected]');
INSERT INTO `mydb`.`Employees` (`EmployeeID`, `Name`, `Position`, `ContactInfo`) VALUES (8, 'Ekaterina Fedorova', 'Developer', '[email protected]');
INSERT INTO `mydb`.`Employees` (`EmployeeID`, `Name`, `Position`, `ContactInfo`) VALUES (9, 'Alexander Smirnov', 'Secretary', '[email protected]');
INSERT INTO `mydb`.`Employees` (`EmployeeID`, `Name`, `Position`, `ContactInfo`) VALUES (10, 'Viktor Vasiliev', 'Supervisor', '[email protected]');
INSERT INTO `mydb`.`Employees` (`EmployeeID`, `Name`, `Position`, `ContactInfo`) VALUES (11, 'Natalia Kovaleva', 'Consultant', '[email protected]');
INSERT INTO `mydb`.`Employees` (`EmployeeID`, `Name`, `Position`, `ContactInfo`) VALUES (12, 'Denis Mikhailov', 'Specialist', '[email protected]');
INSERT INTO `mydb`.`Employees` (`EmployeeID`, `Name`, `Position`, `ContactInfo`) VALUES (13, 'Polina Egorova', 'Coordinator', '[email protected]');
INSERT INTO `mydb`.`Employees` (`EmployeeID`, `Name`, `Position`, `ContactInfo`) VALUES (14, 'Konstantin Pavlov', 'Lead', '[email protected]');
INSERT INTO `mydb`.`Employees` (`EmployeeID`, `Name`, `Position`, `ContactInfo`) VALUES (15, 'Alina Sokolova', 'Assistant', '[email protected]');
INSERT INTO `mydb`.`Employees` (`EmployeeID`, `Name`, `Position`, `ContactInfo`) VALUES (16, 'Ilya Zakharyev', 'Operator', '[email protected]');
INSERT INTO `mydb`.`Employees` (`EmployeeID`, `Name`, `Position`, `ContactInfo`) VALUES (17, 'Egor Grigoryev', 'Analyst', '[email protected]');
INSERT INTO `mydb`.`Employees` (`EmployeeID`, `Name`, `Position`, `ContactInfo`) VALUES (18, 'Tatiana Romanova', 'Specialist', '[email protected]');
INSERT INTO `mydb`.`Employees` (`EmployeeID`, `Name`, `Position`, `ContactInfo`) VALUES (19, 'Aleksey Shevchenko', 'Engineer', '[email protected]');
INSERT INTO `mydb`.`Employees` (`EmployeeID`, `Name`, `Position`, `ContactInfo`) VALUES (20, 'Ksenia Kuznetsova', 'Technician', '[email protected]');
INSERT INTO `mydb`.`Employees` (`EmployeeID`, `Name`, `Position`, `ContactInfo`) VALUES (21, 'Matvey Lebedev', 'Technician', '[email protected]');
INSERT INTO `mydb`.`Employees` (`EmployeeID`, `Name`, `Position`, `ContactInfo`) VALUES (22, 'Valeria Volkova', 'Accountant', '[email protected]');
INSERT INTO `mydb`.`Employees` (`EmployeeID`, `Name`, `Position`, `ContactInfo`) VALUES (23, 'Andrei Morozov', 'HR Specialist', '[email protected]');
INSERT INTO `mydb`.`Employees` (`EmployeeID`, `Name`, `Position`, `ContactInfo`) VALUES (24, 'Nikita Nikitin', 'Designer', '[email protected]');
INSERT INTO `mydb`.`Employees` (`EmployeeID`, `Name`, `Position`, `ContactInfo`) VALUES (25, 'Veronika Fedorova', 'Developer', '[email protected]');
INSERT INTO `mydb`.`Employees` (`EmployeeID`, `Name`, `Position`, `ContactInfo`) VALUES (26, 'Maxim Filippov', 'Secretary', '[email protected]');
INSERT INTO `mydb`.`Employees` (`EmployeeID`, `Name`, `Position`, `ContactInfo`) VALUES (27, 'Dmitry Stepanov', 'Technician', '[email protected]');
INSERT INTO `mydb`.`Employees` (`EmployeeID`, `Name`, `Position`, `ContactInfo`) VALUES (28, 'Pavel Ivanov', 'Consultant', '[email protected]');
INSERT INTO `mydb`.`Employees` (`EmployeeID`, `Name`, `Position`, `ContactInfo`) VALUES (29, 'Oksana Sidorova', 'Specialist', '[email protected]');
INSERT INTO `mydb`.`Employees` (`EmployeeID`, `Name`, `Position`, `ContactInfo`) VALUES (30, 'Grigory Kuznetsov', 'Technician', '[email protected]');
INSERT INTO `mydb`.`Employees` (`EmployeeID`, `Name`, `Position`, `ContactInfo`) VALUES (31, 'Karina Morozova', 'Assistant', '[email protected]');
INSERT INTO `mydb`.`Employees` (`EmployeeID`, `Name`, `Position`, `ContactInfo`) VALUES (32, 'Ilia Nikolaev', 'Engineer', '[email protected]');
INSERT INTO `mydb`.`Employees` (`EmployeeID`, `Name`, `Position`, `ContactInfo`) VALUES (33, 'Aleksandra Fedorova', 'Technician', '[email protected]');
INSERT INTO `mydb`.`Employees` (`EmployeeID`, `Name`, `Position`, `ContactInfo`) VALUES (34, 'Sergey Alekseev', 'Accountant', '[email protected]');
INSERT INTO `mydb`.`Employees` (`EmployeeID`, `Name`, `Position`, `ContactInfo`) VALUES (35, 'Mariya Smirnova', 'Technician', '[email protected]');
INSERT INTO `mydb`.`Employees` (`EmployeeID`, `Name`, `Position`, `ContactInfo`) VALUES (36, 'Vladislav Vasiliev', 'Manager', '[email protected]');
INSERT INTO `mydb`.`Employees` (`EmployeeID`, `Name`, `Position`, `ContactInfo`) VALUES (37, 'Elizaveta Kovaleva', 'Designer', '[email protected]');
INSERT INTO `mydb`.`Employees` (`EmployeeID`, `Name`, `Position`, `ContactInfo`) VALUES (38, 'Evgeniy Mikhailov', 'Specialist', '[email protected]');
INSERT INTO `mydb`.`Employees` (`EmployeeID`, `Name`, `Position`, `ContactInfo`) VALUES (39, 'Darya Egorova', 'Developer', '[email protected]');
INSERT INTO `mydb`.`Employees` (`EmployeeID`, `Name`, `Position`, `ContactInfo`) VALUES (40, 'Ivan Pavlov', 'Technician', '[email protected]');
INSERT INTO `mydb`.`Employees` (`EmployeeID`, `Name`, `Position`, `ContactInfo`) VALUES (41, 'Anna Sokolova', 'Assistant', '[email protected]');
INSERT INTO `mydb`.`Employees` (`EmployeeID`, `Name`, `Position`, `ContactInfo`) VALUES (42, 'Aleksey Zakharyev', 'Engineer', '[email protected]');
INSERT INTO `mydb`.`Employees` (`EmployeeID`, `Name`, `Position`, `ContactInfo`) VALUES (43, 'Mark Grigoryev', 'Technician', '[email protected]');
INSERT INTO `mydb`.`Employees` (`EmployeeID`, `Name`, `Position`, `ContactInfo`) VALUES (44, 'Viktoria Romanova', 'Accountant', '[email protected]');
INSERT INTO `mydb`.`Employees` (`EmployeeID`, `Name`, `Position`, `ContactInfo`) VALUES (45, 'Vadim Shevchenko', 'Technician', '[email protected]');
INSERT INTO `mydb`.`Employees` (`EmployeeID`, `Name`, `Position`, `ContactInfo`) VALUES (46, 'Olga Kuznetsova', 'Consultant', '[email protected]');
INSERT INTO `mydb`.`Employees` (`EmployeeID`, `Name`, `Position`, `ContactInfo`) VALUES (47, 'Dmitriy Lebedev', 'Specialist', '[email protected]');
INSERT INTO `mydb`.`Employees` (`EmployeeID`, `Name`, `Position`, `ContactInfo`) VALUES (48, 'Anastasiya Volkova', 'Technician', '[email protected]');
INSERT INTO `mydb`.`Employees` (`EmployeeID`, `Name`, `Position`, `ContactInfo`) VALUES (49, 'Anton Morozov', 'Assistant', '[email protected]');
INSERT INTO `mydb`.`Employees` (`EmployeeID`, `Name`, `Position`, `ContactInfo`) VALUES (50, 'Nikolay Nikitin', 'Engineer', '[email protected]');
COMMIT;
START TRANSACTION;
USE `mydb`;
-- Связываем сотрудников с департаментами
INSERT INTO `mydb`.`EmployeeDepartments` (`Departments_DepartmentID`, `Employees_EmployeeID`)
VALUES
-- Производство (Production)
(1, 1), -- Artem Vladimirov
(1, 7),
(1, 13),
(1, 19),
(1, 25),
(1, 31),
(1, 37),
(1, 43),
(1, 49),
-- Финансы (Finance)
(2, 4),
(2, 10),
(2, 16),
(2, 22),
(2, 28),
(2, 34),
(2, 40),
(2, 46),
-- HR
(3, 5),
(3, 11),
(3, 17),
(3, 23),
(3, 29),
(3, 35),
(3, 41),
(3, 47),
-- Маркетинг (Marketing)
(4, 6),
(4, 12),
(4, 18),
(4, 24),
(4, 30),
(4, 36),
(4, 42),
(4, 48),
-- IT
(5, 8),
(5, 14),
(5, 20),
(5, 26),
(5, 32),
(5, 38),
(5, 44),
(5, 50);
COMMIT;
-- -----------------------------------------------------
-- Data for table `mydb`.`Salaries`
-- -----------------------------------------------------
START TRANSACTION;
USE `mydb`;
INSERT INTO `mydb`.`Salaries` (`SalaryID`, `SalaryDate`, `Amount`, `Employees_EmployeeID`) VALUES (1, '2023-01-01', 5000.00, 1);
INSERT INTO `mydb`.`Salaries` (`SalaryID`, `SalaryDate`, `Amount`, `Employees_EmployeeID`) VALUES (2, '2023-01-02', 6000.00, 2);
INSERT INTO `mydb`.`Salaries` (`SalaryID`, `SalaryDate`, `Amount`, `Employees_EmployeeID`) VALUES (3, '2023-01-03', 5500.00, 3);
INSERT INTO `mydb`.`Salaries` (`SalaryID`, `SalaryDate`, `Amount`, `Employees_EmployeeID`) VALUES (4, '2023-01-04', 7000.00, 4);
INSERT INTO `mydb`.`Salaries` (`SalaryID`, `SalaryDate`, `Amount`, `Employees_EmployeeID`) VALUES (5, '2023-01-05', 6500.00, 5);
INSERT INTO `mydb`.`Salaries` (`SalaryID`, `SalaryDate`, `Amount`, `Employees_EmployeeID`) VALUES (6, '2023-01-06', 8000.00, 6);
INSERT INTO `mydb`.`Salaries` (`SalaryID`, `SalaryDate`, `Amount`, `Employees_EmployeeID`) VALUES (7, '2023-01-07', 7500.00, 7);
INSERT INTO `mydb`.`Salaries` (`SalaryID`, `SalaryDate`, `Amount`, `Employees_EmployeeID`) VALUES (8, '2023-01-08', 9000.00, 8);
INSERT INTO `mydb`.`Salaries` (`SalaryID`, `SalaryDate`, `Amount`, `Employees_EmployeeID`) VALUES (9, '2023-01-09', 8500.00, 9);
INSERT INTO `mydb`.`Salaries` (`SalaryID`, `SalaryDate`, `Amount`, `Employees_EmployeeID`) VALUES (10, '2023-01-10', 10000.00, 10);
INSERT INTO `mydb`.`Salaries` (`SalaryID`, `SalaryDate`, `Amount`, `Employees_EmployeeID`) VALUES (11, '2023-01-11', 9500.00, 11);
INSERT INTO `mydb`.`Salaries` (`SalaryID`, `SalaryDate`, `Amount`, `Employees_EmployeeID`) VALUES (12, '2023-01-12', 11000.00, 12);
INSERT INTO `mydb`.`Salaries` (`SalaryID`, `SalaryDate`, `Amount`, `Employees_EmployeeID`) VALUES (13, '2023-01-13', 10500.00, 13);
INSERT INTO `mydb`.`Salaries` (`SalaryID`, `SalaryDate`, `Amount`, `Employees_EmployeeID`) VALUES (14, '2023-01-14', 12000.00, 14);
INSERT INTO `mydb`.`Salaries` (`SalaryID`, `SalaryDate`, `Amount`, `Employees_EmployeeID`) VALUES (15, '2023-01-15', 11500.00, 15);
INSERT INTO `mydb`.`Salaries` (`SalaryID`, `SalaryDate`, `Amount`, `Employees_EmployeeID`) VALUES (16, '2023-01-16', 13000.00, 16);
INSERT INTO `mydb`.`Salaries` (`SalaryID`, `SalaryDate`, `Amount`, `Employees_EmployeeID`) VALUES (17, '2023-01-17', 12500.00, 17);
INSERT INTO `mydb`.`Salaries` (`SalaryID`, `SalaryDate`, `Amount`, `Employees_EmployeeID`) VALUES (18, '2023-01-18', 14000.00, 18);
INSERT INTO `mydb`.`Salaries` (`SalaryID`, `SalaryDate`, `Amount`, `Employees_EmployeeID`) VALUES (19, '2023-01-19', 13500.00, 19);
INSERT INTO `mydb`.`Salaries` (`SalaryID`, `SalaryDate`, `Amount`, `Employees_EmployeeID`) VALUES (20, '2023-01-20', 15000.00, 20);
INSERT INTO `mydb`.`Salaries` (`SalaryID`, `SalaryDate`, `Amount`, `Employees_EmployeeID`) VALUES (21, '2023-01-21', 14500.00, 21);
INSERT INTO `mydb`.`Salaries` (`SalaryID`, `SalaryDate`, `Amount`, `Employees_EmployeeID`) VALUES (22, '2023-01-22', 16000.00, 22);
INSERT INTO `mydb`.`Salaries` (`SalaryID`, `SalaryDate`, `Amount`, `Employees_EmployeeID`) VALUES (23, '2023-01-23', 15500.00, 23);
INSERT INTO `mydb`.`Salaries` (`SalaryID`, `SalaryDate`, `Amount`, `Employees_EmployeeID`) VALUES (24, '2023-01-24', 17000.00, 24);
INSERT INTO `mydb`.`Salaries` (`SalaryID`, `SalaryDate`, `Amount`, `Employees_EmployeeID`) VALUES (25, '2023-01-25', 16500.00, 25);
INSERT INTO `mydb`.`Salaries` (`SalaryID`, `SalaryDate`, `Amount`, `Employees_EmployeeID`) VALUES (26, '2023-01-26', 18000.00, 26);
INSERT INTO `mydb`.`Salaries` (`SalaryID`, `SalaryDate`, `Amount`, `Employees_EmployeeID`) VALUES (27, '2023-01-27', 17500.00, 27);
INSERT INTO `mydb`.`Salaries` (`SalaryID`, `SalaryDate`, `Amount`, `Employees_EmployeeID`) VALUES (28, '2023-01-28', 19000.00, 28);
INSERT INTO `mydb`.`Salaries` (`SalaryID`, `SalaryDate`, `Amount`, `Employees_EmployeeID`) VALUES (29, '2023-01-29', 18500.00, 29);
INSERT INTO `mydb`.`Salaries` (`SalaryID`, `SalaryDate`, `Amount`, `Employees_EmployeeID`) VALUES (30, '2023-01-30', 20000.00, 30);
INSERT INTO `mydb`.`Salaries` (`SalaryID`, `SalaryDate`, `Amount`, `Employees_EmployeeID`) VALUES (31, '2023-02-01', 19500.00, 31);
INSERT INTO `mydb`.`Salaries` (`SalaryID`, `SalaryDate`, `Amount`, `Employees_EmployeeID`) VALUES (32, '2023-02-02', 21000.00, 32);
INSERT INTO `mydb`.`Salaries` (`SalaryID`, `SalaryDate`, `Amount`, `Employees_EmployeeID`) VALUES (33, '2023-02-03', 20500.00, 33);
INSERT INTO `mydb`.`Salaries` (`SalaryID`, `SalaryDate`, `Amount`, `Employees_EmployeeID`) VALUES (34, '2023-02-04', 22000.00, 34);
INSERT INTO `mydb`.`Salaries` (`SalaryID`, `SalaryDate`, `Amount`, `Employees_EmployeeID`) VALUES (35, '2023-02-05', 21500.00, 35);
INSERT INTO `mydb`.`Salaries` (`SalaryID`, `SalaryDate`, `Amount`, `Employees_EmployeeID`) VALUES (36, '2023-02-06', 23000.00, 36);
INSERT INTO `mydb`.`Salaries` (`SalaryID`, `SalaryDate`, `Amount`, `Employees_EmployeeID`) VALUES (37, '2023-02-07', 22500.00, 37);
INSERT INTO `mydb`.`Salaries` (`SalaryID`, `SalaryDate`, `Amount`, `Employees_EmployeeID`) VALUES (38, '2023-02-08', 24000.00, 38);
INSERT INTO `mydb`.`Salaries` (`SalaryID`, `SalaryDate`, `Amount`, `Employees_EmployeeID`) VALUES (39, '2023-02-09', 23500.00, 39);
INSERT INTO `mydb`.`Salaries` (`SalaryID`, `SalaryDate`, `Amount`, `Employees_EmployeeID`) VALUES (40, '2023-02-10', 25000.00, 40);
INSERT INTO `mydb`.`Salaries` (`SalaryID`, `SalaryDate`, `Amount`, `Employees_EmployeeID`) VALUES (41, '2023-02-11', 24500.00, 41);
INSERT INTO `mydb`.`Salaries` (`SalaryID`, `SalaryDate`, `Amount`, `Employees_EmployeeID`) VALUES (42, '2023-02-12', 26000.00, 42);
INSERT INTO `mydb`.`Salaries` (`SalaryID`, `SalaryDate`, `Amount`, `Employees_EmployeeID`) VALUES (43, '2023-02-13', 25500.00, 43);
INSERT INTO `mydb`.`Salaries` (`SalaryID`, `SalaryDate`, `Amount`, `Employees_EmployeeID`) VALUES (44, '2023-02-14', 27000.00, 44);
INSERT INTO `mydb`.`Salaries` (`SalaryID`, `SalaryDate`, `Amount`, `Employees_EmployeeID`) VALUES (45, '2023-02-15', 26500.00, 45);
INSERT INTO `mydb`.`Salaries` (`SalaryID`, `SalaryDate`, `Amount`, `Employees_EmployeeID`) VALUES (46, '2023-02-16', 28000.00, 46);
INSERT INTO `mydb`.`Salaries` (`SalaryID`, `SalaryDate`, `Amount`, `Employees_EmployeeID`) VALUES (47, '2023-02-17', 27500.00, 47);
INSERT INTO `mydb`.`Salaries` (`SalaryID`, `SalaryDate`, `Amount`, `Employees_EmployeeID`) VALUES (48, '2023-02-18', 29000.00, 48);
INSERT INTO `mydb`.`Salaries` (`SalaryID`, `SalaryDate`, `Amount`, `Employees_EmployeeID`) VALUES (49, '2023-02-19', 28500.00, 49);
INSERT INTO `mydb`.`Salaries` (`SalaryID`, `SalaryDate`, `Amount`, `Employees_EmployeeID`) VALUES (50, '2023-02-20', 30000.00, 50);
COMMIT;
-- -----------------------------------------------------
-- Data for table `mydb`.`WorkSchedules`
-- -----------------------------------------------------
START TRANSACTION;
USE `mydb`;
INSERT INTO `mydb`.`WorkSchedules` (`ScheduleID`, `WorkDate`, `StartTime`, `EndTime`, `Employees_EmployeeID`) VALUES (1, '2023-01-01 00:00:00', '08:00:00', '17:00:00', 1);
INSERT INTO `mydb`.`WorkSchedules` (`ScheduleID`, `WorkDate`, `StartTime`, `EndTime`, `Employees_EmployeeID`) VALUES (2, '2023-01-02 00:00:00', '08:00:00', '17:00:00', 2);
INSERT INTO `mydb`.`WorkSchedules` (`ScheduleID`, `WorkDate`, `StartTime`, `EndTime`, `Employees_EmployeeID`) VALUES (3, '2023-01-03 00:00:00', '08:00:00', '17:00:00', 3);
INSERT INTO `mydb`.`WorkSchedules` (`ScheduleID`, `WorkDate`, `StartTime`, `EndTime`, `Employees_EmployeeID`) VALUES (4, '2023-01-04 00:00:00', '08:00:00', '17:00:00', 4);
INSERT INTO `mydb`.`WorkSchedules` (`ScheduleID`, `WorkDate`, `StartTime`, `EndTime`, `Employees_EmployeeID`) VALUES (5, '2023-01-05 00:00:00', '08:00:00', '17:00:00', 5);
INSERT INTO `mydb`.`WorkSchedules` (`ScheduleID`, `WorkDate`, `StartTime`, `EndTime`, `Employees_EmployeeID`) VALUES (6, '2023-01-06 00:00:00', '08:00:00', '17:00:00', 6);
INSERT INTO `mydb`.`WorkSchedules` (`ScheduleID`, `WorkDate`, `StartTime`, `EndTime`, `Employees_EmployeeID`) VALUES (7, '2023-01-07 00:00:00', '08:00:00', '17:00:00', 7);
INSERT INTO `mydb`.`WorkSchedules` (`ScheduleID`, `WorkDate`, `StartTime`, `EndTime`, `Employees_EmployeeID`) VALUES (8, '2023-01-08 00:00:00', '08:00:00', '17:00:00', 8);
INSERT INTO `mydb`.`WorkSchedules` (`ScheduleID`, `WorkDate`, `StartTime`, `EndTime`, `Employees_EmployeeID`) VALUES (9, '2023-01-09 00:00:00', '08:00:00', '17:00:00', 9);
INSERT INTO `mydb`.`WorkSchedules` (`ScheduleID`, `WorkDate`, `StartTime`, `EndTime`, `Employees_EmployeeID`) VALUES (10, '2023-01-10 00:00:00', '08:00:00', '17:00:00', 10);
INSERT INTO `mydb`.`WorkSchedules` (`ScheduleID`, `WorkDate`, `StartTime`, `EndTime`, `Employees_EmployeeID`) VALUES (11, '2023-01-11 00:00:00', '08:00:00', '17:00:00', 11);
INSERT INTO `mydb`.`WorkSchedules` (`ScheduleID`, `WorkDate`, `StartTime`, `EndTime`, `Employees_EmployeeID`) VALUES (12, '2023-01-12 00:00:00', '08:00:00', '17:00:00', 12);
INSERT INTO `mydb`.`WorkSchedules` (`ScheduleID`, `WorkDate`, `StartTime`, `EndTime`, `Employees_EmployeeID`) VALUES (13, '2023-01-13 00:00:00', '08:00:00', '17:00:00', 13);
INSERT INTO `mydb`.`WorkSchedules` (`ScheduleID`, `WorkDate`, `StartTime`, `EndTime`, `Employees_EmployeeID`) VALUES (14, '2023-01-14 00:00:00', '08:00:00', '17:00:00', 14);
INSERT INTO `mydb`.`WorkSchedules` (`ScheduleID`, `WorkDate`, `StartTime`, `EndTime`, `Employees_EmployeeID`) VALUES (15, '2023-01-15 00:00:00', '08:00:00', '17:00:00', 15);
INSERT INTO `mydb`.`WorkSchedules` (`ScheduleID`, `WorkDate`, `StartTime`, `EndTime`, `Employees_EmployeeID`) VALUES (16, '2023-01-16 00:00:00', '08:00:00', '17:00:00', 16);
INSERT INTO `mydb`.`WorkSchedules` (`ScheduleID`, `WorkDate`, `StartTime`, `EndTime`, `Employees_EmployeeID`) VALUES (17, '2023-01-17 00:00:00', '08:00:00', '17:00:00', 17);
INSERT INTO `mydb`.`WorkSchedules` (`ScheduleID`, `WorkDate`, `StartTime`, `EndTime`, `Employees_EmployeeID`) VALUES (18, '2023-01-18 00:00:00', '08:00:00', '17:00:00', 18);
INSERT INTO `mydb`.`WorkSchedules` (`ScheduleID`, `WorkDate`, `StartTime`, `EndTime`, `Employees_EmployeeID`) VALUES (19, '2023-01-19 00:00:00', '08:00:00', '17:00:00', 19);
INSERT INTO `mydb`.`WorkSchedules` (`ScheduleID`, `WorkDate`, `StartTime`, `EndTime`, `Employees_EmployeeID`) VALUES (20, '2023-01-20 00:00:00', '08:00:00', '17:00:00', 20);
INSERT INTO `mydb`.`WorkSchedules` (`ScheduleID`, `WorkDate`, `StartTime`, `EndTime`, `Employees_EmployeeID`) VALUES (21, '2023-01-21 00:00:00', '08:00:00', '17:00:00', 21);
INSERT INTO `mydb`.`WorkSchedules` (`ScheduleID`, `WorkDate`, `StartTime`, `EndTime`, `Employees_EmployeeID`) VALUES (22, '2023-01-22 00:00:00', '08:00:00', '17:00:00', 22);
INSERT INTO `mydb`.`WorkSchedules` (`ScheduleID`, `WorkDate`, `StartTime`, `EndTime`, `Employees_EmployeeID`) VALUES (23, '2023-01-23 00:00:00', '08:00:00', '17:00:00', 23);
INSERT INTO `mydb`.`WorkSchedules` (`ScheduleID`, `WorkDate`, `StartTime`, `EndTime`, `Employees_EmployeeID`) VALUES (24, '2023-01-24 00:00:00', '08:00:00', '17:00:00', 24);
INSERT INTO `mydb`.`WorkSchedules` (`ScheduleID`, `WorkDate`, `StartTime`, `EndTime`, `Employees_EmployeeID`) VALUES (25, '2023-01-25 00:00:00', '08:00:00', '17:00:00', 25);
INSERT INTO `mydb`.`WorkSchedules` (`ScheduleID`, `WorkDate`, `StartTime`, `EndTime`, `Employees_EmployeeID`) VALUES (26, '2023-01-26 00:00:00', '08:00:00', '17:00:00', 26);
INSERT INTO `mydb`.`WorkSchedules` (`ScheduleID`, `WorkDate`, `StartTime`, `EndTime`, `Employees_EmployeeID`) VALUES (27, '2023-01-27 00:00:00', '08:00:00', '17:00:00', 27);
INSERT INTO `mydb`.`WorkSchedules` (`ScheduleID`, `WorkDate`, `StartTime`, `EndTime`, `Employees_EmployeeID`) VALUES (28, '2023-01-28 00:00:00', '08:00:00', '17:00:00', 28);
INSERT INTO `mydb`.`WorkSchedules` (`ScheduleID`, `WorkDate`, `StartTime`, `EndTime`, `Employees_EmployeeID`) VALUES (29, '2023-01-29 00:00:00', '08:00:00', '17:00:00', 29);
INSERT INTO `mydb`.`WorkSchedules` (`ScheduleID`, `WorkDate`, `StartTime`, `EndTime`, `Employees_EmployeeID`) VALUES (30, '2023-01-30 00:00:00', '08:00:00', '17:00:00', 30);
INSERT INTO `mydb`.`WorkSchedules` (`ScheduleID`, `WorkDate`, `StartTime`, `EndTime`, `Employees_EmployeeID`) VALUES (31, '2023-02-01 00:00:00', '08:00:00', '17:00:00', 31);
INSERT INTO `mydb`.`WorkSchedules` (`ScheduleID`, `WorkDate`, `StartTime`, `EndTime`, `Employees_EmployeeID`) VALUES (32, '2023-02-02 00:00:00', '08:00:00', '17:00:00', 32);
INSERT INTO `mydb`.`WorkSchedules` (`ScheduleID`, `WorkDate`, `StartTime`, `EndTime`, `Employees_EmployeeID`) VALUES (33, '2023-02-03 00:00:00', '08:00:00', '17:00:00', 33);
INSERT INTO `mydb`.`WorkSchedules` (`ScheduleID`, `WorkDate`, `StartTime`, `EndTime`, `Employees_EmployeeID`) VALUES (34, '2023-02-04 00:00:00', '08:00:00', '17:00:00', 34);
INSERT INTO `mydb`.`WorkSchedules` (`ScheduleID`, `WorkDate`, `StartTime`, `EndTime`, `Employees_EmployeeID`) VALUES (35, '2023-02-05 00:00:00', '08:00:00', '17:00:00', 35);
INSERT INTO `mydb`.`WorkSchedules` (`ScheduleID`, `WorkDate`, `StartTime`, `EndTime`, `Employees_EmployeeID`) VALUES (36, '2023-02-06 00:00:00', '08:00:00', '17:00:00', 36);
INSERT INTO `mydb`.`WorkSchedules` (`ScheduleID`, `WorkDate`, `StartTime`, `EndTime`, `Employees_EmployeeID`) VALUES (37, '2023-02-07 00:00:00', '08:00:00', '17:00:00', 37);
INSERT INTO `mydb`.`WorkSchedules` (`ScheduleID`, `WorkDate`, `StartTime`, `EndTime`, `Employees_EmployeeID`) VALUES (38, '2023-02-08 00:00:00', '08:00:00', '17:00:00', 38);
INSERT INTO `mydb`.`WorkSchedules` (`ScheduleID`, `WorkDate`, `StartTime`, `EndTime`, `Employees_EmployeeID`) VALUES (39, '2023-02-09 00:00:00', '08:00:00', '17:00:00', 39);
INSERT INTO `mydb`.`WorkSchedules` (`ScheduleID`, `WorkDate`, `StartTime`, `EndTime`, `Employees_EmployeeID`) VALUES (40, '2023-02-10 00:00:00', '08:00:00', '17:00:00', 40);
INSERT INTO `mydb`.`WorkSchedules` (`ScheduleID`, `WorkDate`, `StartTime`, `EndTime`, `Employees_EmployeeID`) VALUES (41, '2023-02-11 00:00:00', '08:00:00', '17:00:00', 41);
INSERT INTO `mydb`.`WorkSchedules` (`ScheduleID`, `WorkDate`, `StartTime`, `EndTime`, `Employees_EmployeeID`) VALUES (42, '2023-02-12 00:00:00', '08:00:00', '17:00:00', 42);
INSERT INTO `mydb`.`WorkSchedules` (`ScheduleID`, `WorkDate`, `StartTime`, `EndTime`, `Employees_EmployeeID`) VALUES (43, '2023-02-13 00:00:00', '08:00:00', '17:00:00', 43);
INSERT INTO `mydb`.`WorkSchedules` (`ScheduleID`, `WorkDate`, `StartTime`, `EndTime`, `Employees_EmployeeID`) VALUES (44, '2023-02-14 00:00:00', '08:00:00', '17:00:00', 44);
INSERT INTO `mydb`.`WorkSchedules` (`ScheduleID`, `WorkDate`, `StartTime`, `EndTime`, `Employees_EmployeeID`) VALUES (45, '2023-02-15 00:00:00', '08:00:00', '17:00:00', 45);
INSERT INTO `mydb`.`WorkSchedules` (`ScheduleID`, `WorkDate`, `StartTime`, `EndTime`, `Employees_EmployeeID`) VALUES (46, '2023-02-16 00:00:00', '08:00:00', '17:00:00', 46);
INSERT INTO `mydb`.`WorkSchedules` (`ScheduleID`, `WorkDate`, `StartTime`, `EndTime`, `Employees_EmployeeID`) VALUES (47, '2023-02-17 00:00:00', '08:00:00', '17:00:00', 47);
INSERT INTO `mydb`.`WorkSchedules` (`ScheduleID`, `WorkDate`, `StartTime`, `EndTime`, `Employees_EmployeeID`) VALUES (48, '2023-02-18 00:00:00', '08:00:00', '17:00:00', 48);
INSERT INTO `mydb`.`WorkSchedules` (`ScheduleID`, `WorkDate`, `StartTime`, `EndTime`, `Employees_EmployeeID`) VALUES (49, '2023-02-19 00:00:00', '08:00:00', '17:00:00', 49);
INSERT INTO `mydb`.`WorkSchedules` (`ScheduleID`, `WorkDate`, `StartTime`, `EndTime`, `Employees_EmployeeID`) VALUES (50, '2023-02-20 00:00:00', '08:00:00', '17:00:00', 50);
COMMIT;
-- -----------------------------------------------------
-- Data for table `mydb`.`Reports`
-- -----------------------------------------------------
START TRANSACTION;
USE `mydb`;
INSERT INTO `mydb`.`Reports` (`ReportID`, `ReportName`, `CreationDate`, `ReportType`) VALUES (1, 'Sales Report', '2023-01-01 00:00:00', 'Sales');
INSERT INTO `mydb`.`Reports` (`ReportID`, `ReportName`, `CreationDate`, `ReportType`) VALUES (2, 'Production Report', '2023-01-02 00:00:00', 'Production');
INSERT INTO `mydb`.`Reports` (`ReportID`, `ReportName`, `CreationDate`, `ReportType`) VALUES (3, 'Inventory Report', '2023-01-03 00:00:00', 'Inventory');
INSERT INTO `mydb`.`Reports` (`ReportID`, `ReportName`, `CreationDate`, `ReportType`) VALUES (4, 'Financial Report', '2023-01-04 00:00:00', 'Finance');
INSERT INTO `mydb`.`Reports` (`ReportID`, `ReportName`, `CreationDate`, `ReportType`) VALUES (5, 'Employee Performance Report', '2023-01-05 00:00:00', 'HR');
COMMIT;
-- -----------------------------------------------------
-- Data for table `mydb`.`ReportData`
-- -----------------------------------------------------
START TRANSACTION;
USE `mydb`;
INSERT INTO `mydb`.`ReportData` (`ReportDataID`, `Metric`, `Value`, `Reports_ReportID`) VALUES (1, 'Total Sales', 10000.00, 1);
INSERT INTO `mydb`.`ReportData` (`ReportDataID`, `Metric`, `Value`, `Reports_ReportID`) VALUES (2, 'Average Order Value', 500.00, 1);
INSERT INTO `mydb`.`ReportData` (`ReportDataID`, `Metric`, `Value`, `Reports_ReportID`) VALUES (3, 'Total Production Time', 100.00, 2);
INSERT INTO `mydb`.`ReportData` (`ReportDataID`, `Metric`, `Value`, `Reports_ReportID`) VALUES (4, 'Units Produced', 500, 2);
INSERT INTO `mydb`.`ReportData` (`ReportDataID`, `Metric`, `Value`, `Reports_ReportID`) VALUES (5, 'Current Inventory', 1000, 3);
INSERT INTO `mydb`.`ReportData` (`ReportDataID`, `Metric`, `Value`, `Reports_ReportID`) VALUES (6, 'Total Expenses', 5000.00, 4);
INSERT INTO `mydb`.`ReportData` (`ReportDataID`, `Metric`, `Value`, `Reports_ReportID`) VALUES (7, 'Revenue', 15000.00, 4);
INSERT INTO `mydb`.`ReportData` (`ReportDataID`, `Metric`, `Value`, `Reports_ReportID`) VALUES (8, 'Average Employee Rating', 4.5, 5);
INSERT INTO `mydb`.`ReportData` (`ReportDataID`, `Metric`, `Value`, `Reports_ReportID`) VALUES (9, 'Total Hours Worked', 400.00, 5);
COMMIT;
-- -----------------------------------------------------
-- Data for table `mydb`.`KPIs`
-- -----------------------------------------------------
START TRANSACTION;
USE `mydb`;
INSERT INTO `mydb`.`KPIs` (`KpiID`, `KPIName`, `TargetValue`, `ActualValue`) VALUES (1, 'Production Efficiency', 95.00, 92.50);
INSERT INTO `mydb`.`KPIs` (`KpiID`, `KPIName`, `TargetValue`, `ActualValue`) VALUES (2, 'Order Fulfillment Rate', 98.00, 97.00);
INSERT INTO `mydb`.`KPIs` (`KpiID`, `KPIName`, `TargetValue`, `ActualValue`) VALUES (3, 'Average Lead Time', 5.00, 4.80);
INSERT INTO `mydb`.`KPIs` (`KpiID`, `KPIName`, `TargetValue`, `ActualValue`) VALUES (4, 'On-Time Delivery', 99.00, 98.50);
INSERT INTO `mydb`.`KPIs` (`KpiID`, `KPIName`, `TargetValue`, `ActualValue`) VALUES (5, 'Inventory Turnover', 4.00, 3.80);
COMMIT;
-- -----------------------------------------------------
-- Data for table `mydb`.`SalesAnalytics`
-- -----------------------------------------------------
START TRANSACTION;
USE `mydb`;
INSERT INTO `mydb`.`SalesAnalytics` (`SaleAnalyticsID`, `SaleDate`, `Quantity`, `Revenue`, `Products_ProductID`) VALUES (1, '2023-01-01 00:00:00', 2, 400.00, 201);
INSERT INTO `mydb`.`SalesAnalytics` (`SaleAnalyticsID`, `SaleDate`, `Quantity`, `Revenue`, `Products_ProductID`) VALUES (2, '2023-01-02 00:00:00', 3, 600.00, 202);
INSERT INTO `mydb`.`SalesAnalytics` (`SaleAnalyticsID`, `SaleDate`, `Quantity`, `Revenue`, `Products_ProductID`) VALUES (3, '2023-01-03 00:00:00', 4, 800.00, 203);
INSERT INTO `mydb`.`SalesAnalytics` (`SaleAnalyticsID`, `SaleDate`, `Quantity`, `Revenue`, `Products_ProductID`) VALUES (4, '2023-01-04 00:00:00', 5, 1000.00, 204);
INSERT INTO `mydb`.`SalesAnalytics` (`SaleAnalyticsID`, `SaleDate`, `Quantity`, `Revenue`, `Products_ProductID`) VALUES (5, '2023-01-05 00:00:00', 6, 1200.00, 205);
INSERT INTO `mydb`.`SalesAnalytics` (`SaleAnalyticsID`, `SaleDate`, `Quantity`, `Revenue`, `Products_ProductID`) VALUES (6, '2023-01-06 00:00:00', 7, 1400.00, 206);
INSERT INTO `mydb`.`SalesAnalytics` (`SaleAnalyticsID`, `SaleDate`, `Quantity`, `Revenue`, `Products_ProductID`) VALUES (7, '2023-01-07 00:00:00', 8, 1600.00, 207);
INSERT INTO `mydb`.`SalesAnalytics` (`SaleAnalyticsID`, `SaleDate`, `Quantity`, `Revenue`, `Products_ProductID`) VALUES (8, '2023-01-08 00:00:00', 9, 1800.00, 208);
INSERT INTO `mydb`.`SalesAnalytics` (`SaleAnalyticsID`, `SaleDate`, `Quantity`, `Revenue`, `Products_ProductID`) VALUES (9, '2023-01-09 00:00:00', 10, 2000.00, 209);
INSERT INTO `mydb`.`SalesAnalytics` (`SaleAnalyticsID`, `SaleDate`, `Quantity`, `Revenue`, `Products_ProductID`) VALUES (10, '2023-01-10 00:00:00', 11, 2200.00, 210);
INSERT INTO `mydb`.`SalesAnalytics` (`SaleAnalyticsID`, `SaleDate`, `Quantity`, `Revenue`, `Products_ProductID`) VALUES (11, '2023-01-11 00:00:00', 12, 2400.00, 211);
INSERT INTO `mydb`.`SalesAnalytics` (`SaleAnalyticsID`, `SaleDate`, `Quantity`, `Revenue`, `Products_ProductID`) VALUES (12, '2023-01-12 00:00:00', 13, 2600.00, 212);
INSERT INTO `mydb`.`SalesAnalytics` (`SaleAnalyticsID`, `SaleDate`, `Quantity`, `Revenue`, `Products_ProductID`) VALUES (13, '2023-01-13 00:00:00', 14, 2800.00, 213);
INSERT INTO `mydb`.`SalesAnalytics` (`SaleAnalyticsID`, `SaleDate`, `Quantity`, `Revenue`, `Products_ProductID`) VALUES (14, '2023-01-14 00:00:00', 15, 3000.00, 214);
INSERT INTO `mydb`.`SalesAnalytics` (`SaleAnalyticsID`, `SaleDate`, `Quantity`, `Revenue`, `Products_ProductID`) VALUES (15, '2023-01-15 00:00:00', 16, 3200.00, 215);
INSERT INTO `mydb`.`SalesAnalytics` (`SaleAnalyticsID`, `SaleDate`, `Quantity`, `Revenue`, `Products_ProductID`) VALUES (16, '2023-01-16 00:00:00', 17, 3400.00, 216);
INSERT INTO `mydb`.`SalesAnalytics` (`SaleAnalyticsID`, `SaleDate`, `Quantity`, `Revenue`, `Products_ProductID`) VALUES (17, '2023-01-17 00:00:00', 18, 3600.00, 217);
INSERT INTO `mydb`.`SalesAnalytics` (`SaleAnalyticsID`, `SaleDate`, `Quantity`, `Revenue`, `Products_ProductID`) VALUES (18, '2023-01-18 00:00:00', 19, 3800.00, 218);
INSERT INTO `mydb`.`SalesAnalytics` (`SaleAnalyticsID`, `SaleDate`, `Quantity`, `Revenue`, `Products_ProductID`) VALUES (19, '2023-01-19 00:00:00', 20, 4000.00, 219);
INSERT INTO `mydb`.`SalesAnalytics` (`SaleAnalyticsID`, `SaleDate`, `Quantity`, `Revenue`, `Products_ProductID`) VALUES (20, '2023-01-20 00:00:00', 21, 4200.00, 220);
INSERT INTO `mydb`.`SalesAnalytics` (`SaleAnalyticsID`, `SaleDate`, `Quantity`, `Revenue`, `Products_ProductID`) VALUES (21, '2023-01-21 00:00:00', 22, 4400.00, 221);
INSERT INTO `mydb`.`SalesAnalytics` (`SaleAnalyticsID`, `SaleDate`, `Quantity`, `Revenue`, `Products_ProductID`) VALUES (22, '2023-01-22 00:00:00', 23, 4600.00, 222);
INSERT INTO `mydb`.`SalesAnalytics` (`SaleAnalyticsID`, `SaleDate`, `Quantity`, `Revenue`, `Products_ProductID`) VALUES (23, '2023-01-23 00:00:00', 24, 4800.00, 223);
INSERT INTO `mydb`.`SalesAnalytics` (`SaleAnalyticsID`, `SaleDate`, `Quantity`, `Revenue`, `Products_ProductID`) VALUES (24, '2023-01-24 00:00:00', 25, 5000.00, 224);
INSERT INTO `mydb`.`SalesAnalytics` (`SaleAnalyticsID`, `SaleDate`, `Quantity`, `Revenue`, `Products_ProductID`) VALUES (25, '2023-01-25 00:00:00', 26, 5200.00, 225);
INSERT INTO `mydb`.`SalesAnalytics` (`SaleAnalyticsID`, `SaleDate`, `Quantity`, `Revenue`, `Products_ProductID`) VALUES (26, '2023-01-26 00:00:00', 27, 5400.00, 226);
INSERT INTO `mydb`.`SalesAnalytics` (`SaleAnalyticsID`, `SaleDate`, `Quantity`, `Revenue`, `Products_ProductID`) VALUES (27, '2023-01-27 00:00:00', 28, 5600.00, 227);
INSERT INTO `mydb`.`SalesAnalytics` (`SaleAnalyticsID`, `SaleDate`, `Quantity`, `Revenue`, `Products_ProductID`) VALUES (28, '2023-01-28 00:00:00', 29, 5800.00, 228);
INSERT INTO `mydb`.`SalesAnalytics` (`SaleAnalyticsID`, `SaleDate`, `Quantity`, `Revenue`, `Products_ProductID`) VALUES (29, '2023-01-29 00:00:00', 30, 6000.00, 229);
INSERT INTO `mydb`.`SalesAnalytics` (`SaleAnalyticsID`, `SaleDate`, `Quantity`, `Revenue`, `Products_ProductID`) VALUES (30, '2023-01-30 00:00:00', 31, 6200.00, 230);
INSERT INTO `mydb`.`SalesAnalytics` (`SaleAnalyticsID`, `SaleDate`, `Quantity`, `Revenue`, `Products_ProductID`) VALUES (31, '2023-01-31 00:00:00', 32, 6400.00, 231);
INSERT INTO `mydb`.`SalesAnalytics` (`SaleAnalyticsID`, `SaleDate`, `Quantity`, `Revenue`, `Products_ProductID`) VALUES (32, '2023-02-01 00:00:00', 33, 6600.00, 232);
INSERT INTO `mydb`.`SalesAnalytics` (`SaleAnalyticsID`, `SaleDate`, `Quantity`, `Revenue`, `Products_ProductID`) VALUES (33, '2023-02-02 00:00:00', 34, 6800.00, 233);
INSERT INTO `mydb`.`SalesAnalytics` (`SaleAnalyticsID`, `SaleDate`, `Quantity`, `Revenue`, `Products_ProductID`) VALUES (34, '2023-02-03 00:00:00', 35, 7000.00, 234);
INSERT INTO `mydb`.`SalesAnalytics` (`SaleAnalyticsID`, `SaleDate`, `Quantity`, `Revenue`, `Products_ProductID`) VALUES (35, '2023-02-04 00:00:00', 36, 7200.00, 235);
INSERT INTO `mydb`.`SalesAnalytics` (`SaleAnalyticsID`, `SaleDate`, `Quantity`, `Revenue`, `Products_ProductID`) VALUES (36, '2023-02-05 00:00:00', 37, 7400.00, 236);
INSERT INTO `mydb`.`SalesAnalytics` (`SaleAnalyticsID`, `SaleDate`, `Quantity`, `Revenue`, `Products_ProductID`) VALUES (37, '2023-02-06 00:00:00', 38, 7600.00, 237);
INSERT INTO `mydb`.`SalesAnalytics` (`SaleAnalyticsID`, `SaleDate`, `Quantity`, `Revenue`, `Products_ProductID`) VALUES (38, '2023-02-07 00:00:00', 39, 7800.00, 238);
INSERT INTO `mydb`.`SalesAnalytics` (`SaleAnalyticsID`, `SaleDate`, `Quantity`, `Revenue`, `Products_ProductID`) VALUES (39, '2023-02-08 00:00:00', 40, 8000.00, 239);
INSERT INTO `mydb`.`SalesAnalytics` (`SaleAnalyticsID`, `SaleDate`, `Quantity`, `Revenue`, `Products_ProductID`) VALUES (40, '2023-02-09 00:00:00', 41, 8200.00, 240);
INSERT INTO `mydb`.`SalesAnalytics` (`SaleAnalyticsID`, `SaleDate`, `Quantity`, `Revenue`, `Products_ProductID`) VALUES (41, '2023-02-10 00:00:00', 42, 8400.00, 241);
INSERT INTO `mydb`.`SalesAnalytics` (`SaleAnalyticsID`, `SaleDate`, `Quantity`, `Revenue`, `Products_ProductID`) VALUES (42, '2023-02-11 00:00:00', 43, 8600.00, 242);
INSERT INTO `mydb`.`SalesAnalytics` (`SaleAnalyticsID`, `SaleDate`, `Quantity`, `Revenue`, `Products_ProductID`) VALUES (43, '2023-02-12 00:00:00', 44, 8800.00, 243);
INSERT INTO `mydb`.`SalesAnalytics` (`SaleAnalyticsID`, `SaleDate`, `Quantity`, `Revenue`, `Products_ProductID`) VALUES (44, '2023-02-13 00:00:00', 45, 9000.00, 244);
INSERT INTO `mydb`.`SalesAnalytics` (`SaleAnalyticsID`, `SaleDate`, `Quantity`, `Revenue`, `Products_ProductID`) VALUES (45, '2023-02-14 00:00:00', 46, 9200.00, 245);
INSERT INTO `mydb`.`SalesAnalytics` (`SaleAnalyticsID`, `SaleDate`, `Quantity`, `Revenue`, `Products_ProductID`) VALUES (46, '2023-02-15 00:00:00', 47, 9400.00, 246);
INSERT INTO `mydb`.`SalesAnalytics` (`SaleAnalyticsID`, `SaleDate`, `Quantity`, `Revenue`, `Products_ProductID`) VALUES (47, '2023-02-16 00:00:00', 48, 9600.00, 247);
INSERT INTO `mydb`.`SalesAnalytics` (`SaleAnalyticsID`, `SaleDate`, `Quantity`, `Revenue`, `Products_ProductID`) VALUES (48, '2023-02-17 00:00:00', 49, 9800.00, 248);
INSERT INTO `mydb`.`SalesAnalytics` (`SaleAnalyticsID`, `SaleDate`, `Quantity`, `Revenue`, `Products_ProductID`) VALUES (49, '2023-02-18 00:00:00', 50, 10000.00, 249);
INSERT INTO `mydb`.`SalesAnalytics` (`SaleAnalyticsID`, `SaleDate`, `Quantity`, `Revenue`, `Products_ProductID`) VALUES (50, '2023-02-19 00:00:00', 51, 10200.00, 250);
COMMIT;
-- -----------------------------------------------------
-- Data for table `mydb`.`ProductionAnalytics`
-- -----------------------------------------------------
START TRANSACTION;
USE `mydb`;
INSERT INTO `mydb`.`ProductionAnalytics` (`ProdAnalyticsID`, `ProductionDate`, `Quantity`, `Costs`, `Products_ProductID`) VALUES (1, '2023-01-01 00:00:00', 10, 500.00, 201);
INSERT INTO `mydb`.`ProductionAnalytics` (`ProdAnalyticsID`, `ProductionDate`, `Quantity`, `Costs`, `Products_ProductID`) VALUES (2, '2023-01-02 00:00:00', 15, 750.00, 202);
INSERT INTO `mydb`.`ProductionAnalytics` (`ProdAnalyticsID`, `ProductionDate`, `Quantity`, `Costs`, `Products_ProductID`) VALUES (3, '2023-01-03 00:00:00', 20, 1000.00, 203);
INSERT INTO `mydb`.`ProductionAnalytics` (`ProdAnalyticsID`, `ProductionDate`, `Quantity`, `Costs`, `Products_ProductID`) VALUES (4, '2023-01-04 00:00:00', 12, 600.00, 204);
INSERT INTO `mydb`.`ProductionAnalytics` (`ProdAnalyticsID`, `ProductionDate`, `Quantity`, `Costs`, `Products_ProductID`) VALUES (5, '2023-01-05 00:00:00', 8, 400.00, 205);
INSERT INTO `mydb`.`ProductionAnalytics` (`ProdAnalyticsID`, `ProductionDate`, `Quantity`, `Costs`, `Products_ProductID`) VALUES (6, '2023-01-06 00:00:00', 11, 550.00, 206);
INSERT INTO `mydb`.`ProductionAnalytics` (`ProdAnalyticsID`, `ProductionDate`, `Quantity`, `Costs`, `Products_ProductID`) VALUES (7, '2023-01-07 00:00:00', 9, 450.00, 207);
INSERT INTO `mydb`.`ProductionAnalytics` (`ProdAnalyticsID`, `ProductionDate`, `Quantity`, `Costs`, `Products_ProductID`) VALUES (8, '2023-01-08 00:00:00', 13, 650.00, 208);
INSERT INTO `mydb`.`ProductionAnalytics` (`ProdAnalyticsID`, `ProductionDate`, `Quantity`, `Costs`, `Products_ProductID`) VALUES (9, '2023-01-09 00:00:00', 14, 700.00, 209);
INSERT INTO `mydb`.`ProductionAnalytics` (`ProdAnalyticsID`, `ProductionDate`, `Quantity`, `Costs`, `Products_ProductID`) VALUES (10, '2023-01-10 00:00:00', 16, 800.00, 210);
INSERT INTO `mydb`.`ProductionAnalytics` (`ProdAnalyticsID`, `ProductionDate`, `Quantity`, `Costs`, `Products_ProductID`) VALUES (11, '2023-01-11 00:00:00', 17, 850.00, 211);
INSERT INTO `mydb`.`ProductionAnalytics` (`ProdAnalyticsID`, `ProductionDate`, `Quantity`, `Costs`, `Products_ProductID`) VALUES (12, '2023-01-12 00:00:00', 18, 900.00, 212);
INSERT INTO `mydb`.`ProductionAnalytics` (`ProdAnalyticsID`, `ProductionDate`, `Quantity`, `Costs`, `Products_ProductID`) VALUES (13, '2023-01-13 00:00:00', 19, 950.00, 213);
INSERT INTO `mydb`.`ProductionAnalytics` (`ProdAnalyticsID`, `ProductionDate`, `Quantity`, `Costs`, `Products_ProductID`) VALUES (14, '2023-01-14 00:00:00', 20, 1000.00, 214);
INSERT INTO `mydb`.`ProductionAnalytics` (`ProdAnalyticsID`, `ProductionDate`, `Quantity`, `Costs`, `Products_ProductID`) VALUES (15, '2023-01-15 00:00:00', 21, 1050.00, 215);
INSERT INTO `mydb`.`ProductionAnalytics` (`ProdAnalyticsID`, `ProductionDate`, `Quantity`, `Costs`, `Products_ProductID`) VALUES (16, '2023-01-16 00:00:00', 22, 1100.00, 216);
INSERT INTO `mydb`.`ProductionAnalytics` (`ProdAnalyticsID`, `ProductionDate`, `Quantity`, `Costs`, `Products_ProductID`) VALUES (17, '2023-01-17 00:00:00', 23, 1150.00, 217);
INSERT INTO `mydb`.`ProductionAnalytics` (`ProdAnalyticsID`, `ProductionDate`, `Quantity`, `Costs`, `Products_ProductID`) VALUES (18, '2023-01-18 00:00:00', 24, 1200.00, 218);
INSERT INTO `mydb`.`ProductionAnalytics` (`ProdAnalyticsID`, `ProductionDate`, `Quantity`, `Costs`, `Products_ProductID`) VALUES (19, '2023-01-19 00:00:00', 25, 1250.00, 219);
INSERT INTO `mydb`.`ProductionAnalytics` (`ProdAnalyticsID`, `ProductionDate`, `Quantity`, `Costs`, `Products_ProductID`) VALUES (20, '2023-01-20 00:00:00', 26, 1300.00, 220);
INSERT INTO `mydb`.`ProductionAnalytics` (`ProdAnalyticsID`, `ProductionDate`, `Quantity`, `Costs`, `Products_ProductID`) VALUES (21, '2023-01-21 00:00:00', 27, 1350.00, 221);
INSERT INTO `mydb`.`ProductionAnalytics` (`ProdAnalyticsID`, `ProductionDate`, `Quantity`, `Costs`, `Products_ProductID`) VALUES (22, '2023-01-22 00:00:00', 28, 1400.00, 222);
INSERT INTO `mydb`.`ProductionAnalytics` (`ProdAnalyticsID`, `ProductionDate`, `Quantity`, `Costs`, `Products_ProductID`) VALUES (23, '2023-01-23 00:00:00', 29, 1450.00, 223);
INSERT INTO `mydb`.`ProductionAnalytics` (`ProdAnalyticsID`, `ProductionDate`, `Quantity`, `Costs`, `Products_ProductID`) VALUES (24, '2023-01-24 00:00:00', 30, 1500.00, 224);
INSERT INTO `mydb`.`ProductionAnalytics` (`ProdAnalyticsID`, `ProductionDate`, `Quantity`, `Costs`, `Products_ProductID`) VALUES (25, '2023-01-25 00:00:00', 31, 1550.00, 225);
INSERT INTO `mydb`.`ProductionAnalytics` (`ProdAnalyticsID`, `ProductionDate`, `Quantity`, `Costs`, `Products_ProductID`) VALUES (26, '2023-01-26 00:00:00', 32, 1600.00, 226);
INSERT INTO `mydb`.`ProductionAnalytics` (`ProdAnalyticsID`, `ProductionDate`, `Quantity`, `Costs`, `Products_ProductID`) VALUES (27, '2023-01-27 00:00:00', 33, 1650.00, 227);
INSERT INTO `mydb`.`ProductionAnalytics` (`ProdAnalyticsID`, `ProductionDate`, `Quantity`, `Costs`, `Products_ProductID`) VALUES (28, '2023-01-28 00:00:00', 34, 1700.00, 228);
INSERT INTO `mydb`.`ProductionAnalytics` (`ProdAnalyticsID`, `ProductionDate`, `Quantity`, `Costs`, `Products_ProductID`) VALUES (29, '2023-01-29 00:00:00', 35, 1750.00, 229);
INSERT INTO `mydb`.`ProductionAnalytics` (`ProdAnalyticsID`, `ProductionDate`, `Quantity`, `Costs`, `Products_ProductID`) VALUES (30, '2023-01-30 00:00:00', 36, 1800.00, 230);
INSERT INTO `mydb`.`ProductionAnalytics` (`ProdAnalyticsID`, `ProductionDate`, `Quantity`, `Costs`, `Products_ProductID`) VALUES (31, '2023-01-31 00:00:00', 37, 1850.00, 231);
INSERT INTO `mydb`.`ProductionAnalytics` (`ProdAnalyticsID`, `ProductionDate`, `Quantity`, `Costs`, `Products_ProductID`) VALUES (32, '2023-02-01 00:00:00', 38, 1900.00, 232);
INSERT INTO `mydb`.`ProductionAnalytics` (`ProdAnalyticsID`, `ProductionDate`, `Quantity`, `Costs`, `Products_ProductID`) VALUES (33, '2023-02-02 00:00:00', 39, 1950.00, 233);
INSERT INTO `mydb`.`ProductionAnalytics` (`ProdAnalyticsID`, `ProductionDate`, `Quantity`, `Costs`, `Products_ProductID`) VALUES (34, '2023-02-03 00:00:00', 40, 2000.00, 234);
INSERT INTO `mydb`.`ProductionAnalytics` (`ProdAnalyticsID`, `ProductionDate`, `Quantity`, `Costs`, `Products_ProductID`) VALUES (35, '2023-02-04 00:00:00', 41, 2050.00, 235);
INSERT INTO `mydb`.`ProductionAnalytics` (`ProdAnalyticsID`, `ProductionDate`, `Quantity`, `Costs`, `Products_ProductID`) VALUES (36, '2023-02-05 00:00:00', 42, 2100.00, 236);
INSERT INTO `mydb`.`ProductionAnalytics` (`ProdAnalyticsID`, `ProductionDate`, `Quantity`, `Costs`, `Products_ProductID`) VALUES (37, '2023-02-06 00:00:00', 43, 2150.00, 237);
INSERT INTO `mydb`.`ProductionAnalytics` (`ProdAnalyticsID`, `ProductionDate`, `Quantity`, `Costs`, `Products_ProductID`) VALUES (38, '2023-02-07 00:00:00', 44, 2200.00, 238);
INSERT INTO `mydb`.`ProductionAnalytics` (`ProdAnalyticsID`, `ProductionDate`, `Quantity`, `Costs`, `Products_ProductID`) VALUES (39, '2023-02-08 00:00:00', 45, 2250.00, 239);
INSERT INTO `mydb`.`ProductionAnalytics` (`ProdAnalyticsID`, `ProductionDate`, `Quantity`, `Costs`, `Products_ProductID`) VALUES (40, '2023-02-09 00:00:00', 46, 2300.00, 240);
INSERT INTO `mydb`.`ProductionAnalytics` (`ProdAnalyticsID`, `ProductionDate`, `Quantity`, `Costs`, `Products_ProductID`) VALUES (41, '2023-02-10 00:00:00', 47, 2350.00, 241);
INSERT INTO `mydb`.`ProductionAnalytics` (`ProdAnalyticsID`, `ProductionDate`, `Quantity`, `Costs`, `Products_ProductID`) VALUES (42, '2023-02-11 00:00:00', 48, 2400.00, 242);
INSERT INTO `mydb`.`ProductionAnalytics` (`ProdAnalyticsID`, `ProductionDate`, `Quantity`, `Costs`, `Products_ProductID`) VALUES (43, '2023-02-12 00:00:00', 49, 2450.00, 243);
INSERT INTO `mydb`.`ProductionAnalytics` (`ProdAnalyticsID`, `ProductionDate`, `Quantity`, `Costs`, `Products_ProductID`) VALUES (44, '2023-02-13 00:00:00', 50, 2500.00, 244);
INSERT INTO `mydb`.`ProductionAnalytics` (`ProdAnalyticsID`, `ProductionDate`, `Quantity`, `Costs`, `Products_ProductID`) VALUES (45, '2023-02-14 00:00:00', 51, 2550.00, 245);
INSERT INTO `mydb`.`ProductionAnalytics` (`ProdAnalyticsID`, `ProductionDate`, `Quantity`, `Costs`, `Products_ProductID`) VALUES (46, '2023-02-15 00:00:00', 52, 2600.00, 246);
INSERT INTO `mydb`.`ProductionAnalytics` (`ProdAnalyticsID`, `ProductionDate`, `Quantity`, `Costs`, `Products_ProductID`) VALUES (47, '2023-02-16 00:00:00', 53, 2650.00, 247);
INSERT INTO `mydb`.`ProductionAnalytics` (`ProdAnalyticsID`, `ProductionDate`, `Quantity`, `Costs`, `Products_ProductID`) VALUES (48, '2023-02-17 00:00:00', 54, 2700.00, 248);
INSERT INTO `mydb`.`ProductionAnalytics` (`ProdAnalyticsID`, `ProductionDate`, `Quantity`, `Costs`, `Products_ProductID`) VALUES (49, '2023-02-18 00:00:00', 55, 2750.00, 249);
INSERT INTO `mydb`.`ProductionAnalytics` (`ProdAnalyticsID`, `ProductionDate`, `Quantity`, `Costs`, `Products_ProductID`) VALUES (50, '2023-02-19 00:00:00', 56, 2800.00, 250);
COMMIT;
-- -----------------------------------------------------
-- Data for table `mydb`.`InventoryAnalytics`
-- -----------------------------------------------------
START TRANSACTION;
USE `mydb`;
INSERT INTO `mydb`.`InventoryAnalytics` (`InvAnalyticsID`, `AnalysisDate`, `Quantity`, `Costs`, `Materials_MaterialID`) VALUES (1, '2023-01-01 00:00:00', 100, 5000.00, 101);
INSERT INTO `mydb`.`InventoryAnalytics` (`InvAnalyticsID`, `AnalysisDate`, `Quantity`, `Costs`, `Materials_MaterialID`) VALUES (2, '2023-01-02 00:00:00', 150, 7500.00, 102);
INSERT INTO `mydb`.`InventoryAnalytics` (`InvAnalyticsID`, `AnalysisDate`, `Quantity`, `Costs`, `Materials_MaterialID`) VALUES (3, '2023-01-03 00:00:00', 200, 10000.00, 103);
INSERT INTO `mydb`.`InventoryAnalytics` (`InvAnalyticsID`, `AnalysisDate`, `Quantity`, `Costs`, `Materials_MaterialID`) VALUES (4, '2023-01-04 00:00:00', 120, 6000.00, 104);
INSERT INTO `mydb`.`InventoryAnalytics` (`InvAnalyticsID`, `AnalysisDate`, `Quantity`, `Costs`, `Materials_MaterialID`) VALUES (5, '2023-01-05 00:00:00', 80, 4000.00, 105);
INSERT INTO `mydb`.`InventoryAnalytics` (`InvAnalyticsID`, `AnalysisDate`, `Quantity`, `Costs`, `Materials_MaterialID`) VALUES (6, '2023-01-06 00:00:00', 110, 5500.00, 106);
INSERT INTO `mydb`.`InventoryAnalytics` (`InvAnalyticsID`, `AnalysisDate`, `Quantity`, `Costs`, `Materials_MaterialID`) VALUES (7, '2023-01-07 00:00:00', 90, 4500.00, 107);
INSERT INTO `mydb`.`InventoryAnalytics` (`InvAnalyticsID`, `AnalysisDate`, `Quantity`, `Costs`, `Materials_MaterialID`) VALUES (8, '2023-01-08 00:00:00', 130, 6500.00, 108);
INSERT INTO `mydb`.`InventoryAnalytics` (`InvAnalyticsID`, `AnalysisDate`, `Quantity`, `Costs`, `Materials_MaterialID`) VALUES (9, '2023-01-09 00:00:00', 140, 7000.00, 109);
INSERT INTO `mydb`.`InventoryAnalytics` (`InvAnalyticsID`, `AnalysisDate`, `Quantity`, `Costs`, `Materials_MaterialID`) VALUES (10, '2023-01-10 00:00:00', 160, 8000.00, 110);
INSERT INTO `mydb`.`InventoryAnalytics` (`InvAnalyticsID`, `AnalysisDate`, `Quantity`, `Costs`, `Materials_MaterialID`) VALUES (11, '2023-01-11 00:00:00', 170, 8500.00, 111);
INSERT INTO `mydb`.`InventoryAnalytics` (`InvAnalyticsID`, `AnalysisDate`, `Quantity`, `Costs`, `Materials_MaterialID`) VALUES (12, '2023-01-12 00:00:00', 180, 9000.00, 112);
INSERT INTO `mydb`.`InventoryAnalytics` (`InvAnalyticsID`, `AnalysisDate`, `Quantity`, `Costs`, `Materials_MaterialID`) VALUES (13, '2023-01-13 00:00:00', 190, 9500.00, 113);
INSERT INTO `mydb`.`InventoryAnalytics` (`InvAnalyticsID`, `AnalysisDate`, `Quantity`, `Costs`, `Materials_MaterialID`) VALUES (14, '2023-01-14 00:00:00', 200, 10000.00, 114);
INSERT INTO `mydb`.`InventoryAnalytics` (`InvAnalyticsID`, `AnalysisDate`, `Quantity`, `Costs`, `Materials_MaterialID`) VALUES (15, '2023-01-15 00:00:00', 210, 10500.00, 115);
INSERT INTO `mydb`.`InventoryAnalytics` (`InvAnalyticsID`, `AnalysisDate`, `Quantity`, `Costs`, `Materials_MaterialID`) VALUES (16, '2023-01-16 00:00:00', 220, 11000.00, 116);
INSERT INTO `mydb`.`InventoryAnalytics` (`InvAnalyticsID`, `AnalysisDate`, `Quantity`, `Costs`, `Materials_MaterialID`) VALUES (17, '2023-01-17 00:00:00', 230, 11500.00, 117);
INSERT INTO `mydb`.`InventoryAnalytics` (`InvAnalyticsID`, `AnalysisDate`, `Quantity`, `Costs`, `Materials_MaterialID`) VALUES (18, '2023-01-18 00:00:00', 240, 12000.00, 118);
INSERT INTO `mydb`.`InventoryAnalytics` (`InvAnalyticsID`, `AnalysisDate`, `Quantity`, `Costs`, `Materials_MaterialID`) VALUES (19, '2023-01-19 00:00:00', 250, 12500.00, 119);
INSERT INTO `mydb`.`InventoryAnalytics` (`InvAnalyticsID`, `AnalysisDate`, `Quantity`, `Costs`, `Materials_MaterialID`) VALUES (20, '2023-01-20 00:00:00', 260, 13000.00, 120);
INSERT INTO `mydb`.`InventoryAnalytics` (`InvAnalyticsID`, `AnalysisDate`, `Quantity`, `Costs`, `Materials_MaterialID`) VALUES (21, '2023-01-21 00:00:00', 270, 13500.00, 121);
INSERT INTO `mydb`.`InventoryAnalytics` (`InvAnalyticsID`, `AnalysisDate`, `Quantity`, `Costs`, `Materials_MaterialID`) VALUES (22, '2023-01-22 00:00:00', 280, 14000.00, 122);
INSERT INTO `mydb`.`InventoryAnalytics` (`InvAnalyticsID`, `AnalysisDate`, `Quantity`, `Costs`, `Materials_MaterialID`) VALUES (23, '2023-01-23 00:00:00', 290, 14500.00, 123);
INSERT INTO `mydb`.`InventoryAnalytics` (`InvAnalyticsID`, `AnalysisDate`, `Quantity`, `Costs`, `Materials_MaterialID`) VALUES (24, '2023-01-24 00:00:00', 300, 15000.00, 124);
INSERT INTO `mydb`.`InventoryAnalytics` (`InvAnalyticsID`, `AnalysisDate`, `Quantity`, `Costs`, `Materials_MaterialID`) VALUES (25, '2023-01-25 00:00:00', 310, 15500.00, 125);
INSERT INTO `mydb`.`InventoryAnalytics` (`InvAnalyticsID`, `AnalysisDate`, `Quantity`, `Costs`, `Materials_MaterialID`) VALUES (26, '2023-01-26 00:00:00', 320, 16000.00, 126);
INSERT INTO `mydb`.`InventoryAnalytics` (`InvAnalyticsID`, `AnalysisDate`, `Quantity`, `Costs`, `Materials_MaterialID`) VALUES (27, '2023-01-27 00:00:00', 330, 16500.00, 127);
INSERT INTO `mydb`.`InventoryAnalytics` (`InvAnalyticsID`, `AnalysisDate`, `Quantity`, `Costs`, `Materials_MaterialID`) VALUES (28, '2023-01-28 00:00:00', 340, 17000.00, 128);
INSERT INTO `mydb`.`InventoryAnalytics` (`InvAnalyticsID`, `AnalysisDate`, `Quantity`, `Costs`, `Materials_MaterialID`) VALUES (29, '2023-01-29 00:00:00', 350, 17500.00, 129);
INSERT INTO `mydb`.`InventoryAnalytics` (`InvAnalyticsID`, `AnalysisDate`, `Quantity`, `Costs`, `Materials_MaterialID`) VALUES (30, '2023-01-30 00:00:00', 360, 18000.00, 130);
INSERT INTO `mydb`.`InventoryAnalytics` (`InvAnalyticsID`, `AnalysisDate`, `Quantity`, `Costs`, `Materials_MaterialID`) VALUES (31, '2023-01-31 00:00:00', 370, 18500.00, 131);
INSERT INTO `mydb`.`InventoryAnalytics` (`InvAnalyticsID`, `AnalysisDate`, `Quantity`, `Costs`, `Materials_MaterialID`) VALUES (32, '2023-02-01 00:00:00', 380, 19000.00, 132);
INSERT INTO `mydb`.`InventoryAnalytics` (`InvAnalyticsID`, `AnalysisDate`, `Quantity`, `Costs`, `Materials_MaterialID`) VALUES (33, '2023-02-02 00:00:00', 390, 19500.00, 133);
INSERT INTO `mydb`.`InventoryAnalytics` (`InvAnalyticsID`, `AnalysisDate`, `Quantity`, `Costs`, `Materials_MaterialID`) VALUES (34, '2023-02-03 00:00:00', 400, 20000.00, 134);
INSERT INTO `mydb`.`InventoryAnalytics` (`InvAnalyticsID`, `AnalysisDate`, `Quantity`, `Costs`, `Materials_MaterialID`) VALUES (35, '2023-02-04 00:00:00', 410, 20500.00, 135);
INSERT INTO `mydb`.`InventoryAnalytics` (`InvAnalyticsID`, `AnalysisDate`, `Quantity`, `Costs`, `Materials_MaterialID`) VALUES (36, '2023-02-05 00:00:00', 420, 21000.00, 136);
INSERT INTO `mydb`.`InventoryAnalytics` (`InvAnalyticsID`, `AnalysisDate`, `Quantity`, `Costs`, `Materials_MaterialID`) VALUES (37, '2023-02-06 00:00:00', 430, 21500.00, 137);
INSERT INTO `mydb`.`InventoryAnalytics` (`InvAnalyticsID`, `AnalysisDate`, `Quantity`, `Costs`, `Materials_MaterialID`) VALUES (38, '2023-02-07 00:00:00', 440, 22000.00, 138);
INSERT INTO `mydb`.`InventoryAnalytics` (`InvAnalyticsID`, `AnalysisDate`, `Quantity`, `Costs`, `Materials_MaterialID`) VALUES (39, '2023-02-08 00:00:00', 450, 22500.00, 139);
INSERT INTO `mydb`.`InventoryAnalytics` (`InvAnalyticsID`, `AnalysisDate`, `Quantity`, `Costs`, `Materials_MaterialID`) VALUES (40, '2023-02-09 00:00:00', 460, 23000.00, 140);
INSERT INTO `mydb`.`InventoryAnalytics` (`InvAnalyticsID`, `AnalysisDate`, `Quantity`, `Costs`, `Materials_MaterialID`) VALUES (41, '2023-02-10 00:00:00', 470, 23500.00, 141);
INSERT INTO `mydb`.`InventoryAnalytics` (`InvAnalyticsID`, `AnalysisDate`, `Quantity`, `Costs`, `Materials_MaterialID`) VALUES (42, '2023-02-11 00:00:00', 480, 24000.00, 142);
INSERT INTO `mydb`.`InventoryAnalytics` (`InvAnalyticsID`, `AnalysisDate`, `Quantity`, `Costs`, `Materials_MaterialID`) VALUES (43, '2023-02-12 00:00:00', 490, 24500.00, 143);
INSERT INTO `mydb`.`InventoryAnalytics` (`InvAnalyticsID`, `AnalysisDate`, `Quantity`, `Costs`, `Materials_MaterialID`) VALUES (44, '2023-02-13 00:00:00', 500, 25000.00, 144);
INSERT INTO `mydb`.`InventoryAnalytics` (`InvAnalyticsID`, `AnalysisDate`, `Quantity`, `Costs`, `Materials_MaterialID`) VALUES (45, '2023-02-14 00:00:00', 510, 25500.00, 145);
INSERT INTO `mydb`.`InventoryAnalytics` (`InvAnalyticsID`, `AnalysisDate`, `Quantity`, `Costs`, `Materials_MaterialID`) VALUES (46, '2023-02-15 00:00:00', 520, 26000.00, 146);
INSERT INTO `mydb`.`InventoryAnalytics` (`InvAnalyticsID`, `AnalysisDate`, `Quantity`, `Costs`, `Materials_MaterialID`) VALUES (47, '2023-02-16 00:00:00', 530, 26500.00, 147);
INSERT INTO `mydb`.`InventoryAnalytics` (`InvAnalyticsID`, `AnalysisDate`, `Quantity`, `Costs`, `Materials_MaterialID`) VALUES (48, '2023-02-17 00:00:00', 540, 27000.00, 148);
INSERT INTO `mydb`.`InventoryAnalytics` (`InvAnalyticsID`, `AnalysisDate`, `Quantity`, `Costs`, `Materials_MaterialID`) VALUES (49, '2023-02-18 00:00:00', 550, 27500.00, 149);
INSERT INTO `mydb`.`InventoryAnalytics` (`InvAnalyticsID`, `AnalysisDate`, `Quantity`, `Costs`, `Materials_MaterialID`) VALUES (50, '2023-02-19 00:00:00', 560, 28000.00, 150);
COMMIT;

Add Comment

Please, Sign In to add comment