-- phpMyAdmin SQL Dump
-- version 4.1.14
-- http://www.phpmyadmin.net
--
-- Host: 127.0.0.1
-- Generation Time: Oct 06, 2016 at 06:06 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: `prehrana`
--

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

--
-- Table structure for table `lokal`
--

CREATE TABLE IF NOT EXISTS `lokal` (
  `id` bigint(11) NOT NULL,
  `active` tinyint(1) NOT NULL DEFAULT '1',
  `naziv` varchar(32) COLLATE utf16_slovenian_ci NOT NULL,
  `lastnik` varchar(32) COLLATE utf16_slovenian_ci NOT NULL,
  `naslov` varchar(48) COLLATE utf16_slovenian_ci NOT NULL,
  `coord` text COLLATE utf16_slovenian_ci NOT NULL,
  `kraj` varchar(20) COLLATE utf16_slovenian_ci NOT NULL,
  `telefon` varchar(14) CHARACTER SET latin1 NOT NULL,
  `email` varchar(32) CHARACTER SET latin1 DEFAULT NULL,
  `geslo` text CHARACTER SET utf32 COLLATE utf32_slovenian_ci NOT NULL,
  `salt` text CHARACTER SET latin1 NOT NULL,
  `odprto_teden_zacetek` varchar(8) CHARACTER SET latin1 NOT NULL,
  `odprto_teden_konec` varchar(8) CHARACTER SET latin1 NOT NULL,
  `odprto_sobota_zacetek` varchar(8) CHARACTER SET latin1 NOT NULL,
  `odprto_sobota_konec` varchar(8) CHARACTER SET latin1 NOT NULL,
  `odprto_nedelja_zacetek` varchar(8) CHARACTER SET latin1 NOT NULL,
  `odprto_nedelja_konec` varchar(8) CHARACTER SET latin1 NOT NULL,
  `datum_registracije` datetime NOT NULL,
  `dostava` tinyint(1) NOT NULL,
  `boni` tinyint(1) NOT NULL,
  `dostava_vikend` tinyint(1) NOT NULL,
  `vege` tinyint(1) NOT NULL,
  `kosila` tinyint(1) NOT NULL,
  `img` varchar(128) COLLATE utf16_slovenian_ci DEFAULT NULL,
  `placilo_gotovina` tinyint(1) NOT NULL,
  `placilo_kartica` tinyint(1) NOT NULL,
  `placilo_moneta` tinyint(1) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf16 COLLATE=utf16_slovenian_ci;

--
-- Dumping data for table `lokal`
--

INSERT INTO `lokal` (`id`, `active`, `naziv`, `lastnik`, `naslov`, `coord`, `kraj`, `telefon`, `email`, `geslo`, `salt`, `odprto_teden_zacetek`, `odprto_teden_konec`, `odprto_sobota_zacetek`, `odprto_sobota_konec`, `odprto_nedelja_zacetek`, `odprto_nedelja_konec`, `datum_registracije`, `dostava`, `boni`, `dostava_vikend`, `vege`, `kosila`, `img`, `placilo_gotovina`, `placilo_kartica`, `placilo_moneta`) VALUES
(15244476491, 1, 'tilen', 'tilen', 'tilen', '', 'tilen', '031000000', 'tilen@gmail.com', 'debd503ba7799b8e23b9c362a144233e86b6c114addcaf455c9ed083887842e5', '85488723355988968', '00:00', '00:00', '00:00', '00:00', '00:00', '00:00', '2016-10-06 15:07:00', 1, 1, 1, 1, 1, NULL, 1, 1, 1),
(18936454639, 1, 'Back Werk', 'null', 'Slovenska cesta 52', '46.16110560000001,14.5701338', 'Ljubljana', '031000000', 'null@gmail.com', 'adba5a82a61eb402dd3c7f939f6344f0021d78a54e553a2cba0d74f0845a4404', '27096876959727515', '00:00', '00:00', '00:00', '00:00', '00:00', '00:00', '2016-09-08 23:24:49', 0, 0, 1, 0, 0, NULL, 0, 0, 0),
(20934442485, 1, 'Astoria City Cusine', 'null', 'Slovenska ulica 2', '46.56182708029149,15.6492523802915', 'Maribor', '026211700', 'null@gmail.com', '9f02abb69b0cc1386c3c42e914d003ecea548d690d8a1cbaeabc24f3b29c3943', '79788284005675642', '00:00', '00:00', '00:00', '00:00', '00:00', '00:00', '2016-09-08 23:23:21', 0, 1, 1, 1, 0, NULL, 0, 0, 0),
(21061265696, 1, 'Taverna Sicilia', 'Taverna Sicilia', 'Ulica Heroja Nandeta 31', '46.5340070802915,15.6746749802915', 'Maribor', '024260315', 'taverna@gmail.com', 'ada74449655cc03710ed3e0f6ae2b70570c608806e0c8e29f7b61f5037cc1601', '95349182653758480', '00:00', '24:00', '00:00', '24:00', '00:00', '24:00', '2016-09-23 14:09:00', 1, 1, 1, 1, 1, NULL, 1, 1, 1),
(26403806087, 1, 'qweqwe12', 'qweqwe', 'Zagrebška cesta 92', '', 'maribor', '031000000', 'erwo@gmail.com', '6ced7338765da4de63a1d15eba1f8ab8b3a284806522387dcbb4ddbac165773e', '61784845582192083', '00:00', '00:00', '00:00', '00:00', '00:00', '00:00', '2016-10-06 15:06:00', 1, 0, 0, 0, 0, NULL, 1, 0, 0),
(35358669632, 1, 'Gurmanski hram', 'Gurmanski hram', 'Zagrebška cesta 92', '46.5264909,15.6688336', 'Maribor', '031467088', 'gurmanski@gmail.com', 'c056c6544d63f8809711acbc7de018bb4e9e77ce92e4be3abeb1fbf33656c9b2', '54609880451878850', '10:10', '16:00', '00:00', '00:00', '00:00', '00:00', '2016-09-24 09:52:00', 1, 1, 0, 1, 1, NULL, 1, 0, 0),
(52927503148, 1, 'Apači', 'Apači', 'Pohorska cesta 17b', '46.5396075802915,15.6074563802915', 'Slovenj Gradec', '028831784', 'apaci@gmail.com', '923b10184d21542f7a487f9300df1acab272269c9e41edf80d49934e73f0a370', '88528993183838781', '01:00', '23:00', '12:00', '01:00', '12:00', '22:00', '2016-09-08 14:29:57', 0, 1, 0, 1, 0, NULL, 0, 0, 0),
(66328866021, 1, 'AROMA, restavracija in pizzerija', 'null', 'Ribji trg 2', '', 'Ljubljana', '031000000', 'noemail@gmail.com', '7ad3ed8d42f79c9e03a11102c3ca33c517d4ec0f923e99043982019f0c1daea4', '82067569399867435', '00:00', '00:00', '00:00', '00:00', '00:00', '00:00', '2016-09-08 23:21:48', 0, 0, 1, 1, 0, NULL, 0, 0, 0),
(82386710868, 1, 'AL Pachino', 'AL Pachino', 'Gosposvetska cesta 87', '46.5637327,15.6253737', 'Maribor', '041566373', 'alpachino@gmail.com', '58dfa4991ba96e60caaad2728dc89ab89552a107e714d54c0dbe8b2103c5e60e', '78306335072898800', '10:00', '20:00', '00:00', '00:00', '00:00', '00:00', '2016-09-08 14:27:24', 1, 1, 1, 0, 0, NULL, 0, 0, 0),
(84189335439, 1, 'Bohor d.o.o.', 'Bohor d.o.o.', 'Kidričeva ulica 23', '', 'Rogaška Slatina', '031000000', 'null@gmail.com', '5dba49c1fc147a6cc814fae84bc3f29405c222f4dc9ddafc547cd3b0e862d66c', '33987949451383398', '00:00', '00:00', '00:00', '00:00', '00:00', '00:00', '2016-09-08 23:27:47', 0, 0, 1, 1, 0, NULL, 0, 0, 0),
(86989713026, 1, 'qwekop', 'qweopk', 'Zagrebška cesta 92', '46.5264909,15.6688336', 'maribor', '031000000', 'tilen@gmail.com', 'bb85d6a20a0c7fb5863ea71cfd82d9ff6737a3e42c520872117a5657fbfa2fb7', '12845521090007362', '00:00', '00:00', '00:00', '00:00', '00:00', '00:00', '2016-10-06 15:14:00', 0, 1, 1, 0, 0, NULL, 0, 1, 0),
(88620957473, 1, 'qweqwe', 'qweqwe', 'Zagrebška cesta 92', '', 'maribor', '031000000', 'erwo@gmail.com', '6697ceddfcde818081103144a8a82ae7ca30ea255576ccbe3be1930cc6c9b634', '82784148537856977', '00:00', '00:00', '00:00', '00:00', '00:00', '00:00', '2016-10-06 15:02:00', 1, 0, 0, 0, 0, NULL, 1, 0, 0),
(88928449308, 1, 'qweqwe1', 'qweqwe', 'Zagrebška cesta 92', '', 'maribor', '031000000', 'erwo@gmail.com', 'b32b7b9b196fcbd8a3f6ea04f8077a5688e12b0ecc1d39fbcba0ed6fa851c9db', '21113983066186684', '00:00', '00:00', '00:00', '00:00', '00:00', '00:00', '2016-10-06 15:05:00', 1, 0, 0, 0, 0, NULL, 1, 0, 0);

/*!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 */;