Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- phpMyAdmin SQL Dump
- -- version 4.7.4
- -- https://www.phpmyadmin.net/
- --
- -- Host: 127.0.0.1
- -- Generation Time: Jan 07, 2018 at 06:58 PM
- -- Server version: 10.1.29-MariaDB
- -- PHP Version: 7.2.0
- 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 `gost`
- --
- CREATE TABLE `gost` (
- `ID_gost` bigint(10) UNSIGNED ZEROFILL NOT NULL,
- `ime_gost` varchar(45) DEFAULT NULL,
- `prezime_gost` varchar(45) DEFAULT NULL,
- `datum_rod_gost` date 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 NULL,
- `mail_gost` varchar(45) DEFAULT NULL,
- `lozinka_gost` varchar(15) DEFAULT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- --
- -- Dumping data for table `gost`
- --
- INSERT INTO `gost` (`ID_gost`, `ime_gost`, `prezime_gost`, `datum_rod_gost`, `adresa_gost`, `grad_gost`, `postanski_broj_gost`, `spol_gost`, `bodovi_gost`, `mail_gost`, `lozinka_gost`) VALUES
- (0000000001, 'Ivan', 'Marić', '1996-12-01', 'Ulica Nikole Tesle 23', 'Rijeka', '51000', 'M', 0, 'iv.mar@gmail.com', 'rdvatr23');
- -- --------------------------------------------------------
- --
- -- 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 NULL
- ) 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`) VALUES
- (4326988897, 'Andrej', 'Rokvić', '1990-07-11', 'Danijela Godine 4', 'Rijeka', '51000', 6000, '095 954 4488', 'rokva.and@yahoo.com', 'alfaromeo45', NULL),
- (4831524985, 'Jakov', 'Puljić', '1979-01-26', 'Vukovarska ulica 6', 'Rijeka', '51000', 8400, '099 454 3211', 'jakov.puljic@gmail.com', 'vukovri79', NULL),
- (6549532366, 'Andrej', 'Filipović', '1988-11-02', 'Ciottina ulica 25', 'Rijeka', '51000', 6800, '091 985 3366', 'and.filipovic@gmail.com', 'andfil25', NULL);
- -- --------------------------------------------------------
- --
- -- 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
- ) 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`) VALUES
- (1319508091, 'Milan', 'Marković', '1991-04-07', 'Laginjina ulica 11a', 'Rijeka', '51000', 7800, '097 451 1133', 'milan.markovi@gmail.com', 'mikimilan11'),
- (4548097233, 'Ronald', 'Makić', '1974-12-09', 'Krimeja 6', 'Rijeka', '51000', 10000, '095 0101 990', 'ronmaki@gmail.com', 'makiori6'),
- (6649545644, 'Adrijan', 'Torić', '1989-02-18', 'J.P. Kamova 61', 'Rijeka', '51000', 7800, '099 985 9946', 'adrijan.toric@yahoo.com', 'ciroti61');
- -- --------------------------------------------------------
- --
- -- 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 `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=2;
- --
- -- 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 */;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement