



--
-- Database: `aTutor224`
--

-- --------------------------------------------------------

--
-- 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,
  PRIMARY KEY (`login`)
) 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',
  `details` text,
  KEY `login` (`login`)
) 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,
  `description` text,
  `file_size` int(10) unsigned NOT NULL DEFAULT '0',
  `system_file_name` varchar(50) NOT NULL DEFAULT '',
  `file_name` text,
  `contents` text,
  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',
  `customparameters` text,
  `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,
  `setting` text,
  `xmlimport` text,
  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',
  `customparameters` text,
  `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,
  `body` text,
  PRIMARY KEY (`post_id`)
) 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',
  `comment` text,
  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,
  PRIMARY KEY (`id`)
) 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,
  `calids` text,
  PRIMARY KEY (`id`)
) 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 '',
  `value` text,
  PRIMARY KEY (`name`)
) 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]]'),
('set_utf8', '1'),
('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,
  `keywords` text,
  `content_path` text,
  `title` varchar(255) NOT NULL,
  `text` text,
  `head` text,
  `use_customized_head` tinyint(4) NOT NULL,
  `test_message` text,
  `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,
  `description` text,
  `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',
  `copyright` text,
  `primary_language` varchar(5) NOT NULL DEFAULT '',
  `rss` tinyint(4) NOT NULL DEFAULT '0',
  `icon` varchar(75) NOT NULL DEFAULT '',
  `home_links` text,
  `main_links` text,
  `side_menu` varchar(255) NOT NULL DEFAULT '',
  `release_date` datetime NOT NULL,
  `end_date` datetime NOT NULL,
  `banner` text,
  `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 '',
  PRIMARY KEY (`cat_id`)
) 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 '',
  `comments` text,
  `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,
  `topic_id` mediumint(8) NOT NULL DEFAULT '0',
  `revised_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `approved` tinyint(4) NOT NULL DEFAULT '0',
  `question` text,
  `answer` text,
  PRIMARY KEY (`entry_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]faq_topics`
--

CREATE TABLE `[[dbprefix]]faq_topics` (
  `topic_id` mediumint(8) NOT NULL AUTO_INCREMENT,
  `course_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `name` text,
  PRIMARY KEY (`topic_id`),
  KEY `course_id` (`course_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]feeds`
--

CREATE TABLE `[[dbprefix]]feeds` (
  `feed_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `url` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`feed_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]fha_student_tools`
--

CREATE TABLE `[[dbprefix]]fha_student_tools` (
  `course_id` mediumint(8) unsigned NOT NULL,
  `links` text,
  `home_view` tinyint(4) NOT NULL DEFAULT '1',
  PRIMARY KEY (`course_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]files`
--

CREATE TABLE `[[dbprefix]]files` (
  `file_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `owner_type` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `owner_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `member_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `folder_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `parent_file_id` mediumint(8) 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',
  `num_revisions` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `file_name` varchar(80) NOT NULL DEFAULT '',
  `file_size` int(11) NOT NULL DEFAULT '0',
  `description` text,
  PRIMARY KEY (`file_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]files_comments`
--

CREATE TABLE `[[dbprefix]]files_comments` (
  `comment_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `file_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,
  `comment` text,
  PRIMARY KEY (`comment_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]file_storage_groups`
--

CREATE TABLE `[[dbprefix]]file_storage_groups` (
  `group_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`group_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]folders`
--

CREATE TABLE `[[dbprefix]]folders` (
  `folder_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `parent_folder_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',
  `title` varchar(120) NOT NULL DEFAULT '',
  PRIMARY KEY (`folder_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]forums`
--

CREATE TABLE `[[dbprefix]]forums` (
  `forum_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(240) NOT NULL DEFAULT '',
  `description` text,
  `num_topics` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `num_posts` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `last_post` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `mins_to_edit` smallint(5) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`forum_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]forums_accessed`
--

CREATE TABLE `[[dbprefix]]forums_accessed` (
  `post_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `member_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `last_accessed` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `subscribe` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`post_id`,`member_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]forums_courses`
--

CREATE TABLE `[[dbprefix]]forums_courses` (
  `forum_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `course_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`forum_id`,`course_id`),
  KEY `course_id` (`course_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]forums_groups`
--

CREATE TABLE `[[dbprefix]]forums_groups` (
  `forum_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `group_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`forum_id`,`group_id`),
  KEY `group_id` (`group_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]forums_subscriptions`
--

CREATE TABLE `[[dbprefix]]forums_subscriptions` (
  `forum_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `member_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`forum_id`,`member_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]forums_threads`
--

CREATE TABLE `[[dbprefix]]forums_threads` (
  `post_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `parent_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `member_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `forum_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `last_comment` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `num_comments` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `subject` varchar(255) NOT NULL,
  `body` text,
  `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `locked` tinyint(4) NOT NULL DEFAULT '0',
  `sticky` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`post_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]glossary`
--

CREATE TABLE `[[dbprefix]]glossary` (
  `word_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `course_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `word` varchar(240) NOT NULL DEFAULT '',
  `definition` text,
  `related_word_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`word_id`),
  KEY `course_id` (`course_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]gm_badges`
--

CREATE TABLE `[[dbprefix]]gm_badges` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `course_id` int(11) NOT NULL DEFAULT '0',
  `alias` varchar(32) NOT NULL DEFAULT '',
  `title` varchar(64) NOT NULL DEFAULT '',
  `description` text,
  `image_url` varchar(96) DEFAULT NULL,
  PRIMARY KEY (`id`,`course_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=27 ;

--
-- Dumping data for table `[[dbprefix]]gm_badges`
--

INSERT INTO `[[dbprefix]]gm_badges` VALUES
(7, 0, 'upload_file_badge', 'Good use of File Storage', 'You have figured out how to upload files into the course.', 'mods/_standard/gameme/images/badges/arrow.png'),
(8, 0, 'create_file_badge', 'Create your own files', 'You learned how to create new files in File Storage.', 'mods/_standard/gameme/images/badges/doc.png'),
(2, 0, 'profile_viewed_badge', 'You''re getting noticed', '25 people have viewed your profile', 'mods/_standard/gameme/images/badges/eye.png'),
(1, 0, 'profile_view_badge', 'You know your classmates', 'You have viewed 25 of your classmates'' profiles', 'mods/_standard/gameme/images/badges/id.png'),
(4, 0, 'prefs_update_badge', 'You found your settings', 'You know how to update your personal preference, and configure ATutor to your liking. ', 'mods/_standard/gameme/images/badges/mixer.png'),
(3, 0, 'profile_pic_upload_badge', 'You have a profile pic', 'People are more likely to interact when you have a profile picture.', 'mods/_standard/gameme/images/badges/adduser.png'),
(5, 0, 'read_page_badge', 'You are well on your way', 'You have read 25 pages in the course. Keep going!', 'mods/_standard/gameme/images/badges/silver.png'),
(6, 0, 'new_folder_badge', 'You''re organized', 'You know how to create folder in File Storage to organize your files.', 'mods/_standard/gameme/images/badges/folder.png'),
(9, 0, 'forum_view_badge', 'Discussion Reader', 'You are doing a great job reading through discussion posts in the forums.', 'mods/_standard/gameme/images/badges/bronze.png'),
(10, 0, 'forum_post_badge', 'Discussion Poster', 'You have been a great contributor in the discussion forums.', 'mods/_standard/gameme/images/badges/gold.png'),
(11, 0, 'forum_reply_badge', 'Great Feedback', 'You have been replying to others posts in the discussion forums', 'mods/_standard/gameme/images/badges/conversation.png'),
(12, 0, 'blog_add_badge', 'Blog Poster', 'You''re making great use of the course blog. Keep on posting!', 'mods/_standard/gameme/images/badges/email.png'),
(13, 0, 'blog_comment_badge', 'Blog Commenter', 'You have been commenting on other (or your own) blog posts. Keep on commenting.', 'mods/_standard/gameme/images/badges/lightbulb.png'),
(14, 0, 'chat_login_badge', 'Chat Login', 'You are making good use of the ATutor chat, a great place to interact live with your classmates', 'mods/_standard/gameme/images/badges/chat.png'),
(15, 0, 'chat_post_badge', 'Chat Contributor', 'You are posting message to the chat. Keep on chatting!', 'mods/_standard/gameme/images/badges/bolt.png'),
(16, 0, 'link_add_badge', 'Link Poster', 'You''ve been adding links to the course resources. Keep adding!', 'mods/_standard/gameme/images/badges/link.png'),
(17, 0, 'photo_create_album_badge', 'Create Album', 'You learned how to create an album in the Photo Gallery. Keep creating albums to share.', 'mods/_standard/gameme/images/badges/news.png'),
(18, 0, 'photo_create_album_badge', 'Create Albums', 'You have created several photo albums. Perhaps photograhpy is your calling!', 'mods/_standard/gameme/images/badges/brush.png'),
(19, 0, 'photo_upload_badge', 'Photo Uploader', 'You have been uploading photos into your photo gallery. Keep adding.', 'mods/_standard/gameme/images/badges/picture.png'),
(20, 0, 'photo_comment_badge', 'Photo comments', 'You have been commenting you yours and others photos. Keep commenting for bonus points;', 'mods/_standard/gameme/images/badges/like.png'),
(21, 0, 'photo_album_comment', 'Album Comment', 'Most people comment on photo, but you commenteed on an album for bonus points.', 'mods/_standard/gameme/images/badges/cards.png'),
(22, 0, 'photo_description_badge', 'Photo Describer', 'Exellent job providing descriptions for you photos. ', 'mods/_standard/gameme/images/badges/feather.png'),
(23, 0, 'photo_alt_text', 'Accessibility Aware', 'Its great you are providing Alt text for you image, to make them accessible to people with disabilities. Secret bonus points if you continue adding Alt text to new images in your gallery.', 'mods/_standard/gameme/images/badges/heart.png'),
(24, 0, 'login_badge', 'Returning Visitor', 'You have come back quite a few times now. Keep on visiting the course for bonus points.', 'mods/_standard/gameme/images/badges/hot.png'),
(25, 0, 'logout_badge', 'Security Conscious', 'You have been logging out, rather than leaving or allowing your session to time out. This helps improve security.', 'mods/_standard/gameme/images/badges/lock.png'),
(26, 0, 'welcome_badge', 'Welcome', 'Welcome to the course. Finding your way here earned you your first badge. Get busy with the course to earn points and collect more badges.', 'mods/_standard/gameme/images/badges/acorn.png');

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]gm_events`
--

CREATE TABLE `[[dbprefix]]gm_events` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `course_id` int(11) NOT NULL DEFAULT '0',
  `alias` varchar(32) NOT NULL DEFAULT '',
  `description` text,
  `allow_repetitions` tinyint(1) DEFAULT '1',
  `reach_required_repetitions` int(11) DEFAULT NULL,
  `max_points` int(11) DEFAULT NULL,
  `id_each_badge` int(11) DEFAULT NULL COMMENT '	',
  `id_reach_badge` int(11) DEFAULT NULL,
  `each_points` int(11) DEFAULT NULL,
  `reach_points` int(11) DEFAULT NULL,
  `each_callback` varchar(64) DEFAULT NULL,
  `reach_callback` varchar(64) DEFAULT NULL,
  `reach_message` varchar(1500) DEFAULT NULL,
  PRIMARY KEY (`id`,`course_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=40 ;

--
-- Dumping data for table `[[dbprefix]]gm_events`
--

INSERT INTO `[[dbprefix]]gm_events` VALUES
(2, 0, 'profile_view', 'Profile view other''s', 0, 10, NULL, NULL, 1, 10, 25, NULL, 'GmCallbacksClass::ProfileViewReachCallback', 'Congratulations, you have received a new badge for getting to know your classmates by viewing their profiles. You can earn additional points by sending a private message to a person through their profile page.'),
(3, 0, 'profile_viewed', 'Profile viewed by others', 0, 25, NULL, NULL, 2, 25, 50, NULL, 'GmCallbacksClass::ProfileViewedReachCallback', 'Congratulations, you have received a new badge because lots of people have been viewing your profile.'),
(4, 0, 'sent_message', 'Send a private message', 0, 10, NULL, NULL, NULL, 25, 50, NULL, NULL, NULL),
(5, 0, 'profile_pic_upload', 'Upload a profile picture', 0, 1, NULL, NULL, 3, 100, 200, NULL, 'GmCallbacksClass::ProfilePicUploadCallback', 'Congratulations, you have received a new badge for adding a profile picture. Update your profile picture occassionally to receive additional points.'),
(6, 0, 'read_list_view', 'View reading list details', 0, 15, NULL, NULL, NULL, 25, 50, NULL, NULL, NULL),
(7, 0, 'prefs_update', 'Update personal preferences', 0, 1, NULL, NULL, 4, 25, 250, NULL, 'GmCallbacksClass::PreferencesUpdateCallback', 'Congratulations, you have received a new badge for updating your personal preferences.'),
(8, 0, 'read_page', 'Pages viewed', 0, 25, NULL, NULL, 5, 10, 25, NULL, 'GmCallbacksClass::ReadPageCallback', 'Congratulations, you have received a new badge for getting a good amount of course reading done!'),
(9, 0, 'new_folder', 'Create file storage folder', 0, 1, NULL, NULL, 6, 25, 100, NULL, 'GmCallbacksClass::FileStorageFolderCallback', 'Congratulations, you have received a new badge for learning how to create folders to organize your files. You can also earn points and badges by adding files to those folders'),
(10, 0, 'upload_file', 'Upload to file storage', 0, 5, NULL, NULL, 7, 25, 50, NULL, 'GmCallbacksClass::UploadFilesCallback', 'Congratulations, you have received a new badge for learning how to use file storage to store your files. Create additional folders to organize your files for additional points and badges.'),
(11, 0, 'create_file', 'Create file in file storage', 0, 2, NULL, NULL, 8, 50, 100, NULL, 'GmCallbacksClass::CreateFilesCallback', 'Congratulations, you have received a new badge for learning how to create new files in file storage.'),
(12, 0, 'file_comment', 'Comment on a file storage file', 0, 5, NULL, NULL, NULL, 25, 50, NULL, NULL, NULL),
(13, 0, 'file_description', 'Provide description for file storage file', 0, 5, NULL, NULL, NULL, 50, 100, NULL, NULL, NULL),
(14, 0, 'forum_view', 'Forum discussions viewed', 0, 25, NULL, NULL, 9, 25, 150, NULL, 'GmCallbacksClass::ForumViewCallback', 'Congratulations, you have received a new badge for keeping up with reading forum posts. Continue reading forum posts, start new threads, and reply to others posts to earn additional points and badges.'),
(15, 0, 'forum_post', 'Forum posts', 0, 10, NULL, NULL, 10, 50, 100, NULL, 'GmCallbacksClass::ForumPostsCallback', 'Congratulations, you have received a new badge for contributing new threads to the discussion forums. Continue reading forum posts, start new threads, and reply to others posts to earn additional points and badges.'),
(16, 0, 'forum_reply', 'Forum replies', 0, 5, NULL, NULL, 11, 75, 150, NULL, 'GmCallbacksClass::ForumReplyCallback', 'Congratulations, you have received a new badge for contributing good feedback to discussion forums. Continue reading forum posts, start new threads, and reply to others posts to earn additional points and badges.'),
(17, 0, 'read_time', 'Page view time', 0, 10, NULL, NULL, NULL, 25, 100, NULL, NULL, NULL),
(18, 0, 'blog_add', 'Blob posts', 0, 10, NULL, NULL, 12, 25, 100, NULL, 'GmCallbacksClass::BlogAddCallback', 'Congratulations, you have received a new badge for contributing a good collection of blog posts. Continue adding to your blog, and comments on others'' blogs to earn additional points and badges.'),
(19, 0, 'blog_comment', 'Blog comments', 0, 2, NULL, NULL, 13, 25, 100, NULL, 'GmCallbacksClass::BlogCommentsCallback', 'Congratulations, you have received a new badge for contributing good feedback, and commenting on blog posts. Continue posting to your blog, and commenting on others'' blog posts to earn additional points.'),
(20, 0, 'blog_view', 'Blog views', 0, 15, NULL, NULL, NULL, 15, 50, NULL, NULL, NULL),
(21, 0, 'blog_post_view', 'Blog posts viewed', 0, 10, NULL, NULL, NULL, 10, 25, NULL, NULL, NULL),
(22, 0, 'chat_login', 'Chat login', 0, 10, NULL, NULL, 14, 5, 100, NULL, 'GmCallbacksClass::ChatLoginCallback', 'Congratulations, you have received a new badge for logging into the chat regularly. Just using the chat helps accumulate points.'),
(23, 0, 'chat_post', 'Chat posts', 0, 50, NULL, NULL, 15, 5, 100, NULL, 'GmCallbacksClass::ChatPostCallback', 'Congratulations, you have received a new badge for keeping conversation going in the chat room. Returning to the chat room regularly earns additional points.'),
(24, 0, 'link_add', 'Links added', 0, 2, NULL, NULL, 16, 25, 50, NULL, 'GmCallbacksClass::LinkAddCallback', 'Congratulations, you have received a new badge for making a good contribution to the course links. View links others have posted to earn additional points.'),
(25, 0, 'link_view', 'Links followed', 0, 15, NULL, NULL, NULL, 10, 25, NULL, NULL, NULL),
(26, 0, 'poll_post', 'Polls posted', 0, 2, NULL, NULL, NULL, 25, 75, NULL, NULL, NULL),
(27, 0, 'photo_create_album', 'Photo album created', 1, 1, NULL, 17, NULL, 50, 100, NULL, 'GmCallbacksClass::PhotoAlbumCallback', 'Congratulations, you have received a new badge for creating a photo album. Continue adding photos to earn more points and badges.'),
(28, 0, 'photo_upload', 'Photo uploads', 0, 10, NULL, NULL, 19, 25, 50, NULL, 'GmCallbacksClass::PhotoUploadCallback', 'Congratulations, you have received a new badge for uploading a good collection of photos. Continue adding photos to earn more points. Create additional albums to organize your photos for bonus points.'),
(29, 0, 'photo_view_album', 'View photo album', 0, 5, NULL, NULL, NULL, 10, 30, NULL, NULL, NULL),
(30, 0, 'photo_view_photo', 'View photo', 0, 25, NULL, NULL, NULL, 10, 25, NULL, NULL, NULL),
(31, 0, 'photo_comment', 'Comment on a photo', 0, 2, NULL, NULL, 20, 25, 75, NULL, 'GmCallbacksClass::PhotoCommentCallback', 'Congratulations, you have received a new badge for providing comments on yours, and others photos. Continue commenting to earn additional points. You can also comment on photo albums as a whole, to earn bonus points.'),
(32, 0, 'photo_album_comment', 'Comment on an album', 0, 5, NULL, NULL, 21, 50, 150, NULL, 'GmCallbacksClass::PhotoAlbumCommentCallback', 'Congratulations, you have received a new badge for providing comments on your''s, and other''s albums. Continue commenting about albums for additional points.'),
(33, 0, 'photo_description', 'Photo descriptions provided', 0, 5, NULL, NULL, 22, 25, 150, NULL, 'GmCallbacksClass::PhotoDescriptionCallback', 'Congratulations, you have received a new badge for providing descriptions for your photos. Add alternative text to make your photos accessible to blind classmates, and earn bonus points and a badge.'),
(34, 0, 'photo_alt_text', 'Photo Alt texts provided', 0, 2, NULL, NULL, 23, 50, 250, NULL, 'GmCallbacksClass::PhotoAltTextCallback', 'Congratulations, you have received a new badge for providing alternative text for your photos. This makes photos accessible to blind classmates using a screen reader to access the course. Providing descriptions for your photos can also earn points, and a badge.'),
(35, 0, 'photo_create_albums', 'Photo albums created', 0, 3, NULL, NULL, 18, 50, 100, NULL, 'GmCallbacksClass::PhotoAlbumsCallback', 'Congratulations, you have received a new badge for creating multiple photo albums to organize your photos. Continue adding photos to earn more points.'),
(38, 0, 'logout', 'Logout (not timeout)', 0, 2, 250, NULL, 25, 10, 25, NULL, 'GmCallbacksClass::LogoutReachCallback', 'Congratulations, you have received a new badge for logging out properly, instead of leaving or letting your session timeout, maintaining your privacy and security. '),
(39, 0, 'welcome', 'First course login', 1, 1, 250, NULL, 26, 250, NULL, NULL, 'GmCallbacksClass::WelcomeCallback', 'Welcome to the course. You have earned your first badge by successfully logging in. Continue earning badges by using the features in the course, and participating in course activities.<br /><br />By participating in the course you can also earn points and advance through levels as your points grow. Follow the leader board to see your position among others in the course. Watch for hints after earning a badge, for earning additional badges and bonus points.'),
(1, 0, 'login', 'Login', 0, 25, NULL, NULL, 24, 10, 100, NULL, 'GmCallbacksClass::LoginReachCallback', 'Congratulations, you have received a new badge for logging into the course many times. You can also earn points by logging out of the course properly, clicking the logout link, instead of just leaving or letting your session timeout.'),
(37, 0, 'submit_test', 'Submit a test or quiz', 0, 5, NULL, NULL, NULL, 100, 250, NULL, NULL, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]gm_levels`
--

CREATE TABLE `[[dbprefix]]gm_levels` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `course_id` int(11) NOT NULL DEFAULT '0',
  `title` varchar(64) NOT NULL DEFAULT '',
  `description` text,
  `points` int(11) NOT NULL,
  `icon` varchar(25) DEFAULT NULL,
  PRIMARY KEY (`id`,`course_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=12 ;

--
-- Dumping data for table `[[dbprefix]]gm_levels`
--

INSERT INTO `[[dbprefix]]gm_levels` VALUES
(1, 0, 'Level 0', 'Welcome to the course', 0, 'star_empty_lg.png'),
(2, 0, 'Level 1', '1000 points passed', 1000, 'star_white_lg.png'),
(3, 0, 'Level 2', '2500 points passed', 2500, 'star_yellow_lg.png'),
(4, 0, 'Level 3', '5000 points passed', 5000, 'star_red_lg.png'),
(5, 0, 'Level 4', '7500 points passed', 7500, 'star_green_lg.png'),
(6, 0, 'Level 5', '10000 points passed: ', 10000, 'star_blue_lg.png'),
(7, 0, 'Level 6', '20000 points passed', 20000, 'star_black_lg.png'),
(8, 0, 'Level 7', '25000 points passed: Accomplished status, Bronze Badge', 25000, 'star_bronze_lg.png'),
(9, 0, 'Level 8', '35000 point passed: Intermediate status, Silver Badge', 35000, 'star_silver_lg.png'),
(10, 0, 'Level 9', '50000 points passed: Advanced status: Gold Badge', 50000, 'star_gold_lg.png'),
(11, 0, 'Level 10', '65000 point passed: Highest Honor: Platinum Badge', 65000, 'star_platinum_lg.png');

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]gm_options`
--

CREATE TABLE `[[dbprefix]]gm_options` (
  `id` int(11) unsigned NOT NULL,
  `course_id` int(11) unsigned NOT NULL,
  `gm_option` varchar(25) NOT NULL DEFAULT '',
  `value` int(11) unsigned DEFAULT NULL,
  PRIMARY KEY (`course_id`,`gm_option`),
  KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]gm_user_alerts`
--

CREATE TABLE `[[dbprefix]]gm_user_alerts` (
  `id_user` int(10) unsigned NOT NULL,
  `course_id` int(10) unsigned DEFAULT NULL,
  `id_badge` int(10) unsigned DEFAULT NULL,
  `id_level` int(10) unsigned DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]gm_user_badges`
--

CREATE TABLE `[[dbprefix]]gm_user_badges` (
  `id_user` int(10) unsigned NOT NULL,
  `id_badge` int(10) unsigned NOT NULL,
  `badges_counter` int(10) unsigned NOT NULL,
  `grant_date` datetime NOT NULL,
  `course_id` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id_user`,`id_badge`,`course_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]gm_user_events`
--

CREATE TABLE `[[dbprefix]]gm_user_events` (
  `id_user` int(10) unsigned NOT NULL,
  `id_event` int(10) unsigned NOT NULL,
  `event_counter` int(10) unsigned NOT NULL,
  `points_counter` int(10) unsigned NOT NULL,
  `course_id` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id_user`,`id_event`,`course_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]gm_user_logs`
--

CREATE TABLE `[[dbprefix]]gm_user_logs` (
  `id_user` int(10) unsigned NOT NULL,
  `course_id` int(10) unsigned DEFAULT NULL,
  `id_event` int(10) unsigned DEFAULT NULL,
  `event_date` datetime NOT NULL,
  `id_badge` int(10) unsigned DEFAULT NULL,
  `id_level` int(10) unsigned DEFAULT NULL,
  `points` int(10) unsigned DEFAULT NULL,
  KEY `id_user` (`id_user`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]gm_user_scores`
--

CREATE TABLE `[[dbprefix]]gm_user_scores` (
  `id_user` int(10) unsigned NOT NULL,
  `points` int(10) unsigned NOT NULL,
  `id_level` int(10) unsigned NOT NULL,
  `course_id` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id_user`,`course_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]gradebook_detail`
--

CREATE TABLE `[[dbprefix]]gradebook_detail` (
  `gradebook_test_id` mediumint(8) unsigned NOT NULL,
  `member_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `grade` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`gradebook_test_id`,`member_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]gradebook_tests`
--

