API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Apr 19th, 2015
276
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 25.81 KB | None | 0 0
raw download clone embed print report
  1. -- phpMyAdmin SQL Dump
  2. -- version 4.2.5
  3. -- http://www.phpmyadmin.net
  4. --
  5. -- Host: localhost:8889
  6. -- Generation Time: Apr 19, 2015 at 05:40 PM
  7. -- Server version: 5.5.38
  8. -- PHP Version: 5.5.14
  9.  
  10. SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
  11. SET time_zone = "+00:00";
  12.  
  13. --
  14. -- Database: `flog.cz`
  15. --
  16.  
  17. -- --------------------------------------------------------
  18.  
  19. --
  20. -- Table structure for table `banners`
  21. --
  22.  
  23. CREATE TABLE `banners` (
  24. `id` int(11) NOT NULL,
  25. `image` varchar(55) NOT NULL,
  26. `thumbnail` varchar(55) NOT NULL,
  27. `title` varchar(55) NOT NULL,
  28. `content` text CHARACTER SET utf8 NOT NULL,
  29. `post` int(11) DEFAULT NULL,
  30. `ins_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  31. `order` int(11) NOT NULL,
  32. `author` int(11) NOT NULL,
  33. `status` enum('A','I') NOT NULL DEFAULT 'A'
  34. ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=17 ;
  35.  
  36. --
  37. -- Dumping data for table `banners`
  38. --
  39.  
  40. INSERT INTO `banners` (`id`, `image`, `thumbnail`, `title`, `content`, `post`, `ins_date`, `order`, `author`, `status`) VALUES
  41. (15, '6js66fz2ga.svg', 'y66k6fea2c_thumb.jpg', 'PASTA ONER', 'Some more ZBLAH!', 10, '2015-03-26 17:05:08', 2, 1, 'A'),
  42. (16, '2wber65kzf.svg', 'wl3uxnnclp_thumb.jpg', 'Title', 'Subtitle', 4, '2015-04-16 08:00:39', 3, 2, 'A');
  43.  
  44. -- --------------------------------------------------------
  45.  
  46. --
  47. -- Table structure for table `categories`
  48. --
  49.  
  50. CREATE TABLE `categories` (
  51. `id` int(11) NOT NULL,
  52. `category` varchar(55) NOT NULL
  53. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=10 ;
  54.  
  55. --
  56. -- Dumping data for table `categories`
  57. --
  58.  
  59. INSERT INTO `categories` (`id`, `category`) VALUES
  60. (4, 'Publicistika'),
  61. (5, 'Poezie'),
  62. (8, 'Próza'),
  63. (9, 'Ostatní');
  64.  
  65. -- --------------------------------------------------------
  66.  
  67. --
  68. -- Table structure for table `comments`
  69. --
  70.  
  71. CREATE TABLE `comments` (
  72. `id` int(11) NOT NULL,
  73. `mother_id` int(11) DEFAULT NULL,
  74. `url` varchar(255) NOT NULL,
  75. `content` text NOT NULL,
  76. `fb_uid` bigint(20) NOT NULL,
  77. `fb_name` varchar(255) NOT NULL,
  78. `ins_dt` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
  79. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=17 ;
  80.  
  81. --
  82. -- Dumping data for table `comments`
  83. --
  84.  
  85. INSERT INTO `comments` (`id`, `mother_id`, `url`, `content`, `fb_uid`, `fb_name`, `ins_dt`) VALUES
  86. (1, NULL, 'http://localhost:8888/flog.cz/www/post/?postId=1', 'Dobrý den! :)', 1601818050053224, 'David Kregl', '2015-03-23 11:46:27'),
  87. (3, 1, 'http://localhost:8888/flog.cz/www/post/?postId=1', 'Háj!', 1601818050053224, 'David Kregl', '2015-03-23 11:50:53'),
  88. (4, 1, 'http://localhost:8888/flog.cz/www/post/?postId=1', 'To si nemyslím, ty blbče!', 1601818050053224, 'David Kregl', '2015-03-23 11:51:09'),
  89. (5, NULL, 'http://localhost:8888/flog.cz/www/post/?postId=1', 'Vivamus vehicula risus tellus. Nam finibus sapien quis felis tincidunt, sed volutpat magna ullamcorper. Nulla dapibus ante sit amet ex elementum, sed tincidunt diam placerat. Vestibulum in ipsum nunc. Integer ut tellus ut elit dictum eleifend. Nulla quis leo nec sem congue egestas eu sit amet lorem. Integer tristique tempus lorem, a interdum augue sollicitudin id. Nunc sagittis eros sem, at pharetra leo tincidunt ac.', 1601818050053224, 'David Kregl', '2015-03-23 11:51:33'),
  90. (6, 1, 'http://localhost:8888/flog.cz/www/post/?postId=1', 'Odpovídám na tvůj komentář.', 1601818050053224, 'David Kregl', '2015-03-23 11:54:28'),
  91. (7, NULL, 'http://localhost:8888/flog.cz/www/post/?postId=4', 'Dobrý den, přátelé! Velmi dobrý příspěvek ;)', 1601818050053224, 'David Kregl', '2015-03-24 19:31:11'),
  92. (8, NULL, 'http://localhost:8888/flog.cz/www/post/?postId=2', 'Dobrý den! :)', 1601818050053224, 'David Kregl', '2015-03-26 14:31:03'),
  93. (9, NULL, 'http://localhost:8888/flog.cz/www/post/?postId=2', '', 1601818050053224, 'David Kregl', '2015-03-26 14:58:50'),
  94. (10, 8, 'http://localhost:8888/flog.cz/www/post/?postId=2', 'Ahoj, Dejve!', 1601818050053224, 'David Kregl', '2015-03-26 14:59:01'),
  95. (11, NULL, 'http://localhost:8888/flog.cz/www/post/illustration/?postId=3', 'Hello, guys!', 1601818050053224, 'David Kregl', '2015-03-26 15:50:17'),
  96. (12, NULL, 'http://localhost:8888/flog.cz/www/post/?postId=5', 'První komwnt', 1601818050053224, 'David Kregl', '2015-04-05 21:19:26'),
  97. (13, NULL, 'http://localhost:8888/flog.cz/www/post/illustration/?postId=10', 'Dobrý den :)', 1601818050053224, 'David Kregl', '2015-04-13 10:52:37'),
  98. (14, NULL, 'http://localhost:8888/flog.cz/www/post/?postId=11', 'AHoj, Dejve!', 1601818050053224, 'David Kregl', '2015-04-14 08:29:46'),
  99. (15, NULL, 'http://localhost:8888/flog.cz/www/post/illustration/?postId=10', 'Ahoj.', 1601818050053224, 'David Kregl', '2015-04-14 21:59:50'),
  100. (16, NULL, 'http://localhost:8888/flog.cz/www/post/illustration/?postId=10', 'test', 1601818050053224, 'David Kregl', '2015-04-14 22:12:34');
  101.  
  102. -- --------------------------------------------------------
  103.  
  104. --
  105. -- Table structure for table `events`
  106. --
  107.  
  108. CREATE TABLE `events` (
  109. `id` int(11) NOT NULL,
  110. `title` varchar(55) NOT NULL,
  111. `description` text NOT NULL,
  112. `date` varchar(55) NOT NULL,
  113. `place` varchar(55) NOT NULL,
  114. `facebook_event` varchar(255) NOT NULL,
  115. `google_map` varchar(255) NOT NULL,
  116. `place_website` varchar(255) NOT NULL,
  117. `thumbnail` varchar(55) NOT NULL,
  118. `cover` varchar(55) NOT NULL,
  119. `time` varchar(55) NOT NULL
  120. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;
  121.  
  122. --
  123. -- Dumping data for table `events`
  124. --
  125.  
  126. INSERT INTO `events` (`id`, `title`, `description`, `date`, `place`, `facebook_event`, `google_map`, `place_website`, `thumbnail`, `cover`, `time`) VALUES
  127. (1, 'Quisque venenatis tortor lacus, in eleifend lorem viver', 'Suspendisse mattis vehicula ullamcorper. Donec id vulputate lectus.', '21.3. 2012', 'Times Square, NYC', 'http://web.com', 'http://web.com', 'http://web.com', 'jybe2bqp8q.jpg', 'xjcrktr15q.jpg', '22:00'),
  128. (2, 'Lorem ipsum dolor sit amet, consectetur adipiscing elit', 'Suspendisse mattis vehicula ullamcorper. Donec id vulputate lectus. Pellentesque habitant morbi tristique senectus et netus et malesuada fames ac turpis egestas.', '23.2. 2015', 'Starbucks, Václavské náměstí', 'http://facebook.com', 'http://google.com', 'http://google.com', 'wzg82wbija.jpg', 'v6t0k12jus.jpg', '19:00');
  129.  
  130. -- --------------------------------------------------------
  131.  
  132. --
  133. -- Table structure for table `events_schedule`
  134. --
  135.  
  136. CREATE TABLE `events_schedule` (
  137. `id` int(11) NOT NULL,
  138. `event_id` int(11) NOT NULL,
  139. `title` varchar(55) NOT NULL,
  140. `description` text NOT NULL,
  141. `time` varchar(55) NOT NULL,
  142. `author` int(11) DEFAULT NULL
  143. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=10 ;
  144.  
  145. --
  146. -- Dumping data for table `events_schedule`
  147. --
  148.  
  149. INSERT INTO `events_schedule` (`id`, `event_id`, `title`, `description`, `time`, `author`) VALUES
  150. (5, 2, 'Vestibulum sed ligula iaculis.', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit.', '19:00 - 20:00', 1),
  151. (7, 2, 'Závěr akce, poděkování', 'Nullam sed risus posuere, scelerisque ante quis, congue velit.', '22:00 - 22:30', NULL),
  152. (8, 1, 'Vítejte!', 'Nullam sed risus posuere, scelerisque ante quis, congue velit.', '17:00-22:00', 4),
  153. (9, 2, 'Bod programu', 'Popis programu', '22:30 - 23:00', 4);
  154.  
  155. -- --------------------------------------------------------
  156.  
  157. --
  158. -- Table structure for table `posts`
  159. --
  160.  
  161. CREATE TABLE `posts` (
  162. `id` int(11) NOT NULL,
  163. `title` varchar(55) NOT NULL,
  164. `subtitle` varchar(255) NOT NULL,
  165. `content` text NOT NULL,
  166. `author` int(11) NOT NULL,
  167. `category` int(11) NOT NULL,
  168. `thumbnail` varchar(55) NOT NULL,
  169. `image` varchar(55) NOT NULL,
  170. `timeline` tinyint(1) NOT NULL DEFAULT '1',
  171. `status` enum('new','active','inactive') NOT NULL DEFAULT 'new',
  172. `approval_date` timestamp NULL DEFAULT NULL,
  173. `ins_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
  174. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=12 ;
  175.  
  176. --
  177. -- Dumping data for table `posts`
  178. --
  179.  
  180. INSERT INTO `posts` (`id`, `title`, `subtitle`, `content`, `author`, `category`, `thumbnail`, `image`, `timeline`, `status`, `approval_date`, `ins_date`) VALUES
  181. (1, 'Duis rutrum metus ligula, at venenatis ante auctor eu', 'Phasellus pharetra lacus at massa hendrerit molestie. Sed blandit ipsum a ex varius, eget convallis odio volutpat.', '<p style="text-align:justify">In diam sem, vehicula ut justo vitae, laoreet auctor turpis. Duis rutrum metus ligula, at venenatis ante auctor eu. Phasellus pharetra lacus at massa hendrerit molestie. Sed blandit ipsum a ex varius, eget convallis odio volutpat. Praesent nunc enim, condimentum non pharetra volutpat, cursus quis enim. Praesent risus sapien, viverra euismod viverra in, congue eu sapien. Pellentesque vitae enim tincidunt, facilisis felis sit amet, consectetur libero. Nullam ullamcorper volutpat elementum. Cras mollis orci vitae diam sodales consectetur. Praesent molestie mauris ac leo faucibus rutrum. Vestibulum eu convallis purus. Integer sodales mattis accumsan. Nunc ultricies metus accumsan suscipit congue. Praesent mi quam, consequat et urna et, sodales vestibulum leo. Aliquam eu pellentesque velit, quis condimentum nibh. Nulla dignissim ac diam a ornare.</p><p style="text-align:justify"><em>Donec ante sapien, dignissim nec erat vel, euismod interdum eros. Duis euismod magna sed nunc vehicula viverra. Cras id risus vulputate, interdum est sed, pharetra mi. Sed cursus viverra erat, ut ultrices tortor. Donec tellus massa, dapibus et urna in, sollicitudin ornare dui. Nam massa est, mollis vel cursus sit amet, sodales ut elit. Vestibulum eget nisl volutpat, gravida neque vitae, fermentum felis.</em></p><hr /><p style="text-align:justify"> </p>', 2, 4, 'sj6i3svrfv.jpg', 'k9oas9nj4t.svg', 1, 'active', '2015-04-14 10:34:51', '2015-03-16 16:33:39'),
  182. (2, 'Lorem ipsum dolor sit amet, consectetur adipiscing elit', 'Curabitur blandit sapien eu nulla sodales mollis. Praesent rutrum est sit amet magna ultrices, non congue velit laoreet.', '<h2>V&iacute;tejte,</h2>\nLorem ipsum dolor sit amet, consectetur adipiscing elit. Curabitur blandit sapien eu nulla sodales mollis. Praesent rutrum est sit amet magna ultrices, non congue velit laoreet. Phasellus molestie libero a blandit viverra. Interdum et malesuada fames ac ante ipsum primis in faucibus. Praesent hendrerit, nulla ac finibus semper, erat velit pretium libero, sed consequat ex nisl ac augue. Vivamus nibh velit, blandit vel lorem eget, finibus finibus augue. Nulla vitae nisl vitae mi pulvinar vulputate vel quis mauris. Sed mattis nibh ac varius lobortis. Nunc vel mollis ante. Ut efficitur tellus diam, non facilisis nisi faucibus vitae. Fusce varius turpis id sapien dignissim porta. Ut euismod lectus velit, a rutrum nunc iaculis eu. Aliquam ut tempus dui, a vulputate quam.<br />\n<br />\n<strong>Lorem ipsum dolor sit amet, consectetur adipiscing elit. Curabitur blandit sapien eu nulla sodales mollis. Praesent rutrum est sit amet magna ultrices, non congue velit laoreet. Phasellus molestie libero a blandit viverra. Interdum et malesuada fames ac ante ipsum primis in faucibus. Praesent hendrerit, nulla ac finibus semper, erat velit pretium libero, sed consequat ex nisl ac augue. Vivamus nibh velit, blandit vel lorem eget, finibus finibus augue. Nulla vitae nisl vitae mi pulvinar vulputate vel quis mauris. Sed mattis nibh ac varius lobortis. Nunc vel mollis ante. Ut efficitur tellus diam, non facilisis nisi faucibus vitae. Fusce varius turpis id sapien dignissim porta. Ut euismod lectus velit, a rutrum nunc iaculis eu. Aliquam ut tempus dui, a vulputate quam.</strong><br />\n&nbsp;\n<div class="embed-responsive embed-responsive-16by9"><iframe frameborder="0" src="https://www.youtube.com/embed/qNzp1znjy14"></iframe></div>\n<em>Lorem ipsum dolor sit amet, consectetur adipiscing elit. Curabitur blandit sapien eu nulla sodales mollis. Praesent rutrum est sit amet magna ultrices, non congue velit laoreet. Phasellus molestie libero a blandit viverra. Interdum et malesuada fames ac ante ipsum primis in faucibus. Praesent hendrerit, nulla ac finibus semper, erat velit pretium libero, sed consequat ex nisl ac augue. Vivamus nibh velit, blandit vel lorem eget, finibus finibus augue. Nulla vitae nisl vitae mi pulvinar vulputate vel quis mauris. Sed mattis nibh ac varius lobortis. Nunc vel mollis ante. Ut efficitur tellus diam, non facilisis nisi faucibus vitae. Fusce varius turpis id sapien dignissim porta. Ut euismod lectus velit, a rutrum nunc iaculis eu. Aliquam ut tempus dui, a vulputate quam.</em><br />\n<br />\n&nbsp;', 2, 8, 'e1vxyflmg9.jpg', '', 1, 'active', '2015-04-14 10:35:51', '2015-03-16 16:54:39'),
  183. (3, 'Ut id mi neque. Quisque quis faucibus neque.', 'Nam interdum enim sed lectus eleifend sagittis. Sed tincidunt augue in massa dictum ornare. Donec scelerisque sodales rhoncus. Sed posuere pretium tellus, tristique sollicitudin sapien cursus ac.', '<strong>Donec quis enim pellentesque, tempus lorem eu, aliquet libero. Ut id mi neque. Quisque quis faucibus neque. Nam interdum enim sed lectus eleifend sagittis. Sed tincidunt augue in massa dictum ornare. Donec scelerisque sodales rhoncus. Sed posuere pretium tellus, tristique sollicitudin sapien cursus ac. Ut ut risus nec ipsum dapibus tincidunt et ut tortor. Nulla nec gravida elit. Sed vel dapibus lacu.</strong>', 3, 9, '6j6q0pju5p.jpg', 'ygneoz7lxx.svg', 1, 'active', '2015-04-14 10:41:46', '2014-03-16 18:43:11'),
  184. (4, 'PASTA ONER', 'Donec at mattis enim. Aliquam erat volutpat.', '<p style="text-align:justify">Fusce pellentesque turpis eget arcu finibus, vel facilisis felis fringilla. Donec eu faucibus elit. In eu ullamcorper enim, ac pulvinar turpis. Aliquam pharetra erat eu turpis rutrum, ut commodo mi imperdiet. Donec at mattis enim. Aliquam erat volutpat. Curabitur a nibh molestie dolor lacinia tincidunt. Ut sit amet suscipit neque.</p>\n\n<p style="text-align:justify">In diam sem, vehicula ut justo vitae, laoreet auctor turpis. Duis rutrum metus ligula, at venenatis ante auctor eu. Phasellus pharetra lacus at massa hendrerit molestie. Sed blandit ipsum a ex varius, eget convallis odio volutpat. Praesent nunc enim, condimentum non pharetra volutpat, cursus quis enim. Praesent risus sapien, viverra euismod viverra in, congue eu sapien. Pellentesque vitae enim tincidunt, facilisis felis sit amet, consectetur libero. Nullam ullamcorper volutpat elementum. Cras mollis orci vitae diam sodales consectetur. Praesent molestie mauris ac leo faucibus rutrum. Vestibulum eu convallis purus. Integer sodales mattis accumsan. Nunc ultricies metus accumsan suscipit congue. Praesent mi quam, consequat et urna et, sodales vestibulum leo. Aliquam eu pellentesque velit, quis condimentum nibh. Nulla dignissim ac diam a ornare.</p>\n\n<p style="text-align:justify">Donec ante sapien, dignissim nec erat vel, euismod interdum eros. Duis euismod magna sed nunc vehicula viverra. Cras id risus vulputate, interdum est sed, pharetra mi. Sed cursus viverra erat, ut ultrices tortor. Donec tellus massa, dapibus et urna in, sollicitudin ornare dui. Nam massa est, mollis vel cursus sit amet, sodales ut elit. Vestibulum eget nisl volutpat, gravida neque vitae, fermentum felis.</p>\n\n<p style="text-align:justify">Donec quis enim pellentesque, tempus lorem eu, aliquet libero. Ut id mi neque. Quisque quis faucibus neque. Nam interdum enim sed lectus eleifend sagittis. Sed tincidunt augue in massa dictum ornare. Donec scelerisque sodales rhoncus. Sed posuere pretium tellus, tristique sollicitudin sapien cursus ac. Ut ut risus nec ipsum dapibus tincidunt et ut tortor. Nulla nec gravida elit. Sed vel dapibus lacus.</p>\n', 4, 4, '3etkannyhl.jpg', 'hpmaln5ssx.svg', 0, 'active', NULL, '2015-03-16 18:44:52'),
  185. (10, 'dsadasd', 'dsad', 'asdasdas', 2, 4, 'jk6j0cpn6a.jpg', 'zwayzvwat7.svg', 0, 'active', NULL, '2015-04-13 10:48:59'),
  186. (5, 'Lorem ipsum dolor sit amet, consectetur adipiscing elit', 'Aliquam maximus, leo dignissim efficitur semper, tellus lectus mollis neque, sit amet pretium nulla ante et mauris. Aliquam erat volutpat.', '<p style="text-align:justify">Phasellus id orci quis nibh suscipit lacinia nec et nunc. Pellentesque habitant morbi tristique senectus et netus et malesuada fames ac turpis egestas. In hac habitasse platea dictumst. Suspendisse potenti. Vivamus semper tincidunt magna, vitae tempus lacus ultrices et. Donec quis accumsan augue. Sed a leo metus. Suspendisse potenti. Fusce sit amet lacinia massa. Nunc sed arcu ultricies, ullamcorper enim nec, tristique felis. Praesent id odio rutrum, dignissim ante in, posuere mauris. Sed luctus, neque sed dictum blandit, risus augue dapibus mi, vitae posuere mi libero non mauris. Nullam nec sapien laoreet, malesuada odio et, malesuada mauris. Lorem ipsum dolor sit amet, consectetur adipiscing elit.</p>\n\n<p style="text-align:justify"><strong><em><u>Pellentesque habitant morbi tristique senectus et netus et malesuada fames ac turpis egestas. In ac libero sed eros placerat pulvinar eget in metus. Mauris euismod volutpat justo, id rhoncus mauris porttitor scelerisque. Curabitur mattis tincidunt diam, eu pharetra eros iaculis vel. Curabitur nec nisi velit. Phasellus at tortor eu enim malesuada tincidunt. Maecenas tempus ante sit amet sodales sagittis. Curabitur ac magna euismod, vulputate lorem vitae, hendrerit arcu. Vestibulum ut dictum nibh. Vivamus viverra sit amet erat vitae mattis. Phasellus suscipit nunc tortor, at bibendum neque accumsan ac. Fusce imperdiet, leo quis ultricies pharetra, tellus nisi posuere erat, in porttitor nulla sapien eget odio.</u></em></strong></p>\n', 1, 5, 'ctxw9q90xi.jpg', '', 0, 'active', NULL, '2014-03-16 18:45:40'),
  187. (11, 'ZBLAH', 'SOME MOR ZBLAH', '<span style="font-size:48px"><span style="font-family:comic sans ms,cursive">asdsadasfasfa</span></span>', 2, 9, 'i0ou0xl42z.jpg', '', 1, 'active', NULL, '2015-04-13 21:24:58');
  188.  
  189. -- --------------------------------------------------------
  190.  
  191. --
  192. -- Table structure for table `users`
  193. --
  194.  
  195. CREATE TABLE `users` (
  196. `id` int(11) NOT NULL,
  197. `username` varchar(55) COLLATE utf8_czech_ci NOT NULL,
  198. `password` varchar(55) COLLATE utf8_czech_ci NOT NULL,
  199. `full_name` varchar(55) COLLATE utf8_czech_ci NOT NULL,
  200. `nickname` varchar(55) COLLATE utf8_czech_ci NOT NULL,
  201. `description` text COLLATE utf8_czech_ci NOT NULL,
  202. `phone` int(11) NOT NULL,
  203. `website` varchar(55) COLLATE utf8_czech_ci NOT NULL,
  204. `facebook` varchar(255) COLLATE utf8_czech_ci DEFAULT NULL,
  205. `google` varchar(255) COLLATE utf8_czech_ci DEFAULT NULL,
  206. `twitter` varchar(255) COLLATE utf8_czech_ci DEFAULT NULL,
  207. `youtube` varchar(255) COLLATE utf8_czech_ci DEFAULT NULL,
  208. `avatar` varchar(55) COLLATE utf8_czech_ci DEFAULT NULL,
  209. `role` enum('root','admin','user') COLLATE utf8_czech_ci NOT NULL,
  210. `registered` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  211. `status` enum('active','inactive') COLLATE utf8_czech_ci NOT NULL DEFAULT 'active'
  212. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=8 ;
  213.  
  214. --
  215. -- Dumping data for table `users`
  216. --
  217.  
  218. INSERT INTO `users` (`id`, `username`, `password`, `full_name`, `nickname`, `description`, `phone`, `website`, `facebook`, `google`, `twitter`, `youtube`, `avatar`, `role`, `registered`, `status`) VALUES
  219. (2, 'krekoun@gmail.com', '9d4e1e23bd5b727046a9e3b4b7db57bd8d6ee684', 'David Kregl', 'Šéfredaktor', 'Nulla quis leo vitae mi commodo ullamcorper. Aliquam felis nisl, posuere eu consectetur et, malesuada at lectus. Maecenas condimentum ex ipsum, nec tincidunt odio elementum ac. Nunc sit amet mauris dapibus dolor pretium varius quis non mi. Quisque id aliquam elit. Sed venenatis commodo lorem, in iaculis justo varius nec. Integer quis eleifend elit, at gravida leo. Aenean tellus dui, viverra at rhoncus sit amet, sagittis et mi. Nullam nec consectetur libero. Interdum et malesuada fames ac ante ipsum primis in faucibus. Aliquam egestas efficitur accumsan. Aliquam ut blandit sem. In convallis eget enim ac cursus.', 733330705, 'http://www.davidkregl.com', 'http://www.facebook.com', 'http://google.com', 'http://www.twitter.com/CzechRichBoy', '', '2uy3lsdqdz.jpg', 'root', '2015-02-18 09:57:18', 'active'),
  220. (3, 'anna.pavlisova@gmail.com', '9d4e1e23bd5b727046a9e3b4b7db57bd8d6ee684', 'Anna Pavlisová', 'Mrs. Ann', 'Maecenas eleifend cursus aliquam. Donec porta auctor enim, vel semper nibh lobortis id. Praesent scelerisque orci felis, id porta lacus mollis sit amet. Nam placerat neque orci, quis convallis mauris mollis ut. Suspendisse at luctus neque. Nam sodales tempus malesuada. Praesent in nisl id magna finibus maximus. Praesent varius dapibus sagittis. Aliquam posuere massa sit amet ligula iaculis, id egestas nibh bibendum. Nunc et placerat orci, eu suscipit turpis. Proin leo ante, vulputate at pretium ut, suscipit vel odio.', 763338299, 'http://www.mrsann.com', 'http://www.facebook.com', NULL, NULL, 'https://youtube.com/learn_more', '', 'user', '2015-02-27 00:21:22', 'active'),
  221. (4, 'jan.svehla@gmail.com', 'aafdc23870ecbcd3d557b6423a8982134e17927e', 'Jan Švehla', 'j0hNNy', 'Morbi metus odio, consequat vel purus et, lobortis laoreet ex. Cras quis sagittis dui, vel gravida ipsum. Suspendisse potenti. Sed elementum aliquam tempor. Nunc in odio eu metus rhoncus varius sed non felis. Maecenas leo quam, convallis a orci ac, malesuada lacinia est. Quisque non urna bibendum, molestie urna at, viverra nulla. Pellentesque ornare, eros nec cursus congue, eros dui imperdiet libero, vitae convallis purus massa ut nulla. In non lorem vel magna pellentesque tristique ac nec nulla.', 733330705, 'http://www.jan-svehla.cz', 'http://facebook.com/svehla', '', 'http://twitter.com/svehla', '', 'yr56igwt5g.png', 'user', '2015-02-27 00:27:21', 'active'),
  222. (5, 'john.doe@gmail.com', 'aafdc23870ecbcd3d557b6423a8982134e17927e', 'John Doe', '', '', 0, '', NULL, NULL, NULL, NULL, 'n6dptmhmfs.jpg', 'user', '2015-03-23 12:38:45', 'active'),
  223. (1, 'info@flog.cz', 'fa8da220f207abe5a12991d5f820969edc093c3c', 'Flog.cz', 'Multikulturní doména', '', 0, '', NULL, NULL, NULL, NULL, NULL, 'root', '2015-04-05 11:51:38', 'active');
  224.  
  225. -- --------------------------------------------------------
  226.  
  227. --
  228. -- Table structure for table `users_employment`
  229. --
  230.  
  231. CREATE TABLE `users_employment` (
  232. `id` int(11) NOT NULL,
  233. `user_id` int(11) NOT NULL,
  234. `employment` varchar(255) NOT NULL
  235. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=15 ;
  236.  
  237. --
  238. -- Dumping data for table `users_employment`
  239. --
  240.  
  241. INSERT INTO `users_employment` (`id`, `user_id`, `employment`) VALUES
  242. (7, 3, 'Poradenská společnost SEO group'),
  243. (8, 1, 'Poradenská společnost SEO group'),
  244. (9, 1, 'Alza.cz'),
  245. (10, 1, '#notWorking'),
  246. (12, 3, 'Knihkupectví Neoluxor / 2010-2014'),
  247. (13, 3, 'Flog.cz / 2015-X'),
  248. (14, 4, 'Gymnázium Arabská 14, Praha 6');
  249.  
  250. -- --------------------------------------------------------
  251.  
  252. --
  253. -- Table structure for table `users_valuation`
  254. --
  255.  
  256. CREATE TABLE `users_valuation` (
  257. `id` int(11) NOT NULL,
  258. `user_id` int(11) NOT NULL,
  259. `valuation` varchar(255) NOT NULL
  260. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=9 ;
  261.  
  262. --
  263. -- Dumping data for table `users_valuation`
  264. --
  265.  
  266. INSERT INTO `users_valuation` (`id`, `user_id`, `valuation`) VALUES
  267. (2, 1, '1. místo v literární soutěži'),
  268. (4, 1, '2. místo'),
  269. (7, 3, 'Neoluxor - ZAMĚSTNANEC ROKU 2014'),
  270. (8, 4, '1. místo v literární soutěžy na GYARAB');
  271.  
  272. --
  273. -- Indexes for dumped tables
  274. --
  275.  
  276. --
  277. -- Indexes for table `banners`
  278. --
  279. ALTER TABLE `banners`
  280. ADD PRIMARY KEY (`id`), ADD KEY `post` (`post`);
  281.  
  282. --
  283. -- Indexes for table `categories`
  284. --
  285. ALTER TABLE `categories`
  286. ADD PRIMARY KEY (`id`);
  287.  
  288. --
  289. -- Indexes for table `comments`
  290. --
  291. ALTER TABLE `comments`
  292. ADD PRIMARY KEY (`id`), ADD KEY `mother_id` (`mother_id`);
  293.  
  294. --
  295. -- Indexes for table `events`
  296. --
  297. ALTER TABLE `events`
  298. ADD PRIMARY KEY (`id`);
  299.  
  300. --
  301. -- Indexes for table `events_schedule`
  302. --
  303. ALTER TABLE `events_schedule`
  304. ADD PRIMARY KEY (`id`), ADD KEY `event_id` (`event_id`), ADD KEY `author` (`author`);
  305.  
  306. --
  307. -- Indexes for table `posts`
  308. --
  309. ALTER TABLE `posts`
  310. ADD PRIMARY KEY (`id`), ADD FULLTEXT KEY `vyhledavani` (`title`,`subtitle`,`content`);
  311.  
  312. --
  313. -- Indexes for table `users`
  314. --
  315. ALTER TABLE `users`
  316. ADD PRIMARY KEY (`id`), ADD FULLTEXT KEY `vyhledavani` (`username`,`full_name`,`nickname`,`description`,`website`);
  317.  
  318. --
  319. -- Indexes for table `users_employment`
  320. --
  321. ALTER TABLE `users_employment`
  322. ADD PRIMARY KEY (`id`), ADD KEY `user_id` (`user_id`);
  323.  
  324. --
  325. -- Indexes for table `users_valuation`
  326. --
  327. ALTER TABLE `users_valuation`
  328. ADD PRIMARY KEY (`id`), ADD KEY `user_id` (`user_id`);
  329.  
  330. --
  331. -- AUTO_INCREMENT for dumped tables
  332. --
  333.  
  334. --
  335. -- AUTO_INCREMENT for table `banners`
  336. --
  337. ALTER TABLE `banners`
  338. MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=17;
  339. --
  340. -- AUTO_INCREMENT for table `categories`
  341. --
  342. ALTER TABLE `categories`
  343. MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=10;
  344. --
  345. -- AUTO_INCREMENT for table `comments`
  346. --
  347. ALTER TABLE `comments`
  348. MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=17;
  349. --
  350. -- AUTO_INCREMENT for table `events`
  351. --
  352. ALTER TABLE `events`
  353. MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=3;
  354. --
  355. -- AUTO_INCREMENT for table `events_schedule`
  356. --
  357. ALTER TABLE `events_schedule`
  358. MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=10;
  359. --
  360. -- AUTO_INCREMENT for table `posts`
  361. --
  362. ALTER TABLE `posts`
  363. MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=12;
  364. --
  365. -- AUTO_INCREMENT for table `users`
  366. --
  367. ALTER TABLE `users`
  368. MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=8;
  369. --
  370. -- AUTO_INCREMENT for table `users_employment`
  371. --
  372. ALTER TABLE `users_employment`
  373. MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=15;
  374. --
  375. -- AUTO_INCREMENT for table `users_valuation`
  376. --
  377. ALTER TABLE `users_valuation`
  378. MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=9;
  379. --
  380. -- Constraints for dumped tables
  381. --
  382.  
  383. --
  384. -- Constraints for table `comments`
  385. --
  386. ALTER TABLE `comments`
  387. ADD CONSTRAINT `comments_ibfk_1` FOREIGN KEY (`mother_id`) REFERENCES `comments` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
  388.  
  389. --
  390. -- Constraints for table `events_schedule`
  391. --
  392. ALTER TABLE `events_schedule`
  393. ADD CONSTRAINT `events_schedule_ibfk_1` FOREIGN KEY (`event_id`) REFERENCES `events` (`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!