· 10 years ago · Sep 21, 2016, 08:58 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 21, 2016 at 10:56 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=22 ;
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
67-- --------------------------------------------------------
68
69--
70-- Table structure for table `jedilnik`
71--
72
73CREATE TABLE IF NOT EXISTS `jedilnik` (
74 `id` bigint(20) NOT NULL,
75 `fk_lokal_id` bigint(20) NOT NULL,
76 `memo` varchar(64) COLLATE utf8_slovenian_ci NOT NULL,
77 `datum_vnosa` datetime NOT NULL,
78 `nazadnje_uporabljeno` datetime NOT NULL,
79 `active` tinyint(1) NOT NULL DEFAULT '0',
80 PRIMARY KEY (`id`),
81 KEY `fk_lokal_id` (`fk_lokal_id`)
82) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_slovenian_ci;
83
84--
85-- Dumping data for table `jedilnik`
86--
87
88INSERT INTO `jedilnik` (`id`, `fk_lokal_id`, `memo`, `datum_vnosa`, `nazadnje_uporabljeno`, `active`) VALUES
89(7588134078, 82045867280, '123', '2016-09-17 14:44:00', '2016-09-17 14:44:00', 0),
90(8649271841, 82045867280, 'wewe', '2016-09-17 20:29:00', '2016-09-17 20:29:00', 0),
91(11204853268, 82045867280, 'jedilnik', '2016-09-17 20:34:00', '2016-09-17 20:34:00', 1),
92(15310941807, 82045867280, '1', '2016-09-17 20:31:00', '2016-09-17 20:31:00', 0),
93(20829631860, 82045867280, '33', '2016-09-17 20:28:00', '2016-09-17 20:28:00', 0),
94(26249310923, 82386710868, 'ttz', '2016-09-19 12:00:00', '2016-09-19 12:00:00', 0),
95(28383515488, 82045867280, '333333', '2016-09-17 20:26:00', '2016-09-17 20:26:00', 0),
96(33798324768, 82045867280, '123', '2016-09-17 14:45:00', '2016-09-17 14:45:00', 0),
97(33824648320, 82045867280, '1', '2016-09-17 20:31:00', '2016-09-17 20:31:00', 0),
98(48058712889, 82045867280, '123', '2016-09-17 21:12:00', '2016-09-17 21:12:00', 0),
99(52878884339, 82045867280, '1', '2016-09-17 20:31:00', '2016-09-17 20:31:00', 0),
100(59663741564, 82045867280, 'tilen1', '2016-09-17 20:26:00', '2016-09-17 20:26:00', 0),
101(63831642153, 82045867280, 'asd', '2016-09-17 20:29:00', '2016-09-17 20:29:00', 0),
102(68163308184, 82045867280, '5', '2016-09-17 20:32:00', '2016-09-17 20:32:00', 0),
103(68380364088, 82386710868, 'Vikend meni', '2016-09-20 22:45:00', '2016-09-20 22:45:00', 1),
104(82911641268, 82386710868, 'Teden meni', '2016-09-11 18:34:00', '2016-09-11 18:34:00', 0),
105(89038977489, 82045867280, '33', '2016-09-17 20:26:00', '2016-09-17 20:26:00', 0);
106
107-- --------------------------------------------------------
108
109--
110-- Table structure for table `jedilnik_meni`
111--
112
113CREATE TABLE IF NOT EXISTS `jedilnik_meni` (
114 `id` int(11) NOT NULL AUTO_INCREMENT,
115 `naziv` varchar(64) COLLATE utf8_slovenian_ci DEFAULT NULL,
116 `fk_jedilnik_id` bigint(20) NOT NULL,
117 `fk_jedilnik_tip` int(11) DEFAULT NULL,
118 `jedilnik` mediumtext COLLATE utf8_slovenian_ci NOT NULL,
119 `cena` double DEFAULT '-1',
120 PRIMARY KEY (`id`),
121 KEY `fk_meni_id` (`fk_jedilnik_id`),
122 KEY `fk_jedilnik_tip` (`fk_jedilnik_tip`),
123 KEY `fk_meni_id_2` (`fk_jedilnik_id`),
124 KEY `fk_jedilnik_tip_2` (`fk_jedilnik_tip`),
125 KEY `fk_jedilnik_id` (`fk_jedilnik_id`)
126) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_slovenian_ci AUTO_INCREMENT=50 ;
127
128--
129-- Dumping data for table `jedilnik_meni`
130--
131
132INSERT INTO `jedilnik_meni` (`id`, `naziv`, `fk_jedilnik_id`, `fk_jedilnik_tip`, `jedilnik`, `cena`) VALUES
133(33, 'AOPMD123', 82911641268, 2, '213', -1),
134(37, '123', 11204853268, 2, '2::22::222::2222', 2),
135(38, '123', 11204853268, 3, '3', 3),
136(39, '123', 11204853268, 4, '44', 4),
137(40, '123', 48058712889, 2, '21', 123.5),
138(41, NULL, 48058712889, 3, '33', 123.5),
139(42, NULL, 48058712889, 3, 'wq', 123.5),
140(43, '123', 48058712889, 3, 'cx', 123.5),
141(44, '123', 48058712889, 6, 'sd', 123.5),
142(45, NULL, 26249310923, 2, '123::123::123', 12),
143(46, '123', 26249310923, 2, '33::33', 12),
144(47, 'Kosilo 1', 68380364088, 1, 'Paradižnikova juha::Svinski file v naravni omaki, pire::Sezonska solata::Jabolka', 3.18),
145(48, 'Kosilo 2', 68380364088, 2, 'PARADIŽNIKOVA JUHA::VALVICE Z GAMBERI,BROKOLIJEM IN ANANASOM::SEZONSKA SOLATA::JABOLKO', 3.18),
146(49, 'Kosilo 3', 68380364088, 6, 'PARADIŽNIKOVA JUHA::MESNI TORTELINI Z ZELENJAVO::SEZONSKA SOLATA::JABOLKO', 3.18);
147
148-- --------------------------------------------------------
149
150--
151-- Table structure for table `jedilnik_tip`
152--
153
154CREATE TABLE IF NOT EXISTS `jedilnik_tip` (
155 `id` int(11) NOT NULL,
156 `naziv` varchar(32) NOT NULL,
157 PRIMARY KEY (`id`)
158) ENGINE=InnoDB DEFAULT CHARSET=latin1;
159
160--
161-- Dumping data for table `jedilnik_tip`
162--
163
164INSERT INTO `jedilnik_tip` (`id`, `naziv`) VALUES
165(1, 'Mesni'),
166(2, 'Vege'),
167(3, 'Ribe'),
168(4, 'Hitra hrana'),
169(5, 'Pizza'),
170(6, 'Testenine');
171
172-- --------------------------------------------------------
173
174--
175-- Table structure for table `lokal`
176--
177
178CREATE TABLE IF NOT EXISTS `lokal` (
179 `id` bigint(11) NOT NULL,
180 `active` tinyint(1) NOT NULL DEFAULT '1',
181 `naziv` varchar(32) COLLATE utf16_slovenian_ci NOT NULL,
182 `lastnik` varchar(32) COLLATE utf16_slovenian_ci NOT NULL,
183 `naslov` varchar(48) COLLATE utf16_slovenian_ci NOT NULL,
184 `kraj` varchar(20) COLLATE utf16_slovenian_ci NOT NULL,
185 `telefon` varchar(14) CHARACTER SET latin1 NOT NULL,
186 `email` varchar(32) CHARACTER SET latin1 DEFAULT NULL,
187 `geslo` text CHARACTER SET utf32 COLLATE utf32_slovenian_ci NOT NULL,
188 `salt` text CHARACTER SET latin1 NOT NULL,
189 `odprto_teden_zacetek` varchar(8) CHARACTER SET latin1 NOT NULL,
190 `odprto_teden_konec` varchar(8) CHARACTER SET latin1 NOT NULL,
191 `odprto_sobota_zacetek` varchar(8) CHARACTER SET latin1 NOT NULL,
192 `odprto_sobota_konec` varchar(8) CHARACTER SET latin1 NOT NULL,
193 `odprto_nedelja_zacetek` varchar(8) CHARACTER SET latin1 NOT NULL,
194 `odprto_nedelja_konec` varchar(8) CHARACTER SET latin1 NOT NULL,
195 `datum_registracije` datetime NOT NULL,
196 `dostava` tinyint(1) NOT NULL,
197 `boni` tinyint(1) NOT NULL,
198 `cenabona` double NOT NULL,
199 `dostava_vikend` tinyint(1) NOT NULL,
200 `vege` tinyint(1) NOT NULL,
201 `kosila` tinyint(1) NOT NULL,
202 `img` varchar(128) COLLATE utf16_slovenian_ci DEFAULT NULL,
203 `nacin_placila` int(11) DEFAULT NULL,
204 PRIMARY KEY (`id`)
205) ENGINE=InnoDB DEFAULT CHARSET=utf16 COLLATE=utf16_slovenian_ci;
206
207--
208-- Dumping data for table `lokal`
209--
210
211INSERT 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`, `cenabona`, `dostava_vikend`, `vege`, `kosila`, `img`, `nacin_placila`) VALUES
212(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.87, 1, 0, 0, NULL, NULL),
213(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.87, 1, 0, 0, NULL, NULL),
214(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.87, 1, 0, 0, NULL, NULL),
215(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.87, 1, 0, 0, NULL, NULL),
216(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.87, 1, 0, 0, NULL, NULL),
217(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.87, 1, 0, 0, NULL, NULL),
218(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.87, 1, 0, 0, NULL, NULL),
219(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.87, 1, 0, 0, NULL, NULL),
220(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.87, 1, 0, 0, NULL, NULL),
221(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.87, 1, 0, 0, NULL, NULL),
222(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.87, 1, 0, 0, NULL, NULL),
223(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.87, 1, 0, 0, NULL, NULL),
224(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.87, 1, 0, 0, NULL, NULL),
225(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.87, 1, 0, 0, NULL, NULL),
226(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.87, 1, 0, 0, NULL, NULL),
227(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.87, 1, 0, 0, NULL, NULL),
228(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.87, 1, 0, 0, NULL, NULL),
229(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.87, 1, 0, 0, NULL, NULL),
230(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, 3.47, 1, 1, 0, NULL, NULL),
231(52927503148, 1, 'ApaÄi', 'ApaÄi', 'Pohorska cesta 17b', 'Slovenj Gradec', '028831784', 'apaci@gmail.com', '923b10184d21542f7a487f9300df1acab272269c9e41edf80d49934e73f0a370', '88528993183838781', '09:00', '23:00', '12:00', '01:00', '12:00', '22:00', '2016-09-08 14:29:57', 0, 1, 2.79, 0, 1, 0, NULL, NULL),
232(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, 3.87, 1, 1, 0, NULL, NULL),
233(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, 4.12, 1, 1, 1, NULL, NULL),
234(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, 3.17, 1, 0, 0, NULL, NULL),
235(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, 4, 1, 1, 0, NULL, NULL);
236
237-- --------------------------------------------------------
238
239--
240-- Table structure for table `lokal_nacin_placila`
241--
242
243CREATE TABLE IF NOT EXISTS `lokal_nacin_placila` (
244 `id` int(11) NOT NULL AUTO_INCREMENT,
245 `fk_lokal_id` bigint(20) NOT NULL,
246 `fk_nacin_placila` int(11) NOT NULL,
247 PRIMARY KEY (`id`),
248 KEY `fk_nacin_placila` (`fk_nacin_placila`),
249 KEY `fk_lokal_id` (`fk_lokal_id`)
250) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
251
252-- --------------------------------------------------------
253
254--
255-- Table structure for table `nacin_placila`
256--
257
258CREATE TABLE IF NOT EXISTS `nacin_placila` (
259 `id` int(11) NOT NULL AUTO_INCREMENT,
260 `naziv` varchar(16) NOT NULL,
261 PRIMARY KEY (`id`)
262) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;
263
264--
265-- Dumping data for table `nacin_placila`
266--
267
268INSERT INTO `nacin_placila` (`id`, `naziv`) VALUES
269(1, 'Gotovina'),
270(2, 'Kartica'),
271(3, 'Moneta');
272
273-- --------------------------------------------------------
274
275--
276-- Table structure for table `narocilo`
277--
278
279CREATE TABLE IF NOT EXISTS `narocilo` (
280 `id` bigint(20) NOT NULL,
281 `fk_uporabnik_id` bigint(20) NOT NULL,
282 `fk_jedilnik_meni_id` int(11) DEFAULT NULL,
283 `fk_lokal_id` bigint(20) NOT NULL,
284 `bon` tinyint(1) NOT NULL,
285 `naslov` varchar(64) CHARACTER SET utf8 COLLATE utf8_slovenian_ci NOT NULL,
286 `kraj` varchar(64) CHARACTER SET utf8 COLLATE utf8_slovenian_ci NOT NULL,
287 `telefon` varchar(64) NOT NULL,
288 `cena` double NOT NULL,
289 `komentar` text CHARACTER SET utf8 COLLATE utf8_slovenian_ci NOT NULL,
290 `datum_narocila` datetime NOT NULL,
291 `datum_sprejema` datetime DEFAULT NULL,
292 `koncano` tinyint(1) NOT NULL DEFAULT '0',
293 `predviden_cas_dostave` int(11) DEFAULT NULL,
294 `fk_nacin_placila` int(11) DEFAULT '1',
295 PRIMARY KEY (`id`),
296 KEY `fk_uporabnik_id` (`fk_uporabnik_id`),
297 KEY `fk_lokal_id` (`fk_lokal_id`),
298 KEY `fk_jedilnik_meni_id` (`fk_jedilnik_meni_id`),
299 KEY `fk_nacin_placila` (`fk_nacin_placila`)
300) ENGINE=InnoDB DEFAULT CHARSET=latin1;
301
302-- --------------------------------------------------------
303
304--
305-- Table structure for table `ocena`
306--
307
308CREATE TABLE IF NOT EXISTS `ocena` (
309 `id` int(11) NOT NULL AUTO_INCREMENT,
310 `fk_lokal_id` bigint(11) NOT NULL,
311 `fk_uporabnik_id` bigint(11) NOT NULL,
312 `ocena` int(11) NOT NULL,
313 PRIMARY KEY (`id`),
314 KEY `fk_uporabnik_id` (`fk_uporabnik_id`),
315 KEY `fk_lokal_id` (`fk_lokal_id`)
316) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=15 ;
317
318--
319-- Dumping data for table `ocena`
320--
321
322INSERT INTO `ocena` (`id`, `fk_lokal_id`, `fk_uporabnik_id`, `ocena`) VALUES
323(12, 82386710868, 86891762479, 5),
324(13, 52927503148, 86891762479, 3),
325(14, 82045867280, 86891762479, 5);
326
327-- --------------------------------------------------------
328
329--
330-- Table structure for table `priljubljeno`
331--
332
333CREATE TABLE IF NOT EXISTS `priljubljeno` (
334 `id` int(11) NOT NULL AUTO_INCREMENT,
335 `fk_uporabnik_id` bigint(20) NOT NULL,
336 `fk_lokal_id` bigint(20) NOT NULL,
337 PRIMARY KEY (`id`),
338 KEY `fk_uporabnik_id` (`fk_uporabnik_id`,`fk_lokal_id`),
339 KEY `fk_lokal_id` (`fk_lokal_id`)
340) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=17 ;
341
342--
343-- Dumping data for table `priljubljeno`
344--
345
346INSERT INTO `priljubljeno` (`id`, `fk_uporabnik_id`, `fk_lokal_id`) VALUES
347(14, 86891762479, 82045867280);
348
349-- --------------------------------------------------------
350
351--
352-- Table structure for table `uporabnik`
353--
354
355CREATE TABLE IF NOT EXISTS `uporabnik` (
356 `id` bigint(11) NOT NULL,
357 `email` varchar(32) NOT NULL,
358 `ime` varchar(14) CHARACTER SET utf8 COLLATE utf8_slovenian_ci NOT NULL,
359 `priimek` varchar(20) CHARACTER SET utf8 COLLATE utf8_slovenian_ci NOT NULL,
360 `telefon` varchar(14) NOT NULL,
361 `naslov` varchar(40) CHARACTER SET utf8 COLLATE utf8_slovenian_ci NOT NULL,
362 `kraj` varchar(20) CHARACTER SET utf8 COLLATE utf8_slovenian_ci NOT NULL,
363 `geslo` text CHARACTER SET utf8 COLLATE utf8_slovenian_ci NOT NULL,
364 `salt` text NOT NULL,
365 `ip` varchar(20) NOT NULL,
366 `datum_registracije` datetime NOT NULL,
367 `bon` tinyint(1) NOT NULL,
368 `last_login` datetime NOT NULL,
369 `narocilo_default_naslov` tinyint(1) NOT NULL DEFAULT '0',
370 PRIMARY KEY (`id`)
371) ENGINE=InnoDB DEFAULT CHARSET=latin1;
372
373--
374-- Dumping data for table `uporabnik`
375--
376
377INSERT INTO `uporabnik` (`id`, `email`, `ime`, `priimek`, `telefon`, `naslov`, `kraj`, `geslo`, `salt`, `ip`, `datum_registracije`, `bon`, `last_login`, `narocilo_default_naslov`) VALUES
378(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),
379(86891762479, 'tilen1@gmail.com', 'tilen', 'priimek', '031000000', 'naslov 12', 'maribor', '2bac383336519df7129ca77575dad272bfe86ff8547a6841dc1f8e648086654c', '80509632030640054', '::1', '2016-09-10 14:18:00', 1, '2016-09-20 23:54:00', 0);
380
381--
382-- Constraints for dumped tables
383--
384
385--
386-- Constraints for table `feedback`
387--
388ALTER TABLE `feedback`
389 ADD CONSTRAINT `feedback_ibfk_1` FOREIGN KEY (`fk_uporabnik_id`) REFERENCES `uporabnik` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
390 ADD CONSTRAINT `feedback_ibfk_2` FOREIGN KEY (`fk_lokal_id`) REFERENCES `lokal` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
391
392--
393-- Constraints for table `jedilnik`
394--
395ALTER TABLE `jedilnik`
396 ADD CONSTRAINT `jedilnik_ibfk_1` FOREIGN KEY (`fk_lokal_id`) REFERENCES `lokal` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
397
398--
399-- Constraints for table `jedilnik_meni`
400--
401ALTER TABLE `jedilnik_meni`
402 ADD CONSTRAINT `jedilnik_meni_ibfk_1` FOREIGN KEY (`fk_jedilnik_id`) REFERENCES `jedilnik` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
403 ADD CONSTRAINT `jedilnik_meni_ibfk_2` FOREIGN KEY (`fk_jedilnik_tip`) REFERENCES `jedilnik_tip` (`id`) ON DELETE SET NULL ON UPDATE SET NULL;
404
405--
406-- Constraints for table `lokal_nacin_placila`
407--
408ALTER TABLE `lokal_nacin_placila`
409 ADD CONSTRAINT `lokal_nacin_placila_ibfk_2` FOREIGN KEY (`fk_nacin_placila`) REFERENCES `nacin_placila` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
410 ADD CONSTRAINT `lokal_nacin_placila_ibfk_1` FOREIGN KEY (`fk_lokal_id`) REFERENCES `lokal` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
411
412--
413-- Constraints for table `narocilo`
414--
415ALTER TABLE `narocilo`
416 ADD CONSTRAINT `narocilo_ibfk_4` FOREIGN KEY (`fk_nacin_placila`) REFERENCES `nacin_placila` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
417 ADD CONSTRAINT `narocilo_ibfk_1` FOREIGN KEY (`fk_lokal_id`) REFERENCES `lokal` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
418 ADD CONSTRAINT `narocilo_ibfk_2` FOREIGN KEY (`fk_uporabnik_id`) REFERENCES `uporabnik` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
419 ADD CONSTRAINT `narocilo_ibfk_3` FOREIGN KEY (`fk_jedilnik_meni_id`) REFERENCES `jedilnik_meni` (`id`) ON DELETE SET NULL ON UPDATE SET NULL;
420
421--
422-- Constraints for table `ocena`
423--
424ALTER TABLE `ocena`
425 ADD CONSTRAINT `ocena_ibfk_1` FOREIGN KEY (`fk_lokal_id`) REFERENCES `lokal` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
426 ADD CONSTRAINT `ocena_ibfk_2` FOREIGN KEY (`fk_uporabnik_id`) REFERENCES `uporabnik` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
427
428--
429-- Constraints for table `priljubljeno`
430--
431ALTER TABLE `priljubljeno`
432 ADD CONSTRAINT `priljubljeno_ibfk_1` FOREIGN KEY (`fk_uporabnik_id`) REFERENCES `uporabnik` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
433 ADD CONSTRAINT `priljubljeno_ibfk_2` FOREIGN KEY (`fk_lokal_id`) REFERENCES `lokal` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
434
435/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
436/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
437/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;