API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Sep 28th, 2016
93
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 28.55 KB | None | 0 0
raw download clone embed print report
  1. -- phpMyAdmin SQL Dump
  2. -- version 4.1.14
  3. -- http://www.phpmyadmin.net
  4. --
  5. -- Host: 127.0.0.1
  6. -- Generation Time: Sep 28, 2016 at 09:49 PM
  7. -- Server version: 5.6.17
  8. -- PHP Version: 5.5.12
  9.  
  10. SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
  11. SET time_zone = "+00:00";
  12.  
  13.  
  14. /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
  15. /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
  16. /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
  17. /*!40101 SET NAMES utf8 */;
  18.  
  19. --
  20. -- Database: `prehrana`
  21. --
  22.  
  23. -- --------------------------------------------------------
  24.  
  25. --
  26. -- Table structure for table `akcija`
  27. --
  28.  
  29. CREATE TABLE IF NOT EXISTS `akcija` (
  30. `id` int(11) NOT NULL AUTO_INCREMENT,
  31. `kupon` text COLLATE utf8_slovenian_ci,
  32. `procent` double DEFAULT '-1',
  33. `cena` double DEFAULT '-1',
  34. `fk_lokal_id` bigint(20) NOT NULL,
  35. `aktivno` tinyint(1) NOT NULL DEFAULT '1',
  36. `spletno` tinyint(1) NOT NULL DEFAULT '0',
  37. `datum_vnosa` datetime NOT NULL,
  38. `naziv` text COLLATE utf8_slovenian_ci NOT NULL,
  39. PRIMARY KEY (`id`),
  40. KEY `fk_lokal_id` (`fk_lokal_id`)
  41. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_slovenian_ci AUTO_INCREMENT=3 ;
  42.  
  43. --
  44. -- Dumping data for table `akcija`
  45. --
  46.  
  47. INSERT INTO `akcija` (`id`, `kupon`, `procent`, `cena`, `fk_lokal_id`, `aktivno`, `spletno`, `datum_vnosa`, `naziv`) VALUES
  48. (1, '', 12, -1, 21061265696, 1, 1, '2016-09-26 17:55:00', '123'),
  49. (2, 'qwe', -1, 24, 21061265696, 0, 0, '2016-09-26 17:56:00', 'cena');
  50.  
  51. -- --------------------------------------------------------
  52.  
  53. --
  54. -- Table structure for table `feedback`
  55. --
  56.  
  57. CREATE TABLE IF NOT EXISTS `feedback` (
  58. `id` int(11) NOT NULL AUTO_INCREMENT,
  59. `text` text CHARACTER SET latin1 NOT NULL,
  60. `fk_uporabnik_id` bigint(20) DEFAULT NULL,
  61. `fk_lokal_id` bigint(20) DEFAULT NULL,
  62. `datum` datetime NOT NULL,
  63. PRIMARY KEY (`id`),
  64. KEY `fk_uporabnik_id` (`fk_uporabnik_id`),
  65. KEY `fk_lokal_id` (`fk_lokal_id`)
  66. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_slovenian_ci AUTO_INCREMENT=26 ;
  67.  
  68. --
  69. -- Dumping data for table `feedback`
  70. --
  71.  
  72. INSERT INTO `feedback` (`id`, `text`, `fk_uporabnik_id`, `fk_lokal_id`, `datum`) VALUES
  73. (1, 'ertert', NULL, NULL, '2016-09-20 16:32:00'),
  74. (2, 'ertert', NULL, NULL, '2016-09-20 16:32:00'),
  75. (3, 'ertert', NULL, NULL, '2016-09-20 16:32:00'),
  76. (4, 'ertert', NULL, NULL, '2016-09-20 16:32:00'),
  77. (5, 'ertert', NULL, NULL, '2016-09-20 16:32:00'),
  78. (6, 'ertert', NULL, NULL, '2016-09-20 16:32:00'),
  79. (7, 'ertert', NULL, NULL, '2016-09-20 16:32:00'),
  80. (8, 'ertert', NULL, NULL, '2016-09-20 16:32:00'),
  81. (9, 'ertert', NULL, NULL, '2016-09-20 16:32:00'),
  82. (10, 'ertert', NULL, NULL, '2016-09-20 16:32:00'),
  83. (11, 'ertert', NULL, NULL, '2016-09-20 16:32:00'),
  84. (12, 'ertert', NULL, NULL, '2016-09-20 16:32:00'),
  85. (13, 'zrtzr', NULL, 82386710868, '2016-09-20 16:33:00'),
  86. (14, 'werwer', 86891762479, NULL, '2016-09-20 16:34:00'),
  87. (15, 'rtzertz', 86891762479, NULL, '2016-09-20 16:37:00'),
  88. (16, 'rtzertz', 86891762479, NULL, '2016-09-20 16:37:00'),
  89. (17, 'rtzertz', 86891762479, NULL, '2016-09-20 16:37:00'),
  90. (18, 'rtzertz', 86891762479, NULL, '2016-09-20 16:37:00'),
  91. (19, 'rtuzrtz', 86891762479, NULL, '2016-09-20 16:38:00'),
  92. (20, '78', NULL, 82386710868, '2016-09-20 17:14:00'),
  93. (21, 'iopsdjt', 86891762479, NULL, '2016-09-20 23:58:00'),
  94. (22, '123', 86891762479, NULL, '2016-09-23 15:28:00'),
  95. (23, '123', 86891762479, NULL, '2016-09-23 23:21:00'),
  96. (24, '99o', 86891762479, NULL, '2016-09-24 08:48:00'),
  97. (25, 'erwr', NULL, 21061265696, '2016-09-26 12:54:00');
  98.  
  99. -- --------------------------------------------------------
  100.  
  101. --
  102. -- Table structure for table `jedilnik`
  103. --
  104.  
  105. CREATE TABLE IF NOT EXISTS `jedilnik` (
  106. `id` bigint(20) NOT NULL,
  107. `fk_lokal_id` bigint(20) NOT NULL,
  108. `memo` varchar(64) COLLATE utf8_slovenian_ci NOT NULL,
  109. `datum_vnosa` datetime NOT NULL,
  110. `active` tinyint(1) NOT NULL DEFAULT '0',
  111. `tip` tinyint(1) NOT NULL DEFAULT '0',
  112. PRIMARY KEY (`id`),
  113. KEY `fk_lokal_id` (`fk_lokal_id`)
  114. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_slovenian_ci;
  115.  
  116. --
  117. -- Dumping data for table `jedilnik`
  118. --
  119.  
  120. INSERT INTO `jedilnik` (`id`, `fk_lokal_id`, `memo`, `datum_vnosa`, `active`, `tip`) VALUES
  121. (123123, 82386710868, 'def', '2016-09-23 14:09:00', 1, 0),
  122. (60602130512, 35358669632, 'Privzeto', '2016-09-24 09:52:00', 0, 0),
  123. (89380512299, 21061265696, 'Privzeto', '2016-09-23 14:09:00', 1, 0);
  124.  
  125. -- --------------------------------------------------------
  126.  
  127. --
  128. -- Table structure for table `jedilnik_meni`
  129. --
  130.  
  131. CREATE TABLE IF NOT EXISTS `jedilnik_meni` (
  132. `id` int(11) NOT NULL AUTO_INCREMENT,
  133. `naziv` varchar(64) COLLATE utf8_slovenian_ci DEFAULT NULL,
  134. `fk_jedilnik_id` bigint(20) NOT NULL,
  135. `fk_jedilnik_tip` int(11) DEFAULT NULL,
  136. `jedilnik` mediumtext COLLATE utf8_slovenian_ci NOT NULL,
  137. `cena` double DEFAULT '-1',
  138. `bon` tinyint(1) NOT NULL DEFAULT '0',
  139. PRIMARY KEY (`id`),
  140. KEY `fk_meni_id` (`fk_jedilnik_id`),
  141. KEY `fk_jedilnik_tip` (`fk_jedilnik_tip`),
  142. KEY `fk_meni_id_2` (`fk_jedilnik_id`),
  143. KEY `fk_jedilnik_tip_2` (`fk_jedilnik_tip`),
  144. KEY `fk_jedilnik_id` (`fk_jedilnik_id`)
  145. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_slovenian_ci AUTO_INCREMENT=193 ;
  146.  
  147. --
  148. -- Dumping data for table `jedilnik_meni`
  149. --
  150.  
  151. INSERT INTO `jedilnik_meni` (`id`, `naziv`, `fk_jedilnik_id`, `fk_jedilnik_tip`, `jedilnik`, `cena`, `bon`) VALUES
  152. (174, 'Kosilo 11', 89380512299, 2, 'OCVRTI MEDALJONI,NJOKI S PARMEZANOMm', 3.66, 1),
  153. (175, 'Kosilo 2', 89380512299, 2, 'KORENČKOVA JUHA::SOLATNI KROŽNIK S POPEČENO ZELENJAVO,HLEBČEK IZ KRUŠNE PEČI::ZELENA,PAPRADIŽNIK,KORUZA,FIŽOL::JABOLKO', 3.6, 0),
  154. (176, 'Kosilo 3', 89380512299, 2, 'KORENČKOVA JUHA::LOSOS NA ŽARU,BLITVA S KROMPIRJEM::SEZONSKA SOLATA::JABOLKO', 3.6, 0),
  155. (177, 'Kosilo 1', 60602130512, 1, 'POHORSKI LONEC, ČOKOLADICA::SESTAVLJENA SOLATA::SADJE', 2, 0),
  156. (178, 'Kosilo 2', 60602130512, 1, 'GOVEJI ZREZEK V LOVSKI OMAKI, TESTENINE::SESTAVLJENA SOLATA::SADJE', 2, 0),
  157. (179, 'Kosilo 23', 60602130512, 1, 'MESNI SIR NA ŽARU, RIŽ S KORENČKOM::SESTAVLJENA SOLATA::SADJE', 2, 0),
  158. (180, 'Kosilo bon', 60602130512, 3, '123', 12, 1),
  159. (181, 'Kosilo 4', 89380512299, 1, '123', 34, 1),
  160. (182, 'qwe', 60602130512, 3, '23', 12, 1),
  161. (183, '123', 89380512299, 3, '23', 12, 1),
  162. (184, '12333', 89380512299, 3, '123', 12, 1),
  163. (185, '123', 89380512299, 3, '23', 123, 1),
  164. (186, '123', 89380512299, 3, '23', 123, 1),
  165. (187, '123', 89380512299, 3, '23', 123, 1),
  166. (188, '123', 89380512299, 3, '23', 123, 1),
  167. (189, '123', 89380512299, 4, '123', 213, 1),
  168. (190, '33', 89380512299, 4, '3', 3, 1),
  169. (191, '123', 89380512299, 4, '23', 213, 1),
  170. (192, 'wqe', 89380512299, 3, '123', 123, 1);
  171.  
  172. -- --------------------------------------------------------
  173.  
  174. --
  175. -- Table structure for table `jedilnik_tip`
  176. --
  177.  
  178. CREATE TABLE IF NOT EXISTS `jedilnik_tip` (
  179. `id` int(11) NOT NULL,
  180. `naziv` varchar(32) NOT NULL,
  181. PRIMARY KEY (`id`)
  182. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  183.  
  184. --
  185. -- Dumping data for table `jedilnik_tip`
  186. --
  187.  
  188. INSERT INTO `jedilnik_tip` (`id`, `naziv`) VALUES
  189. (1, 'Mesni'),
  190. (2, 'Vege'),
  191. (3, 'Ribe'),
  192. (4, 'Hitra hrana'),
  193. (5, 'Pizza'),
  194. (6, 'Testenine');
  195.  
  196. -- --------------------------------------------------------
  197.  
  198. --
  199. -- Table structure for table `lokal`
  200. --
  201.  
  202. CREATE TABLE IF NOT EXISTS `lokal` (
  203. `id` bigint(11) NOT NULL,
  204. `active` tinyint(1) NOT NULL DEFAULT '1',
  205. `naziv` varchar(32) COLLATE utf16_slovenian_ci NOT NULL,
  206. `lastnik` varchar(32) COLLATE utf16_slovenian_ci NOT NULL,
  207. `naslov` varchar(48) COLLATE utf16_slovenian_ci NOT NULL,
  208. `kraj` varchar(20) COLLATE utf16_slovenian_ci NOT NULL,
  209. `telefon` varchar(14) CHARACTER SET latin1 NOT NULL,
  210. `email` varchar(32) CHARACTER SET latin1 DEFAULT NULL,
  211. `geslo` text CHARACTER SET utf32 COLLATE utf32_slovenian_ci NOT NULL,
  212. `salt` text CHARACTER SET latin1 NOT NULL,
  213. `odprto_teden_zacetek` varchar(8) CHARACTER SET latin1 NOT NULL,
  214. `odprto_teden_konec` varchar(8) CHARACTER SET latin1 NOT NULL,
  215. `odprto_sobota_zacetek` varchar(8) CHARACTER SET latin1 NOT NULL,
  216. `odprto_sobota_konec` varchar(8) CHARACTER SET latin1 NOT NULL,
  217. `odprto_nedelja_zacetek` varchar(8) CHARACTER SET latin1 NOT NULL,
  218. `odprto_nedelja_konec` varchar(8) CHARACTER SET latin1 NOT NULL,
  219. `datum_registracije` datetime NOT NULL,
  220. `dostava` tinyint(1) NOT NULL,
  221. `boni` tinyint(1) NOT NULL,
  222. `dostava_vikend` tinyint(1) NOT NULL,
  223. `vege` tinyint(1) NOT NULL,
  224. `kosila` tinyint(1) NOT NULL,
  225. `img` varchar(128) COLLATE utf16_slovenian_ci DEFAULT NULL,
  226. `placilo_gotovina` tinyint(1) NOT NULL,
  227. `placilo_kartica` tinyint(1) NOT NULL,
  228. `placilo_moneta` tinyint(1) NOT NULL,
  229. PRIMARY KEY (`id`)
  230. ) ENGINE=InnoDB DEFAULT CHARSET=utf16 COLLATE=utf16_slovenian_ci;
  231.  
  232. --
  233. -- Dumping data for table `lokal`
  234. --
  235.  
  236. INSERT INTO `lokal` (`id`, `active`, `naziv`, `lastnik`, `naslov`, `kraj`, `telefon`, `email`, `geslo`, `salt`, `odprto_teden_zacetek`, `odprto_teden_konec`, `odprto_sobota_zacetek`, `odprto_sobota_konec`, `odprto_nedelja_zacetek`, `odprto_nedelja_konec`, `datum_registracije`, `dostava`, `boni`, `dostava_vikend`, `vege`, `kosila`, `img`, `placilo_gotovina`, `placilo_kartica`, `placilo_moneta`) VALUES
  237. (1893643639, 1, 'Back Werk', 'null', 'Slovenska cesta 52', 'Ljubljana', '031000000', 'null@gmail.com', 'adba5a82a61eb402dd3c7f939f6344f0021d78a54e553a2cba0d74f0845a4404', '27096876959727515', '00:00', '00:00', '00:00', '00:00', '00:00', '00:00', '2016-09-08 23:24:49', 0, 0, 1, 0, 0, NULL, 0, 0, 0),
  238. (6934453239, 1, 'Back Werk', 'null', 'Slovenska cesta 52', 'Ljubljana', '031000000', 'null@gmail.com', 'adba5a82a61eb402dd3c7f939f6344f0021d78a54e553a2cba0d74f0845a4404', '27096876959727515', '00:00', '00:00', '00:00', '00:00', '00:00', '00:00', '2016-09-08 23:24:49', 0, 0, 1, 0, 0, NULL, 0, 0, 0),
  239. (6934455239, 1, 'Back Werk', 'null', 'Slovenska cesta 52', 'Ljubljana', '031000000', 'null@gmail.com', 'adba5a82a61eb402dd3c7f939f6344f0021d78a54e553a2cba0d74f0845a4404', '27096876959727515', '00:00', '00:00', '00:00', '00:00', '00:00', '00:00', '2016-09-08 23:24:49', 0, 0, 1, 0, 0, NULL, 0, 0, 0),
  240. (6936453239, 1, 'Back Werk', 'null', 'Slovenska cesta 52', 'Ljubljana', '031000000', 'null@gmail.com', 'adba5a82a61eb402dd3c7f939f6344f0021d78a54e553a2cba0d74f0845a4404', '27096876959727515', '00:00', '00:00', '00:00', '00:00', '00:00', '00:00', '2016-09-08 23:24:49', 0, 0, 1, 0, 0, NULL, 0, 0, 0),
  241. (6936453639, 1, 'Back Werk', 'null', 'Slovenska cesta 52', 'Ljubljana', '031000000', 'null@gmail.com', 'adba5a82a61eb402dd3c7f939f6344f0021d78a54e553a2cba0d74f0845a4404', '27096876959727515', '00:00', '00:00', '00:00', '00:00', '00:00', '00:00', '2016-09-08 23:24:49', 0, 0, 1, 0, 0, NULL, 0, 0, 0),
  242. (6964455239, 1, 'Back Werk', 'null', 'Slovenska cesta 52', 'Ljubljana', '031000000', 'null@gmail.com', 'adba5a82a61eb402dd3c7f939f6344f0021d78a54e553a2cba0d74f0845a4404', '27096876959727515', '00:00', '00:00', '00:00', '00:00', '00:00', '00:00', '2016-09-08 23:24:49', 0, 0, 1, 0, 0, NULL, 0, 0, 0),
  243. (10936114618, 1, 'Back Werk', 'null', 'Slovenska cesta 52', 'Ljubljana', '031000000', 'null@gmail.com', 'adba5a82a61eb402dd3c7f939f6344f0021d78a54e553a2cba0d74f0845a4404', '27096876959727515', '00:00', '00:00', '00:00', '00:00', '00:00', '00:00', '2016-09-08 23:24:49', 0, 0, 1, 0, 0, NULL, 0, 0, 0),
  244. (10936114619, 1, 'Back Werk', 'null', 'Slovenska cesta 52', 'Ljubljana', '031000000', 'null@gmail.com', 'adba5a82a61eb402dd3c7f939f6344f0021d78a54e553a2cba0d74f0845a4404', '27096876959727515', '00:00', '00:00', '00:00', '00:00', '00:00', '00:00', '2016-09-08 23:24:49', 0, 0, 1, 0, 0, NULL, 0, 0, 0),
  245. (10936114639, 1, 'Back Werk', 'null', 'Slovenska cesta 52', 'Ljubljana', '031000000', 'null@gmail.com', 'adba5a82a61eb402dd3c7f939f6344f0021d78a54e553a2cba0d74f0845a4404', '27096876959727515', '00:00', '00:00', '00:00', '00:00', '00:00', '00:00', '2016-09-08 23:24:49', 0, 0, 1, 0, 0, NULL, 0, 0, 0),
  246. (10936414639, 1, 'Back Werk', 'null', 'Slovenska cesta 52', 'Ljubljana', '031000000', 'null@gmail.com', 'adba5a82a61eb402dd3c7f939f6344f0021d78a54e553a2cba0d74f0845a4404', '27096876959727515', '00:00', '00:00', '00:00', '00:00', '00:00', '00:00', '2016-09-08 23:24:49', 0, 0, 1, 0, 0, NULL, 0, 0, 0),
  247. (10936454639, 1, 'Back Werk', 'null', 'Slovenska cesta 52', 'Ljubljana', '031000000', 'null@gmail.com', 'adba5a82a61eb402dd3c7f939f6344f0021d78a54e553a2cba0d74f0845a4404', '27096876959727515', '00:00', '00:00', '00:00', '00:00', '00:00', '00:00', '2016-09-08 23:24:49', 0, 0, 1, 0, 0, NULL, 0, 0, 0),
  248. (12936454639, 1, 'Back Werk', 'null', 'Slovenska cesta 52', 'Ljubljana', '031000000', 'null@gmail.com', 'adba5a82a61eb402dd3c7f939f6344f0021d78a54e553a2cba0d74f0845a4404', '27096876959727515', '00:00', '00:00', '00:00', '00:00', '00:00', '00:00', '2016-09-08 23:24:49', 0, 0, 1, 0, 0, NULL, 0, 0, 0),
  249. (13936454639, 1, 'Back Werk', 'null', 'Slovenska cesta 52', 'Ljubljana', '031000000', 'null@gmail.com', 'adba5a82a61eb402dd3c7f939f6344f0021d78a54e553a2cba0d74f0845a4404', '27096876959727515', '00:00', '00:00', '00:00', '00:00', '00:00', '00:00', '2016-09-08 23:24:49', 0, 0, 1, 0, 0, NULL, 0, 0, 0),
  250. (16936454639, 1, 'Back Werk', 'null', 'Slovenska cesta 52', 'Ljubljana', '031000000', 'null@gmail.com', 'adba5a82a61eb402dd3c7f939f6344f0021d78a54e553a2cba0d74f0845a4404', '27096876959727515', '00:00', '00:00', '00:00', '00:00', '00:00', '00:00', '2016-09-08 23:24:49', 0, 0, 1, 0, 0, NULL, 0, 0, 0),
  251. (18936414639, 1, 'Back Werk', 'null', 'Slovenska cesta 52', 'Ljubljana', '031000000', 'null@gmail.com', 'adba5a82a61eb402dd3c7f939f6344f0021d78a54e553a2cba0d74f0845a4404', '27096876959727515', '00:00', '00:00', '00:00', '00:00', '00:00', '00:00', '2016-09-08 23:24:49', 0, 0, 1, 0, 0, NULL, 0, 0, 0),
  252. (18936424639, 1, 'Back Werk', 'null', 'Slovenska cesta 52', 'Ljubljana', '031000000', 'null@gmail.com', 'adba5a82a61eb402dd3c7f939f6344f0021d78a54e553a2cba0d74f0845a4404', '27096876959727515', '00:00', '00:00', '00:00', '00:00', '00:00', '00:00', '2016-09-08 23:24:49', 0, 0, 1, 0, 0, NULL, 0, 0, 0),
  253. (18936453639, 1, 'Back Werk', 'null', 'Slovenska cesta 52', 'Ljubljana', '031000000', 'null@gmail.com', 'adba5a82a61eb402dd3c7f939f6344f0021d78a54e553a2cba0d74f0845a4404', '27096876959727515', '00:00', '00:00', '00:00', '00:00', '00:00', '00:00', '2016-09-08 23:24:49', 0, 0, 1, 0, 0, NULL, 0, 0, 0),
  254. (18936454639, 1, 'Back Werk', 'null', 'Slovenska cesta 52', 'Ljubljana', '031000000', 'null@gmail.com', 'adba5a82a61eb402dd3c7f939f6344f0021d78a54e553a2cba0d74f0845a4404', '27096876959727515', '00:00', '00:00', '00:00', '00:00', '00:00', '00:00', '2016-09-08 23:24:49', 0, 0, 1, 0, 0, NULL, 0, 0, 0),
  255. (20934442485, 1, 'Astoria City Cusine', 'null', 'Slovenska ulica 2', 'Maribor', '026211700', 'null@gmail.com', '9f02abb69b0cc1386c3c42e914d003ecea548d690d8a1cbaeabc24f3b29c3943', '79788284005675642', '00:00', '00:00', '00:00', '00:00', '00:00', '00:00', '2016-09-08 23:23:21', 0, 1, 1, 1, 0, NULL, 0, 0, 0),
  256. (21061265696, 1, 'Taverna Sicilia', 'Taverna Sicilia', 'Ulica Heroja Nandeta 31', 'Maribor', '024260315', 'taverna@gmail.com', 'ada74449655cc03710ed3e0f6ae2b70570c608806e0c8e29f7b61f5037cc1601', '95349182653758480', '09:00', '20:00', '11:00', '20:00', '11:00', '20:00', '2016-09-23 14:09:00', 1, 1, 1, 1, 1, NULL, 1, 1, 1),
  257. (35358669632, 1, 'Gurmanski hram', 'Gurmanski hram', 'Zagrebška cesta 92', 'Maribor', '031467088', 'gurmanski@gmail.com', 'c056c6544d63f8809711acbc7de018bb4e9e77ce92e4be3abeb1fbf33656c9b2', '54609880451878850', '10:10', '16:00', '00:00', '00:00', '00:00', '00:00', '2016-09-24 09:52:00', 1, 1, 0, 1, 1, NULL, 1, 0, 0),
  258. (52927503148, 1, 'Apači', 'Apači', 'Pohorska cesta 17b', 'Slovenj Gradec', '028831784', 'apaci@gmail.com', '923b10184d21542f7a487f9300df1acab272269c9e41edf80d49934e73f0a370', '88528993183838781', '01:00', '23:00', '12:00', '01:00', '12:00', '22:00', '2016-09-08 14:29:57', 0, 1, 0, 1, 0, NULL, 0, 0, 0),
  259. (66328866021, 1, 'AROMA, restavracija in pizzerija', 'null', 'Ribji trg 2', 'Ljubljana', '031000000', 'noemail@gmail.com', '7ad3ed8d42f79c9e03a11102c3ca33c517d4ec0f923e99043982019f0c1daea4', '82067569399867435', '00:00', '00:00', '00:00', '00:00', '00:00', '00:00', '2016-09-08 23:21:48', 0, 0, 1, 1, 0, NULL, 0, 0, 0),
  260. (82045867280, 1, 'tilen', 'tilen', 'tilen', 'tilen', '031000000', 'tilen@gmail.com', '58dfa4991ba96e60caaad2728dc89ab89552a107e714d54c0dbe8b2103c5e60e', '78306335072898800', '00:00', '00:00', '00:00', '00:00', '00:00', '00:00', '2016-09-10 15:44:00', 1, 1, 1, 1, 1, NULL, 0, 0, 0),
  261. (82386710868, 1, 'AL Pachino', 'AL Pachino', 'Gosposvetska cesta 87', 'Maribor', '041566373', 'alpachino@gmail.com', '58dfa4991ba96e60caaad2728dc89ab89552a107e714d54c0dbe8b2103c5e60e', '78306335072898800', '10:00', '20:00', '00:00', '00:00', '00:00', '00:00', '2016-09-08 14:27:24', 1, 1, 1, 0, 0, NULL, 0, 0, 0),
  262. (84189335439, 1, 'Bohor d.o.o.', 'Bohor d.o.o.', 'Kidričeva ulica 23', 'Rogaška Slatina', '031000000', 'null@gmail.com', '5dba49c1fc147a6cc814fae84bc3f29405c222f4dc9ddafc547cd3b0e862d66c', '33987949451383398', '00:00', '00:00', '00:00', '00:00', '00:00', '00:00', '2016-09-08 23:27:47', 0, 0, 1, 1, 0, NULL, 0, 0, 0);
  263.  
  264. -- --------------------------------------------------------
  265.  
  266. --
  267. -- Table structure for table `lokal_nagrada`
  268. --
  269.  
  270. CREATE TABLE IF NOT EXISTS `lokal_nagrada` (
  271. `id` int(11) NOT NULL AUTO_INCREMENT,
  272. `fk_lokal_id` bigint(20) NOT NULL,
  273. `fk_nagrada_id` int(11) NOT NULL,
  274. `datum_prejema` datetime NOT NULL,
  275. PRIMARY KEY (`id`),
  276. KEY `fk_lokal_id` (`fk_lokal_id`,`fk_nagrada_id`),
  277. KEY `fk_lokal_id_2` (`fk_lokal_id`),
  278. KEY `fk_nagrada_id` (`fk_nagrada_id`)
  279. ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
  280.  
  281. -- --------------------------------------------------------
  282.  
  283. --
  284. -- Table structure for table `nacin_placila`
  285. --
  286.  
  287. CREATE TABLE IF NOT EXISTS `nacin_placila` (
  288. `id` int(11) NOT NULL AUTO_INCREMENT,
  289. `naziv` varchar(32) NOT NULL,
  290. PRIMARY KEY (`id`)
  291. ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;
  292.  
  293. --
  294. -- Dumping data for table `nacin_placila`
  295. --
  296.  
  297. INSERT INTO `nacin_placila` (`id`, `naziv`) VALUES
  298. (1, 'Gotovina'),
  299. (2, 'Kartica'),
  300. (3, 'Moneta');
  301.  
  302. -- --------------------------------------------------------
  303.  
  304. --
  305. -- Table structure for table `nagrada`
  306. --
  307.  
  308. CREATE TABLE IF NOT EXISTS `nagrada` (
  309. `id` int(11) NOT NULL AUTO_INCREMENT,
  310. `naziv` varchar(64) COLLATE utf8_slovenian_ci NOT NULL,
  311. `ico` varchar(64) COLLATE utf8_slovenian_ci DEFAULT NULL,
  312. PRIMARY KEY (`id`)
  313. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_slovenian_ci AUTO_INCREMENT=1 ;
  314.  
  315. -- --------------------------------------------------------
  316.  
  317. --
  318. -- Table structure for table `narocilo`
  319. --
  320.  
  321. CREATE TABLE IF NOT EXISTS `narocilo` (
  322. `id` bigint(20) NOT NULL,
  323. `fk_uporabnik_id` bigint(20) NOT NULL,
  324. `fk_jedilnik_meni_id` int(11) DEFAULT NULL,
  325. `fk_lokal_id` bigint(20) NOT NULL,
  326. `bon` tinyint(1) NOT NULL,
  327. `naslov` varchar(64) CHARACTER SET utf8 COLLATE utf8_slovenian_ci NOT NULL,
  328. `kraj` varchar(64) CHARACTER SET utf8 COLLATE utf8_slovenian_ci NOT NULL,
  329. `telefon` varchar(64) NOT NULL,
  330. `cena` double NOT NULL,
  331. `komentar` text CHARACTER SET utf8 COLLATE utf8_slovenian_ci NOT NULL,
  332. `datum_narocila` datetime NOT NULL,
  333. `datum_sprejema` datetime DEFAULT NULL,
  334. `koncano` tinyint(1) NOT NULL DEFAULT '0',
  335. `predviden_cas_dostave` int(11) DEFAULT NULL,
  336. `fk_nacin_placila` int(11) DEFAULT '1',
  337. `zavrnjeno` tinyint(1) NOT NULL DEFAULT '0',
  338. PRIMARY KEY (`id`),
  339. KEY `fk_uporabnik_id` (`fk_uporabnik_id`),
  340. KEY `fk_lokal_id` (`fk_lokal_id`),
  341. KEY `fk_jedilnik_meni_id` (`fk_jedilnik_meni_id`),
  342. KEY `fk_nacin_placila` (`fk_nacin_placila`)
  343. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  344.  
  345. --
  346. -- Dumping data for table `narocilo`
  347. --
  348.  
  349. INSERT INTO `narocilo` (`id`, `fk_uporabnik_id`, `fk_jedilnik_meni_id`, `fk_lokal_id`, `bon`, `naslov`, `kraj`, `telefon`, `cena`, `komentar`, `datum_narocila`, `datum_sprejema`, `koncano`, `predviden_cas_dostave`, `fk_nacin_placila`, `zavrnjeno`) VALUES
  350. (48823427674, 86891762479, 175, 21061265696, 1, 'Naslov 12', 'Maribor', '031000000', 3.6, '', '2016-09-26 13:36:00', NULL, 0, NULL, 1, 0),
  351. (57079355894, 86891762479, 176, 21061265696, 1, 'Naslov 12', 'Maribor', '031000000', 3.6, '', '2016-09-26 13:36:00', NULL, 0, NULL, 1, 0),
  352. (63259454303, 86891762479, 175, 21061265696, 1, 'Naslov 12', 'Maribor', '031000000', 3.6, '', '2016-09-26 14:53:00', NULL, 0, NULL, 1, 0);
  353.  
  354. -- --------------------------------------------------------
  355.  
  356. --
  357. -- Table structure for table `narocilo_feedback`
  358. --
  359.  
  360. CREATE TABLE IF NOT EXISTS `narocilo_feedback` (
  361. `id` int(11) NOT NULL AUTO_INCREMENT,
  362. `fk_uporabnik_id` bigint(20) NOT NULL,
  363. `fk_narocilo_id` bigint(20) DEFAULT NULL,
  364. `fk_lokal_id` bigint(20) NOT NULL,
  365. `ocena` int(11) NOT NULL,
  366. `mnenje` text NOT NULL,
  367. PRIMARY KEY (`id`),
  368. KEY `fk_lokal_id` (`fk_lokal_id`),
  369. KEY `fk_uporabnik_id` (`fk_uporabnik_id`),
  370. KEY `fk_narocilo_id` (`fk_narocilo_id`)
  371. ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=20 ;
  372.  
  373. --
  374. -- Dumping data for table `narocilo_feedback`
  375. --
  376.  
  377. INSERT INTO `narocilo_feedback` (`id`, `fk_uporabnik_id`, `fk_narocilo_id`, `fk_lokal_id`, `ocena`, `mnenje`) VALUES
  378. (16, 86891762479, NULL, 82386710868, 4, '123'),
  379. (17, 86891762479, NULL, 21061265696, 5, 'dobro'),
  380. (18, 86891762479, NULL, 21061265696, 5, 'ok'),
  381. (19, 86891762479, NULL, 21061265696, 5, '');
  382.  
  383. -- --------------------------------------------------------
  384.  
  385. --
  386. -- Table structure for table `ocena`
  387. --
  388.  
  389. CREATE TABLE IF NOT EXISTS `ocena` (
  390. `id` int(11) NOT NULL AUTO_INCREMENT,
  391. `fk_lokal_id` bigint(11) NOT NULL,
  392. `fk_uporabnik_id` bigint(11) NOT NULL,
  393. `ocena` int(11) NOT NULL,
  394. PRIMARY KEY (`id`),
  395. KEY `fk_uporabnik_id` (`fk_uporabnik_id`),
  396. KEY `fk_lokal_id` (`fk_lokal_id`)
  397. ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=16 ;
  398.  
  399. --
  400. -- Dumping data for table `ocena`
  401. --
  402.  
  403. INSERT INTO `ocena` (`id`, `fk_lokal_id`, `fk_uporabnik_id`, `ocena`) VALUES
  404. (12, 82386710868, 86891762479, 5),
  405. (13, 52927503148, 86891762479, 3),
  406. (14, 82045867280, 86891762479, 5),
  407. (15, 21061265696, 86891762479, 5);
  408.  
  409. -- --------------------------------------------------------
  410.  
  411. --
  412. -- Table structure for table `priljubljeno`
  413. --
  414.  
  415. CREATE TABLE IF NOT EXISTS `priljubljeno` (
  416. `id` int(11) NOT NULL AUTO_INCREMENT,
  417. `fk_uporabnik_id` bigint(20) NOT NULL,
  418. `fk_lokal_id` bigint(20) NOT NULL,
  419. PRIMARY KEY (`id`),
  420. KEY `fk_uporabnik_id` (`fk_uporabnik_id`,`fk_lokal_id`),
  421. KEY `fk_lokal_id` (`fk_lokal_id`)
  422. ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=18 ;
  423.  
  424. --
  425. -- Dumping data for table `priljubljeno`
  426. --
  427.  
  428. INSERT INTO `priljubljeno` (`id`, `fk_uporabnik_id`, `fk_lokal_id`) VALUES
  429. (14, 86891762479, 82045867280),
  430. (17, 86891762479, 82386710868);
  431.  
  432. -- --------------------------------------------------------
  433.  
  434. --
  435. -- Table structure for table `uporabnik`
  436. --
  437.  
  438. CREATE TABLE IF NOT EXISTS `uporabnik` (
  439. `id` bigint(11) NOT NULL,
  440. `email` varchar(32) NOT NULL,
  441. `ime` varchar(14) CHARACTER SET utf8 COLLATE utf8_slovenian_ci NOT NULL,
  442. `priimek` varchar(20) CHARACTER SET utf8 COLLATE utf8_slovenian_ci NOT NULL,
  443. `telefon` varchar(14) NOT NULL,
  444. `naslov` varchar(40) CHARACTER SET utf8 COLLATE utf8_slovenian_ci NOT NULL,
  445. `kraj` varchar(20) CHARACTER SET utf8 COLLATE utf8_slovenian_ci NOT NULL,
  446. `geslo` text CHARACTER SET utf8 COLLATE utf8_slovenian_ci NOT NULL,
  447. `salt` text NOT NULL,
  448. `ip` varchar(20) NOT NULL,
  449. `datum_registracije` datetime NOT NULL,
  450. `bon` tinyint(1) NOT NULL,
  451. `last_login` datetime NOT NULL,
  452. `narocilo_default_naslov` tinyint(1) NOT NULL DEFAULT '0',
  453. PRIMARY KEY (`id`)
  454. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  455.  
  456. --
  457. -- Dumping data for table `uporabnik`
  458. --
  459.  
  460. INSERT INTO `uporabnik` (`id`, `email`, `ime`, `priimek`, `telefon`, `naslov`, `kraj`, `geslo`, `salt`, `ip`, `datum_registracije`, `bon`, `last_login`, `narocilo_default_naslov`) VALUES
  461. (39419784779, 'poqwek@gmail.com', 'qpwoek', 'qwpoek', '031000000', 'qpwoek', 'qwepok', '984c063ea00984de73129ef5f21aae8ee8b6cc6ea84e1f870b48cb2c09026756', '99688739803629536', '::1', '2016-09-10 12:26:00', 1, '2016-09-10 12:26:00', 0),
  462. (59588628968, 'topkek@gmail.com', 'weiorj', 'qweopk', '031000000', 'qwekowoek', 'qwopek', 'c8af6fbd53a217c783881c02f8e1d78aaf5129bd229e04d890b8c95bb9610f81', '81289829638870888', '::1', '2016-09-24 09:27:00', 1, '2016-09-24 09:27:00', 0),
  463. (86891762479, 'tilen1@gmail.com', 'tilen', 'priimek', '031000000', 'naslov 12', 'maribor', '2bac383336519df7129ca77575dad272bfe86ff8547a6841dc1f8e648086654c', '80509632030640054', '::1', '2016-09-10 14:18:00', 1, '2016-09-26 13:28:00', 0);
  464.  
  465. -- --------------------------------------------------------
  466.  
  467. --
  468. -- Table structure for table `uporabnik_nagrada`
  469. --
  470.  
  471. CREATE TABLE IF NOT EXISTS `uporabnik_nagrada` (
  472. `id` int(11) NOT NULL AUTO_INCREMENT,
  473. `fk_uporabnik_id` bigint(20) NOT NULL,
  474. `fk_nagrada_id` int(11) NOT NULL,
  475. `datum_prejema` datetime NOT NULL,
  476. PRIMARY KEY (`id`),
  477. KEY `fk_uporabnik_id` (`fk_uporabnik_id`,`fk_nagrada_id`),
  478. KEY `fk_uporabnik_id_2` (`fk_uporabnik_id`),
  479. KEY `fk_nagrada_id` (`fk_nagrada_id`)
  480. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_slovenian_ci AUTO_INCREMENT=1 ;
  481.  
  482. --
  483. -- Constraints for dumped tables
  484. --
  485.  
  486. --
  487. -- Constraints for table `akcija`
  488. --
  489. ALTER TABLE `akcija`
  490. ADD CONSTRAINT `akcija_ibfk_1` FOREIGN KEY (`fk_lokal_id`) REFERENCES `lokal` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
  491.  
  492. --
  493. -- Constraints for table `feedback`
  494. --
  495. ALTER TABLE `feedback`
  496. ADD CONSTRAINT `feedback_ibfk_1` FOREIGN KEY (`fk_uporabnik_id`) REFERENCES `uporabnik` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  497. ADD CONSTRAINT `feedback_ibfk_2` FOREIGN KEY (`fk_lokal_id`) REFERENCES `lokal` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
  498.  
  499. --
  500. -- Constraints for table `jedilnik`
  501. --
  502. ALTER TABLE `jedilnik`
  503. ADD CONSTRAINT `jedilnik_ibfk_1` FOREIGN KEY (`fk_lokal_id`) REFERENCES `lokal` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
  504.  
  505. --
  506. -- Constraints for table `jedilnik_meni`
  507. --
  508. ALTER TABLE `jedilnik_meni`
  509. ADD CONSTRAINT `jedilnik_meni_ibfk_1` FOREIGN KEY (`fk_jedilnik_id`) REFERENCES `jedilnik` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  510. ADD CONSTRAINT `jedilnik_meni_ibfk_2` FOREIGN KEY (`fk_jedilnik_tip`) REFERENCES `jedilnik_tip` (`id`) ON DELETE SET NULL ON UPDATE SET NULL;
  511.  
  512. --
  513. -- Constraints for table `lokal_nagrada`
  514. --
  515. ALTER TABLE `lokal_nagrada`
  516. ADD CONSTRAINT `lokal_nagrada_ibfk_2` FOREIGN KEY (`fk_nagrada_id`) REFERENCES `nagrada` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  517. ADD CONSTRAINT `lokal_nagrada_ibfk_1` FOREIGN KEY (`fk_lokal_id`) REFERENCES `lokal` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
  518.  
  519. --
  520. -- Constraints for table `narocilo`
  521. --
  522. ALTER TABLE `narocilo`
  523. ADD CONSTRAINT `narocilo_ibfk_1` FOREIGN KEY (`fk_lokal_id`) REFERENCES `lokal` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  524. ADD CONSTRAINT `narocilo_ibfk_2` FOREIGN KEY (`fk_uporabnik_id`) REFERENCES `uporabnik` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  525. ADD CONSTRAINT `narocilo_ibfk_3` FOREIGN KEY (`fk_jedilnik_meni_id`) REFERENCES `jedilnik_meni` (`id`) ON DELETE SET NULL ON UPDATE SET NULL,
  526. ADD CONSTRAINT `narocilo_ibfk_4` FOREIGN KEY (`fk_nacin_placila`) REFERENCES `nacin_placila` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
  527.  
  528. --
  529. -- Constraints for table `narocilo_feedback`
  530. --
  531. ALTER TABLE `narocilo_feedback`
  532. ADD CONSTRAINT `narocilo_feedback_ibfk_1` FOREIGN KEY (`fk_uporabnik_id`) REFERENCES `uporabnik` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  533. ADD CONSTRAINT `narocilo_feedback_ibfk_2` FOREIGN KEY (`fk_narocilo_id`) REFERENCES `narocilo` (`id`) ON DELETE SET NULL ON UPDATE SET NULL,
  534. ADD CONSTRAINT `narocilo_feedback_ibfk_3` FOREIGN KEY (`fk_lokal_id`) REFERENCES `lokal` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
  535.  
  536. --
  537. -- Constraints for table `ocena`
  538. --
  539. ALTER TABLE `ocena`
  540. ADD CONSTRAINT `ocena_ibfk_1` FOREIGN KEY (`fk_lokal_id`) REFERENCES `lokal` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  541. ADD CONSTRAINT `ocena_ibfk_2` FOREIGN KEY (`fk_uporabnik_id`) REFERENCES `uporabnik` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
  542.  
  543. --
  544. -- Constraints for table `priljubljeno`
  545. --
  546. ALTER TABLE `priljubljeno`
  547. ADD CONSTRAINT `priljubljeno_ibfk_1` FOREIGN KEY (`fk_uporabnik_id`) REFERENCES `uporabnik` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  548. ADD CONSTRAINT `priljubljeno_ibfk_2` FOREIGN KEY (`fk_lokal_id`) REFERENCES `lokal` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
  549.  
  550. --
  551. -- Constraints for table `uporabnik_nagrada`
  552. --
  553. ALTER TABLE `uporabnik_nagrada`
  554. ADD CONSTRAINT `uporabnik_nagrada_ibfk_2` FOREIGN KEY (`fk_nagrada_id`) REFERENCES `nagrada` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  555. ADD CONSTRAINT `uporabnik_nagrada_ibfk_1` FOREIGN KEY (`fk_uporabnik_id`) REFERENCES `uporabnik` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
  556.  
  557. /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
  558. /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
  559. /*!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!