API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Jan 7th, 2018
390
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 26.33 KB | None | 0 0
raw download clone embed print report
  1. -- phpMyAdmin SQL Dump
  2. -- version 4.7.4
  3. -- https://www.phpmyadmin.net/
  4. --
  5. -- Host: 127.0.0.1
  6. -- Generation Time: Jan 07, 2018 at 03:09 PM
  7. -- Server version: 10.1.29-MariaDB
  8. -- PHP Version: 7.2.0
  9.  
  10. SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
  11. SET AUTOCOMMIT = 0;
  12. START TRANSACTION;
  13. SET time_zone = "+00:00";
  14.  
  15.  
  16. /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
  17. /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
  18. /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
  19. /*!40101 SET NAMES utf8mb4 */;
  20.  
  21. --
  22. -- Database: `mydb`
  23. --
  24.  
  25. -- --------------------------------------------------------
  26.  
  27. --
  28. -- Table structure for table `gost`
  29. --
  30.  
  31. CREATE TABLE `gost` (
  32. `ID_gost` bigint(20) UNSIGNED ZEROFILL NOT NULL,
  33. `ime_gost` varchar(45) DEFAULT NULL,
  34. `prezime_gost` varchar(45) DEFAULT NULL,
  35. `datum_rod_gost` date DEFAULT NULL,
  36. `adresa_gost` varchar(45) DEFAULT NULL,
  37. `grad_gost` varchar(45) DEFAULT NULL,
  38. `postanski_broj_gost` varchar(45) DEFAULT NULL,
  39. `spol_gost` varchar(45) DEFAULT NULL,
  40. `bodovi_gost` int(11) DEFAULT NULL,
  41. `mail_gost` varchar(45) DEFAULT NULL,
  42. `lozinka_gost` varchar(15) DEFAULT NULL
  43. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  44.  
  45. -- --------------------------------------------------------
  46.  
  47. --
  48. -- Table structure for table `grupa`
  49. --
  50.  
  51. CREATE TABLE `grupa` (
  52. `ID_grupa` int(10) UNSIGNED ZEROFILL NOT NULL,
  53. `naziv_grupa` varchar(45) DEFAULT NULL
  54. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  55.  
  56. --
  57. -- Dumping data for table `grupa`
  58. --
  59.  
  60. INSERT INTO `grupa` (`ID_grupa`, `naziv_grupa`) VALUES
  61. (0000000001, 'Meksička'),
  62. (0000000002, 'Salate'),
  63. (0000000003, 'Pizze'),
  64. (0000000004, 'Tjestenine'),
  65. (0000000005, 'Rižoti'),
  66. (0000000006, 'Grill'),
  67. (0000000007, 'Juhe'),
  68. (0000000008, 'Deserti');
  69.  
  70. -- --------------------------------------------------------
  71.  
  72. --
  73. -- Table structure for table `jelo`
  74. --
  75.  
  76. CREATE TABLE `jelo` (
  77. `ID_jelo` int(10) UNSIGNED ZEROFILL NOT NULL,
  78. `tip_ID_tip` int(10) UNSIGNED ZEROFILL NOT NULL,
  79. `grupa_ID_grupa` int(10) UNSIGNED ZEROFILL NOT NULL,
  80. `kuhar_ID_kuhar` bigint(20) UNSIGNED ZEROFILL NOT NULL,
  81. `ime_jelo` varchar(45) DEFAULT NULL,
  82. `cijena_jelo` int(4) UNSIGNED DEFAULT NULL,
  83. `opis` varchar(100) DEFAULT NULL,
  84. `slika_jelo` text CHARACTER SET latin2 COLLATE latin2_croatian_ci NOT NULL
  85. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  86.  
  87. --
  88. -- Dumping data for table `jelo`
  89. --
  90.  
  91. INSERT INTO `jelo` (`ID_jelo`, `tip_ID_tip`, `grupa_ID_grupa`, `kuhar_ID_kuhar`, `ime_jelo`, `cijena_jelo`, `opis`, `slika_jelo`) VALUES
  92. (0000000047, 0000000003, 0000000003, 00000000006649545644, 'Margarita', 35, NULL, 'https://i.imgur.com/RWrBdG5.jpg'),
  93. (0000000048, 0000000003, 0000000003, 00000000006649545644, 'Miješana', 40, NULL, 'https://i.imgur.com/14n5Bqw.jpg'),
  94. (0000000049, 0000000003, 0000000003, 00000000006649545644, 'Vesuvio', 40, NULL, 'https://i.imgur.com/thwYz0X.jpg'),
  95. (0000000050, 0000000003, 0000000003, 00000000006649545644, 'Pršut', 45, NULL, 'https://i.imgur.com/PYTRWVa.jpg'),
  96. (0000000051, 0000000003, 0000000003, 00000000006649545644, 'Pizzaiolo', 45, NULL, 'https://i.imgur.com/cKh6exa.jpg'),
  97. (0000000052, 0000000003, 0000000001, 00000000001319508091, 'Quesadilla s piletinom', 57, NULL, 'https://i.imgur.com/aoYpyHO.jpg'),
  98. (0000000053, 0000000003, 0000000001, 00000000001319508091, 'Quesadilla s mljevenim mesom', 57, NULL, 'https://i.imgur.com/kdyi3x2.jpg'),
  99. (0000000054, 0000000003, 0000000001, 00000000001319508091, 'Tacosi s piletinom', 61, NULL, 'https://i.imgur.com/7vBR0wS.jpg'),
  100. (0000000055, 0000000003, 0000000001, 00000000001319508091, 'Tacosi s mljevenim mesom', 61, NULL, 'https://i.imgur.com/b5HcvSr.jpg'),
  101. (0000000056, 0000000003, 0000000006, 00000000004548097233, 'Kokodakalo', 64, 'Pileća prsa punjena špinatom i bademom u mascarpone umaku', 'https://i.imgur.com/9Jw3KSw.jpg'),
  102. (0000000057, 0000000003, 0000000006, 00000000004548097233, 'Muuuu!', 115, 'Biftek na žaru s gratiniranim povrćem', 'https://i.imgur.com/sEojPI8.jpg'),
  103. (0000000058, 0000000003, 0000000006, 00000000004548097233, 'Pivkanburger', 50, 'Burger od junetine u pivskom umaku s krumpirom', 'https://i.imgur.com/DUXPMNE.jpg'),
  104. (0000000059, 0000000003, 0000000006, 00000000004548097233, 'Pliska', 60, 'Pljeskavica s kajmakom i krumpirom', 'https://i.imgur.com/zt5SiDl.jpg'),
  105. (0000000060, 0000000004, 0000000008, 00000000006649545644, 'Cheesecake', 17, NULL, 'https://i.imgur.com/3Rvmnb0.jpg'),
  106. (0000000061, 0000000004, 0000000008, 00000000006649545644, 'Sladoled vanilija', 9, NULL, 'https://i.imgur.com/4DhFVrP.jpg'),
  107. (0000000062, 0000000004, 0000000008, 00000000006649545644, 'Pačalinka', 21, 'Palačinke sa sladoledom i nutellom', 'https://i.imgur.com/fEngoPW.jpg'),
  108. (0000000063, 0000000004, 0000000008, 00000000006649545644, 'Sladoled čokolada', 9, NULL, 'https://i.imgur.com/zcrWpwN.jpg'),
  109. (0000000064, 0000000002, 0000000007, 00000000001319508091, 'Goveđa juha', 14, NULL, 'https://i.imgur.com/sEr1VOi.jpg'),
  110. (0000000065, 0000000002, 0000000007, 00000000001319508091, 'Juha od gljiva', 16, NULL, 'https://i.imgur.com/gFBQaZK.jpg'),
  111. (0000000066, 0000000002, 0000000007, 00000000001319508091, 'Juha od rajčice', 16, NULL, 'https://i.imgur.com/xQG5iRs.jpg'),
  112. (0000000067, 0000000005, 0000000002, 00000000004548097233, 'Šopska salata', 19, NULL, 'https://i.imgur.com/sMUKOWM.jpg'),
  113. (0000000068, 0000000005, 0000000002, 00000000004548097233, 'Salata s tunom', 29, NULL, 'https://i.imgur.com/jw49bCO.jpg'),
  114. (0000000069, 0000000003, 0000000002, 00000000001319508091, 'Steak salata', 56, NULL, 'https://i.imgur.com/imiOBUW.jpg'),
  115. (0000000070, 0000000003, 0000000002, 00000000006649545644, 'Salata s piletinom', 45, NULL, 'https://i.imgur.com/lRuBSRn.jpg'),
  116. (0000000071, 0000000003, 0000000005, 00000000006649545644, 'Rižoto sa škampima', 66, NULL, 'https://i.imgur.com/Q1RbmOs.jpg'),
  117. (0000000072, 0000000003, 0000000005, 00000000006649545644, 'Rižoto s piletinom i gljivama', 53, NULL, 'https://i.imgur.com/RnQjzyZ.jpg'),
  118. (0000000073, 0000000003, 0000000005, 00000000004548097233, 'Vege rižoto', 49, NULL, 'https://i.imgur.com/pgBPGdS.jpg'),
  119. (0000000074, 0000000003, 0000000004, 00000000001319508091, 'Penne sa gljivama', 51, NULL, 'https://i.imgur.com/G69r602.jpg'),
  120. (0000000075, 0000000003, 0000000004, 00000000001319508091, 'Tagliatelle sa pršutom i gljivama', 56, NULL, 'https://i.imgur.com/BZgrHCx.jpg'),
  121. (0000000076, 0000000003, 0000000004, 00000000001319508091, 'Wok špageti', 60, 'Špageti sa piletinom i povrćem pripremljeni u woku', 'https://i.imgur.com/YsW81AA.jpg');
  122.  
  123. -- --------------------------------------------------------
  124.  
  125. --
  126. -- Table structure for table `konobar`
  127. --
  128.  
  129. CREATE TABLE `konobar` (
  130. `ID_konobar` bigint(20) UNSIGNED ZEROFILL NOT NULL,
  131. `ime_konobar` varchar(45) DEFAULT NULL,
  132. `prezime_konobar` varchar(45) DEFAULT NULL,
  133. `datum_rod_konobar` date DEFAULT NULL,
  134. `adresa_konobar` varchar(45) DEFAULT NULL,
  135. `grad_konobar` varchar(45) DEFAULT NULL,
  136. `postanski_broj_konobar` varchar(45) DEFAULT NULL,
  137. `placa_konobar` float DEFAULT NULL,
  138. `tel_konobar` varchar(45) DEFAULT NULL,
  139. `mail_konobar` varchar(45) DEFAULT NULL,
  140. `lozinka_konobar` varchar(45) DEFAULT NULL,
  141. `ocjena_konobar` varchar(45) DEFAULT NULL
  142. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  143.  
  144. --
  145. -- Dumping data for table `konobar`
  146. --
  147.  
  148. 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
  149. (00000000004326988897, 'Andrej', 'Rokvić', '1990-07-11', 'Danijela Godine 4', 'Rijeka', '51000', 6000, '095 954 4488', 'rokva.and@yahoo.com', 'alfaromeo45', NULL),
  150. (00000000004831524985, 'Jakov', 'Puljić', '1979-01-26', 'Vukovarska ulica 6', 'Rijeka', '51000', 8400, '099 454 3211', 'jakov.puljic@gmail.com', 'vukovri79', NULL),
  151. (00000000006549532366, 'Andrej', 'Filipović', '1988-11-02', 'Ciottina ulica 25', 'Rijeka', '51000', 6800, '091 985 3366', 'and.filipovic@gmail.com', 'andfil25', NULL);
  152.  
  153. -- --------------------------------------------------------
  154.  
  155. --
  156. -- Table structure for table `kuhar`
  157. --
  158.  
  159. CREATE TABLE `kuhar` (
  160. `ID_kuhar` bigint(20) UNSIGNED ZEROFILL NOT NULL,
  161. `ime_kuhar` varchar(45) DEFAULT NULL,
  162. `prezime_kuhar` varchar(45) DEFAULT NULL,
  163. `datum_rod` date DEFAULT NULL,
  164. `adresa_kuhar` varchar(45) DEFAULT NULL,
  165. `grad_kuhar` varchar(45) DEFAULT NULL,
  166. `postanski_broj_kuhar` varchar(45) DEFAULT NULL,
  167. `placa_kuhar` float DEFAULT NULL,
  168. `tel_kuhar` varchar(45) DEFAULT NULL,
  169. `mail_kuhar` varchar(45) DEFAULT NULL,
  170. `lozinka_kuhar` varchar(45) DEFAULT NULL
  171. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  172.  
  173. --
  174. -- Dumping data for table `kuhar`
  175. --
  176.  
  177. 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
  178. (00000000001319508091, 'Milan', 'Marković', '1991-04-07', 'Laginjina ulica 11a', 'Rijeka', '51000', 7800, '097 451 1133', 'milan.markovi@gmail.com', 'mikimilan11'),
  179. (00000000004548097233, 'Ronald', 'Makić', '1974-12-09', 'Krimeja 6', 'Rijeka', '51000', 10000, '095 0101 990', 'ronmaki@gmail.com', 'makiori6'),
  180. (00000000006649545644, 'Adrijan', 'Torić', '1989-02-18', 'J.P. Kamova 61', 'Rijeka', '51000', 7800, '099 985 9946', 'adrijan.toric@yahoo.com', 'ciroti61');
  181.  
  182. -- --------------------------------------------------------
  183.  
  184. --
  185. -- Table structure for table `kuhar_priprema_jelo`
  186. --
  187.  
  188. CREATE TABLE `kuhar_priprema_jelo` (
  189. `kuhar_ID_kuhar` bigint(20) UNSIGNED ZEROFILL NOT NULL,
  190. `jelo_ID_jelo` int(10) UNSIGNED ZEROFILL NOT NULL
  191. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  192.  
  193. -- --------------------------------------------------------
  194.  
  195. --
  196. -- Table structure for table `narudzba`
  197. --
  198.  
  199. CREATE TABLE `narudzba` (
  200. `jelo_ID_jelo` int(10) UNSIGNED ZEROFILL NOT NULL,
  201. `racun_ID_racun` int(10) UNSIGNED ZEROFILL NOT NULL
  202. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT=' ';
  203.  
  204. -- --------------------------------------------------------
  205.  
  206. --
  207. -- Table structure for table `pica_na_racunu`
  208. --
  209.  
  210. CREATE TABLE `pica_na_racunu` (
  211. `pice_ID_pice` int(10) UNSIGNED ZEROFILL NOT NULL,
  212. `račun_ID_račun` int(10) UNSIGNED ZEROFILL NOT NULL
  213. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  214.  
  215. -- --------------------------------------------------------
  216.  
  217. --
  218. -- Table structure for table `pice`
  219. --
  220.  
  221. CREATE TABLE `pice` (
  222. `ID_pice` int(10) UNSIGNED ZEROFILL NOT NULL,
  223. `naziv_pice` varchar(45) DEFAULT NULL,
  224. `cijena_pice` int(10) UNSIGNED DEFAULT NULL,
  225. `ulazna_cijena_pice` int(5) NOT NULL,
  226. `kolicina_pice` float DEFAULT NULL,
  227. `vrsta_pica_ID_vrsta_pica` int(10) UNSIGNED ZEROFILL NOT NULL,
  228. `slika_pice` text NOT NULL
  229. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  230.  
  231. --
  232. -- Dumping data for table `pice`
  233. --
  234.  
  235. INSERT INTO `pice` (`ID_pice`, `naziv_pice`, `cijena_pice`, `ulazna_cijena_pice`, `kolicina_pice`, `vrsta_pica_ID_vrsta_pica`, `slika_pice`) VALUES
  236. (0000000001, 'Voda 0.5 L', 10, 4, 0.5, 0000000002, 'https://i.imgur.com/815Fc1q.jpg'),
  237. (0000000002, 'Voda 1L', 15, 6, 1, 0000000002, 'https://i.imgur.com/815Fc1q.jpg'),
  238. (0000000003, 'Coca Cola', 15, 5, 0.25, 0000000002, 'https://i.imgur.com/zUhrnYM.jpg'),
  239. (0000000004, 'Fanta', 15, 5, 0.25, 0000000002, 'https://i.imgur.com/qgZxrh6.png'),
  240. (0000000005, 'Sprite', 15, 5, 0.25, 0000000002, 'https://i.imgur.com/RTD0Rxk.jpg'),
  241. (0000000006, 'Mineralna voda 0.25', 12, 4, 0.25, 0000000002, 'https://i.imgur.com/eTsnJjK.jpg'),
  242. (0000000007, 'Schweppes Tangerine', 15, 5, 0.25, 0000000002, 'https://i.imgur.com/vBqYjOF.jpg'),
  243. (0000000008, 'Schweppes Bitter Lemon', 15, 5, 0.25, 0000000002, 'https://i.imgur.com/lgGCg73.jpg'),
  244. (0000000009, 'Mineralna voda 0.5L', 15, 5, 0.5, 0000000002, 'https://i.imgur.com/eTsnJjK.jpg'),
  245. (0000000010, 'Mineralna voda 1L', 20, 7, 1, 0000000002, 'https://i.imgur.com/eTsnJjK.jpg'),
  246. (0000000011, 'Ledeni čaj', 15, 5, 0.25, 0000000002, 'https://i.imgur.com/PeySGSC.png'),
  247. (0000000012, 'Voćni sok jabuka', 14, 5, 0.2, 0000000002, 'https://i.imgur.com/MNCVliG.jpg'),
  248. (0000000013, 'Voćni sok jagoda', 15, 5, 0.2, 0000000002, 'https://i.imgur.com/hGzUUam.jpg'),
  249. (0000000014, 'Voćni sok naranča', 15, 5, 0.2, 0000000002, 'https://i.imgur.com/xebdXjb.jpg'),
  250. (0000000015, 'Voćni sok banana', 15, 5, 0.2, 0000000002, 'https://i.imgur.com/sY5GIvV.jpg'),
  251. (0000000016, 'Tuborg 0.33L', 18, 6, 0.33, 0000000003, 'https://i.imgur.com/DXHnNTK.jpg'),
  252. (0000000017, 'Heineken', 18, 6, 0.33, 0000000003, 'https://i.imgur.com/owkrm3r.jpg'),
  253. (0000000018, 'Velebitsko kasačko', 22, 8, 0.33, 0000000003, 'https://i.imgur.com/7DUUfvQ.jpg'),
  254. (0000000019, 'Zmajsko Pale Ale', 23, 11, 0.5, 0000000003, 'https://i.imgur.com/F76wyRi.jpg'),
  255. (0000000020, 'Carlsberg 0.33L', 20, 7, 0.33, 0000000003, 'https://i.imgur.com/zj1sES6.png'),
  256. (0000000021, 'Budweiser 0.33L', 20, 7, 0.33, 0000000003, 'https://i.imgur.com/62b3fS1.png'),
  257. (0000000022, 'Jack Daniels', 20, 5, 0.03, 0000000005, 'https://i.imgur.com/eonwb5b.jpg'),
  258. (0000000023, 'Pelinkovac', 10, 3, 0.03, 0000000005, 'https://i.imgur.com/dCaM9dm.jpg'),
  259. (0000000024, 'Ballantines', 17, 4, 0.03, 0000000005, 'https://i.imgur.com/WKf5bHJ.jpg'),
  260. (0000000025, 'Vodka', 12, 4, 0.03, 0000000005, 'https://i.imgur.com/O316NI2.jpg'),
  261. (0000000026, 'Travarica', 11, 3, 0.03, 0000000005, 'https://i.imgur.com/M7l3ech.jpg'),
  262. (0000000027, 'Loza', 11, 3, 0.03, 0000000005, 'https://i.imgur.com/H2PJtP3.jpg'),
  263. (0000000028, 'Šljiva', 11, 3, 0.03, 0000000005, 'https://i.imgur.com/LyMiA5z.jpg'),
  264. (0000000029, 'Orahovica', 11, 3, 0.03, 0000000005, 'https://i.imgur.com/DGmUh8Z.jpg'),
  265. (0000000030, 'Žlahtina 0.75L', 100, 29, 0.75, 0000000004, 'https://i.imgur.com/KcdZQB8.jpg'),
  266. (0000000031, 'Zlatna žlahtina 0.75L', 180, 45, 0.75, 0000000004, 'https://i.imgur.com/h8t3I0V.png'),
  267. (0000000032, 'Cabernet Sauvignon 0.75L', 110, 33, 0.75, 0000000004, 'https://i.imgur.com/5R3a71Z.jpg'),
  268. (0000000033, 'Zlatni Plavac 0.75L', 190, 53, 0.75, 0000000004, 'https://i.imgur.com/o9lCSbM.jpg'),
  269. (0000000034, 'Kava', 8, 3, 0.1, 0000000001, 'https://i.imgur.com/bAgwtbo.png'),
  270. (0000000035, 'Cappuccino', 10, 3, 0.15, 0000000001, 'https://i.imgur.com/N3qUwsX.png'),
  271. (0000000036, 'Čaj', 10, 3, 0.2, 0000000001, 'https://i.imgur.com/OLRTb9M.jpg'),
  272. (0000000037, 'Nescafe', 12, 5, 0.2, 0000000001, 'https://i.imgur.com/5empHPa.jpg');
  273.  
  274. -- --------------------------------------------------------
  275.  
  276. --
  277. -- Table structure for table `racun`
  278. --
  279.  
  280. CREATE TABLE `racun` (
  281. `ID_racun` int(10) UNSIGNED ZEROFILL NOT NULL,
  282. `konobar_ID_konobar` bigint(20) UNSIGNED ZEROFILL NOT NULL,
  283. `gost_ID_gost` bigint(20) UNSIGNED ZEROFILL NOT NULL,
  284. `datum` date DEFAULT NULL,
  285. `iznos_racun` double DEFAULT NULL,
  286. `broj_stola` int(11) DEFAULT NULL
  287. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  288.  
  289. -- --------------------------------------------------------
  290.  
  291. --
  292. -- Table structure for table `recenzija`
  293. --
  294.  
  295. CREATE TABLE `recenzija` (
  296. `ID_preporuka` int(11) NOT NULL,
  297. `jelo_ID_jelo` int(100) UNSIGNED ZEROFILL NOT NULL,
  298. `gost_ID_gost` bigint(20) UNSIGNED ZEROFILL NOT NULL,
  299. `komentar` varchar(100) DEFAULT NULL,
  300. `ocjena` int(11) DEFAULT NULL
  301. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  302.  
  303. -- --------------------------------------------------------
  304.  
  305. --
  306. -- Table structure for table `sastojak`
  307. --
  308.  
  309. CREATE TABLE `sastojak` (
  310. `ID_sastojak` int(10) UNSIGNED ZEROFILL NOT NULL,
  311. `naziv_sastojak` varchar(45) DEFAULT NULL,
  312. `kolicina_sastojak` float DEFAULT NULL,
  313. `cijena_sastojak` float DEFAULT NULL,
  314. `kalorije_sastojak` int(11) DEFAULT NULL
  315. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  316.  
  317. --
  318. -- Dumping data for table `sastojak`
  319. --
  320.  
  321. INSERT INTO `sastojak` (`ID_sastojak`, `naziv_sastojak`, `kolicina_sastojak`, `cijena_sastojak`, `kalorije_sastojak`) VALUES
  322. (0000000001, 'Sir za pizzu', 1000, 65, 280),
  323. (0000000002, 'Šunka za pizzu', 1000, 21, 275),
  324. (0000000003, 'Pelati', 1000, 17, 22),
  325. (0000000004, 'Šampinjoni', 1000, 32, 26),
  326. (0000000005, 'Pršut dalmatinski', 1000, 129, 268),
  327. (0000000006, 'Paprika MIX', 1000, 18, 39),
  328. (0000000007, 'Kiselo vrhnje', 1000, 20, 192),
  329. (0000000008, 'Tortilja pšenična', 10, 25, 232),
  330. (0000000009, 'Pileća prsa', 1000, 43, 239),
  331. (0000000010, 'Gauda sir', 1000, 64, 356),
  332. (0000000011, 'Grah crveni', 1000, 19, 110),
  333. (0000000012, 'Kukuruz konzerva', 1000, 17, 115),
  334. (0000000013, 'Mljeveno meso', 1000, 43, 240),
  335. (0000000014, 'Crveni luk ', 1000, 7, 39),
  336. (0000000015, 'Češnjak', 1000, 40, 148),
  337. (0000000016, 'Pasirana rajčica', 1000, 14, 37),
  338. (0000000017, 'Zelena salata', 1000, 9, 14),
  339. (0000000018, 'Med', 1000, 70, 304),
  340. (0000000019, 'Mrkva', 1000, 9, 41),
  341. (0000000020, 'Pašta špageti', 1000, 15, 154),
  342. (0000000021, 'Pašta penne', 1000, 15, 118),
  343. (0000000022, 'Pašta tagliatele', 1000, 26, 288),
  344. (0000000023, 'Škampi', 1000, 80, 118),
  345. (0000000024, 'Riža', 1000, 17, 130),
  346. (0000000025, 'Tuna u konzervi', 1000, 140, 204),
  347. (0000000026, 'Feta sir', 1000, 80, 263),
  348. (0000000027, 'Cherry rajčica', 1000, 54, 28),
  349. (0000000028, 'Rajčica', 1000, 21, 19),
  350. (0000000029, 'Crne masline', 1000, 35, 115),
  351. (0000000030, 'Kupus svježi', 1000, 18, 24),
  352. (0000000031, 'Biftek', 1000, 180, 137),
  353. (0000000032, 'Goveđi temeljac', 1000, 112, 575),
  354. (0000000033, 'Brašno', 1000, 4, 364),
  355. (0000000034, 'PB keksi', 1000, 20, 434),
  356. (0000000035, 'Bijeli šećer', 1000, 6, 384),
  357. (0000000036, 'Jaja', 100, 200, 155),
  358. (0000000037, 'Svježi sir', 1000, 30, 98),
  359. (0000000038, 'Maslac', 1000, 80, 716),
  360. (0000000039, 'Sladoled vanilija', 1000, 10, 150),
  361. (0000000040, 'Sladoled čokolada', 1000, 13, 153),
  362. (0000000041, 'Nutella', 1000, 56, 534),
  363. (0000000042, 'Krumpir', 1000, 4, 76),
  364. (0000000043, 'Špinat', 1000, 19, 24),
  365. (0000000044, 'Bademi', 1000, 90, 574),
  366. (0000000045, 'Kajmak', 1000, 70, 481);
  367.  
  368. -- --------------------------------------------------------
  369.  
  370. --
  371. -- Table structure for table `sastojci_jela`
  372. --
  373.  
  374. CREATE TABLE `sastojci_jela` (
  375. `jelo_ID_jelo` int(10) UNSIGNED ZEROFILL NOT NULL,
  376. `sastojak_ID_sastojak` int(10) UNSIGNED ZEROFILL NOT NULL
  377. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  378.  
  379. -- --------------------------------------------------------
  380.  
  381. --
  382. -- Table structure for table `tip`
  383. --
  384.  
  385. CREATE TABLE `tip` (
  386. `ID_tip` int(10) UNSIGNED ZEROFILL NOT NULL,
  387. `naziv_tip` varchar(45) DEFAULT NULL
  388. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  389.  
  390. --
  391. -- Dumping data for table `tip`
  392. --
  393.  
  394. INSERT INTO `tip` (`ID_tip`, `naziv_tip`) VALUES
  395. (0000000001, 'Hladno predjelo'),
  396. (0000000002, 'Toplo predjelo'),
  397. (0000000003, 'Glavno jelo'),
  398. (0000000004, 'Desert'),
  399. (0000000005, 'Salate');
  400.  
  401. -- --------------------------------------------------------
  402.  
  403. --
  404. -- Table structure for table `vrsta_pica`
  405. --
  406.  
  407. CREATE TABLE `vrsta_pica` (
  408. `ID_vrsta_pica` int(10) UNSIGNED ZEROFILL NOT NULL,
  409. `vrsta_pica` varchar(45) NOT NULL
  410. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  411.  
  412. --
  413. -- Dumping data for table `vrsta_pica`
  414. --
  415.  
  416. INSERT INTO `vrsta_pica` (`ID_vrsta_pica`, `vrsta_pica`) VALUES
  417. (0000000002, 'Bezalkoholna pića'),
  418. (0000000003, 'Piva'),
  419. (0000000001, 'Topli napitci'),
  420. (0000000004, 'Vina'),
  421. (0000000005, 'Žestoka pića');
  422.  
  423. --
  424. -- Indexes for dumped tables
  425. --
  426.  
  427. --
  428. -- Indexes for table `gost`
  429. --
  430. ALTER TABLE `gost`
  431. ADD PRIMARY KEY (`ID_gost`);
  432.  
  433. --
  434. -- Indexes for table `grupa`
  435. --
  436. ALTER TABLE `grupa`
  437. ADD PRIMARY KEY (`ID_grupa`),
  438. ADD UNIQUE KEY `idtip_kuhinja_jelo_UNIQUE` (`ID_grupa`);
  439.  
  440. --
  441. -- Indexes for table `jelo`
  442. --
  443. ALTER TABLE `jelo`
  444. ADD PRIMARY KEY (`ID_jelo`),
  445. ADD UNIQUE KEY `idjelo_UNIQUE` (`ID_jelo`),
  446. ADD KEY `fk_jelo_tip_kuhinja_jelo1_idx` (`grupa_ID_grupa`),
  447. ADD KEY `fk_jelo_tip1_idx` (`tip_ID_tip`),
  448. ADD KEY `fk_jelo_kuhar1_idx` (`kuhar_ID_kuhar`);
  449.  
  450. --
  451. -- Indexes for table `konobar`
  452. --
  453. ALTER TABLE `konobar`
  454. ADD PRIMARY KEY (`ID_konobar`);
  455.  
  456. --
  457. -- Indexes for table `kuhar`
  458. --
  459. ALTER TABLE `kuhar`
  460. ADD PRIMARY KEY (`ID_kuhar`),
  461. ADD UNIQUE KEY `id_kuhar_UNIQUE` (`ID_kuhar`);
  462.  
  463. --
  464. -- Indexes for table `kuhar_priprema_jelo`
  465. --
  466. ALTER TABLE `kuhar_priprema_jelo`
  467. ADD PRIMARY KEY (`kuhar_ID_kuhar`,`jelo_ID_jelo`),
  468. ADD KEY `fk_kuhar_has_jelo_jelo1_idx` (`jelo_ID_jelo`),
  469. ADD KEY `fk_kuhar_has_jelo_kuhar1_idx` (`kuhar_ID_kuhar`);
  470.  
  471. --
  472. -- Indexes for table `narudzba`
  473. --
  474. ALTER TABLE `narudzba`
  475. ADD PRIMARY KEY (`jelo_ID_jelo`,`racun_ID_racun`),
  476. ADD KEY `fk_jelo_has_račun_račun1_idx` (`racun_ID_racun`),
  477. ADD KEY `fk_jelo_has_račun_jelo1_idx` (`jelo_ID_jelo`);
  478.  
  479. --
  480. -- Indexes for table `pica_na_racunu`
  481. --
  482. ALTER TABLE `pica_na_racunu`
  483. ADD PRIMARY KEY (`pice_ID_pice`,`račun_ID_račun`),
  484. ADD KEY `fk_pice_has_račun_račun1_idx` (`račun_ID_račun`),
  485. ADD KEY `fk_pice_has_račun_pice1_idx` (`pice_ID_pice`);
  486.  
  487. --
  488. -- Indexes for table `pice`
  489. --
  490. ALTER TABLE `pice`
  491. ADD PRIMARY KEY (`ID_pice`),
  492. ADD KEY `fk_pice_vrsta_pica1_idx` (`vrsta_pica_ID_vrsta_pica`);
  493.  
  494. --
  495. -- Indexes for table `racun`
  496. --
  497. ALTER TABLE `racun`
  498. ADD PRIMARY KEY (`ID_racun`),
  499. ADD KEY `fk_račun_konobar1_idx` (`konobar_ID_konobar`),
  500. ADD KEY `fk_račun_gost1_idx` (`gost_ID_gost`);
  501.  
  502. --
  503. -- Indexes for table `recenzija`
  504. --
  505. ALTER TABLE `recenzija`
  506. ADD PRIMARY KEY (`ID_preporuka`),
  507. ADD KEY `fk_preporuka_jelo1_idx` (`jelo_ID_jelo`),
  508. ADD KEY `fk_preporuka_gost1_idx` (`gost_ID_gost`);
  509.  
  510. --
  511. -- Indexes for table `sastojak`
  512. --
  513. ALTER TABLE `sastojak`
  514. ADD PRIMARY KEY (`ID_sastojak`),
  515. ADD UNIQUE KEY `id_sastojci_UNIQUE` (`ID_sastojak`);
  516.  
  517. --
  518. -- Indexes for table `sastojci_jela`
  519. --
  520. ALTER TABLE `sastojci_jela`
  521. ADD PRIMARY KEY (`jelo_ID_jelo`,`sastojak_ID_sastojak`),
  522. ADD KEY `fk_jelo_has_sastojak_sastojak1_idx` (`sastojak_ID_sastojak`),
  523. ADD KEY `fk_jelo_has_sastojak_jelo_idx` (`jelo_ID_jelo`);
  524.  
  525. --
  526. -- Indexes for table `tip`
  527. --
  528. ALTER TABLE `tip`
  529. ADD PRIMARY KEY (`ID_tip`),
  530. ADD UNIQUE KEY `id_tip_UNIQUE` (`ID_tip`);
  531.  
  532. --
  533. -- Indexes for table `vrsta_pica`
  534. --
  535. ALTER TABLE `vrsta_pica`
  536. ADD PRIMARY KEY (`ID_vrsta_pica`),
  537. ADD UNIQUE KEY `ID_vrsta_pica_UNIQUE` (`ID_vrsta_pica`),
  538. ADD UNIQUE KEY `vrsta_pica_UNIQUE` (`vrsta_pica`);
  539.  
  540. --
  541. -- AUTO_INCREMENT for dumped tables
  542. --
  543.  
  544. --
  545. -- AUTO_INCREMENT for table `gost`
  546. --
  547. ALTER TABLE `gost`
  548. MODIFY `ID_gost` bigint(20) UNSIGNED ZEROFILL NOT NULL AUTO_INCREMENT;
  549.  
  550. --
  551. -- AUTO_INCREMENT for table `jelo`
  552. --
  553. ALTER TABLE `jelo`
  554. MODIFY `ID_jelo` int(10) UNSIGNED ZEROFILL NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=77;
  555.  
  556. --
  557. -- AUTO_INCREMENT for table `konobar`
  558. --
  559. ALTER TABLE `konobar`
  560. MODIFY `ID_konobar` bigint(20) UNSIGNED ZEROFILL NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2147483647;
  561.  
  562. --
  563. -- AUTO_INCREMENT for table `kuhar`
  564. --
  565. ALTER TABLE `kuhar`
  566. MODIFY `ID_kuhar` bigint(20) UNSIGNED ZEROFILL NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2147483647;
  567.  
  568. --
  569. -- AUTO_INCREMENT for table `pice`
  570. --
  571. ALTER TABLE `pice`
  572. MODIFY `ID_pice` int(10) UNSIGNED ZEROFILL NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=38;
  573.  
  574. --
  575. -- AUTO_INCREMENT for table `racun`
  576. --
  577. ALTER TABLE `racun`
  578. MODIFY `ID_racun` int(10) UNSIGNED ZEROFILL NOT NULL AUTO_INCREMENT;
  579.  
  580. --
  581. -- AUTO_INCREMENT for table `recenzija`
  582. --
  583. ALTER TABLE `recenzija`
  584. MODIFY `ID_preporuka` int(11) NOT NULL AUTO_INCREMENT;
  585.  
  586. --
  587. -- AUTO_INCREMENT for table `sastojak`
  588. --
  589. ALTER TABLE `sastojak`
  590. MODIFY `ID_sastojak` int(10) UNSIGNED ZEROFILL NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=46;
  591.  
  592. --
  593. -- AUTO_INCREMENT for table `tip`
  594. --
  595. ALTER TABLE `tip`
  596. MODIFY `ID_tip` int(10) UNSIGNED ZEROFILL NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
  597.  
  598. --
  599. -- AUTO_INCREMENT for table `vrsta_pica`
  600. --
  601. ALTER TABLE `vrsta_pica`
  602. MODIFY `ID_vrsta_pica` int(10) UNSIGNED ZEROFILL NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
  603.  
  604. --
  605. -- Constraints for dumped tables
  606. --
  607.  
  608. --
  609. -- Constraints for table `jelo`
  610. --
  611. ALTER TABLE `jelo`
  612. ADD CONSTRAINT `fk_jelo_kuhar1` FOREIGN KEY (`kuhar_ID_kuhar`) REFERENCES `kuhar` (`ID_kuhar`) ON DELETE CASCADE,
  613. ADD CONSTRAINT `fk_jelo_tip1` FOREIGN KEY (`tip_ID_tip`) REFERENCES `tip` (`ID_tip`) ON DELETE CASCADE,
  614. ADD CONSTRAINT `fk_jelo_tip_kuhinja_jelo1` FOREIGN KEY (`grupa_ID_grupa`) REFERENCES `grupa` (`ID_grupa`) ON DELETE CASCADE;
  615.  
  616. --
  617. -- Constraints for table `kuhar_priprema_jelo`
  618. --
  619. ALTER TABLE `kuhar_priprema_jelo`
  620. ADD CONSTRAINT `fk_kuhar_has_jelo_jelo1` FOREIGN KEY (`jelo_ID_jelo`) REFERENCES `jelo` (`ID_jelo`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  621. ADD CONSTRAINT `fk_kuhar_has_jelo_kuhar1` FOREIGN KEY (`kuhar_ID_kuhar`) REFERENCES `kuhar` (`ID_kuhar`) ON DELETE NO ACTION ON UPDATE NO ACTION;
  622.  
  623. --
  624. -- Constraints for table `narudzba`
  625. --
  626. ALTER TABLE `narudzba`
  627. 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,
  628. 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;
  629.  
  630. --
  631. -- Constraints for table `pica_na_racunu`
  632. --
  633. ALTER TABLE `pica_na_racunu`
  634. 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,
  635. 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;
  636.  
  637. --
  638. -- Constraints for table `pice`
  639. --
  640. ALTER TABLE `pice`
  641. 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;
  642.  
  643. --
  644. -- Constraints for table `racun`
  645. --
  646. ALTER TABLE `racun`
  647. ADD CONSTRAINT `fk_račun_gost1` FOREIGN KEY (`gost_ID_gost`) REFERENCES `gost` (`ID_gost`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  648. ADD CONSTRAINT `fk_račun_konobar1` FOREIGN KEY (`konobar_ID_konobar`) REFERENCES `konobar` (`ID_konobar`) ON DELETE NO ACTION ON UPDATE NO ACTION;
  649.  
  650. --
  651. -- Constraints for table `recenzija`
  652. --
  653. ALTER TABLE `recenzija`
  654. ADD CONSTRAINT `fk_preporuka_gost1` FOREIGN KEY (`gost_ID_gost`) REFERENCES `gost` (`ID_gost`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  655. ADD CONSTRAINT `fk_preporuka_jelo1` FOREIGN KEY (`jelo_ID_jelo`) REFERENCES `jelo` (`ID_jelo`) ON DELETE NO ACTION ON UPDATE NO ACTION;
  656.  
  657. --
  658. -- Constraints for table `sastojci_jela`
  659. --
  660. ALTER TABLE `sastojci_jela`
  661. ADD CONSTRAINT `fk_jelo_has_sastojak_jelo` FOREIGN KEY (`jelo_ID_jelo`) REFERENCES `jelo` (`ID_jelo`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  662. ADD CONSTRAINT `fk_jelo_has_sastojak_sastojak1` FOREIGN KEY (`sastojak_ID_sastojak`) REFERENCES `sastojak` (`ID_sastojak`) ON DELETE NO ACTION ON UPDATE NO ACTION;
  663. COMMIT;
  664.  
  665. /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
  666. /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
  667. /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!