CREATE TABLE `[[dbprefix]]gradebook_tests` (
  `gradebook_test_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `id` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT 'Values: 0, tests.test_id or assignments.assignment_id. 0 for external tests/assignments. tests.test_id for ATutor tests, assignments.assignment_id for ATutor assignments.',
  `type` varchar(50) NOT NULL DEFAULT '' COMMENT 'Values: ATutor Test, ATutor Assignment, External',
  `course_id` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT 'Values: 0 or courses.course_id. Only has value for external tests/assignments. When ATutor internal assignments/tests/surveys, always 0.',
  `title` varchar(255) NOT NULL DEFAULT '' COMMENT 'Values: Null or test name. Always null if ATutor internal assignments/tests/surveys.',
  `due_date` datetime NOT NULL,
  `grade_scale_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`gradebook_test_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]grade_scales`
--

CREATE TABLE `[[dbprefix]]grade_scales` (
  `grade_scale_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `member_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `scale_name` varchar(255) NOT NULL DEFAULT '',
  `created_date` datetime NOT NULL,
  PRIMARY KEY (`grade_scale_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;

--
-- Dumping data for table `[[dbprefix]]grade_scales`
--

INSERT INTO `[[dbprefix]]grade_scales` VALUES
(1, 0, 'Letter Grade', '[[regtime]]'),
(2, 0, 'Competency 1', '[[regtime]]'),
(3, 0, 'Competency 2', '[[regtime]]');

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]grade_scales_detail`
--

CREATE TABLE `[[dbprefix]]grade_scales_detail` (
  `grade_scale_id` mediumint(8) unsigned NOT NULL,
  `scale_value` varchar(50) NOT NULL DEFAULT '',
  `percentage_from` mediumint(9) NOT NULL DEFAULT '0',
  `percentage_to` mediumint(9) NOT NULL DEFAULT '0',
  PRIMARY KEY (`grade_scale_id`,`scale_value`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `[[dbprefix]]grade_scales_detail`
--

INSERT INTO `[[dbprefix]]grade_scales_detail` VALUES
(1, 'A+', 90, 100),
(1, 'A', 80, 89),
(1, 'B', 70, 79),
(1, 'C', 60, 69),
(1, 'D', 50, 59),
(1, 'E', 0, 49),
(2, 'Pass', 75, 100),
(2, 'Fail', 0, 74),
(3, 'Excellent', 80, 100),
(3, 'Good', 70, 79),
(3, 'Adequate', 60, 69),
(3, 'Inadequate', 0, 59);

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]groups`
--

CREATE TABLE `[[dbprefix]]groups` (
  `group_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `type_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `title` varchar(80) NOT NULL DEFAULT '',
  `description` text,
  `modules` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`group_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]groups_members`
--

CREATE TABLE `[[dbprefix]]groups_members` (
  `group_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `member_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`group_id`,`member_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]groups_types`
--

CREATE TABLE `[[dbprefix]]groups_types` (
  `type_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `course_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `title` varchar(80) NOT NULL,
  PRIMARY KEY (`type_id`),
  KEY `course_id` (`course_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]guests`
--

CREATE TABLE `[[dbprefix]]guests` (
  `guest_id` varchar(10) NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `organization` varchar(255) DEFAULT NULL,
  `location` varchar(255) DEFAULT NULL,
  `role` varchar(255) DEFAULT NULL,
  `focus` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`guest_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]handbook_notes`
--

CREATE TABLE `[[dbprefix]]handbook_notes` (
  `note_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `section` varchar(15) NOT NULL DEFAULT '',
  `page` varchar(50) NOT NULL DEFAULT '',
  `approved` tinyint(4) NOT NULL DEFAULT '0',
  `email` varchar(50) NOT NULL DEFAULT '',
  `note` text,
  PRIMARY KEY (`note_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]helpme_user`
--

CREATE TABLE `[[dbprefix]]helpme_user` (
  `user_id` mediumint(8) NOT NULL,
  `help_id` mediumint(8) unsigned NOT NULL,
  PRIMARY KEY (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]instructor_approvals`
--

CREATE TABLE `[[dbprefix]]instructor_approvals` (
  `member_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `request_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `notes` text,
  PRIMARY KEY (`member_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]languages`
--

CREATE TABLE `[[dbprefix]]languages` (
  `language_code` varchar(20) NOT NULL DEFAULT '',
  `char_set` varchar(80) NOT NULL DEFAULT '',
  `direction` varchar(16) NOT NULL DEFAULT '',
  `reg_exp` varchar(124) NOT NULL DEFAULT '',
  `native_name` varchar(80) NOT NULL DEFAULT '',
  `english_name` varchar(80) NOT NULL DEFAULT '',
  `status` tinyint(3) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`language_code`,`char_set`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `[[dbprefix]]languages`
--

INSERT INTO `[[dbprefix]]languages` VALUES
('en', 'utf-8', 'ltr', 'en([-_][[:alpha:]]{2})?|english', 'English', 'English', 3);

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]language_pages`
--

CREATE TABLE `[[dbprefix]]language_pages` (
  `term` varchar(50) NOT NULL DEFAULT '',
  `page` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`term`,`page`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]language_text`
--

CREATE TABLE `[[dbprefix]]language_text` (
  `language_code` varchar(5) NOT NULL DEFAULT '',
  `variable` varchar(30) NOT NULL DEFAULT '',
  `term` varchar(50) NOT NULL DEFAULT '',
  `text` blob NOT NULL,
  `revised_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `context` text NOT NULL,
  PRIMARY KEY (`language_code`,`variable`,`term`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `[[dbprefix]]language_text`
--

INSERT INTO `[[dbprefix]]language_text` VALUES
('en', '_module', 'gameme', 'GameMe', '2018-04-23 18:09:51', ''),
('en', '_module', 'gameme-master', 'GameMe', '2018-04-23 18:09:51', ''),
('en', '_module', 'gm_addplus', 'Add +', '2018-04-23 18:09:55', ''),
('en', '_module', 'gm_alerts', 'Alerts', '2018-04-23 18:09:53', ''),
('en', '_module', 'gm_alias', 'Alias', '2018-04-23 18:09:52', ''),
('en', '_module', 'gm_allow_repetition', 'Allow Repetition (Yes this event can repeat, or No is it a one time occurence)', '2018-04-23 18:09:56', ''),
('en', '_module', 'gm_badge', 'Badge', '2018-04-23 18:09:53', ''),
('en', '_module', 'gm_badges', 'Badges', '2018-04-23 18:09:52', ''),
('en', '_module', 'gm_badges_so_far', 'Your badges earned so far', '2018-04-23 18:09:56', ''),
('en', '_module', 'gm_badge_id', 'Badge ID', '2018-04-23 18:09:52', ''),
('en', '_module', 'gm_cancel', 'Cancel', '2018-04-23 18:09:56', ''),
('en', '_module', 'gm_copy', 'Copy', '2018-04-23 18:09:54', ''),
('en', '_module', 'gm_count', 'Count', '2018-04-23 18:09:53', ''),
('en', '_module', 'gm_counter', 'Counter', '2018-04-23 18:09:52', ''),
('en', '_module', 'gm_course_badges', 'Course Badges', '2018-04-23 18:09:54', ''),
('en', '_module', 'gm_course_events', 'Course Events', '2018-04-23 18:09:53', ''),
('en', '_module', 'gm_course_levels', 'Course Levels', '2018-04-23 18:09:54', ''),
('en', '_module', 'gm_default_badges', 'Default Badges', '2018-04-23 18:09:54', ''),
('en', '_module', 'gm_default_events', 'Default Events', '2018-04-23 18:09:54', ''),
('en', '_module', 'gm_default_levels', 'Default Levels', '2018-04-23 18:09:55', ''),
('en', '_module', 'gm_delete', 'delete', '2018-04-23 18:09:55', ''),
('en', '_module', 'gm_delete_badge', 'Delete Badge', '2018-04-23 18:09:55', ''),
('en', '_module', 'gm_delete_event', 'Delete Event', '2018-04-23 18:09:55', ''),
('en', '_module', 'gm_delete_level', 'Delete Level', '2018-04-23 18:09:55', ''),
('en', '_module', 'gm_description', 'Description', '2018-04-23 18:09:52', ''),
('en', '_module', 'gm_disallow_instructors', 'Disallow instructor customizing', '2018-04-23 18:09:56', ''),
('en', '_module', 'gm_eachevent_callback', 'Each callback function (When event occurs, run this function)', '2018-04-23 18:09:57', ''),
('en', '_module', 'gm_eachevent_points', 'Points for each event (Points awarded for each occurence of this event)', '2018-04-23 18:09:57', ''),
('en', '_module', 'gm_each_badge', 'Each Badge', '2018-04-23 18:09:54', ''),
('en', '_module', 'gm_each_badge_id', 'Badge ID each event (When event occurs, issue this badge)', '2018-04-23 18:09:57', ''),
('en', '_module', 'gm_each_callback', 'Each Callback', '2018-04-23 18:09:54', ''),
('en', '_module', 'gm_each_points', 'Each Point', '2018-04-23 18:09:54', ''),
('en', '_module', 'gm_edit', 'Edit', '2018-04-23 18:09:54', ''),
('en', '_module', 'gm_edit_badge', 'Add/Edit Badge', '2018-04-23 18:09:56', ''),
('en', '_module', 'gm_edit_event', 'Add/Edit Event', '2018-04-23 18:09:56', ''),
('en', '_module', 'gm_edit_level', 'Add/Edit Level', '2018-04-23 18:09:56', ''),
('en', '_module', 'gm_enable_edit', 'Enable inline edit', '2018-04-23 18:09:55', ''),
('en', '_module', 'gm_event', 'Event', '2018-04-23 18:09:53', ''),
('en', '_module', 'gm_events', 'Events', '2018-04-23 18:09:53', ''),
('en', '_module', 'gm_event_date', 'Event Date', '2018-04-23 18:09:53', ''),
('en', '_module', 'gm_gameme', 'GameMe', '2018-04-23 18:09:51', ''),
('en', '_module', 'gm_gameme_notification', 'ATutor GameMe Notification', '2018-04-23 18:09:57', ''),
('en', '_module', 'gm_gameme_text', 'Review your progress.', '2018-04-23 18:09:51', ''),
('en', '_module', 'gm_icon', 'Icon', '2018-04-23 18:09:54', ''),
('en', '_module', 'gm_id', 'ID', '2018-04-23 18:09:51', ''),
('en', '_module', 'gm_in_position', 'You are in position: %s', '2018-04-23 18:09:52', ''),
('en', '_module', 'gm_leaders_top', 'Leaders (Top %s)', '2018-04-23 18:09:51', ''),
('en', '_module', 'gm_leader_board', 'Leader Board', '2018-04-23 18:09:55', ''),
('en', '_module', 'gm_leader_length', 'Leader board length', '2018-04-23 18:09:55', ''),
('en', '_module', 'gm_level', 'Level', '2018-04-23 18:09:52', ''),
('en', '_module', 'gm_levels', 'Levels', '2018-04-23 18:09:52', ''),
('en', '_module', 'gm_levels_awarded', 'Levels Awarded', '2018-04-23 18:09:52', ''),
('en', '_module', 'gm_level_name', 'Level Name', '2018-04-23 18:09:55', ''),
('en', '_module', 'gm_level_number', 'Number of levels (max 11)', '2018-04-23 18:09:55', ''),
('en', '_module', 'gm_level_title', 'Level Title', '2018-04-23 18:09:56', ''),
('en', '_module', 'gm_log', 'Log', '2018-04-23 18:09:53', ''),
('en', '_module', 'gm_login_for_points', 'Login to collect points', '2018-04-23 18:09:52', ''),
('en', '_module', 'gm_manage_badges', 'Manage Badges', '2018-04-23 18:09:52', ''),
('en', '_module', 'gm_max_points', 'Max Points', '2018-04-23 18:09:53', ''),
('en', '_module', 'gm_max_points_allowed', 'Maximum points allowed  (Maximum points that can be scored for this event)', '2018-04-23 18:09:56', ''),
('en', '_module', 'gm_no', 'No', '2018-04-23 18:09:57', ''),
('en', '_module', 'gm_no_alerts', 'No level or badge alerts to show', '2018-04-23 18:09:53', ''),
('en', '_module', 'gm_no_badges_earned', 'You have not earned any badges yet. ', '2018-04-23 18:09:57', ''),
('en', '_module', 'gm_no_course_badges_yet', 'No course badges yet. Click "copy" next to a default badge, to move it here for customizing.', '2018-04-23 18:09:57', ''),
('en', '_module', 'gm_no_course_events_yet', 'No course events yet. Click "copy" next to a default event, to move it here for customizing.', '2018-04-23 18:09:57', ''),
('en', '_module', 'gm_no_course_levels_yet', 'No course levels yet. Click "copy" next to a default level, to move it here for customizing.', '2018-04-23 18:09:57', ''),
('en', '_module', 'gm_options', 'Options', '2018-04-23 18:09:53', ''),
('en', '_module', 'gm_points', 'Points', '2018-04-23 18:09:51', ''),
('en', '_module', 'gm_points_reached', 'Points Reached (Points scored to reach level)', '2018-04-23 18:09:56', ''),
('en', '_module', 'gm_points_threshold', 'Points Threshold', '2018-04-23 18:09:55', ''),
('en', '_module', 'gm_position', 'Position relative to others', '2018-04-23 18:09:55', ''),
('en', '_module', 'gm_progress', 'Progress', '2018-04-23 18:09:53', ''),
('en', '_module', 'gm_progress_for', 'Progress for ', '2018-04-23 18:09:55', ''),
('en', '_module', 'gm_progress_to_next', 'Progess to next level: %s/100', '2018-04-23 18:09:52', ''),
('en', '_module', 'gm_progress_to_next2', 'Progess to next level', '2018-04-23 18:09:52', ''),
('en', '_module', 'gm_reachevent_callback', 'Reach callback function (When event repetitions is reached, run this function)', '2018-04-23 18:09:57', ''),
('en', '_module', 'gm_reachevent_message', 'Reach Message (The message sent to users when a reach event occurs)', '2018-04-23 18:09:57', ''),
('en', '_module', 'gm_reachevent_points', 'Points awared for the reach event (Bonus points added when the reach event occurs)', '2018-04-23 18:09:57', ''),
('en', '_module', 'gm_reach_badge', 'Reach Badge', '2018-04-23 18:09:54', ''),
('en', '_module', 'gm_reach_badge_id', 'Badge ID reach event (When event repetitions is reach, issue this badge)', '2018-04-23 18:09:56', ''),
('en', '_module', 'gm_reach_callback', 'Reach Callback', '2018-04-23 18:09:54', ''),
('en', '_module', 'gm_reach_message', 'Reach Message', '2018-04-23 18:09:57', ''),
('en', '_module', 'gm_reach_points', 'Reach Points', '2018-04-23 18:09:54', ''),
('en', '_module', 'gm_reach_repetition', 'Reach required repetitions (Repetitions required to trigger reach event)', '2018-04-23 18:09:56', ''),
('en', '_module', 'gm_reach_reps', 'Reach Reps', '2018-04-23 18:09:53', ''),
('en', '_module', 'gm_remove', 'Remove', '2018-04-23 18:09:54', ''),
('en', '_module', 'gm_repetition', 'Repetition', '2018-04-23 18:09:53', ''),
('en', '_module', 'gm_save_badge', 'Save Badge', '2018-04-23 18:09:56', ''),
('en', '_module', 'gm_save_event', 'Save Event', '2018-04-23 18:09:57', ''),
('en', '_module', 'gm_short_description', 'Short Description', '2018-04-23 18:09:56', ''),
('en', '_module', 'gm_show_instructor', 'Show instructor in leader board', '2018-04-23 18:09:55', ''),
('en', '_module', 'gm_title', 'Title', '2018-04-23 18:09:52', ''),
('en', '_module', 'gm_update_level', 'Update Level', '2018-04-23 18:09:56', ''),
('en', '_module', 'gm_update_options', 'Update Options', '2018-04-23 18:09:56', ''),
('en', '_module', 'gm_view', 'view', '2018-04-23 18:09:55', ''),
('en', '_module', 'gm_yes', 'Yes', '2018-04-23 18:09:57', ''),
('en', '_module', 'gm_your_activity_log', 'Your Activity Log', '2018-04-23 18:09:53', ''),
('en', '_module', 'gm_your_alert', 'Your Alerts', '2018-04-23 18:09:53', ''),
('en', '_module', 'gm_your_badges', 'Your Badges', '2018-04-23 18:09:53', ''),
('en', '_module', 'gm_your_levels_reached', 'Your Levels Reached', '2018-04-23 18:09:52', ''),
('en', '_module', 'gradebook', 'Gradebook', '2008-09-25 15:59:56', 'gradebook'),
('en', '_module', 'helpme', 'HelpMe', '2018-04-19 17:43:12', ''),
('en', '_module', 'helpme_disable', 'Enable/Disable HelpMe', '2018-04-19 17:43:12', ''),
('en', '_module', 'helpme_dismiss', 'Next', '2018-04-19 17:43:12', ''),
('en', '_module', 'helpme_dismiss_all', 'Dismiss All', '2018-04-19 17:43:12', ''),
('en', '_module', 'helpme_language', 'HelpMe Language', '2018-04-19 17:43:13', ''),
('en', '_module', 'helpme_message', 'Message', '2018-04-19 17:43:13', ''),
('en', '_module', 'helpme_reset', 'See HelpMe messages again.', '2018-04-19 17:43:13', ''),
('en', '_module', 'helpme_revisit', 'Previous', '2018-04-19 17:43:13', ''),
('en', '_module', 'helpme_text', 'The HelpMe module presents a short series of prompts for new Administrators and Instructors  to help them quickly learn to use ATutor effectively. Click on checkbox below to enable or disable HelpMe. Use the HelpMe Language form below to modify the help messages presented to new users.', '2018-04-19 17:43:12', ''),
('en', '_msg', 'AT_CONFIRM_GM_DELETE_BADGE', 'Are you sure you want to delete this badge?', '2018-04-23 18:09:59', ''),
('en', '_msg', 'AT_CONFIRM_GM_DELETE_EVENT', 'Are you sure you want to delete this event?', '2018-04-23 18:09:59', ''),
('en', '_msg', 'AT_CONFIRM_GM_DELETE_EVENT_ADMIN', 'Are you sure you want to delete this event? Deleting default events can cause problems. Be sure you know what you are doing.', '2018-04-23 18:09:59', ''),
('en', '_msg', 'AT_CONFIRM_GM_DELETE_LEVEL', 'Are you sure you want to delete this level?', '2018-04-23 18:09:59', ''),
('en', '_msg', 'AT_ERROR_GM_BADGE_COPY_FAILED', 'Copy badge failed. Contact your administrator if it persists.', '2018-04-23 18:09:58', ''),
('en', '_msg', 'AT_ERROR_GM_BADGE_REQUIREMENTS', 'An alias, with no spaces, and a title must be provided for the badge.', '2018-04-23 18:09:59', ''),
('en', '_msg', 'AT_ERROR_GM_EVENT_COPY_FAILED', 'Copy event failed. Contact your administrator if it persists.', '2018-04-23 18:09:58', ''),
('en', '_msg', 'AT_ERROR_GM_LEVEL_COPIED_FAILED', 'Copy level failed. Contact your administrator if it persists.', '2018-04-23 18:09:58', ''),
('en', '_msg', 'AT_ERROR_GM_LEVEL_REQUIREMENTS', 'The level title and a numeric points reached value must be defined.', '2018-04-23 18:09:59', ''),
('en', '_msg', 'AT_ERROR_GM_MAX_DIMENSION', 'Maximum dimensions of %sx%s exceeded. Reduce the height and width of the image.', '2018-04-23 18:09:59', ''),
('en', '_msg', 'AT_ERROR_GM_MAX_FILESESIZE', 'Maximum files size of %sKB exceeded. Reduce the size of the image.', '2018-04-23 18:09:59', ''),
('en', '_msg', 'AT_ERROR_GM_UPDATED_OPTIONS_FAILED', 'Update options failed. Contact your administrator if it persists.', '2018-04-23 18:09:59', ''),
('en', '_msg', 'AT_FEEDBACK_GM_BADGED_ADDED', 'Successfully added badge. Drag a badge image into the dropzone in the first column to add/edit the badge.', '2018-04-23 18:09:59', ''),
('en', '_msg', 'AT_FEEDBACK_GM_BADGE_COPIED', 'Badge was successfully copied. Drag badges into the drop done in the first column to change a badge image. Click on cells to edit them, click out to save.', '2018-04-23 18:09:58', ''),
('en', '_msg', 'AT_FEEDBACK_GM_BADGE_REMOVED', 'Badge was successfully removed.', '2018-04-23 18:09:59', ''),
('en', '_msg', 'AT_FEEDBACK_GM_CONFIG_UPDATED', 'GameMe configuration was sucessfully updated', '2018-04-23 18:10:00', ''),
('en', '_msg', 'AT_FEEDBACK_GM_EVENT_COPIED', 'Event was successfully copied. Click on cells to edit them, click out to save. ', '2018-04-23 18:09:58', ''),
('en', '_msg', 'AT_FEEDBACK_GM_EVENT_REMOVED', 'Event was successfully removed.', '2018-04-23 18:09:59', ''),
('en', '_msg', 'AT_FEEDBACK_GM_LEVEL_COPIED', 'Level was successfully copied. Click on cells to edit them, click out to save. ', '2018-04-23 18:09:58', ''),
('en', '_msg', 'AT_FEEDBACK_GM_LEVEL_REMOVED', 'Level was successfully removed.', '2018-04-23 18:09:59', ''),
('en', '_msg', 'AT_FEEDBACK_GM_UPDATED_OPTIONS', 'Options were sucessfully updated.', '2018-04-23 18:09:59', ''),
('en', '_msg', 'AT_INFOS_GM_BADGE_PROPERTIES', 'Set badge properties here. Drag a badge image into the Badge dropzone for the new badge after saving.', '2018-04-23 18:09:59', ''),
('en', '_msg', 'AT_INFOS_GM_COPY_BADGE', 'Copy Default Badges to modify them', '2018-04-23 18:09:58', ''),
('en', '_msg', 'AT_INFOS_GM_COPY_DEFAULT_LEVELS', 'Copy Default Levels to modify them. Set the number of levels under the Options tab.', '2018-04-23 18:09:58', ''),
('en', '_msg', 'AT_INFOS_GM_COPY_EVENT', 'Copy Default Events to modify them.', '2018-04-23 18:09:57', ''),
('en', '_msg', 'AT_INFOS_GM_CREATE_EVENT_TEXT', 'Creating new events also requires adding matching script to the module''s events.php file. See the Handbook page for details.', '2018-04-23 18:09:59', ''),
('en', '_msg', 'AT_INFOS_GM_DISPLAY_ELEMENTS', 'Set game elements to display to students.', '2018-04-23 18:09:58', ''),
('en', '_msg', 'AT_INFOS_GM_EDITING_DISABLED', 'Editing has been disabled. Contact your administrator to have editing turned on', '2018-04-23 18:09:58', ''),
('en', '_msg', 'AT_INFOS_GM_EDIT_BADGE_TEXT', 'Drag badges into the Badge dropzone in the first column, or click on a table cells to edit its value, click out to save. See the Handbook for more about creating and modifying the system''s Default Badges.', '2018-04-23 18:09:58', ''),
('en', '_msg', 'AT_INFOS_GM_ENABLE_EDIT_TEXT', 'Click on a table cells to edit values, click out to save. See the Handbook for more about creating and modifying the system''s Default Events.', '2018-04-23 18:09:58', ''),
('en', '_msg', 'AT_INFOS_GM_LEVELS_TEXT', 'Drag level icons into the Icon dropzone in the first colum, or click on a table cells to edit its value, click out to save. See the Handbook for more about creating and modifying the system''s Default Levels. ', '2018-04-23 18:09:58', ''),
('en', '_msg', 'AT_INFOS_GM_OPTIONS_TEXT', 'Most options are managed by instructors at the course level, enabled by default. You may choose to prevent Instructors from modifying game elements by checking the checkbox below, allowing only the default settings to be used.', '2018-04-23 18:09:58', ''),
('en', '_msg', 'AT_INFOS_GM_SEE_PROGRESS', 'Select a user from the menu below to view that person''s progress. ', '2018-04-23 18:09:58', ''),
('en', '_msg', 'AT_WARNING_GM_SET_GAMEME_OPTIONS', 'GameMe options must be set in this course. Under the Manage tab, open GameMe and select the Options tab. Enable GameMe elements in Manage>Course Tools.', '2018-04-23 18:09:57', ''),
('en', '_msgs', 'AT_CONFIRM_ADD_FEED', 'Are you sure you want to add this syndicated feed?', '2005-11-15 13:19:26', ''),
('en', '_msgs', 'AT_CONFIRM_ADD_MODULE', 'Are you sure you want to install the module in <strong><code>%s</code></strong>?', '2005-08-17 12:59:04', ''),
('en', '_msgs', 'AT_CONFIRM_ADD_TEST_QUESTIONS', 'Are you sure you want to <em>add</em> the following questions? \r\n<ul>%s</ul>', '2004-11-23 12:38:56', ''),
('en', '_msgs', 'AT_CONFIRM_ALUMNI', 'Are you sure you want to mark the following users as course alumni: <ul> %s </ul>', '2004-11-23 12:17:53', 'enrollment_manager, make students into alumi'),
('en', '_msgs', 'AT_CONFIRM_DELETE', 'Are you sure you want to delete these items?<br />\r\n\r\n <ul> %s </ul>', '2008-05-08 12:19:32', 'generic delete confirmation msg'),
('en', '_msgs', 'AT_CONFIRM_DELETE_ADMIN', 'Are you sure you want to delete the following administrator?\r\n<br />\r\n<strong>%s</strong>', '2008-01-22 09:38:06', ''),
('en', '_msgs', 'AT_CONFIRM_DELETE_ASSIGNMENT', 'Are you sure you want to delete assignment <em>%s</em>?', '2006-05-23 13:10:30', ''),
('en', '_msgs', 'AT_CONFIRM_DELETE_AUTO_ENROLL', 'Are you sure you want to <strong>delete</strong> auto enrollment for <strong>%s</strong>', '2008-03-10 11:52:57', 'confirm message when deleting an auto enroll definition'),
('en', '_msgs', 'AT_CONFIRM_DELETE_CATEGORY', 'Are you sure you want to delete category  <strong>%s</strong>?', '2005-02-17 14:57:18', ''),
('en', '_msgs', 'AT_CONFIRM_DELETE_COURSE_1', 'Are you sure you want to <strong>Delete</strong> the course <strong><em>%s</em></strong>?', '2005-03-04 11:27:35', ''),
('en', '_msgs', 'AT_CONFIRM_DELETE_COURSE_2', 'Are you <strong>really really</strong> sure you want to <b>Delete</b> the course <strong><em>%s</em></strong>? Deleted courses can not be recovered.', '2005-03-04 11:31:35', ''),
('en', '_msgs', 'AT_CONFIRM_DELETE_FAQ_QUESTION', 'Are you sure you want to delete the question <strong>%s</strong>?', '2005-10-19 12:49:55', ''),
('en', '_msgs', 'AT_CONFIRM_DELETE_FAQ_TOPIC', 'Are you sure you want to delete the topic <strong>%s</strong> and its questions?', '2005-11-08 13:42:33', ''),
('en', '_msgs', 'AT_CONFIRM_DELETE_FEED', 'Are you sure you want to delete feed <strong>%s</strong>.?', '2005-12-07 09:36:25', ''),
('en', '_msgs', 'AT_CONFIRM_DELETE_FORUM', 'Are you sure you want to delete <strong>%s</strong> forum? All messages posted to this forum will be erased.', '2005-12-07 09:36:15', 'deleting a forum'),
('en', '_msgs', 'AT_CONFIRM_DELETE_GRADE_SCALE', 'Are you sure you want to <strong>delete</strong> grade scale <strong>%s</strong>?', '2008-09-25 16:01:17', 'gradebook'),
('en', '_msgs', 'AT_CONFIRM_DELETE_GROUP', 'Are you sure you want to delete the group: <strong>%s</strong>?', '2005-02-21 12:07:05', 'deletep enrollment group'),
('en', '_msgs', 'AT_CONFIRM_DELETE_GROUP_TYPE', 'Are you sure you want to delete group type <em>%s</em> and all its groups?', '2006-03-23 11:27:52', ''),
('en', '_msgs', 'AT_CONFIRM_DELETE_LANG', 'Are you sure you want to delete the language ( <strong>%s </strong>)?', '2004-11-24 13:19:50', ''),
('en', '_msgs', 'AT_CONFIRM_DELETE_LINK', 'Are you sure you want to delete the link %s?', '2005-02-21 16:55:38', ''),
('en', '_msgs', 'AT_CONFIRM_DELETE_MSGS', 'Are you sure you want to delete the selected messages?', '2007-02-22 13:09:14', ''),
('en', '_msgs', 'AT_CONFIRM_DELETE_MYOWN_PATCH', 'Are you sure you want to <strong>delete</strong> patch <strong>%s</strong>', '2008-04-21 15:11:31', ''),
('en', '_msgs', 'AT_CONFIRM_DELETE_NEWS', 'Are you sure you want to delete %s?', '2004-11-24 13:37:55', 'news deletion in editor'),
('en', '_msgs', 'AT_CONFIRM_DELETE_POLL', 'Are you sure you want to delete this poll ''%s''?  It cannot be recovered once deleted.', '2004-11-24 14:03:36', 'editor'),
('en', '_msgs', 'AT_CONFIRM_DELETE_TEST', 'Are you sure you want to delete the test/survey <strong><em>%s</em></strong> and any results? The questions, however, will not be deleted.', '2004-12-15 10:42:13', 'Deleting Test'),
('en', '_msgs', 'AT_CONFIRM_DELETE_TEST_CATEGORY', 'Are you sure you want to delete test category <strong>%s</strong>?', '2005-03-07 11:58:48', ''),
('en', '_msgs', 'AT_CONFIRM_DELETE_TEST_FROM_GRADEBOOK', 'Are you sure you want to <strong>delete</strong> test <strong>%s</strong> from gradebook?', '2008-09-25 16:01:17', 'gradebook'),
('en', '_msgs', 'AT_CONFIRM_DELETE_THEME', 'Are you sure you want to delete the following theme: <b> % s </b>', '2004-11-23 09:30:03', 'confirm message for delete theme'),
('en', '_msgs', 'AT_CONFIRM_DELETE_TOOL_1', 'Are you sure you want to delete the tool <strong> %s</strong>?', '2011-05-27 16:09:45', ''),
('en', '_msgs', 'AT_CONFIRM_DELETE_TRACKING', 'Are you sure your want to delete the content usage data for this course?', '2005-08-11 10:08:50', 'reset tracking session'),
('en', '_msgs', 'AT_CONFIRM_DELETE_TRANSCRIPT', 'Are you sure you want to delete the transcript <strong>%s</strong>?', '2005-03-30 14:21:00', 'delete chat transcript'),
('en', '_msgs', 'AT_CONFIRM_DELETE_USER', 'Are you sure you want to delete the following users? Selected instructors who own courses will not be deleted.<strong>%s</strong>', '2007-02-19 11:44:45', 'deleting user from admin'),
('en', '_msgs', 'AT_CONFIRM_DIR_DELETE', 'Are you sure you want to delete the following folder(s) and all their contents? <ul><strong>%s</strong></ul>', '2004-12-15 09:59:39', 'filemanager'),
('en', '_msgs', 'AT_CONFIRM_DIR_MOVE', 'Are you sure you want to move <strong>%1s</strong> to the folder <strong>%2s</strong>?', '2005-01-10 10:35:17', 'filemanager'),
('en', '_msgs', 'AT_CONFIRM_EDIT_STATUS', 'Are you sure you want to change the following users'' status to  <strong>%s</strong>? Status of selected instructors who own courses will not be changed. %s', '2007-02-19 11:43:37', ''),
('en', '_msgs', 'AT_CONFIRM_ENROLL_STUDENT', 'Are you sure you want to enroll the following users: <ul> %s </ul>', '2004-11-23 12:21:00', 'enrollment manager, enroll confirm'),
('en', '_msgs', 'AT_CONFIRM_FILE_DELETE', 'Are you sure you want to delete the following file(s)? <ul>%s</ul>', '2006-07-05 11:44:15', 'filemanager'),
('en', '_msgs', 'AT_CONFIRM_FILE_EXISTS', 'The file <strong>%s</strong> already exists. Do you want to overwrite the file?', '2005-03-09 16:26:11', 'filemanager'),
('en', '_msgs', 'AT_CONFIRM_FILE_MOVE', 'Are you sure you want to move <strong>%1s</strong> to the folder <strong>%2s</strong>?', '2005-01-10 10:33:21', 'file_manager'),
('en', '_msgs', 'AT_CONFIRM_GLOSSARY_REMAINS', 'Deleting a term will not remove the embedded glossary codes from your content.', '2005-02-24 10:34:33', 'content deletion'),
('en', '_msgs', 'AT_CONFIRM_GRANT_WRITE_PERMISSION', 'Please grant <strong>write</strong> permission to folder: %s<p><strong>Note:</strong> To change permissions on Unix use <kbd>chmod a+rw</kbd> then the file name.</p>', '2008-10-21 15:41:53', ''),
('en', '_msgs', 'AT_CONFIRM_LIST_DELETE', 'Are you sure you want to delete <strong>%s</strong> Student ID from the master student list?', '2005-04-04 15:47:51', ''),
('en', '_msgs', 'AT_CONFIRM_LOGIN_INSTRUCTOR', '<h3>%2$s</h3>\r\nYou will be logged in as the instructor for this course.  Are you sure you want to continue?', '2006-04-10 13:12:29', 'viewing courses from admin'),
('en', '_msgs', 'AT_CONFIRM_NO_ANSWER', 'You are about to add a question with no correct choice. Continue?', '2004-12-06 14:35:10', 'adding a question without specifying answer'),
('en', '_msgs', 'AT_CONFIRM_PA_DELETE_ALBUM', 'Are you sure you want to delete the album <strong>%s</strong>? Once deleted, photos can not be recovered.', '2010-03-17 16:08:25', 'photo album'),
('en', '_msgs', 'AT_CONFIRM_PA_DELETE_COMMENT', 'Are you sure you want to delete this comment?', '2010-03-17 16:09:08', 'photo album'),
('en', '_msgs', 'AT_CONFIRM_PA_DELETE_PHOTO', 'Are you sure you want to delete this Photo?', '2010-03-17 16:08:50', 'photo album'),
('en', '_msgs', 'AT_CONFIRM_REMOVE_STUDENT', 'Are you sure you want to remove the following students: <ul> %s </ul>', '2004-11-23 12:21:12', 'removing a student'),
('en', '_msgs', 'AT_CONFIRM_REMOVE_TEST_QUESTION', 'Are you sure you want to remove this question from this test? Removing the question will not delete it from the question database.', '2004-11-25 10:31:52', ''),
('en', '_msgs', 'AT_CONFIRM_REMOVE_WRITE_PERMISSION', '<span style="color:red">For your security, please <strong>REMOVE</strong> write permission on the folder: %s</span><p><strong>Note:</strong> To remove permissions on Unix use <kbd>chmod 755</kbd> then the file or folder name.</p>', '2008-10-21 15:41:53', ''),
('en', '_msgs', 'AT_CONFIRM_RESET_ADMIN_LOG', 'Are you sure you want to delete the Administrator Activity Log?', '2005-03-03 10:42:50', ''),
('en', '_msgs', 'AT_CONFIRM_RESET_ERROR_LOG', 'Are you sure you want to delete all the error logs?', '2005-03-10 15:49:02', 'error log reset (delete logs folder0'),
('en', '_msgs', 'AT_CONFIRM_RL_DELETE_READING', 'Are you sure you want to delete this reading: <strong>%s</strong>?', '2006-10-04 10:48:51', ''),
('en', '_msgs', 'AT_CONFIRM_RL_DELETE_RESOURCE', 'Are you sure you want to delete this resource: <strong>%s</strong>?<br/>Note: Any readings that use this resource will also be deleted.', '2006-10-04 10:48:36', ''),
('en', '_msgs', 'AT_CONFIRM_STUDENT_GROUP', 'Are you sure you want to add the following users to group ''%s''? <ul> %s </ul>', '2005-06-02 12:07:05', ''),
('en', '_msgs', 'AT_CONFIRM_STUDENT_REMOVE_GROUP', 'Are you sure you want to <strong>remove</strong> the following users from group ''%s''? <ul> %s </ul>', '2005-06-02 12:06:56', 'Enrollment'),
('en', '_msgs', 'AT_CONFIRM_SUB_CONTENT_DELETE', 'This content page has sub content. If you delete this page all its sub pages will be deleted as well.<br />', '2004-11-24 13:31:34', 'content deletion'),
('en', '_msgs', 'AT_CONFIRM_UNENROLL', 'Are you sure you want to un-enroll from <strong>%s</strong>?', '2005-03-24 12:43:34', ''),
('en', '_msgs', 'AT_CONFIRM_UNENROLL_PRIV', 'Are you sure you want to un-enroll the following users (the users will have their roles and privileges removed): <ul> %s </ul>', '2004-11-23 12:23:22', 'enrollment manager, unenrolling a TA'),
('en', '_msgs', 'AT_CONFIRM_UNENROLL_STUDENT', 'Are you sure you want to un-enroll the following students: <ul> %s </ul>', '2004-11-23 12:21:36', 'enrollment manager, confirm unenroll'),
('en', '_msgs', 'AT_ERROR_ACCESS_DENIED', 'You do not have permission to access this area.', '2005-06-15 15:13:59', 'error msg'),
('en', '_msgs', 'AT_ERROR_ACCOUNT_DISABLED', 'That account has been disabled.', '2005-04-01 10:30:12', ''),
('en', '_msgs', 'AT_ERROR_ADMIN_EDIT_OWN_ACCOUNT', 'To edit your own account use the <a href="mods/_core/users/admins/my_edit.php">My Account</a> page.', '2010-03-09 14:25:28', ''),
('en', '_msgs', 'AT_ERROR_ALREADY_BOOKMARKED', 'Calendar is already bookmarked.', '2013-09-11 12:34:03', ''),
('en', '_msgs', 'AT_ERROR_ALREADY_ENROLED', 'You have already made a request to enroll in this course and you have not yet been approved by the instructor. You will be notified when your request has been approved.', '2009-09-17 14:47:14', 'error msg'),
('en', '_msgs', 'AT_ERROR_ALREADY_INSTALLED', 'Selected item appears to have been installed.', '2008-10-21 15:41:53', ''),
('en', '_msgs', 'AT_ERROR_ALREADY_OWNED', 'You own this course, and cannot enroll.', '2004-11-26 14:30:22', 'error msg'),
('en', '_msgs', 'AT_ERROR_ALREADY_UNINSTALLED', 'Selected item appears to have been uninstalled. Module directory does not exist.', '2008-10-21 15:41:53', ''),
('en', '_msgs', 'AT_ERROR_ALTERNATIVE_ALREADY_DECLARED', 'The file you selected has already been declared as an alternative to the selected primary resource.', '2008-09-08 15:25:02', ''),
('en', '_msgs', 'AT_ERROR_ALTERNATIVE_NOT_DEFINED', 'You must select an alternative from files available in the File Manager to the right.', '2009-12-01 11:02:01', ''),
('en', '_msgs', 'AT_ERROR_ASSIGNMENT_CUTOFF', 'The assignment cut-off date has past. Submissions are no longer accepted.', '2006-03-20 14:41:46', ''),
('en', '_msgs', 'AT_ERROR_BACKUP_RESTORE', 'Restore failed - file is not a valid backup. Backups older than version 1.3 are not supported.', '2005-11-29 14:33:56', ''),
('en', '_msgs', 'AT_ERROR_BACKUP_UNSUPPORTED_GREATER_VERSION', 'Backups created from versions of ATutor greater than this version are not supported.', '2005-05-11 15:56:50', ''),
('en', '_msgs', 'AT_ERROR_BAD_DATE', 'That date is not valid.', '2003-05-16 13:42:17', 'error msg'),
('en', '_msgs', 'AT_ERROR_BAD_FILE_TYPE', 'Unsupported file type. Plain Text or HTML files only.', '2003-05-16 13:42:17', 'error msg'),
('en', '_msgs', 'AT_ERROR_BAD_FOLDER_NAME', 'The folder name contains illegal characters. You may choose from alphanumeric characters and underscores, dashes or periods.', '2005-01-10 13:13:55', 'filemanager, foilder with illegal chars'),
('en', '_msgs', 'AT_ERROR_CACHE_DIR_BAD', 'Cache dir cannot be created. Cache disabled. See the configuration options to either disable or fix the problem.', '2003-05-27 13:10:53', 'global'),
('en', '_msgs', 'AT_ERROR_CACHE_DIR_NOT_EXIST', 'Cache directory does not exist or is not writable. Create it and set write permissions to make the directory writable by the system''s Web server user. (e.g. chmod a+rwx cache)', '2010-03-04 14:41:51', ''),
('en', '_msgs', 'AT_ERROR_CAL_FILE_DELETE', 'Error in removing duplicate file.', '2013-09-11 12:34:03', ''),
('en', '_msgs', 'AT_ERROR_CAL_FILE_ERROR', 'Error in file processing.', '2013-09-11 12:34:03', ''),
('en', '_msgs', 'AT_ERROR_CANNOT_BE_EMPTY', 'Search field cannot be empty.', '2009-05-27 12:01:11', ''),
('en', '_msgs', 'AT_ERROR_CANNOT_CONNECT_SERVER', 'Failed to connect to server: %s', '2008-10-21 15:41:53', ''),
('en', '_msgs', 'AT_ERROR_CANNOT_CREATE_DIR', 'Cannot create content directory.', '2003-10-15 12:20:51', ''),
('en', '_msgs', 'AT_ERROR_CANNOT_DELETE_OWN_ACCOUNT', 'You cannot delete your own account.', '2005-03-03 10:59:44', ''),
('en', '_msgs', 'AT_ERROR_CANNOT_OPEN_DIR', 'Unable to open content directory. You may try to <a href="mods/_core/file_manager/new.php">create it now</a>.', '2010-03-09 14:26:18', 'error msg'),
('en', '_msgs', 'AT_ERROR_CANNOT_OPEN_FILE', 'Cannot open the file: <b> %s </b>', '2004-10-18 14:38:00', 'Theme Manager'),
('en', '_msgs', 'AT_ERROR_CANNOT_OVERWRITE_FILE', 'Cannot override file.', '2003-05-16 13:42:17', 'error msg'),
('en', '_msgs', 'AT_ERROR_CANNOT_READ_FILE', 'Cannot read from file: <b> %s </b>', '2004-11-19 13:00:03', 'admin/error_logging.php'),
('en', '_msgs', 'AT_ERROR_CANNOT_RENAME', 'File or directory cannot be renamed. Either a file or directory with that name already exists, the original file or directory does not exist, or the file or directory name has not changed.', '2004-08-20 12:05:15', ''),
('en', '_msgs', 'AT_ERROR_CANNOT_UNINSTALL_MANUAL_MODULE', 'This module needs to be uninstalled manually instead of using the ATutor module installer. Please uninstall it manually.', '2008-10-21 15:41:53', 'error msg'),
('en', '_msgs', 'AT_ERROR_CANNOT_UNZIP', 'Can NOT unzip the uploaded file.', '2008-04-21 15:08:55', 'error msg'),
('en', '_msgs', 'AT_ERROR_CANNOT_WRITE_FILE', 'Cannot write to file: <b> %s </b>', '2004-10-18 14:39:10', 'Theme Manager'),
('en', '_msgs', 'AT_ERROR_CANT_DELETE_GROUP', 'You cannot delete this group.', '2009-05-27 12:01:11', ''),
('en', '_msgs', 'AT_ERROR_CHAT_TRAN_REJECTED', 'Transcript filename rejected. Please ensure that it is  alphanumeric and contains no spaces.', '2003-06-02 13:47:39', 'achat'),
('en', '_msgs', 'AT_ERROR_CHOICES_EMPTY', 'Enter at least two answer choices.', '2005-03-08 15:41:49', ''),
('en', '_msgs', 'AT_ERROR_CHOOSE_UNINSTALLED_PATCH', 'Please choose an uninstalled patch.', '2008-04-21 15:08:55', 'error msg'),
('en', '_msgs', 'AT_ERROR_COMBINE_TESTS', '"<strong>%1$s</strong>" cannot be combined because the following students have taken it more than once:<br />\r\n%2$s.', '2008-09-25 16:01:17', 'gradebook'),
('en', '_msgs', 'AT_ERROR_CONFIG_NOT_WRITEABLE', 'It is not possible to edit these settings because the configuration file is locked for security reasons. If you want to make changes, you need to unlock the config.inc.php file first by changing its permissions with the command <kbd>chmod a+rw config.inc.php</kbd>.', '2005-03-03 10:14:48', ''),
('en', '_msgs', 'AT_ERROR_CONFIRM_BAD', 'Your email address and account could not be confirmed.', '2005-05-31 12:55:25', ''),
('en', '_msgs', 'AT_ERROR_CONTACT_INFO_NOT_FOUND', 'Contact Support is not available, because an email address has not been specified.', '2005-03-17 11:33:38', ''),
('en', '_msgs', 'AT_ERROR_COULD_NOT_LOAD_TOOL', 'Could not load tool.', '2013-09-07 10:12:08', 'admin edit LTI tool'),
('en', '_msgs', 'AT_ERROR_COURSE_DIR_NAME_INVALID', 'The course directory name is invalid. It may contain only letters, numbers, and underscores, and may not contain spaces and hyphens.', '2012-07-26 13:58:12', ''),
('en', '_msgs', 'AT_ERROR_COURSE_DIR_NAME_IN_USE', 'The course directory name is already in use. Please try another.', '2008-10-06 13:19:17', ''),
('en', '_msgs', 'AT_ERROR_COURSE_ENDED', 'This course ended on %s.', '2007-07-16 11:53:27', ''),
('en', '_msgs', 'AT_ERROR_COURSE_NOT_RELEASED', 'This course can only be accessed on %s.', '2006-04-10 14:28:27', ''),
('en', '_msgs', 'AT_ERROR_CREATE_MASTER_USED', 'The Student ID you have entered already belongs to another user. If you wish to over-write this association with the new account, use the over-write checkbox.', '2006-06-12 15:39:43', ''),
('en', '_msgs', 'AT_ERROR_CURL_NOT_INSTALLED', 'The curl library needs to be installed for gadgets to be added.  Please contact your administrator for more information.', '2009-06-09 14:44:50', ''),
('en', '_msgs', 'AT_ERROR_CUTOFF_DATE_WRONG', 'The Late Submissions date appears to be wrong. It must occur after the Due Date, and must be in the future.', '2012-07-23 12:10:15', ''),
('en', '_msgs', 'AT_ERROR_DB_NOT_UPDATED', 'Information could not be added to the database.', '2003-05-16 13:42:17', 'error msg'),
('en', '_msgs', 'AT_ERROR_DB_QUERY', 'ATutor was unable to access the database. If the problem persists, please report this to an Administrator with this date reference (%s ) <br />%s <br /> %s', '2018-03-13 19:07:00', 'queryDB failure'),
('en', '_msgs', 'AT_ERROR_DIR_NOT_DELETED', 'Cannot open directory to be deleted.', '2003-05-16 13:42:17', 'error msg'),
('en', '_msgs', 'AT_ERROR_DIR_NOT_EXIST', 'Directory <strong>%s</strong> does not exist. Please create it.', '2005-09-22 14:08:05', 'file manager'),
('en', '_msgs', 'AT_ERROR_DIR_NOT_WRITEABLE', 'Directory <strong>%s</strong> is not writeable. On Unix issue the command <kbd>chmod a+rw</kbd> on the directory.', '2005-09-22 14:22:24', ''),
('en', '_msgs', 'AT_ERROR_DIR_NO_PERMISSION', 'Cannot delete folder. You may not have premission, or it may not be empty.', '2003-05-22 12:20:14', 'error msg'),
('en', '_msgs', 'AT_ERROR_DISABLE_CORE_MODULE', 'Core modules cannot be disabled.', '2005-08-25 14:00:13', ''),
('en', '_msgs', 'AT_ERROR_DISABLE_MISSING_MODULE', 'You cannot disable a missing module. To continue managing this module you must first restore its directory.', '2005-10-05 16:22:01', ''),
('en', '_msgs', 'AT_ERROR_DISABLE_PARTIALLY_UNINSTALLED_MODULE', 'You cannot disable a partially uninstalled module. To continue managing this module you must first restore it.', '2008-10-21 15:41:53', 'error msg'),
('en', '_msgs', 'AT_ERROR_DOB_INVALID', 'Date of birth has invalid format.', '2004-06-24 12:53:34', ''),
('en', '_msgs', 'AT_ERROR_EMAIL_EXISTS', 'An account with that email address already exists.', '2005-03-01 11:36:57', 'error msg'),
('en', '_msgs', 'AT_ERROR_EMAIL_INVALID', 'Email address was invalid.', '2003-05-16 13:42:17', 'error msg'),
('en', '_msgs', 'AT_ERROR_EMAIL_MISMATCH', 'Email addresses do not match. Please re-type them.', '2009-11-04 14:12:12', ''),
('en', '_msgs', 'AT_ERROR_EMAIL_NOT_FOUND', 'No account found with that email address.', '2003-05-16 13:42:17', 'error msg'),
('en', '_msgs', 'AT_ERROR_EMPTY_FIELDS', 'The following required field(s) are empty:<br />\r\n%s.', '2006-10-05 15:51:52', ''),
('en', '_msgs', 'AT_ERROR_EMPTY_ZIP_FILE', 'Downloaded zip file is empty.', '2008-10-21 15:41:53', ''),
('en', '_msgs', 'AT_ERROR_END_DATE_INVALID', 'That end date is not valid.', '2003-05-16 13:42:17', 'error msg'),
('en', '_msgs', 'AT_ERROR_ENROLLMENT_NONE_FOUND', 'There is no one to export.', '2006-06-27 11:53:26', ''),
('en', '_msgs', 'AT_ERROR_FEEDBACK_AUTOHIDE_NEGATIVE_VALUE', 'The value for autohide feedback was set to negative. Please enter a positive value.', '2013-12-18 18:39:32', ''),
('en', '_msgs', 'AT_ERROR_FEED_NO_CONTENT', 'The feed either cannot be found at that URL or is not valid.', '2005-11-23 10:59:56', ''),
('en', '_msgs', 'AT_ERROR_FILE_EMPTY', 'You did not select a file to import or the file was empty.', '2004-12-09 14:44:43', 'enrollment manager'),
('en', '_msgs', 'AT_ERROR_FILE_ILLEGAL', '%s files are not allowed.', '2003-05-22 11:52:08', 'error msg'),
('en', '_msgs', 'AT_ERROR_FILE_MAX_SIZE', 'The file exceeded the maximum allowable size limit of %s.', '2004-05-06 13:18:19', ''),
('en', '_msgs', 'AT_ERROR_FILE_NOT_DELETED', 'Error deleting file. Cannot delete file.', '2004-11-08 16:33:12', 'file manager'),
('en', '_msgs', 'AT_ERROR_FILE_NOT_EXIST', 'The selected file does not exist.', '2005-01-07 09:51:45', 'filemanager, fiule to be edited does not exist'),
('en', '_msgs', 'AT_ERROR_FILE_NOT_FOUND', 'File not found.', '2006-03-20 14:45:12', ''),
('en', '_msgs', 'AT_ERROR_FILE_NOT_SAVED', 'The file cannot be saved.', '2003-05-16 13:42:17', 'error msg'),
('en', '_msgs', 'AT_ERROR_FILE_NOT_SELECTED', 'You did not select a file to upload.', '2003-05-16 13:42:17', 'error msg'),
('en', '_msgs', 'AT_ERROR_FILE_TOO_BIG', 'The file size exceeds the limit of <strong>%s </strong>. Contact your ATutor Administrator to have this limit increased.', '2005-01-15 18:49:53', 'error msg'),
('en', '_msgs', 'AT_ERROR_FIRST_LAST_NAME_UNIQUE', 'First, second, and last names combination must be unique.', '2006-03-27 14:55:34', ''),
('en', '_msgs', 'AT_ERROR_FOLDER_NOT_CREATED', 'The folder " %s " could not be created.', '2006-06-02 13:43:53', 'error msg'),
('en', '_msgs', 'AT_ERROR_FOLDER_NOT_EXIST', 'Folder not found.', '2006-03-20 15:37:24', ''),
('en', '_msgs', 'AT_ERROR_FORUM_DENIED', 'You do not  have permission to post in this forum.', '2005-08-10 13:48:14', ''),
('en', '_msgs', 'AT_ERROR_FORUM_NOT_FOUND', 'Forum can not be found.', '2003-05-16 13:42:17', 'error msg'),
('en', '_msgs', 'AT_ERROR_FORUM_NO_DEL_SHARE', 'You do not have permission to delete a shared forum.', '2004-12-10 11:10:25', ''),
('en', '_msgs', 'AT_ERROR_FORUM_NO_EDIT_SHARE', 'You do not have permission to edit a Shared forum.', '2004-12-10 11:15:41', ''),
('en', '_msgs', 'AT_ERROR_FORUM_NO_SUBSCRIBE', 'Cannot subscribe to the requested thread. Only subscription to the top-level post is allowed.', '2004-12-10 13:44:57', 'forum/subscribe.php'),
('en', '_msgs', 'AT_ERROR_GADGET_ADDED_FAILURE', 'The following error occured while adding a gadget:\r\n%s', '2009-06-22 11:19:44', 'gadget error'),
('en', '_msgs', 'AT_ERROR_GADGET_DELETED_CANNOT_BE_EMPTY', 'You need to select at least one application to delete.', '2009-05-27 12:01:11', ''),
('en', '_msgs', 'AT_ERROR_GENERAL', 'This is a search and %s ATutor error.', '2003-05-22 11:52:28', 'error msg'),
('en', '_msgs', 'AT_ERROR_GOOGLE_KEY_INVALID', 'Invalid key.', '2005-11-30 14:35:03', ''),
('en', '_msgs', 'AT_ERROR_GOOGLE_KEY_MISSING', 'A Google Key must be entered in order for the enabled Web Search to be available in courses. Enter this key by going to Google Key under the Configuration tab.', '2005-11-30 14:40:38', ''),
('en', '_msgs', 'AT_ERROR_GOOGLE_QUERY_FAILED', 'Query failed.', '2005-10-20 10:52:04', ''),
('en', '_msgs', 'AT_ERROR_GROUP_CREATION_FAILED', 'Group creation failed.', '2009-05-27 12:01:11', ''),
('en', '_msgs', 'AT_ERROR_GROUP_EDIT_FAILED', 'Group edit failed.', '2009-05-27 12:01:11', ''),
('en', '_msgs', 'AT_ERROR_GROUP_HAS_BEEN_REMOVED', 'Group has been removed.', '2009-05-27 12:01:11', ''),
('en', '_msgs', 'AT_ERROR_GROUP_NOT_FOUND', 'Group not found.', '2004-11-25 16:03:01', ''),
('en', '_msgs', 'AT_ERROR_GROUP_NO_STUDENTS', 'There are no students to create groups for.', '2006-03-22 13:33:24', ''),
('en', '_msgs', 'AT_ERROR_HAND_IN_FOLDER', 'Folders cannot be handed in.', '2006-03-20 15:43:06', ''),
('en', '_msgs', 'AT_ERROR_ID_ZERO', 'Content ID was zero, or was missing.', '2003-05-16 13:42:17', 'error msg'),
('en', '_msgs', 'AT_ERROR_IMPORTDIR_FAILED', 'Unable to create import directory.', '2005-07-20 14:02:57', 'error msg'),
('en', '_msgs', 'AT_ERROR_IMPORTDIR_IMS_NOTVALID', 'The file does not appear to be a valid ZIP file.', '2005-06-27 11:37:47', 'IMS file is not a ZIP file.'),
('en', '_msgs', 'AT_ERROR_IMPORTFILE_EMPTY', 'The import file must not be empty.', '2003-05-16 13:42:17', 'error msg'),
('en', '_msgs', 'AT_ERROR_IMPORT_CARTRIDGE_FAILED', 'Import failed. Does not appear to be a valid content package or common cartridge:\r\n\r\n%s', '2009-12-03 09:55:01', ''),
('en', '_msgs', 'AT_ERROR_IMPORT_ERROR_IN_ZIP', 'Zip file could not be extracted because: <b> %s </b>', '2006-06-28 10:30:50', 'theme manager'),
('en', '_msgs', 'AT_ERROR_IMPORT_FAILED', 'Import Failed', '2005-01-15 09:50:40', ''),
('en', '_msgs', 'AT_ERROR_IMPORT_NOT_PROPER_FORMAT', 'The selected file does not appear to be a valid theme package.', '2004-12-09 11:34:27', 'admin/themes/import.php'),
('en', '_msgs', 'AT_ERROR_IMS_AUTHORIZATION_NOT_SUPPORT', 'Import failed.  ATutor does not support package authentications.', '2009-12-10 12:19:12', ''),
('en', '_msgs', 'AT_ERROR_INCOMPLETE', 'Please fill out the forms as directed below', '2004-10-18 11:14:50', 'enrollment Manager, incomplete info in create list'),
('en', '_msgs', 'AT_ERROR_INCORRECT_FILE_FORMAT', 'File is in the incorrect format. Review line %s of your course list file and make sure it follows format guidelines.', '2006-06-28 10:43:48', ''),
('en', '_msgs', 'AT_ERROR_INST_INFO_NOT_FOUND', 'Instructor information cannot be found.', '2003-05-16 13:42:17', 'error msg'),
('en', '_msgs', 'AT_ERROR_INVALID_EMAIL', 'Email address is invalid.', '2013-09-11 12:34:03', ''),
('en', '_msgs', 'AT_ERROR_INVALID_LINK', 'The link is either invalid or expired.', '2006-05-10 09:08:50', ''),
('en', '_msgs', 'AT_ERROR_INVALID_LOGIN', 'Invalid login/password combination.', '2003-05-16 13:42:17', 'error msg'),
('en', '_msgs', 'AT_ERROR_INVALID_URL', 'Localhost is not a valid URL', '2004-11-05 10:22:37', 'AChecker'),
('en', '_msgs', 'AT_ERROR_ITEM_NOT_FOUND', 'Item not found.', '2006-10-04 10:52:48', 'generic something not found msg.'),
('en', '_msgs', 'AT_ERROR_JOIN_REQUEST_FAILED', 'Request to join group failed. Perhaps you have already requested to join this group.', '2009-05-27 12:01:11', ''),
('en', '_msgs', 'AT_ERROR_LANG_EXISTS', 'The language pack you are trying to import already exists. Language already exists. You can edit language properties by following the <em>translate</em> in the sub menu above.', '2007-02-06 15:44:17', ''),
('en', '_msgs', 'AT_ERROR_LANG_IMPORT_FAILED', 'Language import failed.', '2003-06-06 11:23:51', 'admin language manager'),
('en', '_msgs', 'AT_ERROR_LANG_NOT_COMPLETE', 'The language pack you are trying to import has not been marked as complete and published. To use incomplete language packs you must enable <em>translating</em> using the instructions at the bottom of this page.', '2005-11-30 14:49:00', ''),
('en', '_msgs', 'AT_ERROR_LANG_WRONG_VERSION', 'The language pack you are trying to import is not compatible with this version of ATutor. If you still want to import this language pack you must enable <em>translating</em> following the instructions under the Translate Tab.', '2011-09-08 16:21:58', ''),
('en', '_msgs', 'AT_ERROR_LAST_LANGUAGE', 'Cannot delete the last language. At least one language must be available.', '2006-06-29 16:50:59', ''),
('en', '_msgs', 'AT_ERROR_LINK_CAT_EMPTY', 'Cannot add a link because there are no categories.', '2005-03-09 13:05:25', 'adding link but no cats'),
('en', '_msgs', 'AT_ERROR_LINK_CAT_NOT_EMPTY', 'Link category cannot be deleted because it contains sub-categories and/or links.', '2005-02-22 15:22:44', 'error msg'),
('en', '_msgs', 'AT_ERROR_LOGIN_CHARS', 'Your Login Name must only contain letters, numbers, periods, or underscores (_''s).', '2006-07-11 10:40:57', 'error msg'),
('en', '_msgs', 'AT_ERROR_LOGIN_ENROL', 'You must be logged in to enroll in a course.', '2003-05-16 13:42:17', 'error msg'),
('en', '_msgs', 'AT_ERROR_LOGIN_EXISTS', 'That login already exists, please choose another.', '2003-05-16 13:42:17', 'error msg'),
('en', '_msgs', 'AT_ERROR_LOGIN_TO_POST', 'You must be logged in to post.', '2003-05-16 13:42:17', 'error msg'),
('en', '_msgs', 'AT_ERROR_LOG_NOT_RESET', 'The error log could not be reset.', '2005-03-10 15:54:03', 'error logging'),
('en', '_msgs', 'AT_ERROR_MAX_LOGIN_ATTEMPT', 'Maximum login attempts has been reached. Login has been temporarily disabled for 1 hour.  Please try again later.', '2009-06-17 11:59:49', ''),
('en', '_msgs', 'AT_ERROR_MAX_LOGIN_ATTEMPT_1', 'Invalid username or password. You have one more attempt before the login page is disabled.', '2009-06-26 16:37:13', ''),
('en', '_msgs', 'AT_ERROR_MAX_LOGIN_ATTEMPT_2', 'You have entered an unrecognized login and password combination. You have two more attempts before the login page is disabled.', '2009-06-26 16:35:44', ''),
('en', '_msgs', 'AT_ERROR_MAX_STORAGE_EXCEEDED', 'Adding this file exceeds the maximum course storage limit.', '2003-10-03 16:00:08', 'error msg'),
('en', '_msgs', 'AT_ERROR_MISSING_TEST', 'Two tests must be selected to combine tests.', '2013-09-23 19:28:04', 'gradebook combine test'),
('en', '_msgs', 'AT_ERROR_MISSING_THEMEXML', 'Cannot import. The import package is missing a vital component: themes.xml. Check that the theme package is for version 1.4.3 or above.', '2004-12-09 11:59:21', 'admin/themese/import.php'),
('en', '_msgs', 'AT_ERROR_MODULE_INSTALL', 'The following error(s) were encountered when trying to install this module:\r\n<ul>%s</ul>', '2005-10-11 10:48:49', ''),
('en', '_msgs', 'AT_ERROR_MODULE_UNINSTALL', 'The following error(s) were encountered when trying to install this module:\r\n<ul>%s</ul>', '2008-10-21 15:41:53', 'error msg'),
('en', '_msgs', 'AT_ERROR_MYSQL_FAILED', 'Connection to MySQL failed.', '2009-12-01 11:07:33', ''),
('en', '_msgs', 'AT_ERROR_NEED_FILENAME', 'Filename was left empty. Need a filename to create new file.', '2004-11-09 16:19:24', 'file manager'),
('en', '_msgs', 'AT_ERROR_NEED_UNIQUE_TOOLID', 'The ToolID is already in use. Choose another.', '2013-09-07 09:50:48', 'admin create LTI'),
('en', '_msgs', 'AT_ERROR_NODELETE_USER', 'Cannot delete this user because they own courses. Delete the courses first.', '2003-05-16 13:42:17', 'error msg'),
('en', '_msgs', 'AT_ERROR_NOT_CONFIRMED', 'Your account''s email address has not yet been confirmed.  Please check your email account for a confirmation message.  Please contact us if you do not receive it.', '2006-06-21 10:59:56', ''),
('en', '_msgs', 'AT_ERROR_NOT_IN_ANY_GROUPS', 'You are not in any groups.', '2006-04-11 13:34:20', ''),
('en', '_msgs', 'AT_ERROR_NOT_OWNER', 'You do not own this course or it does not exist.', '2003-05-16 13:42:17', 'error msg'),
('en', '_msgs', 'AT_ERROR_NOT_RELEASED', 'This content has not yet been released. %s', '2003-05-22 11:52:38', 'error msg'),
('en', '_msgs', 'AT_ERROR_NO_ACTION_SELECTED', 'No action selected.', '2007-02-21 14:12:39', ''),
('en', '_msgs', 'AT_ERROR_NO_ASSIGNMENTS_FOUND', 'No assignments are due in this workspace. You might try another workspace.', '2007-12-13 16:12:07', ''),
('en', '_msgs', 'AT_ERROR_NO_BOXES_CHECKED', 'You must select at least one checkbox.', '2010-04-12 16:39:34', ''),
('en', '_msgs', 'AT_ERROR_NO_CHILD_AS_PARENT', 'Cannot move the content to be the child of its own children.', '2009-09-16 13:14:12', ''),
('en', '_msgs', 'AT_ERROR_NO_CONTENT_SPACE', 'Not enough space to import content directory. %s KB over the limit.', '2003-10-03 15:58:38', 'error msg'),
('en', '_msgs', 'AT_ERROR_NO_COURSE_FLOAT', 'Invalid Maximum Course Float value.', '2005-06-20 10:44:45', 'Admin did not specify a float for course size.'),
('en', '_msgs', 'AT_ERROR_NO_FAQ_TOPICS', 'You must first add a topic.', '2005-10-19 12:44:36', ''),
('en', '_msgs', 'AT_ERROR_NO_IMSMANIFEST', 'IMS manifest file is missing. This does not appear to be a valid IMS content package or common cartridge.', '2009-11-17 12:38:14', ''),
('en', '_msgs', 'AT_ERROR_NO_IMS_BACKUP', 'This file appears to be a <a href="mods/_core/backups/">course backup</a> rather than a content package.', '2010-03-09 14:27:08', ''),
('en', '_msgs', 'AT_ERROR_NO_ITEM_SELECTED', 'You must select an item before using a button.', '2005-03-07 16:36:43', ''),
('en', '_msgs', 'AT_ERROR_NO_LANGUAGE', 'Selected language is not supported.', '2003-05-16 13:42:17', 'error msg'),
('en', '_msgs', 'AT_ERROR_NO_LOGS_SELECTED', 'You must select at least one profile to create a bundle.', '2004-11-25 11:18:19', 'admin/error_logging_details.php'),
('en', '_msgs', 'AT_ERROR_NO_LOG_SELECTED', 'You did not select a log file.', '2004-11-23 15:59:57', 'admin/error_logging_details.php'),
('en', '_msgs', 'AT_ERROR_NO_MEMBERS', 'No users found.', '2005-05-18 12:43:40', ''),
('en', '_msgs', 'AT_ERROR_NO_PROFILE_SELECTED', 'You did not select a profile.', '2004-11-23 16:01:27', 'admin/error_logging_details.php'),
('en', '_msgs', 'AT_ERROR_NO_QUESTIONS', 'No questions were found for this test.', '2003-05-16 13:42:17', 'error msg'),
('en', '_msgs', 'AT_ERROR_NO_QUESTIONS_SELECTED', 'You did not select any questions to add to this test.', '2004-11-23 11:56:45', ''),
('en', '_msgs', 'AT_ERROR_NO_RECIPIENTS', 'There are no recipients of this email.', '2013-09-11 12:34:03', ''),
('en', '_msgs', 'AT_ERROR_NO_SELF_AS_PARENT', 'Cannot move the content to be its own child.', '2009-09-16 13:14:00', ''),
('en', '_msgs', 'AT_ERROR_NO_SPACE_LEFT', 'There is no more space in this course to extract this archive.', '2003-05-16 13:42:17', 'error msg'),
('en', '_msgs', 'AT_ERROR_NO_STUDENT_SELECTED', 'You did not select any students.', '2006-06-27 12:18:13', 'enrollment manager, no students selected'),
('en', '_msgs', 'AT_ERROR_NO_SUCH_USER', 'The user you selected does not exist.', '2005-03-17 15:34:30', 'veiwing profile but no such user'),
('en', '_msgs', 'AT_ERROR_ONLY_EXPORT_EXTRA_MODULE', 'You can only export Extra modules.', '2013-01-19 16:16:18', ''),
('en', '_msgs', 'AT_ERROR_ONLY_UNINSTALL_EXTRA_MODULE', 'Only modules with type "Extra" can be uninstalled.', '2008-10-21 15:41:53', ''),
('en', '_msgs', 'AT_ERROR_PACKAGE_DIR_FAILED', 'Problem with Package Directory.', '2005-05-17 12:02:28', ''),
('en', '_msgs', 'AT_ERROR_PAGE_NOT_FOUND', 'Page cannot be found.', '2005-09-19 12:18:06', 'error msg');



INSERT INTO `[[dbprefix]]language_text` VALUES
('en', '_template', 'file_storage_edit_file', 'File Storage - Edit File', '2010-12-08 20:15:04', 'File Storage'),
('en', '_template', 'file_storage_edit_folder', 'File Storage - Edit Folder', '2010-12-08 20:15:31', 'File Storage'),
('en', '_template', 'file_storage_move', 'File Storage - Move', '2010-12-08 20:15:52', 'File Storage'),
('en', '_template', 'file_storage_new_file', 'File Storage - New File', '2010-12-08 20:21:53', 'File Storage'),
('en', '_template', 'file_storage_version_control', 'Maintain File Storage Version Control', '2010-06-29 14:29:49', ''),
('en', '_template', 'file_to_read', 'File To Read', '2006-04-13 11:03:16', ''),
('en', '_template', 'fill_groups', 'Fill Groups', '2006-03-22 11:52:47', ''),
('en', '_template', 'fill_groups_randomly', 'Fill groups randomly upon creation.', '2006-03-22 11:53:14', ''),
('en', '_template', 'filter', 'Filter', '2005-03-30 14:52:33', ''),
('en', '_template', 'final_score', 'Final Score', '2007-03-16 14:10:05', ''),
('en', '_template', 'find_gadgets', 'Find Gadgets', '2009-07-13 14:55:51', ''),
('en', '_template', 'find_results_in', 'Find results in', '2004-08-18 12:02:16', ''),
('en', '_template', 'first_name', 'First Name', '2003-05-20 09:58:26', 'registration, profile'),
('en', '_template', 'fix_content_ordering', 'Fix Content Ordering', '2004-10-18 14:03:47', ''),
('en', '_template', 'fix_content_ordering_text', 'Occasionally, content pages can get disordered due to miscalculation. This is an ongoing issue that will be resolved in an upcoming version of ATutor but until then, we have made a patch available that can be used to fix the issue. If you are experiencing this problem, please use the button below.', '2005-03-10 11:19:41', ''),
('en', '_template', 'flag_text', '<small>%s indicates files have been handed in.</small>', '2011-05-30 10:07:17', ''),
('en', '_template', 'flowplayer', 'Flowplayer', '2010-03-18 11:46:30', ''),
('en', '_template', 'focus', 'Focus', '2008-10-06 13:41:36', ''),
('en', '_template', 'folder', 'Folder', '2003-05-20 10:05:51', 'file manager, zip utility'),
('en', '_template', 'font_face', 'Font Face', '2008-09-09 09:01:13', ''),
('en', '_template', 'font_size', 'Font Size', '2008-09-09 09:01:13', ''),
('en', '_template', 'formatting', 'Formatting', '2003-05-20 10:07:25', 'add/ edit content, news, export'),
('en', '_template', 'form_editor', 'Atutor Form Editor', '2005-03-11 10:31:45', 'Form editor for test questions'),
('en', '_template', 'form_focus', 'Form Focus On Page Load', '2005-03-29 12:38:11', ''),
('en', '_template', 'forum', 'Forum', '2004-04-16 10:54:23', 'Forum list header'),
('en', '_template', 'forums', 'Forums', '2003-05-20 10:08:05', 'global forums label'),
('en', '_template', 'forum_date_format', '%%D %%M %%j %%H:%%i', '2004-05-26 15:18:29', ''),
('en', '_template', 'forum_email_links', 'All email addresses are made into links.', '2003-05-20 10:11:14', 'forums email address links instruction'),
('en', '_template', 'forum_general_discussion', 'General Discussion', '2004-12-16 11:07:19', 'default forum in forum list'),
('en', '_template', 'forum_html_disabled', 'HTML is disabled.', '2003-05-20 10:11:42', 'forum compose message'),
('en', '_template', 'forum_links', 'All words starting with http:// are made into links.', '2003-05-20 10:12:23', 'forum compose link creation instruction'),
('en', '_template', 'forum_new_submsg', '*DO NOT REPLY TO THIS MESSAGE*\r\nA discussion thread in the ATutor course "%s" has recieved a reply. Login to access the "%s" forum and view the "%s" thread. Click and view the message at: %s', '2009-12-16 11:51:02', 'forum email message to thread subscribers'),
('en', '_template', 'forum_posts', 'Forum Posts', '2005-03-16 14:59:41', ''),
('en', '_template', 'forum_reply_to', 'Replying To', '2003-05-20 10:12:48', 'forum reply to label for quoted messages'),
('en', '_template', 'forward', 'Forward', '2007-02-20 16:21:52', ''),
('en', '_template', 'french', 'French', '2008-09-09 09:01:12', ''),
('en', '_template', 'french-lsf', 'French-LSF', '2008-09-09 09:01:12', ''),
('en', '_template', 'friends', 'My Contacts', '2009-05-27 12:01:11', ''),
('en', '_template', 'friends_of_friends', 'Contacts of Your Contacts', '2009-05-27 12:01:11', ''),
('en', '_template', 'from', 'From', '2003-05-20 10:17:19', 'global from label'),
('en', '_template', 'from_atutor', 'This message was sent through the ATutor system from course %s.', '2003-05-20 10:19:30', 'instructor/admin contact for email message'),
('en', '_template', 'from_email', 'From Email', '2003-05-20 10:21:35', 'instructor/admin contact form'),
('en', '_template', 'from_name', 'From Name', '2003-05-20 10:22:02', 'instrcutor/admin contact from'),
('en', '_template', 'fs_comment', '%s Comment', '2006-06-29 10:09:37', ''),
('en', '_template', 'fs_comments', '%s Comments', '2006-06-29 09:55:11', ''),
('en', '_template', 'fs_revision', '%s Revision', '2006-06-29 10:05:39', ''),
('en', '_template', 'fs_revisions', '%s Revisions', '2006-06-29 09:52:36', ''),
('en', '_template', 'full_name', 'Full Name', '2006-03-27 15:55:44', ''),
('en', '_template', 'fwd', 'Fwd', '2007-02-20 16:20:07', ''),
('en', '_template', 'g', 'G', '2007-01-10 13:48:18', ''),
('en', '_template', 'gender', 'Sex', '2003-05-20 10:22:19', 'registration, profile'),
('en', '_template', 'general_help', 'For guidance on using ATutor see the official <a href="%1$s" onclick="poptastic(''%1$s''); return false;" target="new"><strong>ATutor Handbook</strong></a>.', '2014-01-12 17:02:34', 'atutor default footer'),
('en', '_template', 'geography', 'Geographic', '2009-05-27 12:01:11', ''),
('en', '_template', 'german', 'German', '2008-09-09 09:01:12', ''),
('en', '_template', 'german-dgs', 'German-DGS', '2008-09-09 09:01:12', ''),
('en', '_template', 'give_description', 'Brief description of your proposed course(s)', '2005-03-09 12:19:48', 'control centre request instructor account form'),
('en', '_template', 'global_more_than_10_pages', 'Global: More than 10 pages.', '2006-09-27 12:42:43', ''),
('en', '_template', 'glossary', 'Glossary', '2003-05-20 10:24:33', 'global glossary label'),
('en', '_template', 'glossary_definition', 'Definition', '2003-05-20 10:25:13', 'glossary add/edit term'),
('en', '_template', 'glossary_related', 'Related Term', '2003-05-20 10:26:35', 'add/edit glossary term'),
('en', '_template', 'glossary_term', 'Term', '2003-05-20 10:27:01', 'add/edit glossary term'),
('en', '_template', 'glossary_terms', 'Glossary Terms', '2003-05-20 10:27:47', 'delete course feedback for terms deleted'),
('en', '_template', 'glossary_term_limit', 'This term exceeds the 60 character limit and cannot be added.', '2005-12-12 11:39:08', ''),
('en', '_template', 'go', 'Go!', '2006-04-26 13:47:29', ''),
('en', '_template', 'google_key', 'Google Key', '2005-10-20 11:02:40', ''),
('en', '_template', 'google_key_txt', 'To access the Google search as an <em>embedded service</em>, you must first create an account and obtain a license key at <a href="http://code.google.com/apis/ajaxsearch/signup.html" target="_new">google.com/apis</a> and enter it below.\r\n<br /><br />\r\nThe search can be used as an external service by clearing the key field below.', '2007-09-04 15:14:30', ''),
('en', '_template', 'google_new_window', 'Search opens in a new window.', '2005-11-30 16:45:26', ''),
('en', '_template', 'google_search', 'Web Search', '2005-10-20 10:35:41', ''),
('en', '_template', 'google_search_ajax', 'Google AJAX Search <em>(requires license key</em> <strong>after</strong> <em>Dec 5th, 2006)</em>', '2008-07-28 10:51:24', 'Google search'),
('en', '_template', 'google_search_attn', 'Please note that the old Google search is only applicable to those who have obtained a license key before Dec 5th, 2006; any new license key obtained after December 5th, 2006 is only applicable to the new Google AJAX search.', '2007-09-04 14:55:56', 'Google search'),
('en', '_template', 'google_search_books', 'Books', '2007-08-31 11:25:12', 'Google search'),
('en', '_template', 'google_search_images', 'Images', '2007-08-31 11:22:38', 'Google search'),
('en', '_template', 'google_search_local', 'Local', '2007-08-31 11:57:07', 'Google search'),
('en', '_template', 'google_search_news', 'News', '2007-08-31 11:23:30', 'Google search'),
('en', '_template', 'google_search_soap', 'Old Google Search <em>(requires license key</em> <b>before</b> <em>Dec 5th, 2006)</em>', '2008-07-28 10:51:46', 'Google search'),
('en', '_template', 'google_search_text', 'Search the Web outside this course for additional information.', '2009-07-02 14:17:14', ''),
('en', '_template', 'google_search_txt', 'To search for specific words within a website, enter them below then use the ''Search'' button.  If you wish to search course content, use the <a href="search.php">content search</a>.', '2005-10-20 11:02:02', ''),
('en', '_template', 'google_search_type_txt', 'Please select one of the Google search interfaces.', '2007-08-31 14:36:30', 'Google search'),
('en', '_template', 'google_search_videos', 'Videos', '2007-08-31 11:22:53', 'Google search'),
('en', '_template', 'goto_content', 'Go to content', '2004-05-11 15:18:23', ''),
('en', '_template', 'goto_main_nav', 'Jump to Main Navigation', '2014-01-01 17:34:51', 'bypass link'),
('en', '_template', 'goto_menu', 'Go to Menu', '2006-07-14 10:14:57', '2nd invisible link on the page'),
('en', '_template', 'goto_top', 'Go to Top', '2003-05-20 10:34:03', 'bypass link text in ATutor header'),
('en', '_template', 'go_to_my_start_page', 'Go To My Start Page', '2008-03-10 12:02:45', 'auto enroll property'),
('en', '_template', 'grade', 'Grade', '2008-09-25 16:01:17', 'gradebook'),
('en', '_template', 'gradebook', 'Gradebook', '2011-05-11 14:40:35', ''),
('en', '_template', 'gradebook_text', 'Review marks for your tests and assignments.', '2009-07-02 14:16:20', ''),
('en', '_template', 'grades_uncomparable', 'Grades are uncomparable. Choose another way to solve conflict', '2008-09-25 16:01:17', 'gradebook'),
('en', '_template', 'grade_already_exists', 'Conflict: Grade already exists - %s', '2008-09-25 16:01:17', 'gradebook'),
('en', '_template', 'grade_info', 'Note: "Grade" field can be grade defined in "Grade Scale" or percentage like 50%%.', '2008-09-25 16:01:17', 'gradebook'),
('en', '_template', 'grade_scale', 'Grade Scale', '2008-09-25 15:59:56', 'gradebook'),
('en', '_template', 'grant_write_permission', 'Please grant <strong>write</strong> permission to folders and files listed below:<p><strong>Note:</strong> To change permissions on Unix use <kbd>chmod a+rw</kbd> then the file name.</p>', '2008-04-21 15:08:55', 'patcher'),
('en', '_template', 'graph', 'Graph', '2003-05-20 10:36:18', 'instructor course details graph label'),
('en', '_template', 'gray', 'Gray', '2003-05-20 10:36:32', 'global code picker'),
('en', '_template', 'green', 'Green', '2003-05-20 10:36:45', 'global code picker'),
('en', '_template', 'group', 'Group', '2005-05-03 15:42:38', ''),
('en', '_template', 'grouped_by_course', 'Grouped by course', '2004-08-18 12:04:40', ''),
('en', '_template', 'groups', 'Groups', '2004-11-25 15:45:26', ''),
('en', '_template', 'groups_create_automatic', 'Create multiple groups automatically', '2006-03-21 15:36:08', ''),
('en', '_template', 'groups_create_manual', 'Create a single group manually', '2006-03-21 15:36:58', ''),
('en', '_template', 'groups_text', 'Participate in group learning activities.', '2009-07-02 14:16:03', ''),
('en', '_template', 'groups_type', 'Groups Type', '2006-03-22 11:16:01', ''),
('en', '_template', 'group_about_private', 'Users will have to be approved by the moderator to join this group.', '2009-05-27 12:01:11', ''),
('en', '_template', 'group_about_public', 'The group is opened to all users.  No approval is needed.', '2009-05-27 12:01:11', ''),
('en', '_template', 'group_admin', 'Group Moderator', '2009-05-27 12:01:11', ''),
('en', '_template', 'group_forums', 'Group Forums', '2006-05-24 08:48:58', ''),
('en', '_template', 'group_info', 'Group Details', '2009-05-27 12:01:11', ''),
('en', '_template', 'group_invitation', 'ATutor Social Group Invitation', '2009-05-27 12:01:11', ''),
('en', '_template', 'group_invitation_accepted', 'ATutor Social Group Invitation Accepted', '2009-05-27 12:01:11', ''),
('en', '_template', 'group_joined', 'You are a member of this group.', '2009-05-27 12:01:11', ''),
('en', '_template', 'group_last_update', 'Last Update', '2009-05-27 12:01:11', ''),
('en', '_template', 'group_last_updated', 'Last Updated ', '2009-05-27 12:01:11', ''),
('en', '_template', 'group_logo', 'Group Logo', '2009-05-27 12:01:11', ''),
('en', '_template', 'group_members', 'Group Members', '2005-06-10 10:34:56', ''),
('en', '_template', 'group_name', 'Group Name', '2009-05-27 12:01:11', ''),
('en', '_template', 'group_prefix', 'Group Prefix', '2006-03-22 11:17:12', ''),
('en', '_template', 'group_request', 'ATutor Social Join Group Request', '2009-05-27 12:01:11', ''),
('en', '_template', 'group_request_accepted', 'ATutor Social Group Request Accepted', '2009-05-27 12:01:11', ''),
('en', '_template', 'group_type', 'Group Type', '2009-05-27 12:01:11', ''),
('en', '_template', 'guest', 'Guest', '2003-05-20 10:37:10', 'name assigned to non-registered users'),
('en', '_template', 'guests', 'Guests', '2003-05-20 10:38:19', 'instructor course stats/details'),
('en', '_template', 'guests_not_listed', 'Guests are not listed', '2003-05-20 10:38:32', 'who''s on menu'),
('en', '_template', 'guest_information', 'Guest Information', '2008-10-06 13:40:43', ''),
('en', '_template', 'guest_name', 'Guest Name', '2008-10-06 13:41:12', ''),
('en', '_template', 'guide', 'Guide', '2010-09-21 11:46:53', 'mobile header.tmpl'),
('en', '_template', 'h', 'H', '2007-01-10 13:48:22', ''),
('en', '_template', 'handout_to_read', 'Handout to Read', '2006-04-13 11:58:39', ''),
('en', '_template', 'hand_in', 'Hand In', '2006-03-20 14:36:56', ''),
('en', '_template', 'has_added_app', 'has added the <a href="%s">%s</a>  gadget', '2009-05-27 12:01:11', ''),
('en', '_template', 'has_added_group', 'has added the group %s.', '2009-07-22 14:35:24', ''),
('en', '_template', 'has_invited_join', '%s has invited you to join the group %s.', '2009-07-22 14:36:55', ''),
('en', '_template', 'has_joined_group', 'has joined the group %s.', '2009-07-22 14:35:05', ''),
('en', '_template', 'has_requested_to', '%s has requested to join the group %s.', '2009-05-27 12:01:11', ''),
('en', '_template', 'has_updated_group', 'has updated the group %s.', '2009-07-22 14:35:56', ''),
('en', '_template', 'have', 'Have', '2007-02-21 13:22:47', ''),
('en', '_template', 'have_not', 'Have not', '2007-02-21 14:06:25', ''),
('en', '_template', 'help', 'Help', '2003-05-20 10:41:08', 'global help label'),
('en', '_template', 'hidden', 'Hidden', '2003-05-20 10:42:27', 'instructor/admin contact form'),
('en', '_template', 'hide', 'Hide', '2005-03-15 11:37:50', ''),
('en', '_template', 'hide_all_remedial', 'Hide All Remedial Content', '2013-01-23 14:19:48', ''),
('en', '_template', 'hide_course', 'Hide this course from the Browse Courses list', '2003-05-20 10:42:41', 'create course screen'),
('en', '_template', 'hide_feedback', 'Hide Feedback', '2013-12-18 18:41:36', ''),
('en', '_template', 'hide_side_menu', 'Hide Side Menu', '2014-07-08 18:50:56', 'hide side menu toggle'),
('en', '_template', 'hide_sub_navigation', '. Toggle sub navigation closed.', '2013-12-26 17:30:46', ''),
('en', '_template', 'history', 'History', '2003-05-25 08:36:00', 'context (removed after v1.1)'),
('en', '_template', 'hits', 'Hits', '2003-05-20 10:44:14', 'links database link hit count'),
('en', '_template', 'hit_count', 'Hit Count', '2003-05-20 10:45:17', 'tracker'),
('en', '_template', 'hl_colour', 'Highlight Colour', '2008-09-09 09:01:13', ''),
('en', '_template', 'home', 'Home', '2006-05-31 11:12:30', ''),
('en', '_template', 'home_url', 'Home URL', '2005-03-03 10:50:09', ''),
('en', '_template', 'horizontal', 'Horizontal', '2004-12-01 13:35:05', 'edit/create option test questions'),
('en', '_template', 'hot', 'Hot!', '2003-05-20 10:47:10', '(not used)'),
('en', '_template', 'hot_thread', 'Hot topic!', '2014-01-02 15:40:23', 'forum message for busy thread'),
('en', '_template', 'hours_24', '24hr', '2003-05-20 10:48:10', 'release date picker'),
('en', '_template', 'hour_short', 'h', '2007-07-09 12:31:21', ''),
('en', '_template', 'howto_course', '<a href="https://atutor.github.io/atutor/docs/index.html">ATutor Documentation</a>', '2018-04-11 18:28:21', 'help'),
('en', '_template', 'howto_course_text', 'In addition to the <a href="documentation/" onclick="poptastic(''documentation/''); return false;" target="_new"><em>ATutor Handbook</em></a> bundled with ATutor, other <a href="https://atutor.github.io/atutor/docs/index.html">ATutor Documentation</a> is available on Github.', '2018-04-11 18:32:20', ''),
('en', '_template', 'how_to_solve_conflict', 'How to solve conflict', '2008-09-25 16:01:17', 'gradebook'),
('en', '_template', 'html', 'HTML', '2003-05-20 10:48:48', 'global HTML label'),
('en', '_template', 'html_only', ' Plain Text or HTML files only.', '2003-05-20 10:49:49', 'add/edit content, header'),
('en', '_template', 'i', 'I', '2007-01-10 13:48:26', ''),
('en', '_template', 'icon', 'Icon', '2005-03-03 11:19:49', ''),
('en', '_template', 'icon_on', 'icon view turned on', '2014-01-01 15:18:28', 'icon/detailed view switch'),
('en', '_template', 'icon_view', 'icon view', '2014-01-01 14:43:12', ''),
('en', '_template', 'id', 'ID', '2003-05-20 10:50:57', 'global ID (identification number) label'),
('en', '_template', 'ignore_validation', 'Ignore validation', '2010-06-16 10:01:11', ''),
('en', '_template', 'illegal_file', 'Illegal File Type', '2003-05-20 10:52:36', 'zip utility when archive contain illegal extension'),
('en', '_template', 'illegal_file_extensions', 'Illegal File Extensions', '2005-03-03 10:52:15', ''),
('en', '_template', 'image', 'Image', '2003-05-20 10:53:28', 'global code picker image code link text'),
('en', '_template', 'image_validation_text', 'In the above image there are numbers and/or letters displayed.  Please type them into the following field.', '2009-07-16 09:02:13', ''),
('en', '_template', 'image_validation_text2', 'This helps ensure a live person is registering on this system.', '2009-06-03 15:33:17', ''),
('en', '_template', 'import', 'Import', '2003-05-20 11:56:51', 'instructor import/export screen'),
('en', '_template', 'import_a_new_lang', 'Import a New Language', '2003-06-04 15:34:43', 'admin language manager'),
('en', '_template', 'import_content', 'Import Content', '2005-02-18 14:05:57', ''),
('en', '_template', 'import_content_info', 'Import a conformant IMS content package or IMS common cartridge. Select a location within the existing content to <strong>import into</strong>.  Or enter a URL to content package or common cartridge, to import directly from the Web.', '2009-11-12 16:56:26', ''),
('en', '_template', 'import_content_package', 'Import Content Package', '2003-10-03 13:07:38', ''),
('en', '_template', 'import_content_package_bottom_subcontent', 'As top level content, or as subcontent selected below', '2003-10-20 13:36:27', ''),
('en', '_template', 'import_content_package_where', 'Import into', '2003-10-14 12:24:03', ''),
('en', '_template', 'import_err_email_exists', 'Account exists.', '2004-01-30 15:38:42', ''),
('en', '_template', 'import_err_email_invalid', 'Email invalid.', '2004-01-30 13:28:32', ''),
('en', '_template', 'import_err_email_missing', 'Email missing.', '2004-01-30 13:28:40', ''),
('en', '_template', 'import_err_full_name_exists', 'First and Last name exist.', '2006-03-28 10:40:02', ''),
('en', '_template', 'import_err_username_exists', 'Username already taken.', '2004-01-30 13:28:48', ''),
('en', '_template', 'import_err_username_invalid', 'Username contains invalid characters.', '2004-01-30 13:28:56', ''),
('en', '_template', 'import_export_external_marks', 'External Marks', '2008-09-25 16:01:17', 'gradebook'),
('en', '_template', 'import_lang_howto', 'You may import additional languages into this installation of ATutor by downloading the language pack from atutorlangs on Github, then uploading it using the form below. Or, if the Import Language selector is available below, then language can be imported directly from Github.', '2018-03-15 19:51:26', 'admin language manager'),
('en', '_template', 'import_marks_info', 'A mark list may be imported into ATutor. Create the mark list in a comma separated values (CSV) format as follows: "firstname", "lastname", "email", "mark" with one student per line. Please leave the first line as title. The mark in CSV file can be grade or percentage like 50%%. To simplify the process, you can export the CSV file with export functionality, update the marks into exported file and import back into ATutor.', '2008-09-25 16:01:17', 'gradebook'),
('en', '_template', 'import_package', 'Import Package', '2005-05-17 12:06:10', ''),
('en', '_template', 'import_question', 'Import Questions', '2008-09-23 13:59:41', ''),
('en', '_template', 'import_remote_language', 'Or, import a language directly from atutorlangs on Github.', '2018-03-15 19:45:57', ''),
('en', '_template', 'import_sep_txt', 'For auto-generated usernames, separate first and last names with:', '2004-06-22 12:07:48', ''),
('en', '_template', 'import_test', 'Import Test', '2008-09-23 13:52:19', ''),
('en', '_template', 'import_theme', 'Import Theme', '2004-10-15 15:47:13', 'import theme button in theme manager'),
('en', '_template', 'ims_files_missing', 'In this package, the file, %1$s, is missing or misplaced.', '2009-12-07 14:25:04', ''),
('en', '_template', 'ims_missing_references', 'Missing file references', '2009-12-07 16:27:01', ''),
('en', '_template', 'inactive_admin', 'Inactive Administrator', '2005-03-03 11:00:55', ''),
('en', '_template', 'inbox', 'Inbox', '2003-05-20 11:59:47', 'global Inbox label'),
('en', '_template', 'inbox_date_format', '%%l %%M %%j, %%Y - %%H:%%i', '2003-05-20 12:00:47', 'inbox screen (see www.php.net/date for codes)'),
('en', '_template', 'inbox_notification', 'Inbox Notification', '2005-03-16 14:40:07', ''),
('en', '_template', 'info', 'Course Info', '2005-04-01 15:09:41', 'global info message box label'),
('en', '_template', 'initial_content', 'Initial Content', '2004-10-15 15:45:10', ''),
('en', '_template', 'insert', 'Insert', '2003-05-20 12:02:16', 'instructor add content screen'),
('en', '_template', 'insert_into', 'Insert Into', '2005-03-03 12:15:49', ''),
('en', '_template', 'install', 'Install', '2005-08-16 15:51:57', ''),
('en', '_template', 'installed', 'Installed', '2008-10-28 10:58:39', ''),
('en', '_template', 'installed_date', 'Installed Date', '2008-11-17 10:41:34', ''),
('en', '_template', 'install_modules', 'Install Modules', '2005-08-16 16:17:09', ''),
('en', '_template', 'install_module_text', 'To install a new module it must first be extracted into the <code>%s</code> directory for it to appear in the list below.', '2005-08-17 13:47:02', ''),
('en', '_template', 'install_themes', 'Install Themes', '2008-11-14 11:47:00', ''),
('en', '_template', 'install_themes_text', 'To install new themes the <code>%s</code> directory must be set to writeable. Use the command <kbd>chmod a+w themes</kbd> on Unix machines, while on Windows the web server must have write permissions on that directory.', '2005-12-14 12:36:08', ''),
('en', '_template', 'institution', 'School/Institution', '2009-05-27 12:01:11', ''),
('en', '_template', 'instructions', 'Instructions', '2005-04-05 14:25:07', ''),
('en', '_template', 'instructions_placeholder', 'Enter information about how the test should be taken.', '2013-01-23 14:15:37', ''),
('en', '_template', 'instructor', 'Instructor', '2003-05-20 12:02:59', 'global instructor label'),
('en', '_template', 'instructors', 'Instructors', '2003-05-20 12:03:37', 'admin general statistics label for number of instructors'),
('en', '_template', 'instructor_contact_form', 'Instructor Contact Form', '2003-05-20 12:12:32', 'instructor contact form heading'),
('en', '_template', 'instructor_request', 'ATutor Instructor Request', '2003-05-25 08:37:50', 'subject line in email to admin when instructor request is made'),
('en', '_template', 'instructor_requests', 'Instructor Requests', '2003-05-20 12:19:52', 'admin home page heading'),
('en', '_template', 'instructor_requests_text', 'There are <strong>%s</strong> instructor requests pending approval.', '2005-03-30 15:30:02', ''),
('en', '_template', 'instructor_request_deny', 'Your ATutor instructor request has been denied.', '2003-10-06 15:14:48', 'email message to denied instructor'),
('en', '_template', 'instructor_request_denymsg1', 'Registration information is incomplete.', '2003-10-06 15:55:47', 'reason why denied'),
('en', '_template', 'instructor_request_denymsg2', 'Inappropriate subject matter.', '2003-10-06 16:01:26', 'reason why denied'),
('en', '_template', 'instructor_request_denymsg3', 'The course description requires more detail.', '2003-10-07 15:47:33', 'deny instructor request'),
('en', '_template', 'instructor_request_denymsg4', 'You have requested enrollment with the wrong form.', '2003-10-07 15:52:12', 'admin deny instructor request'),
('en', '_template', 'instructor_request_email_notification', 'Instructor Request Email Notification', '2005-03-03 10:51:01', ''),
('en', '_template', 'instructor_request_enterdenymsg', 'Choose a message explaining why the user''s request was denied or enter your own.', '2003-10-06 15:19:05', 'Header text for deny message text area'),
('en', '_template', 'instructor_request_reply', 'Your ATutor instructor request has been approved. Go to %s to login to My Courses, then select "Create Course".', '2005-05-27 13:53:06', 'email in reply to instructor account approval'),
('en', '_template', 'interests', 'Interests', '2009-05-27 12:01:11', ''),
('en', '_template', 'internet_technology', 'Internet Technology', '2009-05-27 12:01:11', ''),
('en', '_template', 'invalid_session', 'Not a Valid Session', '2003-05-20 12:26:29', 'tracker'),
('en', '_template', 'invite', 'Invite', '2009-05-27 12:01:11', ''),
('en', '_template', 'invite_groups', 'Invite New Group Members', '2009-05-27 12:01:11', ''),
('en', '_template', 'in_minutes', 'Minutes', '2007-02-20 10:30:20', ''),
('en', '_template', 'in_reply_to', 'In reply to', '2003-05-20 12:27:21', 'replyto label for quoted forum or inbox message'),
('en', '_template', 'irish-isl', 'Irish-ISL', '2008-09-09 09:01:12', ''),
('en', '_template', 'italian', 'Italian', '2008-09-09 09:01:12', ''),
('en', '_template', 'italian-lis', 'Italian-LIS', '2008-09-09 09:01:12', ''),
('en', '_template', 'italic', 'Italic', '2003-05-20 12:27:44', 'global code picker link text'),
('en', '_template', 'item', 'Item', '2007-01-10 13:46:39', ''),
('en', '_template', 'j', 'J', '2007-01-10 13:48:30', ''),
('en', '_template', 'japanese-jsl', 'Japanese-JSL', '2008-09-09 09:01:12', ''),
('en', '_template', 'join_group', 'Join Group', '2009-06-12 10:06:28', ''),
('en', '_template', 'jump', 'Jump', '2003-05-20 12:28:03', 'jump menu submit button text'),
('en', '_template', 'jump_codes', 'Jump over the code picker', '2003-05-20 12:29:53', 'alt text for bypass link to jump over the code picker'),
('en', '_template', 'jump_redirect', 'Direct Jump', '2004-11-30 10:03:55', 'preferecnes'),
('en', '_template', 'jump_to_admin_tools', 'jump to manage tools', '2014-01-01 14:24:20', ''),
('en', '_template', 'just_social', 'Use just ATutor Social', '2009-07-17 14:11:50', ''),
('en', '_template', 'kb', '<acronym title="Kilobytes">KB</acronym>', '2007-12-09 12:56:24', ''),
('en', '_template', 'keep_email_private', 'Keep email hidden from others.', '2006-03-28 11:29:07', ''),
('en', '_template', 'keep_it_short', 'Tip: Keep it short, no spaces.', '2003-05-20 12:31:53', 'file manager suggestion for folder creation'),
('en', '_template', 'keywords', 'Keywords', '2003-09-28 10:22:10', 'content add/edit'),
('en', '_template', 'language', 'Language', '2003-05-20 12:32:05', 'profile, registration'),
('en', '_template', 'languages', 'Languages', '2005-03-03 11:07:50', ''),
('en', '_template', 'lang_code', 'Language Code', '2006-09-27 14:12:11', ''),
('en', '_template', 'last_accessed', 'Last Accessed', '2005-03-01 12:52:16', 'tracker'),
('en', '_template', 'last_comment', 'Last Comment', '2003-05-20 12:33:10', 'forums, thread view column label'),
('en', '_template', 'last_login', 'Last Login', '2005-03-03 11:03:12', ''),
('en', '_template', 'last_modified', 'Last Modified', '2003-05-20 12:36:35', 'instructor content editor link text'),
('en', '_template', 'last_name', 'Last Name', '2003-05-20 12:37:39', 'registration, profile, admin user manager'),
('en', '_template', 'last_post', 'Last Post', '2004-04-16 11:24:59', 'Refers to date of last post in forum'),
('en', '_template', 'last_updated', 'Last updated: %s', '2006-05-19 14:54:08', ''),
('en', '_template', 'latex_server', 'MimeTex Server for the LaTex service.  For production purposes, please install mimeTeX on your own server. (http://www.atutor.ca/cgi/mimetex.cgi?)', '2010-03-04 08:46:33', ''),
('en', '_template', 'leave_blank', 'Leave blank', '2003-05-20 12:39:07', 'mytest/test manager question option'),
('en', '_template', 'leave_group', 'Leave Group', '2009-05-27 12:01:11', ''),
('en', '_template', 'leave_unchanged', 'Leave unchanged', '2005-05-10 16:04:07', ''),
('en', '_template', 'left', 'Left', '2004-04-27 11:00:35', ''),
('en', '_template', 'left_blank', 'Left blank', '2003-05-20 12:40:14', 'mytests/test manager question result text for unanswerd question'),
('en', '_template', 'left_side', 'left side', '2014-08-23 08:49:37', 'navigation'),
('en', '_template', 'legend', 'Legend', '2003-05-20 12:41:00', 'instructor course statistics/details'),
('en', '_template', 'license', 'License', '2005-08-16 15:27:07', ''),
('en', '_template', 'light_gray', 'Light Gray', '2008-09-09 09:01:13', ''),
('en', '_template', 'limit_to_group', 'Assign To Groups', '2004-12-10 14:39:53', ''),
('en', '_template', 'link', 'Link', '2003-05-20 12:41:18', 'links database'),
('en', '_template', 'links', 'Links', '2005-02-09 13:25:20', ''),
('en', '_template', 'link_alc', 'Link from AContent:', '2012-09-07 10:56:48', 'tile search'),
('en', '_template', 'list_add_course_list', 'Add to Course List', '2004-10-19 14:39:08', 'Enrollment manager, add students manually button'),
('en', '_template', 'list_add_enrolled_list', 'Add to Enrolled List', '2004-10-19 14:51:02', 'enrollment manager, add to enrolled students list button'),
('en', '_template', 'list_add_unenrolled_list', 'Add to Un-enrolled List', '2004-10-19 14:47:31', 'enrollment manager, add to unenrolled students list button'),
('en', '_template', 'list_create_course_list', 'Create Course List', '2004-10-15 12:04:06', 'create list of students function in enrollement manager'),
('en', '_template', 'list_export_course_list', 'Export Course List', '2003-09-16 10:15:29', 'enrol admin'),
('en', '_template', 'list_import_course_list', 'Import Course List', '2003-09-16 09:35:35', 'import course list'),
('en', '_template', 'list_import_howto', 'A course enrollment list may be imported into ATutor. Create the course list in a comma separated values (CSV) format as follows: <code>"firstname", "lastname", "email"</code> with one student per line.  New students will receive their access instructions by email.', '2004-02-05 10:22:29', ''),
('en', '_template', 'lk_agree', 'Agree', '2004-08-12 15:45:53', ''),
('en', '_template', 'lk_always', 'Always', '2004-08-26 12:23:31', ''),
('en', '_template', 'lk_disagree', 'Disagree', '2004-08-12 15:46:29', ''),
('en', '_template', 'lk_excellent', 'Excellent', '2004-08-12 15:42:09', ''),
('en', '_template', 'lk_fair', 'Fair', '2004-08-12 15:43:07', ''),
('en', '_template', 'lk_good', 'Good', '2004-08-12 15:42:50', ''),
('en', '_template', 'lk_important', 'Important', '2004-08-26 12:26:09', ''),
('en', '_template', 'lk_little_importance', 'Of Little Importance', '2004-08-26 12:26:41', ''),
('en', '_template', 'lk_mod_important', 'Moderately Important', '2004-08-26 12:26:23', ''),
('en', '_template', 'lk_never', 'Never', '2004-08-26 12:25:30', ''),
('en', '_template', 'lk_occasionally', 'Occasionally', '2004-08-26 12:24:04', ''),
('en', '_template', 'lk_poor', 'Poor', '2004-08-12 15:43:18', ''),
('en', '_template', 'lk_rarely', 'Rarely', '2004-08-26 12:24:21', ''),
('en', '_template', 'lk_strongly_agree', 'Strongly Agree', '2004-08-12 15:45:38', ''),
('en', '_template', 'lk_strongly_disagree', 'Strongly Disagree', '2004-08-12 15:46:46', ''),
('en', '_template', 'lk_undecided', 'Undecided', '2004-08-26 11:46:00', ''),
('en', '_template', 'lk_unimportant', 'Unimportant', '2004-08-26 12:27:06', ''),
('en', '_template', 'lk_very_frequently', 'Very Frequently', '2004-08-26 12:23:46', ''),
('en', '_template', 'lk_very_good', 'Very Good', '2004-08-12 15:42:33', ''),
('en', '_template', 'lk_very_important', 'Very Important', '2004-08-26 12:25:52', ''),
('en', '_template', 'lk_very_poor', 'Very Poor', '2004-08-12 15:43:37', ''),
('en', '_template', 'lk_very_rarely', 'Very Rarely', '2004-08-26 12:24:38', ''),
('en', '_template', 'loading', 'Loading', '2016-01-02 13:44:33', 'google search'),
('en', '_template', 'locale', 'Locale', '2004-11-20 19:35:20', ''),
('en', '_template', 'local_network', 'Local Network', '2009-05-27 12:01:11', ''),
('en', '_template', 'location', 'Location', '2005-03-04 14:06:25', ''),
('en', '_template', 'lock_no_post', 'No posting, but allow reading.', '2003-05-20 12:46:36', 'forum instructor lock text'),
('en', '_template', 'lock_no_post1', 'This thread is locked from posting.', '2003-05-20 12:46:45', 'forum instructor lock text'),
('en', '_template', 'lock_no_read', 'No posting and no reading.', '2003-05-20 12:46:56', 'context'),
('en', '_template', 'lock_no_read1', 'This thread is locked from reading and posting.', '2003-05-20 12:47:24', 'forum thread display lock message'),
('en', '_template', 'lock_submit', 'Apply Lock', '2003-05-20 12:47:50', 'text for instructor forum lock button'),
('en', '_template', 'lock_thread', 'Lock Topic', '2014-01-02 15:40:37', 'Alt text for forum instructor lock icon'),
('en', '_template', 'logged_in_within', 'logged in within', '2007-02-21 13:37:39', ''),
('en', '_template', 'login', 'Login', '2006-07-27 17:35:30', 'global login label'),
('en', '_template', 'login_into_atutor', 'Log into your ATutor Account', '2003-05-20 12:51:48', 'login after enrollment message'),
('en', '_template', 'login_name', 'Login Name', '2003-05-20 12:52:32', 'control centre account information label'),
('en', '_template', 'login_name_or_email', 'Login Name or Email', '2006-03-28 14:21:34', ''),
('en', '_template', 'login_statistics', '%s login statistics for  %s', '2003-05-31 14:49:29', 'course login details'),
('en', '_template', 'login_text', 'Enter your login name or your email address, and  your password.', '2010-10-07 09:00:45', ''),
('en', '_template', 'logout', 'Log-out', '2003-05-20 12:53:44', 'global logout link text'),
('en', '_template', 'log_file_bundle', 'Log File Bundle', '2005-03-10 16:36:31', 'error logging - email subject'),
('en', '_template', 'ltr', 'Left to Right', '2004-11-20 19:37:04', ''),
('en', '_template', 'magenta', 'Magenta', '2008-09-09 09:01:13', ''),
('en', '_template', 'mail_queue_cron', 'You must set-up the <a href="admin/cron_config.php">cron</a> to use this feature.', '2006-04-03 14:21:30', ''),
('en', '_template', 'main', 'main', '2014-08-23 08:50:37', ''),
('en', '_template', 'maintainers', 'Maintainers', '2005-08-16 15:26:57', ''),
('en', '_template', 'main_navigation', 'Main Navigation', '2005-03-07 12:09:31', ''),
('en', '_template', 'malaysian-msl', 'Malaysian-MSL', '2008-09-09 09:01:12', ''),
('en', '_template', 'male', 'Male', '2003-05-20 12:55:53', 'registration, profile, admin user manager'),
('en', '_template', 'manage', 'Manage', '2005-02-23 12:05:42', ''),
('en', '_template', 'manage_languages', 'Manage Existing Languages', '2004-09-23 16:30:59', ''),
('en', '_template', 'manage_lang_howto', 'Below are all the languages currently available in this installation of ATutor. You may export the language as an ATutor language pack or delete it from the installation.', '2004-10-18 14:23:43', ''),
('en', '_template', 'manage_links', 'Manage Links', '2006-05-24 11:24:51', ''),
('en', '_template', 'manage_navigation_bar', 'Manage tools', '2014-01-01 17:16:47', 'aria-label for subnavmenu_i'),
('en', '_template', 'manage_off', 'Manage off', '2014-01-01 13:00:21', 'instructor admin switch'),
('en', '_template', 'manage_on', 'Manage on', '2014-01-01 12:59:55', 'instructor admin switch'),
('en', '_template', 'manage_tools_off', 'Manage tools turned off', '2014-01-14 18:17:45', ''),
('en', '_template', 'manage_tools_on', 'Manage tools turned on', '2014-01-01 14:30:33', ''),
('en', '_template', 'mark', 'Mark', '2003-05-20 12:56:19', 'mytests/test manager'),
('en', '_template', 'marked_label', 'Marked (%s)', '2005-05-12 10:25:44', ''),
('en', '_template', 'marks', 'marks', '2003-05-20 12:56:34', 'mytests/test manager'),
('en', '_template', 'mark_alumni', 'Mark Alumni', '2004-10-25 12:24:38', ''),
('en', '_template', 'mark_statistics', 'Submission Statistics', '2004-08-26 13:27:13', ''),
('en', '_template', 'master_list_authentication', 'Authenticate Against A Master Student List', '2005-03-31 13:54:01', ''),
('en', '_template', 'master_not_in_list', 'If existing user not in new list', '2005-05-10 16:04:31', ''),
('en', '_template', 'master_student_list', 'Master Student List', '2005-04-04 10:39:26', ''),
('en', '_template', 'material', 'Material', '2004-10-14 14:10:13', ''),
('en', '_template', 'material_announcements', 'Announcements (%s)', '2004-10-14 14:14:23', ''),
('en', '_template', 'material_content_pages', 'Content Pages (%s)', '2004-10-14 14:12:47', ''),
('en', '_template', 'material_files', 'Files (%s)', '2004-10-14 14:22:54', ''),
('en', '_template', 'material_glossary', 'Glossary (%s)', '2004-10-14 14:22:17', ''),
('en', '_template', 'material_groups', 'Groups (%s)', '2004-11-25 15:43:53', ''),
('en', '_template', 'material_links', 'Links (%1$s categories,  %2$s links)', '2004-10-14 14:18:25', ''),
('en', '_template', 'material_polls', 'Polls (%s)', '2004-10-14 14:21:41', ''),
('en', '_template', 'material_select_all', 'Select All', '2004-10-14 14:11:39', ''),
('en', '_template', 'material_stats', 'Statistics (%s days)', '2004-10-14 14:23:22', ''),
('en', '_template', 'maximum', 'Maximum', '2003-05-20 12:59:01', 'instructor course statistics/details'),
('en', '_template', 'maximum_course_float', 'Maximum Course Float', '2005-03-03 10:52:04', ''),
('en', '_template', 'maximum_course_size', 'Maximum Course Size', '2005-03-03 10:51:52', ''),
('en', '_template', 'maximum_file_size', 'Maximum File Size', '2005-03-03 10:51:39', ''),
('en', '_template', 'maximum_login_attempt', 'Maximum Login Attempts', '2009-06-03 15:33:17', ''),
('en', '_template', 'max_backups_reached', 'You have reached the maximum number of backups allowed.', '2004-10-15 14:16:57', ''),
('en', '_template', 'max_file_size', 'Max File Size', '2003-05-20 12:59:52', 'admin course manager properties'),
('en', '_template', 'max_file_size_system', 'Maximum system allows', '2003-10-14 14:32:52', 'php''s max file size'),
('en', '_template', 'mb', '<acronym title="Megabyte">MB</acronym>', '2007-07-26 14:05:45', 'short for MB (megabytes)'),
('en', '_template', 'media', 'Media', '2007-06-15 14:41:08', ''),
('en', '_template', 'megabytes', 'Megabytes', '2014-06-15 14:26:30', ''),
('en', '_template', 'members', 'Members', '2003-05-20 13:00:39', 'instructor course statistics/details'),
('en', '_template', 'member_id', 'Member ID', '2003-05-20 13:01:18', 'admin user manager column heading'),
('en', '_template', 'member_stats', 'Student Specific Usage', '2005-03-03 15:25:57', ''),
('en', '_template', 'menu', 'Menu', '2003-05-20 13:02:17', 'preferences option'),
('en', '_template', 'menu_menu', 'Content Navigation', '2005-03-30 10:13:27', 'context (?)'),
('en', '_template', 'message', 'Message', '2003-05-20 13:06:56', 'inbox send message screen'),
('en', '_template', 'message_board', 'Message Board', '2009-05-27 12:01:11', ''),
('en', '_template', 'message_notification', 'Message Notification', '2005-03-14 15:31:15', 'preferences'),
('en', '_template', 'mexican-lsm', 'Mexican-LSM', '2008-09-09 09:01:12', ''),
('en', '_template', 'mfu_add_more', 'Add More', '2012-06-08 10:04:20', 'file manager'),
('en', '_template', 'mfu_add_to_queue', 'Choose <em>Browse files</em> to add files to the queue.', '2012-06-08 09:59:28', 'file manager'),
('en', '_template', 'mfu_browse_files', 'Browse Files', '2012-06-08 10:03:37', 'file manager'),
('en', '_template', 'mfu_browse_to_add', 'Use the Browse button to add a file, and the Save button to upload it.', '2012-06-08 09:56:26', 'file manager'),
('en', '_template', 'mfu_cancel_uploads', 'Cancel remaining Uploads', '2012-06-08 10:05:12', 'file manager'),
('en', '_template', 'mfu_default_total', 'Total: 0 files (0 KB)', '2012-06-08 10:06:05', 'file manager'),
('en', '_template', 'mfu_error', 'error', '2012-06-08 10:02:50', 'file manager'),
('en', '_template', 'mfu_errors', 'errors', '2012-06-08 10:03:13', 'file manager'),
('en', '_template', 'mfu_error_allowed', 'File upload error: you have uploaded as many files as you are allowed during this session', '2012-06-08 12:11:31', 'file manager'),
('en', '_template', 'mfu_error_failed', 'File upload error: the upload failed for an unknown reason.', '2012-06-08 12:12:01', 'file manager'),
('en', '_template', 'mfu_error_file_empty', 'One or more of the files that you attempted to add contained no data.', '2012-06-08 12:13:30', 'file manager'),
('en', '_template', 'mfu_error_file_type', 'One or more files were not added to the queue because they were of the wrong type.', '2012-06-08 12:13:59', 'file manager'),
('en', '_template', 'mfu_error_msg', ', %1s %2s', '2012-06-08 12:05:23', 'file manager'),
('en', '_template', 'mfu_error_network', 'File upload error: a network error occured.', '2012-06-08 12:11:06', 'file manager'),
('en', '_template', 'mfu_error_queue_limit', 'You have as many files in the queue as can be added at one time. Removing files from the queue may allow you to add different files.', '2012-06-08 12:12:30', 'file manager'),
('en', '_template', 'mfu_error_size_limit', 'One or more of the files that you attempted to add to the queue exceeded the limit of %1s.', '2012-06-08 12:12:58', 'file manager'),
('en', '_template', 'mfu_error_unknown', 'File upload error: a network error occured or the file was rejected (reason unknown).', '2012-06-08 12:10:26', 'file manager'),
('en', '_template', 'mfu_file', 'file', '2012-06-08 10:02:09', 'file manager'),
('en', '_template', 'mfu_filename', 'File Name', '2012-06-08 09:56:54', 'file manager'),
('en', '_template', 'mfu_filename_placeholder', 'File Name Placeholder', '2012-06-08 09:58:25', 'file manager'),
('en', '_template', 'mfu_files', 'files', '2012-06-08 10:02:28', 'file manager'),
('en', '_template', 'mfu_files_not_added', 'x files were too y and were not added to the queue.', '2012-06-08 10:08:03', 'file manager'),
('en', '_template', 'mfu_files_not_added2', 'The following files were not added:', '2012-06-08 10:08:43', 'file manager'),
('en', '_template', 'mfu_file_list_waiting', 'File List:  %1s files uploaded, %2s file waiting to be uploaded.', '2012-06-08 12:05:54', 'file manager'),
('en', '_template', 'mfu_file_uploaded', 'File Uploaded', '2012-06-08 12:07:48', 'file manager'),
('en', '_template', 'mfu_file_upload_error', 'File Upload Error', '2012-06-08 12:08:12', 'file manager'),
('en', '_template', 'mfu_hide_list', 'Hide this list', '2012-06-08 10:09:27', 'file manager'),
('en', '_template', 'mfu_kb', 'KB', '2012-06-08 09:58:49', 'file manager'),
('en', '_template', 'mfu_no_file_list', 'File list: No files waiting to be uploaded.', '2012-06-08 10:07:01', 'file manager'),
('en', '_template', 'mfu_press_delete', 'Press Delete key to remove file', '2012-06-08 12:09:02', 'file manager'),
('en', '_template', 'mfu_remove_error', 'Remove Error', '2012-06-08 10:09:56', 'file manager'),
('en', '_template', 'mfu_resume_uploads', 'Resume Upload', '2012-06-08 10:05:34', 'file manager'),
('en', '_template', 'mfu_size', 'Size', '2012-06-08 09:57:24', 'file manager'),
('en', '_template', 'mfu_stop_upload', 'Stop Upload', '2012-06-08 10:04:44', 'file manager'),
('en', '_template', 'mfu_tolarge_files', '%1s files were too large and were not added to the queue.', '2012-06-08 12:10:00', 'file manager'),
('en', '_template', 'mfu_tomany_files', 'Too many files were selected. %1s were not added to the queue.', '2012-06-08 12:09:32', 'file manager'),
('en', '_template', 'mfu_to_upload', 'To upload: %1s %2s (%3s)', '2012-06-08 12:03:38', 'file manager'),
('en', '_template', 'mfu_upload', 'Upload', '2012-06-08 10:10:23', 'file manager'),
('en', '_template', 'mfu_uploaded', 'Uploaded: %1s of %2s %3s (%4s)%5s', '2012-06-08 12:04:58', 'file manager'),
('en', '_template', 'mfu_uploading', 'Uploading: %1s of %2s %3s (%4s of %5s)', '2012-06-08 12:04:11', 'file manager'),
('en', '_template', 'mfu_upload_limit', '%1s %2s maximum', '2012-06-08 12:03:07', 'file manager'),
('en', '_template', 'mfu_upload_queue', 'File Upload Queue:', '2012-06-08 09:57:57', 'file manager'),
('en', '_template', 'mfu_warnings', 'Warnings:', '2012-06-08 10:06:29', 'file manager'),
('en', '_template', 'minimum', 'Minimum', '2003-05-20 13:08:57', 'instructor course statistics/details'),
('en', '_template', 'minutes', '%s min.', '2006-03-31 15:41:57', ''),
('en', '_template', 'minute_short', 'm', '2007-07-09 12:31:14', ''),
('en', '_template', 'missing', 'Missing', '2005-10-05 14:02:53', ''),
('en', '_template', 'missing_content', 'Missing Content', '2005-03-07 15:25:10', ''),
('en', '_template', 'missing_info', 'Missing Info', '2005-08-17 13:23:48', ''),
('en', '_template', 'mobile', 'Mobile', '2013-12-15 10:31:22', ''),
('en', '_template', 'mobile_active', 'Mobile active', '2014-01-01 12:54:00', ''),
('en', '_template', 'mobile_disabled', 'Mobile disabled', '2014-01-01 12:53:12', ''),
('en', '_template', 'mobile_theme', 'Mobile Theme', '2010-06-18 15:46:42', ''),
('en', '_template', 'mobile_toggle', 'Toggle to switch between mobile and responsive themes', '2014-01-01 12:52:27', ''),
('en', '_template', 'modules', 'Modules', '2005-08-16 13:40:42', ''),
('en', '_template', 'module_install_directory', 'The following directory must be created for this module to install and function: <kbd>%s</kbd>.', '2005-09-22 14:14:34', ''),
('en', '_template', 'module_name', 'Module Name', '2005-08-17 13:11:29', ''),
('en', '_template', 'module_uninstall', 'Uninstall Module', '2008-10-21 15:41:53', ''),
('en', '_template', 'mod_rewrite', 'mod_rewrite', '2008-05-14 12:05:43', ''),
('en', '_template', 'monospaced', 'Monospaced', '2008-09-09 09:01:13', ''),
('en', '_template', 'month', 'Month', '2004-06-24 15:45:43', ''),
('en', '_template', 'more_menu_items', 'More menu items', '2013-12-28 12:30:39', ''),
('en', '_template', 'more_options', 'More options...', '2007-02-21 11:48:54', ''),
('en', '_template', 'move', 'Move', '2004-01-15 13:31:18', 'editing content'),
('en', '_template', 'move_down', 'Move Down', '2005-03-30 15:54:20', 'modules'),
('en', '_template', 'move_thread', 'Move Topic', '2014-01-02 15:40:51', ''),
('en', '_template', 'move_thread_to', 'Move topic to:', '2014-01-02 15:40:59', ''),
('en', '_template', 'move_to_inbox', 'Move to Inbox', '2007-02-22 13:09:26', ''),
('en', '_template', 'move_up', 'Move Up', '2005-08-02 15:44:46', 'modules'),
('en', '_template', 'music', 'Music', '2009-05-27 12:01:11', ''),
('en', '_template', 'mutual_connections', 'Mutual Connections', '2009-06-12 15:42:42', ''),
('en', '_template', 'myown_patches', 'My Own Patches', '2008-04-21 15:08:55', ''),
('en', '_template', 'mysql_version', 'MySQL Version', '2007-07-26 13:40:50', ''),
('en', '_template', 'my_account', 'My Account', '2005-03-28 14:04:37', ''),
('en', '_template', 'my_courses', 'My Courses', '2004-04-15 12:05:31', ''),
('en', '_template', 'my_enrolled_courses', 'My enrolled courses', '2004-08-18 12:03:04', ''),
('en', '_template', 'my_files', 'My Files', '2006-03-20 14:40:42', ''),
('en', '_template', 'my_friends_only', 'Only my contacts', '2009-05-27 12:01:11', ''),
('en', '_template', 'my_groups', 'My Network Groups', '2009-05-27 12:01:11', ''),
('en', '_template', 'my_start_page', 'My Start Page', '2005-02-08 10:58:06', ''),
('en', '_template', 'my_tests', 'My Tests and Surveys', '2010-06-25 14:01:48', ''),
('en', '_template', 'my_tracker', 'My Tracker', '2003-05-20 13:12:27', 'global my tracker  heading'),
('en', '_template', 'na', 'N/A', '2003-05-20 13:12:48', 'short form for "not applicable"'),
('en', '_template', 'name', 'Name', '2003-05-20 13:31:04', 'file manager, zip utility column heading'),
('en', '_template', 'name_in_english', 'Language name in English', '2004-11-20 19:41:16', 'admin add language'),
('en', '_template', 'name_in_language', 'Language name translated', '2004-11-20 19:39:49', ''),
('en', '_template', 'native-american', 'Native-American', '2008-09-09 09:01:12', ''),
('en', '_template', 'navigation', 'Navigation', '2008-09-09 09:03:56', ''),
('en', '_template', 'nav_path', 'Navigation Path for User', '2003-05-20 13:31:22', 'tracker'),
('en', '_template', 'nav_tendencies', 'Navigation Tendencies for User', '2003-05-20 13:32:03', 'tracker'),
('en', '_template', 'netherlands-ngt', 'Netherlands-NGT', '2008-09-09 09:01:13', ''),
('en', '_template', 'network_home', 'My Network', '2009-05-27 12:01:11', ''),
('en', '_template', 'network_updates', 'Network Activity', '2009-05-27 12:01:11', ''),
('en', '_template', 'never', 'Never', '2005-03-03 11:03:01', ''),
('en', '_template', 'new', 'New!', '2003-05-20 13:32:52', 'forum/inbox new message indicator'),
('en', '_template', 'new_account_enroll', 'A user account has been created for you at %1s and you have been enrolled into the course %2s. To access this course, please log into the site. It is strongly suggested you change your password upon logging in.', '2005-06-24 15:33:45', 'Message emailed to new users as a result of enrollment.'),
('en', '_template', 'new_account_enroll_confirm', 'You have been enrolled into the course %1s. To access this course, you must first confirm your account by using the following link: %2s. It is strongly suggested you change your password upon logging in.', '2005-06-24 15:33:17', 'If new user created during enrollment and needs confirmation.'),
('en', '_template', 'new_file', 'New File', '2006-03-20 14:36:14', ''),
('en', '_template', 'new_group_invitations', 'New Group Invitations', '2009-05-27 12:01:11', ''),
('en', '_template', 'new_group_requests', 'Join Group Requests', '2013-10-19 18:42:08', '');

INSERT INTO `[[dbprefix]]language_text` VALUES
('en', '_template', 'rl_type_of_resource', 'Type of Resource', '2006-07-14 10:24:21', ''),
('en', '_template', 'rl_url', 'URL', '2007-08-02 10:46:30', 'resource type picker'),
('en', '_template', 'rl_view_resource_details', 'View Resource Details', '2008-06-10 14:23:50', 'reading list.'),
('en', '_template', 'rl_year_written', 'Year Written', '2006-06-21 08:55:34', ''),
('en', '_template', 'role', 'Role', '2004-03-05 12:26:47', ''),
('en', '_template', 'rss_feeds', 'News Feeds', '2010-05-03 15:01:37', ''),
('en', '_template', 'rtl', 'Right to Left', '2004-11-20 19:37:58', ''),
('en', '_template', 'russian-rsl', 'Russian-RSL', '2008-09-09 09:01:13', ''),
('en', '_template', 'same_course_users', 'Only users in the same courses as you are listed.', '2003-05-21 19:05:32', 'inbox send message form'),
('en', '_template', 'sans_serif', 'Sans Serif', '2008-09-09 09:01:13', ''),
('en', '_template', 'save', 'Save', '2004-10-29 14:57:46', 'file manager'),
('en', '_template', 'save_changes', 'Save Changes', '2004-05-11 10:48:01', ''),
('en', '_template', 'save_changes_saved', 'All changes have been saved.', '2004-02-16 14:06:16', ''),
('en', '_template', 'save_changes_unsaved', 'Unsaved changes have been made.', '2004-02-16 14:04:25', ''),
('en', '_template', 'save_types_and_language', 'Update Resource Properties', '2008-10-19 13:51:37', ''),
('en', '_template', 'scaffold_text', 'Modify the URLs for the learning tools below. Leave blank to disable.', '2008-09-10 12:29:26', 'tool preferences'),
('en', '_template', 'scale', 'Scale', '2008-09-25 15:59:56', 'gradebook'),
('en', '_template', 'scale_value', 'Scale Value', '2008-09-25 15:59:56', 'gradebook'),
('en', '_template', 'schema_error', 'Wrong schema location', '2009-12-07 13:09:06', 'common cartridge'),
('en', '_template', 'search', 'Search', '2003-05-21 19:19:30', 'links database'),
('en', '_template', 'search_all_words', 'All words', '2003-08-11 11:22:04', ''),
('en', '_template', 'search_any_word', 'Any word', '2003-08-11 11:22:14', ''),
('en', '_template', 'search_connections', 'Search Connections', '2009-05-27 12:01:11', ''),
('en', '_template', 'search_control', 'Search Control', '2009-11-06 15:53:36', 'networking settings'),
('en', '_template', 'search_education', 'Search Education', '2009-05-27 12:01:11', ''),
('en', '_template', 'search_for_friends', 'Search People', '2009-05-27 12:01:11', ''),
('en', '_template', 'search_for_groups', 'Search for Groups', '2009-05-27 12:01:11', ''),
('en', '_template', 'search_in', 'Search in', '2004-04-30 10:51:57', ''),
('en', '_template', 'search_match', 'Match', '2003-08-11 11:21:50', ''),
('en', '_template', 'search_position', 'Search Position', '2009-05-27 12:01:11', ''),
('en', '_template', 'search_profile', 'Search Profile', '2009-05-27 12:01:11', ''),
('en', '_template', 'search_results', 'Search Results', '2003-05-21 19:21:29', 'links database'),
('en', '_template', 'search_site', 'Only search within <strong>%s</strong>.', '2005-10-20 10:53:28', ''),
('en', '_template', 'search_visibility', 'Search Visibility', '2009-05-27 12:01:11', ''),
('en', '_template', 'search_words', 'Words', '2003-08-11 11:21:36', ''),
('en', '_template', 'secondary_resource_body', 'Body', '2008-09-23 13:50:56', ''),
('en', '_template', 'secondary_resource_language', 'Adapted Resource Language', '2008-10-19 17:05:56', ''),
('en', '_template', 'secondary_resource_type', 'Adapted Resource Type', '2008-10-19 17:06:06', ''),
('en', '_template', 'seconds', 'Seconds', '2010-05-10 15:56:57', ''),
('en', '_template', 'second_name', 'Second Name', '2006-03-27 14:53:50', ''),
('en', '_template', 'second_short', 's', '2007-07-09 12:31:07', ''),
('en', '_template', 'section', 'Section', '2005-03-04 14:06:06', ''),
('en', '_template', 'see', 'See', '2003-05-21 19:24:22', 'glossary - "see" related terms'),
('en', '_template', 'see_attached', 'See attached.', '2005-03-10 16:37:04', 'error logging - email body'),
('en', '_template', 'select', 'Select', '2007-02-21 13:22:15', ''),
('en', '_template', 'select_all', 'select/unselect all', '2004-10-29 13:25:57', 'file manager and enrollment manager'),
('en', '_template', 'select_av', 'Select Audio/Visual', '2006-07-25 09:14:57', ''),
('en', '_template', 'select_cat', 'Select Category', '2005-02-23 12:23:56', ''),
('en', '_template', 'select_directory', 'Please choose the folder you want to move the selected files to:', '2004-11-30 11:40:08', 'Filamanger, moving a file'),
('en', '_template', 'select_member', 'Select a Member to View', '2003-05-21 19:29:27', 'instructor course tracker'),
('en', '_template', 'select_parent_topic', 'Select parent topic', '2005-03-16 13:37:00', 'content manager'),
('en', '_template', 'select_term_to_edit', 'Select term to edit.', '2006-09-25 13:08:38', ''),
('en', '_template', 'send', 'Send', '2003-05-21 19:31:57', 'global message send button text'),
('en', '_template', 'send_bundle', 'Send Bundle', '2004-12-06 12:16:19', ''),
('en', '_template', 'send_confirmation', 'Enter your email address below and the account confirmation message will be resent.', '2005-03-24 09:57:32', ''),
('en', '_template', 'send_delete', 'Send & Delete', '2003-05-21 19:32:55', 'send a message from the inbox and delete the original'),
('en', '_template', 'send_message', 'Send Message', '2003-05-21 19:34:13', 'inbox send message button text'),
('en', '_template', 'sent_messages', 'Sent Messages', '2007-02-20 16:21:09', ''),
('en', '_template', 'sent_msgs_ttl_text', 'Number of Days to Keep Copied Sent Messages for', '2007-02-20 14:00:45', ''),
('en', '_template', 'sent_via_atutor', 'Sent via an ATutor system at %s', '2003-05-21 20:04:50', 'global email message footer'),
('en', '_template', 'sequence', 'Sequence', '2003-05-21 20:05:50', 'context (removed 1.2)'),
('en', '_template', 'serif', 'Serif', '2008-09-09 09:01:13', ''),
('en', '_template', 'server_date_format', '%%Y-%%m-%%d %%G:%%i:%%s', '2008-10-01 15:02:49', 'date format'),
('en', '_template', 'session_end', 'and ended on', '2003-05-21 20:12:12', 'tracker - to be updated ( started on [date] and ended on [date])'),
('en', '_template', 'session_start', 'Session above started on', '2003-05-21 20:11:35', 'tracker (to be updated)'),
('en', '_template', 'session_timeout', 'Session Timeout Period', '2013-01-31 11:49:21', ''),
('en', '_template', 'session_timeout_logout_now', 'Logout Now', '2012-06-07 14:32:20', 'timeout dialog'),
('en', '_template', 'session_timeout_stay_connected', 'Stay Connected', '2012-06-07 14:32:41', ''),
('en', '_template', 'session_timeout_title', 'Session Timeout', '2012-06-07 14:31:51', 'timeout dialog'),
('en', '_template', 'session_will_expire', 'Your session is about to expire.', '2012-06-07 11:00:24', 'timeout warning'),
('en', '_template', 'set', 'Set', '2003-06-30 17:02:05', 'admin language manager'),
('en', '_template', 'settings', 'Settings', '2009-05-27 12:01:11', ''),
('en', '_template', 'set_all_weights', 'Set a point value for all the questions on this test.  After you are done, click "save".', '2010-06-16 11:22:11', 'test questions'),
('en', '_template', 'set_default', 'Set as Default', '2004-10-15 15:48:04', 'set as default button in theme manager'),
('en', '_template', 'set_preset', 'Apply Preset', '2003-05-24 10:52:43', 'preferences'),
('en', '_template', 'shared_forums', 'Shared Forums', '2004-11-03 11:18:31', ''),
('en', '_template', 'shindig_blurb', 'If you have your own Shindig server setup, your can enter the URL to the server here. If you do not have your own Shindig server, you can either leave the URL empty, or you can use "http://social.atutor.ca/shindig/php" to connect to the ATutor social network. Shindig allows users to link gadgets from other sites into their social networking environment, as well as communicate with those in other social networks. If you choose not to use a Shindig server, your social network will function as a self-contained network, without access to external networks.', '2010-12-14 16:15:48', ''),
('en', '_template', 'shindig_url', 'URL of Optional ShinDig server.', '2009-05-27 12:01:11', ''),
('en', '_template', 'shortcuts', 'Shortcuts', '2004-04-27 14:57:01', ''),
('en', '_template', 'short_paragraph', 'Short Paragraph', '2003-05-21 20:13:03', 'test manager test type'),
('en', '_template', 'show', 'Show', '2005-03-15 11:37:59', ''),
('en', '_template', 'show_all', 'show all', '2009-05-27 12:01:11', ''),
('en', '_template', 'show_all_remedial', 'Show All Remedial Content', '2013-01-23 14:19:21', ''),
('en', '_template', 'show_available_applications', 'Show Available Gadgets', '2009-05-27 12:01:11', ''),
('en', '_template', 'show_bread_crumbs', 'Show Breadcrumb Link Navigation', '2008-09-24 13:05:06', ''),
('en', '_template', 'show_contents', 'Show page Table of Contents', '2010-10-07 10:42:22', ''),
('en', '_template', 'show_current', 'Display Current Activities on My Start Page', '2015-12-29 17:40:12', ''),
('en', '_template', 'show_guest_form', 'Show Guest Information Collection Form', '2008-10-09 14:13:38', ''),
('en', '_template', 'show_guide', 'Show Context Sensitive Links to Handbook', '2008-09-24 12:09:33', ''),
('en', '_template', 'show_next_previous_buttons', 'Show Next/Previous Navigation Buttons', '2008-09-24 13:04:28', ''),
('en', '_template', 'show_numbers', 'Topic Numbering', '2005-02-09 10:20:54', 'preference option'),
('en', '_template', 'show_on_home_page', 'Show on Home Page', '2009-05-27 12:01:11', ''),
('en', '_template', 'show_pages', 'Show Pages', '2010-04-21 16:28:13', 'thing current'),
('en', '_template', 'show_raw_tracking', 'Show raw tracking', '2003-11-26 15:19:12', ''),
('en', '_template', 'show_side_menu', 'Show Side Menu', '2014-07-08 18:55:21', 'side menu toogle'),
('en', '_template', 'show_summary_tracking', 'Show summary tracking', '2003-11-26 15:18:39', ''),
('en', '_template', 'show_your_applications', 'Show Your Gadgets', '2009-05-27 12:01:11', ''),
('en', '_template', 'side_menu', 'Side Menu', '2005-03-04 14:37:00', ''),
('en', '_template', 'side_menu_closed', 'Side menu closed.', '2014-01-01 18:16:50', 'sidemenu toggle aria-live message'),
('en', '_template', 'side_menu_opened', 'Side menu opened', '2014-01-01 18:16:10', 'sidemenu toggle aria-live message'),
('en', '_template', 'side_menu_text', 'Choose which menu items you would like displayed at the side.', '2005-03-04 15:17:16', ''),
('en', '_template', 'sign_lang', 'Sign Language', '2008-09-09 08:56:34', ''),
('en', '_template', 'sign_language', 'Sign language', '2008-09-08 14:19:39', ''),
('en', '_template', 'singapore-sls', 'Singapore-SLS', '2008-09-09 09:01:13', ''),
('en', '_template', 'sitemap', 'Site-map', '2003-05-21 20:17:21', 'global site-map text'),
('en', '_template', 'sitemap_text', 'Browse through the whole course site from one location.', '2009-07-02 14:15:24', ''),
('en', '_template', 'site_name', 'Site Name', '2005-03-03 10:49:59', ''),
('en', '_template', 'size', 'Size', '2003-05-22 13:01:20', 'file manager, zip tool'),
('en', '_template', 'smile_angry', 'angry', '2004-02-12 12:20:44', ''),
('en', '_template', 'smile_confused', 'confused', '2004-02-12 12:21:15', ''),
('en', '_template', 'smile_crazy', 'crazy', '2004-02-12 12:20:59', ''),
('en', '_template', 'smile_evil', 'evil', '2004-02-12 12:20:37', ''),
('en', '_template', 'smile_frown', 'frown', '2004-02-12 12:20:14', ''),
('en', '_template', 'smile_lol', 'laughing out loud', '2004-02-12 12:20:53', ''),
('en', '_template', 'smile_muah', 'muah', '2004-02-12 12:21:23', ''),
('en', '_template', 'smile_oh_well', 'oh well', '2004-02-12 12:20:21', ''),
('en', '_template', 'smile_smile', 'smile', '2004-02-12 12:20:02', ''),
('en', '_template', 'smile_tired', 'tired', '2004-02-12 12:21:06', ''),
('en', '_template', 'smile_tongue', 'tongue', '2004-02-12 12:20:27', ''),
('en', '_template', 'smile_wink', 'wink', '2004-02-12 12:20:08', ''),
('en', '_template', 'social', 'Networking', '2009-05-27 12:01:11', ''),
('en', '_template', 'social_and_lms', 'Use ATutor LMS with ATutor Social module', '2009-07-17 14:12:34', ''),
('en', '_template', 'social_groups', 'Network Groups', '2009-05-27 12:01:11', ''),
('en', '_template', 'social_profile', 'Network Profile', '2009-05-27 12:01:11', ''),
('en', '_template', 'social_switch', 'Social Networking', '2009-07-17 14:11:16', ''),
('en', '_template', 'social_switch_text', 'Choose to use ATutor as a social networking environment only, or as a learning management system with a social networking module.', '2009-07-17 14:19:22', ''),
('en', '_template', 'spanish', 'Spanish', '2008-09-09 09:01:12', ''),
('en', '_template', 'spanish-lse', 'Spanish-LSE', '2008-09-09 09:01:13', ''),
('en', '_template', 'specific_groups', 'Specific Groups', '2006-03-23 13:39:26', ''),
('en', '_template', 'specify_url_to_content_package', 'Or, Specify a URL to a Content Package or Common Cartridge', '2009-11-16 10:57:14', ''),
('en', '_template', 'specify_url_to_theme_package', 'Or, Specify a URL to a Theme', '2004-10-18 15:10:35', ''),
('en', '_template', 'sports_recreation', 'Sports and Recreation', '2009-05-27 12:01:11', ''),
('en', '_template', 'sql_statement', 'SQL Statement', '2008-04-21 15:11:31', ''),
('en', '_template', 'standard', 'Standard', '2005-09-21 13:35:25', ''),
('en', '_template', 'started_by', 'Started By', '2003-05-22 13:02:38', 'forums thread display table column header'),
('en', '_template', 'startend_date_format', '%%j/%%n/%%y %%G:%%i', '2007-12-09 15:58:39', ''),
('en', '_template', 'startend_date_longs_format', '%%Y-%%m-%%d %%H:%%i', '2008-08-27 11:23:57', ''),
('en', '_template', 'startend_date_long_format', '%%Y-%%m-%%d %%H:%%i', '2008-08-27 11:24:04', ''),
('en', '_template', 'start_date', 'Start Date', '2003-05-22 13:03:05', 'mytests, test manager'),
('en', '_template', 'start_test', 'Begin', '2009-11-13 16:18:58', 'test intro'),
('en', '_template', 'state', 'State', '2005-08-16 15:27:15', ''),
('en', '_template', 'statement', 'Statement', '2003-05-22 13:07:22', 'test manager add/edit questions'),
('en', '_template', 'statistics', 'Statistics', '2003-05-22 13:08:06', 'instructor course statistics/details'),
('en', '_template', 'statistics_information', 'Statistics &amp; Information', '2007-07-26 13:39:49', ''),
('en', '_template', 'status', 'Status', '2003-05-22 13:09:29', 'test manager, control center, profile, admin user manager'),
('en', '_template', 'sticky_thread', 'Sticky Topic - always at the top', '2014-01-02 15:41:44', 'instructor forum option alt text'),
('en', '_template', 'stop_apply_audio_alternatives', 'Stop Applying Audio Alternatives', '2010-04-21 14:35:40', 'alternative switcher'),
('en', '_template', 'stop_apply_sign_lang_alternatives', 'Stop Applying Sign Language Alternatives', '2010-04-21 14:36:15', 'alternative switcher'),
('en', '_template', 'stop_apply_text_alternatives', 'Stop Applying Text Alternatives', '2010-04-21 14:35:20', 'alternative switcher'),
('en', '_template', 'stop_apply_visual_alternatives', 'Stop Applying Visual Alternatives', '2010-04-21 14:35:57', 'alternative switcher'),
('en', '_template', 'street_address', 'Street Address', '2003-05-22 13:10:43', 'registration, profile'),
('en', '_template', 'student', 'Student', '2003-10-27 11:44:47', 'tracker'),
('en', '_template', 'student1', 'Student', '2003-05-22 13:11:42', 'admin user manager'),
('en', '_template', 'students', 'Students', '2003-05-21 20:01:44', 'course email (removed 1.2)'),
('en', '_template', 'student_id', 'Student ID', '2003-05-22 13:12:40', 'tracker'),
('en', '_template', 'student_not_exists', 'Student not exists', '2008-09-25 16:01:17', 'gradebook'),
('en', '_template', 'student_page_stats', 'Student usage statistics by login name', '2013-11-17 11:11:06', ''),
('en', '_template', 'student_pin', 'Student PIN', '2005-05-27 13:35:11', ''),
('en', '_template', 'student_tools', 'Student Tools', '2008-11-07 09:17:23', ''),
('en', '_template', 'student_tools_text', 'Access the tools used in this course.', '2009-07-02 14:16:37', ''),
('en', '_template', 'style_editor', 'Stylesheet Editor', '2003-05-22 13:13:22', 'tool page/ stylesheet editor heading text'),
('en', '_template', 'sub', 'sub', '2014-08-23 08:54:56', 'sub navigation'),
('en', '_template', 'subject', 'Subject', '2003-05-22 13:14:21', 'global message subject label'),
('en', '_template', 'submission', 'Submission', '2005-05-11 11:29:07', ''),
('en', '_template', 'submissions', 'Submissions', '2003-05-22 13:14:47', 'links database'),
('en', '_template', 'submit', 'Submit', '2003-05-22 13:15:05', 'global submit button text'),
('en', '_template', 'submitted_by', 'Submitted By', '2005-02-23 12:23:06', ''),
('en', '_template', 'submit_no', 'No', '2004-11-22 16:23:09', ''),
('en', '_template', 'submit_yes', 'Yes', '2004-11-22 16:23:00', ''),
('en', '_template', 'subscribe', 'Subscribe to this thread to receive notification via email of new replies.', '2003-11-06 13:47:10', ''),
('en', '_template', 'subscribe1', 'Subscribe', '2004-12-02 15:32:01', ''),
('en', '_template', 'sub_nav_closed', 'Sub navigation closed', '2014-04-27 15:36:04', ''),
('en', '_template', 'sub_nav_hidden', 'Sub navigation hidden', '2014-04-27 15:35:42', 'aria message when subnav closes'),
('en', '_template', 'sub_nav_opened', 'Sub navigation bar opened', '2014-06-15 14:25:51', ''),
('en', '_template', 'sub_topics', 'Subtopics', '2005-03-16 13:55:12', 'content manager'),
('en', '_template', 'suggestions', 'Suggestions', '2009-05-27 12:01:11', ''),
('en', '_template', 'suggest_link', 'Suggest Course Link', '2006-05-25 11:40:32', ''),
('en', '_template', 'summary', 'Summary', '2003-09-13 09:24:55', 'course tracker member picker'),
('en', '_template', 'support_tools', 'Learner Tools', '2010-05-03 14:59:19', ''),
('en', '_template', 'swedish', 'Swedish', '2008-09-09 09:01:13', ''),
('en', '_template', 'switch_icon_view', 'Switch between icon and detailed views', '2014-01-01 14:43:41', ''),
('en', '_template', 'switch_text', 'Switch to text editor', '2004-05-27 10:50:47', 'Content editor'),
('en', '_template', 'switch_visual', 'Switch to visual editor', '2004-05-27 10:52:19', 'Used in content editor'),
('en', '_template', 'syndicate_announcements', 'Syndicate Announcements', '2005-01-04 09:46:15', ''),
('en', '_template', 'system_preferences', 'System Preferences', '2005-03-03 10:49:44', ''),
('en', '_template', 'table_of_contents', 'Page Contents', '2010-10-07 10:42:38', 'preferences'),
('en', '_template', 'take_test', 'Take Test', '2003-05-22 13:54:16', 'MyTests'),
('en', '_template', 'tamil', 'Tamil', '2008-09-09 09:01:12', ''),
('en', '_template', 'tech_support_forum', 'Developer Support', '2018-04-11 18:33:30', 'help'),
('en', '_template', 'tech_support_forum_text', 'Report bugs and development activity through <a href="https://github.com/atutor/ATutor/issues">GitHub Issues</a>.', '2018-04-11 18:36:06', 'help'),
('en', '_template', 'template', 'Template', '2006-09-25 13:07:42', ''),
('en', '_template', 'tests', 'Tests and Surveys', '2010-06-25 14:02:12', ''),
('en', '_template', 'test_anonymous', 'This test/survey is anonymous.', '2004-09-02 13:42:31', ''),
('en', '_template', 'test_confirm_submit', 'You are about to submit the test/survey.  Please note that changes are not allowed once the test/survey is submitted, do you want to proceed?', '2010-05-07 10:53:46', 'test questions'),
('en', '_template', 'test_description', 'Test Description', '2008-03-10 11:50:11', 'Test/Survey Property'),
('en', '_template', 'test_import_package', 'Import available tests.', '2008-10-21 11:43:37', ''),
('en', '_template', 'test_lk', 'Likert', '2004-08-12 15:55:22', ''),
('en', '_template', 'test_ma', 'Multiple Answer', '2007-02-01 15:49:57', ''),
('en', '_template', 'test_matching', 'Matching (Simple)', '2007-02-01 16:20:41', ''),
('en', '_template', 'test_matchingdd', 'Matching (Graphical)', '2007-02-01 16:20:28', ''),
('en', '_template', 'test_mc', 'Multiple Choice', '2003-05-22 14:03:29', 'test manager question type'),
('en', '_template', 'test_open', 'Open Ended', '2003-05-22 14:03:45', 'test manager question type'),
('en', '_template', 'test_ordering', 'Ordering', '2007-01-10 13:45:26', ''),
('en', '_template', 'test_tf', 'True or False', '2003-05-22 14:09:05', 'test manager question type'),
('en', '_template', 'text', 'Text', '2004-04-20 16:40:07', ''),
('en', '_template', 'textual', 'Textual', '2008-09-08 14:19:22', ''),
('en', '_template', 'theme', 'Theme', '2004-04-23 15:26:57', ''),
('en', '_template', 'themes', 'Themes', '2003-05-22 14:10:24', 'preferences'),
('en', '_template', 'themes_disabled', 'The personal theme preference has been disabled in favour of theme specific categories.', '2004-08-04 11:58:33', ''),
('en', '_template', 'themes_for_desktop', 'Themes for desktop computers', '2010-06-18 15:45:59', ''),
('en', '_template', 'themes_for_mobile', 'Themes for mobile devices', '2010-06-18 15:46:14', ''),
('en', '_template', 'theme_screenshot', 'Screenshot', '2005-05-06 14:18:00', 'theme manager, screentshot alt/title'),
('en', '_template', 'theme_specific_categories', 'Theme Specific Categories', '2005-03-31 13:49:53', ''),
('en', '_template', 'there_are_entries', 'There are %s entries.', '2009-05-27 12:01:11', ''),
('en', '_template', 'thesaurus', 'Thesaurus', '2008-09-09 09:03:56', ''),
('en', '_template', 'the_follow_errors_occurred', 'The following errors occurred:', '2005-03-07 12:41:09', ''),
('en', '_template', 'things_current', 'Current Activity', '2013-11-17 15:09:50', 'my start page'),
('en', '_template', 'this_course_only', 'This course only', '2004-08-18 12:02:37', ''),
('en', '_template', 'this_is_content', 'This is a blank content page. Use Edit this Page in the Content Editor links above to modify this page. As the instructor of this course, you can manage it through the Manage tab above.', '2010-10-19 10:16:29', 'default content insert when a new course is created'),
('en', '_template', 'thread', 'Topic', '2014-01-02 15:41:57', 'forums subscription email'),
('en', '_template', 'thread_already_subscribed', 'You are already subscribed to this topic.', '2014-01-02 15:42:05', 'forum view thread subscribe feedback'),
('en', '_template', 'thread_locked', 'Topic Locked', '2014-01-02 15:42:19', 'forum thread view thread lock message'),
('en', '_template', 'thread_notify1', 'Topic Subscription', '2014-01-02 15:42:31', 'Thread email notify subject'),
('en', '_template', 'thread_subscribe', 'Subscribe to this topic to receive notification via email of replies.', '2014-01-02 15:42:41', 'forum thread subscribe description'),
('en', '_template', 'tile_any_field', 'Any Field', '2004-05-03 13:14:02', ''),
('en', '_template', 'tile_author', 'Author', '2004-05-03 13:14:17', ''),
('en', '_template', 'tile_export', 'Export content to the AContent repository. A valid AContent account is required.', '2010-06-09 15:20:40', ''),
('en', '_template', 'tile_howto', 'Enter keywords to search AContent repository.', '2010-06-09 15:21:01', 'tile search'),
('en', '_template', 'tile_import_content_package_about', 'Import the content directly into this course.', '2004-05-03 13:15:54', ''),
('en', '_template', 'tile_keyword', 'Keyword', '2004-05-03 13:14:23', ''),
('en', '_template', 'tile_not_accessible', 'AContent repository is not accessible.', '2010-06-09 15:21:48', 'tile search'),
('en', '_template', 'tile_no_response', 'No response from AContent. It might because the course is too big to be auto-imported into AContent, or unknown problems occurred. Please download the ATutor package and manually import into AContent.', '2010-07-12 11:48:07', ''),
('en', '_template', 'tile_progress', 'AContent Importing in Progress...', '2010-06-09 15:22:31', ''),
('en', '_template', 'tile_search', 'AContent', '2010-06-09 15:22:46', ''),
('en', '_template', 'tile_search_text', 'Search the content repository for additional learning materials. Use reserved keyword "OR" (must be capital) in between searching words for searching either one of several words.', '2010-05-05 16:13:20', ''),
('en', '_template', 'tile_setup', 'AContent Setup', '2010-06-09 15:17:05', ''),
('en', '_template', 'tile_setup_txt', 'Enter the location of the AContent repository (http://www.acontent.com) and the AContent web service ID. An AContent web service ID can be obtained by registering on an AContent system. Or, if already registered, it can be accessed from the AContent "Profile" page.', '2010-06-09 15:19:49', ''),
('en', '_template', 'tile_technical_format', 'Technical Format', '2004-05-03 13:14:51', ''),
('en', '_template', 'timeout_minutes', 'minutes', '2013-01-31 11:48:32', 'system preferecnes'),
('en', '_template', 'times', 'Times', '2009-10-26 15:03:31', ''),
('en', '_template', 'timestamp', 'Timestamp', '2004-12-06 12:04:30', ''),
('en', '_template', 'time_spent', 'Time Spent', '2007-07-09 12:32:33', ''),
('en', '_template', 'time_zone', 'Time Zone (date below should match your local time)', '2010-03-03 16:32:12', 'appears on the config page'),
('en', '_template', 'time_zones_not_supported', 'Your server is not set-up to support time zones. See the Handbook for more details.', '2006-11-01 13:06:40', ''),
('en', '_template', 'title', 'Title', '2003-05-22 14:43:54', 'admin course manager column heading'),
('en', '_template', 'to', 'To', '2003-05-22 14:45:14', 'inbox send message "to" a user'),
('en', '_template', 'to1', 'to', '2003-05-22 14:48:13', 'login form header row login -to- some place'),
('en', '_template', 'toggle_disabled', 'Toggle Disabled', '2003-05-22 15:10:01', 'alt text for menu toggle'),
('en', '_template', 'toggle_main', 'Toggle to open and close main navigation', '2014-08-23 08:48:08', ''),
('en', '_template', 'tools', 'Tools', '2006-03-22 12:52:10', ''),
('en', '_template', 'tools_details', 'Details for Tool Usage', '2003-05-22 15:11:15', 'tracker'),
('en', '_template', 'tools_manager', 'Add Activity', '2009-10-22 16:17:01', 'content editor'),
('en', '_template', 'tool_manager', 'Tool/Activity Manager', '2009-11-19 16:12:28', 'core modules'),
('en', '_template', 'tool_man_comment', 'Choose from the tools available in the course, to add activities to this content.', '2009-11-05 12:29:40', 'content tool manager'),
('en', '_template', 'tool_settings', 'Learner Supports', '2010-04-12 16:29:59', ''),
('en', '_template', 'tool_summary', 'Tools Usage Summary', '2003-05-22 15:11:26', 'tracker'),
('en', '_template', 'top', 'Top', '2003-05-22 15:11:53', 'global alt text for jump to top link/icon'),
('en', '_template', 'topic', 'Topic', '2003-05-22 15:12:45', 'forum thread list column heading'),
('en', '_template', 'topics_in', 'Topics in', '2016-03-06 08:52:42', 'mobile login'),
('en', '_template', 'top_20', 'Only the top 20 results have been displayed.', '2005-10-20 10:50:41', ''),
('en', '_template', 'top_level', 'Top Level', '2005-03-16 13:36:35', 'content manager'),
('en', '_template', 'total', 'Total', '2003-05-22 15:14:13', 'instructor course statistic/details, test manager'),
('en', '_template', 'total_votes', 'Total Votes', '2005-03-11 15:51:33', ''),
('en', '_template', 'to_2', 'to', '2003-05-22 15:15:16', 'test manager date'),
('en', '_template', 'to_email', 'To Email', '2003-05-22 15:17:02', 'help admin/instructor contact forms'),
('en', '_template', 'to_name', 'To Name', '2003-05-22 15:17:20', 'help admin/instructor contact forms'),
('en', '_template', 'tracker', 'Content Tracker', '2005-11-25 18:36:21', ''),
('en', '_template', 'tracker_none_viewed', 'No content pages have been viewed in this course yet.', '2003-09-15 11:53:06', 'mytracker summary view'),
('en', '_template', 'tracker_not_viewed', 'Jump to pages not yet viewed.', '2003-09-13 12:16:10', 'mytracker bypass to not viewed alt text'),
('en', '_template', 'tracker_pages_total', 'Total pages in this course %s (pages visited: %s.)', '2003-09-13 09:11:43', 'tracker summary pages read'),
('en', '_template', 'tracker_percent_read', 'Percentage of pages viewed %s.', '2003-09-13 12:09:57', 'tracker pages read'),
('en', '_template', 'tracker_summary_read', 'Summary of pages viewed by user %s.', '2003-09-13 12:30:44', 'tracker summary read'),
('en', '_template', 'tracking', 'Tracking', '2003-05-22 15:18:11', 'admin course manager '),
('en', '_template', 'tracking_all_page_viewed', 'All pages in this course have been viewed.', '2003-09-13 12:37:23', 'mytracker page not viewed'),
('en', '_template', 'training_and_education', 'Training and Education', '2009-05-27 12:01:11', ''),
('en', '_template', 'transformable_uri', 'AContent URL', '2010-06-09 15:32:25', ''),
('en', '_template', 'translate', 'Translate', '2004-12-07 13:59:44', 'language manager translate button'),
('en', '_template', 'translate_lang_howto', 'In order to translate a language you must : <br />\r\n1. Set the AT_DEVEL_TRANSLATE constant in /include/vitals.inc.php to ''1'' <br />\r\n2. Make sure that you have added the new language to the database<br />\r\n3. Select  the new language as the one you want to translate from the ''translate to:'' option at the bottom of the page<br />\r\n4. Use the translate button and translate the new language in a new window<br />', '2004-12-10 16:29:48', 'Language Manager, translation message'),
('en', '_template', 'translate_to', 'Translate to:', '2003-05-22 15:19:14', 'footer'),
('en', '_template', 'true', 'True', '2003-05-22 15:19:50', 'test manager question answer option'),
('en', '_template', 'type', 'Type', '2003-05-22 15:20:30', 'test manager questions column heading'),
('en', '_template', 'unchecked', 'Un-checked', '2006-06-26 14:56:06', ''),
('en', '_template', 'unconfirmed', 'Unconfirmed', '2005-04-01 10:39:51', ''),
('en', '_template', 'underline', 'Underline', '2003-05-22 15:21:31', 'global code picker'),
('en', '_template', 'underscore', 'Underscore', '2004-06-22 12:09:46', ''),
('en', '_template', 'unenroll', 'Un-enroll', '2004-10-15 11:51:25', 'unenroll button in enrollment manager'),
('en', '_template', 'unenrolled', 'Un-enrolled', '2004-10-15 11:50:06', 'unenrolled tab in enrollement manager'),
('en', '_template', 'unenroll_me', 'Unenroll', '2007-12-09 08:57:03', ''),
('en', '_template', 'uninstall', 'Uninstall', '2008-10-21 15:41:53', ''),
('en', '_template', 'uninstall_module_info', 'You are about to <strong>UNINSTALL</strong> module <strong><em>%s</em></strong>.', '2008-10-21 15:41:53', ''),
('en', '_template', 'unique_visits', 'Unique Visits', '2005-03-01 12:41:13', 'tracker'),
('en', '_template', 'university', 'School/Institution', '2009-05-27 12:01:11', ''),
('en', '_template', 'unknown', 'Unknown', '2003-06-06 10:41:35', 'links database , file upload progress window'),
('en', '_template', 'unknown_error', 'An unknown error occured', '2003-05-22 15:22:55', 'general catch all error message'),
('en', '_template', 'unlimited', 'Unlimited', '2005-03-01 11:22:02', 'admin course properties & file manager'),
('en', '_template', 'unlock_thread', 'Unlock Topic', '2014-01-02 15:42:55', 'forum instructor lock screen'),
('en', '_template', 'unmarked', 'Unmarked', '2003-05-22 15:25:33', 'mytests, test manager'),
('en', '_template', 'unmarked_label', 'Unmarked (%s)', '2005-05-12 10:25:56', ''),
('en', '_template', 'unreleased', 'Unreleased', '2005-05-04 13:59:37', ''),
('en', '_template', 'unshared_forums', 'Unshared Forums', '2004-11-05 10:50:02', ''),
('en', '_template', 'unsubscribe', 'UnSubscribe from this thread to cancel receiving notifications via email of new replies.', '2003-11-06 13:47:20', ''),
('en', '_template', 'unsubscribe1', 'Unsubscribe', '2004-12-02 15:32:28', ''),
('en', '_template', 'until', 'Until', '2006-03-23 11:38:49', ''),
('en', '_template', 'unvisited_pages', 'You have not viewed the following pages:', '2003-09-13 11:56:50', 'mytracker summary'),
('en', '_template', 'update', 'Update', '2004-11-24 14:28:45', ''),
('en', '_template', 'updated', 'Updated', '2003-05-22 15:33:15', 'admin course manager'),
('en', '_template', 'update_gradebook', 'Update ATutor Marks', '2008-09-25 16:01:17', 'gradebook'),
('en', '_template', 'update_list', 'Update List', '2005-05-10 14:31:59', ''),
('en', '_template', 'update_to', 'Update To', '2005-03-03 12:16:15', ''),
('en', '_template', 'upload', 'Upload', '2003-05-22 15:56:16', 'global upload button/link text'),
('en', '_template', 'upload_backup', 'Upload Backup', '2008-05-20 12:44:13', ''),
('en', '_template', 'upload_content_package', 'Upload a Content Package or Common Cartridge', '2009-11-16 10:54:04', ''),
('en', '_template', 'upload_custom_logo', 'Upload Custom Logo', '2014-06-06 19:21:52', ''),
('en', '_template', 'upload_file', 'Upload File', '2006-03-20 14:37:46', ''),
('en', '_template', 'upload_files', 'Upload files', '2008-07-22 16:43:38', 'Used in filemanager and any place that uses fluid for multiple file upload.'),
('en', '_template', 'upload_icon', 'Upload Custom Course Icon', '2007-11-09 13:05:42', 'Course Properties Custom Icon'),
('en', '_template', 'upload_icon_text', 'This icon will be uploaded to the file manager for this course under the folder ''/custom_icons''.', '2008-07-28 10:36:03', 'Course Properties Custom Icon Text'),
('en', '_template', 'upload_module', 'Upload a module zip file to install it:', '2008-11-05 08:48:45', 'Module installation message'),
('en', '_template', 'upload_new_picture', 'Upload new picture', '2007-02-26 17:23:08', ''),
('en', '_template', 'upload_patch', 'Upload a zip file to install patch:', '2008-04-21 15:08:55', 'patcher'),
('en', '_template', 'upload_progress', 'File Upload in Progress...', '2003-06-06 10:36:38', 'file upload progress window'),
('en', '_template', 'upload_question', 'Select Question Package to Upload', '2008-09-23 14:00:24', ''),
('en', '_template', 'upload_test', 'Select Test Package to Upload', '2008-09-23 13:58:43', ''),
('en', '_template', 'upload_theme_package', 'Upload a Theme', '2004-10-18 15:09:32', 'Theme Manager'),
('en', '_template', 'upload_zip', 'Choose a zip file to upload.', '2016-01-02 10:48:00', 'patcher'),
('en', '_template', 'urdu', 'Urdu', '2008-09-09 09:01:12', ''),
('en', '_template', 'url', 'URL', '2003-05-22 15:56:36', 'links database'),
('en', '_template', 'url_to_read', 'URL To Read', '2006-04-13 12:01:15', ''),
('en', '_template', 'usage', 'Usage', '2005-03-16 13:55:31', 'content manager'),
('en', '_template', 'usaved_changes_made', 'Unsaved changes made', '2004-01-15 13:30:06', 'editing content'),
('en', '_template', 'user', 'User', '2003-05-22 15:59:34', 'links database'),
('en', '_template', 'username', 'Username', '2003-05-22 16:00:31', 'global username label/link text'),
('en', '_template', 'users', 'Users', '2003-05-22 16:02:26', 'forum, admin user manager'),
('en', '_template', 'users_online', 'Users Online', '2003-05-22 16:03:00', 'discussions page text'),
('en', '_template', 'user_contributed_notes', 'User Contributed Handbook Notes', '2005-07-27 12:01:52', ''),
('en', '_template', 'user_offline', 'Offline', '2005-03-11 16:19:14', 'directory'),
('en', '_template', 'user_online', 'Online', '2005-03-11 16:19:28', 'directory'),
('en', '_template', 'user_type', 'User Type', '2008-10-06 13:41:48', ''),
('en', '_template', 'use_alt_to_audio', 'Use Alternative To Audio', '2008-09-09 08:56:34', ''),
('en', '_template', 'use_alt_to_text', 'Use Alternative To Text', '2008-09-09 08:56:34', ''),
('en', '_template', 'use_alt_to_visual', 'Use Alternative To Visual', '2008-09-09 08:56:34', ''),
('en', '_template', 'use_as_alternative', 'Use As Alternative', '2010-03-09 16:15:53', 'adapted content'),
('en', '_template', 'use_captcha', 'Allow the use of CAPTCHA', '2009-06-03 15:33:17', ''),
('en', '_template', 'use_customized_head', 'Turn on custom Scripts/CSS', '2010-05-03 10:44:56', ''),
('en', '_template', 'use_enrol_button', 'Use the button below to enroll in this course.', '2003-05-22 16:03:37', 'enrol screen instruction'),
('en', '_template', 'use_existing_logo', 'Use Existing Logo', '2014-03-02 10:41:20', 'admin custom logo'),
('en', '_template', 'use_higher_grade', 'Use higher grade', '2008-09-25 16:01:17', 'gradebook'),
('en', '_template', 'use_lower_grade', 'Use lower grade', '2008-09-25 16:01:17', 'gradebook'),
('en', '_template', 'use_parent_theme', 'Use parent category''s theme.', '2004-08-04 11:34:41', ''),
('en', '_template', 'use_system_time', 'Use the system''s time', '2006-11-01 13:06:01', ''),
('en', '_template', 'use_url_as_alternative', 'Use a remote URL as an alternative', '2010-06-18 13:28:40', ''),
('en', '_template', 'use_visual_editor', '<small style="text-decoration:underline;">(Editor)</small>', '2004-12-08 12:15:36', 'form editor in create test question'),
('en', '_template', 'version', 'Version', '2003-05-22 16:04:54', 'copyright notice in footer'),
('en', '_template', 'version_history', 'Version History', '2008-10-21 15:41:53', ''),
('en', '_template', 'version_not_match', 'This patch is for ATutor version %s. Does not match with your current ATutor version. The installation of it may break ATutor. Are you sure you want to proceed?', '2008-06-19 13:20:45', 'patcher warning message'),
('en', '_template', 'vertical', 'Vertical', '2004-12-01 13:34:28', 'create/edit test question option'),
('en', '_template', 'view', 'View', '2004-02-16 15:23:09', ''),
('en', '_template', 'viewing_errors', 'Viewing Error(s)', '2004-12-06 12:10:05', ''),
('en', '_template', 'viewing_profile_bugs', 'Viewing Profile Bugs', '2004-12-06 12:03:33', ''),
('en', '_template', 'view_all', 'View All', '2005-08-04 09:54:04', ''),
('en', '_template', 'view_course_content', 'View Course Content', '2013-10-02 11:07:20', 'mobile'),
('en', '_template', 'view_details', 'View Details', '2005-03-11 11:27:43', ''),
('en', '_template', 'view_entire_post', 'View Entire Post', '2003-05-22 16:07:57', 'forum message view'),
('en', '_template', 'view_groups', 'View Group', '2009-05-27 12:01:11', ''),
('en', '_template', 'view_log', 'View Activity Log', '2005-03-03 10:44:12', ''),
('en', '_template', 'view_mark_test', 'View & Mark Test', '2003-05-22 16:08:11', 'test manager'),
('en', '_template', 'view_message', 'View Message', '2005-03-14 11:48:21', ''),
('en', '_template', 'view_profile_bugs', 'View Profile Bugs', '2004-12-06 11:51:58', 'admin/error_logging.php'),
('en', '_template', 'view_readme', 'View Readme', '2009-07-21 15:31:29', ''),
('en', '_template', 'view_responses', 'View Responses', '2004-08-25 11:53:13', ''),
('en', '_template', 'view_results', 'View Results', '2003-05-22 16:09:09', 'mytests, test manager'),
('en', '_template', 'view_selected_bugs', 'View Selected Bugs', '2004-12-06 12:06:26', ''),
('en', '_template', 'view_sub_topics', 'View subtopics', '2005-03-16 13:35:47', 'content manager'),
('en', '_template', 'view_tracking', 'View Tracking', '2003-05-22 16:09:31', 'tracker'),
('en', '_template', 'vimeo', 'Vimeo', '2010-11-30 18:09:48', 'module name'),
('en', '_template', 'visitor_counts', 'Visitor counts', '2009-05-27 12:01:11', ''),
('en', '_template', 'visits', 'Visits', '2003-09-13 09:19:09', 'tracker summary read'),
('en', '_template', 'visual', 'Visual', '2008-09-08 14:19:07', ''),
('en', '_template', 'visual_editor', 'Visual Editor', '2006-11-23 13:31:56', ''),
('en', '_template', 'vote_to_see_results', 'Vote to see results.', '2004-06-21 16:55:42', ''),
('en', '_template', 'warning', 'Warning', '2003-05-22 16:09:47', 'text for warning message'),
('en', '_template', 'weblink', 'Web Link', '2009-10-22 16:18:13', 'content editor'),
('en', '_template', 'websites', 'Websites', '2009-05-27 12:01:11', ''),
('en', '_template', 'web_service_id', 'Web Service ID', '2010-05-05 16:17:46', ''),
('en', '_template', 'web_site', 'Web Site', '2003-05-22 16:10:20', 'registration, profile'),
('en', '_template', 'weight', 'Weight', '2003-05-22 16:10:31', 'test manager'),
('en', '_template', 'welcome_to_atutor', 'Welcome To ATutor', '2003-05-31 15:30:38', 'announcement default heading for new course'),
('en', '_template', 'white', 'White', '2008-09-09 09:01:13', ''),
('en', '_template', 'window_auto_close', 'This window will close automatically.', '2003-06-06 10:37:43', 'file upload progress window'),
('en', '_template', 'workspace', 'Workspace', '2006-03-20 14:38:08', ''),
('en', '_template', 'world_network', 'World Network', '2009-05-27 12:01:11', ''),
('en', '_template', 'wrong_answer', 'Wrong Answer', '2003-05-22 16:11:51', 'test manager question editor'),
('en', '_template', 'wrong_request_token', 'Mismatched request token from OAuth server.', '2010-02-23 10:03:11', 'oauth client'),
('en', '_template', 'year', 'Year', '2004-06-24 15:45:35', ''),
('en', '_template', 'yellow', 'Yellow', '2008-09-09 09:01:13', ''),
('en', '_template', 'yes', 'Yes', '2005-03-03 10:18:48', 'preferences, admin course manager'),
('en', '_template', 'yes_delete', 'Yes / Delete', '2003-05-22 16:14:23', 'global delete response option'),
('en', '_template', 'your_applications', 'My Gadgets', '2009-05-27 12:01:11', ''),
('en', '_template', 'your_mark', 'Your Mark', '2008-09-25 16:01:17', 'gradebook'),
('en', '_template', 'you_are_here', 'You are here', '2003-10-02 16:46:28', 'ALT text Global/Local Navigation link to self'),
('en', '_template', 'zip_archive', 'Zip Archive', '2003-05-22 16:20:01', 'file manager'),
('en', '_template', 'zip_file_manager', 'Zip File Manager', '2003-05-22 16:20:14', 'file manager'),
('en', '_template', 'zip_illegal_contents', 'The contents of this archive are listed below. Illegal file types will not be extracted, and file names containing illegal characters will be translated.', '2004-08-10 15:10:04', '');

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]links`
--

CREATE TABLE `[[dbprefix]]links` (
  `link_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `cat_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `Url` varchar(255) NOT NULL DEFAULT '',
  `LinkName` varchar(64) NOT NULL DEFAULT '',
  `Description` text,
  `Approved` tinyint(8) DEFAULT '0',
  `SubmitName` varchar(64) NOT NULL DEFAULT '',
  `SubmitEmail` varchar(64) NOT NULL DEFAULT '',
  `SubmitDate` date NOT NULL,
  `hits` int(11) DEFAULT '0',
  PRIMARY KEY (`link_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]links_categories`
--

CREATE TABLE `[[dbprefix]]links_categories` (
  `cat_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `owner_type` tinyint(4) NOT NULL DEFAULT '0',
  `owner_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `name` varchar(255) NOT NULL,
  `parent_id` mediumint(8) unsigned DEFAULT NULL,
  PRIMARY KEY (`cat_id`),
  KEY `owner_id` (`owner_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]mail_queue`
--

CREATE TABLE `[[dbprefix]]mail_queue` (
  `mail_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `to_email` varchar(50) NOT NULL DEFAULT '',
  `to_name` varchar(50) NOT NULL DEFAULT '',
  `from_email` varchar(50) NOT NULL DEFAULT '',
  `from_name` varchar(50) NOT NULL DEFAULT '',
  `char_set` varchar(20) NOT NULL DEFAULT '',
  `subject` varchar(255) NOT NULL,
  `body` text,
  PRIMARY KEY (`mail_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]master_list`
--

CREATE TABLE `[[dbprefix]]master_list` (
  `public_field` char(30) NOT NULL DEFAULT '',
  `hash_field` char(40) NOT NULL DEFAULT '',
  `member_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`public_field`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]members`
--

CREATE TABLE `[[dbprefix]]members` (
  `member_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `login` varchar(20) NOT NULL DEFAULT '',
  `password` varchar(40) NOT NULL DEFAULT '',
  `email` varchar(50) NOT NULL DEFAULT '',
  `website` varchar(200) NOT NULL DEFAULT '',
  `first_name` varchar(100) NOT NULL,
  `second_name` varchar(100) NOT NULL DEFAULT '',
  `last_name` varchar(100) NOT NULL,
  `dob` date NOT NULL,
  `gender` enum('m','f','n') NOT NULL DEFAULT 'n',
  `address` text,
  `postal` varchar(15) NOT NULL DEFAULT '',
  `city` varchar(100) NOT NULL DEFAULT '',
  `province` varchar(100) NOT NULL DEFAULT '',
  `country` varchar(100) NOT NULL DEFAULT '',
  `phone` varchar(15) NOT NULL DEFAULT '',
  `status` tinyint(4) NOT NULL DEFAULT '0',
  `preferences` text,
  `creation_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `language` varchar(5) NOT NULL DEFAULT '',
  `inbox_notify` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `private_email` tinyint(4) NOT NULL DEFAULT '1',
  `last_login` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`member_id`),
  UNIQUE KEY `login` (`login`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `[[dbprefix]]members`
--


-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]member_login_attempt`
--

CREATE TABLE `[[dbprefix]]member_login_attempt` (
  `login` varchar(20) NOT NULL,
  `attempt` tinyint(3) unsigned DEFAULT NULL,
  `expiry` int(10) unsigned DEFAULT NULL,
  PRIMARY KEY (`login`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]member_track`
--

CREATE TABLE `[[dbprefix]]member_track` (
  `member_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `course_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `content_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `counter` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `duration` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `last_accessed` timestamp NULL DEFAULT NULL,
  KEY `member_id` (`member_id`),
  KEY `content_id` (`content_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]messages`
--

CREATE TABLE `[[dbprefix]]messages` (
  `message_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `course_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `from_member_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `to_member_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `date_sent` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `new` tinyint(4) NOT NULL DEFAULT '0',
  `replied` tinyint(4) NOT NULL DEFAULT '0',
  `subject` varchar(255) NOT NULL,
  `body` text,
  PRIMARY KEY (`message_id`),
  KEY `to_member_id` (`to_member_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]messages_sent`
--

CREATE TABLE `[[dbprefix]]messages_sent` (
  `message_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `course_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `from_member_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `to_member_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `date_sent` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `subject` varchar(255) NOT NULL,
  `body` text,
  PRIMARY KEY (`message_id`),
  KEY `from_member_id` (`from_member_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]modules`
--

CREATE TABLE `[[dbprefix]]modules` (
  `dir_name` varchar(50) NOT NULL DEFAULT '',
  `status` tinyint(4) NOT NULL DEFAULT '0',
  `privilege` bigint(20) unsigned NOT NULL DEFAULT '0',
  `admin_privilege` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `cron_interval` smallint(5) unsigned NOT NULL DEFAULT '0',
  `cron_last_run` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`dir_name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `[[dbprefix]]modules`
