API tools faq
paste
Advertisement
Guest User

DB dump 2

a guest
Oct 12th, 2014
70
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 18.63 KB | None | 0 0
raw download clone embed print report
  1. -- phpMyAdmin SQL Dump
  2. -- version 4.0.10deb1
  3. -- http://www.phpmyadmin.net
  4. --
  5. -- Hostiteľ: localhost
  6. -- Vygenerované: So 11.Okt 2014, 21:43
  7. -- Verzia serveru: 5.5.38-0ubuntu0.14.04.1
  8. -- Verzia PHP: 5.5.9-1ubuntu4.4
  9.  
  10. SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
  11. SET time_zone = "+00:00";
  12.  
  13. --
  14. -- Databáza: `pce`
  15. --
  16.  
  17. -- --------------------------------------------------------
  18.  
  19. --
  20. -- Štruktúra tabuľky pre tabuľku `users`
  21. --
  22.  
  23. CREATE TABLE IF NOT EXISTS `users` (
  24.   `id` INT(11) NOT NULL AUTO_INCREMENT,
  25.   `username` VARCHAR(50) NOT NULL,
  26.   `password` VARCHAR(255) NOT NULL,
  27.   `group_id` INT(11) NOT NULL DEFAULT '1',
  28.   `email` VARCHAR(255) NOT NULL,
  29.   `last_login` VARCHAR(25) NOT NULL,
  30.   `previous_login` VARCHAR(25) NOT NULL DEFAULT '0',
  31.   `login_hash` VARCHAR(255) NOT NULL,
  32.   `user_id` INT(11) NOT NULL DEFAULT '0',
  33.   `created_at` INT(11) NOT NULL DEFAULT '0',
  34.   `updated_at` INT(11) NOT NULL DEFAULT '0',
  35.   PRIMARY KEY (`id`),
  36.   UNIQUE KEY `username` (`username`,`email`)
  37. ) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=26 ;
  38.  
  39. --
  40. -- Sťahujem dáta pre tabuľku `users`
  41. --
  42.  
  43. INSERT INTO `users` (`id`, `username`, `password`, `group_id`, `email`, `last_login`, `previous_login`, `login_hash`, `user_id`, `created_at`, `updated_at`) VALUES
  44. (2, 'sveatlo', 'FGTCGFUBeyQMQGH/p/1dHWC6NZnsirhoY+TjWs3ZrwM=', 5, 'svatoplukhanzel@gmail.com', '1413040832', '1413007042', '97770bd1b53506acd7d6fd139ccbe1977674ba35', 2, 1411296942, 1413040832),
  45. (3, 'tito', 'FGTCGFUBeyQMQGH/p/1dHWC6NZnsirhoY+TjWs3ZrwM=', 5, 'tomas.tima@pcexpres.sk', '1412687476', '1412618610', '4fc6b37ea43ceb6b2e37987e404bf306dafd4a8e', 3, 1412616822, 1412687476),
  46. (4, 'filip.vilem@pcexpres.sk', 'VuVOGJUg2WS5VKTpgv2QK28qugq0Iz3Ndx9BhJnP9rE=', 3, 'filip.vilem@pcexpres.sk', '1412878235', '1412877560', '848ab0fb64b8932bfa81ed0627ad622724613645', 4, 1412859025, 1412878235),
  47. (5, 'michal.koperniech@pcexpres.sk', 'VuVOGJUg2WS5VKTpgv2QK28qugq0Iz3Ndx9BhJnP9rE=', 3, 'michal.koperniech@pcexpres.sk', '1412941295', '0', 'dd27163059014072859d8c4a72493ea89c826f41', 5, 1412859025, 1412941295),
  48. (6, 'peter.batora@pcexpres.sk', 'VuVOGJUg2WS5VKTpgv2QK28qugq0Iz3Ndx9BhJnP9rE=', 3, 'peter.batora@pcexpres.sk', '0', '0', '', 0, 1412859025, 0),
  49. (7, 'andrej.bacik@pcexpres.sk', 'VuVOGJUg2WS5VKTpgv2QK28qugq0Iz3Ndx9BhJnP9rE=', 3, 'andrej.bacik@pcexpres.sk', '0', '0', '', 0, 1412859025, 0),
  50. (8, 'marek.duracka@pcexpres.sk', 'VuVOGJUg2WS5VKTpgv2QK28qugq0Iz3Ndx9BhJnP9rE=', 3, 'marek.duracka@pcexpres.sk', '0', '0', '', 0, 1412859025, 0),
  51. (9, 'stefan.luptak@pcexpres.sk', 'VuVOGJUg2WS5VKTpgv2QK28qugq0Iz3Ndx9BhJnP9rE=', 3, 'stefan.luptak@pcexpres.sk', '0', '0', '', 0, 1412859025, 0),
  52. (10, 'viktor.novovesky@pcexpres.sk', 'VuVOGJUg2WS5VKTpgv2QK28qugq0Iz3Ndx9BhJnP9rE=', 3, 'viktor.novovesky@pcexpres.sk', '0', '0', '', 0, 1412859025, 0),
  53. (11, 'jakub.zakutansky@pcexpres.sk', 'VuVOGJUg2WS5VKTpgv2QK28qugq0Iz3Ndx9BhJnP9rE=', 3, 'jakub.zakutansky@pcexpres.sk', '0', '0', '', 0, 1412859025, 0),
  54. (12, 'jakub.svancar@pcexpres.sk', 'VuVOGJUg2WS5VKTpgv2QK28qugq0Iz3Ndx9BhJnP9rE=', 3, 'jakub.svancar@pcexpres.sk', '0', '0', '', 0, 1412859025, 0),
  55. (13, 'gabriel.gaal@pcexpres.sk', 'VuVOGJUg2WS5VKTpgv2QK28qugq0Iz3Ndx9BhJnP9rE=', 3, 'gabriel.gaal@pcexpres.sk', '0', '0', '', 0, 1412859025, 0),
  56. (14, 'tomas.rosol@pcexpres.sk', 'VuVOGJUg2WS5VKTpgv2QK28qugq0Iz3Ndx9BhJnP9rE=', 3, 'tomas.rosol@pcexpres.sk', '0', '0', '', 0, 1412859025, 0),
  57. (15, 'jan.hrbca@pcexpres.sk', 'VuVOGJUg2WS5VKTpgv2QK28qugq0Iz3Ndx9BhJnP9rE=', 3, 'jan.hrbca@pcexpres.sk', '0', '0', '', 0, 1412859025, 0),
  58. (16, 'marek.mikulec@pcexpres.sk', 'VuVOGJUg2WS5VKTpgv2QK28qugq0Iz3Ndx9BhJnP9rE=', 3, 'marek.mikulec@pcexpres.sk', '0', '0', '', 0, 1412859025, 0),
  59. (17, 'marian.bernath@pcexpres.sk', 'VuVOGJUg2WS5VKTpgv2QK28qugq0Iz3Ndx9BhJnP9rE=', 3, 'marian.bernath@pcexpres.sk', '0', '0', '', 0, 1412859025, 0),
  60. (18, 'michal.spuchlak@pcexpres.sk', 'VuVOGJUg2WS5VKTpgv2QK28qugq0Iz3Ndx9BhJnP9rE=', 3, 'michal.spuchlak@pcexpres.sk', '0', '0', '', 0, 1412859026, 0),
  61. (19, 'miroslav.kovac@pcexpres.sk', 'VuVOGJUg2WS5VKTpgv2QK28qugq0Iz3Ndx9BhJnP9rE=', 3, 'miroslav.kovac@pcexpres.sk', '0', '0', '', 0, 1412859026, 0),
  62. (20, 'krystian.makara@pcexpres.sk', 'VuVOGJUg2WS5VKTpgv2QK28qugq0Iz3Ndx9BhJnP9rE=', 3, 'krystian.makara@pcexpres.sk', '0', '0', '', 0, 1412859026, 0),
  63. (21, 'martin.lazorik@pcexpres.sk', 'VuVOGJUg2WS5VKTpgv2QK28qugq0Iz3Ndx9BhJnP9rE=', 3, 'martin.lazorik@pcexpres.sk', '0', '0', '', 0, 1412859026, 0),
  64. (22, 'jozef.adamisin@pcexpres.sk', 'VuVOGJUg2WS5VKTpgv2QK28qugq0Iz3Ndx9BhJnP9rE=', 4, 'jozef.adamisin@pcexpres.sk', '0', '0', '', 0, 1412877765, 0),
  65. (23, 'stefan.migas@pcexpres.sk', 'VuVOGJUg2WS5VKTpgv2QK28qugq0Iz3Ndx9BhJnP9rE=', 4, 'stefan.migas@pcexpres.sk', '0', '0', '', 0, 1412877765, 0),
  66. (24, 'michaela.frohlichova@pcexpres.sk', 'VuVOGJUg2WS5VKTpgv2QK28qugq0Iz3Ndx9BhJnP9rE=', 4, 'michaela.frohlichova@pcexpres.sk', '0', '0', '', 0, 1412877765, 0),
  67. (25, 'jan.ivanic@pcexpres.sk', 'VuVOGJUg2WS5VKTpgv2QK28qugq0Iz3Ndx9BhJnP9rE=', 5, 'jan.ivanic@pcexpres.sk', '0', '0', '', 0, 1412877799, 0);
  68.  
  69. -- --------------------------------------------------------
  70.  
  71. --
  72. -- Štruktúra tabuľky pre tabuľku `users_clients`
  73. --
  74.  
  75. CREATE TABLE IF NOT EXISTS `users_clients` (
  76.   `id` INT(11) NOT NULL AUTO_INCREMENT,
  77.   `name` VARCHAR(32) NOT NULL DEFAULT '',
  78.   `client_id` VARCHAR(32) NOT NULL DEFAULT '',
  79.   `client_secret` VARCHAR(32) NOT NULL DEFAULT '',
  80.   `redirect_uri` VARCHAR(255) NOT NULL DEFAULT '',
  81.   `auto_approve` tinyint(1) NOT NULL DEFAULT '0',
  82.   `autonomous` tinyint(1) NOT NULL DEFAULT '0',
  83.   `status` enum('development','pending','approved','rejected') NOT NULL DEFAULT 'development',
  84.   `suspended` tinyint(1) NOT NULL DEFAULT '0',
  85.   `notes` tinytext NOT NULL,
  86.   PRIMARY KEY (`id`),
  87.   UNIQUE KEY `client_id` (`client_id`)
  88. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
  89.  
  90. -- --------------------------------------------------------
  91.  
  92. --
  93. -- Štruktúra tabuľky pre tabuľku `users_groups`
  94. --
  95.  
  96. CREATE TABLE IF NOT EXISTS `users_groups` (
  97.   `id` INT(11) NOT NULL AUTO_INCREMENT,
  98.   `name` VARCHAR(255) NOT NULL,
  99.   `user_id` INT(11) NOT NULL DEFAULT '0',
  100.   `created_at` INT(11) NOT NULL DEFAULT '0',
  101.   `updated_at` INT(11) NOT NULL DEFAULT '0',
  102.   PRIMARY KEY (`id`)
  103. ) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=6 ;
  104.  
  105. --
  106. -- Sťahujem dáta pre tabuľku `users_groups`
  107. --
  108.  
  109. INSERT INTO `users_groups` (`id`, `name`, `user_id`, `created_at`, `updated_at`) VALUES
  110. (1, 'Banned', 0, 0, 0),
  111. (2, 'Customers', 0, 0, 0),
  112. (3, 'Technicians', 0, 0, 0),
  113. (4, 'Administrators', 0, 0, 0),
  114. (5, 'Super admins', 0, 0, 0);
  115.  
  116. -- --------------------------------------------------------
  117.  
  118. --
  119. -- Štruktúra tabuľky pre tabuľku `users_group_permissions`
  120. --
  121.  
  122. CREATE TABLE IF NOT EXISTS `users_group_permissions` (
  123.   `id` INT(11) NOT NULL AUTO_INCREMENT,
  124.   `group_id` INT(11) NOT NULL,
  125.   `perms_id` INT(11) NOT NULL,
  126.   `actions` text,
  127.   PRIMARY KEY (`id`)
  128. ) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;
  129.  
  130. --
  131. -- Sťahujem dáta pre tabuľku `users_group_permissions`
  132. --
  133.  
  134. INSERT INTO `users_group_permissions` (`id`, `group_id`, `perms_id`, `actions`) VALUES
  135. (1, 3, 1, 'a:3:{i:0;i:0;i:1;i:2;i:2;i:4;}'),
  136. (2, 5, 1, 'a:5:{i:0;i:0;i:1;i:1;i:2;i:2;i:3;i:3;i:4;i:4;}');
  137.  
  138. -- --------------------------------------------------------
  139.  
  140. --
  141. -- Štruktúra tabuľky pre tabuľku `users_group_roles`
  142. --
  143.  
  144. CREATE TABLE IF NOT EXISTS `users_group_roles` (
  145.   `group_id` INT(11) NOT NULL,
  146.   `role_id` INT(11) NOT NULL,
  147.   PRIMARY KEY (`group_id`,`role_id`)
  148. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  149.  
  150. --
  151. -- Sťahujem dáta pre tabuľku `users_group_roles`
  152. --
  153.  
  154. INSERT INTO `users_group_roles` (`group_id`, `role_id`) VALUES
  155. (1, 1),
  156. (2, 2),
  157. (3, 3),
  158. (4, 3),
  159. (4, 4),
  160. (5, 3),
  161. (5, 4),
  162. (5, 5);
  163.  
  164. -- --------------------------------------------------------
  165.  
  166. --
  167. -- Štruktúra tabuľky pre tabuľku `users_metadata`
  168. --
  169.  
  170. CREATE TABLE IF NOT EXISTS `users_metadata` (
  171.   `id` INT(11) NOT NULL AUTO_INCREMENT,
  172.   `parent_id` INT(11) NOT NULL DEFAULT '0',
  173.   `key` VARCHAR(20) NOT NULL,
  174.   `value` VARCHAR(100) NOT NULL,
  175.   `user_id` INT(11) NOT NULL DEFAULT '0',
  176.   `created_at` INT(11) NOT NULL DEFAULT '0',
  177.   `updated_at` INT(11) NOT NULL DEFAULT '0',
  178.   PRIMARY KEY (`id`)
  179. ) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=56 ;
  180.  
  181. --
  182. -- Sťahujem dáta pre tabuľku `users_metadata`
  183. --
  184.  
  185. INSERT INTO `users_metadata` (`id`, `parent_id`, `key`, `value`, `user_id`, `created_at`, `updated_at`) VALUES
  186. (2, 0, 'fullname', 'Guest', 0, 0, 0),
  187. (3, 2, 'fullname', 'Svatopluk Hanzel', 0, 1411297849, 0),
  188. (5, 2, 'branches', 'a:8:{i:0;i:8;i:1;i:7;i:2;i:6;i:3;i:5;i:4;i:4;i:5;i:3;i:6;i:2;i:7;i:1;}', 2, 1411297849, 1412870150),
  189. (6, 3, 'fullname', 'Tomas Tima', 0, 1412618944, 0),
  190. (7, 3, 'branches', 'a:8:{i:0;i:1;i:1;i:2;i:2;i:3;i:3;i:4;i:4;i:5;i:5;i:6;i:6;i:7;i:7;i:8;}', 0, 1412618944, 0),
  191. (8, 4, 'fullname', 'Filip Vilem', 0, 1412858696, 0),
  192. (9, 4, 'branches', 'a:8:{i:0;i:1;i:1;i:2;i:2;i:3;i:3;i:4;i:4;i:5;i:5;i:6;i:6;i:7;i:7;i:8;}', 0, 1412858696, 0),
  193. (10, 4, 'fullname', 'Filip Vilem', 0, 1412858929, 0),
  194. (11, 4, 'branches', 'a:8:{i:0;i:1;i:1;i:2;i:2;i:3;i:3;i:4;i:4;i:5;i:5;i:6;i:6;i:7;i:7;i:8;}', 0, 1412858929, 0),
  195. (12, 4, 'fullname', 'Filip Vilem', 0, 1412859025, 0),
  196. (13, 4, 'branches', 'a:8:{i:0;i:1;i:1;i:2;i:2;i:3;i:3;i:4;i:4;i:5;i:5;i:6;i:6;i:7;i:7;i:8;}', 0, 1412859025, 0),
  197. (14, 5, 'fullname', 'Michal Koperniech', 0, 1412859025, 0),
  198. (15, 5, 'branches', 'a:8:{i:0;i:1;i:1;i:2;i:2;i:3;i:3;i:4;i:4;i:5;i:5;i:6;i:6;i:7;i:7;i:8;}', 0, 1412859025, 0),
  199. (16, 6, 'fullname', 'Peter Batora', 0, 1412859025, 0),
  200. (17, 6, 'branches', 'a:8:{i:0;i:1;i:1;i:2;i:2;i:3;i:3;i:4;i:4;i:5;i:5;i:6;i:6;i:7;i:7;i:8;}', 0, 1412859025, 0),
  201. (18, 7, 'fullname', 'Andrej Bacik', 0, 1412859025, 0),
  202. (19, 7, 'branches', 'a:8:{i:0;i:1;i:1;i:2;i:2;i:3;i:3;i:4;i:4;i:5;i:5;i:6;i:6;i:7;i:7;i:8;}', 0, 1412859025, 0),
  203. (20, 8, 'fullname', 'Marek Duracka', 0, 1412859025, 0),
  204. (21, 8, 'branches', 'a:8:{i:0;i:1;i:1;i:2;i:2;i:3;i:3;i:4;i:4;i:5;i:5;i:6;i:6;i:7;i:7;i:8;}', 0, 1412859025, 0),
  205. (22, 9, 'fullname', 'Stefan Luptak', 0, 1412859025, 0),
  206. (23, 9, 'branches', 'a:8:{i:0;i:1;i:1;i:2;i:2;i:3;i:3;i:4;i:4;i:5;i:5;i:6;i:6;i:7;i:7;i:8;}', 0, 1412859025, 0),
  207. (24, 10, 'fullname', 'Viktor Novovesky', 0, 1412859025, 0),
  208. (25, 10, 'branches', 'a:8:{i:0;i:1;i:1;i:2;i:2;i:3;i:3;i:4;i:4;i:5;i:5;i:6;i:6;i:7;i:7;i:8;}', 0, 1412859025, 0),
  209. (26, 11, 'fullname', 'Jakub Zakutansky', 0, 1412859025, 0),
  210. (27, 11, 'branches', 'a:8:{i:0;i:1;i:1;i:2;i:2;i:3;i:3;i:4;i:4;i:5;i:5;i:6;i:6;i:7;i:7;i:8;}', 0, 1412859025, 0),
  211. (28, 12, 'fullname', 'Jakub Svancar', 0, 1412859025, 0),
  212. (29, 12, 'branches', 'a:8:{i:0;i:1;i:1;i:2;i:2;i:3;i:3;i:4;i:4;i:5;i:5;i:6;i:6;i:7;i:7;i:8;}', 0, 1412859025, 0),
  213. (30, 13, 'fullname', 'Gabriel Gaal', 0, 1412859025, 0),
  214. (31, 13, 'branches', 'a:8:{i:0;i:1;i:1;i:2;i:2;i:3;i:3;i:4;i:4;i:5;i:5;i:6;i:6;i:7;i:7;i:8;}', 0, 1412859025, 0),
  215. (32, 14, 'fullname', 'Tomas Rosol', 0, 1412859025, 0),
  216. (33, 14, 'branches', 'a:8:{i:0;i:1;i:1;i:2;i:2;i:3;i:3;i:4;i:4;i:5;i:5;i:6;i:6;i:7;i:7;i:8;}', 0, 1412859025, 0),
  217. (34, 15, 'fullname', 'Jan Hrbca', 0, 1412859025, 0),
  218. (35, 15, 'branches', 'a:8:{i:0;i:1;i:1;i:2;i:2;i:3;i:3;i:4;i:4;i:5;i:5;i:6;i:6;i:7;i:7;i:8;}', 0, 1412859025, 0),
  219. (36, 16, 'fullname', 'Marek Mikulec', 0, 1412859025, 0),
  220. (37, 16, 'branches', 'a:8:{i:0;i:1;i:1;i:2;i:2;i:3;i:3;i:4;i:4;i:5;i:5;i:6;i:6;i:7;i:7;i:8;}', 0, 1412859025, 0),
  221. (38, 17, 'fullname', 'Marian Bernath', 0, 1412859025, 0),
  222. (39, 17, 'branches', 'a:8:{i:0;i:1;i:1;i:2;i:2;i:3;i:3;i:4;i:4;i:5;i:5;i:6;i:6;i:7;i:7;i:8;}', 0, 1412859025, 0),
  223. (40, 18, 'fullname', 'Michal Spuchlak', 0, 1412859026, 0),
  224. (41, 18, 'branches', 'a:8:{i:0;i:1;i:1;i:2;i:2;i:3;i:3;i:4;i:4;i:5;i:5;i:6;i:6;i:7;i:7;i:8;}', 0, 1412859026, 0),
  225. (42, 19, 'fullname', 'Miroslav Kovac', 0, 1412859026, 0),
  226. (43, 19, 'branches', 'a:8:{i:0;i:1;i:1;i:2;i:2;i:3;i:3;i:4;i:4;i:5;i:5;i:6;i:6;i:7;i:7;i:8;}', 0, 1412859026, 0),
  227. (44, 20, 'fullname', 'Krystian Makara', 0, 1412859026, 0),
  228. (45, 20, 'branches', 'a:8:{i:0;i:1;i:1;i:2;i:2;i:3;i:3;i:4;i:4;i:5;i:5;i:6;i:6;i:7;i:7;i:8;}', 0, 1412859026, 0),
  229. (46, 21, 'fullname', 'Martin Lazorik', 0, 1412859026, 0),
  230. (47, 21, 'branches', 'a:8:{i:0;i:1;i:1;i:2;i:2;i:3;i:3;i:4;i:4;i:5;i:5;i:6;i:6;i:7;i:7;i:8;}', 0, 1412859026, 0),
  231. (48, 22, 'fullname', 'Jozef Adamisin', 0, 1412877765, 0),
  232. (49, 22, 'branches', 'a:8:{i:0;i:1;i:1;i:2;i:2;i:3;i:3;i:4;i:4;i:5;i:5;i:6;i:6;i:7;i:7;i:8;}', 0, 1412877765, 0),
  233. (50, 23, 'fullname', 'Stefan Migas', 0, 1412877765, 0),
  234. (51, 23, 'branches', 'a:8:{i:0;i:1;i:1;i:2;i:2;i:3;i:3;i:4;i:4;i:5;i:5;i:6;i:6;i:7;i:7;i:8;}', 0, 1412877765, 0),
  235. (52, 24, 'fullname', 'Michaela Frohlichova', 0, 1412877765, 0),
  236. (53, 24, 'branches', 'a:8:{i:0;i:1;i:1;i:2;i:2;i:3;i:3;i:4;i:4;i:5;i:5;i:6;i:6;i:7;i:7;i:8;}', 0, 1412877765, 0),
  237. (54, 25, 'fullname', 'Jan Ivanic', 0, 1412877799, 0),
  238. (55, 25, 'branches', 'a:8:{i:0;i:1;i:1;i:2;i:2;i:3;i:3;i:4;i:4;i:5;i:5;i:6;i:6;i:7;i:7;i:8;}', 0, 1412877799, 0);
  239.  
  240. -- --------------------------------------------------------
  241.  
  242. --
  243. -- Štruktúra tabuľky pre tabuľku `users_permissions`
  244. --
  245.  
  246. CREATE TABLE IF NOT EXISTS `users_permissions` (
  247.   `id` INT(11) NOT NULL AUTO_INCREMENT,
  248.   `area` VARCHAR(25) NOT NULL,
  249.   `permission` VARCHAR(25) NOT NULL,
  250.   `description` VARCHAR(255) NOT NULL,
  251.   `actions` text,
  252.   `user_id` INT(11) NOT NULL DEFAULT '0',
  253.   `created_at` INT(11) NOT NULL DEFAULT '0',
  254.   `updated_at` INT(11) NOT NULL DEFAULT '0',
  255.   PRIMARY KEY (`id`),
  256.   UNIQUE KEY `permission` (`area`,`permission`)
  257. ) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
  258.  
  259. --
  260. -- Sťahujem dáta pre tabuľku `users_permissions`
  261. --
  262.  
  263. INSERT INTO `users_permissions` (`id`, `area`, `permission`, `description`, `actions`, `user_id`, `created_at`, `updated_at`) VALUES
  264. (1, 'technician', 'orders', 'access to work_orders', 'a:5:{i:0;s:4:"read";i:1;s:5:"write";i:2;s:9:"write-own";i:3;s:6:"delete";i:4;s:10:"delete-own";}', 0, 1412837542, 0);
  265.  
  266. -- --------------------------------------------------------
  267.  
  268. --
  269. -- Štruktúra tabuľky pre tabuľku `users_providers`
  270. --
  271.  
  272. CREATE TABLE IF NOT EXISTS `users_providers` (
  273.   `id` INT(11) NOT NULL AUTO_INCREMENT,
  274.   `parent_id` INT(11) NOT NULL DEFAULT '0',
  275.   `provider` VARCHAR(50) NOT NULL,
  276.   `uid` VARCHAR(255) NOT NULL,
  277.   `secret` VARCHAR(255) DEFAULT NULL,
  278.   `access_token` VARCHAR(255) DEFAULT NULL,
  279.   `expires` INT(12) DEFAULT '0',
  280.   `refresh_token` VARCHAR(255) DEFAULT NULL,
  281.   `user_id` INT(11) NOT NULL DEFAULT '0',
  282.   `created_at` INT(11) NOT NULL DEFAULT '0',
  283.   `updated_at` INT(11) NOT NULL DEFAULT '0',
  284.   PRIMARY KEY (`id`),
  285.   KEY `parent_id` (`parent_id`)
  286. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
  287.  
  288. -- --------------------------------------------------------
  289.  
  290. --
  291. -- Štruktúra tabuľky pre tabuľku `users_roles`
  292. --
  293.  
  294. CREATE TABLE IF NOT EXISTS `users_roles` (
  295.   `id` INT(11) NOT NULL AUTO_INCREMENT,
  296.   `name` VARCHAR(255) NOT NULL,
  297.   `filter` enum('','A','D','R') NOT NULL DEFAULT '',
  298.   `user_id` INT(11) NOT NULL DEFAULT '0',
  299.   `created_at` INT(11) NOT NULL DEFAULT '0',
  300.   `updated_at` INT(11) NOT NULL DEFAULT '0',
  301.   PRIMARY KEY (`id`)
  302. ) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=6 ;
  303.  
  304. --
  305. -- Sťahujem dáta pre tabuľku `users_roles`
  306. --
  307.  
  308. INSERT INTO `users_roles` (`id`, `name`, `filter`, `user_id`, `created_at`, `updated_at`) VALUES
  309. (1, 'banned', 'D', 0, 0, 0),
  310. (2, 'customers', '', 0, 0, 0),
  311. (3, 'technicians', '', 0, 0, 0),
  312. (4, 'administrators', '', 0, 0, 0),
  313. (5, 'superadmin', 'A', 0, 0, 0);
  314.  
  315. -- --------------------------------------------------------
  316.  
  317. --
  318. -- Štruktúra tabuľky pre tabuľku `users_role_permissions`
  319. --
  320.  
  321. CREATE TABLE IF NOT EXISTS `users_role_permissions` (
  322.   `id` INT(11) NOT NULL AUTO_INCREMENT,
  323.   `role_id` INT(11) NOT NULL,
  324.   `perms_id` INT(11) NOT NULL,
  325.   `actions` text,
  326.   PRIMARY KEY (`id`)
  327. ) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;
  328.  
  329. --
  330. -- Sťahujem dáta pre tabuľku `users_role_permissions`
  331. --
  332.  
  333. INSERT INTO `users_role_permissions` (`id`, `role_id`, `perms_id`, `actions`) VALUES
  334. (1, 3, 1, 'a:3:{i:0;i:0;i:1;i:2;i:2;i:4;}'),
  335. (2, 5, 1, 'a:5:{i:0;i:0;i:1;i:1;i:2;i:2;i:3;i:3;i:4;i:4;}');
  336.  
  337. -- --------------------------------------------------------
  338.  
  339. --
  340. -- Štruktúra tabuľky pre tabuľku `users_scopes`
  341. --
  342.  
  343. CREATE TABLE IF NOT EXISTS `users_scopes` (
  344.   `id` INT(11) NOT NULL AUTO_INCREMENT,
  345.   `scope` VARCHAR(64) NOT NULL DEFAULT '',
  346.   `name` VARCHAR(64) NOT NULL DEFAULT '',
  347.   `description` VARCHAR(255) NOT NULL DEFAULT '',
  348.   PRIMARY KEY (`id`),
  349.   UNIQUE KEY `scope` (`scope`)
  350. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
  351.  
  352. -- --------------------------------------------------------
  353.  
  354. --
  355. -- Štruktúra tabuľky pre tabuľku `users_session`
  356. --
  357.  
  358. CREATE TABLE IF NOT EXISTS `users_session` (
  359.   `id` INT(11) NOT NULL AUTO_INCREMENT,
  360.   `client_id` VARCHAR(32) NOT NULL DEFAULT '',
  361.   `redirect_uri` VARCHAR(255) NOT NULL DEFAULT '',
  362.   `type_id` VARCHAR(64) NOT NULL,
  363.   `type` enum('user','auto') NOT NULL DEFAULT 'user',
  364.   `code` text NOT NULL,
  365.   `access_token` VARCHAR(50) NOT NULL DEFAULT '',
  366.   `stage` enum('request','granted') NOT NULL DEFAULT 'request',
  367.   `first_requested` INT(11) NOT NULL,
  368.   `last_updated` INT(11) NOT NULL,
  369.   `limited_access` tinyint(1) NOT NULL DEFAULT '0',
  370.   PRIMARY KEY (`id`),
  371.   KEY `oauth_sessions_ibfk_1` (`client_id`)
  372. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
  373.  
  374. -- --------------------------------------------------------
  375.  
  376. --
  377. -- Štruktúra tabuľky pre tabuľku `users_sessionscopes`
  378. --
  379.  
  380. CREATE TABLE IF NOT EXISTS `users_sessionscopes` (
  381.   `id` INT(11) NOT NULL AUTO_INCREMENT,
  382.   `session_id` INT(11) NOT NULL,
  383.   `access_token` VARCHAR(50) NOT NULL DEFAULT '',
  384.   `scope` VARCHAR(64) NOT NULL DEFAULT '',
  385.   PRIMARY KEY (`id`),
  386.   KEY `session_id` (`session_id`),
  387.   KEY `access_token` (`access_token`),
  388.   KEY `scope` (`scope`)
  389. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
  390.  
  391. -- --------------------------------------------------------
  392.  
  393. --
  394. -- Štruktúra tabuľky pre tabuľku `users_user_permissions`
  395. --
  396.  
  397. CREATE TABLE IF NOT EXISTS `users_user_permissions` (
  398.   `id` INT(11) NOT NULL AUTO_INCREMENT,
  399.   `user_id` INT(11) NOT NULL,
  400.   `perms_id` INT(11) NOT NULL,
  401.   `actions` text,
  402.   PRIMARY KEY (`id`)
  403. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
  404.  
  405. -- --------------------------------------------------------
  406.  
  407. --
  408. -- Štruktúra tabuľky pre tabuľku `users_user_roles`
  409. --
  410.  
  411. CREATE TABLE IF NOT EXISTS `users_user_roles` (
  412.   `user_id` INT(11) NOT NULL,
  413.   `role_id` INT(11) NOT NULL,
  414.   PRIMARY KEY (`user_id`,`role_id`)
  415. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  416.  
  417. --
  418. -- Obmedzenie pre exportované tabuľky
  419. --
  420.  
  421. --
  422. -- Obmedzenie pre tabuľku `users_session`
  423. --
  424. ALTER TABLE `users_session`
  425.   ADD CONSTRAINT `oauth_sessions_ibfk_1` FOREIGN KEY (`client_id`) REFERENCES `users_clients` (`client_id`) ON DELETE CASCADE;
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!