· 6 years ago · Dec 22, 2019, 04:36 PM
1-- MySQL dump 10.13 Distrib 5.7.23, for Linux (i686)
2--
3-- Host: localhost Database: m5107_sklep
4-- ------------------------------------------------------
5-- Server version 5.7.23-0ubuntu0.16.04.1
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 `bank`
20--
21
22DROP TABLE IF EXISTS `bank`;
23/*!40101 SET @saved_cs_client = @@character_set_client */;
24/*!40101 SET character_set_client = utf8 */;
25CREATE TABLE `bank` (
26 `id` int(11) NOT NULL AUTO_INCREMENT,
27 `code` varchar(16) NOT NULL,
28 `name` varchar(40) NOT NULL,
29 `balance` double NOT NULL DEFAULT '0',
30 PRIMARY KEY (`id`)
31) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
32/*!40101 SET character_set_client = @saved_cs_client */;
33
34--
35-- Dumping data for table `bank`
36--
37
38LOCK TABLES `bank` WRITE;
39/*!40000 ALTER TABLE `bank` DISABLE KEYS */;
40INSERT INTO `bank` VALUES (1,'754567865','Jakub Żuchowski',100);
41/*!40000 ALTER TABLE `bank` ENABLE KEYS */;
42UNLOCK TABLES;
43
44--
45-- Table structure for table `clients`
46--
47
48DROP TABLE IF EXISTS `clients`;
49/*!40101 SET @saved_cs_client = @@character_set_client */;
50/*!40101 SET character_set_client = utf8 */;
51CREATE TABLE `clients` (
52 `id` int(11) NOT NULL AUTO_INCREMENT,
53 `code` varchar(20) NOT NULL,
54 `name` varchar(40) NOT NULL,
55 PRIMARY KEY (`id`)
56) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
57/*!40101 SET character_set_client = @saved_cs_client */;
58
59--
60-- Dumping data for table `clients`
61--
62
63LOCK TABLES `clients` WRITE;
64/*!40000 ALTER TABLE `clients` DISABLE KEYS */;
65INSERT INTO `clients` VALUES (1,'405461300002582000','Joanna Żuchowska'),(2,'481043266781','Żas Pleuo');
66/*!40000 ALTER TABLE `clients` ENABLE KEYS */;
67UNLOCK TABLES;
68
69--
70-- Table structure for table `products`
71--
72
73DROP TABLE IF EXISTS `products`;
74/*!40101 SET @saved_cs_client = @@character_set_client */;
75/*!40101 SET character_set_client = utf8 */;
76CREATE TABLE `products` (
77 `id` int(11) NOT NULL AUTO_INCREMENT,
78 `code` varchar(13) NOT NULL,
79 `name` varchar(30) NOT NULL,
80 `price` double NOT NULL,
81 `sale` double NOT NULL DEFAULT '0',
82 PRIMARY KEY (`id`)
83) ENGINE=InnoDB AUTO_INCREMENT=38 DEFAULT CHARSET=utf8;
84/*!40101 SET character_set_client = @saved_cs_client */;
85
86--
87-- Dumping data for table `products`
88--
89
90LOCK TABLES `products` WRITE;
91/*!40000 ALTER TABLE `products` DISABLE KEYS */;
92INSERT INTO `products` VALUES (1,'5900541000062','Żywiec Zdrój 500ml',2.13,0),(2,'54491472','CocaCola 500ml',3.49,0),(3,'5903240969937','Vitamina D3',9.98,0),(4,'21500015','Cukierki',3,0),(5,'21500022','Książeczka',20,0),(6,'21500039','Torba',0.9,0),(7,'21500046','Koło ratunkowe ',15,0),(8,'21500053','Piłka ',10,0),(9,'5904517048058','Siatka na okno',10.47,0),(10,'5907069000369','Cukier puder ',2.06,0),(11,'5901887039693','Krem do rąk',8.9,0),(12,'5901887006145','Emulsja wodoodporna',17.6,0.2),(13,'9904831290054','Opryskiwacz ręczny ',9.63,0),(14,'6901443211050','Telefon',800,0),(15,'5051701074512','Kapsułki do zmywarki ',19.96,0),(16,'5907437610947','Klej',4.99,0),(17,'5907808888739','Korektor',3.88,0),(18,'5900263100194','Astra tusz kreślarski ',4.9,0),(19,'5905499717901','Hero ink ',3.8,0),(20,'5902557404889','Temperówka',4.9,0),(21,'889296160892','Tusz do drukarki ',35.5,0),(22,'59022091','Chusteczki rumiankowe',0.2,0),(23,'900246172274','Zakreślacz',1,0),(24,'5906858015096','Zszywki ',0.69,0),(25,'5036905022149','Karty Harry Potter',16.49,0),(26,'4035475063676','Kijek do zdjęć ',39.99,0),(27,'5030946112296','Sims 4',99,0),(28,'5035225060879','Sims 3',51.99,0),(29,'76145759','Toblerone',2.19,0),(30,'7610700946442','Ricola ',13.19,0),(31,'5903895010237','Filety z makreli',6.11,0),(32,'8904481006167','Grześki',1.25,0),(33,'42940487','Czekolada milka oreo',13.12,0),(34,'5903837445684','Marchew jadalna',1.65,0),(35,'5903837471621','Rzodkiewka',1.65,0),(36,'5903837468997','Rzeżucha ogrodowa',1.65,0),(37,'5904017072478','Blok techniczny',2.95,0);
93/*!40000 ALTER TABLE `products` ENABLE KEYS */;
94UNLOCK TABLES;
95
96--
97-- Table structure for table `sellers`
98--
99
100DROP TABLE IF EXISTS `sellers`;
101/*!40101 SET @saved_cs_client = @@character_set_client */;
102/*!40101 SET character_set_client = utf8 */;
103CREATE TABLE `sellers` (
104 `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
105 `name` varchar(40) NOT NULL,
106 `password` varchar(60) NOT NULL,
107 PRIMARY KEY (`id`)
108) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
109/*!40101 SET character_set_client = @saved_cs_client */;
110
111--
112-- Dumping data for table `sellers`
113--
114
115LOCK TABLES `sellers` WRITE;
116/*!40000 ALTER TABLE `sellers` DISABLE KEYS */;
117INSERT INTO `sellers` VALUES (1,'asia36','$2a$10$YAoBCA/B.SPa9V6ae9E61O3X80uJhW4qH71bjsNO.mGRFV0VFadDG'),(2,'kuzu13','$2a$10$uYwygIOS674mdjvEnPlqnuw2waG8vrsnq6Zfo35IOIGAVdLosnfVm');
118/*!40000 ALTER TABLE `sellers` ENABLE KEYS */;
119UNLOCK TABLES;
120
121--
122-- Table structure for table `summary`
123--
124
125DROP TABLE IF EXISTS `summary`;
126/*!40101 SET @saved_cs_client = @@character_set_client */;
127/*!40101 SET character_set_client = utf8 */;
128CREATE TABLE `summary` (
129 `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
130 `seller` int(11) NOT NULL,
131 `amount` double NOT NULL,
132 `time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
133 PRIMARY KEY (`id`)
134) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;
135/*!40101 SET character_set_client = @saved_cs_client */;
136
137--
138-- Dumping data for table `summary`
139--
140
141LOCK TABLES `summary` WRITE;
142/*!40000 ALTER TABLE `summary` DISABLE KEYS */;
143INSERT INTO `summary` VALUES (1,2,59,'2018-08-07 12:27:06'),(2,1,875,'2018-08-07 12:45:01'),(3,2,38.23,'2018-08-07 12:53:13'),(4,2,26.31,'2018-08-07 13:32:40'),(5,1,13.48,'2018-08-07 14:19:31');
144/*!40000 ALTER TABLE `summary` ENABLE KEYS */;
145UNLOCK TABLES;
146/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
147
148/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
149/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
150/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
151/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
152/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
153/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
154/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
155
156-- Dump completed on 2019-12-22 16:42:07