Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- phpMyAdmin SQL Dump
- -- version 4.1.14
- -- http://www.phpmyadmin.net
- --
- -- Host: 127.0.0.1
- -- Generation Time: Oct 06, 2016 at 06:08 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 `akcija`
- --
- CREATE TABLE IF NOT EXISTS `akcija` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `kupon` text COLLATE utf8_slovenian_ci,
- `procent` double DEFAULT '-1',
- `cena` double DEFAULT '-1',
- `fk_lokal_id` bigint(20) NOT NULL,
- `aktivno` tinyint(1) NOT NULL DEFAULT '1',
- `spletno` tinyint(1) NOT NULL DEFAULT '0',
- `datum_vnosa` datetime NOT NULL,
- `naziv` text COLLATE utf8_slovenian_ci NOT NULL,
- PRIMARY KEY (`id`),
- KEY `fk_lokal_id` (`fk_lokal_id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_slovenian_ci AUTO_INCREMENT=3 ;
- --
- -- Dumping data for table `akcija`
- --
- INSERT INTO `akcija` (`id`, `kupon`, `procent`, `cena`, `fk_lokal_id`, `aktivno`, `spletno`, `datum_vnosa`, `naziv`) VALUES
- (1, '', 12, -1, 21061265696, 1, 1, '2016-09-26 17:55:00', '123'),
- (2, 'qwe', -1, 24, 21061265696, 0, 0, '2016-09-26 17:56:00', 'cena');
- -- --------------------------------------------------------
- --
- -- Table structure for table `feedback`
- --
- CREATE TABLE IF NOT EXISTS `feedback` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `text` text CHARACTER SET latin1 NOT NULL,
- `fk_uporabnik_id` bigint(20) DEFAULT NULL,
- `fk_lokal_id` bigint(20) DEFAULT NULL,
- `datum` datetime NOT NULL,
- PRIMARY KEY (`id`),
- KEY `fk_uporabnik_id` (`fk_uporabnik_id`),
- KEY `fk_lokal_id` (`fk_lokal_id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_slovenian_ci AUTO_INCREMENT=27 ;
- --
- -- Dumping data for table `feedback`
- --
- INSERT INTO `feedback` (`id`, `text`, `fk_uporabnik_id`, `fk_lokal_id`, `datum`) VALUES
- (1, 'ertert', NULL, NULL, '2016-09-20 16:32:00'),
- (2, 'ertert', NULL, NULL, '2016-09-20 16:32:00'),
- (3, 'ertert', NULL, NULL, '2016-09-20 16:32:00'),
- (4, 'ertert', NULL, NULL, '2016-09-20 16:32:00'),
- (5, 'ertert', NULL, NULL, '2016-09-20 16:32:00'),
- (6, 'ertert', NULL, NULL, '2016-09-20 16:32:00'),
- (7, 'ertert', NULL, NULL, '2016-09-20 16:32:00'),
- (8, 'ertert', NULL, NULL, '2016-09-20 16:32:00'),
- (9, 'ertert', NULL, NULL, '2016-09-20 16:32:00'),
- (10, 'ertert', NULL, NULL, '2016-09-20 16:32:00'),
- (11, 'ertert', NULL, NULL, '2016-09-20 16:32:00'),
- (12, 'ertert', NULL, NULL, '2016-09-20 16:32:00'),
- (13, 'zrtzr', NULL, 82386710868, '2016-09-20 16:33:00'),
- (14, 'werwer', 86891762479, NULL, '2016-09-20 16:34:00'),
- (15, 'rtzertz', 86891762479, NULL, '2016-09-20 16:37:00'),
- (16, 'rtzertz', 86891762479, NULL, '2016-09-20 16:37:00'),
- (17, 'rtzertz', 86891762479, NULL, '2016-09-20 16:37:00'),
- (18, 'rtzertz', 86891762479, NULL, '2016-09-20 16:37:00'),
- (19, 'rtuzrtz', 86891762479, NULL, '2016-09-20 16:38:00'),
- (20, '78', NULL, 82386710868, '2016-09-20 17:14:00'),
- (21, 'iopsdjt', 86891762479, NULL, '2016-09-20 23:58:00'),
- (22, '123', 86891762479, NULL, '2016-09-23 15:28:00'),
- (23, '123', 86891762479, NULL, '2016-09-23 23:21:00'),
- (24, '99o', 86891762479, NULL, '2016-09-24 08:48:00'),
- (25, 'erwr', NULL, 21061265696, '2016-09-26 12:54:00'),
- (26, 'qwe', 86891762479, NULL, '2016-09-30 23:19:00');
- -- --------------------------------------------------------
- --
- -- Table structure for table `jedilnik`
- --
- CREATE TABLE IF NOT EXISTS `jedilnik` (
- `id` bigint(20) NOT NULL,
- `fk_lokal_id` bigint(20) NOT NULL,
- `memo` varchar(64) COLLATE utf8_slovenian_ci NOT NULL,
- `datum_vnosa` datetime NOT NULL,
- `active` tinyint(1) NOT NULL DEFAULT '0',
- `tip` tinyint(1) NOT NULL DEFAULT '0',
- PRIMARY KEY (`id`),
- KEY `fk_lokal_id` (`fk_lokal_id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_slovenian_ci;
- --
- -- Dumping data for table `jedilnik`
- --
- INSERT INTO `jedilnik` (`id`, `fk_lokal_id`, `memo`, `datum_vnosa`, `active`, `tip`) VALUES
- (123123, 82386710868, 'def', '2016-09-23 14:09:00', 1, 0),
- (8166883286, 88620957473, 'Privzeto', '2016-10-06 15:02:00', 0, 0),
- (36107969630, 15244476491, 'Privzeto', '2016-10-06 15:07:00', 0, 0),
- (48027043618, 15244476491, 'Študentski', '2016-10-06 15:07:00', 0, 1),
- (48090639821, 88620957473, 'Študentski', '2016-10-06 15:02:00', 0, 1),
- (48869006086, 88928449308, 'Študentski', '2016-10-06 15:05:00', 0, 1),
- (57866498998, 86989713026, 'Študentski', '2016-10-06 15:14:00', 0, 1),
- (60602130512, 35358669632, 'Privzeto', '2016-09-24 09:52:00', 0, 0),
- (81631866800, 26403806087, 'Študentski', '2016-10-06 15:06:00', 0, 1),
- (85229441881, 88928449308, 'Privzeto', '2016-10-06 15:05:00', 0, 0),
- (89380512299, 21061265696, 'Privzeto', '2016-09-23 14:09:00', 1, 0),
- (92880619443, 26403806087, 'Privzeto', '2016-10-06 15:06:00', 0, 0),
- (94885245845, 86989713026, 'Privzeto', '2016-10-06 15:14:00', 0, 0);
- -- --------------------------------------------------------
- --
- -- Table structure for table `jedilnik_meni`
- --
- CREATE TABLE IF NOT EXISTS `jedilnik_meni` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `naziv` varchar(64) COLLATE utf8_slovenian_ci DEFAULT NULL,
- `fk_jedilnik_id` bigint(20) NOT NULL,
- `fk_jedilnik_tip` int(11) DEFAULT NULL,
- `jedilnik` mediumtext COLLATE utf8_slovenian_ci NOT NULL,
- `cena` double DEFAULT '-1',
- `bon` tinyint(1) NOT NULL DEFAULT '0',
- PRIMARY KEY (`id`),
- KEY `fk_meni_id` (`fk_jedilnik_id`),
- KEY `fk_jedilnik_tip` (`fk_jedilnik_tip`),
- KEY `fk_meni_id_2` (`fk_jedilnik_id`),
- KEY `fk_jedilnik_tip_2` (`fk_jedilnik_tip`),
- KEY `fk_jedilnik_id` (`fk_jedilnik_id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_slovenian_ci AUTO_INCREMENT=193 ;
- --
- -- Dumping data for table `jedilnik_meni`
- --
- INSERT INTO `jedilnik_meni` (`id`, `naziv`, `fk_jedilnik_id`, `fk_jedilnik_tip`, `jedilnik`, `cena`, `bon`) VALUES
- (174, 'Kosilo 11', 89380512299, 2, 'OCVRTI MEDALJONI,NJOKI S PARMEZANOMm', 3.66, 1),
- (175, 'Kosilo 2', 89380512299, 2, 'KORENČKOVA JUHA::SOLATNI KROŽNIK S POPEČENO ZELENJAVO,HLEBČEK IZ KRUŠNE PEČI::ZELENA,PAPRADIŽNIK,KORUZA,FIŽOL::JABOLKO', 3.6, 0),
- (176, 'Kosilo 3', 89380512299, 2, 'KORENČKOVA JUHA::LOSOS NA ŽARU,BLITVA S KROMPIRJEM::SEZONSKA SOLATA::JABOLKO', 3.6, 0),
- (177, 'Kosilo 1', 60602130512, 1, 'POHORSKI LONEC, ČOKOLADICA::SESTAVLJENA SOLATA::SADJE', 2, 0),
- (178, 'Kosilo 2', 60602130512, 1, 'GOVEJI ZREZEK V LOVSKI OMAKI, TESTENINE::SESTAVLJENA SOLATA::SADJE', 2, 0),
- (179, 'Kosilo 23', 60602130512, 1, 'MESNI SIR NA ŽARU, RIŽ S KORENČKOM::SESTAVLJENA SOLATA::SADJE', 2, 0),
- (180, 'Kosilo bon', 60602130512, 3, '123', 12, 1),
- (181, 'Kosilo 4', 89380512299, 1, '123', 34, 1),
- (182, 'qwe', 60602130512, 3, '23', 12, 1),
- (183, '123', 89380512299, 3, '23', 12, 1),
- (184, '12333', 89380512299, 3, '123', 12, 1),
- (185, '123', 89380512299, 3, '23', 123, 1),
- (186, '123', 89380512299, 3, '23', 123, 1),
- (187, '123', 89380512299, 3, '23', 123, 1),
- (188, '123', 89380512299, 3, '23', 123, 1),
- (189, '123', 89380512299, 4, '123', 213, 1),
- (190, '33', 89380512299, 4, '3', 3, 1),
- (191, '123', 89380512299, 4, '23', 213, 1),
- (192, 'wqe', 89380512299, 3, '123', 123, 1);
- -- --------------------------------------------------------
- --
- -- Table structure for table `jedilnik_tip`
- --
- CREATE TABLE IF NOT EXISTS `jedilnik_tip` (
- `id` int(11) NOT NULL,
- `naziv` varchar(32) NOT NULL,
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
- --
- -- Dumping data for table `jedilnik_tip`
- --
- INSERT INTO `jedilnik_tip` (`id`, `naziv`) VALUES
- (1, 'Mesni'),
- (2, 'Vege'),
- (3, 'Ribe'),
- (4, 'Hitra hrana'),
- (5, 'Pizza'),
- (6, 'Testenine');
- -- --------------------------------------------------------
- --
- -- 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);
- -- --------------------------------------------------------
- --
- -- Table structure for table `lokal_nagrada`
- --
- CREATE TABLE IF NOT EXISTS `lokal_nagrada` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `fk_lokal_id` bigint(20) NOT NULL,
- `fk_nagrada_id` int(11) NOT NULL,
- `datum_prejema` datetime NOT NULL,
- PRIMARY KEY (`id`),
- KEY `fk_lokal_id` (`fk_lokal_id`,`fk_nagrada_id`),
- KEY `fk_lokal_id_2` (`fk_lokal_id`),
- KEY `fk_nagrada_id` (`fk_nagrada_id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;
- --
- -- Dumping data for table `lokal_nagrada`
- --
- INSERT INTO `lokal_nagrada` (`id`, `fk_lokal_id`, `fk_nagrada_id`, `datum_prejema`) VALUES
- (1, 21061265696, 2, '2016-10-01 14:18:00'),
- (2, 21061265696, 3, '2016-10-01 14:40:00');
- -- --------------------------------------------------------
- --
- -- Table structure for table `nacin_placila`
- --
- CREATE TABLE IF NOT EXISTS `nacin_placila` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `naziv` varchar(32) NOT NULL,
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;
- --
- -- Dumping data for table `nacin_placila`
- --
- INSERT INTO `nacin_placila` (`id`, `naziv`) VALUES
- (1, 'Gotovina'),
- (2, 'Kartica'),
- (3, 'Moneta');
- -- --------------------------------------------------------
- --
- -- Table structure for table `nagrada`
- --
- CREATE TABLE IF NOT EXISTS `nagrada` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `naziv` varchar(64) COLLATE utf8_slovenian_ci NOT NULL,
- `ico` varchar(64) COLLATE utf8_slovenian_ci DEFAULT NULL,
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_slovenian_ci AUTO_INCREMENT=6 ;
- --
- -- Dumping data for table `nagrada`
- --
- INSERT INTO `nagrada` (`id`, `naziv`, `ico`) VALUES
- (1, 'Prvo naročilo', '179250'),
- (2, 'Pet naročil', '179251'),
- (3, 'Deset naročil', '179249'),
- (4, 'Sto naročil', '214282'),
- (5, 'Tisoč naročil', '214321');
- -- --------------------------------------------------------
- --
- -- Table structure for table `narocilo`
- --
- CREATE TABLE IF NOT EXISTS `narocilo` (
- `id` bigint(20) NOT NULL,
- `fk_uporabnik_id` bigint(20) NOT NULL,
- `fk_jedilnik_meni_id` int(11) DEFAULT NULL,
- `fk_lokal_id` bigint(20) NOT NULL,
- `bon` tinyint(1) NOT NULL,
- `naslov` varchar(64) CHARACTER SET utf8 COLLATE utf8_slovenian_ci NOT NULL,
- `kraj` varchar(64) CHARACTER SET utf8 COLLATE utf8_slovenian_ci NOT NULL,
- `telefon` varchar(64) NOT NULL,
- `cena` double NOT NULL,
- `komentar` text CHARACTER SET utf8 COLLATE utf8_slovenian_ci NOT NULL,
- `datum_narocila` datetime NOT NULL,
- `datum_sprejema` datetime DEFAULT NULL,
- `koncano` tinyint(1) NOT NULL DEFAULT '0',
- `predviden_cas_dostave` int(11) DEFAULT NULL,
- `fk_nacin_placila` int(11) DEFAULT '1',
- `zavrnjeno` tinyint(1) NOT NULL DEFAULT '0',
- PRIMARY KEY (`id`),
- KEY `fk_uporabnik_id` (`fk_uporabnik_id`),
- KEY `fk_lokal_id` (`fk_lokal_id`),
- KEY `fk_jedilnik_meni_id` (`fk_jedilnik_meni_id`),
- KEY `fk_nacin_placila` (`fk_nacin_placila`)
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
- --
- -- Dumping data for table `narocilo`
- --
- INSERT INTO `narocilo` (`id`, `fk_uporabnik_id`, `fk_jedilnik_meni_id`, `fk_lokal_id`, `bon`, `naslov`, `kraj`, `telefon`, `cena`, `komentar`, `datum_narocila`, `datum_sprejema`, `koncano`, `predviden_cas_dostave`, `fk_nacin_placila`, `zavrnjeno`) VALUES
- (3532700036, 86891762479, 175, 21061265696, 1, 'Naslov 12', 'Maribor', '031000000', 3.6, '', '2016-10-01 21:35:00', NULL, 0, NULL, 1, 0),
- (3731491554, 86891762479, 174, 21061265696, 1, 'Naslov 12', 'Maribor', '031000000', 3.66, '', '2016-10-01 14:38:00', NULL, 0, NULL, 1, 0),
- (8083825507, 86891762479, 175, 21061265696, 1, 'Naslov 12', 'Maribor', '031000000', 3.6, '', '2016-10-01 21:34:00', NULL, 0, NULL, 1, 0),
- (10705745610, 86891762479, 183, 21061265696, 1, 'Naslov 12', 'Maribor', '031000000', 3.66, '', '2016-10-01 15:12:00', NULL, 0, NULL, 1, 0),
- (11874175296, 86891762479, 175, 21061265696, 1, 'Naslov 12', 'Maribor', '031000000', 3.6, '', '2016-10-02 18:51:00', '2016-10-02 22:40:00', 1, NULL, 1, 0),
- (12907634997, 86891762479, 175, 21061265696, 1, 'Naslov 12', 'Maribor', '031000000', 3.6, '', '2016-10-01 14:40:00', NULL, 0, NULL, 1, 0),
- (19898273093, 86891762479, 176, 21061265696, 1, 'Naslov 12', 'Maribor', '031000000', 3.6, '', '2016-10-02 18:44:00', NULL, 0, NULL, 1, 0),
- (20764065564, 86891762479, 184, 21061265696, 1, 'Naslov 12', 'Maribor', '031000000', 3.66, '', '2016-10-02 14:58:00', NULL, 0, NULL, 1, 0),
- (34243714175, 86891762479, 175, 21061265696, 1, 'Naslov 12', 'Maribor', '031000000', 3.6, '', '2016-10-02 14:52:00', '2016-10-02 15:00:00', 1, NULL, 1, 0),
- (37357076972, 86891762479, 175, 21061265696, 1, 'Naslov 12', 'Maribor', '031000000', 3.6, '', '2016-10-01 14:18:00', NULL, 0, NULL, 1, 0),
- (37630838143, 86891762479, 175, 21061265696, 1, 'Naslov 12', 'Maribor', '031000000', 3.6, '', '2016-10-01 14:40:00', NULL, 0, NULL, 1, 0),
- (37715508931, 86891762479, 181, 21061265696, 1, 'Naslov 12', 'Maribor', '031000000', 3.66, '', '2016-10-01 15:12:00', NULL, 0, NULL, 1, 0),
- (38626989198, 86891762479, 187, 21061265696, 1, 'Naslov 12', 'Maribor', '031000000', 3.66, '', '2016-10-02 14:58:00', NULL, 0, NULL, 1, 0),
- (42064666101, 86891762479, 192, 21061265696, 1, 'Naslov 12', 'Maribor', '031000000', 3.66, '', '2016-10-01 15:12:00', NULL, 0, NULL, 1, 0),
- (43572457320, 86891762479, 175, 21061265696, 1, 'Naslov 12', 'Maribor', '031000000', 3.6, '', '2016-10-02 18:51:00', '2016-10-02 22:40:00', 1, NULL, 1, 0),
- (47471609413, 86891762479, 175, 21061265696, 1, 'Naslov 12', 'Maribor', '031000000', 3.6, '', '2016-10-01 21:29:00', NULL, 0, NULL, 1, 0),
- (47842139032, 86891762479, 181, 21061265696, 1, 'Naslov 12', 'Maribor', '031000000', 3.66, '', '2016-10-01 14:38:00', NULL, 0, NULL, 1, 0),
- (48598376356, 86891762479, 175, 21061265696, 1, 'Naslov 12', 'Maribor', '031000000', 3.6, '', '2016-10-01 21:55:00', '2016-10-01 22:36:00', 1, NULL, 1, 0),
- (48823427674, 86891762479, 175, 21061265696, 1, 'Naslov 12', 'Maribor', '031000000', 3.6, '', '2016-09-26 13:36:00', NULL, 0, NULL, 1, 0),
- (50057610143, 86891762479, 188, 21061265696, 1, 'Naslov 12', 'Maribor', '031000000', 3.66, '', '2016-10-01 15:12:00', NULL, 0, NULL, 1, 0),
- (50427207039, 86891762479, 175, 21061265696, 1, 'Naslov 12', 'Maribor', '031000000', 3.6, '', '2016-10-02 14:55:00', NULL, 0, NULL, 1, 0),
- (50580618518, 86891762479, 191, 21061265696, 1, 'Naslov 12', 'Maribor', '031000000', 3.66, '', '2016-10-02 14:58:00', '2016-10-02 17:35:00', 1, NULL, 1, 0),
- (51814240804, 86891762479, 186, 21061265696, 1, 'Naslov 12', 'Maribor', '031000000', 3.66, '', '2016-10-01 15:12:00', NULL, 0, NULL, 1, 0),
- (53258599783, 86891762479, 174, 21061265696, 1, 'Naslov 12', 'Maribor', '031000000', 3.66, '', '2016-10-02 14:58:00', '2016-10-02 16:17:00', 1, NULL, 1, 0),
- (54809108263, 86891762479, 175, 21061265696, 1, 'Naslov 12', 'Maribor', '031000000', 3.6, '', '2016-10-01 14:38:00', NULL, 0, NULL, 1, 0),
- (54926129444, 86891762479, 175, 21061265696, 1, 'Naslov 12', 'Maribor', '031000000', 3.6, '', '2016-10-01 18:09:00', NULL, 0, NULL, 1, 0),
- (56142478840, 86891762479, 186, 21061265696, 1, 'Naslov 12', 'Maribor', '031000000', 3.66, '', '2016-10-02 14:58:00', NULL, 0, NULL, 1, 0),
- (56267334194, 86891762479, 184, 21061265696, 1, 'Naslov 12', 'Maribor', '031000000', 3.66, '', '2016-10-01 15:12:00', NULL, 0, NULL, 1, 0),
- (57079355894, 86891762479, 176, 21061265696, 1, 'Naslov 12', 'Maribor', '031000000', 3.6, '', '2016-09-26 13:36:00', NULL, 0, NULL, 1, 0),
- (59162995582, 86891762479, 175, 21061265696, 1, 'Naslov 12', 'Maribor', '031000000', 3.6, '', '2016-10-02 14:47:00', NULL, 0, NULL, 1, 0),
- (59850730864, 86891762479, 189, 21061265696, 1, 'Naslov 12', 'Maribor', '031000000', 3.66, '', '2016-10-01 15:12:00', NULL, 0, NULL, 1, 0),
- (60592010770, 86891762479, 181, 21061265696, 1, 'Naslov 12', 'Maribor', '031000000', 3.66, '', '2016-10-01 18:10:00', NULL, 0, NULL, 1, 0),
- (61741983278, 86891762479, 175, 21061265696, 1, 'Naslov 12', 'Maribor', '031000000', 3.6, '', '2016-10-01 14:39:00', NULL, 0, NULL, 1, 0),
- (63259454303, 86891762479, 175, 21061265696, 1, 'Naslov 12', 'Maribor', '031000000', 3.6, '', '2016-09-26 14:53:00', NULL, 0, NULL, 1, 0),
- (63488998588, 86891762479, 176, 21061265696, 1, 'Naslov 12', 'Maribor', '031000000', 3.6, '', '2016-10-02 14:55:00', NULL, 0, NULL, 1, 0),
- (64266728248, 86891762479, 185, 21061265696, 1, 'Naslov 12', 'Maribor', '031000000', 3.66, '', '2016-10-01 15:12:00', NULL, 0, NULL, 1, 0),
- (66335587347, 86891762479, 185, 21061265696, 1, 'Naslov 12', 'Maribor', '031000000', 3.66, '', '2016-10-02 14:58:00', NULL, 1, NULL, 1, 1),
- (68260553202, 60644838130, 181, 21061265696, 1, 'Wqweokp', 'Qweopk', '031000000', 3.66, '', '2016-10-03 19:47:00', NULL, 0, NULL, 1, 0),
- (68425580184, 86891762479, 187, 21061265696, 1, 'Naslov 12', 'Maribor', '031000000', 3.66, '', '2016-10-01 15:12:00', NULL, 0, NULL, 1, 0),
- (68838786798, 86891762479, 188, 21061265696, 1, 'Naslov 12', 'Maribor', '031000000', 3.66, '', '2016-10-02 14:58:00', NULL, 0, NULL, 1, 0),
- (68839875259, 86891762479, 175, 21061265696, 1, 'Naslov 12', 'Maribor', '031000000', 3.6, '', '2016-10-01 21:34:00', NULL, 0, NULL, 1, 0),
- (68848949384, 86891762479, 174, 21061265696, 1, 'Naslov 12', 'Maribor', '031000000', 3.66, '', '2016-10-01 12:21:00', NULL, 0, NULL, 1, 0),
- (70852178859, 86891762479, 176, 21061265696, 1, 'Naslov 12', 'Maribor', '031000000', 3.6, '', '2016-10-02 14:47:00', NULL, 0, NULL, 1, 0),
- (70863331434, 86891762479, 190, 21061265696, 1, 'Naslov 12', 'Maribor', '031000000', 3.66, '', '2016-10-02 14:58:00', NULL, 0, NULL, 1, 0),
- (74584008685, 86891762479, 175, 21061265696, 1, 'Naslov 12', 'Maribor', '031000000', 3.6, '', '2016-10-02 18:44:00', NULL, 0, NULL, 1, 0),
- (80505641138, 86891762479, 183, 21061265696, 1, 'Naslov 12', 'Maribor', '031000000', 3.66, '', '2016-10-02 14:58:00', NULL, 0, NULL, 1, 0),
- (81169241600, 86891762479, 190, 21061265696, 1, 'Naslov 12', 'Maribor', '031000000', 3.66, '', '2016-10-01 15:12:00', NULL, 0, NULL, 1, 0),
- (81303587464, 60644838130, 174, 21061265696, 1, 'Wqweokp', 'Qweopk', '031000000', 3.66, '', '2016-10-03 19:47:00', NULL, 0, NULL, 1, 0),
- (83246618353, 86891762479, 175, 21061265696, 1, 'Naslov 12', 'Maribor', '031000000', 3.6, '', '2016-10-06 16:59:00', NULL, 0, NULL, 1, 0),
- (84045438295, 86891762479, 192, 21061265696, 1, 'Naslov 12', 'Maribor', '031000000', 3.66, '', '2016-10-02 14:58:00', NULL, 0, NULL, 1, 0),
- (84853657227, 86891762479, 175, 21061265696, 1, 'Naslov 12', 'Maribor', '031000000', 3.6, '', '2016-10-02 18:50:00', NULL, 0, NULL, 1, 0),
- (87003872871, 86891762479, 174, 21061265696, 1, 'Naslov 12', 'Maribor', '031000000', 3.66, '', '2016-10-01 18:10:00', NULL, 0, NULL, 1, 0),
- (88098887488, 86891762479, 176, 21061265696, 1, 'Naslov 12', 'Maribor', '031000000', 3.6, '', '2016-10-02 14:52:00', NULL, 0, NULL, 1, 0),
- (88208872958, 86891762479, 191, 21061265696, 1, 'Naslov 12', 'Maribor', '031000000', 3.66, '', '2016-10-01 15:12:00', NULL, 0, NULL, 1, 0),
- (88538012641, 86891762479, 181, 21061265696, 1, 'Naslov 12', 'Maribor', '031000000', 3.66, '', '2016-10-02 14:58:00', NULL, 0, NULL, 1, 0),
- (88628267878, 86891762479, 175, 21061265696, 1, 'Naslov 12', 'Maribor', '031000000', 3.6, '', '2016-10-01 21:36:00', NULL, 0, NULL, 1, 0),
- (89105189737, 86891762479, 175, 21061265696, 1, 'Naslov 12', 'Maribor', '031000000', 3.6, '', '2016-10-01 21:54:00', '2016-10-02 12:56:00', 1, NULL, 1, 0),
- (89358261806, 86891762479, 176, 21061265696, 1, 'Naslov 12', 'Maribor', '031000000', 3.6, '', '2016-10-06 16:59:00', NULL, 0, NULL, 1, 0),
- (90606606867, 86891762479, 174, 21061265696, 1, 'Naslov 12', 'Maribor', '031000000', 3.66, '', '2016-10-01 15:12:00', NULL, 0, NULL, 1, 0),
- (90778191479, 86891762479, 189, 21061265696, 1, 'Naslov 12', 'Maribor', '031000000', 3.66, '', '2016-10-02 14:58:00', NULL, 0, NULL, 1, 0),
- (91206023470, 86891762479, 183, 21061265696, 1, 'Naslov 12', 'Maribor', '031000000', 3.66, '', '2016-10-01 18:10:00', NULL, 0, NULL, 1, 0),
- (94431163756, 86891762479, 184, 21061265696, 1, 'Naslov 12', 'Maribor', '031000000', 3.66, '', '2016-10-01 18:10:00', NULL, 0, NULL, 1, 0);
- -- --------------------------------------------------------
- --
- -- Table structure for table `narocilo_feedback`
- --
- CREATE TABLE IF NOT EXISTS `narocilo_feedback` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `fk_uporabnik_id` bigint(20) NOT NULL,
- `fk_narocilo_id` bigint(20) DEFAULT NULL,
- `fk_lokal_id` bigint(20) NOT NULL,
- `ocena` int(11) NOT NULL,
- `mnenje` text NOT NULL,
- PRIMARY KEY (`id`),
- KEY `fk_lokal_id` (`fk_lokal_id`),
- KEY `fk_uporabnik_id` (`fk_uporabnik_id`),
- KEY `fk_narocilo_id` (`fk_narocilo_id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=20 ;
- --
- -- Dumping data for table `narocilo_feedback`
- --
- INSERT INTO `narocilo_feedback` (`id`, `fk_uporabnik_id`, `fk_narocilo_id`, `fk_lokal_id`, `ocena`, `mnenje`) VALUES
- (16, 86891762479, NULL, 82386710868, 4, '123'),
- (17, 86891762479, NULL, 21061265696, 5, 'dobro'),
- (18, 86891762479, NULL, 21061265696, 5, 'ok'),
- (19, 86891762479, NULL, 21061265696, 5, '');
- -- --------------------------------------------------------
- --
- -- Table structure for table `notification`
- --
- CREATE TABLE IF NOT EXISTS `notification` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `fk_uporabnik_id` bigint(20) DEFAULT NULL,
- `fk_lokal_id` bigint(20) DEFAULT NULL,
- `fk_notification_id` int(11) NOT NULL DEFAULT '1',
- `text` text COLLATE utf8_slovenian_ci NOT NULL,
- `prebrano` tinyint(1) NOT NULL DEFAULT '0',
- `datum` datetime NOT NULL,
- PRIMARY KEY (`id`),
- KEY `fk_uporabnik_id` (`fk_uporabnik_id`,`fk_notification_id`),
- KEY `fk_lokal_id` (`fk_lokal_id`),
- KEY `fk_notification_id` (`fk_notification_id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_slovenian_ci AUTO_INCREMENT=47 ;
- --
- -- Dumping data for table `notification`
- --
- INSERT INTO `notification` (`id`, `fk_uporabnik_id`, `fk_lokal_id`, `fk_notification_id`, `text`, `prebrano`, `datum`) VALUES
- (8, 86891762479, NULL, 1, 'Naročilo je bilo potrjeno! [[lokal:21061265696,narocilo:89105189737]]', 1, '2016-10-02 12:56:00'),
- (16, NULL, 21061265696, 1, 'Novo naročilo! - Odpri za ogled [[narocilo:80505641138]]', 1, '2016-10-02 14:58:00'),
- (17, NULL, 21061265696, 1, 'Novo naročilo! - Odpri za ogled [[narocilo:20764065564]]', 1, '2016-10-02 14:58:00'),
- (20, NULL, 21061265696, 1, 'Novo naročilo! - Odpri za ogled [[narocilo:38626989198]]', 1, '2016-10-02 14:58:00'),
- (26, 86891762479, NULL, 1, 'Naročilo je bilo potrjeno! [[lokal:21061265696,narocilo:34243714175]]', 1, '2016-10-02 15:00:00'),
- (27, 86891762479, NULL, 1, 'Naročilo je bilo zavrnjeno! [[lokal:21061265696,narocilo:66335587347]]', 1, '2016-10-02 15:01:00'),
- (28, 86891762479, NULL, 1, 'Naročilo je bilo potrjeno! [[lokal:21061265696,narocilo:53258599783]]', 1, '2016-10-02 16:17:00'),
- (29, 86891762479, NULL, 1, 'Naročilo je bilo potrjeno! [[lokal:21061265696,narocilo:50580618518]]', 1, '2016-10-02 17:35:00'),
- (30, NULL, 21061265696, 1, 'Novo naročilo! - Odpri za ogled [[narocilo:74584008685]]', 0, '2016-10-02 18:44:00'),
- (31, NULL, 21061265696, 1, 'Novo naročilo! - Odpri za ogled [[narocilo:19898273093]]', 0, '2016-10-02 18:44:00'),
- (32, NULL, 21061265696, 1, 'Novo naročilo! - Odpri za ogled [[narocilo:84853657227]]', 0, '2016-10-02 18:50:00'),
- (33, NULL, 21061265696, 1, 'Novo naročilo! - Odpri za ogled [[narocilo:11874175296]]', 0, '2016-10-02 18:51:00'),
- (34, NULL, 21061265696, 1, 'Novo naročilo! - Odpri za ogled [[narocilo:43572457320]]', 0, '2016-10-02 18:51:00'),
- (35, NULL, 21061265696, 1, 'Novo naročilo! - Odpri za ogled [[narocilo:68146521681]]', 0, '2016-10-02 18:52:00'),
- (36, NULL, 21061265696, 1, 'Novo naročilo! - Odpri za ogled [[narocilo:18770331036]]', 0, '2016-10-02 18:52:00'),
- (37, NULL, 21061265696, 1, 'Novo naročilo! - Odpri za ogled [[narocilo:08823732167]]', 0, '2016-10-02 18:52:00'),
- (38, NULL, 21061265696, 1, 'Novo naročilo! - Odpri za ogled [[narocilo:59876134750]]', 0, '2016-10-02 18:53:00'),
- (39, 86891762479, NULL, 1, 'Naročilo je bilo potrjeno! [[lokal:21061265696,narocilo:11874175296]]', 1, '2016-10-02 22:40:00'),
- (40, 86891762479, NULL, 1, 'Naročilo je bilo potrjeno! [[lokal:21061265696,narocilo:43572457320]]', 1, '2016-10-02 22:40:00'),
- (41, NULL, 21061265696, 1, 'Novo naročilo! - Odpri za ogled [[narocilo:06984388336]]', 0, '2016-10-03 00:07:00'),
- (42, NULL, 21061265696, 1, 'Novo naročilo! - Odpri za ogled [[narocilo:21853617921]]', 0, '2016-10-03 15:43:00'),
- (43, NULL, 21061265696, 1, 'Novo naročilo! - Odpri za ogled [[narocilo:81303587464]]', 0, '2016-10-03 19:47:00'),
- (44, NULL, 21061265696, 1, 'Novo naročilo! - Odpri za ogled [[narocilo:68260553202]]', 0, '2016-10-03 19:47:00'),
- (45, NULL, 21061265696, 1, 'Novo naročilo! - Odpri za ogled [[narocilo:83246618353]]', 0, '2016-10-06 16:59:00'),
- (46, NULL, 21061265696, 1, 'Novo naročilo! - Odpri za ogled [[narocilo:89358261806]]', 0, '2016-10-06 16:59:00');
- -- --------------------------------------------------------
- --
- -- Table structure for table `notification_tip`
- --
- CREATE TABLE IF NOT EXISTS `notification_tip` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `naziv` varchar(64) COLLATE utf8_slovenian_ci NOT NULL,
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_slovenian_ci AUTO_INCREMENT=2 ;
- --
- -- Dumping data for table `notification_tip`
- --
- INSERT INTO `notification_tip` (`id`, `naziv`) VALUES
- (1, 'Obvestilo');
- -- --------------------------------------------------------
- --
- -- Table structure for table `ocena`
- --
- CREATE TABLE IF NOT EXISTS `ocena` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `fk_lokal_id` bigint(11) NOT NULL,
- `fk_uporabnik_id` bigint(11) NOT NULL,
- `ocena` int(11) NOT NULL,
- PRIMARY KEY (`id`),
- KEY `fk_uporabnik_id` (`fk_uporabnik_id`),
- KEY `fk_lokal_id` (`fk_lokal_id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=16 ;
- --
- -- Dumping data for table `ocena`
- --
- INSERT INTO `ocena` (`id`, `fk_lokal_id`, `fk_uporabnik_id`, `ocena`) VALUES
- (12, 82386710868, 86891762479, 5),
- (13, 52927503148, 86891762479, 3),
- (15, 21061265696, 86891762479, 5);
- -- --------------------------------------------------------
- --
- -- Table structure for table `priljubljeno`
- --
- CREATE TABLE IF NOT EXISTS `priljubljeno` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `fk_uporabnik_id` bigint(20) NOT NULL,
- `fk_lokal_id` bigint(20) NOT NULL,
- PRIMARY KEY (`id`),
- KEY `fk_uporabnik_id` (`fk_uporabnik_id`,`fk_lokal_id`),
- KEY `fk_lokal_id` (`fk_lokal_id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=40 ;
- --
- -- Dumping data for table `priljubljeno`
- --
- INSERT INTO `priljubljeno` (`id`, `fk_uporabnik_id`, `fk_lokal_id`) VALUES
- (39, 60644838130, 82386710868),
- (38, 86891762479, 21061265696),
- (19, 86891762479, 52927503148),
- (33, 86891762479, 82386710868);
- -- --------------------------------------------------------
- --
- -- Table structure for table `uporabnik`
- --
- CREATE TABLE IF NOT EXISTS `uporabnik` (
- `id` bigint(11) NOT NULL,
- `email` varchar(32) NOT NULL,
- `ime` varchar(14) CHARACTER SET utf8 COLLATE utf8_slovenian_ci NOT NULL,
- `priimek` varchar(20) CHARACTER SET utf8 COLLATE utf8_slovenian_ci NOT NULL,
- `telefon` varchar(14) NOT NULL,
- `naslov` varchar(40) CHARACTER SET utf8 COLLATE utf8_slovenian_ci NOT NULL,
- `kraj` varchar(20) CHARACTER SET utf8 COLLATE utf8_slovenian_ci NOT NULL,
- `geslo` text CHARACTER SET utf8 COLLATE utf8_slovenian_ci NOT NULL,
- `salt` text NOT NULL,
- `ip` varchar(20) NOT NULL,
- `datum_registracije` datetime NOT NULL,
- `bon` tinyint(1) NOT NULL,
- `last_login` datetime NOT NULL,
- `narocilo_default_naslov` tinyint(1) NOT NULL DEFAULT '0',
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
- --
- -- Dumping data for table `uporabnik`
- --
- INSERT INTO `uporabnik` (`id`, `email`, `ime`, `priimek`, `telefon`, `naslov`, `kraj`, `geslo`, `salt`, `ip`, `datum_registracije`, `bon`, `last_login`, `narocilo_default_naslov`) VALUES
- (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),
- (59588628968, 'topkek@gmail.com', 'weiorj', 'qweopk', '031000000', 'qwekowoek', 'qwopek', 'c8af6fbd53a217c783881c02f8e1d78aaf5129bd229e04d890b8c95bb9610f81', '81289829638870888', '::1', '2016-09-24 09:27:00', 1, '2016-09-24 09:27:00', 0),
- (60644838130, 'wepqwe@gmail.com', 'weopjr', 'asoijd', '031000000', 'wqweokp', 'qweopk', '70a2f9d3e15e2610f1cad7068a03c70fe4cba94563e6739f66ccd1334ff894ee', '04425336146648702', '::1', '2016-10-03 19:45:00', 1, '2016-10-03 19:45:00', 0),
- (78285812078, 'woekew@gmail.com', 'jaz', 'sem', '031000000', 'novak', 'wleowe', 'ac816e3b39c0d11aa1648be05e008ae78a0d65594dad410830c5f95ed471de8c', '95682518407447908', '::1', '2016-10-03 19:45:00', 0, '2016-10-03 19:45:00', 0),
- (86891762479, 'tilen1@gmail.com', 'Tilen', 'Priimek', '031000000', 'Naslov 12', 'Maribor', '2bac383336519df7129ca77575dad272bfe86ff8547a6841dc1f8e648086654c', '80509632030640054', '::1', '2016-09-10 14:18:00', 1, '2016-10-06 16:59:00', 0);
- -- --------------------------------------------------------
- --
- -- Table structure for table `uporabnik_nagrada`
- --
- CREATE TABLE IF NOT EXISTS `uporabnik_nagrada` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `fk_uporabnik_id` bigint(20) NOT NULL,
- `fk_nagrada_id` int(11) NOT NULL,
- `datum_prejema` datetime NOT NULL,
- PRIMARY KEY (`id`),
- KEY `fk_uporabnik_id` (`fk_uporabnik_id`,`fk_nagrada_id`),
- KEY `fk_uporabnik_id_2` (`fk_uporabnik_id`),
- KEY `fk_nagrada_id` (`fk_nagrada_id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_slovenian_ci AUTO_INCREMENT=4 ;
- --
- -- Dumping data for table `uporabnik_nagrada`
- --
- INSERT INTO `uporabnik_nagrada` (`id`, `fk_uporabnik_id`, `fk_nagrada_id`, `datum_prejema`) VALUES
- (2, 86891762479, 3, '2016-10-01 14:40:00'),
- (3, 60644838130, 1, '2016-10-03 19:47:00');
- --
- -- Constraints for dumped tables
- --
- --
- -- Constraints for table `akcija`
- --
- ALTER TABLE `akcija`
- ADD CONSTRAINT `akcija_ibfk_1` FOREIGN KEY (`fk_lokal_id`) REFERENCES `lokal` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
- --
- -- Constraints for table `feedback`
- --
- ALTER TABLE `feedback`
- ADD CONSTRAINT `feedback_ibfk_1` FOREIGN KEY (`fk_uporabnik_id`) REFERENCES `uporabnik` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
- ADD CONSTRAINT `feedback_ibfk_2` FOREIGN KEY (`fk_lokal_id`) REFERENCES `lokal` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
- --
- -- Constraints for table `jedilnik`
- --
- ALTER TABLE `jedilnik`
- ADD CONSTRAINT `jedilnik_ibfk_1` FOREIGN KEY (`fk_lokal_id`) REFERENCES `lokal` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
- --
- -- Constraints for table `jedilnik_meni`
- --
- ALTER TABLE `jedilnik_meni`
- ADD CONSTRAINT `jedilnik_meni_ibfk_1` FOREIGN KEY (`fk_jedilnik_id`) REFERENCES `jedilnik` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
- ADD CONSTRAINT `jedilnik_meni_ibfk_2` FOREIGN KEY (`fk_jedilnik_tip`) REFERENCES `jedilnik_tip` (`id`) ON DELETE SET NULL ON UPDATE SET NULL;
- --
- -- Constraints for table `lokal_nagrada`
- --
- ALTER TABLE `lokal_nagrada`
- ADD CONSTRAINT `lokal_nagrada_ibfk_1` FOREIGN KEY (`fk_lokal_id`) REFERENCES `lokal` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
- ADD CONSTRAINT `lokal_nagrada_ibfk_2` FOREIGN KEY (`fk_nagrada_id`) REFERENCES `nagrada` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
- --
- -- Constraints for table `narocilo`
- --
- ALTER TABLE `narocilo`
- ADD CONSTRAINT `narocilo_ibfk_1` FOREIGN KEY (`fk_lokal_id`) REFERENCES `lokal` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
- ADD CONSTRAINT `narocilo_ibfk_2` FOREIGN KEY (`fk_uporabnik_id`) REFERENCES `uporabnik` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
- ADD CONSTRAINT `narocilo_ibfk_3` FOREIGN KEY (`fk_jedilnik_meni_id`) REFERENCES `jedilnik_meni` (`id`) ON DELETE SET NULL ON UPDATE SET NULL,
- ADD CONSTRAINT `narocilo_ibfk_4` FOREIGN KEY (`fk_nacin_placila`) REFERENCES `nacin_placila` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
- --
- -- Constraints for table `narocilo_feedback`
- --
- ALTER TABLE `narocilo_feedback`
- ADD CONSTRAINT `narocilo_feedback_ibfk_1` FOREIGN KEY (`fk_uporabnik_id`) REFERENCES `uporabnik` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
- ADD CONSTRAINT `narocilo_feedback_ibfk_2` FOREIGN KEY (`fk_narocilo_id`) REFERENCES `narocilo` (`id`) ON DELETE SET NULL ON UPDATE SET NULL,
- ADD CONSTRAINT `narocilo_feedback_ibfk_3` FOREIGN KEY (`fk_lokal_id`) REFERENCES `lokal` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
- --
- -- Constraints for table `notification`
- --
- ALTER TABLE `notification`
- ADD CONSTRAINT `notification_ibfk_1` FOREIGN KEY (`fk_uporabnik_id`) REFERENCES `uporabnik` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
- ADD CONSTRAINT `notification_ibfk_2` FOREIGN KEY (`fk_lokal_id`) REFERENCES `lokal` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
- ADD CONSTRAINT `notification_ibfk_3` FOREIGN KEY (`fk_notification_id`) REFERENCES `notification_tip` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
- --
- -- Constraints for table `ocena`
- --
- ALTER TABLE `ocena`
- ADD CONSTRAINT `ocena_ibfk_1` FOREIGN KEY (`fk_lokal_id`) REFERENCES `lokal` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
- ADD CONSTRAINT `ocena_ibfk_2` FOREIGN KEY (`fk_uporabnik_id`) REFERENCES `uporabnik` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
- --
- -- Constraints for table `priljubljeno`
- --
- ALTER TABLE `priljubljeno`
- ADD CONSTRAINT `priljubljeno_ibfk_1` FOREIGN KEY (`fk_uporabnik_id`) REFERENCES `uporabnik` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
- ADD CONSTRAINT `priljubljeno_ibfk_2` FOREIGN KEY (`fk_lokal_id`) REFERENCES `lokal` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
- --
- -- Constraints for table `uporabnik_nagrada`
- --
- ALTER TABLE `uporabnik_nagrada`
- ADD CONSTRAINT `uporabnik_nagrada_ibfk_1` FOREIGN KEY (`fk_uporabnik_id`) REFERENCES `uporabnik` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
- ADD CONSTRAINT `uporabnik_nagrada_ibfk_2` FOREIGN KEY (`fk_nagrada_id`) REFERENCES `nagrada` (`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 */;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement