eubBHQyC

1-- MySQL dump 10.13  Distrib 5.7.17, for Win64 (x86_64)
2--
3-- Host: localhost    Database: prodavnica
4-- ------------------------------------------------------
5-- Server version	5.7.23
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 `kupci`
20--
21
22DROP TABLE IF EXISTS `kupci`;
23/*!40101 SET @saved_cs_client     = @@character_set_client */;
24/*!40101 SET character_set_client = utf8 */;
25CREATE TABLE `kupci` (
26  `id` int(11) NOT NULL AUTO_INCREMENT,
27  `ime` varchar(100) NOT NULL,
28  `prezime` varchar(100) NOT NULL,
29  `datum_rodjenja` date NOT NULL,
30  `tip_clana` int(11) DEFAULT NULL,
31  PRIMARY KEY (`id`)
32) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;
33/*!40101 SET character_set_client = @saved_cs_client */;
34
35--
36-- Dumping data for table `kupci`
37--
38
39LOCK TABLES `kupci` WRITE;
40/*!40000 ALTER TABLE `kupci` DISABLE KEYS */;
41INSERT INTO `kupci` VALUES (1,'Marko','Borak','1994-01-25',NULL),(2,'Martina','Nikolić','1994-04-15',NULL),(3,'Dušan','Čoko','2018-12-07',NULL),(4,'Sanja','Golubović','1989-01-01',NULL);
42/*!40000 ALTER TABLE `kupci` ENABLE KEYS */;
43UNLOCK TABLES;
44
45--
46-- Table structure for table `proizvodi`
47--
48
49DROP TABLE IF EXISTS `proizvodi`;
50/*!40101 SET @saved_cs_client     = @@character_set_client */;
51/*!40101 SET character_set_client = utf8 */;
52CREATE TABLE `proizvodi` (
53  `id` int(11) NOT NULL AUTO_INCREMENT,
54  `naziv` varchar(300) NOT NULL,
55  `proizvodjac` varchar(300) DEFAULT NULL,
56  `cena` decimal(10,2) unsigned zerofill NOT NULL,
57  `stanje` int(10) unsigned zerofill NOT NULL,
58  PRIMARY KEY (`id`)
59) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;
60/*!40101 SET character_set_client = @saved_cs_client */;
61
62--
63-- Dumping data for table `proizvodi`
64--
65
66LOCK TABLES `proizvodi` WRITE;
67/*!40000 ALTER TABLE `proizvodi` DISABLE KEYS */;
68INSERT INTO `proizvodi` VALUES (1,'Mleko \"Moja Kravica\" 1L','Imlek',00000090.67,0000000200),(2,'Jogurt 2.8% 1L','Granice',00000112.00,0000000200),(3,'Edamer sir polumasni 250g','365 Days',00000212.45,0000000000),(4,'Mlevena plazma','Bambi',00000199.00,0000000100),(5,'Jogurt BALANS+ protein 750g','Imlek',00000094.99,0000000100),(6,'Jogurt DUKAT light 1,5%','Dukat',00000105.99,0000000200),(7,'MILFORD Peppermint 90g','Milford',00000270.99,0000000050);
69/*!40000 ALTER TABLE `proizvodi` ENABLE KEYS */;
70UNLOCK TABLES;
71
72--
73-- Table structure for table `racuni`
74--
75
76DROP TABLE IF EXISTS `racuni`;
77/*!40101 SET @saved_cs_client     = @@character_set_client */;
78/*!40101 SET character_set_client = utf8 */;
79CREATE TABLE `racuni` (
80  `id` int(11) NOT NULL AUTO_INCREMENT,
81  `adresa_slanja` text NOT NULL,
82  `datum_narudzbine` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
83  PRIMARY KEY (`id`)
84) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
85/*!40101 SET character_set_client = @saved_cs_client */;
86
87--
88-- Dumping data for table `racuni`
89--
90
91LOCK TABLES `racuni` WRITE;
92/*!40000 ALTER TABLE `racuni` DISABLE KEYS */;
93INSERT INTO `racuni` VALUES (1,'Cara Dušana 34','2018-12-07 09:47:40'),(2,'Zaplanjska 36','2018-12-07 09:47:40'),(3,'Bulevar Kralja Aleksandra 73','2018-12-07 09:47:40');
94/*!40000 ALTER TABLE `racuni` ENABLE KEYS */;
95UNLOCK TABLES;
96
97--
98-- Table structure for table `racuni_proizvodi`
99--
100
101DROP TABLE IF EXISTS `racuni_proizvodi`;
102/*!40101 SET @saved_cs_client     = @@character_set_client */;
103/*!40101 SET character_set_client = utf8 */;
104CREATE TABLE `racuni_proizvodi` (
105  `id` int(11) NOT NULL AUTO_INCREMENT,
106  `id_racun` int(11) NOT NULL,
107  `id_proizvod` int(11) NOT NULL,
108  PRIMARY KEY (`id`),
109  KEY `fk_proizvodi_idx` (`id_racun`),
110  KEY `fk_proizvodi_idx1` (`id_proizvod`)
111) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
112/*!40101 SET character_set_client = @saved_cs_client */;
113
114--
115-- Dumping data for table `racuni_proizvodi`
116--
117
118LOCK TABLES `racuni_proizvodi` WRITE;
119/*!40000 ALTER TABLE `racuni_proizvodi` DISABLE KEYS */;
120INSERT INTO `racuni_proizvodi` VALUES (1,1,1),(2,1,2),(3,1,3);
121/*!40000 ALTER TABLE `racuni_proizvodi` ENABLE KEYS */;
122UNLOCK TABLES;
123/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
124
125/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
126/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
127/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
128/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
129/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
130/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
131/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
132
133-- Dump completed on 2018-12-18  9:42:25