456 lines
16 KiB
SQL
456 lines
16 KiB
SQL
-- MySQL dump 10.13 Distrib 8.0.36, for Win64 (x86_64)
|
||
--
|
||
-- Host: 80.90.179.235 Database: pozorisp_ShakirovIV
|
||
-- ------------------------------------------------------
|
||
-- Server version 8.0.42
|
||
|
||
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
|
||
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
|
||
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
|
||
/*!50503 SET NAMES utf8 */;
|
||
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
|
||
/*!40103 SET TIME_ZONE='+00:00' */;
|
||
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
|
||
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
|
||
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
|
||
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
|
||
|
||
--
|
||
-- Table structure for table `Application`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `Application`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!50503 SET character_set_client = utf8mb4 */;
|
||
CREATE TABLE `Application` (
|
||
`idApplication` int NOT NULL AUTO_INCREMENT,
|
||
`PriceApplication` varchar(45) NOT NULL,
|
||
`DataBegin` varchar(45) NOT NULL,
|
||
`DataEnd` varchar(45) NOT NULL,
|
||
`ProductName` varchar(45) NOT NULL,
|
||
PRIMARY KEY (`idApplication`)
|
||
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Dumping data for table `Application`
|
||
--
|
||
|
||
LOCK TABLES `Application` WRITE;
|
||
/*!40000 ALTER TABLE `Application` DISABLE KEYS */;
|
||
INSERT INTO `Application` VALUES (1,'50000','2024.12.12','2024.12.18','продукт'),(2,'15000','2024.12.13','2024.12.19','продукт'),(3,'1000','2024.12.17','2024.12.20','услуга'),(4,'650200','2025.01.10','2025.01.13','продукт');
|
||
/*!40000 ALTER TABLE `Application` ENABLE KEYS */;
|
||
UNLOCK TABLES;
|
||
|
||
--
|
||
-- Table structure for table `Client`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `Client`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!50503 SET character_set_client = utf8mb4 */;
|
||
CREATE TABLE `Client` (
|
||
`idClient` int NOT NULL AUTO_INCREMENT,
|
||
`FIO` varchar(45) NOT NULL,
|
||
`Gender` varchar(45) NOT NULL,
|
||
`DataBirth` varchar(45) NOT NULL,
|
||
`HistoryOrder` varchar(45) DEFAULT NULL,
|
||
PRIMARY KEY (`idClient`)
|
||
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Dumping data for table `Client`
|
||
--
|
||
|
||
LOCK TABLES `Client` WRITE;
|
||
/*!40000 ALTER TABLE `Client` DISABLE KEYS */;
|
||
INSERT INTO `Client` VALUES (1,'Першин.М.С','м','2005.03.20','заказ2'),(2,'Горбачев.А.В.','м','2005.06.04','заказ3'),(3,'Матьякубов.Х.М.','м','1997.04.29','заказ1'),(4,'Шакиров И.В.','м','2005.05.17','заказ4');
|
||
/*!40000 ALTER TABLE `Client` ENABLE KEYS */;
|
||
UNLOCK TABLES;
|
||
|
||
--
|
||
-- Table structure for table `EmployeeClassification`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `EmployeeClassification`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!50503 SET character_set_client = utf8mb4 */;
|
||
CREATE TABLE `EmployeeClassification` (
|
||
`idEmployeeClassification` int NOT NULL AUTO_INCREMENT,
|
||
`Permission` varchar(45) NOT NULL,
|
||
`Discharge` varchar(45) NOT NULL,
|
||
PRIMARY KEY (`idEmployeeClassification`)
|
||
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Dumping data for table `EmployeeClassification`
|
||
--
|
||
|
||
LOCK TABLES `EmployeeClassification` WRITE;
|
||
/*!40000 ALTER TABLE `EmployeeClassification` DISABLE KEYS */;
|
||
INSERT INTO `EmployeeClassification` VALUES (1,'да','1'),(2,'да','2'),(3,'нет','3');
|
||
/*!40000 ALTER TABLE `EmployeeClassification` ENABLE KEYS */;
|
||
UNLOCK TABLES;
|
||
|
||
--
|
||
-- Table structure for table `Employees`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `Employees`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!50503 SET character_set_client = utf8mb4 */;
|
||
CREATE TABLE `Employees` (
|
||
`idEmployees` int NOT NULL AUTO_INCREMENT,
|
||
`FIO` varchar(45) NOT NULL,
|
||
`DateBirth` varchar(45) NOT NULL,
|
||
`JobTitle` varchar(45) NOT NULL,
|
||
`Experience` varchar(45) NOT NULL,
|
||
`MedicalDocument` varchar(45) NOT NULL,
|
||
PRIMARY KEY (`idEmployees`)
|
||
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Dumping data for table `Employees`
|
||
--
|
||
|
||
LOCK TABLES `Employees` WRITE;
|
||
/*!40000 ALTER TABLE `Employees` DISABLE KEYS */;
|
||
INSERT INTO `Employees` VALUES (1,'Петушков А.А.','2001.06.06','механник','2 года','нет'),(2,'Спирченкова Е.А.','2000.09.05','менеджер','3 года','нет'),(3,'Хонюков А.В.','1993.07.24','сборщик','5 лет','да'),(4,'Стародубцев П.С.','1985.12.15','Главный смены','8 лет','да');
|
||
/*!40000 ALTER TABLE `Employees` ENABLE KEYS */;
|
||
UNLOCK TABLES;
|
||
|
||
--
|
||
-- Table structure for table `HistoryOrder`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `HistoryOrder`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!50503 SET character_set_client = utf8mb4 */;
|
||
CREATE TABLE `HistoryOrder` (
|
||
`idHistoryOrder` int NOT NULL AUTO_INCREMENT,
|
||
`IdOrder` varchar(45) NOT NULL,
|
||
PRIMARY KEY (`idHistoryOrder`)
|
||
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Dumping data for table `HistoryOrder`
|
||
--
|
||
|
||
LOCK TABLES `HistoryOrder` WRITE;
|
||
/*!40000 ALTER TABLE `HistoryOrder` DISABLE KEYS */;
|
||
INSERT INTO `HistoryOrder` VALUES (1,'2'),(2,'3'),(3,'1');
|
||
/*!40000 ALTER TABLE `HistoryOrder` ENABLE KEYS */;
|
||
UNLOCK TABLES;
|
||
|
||
--
|
||
-- Table structure for table `InternalControl`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `InternalControl`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!50503 SET character_set_client = utf8mb4 */;
|
||
CREATE TABLE `InternalControl` (
|
||
`idInternalControl` int NOT NULL AUTO_INCREMENT,
|
||
`idCards` varchar(45) NOT NULL,
|
||
`DateBegin` varchar(45) NOT NULL,
|
||
`DateEnd` varchar(45) NOT NULL,
|
||
`TimeOfTriggeringCard` varchar(45) NOT NULL,
|
||
PRIMARY KEY (`idInternalControl`)
|
||
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Dumping data for table `InternalControl`
|
||
--
|
||
|
||
LOCK TABLES `InternalControl` WRITE;
|
||
/*!40000 ALTER TABLE `InternalControl` DISABLE KEYS */;
|
||
INSERT INTO `InternalControl` VALUES (1,'31','2025.02.05','2025.02.08','20сек'),(2,'22','2025.04.30','2025.05.02','15сек'),(3,'52','2025.03.21','2025.03.24','10сек'),(4,'17','2024.12.15','2024.12.18','21сек');
|
||
/*!40000 ALTER TABLE `InternalControl` ENABLE KEYS */;
|
||
UNLOCK TABLES;
|
||
|
||
--
|
||
-- Table structure for table `Materials`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `Materials`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!50503 SET character_set_client = utf8mb4 */;
|
||
CREATE TABLE `Materials` (
|
||
`idMaterials` int NOT NULL AUTO_INCREMENT,
|
||
`NameMaterial` varchar(45) NOT NULL,
|
||
`Type` varchar(45) NOT NULL,
|
||
`idSupplier` varchar(45) NOT NULL,
|
||
`TypeOfPackaging` varchar(45) NOT NULL,
|
||
`Unit` varchar(45) NOT NULL,
|
||
`Price` varchar(45) NOT NULL,
|
||
`QuantityInStock` varchar(45) NOT NULL,
|
||
`MinimumStock` varchar(45) NOT NULL,
|
||
`HistoryOfChange` varchar(45) NOT NULL,
|
||
PRIMARY KEY (`idMaterials`)
|
||
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Dumping data for table `Materials`
|
||
--
|
||
|
||
LOCK TABLES `Materials` WRITE;
|
||
/*!40000 ALTER TABLE `Materials` DISABLE KEYS */;
|
||
INSERT INTO `Materials` VALUES (1,'Тормозные колодки','запчасть','2','пачка','шт','500','100','10','2025.01.01'),(2,'Масло моторное','масло','3','бочка','л','700','150','20','2025.01.02'),(3,'Фильтр воздушный','запчасть','3','пачка','шт','250','80','15','2025.01.03'),(4,'Свечи зажигания','запчасть','1','пачка','шт','300','120','10','2025.01.04');
|
||
/*!40000 ALTER TABLE `Materials` ENABLE KEYS */;
|
||
UNLOCK TABLES;
|
||
|
||
--
|
||
-- Table structure for table `Partners`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `Partners`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!50503 SET character_set_client = utf8mb4 */;
|
||
CREATE TABLE `Partners` (
|
||
`idPartners` int NOT NULL AUTO_INCREMENT,
|
||
`TypeCompany` varchar(45) NOT NULL,
|
||
`INN` bigint NOT NULL,
|
||
`NumberPhone` bigint NOT NULL,
|
||
`Email` varchar(45) NOT NULL,
|
||
`NameCompany` varchar(45) NOT NULL,
|
||
`HistoryOrder` varchar(45) NOT NULL,
|
||
`Reyting` int NOT NULL,
|
||
PRIMARY KEY (`idPartners`)
|
||
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Dumping data for table `Partners`
|
||
--
|
||
|
||
LOCK TABLES `Partners` WRITE;
|
||
/*!40000 ALTER TABLE `Partners` DISABLE KEYS */;
|
||
INSERT INTO `Partners` VALUES (1,'Магазин запчастей',1234567890,74951234567,'parts24@exmaple.com','ООО \"Запчасти 24\"','Заказ №1, Заказ №2, Заказ №3, Заказ №4',4),(2,'Логистика',987654321,74952345678,'logistics@exmaple.com','ООО \"Логистикс\"','Заказ №1, Заказ №2, Заказ №3',6),(3,'Магазин запчастей',1122334455,74956789012,'partsauto@exmaple.com','ООО \"АвтоЗапчасти\"','Заказ №1, Заказ №5',9),(4,'Логистика',5544332211,74959876543,'translogistics@exmaple.com','ООО \"ТранспортГруз\"','Заказ №6, Заказ №7, Заказ №8',2);
|
||
/*!40000 ALTER TABLE `Partners` ENABLE KEYS */;
|
||
UNLOCK TABLES;
|
||
|
||
--
|
||
-- Table structure for table `PassCard`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `PassCard`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!50503 SET character_set_client = utf8mb4 */;
|
||
CREATE TABLE `PassCard` (
|
||
`idPassCard` int NOT NULL AUTO_INCREMENT,
|
||
`FIO` varchar(45) NOT NULL,
|
||
`JobTitle` varchar(45) NOT NULL,
|
||
PRIMARY KEY (`idPassCard`)
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Dumping data for table `PassCard`
|
||
--
|
||
|
||
LOCK TABLES `PassCard` WRITE;
|
||
/*!40000 ALTER TABLE `PassCard` DISABLE KEYS */;
|
||
/*!40000 ALTER TABLE `PassCard` ENABLE KEYS */;
|
||
UNLOCK TABLES;
|
||
|
||
--
|
||
-- Table structure for table `Products`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `Products`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!50503 SET character_set_client = utf8mb4 */;
|
||
CREATE TABLE `Products` (
|
||
`idProducts` int NOT NULL AUTO_INCREMENT,
|
||
PRIMARY KEY (`idProducts`)
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Dumping data for table `Products`
|
||
--
|
||
|
||
LOCK TABLES `Products` WRITE;
|
||
/*!40000 ALTER TABLE `Products` DISABLE KEYS */;
|
||
/*!40000 ALTER TABLE `Products` ENABLE KEYS */;
|
||
UNLOCK TABLES;
|
||
|
||
--
|
||
-- Table structure for table `ServicesAndGoods`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `ServicesAndGoods`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!50503 SET character_set_client = utf8mb4 */;
|
||
CREATE TABLE `ServicesAndGoods` (
|
||
`idServicesAndGoods` int NOT NULL AUTO_INCREMENT,
|
||
`Article` varchar(45) NOT NULL,
|
||
`Name` varchar(45) NOT NULL,
|
||
`Decription` varchar(45) DEFAULT NULL,
|
||
`MinimalPrice` varchar(45) NOT NULL,
|
||
`TimeToDoThat` varchar(45) NOT NULL,
|
||
`MaterialSpent` varchar(45) NOT NULL,
|
||
`NumberBox` varchar(45) DEFAULT NULL,
|
||
`Employees` varchar(45) NOT NULL,
|
||
PRIMARY KEY (`idServicesAndGoods`)
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Dumping data for table `ServicesAndGoods`
|
||
--
|
||
|
||
LOCK TABLES `ServicesAndGoods` WRITE;
|
||
/*!40000 ALTER TABLE `ServicesAndGoods` DISABLE KEYS */;
|
||
/*!40000 ALTER TABLE `ServicesAndGoods` ENABLE KEYS */;
|
||
UNLOCK TABLES;
|
||
|
||
--
|
||
-- Table structure for table `SupplierDeystviya`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `SupplierDeystviya`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!50503 SET character_set_client = utf8mb4 */;
|
||
CREATE TABLE `SupplierDeystviya` (
|
||
`idSupplierDeystviya` int NOT NULL AUTO_INCREMENT,
|
||
PRIMARY KEY (`idSupplierDeystviya`)
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Dumping data for table `SupplierDeystviya`
|
||
--
|
||
|
||
LOCK TABLES `SupplierDeystviya` WRITE;
|
||
/*!40000 ALTER TABLE `SupplierDeystviya` DISABLE KEYS */;
|
||
/*!40000 ALTER TABLE `SupplierDeystviya` ENABLE KEYS */;
|
||
UNLOCK TABLES;
|
||
|
||
--
|
||
-- Table structure for table `SupplierInfo`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `SupplierInfo`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!50503 SET character_set_client = utf8mb4 */;
|
||
CREATE TABLE `SupplierInfo` (
|
||
`idSupplierInfo` int NOT NULL AUTO_INCREMENT,
|
||
PRIMARY KEY (`idSupplierInfo`)
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Dumping data for table `SupplierInfo`
|
||
--
|
||
|
||
LOCK TABLES `SupplierInfo` WRITE;
|
||
/*!40000 ALTER TABLE `SupplierInfo` DISABLE KEYS */;
|
||
/*!40000 ALTER TABLE `SupplierInfo` ENABLE KEYS */;
|
||
UNLOCK TABLES;
|
||
|
||
--
|
||
-- Table structure for table `Suppliers`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `Suppliers`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!50503 SET character_set_client = utf8mb4 */;
|
||
CREATE TABLE `Suppliers` (
|
||
`idSuppliers` int NOT NULL AUTO_INCREMENT,
|
||
PRIMARY KEY (`idSuppliers`)
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Dumping data for table `Suppliers`
|
||
--
|
||
|
||
LOCK TABLES `Suppliers` WRITE;
|
||
/*!40000 ALTER TABLE `Suppliers` DISABLE KEYS */;
|
||
/*!40000 ALTER TABLE `Suppliers` ENABLE KEYS */;
|
||
UNLOCK TABLES;
|
||
|
||
--
|
||
-- Table structure for table `User`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `User`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!50503 SET character_set_client = utf8mb4 */;
|
||
CREATE TABLE `User` (
|
||
`idUser` int NOT NULL AUTO_INCREMENT,
|
||
PRIMARY KEY (`idUser`)
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Dumping data for table `User`
|
||
--
|
||
|
||
LOCK TABLES `User` WRITE;
|
||
/*!40000 ALTER TABLE `User` DISABLE KEYS */;
|
||
/*!40000 ALTER TABLE `User` ENABLE KEYS */;
|
||
UNLOCK TABLES;
|
||
|
||
--
|
||
-- Table structure for table `WarehouseInfo`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `WarehouseInfo`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!50503 SET character_set_client = utf8mb4 */;
|
||
CREATE TABLE `WarehouseInfo` (
|
||
`idWarehouseInfo` int NOT NULL AUTO_INCREMENT,
|
||
PRIMARY KEY (`idWarehouseInfo`)
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Dumping data for table `WarehouseInfo`
|
||
--
|
||
|
||
LOCK TABLES `WarehouseInfo` WRITE;
|
||
/*!40000 ALTER TABLE `WarehouseInfo` DISABLE KEYS */;
|
||
/*!40000 ALTER TABLE `WarehouseInfo` ENABLE KEYS */;
|
||
UNLOCK TABLES;
|
||
|
||
--
|
||
-- Table structure for table `WarehouseOfAction`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `WarehouseOfAction`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!50503 SET character_set_client = utf8mb4 */;
|
||
CREATE TABLE `WarehouseOfAction` (
|
||
`idWarehouseOfAction` int NOT NULL AUTO_INCREMENT,
|
||
PRIMARY KEY (`idWarehouseOfAction`)
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Dumping data for table `WarehouseOfAction`
|
||
--
|
||
|
||
LOCK TABLES `WarehouseOfAction` WRITE;
|
||
/*!40000 ALTER TABLE `WarehouseOfAction` DISABLE KEYS */;
|
||
/*!40000 ALTER TABLE `WarehouseOfAction` ENABLE KEYS */;
|
||
UNLOCK TABLES;
|
||
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
|
||
|
||
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
|
||
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
|
||
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
|
||
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
|
||
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
|
||
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
|
||
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
|
||
|
||
-- Dump completed on 2025-05-12 12:15:26
|