Advertisement
Guest User

access

a guest
Nov 19th, 2015
58
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 9.55 KB | None | 0 0
  1. -- phpMyAdmin SQL Dump
  2. -- version 4.5.1
  3. -- http://www.phpmyadmin.net
  4. --
  5. -- Hostiteľ: localhost
  6. -- Čas generovania: Št 19.Nov 2015, 16:35
  7. -- Verzia serveru: 5.5.44-0+deb7u1
  8. -- Verzia PHP: 5.6.7-1
  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 utf8mb4 */;
  18.  
  19. --
  20. -- Databáza: `prestashop`
  21. --
  22.  
  23. -- --------------------------------------------------------
  24.  
  25. --
  26. -- Štruktúra tabuľky pre tabuľku `access`
  27. --
  28.  
  29. CREATE TABLE `access` (
  30.   `id_profile` INT(10) UNSIGNED NOT NULL,
  31.   `id_tab` INT(10) UNSIGNED NOT NULL,
  32.   `view` INT(11) NOT NULL,
  33.   `add` INT(11) NOT NULL,
  34.   `edit` INT(11) NOT NULL,
  35.   `delete` INT(11) NOT NULL
  36. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  37.  
  38. --
  39. -- Sťahujem dáta pre tabuľku `access`
  40. --
  41.  
  42. INSERT INTO `access` (`id_profile`, `id_tab`, `view`, `add`, `edit`, `delete`) VALUES
  43. (1, 0, 1, 1, 1, 1),
  44. (1, 2, 0, 0, 0, 0),
  45. (1, 3, 0, 0, 0, 0),
  46. (1, 4, 0, 0, 0, 0),
  47. (1, 5, 1, 1, 1, 1),
  48. (1, 6, 0, 0, 0, 0),
  49. (1, 7, 1, 1, 1, 1),
  50. (1, 8, 0, 0, 0, 0),
  51. (1, 19, 1, 1, 1, 1),
  52. (1, 20, 1, 1, 1, 1),
  53. (1, 21, 1, 1, 1, 1),
  54. (1, 22, 1, 1, 1, 1),
  55. (1, 23, 1, 1, 1, 1),
  56. (1, 24, 1, 1, 1, 1),
  57. (1, 25, 1, 1, 1, 1),
  58. (1, 26, 1, 1, 1, 1),
  59. (1, 27, 1, 1, 1, 1),
  60. (1, 28, 1, 1, 1, 1),
  61. (1, 29, 1, 1, 1, 1),
  62. (1, 30, 0, 0, 0, 0),
  63. (1, 31, 1, 1, 1, 1),
  64. (1, 32, 1, 1, 1, 1),
  65. (1, 33, 1, 1, 1, 1),
  66. (1, 34, 1, 1, 1, 1),
  67. (1, 35, 1, 1, 1, 1),
  68. (1, 36, 1, 1, 1, 1),
  69. (1, 37, 0, 0, 0, 0),
  70. (1, 38, 1, 1, 1, 1),
  71. (1, 39, 1, 1, 1, 1),
  72. (1, 40, 1, 1, 1, 1),
  73. (1, 41, 1, 1, 1, 1),
  74. (1, 42, 1, 1, 1, 1),
  75. (1, 43, 0, 0, 0, 0),
  76. (1, 44, 1, 1, 1, 1),
  77. (1, 45, 1, 1, 1, 1),
  78. (1, 46, 0, 0, 0, 0),
  79. (1, 47, 0, 0, 0, 0),
  80. (1, 48, 1, 1, 1, 1),
  81. (1, 49, 0, 0, 0, 0),
  82. (1, 50, 1, 1, 1, 1),
  83. (1, 51, 0, 0, 0, 0),
  84. (1, 52, 1, 1, 1, 1),
  85. (1, 53, 1, 1, 1, 1),
  86. (1, 54, 1, 1, 1, 1),
  87. (1, 55, 1, 1, 1, 1),
  88. (1, 56, 1, 1, 1, 1),
  89. (1, 57, 1, 1, 1, 1),
  90. (1, 58, 1, 1, 1, 1),
  91. (1, 59, 1, 1, 1, 1),
  92. (1, 60, 0, 0, 0, 0),
  93. (1, 61, 1, 1, 1, 1),
  94. (1, 62, 1, 1, 1, 1),
  95. (1, 63, 1, 1, 1, 1),
  96. (1, 64, 0, 0, 0, 0),
  97. (1, 65, 0, 0, 0, 0),
  98. (1, 66, 1, 1, 1, 1),
  99. (1, 67, 1, 1, 1, 1),
  100. (1, 68, 1, 1, 1, 1),
  101. (1, 69, 1, 1, 1, 1),
  102. (1, 70, 1, 1, 1, 1),
  103. (1, 71, 1, 1, 1, 1),
  104. (1, 72, 0, 0, 0, 0),
  105. (1, 73, 1, 1, 1, 1),
  106. (1, 74, 1, 1, 1, 1),
  107. (1, 75, 1, 1, 1, 1),
  108. (1, 76, 1, 1, 1, 1),
  109. (1, 77, 1, 1, 1, 1),
  110. (1, 78, 1, 1, 1, 1),
  111. (1, 79, 0, 0, 0, 0),
  112. (1, 80, 1, 1, 1, 1),
  113. (1, 81, 1, 1, 1, 1),
  114. (1, 82, 1, 1, 1, 1),
  115. (1, 83, 1, 1, 1, 1),
  116. (1, 84, 1, 1, 1, 1),
  117. (1, 85, 0, 0, 0, 0),
  118. (1, 86, 1, 1, 1, 1),
  119. (1, 87, 1, 1, 1, 1),
  120. (1, 88, 1, 1, 1, 1),
  121. (1, 89, 1, 1, 1, 1),
  122. (1, 90, 0, 0, 0, 0),
  123. (1, 91, 0, 0, 0, 0),
  124. (1, 92, 1, 1, 1, 1),
  125. (1, 93, 1, 1, 1, 1),
  126. (1, 94, 1, 1, 1, 1),
  127. (1, 95, 1, 1, 1, 1),
  128. (1, 96, 1, 1, 1, 1),
  129. (1, 97, 0, 0, 0, 0),
  130. (1, 98, 0, 0, 0, 0),
  131. (1, 99, 1, 1, 1, 1),
  132. (1, 100, 1, 1, 1, 1),
  133. (1, 101, 1, 1, 1, 1),
  134. (1, 102, 1, 1, 1, 1),
  135. (1, 103, 1, 1, 1, 1),
  136. (1, 104, 1, 1, 1, 1),
  137. (1, 105, 1, 1, 1, 1),
  138. (2, 0, 1, 1, 1, 1),
  139. (2, 2, 0, 0, 0, 0),
  140. (2, 3, 0, 0, 0, 0),
  141. (2, 4, 0, 0, 0, 0),
  142. (2, 5, 0, 0, 0, 0),
  143. (2, 6, 0, 0, 0, 0),
  144. (2, 7, 0, 0, 0, 0),
  145. (2, 8, 0, 0, 0, 0),
  146. (2, 19, 0, 0, 0, 0),
  147. (2, 20, 1, 1, 1, 1),
  148. (2, 21, 1, 1, 1, 1),
  149. (2, 22, 1, 1, 1, 1),
  150. (2, 23, 1, 1, 1, 1),
  151. (2, 24, 0, 0, 0, 0),
  152. (2, 25, 0, 0, 0, 0),
  153. (2, 26, 0, 0, 0, 0),
  154. (2, 27, 1, 1, 1, 1),
  155. (2, 28, 0, 0, 0, 0),
  156. (2, 29, 0, 0, 0, 0),
  157. (2, 30, 1, 1, 1, 1),
  158. (2, 31, 1, 1, 1, 1),
  159. (2, 32, 1, 1, 1, 1),
  160. (2, 33, 1, 1, 1, 1),
  161. (2, 34, 1, 1, 1, 1),
  162. (2, 35, 1, 1, 1, 1),
  163. (2, 36, 0, 0, 0, 0),
  164. (2, 37, 1, 1, 1, 1),
  165. (2, 38, 1, 1, 1, 1),
  166. (2, 39, 0, 0, 0, 0),
  167. (2, 40, 0, 0, 0, 0),
  168. (2, 41, 0, 0, 0, 0),
  169. (2, 42, 0, 0, 0, 0),
  170. (2, 43, 0, 0, 0, 0),
  171. (2, 44, 0, 0, 0, 0),
  172. (2, 45, 0, 0, 0, 0),
  173. (2, 46, 0, 0, 0, 0),
  174. (2, 47, 0, 0, 0, 0),
  175. (2, 48, 1, 1, 1, 1),
  176. (2, 49, 1, 1, 1, 1),
  177. (2, 50, 0, 0, 0, 0),
  178. (2, 51, 0, 0, 0, 0),
  179. (2, 52, 0, 0, 0, 0),
  180. (2, 53, 0, 0, 0, 0),
  181. (2, 54, 0, 0, 0, 0),
  182. (2, 55, 0, 0, 0, 0),
  183. (2, 56, 0, 0, 0, 0),
  184. (2, 57, 0, 0, 0, 0),
  185. (2, 58, 0, 0, 0, 0),
  186. (2, 59, 0, 0, 0, 0),
  187. (2, 60, 1, 0, 1, 0),
  188. (2, 61, 0, 0, 0, 0),
  189. (2, 62, 0, 0, 0, 0),
  190. (2, 63, 0, 0, 0, 0),
  191. (2, 64, 0, 0, 0, 0),
  192. (2, 65, 0, 0, 0, 0),
  193. (2, 66, 0, 0, 0, 0),
  194. (2, 67, 0, 0, 0, 0),
  195. (2, 68, 0, 0, 0, 0),
  196. (2, 69, 0, 0, 0, 0),
  197. (2, 70, 0, 0, 0, 0),
  198. (2, 71, 0, 0, 0, 0),
  199. (2, 72, 0, 0, 0, 0),
  200. (2, 73, 0, 0, 0, 0),
  201. (2, 74, 0, 0, 0, 0),
  202. (2, 75, 0, 0, 0, 0),
  203. (2, 76, 0, 0, 0, 0),
  204. (2, 77, 0, 0, 0, 0),
  205. (2, 78, 0, 0, 0, 0),
  206. (2, 79, 0, 0, 0, 0),
  207. (2, 80, 0, 0, 0, 0),
  208. (2, 81, 0, 0, 0, 0),
  209. (2, 82, 0, 0, 0, 0),
  210. (2, 83, 0, 0, 0, 0),
  211. (2, 84, 0, 0, 0, 0),
  212. (2, 85, 0, 0, 0, 0),
  213. (2, 86, 0, 0, 0, 0),
  214. (2, 87, 0, 0, 0, 0),
  215. (2, 88, 0, 0, 0, 0),
  216. (2, 89, 0, 0, 0, 0),
  217. (2, 90, 0, 0, 0, 0),
  218. (2, 91, 0, 0, 0, 0),
  219. (2, 92, 0, 0, 0, 0),
  220. (2, 93, 0, 0, 0, 0),
  221. (2, 94, 1, 1, 1, 1),
  222. (2, 95, 1, 1, 1, 1),
  223. (2, 96, 1, 1, 1, 1),
  224. (2, 97, 0, 0, 0, 0),
  225. (2, 98, 0, 0, 0, 0),
  226. (2, 99, 1, 1, 1, 1),
  227. (2, 100, 1, 1, 1, 1),
  228. (2, 101, 0, 0, 0, 0),
  229. (2, 102, 0, 0, 0, 0),
  230. (2, 103, 0, 0, 0, 0),
  231. (2, 104, 0, 0, 0, 0),
  232. (2, 105, 0, 0, 0, 0),
  233. (3, 0, 1, 1, 1, 1),
  234. (3, 2, 0, 0, 0, 0),
  235. (3, 3, 0, 0, 0, 0),
  236. (3, 4, 0, 0, 0, 0),
  237. (3, 5, 1, 0, 0, 0),
  238. (3, 6, 0, 0, 0, 0),
  239. (3, 7, 0, 0, 0, 0),
  240. (3, 8, 0, 0, 0, 0),
  241. (3, 19, 0, 0, 0, 0),
  242. (3, 20, 0, 0, 0, 0),
  243. (3, 21, 1, 1, 1, 1),
  244. (3, 22, 1, 1, 1, 1),
  245. (3, 23, 0, 0, 0, 0),
  246. (3, 24, 0, 0, 0, 0),
  247. (3, 25, 0, 0, 0, 0),
  248. (3, 26, 0, 0, 0, 0),
  249. (3, 27, 0, 0, 0, 0),
  250. (3, 28, 0, 0, 0, 0),
  251. (3, 29, 0, 0, 0, 0),
  252. (3, 30, 0, 0, 0, 0),
  253. (3, 31, 0, 0, 0, 0),
  254. (3, 32, 0, 0, 0, 0),
  255. (3, 33, 0, 0, 0, 0),
  256. (3, 34, 0, 0, 0, 0),
  257. (3, 35, 0, 0, 0, 0),
  258. (3, 36, 0, 0, 0, 0),
  259. (3, 37, 0, 0, 0, 0),
  260. (3, 38, 0, 0, 0, 0),
  261. (3, 39, 0, 0, 0, 0),
  262. (3, 40, 0, 0, 0, 0),
  263. (3, 41, 0, 0, 0, 0),
  264. (3, 42, 0, 0, 0, 0),
  265. (3, 43, 0, 0, 0, 0),
  266. (3, 44, 0, 0, 0, 0),
  267. (3, 45, 0, 0, 0, 0),
  268. (3, 46, 0, 0, 0, 0),
  269. (3, 47, 0, 0, 0, 0),
  270. (3, 48, 0, 0, 0, 0),
  271. (3, 49, 0, 0, 0, 0),
  272. (3, 50, 0, 0, 0, 0),
  273. (3, 51, 0, 0, 0, 0),
  274. (3, 52, 0, 0, 0, 0),
  275. (3, 53, 0, 0, 0, 0),
  276. (3, 54, 0, 0, 0, 0),
  277. (3, 55, 0, 0, 0, 0),
  278. (3, 56, 0, 0, 0, 0),
  279. (3, 57, 0, 0, 0, 0),
  280. (3, 58, 0, 0, 0, 0),
  281. (3, 59, 1, 1, 1, 1),
  282. (3, 60, 0, 0, 0, 0),
  283. (3, 61, 0, 0, 0, 0),
  284. (3, 62, 0, 0, 0, 0),
  285. (3, 63, 0, 0, 0, 0),
  286. (3, 64, 0, 0, 0, 0),
  287. (3, 65, 0, 0, 0, 0),
  288. (3, 66, 0, 0, 0, 0),
  289. (3, 67, 0, 0, 0, 0),
  290. (3, 68, 0, 0, 0, 0),
  291. (3, 69, 0, 0, 0, 0),
  292. (3, 70, 1, 1, 1, 1),
  293. (3, 71, 0, 0, 0, 0),
  294. (3, 72, 0, 0, 0, 0),
  295. (3, 73, 0, 0, 0, 0),
  296. (3, 74, 0, 0, 0, 0),
  297. (3, 75, 0, 0, 0, 0),
  298. (3, 76, 0, 0, 0, 0),
  299. (3, 77, 0, 0, 0, 0),
  300. (3, 78, 0, 0, 0, 0),
  301. (3, 79, 0, 0, 0, 0),
  302. (3, 80, 0, 0, 0, 0),
  303. (3, 81, 0, 0, 0, 0),
  304. (3, 82, 0, 0, 0, 0),
  305. (3, 83, 0, 0, 0, 0),
  306. (3, 84, 0, 0, 0, 0),
  307. (3, 85, 0, 0, 0, 0),
  308. (3, 86, 0, 0, 0, 0),
  309. (3, 87, 0, 0, 0, 0),
  310. (3, 88, 0, 0, 0, 0),
  311. (3, 89, 0, 0, 0, 0),
  312. (3, 90, 0, 0, 0, 0),
  313. (3, 91, 0, 0, 0, 0),
  314. (3, 92, 0, 0, 0, 0),
  315. (3, 93, 0, 0, 0, 0),
  316. (3, 94, 0, 0, 0, 0),
  317. (3, 95, 0, 0, 0, 0),
  318. (3, 96, 0, 0, 0, 0),
  319. (3, 97, 0, 0, 0, 0),
  320. (3, 98, 0, 0, 0, 0),
  321. (3, 99, 0, 0, 0, 0),
  322. (3, 100, 0, 0, 0, 0),
  323. (3, 101, 0, 0, 0, 0),
  324. (3, 102, 0, 0, 0, 0),
  325. (3, 103, 0, 0, 0, 0),
  326. (3, 104, 0, 0, 0, 0),
  327. (3, 105, 0, 0, 0, 0),
  328. (4, 0, 1, 1, 1, 1),
  329. (4, 2, 0, 0, 0, 0),
  330. (4, 3, 0, 0, 0, 0),
  331. (4, 4, 0, 0, 0, 0),
  332. (4, 5, 1, 0, 0, 0),
  333. (4, 6, 0, 0, 0, 0),
  334. (4, 7, 0, 0, 0, 0),
  335. (4, 8, 0, 0, 0, 0),
  336. (4, 19, 1, 1, 1, 1),
  337. (4, 20, 1, 0, 0, 0),
  338. (4, 21, 1, 1, 1, 1),
  339. (4, 22, 1, 1, 1, 1),
  340. (4, 23, 0, 0, 0, 0),
  341. (4, 24, 0, 0, 0, 0),
  342. (4, 25, 0, 0, 0, 0),
  343. (4, 26, 1, 0, 0, 0),
  344. (4, 27, 0, 0, 0, 0),
  345. (4, 28, 0, 0, 0, 0),
  346. (4, 29, 0, 0, 0, 0),
  347. (4, 30, 1, 1, 1, 1),
  348. (4, 31, 1, 1, 1, 1),
  349. (4, 32, 0, 0, 0, 0),
  350. (4, 33, 0, 0, 0, 0),
  351. (4, 34, 1, 1, 1, 1),
  352. (4, 35, 0, 0, 0, 0),
  353. (4, 36, 1, 1, 1, 1),
  354. (4, 37, 1, 1, 1, 1),
  355. (4, 38, 1, 1, 1, 1),
  356. (4, 39, 1, 1, 1, 1),
  357. (4, 40, 1, 1, 1, 1),
  358. (4, 41, 0, 0, 0, 0),
  359. (4, 42, 0, 0, 0, 0),
  360. (4, 43, 0, 0, 0, 0),
  361. (4, 44, 0, 0, 0, 0),
  362. (4, 45, 0, 0, 0, 0),
  363. (4, 46, 0, 0, 0, 0),
  364. (4, 47, 0, 0, 0, 0),
  365. (4, 48, 0, 0, 0, 0),
  366. (4, 49, 0, 0, 0, 0),
  367. (4, 50, 0, 0, 0, 0),
  368. (4, 51, 0, 0, 0, 0),
  369. (4, 52, 0, 0, 0, 0),
  370. (4, 53, 0, 0, 0, 0),
  371. (4, 54, 0, 0, 0, 0),
  372. (4, 55, 0, 0, 0, 0),
  373. (4, 56, 0, 0, 0, 0),
  374. (4, 57, 0, 0, 0, 0),
  375. (4, 58, 0, 0, 0, 0),
  376. (4, 59, 0, 0, 0, 0),
  377. (4, 60, 1, 0, 1, 0),
  378. (4, 61, 0, 0, 0, 0),
  379. (4, 62, 0, 0, 0, 0),
  380. (4, 63, 0, 0, 0, 0),
  381. (4, 64, 0, 0, 0, 0),
  382. (4, 65, 0, 0, 0, 0),
  383. (4, 66, 0, 0, 0, 0),
  384. (4, 67, 0, 0, 0, 0),
  385. (4, 68, 0, 0, 0, 0),
  386. (4, 69, 0, 0, 0, 0),
  387. (4, 70, 0, 0, 0, 0),
  388. (4, 71, 0, 0, 0, 0),
  389. (4, 72, 0, 0, 0, 0),
  390. (4, 73, 0, 0, 0, 0),
  391. (4, 74, 0, 0, 0, 0),
  392. (4, 75, 0, 0, 0, 0),
  393. (4, 76, 0, 0, 0, 0),
  394. (4, 77, 0, 0, 0, 0),
  395. (4, 78, 0, 0, 0, 0),
  396. (4, 79, 0, 0, 0, 0),
  397. (4, 80, 0, 0, 0, 0),
  398. (4, 81, 0, 0, 0, 0),
  399. (4, 82, 0, 0, 0, 0),
  400. (4, 83, 0, 0, 0, 0),
  401. (4, 84, 1, 1, 1, 1),
  402. (4, 85, 0, 0, 0, 0),
  403. (4, 86, 0, 0, 0, 0),
  404. (4, 87, 0, 0, 0, 0),
  405. (4, 88, 0, 0, 0, 0),
  406. (4, 89, 0, 0, 0, 0),
  407. (4, 90, 0, 0, 0, 0),
  408. (4, 91, 1, 1, 1, 1),
  409. (4, 92, 0, 0, 0, 0),
  410. (4, 93, 1, 1, 1, 1),
  411. (4, 94, 0, 0, 0, 0),
  412. (4, 95, 0, 0, 0, 0),
  413. (4, 96, 0, 0, 0, 0),
  414. (4, 97, 0, 0, 0, 0),
  415. (4, 98, 0, 0, 0, 0),
  416. (4, 99, 1, 0, 0, 0),
  417. (4, 100, 0, 0, 0, 0),
  418. (4, 101, 0, 0, 0, 0),
  419. (4, 102, 0, 0, 0, 0),
  420. (4, 103, 0, 0, 0, 0),
  421. (4, 104, 0, 0, 0, 0),
  422. (4, 105, 0, 0, 0, 0);
  423.  
  424. --
  425. -- Kľúče pre exportované tabuľky
  426. --
  427.  
  428. --
  429. -- Indexy pre tabuľku `access`
  430. --
  431. ALTER TABLE `access`
  432.   ADD PRIMARY KEY (`id_profile`,`id_tab`);
  433.  
  434. /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
  435. /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
  436. /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement