-- MySQL dump 10.13  Distrib 8.0.36, for Win64 (x86_64)
--
-- Host: 192.168.201.207    Database: pozorisp_sosn
-- ------------------------------------------------------
-- Server version	5.7.44

/*!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 `MaterialName`
--

DROP TABLE IF EXISTS `MaterialName`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `MaterialName` (
  `idMaterialName` int(11) NOT NULL,
  `MaterialName` varchar(45) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`idMaterialName`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `MaterialName`
--

LOCK TABLES `MaterialName` WRITE;
/*!40000 ALTER TABLE `MaterialName` DISABLE KEYS */;
INSERT INTO `MaterialName` VALUES (1,'Техническая сода'),(2,'Пирофосфат натрия'),(3,'Перлит'),(4,'Глина'),(5,'Монтмориллонит'),(6,'Углещелочной реагент'),(7,'Бура техническая'),(8,'Пирофосфат натрия'),(9,'Жильный кварц'),(10,'Стекло'),(11,'Барий углекислый'),(12,'Каолин'),(13,'Шамот'),(14,'Краска-раствор'),(15,'Полевой шпат'),(16,'Гидрослюда');
/*!40000 ALTER TABLE `MaterialName` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `Material_suppliers`
--

DROP TABLE IF EXISTS `Material_suppliers`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `Material_suppliers` (
  `idMaterial_suppliers` int(11) NOT NULL,
  `idMaterialName` int(11) NOT NULL,
  `idSupplier` int(11) NOT NULL,
  PRIMARY KEY (`idMaterial_suppliers`),
  KEY `MATERIALNAME_idx` (`idMaterialName`),
  KEY `SUPP_idx` (`idSupplier`),
  CONSTRAINT `MATERIALNAME` FOREIGN KEY (`idMaterialName`) REFERENCES `MaterialName` (`idMaterialName`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `SUPP` FOREIGN KEY (`idSupplier`) REFERENCES `Supplier` (`idPostav`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `Material_suppliers`
--

LOCK TABLES `Material_suppliers` WRITE;
/*!40000 ALTER TABLE `Material_suppliers` DISABLE KEYS */;
INSERT INTO `Material_suppliers` VALUES (1,16,5),(2,8,7),(3,3,5),(4,1,7),(5,4,10),(6,1,16),(7,5,10),(8,6,12),(9,1,8),(10,7,2),(11,8,5),(12,9,10),(13,10,2),(14,6,8),(15,11,5),(16,8,8),(17,12,5),(18,13,11),(19,6,5),(20,14,8),(21,15,10);
/*!40000 ALTER TABLE `Material_suppliers` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `Material_type`
--

DROP TABLE IF EXISTS `Material_type`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `Material_type` (
  `idMaterial_type` int(11) NOT NULL,
  `TypeMaterial` varchar(45) COLLATE utf8mb4_unicode_ci NOT NULL,
  `Percent` varchar(45) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`idMaterial_type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `Material_type`
--

LOCK TABLES `Material_type` WRITE;
/*!40000 ALTER TABLE `Material_type` DISABLE KEYS */;
INSERT INTO `Material_type` VALUES (1,'Пластичные материалы','0,12%'),(2,'Добавка','0,20%'),(3,'Электролит','0,15%'),(4,'Глазурь','0,30%'),(5,'Пигмент','0,25%');
/*!40000 ALTER TABLE `Material_type` 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(11) NOT NULL,
  `idMaterial_suppliers` int(11) NOT NULL,
  `idMaterial_type` int(11) NOT NULL,
  `PriceEd` int(11) NOT NULL,
  `SkladCol` int(11) NOT NULL,
  `MinCol` int(11) NOT NULL,
  `ColInPack` int(11) NOT NULL,
  `ided_izm` int(11) NOT NULL,
  PRIMARY KEY (`idMaterials`),
  KEY `MATERIALSUPP_idx` (`idMaterial_suppliers`),
  KEY `MATERIALTYPE_idx` (`idMaterial_type`),
  KEY `IDEZIZM_idx` (`ided_izm`),
  CONSTRAINT `IDEZIZM` FOREIGN KEY (`ided_izm`) REFERENCES `ed_izm` (`ided_izm`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `MATERIALSUPP` FOREIGN KEY (`idMaterial_suppliers`) REFERENCES `Material_suppliers` (`idMaterial_suppliers`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `MATERIALTYPE` FOREIGN KEY (`idMaterial_type`) REFERENCES `Material_type` (`idMaterial_type`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_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,1,1,15,1570,5500,30,1),(2,1,1,18,1030,3500,25,1),(3,1,1,17,2147,3500,25,1),(4,1,1,17,3000,3000,30,1),(5,1,2,13,150,1000,50,2),(6,1,2,2,3000,1500,500,1),(7,1,2,21,3000,2500,20,1),(8,1,2,27,2300,1960,20,1),(9,1,3,54,1200,1500,25,1),(10,1,3,76,500,1500,15,1),(11,1,4,375,1500,2500,10,1),(12,1,4,15,750,1500,100,1),(13,1,5,200,1496,2500,5,2),(14,1,5,84,511,1750,25,1),(15,1,2,4,3000,1600,50,1),(16,1,2,18,2556,1600,25,1),(17,1,4,303,340,1500,25,1),(18,1,4,125,165,1300,25,1),(19,1,3,3,450,1100,25,1),(20,1,3,700,356,1200,25,1);
/*!40000 ALTER TABLE `Materials` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `Supplier`
--

DROP TABLE IF EXISTS `Supplier`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `Supplier` (
  `idPostav` int(11) NOT NULL,
  `Name` varchar(45) COLLATE utf8mb4_unicode_ci NOT NULL,
  `Type` varchar(45) COLLATE utf8mb4_unicode_ci NOT NULL,
  `INN` int(10) NOT NULL,
  `Rate` int(2) NOT NULL,
  `DateStart` date NOT NULL,
  PRIMARY KEY (`idPostav`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `Supplier`
--

LOCK TABLES `Supplier` WRITE;
/*!40000 ALTER TABLE `Supplier` DISABLE KEYS */;
INSERT INTO `Supplier` VALUES (1,'БрянскСтройресурс','ЗАО',9,8,'2020-12-20'),(2,'Стройкомплект','ЗАО',8,7,'2013-09-20'),(3,'Железногорская руда','ООО',8,7,'2023-12-20'),(4,'Белая гора','ООО',4,8,'2027-05-20'),(5,'Тульский обрабатывающий завод','ООО',8,7,'2016-06-20'),(6,'ГорТехРазработка','ПАО',6,9,'2027-12-20'),(7,'Сапфир','ОАО',1,3,'2010-04-20'),(8,'ХимБытСервис','ПАО',8,5,'2013-03-20'),(9,'ВоронежРудоКомбинат','ОАО',4,8,'2011-11-20'),(10,'Смоленский добывающий комбинат','ОАО',2,3,'2023-11-20'),(11,'МосКарьер','ПАО',4,2,'2007-07-20'),(12,'КурскРесурс','ЗАО',9,4,'2023-07-20'),(13,'Нижегородская разработка','ОАО',4,9,'2023-05-20'),(14,'Речная долина','ОАО',7,8,'2025-06-20'),(15,'Карелия добыча','ПАО',9,6,'2009-03-20'),(16,'Московский ХимЗавод','ПАО',6,4,'2007-05-20'),(17,'Горная компания','ЗАО',2,3,'2022-12-20'),(18,'Минерал Ресурс','ООО',4,7,'2022-05-20'),(19,'Арсенал','ЗАО',4,5,'2025-11-20'),(20,'КамчаткаСтройМинералы','ЗАО',9,7,'2020-12-20');
/*!40000 ALTER TABLE `Supplier` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `TypeProduct`
--

DROP TABLE IF EXISTS `TypeProduct`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `TypeProduct` (
  `idTypeProduct` int(11) NOT NULL,
  `TypeName` varchar(45) COLLATE utf8mb4_unicode_ci NOT NULL,
  `TypeKoof` int(11) NOT NULL,
  PRIMARY KEY (`idTypeProduct`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `TypeProduct`
--

LOCK TABLES `TypeProduct` WRITE;
/*!40000 ALTER TABLE `TypeProduct` DISABLE KEYS */;
INSERT INTO `TypeProduct` VALUES (1,'Тип продукции 1',1),(2,'Тип продукции 2',9),(3,'Тип продукции 3',4),(4,'Тип продукции 4',6);
/*!40000 ALTER TABLE `TypeProduct` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ed_izm`
--

DROP TABLE IF EXISTS `ed_izm`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `ed_izm` (
  `ided_izm` int(11) NOT NULL,
  `Name` varchar(45) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`ided_izm`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ed_izm`
--

LOCK TABLES `ed_izm` WRITE;
/*!40000 ALTER TABLE `ed_izm` DISABLE KEYS */;
INSERT INTO `ed_izm` VALUES (1,'кг'),(2,'л');
/*!40000 ALTER TABLE `ed_izm` 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 2026-05-15 10:35:56