· 8 years ago · Dec 07, 2017, 11:30 AM
1-- MySQL dump 10.13 Distrib 5.7.17, for macos10.12 (x86_64)
2--
3-- Host: 127.0.0.1 Database: db1
4-- ------------------------------------------------------
5-- Server version 5.7.19
6
7/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
8/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
9/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
10/*!40101 SET NAMES utf8 */;
11/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
12/*!40103 SET TIME_ZONE='+00:00' */;
13/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
14/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
15/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
16/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
17
18--
19-- Table structure for table `have`
20--
21
22DROP TABLE IF EXISTS `have`;
23/*!40101 SET @saved_cs_client = @@character_set_client */;
24/*!40101 SET character_set_client = utf8 */;
25CREATE TABLE `have` (
26 `item_id` int(4) NOT NULL,
27 `imei` double NOT NULL,
28 `item_cost` decimal(10,0) NOT NULL,
29 PRIMARY KEY (`imei`),
30 UNIQUE KEY `imei_UNIQUE` (`imei`),
31 KEY `items_have_idx` (`item_id`),
32 CONSTRAINT `items_have` FOREIGN KEY (`item_id`) REFERENCES `items` (`item_id`) ON DELETE NO ACTION ON UPDATE NO ACTION
33) ENGINE=InnoDB DEFAULT CHARSET=latin1;
34/*!40101 SET character_set_client = @saved_cs_client */;
35
36--
37-- Dumping data for table `have`
38--
39
40LOCK TABLES `have` WRITE;
41/*!40000 ALTER TABLE `have` DISABLE KEYS */;
42INSERT INTO `have` VALUES (5,352024506065785,16000),(4,352024506065786,13200),(3,352024506065787,7800),(2,352024506065788,5700),(1,352024506065789,3600);
43/*!40000 ALTER TABLE `have` ENABLE KEYS */;
44UNLOCK TABLES;
45
46--
47-- Table structure for table `items`
48--
49
50DROP TABLE IF EXISTS `items`;
51/*!40101 SET @saved_cs_client = @@character_set_client */;
52/*!40101 SET character_set_client = utf8 */;
53CREATE TABLE `items` (
54 `item_id` int(4) NOT NULL,
55 `item_name` varchar(150) NOT NULL,
56 `price` decimal(10,0) unsigned NOT NULL,
57 `price_opt_3` decimal(10,0) unsigned NOT NULL,
58 `price_opt_5` decimal(10,0) unsigned NOT NULL,
59 `kol` decimal(10,0) unsigned NOT NULL,
60 PRIMARY KEY (`item_id`),
61 UNIQUE KEY `item_id_UNIQUE` (`item_id`),
62 UNIQUE KEY `item_ name_UNIQUE` (`item_name`)
63) ENGINE=InnoDB DEFAULT CHARSET=latin1;
64/*!40101 SET character_set_client = @saved_cs_client */;
65
66--
67-- Dumping data for table `items`
68--
69
70LOCK TABLES `items` WRITE;
71/*!40000 ALTER TABLE `items` DISABLE KEYS */;
72INSERT INTO `items` VALUES (1,'iPhone 4s',4300,4000,3900,1),(2,'iPhone 5',6500,6100,6000,1),(3,'iPhone 5s',9000,8300,8200,1),(4,'iPhone 6',14500,13900,13700,1),(5,'iPhone 6s',19000,17300,17000,1);
73/*!40000 ALTER TABLE `items` ENABLE KEYS */;
74UNLOCK TABLES;
75
76--
77-- Table structure for table `persons`
78--
79
80DROP TABLE IF EXISTS `persons`;
81/*!40101 SET @saved_cs_client = @@character_set_client */;
82/*!40101 SET character_set_client = utf8 */;
83CREATE TABLE `persons` (
84 `person_id` int(4) NOT NULL,
85 `person_fio` varchar(150) NOT NULL,
86 `person_mobile` double NOT NULL,
87 PRIMARY KEY (`person_id`),
88 UNIQUE KEY `person_id_UNIQUE` (`person_id`),
89 UNIQUE KEY `person_mobile_UNIQUE` (`person_mobile`)
90) ENGINE=InnoDB DEFAULT CHARSET=latin1;
91/*!40101 SET character_set_client = @saved_cs_client */;
92
93--
94-- Dumping data for table `persons`
95--
96
97LOCK TABLES `persons` WRITE;
98/*!40000 ALTER TABLE `persons` DISABLE KEYS */;
99INSERT INTO `persons` VALUES (1,'Petrov A H',89278098789),(2,'Ivanov H H',83789876767),(3,'Nesterov G T',87376465473),(4,'Minin N H',89079875674);
100/*!40000 ALTER TABLE `persons` ENABLE KEYS */;
101UNLOCK TABLES;
102
103--
104-- Table structure for table `return_items`
105--
106
107DROP TABLE IF EXISTS `return_items`;
108/*!40101 SET @saved_cs_client = @@character_set_client */;
109/*!40101 SET character_set_client = utf8 */;
110CREATE TABLE `return_items` (
111 `item_id` int(4) NOT NULL,
112 `imei` double NOT NULL,
113 `return_date` date NOT NULL,
114 `ploblem` varchar(150) NOT NULL,
115 `person_id` int(4) NOT NULL,
116 PRIMARY KEY (`imei`),
117 UNIQUE KEY `imei_UNIQUE` (`imei`),
118 KEY `items_return_idx` (`item_id`),
119 KEY `person_return_idx` (`person_id`),
120 CONSTRAINT `items_return` FOREIGN KEY (`item_id`) REFERENCES `items` (`item_id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
121 CONSTRAINT `person_return` FOREIGN KEY (`person_id`) REFERENCES `persons` (`person_id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
122 CONSTRAINT `sale_return` FOREIGN KEY (`imei`) REFERENCES `sale` (`imei`) ON DELETE NO ACTION ON UPDATE NO ACTION
123) ENGINE=InnoDB DEFAULT CHARSET=latin1;
124/*!40101 SET character_set_client = @saved_cs_client */;
125
126--
127-- Dumping data for table `return_items`
128--
129
130LOCK TABLES `return_items` WRITE;
131/*!40000 ALTER TABLE `return_items` DISABLE KEYS */;
132INSERT INTO `return_items` VALUES (1,352024506065700,'2017-10-20','sensor',1),(1,352024506065701,'2017-10-17','display',1),(2,352024506065702,'2017-10-10','charger',2),(2,352024506065703,'2017-10-12','no service',3),(2,352024506065704,'2017-10-11','wi-fi',3);
133/*!40000 ALTER TABLE `return_items` ENABLE KEYS */;
134UNLOCK TABLES;
135
136--
137-- Table structure for table `sale`
138--
139
140DROP TABLE IF EXISTS `sale`;
141/*!40101 SET @saved_cs_client = @@character_set_client */;
142/*!40101 SET character_set_client = utf8 */;
143CREATE TABLE `sale` (
144 `item_id` int(4) NOT NULL,
145 `imei` double NOT NULL,
146 `sale_date` date NOT NULL,
147 `status` varchar(50) NOT NULL,
148 `item_cost` decimal(10,0) NOT NULL,
149 `item_sale` decimal(10,0) NOT NULL,
150 `profit` decimal(10,0) NOT NULL,
151 `person_id` int(4) NOT NULL,
152 PRIMARY KEY (`imei`),
153 UNIQUE KEY `imei_UNIQUE` (`imei`),
154 KEY `person_sale_idx` (`person_id`),
155 KEY `items_sale_idx` (`item_id`),
156 CONSTRAINT `items_sale` FOREIGN KEY (`item_id`) REFERENCES `items` (`item_id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
157 CONSTRAINT `person_sale` FOREIGN KEY (`person_id`) REFERENCES `persons` (`person_id`) ON DELETE NO ACTION ON UPDATE NO ACTION
158) ENGINE=InnoDB DEFAULT CHARSET=latin1;
159/*!40101 SET character_set_client = @saved_cs_client */;
160
161--
162-- Dumping data for table `sale`
163--
164
165LOCK TABLES `sale` WRITE;
166/*!40000 ALTER TABLE `sale` DISABLE KEYS */;
167INSERT INTO `sale` VALUES (1,352024506065700,'2017-10-10','return',3600,4300,700,1),(1,352024506065701,'2017-10-10','return',3600,4300,700,1),(2,352024506065702,'2017-10-10','return',5700,6500,800,2),(2,352024506065703,'2017-10-10','return',5700,6500,800,3),(2,352024506065704,'2017-10-10','return',5700,6500,800,3),(3,352024506065705,'2017-10-03','success',7800,9000,1200,3),(3,352024506065706,'2017-10-02','success',7800,9000,1200,4),(4,352024506065707,'2017-10-01','success',13200,14500,1300,4),(5,352024506065708,'2017-10-01','success',16000,19000,3000,4);
168/*!40000 ALTER TABLE `sale` ENABLE KEYS */;
169UNLOCK TABLES;
170/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
171
172/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
173/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
174/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
175/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
176/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
177/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
178/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
179
180-- Dump completed on 2017-11-26 19:45:32