· 9 years ago · Dec 22, 2016, 07:10 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: Dec 22, 2016 at 08:08 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 `komentar` text COLLATE utf8_slovenian_ci NOT NULL,
40 PRIMARY KEY (`id`),
41 KEY `fk_lokal_id` (`fk_lokal_id`)
42) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_slovenian_ci AUTO_INCREMENT=2 ;
43
44--
45-- Dumping data for table `akcija`
46--
47
48INSERT INTO `akcija` (`id`, `kupon`, `procent`, `cena`, `fk_lokal_id`, `aktivno`, `spletno`, `datum_vnosa`, `naziv`, `komentar`) VALUES
49(1, '', 12, -1, 21061265696, 1, 1, '2016-09-26 17:55:00', '123', '');
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=28 ;
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(26, 'qwe', 86891762479, NULL, '2016-09-30 23:19:00'),
99(27, 'qwe', 86891762479, NULL, '2016-12-06 18:48:00');
100
101-- --------------------------------------------------------
102
103--
104-- Table structure for table `jedilnik`
105--
106
107CREATE TABLE IF NOT EXISTS `jedilnik` (
108 `id` bigint(20) NOT NULL,
109 `fk_lokal_id` bigint(20) NOT NULL,
110 `memo` varchar(64) COLLATE utf8_slovenian_ci NOT NULL,
111 `datum_vnosa` datetime NOT NULL,
112 `active` tinyint(1) NOT NULL DEFAULT '0',
113 `tip` tinyint(1) NOT NULL DEFAULT '0',
114 PRIMARY KEY (`id`),
115 KEY `fk_lokal_id` (`fk_lokal_id`)
116) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_slovenian_ci;
117
118--
119-- Dumping data for table `jedilnik`
120--
121
122INSERT INTO `jedilnik` (`id`, `fk_lokal_id`, `memo`, `datum_vnosa`, `active`, `tip`) VALUES
123(123123, 82386710868, 'def', '2016-09-23 14:09:00', 1, 0),
124(60602130512, 35358669632, 'Privzeto', '2016-09-24 09:52:00', 0, 0),
125(89380512299, 21061265696, 'Privzeto', '2016-09-23 14:09:00', 1, 0);
126
127-- --------------------------------------------------------
128
129--
130-- Table structure for table `jedilnik_meni`
131--
132
133CREATE TABLE IF NOT EXISTS `jedilnik_meni` (
134 `id` int(11) NOT NULL AUTO_INCREMENT,
135 `naziv` varchar(64) COLLATE utf8_slovenian_ci DEFAULT NULL,
136 `fk_jedilnik_id` bigint(20) NOT NULL,
137 `fk_jedilnik_tip` int(11) DEFAULT NULL,
138 `jedilnik` mediumtext COLLATE utf8_slovenian_ci NOT NULL,
139 `cena` double DEFAULT '-1',
140 `bon` tinyint(1) NOT NULL DEFAULT '0',
141 PRIMARY KEY (`id`),
142 KEY `fk_meni_id` (`fk_jedilnik_id`),
143 KEY `fk_jedilnik_tip` (`fk_jedilnik_tip`),
144 KEY `fk_meni_id_2` (`fk_jedilnik_id`),
145 KEY `fk_jedilnik_tip_2` (`fk_jedilnik_tip`),
146 KEY `fk_jedilnik_id` (`fk_jedilnik_id`)
147) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_slovenian_ci AUTO_INCREMENT=223 ;
148
149--
150-- Dumping data for table `jedilnik_meni`
151--
152
153INSERT INTO `jedilnik_meni` (`id`, `naziv`, `fk_jedilnik_id`, `fk_jedilnik_tip`, `jedilnik`, `cena`, `bon`) VALUES
154(174, 'Kosilo 11', 89380512299, 2, 'OCVRTI MEDALJONI,NJOKI S PARMEZANOMm', 3.66, 0),
155(175, 'Kosilo 2', 89380512299, 1, '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),
156(176, 'Kosilo 3', 89380512299, 2, 'KORENČKOVA JUHA::LOSOS NA ŽARU,BLITVA S KROMPIRJEM::SEZONSKA SOLATA::JABOLKO', 3.6, 0),
157(177, 'Kosilo 1', 60602130512, 1, 'POHORSKI LONEC, ÄŒOKOLADICA::SESTAVLJENA SOLATA::SADJE', 2, 0),
158(178, 'Kosilo 2', 60602130512, 1, 'GOVEJI ZREZEK V LOVSKI OMAKI, TESTENINE::SESTAVLJENA SOLATA::SADJE', 2, 0),
159(179, 'Kosilo 23', 60602130512, 1, 'MESNI SIR NA ŽARU, RIŽ S KORENČKOM::SESTAVLJENA SOLATA::SADJE', 2, 0),
160(180, 'Kosilo bon', 60602130512, 3, '123', 12, 1),
161(181, 'Kosilo 4', 89380512299, 1, '123', 34, 1),
162(182, 'qwe', 60602130512, 3, '23', 12, 1),
163(183, '123', 89380512299, 3, '23', 12, 1),
164(184, '12333', 89380512299, 3, '123', 12, 1),
165(185, '123', 89380512299, 3, '23', 123, 1),
166(186, '123', 89380512299, 3, '23', 123, 1),
167(187, '123', 89380512299, 3, '23', 123, 1),
168(188, '123', 89380512299, 3, '23', 123, 1),
169(189, '123', 89380512299, 4, '123', 213, 1),
170(190, '33', 89380512299, 4, '3', 3, 1),
171(191, '123', 89380512299, 4, '23', 213, 1),
172(192, 'wqe', 89380512299, 3, '123', 123, 1),
173(193, 'Sladica', 89380512299, 4, 'qwe', 2, 1),
174(194, 'Sladica', 89380512299, 4, 'qwe', 2, 1),
175(195, 'Sladica', 89380512299, 4, 'qwe', 2, 1),
176(196, 'Sladica', 89380512299, 4, 'qwe', 2, 1),
177(197, 'Sladica', 89380512299, 4, 'qwe', 2, 1),
178(198, 'Sladica', 89380512299, 4, 'qwe', 2, 1),
179(199, 'Sladica', 89380512299, 4, 'qwe', 2, 1),
180(200, 'Sladica', 89380512299, 4, 'qwe', 2, 1),
181(201, 'Sladica', 89380512299, 4, 'qwe', 2, 1),
182(202, 'Sladica', 89380512299, 4, 'qwe', 2, 1),
183(203, 'Sladica', 89380512299, 4, 'qwe', 2, 1),
184(204, 'Sladica', 89380512299, 4, 'qwe', 2, 1),
185(205, 'Sladica', 89380512299, 4, 'qwe', 2, 1),
186(206, 'sladica1', 89380512299, 4, '12', 2, 1),
187(207, 'sladica1', 89380512299, 4, '12', 2, 1),
188(208, 'sladica1', 89380512299, 4, '12', 2, 1),
189(209, 'sladica1', 89380512299, 4, '12', 2, 1),
190(210, 'sladica1', 89380512299, 4, '12', 2, 1),
191(211, 'sladica1', 89380512299, 4, '12', 2, 1),
192(212, 'sladica1', 89380512299, 4, '12', 2, 1),
193(213, '123', 89380512299, 3, '123', 1, 1),
194(214, '12', 89380512299, 3, '12', 1, 0),
195(215, '12', 89380512299, 3, '12', 1, 0),
196(216, '123', 89380512299, 3, '23', 123, 0),
197(217, '12', 89380512299, 1, '123', 12, 1),
198(218, '123', 89380512299, 2, '123', 12, 1),
199(219, '123', 89380512299, 3, '123::123', 1, 1),
200(220, '1123', 89380512299, 4, '123', 12, 1),
201(221, '12', 89380512299, 3, '123', 1, 1),
202(222, '123', 89380512299, 3, '12', 12, 1);
203
204-- --------------------------------------------------------
205
206--
207-- Table structure for table `jedilnik_tip`
208--
209
210CREATE TABLE IF NOT EXISTS `jedilnik_tip` (
211 `id` int(11) NOT NULL,
212 `naziv` varchar(32) NOT NULL,
213 `ico` varchar(64) NOT NULL,
214 PRIMARY KEY (`id`)
215) ENGINE=InnoDB DEFAULT CHARSET=latin1;
216
217--
218-- Dumping data for table `jedilnik_tip`
219--
220
221INSERT INTO `jedilnik_tip` (`id`, `naziv`, `ico`) VALUES
222(1, 'Mesni', 'mesni'),
223(2, 'Vege', 'vege'),
224(3, 'Ribe', 'ribe'),
225(4, 'Hitra hrana', 'hitra_hrana'),
226(5, 'Pizza', 'pizza'),
227(6, 'Testenine', 'testenine'),
228(7, 'Burger', 'burger'),
229(8, 'Juhe', 'juhe'),
230(9, 'Sladice', 'sladice');
231
232-- --------------------------------------------------------
233
234--
235-- Table structure for table `lokal`
236--
237
238CREATE TABLE IF NOT EXISTS `lokal` (
239 `id` bigint(11) NOT NULL,
240 `active` tinyint(1) NOT NULL DEFAULT '1',
241 `naziv` varchar(32) COLLATE utf16_slovenian_ci NOT NULL,
242 `lastnik` varchar(32) COLLATE utf16_slovenian_ci NOT NULL,
243 `naslov` varchar(48) COLLATE utf16_slovenian_ci NOT NULL,
244 `coord` text COLLATE utf16_slovenian_ci NOT NULL,
245 `kraj` varchar(20) COLLATE utf16_slovenian_ci NOT NULL,
246 `regija` int(11) DEFAULT '0',
247 `telefon` varchar(14) CHARACTER SET latin1 NOT NULL,
248 `email` varchar(32) CHARACTER SET latin1 DEFAULT NULL,
249 `geslo` text CHARACTER SET utf32 COLLATE utf32_slovenian_ci NOT NULL,
250 `salt` text CHARACTER SET latin1 NOT NULL,
251 `odprto_teden_zacetek` varchar(8) CHARACTER SET latin1 NOT NULL,
252 `odprto_teden_konec` varchar(8) CHARACTER SET latin1 NOT NULL,
253 `odprto_sobota_zacetek` varchar(8) CHARACTER SET latin1 NOT NULL,
254 `odprto_sobota_konec` varchar(8) CHARACTER SET latin1 NOT NULL,
255 `odprto_nedelja_zacetek` varchar(8) CHARACTER SET latin1 NOT NULL,
256 `odprto_nedelja_konec` varchar(8) CHARACTER SET latin1 NOT NULL,
257 `datum_registracije` datetime NOT NULL,
258 `dostava` tinyint(1) NOT NULL,
259 `boni` tinyint(1) NOT NULL,
260 `dostava_vikend` tinyint(1) NOT NULL,
261 `vege` tinyint(1) NOT NULL,
262 `kosila` tinyint(1) NOT NULL,
263 `img` varchar(128) COLLATE utf16_slovenian_ci DEFAULT NULL,
264 `placilo_gotovina` tinyint(1) NOT NULL,
265 `placilo_kartica` tinyint(1) NOT NULL,
266 `placilo_moneta` tinyint(1) NOT NULL,
267 PRIMARY KEY (`id`),
268 KEY `regija` (`regija`),
269 KEY `regija_2` (`regija`)
270) ENGINE=InnoDB DEFAULT CHARSET=utf16 COLLATE=utf16_slovenian_ci;
271
272--
273-- Dumping data for table `lokal`
274--
275
276INSERT INTO `lokal` (`id`, `active`, `naziv`, `lastnik`, `naslov`, `coord`, `kraj`, `regija`, `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
277(18936454639, 1, 'Back Werk', 'null', 'Slovenska cesta 52', '46.16110560000001,14.5701338', 'Ljubljana', NULL, '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),
278(20934442485, 1, 'Astoria City Cusine', 'null', 'Slovenska ulica 2', '46.56182708029149,15.6492523802915', 'Maribor', NULL, '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),
279(21061265696, 1, 'Taverna Sicilia', 'Taverna Sicilia', 'Ulica Heroja Nandeta 31', '46.5326581,15.673326', 'Maribor', 2, '024260315', 'taverna@gmail.com', 'ada74449655cc03710ed3e0f6ae2b70570c608806e0c8e29f7b61f5037cc1601', '95349182653758480', '00:00', '24:00', '00:00', '24:00', '00:00', '24:00', '2016-09-23 14:09:00', 1, 1, 1, 1, 1, 'bee7e9f300fb84fa929e9cfd82717d90.jpg', 1, 1, 1),
280(35358669632, 1, 'Gurmanski hram', 'Gurmanski hram', 'Zagrebška cesta 92', '46.5264909,15.6688336', 'Maribor', 2, '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, 'ap.jpg', 1, 0, 0),
281(52927503148, 1, 'ApaÄi', 'ApaÄi', 'Pohorska cesta 17b', '46.5396075802915,15.6074563802915', 'Slovenj Gradec', 5, '031223444', '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, 'chef.png', 0, 0, 0),
282(66328866021, 1, 'AROMA, restavracija in pizzerija', 'null', 'Ribji trg 2', '', 'Ljubljana', NULL, '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),
283(82386710868, 1, 'AL Pachino', 'AL Pachino', 'Gosposvetska cesta 87', '46.5637327,15.6253737', 'Maribor', NULL, '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, 'c40a3b6654bf165b653d3013dbee6ac9.JPG', 0, 0, 0),
284(84189335439, 1, 'Bohor d.o.o.', 'Bohor d.o.o.', 'KidriÄeva ulica 23', '', 'RogaÅ¡ka Slatina', NULL, '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);
285
286-- --------------------------------------------------------
287
288--
289-- Table structure for table `lokal_nagrada`
290--
291
292CREATE TABLE IF NOT EXISTS `lokal_nagrada` (
293 `id` int(11) NOT NULL AUTO_INCREMENT,
294 `fk_lokal_id` bigint(20) NOT NULL,
295 `fk_nagrada_id` int(11) NOT NULL,
296 `datum_prejema` datetime NOT NULL,
297 PRIMARY KEY (`id`),
298 KEY `fk_lokal_id` (`fk_lokal_id`,`fk_nagrada_id`),
299 KEY `fk_lokal_id_2` (`fk_lokal_id`),
300 KEY `fk_nagrada_id` (`fk_nagrada_id`)
301) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=20 ;
302
303--
304-- Dumping data for table `lokal_nagrada`
305--
306
307INSERT INTO `lokal_nagrada` (`id`, `fk_lokal_id`, `fk_nagrada_id`, `datum_prejema`) VALUES
308(1, 21061265696, 2, '2016-10-01 14:18:00'),
309(2, 21061265696, 3, '2016-10-01 14:40:00'),
310(3, 21061265696, 1, '2016-10-19 23:23:00'),
311(4, 21061265696, 2, '2016-10-19 23:39:00'),
312(5, 21061265696, 1, '2016-10-20 17:28:00'),
313(6, 21061265696, 2, '2016-10-20 18:48:00'),
314(7, 21061265696, 1, '2016-10-22 23:01:00'),
315(8, 21061265696, 1, '2016-10-22 23:02:00'),
316(9, 21061265696, 1, '2016-10-22 23:02:00'),
317(10, 21061265696, 1, '2016-10-22 23:03:00'),
318(11, 21061265696, 1, '2016-10-22 23:03:00'),
319(12, 21061265696, 1, '2016-10-22 23:03:00'),
320(13, 21061265696, 1, '2016-10-22 23:04:00'),
321(14, 21061265696, 1, '2016-10-22 23:06:00'),
322(15, 21061265696, 1, '2016-10-26 23:54:00'),
323(16, 21061265696, 3, '2016-11-19 18:42:00'),
324(17, 21061265696, 3, '2016-11-20 00:22:00'),
325(18, 21061265696, 1, '2016-12-06 23:25:00'),
326(19, 21061265696, 1, '2016-12-06 23:27:00');
327
328-- --------------------------------------------------------
329
330--
331-- Table structure for table `nacin_placila`
332--
333
334CREATE TABLE IF NOT EXISTS `nacin_placila` (
335 `id` int(11) NOT NULL AUTO_INCREMENT,
336 `naziv` varchar(32) NOT NULL,
337 PRIMARY KEY (`id`)
338) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;
339
340--
341-- Dumping data for table `nacin_placila`
342--
343
344INSERT INTO `nacin_placila` (`id`, `naziv`) VALUES
345(1, 'Gotovina'),
346(2, 'Kartica'),
347(3, 'Moneta');
348
349-- --------------------------------------------------------
350
351--
352-- Table structure for table `nagrada`
353--
354
355CREATE TABLE IF NOT EXISTS `nagrada` (
356 `id` int(11) NOT NULL AUTO_INCREMENT,
357 `naziv` varchar(64) COLLATE utf8_slovenian_ci NOT NULL,
358 `ico` varchar(64) COLLATE utf8_slovenian_ci DEFAULT NULL,
359 PRIMARY KEY (`id`)
360) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_slovenian_ci AUTO_INCREMENT=6 ;
361
362--
363-- Dumping data for table `nagrada`
364--
365
366INSERT INTO `nagrada` (`id`, `naziv`, `ico`) VALUES
367(1, 'Prvo naroÄilo', '179250'),
368(2, 'Pet naroÄil', '179251'),
369(3, 'Deset naroÄil', '179249'),
370(4, 'Sto naroÄil', '214282'),
371(5, 'TisoÄ naroÄil', '214321');
372
373-- --------------------------------------------------------
374
375--
376-- Table structure for table `narocilo`
377--
378
379CREATE TABLE IF NOT EXISTS `narocilo` (
380 `id` bigint(20) NOT NULL,
381 `fk_uporabnik_id` bigint(20) NOT NULL,
382 `fk_jedilnik_meni_id` int(11) DEFAULT NULL,
383 `fk_lokal_id` bigint(20) NOT NULL,
384 `bon` tinyint(1) NOT NULL,
385 `naslov` varchar(64) CHARACTER SET utf8 COLLATE utf8_slovenian_ci NOT NULL,
386 `kraj` varchar(64) CHARACTER SET utf8 COLLATE utf8_slovenian_ci NOT NULL,
387 `telefon` varchar(64) NOT NULL,
388 `cena` double NOT NULL,
389 `komentar` text CHARACTER SET utf8 COLLATE utf8_slovenian_ci NOT NULL,
390 `datum_narocila` datetime NOT NULL,
391 `datum_sprejema` datetime DEFAULT NULL,
392 `koncano` tinyint(1) NOT NULL DEFAULT '0',
393 `predviden_cas_dostave` varchar(6) NOT NULL DEFAULT '00:00',
394 `fk_nacin_placila` int(11) DEFAULT '1',
395 `zavrnjeno` tinyint(1) NOT NULL DEFAULT '0',
396 `stanje` int(11) NOT NULL DEFAULT '0',
397 PRIMARY KEY (`id`),
398 KEY `fk_uporabnik_id` (`fk_uporabnik_id`),
399 KEY `fk_lokal_id` (`fk_lokal_id`),
400 KEY `fk_jedilnik_meni_id` (`fk_jedilnik_meni_id`),
401 KEY `fk_nacin_placila` (`fk_nacin_placila`)
402) ENGINE=InnoDB DEFAULT CHARSET=latin1;
403
404--
405-- Dumping data for table `narocilo`
406--
407
408INSERT 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`, `stanje`) VALUES
409(38158866588, 86891762479, 175, 21061265696, 1, 'Ribiška 12', 'Maribor', '031000000', 3.66, '', '2016-12-06 23:27:00', NULL, 0, '00:00', 1, 0, 0),
410(62842181687, 86891762479, 174, 21061265696, 1, 'Ribiška 12', 'Maribor', '031000000', 3.66, '', '2016-12-06 23:27:00', '2016-12-07 13:58:00', 1, '01:01', 1, 0, 0),
411(90232558153, 86891762479, 176, 21061265696, 1, 'Ribiška 12', 'Maribor', '031000000', 3.66, '', '2016-12-06 23:27:00', NULL, 0, '00:00', 1, 0, 0);
412
413-- --------------------------------------------------------
414
415--
416-- Table structure for table `narocilo_feedback`
417--
418
419CREATE TABLE IF NOT EXISTS `narocilo_feedback` (
420 `id` int(11) NOT NULL AUTO_INCREMENT,
421 `fk_uporabnik_id` bigint(20) NOT NULL,
422 `fk_narocilo_id` bigint(20) DEFAULT NULL,
423 `fk_lokal_id` bigint(20) NOT NULL,
424 `ocena` int(11) NOT NULL,
425 `mnenje` text NOT NULL,
426 PRIMARY KEY (`id`),
427 KEY `fk_lokal_id` (`fk_lokal_id`),
428 KEY `fk_uporabnik_id` (`fk_uporabnik_id`),
429 KEY `fk_narocilo_id` (`fk_narocilo_id`)
430) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=24 ;
431
432--
433-- Dumping data for table `narocilo_feedback`
434--
435
436INSERT INTO `narocilo_feedback` (`id`, `fk_uporabnik_id`, `fk_narocilo_id`, `fk_lokal_id`, `ocena`, `mnenje`) VALUES
437(16, 86891762479, NULL, 82386710868, 4, '123'),
438(17, 86891762479, NULL, 21061265696, 5, 'dobro'),
439(18, 86891762479, NULL, 21061265696, 5, 'ok'),
440(19, 86891762479, NULL, 21061265696, 5, ''),
441(20, 86891762479, NULL, 21061265696, 5, ''),
442(21, 86891762479, NULL, 21061265696, 1, ''),
443(22, 86891762479, NULL, 21061265696, 3, '123'),
444(23, 86891762479, NULL, 21061265696, 4, 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Fusce ultricies tellus pretium, euismod velit et, dignissim nulla. Mauris in consectetur orci. Class aptent taciti sociosqu ad litora torquent per conubia nostra, per inceptos himenaeos. Phasellus gravida feugiat ligula id dictum. In condimentum mattis aliquam. Interdum et malesuada fames ac ante ipsum primis in faucibus. Duis congue non risus a hendrerit. Vivamus vulputate sed felis nec varius. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Cras lobortis varius cursus. Etiam mauris elit, facilisis et vehicula quis, ullamcorper in metus. Donec feugiat tincidunt lectus sit amet molestie. Vivamus nunc ex, pellentesque commodo arcu et, fringilla posuere odio. Phasellus at nisi at mi pellentesque fringilla ut ut magna. Curabitur mi ex, interdum eu diam congue, luctus eleifend est. Class aptent taciti sociosqu ad litora torquent per conubia nostra, per inceptos himenaeos.');
445
446-- --------------------------------------------------------
447
448--
449-- Table structure for table `notification`
450--
451
452CREATE TABLE IF NOT EXISTS `notification` (
453 `id` int(11) NOT NULL AUTO_INCREMENT,
454 `fk_uporabnik_id` bigint(20) DEFAULT NULL,
455 `fk_lokal_id` bigint(20) DEFAULT NULL,
456 `fk_notification_id` int(11) NOT NULL DEFAULT '1',
457 `text` text COLLATE utf8_slovenian_ci NOT NULL,
458 `prebrano` tinyint(1) NOT NULL DEFAULT '0',
459 `datum` datetime NOT NULL,
460 PRIMARY KEY (`id`),
461 KEY `fk_uporabnik_id` (`fk_uporabnik_id`,`fk_notification_id`),
462 KEY `fk_lokal_id` (`fk_lokal_id`),
463 KEY `fk_notification_id` (`fk_notification_id`)
464) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_slovenian_ci AUTO_INCREMENT=194 ;
465
466--
467-- Dumping data for table `notification`
468--
469
470INSERT INTO `notification` (`id`, `fk_uporabnik_id`, `fk_lokal_id`, `fk_notification_id`, `text`, `prebrano`, `datum`) VALUES
471(8, 86891762479, NULL, 1, 'NaroÄilo je bilo potrjeno! [[lokal:21061265696,narocilo:89105189737]]', 1, '2016-10-02 12:56:00'),
472(16, NULL, 21061265696, 1, 'Novo naroÄilo! - Odpri za ogled [[narocilo:80505641138]]', 1, '2016-10-02 14:58:00'),
473(17, NULL, 21061265696, 1, 'Novo naroÄilo! - Odpri za ogled [[narocilo:20764065564]]', 1, '2016-10-02 14:58:00'),
474(20, NULL, 21061265696, 1, 'Novo naroÄilo! - Odpri za ogled [[narocilo:38626989198]]', 1, '2016-10-02 14:58:00'),
475(26, 86891762479, NULL, 1, 'NaroÄilo je bilo potrjeno! [[lokal:21061265696,narocilo:34243714175]]', 1, '2016-10-02 15:00:00'),
476(27, 86891762479, NULL, 1, 'NaroÄilo je bilo zavrnjeno! [[lokal:21061265696,narocilo:66335587347]]', 1, '2016-10-02 15:01:00'),
477(28, 86891762479, NULL, 1, 'NaroÄilo je bilo potrjeno! [[lokal:21061265696,narocilo:53258599783]]', 1, '2016-10-02 16:17:00'),
478(29, 86891762479, NULL, 1, 'NaroÄilo je bilo potrjeno! [[lokal:21061265696,narocilo:50580618518]]', 1, '2016-10-02 17:35:00'),
479(30, NULL, 21061265696, 1, 'Novo naroÄilo! - Odpri za ogled [[narocilo:74584008685]]', 0, '2016-10-02 18:44:00'),
480(31, NULL, 21061265696, 1, 'Novo naroÄilo! - Odpri za ogled [[narocilo:19898273093]]', 0, '2016-10-02 18:44:00'),
481(32, NULL, 21061265696, 1, 'Novo naroÄilo! - Odpri za ogled [[narocilo:84853657227]]', 0, '2016-10-02 18:50:00'),
482(33, NULL, 21061265696, 1, 'Novo naroÄilo! - Odpri za ogled [[narocilo:11874175296]]', 1, '2016-10-02 18:51:00'),
483(34, NULL, 21061265696, 1, 'Novo naroÄilo! - Odpri za ogled [[narocilo:43572457320]]', 0, '2016-10-02 18:51:00'),
484(35, NULL, 21061265696, 1, 'Novo naroÄilo! - Odpri za ogled [[narocilo:68146521681]]', 1, '2016-10-02 18:52:00'),
485(36, NULL, 21061265696, 1, 'Novo naroÄilo! - Odpri za ogled [[narocilo:18770331036]]', 1, '2016-10-02 18:52:00'),
486(37, NULL, 21061265696, 1, 'Novo naroÄilo! - Odpri za ogled [[narocilo:08823732167]]', 1, '2016-10-02 18:52:00'),
487(38, NULL, 21061265696, 1, 'Novo naroÄilo! - Odpri za ogled [[narocilo:59876134750]]', 1, '2016-10-02 18:53:00'),
488(39, 86891762479, NULL, 1, 'NaroÄilo je bilo potrjeno! [[lokal:21061265696,narocilo:11874175296]]', 1, '2016-10-02 22:40:00'),
489(40, 86891762479, NULL, 1, 'NaroÄilo je bilo potrjeno! [[lokal:21061265696,narocilo:43572457320]]', 1, '2016-10-02 22:40:00'),
490(41, NULL, 21061265696, 1, 'Novo naroÄilo! - Odpri za ogled [[narocilo:06984388336]]', 1, '2016-10-03 00:07:00'),
491(42, NULL, 21061265696, 1, 'Novo naroÄilo! - Odpri za ogled [[narocilo:21853617921]]', 1, '2016-10-03 15:43:00'),
492(43, NULL, 21061265696, 1, 'Novo naroÄilo! - Odpri za ogled [[narocilo:81303587464]]', 1, '2016-10-03 19:47:00'),
493(44, NULL, 21061265696, 1, 'Novo naroÄilo! - Odpri za ogled [[narocilo:68260553202]]', 1, '2016-10-03 19:47:00'),
494(45, NULL, 21061265696, 1, 'Novo naroÄilo! - Odpri za ogled [[narocilo:83246618353]]', 1, '2016-10-06 16:59:00'),
495(46, NULL, 21061265696, 1, 'Novo naroÄilo! - Odpri za ogled [[narocilo:89358261806]]', 1, '2016-10-06 16:59:00'),
496(47, NULL, 21061265696, 1, 'Novo naroÄilo! - Odpri za ogled [[narocilo:38486380195]]', 1, '2016-10-07 17:24:00'),
497(48, NULL, 21061265696, 1, 'Novo naroÄilo! - Odpri za ogled [[narocilo:51255928866]]', 1, '2016-10-07 17:25:00'),
498(49, 86891762479, NULL, 1, 'NaroÄilo je bilo potrjeno! [[lokal:21061265696,narocilo:51255928866]]', 1, '2016-10-07 17:26:00'),
499(50, 86891762479, NULL, 1, 'NaroÄilo je bilo potrjeno! [[lokal:21061265696,narocilo:89358261806]]', 1, '2016-10-10 13:17:00'),
500(51, 86891762479, NULL, 1, 'NaroÄilo je bilo potrjeno! [[lokal:21061265696,narocilo:83246618353]]', 1, '2016-10-10 13:47:00'),
501(52, 60644838130, NULL, 1, 'NaroÄilo je bilo potrjeno! [[lokal:21061265696,narocilo:81303587464]]', 0, '2016-10-10 13:47:00'),
502(53, 60644838130, NULL, 1, 'NaroÄilo je bilo potrjeno! [[lokal:21061265696,narocilo:68260553202]]', 0, '2016-10-10 13:47:00'),
503(54, 86891762479, NULL, 1, 'NaroÄilo je bilo potrjeno! [[lokal:21061265696,narocilo:84853657227]]', 1, '2016-10-10 13:48:00'),
504(55, 86891762479, NULL, 1, 'NaroÄilo je bilo potrjeno! [[lokal:21061265696,narocilo:19898273093]]', 1, '2016-10-10 16:28:00'),
505(56, 86891762479, NULL, 1, 'NaroÄilo je bilo potrjeno! [[lokal:21061265696,narocilo:74584008685]]', 1, '2016-10-10 16:40:00'),
506(57, 86891762479, NULL, 1, 'NaroÄilo je bilo potrjeno! [[lokal:21061265696,narocilo:20764065564]]', 1, '2016-10-10 16:45:00'),
507(58, 86891762479, NULL, 1, 'NaroÄilo je bilo potrjeno! [[lokal:21061265696,narocilo:84045438295]]', 1, '2016-10-10 16:46:00'),
508(59, 86891762479, NULL, 1, 'NaroÄilo je bilo potrjeno! [[lokal:21061265696,narocilo:70863331434]]', 1, '2016-10-10 16:53:00'),
509(60, 86891762479, NULL, 1, 'NaroÄilo je bilo potrjeno! [[lokal:21061265696,narocilo:90778191479]]', 1, '2016-10-10 17:45:00'),
510(61, 86891762479, NULL, 1, 'NaroÄilo je bilo potrjeno! [[lokal:21061265696,narocilo:38626989198]]', 1, '2016-10-10 17:47:00'),
511(62, 86891762479, NULL, 1, 'NaroÄilo je bilo potrjeno! [[lokal:21061265696,narocilo:80505641138]]', 1, '2016-10-10 18:11:00'),
512(63, 86891762479, NULL, 1, 'NaroÄilo je bilo potrjeno! [[lokal:21061265696,narocilo:88538012641]]', 1, '2016-10-10 18:12:00'),
513(64, 86891762479, NULL, 1, 'NaroÄilo je bilo potrjeno! [[lokal:21061265696,narocilo:68838786798]]', 1, '2016-10-10 18:12:00'),
514(65, 86891762479, NULL, 1, 'NaroÄilo je bilo potrjeno! [[lokal:21061265696,narocilo:56142478840]]', 1, '2016-10-10 18:12:00'),
515(66, 86891762479, NULL, 1, 'NaroÄilo je bilo potrjeno! [[lokal:21061265696,narocilo:50427207039]]', 1, '2016-10-10 18:20:00'),
516(67, NULL, 21061265696, 1, 'Novo naroÄilo! - Odpri za ogled [[narocilo:86300181022]]', 0, '2016-10-18 00:50:00'),
517(68, NULL, 21061265696, 1, 'Novo naroÄilo! - Odpri za ogled [[narocilo:83683953856]]', 0, '2016-10-18 00:50:00'),
518(69, NULL, 21061265696, 1, 'Novo naroÄilo! - Odpri za ogled [[narocilo:18221159726]]', 0, '2016-10-18 00:51:00'),
519(70, NULL, 21061265696, 1, 'Novo naroÄilo! - Odpri za ogled [[narocilo:16204249949]]', 0, '2016-10-18 00:52:00'),
520(71, NULL, 21061265696, 1, 'Novo naroÄilo! - Odpri za ogled [[narocilo:86519530731]]', 0, '2016-10-18 00:52:00'),
521(72, NULL, 21061265696, 1, 'Novo naroÄilo! - Odpri za ogled [[narocilo:03492340985]]', 0, '2016-10-18 00:52:00'),
522(73, 86891762479, NULL, 1, 'NaroÄilo je bilo potrjeno! [[lokal:21061265696,narocilo:16204249949]]', 1, '2016-10-18 00:54:00'),
523(74, NULL, 21061265696, 1, 'Novo naroÄilo! - Odpri za ogled [[narocilo:28640573896]]', 0, '2016-10-18 15:54:00'),
524(75, NULL, 21061265696, 1, 'Novo naroÄilo! - Odpri za ogled [[narocilo:39210968528]]', 0, '2016-10-18 16:01:00'),
525(76, NULL, 21061265696, 1, 'Novo naroÄilo! - Odpri za ogled [[narocilo:85431970158]]', 0, '2016-10-18 16:04:00'),
526(77, NULL, 21061265696, 1, 'Novo naroÄilo! - Odpri za ogled [[narocilo:12215282681]]', 0, '2016-10-18 16:04:00'),
527(78, NULL, 21061265696, 1, 'Novo naroÄilo! - Odpri za ogled [[narocilo:21700555852]]', 0, '2016-10-18 16:05:00'),
528(79, NULL, 21061265696, 1, 'Novo naroÄilo! - Odpri za ogled [[narocilo:12629566747]]', 0, '2016-10-18 16:05:00'),
529(80, NULL, 21061265696, 1, 'Novo naroÄilo! - Odpri za ogled [[narocilo:84186645845]]', 0, '2016-10-18 16:07:00'),
530(81, NULL, 21061265696, 1, 'Novo naroÄilo! - Odpri za ogled [[narocilo:30598982651]]', 0, '2016-10-18 16:09:00'),
531(82, NULL, 21061265696, 1, 'Novo naroÄilo! - Odpri za ogled [[narocilo:82241593871]]', 0, '2016-10-18 16:09:00'),
532(83, NULL, 21061265696, 1, 'Novo naroÄilo! - Odpri za ogled [[narocilo:80788586069]]', 0, '2016-10-18 16:09:00'),
533(84, NULL, 21061265696, 1, 'Novo naroÄilo! - Odpri za ogled [[narocilo:22843650854]]', 0, '2016-10-18 16:10:00'),
534(85, NULL, 21061265696, 1, 'Novo naroÄilo! - Odpri za ogled [[narocilo:20278130048]]', 0, '2016-10-18 16:10:00'),
535(86, NULL, 21061265696, 1, 'Novo naroÄilo! - Odpri za ogled [[narocilo:88035540594]]', 0, '2016-10-18 16:10:00'),
536(87, NULL, 21061265696, 1, 'Novo naroÄilo! - Odpri za ogled [[narocilo:45567788286]]', 0, '2016-10-18 16:17:00'),
537(88, NULL, 21061265696, 1, 'Novo naroÄilo! - Odpri za ogled [[narocilo:74141728604]]', 0, '2016-10-18 16:19:00'),
538(89, NULL, 21061265696, 1, 'Novo naroÄilo! - Odpri za ogled [[narocilo:30346044349]]', 0, '2016-10-18 16:20:00'),
539(90, NULL, 21061265696, 1, 'Novo naroÄilo! - Odpri za ogled [[narocilo:18718184143]]', 0, '2016-10-18 16:20:00'),
540(91, NULL, 21061265696, 1, 'Novo naroÄilo! - Odpri za ogled [[narocilo:94504287782]]', 0, '2016-10-18 16:20:00'),
541(92, NULL, 21061265696, 1, 'Novo naroÄilo! - Odpri za ogled [[narocilo:96105110286]]', 0, '2016-10-18 16:20:00'),
542(93, NULL, 21061265696, 1, 'Novo naroÄilo! - Odpri za ogled [[narocilo:76977693578]]', 0, '2016-10-18 16:20:00'),
543(94, NULL, 21061265696, 1, 'Novo naroÄilo! - Odpri za ogled [[narocilo:59851368258]]', 0, '2016-10-18 16:25:00'),
544(95, NULL, 21061265696, 1, 'Novo naroÄilo! - Odpri za ogled [[narocilo:37882719188]]', 0, '2016-10-18 16:25:00'),
545(96, NULL, 21061265696, 1, 'Novo naroÄilo! - Odpri za ogled [[narocilo:23845486729]]', 0, '2016-10-18 17:45:00'),
546(97, NULL, 21061265696, 1, 'Novo naroÄilo! - Odpri za ogled [[narocilo:17886746361]]', 0, '2016-10-18 17:45:00'),
547(98, NULL, 21061265696, 1, 'Novo naroÄilo! - Odpri za ogled [[narocilo:43644107661]]', 0, '2016-10-19 19:00:00'),
548(99, NULL, 21061265696, 1, 'Novo naroÄilo! - Odpri za ogled [[narocilo:10381131782]]', 0, '2016-10-19 23:23:00'),
549(100, 86891762479, NULL, 1, 'NaroÄilo je bilo potrjeno! [[lokal:21061265696,narocilo:10381131782]]', 1, '2016-10-19 23:31:00'),
550(101, NULL, 21061265696, 1, 'Novo naroÄilo! - Odpri za ogled [[narocilo:98613847168]]', 0, '2016-10-19 23:34:00'),
551(102, 86891762479, NULL, 1, 'NaroÄilo je bilo potrjeno! [[lokal:21061265696,narocilo:98613847168]]', 1, '2016-10-19 23:35:00'),
552(103, NULL, 21061265696, 1, 'Novo naroÄilo! - Odpri za ogled [[narocilo:63259454303]]', 0, '2016-10-19 23:35:00'),
553(104, 86891762479, NULL, 1, 'NaroÄilo je bilo potrjeno! [[lokal:21061265696,narocilo:63259454303]]', 1, '2016-10-19 23:36:00'),
554(105, NULL, 21061265696, 1, 'Novo naroÄilo! - Odpri za ogled [[narocilo:27139080072]]', 0, '2016-10-19 23:37:00'),
555(106, 86891762479, NULL, 1, 'NaroÄilo je bilo potrjeno! [[lokal:21061265696,narocilo:27139080072]]', 1, '2016-10-19 23:39:00'),
556(107, NULL, 21061265696, 1, 'Novo naroÄilo! - Odpri za ogled [[narocilo:64487386479]]', 0, '2016-10-19 23:39:00'),
557(108, 86891762479, NULL, 1, 'NaroÄilo je bilo potrjeno! [[lokal:21061265696,narocilo:64487386479]]', 1, '2016-10-19 23:40:00'),
558(109, NULL, 21061265696, 1, 'Novo naroÄilo! - Odpri za ogled [[narocilo:94288827892]]', 0, '2016-10-19 23:40:00'),
559(110, 86891762479, NULL, 1, 'NaroÄilo je bilo potrjeno! [[lokal:21061265696,narocilo:94288827892]]', 1, '2016-10-19 23:42:00'),
560(111, NULL, 21061265696, 1, 'Novo naroÄilo! - Odpri za ogled [[narocilo:84598564028]]', 0, '2016-10-19 23:44:00'),
561(112, NULL, 21061265696, 1, 'Novo naroÄilo! - Odpri za ogled [[narocilo:35885809401]]', 0, '2016-10-19 23:45:00'),
562(113, 86891762479, NULL, 1, 'NaroÄilo je bilo zavrnjeno! [[lokal:21061265696,narocilo:84598564028]]', 1, '2016-10-20 17:27:00'),
563(114, NULL, 21061265696, 1, 'Novo naroÄilo! - Odpri za ogled [[narocilo:10538995620]]', 0, '2016-10-20 17:28:00'),
564(115, 86891762479, NULL, 1, 'NaroÄilo je bilo zavrnjeno! [[lokal:21061265696,narocilo:10538995620]]', 1, '2016-10-20 17:28:00'),
565(116, NULL, 21061265696, 1, 'Novo naroÄilo! - Odpri za ogled [[narocilo:29180371699]]', 0, '2016-10-20 17:37:00'),
566(117, 86891762479, NULL, 1, 'NaroÄilo je bilo zavrnjeno! [[lokal:21061265696,narocilo:29180371699]]', 1, '2016-10-20 17:38:00'),
567(118, NULL, 21061265696, 1, 'Novo naroÄilo! - Odpri za ogled [[narocilo:76520411829]]', 0, '2016-10-20 17:39:00'),
568(119, 86891762479, NULL, 1, 'NaroÄilo je bilo potrjeno! [[lokal:21061265696,narocilo:76520411829]]', 1, '2016-10-20 17:40:00'),
569(120, NULL, 21061265696, 1, 'Novo naroÄilo! - Odpri za ogled [[narocilo:34084831780]]', 0, '2016-10-20 17:48:00'),
570(121, 86891762479, NULL, 1, 'NaroÄilo je bilo zavrnjeno! [[lokal:21061265696,narocilo:34084831780]]', 1, '2016-10-20 17:48:00'),
571(122, NULL, 21061265696, 1, 'Novo naroÄilo! - Odpri za ogled [[narocilo:87672920324]]', 0, '2016-10-20 18:48:00'),
572(123, 86891762479, NULL, 1, 'NaroÄilo je bilo potrjeno! [[lokal:21061265696,narocilo:87672920324]]', 1, '2016-10-20 18:48:00'),
573(124, NULL, 21061265696, 1, 'Novo naroÄilo! - Odpri za ogled [[narocilo:38930737889]]', 0, '2016-10-21 20:08:00'),
574(125, NULL, 21061265696, 1, 'Novo naroÄilo! - Odpri za ogled [[narocilo:54580387094]]', 0, '2016-10-21 20:08:00'),
575(126, NULL, 21061265696, 1, 'Novo naroÄilo! - Odpri za ogled [[narocilo:72578287568]]', 0, '2016-10-22 12:34:00'),
576(127, NULL, 21061265696, 1, 'Novo naroÄilo! - Odpri za ogled [[narocilo:81978962552]]', 0, '2016-10-22 12:34:00'),
577(128, NULL, 21061265696, 1, 'Novo naroÄilo! - Odpri za ogled [[narocilo:82804268278]]', 0, '2016-10-22 12:34:00'),
578(129, NULL, 21061265696, 1, 'Novo naroÄilo! - Odpri za ogled [[narocilo:62824688239]]', 0, '2016-10-22 12:34:00'),
579(130, NULL, 21061265696, 1, 'Novo naroÄilo! - Odpri za ogled [[narocilo:18753465082]]', 0, '2016-10-22 12:34:00'),
580(131, NULL, 21061265696, 1, 'Novo naroÄilo! - Odpri za ogled [[narocilo:43061700249]]', 0, '2016-10-22 12:34:00'),
581(132, NULL, 21061265696, 1, 'Novo naroÄilo! - Odpri za ogled [[narocilo:95030227540]]', 0, '2016-10-22 13:05:00'),
582(133, NULL, 21061265696, 1, 'Novo naroÄilo! - Odpri za ogled [[narocilo:88288113783]]', 0, '2016-10-22 14:03:00'),
583(134, NULL, 21061265696, 1, 'Novo naroÄilo! - Odpri za ogled [[narocilo:74737443548]]', 0, '2016-10-22 14:03:00'),
584(135, NULL, 21061265696, 1, 'Novo naroÄilo! - Odpri za ogled [[narocilo:88859944357]]', 0, '2016-10-22 14:08:00'),
585(136, NULL, 21061265696, 1, 'Novo naroÄilo! - Odpri za ogled [[narocilo:80830758228]]', 0, '2016-10-22 14:08:00'),
586(137, NULL, 21061265696, 1, 'Novo naroÄilo! - Odpri za ogled [[narocilo:85568338765]]', 0, '2016-10-22 14:09:00'),
587(138, NULL, 21061265696, 1, 'Novo naroÄilo! - Odpri za ogled [[narocilo:46815617888]]', 0, '2016-10-22 14:13:00'),
588(139, NULL, 21061265696, 1, 'Novo naroÄilo! - Odpri za ogled [[narocilo:26375636687]]', 0, '2016-10-22 14:14:00'),
589(140, NULL, 21061265696, 1, 'Novo naroÄilo! - Odpri za ogled [[narocilo:29371803368]]', 0, '2016-10-22 14:14:00'),
590(141, NULL, 21061265696, 1, 'Novo naroÄilo! - Odpri za ogled [[narocilo:29722487822]]', 0, '2016-10-22 14:15:00'),
591(142, NULL, 21061265696, 1, 'Novo naroÄilo! - Odpri za ogled [[narocilo:80381809831]]', 0, '2016-10-22 14:15:00'),
592(143, NULL, 21061265696, 1, 'Novo naroÄilo! - Odpri za ogled [[narocilo:82207885696]]', 0, '2016-10-22 14:15:00'),
593(144, NULL, 21061265696, 1, 'Novo naroÄilo! - Odpri za ogled [[narocilo:81690830458]]', 0, '2016-10-22 15:47:00'),
594(145, NULL, 21061265696, 1, 'Novo naroÄilo! - Odpri za ogled [[narocilo:78894986872]]', 0, '2016-10-22 23:01:00'),
595(146, NULL, 21061265696, 1, 'Novo naroÄilo! - Odpri za ogled [[narocilo:23813698987]]', 0, '2016-10-22 23:02:00'),
596(147, NULL, 21061265696, 1, 'Novo naroÄilo! - Odpri za ogled [[narocilo:58655831877]]', 0, '2016-10-22 23:02:00'),
597(148, NULL, 21061265696, 1, 'Novo naroÄilo! - Odpri za ogled [[narocilo:98688796189]]', 0, '2016-10-22 23:03:00'),
598(149, NULL, 21061265696, 1, 'Novo naroÄilo! - Odpri za ogled [[narocilo:06920888733]]', 0, '2016-10-22 23:03:00'),
599(150, NULL, 21061265696, 1, 'Novo naroÄilo! - Odpri za ogled [[narocilo:28698556864]]', 0, '2016-10-22 23:03:00'),
600(151, NULL, 21061265696, 1, 'Novo naroÄilo! - Odpri za ogled [[narocilo:86205729117]]', 0, '2016-10-22 23:04:00'),
601(152, NULL, 21061265696, 1, 'Novo naroÄilo! - Odpri za ogled [[narocilo:66380669216]]', 0, '2016-10-22 23:06:00'),
602(153, NULL, 21061265696, 1, 'Novo naroÄilo! - Odpri za ogled [[narocilo:56980430528]]', 0, '2016-10-22 23:06:00'),
603(154, NULL, 21061265696, 1, 'Novo naroÄilo! - Odpri za ogled [[narocilo:27947847284]]', 0, '2016-10-22 23:08:00'),
604(155, NULL, 21061265696, 1, 'Novo naroÄilo! - Odpri za ogled [[narocilo:51901339203]]', 0, '2016-10-22 23:12:00'),
605(156, NULL, 21061265696, 1, 'Novo naroÄilo! - Odpri za ogled [[narocilo:10292217307]]', 0, '2016-10-22 23:12:00'),
606(157, NULL, 21061265696, 1, 'Novo naroÄilo! - Odpri za ogled [[narocilo:50328405611]]', 0, '2016-10-22 23:12:00'),
607(158, NULL, 21061265696, 1, 'Novo naroÄilo! - Odpri za ogled [[narocilo:94274026223]]', 0, '2016-10-22 23:12:00'),
608(159, NULL, 21061265696, 1, 'Novo naroÄilo! - Odpri za ogled [[narocilo:81712607151]]', 0, '2016-10-22 23:12:00'),
609(160, NULL, 21061265696, 1, 'Novo naroÄilo! - Odpri za ogled [[narocilo:50068312261]]', 0, '2016-10-22 23:12:00'),
610(161, NULL, 21061265696, 1, 'Novo naroÄilo! - Odpri za ogled [[narocilo:67287987995]]', 0, '2016-10-22 23:12:00'),
611(162, NULL, 21061265696, 1, 'Novo naroÄilo! - Odpri za ogled [[narocilo:52425230774]]', 0, '2016-10-22 23:12:00'),
612(163, NULL, 21061265696, 1, 'Novo naroÄilo! - Odpri za ogled [[narocilo:72264187978]]', 0, '2016-10-22 23:12:00'),
613(164, NULL, 21061265696, 1, 'Novo naroÄilo! - Odpri za ogled [[narocilo:65829865802]]', 0, '2016-10-22 23:12:00'),
614(165, NULL, 21061265696, 1, 'Novo naroÄilo! - Odpri za ogled [[narocilo:80983482162]]', 0, '2016-10-22 23:12:00'),
615(166, NULL, 21061265696, 1, 'Novo naroÄilo! - Odpri za ogled [[narocilo:88846152788]]', 0, '2016-10-22 23:12:00'),
616(167, NULL, 21061265696, 1, 'Novo naroÄilo! - Odpri za ogled [[narocilo:10595625889]]', 0, '2016-10-23 13:39:00'),
617(168, NULL, 21061265696, 1, 'Novo naroÄilo! - Odpri za ogled [[narocilo:45999342951]]', 0, '2016-10-26 23:54:00'),
618(169, NULL, 21061265696, 1, 'Novo naroÄilo! - Odpri za ogled [[narocilo:78950859800]]', 0, '2016-10-26 23:54:00'),
619(170, NULL, 21061265696, 1, 'Novo naroÄilo! - Odpri za ogled [[narocilo:97820031686]]', 0, '2016-10-26 23:54:00'),
620(171, NULL, 21061265696, 1, 'Novo naroÄilo! - Odpri za ogled [[narocilo:52322140013]]', 0, '2016-10-26 23:54:00'),
621(172, NULL, 21061265696, 1, 'Novo naroÄilo! - Odpri za ogled [[narocilo:79408678311]]', 0, '2016-10-26 23:54:00'),
622(173, NULL, 21061265696, 1, 'Novo naroÄilo! - Odpri za ogled [[narocilo:58954939578]]', 0, '2016-10-26 23:54:00'),
623(174, NULL, 21061265696, 1, 'Novo naroÄilo! - Odpri za ogled [[narocilo:30458919043]]', 0, '2016-10-26 23:54:00'),
624(175, NULL, 21061265696, 1, 'Novo naroÄilo! - Odpri za ogled [[narocilo:32481224617]]', 0, '2016-10-26 23:54:00'),
625(176, NULL, 21061265696, 1, 'Novo naroÄilo! - Odpri za ogled [[narocilo:81825926664]]', 0, '2016-10-26 23:54:00'),
626(177, NULL, 21061265696, 1, 'Novo naroÄilo! - Odpri za ogled [[narocilo:14138938880]]', 0, '2016-10-26 23:54:00'),
627(178, NULL, 21061265696, 1, 'Novo naroÄilo! - Odpri za ogled [[narocilo:91807944127]]', 0, '2016-10-26 23:54:00'),
628(179, NULL, 21061265696, 1, 'Novo naroÄilo! - Odpri za ogled [[narocilo:69398404727]]', 0, '2016-10-26 23:54:00'),
629(180, NULL, 21061265696, 1, 'Novo naroÄilo! - Odpri za ogled [[narocilo:78889648902]]', 0, '2016-11-19 18:42:00'),
630(181, NULL, 21061265696, 1, 'Novo naroÄilo! - Odpri za ogled [[narocilo:52007428414]]', 0, '2016-11-20 00:22:00'),
631(182, NULL, 21061265696, 1, 'Novo naroÄilo! - Odpri za ogled [[narocilo:26823334739]]', 0, '2016-11-20 00:22:00'),
632(183, NULL, 21061265696, 1, 'Novo naroÄilo! - Odpri za ogled [[narocilo:96825778527]]', 0, '2016-11-21 11:12:00'),
633(184, 86891762479, NULL, 1, 'NaroÄilo je bilo potrjeno! [[lokal:21061265696,narocilo:96825778527]]', 1, '2016-11-21 11:13:00'),
634(185, 86891762479, NULL, 1, 'NaroÄilo je bilo potrjeno! [[lokal:21061265696,narocilo:52007428414]]', 1, '2016-11-25 00:41:00'),
635(186, NULL, 21061265696, 1, 'Novo naroÄilo! - Odpri za ogled [[narocilo:88178866606]]', 0, '2016-12-06 23:24:00'),
636(187, NULL, 21061265696, 1, 'Novo naroÄilo! - Odpri za ogled [[narocilo:37281590577]]', 0, '2016-12-06 23:25:00'),
637(188, NULL, 21061265696, 1, 'Novo naroÄilo! - Odpri za ogled [[narocilo:80322189821]]', 0, '2016-12-06 23:25:00'),
638(189, NULL, 21061265696, 1, 'Novo naroÄilo! - Odpri za ogled [[narocilo:62842181687]]', 1, '2016-12-06 23:27:00'),
639(190, NULL, 21061265696, 1, 'Novo naroÄilo! - Odpri za ogled [[narocilo:38158866588]]', 0, '2016-12-06 23:27:00'),
640(191, NULL, 21061265696, 1, 'Novo naroÄilo! - Odpri za ogled [[narocilo:90232558153]]', 0, '2016-12-06 23:27:00'),
641(192, NULL, 21061265696, 1, 'Novo naroÄilo! - Odpri za ogled [[narocilo:27348101803]]', 1, '2016-12-06 23:33:00'),
642(193, 86891762479, NULL, 1, 'NaroÄilo je bilo potrjeno! [[lokal:21061265696,narocilo:62842181687]]', 1, '2016-12-07 13:58:00');
643
644-- --------------------------------------------------------
645
646--
647-- Table structure for table `notification_tip`
648--
649
650CREATE TABLE IF NOT EXISTS `notification_tip` (
651 `id` int(11) NOT NULL AUTO_INCREMENT,
652 `naziv` varchar(64) COLLATE utf8_slovenian_ci NOT NULL,
653 PRIMARY KEY (`id`)
654) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_slovenian_ci AUTO_INCREMENT=2 ;
655
656--
657-- Dumping data for table `notification_tip`
658--
659
660INSERT INTO `notification_tip` (`id`, `naziv`) VALUES
661(1, 'Obvestilo');
662
663-- --------------------------------------------------------
664
665--
666-- Table structure for table `ocena`
667--
668
669CREATE TABLE IF NOT EXISTS `ocena` (
670 `id` int(11) NOT NULL AUTO_INCREMENT,
671 `fk_lokal_id` bigint(11) NOT NULL,
672 `fk_uporabnik_id` bigint(11) NOT NULL,
673 `ocena` int(11) NOT NULL,
674 PRIMARY KEY (`id`),
675 KEY `fk_uporabnik_id` (`fk_uporabnik_id`),
676 KEY `fk_lokal_id` (`fk_lokal_id`)
677) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=20 ;
678
679--
680-- Dumping data for table `ocena`
681--
682
683INSERT INTO `ocena` (`id`, `fk_lokal_id`, `fk_uporabnik_id`, `ocena`) VALUES
684(12, 82386710868, 86891762479, 5),
685(13, 52927503148, 86891762479, 3),
686(15, 21061265696, 86891762479, 5),
687(16, 20934442485, 86891762479, 5),
688(17, 21061265696, 86891762479, 1),
689(18, 21061265696, 86891762479, 3),
690(19, 21061265696, 86891762479, 4);
691
692-- --------------------------------------------------------
693
694--
695-- Table structure for table `priljubljeno`
696--
697
698CREATE TABLE IF NOT EXISTS `priljubljeno` (
699 `id` int(11) NOT NULL AUTO_INCREMENT,
700 `fk_uporabnik_id` bigint(20) NOT NULL,
701 `fk_lokal_id` bigint(20) NOT NULL,
702 PRIMARY KEY (`id`),
703 KEY `fk_uporabnik_id` (`fk_uporabnik_id`,`fk_lokal_id`),
704 KEY `fk_lokal_id` (`fk_lokal_id`)
705) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=86 ;
706
707--
708-- Dumping data for table `priljubljeno`
709--
710
711INSERT INTO `priljubljeno` (`id`, `fk_uporabnik_id`, `fk_lokal_id`) VALUES
712(39, 60644838130, 82386710868),
713(85, 86891762479, 21061265696),
714(19, 86891762479, 52927503148),
715(33, 86891762479, 82386710868);
716
717-- --------------------------------------------------------
718
719--
720-- Table structure for table `regije`
721--
722
723CREATE TABLE IF NOT EXISTS `regije` (
724 `id` int(11) NOT NULL,
725 `ime` varchar(32) NOT NULL,
726 PRIMARY KEY (`id`)
727) ENGINE=InnoDB DEFAULT CHARSET=latin1;
728
729--
730-- Dumping data for table `regije`
731--
732
733INSERT INTO `regije` (`id`, `ime`) VALUES
734(0, 'Brez'),
735(1, 'Osrednjeslovenska'),
736(2, 'Podravska'),
737(3, 'Savinjska'),
738(4, 'Goriška'),
739(5, 'Koroška'),
740(6, 'Pomurje'),
741(7, 'Jugovzhodna'),
742(8, 'Zasavska'),
743(9, 'Gorenjska'),
744(10, 'Notranjsko-kraška'),
745(11, 'Obalno-kraška'),
746(12, 'Spodnjeposavska');
747
748-- --------------------------------------------------------
749
750--
751-- Table structure for table `uporabnik`
752--
753
754CREATE TABLE IF NOT EXISTS `uporabnik` (
755 `id` bigint(11) NOT NULL,
756 `email` varchar(32) NOT NULL,
757 `ime` varchar(14) CHARACTER SET utf8 COLLATE utf8_slovenian_ci NOT NULL,
758 `priimek` varchar(20) CHARACTER SET utf8 COLLATE utf8_slovenian_ci NOT NULL,
759 `telefon` varchar(14) NOT NULL,
760 `naslov` varchar(40) CHARACTER SET utf8 COLLATE utf8_slovenian_ci NOT NULL,
761 `kraj` varchar(20) CHARACTER SET utf8 COLLATE utf8_slovenian_ci NOT NULL,
762 `coord` text NOT NULL,
763 `geslo` text CHARACTER SET utf8 COLLATE utf8_slovenian_ci NOT NULL,
764 `salt` text NOT NULL,
765 `ip` varchar(20) NOT NULL,
766 `datum_registracije` datetime NOT NULL,
767 `bon` tinyint(1) NOT NULL,
768 `last_login` datetime NOT NULL,
769 `prikazi_potrditev_hitro` tinyint(1) NOT NULL DEFAULT '1',
770 PRIMARY KEY (`id`)
771) ENGINE=InnoDB DEFAULT CHARSET=latin1;
772
773--
774-- Dumping data for table `uporabnik`
775--
776
777INSERT INTO `uporabnik` (`id`, `email`, `ime`, `priimek`, `telefon`, `naslov`, `kraj`, `coord`, `geslo`, `salt`, `ip`, `datum_registracije`, `bon`, `last_login`, `prikazi_potrditev_hitro`) VALUES
778(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', 1),
779(49475798535, 'jnovak@gmail.com', 'Janez', 'Novak', '031000000', 'Ribiška ulica 7', 'Maribor', '46.5578036,15.6399912', '94e5a51335643e8ae5e52e53a7b84d1ce561e5d210ea1fe9a5005b0839ed862c', '51555347788555878', '::1', '2016-10-07 12:23:00', 1, '2016-10-07 12:23:00', 1),
780(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', 1),
781(60644838130, 'wepqwe@gmail.com', 'weopjr', 'asoijd', '031000000', 'wqweokp', 'qweopk', '', '70a2f9d3e15e2610f1cad7068a03c70fe4cba94563e6739f66ccd1334ff894ee', '04425336146648702', '::1', '2016-10-03 19:45:00', 1, '2016-10-03 19:45:00', 1),
782(78285812078, 'woekew@gmail.com', 'jaz', 'sem', '031000000', 'novak', 'wleowe', '', 'ac816e3b39c0d11aa1648be05e008ae78a0d65594dad410830c5f95ed471de8c', '95682518407447908', '::1', '2016-10-03 19:45:00', 0, '2016-10-03 19:45:00', 1),
783(86891762479, 'tilen1@gmail.com', 'Tilen', 'Priimek', '031000000', 'Ribiška 12', 'Maribor', '46.5575641,15.6397196', '2bac383336519df7129ca77575dad272bfe86ff8547a6841dc1f8e648086654c', '80509632030640054', '::1', '2016-09-10 14:18:00', 1, '2016-12-08 19:00:00', 1);
784
785-- --------------------------------------------------------
786
787--
788-- Table structure for table `uporabnik_nagrada`
789--
790
791CREATE TABLE IF NOT EXISTS `uporabnik_nagrada` (
792 `id` int(11) NOT NULL AUTO_INCREMENT,
793 `fk_uporabnik_id` bigint(20) NOT NULL,
794 `fk_nagrada_id` int(11) NOT NULL,
795 `datum_prejema` datetime NOT NULL,
796 PRIMARY KEY (`id`),
797 KEY `fk_uporabnik_id` (`fk_uporabnik_id`,`fk_nagrada_id`),
798 KEY `fk_uporabnik_id_2` (`fk_uporabnik_id`),
799 KEY `fk_nagrada_id` (`fk_nagrada_id`)
800) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_slovenian_ci AUTO_INCREMENT=21 ;
801
802--
803-- Dumping data for table `uporabnik_nagrada`
804--
805
806INSERT INTO `uporabnik_nagrada` (`id`, `fk_uporabnik_id`, `fk_nagrada_id`, `datum_prejema`) VALUES
807(2, 86891762479, 3, '2016-10-01 14:40:00'),
808(3, 60644838130, 1, '2016-10-03 19:47:00'),
809(4, 86891762479, 1, '2016-10-19 23:23:00'),
810(5, 86891762479, 2, '2016-10-19 23:39:00'),
811(6, 86891762479, 1, '2016-10-20 17:28:00'),
812(7, 86891762479, 2, '2016-10-20 18:48:00'),
813(8, 86891762479, 1, '2016-10-22 23:01:00'),
814(9, 86891762479, 1, '2016-10-22 23:02:00'),
815(10, 86891762479, 1, '2016-10-22 23:02:00'),
816(11, 86891762479, 1, '2016-10-22 23:03:00'),
817(12, 86891762479, 1, '2016-10-22 23:03:00'),
818(13, 86891762479, 1, '2016-10-22 23:03:00'),
819(14, 86891762479, 1, '2016-10-22 23:04:00'),
820(15, 86891762479, 1, '2016-10-22 23:06:00'),
821(16, 86891762479, 1, '2016-10-26 23:54:00'),
822(17, 86891762479, 3, '2016-11-19 18:42:00'),
823(18, 86891762479, 3, '2016-11-20 00:22:00'),
824(19, 86891762479, 1, '2016-12-06 23:25:00'),
825(20, 86891762479, 1, '2016-12-06 23:27:00');
826
827--
828-- Constraints for dumped tables
829--
830
831--
832-- Constraints for table `akcija`
833--
834ALTER TABLE `akcija`
835 ADD CONSTRAINT `akcija_ibfk_1` FOREIGN KEY (`fk_lokal_id`) REFERENCES `lokal` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
836
837--
838-- Constraints for table `feedback`
839--
840ALTER TABLE `feedback`
841 ADD CONSTRAINT `feedback_ibfk_1` FOREIGN KEY (`fk_uporabnik_id`) REFERENCES `uporabnik` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
842 ADD CONSTRAINT `feedback_ibfk_2` FOREIGN KEY (`fk_lokal_id`) REFERENCES `lokal` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
843
844--
845-- Constraints for table `jedilnik`
846--
847ALTER TABLE `jedilnik`
848 ADD CONSTRAINT `jedilnik_ibfk_1` FOREIGN KEY (`fk_lokal_id`) REFERENCES `lokal` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
849
850--
851-- Constraints for table `jedilnik_meni`
852--
853ALTER TABLE `jedilnik_meni`
854 ADD CONSTRAINT `jedilnik_meni_ibfk_1` FOREIGN KEY (`fk_jedilnik_id`) REFERENCES `jedilnik` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
855 ADD CONSTRAINT `jedilnik_meni_ibfk_2` FOREIGN KEY (`fk_jedilnik_tip`) REFERENCES `jedilnik_tip` (`id`) ON DELETE SET NULL ON UPDATE SET NULL;
856
857--
858-- Constraints for table `lokal`
859--
860ALTER TABLE `lokal`
861 ADD CONSTRAINT `lokal_ibfk_1` FOREIGN KEY (`regija`) REFERENCES `regije` (`id`) ON DELETE SET NULL ON UPDATE SET NULL;
862
863--
864-- Constraints for table `lokal_nagrada`
865--
866ALTER TABLE `lokal_nagrada`
867 ADD CONSTRAINT `lokal_nagrada_ibfk_1` FOREIGN KEY (`fk_lokal_id`) REFERENCES `lokal` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
868 ADD CONSTRAINT `lokal_nagrada_ibfk_2` FOREIGN KEY (`fk_nagrada_id`) REFERENCES `nagrada` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
869
870--
871-- Constraints for table `narocilo`
872--
873ALTER TABLE `narocilo`
874 ADD CONSTRAINT `narocilo_ibfk_1` FOREIGN KEY (`fk_lokal_id`) REFERENCES `lokal` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
875 ADD CONSTRAINT `narocilo_ibfk_2` FOREIGN KEY (`fk_uporabnik_id`) REFERENCES `uporabnik` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
876 ADD CONSTRAINT `narocilo_ibfk_3` FOREIGN KEY (`fk_jedilnik_meni_id`) REFERENCES `jedilnik_meni` (`id`) ON DELETE SET NULL ON UPDATE SET NULL,
877 ADD CONSTRAINT `narocilo_ibfk_4` FOREIGN KEY (`fk_nacin_placila`) REFERENCES `nacin_placila` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
878
879--
880-- Constraints for table `narocilo_feedback`
881--
882ALTER TABLE `narocilo_feedback`
883 ADD CONSTRAINT `narocilo_feedback_ibfk_1` FOREIGN KEY (`fk_uporabnik_id`) REFERENCES `uporabnik` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
884 ADD CONSTRAINT `narocilo_feedback_ibfk_2` FOREIGN KEY (`fk_narocilo_id`) REFERENCES `narocilo` (`id`) ON DELETE SET NULL ON UPDATE SET NULL,
885 ADD CONSTRAINT `narocilo_feedback_ibfk_3` FOREIGN KEY (`fk_lokal_id`) REFERENCES `lokal` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
886
887--
888-- Constraints for table `notification`
889--
890ALTER TABLE `notification`
891 ADD CONSTRAINT `notification_ibfk_1` FOREIGN KEY (`fk_uporabnik_id`) REFERENCES `uporabnik` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
892 ADD CONSTRAINT `notification_ibfk_2` FOREIGN KEY (`fk_lokal_id`) REFERENCES `lokal` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
893 ADD CONSTRAINT `notification_ibfk_3` FOREIGN KEY (`fk_notification_id`) REFERENCES `notification_tip` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
894
895--
896-- Constraints for table `ocena`
897--
898ALTER TABLE `ocena`
899 ADD CONSTRAINT `ocena_ibfk_1` FOREIGN KEY (`fk_lokal_id`) REFERENCES `lokal` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
900 ADD CONSTRAINT `ocena_ibfk_2` FOREIGN KEY (`fk_uporabnik_id`) REFERENCES `uporabnik` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
901
902--
903-- Constraints for table `priljubljeno`
904--
905ALTER TABLE `priljubljeno`
906 ADD CONSTRAINT `priljubljeno_ibfk_1` FOREIGN KEY (`fk_uporabnik_id`) REFERENCES `uporabnik` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
907 ADD CONSTRAINT `priljubljeno_ibfk_2` FOREIGN KEY (`fk_lokal_id`) REFERENCES `lokal` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
908
909--
910-- Constraints for table `uporabnik_nagrada`
911--
912ALTER TABLE `uporabnik_nagrada`
913 ADD CONSTRAINT `uporabnik_nagrada_ibfk_1` FOREIGN KEY (`fk_uporabnik_id`) REFERENCES `uporabnik` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
914 ADD CONSTRAINT `uporabnik_nagrada_ibfk_2` FOREIGN KEY (`fk_nagrada_id`) REFERENCES `nagrada` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
915
916/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
917/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
918/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;