· 8 years ago · Jan 25, 2018, 12:30 PM
1-- MySQL dump 10.13 Distrib 5.7.20, for Linux (x86_64)
2--
3-- Host: 127.0.0.1 Database: prototype
4-- ------------------------------------------------------
5-- Server version 5.7.20
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 `CatalogProduct`
20--
21
22DROP TABLE IF EXISTS `CatalogProduct`;
23/*!40101 SET @saved_cs_client = @@character_set_client */;
24/*!40101 SET character_set_client = utf8 */;
25CREATE TABLE `CatalogProduct` (
26 `productID` int(11) NOT NULL,
27 `salesPrice` float DEFAULT NULL,
28 `Image` varchar(256) DEFAULT NULL,
29 `StoreID` int(11) NOT NULL,
30 PRIMARY KEY (`productID`,`StoreID`),
31 KEY `storeid_idx` (`StoreID`),
32 CONSTRAINT `pID` FOREIGN KEY (`productID`) REFERENCES `Product` (`ProductID`) ON DELETE CASCADE ON UPDATE CASCADE,
33 CONSTRAINT `storeid` FOREIGN KEY (`StoreID`) REFERENCES `Store` (`StoreID`) ON DELETE CASCADE ON UPDATE CASCADE
34) ENGINE=InnoDB DEFAULT CHARSET=latin1;
35/*!40101 SET character_set_client = @saved_cs_client */;
36
37--
38-- Dumping data for table `CatalogProduct`
39--
40
41
42LOCK TABLES `CatalogProduct` WRITE;
43/*!40000 ALTER TABLE `CatalogProduct` DISABLE KEYS */;
44INSERT INTO `CatalogProduct` VALUES (2,-1,NULL,2),(3,-1,NULL,1),(4,100,'panter.jpg',0),(5,-1,'buttercup.jpg',0),(6,-1,'Zer-li Class Diagram.jpg',0),(6,10,NULL,3);
45/*!40000 ALTER TABLE `CatalogProduct` ENABLE KEYS */;
46UNLOCK TABLES;
47
48--
49-- Table structure for table `ComplaintReport`
50--
51
52DROP TABLE IF EXISTS `ComplaintReport`;
53/*!40101 SET @saved_cs_client = @@character_set_client */;
54/*!40101 SET character_set_client = utf8 */;
55CREATE TABLE `ComplaintReport` (
56 `Quarterly` varchar(45) NOT NULL,
57 `Year` varchar(45) NOT NULL,
58 `StoreID` int(11) NOT NULL,
59 `FirstMonthHandledComplaintsAmount` int(11) DEFAULT NULL,
60 `FirstMonthPendingComplaintsAmount` int(11) DEFAULT NULL,
61 `SecondMonthHandledComplaintsAmount` int(11) DEFAULT NULL,
62 `SecondMonthPendingComplaintsAmount` int(11) DEFAULT NULL,
63 `ThirdMonthHandledComplaintsAmount` int(11) DEFAULT NULL,
64 `ThirdMonthPendingComplaintsAmount` int(11) DEFAULT NULL,
65 PRIMARY KEY (`Quarterly`,`Year`,`StoreID`),
66 KEY `fk_ComplaintReport_1_idx` (`StoreID`),
67 CONSTRAINT `fk_ComplaintReport_1` FOREIGN KEY (`StoreID`) REFERENCES `Store` (`StoreID`) ON DELETE CASCADE ON UPDATE CASCADE
68) ENGINE=InnoDB DEFAULT CHARSET=utf8;
69/*!40101 SET character_set_client = @saved_cs_client */;
70
71--
72-- Dumping data for table `ComplaintReport`
73--
74
75LOCK TABLES `ComplaintReport` WRITE;
76/*!40000 ALTER TABLE `ComplaintReport` DISABLE KEYS */;
77INSERT INTO `ComplaintReport` VALUES ('FIRST','2017',2,13,14,15,16,17,18);
78/*!40000 ALTER TABLE `ComplaintReport` ENABLE KEYS */;
79UNLOCK TABLES;
80
81--
82-- Table structure for table `CustomItem`
83--
84
85DROP TABLE IF EXISTS `CustomItem`;
86/*!40101 SET @saved_cs_client = @@character_set_client */;
87/*!40101 SET character_set_client = utf8 */;
88CREATE TABLE `CustomItem` (
89 `CustomItemID` int(11) NOT NULL AUTO_INCREMENT,
90 `CustomItemType` varchar(45) DEFAULT NULL,
91 `CustomItemPrice` float DEFAULT NULL,
92 `CustomItemColor` varchar(45) DEFAULT NULL,
93 `CustomItemGreetingCard` varchar(45) DEFAULT NULL,
94 `CustomItemOrderID` int(11) DEFAULT NULL,
95 PRIMARY KEY (`CustomItemID`),
96 KEY `fk_CustomItem_1_idx` (`CustomItemOrderID`),
97 CONSTRAINT `fk_CustomItem_1` FOREIGN KEY (`CustomItemOrderID`) REFERENCES `Order` (`OrderID`) ON DELETE CASCADE ON UPDATE CASCADE
98) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
99/*!40101 SET character_set_client = @saved_cs_client */;
100
101--
102-- Dumping data for table `CustomItem`
103--
104
105LOCK TABLES `CustomItem` WRITE;
106/*!40000 ALTER TABLE `CustomItem` DISABLE KEYS */;
107/*!40000 ALTER TABLE `CustomItem` ENABLE KEYS */;
108UNLOCK TABLES;
109
110--
111-- Table structure for table `CustomItemProduct`
112--
113
114DROP TABLE IF EXISTS `CustomItemProduct`;
115/*!40101 SET @saved_cs_client = @@character_set_client */;
116/*!40101 SET character_set_client = utf8 */;
117CREATE TABLE `CustomItemProduct` (
118 `CustomItemID` int(11) NOT NULL AUTO_INCREMENT,
119 `ProductID` int(11) NOT NULL,
120 `Amount` int(11) NOT NULL,
121 `Price` varchar(45) DEFAULT NULL,
122 PRIMARY KEY (`CustomItemID`,`ProductID`),
123 KEY `fk_CustomItemProduct_2_idx` (`CustomItemID`),
124 KEY `fk_CustomItemProduct_2_idx1` (`ProductID`),
125 CONSTRAINT `fk_CustomItemProduct_1` FOREIGN KEY (`CustomItemID`) REFERENCES `CustomItem` (`CustomItemID`) ON DELETE CASCADE ON UPDATE CASCADE,
126 CONSTRAINT `fk_CustomItemProduct_2` FOREIGN KEY (`ProductID`) REFERENCES `Product` (`ProductID`) ON DELETE CASCADE ON UPDATE CASCADE
127) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
128/*!40101 SET character_set_client = @saved_cs_client */;
129
130--
131-- Dumping data for table `CustomItemProduct`
132--
133
134LOCK TABLES `CustomItemProduct` WRITE;
135/*!40000 ALTER TABLE `CustomItemProduct` DISABLE KEYS */;
136/*!40000 ALTER TABLE `CustomItemProduct` ENABLE KEYS */;
137UNLOCK TABLES;
138
139--
140-- Table structure for table `Customers`
141--
142
143DROP TABLE IF EXISTS `Customers`;
144/*!40101 SET @saved_cs_client = @@character_set_client */;
145/*!40101 SET character_set_client = utf8 */;
146CREATE TABLE `Customers` (
147 `personID` int(11) NOT NULL,
148 `fullName` varchar(45) DEFAULT NULL,
149 `phoneNumber` varchar(45) DEFAULT NULL,
150 `payMethod` varchar(45) DEFAULT NULL,
151 `accountBalance` float DEFAULT NULL,
152 `creditCardNumber` varchar(45) DEFAULT NULL,
153 `AccountStatus` tinyint(4) DEFAULT NULL,
154 `StoreID` int(11) NOT NULL,
155 `ExpirationDate` varchar(45) DEFAULT NULL,
156 PRIMARY KEY (`personID`,`StoreID`),
157 KEY `fk_Customers_1_idx` (`StoreID`),
158 CONSTRAINT `fk_Customers_1` FOREIGN KEY (`StoreID`) REFERENCES `Store` (`StoreID`) ON DELETE CASCADE ON UPDATE CASCADE
159) ENGINE=InnoDB DEFAULT CHARSET=latin1;
160/*!40101 SET character_set_client = @saved_cs_client */;
161
162--
163-- Dumping data for table `Customers`
164--
165
166LOCK TABLES `Customers` WRITE;
167/*!40000 ALTER TABLE `Customers` DISABLE KEYS */;
168INSERT INTO `Customers` VALUES (1234,'mk','546','YEARLY_SUBSCRIPTION',3112,'1111-2222-3333-4444',1,1,'23-01-2018'),(1234,'mk','452','MONTHLY_SUBSCRIPTION',100.35,'3423',1,2,'30-01-2018'),(12345,'Dzon Levi','101','CREDIT_CARD',0,'4356768',NULL,1,NULL),(2344354,'Mark Twain','3435678','YEARLY_SUBSCRIPTION',0,'5454645757',1,2,'24-01-2019'),(305022949,'matan k','0507788765','CREDIT_CARD',194,'1111-2222-3333-4444',1,1,''),(305022949,'Matan Keren','3523523','MONTHLY_SUBSCRIPTION',0,'2314123',1,2,'24-02-2018'),(305022949,'matan k','0507788765','CREDIT_CARD',0,'1111-2222-3333-4444',0,3,NULL);
169/*!40000 ALTER TABLE `Customers` ENABLE KEYS */;
170UNLOCK TABLES;
171
172--
173-- Table structure for table `Order`
174--
175
176DROP TABLE IF EXISTS `Order`;
177/*!40101 SET @saved_cs_client = @@character_set_client */;
178/*!40101 SET character_set_client = utf8 */;
179CREATE TABLE `Order` (
180 `OrderID` int(11) NOT NULL AUTO_INCREMENT,
181 `OrderStatus` varchar(45) DEFAULT NULL,
182 `OrderPrice` float DEFAULT NULL,
183 `OrderCreationDateTime` varchar(45) DEFAULT NULL,
184 `OrderRequiredDate` varchar(45) DEFAULT NULL,
185 `OrderRequiredTime` varchar(45) DEFAULT NULL,
186 `OrderShipmentAddress` varchar(45) DEFAULT NULL,
187 `OrderReceiverName` varchar(45) DEFAULT NULL,
188 `OrderReceiverPhoneNumber` varchar(45) DEFAULT NULL,
189 `OrderPaymentMethod` varchar(45) DEFAULT NULL,
190 `OrderOriginStore` int(11) DEFAULT NULL,
191 `OrderCustomerID` int(11) DEFAULT NULL,
192 `OrderRefund` float DEFAULT NULL,
193 PRIMARY KEY (`OrderID`),
194 KEY `fk_Order_1_idx` (`OrderCustomerID`),
195 CONSTRAINT `fk_Order_1` FOREIGN KEY (`OrderCustomerID`) REFERENCES `Customers` (`personID`) ON DELETE CASCADE ON UPDATE CASCADE
196) ENGINE=InnoDB AUTO_INCREMENT=108 DEFAULT CHARSET=latin1;
197/*!40101 SET character_set_client = @saved_cs_client */;
198
199--
200-- Dumping data for table `Order`
201--
202
203LOCK TABLES `Order` WRITE;
204/*!40000 ALTER TABLE `Order` DISABLE KEYS */;
205INSERT INTO `Order` VALUES (77,'NEW',90,'2018-01-22 09:03:54','2018-01-22 12:03:54','',NULL,NULL,NULL,'SUBSCRIPTION',2,12345,0),(78,'NEW',82.5,'2018-01-22 09:04:06','2018-01-22 12:04:06','',NULL,NULL,NULL,'SUBSCRIPTION',3,12345,0),(79,'NEW',174.6,'2018-01-22 09:45:58','2018-01-22 12:45:58','',NULL,NULL,NULL,'SUBSCRIPTION',2,12345,0),(80,'NEW',183.6,'2018-01-22 12:16:44','2018-01-23 03:16:00','','','','','SUBSCRIPTION',2,12345,0),(81,'NEW',151,'2018-01-22 20:47:50','2018-01-23 11:47:00','',NULL,NULL,NULL,'CREDITCARD',3,12345,0),(82,'NEW',174.6,'2018-01-22 21:52:24','2018-01-23 12:51:00','',NULL,NULL,NULL,'SUBSCRIPTION',2,12345,0),(83,'NEW',233,'2018-01-24 10:43:58','2018-01-24 13:43:58','','werwe','345345','455464','CREDITCARD',1,12345,0),(88,'CANCELED',327,'2018-01-24 13:07:38','2018-01-25 04:07:00','','asfa','sdfsdf','232342','CREDITCARD',1,1234,0),(94,'NEW',223,'2018-01-24 14:56:12','2018-01-24 17:56:12','',NULL,NULL,NULL,'CREDITCARD',1,305022949,0),(95,'NEW',294.3,'2018-01-24 14:56:30','2018-01-24 17:56:30','','2342','42342','42342','SUBSCRIPTION',2,305022949,0),(96,'NEW',217,'2018-01-24 14:56:51','2018-01-24 17:56:51','',NULL,NULL,NULL,'CREDITCARD',1,305022949,0),(97,'NEW',223,'2018-01-24 14:57:02','2018-01-24 20:50:00','',NULL,NULL,NULL,'CREDITCARD',1,305022949,0),(98,'NEW',223,'2018-01-24 14:58:08','2018-01-26 17:58:00','',NULL,NULL,NULL,'CREDITCARD',1,305022949,0),(99,'NEW',94,'2018-01-24 14:58:36','2018-01-30 17:58:00','',NULL,NULL,NULL,'CREDITCARD',1,305022949,0),(100,'NEW',217,'2018-01-24 14:59:36','2018-01-24 17:59:36','',NULL,NULL,NULL,'CREDITCARD',1,305022949,0),(101,'NEW',123,'2018-01-24 15:46:51','2018-01-31 12:12:00','',NULL,NULL,NULL,'CREDITCARD',1,305022949,0),(102,'NEW',123,'2018-01-24 15:52:53','2018-02-10 12:12:00','',NULL,NULL,NULL,'CREDITCARD',1,305022949,0),(103,'NEW',123,'2018-01-24 15:53:59','2018-02-09 12:12:00','',NULL,NULL,NULL,'CREDITCARD',1,305022949,0),(104,'NEW',123,'2018-01-24 15:56:38','2018-02-01 12:12:00','',NULL,NULL,NULL,'CREDITCARD',1,305022949,0),(105,'NEW',123,'2018-01-24 15:56:52','2018-02-15 12:12:00','',NULL,NULL,NULL,'CREDITCARD',1,305022949,0),(106,'CANCELED',100,'2018-01-24 18:23:53','2018-01-24 21:23:53','',NULL,NULL,NULL,'CREDITCARD',1,1234,0),(107,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0);
206/*!40000 ALTER TABLE `Order` ENABLE KEYS */;
207UNLOCK TABLES;
208
209--
210-- Table structure for table `Product`
211--
212
213DROP TABLE IF EXISTS `Product`;
214/*!40101 SET @saved_cs_client = @@character_set_client */;
215/*!40101 SET character_set_client = utf8 */;
216CREATE TABLE `Product` (
217 `ProductID` int(11) NOT NULL,
218 `ProductName` varchar(45) DEFAULT NULL,
219 `ProductType` varchar(45) DEFAULT NULL,
220 `ProductPrice` float DEFAULT NULL,
221 `ProductAmount` int(11) DEFAULT NULL,
222 `ProductColor` varchar(45) DEFAULT NULL,
223 PRIMARY KEY (`ProductID`)
224) ENGINE=InnoDB DEFAULT CHARSET=latin1;
225/*!40101 SET character_set_client = @saved_cs_client */;
226
227--
228-- Dumping data for table `Product`
229--
230
231LOCK TABLES `Product` WRITE;
232/*!40000 ALTER TABLE `Product` DISABLE KEYS */;
233INSERT INTO `Product` VALUES (1,'roses bouquet','Red',90,15,'Red'),(2,'Chrysanthemums bouquet','bouquet',20,20,'White'),(3,'Avalanche bouquet','bouquet',15,10,'Purple'),(4,'Panter bouquet','bouquet',151,5,'Pink'),(5,'Buttercup bouquet','bouquet',94,10,'Red'),(6,'Anemone bouquet','bouquet',123,15,'Red'),(7,'Chrysanthemums','FLOWER',9,30,'White'),(8,'Limonium','FLOWER',10,30,'Purple'),(9,'Sunflower','FLOWER',11,30,'Yellow'),(10,'roses','FLOWER',12,40,'Red');
234/*!40000 ALTER TABLE `Product` ENABLE KEYS */;
235UNLOCK TABLES;
236
237--
238-- Table structure for table `ProductInOrder`
239--
240
241DROP TABLE IF EXISTS `ProductInOrder`;
242/*!40101 SET @saved_cs_client = @@character_set_client */;
243/*!40101 SET character_set_client = utf8 */;
244CREATE TABLE `ProductInOrder` (
245 `ProductID` int(11) NOT NULL,
246 `OrderID` int(11) NOT NULL,
247 `ProductGrettingCard` varchar(45) DEFAULT NULL,
248 PRIMARY KEY (`ProductID`,`OrderID`),
249 KEY `fk_ProductInOrder_2_idx` (`OrderID`),
250 CONSTRAINT `fk_ProductInOrder_1` FOREIGN KEY (`ProductID`) REFERENCES `Product` (`ProductID`) ON DELETE CASCADE ON UPDATE CASCADE,
251 CONSTRAINT `fk_ProductInOrder_2` FOREIGN KEY (`OrderID`) REFERENCES `Order` (`OrderID`) ON DELETE CASCADE ON UPDATE CASCADE
252) ENGINE=InnoDB DEFAULT CHARSET=latin1;
253/*!40101 SET character_set_client = @saved_cs_client */;
254
255--
256-- Dumping data for table `ProductInOrder`
257--
258
259LOCK TABLES `ProductInOrder` WRITE;
260/*!40000 ALTER TABLE `ProductInOrder` DISABLE KEYS */;
261INSERT INTO `ProductInOrder` VALUES (4,77,''),(4,78,''),(4,79,''),(4,80,''),(4,81,'fgjgfj'),(4,82,''),(4,83,''),(4,88,''),(4,94,''),(4,95,''),(4,97,''),(4,98,''),(4,106,''),(5,79,''),(5,80,''),(5,82,''),(5,88,''),(5,95,''),(5,96,''),(5,99,''),(5,100,''),(6,78,''),(6,83,''),(6,88,''),(6,94,''),(6,95,''),(6,96,''),(6,97,''),(6,98,''),(6,100,''),(6,101,''),(6,102,''),(6,103,''),(6,104,''),(6,105,'');
262/*!40000 ALTER TABLE `ProductInOrder` ENABLE KEYS */;
263UNLOCK TABLES;
264
265--
266-- Table structure for table `Store`
267--
268
269DROP TABLE IF EXISTS `Store`;
270/*!40101 SET @saved_cs_client = @@character_set_client */;
271/*!40101 SET character_set_client = utf8 */;
272CREATE TABLE `Store` (
273 `StoreID` int(11) NOT NULL,
274 `StoreAddress` varchar(45) DEFAULT NULL,
275 PRIMARY KEY (`StoreID`)
276) ENGINE=InnoDB DEFAULT CHARSET=latin1;
277/*!40101 SET character_set_client = @saved_cs_client */;
278
279--
280-- Dumping data for table `Store`
281--
282
283LOCK TABLES `Store` WRITE;
284/*!40000 ALTER TABLE `Store` DISABLE KEYS */;
285INSERT INTO `Store` VALUES (0,'Base'),(1,'Haifa'),(2,'Karmiel'),(3,'Qiryat Biyalik');
286/*!40000 ALTER TABLE `Store` ENABLE KEYS */;
287UNLOCK TABLES;
288
289--
290-- Table structure for table `User`
291--
292
293DROP TABLE IF EXISTS `User`;
294/*!40101 SET @saved_cs_client = @@character_set_client */;
295/*!40101 SET character_set_client = utf8 */;
296CREATE TABLE `User` (
297 `UserName` varchar(45) NOT NULL,
298 `UserPassword` varchar(45) DEFAULT NULL,
299 `UserPermission` varchar(45) DEFAULT NULL,
300 `personID` int(11) DEFAULT NULL,
301 `UserStatus` varchar(45) DEFAULT NULL,
302 `unsuccessfulTries` int(11) DEFAULT NULL,
303 PRIMARY KEY (`UserName`)
304) ENGINE=InnoDB DEFAULT CHARSET=latin1;
305/*!40101 SET character_set_client = @saved_cs_client */;
306
307--
308-- Dumping data for table `User`
309--
310
311LOCK TABLES `User` WRITE;
312/*!40000 ALTER TABLE `User` DISABLE KEYS */;
313INSERT INTO `User` VALUES ('admin','123456','SYSTEM_MANAGER',0,'REGULAR',0),('deckard','123456','STORE_MANAGER',55,'REGULAR',0),('jenia','123456','CUSTOMER_SERVICE_EXPERT',1111,'REGULAR',0),('matan','qwerty','STORE_WORKER',1,'REGULAR',0),('matan2','123456','CUSTOMER',305022949,'REGULAR',0),('matan3','123456','CUSTOMER',1234,'REGULAR',0),('matan4','123456','NETWORK_WORKER',2,'REGULAR',0),('service','123456','CUSTOMER_SERVICE',12546,'REGULAR',0),('serviceWorker','123456','CUSTOMER_SERVICE_WORKER',12546,'REGULAR',0);
314/*!40000 ALTER TABLE `User` ENABLE KEYS */;
315UNLOCK TABLES;
316
317--
318-- Table structure for table `customersatisfactionsurveyresults`
319--
320
321DROP TABLE IF EXISTS `customersatisfactionsurveyresults`;
322/*!40101 SET @saved_cs_client = @@character_set_client */;
323/*!40101 SET character_set_client = utf8 */;
324CREATE TABLE `customersatisfactionsurveyresults` (
325 `id` int(11) NOT NULL AUTO_INCREMENT,
326 `date` date DEFAULT NULL,
327 `answer1` int(2) DEFAULT NULL,
328 `answer2` int(2) DEFAULT NULL,
329 `answer3` int(2) DEFAULT NULL,
330 `answer4` int(2) DEFAULT NULL,
331 `answer5` int(2) DEFAULT NULL,
332 `answer6` int(2) DEFAULT NULL,
333 `storeID` int(11) DEFAULT NULL,
334 `analysis` varchar(500) DEFAULT '',
335 PRIMARY KEY (`id`),
336 KEY `fk_customersatisfactionsurveyresults_1_idx` (`storeID`),
337 CONSTRAINT `fk_customersatisfactionsurveyresults_1` FOREIGN KEY (`storeID`) REFERENCES `store` (`StoreID`) ON DELETE CASCADE ON UPDATE CASCADE
338) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;
339/*!40101 SET character_set_client = @saved_cs_client */;
340
341--
342-- Dumping data for table `customersatisfactionsurveyresults`
343--
344
345LOCK TABLES `customersatisfactionsurveyresults` WRITE;
346/*!40000 ALTER TABLE `customersatisfactionsurveyresults` DISABLE KEYS */;
347INSERT INTO `customersatisfactionsurveyresults` VALUES (1,'2018-01-03',2,2,2,2,2,2,1,'Sample Survey Analysis'),(2,'2018-01-03',5,5,5,5,5,5,1,''),(3,'2018-01-03',5,5,5,5,5,5,1,''),(4,'2018-01-14',5,6,9,8,7,4,1,''),(6,'2018-01-15',9,9,9,9,9,9,1,'');
348/*!40000 ALTER TABLE `customersatisfactionsurveyresults` ENABLE KEYS */;
349UNLOCK TABLES;
350
351--
352-- Table structure for table `incomereport`
353--
354
355DROP TABLE IF EXISTS `incomereport`;
356/*!40101 SET @saved_cs_client = @@character_set_client */;
357/*!40101 SET character_set_client = utf8 */;
358CREATE TABLE `incomereport` (
359 `Quarterly` varchar(45) NOT NULL,
360 `Year` varchar(45) NOT NULL,
361 `StoreID` int(11) NOT NULL,
362 `IncomeAmount` float DEFAULT NULL,
363 PRIMARY KEY (`Quarterly`,`Year`,`StoreID`),
364 KEY `fk_IncomeReport_1_idx` (`StoreID`),
365 CONSTRAINT `fk_IncomeReport_1` FOREIGN KEY (`StoreID`) REFERENCES `store` (`StoreID`) ON DELETE CASCADE ON UPDATE CASCADE
366) ENGINE=InnoDB DEFAULT CHARSET=latin1;
367/*!40101 SET character_set_client = @saved_cs_client */;
368
369--
370-- Dumping data for table `incomereport`
371--
372
373LOCK TABLES `incomereport` WRITE;
374/*!40000 ALTER TABLE `incomereport` DISABLE KEYS */;
375INSERT INTO `incomereport` VALUES ('SECOND','2017',2,1290);
376/*!40000 ALTER TABLE `incomereport` ENABLE KEYS */;
377UNLOCK TABLES;
378
379--
380-- Table structure for table `ordercomplaint`
381--
382
383DROP TABLE IF EXISTS `ordercomplaint`;
384/*!40101 SET @saved_cs_client = @@character_set_client */;
385/*!40101 SET character_set_client = utf8 */;
386CREATE TABLE `ordercomplaint` (
387 `id` int(11) NOT NULL AUTO_INCREMENT,
388 `customerID` int(11) DEFAULT NULL,
389 `customerName` varchar(100) DEFAULT NULL,
390 `customerPhoneNumber` varchar(100) DEFAULT NULL,
391 `storeID` int(11) DEFAULT NULL,
392 `complaintDescription` varchar(500) DEFAULT NULL,
393 `date` date DEFAULT NULL,
394 `time` varchar(45) DEFAULT NULL,
395 `givenCompensationAmount` float DEFAULT NULL,
396 `maxCompensationAmount` float DEFAULT NULL,
397 `status` varchar(45) DEFAULT NULL,
398 PRIMARY KEY (`id`)
399) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;
400/*!40101 SET character_set_client = @saved_cs_client */;
401
402--
403-- Dumping data for table `ordercomplaint`
404--
405
406LOCK TABLES `ordercomplaint` WRITE;
407/*!40000 ALTER TABLE `ordercomplaint` DISABLE KEYS */;
408INSERT INTO `ordercomplaint` VALUES (1,305022949,'matan k','0507788765',1,'asdsadasdas','2018-01-18','14:19',0,100,'CLOSED'),(2,305022949,'Son Goku','0507788765',1,'asdsadasdas','2018-01-18','14:19',NULL,10.2,'NEW'),(3,305022949,'Ali baba','0507788765',1,'asdsadasdas','2018-01-18','14:19',0,519.3,'NEW'),(5,305022949,'matan k','0507788765',1,'new complaint.','2018-01-19','18:36',NULL,198,'NEW'),(6,305022949,'matan k','0507788765',1,'New complaint, store 1','2018-01-19','18:49',NULL,100,'NEW'),(7,305022949,'matan k','0507788765',1,'complaint!!!!!','2018-01-19','19:17',NULL,233,'NEW');
409/*!40000 ALTER TABLE `ordercomplaint` ENABLE KEYS */;
410UNLOCK TABLES;
411
412--
413-- Table structure for table `orderreport`
414--
415
416DROP TABLE IF EXISTS `orderreport`;
417/*!40101 SET @saved_cs_client = @@character_set_client */;
418/*!40101 SET character_set_client = utf8 */;
419CREATE TABLE `orderreport` (
420 `Quarterly` varchar(45) NOT NULL,
421 `Year` varchar(45) NOT NULL,
422 `StoreID` int(11) NOT NULL,
423 `TotalOrdersAmount` int(11) DEFAULT NULL,
424 `BouquetAmount` int(11) DEFAULT NULL,
425 `BrideBouquetAmount` int(11) DEFAULT NULL,
426 `FlowerPotAmount` int(11) DEFAULT NULL,
427 `FlowerAmount` int(11) DEFAULT NULL,
428 `PlantAmount` int(11) DEFAULT NULL,
429 PRIMARY KEY (`Quarterly`,`Year`,`StoreID`),
430 KEY `OrderReport_idx` (`StoreID`),
431 CONSTRAINT `fk_OrderReport_1` FOREIGN KEY (`StoreID`) REFERENCES `store` (`StoreID`) ON DELETE CASCADE ON UPDATE CASCADE
432) ENGINE=InnoDB DEFAULT CHARSET=latin1;
433/*!40101 SET character_set_client = @saved_cs_client */;
434
435--
436-- Dumping data for table `orderreport`
437--
438
439LOCK TABLES `orderreport` WRITE;
440/*!40000 ALTER TABLE `orderreport` DISABLE KEYS */;
441INSERT INTO `orderreport` VALUES ('THIRD','2017',2,265,51,52,53,54,55);
442/*!40000 ALTER TABLE `orderreport` ENABLE KEYS */;
443UNLOCK TABLES;
444
445--
446-- Table structure for table `storeEmployees`
447--
448
449DROP TABLE IF EXISTS `storeEmployees`;
450/*!40101 SET @saved_cs_client = @@character_set_client */;
451/*!40101 SET character_set_client = utf8 */;
452CREATE TABLE `storeEmployees` (
453 `username` varchar(45) NOT NULL,
454 `storeID` int(11) DEFAULT NULL,
455 `type` varchar(45) DEFAULT NULL,
456 PRIMARY KEY (`username`)
457) ENGINE=InnoDB DEFAULT CHARSET=latin1;
458/*!40101 SET character_set_client = @saved_cs_client */;
459
460--
461-- Dumping data for table `storeEmployees`
462--
463
464LOCK TABLES `storeEmployees` WRITE;
465/*!40000 ALTER TABLE `storeEmployees` DISABLE KEYS */;
466INSERT INTO `storeEmployees` VALUES ('deckard',2,'STORE_MANAGER'),('matan',1,'STORE_WORKER');
467/*!40000 ALTER TABLE `storeEmployees` ENABLE KEYS */;
468UNLOCK TABLES;
469
470--
471-- Table structure for table `surveyreport`
472--
473
474DROP TABLE IF EXISTS `surveyreport`;
475/*!40101 SET @saved_cs_client = @@character_set_client */;
476/*!40101 SET character_set_client = utf8 */;
477CREATE TABLE `surveyreport` (
478 `Quarterly` varchar(45) NOT NULL,
479 `Year` varchar(45) NOT NULL,
480 `StoreID` int(11) NOT NULL,
481 `FirstSurveyAverageResult` int(11) DEFAULT NULL,
482 `SecondSurveyAverageResult` int(11) DEFAULT NULL,
483 `ThirdSurveyAverageResult` int(11) DEFAULT NULL,
484 `FourthSurveyAverageResult` int(11) DEFAULT NULL,
485 `FifthSurveyAverageResult` int(11) DEFAULT NULL,
486 `SixthSurveyAverageResult` int(11) DEFAULT NULL,
487 PRIMARY KEY (`Quarterly`,`Year`,`StoreID`),
488 KEY `fk_SurveyReport_1_idx` (`StoreID`),
489 CONSTRAINT `fk_SurveyReport_1` FOREIGN KEY (`StoreID`) REFERENCES `store` (`StoreID`) ON DELETE CASCADE ON UPDATE CASCADE
490) ENGINE=InnoDB DEFAULT CHARSET=latin1;
491/*!40101 SET character_set_client = @saved_cs_client */;
492
493--
494-- Dumping data for table `surveyreport`
495--
496
497LOCK TABLES `surveyreport` WRITE;
498/*!40000 ALTER TABLE `surveyreport` DISABLE KEYS */;
499INSERT INTO `surveyreport` VALUES ('FOURTH','2018',1,1,3,5,7,9,4);
500/*!40000 ALTER TABLE `surveyreport` ENABLE KEYS */;
501UNLOCK TABLES;
502
503--
504-- Table structure for table `surveys`
505--
506
507DROP TABLE IF EXISTS `surveys`;
508/*!40101 SET @saved_cs_client = @@character_set_client */;
509/*!40101 SET character_set_client = utf8 */;
510CREATE TABLE `surveys` (
511 `surveyName` varchar(200) NOT NULL,
512 `question1` varchar(200) DEFAULT NULL,
513 `question2` varchar(200) DEFAULT NULL,
514 `question3` varchar(200) DEFAULT NULL,
515 `question4` varchar(200) DEFAULT NULL,
516 `question5` varchar(200) DEFAULT NULL,
517 `question6` varchar(200) DEFAULT NULL,
518 `analysis` varchar(500) DEFAULT NULL,
519 PRIMARY KEY (`surveyName`)
520) ENGINE=InnoDB DEFAULT CHARSET=utf8;
521/*!40101 SET character_set_client = @saved_cs_client */;
522
523--
524-- Dumping data for table `surveys`
525--
526
527LOCK TABLES `surveys` WRITE;
528/*!40000 ALTER TABLE `surveys` DISABLE KEYS */;
529INSERT INTO `surveys` VALUES ('12','1','1','1','1','1','1','1'),('123','Question','Question','Question','Question','Question','Question','Bla bla'),('12355','1','1','1','1','1','1',NULL),('new survey','1','1','1','1','1','1',NULL);
530/*!40000 ALTER TABLE `surveys` ENABLE KEYS */;
531UNLOCK TABLES;
532/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
533
534/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
535/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
536/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
537/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
538/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
539/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
540/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
541
542-- Dump completed on 2018-01-24 19:14:28