· 5 months ago · May 06, 2025, 10:15 AM
1-- MySQL Script generated by MySQL Workbench
2-- Tue Mar 25 16:11:13 2025
3-- Model: New Model Version: 1.0
4-- MySQL Workbench Forward Engineering
5
6SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
7SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
8SET @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';
9
10-- -----------------------------------------------------
11-- Schema mydb
12-- -----------------------------------------------------
13
14-- -----------------------------------------------------
15-- Schema mydb
16-- -----------------------------------------------------
17CREATE SCHEMA IF NOT EXISTS `mydb` DEFAULT CHARACTER SET utf8 ;
18USE `mydb` ;
19
20-- -----------------------------------------------------
21-- Table `mydb`.`OrderStatuses`
22-- -----------------------------------------------------
23CREATE TABLE IF NOT EXISTS `mydb`.`OrderStatuses` (
24 `StatusID` INT NOT NULL AUTO_INCREMENT,
25 `StatusName` VARCHAR(50) NULL,
26 PRIMARY KEY (`StatusID`))
27ENGINE = InnoDB;
28
29
30-- -----------------------------------------------------
31-- Table `mydb`.`Customers`
32-- -----------------------------------------------------
33CREATE TABLE IF NOT EXISTS `mydb`.`Customers` (
34 `CustomerID` INT NOT NULL AUTO_INCREMENT,
35 `Name` VARCHAR(255) NULL,
36 `ContactInfo` VARCHAR(255) NULL,
37 `Adress` VARCHAR(255) NULL,
38 PRIMARY KEY (`CustomerID`))
39ENGINE = InnoDB;
40
41
42-- -----------------------------------------------------
43-- Table `mydb`.`Orders`
44-- -----------------------------------------------------
45CREATE TABLE IF NOT EXISTS `mydb`.`Orders` (
46 `OrderID` INT NOT NULL AUTO_INCREMENT,
47 `OrderDate` TIMESTAMP NULL,
48 `TotalAmount` DECIMAL(10,2) NULL,
49 `OrderStatuses_StatusID` INT NOT NULL,
50 `Customers_CustomerID` INT NOT NULL,
51 PRIMARY KEY (`OrderID`),
52 INDEX `fk_Orders_OrderStatuses1_idx` (`OrderStatuses_StatusID` ASC) VISIBLE,
53 INDEX `fk_Orders_Customers1_idx` (`Customers_CustomerID` ASC) VISIBLE,
54 CONSTRAINT `fk_Orders_OrderStatuses1`
55 FOREIGN KEY (`OrderStatuses_StatusID`)
56 REFERENCES `mydb`.`OrderStatuses` (`StatusID`)
57 ON DELETE NO ACTION
58 ON UPDATE NO ACTION,
59 CONSTRAINT `fk_Orders_Customers1`
60 FOREIGN KEY (`Customers_CustomerID`)
61 REFERENCES `mydb`.`Customers` (`CustomerID`)
62 ON DELETE NO ACTION
63 ON UPDATE NO ACTION)
64ENGINE = InnoDB;
65
66
67-- -----------------------------------------------------
68-- Table `mydb`.`ProductsCategories`
69-- -----------------------------------------------------
70CREATE TABLE IF NOT EXISTS `mydb`.`ProductsCategories` (
71 `ProductCategoryID` INT NOT NULL AUTO_INCREMENT,
72 `CategoryName` VARCHAR(100) NULL,
73 PRIMARY KEY (`ProductCategoryID`))
74ENGINE = InnoDB;
75
76
77-- -----------------------------------------------------
78-- Table `mydb`.`Products`
79-- -----------------------------------------------------
80CREATE TABLE IF NOT EXISTS `mydb`.`Products` (
81 `ProductID` INT NOT NULL AUTO_INCREMENT,
82 `Name` VARCHAR(255) NULL,
83 `Description` TEXT NULL,
84 `ProductsCategories_ProductCategoryID` INT NOT NULL,
85 PRIMARY KEY (`ProductID`),
86 INDEX `fk_Products_ProductsCategories1_idx` (`ProductsCategories_ProductCategoryID` ASC) VISIBLE,
87 CONSTRAINT `fk_Products_ProductsCategories1`
88 FOREIGN KEY (`ProductsCategories_ProductCategoryID`)
89 REFERENCES `mydb`.`ProductsCategories` (`ProductCategoryID`)
90 ON DELETE NO ACTION
91 ON UPDATE NO ACTION)
92ENGINE = InnoDB;
93
94
95-- -----------------------------------------------------
96-- Table `mydb`.`OrderDetails`
97-- -----------------------------------------------------
98CREATE TABLE IF NOT EXISTS `mydb`.`OrderDetails` (
99 `OrderDetailID` INT NOT NULL AUTO_INCREMENT,
100 `Price` DECIMAL(10,2) NULL,
101 `Orders_OrderID` INT NOT NULL,
102 `Products_ProductID` INT NOT NULL,
103 PRIMARY KEY (`OrderDetailID`),
104 INDEX `fk_OrderDetails_Orders1_idx` (`Orders_OrderID` ASC) VISIBLE,
105 INDEX `fk_OrderDetails_Products1_idx` (`Products_ProductID` ASC) VISIBLE,
106 CONSTRAINT `fk_OrderDetails_Orders1`
107 FOREIGN KEY (`Orders_OrderID`)
108 REFERENCES `mydb`.`Orders` (`OrderID`)
109 ON DELETE NO ACTION
110 ON UPDATE NO ACTION,
111 CONSTRAINT `fk_OrderDetails_Products1`
112 FOREIGN KEY (`Products_ProductID`)
113 REFERENCES `mydb`.`Products` (`ProductID`)
114 ON DELETE NO ACTION
115 ON UPDATE NO ACTION)
116ENGINE = InnoDB;
117
118
119-- -----------------------------------------------------
120-- Table `mydb`.`CustomersContacts`
121-- -----------------------------------------------------
122CREATE TABLE IF NOT EXISTS `mydb`.`CustomersContacts` (
123 `ContactID` INT NOT NULL AUTO_INCREMENT,
124 `ContactType` ENUM('Телефон', 'Почта') NULL,
125 `Value` VARCHAR(255) NULL,
126 `Customers_CustomerID` INT NOT NULL,
127 PRIMARY KEY (`ContactID`),
128 INDEX `fk_CustomersContacts_Customers1_idx` (`Customers_CustomerID` ASC) VISIBLE,
129 CONSTRAINT `fk_CustomersContacts_Customers1`
130 FOREIGN KEY (`Customers_CustomerID`)
131 REFERENCES `mydb`.`Customers` (`CustomerID`)
132 ON DELETE NO ACTION
133 ON UPDATE NO ACTION)
134ENGINE = InnoDB;
135
136
137-- -----------------------------------------------------
138-- Table `mydb`.`Quotes`
139-- -----------------------------------------------------
140CREATE TABLE IF NOT EXISTS `mydb`.`Quotes` (
141 `QuoteID` INT NOT NULL AUTO_INCREMENT,
142 `QuoteDate` TIMESTAMP NULL,
143 `TotalCost` DECIMAL(10,2) NULL,
144 `Customers_CustomerID` INT NOT NULL,
145 PRIMARY KEY (`QuoteID`),
146 INDEX `fk_Quotes_Customers1_idx` (`Customers_CustomerID` ASC) VISIBLE,
147 CONSTRAINT `fk_Quotes_Customers1`
148 FOREIGN KEY (`Customers_CustomerID`)
149 REFERENCES `mydb`.`Customers` (`CustomerID`)
150 ON DELETE NO ACTION
151 ON UPDATE NO ACTION)
152ENGINE = InnoDB;
153
154
155-- -----------------------------------------------------
156-- Table `mydb`.`QuoteDetails`
157-- -----------------------------------------------------
158CREATE TABLE IF NOT EXISTS `mydb`.`QuoteDetails` (
159 `QuoteDetailID` INT NOT NULL AUTO_INCREMENT,
160 `Quantity` INT NULL,
161 `Price` DECIMAL(10,2) NULL,
162 `Quotes_QuoteID` INT NOT NULL,
163 `Products_ProductID` INT NOT NULL,
164 PRIMARY KEY (`QuoteDetailID`),
165 INDEX `fk_QuoteDetails_Quotes1_idx` (`Quotes_QuoteID` ASC) VISIBLE,
166 INDEX `fk_QuoteDetails_Products1_idx` (`Products_ProductID` ASC) VISIBLE,
167 CONSTRAINT `fk_QuoteDetails_Quotes1`
168 FOREIGN KEY (`Quotes_QuoteID`)
169 REFERENCES `mydb`.`Quotes` (`QuoteID`)
170 ON DELETE NO ACTION
171 ON UPDATE NO ACTION,
172 CONSTRAINT `fk_QuoteDetails_Products1`
173 FOREIGN KEY (`Products_ProductID`)
174 REFERENCES `mydb`.`Products` (`ProductID`)
175 ON DELETE NO ACTION
176 ON UPDATE NO ACTION)
177ENGINE = InnoDB;
178
179
180-- -----------------------------------------------------
181-- Table `mydb`.`ProductionOrders`
182-- -----------------------------------------------------
183CREATE TABLE IF NOT EXISTS `mydb`.`ProductionOrders` (
184 `ProductionOrderID` INT NOT NULL AUTO_INCREMENT,
185 `StartDate` TIMESTAMP NULL,
186 `EndDate` TIMESTAMP NULL,
187 `Status` VARCHAR(45) NULL,
188 PRIMARY KEY (`ProductionOrderID`))
189ENGINE = InnoDB;
190
191
192-- -----------------------------------------------------
193-- Table `mydb`.`ProductionSteps`
194-- -----------------------------------------------------
195CREATE TABLE IF NOT EXISTS `mydb`.`ProductionSteps` (
196 `StepID` INT NOT NULL AUTO_INCREMENT,
197 `StepName` VARCHAR(100) NULL,
198 `Description` TEXT NULL,
199 PRIMARY KEY (`StepID`))
200ENGINE = InnoDB;
201
202
203-- -----------------------------------------------------
204-- Table `mydb`.`ProductionOrderSteps`
205-- -----------------------------------------------------
206CREATE TABLE IF NOT EXISTS `mydb`.`ProductionOrderSteps` (
207 `OrderStepID` INT NOT NULL AUTO_INCREMENT,
208 `Status` VARCHAR(45) NULL,
209 `ProductionSteps_StepID` INT NOT NULL,
210 `ProductionOrders_ProductionOrderID` INT NOT NULL,
211 PRIMARY KEY (`OrderStepID`),
212 INDEX `fk_ProductionOrderSteps_ProductionSteps1_idx` (`ProductionSteps_StepID` ASC) VISIBLE,
213 INDEX `fk_ProductionOrderSteps_ProductionOrders1_idx` (`ProductionOrders_ProductionOrderID` ASC) VISIBLE,
214 CONSTRAINT `fk_ProductionOrderSteps_ProductionSteps1`
215 FOREIGN KEY (`ProductionSteps_StepID`)
216 REFERENCES `mydb`.`ProductionSteps` (`StepID`)
217 ON DELETE NO ACTION
218 ON UPDATE NO ACTION,
219 CONSTRAINT `fk_ProductionOrderSteps_ProductionOrders1`
220 FOREIGN KEY (`ProductionOrders_ProductionOrderID`)
221 REFERENCES `mydb`.`ProductionOrders` (`ProductionOrderID`)
222 ON DELETE NO ACTION
223 ON UPDATE NO ACTION)
224ENGINE = InnoDB;
225
226
227-- -----------------------------------------------------
228-- Table `mydb`.`Materials`
229-- -----------------------------------------------------
230CREATE TABLE IF NOT EXISTS `mydb`.`Materials` (
231 `MaterialID` INT NOT NULL AUTO_INCREMENT,
232 `Name` VARCHAR(255) NULL,
233 `UnitOfMeasure` VARCHAR(45) NULL,
234 `PricePerUnit` DECIMAL(10,2) NULL,
235 PRIMARY KEY (`MaterialID`))
236ENGINE = InnoDB;
237
238
239-- -----------------------------------------------------
240-- Table `mydb`.`MaterialUsage`
241-- -----------------------------------------------------
242CREATE TABLE IF NOT EXISTS `mydb`.`MaterialUsage` (
243 `UsageID` INT NOT NULL AUTO_INCREMENT,
244 `Quantity` INT NULL,
245 `Materials_MaterialID` INT NOT NULL,
246 `Orders_OrderID` INT NOT NULL,
247 PRIMARY KEY (`UsageID`),
248 INDEX `fk_MaterialUsage_Materials1_idx` (`Materials_MaterialID` ASC) VISIBLE,
249 INDEX `fk_MaterialUsage_Orders1_idx` (`Orders_OrderID` ASC) VISIBLE,
250 CONSTRAINT `fk_MaterialUsage_Materials1`
251 FOREIGN KEY (`Materials_MaterialID`)
252 REFERENCES `mydb`.`Materials` (`MaterialID`)
253 ON DELETE NO ACTION
254 ON UPDATE NO ACTION,
255 CONSTRAINT `fk_MaterialUsage_Orders1`
256 FOREIGN KEY (`Orders_OrderID`)
257 REFERENCES `mydb`.`Orders` (`OrderID`)
258 ON DELETE NO ACTION
259 ON UPDATE NO ACTION)
260ENGINE = InnoDB;
261
262
263-- -----------------------------------------------------
264-- Table `mydb`.`Equipment`
265-- -----------------------------------------------------
266CREATE TABLE IF NOT EXISTS `mydb`.`Equipment` (
267 `EquipmentID` INT NOT NULL AUTO_INCREMENT,
268 `Name` VARCHAR(255) NULL,
269 `Model` VARCHAR(100) NULL,
270 `PurchaseDate` TIMESTAMP NULL,
271 `Equipmentcol` VARCHAR(45) NULL,
272 PRIMARY KEY (`EquipmentID`))
273ENGINE = InnoDB;
274
275
276-- -----------------------------------------------------
277-- Table `mydb`.`EquipmentMaintenance`
278-- -----------------------------------------------------
279CREATE TABLE IF NOT EXISTS `mydb`.`EquipmentMaintenance` (
280 `MaintenanceID` INT NOT NULL AUTO_INCREMENT,
281 `MaintenanceDate` TIMESTAMP NULL,
282 `Description` TEXT NULL,
283 `Equipment_EquipmentID` INT NOT NULL,
284 PRIMARY KEY (`MaintenanceID`),
285 INDEX `fk_EquipmentMaintenance_Equipment1_idx` (`Equipment_EquipmentID` ASC) VISIBLE,
286 CONSTRAINT `fk_EquipmentMaintenance_Equipment1`
287 FOREIGN KEY (`Equipment_EquipmentID`)
288 REFERENCES `mydb`.`Equipment` (`EquipmentID`)
289 ON DELETE NO ACTION
290 ON UPDATE NO ACTION)
291ENGINE = InnoDB;
292
293
294-- -----------------------------------------------------
295-- Table `mydb`.`Warehouses`
296-- -----------------------------------------------------
297CREATE TABLE IF NOT EXISTS `mydb`.`Warehouses` (
298 `WarehouseID` INT NOT NULL AUTO_INCREMENT,
299 `Name` VARCHAR(255) NULL,
300 `Address` VARCHAR(255) NULL,
301 PRIMARY KEY (`WarehouseID`))
302ENGINE = InnoDB;
303
304
305-- -----------------------------------------------------
306-- Table `mydb`.`Stocks`
307-- -----------------------------------------------------
308CREATE TABLE IF NOT EXISTS `mydb`.`Stocks` (
309 `StockID` INT NOT NULL AUTO_INCREMENT,
310 `Quantity` INT NULL,
311 `Warehouses_WarehouseID` INT NOT NULL,
312 `Materials_MaterialID` INT NOT NULL,
313 PRIMARY KEY (`StockID`),
314 INDEX `fk_Stocks_Warehouses1_idx` (`Warehouses_WarehouseID` ASC) VISIBLE,
315 INDEX `fk_Stocks_Materials1_idx` (`Materials_MaterialID` ASC) VISIBLE,
316 CONSTRAINT `fk_Stocks_Warehouses1`
317 FOREIGN KEY (`Warehouses_WarehouseID`)
318 REFERENCES `mydb`.`Warehouses` (`WarehouseID`)
319 ON DELETE NO ACTION
320 ON UPDATE NO ACTION,
321 CONSTRAINT `fk_Stocks_Materials1`
322 FOREIGN KEY (`Materials_MaterialID`)
323 REFERENCES `mydb`.`Materials` (`MaterialID`)
324 ON DELETE NO ACTION
325 ON UPDATE NO ACTION)
326ENGINE = InnoDB;
327
328
329-- -----------------------------------------------------
330-- Table `mydb`.`StockMovements`
331-- -----------------------------------------------------
332CREATE TABLE IF NOT EXISTS `mydb`.`StockMovements` (
333 `StockMovementsID` INT NOT NULL AUTO_INCREMENT,
334 `OperationType` ENUM('Приход', 'Расход') NULL,
335 `Quantity` INT NULL,
336 `Materials_MaterialID` INT NOT NULL,
337 `Warehouses_WarehouseID` INT NOT NULL,
338 PRIMARY KEY (`StockMovementsID`),
339 INDEX `fk_StockMovements_Materials1_idx` (`Materials_MaterialID` ASC) VISIBLE,
340 INDEX `fk_StockMovements_Warehouses1_idx` (`Warehouses_WarehouseID` ASC) VISIBLE,
341 CONSTRAINT `fk_StockMovements_Materials1`
342 FOREIGN KEY (`Materials_MaterialID`)
343 REFERENCES `mydb`.`Materials` (`MaterialID`)
344 ON DELETE NO ACTION
345 ON UPDATE NO ACTION,
346 CONSTRAINT `fk_StockMovements_Warehouses1`
347 FOREIGN KEY (`Warehouses_WarehouseID`)
348 REFERENCES `mydb`.`Warehouses` (`WarehouseID`)
349 ON DELETE NO ACTION
350 ON UPDATE NO ACTION)
351ENGINE = InnoDB;
352
353
354-- -----------------------------------------------------
355-- Table `mydb`.`Suppliers`
356-- -----------------------------------------------------
357CREATE TABLE IF NOT EXISTS `mydb`.`Suppliers` (
358 `SupplierID` INT NOT NULL AUTO_INCREMENT,
359 `Name` VARCHAR(255) NULL,
360 `ContactInfo` VARCHAR(255) NULL,
361 PRIMARY KEY (`SupplierID`))
362ENGINE = InnoDB;
363
364
365-- -----------------------------------------------------
366-- Table `mydb`.`SupplierContacts`
367-- -----------------------------------------------------
368CREATE TABLE IF NOT EXISTS `mydb`.`SupplierContacts` (
369 `ContactID` INT NOT NULL AUTO_INCREMENT,
370 `ContactType` ENUM('Телефон', 'Почта') NULL,
371 `Value` VARCHAR(255) NULL,
372 `Suppliers_SupplierID` INT NOT NULL,
373 PRIMARY KEY (`ContactID`),
374 INDEX `fk_SupplierContacts_Suppliers1_idx` (`Suppliers_SupplierID` ASC) VISIBLE,
375 CONSTRAINT `fk_SupplierContacts_Suppliers1`
376 FOREIGN KEY (`Suppliers_SupplierID`)
377 REFERENCES `mydb`.`Suppliers` (`SupplierID`)
378 ON DELETE NO ACTION
379 ON UPDATE NO ACTION)
380ENGINE = InnoDB;
381
382
383-- -----------------------------------------------------
384-- Table `mydb`.`PurchaseOrders`
385-- -----------------------------------------------------
386CREATE TABLE IF NOT EXISTS `mydb`.`PurchaseOrders` (
387 `PurchaseOrderID` INT NOT NULL AUTO_INCREMENT,
388 `OrderDate` TIMESTAMP NULL,
389 `Status` VARCHAR(45) NULL,
390 `Suppliers_SupplierID` INT NOT NULL,
391 PRIMARY KEY (`PurchaseOrderID`),
392 INDEX `fk_PurchaseOrders_Suppliers1_idx` (`Suppliers_SupplierID` ASC) VISIBLE,
393 CONSTRAINT `fk_PurchaseOrders_Suppliers1`
394 FOREIGN KEY (`Suppliers_SupplierID`)
395 REFERENCES `mydb`.`Suppliers` (`SupplierID`)
396 ON DELETE NO ACTION
397 ON UPDATE NO ACTION)
398ENGINE = InnoDB;
399
400
401-- -----------------------------------------------------
402-- Table `mydb`.`PurchaseOrderDetails`
403-- -----------------------------------------------------
404CREATE TABLE IF NOT EXISTS `mydb`.`PurchaseOrderDetails` (
405 `PurchaseDetailID` INT NOT NULL AUTO_INCREMENT,
406 `Quantity` INT NULL,
407 `Price` DECIMAL(10,2) NULL,
408 `PurchaseOrders_PurchaseOrderID` INT NOT NULL,
409 `Materials_MaterialID` INT NOT NULL,
410 PRIMARY KEY (`PurchaseDetailID`),
411 INDEX `fk_PurchaseOrderDetails_PurchaseOrders1_idx` (`PurchaseOrders_PurchaseOrderID` ASC) VISIBLE,
412 INDEX `fk_PurchaseOrderDetails_Materials1_idx` (`Materials_MaterialID` ASC) VISIBLE,
413 CONSTRAINT `fk_PurchaseOrderDetails_PurchaseOrders1`
414 FOREIGN KEY (`PurchaseOrders_PurchaseOrderID`)
415 REFERENCES `mydb`.`PurchaseOrders` (`PurchaseOrderID`)
416 ON DELETE NO ACTION
417 ON UPDATE NO ACTION,
418 CONSTRAINT `fk_PurchaseOrderDetails_Materials1`
419 FOREIGN KEY (`Materials_MaterialID`)
420 REFERENCES `mydb`.`Materials` (`MaterialID`)
421 ON DELETE NO ACTION
422 ON UPDATE NO ACTION)
423ENGINE = InnoDB;
424
425
426-- -----------------------------------------------------
427-- Table `mydb`.`Invoices`
428-- -----------------------------------------------------
429CREATE TABLE IF NOT EXISTS `mydb`.`Invoices` (
430 `InvoiceID` INT NOT NULL AUTO_INCREMENT,
431 `InvoiceDate` TIMESTAMP NULL,
432 `Amount` DECIMAL(10,2) NULL,
433 PRIMARY KEY (`InvoiceID`))
434ENGINE = InnoDB;
435
436
437-- -----------------------------------------------------
438-- Table `mydb`.`Payments`
439-- -----------------------------------------------------
440CREATE TABLE IF NOT EXISTS `mydb`.`Payments` (
441 `PaymentID` INT NOT NULL AUTO_INCREMENT,
442 `PaymentDate` TIMESTAMP NULL,
443 `Amount` DECIMAL(10,2) NULL,
444 `PaymentMethod` VARCHAR(45) NULL,
445 `Invoices_InvoiceID` INT NOT NULL,
446 PRIMARY KEY (`PaymentID`),
447 INDEX `fk_Payments_Invoices1_idx` (`Invoices_InvoiceID` ASC) VISIBLE,
448 CONSTRAINT `fk_Payments_Invoices1`
449 FOREIGN KEY (`Invoices_InvoiceID`)
450 REFERENCES `mydb`.`Invoices` (`InvoiceID`)
451 ON DELETE NO ACTION
452 ON UPDATE NO ACTION)
453ENGINE = InnoDB;
454
455
456-- -----------------------------------------------------
457-- Table `mydb`.`ExpenseCategories`
458-- -----------------------------------------------------
459CREATE TABLE IF NOT EXISTS `mydb`.`ExpenseCategories` (
460 `ExpenseCategoryID` INT NOT NULL AUTO_INCREMENT,
461 `CategoryName` VARCHAR(100) NULL,
462 PRIMARY KEY (`ExpenseCategoryID`))
463ENGINE = InnoDB;
464
465
466-- -----------------------------------------------------
467-- Table `mydb`.`Expenses`
468-- -----------------------------------------------------
469CREATE TABLE IF NOT EXISTS `mydb`.`Expenses` (
470 `ExpenseID` INT NOT NULL AUTO_INCREMENT,
471 `ExpenseDate` TIMESTAMP NULL,
472 `Amount` DECIMAL(10,2) NULL,
473 `ExpenseCategories_ExpenseCategoryID` INT NOT NULL,
474 PRIMARY KEY (`ExpenseID`),
475 INDEX `fk_Expenses_ExpenseCategories1_idx` (`ExpenseCategories_ExpenseCategoryID` ASC) VISIBLE,
476 CONSTRAINT `fk_Expenses_ExpenseCategories1`
477 FOREIGN KEY (`ExpenseCategories_ExpenseCategoryID`)
478 REFERENCES `mydb`.`ExpenseCategories` (`ExpenseCategoryID`)
479 ON DELETE NO ACTION
480 ON UPDATE NO ACTION)
481ENGINE = InnoDB;
482
483
484-- -----------------------------------------------------
485-- Table `mydb`.`Accounts`
486-- -----------------------------------------------------
487CREATE TABLE IF NOT EXISTS `mydb`.`Accounts` (
488 `AccountID` INT NOT NULL AUTO_INCREMENT,
489 `AccountName` VARCHAR(255) NULL,
490 `Balance` DECIMAL(10,2) NULL,
491 PRIMARY KEY (`AccountID`))
492ENGINE = InnoDB;
493
494
495-- -----------------------------------------------------
496-- Table `mydb`.`AccountTransactions`
497-- -----------------------------------------------------
498CREATE TABLE IF NOT EXISTS `mydb`.`AccountTransactions` (
499 `TransactionID` INT NOT NULL AUTO_INCREMENT,
500 `TransactionDate` TIMESTAMP NULL,
501 `Amount` DECIMAL(10,2) NULL,
502 `TransactionType` ENUM('Доход', 'Расход') NULL,
503 `Accounts_AccountID` INT NOT NULL,
504 PRIMARY KEY (`TransactionID`),
505 INDEX `fk_AccountTransactions_Accounts1_idx` (`Accounts_AccountID` ASC) VISIBLE,
506 CONSTRAINT `fk_AccountTransactions_Accounts1`
507 FOREIGN KEY (`Accounts_AccountID`)
508 REFERENCES `mydb`.`Accounts` (`AccountID`)
509 ON DELETE NO ACTION
510 ON UPDATE NO ACTION)
511ENGINE = InnoDB;
512
513
514-- -----------------------------------------------------
515-- Table `mydb`.`Departments`
516-- -----------------------------------------------------
517CREATE TABLE IF NOT EXISTS `mydb`.`Departments` (
518 `DepartmentID` INT NOT NULL AUTO_INCREMENT,
519 `DepartmentName` VARCHAR(100) NULL,
520 PRIMARY KEY (`DepartmentID`))
521ENGINE = InnoDB;
522
523
524-- -----------------------------------------------------
525-- Table `mydb`.`Employees`
526-- -----------------------------------------------------
527CREATE TABLE IF NOT EXISTS `mydb`.`Employees` (
528 `EmployeeID` INT NOT NULL AUTO_INCREMENT,
529 `Name` VARCHAR(255) NULL,
530 `Position` VARCHAR(100) NULL,
531 `ContactInfo` VARCHAR(255) NULL,
532 PRIMARY KEY (`EmployeeID`))
533ENGINE = InnoDB;
534
535
536-- -----------------------------------------------------
537-- Table `mydb`.`Salaries`
538-- -----------------------------------------------------
539CREATE TABLE IF NOT EXISTS `mydb`.`Salaries` (
540 `SalaryID` INT NOT NULL AUTO_INCREMENT,
541 `SalaryDate` DATE NULL,
542 `Amount` DECIMAL(10,2) NULL,
543 `Employees_EmployeeID` INT NOT NULL,
544 PRIMARY KEY (`SalaryID`),
545 INDEX `fk_Salaries_Employees1_idx` (`Employees_EmployeeID` ASC) VISIBLE,
546 CONSTRAINT `fk_Salaries_Employees1`
547 FOREIGN KEY (`Employees_EmployeeID`)
548 REFERENCES `mydb`.`Employees` (`EmployeeID`)
549 ON DELETE NO ACTION
550 ON UPDATE NO ACTION)
551ENGINE = InnoDB;
552
553
554-- -----------------------------------------------------
555-- Table `mydb`.`WorkSchedules`
556-- -----------------------------------------------------
557CREATE TABLE IF NOT EXISTS `mydb`.`WorkSchedules` (
558 `ScheduleID` INT NOT NULL AUTO_INCREMENT,
559 `WorkDate` TIMESTAMP NULL,
560 `StartTime` TIME NULL,
561 `EndTime` TIME NULL,
562 `Employees_EmployeeID` INT NOT NULL,
563 PRIMARY KEY (`ScheduleID`),
564 INDEX `fk_WorkSchedules_Employees1_idx` (`Employees_EmployeeID` ASC) VISIBLE,
565 CONSTRAINT `fk_WorkSchedules_Employees1`
566 FOREIGN KEY (`Employees_EmployeeID`)
567 REFERENCES `mydb`.`Employees` (`EmployeeID`)
568 ON DELETE NO ACTION
569 ON UPDATE NO ACTION)
570ENGINE = InnoDB;
571
572
573-- -----------------------------------------------------
574-- Table `mydb`.`EmployeeDepartments`
575-- -----------------------------------------------------
576CREATE TABLE IF NOT EXISTS `mydb`.`EmployeeDepartments` (
577 `EmployeeDepartmentID` INT NOT NULL AUTO_INCREMENT,
578 `Departments_DepartmentID` INT NOT NULL,
579 `Employees_EmployeeID` INT NOT NULL,
580 PRIMARY KEY (`EmployeeDepartmentID`),
581 INDEX `fk_EmployeeDepartments_Departments1_idx` (`Departments_DepartmentID` ASC) VISIBLE,
582 INDEX `fk_EmployeeDepartments_Employees1_idx` (`Employees_EmployeeID` ASC) VISIBLE,
583 CONSTRAINT `fk_EmployeeDepartments_Departments1`
584 FOREIGN KEY (`Departments_DepartmentID`)
585 REFERENCES `mydb`.`Departments` (`DepartmentID`)
586 ON DELETE NO ACTION
587 ON UPDATE NO ACTION,
588 CONSTRAINT `fk_EmployeeDepartments_Employees1`
589 FOREIGN KEY (`Employees_EmployeeID`)
590 REFERENCES `mydb`.`Employees` (`EmployeeID`)
591 ON DELETE NO ACTION
592 ON UPDATE NO ACTION)
593ENGINE = InnoDB;
594
595
596-- -----------------------------------------------------
597-- Table `mydb`.`Reports`
598-- -----------------------------------------------------
599CREATE TABLE IF NOT EXISTS `mydb`.`Reports` (
600 `ReportID` INT NOT NULL AUTO_INCREMENT,
601 `ReportName` VARCHAR(255) NULL,
602 `CreationDate` TIMESTAMP NULL,
603 `ReportType` VARCHAR(100) NULL,
604 PRIMARY KEY (`ReportID`))
605ENGINE = InnoDB;
606
607
608-- -----------------------------------------------------
609-- Table `mydb`.`ReportData`
610-- -----------------------------------------------------
611CREATE TABLE IF NOT EXISTS `mydb`.`ReportData` (
612 `ReportDataID` INT NOT NULL AUTO_INCREMENT,
613 `Metric` VARCHAR(255) NULL,
614 `Value` DECIMAL(10,2) NULL,
615 `Reports_ReportID` INT NOT NULL,
616 PRIMARY KEY (`ReportDataID`),
617 INDEX `fk_ReportData_Reports1_idx` (`Reports_ReportID` ASC) VISIBLE,
618 CONSTRAINT `fk_ReportData_Reports1`
619 FOREIGN KEY (`Reports_ReportID`)
620 REFERENCES `mydb`.`Reports` (`ReportID`)
621 ON DELETE NO ACTION
622 ON UPDATE NO ACTION)
623ENGINE = InnoDB;
624
625
626-- -----------------------------------------------------
627-- Table `mydb`.`KPIs`
628-- -----------------------------------------------------
629CREATE TABLE IF NOT EXISTS `mydb`.`KPIs` (
630 `KpiID` INT NOT NULL AUTO_INCREMENT,
631 `KPIName` VARCHAR(255) NULL,
632 `TargetValue` DECIMAL(10,2) NULL,
633 `ActualValue` DECIMAL(10,2) NULL,
634 PRIMARY KEY (`KpiID`))
635ENGINE = InnoDB;
636
637
638-- -----------------------------------------------------
639-- Table `mydb`.`SalesAnalytics`
640-- -----------------------------------------------------
641CREATE TABLE IF NOT EXISTS `mydb`.`SalesAnalytics` (
642 `SaleAnalyticsID` INT NOT NULL AUTO_INCREMENT,
643 `SaleDate` TIMESTAMP NULL,
644 `Quantity` INT NULL,
645 `Revenue` DECIMAL(10,2) NULL,
646 `Products_ProductID` INT NOT NULL,
647 PRIMARY KEY (`SaleAnalyticsID`),
648 INDEX `fk_SalesAnalytics_Products1_idx` (`Products_ProductID` ASC) VISIBLE,
649 CONSTRAINT `fk_SalesAnalytics_Products1`
650 FOREIGN KEY (`Products_ProductID`)
651 REFERENCES `mydb`.`Products` (`ProductID`)
652 ON DELETE NO ACTION
653 ON UPDATE NO ACTION)
654ENGINE = InnoDB;
655
656
657-- -----------------------------------------------------
658-- Table `mydb`.`ProductionAnalytics`
659-- -----------------------------------------------------
660CREATE TABLE IF NOT EXISTS `mydb`.`ProductionAnalytics` (
661 `ProdAnalyticsID` INT NOT NULL AUTO_INCREMENT,
662 `ProductionDate` TIMESTAMP NULL,
663 `Quantity` INT NULL,
664 `Costs` DECIMAL(10,2) NULL,
665 `Products_ProductID` INT NOT NULL,
666 PRIMARY KEY (`ProdAnalyticsID`),
667 INDEX `fk_ProductionAnalytics_Products1_idx` (`Products_ProductID` ASC) VISIBLE,
668 CONSTRAINT `fk_ProductionAnalytics_Products1`
669 FOREIGN KEY (`Products_ProductID`)
670 REFERENCES `mydb`.`Products` (`ProductID`)
671 ON DELETE NO ACTION
672 ON UPDATE NO ACTION)
673ENGINE = InnoDB;
674
675
676-- -----------------------------------------------------
677-- Table `mydb`.`InventoryAnalytics`
678-- -----------------------------------------------------
679CREATE TABLE IF NOT EXISTS `mydb`.`InventoryAnalytics` (
680 `InvAnalyticsID` INT NOT NULL AUTO_INCREMENT,
681 `AnalysisDate` TIMESTAMP NULL,
682 `Quantity` INT NULL,
683 `Costs` DECIMAL(10,2) NULL,
684 `Materials_MaterialID` INT NOT NULL,
685 PRIMARY KEY (`InvAnalyticsID`),
686 INDEX `fk_InventoryAnalytics_Materials1_idx` (`Materials_MaterialID` ASC) VISIBLE,
687 CONSTRAINT `fk_InventoryAnalytics_Materials1`
688 FOREIGN KEY (`Materials_MaterialID`)
689 REFERENCES `mydb`.`Materials` (`MaterialID`)
690 ON DELETE NO ACTION
691 ON UPDATE NO ACTION)
692ENGINE = InnoDB;
693
694USE `mydb` ;
695
696-- -----------------------------------------------------
697-- Placeholder table for view `mydb`.`view1`
698-- -----------------------------------------------------
699CREATE TABLE IF NOT EXISTS `mydb`.`view1` (`id` INT);
700
701-- -----------------------------------------------------
702-- Placeholder table for view `mydb`.`PopularProducts`
703-- -----------------------------------------------------
704CREATE TABLE IF NOT EXISTS `mydb`.`PopularProducts` (`Name` INT, `UsageCount` INT);
705
706-- -----------------------------------------------------
707-- Placeholder table for view `mydb`.`ActiveOrders`
708-- -----------------------------------------------------
709CREATE TABLE IF NOT EXISTS `mydb`.`ActiveOrders` (`OrderID` INT, `CustomerName` INT, `OrderDate` INT, `TotalAmount` INT, `Status` INT);
710
711-- -----------------------------------------------------
712-- Placeholder table for view `mydb`.`LowStockMaterials`
713-- -----------------------------------------------------
714CREATE TABLE IF NOT EXISTS `mydb`.`LowStockMaterials` (`MaterialID` INT, `Name` INT, `StockQuantity` INT);
715
716-- -----------------------------------------------------
717-- View `mydb`.`view1`
718-- -----------------------------------------------------
719DROP TABLE IF EXISTS `mydb`.`view1`;
720USE `mydb`;
721
722
723-- -----------------------------------------------------
724-- View `mydb`.`PopularProducts`
725-- -----------------------------------------------------
726DROP TABLE IF EXISTS `mydb`.`PopularProducts`;
727USE `mydb`;
728CREATE OR REPLACE VIEW PopularProducts AS
729SELECT
730 p.Name,
731 COUNT(od.Products_ProductID) AS UsageCount
732FROM OrderDetails od
733JOIN Products p ON od.Products_ProductID = p.ProductID
734GROUP BY od.Products_ProductID
735ORDER BY UsageCount DESC
736LIMIT 10;
737/*
738CREATE FUNCTION CalculateOrderTotal(OrderID INT) RETURNS DECIMAL(10, 2)
739BEGIN
740 DECLARE TotGenerateOrdersReportal DECIMAL(10, 2);
741
742 SELECT SUM(m.PricePerUnit * od.Quantity) INTO Total
743 FROM OrderDetails od
744 JOIN Products p ON od.Products_ProductID = p.ProductID
745 WHERE od.OrderID = OrderID;
746
747 RETURN IFNULL(Total, 0.00);
748END;*/
749
750-- -----------------------------------------------------
751-- View `mydb`.`ActiveOrders`
752-- -----------------------------------------------------
753DROP TABLE IF EXISTS `mydb`.`ActiveOrders`;
754USE `mydb`;
755CREATE OR REPLACE VIEW ActiveOrders AS
756SELECT
757 o.OrderID,
758 c.Name AS CustomerName,
759 o.OrderDate,
760 o.TotalAmount,
761 os.StatusName AS Status
762FROM Orders o
763JOIN Customers c ON o.customers_CustomerID = c.CustomerID
764JOIN OrderStatuses os ON o.OrderStatuses_StatusID = os.StatusID
765WHERE os.StatusName = 'Active';
766/*
767USE `mydb`;
768CREATE PROCEDURE GenerateOrdersReport (IN StartDate DATE, IN EndDate DATE)
769BEGIN
770 SELECT
771 o.OrderID,
772 c.Name AS CustomerName,
773 o.OrderDate,
774 o.TotalAmount,
775 os.StatusName
776 FROM Orders o
777 JOIN Customers c ON o.Customers_CustomerID = c.CustomerID
778 JOIN OrderStatuses os ON o.OrderStatuses_StatusID = os.StatusID
779 WHERE o.OrderDate BETWEEN StartDate AND EndDate
780END;
781*/
782-- -----------------------------------------------------
783-- View `mydb`.`LowStockMaterials`
784-- -----------------------------------------------------
785DROP TABLE IF EXISTS `mydb`.`LowStockMaterials`;
786USE `mydb`;
787CREATE OR REPLACE VIEW LowStockMaterials AS
788SELECT
789 m.MaterialID,
790 m.Name,
791 mu.Quantity AS StockQuantity
792FROM Materials m
793JOIN MaterialUsage mu ON m.MaterialID = mu.Materials_MaterialID
794WHERE mu.Quantity < 10;
795/*
796USE `mydb`;
797CREATE FUNCTION IsMaterialAvailable(MaterialID INT, RequiredQuantity INT) RETURNS BOOLEAN
798BEGIN
799 DECLARE AvailableQuantity INT;
800 SELECT Quantity INTO AvailableQuantity
801 FROM Stocks
802 WHERE Materials_MaterialID = MaterialID;
803 RETURN AvailableQuantity >= RequiredQuantity;
804END;
805*/
806USE `mydb`;
807
808DELIMITER $$
809USE `mydb`$$
810CREATE TRIGGER `LogCustomerUpdates`
811AFTER UPDATE ON `Customers`
812FOR EACH ROW
813BEGIN
814 -- Логируем изменения имени клиента
815 IF OLD.Name <> NEW.Name THEN
816 INSERT INTO Reports (ReportName, CreationDate, ReportType)
817 VALUES (
818 CONCAT('Customer name changed from "', OLD.Name, '" to "', NEW.Name, '".'),
819 NOW(),
820 'Update'
821 );
822 END IF;
823
824 -- Логируем изменения контактной информации
825 IF OLD.ContactInfo <> NEW.ContactInfo THEN
826 INSERT INTO Reports (ReportName, CreationDate, ReportType)
827 VALUES (
828 CONCAT('Customer contact info changed for ID ', OLD.CustomerID),
829 NOW(),
830 'Update'
831 );
832 END IF;
833END;$$
834
835USE `mydb`$$
836CREATE DEFINER = CURRENT_USER TRIGGER `mydb`.`Materials_BEFORE_INSERT`
837BEFORE INSERT ON `Materials`
838FOR EACH ROW
839BEGIN
840 -- Проверяем, что цена больше нуля
841 IF NEW.PricePerUnit <= 0 THEN
842 -- Записываем ошибку в таблицу Reports
843 INSERT INTO Reports (ReportName, CreationDate, ReportType)
844 VALUES (
845 CONCAT('Error: Invalid price value for material with ID ', NEW.MaterialID),
846 NOW(),
847 'Error'
848 );
849
850 -- Генерируем ошибку для отмены вставки
851 SIGNAL SQLSTATE '45000'
852 SET MESSAGE_TEXT = 'Price must be greater than zero.';
853 END IF;
854END$$
855
856USE `mydb`$$
857CREATE DEFINER = CURRENT_USER TRIGGER `mydb`.`Stocks_AFTER_INSERT` AFTER INSERT ON `Stocks` FOR EACH ROW
858BEGIN
859 INSERT INTO StockMovements (OperationType, Quantity, Materials_MaterialID, Warehouses_WarehouseID)
860 VALUES ('Приход', NEW.Quantity, NEW.Materials_MaterialID, NEW.Warehouses_WarehouseID);
861END$$
862
863USE `mydb`$$
864CREATE DEFINER = CURRENT_USER TRIGGER `mydb`.`Stocks_BEFORE_INSERT` BEFORE INSERT ON `Stocks` FOR EACH ROW
865BEGIN
866DECLARE CurrentStock INT;
867
868 -- Проверяем текущее количество товаров на складе
869 SELECT COALESCE(SUM(Quantity), 0) INTO CurrentStock
870 FROM Stocks
871 WHERE Warehouses_WarehouseID = NEW.Warehouses_WarehouseID;
872
873 IF (CurrentStock + NEW.Quantity) > 100000000 THEN
874 SIGNAL SQLSTATE '45000'
875 SET MESSAGE_TEXT = 'Warehouse capacity exceeded. Cannot add more items.';
876 END IF;
877END$$
878
879USE `mydb`$$
880CREATE DEFINER = CURRENT_USER TRIGGER `mydb`.`Suppliers_BEFORE_DELETE` BEFORE DELETE ON `Suppliers` FOR EACH ROW
881BEGIN
882 SIGNAL SQLSTATE '45000'
883 SET MESSAGE_TEXT = 'Deleting suppliers is not allowed.';
884END$$
885
886USE `mydb`$$
887CREATE DEFINER = CURRENT_USER TRIGGER `mydb`.`Employees_AFTER_UPDATE` AFTER UPDATE ON `Employees` FOR EACH ROW
888BEGIN
889
890END$$
891
892
893DELIMITER ;
894
895SET SQL_MODE=@OLD_SQL_MODE;
896SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
897SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;
898
899-- -----------------------------------------------------
900-- Data for table `mydb`.`OrderStatuses`
901-- -----------------------------------------------------
902START TRANSACTION;
903USE `mydb`;
904INSERT INTO `mydb`.`OrderStatuses` (`StatusID`, `StatusName`) VALUES (1, 'In Processing');
905INSERT INTO `mydb`.`OrderStatuses` (`StatusID`, `StatusName`) VALUES (2, 'In Production');
906INSERT INTO `mydb`.`OrderStatuses` (`StatusID`, `StatusName`) VALUES (3, 'Completed');
907INSERT INTO `mydb`.`OrderStatuses` (`StatusID`, `StatusName`) VALUES (4, 'Cancelled');
908INSERT INTO `mydb`.`OrderStatuses` (`StatusID`, `StatusName`) VALUES (5, 'Shipped');
909INSERT INTO `mydb`.`OrderStatuses` (`StatusID`, `StatusName`) VALUES (6, 'Delivered');
910INSERT INTO `mydb`.`OrderStatuses` (`StatusID`, `StatusName`) VALUES (7, 'On Hold');
911INSERT INTO `mydb`.`OrderStatuses` (`StatusID`, `StatusName`) VALUES (8, 'Returned');
912INSERT INTO `mydb`.`OrderStatuses` (`StatusID`, `StatusName`) VALUES (9, 'Pending Payment');
913INSERT INTO `mydb`.`OrderStatuses` (`StatusID`, `StatusName`) VALUES (10, 'Confirmed');
914
915COMMIT;
916
917
918-- -----------------------------------------------------
919-- Data for table `mydb`.`Customers`
920-- -----------------------------------------------------
921START TRANSACTION;
922USE `mydb`;
923INSERT INTO `mydb`.`Customers` (`CustomerID`, `Name`, `ContactInfo`, `Adress`) VALUES (101, 'Ivan Ivanov', 'Phone: +79001234567', 'Lenin St.');
924INSERT INTO `mydb`.`Customers` (`CustomerID`, `Name`, `ContactInfo`, `Adress`) VALUES (102, 'Petr Petrov', 'Email: petrov@example.com', 'Pushkin St.');
925INSERT INTO `mydb`.`Customers` (`CustomerID`, `Name`, `ContactInfo`, `Adress`) VALUES (103, 'Anna Sidorova', 'Phone: +79001234568', 'Gagarin St.');
926INSERT INTO `mydb`.`Customers` (`CustomerID`, `Name`, `ContactInfo`, `Adress`) VALUES (104, 'Mikhail Kuznetsov', 'Email: kuznetsov@example.com', 'Mira St.');
927INSERT INTO `mydb`.`Customers` (`CustomerID`, `Name`, `ContactInfo`, `Adress`) VALUES (105, 'Elena Morozova', 'Phone: +79001234569', 'Sovetskaya St.');
928INSERT INTO `mydb`.`Customers` (`CustomerID`, `Name`, `ContactInfo`, `Adress`) VALUES (106, 'Dmitry Nikolaev', 'Email: nikolaev@example.com', 'Central St.');
929INSERT INTO `mydb`.`Customers` (`CustomerID`, `Name`, `ContactInfo`, `Adress`) VALUES (107, 'Olga Fedorova', 'Phone: +79001234570', 'Naberezhnaya St.');
930INSERT INTO `mydb`.`Customers` (`CustomerID`, `Name`, `ContactInfo`, `Adress`) VALUES (108, 'Andrey Alekseev', 'Email: alexeev@example.com', 'Zarechnaya St.');
931INSERT INTO `mydb`.`Customers` (`CustomerID`, `Name`, `ContactInfo`, `Adress`) VALUES (109, 'Maria Smirnova', 'Phone: +79001234571', 'Yuzhnaya St.');
932INSERT INTO `mydb`.`Customers` (`CustomerID`, `Name`, `ContactInfo`, `Adress`) VALUES (110, 'Sergey Vasiliev', 'Email: vasiliev@example.com', 'Severnaya St.');
933INSERT INTO `mydb`.`Customers` (`CustomerID`, `Name`, `ContactInfo`, `Adress`) VALUES (111, 'Tatyana Kovaleva', 'Phone: +79001234572', 'Vostochnaya St.');
934INSERT INTO `mydb`.`Customers` (`CustomerID`, `Name`, `ContactInfo`, `Adress`) VALUES (112, 'Alexander Mikhailov', 'Email: mikhailov@example.com', 'Zapadnaya St.');
935INSERT INTO `mydb`.`Customers` (`CustomerID`, `Name`, `ContactInfo`, `Adress`) VALUES (113, 'Darya Egorova', 'Phone: +79001234573', 'Pervomayskaya St.');
936INSERT INTO `mydb`.`Customers` (`CustomerID`, `Name`, `ContactInfo`, `Adress`) VALUES (114, 'Igor Pavlov', 'Email: pavlov@example.com', 'Krasnaya St.');
937INSERT INTO `mydb`.`Customers` (`CustomerID`, `Name`, `ContactInfo`, `Adress`) VALUES (115, 'Ekaterina Sokolova', 'Phone: +79001234574', 'Bolshaya St.');
938INSERT INTO `mydb`.`Customers` (`CustomerID`, `Name`, `ContactInfo`, `Adress`) VALUES (116, 'Artem Zakharyov', 'Email: zaharov@example.com', 'Malaya St.');
939INSERT INTO `mydb`.`Customers` (`CustomerID`, `Name`, `ContactInfo`, `Adress`) VALUES (117, 'Anastasia Belova', 'Phone: +79001234575', 'Lesnaya St.');
940INSERT INTO `mydb`.`Customers` (`CustomerID`, `Name`, `ContactInfo`, `Adress`) VALUES (118, 'Maxim Grigoryev', 'Email: grigoriev@example.com', 'Polevaya St.');
941INSERT INTO `mydb`.`Customers` (`CustomerID`, `Name`, `ContactInfo`, `Adress`) VALUES (119, 'Victoria Romanova', 'Phone: +79001234576', 'Gornaya St.');
942INSERT INTO `mydb`.`Customers` (`CustomerID`, `Name`, `ContactInfo`, `Adress`) VALUES (120, 'Vladimir Shevchenko', 'Email: shevchenko@example.com', 'Rechnaya St.');
943INSERT INTO `mydb`.`Customers` (`CustomerID`, `Name`, `ContactInfo`, `Adress`) VALUES (121, 'Natalya Kuznetsova', 'Phone: +79001234577', 'Sadovaya St.');
944INSERT INTO `mydb`.`Customers` (`CustomerID`, `Name`, `ContactInfo`, `Adress`) VALUES (122, 'Dmitry Lebedev', 'Email: lebedev@example.com', 'Parkovaya St.');
945INSERT INTO `mydb`.`Customers` (`CustomerID`, `Name`, `ContactInfo`, `Adress`) VALUES (123, 'Elena Orlova', 'Phone: +79001234578', 'Shkolnaya St.');
946INSERT INTO `mydb`.`Customers` (`CustomerID`, `Name`, `ContactInfo`, `Adress`) VALUES (124, 'Andrey Semenov', 'Email: semenov@example.com', 'Tsvetochnaya St.');
947INSERT INTO `mydb`.`Customers` (`CustomerID`, `Name`, `ContactInfo`, `Adress`) VALUES (125, 'Mikhail Kovalev', 'Phone: +79001234579', 'Stroiteley St.');
948INSERT INTO `mydb`.`Customers` (`CustomerID`, `Name`, `ContactInfo`, `Adress`) VALUES (126, 'Anna Volkova', 'Email: volkova@example.com', 'Trudovaya St.');
949INSERT INTO `mydb`.`Customers` (`CustomerID`, `Name`, `ContactInfo`, `Adress`) VALUES (127, 'Ivan Morozov', 'Phone: +79001234580', 'Proletarskaya St.');
950INSERT INTO `mydb`.`Customers` (`CustomerID`, `Name`, `ContactInfo`, `Adress`) VALUES (128, 'Artem Nikitin', 'Email: nikitin@example.com', 'Zavodskaya St.');
951INSERT INTO `mydb`.`Customers` (`CustomerID`, `Name`, `ContactInfo`, `Adress`) VALUES (129, 'Sergey Fedorov', 'Phone: +79001234581', 'Beregovaya St.');
952INSERT INTO `mydb`.`Customers` (`CustomerID`, `Name`, `ContactInfo`, `Adress`) VALUES (130, 'Olga Andreyeva', 'Email: andreeva@example.com', 'Lugovaya St.');
953INSERT INTO `mydb`.`Customers` (`CustomerID`, `Name`, `ContactInfo`, `Adress`) VALUES (131, 'Dmitry Kozlov', 'Phone: +79001234582', 'Novaya St.');
954INSERT INTO `mydb`.`Customers` (`CustomerID`, `Name`, `ContactInfo`, `Adress`) VALUES (132, 'Maria Vasilieva', 'Email: vasileva@example.com', 'Staraya St.');
955INSERT INTO `mydb`.`Customers` (`CustomerID`, `Name`, `ContactInfo`, `Adress`) VALUES (133, 'Alexander Popov', 'Phone: +79001234583', 'Chistaya St.');
956INSERT INTO `mydb`.`Customers` (`CustomerID`, `Name`, `ContactInfo`, `Adress`) VALUES (134, 'Igor Sokolov', 'Email: sokolov@example.com', 'Dachnaya St.');
957INSERT INTO `mydb`.`Customers` (`CustomerID`, `Name`, `ContactInfo`, `Adress`) VALUES (135, 'Darya Zaitseva', 'Phone: +79001234584', 'Lugovaya St.');
958INSERT INTO `mydb`.`Customers` (`CustomerID`, `Name`, `ContactInfo`, `Adress`) VALUES (136, 'Mikhail Belyaev', 'Email: belyaev@example.com', 'Sosnovaya St.');
959INSERT INTO `mydb`.`Customers` (`CustomerID`, `Name`, `ContactInfo`, `Adress`) VALUES (137, 'Ekaterina Krylova', 'Phone: +79001234585', 'Yablonevaya St.');
960INSERT INTO `mydb`.`Customers` (`CustomerID`, `Name`, `ContactInfo`, `Adress`) VALUES (138, 'Artem Gusev', 'Email: gusev@example.com', 'Vishnevaya St.');
961INSERT INTO `mydb`.`Customers` (`CustomerID`, `Name`, `ContactInfo`, `Adress`) VALUES (139, 'Anastasia Makarova', 'Phone: +79001234586', 'Chereshevaya St.');
962INSERT INTO `mydb`.`Customers` (`CustomerID`, `Name`, `ContactInfo`, `Adress`) VALUES (140, 'Maxim Novikov', 'Email: novikov@example.com', 'Grushevaya St.');
963INSERT INTO `mydb`.`Customers` (`CustomerID`, `Name`, `ContactInfo`, `Adress`) VALUES (141, 'Dmitry Volkov', 'Phone: +79001234587', 'Persikovaya St.');
964INSERT INTO `mydb`.`Customers` (`CustomerID`, `Name`, `ContactInfo`, `Adress`) VALUES (142, 'Olga Kudryavtseva', 'Email: kudryavtseva@example.com', 'Abrikosovaya St.');
965INSERT INTO `mydb`.`Customers` (`CustomerID`, `Name`, `ContactInfo`, `Adress`) VALUES (143, 'Alexander Lazarev', 'Phone: +79001234588', 'Vinogradnaya St.');
966INSERT INTO `mydb`.`Customers` (`CustomerID`, `Name`, `ContactInfo`, `Adress`) VALUES (144, 'Andrey Medvedev', 'Email: medvedev@example.com', 'Klubnichnaya St.');
967INSERT INTO `mydb`.`Customers` (`CustomerID`, `Name`, `ContactInfo`, `Adress`) VALUES (145, 'Elena Yermakova', 'Phone: +79001234589', 'Malinovaya St.');
968INSERT INTO `mydb`.`Customers` (`CustomerID`, `Name`, `ContactInfo`, `Adress`) VALUES (146, 'Sergey Danilov', 'Email: danilov@example.com', 'Smorodinovaya St.');
969INSERT INTO `mydb`.`Customers` (`CustomerID`, `Name`, `ContactInfo`, `Adress`) VALUES (147, 'Maria Zhukova', 'Phone: +79001234590', 'Klyukvennaya St.');
970INSERT INTO `mydb`.`Customers` (`CustomerID`, `Name`, `ContactInfo`, `Adress`) VALUES (148, 'Dmitry Karpov', 'Email: karpov@example.com', 'Brusnichnaya St.');
971INSERT INTO `mydb`.`Customers` (`CustomerID`, `Name`, `ContactInfo`, `Adress`) VALUES (149, 'Anna Filippova', 'Phone: +79001234591', 'Oblepikhovaya St.');
972INSERT INTO `mydb`.`Customers` (`CustomerID`, `Name`, `ContactInfo`, `Adress`) VALUES (150, 'Mikhail Stepanov', 'Email: stepanov@example.com', 'Ryabinovaya St.');
973
974COMMIT;
975
976
977-- -----------------------------------------------------
978-- Data for table `mydb`.`Orders`
979-- -----------------------------------------------------
980START TRANSACTION;
981USE `mydb`;
982INSERT INTO `mydb`.`Orders` (`OrderID`, `OrderDate`, `TotalAmount`, `OrderStatuses_StatusID`, `Customers_CustomerID`) VALUES (1, '2023-01-05 10:00:00', 450.00, 1, 101);
983INSERT INTO `mydb`.`Orders` (`OrderID`, `OrderDate`, `TotalAmount`, `OrderStatuses_StatusID`, `Customers_CustomerID`) VALUES (2, '2023-01-06 11:00:00', 1200.50, 2, 102);
984INSERT INTO `mydb`.`Orders` (`OrderID`, `OrderDate`, `TotalAmount`, `OrderStatuses_StatusID`, `Customers_CustomerID`) VALUES (3, '2023-01-07 12:00:00', 890.75, 1, 103);
985INSERT INTO `mydb`.`Orders` (`OrderID`, `OrderDate`, `TotalAmount`, `OrderStatuses_StatusID`, `Customers_CustomerID`) VALUES (4, '2023-01-08 13:00:00', 250.00, 3, 104);
986INSERT INTO `mydb`.`Orders` (`OrderID`, `OrderDate`, `TotalAmount`, `OrderStatuses_StatusID`, `Customers_CustomerID`) VALUES (5, '2023-01-09 14:00:00', 670.25, 1, 105);
987INSERT INTO `mydb`.`Orders` (`OrderID`, `OrderDate`, `TotalAmount`, `OrderStatuses_StatusID`, `Customers_CustomerID`) VALUES (6, '2023-01-10 15:00:00', 1500.00, 2, 106);
988INSERT INTO `mydb`.`Orders` (`OrderID`, `OrderDate`, `TotalAmount`, `OrderStatuses_StatusID`, `Customers_CustomerID`) VALUES (7, '2023-01-11 16:00:00', 340.50, 1, 107);
989INSERT INTO `mydb`.`Orders` (`OrderID`, `OrderDate`, `TotalAmount`, `OrderStatuses_StatusID`, `Customers_CustomerID`) VALUES (8, '2023-01-12 17:00:00', 950.00, 3, 108);
990INSERT INTO `mydb`.`Orders` (`OrderID`, `OrderDate`, `TotalAmount`, `OrderStatuses_StatusID`, `Customers_CustomerID`) VALUES (9, '2023-01-13 18:00:00', 780.00, 1, 109);
991INSERT INTO `mydb`.`Orders` (`OrderID`, `OrderDate`, `TotalAmount`, `OrderStatuses_StatusID`, `Customers_CustomerID`) VALUES (10, '2023-01-14 19:00:00', 1100.75, 2, 110);
992INSERT INTO `mydb`.`Orders` (`OrderID`, `OrderDate`, `TotalAmount`, `OrderStatuses_StatusID`, `Customers_CustomerID`) VALUES (11, '2023-01-15 20:00:00', 500.00, 1, 111);
993INSERT INTO `mydb`.`Orders` (`OrderID`, `OrderDate`, `TotalAmount`, `OrderStatuses_StatusID`, `Customers_CustomerID`) VALUES (12, '2023-01-16 21:00:00', 1300.50, 3, 112);
994INSERT INTO `mydb`.`Orders` (`OrderID`, `OrderDate`, `TotalAmount`, `OrderStatuses_StatusID`, `Customers_CustomerID`) VALUES (13, '2023-01-17 22:00:00', 450.00, 1, 113);
995INSERT INTO `mydb`.`Orders` (`OrderID`, `OrderDate`, `TotalAmount`, `OrderStatuses_StatusID`, `Customers_CustomerID`) VALUES (14, '2023-01-18 23:00:00', 890.75, 2, 114);
996INSERT INTO `mydb`.`Orders` (`OrderID`, `OrderDate`, `TotalAmount`, `OrderStatuses_StatusID`, `Customers_CustomerID`) VALUES (15, '2023-01-19 00:00:00', 250.00, 1, 115);
997INSERT INTO `mydb`.`Orders` (`OrderID`, `OrderDate`, `TotalAmount`, `OrderStatuses_StatusID`, `Customers_CustomerID`) VALUES (16, '2023-01-20 01:00:00', 670.25, 3, 116);
998INSERT INTO `mydb`.`Orders` (`OrderID`, `OrderDate`, `TotalAmount`, `OrderStatuses_StatusID`, `Customers_CustomerID`) VALUES (17, '2023-01-21 02:00:00', 1500.00, 1, 117);
999INSERT INTO `mydb`.`Orders` (`OrderID`, `OrderDate`, `TotalAmount`, `OrderStatuses_StatusID`, `Customers_CustomerID`) VALUES (18, '2023-01-22 03:00:00', 340.50, 2, 118);
1000INSERT INTO `mydb`.`Orders` (`OrderID`, `OrderDate`, `TotalAmount`, `OrderStatuses_StatusID`, `Customers_CustomerID`) VALUES (19, '2023-01-23 04:00:00', 950.00, 1, 119);
1001INSERT INTO `mydb`.`Orders` (`OrderID`, `OrderDate`, `TotalAmount`, `OrderStatuses_StatusID`, `Customers_CustomerID`) VALUES (20, '2023-01-24 05:00:00', 780.00, 3, 120);
1002INSERT INTO `mydb`.`Orders` (`OrderID`, `OrderDate`, `TotalAmount`, `OrderStatuses_StatusID`, `Customers_CustomerID`) VALUES (21, '2023-01-25 06:00:00', 1100.75, 1, 121);
1003INSERT INTO `mydb`.`Orders` (`OrderID`, `OrderDate`, `TotalAmount`, `OrderStatuses_StatusID`, `Customers_CustomerID`) VALUES (22, '2023-01-26 07:00:00', 500.00, 2, 122);
1004INSERT INTO `mydb`.`Orders` (`OrderID`, `OrderDate`, `TotalAmount`, `OrderStatuses_StatusID`, `Customers_CustomerID`) VALUES (23, '2023-01-27 08:00:00', 1300.50, 1, 123);
1005INSERT INTO `mydb`.`Orders` (`OrderID`, `OrderDate`, `TotalAmount`, `OrderStatuses_StatusID`, `Customers_CustomerID`) VALUES (24, '2023-01-28 09:00:00', 450.00, 3, 124);
1006INSERT INTO `mydb`.`Orders` (`OrderID`, `OrderDate`, `TotalAmount`, `OrderStatuses_StatusID`, `Customers_CustomerID`) VALUES (25, '2023-01-29 10:00:00', 890.75, 1, 125);
1007INSERT INTO `mydb`.`Orders` (`OrderID`, `OrderDate`, `TotalAmount`, `OrderStatuses_StatusID`, `Customers_CustomerID`) VALUES (26, '2023-01-30 11:00:00', 250.00, 2, 126);
1008INSERT INTO `mydb`.`Orders` (`OrderID`, `OrderDate`, `TotalAmount`, `OrderStatuses_StatusID`, `Customers_CustomerID`) VALUES (27, '2023-01-31 12:00:00', 670.25, 1, 127);
1009INSERT INTO `mydb`.`Orders` (`OrderID`, `OrderDate`, `TotalAmount`, `OrderStatuses_StatusID`, `Customers_CustomerID`) VALUES (28, '2023-02-01 13:00:00', 1500.00, 3, 128);
1010INSERT INTO `mydb`.`Orders` (`OrderID`, `OrderDate`, `TotalAmount`, `OrderStatuses_StatusID`, `Customers_CustomerID`) VALUES (29, '2023-02-02 14:00:00', 340.50, 1, 129);
1011INSERT INTO `mydb`.`Orders` (`OrderID`, `OrderDate`, `TotalAmount`, `OrderStatuses_StatusID`, `Customers_CustomerID`) VALUES (30, '2023-02-03 15:00:00', 950.00, 2, 130);
1012INSERT INTO `mydb`.`Orders` (`OrderID`, `OrderDate`, `TotalAmount`, `OrderStatuses_StatusID`, `Customers_CustomerID`) VALUES (31, '2023-02-04 16:00:00', 780.00, 1, 131);
1013INSERT INTO `mydb`.`Orders` (`OrderID`, `OrderDate`, `TotalAmount`, `OrderStatuses_StatusID`, `Customers_CustomerID`) VALUES (32, '2023-02-05 17:00:00', 1100.75, 3, 132);
1014INSERT INTO `mydb`.`Orders` (`OrderID`, `OrderDate`, `TotalAmount`, `OrderStatuses_StatusID`, `Customers_CustomerID`) VALUES (33, '2023-02-06 18:00:00', 500.00, 1, 133);
1015INSERT INTO `mydb`.`Orders` (`OrderID`, `OrderDate`, `TotalAmount`, `OrderStatuses_StatusID`, `Customers_CustomerID`) VALUES (34, '2023-02-07 19:00:00', 1300.50, 2, 134);
1016INSERT INTO `mydb`.`Orders` (`OrderID`, `OrderDate`, `TotalAmount`, `OrderStatuses_StatusID`, `Customers_CustomerID`) VALUES (35, '2023-02-08 20:00:00', 450.00, 1, 135);
1017INSERT INTO `mydb`.`Orders` (`OrderID`, `OrderDate`, `TotalAmount`, `OrderStatuses_StatusID`, `Customers_CustomerID`) VALUES (36, '2023-02-09 21:00:00', 890.75, 3, 136);
1018INSERT INTO `mydb`.`Orders` (`OrderID`, `OrderDate`, `TotalAmount`, `OrderStatuses_StatusID`, `Customers_CustomerID`) VALUES (37, '2023-02-10 22:00:00', 250.00, 1, 137);
1019INSERT INTO `mydb`.`Orders` (`OrderID`, `OrderDate`, `TotalAmount`, `OrderStatuses_StatusID`, `Customers_CustomerID`) VALUES (38, '2023-02-11 23:00:00', 670.25, 2, 138);
1020INSERT INTO `mydb`.`Orders` (`OrderID`, `OrderDate`, `TotalAmount`, `OrderStatuses_StatusID`, `Customers_CustomerID`) VALUES (39, '2023-02-12 00:00:00', 1500.00, 1, 139);
1021INSERT INTO `mydb`.`Orders` (`OrderID`, `OrderDate`, `TotalAmount`, `OrderStatuses_StatusID`, `Customers_CustomerID`) VALUES (40, '2023-02-13 01:00:00', 340.50, 3, 140);
1022INSERT INTO `mydb`.`Orders` (`OrderID`, `OrderDate`, `TotalAmount`, `OrderStatuses_StatusID`, `Customers_CustomerID`) VALUES (41, '2023-02-14 02:00:00', 950.00, 1, 141);
1023INSERT INTO `mydb`.`Orders` (`OrderID`, `OrderDate`, `TotalAmount`, `OrderStatuses_StatusID`, `Customers_CustomerID`) VALUES (42, '2023-02-15 03:00:00', 780.00, 2, 142);
1024INSERT INTO `mydb`.`Orders` (`OrderID`, `OrderDate`, `TotalAmount`, `OrderStatuses_StatusID`, `Customers_CustomerID`) VALUES (43, '2023-02-16 04:00:00', 1100.75, 1, 143);
1025INSERT INTO `mydb`.`Orders` (`OrderID`, `OrderDate`, `TotalAmount`, `OrderStatuses_StatusID`, `Customers_CustomerID`) VALUES (44, '2023-02-17 05:00:00', 500.00, 3, 144);
1026INSERT INTO `mydb`.`Orders` (`OrderID`, `OrderDate`, `TotalAmount`, `OrderStatuses_StatusID`, `Customers_CustomerID`) VALUES (45, '2023-02-18 06:00:00', 1300.50, 1, 145);
1027INSERT INTO `mydb`.`Orders` (`OrderID`, `OrderDate`, `TotalAmount`, `OrderStatuses_StatusID`, `Customers_CustomerID`) VALUES (46, '2023-02-19 07:00:00', 450.00, 2, 146);
1028INSERT INTO `mydb`.`Orders` (`OrderID`, `OrderDate`, `TotalAmount`, `OrderStatuses_StatusID`, `Customers_CustomerID`) VALUES (47, '2023-02-20 08:00:00', 890.75, 1, 147);
1029INSERT INTO `mydb`.`Orders` (`OrderID`, `OrderDate`, `TotalAmount`, `OrderStatuses_StatusID`, `Customers_CustomerID`) VALUES (48, '2023-02-21 09:00:00', 250.00, 3, 148);
1030INSERT INTO `mydb`.`Orders` (`OrderID`, `OrderDate`, `TotalAmount`, `OrderStatuses_StatusID`, `Customers_CustomerID`) VALUES (49, '2023-02-22 10:00:00', 670.25, 1, 149);
1031INSERT INTO `mydb`.`Orders` (`OrderID`, `OrderDate`, `TotalAmount`, `OrderStatuses_StatusID`, `Customers_CustomerID`) VALUES (50, '2023-02-23 11:00:00', 1500.00, 2, 150);
1032
1033COMMIT;
1034
1035
1036-- -----------------------------------------------------
1037-- Data for table `mydb`.`ProductsCategories`
1038-- -----------------------------------------------------
1039START TRANSACTION;
1040USE `mydb`;
1041INSERT INTO `mydb`.`ProductsCategories` (`ProductCategoryID`, `CategoryName`) VALUES (1, 'Windows');
1042INSERT INTO `mydb`.`ProductsCategories` (`ProductCategoryID`, `CategoryName`) VALUES (2, 'Doors');
1043INSERT INTO `mydb`.`ProductsCategories` (`ProductCategoryID`, `CategoryName`) VALUES (3, 'Glass Systems');
1044
1045COMMIT;
1046
1047
1048-- -----------------------------------------------------
1049-- Data for table `mydb`.`Products`
1050-- -----------------------------------------------------
1051START TRANSACTION;
1052USE `mydb`;
1053INSERT INTO `mydb`.`Products` (`ProductID`, `Name`, `Description`, `ProductsCategories_ProductCategoryID`) VALUES (201, 'Double Glazed Window', 'Energy-efficient window with double glazing', 1);
1054INSERT INTO `mydb`.`Products` (`ProductID`, `Name`, `Description`, `ProductsCategories_ProductCategoryID`) VALUES (202, 'Triple Glazed Window', 'High insulation window with triple glazing', 1);
1055INSERT INTO `mydb`.`Products` (`ProductID`, `Name`, `Description`, `ProductsCategories_ProductCategoryID`) VALUES (203, 'Sliding Door', 'Large sliding door for balconies', 2);
1056INSERT INTO `mydb`.`Products` (`ProductID`, `Name`, `Description`, `ProductsCategories_ProductCategoryID`) VALUES (204, 'French Window', 'Classic design window with two opening sashes', 1);
1057INSERT INTO `mydb`.`Products` (`ProductID`, `Name`, `Description`, `ProductsCategories_ProductCategoryID`) VALUES (205, 'Balcony Door', 'Standard balcony door with single glazing', 2);
1058INSERT INTO `mydb`.`Products` (`ProductID`, `Name`, `Description`, `ProductsCategories_ProductCategoryID`) VALUES (206, 'Folding Window', 'Space-saving folding window system', 1);
1059INSERT INTO `mydb`.`Products` (`ProductID`, `Name`, `Description`, `ProductsCategories_ProductCategoryID`) VALUES (207, 'Custom Window', 'Customizable window design', 1);
1060INSERT INTO `mydb`.`Products` (`ProductID`, `Name`, `Description`, `ProductsCategories_ProductCategoryID`) VALUES (208, 'Security Door', 'Reinforced door with advanced locking mechanism', 2);
1061INSERT INTO `mydb`.`Products` (`ProductID`, `Name`, `Description`, `ProductsCategories_ProductCategoryID`) VALUES (209, 'Skylight Window', 'Roof-mounted window for natural light', 1);
1062INSERT INTO `mydb`.`Products` (`ProductID`, `Name`, `Description`, `ProductsCategories_ProductCategoryID`) VALUES (210, 'Soundproof Window', 'Window designed to reduce noise', 1);
1063INSERT INTO `mydb`.`Products` (`ProductID`, `Name`, `Description`, `ProductsCategories_ProductCategoryID`) VALUES (211, 'Thermal Insulated Window', 'Window optimized for thermal insulation', 1);
1064INSERT INTO `mydb`.`Products` (`ProductID`, `Name`, `Description`, `ProductsCategories_ProductCategoryID`) VALUES (212, 'Aluminum Frame Window', 'Durable window with aluminum frame', 1);
1065INSERT INTO `mydb`.`Products` (`ProductID`, `Name`, `Description`, `ProductsCategories_ProductCategoryID`) VALUES (213, 'PVC Frame Window', 'Cost-effective PVC framed window', 1);
1066INSERT INTO `mydb`.`Products` (`ProductID`, `Name`, `Description`, `ProductsCategories_ProductCategoryID`) VALUES (214, 'Steel Reinforced Door', 'Heavy-duty door with steel reinforcement', 2);
1067INSERT INTO `mydb`.`Products` (`ProductID`, `Name`, `Description`, `ProductsCategories_ProductCategoryID`) VALUES (215, 'Glass Partition Wall', 'Interior glass partition wall', 3);
1068INSERT INTO `mydb`.`Products` (`ProductID`, `Name`, `Description`, `ProductsCategories_ProductCategoryID`) VALUES (216, 'Curtain Wall System', 'Large glass facade system', 3);
1069INSERT INTO `mydb`.`Products` (`ProductID`, `Name`, `Description`, `ProductsCategories_ProductCategoryID`) VALUES (217, 'Security Glass Window', 'Window with laminated security glass', 1);
1070INSERT INTO `mydb`.`Products` (`ProductID`, `Name`, `Description`, `ProductsCategories_ProductCategoryID`) VALUES (218, 'UV Protected Window', 'Window with UV protection coating', 1);
1071INSERT INTO `mydb`.`Products` (`ProductID`, `Name`, `Description`, `ProductsCategories_ProductCategoryID`) VALUES (219, 'Energy Saving Window', 'Window with low-emissivity glass', 1);
1072INSERT INTO `mydb`.`Products` (`ProductID`, `Name`, `Description`, `ProductsCategories_ProductCategoryID`) VALUES (220, 'Acoustic Insulated Window', 'Window designed for sound insulation', 1);
1073INSERT INTO `mydb`.`Products` (`ProductID`, `Name`, `Description`, `ProductsCategories_ProductCategoryID`) VALUES (221, 'Fixed Glass Panel', 'Non-opening decorative glass panel', 3);
1074INSERT INTO `mydb`.`Products` (`ProductID`, `Name`, `Description`, `ProductsCategories_ProductCategoryID`) VALUES (222, 'Swing Door', 'Standard swing door with handle', 2);
1075INSERT INTO `mydb`.`Products` (`ProductID`, `Name`, `Description`, `ProductsCategories_ProductCategoryID`) VALUES (223, 'Automatic Sliding Door', 'Automatic door system for commercial use', 2);
1076INSERT INTO `mydb`.`Products` (`ProductID`, `Name`, `Description`, `ProductsCategories_ProductCategoryID`) VALUES (224, 'Folding Sliding Door', 'Combination of folding and sliding mechanisms', 2);
1077INSERT INTO `mydb`.`Products` (`ProductID`, `Name`, `Description`, `ProductsCategories_ProductCategoryID`) VALUES (225, 'Fire Rated Window', 'Window with fire-resistant glass', 1);
1078INSERT INTO `mydb`.`Products` (`ProductID`, `Name`, `Description`, `ProductsCategories_ProductCategoryID`) VALUES (226, 'Decorative Window', 'Window with artistic patterns', 1);
1079INSERT INTO `mydb`.`Products` (`ProductID`, `Name`, `Description`, `ProductsCategories_ProductCategoryID`) VALUES (227, 'Skylight Dome', 'Dome-shaped skylight for roofs', 1);
1080INSERT INTO `mydb`.`Products` (`ProductID`, `Name`, `Description`, `ProductsCategories_ProductCategoryID`) VALUES (228, 'Wooden Frame Window', 'Window with wooden frame finish', 1);
1081INSERT INTO `mydb`.`Products` (`ProductID`, `Name`, `Description`, `ProductsCategories_ProductCategoryID`) VALUES (229, 'Composite Frame Window', 'Window with composite material frame', 1);
1082INSERT INTO `mydb`.`Products` (`ProductID`, `Name`, `Description`, `ProductsCategories_ProductCategoryID`) VALUES (230, 'Glass Balustrade', 'Glass railing system for balconies', 3);
1083INSERT INTO `mydb`.`Products` (`ProductID`, `Name`, `Description`, `ProductsCategories_ProductCategoryID`) VALUES (231, 'Laminated Glass Window', 'Window with safety laminated glass', 1);
1084INSERT INTO `mydb`.`Products` (`ProductID`, `Name`, `Description`, `ProductsCategories_ProductCategoryID`) VALUES (232, 'Tinted Glass Window', 'Window with tinted glass for privacy', 1);
1085INSERT INTO `mydb`.`Products` (`ProductID`, `Name`, `Description`, `ProductsCategories_ProductCategoryID`) VALUES (233, 'Low Iron Glass Window', 'Window with extra-clear low-iron glass', 1);
1086INSERT INTO `mydb`.`Products` (`ProductID`, `Name`, `Description`, `ProductsCategories_ProductCategoryID`) VALUES (234, 'Reflective Glass Window', 'Window with reflective coating', 1);
1087INSERT INTO `mydb`.`Products` (`ProductID`, `Name`, `Description`, `ProductsCategories_ProductCategoryID`) VALUES (235, 'Insulated Glass Unit', 'Double-glazed unit with argon gas filling', 1);
1088INSERT INTO `mydb`.`Products` (`ProductID`, `Name`, `Description`, `ProductsCategories_ProductCategoryID`) VALUES (236, 'Frameless Glass Door', 'Modern frameless glass door', 2);
1089INSERT INTO `mydb`.`Products` (`ProductID`, `Name`, `Description`, `ProductsCategories_ProductCategoryID`) VALUES (237, 'Sliding Patio Door', 'Large sliding door for patios', 2);
1090INSERT INTO `mydb`.`Products` (`ProductID`, `Name`, `Description`, `ProductsCategories_ProductCategoryID`) VALUES (238, 'Frosted Glass Window', 'Window with frosted glass for privacy', 1);
1091INSERT INTO `mydb`.`Products` (`ProductID`, `Name`, `Description`, `ProductsCategories_ProductCategoryID`) VALUES (239, 'Heat Strengthened Glass', 'Window with heat-strengthened glass', 1);
1092INSERT INTO `mydb`.`Products` (`ProductID`, `Name`, `Description`, `ProductsCategories_ProductCategoryID`) VALUES (240, 'Vacuum Insulated Glass', 'Window with vacuum-insulated glass', 1);
1093INSERT INTO `mydb`.`Products` (`ProductID`, `Name`, `Description`, `ProductsCategories_ProductCategoryID`) VALUES (241, 'Electric Awning Window', 'Window with electric awning mechanism', 1);
1094INSERT INTO `mydb`.`Products` (`ProductID`, `Name`, `Description`, `ProductsCategories_ProductCategoryID`) VALUES (242, 'Sliding Folding Door', 'Door with sliding and folding mechanism', 2);
1095INSERT INTO `mydb`.`Products` (`ProductID`, `Name`, `Description`, `ProductsCategories_ProductCategoryID`) VALUES (243, 'Glass Facade System', 'Large-scale glass facade system', 3);
1096INSERT INTO `mydb`.`Products` (`ProductID`, `Name`, `Description`, `ProductsCategories_ProductCategoryID`) VALUES (244, 'Structural Glazing System', 'Frameless structural glazing system', 3);
1097INSERT INTO `mydb`.`Products` (`ProductID`, `Name`, `Description`, `ProductsCategories_ProductCategoryID`) VALUES (245, 'Solar Control Window', 'Window with solar control coating', 1);
1098INSERT INTO `mydb`.`Products` (`ProductID`, `Name`, `Description`, `ProductsCategories_ProductCategoryID`) VALUES (246, 'Noise Reduction Window', 'Window designed for noise reduction', 1);
1099INSERT INTO `mydb`.`Products` (`ProductID`, `Name`, `Description`, `ProductsCategories_ProductCategoryID`) VALUES (247, 'Energy Efficient Door', 'Thermally efficient door system', 2);
1100INSERT INTO `mydb`.`Products` (`ProductID`, `Name`, `Description`, `ProductsCategories_ProductCategoryID`) VALUES (248, 'Glass Canopy', 'Decorative glass canopy for entrances', 3);
1101INSERT INTO `mydb`.`Products` (`ProductID`, `Name`, `Description`, `ProductsCategories_ProductCategoryID`) VALUES (249, 'Glass Floor Panel', 'Walkable glass floor panel', 3);
1102INSERT INTO `mydb`.`Products` (`ProductID`, `Name`, `Description`, `ProductsCategories_ProductCategoryID`) VALUES (250, 'Glass Staircase', 'Modern glass staircase system', 3);
1103
1104COMMIT;
1105
1106
1107-- -----------------------------------------------------
1108-- Data for table `mydb`.`OrderDetails`
1109-- -----------------------------------------------------
1110START TRANSACTION;
1111USE `mydb`;
1112INSERT INTO `mydb`.`OrderDetails` (`OrderDetailID`, `Price`, `Orders_OrderID`, `Products_ProductID`) VALUES (1, 225.00, 1, 201);
1113INSERT INTO `mydb`.`OrderDetails` (`OrderDetailID`, `Price`, `Orders_OrderID`, `Products_ProductID`) VALUES (2, 400.17, 2, 202);
1114INSERT INTO `mydb`.`OrderDetails` (`OrderDetailID`, `Price`, `Orders_OrderID`, `Products_ProductID`) VALUES (3, 890.75, 3, 203);
1115INSERT INTO `mydb`.`OrderDetails` (`OrderDetailID`, `Price`, `Orders_OrderID`, `Products_ProductID`) VALUES (4, 50.00, 4, 204);
1116INSERT INTO `mydb`.`OrderDetails` (`OrderDetailID`, `Price`, `Orders_OrderID`, `Products_ProductID`) VALUES (5, 335.13, 5, 205);
1117INSERT INTO `mydb`.`OrderDetails` (`OrderDetailID`, `Price`, `Orders_OrderID`, `Products_ProductID`) VALUES (6, 375.00, 6, 206);
1118INSERT INTO `mydb`.`OrderDetails` (`OrderDetailID`, `Price`, `Orders_OrderID`, `Products_ProductID`) VALUES (7, 113.50, 7, 207);
1119INSERT INTO `mydb`.`OrderDetails` (`OrderDetailID`, `Price`, `Orders_OrderID`, `Products_ProductID`) VALUES (8, 475.00, 8, 208);
1120INSERT INTO `mydb`.`OrderDetails` (`OrderDetailID`, `Price`, `Orders_OrderID`, `Products_ProductID`) VALUES (9, 195.00, 9, 209);
1121INSERT INTO `mydb`.`OrderDetails` (`OrderDetailID`, `Price`, `Orders_OrderID`, `Products_ProductID`) VALUES (10, 366.92, 10, 210);
1122INSERT INTO `mydb`.`OrderDetails` (`OrderDetailID`, `Price`, `Orders_OrderID`, `Products_ProductID`) VALUES (11, 500.00, 11, 211);
1123INSERT INTO `mydb`.`OrderDetails` (`OrderDetailID`, `Price`, `Orders_OrderID`, `Products_ProductID`) VALUES (12, 260.10, 12, 212);
1124INSERT INTO `mydb`.`OrderDetails` (`OrderDetailID`, `Price`, `Orders_OrderID`, `Products_ProductID`) VALUES (13, 125.00, 13, 213);
1125INSERT INTO `mydb`.`OrderDetails` (`OrderDetailID`, `Price`, `Orders_OrderID`, `Products_ProductID`) VALUES (14, 296.67, 14, 214);
1126INSERT INTO `mydb`.`OrderDetails` (`OrderDetailID`, `Price`, `Orders_OrderID`, `Products_ProductID`) VALUES (15, 167.50, 15, 215);
1127INSERT INTO `mydb`.`OrderDetails` (`OrderDetailID`, `Price`, `Orders_OrderID`, `Products_ProductID`) VALUES (16, 335.13, 16, 216);
1128INSERT INTO `mydb`.`OrderDetails` (`OrderDetailID`, `Price`, `Orders_OrderID`, `Products_ProductID`) VALUES (17, 300.00, 17, 217);
1129INSERT INTO `mydb`.`OrderDetails` (`OrderDetailID`, `Price`, `Orders_OrderID`, `Products_ProductID`) VALUES (18, 113.50, 18, 218);
1130INSERT INTO `mydb`.`OrderDetails` (`OrderDetailID`, `Price`, `Orders_OrderID`, `Products_ProductID`) VALUES (19, 237.50, 19, 219);
1131INSERT INTO `mydb`.`OrderDetails` (`OrderDetailID`, `Price`, `Orders_OrderID`, `Products_ProductID`) VALUES (20, 390.00, 20, 220);
1132INSERT INTO `mydb`.`OrderDetails` (`OrderDetailID`, `Price`, `Orders_OrderID`, `Products_ProductID`) VALUES (21, 366.92, 21, 221);
1133INSERT INTO `mydb`.`OrderDetails` (`OrderDetailID`, `Price`, `Orders_OrderID`, `Products_ProductID`) VALUES (22, 500.00, 22, 222);
1134INSERT INTO `mydb`.`OrderDetails` (`OrderDetailID`, `Price`, `Orders_OrderID`, `Products_ProductID`) VALUES (23, 260.10, 23, 223);
1135INSERT INTO `mydb`.`OrderDetails` (`OrderDetailID`, `Price`, `Orders_OrderID`, `Products_ProductID`) VALUES (24, 125.00, 24, 224);
1136INSERT INTO `mydb`.`OrderDetails` (`OrderDetailID`, `Price`, `Orders_OrderID`, `Products_ProductID`) VALUES (25, 296.67, 25, 225);
1137INSERT INTO `mydb`.`OrderDetails` (`OrderDetailID`, `Price`, `Orders_OrderID`, `Products_ProductID`) VALUES (26, 167.50, 26, 226);
1138INSERT INTO `mydb`.`OrderDetails` (`OrderDetailID`, `Price`, `Orders_OrderID`, `Products_ProductID`) VALUES (27, 335.13, 27, 227);
1139INSERT INTO `mydb`.`OrderDetails` (`OrderDetailID`, `Price`, `Orders_OrderID`, `Products_ProductID`) VALUES (28, 300.00, 28, 228);
1140INSERT INTO `mydb`.`OrderDetails` (`OrderDetailID`, `Price`, `Orders_OrderID`, `Products_ProductID`) VALUES (29, 113.50, 29, 229);
1141INSERT INTO `mydb`.`OrderDetails` (`OrderDetailID`, `Price`, `Orders_OrderID`, `Products_ProductID`) VALUES (30, 237.50, 30, 230);
1142INSERT INTO `mydb`.`OrderDetails` (`OrderDetailID`, `Price`, `Orders_OrderID`, `Products_ProductID`) VALUES (31, 390.00, 31, 231);
1143INSERT INTO `mydb`.`OrderDetails` (`OrderDetailID`, `Price`, `Orders_OrderID`, `Products_ProductID`) VALUES (32, 366.92, 32, 232);
1144INSERT INTO `mydb`.`OrderDetails` (`OrderDetailID`, `Price`, `Orders_OrderID`, `Products_ProductID`) VALUES (33, 500.00, 33, 233);
1145INSERT INTO `mydb`.`OrderDetails` (`OrderDetailID`, `Price`, `Orders_OrderID`, `Products_ProductID`) VALUES (34, 260.10, 34, 234);
1146INSERT INTO `mydb`.`OrderDetails` (`OrderDetailID`, `Price`, `Orders_OrderID`, `Products_ProductID`) VALUES (35, 125.00, 35, 235);
1147INSERT INTO `mydb`.`OrderDetails` (`OrderDetailID`, `Price`, `Orders_OrderID`, `Products_ProductID`) VALUES (36, 296.67, 36, 236);
1148INSERT INTO `mydb`.`OrderDetails` (`OrderDetailID`, `Price`, `Orders_OrderID`, `Products_ProductID`) VALUES (37, 167.50, 37, 237);
1149INSERT INTO `mydb`.`OrderDetails` (`OrderDetailID`, `Price`, `Orders_OrderID`, `Products_ProductID`) VALUES (38, 335.13, 38, 238);
1150INSERT INTO `mydb`.`OrderDetails` (`OrderDetailID`, `Price`, `Orders_OrderID`, `Products_ProductID`) VALUES (39, 300.00, 39, 239);
1151INSERT INTO `mydb`.`OrderDetails` (`OrderDetailID`, `Price`, `Orders_OrderID`, `Products_ProductID`) VALUES (40, 113.50, 40, 240);
1152INSERT INTO `mydb`.`OrderDetails` (`OrderDetailID`, `Price`, `Orders_OrderID`, `Products_ProductID`) VALUES (41, 237.50, 41, 241);
1153INSERT INTO `mydb`.`OrderDetails` (`OrderDetailID`, `Price`, `Orders_OrderID`, `Products_ProductID`) VALUES (42, 390.00, 42, 242);
1154INSERT INTO `mydb`.`OrderDetails` (`OrderDetailID`, `Price`, `Orders_OrderID`, `Products_ProductID`) VALUES (43, 366.92, 43, 243);
1155INSERT INTO `mydb`.`OrderDetails` (`OrderDetailID`, `Price`, `Orders_OrderID`, `Products_ProductID`) VALUES (44, 500.00, 44, 244);
1156INSERT INTO `mydb`.`OrderDetails` (`OrderDetailID`, `Price`, `Orders_OrderID`, `Products_ProductID`) VALUES (45, 260.10, 45, 245);
1157INSERT INTO `mydb`.`OrderDetails` (`OrderDetailID`, `Price`, `Orders_OrderID`, `Products_ProductID`) VALUES (46, 125.00, 46, 246);
1158INSERT INTO `mydb`.`OrderDetails` (`OrderDetailID`, `Price`, `Orders_OrderID`, `Products_ProductID`) VALUES (47, 296.67, 47, 247);
1159INSERT INTO `mydb`.`OrderDetails` (`OrderDetailID`, `Price`, `Orders_OrderID`, `Products_ProductID`) VALUES (48, 167.50, 48, 248);
1160INSERT INTO `mydb`.`OrderDetails` (`OrderDetailID`, `Price`, `Orders_OrderID`, `Products_ProductID`) VALUES (49, 335.13, 49, 249);
1161INSERT INTO `mydb`.`OrderDetails` (`OrderDetailID`, `Price`, `Orders_OrderID`, `Products_ProductID`) VALUES (50, 300.00, 50, 250);
1162
1163COMMIT;
1164
1165
1166-- -----------------------------------------------------
1167-- Data for table `mydb`.`CustomersContacts`
1168-- -----------------------------------------------------
1169START TRANSACTION;
1170
1171USE `mydb`;
1172
1173INSERT INTO `mydb`.`CustomersContacts` (`ContactID`, `Customers_CustomerID`, `ContactType`, `Value`)
1174VALUES
1175 (1, 101, 'Телефон', '+79001234567'),
1176 (2, 102, 'Почта', 'petrov@example.com'),
1177 (3, 103, 'Телефон', '+79001234568'),
1178 (4, 104, 'Почта', 'kuznetsov@example.com'),
1179 (5, 105, 'Телефон', '+79001234569'),
1180 (6, 106, 'Почта', 'nikolaev@example.com'),
1181 (7, 107, 'Телефон', '+79001234570'),
1182 (8, 108, 'Почта', 'alexeev@example.com'),
1183 (9, 109, 'Телефон', '+79001234571'),
1184 (10, 110, 'Почта', 'vasiliev@example.com'),
1185 (11, 111, 'Телефон', '+79001234572'),
1186 (12, 112, 'Почта', 'mikhailov@example.com'),
1187 (13, 113, 'Телефон', '+79001234573'),
1188 (14, 114, 'Почта', 'pavlov@example.com'),
1189 (15, 115, 'Телефон', '+79001234574'),
1190 (16, 116, 'Почта', 'zaharov@example.com'),
1191 (17, 117, 'Телефон', '+79001234575'),
1192 (18, 118, 'Почта', 'grigoriev@example.com'),
1193 (19, 119, 'Телефон', '+79001234576'),
1194 (20, 120, 'Почта', 'shevchenko@example.com'),
1195 (21, 121, 'Телефон', '+79001234577'),
1196 (22, 122, 'Почта', 'lebedev@example.com'),
1197 (23, 123, 'Телефон', '+79001234578'),
1198 (24, 124, 'Почта', 'semenov@example.com'),
1199 (25, 125, 'Телефон', '+79001234579'),
1200 (26, 126, 'Почта', 'volkova@example.com'),
1201 (27, 127, 'Телефон', '+79001234580'),
1202 (28, 128, 'Почта', 'nikitin@example.com'),
1203 (29, 129, 'Телефон', '+79001234581'),
1204 (30, 130, 'Почта', 'andreeva@example.com'),
1205 (31, 131, 'Телефон', '+79001234582'),
1206 (32, 132, 'Почта', 'vasileva@example.com'),
1207 (33, 133, 'Телефон', '+79001234583'),
1208 (34, 134, 'Почта', 'sokolov@example.com'),
1209 (35, 135, 'Телефон', '+79001234584'),
1210 (36, 136, 'Почта', 'belyaev@example.com'),
1211 (37, 137, 'Телефон', '+79001234585'),
1212 (38, 138, 'Почта', 'gusev@example.com'),
1213 (39, 139, 'Телефон', '+79001234586'),
1214 (40, 140, 'Почта', 'novikov@example.com'),
1215 (41, 141, 'Телефон', '+79001234587'),
1216 (42, 142, 'Почта', 'kudryavtseva@example.com'),
1217 (43, 143, 'Телефон', '+79001234588'),
1218 (44, 144, 'Почта', 'medvedev@example.com'),
1219 (45, 145, 'Телефон', '+79001234589'),
1220 (46, 146, 'Почта', 'danilov@example.com'),
1221 (47, 147, 'Телефон', '+79001234590'),
1222 (48, 148, 'Почта', 'karpov@example.com'),
1223 (49, 149, 'Телефон', '+79001234591'),
1224 (50, 150, 'Почта', 'stepanov@example.com');
1225
1226COMMIT;
1227
1228-- -----------------------------------------------------
1229-- Data for table `mydb`.`Quotes`
1230-- -----------------------------------------------------
1231START TRANSACTION;
1232USE `mydb`;
1233INSERT INTO `mydb`.`Quotes` (`QuoteID`, `QuoteDate`, `TotalCost`, `Customers_CustomerID`) VALUES (1, '2023-01-01 00:00:00', 500.00, 101);
1234INSERT INTO `mydb`.`Quotes` (`QuoteID`, `QuoteDate`, `TotalCost`, `Customers_CustomerID`) VALUES (2, '2023-01-02 00:00:00', 750.00, 102);
1235INSERT INTO `mydb`.`Quotes` (`QuoteID`, `QuoteDate`, `TotalCost`, `Customers_CustomerID`) VALUES (3, '2023-01-03 00:00:00', 1000.00, 103);
1236INSERT INTO `mydb`.`Quotes` (`QuoteID`, `QuoteDate`, `TotalCost`, `Customers_CustomerID`) VALUES (4, '2023-01-04 00:00:00', 600.00, 104);
1237INSERT INTO `mydb`.`Quotes` (`QuoteID`, `QuoteDate`, `TotalCost`, `Customers_CustomerID`) VALUES (5, '2023-01-05 00:00:00', 800.00, 105);
1238INSERT INTO `mydb`.`Quotes` (`QuoteID`, `QuoteDate`, `TotalCost`, `Customers_CustomerID`) VALUES (6, '2023-01-06 00:00:00', 900.00, 106);
1239INSERT INTO `mydb`.`Quotes` (`QuoteID`, `QuoteDate`, `TotalCost`, `Customers_CustomerID`) VALUES (7, '2023-01-07 00:00:00', 1200.00, 107);
1240INSERT INTO `mydb`.`Quotes` (`QuoteID`, `QuoteDate`, `TotalCost`, `Customers_CustomerID`) VALUES (8, '2023-01-08 00:00:00', 1500.00, 108);
1241INSERT INTO `mydb`.`Quotes` (`QuoteID`, `QuoteDate`, `TotalCost`, `Customers_CustomerID`) VALUES (9, '2023-01-09 00:00:00', 1800.00, 109);
1242INSERT INTO `mydb`.`Quotes` (`QuoteID`, `QuoteDate`, `TotalCost`, `Customers_CustomerID`) VALUES (10, '2023-01-10 00:00:00', 2000.00, 110);
1243INSERT INTO `mydb`.`Quotes` (`QuoteID`, `QuoteDate`, `TotalCost`, `Customers_CustomerID`) VALUES (11, '2023-01-11 00:00:00', 2200.00, 101);
1244INSERT INTO `mydb`.`Quotes` (`QuoteID`, `QuoteDate`, `TotalCost`, `Customers_CustomerID`) VALUES (12, '2023-01-12 00:00:00', 2500.00, 102);
1245INSERT INTO `mydb`.`Quotes` (`QuoteID`, `QuoteDate`, `TotalCost`, `Customers_CustomerID`) VALUES (13, '2023-01-13 00:00:00', 2800.00, 103);
1246INSERT INTO `mydb`.`Quotes` (`QuoteID`, `QuoteDate`, `TotalCost`, `Customers_CustomerID`) VALUES (14, '2023-01-14 00:00:00', 3000.00, 104);
1247INSERT INTO `mydb`.`Quotes` (`QuoteID`, `QuoteDate`, `TotalCost`, `Customers_CustomerID`) VALUES (15, '2023-01-15 00:00:00', 3200.00, 105);
1248INSERT INTO `mydb`.`Quotes` (`QuoteID`, `QuoteDate`, `TotalCost`, `Customers_CustomerID`) VALUES (16, '2023-01-16 00:00:00', 3500.00, 106);
1249INSERT INTO `mydb`.`Quotes` (`QuoteID`, `QuoteDate`, `TotalCost`, `Customers_CustomerID`) VALUES (17, '2023-01-17 00:00:00', 3800.00, 107);
1250INSERT INTO `mydb`.`Quotes` (`QuoteID`, `QuoteDate`, `TotalCost`, `Customers_CustomerID`) VALUES (18, '2023-01-18 00:00:00', 4000.00, 108);
1251INSERT INTO `mydb`.`Quotes` (`QuoteID`, `QuoteDate`, `TotalCost`, `Customers_CustomerID`) VALUES (19, '2023-01-19 00:00:00', 4200.00, 109);
1252INSERT INTO `mydb`.`Quotes` (`QuoteID`, `QuoteDate`, `TotalCost`, `Customers_CustomerID`) VALUES (20, '2023-01-20 00:00:00', 4500.00, 110);
1253INSERT INTO `mydb`.`Quotes` (`QuoteID`, `QuoteDate`, `TotalCost`, `Customers_CustomerID`) VALUES (21, '2023-01-21 00:00:00', 4800.00, 101);
1254INSERT INTO `mydb`.`Quotes` (`QuoteID`, `QuoteDate`, `TotalCost`, `Customers_CustomerID`) VALUES (22, '2023-01-22 00:00:00', 5000.00, 102);
1255INSERT INTO `mydb`.`Quotes` (`QuoteID`, `QuoteDate`, `TotalCost`, `Customers_CustomerID`) VALUES (23, '2023-01-23 00:00:00', 5200.00, 103);
1256INSERT INTO `mydb`.`Quotes` (`QuoteID`, `QuoteDate`, `TotalCost`, `Customers_CustomerID`) VALUES (24, '2023-01-24 00:00:00', 5500.00, 104);
1257INSERT INTO `mydb`.`Quotes` (`QuoteID`, `QuoteDate`, `TotalCost`, `Customers_CustomerID`) VALUES (25, '2023-01-25 00:00:00', 5800.00, 105);
1258INSERT INTO `mydb`.`Quotes` (`QuoteID`, `QuoteDate`, `TotalCost`, `Customers_CustomerID`) VALUES (26, '2023-01-26 00:00:00', 6000.00, 106);
1259INSERT INTO `mydb`.`Quotes` (`QuoteID`, `QuoteDate`, `TotalCost`, `Customers_CustomerID`) VALUES (27, '2023-01-27 00:00:00', 6200.00, 107);
1260INSERT INTO `mydb`.`Quotes` (`QuoteID`, `QuoteDate`, `TotalCost`, `Customers_CustomerID`) VALUES (28, '2023-01-28 00:00:00', 6500.00, 108);
1261INSERT INTO `mydb`.`Quotes` (`QuoteID`, `QuoteDate`, `TotalCost`, `Customers_CustomerID`) VALUES (29, '2023-01-29 00:00:00', 6800.00, 109);
1262INSERT INTO `mydb`.`Quotes` (`QuoteID`, `QuoteDate`, `TotalCost`, `Customers_CustomerID`) VALUES (30, '2023-01-30 00:00:00', 7000.00, 110);
1263INSERT INTO `mydb`.`Quotes` (`QuoteID`, `QuoteDate`, `TotalCost`, `Customers_CustomerID`) VALUES (31, '2023-02-01 00:00:00', 7200.00, 101);
1264INSERT INTO `mydb`.`Quotes` (`QuoteID`, `QuoteDate`, `TotalCost`, `Customers_CustomerID`) VALUES (32, '2023-02-02 00:00:00', 7500.00, 102);
1265INSERT INTO `mydb`.`Quotes` (`QuoteID`, `QuoteDate`, `TotalCost`, `Customers_CustomerID`) VALUES (33, '2023-02-03 00:00:00', 7800.00, 103);
1266INSERT INTO `mydb`.`Quotes` (`QuoteID`, `QuoteDate`, `TotalCost`, `Customers_CustomerID`) VALUES (34, '2023-02-04 00:00:00', 8000.00, 104);
1267INSERT INTO `mydb`.`Quotes` (`QuoteID`, `QuoteDate`, `TotalCost`, `Customers_CustomerID`) VALUES (35, '2023-02-05 00:00:00', 8200.00, 105);
1268INSERT INTO `mydb`.`Quotes` (`QuoteID`, `QuoteDate`, `TotalCost`, `Customers_CustomerID`) VALUES (36, '2023-02-06 00:00:00', 8500.00, 106);
1269INSERT INTO `mydb`.`Quotes` (`QuoteID`, `QuoteDate`, `TotalCost`, `Customers_CustomerID`) VALUES (37, '2023-02-07 00:00:00', 8800.00, 107);
1270INSERT INTO `mydb`.`Quotes` (`QuoteID`, `QuoteDate`, `TotalCost`, `Customers_CustomerID`) VALUES (38, '2023-02-08 00:00:00', 9000.00, 108);
1271INSERT INTO `mydb`.`Quotes` (`QuoteID`, `QuoteDate`, `TotalCost`, `Customers_CustomerID`) VALUES (39, '2023-02-09 00:00:00', 9200.00, 109);
1272INSERT INTO `mydb`.`Quotes` (`QuoteID`, `QuoteDate`, `TotalCost`, `Customers_CustomerID`) VALUES (40, '2023-02-10 00:00:00', 9500.00, 110);
1273INSERT INTO `mydb`.`Quotes` (`QuoteID`, `QuoteDate`, `TotalCost`, `Customers_CustomerID`) VALUES (41, '2023-02-11 00:00:00', 9800.00, 101);
1274INSERT INTO `mydb`.`Quotes` (`QuoteID`, `QuoteDate`, `TotalCost`, `Customers_CustomerID`) VALUES (42, '2023-02-12 00:00:00', 10000.00, 102);
1275INSERT INTO `mydb`.`Quotes` (`QuoteID`, `QuoteDate`, `TotalCost`, `Customers_CustomerID`) VALUES (43, '2023-02-13 00:00:00', 10200.00, 103);
1276INSERT INTO `mydb`.`Quotes` (`QuoteID`, `QuoteDate`, `TotalCost`, `Customers_CustomerID`) VALUES (44, '2023-02-14 00:00:00', 10500.00, 104);
1277INSERT INTO `mydb`.`Quotes` (`QuoteID`, `QuoteDate`, `TotalCost`, `Customers_CustomerID`) VALUES (45, '2023-02-15 00:00:00', 10800.00, 105);
1278INSERT INTO `mydb`.`Quotes` (`QuoteID`, `QuoteDate`, `TotalCost`, `Customers_CustomerID`) VALUES (46, '2023-02-16 00:00:00', 11000.00, 106);
1279INSERT INTO `mydb`.`Quotes` (`QuoteID`, `QuoteDate`, `TotalCost`, `Customers_CustomerID`) VALUES (47, '2023-02-17 00:00:00', 11200.00, 107);
1280INSERT INTO `mydb`.`Quotes` (`QuoteID`, `QuoteDate`, `TotalCost`, `Customers_CustomerID`) VALUES (48, '2023-02-18 00:00:00', 11500.00, 108);
1281INSERT INTO `mydb`.`Quotes` (`QuoteID`, `QuoteDate`, `TotalCost`, `Customers_CustomerID`) VALUES (49, '2023-02-19 00:00:00', 11800.00, 109);
1282INSERT INTO `mydb`.`Quotes` (`QuoteID`, `QuoteDate`, `TotalCost`, `Customers_CustomerID`) VALUES (50, '2023-02-20 00:00:00', 12000.00, 110);
1283
1284COMMIT;
1285
1286
1287-- -----------------------------------------------------
1288-- Data for table `mydb`.`QuoteDetails`
1289-- -----------------------------------------------------
1290START TRANSACTION;
1291USE `mydb`;
1292INSERT INTO `mydb`.`QuoteDetails` (`QuoteDetailID`, `Quantity`, `Price`, `Quotes_QuoteID`, `Products_ProductID`) VALUES (1, 2, 100.00, 1, 201);
1293INSERT INTO `mydb`.`QuoteDetails` (`QuoteDetailID`, `Quantity`, `Price`, `Quotes_QuoteID`, `Products_ProductID`) VALUES (2, 3, 150.00, 1, 202);
1294INSERT INTO `mydb`.`QuoteDetails` (`QuoteDetailID`, `Quantity`, `Price`, `Quotes_QuoteID`, `Products_ProductID`) VALUES (3, 1, 200.00, 2, 203);
1295INSERT INTO `mydb`.`QuoteDetails` (`QuoteDetailID`, `Quantity`, `Price`, `Quotes_QuoteID`, `Products_ProductID`) VALUES (4, 4, 250.00, 2, 204);
1296INSERT INTO `mydb`.`QuoteDetails` (`QuoteDetailID`, `Quantity`, `Price`, `Quotes_QuoteID`, `Products_ProductID`) VALUES (5, 2, 300.00, 3, 205);
1297INSERT INTO `mydb`.`QuoteDetails` (`QuoteDetailID`, `Quantity`, `Price`, `Quotes_QuoteID`, `Products_ProductID`) VALUES (6, 3, 350.00, 3, 206);
1298INSERT INTO `mydb`.`QuoteDetails` (`QuoteDetailID`, `Quantity`, `Price`, `Quotes_QuoteID`, `Products_ProductID`) VALUES (7, 1, 400.00, 4, 207);
1299INSERT INTO `mydb`.`QuoteDetails` (`QuoteDetailID`, `Quantity`, `Price`, `Quotes_QuoteID`, `Products_ProductID`) VALUES (8, 4, 450.00, 4, 208);
1300INSERT INTO `mydb`.`QuoteDetails` (`QuoteDetailID`, `Quantity`, `Price`, `Quotes_QuoteID`, `Products_ProductID`) VALUES (9, 2, 500.00, 5, 209);
1301INSERT INTO `mydb`.`QuoteDetails` (`QuoteDetailID`, `Quantity`, `Price`, `Quotes_QuoteID`, `Products_ProductID`) VALUES (10, 3, 550.00, 5, 210);
1302INSERT INTO `mydb`.`QuoteDetails` (`QuoteDetailID`, `Quantity`, `Price`, `Quotes_QuoteID`, `Products_ProductID`) VALUES (11, 1, 600.00, 6, 211);
1303INSERT INTO `mydb`.`QuoteDetails` (`QuoteDetailID`, `Quantity`, `Price`, `Quotes_QuoteID`, `Products_ProductID`) VALUES (12, 4, 650.00, 6, 212);
1304INSERT INTO `mydb`.`QuoteDetails` (`QuoteDetailID`, `Quantity`, `Price`, `Quotes_QuoteID`, `Products_ProductID`) VALUES (13, 2, 700.00, 7, 213);
1305INSERT INTO `mydb`.`QuoteDetails` (`QuoteDetailID`, `Quantity`, `Price`, `Quotes_QuoteID`, `Products_ProductID`) VALUES (14, 3, 750.00, 7, 214);
1306INSERT INTO `mydb`.`QuoteDetails` (`QuoteDetailID`, `Quantity`, `Price`, `Quotes_QuoteID`, `Products_ProductID`) VALUES (15, 1, 800.00, 8, 215);
1307INSERT INTO `mydb`.`QuoteDetails` (`QuoteDetailID`, `Quantity`, `Price`, `Quotes_QuoteID`, `Products_ProductID`) VALUES (16, 4, 850.00, 8, 216);
1308INSERT INTO `mydb`.`QuoteDetails` (`QuoteDetailID`, `Quantity`, `Price`, `Quotes_QuoteID`, `Products_ProductID`) VALUES (17, 2, 900.00, 9, 217);
1309INSERT INTO `mydb`.`QuoteDetails` (`QuoteDetailID`, `Quantity`, `Price`, `Quotes_QuoteID`, `Products_ProductID`) VALUES (18, 3, 950.00, 9, 218);
1310INSERT INTO `mydb`.`QuoteDetails` (`QuoteDetailID`, `Quantity`, `Price`, `Quotes_QuoteID`, `Products_ProductID`) VALUES (19, 1, 1000.00, 10, 219);
1311INSERT INTO `mydb`.`QuoteDetails` (`QuoteDetailID`, `Quantity`, `Price`, `Quotes_QuoteID`, `Products_ProductID`) VALUES (20, 4, 1050.00, 10, 220);
1312INSERT INTO `mydb`.`QuoteDetails` (`QuoteDetailID`, `Quantity`, `Price`, `Quotes_QuoteID`, `Products_ProductID`) VALUES (21, 2, 1100.00, 11, 221);
1313INSERT INTO `mydb`.`QuoteDetails` (`QuoteDetailID`, `Quantity`, `Price`, `Quotes_QuoteID`, `Products_ProductID`) VALUES (22, 3, 1150.00, 11, 222);
1314INSERT INTO `mydb`.`QuoteDetails` (`QuoteDetailID`, `Quantity`, `Price`, `Quotes_QuoteID`, `Products_ProductID`) VALUES (23, 1, 1200.00, 12, 223);
1315INSERT INTO `mydb`.`QuoteDetails` (`QuoteDetailID`, `Quantity`, `Price`, `Quotes_QuoteID`, `Products_ProductID`) VALUES (24, 4, 1250.00, 12, 224);
1316INSERT INTO `mydb`.`QuoteDetails` (`QuoteDetailID`, `Quantity`, `Price`, `Quotes_QuoteID`, `Products_ProductID`) VALUES (25, 2, 1300.00, 13, 225);
1317INSERT INTO `mydb`.`QuoteDetails` (`QuoteDetailID`, `Quantity`, `Price`, `Quotes_QuoteID`, `Products_ProductID`) VALUES (26, 3, 1350.00, 13, 226);
1318INSERT INTO `mydb`.`QuoteDetails` (`QuoteDetailID`, `Quantity`, `Price`, `Quotes_QuoteID`, `Products_ProductID`) VALUES (27, 1, 1400.00, 14, 227);
1319INSERT INTO `mydb`.`QuoteDetails` (`QuoteDetailID`, `Quantity`, `Price`, `Quotes_QuoteID`, `Products_ProductID`) VALUES (28, 4, 1450.00, 14, 228);
1320INSERT INTO `mydb`.`QuoteDetails` (`QuoteDetailID`, `Quantity`, `Price`, `Quotes_QuoteID`, `Products_ProductID`) VALUES (29, 2, 1500.00, 15, 229);
1321INSERT INTO `mydb`.`QuoteDetails` (`QuoteDetailID`, `Quantity`, `Price`, `Quotes_QuoteID`, `Products_ProductID`) VALUES (30, 3, 1550.00, 15, 230);
1322INSERT INTO `mydb`.`QuoteDetails` (`QuoteDetailID`, `Quantity`, `Price`, `Quotes_QuoteID`, `Products_ProductID`) VALUES (31, 1, 1600.00, 16, 231);
1323INSERT INTO `mydb`.`QuoteDetails` (`QuoteDetailID`, `Quantity`, `Price`, `Quotes_QuoteID`, `Products_ProductID`) VALUES (32, 4, 1650.00, 16, 232);
1324INSERT INTO `mydb`.`QuoteDetails` (`QuoteDetailID`, `Quantity`, `Price`, `Quotes_QuoteID`, `Products_ProductID`) VALUES (33, 2, 1700.00, 17, 233);
1325INSERT INTO `mydb`.`QuoteDetails` (`QuoteDetailID`, `Quantity`, `Price`, `Quotes_QuoteID`, `Products_ProductID`) VALUES (34, 3, 1750.00, 17, 234);
1326INSERT INTO `mydb`.`QuoteDetails` (`QuoteDetailID`, `Quantity`, `Price`, `Quotes_QuoteID`, `Products_ProductID`) VALUES (35, 1, 1800.00, 18, 235);
1327INSERT INTO `mydb`.`QuoteDetails` (`QuoteDetailID`, `Quantity`, `Price`, `Quotes_QuoteID`, `Products_ProductID`) VALUES (36, 4, 1850.00, 18, 236);
1328INSERT INTO `mydb`.`QuoteDetails` (`QuoteDetailID`, `Quantity`, `Price`, `Quotes_QuoteID`, `Products_ProductID`) VALUES (37, 2, 1900.00, 19, 237);
1329INSERT INTO `mydb`.`QuoteDetails` (`QuoteDetailID`, `Quantity`, `Price`, `Quotes_QuoteID`, `Products_ProductID`) VALUES (38, 3, 1950.00, 19, 238);
1330INSERT INTO `mydb`.`QuoteDetails` (`QuoteDetailID`, `Quantity`, `Price`, `Quotes_QuoteID`, `Products_ProductID`) VALUES (39, 1, 2000.00, 20, 239);
1331INSERT INTO `mydb`.`QuoteDetails` (`QuoteDetailID`, `Quantity`, `Price`, `Quotes_QuoteID`, `Products_ProductID`) VALUES (40, 4, 2050.00, 20, 240);
1332INSERT INTO `mydb`.`QuoteDetails` (`QuoteDetailID`, `Quantity`, `Price`, `Quotes_QuoteID`, `Products_ProductID`) VALUES (41, 2, 2100.00, 21, 241);
1333INSERT INTO `mydb`.`QuoteDetails` (`QuoteDetailID`, `Quantity`, `Price`, `Quotes_QuoteID`, `Products_ProductID`) VALUES (42, 3, 2150.00, 21, 242);
1334INSERT INTO `mydb`.`QuoteDetails` (`QuoteDetailID`, `Quantity`, `Price`, `Quotes_QuoteID`, `Products_ProductID`) VALUES (43, 1, 2200.00, 22, 243);
1335INSERT INTO `mydb`.`QuoteDetails` (`QuoteDetailID`, `Quantity`, `Price`, `Quotes_QuoteID`, `Products_ProductID`) VALUES (44, 4, 2250.00, 22, 244);
1336INSERT INTO `mydb`.`QuoteDetails` (`QuoteDetailID`, `Quantity`, `Price`, `Quotes_QuoteID`, `Products_ProductID`) VALUES (45, 2, 2300.00, 23, 245);
1337INSERT INTO `mydb`.`QuoteDetails` (`QuoteDetailID`, `Quantity`, `Price`, `Quotes_QuoteID`, `Products_ProductID`) VALUES (46, 3, 2350.00, 23, 246);
1338INSERT INTO `mydb`.`QuoteDetails` (`QuoteDetailID`, `Quantity`, `Price`, `Quotes_QuoteID`, `Products_ProductID`) VALUES (47, 1, 2400.00, 24, 247);
1339INSERT INTO `mydb`.`QuoteDetails` (`QuoteDetailID`, `Quantity`, `Price`, `Quotes_QuoteID`, `Products_ProductID`) VALUES (48, 4, 2450.00, 24, 248);
1340INSERT INTO `mydb`.`QuoteDetails` (`QuoteDetailID`, `Quantity`, `Price`, `Quotes_QuoteID`, `Products_ProductID`) VALUES (49, 2, 2500.00, 25, 249);
1341INSERT INTO `mydb`.`QuoteDetails` (`QuoteDetailID`, `Quantity`, `Price`, `Quotes_QuoteID`, `Products_ProductID`) VALUES (50, 3, 2550.00, 25, 250);
1342
1343COMMIT;
1344
1345
1346-- -----------------------------------------------------
1347-- Data for table `mydb`.`ProductionOrders`
1348-- -----------------------------------------------------
1349START TRANSACTION;
1350USE `mydb`;
1351INSERT INTO `mydb`.`ProductionOrders` (`ProductionOrderID`, `StartDate`, `EndDate`, `Status`) VALUES (1, '2023-01-05 08:00:00', '2023-01-06 16:00:00', 'In Progress');
1352INSERT INTO `mydb`.`ProductionOrders` (`ProductionOrderID`, `StartDate`, `EndDate`, `Status`) VALUES (2, '2023-01-07 09:00:00', '2023-01-08 17:00:00', 'Completed');
1353INSERT INTO `mydb`.`ProductionOrders` (`ProductionOrderID`, `StartDate`, `EndDate`, `Status`) VALUES (3, '2023-01-09 10:00:00', '2023-01-10 18:00:00', 'In Progress');
1354INSERT INTO `mydb`.`ProductionOrders` (`ProductionOrderID`, `StartDate`, `EndDate`, `Status`) VALUES (4, '2023-01-11 11:00:00', '2023-01-12 19:00:00', 'Completed');
1355INSERT INTO `mydb`.`ProductionOrders` (`ProductionOrderID`, `StartDate`, `EndDate`, `Status`) VALUES (5, '2023-01-13 12:00:00', '2023-01-14 20:00:00', 'In Progress');
1356INSERT INTO `mydb`.`ProductionOrders` (`ProductionOrderID`, `StartDate`, `EndDate`, `Status`) VALUES (6, '2023-01-15 13:00:00', '2023-01-16 21:00:00', 'Completed');
1357INSERT INTO `mydb`.`ProductionOrders` (`ProductionOrderID`, `StartDate`, `EndDate`, `Status`) VALUES (7, '2023-01-17 14:00:00', '2023-01-18 22:00:00', 'In Progress');
1358INSERT INTO `mydb`.`ProductionOrders` (`ProductionOrderID`, `StartDate`, `EndDate`, `Status`) VALUES (8, '2023-01-19 15:00:00', '2023-01-20 23:00:00', 'Completed');
1359INSERT INTO `mydb`.`ProductionOrders` (`ProductionOrderID`, `StartDate`, `EndDate`, `Status`) VALUES (9, '2023-01-21 16:00:00', '2023-01-22 00:00:00', 'In Progress');
1360INSERT INTO `mydb`.`ProductionOrders` (`ProductionOrderID`, `StartDate`, `EndDate`, `Status`) VALUES (10, '2023-01-23 17:00:00', '2023-01-24 01:00:00', 'Completed');
1361
1362COMMIT;
1363
1364
1365-- -----------------------------------------------------
1366-- Data for table `mydb`.`ProductionSteps`
1367-- -----------------------------------------------------
1368START TRANSACTION;
1369USE `mydb`;
1370INSERT INTO `mydb`.`ProductionSteps` (`StepID`, `StepName`, `Description`) VALUES (1, 'Cutting', 'Cutting glass and frames to required sizes');
1371INSERT INTO `mydb`.`ProductionSteps` (`StepID`, `StepName`, `Description`) VALUES (2, 'Assembly', 'Assembling the frame and installing glass panels');
1372INSERT INTO `mydb`.`ProductionSteps` (`StepID`, `StepName`, `Description`) VALUES (3, 'Sealing', 'Applying sealant and ensuring airtightness');
1373INSERT INTO `mydb`.`ProductionSteps` (`StepID`, `StepName`, `Description`) VALUES (4, 'Finishing', 'Final inspection and quality control');
1374INSERT INTO `mydb`.`ProductionSteps` (`StepID`, `StepName`, `Description`) VALUES (5, 'Packaging', 'Packaging the finished product for delivery');
1375
1376COMMIT;
1377
1378
1379-- -----------------------------------------------------
1380-- Data for table `mydb`.`ProductionOrderSteps`
1381-- -----------------------------------------------------
1382START TRANSACTION;
1383USE `mydb`;
1384INSERT INTO `mydb`.`ProductionOrderSteps` (`OrderStepID`, `Status`, `ProductionSteps_StepID`, `ProductionOrders_ProductionOrderID`) VALUES (1, 'In Progress', 1, 1);
1385INSERT INTO `mydb`.`ProductionOrderSteps` (`OrderStepID`, `Status`, `ProductionSteps_StepID`, `ProductionOrders_ProductionOrderID`) VALUES (2, 'Completed', 2, 1);
1386INSERT INTO `mydb`.`ProductionOrderSteps` (`OrderStepID`, `Status`, `ProductionSteps_StepID`, `ProductionOrders_ProductionOrderID`) VALUES (3, 'In Progress', 3, 2);
1387INSERT INTO `mydb`.`ProductionOrderSteps` (`OrderStepID`, `Status`, `ProductionSteps_StepID`, `ProductionOrders_ProductionOrderID`) VALUES (4, 'Completed', 4, 2);
1388INSERT INTO `mydb`.`ProductionOrderSteps` (`OrderStepID`, `Status`, `ProductionSteps_StepID`, `ProductionOrders_ProductionOrderID`) VALUES (5, 'In Progress', 5, 3);
1389INSERT INTO `mydb`.`ProductionOrderSteps` (`OrderStepID`, `Status`, `ProductionSteps_StepID`, `ProductionOrders_ProductionOrderID`) VALUES (6, 'Completed', 1, 3);
1390INSERT INTO `mydb`.`ProductionOrderSteps` (`OrderStepID`, `Status`, `ProductionSteps_StepID`, `ProductionOrders_ProductionOrderID`) VALUES (7, 'In Progress', 2, 4);
1391INSERT INTO `mydb`.`ProductionOrderSteps` (`OrderStepID`, `Status`, `ProductionSteps_StepID`, `ProductionOrders_ProductionOrderID`) VALUES (8, 'Completed', 3, 4);
1392INSERT INTO `mydb`.`ProductionOrderSteps` (`OrderStepID`, `Status`, `ProductionSteps_StepID`, `ProductionOrders_ProductionOrderID`) VALUES (9, 'In Progress', 4, 5);
1393INSERT INTO `mydb`.`ProductionOrderSteps` (`OrderStepID`, `Status`, `ProductionSteps_StepID`, `ProductionOrders_ProductionOrderID`) VALUES (10, 'Completed', 5, 5);
1394INSERT INTO `mydb`.`ProductionOrderSteps` (`OrderStepID`, `Status`, `ProductionSteps_StepID`, `ProductionOrders_ProductionOrderID`) VALUES (11, 'In Progress', 1, 6);
1395INSERT INTO `mydb`.`ProductionOrderSteps` (`OrderStepID`, `Status`, `ProductionSteps_StepID`, `ProductionOrders_ProductionOrderID`) VALUES (12, 'Completed', 2, 6);
1396INSERT INTO `mydb`.`ProductionOrderSteps` (`OrderStepID`, `Status`, `ProductionSteps_StepID`, `ProductionOrders_ProductionOrderID`) VALUES (13, 'In Progress', 3, 7);
1397INSERT INTO `mydb`.`ProductionOrderSteps` (`OrderStepID`, `Status`, `ProductionSteps_StepID`, `ProductionOrders_ProductionOrderID`) VALUES (14, 'Completed', 4, 7);
1398INSERT INTO `mydb`.`ProductionOrderSteps` (`OrderStepID`, `Status`, `ProductionSteps_StepID`, `ProductionOrders_ProductionOrderID`) VALUES (15, 'In Progress', 5, 8);
1399INSERT INTO `mydb`.`ProductionOrderSteps` (`OrderStepID`, `Status`, `ProductionSteps_StepID`, `ProductionOrders_ProductionOrderID`) VALUES (16, 'Completed', 1, 8);
1400INSERT INTO `mydb`.`ProductionOrderSteps` (`OrderStepID`, `Status`, `ProductionSteps_StepID`, `ProductionOrders_ProductionOrderID`) VALUES (17, 'In Progress', 2, 9);
1401INSERT INTO `mydb`.`ProductionOrderSteps` (`OrderStepID`, `Status`, `ProductionSteps_StepID`, `ProductionOrders_ProductionOrderID`) VALUES (18, 'Completed', 3, 9);
1402INSERT INTO `mydb`.`ProductionOrderSteps` (`OrderStepID`, `Status`, `ProductionSteps_StepID`, `ProductionOrders_ProductionOrderID`) VALUES (19, 'In Progress', 4, 10);
1403INSERT INTO `mydb`.`ProductionOrderSteps` (`OrderStepID`, `Status`, `ProductionSteps_StepID`, `ProductionOrders_ProductionOrderID`) VALUES (20, 'Completed', 5, 10);
1404
1405COMMIT;
1406
1407
1408-- -----------------------------------------------------
1409-- Data for table `mydb`.`Materials`
1410-- -----------------------------------------------------
1411START TRANSACTION;
1412USE `mydb`;
1413INSERT INTO `mydb`.`Materials` (`MaterialID`, `Name`, `UnitOfMeasure`, `PricePerUnit`) VALUES (101, 'Glass', 'Square Meter', 50.00);
1414INSERT INTO `mydb`.`Materials` (`MaterialID`, `Name`, `UnitOfMeasure`, `PricePerUnit`) VALUES (102, 'Frame', 'Piece', 30.00);
1415INSERT INTO `mydb`.`Materials` (`MaterialID`, `Name`, `UnitOfMeasure`, `PricePerUnit`) VALUES (103, 'Sealant', 'Meter', 10.00);
1416INSERT INTO `mydb`.`Materials` (`MaterialID`, `Name`, `UnitOfMeasure`, `PricePerUnit`) VALUES (104, 'Hardware Set', 'Piece', 25.00);
1417INSERT INTO `mydb`.`Materials` (`MaterialID`, `Name`, `UnitOfMeasure`, `PricePerUnit`) VALUES (105, 'Adhesive', 'Liter', 15.00);
1418INSERT INTO `mydb`.`Materials` (`MaterialID`, `Name`, `UnitOfMeasure`, `PricePerUnit`) VALUES (106, 'Insulating Film', 'Square Meter', 20.00);
1419INSERT INTO `mydb`.`Materials` (`MaterialID`, `Name`, `UnitOfMeasure`, `PricePerUnit`) VALUES (107, 'Spacer', 'Piece', 5.00);
1420INSERT INTO `mydb`.`Materials` (`MaterialID`, `Name`, `UnitOfMeasure`, `PricePerUnit`) VALUES (108, 'Paint', 'Liter', 35.00);
1421INSERT INTO `mydb`.`Materials` (`MaterialID`, `Name`, `UnitOfMeasure`, `PricePerUnit`) VALUES (109, 'Protective Coating', 'Square Meter', 12.00);
1422INSERT INTO `mydb`.`Materials` (`MaterialID`, `Name`, `UnitOfMeasure`, `PricePerUnit`) VALUES (110, 'Corner Key', 'Piece', 3.00);
1423INSERT INTO `mydb`.`Materials` (`MaterialID`, `Name`, `UnitOfMeasure`, `PricePerUnit`) VALUES (111, 'Drainage System', 'Piece', 40.00);
1424INSERT INTO `mydb`.`Materials` (`MaterialID`, `Name`, `UnitOfMeasure`, `PricePerUnit`) VALUES (112, 'Mounting Tape', 'Roll', 8.00);
1425INSERT INTO `mydb`.`Materials` (`MaterialID`, `Name`, `UnitOfMeasure`, `PricePerUnit`) VALUES (113, 'Gasket', 'Meter', 7.00);
1426INSERT INTO `mydb`.`Materials` (`MaterialID`, `Name`, `UnitOfMeasure`, `PricePerUnit`) VALUES (114, 'Reinforcement Profile', 'Piece', 18.00);
1427INSERT INTO `mydb`.`Materials` (`MaterialID`, `Name`, `UnitOfMeasure`, `PricePerUnit`) VALUES (115, 'Thermal Insulation', 'Square Meter', 22.00);
1428INSERT INTO `mydb`.`Materials` (`MaterialID`, `Name`, `UnitOfMeasure`, `PricePerUnit`) VALUES (116, 'Soundproofing Material', 'Square Meter', 25.00);
1429INSERT INTO `mydb`.`Materials` (`MaterialID`, `Name`, `UnitOfMeasure`, `PricePerUnit`) VALUES (117, 'UV Protection Film', 'Square Meter', 18.00);
1430INSERT INTO `mydb`.`Materials` (`MaterialID`, `Name`, `UnitOfMeasure`, `PricePerUnit`) VALUES (118, 'Structural Glue', 'Tube', 12.00);
1431INSERT INTO `mydb`.`Materials` (`MaterialID`, `Name`, `UnitOfMeasure`, `PricePerUnit`) VALUES (119, 'Window Handle', 'Piece', 10.00);
1432INSERT INTO `mydb`.`Materials` (`MaterialID`, `Name`, `UnitOfMeasure`, `PricePerUnit`) VALUES (120, 'Locking Mechanism', 'Piece', 30.00);
1433INSERT INTO `mydb`.`Materials` (`MaterialID`, `Name`, `UnitOfMeasure`, `PricePerUnit`) VALUES (121, 'Hinge', 'Piece', 15.00);
1434INSERT INTO `mydb`.`Materials` (`MaterialID`, `Name`, `UnitOfMeasure`, `PricePerUnit`) VALUES (122, 'Weatherproof Seal', 'Meter', 9.00);
1435INSERT INTO `mydb`.`Materials` (`MaterialID`, `Name`, `UnitOfMeasure`, `PricePerUnit`) VALUES (123, 'Decorative Strip', 'Meter', 6.00);
1436INSERT INTO `mydb`.`Materials` (`MaterialID`, `Name`, `UnitOfMeasure`, `PricePerUnit`) VALUES (124, 'Glazing Bead', 'Piece', 4.00);
1437INSERT INTO `mydb`.`Materials` (`MaterialID`, `Name`, `UnitOfMeasure`, `PricePerUnit`) VALUES (125, 'Aluminum Profile', 'Piece', 45.00);
1438INSERT INTO `mydb`.`Materials` (`MaterialID`, `Name`, `UnitOfMeasure`, `PricePerUnit`) VALUES (126, 'PVC Profile', 'Piece', 35.00);
1439INSERT INTO `mydb`.`Materials` (`MaterialID`, `Name`, `UnitOfMeasure`, `PricePerUnit`) VALUES (127, 'Steel Reinforcement', 'Piece', 50.00);
1440INSERT INTO `mydb`.`Materials` (`MaterialID`, `Name`, `UnitOfMeasure`, `PricePerUnit`) VALUES (128, 'Composite Panel', 'Square Meter', 60.00);
1441INSERT INTO `mydb`.`Materials` (`MaterialID`, `Name`, `UnitOfMeasure`, `PricePerUnit`) VALUES (129, 'Acoustic Membrane', 'Square Meter', 30.00);
1442INSERT INTO `mydb`.`Materials` (`MaterialID`, `Name`, `UnitOfMeasure`, `PricePerUnit`) VALUES (130, 'Solar Control Film', 'Square Meter', 28.00);
1443INSERT INTO `mydb`.`Materials` (`MaterialID`, `Name`, `UnitOfMeasure`, `PricePerUnit`) VALUES (131, 'Low Iron Glass', 'Square Meter', 65.00);
1444INSERT INTO `mydb`.`Materials` (`MaterialID`, `Name`, `UnitOfMeasure`, `PricePerUnit`) VALUES (132, 'Tinted Glass', 'Square Meter', 70.00);
1445INSERT INTO `mydb`.`Materials` (`MaterialID`, `Name`, `UnitOfMeasure`, `PricePerUnit`) VALUES (133, 'Reflective Glass', 'Square Meter', 75.00);
1446INSERT INTO `mydb`.`Materials` (`MaterialID`, `Name`, `UnitOfMeasure`, `PricePerUnit`) VALUES (134, 'Heat Strengthened Glass', 'Square Meter', 80.00);
1447INSERT INTO `mydb`.`Materials` (`MaterialID`, `Name`, `UnitOfMeasure`, `PricePerUnit`) VALUES (135, 'Vacuum Insulated Glass', 'Square Meter', 100.00);
1448INSERT INTO `mydb`.`Materials` (`MaterialID`, `Name`, `UnitOfMeasure`, `PricePerUnit`) VALUES (136, 'Electric Motor', 'Piece', 120.00);
1449INSERT INTO `mydb`.`Materials` (`MaterialID`, `Name`, `UnitOfMeasure`, `PricePerUnit`) VALUES (137, 'Awning Mechanism', 'Piece', 90.00);
1450INSERT INTO `mydb`.`Materials` (`MaterialID`, `Name`, `UnitOfMeasure`, `PricePerUnit`) VALUES (138, 'Sliding Track', 'Meter', 25.00);
1451INSERT INTO `mydb`.`Materials` (`MaterialID`, `Name`, `UnitOfMeasure`, `PricePerUnit`) VALUES (139, 'Noise Reduction Film', 'Square Meter', 30.00);
1452INSERT INTO `mydb`.`Materials` (`MaterialID`, `Name`, `UnitOfMeasure`, `PricePerUnit`) VALUES (140, 'Energy Efficient Film', 'Square Meter', 35.00);
1453INSERT INTO `mydb`.`Materials` (`MaterialID`, `Name`, `UnitOfMeasure`, `PricePerUnit`) VALUES (141, 'Glass Reinforcement Rod', 'Meter', 15.00);
1454INSERT INTO `mydb`.`Materials` (`MaterialID`, `Name`, `UnitOfMeasure`, `PricePerUnit`) VALUES (142, 'Structural Silicone', 'Tube', 20.00);
1455INSERT INTO `mydb`.`Materials` (`MaterialID`, `Name`, `UnitOfMeasure`, `PricePerUnit`) VALUES (143, 'Glass Finishing Strip', 'Meter', 10.00);
1456INSERT INTO `mydb`.`Materials` (`MaterialID`, `Name`, `UnitOfMeasure`, `PricePerUnit`) VALUES (144, 'Glass Spacer Bar', 'Piece', 5.00);
1457INSERT INTO `mydb`.`Materials` (`MaterialID`, `Name`, `UnitOfMeasure`, `PricePerUnit`) VALUES (145, 'Glass Edge Protector', 'Piece', 8.00);
1458INSERT INTO `mydb`.`Materials` (`MaterialID`, `Name`, `UnitOfMeasure`, `PricePerUnit`) VALUES (146, 'Glass Cleaning Solution', 'Liter', 12.00);
1459INSERT INTO `mydb`.`Materials` (`MaterialID`, `Name`, `UnitOfMeasure`, `PricePerUnit`) VALUES (147, 'Glass Polishing Compound', 'Kilogram', 25.00);
1460INSERT INTO `mydb`.`Materials` (`MaterialID`, `Name`, `UnitOfMeasure`, `PricePerUnit`) VALUES (148, 'Glass Cutting Wheel', 'Piece', 20.00);
1461INSERT INTO `mydb`.`Materials` (`MaterialID`, `Name`, `UnitOfMeasure`, `PricePerUnit`) VALUES (149, 'Glass Drilling Bit', 'Piece', 30.00);
1462INSERT INTO `mydb`.`Materials` (`MaterialID`, `Name`, `UnitOfMeasure`, `PricePerUnit`) VALUES (150, 'Glass Clamps', 'Piece', 18.00);
1463
1464COMMIT;
1465
1466
1467-- -----------------------------------------------------
1468-- Data for table `mydb`.`MaterialUsage`
1469-- -----------------------------------------------------
1470START TRANSACTION;
1471USE `mydb`;
1472INSERT INTO `mydb`.`MaterialUsage` (`UsageID`, `Quantity`, `Materials_MaterialID`, `Orders_OrderID`) VALUES (1, 5, 101, 1);
1473INSERT INTO `mydb`.`MaterialUsage` (`UsageID`, `Quantity`, `Materials_MaterialID`, `Orders_OrderID`) VALUES (2, 10, 102, 2);
1474INSERT INTO `mydb`.`MaterialUsage` (`UsageID`, `Quantity`, `Materials_MaterialID`, `Orders_OrderID`) VALUES (3, 3, 103, 3);
1475INSERT INTO `mydb`.`MaterialUsage` (`UsageID`, `Quantity`, `Materials_MaterialID`, `Orders_OrderID`) VALUES (4, 7, 104, 4);
1476INSERT INTO `mydb`.`MaterialUsage` (`UsageID`, `Quantity`, `Materials_MaterialID`, `Orders_OrderID`) VALUES (5, 2, 105, 5);
1477INSERT INTO `mydb`.`MaterialUsage` (`UsageID`, `Quantity`, `Materials_MaterialID`, `Orders_OrderID`) VALUES (6, 8, 106, 6);
1478INSERT INTO `mydb`.`MaterialUsage` (`UsageID`, `Quantity`, `Materials_MaterialID`, `Orders_OrderID`) VALUES (7, 4, 107, 7);
1479INSERT INTO `mydb`.`MaterialUsage` (`UsageID`, `Quantity`, `Materials_MaterialID`, `Orders_OrderID`) VALUES (8, 6, 108, 8);
1480INSERT INTO `mydb`.`MaterialUsage` (`UsageID`, `Quantity`, `Materials_MaterialID`, `Orders_OrderID`) VALUES (9, 5, 109, 9);
1481INSERT INTO `mydb`.`MaterialUsage` (`UsageID`, `Quantity`, `Materials_MaterialID`, `Orders_OrderID`) VALUES (10, 9, 110, 10);
1482INSERT INTO `mydb`.`MaterialUsage` (`UsageID`, `Quantity`, `Materials_MaterialID`, `Orders_OrderID`) VALUES (11, 3, 111, 11);
1483INSERT INTO `mydb`.`MaterialUsage` (`UsageID`, `Quantity`, `Materials_MaterialID`, `Orders_OrderID`) VALUES (12, 7, 112, 12);
1484INSERT INTO `mydb`.`MaterialUsage` (`UsageID`, `Quantity`, `Materials_MaterialID`, `Orders_OrderID`) VALUES (13, 2, 113, 13);
1485INSERT INTO `mydb`.`MaterialUsage` (`UsageID`, `Quantity`, `Materials_MaterialID`, `Orders_OrderID`) VALUES (14, 8, 114, 14);
1486INSERT INTO `mydb`.`MaterialUsage` (`UsageID`, `Quantity`, `Materials_MaterialID`, `Orders_OrderID`) VALUES (15, 4, 115, 15);
1487INSERT INTO `mydb`.`MaterialUsage` (`UsageID`, `Quantity`, `Materials_MaterialID`, `Orders_OrderID`) VALUES (16, 6, 116, 16);
1488INSERT INTO `mydb`.`MaterialUsage` (`UsageID`, `Quantity`, `Materials_MaterialID`, `Orders_OrderID`) VALUES (17, 5, 117, 17);
1489INSERT INTO `mydb`.`MaterialUsage` (`UsageID`, `Quantity`, `Materials_MaterialID`, `Orders_OrderID`) VALUES (18, 9, 118, 18);
1490INSERT INTO `mydb`.`MaterialUsage` (`UsageID`, `Quantity`, `Materials_MaterialID`, `Orders_OrderID`) VALUES (19, 3, 119, 19);
1491INSERT INTO `mydb`.`MaterialUsage` (`UsageID`, `Quantity`, `Materials_MaterialID`, `Orders_OrderID`) VALUES (20, 7, 120, 20);
1492INSERT INTO `mydb`.`MaterialUsage` (`UsageID`, `Quantity`, `Materials_MaterialID`, `Orders_OrderID`) VALUES (21, 2, 121, 21);
1493INSERT INTO `mydb`.`MaterialUsage` (`UsageID`, `Quantity`, `Materials_MaterialID`, `Orders_OrderID`) VALUES (22, 8, 122, 22);
1494INSERT INTO `mydb`.`MaterialUsage` (`UsageID`, `Quantity`, `Materials_MaterialID`, `Orders_OrderID`) VALUES (23, 4, 123, 23);
1495INSERT INTO `mydb`.`MaterialUsage` (`UsageID`, `Quantity`, `Materials_MaterialID`, `Orders_OrderID`) VALUES (24, 6, 124, 24);
1496INSERT INTO `mydb`.`MaterialUsage` (`UsageID`, `Quantity`, `Materials_MaterialID`, `Orders_OrderID`) VALUES (25, 5, 125, 25);
1497INSERT INTO `mydb`.`MaterialUsage` (`UsageID`, `Quantity`, `Materials_MaterialID`, `Orders_OrderID`) VALUES (26, 9, 126, 26);
1498INSERT INTO `mydb`.`MaterialUsage` (`UsageID`, `Quantity`, `Materials_MaterialID`, `Orders_OrderID`) VALUES (27, 3, 127, 27);
1499INSERT INTO `mydb`.`MaterialUsage` (`UsageID`, `Quantity`, `Materials_MaterialID`, `Orders_OrderID`) VALUES (28, 7, 128, 28);
1500INSERT INTO `mydb`.`MaterialUsage` (`UsageID`, `Quantity`, `Materials_MaterialID`, `Orders_OrderID`) VALUES (29, 2, 129, 29);
1501INSERT INTO `mydb`.`MaterialUsage` (`UsageID`, `Quantity`, `Materials_MaterialID`, `Orders_OrderID`) VALUES (30, 8, 130, 30);
1502INSERT INTO `mydb`.`MaterialUsage` (`UsageID`, `Quantity`, `Materials_MaterialID`, `Orders_OrderID`) VALUES (31, 4, 101, 31);
1503INSERT INTO `mydb`.`MaterialUsage` (`UsageID`, `Quantity`, `Materials_MaterialID`, `Orders_OrderID`) VALUES (32, 6, 102, 32);
1504INSERT INTO `mydb`.`MaterialUsage` (`UsageID`, `Quantity`, `Materials_MaterialID`, `Orders_OrderID`) VALUES (33, 5, 103, 33);
1505INSERT INTO `mydb`.`MaterialUsage` (`UsageID`, `Quantity`, `Materials_MaterialID`, `Orders_OrderID`) VALUES (34, 9, 104, 34);
1506INSERT INTO `mydb`.`MaterialUsage` (`UsageID`, `Quantity`, `Materials_MaterialID`, `Orders_OrderID`) VALUES (35, 3, 105, 35);
1507INSERT INTO `mydb`.`MaterialUsage` (`UsageID`, `Quantity`, `Materials_MaterialID`, `Orders_OrderID`) VALUES (36, 7, 106, 36);
1508INSERT INTO `mydb`.`MaterialUsage` (`UsageID`, `Quantity`, `Materials_MaterialID`, `Orders_OrderID`) VALUES (37, 2, 107, 37);
1509INSERT INTO `mydb`.`MaterialUsage` (`UsageID`, `Quantity`, `Materials_MaterialID`, `Orders_OrderID`) VALUES (38, 8, 108, 38);
1510INSERT INTO `mydb`.`MaterialUsage` (`UsageID`, `Quantity`, `Materials_MaterialID`, `Orders_OrderID`) VALUES (39, 4, 109, 39);
1511INSERT INTO `mydb`.`MaterialUsage` (`UsageID`, `Quantity`, `Materials_MaterialID`, `Orders_OrderID`) VALUES (40, 6, 110, 40);
1512INSERT INTO `mydb`.`MaterialUsage` (`UsageID`, `Quantity`, `Materials_MaterialID`, `Orders_OrderID`) VALUES (41, 5, 111, 41);
1513INSERT INTO `mydb`.`MaterialUsage` (`UsageID`, `Quantity`, `Materials_MaterialID`, `Orders_OrderID`) VALUES (42, 9, 112, 42);
1514INSERT INTO `mydb`.`MaterialUsage` (`UsageID`, `Quantity`, `Materials_MaterialID`, `Orders_OrderID`) VALUES (43, 3, 113, 43);
1515INSERT INTO `mydb`.`MaterialUsage` (`UsageID`, `Quantity`, `Materials_MaterialID`, `Orders_OrderID`) VALUES (44, 7, 114, 44);
1516INSERT INTO `mydb`.`MaterialUsage` (`UsageID`, `Quantity`, `Materials_MaterialID`, `Orders_OrderID`) VALUES (45, 2, 115, 45);
1517INSERT INTO `mydb`.`MaterialUsage` (`UsageID`, `Quantity`, `Materials_MaterialID`, `Orders_OrderID`) VALUES (46, 8, 116, 46);
1518INSERT INTO `mydb`.`MaterialUsage` (`UsageID`, `Quantity`, `Materials_MaterialID`, `Orders_OrderID`) VALUES (47, 4, 117, 47);
1519INSERT INTO `mydb`.`MaterialUsage` (`UsageID`, `Quantity`, `Materials_MaterialID`, `Orders_OrderID`) VALUES (48, 6, 118, 48);
1520INSERT INTO `mydb`.`MaterialUsage` (`UsageID`, `Quantity`, `Materials_MaterialID`, `Orders_OrderID`) VALUES (49, 5, 119, 49);
1521INSERT INTO `mydb`.`MaterialUsage` (`UsageID`, `Quantity`, `Materials_MaterialID`, `Orders_OrderID`) VALUES (50, 9, 120, 50);
1522
1523COMMIT;
1524
1525
1526-- -----------------------------------------------------
1527-- Data for table `mydb`.`Equipment`
1528-- -----------------------------------------------------
1529START TRANSACTION;
1530USE `mydb`;
1531INSERT INTO `mydb`.`Equipment` (`EquipmentID`, `Name`, `Model`, `PurchaseDate`, `Equipmentcol`) VALUES (1, 'Drilling Machine', 'DM-100', '2022-01-01 00:00:00', 'Red');
1532INSERT INTO `mydb`.`Equipment` (`EquipmentID`, `Name`, `Model`, `PurchaseDate`, `Equipmentcol`) VALUES (2, 'Cutting Machine', 'CM-200', '2022-02-01 00:00:00', 'Blue');
1533INSERT INTO `mydb`.`Equipment` (`EquipmentID`, `Name`, `Model`, `PurchaseDate`, `Equipmentcol`) VALUES (3, 'Sealing Machine', 'SM-300', '2022-03-01 00:00:00', 'Green');
1534INSERT INTO `mydb`.`Equipment` (`EquipmentID`, `Name`, `Model`, `PurchaseDate`, `Equipmentcol`) VALUES (4, 'Assembly Line', 'AL-400', '2022-04-01 00:00:00', 'Yellow');
1535INSERT INTO `mydb`.`Equipment` (`EquipmentID`, `Name`, `Model`, `PurchaseDate`, `Equipmentcol`) VALUES (5, 'Inspection Tool', 'IT-500', '2022-05-01 00:00:00', 'Orange');
1536
1537COMMIT;
1538
1539
1540-- -----------------------------------------------------
1541-- Data for table `mydb`.`EquipmentMaintenance`
1542-- -----------------------------------------------------
1543START TRANSACTION;
1544USE `mydb`;
1545INSERT INTO `mydb`.`EquipmentMaintenance` (`MaintenanceID`, `MaintenanceDate`, `Description`, `Equipment_EquipmentID`) VALUES (1, '2022-06-01 00:00:00', 'Routine check and oiling', 1);
1546INSERT INTO `mydb`.`EquipmentMaintenance` (`MaintenanceID`, `MaintenanceDate`, `Description`, `Equipment_EquipmentID`) VALUES (2, '2022-07-01 00:00:00', 'Belt replacement', 2);
1547INSERT INTO `mydb`.`EquipmentMaintenance` (`MaintenanceID`, `MaintenanceDate`, `Description`, `Equipment_EquipmentID`) VALUES (3, '2022-08-01 00:00:00', 'Sealant application', 3);
1548INSERT INTO `mydb`.`EquipmentMaintenance` (`MaintenanceID`, `MaintenanceDate`, `Description`, `Equipment_EquipmentID`) VALUES (4, '2022-09-01 00:00:00', 'Calibration', 4);
1549INSERT INTO `mydb`.`EquipmentMaintenance` (`MaintenanceID`, `MaintenanceDate`, `Description`, `Equipment_EquipmentID`) VALUES (5, '2022-10-01 00:00:00', 'Filter cleaning', 5);
1550
1551COMMIT;
1552
1553
1554-- -----------------------------------------------------
1555-- Data for table `mydb`.`Warehouses`
1556-- -----------------------------------------------------
1557START TRANSACTION;
1558USE `mydb`;
1559INSERT INTO `mydb`.`Warehouses` (`WarehouseID`, `Name`, `Address`) VALUES (1, 'Warehouse A', 'Lenina str.');
1560INSERT INTO `mydb`.`Warehouses` (`WarehouseID`, `Name`, `Address`) VALUES (2, 'Warehouse B', 'Moskovskiy pros. 34');
1561INSERT INTO `mydb`.`Warehouses` (`WarehouseID`, `Name`, `Address`) VALUES (3, 'Warehouse C', 'Pushkina str.');
1562INSERT INTO `mydb`.`Warehouses` (`WarehouseID`, `Name`, `Address`) VALUES (4, 'Warehouse D', 'Kalinina str.');
1563INSERT INTO `mydb`.`Warehouses` (`WarehouseID`, `Name`, `Address`) VALUES (5, 'Warehouse E', 'Chkalova str.');
1564INSERT INTO `mydb`.`Warehouses` (`WarehouseID`, `Name`, `Address`) VALUES (6, 'Warehouse F', 'Horkova str.');
1565INSERT INTO `mydb`.`Warehouses` (`WarehouseID`, `Name`, `Address`) VALUES (7, 'Warehouse G', 'Stroitelei str.');
1566INSERT INTO `mydb`.`Warehouses` (`WarehouseID`, `Name`, `Address`) VALUES (8, 'Warehouse H', 'Lugovaya str.');
1567INSERT INTO `mydb`.`Warehouses` (`WarehouseID`, `Name`, `Address`) VALUES (9, 'Warehouse I', 'Komsomoltcev str.');
1568INSERT INTO `mydb`.`Warehouses` (`WarehouseID`, `Name`, `Address`) VALUES (10, 'Warehouse J', 'Octyabrskaya str.');
1569
1570COMMIT;
1571
1572
1573-- -----------------------------------------------------
1574-- Data for table `mydb`.`Stocks`
1575-- -----------------------------------------------------
1576START TRANSACTION;
1577USE `mydb`;
1578INSERT INTO `mydb`.`Stocks` (`StockID`, `Quantity`, `Warehouses_WarehouseID`, `Materials_MaterialID`) VALUES (1, 100, 1, 101);
1579INSERT INTO `mydb`.`Stocks` (`StockID`, `Quantity`, `Warehouses_WarehouseID`, `Materials_MaterialID`) VALUES (2, 150, 1, 102);
1580INSERT INTO `mydb`.`Stocks` (`StockID`, `Quantity`, `Warehouses_WarehouseID`, `Materials_MaterialID`) VALUES (3, 200, 2, 103);
1581INSERT INTO `mydb`.`Stocks` (`StockID`, `Quantity`, `Warehouses_WarehouseID`, `Materials_MaterialID`) VALUES (4, 120, 2, 104);
1582INSERT INTO `mydb`.`Stocks` (`StockID`, `Quantity`, `Warehouses_WarehouseID`, `Materials_MaterialID`) VALUES (5, 80, 3, 105);
1583INSERT INTO `mydb`.`Stocks` (`StockID`, `Quantity`, `Warehouses_WarehouseID`, `Materials_MaterialID`) VALUES (6, 110, 3, 106);
1584INSERT INTO `mydb`.`Stocks` (`StockID`, `Quantity`, `Warehouses_WarehouseID`, `Materials_MaterialID`) VALUES (7, 90, 4, 107);
1585INSERT INTO `mydb`.`Stocks` (`StockID`, `Quantity`, `Warehouses_WarehouseID`, `Materials_MaterialID`) VALUES (8, 130, 4, 108);
1586INSERT INTO `mydb`.`Stocks` (`StockID`, `Quantity`, `Warehouses_WarehouseID`, `Materials_MaterialID`) VALUES (9, 140, 5, 109);
1587INSERT INTO `mydb`.`Stocks` (`StockID`, `Quantity`, `Warehouses_WarehouseID`, `Materials_MaterialID`) VALUES (10, 160, 5, 110);
1588INSERT INTO `mydb`.`Stocks` (`StockID`, `Quantity`, `Warehouses_WarehouseID`, `Materials_MaterialID`) VALUES (11, 170, 6, 111);
1589INSERT INTO `mydb`.`Stocks` (`StockID`, `Quantity`, `Warehouses_WarehouseID`, `Materials_MaterialID`) VALUES (12, 180, 6, 112);
1590INSERT INTO `mydb`.`Stocks` (`StockID`, `Quantity`, `Warehouses_WarehouseID`, `Materials_MaterialID`) VALUES (13, 190, 7, 113);
1591INSERT INTO `mydb`.`Stocks` (`StockID`, `Quantity`, `Warehouses_WarehouseID`, `Materials_MaterialID`) VALUES (14, 210, 7, 114);
1592INSERT INTO `mydb`.`Stocks` (`StockID`, `Quantity`, `Warehouses_WarehouseID`, `Materials_MaterialID`) VALUES (15, 220, 8, 115);
1593INSERT INTO `mydb`.`Stocks` (`StockID`, `Quantity`, `Warehouses_WarehouseID`, `Materials_MaterialID`) VALUES (16, 230, 8, 116);
1594INSERT INTO `mydb`.`Stocks` (`StockID`, `Quantity`, `Warehouses_WarehouseID`, `Materials_MaterialID`) VALUES (17, 240, 9, 117);
1595INSERT INTO `mydb`.`Stocks` (`StockID`, `Quantity`, `Warehouses_WarehouseID`, `Materials_MaterialID`) VALUES (18, 250, 9, 118);
1596INSERT INTO `mydb`.`Stocks` (`StockID`, `Quantity`, `Warehouses_WarehouseID`, `Materials_MaterialID`) VALUES (19, 260, 10, 119);
1597INSERT INTO `mydb`.`Stocks` (`StockID`, `Quantity`, `Warehouses_WarehouseID`, `Materials_MaterialID`) VALUES (20, 270, 10, 120);
1598INSERT INTO `mydb`.`Stocks` (`StockID`, `Quantity`, `Warehouses_WarehouseID`, `Materials_MaterialID`) VALUES (21, 280, 1, 121);
1599INSERT INTO `mydb`.`Stocks` (`StockID`, `Quantity`, `Warehouses_WarehouseID`, `Materials_MaterialID`) VALUES (22, 290, 1, 122);
1600INSERT INTO `mydb`.`Stocks` (`StockID`, `Quantity`, `Warehouses_WarehouseID`, `Materials_MaterialID`) VALUES (23, 300, 2, 123);
1601INSERT INTO `mydb`.`Stocks` (`StockID`, `Quantity`, `Warehouses_WarehouseID`, `Materials_MaterialID`) VALUES (24, 310, 2, 124);
1602INSERT INTO `mydb`.`Stocks` (`StockID`, `Quantity`, `Warehouses_WarehouseID`, `Materials_MaterialID`) VALUES (25, 320, 3, 125);
1603INSERT INTO `mydb`.`Stocks` (`StockID`, `Quantity`, `Warehouses_WarehouseID`, `Materials_MaterialID`) VALUES (26, 330, 3, 126);
1604INSERT INTO `mydb`.`Stocks` (`StockID`, `Quantity`, `Warehouses_WarehouseID`, `Materials_MaterialID`) VALUES (27, 340, 4, 127);
1605INSERT INTO `mydb`.`Stocks` (`StockID`, `Quantity`, `Warehouses_WarehouseID`, `Materials_MaterialID`) VALUES (28, 350, 4, 128);
1606INSERT INTO `mydb`.`Stocks` (`StockID`, `Quantity`, `Warehouses_WarehouseID`, `Materials_MaterialID`) VALUES (29, 360, 5, 129);
1607INSERT INTO `mydb`.`Stocks` (`StockID`, `Quantity`, `Warehouses_WarehouseID`, `Materials_MaterialID`) VALUES (30, 370, 5, 130);
1608INSERT INTO `mydb`.`Stocks` (`StockID`, `Quantity`, `Warehouses_WarehouseID`, `Materials_MaterialID`) VALUES (31, 380, 6, 131);
1609INSERT INTO `mydb`.`Stocks` (`StockID`, `Quantity`, `Warehouses_WarehouseID`, `Materials_MaterialID`) VALUES (32, 390, 6, 132);
1610INSERT INTO `mydb`.`Stocks` (`StockID`, `Quantity`, `Warehouses_WarehouseID`, `Materials_MaterialID`) VALUES (33, 400, 7, 133);
1611INSERT INTO `mydb`.`Stocks` (`StockID`, `Quantity`, `Warehouses_WarehouseID`, `Materials_MaterialID`) VALUES (34, 410, 7, 134);
1612INSERT INTO `mydb`.`Stocks` (`StockID`, `Quantity`, `Warehouses_WarehouseID`, `Materials_MaterialID`) VALUES (35, 420, 8, 135);
1613INSERT INTO `mydb`.`Stocks` (`StockID`, `Quantity`, `Warehouses_WarehouseID`, `Materials_MaterialID`) VALUES (36, 430, 8, 136);
1614INSERT INTO `mydb`.`Stocks` (`StockID`, `Quantity`, `Warehouses_WarehouseID`, `Materials_MaterialID`) VALUES (37, 440, 9, 137);
1615INSERT INTO `mydb`.`Stocks` (`StockID`, `Quantity`, `Warehouses_WarehouseID`, `Materials_MaterialID`) VALUES (38, 450, 9, 138);
1616INSERT INTO `mydb`.`Stocks` (`StockID`, `Quantity`, `Warehouses_WarehouseID`, `Materials_MaterialID`) VALUES (39, 460, 10, 139);
1617INSERT INTO `mydb`.`Stocks` (`StockID`, `Quantity`, `Warehouses_WarehouseID`, `Materials_MaterialID`) VALUES (40, 470, 10, 140);
1618INSERT INTO `mydb`.`Stocks` (`StockID`, `Quantity`, `Warehouses_WarehouseID`, `Materials_MaterialID`) VALUES (41, 480, 1, 141);
1619INSERT INTO `mydb`.`Stocks` (`StockID`, `Quantity`, `Warehouses_WarehouseID`, `Materials_MaterialID`) VALUES (42, 490, 1, 142);
1620INSERT INTO `mydb`.`Stocks` (`StockID`, `Quantity`, `Warehouses_WarehouseID`, `Materials_MaterialID`) VALUES (43, 500, 2, 143);
1621INSERT INTO `mydb`.`Stocks` (`StockID`, `Quantity`, `Warehouses_WarehouseID`, `Materials_MaterialID`) VALUES (44, 510, 2, 144);
1622INSERT INTO `mydb`.`Stocks` (`StockID`, `Quantity`, `Warehouses_WarehouseID`, `Materials_MaterialID`) VALUES (45, 520, 3, 145);
1623INSERT INTO `mydb`.`Stocks` (`StockID`, `Quantity`, `Warehouses_WarehouseID`, `Materials_MaterialID`) VALUES (46, 530, 3, 146);
1624INSERT INTO `mydb`.`Stocks` (`StockID`, `Quantity`, `Warehouses_WarehouseID`, `Materials_MaterialID`) VALUES (47, 540, 4, 147);
1625INSERT INTO `mydb`.`Stocks` (`StockID`, `Quantity`, `Warehouses_WarehouseID`, `Materials_MaterialID`) VALUES (48, 550, 4, 148);
1626INSERT INTO `mydb`.`Stocks` (`StockID`, `Quantity`, `Warehouses_WarehouseID`, `Materials_MaterialID`) VALUES (49, 560, 5, 149);
1627INSERT INTO `mydb`.`Stocks` (`StockID`, `Quantity`, `Warehouses_WarehouseID`, `Materials_MaterialID`) VALUES (50, 570, 5, 150);
1628
1629COMMIT;
1630
1631/*
1632-- -----------------------------------------------------
1633-- Data for table `mydb`.`StockMovements`
1634-- -----------------------------------------------------
1635START TRANSACTION;
1636
1637USE `mydb`;
1638
1639INSERT INTO `mydb`.`StockMovements` (`StockMovementsID`, `OperationType`, `Quantity`, `Materials_MaterialID`, `Warehouses_WarehouseID`)
1640VALUES
1641 (1, 'Приход', 10, 101, 1),
1642 (2, 'Расход', 15, 102, 1),
1643 (3, 'Приход', 20, 103, 2),
1644 (4, 'Расход', 12, 104, 2),
1645 (5, 'Приход', 8, 105, 3),
1646 (6, 'Расход', 11, 106, 3),
1647 (7, 'Приход', 9, 107, 4),
1648 (8, 'Расход', 13, 108, 4),
1649 (9, 'Приход', 14, 109, 5),
1650 (10, 'Расход', 16, 110, 5),
1651 (11, 'Приход', 17, 111, 6),
1652 (12, 'Расход', 18, 112, 6),
1653 (13, 'Приход', 19, 113, 7),
1654 (14, 'Расход', 21, 114, 7),
1655 (15, 'Приход', 22, 115, 8),
1656 (16, 'Расход', 23, 116, 8),
1657 (17, 'Приход', 24, 117, 9),
1658 (18, 'Расход', 25, 118, 9),
1659 (19, 'Приход', 26, 119, 10),
1660 (20, 'Расход', 27, 120, 10),
1661 (21, 'Приход', 28, 121, 1),
1662 (22, 'Расход', 29, 122, 1),
1663 (23, 'Приход', 30, 123, 2),
1664 (24, 'Расход', 31, 124, 2),
1665 (25, 'Приход', 32, 125, 3),
1666 (26, 'Расход', 33, 126, 3),
1667 (27, 'Приход', 34, 127, 4),
1668 (28, 'Расход', 35, 128, 4),
1669 (29, 'Приход', 36, 129, 5),
1670 (30, 'Расход', 37, 130, 5),
1671 (31, 'Приход', 38, 131, 6),
1672 (32, 'Расход', 39, 132, 6),
1673 (33, 'Приход', 40, 133, 7),
1674 (34, 'Расход', 41, 134, 7),
1675 (35, 'Приход', 42, 135, 8),
1676 (36, 'Расход', 43, 136, 8),
1677 (37, 'Приход', 44, 137, 9),
1678 (38, 'Расход', 45, 138, 9),
1679 (39, 'Приход', 46, 139, 10),
1680 (40, 'Расход', 47, 140, 10),
1681 (41, 'Приход', 48, 141, 1),
1682 (42, 'Расход', 49, 142, 1),
1683 (43, 'Приход', 50, 143, 2),
1684 (44, 'Расход', 51, 144, 2),
1685 (45, 'Приход', 52, 145, 3),
1686 (46, 'Расход', 53, 146, 3),
1687 (47, 'Приход', 54, 147, 4),
1688 (48, 'Расход', 55, 148, 4),
1689 (49, 'Приход', 56, 149, 5),
1690 (50, 'Расход', 57, 150, 5);
1691
1692COMMIT;
1693
1694*/
1695-- -----------------------------------------------------
1696-- Data for table `mydb`.`Suppliers`
1697-- -----------------------------------------------------
1698START TRANSACTION;
1699USE `mydb`;
1700INSERT INTO `mydb`.`Suppliers` (`SupplierID`, `Name`, `ContactInfo`) VALUES (1, 'GlassMaster', 'Phone: +79002345678');
1701INSERT INTO `mydb`.`Suppliers` (`SupplierID`, `Name`, `ContactInfo`) VALUES (2, 'FrameWorks', 'Email: frameworks@example.com');
1702INSERT INTO `mydb`.`Suppliers` (`SupplierID`, `Name`, `ContactInfo`) VALUES (3, 'SealantSolutions', 'Phone: +79003456789');
1703INSERT INTO `mydb`.`Suppliers` (`SupplierID`, `Name`, `ContactInfo`) VALUES (4, 'HardwareHub', 'Email: hardwarehub@example.com');
1704INSERT INTO `mydb`.`Suppliers` (`SupplierID`, `Name`, `ContactInfo`) VALUES (5, 'AdhesiveExperts', 'Phone: +79004567890');
1705INSERT INTO `mydb`.`Suppliers` (`SupplierID`, `Name`, `ContactInfo`) VALUES (6, 'InsulationInnovations', 'Email: insulationinnovations@example.com');
1706INSERT INTO `mydb`.`Suppliers` (`SupplierID`, `Name`, `ContactInfo`) VALUES (7, 'SpacerSystems', 'Phone: +79005678901');
1707INSERT INTO `mydb`.`Suppliers` (`SupplierID`, `Name`, `ContactInfo`) VALUES (8, 'PaintPartners', 'Email: paintpartners@example.com');
1708INSERT INTO `mydb`.`Suppliers` (`SupplierID`, `Name`, `ContactInfo`) VALUES (9, 'CoatingCompany', 'Phone: +79006789012');
1709INSERT INTO `mydb`.`Suppliers` (`SupplierID`, `Name`, `ContactInfo`) VALUES (10, 'ReinforcementResources', 'Email: reinforcementresources@example.com');
1710
1711COMMIT;
1712
1713
1714-- -----------------------------------------------------
1715-- Data for table `mydb`.`SupplierContacts`
1716-- -----------------------------------------------------
1717START TRANSACTION;
1718USE `mydb`;
1719INSERT INTO `mydb`.`SupplierContacts` (`ContactID`, `ContactType`, `Value`, `Suppliers_SupplierID`) VALUES (1, 'Телефон', '+79002345678', 1);
1720INSERT INTO `mydb`.`SupplierContacts` (`ContactID`, `ContactType`, `Value`, `Suppliers_SupplierID`) VALUES (2, 'Почта', 'frameworks@example.com', 2);
1721INSERT INTO `mydb`.`SupplierContacts` (`ContactID`, `ContactType`, `Value`, `Suppliers_SupplierID`) VALUES (3, 'Телефон', '+79003456789', 3);
1722INSERT INTO `mydb`.`SupplierContacts` (`ContactID`, `ContactType`, `Value`, `Suppliers_SupplierID`) VALUES (4, 'Почта', 'hardwarehub@example.com', 4);
1723INSERT INTO `mydb`.`SupplierContacts` (`ContactID`, `ContactType`, `Value`, `Suppliers_SupplierID`) VALUES (5, 'Телефон', '+79004567890', 5);
1724INSERT INTO `mydb`.`SupplierContacts` (`ContactID`, `ContactType`, `Value`, `Suppliers_SupplierID`) VALUES (6, 'Почта', 'insulationinnovations@example.com', 6);
1725INSERT INTO `mydb`.`SupplierContacts` (`ContactID`, `ContactType`, `Value`, `Suppliers_SupplierID`) VALUES (7, 'Телефон', '+79005678901', 7);
1726INSERT INTO `mydb`.`SupplierContacts` (`ContactID`, `ContactType`, `Value`, `Suppliers_SupplierID`) VALUES (8, 'Почта', 'paintpartners@example.com', 8);
1727INSERT INTO `mydb`.`SupplierContacts` (`ContactID`, `ContactType`, `Value`, `Suppliers_SupplierID`) VALUES (9, 'Телефон', '+79006789012', 9);
1728INSERT INTO `mydb`.`SupplierContacts` (`ContactID`, `ContactType`, `Value`, `Suppliers_SupplierID`) VALUES (10, 'ПочтаOrderID', 'reinforcementresources@example.com', 10);
1729
1730COMMIT;
1731
1732
1733-- -----------------------------------------------------
1734-- Data for table `mydb`.`PurchaseOrders`
1735-- -----------------------------------------------------
1736START TRANSACTION;
1737USE `mydb`;
1738INSERT INTO `mydb`.`PurchaseOrders` (`PurchaseOrderID`, `OrderDate`, `Status`, `Suppliers_SupplierID`) VALUES (1, '2023-01-01 00:00:00', 'Processing', 1);
1739INSERT INTO `mydb`.`PurchaseOrders` (`PurchaseOrderID`, `OrderDate`, `Status`, `Suppliers_SupplierID`) VALUES (2, '2023-01-02 00:00:00', 'Completed', 2);
1740INSERT INTO `mydb`.`PurchaseOrders` (`PurchaseOrderID`, `OrderDate`, `Status`, `Suppliers_SupplierID`) VALUES (3, '2023-01-03 00:00:00', 'Processing', 3);
1741INSERT INTO `mydb`.`PurchaseOrders` (`PurchaseOrderID`, `OrderDate`, `Status`, `Suppliers_SupplierID`) VALUES (4, '2023-01-04 00:00:00', 'Completed', 4);
1742INSERT INTO `mydb`.`PurchaseOrders` (`PurchaseOrderID`, `OrderDate`, `Status`, `Suppliers_SupplierID`) VALUES (5, '2023-01-05 00:00:00', 'Processing', 5);
1743INSERT INTO `mydb`.`PurchaseOrders` (`PurchaseOrderID`, `OrderDate`, `Status`, `Suppliers_SupplierID`) VALUES (6, '2023-01-06 00:00:00', 'Completed', 6);
1744INSERT INTO `mydb`.`PurchaseOrders` (`PurchaseOrderID`, `OrderDate`, `Status`, `Suppliers_SupplierID`) VALUES (7, '2023-01-07 00:00:00', 'Processing', 7);
1745INSERT INTO `mydb`.`PurchaseOrders` (`PurchaseOrderID`, `OrderDate`, `Status`, `Suppliers_SupplierID`) VALUES (8, '2023-01-08 00:00:00', 'Completed', 8);
1746INSERT INTO `mydb`.`PurchaseOrders` (`PurchaseOrderID`, `OrderDate`, `Status`, `Suppliers_SupplierID`) VALUES (9, '2023-01-09 00:00:00', 'Processing', 9);
1747INSERT INTO `mydb`.`PurchaseOrders` (`PurchaseOrderID`, `OrderDate`, `Status`, `Suppliers_SupplierID`) VALUES (10, '2023-01-10 00:00:00', 'Completed', 10);
1748
1749COMMIT;
1750
1751
1752-- -----------------------------------------------------
1753-- Data for table `mydb`.`PurchaseOrderDetails`
1754-- -----------------------------------------------------
1755START TRANSACTION;
1756USE `mydb`;
1757INSERT INTO `mydb`.`PurchaseOrderDetails` (`PurchaseDetailID`, `Quantity`, `Price`, `PurchaseOrders_PurchaseOrderID`, `Materials_MaterialID`) VALUES (1, 10, 50.00, 1, 101);
1758INSERT INTO `mydb`.`PurchaseOrderDetails` (`PurchaseDetailID`, `Quantity`, `Price`, `PurchaseOrders_PurchaseOrderID`, `Materials_MaterialID`) VALUES (2, 15, 75.00, 2, 102);
1759INSERT INTO `mydb`.`PurchaseOrderDetails` (`PurchaseDetailID`, `Quantity`, `Price`, `PurchaseOrders_PurchaseOrderID`, `Materials_MaterialID`) VALUES (3, 20, 100.00, 3, 103);
1760INSERT INTO `mydb`.`PurchaseOrderDetails` (`PurchaseDetailID`, `Quantity`, `Price`, `PurchaseOrders_PurchaseOrderID`, `Materials_MaterialID`) VALUES (4, 12, 60.00, 4, 104);
1761INSERT INTO `mydb`.`PurchaseOrderDetails` (`PurchaseDetailID`, `Quantity`, `Price`, `PurchaseOrders_PurchaseOrderID`, `Materials_MaterialID`) VALUES (5, 8, 40.00, 5, 105);
1762INSERT INTO `mydb`.`PurchaseOrderDetails` (`PurchaseDetailID`, `Quantity`, `Price`, `PurchaseOrders_PurchaseOrderID`, `Materials_MaterialID`) VALUES (6, 11, 55.00, 6, 106);
1763INSERT INTO `mydb`.`PurchaseOrderDetails` (`PurchaseDetailID`, `Quantity`, `Price`, `PurchaseOrders_PurchaseOrderID`, `Materials_MaterialID`) VALUES (7, 9, 45.00, 7, 107);
1764INSERT INTO `mydb`.`PurchaseOrderDetails` (`PurchaseDetailID`, `Quantity`, `Price`, `PurchaseOrders_PurchaseOrderID`, `Materials_MaterialID`) VALUES (8, 13, 65.00, 8, 108);
1765INSERT INTO `mydb`.`PurchaseOrderDetails` (`PurchaseDetailID`, `Quantity`, `Price`, `PurchaseOrders_PurchaseOrderID`, `Materials_MaterialID`) VALUES (9, 14, 70.00, 9, 109);
1766INSERT INTO `mydb`.`PurchaseOrderDetails` (`PurchaseDetailID`, `Quantity`, `Price`, `PurchaseOrders_PurchaseOrderID`, `Materials_MaterialID`) VALUES (10, 16, 80.00, 10, 110);
1767INSERT INTO `mydb`.`PurchaseOrderDetails` (`PurchaseDetailID`, `Quantity`, `Price`, `PurchaseOrders_PurchaseOrderID`, `Materials_MaterialID`) VALUES (11, 17, 85.00, 1, 111);
1768INSERT INTO `mydb`.`PurchaseOrderDetails` (`PurchaseDetailID`, `Quantity`, `Price`, `PurchaseOrders_PurchaseOrderID`, `Materials_MaterialID`) VALUES (12, 18, 90.00, 2, 112);
1769INSERT INTO `mydb`.`PurchaseOrderDetails` (`PurchaseDetailID`, `Quantity`, `Price`, `PurchaseOrders_PurchaseOrderID`, `Materials_MaterialID`) VALUES (13, 19, 95.00, 3, 113);
1770INSERT INTO `mydb`.`PurchaseOrderDetails` (`PurchaseDetailID`, `Quantity`, `Price`, `PurchaseOrders_PurchaseOrderID`, `Materials_MaterialID`) VALUES (14, 21, 105.00, 4, 114);
1771INSERT INTO `mydb`.`PurchaseOrderDetails` (`PurchaseDetailID`, `Quantity`, `Price`, `PurchaseOrders_PurchaseOrderID`, `Materials_MaterialID`) VALUES (15, 22, 110.00, 5, 115);
1772INSERT INTO `mydb`.`PurchaseOrderDetails` (`PurchaseDetailID`, `Quantity`, `Price`, `PurchaseOrders_PurchaseOrderID`, `Materials_MaterialID`) VALUES (16, 23, 115.00, 6, 116);
1773INSERT INTO `mydb`.`PurchaseOrderDetails` (`PurchaseDetailID`, `Quantity`, `Price`, `PurchaseOrders_PurchaseOrderID`, `Materials_MaterialID`) VALUES (17, 24, 120.00, 7, 117);
1774INSERT INTO `mydb`.`PurchaseOrderDetails` (`PurchaseDetailID`, `Quantity`, `Price`, `PurchaseOrders_PurchaseOrderID`, `Materials_MaterialID`) VALUES (18, 25, 125.00, 8, 118);
1775INSERT INTO `mydb`.`PurchaseOrderDetails` (`PurchaseDetailID`, `Quantity`, `Price`, `PurchaseOrders_PurchaseOrderID`, `Materials_MaterialID`) VALUES (19, 26, 130.00, 9, 119);
1776INSERT INTO `mydb`.`PurchaseOrderDetails` (`PurchaseDetailID`, `Quantity`, `Price`, `PurchaseOrders_PurchaseOrderID`, `Materials_MaterialID`) VALUES (20, 27, 135.00, 10, 120);
1777INSERT INTO `mydb`.`PurchaseOrderDetails` (`PurchaseDetailID`, `Quantity`, `Price`, `PurchaseOrders_PurchaseOrderID`, `Materials_MaterialID`) VALUES (21, 28, 140.00, 1, 121);
1778INSERT INTO `mydb`.`PurchaseOrderDetails` (`PurchaseDetailID`, `Quantity`, `Price`, `PurchaseOrders_PurchaseOrderID`, `Materials_MaterialID`) VALUES (22, 29, 145.00, 2, 122);
1779INSERT INTO `mydb`.`PurchaseOrderDetails` (`PurchaseDetailID`, `Quantity`, `Price`, `PurchaseOrders_PurchaseOrderID`, `Materials_MaterialID`) VALUES (23, 30, 150.00, 3, 123);
1780INSERT INTO `mydb`.`PurchaseOrderDetails` (`PurchaseDetailID`, `Quantity`, `Price`, `PurchaseOrders_PurchaseOrderID`, `Materials_MaterialID`) VALUES (24, 31, 155.00, 4, 124);
1781INSERT INTO `mydb`.`PurchaseOrderDetails` (`PurchaseDetailID`, `Quantity`, `Price`, `PurchaseOrders_PurchaseOrderID`, `Materials_MaterialID`) VALUES (25, 32, 160.00, 5, 125);
1782INSERT INTO `mydb`.`PurchaseOrderDetails` (`PurchaseDetailID`, `Quantity`, `Price`, `PurchaseOrders_PurchaseOrderID`, `Materials_MaterialID`) VALUES (26, 33, 165.00, 6, 126);
1783INSERT INTO `mydb`.`PurchaseOrderDetails` (`PurchaseDetailID`, `Quantity`, `Price`, `PurchaseOrders_PurchaseOrderID`, `Materials_MaterialID`) VALUES (27, 34, 170.00, 7, 127);
1784INSERT INTO `mydb`.`PurchaseOrderDetails` (`PurchaseDetailID`, `Quantity`, `Price`, `PurchaseOrders_PurchaseOrderID`, `Materials_MaterialID`) VALUES (28, 35, 175.00, 8, 128);
1785INSERT INTO `mydb`.`PurchaseOrderDetails` (`PurchaseDetailID`, `Quantity`, `Price`, `PurchaseOrders_PurchaseOrderID`, `Materials_MaterialID`) VALUES (29, 36, 180.00, 9, 129);
1786INSERT INTO `mydb`.`PurchaseOrderDetails` (`PurchaseDetailID`, `Quantity`, `Price`, `PurchaseOrders_PurchaseOrderID`, `Materials_MaterialID`) VALUES (30, 37, 185.00, 10, 130);
1787INSERT INTO `mydb`.`PurchaseOrderDetails` (`PurchaseDetailID`, `Quantity`, `Price`, `PurchaseOrders_PurchaseOrderID`, `Materials_MaterialID`) VALUES (31, 38, 190.00, 1, 131);
1788INSERT INTO `mydb`.`PurchaseOrderDetails` (`PurchaseDetailID`, `Quantity`, `Price`, `PurchaseOrders_PurchaseOrderID`, `Materials_MaterialID`) VALUES (32, 39, 195.00, 2, 132);
1789INSERT INTO `mydb`.`PurchaseOrderDetails` (`PurchaseDetailID`, `Quantity`, `Price`, `PurchaseOrders_PurchaseOrderID`, `Materials_MaterialID`) VALUES (33, 40, 200.00, 3, 133);
1790INSERT INTO `mydb`.`PurchaseOrderDetails` (`PurchaseDetailID`, `Quantity`, `Price`, `PurchaseOrders_PurchaseOrderID`, `Materials_MaterialID`) VALUES (34, 41, 205.00, 4, 134);
1791INSERT INTO `mydb`.`PurchaseOrderDetails` (`PurchaseDetailID`, `Quantity`, `Price`, `PurchaseOrders_PurchaseOrderID`, `Materials_MaterialID`) VALUES (35, 42, 210.00, 5, 135);
1792INSERT INTO `mydb`.`PurchaseOrderDetails` (`PurchaseDetailID`, `Quantity`, `Price`, `PurchaseOrders_PurchaseOrderID`, `Materials_MaterialID`) VALUES (36, 43, 215.00, 6, 136);
1793INSERT INTO `mydb`.`PurchaseOrderDetails` (`PurchaseDetailID`, `Quantity`, `Price`, `PurchaseOrders_PurchaseOrderID`, `Materials_MaterialID`) VALUES (37, 44, 220.00, 7, 137);
1794INSERT INTO `mydb`.`PurchaseOrderDetails` (`PurchaseDetailID`, `Quantity`, `Price`, `PurchaseOrders_PurchaseOrderID`, `Materials_MaterialID`) VALUES (38, 45, 225.00, 8, 138);
1795INSERT INTO `mydb`.`PurchaseOrderDetails` (`PurchaseDetailID`, `Quantity`, `Price`, `PurchaseOrders_PurchaseOrderID`, `Materials_MaterialID`) VALUES (39, 46, 230.00, 9, 139);
1796INSERT INTO `mydb`.`PurchaseOrderDetails` (`PurchaseDetailID`, `Quantity`, `Price`, `PurchaseOrders_PurchaseOrderID`, `Materials_MaterialID`) VALUES (40, 47, 235.00, 10, 140);
1797INSERT INTO `mydb`.`PurchaseOrderDetails` (`PurchaseDetailID`, `Quantity`, `Price`, `PurchaseOrders_PurchaseOrderID`, `Materials_MaterialID`) VALUES (41, 48, 240.00, 1, 141);
1798INSERT INTO `mydb`.`PurchaseOrderDetails` (`PurchaseDetailID`, `Quantity`, `Price`, `PurchaseOrders_PurchaseOrderID`, `Materials_MaterialID`) VALUES (42, 49, 245.00, 2, 142);
1799INSERT INTO `mydb`.`PurchaseOrderDetails` (`PurchaseDetailID`, `Quantity`, `Price`, `PurchaseOrders_PurchaseOrderID`, `Materials_MaterialID`) VALUES (43, 50, 250.00, 3, 143);
1800INSERT INTO `mydb`.`PurchaseOrderDetails` (`PurchaseDetailID`, `Quantity`, `Price`, `PurchaseOrders_PurchaseOrderID`, `Materials_MaterialID`) VALUES (44, 51, 255.00, 4, 144);
1801INSERT INTO `mydb`.`PurchaseOrderDetails` (`PurchaseDetailID`, `Quantity`, `Price`, `PurchaseOrders_PurchaseOrderID`, `Materials_MaterialID`) VALUES (45, 52, 260.00, 5, 145);
1802INSERT INTO `mydb`.`PurchaseOrderDetails` (`PurchaseDetailID`, `Quantity`, `Price`, `PurchaseOrders_PurchaseOrderID`, `Materials_MaterialID`) VALUES (46, 53, 265.00, 6, 146);
1803INSERT INTO `mydb`.`PurchaseOrderDetails` (`PurchaseDetailID`, `Quantity`, `Price`, `PurchaseOrders_PurchaseOrderID`, `Materials_MaterialID`) VALUES (47, 54, 270.00, 7, 147);
1804INSERT INTO `mydb`.`PurchaseOrderDetails` (`PurchaseDetailID`, `Quantity`, `Price`, `PurchaseOrders_PurchaseOrderID`, `Materials_MaterialID`) VALUES (48, 55, 275.00, 8, 148);
1805INSERT INTO `mydb`.`PurchaseOrderDetails` (`PurchaseDetailID`, `Quantity`, `Price`, `PurchaseOrders_PurchaseOrderID`, `Materials_MaterialID`) VALUES (49, 56, 280.00, 9, 149);
1806INSERT INTO `mydb`.`PurchaseOrderDetails` (`PurchaseDetailID`, `Quantity`, `Price`, `PurchaseOrders_PurchaseOrderID`, `Materials_MaterialID`) VALUES (50, 57, 285.00, 10, 150);
1807
1808COMMIT;
1809
1810
1811-- -----------------------------------------------------
1812-- Data for table `mydb`.`Invoices`
1813-- -----------------------------------------------------
1814START TRANSACTION;
1815USE `mydb`;
1816INSERT INTO `mydb`.`Invoices` (`InvoiceID`, `InvoiceDate`, `Amount`) VALUES (1, '2023-01-01 00:00:00', 500.00);
1817INSERT INTO `mydb`.`Invoices` (`InvoiceID`, `InvoiceDate`, `Amount`) VALUES (2, '2023-01-02 00:00:00', 1000.00);
1818INSERT INTO `mydb`.`Invoices` (`InvoiceID`, `InvoiceDate`, `Amount`) VALUES (3, '2023-01-03 00:00:00', 750.00);
1819INSERT INTO `mydb`.`Invoices` (`InvoiceID`, `InvoiceDate`, `Amount`) VALUES (4, '2023-01-04 00:00:00', 1200.00);
1820INSERT INTO `mydb`.`Invoices` (`InvoiceID`, `InvoiceDate`, `Amount`) VALUES (5, '2023-01-05 00:00:00', 600.00);
1821INSERT INTO `mydb`.`Invoices` (`InvoiceID`, `InvoiceDate`, `Amount`) VALUES (6, '2023-01-06 00:00:00', 1500.00);
1822INSERT INTO `mydb`.`Invoices` (`InvoiceID`, `InvoiceDate`, `Amount`) VALUES (7, '2023-01-07 00:00:00', 800.00);
1823INSERT INTO `mydb`.`Invoices` (`InvoiceID`, `InvoiceDate`, `Amount`) VALUES (8, '2023-01-08 00:00:00', 1300.00);
1824INSERT INTO `mydb`.`Invoices` (`InvoiceID`, `InvoiceDate`, `Amount`) VALUES (9, '2023-01-09 00:00:00', 650.00);
1825INSERT INTO `mydb`.`Invoices` (`InvoiceID`, `InvoiceDate`, `Amount`) VALUES (10, '2023-01-10 00:00:00', 1600.00);
1826INSERT INTO `mydb`.`Invoices` (`InvoiceID`, `InvoiceDate`, `Amount`) VALUES (11, '2023-01-11 00:00:00', 850.00);
1827INSERT INTO `mydb`.`Invoices` (`InvoiceID`, `InvoiceDate`, `Amount`) VALUES (12, '2023-01-12 00:00:00', 1400.00);
1828INSERT INTO `mydb`.`Invoices` (`InvoiceID`, `InvoiceDate`, `Amount`) VALUES (13, '2023-01-13 00:00:00', 700.00);
1829INSERT INTO `mydb`.`Invoices` (`InvoiceID`, `InvoiceDate`, `Amount`) VALUES (14, '2023-01-14 00:00:00', 1700.00);
1830INSERT INTO `mydb`.`Invoices` (`InvoiceID`, `InvoiceDate`, `Amount`) VALUES (15, '2023-01-15 00:00:00', 900.00);
1831INSERT INTO `mydb`.`Invoices` (`InvoiceID`, `InvoiceDate`, `Amount`) VALUES (16, '2023-01-16 00:00:00', 1800.00);
1832INSERT INTO `mydb`.`Invoices` (`InvoiceID`, `InvoiceDate`, `Amount`) VALUES (17, '2023-01-17 00:00:00', 950.00);
1833INSERT INTO `mydb`.`Invoices` (`InvoiceID`, `InvoiceDate`, `Amount`) VALUES (18, '2023-01-18 00:00:00', 1900.00);
1834INSERT INTO `mydb`.`Invoices` (`InvoiceID`, `InvoiceDate`, `Amount`) VALUES (19, '2023-01-19 00:00:00', 1000.00);
1835INSERT INTO `mydb`.`Invoices` (`InvoiceID`, `InvoiceDate`, `Amount`) VALUES (20, '2023-01-20 00:00:00', 2000.00);
1836INSERT INTO `mydb`.`Invoices` (`InvoiceID`, `InvoiceDate`, `Amount`) VALUES (21, '2023-01-21 00:00:00', 1050.00);
1837INSERT INTO `mydb`.`Invoices` (`InvoiceID`, `InvoiceDate`, `Amount`) VALUES (22, '2023-01-22 00:00:00', 2100.00);
1838INSERT INTO `mydb`.`Invoices` (`InvoiceID`, `InvoiceDate`, `Amount`) VALUES (23, '2023-01-23 00:00:00', 1100.00);
1839INSERT INTO `mydb`.`Invoices` (`InvoiceID`, `InvoiceDate`, `Amount`) VALUES (24, '2023-01-24 00:00:00', 2200.00);
1840INSERT INTO `mydb`.`Invoices` (`InvoiceID`, `InvoiceDate`, `Amount`) VALUES (25, '2023-01-25 00:00:00', 1150.00);
1841INSERT INTO `mydb`.`Invoices` (`InvoiceID`, `InvoiceDate`, `Amount`) VALUES (26, '2023-01-26 00:00:00', 2300.00);
1842INSERT INTO `mydb`.`Invoices` (`InvoiceID`, `InvoiceDate`, `Amount`) VALUES (27, '2023-01-27 00:00:00', 1200.00);
1843INSERT INTO `mydb`.`Invoices` (`InvoiceID`, `InvoiceDate`, `Amount`) VALUES (28, '2023-01-28 00:00:00', 2400.00);
1844INSERT INTO `mydb`.`Invoices` (`InvoiceID`, `InvoiceDate`, `Amount`) VALUES (29, '2023-01-29 00:00:00', 1250.00);
1845INSERT INTO `mydb`.`Invoices` (`InvoiceID`, `InvoiceDate`, `Amount`) VALUES (30, '2023-01-30 00:00:00', 2500.00);
1846INSERT INTO `mydb`.`Invoices` (`InvoiceID`, `InvoiceDate`, `Amount`) VALUES (31, '2023-01-31 00:00:00', 1300.00);
1847INSERT INTO `mydb`.`Invoices` (`InvoiceID`, `InvoiceDate`, `Amount`) VALUES (32, '2023-02-01 00:00:00', 2600.00);
1848INSERT INTO `mydb`.`Invoices` (`InvoiceID`, `InvoiceDate`, `Amount`) VALUES (33, '2023-02-02 00:00:00', 1350.00);
1849INSERT INTO `mydb`.`Invoices` (`InvoiceID`, `InvoiceDate`, `Amount`) VALUES (34, '2023-02-03 00:00:00', 2700.00);
1850INSERT INTO `mydb`.`Invoices` (`InvoiceID`, `InvoiceDate`, `Amount`) VALUES (35, '2023-02-04 00:00:00', 1400.00);
1851INSERT INTO `mydb`.`Invoices` (`InvoiceID`, `InvoiceDate`, `Amount`) VALUES (36, '2023-02-05 00:00:00', 2800.00);
1852INSERT INTO `mydb`.`Invoices` (`InvoiceID`, `InvoiceDate`, `Amount`) VALUES (37, '2023-02-06 00:00:00', 1450.00);
1853INSERT INTO `mydb`.`Invoices` (`InvoiceID`, `InvoiceDate`, `Amount`) VALUES (38, '2023-02-07 00:00:00', 2900.00);
1854INSERT INTO `mydb`.`Invoices` (`InvoiceID`, `InvoiceDate`, `Amount`) VALUES (39, '2023-02-08 00:00:00', 1500.00);
1855INSERT INTO `mydb`.`Invoices` (`InvoiceID`, `InvoiceDate`, `Amount`) VALUES (40, '2023-02-09 00:00:00', 3000.00);
1856INSERT INTO `mydb`.`Invoices` (`InvoiceID`, `InvoiceDate`, `Amount`) VALUES (41, '2023-02-10 00:00:00', 1550.00);
1857INSERT INTO `mydb`.`Invoices` (`InvoiceID`, `InvoiceDate`, `Amount`) VALUES (42, '2023-02-11 00:00:00', 3100.00);
1858INSERT INTO `mydb`.`Invoices` (`InvoiceID`, `InvoiceDate`, `Amount`) VALUES (43, '2023-02-12 00:00:00', 1600.00);
1859INSERT INTO `mydb`.`Invoices` (`InvoiceID`, `InvoiceDate`, `Amount`) VALUES (44, '2023-02-13 00:00:00', 3200.00);
1860INSERT INTO `mydb`.`Invoices` (`InvoiceID`, `InvoiceDate`, `Amount`) VALUES (45, '2023-02-14 00:00:00', 1650.00);
1861INSERT INTO `mydb`.`Invoices` (`InvoiceID`, `InvoiceDate`, `Amount`) VALUES (46, '2023-02-15 00:00:00', 3300.00);
1862INSERT INTO `mydb`.`Invoices` (`InvoiceID`, `InvoiceDate`, `Amount`) VALUES (47, '2023-02-16 00:00:00', 1700.00);
1863INSERT INTO `mydb`.`Invoices` (`InvoiceID`, `InvoiceDate`, `Amount`) VALUES (48, '2023-02-17 00:00:00', 3400.00);
1864INSERT INTO `mydb`.`Invoices` (`InvoiceID`, `InvoiceDate`, `Amount`) VALUES (49, '2023-02-18 00:00:00', 1750.00);
1865INSERT INTO `mydb`.`Invoices` (`InvoiceID`, `InvoiceDate`, `Amount`) VALUES (50, '2023-02-19 00:00:00', 3500.00);
1866
1867COMMIT;
1868
1869
1870-- -----------------------------------------------------
1871-- Data for table `mydb`.`Payments`
1872-- -----------------------------------------------------
1873START TRANSACTION;
1874USE `mydb`;
1875INSERT INTO `mydb`.`Payments` (`PaymentID`, `PaymentDate`, `Amount`, `PaymentMethod`, `Invoices_InvoiceID`) VALUES (1, '2023-01-01 00:00:00', 100.00, 'Cash', 1);
1876INSERT INTO `mydb`.`Payments` (`PaymentID`, `PaymentDate`, `Amount`, `PaymentMethod`, `Invoices_InvoiceID`) VALUES (2, '2023-01-02 00:00:00', 200.00, 'Credit Card', 2);
1877INSERT INTO `mydb`.`Payments` (`PaymentID`, `PaymentDate`, `Amount`, `PaymentMethod`, `Invoices_InvoiceID`) VALUES (3, '2023-01-03 00:00:00', 150.00, 'Debit Card', 3);
1878INSERT INTO `mydb`.`Payments` (`PaymentID`, `PaymentDate`, `Amount`, `PaymentMethod`, `Invoices_InvoiceID`) VALUES (4, '2023-01-04 00:00:00', 300.00, 'Bank Transfer', 4);
1879INSERT INTO `mydb`.`Payments` (`PaymentID`, `PaymentDate`, `Amount`, `PaymentMethod`, `Invoices_InvoiceID`) VALUES (5, '2023-01-05 00:00:00', 250.00, 'Cash', 5);
1880INSERT INTO `mydb`.`Payments` (`PaymentID`, `PaymentDate`, `Amount`, `PaymentMethod`, `Invoices_InvoiceID`) VALUES (6, '2023-01-06 00:00:00', 400.00, 'Credit Card', 6);
1881INSERT INTO `mydb`.`Payments` (`PaymentID`, `PaymentDate`, `Amount`, `PaymentMethod`, `Invoices_InvoiceID`) VALUES (7, '2023-01-07 00:00:00', 350.00, 'Debit Card', 7);
1882INSERT INTO `mydb`.`Payments` (`PaymentID`, `PaymentDate`, `Amount`, `PaymentMethod`, `Invoices_InvoiceID`) VALUES (8, '2023-01-08 00:00:00', 500.00, 'Bank Transfer', 8);
1883INSERT INTO `mydb`.`Payments` (`PaymentID`, `PaymentDate`, `Amount`, `PaymentMethod`, `Invoices_InvoiceID`) VALUES (9, '2023-01-09 00:00:00', 450.00, 'Cash', 9);
1884INSERT INTO `mydb`.`Payments` (`PaymentID`, `PaymentDate`, `Amount`, `PaymentMethod`, `Invoices_InvoiceID`) VALUES (10, '2023-01-10 00:00:00', 600.00, 'Credit Card', 10);
1885INSERT INTO `mydb`.`Payments` (`PaymentID`, `PaymentDate`, `Amount`, `PaymentMethod`, `Invoices_InvoiceID`) VALUES (11, '2023-01-11 00:00:00', 550.00, 'Debit Card', 11);
1886INSERT INTO `mydb`.`Payments` (`PaymentID`, `PaymentDate`, `Amount`, `PaymentMethod`, `Invoices_InvoiceID`) VALUES (12, '2023-01-12 00:00:00', 700.00, 'Bank Transfer', 12);
1887INSERT INTO `mydb`.`Payments` (`PaymentID`, `PaymentDate`, `Amount`, `PaymentMethod`, `Invoices_InvoiceID`) VALUES (13, '2023-01-13 00:00:00', 650.00, 'Cash', 13);
1888INSERT INTO `mydb`.`Payments` (`PaymentID`, `PaymentDate`, `Amount`, `PaymentMethod`, `Invoices_InvoiceID`) VALUES (14, '2023-01-14 00:00:00', 800.00, 'Credit Card', 14);
1889INSERT INTO `mydb`.`Payments` (`PaymentID`, `PaymentDate`, `Amount`, `PaymentMethod`, `Invoices_InvoiceID`) VALUES (15, '2023-01-15 00:00:00', 750.00, 'Debit Card', 15);
1890INSERT INTO `mydb`.`Payments` (`PaymentID`, `PaymentDate`, `Amount`, `PaymentMethod`, `Invoices_InvoiceID`) VALUES (16, '2023-01-16 00:00:00', 900.00, 'Bank Transfer', 16);
1891INSERT INTO `mydb`.`Payments` (`PaymentID`, `PaymentDate`, `Amount`, `PaymentMethod`, `Invoices_InvoiceID`) VALUES (17, '2023-01-17 00:00:00', 850.00, 'Cash', 17);
1892INSERT INTO `mydb`.`Payments` (`PaymentID`, `PaymentDate`, `Amount`, `PaymentMethod`, `Invoices_InvoiceID`) VALUES (18, '2023-01-18 00:00:00', 1000.00, 'Credit Card', 18);
1893INSERT INTO `mydb`.`Payments` (`PaymentID`, `PaymentDate`, `Amount`, `PaymentMethod`, `Invoices_InvoiceID`) VALUES (19, '2023-01-19 00:00:00', 950.00, 'Debit Card', 19);
1894INSERT INTO `mydb`.`Payments` (`PaymentID`, `PaymentDate`, `Amount`, `PaymentMethod`, `Invoices_InvoiceID`) VALUES (20, '2023-01-20 00:00:00', 1100.00, 'Bank Transfer', 20);
1895INSERT INTO `mydb`.`Payments` (`PaymentID`, `PaymentDate`, `Amount`, `PaymentMethod`, `Invoices_InvoiceID`) VALUES (21, '2023-01-21 00:00:00', 1050.00, 'Cash', 21);
1896INSERT INTO `mydb`.`Payments` (`PaymentID`, `PaymentDate`, `Amount`, `PaymentMethod`, `Invoices_InvoiceID`) VALUES (22, '2023-01-22 00:00:00', 1200.00, 'Credit Card', 22);
1897INSERT INTO `mydb`.`Payments` (`PaymentID`, `PaymentDate`, `Amount`, `PaymentMethod`, `Invoices_InvoiceID`) VALUES (23, '2023-01-23 00:00:00', 1150.00, 'Debit Card', 23);
1898INSERT INTO `mydb`.`Payments` (`PaymentID`, `PaymentDate`, `Amount`, `PaymentMethod`, `Invoices_InvoiceID`) VALUES (24, '2023-01-24 00:00:00', 1300.00, 'Bank Transfer', 24);
1899INSERT INTO `mydb`.`Payments` (`PaymentID`, `PaymentDate`, `Amount`, `PaymentMethod`, `Invoices_InvoiceID`) VALUES (25, '2023-01-25 00:00:00', 1250.00, 'Cash', 25);
1900INSERT INTO `mydb`.`Payments` (`PaymentID`, `PaymentDate`, `Amount`, `PaymentMethod`, `Invoices_InvoiceID`) VALUES (26, '2023-01-26 00:00:00', 1400.00, 'Credit Card', 26);
1901INSERT INTO `mydb`.`Payments` (`PaymentID`, `PaymentDate`, `Amount`, `PaymentMethod`, `Invoices_InvoiceID`) VALUES (27, '2023-01-27 00:00:00', 1350.00, 'Debit Card', 27);
1902INSERT INTO `mydb`.`Payments` (`PaymentID`, `PaymentDate`, `Amount`, `PaymentMethod`, `Invoices_InvoiceID`) VALUES (28, '2023-01-28 00:00:00', 1500.00, 'Bank Transfer', 28);
1903INSERT INTO `mydb`.`Payments` (`PaymentID`, `PaymentDate`, `Amount`, `PaymentMethod`, `Invoices_InvoiceID`) VALUES (29, '2023-01-29 00:00:00', 1450.00, 'Cash', 29);
1904INSERT INTO `mydb`.`Payments` (`PaymentID`, `PaymentDate`, `Amount`, `PaymentMethod`, `Invoices_InvoiceID`) VALUES (30, '2023-01-30 00:00:00', 1600.00, 'Credit Card', 30);
1905INSERT INTO `mydb`.`Payments` (`PaymentID`, `PaymentDate`, `Amount`, `PaymentMethod`, `Invoices_InvoiceID`) VALUES (31, '2023-01-31 00:00:00', 1550.00, 'Debit Card', 31);
1906INSERT INTO `mydb`.`Payments` (`PaymentID`, `PaymentDate`, `Amount`, `PaymentMethod`, `Invoices_InvoiceID`) VALUES (32, '2023-02-01 00:00:00', 1700.00, 'Bank Transfer', 32);
1907INSERT INTO `mydb`.`Payments` (`PaymentID`, `PaymentDate`, `Amount`, `PaymentMethod`, `Invoices_InvoiceID`) VALUES (33, '2023-02-02 00:00:00', 1650.00, 'Cash', 33);
1908INSERT INTO `mydb`.`Payments` (`PaymentID`, `PaymentDate`, `Amount`, `PaymentMethod`, `Invoices_InvoiceID`) VALUES (34, '2023-02-03 00:00:00', 1800.00, 'Credit Card', 34);
1909INSERT INTO `mydb`.`Payments` (`PaymentID`, `PaymentDate`, `Amount`, `PaymentMethod`, `Invoices_InvoiceID`) VALUES (35, '2023-02-04 00:00:00', 1750.00, 'Debit Card', 35);
1910INSERT INTO `mydb`.`Payments` (`PaymentID`, `PaymentDate`, `Amount`, `PaymentMethod`, `Invoices_InvoiceID`) VALUES (36, '2023-02-05 00:00:00', 1900.00, 'Bank Transfer', 36);
1911INSERT INTO `mydb`.`Payments` (`PaymentID`, `PaymentDate`, `Amount`, `PaymentMethod`, `Invoices_InvoiceID`) VALUES (37, '2023-02-06 00:00:00', 1850.00, 'Cash', 37);
1912INSERT INTO `mydb`.`Payments` (`PaymentID`, `PaymentDate`, `Amount`, `PaymentMethod`, `Invoices_InvoiceID`) VALUES (38, '2023-02-07 00:00:00', 2000.00, 'Credit Card', 38);
1913INSERT INTO `mydb`.`Payments` (`PaymentID`, `PaymentDate`, `Amount`, `PaymentMethod`, `Invoices_InvoiceID`) VALUES (39, '2023-02-08 00:00:00', 1950.00, 'Debit Card', 39);
1914INSERT INTO `mydb`.`Payments` (`PaymentID`, `PaymentDate`, `Amount`, `PaymentMethod`, `Invoices_InvoiceID`) VALUES (40, '2023-02-09 00:00:00', 2100.00, 'Bank Transfer', 40);
1915INSERT INTO `mydb`.`Payments` (`PaymentID`, `PaymentDate`, `Amount`, `PaymentMethod`, `Invoices_InvoiceID`) VALUES (41, '2023-02-10 00:00:00', 2050.00, 'Cash', 41);
1916INSERT INTO `mydb`.`Payments` (`PaymentID`, `PaymentDate`, `Amount`, `PaymentMethod`, `Invoices_InvoiceID`) VALUES (42, '2023-02-11 00:00:00', 2200.00, 'Credit Card', 42);
1917INSERT INTO `mydb`.`Payments` (`PaymentID`, `PaymentDate`, `Amount`, `PaymentMethod`, `Invoices_InvoiceID`) VALUES (43, '2023-02-12 00:00:00', 2150.00, 'Debit Card', 43);
1918INSERT INTO `mydb`.`Payments` (`PaymentID`, `PaymentDate`, `Amount`, `PaymentMethod`, `Invoices_InvoiceID`) VALUES (44, '2023-02-13 00:00:00', 2300.00, 'Bank Transfer', 44);
1919INSERT INTO `mydb`.`Payments` (`PaymentID`, `PaymentDate`, `Amount`, `PaymentMethod`, `Invoices_InvoiceID`) VALUES (45, '2023-02-14 00:00:00', 2250.00, 'Cash', 45);
1920INSERT INTO `mydb`.`Payments` (`PaymentID`, `PaymentDate`, `Amount`, `PaymentMethod`, `Invoices_InvoiceID`) VALUES (46, '2023-02-15 00:00:00', 2400.00, 'Credit Card', 46);
1921INSERT INTO `mydb`.`Payments` (`PaymentID`, `PaymentDate`, `Amount`, `PaymentMethod`, `Invoices_InvoiceID`) VALUES (47, '2023-02-16 00:00:00', 2350.00, 'Debit Card', 47);
1922INSERT INTO `mydb`.`Payments` (`PaymentID`, `PaymentDate`, `Amount`, `PaymentMethod`, `Invoices_InvoiceID`) VALUES (48, '2023-02-17 00:00:00', 2500.00, 'Bank Transfer', 48);
1923INSERT INTO `mydb`.`Payments` (`PaymentID`, `PaymentDate`, `Amount`, `PaymentMethod`, `Invoices_InvoiceID`) VALUES (49, '2023-02-18 00:00:00', 2450.00, 'Cash', 49);
1924INSERT INTO `mydb`.`Payments` (`PaymentID`, `PaymentDate`, `Amount`, `PaymentMethod`, `Invoices_InvoiceID`) VALUES (50, '2023-02-19 00:00:00', 2600.00, 'Credit Card', 50);
1925
1926COMMIT;
1927
1928
1929-- -----------------------------------------------------
1930-- Data for table `mydb`.`ExpenseCategories`
1931-- -----------------------------------------------------
1932START TRANSACTION;
1933USE `mydb`;
1934INSERT INTO `mydb`.`ExpenseCategories` (`ExpenseCategoryID`, `CategoryName`) VALUES (1, 'Raw Materials');
1935INSERT INTO `mydb`.`ExpenseCategories` (`ExpenseCategoryID`, `CategoryName`) VALUES (2, 'Employee Salaries');
1936INSERT INTO `mydb`.`ExpenseCategories` (`ExpenseCategoryID`, `CategoryName`) VALUES (3, 'Utilities');
1937INSERT INTO `mydb`.`ExpenseCategories` (`ExpenseCategoryID`, `CategoryName`) VALUES (4, 'Rent');
1938INSERT INTO `mydb`.`ExpenseCategories` (`ExpenseCategoryID`, `CategoryName`) VALUES (5, 'Marketing');
1939INSERT INTO `mydb`.`ExpenseCategories` (`ExpenseCategoryID`, `CategoryName`) VALUES (6, 'Travel');
1940INSERT INTO `mydb`.`ExpenseCategories` (`ExpenseCategoryID`, `CategoryName`) VALUES (7, 'Training');
1941INSERT INTO `mydb`.`ExpenseCategories` (`ExpenseCategoryID`, `CategoryName`) VALUES (8, 'Insurance');
1942INSERT INTO `mydb`.`ExpenseCategories` (`ExpenseCategoryID`, `CategoryName`) VALUES (9, 'Maintenance');
1943INSERT INTO `mydb`.`ExpenseCategories` (`ExpenseCategoryID`, `CategoryName`) VALUES (10, 'Office Supplies');
1944
1945COMMIT;
1946
1947
1948-- -----------------------------------------------------
1949-- Data for table `mydb`.`Expenses`
1950-- -----------------------------------------------------
1951START TRANSACTION;
1952USE `mydb`;
1953INSERT INTO `mydb`.`Expenses` (`ExpenseID`, `ExpenseDate`, `Amount`, `ExpenseCategories_ExpenseCategoryID`) VALUES (1, '2023-01-01 00:00:00', 100.00, 1);
1954INSERT INTO `mydb`.`Expenses` (`ExpenseID`, `ExpenseDate`, `Amount`, `ExpenseCategories_ExpenseCategoryID`) VALUES (2, '2023-01-02 00:00:00', 200.00, 2);
1955INSERT INTO `mydb`.`Expenses` (`ExpenseID`, `ExpenseDate`, `Amount`, `ExpenseCategories_ExpenseCategoryID`) VALUES (3, '2023-01-03 00:00:00', 150.00, 3);
1956INSERT INTO `mydb`.`Expenses` (`ExpenseID`, `ExpenseDate`, `Amount`, `ExpenseCategories_ExpenseCategoryID`) VALUES (4, '2023-01-04 00:00:00', 300.00, 4);
1957INSERT INTO `mydb`.`Expenses` (`ExpenseID`, `ExpenseDate`, `Amount`, `ExpenseCategories_ExpenseCategoryID`) VALUES (5, '2023-01-05 00:00:00', 250.00, 5);
1958INSERT INTO `mydb`.`Expenses` (`ExpenseID`, `ExpenseDate`, `Amount`, `ExpenseCategories_ExpenseCategoryID`) VALUES (6, '2023-01-06 00:00:00', 400.00, 6);
1959INSERT INTO `mydb`.`Expenses` (`ExpenseID`, `ExpenseDate`, `Amount`, `ExpenseCategories_ExpenseCategoryID`) VALUES (7, '2023-01-07 00:00:00', 350.00, 7);
1960INSERT INTO `mydb`.`Expenses` (`ExpenseID`, `ExpenseDate`, `Amount`, `ExpenseCategories_ExpenseCategoryID`) VALUES (8, '2023-01-08 00:00:00', 500.00, 8);
1961INSERT INTO `mydb`.`Expenses` (`ExpenseID`, `ExpenseDate`, `Amount`, `ExpenseCategories_ExpenseCategoryID`) VALUES (9, '2023-01-09 00:00:00', 450.00, 9);
1962INSERT INTO `mydb`.`Expenses` (`ExpenseID`, `ExpenseDate`, `Amount`, `ExpenseCategories_ExpenseCategoryID`) VALUES (10, '2023-01-10 00:00:00', 600.00, 10);
1963INSERT INTO `mydb`.`Expenses` (`ExpenseID`, `ExpenseDate`, `Amount`, `ExpenseCategories_ExpenseCategoryID`) VALUES (11, '2023-01-11 00:00:00', 110.00, 1);
1964INSERT INTO `mydb`.`Expenses` (`ExpenseID`, `ExpenseDate`, `Amount`, `ExpenseCategories_ExpenseCategoryID`) VALUES (12, '2023-01-12 00:00:00', 220.00, 2);
1965INSERT INTO `mydb`.`Expenses` (`ExpenseID`, `ExpenseDate`, `Amount`, `ExpenseCategories_ExpenseCategoryID`) VALUES (13, '2023-01-13 00:00:00', 160.00, 3);
1966INSERT INTO `mydb`.`Expenses` (`ExpenseID`, `ExpenseDate`, `Amount`, `ExpenseCategories_ExpenseCategoryID`) VALUES (14, '2023-01-14 00:00:00', 320.00, 4);
1967INSERT INTO `mydb`.`Expenses` (`ExpenseID`, `ExpenseDate`, `Amount`, `ExpenseCategories_ExpenseCategoryID`) VALUES (15, '2023-01-15 00:00:00', 260.00, 5);
1968INSERT INTO `mydb`.`Expenses` (`ExpenseID`, `ExpenseDate`, `Amount`, `ExpenseCategories_ExpenseCategoryID`) VALUES (16, '2023-01-16 00:00:00', 420.00, 6);
1969INSERT INTO `mydb`.`Expenses` (`ExpenseID`, `ExpenseDate`, `Amount`, `ExpenseCategories_ExpenseCategoryID`) VALUES (17, '2023-01-17 00:00:00', 360.00, 7);
1970INSERT INTO `mydb`.`Expenses` (`ExpenseID`, `ExpenseDate`, `Amount`, `ExpenseCategories_ExpenseCategoryID`) VALUES (18, '2023-01-18 00:00:00', 520.00, 8);
1971INSERT INTO `mydb`.`Expenses` (`ExpenseID`, `ExpenseDate`, `Amount`, `ExpenseCategories_ExpenseCategoryID`) VALUES (19, '2023-01-19 00:00:00', 460.00, 9);
1972INSERT INTO `mydb`.`Expenses` (`ExpenseID`, `ExpenseDate`, `Amount`, `ExpenseCategories_ExpenseCategoryID`) VALUES (20, '2023-01-20 00:00:00', 620.00, 10);
1973INSERT INTO `mydb`.`Expenses` (`ExpenseID`, `ExpenseDate`, `Amount`, `ExpenseCategories_ExpenseCategoryID`) VALUES (21, '2023-01-21 00:00:00', 120.00, 1);
1974INSERT INTO `mydb`.`Expenses` (`ExpenseID`, `ExpenseDate`, `Amount`, `ExpenseCategories_ExpenseCategoryID`) VALUES (22, '2023-01-22 00:00:00', 240.00, 2);
1975INSERT INTO `mydb`.`Expenses` (`ExpenseID`, `ExpenseDate`, `Amount`, `ExpenseCategories_ExpenseCategoryID`) VALUES (23, '2023-01-23 00:00:00', 170.00, 3);
1976INSERT INTO `mydb`.`Expenses` (`ExpenseID`, `ExpenseDate`, `Amount`, `ExpenseCategories_ExpenseCategoryID`) VALUES (24, '2023-01-24 00:00:00', 340.00, 4);
1977INSERT INTO `mydb`.`Expenses` (`ExpenseID`, `ExpenseDate`, `Amount`, `ExpenseCategories_ExpenseCategoryID`) VALUES (25, '2023-01-25 00:00:00', 270.00, 5);
1978INSERT INTO `mydb`.`Expenses` (`ExpenseID`, `ExpenseDate`, `Amount`, `ExpenseCategories_ExpenseCategoryID`) VALUES (26, '2023-01-26 00:00:00', 440.00, 6);
1979INSERT INTO `mydb`.`Expenses` (`ExpenseID`, `ExpenseDate`, `Amount`, `ExpenseCategories_ExpenseCategoryID`) VALUES (27, '2023-01-27 00:00:00', 370.00, 7);
1980INSERT INTO `mydb`.`Expenses` (`ExpenseID`, `ExpenseDate`, `Amount`, `ExpenseCategories_ExpenseCategoryID`) VALUES (28, '2023-01-28 00:00:00', 540.00, 8);
1981INSERT INTO `mydb`.`Expenses` (`ExpenseID`, `ExpenseDate`, `Amount`, `ExpenseCategories_ExpenseCategoryID`) VALUES (29, '2023-01-29 00:00:00', 470.00, 9);
1982INSERT INTO `mydb`.`Expenses` (`ExpenseID`, `ExpenseDate`, `Amount`, `ExpenseCategories_ExpenseCategoryID`) VALUES (30, '2023-01-30 00:00:00', 640.00, 10);
1983INSERT INTO `mydb`.`Expenses` (`ExpenseID`, `ExpenseDate`, `Amount`, `ExpenseCategories_ExpenseCategoryID`) VALUES (31, '2023-01-31 00:00:00', 130.00, 1);
1984INSERT INTO `mydb`.`Expenses` (`ExpenseID`, `ExpenseDate`, `Amount`, `ExpenseCategories_ExpenseCategoryID`) VALUES (32, '2023-02-01 00:00:00', 260.00, 2);
1985INSERT INTO `mydb`.`Expenses` (`ExpenseID`, `ExpenseDate`, `Amount`, `ExpenseCategories_ExpenseCategoryID`) VALUES (33, '2023-02-02 00:00:00', 180.00, 3);
1986INSERT INTO `mydb`.`Expenses` (`ExpenseID`, `ExpenseDate`, `Amount`, `ExpenseCategories_ExpenseCategoryID`) VALUES (34, '2023-02-03 00:00:00', 360.00, 4);
1987INSERT INTO `mydb`.`Expenses` (`ExpenseID`, `ExpenseDate`, `Amount`, `ExpenseCategories_ExpenseCategoryID`) VALUES (35, '2023-02-04 00:00:00', 280.00, 5);
1988INSERT INTO `mydb`.`Expenses` (`ExpenseID`, `ExpenseDate`, `Amount`, `ExpenseCategories_ExpenseCategoryID`) VALUES (36, '2023-02-05 00:00:00', 460.00, 6);
1989INSERT INTO `mydb`.`Expenses` (`ExpenseID`, `ExpenseDate`, `Amount`, `ExpenseCategories_ExpenseCategoryID`) VALUES (37, '2023-02-06 00:00:00', 380.00, 7);
1990INSERT INTO `mydb`.`Expenses` (`ExpenseID`, `ExpenseDate`, `Amount`, `ExpenseCategories_ExpenseCategoryID`) VALUES (38, '2023-02-07 00:00:00', 560.00, 8);
1991INSERT INTO `mydb`.`Expenses` (`ExpenseID`, `ExpenseDate`, `Amount`, `ExpenseCategories_ExpenseCategoryID`) VALUES (39, '2023-02-08 00:00:00', 480.00, 9);
1992INSERT INTO `mydb`.`Expenses` (`ExpenseID`, `ExpenseDate`, `Amount`, `ExpenseCategories_ExpenseCategoryID`) VALUES (40, '2023-02-09 00:00:00', 660.00, 10);
1993INSERT INTO `mydb`.`Expenses` (`ExpenseID`, `ExpenseDate`, `Amount`, `ExpenseCategories_ExpenseCategoryID`) VALUES (41, '2023-02-10 00:00:00', 140.00, 1);
1994INSERT INTO `mydb`.`Expenses` (`ExpenseID`, `ExpenseDate`, `Amount`, `ExpenseCategories_ExpenseCategoryID`) VALUES (42, '2023-02-11 00:00:00', 280.00, 2);
1995INSERT INTO `mydb`.`Expenses` (`ExpenseID`, `ExpenseDate`, `Amount`, `ExpenseCategories_ExpenseCategoryID`) VALUES (43, '2023-02-12 00:00:00', 190.00, 3);
1996INSERT INTO `mydb`.`Expenses` (`ExpenseID`, `ExpenseDate`, `Amount`, `ExpenseCategories_ExpenseCategoryID`) VALUES (44, '2023-02-13 00:00:00', 380.00, 4);
1997INSERT INTO `mydb`.`Expenses` (`ExpenseID`, `ExpenseDate`, `Amount`, `ExpenseCategories_ExpenseCategoryID`) VALUES (45, '2023-02-14 00:00:00', 290.00, 5);
1998INSERT INTO `mydb`.`Expenses` (`ExpenseID`, `ExpenseDate`, `Amount`, `ExpenseCategories_ExpenseCategoryID`) VALUES (46, '2023-02-15 00:00:00', 480.00, 6);
1999INSERT INTO `mydb`.`Expenses` (`ExpenseID`, `ExpenseDate`, `Amount`, `ExpenseCategories_ExpenseCategoryID`) VALUES (47, '2023-02-16 00:00:00', 390.00, 7);
2000INSERT INTO `mydb`.`Expenses` (`ExpenseID`, `ExpenseDate`, `Amount`, `ExpenseCategories_ExpenseCategoryID`) VALUES (48, '2023-02-17 00:00:00', 580.00, 8);
2001INSERT INTO `mydb`.`Expenses` (`ExpenseID`, `ExpenseDate`, `Amount`, `ExpenseCategories_ExpenseCategoryID`) VALUES (49, '2023-02-18 00:00:00', 500.00, 9);
2002INSERT INTO `mydb`.`Expenses` (`ExpenseID`, `ExpenseDate`, `Amount`, `ExpenseCategories_ExpenseCategoryID`) VALUES (50, '2023-02-19 00:00:00', 680.00, 10);
2003
2004COMMIT;
2005
2006
2007-- -----------------------------------------------------
2008-- Data for table `mydb`.`Accounts`
2009-- -----------------------------------------------------
2010START TRANSACTION;
2011USE `mydb`;
2012INSERT INTO `mydb`.`Accounts` (`AccountID`, `AccountName`, `Balance`) VALUES (1, 'Sales Account', 10000.00);
2013INSERT INTO `mydb`.`Accounts` (`AccountID`, `AccountName`, `Balance`) VALUES (2, 'Purchase Account', 5000.00);
2014INSERT INTO `mydb`.`Accounts` (`AccountID`, `AccountName`, `Balance`) VALUES (3, 'Payroll Account', 3000.00);
2015INSERT INTO `mydb`.`Accounts` (`AccountID`, `AccountName`, `Balance`) VALUES (4, 'General Fund', 2000.00);
2016INSERT INTO `mydb`.`Accounts` (`AccountID`, `AccountName`, `Balance`) VALUES (5, 'Marketing Budget', 1500.00);
2017INSERT INTO `mydb`.`Accounts` (`AccountID`, `AccountName`, `Balance`) VALUES (6, 'Research and Development', 2500.00);
2018INSERT INTO `mydb`.`Accounts` (`AccountID`, `AccountName`, `Balance`) VALUES (7, 'Inventory Account', 3500.00);
2019INSERT INTO `mydb`.`Accounts` (`AccountID`, `AccountName`, `Balance`) VALUES (8, 'Fixed Assets', 4000.00);
2020INSERT INTO `mydb`.`Accounts` (`AccountID`, `AccountName`, `Balance`) VALUES (9, 'Loan Account', 5500.00);
2021INSERT INTO `mydb`.`Accounts` (`AccountID`, `AccountName`, `Balance`) VALUES (10, 'Investment Account', 6000.00);
2022INSERT INTO `mydb`.`Accounts` (`AccountID`, `AccountName`, `Balance`) VALUES (11, 'Operating Expenses', 7000.00);
2023INSERT INTO `mydb`.`Accounts` (`AccountID`, `AccountName`, `Balance`) VALUES (12, 'Depreciation Account', 8000.00);
2024INSERT INTO `mydb`.`Accounts` (`AccountID`, `AccountName`, `Balance`) VALUES (13, 'Tax Account', 9000.00);
2025INSERT INTO `mydb`.`Accounts` (`AccountID`, `AccountName`, `Balance`) VALUES (14, 'Insurance Account', 10000.00);
2026INSERT INTO `mydb`.`Accounts` (`AccountID`, `AccountName`, `Balance`) VALUES (15, 'Rent Account', 11000.00);
2027INSERT INTO `mydb`.`Accounts` (`AccountID`, `AccountName`, `Balance`) VALUES (16, 'Utilities Account', 12000.00);
2028INSERT INTO `mydb`.`Accounts` (`AccountID`, `AccountName`, `Balance`) VALUES (17, 'Travel Account', 13000.00);
2029INSERT INTO `mydb`.`Accounts` (`AccountID`, `AccountName`, `Balance`) VALUES (18, 'Training Account', 14000.00);
2030INSERT INTO `mydb`.`Accounts` (`AccountID`, `AccountName`, `Balance`) VALUES (19, 'Entertainment Account', 15000.00);
2031INSERT INTO `mydb`.`Accounts` (`AccountID`, `AccountName`, `Balance`) VALUES (20, 'Charitable Contributions', 16000.00);
2032INSERT INTO `mydb`.`Accounts` (`AccountID`, `AccountName`, `Balance`) VALUES (21, 'Employee Benefits', 17000.00);
2033INSERT INTO `mydb`.`Accounts` (`AccountID`, `AccountName`, `Balance`) VALUES (22, 'Office Supplies', 18000.00);
2034INSERT INTO `mydb`.`Accounts` (`AccountID`, `AccountName`, `Balance`) VALUES (23, 'Computer Equipment', 19000.00);
2035INSERT INTO `mydb`.`Accounts` (`AccountID`, `AccountName`, `Balance`) VALUES (24, 'Furniture and Fixtures', 20000.00);
2036INSERT INTO `mydb`.`Accounts` (`AccountID`, `AccountName`, `Balance`) VALUES (25, 'Vehicles', 21000.00);
2037INSERT INTO `mydb`.`Accounts` (`AccountID`, `AccountName`, `Balance`) VALUES (26, 'Leasehold Improvements', 22000.00);
2038INSERT INTO `mydb`.`Accounts` (`AccountID`, `AccountName`, `Balance`) VALUES (27, 'Patents and Trademarks', 23000.00);
2039INSERT INTO `mydb`.`Accounts` (`AccountID`, `AccountName`, `Balance`) VALUES (28, 'Goodwill', 24000.00);
2040INSERT INTO `mydb`.`Accounts` (`AccountID`, `AccountName`, `Balance`) VALUES (29, 'Long-Term Investments', 25000.00);
2041INSERT INTO `mydb`.`Accounts` (`AccountID`, `AccountName`, `Balance`) VALUES (30, 'Retained Earnings', 26000.00);
2042INSERT INTO `mydb`.`Accounts` (`AccountID`, `AccountName`, `Balance`) VALUES (31, 'Common Stock', 27000.00);
2043INSERT INTO `mydb`.`Accounts` (`AccountID`, `AccountName`, `Balance`) VALUES (32, 'Preferred Stock', 28000.00);
2044INSERT INTO `mydb`.`Accounts` (`AccountID`, `AccountName`, `Balance`) VALUES (33, 'Dividends Payable', 29000.00);
2045INSERT INTO `mydb`.`Accounts` (`AccountID`, `AccountName`, `Balance`) VALUES (34, 'Accrued Liabilities', 30000.00);
2046INSERT INTO `mydb`.`Accounts` (`AccountID`, `AccountName`, `Balance`) VALUES (35, 'Unearned Revenue', 31000.00);
2047INSERT INTO `mydb`.`Accounts` (`AccountID`, `AccountName`, `Balance`) VALUES (36, 'Deferred Tax Liability', 32000.00);
2048INSERT INTO `mydb`.`Accounts` (`AccountID`, `AccountName`, `Balance`) VALUES (37, 'Contingent Liabilities', 33000.00);
2049INSERT INTO `mydb`.`Accounts` (`AccountID`, `AccountName`, `Balance`) VALUES (38, 'Provision for Doubtful Debts', 34000.00);
2050INSERT INTO `mydb`.`Accounts` (`AccountID`, `AccountName`, `Balance`) VALUES (39, 'Provision for Warranty Costs', 35000.00);
2051INSERT INTO `mydb`.`Accounts` (`AccountID`, `AccountName`, `Balance`) VALUES (40, 'Provision for Restructuring Costs', 36000.00);
2052INSERT INTO `mydb`.`Accounts` (`AccountID`, `AccountName`, `Balance`) VALUES (41, 'Provision for Environmental Costs', 37000.00);
2053INSERT INTO `mydb`.`Accounts` (`AccountID`, `AccountName`, `Balance`) VALUES (42, 'Provision for Legal Claims', 38000.00);
2054INSERT INTO `mydb`.`Accounts` (`AccountID`, `AccountName`, `Balance`) VALUES (43, 'Provision for Pension Costs', 39000.00);
2055INSERT INTO `mydb`.`Accounts` (`AccountID`, `AccountName`, `Balance`) VALUES (44, 'Provision for Post-Employment Benefits', 40000.00);
2056INSERT INTO `mydb`.`Accounts` (`AccountID`, `AccountName`, `Balance`) VALUES (45, 'Provision for Long-Term Care Costs', 41000.00);
2057INSERT INTO `mydb`.`Accounts` (`AccountID`, `AccountName`, `Balance`) VALUES (46, 'Provision for Asset Retirement Costs', 42000.00);
2058INSERT INTO `mydb`.`Accounts` (`AccountID`, `AccountName`, `Balance`) VALUES (47, 'Provision for Asset Impairment Costs', 43000.00);
2059INSERT INTO `mydb`.`Accounts` (`AccountID`, `AccountName`, `Balance`) VALUES (48, 'Provision for Asset Disposal Costs', 44000.00);
2060INSERT INTO `mydb`.`Accounts` (`AccountID`, `AccountName`, `Balance`) VALUES (49, 'Provision for Asset Write-Down Costs', 45000.00);
2061INSERT INTO `mydb`.`Accounts` (`AccountID`, `AccountName`, `Balance`) VALUES (50, 'Provision for Asset Revaluation Costs', 46000.00);
2062
2063COMMIT;
2064
2065
2066-- -----------------------------------------------------
2067-- Data for table `mydb`.`AccountTransactions`
2068-- -----------------------------------------------------
2069START TRANSACTION;
2070
2071USE `mydb`;
2072
2073INSERT INTO `mydb`.`AccountTransactions` (`TransactionID`, `TransactionDate`, `Amount`, `TransactionType`, `Accounts_AccountID`)
2074VALUES
2075 (1, '2023-01-01 00:00:00', 100.00, 'Доход', 1),
2076 (2, '2023-01-02 00:00:00', 200.00, 'Расход', 2),
2077 (3, '2023-01-03 00:00:00', 150.00, 'Доход', 3),
2078 (4, '2023-01-04 00:00:00', 300.00, 'Расход', 4),
2079 (5, '2023-01-05 00:00:00', 250.00, 'Доход', 5),
2080 (6, '2023-01-06 00:00:00', 400.00, 'Расход', 6),
2081 (7, '2023-01-07 00:00:00', 350.00, 'Доход', 7),
2082 (8, '2023-01-08 00:00:00', 500.00, 'Расход', 8),
2083 (9, '2023-01-09 00:00:00', 450.00, 'Доход', 9),
2084 (10, '2023-01-10 00:00:00', 600.00, 'Расход', 10),
2085 (11, '2023-01-11 00:00:00', 550.00, 'Доход', 11),
2086 (12, '2023-01-12 00:00:00', 700.00, 'Расход', 12),
2087 (13, '2023-01-13 00:00:00', 650.00, 'Доход', 13),
2088 (14, '2023-01-14 00:00:00', 800.00, 'Расход', 14),
2089 (15, '2023-01-15 00:00:00', 750.00, 'Доход', 15),
2090 (16, '2023-01-16 00:00:00', 900.00, 'Расход', 16),
2091 (17, '2023-01-17 00:00:00', 850.00, 'Доход', 17),
2092 (18, '2023-01-18 00:00:00', 1000.00, 'Расход', 18),
2093 (19, '2023-01-19 00:00:00', 950.00, 'Доход', 19),
2094 (20, '2023-01-20 00:00:00', 1100.00, 'Расход', 20),
2095 (21, '2023-01-21 00:00:00', 1050.00, 'Доход', 21),
2096 (22, '2023-01-22 00:00:00', 1200.00, 'Расход', 22),
2097 (23, '2023-01-23 00:00:00', 1150.00, 'Доход', 23),
2098 (24, '2023-01-24 00:00:00', 1300.00, 'Расход', 24),
2099 (25, '2023-01-25 00:00:00', 1250.00, 'Доход', 25),
2100 (26, '2023-01-26 00:00:00', 1400.00, 'Расход', 26),
2101 (27, '2023-01-27 00:00:00', 1350.00, 'Доход', 27),
2102 (28, '2023-01-28 00:00:00', 1500.00, 'Расход', 28),
2103 (29, '2023-01-29 00:00:00', 1450.00, 'Доход', 29),
2104 (30, '2023-01-30 00:00:00', 1600.00, 'Расход', 30),
2105 (31, '2023-01-31 00:00:00', 1550.00, 'Доход', 31),
2106 (32, '2023-02-01 00:00:00', 1700.00, 'Расход', 32),
2107 (33, '2023-02-02 00:00:00', 1650.00, 'Доход', 33),
2108 (34, '2023-02-03 00:00:00', 1800.00, 'Расход', 34),
2109 (35, '2023-02-04 00:00:00', 1750.00, 'Доход', 35),
2110 (36, '2023-02-05 00:00:00', 1900.00, 'Расход', 36),
2111 (37, '2023-02-06 00:00:00', 1850.00, 'Доход', 37),
2112 (38, '2023-02-07 00:00:00', 2000.00, 'Расход', 38),
2113 (39, '2023-02-08 00:00:00', 1950.00, 'Доход', 39),
2114 (40, '2023-02-09 00:00:00', 2100.00, 'Расход', 40),
2115 (41, '2023-02-10 00:00:00', 2050.00, 'Доход', 41),
2116 (42, '2023-02-11 00:00:00', 2200.00, 'Расход', 42),
2117 (43, '2023-02-12 00:00:00', 2150.00, 'Доход', 43),
2118 (44, '2023-02-13 00:00:00', 2300.00, 'Расход', 44),
2119 (45, '2023-02-14 00:00:00', 2250.00, 'Доход', 45),
2120 (46, '2023-02-15 00:00:00', 2400.00, 'Расход', 46),
2121 (47, '2023-02-16 00:00:00', 2350.00, 'Доход', 47),
2122 (48, '2023-02-17 00:00:00', 2500.00, 'Расход', 48),
2123 (49, '2023-02-18 00:00:00', 2450.00, 'Доход', 49),
2124 (50, '2023-02-19 00:00:00', 2600.00, 'Расход', 50);
2125
2126COMMIT;
2127
2128-- -----------------------------------------------------
2129-- Data for table `mydb`.`Departments`
2130-- -----------------------------------------------------
2131START TRANSACTION;
2132USE `mydb`;
2133INSERT INTO `mydb`.`Departments` (`DepartmentID`, `DepartmentName`) VALUES (1, 'Production');
2134INSERT INTO `mydb`.`Departments` (`DepartmentID`, `DepartmentName`) VALUES (2, 'Finance');
2135INSERT INTO `mydb`.`Departments` (`DepartmentID`, `DepartmentName`) VALUES (3, 'HR');
2136INSERT INTO `mydb`.`Departments` (`DepartmentID`, `DepartmentName`) VALUES (4, 'Marketing');
2137INSERT INTO `mydb`.`Departments` (`DepartmentID`, `DepartmentName`) VALUES (5, 'IT');
2138
2139COMMIT;
2140
2141
2142-- -----------------------------------------------------
2143-- Data for table `mydb`.`Employees`
2144-- -----------------------------------------------------
2145START TRANSACTION;
2146USE `mydb`;
2147INSERT INTO `mydb`.`Employees` (`EmployeeID`, `Name`, `Position`, `ContactInfo`) VALUES (1, 'Artem Vladimirov', 'Engineer', 'artem.vladimirov@example.com');
2148INSERT INTO `mydb`.`Employees` (`EmployeeID`, `Name`, `Position`, `ContactInfo`) VALUES (2, 'Sofia Kozlova', 'Technician', 'sofia.kozlova@example.com');
2149INSERT INTO `mydb`.`Employees` (`EmployeeID`, `Name`, `Position`, `ContactInfo`) VALUES (3, 'Daniil Morozov', 'Technician', 'daniil.morozov@example.com');
2150INSERT INTO `mydb`.`Employees` (`EmployeeID`, `Name`, `Position`, `ContactInfo`) VALUES (4, 'Anastasia Volkova', 'Accountant', 'anastasia.volkova@example.com');
2151INSERT INTO `mydb`.`Employees` (`EmployeeID`, `Name`, `Position`, `ContactInfo`) VALUES (5, 'Mikhail Ivanov', 'HR Specialist', 'mikhail.ivanov@example.com');
2152INSERT INTO `mydb`.`Employees` (`EmployeeID`, `Name`, `Position`, `ContactInfo`) VALUES (6, 'Yulia Petrova', 'Designer', 'yulia.petrova@example.com');
2153INSERT INTO `mydb`.`Employees` (`EmployeeID`, `Name`, `Position`, `ContactInfo`) VALUES (7, 'Roman Sidorov', 'Analyst', 'roman.sidorov@example.com');
2154INSERT INTO `mydb`.`Employees` (`EmployeeID`, `Name`, `Position`, `ContactInfo`) VALUES (8, 'Ekaterina Fedorova', 'Developer', 'ekaterina.fedorova@example.com');
2155INSERT INTO `mydb`.`Employees` (`EmployeeID`, `Name`, `Position`, `ContactInfo`) VALUES (9, 'Alexander Smirnov', 'Secretary', 'alexander.smirnov@example.com');
2156INSERT INTO `mydb`.`Employees` (`EmployeeID`, `Name`, `Position`, `ContactInfo`) VALUES (10, 'Viktor Vasiliev', 'Supervisor', 'viktor.vasiliev@example.com');
2157INSERT INTO `mydb`.`Employees` (`EmployeeID`, `Name`, `Position`, `ContactInfo`) VALUES (11, 'Natalia Kovaleva', 'Consultant', 'natalia.kovaleva@example.com');
2158INSERT INTO `mydb`.`Employees` (`EmployeeID`, `Name`, `Position`, `ContactInfo`) VALUES (12, 'Denis Mikhailov', 'Specialist', 'denis.mikhailov@example.com');
2159INSERT INTO `mydb`.`Employees` (`EmployeeID`, `Name`, `Position`, `ContactInfo`) VALUES (13, 'Polina Egorova', 'Coordinator', 'polina.egorova@example.com');
2160INSERT INTO `mydb`.`Employees` (`EmployeeID`, `Name`, `Position`, `ContactInfo`) VALUES (14, 'Konstantin Pavlov', 'Lead', 'konstantin.pavlov@example.com');
2161INSERT INTO `mydb`.`Employees` (`EmployeeID`, `Name`, `Position`, `ContactInfo`) VALUES (15, 'Alina Sokolova', 'Assistant', 'alina.sokolova@example.com');
2162INSERT INTO `mydb`.`Employees` (`EmployeeID`, `Name`, `Position`, `ContactInfo`) VALUES (16, 'Ilya Zakharyev', 'Operator', 'ilya.zakharyev@example.com');
2163INSERT INTO `mydb`.`Employees` (`EmployeeID`, `Name`, `Position`, `ContactInfo`) VALUES (17, 'Egor Grigoryev', 'Analyst', 'egor.grigoryev@example.com');
2164INSERT INTO `mydb`.`Employees` (`EmployeeID`, `Name`, `Position`, `ContactInfo`) VALUES (18, 'Tatiana Romanova', 'Specialist', 'tatiana.romanova@example.com');
2165INSERT INTO `mydb`.`Employees` (`EmployeeID`, `Name`, `Position`, `ContactInfo`) VALUES (19, 'Aleksey Shevchenko', 'Engineer', 'aleksey.shevchenko@example.com');
2166INSERT INTO `mydb`.`Employees` (`EmployeeID`, `Name`, `Position`, `ContactInfo`) VALUES (20, 'Ksenia Kuznetsova', 'Technician', 'ksenia.kuznetsova@example.com');
2167INSERT INTO `mydb`.`Employees` (`EmployeeID`, `Name`, `Position`, `ContactInfo`) VALUES (21, 'Matvey Lebedev', 'Technician', 'matvey.lebedev@example.com');
2168INSERT INTO `mydb`.`Employees` (`EmployeeID`, `Name`, `Position`, `ContactInfo`) VALUES (22, 'Valeria Volkova', 'Accountant', 'valeria.volkova@example.com');
2169INSERT INTO `mydb`.`Employees` (`EmployeeID`, `Name`, `Position`, `ContactInfo`) VALUES (23, 'Andrei Morozov', 'HR Specialist', 'andrei.morozov@example.com');
2170INSERT INTO `mydb`.`Employees` (`EmployeeID`, `Name`, `Position`, `ContactInfo`) VALUES (24, 'Nikita Nikitin', 'Designer', 'nikita.nikitin@example.com');
2171INSERT INTO `mydb`.`Employees` (`EmployeeID`, `Name`, `Position`, `ContactInfo`) VALUES (25, 'Veronika Fedorova', 'Developer', 'veronika.fedorova@example.com');
2172INSERT INTO `mydb`.`Employees` (`EmployeeID`, `Name`, `Position`, `ContactInfo`) VALUES (26, 'Maxim Filippov', 'Secretary', 'maxim.filippov@example.com');
2173INSERT INTO `mydb`.`Employees` (`EmployeeID`, `Name`, `Position`, `ContactInfo`) VALUES (27, 'Dmitry Stepanov', 'Technician', 'dmitry.stepanov@example.com');
2174INSERT INTO `mydb`.`Employees` (`EmployeeID`, `Name`, `Position`, `ContactInfo`) VALUES (28, 'Pavel Ivanov', 'Consultant', 'pavel.ivanov@example.com');
2175INSERT INTO `mydb`.`Employees` (`EmployeeID`, `Name`, `Position`, `ContactInfo`) VALUES (29, 'Oksana Sidorova', 'Specialist', 'oksana.sidorova@example.com');
2176INSERT INTO `mydb`.`Employees` (`EmployeeID`, `Name`, `Position`, `ContactInfo`) VALUES (30, 'Grigory Kuznetsov', 'Technician', 'grigory.kuznetsov@example.com');
2177INSERT INTO `mydb`.`Employees` (`EmployeeID`, `Name`, `Position`, `ContactInfo`) VALUES (31, 'Karina Morozova', 'Assistant', 'karina.morozova@example.com');
2178INSERT INTO `mydb`.`Employees` (`EmployeeID`, `Name`, `Position`, `ContactInfo`) VALUES (32, 'Ilia Nikolaev', 'Engineer', 'ilia.nikolaev@example.com');
2179INSERT INTO `mydb`.`Employees` (`EmployeeID`, `Name`, `Position`, `ContactInfo`) VALUES (33, 'Aleksandra Fedorova', 'Technician', 'aleksandra.fedorova@example.com');
2180INSERT INTO `mydb`.`Employees` (`EmployeeID`, `Name`, `Position`, `ContactInfo`) VALUES (34, 'Sergey Alekseev', 'Accountant', 'sergey.alekseev@example.com');
2181INSERT INTO `mydb`.`Employees` (`EmployeeID`, `Name`, `Position`, `ContactInfo`) VALUES (35, 'Mariya Smirnova', 'Technician', 'mariya.smirnova@example.com');
2182INSERT INTO `mydb`.`Employees` (`EmployeeID`, `Name`, `Position`, `ContactInfo`) VALUES (36, 'Vladislav Vasiliev', 'Manager', 'vladislav.vasiliev@example.com');
2183INSERT INTO `mydb`.`Employees` (`EmployeeID`, `Name`, `Position`, `ContactInfo`) VALUES (37, 'Elizaveta Kovaleva', 'Designer', 'elizaveta.kovaleva@example.com');
2184INSERT INTO `mydb`.`Employees` (`EmployeeID`, `Name`, `Position`, `ContactInfo`) VALUES (38, 'Evgeniy Mikhailov', 'Specialist', 'evgeniy.mikhailov@example.com');
2185INSERT INTO `mydb`.`Employees` (`EmployeeID`, `Name`, `Position`, `ContactInfo`) VALUES (39, 'Darya Egorova', 'Developer', 'darya.egorova@example.com');
2186INSERT INTO `mydb`.`Employees` (`EmployeeID`, `Name`, `Position`, `ContactInfo`) VALUES (40, 'Ivan Pavlov', 'Technician', 'ivan.pavlov@example.com');
2187INSERT INTO `mydb`.`Employees` (`EmployeeID`, `Name`, `Position`, `ContactInfo`) VALUES (41, 'Anna Sokolova', 'Assistant', 'anna.sokolova@example.com');
2188INSERT INTO `mydb`.`Employees` (`EmployeeID`, `Name`, `Position`, `ContactInfo`) VALUES (42, 'Aleksey Zakharyev', 'Engineer', 'aleksey.zakharyev@example.com');
2189INSERT INTO `mydb`.`Employees` (`EmployeeID`, `Name`, `Position`, `ContactInfo`) VALUES (43, 'Mark Grigoryev', 'Technician', 'mark.grigoryev@example.com');
2190INSERT INTO `mydb`.`Employees` (`EmployeeID`, `Name`, `Position`, `ContactInfo`) VALUES (44, 'Viktoria Romanova', 'Accountant', 'viktoria.romanova@example.com');
2191INSERT INTO `mydb`.`Employees` (`EmployeeID`, `Name`, `Position`, `ContactInfo`) VALUES (45, 'Vadim Shevchenko', 'Technician', 'vadim.shevchenko@example.com');
2192INSERT INTO `mydb`.`Employees` (`EmployeeID`, `Name`, `Position`, `ContactInfo`) VALUES (46, 'Olga Kuznetsova', 'Consultant', 'olga.kuznetsova@example.com');
2193INSERT INTO `mydb`.`Employees` (`EmployeeID`, `Name`, `Position`, `ContactInfo`) VALUES (47, 'Dmitriy Lebedev', 'Specialist', 'dmitriy.lebedev@example.com');
2194INSERT INTO `mydb`.`Employees` (`EmployeeID`, `Name`, `Position`, `ContactInfo`) VALUES (48, 'Anastasiya Volkova', 'Technician', 'anastasiya.volkova@example.com');
2195INSERT INTO `mydb`.`Employees` (`EmployeeID`, `Name`, `Position`, `ContactInfo`) VALUES (49, 'Anton Morozov', 'Assistant', 'anton.morozov@example.com');
2196INSERT INTO `mydb`.`Employees` (`EmployeeID`, `Name`, `Position`, `ContactInfo`) VALUES (50, 'Nikolay Nikitin', 'Engineer', 'nikolay.nikitin@example.com');
2197
2198COMMIT;
2199
2200
2201START TRANSACTION;
2202
2203USE `mydb`;
2204
2205-- Связываем сотрудников с департаментами
2206INSERT INTO `mydb`.`EmployeeDepartments` (`Departments_DepartmentID`, `Employees_EmployeeID`)
2207VALUES
2208 -- Производство (Production)
2209 (1, 1), -- Artem Vladimirov
2210 (1, 7),
2211 (1, 13),
2212 (1, 19),
2213 (1, 25),
2214 (1, 31),
2215 (1, 37),
2216 (1, 43),
2217 (1, 49),
2218
2219 -- Финансы (Finance)
2220 (2, 4),
2221 (2, 10),
2222 (2, 16),
2223 (2, 22),
2224 (2, 28),
2225 (2, 34),
2226 (2, 40),
2227 (2, 46),
2228
2229 -- HR
2230 (3, 5),
2231 (3, 11),
2232 (3, 17),
2233 (3, 23),
2234 (3, 29),
2235 (3, 35),
2236 (3, 41),
2237 (3, 47),
2238
2239 -- Маркетинг (Marketing)
2240 (4, 6),
2241 (4, 12),
2242 (4, 18),
2243 (4, 24),
2244 (4, 30),
2245 (4, 36),
2246 (4, 42),
2247 (4, 48),
2248
2249 -- IT
2250 (5, 8),
2251 (5, 14),
2252 (5, 20),
2253 (5, 26),
2254 (5, 32),
2255 (5, 38),
2256 (5, 44),
2257 (5, 50);
2258
2259COMMIT;
2260
2261-- -----------------------------------------------------
2262-- Data for table `mydb`.`Salaries`
2263-- -----------------------------------------------------
2264START TRANSACTION;
2265USE `mydb`;
2266INSERT INTO `mydb`.`Salaries` (`SalaryID`, `SalaryDate`, `Amount`, `Employees_EmployeeID`) VALUES (1, '2023-01-01', 5000.00, 1);
2267INSERT INTO `mydb`.`Salaries` (`SalaryID`, `SalaryDate`, `Amount`, `Employees_EmployeeID`) VALUES (2, '2023-01-02', 6000.00, 2);
2268INSERT INTO `mydb`.`Salaries` (`SalaryID`, `SalaryDate`, `Amount`, `Employees_EmployeeID`) VALUES (3, '2023-01-03', 5500.00, 3);
2269INSERT INTO `mydb`.`Salaries` (`SalaryID`, `SalaryDate`, `Amount`, `Employees_EmployeeID`) VALUES (4, '2023-01-04', 7000.00, 4);
2270INSERT INTO `mydb`.`Salaries` (`SalaryID`, `SalaryDate`, `Amount`, `Employees_EmployeeID`) VALUES (5, '2023-01-05', 6500.00, 5);
2271INSERT INTO `mydb`.`Salaries` (`SalaryID`, `SalaryDate`, `Amount`, `Employees_EmployeeID`) VALUES (6, '2023-01-06', 8000.00, 6);
2272INSERT INTO `mydb`.`Salaries` (`SalaryID`, `SalaryDate`, `Amount`, `Employees_EmployeeID`) VALUES (7, '2023-01-07', 7500.00, 7);
2273INSERT INTO `mydb`.`Salaries` (`SalaryID`, `SalaryDate`, `Amount`, `Employees_EmployeeID`) VALUES (8, '2023-01-08', 9000.00, 8);
2274INSERT INTO `mydb`.`Salaries` (`SalaryID`, `SalaryDate`, `Amount`, `Employees_EmployeeID`) VALUES (9, '2023-01-09', 8500.00, 9);
2275INSERT INTO `mydb`.`Salaries` (`SalaryID`, `SalaryDate`, `Amount`, `Employees_EmployeeID`) VALUES (10, '2023-01-10', 10000.00, 10);
2276INSERT INTO `mydb`.`Salaries` (`SalaryID`, `SalaryDate`, `Amount`, `Employees_EmployeeID`) VALUES (11, '2023-01-11', 9500.00, 11);
2277INSERT INTO `mydb`.`Salaries` (`SalaryID`, `SalaryDate`, `Amount`, `Employees_EmployeeID`) VALUES (12, '2023-01-12', 11000.00, 12);
2278INSERT INTO `mydb`.`Salaries` (`SalaryID`, `SalaryDate`, `Amount`, `Employees_EmployeeID`) VALUES (13, '2023-01-13', 10500.00, 13);
2279INSERT INTO `mydb`.`Salaries` (`SalaryID`, `SalaryDate`, `Amount`, `Employees_EmployeeID`) VALUES (14, '2023-01-14', 12000.00, 14);
2280INSERT INTO `mydb`.`Salaries` (`SalaryID`, `SalaryDate`, `Amount`, `Employees_EmployeeID`) VALUES (15, '2023-01-15', 11500.00, 15);
2281INSERT INTO `mydb`.`Salaries` (`SalaryID`, `SalaryDate`, `Amount`, `Employees_EmployeeID`) VALUES (16, '2023-01-16', 13000.00, 16);
2282INSERT INTO `mydb`.`Salaries` (`SalaryID`, `SalaryDate`, `Amount`, `Employees_EmployeeID`) VALUES (17, '2023-01-17', 12500.00, 17);
2283INSERT INTO `mydb`.`Salaries` (`SalaryID`, `SalaryDate`, `Amount`, `Employees_EmployeeID`) VALUES (18, '2023-01-18', 14000.00, 18);
2284INSERT INTO `mydb`.`Salaries` (`SalaryID`, `SalaryDate`, `Amount`, `Employees_EmployeeID`) VALUES (19, '2023-01-19', 13500.00, 19);
2285INSERT INTO `mydb`.`Salaries` (`SalaryID`, `SalaryDate`, `Amount`, `Employees_EmployeeID`) VALUES (20, '2023-01-20', 15000.00, 20);
2286INSERT INTO `mydb`.`Salaries` (`SalaryID`, `SalaryDate`, `Amount`, `Employees_EmployeeID`) VALUES (21, '2023-01-21', 14500.00, 21);
2287INSERT INTO `mydb`.`Salaries` (`SalaryID`, `SalaryDate`, `Amount`, `Employees_EmployeeID`) VALUES (22, '2023-01-22', 16000.00, 22);
2288INSERT INTO `mydb`.`Salaries` (`SalaryID`, `SalaryDate`, `Amount`, `Employees_EmployeeID`) VALUES (23, '2023-01-23', 15500.00, 23);
2289INSERT INTO `mydb`.`Salaries` (`SalaryID`, `SalaryDate`, `Amount`, `Employees_EmployeeID`) VALUES (24, '2023-01-24', 17000.00, 24);
2290INSERT INTO `mydb`.`Salaries` (`SalaryID`, `SalaryDate`, `Amount`, `Employees_EmployeeID`) VALUES (25, '2023-01-25', 16500.00, 25);
2291INSERT INTO `mydb`.`Salaries` (`SalaryID`, `SalaryDate`, `Amount`, `Employees_EmployeeID`) VALUES (26, '2023-01-26', 18000.00, 26);
2292INSERT INTO `mydb`.`Salaries` (`SalaryID`, `SalaryDate`, `Amount`, `Employees_EmployeeID`) VALUES (27, '2023-01-27', 17500.00, 27);
2293INSERT INTO `mydb`.`Salaries` (`SalaryID`, `SalaryDate`, `Amount`, `Employees_EmployeeID`) VALUES (28, '2023-01-28', 19000.00, 28);
2294INSERT INTO `mydb`.`Salaries` (`SalaryID`, `SalaryDate`, `Amount`, `Employees_EmployeeID`) VALUES (29, '2023-01-29', 18500.00, 29);
2295INSERT INTO `mydb`.`Salaries` (`SalaryID`, `SalaryDate`, `Amount`, `Employees_EmployeeID`) VALUES (30, '2023-01-30', 20000.00, 30);
2296INSERT INTO `mydb`.`Salaries` (`SalaryID`, `SalaryDate`, `Amount`, `Employees_EmployeeID`) VALUES (31, '2023-02-01', 19500.00, 31);
2297INSERT INTO `mydb`.`Salaries` (`SalaryID`, `SalaryDate`, `Amount`, `Employees_EmployeeID`) VALUES (32, '2023-02-02', 21000.00, 32);
2298INSERT INTO `mydb`.`Salaries` (`SalaryID`, `SalaryDate`, `Amount`, `Employees_EmployeeID`) VALUES (33, '2023-02-03', 20500.00, 33);
2299INSERT INTO `mydb`.`Salaries` (`SalaryID`, `SalaryDate`, `Amount`, `Employees_EmployeeID`) VALUES (34, '2023-02-04', 22000.00, 34);
2300INSERT INTO `mydb`.`Salaries` (`SalaryID`, `SalaryDate`, `Amount`, `Employees_EmployeeID`) VALUES (35, '2023-02-05', 21500.00, 35);
2301INSERT INTO `mydb`.`Salaries` (`SalaryID`, `SalaryDate`, `Amount`, `Employees_EmployeeID`) VALUES (36, '2023-02-06', 23000.00, 36);
2302INSERT INTO `mydb`.`Salaries` (`SalaryID`, `SalaryDate`, `Amount`, `Employees_EmployeeID`) VALUES (37, '2023-02-07', 22500.00, 37);
2303INSERT INTO `mydb`.`Salaries` (`SalaryID`, `SalaryDate`, `Amount`, `Employees_EmployeeID`) VALUES (38, '2023-02-08', 24000.00, 38);
2304INSERT INTO `mydb`.`Salaries` (`SalaryID`, `SalaryDate`, `Amount`, `Employees_EmployeeID`) VALUES (39, '2023-02-09', 23500.00, 39);
2305INSERT INTO `mydb`.`Salaries` (`SalaryID`, `SalaryDate`, `Amount`, `Employees_EmployeeID`) VALUES (40, '2023-02-10', 25000.00, 40);
2306INSERT INTO `mydb`.`Salaries` (`SalaryID`, `SalaryDate`, `Amount`, `Employees_EmployeeID`) VALUES (41, '2023-02-11', 24500.00, 41);
2307INSERT INTO `mydb`.`Salaries` (`SalaryID`, `SalaryDate`, `Amount`, `Employees_EmployeeID`) VALUES (42, '2023-02-12', 26000.00, 42);
2308INSERT INTO `mydb`.`Salaries` (`SalaryID`, `SalaryDate`, `Amount`, `Employees_EmployeeID`) VALUES (43, '2023-02-13', 25500.00, 43);
2309INSERT INTO `mydb`.`Salaries` (`SalaryID`, `SalaryDate`, `Amount`, `Employees_EmployeeID`) VALUES (44, '2023-02-14', 27000.00, 44);
2310INSERT INTO `mydb`.`Salaries` (`SalaryID`, `SalaryDate`, `Amount`, `Employees_EmployeeID`) VALUES (45, '2023-02-15', 26500.00, 45);
2311INSERT INTO `mydb`.`Salaries` (`SalaryID`, `SalaryDate`, `Amount`, `Employees_EmployeeID`) VALUES (46, '2023-02-16', 28000.00, 46);
2312INSERT INTO `mydb`.`Salaries` (`SalaryID`, `SalaryDate`, `Amount`, `Employees_EmployeeID`) VALUES (47, '2023-02-17', 27500.00, 47);
2313INSERT INTO `mydb`.`Salaries` (`SalaryID`, `SalaryDate`, `Amount`, `Employees_EmployeeID`) VALUES (48, '2023-02-18', 29000.00, 48);
2314INSERT INTO `mydb`.`Salaries` (`SalaryID`, `SalaryDate`, `Amount`, `Employees_EmployeeID`) VALUES (49, '2023-02-19', 28500.00, 49);
2315INSERT INTO `mydb`.`Salaries` (`SalaryID`, `SalaryDate`, `Amount`, `Employees_EmployeeID`) VALUES (50, '2023-02-20', 30000.00, 50);
2316
2317COMMIT;
2318
2319
2320-- -----------------------------------------------------
2321-- Data for table `mydb`.`WorkSchedules`
2322-- -----------------------------------------------------
2323START TRANSACTION;
2324USE `mydb`;
2325INSERT INTO `mydb`.`WorkSchedules` (`ScheduleID`, `WorkDate`, `StartTime`, `EndTime`, `Employees_EmployeeID`) VALUES (1, '2023-01-01 00:00:00', '08:00:00', '17:00:00', 1);
2326INSERT INTO `mydb`.`WorkSchedules` (`ScheduleID`, `WorkDate`, `StartTime`, `EndTime`, `Employees_EmployeeID`) VALUES (2, '2023-01-02 00:00:00', '08:00:00', '17:00:00', 2);
2327INSERT INTO `mydb`.`WorkSchedules` (`ScheduleID`, `WorkDate`, `StartTime`, `EndTime`, `Employees_EmployeeID`) VALUES (3, '2023-01-03 00:00:00', '08:00:00', '17:00:00', 3);
2328INSERT INTO `mydb`.`WorkSchedules` (`ScheduleID`, `WorkDate`, `StartTime`, `EndTime`, `Employees_EmployeeID`) VALUES (4, '2023-01-04 00:00:00', '08:00:00', '17:00:00', 4);
2329INSERT INTO `mydb`.`WorkSchedules` (`ScheduleID`, `WorkDate`, `StartTime`, `EndTime`, `Employees_EmployeeID`) VALUES (5, '2023-01-05 00:00:00', '08:00:00', '17:00:00', 5);
2330INSERT INTO `mydb`.`WorkSchedules` (`ScheduleID`, `WorkDate`, `StartTime`, `EndTime`, `Employees_EmployeeID`) VALUES (6, '2023-01-06 00:00:00', '08:00:00', '17:00:00', 6);
2331INSERT INTO `mydb`.`WorkSchedules` (`ScheduleID`, `WorkDate`, `StartTime`, `EndTime`, `Employees_EmployeeID`) VALUES (7, '2023-01-07 00:00:00', '08:00:00', '17:00:00', 7);
2332INSERT INTO `mydb`.`WorkSchedules` (`ScheduleID`, `WorkDate`, `StartTime`, `EndTime`, `Employees_EmployeeID`) VALUES (8, '2023-01-08 00:00:00', '08:00:00', '17:00:00', 8);
2333INSERT INTO `mydb`.`WorkSchedules` (`ScheduleID`, `WorkDate`, `StartTime`, `EndTime`, `Employees_EmployeeID`) VALUES (9, '2023-01-09 00:00:00', '08:00:00', '17:00:00', 9);
2334INSERT INTO `mydb`.`WorkSchedules` (`ScheduleID`, `WorkDate`, `StartTime`, `EndTime`, `Employees_EmployeeID`) VALUES (10, '2023-01-10 00:00:00', '08:00:00', '17:00:00', 10);
2335INSERT INTO `mydb`.`WorkSchedules` (`ScheduleID`, `WorkDate`, `StartTime`, `EndTime`, `Employees_EmployeeID`) VALUES (11, '2023-01-11 00:00:00', '08:00:00', '17:00:00', 11);
2336INSERT INTO `mydb`.`WorkSchedules` (`ScheduleID`, `WorkDate`, `StartTime`, `EndTime`, `Employees_EmployeeID`) VALUES (12, '2023-01-12 00:00:00', '08:00:00', '17:00:00', 12);
2337INSERT INTO `mydb`.`WorkSchedules` (`ScheduleID`, `WorkDate`, `StartTime`, `EndTime`, `Employees_EmployeeID`) VALUES (13, '2023-01-13 00:00:00', '08:00:00', '17:00:00', 13);
2338INSERT INTO `mydb`.`WorkSchedules` (`ScheduleID`, `WorkDate`, `StartTime`, `EndTime`, `Employees_EmployeeID`) VALUES (14, '2023-01-14 00:00:00', '08:00:00', '17:00:00', 14);
2339INSERT INTO `mydb`.`WorkSchedules` (`ScheduleID`, `WorkDate`, `StartTime`, `EndTime`, `Employees_EmployeeID`) VALUES (15, '2023-01-15 00:00:00', '08:00:00', '17:00:00', 15);
2340INSERT INTO `mydb`.`WorkSchedules` (`ScheduleID`, `WorkDate`, `StartTime`, `EndTime`, `Employees_EmployeeID`) VALUES (16, '2023-01-16 00:00:00', '08:00:00', '17:00:00', 16);
2341INSERT INTO `mydb`.`WorkSchedules` (`ScheduleID`, `WorkDate`, `StartTime`, `EndTime`, `Employees_EmployeeID`) VALUES (17, '2023-01-17 00:00:00', '08:00:00', '17:00:00', 17);
2342INSERT INTO `mydb`.`WorkSchedules` (`ScheduleID`, `WorkDate`, `StartTime`, `EndTime`, `Employees_EmployeeID`) VALUES (18, '2023-01-18 00:00:00', '08:00:00', '17:00:00', 18);
2343INSERT INTO `mydb`.`WorkSchedules` (`ScheduleID`, `WorkDate`, `StartTime`, `EndTime`, `Employees_EmployeeID`) VALUES (19, '2023-01-19 00:00:00', '08:00:00', '17:00:00', 19);
2344INSERT INTO `mydb`.`WorkSchedules` (`ScheduleID`, `WorkDate`, `StartTime`, `EndTime`, `Employees_EmployeeID`) VALUES (20, '2023-01-20 00:00:00', '08:00:00', '17:00:00', 20);
2345INSERT INTO `mydb`.`WorkSchedules` (`ScheduleID`, `WorkDate`, `StartTime`, `EndTime`, `Employees_EmployeeID`) VALUES (21, '2023-01-21 00:00:00', '08:00:00', '17:00:00', 21);
2346INSERT INTO `mydb`.`WorkSchedules` (`ScheduleID`, `WorkDate`, `StartTime`, `EndTime`, `Employees_EmployeeID`) VALUES (22, '2023-01-22 00:00:00', '08:00:00', '17:00:00', 22);
2347INSERT INTO `mydb`.`WorkSchedules` (`ScheduleID`, `WorkDate`, `StartTime`, `EndTime`, `Employees_EmployeeID`) VALUES (23, '2023-01-23 00:00:00', '08:00:00', '17:00:00', 23);
2348INSERT INTO `mydb`.`WorkSchedules` (`ScheduleID`, `WorkDate`, `StartTime`, `EndTime`, `Employees_EmployeeID`) VALUES (24, '2023-01-24 00:00:00', '08:00:00', '17:00:00', 24);
2349INSERT INTO `mydb`.`WorkSchedules` (`ScheduleID`, `WorkDate`, `StartTime`, `EndTime`, `Employees_EmployeeID`) VALUES (25, '2023-01-25 00:00:00', '08:00:00', '17:00:00', 25);
2350INSERT INTO `mydb`.`WorkSchedules` (`ScheduleID`, `WorkDate`, `StartTime`, `EndTime`, `Employees_EmployeeID`) VALUES (26, '2023-01-26 00:00:00', '08:00:00', '17:00:00', 26);
2351INSERT INTO `mydb`.`WorkSchedules` (`ScheduleID`, `WorkDate`, `StartTime`, `EndTime`, `Employees_EmployeeID`) VALUES (27, '2023-01-27 00:00:00', '08:00:00', '17:00:00', 27);
2352INSERT INTO `mydb`.`WorkSchedules` (`ScheduleID`, `WorkDate`, `StartTime`, `EndTime`, `Employees_EmployeeID`) VALUES (28, '2023-01-28 00:00:00', '08:00:00', '17:00:00', 28);
2353INSERT INTO `mydb`.`WorkSchedules` (`ScheduleID`, `WorkDate`, `StartTime`, `EndTime`, `Employees_EmployeeID`) VALUES (29, '2023-01-29 00:00:00', '08:00:00', '17:00:00', 29);
2354INSERT INTO `mydb`.`WorkSchedules` (`ScheduleID`, `WorkDate`, `StartTime`, `EndTime`, `Employees_EmployeeID`) VALUES (30, '2023-01-30 00:00:00', '08:00:00', '17:00:00', 30);
2355INSERT INTO `mydb`.`WorkSchedules` (`ScheduleID`, `WorkDate`, `StartTime`, `EndTime`, `Employees_EmployeeID`) VALUES (31, '2023-02-01 00:00:00', '08:00:00', '17:00:00', 31);
2356INSERT INTO `mydb`.`WorkSchedules` (`ScheduleID`, `WorkDate`, `StartTime`, `EndTime`, `Employees_EmployeeID`) VALUES (32, '2023-02-02 00:00:00', '08:00:00', '17:00:00', 32);
2357INSERT INTO `mydb`.`WorkSchedules` (`ScheduleID`, `WorkDate`, `StartTime`, `EndTime`, `Employees_EmployeeID`) VALUES (33, '2023-02-03 00:00:00', '08:00:00', '17:00:00', 33);
2358INSERT INTO `mydb`.`WorkSchedules` (`ScheduleID`, `WorkDate`, `StartTime`, `EndTime`, `Employees_EmployeeID`) VALUES (34, '2023-02-04 00:00:00', '08:00:00', '17:00:00', 34);
2359INSERT INTO `mydb`.`WorkSchedules` (`ScheduleID`, `WorkDate`, `StartTime`, `EndTime`, `Employees_EmployeeID`) VALUES (35, '2023-02-05 00:00:00', '08:00:00', '17:00:00', 35);
2360INSERT INTO `mydb`.`WorkSchedules` (`ScheduleID`, `WorkDate`, `StartTime`, `EndTime`, `Employees_EmployeeID`) VALUES (36, '2023-02-06 00:00:00', '08:00:00', '17:00:00', 36);
2361INSERT INTO `mydb`.`WorkSchedules` (`ScheduleID`, `WorkDate`, `StartTime`, `EndTime`, `Employees_EmployeeID`) VALUES (37, '2023-02-07 00:00:00', '08:00:00', '17:00:00', 37);
2362INSERT INTO `mydb`.`WorkSchedules` (`ScheduleID`, `WorkDate`, `StartTime`, `EndTime`, `Employees_EmployeeID`) VALUES (38, '2023-02-08 00:00:00', '08:00:00', '17:00:00', 38);
2363INSERT INTO `mydb`.`WorkSchedules` (`ScheduleID`, `WorkDate`, `StartTime`, `EndTime`, `Employees_EmployeeID`) VALUES (39, '2023-02-09 00:00:00', '08:00:00', '17:00:00', 39);
2364INSERT INTO `mydb`.`WorkSchedules` (`ScheduleID`, `WorkDate`, `StartTime`, `EndTime`, `Employees_EmployeeID`) VALUES (40, '2023-02-10 00:00:00', '08:00:00', '17:00:00', 40);
2365INSERT INTO `mydb`.`WorkSchedules` (`ScheduleID`, `WorkDate`, `StartTime`, `EndTime`, `Employees_EmployeeID`) VALUES (41, '2023-02-11 00:00:00', '08:00:00', '17:00:00', 41);
2366INSERT INTO `mydb`.`WorkSchedules` (`ScheduleID`, `WorkDate`, `StartTime`, `EndTime`, `Employees_EmployeeID`) VALUES (42, '2023-02-12 00:00:00', '08:00:00', '17:00:00', 42);
2367INSERT INTO `mydb`.`WorkSchedules` (`ScheduleID`, `WorkDate`, `StartTime`, `EndTime`, `Employees_EmployeeID`) VALUES (43, '2023-02-13 00:00:00', '08:00:00', '17:00:00', 43);
2368INSERT INTO `mydb`.`WorkSchedules` (`ScheduleID`, `WorkDate`, `StartTime`, `EndTime`, `Employees_EmployeeID`) VALUES (44, '2023-02-14 00:00:00', '08:00:00', '17:00:00', 44);
2369INSERT INTO `mydb`.`WorkSchedules` (`ScheduleID`, `WorkDate`, `StartTime`, `EndTime`, `Employees_EmployeeID`) VALUES (45, '2023-02-15 00:00:00', '08:00:00', '17:00:00', 45);
2370INSERT INTO `mydb`.`WorkSchedules` (`ScheduleID`, `WorkDate`, `StartTime`, `EndTime`, `Employees_EmployeeID`) VALUES (46, '2023-02-16 00:00:00', '08:00:00', '17:00:00', 46);
2371INSERT INTO `mydb`.`WorkSchedules` (`ScheduleID`, `WorkDate`, `StartTime`, `EndTime`, `Employees_EmployeeID`) VALUES (47, '2023-02-17 00:00:00', '08:00:00', '17:00:00', 47);
2372INSERT INTO `mydb`.`WorkSchedules` (`ScheduleID`, `WorkDate`, `StartTime`, `EndTime`, `Employees_EmployeeID`) VALUES (48, '2023-02-18 00:00:00', '08:00:00', '17:00:00', 48);
2373INSERT INTO `mydb`.`WorkSchedules` (`ScheduleID`, `WorkDate`, `StartTime`, `EndTime`, `Employees_EmployeeID`) VALUES (49, '2023-02-19 00:00:00', '08:00:00', '17:00:00', 49);
2374INSERT INTO `mydb`.`WorkSchedules` (`ScheduleID`, `WorkDate`, `StartTime`, `EndTime`, `Employees_EmployeeID`) VALUES (50, '2023-02-20 00:00:00', '08:00:00', '17:00:00', 50);
2375
2376COMMIT;
2377
2378
2379-- -----------------------------------------------------
2380-- Data for table `mydb`.`Reports`
2381-- -----------------------------------------------------
2382START TRANSACTION;
2383USE `mydb`;
2384INSERT INTO `mydb`.`Reports` (`ReportID`, `ReportName`, `CreationDate`, `ReportType`) VALUES (1, 'Sales Report', '2023-01-01 00:00:00', 'Sales');
2385INSERT INTO `mydb`.`Reports` (`ReportID`, `ReportName`, `CreationDate`, `ReportType`) VALUES (2, 'Production Report', '2023-01-02 00:00:00', 'Production');
2386INSERT INTO `mydb`.`Reports` (`ReportID`, `ReportName`, `CreationDate`, `ReportType`) VALUES (3, 'Inventory Report', '2023-01-03 00:00:00', 'Inventory');
2387INSERT INTO `mydb`.`Reports` (`ReportID`, `ReportName`, `CreationDate`, `ReportType`) VALUES (4, 'Financial Report', '2023-01-04 00:00:00', 'Finance');
2388INSERT INTO `mydb`.`Reports` (`ReportID`, `ReportName`, `CreationDate`, `ReportType`) VALUES (5, 'Employee Performance Report', '2023-01-05 00:00:00', 'HR');
2389
2390COMMIT;
2391
2392
2393-- -----------------------------------------------------
2394-- Data for table `mydb`.`ReportData`
2395-- -----------------------------------------------------
2396START TRANSACTION;
2397USE `mydb`;
2398INSERT INTO `mydb`.`ReportData` (`ReportDataID`, `Metric`, `Value`, `Reports_ReportID`) VALUES (1, 'Total Sales', 10000.00, 1);
2399INSERT INTO `mydb`.`ReportData` (`ReportDataID`, `Metric`, `Value`, `Reports_ReportID`) VALUES (2, 'Average Order Value', 500.00, 1);
2400INSERT INTO `mydb`.`ReportData` (`ReportDataID`, `Metric`, `Value`, `Reports_ReportID`) VALUES (3, 'Total Production Time', 100.00, 2);
2401INSERT INTO `mydb`.`ReportData` (`ReportDataID`, `Metric`, `Value`, `Reports_ReportID`) VALUES (4, 'Units Produced', 500, 2);
2402INSERT INTO `mydb`.`ReportData` (`ReportDataID`, `Metric`, `Value`, `Reports_ReportID`) VALUES (5, 'Current Inventory', 1000, 3);
2403INSERT INTO `mydb`.`ReportData` (`ReportDataID`, `Metric`, `Value`, `Reports_ReportID`) VALUES (6, 'Total Expenses', 5000.00, 4);
2404INSERT INTO `mydb`.`ReportData` (`ReportDataID`, `Metric`, `Value`, `Reports_ReportID`) VALUES (7, 'Revenue', 15000.00, 4);
2405INSERT INTO `mydb`.`ReportData` (`ReportDataID`, `Metric`, `Value`, `Reports_ReportID`) VALUES (8, 'Average Employee Rating', 4.5, 5);
2406INSERT INTO `mydb`.`ReportData` (`ReportDataID`, `Metric`, `Value`, `Reports_ReportID`) VALUES (9, 'Total Hours Worked', 400.00, 5);
2407
2408COMMIT;
2409
2410
2411-- -----------------------------------------------------
2412-- Data for table `mydb`.`KPIs`
2413-- -----------------------------------------------------
2414START TRANSACTION;
2415USE `mydb`;
2416INSERT INTO `mydb`.`KPIs` (`KpiID`, `KPIName`, `TargetValue`, `ActualValue`) VALUES (1, 'Production Efficiency', 95.00, 92.50);
2417INSERT INTO `mydb`.`KPIs` (`KpiID`, `KPIName`, `TargetValue`, `ActualValue`) VALUES (2, 'Order Fulfillment Rate', 98.00, 97.00);
2418INSERT INTO `mydb`.`KPIs` (`KpiID`, `KPIName`, `TargetValue`, `ActualValue`) VALUES (3, 'Average Lead Time', 5.00, 4.80);
2419INSERT INTO `mydb`.`KPIs` (`KpiID`, `KPIName`, `TargetValue`, `ActualValue`) VALUES (4, 'On-Time Delivery', 99.00, 98.50);
2420INSERT INTO `mydb`.`KPIs` (`KpiID`, `KPIName`, `TargetValue`, `ActualValue`) VALUES (5, 'Inventory Turnover', 4.00, 3.80);
2421
2422COMMIT;
2423
2424
2425-- -----------------------------------------------------
2426-- Data for table `mydb`.`SalesAnalytics`
2427-- -----------------------------------------------------
2428START TRANSACTION;
2429USE `mydb`;
2430INSERT INTO `mydb`.`SalesAnalytics` (`SaleAnalyticsID`, `SaleDate`, `Quantity`, `Revenue`, `Products_ProductID`) VALUES (1, '2023-01-01 00:00:00', 2, 400.00, 201);
2431INSERT INTO `mydb`.`SalesAnalytics` (`SaleAnalyticsID`, `SaleDate`, `Quantity`, `Revenue`, `Products_ProductID`) VALUES (2, '2023-01-02 00:00:00', 3, 600.00, 202);
2432INSERT INTO `mydb`.`SalesAnalytics` (`SaleAnalyticsID`, `SaleDate`, `Quantity`, `Revenue`, `Products_ProductID`) VALUES (3, '2023-01-03 00:00:00', 4, 800.00, 203);
2433INSERT INTO `mydb`.`SalesAnalytics` (`SaleAnalyticsID`, `SaleDate`, `Quantity`, `Revenue`, `Products_ProductID`) VALUES (4, '2023-01-04 00:00:00', 5, 1000.00, 204);
2434INSERT INTO `mydb`.`SalesAnalytics` (`SaleAnalyticsID`, `SaleDate`, `Quantity`, `Revenue`, `Products_ProductID`) VALUES (5, '2023-01-05 00:00:00', 6, 1200.00, 205);
2435INSERT INTO `mydb`.`SalesAnalytics` (`SaleAnalyticsID`, `SaleDate`, `Quantity`, `Revenue`, `Products_ProductID`) VALUES (6, '2023-01-06 00:00:00', 7, 1400.00, 206);
2436INSERT INTO `mydb`.`SalesAnalytics` (`SaleAnalyticsID`, `SaleDate`, `Quantity`, `Revenue`, `Products_ProductID`) VALUES (7, '2023-01-07 00:00:00', 8, 1600.00, 207);
2437INSERT INTO `mydb`.`SalesAnalytics` (`SaleAnalyticsID`, `SaleDate`, `Quantity`, `Revenue`, `Products_ProductID`) VALUES (8, '2023-01-08 00:00:00', 9, 1800.00, 208);
2438INSERT INTO `mydb`.`SalesAnalytics` (`SaleAnalyticsID`, `SaleDate`, `Quantity`, `Revenue`, `Products_ProductID`) VALUES (9, '2023-01-09 00:00:00', 10, 2000.00, 209);
2439INSERT INTO `mydb`.`SalesAnalytics` (`SaleAnalyticsID`, `SaleDate`, `Quantity`, `Revenue`, `Products_ProductID`) VALUES (10, '2023-01-10 00:00:00', 11, 2200.00, 210);
2440INSERT INTO `mydb`.`SalesAnalytics` (`SaleAnalyticsID`, `SaleDate`, `Quantity`, `Revenue`, `Products_ProductID`) VALUES (11, '2023-01-11 00:00:00', 12, 2400.00, 211);
2441INSERT INTO `mydb`.`SalesAnalytics` (`SaleAnalyticsID`, `SaleDate`, `Quantity`, `Revenue`, `Products_ProductID`) VALUES (12, '2023-01-12 00:00:00', 13, 2600.00, 212);
2442INSERT INTO `mydb`.`SalesAnalytics` (`SaleAnalyticsID`, `SaleDate`, `Quantity`, `Revenue`, `Products_ProductID`) VALUES (13, '2023-01-13 00:00:00', 14, 2800.00, 213);
2443INSERT INTO `mydb`.`SalesAnalytics` (`SaleAnalyticsID`, `SaleDate`, `Quantity`, `Revenue`, `Products_ProductID`) VALUES (14, '2023-01-14 00:00:00', 15, 3000.00, 214);
2444INSERT INTO `mydb`.`SalesAnalytics` (`SaleAnalyticsID`, `SaleDate`, `Quantity`, `Revenue`, `Products_ProductID`) VALUES (15, '2023-01-15 00:00:00', 16, 3200.00, 215);
2445INSERT INTO `mydb`.`SalesAnalytics` (`SaleAnalyticsID`, `SaleDate`, `Quantity`, `Revenue`, `Products_ProductID`) VALUES (16, '2023-01-16 00:00:00', 17, 3400.00, 216);
2446INSERT INTO `mydb`.`SalesAnalytics` (`SaleAnalyticsID`, `SaleDate`, `Quantity`, `Revenue`, `Products_ProductID`) VALUES (17, '2023-01-17 00:00:00', 18, 3600.00, 217);
2447INSERT INTO `mydb`.`SalesAnalytics` (`SaleAnalyticsID`, `SaleDate`, `Quantity`, `Revenue`, `Products_ProductID`) VALUES (18, '2023-01-18 00:00:00', 19, 3800.00, 218);
2448INSERT INTO `mydb`.`SalesAnalytics` (`SaleAnalyticsID`, `SaleDate`, `Quantity`, `Revenue`, `Products_ProductID`) VALUES (19, '2023-01-19 00:00:00', 20, 4000.00, 219);
2449INSERT INTO `mydb`.`SalesAnalytics` (`SaleAnalyticsID`, `SaleDate`, `Quantity`, `Revenue`, `Products_ProductID`) VALUES (20, '2023-01-20 00:00:00', 21, 4200.00, 220);
2450INSERT INTO `mydb`.`SalesAnalytics` (`SaleAnalyticsID`, `SaleDate`, `Quantity`, `Revenue`, `Products_ProductID`) VALUES (21, '2023-01-21 00:00:00', 22, 4400.00, 221);
2451INSERT INTO `mydb`.`SalesAnalytics` (`SaleAnalyticsID`, `SaleDate`, `Quantity`, `Revenue`, `Products_ProductID`) VALUES (22, '2023-01-22 00:00:00', 23, 4600.00, 222);
2452INSERT INTO `mydb`.`SalesAnalytics` (`SaleAnalyticsID`, `SaleDate`, `Quantity`, `Revenue`, `Products_ProductID`) VALUES (23, '2023-01-23 00:00:00', 24, 4800.00, 223);
2453INSERT INTO `mydb`.`SalesAnalytics` (`SaleAnalyticsID`, `SaleDate`, `Quantity`, `Revenue`, `Products_ProductID`) VALUES (24, '2023-01-24 00:00:00', 25, 5000.00, 224);
2454INSERT INTO `mydb`.`SalesAnalytics` (`SaleAnalyticsID`, `SaleDate`, `Quantity`, `Revenue`, `Products_ProductID`) VALUES (25, '2023-01-25 00:00:00', 26, 5200.00, 225);
2455INSERT INTO `mydb`.`SalesAnalytics` (`SaleAnalyticsID`, `SaleDate`, `Quantity`, `Revenue`, `Products_ProductID`) VALUES (26, '2023-01-26 00:00:00', 27, 5400.00, 226);
2456INSERT INTO `mydb`.`SalesAnalytics` (`SaleAnalyticsID`, `SaleDate`, `Quantity`, `Revenue`, `Products_ProductID`) VALUES (27, '2023-01-27 00:00:00', 28, 5600.00, 227);
2457INSERT INTO `mydb`.`SalesAnalytics` (`SaleAnalyticsID`, `SaleDate`, `Quantity`, `Revenue`, `Products_ProductID`) VALUES (28, '2023-01-28 00:00:00', 29, 5800.00, 228);
2458INSERT INTO `mydb`.`SalesAnalytics` (`SaleAnalyticsID`, `SaleDate`, `Quantity`, `Revenue`, `Products_ProductID`) VALUES (29, '2023-01-29 00:00:00', 30, 6000.00, 229);
2459INSERT INTO `mydb`.`SalesAnalytics` (`SaleAnalyticsID`, `SaleDate`, `Quantity`, `Revenue`, `Products_ProductID`) VALUES (30, '2023-01-30 00:00:00', 31, 6200.00, 230);
2460INSERT INTO `mydb`.`SalesAnalytics` (`SaleAnalyticsID`, `SaleDate`, `Quantity`, `Revenue`, `Products_ProductID`) VALUES (31, '2023-01-31 00:00:00', 32, 6400.00, 231);
2461INSERT INTO `mydb`.`SalesAnalytics` (`SaleAnalyticsID`, `SaleDate`, `Quantity`, `Revenue`, `Products_ProductID`) VALUES (32, '2023-02-01 00:00:00', 33, 6600.00, 232);
2462INSERT INTO `mydb`.`SalesAnalytics` (`SaleAnalyticsID`, `SaleDate`, `Quantity`, `Revenue`, `Products_ProductID`) VALUES (33, '2023-02-02 00:00:00', 34, 6800.00, 233);
2463INSERT INTO `mydb`.`SalesAnalytics` (`SaleAnalyticsID`, `SaleDate`, `Quantity`, `Revenue`, `Products_ProductID`) VALUES (34, '2023-02-03 00:00:00', 35, 7000.00, 234);
2464INSERT INTO `mydb`.`SalesAnalytics` (`SaleAnalyticsID`, `SaleDate`, `Quantity`, `Revenue`, `Products_ProductID`) VALUES (35, '2023-02-04 00:00:00', 36, 7200.00, 235);
2465INSERT INTO `mydb`.`SalesAnalytics` (`SaleAnalyticsID`, `SaleDate`, `Quantity`, `Revenue`, `Products_ProductID`) VALUES (36, '2023-02-05 00:00:00', 37, 7400.00, 236);
2466INSERT INTO `mydb`.`SalesAnalytics` (`SaleAnalyticsID`, `SaleDate`, `Quantity`, `Revenue`, `Products_ProductID`) VALUES (37, '2023-02-06 00:00:00', 38, 7600.00, 237);
2467INSERT INTO `mydb`.`SalesAnalytics` (`SaleAnalyticsID`, `SaleDate`, `Quantity`, `Revenue`, `Products_ProductID`) VALUES (38, '2023-02-07 00:00:00', 39, 7800.00, 238);
2468INSERT INTO `mydb`.`SalesAnalytics` (`SaleAnalyticsID`, `SaleDate`, `Quantity`, `Revenue`, `Products_ProductID`) VALUES (39, '2023-02-08 00:00:00', 40, 8000.00, 239);
2469INSERT INTO `mydb`.`SalesAnalytics` (`SaleAnalyticsID`, `SaleDate`, `Quantity`, `Revenue`, `Products_ProductID`) VALUES (40, '2023-02-09 00:00:00', 41, 8200.00, 240);
2470INSERT INTO `mydb`.`SalesAnalytics` (`SaleAnalyticsID`, `SaleDate`, `Quantity`, `Revenue`, `Products_ProductID`) VALUES (41, '2023-02-10 00:00:00', 42, 8400.00, 241);
2471INSERT INTO `mydb`.`SalesAnalytics` (`SaleAnalyticsID`, `SaleDate`, `Quantity`, `Revenue`, `Products_ProductID`) VALUES (42, '2023-02-11 00:00:00', 43, 8600.00, 242);
2472INSERT INTO `mydb`.`SalesAnalytics` (`SaleAnalyticsID`, `SaleDate`, `Quantity`, `Revenue`, `Products_ProductID`) VALUES (43, '2023-02-12 00:00:00', 44, 8800.00, 243);
2473INSERT INTO `mydb`.`SalesAnalytics` (`SaleAnalyticsID`, `SaleDate`, `Quantity`, `Revenue`, `Products_ProductID`) VALUES (44, '2023-02-13 00:00:00', 45, 9000.00, 244);
2474INSERT INTO `mydb`.`SalesAnalytics` (`SaleAnalyticsID`, `SaleDate`, `Quantity`, `Revenue`, `Products_ProductID`) VALUES (45, '2023-02-14 00:00:00', 46, 9200.00, 245);
2475INSERT INTO `mydb`.`SalesAnalytics` (`SaleAnalyticsID`, `SaleDate`, `Quantity`, `Revenue`, `Products_ProductID`) VALUES (46, '2023-02-15 00:00:00', 47, 9400.00, 246);
2476INSERT INTO `mydb`.`SalesAnalytics` (`SaleAnalyticsID`, `SaleDate`, `Quantity`, `Revenue`, `Products_ProductID`) VALUES (47, '2023-02-16 00:00:00', 48, 9600.00, 247);
2477INSERT INTO `mydb`.`SalesAnalytics` (`SaleAnalyticsID`, `SaleDate`, `Quantity`, `Revenue`, `Products_ProductID`) VALUES (48, '2023-02-17 00:00:00', 49, 9800.00, 248);
2478INSERT INTO `mydb`.`SalesAnalytics` (`SaleAnalyticsID`, `SaleDate`, `Quantity`, `Revenue`, `Products_ProductID`) VALUES (49, '2023-02-18 00:00:00', 50, 10000.00, 249);
2479INSERT INTO `mydb`.`SalesAnalytics` (`SaleAnalyticsID`, `SaleDate`, `Quantity`, `Revenue`, `Products_ProductID`) VALUES (50, '2023-02-19 00:00:00', 51, 10200.00, 250);
2480
2481COMMIT;
2482
2483
2484-- -----------------------------------------------------
2485-- Data for table `mydb`.`ProductionAnalytics`
2486-- -----------------------------------------------------
2487START TRANSACTION;
2488USE `mydb`;
2489INSERT INTO `mydb`.`ProductionAnalytics` (`ProdAnalyticsID`, `ProductionDate`, `Quantity`, `Costs`, `Products_ProductID`) VALUES (1, '2023-01-01 00:00:00', 10, 500.00, 201);
2490INSERT INTO `mydb`.`ProductionAnalytics` (`ProdAnalyticsID`, `ProductionDate`, `Quantity`, `Costs`, `Products_ProductID`) VALUES (2, '2023-01-02 00:00:00', 15, 750.00, 202);
2491INSERT INTO `mydb`.`ProductionAnalytics` (`ProdAnalyticsID`, `ProductionDate`, `Quantity`, `Costs`, `Products_ProductID`) VALUES (3, '2023-01-03 00:00:00', 20, 1000.00, 203);
2492INSERT INTO `mydb`.`ProductionAnalytics` (`ProdAnalyticsID`, `ProductionDate`, `Quantity`, `Costs`, `Products_ProductID`) VALUES (4, '2023-01-04 00:00:00', 12, 600.00, 204);
2493INSERT INTO `mydb`.`ProductionAnalytics` (`ProdAnalyticsID`, `ProductionDate`, `Quantity`, `Costs`, `Products_ProductID`) VALUES (5, '2023-01-05 00:00:00', 8, 400.00, 205);
2494INSERT INTO `mydb`.`ProductionAnalytics` (`ProdAnalyticsID`, `ProductionDate`, `Quantity`, `Costs`, `Products_ProductID`) VALUES (6, '2023-01-06 00:00:00', 11, 550.00, 206);
2495INSERT INTO `mydb`.`ProductionAnalytics` (`ProdAnalyticsID`, `ProductionDate`, `Quantity`, `Costs`, `Products_ProductID`) VALUES (7, '2023-01-07 00:00:00', 9, 450.00, 207);
2496INSERT INTO `mydb`.`ProductionAnalytics` (`ProdAnalyticsID`, `ProductionDate`, `Quantity`, `Costs`, `Products_ProductID`) VALUES (8, '2023-01-08 00:00:00', 13, 650.00, 208);
2497INSERT INTO `mydb`.`ProductionAnalytics` (`ProdAnalyticsID`, `ProductionDate`, `Quantity`, `Costs`, `Products_ProductID`) VALUES (9, '2023-01-09 00:00:00', 14, 700.00, 209);
2498INSERT INTO `mydb`.`ProductionAnalytics` (`ProdAnalyticsID`, `ProductionDate`, `Quantity`, `Costs`, `Products_ProductID`) VALUES (10, '2023-01-10 00:00:00', 16, 800.00, 210);
2499INSERT INTO `mydb`.`ProductionAnalytics` (`ProdAnalyticsID`, `ProductionDate`, `Quantity`, `Costs`, `Products_ProductID`) VALUES (11, '2023-01-11 00:00:00', 17, 850.00, 211);
2500INSERT INTO `mydb`.`ProductionAnalytics` (`ProdAnalyticsID`, `ProductionDate`, `Quantity`, `Costs`, `Products_ProductID`) VALUES (12, '2023-01-12 00:00:00', 18, 900.00, 212);
2501INSERT INTO `mydb`.`ProductionAnalytics` (`ProdAnalyticsID`, `ProductionDate`, `Quantity`, `Costs`, `Products_ProductID`) VALUES (13, '2023-01-13 00:00:00', 19, 950.00, 213);
2502INSERT INTO `mydb`.`ProductionAnalytics` (`ProdAnalyticsID`, `ProductionDate`, `Quantity`, `Costs`, `Products_ProductID`) VALUES (14, '2023-01-14 00:00:00', 20, 1000.00, 214);
2503INSERT INTO `mydb`.`ProductionAnalytics` (`ProdAnalyticsID`, `ProductionDate`, `Quantity`, `Costs`, `Products_ProductID`) VALUES (15, '2023-01-15 00:00:00', 21, 1050.00, 215);
2504INSERT INTO `mydb`.`ProductionAnalytics` (`ProdAnalyticsID`, `ProductionDate`, `Quantity`, `Costs`, `Products_ProductID`) VALUES (16, '2023-01-16 00:00:00', 22, 1100.00, 216);
2505INSERT INTO `mydb`.`ProductionAnalytics` (`ProdAnalyticsID`, `ProductionDate`, `Quantity`, `Costs`, `Products_ProductID`) VALUES (17, '2023-01-17 00:00:00', 23, 1150.00, 217);
2506INSERT INTO `mydb`.`ProductionAnalytics` (`ProdAnalyticsID`, `ProductionDate`, `Quantity`, `Costs`, `Products_ProductID`) VALUES (18, '2023-01-18 00:00:00', 24, 1200.00, 218);
2507INSERT INTO `mydb`.`ProductionAnalytics` (`ProdAnalyticsID`, `ProductionDate`, `Quantity`, `Costs`, `Products_ProductID`) VALUES (19, '2023-01-19 00:00:00', 25, 1250.00, 219);
2508INSERT INTO `mydb`.`ProductionAnalytics` (`ProdAnalyticsID`, `ProductionDate`, `Quantity`, `Costs`, `Products_ProductID`) VALUES (20, '2023-01-20 00:00:00', 26, 1300.00, 220);
2509INSERT INTO `mydb`.`ProductionAnalytics` (`ProdAnalyticsID`, `ProductionDate`, `Quantity`, `Costs`, `Products_ProductID`) VALUES (21, '2023-01-21 00:00:00', 27, 1350.00, 221);
2510INSERT INTO `mydb`.`ProductionAnalytics` (`ProdAnalyticsID`, `ProductionDate`, `Quantity`, `Costs`, `Products_ProductID`) VALUES (22, '2023-01-22 00:00:00', 28, 1400.00, 222);
2511INSERT INTO `mydb`.`ProductionAnalytics` (`ProdAnalyticsID`, `ProductionDate`, `Quantity`, `Costs`, `Products_ProductID`) VALUES (23, '2023-01-23 00:00:00', 29, 1450.00, 223);
2512INSERT INTO `mydb`.`ProductionAnalytics` (`ProdAnalyticsID`, `ProductionDate`, `Quantity`, `Costs`, `Products_ProductID`) VALUES (24, '2023-01-24 00:00:00', 30, 1500.00, 224);
2513INSERT INTO `mydb`.`ProductionAnalytics` (`ProdAnalyticsID`, `ProductionDate`, `Quantity`, `Costs`, `Products_ProductID`) VALUES (25, '2023-01-25 00:00:00', 31, 1550.00, 225);
2514INSERT INTO `mydb`.`ProductionAnalytics` (`ProdAnalyticsID`, `ProductionDate`, `Quantity`, `Costs`, `Products_ProductID`) VALUES (26, '2023-01-26 00:00:00', 32, 1600.00, 226);
2515INSERT INTO `mydb`.`ProductionAnalytics` (`ProdAnalyticsID`, `ProductionDate`, `Quantity`, `Costs`, `Products_ProductID`) VALUES (27, '2023-01-27 00:00:00', 33, 1650.00, 227);
2516INSERT INTO `mydb`.`ProductionAnalytics` (`ProdAnalyticsID`, `ProductionDate`, `Quantity`, `Costs`, `Products_ProductID`) VALUES (28, '2023-01-28 00:00:00', 34, 1700.00, 228);
2517INSERT INTO `mydb`.`ProductionAnalytics` (`ProdAnalyticsID`, `ProductionDate`, `Quantity`, `Costs`, `Products_ProductID`) VALUES (29, '2023-01-29 00:00:00', 35, 1750.00, 229);
2518INSERT INTO `mydb`.`ProductionAnalytics` (`ProdAnalyticsID`, `ProductionDate`, `Quantity`, `Costs`, `Products_ProductID`) VALUES (30, '2023-01-30 00:00:00', 36, 1800.00, 230);
2519INSERT INTO `mydb`.`ProductionAnalytics` (`ProdAnalyticsID`, `ProductionDate`, `Quantity`, `Costs`, `Products_ProductID`) VALUES (31, '2023-01-31 00:00:00', 37, 1850.00, 231);
2520INSERT INTO `mydb`.`ProductionAnalytics` (`ProdAnalyticsID`, `ProductionDate`, `Quantity`, `Costs`, `Products_ProductID`) VALUES (32, '2023-02-01 00:00:00', 38, 1900.00, 232);
2521INSERT INTO `mydb`.`ProductionAnalytics` (`ProdAnalyticsID`, `ProductionDate`, `Quantity`, `Costs`, `Products_ProductID`) VALUES (33, '2023-02-02 00:00:00', 39, 1950.00, 233);
2522INSERT INTO `mydb`.`ProductionAnalytics` (`ProdAnalyticsID`, `ProductionDate`, `Quantity`, `Costs`, `Products_ProductID`) VALUES (34, '2023-02-03 00:00:00', 40, 2000.00, 234);
2523INSERT INTO `mydb`.`ProductionAnalytics` (`ProdAnalyticsID`, `ProductionDate`, `Quantity`, `Costs`, `Products_ProductID`) VALUES (35, '2023-02-04 00:00:00', 41, 2050.00, 235);
2524INSERT INTO `mydb`.`ProductionAnalytics` (`ProdAnalyticsID`, `ProductionDate`, `Quantity`, `Costs`, `Products_ProductID`) VALUES (36, '2023-02-05 00:00:00', 42, 2100.00, 236);
2525INSERT INTO `mydb`.`ProductionAnalytics` (`ProdAnalyticsID`, `ProductionDate`, `Quantity`, `Costs`, `Products_ProductID`) VALUES (37, '2023-02-06 00:00:00', 43, 2150.00, 237);
2526INSERT INTO `mydb`.`ProductionAnalytics` (`ProdAnalyticsID`, `ProductionDate`, `Quantity`, `Costs`, `Products_ProductID`) VALUES (38, '2023-02-07 00:00:00', 44, 2200.00, 238);
2527INSERT INTO `mydb`.`ProductionAnalytics` (`ProdAnalyticsID`, `ProductionDate`, `Quantity`, `Costs`, `Products_ProductID`) VALUES (39, '2023-02-08 00:00:00', 45, 2250.00, 239);
2528INSERT INTO `mydb`.`ProductionAnalytics` (`ProdAnalyticsID`, `ProductionDate`, `Quantity`, `Costs`, `Products_ProductID`) VALUES (40, '2023-02-09 00:00:00', 46, 2300.00, 240);
2529INSERT INTO `mydb`.`ProductionAnalytics` (`ProdAnalyticsID`, `ProductionDate`, `Quantity`, `Costs`, `Products_ProductID`) VALUES (41, '2023-02-10 00:00:00', 47, 2350.00, 241);
2530INSERT INTO `mydb`.`ProductionAnalytics` (`ProdAnalyticsID`, `ProductionDate`, `Quantity`, `Costs`, `Products_ProductID`) VALUES (42, '2023-02-11 00:00:00', 48, 2400.00, 242);
2531INSERT INTO `mydb`.`ProductionAnalytics` (`ProdAnalyticsID`, `ProductionDate`, `Quantity`, `Costs`, `Products_ProductID`) VALUES (43, '2023-02-12 00:00:00', 49, 2450.00, 243);
2532INSERT INTO `mydb`.`ProductionAnalytics` (`ProdAnalyticsID`, `ProductionDate`, `Quantity`, `Costs`, `Products_ProductID`) VALUES (44, '2023-02-13 00:00:00', 50, 2500.00, 244);
2533INSERT INTO `mydb`.`ProductionAnalytics` (`ProdAnalyticsID`, `ProductionDate`, `Quantity`, `Costs`, `Products_ProductID`) VALUES (45, '2023-02-14 00:00:00', 51, 2550.00, 245);
2534INSERT INTO `mydb`.`ProductionAnalytics` (`ProdAnalyticsID`, `ProductionDate`, `Quantity`, `Costs`, `Products_ProductID`) VALUES (46, '2023-02-15 00:00:00', 52, 2600.00, 246);
2535INSERT INTO `mydb`.`ProductionAnalytics` (`ProdAnalyticsID`, `ProductionDate`, `Quantity`, `Costs`, `Products_ProductID`) VALUES (47, '2023-02-16 00:00:00', 53, 2650.00, 247);
2536INSERT INTO `mydb`.`ProductionAnalytics` (`ProdAnalyticsID`, `ProductionDate`, `Quantity`, `Costs`, `Products_ProductID`) VALUES (48, '2023-02-17 00:00:00', 54, 2700.00, 248);
2537INSERT INTO `mydb`.`ProductionAnalytics` (`ProdAnalyticsID`, `ProductionDate`, `Quantity`, `Costs`, `Products_ProductID`) VALUES (49, '2023-02-18 00:00:00', 55, 2750.00, 249);
2538INSERT INTO `mydb`.`ProductionAnalytics` (`ProdAnalyticsID`, `ProductionDate`, `Quantity`, `Costs`, `Products_ProductID`) VALUES (50, '2023-02-19 00:00:00', 56, 2800.00, 250);
2539
2540COMMIT;
2541
2542
2543-- -----------------------------------------------------
2544-- Data for table `mydb`.`InventoryAnalytics`
2545-- -----------------------------------------------------
2546START TRANSACTION;
2547USE `mydb`;
2548INSERT INTO `mydb`.`InventoryAnalytics` (`InvAnalyticsID`, `AnalysisDate`, `Quantity`, `Costs`, `Materials_MaterialID`) VALUES (1, '2023-01-01 00:00:00', 100, 5000.00, 101);
2549INSERT INTO `mydb`.`InventoryAnalytics` (`InvAnalyticsID`, `AnalysisDate`, `Quantity`, `Costs`, `Materials_MaterialID`) VALUES (2, '2023-01-02 00:00:00', 150, 7500.00, 102);
2550INSERT INTO `mydb`.`InventoryAnalytics` (`InvAnalyticsID`, `AnalysisDate`, `Quantity`, `Costs`, `Materials_MaterialID`) VALUES (3, '2023-01-03 00:00:00', 200, 10000.00, 103);
2551INSERT INTO `mydb`.`InventoryAnalytics` (`InvAnalyticsID`, `AnalysisDate`, `Quantity`, `Costs`, `Materials_MaterialID`) VALUES (4, '2023-01-04 00:00:00', 120, 6000.00, 104);
2552INSERT INTO `mydb`.`InventoryAnalytics` (`InvAnalyticsID`, `AnalysisDate`, `Quantity`, `Costs`, `Materials_MaterialID`) VALUES (5, '2023-01-05 00:00:00', 80, 4000.00, 105);
2553INSERT INTO `mydb`.`InventoryAnalytics` (`InvAnalyticsID`, `AnalysisDate`, `Quantity`, `Costs`, `Materials_MaterialID`) VALUES (6, '2023-01-06 00:00:00', 110, 5500.00, 106);
2554INSERT INTO `mydb`.`InventoryAnalytics` (`InvAnalyticsID`, `AnalysisDate`, `Quantity`, `Costs`, `Materials_MaterialID`) VALUES (7, '2023-01-07 00:00:00', 90, 4500.00, 107);
2555INSERT INTO `mydb`.`InventoryAnalytics` (`InvAnalyticsID`, `AnalysisDate`, `Quantity`, `Costs`, `Materials_MaterialID`) VALUES (8, '2023-01-08 00:00:00', 130, 6500.00, 108);
2556INSERT INTO `mydb`.`InventoryAnalytics` (`InvAnalyticsID`, `AnalysisDate`, `Quantity`, `Costs`, `Materials_MaterialID`) VALUES (9, '2023-01-09 00:00:00', 140, 7000.00, 109);
2557INSERT INTO `mydb`.`InventoryAnalytics` (`InvAnalyticsID`, `AnalysisDate`, `Quantity`, `Costs`, `Materials_MaterialID`) VALUES (10, '2023-01-10 00:00:00', 160, 8000.00, 110);
2558INSERT INTO `mydb`.`InventoryAnalytics` (`InvAnalyticsID`, `AnalysisDate`, `Quantity`, `Costs`, `Materials_MaterialID`) VALUES (11, '2023-01-11 00:00:00', 170, 8500.00, 111);
2559INSERT INTO `mydb`.`InventoryAnalytics` (`InvAnalyticsID`, `AnalysisDate`, `Quantity`, `Costs`, `Materials_MaterialID`) VALUES (12, '2023-01-12 00:00:00', 180, 9000.00, 112);
2560INSERT INTO `mydb`.`InventoryAnalytics` (`InvAnalyticsID`, `AnalysisDate`, `Quantity`, `Costs`, `Materials_MaterialID`) VALUES (13, '2023-01-13 00:00:00', 190, 9500.00, 113);
2561INSERT INTO `mydb`.`InventoryAnalytics` (`InvAnalyticsID`, `AnalysisDate`, `Quantity`, `Costs`, `Materials_MaterialID`) VALUES (14, '2023-01-14 00:00:00', 200, 10000.00, 114);
2562INSERT INTO `mydb`.`InventoryAnalytics` (`InvAnalyticsID`, `AnalysisDate`, `Quantity`, `Costs`, `Materials_MaterialID`) VALUES (15, '2023-01-15 00:00:00', 210, 10500.00, 115);
2563INSERT INTO `mydb`.`InventoryAnalytics` (`InvAnalyticsID`, `AnalysisDate`, `Quantity`, `Costs`, `Materials_MaterialID`) VALUES (16, '2023-01-16 00:00:00', 220, 11000.00, 116);
2564INSERT INTO `mydb`.`InventoryAnalytics` (`InvAnalyticsID`, `AnalysisDate`, `Quantity`, `Costs`, `Materials_MaterialID`) VALUES (17, '2023-01-17 00:00:00', 230, 11500.00, 117);
2565INSERT INTO `mydb`.`InventoryAnalytics` (`InvAnalyticsID`, `AnalysisDate`, `Quantity`, `Costs`, `Materials_MaterialID`) VALUES (18, '2023-01-18 00:00:00', 240, 12000.00, 118);
2566INSERT INTO `mydb`.`InventoryAnalytics` (`InvAnalyticsID`, `AnalysisDate`, `Quantity`, `Costs`, `Materials_MaterialID`) VALUES (19, '2023-01-19 00:00:00', 250, 12500.00, 119);
2567INSERT INTO `mydb`.`InventoryAnalytics` (`InvAnalyticsID`, `AnalysisDate`, `Quantity`, `Costs`, `Materials_MaterialID`) VALUES (20, '2023-01-20 00:00:00', 260, 13000.00, 120);
2568INSERT INTO `mydb`.`InventoryAnalytics` (`InvAnalyticsID`, `AnalysisDate`, `Quantity`, `Costs`, `Materials_MaterialID`) VALUES (21, '2023-01-21 00:00:00', 270, 13500.00, 121);
2569INSERT INTO `mydb`.`InventoryAnalytics` (`InvAnalyticsID`, `AnalysisDate`, `Quantity`, `Costs`, `Materials_MaterialID`) VALUES (22, '2023-01-22 00:00:00', 280, 14000.00, 122);
2570INSERT INTO `mydb`.`InventoryAnalytics` (`InvAnalyticsID`, `AnalysisDate`, `Quantity`, `Costs`, `Materials_MaterialID`) VALUES (23, '2023-01-23 00:00:00', 290, 14500.00, 123);
2571INSERT INTO `mydb`.`InventoryAnalytics` (`InvAnalyticsID`, `AnalysisDate`, `Quantity`, `Costs`, `Materials_MaterialID`) VALUES (24, '2023-01-24 00:00:00', 300, 15000.00, 124);
2572INSERT INTO `mydb`.`InventoryAnalytics` (`InvAnalyticsID`, `AnalysisDate`, `Quantity`, `Costs`, `Materials_MaterialID`) VALUES (25, '2023-01-25 00:00:00', 310, 15500.00, 125);
2573INSERT INTO `mydb`.`InventoryAnalytics` (`InvAnalyticsID`, `AnalysisDate`, `Quantity`, `Costs`, `Materials_MaterialID`) VALUES (26, '2023-01-26 00:00:00', 320, 16000.00, 126);
2574INSERT INTO `mydb`.`InventoryAnalytics` (`InvAnalyticsID`, `AnalysisDate`, `Quantity`, `Costs`, `Materials_MaterialID`) VALUES (27, '2023-01-27 00:00:00', 330, 16500.00, 127);
2575INSERT INTO `mydb`.`InventoryAnalytics` (`InvAnalyticsID`, `AnalysisDate`, `Quantity`, `Costs`, `Materials_MaterialID`) VALUES (28, '2023-01-28 00:00:00', 340, 17000.00, 128);
2576INSERT INTO `mydb`.`InventoryAnalytics` (`InvAnalyticsID`, `AnalysisDate`, `Quantity`, `Costs`, `Materials_MaterialID`) VALUES (29, '2023-01-29 00:00:00', 350, 17500.00, 129);
2577INSERT INTO `mydb`.`InventoryAnalytics` (`InvAnalyticsID`, `AnalysisDate`, `Quantity`, `Costs`, `Materials_MaterialID`) VALUES (30, '2023-01-30 00:00:00', 360, 18000.00, 130);
2578INSERT INTO `mydb`.`InventoryAnalytics` (`InvAnalyticsID`, `AnalysisDate`, `Quantity`, `Costs`, `Materials_MaterialID`) VALUES (31, '2023-01-31 00:00:00', 370, 18500.00, 131);
2579INSERT INTO `mydb`.`InventoryAnalytics` (`InvAnalyticsID`, `AnalysisDate`, `Quantity`, `Costs`, `Materials_MaterialID`) VALUES (32, '2023-02-01 00:00:00', 380, 19000.00, 132);
2580INSERT INTO `mydb`.`InventoryAnalytics` (`InvAnalyticsID`, `AnalysisDate`, `Quantity`, `Costs`, `Materials_MaterialID`) VALUES (33, '2023-02-02 00:00:00', 390, 19500.00, 133);
2581INSERT INTO `mydb`.`InventoryAnalytics` (`InvAnalyticsID`, `AnalysisDate`, `Quantity`, `Costs`, `Materials_MaterialID`) VALUES (34, '2023-02-03 00:00:00', 400, 20000.00, 134);
2582INSERT INTO `mydb`.`InventoryAnalytics` (`InvAnalyticsID`, `AnalysisDate`, `Quantity`, `Costs`, `Materials_MaterialID`) VALUES (35, '2023-02-04 00:00:00', 410, 20500.00, 135);
2583INSERT INTO `mydb`.`InventoryAnalytics` (`InvAnalyticsID`, `AnalysisDate`, `Quantity`, `Costs`, `Materials_MaterialID`) VALUES (36, '2023-02-05 00:00:00', 420, 21000.00, 136);
2584INSERT INTO `mydb`.`InventoryAnalytics` (`InvAnalyticsID`, `AnalysisDate`, `Quantity`, `Costs`, `Materials_MaterialID`) VALUES (37, '2023-02-06 00:00:00', 430, 21500.00, 137);
2585INSERT INTO `mydb`.`InventoryAnalytics` (`InvAnalyticsID`, `AnalysisDate`, `Quantity`, `Costs`, `Materials_MaterialID`) VALUES (38, '2023-02-07 00:00:00', 440, 22000.00, 138);
2586INSERT INTO `mydb`.`InventoryAnalytics` (`InvAnalyticsID`, `AnalysisDate`, `Quantity`, `Costs`, `Materials_MaterialID`) VALUES (39, '2023-02-08 00:00:00', 450, 22500.00, 139);
2587INSERT INTO `mydb`.`InventoryAnalytics` (`InvAnalyticsID`, `AnalysisDate`, `Quantity`, `Costs`, `Materials_MaterialID`) VALUES (40, '2023-02-09 00:00:00', 460, 23000.00, 140);
2588INSERT INTO `mydb`.`InventoryAnalytics` (`InvAnalyticsID`, `AnalysisDate`, `Quantity`, `Costs`, `Materials_MaterialID`) VALUES (41, '2023-02-10 00:00:00', 470, 23500.00, 141);
2589INSERT INTO `mydb`.`InventoryAnalytics` (`InvAnalyticsID`, `AnalysisDate`, `Quantity`, `Costs`, `Materials_MaterialID`) VALUES (42, '2023-02-11 00:00:00', 480, 24000.00, 142);
2590INSERT INTO `mydb`.`InventoryAnalytics` (`InvAnalyticsID`, `AnalysisDate`, `Quantity`, `Costs`, `Materials_MaterialID`) VALUES (43, '2023-02-12 00:00:00', 490, 24500.00, 143);
2591INSERT INTO `mydb`.`InventoryAnalytics` (`InvAnalyticsID`, `AnalysisDate`, `Quantity`, `Costs`, `Materials_MaterialID`) VALUES (44, '2023-02-13 00:00:00', 500, 25000.00, 144);
2592INSERT INTO `mydb`.`InventoryAnalytics` (`InvAnalyticsID`, `AnalysisDate`, `Quantity`, `Costs`, `Materials_MaterialID`) VALUES (45, '2023-02-14 00:00:00', 510, 25500.00, 145);
2593INSERT INTO `mydb`.`InventoryAnalytics` (`InvAnalyticsID`, `AnalysisDate`, `Quantity`, `Costs`, `Materials_MaterialID`) VALUES (46, '2023-02-15 00:00:00', 520, 26000.00, 146);
2594INSERT INTO `mydb`.`InventoryAnalytics` (`InvAnalyticsID`, `AnalysisDate`, `Quantity`, `Costs`, `Materials_MaterialID`) VALUES (47, '2023-02-16 00:00:00', 530, 26500.00, 147);
2595INSERT INTO `mydb`.`InventoryAnalytics` (`InvAnalyticsID`, `AnalysisDate`, `Quantity`, `Costs`, `Materials_MaterialID`) VALUES (48, '2023-02-17 00:00:00', 540, 27000.00, 148);
2596INSERT INTO `mydb`.`InventoryAnalytics` (`InvAnalyticsID`, `AnalysisDate`, `Quantity`, `Costs`, `Materials_MaterialID`) VALUES (49, '2023-02-18 00:00:00', 550, 27500.00, 149);
2597INSERT INTO `mydb`.`InventoryAnalytics` (`InvAnalyticsID`, `AnalysisDate`, `Quantity`, `Costs`, `Materials_MaterialID`) VALUES (50, '2023-02-19 00:00:00', 560, 28000.00, 150);
2598
2599COMMIT;
2600
2601