· 9 years ago · Sep 28, 2016, 07:50 PM
1-- phpMyAdmin SQL Dump
2-- version 4.1.14
3-- http://www.phpmyadmin.net
4--
5-- Host: 127.0.0.1
6-- Generation Time: Sep 28, 2016 at 09:49 PM
7-- Server version: 5.6.17
8-- PHP Version: 5.5.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 @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
17/*!40101 SET NAMES utf8 */;
18
19--
20-- Database: `prehrana`
21--
22
23-- --------------------------------------------------------
24
25--
26-- Table structure for table `akcija`
27--
28
29CREATE TABLE IF NOT EXISTS `akcija` (
30 `id` int(11) NOT NULL AUTO_INCREMENT,
31 `kupon` text COLLATE utf8_slovenian_ci,
32 `procent` double DEFAULT '-1',
33 `cena` double DEFAULT '-1',
34 `fk_lokal_id` bigint(20) NOT NULL,
35 `aktivno` tinyint(1) NOT NULL DEFAULT '1',
36 `spletno` tinyint(1) NOT NULL DEFAULT '0',
37 `datum_vnosa` datetime NOT NULL,
38 `naziv` text COLLATE utf8_slovenian_ci NOT NULL,
39 PRIMARY KEY (`id`),
40 KEY `fk_lokal_id` (`fk_lokal_id`)
41) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_slovenian_ci AUTO_INCREMENT=3 ;
42
43--
44-- Dumping data for table `akcija`
45--
46
47INSERT INTO `akcija` (`id`, `kupon`, `procent`, `cena`, `fk_lokal_id`, `aktivno`, `spletno`, `datum_vnosa`, `naziv`) VALUES
48(1, '', 12, -1, 21061265696, 1, 1, '2016-09-26 17:55:00', '123'),
49(2, 'qwe', -1, 24, 21061265696, 0, 0, '2016-09-26 17:56:00', 'cena');
50
51-- --------------------------------------------------------
52
53--
54-- Table structure for table `feedback`
55--
56
57CREATE TABLE IF NOT EXISTS `feedback` (
58 `id` int(11) NOT NULL AUTO_INCREMENT,
59 `text` text CHARACTER SET latin1 NOT NULL,
60 `fk_uporabnik_id` bigint(20) DEFAULT NULL,
61 `fk_lokal_id` bigint(20) DEFAULT NULL,
62 `datum` datetime NOT NULL,
63 PRIMARY KEY (`id`),
64 KEY `fk_uporabnik_id` (`fk_uporabnik_id`),
65 KEY `fk_lokal_id` (`fk_lokal_id`)
66) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_slovenian_ci AUTO_INCREMENT=26 ;
67
68--
69-- Dumping data for table `feedback`
70--
71
72INSERT INTO `feedback` (`id`, `text`, `fk_uporabnik_id`, `fk_lokal_id`, `datum`) VALUES
73(1, 'ertert', NULL, NULL, '2016-09-20 16:32:00'),
74(2, 'ertert', NULL, NULL, '2016-09-20 16:32:00'),
75(3, 'ertert', NULL, NULL, '2016-09-20 16:32:00'),
76(4, 'ertert', NULL, NULL, '2016-09-20 16:32:00'),
77(5, 'ertert', NULL, NULL, '2016-09-20 16:32:00'),
78(6, 'ertert', NULL, NULL, '2016-09-20 16:32:00'),
79(7, 'ertert', NULL, NULL, '2016-09-20 16:32:00'),
80(8, 'ertert', NULL, NULL, '2016-09-20 16:32:00'),
81(9, 'ertert', NULL, NULL, '2016-09-20 16:32:00'),
82(10, 'ertert', NULL, NULL, '2016-09-20 16:32:00'),
83(11, 'ertert', NULL, NULL, '2016-09-20 16:32:00'),
84(12, 'ertert', NULL, NULL, '2016-09-20 16:32:00'),
85(13, 'zrtzr', NULL, 82386710868, '2016-09-20 16:33:00'),
86(14, 'werwer', 86891762479, NULL, '2016-09-20 16:34:00'),
87(15, 'rtzertz', 86891762479, NULL, '2016-09-20 16:37:00'),
88(16, 'rtzertz', 86891762479, NULL, '2016-09-20 16:37:00'),
89(17, 'rtzertz', 86891762479, NULL, '2016-09-20 16:37:00'),
90(18, 'rtzertz', 86891762479, NULL, '2016-09-20 16:37:00'),
91(19, 'rtuzrtz', 86891762479, NULL, '2016-09-20 16:38:00'),
92(20, '78', NULL, 82386710868, '2016-09-20 17:14:00'),
93(21, 'iopsdjt', 86891762479, NULL, '2016-09-20 23:58:00'),
94(22, '123', 86891762479, NULL, '2016-09-23 15:28:00'),
95(23, '123', 86891762479, NULL, '2016-09-23 23:21:00'),
96(24, '99o', 86891762479, NULL, '2016-09-24 08:48:00'),
97(25, 'erwr', NULL, 21061265696, '2016-09-26 12:54:00');
98
99-- --------------------------------------------------------
100
101--
102-- Table structure for table `jedilnik`
103--
104
105CREATE TABLE IF NOT EXISTS `jedilnik` (
106 `id` bigint(20) NOT NULL,
107 `fk_lokal_id` bigint(20) NOT NULL,
108 `memo` varchar(64) COLLATE utf8_slovenian_ci NOT NULL,
109 `datum_vnosa` datetime NOT NULL,
110 `active` tinyint(1) NOT NULL DEFAULT '0',
111 `tip` tinyint(1) NOT NULL DEFAULT '0',
112 PRIMARY KEY (`id`),
113 KEY `fk_lokal_id` (`fk_lokal_id`)
114) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_slovenian_ci;
115
116--
117-- Dumping data for table `jedilnik`
118--
119
120INSERT INTO `jedilnik` (`id`, `fk_lokal_id`, `memo`, `datum_vnosa`, `active`, `tip`) VALUES
121(123123, 82386710868, 'def', '2016-09-23 14:09:00', 1, 0),
122(60602130512, 35358669632, 'Privzeto', '2016-09-24 09:52:00', 0, 0),
123(89380512299, 21061265696, 'Privzeto', '2016-09-23 14:09:00', 1, 0);
124
125-- --------------------------------------------------------
126
127--
128-- Table structure for table `jedilnik_meni`
129--
130
131CREATE TABLE IF NOT EXISTS `jedilnik_meni` (
132 `id` int(11) NOT NULL AUTO_INCREMENT,
133 `naziv` varchar(64) COLLATE utf8_slovenian_ci DEFAULT NULL,
134 `fk_jedilnik_id` bigint(20) NOT NULL,
135 `fk_jedilnik_tip` int(11) DEFAULT NULL,
136 `jedilnik` mediumtext COLLATE utf8_slovenian_ci NOT NULL,
137 `cena` double DEFAULT '-1',
138 `bon` tinyint(1) NOT NULL DEFAULT '0',
139 PRIMARY KEY (`id`),
140 KEY `fk_meni_id` (`fk_jedilnik_id`),
141 KEY `fk_jedilnik_tip` (`fk_jedilnik_tip`),
142 KEY `fk_meni_id_2` (`fk_jedilnik_id`),
143 KEY `fk_jedilnik_tip_2` (`fk_jedilnik_tip`),
144 KEY `fk_jedilnik_id` (`fk_jedilnik_id`)
145) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_slovenian_ci AUTO_INCREMENT=193 ;
146
147--
148-- Dumping data for table `jedilnik_meni`
149--
150
151INSERT INTO `jedilnik_meni` (`id`, `naziv`, `fk_jedilnik_id`, `fk_jedilnik_tip`, `jedilnik`, `cena`, `bon`) VALUES
152(174, 'Kosilo 11', 89380512299, 2, 'OCVRTI MEDALJONI,NJOKI S PARMEZANOMm', 3.66, 1),
153(175, 'Kosilo 2', 89380512299, 2, 'KORENČKOVA JUHA::SOLATNI KROŽNIK S POPEČENO ZELENJAVO,HLEBČEK IZ KRUŠNE PEČI::ZELENA,PAPRADIŽNIK,KORUZA,FIŽOL::JABOLKO', 3.6, 0),
154(176, 'Kosilo 3', 89380512299, 2, 'KORENČKOVA JUHA::LOSOS NA ŽARU,BLITVA S KROMPIRJEM::SEZONSKA SOLATA::JABOLKO', 3.6, 0),
155(177, 'Kosilo 1', 60602130512, 1, 'POHORSKI LONEC, ÄŒOKOLADICA::SESTAVLJENA SOLATA::SADJE', 2, 0),
156(178, 'Kosilo 2', 60602130512, 1, 'GOVEJI ZREZEK V LOVSKI OMAKI, TESTENINE::SESTAVLJENA SOLATA::SADJE', 2, 0),
157(179, 'Kosilo 23', 60602130512, 1, 'MESNI SIR NA ŽARU, RIŽ S KORENČKOM::SESTAVLJENA SOLATA::SADJE', 2, 0),
158(180, 'Kosilo bon', 60602130512, 3, '123', 12, 1),
159(181, 'Kosilo 4', 89380512299, 1, '123', 34, 1),
160(182, 'qwe', 60602130512, 3, '23', 12, 1),
161(183, '123', 89380512299, 3, '23', 12, 1),
162(184, '12333', 89380512299, 3, '123', 12, 1),
163(185, '123', 89380512299, 3, '23', 123, 1),
164(186, '123', 89380512299, 3, '23', 123, 1),
165(187, '123', 89380512299, 3, '23', 123, 1),
166(188, '123', 89380512299, 3, '23', 123, 1),
167(189, '123', 89380512299, 4, '123', 213, 1),
168(190, '33', 89380512299, 4, '3', 3, 1),
169(191, '123', 89380512299, 4, '23', 213, 1),
170(192, 'wqe', 89380512299, 3, '123', 123, 1);
171
172-- --------------------------------------------------------
173
174--
175-- Table structure for table `jedilnik_tip`
176--
177
178CREATE TABLE IF NOT EXISTS `jedilnik_tip` (
179 `id` int(11) NOT NULL,
180 `naziv` varchar(32) NOT NULL,
181 PRIMARY KEY (`id`)
182) ENGINE=InnoDB DEFAULT CHARSET=latin1;
183
184--
185-- Dumping data for table `jedilnik_tip`
186--
187
188INSERT INTO `jedilnik_tip` (`id`, `naziv`) VALUES
189(1, 'Mesni'),
190(2, 'Vege'),
191(3, 'Ribe'),
192(4, 'Hitra hrana'),
193(5, 'Pizza'),
194(6, 'Testenine');
195
196-- --------------------------------------------------------
197
198--
199-- Table structure for table `lokal`
200--
201
202CREATE TABLE IF NOT EXISTS `lokal` (
203 `id` bigint(11) NOT NULL,
204 `active` tinyint(1) NOT NULL DEFAULT '1',
205 `naziv` varchar(32) COLLATE utf16_slovenian_ci NOT NULL,
206 `lastnik` varchar(32) COLLATE utf16_slovenian_ci NOT NULL,
207 `naslov` varchar(48) COLLATE utf16_slovenian_ci NOT NULL,
208 `kraj` varchar(20) COLLATE utf16_slovenian_ci NOT NULL,
209 `telefon` varchar(14) CHARACTER SET latin1 NOT NULL,
210 `email` varchar(32) CHARACTER SET latin1 DEFAULT NULL,
211 `geslo` text CHARACTER SET utf32 COLLATE utf32_slovenian_ci NOT NULL,
212 `salt` text CHARACTER SET latin1 NOT NULL,
213 `odprto_teden_zacetek` varchar(8) CHARACTER SET latin1 NOT NULL,
214 `odprto_teden_konec` varchar(8) CHARACTER SET latin1 NOT NULL,
215 `odprto_sobota_zacetek` varchar(8) CHARACTER SET latin1 NOT NULL,
216 `odprto_sobota_konec` varchar(8) CHARACTER SET latin1 NOT NULL,
217 `odprto_nedelja_zacetek` varchar(8) CHARACTER SET latin1 NOT NULL,
218 `odprto_nedelja_konec` varchar(8) CHARACTER SET latin1 NOT NULL,
219 `datum_registracije` datetime NOT NULL,
220 `dostava` tinyint(1) NOT NULL,
221 `boni` tinyint(1) NOT NULL,
222 `dostava_vikend` tinyint(1) NOT NULL,
223 `vege` tinyint(1) NOT NULL,
224 `kosila` tinyint(1) NOT NULL,
225 `img` varchar(128) COLLATE utf16_slovenian_ci DEFAULT NULL,
226 `placilo_gotovina` tinyint(1) NOT NULL,
227 `placilo_kartica` tinyint(1) NOT NULL,
228 `placilo_moneta` tinyint(1) NOT NULL,
229 PRIMARY KEY (`id`)
230) ENGINE=InnoDB DEFAULT CHARSET=utf16 COLLATE=utf16_slovenian_ci;
231
232--
233-- Dumping data for table `lokal`
234--
235
236INSERT INTO `lokal` (`id`, `active`, `naziv`, `lastnik`, `naslov`, `kraj`, `telefon`, `email`, `geslo`, `salt`, `odprto_teden_zacetek`, `odprto_teden_konec`, `odprto_sobota_zacetek`, `odprto_sobota_konec`, `odprto_nedelja_zacetek`, `odprto_nedelja_konec`, `datum_registracije`, `dostava`, `boni`, `dostava_vikend`, `vege`, `kosila`, `img`, `placilo_gotovina`, `placilo_kartica`, `placilo_moneta`) VALUES
237(1893643639, 1, 'Back Werk', 'null', 'Slovenska cesta 52', 'Ljubljana', '031000000', 'null@gmail.com', 'adba5a82a61eb402dd3c7f939f6344f0021d78a54e553a2cba0d74f0845a4404', '27096876959727515', '00:00', '00:00', '00:00', '00:00', '00:00', '00:00', '2016-09-08 23:24:49', 0, 0, 1, 0, 0, NULL, 0, 0, 0),
238(6934453239, 1, 'Back Werk', 'null', 'Slovenska cesta 52', 'Ljubljana', '031000000', 'null@gmail.com', 'adba5a82a61eb402dd3c7f939f6344f0021d78a54e553a2cba0d74f0845a4404', '27096876959727515', '00:00', '00:00', '00:00', '00:00', '00:00', '00:00', '2016-09-08 23:24:49', 0, 0, 1, 0, 0, NULL, 0, 0, 0),
239(6934455239, 1, 'Back Werk', 'null', 'Slovenska cesta 52', 'Ljubljana', '031000000', 'null@gmail.com', 'adba5a82a61eb402dd3c7f939f6344f0021d78a54e553a2cba0d74f0845a4404', '27096876959727515', '00:00', '00:00', '00:00', '00:00', '00:00', '00:00', '2016-09-08 23:24:49', 0, 0, 1, 0, 0, NULL, 0, 0, 0),
240(6936453239, 1, 'Back Werk', 'null', 'Slovenska cesta 52', 'Ljubljana', '031000000', 'null@gmail.com', 'adba5a82a61eb402dd3c7f939f6344f0021d78a54e553a2cba0d74f0845a4404', '27096876959727515', '00:00', '00:00', '00:00', '00:00', '00:00', '00:00', '2016-09-08 23:24:49', 0, 0, 1, 0, 0, NULL, 0, 0, 0),
241(6936453639, 1, 'Back Werk', 'null', 'Slovenska cesta 52', 'Ljubljana', '031000000', 'null@gmail.com', 'adba5a82a61eb402dd3c7f939f6344f0021d78a54e553a2cba0d74f0845a4404', '27096876959727515', '00:00', '00:00', '00:00', '00:00', '00:00', '00:00', '2016-09-08 23:24:49', 0, 0, 1, 0, 0, NULL, 0, 0, 0),
242(6964455239, 1, 'Back Werk', 'null', 'Slovenska cesta 52', 'Ljubljana', '031000000', 'null@gmail.com', 'adba5a82a61eb402dd3c7f939f6344f0021d78a54e553a2cba0d74f0845a4404', '27096876959727515', '00:00', '00:00', '00:00', '00:00', '00:00', '00:00', '2016-09-08 23:24:49', 0, 0, 1, 0, 0, NULL, 0, 0, 0),
243(10936114618, 1, 'Back Werk', 'null', 'Slovenska cesta 52', 'Ljubljana', '031000000', 'null@gmail.com', 'adba5a82a61eb402dd3c7f939f6344f0021d78a54e553a2cba0d74f0845a4404', '27096876959727515', '00:00', '00:00', '00:00', '00:00', '00:00', '00:00', '2016-09-08 23:24:49', 0, 0, 1, 0, 0, NULL, 0, 0, 0),
244(10936114619, 1, 'Back Werk', 'null', 'Slovenska cesta 52', 'Ljubljana', '031000000', 'null@gmail.com', 'adba5a82a61eb402dd3c7f939f6344f0021d78a54e553a2cba0d74f0845a4404', '27096876959727515', '00:00', '00:00', '00:00', '00:00', '00:00', '00:00', '2016-09-08 23:24:49', 0, 0, 1, 0, 0, NULL, 0, 0, 0),
245(10936114639, 1, 'Back Werk', 'null', 'Slovenska cesta 52', 'Ljubljana', '031000000', 'null@gmail.com', 'adba5a82a61eb402dd3c7f939f6344f0021d78a54e553a2cba0d74f0845a4404', '27096876959727515', '00:00', '00:00', '00:00', '00:00', '00:00', '00:00', '2016-09-08 23:24:49', 0, 0, 1, 0, 0, NULL, 0, 0, 0),
246(10936414639, 1, 'Back Werk', 'null', 'Slovenska cesta 52', 'Ljubljana', '031000000', 'null@gmail.com', 'adba5a82a61eb402dd3c7f939f6344f0021d78a54e553a2cba0d74f0845a4404', '27096876959727515', '00:00', '00:00', '00:00', '00:00', '00:00', '00:00', '2016-09-08 23:24:49', 0, 0, 1, 0, 0, NULL, 0, 0, 0),
247(10936454639, 1, 'Back Werk', 'null', 'Slovenska cesta 52', 'Ljubljana', '031000000', 'null@gmail.com', 'adba5a82a61eb402dd3c7f939f6344f0021d78a54e553a2cba0d74f0845a4404', '27096876959727515', '00:00', '00:00', '00:00', '00:00', '00:00', '00:00', '2016-09-08 23:24:49', 0, 0, 1, 0, 0, NULL, 0, 0, 0),
248(12936454639, 1, 'Back Werk', 'null', 'Slovenska cesta 52', 'Ljubljana', '031000000', 'null@gmail.com', 'adba5a82a61eb402dd3c7f939f6344f0021d78a54e553a2cba0d74f0845a4404', '27096876959727515', '00:00', '00:00', '00:00', '00:00', '00:00', '00:00', '2016-09-08 23:24:49', 0, 0, 1, 0, 0, NULL, 0, 0, 0),
249(13936454639, 1, 'Back Werk', 'null', 'Slovenska cesta 52', 'Ljubljana', '031000000', 'null@gmail.com', 'adba5a82a61eb402dd3c7f939f6344f0021d78a54e553a2cba0d74f0845a4404', '27096876959727515', '00:00', '00:00', '00:00', '00:00', '00:00', '00:00', '2016-09-08 23:24:49', 0, 0, 1, 0, 0, NULL, 0, 0, 0),
250(16936454639, 1, 'Back Werk', 'null', 'Slovenska cesta 52', 'Ljubljana', '031000000', 'null@gmail.com', 'adba5a82a61eb402dd3c7f939f6344f0021d78a54e553a2cba0d74f0845a4404', '27096876959727515', '00:00', '00:00', '00:00', '00:00', '00:00', '00:00', '2016-09-08 23:24:49', 0, 0, 1, 0, 0, NULL, 0, 0, 0),
251(18936414639, 1, 'Back Werk', 'null', 'Slovenska cesta 52', 'Ljubljana', '031000000', 'null@gmail.com', 'adba5a82a61eb402dd3c7f939f6344f0021d78a54e553a2cba0d74f0845a4404', '27096876959727515', '00:00', '00:00', '00:00', '00:00', '00:00', '00:00', '2016-09-08 23:24:49', 0, 0, 1, 0, 0, NULL, 0, 0, 0),
252(18936424639, 1, 'Back Werk', 'null', 'Slovenska cesta 52', 'Ljubljana', '031000000', 'null@gmail.com', 'adba5a82a61eb402dd3c7f939f6344f0021d78a54e553a2cba0d74f0845a4404', '27096876959727515', '00:00', '00:00', '00:00', '00:00', '00:00', '00:00', '2016-09-08 23:24:49', 0, 0, 1, 0, 0, NULL, 0, 0, 0),
253(18936453639, 1, 'Back Werk', 'null', 'Slovenska cesta 52', 'Ljubljana', '031000000', 'null@gmail.com', 'adba5a82a61eb402dd3c7f939f6344f0021d78a54e553a2cba0d74f0845a4404', '27096876959727515', '00:00', '00:00', '00:00', '00:00', '00:00', '00:00', '2016-09-08 23:24:49', 0, 0, 1, 0, 0, NULL, 0, 0, 0),
254(18936454639, 1, 'Back Werk', 'null', 'Slovenska cesta 52', 'Ljubljana', '031000000', 'null@gmail.com', 'adba5a82a61eb402dd3c7f939f6344f0021d78a54e553a2cba0d74f0845a4404', '27096876959727515', '00:00', '00:00', '00:00', '00:00', '00:00', '00:00', '2016-09-08 23:24:49', 0, 0, 1, 0, 0, NULL, 0, 0, 0),
255(20934442485, 1, 'Astoria City Cusine', 'null', 'Slovenska ulica 2', 'Maribor', '026211700', 'null@gmail.com', '9f02abb69b0cc1386c3c42e914d003ecea548d690d8a1cbaeabc24f3b29c3943', '79788284005675642', '00:00', '00:00', '00:00', '00:00', '00:00', '00:00', '2016-09-08 23:23:21', 0, 1, 1, 1, 0, NULL, 0, 0, 0),
256(21061265696, 1, 'Taverna Sicilia', 'Taverna Sicilia', 'Ulica Heroja Nandeta 31', 'Maribor', '024260315', 'taverna@gmail.com', 'ada74449655cc03710ed3e0f6ae2b70570c608806e0c8e29f7b61f5037cc1601', '95349182653758480', '09:00', '20:00', '11:00', '20:00', '11:00', '20:00', '2016-09-23 14:09:00', 1, 1, 1, 1, 1, NULL, 1, 1, 1),
257(35358669632, 1, 'Gurmanski hram', 'Gurmanski hram', 'Zagrebška cesta 92', 'Maribor', '031467088', 'gurmanski@gmail.com', 'c056c6544d63f8809711acbc7de018bb4e9e77ce92e4be3abeb1fbf33656c9b2', '54609880451878850', '10:10', '16:00', '00:00', '00:00', '00:00', '00:00', '2016-09-24 09:52:00', 1, 1, 0, 1, 1, NULL, 1, 0, 0),
258(52927503148, 1, 'ApaÄi', 'ApaÄi', 'Pohorska cesta 17b', 'Slovenj Gradec', '028831784', 'apaci@gmail.com', '923b10184d21542f7a487f9300df1acab272269c9e41edf80d49934e73f0a370', '88528993183838781', '01:00', '23:00', '12:00', '01:00', '12:00', '22:00', '2016-09-08 14:29:57', 0, 1, 0, 1, 0, NULL, 0, 0, 0),
259(66328866021, 1, 'AROMA, restavracija in pizzerija', 'null', 'Ribji trg 2', 'Ljubljana', '031000000', 'noemail@gmail.com', '7ad3ed8d42f79c9e03a11102c3ca33c517d4ec0f923e99043982019f0c1daea4', '82067569399867435', '00:00', '00:00', '00:00', '00:00', '00:00', '00:00', '2016-09-08 23:21:48', 0, 0, 1, 1, 0, NULL, 0, 0, 0),
260(82045867280, 1, 'tilen', 'tilen', 'tilen', 'tilen', '031000000', 'tilen@gmail.com', '58dfa4991ba96e60caaad2728dc89ab89552a107e714d54c0dbe8b2103c5e60e', '78306335072898800', '00:00', '00:00', '00:00', '00:00', '00:00', '00:00', '2016-09-10 15:44:00', 1, 1, 1, 1, 1, NULL, 0, 0, 0),
261(82386710868, 1, 'AL Pachino', 'AL Pachino', 'Gosposvetska cesta 87', 'Maribor', '041566373', 'alpachino@gmail.com', '58dfa4991ba96e60caaad2728dc89ab89552a107e714d54c0dbe8b2103c5e60e', '78306335072898800', '10:00', '20:00', '00:00', '00:00', '00:00', '00:00', '2016-09-08 14:27:24', 1, 1, 1, 0, 0, NULL, 0, 0, 0),
262(84189335439, 1, 'Bohor d.o.o.', 'Bohor d.o.o.', 'KidriÄeva ulica 23', 'RogaÅ¡ka Slatina', '031000000', 'null@gmail.com', '5dba49c1fc147a6cc814fae84bc3f29405c222f4dc9ddafc547cd3b0e862d66c', '33987949451383398', '00:00', '00:00', '00:00', '00:00', '00:00', '00:00', '2016-09-08 23:27:47', 0, 0, 1, 1, 0, NULL, 0, 0, 0);
263
264-- --------------------------------------------------------
265
266--
267-- Table structure for table `lokal_nagrada`
268--
269
270CREATE TABLE IF NOT EXISTS `lokal_nagrada` (
271 `id` int(11) NOT NULL AUTO_INCREMENT,
272 `fk_lokal_id` bigint(20) NOT NULL,
273 `fk_nagrada_id` int(11) NOT NULL,
274 `datum_prejema` datetime NOT NULL,
275 PRIMARY KEY (`id`),
276 KEY `fk_lokal_id` (`fk_lokal_id`,`fk_nagrada_id`),
277 KEY `fk_lokal_id_2` (`fk_lokal_id`),
278 KEY `fk_nagrada_id` (`fk_nagrada_id`)
279) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
280
281-- --------------------------------------------------------
282
283--
284-- Table structure for table `nacin_placila`
285--
286
287CREATE TABLE IF NOT EXISTS `nacin_placila` (
288 `id` int(11) NOT NULL AUTO_INCREMENT,
289 `naziv` varchar(32) NOT NULL,
290 PRIMARY KEY (`id`)
291) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;
292
293--
294-- Dumping data for table `nacin_placila`
295--
296
297INSERT INTO `nacin_placila` (`id`, `naziv`) VALUES
298(1, 'Gotovina'),
299(2, 'Kartica'),
300(3, 'Moneta');
301
302-- --------------------------------------------------------
303
304--
305-- Table structure for table `nagrada`
306--
307
308CREATE TABLE IF NOT EXISTS `nagrada` (
309 `id` int(11) NOT NULL AUTO_INCREMENT,
310 `naziv` varchar(64) COLLATE utf8_slovenian_ci NOT NULL,
311 `ico` varchar(64) COLLATE utf8_slovenian_ci DEFAULT NULL,
312 PRIMARY KEY (`id`)
313) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_slovenian_ci AUTO_INCREMENT=1 ;
314
315-- --------------------------------------------------------
316
317--
318-- Table structure for table `narocilo`
319--
320
321CREATE TABLE IF NOT EXISTS `narocilo` (
322 `id` bigint(20) NOT NULL,
323 `fk_uporabnik_id` bigint(20) NOT NULL,
324 `fk_jedilnik_meni_id` int(11) DEFAULT NULL,
325 `fk_lokal_id` bigint(20) NOT NULL,
326 `bon` tinyint(1) NOT NULL,
327 `naslov` varchar(64) CHARACTER SET utf8 COLLATE utf8_slovenian_ci NOT NULL,
328 `kraj` varchar(64) CHARACTER SET utf8 COLLATE utf8_slovenian_ci NOT NULL,
329 `telefon` varchar(64) NOT NULL,
330 `cena` double NOT NULL,
331 `komentar` text CHARACTER SET utf8 COLLATE utf8_slovenian_ci NOT NULL,
332 `datum_narocila` datetime NOT NULL,
333 `datum_sprejema` datetime DEFAULT NULL,
334 `koncano` tinyint(1) NOT NULL DEFAULT '0',
335 `predviden_cas_dostave` int(11) DEFAULT NULL,
336 `fk_nacin_placila` int(11) DEFAULT '1',
337 `zavrnjeno` tinyint(1) NOT NULL DEFAULT '0',
338 PRIMARY KEY (`id`),
339 KEY `fk_uporabnik_id` (`fk_uporabnik_id`),
340 KEY `fk_lokal_id` (`fk_lokal_id`),
341 KEY `fk_jedilnik_meni_id` (`fk_jedilnik_meni_id`),
342 KEY `fk_nacin_placila` (`fk_nacin_placila`)
343) ENGINE=InnoDB DEFAULT CHARSET=latin1;
344
345--
346-- Dumping data for table `narocilo`
347--
348
349INSERT INTO `narocilo` (`id`, `fk_uporabnik_id`, `fk_jedilnik_meni_id`, `fk_lokal_id`, `bon`, `naslov`, `kraj`, `telefon`, `cena`, `komentar`, `datum_narocila`, `datum_sprejema`, `koncano`, `predviden_cas_dostave`, `fk_nacin_placila`, `zavrnjeno`) VALUES
350(48823427674, 86891762479, 175, 21061265696, 1, 'Naslov 12', 'Maribor', '031000000', 3.6, '', '2016-09-26 13:36:00', NULL, 0, NULL, 1, 0),
351(57079355894, 86891762479, 176, 21061265696, 1, 'Naslov 12', 'Maribor', '031000000', 3.6, '', '2016-09-26 13:36:00', NULL, 0, NULL, 1, 0),
352(63259454303, 86891762479, 175, 21061265696, 1, 'Naslov 12', 'Maribor', '031000000', 3.6, '', '2016-09-26 14:53:00', NULL, 0, NULL, 1, 0);
353
354-- --------------------------------------------------------
355
356--
357-- Table structure for table `narocilo_feedback`
358--
359
360CREATE TABLE IF NOT EXISTS `narocilo_feedback` (
361 `id` int(11) NOT NULL AUTO_INCREMENT,
362 `fk_uporabnik_id` bigint(20) NOT NULL,
363 `fk_narocilo_id` bigint(20) DEFAULT NULL,
364 `fk_lokal_id` bigint(20) NOT NULL,
365 `ocena` int(11) NOT NULL,
366 `mnenje` text NOT NULL,
367 PRIMARY KEY (`id`),
368 KEY `fk_lokal_id` (`fk_lokal_id`),
369 KEY `fk_uporabnik_id` (`fk_uporabnik_id`),
370 KEY `fk_narocilo_id` (`fk_narocilo_id`)
371) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=20 ;
372
373--
374-- Dumping data for table `narocilo_feedback`
375--
376
377INSERT INTO `narocilo_feedback` (`id`, `fk_uporabnik_id`, `fk_narocilo_id`, `fk_lokal_id`, `ocena`, `mnenje`) VALUES
378(16, 86891762479, NULL, 82386710868, 4, '123'),
379(17, 86891762479, NULL, 21061265696, 5, 'dobro'),
380(18, 86891762479, NULL, 21061265696, 5, 'ok'),
381(19, 86891762479, NULL, 21061265696, 5, '');
382
383-- --------------------------------------------------------
384
385--
386-- Table structure for table `ocena`
387--
388
389CREATE TABLE IF NOT EXISTS `ocena` (
390 `id` int(11) NOT NULL AUTO_INCREMENT,
391 `fk_lokal_id` bigint(11) NOT NULL,
392 `fk_uporabnik_id` bigint(11) NOT NULL,
393 `ocena` int(11) NOT NULL,
394 PRIMARY KEY (`id`),
395 KEY `fk_uporabnik_id` (`fk_uporabnik_id`),
396 KEY `fk_lokal_id` (`fk_lokal_id`)
397) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=16 ;
398
399--
400-- Dumping data for table `ocena`
401--
402
403INSERT INTO `ocena` (`id`, `fk_lokal_id`, `fk_uporabnik_id`, `ocena`) VALUES
404(12, 82386710868, 86891762479, 5),
405(13, 52927503148, 86891762479, 3),
406(14, 82045867280, 86891762479, 5),
407(15, 21061265696, 86891762479, 5);
408
409-- --------------------------------------------------------
410
411--
412-- Table structure for table `priljubljeno`
413--
414
415CREATE TABLE IF NOT EXISTS `priljubljeno` (
416 `id` int(11) NOT NULL AUTO_INCREMENT,
417 `fk_uporabnik_id` bigint(20) NOT NULL,
418 `fk_lokal_id` bigint(20) NOT NULL,
419 PRIMARY KEY (`id`),
420 KEY `fk_uporabnik_id` (`fk_uporabnik_id`,`fk_lokal_id`),
421 KEY `fk_lokal_id` (`fk_lokal_id`)
422) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=18 ;
423
424--
425-- Dumping data for table `priljubljeno`
426--
427
428INSERT INTO `priljubljeno` (`id`, `fk_uporabnik_id`, `fk_lokal_id`) VALUES
429(14, 86891762479, 82045867280),
430(17, 86891762479, 82386710868);
431
432-- --------------------------------------------------------
433
434--
435-- Table structure for table `uporabnik`
436--
437
438CREATE TABLE IF NOT EXISTS `uporabnik` (
439 `id` bigint(11) NOT NULL,
440 `email` varchar(32) NOT NULL,
441 `ime` varchar(14) CHARACTER SET utf8 COLLATE utf8_slovenian_ci NOT NULL,
442 `priimek` varchar(20) CHARACTER SET utf8 COLLATE utf8_slovenian_ci NOT NULL,
443 `telefon` varchar(14) NOT NULL,
444 `naslov` varchar(40) CHARACTER SET utf8 COLLATE utf8_slovenian_ci NOT NULL,
445 `kraj` varchar(20) CHARACTER SET utf8 COLLATE utf8_slovenian_ci NOT NULL,
446 `geslo` text CHARACTER SET utf8 COLLATE utf8_slovenian_ci NOT NULL,
447 `salt` text NOT NULL,
448 `ip` varchar(20) NOT NULL,
449 `datum_registracije` datetime NOT NULL,
450 `bon` tinyint(1) NOT NULL,
451 `last_login` datetime NOT NULL,
452 `narocilo_default_naslov` tinyint(1) NOT NULL DEFAULT '0',
453 PRIMARY KEY (`id`)
454) ENGINE=InnoDB DEFAULT CHARSET=latin1;
455
456--
457-- Dumping data for table `uporabnik`
458--
459
460INSERT INTO `uporabnik` (`id`, `email`, `ime`, `priimek`, `telefon`, `naslov`, `kraj`, `geslo`, `salt`, `ip`, `datum_registracije`, `bon`, `last_login`, `narocilo_default_naslov`) VALUES
461(39419784779, 'poqwek@gmail.com', 'qpwoek', 'qwpoek', '031000000', 'qpwoek', 'qwepok', '984c063ea00984de73129ef5f21aae8ee8b6cc6ea84e1f870b48cb2c09026756', '99688739803629536', '::1', '2016-09-10 12:26:00', 1, '2016-09-10 12:26:00', 0),
462(59588628968, 'topkek@gmail.com', 'weiorj', 'qweopk', '031000000', 'qwekowoek', 'qwopek', 'c8af6fbd53a217c783881c02f8e1d78aaf5129bd229e04d890b8c95bb9610f81', '81289829638870888', '::1', '2016-09-24 09:27:00', 1, '2016-09-24 09:27:00', 0),
463(86891762479, 'tilen1@gmail.com', 'tilen', 'priimek', '031000000', 'naslov 12', 'maribor', '2bac383336519df7129ca77575dad272bfe86ff8547a6841dc1f8e648086654c', '80509632030640054', '::1', '2016-09-10 14:18:00', 1, '2016-09-26 13:28:00', 0);
464
465-- --------------------------------------------------------
466
467--
468-- Table structure for table `uporabnik_nagrada`
469--
470
471CREATE TABLE IF NOT EXISTS `uporabnik_nagrada` (
472 `id` int(11) NOT NULL AUTO_INCREMENT,
473 `fk_uporabnik_id` bigint(20) NOT NULL,
474 `fk_nagrada_id` int(11) NOT NULL,
475 `datum_prejema` datetime NOT NULL,
476 PRIMARY KEY (`id`),
477 KEY `fk_uporabnik_id` (`fk_uporabnik_id`,`fk_nagrada_id`),
478 KEY `fk_uporabnik_id_2` (`fk_uporabnik_id`),
479 KEY `fk_nagrada_id` (`fk_nagrada_id`)
480) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_slovenian_ci AUTO_INCREMENT=1 ;
481
482--
483-- Constraints for dumped tables
484--
485
486--
487-- Constraints for table `akcija`
488--
489ALTER TABLE `akcija`
490 ADD CONSTRAINT `akcija_ibfk_1` FOREIGN KEY (`fk_lokal_id`) REFERENCES `lokal` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
491
492--
493-- Constraints for table `feedback`
494--
495ALTER TABLE `feedback`
496 ADD CONSTRAINT `feedback_ibfk_1` FOREIGN KEY (`fk_uporabnik_id`) REFERENCES `uporabnik` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
497 ADD CONSTRAINT `feedback_ibfk_2` FOREIGN KEY (`fk_lokal_id`) REFERENCES `lokal` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
498
499--
500-- Constraints for table `jedilnik`
501--
502ALTER TABLE `jedilnik`
503 ADD CONSTRAINT `jedilnik_ibfk_1` FOREIGN KEY (`fk_lokal_id`) REFERENCES `lokal` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
504
505--
506-- Constraints for table `jedilnik_meni`
507--
508ALTER TABLE `jedilnik_meni`
509 ADD CONSTRAINT `jedilnik_meni_ibfk_1` FOREIGN KEY (`fk_jedilnik_id`) REFERENCES `jedilnik` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
510 ADD CONSTRAINT `jedilnik_meni_ibfk_2` FOREIGN KEY (`fk_jedilnik_tip`) REFERENCES `jedilnik_tip` (`id`) ON DELETE SET NULL ON UPDATE SET NULL;
511
512--
513-- Constraints for table `lokal_nagrada`
514--
515ALTER TABLE `lokal_nagrada`
516 ADD CONSTRAINT `lokal_nagrada_ibfk_2` FOREIGN KEY (`fk_nagrada_id`) REFERENCES `nagrada` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
517 ADD CONSTRAINT `lokal_nagrada_ibfk_1` FOREIGN KEY (`fk_lokal_id`) REFERENCES `lokal` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
518
519--
520-- Constraints for table `narocilo`
521--
522ALTER TABLE `narocilo`
523 ADD CONSTRAINT `narocilo_ibfk_1` FOREIGN KEY (`fk_lokal_id`) REFERENCES `lokal` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
524 ADD CONSTRAINT `narocilo_ibfk_2` FOREIGN KEY (`fk_uporabnik_id`) REFERENCES `uporabnik` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
525 ADD CONSTRAINT `narocilo_ibfk_3` FOREIGN KEY (`fk_jedilnik_meni_id`) REFERENCES `jedilnik_meni` (`id`) ON DELETE SET NULL ON UPDATE SET NULL,
526 ADD CONSTRAINT `narocilo_ibfk_4` FOREIGN KEY (`fk_nacin_placila`) REFERENCES `nacin_placila` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
527
528--
529-- Constraints for table `narocilo_feedback`
530--
531ALTER TABLE `narocilo_feedback`
532 ADD CONSTRAINT `narocilo_feedback_ibfk_1` FOREIGN KEY (`fk_uporabnik_id`) REFERENCES `uporabnik` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
533 ADD CONSTRAINT `narocilo_feedback_ibfk_2` FOREIGN KEY (`fk_narocilo_id`) REFERENCES `narocilo` (`id`) ON DELETE SET NULL ON UPDATE SET NULL,
534 ADD CONSTRAINT `narocilo_feedback_ibfk_3` FOREIGN KEY (`fk_lokal_id`) REFERENCES `lokal` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
535
536--
537-- Constraints for table `ocena`
538--
539ALTER TABLE `ocena`
540 ADD CONSTRAINT `ocena_ibfk_1` FOREIGN KEY (`fk_lokal_id`) REFERENCES `lokal` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
541 ADD CONSTRAINT `ocena_ibfk_2` FOREIGN KEY (`fk_uporabnik_id`) REFERENCES `uporabnik` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
542
543--
544-- Constraints for table `priljubljeno`
545--
546ALTER TABLE `priljubljeno`
547 ADD CONSTRAINT `priljubljeno_ibfk_1` FOREIGN KEY (`fk_uporabnik_id`) REFERENCES `uporabnik` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
548 ADD CONSTRAINT `priljubljeno_ibfk_2` FOREIGN KEY (`fk_lokal_id`) REFERENCES `lokal` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
549
550--
551-- Constraints for table `uporabnik_nagrada`
552--
553ALTER TABLE `uporabnik_nagrada`
554 ADD CONSTRAINT `uporabnik_nagrada_ibfk_2` FOREIGN KEY (`fk_nagrada_id`) REFERENCES `nagrada` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
555 ADD CONSTRAINT `uporabnik_nagrada_ibfk_1` FOREIGN KEY (`fk_uporabnik_id`) REFERENCES `uporabnik` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
556
557/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
558/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
559/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;