-- phpMyAdmin SQL Dump
-- version 4.7.4
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Jan 09, 2018 at 07:27 PM
-- Server version: 10.1.28-MariaDB
-- PHP Version: 7.1.11

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
START TRANSACTION;
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 utf8mb4 */;

--
-- Database: `mydb`
--

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

--
-- Table structure for table `admin`
--

CREATE TABLE `admin` (
  `username` varchar(20) CHARACTER SET latin1 NOT NULL,
  `password` varchar(35) CHARACTER SET latin1 NOT NULL,
  `level` int(11) NOT NULL DEFAULT '3'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `admin`
--

INSERT INTO `admin` (`username`, `password`, `level`) VALUES
('admin1', 'e00cf25ad42683b3df678c61f42c6bda', 3);

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

--
-- Table structure for table `gost`
--

CREATE TABLE `gost` (
  `ID_gost` bigint(10) UNSIGNED ZEROFILL NOT NULL,
  `ime_gost` varchar(45) DEFAULT NULL,
  `prezime_gost` varchar(45) DEFAULT NULL,
  `adresa_gost` varchar(45) DEFAULT NULL,
  `grad_gost` varchar(45) DEFAULT NULL,
  `postanski_broj_gost` varchar(45) DEFAULT NULL,
  `spol_gost` varchar(45) DEFAULT NULL,
  `bodovi_gost` int(11) DEFAULT '0',
  `mail_gost` varchar(45) DEFAULT NULL,
  `lozinka_gost` varchar(100) DEFAULT NULL,
  `level` tinyint(4) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `gost`
--

INSERT INTO `gost` (`ID_gost`, `ime_gost`, `prezime_gost`, `adresa_gost`, `grad_gost`, `postanski_broj_gost`, `spol_gost`, `bodovi_gost`, `mail_gost`, `lozinka_gost`, `level`) VALUES
(0000000004, 'Marko', 'Njirjak', 'Vukovarska 7', 'Rijeka', '51000', 'musko', 0, 'marko@gmail.com', '26c7c9089e23c14', 0),
(0000000005, 'Antonio', 'Gauta', 'Dr. Joze Grabovceka 3', 'Rijeka', '51000', 'other', 0, 'helikopter@gmail.com', 'dce6345ea5b90d6', 0),
(0000000006, 'Ana', 'Batel', 'Franje Candeka 16', 'Rijeka', '51000', 'zensko', 0, 'frane@ana.com', '5390489da3971cb', 0),
(0000000007, 'Domagoj', 'Grdinic', 'Selo 3', 'Krk', '50000', 'other', 0, 'domagoj@gmail.com', '202cb962ac59075', 0),
(0000000008, 'Antonio', 'Sanko', 'Danijela Godine 6', 'Rijeka', '51000', 'musko', 0, 'rasanko@gmail.com', '$2y$10$KdLiOGKspTkqd/UQLpkhK.mLiQRkXJ9QmFeUQJ/pzuVABfl3PVB2K', 0),
(0000000009, 'Ivan', 'Ivic', 'Ivana 32', 'Ivanic Grad', '8000', 'musko', 0, 'ivo@gmail.com', '202cb962ac59075b964b07152d234b70', 0),
(0000000010, 'domagoj', 'grdinic', 'selo', 'selo', '1', 'zensko', 0, 'd@gmail.com', '202cb962ac59075b964b07152d234b70', 0);

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

--
-- Table structure for table `grupa`
--

CREATE TABLE `grupa` (
  `ID_grupa` int(10) UNSIGNED ZEROFILL NOT NULL,
  `naziv_grupa` varchar(45) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `grupa`
--

INSERT INTO `grupa` (`ID_grupa`, `naziv_grupa`) VALUES
(0000000001, 'Meksička'),
(0000000002, 'Salate'),
(0000000003, 'Pizze'),
(0000000004, 'Tjestenine'),
(0000000005, 'Rižoti'),
(0000000006, 'Grill'),
(0000000007, 'Juhe'),
(0000000008, 'Deserti');

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

--
-- Table structure for table `jelo`
--

CREATE TABLE `jelo` (
  `ID_jelo` int(10) UNSIGNED ZEROFILL NOT NULL,
  `tip_ID_tip` int(10) UNSIGNED ZEROFILL NOT NULL,
  `grupa_ID_grupa` int(10) UNSIGNED ZEROFILL NOT NULL,
  `kuhar_ID_kuhar` bigint(20) UNSIGNED ZEROFILL NOT NULL,
  `ime_jelo` varchar(45) DEFAULT NULL,
  `cijena_jelo` int(4) UNSIGNED DEFAULT NULL,
  `opis` varchar(100) DEFAULT NULL,
  `slika_jelo` text CHARACTER SET latin2 COLLATE latin2_croatian_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `jelo`
--

INSERT INTO `jelo` (`ID_jelo`, `tip_ID_tip`, `grupa_ID_grupa`, `kuhar_ID_kuhar`, `ime_jelo`, `cijena_jelo`, `opis`, `slika_jelo`) VALUES
(0000000047, 0000000003, 0000000003, 00000000006649545644, 'Margarita', 35, NULL, 'https://i.imgur.com/RWrBdG5.jpg'),
(0000000048, 0000000003, 0000000003, 00000000006649545644, 'Miješana', 40, NULL, 'https://i.imgur.com/14n5Bqw.jpg'),
(0000000049, 0000000003, 0000000003, 00000000006649545644, 'Vesuvio', 40, NULL, 'https://i.imgur.com/thwYz0X.jpg'),
(0000000050, 0000000003, 0000000003, 00000000006649545644, 'Pršut', 45, NULL, 'https://i.imgur.com/PYTRWVa.jpg'),
(0000000051, 0000000003, 0000000003, 00000000006649545644, 'Pizzaiolo', 45, NULL, 'https://i.imgur.com/cKh6exa.jpg'),
(0000000052, 0000000003, 0000000001, 00000000001319508091, 'Quesadilla s piletinom', 57, NULL, 'https://i.imgur.com/aoYpyHO.jpg'),
(0000000053, 0000000003, 0000000001, 00000000001319508091, 'Quesadilla s mljevenim mesom', 57, NULL, 'https://i.imgur.com/kdyi3x2.jpg'),
(0000000054, 0000000003, 0000000001, 00000000001319508091, 'Tacosi s piletinom', 61, NULL, 'https://i.imgur.com/7vBR0wS.jpg'),
(0000000055, 0000000003, 0000000001, 00000000001319508091, 'Tacosi s mljevenim mesom', 61, NULL, 'https://i.imgur.com/b5HcvSr.jpg'),
(0000000056, 0000000003, 0000000006, 00000000004548097233, 'Kokodakalo', 64, 'Pileća prsa punjena špinatom i bademom u mascarpone umaku', 'https://i.imgur.com/9Jw3KSw.jpg'),
(0000000057, 0000000003, 0000000006, 00000000004548097233, 'Muuuu!', 115, 'Biftek na žaru s gratiniranim povrćem', 'https://i.imgur.com/sEojPI8.jpg'),
(0000000058, 0000000003, 0000000006, 00000000004548097233, 'Pivkanburger', 50, 'Burger od junetine u pivskom umaku s krumpirom', 'https://i.imgur.com/DUXPMNE.jpg'),
(0000000059, 0000000003, 0000000006, 00000000004548097233, 'Pliska', 60, 'Pljeskavica s kajmakom i krumpirom', 'https://i.imgur.com/zt5SiDl.jpg'),
(0000000060, 0000000004, 0000000008, 00000000006649545644, 'Cheesecake', 17, NULL, 'https://i.imgur.com/3Rvmnb0.jpg'),
(0000000061, 0000000004, 0000000008, 00000000006649545644, 'Sladoled vanilija', 9, NULL, 'https://i.imgur.com/4DhFVrP.jpg'),
(0000000062, 0000000004, 0000000008, 00000000006649545644, 'Pačalinka', 21, 'Palačinke sa sladoledom i nutellom', 'https://i.imgur.com/fEngoPW.jpg'),
(0000000063, 0000000004, 0000000008, 00000000006649545644, 'Sladoled čokolada', 9, NULL, 'https://i.imgur.com/zcrWpwN.jpg'),
(0000000064, 0000000002, 0000000007, 00000000001319508091, 'Goveđa juha', 14, NULL, 'https://i.imgur.com/sEr1VOi.jpg'),
(0000000065, 0000000002, 0000000007, 00000000001319508091, 'Juha od gljiva', 16, NULL, 'https://i.imgur.com/gFBQaZK.jpg'),
(0000000066, 0000000002, 0000000007, 00000000001319508091, 'Juha od rajčice', 16, NULL, 'https://i.imgur.com/xQG5iRs.jpg'),
(0000000067, 0000000005, 0000000002, 00000000004548097233, 'Šopska salata', 19, NULL, 'https://i.imgur.com/sMUKOWM.jpg'),
(0000000068, 0000000005, 0000000002, 00000000004548097233, 'Salata s tunom', 29, NULL, 'https://i.imgur.com/jw49bCO.jpg'),
(0000000069, 0000000003, 0000000002, 00000000001319508091, 'Steak salata', 56, NULL, 'https://i.imgur.com/imiOBUW.jpg'),
(0000000070, 0000000003, 0000000002, 00000000006649545644, 'Salata s piletinom', 45, NULL, 'https://i.imgur.com/lRuBSRn.jpg'),
(0000000071, 0000000003, 0000000005, 00000000006649545644, 'Rižoto sa škampima', 66, NULL, 'https://i.imgur.com/Q1RbmOs.jpg'),
(0000000072, 0000000003, 0000000005, 00000000006649545644, 'Rižoto s piletinom i gljivama', 53, NULL, 'https://i.imgur.com/RnQjzyZ.jpg'),
(0000000073, 0000000003, 0000000005, 00000000004548097233, 'Vege rižoto', 49, NULL, 'https://i.imgur.com/pgBPGdS.jpg'),
(0000000074, 0000000003, 0000000004, 00000000001319508091, 'Penne sa gljivama', 51, NULL, 'https://i.imgur.com/G69r602.jpg'),
(0000000075, 0000000003, 0000000004, 00000000001319508091, 'Tagliatelle sa pršutom i gljivama', 56, NULL, 'https://i.imgur.com/BZgrHCx.jpg'),
(0000000076, 0000000003, 0000000004, 00000000001319508091, 'Wok špageti', 60, 'Špageti sa piletinom i povrćem pripremljeni u woku', 'https://i.imgur.com/YsW81AA.jpg');

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

--
-- Table structure for table `konobar`
--

CREATE TABLE `konobar` (
  `ID_konobar` bigint(10) UNSIGNED ZEROFILL NOT NULL,
  `ime_konobar` varchar(45) DEFAULT NULL,
  `prezime_konobar` varchar(45) DEFAULT NULL,
  `datum_rod_konobar` date DEFAULT NULL,
  `adresa_konobar` varchar(45) DEFAULT NULL,
  `grad_konobar` varchar(45) DEFAULT NULL,
  `postanski_broj_konobar` varchar(45) DEFAULT NULL,
  `placa_konobar` float DEFAULT NULL,
  `tel_konobar` varchar(45) DEFAULT NULL,
  `mail_konobar` varchar(45) DEFAULT NULL,
  `lozinka_konobar` varchar(45) DEFAULT NULL,
  `ocjena_konobar` varchar(45) DEFAULT '0',
  `level` tinyint(4) NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `konobar`
--

INSERT INTO `konobar` (`ID_konobar`, `ime_konobar`, `prezime_konobar`, `datum_rod_konobar`, `adresa_konobar`, `grad_konobar`, `postanski_broj_konobar`, `placa_konobar`, `tel_konobar`, `mail_konobar`, `lozinka_konobar`, `ocjena_konobar`, `level`) VALUES
(4326988897, 'Andrej', 'Rokvić', '1990-07-11', 'Danijela Godine 4', 'Rijeka', '51000', 6000, '095 954 4488', 'rokva.and@yahoo.com', 'alfaromeo45', '0', 1),
(4831524985, 'Jakov', 'Puljić', '1979-01-26', 'Vukovarska ulica 6', 'Rijeka', '51000', 8400, '099 454 3211', 'jakov.puljic@gmail.com', 'vukovri79', '0', 1),
(6549532366, 'Andrej', 'Filipović', '1988-11-02', 'Ciottina ulica 25', 'Rijeka', '51000', 6800, '091 985 3366', 'and.filipovic@gmail.com', 'andfil25', '0', 1);

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

--
-- Table structure for table `kuhar`
--

CREATE TABLE `kuhar` (
  `ID_kuhar` bigint(10) UNSIGNED ZEROFILL NOT NULL,
  `ime_kuhar` varchar(45) DEFAULT NULL,
  `prezime_kuhar` varchar(45) DEFAULT NULL,
  `datum_rod` date DEFAULT NULL,
  `adresa_kuhar` varchar(45) DEFAULT NULL,
  `grad_kuhar` varchar(45) DEFAULT NULL,
  `postanski_broj_kuhar` varchar(45) DEFAULT NULL,
  `placa_kuhar` float DEFAULT NULL,
  `tel_kuhar` varchar(45) DEFAULT NULL,
  `mail_kuhar` varchar(45) DEFAULT NULL,
  `lozinka_kuhar` varchar(45) DEFAULT NULL,
  `level` tinyint(4) NOT NULL DEFAULT '2'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `kuhar`
--

INSERT INTO `kuhar` (`ID_kuhar`, `ime_kuhar`, `prezime_kuhar`, `datum_rod`, `adresa_kuhar`, `grad_kuhar`, `postanski_broj_kuhar`, `placa_kuhar`, `tel_kuhar`, `mail_kuhar`, `lozinka_kuhar`, `level`) VALUES
(1319508091, 'Milan', 'Marković', '1991-04-07', 'Laginjina ulica 11a', 'Rijeka', '51000', 7800, '097 451 1133', 'milan.markovi@gmail.com', 'mikimilan11', 2),
(4548097233, 'Ronald', 'Makić', '1974-12-09', 'Krimeja 6', 'Rijeka', '51000', 10000, '095 0101 990', 'ronmaki@gmail.com', 'makiori6', 2),
(6649545644, 'Adrijan', 'Torić', '1989-02-18', 'J.P. Kamova 61', 'Rijeka', '51000', 7800, '099 985 9946', 'adrijan.toric@yahoo.com', 'ciroti61', 2);

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

--
-- Table structure for table `kuhar_priprema_jelo`
--

CREATE TABLE `kuhar_priprema_jelo` (
  `kuhar_ID_kuhar` bigint(20) UNSIGNED ZEROFILL NOT NULL,
  `jelo_ID_jelo` int(10) UNSIGNED ZEROFILL NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `narudzba`
--

CREATE TABLE `narudzba` (
  `jelo_ID_jelo` int(10) UNSIGNED ZEROFILL NOT NULL,
  `racun_ID_racun` int(10) UNSIGNED ZEROFILL NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='  ';

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

--
-- Table structure for table `pica_na_racunu`
--

CREATE TABLE `pica_na_racunu` (
  `pice_ID_pice` int(10) UNSIGNED ZEROFILL NOT NULL,
  `račun_ID_račun` int(10) UNSIGNED ZEROFILL NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `pice`
--

CREATE TABLE `pice` (
  `ID_pice` int(10) UNSIGNED ZEROFILL NOT NULL,
  `naziv_pice` varchar(45) DEFAULT NULL,
  `cijena_pice` int(10) UNSIGNED DEFAULT NULL,
  `ulazna_cijena_pice` int(5) NOT NULL,
  `kolicina_pice` float DEFAULT NULL,
  `vrsta_pica_ID_vrsta_pica` int(10) UNSIGNED ZEROFILL NOT NULL,
  `slika_pice` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `pice`
--

INSERT INTO `pice` (`ID_pice`, `naziv_pice`, `cijena_pice`, `ulazna_cijena_pice`, `kolicina_pice`, `vrsta_pica_ID_vrsta_pica`, `slika_pice`) VALUES
(0000000001, 'Voda 0.5 L', 10, 4, 0.5, 0000000002, 'https://i.imgur.com/815Fc1q.jpg'),
(0000000002, 'Voda 1L', 15, 6, 1, 0000000002, 'https://i.imgur.com/815Fc1q.jpg'),
(0000000003, 'Coca Cola', 15, 5, 0.25, 0000000002, 'https://i.imgur.com/zUhrnYM.jpg'),
(0000000004, 'Fanta', 15, 5, 0.25, 0000000002, 'https://i.imgur.com/qgZxrh6.png'),
(0000000005, 'Sprite', 15, 5, 0.25, 0000000002, 'https://i.imgur.com/RTD0Rxk.jpg'),
(0000000006, 'Mineralna voda 0.25', 12, 4, 0.25, 0000000002, 'https://i.imgur.com/eTsnJjK.jpg'),
(0000000007, 'Schweppes Tangerine', 15, 5, 0.25, 0000000002, 'https://i.imgur.com/vBqYjOF.jpg'),
(0000000008, 'Schweppes Bitter Lemon', 15, 5, 0.25, 0000000002, 'https://i.imgur.com/lgGCg73.jpg'),
(0000000009, 'Mineralna voda 0.5L', 15, 5, 0.5, 0000000002, 'https://i.imgur.com/eTsnJjK.jpg'),
(0000000010, 'Mineralna voda 1L', 20, 7, 1, 0000000002, 'https://i.imgur.com/eTsnJjK.jpg'),
(0000000011, 'Ledeni čaj', 15, 5, 0.25, 0000000002, 'https://i.imgur.com/PeySGSC.png'),
(0000000012, 'Voćni sok jabuka', 14, 5, 0.2, 0000000002, 'https://i.imgur.com/MNCVliG.jpg'),
(0000000013, 'Voćni sok jagoda', 15, 5, 0.2, 0000000002, 'https://i.imgur.com/hGzUUam.jpg'),
(0000000014, 'Voćni sok naranča', 15, 5, 0.2, 0000000002, 'https://i.imgur.com/xebdXjb.jpg'),
(0000000015, 'Voćni sok banana', 15, 5, 0.2, 0000000002, 'https://i.imgur.com/sY5GIvV.jpg'),
(0000000016, 'Tuborg 0.33L', 18, 6, 0.33, 0000000003, 'https://i.imgur.com/DXHnNTK.jpg'),
(0000000017, 'Heineken', 18, 6, 0.33, 0000000003, 'https://i.imgur.com/owkrm3r.jpg'),
(0000000018, 'Velebitsko kasačko', 22, 8, 0.33, 0000000003, 'https://i.imgur.com/7DUUfvQ.jpg'),
(0000000019, 'Zmajsko Pale Ale', 23, 11, 0.5, 0000000003, 'https://i.imgur.com/F76wyRi.jpg'),
(0000000020, 'Carlsberg 0.33L', 20, 7, 0.33, 0000000003, 'https://i.imgur.com/zj1sES6.png'),
(0000000021, 'Budweiser 0.33L', 20, 7, 0.33, 0000000003, 'https://i.imgur.com/62b3fS1.png'),
(0000000022, 'Jack Daniels', 20, 5, 0.03, 0000000005, 'https://i.imgur.com/eonwb5b.jpg'),
(0000000023, 'Pelinkovac', 10, 3, 0.03, 0000000005, 'https://i.imgur.com/dCaM9dm.jpg'),
(0000000024, 'Ballantines', 17, 4, 0.03, 0000000005, 'https://i.imgur.com/WKf5bHJ.jpg'),
(0000000025, 'Vodka', 12, 4, 0.03, 0000000005, 'https://i.imgur.com/O316NI2.jpg'),
(0000000026, 'Travarica', 11, 3, 0.03, 0000000005, 'https://i.imgur.com/M7l3ech.jpg'),
(0000000027, 'Loza', 11, 3, 0.03, 0000000005, 'https://i.imgur.com/H2PJtP3.jpg'),
(0000000028, 'Šljiva', 11, 3, 0.03, 0000000005, 'https://i.imgur.com/LyMiA5z.jpg'),
(0000000029, 'Orahovica', 11, 3, 0.03, 0000000005, 'https://i.imgur.com/DGmUh8Z.jpg'),
(0000000030, 'Žlahtina 0.75L', 100, 29, 0.75, 0000000004, 'https://i.imgur.com/KcdZQB8.jpg'),
(0000000031, 'Zlatna žlahtina 0.75L', 180, 45, 0.75, 0000000004, 'https://i.imgur.com/h8t3I0V.png'),
(0000000032, 'Cabernet Sauvignon 0.75L', 110, 33, 0.75, 0000000004, 'https://i.imgur.com/5R3a71Z.jpg'),
(0000000033, 'Zlatni Plavac 0.75L', 190, 53, 0.75, 0000000004, 'https://i.imgur.com/o9lCSbM.jpg'),
(0000000034, 'Kava', 8, 3, 0.1, 0000000001, 'https://i.imgur.com/bAgwtbo.png'),
(0000000035, 'Cappuccino', 10, 3, 0.15, 0000000001, 'https://i.imgur.com/N3qUwsX.png'),
(0000000036, 'Čaj', 10, 3, 0.2, 0000000001, 'https://i.imgur.com/OLRTb9M.jpg'),
(0000000037, 'Nescafe', 12, 5, 0.2, 0000000001, 'https://i.imgur.com/5empHPa.jpg');

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

--
-- Table structure for table `pomocna`
--

CREATE TABLE `pomocna` (
  `br_po_str` int(5) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `pomocna`
--

INSERT INTO `pomocna` (`br_po_str`) VALUES
(8);

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

--
-- Table structure for table `racun`
--

CREATE TABLE `racun` (
  `ID_racun` int(10) UNSIGNED ZEROFILL NOT NULL,
  `konobar_ID_konobar` bigint(20) UNSIGNED ZEROFILL NOT NULL,
  `gost_ID_gost` bigint(20) UNSIGNED ZEROFILL NOT NULL,
  `datum` date DEFAULT NULL,
  `iznos_racun` double DEFAULT NULL,
  `broj_stola` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `recenzija`
--

CREATE TABLE `recenzija` (
  `ID_preporuka` int(11) NOT NULL,
  `jelo_ID_jelo` int(100) UNSIGNED ZEROFILL NOT NULL,
  `gost_ID_gost` bigint(20) UNSIGNED ZEROFILL NOT NULL,
  `komentar` varchar(100) DEFAULT NULL,
  `ocjena` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `sastojak`
--

CREATE TABLE `sastojak` (
  `ID_sastojak` int(10) UNSIGNED ZEROFILL NOT NULL,
  `naziv_sastojak` varchar(45) DEFAULT NULL,
  `kolicina_sastojak` float DEFAULT NULL,
  `cijena_sastojak` float DEFAULT NULL,
  `kalorije_sastojak` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sastojak`
--

INSERT INTO `sastojak` (`ID_sastojak`, `naziv_sastojak`, `kolicina_sastojak`, `cijena_sastojak`, `kalorije_sastojak`) VALUES
(0000000001, 'Sir za pizzu', 1000, 65, 280),
(0000000002, 'Šunka za pizzu', 1000, 21, 275),
(0000000003, 'Pelati', 1000, 17, 22),
(0000000004, 'Šampinjoni', 1000, 32, 26),
(0000000005, 'Pršut dalmatinski', 1000, 129, 268),
(0000000006, 'Paprika MIX', 1000, 18, 39),
(0000000007, 'Kiselo vrhnje', 1000, 20, 192),
(0000000008, 'Tortilja pšenična', 10, 25, 232),
(0000000009, 'Pileća prsa', 1000, 43, 239),
(0000000010, 'Gauda sir', 1000, 64, 356),
(0000000011, 'Grah crveni', 1000, 19, 110),
(0000000012, 'Kukuruz konzerva', 1000, 17, 115),
(0000000013, 'Mljeveno meso', 1000, 43, 240),
(0000000014, 'Crveni luk ', 1000, 7, 39),
(0000000015, 'Češnjak', 1000, 40, 148),
(0000000016, 'Pasirana rajčica', 1000, 14, 37),
(0000000017, 'Zelena salata', 1000, 9, 14),
(0000000018, 'Med', 1000, 70, 304),
(0000000019, 'Mrkva', 1000, 9, 41),
(0000000020, 'Pašta špageti', 1000, 15, 154),
(0000000021, 'Pašta penne', 1000, 15, 118),
(0000000022, 'Pašta tagliatele', 1000, 26, 288),
(0000000023, 'Škampi', 1000, 80, 118),
(0000000024, 'Riža', 1000, 17, 130),
(0000000025, 'Tuna u konzervi', 1000, 140, 204),
(0000000026, 'Feta sir', 1000, 80, 263),
(0000000027, 'Cherry rajčica', 1000, 54, 28),
(0000000028, 'Rajčica', 1000, 21, 19),
(0000000029, 'Crne masline', 1000, 35, 115),
(0000000030, 'Kupus svježi', 1000, 18, 24),
(0000000031, 'Biftek', 1000, 180, 137),
(0000000032, 'Goveđi temeljac', 1000, 112, 575),
(0000000033, 'Brašno', 1000, 4, 364),
(0000000034, 'PB keksi', 1000, 20, 434),
(0000000035, 'Bijeli šećer', 1000, 6, 384),
(0000000036, 'Jaja', 100, 200, 155),
(0000000037, 'Svježi sir', 1000, 30, 98),
(0000000038, 'Maslac', 1000, 80, 716),
(0000000039, 'Sladoled vanilija', 1000, 10, 150),
(0000000040, 'Sladoled čokolada', 1000, 13, 153),
(0000000041, 'Nutella', 1000, 56, 534),
(0000000042, 'Krumpir', 1000, 4, 76),
(0000000043, 'Špinat', 1000, 19, 24),
(0000000044, 'Bademi', 1000, 90, 574),
(0000000045, 'Kajmak', 1000, 70, 481);

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

--
-- Table structure for table `sastojci_jela`
--

CREATE TABLE `sastojci_jela` (
  `jelo_ID_jelo` int(10) UNSIGNED ZEROFILL NOT NULL,
  `sastojak_ID_sastojak` int(10) UNSIGNED ZEROFILL NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sastojci_jela`
--

INSERT INTO `sastojci_jela` (`jelo_ID_jelo`, `sastojak_ID_sastojak`) VALUES
(0000000047, 0000000001),
(0000000047, 0000000003),
(0000000048, 0000000001),
(0000000048, 0000000002),
(0000000048, 0000000003),
(0000000048, 0000000004),
(0000000048, 0000000029),
(0000000049, 0000000001),
(0000000049, 0000000002),
(0000000049, 0000000003),
(0000000050, 0000000001),
(0000000050, 0000000003),
(0000000050, 0000000005),
(0000000050, 0000000029),
(0000000051, 0000000001),
(0000000051, 0000000002),
(0000000051, 0000000003),
(0000000051, 0000000004),
(0000000051, 0000000006),
(0000000051, 0000000007),
(0000000052, 0000000006),
(0000000052, 0000000007),
(0000000052, 0000000008),
(0000000052, 0000000009),
(0000000052, 0000000010),
(0000000052, 0000000011),
(0000000052, 0000000012),
(0000000053, 0000000007),
(0000000053, 0000000008),
(0000000053, 0000000010),
(0000000053, 0000000011),
(0000000053, 0000000012),
(0000000053, 0000000013),
(0000000054, 0000000007),
(0000000054, 0000000008),
(0000000054, 0000000009),
(0000000054, 0000000014),
(0000000054, 0000000015),
(0000000054, 0000000016),
(0000000054, 0000000017),
(0000000055, 0000000007),
(0000000055, 0000000008),
(0000000055, 0000000011),
(0000000055, 0000000013),
(0000000055, 0000000014),
(0000000055, 0000000015),
(0000000055, 0000000016),
(0000000055, 0000000017),
(0000000056, 0000000009),
(0000000056, 0000000037),
(0000000056, 0000000043),
(0000000056, 0000000044),
(0000000057, 0000000006),
(0000000057, 0000000014),
(0000000057, 0000000019),
(0000000057, 0000000031),
(0000000058, 0000000013),
(0000000058, 0000000042),
(0000000059, 0000000001),
(0000000059, 0000000013),
(0000000059, 0000000042),
(0000000059, 0000000045),
(0000000060, 0000000007),
(0000000060, 0000000034),
(0000000060, 0000000035),
(0000000060, 0000000036),
(0000000060, 0000000037),
(0000000060, 0000000038),
(0000000061, 0000000039),
(0000000062, 0000000039),
(0000000062, 0000000041),
(0000000063, 0000000040),
(0000000064, 0000000032),
(0000000065, 0000000004),
(0000000066, 0000000016),
(0000000067, 0000000006),
(0000000067, 0000000011),
(0000000067, 0000000012),
(0000000067, 0000000014),
(0000000067, 0000000017),
(0000000067, 0000000026),
(0000000067, 0000000030),
(0000000068, 0000000006),
(0000000068, 0000000012),
(0000000068, 0000000017),
(0000000068, 0000000025),
(0000000068, 0000000027),
(0000000069, 0000000017),
(0000000069, 0000000027),
(0000000069, 0000000029),
(0000000069, 0000000030),
(0000000069, 0000000031),
(0000000070, 0000000006),
(0000000070, 0000000009),
(0000000070, 0000000017),
(0000000070, 0000000026),
(0000000070, 0000000028),
(0000000071, 0000000016),
(0000000071, 0000000023),
(0000000071, 0000000024),
(0000000072, 0000000004),
(0000000072, 0000000009),
(0000000072, 0000000016),
(0000000072, 0000000024),
(0000000073, 0000000004),
(0000000073, 0000000006),
(0000000073, 0000000012),
(0000000073, 0000000014),
(0000000073, 0000000015),
(0000000073, 0000000016),
(0000000073, 0000000024),
(0000000074, 0000000004),
(0000000074, 0000000016),
(0000000074, 0000000021),
(0000000075, 0000000004),
(0000000075, 0000000005),
(0000000075, 0000000007),
(0000000075, 0000000022),
(0000000075, 0000000027),
(0000000076, 0000000006),
(0000000076, 0000000009),
(0000000076, 0000000014),
(0000000076, 0000000018),
(0000000076, 0000000019),
(0000000076, 0000000020);

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

--
-- Table structure for table `tip`
--

CREATE TABLE `tip` (
  `ID_tip` int(10) UNSIGNED ZEROFILL NOT NULL,
  `naziv_tip` varchar(45) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `tip`
--

INSERT INTO `tip` (`ID_tip`, `naziv_tip`) VALUES
(0000000001, 'Hladno predjelo'),
(0000000002, 'Toplo predjelo'),
(0000000003, 'Glavno jelo'),
(0000000004, 'Desert'),
(0000000005, 'Salate');

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

--
-- Table structure for table `vrsta_pica`
--

CREATE TABLE `vrsta_pica` (
  `ID_vrsta_pica` int(10) UNSIGNED ZEROFILL NOT NULL,
  `vrsta_pica` varchar(45) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `vrsta_pica`
--

INSERT INTO `vrsta_pica` (`ID_vrsta_pica`, `vrsta_pica`) VALUES
(0000000002, 'Bezalkoholna pića'),
(0000000003, 'Piva'),
(0000000001, 'Topli napitci'),
(0000000004, 'Vina'),
(0000000005, 'Žestoka pića');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `admin`
--
ALTER TABLE `admin`
  ADD PRIMARY KEY (`username`);

--
-- Indexes for table `gost`
--
ALTER TABLE `gost`
  ADD PRIMARY KEY (`ID_gost`);

--
-- Indexes for table `grupa`
--
ALTER TABLE `grupa`
  ADD PRIMARY KEY (`ID_grupa`),
  ADD UNIQUE KEY `idtip_kuhinja_jelo_UNIQUE` (`ID_grupa`);

--
-- Indexes for table `jelo`
--
ALTER TABLE `jelo`
  ADD PRIMARY KEY (`ID_jelo`),
  ADD UNIQUE KEY `idjelo_UNIQUE` (`ID_jelo`),
  ADD KEY `fk_jelo_tip_kuhinja_jelo1_idx` (`grupa_ID_grupa`),
  ADD KEY `fk_jelo_tip1_idx` (`tip_ID_tip`),
  ADD KEY `fk_jelo_kuhar1_idx` (`kuhar_ID_kuhar`);

--
-- Indexes for table `konobar`
--
ALTER TABLE `konobar`
  ADD PRIMARY KEY (`ID_konobar`);

--
-- Indexes for table `kuhar`
--
ALTER TABLE `kuhar`
  ADD PRIMARY KEY (`ID_kuhar`),
  ADD UNIQUE KEY `id_kuhar_UNIQUE` (`ID_kuhar`);

--
-- Indexes for table `kuhar_priprema_jelo`
--
ALTER TABLE `kuhar_priprema_jelo`
  ADD PRIMARY KEY (`kuhar_ID_kuhar`,`jelo_ID_jelo`),
  ADD KEY `fk_kuhar_has_jelo_jelo1_idx` (`jelo_ID_jelo`),
  ADD KEY `fk_kuhar_has_jelo_kuhar1_idx` (`kuhar_ID_kuhar`);

--
-- Indexes for table `narudzba`
--
ALTER TABLE `narudzba`
  ADD PRIMARY KEY (`jelo_ID_jelo`,`racun_ID_racun`),
  ADD KEY `fk_jelo_has_račun_račun1_idx` (`racun_ID_racun`),
  ADD KEY `fk_jelo_has_račun_jelo1_idx` (`jelo_ID_jelo`);

--
-- Indexes for table `pica_na_racunu`
--
ALTER TABLE `pica_na_racunu`
  ADD PRIMARY KEY (`pice_ID_pice`,`račun_ID_račun`),
  ADD KEY `fk_pice_has_račun_račun1_idx` (`račun_ID_račun`),
  ADD KEY `fk_pice_has_račun_pice1_idx` (`pice_ID_pice`);

--
-- Indexes for table `pice`
--
ALTER TABLE `pice`
  ADD PRIMARY KEY (`ID_pice`),
  ADD KEY `fk_pice_vrsta_pica1_idx` (`vrsta_pica_ID_vrsta_pica`);

--
-- Indexes for table `racun`
--
ALTER TABLE `racun`
  ADD PRIMARY KEY (`ID_racun`),
  ADD KEY `fk_račun_konobar1_idx` (`konobar_ID_konobar`),
  ADD KEY `fk_račun_gost1_idx` (`gost_ID_gost`);

--
-- Indexes for table `recenzija`
--
ALTER TABLE `recenzija`
  ADD PRIMARY KEY (`ID_preporuka`),
  ADD KEY `fk_preporuka_jelo1_idx` (`jelo_ID_jelo`),
  ADD KEY `fk_preporuka_gost1_idx` (`gost_ID_gost`);

--
-- Indexes for table `sastojak`
--
ALTER TABLE `sastojak`
  ADD PRIMARY KEY (`ID_sastojak`),
  ADD UNIQUE KEY `id_sastojci_UNIQUE` (`ID_sastojak`);

--
-- Indexes for table `sastojci_jela`
--
ALTER TABLE `sastojci_jela`
  ADD PRIMARY KEY (`jelo_ID_jelo`,`sastojak_ID_sastojak`),
  ADD KEY `fk_jelo_has_sastojak_sastojak1_idx` (`sastojak_ID_sastojak`),
  ADD KEY `fk_jelo_has_sastojak_jelo_idx` (`jelo_ID_jelo`);

--
-- Indexes for table `tip`
--
ALTER TABLE `tip`
  ADD PRIMARY KEY (`ID_tip`),
  ADD UNIQUE KEY `id_tip_UNIQUE` (`ID_tip`);

--
-- Indexes for table `vrsta_pica`
--
ALTER TABLE `vrsta_pica`
  ADD PRIMARY KEY (`ID_vrsta_pica`),
  ADD UNIQUE KEY `ID_vrsta_pica_UNIQUE` (`ID_vrsta_pica`),
  ADD UNIQUE KEY `vrsta_pica_UNIQUE` (`vrsta_pica`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `gost`
--
ALTER TABLE `gost`
  MODIFY `ID_gost` bigint(10) UNSIGNED ZEROFILL NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;

--
-- AUTO_INCREMENT for table `jelo`
--
ALTER TABLE `jelo`
  MODIFY `ID_jelo` int(10) UNSIGNED ZEROFILL NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=77;

--
-- AUTO_INCREMENT for table `konobar`
--
ALTER TABLE `konobar`
  MODIFY `ID_konobar` bigint(10) UNSIGNED ZEROFILL NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2147483647;

--
-- AUTO_INCREMENT for table `kuhar`
--
ALTER TABLE `kuhar`
  MODIFY `ID_kuhar` bigint(10) UNSIGNED ZEROFILL NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2147483647;

--
-- AUTO_INCREMENT for table `pice`
--
ALTER TABLE `pice`
  MODIFY `ID_pice` int(10) UNSIGNED ZEROFILL NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=38;

--
-- AUTO_INCREMENT for table `racun`
--
ALTER TABLE `racun`
  MODIFY `ID_racun` int(10) UNSIGNED ZEROFILL NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `recenzija`
--
ALTER TABLE `recenzija`
  MODIFY `ID_preporuka` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `sastojak`
--
ALTER TABLE `sastojak`
  MODIFY `ID_sastojak` int(10) UNSIGNED ZEROFILL NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=46;

--
-- AUTO_INCREMENT for table `tip`
--
ALTER TABLE `tip`
  MODIFY `ID_tip` int(10) UNSIGNED ZEROFILL NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `vrsta_pica`
--
ALTER TABLE `vrsta_pica`
  MODIFY `ID_vrsta_pica` int(10) UNSIGNED ZEROFILL NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `jelo`
--
ALTER TABLE `jelo`
  ADD CONSTRAINT `fk_jelo_kuhar1` FOREIGN KEY (`kuhar_ID_kuhar`) REFERENCES `kuhar` (`ID_kuhar`) ON DELETE CASCADE,
  ADD CONSTRAINT `fk_jelo_tip1` FOREIGN KEY (`tip_ID_tip`) REFERENCES `tip` (`ID_tip`) ON DELETE CASCADE,
  ADD CONSTRAINT `fk_jelo_tip_kuhinja_jelo1` FOREIGN KEY (`grupa_ID_grupa`) REFERENCES `grupa` (`ID_grupa`) ON DELETE CASCADE;

--
-- Constraints for table `kuhar_priprema_jelo`
--
ALTER TABLE `kuhar_priprema_jelo`
  ADD CONSTRAINT `fk_kuhar_has_jelo_jelo1` FOREIGN KEY (`jelo_ID_jelo`) REFERENCES `jelo` (`ID_jelo`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  ADD CONSTRAINT `fk_kuhar_has_jelo_kuhar1` FOREIGN KEY (`kuhar_ID_kuhar`) REFERENCES `kuhar` (`ID_kuhar`) ON DELETE NO ACTION ON UPDATE NO ACTION;

--
-- Constraints for table `narudzba`
--
ALTER TABLE `narudzba`
  ADD CONSTRAINT `fk_jelo_has_račun_jelo1` FOREIGN KEY (`jelo_ID_jelo`) REFERENCES `jelo` (`ID_jelo`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  ADD CONSTRAINT `fk_jelo_has_račun_račun1` FOREIGN KEY (`racun_ID_racun`) REFERENCES `racun` (`ID_racun`) ON DELETE NO ACTION ON UPDATE NO ACTION;

--
-- Constraints for table `pica_na_racunu`
--
ALTER TABLE `pica_na_racunu`
  ADD CONSTRAINT `fk_pice_has_račun_pice1` FOREIGN KEY (`pice_ID_pice`) REFERENCES `pice` (`ID_pice`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  ADD CONSTRAINT `fk_pice_has_račun_račun1` FOREIGN KEY (`račun_ID_račun`) REFERENCES `racun` (`ID_racun`) ON DELETE NO ACTION ON UPDATE NO ACTION;

--
-- Constraints for table `pice`
--
ALTER TABLE `pice`
  ADD CONSTRAINT `fk_pice_vrsta_pica1` FOREIGN KEY (`vrsta_pica_ID_vrsta_pica`) REFERENCES `vrsta_pica` (`ID_vrsta_pica`) ON DELETE NO ACTION ON UPDATE NO ACTION;

--
-- Constraints for table `racun`
--
ALTER TABLE `racun`
  ADD CONSTRAINT `fk_račun_gost1` FOREIGN KEY (`gost_ID_gost`) REFERENCES `gost` (`ID_gost`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  ADD CONSTRAINT `fk_račun_konobar1` FOREIGN KEY (`konobar_ID_konobar`) REFERENCES `konobar` (`ID_konobar`) ON DELETE NO ACTION ON UPDATE NO ACTION;

--
-- Constraints for table `recenzija`
--
ALTER TABLE `recenzija`
  ADD CONSTRAINT `fk_preporuka_gost1` FOREIGN KEY (`gost_ID_gost`) REFERENCES `gost` (`ID_gost`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  ADD CONSTRAINT `fk_preporuka_jelo1` FOREIGN KEY (`jelo_ID_jelo`) REFERENCES `jelo` (`ID_jelo`) ON DELETE NO ACTION ON UPDATE NO ACTION;

--
-- Constraints for table `sastojci_jela`
--
ALTER TABLE `sastojci_jela`
  ADD CONSTRAINT `fk_jelo_has_sastojak_jelo` FOREIGN KEY (`jelo_ID_jelo`) REFERENCES `jelo` (`ID_jelo`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  ADD CONSTRAINT `fk_jelo_has_sastojak_sastojak1` FOREIGN KEY (`sastojak_ID_sastojak`) REFERENCES `sastojak` (`ID_sastojak`) ON DELETE NO ACTION ON UPDATE NO ACTION;
COMMIT;

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