217 lines
12 KiB
SQL
217 lines
12 KiB
SQL
-- MySQL dump 10.13 Distrib 8.0.36, for Win64 (x86_64)
|
||
--
|
||
-- Host: 192.168.201.207 Database: pozorisp_Safiulina
|
||
-- ------------------------------------------------------
|
||
-- 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 `cash_card`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `cash_card`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!50503 SET character_set_client = utf8mb4 */;
|
||
CREATE TABLE `cash_card` (
|
||
`idcash_card` int(10) unsigned zerofill NOT NULL,
|
||
`name` varchar(45) COLLATE utf8mb4_unicode_ci NOT NULL,
|
||
`surname` varchar(45) COLLATE utf8mb4_unicode_ci NOT NULL,
|
||
`patronomic` varchar(45) COLLATE utf8mb4_unicode_ci NOT NULL,
|
||
`number` bigint(11) NOT NULL,
|
||
`email` varchar(45) COLLATE utf8mb4_unicode_ci NOT NULL,
|
||
`discount` int(11) DEFAULT NULL,
|
||
PRIMARY KEY (`idcash_card`)
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Dumping data for table `cash_card`
|
||
--
|
||
|
||
LOCK TABLES `cash_card` WRITE;
|
||
/*!40000 ALTER TABLE `cash_card` DISABLE KEYS */;
|
||
INSERT INTO `cash_card` VALUES (0000000001,'Рябова','Ксения','Арсеньевна',89279008798,'o@outlook.com',10),(0000000002,'Панфилов','Любомир','Кириллович',89273478691,'hr6zdl@yandex.ru',NULL),(0000000003,'Шубина','Сабина','Васильевна',89270811514,'kaft93x@outlook.com',NULL),(0000000004,'Галкин','Александр','Мэлсович',89279031790,'dcu@yandex.ru',50),(0000000005,'Жданова','Камилла','Мартыновна',89270157133,'19dn@outlook.com',NULL),(0000000006,'Тихонова','Юстина','Васильевна',89278034056,'pa5h@mail.ru',NULL),(0000000007,'Ковалёв','Ян','Денисович',89273719956,'281av0@gmail.com',NULL),(0000000008,'Иванова','Руслана','Викторовна',89275002009,'8edmfh@outlook.com',15),(0000000009,'Агафонова','Марта','Тимофеевна',89271472717,'sfn13i@mail.ru',NULL),(0000000010,'Архипова','Селена','Парфеньевна',89272002572,'g0orc3x1@outlook.com',NULL),(0000000011,'Ковалёв','Константин','Тимурович',89271492887,'rv7bp@gmail.com',10),(0000000012,'Михеев','Мечеслав','Иосифович',89276527136,'93@outlook.com',NULL),(0000000013,'Горшков','Натан','Иосифович',89271570213,'er@gmail.com',NULL),(0000000014,'Селиверстова','Грета','Демьяновна',89273486043,'o0my@gmail.com',NULL),(0000000015,'Никонов','Климент','Иванович',89279247021,'715qy08@gmail.com',50),(0000000016,'Селезнёв','Юлиан','Семёнович',89277358712,'vubx0t@mail.ru',NULL),(0000000017,'Михайлов','Демьян','Федорович',89277089220,'wnhborq@outlook.com',NULL),(0000000018,'Носов','Яков','Гордеевич',89277837369,'gq@yandex.ru',70),(0000000019,'Казакова','Лигия','Богдановна',89278498606,'ic0pu@outlook.com',NULL),(0000000020,'Орлов','Петр','Аркадьевич',89274121250,'o7khr@yandex.ru',12),(0000000021,'Селиверстова','Мелитта','Артемовна',89278455642,'2shlaq@outlook.com',NULL),(0000000022,'Веселова','Фаня','Онисимовна',89279025708,'cdbw@yandex.ru',20);
|
||
/*!40000 ALTER TABLE `cash_card` ENABLE KEYS */;
|
||
UNLOCK TABLES;
|
||
|
||
--
|
||
-- Table structure for table `categoria`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `categoria`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!50503 SET character_set_client = utf8mb4 */;
|
||
CREATE TABLE `categoria` (
|
||
`idcategoria` int(11) NOT NULL AUTO_INCREMENT,
|
||
`categoria` varchar(45) COLLATE utf8mb4_unicode_ci NOT NULL,
|
||
PRIMARY KEY (`idcategoria`)
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Dumping data for table `categoria`
|
||
--
|
||
|
||
LOCK TABLES `categoria` WRITE;
|
||
/*!40000 ALTER TABLE `categoria` DISABLE KEYS */;
|
||
/*!40000 ALTER TABLE `categoria` ENABLE KEYS */;
|
||
UNLOCK TABLES;
|
||
|
||
--
|
||
-- Table structure for table `material`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `material`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!50503 SET character_set_client = utf8mb4 */;
|
||
CREATE TABLE `material` (
|
||
`idmaterial` int(11) NOT NULL AUTO_INCREMENT,
|
||
`material_name` varchar(45) COLLATE utf8mb4_unicode_ci NOT NULL,
|
||
`material_type_id` int(11) NOT NULL,
|
||
`price` varchar(45) COLLATE utf8mb4_unicode_ci NOT NULL,
|
||
`count` varchar(45) COLLATE utf8mb4_unicode_ci NOT NULL,
|
||
`count_min` varchar(45) COLLATE utf8mb4_unicode_ci NOT NULL,
|
||
`count_sht` int(11) NOT NULL,
|
||
`unit_id` int(11) NOT NULL,
|
||
PRIMARY KEY (`idmaterial`),
|
||
KEY `material_type_id_idx` (`material_type_id`),
|
||
KEY `unit_id_idx` (`unit_id`),
|
||
CONSTRAINT `material_type_id` FOREIGN KEY (`material_type_id`) REFERENCES `material_type` (`idmaterial_type`) ON DELETE NO ACTION ON UPDATE NO ACTION,
|
||
CONSTRAINT `unit_id` FOREIGN KEY (`unit_id`) REFERENCES `unit` (`idunit`) ON DELETE NO ACTION ON UPDATE NO ACTION
|
||
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Dumping data for table `material`
|
||
--
|
||
|
||
LOCK TABLES `material` WRITE;
|
||
/*!40000 ALTER TABLE `material` DISABLE KEYS */;
|
||
INSERT INTO `material` VALUES (1,'Глина',1,'15','1570','5500',30,1),(2,'Каолин',1,'18','1030','3500',25,1),(3,'Гидрослюда',1,'17','2147','3500',25,1),(4,'Монтмориллонит',1,'18','3000','3000',30,1),(5,'Перлит',2,'14','150','1000',50,2),(6,'Стекло',2,'2','3000','1500',500,1),(7,'Дегидратированная глина',2,'22','3000','2500',20,1),(8,'Шамот',2,'28','2300','1960',20,1),(9,'Техническая сода',3,'55','1200','1500',25,1),(10,'Жидкое стекло',3,'77','500','1500',15,1),(11,'Кварц',4,'376','1500','2500',10,1),(12,'Полевой шпат',4,'16','750','1500',100,1),(13,'Краска-раствор',4,'201','1496','2500',5,2),(14,'Порошок цветной',4,'84','511','1750',25,1),(15,'Кварцевый песок',2,'4','3000','1600',50,1),(16,'Жильный кварц',2,'19','2556','1600',25,1),(17,'Барий углекислый',4,'304','340','1500',25,1),(18,'Бура техническая',4,'126','165','1300',25,1),(19,'Углещелочной реагент',3,'3','450','1100',25,1),(20,'Пирофосфат натрия',3,'701','356','1200',25,1);
|
||
/*!40000 ALTER TABLE `material` 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 AUTO_INCREMENT,
|
||
`material_name` varchar(45) COLLATE utf8mb4_unicode_ci NOT NULL,
|
||
`material_type_зк` int(11) NOT NULL,
|
||
PRIMARY KEY (`idmaterial_type`)
|
||
) ENGINE=InnoDB AUTO_INCREMENT=5 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,'Пластичные материалы',12),(2,'Добавка',20),(3,'Электролит',15),(4,'Глазурь',30);
|
||
/*!40000 ALTER TABLE `material_type` 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(11) NOT NULL AUTO_INCREMENT,
|
||
`name_suppliers` varchar(45) COLLATE utf8mb4_unicode_ci NOT NULL,
|
||
`suppliers_type_id` int(11) NOT NULL,
|
||
`inn` bigint(15) NOT NULL,
|
||
`reitings` int(11) NOT NULL,
|
||
`data` date NOT NULL,
|
||
PRIMARY KEY (`idsuppliers`),
|
||
KEY `suppliers_type_id_idx` (`suppliers_type_id`),
|
||
CONSTRAINT `suppliers_type_id` FOREIGN KEY (`suppliers_type_id`) REFERENCES `suppliers_type` (`idsuppliers_type`) ON DELETE NO ACTION ON UPDATE NO ACTION
|
||
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Dumping data for table `suppliers`
|
||
--
|
||
|
||
LOCK TABLES `suppliers` WRITE;
|
||
/*!40000 ALTER TABLE `suppliers` DISABLE KEYS */;
|
||
INSERT INTO `suppliers` VALUES (2,'Стройкомплект',1,7803888520,7,'2017-09-13'),(3,'Железногорская руда',2,8430391035,7,'2016-12-23'),(4,'Белая гора',2,4318170454,8,'2019-05-27'),(5,'Тульский обрабатывающий завод',2,7687851800,7,'2015-06-16'),(6,'ГорТехРазработка',3,6119144874,9,'2021-12-27'),(7,'Сапфир',4,1122170258,3,'2022-04-10'),(8,'ХимБытСервис',3,8355114917,5,'2022-03-13'),(9,'ВоронежРудоКомбинат',4,3532367439,8,'2023-11-11'),(10,'Смоленский добывающий комбинат',4,2362431140,3,'2018-11-23'),(11,'МосКарьер',3,4159215346,2,'2012-07-07'),(12,'КурскРесурс',1,9032455179,4,'2021-07-23'),(13,'Нижегородская разработка',4,3776671267,9,'2016-05-23'),(14,'Речная долина',4,7447864518,8,'2015-06-25'),(15,'Карелия добыча',3,9037040523,6,'2017-03-09'),(16,'Московский ХимЗавод',3,6221520857,4,'2015-05-07'),(17,'Горная компания',1,2262431140,3,'2020-12-22'),(18,'Минерал Ресурс',2,4155215346,7,'2015-05-22'),(19,'Арсенал',1,3961234561,5,'2010-11-25'),(20,'КамчаткаСтройМинералы',1,9600275878,7,'2016-12-20');
|
||
/*!40000 ALTER TABLE `suppliers` ENABLE KEYS */;
|
||
UNLOCK TABLES;
|
||
|
||
--
|
||
-- Table structure for table `suppliers_type`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `suppliers_type`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!50503 SET character_set_client = utf8mb4 */;
|
||
CREATE TABLE `suppliers_type` (
|
||
`idsuppliers_type` int(11) NOT NULL AUTO_INCREMENT,
|
||
`suppliers_type` varchar(45) COLLATE utf8mb4_unicode_ci NOT NULL,
|
||
PRIMARY KEY (`idsuppliers_type`)
|
||
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Dumping data for table `suppliers_type`
|
||
--
|
||
|
||
LOCK TABLES `suppliers_type` WRITE;
|
||
/*!40000 ALTER TABLE `suppliers_type` DISABLE KEYS */;
|
||
INSERT INTO `suppliers_type` VALUES (1,'ЗАО'),(2,'ООО'),(3,'ПАО'),(4,'ОАО');
|
||
/*!40000 ALTER TABLE `suppliers_type` ENABLE KEYS */;
|
||
UNLOCK TABLES;
|
||
|
||
--
|
||
-- Table structure for table `unit`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `unit`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!50503 SET character_set_client = utf8mb4 */;
|
||
CREATE TABLE `unit` (
|
||
`idunit` int(11) NOT NULL AUTO_INCREMENT,
|
||
`unit_name` varchar(45) COLLATE utf8mb4_unicode_ci NOT NULL,
|
||
PRIMARY KEY (`idunit`)
|
||
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Dumping data for table `unit`
|
||
--
|
||
|
||
LOCK TABLES `unit` WRITE;
|
||
/*!40000 ALTER TABLE `unit` DISABLE KEYS */;
|
||
INSERT INTO `unit` VALUES (1,'кг'),(2,'литр');
|
||
/*!40000 ALTER TABLE `unit` 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 12:00:12
|