API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Oct 22nd, 2017
76
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 9.49 KB | None | 0 0
raw download clone embed print report
  1. -- phpMyAdmin SQL Dump
  2. -- version 4.6.5.2
  3. -- https://www.phpmyadmin.net/
  4. --
  5. -- Host: 127.0.0.1
  6. -- Generation Time: Oct 22, 2017 at 03:19 PM
  7. -- Server version: 10.1.21-MariaDB
  8. -- PHP Version: 7.1.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. -- Database: `examonline`
  21. --
  22.  
  23. -- --------------------------------------------------------
  24.  
  25. --
  26. -- Table structure for table `questions`
  27. --
  28.  
  29. CREATE TABLE `questions` (
  30.   `id` INT(11) NOT NULL,
  31.   `name` VARCHAR(70) NOT NULL,
  32.   `time` VARCHAR(30) DEFAULT NULL,
  33.   `random` INT(11) DEFAULT NULL,
  34.   `score` INT(11) NOT NULL,
  35.   `created_at` TIMESTAMP NULL DEFAULT NULL,
  36.   `updated_at` TIMESTAMP NULL DEFAULT NULL,
  37.   `deleted_at` TIMESTAMP NULL DEFAULT NULL
  38. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  39.  
  40. --
  41. -- Dumping data for table `questions`
  42. --
  43.  
  44. INSERT INTO `questions` (`id`, `name`, `time`, `random`, `score`, `created_at`, `updated_at`, `deleted_at`) VALUES
  45. (1, 'HTML5', '120', NULL, 70, '2017-09-07 10:09:54', '2017-10-06 19:16:12', NULL),
  46. (2, 'CSS3', '120', NULL, 80, '2017-09-07 11:42:56', '2017-10-06 18:54:07', NULL),
  47. (3, 'a', '12', NULL, 100, '2017-10-04 23:31:48', '2017-10-04 23:31:57', '2017-10-04 23:31:57'),
  48. (4, 'a', '12', NULL, 100, '2017-10-04 23:31:51', '2017-10-04 23:32:00', '2017-10-04 23:32:00'),
  49. (5, 'Hello', '10', NULL, 10, '2017-10-04 23:32:11', '2017-10-06 18:54:09', NULL),
  50. (6, 'PHP\'s Test', '120', NULL, 90, '2017-10-06 18:29:00', '2017-10-06 18:54:11', NULL);
  51.  
  52. -- --------------------------------------------------------
  53.  
  54. --
  55. -- Table structure for table `question_list`
  56. --
  57.  
  58. CREATE TABLE `question_list` (
  59.   `id` INT(11) NOT NULL,
  60.   `questions_id` INT(11) NOT NULL,
  61.   `question` text NOT NULL,
  62.   `answer` VARCHAR(70) DEFAULT NULL,
  63.   `note` text,
  64.   `gen_id` VARCHAR(50) DEFAULT NULL
  65. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  66.  
  67. --
  68. -- Dumping data for table `question_list`
  69. --
  70.  
  71. INSERT INTO `question_list` (`id`, `questions_id`, `question`, `answer`, `note`, `gen_id`) VALUES
  72. (1, 1, '<p>Apa itu HTML?</p>', 'option_1_1', 'Hello, world!', NULL),
  73. (2, 1, '<p>Tag table?</p>', 'option_2_3', 'Place your note here', NULL),
  74. (3, 1, '<p>Tag title?</p>', 'option_3_6', 'Testing', NULL),
  75. (6, 5, '<p>Your question #1</p>', 'option_1_1', 'asdasdasdasd', NULL),
  76. (16, 6, '<p>Your question #1</p>', 'option_1_1', NULL, NULL),
  77. (17, 6, '<p>Your question #2</p>', 'option_2_3', NULL, NULL),
  78. (18, 6, '<p>Your question #3</p>', NULL, NULL, NULL),
  79. (31, 2, '<p>Penulisan mana untuk membuat&nbsp;<em>transition&nbsp;</em>yang benar?</p>', 'option_2_5', NULL, NULL),
  80. (32, 2, '<p>Pseudo-class selector pada CSS untuk menempatkan&nbsp;<em>content&nbsp;</em>sebelum pada element?</p>', 'option_3_10', NULL, NULL),
  81. (33, 2, '<p>Apa itu CSS?</p>', 'option_1_1', NULL, NULL),
  82. (34, 2, '<p>Bagaimana menyisipkan CSS pada HTML?</p>', 'option_4_13', NULL, NULL),
  83. (35, 2, '<p>Your question #5</p>', 'option_5_15', NULL, NULL),
  84. (36, 2, '<p>Your question #6</p>', 'option_6_19', NULL, NULL),
  85. (37, 2, '<p>Your question #7</p>', 'option_7_20', NULL, NULL),
  86. (38, 2, '<p>Your question #8</p>', 'option_8_24', NULL, NULL),
  87. (39, 2, '<p>Your question #9</p>', 'option_9_28', NULL, NULL),
  88. (40, 2, '<p>Your question #10</p>', 'option_10_29', NULL, NULL),
  89. (41, 2, '<p>Your question #11</p>', 'option_11_31', NULL, NULL),
  90. (42, 2, '<p>Your question #12</p>', 'option_12_34', NULL, NULL);
  91.  
  92. -- --------------------------------------------------------
  93.  
  94. --
  95. -- Table structure for table `question_options`
  96. --
  97.  
  98. CREATE TABLE `question_options` (
  99.   `id` INT(11) NOT NULL,
  100.   `question_list_id` VARCHAR(50) NOT NULL,
  101.   `option_text` text NOT NULL,
  102.   `gen_id` VARCHAR(70) NOT NULL
  103. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  104.  
  105. --
  106. -- Dumping data for table `question_options`
  107. --
  108.  
  109. INSERT INTO `question_options` (`id`, `question_list_id`, `option_text`, `gen_id`) VALUES
  110. (1, '1', 'Hypertext Markup Language', 'option_1_1'),
  111. (2, '1', 'How To Meet Ladies', 'option_1_2'),
  112. (3, '2', '&lt;table&gt;', 'option_2_3'),
  113. (4, '2', '&lt;tr&gt;', 'option_2_4'),
  114. (5, '2', '&lt;td&gt;', 'option_2_5'),
  115. (6, '3', '&lt;title&gt;', 'option_3_6'),
  116. (7, '3', '&lt;meta&gt;', 'option_3_7'),
  117. (8, '6', 'Optisson', 'option_1_1'),
  118. (9, '6', 'Optioaan', 'option_1_2'),
  119. (10, '6', 'Op22tion', 'option_1_3'),
  120. (11, '7', 'Cascading Style Sheet', 'option_1_1'),
  121. (12, '7', 'Cascading Style Shit', 'option_1_2'),
  122. (13, '7', 'Cascading Sit Down', 'option_1_3'),
  123. (14, '8', 'transvision: 10s;', 'option_2_4'),
  124. (15, '8', 'transition: all .3s;', 'option_2_5'),
  125. (16, '8', 'transition: all .4s', 'option_2_6'),
  126. (17, '8', 'transjakarta: 20s', 'option_2_7'),
  127. (18, '9', '.class:after', 'option_3_8'),
  128. (19, '9', ':after.class', 'option_3_9'),
  129. (20, '9', '.class:before', 'option_3_10'),
  130. (21, '9', ':before.class', 'option_3_11'),
  131. (22, '10', '&lt;link href=\"style.css\"&gt;', 'option_4_12'),
  132. (23, '10', '&lt;link href=\"style.css\" rel=\"stylesheet\"&gt;', 'option_4_13'),
  133. (24, '10', '&lt;link href=\"style.css\" rel=\"text/javascript\"&gt;', 'option_4_14'),
  134. (25, '12', 'Option', 'option_1_1'),
  135. (26, '12', 'Option', 'option_1_2'),
  136. (27, '13', 'Option', 'option_1_1'),
  137. (28, '13', 'Option', 'option_1_2'),
  138. (29, '14', 'Option', 'option_1_1'),
  139. (30, '14', 'Option', 'option_1_2'),
  140. (31, '15', 'Option', 'option_2_3'),
  141. (32, '16', 'Option', 'option_1_1'),
  142. (33, '16', 'Option', 'option_1_2'),
  143. (34, '17', 'Option', 'option_2_3'),
  144. (35, '19', 'Cascading Style Sheet', 'option_1_1'),
  145. (36, '19', 'Cascading Style Shit', 'option_1_2'),
  146. (37, '19', 'Cascading Sit Down', 'option_1_3'),
  147. (38, '20', 'transvision: 10s;', 'option_2_4'),
  148. (39, '20', 'transition: all .3s;', 'option_2_5'),
  149. (40, '20', 'transition: all .4s', 'option_2_6'),
  150. (41, '20', 'transjakarta: 20s', 'option_2_7'),
  151. (42, '21', '.class:after', 'option_3_8'),
  152. (43, '21', ':after.class', 'option_3_9'),
  153. (44, '21', '.class:before', 'option_3_10'),
  154. (45, '21', ':before.class', 'option_3_11'),
  155. (46, '22', '<link href=', 'option_4_12'),
  156. (47, '22', '<link href=', 'option_4_13'),
  157. (48, '22', '<link href=', 'option_4_14'),
  158. (49, '23', 'Option', 'option_5_15'),
  159. (50, '23', 'Option', 'option_5_16'),
  160. (51, '23', 'Option', 'option_5_17'),
  161. (52, '24', 'Option', 'option_6_18'),
  162. (53, '24', 'Option', 'option_6_19'),
  163. (54, '25', 'Option', 'option_7_20'),
  164. (55, '25', 'Option', 'option_7_21'),
  165. (56, '25', 'Option', 'option_7_22'),
  166. (57, '25', 'Option', 'option_7_23'),
  167. (58, '26', 'Option', 'option_8_24'),
  168. (59, '26', 'Option', 'option_8_25'),
  169. (60, '27', 'Option', 'option_9_26'),
  170. (61, '27', 'Option', 'option_9_27'),
  171. (62, '27', 'Option', 'option_9_28'),
  172. (63, '28', 'Option', 'option_10_29'),
  173. (64, '28', 'Option', 'option_10_30'),
  174. (65, '29', 'Option', 'option_11_31'),
  175. (66, '29', 'Option', 'option_11_32'),
  176. (67, '29', 'Option', 'option_11_33'),
  177. (68, '30', 'Option', 'option_12_34'),
  178. (69, '30', 'Option', 'option_12_35'),
  179. (70, '31', 'transvision: 10s;', 'option_2_4'),
  180. (71, '31', 'transition: all .3s;', 'option_2_5'),
  181. (72, '31', 'transition: all .4s', 'option_2_6'),
  182. (73, '31', 'transjakarta: 20s', 'option_2_7'),
  183. (74, '32', '.class:after', 'option_3_8'),
  184. (75, '32', ':after.class', 'option_3_9'),
  185. (76, '32', '.class:before', 'option_3_10'),
  186. (77, '32', ':before.class', 'option_3_11'),
  187. (78, '33', 'Cascading Style Sheet', 'option_1_1'),
  188. (79, '33', 'Cascading Style Shit', 'option_1_2'),
  189. (80, '33', 'Cascading Sit Down', 'option_1_3'),
  190. (81, '34', '<link href=', 'option_4_12'),
  191. (82, '34', '<link href=', 'option_4_13'),
  192. (83, '34', '<link href=', 'option_4_14'),
  193. (84, '35', 'Option', 'option_5_15'),
  194. (85, '35', 'Option', 'option_5_16'),
  195. (86, '35', 'Option', 'option_5_17'),
  196. (87, '36', 'Option', 'option_6_18'),
  197. (88, '36', 'Option', 'option_6_19'),
  198. (89, '37', 'Option', 'option_7_20'),
  199. (90, '37', 'Option', 'option_7_21'),
  200. (91, '37', 'Option', 'option_7_22'),
  201. (92, '37', 'Option', 'option_7_23'),
  202. (93, '38', 'Option', 'option_8_24'),
  203. (94, '38', 'Option', 'option_8_25'),
  204. (95, '39', 'Option', 'option_9_26'),
  205. (96, '39', 'Option', 'option_9_27'),
  206. (97, '39', 'Option', 'option_9_28'),
  207. (98, '40', 'Option', 'option_10_29'),
  208. (99, '40', 'Option', 'option_10_30'),
  209. (100, '41', 'Option', 'option_11_31'),
  210. (101, '41', 'Option', 'option_11_32'),
  211. (102, '41', 'Option', 'option_11_33'),
  212. (103, '42', 'Option', 'option_12_34'),
  213. (104, '42', 'Option', 'option_12_35');
  214.  
  215. --
  216. -- Indexes for dumped tables
  217. --
  218.  
  219. --
  220. -- Indexes for table `questions`
  221. --
  222. ALTER TABLE `questions`
  223.   ADD PRIMARY KEY (`id`);
  224.  
  225. --
  226. -- Indexes for table `question_list`
  227. --
  228. ALTER TABLE `question_list`
  229.   ADD PRIMARY KEY (`id`),
  230.   ADD KEY `questions_id` (`questions_id`);
  231.  
  232. --
  233. -- Indexes for table `question_options`
  234. --
  235. ALTER TABLE `question_options`
  236.   ADD PRIMARY KEY (`id`),
  237.   ADD KEY `question_list_id` (`question_list_id`);
  238.  
  239. --
  240. -- AUTO_INCREMENT for dumped tables
  241. --
  242.  
  243. --
  244. -- AUTO_INCREMENT for table `questions`
  245. --
  246. ALTER TABLE `questions`
  247.   MODIFY `id` INT(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;
  248. --
  249. -- AUTO_INCREMENT for table `question_list`
  250. --
  251. ALTER TABLE `question_list`
  252.   MODIFY `id` INT(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=43;
  253. --
  254. -- AUTO_INCREMENT for table `question_options`
  255. --
  256. ALTER TABLE `question_options`
  257.   MODIFY `id` INT(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=105;
  258. /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
  259. /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
  260. /*!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!