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 05, 2018 at 02:32 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(20) 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
- (00000000000000000001, '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, 'Slatko');
- -- --------------------------------------------------------
- --
- -- Table structure for table `jelo`
- --
- CREATE TABLE `jelo` (
- `ID_jelo` int(5) 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` int(4) UNSIGNED DEFAULT NULL,
- `opis` varchar(100) DEFAULT 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`, `opis`) VALUES
- (00001, 0000000003, 0000000003, 00000000006649545644, 'Margarita', 35, NULL),
- (00002, 0000000003, 0000000003, 00000000006649545644, 'Miješana', 40, NULL),
- (00003, 0000000003, 0000000003, 00000000006649545644, 'Vesuvio', 40, NULL),
- (00004, 0000000003, 0000000003, 00000000006649545644, 'Pršut', 45, NULL),
- (00005, 0000000003, 0000000003, 00000000006649545644, 'Pizzaiolo', 45, NULL),
- (00006, 0000000003, 0000000001, 00000000001319508091, 'Quesadilla s piletinom', 57, NULL),
- (00007, 0000000003, 0000000001, 00000000001319508091, 'Quesadilla s mljevenim mesom', 57, NULL),
- (00008, 0000000003, 0000000001, 00000000001319508091, 'Tacosi s piletinom', 61, NULL),
- (00009, 0000000003, 0000000001, 00000000001319508091, 'Tacosi s mljevenim mesom', 61, NULL),
- (00010, 0000000003, 0000000006, 00000000004548097233, 'Kokodakalo', 64, 'Pileća prsa punjena špinatom i bademom u mascarpone umaku'),
- (00011, 0000000003, 0000000006, 00000000004548097233, 'Muuuu!', 115, 'Biftek na žaru s gratiniranim povrćem'),
- (00012, 0000000003, 0000000006, 00000000004548097233, 'Pivkanburger', 50, 'Burger od junetine u pivskom umaku s krumpirom'),
- (00013, 0000000003, 0000000006, 00000000004548097233, 'Pliska', 60, 'Pljeskavica s kajmakom i krumpirom'),
- (00014, 0000000004, 0000000008, 00000000006649545644, 'Cheesecake', 17, NULL),
- (00015, 0000000004, 0000000008, 00000000006649545644, 'Sladoled vanilija', 9, NULL),
- (00016, 0000000004, 0000000008, 00000000006649545644, 'Pačalinka', 21, 'Palačinke sa sladoledom i nutellom'),
- (00017, 0000000004, 0000000008, 00000000006649545644, 'Sladoled čokolada', 9, NULL),
- (00018, 0000000002, 0000000007, 00000000001319508091, 'Goveđa juha', 14, NULL),
- (00019, 0000000002, 0000000007, 00000000001319508091, 'Juha od gljiva', 16, NULL),
- (00020, 0000000002, 0000000007, 00000000001319508091, 'Juha od rajčice', 16, NULL),
- (00021, 0000000005, 0000000002, 00000000004548097233, 'Šopska salata', 19, NULL),
- (00022, 0000000005, 0000000002, 00000000004548097233, 'Salata s tunom', 29, NULL),
- (00023, 0000000003, 0000000002, 00000000001319508091, 'Steak salata', 56, NULL),
- (00024, 0000000003, 0000000002, 00000000006649545644, 'Salata s piletinom', 45, NULL),
- (00025, 0000000003, 0000000005, 00000000006649545644, 'Rižoto sa škampima', 66, NULL),
- (00026, 0000000003, 0000000005, 00000000006649545644, 'Rižoto s piletinom i gljivama', 53, NULL),
- (00027, 0000000003, 0000000005, 00000000004548097233, 'Rižoto s povrćem', 49, NULL),
- (00028, 0000000003, 0000000004, 00000000001319508091, 'Penne sa gljivama', 51, NULL),
- (00029, 0000000003, 0000000004, 00000000001319508091, 'Tagliatelle sa pršutom i gljivama', 56, NULL),
- (00030, 0000000003, 0000000004, 00000000001319508091, 'Wok špageti', 60, 'Špageti sa piletinom i povrćem pripremljeni u woku');
- -- --------------------------------------------------------
- --
- -- 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
- ) 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`) VALUES
- (0000000001, 'Voda 0.5 L', 10, 4, 0.5, 0000000002),
- (0000000002, 'Voda 1L', 15, 6, 1, 0000000002),
- (0000000003, 'Coca Cola', 15, 5, 0.25, 0000000002),
- (0000000004, 'Fanta', 15, 5, 0.25, 0000000002),
- (0000000005, 'Sprite', 15, 5, 0.25, 0000000002),
- (0000000006, 'Mineralna voda', 12, 4, 0.25, 0000000002),
- (0000000007, 'Schweppes Tangerine', 15, 5, 0.25, 0000000002),
- (0000000008, 'Schweppes Bitter Lemon', 15, 5, 0.25, 0000000002),
- (0000000009, 'Mineralna voda 0.5L', 15, 5, 0.5, 0000000002),
- (0000000010, 'Mineralna voda 1L', 20, 7, 1, 0000000002),
- (0000000011, 'Ledeni čaj', 15, 5, 0.25, 0000000002),
- (0000000012, 'Voćni sok jabuka', 14, 5, 0.2, 0000000002),
- (0000000013, 'Voćni sok jagoda', 15, 5, 0.2, 0000000002),
- (0000000014, 'Voćni sok naranča', 15, 5, 0.2, 0000000002),
- (0000000015, 'Voćni sok banana', 15, 5, 0.2, 0000000002),
- (0000000016, 'Tuborg 0.33L', 18, 6, 0.33, 0000000003),
- (0000000017, 'Heineken', 18, 6, 0.33, 0000000003),
- (0000000018, 'Velebitsko kasačko', 22, 8, 0.33, 0000000003),
- (0000000019, 'Zmajsko Pale Ale', 23, 11, 0.5, 0000000003),
- (0000000020, 'Carlsberg 0.33L', 20, 7, 0.33, 0000000003),
- (0000000021, 'Budweiser 0.33L', 20, 7, 0.33, 0000000003),
- (0000000022, 'Jack Daniels', 20, 5, 0.03, 0000000005),
- (0000000023, 'Pelinkovac', 10, 3, 0.03, 0000000005),
- (0000000024, 'Ballentines', 17, 4, 0.03, 0000000005),
- (0000000025, 'Vodka', 12, 4, 0.03, 0000000005),
- (0000000026, 'Travarica', 11, 3, 0.03, 0000000005),
- (0000000027, 'Loza', 11, 3, 0.03, 0000000005),
- (0000000028, 'Šljiva', 11, 3, 0.03, 0000000005),
- (0000000029, 'Orih', 11, 3, 0.03, 0000000005),
- (0000000030, 'Žlahtina 0.75L', 100, 29, 0.75, 0000000004),
- (0000000031, 'Zlatna žlahtina 0.75L', 180, 45, 0.75, 0000000004),
- (0000000032, 'Cabernet Sauvignon 0.75L', 110, 33, 0.75, 0000000004),
- (0000000033, 'Zlatni Plavac 0.75L', 190, 53, 0.75, 0000000004),
- (0000000034, 'Kava', 8, 3, 0.1, 0000000001),
- (0000000035, 'Capuccino', 10, 3, 0.15, 0000000001),
- (0000000036, 'Čaj', 10, 3, 0.2, 0000000001),
- (0000000037, 'Nescafe', 12, 5, 0.2, 0000000001);
- -- --------------------------------------------------------
- --
- -- 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),
- (0000000046, 'Vrhnje za kuhanje', 1000, 47, 209);
- -- --------------------------------------------------------
- --
- -- 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
- (0000000001, 0000000001),
- (0000000001, 0000000003),
- (0000000002, 0000000001),
- (0000000002, 0000000002),
- (0000000002, 0000000003),
- (0000000002, 0000000004),
- (0000000003, 0000000002),
- (0000000003, 0000000003),
- (0000000003, 0000000009),
- (0000000004, 0000000001),
- (0000000004, 0000000003),
- (0000000004, 0000000027),
- (0000000005, 0000000001),
- (0000000005, 0000000002),
- (0000000005, 0000000003),
- (0000000005, 0000000004),
- (0000000005, 0000000006),
- (0000000005, 0000000007),
- (0000000005, 0000000027),
- (0000000005, 0000000029),
- (0000000006, 0000000007),
- (0000000006, 0000000008),
- (0000000006, 0000000009),
- (0000000006, 0000000010),
- (0000000006, 0000000011),
- (0000000006, 0000000012),
- (0000000007, 0000000007),
- (0000000007, 0000000008),
- (0000000007, 0000000010),
- (0000000007, 0000000011),
- (0000000007, 0000000012),
- (0000000007, 0000000013),
- (0000000008, 0000000008),
- (0000000008, 0000000009),
- (0000000008, 0000000011),
- (0000000008, 0000000012),
- (0000000008, 0000000014),
- (0000000008, 0000000015),
- (0000000008, 0000000016),
- (0000000008, 0000000017),
- (0000000008, 0000000030),
- (0000000008, 0000000046),
- (0000000009, 0000000008),
- (0000000009, 0000000011),
- (0000000009, 0000000012),
- (0000000009, 0000000013),
- (0000000009, 0000000014),
- (0000000009, 0000000015),
- (0000000009, 0000000016),
- (0000000009, 0000000017),
- (0000000009, 0000000030),
- (0000000009, 0000000046),
- (0000000010, 0000000009),
- (0000000010, 0000000037),
- (0000000010, 0000000043),
- (0000000010, 0000000044),
- (0000000011, 0000000004),
- (0000000011, 0000000006),
- (0000000011, 0000000014),
- (0000000011, 0000000031),
- (0000000011, 0000000042),
- (0000000011, 0000000043),
- (0000000012, 0000000013),
- (0000000012, 0000000014),
- (0000000012, 0000000018),
- (0000000012, 0000000042),
- (0000000013, 0000000013),
- (0000000013, 0000000042),
- (0000000013, 0000000045),
- (0000000014, 0000000034),
- (0000000014, 0000000035),
- (0000000014, 0000000036),
- (0000000014, 0000000037),
- (0000000014, 0000000038),
- (0000000015, 0000000039),
- (0000000016, 0000000033),
- (0000000016, 0000000036),
- (0000000016, 0000000039),
- (0000000016, 0000000041),
- (0000000017, 0000000040),
- (0000000018, 0000000032),
- (0000000019, 0000000004),
- (0000000020, 0000000016),
- (0000000021, 0000000006),
- (0000000021, 0000000011),
- (0000000021, 0000000012),
- (0000000021, 0000000014),
- (0000000021, 0000000017),
- (0000000021, 0000000026),
- (0000000021, 0000000028),
- (0000000022, 0000000017),
- (0000000022, 0000000025),
- (0000000022, 0000000026),
- (0000000022, 0000000028),
- (0000000022, 0000000036),
- (0000000023, 0000000014),
- (0000000023, 0000000017),
- (0000000023, 0000000027),
- (0000000023, 0000000029),
- (0000000023, 0000000031),
- (0000000024, 0000000009),
- (0000000024, 0000000012),
- (0000000024, 0000000017),
- (0000000024, 0000000026),
- (0000000024, 0000000028),
- (0000000024, 0000000030),
- (0000000025, 0000000016),
- (0000000025, 0000000023),
- (0000000025, 0000000024),
- (0000000026, 0000000004),
- (0000000026, 0000000009),
- (0000000026, 0000000024),
- (0000000026, 0000000046),
- (0000000027, 0000000006),
- (0000000027, 0000000015),
- (0000000027, 0000000016),
- (0000000027, 0000000019),
- (0000000027, 0000000024),
- (0000000027, 0000000028),
- (0000000027, 0000000029),
- (0000000028, 0000000004),
- (0000000028, 0000000014),
- (0000000028, 0000000015),
- (0000000028, 0000000021),
- (0000000029, 0000000004),
- (0000000029, 0000000005),
- (0000000029, 0000000014),
- (0000000029, 0000000015),
- (0000000029, 0000000022),
- (0000000029, 0000000046),
- (0000000030, 0000000004),
- (0000000030, 0000000006),
- (0000000030, 0000000009),
- (0000000030, 0000000012),
- (0000000030, 0000000014),
- (0000000030, 0000000015),
- (0000000030, 0000000019),
- (0000000030, 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`,`tip_ID_tip`,`grupa_ID_grupa`,`kuhar_ID_kuhar`),
- 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`,`konobar_ID_konobar`,`gost_ID_gost`),
- 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`,`jelo_ID_jelo`,`gost_ID_gost`),
- 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(20) UNSIGNED ZEROFILL NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
- --
- -- AUTO_INCREMENT for table `jelo`
- --
- ALTER TABLE `jelo`
- MODIFY `ID_jelo` int(5) UNSIGNED ZEROFILL NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=31;
- --
- -- 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=47;
- --
- -- 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 NO ACTION ON UPDATE NO ACTION,
- ADD CONSTRAINT `fk_jelo_tip1` FOREIGN KEY (`tip_ID_tip`) REFERENCES `tip` (`ID_tip`) ON DELETE NO ACTION ON UPDATE NO ACTION,
- ADD CONSTRAINT `fk_jelo_tip_kuhinja_jelo1` FOREIGN KEY (`grupa_ID_grupa`) REFERENCES `grupa` (`ID_grupa`) ON DELETE NO ACTION ON UPDATE NO ACTION;
- --
- -- 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