Skip to content

Instantly share code, notes, and snippets.

@sekanderb
Created July 6, 2021 03:26
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save sekanderb/6f58fc11edee6e19e8d31df3ed4ffd7c to your computer and use it in GitHub Desktop.
Save sekanderb/6f58fc11edee6e19e8d31df3ed4ffd7c to your computer and use it in GitHub Desktop.
If you are unable to create quiz options, please import this file into your database to create the necessary tables.
-- phpMyAdmin SQL Dump
-- version 5.0.2
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1:3306
-- Generation Time: May 29, 2021 at 05:03 AM
-- Server version: 5.7.31
-- PHP Version: 7.3.21
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;
--
-- Database: `tutor`
--
-- --------------------------------------------------------
--
-- Table structure for table `wp_tutor_earnings`
--
CREATE TABLE IF NOT EXISTS `wp_tutor_earnings` (
`earning_id` int(11) NOT NULL AUTO_INCREMENT,
`user_id` int(11) DEFAULT NULL,
`course_id` int(11) DEFAULT NULL,
`order_id` int(11) DEFAULT NULL,
`order_status` varchar(50) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
`course_price_total` decimal(16,2) DEFAULT NULL,
`course_price_grand_total` decimal(16,2) DEFAULT NULL,
`instructor_amount` decimal(16,2) DEFAULT NULL,
`instructor_rate` decimal(16,2) DEFAULT NULL,
`admin_amount` decimal(16,2) DEFAULT NULL,
`admin_rate` decimal(16,2) DEFAULT NULL,
`commission_type` varchar(20) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
`deduct_fees_amount` decimal(16,2) DEFAULT NULL,
`deduct_fees_name` varchar(250) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
`deduct_fees_type` varchar(20) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
`process_by` varchar(20) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
`created_at` datetime DEFAULT NULL,
PRIMARY KEY (`earning_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
-- --------------------------------------------------------
--
-- Table structure for table `wp_tutor_email_queue`
--
CREATE TABLE IF NOT EXISTS `wp_tutor_email_queue` (
`id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
`mail_to` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL,
`subject` text COLLATE utf8mb4_unicode_520_ci NOT NULL,
`message` text COLLATE utf8mb4_unicode_520_ci NOT NULL,
`headers` text COLLATE utf8mb4_unicode_520_ci NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
-- --------------------------------------------------------
--
-- Table structure for table `wp_tutor_gradebooks`
--
CREATE TABLE IF NOT EXISTS `wp_tutor_gradebooks` (
`gradebook_id` int(11) NOT NULL AUTO_INCREMENT,
`grade_name` varchar(50) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
`grade_point` varchar(20) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
`grade_point_to` varchar(20) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
`percent_from` int(3) DEFAULT NULL,
`percent_to` int(3) DEFAULT NULL,
`grade_config` longtext COLLATE utf8mb4_unicode_520_ci,
PRIMARY KEY (`gradebook_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
-- --------------------------------------------------------
--
-- Table structure for table `wp_tutor_gradebooks_results`
--
CREATE TABLE IF NOT EXISTS `wp_tutor_gradebooks_results` (
`gradebook_result_id` int(11) NOT NULL AUTO_INCREMENT,
`user_id` int(11) DEFAULT NULL,
`course_id` int(11) DEFAULT NULL,
`quiz_id` int(11) DEFAULT NULL,
`assignment_id` int(11) DEFAULT NULL,
`gradebook_id` int(11) DEFAULT NULL,
`result_for` varchar(50) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
`grade_name` varchar(50) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
`grade_point` varchar(20) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
`earned_grade_point` varchar(20) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
`earned_percent` int(3) DEFAULT NULL,
`generate_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`update_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
PRIMARY KEY (`gradebook_result_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
-- --------------------------------------------------------
--
-- Table structure for table `wp_tutor_quiz_attempts`
--
CREATE TABLE IF NOT EXISTS `wp_tutor_quiz_attempts` (
`attempt_id` int(11) NOT NULL AUTO_INCREMENT,
`course_id` int(11) DEFAULT NULL,
`quiz_id` int(11) DEFAULT NULL,
`user_id` int(11) DEFAULT NULL,
`total_questions` int(11) DEFAULT NULL,
`total_answered_questions` int(11) DEFAULT NULL,
`total_marks` decimal(9,2) DEFAULT NULL,
`earned_marks` decimal(9,2) DEFAULT NULL,
`attempt_info` text COLLATE utf8mb4_unicode_520_ci,
`attempt_status` varchar(50) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
`attempt_ip` varchar(250) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
`attempt_started_at` datetime DEFAULT NULL,
`attempt_ended_at` datetime DEFAULT NULL,
`is_manually_reviewed` int(1) DEFAULT NULL,
`manually_reviewed_at` datetime DEFAULT NULL,
PRIMARY KEY (`attempt_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
-- --------------------------------------------------------
--
-- Table structure for table `wp_tutor_quiz_attempt_answers`
--
CREATE TABLE IF NOT EXISTS `wp_tutor_quiz_attempt_answers` (
`attempt_answer_id` int(11) NOT NULL AUTO_INCREMENT,
`user_id` int(11) DEFAULT NULL,
`quiz_id` int(11) DEFAULT NULL,
`question_id` int(11) DEFAULT NULL,
`quiz_attempt_id` int(11) DEFAULT NULL,
`given_answer` longtext COLLATE utf8mb4_unicode_520_ci,
`question_mark` decimal(8,2) DEFAULT NULL,
`achieved_mark` decimal(8,2) DEFAULT NULL,
`minus_mark` decimal(8,2) DEFAULT NULL,
`is_correct` tinyint(4) DEFAULT NULL,
PRIMARY KEY (`attempt_answer_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
-- --------------------------------------------------------
--
-- Table structure for table `wp_tutor_quiz_questions`
--
CREATE TABLE IF NOT EXISTS `wp_tutor_quiz_questions` (
`question_id` int(11) NOT NULL AUTO_INCREMENT,
`quiz_id` int(11) DEFAULT NULL,
`question_title` text COLLATE utf8mb4_unicode_520_ci,
`question_description` longtext COLLATE utf8mb4_unicode_520_ci,
`question_type` varchar(50) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
`question_mark` decimal(9,2) DEFAULT NULL,
`question_settings` longtext COLLATE utf8mb4_unicode_520_ci,
`question_order` int(11) DEFAULT NULL,
PRIMARY KEY (`question_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
-- --------------------------------------------------------
--
-- Table structure for table `wp_tutor_quiz_question_answers`
--
CREATE TABLE IF NOT EXISTS `wp_tutor_quiz_question_answers` (
`answer_id` int(11) NOT NULL AUTO_INCREMENT,
`belongs_question_id` int(11) DEFAULT NULL,
`belongs_question_type` varchar(250) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
`answer_title` text COLLATE utf8mb4_unicode_520_ci,
`is_correct` tinyint(4) DEFAULT NULL,
`image_id` int(11) DEFAULT NULL,
`answer_two_gap_match` text COLLATE utf8mb4_unicode_520_ci,
`answer_view_format` varchar(250) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
`answer_settings` text COLLATE utf8mb4_unicode_520_ci,
`answer_order` int(11) DEFAULT '0',
PRIMARY KEY (`answer_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
-- --------------------------------------------------------
--
-- Table structure for table `wp_tutor_withdraws`
--
CREATE TABLE IF NOT EXISTS `wp_tutor_withdraws` (
`withdraw_id` int(11) NOT NULL AUTO_INCREMENT,
`user_id` int(11) DEFAULT NULL,
`amount` decimal(16,2) DEFAULT NULL,
`method_data` text COLLATE utf8mb4_unicode_520_ci,
`status` varchar(50) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
`updated_at` datetime DEFAULT NULL,
`created_at` datetime DEFAULT NULL,
PRIMARY KEY (`withdraw_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
COMMIT;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
@geovane890
Copy link

I import the file, but it shows a message 0 query executed, what can be pu how to import correctly? I just imported the zip

@sekanderb
Copy link
Author

@geovane890 this snippet is made 2 years back, bro! This is outdated right now, I guess. Please send and email to support for help.

@lw-development
Copy link

@geovane890 Were you able to find a fix for this after speaking to support? Thank you

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment