340 lines
19 KiB
SQL
340 lines
19 KiB
SQL
-- MySQL dump 10.13 Distrib 8.0.36, for Win64 (x86_64)
|
||
--
|
||
-- Host: cfif31.ru Database: ISPr25-21_NeshinaPV_1703
|
||
-- ------------------------------------------------------
|
||
-- Server version 8.0.45-0ubuntu0.24.04.1
|
||
|
||
/*!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 `clients`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `clients`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!50503 SET character_set_client = utf8mb4 */;
|
||
CREATE TABLE `clients` (
|
||
`id` int NOT NULL AUTO_INCREMENT,
|
||
`full_name` varchar(200) NOT NULL,
|
||
`phone` varchar(20) DEFAULT NULL,
|
||
`email` varchar(100) DEFAULT NULL,
|
||
`discount_card_id` int DEFAULT NULL,
|
||
PRIMARY KEY (`id`),
|
||
KEY `discount_card_id` (`discount_card_id`),
|
||
CONSTRAINT `clients_ibfk_1` FOREIGN KEY (`discount_card_id`) REFERENCES `discount_cards` (`id`)
|
||
) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Dumping data for table `clients`
|
||
--
|
||
|
||
LOCK TABLES `clients` WRITE;
|
||
/*!40000 ALTER TABLE `clients` DISABLE KEYS */;
|
||
INSERT INTO `clients` VALUES (1,'Рябова Ксения Арсеньевна','8(927)9008798','o@outlook.com',1),(2,'Панфилов Любомир Кириллович','8(927)3478691','hr6zdl@yandex.ru',2),(3,'Шубина Сабина Васильевна','8(927)0811514','kaft93x@outlook.com',3),(4,'Галкин Александр Мэлсович','8(927)9031790','dcu@yandex.ru',4),(5,'Жданова Камилла Мартыновна','8(927)0157133','19dn@outlook.com',5),(6,'Тихонова Юстина Васильевна','8(927)8034056','pa5h@mail.ru',6),(7,'Ковалёв Ян Денисович','8(927)3719956','281av0@gmail.com',7),(8,'Иванова Руслана Викторовна','8(927)5002009','8edmfh@outlook.com',8),(9,'Агафонова Марта Тимофеевна','8(927)1472717','sfn13i@mail.ru',9),(10,'Архипова Селена Парфеньевна','8(927)2002572','g0orc3x1@outlook.com',10),(11,'Ковалёв Константин Тимурович','8(927)1492887','rv7bp@gmail.com',11),(12,'Михеев Мечеслав Иосифович','8(927)6527136','93@outlook.com',12),(13,'Горшков Натан Иосифович','8(927)1570213','er@gmail.com',13),(14,'Селиверстова Грета Демьяновна','8(927)3486043','o0my@gmail.com',14),(15,'Никонов Климент Иванович','8(927)9247021','715qy08@gmail.com',15),(16,'Селезнёв Юлиан Семёнович','8(927)7358712','vubx0t@mail.ru',16),(17,'Михайлов Демьян Федорович','8(927)7089220','wnhborq@outlook.com',17),(18,'Носов Яков Гордеевич','8(927)7837369','gq@yandex.ru',18),(19,'Казакова Лигия Богдановна','8(927)8498606','ic0pu@outlook.com',19),(20,'Орлов Петр Аркадьевич','8(927)4121250','o7khr@yandex.ru',20),(21,'Селиверстова Мелитта Артемовна','8(927)8455642','2shlaq@outlook.com',21),(22,'Веселова Фаня Онисимовна','8(927)9025708','cdbw@yandex.ru',22);
|
||
/*!40000 ALTER TABLE `clients` ENABLE KEYS */;
|
||
UNLOCK TABLES;
|
||
|
||
--
|
||
-- Table structure for table `discount_cards`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `discount_cards`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!50503 SET character_set_client = utf8mb4 */;
|
||
CREATE TABLE `discount_cards` (
|
||
`id` int NOT NULL AUTO_INCREMENT,
|
||
`discount_percentage` decimal(5,2) DEFAULT '0.00',
|
||
PRIMARY KEY (`id`)
|
||
) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Dumping data for table `discount_cards`
|
||
--
|
||
|
||
LOCK TABLES `discount_cards` WRITE;
|
||
/*!40000 ALTER TABLE `discount_cards` DISABLE KEYS */;
|
||
INSERT INTO `discount_cards` VALUES (1,10.00),(2,0.00),(3,0.00),(4,50.00),(5,0.00),(6,0.00),(7,0.00),(8,15.00),(9,0.00),(10,0.00),(11,10.00),(12,0.00),(13,0.00),(14,0.00),(15,50.00),(16,0.00),(17,0.00),(18,70.00),(19,0.00),(20,12.00),(21,0.00),(22,20.00);
|
||
/*!40000 ALTER TABLE `discount_cards` ENABLE KEYS */;
|
||
UNLOCK TABLES;
|
||
|
||
--
|
||
-- Table structure for table `dispensing_statuses`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `dispensing_statuses`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!50503 SET character_set_client = utf8mb4 */;
|
||
CREATE TABLE `dispensing_statuses` (
|
||
`id` int NOT NULL AUTO_INCREMENT,
|
||
`status_name` varchar(50) NOT NULL,
|
||
PRIMARY KEY (`id`),
|
||
UNIQUE KEY `status_name` (`status_name`)
|
||
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Dumping data for table `dispensing_statuses`
|
||
--
|
||
|
||
LOCK TABLES `dispensing_statuses` WRITE;
|
||
/*!40000 ALTER TABLE `dispensing_statuses` DISABLE KEYS */;
|
||
INSERT INTO `dispensing_statuses` VALUES (2,'По рецепту'),(1,'Свободно');
|
||
/*!40000 ALTER TABLE `dispensing_statuses` 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` (
|
||
`id` int NOT NULL AUTO_INCREMENT,
|
||
`full_name` varchar(200) NOT NULL,
|
||
`position_id` int NOT NULL,
|
||
`phone` varchar(20) DEFAULT NULL,
|
||
`email` varchar(100) DEFAULT NULL,
|
||
`password_hash` varchar(255) DEFAULT NULL,
|
||
PRIMARY KEY (`id`),
|
||
UNIQUE KEY `email` (`email`),
|
||
KEY `position_id` (`position_id`),
|
||
CONSTRAINT `employees_ibfk_1` FOREIGN KEY (`position_id`) REFERENCES `positions` (`id`)
|
||
) ENGINE=InnoDB AUTO_INCREMENT=13 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,'Артемьев Илья Геннадиевич',1,'8(927)3298823','2de17h@mail.ru','tYS7a7'),(2,'Богданов Гавриил Кимович',2,'8(927)7157085','we3l08z5@gmail.com','rA19Gu'),(3,'Вишнякова Габи Егоровна',1,'8(927)7813388','i8ovxn2f@gmail.com','bR2r01'),(4,'Воробьёв Евдоким Ефимович',2,'8(927)8099201','q4as80@outlook.com','ynDtcg'),(5,'Гаврилов Петр Степанович',2,'8(927)3042375','opu@outlook.com','BNRvda'),(6,'Дроздова Роксана Ростиславовна',2,'8(927)8089832','5iar3l8k@yandex.ru','jkJvld'),(7,'Емельянова Инара Рудольфовна',2,'8(927)2396270','4zegxla@mail.ru','hUR2No'),(8,'Ефимова Марина Пантелеймоновна',2,'8(927)7900026','8lf0g@yandex.ru','I6tR5H'),(9,'Зимина Анжела Макаровна',2,'8(927)2056718','1zx8@yandex.ru','5kVTBm'),(10,'Исаева Вероника Андреевна',1,'8(927)1760187','x@mail.ru','OunjSy'),(11,'11',1,'1','1','1'),(12,'2',2,'2','2','2');
|
||
/*!40000 ALTER TABLE `employees` ENABLE KEYS */;
|
||
UNLOCK TABLES;
|
||
|
||
--
|
||
-- Table structure for table `medications`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `medications`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!50503 SET character_set_client = utf8mb4 */;
|
||
CREATE TABLE `medications` (
|
||
`id` int NOT NULL AUTO_INCREMENT,
|
||
`medication_name` varchar(200) NOT NULL,
|
||
`price` decimal(10,2) NOT NULL,
|
||
`discount_percent` decimal(5,2) DEFAULT '0.00',
|
||
`stock_quantity` int DEFAULT '0',
|
||
`batch_number` varchar(50) DEFAULT NULL,
|
||
`supplier_id` int DEFAULT NULL,
|
||
`dispensing_status_id` int DEFAULT NULL,
|
||
`image_filename` varchar(255) DEFAULT NULL,
|
||
`has_analog` tinyint(1) DEFAULT '0',
|
||
PRIMARY KEY (`id`),
|
||
UNIQUE KEY `medication_name` (`medication_name`),
|
||
KEY `supplier_id` (`supplier_id`),
|
||
KEY `dispensing_status_id` (`dispensing_status_id`),
|
||
CONSTRAINT `medications_ibfk_1` FOREIGN KEY (`supplier_id`) REFERENCES `suppliers` (`id`),
|
||
CONSTRAINT `medications_ibfk_2` FOREIGN KEY (`dispensing_status_id`) REFERENCES `dispensing_statuses` (`id`)
|
||
) ENGINE=InnoDB AUTO_INCREMENT=32 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Dumping data for table `medications`
|
||
--
|
||
|
||
LOCK TABLES `medications` WRITE;
|
||
/*!40000 ALTER TABLE `medications` DISABLE KEYS */;
|
||
INSERT INTO `medications` VALUES (1,'Саланабапамид',345.00,23.00,5,'895F47',1,1,NULL,1),(2,'Набаальдоламезин',654.00,40.00,7,'785R89',2,1,'Nabaaldolamezin.jpg',0),(3,'Наббулин',235.00,23.00,3,'359R87',3,1,NULL,0),(4,'Гуантокслептин',985.00,0.00,9,'568P49',4,1,NULL,1),(5,'Эстрпласнинин',257.00,25.00,10,'784L69',5,1,NULL,0),(6,'Гуаназепам',2356.00,20.00,15,'321X45',6,2,'Guanazepam.jpg',1),(7,'Перфлуастатрсен',876.00,0.00,37,'456T34',7,1,NULL,0),(8,'Пегикортролин',234.00,0.00,12,'878W15',4,1,NULL,0),(9,'Гуанастатифунгин',975.00,10.00,45,'457Q59',1,1,NULL,1),(10,'Вираппредатин',345.00,0.00,6,'577F89',2,1,NULL,1),(11,'Эстроксан',3232.00,30.00,3,'785W91',8,2,NULL,1),(12,'Винонид',989.00,0.00,7,'365W78',5,1,NULL,0),(13,'Гадокрин',2324.00,0.00,12,'159U45',3,2,'Gadocrine.jpg',0),(14,'Йоивиртеплаза',987.00,15.00,12,'564Q54',9,1,NULL,0),(15,'Гадоадан',457.00,0.00,12,'217H87',4,1,NULL,0),(16,'Винипоэтин',2390.00,10.00,24,'347H88',10,2,NULL,1),(17,'Предистатин',432.00,0.00,34,'278R45',3,1,'Predistatin.jpg',1),(18,'Пегиконазол',89.00,0.00,84,'450M78',7,1,NULL,0),(19,'Набинертант',4326.00,10.00,25,'327N48',1,2,NULL,0),(20,'Перфлудилакарбеф',87.00,0.00,0,'278W78',2,1,NULL,0),(21,'Эстретиникасан',2323.00,20.00,54,'578Q21',11,2,'Estretinikasan.jpg',0),(22,'Гадоиметацин',654.00,0.00,27,'658Z74',12,1,NULL,0),(23,'Нифурисульфан',98.00,0.00,68,'245A14',1,1,NULL,1),(24,'Дилипредипидем',345.00,0.00,14,'357I24',6,1,'Dilipredipidem.jpg',1),(25,'Салалдолкатиб',8796.00,0.00,18,'548F57',4,2,NULL,0),(26,'Вирлезауридин',2353.00,0.00,22,'359D68',8,2,NULL,0),(27,'Кальцидант',3465.00,0.00,24,'574H57',10,2,NULL,0),(28,'Предаэргаэнтан',7543.00,10.00,12,'570S56',6,2,NULL,0),(29,'Дилимонам',973.00,0.00,48,'590K54',8,1,'Dilimonam.jpg',1),(30,'Нифуридилфунгин',983.00,0.00,0,'534B67',1,1,NULL,NULL),(31,'ppp',99.00,0.00,0,NULL,NULL,2,NULL,1);
|
||
/*!40000 ALTER TABLE `medications` ENABLE KEYS */;
|
||
UNLOCK TABLES;
|
||
|
||
--
|
||
-- Table structure for table `positions`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `positions`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!50503 SET character_set_client = utf8mb4 */;
|
||
CREATE TABLE `positions` (
|
||
`id` int NOT NULL AUTO_INCREMENT,
|
||
`position_name` varchar(100) NOT NULL,
|
||
PRIMARY KEY (`id`),
|
||
UNIQUE KEY `position_name` (`position_name`)
|
||
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Dumping data for table `positions`
|
||
--
|
||
|
||
LOCK TABLES `positions` WRITE;
|
||
/*!40000 ALTER TABLE `positions` DISABLE KEYS */;
|
||
INSERT INTO `positions` VALUES (1,'Главный фармацевт'),(2,'Фармацевт');
|
||
/*!40000 ALTER TABLE `positions` ENABLE KEYS */;
|
||
UNLOCK TABLES;
|
||
|
||
--
|
||
-- Table structure for table `prescription_medications`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `prescription_medications`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!50503 SET character_set_client = utf8mb4 */;
|
||
CREATE TABLE `prescription_medications` (
|
||
`prescription_id` int NOT NULL,
|
||
`medication_id` int NOT NULL,
|
||
PRIMARY KEY (`prescription_id`,`medication_id`),
|
||
KEY `medication_id` (`medication_id`),
|
||
CONSTRAINT `prescription_medications_ibfk_1` FOREIGN KEY (`prescription_id`) REFERENCES `prescriptions` (`id`) ON DELETE CASCADE,
|
||
CONSTRAINT `prescription_medications_ibfk_2` FOREIGN KEY (`medication_id`) REFERENCES `medications` (`id`)
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Dumping data for table `prescription_medications`
|
||
--
|
||
|
||
LOCK TABLES `prescription_medications` WRITE;
|
||
/*!40000 ALTER TABLE `prescription_medications` DISABLE KEYS */;
|
||
INSERT INTO `prescription_medications` VALUES (1,11),(6,11),(5,16),(7,19),(4,25),(3,26),(3,27),(8,27),(2,28);
|
||
/*!40000 ALTER TABLE `prescription_medications` ENABLE KEYS */;
|
||
UNLOCK TABLES;
|
||
|
||
--
|
||
-- Table structure for table `prescriptions`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `prescriptions`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!50503 SET character_set_client = utf8mb4 */;
|
||
CREATE TABLE `prescriptions` (
|
||
`id` int NOT NULL AUTO_INCREMENT,
|
||
`prescription_number` varchar(20) NOT NULL,
|
||
`client_id` int NOT NULL,
|
||
`valid_until` date DEFAULT NULL,
|
||
PRIMARY KEY (`id`),
|
||
UNIQUE KEY `prescription_number` (`prescription_number`),
|
||
KEY `client_id` (`client_id`),
|
||
CONSTRAINT `prescriptions_ibfk_1` FOREIGN KEY (`client_id`) REFERENCES `clients` (`id`)
|
||
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Dumping data for table `prescriptions`
|
||
--
|
||
|
||
LOCK TABLES `prescriptions` WRITE;
|
||
/*!40000 ALTER TABLE `prescriptions` DISABLE KEYS */;
|
||
INSERT INTO `prescriptions` VALUES (1,'893672',18,'2022-04-10'),(2,'102395',5,'2022-05-04'),(3,'778102',7,'2022-06-05'),(4,'487832',2,'2022-09-29'),(5,'479878',16,'2022-12-06'),(6,'474721',19,'2023-01-15'),(7,'874962',6,'2023-02-05'),(8,'150369',21,'2023-02-17');
|
||
/*!40000 ALTER TABLE `prescriptions` ENABLE KEYS */;
|
||
UNLOCK TABLES;
|
||
|
||
--
|
||
-- Table structure for table `purchase_medications`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `purchase_medications`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!50503 SET character_set_client = utf8mb4 */;
|
||
CREATE TABLE `purchase_medications` (
|
||
`id` int NOT NULL AUTO_INCREMENT,
|
||
`purchase_id` int NOT NULL,
|
||
`medication_id` int NOT NULL,
|
||
`quantity` int NOT NULL DEFAULT '1',
|
||
PRIMARY KEY (`id`),
|
||
KEY `purchase_id` (`purchase_id`),
|
||
KEY `medication_id` (`medication_id`),
|
||
CONSTRAINT `purchase_medications_ibfk_1` FOREIGN KEY (`purchase_id`) REFERENCES `purchases` (`id`) ON DELETE CASCADE,
|
||
CONSTRAINT `purchase_medications_ibfk_2` FOREIGN KEY (`medication_id`) REFERENCES `medications` (`id`)
|
||
) ENGINE=InnoDB AUTO_INCREMENT=42 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Dumping data for table `purchase_medications`
|
||
--
|
||
|
||
LOCK TABLES `purchase_medications` WRITE;
|
||
/*!40000 ALTER TABLE `purchase_medications` DISABLE KEYS */;
|
||
INSERT INTO `purchase_medications` VALUES (1,1,3,2),(2,1,17,1),(3,2,12,3),(4,3,24,2),(5,3,23,2),(6,4,11,1),(7,5,28,1),(8,6,9,2),(9,6,15,2),(10,7,26,1),(11,7,27,2),(12,8,5,3),(13,8,3,3),(14,8,1,1),(15,9,10,5),(16,10,14,2),(17,10,9,1),(18,11,14,2),(19,11,16,2),(20,12,20,7),(21,13,24,3),(22,13,25,1),(23,14,9,2),(24,15,18,4),(25,15,19,1),(26,16,5,2),(27,16,16,2),(28,17,29,3),(29,18,24,3),(30,18,6,1),(31,19,11,2),(32,20,2,4),(33,20,19,1),(34,21,27,2),(35,22,10,4),(36,22,7,1),(37,23,16,1),(38,23,15,1),(39,23,26,1),(40,24,15,1),(41,24,13,3);
|
||
/*!40000 ALTER TABLE `purchase_medications` ENABLE KEYS */;
|
||
UNLOCK TABLES;
|
||
|
||
--
|
||
-- Table structure for table `purchases`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `purchases`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!50503 SET character_set_client = utf8mb4 */;
|
||
CREATE TABLE `purchases` (
|
||
`id` int NOT NULL AUTO_INCREMENT,
|
||
`purchase_date` date NOT NULL,
|
||
`client_id` int DEFAULT NULL,
|
||
`prescription_id` int DEFAULT NULL,
|
||
PRIMARY KEY (`id`),
|
||
KEY `client_id` (`client_id`),
|
||
KEY `prescription_id` (`prescription_id`),
|
||
CONSTRAINT `purchases_ibfk_1` FOREIGN KEY (`client_id`) REFERENCES `clients` (`id`),
|
||
CONSTRAINT `purchases_ibfk_2` FOREIGN KEY (`prescription_id`) REFERENCES `prescriptions` (`id`)
|
||
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Dumping data for table `purchases`
|
||
--
|
||
|
||
LOCK TABLES `purchases` WRITE;
|
||
/*!40000 ALTER TABLE `purchases` DISABLE KEYS */;
|
||
INSERT INTO `purchases` VALUES (1,'2022-03-14',1,NULL),(2,'2022-03-31',NULL,NULL),(3,'2022-04-05',3,NULL),(4,'2022-04-08',18,1),(5,'2022-05-03',5,2),(6,'2022-05-17',NULL,NULL),(7,'2022-06-02',7,3),(8,'2022-06-20',NULL,NULL),(9,'2022-07-11',22,NULL),(10,'2022-07-29',NULL,NULL),(11,'2022-08-29',11,NULL),(12,'2022-09-16',12,NULL),(13,'2022-09-28',2,4),(14,'2022-11-01',NULL,NULL),(15,'2022-11-25',15,NULL),(16,'2022-12-06',16,5),(17,'2022-12-20',NULL,NULL),(18,'2023-01-03',NULL,NULL),(19,'2023-01-11',19,6),(20,'2023-02-01',6,7),(21,'2023-02-15',21,8),(22,'2023-02-22',22,NULL),(23,'2026-03-17',NULL,NULL),(24,'2026-03-17',NULL,NULL);
|
||
/*!40000 ALTER TABLE `purchases` 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` (
|
||
`id` int NOT NULL AUTO_INCREMENT,
|
||
`supplier_name` varchar(200) NOT NULL,
|
||
PRIMARY KEY (`id`),
|
||
UNIQUE KEY `supplier_name` (`supplier_name`)
|
||
) ENGINE=InnoDB AUTO_INCREMENT=13 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 */;
|
||
INSERT INTO `suppliers` VALUES (2,'ООО \"Абочкисилк\"'),(4,'ООО \"Дагкан\"'),(9,'ООО \"Енгозмирос\"'),(5,'ООО \"Канзарбуко\"'),(6,'ООО \"Квинто\"'),(7,'ООО \"Кисилкамоч\"'),(3,'ООО \"Летаг\"'),(10,'ООО \"Лотаточкам\"'),(1,'ООО \"Нзарбуколу\"'),(12,'ООО \"Раббаг\"'),(8,'ООО \"Роуз\"'),(11,'ООО \"Яченгоуроз\"');
|
||
/*!40000 ALTER TABLE `suppliers` 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-03-17 13:35:45
|