· 9 years ago · Jan 05, 2017, 09:44 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: Jan 05, 2017 at 10:42 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: `prodaja`
21--
22
23-- --------------------------------------------------------
24
25--
26-- Table structure for table `artikel_ohranjenost`
27--
28
29CREATE TABLE IF NOT EXISTS `artikel_ohranjenost` (
30 `id` int(11) NOT NULL,
31 `naziv` varchar(32) COLLATE utf8_slovenian_ci NOT NULL,
32 PRIMARY KEY (`id`)
33) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_slovenian_ci;
34
35--
36-- Dumping data for table `artikel_ohranjenost`
37--
38
39INSERT INTO `artikel_ohranjenost` (`id`, `naziv`) VALUES
40(1, 'Kot novo'),
41(2, 'OdliÄno ohranjeno'),
42(3, 'Dobro ohranjeno'),
43(4, 'Zmerno ohranjeno'),
44(5, 'Slabo ohranjeno');
45
46-- --------------------------------------------------------
47
48--
49-- Table structure for table `artikel_stanje`
50--
51
52CREATE TABLE IF NOT EXISTS `artikel_stanje` (
53 `id` int(11) NOT NULL,
54 `stanje` varchar(16) COLLATE utf8_slovenian_ci NOT NULL,
55 PRIMARY KEY (`id`)
56) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_slovenian_ci;
57
58--
59-- Dumping data for table `artikel_stanje`
60--
61
62INSERT INTO `artikel_stanje` (`id`, `stanje`) VALUES
63(1, 'Novo'),
64(2, 'Rabljeno');
65
66-- --------------------------------------------------------
67
68--
69-- Table structure for table `drazba`
70--
71
72CREATE TABLE IF NOT EXISTS `drazba` (
73 `id` int(11) NOT NULL AUTO_INCREMENT,
74 `fk_oglas` bigint(20) NOT NULL,
75 `trenutna_cena` float NOT NULL,
76 `datum_konca` datetime NOT NULL,
77 PRIMARY KEY (`id`),
78 KEY `fk_oglas` (`fk_oglas`)
79) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
80
81--
82-- Dumping data for table `drazba`
83--
84
85INSERT INTO `drazba` (`id`, `fk_oglas`, `trenutna_cena`, `datum_konca`) VALUES
86(1, 34295178950, 10009, '2017-01-17 16:55:00');
87
88-- --------------------------------------------------------
89
90--
91-- Table structure for table `drazba_vnos`
92--
93
94CREATE TABLE IF NOT EXISTS `drazba_vnos` (
95 `id` int(11) NOT NULL AUTO_INCREMENT,
96 `datum` datetime NOT NULL,
97 `fk_uporabnik` bigint(20) NOT NULL,
98 `fk_drazba` int(11) NOT NULL,
99 `cena` float NOT NULL,
100 PRIMARY KEY (`id`),
101 KEY `fk_uporabnik` (`fk_uporabnik`),
102 KEY `fk_drazba` (`fk_drazba`)
103) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=80 ;
104
105--
106-- Dumping data for table `drazba_vnos`
107--
108
109INSERT INTO `drazba_vnos` (`id`, `datum`, `fk_uporabnik`, `fk_drazba`, `cena`) VALUES
110(1, '2017-01-03 20:57:00', 10000000, 1, 102),
111(4, '2017-01-03 21:00:00', 10000000, 1, 102),
112(5, '2017-01-03 21:01:00', 10000000, 1, 103),
113(6, '2017-01-03 21:01:00', 10000000, 1, 104),
114(7, '2017-01-03 21:01:00', 10000000, 1, 105),
115(8, '2017-01-03 21:01:00', 10000000, 1, 106),
116(9, '2017-01-03 21:02:00', 10000000, 1, 107),
117(10, '2017-01-03 21:03:00', 10000000, 1, 108),
118(11, '2017-01-03 21:04:00', 10000000, 1, 109),
119(12, '2017-01-03 21:04:00', 10000000, 1, 110),
120(13, '2017-01-03 21:04:00', 10000000, 1, 111),
121(14, '2017-01-03 21:13:00', 10000000, 1, 122),
122(15, '2017-01-03 21:14:00', 10000000, 1, 123),
123(16, '2017-01-03 21:14:00', 10000000, 1, 124),
124(17, '2017-01-03 21:19:00', 10000000, 1, 125),
125(18, '2017-01-03 21:19:00', 10000000, 1, 126),
126(19, '2017-01-03 21:20:00', 10000000, 1, 127),
127(20, '2017-01-03 21:20:00', 10000000, 1, 129),
128(21, '2017-01-03 21:21:00', 10000000, 1, 130),
129(22, '2017-01-03 21:22:00', 10000000, 1, 131),
130(23, '2017-01-03 21:22:00', 10000000, 1, 132),
131(24, '2017-01-03 21:22:00', 10000000, 1, 133),
132(25, '2017-01-03 21:23:00', 10000000, 1, 150),
133(26, '2017-01-03 21:24:00', 10000000, 1, 151),
134(27, '2017-01-03 21:25:00', 10000000, 1, 152),
135(28, '2017-01-03 21:26:00', 10000000, 1, 153),
136(29, '2017-01-03 21:34:00', 10000000, 1, 154),
137(30, '2017-01-03 21:35:00', 10000000, 1, 155),
138(31, '2017-01-03 21:35:00', 10000000, 1, 156),
139(32, '2017-01-03 21:35:00', 10000000, 1, 157),
140(33, '2017-01-03 21:37:00', 10000000, 1, 158),
141(34, '2017-01-03 21:39:00', 10000000, 1, 158.2),
142(35, '2017-01-03 21:46:00', 10000000, 1, 159.2),
143(36, '2017-01-03 21:49:00', 10000000, 1, 160.2),
144(37, '2017-01-03 21:54:00', 10000000, 1, 161.2),
145(38, '2017-01-03 21:55:00', 10000000, 1, 162.2),
146(39, '2017-01-03 21:55:00', 10000000, 1, 163.2),
147(40, '2017-01-03 21:56:00', 10000000, 1, 164.2),
148(41, '2017-01-03 20:57:00', 10000000, 1, 102),
149(42, '2017-01-03 21:58:00', 10000000, 1, 165.2),
150(43, '2017-01-03 21:58:00', 10000000, 1, 166.2),
151(44, '2017-01-03 21:59:00', 10000000, 1, 167.2),
152(45, '2017-01-03 21:59:00', 10000000, 1, 168.2),
153(46, '2017-01-03 21:59:00', 10000000, 1, 169.2),
154(47, '2017-01-03 21:59:00', 10000000, 1, 170.2),
155(48, '2017-01-03 21:59:00', 10000000, 1, 180),
156(49, '2017-01-03 22:00:00', 10000000, 1, 181),
157(50, '2017-01-03 22:02:00', 10000000, 1, 182),
158(51, '2017-01-04 00:00:00', 10000000, 1, 183),
159(52, '2017-01-04 00:08:00', 10000000, 1, 184),
160(53, '2017-01-04 00:13:00', 10000000, 1, 185),
161(54, '2017-01-04 00:32:00', 10000000, 1, 186),
162(55, '2017-01-04 02:05:00', 10000000, 1, 187),
163(56, '2017-01-04 02:05:00', 10000000, 1, 188),
164(57, '2017-01-04 02:05:00', 10000000, 1, 189),
165(58, '2017-01-04 02:05:00', 10000000, 1, 190),
166(59, '2017-01-04 02:06:00', 10000000, 1, 191),
167(60, '2017-01-04 02:12:00', 10000000, 1, 192),
168(61, '2017-01-04 02:12:00', 10000000, 1, 193),
169(62, '2017-01-04 02:22:00', 10000000, 1, 194),
170(63, '2017-01-04 02:25:00', 10000000, 1, 195),
171(64, '2017-01-04 02:25:00', 10000000, 1, 196),
172(65, '2017-01-04 02:25:00', 10000000, 1, 197),
173(66, '2017-01-04 02:25:00', 10000000, 1, 198),
174(67, '2017-01-04 02:25:00', 10000000, 1, 199),
175(68, '2017-01-04 02:25:00', 10000000, 1, 200),
176(69, '2017-01-04 02:26:00', 10000000, 1, 2010),
177(70, '2017-01-04 02:26:00', 10000000, 1, 10000),
178(71, '2017-01-04 02:26:00', 10000000, 1, 10001),
179(72, '2017-01-04 02:26:00', 10000000, 1, 10002),
180(73, '2017-01-04 02:26:00', 10000000, 1, 10003),
181(74, '2017-01-04 02:26:00', 10000000, 1, 10004),
182(75, '2017-01-04 13:48:00', 10000000, 1, 10005),
183(76, '2017-01-04 14:29:00', 10000000, 1, 10006),
184(77, '2017-01-04 14:30:00', 10000000, 1, 10007),
185(78, '2017-01-04 14:44:00', 10000000, 1, 10008),
186(79, '2017-01-04 14:45:00', 10000000, 1, 10009);
187
188-- --------------------------------------------------------
189
190--
191-- Table structure for table `fav_kategorija`
192--
193
194CREATE TABLE IF NOT EXISTS `fav_kategorija` (
195 `id` int(11) NOT NULL AUTO_INCREMENT,
196 `fk_uporabnik` bigint(20) NOT NULL,
197 `fk_kategorija` int(11) NOT NULL,
198 PRIMARY KEY (`id`),
199 KEY `fk_uporabnik` (`fk_uporabnik`),
200 KEY `fk_kategorija` (`fk_kategorija`)
201) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=30 ;
202
203--
204-- Dumping data for table `fav_kategorija`
205--
206
207INSERT INTO `fav_kategorija` (`id`, `fk_uporabnik`, `fk_kategorija`) VALUES
208(27, 10000000, 68),
209(28, 10000000, 11),
210(29, 10000000, 36);
211
212-- --------------------------------------------------------
213
214--
215-- Table structure for table `kategorija`
216--
217
218CREATE TABLE IF NOT EXISTS `kategorija` (
219 `id` int(11) NOT NULL AUTO_INCREMENT,
220 `fk_nadkategorija` int(11) DEFAULT NULL,
221 `naziv` varchar(64) COLLATE utf8_slovenian_ci NOT NULL,
222 `ico` varchar(32) COLLATE utf8_slovenian_ci NOT NULL,
223 `red` smallint(6) NOT NULL DEFAULT '0',
224 PRIMARY KEY (`id`),
225 KEY `fk_nadkategorija` (`fk_nadkategorija`)
226) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_slovenian_ci AUTO_INCREMENT=72 ;
227
228--
229-- Dumping data for table `kategorija`
230--
231
232INSERT INTO `kategorija` (`id`, `fk_nadkategorija`, `naziv`, `ico`, `red`) VALUES
233(1, NULL, 'RaÄunalniÅ¡tvo in telefonija', 'devices', 0),
234(2, NULL, 'Avdio-video in foto', 'camera', 0),
235(3, NULL, 'Osebna nega in zdravje', 'bubble_chart', 0),
236(4, NULL, 'Glasba in glasbila', 'audiotrack', 0),
237(5, NULL, 'OblaÄila in obutev', 'wc', 0),
238(6, NULL, 'Storitve', 'accessibility', 0),
239(7, NULL, 'Orodja in stroji', 'build', 0),
240(8, NULL, 'Hobi in zbirateljstvo', 'schedule', 0),
241(9, NULL, 'Živali', 'pets', 0),
242(10, NULL, 'Dom in vrt', 'home', 0),
243(11, 1, 'Monitorji', '11', 7),
244(12, 1, 'Namizni raÄunalniki', '12', 9),
245(13, 1, 'Prenosni raÄunalniki', '13', 8),
246(14, 1, 'Ohišja, napajalniki', '14', 0),
247(15, 1, 'Tipkovnice, miške', '15', 6),
248(16, 1, 'Procesorji', '16', 0),
249(17, 1, 'Mrežna oprema', '17', 0),
250(18, 1, 'Shramba podatkov', '18', 0),
251(19, 1, 'Tiskalniki, skenerji', '19', 4),
252(20, 2, 'ZvoÄniki, sluÅ¡alke, mikrofoni', '20', 0),
253(21, 1, 'Strežniki in oprema', '21', 0),
254(22, 1, 'RaÄunalniÅ¡ke komponente', '22', 0),
255(23, 1, 'Telefoni', '23', 10),
256(24, 1, 'Telefaksi', '24', 0),
257(25, 1, 'Tablice', '25', 5),
258(26, 2, 'Fotoaparati', '26', 0),
259(27, 2, 'Fotografksa oprema', '27', 0),
260(28, 2, 'Projektorji', '28', 0),
261(29, 2, 'Optika', '29', 0),
262(30, 2, 'Snemalna oprema', '30', 0),
263(31, NULL, 'Valute in dragocene kovine', 'euro_symbol', 0),
264(32, 4, 'Glasbena oprema', '32', 0),
265(33, 4, 'Glasbila', '33', 0),
266(34, 5, 'MoÅ¡ka oblaÄila', '34', 0),
267(35, 5, 'Ženska oblaÄila', '35', 0),
268(36, 5, 'OtroÅ¡ka oblaÄila', '36', 0),
269(37, 5, 'Obutev', '37', 0),
270(38, 5, 'Å portna oblaÄila', '38', 0),
271(39, 5, 'RoÄne ure in nakit', '39', 0),
272(40, 10, 'Gradnja', '40', 0),
273(41, 10, 'Bela tehnika', '41', 0),
274(42, 10, 'Dnevne sobe', '42', 0),
275(43, 10, 'Kopalnice', '43', 0),
276(44, 10, 'Kuhinje', '44', 0),
277(45, 10, 'Spalnice', '45', 0),
278(46, 10, 'Svetila', '46', 0),
279(47, 10, 'Vrtna oprema', '47', 0),
280(48, 2, 'Filmi', '48', 0),
281(49, 2, 'TV sprejemniki, televizija', '49', 0),
282(52, 3, 'Lepota', '52', 0),
283(53, 3, 'Zdravje', '53', 0),
284(54, 3, 'Dobro poÄutje', '54', 0),
285(55, 5, 'Pust, maškarada', '55', 0),
286(56, 7, 'Akumulatorji, baterije, polnilci', '56', 0),
287(57, 7, 'ElektriÄno orodje', '57', 0),
288(58, 7, 'RoÄno orodje', '58', 0),
289(59, 7, 'Merila', '59', 0),
290(60, 7, 'Stroji', '60', 0),
291(61, 8, 'Hobi', '61', 0),
292(62, 8, 'Zbirateljstvo', '62', 0),
293(63, 8, 'Umetnine', '63', 0),
294(64, 8, 'Starine', '64', 0),
295(65, 9, 'LjubljenÄki', '65', 0),
296(66, 9, 'Rejne živali', '66', 0),
297(67, 9, 'Živalska oprema', '67', 0),
298(68, 1, 'Gaming', '68', 2),
299(69, NULL, 'IgraÄe in otroÅ¡ka oprema', 'child_friendly', 0),
300(70, 1, 'Telefonska oprema in pripomoÄki', '70', 3),
301(71, 5, 'Torbe in pripomoÄki', '39', 0);
302
303-- --------------------------------------------------------
304
305--
306-- Table structure for table `msg`
307--
308
309CREATE TABLE IF NOT EXISTS `msg` (
310 `id` int(11) NOT NULL AUTO_INCREMENT,
311 `fk_uporabnik` bigint(20) NOT NULL,
312 `fk_pogovor` int(11) NOT NULL,
313 `text` text NOT NULL,
314 `datum` datetime NOT NULL,
315 PRIMARY KEY (`id`),
316 KEY `fk_pogovor` (`fk_pogovor`),
317 KEY `fk_uporabnik` (`fk_uporabnik`)
318) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
319
320-- --------------------------------------------------------
321
322--
323-- Table structure for table `oglas`
324--
325
326CREATE TABLE IF NOT EXISTS `oglas` (
327 `id` bigint(20) NOT NULL,
328 `naslov` varchar(128) COLLATE utf8_slovenian_ci NOT NULL,
329 `opis` text COLLATE utf8_slovenian_ci NOT NULL,
330 `fk_oglas_tip` int(11) DEFAULT NULL,
331 `cena` float NOT NULL,
332 `cena_pred_popustom` float NOT NULL DEFAULT '-1',
333 `postnina_vkljucena` tinyint(1) NOT NULL DEFAULT '0',
334 `fk_uporabnik` bigint(20) DEFAULT NULL,
335 `fk_podjetje` bigint(20) DEFAULT NULL,
336 `fk_kategorija` int(11) DEFAULT NULL,
337 `fk_stanje` int(11) DEFAULT NULL,
338 `fk_ohranjenost` int(11) DEFAULT NULL,
339 `datum` datetime NOT NULL,
340 `fk_znamka` int(11) DEFAULT NULL,
341 PRIMARY KEY (`id`),
342 KEY `fk_kategorija` (`fk_kategorija`),
343 KEY `fk_uporabnik` (`fk_uporabnik`),
344 KEY `fk_oglas_tip` (`fk_oglas_tip`),
345 KEY `fk_stanje` (`fk_stanje`),
346 KEY `fk_znamka` (`fk_znamka`),
347 KEY `fk_ohranjenost` (`fk_ohranjenost`)
348) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_slovenian_ci;
349
350--
351-- Dumping data for table `oglas`
352--
353
354INSERT INTO `oglas` (`id`, `naslov`, `opis`, `fk_oglas_tip`, `cena`, `cena_pred_popustom`, `postnina_vkljucena`, `fk_uporabnik`, `fk_podjetje`, `fk_kategorija`, `fk_stanje`, `fk_ohranjenost`, `datum`, `fk_znamka`) VALUES
355(1683166449, 'Kupim monitor', 'asdasdasd', 2, 123, 0, 0, 10000000, NULL, 11, 1, NULL, '2016-12-26 18:41:00', 8),
356(8858883145, 'Asus X550VX-MS71 15.6" Laptop Intel i7-6700HQ 2.6GHz 8GB 1TB NVIDIA GTX 950M W10', 'Laptop - Manufacturer refurbished in brown box, well packed. Power adapter/charger is included. Office 365 not included.', 1, 499.99, 799.99, 0, 10000000, NULL, 13, 1, NULL, '2017-01-01 17:43:00', 4),
357(12884594619, 'swag', 'qwhhmstjr,mzmkzj', 2, 12, 0, 1, 10000000, NULL, 68, 1, NULL, '2016-12-22 21:49:00', NULL),
358(17066749688, 'qweqweqwe', 'qweqweqwe', 1, 1233, -1, 0, 10000000, NULL, 26, 1, NULL, '2017-01-03 13:50:00', NULL),
359(20031686523, 'swag', 'qwhhmstjr,mzmkzj', 2, 12, 0, 1, 10000000, NULL, 68, 1, NULL, '2016-12-22 21:49:00', NULL),
360(28801676345, 'qweqweqwe', 'qweqweqweqwe', 2, -1, 0, 1, 10000000, NULL, 11, 1, NULL, '2016-12-26 18:44:00', 12),
361(29288908190, 'hladnilnik', 'sfukan', 1, 123, 0, 0, 10000000, NULL, 17, 2, 5, '2016-12-22 21:08:00', 24),
362(34295178950, 'Drazba test', 'test', 3, 100, -1, 0, 10000000, NULL, 55, 1, NULL, '2017-01-03 18:55:00', NULL),
363(34457118362, 'swag', 'qwhhmstjr,mzmkzj', 2, 12, 0, 1, 10000000, NULL, 68, 1, NULL, '2016-12-22 21:49:00', NULL),
364(37558867940, 'HP EliteBook 8460p Intel Core i5 2.50 GHz 4 GB Ram 320 GB HDD Win 10 (LPT-025)', 'his laptop is used and may have noticeable wear and scratches on the casing, corners, and edges (See Photos). The keyboard and touch pad are all in good condition with minimal wear. The screen is in overall good condition with no scratches but it does have a dead pixel. This laptop does include a legal copy of Windows 10 Home. Additional features include a Webcam, Bluetooth, Fingerprint Scanner, DVD-RW Drive and Media Card Reader.', 1, 200, -1, 0, 10000000, NULL, 13, 2, 3, '2017-01-04 16:15:00', 9),
365(38010905964, 'Samsung SyncMaster B2240W LCD monitor - 22"', 'Prodam malo rabljen 22" LCD monitor Samsung SyncMaster B2240W. Monitor je lepo ohranjen in deluje brezhibno.\r\nProdam za 55€ ( cena novega cca. 170€ )\r\nSpecifikacije:\r\nhttp://www.samsung.com/us/computer/monitors/LS22CBKABV/ZA-sp...', 1, 100.55, 0, 0, 10000000, NULL, 11, 2, 2, '2016-12-16 18:31:00', 12),
366(41713111699, 'hladnilnasdin', 'asdokasodk', 1, 15, 0, 0, 10000000, NULL, 68, 2, 2, '2016-12-22 21:32:00', NULL),
367(42282104886, 'Acer TN LED monitor KA KA240HQBbid 59,9cm (23,6")\n', 'Acer KA je zmogljiv TN LED monitor, namenjen za vse pisarne. Ponuja vam 59,9 cm (23,6") zaslon s Full HD loÄljivostjo 1920×1080 in svetilnostjo 300 cd/m2.', 1, 129.95, 0, 0, 10000000, NULL, 11, 1, NULL, '2016-12-11 18:56:00', 6),
368(47439900894, 'awfawf', 'afawfa', 1, 122, 0, 0, 10000000, NULL, 68, 1, NULL, '2016-12-22 21:56:00', NULL),
369(50540645999, 'MoÅ¡ka obleka- komplet Kenzo Homme, blazer + hlaÄe', 'Prodam moÅ¡ko obleko znamke Kenzo, v velikosti 56.\r\nJe zelo dobro ohranjena, stara 1 leto in noÅ¡ena le za potrebe sestankov. \r\nBlazer je na zapenjanje dveh gumbov, dolg 120cm (prbl 78 cm v ramenih, 105 dolžine rokavov).\r\nCena ob nakupu: 800evrov, prodajam za 590', 1, 590, -1, 0, 10000000, NULL, 34, 2, 1, '2017-01-03 15:10:00', NULL),
370(50859800978, 'swag', 'qwhhmstjr,mzmkzj', 2, 12, 0, 1, 10000000, NULL, 68, 1, NULL, '2016-12-22 21:49:00', NULL),
371(57234939967, 'swag', 'awfaw', 1, 12, 0, 0, 10000000, NULL, 1, 1, NULL, '2016-12-22 21:57:00', NULL),
372(59275224985, 'hadilnik', 'zjeban', 1, 112, 0, 0, 10000000, NULL, 17, 2, 5, '2016-12-22 20:55:00', 24),
373(59958501386, 'SuknjiÄ + krilo, kvalitetne znamke JONES, vel.38-40', 'ÄŒe katero zanima, imam naprodaj Äudovit, neponovljiv kostim avstrijske znamke JONES, vel. 38. Predlagam, da preverite mere, ker so Å¡tevilke malo veÄje od naÅ¡ih. Kupljen je bil preko spleta, prodam, ker mi velikost ne ustreza.\r\nÄŒe ste ljubiteljice te znamke so vam poznane cene. Jaz kostim prodam za ugodno ceno in sicer 90 eur + stroÅ¡ki poÅ¡iljanja.\r\nKostim je idealen za posebne priložnosti, Äe pa nosite vsak kos posebej, potem je uporaben tudi za vsakodnevno noÅ¡njo.\r\n\r\nKrilo: pas 40 cm (x 2), boki 49 cm (x2), dolžina krila 57 cm.\r\nSuknjiÄ: prsa 48 cm (x2), pas 42,5 cm (x2), dolžina suknjiÄa 62 cm, dolžina rokavov (merjeno od pazduhe navzdol) 45 cm.\r\nImam Å¡e veÄ oglasov.', 1, 70, 0, 0, 10000000, NULL, 35, 1, NULL, '2016-12-18 16:10:00', NULL),
374(60585573030, 'swag', 'qwhhmstjr,mzmkzj', 2, 12, 0, 1, 10000000, NULL, 68, 1, NULL, '2016-12-22 21:49:00', NULL),
375(68505406459, 'swag', 'qwhhmstjr,mzmkzj', 2, 12, 0, 1, 10000000, NULL, 68, 1, NULL, '2016-12-22 21:49:00', NULL),
376(70497502484, 'swag', 'qwhhmstjr,mzmkzj', 2, 12, 0, 1, 10000000, NULL, 68, 1, NULL, '2016-12-22 21:49:00', NULL),
377(74847607123, 'fegeg', 'wgwegwegwegweg', 1, 12, 0, 0, 55885178732, NULL, 68, 1, NULL, '2016-12-22 22:49:00', NULL),
378(74955981011, 'test', 'test', 1, 12, 0, 0, 10000000, NULL, 11, 2, NULL, '2016-12-17 13:31:00', 3),
379(74955981012, 'test', 'test', 1, 12, 0, 0, 10000000, NULL, 11, 2, NULL, '2016-12-17 13:31:00', 3),
380(74955981013, 'test', 'test', 1, 12, 0, 0, 10000000, NULL, 11, 2, NULL, '2016-12-17 13:31:00', 3),
381(74955981014, 'test', 'test', 1, 12, 0, 0, 10000000, NULL, 11, 2, NULL, '2016-12-17 13:31:00', 3),
382(74955981015, 'test', 'test', 1, 12, 0, 0, 10000000, NULL, 11, 2, NULL, '2016-12-17 13:31:00', 3),
383(74955981016, 'test', 'test', 1, 12, 0, 0, 10000000, NULL, 11, 2, NULL, '2016-12-17 13:31:00', 3),
384(74955981017, 'test', 'test', 1, 12, 0, 0, 10000000, NULL, 11, 2, NULL, '2016-12-17 13:31:00', 3),
385(78460143082, ' BenQ VW2245Z LED VA 21.5 -inch W Monitor 1920 x 1080', 'In perfect working order. No original packaging. Any questions just ask!', 1, 122, 0, 0, 10000000, NULL, 11, 1, NULL, '2016-12-27 17:39:00', 8),
386(80346558888, 'qweqwe', 'qweqwe', 1, 123, 0, 0, 10000000, NULL, 68, 2, 4, '2016-12-18 18:02:00', NULL),
387(80701313008, 'qweqwe', 'qweqwe', 1, 123, 0, 0, 10000000, NULL, 21, 2, NULL, '2016-12-17 23:37:00', NULL),
388(88714409822, '123123', '123123', 3, 123, 0, 0, 10000000, NULL, 55, 2, 2, '2016-12-26 23:54:00', NULL),
389(89041778168, 'OtroÅ¡ki voziÄek kolekcije Moon Rainbow 3 v1', 'Ob Äudovitih prihajajoÄih praznikih kjer obdarujemo svoje najdražje izberite Äudovit voziÄek za otroka po ZNIŽANI CENI!\r\nRedna cena je 460,00 eur, znižana cena 410,00 eur za cel popoln komplet!\r\n\r\nOtroÅ¡ki voziÄek kolekcije Moon - Rainbow je najnovejÅ¡i model voziÄka z izrednim dizajnom ohiÅ¡ja, koles in z Äudovitimi kombinacijami barv. Model voziÄka je " HIT " med voziÄki za otroka. VoziÄek narejen po vrhunski, najnovejÅ¡i tehnologiji.\r\n\r\nKoÅ¡ara voziÄka je iz plastike obrobljena z materialom eko usnje, medtem ko so ostale tkanine kombinacija tekstila in eko usnja. \r\nPriroÄna, enostavna uporaba z nastavljivim roÄajem po viÅ¡ini, preprost mehanizem zlaganja. VoziÄek dobavljiv 3v1. \r\nVoziÄki izdelani v skladu z standardom EN 1888.\r\n \r\nPodroben opis: \r\n \r\nohiÅ¡je voziÄka iz lahkega aluminija \r\nnastavljiv roÄaj po viÅ¡ini 73- 112 cm\r\npreprost in enostaven mehanizem za zlaganje\r\nvelika nakupovalna koÅ¡ara do 5kg\r\npodvozje je lahko in enostavno za manevriranje\r\nvsa kolesa so gumirana napolnjena z zrakom in snemljiva ali napihljiva (možnost izbire)\r\nprednja so vrtljiva 360 °z možnostjo fiksiranja\r\nzadnja kolesa z ležaji in snemljiva\r\nna zadnjih kolesih je nožna zavora\r\nnastavljivi amortizerji\r\ndodana torbica z pasom \r\nprekrivalo za dež\r\nprekrivalo za mrÄes\r\nzaÅ¡Äitna prekrivala koles\r\nDMS »Direction Memory System« ko je kolo v zraku ostane v položaju kot je in se ne vrti\r\nSAS »Shock Absorption System« sistem za absorbiranje vibracij na neravnem terenu\r\n \r\nkoÅ¡ara za otroka ima možnost zibanja\r\nstrehica koÅ¡are z možnostjo spuÅ¡Äanja\r\nza udoben oprijem koÅ¡are skrbi roÄaj ki je obÅ¡it z prevleko\r\nv koÅ¡ari veÄstopenjsko nastavitev viÅ¡ine naklona\r\nvgrajena mreža za prezraÄevanje\r\nje velika, udobna z hitrim klik sistemom pripenjanja\r\nprav tako je obrnljiva v obe smeri vožnje\r\ndodana je zaÅ¡Äitna prevleka za nogice\r\nnotranja dimenzije koÅ¡are 85 cm x 40 cm \r\nviÅ¡ina od tal 70 cm \r\n \r\nÅ portni del ima z usnjem obrobljeno naslonjalo za noge\r\nmožnost nastavitve v obe smeri vožnje\r\nveÄkratno nastavljivo naslonjalo \r\npo viÅ¡ini nastavljiva opora za nogice\r\nodstranljivo prednje varovalo z sredinsko zaÅ¡Äito\r\nzaÅ¡Äitna prevleka za nogice\r\n5 toÄkovni nastavljiv varnostni pas\r\ndolžina 110 cm, Å¡irina 45 cm\r\nnastavljiva strehica z vgrajeno mrežo\r\n \r\nlupinica / avtosedež od 0-10 kg\r\nvgrajen 3 toÄkovni varnostni pas, nastavljiv z blazinicami\r\nsedež je opremljen z zaÅ¡Äitno strehico in prevleko za nogice\r\ndodaten notranji vložek ki je odstranljiv\r\nnastavljiv usnjen roÄaj\r\nv kompletu tudi adapterji za namestitev na ohiÅ¡je voziÄka\r\nv avtomobil se pripne z varnostnim pasom avtomobila ali isofix bazo (posebej dobavljiva)\r\nvse ustrezajo evropskim standardom varnosti ECE R44/04\r\nteža 3,5 kg\r\n\r\nhttp://www.sb-poceni.si/otroski_vozicki/nestor/moon_rainbow\r\n\r\nPri nas v salonu je možen tudi ogled voziÄka.\r\n\r\nPodjetje:\r\nS&B PosredniÅ¡tvo in Trgovina Suzana KerÄmar s.p\r\nSpletna stran:\r\nhttp://www.sb-poceni.si/', 1, 420, 0, 0, 10000000, NULL, 69, 1, NULL, '2016-12-19 23:48:00', NULL),
390(91111228291, 'swag', 'qwhhmstjr,mzmkzj', 2, 12, 0, 1, 10000000, NULL, 68, 1, NULL, '2016-12-22 21:49:00', NULL),
391(95411386693, 'Blazer Zara Basic, velikost M', 'Prodam blazer Zara Basic, velikost M, na rokavu ima strgano podlogo, kar lahko vidite tudi na sliki.\r\n\r\nPoglejte si Å¡e ostale moje oglase.', 1, 5, 0, 0, 10000000, NULL, 35, 1, NULL, '2016-12-18 15:30:00', NULL),
392(99342951789, 'swag', 'qwhhmstjr,mzmkzj', 2, 12, 0, 1, 10000000, NULL, 68, 1, NULL, '2016-12-22 21:49:00', NULL),
393(749559110127, 'test', 'test', 1, 12, 0, 0, 10000000, NULL, 11, 2, NULL, '2016-12-23 13:31:00', 3),
394(749559110187, 'test', 'test', 1, 12, 0, 0, 10000000, NULL, 11, 2, NULL, '2016-12-17 13:31:00', 3),
395(749559810187, 'test', 'test', 1, 12, 0, 0, 10000000, NULL, 11, 2, NULL, '2016-12-17 13:31:00', 3);
396
397-- --------------------------------------------------------
398
399--
400-- Table structure for table `oglas_slika`
401--
402
403CREATE TABLE IF NOT EXISTS `oglas_slika` (
404 `id` int(11) NOT NULL AUTO_INCREMENT,
405 `cdn` varchar(64) COLLATE utf8_slovenian_ci NOT NULL,
406 `fk_oglas` bigint(20) NOT NULL,
407 PRIMARY KEY (`id`),
408 KEY `fk_oglas` (`fk_oglas`)
409) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_slovenian_ci AUTO_INCREMENT=20 ;
410
411--
412-- Dumping data for table `oglas_slika`
413--
414
415INSERT INTO `oglas_slika` (`id`, `cdn`, `fk_oglas`) VALUES
416(1, 'd27dec0c9fb4df0d90670318586318e5__1.jpg', 38010905964),
417(4, '28cc90ecae4f3690a5d4eda81882e434__1.jpg', 42282104886),
418(5, '28cc90ecae4f3690a5d4eda81882e434__2.jpg', 42282104886),
419(6, '292c8f81ec0c98dedbe34307fbf81270__1.jpg', 95411386693),
420(7, '74331c23a99f0e2854532efb565f4030__1.jpg', 59958501386),
421(9, 'c56bb7d5f304430b1e5ad520a2e818a4__1.jpg', 89041778168),
422(10, 'c56bb7d5f304430b1e5ad520a2e818a4__2.jpg', 89041778168),
423(11, 'c56bb7d5f304430b1e5ad520a2e818a4__3.jpg', 89041778168),
424(12, '5a28ae0be23192d41aeb7cbceffa764e__1.jpg', 78460143082),
425(13, '8983933f99e7c66898b5bddaefe2eddb__1.jpg', 8858883145),
426(14, '8983933f99e7c66898b5bddaefe2eddb__2.jpg', 8858883145),
427(15, 'bc5a725064f2d8f23ec5df8ae108d852__1.jpg', 50540645999),
428(16, 'bc5a725064f2d8f23ec5df8ae108d852__2.jpg', 50540645999),
429(17, 'bc5a725064f2d8f23ec5df8ae108d852__3.jpg', 50540645999),
430(18, 'bc89e517cf45d787deb2d9ac043e094a__1.jpg', 37558867940),
431(19, 'bc89e517cf45d787deb2d9ac043e094a__2.jpg', 37558867940);
432
433-- --------------------------------------------------------
434
435--
436-- Table structure for table `oglas_tip`
437--
438
439CREATE TABLE IF NOT EXISTS `oglas_tip` (
440 `id` int(11) NOT NULL,
441 `tip` varchar(24) COLLATE utf8_slovenian_ci NOT NULL,
442 PRIMARY KEY (`id`)
443) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_slovenian_ci;
444
445--
446-- Dumping data for table `oglas_tip`
447--
448
449INSERT INTO `oglas_tip` (`id`, `tip`) VALUES
450(1, 'Prodaja'),
451(2, 'Nakup'),
452(3, 'Dražba'),
453(4, 'Podarim');
454
455-- --------------------------------------------------------
456
457--
458-- Table structure for table `ogledano`
459--
460
461CREATE TABLE IF NOT EXISTS `ogledano` (
462 `id` int(11) NOT NULL AUTO_INCREMENT,
463 `fk_oglas` bigint(20) NOT NULL,
464 `fk_uporabnik` bigint(20) DEFAULT NULL,
465 `datum` datetime NOT NULL,
466 PRIMARY KEY (`id`),
467 KEY `fk_oglas` (`fk_oglas`),
468 KEY `fk_uporabnik` (`fk_uporabnik`)
469) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=14 ;
470
471--
472-- Dumping data for table `ogledano`
473--
474
475INSERT INTO `ogledano` (`id`, `fk_oglas`, `fk_uporabnik`, `datum`) VALUES
476(1, 8858883145, 10000000, '2017-01-03 15:07:00'),
477(2, 89041778168, 10000000, '2017-01-01 19:42:00'),
478(3, 59958501386, 10000000, '2017-01-03 14:57:00'),
479(4, 74847607123, 10000000, '2017-01-05 19:25:00'),
480(5, 78460143082, 10000000, '2017-01-04 16:12:00'),
481(6, 749559110187, 10000000, '2017-01-01 22:20:00'),
482(7, 17066749688, 10000000, '2017-01-05 23:12:00'),
483(8, 57234939967, 10000000, '2017-01-05 22:12:00'),
484(9, 50540645999, 10000000, '2017-01-03 15:10:00'),
485(10, 34295178950, 10000000, '2017-01-04 14:58:00'),
486(11, 34295178950, NULL, '2017-01-03 21:21:00'),
487(12, 34295178950, NULL, '2017-01-03 21:21:00'),
488(13, 37558867940, 10000000, '2017-01-05 16:50:00');
489
490-- --------------------------------------------------------
491
492--
493-- Table structure for table `pogovor`
494--
495
496CREATE TABLE IF NOT EXISTS `pogovor` (
497 `id` int(11) NOT NULL AUTO_INCREMENT,
498 `fk_uporabnik1` bigint(20) NOT NULL,
499 `fk_uporabnik2` bigint(20) NOT NULL,
500 PRIMARY KEY (`id`),
501 KEY `fk_uporabnik2` (`fk_uporabnik2`),
502 KEY `fk_uporabnik1` (`fk_uporabnik1`)
503) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
504
505-- --------------------------------------------------------
506
507--
508-- Table structure for table `regije`
509--
510
511CREATE TABLE IF NOT EXISTS `regije` (
512 `id` int(11) NOT NULL,
513 `ime` varchar(32) NOT NULL,
514 PRIMARY KEY (`id`)
515) ENGINE=InnoDB DEFAULT CHARSET=latin1;
516
517--
518-- Dumping data for table `regije`
519--
520
521INSERT INTO `regije` (`id`, `ime`) VALUES
522(0, 'Brez'),
523(1, 'Osrednjeslovenska'),
524(2, 'Podravska'),
525(3, 'Savinjska'),
526(4, 'Goriška'),
527(5, 'Koroška'),
528(6, 'Pomurje'),
529(7, 'Jugovzhodna'),
530(8, 'Zasavska'),
531(9, 'Gorenjska'),
532(10, 'Notranjsko-kraška'),
533(11, 'Obalno-kraška'),
534(12, 'Spodnjeposavska');
535
536-- --------------------------------------------------------
537
538--
539-- Table structure for table `shranjen_oglas`
540--
541
542CREATE TABLE IF NOT EXISTS `shranjen_oglas` (
543 `id` int(11) NOT NULL AUTO_INCREMENT,
544 `fk_uporabnik` bigint(20) NOT NULL,
545 `fk_oglas` bigint(20) NOT NULL,
546 PRIMARY KEY (`id`),
547 KEY `fk_uporabnik` (`fk_uporabnik`),
548 KEY `fk_oglas` (`fk_oglas`)
549) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
550
551-- --------------------------------------------------------
552
553--
554-- Table structure for table `uporabnik`
555--
556
557CREATE TABLE IF NOT EXISTS `uporabnik` (
558 `id` bigint(20) NOT NULL,
559 `email` varchar(32) COLLATE utf8_slovenian_ci NOT NULL,
560 `uporabnisko` varchar(32) COLLATE utf8_slovenian_ci NOT NULL,
561 `ime` varchar(16) COLLATE utf8_slovenian_ci NOT NULL,
562 `priimek` varchar(24) COLLATE utf8_slovenian_ci NOT NULL,
563 `telefon` varchar(14) COLLATE utf8_slovenian_ci NOT NULL,
564 `naslov` varchar(40) COLLATE utf8_slovenian_ci NOT NULL,
565 `kraj` varchar(24) COLLATE utf8_slovenian_ci NOT NULL,
566 `fk_regija` int(11) NOT NULL DEFAULT '0',
567 `ip` varchar(24) COLLATE utf8_slovenian_ci NOT NULL,
568 `datum_registracije` datetime NOT NULL,
569 `last_login` datetime NOT NULL,
570 `geslo` text COLLATE utf8_slovenian_ci NOT NULL,
571 `salt` text COLLATE utf8_slovenian_ci NOT NULL,
572 `profil_ogledi` int(11) NOT NULL DEFAULT '0',
573 PRIMARY KEY (`id`)
574) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_slovenian_ci;
575
576--
577-- Dumping data for table `uporabnik`
578--
579
580INSERT INTO `uporabnik` (`id`, `email`, `uporabnisko`, `ime`, `priimek`, `telefon`, `naslov`, `kraj`, `fk_regija`, `ip`, `datum_registracije`, `last_login`, `geslo`, `salt`, `profil_ogledi`) VALUES
581(10000000, 'tilen1@gmail.com', 'Tilen', 'tilen', 'priimek', '031000000', 'naslov 12', 'maribor', 0, '::1', '2016-12-10 20:44:00', '2017-01-03 21:21:00', 'db9c7d9560b4120be1f9be7364799dece23de77deb2b159c329f9ff09b045bce', '28896038162723414', 4),
582(34822882469, 'kayc2@gmail.com', 'Kayc', 'kajetan', 'priimek', '031000000', 'naslov 14', 'maribor', 0, '::1', '2016-12-22 21:01:00', '2016-12-22 21:01:00', '483cfa3a7dec75a0cf1e62466ca6f5c6296790ee06831977a4e2f3b73a664d61', '78863780307850819', 0),
583(52553600174, 'stumf@gmail.com', 'stumf', 'zan', 'stumberger', '031031031', 'nalsov 13', 'mairbor', 0, '::1', '2016-12-22 22:46:00', '2016-12-22 22:46:00', 'be183cec763abbc7190c17724731052dfad2f8cc2a4671e9c029f6182972b5b8', '15688208181934374', 0),
584(55885178732, 'zist.kajetan@gmail.com', 'kaayc', 'kajetan', 'zist', '031031031', 'naslov 13', 'maribor', 0, '::1', '2016-12-22 22:48:00', '2016-12-22 22:48:00', '9f7cf250a08550cc3bf22ee817a5c292f9aec41d14a86bbc863b7327ab97328c', '31125649893310670', 0),
585(61449182190, 'coask@gmail.com', '', 'asdop', 'aposdk', '031000000', 'nalos 122', 'kraj', 0, '::1', '2016-12-22 21:03:00', '2016-12-22 21:03:00', '2032026b148c4d235baf19c82f55545e49a3707b385e48f3550fdb0af103e51e', '94898784815287726', 0),
586(68212098087, 'zan1@gmail.com', 'Zan', 'zan', 'priimek', '031000000', 'naslov 13', 'maribor', 0, '::1', '2016-12-10 20:52:00', '2016-12-10 20:52:00', 'fadc598dc39e980ad3674291dabec122081b064160ff90bff6777cc885f0543e', '80630991181092839', 0),
587(75107974168, 'oqwpke@gmail.com', 'qwpoemqwe', 'qweqwe', 'qweopkqw', '031000000', 'oewkw 12', 'qwokew', 0, '::1', '2016-12-22 21:05:00', '2016-12-22 21:05:00', '54f37683379a35f5376490ffd557fc0abff8f3758f6c1c75bd3e0beb5fc62550', '58410098370501304', 0);
588
589-- --------------------------------------------------------
590
591--
592-- Table structure for table `zbirka`
593--
594
595CREATE TABLE IF NOT EXISTS `zbirka` (
596 `id` bigint(20) NOT NULL,
597 `fk_kategorija` int(11) DEFAULT NULL,
598 `naslov` varchar(64) COLLATE utf8_slovenian_ci NOT NULL,
599 `opis` text COLLATE utf8_slovenian_ci NOT NULL,
600 `img` varchar(64) CHARACTER SET latin1 DEFAULT NULL,
601 `datum` datetime NOT NULL,
602 PRIMARY KEY (`id`),
603 KEY `fk_kategorija` (`fk_kategorija`)
604) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_slovenian_ci;
605
606--
607-- Dumping data for table `zbirka`
608--
609
610INSERT INTO `zbirka` (`id`, `fk_kategorija`, `naslov`, `opis`, `img`, `datum`) VALUES
611(48074016687, 37, 'Å kornji za zimo', 'Lepi Å¡kornji', '26462de4979729b44264d0c619c9a8df_w.jpg', '2016-12-26 17:19:00'),
612(62652092727, 37, 'Å kornji za zimo', 'Lepi Å¡kornji', '4bdec1e2ded338458b7545e32fc9d489_w.jpg', '2016-12-26 17:19:00'),
613(79124081174, 17, 'OblaÄila', 'Nove obleke', NULL, '2017-01-03 16:02:00');
614
615-- --------------------------------------------------------
616
617--
618-- Table structure for table `zbirka_oglas`
619--
620
621CREATE TABLE IF NOT EXISTS `zbirka_oglas` (
622 `id` int(11) NOT NULL AUTO_INCREMENT,
623 `fk_oglas` bigint(20) NOT NULL,
624 `fk_zbirka` bigint(20) NOT NULL,
625 PRIMARY KEY (`id`),
626 KEY `fk_oglas` (`fk_oglas`),
627 KEY `fk_zbirka` (`fk_zbirka`)
628) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=28 ;
629
630--
631-- Dumping data for table `zbirka_oglas`
632--
633
634INSERT INTO `zbirka_oglas` (`id`, `fk_oglas`, `fk_zbirka`) VALUES
635(19, 59958501386, 48074016687),
636(20, 89041778168, 48074016687),
637(21, 95411386693, 48074016687),
638(22, 59958501386, 62652092727),
639(23, 89041778168, 62652092727),
640(24, 95411386693, 62652092727),
641(25, 50540645999, 79124081174),
642(26, 59958501386, 79124081174),
643(27, 95411386693, 79124081174);
644
645-- --------------------------------------------------------
646
647--
648-- Table structure for table `znamka`
649--
650
651CREATE TABLE IF NOT EXISTS `znamka` (
652 `id` int(11) NOT NULL AUTO_INCREMENT,
653 `naziv` varchar(48) COLLATE utf8_slovenian_ci NOT NULL,
654 PRIMARY KEY (`id`),
655 UNIQUE KEY `naziv` (`naziv`)
656) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_slovenian_ci AUTO_INCREMENT=62 ;
657
658--
659-- Dumping data for table `znamka`
660--
661
662INSERT INTO `znamka` (`id`, `naziv`) VALUES
663(52, 'A-Data'),
664(6, 'Acer'),
665(43, 'ActiveJet'),
666(46, 'AMD'),
667(7, 'AOC'),
668(17, 'Apple'),
669(4, 'Asus'),
670(8, 'BENQ'),
671(31, 'Brother'),
672(28, 'Buffalo'),
673(30, 'Canon'),
674(48, 'Crucial'),
675(24, 'D-Link'),
676(3, 'DELL'),
677(27, 'DrayTek'),
678(33, 'Dymo'),
679(23, 'Edimax'),
680(34, 'Epson'),
681(41, 'Fujitsu'),
682(18, 'Gigabyte'),
683(47, 'Gorenje'),
684(53, 'Hitachi'),
685(9, 'HP'),
686(61, 'IBM'),
687(15, 'iiyama'),
688(54, 'Integral'),
689(19, 'Intel'),
690(55, 'Intenso'),
691(51, 'Kingston'),
692(40, 'Kodak'),
693(38, 'Konica Minolta'),
694(44, 'Kyocera'),
695(10, 'Lenovo'),
696(2, 'LG'),
697(22, 'Linksys'),
698(56, 'Liteon'),
699(16, 'Microsoft'),
700(20, 'MSI'),
701(42, 'Mustek'),
702(11, 'NEC'),
703(26, 'Netgear'),
704(5, 'Philips'),
705(12, 'Samsung'),
706(57, 'SanDisk'),
707(58, 'Seagate'),
708(60, 'Sony'),
709(36, 'Star'),
710(50, 'Toshiba'),
711(21, 'TP-Link'),
712(59, 'Transcend'),
713(25, 'TrendNet'),
714(13, 'Viewsonic'),
715(49, 'WD'),
716(29, 'Xerox'),
717(37, 'Zebra');
718
719-- --------------------------------------------------------
720
721--
722-- Table structure for table `znamka_kategorija`
723--
724
725CREATE TABLE IF NOT EXISTS `znamka_kategorija` (
726 `id` int(11) NOT NULL AUTO_INCREMENT,
727 `fk_znamka` int(11) NOT NULL,
728 `fk_kategorija` int(11) NOT NULL,
729 PRIMARY KEY (`id`),
730 UNIQUE KEY `fk_znamka_2` (`fk_znamka`,`fk_kategorija`),
731 KEY `fk_znamka` (`fk_znamka`,`fk_kategorija`),
732 KEY `fk_kategorjia` (`fk_kategorija`)
733) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_slovenian_ci AUTO_INCREMENT=88 ;
734
735--
736-- Dumping data for table `znamka_kategorija`
737--
738
739INSERT INTO `znamka_kategorija` (`id`, `fk_znamka`, `fk_kategorija`) VALUES
740(1, 2, 11),
741(59, 2, 19),
742(9, 3, 11),
743(33, 3, 12),
744(26, 3, 13),
745(7, 4, 11),
746(32, 4, 12),
747(24, 4, 13),
748(49, 4, 17),
749(16, 5, 11),
750(4, 6, 11),
751(30, 6, 12),
752(27, 6, 13),
753(6, 7, 11),
754(8, 8, 11),
755(10, 9, 11),
756(35, 9, 12),
757(23, 9, 13),
758(50, 9, 17),
759(80, 9, 18),
760(53, 9, 19),
761(19, 10, 11),
762(37, 10, 12),
763(22, 10, 13),
764(15, 11, 11),
765(39, 11, 12),
766(17, 12, 11),
767(56, 12, 19),
768(18, 13, 11),
769(21, 15, 11),
770(29, 16, 13),
771(31, 17, 12),
772(28, 17, 13),
773(34, 18, 12),
774(44, 18, 17),
775(36, 19, 12),
776(70, 19, 16),
777(38, 20, 12),
778(48, 21, 17),
779(45, 22, 17),
780(43, 23, 17),
781(41, 24, 17),
782(47, 25, 17),
783(46, 26, 17),
784(42, 27, 17),
785(40, 28, 17),
786(51, 29, 19),
787(54, 30, 19),
788(55, 31, 19),
789(57, 33, 19),
790(58, 34, 19),
791(60, 36, 19),
792(52, 37, 19),
793(61, 38, 19),
794(62, 40, 19),
795(65, 41, 19),
796(64, 42, 19),
797(67, 43, 19),
798(66, 44, 19),
799(69, 46, 16),
800(71, 47, 41),
801(84, 48, 18),
802(75, 49, 18),
803(72, 50, 13),
804(73, 50, 18),
805(83, 52, 18),
806(81, 53, 18),
807(79, 55, 18),
808(78, 56, 18),
809(76, 57, 18),
810(77, 58, 18),
811(74, 59, 18),
812(85, 60, 13),
813(87, 61, 13);
814
815--
816-- Constraints for dumped tables
817--
818
819--
820-- Constraints for table `drazba`
821--
822ALTER TABLE `drazba`
823 ADD CONSTRAINT `drazba_ibfk_1` FOREIGN KEY (`fk_oglas`) REFERENCES `oglas` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
824
825--
826-- Constraints for table `drazba_vnos`
827--
828ALTER TABLE `drazba_vnos`
829 ADD CONSTRAINT `drazba_vnos_ibfk_1` FOREIGN KEY (`fk_uporabnik`) REFERENCES `uporabnik` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
830 ADD CONSTRAINT `drazba_vnos_ibfk_2` FOREIGN KEY (`fk_drazba`) REFERENCES `drazba` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
831
832--
833-- Constraints for table `fav_kategorija`
834--
835ALTER TABLE `fav_kategorija`
836 ADD CONSTRAINT `fav_kategorija_ibfk_1` FOREIGN KEY (`fk_uporabnik`) REFERENCES `uporabnik` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
837 ADD CONSTRAINT `fav_kategorija_ibfk_2` FOREIGN KEY (`fk_kategorija`) REFERENCES `kategorija` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
838
839--
840-- Constraints for table `kategorija`
841--
842ALTER TABLE `kategorija`
843 ADD CONSTRAINT `kategorija_ibfk_1` FOREIGN KEY (`fk_nadkategorija`) REFERENCES `kategorija` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
844
845--
846-- Constraints for table `msg`
847--
848ALTER TABLE `msg`
849 ADD CONSTRAINT `msg_ibfk_2` FOREIGN KEY (`fk_uporabnik`) REFERENCES `uporabnik` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
850 ADD CONSTRAINT `msg_ibfk_1` FOREIGN KEY (`fk_pogovor`) REFERENCES `pogovor` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
851
852--
853-- Constraints for table `oglas`
854--
855ALTER TABLE `oglas`
856 ADD CONSTRAINT `oglas_ibfk_1` FOREIGN KEY (`fk_uporabnik`) REFERENCES `uporabnik` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
857 ADD CONSTRAINT `oglas_ibfk_2` FOREIGN KEY (`fk_kategorija`) REFERENCES `kategorija` (`id`) ON DELETE SET NULL ON UPDATE SET NULL,
858 ADD CONSTRAINT `oglas_ibfk_3` FOREIGN KEY (`fk_stanje`) REFERENCES `artikel_stanje` (`id`) ON DELETE SET NULL ON UPDATE SET NULL,
859 ADD CONSTRAINT `oglas_ibfk_4` FOREIGN KEY (`fk_oglas_tip`) REFERENCES `oglas_tip` (`id`) ON DELETE SET NULL ON UPDATE SET NULL,
860 ADD CONSTRAINT `oglas_ibfk_5` FOREIGN KEY (`fk_znamka`) REFERENCES `znamka` (`id`) ON DELETE SET NULL ON UPDATE SET NULL,
861 ADD CONSTRAINT `oglas_ibfk_6` FOREIGN KEY (`fk_ohranjenost`) REFERENCES `artikel_ohranjenost` (`id`) ON DELETE SET NULL ON UPDATE SET NULL;
862
863--
864-- Constraints for table `oglas_slika`
865--
866ALTER TABLE `oglas_slika`
867 ADD CONSTRAINT `oglas_slika_ibfk_1` FOREIGN KEY (`fk_oglas`) REFERENCES `oglas` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
868
869--
870-- Constraints for table `ogledano`
871--
872ALTER TABLE `ogledano`
873 ADD CONSTRAINT `ogledano_ibfk_1` FOREIGN KEY (`fk_oglas`) REFERENCES `oglas` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
874 ADD CONSTRAINT `ogledano_ibfk_2` FOREIGN KEY (`fk_uporabnik`) REFERENCES `uporabnik` (`id`) ON DELETE SET NULL ON UPDATE SET NULL;
875
876--
877-- Constraints for table `pogovor`
878--
879ALTER TABLE `pogovor`
880 ADD CONSTRAINT `pogovor_ibfk_2` FOREIGN KEY (`fk_uporabnik2`) REFERENCES `uporabnik` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
881 ADD CONSTRAINT `pogovor_ibfk_1` FOREIGN KEY (`fk_uporabnik1`) REFERENCES `uporabnik` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
882
883--
884-- Constraints for table `shranjen_oglas`
885--
886ALTER TABLE `shranjen_oglas`
887 ADD CONSTRAINT `shranjen_oglas_ibfk_2` FOREIGN KEY (`fk_oglas`) REFERENCES `oglas` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
888 ADD CONSTRAINT `shranjen_oglas_ibfk_1` FOREIGN KEY (`fk_uporabnik`) REFERENCES `uporabnik` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
889
890--
891-- Constraints for table `zbirka`
892--
893ALTER TABLE `zbirka`
894 ADD CONSTRAINT `zbirka_ibfk_1` FOREIGN KEY (`fk_kategorija`) REFERENCES `kategorija` (`id`) ON DELETE SET NULL ON UPDATE SET NULL;
895
896--
897-- Constraints for table `zbirka_oglas`
898--
899ALTER TABLE `zbirka_oglas`
900 ADD CONSTRAINT `zbirka_oglas_ibfk_1` FOREIGN KEY (`fk_oglas`) REFERENCES `oglas` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
901 ADD CONSTRAINT `zbirka_oglas_ibfk_2` FOREIGN KEY (`fk_zbirka`) REFERENCES `zbirka` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
902
903--
904-- Constraints for table `znamka_kategorija`
905--
906ALTER TABLE `znamka_kategorija`
907 ADD CONSTRAINT `znamka_kategorija_ibfk_1` FOREIGN KEY (`fk_znamka`) REFERENCES `znamka` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
908 ADD CONSTRAINT `znamka_kategorija_ibfk_2` FOREIGN KEY (`fk_kategorija`) REFERENCES `kategorija` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
909
910/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
911/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
912/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;