· 10 years ago · Sep 25, 2016, 10:28 AM
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 25, 2016 at 12:27 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 `feedback`
27--
28
29CREATE TABLE IF NOT EXISTS `feedback` (
30 `id` int(11) NOT NULL AUTO_INCREMENT,
31 `text` text CHARACTER SET latin1 NOT NULL,
32 `fk_uporabnik_id` bigint(20) DEFAULT NULL,
33 `fk_lokal_id` bigint(20) DEFAULT NULL,
34 `datum` datetime NOT NULL,
35 PRIMARY KEY (`id`),
36 KEY `fk_uporabnik_id` (`fk_uporabnik_id`),
37 KEY `fk_lokal_id` (`fk_lokal_id`)
38) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_slovenian_ci AUTO_INCREMENT=25 ;
39
40--
41-- Dumping data for table `feedback`
42--
43
44INSERT INTO `feedback` (`id`, `text`, `fk_uporabnik_id`, `fk_lokal_id`, `datum`) VALUES
45(1, 'ertert', NULL, NULL, '2016-09-20 16:32:00'),
46(2, 'ertert', NULL, NULL, '2016-09-20 16:32:00'),
47(3, 'ertert', NULL, NULL, '2016-09-20 16:32:00'),
48(4, 'ertert', NULL, NULL, '2016-09-20 16:32:00'),
49(5, 'ertert', NULL, NULL, '2016-09-20 16:32:00'),
50(6, 'ertert', NULL, NULL, '2016-09-20 16:32:00'),
51(7, 'ertert', NULL, NULL, '2016-09-20 16:32:00'),
52(8, 'ertert', NULL, NULL, '2016-09-20 16:32:00'),
53(9, 'ertert', NULL, NULL, '2016-09-20 16:32:00'),
54(10, 'ertert', NULL, NULL, '2016-09-20 16:32:00'),
55(11, 'ertert', NULL, NULL, '2016-09-20 16:32:00'),
56(12, 'ertert', NULL, NULL, '2016-09-20 16:32:00'),
57(13, 'zrtzr', NULL, 82386710868, '2016-09-20 16:33:00'),
58(14, 'werwer', 86891762479, NULL, '2016-09-20 16:34:00'),
59(15, 'rtzertz', 86891762479, NULL, '2016-09-20 16:37:00'),
60(16, 'rtzertz', 86891762479, NULL, '2016-09-20 16:37:00'),
61(17, 'rtzertz', 86891762479, NULL, '2016-09-20 16:37:00'),
62(18, 'rtzertz', 86891762479, NULL, '2016-09-20 16:37:00'),
63(19, 'rtuzrtz', 86891762479, NULL, '2016-09-20 16:38:00'),
64(20, '78', NULL, 82386710868, '2016-09-20 17:14:00'),
65(21, 'iopsdjt', 86891762479, NULL, '2016-09-20 23:58:00'),
66(22, '123', 86891762479, NULL, '2016-09-23 15:28:00'),
67(23, '123', 86891762479, NULL, '2016-09-23 23:21:00'),
68(24, '99o', 86891762479, NULL, '2016-09-24 08:48:00');
69
70-- --------------------------------------------------------
71
72--
73-- Table structure for table `jedilnik`
74--
75
76CREATE TABLE IF NOT EXISTS `jedilnik` (
77 `id` bigint(20) NOT NULL,
78 `fk_lokal_id` bigint(20) NOT NULL,
79 `memo` varchar(64) COLLATE utf8_slovenian_ci NOT NULL,
80 `datum_vnosa` datetime NOT NULL,
81 `active` tinyint(1) NOT NULL DEFAULT '0',
82 `tip` tinyint(1) NOT NULL DEFAULT '0',
83 PRIMARY KEY (`id`),
84 KEY `fk_lokal_id` (`fk_lokal_id`)
85) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_slovenian_ci;
86
87--
88-- Dumping data for table `jedilnik`
89--
90
91INSERT INTO `jedilnik` (`id`, `fk_lokal_id`, `memo`, `datum_vnosa`, `active`, `tip`) VALUES
92(123123, 82386710868, 'def', '2016-09-23 14:09:00', 1, 0),
93(60602130512, 35358669632, 'Privzeto', '2016-09-24 09:52:00', 0, 0),
94(78432093444, 35358669632, 'Å tudentski', '2016-09-24 09:52:00', 0, 1),
95(89380512299, 21061265696, 'Privzeto', '2016-09-23 14:09:00', 1, 0);
96
97-- --------------------------------------------------------
98
99--
100-- Table structure for table `jedilnik_meni`
101--
102
103CREATE TABLE IF NOT EXISTS `jedilnik_meni` (
104 `id` int(11) NOT NULL AUTO_INCREMENT,
105 `naziv` varchar(64) COLLATE utf8_slovenian_ci DEFAULT NULL,
106 `fk_jedilnik_id` bigint(20) NOT NULL,
107 `fk_jedilnik_tip` int(11) DEFAULT NULL,
108 `jedilnik` mediumtext COLLATE utf8_slovenian_ci NOT NULL,
109 `cena` double DEFAULT '-1',
110 `bon` tinyint(1) NOT NULL DEFAULT '0',
111 PRIMARY KEY (`id`),
112 KEY `fk_meni_id` (`fk_jedilnik_id`),
113 KEY `fk_jedilnik_tip` (`fk_jedilnik_tip`),
114 KEY `fk_meni_id_2` (`fk_jedilnik_id`),
115 KEY `fk_jedilnik_tip_2` (`fk_jedilnik_tip`),
116 KEY `fk_jedilnik_id` (`fk_jedilnik_id`)
117) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_slovenian_ci AUTO_INCREMENT=181 ;
118
119--
120-- Dumping data for table `jedilnik_meni`
121--
122
123INSERT INTO `jedilnik_meni` (`id`, `naziv`, `fk_jedilnik_id`, `fk_jedilnik_tip`, `jedilnik`, `cena`, `bon`) VALUES
124(174, 'Kosilo 1', 89380512299, 1, 'KORENÄŒKOVA JUHA::OCVRTI MEDALJONI,NJOKI S PARMEZANOM::SEZONSKA SOLATA::JABOLKO', 3.6, 0),
125(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),
126(176, 'Kosilo 3', 89380512299, 2, 'KORENČKOVA JUHA::LOSOS NA ŽARU,BLITVA S KROMPIRJEM::SEZONSKA SOLATA::JABOLKO', 3.6, 0),
127(177, 'Kosilo 1', 60602130512, 1, 'POHORSKI LONEC, ÄŒOKOLADICA::SESTAVLJENA SOLATA::SADJE', 2, 0),
128(178, 'Kosilo 2', 60602130512, 1, 'GOVEJI ZREZEK V LOVSKI OMAKI, TESTENINE::SESTAVLJENA SOLATA::SADJE', 2, 0),
129(179, 'Kosilo 23', 60602130512, 1, 'MESNI SIR NA ŽARU, RIŽ S KORENČKOM::SESTAVLJENA SOLATA::SADJE', 2, 0),
130(180, 'Kosilo bon', 60602130512, 3, '123', 12, 1);
131
132-- --------------------------------------------------------
133
134--
135-- Table structure for table `jedilnik_tip`
136--
137
138CREATE TABLE IF NOT EXISTS `jedilnik_tip` (
139 `id` int(11) NOT NULL,
140 `naziv` varchar(32) NOT NULL,
141 PRIMARY KEY (`id`)
142) ENGINE=InnoDB DEFAULT CHARSET=latin1;
143
144--
145-- Dumping data for table `jedilnik_tip`
146--
147
148INSERT INTO `jedilnik_tip` (`id`, `naziv`) VALUES
149(1, 'Mesni'),
150(2, 'Vege'),
151(3, 'Ribe'),
152(4, 'Hitra hrana'),
153(5, 'Pizza'),
154(6, 'Testenine');
155
156-- --------------------------------------------------------
157
158--
159-- Table structure for table `lokal`
160--
161
162CREATE TABLE IF NOT EXISTS `lokal` (
163 `id` bigint(11) NOT NULL,
164 `active` tinyint(1) NOT NULL DEFAULT '1',
165 `naziv` varchar(32) COLLATE utf16_slovenian_ci NOT NULL,
166 `lastnik` varchar(32) COLLATE utf16_slovenian_ci NOT NULL,
167 `naslov` varchar(48) COLLATE utf16_slovenian_ci NOT NULL,
168 `kraj` varchar(20) COLLATE utf16_slovenian_ci NOT NULL,
169 `telefon` varchar(14) CHARACTER SET latin1 NOT NULL,
170 `email` varchar(32) CHARACTER SET latin1 DEFAULT NULL,
171 `geslo` text CHARACTER SET utf32 COLLATE utf32_slovenian_ci NOT NULL,
172 `salt` text CHARACTER SET latin1 NOT NULL,
173 `odprto_teden_zacetek` varchar(8) CHARACTER SET latin1 NOT NULL,
174 `odprto_teden_konec` varchar(8) CHARACTER SET latin1 NOT NULL,
175 `odprto_sobota_zacetek` varchar(8) CHARACTER SET latin1 NOT NULL,
176 `odprto_sobota_konec` varchar(8) CHARACTER SET latin1 NOT NULL,
177 `odprto_nedelja_zacetek` varchar(8) CHARACTER SET latin1 NOT NULL,
178 `odprto_nedelja_konec` varchar(8) CHARACTER SET latin1 NOT NULL,
179 `datum_registracije` datetime NOT NULL,
180 `dostava` tinyint(1) NOT NULL,
181 `boni` tinyint(1) NOT NULL,
182 `dostava_vikend` tinyint(1) NOT NULL,
183 `vege` tinyint(1) NOT NULL,
184 `kosila` tinyint(1) NOT NULL,
185 `img` varchar(128) COLLATE utf16_slovenian_ci DEFAULT NULL,
186 `placilo_gotovina` tinyint(1) NOT NULL,
187 `placilo_kartica` tinyint(1) NOT NULL,
188 `placilo_moneta` tinyint(1) NOT NULL,
189 PRIMARY KEY (`id`)
190) ENGINE=InnoDB DEFAULT CHARSET=utf16 COLLATE=utf16_slovenian_ci;
191
192--
193-- Dumping data for table `lokal`
194--
195
196INSERT 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
197(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),
198(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),
199(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),
200(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),
201(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),
202(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),
203(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),
204(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),
205(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),
206(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),
207(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),
208(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),
209(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),
210(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),
211(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),
212(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),
213(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),
214(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),
215(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),
216(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),
217(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),
218(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),
219(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),
220(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),
221(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),
222(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);
223
224-- --------------------------------------------------------
225
226--
227-- Table structure for table `nacin_placila`
228--
229
230CREATE TABLE IF NOT EXISTS `nacin_placila` (
231 `id` int(11) NOT NULL AUTO_INCREMENT,
232 `naziv` varchar(32) NOT NULL,
233 PRIMARY KEY (`id`)
234) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;
235
236--
237-- Dumping data for table `nacin_placila`
238--
239
240INSERT INTO `nacin_placila` (`id`, `naziv`) VALUES
241(1, 'Gotovina'),
242(2, 'Kartica'),
243(3, 'Moneta');
244
245-- --------------------------------------------------------
246
247--
248-- Table structure for table `narocilo`
249--
250
251CREATE TABLE IF NOT EXISTS `narocilo` (
252 `id` bigint(20) NOT NULL,
253 `fk_uporabnik_id` bigint(20) NOT NULL,
254 `fk_jedilnik_meni_id` int(11) DEFAULT NULL,
255 `fk_lokal_id` bigint(20) NOT NULL,
256 `bon` tinyint(1) NOT NULL,
257 `naslov` varchar(64) CHARACTER SET utf8 COLLATE utf8_slovenian_ci NOT NULL,
258 `kraj` varchar(64) CHARACTER SET utf8 COLLATE utf8_slovenian_ci NOT NULL,
259 `telefon` varchar(64) NOT NULL,
260 `cena` double NOT NULL,
261 `komentar` text CHARACTER SET utf8 COLLATE utf8_slovenian_ci NOT NULL,
262 `datum_narocila` datetime NOT NULL,
263 `datum_sprejema` datetime DEFAULT NULL,
264 `koncano` tinyint(1) NOT NULL DEFAULT '0',
265 `predviden_cas_dostave` int(11) DEFAULT NULL,
266 `fk_nacin_placila` int(11) DEFAULT '1',
267 `zavrnjeno` tinyint(1) NOT NULL DEFAULT '0',
268 PRIMARY KEY (`id`),
269 KEY `fk_uporabnik_id` (`fk_uporabnik_id`),
270 KEY `fk_lokal_id` (`fk_lokal_id`),
271 KEY `fk_jedilnik_meni_id` (`fk_jedilnik_meni_id`),
272 KEY `fk_nacin_placila` (`fk_nacin_placila`)
273) ENGINE=InnoDB DEFAULT CHARSET=latin1;
274
275--
276-- Dumping data for table `narocilo`
277--
278
279INSERT 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
280(1741568820, 86891762479, 176, 21061265696, 1, 'Naslov 12', 'Maribor', '031000000', 3.6, '', '2016-09-23 23:42:00', NULL, 0, NULL, 1, 0),
281(9373848290, 86891762479, NULL, 82386710868, 1, 'qweqwe', 'qweqwe', '031000000', 3.18, '123', '2016-09-22 15:22:00', '2016-09-22 20:01:00', 1, NULL, 1, 0),
282(11350552511, 86891762479, 174, 21061265696, 1, 'Naslov 12', 'Maribor', '031000000', 3.6, '', '2016-09-24 01:10:00', '2016-09-24 08:41:00', 1, NULL, 1, 0),
283(17093856403, 86891762479, NULL, 82386710868, 1, '123123', '123123', '031000000', 3.18, '132', '2016-09-22 13:12:00', '2016-09-23 13:50:00', 1, NULL, 1, 0),
284(18868420336, 86891762479, NULL, 82386710868, 1, '123123', '123123', '031000000', 3.18, '132', '2016-09-22 13:12:00', NULL, 0, NULL, 1, 0),
285(46788785820, 86891762479, 176, 21061265696, 1, 'opwqke', 'qpwoke', '031000000', 3.6, 'qwe', '2016-09-23 23:16:00', NULL, 0, NULL, 1, 0),
286(46906979696, 86891762479, 176, 21061265696, 1, 'Naslov 12', 'Maribor', '031000000', 3.6, '', '2016-09-23 23:10:00', NULL, 0, NULL, 1, 0),
287(51958082309, 86891762479, NULL, 82386710868, 1, 'Naslov 12', 'Maribor', '031000000', 12, '', '2016-09-23 13:54:00', NULL, 0, NULL, 1, 0),
288(53886804147, 86891762479, 174, 21061265696, 1, 'Naslov 12', 'Maribor', '031000000', 3.6, '', '2016-09-23 23:14:00', NULL, 0, NULL, 1, 0),
289(54532842888, 86891762479, NULL, 82386710868, 1, 'qweqwe', 'qweqwe', '031000000', 3.18, '123', '2016-09-22 15:22:00', '2016-09-22 18:15:00', 1, NULL, 1, 0),
290(62273868549, 86891762479, NULL, 82386710868, 1, 'qweqwe', 'qweqwe', '031000000', 3.18, '123', '2016-09-22 15:22:00', '2016-09-22 17:44:00', 1, NULL, 1, 0),
291(66286868548, 86891762479, 175, 21061265696, 1, 'opwqke', 'qpwoke', '031000000', 3.6, 'qwe', '2016-09-23 23:16:00', NULL, 0, NULL, 1, 0),
292(69837336727, 86891762479, 174, 21061265696, 1, 'opwqke', 'qpwoke', '031000000', 3.6, 'qwe', '2016-09-23 23:16:00', NULL, 0, NULL, 1, 0),
293(70268978308, 86891762479, 174, 21061265696, 1, 'Naslov 12', 'Maribor', '031000000', 3.6, '', '2016-09-24 05:26:00', '2016-09-24 07:48:00', 1, NULL, 1, 0),
294(71945255360, 86891762479, 176, 21061265696, 1, 'Naslov 12', 'Maribor', '031000000', 3.6, '', '2016-09-23 23:14:00', NULL, 0, NULL, 1, 0),
295(76689130628, 86891762479, 175, 21061265696, 1, 'Naslov 12', 'Maribor', '031000000', 3.6, '', '2016-09-23 23:21:00', NULL, 0, NULL, 1, 0),
296(76771100821, 86891762479, 174, 21061265696, 1, 'Naslov 12', 'Maribor', '031000000', 3.6, '', '2016-09-23 23:21:00', NULL, 0, NULL, 1, 0),
297(79600468389, 86891762479, 174, 21061265696, 1, 'Naslov 12', 'Maribor', '031000000', 3.6, '', '2016-09-23 14:12:00', '2016-09-23 15:17:00', 1, NULL, 1, 0),
298(80551087816, 86891762479, 176, 21061265696, 1, 'Naslov 12', 'Maribor', '031000000', 3.6, '', '2016-09-23 23:21:00', NULL, 0, NULL, 1, 0),
299(98865609855, 86891762479, NULL, 82386710868, 1, '123123', '123123', '031000000', 3.18, '132', '2016-09-22 13:12:00', '2016-09-23 00:18:00', 1, NULL, 1, 0),
300(98878138848, 86891762479, 174, 21061265696, 1, 'Naslov 12', 'Maribor', '031000000', 3.6, '', '2016-09-24 01:06:00', NULL, 0, NULL, 1, 0);
301
302-- --------------------------------------------------------
303
304--
305-- Table structure for table `narocilo_feedback`
306--
307
308CREATE TABLE IF NOT EXISTS `narocilo_feedback` (
309 `id` int(11) NOT NULL AUTO_INCREMENT,
310 `fk_uporabnik_id` bigint(20) NOT NULL,
311 `fk_narocilo_id` bigint(20) DEFAULT NULL,
312 `fk_lokal_id` bigint(20) NOT NULL,
313 `ocena` int(11) NOT NULL,
314 `mnenje` text NOT NULL,
315 PRIMARY KEY (`id`),
316 KEY `fk_lokal_id` (`fk_lokal_id`),
317 KEY `fk_uporabnik_id` (`fk_uporabnik_id`),
318 KEY `fk_narocilo_id` (`fk_narocilo_id`)
319) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=19 ;
320
321--
322-- Dumping data for table `narocilo_feedback`
323--
324
325INSERT INTO `narocilo_feedback` (`id`, `fk_uporabnik_id`, `fk_narocilo_id`, `fk_lokal_id`, `ocena`, `mnenje`) VALUES
326(16, 86891762479, 54532842888, 82386710868, 4, '123'),
327(17, 86891762479, 79600468389, 21061265696, 5, 'dobro'),
328(18, 86891762479, 11350552511, 21061265696, 5, 'ok');
329
330-- --------------------------------------------------------
331
332--
333-- Table structure for table `ocena`
334--
335
336CREATE TABLE IF NOT EXISTS `ocena` (
337 `id` int(11) NOT NULL AUTO_INCREMENT,
338 `fk_lokal_id` bigint(11) NOT NULL,
339 `fk_uporabnik_id` bigint(11) NOT NULL,
340 `ocena` int(11) NOT NULL,
341 PRIMARY KEY (`id`),
342 KEY `fk_uporabnik_id` (`fk_uporabnik_id`),
343 KEY `fk_lokal_id` (`fk_lokal_id`)
344) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=16 ;
345
346--
347-- Dumping data for table `ocena`
348--
349
350INSERT INTO `ocena` (`id`, `fk_lokal_id`, `fk_uporabnik_id`, `ocena`) VALUES
351(12, 82386710868, 86891762479, 5),
352(13, 52927503148, 86891762479, 3),
353(14, 82045867280, 86891762479, 5),
354(15, 21061265696, 86891762479, 5);
355
356-- --------------------------------------------------------
357
358--
359-- Table structure for table `priljubljeno`
360--
361
362CREATE TABLE IF NOT EXISTS `priljubljeno` (
363 `id` int(11) NOT NULL AUTO_INCREMENT,
364 `fk_uporabnik_id` bigint(20) NOT NULL,
365 `fk_lokal_id` bigint(20) NOT NULL,
366 PRIMARY KEY (`id`),
367 KEY `fk_uporabnik_id` (`fk_uporabnik_id`,`fk_lokal_id`),
368 KEY `fk_lokal_id` (`fk_lokal_id`)
369) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=18 ;
370
371--
372-- Dumping data for table `priljubljeno`
373--
374
375INSERT INTO `priljubljeno` (`id`, `fk_uporabnik_id`, `fk_lokal_id`) VALUES
376(14, 86891762479, 82045867280),
377(17, 86891762479, 82386710868);
378
379-- --------------------------------------------------------
380
381--
382-- Table structure for table `uporabnik`
383--
384
385CREATE TABLE IF NOT EXISTS `uporabnik` (
386 `id` bigint(11) NOT NULL,
387 `email` varchar(32) NOT NULL,
388 `ime` varchar(14) CHARACTER SET utf8 COLLATE utf8_slovenian_ci NOT NULL,
389 `priimek` varchar(20) CHARACTER SET utf8 COLLATE utf8_slovenian_ci NOT NULL,
390 `telefon` varchar(14) NOT NULL,
391 `naslov` varchar(40) CHARACTER SET utf8 COLLATE utf8_slovenian_ci NOT NULL,
392 `kraj` varchar(20) CHARACTER SET utf8 COLLATE utf8_slovenian_ci NOT NULL,
393 `geslo` text CHARACTER SET utf8 COLLATE utf8_slovenian_ci NOT NULL,
394 `salt` text NOT NULL,
395 `ip` varchar(20) NOT NULL,
396 `datum_registracije` datetime NOT NULL,
397 `bon` tinyint(1) NOT NULL,
398 `last_login` datetime NOT NULL,
399 `narocilo_default_naslov` tinyint(1) NOT NULL DEFAULT '0',
400 PRIMARY KEY (`id`)
401) ENGINE=InnoDB DEFAULT CHARSET=latin1;
402
403--
404-- Dumping data for table `uporabnik`
405--
406
407INSERT INTO `uporabnik` (`id`, `email`, `ime`, `priimek`, `telefon`, `naslov`, `kraj`, `geslo`, `salt`, `ip`, `datum_registracije`, `bon`, `last_login`, `narocilo_default_naslov`) VALUES
408(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),
409(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),
410(86891762479, 'tilen1@gmail.com', 'tilen', 'priimek', '031000000', 'naslov 12', 'maribor', '2bac383336519df7129ca77575dad272bfe86ff8547a6841dc1f8e648086654c', '80509632030640054', '::1', '2016-09-10 14:18:00', 1, '2016-09-24 08:41:00', 0);
411
412--
413-- Constraints for dumped tables
414--
415
416--
417-- Constraints for table `feedback`
418--
419ALTER TABLE `feedback`
420 ADD CONSTRAINT `feedback_ibfk_1` FOREIGN KEY (`fk_uporabnik_id`) REFERENCES `uporabnik` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
421 ADD CONSTRAINT `feedback_ibfk_2` FOREIGN KEY (`fk_lokal_id`) REFERENCES `lokal` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
422
423--
424-- Constraints for table `jedilnik`
425--
426ALTER TABLE `jedilnik`
427 ADD CONSTRAINT `jedilnik_ibfk_1` FOREIGN KEY (`fk_lokal_id`) REFERENCES `lokal` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
428
429--
430-- Constraints for table `jedilnik_meni`
431--
432ALTER TABLE `jedilnik_meni`
433 ADD CONSTRAINT `jedilnik_meni_ibfk_1` FOREIGN KEY (`fk_jedilnik_id`) REFERENCES `jedilnik` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
434 ADD CONSTRAINT `jedilnik_meni_ibfk_2` FOREIGN KEY (`fk_jedilnik_tip`) REFERENCES `jedilnik_tip` (`id`) ON DELETE SET NULL ON UPDATE SET NULL;
435
436--
437-- Constraints for table `narocilo`
438--
439ALTER TABLE `narocilo`
440 ADD CONSTRAINT `narocilo_ibfk_1` FOREIGN KEY (`fk_lokal_id`) REFERENCES `lokal` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
441 ADD CONSTRAINT `narocilo_ibfk_2` FOREIGN KEY (`fk_uporabnik_id`) REFERENCES `uporabnik` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
442 ADD CONSTRAINT `narocilo_ibfk_3` FOREIGN KEY (`fk_jedilnik_meni_id`) REFERENCES `jedilnik_meni` (`id`) ON DELETE SET NULL ON UPDATE SET NULL,
443 ADD CONSTRAINT `narocilo_ibfk_4` FOREIGN KEY (`fk_nacin_placila`) REFERENCES `nacin_placila` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
444
445--
446-- Constraints for table `narocilo_feedback`
447--
448ALTER TABLE `narocilo_feedback`
449 ADD CONSTRAINT `narocilo_feedback_ibfk_3` FOREIGN KEY (`fk_lokal_id`) REFERENCES `lokal` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
450 ADD CONSTRAINT `narocilo_feedback_ibfk_1` FOREIGN KEY (`fk_uporabnik_id`) REFERENCES `uporabnik` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
451 ADD CONSTRAINT `narocilo_feedback_ibfk_2` FOREIGN KEY (`fk_narocilo_id`) REFERENCES `narocilo` (`id`) ON DELETE SET NULL ON UPDATE SET NULL;
452
453--
454-- Constraints for table `ocena`
455--
456ALTER TABLE `ocena`
457 ADD CONSTRAINT `ocena_ibfk_1` FOREIGN KEY (`fk_lokal_id`) REFERENCES `lokal` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
458 ADD CONSTRAINT `ocena_ibfk_2` FOREIGN KEY (`fk_uporabnik_id`) REFERENCES `uporabnik` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
459
460--
461-- Constraints for table `priljubljeno`
462--
463ALTER TABLE `priljubljeno`
464 ADD CONSTRAINT `priljubljeno_ibfk_1` FOREIGN KEY (`fk_uporabnik_id`) REFERENCES `uporabnik` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
465 ADD CONSTRAINT `priljubljeno_ibfk_2` FOREIGN KEY (`fk_lokal_id`) REFERENCES `lokal` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
466
467/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
468/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
469/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;