Setting an ID number provides a way of identifying the activity for grade calculation purposes. If the activity is not included in any grade calculation then the ID number field may be left blank.
\n\nThe ID number can also be set in the gradebook, though it can only be edited on the activity settings page.
\n', 1283751135), > (2, '9ea15f834536dcfd4c549355885478c9', 'remnants test - res-label
', 1283851016), > (3, 'd880260f845681193074e23246de0efc', 'remnants test - res-label
', 1283851514), > (4, '6c7bc384a126e6a9c45429b27f176037', 'a resourceful page this is not.
', 1283845352), > (5, '4306a8de8c2af5007592951ee9601e5c', 'there is no content thats useful in here. this is a test.
', 1283845352), > (6, 'd217448c7152cbdc851b1412e13f6bad', 'this here is a link to an ims package ... that was used to test the ims resource.
\r\ni used this one : http://openlearn.open.ac.uk/blocks/formats/download_unit.php?id=1641
\r\nbut MD suggested http://openlearn.open.ac.uk/blocks/formats/download_unit.php?id=1529 (expected)
', 1283754069), > (7, '8bc22e0543dcb8e52c325fba45c362be', 'The "Send for marking" button allows students to indicate to the teacher that they have finished working on an assignment. The teacher may choose to revert the assignment to draft status (if it requires further work, for example).
\n', 1283754355), > (8, '9754ce8d77a7fcdb6dae3f713e602722', 'this is a advanced upload activity test.
', 1283846972), > (9, '5523b79cf5e6112903c0b2cd11fbca44', 'If enabled, the submission text will be copied into the feedback comment field during grading, making it easier to comment inline (using a different colour, perhaps) or to edit the original text.
\n', 1283754483), > (10, '5c85514e5fcdba1bc8879ce6ebe091c3', 'this is an offline assignment.
', 1283754718), > (11, '82660b211b688bd8d7fddf9095b64433', 'If set to No, only users have mod/chat:readlog capability are able to see the chat logs
\n', 1283754837), > (12, '341c7a3ee106746dc81cef2e57d4e333', 'this is a chat.. hmm what does this do?
', 1283849230), > (13, '973160b52c4480bd4381ff8ae65a2bdb', 'This option allows you to limit the number of participants that can select each choice option. When the limit is reached then no-one else can select that option.
\n\nIf limits are disabled then any number of participants can select each of the options.
\n', 1283755095), > (14, '971311c6ec200b08d7f15b4f54808d26', 'Here is where you specify the options that participants have to choose from.
\n\nYou can fill in any number of these. If you leave some of the options blank, they will not be displayed. If you need more than 8 options, click the "Add 3 fields to form" button.
\n', 1283755009), > (15, '0d110a252d7e5e1d52f73b0c57b7933c', 'The number of entries a student is required to submit before the activity can be considered complete.
\n', 1283755322), > (16, '434e38eea8a87812e0cef35a02d7ab7f', 'The number of entries a student is required to submit before they can view entries from other students.
\n\nNote: If entries are required before viewing, the database auto-linking filter should be disabled. This is because the database auto-linking filter can''t determine whether a user has submitted the required number of entries.
\n', 1283755332), > (17, '78b8cfd3e5c9fdb062812b68ce96f8aa', 'If enabled, entries require approving by a teacher before they are viewable by everyone.
\n', 1283755447), > (18, 'c1bd973c0892cd2e286dcb0753a79c2f', 'To submit ratings users require the moodle/rating:rate capability and any module specific capabilities. Users assigned the following roles should be able to rate items. The list of roles may be amended via the permissions link in the settings block.
\n', 1283755474), > (19, 'da3646c26b2579b5712116719de66b1a', 'The aggregate type defines how ratings are combined to form the final grade in the gradebook.
\n\nIf "No ratings" is selected, then the activity will not appear in the gradebook.
\n', 1283755492), > (20, '977e888ea775612944214b8ef3c676d6', 'If this checkbox is ticked, the activity (or resource) will only be available to students assigned to groups within the selected grouping.
\n', 1283755573), > (21, '2f4ba76fe7fcaa510025be8c94d0db31', 'When a participant is subscribed to a forum it means they will receive email copies of forum posts.
\n\nThere are 4 subscription mode options:
\n\nStudents can be blocked from posting more than a given number of posts in a given time period. Users with the capability mod/forum:postwithoutthrottling are exempt from post limits.
\n', 1283755683), > (23, '9e7b82d6673ef186fd1625a2a2646cad', 'This setting specifies the maximum number of posts which a user can post in the given time period. Users with the capability mod/forum:postwithoutthrottling are exempt from post limits.
\n', 1283755700), > (24, '6e943fa58e49165e95fcb6ec28315e34', 'Students can be warned as they approach the maximum number of posts allowed in a given period. This setting specifies after how many posts they are warned. Users with the capability mod/forum:postwithoutthrottling are exempt from post limits.
\n', 1283755724), > (25, 'e0999b3fdfe878347eca637f117b93ca', 'This setting has 3 options:
\n\nThe group mode defined at course level is the default mode for all activities within the course. Each activity that supports groups can also define its own group mode, though if the group mode is forced at course level, the group mode setting for each activity is ignored.
\n', 1283755799), > (26, 'e0736d09f4516ca3d9743350de00e1ac', 'This setting specifies whether entries are always editable or whether students can only edit their entries during a configured editing time (usually 30 minutes).
\n', 1283755970), > (27, '8d00459243ebee209d13f69118f2535a', 'If enabled, then each answer may be given a numerical point value (positive or negative).
\n', 1283756134), > (28, 'd6c288768ecbc788eaabb6f4b3a2a04a', 'Quiz access may be restricted to particular subnets on the LAN or Internet by specifying a comma-separated list of partial or full IP address numbers. This can be useful for an invigilated (proctored) quiz, to ensure that only people in a certain location can access the quiz.
\n', 1283850963), > (29, '7b803b9d878e64c1592ab8e96e288ad0', 'this is a test to look for remnants
', 1283851506), > (30, '26a91043dc74c972ced667592c7a5577', 'The grading strategy determines the assessment form used and the method of grading submissions. There are 4 options:
\n\nthis is a new folder.
', 1283845322), > (32, 'f03460f283e227037816792406b96585', 'this is an online assignment
', 1283847006), > (33, '3fa386292e1075d13fe0318c304ee3d8', 'a group for use in remnants test
', 1283846767), > (34, '5ee3052dd3f8148fca7fb7ab507770c3', 'remnants testing for a note...
', 1283846973), > (35, '6703e8028929538207128b503b1a4e39', 'lets upload the ims for education .
', 1283847026), > (36, '7d306af794a1d2622a521b1e6eda00bb', 'this is a test to look for remnants
', 1283850312), > (37, 'a57ee61dab0bd21783f7bc7e13b2446d', 'test', 1283847384), > (38, '473e4c62de3a10ae5d2fd82fd8aeba07', 'testhi', 1283847388), > (39, '2769188dc13a8359cdc20d20a9129728', 'wrdfv', 1283847392), > (40, 'e85a5988bda93bc5708c1dac8d65ea22', 'hello', 1283847404), > (41, '36680eb15c35d50f5e073c7e9d54fa72', 'Navigation * Home o moodleMy home o Site pages + moodleParticipants + moodleBlogs + moodleTags o My profile + moodleView profile + Blogs # moodleView all of my entries # moodleAdd a new entry + moodleMessages + moodleMy private files o My courses + remnants # Participants * moodleBlogs * Terry Smart o moodleView profile o Forum posts + moodleDiscussions o Blogs + moodleView all of my entries + moodleAdd a new entry o moodleMessages o moodleMy private files # General * ForumNews forum * Filethis is a remnants test (res-FILE) * Folderremnants test (res-Folder) * IMS content packageremnants test (res-IMS) * Pageremnantes test - res-page. * URLremnantest test res-url * Assignment--- remnants test -- act:adv upload * Assignmentremnants online assignment test * Assignmentremnants test - activity upload single file * Chatremnants test - activity chat o Click here to enter the chat now o Use more accessible interface * Choiceremnants activity choice * Databaseremnants test - database activity * Forumremnants test for forum activity * Glossaryremnants test glooooossary * Lessonremnants test - activity : Lesson * Quizremnants testing - a quiz in activity * SCORM packageremnants testing a scrom pkg * Surveyremnants survey for this survey. a test * Wikiremnants test ', 1283847439), > (42, '38bbf292fb5e54bdeb7d3c587791ef28', 'sxtfdg', 1283847453), > (43, '915c3f14e9f46a7f99f45285409cdd8d', 'baaa', 1283847658), > (44, 'd5c1769fbc6cadd32aeac0c17436cd14', 'what is a choice? its like a poll is it ? sorta.. choose your colour!
', 1283851485), > (45, '5dccfb23f40cc9c1f957cc705bc978a5', 'this is a test db
', 1283849880), > (46, '03b12196fe72b667df8e2be245fd65e7', '| magic number: | \r\n\r\n |
| modified: | \r\n\r\n |
| Author first name: | \r\n\r\n |
| Author surname: | \r\n\r\n |
| magic number: | \r\n\r\n |
| modified: | \r\n\r\n |
| magic number: | \r\n\r\n |
| modified: | \r\n\r\n |
| magic number: | \r\n\r\n |
| modified: | \r\n\r\n |
| magic number: | \r\n\r\n |
| modified: | \r\n\r\n |
| magic number: | \r\n\r\n |
| modified: | \r\n\r\n |
| magic number: | \r\n\r\n |
| modified: | \r\n\r\n |
| magic number: | \r\n\r\n |
| modified: | \r\n\r\n |
| Author first name: | \r\n\r\n |
| Author surname: | \r\n\r\n |
| magic number: | \r\n\r\n |
| modified: | \r\n\r\n |
| magic number: | \r\n\r\n |
| modified: | \r\n\r\n |
| Author first name: | \r\n\r\n |
| Author surname: | \r\n\r\n |
The bucket list. whats your bucket list?
', 1283850033), > (57, '1f5fa8cb731cc095fe73939a2ed0f41d', '@todo?
', 1283850202), > (58, '0e3b2685116884973f1495ab355f25ce', 'the reply link was so far out to the right! i couldn''t even see it with the horizontal scrollbars disabled!
', 1283850202), > (59, '47a0442d6bb45a7410f8e4b3187406fa', 'hrm testing is like killing onesself softly. hurry up and get back to coding..
', 1283850295), > (60, 'c2978305b4fe95efc5549d8b7e3d69b1', 'a lot of laid
', 1283850296), > (62, 'cc53ff23fbaca11973754517d6f4e274', 'is this the real life or is it just fantasy?
\r\nany memories of being stuck with no escape ... a landslide?
', 1283850619), > (65, 'dd2089e1d5325e7b7332d938f98c207f', 'close your eyes', 1283850620), > (66, '8d867f7b68ec9872f629fda75474559b', 'open your eyes', 1283850620), > (67, '0b9efb5468dd414859f5f574755315c2', 'back to the matrix for you.', 1283850631), > (68, 'f3a72515d778f325badb6f7f7ac7f33a', 'look up to the sky and see!', 1283850639), > (69, '7d3d0defb1a97e8ae4ef9646df47df35', 'this is a pop quiz. who invented pop?
', 1283851114), > (70, '3684546649cf90e6367c69017b85ab20', 'for real?
', 1283850686), > (71, '536c0218e0ff1d253a10aced067ed73f', 'must you do the vandango?
', 1283851136), > (74, '22e24de635640beef151cad77eeacc7e', 'very very frightening
', 1283851075), > (75, 'a6927a4afb3874a4605ebb0253f25564', 'very scared
', 1283851085), > (76, '5e9ee2a435908df134822ac87d3e38c6', 'asdfghjkl;
', 1283851097), > (77, 'b26b5501ebdbfe73f15555ac5a378a61', 'adfgdgsfdgsdfg
', 1283851217), > (78, '3f79920b73f09f332ea2bbdffcae61da', 'kiwi wiki?
', 1283851392), > (79, 'c5216d833c5d43976192913ec452477e', 'hail
wtf
', 1283851386), > (81, '1b93558e0dce389f4cb2bd9bc1df4ecd', 'this is a workshop .. sounds interesting...
', 1283851527), > (82, 'ad509c02da09d6d07a2968187f94be66', 'The workshop planner displays all phases of the activity and lists the tasks for each phase. The current phase is highlighted and task completion is indicated with a tick.
\n', 1283851551); 671d768 < DROP TABLE IF EXISTS `mdl_capabilities`; 1049d1145 < DROP TABLE IF EXISTS `mdl_chat`; 1063c1159 < ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Each of these is a chat room' AUTO_INCREMENT=1 ; --- > ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Each of these is a chat room' AUTO_INCREMENT=2 ; 1076d1171 < DROP TABLE IF EXISTS `mdl_chat_messages`; 1090c1185 < ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Stores all the actual chat messages' AUTO_INCREMENT=1 ; --- > ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Stores all the actual chat messages' AUTO_INCREMENT=10 ; 1103d1197 < DROP TABLE IF EXISTS `mdl_chat_messages_current`; 1117c1211 < ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Stores current session' AUTO_INCREMENT=1 ; --- > ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Stores current session' AUTO_INCREMENT=10 ; 1130d1223 < DROP TABLE IF EXISTS `mdl_chat_users`; 1149c1242 < ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Keeps track of which users are in which chat rooms' AUTO_INCREMENT=1 ; --- > ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Keeps track of which users are in which chat rooms' AUTO_INCREMENT=2 ; 1162d1254 < DROP TABLE IF EXISTS `mdl_choice`; 1180c1272 < ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Available choices are stored here' AUTO_INCREMENT=1 ; --- > ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Available choices are stored here' AUTO_INCREMENT=2 ; 1193d1284 < DROP TABLE IF EXISTS `mdl_choice_answers`; 1204c1295 < ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='choices performed by users' AUTO_INCREMENT=1 ; --- > ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='choices performed by users' AUTO_INCREMENT=2 ; 1217d1307 < DROP TABLE IF EXISTS `mdl_choice_options`; 1226c1316 < ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='available options to choice' AUTO_INCREMENT=1 ; --- > ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='available options to choice' AUTO_INCREMENT=9 ; 1239d1328 < DROP TABLE IF EXISTS `mdl_cohort`; 1265d1353 < DROP TABLE IF EXISTS `mdl_cohort_members`; 1288d1375 < DROP TABLE IF EXISTS `mdl_comments`; 1299c1386 < ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='moodle comments module' AUTO_INCREMENT=1 ; --- > ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='moodle comments module' AUTO_INCREMENT=2 ; 1304a1392,1393 > INSERT INTO `mdl_comments` (`id`, `contextid`, `commentarea`, `itemid`, `content`, `format`, `userid`, `timecreated`) VALUES > (1, 45, 'wiki_page', 1, 'wtf
', 1, 3, 1283851386); 1312d1400 < DROP TABLE IF EXISTS `mdl_config`; 1688d1775 < DROP TABLE IF EXISTS `mdl_config_log`; 2367d2453 < DROP TABLE IF EXISTS `mdl_config_plugins`; 2375c2461 < ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Moodle modules and plugins configuration variables' AUTO_INCREMENT=469 ; --- > ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Moodle modules and plugins configuration variables' AUTO_INCREMENT=470 ; 2809c2895,2896 < (468, 'enrol_self', 'roleid', '5'); --- > (468, 'enrol_self', 'roleid', '5'), > (469, 'enrol_ldap', 'objectclass', '(objectClass=*)'); 2817d2903 < DROP TABLE IF EXISTS `mdl_context`; 2828c2914 < ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='one of these must be set' AUTO_INCREMENT=14 ; --- > ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='one of these must be set' AUTO_INCREMENT=51 ; 2847c2933,2934 < (13, 30, 2, '/1/13', 2); --- > (13, 30, 2, '/1/13', 2), > (50, 30, 3, '/1/50', 2); 2855d2941 < DROP TABLE IF EXISTS `mdl_context_temp`; 2874d2959 < DROP TABLE IF EXISTS `mdl_course`; 2913c2998 < ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Central course table' AUTO_INCREMENT=2 ; --- > ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Central course table' AUTO_INCREMENT=3 ; 2928d3012 < DROP TABLE IF EXISTS `mdl_course_allowed_modules`; 2949d3032 < DROP TABLE IF EXISTS `mdl_course_categories`; 2981d3063 < DROP TABLE IF EXISTS `mdl_course_completions`; 3009d3090 < DROP TABLE IF EXISTS `mdl_course_completion_aggr_methd`; 3032d3112 < DROP TABLE IF EXISTS `mdl_course_completion_criteria`; 3059d3138 < DROP TABLE IF EXISTS `mdl_course_completion_crit_compl`; 3087d3165 < DROP TABLE IF EXISTS `mdl_course_completion_notify`; 3109d3186 < DROP TABLE IF EXISTS `mdl_course_display`; 3117c3194 < ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Stores info about how to display the course' AUTO_INCREMENT=1 ; --- > ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Stores info about how to display the course' AUTO_INCREMENT=3 ; 3122a3200,3202 > INSERT INTO `mdl_course_display` (`id`, `course`, `userid`, `display`) VALUES > (1, 2, 2, 0), > (2, 2, 3, 0); 3130d3209 < DROP TABLE IF EXISTS `mdl_course_modules`; 3160c3239 < ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='course_modules table retrofitted from MySQL' AUTO_INCREMENT=1 ; --- > ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='course_modules table retrofitted from MySQL' AUTO_INCREMENT=26 ; 3173d3251 < DROP TABLE IF EXISTS `mdl_course_modules_availability`; 3199d3276 < DROP TABLE IF EXISTS `mdl_course_modules_completion`; 3223d3299 < DROP TABLE IF EXISTS `mdl_course_published`; 3247d3322 < DROP TABLE IF EXISTS `mdl_course_request`; 3272d3346 < DROP TABLE IF EXISTS `mdl_course_sections`; 3284c3358 < ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='to define the sections for each course' AUTO_INCREMENT=1 ; --- > ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='to define the sections for each course' AUTO_INCREMENT=13 ; 3289a3364,3365 > INSERT INTO `mdl_course_sections` (`id`, `course`, `section`, `name`, `summary`, `summaryformat`, `sequence`, `visible`) VALUES > (12, 1, 0, NULL, '', 1, '', 1); 3297d3372 < DROP TABLE IF EXISTS `mdl_customlang`; 3326d3400 < DROP TABLE IF EXISTS `mdl_customlang_components`; 3345d3418 < DROP TABLE IF EXISTS `mdl_data`; 3382c3455 < ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Removed ratings column' AUTO_INCREMENT=1 ; --- > ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Removed ratings column' AUTO_INCREMENT=2 ; 3395d3467 < DROP TABLE IF EXISTS `mdl_data_content`; 3408c3480 < ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='the content introduced in each record/fields' AUTO_INCREMENT=1 ; --- > ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='the content introduced in each record/fields' AUTO_INCREMENT=15 ; 3421d3492 < DROP TABLE IF EXISTS `mdl_data_fields`; 3441c3512 < ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='every field available' AUTO_INCREMENT=1 ; --- > ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='every field available' AUTO_INCREMENT=3 ; 3454d3524 < DROP TABLE IF EXISTS `mdl_data_records`; 3465c3535 < ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='every record introduced' AUTO_INCREMENT=1 ; --- > ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='every record introduced' AUTO_INCREMENT=8 ; 3478d3547 < DROP TABLE IF EXISTS `mdl_enrol`; 3511c3580 < ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Instances of enrolment plugins used in courses, fields marke' AUTO_INCREMENT=1 ; --- > ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Instances of enrolment plugins used in courses, fields marke' AUTO_INCREMENT=4 ; 3516a3586,3589 > INSERT INTO `mdl_enrol` (`id`, `enrol`, `status`, `courseid`, `sortorder`, `name`, `enrolperiod`, `enrolstartdate`, `enrolenddate`, `expirynotify`, `expirythreshold`, `notifyall`, `password`, `cost`, `currency`, `roleid`, `customint1`, `customint2`, `customint3`, `customint4`, `customchar1`, `customchar2`, `customdec1`, `customdec2`, `customtext1`, `customtext2`, `timecreated`, `timemodified`) VALUES > (1, 'manual', 0, 2, 0, NULL, 0, 0, 0, 0, 0, 0, NULL, NULL, NULL, 5, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1283750816, 1283846670), > (2, 'guest', 1, 2, 1, NULL, 0, 0, 0, 0, 0, 0, 'remnants', NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1283750816, 1283846496), > (3, 'self', 1, 2, 2, NULL, 0, 0, 0, 0, 0, 0, NULL, NULL, NULL, 5, 0, 0, 0, 1, NULL, NULL, NULL, NULL, NULL, NULL, 1283750816, 1283750816); 3524d3596 < DROP TABLE IF EXISTS `mdl_enrol_authorize`; 3557d3628 < DROP TABLE IF EXISTS `mdl_enrol_authorize_refunds`; 3581d3651 < DROP TABLE IF EXISTS `mdl_enrol_paypal`; 3618d3687 < DROP TABLE IF EXISTS `mdl_event`; 3643c3712 < ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='For everything with a time associated to it' AUTO_INCREMENT=1 ; --- > ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='For everything with a time associated to it' AUTO_INCREMENT=6 ; 3656d3724 < DROP TABLE IF EXISTS `mdl_events_handlers`; 3675c3743 < (2, 'user_enrolled', 'mod_forum', '/mod/forum/lib.php', 's:19:"forum_user_enrolled";', 'instant', 0), --- > (2, 'user_enrolled', 'mod_forum', '/mod/forum/lib.php', 's:19:"forum_user_enrolled";', 'instant', 1), 3696d3763 < DROP TABLE IF EXISTS `mdl_events_queue`; 3705c3772 < ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='This table is for storing queued events. It stores only one ' AUTO_INCREMENT=1 ; --- > ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='This table is for storing queued events. It stores only one ' AUTO_INCREMENT=2 ; 3710a3778,3779 > INSERT INTO `mdl_events_queue` (`id`, `eventdata`, `stackdump`, `userid`, `timecreated`) VALUES > (1, 'Tzo2OiJvYmplY3QiOjExOntzOjc6ImVucm9saWQiO3M6MToiMSI7czo2OiJzdGF0dXMiO2k6MDtzOjY6InVzZXJpZCI7czoxOiIzIjtzOjk6InRpbWVzdGFydCI7aToxMjgzNzg4ODAwO3M6NzoidGltZWVuZCI7aTowO3M6ODoibW9kaWZpZXIiO3M6MToiMiI7czoxMToidGltZWNyZWF0ZWQiO2k6MTI4Mzg0Njg1OTtzOjEyOiJ0aW1lbW9kaWZpZWQiO2k6MTI4Mzg0Njg1OTtzOjI6ImlkIjtpOjE7czo4OiJjb3Vyc2VpZCI7czoxOiIyIjtzOjU6ImVucm9sIjtzOjY6Im1hbnVhbCI7fQ==', '', 2, 1283846859); 3718d3786 < DROP TABLE IF EXISTS `mdl_events_queue_handlers`; 3729c3797 < ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='This is the list of queued handlers for processing. The even' AUTO_INCREMENT=1 ; --- > ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='This is the list of queued handlers for processing. The even' AUTO_INCREMENT=2 ; 3734a3803,3804 > INSERT INTO `mdl_events_queue_handlers` (`id`, `queuedeventid`, `handlerid`, `status`, `errormessage`, `timemodified`) VALUES > (1, 1, 2, 0, 'Unknown error', 1283846859); 3742d3811 < DROP TABLE IF EXISTS `mdl_external_functions`; 3785d3853 < DROP TABLE IF EXISTS `mdl_external_services`; 3810d3877 < DROP TABLE IF EXISTS `mdl_external_services_functions`; 3830d3896 < DROP TABLE IF EXISTS `mdl_external_services_users`; 3854d3919 < DROP TABLE IF EXISTS `mdl_external_tokens`; 3886d3950 < DROP TABLE IF EXISTS `mdl_feedback`; 3919d3982 < DROP TABLE IF EXISTS `mdl_feedback_completed`; 3943d4005 < DROP TABLE IF EXISTS `mdl_feedback_completedtmp`; 3968d4029 < DROP TABLE IF EXISTS `mdl_feedback_item`; 3999d4059 < DROP TABLE IF EXISTS `mdl_feedback_sitecourse_map`; 4020d4079 < DROP TABLE IF EXISTS `mdl_feedback_template`; 4041d4099 < DROP TABLE IF EXISTS `mdl_feedback_tracking`; 4065d4122 < DROP TABLE IF EXISTS `mdl_feedback_value`; 4089d4145 < DROP TABLE IF EXISTS `mdl_feedback_valuetmp`; 4113d4168 < DROP TABLE IF EXISTS `mdl_files`; 4140c4195 < ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='description of files, content is stored in sha1 file pool' AUTO_INCREMENT=1 ; --- > ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='description of files, content is stored in sha1 file pool' AUTO_INCREMENT=107 ; 4145a4201,4222 > INSERT INTO `mdl_files` (`id`, `contenthash`, `pathnamehash`, `contextid`, `component`, `filearea`, `itemid`, `filepath`, `filename`, `userid`, `filesize`, `mimetype`, `status`, `source`, `author`, `license`, `timecreated`, `timemodified`, `sortorder`) VALUES > (1, 'd827099d0f7a594a5e17773784bbf246c999ed93', '6a8163a375343a8b70fad3988e7323f83f89a03a', 13, 'user', 'draft', 403037261, '/', 'wip', 2, 49, 'document/unknown', 0, NULL, 'Admin User', 'allrightsreserved', 1283751036, 1283751036, 0), > (2, 'da39a3ee5e6b4b0d3255bfef95601890afd80709', 'f061a398e5c7410072342fd8164724ce3509547b', 13, 'user', 'draft', 403037261, '/', '.', 2, 0, NULL, 0, NULL, NULL, NULL, 1283751036, 1283751036, 0), > (5, 'da39a3ee5e6b4b0d3255bfef95601890afd80709', '2d0dadd4b24e960ab465bc2e7ea4e32f92fb74f6', 13, 'user', 'draft', 920741263, '/blank folder/', '.', NULL, 0, NULL, 0, NULL, NULL, NULL, 1283751125, 1283751125, 0), > (6, 'da39a3ee5e6b4b0d3255bfef95601890afd80709', 'b4521f954e01ed41b52606070361fee91cd4583d', 13, 'user', 'draft', 920741263, '/', '.', NULL, 0, NULL, 0, NULL, NULL, NULL, 1283751125, 1283751125, 0), > (11, 'ffade3ffc3192abcf9e9d0a98bbd6979165eaee8', 'ba05bc99a76e76ade105b37888b1c544b85cb06b', 13, 'user', 'draft', 619081671, '/', 'E500_10_imscp.zip', 2, 531617, 'application/zip', 0, NULL, 'Admin User', 'allrightsreserved', 1283753419, 1283753419, 0), > (12, 'da39a3ee5e6b4b0d3255bfef95601890afd80709', '987f2dfb57bd4bbabc78de7f33f1e511cddc77f1', 13, 'user', 'draft', 619081671, '/', '.', 2, 0, NULL, 0, NULL, NULL, NULL, 1283753419, 1283753419, 0), > (50, '7cd7ba3dbb7b32964d7373e7a55c61095d78fba0', '235ce67c3da4c2d2075cc55fe9d4e0b66a5612b6', 13, 'user', 'draft', 422394633, '/', 'moodle_freshm20fresh-justinstalled.sql', 2, 474363, 'document/unknown', 0, NULL, 'Admin User', 'allrightsreserved', 1283756195, 1283756195, 0), > (51, 'da39a3ee5e6b4b0d3255bfef95601890afd80709', 'b8baff30913bb2cfa5211fa4f79dd4e57ede0eeb', 13, 'user', 'draft', 422394633, '/', '.', 2, 0, NULL, 0, NULL, NULL, NULL, 1283756195, 1283756195, 0), > (54, 'b3a281fb410bde6a2a0258e70020269e8d5470fa', '1e87003f4b788db6496a44b594413e97b200a355', 13, 'user', 'draft', 108342457, '/', 'E500_13_scorm.zip', 2, 2046119, 'application/zip', 0, NULL, 'Admin User', 'allrightsreserved', 1283756707, 1283756707, 0), > (55, 'da39a3ee5e6b4b0d3255bfef95601890afd80709', '7ee44f551cfd8287e4aa4a6e040e5d5ce0a357da', 13, 'user', 'draft', 108342457, '/', '.', 2, 0, NULL, 0, NULL, NULL, NULL, 1283756707, 1283756707, 0), > (85, 'b9a28b6b71a11237a536863ed7c1e730c7be8bd1', 'acb5d1ba3cf222675b7b637bca87c08e233a1101', 50, 'user', 'draft', 516001394, '/', 'moodle_freshm20fresh-coursewiththeLot.sql', 3, 585112, 'document/unknown', 0, NULL, 'Terry Smart', 'allrightsreserved', 1283846935, 1283846935, 0), > (86, 'da39a3ee5e6b4b0d3255bfef95601890afd80709', '5eb80503881f881ce5ff1d64efd0c1c2f87fbab7', 50, 'user', 'draft', 516001394, '/', '.', 3, 0, NULL, 0, NULL, NULL, NULL, 1283846935, 1283846935, 0), > (87, '7cd7ba3dbb7b32964d7373e7a55c61095d78fba0', 'c32e202480293972d11ccb657a331e7d3bddd426', 50, 'user', 'draft', 516001394, '/', 'moodle_freshm20fresh-justinstalled.sql', 3, 474363, 'document/unknown', 0, NULL, 'Terry Smart', 'allrightsreserved', 1283846945, 1283846945, 0), > (91, '925bd24a7456608424cd36e35a0e7127de41a014', 'e670e0442b2efa68a286186668edca9f0ca2a391', 50, 'user', 'draft', 984172182, '/', 'IMG_1417.JPG', 3, 779803, 'image/jpeg', 0, NULL, 'Terry Smart', 'allrightsreserved', 1283847063, 1283847063, 0), > (92, 'da39a3ee5e6b4b0d3255bfef95601890afd80709', 'd52c7c1ddeb73212747f907c1e0cd20455aad6bc', 50, 'user', 'draft', 984172182, '/', '.', 3, 0, NULL, 0, NULL, NULL, NULL, 1283847063, 1283847063, 0), > (95, '26608975a3918d7b7c9ee287f932d271c4112742', '8e09d11a7b130328ef07d805bfc0483a4516add7', 13, 'user', 'draft', 935643671, '/', 'IMG_1413.JPG', 2, 555832, 'image/jpeg', 0, NULL, 'Admin User', 'allrightsreserved', 1283850022, 1283850022, 0), > (96, 'da39a3ee5e6b4b0d3255bfef95601890afd80709', '2ab413397e460067df66db0154c9a6c7fd3eba19', 13, 'user', 'draft', 935643671, '/', '.', 2, 0, NULL, 0, NULL, NULL, NULL, 1283850022, 1283850022, 0), > (99, '4500cafe027b1ad6961fb9403fad2f923dc038c3', 'c4b4063d7723a4a5690dc5ea41c58e2fb40bf1c6', 50, 'user', 'draft', 394705970, '/', 'IMG_1433.JPG', 3, 512546, 'image/jpeg', 0, NULL, 'Terry Smart', 'allrightsreserved', 1283850195, 1283850195, 0), > (100, 'da39a3ee5e6b4b0d3255bfef95601890afd80709', 'af1cebc7a09fab996c16a5ba051f8a546d0033ca', 50, 'user', 'draft', 394705970, '/', '.', 3, 0, NULL, 0, NULL, NULL, NULL, 1283850195, 1283850195, 0), > (103, '6473c0299fe55ff6b8fb9c811c1d883a9ba9382a', '9bb42b2fb3fa34969132a1458b1cc34e95cf43d7', 50, 'user', 'draft', 423784645, '/', 'IMG_1881.JPG', 3, 505769, 'image/jpeg', 0, NULL, 'Terry Smart', 'allrightsreserved', 1283850292, 1283850292, 0), > (104, 'da39a3ee5e6b4b0d3255bfef95601890afd80709', '289d9de0d6f776bc1a7675c2437141f10aa5a99d', 50, 'user', 'draft', 423784645, '/', '.', 3, 0, NULL, 0, NULL, NULL, NULL, 1283850292, 1283850292, 0); 4153d4229 < DROP TABLE IF EXISTS `mdl_filter_active`; 4178d4253 < DROP TABLE IF EXISTS `mdl_filter_config`; 4201d4275 < DROP TABLE IF EXISTS `mdl_folder`; 4212c4286 < ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='each record is one folder resource' AUTO_INCREMENT=1 ; --- > ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='each record is one folder resource' AUTO_INCREMENT=2 ; 4225d4298 < DROP TABLE IF EXISTS `mdl_forum`; 4252c4325 < ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Forums contain and structure discussion' AUTO_INCREMENT=1 ; --- > ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Forums contain and structure discussion' AUTO_INCREMENT=3 ; 4265d4337 < DROP TABLE IF EXISTS `mdl_forum_discussions`; 4282c4354 < ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Forums are composed of discussions' AUTO_INCREMENT=1 ; --- > ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Forums are composed of discussions' AUTO_INCREMENT=2 ; 4295d4366 < DROP TABLE IF EXISTS `mdl_forum_posts`; 4317c4388 < ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='All posts are stored in this table' AUTO_INCREMENT=1 ; --- > ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='All posts are stored in this table' AUTO_INCREMENT=3 ; 4330d4400 < DROP TABLE IF EXISTS `mdl_forum_queue`; 4354d4423 < DROP TABLE IF EXISTS `mdl_forum_read`; 4380d4448 < DROP TABLE IF EXISTS `mdl_forum_subscriptions`; 4401d4468 < DROP TABLE IF EXISTS `mdl_forum_track_prefs`; 4421d4487 < DROP TABLE IF EXISTS `mdl_glossary`; 4451c4517 < ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='all glossaries' AUTO_INCREMENT=1 ; --- > ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='all glossaries' AUTO_INCREMENT=2 ; 4464d4529 < DROP TABLE IF EXISTS `mdl_glossary_alias`; 4471c4536 < ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='entries alias' AUTO_INCREMENT=1 ; --- > ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='entries alias' AUTO_INCREMENT=2 ; 4484d4548 < DROP TABLE IF EXISTS `mdl_glossary_categories`; 4505d4568 < DROP TABLE IF EXISTS `mdl_glossary_entries`; 4527c4590 < ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='all glossary entries' AUTO_INCREMENT=1 ; --- > ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='all glossary entries' AUTO_INCREMENT=2 ; 4532a4596,4597 > INSERT INTO `mdl_glossary_entries` (`id`, `glossaryid`, `userid`, `concept`, `definition`, `definitionformat`, `definitiontrust`, `attachment`, `timecreated`, `timemodified`, `teacherentry`, `sourceglossaryid`, `usedynalink`, `casesensitive`, `fullmatch`, `approved`) VALUES > (1, 1, 3, 'late', 'a lot of laid
', 1, 0, '1', 1283850294, 1283850294, 0, 0, 0, 0, 0, 0); 4540d4604 < DROP TABLE IF EXISTS `mdl_glossary_entries_categories`; 4561d4624 < DROP TABLE IF EXISTS `mdl_glossary_formats`; 4594d4656 < DROP TABLE IF EXISTS `mdl_grade_categories`; 4613c4675 < ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='This table keeps information about categories, used for grou' AUTO_INCREMENT=1 ; --- > ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='This table keeps information about categories, used for grou' AUTO_INCREMENT=2 ; 4626d4687 < DROP TABLE IF EXISTS `mdl_grade_categories_history`; 4651c4712 < ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='History of grade_categories' AUTO_INCREMENT=1 ; --- > ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='History of grade_categories' AUTO_INCREMENT=21 ; 4656a4718,4738 > INSERT INTO `mdl_grade_categories_history` (`id`, `action`, `oldid`, `source`, `timemodified`, `loggeduser`, `courseid`, `parent`, `depth`, `path`, `fullname`, `aggregation`, `keephigh`, `droplow`, `aggregateonlygraded`, `aggregateoutcomes`, `aggregatesubcats`) VALUES > (1, 1, 1, 'system', 1283751073, NULL, 2, NULL, 0, NULL, '?', 11, 0, 0, 1, 0, 0), > (2, 2, 1, 'system', 1283751073, NULL, 2, NULL, 1, '/1/', '?', 11, 0, 0, 1, 0, 0), > (3, 2, 1, NULL, 1283754391, NULL, 2, NULL, 1, '/1/', '?', 11, 0, 0, 1, 0, 0), > (4, 2, 1, NULL, 1283754504, NULL, 2, NULL, 1, '/1/', '?', 11, 0, 0, 1, 0, 0), > (5, 2, 1, NULL, 1283754611, NULL, 2, NULL, 1, '/1/', '?', 11, 0, 0, 1, 0, 0), > (6, 2, 1, NULL, 1283754627, NULL, 2, NULL, 1, '/1/', '?', 11, 0, 0, 1, 0, 0), > (7, 2, 1, NULL, 1283755585, NULL, 2, NULL, 1, '/1/', '?', 11, 0, 0, 1, 0, 0), > (8, 2, 1, NULL, 1283755841, NULL, 2, NULL, 1, '/1/', '?', 11, 0, 0, 1, 0, 0), > (9, 2, 1, NULL, 1283755857, NULL, 2, NULL, 1, '/1/', '?', 11, 0, 0, 1, 0, 0), > (10, 2, 1, NULL, 1283756029, NULL, 2, NULL, 1, '/1/', '?', 11, 0, 0, 1, 0, 0), > (11, 2, 1, NULL, 1283756229, NULL, 2, NULL, 1, '/1/', '?', 11, 0, 0, 1, 0, 0), > (12, 2, 1, NULL, 1283756638, NULL, 2, NULL, 1, '/1/', '?', 11, 0, 0, 1, 0, 0), > (13, 2, 1, NULL, 1283756958, NULL, 2, NULL, 1, '/1/', '?', 11, 0, 0, 1, 0, 0), > (14, 2, 1, NULL, 1283845517, NULL, 2, NULL, 1, '/1/', '?', 11, 0, 0, 1, 0, 0), > (15, 2, 1, NULL, 1283846012, NULL, 2, NULL, 1, '/1/', '?', 11, 0, 0, 1, 0, 0), > (16, 2, 1, NULL, 1283849808, NULL, 2, NULL, 1, '/1/', '?', 11, 0, 0, 1, 0, 0), > (17, 2, 1, NULL, 1283850926, NULL, 2, NULL, 1, '/1/', '?', 11, 0, 0, 1, 0, 0), > (18, 2, 1, NULL, 1283851016, NULL, 2, NULL, 1, '/1/', '?', 11, 0, 0, 1, 0, 0), > (19, 2, 1, NULL, 1283851056, NULL, 2, NULL, 1, '/1/', '?', 11, 0, 0, 1, 0, 0), > (20, 3, 1, 'coursedelete', 1283851598, NULL, 2, NULL, 1, '/1/', '?', 11, 0, 0, 1, 0, 0); 4664d4745 < DROP TABLE IF EXISTS `mdl_grade_grades`; 4694c4775 < ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='grade_grades This table keeps individual grades for each us' AUTO_INCREMENT=1 ; --- > ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='grade_grades This table keeps individual grades for each us' AUTO_INCREMENT=7 ; 4707d4787 < DROP TABLE IF EXISTS `mdl_grade_grades_history`; 4741c4821 < ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='History table' AUTO_INCREMENT=1 ; --- > ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='History table' AUTO_INCREMENT=16 ; 4746a4827,4842 > INSERT INTO `mdl_grade_grades_history` (`id`, `action`, `oldid`, `source`, `timemodified`, `loggeduser`, `itemid`, `userid`, `rawgrade`, `rawgrademax`, `rawgrademin`, `rawscaleid`, `usermodified`, `finalgrade`, `hidden`, `locked`, `locktime`, `exported`, `overridden`, `excluded`, `feedback`, `feedbackformat`, `information`, `informationformat`) VALUES > (1, 1, 1, 'mod/assignment', 1283846948, NULL, 2, 3, NULL, '3.00000', '1.00000', 1, 3, NULL, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0), > (2, 1, 2, 'system', 1283846948, NULL, 1, 3, NULL, '100.00000', '0.00000', NULL, NULL, NULL, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0), > (3, 1, 3, 'mod/assignment', 1283847066, NULL, 4, 3, NULL, '3.00000', '1.00000', 1, 3, NULL, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0), > (4, 1, 4, 'mod/lesson', 1283850513, NULL, 9, 3, '0.00000', '100.00000', '0.00000', NULL, 3, '0.00000', 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0), > (5, 2, 2, 'aggregation', 1283850513, NULL, 1, 3, NULL, '100.00000', '0.00000', NULL, NULL, '0.00000', 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0), > (6, 1, 5, 'mod/quiz', 1283851136, NULL, 10, 3, '10.00000', '10.00000', '0.00000', NULL, 3, '10.00000', 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0), > (7, 2, 2, 'aggregation', 1283851136, NULL, 1, 3, NULL, '100.00000', '0.00000', NULL, NULL, '9.09091', 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0), > (8, 1, 6, 'mod/scorm', 1283851159, NULL, 11, 3, '0.00000', '83.00000', '0.00000', NULL, 3, '0.00000', 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0), > (9, 2, 2, 'aggregation', 1283851159, NULL, 1, 3, NULL, '100.00000', '0.00000', NULL, NULL, '5.18135', 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0), > (10, 3, 1, 'coursedelete', 1283851595, NULL, 2, 3, NULL, '3.00000', '1.00000', 1, 3, NULL, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0), > (11, 3, 3, 'coursedelete', 1283851595, NULL, 4, 3, NULL, '3.00000', '1.00000', 1, 3, NULL, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0), > (12, 3, 4, 'coursedelete', 1283851596, NULL, 9, 3, '0.00000', '100.00000', '0.00000', NULL, 3, '0.00000', 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0), > (13, 3, 5, 'coursedelete', 1283851596, NULL, 10, 3, '10.00000', '10.00000', '0.00000', NULL, 3, '10.00000', 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0), > (14, 3, 6, 'coursedelete', 1283851597, NULL, 11, 3, '0.00000', '83.00000', '0.00000', NULL, 3, '0.00000', 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0), > (15, 3, 2, 'coursedelete', 1283851598, NULL, 1, 3, NULL, '100.00000', '0.00000', NULL, NULL, '5.18135', 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0); 4754d4849 < DROP TABLE IF EXISTS `mdl_grade_import_newitem`; 4775d4869 < DROP TABLE IF EXISTS `mdl_grade_import_values`; 4802d4895 < DROP TABLE IF EXISTS `mdl_grade_items`; 4842c4935 < ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='This table keeps information about gradeable items (ie colum' AUTO_INCREMENT=1 ; --- > ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='This table keeps information about gradeable items (ie colum' AUTO_INCREMENT=20 ; 4855d4947 < DROP TABLE IF EXISTS `mdl_grade_items_history`; 4895c4987 < ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='History of grade_items' AUTO_INCREMENT=1 ; --- > ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='History of grade_items' AUTO_INCREMENT=97 ; 4900a4993,5089 > INSERT INTO `mdl_grade_items_history` (`id`, `action`, `oldid`, `source`, `timemodified`, `loggeduser`, `courseid`, `categoryid`, `itemname`, `itemtype`, `itemmodule`, `iteminstance`, `itemnumber`, `iteminfo`, `idnumber`, `calculation`, `gradetype`, `grademax`, `grademin`, `scaleid`, `outcomeid`, `gradepass`, `multfactor`, `plusfactor`, `aggregationcoef`, `sortorder`, `hidden`, `locked`, `locktime`, `needsupdate`) VALUES > (1, 1, 1, 'system', 1283751073, NULL, 2, NULL, NULL, 'course', NULL, 1, NULL, NULL, NULL, NULL, 1, '100.00000', '0.00000', NULL, NULL, '0.00000', '1.00000', '0.00000', '0.00000', 1, 0, 0, 0, 1), > (2, 1, 2, NULL, 1283754391, NULL, 2, 1, '--- remnants test -- act:adv upload', 'mod', 'assignment', 1, 0, NULL, '3676754', NULL, 2, '3.00000', '1.00000', 1, NULL, '0.00000', '1.00000', '0.00000', '0.00000', 2, 0, 0, 0, 1), > (3, 2, 2, NULL, 1283754391, NULL, 2, 1, '--- remnants test -- act:adv upload', 'mod', 'assignment', 1, 0, NULL, '3676754', NULL, 2, '3.00000', '1.00000', 1, NULL, '0.00000', '1.00000', '0.00000', '0.00000', 2, 0, 0, 0, 1), > (4, 2, 1, NULL, 1283754391, NULL, 2, NULL, NULL, 'course', NULL, 1, NULL, NULL, NULL, NULL, 1, '100.00000', '0.00000', NULL, NULL, '0.00000', '1.00000', '0.00000', '0.00000', 1, 0, 0, 0, 1), > (5, 1, 3, NULL, 1283754504, NULL, 2, 1, 'remnants online assignment test', 'mod', 'assignment', 2, 0, NULL, '111111', NULL, 1, '96.00000', '0.00000', NULL, NULL, '0.00000', '1.00000', '0.00000', '0.00000', 3, 0, 0, 0, 1), > (6, 2, 3, NULL, 1283754504, NULL, 2, 1, 'remnants online assignment test', 'mod', 'assignment', 2, 0, NULL, '111111', NULL, 1, '96.00000', '0.00000', NULL, NULL, '0.00000', '1.00000', '0.00000', '0.00000', 3, 0, 0, 0, 1), > (7, 2, 1, NULL, 1283754504, NULL, 2, NULL, NULL, 'course', NULL, 1, NULL, NULL, NULL, NULL, 1, '100.00000', '0.00000', NULL, NULL, '0.00000', '1.00000', '0.00000', '0.00000', 1, 0, 0, 0, 1), > (8, 1, 4, NULL, 1283754610, NULL, 2, 1, 'remnants test - activity upload single file', 'mod', 'assignment', 3, 0, NULL, '25624356354', NULL, 2, '3.00000', '1.00000', 1, NULL, '0.00000', '1.00000', '0.00000', '0.00000', 4, 0, 0, 0, 1), > (9, 2, 4, NULL, 1283754611, NULL, 2, 1, 'remnants test - activity upload single file', 'mod', 'assignment', 3, 0, NULL, '25624356354', NULL, 2, '3.00000', '1.00000', 1, NULL, '0.00000', '1.00000', '0.00000', '0.00000', 4, 0, 0, 0, 1), > (10, 2, 1, NULL, 1283754611, NULL, 2, NULL, NULL, 'course', NULL, 1, NULL, NULL, NULL, NULL, 1, '100.00000', '0.00000', NULL, NULL, '0.00000', '1.00000', '0.00000', '0.00000', 1, 0, 0, 0, 1), > (11, 2, 4, NULL, 1283754627, NULL, 2, 1, 'remnants test - activity upload single file', 'mod', 'assignment', 3, 0, NULL, '25624356354', NULL, 2, '3.00000', '1.00000', 1, NULL, '0.00000', '1.00000', '0.00000', '0.00000', 4, 0, 0, 0, 0), > (12, 2, 1, NULL, 1283754627, NULL, 2, NULL, NULL, 'course', NULL, 1, NULL, NULL, NULL, NULL, 1, '100.00000', '0.00000', NULL, NULL, '0.00000', '1.00000', '0.00000', '0.00000', 1, 0, 0, 0, 0), > (13, 1, 5, NULL, 1283754718, NULL, 2, 1, 'remnants test - offline assignment', 'mod', 'assignment', 4, 0, NULL, '123452432332', NULL, 1, '100.00000', '0.00000', NULL, NULL, '0.00000', '1.00000', '0.00000', '0.00000', 5, 0, 0, 0, 1), > (14, 2, 5, NULL, 1283754718, NULL, 2, 1, 'remnants test - offline assignment', 'mod', 'assignment', 4, 0, NULL, '123452432332', NULL, 1, '100.00000', '0.00000', NULL, NULL, '0.00000', '1.00000', '0.00000', '0.00000', 5, 1, 0, 0, 1), > (15, 1, 6, NULL, 1283755585, NULL, 2, 1, 'remnants test - database activity', 'mod', 'data', 1, 0, NULL, '376456', NULL, 1, '50.00000', '0.00000', NULL, NULL, '0.00000', '1.00000', '0.00000', '0.00000', 6, 0, 0, 0, 1), > (16, 2, 6, NULL, 1283755585, NULL, 2, 1, 'remnants test - database activity', 'mod', 'data', 1, 0, NULL, '376456', NULL, 1, '50.00000', '0.00000', NULL, NULL, '0.00000', '1.00000', '0.00000', '0.00000', 6, 0, 0, 0, 1), > (17, 2, 1, NULL, 1283755585, NULL, 2, NULL, NULL, 'course', NULL, 1, NULL, NULL, NULL, NULL, 1, '100.00000', '0.00000', NULL, NULL, '0.00000', '1.00000', '0.00000', '0.00000', 1, 0, 0, 0, 1), > (18, 1, 7, NULL, 1283755841, NULL, 2, 1, 'remnants test for forum activity', 'mod', 'forum', 2, 0, NULL, '', NULL, 1, '77.00000', '0.00000', NULL, NULL, '0.00000', '1.00000', '0.00000', '0.00000', 7, 0, 0, 0, 1), > (19, 2, 7, NULL, 1283755841, NULL, 2, 1, 'remnants test for forum activity', 'mod', 'forum', 2, 0, NULL, '', NULL, 1, '77.00000', '0.00000', NULL, NULL, '0.00000', '1.00000', '0.00000', '0.00000', 7, 0, 0, 0, 1), > (20, 2, 1, NULL, 1283755841, NULL, 2, NULL, NULL, 'course', NULL, 1, NULL, NULL, NULL, NULL, 1, '100.00000', '0.00000', NULL, NULL, '0.00000', '1.00000', '0.00000', '0.00000', 1, 0, 0, 0, 1), > (21, 2, 7, NULL, 1283755857, NULL, 2, 1, 'remnants test for forum activity', 'mod', 'forum', 2, 0, NULL, '34rf', NULL, 1, '77.00000', '0.00000', NULL, NULL, '0.00000', '1.00000', '0.00000', '0.00000', 7, 0, 0, 0, 0), > (22, 2, 7, NULL, 1283755857, NULL, 2, 1, 'remnants test for forum activity', 'mod', 'forum', 2, 0, NULL, '34rf', NULL, 1, '77.00000', '0.00000', NULL, NULL, '0.00000', '1.00000', '0.00000', '0.00000', 7, 0, 0, 0, 0), > (23, 2, 1, NULL, 1283755857, NULL, 2, NULL, NULL, 'course', NULL, 1, NULL, NULL, NULL, NULL, 1, '100.00000', '0.00000', NULL, NULL, '0.00000', '1.00000', '0.00000', '0.00000', 1, 0, 0, 0, 0), > (24, 1, 8, NULL, 1283756028, NULL, 2, 1, 'remnants test glooooossary', 'mod', 'glossary', 1, 0, NULL, '67272727272727', NULL, 1, '100.00000', '0.00000', NULL, NULL, '0.00000', '1.00000', '0.00000', '0.00000', 8, 0, 0, 0, 1), > (25, 2, 8, NULL, 1283756029, NULL, 2, 1, 'remnants test glooooossary', 'mod', 'glossary', 1, 0, NULL, '67272727272727', NULL, 1, '100.00000', '0.00000', NULL, NULL, '0.00000', '1.00000', '0.00000', '0.00000', 8, 0, 0, 0, 1), > (26, 2, 1, NULL, 1283756029, NULL, 2, NULL, NULL, 'course', NULL, 1, NULL, NULL, NULL, NULL, 1, '100.00000', '0.00000', NULL, NULL, '0.00000', '1.00000', '0.00000', '0.00000', 1, 0, 0, 0, 1), > (27, 1, 9, NULL, 1283756228, NULL, 2, 1, 'remnants test - activity : Lesson', 'mod', 'lesson', 1, 0, NULL, '198165', NULL, 1, '100.00000', '0.00000', NULL, NULL, '0.00000', '1.00000', '0.00000', '0.00000', 9, 0, 0, 0, 1), > (28, 2, 9, NULL, 1283756229, NULL, 2, 1, 'remnants test - activity : Lesson', 'mod', 'lesson', 1, 0, NULL, '198165', NULL, 1, '100.00000', '0.00000', NULL, NULL, '0.00000', '1.00000', '0.00000', '0.00000', 9, 0, 0, 0, 1), > (29, 2, 1, NULL, 1283756229, NULL, 2, NULL, NULL, 'course', NULL, 1, NULL, NULL, NULL, NULL, 1, '100.00000', '0.00000', NULL, NULL, '0.00000', '1.00000', '0.00000', '0.00000', 1, 0, 0, 0, 1), > (30, 1, 10, NULL, 1283756638, NULL, 2, 1, 'remnants testing - a quiz in activity', 'mod', 'quiz', 1, 0, NULL, 'ofglviyvh', NULL, 1, '10.00000', '0.00000', NULL, NULL, '0.00000', '1.00000', '0.00000', '0.00000', 10, 1283637900, 0, 0, 1), > (31, 2, 10, NULL, 1283756638, NULL, 2, 1, 'remnants testing - a quiz in activity', 'mod', 'quiz', 1, 0, NULL, 'ofglviyvh', NULL, 1, '10.00000', '0.00000', NULL, NULL, '0.00000', '1.00000', '0.00000', '0.00000', 10, 0, 0, 0, 1), > (32, 2, 1, NULL, 1283756638, NULL, 2, NULL, NULL, 'course', NULL, 1, NULL, NULL, NULL, NULL, 1, '100.00000', '0.00000', NULL, NULL, '0.00000', '1.00000', '0.00000', '0.00000', 1, 0, 0, 0, 1), > (33, 1, 11, NULL, 1283756957, NULL, 2, 1, 'remnants testing a scrom pkg', 'mod', 'scorm', 1, 0, NULL, '846513204613285', NULL, 1, '83.00000', '0.00000', NULL, NULL, '0.00000', '1.00000', '0.00000', '0.00000', 11, 0, 0, 0, 1), > (34, 2, 11, NULL, 1283756958, NULL, 2, 1, 'remnants testing a scrom pkg', 'mod', 'scorm', 1, 0, NULL, '846513204613285', NULL, 1, '83.00000', '0.00000', NULL, NULL, '0.00000', '1.00000', '0.00000', '0.00000', 11, 0, 0, 0, 1), > (35, 2, 1, NULL, 1283756958, NULL, 2, NULL, NULL, 'course', NULL, 1, NULL, NULL, NULL, NULL, 1, '100.00000', '0.00000', NULL, NULL, '0.00000', '1.00000', '0.00000', '0.00000', 1, 0, 0, 0, 1), > (36, 1, 12, NULL, 1283757415, NULL, 2, 1, 'remnants test - a workshop . (submission)', 'mod', 'workshop', 1, 0, NULL, NULL, NULL, 1, '96.00000', '0.00000', NULL, NULL, '0.00000', '1.00000', '0.00000', '0.00000', 12, 0, 0, 0, 1), > (37, 1, 13, NULL, 1283757415, NULL, 2, 1, 'remnants test - a workshop . (assessment)', 'mod', 'workshop', 1, 1, NULL, NULL, NULL, 1, '37.00000', '0.00000', NULL, NULL, '0.00000', '1.00000', '0.00000', '0.00000', 13, 0, 0, 0, 1), > (38, 1, 14, NULL, 1283757796, NULL, 2, 1, 'remnantest testing a workshoip acitivity (submission)', 'mod', 'workshop', 2, 0, NULL, NULL, NULL, 1, '97.00000', '0.00000', NULL, NULL, '0.00000', '1.00000', '0.00000', '0.00000', 14, 0, 0, 0, 1), > (39, 1, 15, NULL, 1283757796, NULL, 2, 1, 'remnantest testing a workshoip acitivity (assessment)', 'mod', 'workshop', 2, 1, NULL, NULL, NULL, 1, '37.00000', '0.00000', NULL, NULL, '0.00000', '1.00000', '0.00000', '0.00000', 15, 0, 0, 0, 1), > (40, 1, 16, NULL, 1283757897, NULL, 2, 1, 'remnants test - a workshop . (submission)', 'mod', 'workshop', 3, 0, NULL, NULL, NULL, 1, '95.00000', '0.00000', NULL, NULL, '0.00000', '1.00000', '0.00000', '0.00000', 16, 0, 0, 0, 1), > (41, 1, 17, NULL, 1283757897, NULL, 2, 1, 'remnants test - a workshop . (assessment)', 'mod', 'workshop', 3, 1, NULL, NULL, NULL, 1, '34.00000', '0.00000', NULL, NULL, '0.00000', '1.00000', '0.00000', '0.00000', 17, 0, 0, 0, 1), > (42, 1, 18, NULL, 1283757944, NULL, 2, 1, 'remnants test - a workshop . (submission)', 'mod', 'workshop', 4, 0, NULL, NULL, NULL, 1, '80.00000', '0.00000', NULL, NULL, '0.00000', '1.00000', '0.00000', '0.00000', 18, 0, 0, 0, 1), > (43, 1, 19, NULL, 1283757944, NULL, 2, 1, 'remnants test - a workshop . (assessment)', 'mod', 'workshop', 4, 1, NULL, NULL, NULL, 1, '20.00000', '0.00000', NULL, NULL, '0.00000', '1.00000', '0.00000', '0.00000', 19, 0, 0, 0, 1), > (44, 2, 2, NULL, 1283845516, NULL, 2, 1, '--- remnants test -- act:adv upload', 'mod', 'assignment', 1, 0, NULL, '3676754', NULL, 2, '3.00000', '1.00000', 1, NULL, '0.00000', '1.00000', '0.00000', '0.00000', 2, 0, 0, 0, 0), > (45, 2, 1, NULL, 1283845516, NULL, 2, NULL, NULL, 'course', NULL, 1, NULL, NULL, NULL, NULL, 1, '100.00000', '0.00000', NULL, NULL, '0.00000', '1.00000', '0.00000', '0.00000', 1, 0, 0, 0, 1), > (46, 2, 2, NULL, 1283846012, NULL, 2, 1, '--- remnants test -- act:adv upload', 'mod', 'assignment', 1, 0, NULL, '3676754', NULL, 2, '3.00000', '1.00000', 1, NULL, '0.00000', '1.00000', '0.00000', '0.00000', 2, 0, 0, 0, 0), > (47, 2, 1, NULL, 1283846012, NULL, 2, NULL, NULL, 'course', NULL, 1, NULL, NULL, NULL, NULL, 1, '100.00000', '0.00000', NULL, NULL, '0.00000', '1.00000', '0.00000', '0.00000', 1, 0, 0, 0, 0), > (48, 2, 6, NULL, 1283849808, NULL, 2, 1, 'remnants test - database activity', 'mod', 'data', 1, 0, NULL, '376456', NULL, 1, '50.00000', '0.00000', NULL, NULL, '0.00000', '1.00000', '0.00000', '0.00000', 6, 0, 0, 0, 0), > (49, 2, 1, NULL, 1283849808, NULL, 2, NULL, NULL, 'course', NULL, 1, NULL, NULL, NULL, NULL, 1, '100.00000', '0.00000', NULL, NULL, '0.00000', '1.00000', '0.00000', '0.00000', 1, 0, 0, 0, 0), > (50, 2, 2, NULL, 1283850549, NULL, 2, 1, '--- remnants test -- act:adv upload', 'mod', 'assignment', 1, 0, NULL, '3676754', NULL, 2, '3.00000', '1.00000', 1, NULL, '0.00000', '1.00000', '0.00000', '0.00000', 1, 0, 0, 0, 0), > (51, 2, 3, NULL, 1283850549, NULL, 2, 1, 'remnants online assignment test', 'mod', 'assignment', 2, 0, NULL, '111111', NULL, 1, '96.00000', '0.00000', NULL, NULL, '0.00000', '1.00000', '0.00000', '0.00000', 2, 0, 0, 0, 0), > (52, 2, 4, NULL, 1283850549, NULL, 2, 1, 'remnants test - activity upload single file', 'mod', 'assignment', 3, 0, NULL, '25624356354', NULL, 2, '3.00000', '1.00000', 1, NULL, '0.00000', '1.00000', '0.00000', '0.00000', 3, 0, 0, 0, 0), > (53, 2, 5, NULL, 1283850550, NULL, 2, 1, 'remnants test - offline assignment', 'mod', 'assignment', 4, 0, NULL, '123452432332', NULL, 1, '100.00000', '0.00000', NULL, NULL, '0.00000', '1.00000', '0.00000', '0.00000', 4, 1, 0, 0, 0), > (54, 2, 6, NULL, 1283850550, NULL, 2, 1, 'remnants test - database activity', 'mod', 'data', 1, 0, NULL, '376456', NULL, 1, '50.00000', '0.00000', NULL, NULL, '0.00000', '1.00000', '0.00000', '0.00000', 5, 0, 0, 0, 0), > (55, 2, 7, NULL, 1283850550, NULL, 2, 1, 'remnants test for forum activity', 'mod', 'forum', 2, 0, NULL, '34rf', NULL, 1, '77.00000', '0.00000', NULL, NULL, '0.00000', '1.00000', '0.00000', '0.00000', 6, 0, 0, 0, 0), > (56, 2, 8, NULL, 1283850550, NULL, 2, 1, 'remnants test glooooossary', 'mod', 'glossary', 1, 0, NULL, '67272727272727', NULL, 1, '100.00000', '0.00000', NULL, NULL, '0.00000', '1.00000', '0.00000', '0.00000', 7, 0, 0, 0, 0), > (57, 2, 9, NULL, 1283850550, NULL, 2, 1, 'remnants test - activity : Lesson', 'mod', 'lesson', 1, 0, NULL, '198165', NULL, 1, '100.00000', '0.00000', NULL, NULL, '0.00000', '1.00000', '0.00000', '0.00000', 8, 0, 0, 0, 0), > (58, 2, 10, NULL, 1283850550, NULL, 2, 1, 'remnants testing - a quiz in activity', 'mod', 'quiz', 1, 0, NULL, 'ofglviyvh', NULL, 1, '10.00000', '0.00000', NULL, NULL, '0.00000', '1.00000', '0.00000', '0.00000', 9, 0, 0, 0, 0), > (59, 2, 11, NULL, 1283850550, NULL, 2, 1, 'remnants testing a scrom pkg', 'mod', 'scorm', 1, 0, NULL, '846513204613285', NULL, 1, '83.00000', '0.00000', NULL, NULL, '0.00000', '1.00000', '0.00000', '0.00000', 10, 0, 0, 0, 0), > (60, 2, 12, NULL, 1283850550, NULL, 2, 1, 'remnants test - a workshop . (submission)', 'mod', 'workshop', 1, 0, NULL, NULL, NULL, 1, '96.00000', '0.00000', NULL, NULL, '0.00000', '1.00000', '0.00000', '0.00000', 11, 0, 0, 0, 0), > (61, 2, 13, NULL, 1283850550, NULL, 2, 1, 'remnants test - a workshop . (assessment)', 'mod', 'workshop', 1, 1, NULL, NULL, NULL, 1, '37.00000', '0.00000', NULL, NULL, '0.00000', '1.00000', '0.00000', '0.00000', 12, 0, 0, 0, 0), > (62, 2, 14, NULL, 1283850550, NULL, 2, 1, 'remnantest testing a workshoip acitivity (submission)', 'mod', 'workshop', 2, 0, NULL, NULL, NULL, 1, '97.00000', '0.00000', NULL, NULL, '0.00000', '1.00000', '0.00000', '0.00000', 13, 0, 0, 0, 0), > (63, 2, 15, NULL, 1283850550, NULL, 2, 1, 'remnantest testing a workshoip acitivity (assessment)', 'mod', 'workshop', 2, 1, NULL, NULL, NULL, 1, '37.00000', '0.00000', NULL, NULL, '0.00000', '1.00000', '0.00000', '0.00000', 14, 0, 0, 0, 0), > (64, 2, 16, NULL, 1283850550, NULL, 2, 1, 'remnants test - a workshop . (submission)', 'mod', 'workshop', 3, 0, NULL, NULL, NULL, 1, '95.00000', '0.00000', NULL, NULL, '0.00000', '1.00000', '0.00000', '0.00000', 15, 0, 0, 0, 0), > (65, 2, 17, NULL, 1283850551, NULL, 2, 1, 'remnants test - a workshop . (assessment)', 'mod', 'workshop', 3, 1, NULL, NULL, NULL, 1, '34.00000', '0.00000', NULL, NULL, '0.00000', '1.00000', '0.00000', '0.00000', 16, 0, 0, 0, 0), > (66, 2, 18, NULL, 1283850551, NULL, 2, 1, 'remnants test - a workshop . (submission)', 'mod', 'workshop', 4, 0, NULL, NULL, NULL, 1, '80.00000', '0.00000', NULL, NULL, '0.00000', '1.00000', '0.00000', '0.00000', 17, 0, 0, 0, 0), > (67, 2, 19, NULL, 1283850551, NULL, 2, 1, 'remnants test - a workshop . (assessment)', 'mod', 'workshop', 4, 1, NULL, NULL, NULL, 1, '20.00000', '0.00000', NULL, NULL, '0.00000', '1.00000', '0.00000', '0.00000', 18, 0, 0, 0, 0), > (68, 2, 10, NULL, 1283850926, NULL, 2, 1, 'remnants testing - a quiz in activity', 'mod', 'quiz', 1, 0, NULL, 'ofglviyvh', NULL, 1, '10.00000', '0.00000', NULL, NULL, '0.00000', '1.00000', '0.00000', '0.00000', 9, 1, 0, 0, 0), > (69, 2, 10, NULL, 1283850926, NULL, 2, 1, 'remnants testing - a quiz in activity', 'mod', 'quiz', 1, 0, NULL, 'ofglviyvh', NULL, 1, '10.00000', '0.00000', NULL, NULL, '0.00000', '1.00000', '0.00000', '0.00000', 9, 0, 0, 0, 0), > (70, 2, 1, NULL, 1283850926, NULL, 2, NULL, NULL, 'course', NULL, 1, NULL, NULL, NULL, NULL, 1, '100.00000', '0.00000', NULL, NULL, '0.00000', '1.00000', '0.00000', '0.00000', 1, 0, 0, 0, 0), > (71, 2, 10, NULL, 1283851016, NULL, 2, 1, 'remnants testing - a quiz in activity', 'mod', 'quiz', 1, 0, NULL, 'ofglviyvh', NULL, 1, '10.00000', '0.00000', NULL, NULL, '0.00000', '1.00000', '0.00000', '0.00000', 9, 1, 0, 0, 0), > (72, 2, 10, NULL, 1283851016, NULL, 2, 1, 'remnants testing - a quiz in activity', 'mod', 'quiz', 1, 0, NULL, 'ofglviyvh', NULL, 1, '10.00000', '0.00000', NULL, NULL, '0.00000', '1.00000', '0.00000', '0.00000', 9, 0, 0, 0, 0), > (73, 2, 1, NULL, 1283851016, NULL, 2, NULL, NULL, 'course', NULL, 1, NULL, NULL, NULL, NULL, 1, '100.00000', '0.00000', NULL, NULL, '0.00000', '1.00000', '0.00000', '0.00000', 1, 0, 0, 0, 0), > (74, 2, 10, NULL, 1283851056, NULL, 2, 1, 'remnants testing - a quiz in activity', 'mod', 'quiz', 1, 0, NULL, 'ofglviyvh', NULL, 1, '10.00000', '0.00000', NULL, NULL, '0.00000', '1.00000', '0.00000', '0.00000', 9, 1, 0, 0, 0), > (75, 2, 10, NULL, 1283851056, NULL, 2, 1, 'remnants testing - a quiz in activity', 'mod', 'quiz', 1, 0, NULL, 'ofglviyvh', NULL, 1, '10.00000', '0.00000', NULL, NULL, '0.00000', '1.00000', '0.00000', '0.00000', 9, 0, 0, 0, 0), > (76, 2, 1, NULL, 1283851056, NULL, 2, NULL, NULL, 'course', NULL, 1, NULL, NULL, NULL, NULL, 1, '100.00000', '0.00000', NULL, NULL, '0.00000', '1.00000', '0.00000', '0.00000', 1, 0, 0, 0, 0), > (77, 2, 10, NULL, 1283851135, NULL, 2, 1, 'remnants testing - a quiz in activity', 'mod', 'quiz', 1, 0, NULL, 'ofglviyvh', NULL, 1, '10.00000', '0.00000', NULL, NULL, '0.00000', '1.00000', '0.00000', '0.00000', 9, 1, 0, 0, 0), > (78, 3, 2, 'coursedelete', 1283851595, NULL, 2, 1, '--- remnants test -- act:adv upload', 'mod', 'assignment', 1, 0, NULL, '3676754', NULL, 2, '3.00000', '1.00000', 1, NULL, '0.00000', '1.00000', '0.00000', '0.00000', 1, 0, 0, 0, 1), > (79, 3, 3, 'coursedelete', 1283851595, NULL, 2, 1, 'remnants online assignment test', 'mod', 'assignment', 2, 0, NULL, '111111', NULL, 1, '96.00000', '0.00000', NULL, NULL, '0.00000', '1.00000', '0.00000', '0.00000', 2, 0, 0, 0, 1), > (80, 3, 4, 'coursedelete', 1283851596, NULL, 2, 1, 'remnants test - activity upload single file', 'mod', 'assignment', 3, 0, NULL, '25624356354', NULL, 2, '3.00000', '1.00000', 1, NULL, '0.00000', '1.00000', '0.00000', '0.00000', 3, 0, 0, 0, 1), > (81, 3, 5, 'coursedelete', 1283851596, NULL, 2, 1, 'remnants test - offline assignment', 'mod', 'assignment', 4, 0, NULL, '123452432332', NULL, 1, '100.00000', '0.00000', NULL, NULL, '0.00000', '1.00000', '0.00000', '0.00000', 4, 1, 0, 0, 1), > (82, 3, 6, 'coursedelete', 1283851596, NULL, 2, 1, 'remnants test - database activity', 'mod', 'data', 1, 0, NULL, '376456', NULL, 1, '50.00000', '0.00000', NULL, NULL, '0.00000', '1.00000', '0.00000', '0.00000', 5, 0, 0, 0, 1), > (83, 3, 7, 'coursedelete', 1283851596, NULL, 2, 1, 'remnants test for forum activity', 'mod', 'forum', 2, 0, NULL, '34rf', NULL, 1, '77.00000', '0.00000', NULL, NULL, '0.00000', '1.00000', '0.00000', '0.00000', 6, 0, 0, 0, 1), > (84, 3, 8, 'coursedelete', 1283851596, NULL, 2, 1, 'remnants test glooooossary', 'mod', 'glossary', 1, 0, NULL, '67272727272727', NULL, 1, '100.00000', '0.00000', NULL, NULL, '0.00000', '1.00000', '0.00000', '0.00000', 7, 0, 0, 0, 1), > (85, 3, 9, 'coursedelete', 1283851596, NULL, 2, 1, 'remnants test - activity : Lesson', 'mod', 'lesson', 1, 0, NULL, '198165', NULL, 1, '100.00000', '0.00000', NULL, NULL, '0.00000', '1.00000', '0.00000', '0.00000', 8, 0, 0, 0, 1), > (86, 3, 10, 'coursedelete', 1283851596, NULL, 2, 1, 'remnants testing - a quiz in activity', 'mod', 'quiz', 1, 0, NULL, 'ofglviyvh', NULL, 1, '10.00000', '0.00000', NULL, NULL, '0.00000', '1.00000', '0.00000', '0.00000', 9, 1, 0, 0, 1), > (87, 3, 11, 'coursedelete', 1283851597, NULL, 2, 1, 'remnants testing a scrom pkg', 'mod', 'scorm', 1, 0, NULL, '846513204613285', NULL, 1, '83.00000', '0.00000', NULL, NULL, '0.00000', '1.00000', '0.00000', '0.00000', 10, 0, 0, 0, 1), > (88, 3, 12, 'coursedelete', 1283851597, NULL, 2, 1, 'remnants test - a workshop . (submission)', 'mod', 'workshop', 1, 0, NULL, NULL, NULL, 1, '96.00000', '0.00000', NULL, NULL, '0.00000', '1.00000', '0.00000', '0.00000', 11, 0, 0, 0, 1), > (89, 3, 13, 'coursedelete', 1283851597, NULL, 2, 1, 'remnants test - a workshop . (assessment)', 'mod', 'workshop', 1, 1, NULL, NULL, NULL, 1, '37.00000', '0.00000', NULL, NULL, '0.00000', '1.00000', '0.00000', '0.00000', 12, 0, 0, 0, 1), > (90, 3, 14, 'coursedelete', 1283851597, NULL, 2, 1, 'remnantest testing a workshoip acitivity (submission)', 'mod', 'workshop', 2, 0, NULL, NULL, NULL, 1, '97.00000', '0.00000', NULL, NULL, '0.00000', '1.00000', '0.00000', '0.00000', 13, 0, 0, 0, 1), > (91, 3, 15, 'coursedelete', 1283851597, NULL, 2, 1, 'remnantest testing a workshoip acitivity (assessment)', 'mod', 'workshop', 2, 1, NULL, NULL, NULL, 1, '37.00000', '0.00000', NULL, NULL, '0.00000', '1.00000', '0.00000', '0.00000', 14, 0, 0, 0, 1), > (92, 3, 16, 'coursedelete', 1283851597, NULL, 2, 1, 'remnants test - a workshop . (submission)', 'mod', 'workshop', 3, 0, NULL, NULL, NULL, 1, '95.00000', '0.00000', NULL, NULL, '0.00000', '1.00000', '0.00000', '0.00000', 15, 0, 0, 0, 1), > (93, 3, 17, 'coursedelete', 1283851597, NULL, 2, 1, 'remnants test - a workshop . (assessment)', 'mod', 'workshop', 3, 1, NULL, NULL, NULL, 1, '34.00000', '0.00000', NULL, NULL, '0.00000', '1.00000', '0.00000', '0.00000', 16, 0, 0, 0, 1), > (94, 3, 18, 'coursedelete', 1283851598, NULL, 2, 1, 'remnants test - a workshop . (submission)', 'mod', 'workshop', 4, 0, NULL, NULL, NULL, 1, '80.00000', '0.00000', NULL, NULL, '0.00000', '1.00000', '0.00000', '0.00000', 17, 0, 0, 0, 1), > (95, 3, 19, 'coursedelete', 1283851598, NULL, 2, 1, 'remnants test - a workshop . (assessment)', 'mod', 'workshop', 4, 1, NULL, NULL, NULL, 1, '20.00000', '0.00000', NULL, NULL, '0.00000', '1.00000', '0.00000', '0.00000', 18, 0, 0, 0, 1), > (96, 3, 1, 'coursedelete', 1283851598, NULL, 2, NULL, NULL, 'course', NULL, 1, NULL, NULL, NULL, NULL, 1, '100.00000', '0.00000', NULL, NULL, '0.00000', '1.00000', '0.00000', '0.00000', 1, 0, 0, 0, 0); 4908d5096 < DROP TABLE IF EXISTS `mdl_grade_letters`; 4929d5116 < DROP TABLE IF EXISTS `mdl_grade_outcomes`; 4959d5145 < DROP TABLE IF EXISTS `mdl_grade_outcomes_courses`; 4981d5166 < DROP TABLE IF EXISTS `mdl_grade_outcomes_history`; 5013d5197 < DROP TABLE IF EXISTS `mdl_grade_settings`; 5035d5218 < DROP TABLE IF EXISTS `mdl_groupings`; 5060d5242 < DROP TABLE IF EXISTS `mdl_groupings_groups`; 5082d5263 < DROP TABLE IF EXISTS `mdl_groups`; 5096c5277 < ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Each record represents a group.' AUTO_INCREMENT=1 ; --- > ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Each record represents a group.' AUTO_INCREMENT=2 ; 5109d5289 < DROP TABLE IF EXISTS `mdl_groups_members`; 5131d5310 < DROP TABLE IF EXISTS `mdl_imscp`; 5144c5323 < ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='each record is one imscp resource' AUTO_INCREMENT=1 ; --- > ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='each record is one imscp resource' AUTO_INCREMENT=2 ; 5157d5335 < DROP TABLE IF EXISTS `mdl_label`; 5167c5345 < ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Defines labels' AUTO_INCREMENT=1 ; --- > ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Defines labels' AUTO_INCREMENT=2 ; 5180d5357 < DROP TABLE IF EXISTS `mdl_lesson`; 5224c5401 < ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Defines lesson' AUTO_INCREMENT=1 ; --- > ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Defines lesson' AUTO_INCREMENT=2 ; 5237d5413 < DROP TABLE IF EXISTS `mdl_lesson_answers`; 5255c5431 < ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Defines lesson_answers' AUTO_INCREMENT=1 ; --- > ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Defines lesson_answers' AUTO_INCREMENT=3 ; 5268d5443 < DROP TABLE IF EXISTS `mdl_lesson_attempts`; 5284c5459 < ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Defines lesson_attempts' AUTO_INCREMENT=1 ; --- > ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Defines lesson_attempts' AUTO_INCREMENT=8 ; 5297d5471 < DROP TABLE IF EXISTS `mdl_lesson_branch`; 5323d5496 < DROP TABLE IF EXISTS `mdl_lesson_grades`; 5347d5519 < DROP TABLE IF EXISTS `mdl_lesson_high_scores`; 5370d5541 < DROP TABLE IF EXISTS `mdl_lesson_pages`; 5387c5558 < ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Defines lesson_pages' AUTO_INCREMENT=1 ; --- > ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Defines lesson_pages' AUTO_INCREMENT=2 ; 5400d5570 < DROP TABLE IF EXISTS `mdl_lesson_timer`; 5410c5580 < ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='lesson timer for each lesson' AUTO_INCREMENT=1 ; --- > ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='lesson timer for each lesson' AUTO_INCREMENT=5 ; 5423d5592 < DROP TABLE IF EXISTS `mdl_license`; 5455d5623 < DROP TABLE IF EXISTS `mdl_log`; 5473c5641 < ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Every action is logged as far as possible' AUTO_INCREMENT=3 ; --- > ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Every action is logged as far as possible' AUTO_INCREMENT=411 ; 5481c5649,5725 < (2, 1283750208, 2, '127.0.0.1', 1, 'course', 0, 'view', 'view.php?id=1', '1'); --- > (2, 1283750208, 2, '127.0.0.1', 1, 'course', 0, 'view', 'view.php?id=1', '1'), > (3, 1283750817, 2, '127.0.0.1', 1, 'course', 0, 'new', 'view.php?id=2', 'testing Course deletion remnants (ID 2)'), > (103, 1283757443, 2, '127.0.0.1', 1, 'course', 0, 'view', 'view.php?id=1', '1'), > (105, 1283757805, 2, '127.0.0.1', 1, 'course', 0, 'view', 'view.php?id=1', '1'), > (107, 1283757948, 2, '127.0.0.1', 1, 'course', 0, 'view', 'view.php?id=1', '1'), > (109, 1283842618, 2, '127.0.0.1', 1, 'user', 0, 'login', 'view.php?id=0&course=1', '2'), > (112, 1283844877, 2, '127.0.0.1', 1, 'user', 0, 'update', 'view.php?id=-1&course=1', ''), > (114, 1283844903, 2, '127.0.0.1', 1, 'user', 0, 'logout', 'view.php?id=2&course=1', '2'), > (115, 1283845144, 3, '127.0.0.1', 1, 'user', 0, 'login', 'view.php?id=0&course=1', '3'), > (116, 1283845182, 3, '127.0.0.1', 1, 'user', 0, 'logout', 'view.php?id=3&course=1', '3'), > (117, 1283845195, 2, '127.0.0.1', 1, 'user', 0, 'login', 'view.php?id=0&course=1', '2'), > (118, 1283845197, 2, '127.0.0.1', 1, 'course', 0, 'view', 'view.php?id=1', '1'), > (119, 1283845235, 2, '127.0.0.1', 1, 'user', 0, 'update', 'view.php?id=3&course=1', ''), > (123, 1283845291, 2, '127.0.0.1', 1, 'user', 0, 'logout', 'view.php?id=2&course=1', '2'), > (124, 1283845301, 3, '127.0.0.1', 1, 'user', 0, 'login', 'view.php?id=0&course=1', '3'), > (136, 1283845401, 3, '127.0.0.1', 1, 'user', 0, 'logout', 'view.php?id=3&course=1', '3'), > (137, 1283845412, 2, '127.0.0.1', 1, 'user', 0, 'login', 'view.php?id=0&course=1', '2'), > (138, 1283845412, 2, '127.0.0.1', 1, 'course', 0, 'view', 'view.php?id=1', '1'), > (145, 1283845526, 2, '127.0.0.1', 1, 'user', 0, 'logout', 'view.php?id=2&course=1', '2'), > (146, 1283845533, 3, '127.0.0.1', 1, 'user', 0, 'login', 'view.php?id=0&course=1', '3'), > (153, 1283845760, 3, '127.0.0.1', 1, 'user', 0, 'logout', 'view.php?id=3&course=1', '3'), > (154, 1283845773, 2, '127.0.0.1', 1, 'user', 0, 'login', 'view.php?id=0&course=1', '2'), > (162, 1283846017, 2, '127.0.0.1', 1, 'user', 0, 'logout', 'view.php?id=2&course=1', '2'), > (163, 1283846027, 3, '127.0.0.1', 1, 'user', 0, 'login', 'view.php?id=0&course=1', '3'), > (166, 1283846362, 3, '127.0.0.1', 1, 'user', 0, 'logout', 'view.php?id=3&course=1', '3'), > (167, 1283846370, 2, '127.0.0.1', 1, 'user', 0, 'login', 'view.php?id=0&course=1', '2'), > (168, 1283846371, 2, '127.0.0.1', 1, 'course', 0, 'view', 'view.php?id=1', '1'), > (173, 1283846503, 2, '127.0.0.1', 1, 'user', 0, 'logout', 'view.php?id=2&course=1', '2'), > (174, 1283846513, 3, '127.0.0.1', 1, 'user', 0, 'login', 'view.php?id=0&course=1', '3'), > (175, 1283846590, 3, '127.0.0.1', 1, 'user', 0, 'logout', 'view.php?id=3&course=1', '3'), > (176, 1283846599, 2, '127.0.0.1', 1, 'user', 0, 'login', 'view.php?id=0&course=1', '2'), > (181, 1283846883, 2, '127.0.0.1', 1, 'user', 0, 'logout', 'view.php?id=2&course=1', '2'), > (182, 1283846905, 3, '127.0.0.1', 1, 'user', 0, 'login', 'view.php?id=0&course=1', '3'), > (193, 1283847119, 3, '127.0.0.1', 1, 'course', 0, 'view', 'view.php?id=1', '1'), > (205, 1283847870, 3, '127.0.0.1', 1, 'user', 0, 'logout', 'view.php?id=3&course=1', '3'), > (206, 1283847885, 2, '127.0.0.1', 1, 'user', 0, 'login', 'view.php?id=0&course=1', '2'), > (208, 1283848456, 2, '127.0.0.1', 1, 'user', 0, 'logout', 'view.php?id=2&course=1', '2'), > (209, 1283848479, 2, '127.0.0.1', 1, 'user', 0, 'login', 'view.php?id=0&course=1', '2'), > (210, 1283848479, 2, '127.0.0.1', 1, 'course', 0, 'view', 'view.php?id=1', '1'), > (211, 1283849101, 2, '127.0.0.1', 1, 'course', 0, 'view', 'view.php?id=1', '1'), > (218, 1283849265, 2, '127.0.0.1', 1, 'user', 0, 'logout', 'view.php?id=2&course=1', '2'), > (219, 1283849276, 3, '127.0.0.1', 1, 'user', 0, 'login', 'view.php?id=0&course=1', '3'), > (226, 1283849319, 3, '127.0.0.1', 1, 'user', 0, 'logout', 'view.php?id=3&course=1', '3'), > (227, 1283849327, 2, '127.0.0.1', 1, 'user', 0, 'login', 'view.php?id=0&course=1', '2'), > (231, 1283849415, 2, '127.0.0.1', 1, 'user', 0, 'logout', 'view.php?id=2&course=1', '2'), > (232, 1283849424, 2, '127.0.0.1', 1, 'user', 0, 'login', 'view.php?id=0&course=1', '2'), > (246, 1283849492, 2, '127.0.0.1', 1, 'user', 0, 'logout', 'view.php?id=2&course=1', '2'), > (247, 1283849500, 3, '127.0.0.1', 1, 'user', 0, 'login', 'view.php?id=0&course=1', '3'), > (252, 1283849536, 3, '127.0.0.1', 1, 'user', 0, 'logout', 'view.php?id=3&course=1', '3'), > (253, 1283849545, 2, '127.0.0.1', 1, 'user', 0, 'login', 'view.php?id=0&course=1', '2'), > (260, 1283849580, 2, '127.0.0.1', 1, 'user', 0, 'logout', 'view.php?id=2&course=1', '2'), > (261, 1283849588, 3, '127.0.0.1', 1, 'user', 0, 'login', 'view.php?id=0&course=1', '3'), > (265, 1283849606, 3, '127.0.0.1', 1, 'user', 0, 'logout', 'view.php?id=3&course=1', '3'), > (266, 1283849613, 2, '127.0.0.1', 1, 'user', 0, 'login', 'view.php?id=0&course=1', '2'), > (280, 1283849863, 2, '127.0.0.1', 1, 'user', 0, 'logout', 'view.php?id=2&course=1', '2'), > (281, 1283849873, 3, '127.0.0.1', 1, 'user', 0, 'login', 'view.php?id=0&course=1', '3'), > (282, 1283849873, 3, '127.0.0.1', 1, 'course', 0, 'view', 'view.php?id=1', '1'), > (290, 1283849929, 3, '127.0.0.1', 1, 'user', 0, 'logout', 'view.php?id=3&course=1', '3'), > (291, 1283849939, 2, '127.0.0.1', 1, 'user', 0, 'login', 'view.php?id=0&course=1', '2'), > (296, 1283850037, 2, '127.0.0.1', 1, 'user', 0, 'logout', 'view.php?id=2&course=1', '2'), > (297, 1283850046, 3, '127.0.0.1', 1, 'user', 0, 'login', 'view.php?id=0&course=1', '3'), > (308, 1283850312, 3, '127.0.0.1', 1, 'course', 0, 'view', 'view.php?id=1', '1'), > (309, 1283850314, 3, '127.0.0.1', 1, 'user', 0, 'logout', 'view.php?id=3&course=1', '3'), > (310, 1283850323, 2, '127.0.0.1', 1, 'user', 0, 'login', 'view.php?id=0&course=1', '2'), > (312, 1283850468, 2, '127.0.0.1', 1, 'user', 0, 'logout', 'view.php?id=2&course=1', '2'), > (313, 1283850476, 3, '127.0.0.1', 1, 'user', 0, 'login', 'view.php?id=0&course=1', '3'), > (336, 1283850672, 3, '127.0.0.1', 1, 'user', 0, 'logout', 'view.php?id=3&course=1', '3'), > (337, 1283850679, 2, '127.0.0.1', 1, 'user', 0, 'login', 'view.php?id=0&course=1', '2'), > (346, 1283850814, 2, '127.0.0.1', 1, 'user', 0, 'logout', 'view.php?id=2&course=1', '2'), > (347, 1283850821, 3, '127.0.0.1', 1, 'user', 0, 'login', 'view.php?id=0&course=1', '3'), > (352, 1283850850, 3, '127.0.0.1', 1, 'user', 0, 'logout', 'view.php?id=3&course=1', '3'), > (353, 1283850859, 2, '127.0.0.1', 1, 'user', 0, 'login', 'view.php?id=0&course=1', '2'), > (376, 1283851102, 2, '127.0.0.1', 1, 'user', 0, 'logout', 'view.php?id=2&course=1', '2'), > (377, 1283851109, 3, '127.0.0.1', 1, 'user', 0, 'login', 'view.php?id=0&course=1', '3'), > (406, 1283851506, 3, '127.0.0.1', 1, 'user', 0, 'logout', 'view.php?id=3&course=1', '3'), > (407, 1283851513, 2, '127.0.0.1', 1, 'user', 0, 'login', 'view.php?id=0&course=1', '2'), > (410, 1283851595, 2, '127.0.0.1', 1, 'course', 0, 'delete', 'view.php?id=2', 'testing Course deletion remnants (ID 2)'); 5489d5732 < DROP TABLE IF EXISTS `mdl_log_display`; 5634d5876 < DROP TABLE IF EXISTS `mdl_log_queries`; 5659d5900 < DROP TABLE IF EXISTS `mdl_message`; 5686d5926 < DROP TABLE IF EXISTS `mdl_message_contacts`; 5707d5946 < DROP TABLE IF EXISTS `mdl_message_processors`; 5729d5967 < DROP TABLE IF EXISTS `mdl_message_providers`; 5755d5992 < DROP TABLE IF EXISTS `mdl_message_read`; 5783d6019 < DROP TABLE IF EXISTS `mdl_message_working`; 5802d6037 < DROP TABLE IF EXISTS `mdl_mnetservice_enrol_courses`; 5833d6067 < DROP TABLE IF EXISTS `mdl_mnetservice_enrol_enrolments`; 5858d6091 < DROP TABLE IF EXISTS `mdl_mnet_application`; 5883d6115 < DROP TABLE IF EXISTS `mdl_mnet_host`; 5917d6148 < DROP TABLE IF EXISTS `mdl_mnet_host2service`; 5939d6169 < DROP TABLE IF EXISTS `mdl_mnet_log`; 5969d6198 < DROP TABLE IF EXISTS `mdl_mnet_remote_rpc`; 6008d6236 < DROP TABLE IF EXISTS `mdl_mnet_remote_service2rpc`; 6045d6272 < DROP TABLE IF EXISTS `mdl_mnet_rpc`; 6089d6315 < DROP TABLE IF EXISTS `mdl_mnet_service`; 6115d6340 < DROP TABLE IF EXISTS `mdl_mnet_service2rpc`; 6151d6375 < DROP TABLE IF EXISTS `mdl_mnet_session`; 6177d6400 < DROP TABLE IF EXISTS `mdl_mnet_sso_access_control`; 6198d6420 < DROP TABLE IF EXISTS `mdl_modules`; 6242d6463 < DROP TABLE IF EXISTS `mdl_my_pages`; 6267d6487 < DROP TABLE IF EXISTS `mdl_page`; 6284c6504 < ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Each record is one page and its config data' AUTO_INCREMENT=1 ; --- > ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Each record is one page and its config data' AUTO_INCREMENT=2 ; 6297d6516 < DROP TABLE IF EXISTS `mdl_portfolio_instance`; 6317d6535 < DROP TABLE IF EXISTS `mdl_portfolio_instance_config`; 6339d6556 < DROP TABLE IF EXISTS `mdl_portfolio_instance_user`; 6362d6578 < DROP TABLE IF EXISTS `mdl_portfolio_log`; 6390d6605 < DROP TABLE IF EXISTS `mdl_portfolio_mahara_queue`; 6411d6625 < DROP TABLE IF EXISTS `mdl_portfolio_tempdata`; 6434d6647 < DROP TABLE IF EXISTS `mdl_post`; 6474d6686 < DROP TABLE IF EXISTS `mdl_question`; 6500c6712 < ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='The questions themselves' AUTO_INCREMENT=1 ; --- > ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='The questions themselves' AUTO_INCREMENT=2 ; 6513d6724 < DROP TABLE IF EXISTS `mdl_question_answers`; 6524c6735 < ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Answers, with a fractional grade (0-1) and feedback' AUTO_INCREMENT=1 ; --- > ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Answers, with a fractional grade (0-1) and feedback' AUTO_INCREMENT=3 ; 6537d6747 < DROP TABLE IF EXISTS `mdl_question_attempts`; 6542c6752 < ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Student attempts. This table gets extended by the modules' AUTO_INCREMENT=1 ; --- > ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Student attempts. This table gets extended by the modules' AUTO_INCREMENT=3 ; 6555d6764 < DROP TABLE IF EXISTS `mdl_question_calculated`; 6580d6788 < DROP TABLE IF EXISTS `mdl_question_calculated_options`; 6609d6816 < DROP TABLE IF EXISTS `mdl_question_categories`; 6622c6829 < ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Categories are for grouping questions' AUTO_INCREMENT=1 ; --- > ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Categories are for grouping questions' AUTO_INCREMENT=5 ; 6627a6835,6837 > INSERT INTO `mdl_question_categories` (`id`, `name`, `contextid`, `info`, `infoformat`, `stamp`, `parent`, `sortorder`) VALUES > (3, 'Default for Miscellaneous', 3, 'The default category for questions shared in context ''Miscellaneous''.', 0, 'aparup.moodle.local+100907091127+JwLr4o', 0, 999), > (4, 'Default for System', 1, 'The default category for questions shared in context ''System''.', 0, 'aparup.moodle.local+100907091127+520cl8', 0, 999); 6635d6844 < DROP TABLE IF EXISTS `mdl_question_datasets`; 6657d6865 < DROP TABLE IF EXISTS `mdl_question_dataset_definitions`; 6680d6887 < DROP TABLE IF EXISTS `mdl_question_dataset_items`; 6701d6907 < DROP TABLE IF EXISTS `mdl_question_match`; 6722d6927 < DROP TABLE IF EXISTS `mdl_question_match_sub`; 6745d6949 < DROP TABLE IF EXISTS `mdl_question_multianswer`; 6765d6968 < DROP TABLE IF EXISTS `mdl_question_multichoice`; 6795d6997 < DROP TABLE IF EXISTS `mdl_question_numerical`; 6817d7018 < DROP TABLE IF EXISTS `mdl_question_numerical_options`; 6842d7042 < DROP TABLE IF EXISTS `mdl_question_numerical_units`; 6864d7063 < DROP TABLE IF EXISTS `mdl_question_randomsamatch`; 6884d7082 < DROP TABLE IF EXISTS `mdl_question_sessions`; 6901c7099 < ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Gives ids of the newest open and newest graded states' AUTO_INCREMENT=1 ; --- > ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Gives ids of the newest open and newest graded states' AUTO_INCREMENT=3 ; 6914d7111 < DROP TABLE IF EXISTS `mdl_question_shortanswer`; 6935d7131 < DROP TABLE IF EXISTS `mdl_question_states`; 6950c7146 < ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Stores user responses to an attempt, and percentage grades' AUTO_INCREMENT=1 ; --- > ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Stores user responses to an attempt, and percentage grades' AUTO_INCREMENT=8 ; 6963d7158 < DROP TABLE IF EXISTS `mdl_question_truefalse`; 6971c7166 < ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Options for True-False questions' AUTO_INCREMENT=1 ; --- > ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Options for True-False questions' AUTO_INCREMENT=2 ; 6984d7178 < DROP TABLE IF EXISTS `mdl_quiz`; 7018c7212 < ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Main information about each quiz' AUTO_INCREMENT=1 ; --- > ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Main information about each quiz' AUTO_INCREMENT=2 ; 7031d7224 < DROP TABLE IF EXISTS `mdl_quiz_attempts`; 7048c7241 < ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Stores various attempts on a quiz' AUTO_INCREMENT=1 ; --- > ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Stores various attempts on a quiz' AUTO_INCREMENT=3 ; 7061d7253 < DROP TABLE IF EXISTS `mdl_quiz_feedback`; 7071c7263 < ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Feedback given to students based on which grade band their o' AUTO_INCREMENT=1 ; --- > ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Feedback given to students based on which grade band their o' AUTO_INCREMENT=21 ; 7084d7275 < DROP TABLE IF EXISTS `mdl_quiz_grades`; 7094c7285 < ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='The overall grade for each user on the quiz, based on their ' AUTO_INCREMENT=1 ; --- > ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='The overall grade for each user on the quiz, based on their ' AUTO_INCREMENT=2 ; 7107d7297 < DROP TABLE IF EXISTS `mdl_quiz_overrides`; 7135d7324 < DROP TABLE IF EXISTS `mdl_quiz_question_instances`; 7144c7333 < ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Stores the maximum possible grade (weight) for each question' AUTO_INCREMENT=1 ; --- > ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Stores the maximum possible grade (weight) for each question' AUTO_INCREMENT=2 ; 7157d7345 < DROP TABLE IF EXISTS `mdl_quiz_question_regrade`; 7180d7367 < DROP TABLE IF EXISTS `mdl_quiz_question_response_stats`; 7204d7390 < DROP TABLE IF EXISTS `mdl_quiz_question_statistics`; 7234d7419 < DROP TABLE IF EXISTS `mdl_quiz_report`; 7261d7445 < DROP TABLE IF EXISTS `mdl_quiz_statistics`; 7293d7476 < DROP TABLE IF EXISTS `mdl_rating`; 7317d7499 < DROP TABLE IF EXISTS `mdl_registration_hubs`; 7338d7519 < DROP TABLE IF EXISTS `mdl_repository`; 7363d7543 < DROP TABLE IF EXISTS `mdl_repository_instances`; 7394d7573 < DROP TABLE IF EXISTS `mdl_repository_instance_config`; 7414d7592 < DROP TABLE IF EXISTS `mdl_resource`; 7431c7609 < ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Each record is one resource and its config data' AUTO_INCREMENT=1 ; --- > ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Each record is one resource and its config data' AUTO_INCREMENT=2 ; 7444d7621 < DROP TABLE IF EXISTS `mdl_resource_old`; 7478d7654 < DROP TABLE IF EXISTS `mdl_role`; 7512d7687 < DROP TABLE IF EXISTS `mdl_role_allow_assign`; 7542d7716 < DROP TABLE IF EXISTS `mdl_role_allow_override`; 7576d7749 < DROP TABLE IF EXISTS `mdl_role_allow_switch`; 7608d7780 < DROP TABLE IF EXISTS `mdl_role_assignments`; 7624c7796 < ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='assigning roles in different context' AUTO_INCREMENT=1 ; --- > ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='assigning roles in different context' AUTO_INCREMENT=2 ; 7637d7808 < DROP TABLE IF EXISTS `mdl_role_capabilities`; 8514d8684 < DROP TABLE IF EXISTS `mdl_role_context_levels`; 8547d8716 < DROP TABLE IF EXISTS `mdl_role_names`; 8557c8726 < ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='role names in native strings' AUTO_INCREMENT=1 ; --- > ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='role names in native strings' AUTO_INCREMENT=9 ; 8570d8738 < DROP TABLE IF EXISTS `mdl_role_sortorder`; 8595d8762 < DROP TABLE IF EXISTS `mdl_scale`; 8607c8774 < ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Defines grading scales' AUTO_INCREMENT=1 ; --- > ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Defines grading scales' AUTO_INCREMENT=2 ; 8612a8780,8781 > INSERT INTO `mdl_scale` (`id`, `courseid`, `userid`, `name`, `scale`, `description`, `descriptionformat`, `timemodified`) VALUES > (1, 0, 0, 'Separate and Connected ways of knowing', 'Mostly Separate Knowing,Separate and Connected,Mostly Connected Knowing', 'The scale based on the theory of separate and connected knowing. This theory describes two different ways that we can evaluate and learn about the things we see and hear.a user that isn''t sure.
', 1, 1, 0, 2, 1, 0, 1, 0, 1283844877, 1283845235, 0, '', 0); 9958d10102 < DROP TABLE IF EXISTS `mdl_user_enrolments`; 9974c10118 < ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Users participating in courses (aka enrolled users) - everyb' AUTO_INCREMENT=1 ; --- > ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Users participating in courses (aka enrolled users) - everyb' AUTO_INCREMENT=2 ; 9979a10124,10125 > INSERT INTO `mdl_user_enrolments` (`id`, `status`, `enrolid`, `userid`, `timestart`, `timeend`, `modifierid`, `timecreated`, `timemodified`) VALUES > (1, 0, 1, 3, 1283788800, 0, 0, 1283846859, 1283846859); 9987d10132 < DROP TABLE IF EXISTS `mdl_user_info_category`; 10006d10150 < DROP TABLE IF EXISTS `mdl_user_info_data`; 10027d10170 < DROP TABLE IF EXISTS `mdl_user_info_field`; 10063d10205 < DROP TABLE IF EXISTS `mdl_user_lastaccess`; 10073c10215 < ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='To keep track of course page access times, used in online pa' AUTO_INCREMENT=1 ; --- > ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='To keep track of course page access times, used in online pa' AUTO_INCREMENT=3 ; 10086d10227 < DROP TABLE IF EXISTS `mdl_user_preferences`; 10094c10235 < ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Allows modules to store arbitrary user preferences' AUTO_INCREMENT=12 ; --- > ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Allows modules to store arbitrary user preferences' AUTO_INCREMENT=39 ; 10111c10252,10279 < (11, 2, 'email_send_count', '1'); --- > (11, 2, 'email_send_count', '1'), > (12, 2, 'course_edit_form_showadvanced', '1'), > (13, 2, 'mod_imscp_mod_form_showadvanced', '0'), > (14, 2, 'mod_label_mod_form_showadvanced', '1'), > (15, 2, 'mod_page_mod_form_showadvanced', '1'), > (16, 2, 'mod_url_mod_form_showadvanced', '1'), > (17, 2, 'mod_assignment_mod_form_showadvanced', '1'), > (18, 2, 'mod_data_mod_form_showadvanced', '1'), > (19, 2, 'mod_forum_mod_form_showadvanced', '1'), > (20, 2, 'mod_glossary_mod_form_showadvanced', '1'), > (21, 2, 'mod_quiz_mod_form_showadvanced', '1'), > (22, 2, 'mod_scorm_mod_form_showadvanced', '1'), > (23, 2, 'mod_survey_mod_form_showadvanced', '1'), > (24, 2, 'mod_wiki_mod_form_showadvanced', '1'), > (25, 2, 'mod_workshop_mod_form_showadvanced', '1'), > (26, 3, 'auth_forcepasswordchange', '0'), > (27, 3, 'email_bounce_count', '1'), > (28, 3, 'email_send_count', '1'), > (29, 3, 'message_provider_moodle_notices_loggedin', 'popup'), > (30, 3, 'message_provider_moodle_notices_loggedoff', 'email'), > (31, 3, 'message_provider_moodle_errors_loggedin', 'popup'), > (32, 3, 'message_provider_moodle_errors_loggedoff', 'email'), > (33, 3, 'message_provider_moodle_instantmessage_loggedin', 'popup'), > (34, 3, 'message_provider_moodle_instantmessage_loggedoff', 'email'), > (35, 3, 'message_provider_mod_forum_posts_loggedin', 'popup'), > (36, 3, 'message_provider_mod_forum_posts_loggedoff', 'email'), > (37, 3, 'forum_displaymode', '-1'), > (38, 2, 'quiz_qbanktool_open', '1'); 10119d10286 < DROP TABLE IF EXISTS `mdl_user_private_key`; 10145d10311 < DROP TABLE IF EXISTS `mdl_webdav_locks`; 10174d10339 < DROP TABLE IF EXISTS `mdl_wiki`; 10191c10356 < ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Stores Wiki activity configuration' AUTO_INCREMENT=1 ; --- > ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Stores Wiki activity configuration' AUTO_INCREMENT=2 ; 10204d10368 < DROP TABLE IF EXISTS `mdl_wiki_links`; 10227d10390 < DROP TABLE IF EXISTS `mdl_wiki_locks`; 10235c10398 < ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Manages page locks' AUTO_INCREMENT=1 ; --- > ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Manages page locks' AUTO_INCREMENT=3 ; 10248d10410 < DROP TABLE IF EXISTS `mdl_wiki_pages`; 10263c10425 < ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Stores wiki pages' AUTO_INCREMENT=1 ; --- > ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Stores wiki pages' AUTO_INCREMENT=2 ; 10276d10437 < DROP TABLE IF EXISTS `mdl_wiki_subwikis`; 10285c10446 < ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Stores subwiki instances' AUTO_INCREMENT=1 ; --- > ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Stores subwiki instances' AUTO_INCREMENT=2 ; 10298d10458 < DROP TABLE IF EXISTS `mdl_wiki_synonyms`; 10319d10478 < DROP TABLE IF EXISTS `mdl_wiki_versions`; 10330c10489 < ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Stores wiki page history' AUTO_INCREMENT=1 ; --- > ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Stores wiki page history' AUTO_INCREMENT=3 ; 10343d10501 < DROP TABLE IF EXISTS `mdl_workshop`; 10374c10532 < ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='This table keeps information about the module instances and ' AUTO_INCREMENT=1 ; --- > ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='This table keeps information about the module instances and ' AUTO_INCREMENT=5 ; 10387d10544 < DROP TABLE IF EXISTS `mdl_workshopeval_best_settings`; 10407d10563 < DROP TABLE IF EXISTS `mdl_workshopform_accumulative`; 10431d10586 < DROP TABLE IF EXISTS `mdl_workshopform_comments`; 10453d10607 < DROP TABLE IF EXISTS `mdl_workshopform_numerrors`; 10479d10632 < DROP TABLE IF EXISTS `mdl_workshopform_numerrors_map`; 10501d10653 < DROP TABLE IF EXISTS `mdl_workshopform_rubric`; 10523d10674 < DROP TABLE IF EXISTS `mdl_workshopform_rubric_config`; 10543d10693 < DROP TABLE IF EXISTS `mdl_workshopform_rubric_levels`; 10565d10714 < DROP TABLE IF EXISTS `mdl_workshop_aggregations`; 10589d10737 < DROP TABLE IF EXISTS `mdl_workshop_assessments`; 10622d10769 < DROP TABLE IF EXISTS `mdl_workshop_grades`; 10647d10793 < DROP TABLE IF EXISTS `mdl_workshop_submissions`;