· 10 years ago · Sep 27, 2016, 02:38 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 27, 2016 at 03:36 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 `nacin_placila`
268--
269
270CREATE TABLE IF NOT EXISTS `nacin_placila` (
271 `id` int(11) NOT NULL AUTO_INCREMENT,
272 `naziv` varchar(32) NOT NULL,
273 PRIMARY KEY (`id`)
274) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;
275
276--
277-- Dumping data for table `nacin_placila`
278--
279
280INSERT INTO `nacin_placila` (`id`, `naziv`) VALUES
281(1, 'Gotovina'),
282(2, 'Kartica'),
283(3, 'Moneta');
284
285-- --------------------------------------------------------
286
287--
288-- Table structure for table `narocilo`
289--
290
291CREATE TABLE IF NOT EXISTS `narocilo` (
292 `id` bigint(20) NOT NULL,
293 `fk_uporabnik_id` bigint(20) NOT NULL,
294 `fk_jedilnik_meni_id` int(11) DEFAULT NULL,
295 `fk_lokal_id` bigint(20) NOT NULL,
296 `bon` tinyint(1) NOT NULL,
297 `naslov` varchar(64) CHARACTER SET utf8 COLLATE utf8_slovenian_ci NOT NULL,
298 `kraj` varchar(64) CHARACTER SET utf8 COLLATE utf8_slovenian_ci NOT NULL,
299 `telefon` varchar(64) NOT NULL,
300 `cena` double NOT NULL,
301 `komentar` text CHARACTER SET utf8 COLLATE utf8_slovenian_ci NOT NULL,
302 `datum_narocila` datetime NOT NULL,
303 `datum_sprejema` datetime DEFAULT NULL,
304 `koncano` tinyint(1) NOT NULL DEFAULT '0',
305 `predviden_cas_dostave` int(11) DEFAULT NULL,
306 `fk_nacin_placila` int(11) DEFAULT '1',
307 `zavrnjeno` tinyint(1) NOT NULL DEFAULT '0',
308 PRIMARY KEY (`id`),
309 KEY `fk_uporabnik_id` (`fk_uporabnik_id`),
310 KEY `fk_lokal_id` (`fk_lokal_id`),
311 KEY `fk_jedilnik_meni_id` (`fk_jedilnik_meni_id`),
312 KEY `fk_nacin_placila` (`fk_nacin_placila`)
313) ENGINE=InnoDB DEFAULT CHARSET=latin1;
314
315--
316-- Dumping data for table `narocilo`
317--
318
319INSERT 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
320(48823427674, 86891762479, 175, 21061265696, 1, 'Naslov 12', 'Maribor', '031000000', 3.6, '', '2016-09-26 13:36:00', NULL, 0, NULL, 1, 0),
321(57079355894, 86891762479, 176, 21061265696, 1, 'Naslov 12', 'Maribor', '031000000', 3.6, '', '2016-09-26 13:36:00', NULL, 0, NULL, 1, 0),
322(63259454303, 86891762479, 175, 21061265696, 1, 'Naslov 12', 'Maribor', '031000000', 3.6, '', '2016-09-26 14:53:00', NULL, 0, NULL, 1, 0);
323
324-- --------------------------------------------------------
325
326--
327-- Table structure for table `narocilo_feedback`
328--
329
330CREATE TABLE IF NOT EXISTS `narocilo_feedback` (
331 `id` int(11) NOT NULL AUTO_INCREMENT,
332 `fk_uporabnik_id` bigint(20) NOT NULL,
333 `fk_narocilo_id` bigint(20) DEFAULT NULL,
334 `fk_lokal_id` bigint(20) NOT NULL,
335 `ocena` int(11) NOT NULL,
336 `mnenje` text NOT NULL,
337 PRIMARY KEY (`id`),
338 KEY `fk_lokal_id` (`fk_lokal_id`),
339 KEY `fk_uporabnik_id` (`fk_uporabnik_id`),
340 KEY `fk_narocilo_id` (`fk_narocilo_id`)
341) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=20 ;
342
343--
344-- Dumping data for table `narocilo_feedback`
345--
346
347INSERT INTO `narocilo_feedback` (`id`, `fk_uporabnik_id`, `fk_narocilo_id`, `fk_lokal_id`, `ocena`, `mnenje`) VALUES
348(16, 86891762479, NULL, 82386710868, 4, '123'),
349(17, 86891762479, NULL, 21061265696, 5, 'dobro'),
350(18, 86891762479, NULL, 21061265696, 5, 'ok'),
351(19, 86891762479, NULL, 21061265696, 5, '');
352
353-- --------------------------------------------------------
354
355--
356-- Table structure for table `ocena`
357--
358
359CREATE TABLE IF NOT EXISTS `ocena` (
360 `id` int(11) NOT NULL AUTO_INCREMENT,
361 `fk_lokal_id` bigint(11) NOT NULL,
362 `fk_uporabnik_id` bigint(11) NOT NULL,
363 `ocena` int(11) NOT NULL,
364 PRIMARY KEY (`id`),
365 KEY `fk_uporabnik_id` (`fk_uporabnik_id`),
366 KEY `fk_lokal_id` (`fk_lokal_id`)
367) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=16 ;
368
369--
370-- Dumping data for table `ocena`
371--
372
373INSERT INTO `ocena` (`id`, `fk_lokal_id`, `fk_uporabnik_id`, `ocena`) VALUES
374(12, 82386710868, 86891762479, 5),
375(13, 52927503148, 86891762479, 3),
376(14, 82045867280, 86891762479, 5),
377(15, 21061265696, 86891762479, 5);
378
379-- --------------------------------------------------------
380
381--
382-- Table structure for table `priljubljeno`
383--
384
385CREATE TABLE IF NOT EXISTS `priljubljeno` (
386 `id` int(11) NOT NULL AUTO_INCREMENT,
387 `fk_uporabnik_id` bigint(20) NOT NULL,
388 `fk_lokal_id` bigint(20) NOT NULL,
389 PRIMARY KEY (`id`),
390 KEY `fk_uporabnik_id` (`fk_uporabnik_id`,`fk_lokal_id`),
391 KEY `fk_lokal_id` (`fk_lokal_id`)
392) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=18 ;
393
394--
395-- Dumping data for table `priljubljeno`
396--
397
398INSERT INTO `priljubljeno` (`id`, `fk_uporabnik_id`, `fk_lokal_id`) VALUES
399(14, 86891762479, 82045867280),
400(17, 86891762479, 82386710868);
401
402-- --------------------------------------------------------
403
404--
405-- Table structure for table `uporabnik`
406--
407
408CREATE TABLE IF NOT EXISTS `uporabnik` (
409 `id` bigint(11) NOT NULL,
410 `email` varchar(32) NOT NULL,
411 `ime` varchar(14) CHARACTER SET utf8 COLLATE utf8_slovenian_ci NOT NULL,
412 `priimek` varchar(20) CHARACTER SET utf8 COLLATE utf8_slovenian_ci NOT NULL,
413 `telefon` varchar(14) NOT NULL,
414 `naslov` varchar(40) CHARACTER SET utf8 COLLATE utf8_slovenian_ci NOT NULL,
415 `kraj` varchar(20) CHARACTER SET utf8 COLLATE utf8_slovenian_ci NOT NULL,
416 `geslo` text CHARACTER SET utf8 COLLATE utf8_slovenian_ci NOT NULL,
417 `salt` text NOT NULL,
418 `ip` varchar(20) NOT NULL,
419 `datum_registracije` datetime NOT NULL,
420 `bon` tinyint(1) NOT NULL,
421 `last_login` datetime NOT NULL,
422 `narocilo_default_naslov` tinyint(1) NOT NULL DEFAULT '0',
423 PRIMARY KEY (`id`)
424) ENGINE=InnoDB DEFAULT CHARSET=latin1;
425
426--
427-- Dumping data for table `uporabnik`
428--
429
430INSERT INTO `uporabnik` (`id`, `email`, `ime`, `priimek`, `telefon`, `naslov`, `kraj`, `geslo`, `salt`, `ip`, `datum_registracije`, `bon`, `last_login`, `narocilo_default_naslov`) VALUES
431(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),
432(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),
433(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);
434
435--
436-- Constraints for dumped tables
437--
438
439--
440-- Constraints for table `akcija`
441--
442ALTER TABLE `akcija`
443 ADD CONSTRAINT `akcija_ibfk_1` FOREIGN KEY (`fk_lokal_id`) REFERENCES `lokal` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
444
445--
446-- Constraints for table `feedback`
447--
448ALTER TABLE `feedback`
449 ADD CONSTRAINT `feedback_ibfk_1` FOREIGN KEY (`fk_uporabnik_id`) REFERENCES `uporabnik` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
450 ADD CONSTRAINT `feedback_ibfk_2` FOREIGN KEY (`fk_lokal_id`) REFERENCES `lokal` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
451
452--
453-- Constraints for table `jedilnik`
454--
455ALTER TABLE `jedilnik`
456 ADD CONSTRAINT `jedilnik_ibfk_1` FOREIGN KEY (`fk_lokal_id`) REFERENCES `lokal` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
457
458--
459-- Constraints for table `jedilnik_meni`
460--
461ALTER TABLE `jedilnik_meni`
462 ADD CONSTRAINT `jedilnik_meni_ibfk_1` FOREIGN KEY (`fk_jedilnik_id`) REFERENCES `jedilnik` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
463 ADD CONSTRAINT `jedilnik_meni_ibfk_2` FOREIGN KEY (`fk_jedilnik_tip`) REFERENCES `jedilnik_tip` (`id`) ON DELETE SET NULL ON UPDATE SET NULL;
464
465--
466-- Constraints for table `narocilo`
467--
468ALTER TABLE `narocilo`
469 ADD CONSTRAINT `narocilo_ibfk_1` FOREIGN KEY (`fk_lokal_id`) REFERENCES `lokal` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
470 ADD CONSTRAINT `narocilo_ibfk_2` FOREIGN KEY (`fk_uporabnik_id`) REFERENCES `uporabnik` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
471 ADD CONSTRAINT `narocilo_ibfk_3` FOREIGN KEY (`fk_jedilnik_meni_id`) REFERENCES `jedilnik_meni` (`id`) ON DELETE SET NULL ON UPDATE SET NULL,
472 ADD CONSTRAINT `narocilo_ibfk_4` FOREIGN KEY (`fk_nacin_placila`) REFERENCES `nacin_placila` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
473
474--
475-- Constraints for table `narocilo_feedback`
476--
477ALTER TABLE `narocilo_feedback`
478 ADD CONSTRAINT `narocilo_feedback_ibfk_1` FOREIGN KEY (`fk_uporabnik_id`) REFERENCES `uporabnik` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
479 ADD CONSTRAINT `narocilo_feedback_ibfk_2` FOREIGN KEY (`fk_narocilo_id`) REFERENCES `narocilo` (`id`) ON DELETE SET NULL ON UPDATE SET NULL,
480 ADD CONSTRAINT `narocilo_feedback_ibfk_3` FOREIGN KEY (`fk_lokal_id`) REFERENCES `lokal` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
481
482--
483-- Constraints for table `ocena`
484--
485ALTER TABLE `ocena`
486 ADD CONSTRAINT `ocena_ibfk_1` FOREIGN KEY (`fk_lokal_id`) REFERENCES `lokal` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
487 ADD CONSTRAINT `ocena_ibfk_2` FOREIGN KEY (`fk_uporabnik_id`) REFERENCES `uporabnik` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
488
489--
490-- Constraints for table `priljubljeno`
491--
492ALTER TABLE `priljubljeno`
493 ADD CONSTRAINT `priljubljeno_ibfk_1` FOREIGN KEY (`fk_uporabnik_id`) REFERENCES `uporabnik` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
494 ADD CONSTRAINT `priljubljeno_ibfk_2` FOREIGN KEY (`fk_lokal_id`) REFERENCES `lokal` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
495
496/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
497/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
498/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;