-- phpMyAdmin SQL Dump
-- version 4.1.14
-- http://www.phpmyadmin.net
--
-- Host: 127.0.0.1
-- Generation Time: Jan 05, 2017 at 10:42 PM
-- Server version: 5.6.17
-- PHP Version: 5.5.12

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Database: `prodaja`
--

-- --------------------------------------------------------

--
-- Table structure for table `artikel_ohranjenost`
--

CREATE TABLE IF NOT EXISTS `artikel_ohranjenost` (
  `id` int(11) NOT NULL,
  `naziv` varchar(32) COLLATE utf8_slovenian_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_slovenian_ci;

--
-- Dumping data for table `artikel_ohranjenost`
--

INSERT INTO `artikel_ohranjenost` (`id`, `naziv`) VALUES
(1, 'Kot novo'),
(2, 'Odlično ohranjeno'),
(3, 'Dobro ohranjeno'),
(4, 'Zmerno ohranjeno'),
(5, 'Slabo ohranjeno');

-- --------------------------------------------------------

--
-- Table structure for table `artikel_stanje`
--

CREATE TABLE IF NOT EXISTS `artikel_stanje` (
  `id` int(11) NOT NULL,
  `stanje` varchar(16) COLLATE utf8_slovenian_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_slovenian_ci;

--
-- Dumping data for table `artikel_stanje`
--

INSERT INTO `artikel_stanje` (`id`, `stanje`) VALUES
(1, 'Novo'),
(2, 'Rabljeno');

-- --------------------------------------------------------

--
-- Table structure for table `drazba`
--

CREATE TABLE IF NOT EXISTS `drazba` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `fk_oglas` bigint(20) NOT NULL,
  `trenutna_cena` float NOT NULL,
  `datum_konca` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `fk_oglas` (`fk_oglas`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `drazba`
--

INSERT INTO `drazba` (`id`, `fk_oglas`, `trenutna_cena`, `datum_konca`) VALUES
(1, 34295178950, 10009, '2017-01-17 16:55:00');

-- --------------------------------------------------------

--
-- Table structure for table `drazba_vnos`
--

CREATE TABLE IF NOT EXISTS `drazba_vnos` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `datum` datetime NOT NULL,
  `fk_uporabnik` bigint(20) NOT NULL,
  `fk_drazba` int(11) NOT NULL,
  `cena` float NOT NULL,
  PRIMARY KEY (`id`),
  KEY `fk_uporabnik` (`fk_uporabnik`),
  KEY `fk_drazba` (`fk_drazba`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=80 ;

--
-- Dumping data for table `drazba_vnos`
--

INSERT INTO `drazba_vnos` (`id`, `datum`, `fk_uporabnik`, `fk_drazba`, `cena`) VALUES
(1, '2017-01-03 20:57:00', 10000000, 1, 102),
(4, '2017-01-03 21:00:00', 10000000, 1, 102),
(5, '2017-01-03 21:01:00', 10000000, 1, 103),
(6, '2017-01-03 21:01:00', 10000000, 1, 104),
(7, '2017-01-03 21:01:00', 10000000, 1, 105),
(8, '2017-01-03 21:01:00', 10000000, 1, 106),
(9, '2017-01-03 21:02:00', 10000000, 1, 107),
(10, '2017-01-03 21:03:00', 10000000, 1, 108),
(11, '2017-01-03 21:04:00', 10000000, 1, 109),
(12, '2017-01-03 21:04:00', 10000000, 1, 110),
(13, '2017-01-03 21:04:00', 10000000, 1, 111),
(14, '2017-01-03 21:13:00', 10000000, 1, 122),
(15, '2017-01-03 21:14:00', 10000000, 1, 123),
(16, '2017-01-03 21:14:00', 10000000, 1, 124),
(17, '2017-01-03 21:19:00', 10000000, 1, 125),
(18, '2017-01-03 21:19:00', 10000000, 1, 126),
(19, '2017-01-03 21:20:00', 10000000, 1, 127),
(20, '2017-01-03 21:20:00', 10000000, 1, 129),
(21, '2017-01-03 21:21:00', 10000000, 1, 130),
(22, '2017-01-03 21:22:00', 10000000, 1, 131),
(23, '2017-01-03 21:22:00', 10000000, 1, 132),
(24, '2017-01-03 21:22:00', 10000000, 1, 133),
(25, '2017-01-03 21:23:00', 10000000, 1, 150),
(26, '2017-01-03 21:24:00', 10000000, 1, 151),
(27, '2017-01-03 21:25:00', 10000000, 1, 152),
(28, '2017-01-03 21:26:00', 10000000, 1, 153),
(29, '2017-01-03 21:34:00', 10000000, 1, 154),
(30, '2017-01-03 21:35:00', 10000000, 1, 155),
(31, '2017-01-03 21:35:00', 10000000, 1, 156),
(32, '2017-01-03 21:35:00', 10000000, 1, 157),
(33, '2017-01-03 21:37:00', 10000000, 1, 158),
(34, '2017-01-03 21:39:00', 10000000, 1, 158.2),
(35, '2017-01-03 21:46:00', 10000000, 1, 159.2),
(36, '2017-01-03 21:49:00', 10000000, 1, 160.2),
(37, '2017-01-03 21:54:00', 10000000, 1, 161.2),
(38, '2017-01-03 21:55:00', 10000000, 1, 162.2),
(39, '2017-01-03 21:55:00', 10000000, 1, 163.2),
(40, '2017-01-03 21:56:00', 10000000, 1, 164.2),
(41, '2017-01-03 20:57:00', 10000000, 1, 102),
(42, '2017-01-03 21:58:00', 10000000, 1, 165.2),
(43, '2017-01-03 21:58:00', 10000000, 1, 166.2),
(44, '2017-01-03 21:59:00', 10000000, 1, 167.2),
(45, '2017-01-03 21:59:00', 10000000, 1, 168.2),
(46, '2017-01-03 21:59:00', 10000000, 1, 169.2),
(47, '2017-01-03 21:59:00', 10000000, 1, 170.2),
(48, '2017-01-03 21:59:00', 10000000, 1, 180),
(49, '2017-01-03 22:00:00', 10000000, 1, 181),
(50, '2017-01-03 22:02:00', 10000000, 1, 182),
(51, '2017-01-04 00:00:00', 10000000, 1, 183),
(52, '2017-01-04 00:08:00', 10000000, 1, 184),
(53, '2017-01-04 00:13:00', 10000000, 1, 185),
(54, '2017-01-04 00:32:00', 10000000, 1, 186),
(55, '2017-01-04 02:05:00', 10000000, 1, 187),
(56, '2017-01-04 02:05:00', 10000000, 1, 188),
(57, '2017-01-04 02:05:00', 10000000, 1, 189),
(58, '2017-01-04 02:05:00', 10000000, 1, 190),
(59, '2017-01-04 02:06:00', 10000000, 1, 191),
(60, '2017-01-04 02:12:00', 10000000, 1, 192),
(61, '2017-01-04 02:12:00', 10000000, 1, 193),
(62, '2017-01-04 02:22:00', 10000000, 1, 194),
(63, '2017-01-04 02:25:00', 10000000, 1, 195),
(64, '2017-01-04 02:25:00', 10000000, 1, 196),
(65, '2017-01-04 02:25:00', 10000000, 1, 197),
(66, '2017-01-04 02:25:00', 10000000, 1, 198),
(67, '2017-01-04 02:25:00', 10000000, 1, 199),
(68, '2017-01-04 02:25:00', 10000000, 1, 200),
(69, '2017-01-04 02:26:00', 10000000, 1, 2010),
(70, '2017-01-04 02:26:00', 10000000, 1, 10000),
(71, '2017-01-04 02:26:00', 10000000, 1, 10001),
(72, '2017-01-04 02:26:00', 10000000, 1, 10002),
(73, '2017-01-04 02:26:00', 10000000, 1, 10003),
(74, '2017-01-04 02:26:00', 10000000, 1, 10004),
(75, '2017-01-04 13:48:00', 10000000, 1, 10005),
(76, '2017-01-04 14:29:00', 10000000, 1, 10006),
(77, '2017-01-04 14:30:00', 10000000, 1, 10007),
(78, '2017-01-04 14:44:00', 10000000, 1, 10008),
(79, '2017-01-04 14:45:00', 10000000, 1, 10009);

-- --------------------------------------------------------

--
-- Table structure for table `fav_kategorija`
--

CREATE TABLE IF NOT EXISTS `fav_kategorija` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `fk_uporabnik` bigint(20) NOT NULL,
  `fk_kategorija` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `fk_uporabnik` (`fk_uporabnik`),
  KEY `fk_kategorija` (`fk_kategorija`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=30 ;

--
-- Dumping data for table `fav_kategorija`
--

INSERT INTO `fav_kategorija` (`id`, `fk_uporabnik`, `fk_kategorija`) VALUES
(27, 10000000, 68),
(28, 10000000, 11),
(29, 10000000, 36);

-- --------------------------------------------------------

--
-- Table structure for table `kategorija`
--

CREATE TABLE IF NOT EXISTS `kategorija` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `fk_nadkategorija` int(11) DEFAULT NULL,
  `naziv` varchar(64) COLLATE utf8_slovenian_ci NOT NULL,
  `ico` varchar(32) COLLATE utf8_slovenian_ci NOT NULL,
  `red` smallint(6) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `fk_nadkategorija` (`fk_nadkategorija`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_slovenian_ci AUTO_INCREMENT=72 ;

--
-- Dumping data for table `kategorija`
--

INSERT INTO `kategorija` (`id`, `fk_nadkategorija`, `naziv`, `ico`, `red`) VALUES
(1, NULL, 'Računalništvo in telefonija', 'devices', 0),
(2, NULL, 'Avdio-video in foto', 'camera', 0),
(3, NULL, 'Osebna nega in zdravje', 'bubble_chart', 0),
(4, NULL, 'Glasba in glasbila', 'audiotrack', 0),
(5, NULL, 'Oblačila in obutev', 'wc', 0),
(6, NULL, 'Storitve', 'accessibility', 0),
(7, NULL, 'Orodja in stroji', 'build', 0),
(8, NULL, 'Hobi in zbirateljstvo', 'schedule', 0),
(9, NULL, 'Živali', 'pets', 0),
(10, NULL, 'Dom in vrt', 'home', 0),
(11, 1, 'Monitorji', '11', 7),
(12, 1, 'Namizni računalniki', '12', 9),
(13, 1, 'Prenosni računalniki', '13', 8),
(14, 1, 'Ohišja, napajalniki', '14', 0),
(15, 1, 'Tipkovnice, miške', '15', 6),
(16, 1, 'Procesorji', '16', 0),
(17, 1, 'Mrežna oprema', '17', 0),
(18, 1, 'Shramba podatkov', '18', 0),
(19, 1, 'Tiskalniki, skenerji', '19', 4),
(20, 2, 'Zvočniki, slušalke, mikrofoni', '20', 0),
(21, 1, 'Strežniki in oprema', '21', 0),
(22, 1, 'Računalniške komponente', '22', 0),
(23, 1, 'Telefoni', '23', 10),
(24, 1, 'Telefaksi', '24', 0),
(25, 1, 'Tablice', '25', 5),
(26, 2, 'Fotoaparati', '26', 0),
(27, 2, 'Fotografksa oprema', '27', 0),
(28, 2, 'Projektorji', '28', 0),
(29, 2, 'Optika', '29', 0),
(30, 2, 'Snemalna oprema', '30', 0),
(31, NULL, 'Valute in dragocene kovine', 'euro_symbol', 0),
(32, 4, 'Glasbena oprema', '32', 0),
(33, 4, 'Glasbila', '33', 0),
(34, 5, 'Moška oblačila', '34', 0),
(35, 5, 'Ženska oblačila', '35', 0),
(36, 5, 'Otroška oblačila', '36', 0),
(37, 5, 'Obutev', '37', 0),
(38, 5, 'Športna oblačila', '38', 0),
(39, 5, 'Ročne ure in nakit', '39', 0),
(40, 10, 'Gradnja', '40', 0),
(41, 10, 'Bela tehnika', '41', 0),
(42, 10, 'Dnevne sobe', '42', 0),
(43, 10, 'Kopalnice', '43', 0),
(44, 10, 'Kuhinje', '44', 0),
(45, 10, 'Spalnice', '45', 0),
(46, 10, 'Svetila', '46', 0),
(47, 10, 'Vrtna oprema', '47', 0),
(48, 2, 'Filmi', '48', 0),
(49, 2, 'TV sprejemniki, televizija', '49', 0),
(52, 3, 'Lepota', '52', 0),
(53, 3, 'Zdravje', '53', 0),
(54, 3, 'Dobro počutje', '54', 0),
(55, 5, 'Pust, maškarada', '55', 0),
(56, 7, 'Akumulatorji, baterije, polnilci', '56', 0),
(57, 7, 'Električno orodje', '57', 0),
(58, 7, 'Ročno orodje', '58', 0),
(59, 7, 'Merila', '59', 0),
(60, 7, 'Stroji', '60', 0),
(61, 8, 'Hobi', '61', 0),
(62, 8, 'Zbirateljstvo', '62', 0),
(63, 8, 'Umetnine', '63', 0),
(64, 8, 'Starine', '64', 0),
(65, 9, 'Ljubljenčki', '65', 0),
(66, 9, 'Rejne živali', '66', 0),
(67, 9, 'Živalska oprema', '67', 0),
(68, 1, 'Gaming', '68', 2),
(69, NULL, 'Igrače in otroška oprema', 'child_friendly', 0),
(70, 1, 'Telefonska oprema in pripomočki', '70', 3),
(71, 5, 'Torbe in pripomočki', '39', 0);

-- --------------------------------------------------------

--
-- Table structure for table `msg`
--

CREATE TABLE IF NOT EXISTS `msg` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `fk_uporabnik` bigint(20) NOT NULL,
  `fk_pogovor` int(11) NOT NULL,
  `text` text NOT NULL,
  `datum` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `fk_pogovor` (`fk_pogovor`),
  KEY `fk_uporabnik` (`fk_uporabnik`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `oglas`
--

CREATE TABLE IF NOT EXISTS `oglas` (
  `id` bigint(20) NOT NULL,
  `naslov` varchar(128) COLLATE utf8_slovenian_ci NOT NULL,
  `opis` text COLLATE utf8_slovenian_ci NOT NULL,
  `fk_oglas_tip` int(11) DEFAULT NULL,
  `cena` float NOT NULL,
  `cena_pred_popustom` float NOT NULL DEFAULT '-1',
  `postnina_vkljucena` tinyint(1) NOT NULL DEFAULT '0',
  `fk_uporabnik` bigint(20) DEFAULT NULL,
  `fk_podjetje` bigint(20) DEFAULT NULL,
  `fk_kategorija` int(11) DEFAULT NULL,
  `fk_stanje` int(11) DEFAULT NULL,
  `fk_ohranjenost` int(11) DEFAULT NULL,
  `datum` datetime NOT NULL,
  `fk_znamka` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `fk_kategorija` (`fk_kategorija`),
  KEY `fk_uporabnik` (`fk_uporabnik`),
  KEY `fk_oglas_tip` (`fk_oglas_tip`),
  KEY `fk_stanje` (`fk_stanje`),
  KEY `fk_znamka` (`fk_znamka`),
  KEY `fk_ohranjenost` (`fk_ohranjenost`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_slovenian_ci;

--
-- Dumping data for table `oglas`
--

INSERT 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
(1683166449, 'Kupim monitor', 'asdasdasd', 2, 123, 0, 0, 10000000, NULL, 11, 1, NULL, '2016-12-26 18:41:00', 8),
(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),
(12884594619, 'swag', 'qwhhmstjr,mzmkzj', 2, 12, 0, 1, 10000000, NULL, 68, 1, NULL, '2016-12-22 21:49:00', NULL),
(17066749688, 'qweqweqwe', 'qweqweqwe', 1, 1233, -1, 0, 10000000, NULL, 26, 1, NULL, '2017-01-03 13:50:00', NULL),
(20031686523, 'swag', 'qwhhmstjr,mzmkzj', 2, 12, 0, 1, 10000000, NULL, 68, 1, NULL, '2016-12-22 21:49:00', NULL),
(28801676345, 'qweqweqwe', 'qweqweqweqwe', 2, -1, 0, 1, 10000000, NULL, 11, 1, NULL, '2016-12-26 18:44:00', 12),
(29288908190, 'hladnilnik', 'sfukan', 1, 123, 0, 0, 10000000, NULL, 17, 2, 5, '2016-12-22 21:08:00', 24),
(34295178950, 'Drazba test', 'test', 3, 100, -1, 0, 10000000, NULL, 55, 1, NULL, '2017-01-03 18:55:00', NULL),
(34457118362, 'swag', 'qwhhmstjr,mzmkzj', 2, 12, 0, 1, 10000000, NULL, 68, 1, NULL, '2016-12-22 21:49:00', NULL),
(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),
(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),
(41713111699, 'hladnilnasdin', 'asdokasodk', 1, 15, 0, 0, 10000000, NULL, 68, 2, 2, '2016-12-22 21:32:00', NULL),
(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),
(47439900894, 'awfawf', 'afawfa', 1, 122, 0, 0, 10000000, NULL, 68, 1, NULL, '2016-12-22 21:56:00', NULL),
(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),
(50859800978, 'swag', 'qwhhmstjr,mzmkzj', 2, 12, 0, 1, 10000000, NULL, 68, 1, NULL, '2016-12-22 21:49:00', NULL),
(57234939967, 'swag', 'awfaw', 1, 12, 0, 0, 10000000, NULL, 1, 1, NULL, '2016-12-22 21:57:00', NULL),
(59275224985, 'hadilnik', 'zjeban', 1, 112, 0, 0, 10000000, NULL, 17, 2, 5, '2016-12-22 20:55:00', 24),
(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),
(60585573030, 'swag', 'qwhhmstjr,mzmkzj', 2, 12, 0, 1, 10000000, NULL, 68, 1, NULL, '2016-12-22 21:49:00', NULL),
(68505406459, 'swag', 'qwhhmstjr,mzmkzj', 2, 12, 0, 1, 10000000, NULL, 68, 1, NULL, '2016-12-22 21:49:00', NULL),
(70497502484, 'swag', 'qwhhmstjr,mzmkzj', 2, 12, 0, 1, 10000000, NULL, 68, 1, NULL, '2016-12-22 21:49:00', NULL),
(74847607123, 'fegeg', 'wgwegwegwegweg', 1, 12, 0, 0, 55885178732, NULL, 68, 1, NULL, '2016-12-22 22:49:00', NULL),
(74955981011, 'test', 'test', 1, 12, 0, 0, 10000000, NULL, 11, 2, NULL, '2016-12-17 13:31:00', 3),
(74955981012, 'test', 'test', 1, 12, 0, 0, 10000000, NULL, 11, 2, NULL, '2016-12-17 13:31:00', 3),
(74955981013, 'test', 'test', 1, 12, 0, 0, 10000000, NULL, 11, 2, NULL, '2016-12-17 13:31:00', 3),
(74955981014, 'test', 'test', 1, 12, 0, 0, 10000000, NULL, 11, 2, NULL, '2016-12-17 13:31:00', 3),
(74955981015, 'test', 'test', 1, 12, 0, 0, 10000000, NULL, 11, 2, NULL, '2016-12-17 13:31:00', 3),
(74955981016, 'test', 'test', 1, 12, 0, 0, 10000000, NULL, 11, 2, NULL, '2016-12-17 13:31:00', 3),
(74955981017, 'test', 'test', 1, 12, 0, 0, 10000000, NULL, 11, 2, NULL, '2016-12-17 13:31:00', 3),
(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),
(80346558888, 'qweqwe', 'qweqwe', 1, 123, 0, 0, 10000000, NULL, 68, 2, 4, '2016-12-18 18:02:00', NULL),
(80701313008, 'qweqwe', 'qweqwe', 1, 123, 0, 0, 10000000, NULL, 21, 2, NULL, '2016-12-17 23:37:00', NULL),
(88714409822, '123123', '123123', 3, 123, 0, 0, 10000000, NULL, 55, 2, 2, '2016-12-26 23:54:00', NULL),
(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),
(91111228291, 'swag', 'qwhhmstjr,mzmkzj', 2, 12, 0, 1, 10000000, NULL, 68, 1, NULL, '2016-12-22 21:49:00', NULL),
(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),
(99342951789, 'swag', 'qwhhmstjr,mzmkzj', 2, 12, 0, 1, 10000000, NULL, 68, 1, NULL, '2016-12-22 21:49:00', NULL),
(749559110127, 'test', 'test', 1, 12, 0, 0, 10000000, NULL, 11, 2, NULL, '2016-12-23 13:31:00', 3),
(749559110187, 'test', 'test', 1, 12, 0, 0, 10000000, NULL, 11, 2, NULL, '2016-12-17 13:31:00', 3),
(749559810187, 'test', 'test', 1, 12, 0, 0, 10000000, NULL, 11, 2, NULL, '2016-12-17 13:31:00', 3);

-- --------------------------------------------------------

--
-- Table structure for table `oglas_slika`
--

CREATE TABLE IF NOT EXISTS `oglas_slika` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `cdn` varchar(64) COLLATE utf8_slovenian_ci NOT NULL,
  `fk_oglas` bigint(20) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `fk_oglas` (`fk_oglas`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_slovenian_ci AUTO_INCREMENT=20 ;

--
-- Dumping data for table `oglas_slika`
--

INSERT INTO `oglas_slika` (`id`, `cdn`, `fk_oglas`) VALUES
(1, 'd27dec0c9fb4df0d90670318586318e5__1.jpg', 38010905964),
(4, '28cc90ecae4f3690a5d4eda81882e434__1.jpg', 42282104886),
(5, '28cc90ecae4f3690a5d4eda81882e434__2.jpg', 42282104886),
(6, '292c8f81ec0c98dedbe34307fbf81270__1.jpg', 95411386693),
(7, '74331c23a99f0e2854532efb565f4030__1.jpg', 59958501386),
(9, 'c56bb7d5f304430b1e5ad520a2e818a4__1.jpg', 89041778168),
(10, 'c56bb7d5f304430b1e5ad520a2e818a4__2.jpg', 89041778168),
(11, 'c56bb7d5f304430b1e5ad520a2e818a4__3.jpg', 89041778168),
(12, '5a28ae0be23192d41aeb7cbceffa764e__1.jpg', 78460143082),
(13, '8983933f99e7c66898b5bddaefe2eddb__1.jpg', 8858883145),
(14, '8983933f99e7c66898b5bddaefe2eddb__2.jpg', 8858883145),
(15, 'bc5a725064f2d8f23ec5df8ae108d852__1.jpg', 50540645999),
(16, 'bc5a725064f2d8f23ec5df8ae108d852__2.jpg', 50540645999),
(17, 'bc5a725064f2d8f23ec5df8ae108d852__3.jpg', 50540645999),
(18, 'bc89e517cf45d787deb2d9ac043e094a__1.jpg', 37558867940),
(19, 'bc89e517cf45d787deb2d9ac043e094a__2.jpg', 37558867940);

-- --------------------------------------------------------

--
-- Table structure for table `oglas_tip`
--

CREATE TABLE IF NOT EXISTS `oglas_tip` (
  `id` int(11) NOT NULL,
  `tip` varchar(24) COLLATE utf8_slovenian_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_slovenian_ci;

--
-- Dumping data for table `oglas_tip`
--

INSERT INTO `oglas_tip` (`id`, `tip`) VALUES
(1, 'Prodaja'),
(2, 'Nakup'),
(3, 'Dražba'),
(4, 'Podarim');

-- --------------------------------------------------------

--
-- Table structure for table `ogledano`
--

CREATE TABLE IF NOT EXISTS `ogledano` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `fk_oglas` bigint(20) NOT NULL,
  `fk_uporabnik` bigint(20) DEFAULT NULL,
  `datum` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `fk_oglas` (`fk_oglas`),
  KEY `fk_uporabnik` (`fk_uporabnik`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=14 ;

--
-- Dumping data for table `ogledano`
--

INSERT INTO `ogledano` (`id`, `fk_oglas`, `fk_uporabnik`, `datum`) VALUES
(1, 8858883145, 10000000, '2017-01-03 15:07:00'),
(2, 89041778168, 10000000, '2017-01-01 19:42:00'),
(3, 59958501386, 10000000, '2017-01-03 14:57:00'),
(4, 74847607123, 10000000, '2017-01-05 19:25:00'),
(5, 78460143082, 10000000, '2017-01-04 16:12:00'),
(6, 749559110187, 10000000, '2017-01-01 22:20:00'),
(7, 17066749688, 10000000, '2017-01-05 23:12:00'),
(8, 57234939967, 10000000, '2017-01-05 22:12:00'),
(9, 50540645999, 10000000, '2017-01-03 15:10:00'),
(10, 34295178950, 10000000, '2017-01-04 14:58:00'),
(11, 34295178950, NULL, '2017-01-03 21:21:00'),
(12, 34295178950, NULL, '2017-01-03 21:21:00'),
(13, 37558867940, 10000000, '2017-01-05 16:50:00');

-- --------------------------------------------------------

--
-- Table structure for table `pogovor`
--

CREATE TABLE IF NOT EXISTS `pogovor` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `fk_uporabnik1` bigint(20) NOT NULL,
  `fk_uporabnik2` bigint(20) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `fk_uporabnik2` (`fk_uporabnik2`),
  KEY `fk_uporabnik1` (`fk_uporabnik1`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `regije`
--

CREATE TABLE IF NOT EXISTS `regije` (
  `id` int(11) NOT NULL,
  `ime` varchar(32) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `regije`
--

INSERT INTO `regije` (`id`, `ime`) VALUES
(0, 'Brez'),
(1, 'Osrednjeslovenska'),
(2, 'Podravska'),
(3, 'Savinjska'),
(4, 'Goriška'),
(5, 'Koroška'),
(6, 'Pomurje'),
(7, 'Jugovzhodna'),
(8, 'Zasavska'),
(9, 'Gorenjska'),
(10, 'Notranjsko-kraška'),
(11, 'Obalno-kraška'),
(12, 'Spodnjeposavska');

-- --------------------------------------------------------

--
-- Table structure for table `shranjen_oglas`
--

CREATE TABLE IF NOT EXISTS `shranjen_oglas` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `fk_uporabnik` bigint(20) NOT NULL,
  `fk_oglas` bigint(20) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `fk_uporabnik` (`fk_uporabnik`),
  KEY `fk_oglas` (`fk_oglas`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `uporabnik`
--

CREATE TABLE IF NOT EXISTS `uporabnik` (
  `id` bigint(20) NOT NULL,
  `email` varchar(32) COLLATE utf8_slovenian_ci NOT NULL,
  `uporabnisko` varchar(32) COLLATE utf8_slovenian_ci NOT NULL,
  `ime` varchar(16) COLLATE utf8_slovenian_ci NOT NULL,
  `priimek` varchar(24) COLLATE utf8_slovenian_ci NOT NULL,
  `telefon` varchar(14) COLLATE utf8_slovenian_ci NOT NULL,
  `naslov` varchar(40) COLLATE utf8_slovenian_ci NOT NULL,
  `kraj` varchar(24) COLLATE utf8_slovenian_ci NOT NULL,
  `fk_regija` int(11) NOT NULL DEFAULT '0',
  `ip` varchar(24) COLLATE utf8_slovenian_ci NOT NULL,
  `datum_registracije` datetime NOT NULL,
  `last_login` datetime NOT NULL,
  `geslo` text COLLATE utf8_slovenian_ci NOT NULL,
  `salt` text COLLATE utf8_slovenian_ci NOT NULL,
  `profil_ogledi` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_slovenian_ci;

--
-- Dumping data for table `uporabnik`
--

INSERT INTO `uporabnik` (`id`, `email`, `uporabnisko`, `ime`, `priimek`, `telefon`, `naslov`, `kraj`, `fk_regija`, `ip`, `datum_registracije`, `last_login`, `geslo`, `salt`, `profil_ogledi`) VALUES
(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),
(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),
(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),
(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),
(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),
(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),
(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);

-- --------------------------------------------------------

--
-- Table structure for table `zbirka`
--

CREATE TABLE IF NOT EXISTS `zbirka` (
  `id` bigint(20) NOT NULL,
  `fk_kategorija` int(11) DEFAULT NULL,
  `naslov` varchar(64) COLLATE utf8_slovenian_ci NOT NULL,
  `opis` text COLLATE utf8_slovenian_ci NOT NULL,
  `img` varchar(64) CHARACTER SET latin1 DEFAULT NULL,
  `datum` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `fk_kategorija` (`fk_kategorija`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_slovenian_ci;

--
-- Dumping data for table `zbirka`
--

INSERT INTO `zbirka` (`id`, `fk_kategorija`, `naslov`, `opis`, `img`, `datum`) VALUES
(48074016687, 37, 'Škornji za zimo', 'Lepi škornji', '26462de4979729b44264d0c619c9a8df_w.jpg', '2016-12-26 17:19:00'),
(62652092727, 37, 'Škornji za zimo', 'Lepi škornji', '4bdec1e2ded338458b7545e32fc9d489_w.jpg', '2016-12-26 17:19:00'),
(79124081174, 17, 'Oblačila', 'Nove obleke', NULL, '2017-01-03 16:02:00');

-- --------------------------------------------------------

--
-- Table structure for table `zbirka_oglas`
--

CREATE TABLE IF NOT EXISTS `zbirka_oglas` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `fk_oglas` bigint(20) NOT NULL,
  `fk_zbirka` bigint(20) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `fk_oglas` (`fk_oglas`),
  KEY `fk_zbirka` (`fk_zbirka`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=28 ;

--
-- Dumping data for table `zbirka_oglas`
--

INSERT INTO `zbirka_oglas` (`id`, `fk_oglas`, `fk_zbirka`) VALUES
(19, 59958501386, 48074016687),
(20, 89041778168, 48074016687),
(21, 95411386693, 48074016687),
(22, 59958501386, 62652092727),
(23, 89041778168, 62652092727),
(24, 95411386693, 62652092727),
(25, 50540645999, 79124081174),
(26, 59958501386, 79124081174),
(27, 95411386693, 79124081174);

-- --------------------------------------------------------

--
-- Table structure for table `znamka`
--

CREATE TABLE IF NOT EXISTS `znamka` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `naziv` varchar(48) COLLATE utf8_slovenian_ci NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `naziv` (`naziv`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_slovenian_ci AUTO_INCREMENT=62 ;

--
-- Dumping data for table `znamka`
--

INSERT INTO `znamka` (`id`, `naziv`) VALUES
(52, 'A-Data'),
(6, 'Acer'),
(43, 'ActiveJet'),
(46, 'AMD'),
(7, 'AOC'),
(17, 'Apple'),
(4, 'Asus'),
(8, 'BENQ'),
(31, 'Brother'),
(28, 'Buffalo'),
(30, 'Canon'),
(48, 'Crucial'),
(24, 'D-Link'),
(3, 'DELL'),
(27, 'DrayTek'),
(33, 'Dymo'),
(23, 'Edimax'),
(34, 'Epson'),
(41, 'Fujitsu'),
(18, 'Gigabyte'),
(47, 'Gorenje'),
(53, 'Hitachi'),
(9, 'HP'),
(61, 'IBM'),
(15, 'iiyama'),
(54, 'Integral'),
(19, 'Intel'),
(55, 'Intenso'),
(51, 'Kingston'),
(40, 'Kodak'),
(38, 'Konica Minolta'),
(44, 'Kyocera'),
(10, 'Lenovo'),
(2, 'LG'),
(22, 'Linksys'),
(56, 'Liteon'),
(16, 'Microsoft'),
(20, 'MSI'),
(42, 'Mustek'),
(11, 'NEC'),
(26, 'Netgear'),
(5, 'Philips'),
(12, 'Samsung'),
(57, 'SanDisk'),
(58, 'Seagate'),
(60, 'Sony'),
(36, 'Star'),
(50, 'Toshiba'),
(21, 'TP-Link'),
(59, 'Transcend'),
(25, 'TrendNet'),
(13, 'Viewsonic'),
(49, 'WD'),
(29, 'Xerox'),
(37, 'Zebra');

-- --------------------------------------------------------

--
-- Table structure for table `znamka_kategorija`
--

CREATE TABLE IF NOT EXISTS `znamka_kategorija` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `fk_znamka` int(11) NOT NULL,
  `fk_kategorija` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `fk_znamka_2` (`fk_znamka`,`fk_kategorija`),
  KEY `fk_znamka` (`fk_znamka`,`fk_kategorija`),
  KEY `fk_kategorjia` (`fk_kategorija`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_slovenian_ci AUTO_INCREMENT=88 ;

--
-- Dumping data for table `znamka_kategorija`
--

INSERT INTO `znamka_kategorija` (`id`, `fk_znamka`, `fk_kategorija`) VALUES
(1, 2, 11),
(59, 2, 19),
(9, 3, 11),
(33, 3, 12),
(26, 3, 13),
(7, 4, 11),
(32, 4, 12),
(24, 4, 13),
(49, 4, 17),
(16, 5, 11),
(4, 6, 11),
(30, 6, 12),
(27, 6, 13),
(6, 7, 11),
(8, 8, 11),
(10, 9, 11),
(35, 9, 12),
(23, 9, 13),
(50, 9, 17),
(80, 9, 18),
(53, 9, 19),
(19, 10, 11),
(37, 10, 12),
(22, 10, 13),
(15, 11, 11),
(39, 11, 12),
(17, 12, 11),
(56, 12, 19),
(18, 13, 11),
(21, 15, 11),
(29, 16, 13),
(31, 17, 12),
(28, 17, 13),
(34, 18, 12),
(44, 18, 17),
(36, 19, 12),
(70, 19, 16),
(38, 20, 12),
(48, 21, 17),
(45, 22, 17),
(43, 23, 17),
(41, 24, 17),
(47, 25, 17),
(46, 26, 17),
(42, 27, 17),
(40, 28, 17),
(51, 29, 19),
(54, 30, 19),
(55, 31, 19),
(57, 33, 19),
(58, 34, 19),
(60, 36, 19),
(52, 37, 19),
(61, 38, 19),
(62, 40, 19),
(65, 41, 19),
(64, 42, 19),
(67, 43, 19),
(66, 44, 19),
(69, 46, 16),
(71, 47, 41),
(84, 48, 18),
(75, 49, 18),
(72, 50, 13),
(73, 50, 18),
(83, 52, 18),
(81, 53, 18),
(79, 55, 18),
(78, 56, 18),
(76, 57, 18),
(77, 58, 18),
(74, 59, 18),
(85, 60, 13),
(87, 61, 13);

--
-- Constraints for dumped tables
--

--
-- Constraints for table `drazba`
--
ALTER TABLE `drazba`
  ADD CONSTRAINT `drazba_ibfk_1` FOREIGN KEY (`fk_oglas`) REFERENCES `oglas` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `drazba_vnos`
--
ALTER TABLE `drazba_vnos`
  ADD CONSTRAINT `drazba_vnos_ibfk_1` FOREIGN KEY (`fk_uporabnik`) REFERENCES `uporabnik` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `drazba_vnos_ibfk_2` FOREIGN KEY (`fk_drazba`) REFERENCES `drazba` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `fav_kategorija`
--
ALTER TABLE `fav_kategorija`
  ADD CONSTRAINT `fav_kategorija_ibfk_1` FOREIGN KEY (`fk_uporabnik`) REFERENCES `uporabnik` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `fav_kategorija_ibfk_2` FOREIGN KEY (`fk_kategorija`) REFERENCES `kategorija` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `kategorija`
--
ALTER TABLE `kategorija`
  ADD CONSTRAINT `kategorija_ibfk_1` FOREIGN KEY (`fk_nadkategorija`) REFERENCES `kategorija` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `msg`
--
ALTER TABLE `msg`
  ADD CONSTRAINT `msg_ibfk_2` FOREIGN KEY (`fk_uporabnik`) REFERENCES `uporabnik` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `msg_ibfk_1` FOREIGN KEY (`fk_pogovor`) REFERENCES `pogovor` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `oglas`
--
ALTER TABLE `oglas`
  ADD CONSTRAINT `oglas_ibfk_1` FOREIGN KEY (`fk_uporabnik`) REFERENCES `uporabnik` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `oglas_ibfk_2` FOREIGN KEY (`fk_kategorija`) REFERENCES `kategorija` (`id`) ON DELETE SET NULL ON UPDATE SET NULL,
  ADD CONSTRAINT `oglas_ibfk_3` FOREIGN KEY (`fk_stanje`) REFERENCES `artikel_stanje` (`id`) ON DELETE SET NULL ON UPDATE SET NULL,
  ADD CONSTRAINT `oglas_ibfk_4` FOREIGN KEY (`fk_oglas_tip`) REFERENCES `oglas_tip` (`id`) ON DELETE SET NULL ON UPDATE SET NULL,
  ADD CONSTRAINT `oglas_ibfk_5` FOREIGN KEY (`fk_znamka`) REFERENCES `znamka` (`id`) ON DELETE SET NULL ON UPDATE SET NULL,
  ADD CONSTRAINT `oglas_ibfk_6` FOREIGN KEY (`fk_ohranjenost`) REFERENCES `artikel_ohranjenost` (`id`) ON DELETE SET NULL ON UPDATE SET NULL;

--
-- Constraints for table `oglas_slika`
--
ALTER TABLE `oglas_slika`
  ADD CONSTRAINT `oglas_slika_ibfk_1` FOREIGN KEY (`fk_oglas`) REFERENCES `oglas` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `ogledano`
--
ALTER TABLE `ogledano`
  ADD CONSTRAINT `ogledano_ibfk_1` FOREIGN KEY (`fk_oglas`) REFERENCES `oglas` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `ogledano_ibfk_2` FOREIGN KEY (`fk_uporabnik`) REFERENCES `uporabnik` (`id`) ON DELETE SET NULL ON UPDATE SET NULL;

--
-- Constraints for table `pogovor`
--
ALTER TABLE `pogovor`
  ADD CONSTRAINT `pogovor_ibfk_2` FOREIGN KEY (`fk_uporabnik2`) REFERENCES `uporabnik` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `pogovor_ibfk_1` FOREIGN KEY (`fk_uporabnik1`) REFERENCES `uporabnik` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `shranjen_oglas`
--
ALTER TABLE `shranjen_oglas`
  ADD CONSTRAINT `shranjen_oglas_ibfk_2` FOREIGN KEY (`fk_oglas`) REFERENCES `oglas` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `shranjen_oglas_ibfk_1` FOREIGN KEY (`fk_uporabnik`) REFERENCES `uporabnik` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `zbirka`
--
ALTER TABLE `zbirka`
  ADD CONSTRAINT `zbirka_ibfk_1` FOREIGN KEY (`fk_kategorija`) REFERENCES `kategorija` (`id`) ON DELETE SET NULL ON UPDATE SET NULL;

--
-- Constraints for table `zbirka_oglas`
--
ALTER TABLE `zbirka_oglas`
  ADD CONSTRAINT `zbirka_oglas_ibfk_1` FOREIGN KEY (`fk_oglas`) REFERENCES `oglas` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `zbirka_oglas_ibfk_2` FOREIGN KEY (`fk_zbirka`) REFERENCES `zbirka` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `znamka_kategorija`
--
ALTER TABLE `znamka_kategorija`
  ADD CONSTRAINT `znamka_kategorija_ibfk_1` FOREIGN KEY (`fk_znamka`) REFERENCES `znamka` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `znamka_kategorija_ibfk_2` FOREIGN KEY (`fk_kategorija`) REFERENCES `kategorija` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;