SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
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 utf8 */;
-- --------------------------------------------------------
-- Table structure for table `[[dbprefix]]admins`
CREATE TABLE `[[dbprefix]]admins` (
`login` varchar(30) NOT NULL DEFAULT '',
`password` varchar(40) NOT NULL DEFAULT '',
`real_name` varchar(120) NOT NULL DEFAULT '',
`email` varchar(50) NOT NULL DEFAULT '',
`language` varchar(5) NOT NULL DEFAULT '',
`privileges` mediumint(8) unsigned NOT NULL DEFAULT '0',
`last_login` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- Dumping data for table `[[dbprefix]]admins`
INSERT INTO `[[dbprefix]]admins` VALUES
('[[admin_username]]', '[[admin_pass]]', '', '[[admin_email]]', 'en', 1, '[[regtime]]');
-- --------------------------------------------------------
-- Table structure for table `[[dbprefix]]admin_log`
CREATE TABLE `[[dbprefix]]admin_log` (
`login` varchar(30) NOT NULL DEFAULT '',
`time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`operation` varchar(20) NOT NULL DEFAULT '',
`table` varchar(30) NOT NULL DEFAULT '',
`num_affected` tinyint(3) NOT NULL DEFAULT '0',
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
-- Table structure for table `[[dbprefix]]assignments`
CREATE TABLE `[[dbprefix]]assignments` (
`assignment_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
`course_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
`title` varchar(240) NOT NULL DEFAULT '',
`assign_to` mediumint(8) unsigned DEFAULT '0',
`date_due` datetime NOT NULL,
`date_cutoff` datetime NOT NULL,
`multi_submit` tinyint(4) DEFAULT '0',
PRIMARY KEY (`assignment_id`),
KEY `course_id` (`course_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
-- Table structure for table `[[dbprefix]]auto_enroll`
CREATE TABLE `[[dbprefix]]auto_enroll` (
`auto_enroll_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
`associate_string` varchar(10) NOT NULL,
`name` varchar(50) NOT NULL DEFAULT '',
PRIMARY KEY (`auto_enroll_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
-- Table structure for table `[[dbprefix]]auto_enroll_courses`
CREATE TABLE `[[dbprefix]]auto_enroll_courses` (
`auto_enroll_courses_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
`auto_enroll_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
`course_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`auto_enroll_courses_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
-- Table structure for table `[[dbprefix]]backups`
CREATE TABLE `[[dbprefix]]backups` (
`backup_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
`course_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
`date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`file_size` int(10) unsigned NOT NULL DEFAULT '0',
`system_file_name` varchar(50) NOT NULL DEFAULT '',
PRIMARY KEY (`backup_id`),
KEY `course_id` (`course_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
-- Table structure for table `[[dbprefix]]basiclti_content`
CREATE TABLE `[[dbprefix]]basiclti_content` (
`id` mediumint(10) NOT NULL AUTO_INCREMENT,
`content_id` mediumint(10) NOT NULL DEFAULT '0',
`course_id` mediumint(10) NOT NULL DEFAULT '0',
`toolid` varchar(32) NOT NULL DEFAULT '',
`preferheight` mediumint(4) NOT NULL DEFAULT '0',
`sendname` mediumint(1) NOT NULL DEFAULT '0',
`sendemailaddr` mediumint(1) NOT NULL DEFAULT '0',
`gradebook_test_id` mediumint(10) NOT NULL DEFAULT '0',
`allowroster` mediumint(1) NOT NULL DEFAULT '0',
`allowsetting` mediumint(1) NOT NULL DEFAULT '0',
`launchinpopup` mediumint(1) NOT NULL DEFAULT '0',
`debuglaunch` mediumint(1) NOT NULL DEFAULT '0',
`placementsecret` varchar(1023) DEFAULT NULL,
`timeplacementsecret` mediumint(10) NOT NULL DEFAULT '0',
`oldplacementsecret` varchar(1023) DEFAULT NULL,
PRIMARY KEY (`id`,`course_id`,`content_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
-- Table structure for table `[[dbprefix]]basiclti_tools`
CREATE TABLE `[[dbprefix]]basiclti_tools` (
`id` mediumint(10) NOT NULL AUTO_INCREMENT,
`toolid` varchar(32) NOT NULL,
`course_id` mediumint(10) NOT NULL DEFAULT '0',
`title` varchar(255) NOT NULL,
`description` varchar(1024) DEFAULT NULL,
`timecreated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`timemodified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`toolurl` varchar(1023) NOT NULL,
`resourcekey` varchar(1023) NOT NULL,
`password` varchar(1023) NOT NULL,
`preferheight` mediumint(4) NOT NULL DEFAULT '0',
`allowpreferheight` mediumint(1) NOT NULL DEFAULT '0',
`sendname` mediumint(1) NOT NULL DEFAULT '0',
`sendemailaddr` mediumint(1) NOT NULL DEFAULT '0',
`acceptgrades` mediumint(1) NOT NULL DEFAULT '0',
`allowroster` mediumint(1) NOT NULL DEFAULT '0',
`allowsetting` mediumint(1) NOT NULL DEFAULT '0',
`allowcustomparameters` mediumint(1) NOT NULL DEFAULT '0',
`organizationid` varchar(64) DEFAULT NULL,
`organizationurl` varchar(255) DEFAULT NULL,
`organizationdescr` varchar(255) DEFAULT NULL,
`launchinpopup` mediumint(1) NOT NULL DEFAULT '0',
`debuglaunch` mediumint(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`,`toolid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
-- Table structure for table `[[dbprefix]]blog_posts`
CREATE TABLE `[[dbprefix]]blog_posts` (
`post_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
`member_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
`owner_type` tinyint(3) unsigned NOT NULL DEFAULT '0',
`owner_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
`private` tinyint(3) unsigned NOT NULL DEFAULT '0',
`date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`num_comments` tinyint(3) unsigned NOT NULL DEFAULT '0',
`title` varchar(255) NOT NULL,
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
-- Table structure for table `[[dbprefix]]blog_posts_comments`
CREATE TABLE `[[dbprefix]]blog_posts_comments` (
`comment_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
`post_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
`member_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
`date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`private` tinyint(3) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`comment_id`),
KEY `post_id` (`post_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
-- Table structure for table `[[dbprefix]]blog_subscription`
CREATE TABLE `[[dbprefix]]blog_subscription` (
`group_id` mediumint(9) NOT NULL,
`member_id` mediumint(9) NOT NULL,
PRIMARY KEY (`group_id`,`member_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
-- Table structure for table `[[dbprefix]]calendar_bookmark`
CREATE TABLE `[[dbprefix]]calendar_bookmark` (
`memberid` int(11) DEFAULT NULL,
`ownerid` int(8) DEFAULT NULL,
`courseid` int(8) DEFAULT NULL,
`calname` varchar(256) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
-- Table structure for table `[[dbprefix]]calendar_events`
CREATE TABLE `[[dbprefix]]calendar_events` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` varchar(256) DEFAULT NULL,
`start` datetime DEFAULT NULL,
`end` datetime DEFAULT NULL,
`allDay` varchar(20) DEFAULT NULL,
`userid` int(8) DEFAULT NULL,
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
-- Table structure for table `[[dbprefix]]calendar_google_sync`
CREATE TABLE `[[dbprefix]]calendar_google_sync` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`token` varchar(256) DEFAULT NULL,
`userid` int(8) DEFAULT NULL,
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
-- Table structure for table `[[dbprefix]]calendar_notification`
CREATE TABLE `[[dbprefix]]calendar_notification` (
`memberid` int(11) DEFAULT NULL,
`status` int(8) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
-- Table structure for table `[[dbprefix]]config`
CREATE TABLE `[[dbprefix]]config` (
`name` char(30) NOT NULL DEFAULT '',
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- Dumping data for table `[[dbprefix]]config`
INSERT INTO `[[dbprefix]]config` VALUES
('encyclopedia', 'http://www.wikipedia.org'),
('dictionary', 'http://dictionary.reference.com/'),
('thesaurus', 'http://www.thesaurus.com/'),
('atlas', 'http://maps.google.ca/'),
('calculator', 'http://www.calculateforfree.com/'),
('note_taking', 'http://www.aypwip.org/webnote/'),
('abacas', 'http://www.mandarintools.com/abacus.html'),
('pa_max_memory_per_member', '50'),
('home_url', 'https://atutor.github.io'),
('custom_logo_foot_enabled', '1'),
('site_name', '[[site_name]]'),
('contact_email', '[[admin_email]]'),
('session_path', '[[relativeurl]]/');
-- --------------------------------------------------------
-- Table structure for table `[[dbprefix]]content`
CREATE TABLE `[[dbprefix]]content` (
`content_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
`course_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
`content_parent_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
`ordering` mediumint(8) NOT NULL DEFAULT '0',
`last_modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`revision` tinyint(3) unsigned NOT NULL DEFAULT '0',
`formatting` tinyint(4) NOT NULL DEFAULT '0',
`release_date` datetime NOT NULL,
`title` varchar(255) NOT NULL,
`use_customized_head` tinyint(4) NOT NULL,
`allow_test_export` tinyint(1) unsigned NOT NULL,
`content_type` tinyint(1) unsigned NOT NULL,
PRIMARY KEY (`content_id`),
KEY `course_id` (`course_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
-- Table structure for table `[[dbprefix]]content_forums_assoc`
CREATE TABLE `[[dbprefix]]content_forums_assoc` (
`content_id` int(10) unsigned NOT NULL,
`forum_id` int(10) unsigned NOT NULL,
PRIMARY KEY (`content_id`,`forum_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
-- Table structure for table `[[dbprefix]]content_prerequisites`
CREATE TABLE `[[dbprefix]]content_prerequisites` (
`content_id` mediumint(9) NOT NULL,
`type` varchar(50) NOT NULL DEFAULT '',
`item_id` mediumint(9) NOT NULL,
PRIMARY KEY (`content_id`,`type`,`item_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
-- Table structure for table `[[dbprefix]]content_tests_assoc`
CREATE TABLE `[[dbprefix]]content_tests_assoc` (
`content_id` int(10) unsigned NOT NULL,
`test_id` int(10) unsigned NOT NULL,
PRIMARY KEY (`content_id`,`test_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
-- Table structure for table `[[dbprefix]]courses`
CREATE TABLE `[[dbprefix]]courses` (
`course_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
`member_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
`cat_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
`content_packaging` enum('none','top','all') NOT NULL DEFAULT 'top',
`access` enum('public','protected','private') NOT NULL DEFAULT 'public',
`created_date` datetime NOT NULL,
`title` varchar(255) NOT NULL,
`course_dir_name` varchar(255) NOT NULL,
`notify` tinyint(4) NOT NULL DEFAULT '0',
`max_quota` varchar(30) NOT NULL DEFAULT '',
`max_file_size` varchar(30) NOT NULL DEFAULT '',
`hide` tinyint(4) NOT NULL DEFAULT '0',
`primary_language` varchar(5) NOT NULL DEFAULT '',
`rss` tinyint(4) NOT NULL DEFAULT '0',
`icon` varchar(75) NOT NULL DEFAULT '',
`side_menu` varchar(255) NOT NULL DEFAULT '',
`release_date` datetime NOT NULL,
`end_date` datetime NOT NULL,
`home_view` tinyint(4) NOT NULL DEFAULT '1',
PRIMARY KEY (`course_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
-- Table structure for table `[[dbprefix]]course_access`
CREATE TABLE `[[dbprefix]]course_access` (
`password` char(8) NOT NULL,
`course_id` mediumint(8) unsigned NOT NULL,
`expiry_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`enabled` tinyint(4) NOT NULL,
PRIMARY KEY (`password`),
UNIQUE KEY `course_id` (`course_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
-- Table structure for table `[[dbprefix]]course_cats`
CREATE TABLE `[[dbprefix]]course_cats` (
`cat_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
`cat_name` varchar(255) NOT NULL,
`cat_parent` mediumint(8) unsigned NOT NULL DEFAULT '0',
`theme` varchar(30) NOT NULL DEFAULT '',
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
-- Table structure for table `[[dbprefix]]course_enrollment`
CREATE TABLE `[[dbprefix]]course_enrollment` (
`member_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
`course_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
`approved` enum('y','n','a') NOT NULL DEFAULT 'n',
`privileges` int(10) unsigned NOT NULL DEFAULT '0',
`role` varchar(35) NOT NULL DEFAULT '',
`last_cid` mediumint(8) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`member_id`,`course_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
-- Table structure for table `[[dbprefix]]course_stats`
CREATE TABLE `[[dbprefix]]course_stats` (
`course_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
`login_date` date NOT NULL,
`guests` mediumint(8) unsigned NOT NULL DEFAULT '0',
`members` mediumint(8) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`course_id`,`login_date`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
-- Table structure for table `[[dbprefix]]external_resources`
CREATE TABLE `[[dbprefix]]external_resources` (
`resource_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
`course_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
`type` tinyint(3) unsigned NOT NULL DEFAULT '0',
`title` varchar(255) NOT NULL,
`author` varchar(150) NOT NULL,
`publisher` varchar(150) NOT NULL,
`date` varchar(20) NOT NULL DEFAULT '',
`id` varchar(50) NOT NULL DEFAULT '',
`url` varchar(255) NOT NULL DEFAULT '',
PRIMARY KEY (`resource_id`),
KEY `course_id` (`course_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
-- Table structure for table `[[dbprefix]]faq_entries`
CREATE TABLE `[[dbprefix]]faq_entries` (
`entry_id` mediumint(8) NOT NULL AUTO_INCREMENT,
It is recommended that you Edit text format, this type of Fix handles quite a lot in one request
