-- MySQL dump 9.11 -- -- Host: localhost Database: avirtuou_mdle1 -- ------------------------------------------------------ -- Server version 4.0.22-standard -- -- Table structure for table `mdl_assignment` -- CREATE TABLE `mdl_assignment` ( `id` int(10) unsigned NOT NULL auto_increment, `course` int(10) unsigned NOT NULL default '0', `name` varchar(255) NOT NULL default '', `description` text NOT NULL, `format` tinyint(2) unsigned NOT NULL default '0', `resubmit` tinyint(2) unsigned NOT NULL default '0', `type` int(10) unsigned NOT NULL default '1', `maxbytes` int(10) unsigned NOT NULL default '100000', `timedue` int(10) unsigned NOT NULL default '0', `grade` int(10) NOT NULL default '0', `timemodified` int(10) unsigned NOT NULL default '0', PRIMARY KEY (`id`) ) TYPE=MyISAM COMMENT='Defines assignments'; -- -- Dumping data for table `mdl_assignment` -- -- -- Table structure for table `mdl_assignment_submissions` -- CREATE TABLE `mdl_assignment_submissions` ( `id` int(10) unsigned NOT NULL auto_increment, `assignment` int(10) unsigned NOT NULL default '0', `userid` int(10) unsigned NOT NULL default '0', `timecreated` int(10) unsigned NOT NULL default '0', `timemodified` int(10) unsigned NOT NULL default '0', `numfiles` int(10) unsigned NOT NULL default '0', `grade` int(11) NOT NULL default '0', `comment` text NOT NULL, `teacher` int(10) unsigned NOT NULL default '0', `timemarked` int(10) unsigned NOT NULL default '0', `mailed` tinyint(1) unsigned NOT NULL default '0', PRIMARY KEY (`id`) ) TYPE=MyISAM COMMENT='Info about submitted assignments'; -- -- Dumping data for table `mdl_assignment_submissions` -- -- -- Table structure for table `mdl_backup_config` -- CREATE TABLE `mdl_backup_config` ( `id` int(10) unsigned NOT NULL auto_increment, `name` varchar(255) NOT NULL default '', `value` varchar(255) NOT NULL default '', PRIMARY KEY (`id`), UNIQUE KEY `name` (`name`) ) TYPE=MyISAM COMMENT='To store backup configuration variables'; -- -- Dumping data for table `mdl_backup_config` -- -- -- Table structure for table `mdl_backup_courses` -- CREATE TABLE `mdl_backup_courses` ( `id` int(10) unsigned NOT NULL auto_increment, `courseid` int(10) unsigned NOT NULL default '0', `laststarttime` int(10) unsigned NOT NULL default '0', `lastendtime` int(10) unsigned NOT NULL default '0', `laststatus` char(1) NOT NULL default '0', `nextstarttime` int(10) unsigned NOT NULL default '0', PRIMARY KEY (`id`), UNIQUE KEY `courseid` (`courseid`) ) TYPE=MyISAM COMMENT='To store every course backup status'; -- -- Dumping data for table `mdl_backup_courses` -- -- -- Table structure for table `mdl_backup_files` -- CREATE TABLE `mdl_backup_files` ( `backup_code` int(10) unsigned NOT NULL default '0', `file_type` varchar(10) NOT NULL default '', `path` varchar(255) NOT NULL default '', `old_id` int(10) unsigned default NULL, `new_id` int(10) unsigned default NULL, PRIMARY KEY (`backup_code`,`file_type`,`path`) ) TYPE=MyISAM COMMENT='To store and recode ids to user and course files.'; -- -- Dumping data for table `mdl_backup_files` -- -- -- Table structure for table `mdl_backup_ids` -- CREATE TABLE `mdl_backup_ids` ( `backup_code` int(12) unsigned NOT NULL default '0', `table_name` varchar(30) NOT NULL default '', `old_id` int(10) unsigned NOT NULL default '0', `new_id` int(10) unsigned default NULL, `info` mediumtext, PRIMARY KEY (`backup_code`,`table_name`,`old_id`) ) TYPE=MyISAM COMMENT='To store and convert ids in backup/restore'; -- -- Dumping data for table `mdl_backup_ids` -- -- -- Table structure for table `mdl_backup_log` -- CREATE TABLE `mdl_backup_log` ( `id` int(10) unsigned NOT NULL auto_increment, `courseid` int(10) unsigned NOT NULL default '0', `time` int(10) unsigned NOT NULL default '0', `laststarttime` int(10) unsigned NOT NULL default '0', `info` varchar(255) NOT NULL default '', PRIMARY KEY (`id`) ) TYPE=MyISAM COMMENT='To store every course backup log info'; -- -- Dumping data for table `mdl_backup_log` -- -- -- Table structure for table `mdl_blocks` -- CREATE TABLE `mdl_blocks` ( `id` int(10) unsigned NOT NULL auto_increment, `name` varchar(40) NOT NULL default '', `version` int(10) NOT NULL default '0', `cron` int(10) unsigned NOT NULL default '0', `lastcron` int(10) unsigned NOT NULL default '0', `visible` tinyint(1) NOT NULL default '1', PRIMARY KEY (`id`) ) TYPE=MyISAM; -- -- Dumping data for table `mdl_blocks` -- INSERT INTO `mdl_blocks` (`id`, `name`, `version`, `cron`, `lastcron`, `visible`) VALUES (1,'activity_modules',2004041000,0,0,1); INSERT INTO `mdl_blocks` (`id`, `name`, `version`, `cron`, `lastcron`, `visible`) VALUES (2,'admin',2004081200,0,0,1); INSERT INTO `mdl_blocks` (`id`, `name`, `version`, `cron`, `lastcron`, `visible`) VALUES (3,'calendar_month',2004081200,0,0,1); INSERT INTO `mdl_blocks` (`id`, `name`, `version`, `cron`, `lastcron`, `visible`) VALUES (4,'calendar_upcoming',2004052600,0,0,1); INSERT INTO `mdl_blocks` (`id`, `name`, `version`, `cron`, `lastcron`, `visible`) VALUES (5,'course_list',2004081200,0,0,1); INSERT INTO `mdl_blocks` (`id`, `name`, `version`, `cron`, `lastcron`, `visible`) VALUES (6,'course_summary',2004052600,0,0,1); INSERT INTO `mdl_blocks` (`id`, `name`, `version`, `cron`, `lastcron`, `visible`) VALUES (7,'login',2004081600,0,0,1); INSERT INTO `mdl_blocks` (`id`, `name`, `version`, `cron`, `lastcron`, `visible`) VALUES (8,'news_items',2004052600,0,0,1); INSERT INTO `mdl_blocks` (`id`, `name`, `version`, `cron`, `lastcron`, `visible`) VALUES (9,'online_users',2004052700,0,0,1); INSERT INTO `mdl_blocks` (`id`, `name`, `version`, `cron`, `lastcron`, `visible`) VALUES (10,'participants',2004052600,0,0,1); INSERT INTO `mdl_blocks` (`id`, `name`, `version`, `cron`, `lastcron`, `visible`) VALUES (11,'recent_activity',2004042900,0,0,1); INSERT INTO `mdl_blocks` (`id`, `name`, `version`, `cron`, `lastcron`, `visible`) VALUES (12,'search_forums',2004041000,0,0,1); INSERT INTO `mdl_blocks` (`id`, `name`, `version`, `cron`, `lastcron`, `visible`) VALUES (13,'section_links',2004052800,0,0,1); INSERT INTO `mdl_blocks` (`id`, `name`, `version`, `cron`, `lastcron`, `visible`) VALUES (14,'site_main_menu',2004052700,0,0,1); INSERT INTO `mdl_blocks` (`id`, `name`, `version`, `cron`, `lastcron`, `visible`) VALUES (15,'social_activities',2004041800,0,0,1); -- -- Table structure for table `mdl_cache_filters` -- CREATE TABLE `mdl_cache_filters` ( `id` int(10) unsigned NOT NULL auto_increment, `filter` varchar(32) NOT NULL default '', `version` int(10) unsigned NOT NULL default '0', `md5key` varchar(32) NOT NULL default '', `rawtext` text NOT NULL, `timemodified` int(10) unsigned NOT NULL default '0', PRIMARY KEY (`id`), KEY `filtermd5key` (`filter`,`md5key`) ) TYPE=MyISAM COMMENT='For keeping information about cached data'; -- -- Dumping data for table `mdl_cache_filters` -- -- -- Table structure for table `mdl_cache_text` -- CREATE TABLE `mdl_cache_text` ( `id` int(10) unsigned NOT NULL auto_increment, `md5key` varchar(32) NOT NULL default '', `formattedtext` longtext NOT NULL, `timemodified` int(10) unsigned NOT NULL default '0', PRIMARY KEY (`id`), KEY `md5key` (`md5key`) ) TYPE=MyISAM COMMENT='For storing temporary copies of processed texts'; -- -- Dumping data for table `mdl_cache_text` -- -- -- Table structure for table `mdl_chat` -- CREATE TABLE `mdl_chat` ( `id` int(10) unsigned NOT NULL auto_increment, `course` int(10) unsigned NOT NULL default '0', `name` varchar(255) NOT NULL default '', `intro` text NOT NULL, `keepdays` int(11) NOT NULL default '0', `studentlogs` int(4) NOT NULL default '0', `chattime` int(10) unsigned NOT NULL default '0', `schedule` int(4) NOT NULL default '0', `timemodified` int(10) unsigned NOT NULL default '0', PRIMARY KEY (`id`) ) TYPE=MyISAM COMMENT='Each of these is a chat room'; -- -- Dumping data for table `mdl_chat` -- -- -- Table structure for table `mdl_chat_messages` -- CREATE TABLE `mdl_chat_messages` ( `id` int(10) unsigned NOT NULL auto_increment, `chatid` int(10) NOT NULL default '0', `userid` int(10) NOT NULL default '0', `groupid` int(10) NOT NULL default '0', `system` int(1) unsigned NOT NULL default '0', `message` text NOT NULL, `timestamp` int(10) unsigned NOT NULL default '0', PRIMARY KEY (`id`), KEY `timemodifiedchat` (`timestamp`,`chatid`) ) TYPE=MyISAM COMMENT='Stores all the actual chat messages'; -- -- Dumping data for table `mdl_chat_messages` -- -- -- Table structure for table `mdl_chat_users` -- CREATE TABLE `mdl_chat_users` ( `id` int(10) unsigned NOT NULL auto_increment, `chatid` int(11) NOT NULL default '0', `userid` int(11) NOT NULL default '0', `groupid` int(11) NOT NULL default '0', `version` varchar(16) NOT NULL default '', `ip` varchar(15) NOT NULL default '', `firstping` int(10) unsigned NOT NULL default '0', `lastping` int(10) unsigned NOT NULL default '0', `lastmessageping` int(10) unsigned NOT NULL default '0', `sid` varchar(32) NOT NULL default '', PRIMARY KEY (`id`), KEY `userid` (`userid`), KEY `lastping` (`lastping`) ) TYPE=MyISAM COMMENT='Keeps track of which users are in which chat rooms'; -- -- Dumping data for table `mdl_chat_users` -- -- -- Table structure for table `mdl_choice` -- CREATE TABLE `mdl_choice` ( `id` int(10) unsigned NOT NULL auto_increment, `course` int(10) unsigned NOT NULL default '0', `name` varchar(255) NOT NULL default '', `text` text NOT NULL, `format` tinyint(2) unsigned NOT NULL default '0', `answer1` varchar(255) NOT NULL default 'Yes', `answer2` varchar(255) NOT NULL default 'No', `answer3` varchar(255) default NULL, `answer4` varchar(255) default NULL, `answer5` varchar(255) default NULL, `answer6` varchar(255) default NULL, `publish` tinyint(2) unsigned NOT NULL default '0', `release` tinyint(2) unsigned NOT NULL default '0', `allowupdate` tinyint(2) unsigned NOT NULL default '0', `showunanswered` tinyint(2) unsigned NOT NULL default '0', `timeopen` int(10) unsigned NOT NULL default '0', `timeclose` int(10) unsigned NOT NULL default '0', `timemodified` int(10) unsigned NOT NULL default '0', PRIMARY KEY (`id`), UNIQUE KEY `id` (`id`) ) TYPE=MyISAM COMMENT='Available choices are stored here.'; -- -- Dumping data for table `mdl_choice` -- -- -- Table structure for table `mdl_choice_answers` -- CREATE TABLE `mdl_choice_answers` ( `id` int(10) unsigned NOT NULL auto_increment, `choice` int(10) unsigned NOT NULL default '0', `userid` int(10) unsigned NOT NULL default '0', `answer` tinyint(4) NOT NULL default '0', `timemodified` int(10) NOT NULL default '0', PRIMARY KEY (`id`), UNIQUE KEY `id` (`id`) ) TYPE=MyISAM; -- -- Dumping data for table `mdl_choice_answers` -- -- -- Table structure for table `mdl_config` -- CREATE TABLE `mdl_config` ( `id` int(10) unsigned NOT NULL auto_increment, `name` varchar(255) NOT NULL default '', `value` text NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `name` (`name`) ) TYPE=MyISAM COMMENT='Moodle configuration variables'; -- -- Dumping data for table `mdl_config` -- INSERT INTO `mdl_config` (`id`, `name`, `value`) VALUES (1,'locale','en'); INSERT INTO `mdl_config` (`id`, `name`, `value`) VALUES (2,'allowunenroll','1'); INSERT INTO `mdl_config` (`id`, `name`, `value`) VALUES (3,'allusersaresitestudents','1'); INSERT INTO `mdl_config` (`id`, `name`, `value`) VALUES (4,'auth','email'); INSERT INTO `mdl_config` (`id`, `name`, `value`) VALUES (5,'auth_pop3mailbox','INBOX'); INSERT INTO `mdl_config` (`id`, `name`, `value`) VALUES (6,'autologinguests','0'); INSERT INTO `mdl_config` (`id`, `name`, `value`) VALUES (7,'cachetext','60'); INSERT INTO `mdl_config` (`id`, `name`, `value`) VALUES (8,'changepassword','1'); INSERT INTO `mdl_config` (`id`, `name`, `value`) VALUES (9,'country','US'); INSERT INTO `mdl_config` (`id`, `name`, `value`) VALUES (10,'deleteunconfirmed','168'); INSERT INTO `mdl_config` (`id`, `name`, `value`) VALUES (11,'digestmailtime','8'); INSERT INTO `mdl_config` (`id`, `name`, `value`) VALUES (12,'displayloginfailures','admin'); INSERT INTO `mdl_config` (`id`, `name`, `value`) VALUES (13,'enablerssfeeds','1'); INSERT INTO `mdl_config` (`id`, `name`, `value`) VALUES (14,'extendedusernamechars','0'); INSERT INTO `mdl_config` (`id`, `name`, `value`) VALUES (15,'editorbackgroundcolor','#ffffff'); INSERT INTO `mdl_config` (`id`, `name`, `value`) VALUES (16,'editorfontfamily','Trebuchet MS,Verdana,Arial,Helvetica,sans-serif'); INSERT INTO `mdl_config` (`id`, `name`, `value`) VALUES (17,'editorfontsize',''); INSERT INTO `mdl_config` (`id`, `name`, `value`) VALUES (18,'editorkillword','1'); INSERT INTO `mdl_config` (`id`, `name`, `value`) VALUES (19,'editorspelling','0'); INSERT INTO `mdl_config` (`id`, `name`, `value`) VALUES (20,'editorfontlist','Trebuchet:Trebuchet MS,Verdana,Arial,Helvetica,sans-serif;Arial:arial,helvetica,sans-serif;Courier New:courier new,courier,monospace;Georgia:georgia,times new roman,times,serif;Tahoma:tahoma,arial,helvetica,sans-serif;Times New Roman:times new roman,times,serif;Verdana:verdana,arial,helvetica,sans-serif;Impact:impact;Wingdings:wingdings'); INSERT INTO `mdl_config` (`id`, `name`, `value`) VALUES (21,'filteruploadedfiles','1'); INSERT INTO `mdl_config` (`id`, `name`, `value`) VALUES (22,'forcelogin','0'); INSERT INTO `mdl_config` (`id`, `name`, `value`) VALUES (23,'forceloginforprofiles','0'); INSERT INTO `mdl_config` (`id`, `name`, `value`) VALUES (24,'fullnamedisplay','firstname'); INSERT INTO `mdl_config` (`id`, `name`, `value`) VALUES (25,'frontpage','0'); INSERT INTO `mdl_config` (`id`, `name`, `value`) VALUES (26,'gdversion','2'); INSERT INTO `mdl_config` (`id`, `name`, `value`) VALUES (27,'guestloginbutton','1'); INSERT INTO `mdl_config` (`id`, `name`, `value`) VALUES (28,'htmleditor','1'); INSERT INTO `mdl_config` (`id`, `name`, `value`) VALUES (29,'langmenu','1'); INSERT INTO `mdl_config` (`id`, `name`, `value`) VALUES (30,'langlist',''); INSERT INTO `mdl_config` (`id`, `name`, `value`) VALUES (31,'loginhttps','0'); INSERT INTO `mdl_config` (`id`, `name`, `value`) VALUES (32,'loglifetime','1000'); INSERT INTO `mdl_config` (`id`, `name`, `value`) VALUES (33,'longtimenosee','1000'); INSERT INTO `mdl_config` (`id`, `name`, `value`) VALUES (34,'maxbytes','52428800'); INSERT INTO `mdl_config` (`id`, `name`, `value`) VALUES (35,'maxeditingtime','1800'); INSERT INTO `mdl_config` (`id`, `name`, `value`) VALUES (36,'noreplyaddress','admin@avirtuouswoman.org'); INSERT INTO `mdl_config` (`id`, `name`, `value`) VALUES (37,'notifyloginfailures','mainadmin'); INSERT INTO `mdl_config` (`id`, `name`, `value`) VALUES (38,'notifyloginthreshold','10'); INSERT INTO `mdl_config` (`id`, `name`, `value`) VALUES (39,'opentogoogle','0'); INSERT INTO `mdl_config` (`id`, `name`, `value`) VALUES (40,'proxyhost',''); INSERT INTO `mdl_config` (`id`, `name`, `value`) VALUES (41,'proxyport',''); INSERT INTO `mdl_config` (`id`, `name`, `value`) VALUES (42,'secureforms','0'); INSERT INTO `mdl_config` (`id`, `name`, `value`) VALUES (43,'sessiontimeout','7200'); INSERT INTO `mdl_config` (`id`, `name`, `value`) VALUES (44,'showsiteparticipantslist','0'); INSERT INTO `mdl_config` (`id`, `name`, `value`) VALUES (45,'slasharguments','1'); INSERT INTO `mdl_config` (`id`, `name`, `value`) VALUES (46,'smtphosts',''); INSERT INTO `mdl_config` (`id`, `name`, `value`) VALUES (47,'smtppass',''); INSERT INTO `mdl_config` (`id`, `name`, `value`) VALUES (48,'smtpuser',''); INSERT INTO `mdl_config` (`id`, `name`, `value`) VALUES (49,'style','default'); INSERT INTO `mdl_config` (`id`, `name`, `value`) VALUES (50,'teacherassignteachers','0'); INSERT INTO `mdl_config` (`id`, `name`, `value`) VALUES (51,'template','default'); INSERT INTO `mdl_config` (`id`, `name`, `value`) VALUES (52,'textfilters','mod/glossary/dynalink.php'); INSERT INTO `mdl_config` (`id`, `name`, `value`) VALUES (53,'timezone','-5'); INSERT INTO `mdl_config` (`id`, `name`, `value`) VALUES (54,'unzip',''); INSERT INTO `mdl_config` (`id`, `name`, `value`) VALUES (55,'zip',''); INSERT INTO `mdl_config` (`id`, `name`, `value`) VALUES (56,'resource_framesize','130'); INSERT INTO `mdl_config` (`id`, `name`, `value`) VALUES (57,'resource_websearch','http://google.com/'); INSERT INTO `mdl_config` (`id`, `name`, `value`) VALUES (58,'resource_defaulturl','http://'); INSERT INTO `mdl_config` (`id`, `name`, `value`) VALUES (59,'resource_filterexternalpages',''); INSERT INTO `mdl_config` (`id`, `name`, `value`) VALUES (60,'resource_secretphrase','myguFuqr405bge2JS39C'); INSERT INTO `mdl_config` (`id`, `name`, `value`) VALUES (61,'resource_popup',''); INSERT INTO `mdl_config` (`id`, `name`, `value`) VALUES (62,'resource_windowsettings','0'); INSERT INTO `mdl_config` (`id`, `name`, `value`) VALUES (63,'resource_parametersettings','0'); INSERT INTO `mdl_config` (`id`, `name`, `value`) VALUES (64,'resource_popupresizable','checked'); INSERT INTO `mdl_config` (`id`, `name`, `value`) VALUES (65,'resource_popupscrollbars','checked'); INSERT INTO `mdl_config` (`id`, `name`, `value`) VALUES (66,'resource_popupdirectories','checked'); INSERT INTO `mdl_config` (`id`, `name`, `value`) VALUES (67,'resource_popuplocation','checked'); INSERT INTO `mdl_config` (`id`, `name`, `value`) VALUES (68,'resource_popupmenubar','checked'); INSERT INTO `mdl_config` (`id`, `name`, `value`) VALUES (69,'resource_popuptoolbar','checked'); INSERT INTO `mdl_config` (`id`, `name`, `value`) VALUES (70,'resource_popupstatus','checked'); INSERT INTO `mdl_config` (`id`, `name`, `value`) VALUES (71,'resource_popupheight','450'); INSERT INTO `mdl_config` (`id`, `name`, `value`) VALUES (72,'resource_popupwidth','620'); INSERT INTO `mdl_config` (`id`, `name`, `value`) VALUES (73,'forum_displaymode','3'); INSERT INTO `mdl_config` (`id`, `name`, `value`) VALUES (74,'forum_shortpost','300'); INSERT INTO `mdl_config` (`id`, `name`, `value`) VALUES (75,'forum_longpost','600'); INSERT INTO `mdl_config` (`id`, `name`, `value`) VALUES (76,'forum_manydiscussions','10'); INSERT INTO `mdl_config` (`id`, `name`, `value`) VALUES (77,'forum_maxbytes','512000'); INSERT INTO `mdl_config` (`id`, `name`, `value`) VALUES (78,'forum_replytouser','1'); INSERT INTO `mdl_config` (`id`, `name`, `value`) VALUES (79,'lang','en'); INSERT INTO `mdl_config` (`id`, `name`, `value`) VALUES (80,'sessioncookie',''); INSERT INTO `mdl_config` (`id`, `name`, `value`) VALUES (81,'debug','7'); INSERT INTO `mdl_config` (`id`, `name`, `value`) VALUES (82,'framename','_top'); INSERT INTO `mdl_config` (`id`, `name`, `value`) VALUES (83,'version','2004083101'); INSERT INTO `mdl_config` (`id`, `name`, `value`) VALUES (84,'release','1.4.1'); INSERT INTO `mdl_config` (`id`, `name`, `value`) VALUES (85,'backup_version','2004083100'); INSERT INTO `mdl_config` (`id`, `name`, `value`) VALUES (86,'backup_release','1.4'); INSERT INTO `mdl_config` (`id`, `name`, `value`) VALUES (87,'blocks_version','2004052700'); INSERT INTO `mdl_config` (`id`, `name`, `value`) VALUES (88,'enrol_paypal_version','2004081800'); INSERT INTO `mdl_config` (`id`, `name`, `value`) VALUES (89,'assignment_maxbytes','1024000'); INSERT INTO `mdl_config` (`id`, `name`, `value`) VALUES (90,'chat_refresh_room','5'); INSERT INTO `mdl_config` (`id`, `name`, `value`) VALUES (91,'chat_refresh_userlist','10'); INSERT INTO `mdl_config` (`id`, `name`, `value`) VALUES (92,'chat_old_ping','35'); INSERT INTO `mdl_config` (`id`, `name`, `value`) VALUES (93,'chat_method','header_js'); INSERT INTO `mdl_config` (`id`, `name`, `value`) VALUES (94,'chat_serverhost',''); INSERT INTO `mdl_config` (`id`, `name`, `value`) VALUES (95,'chat_serverip',''); INSERT INTO `mdl_config` (`id`, `name`, `value`) VALUES (96,'chat_serverport','9111'); INSERT INTO `mdl_config` (`id`, `name`, `value`) VALUES (97,'chat_servermax','100'); INSERT INTO `mdl_config` (`id`, `name`, `value`) VALUES (98,'glossary_studentspost','1'); INSERT INTO `mdl_config` (`id`, `name`, `value`) VALUES (99,'glossary_dupentries','0'); INSERT INTO `mdl_config` (`id`, `name`, `value`) VALUES (100,'glossary_allowcomments','0'); INSERT INTO `mdl_config` (`id`, `name`, `value`) VALUES (101,'glossary_linkbydefault','1'); INSERT INTO `mdl_config` (`id`, `name`, `value`) VALUES (102,'glossary_defaultapproval','1'); INSERT INTO `mdl_config` (`id`, `name`, `value`) VALUES (103,'glossary_entbypage','10'); INSERT INTO `mdl_config` (`id`, `name`, `value`) VALUES (104,'journal_showrecentactivity','1'); INSERT INTO `mdl_config` (`id`, `name`, `value`) VALUES (105,'scorm_popup',''); INSERT INTO `mdl_config` (`id`, `name`, `value`) VALUES (106,'scorm_validate','none'); INSERT INTO `mdl_config` (`id`, `name`, `value`) VALUES (107,'scorm_popupresizable','checked'); INSERT INTO `mdl_config` (`id`, `name`, `value`) VALUES (108,'scorm_popupscrollbars','checked'); INSERT INTO `mdl_config` (`id`, `name`, `value`) VALUES (109,'scorm_popupstatus','checked'); INSERT INTO `mdl_config` (`id`, `name`, `value`) VALUES (110,'scorm_popupheight','450'); INSERT INTO `mdl_config` (`id`, `name`, `value`) VALUES (111,'scorm_popupwidth','620'); INSERT INTO `mdl_config` (`id`, `name`, `value`) VALUES (112,'scorm_framesize','140'); INSERT INTO `mdl_config` (`id`, `name`, `value`) VALUES (113,'digestmailtimelast','1103547606'); INSERT INTO `mdl_config` (`id`, `name`, `value`) VALUES (114,'theme','oceanblue'); INSERT INTO `mdl_config` (`id`, `name`, `value`) VALUES (115,'forum_enablerssfeeds','0'); -- -- Table structure for table `mdl_course` -- CREATE TABLE `mdl_course` ( `id` int(10) unsigned NOT NULL auto_increment, `category` int(10) unsigned NOT NULL default '0', `sortorder` int(10) unsigned NOT NULL default '0', `password` varchar(50) NOT NULL default '', `fullname` varchar(254) NOT NULL default '', `shortname` varchar(15) NOT NULL default '', `idnumber` varchar(50) NOT NULL default '', `summary` text NOT NULL, `format` varchar(10) NOT NULL default 'topics', `showgrades` smallint(2) unsigned NOT NULL default '1', `modinfo` longtext NOT NULL, `blockinfo` varchar(255) NOT NULL default '', `newsitems` smallint(5) unsigned NOT NULL default '1', `teacher` varchar(100) NOT NULL default 'Teacher', `teachers` varchar(100) NOT NULL default 'Teachers', `student` varchar(100) NOT NULL default 'Student', `students` varchar(100) NOT NULL default 'Students', `guest` tinyint(2) unsigned NOT NULL default '0', `startdate` int(10) unsigned NOT NULL default '0', `enrolperiod` int(10) unsigned NOT NULL default '0', `numsections` smallint(5) unsigned NOT NULL default '1', `marker` int(10) unsigned NOT NULL default '0', `maxbytes` int(10) unsigned NOT NULL default '0', `showreports` int(4) unsigned NOT NULL default '0', `visible` int(1) unsigned NOT NULL default '1', `hiddensections` int(2) unsigned NOT NULL default '0', `groupmode` int(4) unsigned NOT NULL default '0', `groupmodeforce` int(4) unsigned NOT NULL default '0', `lang` varchar(10) NOT NULL default '', `cost` varchar(10) NOT NULL default '', `timecreated` int(10) unsigned NOT NULL default '0', `timemodified` int(10) unsigned NOT NULL default '0', PRIMARY KEY (`id`), KEY `category` (`category`) ) TYPE=MyISAM; -- -- Dumping data for table `mdl_course` -- INSERT INTO `mdl_course` (`id`, `category`, `sortorder`, `password`, `fullname`, `shortname`, `idnumber`, `summary`, `format`, `showgrades`, `modinfo`, `blockinfo`, `newsitems`, `teacher`, `teachers`, `student`, `students`, `guest`, `startdate`, `enrolperiod`, `numsections`, `marker`, `maxbytes`, `showreports`, `visible`, `hiddensections`, `groupmode`, `groupmodeforce`, `lang`, `cost`, `timecreated`, `timemodified`) VALUES (1,0,0,'','A Virtuous Woman','Home','','

Welcome to A Virtuous Woman

So many women today were not taught how to run a household efficently while in the care of their mothers. God gives guidelines for how a virtuous woman lives. Proverbs 31 is an empowering look at the role of women. Not only is a virtuous woman righteous in the Lord, but she is a loving wife and mother, a smart shopper, a seamstress, a gardener, a good housekeeper, a savvy business woman, and trains her children with wisdom. Her husband appreciates her and can praise her to his associates and friends because she is worthy of praise. Is this attainable for the average Christian woman? Absolutely! All things are possible through Christ. With prayer and study and a little know how, we can all be "Proverbs 31 women."

\"The

Featured:

Correction Please! by Melissa Ringstaff, Director

A virtuous woman is kind and good. She shows her husband love and respect through her words and actions. Proverbs 31 tells us that a virtuous woman has the law of kindness on her tongue and that she is good to her husband all the days of her life. How do you treat your husband?

Criticism can destroy a man’s dignity. When a wife corrects her husband in public, he feels hurt, betrayed and even angry. He feels less of a man. It is important for a wife to show this simple form of respect for her husband. A virtuous woman, or godly wife, is good to her husband. I have known many women who make it a point to correct their husband in public, especially when he is telling a story.   For the most part, the details are unimportant to the context of what is being said.  If it does not matter, why bring him down by correcting him? 

Allow your husband the freedom of telling a story, describing an event, or giving information without fearing criticism. For the benefit of your marriage, allow mistakes that matter little, and know that even you are not always perfect. How would you feel if every time you opened your mouth, your husband pointed out every wrong detail?

Announcements:

Announcing!! our new print publication A Woman of Worth! This "little magazine" is a monthly newsletter that is filled with articles, recipes, household hints, inspiring ideas and more! Subscribe today!


Join our Proverbs 31 Club Mailing List for updates and more information!

We have now upgraded our discussion board! It is brand new so come join us as we make new friends! I think you will like the new design!

Email Services now available! Get your own free email account - yourname@avirtuouswoman.org - today! Login and New User Sign Up located above on left side.

NEW! Listen to Life Talk Christian Radio while you browse the site or internet. Just click on the link above right side. Enjoy!

Now we are accepting credit cards in our bookstore and for donations!

Now you can purchase A Virtuous Woman merchandise and help support our ministry!

In the Kitchen:\"Cheese

Our recipe section is growing! New recipes include these easy     to make Cheese Garlic Biscuits! If you have a great recipe you   would like to submit for consideration, please fill out the form on our submission page. Thank you!

What our readers are saying:

Just browsing through my new found "treasure" chest, and I found your household notebook. I love it! It\'s so nice to read detailed cleaning lists, so that I have something to compare to. Usually I wouldn\'t recommend "comparing" but when you don\'t know what "normal" homes look like, you don\'t know what to aim for!
- Michelle

I just wanted to say directly that your site is a resource that is changing my life. Please continue to build so that the articles not yet available will be! I have never found a resource with such practical application and have always felt like these are things that "a woman just knows", but the truth is I needed it all. Even the simplicity of how to clean a kitchen and bathroom. I just was not taught and had no clue! Thank you, thank you, thank you. Please keep the information coming!
- Devyna

I love your chores and checklist! I recently became a stay at home mom and it is a lot harder than I thought it would be. Your checklist helped me to reorganize and get my house back on track. Thank you very much!
- Aliceson

I love this site. I needed this information at this time in my life. The Lord is helping me to grow and become a virtuous woman. I am also learning how to teach my children to become virtuous women. Thank you for all of the wonderful resources that I am finding through your pages here.
- Trina

DISCLAIMER: All information contained on this website is for imformation only. It is not intended to take the place of professional advice from a medical, mental, or legal professional. All links contained on this site have been preveiwed, but are not guaranteed. Although we choose each link for appropriateness, we do not necessarily endorse or agree with all the information contained there within.

Advertising Rates and Information | Some images have been used from: Free Images

','social',1,'a:1:{i:1;O:8:\"stdClass\":6:{s:2:\"cm\";s:1:\"1\";s:3:\"mod\";s:5:\"forum\";s:7:\"section\";s:1:\"0\";s:4:\"name\";s:9:\"Site+news\";s:7:\"visible\";s:1:\"1\";s:5:\"extra\";s:0:\"\";}}','14,2,8,9,3,12:6,',0,'Director','Staff','Member','Members',0,0,0,0,0,0,0,1,0,0,0,'','',0,1102443160); -- -- Table structure for table `mdl_course_categories` -- CREATE TABLE `mdl_course_categories` ( `id` int(10) unsigned NOT NULL auto_increment, `name` varchar(255) NOT NULL default '', `description` text NOT NULL, `parent` int(10) unsigned NOT NULL default '0', `sortorder` int(10) unsigned NOT NULL default '0', `coursecount` int(10) unsigned NOT NULL default '0', `visible` tinyint(1) NOT NULL default '1', `timemodified` int(10) unsigned NOT NULL default '0', PRIMARY KEY (`id`), UNIQUE KEY `id` (`id`) ) TYPE=MyISAM COMMENT='Course categories'; -- -- Dumping data for table `mdl_course_categories` -- INSERT INTO `mdl_course_categories` (`id`, `name`, `description`, `parent`, `sortorder`, `coursecount`, `visible`, `timemodified`) VALUES (1,'Miscellaneous','',0,0,0,1,0); -- -- Table structure for table `mdl_course_display` -- CREATE TABLE `mdl_course_display` ( `id` int(10) unsigned NOT NULL auto_increment, `course` int(10) unsigned NOT NULL default '0', `userid` int(10) unsigned NOT NULL default '0', `display` int(10) NOT NULL default '0', PRIMARY KEY (`id`), UNIQUE KEY `id` (`id`), KEY `courseuserid` (`course`,`userid`) ) TYPE=MyISAM COMMENT='Stores info about how to display the course'; -- -- Dumping data for table `mdl_course_display` -- -- -- Table structure for table `mdl_course_modules` -- CREATE TABLE `mdl_course_modules` ( `id` int(10) unsigned NOT NULL auto_increment, `course` int(10) unsigned NOT NULL default '0', `module` int(10) unsigned NOT NULL default '0', `instance` int(10) unsigned NOT NULL default '0', `section` int(10) unsigned NOT NULL default '0', `added` int(10) unsigned NOT NULL default '0', `deleted` tinyint(1) unsigned NOT NULL default '0', `score` tinyint(4) NOT NULL default '0', `indent` int(5) unsigned NOT NULL default '0', `visible` tinyint(1) NOT NULL default '1', `groupmode` tinyint(4) NOT NULL default '0', PRIMARY KEY (`id`), UNIQUE KEY `id` (`id`) ) TYPE=MyISAM; -- -- Dumping data for table `mdl_course_modules` -- INSERT INTO `mdl_course_modules` (`id`, `course`, `module`, `instance`, `section`, `added`, `deleted`, `score`, `indent`, `visible`, `groupmode`) VALUES (1,1,4,1,1,1095067846,0,0,0,1,0); -- -- Table structure for table `mdl_course_sections` -- CREATE TABLE `mdl_course_sections` ( `id` int(10) unsigned NOT NULL auto_increment, `course` int(10) unsigned NOT NULL default '0', `section` int(10) unsigned NOT NULL default '0', `summary` text NOT NULL, `sequence` text NOT NULL, `visible` tinyint(1) NOT NULL default '1', PRIMARY KEY (`id`), KEY `coursesection` (`course`,`section`) ) TYPE=MyISAM; -- -- Dumping data for table `mdl_course_sections` -- INSERT INTO `mdl_course_sections` (`id`, `course`, `section`, `summary`, `sequence`, `visible`) VALUES (1,1,0,'','1',1); INSERT INTO `mdl_course_sections` (`id`, `course`, `section`, `summary`, `sequence`, `visible`) VALUES (2,1,1,'','',1); -- -- Table structure for table `mdl_enrol_paypal` -- CREATE TABLE `mdl_enrol_paypal` ( `id` int(10) unsigned NOT NULL auto_increment, `business` varchar(255) NOT NULL default '', `receiver_email` varchar(255) NOT NULL default '', `receiver_id` varchar(255) NOT NULL default '', `item_name` varchar(255) NOT NULL default '', `courseid` int(10) unsigned NOT NULL default '0', `userid` int(10) unsigned NOT NULL default '0', `memo` varchar(255) NOT NULL default '', `tax` varchar(255) NOT NULL default '', `option_name1` varchar(255) NOT NULL default '', `option_selection1_x` varchar(255) NOT NULL default '', `option_name2` varchar(255) NOT NULL default '', `option_selection2_x` varchar(255) NOT NULL default '', `payment_status` varchar(255) NOT NULL default '', `pending_reason` varchar(255) NOT NULL default '', `reason_code` varchar(30) NOT NULL default '', `txn_id` varchar(255) NOT NULL default '', `parent_txn_id` varchar(255) NOT NULL default '', `payment_type` varchar(30) NOT NULL default '', `timeupdated` int(10) unsigned NOT NULL default '0', PRIMARY KEY (`id`) ) TYPE=MyISAM COMMENT='Holds all known information about Paypal transactions'; -- -- Dumping data for table `mdl_enrol_paypal` -- -- -- Table structure for table `mdl_event` -- CREATE TABLE `mdl_event` ( `id` int(10) unsigned NOT NULL auto_increment, `name` varchar(255) NOT NULL default '', `description` text NOT NULL, `format` int(4) unsigned NOT NULL default '0', `courseid` int(10) unsigned NOT NULL default '0', `groupid` int(10) unsigned NOT NULL default '0', `userid` int(10) unsigned NOT NULL default '0', `modulename` varchar(20) NOT NULL default '', `instance` int(10) unsigned NOT NULL default '0', `eventtype` varchar(20) NOT NULL default '', `timestart` int(10) unsigned NOT NULL default '0', `timeduration` int(10) unsigned NOT NULL default '0', `visible` tinyint(4) NOT NULL default '1', `timemodified` int(10) unsigned NOT NULL default '0', PRIMARY KEY (`id`), UNIQUE KEY `id` (`id`), KEY `courseid` (`courseid`), KEY `userid` (`userid`) ) TYPE=MyISAM COMMENT='For everything with a time associated to it'; -- -- Dumping data for table `mdl_event` -- -- -- Table structure for table `mdl_forum` -- CREATE TABLE `mdl_forum` ( `id` int(10) unsigned NOT NULL auto_increment, `course` int(10) unsigned NOT NULL default '0', `type` enum('single','news','general','social','eachuser','teacher') NOT NULL default 'general', `name` varchar(255) NOT NULL default '', `intro` text NOT NULL, `open` tinyint(2) unsigned NOT NULL default '2', `assessed` int(10) unsigned NOT NULL default '0', `assesspublic` int(4) unsigned NOT NULL default '0', `assesstimestart` int(10) unsigned NOT NULL default '0', `assesstimefinish` int(10) unsigned NOT NULL default '0', `scale` int(10) NOT NULL default '0', `maxbytes` int(10) unsigned NOT NULL default '0', `forcesubscribe` tinyint(1) unsigned NOT NULL default '0', `rsstype` tinyint(2) unsigned NOT NULL default '0', `rssarticles` tinyint(2) unsigned NOT NULL default '0', `timemodified` int(10) unsigned NOT NULL default '0', PRIMARY KEY (`id`), UNIQUE KEY `id` (`id`) ) TYPE=MyISAM COMMENT='Forums contain and structure discussion'; -- -- Dumping data for table `mdl_forum` -- INSERT INTO `mdl_forum` (`id`, `course`, `type`, `name`, `intro`, `open`, `assessed`, `assesspublic`, `assesstimestart`, `assesstimefinish`, `scale`, `maxbytes`, `forcesubscribe`, `rsstype`, `rssarticles`, `timemodified`) VALUES (1,1,'news','Site news','General news and announcements',1,0,0,0,0,0,0,0,0,0,1095067846); -- -- Table structure for table `mdl_forum_discussions` -- CREATE TABLE `mdl_forum_discussions` ( `id` int(10) unsigned NOT NULL auto_increment, `course` int(10) unsigned NOT NULL default '0', `forum` int(10) unsigned NOT NULL default '0', `name` varchar(255) NOT NULL default '', `firstpost` int(10) unsigned NOT NULL default '0', `userid` int(10) unsigned NOT NULL default '0', `groupid` int(10) NOT NULL default '-1', `assessed` tinyint(1) NOT NULL default '1', `timemodified` int(10) unsigned NOT NULL default '0', `usermodified` int(10) unsigned NOT NULL default '0', PRIMARY KEY (`id`) ) TYPE=MyISAM COMMENT='Forums are composed of discussions'; -- -- Dumping data for table `mdl_forum_discussions` -- -- -- Table structure for table `mdl_forum_posts` -- CREATE TABLE `mdl_forum_posts` ( `id` int(10) unsigned NOT NULL auto_increment, `discussion` int(10) unsigned NOT NULL default '0', `parent` int(10) unsigned NOT NULL default '0', `userid` int(10) unsigned NOT NULL default '0', `created` int(10) unsigned NOT NULL default '0', `modified` int(10) unsigned NOT NULL default '0', `mailed` tinyint(2) unsigned NOT NULL default '0', `subject` varchar(255) NOT NULL default '', `message` text NOT NULL, `format` tinyint(2) NOT NULL default '0', `attachment` varchar(100) NOT NULL default '', `totalscore` tinyint(4) NOT NULL default '0', PRIMARY KEY (`id`) ) TYPE=MyISAM COMMENT='All posts are stored in this table'; -- -- Dumping data for table `mdl_forum_posts` -- -- -- Table structure for table `mdl_forum_queue` -- CREATE TABLE `mdl_forum_queue` ( `id` int(10) unsigned NOT NULL auto_increment, `userid` int(10) unsigned NOT NULL default '0', `discussionid` int(10) unsigned NOT NULL default '0', `postid` int(10) unsigned NOT NULL default '0', PRIMARY KEY (`id`), KEY `user` (`userid`), KEY `post` (`postid`) ) TYPE=MyISAM COMMENT='For keeping track of posts that will be mailed in digest for'; -- -- Dumping data for table `mdl_forum_queue` -- -- -- Table structure for table `mdl_forum_ratings` -- CREATE TABLE `mdl_forum_ratings` ( `id` int(10) unsigned NOT NULL auto_increment, `userid` int(10) unsigned NOT NULL default '0', `post` int(10) unsigned NOT NULL default '0', `time` int(10) unsigned NOT NULL default '0', `rating` tinyint(4) NOT NULL default '0', PRIMARY KEY (`id`) ) TYPE=MyISAM COMMENT='Contains user ratings for individual posts'; -- -- Dumping data for table `mdl_forum_ratings` -- -- -- Table structure for table `mdl_forum_subscriptions` -- CREATE TABLE `mdl_forum_subscriptions` ( `id` int(10) unsigned NOT NULL auto_increment, `userid` int(10) unsigned NOT NULL default '0', `forum` int(10) unsigned NOT NULL default '0', PRIMARY KEY (`id`), UNIQUE KEY `id` (`id`) ) TYPE=MyISAM COMMENT='Keeps track of who is subscribed to what forum'; -- -- Dumping data for table `mdl_forum_subscriptions` -- -- -- Table structure for table `mdl_glossary` -- CREATE TABLE `mdl_glossary` ( `id` int(10) unsigned NOT NULL auto_increment, `course` int(10) unsigned NOT NULL default '0', `name` varchar(255) NOT NULL default '', `intro` text NOT NULL, `studentcanpost` tinyint(2) unsigned NOT NULL default '0', `allowduplicatedentries` tinyint(2) unsigned NOT NULL default '0', `displayformat` varchar(50) NOT NULL default 'dictionary', `mainglossary` tinyint(2) unsigned NOT NULL default '0', `showspecial` tinyint(2) unsigned NOT NULL default '1', `showalphabet` tinyint(2) unsigned NOT NULL default '1', `showall` tinyint(2) unsigned NOT NULL default '1', `allowcomments` tinyint(2) unsigned NOT NULL default '0', `usedynalink` tinyint(2) unsigned NOT NULL default '1', `defaultapproval` tinyint(2) unsigned NOT NULL default '1', `globalglossary` tinyint(2) unsigned NOT NULL default '0', `entbypage` tinyint(3) unsigned NOT NULL default '10', `editalways` tinyint(2) unsigned NOT NULL default '0', `rsstype` tinyint(2) unsigned NOT NULL default '0', `rssarticles` tinyint(2) unsigned NOT NULL default '0', `assessed` int(10) unsigned NOT NULL default '0', `assesstimestart` int(10) unsigned NOT NULL default '0', `assesstimefinish` int(10) unsigned NOT NULL default '0', `scale` int(10) NOT NULL default '0', `timecreated` int(10) unsigned NOT NULL default '0', `timemodified` int(10) unsigned NOT NULL default '0', PRIMARY KEY (`id`) ) TYPE=MyISAM COMMENT='all glossaries'; -- -- Dumping data for table `mdl_glossary` -- -- -- Table structure for table `mdl_glossary_alias` -- CREATE TABLE `mdl_glossary_alias` ( `id` int(10) unsigned NOT NULL auto_increment, `entryid` int(10) unsigned NOT NULL default '0', `alias` varchar(255) NOT NULL default '', PRIMARY KEY (`id`) ) TYPE=MyISAM COMMENT='entries alias'; -- -- Dumping data for table `mdl_glossary_alias` -- -- -- Table structure for table `mdl_glossary_categories` -- CREATE TABLE `mdl_glossary_categories` ( `id` int(10) unsigned NOT NULL auto_increment, `glossaryid` int(10) unsigned NOT NULL default '0', `name` varchar(255) NOT NULL default '', `usedynalink` tinyint(2) unsigned NOT NULL default '1', PRIMARY KEY (`id`) ) TYPE=MyISAM COMMENT='all categories for glossary entries'; -- -- Dumping data for table `mdl_glossary_categories` -- -- -- Table structure for table `mdl_glossary_comments` -- CREATE TABLE `mdl_glossary_comments` ( `id` int(10) unsigned NOT NULL auto_increment, `entryid` int(10) unsigned NOT NULL default '0', `userid` int(10) unsigned NOT NULL default '0', `comment` text NOT NULL, `format` tinyint(2) unsigned NOT NULL default '0', `timemodified` int(10) unsigned NOT NULL default '0', PRIMARY KEY (`id`) ) TYPE=MyISAM COMMENT='comments on glossary entries'; -- -- Dumping data for table `mdl_glossary_comments` -- -- -- Table structure for table `mdl_glossary_entries` -- CREATE TABLE `mdl_glossary_entries` ( `id` int(10) unsigned NOT NULL auto_increment, `glossaryid` int(10) unsigned NOT NULL default '0', `userid` int(10) unsigned NOT NULL default '0', `concept` varchar(255) NOT NULL default '', `definition` text NOT NULL, `format` tinyint(2) unsigned NOT NULL default '0', `attachment` varchar(100) NOT NULL default '', `timecreated` int(10) unsigned NOT NULL default '0', `timemodified` int(10) unsigned NOT NULL default '0', `teacherentry` tinyint(2) unsigned NOT NULL default '0', `sourceglossaryid` int(10) unsigned NOT NULL default '0', `usedynalink` tinyint(2) unsigned NOT NULL default '1', `casesensitive` tinyint(2) unsigned NOT NULL default '0', `fullmatch` tinyint(2) unsigned NOT NULL default '1', `approved` tinyint(2) unsigned NOT NULL default '1', PRIMARY KEY (`id`) ) TYPE=MyISAM COMMENT='all glossary entries'; -- -- Dumping data for table `mdl_glossary_entries` -- -- -- Table structure for table `mdl_glossary_entries_categories` -- CREATE TABLE `mdl_glossary_entries_categories` ( `id` int(10) unsigned NOT NULL auto_increment, `categoryid` int(10) unsigned NOT NULL default '0', `entryid` int(10) unsigned NOT NULL default '0', PRIMARY KEY (`id`) ) TYPE=MyISAM COMMENT='categories of each glossary entry'; -- -- Dumping data for table `mdl_glossary_entries_categories` -- -- -- Table structure for table `mdl_glossary_formats` -- CREATE TABLE `mdl_glossary_formats` ( `id` int(10) unsigned NOT NULL auto_increment, `name` varchar(50) NOT NULL default '', `popupformatname` varchar(50) NOT NULL default '', `visible` tinyint(2) unsigned NOT NULL default '1', `showgroup` tinyint(2) unsigned NOT NULL default '1', `defaultmode` varchar(50) NOT NULL default '', `defaulthook` varchar(50) NOT NULL default '', `sortkey` varchar(50) NOT NULL default '', `sortorder` varchar(50) NOT NULL default '', PRIMARY KEY (`id`) ) TYPE=MyISAM COMMENT='Setting of the display formats'; -- -- Dumping data for table `mdl_glossary_formats` -- -- -- Table structure for table `mdl_glossary_ratings` -- CREATE TABLE `mdl_glossary_ratings` ( `id` int(10) unsigned NOT NULL auto_increment, `userid` int(10) unsigned NOT NULL default '0', `entryid` int(10) unsigned NOT NULL default '0', `time` int(10) unsigned NOT NULL default '0', `rating` tinyint(4) NOT NULL default '0', PRIMARY KEY (`id`) ) TYPE=MyISAM COMMENT='Contains user ratings for entries'; -- -- Dumping data for table `mdl_glossary_ratings` -- -- -- Table structure for table `mdl_groups` -- CREATE TABLE `mdl_groups` ( `id` int(10) unsigned NOT NULL auto_increment, `courseid` int(10) unsigned NOT NULL default '0', `name` varchar(254) NOT NULL default '', `description` text NOT NULL, `lang` varchar(10) NOT NULL default 'en', `picture` int(10) unsigned NOT NULL default '0', `hidepicture` int(2) unsigned NOT NULL default '0', `timecreated` int(10) unsigned NOT NULL default '0', `timemodified` int(10) unsigned NOT NULL default '0', PRIMARY KEY (`id`), UNIQUE KEY `id` (`id`), KEY `courseid` (`courseid`) ) TYPE=MyISAM COMMENT='Each record is a group in a course.'; -- -- Dumping data for table `mdl_groups` -- -- -- Table structure for table `mdl_groups_members` -- CREATE TABLE `mdl_groups_members` ( `id` int(10) unsigned NOT NULL auto_increment, `groupid` int(10) unsigned NOT NULL default '0', `userid` int(10) unsigned NOT NULL default '0', `timeadded` int(10) unsigned NOT NULL default '0', PRIMARY KEY (`id`), UNIQUE KEY `id` (`id`), KEY `groupid` (`groupid`) ) TYPE=MyISAM COMMENT='Lists memberships of users to groups'; -- -- Dumping data for table `mdl_groups_members` -- -- -- Table structure for table `mdl_journal` -- CREATE TABLE `mdl_journal` ( `id` int(10) unsigned NOT NULL auto_increment, `course` int(10) unsigned NOT NULL default '0', `name` varchar(255) default NULL, `intro` text, `introformat` tinyint(2) NOT NULL default '0', `days` smallint(5) unsigned NOT NULL default '7', `assessed` int(10) NOT NULL default '0', `timemodified` int(10) unsigned NOT NULL default '0', PRIMARY KEY (`id`) ) TYPE=MyISAM; -- -- Dumping data for table `mdl_journal` -- -- -- Table structure for table `mdl_journal_entries` -- CREATE TABLE `mdl_journal_entries` ( `id` int(10) unsigned NOT NULL auto_increment, `journal` int(10) unsigned NOT NULL default '0', `userid` int(10) unsigned NOT NULL default '0', `modified` int(10) unsigned NOT NULL default '0', `text` text NOT NULL, `format` tinyint(2) NOT NULL default '0', `rating` int(10) default '0', `comment` text, `teacher` int(10) unsigned NOT NULL default '0', `timemarked` int(10) unsigned NOT NULL default '0', `mailed` int(1) unsigned NOT NULL default '0', PRIMARY KEY (`id`) ) TYPE=MyISAM COMMENT='All the journal entries of all people'; -- -- Dumping data for table `mdl_journal_entries` -- -- -- Table structure for table `mdl_label` -- CREATE TABLE `mdl_label` ( `id` int(10) unsigned NOT NULL auto_increment, `course` int(10) unsigned NOT NULL default '0', `name` varchar(255) NOT NULL default '', `content` text NOT NULL, `timemodified` int(10) unsigned NOT NULL default '0', PRIMARY KEY (`id`) ) TYPE=MyISAM COMMENT='Defines labels'; -- -- Dumping data for table `mdl_label` -- -- -- Table structure for table `mdl_lesson` -- CREATE TABLE `mdl_lesson` ( `id` int(10) unsigned NOT NULL auto_increment, `course` int(10) unsigned NOT NULL default '0', `name` varchar(255) NOT NULL default '', `grade` tinyint(3) NOT NULL default '0', `usemaxgrade` tinyint(3) NOT NULL default '0', `maxanswers` int(3) unsigned NOT NULL default '4', `maxattempts` int(3) unsigned NOT NULL default '5', `nextpagedefault` int(3) unsigned NOT NULL default '0', `minquestions` int(3) unsigned NOT NULL default '0', `maxpages` int(3) unsigned NOT NULL default '0', `retake` int(3) unsigned NOT NULL default '1', `available` int(10) unsigned NOT NULL default '0', `deadline` int(10) unsigned NOT NULL default '0', `timemodified` int(10) unsigned NOT NULL default '0', PRIMARY KEY (`id`) ) TYPE=MyISAM COMMENT='Defines lesson'; -- -- Dumping data for table `mdl_lesson` -- -- -- Table structure for table `mdl_lesson_answers` -- CREATE TABLE `mdl_lesson_answers` ( `id` int(10) unsigned NOT NULL auto_increment, `lessonid` int(10) unsigned NOT NULL default '0', `pageid` int(10) unsigned NOT NULL default '0', `jumpto` int(11) NOT NULL default '0', `grade` tinyint(3) unsigned NOT NULL default '0', `flags` tinyint(3) unsigned NOT NULL default '0', `timecreated` int(10) unsigned NOT NULL default '0', `timemodified` int(10) unsigned NOT NULL default '0', `answer` text NOT NULL, `response` text NOT NULL, PRIMARY KEY (`id`), KEY `pageid` (`pageid`) ) TYPE=MyISAM COMMENT='Defines lesson_answers'; -- -- Dumping data for table `mdl_lesson_answers` -- -- -- Table structure for table `mdl_lesson_attempts` -- CREATE TABLE `mdl_lesson_attempts` ( `id` int(10) unsigned NOT NULL auto_increment, `lessonid` int(10) unsigned NOT NULL default '0', `pageid` int(10) unsigned NOT NULL default '0', `userid` int(10) unsigned NOT NULL default '0', `answerid` int(10) unsigned NOT NULL default '0', `retry` int(3) unsigned NOT NULL default '0', `correct` int(10) unsigned NOT NULL default '0', `timeseen` int(10) unsigned NOT NULL default '0', PRIMARY KEY (`id`), KEY `userid` (`userid`) ) TYPE=MyISAM COMMENT='Defines lesson_attempts'; -- -- Dumping data for table `mdl_lesson_attempts` -- -- -- Table structure for table `mdl_lesson_grades` -- CREATE TABLE `mdl_lesson_grades` ( `id` int(10) unsigned NOT NULL auto_increment, `lessonid` int(10) unsigned NOT NULL default '0', `userid` int(10) unsigned NOT NULL default '0', `grade` int(3) unsigned NOT NULL default '0', `late` int(3) unsigned NOT NULL default '0', `completed` int(10) unsigned NOT NULL default '0', PRIMARY KEY (`id`) ) TYPE=MyISAM COMMENT='Defines lesson_grades'; -- -- Dumping data for table `mdl_lesson_grades` -- -- -- Table structure for table `mdl_lesson_pages` -- CREATE TABLE `mdl_lesson_pages` ( `id` int(10) unsigned NOT NULL auto_increment, `lessonid` int(10) unsigned NOT NULL default '0', `prevpageid` int(10) unsigned NOT NULL default '0', `nextpageid` int(10) unsigned NOT NULL default '0', `qtype` tinyint(3) unsigned NOT NULL default '0', `qoption` tinyint(3) unsigned NOT NULL default '0', `timecreated` int(10) unsigned NOT NULL default '0', `timemodified` int(10) unsigned NOT NULL default '0', `title` varchar(255) NOT NULL default '', `contents` text NOT NULL, PRIMARY KEY (`id`) ) TYPE=MyISAM COMMENT='Defines lesson_pages'; -- -- Dumping data for table `mdl_lesson_pages` -- -- -- Table structure for table `mdl_log` -- CREATE TABLE `mdl_log` ( `id` int(10) unsigned NOT NULL auto_increment, `time` int(10) unsigned NOT NULL default '0', `userid` int(10) unsigned NOT NULL default '0', `ip` varchar(15) NOT NULL default '', `course` int(10) unsigned NOT NULL default '0', `module` varchar(10) NOT NULL default '', `cmid` int(10) unsigned NOT NULL default '0', `action` varchar(15) NOT NULL default '', `url` varchar(100) NOT NULL default '', `info` varchar(255) NOT NULL default '', PRIMARY KEY (`id`), KEY `timecoursemoduleaction` (`time`,`course`,`module`,`action`), KEY `coursemoduleaction` (`course`,`module`,`action`), KEY `courseuserid` (`course`,`userid`) ) TYPE=MyISAM COMMENT='Every action is logged as far as possible.'; -- -- Dumping data for table `mdl_log` -- INSERT INTO `mdl_log` (`id`, `time`, `userid`, `ip`, `course`, `module`, `cmid`, `action`, `url`, `info`) VALUES (6,1102442562,1,'65.207.127.189',1,'course',0,'view','view.php?id=1','1'); INSERT INTO `mdl_log` (`id`, `time`, `userid`, `ip`, `course`, `module`, `cmid`, `action`, `url`, `info`) VALUES (7,1102442807,1,'65.207.127.189',1,'course',0,'view','view.php?id=1','1'); INSERT INTO `mdl_log` (`id`, `time`, `userid`, `ip`, `course`, `module`, `cmid`, `action`, `url`, `info`) VALUES (8,1102442819,1,'65.207.127.189',1,'course',0,'view','view.php?id=1','1'); INSERT INTO `mdl_log` (`id`, `time`, `userid`, `ip`, `course`, `module`, `cmid`, `action`, `url`, `info`) VALUES (9,1102442832,1,'65.207.127.189',1,'course',0,'view','view.php?id=1','1'); INSERT INTO `mdl_log` (`id`, `time`, `userid`, `ip`, `course`, `module`, `cmid`, `action`, `url`, `info`) VALUES (10,1102442839,1,'65.207.127.189',1,'course',0,'view','view.php?id=1','1'); INSERT INTO `mdl_log` (`id`, `time`, `userid`, `ip`, `course`, `module`, `cmid`, `action`, `url`, `info`) VALUES (11,1102442852,1,'65.207.127.189',1,'course',0,'view','view.php?id=1','1'); INSERT INTO `mdl_log` (`id`, `time`, `userid`, `ip`, `course`, `module`, `cmid`, `action`, `url`, `info`) VALUES (12,1102442919,1,'65.207.127.189',1,'forum',1,'view forum','view.php?id=1','1'); INSERT INTO `mdl_log` (`id`, `time`, `userid`, `ip`, `course`, `module`, `cmid`, `action`, `url`, `info`) VALUES (13,1102442925,1,'65.207.127.189',1,'forum',0,'view forums','index.php?id=1',''); INSERT INTO `mdl_log` (`id`, `time`, `userid`, `ip`, `course`, `module`, `cmid`, `action`, `url`, `info`) VALUES (14,1102442931,1,'65.207.127.189',1,'forum',1,'view forum','view.php?id=1','1'); INSERT INTO `mdl_log` (`id`, `time`, `userid`, `ip`, `course`, `module`, `cmid`, `action`, `url`, `info`) VALUES (15,1102443202,1,'65.207.127.189',1,'course',0,'view','view.php?id=1','1'); INSERT INTO `mdl_log` (`id`, `time`, `userid`, `ip`, `course`, `module`, `cmid`, `action`, `url`, `info`) VALUES (16,1102443209,1,'65.207.127.189',1,'course',0,'view','view.php?id=1','1'); INSERT INTO `mdl_log` (`id`, `time`, `userid`, `ip`, `course`, `module`, `cmid`, `action`, `url`, `info`) VALUES (17,1102443221,1,'65.207.127.189',1,'course',0,'view','view.php?id=1','1'); INSERT INTO `mdl_log` (`id`, `time`, `userid`, `ip`, `course`, `module`, `cmid`, `action`, `url`, `info`) VALUES (18,1102443241,1,'65.207.127.189',1,'course',0,'view','view.php?id=1','1'); INSERT INTO `mdl_log` (`id`, `time`, `userid`, `ip`, `course`, `module`, `cmid`, `action`, `url`, `info`) VALUES (19,1102443266,1,'65.207.127.189',1,'course',0,'view','view.php?id=1','1'); INSERT INTO `mdl_log` (`id`, `time`, `userid`, `ip`, `course`, `module`, `cmid`, `action`, `url`, `info`) VALUES (20,1102443278,1,'65.207.127.189',1,'course',0,'view','view.php?id=1','1'); INSERT INTO `mdl_log` (`id`, `time`, `userid`, `ip`, `course`, `module`, `cmid`, `action`, `url`, `info`) VALUES (21,1102443285,1,'65.207.127.189',1,'course',0,'view','view.php?id=1','1'); INSERT INTO `mdl_log` (`id`, `time`, `userid`, `ip`, `course`, `module`, `cmid`, `action`, `url`, `info`) VALUES (22,1102443291,1,'65.207.127.189',1,'course',0,'view','view.php?id=1','1'); INSERT INTO `mdl_log` (`id`, `time`, `userid`, `ip`, `course`, `module`, `cmid`, `action`, `url`, `info`) VALUES (23,1102443304,1,'65.207.127.189',1,'course',0,'view','view.php?id=1','1'); INSERT INTO `mdl_log` (`id`, `time`, `userid`, `ip`, `course`, `module`, `cmid`, `action`, `url`, `info`) VALUES (24,1102443313,1,'65.207.127.189',1,'course',0,'view','view.php?id=1','1'); INSERT INTO `mdl_log` (`id`, `time`, `userid`, `ip`, `course`, `module`, `cmid`, `action`, `url`, `info`) VALUES (25,1102443323,1,'65.207.127.189',1,'course',0,'view','view.php?id=1','1'); INSERT INTO `mdl_log` (`id`, `time`, `userid`, `ip`, `course`, `module`, `cmid`, `action`, `url`, `info`) VALUES (26,1102443335,1,'65.207.127.189',1,'course',0,'view','view.php?id=1','1'); INSERT INTO `mdl_log` (`id`, `time`, `userid`, `ip`, `course`, `module`, `cmid`, `action`, `url`, `info`) VALUES (27,1102443358,1,'65.207.127.189',1,'course',0,'view','view.php?id=1','1'); INSERT INTO `mdl_log` (`id`, `time`, `userid`, `ip`, `course`, `module`, `cmid`, `action`, `url`, `info`) VALUES (28,1102443581,1,'65.207.127.189',1,'forum',1,'view forum','view.php?id=1','1'); -- -- Table structure for table `mdl_log_display` -- CREATE TABLE `mdl_log_display` ( `module` varchar(20) NOT NULL default '', `action` varchar(20) NOT NULL default '', `mtable` varchar(20) NOT NULL default '', `field` varchar(40) NOT NULL default '' ) TYPE=MyISAM COMMENT='For a particular module/action, specifies a moodle table/fie'; -- -- Dumping data for table `mdl_log_display` -- INSERT INTO `mdl_log_display` (`module`, `action`, `mtable`, `field`) VALUES ('user','view','user','CONCAT(firstname,\" \",lastname)'); INSERT INTO `mdl_log_display` (`module`, `action`, `mtable`, `field`) VALUES ('course','user report','user','CONCAT(firstname,\" \",lastname)'); INSERT INTO `mdl_log_display` (`module`, `action`, `mtable`, `field`) VALUES ('course','view','course','fullname'); INSERT INTO `mdl_log_display` (`module`, `action`, `mtable`, `field`) VALUES ('course','update','course','fullname'); INSERT INTO `mdl_log_display` (`module`, `action`, `mtable`, `field`) VALUES ('course','enrol','course','fullname'); INSERT INTO `mdl_log_display` (`module`, `action`, `mtable`, `field`) VALUES ('assignment','view','assignment','name'); INSERT INTO `mdl_log_display` (`module`, `action`, `mtable`, `field`) VALUES ('assignment','add','assignment','name'); INSERT INTO `mdl_log_display` (`module`, `action`, `mtable`, `field`) VALUES ('assignment','update','assignment','name'); INSERT INTO `mdl_log_display` (`module`, `action`, `mtable`, `field`) VALUES ('assignment','view submission','assignment','name'); INSERT INTO `mdl_log_display` (`module`, `action`, `mtable`, `field`) VALUES ('assignment','upload','assignment','name'); INSERT INTO `mdl_log_display` (`module`, `action`, `mtable`, `field`) VALUES ('chat','view','chat','name'); INSERT INTO `mdl_log_display` (`module`, `action`, `mtable`, `field`) VALUES ('chat','add','chat','name'); INSERT INTO `mdl_log_display` (`module`, `action`, `mtable`, `field`) VALUES ('chat','update','chat','name'); INSERT INTO `mdl_log_display` (`module`, `action`, `mtable`, `field`) VALUES ('chat','report','chat','name'); INSERT INTO `mdl_log_display` (`module`, `action`, `mtable`, `field`) VALUES ('chat','talk','chat','name'); INSERT INTO `mdl_log_display` (`module`, `action`, `mtable`, `field`) VALUES ('choice','view','choice','name'); INSERT INTO `mdl_log_display` (`module`, `action`, `mtable`, `field`) VALUES ('choice','update','choice','name'); INSERT INTO `mdl_log_display` (`module`, `action`, `mtable`, `field`) VALUES ('choice','add','choice','name'); INSERT INTO `mdl_log_display` (`module`, `action`, `mtable`, `field`) VALUES ('choice','report','choice','name'); INSERT INTO `mdl_log_display` (`module`, `action`, `mtable`, `field`) VALUES ('choice','choose','choice','name'); INSERT INTO `mdl_log_display` (`module`, `action`, `mtable`, `field`) VALUES ('choice','choose again','choice','name'); INSERT INTO `mdl_log_display` (`module`, `action`, `mtable`, `field`) VALUES ('forum','add','forum','name'); INSERT INTO `mdl_log_display` (`module`, `action`, `mtable`, `field`) VALUES ('forum','update','forum','name'); INSERT INTO `mdl_log_display` (`module`, `action`, `mtable`, `field`) VALUES ('forum','add discussion','forum_discussions','name'); INSERT INTO `mdl_log_display` (`module`, `action`, `mtable`, `field`) VALUES ('forum','add post','forum_posts','subject'); INSERT INTO `mdl_log_display` (`module`, `action`, `mtable`, `field`) VALUES ('forum','update post','forum_posts','subject'); INSERT INTO `mdl_log_display` (`module`, `action`, `mtable`, `field`) VALUES ('forum','move discussion','forum_discussions','name'); INSERT INTO `mdl_log_display` (`module`, `action`, `mtable`, `field`) VALUES ('forum','view subscribers','forum','name'); INSERT INTO `mdl_log_display` (`module`, `action`, `mtable`, `field`) VALUES ('forum','view discussion','forum_discussions','name'); INSERT INTO `mdl_log_display` (`module`, `action`, `mtable`, `field`) VALUES ('forum','view forum','forum','name'); INSERT INTO `mdl_log_display` (`module`, `action`, `mtable`, `field`) VALUES ('forum','subscribe','forum','name'); INSERT INTO `mdl_log_display` (`module`, `action`, `mtable`, `field`) VALUES ('forum','unsubscribe','forum','name'); INSERT INTO `mdl_log_display` (`module`, `action`, `mtable`, `field`) VALUES ('glossary','add','glossary','name'); INSERT INTO `mdl_log_display` (`module`, `action`, `mtable`, `field`) VALUES ('glossary','update','glossary','name'); INSERT INTO `mdl_log_display` (`module`, `action`, `mtable`, `field`) VALUES ('glossary','view','glossary','name'); INSERT INTO `mdl_log_display` (`module`, `action`, `mtable`, `field`) VALUES ('glossary','view all','glossary','name'); INSERT INTO `mdl_log_display` (`module`, `action`, `mtable`, `field`) VALUES ('glossary','add entry','glossary','name'); INSERT INTO `mdl_log_display` (`module`, `action`, `mtable`, `field`) VALUES ('glossary','update entry','glossary','name'); INSERT INTO `mdl_log_display` (`module`, `action`, `mtable`, `field`) VALUES ('glossary','add category','glossary','name'); INSERT INTO `mdl_log_display` (`module`, `action`, `mtable`, `field`) VALUES ('glossary','update category','glossary','name'); INSERT INTO `mdl_log_display` (`module`, `action`, `mtable`, `field`) VALUES ('glossary','delete category','glossary','name'); INSERT INTO `mdl_log_display` (`module`, `action`, `mtable`, `field`) VALUES ('glossary','add comment','glossary','name'); INSERT INTO `mdl_log_display` (`module`, `action`, `mtable`, `field`) VALUES ('glossary','update comment','glossary','name'); INSERT INTO `mdl_log_display` (`module`, `action`, `mtable`, `field`) VALUES ('glossary','delete comment','glossary','name'); INSERT INTO `mdl_log_display` (`module`, `action`, `mtable`, `field`) VALUES ('glossary','approve entry','glossary','name'); INSERT INTO `mdl_log_display` (`module`, `action`, `mtable`, `field`) VALUES ('journal','view','journal','name'); INSERT INTO `mdl_log_display` (`module`, `action`, `mtable`, `field`) VALUES ('journal','add entry','journal','name'); INSERT INTO `mdl_log_display` (`module`, `action`, `mtable`, `field`) VALUES ('journal','update entry','journal','name'); INSERT INTO `mdl_log_display` (`module`, `action`, `mtable`, `field`) VALUES ('journal','view responses','journal','name'); INSERT INTO `mdl_log_display` (`module`, `action`, `mtable`, `field`) VALUES ('label','add','quiz','name'); INSERT INTO `mdl_log_display` (`module`, `action`, `mtable`, `field`) VALUES ('label','update','quiz','name'); INSERT INTO `mdl_log_display` (`module`, `action`, `mtable`, `field`) VALUES ('lesson','start','lesson','name'); INSERT INTO `mdl_log_display` (`module`, `action`, `mtable`, `field`) VALUES ('lesson','end','lesson','name'); INSERT INTO `mdl_log_display` (`module`, `action`, `mtable`, `field`) VALUES ('lesson','view','lesson_pages','title'); INSERT INTO `mdl_log_display` (`module`, `action`, `mtable`, `field`) VALUES ('quiz','add','quiz','name'); INSERT INTO `mdl_log_display` (`module`, `action`, `mtable`, `field`) VALUES ('quiz','update','quiz','name'); INSERT INTO `mdl_log_display` (`module`, `action`, `mtable`, `field`) VALUES ('quiz','view','quiz','name'); INSERT INTO `mdl_log_display` (`module`, `action`, `mtable`, `field`) VALUES ('quiz','report','quiz','name'); INSERT INTO `mdl_log_display` (`module`, `action`, `mtable`, `field`) VALUES ('quiz','attempt','quiz','name'); INSERT INTO `mdl_log_display` (`module`, `action`, `mtable`, `field`) VALUES ('quiz','submit','quiz','name'); INSERT INTO `mdl_log_display` (`module`, `action`, `mtable`, `field`) VALUES ('quiz','review','quiz','name'); INSERT INTO `mdl_log_display` (`module`, `action`, `mtable`, `field`) VALUES ('resource','view','resource','name'); INSERT INTO `mdl_log_display` (`module`, `action`, `mtable`, `field`) VALUES ('resource','update','resource','name'); INSERT INTO `mdl_log_display` (`module`, `action`, `mtable`, `field`) VALUES ('resource','add','resource','name'); INSERT INTO `mdl_log_display` (`module`, `action`, `mtable`, `field`) VALUES ('scorm','view','scorm','name'); INSERT INTO `mdl_log_display` (`module`, `action`, `mtable`, `field`) VALUES ('scorm','update','scorm','name'); INSERT INTO `mdl_log_display` (`module`, `action`, `mtable`, `field`) VALUES ('scorm','add','scorm','name'); INSERT INTO `mdl_log_display` (`module`, `action`, `mtable`, `field`) VALUES ('survey','add','survey','name'); INSERT INTO `mdl_log_display` (`module`, `action`, `mtable`, `field`) VALUES ('survey','update','survey','name'); INSERT INTO `mdl_log_display` (`module`, `action`, `mtable`, `field`) VALUES ('survey','download','survey','name'); INSERT INTO `mdl_log_display` (`module`, `action`, `mtable`, `field`) VALUES ('survey','view form','survey','name'); INSERT INTO `mdl_log_display` (`module`, `action`, `mtable`, `field`) VALUES ('survey','view graph','survey','name'); INSERT INTO `mdl_log_display` (`module`, `action`, `mtable`, `field`) VALUES ('survey','view report','survey','name'); INSERT INTO `mdl_log_display` (`module`, `action`, `mtable`, `field`) VALUES ('survey','submit','survey','name'); INSERT INTO `mdl_log_display` (`module`, `action`, `mtable`, `field`) VALUES ('workshop','assessments','workshop','name'); INSERT INTO `mdl_log_display` (`module`, `action`, `mtable`, `field`) VALUES ('workshop','close','workshop','name'); INSERT INTO `mdl_log_display` (`module`, `action`, `mtable`, `field`) VALUES ('workshop','display','workshop','name'); INSERT INTO `mdl_log_display` (`module`, `action`, `mtable`, `field`) VALUES ('workshop','resubmit','workshop','name'); INSERT INTO `mdl_log_display` (`module`, `action`, `mtable`, `field`) VALUES ('workshop','set up','workshop','name'); INSERT INTO `mdl_log_display` (`module`, `action`, `mtable`, `field`) VALUES ('workshop','submissions','workshop','name'); INSERT INTO `mdl_log_display` (`module`, `action`, `mtable`, `field`) VALUES ('workshop','view','workshop','name'); INSERT INTO `mdl_log_display` (`module`, `action`, `mtable`, `field`) VALUES ('workshop','update','workshop','name'); -- -- Table structure for table `mdl_modules` -- CREATE TABLE `mdl_modules` ( `id` int(10) unsigned NOT NULL auto_increment, `name` varchar(20) NOT NULL default '', `version` int(10) NOT NULL default '0', `cron` int(10) unsigned NOT NULL default '0', `lastcron` int(10) unsigned NOT NULL default '0', `search` varchar(255) NOT NULL default '', `visible` tinyint(1) NOT NULL default '1', PRIMARY KEY (`id`), UNIQUE KEY `id` (`id`) ) TYPE=MyISAM; -- -- Dumping data for table `mdl_modules` -- INSERT INTO `mdl_modules` (`id`, `name`, `version`, `cron`, `lastcron`, `search`, `visible`) VALUES (1,'assignment',2004060400,60,1103623210,'',1); INSERT INTO `mdl_modules` (`id`, `name`, `version`, `cron`, `lastcron`, `search`, `visible`) VALUES (2,'chat',2004060400,300,1103623210,'',1); INSERT INTO `mdl_modules` (`id`, `name`, `version`, `cron`, `lastcron`, `search`, `visible`) VALUES (3,'choice',2004070102,0,0,'',1); INSERT INTO `mdl_modules` (`id`, `name`, `version`, `cron`, `lastcron`, `search`, `visible`) VALUES (4,'forum',2004081800,60,1103623210,'',1); INSERT INTO `mdl_modules` (`id`, `name`, `version`, `cron`, `lastcron`, `search`, `visible`) VALUES (5,'glossary',2004080900,0,0,'',1); INSERT INTO `mdl_modules` (`id`, `name`, `version`, `cron`, `lastcron`, `search`, `visible`) VALUES (6,'journal',2004060400,60,1103623210,'',1); INSERT INTO `mdl_modules` (`id`, `name`, `version`, `cron`, `lastcron`, `search`, `visible`) VALUES (7,'label',2004060400,0,0,'',1); INSERT INTO `mdl_modules` (`id`, `name`, `version`, `cron`, `lastcron`, `search`, `visible`) VALUES (8,'lesson',2004060400,0,0,'',1); INSERT INTO `mdl_modules` (`id`, `name`, `version`, `cron`, `lastcron`, `search`, `visible`) VALUES (9,'quiz',2004073001,0,0,'',1); INSERT INTO `mdl_modules` (`id`, `name`, `version`, `cron`, `lastcron`, `search`, `visible`) VALUES (10,'resource',2004080801,0,0,'',1); INSERT INTO `mdl_modules` (`id`, `name`, `version`, `cron`, `lastcron`, `search`, `visible`) VALUES (11,'scorm',2004071900,0,0,'',1); INSERT INTO `mdl_modules` (`id`, `name`, `version`, `cron`, `lastcron`, `search`, `visible`) VALUES (12,'survey',2004060400,0,0,'',1); INSERT INTO `mdl_modules` (`id`, `name`, `version`, `cron`, `lastcron`, `search`, `visible`) VALUES (13,'wiki',2004082303,0,0,'',1); INSERT INTO `mdl_modules` (`id`, `name`, `version`, `cron`, `lastcron`, `search`, `visible`) VALUES (14,'workshop',2004060400,60,1103623210,'',1); -- -- Table structure for table `mdl_quiz` -- CREATE TABLE `mdl_quiz` ( `id` int(10) unsigned NOT NULL auto_increment, `course` int(10) unsigned NOT NULL default '0', `name` varchar(255) NOT NULL default '', `intro` text NOT NULL, `timeopen` int(10) unsigned NOT NULL default '0', `timeclose` int(10) unsigned NOT NULL default '0', `attempts` smallint(6) NOT NULL default '0', `attemptonlast` tinyint(4) NOT NULL default '0', `feedback` tinyint(4) NOT NULL default '0', `correctanswers` tinyint(4) NOT NULL default '1', `grademethod` tinyint(4) NOT NULL default '1', `review` tinyint(4) NOT NULL default '0', `shufflequestions` tinyint(4) NOT NULL default '0', `shuffleanswers` tinyint(4) NOT NULL default '0', `questions` text NOT NULL, `sumgrades` int(10) NOT NULL default '0', `grade` int(10) NOT NULL default '0', `timecreated` int(10) unsigned NOT NULL default '0', `timemodified` int(10) unsigned NOT NULL default '0', `timelimit` int(2) unsigned NOT NULL default '0', `password` varchar(255) NOT NULL default '', `subnet` varchar(255) NOT NULL default '', PRIMARY KEY (`id`) ) TYPE=MyISAM COMMENT='Main information about each quiz'; -- -- Dumping data for table `mdl_quiz` -- -- -- Table structure for table `mdl_quiz_answers` -- CREATE TABLE `mdl_quiz_answers` ( `id` int(10) unsigned NOT NULL auto_increment, `question` int(10) unsigned NOT NULL default '0', `answer` varchar(255) NOT NULL default '', `fraction` varchar(10) NOT NULL default '0.0', `feedback` text NOT NULL, PRIMARY KEY (`id`), KEY `question` (`question`) ) TYPE=MyISAM COMMENT='Answers, with a fractional grade (0-1) and feedback'; -- -- Dumping data for table `mdl_quiz_answers` -- -- -- Table structure for table `mdl_quiz_attemptonlast_datasets` -- CREATE TABLE `mdl_quiz_attemptonlast_datasets` ( `id` int(10) unsigned NOT NULL auto_increment, `category` int(10) unsigned NOT NULL default '0', `userid` int(10) unsigned NOT NULL default '0', `datasetnumber` int(10) unsigned NOT NULL default '0', PRIMARY KEY (`id`), UNIQUE KEY `category` (`category`,`userid`) ) TYPE=MyISAM COMMENT='Dataset number for attemptonlast attempts per user'; -- -- Dumping data for table `mdl_quiz_attemptonlast_datasets` -- -- -- Table structure for table `mdl_quiz_attempts` -- CREATE TABLE `mdl_quiz_attempts` ( `id` int(10) unsigned NOT NULL auto_increment, `quiz` int(10) unsigned NOT NULL default '0', `userid` int(10) unsigned NOT NULL default '0', `attempt` smallint(6) NOT NULL default '0', `sumgrades` varchar(10) NOT NULL default '0.0', `timestart` int(10) unsigned NOT NULL default '0', `timefinish` int(10) unsigned NOT NULL default '0', `timemodified` int(10) unsigned NOT NULL default '0', PRIMARY KEY (`id`), KEY `quiz` (`quiz`), KEY `userid` (`userid`) ) TYPE=MyISAM COMMENT='Stores various attempts on a quiz'; -- -- Dumping data for table `mdl_quiz_attempts` -- -- -- Table structure for table `mdl_quiz_calculated` -- CREATE TABLE `mdl_quiz_calculated` ( `id` int(10) unsigned NOT NULL auto_increment, `question` int(10) unsigned NOT NULL default '0', `answer` int(10) unsigned NOT NULL default '0', `tolerance` varchar(20) NOT NULL default '0.0', `tolerancetype` int(10) NOT NULL default '1', `correctanswerlength` int(10) NOT NULL default '2', PRIMARY KEY (`id`), KEY `question` (`question`) ) TYPE=MyISAM COMMENT='Options for questions of type calculated'; -- -- Dumping data for table `mdl_quiz_calculated` -- -- -- Table structure for table `mdl_quiz_categories` -- CREATE TABLE `mdl_quiz_categories` ( `id` int(10) unsigned NOT NULL auto_increment, `course` int(10) unsigned NOT NULL default '0', `name` varchar(255) NOT NULL default '', `info` text NOT NULL, `publish` tinyint(4) NOT NULL default '0', `stamp` varchar(255) NOT NULL default '', PRIMARY KEY (`id`) ) TYPE=MyISAM COMMENT='Categories are for grouping questions'; -- -- Dumping data for table `mdl_quiz_categories` -- -- -- Table structure for table `mdl_quiz_dataset_definitions` -- CREATE TABLE `mdl_quiz_dataset_definitions` ( `id` int(10) unsigned NOT NULL auto_increment, `category` int(10) unsigned NOT NULL default '0', `name` varchar(255) NOT NULL default '', `type` int(10) NOT NULL default '0', `options` varchar(255) NOT NULL default '', `itemcount` int(10) unsigned NOT NULL default '0', PRIMARY KEY (`id`) ) TYPE=MyISAM COMMENT='Organises and stores properties for dataset items'; -- -- Dumping data for table `mdl_quiz_dataset_definitions` -- -- -- Table structure for table `mdl_quiz_dataset_items` -- CREATE TABLE `mdl_quiz_dataset_items` ( `id` int(10) unsigned NOT NULL auto_increment, `definition` int(10) unsigned NOT NULL default '0', `number` int(10) unsigned NOT NULL default '0', `value` varchar(255) NOT NULL default '', PRIMARY KEY (`id`), KEY `definition` (`definition`) ) TYPE=MyISAM COMMENT='Individual dataset items'; -- -- Dumping data for table `mdl_quiz_dataset_items` -- -- -- Table structure for table `mdl_quiz_grades` -- CREATE TABLE `mdl_quiz_grades` ( `id` int(10) unsigned NOT NULL auto_increment, `quiz` int(10) unsigned NOT NULL default '0', `userid` int(10) unsigned NOT NULL default '0', `grade` varchar(10) NOT NULL default '0.0', `timemodified` int(10) unsigned NOT NULL default '0', PRIMARY KEY (`id`), KEY `quiz` (`quiz`), KEY `userid` (`userid`) ) TYPE=MyISAM COMMENT='Final quiz grade (may be best of several attempts)'; -- -- Dumping data for table `mdl_quiz_grades` -- -- -- Table structure for table `mdl_quiz_match` -- CREATE TABLE `mdl_quiz_match` ( `id` int(10) unsigned NOT NULL auto_increment, `question` int(10) unsigned NOT NULL default '0', `subquestions` varchar(255) NOT NULL default '', PRIMARY KEY (`id`), KEY `question` (`question`) ) TYPE=MyISAM COMMENT='Defines fixed matching questions'; -- -- Dumping data for table `mdl_quiz_match` -- -- -- Table structure for table `mdl_quiz_match_sub` -- CREATE TABLE `mdl_quiz_match_sub` ( `id` int(10) unsigned NOT NULL auto_increment, `question` int(10) unsigned NOT NULL default '0', `questiontext` text NOT NULL, `answertext` varchar(255) NOT NULL default '', PRIMARY KEY (`id`), KEY `question` (`question`) ) TYPE=MyISAM COMMENT='Defines the subquestions that make up a matching question'; -- -- Dumping data for table `mdl_quiz_match_sub` -- -- -- Table structure for table `mdl_quiz_multianswers` -- CREATE TABLE `mdl_quiz_multianswers` ( `id` int(10) unsigned NOT NULL auto_increment, `question` int(10) unsigned NOT NULL default '0', `answers` varchar(255) NOT NULL default '', `positionkey` varchar(255) NOT NULL default '', `answertype` smallint(6) NOT NULL default '0', `norm` int(10) unsigned NOT NULL default '1', PRIMARY KEY (`id`), KEY `question` (`question`) ) TYPE=MyISAM COMMENT='Options for multianswer questions'; -- -- Dumping data for table `mdl_quiz_multianswers` -- -- -- Table structure for table `mdl_quiz_multichoice` -- CREATE TABLE `mdl_quiz_multichoice` ( `id` int(10) unsigned NOT NULL auto_increment, `question` int(10) unsigned NOT NULL default '0', `layout` tinyint(4) NOT NULL default '0', `answers` varchar(255) NOT NULL default '', `single` tinyint(4) NOT NULL default '0', PRIMARY KEY (`id`), KEY `question` (`question`) ) TYPE=MyISAM COMMENT='Options for multiple choice questions'; -- -- Dumping data for table `mdl_quiz_multichoice` -- -- -- Table structure for table `mdl_quiz_numerical` -- CREATE TABLE `mdl_quiz_numerical` ( `id` int(10) unsigned NOT NULL auto_increment, `question` int(10) unsigned NOT NULL default '0', `answer` int(10) unsigned NOT NULL default '0', `min` varchar(255) NOT NULL default '', `max` varchar(255) NOT NULL default '', PRIMARY KEY (`id`), KEY `answer` (`answer`) ) TYPE=MyISAM COMMENT='Options for numerical questions'; -- -- Dumping data for table `mdl_quiz_numerical` -- -- -- Table structure for table `mdl_quiz_numerical_units` -- CREATE TABLE `mdl_quiz_numerical_units` ( `id` int(10) unsigned NOT NULL auto_increment, `question` int(10) unsigned NOT NULL default '0', `multiplier` decimal(40,20) NOT NULL default '1.00000000000000000000', `unit` varchar(50) NOT NULL default '', PRIMARY KEY (`id`) ) TYPE=MyISAM COMMENT='Optional unit options for numerical questions'; -- -- Dumping data for table `mdl_quiz_numerical_units` -- -- -- Table structure for table `mdl_quiz_question_datasets` -- CREATE TABLE `mdl_quiz_question_datasets` ( `id` int(10) unsigned NOT NULL auto_increment, `question` int(10) unsigned NOT NULL default '0', `datasetdefinition` int(10) unsigned NOT NULL default '0', PRIMARY KEY (`id`), KEY `question` (`question`,`datasetdefinition`) ) TYPE=MyISAM COMMENT='Many-many relation between questions and dataset definitions'; -- -- Dumping data for table `mdl_quiz_question_datasets` -- -- -- Table structure for table `mdl_quiz_question_grades` -- CREATE TABLE `mdl_quiz_question_grades` ( `id` int(10) unsigned NOT NULL auto_increment, `quiz` int(10) unsigned NOT NULL default '0', `question` int(10) unsigned NOT NULL default '0', `grade` smallint(6) NOT NULL default '0', PRIMARY KEY (`id`), KEY `quiz` (`quiz`), KEY `question` (`question`) ) TYPE=MyISAM COMMENT='The grade for a question in a quiz'; -- -- Dumping data for table `mdl_quiz_question_grades` -- -- -- Table structure for table `mdl_quiz_questions` -- CREATE TABLE `mdl_quiz_questions` ( `id` int(10) NOT NULL auto_increment, `category` int(10) NOT NULL default '0', `name` varchar(255) NOT NULL default '', `questiontext` text NOT NULL, `questiontextformat` tinyint(2) NOT NULL default '0', `image` varchar(255) NOT NULL default '', `defaultgrade` int(10) unsigned NOT NULL default '1', `qtype` smallint(6) NOT NULL default '0', `stamp` varchar(255) NOT NULL default '', `version` int(10) NOT NULL default '1', PRIMARY KEY (`id`) ) TYPE=MyISAM COMMENT='The quiz questions themselves'; -- -- Dumping data for table `mdl_quiz_questions` -- -- -- Table structure for table `mdl_quiz_randomsamatch` -- CREATE TABLE `mdl_quiz_randomsamatch` ( `id` int(10) unsigned NOT NULL auto_increment, `question` int(10) unsigned NOT NULL default '0', `choose` int(10) unsigned NOT NULL default '4', PRIMARY KEY (`id`), KEY `question` (`question`) ) TYPE=MyISAM COMMENT='Info about a random short-answer matching question'; -- -- Dumping data for table `mdl_quiz_randomsamatch` -- -- -- Table structure for table `mdl_quiz_responses` -- CREATE TABLE `mdl_quiz_responses` ( `id` int(10) unsigned NOT NULL auto_increment, `attempt` int(10) unsigned NOT NULL default '0', `question` int(10) unsigned NOT NULL default '0', `answer` varchar(255) NOT NULL default '', `grade` varchar(10) NOT NULL default '0.0', PRIMARY KEY (`id`), KEY `attempt` (`attempt`), KEY `question` (`question`) ) TYPE=MyISAM COMMENT='Stores user responses to a quiz, and percentage grades'; -- -- Dumping data for table `mdl_quiz_responses` -- -- -- Table structure for table `mdl_quiz_shortanswer` -- CREATE TABLE `mdl_quiz_shortanswer` ( `id` int(10) unsigned NOT NULL auto_increment, `question` int(10) unsigned NOT NULL default '0', `answers` varchar(255) NOT NULL default '', `usecase` tinyint(2) NOT NULL default '0', PRIMARY KEY (`id`), KEY `question` (`question`) ) TYPE=MyISAM COMMENT='Options for short answer questions'; -- -- Dumping data for table `mdl_quiz_shortanswer` -- -- -- Table structure for table `mdl_quiz_truefalse` -- CREATE TABLE `mdl_quiz_truefalse` ( `id` int(10) unsigned NOT NULL auto_increment, `question` int(10) unsigned NOT NULL default '0', `trueanswer` int(10) unsigned NOT NULL default '0', `falseanswer` int(10) unsigned NOT NULL default '0', PRIMARY KEY (`id`), KEY `question` (`question`) ) TYPE=MyISAM COMMENT='Options for True-False questions'; -- -- Dumping data for table `mdl_quiz_truefalse` -- -- -- Table structure for table `mdl_resource` -- CREATE TABLE `mdl_resource` ( `id` int(10) unsigned NOT NULL auto_increment, `course` int(10) unsigned NOT NULL default '0', `name` varchar(255) NOT NULL default '', `type` varchar(30) NOT NULL default '', `reference` varchar(255) default NULL, `summary` text NOT NULL, `alltext` text NOT NULL, `popup` text NOT NULL, `options` varchar(255) NOT NULL default '', `timemodified` int(10) unsigned NOT NULL default '0', PRIMARY KEY (`id`), UNIQUE KEY `id` (`id`) ) TYPE=MyISAM; -- -- Dumping data for table `mdl_resource` -- -- -- Table structure for table `mdl_scale` -- CREATE TABLE `mdl_scale` ( `id` int(10) unsigned NOT NULL auto_increment, `courseid` int(10) unsigned NOT NULL default '0', `userid` int(10) unsigned NOT NULL default '0', `name` varchar(255) NOT NULL default '', `scale` text NOT NULL, `description` text NOT NULL, `timemodified` int(10) unsigned NOT NULL default '0', PRIMARY KEY (`id`) ) TYPE=MyISAM COMMENT='Defines grading scales'; -- -- Dumping data for table `mdl_scale` -- -- -- Table structure for table `mdl_scorm` -- CREATE TABLE `mdl_scorm` ( `id` int(10) unsigned NOT NULL auto_increment, `course` int(10) unsigned NOT NULL default '0', `name` varchar(255) NOT NULL default '', `reference` varchar(255) NOT NULL default '', `maxgrade` float NOT NULL default '0', `grademethod` tinyint(2) NOT NULL default '0', `datadir` varchar(255) NOT NULL default '', `launch` int(10) unsigned NOT NULL default '0', `summary` text NOT NULL, `auto` tinyint(1) unsigned NOT NULL default '0', `popup` varchar(255) NOT NULL default '', `timemodified` int(10) unsigned NOT NULL default '0', PRIMARY KEY (`id`), UNIQUE KEY `id` (`id`) ) TYPE=MyISAM; -- -- Dumping data for table `mdl_scorm` -- -- -- Table structure for table `mdl_scorm_sco_users` -- CREATE TABLE `mdl_scorm_sco_users` ( `id` int(10) unsigned NOT NULL auto_increment, `userid` int(10) unsigned NOT NULL default '0', `scormid` int(10) NOT NULL default '0', `scoid` int(10) unsigned NOT NULL default '0', `cmi_core_lesson_location` varchar(255) NOT NULL default '', `cmi_core_lesson_status` varchar(30) NOT NULL default '', `cmi_core_exit` varchar(30) NOT NULL default '', `cmi_core_total_time` varchar(13) NOT NULL default '00:00:00', `cmi_core_session_time` varchar(13) NOT NULL default '00:00:00', `cmi_core_score_raw` float NOT NULL default '0', `cmi_suspend_data` longtext, PRIMARY KEY (`id`) ) TYPE=MyISAM; -- -- Dumping data for table `mdl_scorm_sco_users` -- -- -- Table structure for table `mdl_scorm_scoes` -- CREATE TABLE `mdl_scorm_scoes` ( `id` int(10) unsigned NOT NULL auto_increment, `scorm` int(10) unsigned NOT NULL default '0', `manifest` varchar(255) NOT NULL default '', `organization` varchar(255) NOT NULL default '', `parent` varchar(255) NOT NULL default '', `identifier` varchar(255) NOT NULL default '', `launch` varchar(255) NOT NULL default '', `type` varchar(5) NOT NULL default '', `title` varchar(255) NOT NULL default '', `datafromlms` longtext, `next` tinyint(1) unsigned NOT NULL default '0', `previous` tinyint(1) unsigned NOT NULL default '0', PRIMARY KEY (`id`), UNIQUE KEY `id` (`id`) ) TYPE=MyISAM; -- -- Dumping data for table `mdl_scorm_scoes` -- -- -- Table structure for table `mdl_survey` -- CREATE TABLE `mdl_survey` ( `id` int(10) unsigned NOT NULL auto_increment, `course` int(10) unsigned NOT NULL default '0', `template` int(10) unsigned NOT NULL default '0', `days` smallint(6) NOT NULL default '0', `timecreated` int(10) unsigned NOT NULL default '0', `timemodified` int(10) unsigned NOT NULL default '0', `name` varchar(255) NOT NULL default '', `intro` text, `questions` varchar(255) default NULL, PRIMARY KEY (`id`) ) TYPE=MyISAM COMMENT='all surveys'; -- -- Dumping data for table `mdl_survey` -- INSERT INTO `mdl_survey` (`id`, `course`, `template`, `days`, `timecreated`, `timemodified`, `name`, `intro`, `questions`) VALUES (1,0,0,0,985017600,985017600,'collesaname','collesaintro','25,26,27,28,29,30,43,44'); INSERT INTO `mdl_survey` (`id`, `course`, `template`, `days`, `timecreated`, `timemodified`, `name`, `intro`, `questions`) VALUES (2,0,0,0,985017600,985017600,'collespname','collespintro','31,32,33,34,35,36,43,44'); INSERT INTO `mdl_survey` (`id`, `course`, `template`, `days`, `timecreated`, `timemodified`, `name`, `intro`, `questions`) VALUES (3,0,0,0,985017600,985017600,'collesapname','collesapintro','37,38,39,40,41,42,43,44'); INSERT INTO `mdl_survey` (`id`, `course`, `template`, `days`, `timecreated`, `timemodified`, `name`, `intro`, `questions`) VALUES (4,0,0,0,985017600,985017600,'attlsname','attlsintro','65,67,68'); INSERT INTO `mdl_survey` (`id`, `course`, `template`, `days`, `timecreated`, `timemodified`, `name`, `intro`, `questions`) VALUES (5,0,0,0,985017600,985017600,'ciqname','ciqintro','69,70,71,72,73'); -- -- Table structure for table `mdl_survey_analysis` -- CREATE TABLE `mdl_survey_analysis` ( `id` int(10) unsigned NOT NULL auto_increment, `survey` int(10) unsigned NOT NULL default '0', `userid` int(10) unsigned NOT NULL default '0', `notes` text NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `id` (`id`) ) TYPE=MyISAM; -- -- Dumping data for table `mdl_survey_analysis` -- -- -- Table structure for table `mdl_survey_answers` -- CREATE TABLE `mdl_survey_answers` ( `id` int(10) unsigned NOT NULL auto_increment, `userid` int(10) unsigned NOT NULL default '0', `survey` int(10) unsigned NOT NULL default '0', `question` int(10) unsigned NOT NULL default '0', `time` int(10) unsigned default NULL, `answer1` text, `answer2` text, PRIMARY KEY (`id`), UNIQUE KEY `id` (`id`) ) TYPE=MyISAM; -- -- Dumping data for table `mdl_survey_answers` -- -- -- Table structure for table `mdl_survey_questions` -- CREATE TABLE `mdl_survey_questions` ( `id` int(10) unsigned NOT NULL auto_increment, `text` varchar(255) NOT NULL default '', `shorttext` varchar(30) NOT NULL default '', `multi` varchar(100) NOT NULL default '', `intro` varchar(50) default NULL, `type` tinyint(3) NOT NULL default '0', `options` text, PRIMARY KEY (`id`) ) TYPE=MyISAM; -- -- Dumping data for table `mdl_survey_questions` -- INSERT INTO `mdl_survey_questions` (`id`, `text`, `shorttext`, `multi`, `intro`, `type`, `options`) VALUES (1,'colles1','colles1short','','',1,'scaletimes5'); INSERT INTO `mdl_survey_questions` (`id`, `text`, `shorttext`, `multi`, `intro`, `type`, `options`) VALUES (2,'colles2','colles2short','','',1,'scaletimes5'); INSERT INTO `mdl_survey_questions` (`id`, `text`, `shorttext`, `multi`, `intro`, `type`, `options`) VALUES (3,'colles3','colles3short','','',1,'scaletimes5'); INSERT INTO `mdl_survey_questions` (`id`, `text`, `shorttext`, `multi`, `intro`, `type`, `options`) VALUES (4,'colles4','colles4short','','',1,'scaletimes5'); INSERT INTO `mdl_survey_questions` (`id`, `text`, `shorttext`, `multi`, `intro`, `type`, `options`) VALUES (5,'colles5','colles5short','','',1,'scaletimes5'); INSERT INTO `mdl_survey_questions` (`id`, `text`, `shorttext`, `multi`, `intro`, `type`, `options`) VALUES (6,'colles6','colles6short','','',1,'scaletimes5'); INSERT INTO `mdl_survey_questions` (`id`, `text`, `shorttext`, `multi`, `intro`, `type`, `options`) VALUES (7,'colles7','colles7short','','',1,'scaletimes5'); INSERT INTO `mdl_survey_questions` (`id`, `text`, `shorttext`, `multi`, `intro`, `type`, `options`) VALUES (8,'colles8','colles8short','','',1,'scaletimes5'); INSERT INTO `mdl_survey_questions` (`id`, `text`, `shorttext`, `multi`, `intro`, `type`, `options`) VALUES (9,'colles9','colles9short','','',1,'scaletimes5'); INSERT INTO `mdl_survey_questions` (`id`, `text`, `shorttext`, `multi`, `intro`, `type`, `options`) VALUES (10,'colles10','colles10short','','',1,'scaletimes5'); INSERT INTO `mdl_survey_questions` (`id`, `text`, `shorttext`, `multi`, `intro`, `type`, `options`) VALUES (11,'colles11','colles11short','','',1,'scaletimes5'); INSERT INTO `mdl_survey_questions` (`id`, `text`, `shorttext`, `multi`, `intro`, `type`, `options`) VALUES (12,'colles12','colles12short','','',1,'scaletimes5'); INSERT INTO `mdl_survey_questions` (`id`, `text`, `shorttext`, `multi`, `intro`, `type`, `options`) VALUES (13,'colles13','colles13short','','',1,'scaletimes5'); INSERT INTO `mdl_survey_questions` (`id`, `text`, `shorttext`, `multi`, `intro`, `type`, `options`) VALUES (14,'colles14','colles14short','','',1,'scaletimes5'); INSERT INTO `mdl_survey_questions` (`id`, `text`, `shorttext`, `multi`, `intro`, `type`, `options`) VALUES (15,'colles15','colles15short','','',1,'scaletimes5'); INSERT INTO `mdl_survey_questions` (`id`, `text`, `shorttext`, `multi`, `intro`, `type`, `options`) VALUES (16,'colles16','colles16short','','',1,'scaletimes5'); INSERT INTO `mdl_survey_questions` (`id`, `text`, `shorttext`, `multi`, `intro`, `type`, `options`) VALUES (17,'colles17','colles17short','','',1,'scaletimes5'); INSERT INTO `mdl_survey_questions` (`id`, `text`, `shorttext`, `multi`, `intro`, `type`, `options`) VALUES (18,'colles18','colles18short','','',1,'scaletimes5'); INSERT INTO `mdl_survey_questions` (`id`, `text`, `shorttext`, `multi`, `intro`, `type`, `options`) VALUES (19,'colles19','colles19short','','',1,'scaletimes5'); INSERT INTO `mdl_survey_questions` (`id`, `text`, `shorttext`, `multi`, `intro`, `type`, `options`) VALUES (20,'colles20','colles20short','','',1,'scaletimes5'); INSERT INTO `mdl_survey_questions` (`id`, `text`, `shorttext`, `multi`, `intro`, `type`, `options`) VALUES (21,'colles21','colles21short','','',1,'scaletimes5'); INSERT INTO `mdl_survey_questions` (`id`, `text`, `shorttext`, `multi`, `intro`, `type`, `options`) VALUES (22,'colles22','colles22short','','',1,'scaletimes5'); INSERT INTO `mdl_survey_questions` (`id`, `text`, `shorttext`, `multi`, `intro`, `type`, `options`) VALUES (23,'colles23','colles23short','','',1,'scaletimes5'); INSERT INTO `mdl_survey_questions` (`id`, `text`, `shorttext`, `multi`, `intro`, `type`, `options`) VALUES (24,'colles24','colles24short','','',1,'scaletimes5'); INSERT INTO `mdl_survey_questions` (`id`, `text`, `shorttext`, `multi`, `intro`, `type`, `options`) VALUES (25,'collesm1','collesm1short','1,2,3,4','collesmintro',1,'scaletimes5'); INSERT INTO `mdl_survey_questions` (`id`, `text`, `shorttext`, `multi`, `intro`, `type`, `options`) VALUES (26,'collesm2','collesm2short','5,6,7,8','collesmintro',1,'scaletimes5'); INSERT INTO `mdl_survey_questions` (`id`, `text`, `shorttext`, `multi`, `intro`, `type`, `options`) VALUES (27,'collesm3','collesm3short','9,10,11,12','collesmintro',1,'scaletimes5'); INSERT INTO `mdl_survey_questions` (`id`, `text`, `shorttext`, `multi`, `intro`, `type`, `options`) VALUES (28,'collesm4','collesm4short','13,14,15,16','collesmintro',1,'scaletimes5'); INSERT INTO `mdl_survey_questions` (`id`, `text`, `shorttext`, `multi`, `intro`, `type`, `options`) VALUES (29,'collesm5','collesm5short','17,18,19,20','collesmintro',1,'scaletimes5'); INSERT INTO `mdl_survey_questions` (`id`, `text`, `shorttext`, `multi`, `intro`, `type`, `options`) VALUES (30,'collesm6','collesm6short','21,22,23,24','collesmintro',1,'scaletimes5'); INSERT INTO `mdl_survey_questions` (`id`, `text`, `shorttext`, `multi`, `intro`, `type`, `options`) VALUES (31,'collesm1','collesm1short','1,2,3,4','collesmintro',2,'scaletimes5'); INSERT INTO `mdl_survey_questions` (`id`, `text`, `shorttext`, `multi`, `intro`, `type`, `options`) VALUES (32,'collesm2','collesm2short','5,6,7,8','collesmintro',2,'scaletimes5'); INSERT INTO `mdl_survey_questions` (`id`, `text`, `shorttext`, `multi`, `intro`, `type`, `options`) VALUES (33,'collesm3','collesm3short','9,10,11,12','collesmintro',2,'scaletimes5'); INSERT INTO `mdl_survey_questions` (`id`, `text`, `shorttext`, `multi`, `intro`, `type`, `options`) VALUES (34,'collesm4','collesm4short','13,14,15,16','collesmintro',2,'scaletimes5'); INSERT INTO `mdl_survey_questions` (`id`, `text`, `shorttext`, `multi`, `intro`, `type`, `options`) VALUES (35,'collesm5','collesm5short','17,18,19,20','collesmintro',2,'scaletimes5'); INSERT INTO `mdl_survey_questions` (`id`, `text`, `shorttext`, `multi`, `intro`, `type`, `options`) VALUES (36,'collesm6','collesm6short','21,22,23,24','collesmintro',2,'scaletimes5'); INSERT INTO `mdl_survey_questions` (`id`, `text`, `shorttext`, `multi`, `intro`, `type`, `options`) VALUES (37,'collesm1','collesm1short','1,2,3,4','collesmintro',3,'scaletimes5'); INSERT INTO `mdl_survey_questions` (`id`, `text`, `shorttext`, `multi`, `intro`, `type`, `options`) VALUES (38,'collesm2','collesm2short','5,6,7,8','collesmintro',3,'scaletimes5'); INSERT INTO `mdl_survey_questions` (`id`, `text`, `shorttext`, `multi`, `intro`, `type`, `options`) VALUES (39,'collesm3','collesm3short','9,10,11,12','collesmintro',3,'scaletimes5'); INSERT INTO `mdl_survey_questions` (`id`, `text`, `shorttext`, `multi`, `intro`, `type`, `options`) VALUES (40,'collesm4','collesm4short','13,14,15,16','collesmintro',3,'scaletimes5'); INSERT INTO `mdl_survey_questions` (`id`, `text`, `shorttext`, `multi`, `intro`, `type`, `options`) VALUES (41,'collesm5','collesm5short','17,18,19,20','collesmintro',3,'scaletimes5'); INSERT INTO `mdl_survey_questions` (`id`, `text`, `shorttext`, `multi`, `intro`, `type`, `options`) VALUES (42,'collesm6','collesm6short','21,22,23,24','collesmintro',3,'scaletimes5'); INSERT INTO `mdl_survey_questions` (`id`, `text`, `shorttext`, `multi`, `intro`, `type`, `options`) VALUES (43,'howlong','','','',1,'howlongoptions'); INSERT INTO `mdl_survey_questions` (`id`, `text`, `shorttext`, `multi`, `intro`, `type`, `options`) VALUES (44,'othercomments','','','',0,''); INSERT INTO `mdl_survey_questions` (`id`, `text`, `shorttext`, `multi`, `intro`, `type`, `options`) VALUES (64,'attls20','attls20short','','',1,'scaleagree5'); INSERT INTO `mdl_survey_questions` (`id`, `text`, `shorttext`, `multi`, `intro`, `type`, `options`) VALUES (58,'attls14','attls14short','','',1,'scaleagree5'); INSERT INTO `mdl_survey_questions` (`id`, `text`, `shorttext`, `multi`, `intro`, `type`, `options`) VALUES (59,'attls15','attls15short','','',1,'scaleagree5'); INSERT INTO `mdl_survey_questions` (`id`, `text`, `shorttext`, `multi`, `intro`, `type`, `options`) VALUES (60,'attls16','attls16short','','',1,'scaleagree5'); INSERT INTO `mdl_survey_questions` (`id`, `text`, `shorttext`, `multi`, `intro`, `type`, `options`) VALUES (61,'attls17','attls17short','','',1,'scaleagree5'); INSERT INTO `mdl_survey_questions` (`id`, `text`, `shorttext`, `multi`, `intro`, `type`, `options`) VALUES (62,'attls18','attls18short','','',1,'scaleagree5'); INSERT INTO `mdl_survey_questions` (`id`, `text`, `shorttext`, `multi`, `intro`, `type`, `options`) VALUES (63,'attls19','attls19short','','',1,'scaleagree5'); INSERT INTO `mdl_survey_questions` (`id`, `text`, `shorttext`, `multi`, `intro`, `type`, `options`) VALUES (56,'attls12','attls12short','','',1,'scaleagree5'); INSERT INTO `mdl_survey_questions` (`id`, `text`, `shorttext`, `multi`, `intro`, `type`, `options`) VALUES (57,'attls13','attls13short','','',1,'scaleagree5'); INSERT INTO `mdl_survey_questions` (`id`, `text`, `shorttext`, `multi`, `intro`, `type`, `options`) VALUES (55,'attls11','attls11short','','',1,'scaleagree5'); INSERT INTO `mdl_survey_questions` (`id`, `text`, `shorttext`, `multi`, `intro`, `type`, `options`) VALUES (54,'attls10','attls10short','','',1,'scaleagree5'); INSERT INTO `mdl_survey_questions` (`id`, `text`, `shorttext`, `multi`, `intro`, `type`, `options`) VALUES (53,'attls9','attls9short','','',1,'scaleagree5'); INSERT INTO `mdl_survey_questions` (`id`, `text`, `shorttext`, `multi`, `intro`, `type`, `options`) VALUES (52,'attls8','attls8short','','',1,'scaleagree5'); INSERT INTO `mdl_survey_questions` (`id`, `text`, `shorttext`, `multi`, `intro`, `type`, `options`) VALUES (51,'attls7','attls7short','','',1,'scaleagree5'); INSERT INTO `mdl_survey_questions` (`id`, `text`, `shorttext`, `multi`, `intro`, `type`, `options`) VALUES (50,'attls6','attls6short','','',1,'scaleagree5'); INSERT INTO `mdl_survey_questions` (`id`, `text`, `shorttext`, `multi`, `intro`, `type`, `options`) VALUES (49,'attls5','attls5short','','',1,'scaleagree5'); INSERT INTO `mdl_survey_questions` (`id`, `text`, `shorttext`, `multi`, `intro`, `type`, `options`) VALUES (48,'attls4','attls4short','','',1,'scaleagree5'); INSERT INTO `mdl_survey_questions` (`id`, `text`, `shorttext`, `multi`, `intro`, `type`, `options`) VALUES (47,'attls3','attls3short','','',1,'scaleagree5'); INSERT INTO `mdl_survey_questions` (`id`, `text`, `shorttext`, `multi`, `intro`, `type`, `options`) VALUES (45,'attls1','attls1short','','',1,'scaleagree5'); INSERT INTO `mdl_survey_questions` (`id`, `text`, `shorttext`, `multi`, `intro`, `type`, `options`) VALUES (46,'attls2','attls2short','','',1,'scaleagree5'); INSERT INTO `mdl_survey_questions` (`id`, `text`, `shorttext`, `multi`, `intro`, `type`, `options`) VALUES (65,'attlsm1','attlsm1','45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64','attlsmintro',1,'scaleagree5'); INSERT INTO `mdl_survey_questions` (`id`, `text`, `shorttext`, `multi`, `intro`, `type`, `options`) VALUES (67,'attlsm2','attlsm2','63,62,59,57,55,49,52,50,48,47','attlsmintro',-1,'scaleagree5'); INSERT INTO `mdl_survey_questions` (`id`, `text`, `shorttext`, `multi`, `intro`, `type`, `options`) VALUES (68,'attlsm3','attlsm3','46,54,45,51,60,53,56,58,61,64','attlsmintro',-1,'scaleagree5'); INSERT INTO `mdl_survey_questions` (`id`, `text`, `shorttext`, `multi`, `intro`, `type`, `options`) VALUES (69,'ciq1','ciq1short','','',0,''); INSERT INTO `mdl_survey_questions` (`id`, `text`, `shorttext`, `multi`, `intro`, `type`, `options`) VALUES (70,'ciq2','ciq2short','','',0,''); INSERT INTO `mdl_survey_questions` (`id`, `text`, `shorttext`, `multi`, `intro`, `type`, `options`) VALUES (71,'ciq3','ciq3short','','',0,''); INSERT INTO `mdl_survey_questions` (`id`, `text`, `shorttext`, `multi`, `intro`, `type`, `options`) VALUES (72,'ciq4','ciq4short','','',0,''); INSERT INTO `mdl_survey_questions` (`id`, `text`, `shorttext`, `multi`, `intro`, `type`, `options`) VALUES (73,'ciq5','ciq5short','','',0,''); -- -- Table structure for table `mdl_user` -- CREATE TABLE `mdl_user` ( `id` int(10) unsigned NOT NULL auto_increment, `auth` varchar(20) NOT NULL default 'manual', `confirmed` tinyint(1) NOT NULL default '0', `deleted` tinyint(1) NOT NULL default '0', `username` varchar(100) NOT NULL default '', `password` varchar(32) NOT NULL default '', `idnumber` varchar(12) default NULL, `firstname` varchar(20) NOT NULL default '', `lastname` varchar(20) NOT NULL default '', `email` varchar(100) NOT NULL default '', `emailstop` tinyint(1) unsigned NOT NULL default '0', `icq` varchar(15) default NULL, `phone1` varchar(20) default NULL, `phone2` varchar(20) default NULL, `institution` varchar(40) default NULL, `department` varchar(30) default NULL, `address` varchar(70) default NULL, `city` varchar(20) default NULL, `country` char(2) default NULL, `lang` varchar(10) default 'en', `timezone` float NOT NULL default '99', `firstaccess` int(10) unsigned NOT NULL default '0', `lastaccess` int(10) unsigned NOT NULL default '0', `lastlogin` int(10) unsigned NOT NULL default '0', `currentlogin` int(10) unsigned NOT NULL default '0', `lastIP` varchar(15) default NULL, `secret` varchar(15) default NULL, `picture` tinyint(1) default NULL, `url` varchar(255) default NULL, `description` text, `mailformat` tinyint(1) unsigned NOT NULL default '1', `maildigest` tinyint(1) unsigned NOT NULL default '0', `maildisplay` tinyint(2) unsigned NOT NULL default '2', `htmleditor` tinyint(1) unsigned NOT NULL default '1', `autosubscribe` tinyint(1) unsigned NOT NULL default '1', `timemodified` int(10) unsigned NOT NULL default '0', PRIMARY KEY (`id`), UNIQUE KEY `username` (`username`), UNIQUE KEY `id` (`id`) ) TYPE=MyISAM COMMENT='One record for each person'; -- -- Dumping data for table `mdl_user` -- INSERT INTO `mdl_user` (`id`, `auth`, `confirmed`, `deleted`, `username`, `password`, `idnumber`, `firstname`, `lastname`, `email`, `emailstop`, `icq`, `phone1`, `phone2`, `institution`, `department`, `address`, `city`, `country`, `lang`, `timezone`, `firstaccess`, `lastaccess`, `lastlogin`, `currentlogin`, `lastIP`, `secret`, `picture`, `url`, `description`, `mailformat`, `maildigest`, `maildisplay`, `htmleditor`, `autosubscribe`, `timemodified`) VALUES (1,'manual',1,0,'admin','0d78658b259edcf59d78044457275aa4','','Melissa','Ringstaff','admin@avirtuouswoman.org',0,'','','','','','','','','en',99,0,1102443581,1100285780,1102439675,'65.207.127.189',NULL,NULL,'','',1,0,1,1,1,1099596968); INSERT INTO `mdl_user` (`id`, `auth`, `confirmed`, `deleted`, `username`, `password`, `idnumber`, `firstname`, `lastname`, `email`, `emailstop`, `icq`, `phone1`, `phone2`, `institution`, `department`, `address`, `city`, `country`, `lang`, `timezone`, `firstaccess`, `lastaccess`, `lastlogin`, `currentlogin`, `lastIP`, `secret`, `picture`, `url`, `description`, `mailformat`, `maildigest`, `maildisplay`, `htmleditor`, `autosubscribe`, `timemodified`) VALUES (2,'manual',1,0,'guest','084e0343a0486ff05530df6c705c8bb4',NULL,'Guest User','','root@localhost',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'en',99,0,0,0,0,NULL,NULL,NULL,NULL,'This user is a special user that allows read-only access to some courses.',1,0,2,1,1,1099597046); -- -- Table structure for table `mdl_user_admins` -- CREATE TABLE `mdl_user_admins` ( `id` int(10) unsigned NOT NULL auto_increment, `userid` int(10) unsigned NOT NULL default '0', PRIMARY KEY (`id`), UNIQUE KEY `id` (`id`) ) TYPE=MyISAM COMMENT='One record per administrator user'; -- -- Dumping data for table `mdl_user_admins` -- INSERT INTO `mdl_user_admins` (`id`, `userid`) VALUES (1,1); -- -- Table structure for table `mdl_user_coursecreators` -- CREATE TABLE `mdl_user_coursecreators` ( `id` int(10) unsigned NOT NULL auto_increment, `userid` int(10) unsigned NOT NULL default '0', PRIMARY KEY (`id`), UNIQUE KEY `id` (`id`) ) TYPE=MyISAM COMMENT='One record per course creator'; -- -- Dumping data for table `mdl_user_coursecreators` -- -- -- Table structure for table `mdl_user_preferences` -- CREATE TABLE `mdl_user_preferences` ( `id` int(10) unsigned NOT NULL auto_increment, `userid` int(10) unsigned NOT NULL default '0', `name` varchar(50) NOT NULL default '', `value` varchar(255) NOT NULL default '', PRIMARY KEY (`id`), UNIQUE KEY `id` (`id`), KEY `useridname` (`userid`,`name`) ) TYPE=MyISAM COMMENT='Allows modules to store arbitrary user preferences'; -- -- Dumping data for table `mdl_user_preferences` -- -- -- Table structure for table `mdl_user_students` -- CREATE TABLE `mdl_user_students` ( `id` int(10) unsigned NOT NULL auto_increment, `userid` int(10) unsigned NOT NULL default '0', `course` int(10) unsigned NOT NULL default '0', `timestart` int(10) unsigned NOT NULL default '0', `timeend` int(10) unsigned NOT NULL default '0', `time` int(10) unsigned NOT NULL default '0', `timeaccess` int(10) unsigned NOT NULL default '0', PRIMARY KEY (`id`), UNIQUE KEY `id` (`id`), KEY `courseuserid` (`course`,`userid`) ) TYPE=MyISAM; -- -- Dumping data for table `mdl_user_students` -- -- -- Table structure for table `mdl_user_teachers` -- CREATE TABLE `mdl_user_teachers` ( `id` int(10) unsigned NOT NULL auto_increment, `userid` int(10) unsigned NOT NULL default '0', `course` int(10) unsigned NOT NULL default '0', `authority` int(10) NOT NULL default '3', `role` varchar(40) NOT NULL default '', `editall` int(1) unsigned NOT NULL default '1', `timestart` int(10) unsigned NOT NULL default '0', `timeend` int(10) unsigned NOT NULL default '0', `timemodified` int(10) unsigned NOT NULL default '0', `timeaccess` int(10) unsigned NOT NULL default '0', PRIMARY KEY (`id`), UNIQUE KEY `id` (`id`), KEY `courseuserid` (`course`,`userid`) ) TYPE=MyISAM COMMENT='One record per teacher per course'; -- -- Dumping data for table `mdl_user_teachers` -- INSERT INTO `mdl_user_teachers` (`id`, `userid`, `course`, `authority`, `role`, `editall`, `timestart`, `timeend`, `timemodified`, `timeaccess`) VALUES (1,1,1,1,'',1,0,0,0,0); -- -- Table structure for table `mdl_wiki` -- CREATE TABLE `mdl_wiki` ( `id` int(10) unsigned NOT NULL auto_increment, `course` int(10) unsigned NOT NULL default '0', `name` varchar(255) NOT NULL default '', `summary` text NOT NULL, `pagename` varchar(255) default NULL, `wtype` enum('teacher','group','student') NOT NULL default 'group', `ewikiprinttitle` tinyint(4) NOT NULL default '1', `htmlmode` tinyint(4) NOT NULL default '0', `ewikiacceptbinary` tinyint(4) NOT NULL default '0', `disablecamelcase` tinyint(4) NOT NULL default '0', `setpageflags` tinyint(4) NOT NULL default '1', `strippages` tinyint(4) NOT NULL default '1', `removepages` tinyint(4) NOT NULL default '1', `revertchanges` tinyint(4) NOT NULL default '1', `initialcontent` varchar(255) default NULL, `timemodified` int(10) NOT NULL default '0', PRIMARY KEY (`id`) ) TYPE=MyISAM COMMENT='Main wiki table'; -- -- Dumping data for table `mdl_wiki` -- -- -- Table structure for table `mdl_wiki_entries` -- CREATE TABLE `mdl_wiki_entries` ( `id` int(10) NOT NULL auto_increment, `wikiid` int(10) NOT NULL default '0', `course` int(10) NOT NULL default '0', `groupid` int(10) NOT NULL default '0', `userid` int(10) NOT NULL default '0', `pagename` varchar(255) NOT NULL default '', `timemodified` int(10) NOT NULL default '0', PRIMARY KEY (`id`) ) TYPE=MyISAM COMMENT='Holds entries for each wiki start instance.'; -- -- Dumping data for table `mdl_wiki_entries` -- -- -- Table structure for table `mdl_wiki_pages` -- CREATE TABLE `mdl_wiki_pages` ( `pagename` varchar(160) NOT NULL default '', `version` int(10) unsigned NOT NULL default '0', `flags` int(10) unsigned default '0', `content` mediumtext, `author` varchar(100) default 'ewiki', `userid` int(10) unsigned NOT NULL default '0', `created` int(10) unsigned default '0', `lastmodified` int(10) unsigned default '0', `refs` mediumtext, `meta` mediumtext, `hits` int(10) unsigned default '0', `wiki` int(10) unsigned NOT NULL default '0', PRIMARY KEY (`pagename`,`version`,`wiki`) ) TYPE=MyISAM COMMENT='Holds the Wiki-Pages'; -- -- Dumping data for table `mdl_wiki_pages` -- -- -- Table structure for table `mdl_workshop` -- CREATE TABLE `mdl_workshop` ( `id` int(10) unsigned NOT NULL auto_increment, `course` int(10) unsigned NOT NULL default '0', `name` varchar(255) NOT NULL default '', `description` text NOT NULL, `nelements` tinyint(3) unsigned NOT NULL default '1', `phase` tinyint(2) unsigned NOT NULL default '0', `format` tinyint(2) unsigned NOT NULL default '0', `gradingstrategy` tinyint(2) unsigned NOT NULL default '1', `resubmit` tinyint(2) unsigned NOT NULL default '0', `agreeassessments` tinyint(2) unsigned NOT NULL default '0', `hidegrades` tinyint(2) unsigned NOT NULL default '0', `anonymous` tinyint(2) unsigned NOT NULL default '0', `includeself` tinyint(2) unsigned NOT NULL default '0', `maxbytes` int(10) unsigned NOT NULL default '100000', `deadline` int(10) unsigned NOT NULL default '0', `grade` int(10) NOT NULL default '0', `ntassessments` tinyint(3) unsigned NOT NULL default '0', `nsassessments` tinyint(3) unsigned NOT NULL default '0', `overallocation` tinyint(3) unsigned NOT NULL default '0', `timemodified` int(10) unsigned NOT NULL default '0', `mergegrades` tinyint(3) unsigned NOT NULL default '0', `teacherweight` tinyint(3) unsigned NOT NULL default '5', `peerweight` tinyint(3) unsigned NOT NULL default '5', `includeteachersgrade` tinyint(3) unsigned NOT NULL default '0', `biasweight` tinyint(3) unsigned NOT NULL default '5', `reliabilityweight` tinyint(3) unsigned NOT NULL default '5', `gradingweight` tinyint(3) unsigned NOT NULL default '5', `teacherloading` tinyint(3) unsigned NOT NULL default '5', `assessmentstodrop` tinyint(3) unsigned NOT NULL default '0', `showleaguetable` tinyint(3) unsigned NOT NULL default '0', PRIMARY KEY (`id`) ) TYPE=MyISAM COMMENT='Defines workshop'; -- -- Dumping data for table `mdl_workshop` -- -- -- Table structure for table `mdl_workshop_assessments` -- CREATE TABLE `mdl_workshop_assessments` ( `id` int(10) unsigned NOT NULL auto_increment, `workshopid` int(10) unsigned NOT NULL default '0', `submissionid` int(10) unsigned NOT NULL default '0', `userid` int(10) unsigned NOT NULL default '0', `timecreated` int(10) unsigned NOT NULL default '0', `timegraded` int(10) unsigned NOT NULL default '0', `timeagreed` int(10) unsigned NOT NULL default '0', `grade` float NOT NULL default '0', `gradinggrade` int(3) NOT NULL default '0', `mailed` tinyint(3) unsigned NOT NULL default '0', `resubmission` tinyint(3) unsigned NOT NULL default '0', `donotuse` tinyint(3) unsigned NOT NULL default '0', `generalcomment` text NOT NULL, `teachercomment` text NOT NULL, PRIMARY KEY (`id`) ) TYPE=MyISAM COMMENT='Info about assessments by teacher and students'; -- -- Dumping data for table `mdl_workshop_assessments` -- -- -- Table structure for table `mdl_workshop_comments` -- CREATE TABLE `mdl_workshop_comments` ( `id` int(10) unsigned NOT NULL auto_increment, `workshopid` int(10) unsigned NOT NULL default '0', `assessmentid` int(10) unsigned NOT NULL default '0', `userid` int(10) unsigned NOT NULL default '0', `timecreated` int(10) unsigned NOT NULL default '0', `mailed` tinyint(2) unsigned NOT NULL default '0', `comments` text NOT NULL, PRIMARY KEY (`id`) ) TYPE=MyISAM COMMENT='Defines comments'; -- -- Dumping data for table `mdl_workshop_comments` -- -- -- Table structure for table `mdl_workshop_elements` -- CREATE TABLE `mdl_workshop_elements` ( `id` int(10) unsigned NOT NULL auto_increment, `workshopid` int(10) unsigned NOT NULL default '0', `elementno` tinyint(3) unsigned NOT NULL default '0', `description` text NOT NULL, `scale` tinyint(3) unsigned NOT NULL default '0', `maxscore` tinyint(3) unsigned NOT NULL default '1', `weight` float NOT NULL default '1', PRIMARY KEY (`id`) ) TYPE=MyISAM COMMENT='Info about marking scheme of assignment'; -- -- Dumping data for table `mdl_workshop_elements` -- -- -- Table structure for table `mdl_workshop_grades` -- CREATE TABLE `mdl_workshop_grades` ( `id` int(10) unsigned NOT NULL auto_increment, `workshopid` int(10) unsigned NOT NULL default '0', `assessmentid` int(10) unsigned NOT NULL default '0', `elementno` int(10) unsigned NOT NULL default '0', `feedback` text NOT NULL, `grade` tinyint(3) NOT NULL default '0', PRIMARY KEY (`id`) ) TYPE=MyISAM COMMENT='Info about individual grades given to each element'; -- -- Dumping data for table `mdl_workshop_grades` -- -- -- Table structure for table `mdl_workshop_rubrics` -- CREATE TABLE `mdl_workshop_rubrics` ( `id` int(10) unsigned NOT NULL auto_increment, `workshopid` int(10) unsigned NOT NULL default '0', `elementno` int(10) unsigned NOT NULL default '0', `rubricno` tinyint(3) unsigned NOT NULL default '0', `description` text NOT NULL, PRIMARY KEY (`id`) ) TYPE=MyISAM COMMENT='Info about the rubrics marking scheme'; -- -- Dumping data for table `mdl_workshop_rubrics` -- -- -- Table structure for table `mdl_workshop_submissions` -- CREATE TABLE `mdl_workshop_submissions` ( `id` int(10) unsigned NOT NULL auto_increment, `workshopid` int(10) unsigned NOT NULL default '0', `userid` int(10) unsigned NOT NULL default '0', `title` varchar(100) NOT NULL default '', `timecreated` int(10) unsigned NOT NULL default '0', `mailed` tinyint(2) unsigned NOT NULL default '0', `teachergrade` int(3) unsigned NOT NULL default '0', `peergrade` int(3) unsigned NOT NULL default '0', `biasgrade` int(3) unsigned NOT NULL default '0', `reliabilitygrade` int(3) unsigned NOT NULL default '0', `gradinggrade` int(3) unsigned NOT NULL default '0', `finalgrade` int(3) unsigned NOT NULL default '0', PRIMARY KEY (`id`), KEY `title` (`title`) ) TYPE=MyISAM COMMENT='Info about submitted work from teacher and students'; -- -- Dumping data for table `mdl_workshop_submissions` --