b4uAzReD

1-- phpMyAdmin SQL Dump
2-- version 4.0.4
3-- http://www.phpmyadmin.net
4--
5-- Host: localhost
6-- Generation Time: Feb 20, 2016 at 01:40 PM
7-- Server version: 5.6.12-log
8-- PHP Version: 5.4.12
9
10SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11SET time_zone = "+00:00";
12
13
14/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
15/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
16/*!40101 SET NAMES utf8 */;
17
18--
19-- Database: `poslasticarnice`
20--
21CREATE DATABASE IF NOT EXISTS `poslasticarnice2` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
22USE `poslasticarnice2`;
23
24-- --------------------------------------------------------
25
26--
27-- Table structure for table `poslasticarnice`
28--
29
30CREATE TABLE IF NOT EXISTS `poslasticarnice` (
31  `idPoslasticarnice` int(11) NOT NULL AUTO_INCREMENT,
32  `naziv` varchar(255) NOT NULL,
33  `telefon` varchar(255) NOT NULL,
34  `lokacija` int(11) NOT NULL,
35  `vrsta` int(11) NOT NULL,
36  PRIMARY KEY (`idPoslasticarnice`)
37) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=14 ;
38
39--
40-- Dumping data for table `poslasticarnice`
41--
42
43INSERT INTO `poslasticarnice` (`idPoslasticarnice`, `naziv`, `telefon`, `lokacija`, `vrsta`) VALUES
44(1, 'Gelato', '+381635652', 3, 5),
45(2, 'Gelato2', '+38128627', 3, 5),
46(3, 'Gelato3', '+3874823', 3, 5),
47(4, 'Fabrika ukusa', '+381666383', 1, 4),
48(5, 'Mala fabrika ukusa', '+38166252', 1, 4),
49(6, 'Marimari', '+3816534085', 1, 4),
50(7, 'Blok', '+38199373', 4, 3),
51(8, 'Sladokusci', '+381627673', 4, 2),
52(9, 'Dvanestorica', '+38166353', 4, 3),
53(10, 'Najbolje od nas', '+381762762', 2, 3),
54(11, 'San', '+381787634', 2, 2),
55(12, 'Miris slada', '+38177673253', 5, 1),
56(13, 'Mrvica', '381627626', 5, 1),
57(14, 'Hlad', '+381676234', 6, 2),
58(15, 'Beverli', '+381876237', 6, 2);
59
60-- --------------------------------------------------------
61
62--
63-- Table structure for table `lokacija`
64--
65
66CREATE TABLE IF NOT EXISTS `lokacija` (
67  `idLokacija` int(11) NOT NULL AUTO_INCREMENT,
68  `lokacija` varchar(255) NOT NULL,
69  PRIMARY KEY (`idLokacija`)
70) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;
71
72--
73-- Dumping data for table `lokacija`
74--
75
76INSERT INTO `lokacija` (`idLokacija`, `lokacija`) VALUES
77(1, 'Stari Grad'),
78(2, 'Novi Beograd'),
79(3, 'Dedinje'),
80(4, 'Senjak'),
81(5, 'Banovo Brdo'),
82(6, 'Zemun');
83
84-- --------------------------------------------------------
85
86--
87-- Table structure for table `vrsta`
88--
89
90CREATE TABLE IF NOT EXISTS `vrsta` (
91  `idVrsta` int(11) NOT NULL AUTO_INCREMENT,
92  `vrsta` varchar(255) NOT NULL,
93  PRIMARY KEY (`idVrsta`),
94  KEY `idVrsta` (`idVrsta`)
95) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;
96
97--
98-- Dumping data for table `vrsta`
99--
100
101INSERT INTO `vrsta` (`idVrsta`, `vrsta`) VALUES
102(1, 'Vulkan-topli'),
103(2, 'Sitni'),
104(3, 'Sladoledi'),
105(4, 'Domaći'),
106(5, 'Pravi srpski');
107
108/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
109/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;