API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Sep 21st, 2016
107
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 22.41 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 22, 2016 at 12:01 AM
  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 `feedback`
  27. --
  28.  
  29. CREATE TABLE IF NOT EXISTS `feedback` (
  30. `id` int(11) NOT NULL AUTO_INCREMENT,
  31. `text` text CHARACTER SET latin1 NOT NULL,
  32. `fk_uporabnik_id` bigint(20) DEFAULT NULL,
  33. `fk_lokal_id` bigint(20) DEFAULT NULL,
  34. `datum` datetime NOT NULL,
  35. PRIMARY KEY (`id`),
  36. KEY `fk_uporabnik_id` (`fk_uporabnik_id`),
  37. KEY `fk_lokal_id` (`fk_lokal_id`)
  38. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_slovenian_ci AUTO_INCREMENT=22 ;
  39.  
  40. --
  41. -- Dumping data for table `feedback`
  42. --
  43.  
  44. INSERT INTO `feedback` (`id`, `text`, `fk_uporabnik_id`, `fk_lokal_id`, `datum`) VALUES
  45. (1, 'ertert', NULL, NULL, '2016-09-20 16:32:00'),
  46. (2, 'ertert', NULL, NULL, '2016-09-20 16:32:00'),
  47. (3, 'ertert', NULL, NULL, '2016-09-20 16:32:00'),
  48. (4, 'ertert', NULL, NULL, '2016-09-20 16:32:00'),
  49. (5, 'ertert', NULL, NULL, '2016-09-20 16:32:00'),
  50. (6, 'ertert', NULL, NULL, '2016-09-20 16:32:00'),
  51. (7, 'ertert', NULL, NULL, '2016-09-20 16:32:00'),
  52. (8, 'ertert', NULL, NULL, '2016-09-20 16:32:00'),
  53. (9, 'ertert', NULL, NULL, '2016-09-20 16:32:00'),
  54. (10, 'ertert', NULL, NULL, '2016-09-20 16:32:00'),
  55. (11, 'ertert', NULL, NULL, '2016-09-20 16:32:00'),
  56. (12, 'ertert', NULL, NULL, '2016-09-20 16:32:00'),
  57. (13, 'zrtzr', NULL, 82386710868, '2016-09-20 16:33:00'),
  58. (14, 'werwer', 86891762479, NULL, '2016-09-20 16:34:00'),
  59. (15, 'rtzertz', 86891762479, NULL, '2016-09-20 16:37:00'),
  60. (16, 'rtzertz', 86891762479, NULL, '2016-09-20 16:37:00'),
  61. (17, 'rtzertz', 86891762479, NULL, '2016-09-20 16:37:00'),
  62. (18, 'rtzertz', 86891762479, NULL, '2016-09-20 16:37:00'),
  63. (19, 'rtuzrtz', 86891762479, NULL, '2016-09-20 16:38:00'),
  64. (20, '78', NULL, 82386710868, '2016-09-20 17:14:00'),
  65. (21, 'iopsdjt', 86891762479, NULL, '2016-09-20 23:58:00');
  66.  
  67. -- --------------------------------------------------------
  68.  
  69. --
  70. -- Table structure for table `jedilnik`
  71. --
  72.  
  73. CREATE TABLE IF NOT EXISTS `jedilnik` (
  74. `id` bigint(20) NOT NULL,
  75. `fk_lokal_id` bigint(20) NOT NULL,
  76. `memo` varchar(64) COLLATE utf8_slovenian_ci NOT NULL,
  77. `datum_vnosa` datetime NOT NULL,
  78. `nazadnje_uporabljeno` datetime NOT NULL,
  79. `active` tinyint(1) NOT NULL DEFAULT '0',
  80. PRIMARY KEY (`id`),
  81. KEY `fk_lokal_id` (`fk_lokal_id`)
  82. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_slovenian_ci;
  83.  
  84. --
  85. -- Dumping data for table `jedilnik`
  86. --
  87.  
  88. INSERT INTO `jedilnik` (`id`, `fk_lokal_id`, `memo`, `datum_vnosa`, `nazadnje_uporabljeno`, `active`) VALUES
  89. (7588134078, 82045867280, '123', '2016-09-17 14:44:00', '2016-09-17 14:44:00', 0),
  90. (8649271841, 82045867280, 'wewe', '2016-09-17 20:29:00', '2016-09-17 20:29:00', 0),
  91. (11204853268, 82045867280, 'jedilnik', '2016-09-17 20:34:00', '2016-09-17 20:34:00', 1),
  92. (15310941807, 82045867280, '1', '2016-09-17 20:31:00', '2016-09-17 20:31:00', 0),
  93. (20829631860, 82045867280, '33', '2016-09-17 20:28:00', '2016-09-17 20:28:00', 0),
  94. (26249310923, 82386710868, 'ttz', '2016-09-19 12:00:00', '2016-09-19 12:00:00', 0),
  95. (28383515488, 82045867280, '333333', '2016-09-17 20:26:00', '2016-09-17 20:26:00', 0),
  96. (33798324768, 82045867280, '123', '2016-09-17 14:45:00', '2016-09-17 14:45:00', 0),
  97. (33824648320, 82045867280, '1', '2016-09-17 20:31:00', '2016-09-17 20:31:00', 0),
  98. (48058712889, 82045867280, '123', '2016-09-17 21:12:00', '2016-09-17 21:12:00', 0),
  99. (52878884339, 82045867280, '1', '2016-09-17 20:31:00', '2016-09-17 20:31:00', 0),
  100. (59663741564, 82045867280, 'tilen1', '2016-09-17 20:26:00', '2016-09-17 20:26:00', 0),
  101. (63831642153, 82045867280, 'asd', '2016-09-17 20:29:00', '2016-09-17 20:29:00', 0),
  102. (68163308184, 82045867280, '5', '2016-09-17 20:32:00', '2016-09-17 20:32:00', 0),
  103. (68380364088, 82386710868, 'Vikend meni', '2016-09-20 22:45:00', '2016-09-20 22:45:00', 1),
  104. (82911641268, 82386710868, 'Teden meni', '2016-09-11 18:34:00', '2016-09-11 18:34:00', 0),
  105. (89038977489, 82045867280, '33', '2016-09-17 20:26:00', '2016-09-17 20:26:00', 0);
  106.  
  107. -- --------------------------------------------------------
  108.  
  109. --
  110. -- Table structure for table `jedilnik_meni`
  111. --
  112.  
  113. CREATE TABLE IF NOT EXISTS `jedilnik_meni` (
  114. `id` int(11) NOT NULL AUTO_INCREMENT,
  115. `naziv` varchar(64) COLLATE utf8_slovenian_ci DEFAULT NULL,
  116. `fk_jedilnik_id` bigint(20) NOT NULL,
  117. `fk_jedilnik_tip` int(11) DEFAULT NULL,
  118. `jedilnik` mediumtext COLLATE utf8_slovenian_ci NOT NULL,
  119. `cena` double DEFAULT '-1',
  120. PRIMARY KEY (`id`),
  121. KEY `fk_meni_id` (`fk_jedilnik_id`),
  122. KEY `fk_jedilnik_tip` (`fk_jedilnik_tip`),
  123. KEY `fk_meni_id_2` (`fk_jedilnik_id`),
  124. KEY `fk_jedilnik_tip_2` (`fk_jedilnik_tip`),
  125. KEY `fk_jedilnik_id` (`fk_jedilnik_id`)
  126. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_slovenian_ci AUTO_INCREMENT=50 ;
  127.  
  128. --
  129. -- Dumping data for table `jedilnik_meni`
  130. --
  131.  
  132. INSERT INTO `jedilnik_meni` (`id`, `naziv`, `fk_jedilnik_id`, `fk_jedilnik_tip`, `jedilnik`, `cena`) VALUES
  133. (33, 'AOPMD123', 82911641268, 2, '213', -1),
  134. (37, '123', 11204853268, 2, '2::22::222::2222', 2),
  135. (38, '123', 11204853268, 3, '3', 3),
  136. (39, '123', 11204853268, 4, '44', 4),
  137. (40, '123', 48058712889, 2, '21', 123.5),
  138. (41, NULL, 48058712889, 3, '33', 123.5),
  139. (42, NULL, 48058712889, 3, 'wq', 123.5),
  140. (43, '123', 48058712889, 3, 'cx', 123.5),
  141. (44, '123', 48058712889, 6, 'sd', 123.5),
  142. (45, NULL, 26249310923, 2, '123::123::123', 12),
  143. (46, '123', 26249310923, 2, '33::33', 12),
  144. (47, 'Kosilo 1', 68380364088, 1, 'Paradižnikova juha::Svinski file v naravni omaki, pire::Sezonska solata::Jabolka', 3.18),
  145. (48, 'Kosilo 2', 68380364088, 2, 'PARADIŽNIKOVA JUHA::VALVICE Z GAMBERI,BROKOLIJEM IN ANANASOM::SEZONSKA SOLATA::JABOLKO', 3.18),
  146. (49, 'Kosilo 3', 68380364088, 6, 'PARADIŽNIKOVA JUHA::MESNI TORTELINI Z ZELENJAVO::SEZONSKA SOLATA::JABOLKO', 3.18);
  147.  
  148. -- --------------------------------------------------------
  149.  
  150. --
  151. -- Table structure for table `jedilnik_tip`
  152. --
  153.  
  154. CREATE TABLE IF NOT EXISTS `jedilnik_tip` (
  155. `id` int(11) NOT NULL,
  156. `naziv` varchar(32) NOT NULL,
  157. PRIMARY KEY (`id`)
  158. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  159.  
  160. --
  161. -- Dumping data for table `jedilnik_tip`
  162. --
  163.  
  164. INSERT INTO `jedilnik_tip` (`id`, `naziv`) VALUES
  165. (1, 'Mesni'),
  166. (2, 'Vege'),
  167. (3, 'Ribe'),
  168. (4, 'Hitra hrana'),
  169. (5, 'Pizza'),
  170. (6, 'Testenine');
  171.  
  172. -- --------------------------------------------------------
  173.  
  174. --
  175. -- Table structure for table `lokal`
  176. --
  177.  
  178. CREATE TABLE IF NOT EXISTS `lokal` (
  179. `id` bigint(11) NOT NULL,
  180. `active` tinyint(1) NOT NULL DEFAULT '1',
  181. `naziv` varchar(32) COLLATE utf16_slovenian_ci NOT NULL,
  182. `lastnik` varchar(32) COLLATE utf16_slovenian_ci NOT NULL,
  183. `naslov` varchar(48) COLLATE utf16_slovenian_ci NOT NULL,
  184. `kraj` varchar(20) COLLATE utf16_slovenian_ci NOT NULL,
  185. `telefon` varchar(14) CHARACTER SET latin1 NOT NULL,
  186. `email` varchar(32) CHARACTER SET latin1 DEFAULT NULL,
  187. `geslo` text CHARACTER SET utf32 COLLATE utf32_slovenian_ci NOT NULL,
  188. `salt` text CHARACTER SET latin1 NOT NULL,
  189. `odprto_teden_zacetek` varchar(8) CHARACTER SET latin1 NOT NULL,
  190. `odprto_teden_konec` varchar(8) CHARACTER SET latin1 NOT NULL,
  191. `odprto_sobota_zacetek` varchar(8) CHARACTER SET latin1 NOT NULL,
  192. `odprto_sobota_konec` varchar(8) CHARACTER SET latin1 NOT NULL,
  193. `odprto_nedelja_zacetek` varchar(8) CHARACTER SET latin1 NOT NULL,
  194. `odprto_nedelja_konec` varchar(8) CHARACTER SET latin1 NOT NULL,
  195. `datum_registracije` datetime NOT NULL,
  196. `dostava` tinyint(1) NOT NULL,
  197. `boni` tinyint(1) NOT NULL,
  198. `dostava_vikend` tinyint(1) NOT NULL,
  199. `vege` tinyint(1) NOT NULL,
  200. `kosila` tinyint(1) NOT NULL,
  201. `img` varchar(128) COLLATE utf16_slovenian_ci DEFAULT NULL,
  202. `placilo_gotovina` tinyint(1) NOT NULL,
  203. `placilo_kartica` tinyint(1) NOT NULL,
  204. `placilo_moneta` tinyint(1) NOT NULL,
  205. PRIMARY KEY (`id`)
  206. ) ENGINE=InnoDB DEFAULT CHARSET=utf16 COLLATE=utf16_slovenian_ci;
  207.  
  208. --
  209. -- Dumping data for table `lokal`
  210. --
  211.  
  212. 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
  213. (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),
  214. (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),
  215. (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),
  216. (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),
  217. (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),
  218. (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),
  219. (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),
  220. (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),
  221. (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),
  222. (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),
  223. (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),
  224. (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),
  225. (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),
  226. (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),
  227. (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),
  228. (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),
  229. (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),
  230. (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),
  231. (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),
  232. (52927503148, 1, 'Apači', 'Apači', 'Pohorska cesta 17b', 'Slovenj Gradec', '028831784', 'apaci@gmail.com', '923b10184d21542f7a487f9300df1acab272269c9e41edf80d49934e73f0a370', '88528993183838781', '09: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),
  233. (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),
  234. (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),
  235. (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),
  236. (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);
  237.  
  238. -- --------------------------------------------------------
  239.  
  240. --
  241. -- Table structure for table `nacin_placila`
  242. --
  243.  
  244. CREATE TABLE IF NOT EXISTS `nacin_placila` (
  245. `id` int(11) NOT NULL AUTO_INCREMENT,
  246. PRIMARY KEY (`id`)
  247. ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;
  248.  
  249. -- --------------------------------------------------------
  250.  
  251. --
  252. -- Table structure for table `narocilo`
  253. --
  254.  
  255. CREATE TABLE IF NOT EXISTS `narocilo` (
  256. `id` bigint(20) NOT NULL,
  257. `fk_uporabnik_id` bigint(20) NOT NULL,
  258. `fk_jedilnik_meni_id` int(11) DEFAULT NULL,
  259. `fk_lokal_id` bigint(20) NOT NULL,
  260. `bon` tinyint(1) NOT NULL,
  261. `naslov` varchar(64) CHARACTER SET utf8 COLLATE utf8_slovenian_ci NOT NULL,
  262. `kraj` varchar(64) CHARACTER SET utf8 COLLATE utf8_slovenian_ci NOT NULL,
  263. `telefon` varchar(64) NOT NULL,
  264. `cena` double NOT NULL,
  265. `komentar` text CHARACTER SET utf8 COLLATE utf8_slovenian_ci NOT NULL,
  266. `datum_narocila` datetime NOT NULL,
  267. `datum_sprejema` datetime DEFAULT NULL,
  268. `koncano` tinyint(1) NOT NULL DEFAULT '0',
  269. `predviden_cas_dostave` int(11) DEFAULT NULL,
  270. `fk_nacin_placila` int(11) DEFAULT '1',
  271. PRIMARY KEY (`id`),
  272. KEY `fk_uporabnik_id` (`fk_uporabnik_id`),
  273. KEY `fk_lokal_id` (`fk_lokal_id`),
  274. KEY `fk_jedilnik_meni_id` (`fk_jedilnik_meni_id`),
  275. KEY `fk_nacin_placila` (`fk_nacin_placila`)
  276. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  277.  
  278. -- --------------------------------------------------------
  279.  
  280. --
  281. -- Table structure for table `ocena`
  282. --
  283.  
  284. CREATE TABLE IF NOT EXISTS `ocena` (
  285. `id` int(11) NOT NULL AUTO_INCREMENT,
  286. `fk_lokal_id` bigint(11) NOT NULL,
  287. `fk_uporabnik_id` bigint(11) NOT NULL,
  288. `ocena` int(11) NOT NULL,
  289. PRIMARY KEY (`id`),
  290. KEY `fk_uporabnik_id` (`fk_uporabnik_id`),
  291. KEY `fk_lokal_id` (`fk_lokal_id`)
  292. ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=15 ;
  293.  
  294. --
  295. -- Dumping data for table `ocena`
  296. --
  297.  
  298. INSERT INTO `ocena` (`id`, `fk_lokal_id`, `fk_uporabnik_id`, `ocena`) VALUES
  299. (12, 82386710868, 86891762479, 5),
  300. (13, 52927503148, 86891762479, 3),
  301. (14, 82045867280, 86891762479, 5);
  302.  
  303. -- --------------------------------------------------------
  304.  
  305. --
  306. -- Table structure for table `priljubljeno`
  307. --
  308.  
  309. CREATE TABLE IF NOT EXISTS `priljubljeno` (
  310. `id` int(11) NOT NULL AUTO_INCREMENT,
  311. `fk_uporabnik_id` bigint(20) NOT NULL,
  312. `fk_lokal_id` bigint(20) NOT NULL,
  313. PRIMARY KEY (`id`),
  314. KEY `fk_uporabnik_id` (`fk_uporabnik_id`,`fk_lokal_id`),
  315. KEY `fk_lokal_id` (`fk_lokal_id`)
  316. ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=17 ;
  317.  
  318. --
  319. -- Dumping data for table `priljubljeno`
  320. --
  321.  
  322. INSERT INTO `priljubljeno` (`id`, `fk_uporabnik_id`, `fk_lokal_id`) VALUES
  323. (14, 86891762479, 82045867280);
  324.  
  325. -- --------------------------------------------------------
  326.  
  327. --
  328. -- Table structure for table `uporabnik`
  329. --
  330.  
  331. CREATE TABLE IF NOT EXISTS `uporabnik` (
  332. `id` bigint(11) NOT NULL,
  333. `email` varchar(32) NOT NULL,
  334. `ime` varchar(14) CHARACTER SET utf8 COLLATE utf8_slovenian_ci NOT NULL,
  335. `priimek` varchar(20) CHARACTER SET utf8 COLLATE utf8_slovenian_ci NOT NULL,
  336. `telefon` varchar(14) NOT NULL,
  337. `naslov` varchar(40) CHARACTER SET utf8 COLLATE utf8_slovenian_ci NOT NULL,
  338. `kraj` varchar(20) CHARACTER SET utf8 COLLATE utf8_slovenian_ci NOT NULL,
  339. `geslo` text CHARACTER SET utf8 COLLATE utf8_slovenian_ci NOT NULL,
  340. `salt` text NOT NULL,
  341. `ip` varchar(20) NOT NULL,
  342. `datum_registracije` datetime NOT NULL,
  343. `bon` tinyint(1) NOT NULL,
  344. `last_login` datetime NOT NULL,
  345. `narocilo_default_naslov` tinyint(1) NOT NULL DEFAULT '0',
  346. PRIMARY KEY (`id`)
  347. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  348.  
  349. --
  350. -- Dumping data for table `uporabnik`
  351. --
  352.  
  353. INSERT INTO `uporabnik` (`id`, `email`, `ime`, `priimek`, `telefon`, `naslov`, `kraj`, `geslo`, `salt`, `ip`, `datum_registracije`, `bon`, `last_login`, `narocilo_default_naslov`) VALUES
  354. (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),
  355. (86891762479, 'tilen1@gmail.com', 'tilen', 'priimek', '031000000', 'naslov 12', 'maribor', '2bac383336519df7129ca77575dad272bfe86ff8547a6841dc1f8e648086654c', '80509632030640054', '::1', '2016-09-10 14:18:00', 1, '2016-09-21 23:16:00', 0);
  356.  
  357. --
  358. -- Constraints for dumped tables
  359. --
  360.  
  361. --
  362. -- Constraints for table `feedback`
  363. --
  364. ALTER TABLE `feedback`
  365. ADD CONSTRAINT `feedback_ibfk_1` FOREIGN KEY (`fk_uporabnik_id`) REFERENCES `uporabnik` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  366. ADD CONSTRAINT `feedback_ibfk_2` FOREIGN KEY (`fk_lokal_id`) REFERENCES `lokal` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
  367.  
  368. --
  369. -- Constraints for table `jedilnik`
  370. --
  371. ALTER TABLE `jedilnik`
  372. ADD CONSTRAINT `jedilnik_ibfk_1` FOREIGN KEY (`fk_lokal_id`) REFERENCES `lokal` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
  373.  
  374. --
  375. -- Constraints for table `jedilnik_meni`
  376. --
  377. ALTER TABLE `jedilnik_meni`
  378. ADD CONSTRAINT `jedilnik_meni_ibfk_1` FOREIGN KEY (`fk_jedilnik_id`) REFERENCES `jedilnik` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  379. ADD CONSTRAINT `jedilnik_meni_ibfk_2` FOREIGN KEY (`fk_jedilnik_tip`) REFERENCES `jedilnik_tip` (`id`) ON DELETE SET NULL ON UPDATE SET NULL;
  380.  
  381. --
  382. -- Constraints for table `narocilo`
  383. --
  384. ALTER TABLE `narocilo`
  385. ADD CONSTRAINT `narocilo_ibfk_4` FOREIGN KEY (`fk_nacin_placila`) REFERENCES `nacin_placila` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  386. ADD CONSTRAINT `narocilo_ibfk_1` FOREIGN KEY (`fk_lokal_id`) REFERENCES `lokal` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  387. ADD CONSTRAINT `narocilo_ibfk_2` FOREIGN KEY (`fk_uporabnik_id`) REFERENCES `uporabnik` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  388. ADD CONSTRAINT `narocilo_ibfk_3` FOREIGN KEY (`fk_jedilnik_meni_id`) REFERENCES `jedilnik_meni` (`id`) ON DELETE SET NULL ON UPDATE SET NULL;
  389.  
  390. --
  391. -- Constraints for table `ocena`
  392. --
  393. ALTER TABLE `ocena`
  394. ADD CONSTRAINT `ocena_ibfk_1` FOREIGN KEY (`fk_lokal_id`) REFERENCES `lokal` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  395. ADD CONSTRAINT `ocena_ibfk_2` FOREIGN KEY (`fk_uporabnik_id`) REFERENCES `uporabnik` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
  396.  
  397. --
  398. -- Constraints for table `priljubljeno`
  399. --
  400. ALTER TABLE `priljubljeno`
  401. ADD CONSTRAINT `priljubljeno_ibfk_1` FOREIGN KEY (`fk_uporabnik_id`) REFERENCES `uporabnik` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  402. ADD CONSTRAINT `priljubljeno_ibfk_2` FOREIGN KEY (`fk_lokal_id`) REFERENCES `lokal` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
  403.  
  404. /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
  405. /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
  406. /*!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!