API tools faq
paste
Advertisement
Guest User

Untitled

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