--

INSERT INTO `[[dbprefix]]modules` VALUES
('_core/properties', 2, 1, 0, 0, 0),
('_standard/statistics', 2, 1, 0, 0, 0),
('_core/content', 2, 2, 0, 0, 0),
('_core/glossary', 2, 4, 0, 0, 0),
('_standard/tests', 2, 8, 0, 0, 0),
('_standard/chat', 2, 16, 0, 0, 0),
('_core/file_manager', 2, 32, 0, 0, 0),
('_standard/links', 2, 64, 0, 0, 0),
('_standard/forums', 2, 128, 16, 0, 0),
('_standard/course_tools', 2, 256, 0, 0, 0),
('_core/enrolment', 2, 512, 512, 0, 0),
('_standard/course_email', 2, 1024, 0, 0, 0),
('_standard/announcements', 2, 2048, 0, 0, 0),
('_standard/polls', 2, 16384, 0, 0, 0),
('_standard/faq', 2, 32768, 0, 0, 0),
('_core/groups', 2, 65536, 0, 0, 0),
('_standard/reading_list', 2, 131072, 0, 0, 0),
('_standard/file_storage', 2, 262144, 0, 0, 0),
('_standard/assignments', 2, 524288, 0, 0, 0),
('_standard/gradebook', 2, 1048576, 4096, 0, 0),
('_standard/student_tools', 2, 2097152, 0, 0, 0),
('_standard/farchive', 2, 4194304, 0, 0, 0),
('_standard/social', 2, 8388608, 0, 0, 0),
('_standard/photos', 2, 16777216, 0, 0, 0),
('_standard/flowplayer', 2, 33554432, 0, 0, 0),
('_standard/basiclti', 2, 67108864, 16384, 0, 0),
('_standard/helpme', 2, 0, 32768, 0, 0),
('_standard/assignment_dropbox', 2, 134217728, 0, 0, 0),
('_standard/calendar', 2, 268435456, 0, 0, 0),
('_standard/gameme', 2, 536870912, 65536, 0, 0),
('_core/users', 2, 0, 2, 0, 0),
('_core/courses', 2, 0, 4, 0, 0),
('_core/backups', 2, 1, 8, 0, 0),
('_core/cats_categories', 2, 0, 32, 0, 0),
('_core/languages', 2, 0, 64, 1440, 0),
('_core/themes', 2, 0, 128, 0, 0),
('_standard/rss_feeds', 2, 0, 256, 0, 0),
('_standard/directory', 2, 0, 0, 0, 0),
('_standard/tile_search', 2, 0, 0, 0, 0),
('_standard/sitemap', 2, 0, 0, 0, 0),
('_standard/tracker', 2, 0, 0, 0, 0),
('_core/content_packaging', 2, 0, 0, 0, 0),
('_standard/google_search', 2, 0, 0, 0, 0),
('_standard/blogs', 2, 0, 0, 0, 0),
('_standard/profile_pictures', 2, 0, 0, 0, 0),
('_standard/patcher', 2, 0, 1024, 0, 0),
('_standard/support_tools', 2, 0, 2048, 0, 0),
('_core/tool_manager', 2, 0, 0, 0, 0),
('_core/modules', 2, 0, 8192, 0, 0),
('_standard/vimeo', 2, 0, 1, 0, 0);

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]myown_patches`
--

CREATE TABLE `[[dbprefix]]myown_patches` (
  `myown_patch_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `atutor_patch_id` varchar(20) NOT NULL DEFAULT '',
  `applied_version` varchar(10) NOT NULL DEFAULT '',
  `description` text,
  `sql_statement` text,
  `status` varchar(20) NOT NULL DEFAULT '',
  `last_modified` datetime NOT NULL,
  PRIMARY KEY (`myown_patch_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]myown_patches_dependent`
--

CREATE TABLE `[[dbprefix]]myown_patches_dependent` (
  `myown_patches_dependent_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `myown_patch_id` mediumint(8) unsigned NOT NULL,
  `dependent_patch_id` varchar(50) NOT NULL DEFAULT '',
  PRIMARY KEY (`myown_patches_dependent_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]myown_patches_files`
--

CREATE TABLE `[[dbprefix]]myown_patches_files` (
  `myown_patches_files_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `myown_patch_id` mediumint(8) unsigned NOT NULL,
  `action` varchar(20) NOT NULL DEFAULT '',
  `name` varchar(250) NOT NULL,
  `location` varchar(250) NOT NULL DEFAULT '',
  `code_from` text,
  `code_to` text,
  `uploaded_file` text,
  PRIMARY KEY (`myown_patches_files_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]news`
--

CREATE TABLE `[[dbprefix]]news` (
  `news_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `course_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,
  `formatting` tinyint(4) NOT NULL DEFAULT '0',
  `title` varchar(200) NOT NULL,
  `body` text,
  PRIMARY KEY (`news_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]oauth_client_servers`
--

CREATE TABLE `[[dbprefix]]oauth_client_servers` (
  `oauth_server_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `oauth_server` varchar(255) NOT NULL DEFAULT '',
  `consumer_key` text,
  `consumer_secret` text,
  `expire_threshold` int(11) NOT NULL DEFAULT '0',
  `create_date` datetime NOT NULL,
  PRIMARY KEY (`oauth_server_id`),
  UNIQUE KEY `idx_consumer` (`oauth_server`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]oauth_client_tokens`
--

CREATE TABLE `[[dbprefix]]oauth_client_tokens` (
  `oauth_server_id` mediumint(8) unsigned NOT NULL,
  `token` varchar(50) NOT NULL DEFAULT '',
  `token_type` varchar(50) NOT NULL DEFAULT '',
  `token_secret` text,
  `member_id` mediumint(8) unsigned NOT NULL,
  `assign_date` datetime NOT NULL,
  PRIMARY KEY (`oauth_server_id`,`token`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]patches`
--

CREATE TABLE `[[dbprefix]]patches` (
  `patches_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `atutor_patch_id` varchar(20) NOT NULL DEFAULT '',
  `applied_version` varchar(10) NOT NULL DEFAULT '',
  `patch_folder` varchar(250) NOT NULL DEFAULT '',
  `description` text,
  `available_to` varchar(250) NOT NULL DEFAULT '',
  `sql_statement` text,
  `status` varchar(20) NOT NULL DEFAULT '',
  `remove_permission_files` text,
  `backup_files` text,
  `patch_files` text,
  `author` varchar(255) NOT NULL,
  `installed_date` datetime NOT NULL,
  PRIMARY KEY (`patches_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]patches_files`
--

CREATE TABLE `[[dbprefix]]patches_files` (
  `patches_files_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `patches_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `action` varchar(20) NOT NULL DEFAULT '',
  `name` text,
  `location` varchar(250) NOT NULL DEFAULT '',
  PRIMARY KEY (`patches_files_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]patches_files_actions`
--

CREATE TABLE `[[dbprefix]]patches_files_actions` (
  `patches_files_actions_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `patches_files_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `action` varchar(20) NOT NULL DEFAULT '',
  `code_from` text,
  `code_to` text,
  PRIMARY KEY (`patches_files_actions_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]pa_albums`
--

CREATE TABLE `[[dbprefix]]pa_albums` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `location` varchar(255) NOT NULL,
  `description` text,
  `permission` tinyint(1) unsigned NOT NULL,
  `member_id` int(10) unsigned NOT NULL,
  `photo_id` int(10) unsigned NOT NULL,
  `type_id` tinyint(1) unsigned NOT NULL,
  `created_date` datetime NOT NULL,
  `last_updated` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]pa_album_comments`
--

CREATE TABLE `[[dbprefix]]pa_album_comments` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `album_id` int(10) unsigned NOT NULL,
  `member_id` int(10) unsigned NOT NULL,
  `comment` text,
  `created_date` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]pa_course_album`
--

CREATE TABLE `[[dbprefix]]pa_course_album` (
  `course_id` int(10) unsigned NOT NULL DEFAULT '0',
  `album_id` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`course_id`,`album_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]pa_groups`
--

CREATE TABLE `[[dbprefix]]pa_groups` (
  `group_id` int(10) unsigned NOT NULL,
  `album_id` int(10) unsigned NOT NULL,
  PRIMARY KEY (`group_id`,`album_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]pa_photos`
--

CREATE TABLE `[[dbprefix]]pa_photos` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `description` text,
  `alt_text` text,
  `member_id` int(10) unsigned NOT NULL,
  `album_id` int(10) unsigned NOT NULL,
  `ordering` smallint(5) unsigned NOT NULL,
  `created_date` datetime NOT NULL,
  `last_updated` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]pa_photo_comments`
--

CREATE TABLE `[[dbprefix]]pa_photo_comments` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `photo_id` int(10) unsigned NOT NULL,
  `member_id` int(10) unsigned NOT NULL,
  `comment` text,
  `created_date` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]polls`
--

CREATE TABLE `[[dbprefix]]polls` (
  `poll_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `course_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `question` varchar(255) NOT NULL,
  `created_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `total` smallint(5) unsigned NOT NULL DEFAULT '0',
  `choice1` varchar(255) NOT NULL,
  `count1` smallint(5) unsigned NOT NULL DEFAULT '0',
  `choice2` varchar(255) NOT NULL,
  `count2` smallint(5) unsigned NOT NULL DEFAULT '0',
  `choice3` varchar(255) NOT NULL,
  `count3` smallint(5) unsigned NOT NULL DEFAULT '0',
  `choice4` varchar(255) NOT NULL,
  `count4` smallint(5) unsigned NOT NULL DEFAULT '0',
  `choice5` varchar(255) NOT NULL,
  `count5` smallint(5) unsigned NOT NULL DEFAULT '0',
  `choice6` varchar(255) NOT NULL,
  `count6` smallint(5) unsigned NOT NULL DEFAULT '0',
  `choice7` varchar(255) NOT NULL,
  `count7` smallint(5) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`poll_id`),
  KEY `course_id` (`course_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]polls_members`
--

CREATE TABLE `[[dbprefix]]polls_members` (
  `poll_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `member_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`poll_id`,`member_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]primary_resources`
--

CREATE TABLE `[[dbprefix]]primary_resources` (
  `primary_resource_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `content_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `resource` text,
  `language_code` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`primary_resource_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]primary_resources_types`
--

CREATE TABLE `[[dbprefix]]primary_resources_types` (
  `primary_resource_id` mediumint(8) unsigned NOT NULL,
  `type_id` mediumint(8) unsigned NOT NULL,
  PRIMARY KEY (`primary_resource_id`,`type_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]reading_list`
--

CREATE TABLE `[[dbprefix]]reading_list` (
  `reading_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `course_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `resource_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `required` enum('required','optional') NOT NULL DEFAULT 'required',
  `date_start` date NOT NULL,
  `date_end` date NOT NULL,
  `comment` text,
  PRIMARY KEY (`reading_id`),
  KEY `course_id` (`course_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]related_content`
--

CREATE TABLE `[[dbprefix]]related_content` (
  `content_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `related_content_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`content_id`,`related_content_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]resource_types`
--

CREATE TABLE `[[dbprefix]]resource_types` (
  `type_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `type` text,
  PRIMARY KEY (`type_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;

--
-- Dumping data for table `[[dbprefix]]resource_types`
--

INSERT INTO `[[dbprefix]]resource_types` VALUES
(1, 'auditory'),
(2, 'sign_language'),
(3, 'textual'),
(4, 'visual');

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]secondary_resources`
--

CREATE TABLE `[[dbprefix]]secondary_resources` (
  `secondary_resource_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `primary_resource_id` mediumint(8) unsigned NOT NULL,
  `secondary_resource` text,
  `language_code` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`secondary_resource_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]secondary_resources_types`
--

CREATE TABLE `[[dbprefix]]secondary_resources_types` (
  `secondary_resource_id` mediumint(8) unsigned NOT NULL,
  `type_id` mediumint(8) unsigned NOT NULL,
  PRIMARY KEY (`secondary_resource_id`,`type_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]social_activities`
--

CREATE TABLE `[[dbprefix]]social_activities` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `member_id` int(10) unsigned NOT NULL,
  `application_id` int(10) unsigned NOT NULL,
  `title` text,
  `created_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]social_applications`
--

CREATE TABLE `[[dbprefix]]social_applications` (
  `id` int(10) unsigned DEFAULT NULL,
  `url` varchar(255) NOT NULL DEFAULT '',
  `title` varchar(255) NOT NULL,
  `height` int(10) unsigned DEFAULT NULL,
  `scrolling` int(10) unsigned DEFAULT NULL,
  `screenshot` varchar(255) NOT NULL,
  `thumbnail` varchar(255) NOT NULL,
  `author` varchar(255) NOT NULL,
  `author_email` varchar(128) NOT NULL,
  `description` text,
  `settings` text,
  `views` text,
  `last_updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`url`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]social_application_settings`
--

CREATE TABLE `[[dbprefix]]social_application_settings` (
  `application_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `member_id` int(10) unsigned NOT NULL,
  `name` varchar(255) NOT NULL,
  `value` text,
  PRIMARY KEY (`application_id`,`member_id`,`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]social_friends`
--

CREATE TABLE `[[dbprefix]]social_friends` (
  `member_id` int(10) unsigned NOT NULL,
  `friend_id` int(10) unsigned NOT NULL,
  `relationship` int(10) unsigned NOT NULL,
  PRIMARY KEY (`member_id`,`friend_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]social_friend_requests`
--

CREATE TABLE `[[dbprefix]]social_friend_requests` (
  `member_id` int(10) unsigned NOT NULL,
  `friend_id` int(10) unsigned NOT NULL,
  `relationship` int(10) unsigned NOT NULL,
  PRIMARY KEY (`member_id`,`friend_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]social_groups`
--

CREATE TABLE `[[dbprefix]]social_groups` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `member_id` int(10) unsigned NOT NULL,
  `type_id` int(10) unsigned NOT NULL,
  `privacy` int(10) unsigned NOT NULL,
  `name` varchar(255) NOT NULL,
  `logo` varchar(255) NOT NULL,
  `description` text,
  `created_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `last_updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]social_groups_activities`
--

CREATE TABLE `[[dbprefix]]social_groups_activities` (
  `activity_id` int(10) unsigned NOT NULL,
  `group_id` int(10) unsigned NOT NULL,
  PRIMARY KEY (`activity_id`,`group_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]social_groups_board`
--

CREATE TABLE `[[dbprefix]]social_groups_board` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `member_id` int(10) unsigned NOT NULL,
  `group_id` int(10) unsigned NOT NULL,
  `body` text,
  `created_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]social_groups_invitations`
--

CREATE TABLE `[[dbprefix]]social_groups_invitations` (
  `sender_id` int(10) unsigned NOT NULL,
  `member_id` int(10) unsigned NOT NULL,
  `group_id` int(10) unsigned NOT NULL,
  PRIMARY KEY (`sender_id`,`member_id`,`group_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]social_groups_members`
--

CREATE TABLE `[[dbprefix]]social_groups_members` (
  `group_id` int(10) unsigned NOT NULL,
  `member_id` int(10) unsigned NOT NULL,
  PRIMARY KEY (`group_id`,`member_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]social_groups_requests`
--

CREATE TABLE `[[dbprefix]]social_groups_requests` (
  `sender_id` int(10) unsigned NOT NULL,
  `member_id` int(10) unsigned NOT NULL,
  `group_id` int(10) unsigned NOT NULL,
  PRIMARY KEY (`sender_id`,`member_id`,`group_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]social_groups_types`
--

CREATE TABLE `[[dbprefix]]social_groups_types` (
  `type_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(127) NOT NULL,
  PRIMARY KEY (`type_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=9 ;

--
-- Dumping data for table `[[dbprefix]]social_groups_types`
--

INSERT INTO `[[dbprefix]]social_groups_types` VALUES
(1, 'business'),
(2, 'common_interest'),
(3, 'entertainment_arts'),
(4, 'geography'),
(5, 'internet_technology'),
(6, 'organization'),
(7, 'music'),
(8, 'sports_recreation');

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]social_members_applications`
--

CREATE TABLE `[[dbprefix]]social_members_applications` (
  `member_id` int(10) unsigned NOT NULL,
  `application_id` int(10) unsigned NOT NULL,
  PRIMARY KEY (`member_id`,`application_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]social_member_additional_information`
--

CREATE TABLE `[[dbprefix]]social_member_additional_information` (
  `member_id` int(10) unsigned NOT NULL,
  `expertise` varchar(255) NOT NULL,
  `interests` text,
  `associations` text,
  `awards` text,
  `others` text,
  PRIMARY KEY (`member_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]social_member_contact`
--

CREATE TABLE `[[dbprefix]]social_member_contact` (
  `contact_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `member_id` int(10) unsigned NOT NULL,
  `con_name` varchar(200) NOT NULL,
  `con_phone` varchar(15) NOT NULL,
  `con_email` varchar(50) NOT NULL,
  `con_address` text,
  PRIMARY KEY (`contact_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]social_member_education`
--

CREATE TABLE `[[dbprefix]]social_member_education` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `member_id` int(10) unsigned NOT NULL,
  `university` varchar(255) NOT NULL,
  `country` varchar(128) DEFAULT NULL,
  `province` varchar(128) DEFAULT NULL,
  `degree` varchar(64) DEFAULT NULL,
  `field` varchar(64) DEFAULT NULL,
  `from` varchar(10) NOT NULL DEFAULT '0',
  `to` varchar(10) NOT NULL DEFAULT '0',
  `description` text,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]social_member_personal`
--

CREATE TABLE `[[dbprefix]]social_member_personal` (
  `per_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `member_id` int(10) unsigned NOT NULL,
  `per_weight` varchar(200) NOT NULL,
  `per_height` varchar(50) NOT NULL,
  `per_hair` varchar(15) NOT NULL,
  `per_eyes` varchar(50) NOT NULL,
  `per_ethnicity` varchar(50) NOT NULL,
  `per_languages` varchar(255) NOT NULL,
  `per_disabilities` varchar(255) NOT NULL,
  PRIMARY KEY (`per_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]social_member_position`
--

CREATE TABLE `[[dbprefix]]social_member_position` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `member_id` int(10) unsigned NOT NULL,
  `title` varchar(255) NOT NULL,
  `company` varchar(255) NOT NULL,
  `from` varchar(10) NOT NULL DEFAULT '0',
  `to` varchar(10) NOT NULL DEFAULT '0',
  `description` text,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]social_member_representation`
--

CREATE TABLE `[[dbprefix]]social_member_representation` (
  `rep_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `member_id` int(10) unsigned NOT NULL,
  `rep_name` varchar(200) NOT NULL,
  `rep_title` varchar(50) NOT NULL,
  `rep_phone` varchar(15) NOT NULL,
  `rep_email` varchar(50) NOT NULL,
  `rep_address` text,
  PRIMARY KEY (`rep_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]social_member_track`
--

CREATE TABLE `[[dbprefix]]social_member_track` (
  `member_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `visitor_id` int(10) unsigned NOT NULL,
  `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`member_id`,`visitor_id`,`timestamp`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]social_member_websites`
--

CREATE TABLE `[[dbprefix]]social_member_websites` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `member_id` int(10) unsigned NOT NULL,
  `url` varchar(255) NOT NULL,
  `site_name` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]social_privacy_preferences`
--

CREATE TABLE `[[dbprefix]]social_privacy_preferences` (
  `member_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `preferences` text,
  PRIMARY KEY (`member_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]social_user_settings`
--

CREATE TABLE `[[dbprefix]]social_user_settings` (
  `member_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `app_settings` text,
  PRIMARY KEY (`member_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]tests`
--

CREATE TABLE `[[dbprefix]]tests` (
  `test_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `course_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `title` varchar(255) NOT NULL,
  `format` tinyint(4) NOT NULL DEFAULT '0',
  `start_date` datetime NOT NULL,
  `end_date` datetime NOT NULL,
  `randomize_order` tinyint(4) NOT NULL DEFAULT '0',
  `num_questions` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `instructions` text,
  `content_id` mediumint(8) NOT NULL DEFAULT '0',
  `result_release` tinyint(4) unsigned NOT NULL DEFAULT '0',
  `random` tinyint(4) unsigned NOT NULL DEFAULT '0',
  `difficulty` tinyint(4) unsigned NOT NULL DEFAULT '0',
  `num_takes` tinyint(4) unsigned NOT NULL DEFAULT '0',
  `anonymous` tinyint(4) NOT NULL DEFAULT '0',
  `out_of` varchar(4) NOT NULL DEFAULT '',
  `guests` tinyint(4) NOT NULL DEFAULT '0',
  `display` tinyint(4) NOT NULL DEFAULT '0',
  `description` text,
  `passscore` mediumint(9) NOT NULL DEFAULT '0',
  `passpercent` mediumint(9) NOT NULL DEFAULT '0',
  `passfeedback` text,
  `failfeedback` text,
  `show_guest_form` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `remedial_content` tinyint(1) unsigned DEFAULT '0',
  PRIMARY KEY (`test_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]tests_answers`
--

CREATE TABLE `[[dbprefix]]tests_answers` (
  `result_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `question_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `member_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `answer` text,
  `score` varchar(5) NOT NULL DEFAULT '',
  `notes` text,
  PRIMARY KEY (`result_id`,`question_id`,`member_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]tests_groups`
--

CREATE TABLE `[[dbprefix]]tests_groups` (
  `test_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `group_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`test_id`,`group_id`),
  KEY `test_id` (`test_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]tests_questions`
--

CREATE TABLE `[[dbprefix]]tests_questions` (
  `question_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `category_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `course_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `type` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `feedback` text,
  `question` text,
  `choice_0` text,
  `choice_1` text,
  `choice_2` text,
  `choice_3` text,
  `choice_4` text,
  `choice_5` text,
  `choice_6` text,
  `choice_7` text,
  `choice_8` text,
  `choice_9` text,
  `answer_0` tinyint(4) NOT NULL DEFAULT '0',
  `answer_1` tinyint(4) NOT NULL DEFAULT '0',
  `answer_2` tinyint(4) NOT NULL DEFAULT '0',
  `answer_3` tinyint(4) NOT NULL DEFAULT '0',
  `answer_4` tinyint(4) NOT NULL DEFAULT '0',
  `answer_5` tinyint(4) NOT NULL DEFAULT '0',
  `answer_6` tinyint(4) NOT NULL DEFAULT '0',
  `answer_7` tinyint(4) NOT NULL DEFAULT '0',
  `answer_8` tinyint(4) NOT NULL DEFAULT '0',
  `answer_9` tinyint(4) NOT NULL DEFAULT '0',
  `option_0` text,
  `option_1` text,
  `option_2` text,
  `option_3` text,
  `option_4` text,
  `option_5` text,
  `option_6` text,
  `option_7` text,
  `option_8` text,
  `option_9` text,
  `properties` tinyint(4) NOT NULL DEFAULT '0',
  `content_id` mediumint(8) NOT NULL,
  `remedial_content` text,
  PRIMARY KEY (`question_id`),
  KEY `category_id` (`category_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]tests_questions_assoc`
--

CREATE TABLE `[[dbprefix]]tests_questions_assoc` (
  `test_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `question_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `weight` varchar(4) NOT NULL DEFAULT '',
  `ordering` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `required` tinyint(3) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`test_id`,`question_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]tests_questions_categories`
--

CREATE TABLE `[[dbprefix]]tests_questions_categories` (
  `category_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `course_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `title` char(200) NOT NULL DEFAULT '',
  PRIMARY KEY (`category_id`),
  KEY `course_id` (`course_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]tests_results`
--

CREATE TABLE `[[dbprefix]]tests_results` (
  `result_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `test_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `member_id` varchar(10) NOT NULL DEFAULT '',
  `date_taken` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `final_score` char(5) NOT NULL DEFAULT '',
  `status` tinyint(4) NOT NULL DEFAULT '0',
  `end_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `max_pos` tinyint(3) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`result_id`),
  KEY `test_id` (`test_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]themes`
--

CREATE TABLE `[[dbprefix]]themes` (
  `title` varchar(80) NOT NULL DEFAULT '',
  `version` varchar(10) NOT NULL DEFAULT '',
  `dir_name` varchar(20) NOT NULL DEFAULT '',
  `type` varchar(20) NOT NULL DEFAULT 'Desktop',
  `last_updated` date NOT NULL,
  `extra_info` text,
  `status` tinyint(3) unsigned NOT NULL DEFAULT '1',
  `customized` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`title`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `[[dbprefix]]themes`
--

INSERT INTO `[[dbprefix]]themes` VALUES
('ATutor', '2.2.2', 'default', 'Desktop', '[[date]]', 'This is the default ATutor theme and cannot be deleted as other themes inherit from it. Please do not alter this theme directly as it would complicate upgrading. Instead, create a new theme derived from this one.', 2, 0),
('ATutor 2.1', '2.2.2', 'default21', 'Desktop', '[[date]]', 'This is the ATutor 2.1 series defailt theme.', 1, 0),
('Fluid', '2.2.2', 'fluid', 'Desktop', '[[date]]', 'Theme that implements the Fluid reorderer used to drag-and-drop the menu from side-to-side.', 1, 0),
('ATutor Classic', '2.2.2', 'default_classic', 'Desktop', '[[date]]', 'This is the ATutor Classic theme which makes use of the custom Header and logo images. To customize those images you must edit the <code>theme.cfg.php</code> in this themes directory.', 1, 0),
('Blumin', '2.2.2', 'blumin', 'Desktop', '[[date]]', 'This is the plone look-alike theme.', 1, 0),
('Greenmin', '2.2.2', 'greenmin', 'Desktop', '[[date]]', 'This is the plone look-alike theme in green.', 1, 0),
('ATutor 2.0', '2.2.2', 'default20', 'Desktop', '[[date]]', 'This is the ATutor 2.0 series Default theme.', 1, 0),
('ATutor 1.5', '2.2.2', 'default15', 'Desktop', '[[date]]', 'This is the 1.5 series default theme.', 1, 0),
('ATutor 1.6', '2.2.2', 'default16', 'Desktop', '[[date]]', 'This is the 1.6 series default theme.', 1, 0),
('IDI Theme', '2.2.2', 'idi', 'Desktop', '[[date]]', 'The theme created for the IDI course server.', 1, 0),
('Mobile', '2.2.2', 'mobile', 'Mobile', '[[date]]', 'This is the default theme for mobile devices.', 3, 0),
('Simple', '2.2.2', 'simplified_desktop', 'Desktop', '[[date]]', 'An adapted version of the iPad theme, designed to make a desktop look like an iPad.', 1, 0),
('ATutorSpaces', '2.2.2', 'atspaces', 'Desktop', '[[date]]', 'This is the default theme for the ATutorSpaces.com hosting service.', 1, 0);

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]users_online`
--

CREATE TABLE `[[dbprefix]]users_online` (
  `member_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `course_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `login` varchar(255) NOT NULL DEFAULT '',
  `expiry` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`member_id`)
) ENGINE=MEMORY DEFAULT CHARSET=utf8 MAX_ROWS=500;

