· 8 years ago · May 27, 2018, 07:34 PM
1/* Error with snippets directory: The specified path was not found */
2/* Delimiter changed to ; */
3/* Connecting to 127.0.0.1 via MySQL (TCP/IP), username root, using password: Yes ... */
4SELECT CONNECTION_ID();
5/* Connected. Thread-ID: 8 */
6/* Characterset: utf8mb4 */
7SHOW STATUS;
8SHOW VARIABLES;
9SHOW DATABASES;
10/* Entering session "Unnamed" */
11-- --------------------------------------------------------
12-- Host: 127.0.0.1
13-- Server version: 10.2.14-MariaDB - mariadb.org binary distribution
14-- Server OS: Win64
15-- HeidiSQL Version: 9.4.0.5125
16-- --------------------------------------------------------
17
18/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
19/*!40101 SET NAMES utf8 */;
20/*!50503 SET NAMES utf8mb4 */;
21/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
22/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
23-- Dumping database structure for pwa_questions
24CREATE DATABASE IF NOT EXISTS `pwa_questions` /*!40100 DEFAULT CHARACTER SET latin1 */;
25USE `pwa_questions`;
26-- Dumping structure for table pwa_questions.questions
27CREATE TABLE IF NOT EXISTS `questions` (
28 `id` int(7) unsigned NOT NULL AUTO_INCREMENT,
29 `category` varchar(30) NOT NULL,
30 `first_alternative` varchar(140) NOT NULL,
31 `first_alternative_count` int(6) NOT NULL DEFAULT 0,
32 `second_alternative` varchar(140) NOT NULL,
33 `second_alternative_count` int(6) NOT NULL DEFAULT 0,
34 `created_by` int(6) NOT NULL DEFAULT 0,
35 `created_at` date NOT NULL,
36 PRIMARY KEY (`id`)
37) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;
38-- Dumping data for table pwa_questions.questions: ~6 rows (approximately)
39/*!40000 ALTER TABLE `questions` DISABLE KEYS */;
40REPLACE INTO `questions` (`id`, `category`, `first_alternative`, `first_alternative_count`, `second_alternative`, `second_alternative_count`, `created_by`, `created_at`) VALUES
41 (1, 'food', 'Pepperoni', 0, 'Salami', 0, 0, '2018-05-05'),
42 (2, 'food', 'Hamburger', 0, 'Pizza', 0, 0, '2018-05-08'),
43 (3, 'food', 'Pasta', 0, 'Wok', 0, 0, '2018-05-08'),
44 (4, 'food', 'Wine', 0, 'Beer', 0, 0, '2018-05-08'),
45 (5, 'sports', 'Tennis', 2, 'Golf', 0, 0, '2018-05-08'),
46 (6, 'sports', 'Soccer', 1, 'Football', 0, 0, '2018-05-08'),
47 (7, 'sports', 'Lifting', 4, 'Running', 0, 0, '2018-05-08');
48/*!40000 ALTER TABLE `questions` ENABLE KEYS */;
49/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
50/*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
51/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;