Language import utility: sk_utf8 ...

Upgrading Moodle database from version 1.8 + (2007021505) to 1.9.2 (Build: 20080711) (2007101520)...

(mysql): SHOW TABLES

(mysql): CREATE TABLE mdl_role_sortorder ( id BIGINT(10) unsigned NOT NULL auto_increment, userid BIGINT(10) unsigned NOT NULL, roleid BIGINT(10) unsigned NOT NULL, contextid BIGINT(10) unsigned NOT NULL, sortoder BIGINT(10) NOT NULL, CONSTRAINT PRIMARY KEY (id) )

Úspech

(mysql): CREATE UNIQUE INDEX mdl_rolesort_userolcon_uix ON mdl_role_sortorder (userid, roleid, contextid)

Úspech

(mysql): CREATE INDEX mdl_rolesort_use_ix ON mdl_role_sortorder (userid)

Úspech

(mysql): CREATE INDEX mdl_rolesort_rol_ix ON mdl_role_sortorder (roleid)

Úspech

(mysql): CREATE INDEX mdl_rolesort_con_ix ON mdl_role_sortorder (contextid)

Úspech

(mysql): SELECT name FROM mdl_config WHERE name = 'version' LIMIT 1

(mysql): UPDATE mdl_config SET value = '2007032200' WHERE name = 'version'

(mysql): ALTER TABLE mdl_tags DROP INDEX mdl_tags_tex_ix

Úspech

(mysql): ALTER TABLE mdl_tags MODIFY COLUMN text VARCHAR(255) NOT NULL DEFAULT '' after userid

Úspech

(mysql): SHOW TABLES

(mysql): SHOW INDEX FROM mdl_tags

(mysql): CREATE INDEX mdl_tags_tex_ix ON mdl_tags (text)

Úspech

(mysql): SELECT name FROM mdl_config WHERE name = 'version' LIMIT 1

(mysql): UPDATE mdl_config SET value = '2007040400' WHERE name = 'version'

(mysql): ALTER TABLE mdl_course_modules ADD idnumber VARCHAR(100) DEFAULT NULL after section

Úspech

(mysql): SELECT name FROM mdl_config WHERE name = 'version' LIMIT 1

(mysql): UPDATE mdl_config SET value = '2007041100' WHERE name = 'version'

(mysql): SELECT * FROM mdl_user_info_field WHERE datatype = 'menu'

(mysql): SELECT name FROM mdl_config WHERE name = 'version' LIMIT 1

(mysql): UPDATE mdl_config SET value = '2007041600' WHERE name = 'version'

(mysql): SHOW TABLES

(mysql): CREATE TABLE mdl_events_handlers ( id BIGINT(10) unsigned NOT NULL auto_increment, eventname VARCHAR(166) NOT NULL DEFAULT '', handlermodule VARCHAR(166) NOT NULL DEFAULT '', handlerfile VARCHAR(255) NOT NULL DEFAULT '', handlerfunction MEDIUMTEXT, CONSTRAINT PRIMARY KEY (id) )

Úspech

(mysql): CREATE UNIQUE INDEX mdl_evenhand_evehan_uix ON mdl_events_handlers (eventname, handlermodule)

Úspech

(mysql): SHOW TABLES

(mysql): CREATE TABLE mdl_events_queue ( id BIGINT(10) unsigned NOT NULL auto_increment, eventdata LONGTEXT NOT NULL, schedule VARCHAR(255) NOT NULL DEFAULT '', stackdump MEDIUMTEXT, userid BIGINT(10) unsigned DEFAULT NULL, timecreated BIGINT(10) unsigned NOT NULL, CONSTRAINT PRIMARY KEY (id) )

Úspech

(mysql): CREATE INDEX mdl_evenqueu_use_ix ON mdl_events_queue (userid)

Úspech

(mysql): SHOW TABLES

(mysql): CREATE TABLE mdl_events_queue_handlers ( id BIGINT(10) unsigned NOT NULL auto_increment, queuedeventid BIGINT(10) unsigned NOT NULL, handlerid BIGINT(10) unsigned NOT NULL, status BIGINT(10) DEFAULT NULL, errormessage MEDIUMTEXT, timemodified BIGINT(10) unsigned NOT NULL, CONSTRAINT PRIMARY KEY (id) )

Úspech

(mysql): CREATE INDEX mdl_evenqueuhand_que_ix ON mdl_events_queue_handlers (queuedeventid)

Úspech

(mysql): CREATE INDEX mdl_evenqueuhand_han_ix ON mdl_events_queue_handlers (handlerid)

Úspech

(mysql): SELECT name FROM mdl_config WHERE name = 'version' LIMIT 1

(mysql): UPDATE mdl_config SET value = '2007041800' WHERE name = 'version'

(mysql): ALTER TABLE mdl_events_handlers ADD schedule VARCHAR(255) DEFAULT NULL after handlerfunction

Úspech

(mysql): ALTER TABLE mdl_events_handlers ADD status BIGINT(10) unsigned NOT NULL DEFAULT 0 after schedule

Úspech

(mysql): SELECT name FROM mdl_config WHERE name = 'version' LIMIT 1

(mysql): UPDATE mdl_config SET value = '2007043001' WHERE name = 'version'

(mysql): ALTER TABLE mdl_course_categories ADD theme VARCHAR(50) DEFAULT NULL after path

Úspech

(mysql): SELECT name FROM mdl_config WHERE name = 'version' LIMIT 1

(mysql): UPDATE mdl_config SET value = '2007050201' WHERE name = 'version'

(mysql): ALTER TABLE mdl_user_info_field ADD forceunique TINYINT(2) unsigned NOT NULL DEFAULT 0 after visible

Úspech

(mysql): ALTER TABLE mdl_user_info_field ADD signup TINYINT(2) unsigned NOT NULL DEFAULT 0 after forceunique

Úspech

(mysql): SELECT name FROM mdl_config WHERE name = 'version' LIMIT 1

(mysql): UPDATE mdl_config SET value = '2007051100' WHERE name = 'version'

(mysql): SELECT * FROM mdl_role WHERE shortname = 'user' LIMIT 1

(mysql): SELECT name FROM mdl_config WHERE name = 'version' LIMIT 1

(mysql): UPDATE mdl_config SET value = '2007051801' WHERE name = 'version'

(mysql): ALTER TABLE mdl_events_queue DROP COLUMN schedule

Úspech

(mysql): SELECT name FROM mdl_config WHERE name = 'version' LIMIT 1

(mysql): UPDATE mdl_config SET value = '2007052200' WHERE name = 'version'

(mysql): DROP TABLE mdl_question_rqp_states

Úspech

(mysql): DROP TABLE mdl_question_rqp

Úspech

(mysql): DROP TABLE mdl_question_rqp_types

Úspech

(mysql): DROP TABLE mdl_question_rqp_servers

Úspech

(mysql): DELETE FROM mdl_config WHERE name = 'qtype_rqp_version'

(mysql): SELECT name FROM mdl_config WHERE name = 'version' LIMIT 1

(mysql): UPDATE mdl_config SET value = '2007052300' WHERE name = 'version'

(mysql): ALTER TABLE mdl_post ADD usermodified BIGINT(10) unsigned DEFAULT NULL after created

Úspech

(mysql): SHOW TABLES

(mysql): SHOW INDEX FROM mdl_post

(mysql): CREATE INDEX mdl_post_use_ix ON mdl_post (usermodified)

Úspech

(mysql): SELECT name FROM mdl_config WHERE name = 'version' LIMIT 1

(mysql): UPDATE mdl_config SET value = '2007060500' WHERE name = 'version'

(mysql): UPDATE mdl_user SET mnethostid = '1' WHERE username = 'guest'

(mysql): SELECT name FROM mdl_config WHERE name = 'version' LIMIT 1

(mysql): UPDATE mdl_config SET value = '2007070603' WHERE name = 'version'

(mysql): CREATE TABLE mdl_mnet_application ( id BIGINT(10) NOT NULL auto_increment, name VARCHAR(50) NOT NULL DEFAULT '', display_name VARCHAR(50) NOT NULL DEFAULT '', xmlrpc_server_url VARCHAR(255) NOT NULL DEFAULT '', sso_land_url VARCHAR(255) NOT NULL DEFAULT '', CONSTRAINT PRIMARY KEY (id) )

Úspech

(mysql): ALTER TABLE mdl_mnet_application COMMENT='Information about applications on remote hosts'

Úspech

(mysql): SELECT * FROM mdl_mnet_application WHERE id = '-1'

(mysql): INSERT INTO mdl_mnet_application ( NAME, DISPLAY_NAME, XMLRPC_SERVER_URL, SSO_LAND_URL ) VALUES ( 'moodle', 'Moodle', '/mnet/xmlrpc/server.php', '/auth/mnet/land.php' )

(mysql): INSERT INTO mdl_mnet_application ( NAME, DISPLAY_NAME, XMLRPC_SERVER_URL, SSO_LAND_URL ) VALUES ( 'mahara', 'Mahara', '/api/xmlrpc/server.php', '/auth/xmlrpc/land.php' )

(mysql): ALTER TABLE mdl_mnet_host ADD applicationid TINYINT(1) unsigned NOT NULL DEFAULT 1 after last_log_id

Úspech

(mysql): SHOW TABLES

(mysql): SHOW INDEX FROM mdl_mnet_host

(mysql): CREATE INDEX mdl_mnethost_app_ix ON mdl_mnet_host (applicationid)

Úspech

(mysql): SELECT name FROM mdl_config WHERE name = 'version' LIMIT 1

(mysql): UPDATE mdl_config SET value = '2007071400' WHERE name = 'version'

(mysql): SELECT name FROM mdl_config WHERE name = 'version' LIMIT 1

(mysql): UPDATE mdl_config SET value = '2007071607' WHERE name = 'version'

(mysql): SHOW TABLES

(mysql): CREATE TABLE mdl_grade_outcomes ( id BIGINT(10) unsigned NOT NULL auto_increment, courseid BIGINT(10) unsigned DEFAULT NULL, shortname VARCHAR(255) NOT NULL DEFAULT '', fullname TEXT NOT NULL, scaleid BIGINT(10) unsigned DEFAULT NULL, description TEXT, timecreated BIGINT(10) unsigned DEFAULT NULL, timemodified BIGINT(10) unsigned DEFAULT NULL, usermodified BIGINT(10) unsigned DEFAULT NULL, CONSTRAINT PRIMARY KEY (id) )

Úspech

(mysql): CREATE INDEX mdl_gradoutc_cou_ix ON mdl_grade_outcomes (courseid)

Úspech

(mysql): CREATE INDEX mdl_gradoutc_sca_ix ON mdl_grade_outcomes (scaleid)

Úspech

(mysql): CREATE INDEX mdl_gradoutc_use_ix ON mdl_grade_outcomes (usermodified)

Úspech

(mysql): SHOW TABLES

(mysql): CREATE TABLE mdl_grade_categories ( id BIGINT(10) unsigned NOT NULL auto_increment, courseid BIGINT(10) unsigned NOT NULL, parent BIGINT(10) unsigned DEFAULT NULL, depth BIGINT(10) unsigned NOT NULL DEFAULT 0, path VARCHAR(255) DEFAULT NULL, fullname VARCHAR(255) NOT NULL DEFAULT '', aggregation BIGINT(10) NOT NULL DEFAULT 0, keephigh BIGINT(10) NOT NULL DEFAULT 0, droplow BIGINT(10) NOT NULL DEFAULT 0, aggregateonlygraded TINYINT(1) unsigned NOT NULL DEFAULT 0, aggregateoutcomes TINYINT(1) unsigned NOT NULL DEFAULT 0, aggregatesubcats TINYINT(1) unsigned NOT NULL DEFAULT 0, timecreated BIGINT(10) unsigned NOT NULL, timemodified BIGINT(10) unsigned NOT NULL, CONSTRAINT PRIMARY KEY (id) )

Úspech

(mysql): CREATE INDEX mdl_gradcate_cou_ix ON mdl_grade_categories (courseid)

Úspech

(mysql): CREATE INDEX mdl_gradcate_par_ix ON mdl_grade_categories (parent)

Úspech

(mysql): SHOW TABLES

(mysql): CREATE TABLE mdl_grade_items ( id BIGINT(10) unsigned NOT NULL auto_increment, courseid BIGINT(10) unsigned DEFAULT NULL, categoryid BIGINT(10) unsigned DEFAULT NULL, itemname VARCHAR(255) DEFAULT NULL, itemtype VARCHAR(30) NOT NULL DEFAULT '', itemmodule VARCHAR(30) DEFAULT NULL, iteminstance BIGINT(10) unsigned DEFAULT NULL, itemnumber BIGINT(10) unsigned DEFAULT NULL, iteminfo MEDIUMTEXT, idnumber VARCHAR(255) DEFAULT NULL, calculation MEDIUMTEXT, gradetype SMALLINT(4) NOT NULL DEFAULT 1, grademax NUMERIC(10,5) NOT NULL DEFAULT 100, grademin NUMERIC(10,5) NOT NULL DEFAULT 0, scaleid BIGINT(10) unsigned DEFAULT NULL, outcomeid BIGINT(10) unsigned DEFAULT NULL, gradepass NUMERIC(10,5) NOT NULL DEFAULT 0, multfactor NUMERIC(10,5) NOT NULL DEFAULT 1.0, plusfactor NUMERIC(10,5) NOT NULL DEFAULT 0, aggregationcoef NUMERIC(10,5) NOT NULL DEFAULT 0, sortorder BIGINT(10) NOT NULL DEFAULT 0, display BIGINT(10) NOT NULL DEFAULT 0, decimals TINYINT(1) unsigned DEFAULT NULL, hidden BIGINT(10) NOT NULL DEFAULT 0, locked BIGINT(10) NOT NULL DEFAULT 0, locktime BIGINT(10) unsigned NOT NULL DEFAULT 0, needsupdate BIGINT(10) NOT NULL DEFAULT 0, timecreated BIGINT(10) unsigned DEFAULT NULL, timemodified BIGINT(10) unsigned DEFAULT NULL, CONSTRAINT PRIMARY KEY (id) )

Úspech

(mysql): CREATE INDEX mdl_graditem_locloc_ix ON mdl_grade_items (locked, locktime)

Úspech

(mysql): CREATE INDEX mdl_graditem_itenee_ix ON mdl_grade_items (itemtype, needsupdate)

Úspech

(mysql): CREATE INDEX mdl_graditem_gra_ix ON mdl_grade_items (gradetype)

Úspech

(mysql): CREATE INDEX mdl_graditem_cou_ix ON mdl_grade_items (courseid)

Úspech

(mysql): CREATE INDEX mdl_graditem_cat_ix ON mdl_grade_items (categoryid)

Úspech

(mysql): CREATE INDEX mdl_graditem_sca_ix ON mdl_grade_items (scaleid)

Úspech

(mysql): CREATE INDEX mdl_graditem_out_ix ON mdl_grade_items (outcomeid)

Úspech

(mysql): SHOW TABLES

(mysql): CREATE TABLE mdl_grade_grades ( id BIGINT(10) unsigned NOT NULL auto_increment, itemid BIGINT(10) unsigned NOT NULL, userid BIGINT(10) unsigned NOT NULL, rawgrade NUMERIC(10,5) DEFAULT NULL, rawgrademax NUMERIC(10,5) NOT NULL DEFAULT 100, rawgrademin NUMERIC(10,5) NOT NULL DEFAULT 0, rawscaleid BIGINT(10) unsigned DEFAULT NULL, usermodified BIGINT(10) unsigned DEFAULT NULL, finalgrade NUMERIC(10,5) DEFAULT NULL, hidden BIGINT(10) unsigned NOT NULL DEFAULT 0, locked BIGINT(10) unsigned NOT NULL DEFAULT 0, locktime BIGINT(10) unsigned NOT NULL DEFAULT 0, exported BIGINT(10) unsigned NOT NULL DEFAULT 0, overridden BIGINT(10) unsigned NOT NULL DEFAULT 0, excluded BIGINT(10) unsigned NOT NULL DEFAULT 0, feedback MEDIUMTEXT, feedbackformat BIGINT(10) unsigned NOT NULL DEFAULT 0, information MEDIUMTEXT, informationformat BIGINT(10) unsigned NOT NULL DEFAULT 0, timecreated BIGINT(10) unsigned DEFAULT NULL, timemodified BIGINT(10) unsigned DEFAULT NULL, CONSTRAINT PRIMARY KEY (id) )

Úspech

(mysql): CREATE INDEX mdl_gradgrad_locloc_ix ON mdl_grade_grades (locked, locktime)

Úspech

(mysql): CREATE INDEX mdl_gradgrad_ite_ix ON mdl_grade_grades (itemid)

Úspech

(mysql): CREATE INDEX mdl_gradgrad_use_ix ON mdl_grade_grades (userid)

Úspech

(mysql): CREATE INDEX mdl_gradgrad_raw_ix ON mdl_grade_grades (rawscaleid)

Úspech

(mysql): CREATE INDEX mdl_gradgrad_use2_ix ON mdl_grade_grades (usermodified)

Úspech

(mysql): SHOW TABLES

(mysql): CREATE TABLE mdl_grade_outcomes_history ( id BIGINT(10) unsigned NOT NULL auto_increment, action BIGINT(10) unsigned NOT NULL DEFAULT 0, oldid BIGINT(10) unsigned NOT NULL, source VARCHAR(255) DEFAULT NULL, timemodified BIGINT(10) unsigned DEFAULT NULL, loggeduser BIGINT(10) unsigned DEFAULT NULL, courseid BIGINT(10) unsigned DEFAULT NULL, shortname VARCHAR(255) NOT NULL DEFAULT '', fullname TEXT NOT NULL, scaleid BIGINT(10) unsigned DEFAULT NULL, description TEXT, CONSTRAINT PRIMARY KEY (id) )

Úspech

(mysql): CREATE INDEX mdl_gradoutchist_act_ix ON mdl_grade_outcomes_history (action)

Úspech

(mysql): CREATE INDEX mdl_gradoutchist_old_ix ON mdl_grade_outcomes_history (oldid)

Úspech

(mysql): CREATE INDEX mdl_gradoutchist_cou_ix ON mdl_grade_outcomes_history (courseid)

Úspech

(mysql): CREATE INDEX mdl_gradoutchist_sca_ix ON mdl_grade_outcomes_history (scaleid)

Úspech

(mysql): CREATE INDEX mdl_gradoutchist_log_ix ON mdl_grade_outcomes_history (loggeduser)

Úspech

(mysql): SHOW TABLES

(mysql): CREATE TABLE mdl_grade_categories_history ( id BIGINT(10) unsigned NOT NULL auto_increment, action BIGINT(10) unsigned NOT NULL DEFAULT 0, oldid BIGINT(10) unsigned NOT NULL, source VARCHAR(255) DEFAULT NULL, timemodified BIGINT(10) unsigned DEFAULT NULL, loggeduser BIGINT(10) unsigned DEFAULT NULL, courseid BIGINT(10) unsigned NOT NULL, parent BIGINT(10) unsigned DEFAULT NULL, depth BIGINT(10) unsigned NOT NULL DEFAULT 0, path VARCHAR(255) DEFAULT NULL, fullname VARCHAR(255) NOT NULL DEFAULT '', aggregation BIGINT(10) NOT NULL DEFAULT 0, keephigh BIGINT(10) NOT NULL DEFAULT 0, droplow BIGINT(10) NOT NULL DEFAULT 0, aggregateonlygraded TINYINT(1) unsigned NOT NULL DEFAULT 0, aggregateoutcomes TINYINT(1) unsigned NOT NULL DEFAULT 0, aggregatesubcats TINYINT(1) unsigned NOT NULL DEFAULT 0, CONSTRAINT PRIMARY KEY (id) )

Úspech

(mysql): CREATE INDEX mdl_gradcatehist_act_ix ON mdl_grade_categories_history (action)

Úspech

(mysql): CREATE INDEX mdl_gradcatehist_old_ix ON mdl_grade_categories_history (oldid)

Úspech

(mysql): CREATE INDEX mdl_gradcatehist_cou_ix ON mdl_grade_categories_history (courseid)

Úspech

(mysql): CREATE INDEX mdl_gradcatehist_par_ix ON mdl_grade_categories_history (parent)

Úspech

(mysql): CREATE INDEX mdl_gradcatehist_log_ix ON mdl_grade_categories_history (loggeduser)

Úspech

(mysql): SHOW TABLES

(mysql): CREATE TABLE mdl_grade_items_history ( id BIGINT(10) unsigned NOT NULL auto_increment, action BIGINT(10) unsigned NOT NULL DEFAULT 0, oldid BIGINT(10) unsigned NOT NULL, source VARCHAR(255) DEFAULT NULL, timemodified BIGINT(10) unsigned DEFAULT NULL, loggeduser BIGINT(10) unsigned DEFAULT NULL, courseid BIGINT(10) unsigned DEFAULT NULL, categoryid BIGINT(10) unsigned DEFAULT NULL, itemname VARCHAR(255) DEFAULT NULL, itemtype VARCHAR(30) NOT NULL DEFAULT '', itemmodule VARCHAR(30) DEFAULT NULL, iteminstance BIGINT(10) unsigned DEFAULT NULL, itemnumber BIGINT(10) unsigned DEFAULT NULL, iteminfo MEDIUMTEXT, idnumber VARCHAR(255) DEFAULT NULL, calculation MEDIUMTEXT, gradetype SMALLINT(4) NOT NULL DEFAULT 1, grademax NUMERIC(10,5) NOT NULL DEFAULT 100, grademin NUMERIC(10,5) NOT NULL DEFAULT 0, scaleid BIGINT(10) unsigned DEFAULT NULL, outcomeid BIGINT(10) unsigned DEFAULT NULL, gradepass NUMERIC(10,5) NOT NULL DEFAULT 0, multfactor NUMERIC(10,5) NOT NULL DEFAULT 1.0, plusfactor NUMERIC(10,5) NOT NULL DEFAULT 0, aggregationcoef NUMERIC(10,5) NOT NULL DEFAULT 0, sortorder BIGINT(10) NOT NULL DEFAULT 0, display BIGINT(10) NOT NULL DEFAULT 0, decimals TINYINT(1) unsigned DEFAULT NULL, hidden BIGINT(10) NOT NULL DEFAULT 0, locked BIGINT(10) NOT NULL DEFAULT 0, locktime BIGINT(10) unsigned NOT NULL DEFAULT 0, needsupdate BIGINT(10) NOT NULL DEFAULT 0, CONSTRAINT PRIMARY KEY (id) )

Úspech

(mysql): CREATE INDEX mdl_graditemhist_act_ix ON mdl_grade_items_history (action)

Úspech

(mysql): CREATE INDEX mdl_graditemhist_old_ix ON mdl_grade_items_history (oldid)

Úspech

(mysql): CREATE INDEX mdl_graditemhist_cou_ix ON mdl_grade_items_history (courseid)

Úspech

(mysql): CREATE INDEX mdl_graditemhist_cat_ix ON mdl_grade_items_history (categoryid)

Úspech

(mysql): CREATE INDEX mdl_graditemhist_sca_ix ON mdl_grade_items_history (scaleid)

Úspech

(mysql): CREATE INDEX mdl_graditemhist_out_ix ON mdl_grade_items_history (outcomeid)

Úspech

(mysql): CREATE INDEX mdl_graditemhist_log_ix ON mdl_grade_items_history (loggeduser)

Úspech

(mysql): SHOW TABLES

(mysql): CREATE TABLE mdl_grade_grades_history ( id BIGINT(10) unsigned NOT NULL auto_increment, action BIGINT(10) unsigned NOT NULL DEFAULT 0, oldid BIGINT(10) unsigned NOT NULL, source VARCHAR(255) DEFAULT NULL, timemodified BIGINT(10) unsigned DEFAULT NULL, loggeduser BIGINT(10) unsigned DEFAULT NULL, itemid BIGINT(10) unsigned NOT NULL, userid BIGINT(10) unsigned NOT NULL, rawgrade NUMERIC(10,5) DEFAULT NULL, rawgrademax NUMERIC(10,5) NOT NULL DEFAULT 100, rawgrademin NUMERIC(10,5) NOT NULL DEFAULT 0, rawscaleid BIGINT(10) unsigned DEFAULT NULL, usermodified BIGINT(10) unsigned DEFAULT NULL, finalgrade NUMERIC(10,5) DEFAULT NULL, hidden BIGINT(10) unsigned NOT NULL DEFAULT 0, locked BIGINT(10) unsigned NOT NULL DEFAULT 0, locktime BIGINT(10) unsigned NOT NULL DEFAULT 0, exported BIGINT(10) unsigned NOT NULL DEFAULT 0, overridden BIGINT(10) unsigned NOT NULL DEFAULT 0, excluded BIGINT(10) unsigned NOT NULL DEFAULT 0, feedback MEDIUMTEXT, feedbackformat BIGINT(10) unsigned NOT NULL DEFAULT 0, information MEDIUMTEXT, informationformat BIGINT(10) unsigned NOT NULL DEFAULT 0, CONSTRAINT PRIMARY KEY (id) )

Úspech

(mysql): CREATE INDEX mdl_gradgradhist_act_ix ON mdl_grade_grades_history (action)

Úspech

(mysql): CREATE INDEX mdl_gradgradhist_old_ix ON mdl_grade_grades_history (oldid)

Úspech

(mysql): CREATE INDEX mdl_gradgradhist_ite_ix ON mdl_grade_grades_history (itemid)

Úspech

(mysql): CREATE INDEX mdl_gradgradhist_use_ix ON mdl_grade_grades_history (userid)

Úspech

(mysql): CREATE INDEX mdl_gradgradhist_raw_ix ON mdl_grade_grades_history (rawscaleid)

Úspech

(mysql): CREATE INDEX mdl_gradgradhist_use2_ix ON mdl_grade_grades_history (usermodified)

Úspech

(mysql): CREATE INDEX mdl_gradgradhist_log_ix ON mdl_grade_grades_history (loggeduser)

Úspech

(mysql): SHOW TABLES

(mysql): CREATE TABLE mdl_scale_history ( id BIGINT(10) unsigned NOT NULL auto_increment, action BIGINT(10) unsigned NOT NULL DEFAULT 0, oldid BIGINT(10) unsigned NOT NULL, source VARCHAR(255) DEFAULT NULL, timemodified BIGINT(10) unsigned DEFAULT NULL, loggeduser BIGINT(10) unsigned DEFAULT NULL, courseid BIGINT(10) unsigned NOT NULL DEFAULT 0, userid BIGINT(10) unsigned NOT NULL DEFAULT 0, name VARCHAR(255) NOT NULL DEFAULT '', scale TEXT NOT NULL, description TEXT NOT NULL, CONSTRAINT PRIMARY KEY (id) )

Úspech

(mysql): CREATE INDEX mdl_scalhist_act_ix ON mdl_scale_history (action)

Úspech

(mysql): CREATE INDEX mdl_scalhist_old_ix ON mdl_scale_history (oldid)

Úspech

(mysql): CREATE INDEX mdl_scalhist_cou_ix ON mdl_scale_history (courseid)

Úspech

(mysql): CREATE INDEX mdl_scalhist_log_ix ON mdl_scale_history (loggeduser)

Úspech

(mysql): SELECT * FROM mdl_course

(mysql): SELECT gi.*, cm.idnumber as cmidnumber, m.name as modname FROM mdl_grade_item gi, mdl_course_modules cm, mdl_modules m WHERE gi.courseid=1 AND m.id=gi.modid AND cm.instance=gi.cminstance ORDER BY gi.sort_order ASC

(mysql): SELECT gi.*, cm.idnumber as cmidnumber, m.name as modname FROM mdl_grade_item gi, mdl_course_modules cm, mdl_modules m WHERE gi.courseid=2 AND m.id=gi.modid AND cm.instance=gi.cminstance ORDER BY gi.sort_order ASC

(mysql): SELECT gi.*, cm.idnumber as cmidnumber, m.name as modname FROM mdl_grade_item gi, mdl_course_modules cm, mdl_modules m WHERE gi.courseid=5 AND m.id=gi.modid AND cm.instance=gi.cminstance ORDER BY gi.sort_order ASC

(mysql): SELECT * FROM mdl_grade_category WHERE courseid = '5' ORDER BY id

(mysql): SELECT * FROM mdl_grade_categories WHERE id = '-1'

(mysql): INSERT INTO mdl_grade_categories ( COURSEID, PARENT, FULLNAME, AGGREGATION, AGGREGATEONLYGRADED, TIMECREATED, TIMEMODIFIED ) VALUES ( 5, null, '?', 11, 0, 1222355036, 1222355036 )

(mysql): SELECT LAST_INSERT_ID()

(mysql): SHOW COLUMNS FROM `mdl_grade_categories`

(mysql): UPDATE mdl_grade_categories SET courseid = '5',parent = NULL,depth = '1',path = '/1',fullname = '?',aggregation = '11',aggregateonlygraded = '0',timecreated = '1222355036',timemodified = '1222355036' WHERE id = 1

(mysql): SELECT * FROM mdl_grade_items WHERE id = '-1'

(mysql): INSERT INTO mdl_grade_items ( COURSEID, ITEMTYPE, ITEMINSTANCE, GRADETYPE, SORTORDER, DISPLAY, NEEDSUPDATE, TIMECREATED, TIMEMODIFIED ) VALUES ( 5, 'course', 1, 1, 1, 2, 1, 1222355036, 1222355036 )

(mysql): SELECT LAST_INSERT_ID()

(mysql): INSERT INTO mdl_grade_items ( COURSEID, CATEGORYID, ITEMNAME, ITEMTYPE, ITEMMODULE, ITEMINSTANCE, ITEMNUMBER, IDNUMBER, GRADETYPE, MULTFACTOR, AGGREGATIONCOEF, SORTORDER, HIDDEN, NEEDSUPDATE, TIMECREATED, TIMEMODIFIED ) VALUES ( 5, 1, null, 'mod', 'quiz', 8, 0, null, 1, 1.0000000000, 0, 2, 0, 1, 1222355036, 1222355036 )

(mysql): SELECT LAST_INSERT_ID()

(mysql): SELECT * FROM mdl_grade_exceptions WHERE courseid = '5'

(mysql): SELECT gi.*, cm.idnumber as cmidnumber, m.name as modname FROM mdl_grade_item gi, mdl_course_modules cm, mdl_modules m WHERE gi.courseid=4 AND m.id=gi.modid AND cm.instance=gi.cminstance ORDER BY gi.sort_order ASC

(mysql): SELECT * FROM mdl_grade_category WHERE courseid = '4' ORDER BY id

(mysql): INSERT INTO mdl_grade_categories ( COURSEID, PARENT, FULLNAME, AGGREGATION, AGGREGATEONLYGRADED, TIMECREATED, TIMEMODIFIED ) VALUES ( 4, null, '?', 11, 0, 1222355036, 1222355036 )

(mysql): SELECT LAST_INSERT_ID()

(mysql): SHOW COLUMNS FROM `mdl_grade_categories`

(mysql): UPDATE mdl_grade_categories SET courseid = '4',parent = NULL,depth = '1',path = '/2',fullname = '?',aggregation = '11',aggregateonlygraded = '0',timecreated = '1222355036',timemodified = '1222355036' WHERE id = 2

(mysql): INSERT INTO mdl_grade_items ( COURSEID, ITEMTYPE, ITEMINSTANCE, GRADETYPE, SORTORDER, DISPLAY, NEEDSUPDATE, TIMECREATED, TIMEMODIFIED ) VALUES ( 4, 'course', 2, 1, 1, 2, 1, 1222355036, 1222355036 )

(mysql): SELECT LAST_INSERT_ID()

(mysql): INSERT INTO mdl_grade_items ( COURSEID, CATEGORYID, ITEMNAME, ITEMTYPE, ITEMMODULE, ITEMINSTANCE, ITEMNUMBER, IDNUMBER, GRADETYPE, MULTFACTOR, AGGREGATIONCOEF, SORTORDER, HIDDEN, NEEDSUPDATE, TIMECREATED, TIMEMODIFIED ) VALUES ( 4, 2, null, 'mod', 'lesson', 1, 0, null, 1, 1.0000000000, 0, 2, 0, 1, 1222355036, 1222355036 )

(mysql): SELECT LAST_INSERT_ID()

(mysql): INSERT INTO mdl_grade_items ( COURSEID, CATEGORYID, ITEMNAME, ITEMTYPE, ITEMMODULE, ITEMINSTANCE, ITEMNUMBER, IDNUMBER, GRADETYPE, MULTFACTOR, AGGREGATIONCOEF, SORTORDER, HIDDEN, NEEDSUPDATE, TIMECREATED, TIMEMODIFIED ) VALUES ( 4, 2, null, 'mod', 'quiz', 1, 0, null, 1, 1.0000000000, 0, 3, 0, 1, 1222355036, 1222355036 )

(mysql): SELECT LAST_INSERT_ID()

(mysql): INSERT INTO mdl_grade_items ( COURSEID, CATEGORYID, ITEMNAME, ITEMTYPE, ITEMMODULE, ITEMINSTANCE, ITEMNUMBER, IDNUMBER, GRADETYPE, MULTFACTOR, AGGREGATIONCOEF, SORTORDER, HIDDEN, NEEDSUPDATE, TIMECREATED, TIMEMODIFIED ) VALUES ( 4, 2, null, 'mod', 'lesson', 2, 0, null, 1, 1.0000000000, 0, 4, 0, 1, 1222355036, 1222355036 )

(mysql): SELECT LAST_INSERT_ID()

(mysql): INSERT INTO mdl_grade_items ( COURSEID, CATEGORYID, ITEMNAME, ITEMTYPE, ITEMMODULE, ITEMINSTANCE, ITEMNUMBER, IDNUMBER, GRADETYPE, MULTFACTOR, AGGREGATIONCOEF, SORTORDER, HIDDEN, NEEDSUPDATE, TIMECREATED, TIMEMODIFIED ) VALUES ( 4, 2, null, 'mod', 'quiz', 2, 0, null, 1, 1.0000000000, 0, 5, 0, 1, 1222355036, 1222355036 )

(mysql): SELECT LAST_INSERT_ID()

(mysql): INSERT INTO mdl_grade_items ( COURSEID, CATEGORYID, ITEMNAME, ITEMTYPE, ITEMMODULE, ITEMINSTANCE, ITEMNUMBER, IDNUMBER, GRADETYPE, MULTFACTOR, AGGREGATIONCOEF, SORTORDER, HIDDEN, NEEDSUPDATE, TIMECREATED, TIMEMODIFIED ) VALUES ( 4, 2, null, 'mod', 'quiz', 3, 0, null, 1, 1.0000000000, 0, 6, 0, 1, 1222355036, 1222355036 )

(mysql): SELECT LAST_INSERT_ID()

(mysql): INSERT INTO mdl_grade_items ( COURSEID, CATEGORYID, ITEMNAME, ITEMTYPE, ITEMMODULE, ITEMINSTANCE, ITEMNUMBER, IDNUMBER, GRADETYPE, MULTFACTOR, AGGREGATIONCOEF, SORTORDER, HIDDEN, NEEDSUPDATE, TIMECREATED, TIMEMODIFIED ) VALUES ( 4, 2, null, 'mod', 'assignment', 2, 0, null, 1, 1.0000000000, 0, 7, 0, 1, 1222355036, 1222355036 )

(mysql): SELECT LAST_INSERT_ID()

(mysql): INSERT INTO mdl_grade_items ( COURSEID, CATEGORYID, ITEMNAME, ITEMTYPE, ITEMMODULE, ITEMINSTANCE, ITEMNUMBER, IDNUMBER, GRADETYPE, MULTFACTOR, AGGREGATIONCOEF, SORTORDER, HIDDEN, NEEDSUPDATE, TIMECREATED, TIMEMODIFIED ) VALUES ( 4, 2, null, 'mod', 'assignment', 3, 0, null, 1, 1.0000000000, 0, 8, 0, 1, 1222355036, 1222355036 )

(mysql): SELECT LAST_INSERT_ID()

(mysql): INSERT INTO mdl_grade_items ( COURSEID, CATEGORYID, ITEMNAME, ITEMTYPE, ITEMMODULE, ITEMINSTANCE, ITEMNUMBER, IDNUMBER, GRADETYPE, MULTFACTOR, AGGREGATIONCOEF, SORTORDER, HIDDEN, NEEDSUPDATE, TIMECREATED, TIMEMODIFIED ) VALUES ( 4, 2, null, 'mod', 'assignment', 4, 0, null, 1, 1.0000000000, 0, 9, 0, 1, 1222355036, 1222355036 )

(mysql): SELECT LAST_INSERT_ID()

(mysql): INSERT INTO mdl_grade_items ( COURSEID, CATEGORYID, ITEMNAME, ITEMTYPE, ITEMMODULE, ITEMINSTANCE, ITEMNUMBER, IDNUMBER, GRADETYPE, MULTFACTOR, AGGREGATIONCOEF, SORTORDER, HIDDEN, NEEDSUPDATE, TIMECREATED, TIMEMODIFIED ) VALUES ( 4, 2, null, 'mod', 'quiz', 4, 0, null, 1, 1.0000000000, 0, 10, 0, 1, 1222355036, 1222355036 )

(mysql): SELECT LAST_INSERT_ID()

(mysql): INSERT INTO mdl_grade_items ( COURSEID, CATEGORYID, ITEMNAME, ITEMTYPE, ITEMMODULE, ITEMINSTANCE, ITEMNUMBER, IDNUMBER, GRADETYPE, MULTFACTOR, AGGREGATIONCOEF, SORTORDER, HIDDEN, NEEDSUPDATE, TIMECREATED, TIMEMODIFIED ) VALUES ( 4, 2, null, 'mod', 'quiz', 5, 0, null, 1, 1.0000000000, 0, 11, 0, 1, 1222355036, 1222355036 )

(mysql): SELECT LAST_INSERT_ID()

(mysql): INSERT INTO mdl_grade_items ( COURSEID, CATEGORYID, ITEMNAME, ITEMTYPE, ITEMMODULE, ITEMINSTANCE, ITEMNUMBER, IDNUMBER, GRADETYPE, MULTFACTOR, AGGREGATIONCOEF, SORTORDER, HIDDEN, NEEDSUPDATE, TIMECREATED, TIMEMODIFIED ) VALUES ( 4, 2, null, 'mod', 'quiz', 6, 0, null, 1, 1.0000000000, 0, 12, 0, 1, 1222355036, 1222355036 )

(mysql): SELECT LAST_INSERT_ID()

(mysql): INSERT INTO mdl_grade_items ( COURSEID, CATEGORYID, ITEMNAME, ITEMTYPE, ITEMMODULE, ITEMINSTANCE, ITEMNUMBER, IDNUMBER, GRADETYPE, MULTFACTOR, AGGREGATIONCOEF, SORTORDER, HIDDEN, NEEDSUPDATE, TIMECREATED, TIMEMODIFIED ) VALUES ( 4, 2, null, 'mod', 'assignment', 1, 0, null, 1, 1.0000000000, 0, 13, 0, 1, 1222355036, 1222355036 )

(mysql): SELECT LAST_INSERT_ID()

(mysql): INSERT INTO mdl_grade_items ( COURSEID, CATEGORYID, ITEMNAME, ITEMTYPE, ITEMMODULE, ITEMINSTANCE, ITEMNUMBER, IDNUMBER, GRADETYPE, MULTFACTOR, AGGREGATIONCOEF, SORTORDER, HIDDEN, NEEDSUPDATE, TIMECREATED, TIMEMODIFIED ) VALUES ( 4, 2, null, 'mod', 'quiz', 7, 0, null, 1, 1.0000000000, 0, 14, 0, 1, 1222355036, 1222355036 )

(mysql): SELECT LAST_INSERT_ID()

(mysql): SELECT * FROM mdl_grade_exceptions WHERE courseid = '4'

(mysql): SELECT gi.*, cm.idnumber as cmidnumber, m.name as modname FROM mdl_grade_item gi, mdl_course_modules cm, mdl_modules m WHERE gi.courseid=6 AND m.id=gi.modid AND cm.instance=gi.cminstance ORDER BY gi.sort_order ASC

(mysql): SELECT * FROM mdl_grade_category WHERE courseid = '6' ORDER BY id

(mysql): INSERT INTO mdl_grade_categories ( COURSEID, PARENT, FULLNAME, AGGREGATION, AGGREGATEONLYGRADED, TIMECREATED, TIMEMODIFIED ) VALUES ( 6, null, '?', 11, 0, 1222355036, 1222355036 )

(mysql): SELECT LAST_INSERT_ID()

(mysql): SHOW COLUMNS FROM `mdl_grade_categories`

(mysql): UPDATE mdl_grade_categories SET courseid = '6',parent = NULL,depth = '1',path = '/3',fullname = '?',aggregation = '11',aggregateonlygraded = '0',timecreated = '1222355036',timemodified = '1222355036' WHERE id = 3

(mysql): INSERT INTO mdl_grade_items ( COURSEID, ITEMTYPE, ITEMINSTANCE, GRADETYPE, SORTORDER, DISPLAY, NEEDSUPDATE, TIMECREATED, TIMEMODIFIED ) VALUES ( 6, 'course', 3, 1, 1, 2, 1, 1222355036, 1222355036 )

(mysql): SELECT LAST_INSERT_ID()

(mysql): INSERT INTO mdl_grade_items ( COURSEID, CATEGORYID, ITEMNAME, ITEMTYPE, ITEMMODULE, ITEMINSTANCE, ITEMNUMBER, IDNUMBER, GRADETYPE, MULTFACTOR, AGGREGATIONCOEF, SORTORDER, HIDDEN, NEEDSUPDATE, TIMECREATED, TIMEMODIFIED ) VALUES ( 6, 3, null, 'mod', 'quiz', 9, 0, null, 1, 1.0000000000, 0, 2, 0, 1, 1222355036, 1222355036 )

(mysql): SELECT LAST_INSERT_ID()

(mysql): INSERT INTO mdl_grade_items ( COURSEID, CATEGORYID, ITEMNAME, ITEMTYPE, ITEMMODULE, ITEMINSTANCE, ITEMNUMBER, IDNUMBER, GRADETYPE, MULTFACTOR, AGGREGATIONCOEF, SORTORDER, HIDDEN, NEEDSUPDATE, TIMECREATED, TIMEMODIFIED ) VALUES ( 6, 3, null, 'mod', 'quiz', 16, 0, null, 1, 1.0000000000, 0, 3, 0, 1, 1222355036, 1222355036 )

(mysql): SELECT LAST_INSERT_ID()

(mysql): INSERT INTO mdl_grade_items ( COURSEID, CATEGORYID, ITEMNAME, ITEMTYPE, ITEMMODULE, ITEMINSTANCE, ITEMNUMBER, IDNUMBER, GRADETYPE, MULTFACTOR, AGGREGATIONCOEF, SORTORDER, HIDDEN, NEEDSUPDATE, TIMECREATED, TIMEMODIFIED ) VALUES ( 6, 3, null, 'mod', 'quiz', 10, 0, null, 1, 1.0000000000, 0, 4, 0, 1, 1222355036, 1222355036 )

(mysql): SELECT LAST_INSERT_ID()

(mysql): INSERT INTO mdl_grade_items ( COURSEID, CATEGORYID, ITEMNAME, ITEMTYPE, ITEMMODULE, ITEMINSTANCE, ITEMNUMBER, IDNUMBER, GRADETYPE, MULTFACTOR, AGGREGATIONCOEF, SORTORDER, HIDDEN, NEEDSUPDATE, TIMECREATED, TIMEMODIFIED ) VALUES ( 6, 3, null, 'mod', 'assignment', 25, 0, null, 1, 1.0000000000, 0, 5, 0, 1, 1222355036, 1222355036 )

(mysql): SELECT LAST_INSERT_ID()

(mysql): INSERT INTO mdl_grade_items ( COURSEID, CATEGORYID, ITEMNAME, ITEMTYPE, ITEMMODULE, ITEMINSTANCE, ITEMNUMBER, IDNUMBER, GRADETYPE, MULTFACTOR, AGGREGATIONCOEF, SORTORDER, HIDDEN, NEEDSUPDATE, TIMECREATED, TIMEMODIFIED ) VALUES ( 6, 3, null, 'mod', 'quiz', 11, 0, null, 1, 1.0000000000, 0, 6, 0, 1, 1222355036, 1222355036 )

(mysql): SELECT LAST_INSERT_ID()

(mysql): SELECT * FROM mdl_grade_exceptions WHERE courseid = '6'

(mysql): SELECT gi.*, cm.idnumber as cmidnumber, m.name as modname FROM mdl_grade_item gi, mdl_course_modules cm, mdl_modules m WHERE gi.courseid=7 AND m.id=gi.modid AND cm.instance=gi.cminstance ORDER BY gi.sort_order ASC

(mysql): SELECT * FROM mdl_grade_category WHERE courseid = '7' ORDER BY id

(mysql): INSERT INTO mdl_grade_categories ( COURSEID, PARENT, FULLNAME, AGGREGATION, AGGREGATEONLYGRADED, TIMECREATED, TIMEMODIFIED ) VALUES ( 7, null, '?', 11, 0, 1222355036, 1222355036 )

(mysql): SELECT LAST_INSERT_ID()

(mysql): SHOW COLUMNS FROM `mdl_grade_categories`

(mysql): UPDATE mdl_grade_categories SET courseid = '7',parent = NULL,depth = '1',path = '/4',fullname = '?',aggregation = '11',aggregateonlygraded = '0',timecreated = '1222355036',timemodified = '1222355036' WHERE id = 4

(mysql): INSERT INTO mdl_grade_items ( COURSEID, ITEMTYPE, ITEMINSTANCE, GRADETYPE, SORTORDER, DISPLAY, NEEDSUPDATE, TIMECREATED, TIMEMODIFIED ) VALUES ( 7, 'course', 4, 1, 1, 2, 1, 1222355036, 1222355036 )

(mysql): SELECT LAST_INSERT_ID()

(mysql): INSERT INTO mdl_grade_items ( COURSEID, CATEGORYID, ITEMNAME, ITEMTYPE, ITEMMODULE, ITEMINSTANCE, ITEMNUMBER, IDNUMBER, GRADETYPE, MULTFACTOR, AGGREGATIONCOEF, SORTORDER, HIDDEN, NEEDSUPDATE, TIMECREATED, TIMEMODIFIED ) VALUES ( 7, 4, null, 'mod', 'assignment', 5, 0, null, 1, 1.0000000000, 0, 2, 0, 1, 1222355036, 1222355036 )

(mysql): SELECT LAST_INSERT_ID()

(mysql): INSERT INTO mdl_grade_items ( COURSEID, CATEGORYID, ITEMNAME, ITEMTYPE, ITEMMODULE, ITEMINSTANCE, ITEMNUMBER, IDNUMBER, GRADETYPE, MULTFACTOR, AGGREGATIONCOEF, SORTORDER, HIDDEN, NEEDSUPDATE, TIMECREATED, TIMEMODIFIED ) VALUES ( 7, 4, null, 'mod', 'assignment', 21, 0, null, 1, 1.0000000000, 0, 3, 0, 1, 1222355036, 1222355036 )

(mysql): SELECT LAST_INSERT_ID()

(mysql): INSERT INTO mdl_grade_items ( COURSEID, CATEGORYID, ITEMNAME, ITEMTYPE, ITEMMODULE, ITEMINSTANCE, ITEMNUMBER, IDNUMBER, GRADETYPE, MULTFACTOR, AGGREGATIONCOEF, SORTORDER, HIDDEN, NEEDSUPDATE, TIMECREATED, TIMEMODIFIED ) VALUES ( 7, 4, null, 'mod', 'assignment', 6, 0, null, 1, 1.0000000000, 0, 4, 0, 1, 1222355036, 1222355036 )

(mysql): SELECT LAST_INSERT_ID()

(mysql): INSERT INTO mdl_grade_items ( COURSEID, CATEGORYID, ITEMNAME, ITEMTYPE, ITEMMODULE, ITEMINSTANCE, ITEMNUMBER, IDNUMBER, GRADETYPE, MULTFACTOR, AGGREGATIONCOEF, SORTORDER, HIDDEN, NEEDSUPDATE, TIMECREATED, TIMEMODIFIED ) VALUES ( 7, 4, null, 'mod', 'journal', 5, 0, null, 1, 1.0000000000, 0, 5, 0, 1, 1222355036, 1222355036 )

(mysql): SELECT LAST_INSERT_ID()

(mysql): INSERT INTO mdl_grade_items ( COURSEID, CATEGORYID, ITEMNAME, ITEMTYPE, ITEMMODULE, ITEMINSTANCE, ITEMNUMBER, IDNUMBER, GRADETYPE, MULTFACTOR, AGGREGATIONCOEF, SORTORDER, HIDDEN, NEEDSUPDATE, TIMECREATED, TIMEMODIFIED ) VALUES ( 7, 4, null, 'mod', 'assignment', 7, 0, null, 1, 1.0000000000, 0, 6, 0, 1, 1222355037, 1222355037 )

(mysql): SELECT LAST_INSERT_ID()

(mysql): INSERT INTO mdl_grade_items ( COURSEID, CATEGORYID, ITEMNAME, ITEMTYPE, ITEMMODULE, ITEMINSTANCE, ITEMNUMBER, IDNUMBER, GRADETYPE, MULTFACTOR, AGGREGATIONCOEF, SORTORDER, HIDDEN, NEEDSUPDATE, TIMECREATED, TIMEMODIFIED ) VALUES ( 7, 4, null, 'mod', 'assignment', 8, 0, null, 1, 1.0000000000, 0, 7, 0, 1, 1222355037, 1222355037 )

(mysql): SELECT LAST_INSERT_ID()

(mysql): INSERT INTO mdl_grade_items ( COURSEID, CATEGORYID, ITEMNAME, ITEMTYPE, ITEMMODULE, ITEMINSTANCE, ITEMNUMBER, IDNUMBER, GRADETYPE, MULTFACTOR, AGGREGATIONCOEF, SORTORDER, HIDDEN, NEEDSUPDATE, TIMECREATED, TIMEMODIFIED ) VALUES ( 7, 4, null, 'mod', 'assignment', 9, 0, null, 1, 1.0000000000, 0, 8, 0, 1, 1222355037, 1222355037 )

(mysql): SELECT LAST_INSERT_ID()

(mysql): INSERT INTO mdl_grade_items ( COURSEID, CATEGORYID, ITEMNAME, ITEMTYPE, ITEMMODULE, ITEMINSTANCE, ITEMNUMBER, IDNUMBER, GRADETYPE, MULTFACTOR, AGGREGATIONCOEF, SORTORDER, HIDDEN, NEEDSUPDATE, TIMECREATED, TIMEMODIFIED ) VALUES ( 7, 4, null, 'mod', 'assignment', 10, 0, null, 1, 1.0000000000, 0, 9, 0, 1, 1222355037, 1222355037 )

(mysql): SELECT LAST_INSERT_ID()

(mysql): INSERT INTO mdl_grade_items ( COURSEID, CATEGORYID, ITEMNAME, ITEMTYPE, ITEMMODULE, ITEMINSTANCE, ITEMNUMBER, IDNUMBER, GRADETYPE, MULTFACTOR, AGGREGATIONCOEF, SORTORDER, HIDDEN, NEEDSUPDATE, TIMECREATED, TIMEMODIFIED ) VALUES ( 7, 4, null, 'mod', 'assignment', 14, 0, null, 1, 1.0000000000, 0, 10, 0, 1, 1222355037, 1222355037 )

(mysql): SELECT LAST_INSERT_ID()

(mysql): INSERT INTO mdl_grade_items ( COURSEID, CATEGORYID, ITEMNAME, ITEMTYPE, ITEMMODULE, ITEMINSTANCE, ITEMNUMBER, IDNUMBER, GRADETYPE, MULTFACTOR, AGGREGATIONCOEF, SORTORDER, HIDDEN, NEEDSUPDATE, TIMECREATED, TIMEMODIFIED ) VALUES ( 7, 4, null, 'mod', 'assignment', 15, 0, null, 1, 1.0000000000, 0, 11, 0, 1, 1222355037, 1222355037 )

(mysql): SELECT LAST_INSERT_ID()

(mysql): INSERT INTO mdl_grade_items ( COURSEID, CATEGORYID, ITEMNAME, ITEMTYPE, ITEMMODULE, ITEMINSTANCE, ITEMNUMBER, IDNUMBER, GRADETYPE, MULTFACTOR, AGGREGATIONCOEF, SORTORDER, HIDDEN, NEEDSUPDATE, TIMECREATED, TIMEMODIFIED ) VALUES ( 7, 4, null, 'mod', 'assignment', 11, 0, null, 1, 1.0000000000, 0, 12, 0, 1, 1222355037, 1222355037 )

(mysql): SELECT LAST_INSERT_ID()

(mysql): INSERT INTO mdl_grade_items ( COURSEID, CATEGORYID, ITEMNAME, ITEMTYPE, ITEMMODULE, ITEMINSTANCE, ITEMNUMBER, IDNUMBER, GRADETYPE, MULTFACTOR, AGGREGATIONCOEF, SORTORDER, HIDDEN, NEEDSUPDATE, TIMECREATED, TIMEMODIFIED ) VALUES ( 7, 4, null, 'mod', 'assignment', 12, 0, null, 1, 1.0000000000, 0, 13, 0, 1, 1222355037, 1222355037 )

(mysql): SELECT LAST_INSERT_ID()

(mysql): INSERT INTO mdl_grade_items ( COURSEID, CATEGORYID, ITEMNAME, ITEMTYPE, ITEMMODULE, ITEMINSTANCE, ITEMNUMBER, IDNUMBER, GRADETYPE, MULTFACTOR, AGGREGATIONCOEF, SORTORDER, HIDDEN, NEEDSUPDATE, TIMECREATED, TIMEMODIFIED ) VALUES ( 7, 4, null, 'mod', 'assignment', 13, 0, null, 1, 1.0000000000, 0, 14, 0, 1, 1222355037, 1222355037 )

(mysql): SELECT LAST_INSERT_ID()

(mysql): INSERT INTO mdl_grade_items ( COURSEID, CATEGORYID, ITEMNAME, ITEMTYPE, ITEMMODULE, ITEMINSTANCE, ITEMNUMBER, IDNUMBER, GRADETYPE, MULTFACTOR, AGGREGATIONCOEF, SORTORDER, HIDDEN, NEEDSUPDATE, TIMECREATED, TIMEMODIFIED ) VALUES ( 7, 4, null, 'mod', 'quiz', 12, 0, null, 1, 1.0000000000, 0, 15, 0, 1, 1222355037, 1222355037 )

(mysql): SELECT LAST_INSERT_ID()

(mysql): INSERT INTO mdl_grade_items ( COURSEID, CATEGORYID, ITEMNAME, ITEMTYPE, ITEMMODULE, ITEMINSTANCE, ITEMNUMBER, IDNUMBER, GRADETYPE, MULTFACTOR, AGGREGATIONCOEF, SORTORDER, HIDDEN, NEEDSUPDATE, TIMECREATED, TIMEMODIFIED ) VALUES ( 7, 4, null, 'mod', 'assignment', 16, 0, null, 1, 1.0000000000, 0, 16, 0, 1, 1222355037, 1222355037 )

(mysql): SELECT LAST_INSERT_ID()

(mysql): INSERT INTO mdl_grade_items ( COURSEID, CATEGORYID, ITEMNAME, ITEMTYPE, ITEMMODULE, ITEMINSTANCE, ITEMNUMBER, IDNUMBER, GRADETYPE, MULTFACTOR, AGGREGATIONCOEF, SORTORDER, HIDDEN, NEEDSUPDATE, TIMECREATED, TIMEMODIFIED ) VALUES ( 7, 4, null, 'mod', 'assignment', 17, 0, null, 1, 1.0000000000, 0, 17, 0, 1, 1222355037, 1222355037 )

(mysql): SELECT LAST_INSERT_ID()

(mysql): INSERT INTO mdl_grade_items ( COURSEID, CATEGORYID, ITEMNAME, ITEMTYPE, ITEMMODULE, ITEMINSTANCE, ITEMNUMBER, IDNUMBER, GRADETYPE, MULTFACTOR, AGGREGATIONCOEF, SORTORDER, HIDDEN, NEEDSUPDATE, TIMECREATED, TIMEMODIFIED ) VALUES ( 7, 4, null, 'mod', 'assignment', 18, 0, null, 1, 1.0000000000, 0, 18, 0, 1, 1222355037, 1222355037 )

(mysql): SELECT LAST_INSERT_ID()

(mysql): INSERT INTO mdl_grade_items ( COURSEID, CATEGORYID, ITEMNAME, ITEMTYPE, ITEMMODULE, ITEMINSTANCE, ITEMNUMBER, IDNUMBER, GRADETYPE, MULTFACTOR, AGGREGATIONCOEF, SORTORDER, HIDDEN, NEEDSUPDATE, TIMECREATED, TIMEMODIFIED ) VALUES ( 7, 4, null, 'mod', 'quiz', 19, 0, null, 1, 1.0000000000, 0, 19, 0, 1, 1222355037, 1222355037 )

(mysql): SELECT LAST_INSERT_ID()

(mysql): SELECT * FROM mdl_grade_exceptions WHERE courseid = '7'

(mysql): SELECT gi.*, cm.idnumber as cmidnumber, m.name as modname FROM mdl_grade_item gi, mdl_course_modules cm, mdl_modules m WHERE gi.courseid=9 AND m.id=gi.modid AND cm.instance=gi.cminstance ORDER BY gi.sort_order ASC

(mysql): SELECT * FROM mdl_grade_category WHERE courseid = '9' ORDER BY id

(mysql): INSERT INTO mdl_grade_categories ( COURSEID, PARENT, FULLNAME, AGGREGATION, AGGREGATEONLYGRADED, TIMECREATED, TIMEMODIFIED ) VALUES ( 9, null, '?', 11, 0, 1222355037, 1222355037 )

(mysql): SELECT LAST_INSERT_ID()

(mysql): SHOW COLUMNS FROM `mdl_grade_categories`

(mysql): UPDATE mdl_grade_categories SET courseid = '9',parent = NULL,depth = '1',path = '/5',fullname = '?',aggregation = '11',aggregateonlygraded = '0',timecreated = '1222355037',timemodified = '1222355037' WHERE id = 5

(mysql): INSERT INTO mdl_grade_items ( COURSEID, ITEMTYPE, ITEMINSTANCE, GRADETYPE, SORTORDER, DISPLAY, NEEDSUPDATE, TIMECREATED, TIMEMODIFIED ) VALUES ( 9, 'course', 5, 1, 1, 2, 1, 1222355037, 1222355037 )

(mysql): SELECT LAST_INSERT_ID()

(mysql): INSERT INTO mdl_grade_categories ( COURSEID, PARENT, FULLNAME, AGGREGATION, DROPLOW, AGGREGATEONLYGRADED, TIMECREATED, TIMEMODIFIED ) VALUES ( 9, 5, 'uncategorised', 11, 0, 0, 1222355037, 1222355037 )

(mysql): SELECT LAST_INSERT_ID()

(mysql): SHOW COLUMNS FROM `mdl_grade_categories`

(mysql): UPDATE mdl_grade_categories SET courseid = '9',parent = '5',depth = '2',path = '/5/6',fullname = 'uncategorised',aggregation = '11',droplow = '0',aggregateonlygraded = '0',timecreated = '1222355037',timemodified = '1222355037' WHERE id = 6

(mysql): INSERT INTO mdl_grade_items ( COURSEID, ITEMTYPE, ITEMINSTANCE, GRADETYPE, PLUSFACTOR, AGGREGATIONCOEF, SORTORDER, DISPLAY, HIDDEN, NEEDSUPDATE, TIMECREATED, TIMEMODIFIED ) VALUES ( 9, 'category', 6, 1, 0, 0.00, 2, 2, 0, 1, 1222355037, 1222355037 )

(mysql): SELECT LAST_INSERT_ID()

(mysql): INSERT INTO mdl_grade_categories ( COURSEID, PARENT, FULLNAME, AGGREGATION, DROPLOW, AGGREGATEONLYGRADED, TIMECREATED, TIMEMODIFIED ) VALUES ( 9, 5, '1. štvrťrok', 11, 0, 0, 1222355037, 1222355037 )

(mysql): SELECT LAST_INSERT_ID()

(mysql): SHOW COLUMNS FROM `mdl_grade_categories`

(mysql): UPDATE mdl_grade_categories SET courseid = '9',parent = '5',depth = '2',path = '/5/7',fullname = '1. štvrťrok',aggregation = '11',droplow = '0',aggregateonlygraded = '0',timecreated = '1222355037',timemodified = '1222355037' WHERE id = 7

(mysql): INSERT INTO mdl_grade_items ( COURSEID, ITEMTYPE, ITEMINSTANCE, GRADETYPE, PLUSFACTOR, AGGREGATIONCOEF, SORTORDER, DISPLAY, HIDDEN, NEEDSUPDATE, TIMECREATED, TIMEMODIFIED ) VALUES ( 9, 'category', 7, 1, 0, 100.00, 3, 2, 0, 1, 1222355037, 1222355037 )

(mysql): SELECT LAST_INSERT_ID()

(mysql): INSERT INTO mdl_grade_categories ( COURSEID, PARENT, FULLNAME, AGGREGATION, DROPLOW, AGGREGATEONLYGRADED, TIMECREATED, TIMEMODIFIED ) VALUES ( 9, 5, '2. štvrťrok', 11, 0, 0, 1222355037, 1222355037 )

(mysql): SELECT LAST_INSERT_ID()

(mysql): SHOW COLUMNS FROM `mdl_grade_categories`

(mysql): UPDATE mdl_grade_categories SET courseid = '9',parent = '5',depth = '2',path = '/5/8',fullname = '2. štvrťrok',aggregation = '11',droplow = '0',aggregateonlygraded = '0',timecreated = '1222355037',timemodified = '1222355037' WHERE id = 8

(mysql): INSERT INTO mdl_grade_items ( COURSEID, ITEMTYPE, ITEMINSTANCE, GRADETYPE, PLUSFACTOR, AGGREGATIONCOEF, SORTORDER, DISPLAY, HIDDEN, NEEDSUPDATE, TIMECREATED, TIMEMODIFIED ) VALUES ( 9, 'category', 8, 1, 0, 0.00, 4, 2, 0, 1, 1222355037, 1222355037 )

(mysql): SELECT LAST_INSERT_ID()

(mysql): SHOW COLUMNS FROM `mdl_grade_categories`

(mysql): INSERT INTO mdl_grade_items ( COURSEID, CATEGORYID, ITEMNAME, ITEMTYPE, ITEMMODULE, ITEMINSTANCE, ITEMNUMBER, IDNUMBER, GRADETYPE, MULTFACTOR, AGGREGATIONCOEF, SORTORDER, HIDDEN, NEEDSUPDATE, TIMECREATED, TIMEMODIFIED ) VALUES ( 9, 7, null, 'mod', 'quiz', 17, 0, null, 1, 1.0000000000, 0, 5, 0, 1, 1222355037, 1222355037 )

(mysql): SELECT LAST_INSERT_ID()

(mysql): INSERT INTO mdl_grade_items ( COURSEID, CATEGORYID, ITEMNAME, ITEMTYPE, ITEMMODULE, ITEMINSTANCE, ITEMNUMBER, IDNUMBER, GRADETYPE, MULTFACTOR, AGGREGATIONCOEF, SORTORDER, HIDDEN, NEEDSUPDATE, TIMECREATED, TIMEMODIFIED ) VALUES ( 9, 6, null, 'mod', 'game', 2, 0, null, 1, 1.0000000000, 0, 6, 0, 1, 1222355037, 1222355037 )

(mysql): SELECT LAST_INSERT_ID()

(mysql): INSERT INTO mdl_grade_items ( COURSEID, CATEGORYID, ITEMNAME, ITEMTYPE, ITEMMODULE, ITEMINSTANCE, ITEMNUMBER, IDNUMBER, GRADETYPE, MULTFACTOR, AGGREGATIONCOEF, SORTORDER, HIDDEN, NEEDSUPDATE, TIMECREATED, TIMEMODIFIED ) VALUES ( 9, 8, null, 'mod', 'quiz', 18, 0, null, 1, 1.0000000000, 0, 7, 0, 1, 1222355037, 1222355037 )

(mysql): SELECT LAST_INSERT_ID()

(mysql): INSERT INTO mdl_grade_items ( COURSEID, CATEGORYID, ITEMNAME, ITEMTYPE, ITEMMODULE, ITEMINSTANCE, ITEMNUMBER, IDNUMBER, GRADETYPE, MULTFACTOR, AGGREGATIONCOEF, SORTORDER, HIDDEN, NEEDSUPDATE, TIMECREATED, TIMEMODIFIED ) VALUES ( 9, 6, null, 'mod', 'quiz', 20, 0, null, 1, 1.0000000000, 0, 8, 0, 1, 1222355037, 1222355037 )

(mysql): SELECT LAST_INSERT_ID()

(mysql): INSERT INTO mdl_grade_items ( COURSEID, CATEGORYID, ITEMNAME, ITEMTYPE, ITEMMODULE, ITEMINSTANCE, ITEMNUMBER, IDNUMBER, GRADETYPE, MULTFACTOR, AGGREGATIONCOEF, SORTORDER, HIDDEN, NEEDSUPDATE, TIMECREATED, TIMEMODIFIED ) VALUES ( 9, 6, null, 'mod', 'game', 3, 0, null, 1, 1.0000000000, 0, 9, 0, 1, 1222355037, 1222355037 )

(mysql): SELECT LAST_INSERT_ID()

(mysql): INSERT INTO mdl_grade_items ( COURSEID, CATEGORYID, ITEMNAME, ITEMTYPE, ITEMMODULE, ITEMINSTANCE, ITEMNUMBER, IDNUMBER, GRADETYPE, MULTFACTOR, AGGREGATIONCOEF, SORTORDER, HIDDEN, NEEDSUPDATE, TIMECREATED, TIMEMODIFIED ) VALUES ( 9, 6, null, 'mod', 'quiz', 21, 0, null, 1, 1.0000000000, 0, 10, 0, 1, 1222355037, 1222355037 )

(mysql): SELECT LAST_INSERT_ID()

(mysql): SELECT * FROM mdl_grade_exceptions WHERE courseid = '9'

(mysql): SELECT gi.*, cm.idnumber as cmidnumber, m.name as modname FROM mdl_grade_item gi, mdl_course_modules cm, mdl_modules m WHERE gi.courseid=8 AND m.id=gi.modid AND cm.instance=gi.cminstance ORDER BY gi.sort_order ASC

(mysql): SELECT * FROM mdl_grade_category WHERE courseid = '8' ORDER BY id

(mysql): INSERT INTO mdl_grade_categories ( COURSEID, PARENT, FULLNAME, AGGREGATION, AGGREGATEONLYGRADED, TIMECREATED, TIMEMODIFIED ) VALUES ( 8, null, '?', 11, 0, 1222355037, 1222355037 )

(mysql): SELECT LAST_INSERT_ID()

(mysql): SHOW COLUMNS FROM `mdl_grade_categories`

(mysql): UPDATE mdl_grade_categories SET courseid = '8',parent = NULL,depth = '1',path = '/9',fullname = '?',aggregation = '11',aggregateonlygraded = '0',timecreated = '1222355037',timemodified = '1222355037' WHERE id = 9

(mysql): INSERT INTO mdl_grade_items ( COURSEID, ITEMTYPE, ITEMINSTANCE, GRADETYPE, SORTORDER, DISPLAY, NEEDSUPDATE, TIMECREATED, TIMEMODIFIED ) VALUES ( 8, 'course', 9, 1, 1, 2, 1, 1222355037, 1222355037 )

(mysql): SELECT LAST_INSERT_ID()

(mysql): INSERT INTO mdl_grade_items ( COURSEID, CATEGORYID, ITEMNAME, ITEMTYPE, ITEMMODULE, ITEMINSTANCE, ITEMNUMBER, IDNUMBER, GRADETYPE, MULTFACTOR, AGGREGATIONCOEF, SORTORDER, HIDDEN, NEEDSUPDATE, TIMECREATED, TIMEMODIFIED ) VALUES ( 8, 9, null, 'mod', 'assignment', 22, 0, null, 1, 1.0000000000, 0, 2, 0, 1, 1222355037, 1222355037 )

(mysql): SELECT LAST_INSERT_ID()

(mysql): INSERT INTO mdl_grade_items ( COURSEID, CATEGORYID, ITEMNAME, ITEMTYPE, ITEMMODULE, ITEMINSTANCE, ITEMNUMBER, IDNUMBER, GRADETYPE, MULTFACTOR, AGGREGATIONCOEF, SORTORDER, HIDDEN, NEEDSUPDATE, TIMECREATED, TIMEMODIFIED ) VALUES ( 8, 9, null, 'mod', 'assignment', 23, 0, null, 1, 1.0000000000, 0, 3, 0, 1, 1222355037, 1222355037 )

(mysql): SELECT LAST_INSERT_ID()

(mysql): INSERT INTO mdl_grade_items ( COURSEID, CATEGORYID, ITEMNAME, ITEMTYPE, ITEMMODULE, ITEMINSTANCE, ITEMNUMBER, IDNUMBER, GRADETYPE, MULTFACTOR, AGGREGATIONCOEF, SORTORDER, HIDDEN, NEEDSUPDATE, TIMECREATED, TIMEMODIFIED ) VALUES ( 8, 9, null, 'mod', 'assignment', 24, 0, null, 1, 1.0000000000, 0, 4, 0, 1, 1222355037, 1222355037 )

(mysql): SELECT LAST_INSERT_ID()

(mysql): INSERT INTO mdl_grade_items ( COURSEID, CATEGORYID, ITEMNAME, ITEMTYPE, ITEMMODULE, ITEMINSTANCE, ITEMNUMBER, IDNUMBER, GRADETYPE, MULTFACTOR, AGGREGATIONCOEF, SORTORDER, HIDDEN, NEEDSUPDATE, TIMECREATED, TIMEMODIFIED ) VALUES ( 8, 9, null, 'mod', 'assignment', 26, 0, null, 1, 1.0000000000, 0, 5, 0, 1, 1222355037, 1222355037 )

(mysql): SELECT LAST_INSERT_ID()

(mysql): INSERT INTO mdl_grade_items ( COURSEID, CATEGORYID, ITEMNAME, ITEMTYPE, ITEMMODULE, ITEMINSTANCE, ITEMNUMBER, IDNUMBER, GRADETYPE, MULTFACTOR, AGGREGATIONCOEF, SORTORDER, HIDDEN, NEEDSUPDATE, TIMECREATED, TIMEMODIFIED ) VALUES ( 8, 9, null, 'mod', 'assignment', 27, 0, null, 1, 1.0000000000, 0, 6, 0, 1, 1222355037, 1222355037 )

(mysql): SELECT LAST_INSERT_ID()

(mysql): SELECT * FROM mdl_grade_exceptions WHERE courseid = '8'

(mysql): SELECT name FROM mdl_config WHERE name = 'version' LIMIT 1

(mysql): UPDATE mdl_config SET value = '2007072200' WHERE name = 'version'

(mysql): ALTER TABLE mdl_sessions2 MODIFY COLUMN sessdata LONGTEXT NULL after modified

Úspech

(mysql): SELECT name FROM mdl_config WHERE name = 'version' LIMIT 1

(mysql): UPDATE mdl_config SET value = '2007072400' WHERE name = 'version'

(mysql): SHOW TABLES

(mysql): CREATE TABLE mdl_grade_outcomes_courses ( id BIGINT(10) unsigned NOT NULL auto_increment, courseid BIGINT(10) unsigned NOT NULL, outcomeid BIGINT(10) unsigned NOT NULL, CONSTRAINT PRIMARY KEY (id) )

Úspech

(mysql): CREATE INDEX mdl_gradoutccour_cou_ix ON mdl_grade_outcomes_courses (courseid)

Úspech

(mysql): CREATE INDEX mdl_gradoutccour_out_ix ON mdl_grade_outcomes_courses (outcomeid)

Úspech

(mysql): CREATE UNIQUE INDEX mdl_gradoutccour_couout_uix ON mdl_grade_outcomes_courses (courseid, outcomeid)

Úspech

(mysql): SELECT name FROM mdl_config WHERE name = 'version' LIMIT 1

(mysql): UPDATE mdl_config SET value = '2007073100' WHERE name = 'version'

(mysql): SHOW TABLES

(mysql): CREATE TABLE mdl_tag ( id BIGINT(10) unsigned NOT NULL auto_increment, userid BIGINT(10) NOT NULL, name VARCHAR(255) NOT NULL DEFAULT '', tagtype VARCHAR(255) DEFAULT NULL, description TEXT, descriptionformat TINYINT(2) NOT NULL, flag SMALLINT(4) unsigned DEFAULT 0, timemodified BIGINT(10) unsigned DEFAULT NULL, CONSTRAINT PRIMARY KEY (id) )

Úspech

(mysql): CREATE UNIQUE INDEX mdl_tag_nam_uix ON mdl_tag (name)

Úspech

(mysql): SHOW TABLES

(mysql): CREATE TABLE mdl_tag_correlation ( id BIGINT(10) unsigned NOT NULL auto_increment, tagid BIGINT(10) NOT NULL, correlatedtags TEXT NOT NULL, CONSTRAINT PRIMARY KEY (id) )

Úspech

(mysql): CREATE UNIQUE INDEX mdl_tagcorr_tag_uix ON mdl_tag_correlation (tagid)

Úspech

(mysql): SHOW TABLES

(mysql): CREATE TABLE mdl_tag_instance ( id BIGINT(10) unsigned NOT NULL auto_increment, tagid BIGINT(10) NOT NULL, itemtype VARCHAR(255) NOT NULL DEFAULT '', itemid BIGINT(10) NOT NULL, CONSTRAINT PRIMARY KEY (id) )

Úspech

(mysql): CREATE INDEX mdl_taginst_tagiteite_ix ON mdl_tag_instance (tagid, itemtype, itemid)

Úspech

(mysql): SELECT name FROM mdl_config WHERE name = 'version' LIMIT 1

(mysql): UPDATE mdl_config SET value = '2007073101' WHERE name = 'version'

(mysql): ALTER TABLE mdl_tag ADD rawname VARCHAR(255) NOT NULL DEFAULT '' after name

Úspech

(mysql): SELECT name FROM mdl_config WHERE name = 'version' LIMIT 1

(mysql): UPDATE mdl_config SET value = '2007073103' WHERE name = 'version'

(mysql): SELECT name FROM mdl_config WHERE name = 'version' LIMIT 1

(mysql): UPDATE mdl_config SET value = '2007073105' WHERE name = 'version'

(mysql): SHOW TABLES

(mysql): SHOW INDEX FROM mdl_grade_outcomes

(mysql): CREATE UNIQUE INDEX mdl_gradoutc_cousho_uix ON mdl_grade_outcomes (courseid, shortname)

Úspech

(mysql): SELECT name FROM mdl_config WHERE name = 'version' LIMIT 1

(mysql): UPDATE mdl_config SET value = '2007080100' WHERE name = 'version'

(mysql): ALTER TABLE mdl_tag_instance DROP INDEX mdl_taginst_tagiteite_ix

Úspech

(mysql): SHOW TABLES

(mysql): SHOW INDEX FROM mdl_tag_instance

(mysql): CREATE UNIQUE INDEX mdl_taginst_tagiteite_uix ON mdl_tag_instance (tagid, itemtype, itemid)

Úspech

(mysql): SELECT name FROM mdl_config WHERE name = 'version' LIMIT 1

(mysql): UPDATE mdl_config SET value = '2007080202' WHERE name = 'version'

(mysql): SELECT name FROM mdl_config WHERE name = 'version' LIMIT 1

(mysql): UPDATE mdl_config SET value = '2007080300' WHERE name = 'version'

(mysql): ALTER TABLE mdl_course MODIFY COLUMN shortname VARCHAR(100) NOT NULL DEFAULT '' after fullname

Úspech

(mysql): SELECT name FROM mdl_config WHERE name = 'version' LIMIT 1

(mysql): UPDATE mdl_config SET value = '2007080800' WHERE name = 'version'

(mysql): ALTER TABLE mdl_context ADD path VARCHAR(255) DEFAULT NULL after instanceid

Úspech

(mysql): SHOW TABLES

(mysql): SHOW INDEX FROM mdl_context

(mysql): CREATE INDEX mdl_cont_pat_ix ON mdl_context (path)

Úspech

(mysql): ALTER TABLE mdl_context ADD depth TINYINT(2) unsigned NOT NULL DEFAULT 0 after path

Úspech

(mysql): SELECT * FROM mdl_context WHERE contextlevel = '10' LIMIT 1

(mysql): SHOW COLUMNS FROM `mdl_context`

(mysql): UPDATE mdl_context SET contextlevel = '10',instanceid = '0',path = '/1',depth = '1' WHERE id = 1

(mysql): SELECT name FROM mdl_config WHERE name = 'version' LIMIT 1

(mysql): UPDATE mdl_config SET value = '2007080900' WHERE name = 'version'

(mysql): SELECT name FROM mdl_config WHERE name = 'version' LIMIT 1

(mysql): UPDATE mdl_config SET value = '2007080903' WHERE name = 'version'

(mysql): SELECT q.* FROM mdl_question q LEFT JOIN mdl_quiz_question_instances qqi ON q.id = qqi.question WHERE q.qtype='random' AND qqi.question IS NULL

(mysql): DELETE FROM mdl_question WHERE id IN (1,53)

(mysql): SELECT * FROM mdl_question_categories

(mysql): SELECT DISTINCT qc.id, 1 FROM mdl_question q, mdl_question_categories qc WHERE q.qtype='random' AND qc.id = q.category AND q.questiontext = '1'

(mysql): SELECT shortname FROM mdl_course WHERE id = '4' LIMIT 1

(mysql): SELECT * FROM mdl_context WHERE contextlevel = '50' AND instanceid = '5' LIMIT 1

(mysql): SELECT shortname FROM mdl_course WHERE id = '6' LIMIT 1

(mysql): SELECT * FROM mdl_context WHERE contextlevel = '50' AND instanceid = '7' LIMIT 1

(mysql): SELECT shortname FROM mdl_course WHERE id = '6' LIMIT 1

(mysql): SELECT shortname FROM mdl_course WHERE id = '9' LIMIT 1

(mysql): SELECT * FROM mdl_context WHERE contextlevel = '50' AND instanceid = '9' LIMIT 1

(mysql): SELECT * FROM mdl_context WHERE contextlevel = '50' AND instanceid = '8' LIMIT 1

(mysql): SELECT shortname FROM mdl_course WHERE id = '6' LIMIT 1

(mysql): SELECT * FROM mdl_context WHERE contextlevel = '50' AND instanceid = '6' LIMIT 1

(mysql): SELECT shortname FROM mdl_course WHERE id = '9' LIMIT 1

(mysql): SELECT shortname FROM mdl_course WHERE id = '4' LIMIT 1

(mysql): ALTER TABLE mdl_question_categories DROP INDEX mdl_quescate_cou_ix

Úspech

(mysql): ALTER TABLE mdl_question_categories DROP COLUMN course

Úspech

(mysql): ALTER TABLE mdl_question_categories ADD contextid BIGINT(10) unsigned NOT NULL DEFAULT 0 after name

Úspech

(mysql): SHOW TABLES

(mysql): SHOW INDEX FROM mdl_question_categories

(mysql): CREATE INDEX mdl_quescate_con_ix ON mdl_question_categories (contextid)

Úspech

(mysql): ALTER TABLE mdl_question_categories DROP COLUMN publish

Úspech

(mysql): SHOW COLUMNS FROM `mdl_question_categories`

(mysql): UPDATE mdl_question_categories SET name = 'Prevody medzi číselnými sústavami (VYT3R)',contextid = '1',info = 'Prevody medzi číselnými sústavami',stamp = 'www.spseke.sk+060611105618+MCroUa',parent = '0',sortorder = '999' WHERE id = 1

(mysql): SHOW COLUMNS FROM `mdl_question_categories`

(mysql): UPDATE mdl_question_categories SET name = 'Z desiatkovej (VYT3R)',contextid = '1',info = 'Prevody z desiatkovej do iných sústav',stamp = 'www.spseke.sk+060611105708+tIgboI',parent = '1',sortorder = '999' WHERE id = 2

(mysql): SHOW COLUMNS FROM `mdl_question_categories`

(mysql): UPDATE mdl_question_categories SET name = 'Do desiatkovej (VYT3R)',contextid = '1',info = 'Prevody do desiatkovej sústavy z iných sústav',stamp = 'www.spseke.sk+060611105742+2WBl6m',parent = '1',sortorder = '999' WHERE id = 3

(mysql): SHOW COLUMNS FROM `mdl_question_categories`

(mysql): UPDATE mdl_question_categories SET name = 'Rýchle prevody (VYT3R)',contextid = '1',info = 'Rýchle prevody medzi sústavami zo základom rovným mocnine 2ky',stamp = 'www.spseke.sk+060611105921+OikaOX',parent = '1',sortorder = '999' WHERE id = 4

(mysql): SHOW COLUMNS FROM `mdl_question_categories`

(mysql): UPDATE mdl_question_categories SET name = 'Zložité prevody (VYT3R)',contextid = '1',info = 'Prevody medzi rôznymi sústavami s nedeisatkovym základom',stamp = 'www.spseke.sk+060611110257+7mCrbe',parent = '1',sortorder = '999' WHERE id = 5

(mysql): SHOW COLUMNS FROM `mdl_question_categories`

(mysql): UPDATE mdl_question_categories SET name = 'Mikropočítače (VYT3R)',contextid = '1',info = 'Všetko o programovaní Harwardskeho mikropočítača I8051',stamp = 'www.spseke.sk+070129115127+6gbaaH',parent = '0',sortorder = '999' WHERE id = 6

(mysql): SHOW COLUMNS FROM `mdl_question_categories`

(mysql): UPDATE mdl_question_categories SET name = 'Hardware mikropočítačov (VYT3R)',contextid = '1',info = 'Blokové schémy, registre, pamäte, hardwarové otázky',stamp = 'www.spseke.sk+070129115517+QbKPPN',parent = '6',sortorder = '999' WHERE id = 7

(mysql): SHOW COLUMNS FROM `mdl_question_categories`

(mysql): UPDATE mdl_question_categories SET name = 'Software mikropočítačov (VYT3R)',contextid = '1',info = 'Inštrukcie, možnosti software, obsluha prerušení,',stamp = 'www.spseke.sk+070129115715+vfrWdL',parent = '6',sortorder = '999' WHERE id = 8

(mysql): SHOW COLUMNS FROM `mdl_question_categories`

(mysql): UPDATE mdl_question_categories SET name = 'VYT1R - do dvojkovej',contextid = '104',info = 'Prevody číselných sústav do dvojkovej z inej sústavy',stamp = 'www.spseke.sk+060828085240+Yghh8f',parent = '15',sortorder = '999' WHERE id = 9

(mysql): SHOW COLUMNS FROM `mdl_question_categories`

(mysql): UPDATE mdl_question_categories SET name = 'VYT1R - Periférie',contextid = '104',info = 'Periférne zariadenia PC',stamp = 'www.spseke.sk+060828085311+aww4eb',parent = '15',sortorder = '999' WHERE id = 10

(mysql): SHOW COLUMNS FROM `mdl_question_categories`

(mysql): UPDATE mdl_question_categories SET name = 'VYT1R - Pamäťové médiá',contextid = '104',info = 'Pamäťové médiá',stamp = 'www.spseke.sk+060828085331+2W2qu5',parent = '15',sortorder = '999' WHERE id = 11

(mysql): SHOW COLUMNS FROM `mdl_question_categories`

(mysql): UPDATE mdl_question_categories SET name = 'VYT1R - Počítač',contextid = '104',info = 'Základné prvky počítača, HW, SW',stamp = 'www.spseke.sk+060828085410+nigIeU',parent = '15',sortorder = '999' WHERE id = 12

(mysql): SHOW COLUMNS FROM `mdl_question_categories`

(mysql): UPDATE mdl_question_categories SET name = 'VYT1R - DOS',contextid = '104',info = 'Príkazy DOSu',stamp = 'www.spseke.sk+060828085422+VTlkwi',parent = '15',sortorder = '999' WHERE id = 13

(mysql): SHOW COLUMNS FROM `mdl_question_categories`

(mysql): UPDATE mdl_question_categories SET name = 'Výpočtová technika 1. ročník',contextid = '104',info = 'Otázky pre testy pre 1. ročník VYT',stamp = 'www.spseke.sk+060828085612+KKVLla',parent = '0',sortorder = '999' WHERE id = 14

(mysql): SHOW COLUMNS FROM `mdl_question_categories`

(mysql): UPDATE mdl_question_categories SET name = 'Test č.2',contextid = '104',info = '',stamp = 'www.spseke.sk+060828085631+M3V3KG',parent = '14',sortorder = '999' WHERE id = 15

(mysql): SHOW COLUMNS FROM `mdl_question_categories`

(mysql): UPDATE mdl_question_categories SET name = 'Vianočné otázky (VYT4R)',contextid = '1',info = '',stamp = 'www.spseke.sk+061220094010+e0lu3x',parent = '23',sortorder = '999' WHERE id = 18

(mysql): SHOW COLUMNS FROM `mdl_question_categories`

(mysql): UPDATE mdl_question_categories SET name = 'Programovanie (I. až IV. roèník)',contextid = '128',info = '',stamp = 'www.spseke.sk+070214161717+GlstaJ',parent = '0',sortorder = '999' WHERE id = 19

(mysql): SHOW COLUMNS FROM `mdl_question_categories`

(mysql): UPDATE mdl_question_categories SET name = 'C - jazyk',contextid = '128',info = '',stamp = 'www.spseke.sk+070214161924+tsiVmH',parent = '19',sortorder = '999' WHERE id = 20

(mysql): SHOW COLUMNS FROM `mdl_question_categories`

(mysql): UPDATE mdl_question_categories SET name = 'VYT4R - 1.hodina (VYT4R)',contextid = '1',info = 'Pochopenie učiva - Údaje, informácie, znalosti',stamp = 'www.spseke.sk+070528111139+D2H11w',parent = '23',sortorder = '999' WHERE id = 21

(mysql): SHOW COLUMNS FROM `mdl_question_categories`

(mysql): UPDATE mdl_question_categories SET name = 'VYT4R - 2.hodina (VYT4R)',contextid = '1',info = 'Pochopenie učiva - Základné databázové pojmy',stamp = 'www.spseke.sk+070529093119+WadiUk',parent = '23',sortorder = '999' WHERE id = 22

(mysql): SHOW COLUMNS FROM `mdl_question_categories`

(mysql): UPDATE mdl_question_categories SET name = 'Databázy (VYT4R) (VYT4R)',contextid = '1',info = '',stamp = 'www.spseke.sk+070529093208+4guKeW',parent = '0',sortorder = '999' WHERE id = 23

(mysql): SHOW COLUMNS FROM `mdl_question_categories`

(mysql): UPDATE mdl_question_categories SET name = 'Modely PS (STE3R)',contextid = '1',info = '',stamp = 'www.spseke.sk+071018182450+ZXPifU',parent = '32',sortorder = '999' WHERE id = 28

(mysql): SHOW COLUMNS FROM `mdl_question_categories`

(mysql): UPDATE mdl_question_categories SET name = 'Východiskové nastavenie',contextid = '611',info = 'Nastavená kategória pre otázky.',stamp = 'www.spseke.sk+071018182428+rNwZqf',parent = '0',sortorder = '999' WHERE id = 27

(mysql): SHOW COLUMNS FROM `mdl_question_categories`

(mysql): UPDATE mdl_question_categories SET name = 'Východiskové nastavenie',contextid = '364',info = 'Nastavená kategória pre otázky.',stamp = 'www.spseke.sk+071011164004+oerikd',parent = '0',sortorder = '999' WHERE id = 24

(mysql): SHOW COLUMNS FROM `mdl_question_categories`

(mysql): UPDATE mdl_question_categories SET name = '4R - Teória (VYT4R)',contextid = '1',info = '',stamp = 'www.spseke.sk+071018080257+5yZfgz',parent = '23',sortorder = '999' WHERE id = 25

(mysql): SHOW COLUMNS FROM `mdl_question_categories`

(mysql): UPDATE mdl_question_categories SET name = '4R - Príklady na integritu',contextid = '125',info = '',stamp = 'www.spseke.sk+071018083717+TeaFwx',parent = '0',sortorder = '999' WHERE id = 26

(mysql): SHOW COLUMNS FROM `mdl_question_categories`

(mysql): UPDATE mdl_question_categories SET name = 'Prezentačná vrstva (STE3R)',contextid = '1',info = '',stamp = 'www.spseke.sk+071018182511+0br57f',parent = '32',sortorder = '999' WHERE id = 29

(mysql): SHOW COLUMNS FROM `mdl_question_categories`

(mysql): UPDATE mdl_question_categories SET name = 'Aplikačná vrstva (STE3R)',contextid = '1',info = '',stamp = 'www.spseke.sk+071018182544+uivpv4',parent = '32',sortorder = '999' WHERE id = 30

(mysql): SHOW COLUMNS FROM `mdl_question_categories`

(mysql): UPDATE mdl_question_categories SET name = 'Základné pojmy PS (STE3R)',contextid = '1',info = '',stamp = 'www.spseke.sk+071018195029+pCHGak',parent = '32',sortorder = '999' WHERE id = 31

(mysql): SHOW COLUMNS FROM `mdl_question_categories`

(mysql): UPDATE mdl_question_categories SET name = 'Sieťové technológie (STE3R) (STE3R)',contextid = '1',info = '',stamp = 'www.spseke.sk+071229101534+n6wl2V',parent = '0',sortorder = '999' WHERE id = 32

(mysql): SHOW COLUMNS FROM `mdl_question_categories`

(mysql): UPDATE mdl_question_categories SET name = 'Sieťová vrstva - teória (STE3R)',contextid = '1',info = '',stamp = 'www.spseke.sk+071229101755+6OBkp4',parent = '32',sortorder = '999' WHERE id = 33

(mysql): SHOW COLUMNS FROM `mdl_question_categories`

(mysql): UPDATE mdl_question_categories SET name = 'Sieťová vrstva - IP adresy (STE3R)',contextid = '1',info = '',stamp = 'www.spseke.sk+071229101822+5tqYdj',parent = '32',sortorder = '999' WHERE id = 34

(mysql): SHOW COLUMNS FROM `mdl_question_categories`

(mysql): UPDATE mdl_question_categories SET name = 'Transportná vrstva - teória (STE3R)',contextid = '1',info = '',stamp = 'www.spseke.sk+071229101839+r3agSF',parent = '32',sortorder = '999' WHERE id = 35

(mysql): SHOW COLUMNS FROM `mdl_question_categories`

(mysql): UPDATE mdl_question_categories SET name = 'Sieťová a transportná vrstva - Game (STE3R)',contextid = '1',info = '',stamp = 'www.spseke.sk+080111153954+WuRIw1',parent = '32',sortorder = '999' WHERE id = 44

(mysql): SHOW COLUMNS FROM `mdl_question_categories`

(mysql): UPDATE mdl_question_categories SET name = 'Sieťová vrstva - troubleshooting (STE3R)',contextid = '1',info = '',stamp = 'www.spseke.sk+071229124534+u2ftjU',parent = '32',sortorder = '999' WHERE id = 37

(mysql): SHOW COLUMNS FROM `mdl_question_categories`

(mysql): UPDATE mdl_question_categories SET name = 'Adresa siete (STE3R)',contextid = '1',info = '',stamp = 'www.spseke.sk+071229133314+lyEh7O',parent = '34',sortorder = '999' WHERE id = 38

(mysql): SHOW COLUMNS FROM `mdl_question_categories`

(mysql): UPDATE mdl_question_categories SET name = 'Masky (STE3R)',contextid = '1',info = '',stamp = 'www.spseke.sk+071229133332+bWUOkq',parent = '34',sortorder = '999' WHERE id = 39

(mysql): SHOW COLUMNS FROM `mdl_question_categories`

(mysql): UPDATE mdl_question_categories SET name = 'Broadcast (STE3R)',contextid = '1',info = '',stamp = 'www.spseke.sk+071229133345+Emv2AR',parent = '34',sortorder = '999' WHERE id = 40

(mysql): SHOW COLUMNS FROM `mdl_question_categories`

(mysql): UPDATE mdl_question_categories SET name = 'Triedy (STE3R)',contextid = '1',info = '',stamp = 'www.spseke.sk+071229135416+HB8uul',parent = '34',sortorder = '999' WHERE id = 41

(mysql): SHOW COLUMNS FROM `mdl_question_categories`

(mysql): UPDATE mdl_question_categories SET name = 'Smerovacia tabuľka (STE3R)',contextid = '1',info = '',stamp = 'www.spseke.sk+071229140449+h7jPey',parent = '33',sortorder = '999' WHERE id = 42

(mysql): SHOW COLUMNS FROM `mdl_question_categories`

(mysql): UPDATE mdl_question_categories SET name = 'Broadcastové domény (STE3R)',contextid = '1',info = '',stamp = 'www.spseke.sk+071229140504+qeS3M5',parent = '33',sortorder = '999' WHERE id = 43

(mysql): SHOW COLUMNS FROM `mdl_question_categories`

(mysql): UPDATE mdl_question_categories SET name = 'Zariadenia v sieti (STE3R)',contextid = '1',info = '',stamp = 'www.spseke.sk+080112091348+DU9aUj',parent = '31',sortorder = '999' WHERE id = 45

(mysql): SHOW COLUMNS FROM `mdl_question_categories`

(mysql): UPDATE mdl_question_categories SET name = 'Sieťové médiá (STE3R)',contextid = '1',info = '',stamp = 'www.spseke.sk+080112135510+NBMpqp',parent = '31',sortorder = '999' WHERE id = 46

(mysql): SHOW COLUMNS FROM `mdl_question_categories`

(mysql): UPDATE mdl_question_categories SET name = 'Adr. schémy - Bez VLSM (STE3R)',contextid = '1',info = '',stamp = 'www.spseke.sk+080112140404+ZQfIQS',parent = '34',sortorder = '999' WHERE id = 47

(mysql): SHOW COLUMNS FROM `mdl_question_categories`

(mysql): UPDATE mdl_question_categories SET name = 'Linková vrstva - Game (STE3R)',contextid = '1',info = '',stamp = 'www.spseke.sk+080303120130+AfOIM9',parent = '32',sortorder = '999' WHERE id = 48

(mysql): SHOW COLUMNS FROM `mdl_question_categories`

(mysql): UPDATE mdl_question_categories SET name = 'Linková vrstva (STE3R)',contextid = '1',info = '',stamp = 'www.spseke.sk+080312162503+WmpHxG',parent = '32',sortorder = '999' WHERE id = 49

(mysql): SHOW COLUMNS FROM `mdl_question_categories`

(mysql): UPDATE mdl_question_categories SET name = 'MAC komunikácia (STE3R)',contextid = '1',info = '',stamp = 'www.spseke.sk+080312172031+z8Apk5',parent = '49',sortorder = '999' WHERE id = 50

(mysql): SHOW COLUMNS FROM `mdl_question_categories`

(mysql): UPDATE mdl_question_categories SET name = 'Fyzická vrstva (STE3R)',contextid = '1',info = '',stamp = 'www.spseke.sk+080312173046+mh0Gkv',parent = '32',sortorder = '999' WHERE id = 51

(mysql): SHOW COLUMNS FROM `mdl_question_categories`

(mysql): UPDATE mdl_question_categories SET name = 'Elektrotechnika (VYT3R)',contextid = '1',info = 'Spínacie výkonové prvky',stamp = 'www.spseke.sk+080819190034+8M2Pfq',parent = '7',sortorder = '999' WHERE id = 52

(mysql): ALTER TABLE mdl_question ADD timecreated BIGINT(10) unsigned NOT NULL DEFAULT 0 after hidden

Úspech

(mysql): ALTER TABLE mdl_question ADD timemodified BIGINT(10) unsigned NOT NULL DEFAULT 0 after timecreated

Úspech

(mysql): ALTER TABLE mdl_question ADD createdby BIGINT(10) unsigned DEFAULT NULL after timemodified

Úspech

(mysql): ALTER TABLE mdl_question ADD modifiedby BIGINT(10) unsigned DEFAULT NULL after createdby

Úspech

(mysql): SHOW TABLES

(mysql): SHOW INDEX FROM mdl_question

(mysql): CREATE INDEX mdl_ques_cre_ix ON mdl_question (createdby)

Úspech

(mysql): SHOW TABLES

(mysql): SHOW INDEX FROM mdl_question

(mysql): CREATE INDEX mdl_ques_mod_ix ON mdl_question (modifiedby)

Úspech

(mysql): SELECT name FROM mdl_config WHERE name = 'version' LIMIT 1

(mysql): UPDATE mdl_config SET value = '2007081000' WHERE name = 'version'

(mysql): ALTER TABLE mdl_groups_members DROP INDEX mdl_groumemb_grouse_uix

Úspech

(mysql): ALTER TABLE mdl_groups_courses_groups DROP INDEX mdl_groucourgrou_cou_ix

Úspech

(mysql): ALTER TABLE mdl_groups_courses_groups DROP INDEX mdl_groucourgrou_gro_ix

Úspech

(mysql): ALTER TABLE mdl_groups_courses_groups DROP INDEX mdl_groucourgrou_cougro_uix

Úspech

(mysql): ALTER TABLE mdl_groups_courses_groupings DROP INDEX mdl_groucourgrou_cou2_ix

Úspech

(mysql): ALTER TABLE mdl_groups_courses_groupings DROP INDEX mdl_groucourgrou_gro2_ix

Úspech

(mysql): ALTER TABLE mdl_groups_courses_groupings DROP INDEX mdl_groucourgrou_cougro2_uix

Úspech

(mysql): ALTER TABLE mdl_groups_groupings_groups DROP INDEX mdl_grougrougrou_gro_ix

Úspech

(mysql): ALTER TABLE mdl_groups_groupings_groups DROP INDEX mdl_grougrougrou_gro2_ix

Úspech

(mysql): ALTER TABLE mdl_groups_groupings_groups DROP INDEX mdl_grougrougrou_grogro_uix

Úspech

(mysql): ALTER TABLE mdl_groups_groupings DROP COLUMN viewowngroup

Úspech

(mysql): ALTER TABLE mdl_groups_groupings DROP COLUMN viewallgroupsmembers

Úspech

(mysql): ALTER TABLE mdl_groups_groupings DROP COLUMN viewallgroupsactivities

Úspech

(mysql): ALTER TABLE mdl_groups_groupings DROP COLUMN teachersgroupmark

Úspech

(mysql): ALTER TABLE mdl_groups_groupings DROP COLUMN teachersgroupview

Úspech

(mysql): ALTER TABLE mdl_groups_groupings DROP COLUMN teachersoverride

Úspech

(mysql): ALTER TABLE mdl_groups_groupings DROP COLUMN teacherdeletable

Úspech

(mysql): ALTER TABLE mdl_groups_groupings RENAME TO mdl_groupings

Úspech

(mysql): ALTER TABLE mdl_groupings ADD courseid BIGINT(10) unsigned NOT NULL DEFAULT 0 after id

Úspech

(mysql): SHOW TABLES

(mysql): SHOW INDEX FROM mdl_groupings

(mysql): CREATE INDEX mdl_grou_cou_ix ON mdl_groupings (courseid)

Úspech

(mysql): ALTER TABLE mdl_groupings ADD configdata TEXT after description

Úspech

(mysql): ALTER TABLE mdl_groupings ADD timemodified BIGINT(10) unsigned NOT NULL DEFAULT 0 after timecreated

Úspech

(mysql): ALTER TABLE mdl_groups ADD courseid BIGINT(10) unsigned NOT NULL DEFAULT 0 after id

Úspech

(mysql): SHOW TABLES

(mysql): SHOW INDEX FROM mdl_groups

(mysql): CREATE INDEX mdl_grou_cou2_ix ON mdl_groups (courseid)

Úspech

(mysql): ALTER TABLE mdl_groups MODIFY COLUMN enrolmentkey VARCHAR(50) NULL DEFAULT NULL after description

Úspech

(mysql): ALTER TABLE mdl_groups_groupings_groups RENAME TO mdl_groupings_groups

Úspech

(mysql): SHOW TABLES

(mysql): SHOW INDEX FROM mdl_groupings_groups

(mysql): CREATE INDEX mdl_grougrou_gro_ix ON mdl_groupings_groups (groupingid)

Úspech

(mysql): SHOW TABLES

(mysql): SHOW INDEX FROM mdl_groupings_groups

(mysql): CREATE INDEX mdl_grougrou_gro2_ix ON mdl_groupings_groups (groupid)

Úspech

(mysql): UPDATE mdl_groups SET courseid = ( SELECT MAX(courseid) FROM mdl_groups_courses_groups gcg WHERE gcg.groupid = mdl_groups.id)

Úspech

(mysql): UPDATE mdl_groupings SET courseid = ( SELECT MAX(courseid) FROM mdl_groups_courses_groupings gcg WHERE gcg.groupingid = mdl_groupings.id)

Úspech

(mysql): DROP TABLE mdl_groups_courses_groups

Úspech

(mysql): DROP TABLE mdl_groups_courses_groupings

Úspech

(mysql): DELETE FROM mdl_config WHERE name = 'group_version'

(mysql): ALTER TABLE mdl_groups DROP COLUMN theme

Úspech

(mysql): ALTER TABLE mdl_groups DROP COLUMN lang

Úspech

(mysql): ALTER TABLE mdl_course ADD defaultgroupingid BIGINT(10) unsigned NOT NULL DEFAULT 0 after groupmodeforce

Úspech

(mysql): ALTER TABLE mdl_course_modules ADD groupingid BIGINT(10) unsigned NOT NULL DEFAULT 0 after groupmode

Úspech

(mysql): ALTER TABLE mdl_course_modules ADD groupmembersonly SMALLINT(4) unsigned NOT NULL DEFAULT 0 after groupingid

Úspech

(mysql): SHOW TABLES

(mysql): SHOW INDEX FROM mdl_course_modules

(mysql): CREATE INDEX mdl_courmodu_gro_ix ON mdl_course_modules (groupingid)

Úspech

(mysql): SELECT name FROM mdl_config WHERE name = 'version' LIMIT 1

(mysql): UPDATE mdl_config SET value = '2007081302' WHERE name = 'version'

(mysql): ALTER TABLE mdl_tag_instance ADD ordering BIGINT(10) unsigned NOT NULL DEFAULT 0 after itemid

Úspech

(mysql): SELECT name FROM mdl_config WHERE name = 'version' LIMIT 1

(mysql): UPDATE mdl_config SET value = '2007082300' WHERE name = 'version'

(mysql): ALTER TABLE mdl_tag_instance ADD timemodified BIGINT(10) unsigned NOT NULL DEFAULT 0 after ordering

Úspech

(mysql): SELECT name FROM mdl_config WHERE name = 'version' LIMIT 1

(mysql): UPDATE mdl_config SET value = '2007082700' WHERE name = 'version'

(mysql): SELECT * FROM mdl_tags

(mysql): SELECT * FROM mdl_blog_tag_instance

(mysql): DROP TABLE mdl_tags

Úspech

(mysql): DROP TABLE mdl_blog_tag_instance

Úspech

(mysql): SELECT name FROM mdl_config WHERE name = 'version' LIMIT 1

(mysql): UPDATE mdl_config SET value = '2007082701' WHERE name = 'version'

(mysql): ALTER TABLE mdl_tag MODIFY COLUMN userid BIGINT(10) unsigned NOT NULL after id

Úspech

(mysql): ALTER TABLE mdl_tag MODIFY COLUMN descriptionformat TINYINT(2) unsigned NOT NULL DEFAULT 0 after description

Úspech

(mysql): SHOW TABLES

(mysql): SHOW INDEX FROM mdl_tag

(mysql): CREATE INDEX mdl_tag_use_ix ON mdl_tag (userid)

Úspech

(mysql): ALTER TABLE mdl_tag_instance DROP INDEX mdl_taginst_tagiteite_uix

Úspech

(mysql): ALTER TABLE mdl_tag_instance MODIFY COLUMN tagid BIGINT(10) unsigned NOT NULL after id

Úspech

(mysql): SHOW TABLES

(mysql): SHOW INDEX FROM mdl_tag_instance

(mysql): CREATE INDEX mdl_taginst_tag_ix ON mdl_tag_instance (tagid)

Úspech

(mysql): ALTER TABLE mdl_tag_instance MODIFY COLUMN itemid BIGINT(10) unsigned NOT NULL after itemtype

Úspech

(mysql): ALTER TABLE mdl_tag_instance MODIFY COLUMN ordering BIGINT(10) unsigned NULL DEFAULT NULL after itemid

Úspech

(mysql): SHOW TABLES

(mysql): SHOW INDEX FROM mdl_tag_instance

(mysql): CREATE UNIQUE INDEX mdl_taginst_iteitetag_uix ON mdl_tag_instance (itemtype, itemid, tagid)

Úspech

(mysql): ALTER TABLE mdl_tag_correlation DROP INDEX mdl_tagcorr_tag_uix

Úspech

(mysql): ALTER TABLE mdl_tag_correlation MODIFY COLUMN tagid BIGINT(10) unsigned NOT NULL after id

Úspech

(mysql): SHOW TABLES

(mysql): SHOW INDEX FROM mdl_tag_correlation

(mysql): CREATE INDEX mdl_tagcorr_tag_ix ON mdl_tag_correlation (tagid)

Úspech

(mysql): SELECT name FROM mdl_config WHERE name = 'version' LIMIT 1

(mysql): UPDATE mdl_config SET value = '2007082800' WHERE name = 'version'

(mysql): SHOW TABLES

(mysql): CREATE TABLE mdl_user_private_key ( id BIGINT(10) unsigned NOT NULL auto_increment, script VARCHAR(128) NOT NULL DEFAULT '', value VARCHAR(128) NOT NULL DEFAULT '', userid BIGINT(10) unsigned NOT NULL, instance BIGINT(10) unsigned DEFAULT NULL, iprestriction VARCHAR(255) DEFAULT NULL, validuntil BIGINT(10) unsigned DEFAULT NULL, timecreated BIGINT(10) unsigned DEFAULT NULL, CONSTRAINT PRIMARY KEY (id) )

Úspech

(mysql): CREATE INDEX mdl_userprivkey_scrval_ix ON mdl_user_private_key (script, value)

Úspech

(mysql): CREATE INDEX mdl_userprivkey_use_ix ON mdl_user_private_key (userid)

Úspech

(mysql): SELECT name FROM mdl_config WHERE name = 'version' LIMIT 1

(mysql): UPDATE mdl_config SET value = '2007082801' WHERE name = 'version'

(mysql): ALTER TABLE mdl_mnet_host DROP INDEX mdl_mnethost_app_ix

Úspech

(mysql): ALTER TABLE mdl_mnet_host MODIFY COLUMN applicationid BIGINT(10) unsigned NOT NULL DEFAULT 1 after last_log_id

Úspech

(mysql): CREATE INDEX mdl_mnethost_app_ix ON mdl_mnet_host (applicationid)

Úspech

(mysql): SELECT name FROM mdl_config WHERE name = 'version' LIMIT 1

(mysql): UPDATE mdl_config SET value = '2007082803' WHERE name = 'version'

(mysql): UPDATE mdl_grade_categories SET path = CONCAT(path,'/') WHERE path NOT LIKE '/%/'

Úspech

(mysql): UPDATE mdl_grade_categories SET aggregation = 0, aggregateonlygraded = 1 WHERE aggregation = 1

Úspech

(mysql): UPDATE mdl_grade_categories SET aggregation = 2, aggregateonlygraded = 1 WHERE aggregation = 3

Úspech

(mysql): UPDATE mdl_grade_categories SET aggregation = 4, aggregateonlygraded = 1 WHERE aggregation = 5

Úspech

(mysql): UPDATE mdl_grade_categories SET aggregation = 6, aggregateonlygraded = 1 WHERE aggregation = 7

Úspech

(mysql): UPDATE mdl_grade_categories SET aggregation = 8, aggregateonlygraded = 1 WHERE aggregation = 9

Úspech

(mysql): UPDATE mdl_grade_categories SET aggregation = 10, aggregateonlygraded = 1 WHERE aggregation = 11

Úspech

(mysql): UPDATE mdl_grade_categories SET aggregation = 12, aggregateonlygraded = 1 WHERE aggregation = 13

Úspech

(mysql): SELECT name FROM mdl_config WHERE name = 'version' LIMIT 1

(mysql): UPDATE mdl_config SET value = '2007090503' WHERE name = 'version'

(mysql): SHOW TABLES

(mysql): SHOW INDEX FROM mdl_course_modules

(mysql): CREATE INDEX mdl_courmodu_idncou_ix ON mdl_course_modules (idnumber, course)

Úspech

(mysql): SHOW TABLES

(mysql): SHOW INDEX FROM mdl_grade_items

(mysql): CREATE INDEX mdl_graditem_idncou_ix ON mdl_grade_items (idnumber, courseid)

Úspech

(mysql): SELECT name FROM mdl_config WHERE name = 'version' LIMIT 1

(mysql): UPDATE mdl_config SET value = '2007090600' WHERE name = 'version'

(mysql): CREATE TABLE mdl_context_temp ( id BIGINT(10) unsigned NOT NULL, path VARCHAR(255) NOT NULL DEFAULT '', depth TINYINT(2) unsigned NOT NULL, CONSTRAINT PRIMARY KEY (id) )

Úspech

(mysql): SELECT c.id FROM mdl_course_categories c WHERE c.parent > 0 AND c.parent NOT IN (SELECT pc.id FROM mdl_course_categories pc)

(mysql): UPDATE mdl_course_categories SET depth = 1, path = CONCAT('/',id) WHERE parent = 0

Úspech

(mysql): SELECT * FROM mdl_course_categories WHERE depth = '0' LIMIT 1

(mysql): SELECT c.contextlevel, c.instanceid AS instanceid FROM mdl_context c LEFT OUTER JOIN mdl_course_categories t ON c.instanceid = t.id WHERE t.id IS NULL AND c.contextlevel = 40 UNION SELECT c.contextlevel, c.instanceid FROM mdl_context c LEFT OUTER JOIN mdl_course t ON c.instanceid = t.id WHERE t.id IS NULL AND c.contextlevel = 50 UNION SELECT c.contextlevel, c.instanceid FROM mdl_context c LEFT OUTER JOIN mdl_course_modules t ON c.instanceid = t.id WHERE t.id IS NULL AND c.contextlevel = 70 UNION SELECT c.contextlevel, c.instanceid FROM mdl_context c LEFT OUTER JOIN mdl_user t ON c.instanceid = t.id WHERE t.id IS NULL AND c.contextlevel = 30 UNION SELECT c.contextlevel, c.instanceid FROM mdl_context c LEFT OUTER JOIN mdl_block_instance t ON c.instanceid = t.id WHERE t.id IS NULL AND c.contextlevel = 80 UNION SELECT c.contextlevel, c.instanceid FROM mdl_context c LEFT OUTER JOIN mdl_groups t ON c.instanceid = t.id WHERE t.id IS NULL AND c.contextlevel = 60

Transactions not supported in 'mysql' driver. Use 'mysqlt' or 'mysqli' driver

(mysql): SELECT * FROM mdl_context WHERE contextlevel = '40' AND instanceid = '0' LIMIT 1

(mysql): DELETE FROM mdl_role_assignments WHERE contextid = '64'

(mysql): DELETE FROM mdl_role_capabilities WHERE contextid = '64'

(mysql): DELETE FROM mdl_context WHERE id = '64'

(mysql): SELECT * FROM mdl_context WHERE contextlevel = '70' AND instanceid = '10' LIMIT 1

(mysql): DELETE FROM mdl_role_assignments WHERE contextid = '22'

(mysql): DELETE FROM mdl_role_capabilities WHERE contextid = '22'

(mysql): DELETE FROM mdl_context WHERE id = '22'

(mysql): SELECT * FROM mdl_context WHERE contextlevel = '70' AND instanceid = '11' LIMIT 1

(mysql): DELETE FROM mdl_role_assignments WHERE contextid = '23'

(mysql): DELETE FROM mdl_role_capabilities WHERE contextid = '23'

(mysql): DELETE FROM mdl_context WHERE id = '23'

(mysql): SELECT * FROM mdl_context WHERE contextlevel = '70' AND instanceid = '60' LIMIT 1

(mysql): DELETE FROM mdl_role_assignments WHERE contextid = '185'

(mysql): DELETE FROM mdl_role_capabilities WHERE contextid = '185'

(mysql): DELETE FROM mdl_context WHERE id = '185'

(mysql): SELECT * FROM mdl_context WHERE contextlevel = '70' AND instanceid = '61' LIMIT 1

(mysql): DELETE FROM mdl_role_assignments WHERE contextid = '197'

(mysql): DELETE FROM mdl_role_capabilities WHERE contextid = '197'

(mysql): DELETE FROM mdl_context WHERE id = '197'

(mysql): SELECT * FROM mdl_context WHERE contextlevel = '70' AND instanceid = '63' LIMIT 1

(mysql): DELETE FROM mdl_role_assignments WHERE contextid = '182'

(mysql): DELETE FROM mdl_role_capabilities WHERE contextid = '182'

(mysql): DELETE FROM mdl_context WHERE id = '182'

(mysql): SELECT * FROM mdl_context WHERE contextlevel = '70' AND instanceid = '106' LIMIT 1

(mysql): DELETE FROM mdl_role_assignments WHERE contextid = '162'

(mysql): DELETE FROM mdl_role_capabilities WHERE contextid = '162'

(mysql): DELETE FROM mdl_context WHERE id = '162'

(mysql): SELECT * FROM mdl_context WHERE contextlevel = '70' AND instanceid = '120' LIMIT 1

(mysql): DELETE FROM mdl_role_assignments WHERE contextid = '224'

(mysql): DELETE FROM mdl_role_capabilities WHERE contextid = '224'

(mysql): DELETE FROM mdl_context WHERE id = '224'

(mysql): SELECT * FROM mdl_context WHERE contextlevel = '70' AND instanceid = '121' LIMIT 1

(mysql): DELETE FROM mdl_role_assignments WHERE contextid = '225'

(mysql): DELETE FROM mdl_role_capabilities WHERE contextid = '225'

(mysql): DELETE FROM mdl_context WHERE id = '225'

(mysql): SELECT * FROM mdl_context WHERE contextlevel = '70' AND instanceid = '123' LIMIT 1

(mysql): DELETE FROM mdl_role_assignments WHERE contextid = '227'

(mysql): DELETE FROM mdl_role_capabilities WHERE contextid = '227'

(mysql): DELETE FROM mdl_context WHERE id = '227'

(mysql): SELECT * FROM mdl_context WHERE contextlevel = '70' AND instanceid = '142' LIMIT 1

(mysql): DELETE FROM mdl_role_assignments WHERE contextid = '436'

(mysql): DELETE FROM mdl_role_capabilities WHERE contextid = '436'

(mysql): DELETE FROM mdl_context WHERE id = '436'

(mysql): SELECT * FROM mdl_context WHERE contextlevel = '70' AND instanceid = '150' LIMIT 1

(mysql): DELETE FROM mdl_role_assignments WHERE contextid = '604'

(mysql): DELETE FROM mdl_role_capabilities WHERE contextid = '604'

(mysql): DELETE FROM mdl_context WHERE id = '604'

(mysql): SELECT * FROM mdl_context WHERE contextlevel = '70' AND instanceid = '155' LIMIT 1

(mysql): DELETE FROM mdl_role_assignments WHERE contextid = '609'

(mysql): DELETE FROM mdl_role_capabilities WHERE contextid = '609'

(mysql): DELETE FROM mdl_context WHERE id = '609'

(mysql): SELECT * FROM mdl_context WHERE contextlevel = '70' AND instanceid = '166' LIMIT 1

(mysql): DELETE FROM mdl_role_assignments WHERE contextid = '679'

(mysql): DELETE FROM mdl_role_capabilities WHERE contextid = '679'

(mysql): DELETE FROM mdl_context WHERE id = '679'

(mysql): SELECT * FROM mdl_context WHERE contextlevel = '70' AND instanceid = '177' LIMIT 1

(mysql): DELETE FROM mdl_role_assignments WHERE contextid = '692'

(mysql): DELETE FROM mdl_role_capabilities WHERE contextid = '692'

(mysql): DELETE FROM mdl_context WHERE id = '692'

(mysql): SELECT * FROM mdl_context WHERE contextlevel = '70' AND instanceid = '210' LIMIT 1

(mysql): DELETE FROM mdl_role_assignments WHERE contextid = '799'

(mysql): DELETE FROM mdl_role_capabilities WHERE contextid = '799'

(mysql): DELETE FROM mdl_context WHERE id = '799'

(mysql): SELECT * FROM mdl_context WHERE contextlevel = '60' AND instanceid = '1' LIMIT 1

(mysql): DELETE FROM mdl_role_assignments WHERE contextid = '67'

(mysql): DELETE FROM mdl_role_capabilities WHERE contextid = '67'

(mysql): DELETE FROM mdl_context WHERE id = '67'

(mysql): SELECT * FROM mdl_context WHERE contextlevel = '60' AND instanceid = '2' LIMIT 1

(mysql): DELETE FROM mdl_role_assignments WHERE contextid = '68'

(mysql): DELETE FROM mdl_role_capabilities WHERE contextid = '68'

(mysql): DELETE FROM mdl_context WHERE id = '68'

(mysql): SELECT * FROM mdl_context WHERE contextlevel = '60' AND instanceid = '3' LIMIT 1

(mysql): DELETE FROM mdl_role_assignments WHERE contextid = '69'

(mysql): DELETE FROM mdl_role_capabilities WHERE contextid = '69'

(mysql): DELETE FROM mdl_context WHERE id = '69'

(mysql): SELECT * FROM mdl_context WHERE contextlevel = '60' AND instanceid = '4' LIMIT 1

(mysql): DELETE FROM mdl_role_assignments WHERE contextid = '70'

(mysql): DELETE FROM mdl_role_capabilities WHERE contextid = '70'

(mysql): DELETE FROM mdl_context WHERE id = '70'

(mysql): SELECT * FROM mdl_context WHERE contextlevel = '60' AND instanceid = '5' LIMIT 1

(mysql): DELETE FROM mdl_role_assignments WHERE contextid = '71'

(mysql): DELETE FROM mdl_role_capabilities WHERE contextid = '71'

(mysql): DELETE FROM mdl_context WHERE id = '71'

(mysql): SELECT * FROM mdl_context WHERE contextlevel = '60' AND instanceid = '6' LIMIT 1

(mysql): DELETE FROM mdl_role_assignments WHERE contextid = '72'

(mysql): DELETE FROM mdl_role_capabilities WHERE contextid = '72'

(mysql): DELETE FROM mdl_context WHERE id = '72'

(mysql): SELECT * FROM mdl_context WHERE contextlevel = '60' AND instanceid = '7' LIMIT 1

(mysql): DELETE FROM mdl_role_assignments WHERE contextid = '73'

(mysql): DELETE FROM mdl_role_capabilities WHERE contextid = '73'

(mysql): DELETE FROM mdl_context WHERE id = '73'

(mysql): SELECT * FROM mdl_context WHERE contextlevel = '60' AND instanceid = '8' LIMIT 1

(mysql): DELETE FROM mdl_role_assignments WHERE contextid = '74'

(mysql): DELETE FROM mdl_role_capabilities WHERE contextid = '74'

(mysql): DELETE FROM mdl_context WHERE id = '74'

(mysql): SELECT * FROM mdl_context WHERE contextlevel = '60' AND instanceid = '9' LIMIT 1

(mysql): DELETE FROM mdl_role_assignments WHERE contextid = '75'

(mysql): DELETE FROM mdl_role_capabilities WHERE contextid = '75'

(mysql): DELETE FROM mdl_context WHERE id = '75'

(mysql): SELECT * FROM mdl_context WHERE contextlevel = '60' AND instanceid = '10' LIMIT 1

(mysql): DELETE FROM mdl_role_assignments WHERE contextid = '76'

(mysql): DELETE FROM mdl_role_capabilities WHERE contextid = '76'

(mysql): DELETE FROM mdl_context WHERE id = '76'

(mysql): SELECT * FROM mdl_context WHERE contextlevel = '60' AND instanceid = '11' LIMIT 1

(mysql): DELETE FROM mdl_role_assignments WHERE contextid = '77'

(mysql): DELETE FROM mdl_role_capabilities WHERE contextid = '77'

(mysql): DELETE FROM mdl_context WHERE id = '77'

(mysql): SELECT * FROM mdl_context WHERE contextlevel = '60' AND instanceid = '12' LIMIT 1

(mysql): DELETE FROM mdl_role_assignments WHERE contextid = '78'

(mysql): DELETE FROM mdl_role_capabilities WHERE contextid = '78'

(mysql): DELETE FROM mdl_context WHERE id = '78'

(mysql): SELECT * FROM mdl_context WHERE contextlevel = '60' AND instanceid = '13' LIMIT 1

(mysql): DELETE FROM mdl_role_assignments WHERE contextid = '79'

(mysql): DELETE FROM mdl_role_capabilities WHERE contextid = '79'

(mysql): DELETE FROM mdl_context WHERE id = '79'

(mysql): SELECT * FROM mdl_context WHERE contextlevel = '60' AND instanceid = '14' LIMIT 1

(mysql): DELETE FROM mdl_role_assignments WHERE contextid = '80'

(mysql): DELETE FROM mdl_role_capabilities WHERE contextid = '80'

(mysql): DELETE FROM mdl_context WHERE id = '80'

(mysql): SELECT * FROM mdl_context WHERE contextlevel = '60' AND instanceid = '15' LIMIT 1

(mysql): DELETE FROM mdl_role_assignments WHERE contextid = '81'

(mysql): DELETE FROM mdl_role_capabilities WHERE contextid = '81'

(mysql): DELETE FROM mdl_context WHERE id = '81'

(mysql): SELECT * FROM mdl_context WHERE contextlevel = '60' AND instanceid = '16' LIMIT 1

(mysql): DELETE FROM mdl_role_assignments WHERE contextid = '82'

(mysql): DELETE FROM mdl_role_capabilities WHERE contextid = '82'

(mysql): DELETE FROM mdl_context WHERE id = '82'

(mysql): SELECT * FROM mdl_context WHERE contextlevel = '60' AND instanceid = '17' LIMIT 1

(mysql): DELETE FROM mdl_role_assignments WHERE contextid = '83'

(mysql): DELETE FROM mdl_role_capabilities WHERE contextid = '83'

(mysql): DELETE FROM mdl_context WHERE id = '83'

(mysql): SELECT * FROM mdl_context WHERE contextlevel = '60' AND instanceid = '18' LIMIT 1

(mysql): DELETE FROM mdl_role_assignments WHERE contextid = '84'

(mysql): DELETE FROM mdl_role_capabilities WHERE contextid = '84'

(mysql): DELETE FROM mdl_context WHERE id = '84'

(mysql): SELECT * FROM mdl_context WHERE contextlevel = '60' AND instanceid = '19' LIMIT 1

(mysql): DELETE FROM mdl_role_assignments WHERE contextid = '85'

(mysql): DELETE FROM mdl_role_capabilities WHERE contextid = '85'

(mysql): DELETE FROM mdl_context WHERE id = '85'

(mysql): SELECT * FROM mdl_context WHERE contextlevel = '60' AND instanceid = '26' LIMIT 1

(mysql): DELETE FROM mdl_role_assignments WHERE contextid = '213'

(mysql): DELETE FROM mdl_role_capabilities WHERE contextid = '213'

(mysql): DELETE FROM mdl_context WHERE id = '213'

(mysql): SELECT * FROM mdl_context WHERE contextlevel = '60' AND instanceid = '27' LIMIT 1

(mysql): DELETE FROM mdl_role_assignments WHERE contextid = '214'

(mysql): DELETE FROM mdl_role_capabilities WHERE contextid = '214'

(mysql): DELETE FROM mdl_context WHERE id = '214'

(mysql): SELECT * FROM mdl_context WHERE contextlevel = '60' AND instanceid = '28' LIMIT 1

(mysql): DELETE FROM mdl_role_assignments WHERE contextid = '215'

(mysql): DELETE FROM mdl_role_capabilities WHERE contextid = '215'

(mysql): DELETE FROM mdl_context WHERE id = '215'

(mysql): SELECT * FROM mdl_context WHERE contextlevel = '60' AND instanceid = '29' LIMIT 1

(mysql): DELETE FROM mdl_role_assignments WHERE contextid = '216'

(mysql): DELETE FROM mdl_role_capabilities WHERE contextid = '216'

(mysql): DELETE FROM mdl_context WHERE id = '216'

(mysql): SELECT * FROM mdl_context WHERE contextlevel = '60' AND instanceid = '30' LIMIT 1

(mysql): DELETE FROM mdl_role_assignments WHERE contextid = '217'

(mysql): DELETE FROM mdl_role_capabilities WHERE contextid = '217'

(mysql): DELETE FROM mdl_context WHERE id = '217'

(mysql): SELECT * FROM mdl_context WHERE contextlevel = '60' AND instanceid = '31' LIMIT 1

(mysql): DELETE FROM mdl_role_assignments WHERE contextid = '218'

(mysql): DELETE FROM mdl_role_capabilities WHERE contextid = '218'

(mysql): DELETE FROM mdl_context WHERE id = '218'

(mysql): SELECT * FROM mdl_context WHERE contextlevel = '60' AND instanceid = '32' LIMIT 1

(mysql): DELETE FROM mdl_role_assignments WHERE contextid = '219'

(mysql): DELETE FROM mdl_role_capabilities WHERE contextid = '219'

(mysql): DELETE FROM mdl_context WHERE id = '219'

(mysql): SELECT * FROM mdl_context WHERE contextlevel = '60' AND instanceid = '33' LIMIT 1

(mysql): DELETE FROM mdl_role_assignments WHERE contextid = '220'

(mysql): DELETE FROM mdl_role_capabilities WHERE contextid = '220'

(mysql): DELETE FROM mdl_context WHERE id = '220'

(mysql): SELECT * FROM mdl_context WHERE contextlevel = '60' AND instanceid = '34' LIMIT 1

(mysql): DELETE FROM mdl_role_assignments WHERE contextid = '174'

(mysql): DELETE FROM mdl_role_capabilities WHERE contextid = '174'

(mysql): DELETE FROM mdl_context WHERE id = '174'

(mysql): SELECT * FROM mdl_context WHERE contextlevel = '60' AND instanceid = '35' LIMIT 1

(mysql): DELETE FROM mdl_role_assignments WHERE contextid = '175'

(mysql): DELETE FROM mdl_role_capabilities WHERE contextid = '175'

(mysql): DELETE FROM mdl_context WHERE id = '175'

(mysql): SELECT * FROM mdl_context WHERE contextlevel = '60' AND instanceid = '36' LIMIT 1

(mysql): DELETE FROM mdl_role_assignments WHERE contextid = '176'

(mysql): DELETE FROM mdl_role_capabilities WHERE contextid = '176'

(mysql): DELETE FROM mdl_context WHERE id = '176'

(mysql): SELECT * FROM mdl_context WHERE contextlevel = '60' AND instanceid = '37' LIMIT 1

(mysql): DELETE FROM mdl_role_assignments WHERE contextid = '177'

(mysql): DELETE FROM mdl_role_capabilities WHERE contextid = '177'

(mysql): DELETE FROM mdl_context WHERE id = '177'

(mysql): SELECT * FROM mdl_context WHERE contextlevel = '60' AND instanceid = '38' LIMIT 1

(mysql): DELETE FROM mdl_role_assignments WHERE contextid = '178'

(mysql): DELETE FROM mdl_role_capabilities WHERE contextid = '178'

(mysql): DELETE FROM mdl_context WHERE id = '178'

(mysql): SELECT * FROM mdl_context WHERE contextlevel = '60' AND instanceid = '39' LIMIT 1

(mysql): DELETE FROM mdl_role_assignments WHERE contextid = '179'

(mysql): DELETE FROM mdl_role_capabilities WHERE contextid = '179'

(mysql): DELETE FROM mdl_context WHERE id = '179'

(mysql): SELECT * FROM mdl_context WHERE contextlevel = '60' AND instanceid = '40' LIMIT 1

(mysql): DELETE FROM mdl_role_assignments WHERE contextid = '180'

(mysql): DELETE FROM mdl_role_capabilities WHERE contextid = '180'

(mysql): DELETE FROM mdl_context WHERE id = '180'

(mysql): SELECT * FROM mdl_context WHERE contextlevel = '10' LIMIT 1

(mysql): INSERT INTO mdl_context (contextlevel, instanceid) SELECT 40, cc.id FROM mdl_course_categories cc WHERE NOT EXISTS (SELECT 'x' FROM mdl_context cx WHERE cc.id = cx.instanceid AND cx.contextlevel=40)

Úspech

(mysql): INSERT INTO mdl_context (contextlevel, instanceid) SELECT 50, c.id FROM mdl_course c WHERE NOT EXISTS (SELECT 'x' FROM mdl_context cx WHERE c.id = cx.instanceid AND cx.contextlevel=50)

Úspech

(mysql): SELECT * FROM mdl_context WHERE contextlevel = '10' LIMIT 1

(mysql): INSERT INTO mdl_context (contextlevel, instanceid) SELECT 30, u.id FROM mdl_user u WHERE u.deleted=0 AND NOT EXISTS (SELECT 'x' FROM mdl_context cx WHERE u.id = cx.instanceid AND cx.contextlevel=30)

Úspech

(mysql): SELECT * FROM mdl_context WHERE contextlevel = '10' LIMIT 1

(mysql): SELECT * FROM mdl_context WHERE contextlevel = '50' AND instanceid = '1' LIMIT 1

(mysql): UPDATE mdl_context SET path = '/1/2' WHERE id = '2'

(mysql): UPDATE mdl_context SET depth = '2' WHERE id = '2'

(mysql): SELECT * FROM mdl_context WHERE contextlevel = '50' AND instanceid = '1' LIMIT 1

(mysql): UPDATE mdl_context SET depth=2, path=CONCAT('/1/',id) WHERE contextlevel=40 AND EXISTS (SELECT 'x' FROM mdl_course_categories cc WHERE cc.id = mdl_context.instanceid AND cc.depth=1)

Úspech

(mysql): TRUNCATE TABLE mdl_context_temp

Úspech

(mysql): SELECT MAX(depth) FROM mdl_course_categories LIMIT 1

(mysql): INSERT INTO mdl_context_temp (id, path, depth) SELECT ctx.id, CONCAT(pctx.path,'/',ctx.id), pctx.depth+1 FROM mdl_context ctx JOIN mdl_course c ON ctx.instanceid=c.id JOIN mdl_context pctx ON c.category=pctx.instanceid WHERE ctx.contextlevel=50 AND c.id!=1 AND pctx.contextlevel=40 AND NOT EXISTS (SELECT 'x' FROM mdl_context_temp temp WHERE temp.id = ctx.id)

Úspech

(mysql): UPDATE mdl_context ct, mdl_context_temp temp SET ct.path = temp.path, ct.depth = temp.depth WHERE ct.id = temp.id

Úspech

(mysql): TRUNCATE TABLE mdl_context_temp

Úspech

(mysql): INSERT INTO mdl_context_temp (id, path, depth) SELECT ctx.id, CONCAT(pctx.path,'/',ctx.id), pctx.depth+1 FROM mdl_context ctx JOIN mdl_course_modules cm ON ctx.instanceid=cm.id JOIN mdl_context pctx ON cm.course=pctx.instanceid WHERE ctx.contextlevel=70 AND pctx.contextlevel=50 AND NOT EXISTS (SELECT 'x' FROM mdl_context_temp temp WHERE temp.id = ctx.id)

Úspech

(mysql): UPDATE mdl_context ct, mdl_context_temp temp SET ct.path = temp.path, ct.depth = temp.depth WHERE ct.id = temp.id

Úspech

(mysql): TRUNCATE TABLE mdl_context_temp

Úspech

(mysql): INSERT INTO mdl_context_temp (id, path, depth) SELECT ctx.id, CONCAT(pctx.path,'/',ctx.id), pctx.depth+1 FROM mdl_context ctx JOIN mdl_block_instance bi ON ctx.instanceid = bi.id JOIN mdl_context pctx ON bi.pageid=pctx.instanceid WHERE ctx.contextlevel=80 AND pctx.contextlevel=50 AND bi.pagetype='course-view' AND NOT EXISTS (SELECT 'x' FROM mdl_context_temp temp WHERE temp.id = ctx.id)

Úspech

(mysql): UPDATE mdl_context ct, mdl_context_temp temp SET ct.path = temp.path, ct.depth = temp.depth WHERE ct.id = temp.id

Úspech

(mysql): TRUNCATE TABLE mdl_context_temp

Úspech

(mysql): UPDATE mdl_context SET depth=2, path=CONCAT('/1/',id) WHERE contextlevel=80 AND EXISTS (SELECT 'x' FROM mdl_block_instance bi WHERE bi.id = mdl_context.instanceid AND bi.pagetype!='course-view')

Úspech

(mysql): UPDATE mdl_context SET depth=2, path=CONCAT('/1/',id) WHERE contextlevel=30 AND EXISTS (SELECT 'x' FROM mdl_user u WHERE u.id = mdl_context.instanceid)

Úspech

(mysql): SELECT ctx.path, rc.capability, rc.permission FROM mdl_context ctx JOIN mdl_role_capabilities rc ON rc.contextid=ctx.id WHERE rc.roleid = 6 AND ctx.contextlevel <= 50 ORDER BY ctx.depth, ctx.path

(mysql): SELECT name FROM mdl_config WHERE name = 'version' LIMIT 1

(mysql): UPDATE mdl_config SET value = '2007092001' WHERE name = 'version'

(mysql): SELECT name FROM mdl_config WHERE name = 'version' LIMIT 1

(mysql): UPDATE mdl_config SET value = '2007092002' WHERE name = 'version'

(mysql): ALTER TABLE mdl_grade_items MODIFY COLUMN display BIGINT(10) NOT NULL DEFAULT 0 after sortorder

Úspech

(mysql): ALTER TABLE mdl_grade_items MODIFY COLUMN decimals TINYINT(1) unsigned NULL DEFAULT NULL after display

Úspech

(mysql): ALTER TABLE mdl_grade_items MODIFY COLUMN decimals TINYINT(1) unsigned NULL DEFAULT NULL after display

Úspech

(mysql): UPDATE mdl_grade_items SET display=0 WHERE display=-1

Úspech

(mysql): SELECT name FROM mdl_config WHERE name = 'version' LIMIT 1

(mysql): UPDATE mdl_config SET value = '2007092803' WHERE name = 'version'

(mysql): ALTER TABLE mdl_grade_letter CHANGE grade_low lowerboundary NUMERIC(5,2) NOT NULL DEFAULT 0.00

Úspech

(mysql): ALTER TABLE mdl_grade_letter DROP COLUMN grade_high

Úspech

(mysql): ALTER TABLE mdl_grade_letter DROP INDEX mdl_gradlett_cou_ix

Úspech

(mysql): ALTER TABLE mdl_grade_letter CHANGE courseid contextid BIGINT(10) unsigned NOT NULL DEFAULT 0

Úspech

(mysql): UPDATE mdl_grade_letter SET contextid=COALESCE((SELECT c.id FROM mdl_context c WHERE c.instanceid=mdl_grade_letter.contextid AND c.contextlevel=50), 0)

Úspech

(mysql): DELETE FROM mdl_grade_letter WHERE contextid=0

Úspech

(mysql): ALTER TABLE mdl_grade_letter RENAME TO mdl_grade_letters

Úspech

(mysql): ALTER TABLE mdl_grade_letters MODIFY COLUMN lowerboundary NUMERIC(10,5) NOT NULL after contextid

Úspech

(mysql): ALTER TABLE mdl_grade_letters MODIFY COLUMN lowerboundary NUMERIC(10,5) NOT NULL after contextid

Úspech

(mysql): ALTER TABLE mdl_grade_letters MODIFY COLUMN letter VARCHAR(255) NOT NULL DEFAULT '' after lowerboundary

Úspech

(mysql): ALTER TABLE mdl_grade_letters MODIFY COLUMN letter VARCHAR(255) NOT NULL DEFAULT '' after lowerboundary

Úspech

(mysql): SHOW TABLES

(mysql): SHOW INDEX FROM mdl_grade_letters

(mysql): CREATE INDEX mdl_gradlett_conlow_ix ON mdl_grade_letters (contextid, lowerboundary)

Úspech

(mysql): SELECT name FROM mdl_config WHERE name = 'version' LIMIT 1

(mysql): UPDATE mdl_config SET value = '2007092806' WHERE name = 'version'

(mysql): SHOW TABLES

(mysql): CREATE TABLE mdl_cache_flags ( id BIGINT(10) unsigned NOT NULL auto_increment, flagtype VARCHAR(255) NOT NULL DEFAULT '', name VARCHAR(255) NOT NULL DEFAULT '', timemodified BIGINT(10) unsigned NOT NULL DEFAULT 0, value MEDIUMTEXT NOT NULL, expiry BIGINT(10) unsigned NOT NULL, CONSTRAINT PRIMARY KEY (id) )

Úspech

(mysql): CREATE INDEX mdl_cachflag_fla_ix ON mdl_cache_flags (flagtype)

Úspech

(mysql): CREATE INDEX mdl_cachflag_nam_ix ON mdl_cache_flags (name)

Úspech

(mysql): SELECT name FROM mdl_config WHERE name = 'version' LIMIT 1

(mysql): UPDATE mdl_config SET value = '2007100100' WHERE name = 'version'

(mysql): ALTER TABLE mdl_mnet_host ADD force_theme TINYINT(1) unsigned NOT NULL DEFAULT 0 after last_log_id

Úspech

(mysql): ALTER TABLE mdl_mnet_host ADD theme VARCHAR(100) DEFAULT NULL after force_theme

Úspech

(mysql): SELECT name FROM mdl_config WHERE name = 'version' LIMIT 1

(mysql): UPDATE mdl_config SET value = '2007100300' WHERE name = 'version'

(mysql): SELECT name FROM mdl_config WHERE name = 'version' LIMIT 1

(mysql): UPDATE mdl_config SET value = '2007100301' WHERE name = 'version'

(mysql): ALTER TABLE mdl_course MODIFY COLUMN summary TEXT NULL after idnumber

Úspech

(mysql): SELECT name FROM mdl_config WHERE name = 'version' LIMIT 1

(mysql): UPDATE mdl_config SET value = '2007100303' WHERE name = 'version'

(mysql): ALTER TABLE mdl_context MODIFY COLUMN path VARCHAR(255) NULL DEFAULT NULL after instanceid

Úspech

(mysql): SELECT name FROM mdl_config WHERE name = 'version' LIMIT 1

(mysql): UPDATE mdl_config SET value = '2007100500' WHERE name = 'version'

(mysql): SHOW TABLES

(mysql): CREATE TABLE mdl_grade_import_newitem ( id BIGINT(10) unsigned NOT NULL auto_increment, itemname VARCHAR(255) NOT NULL DEFAULT '', importcode BIGINT(10) unsigned NOT NULL, importer BIGINT(10) unsigned NOT NULL, CONSTRAINT PRIMARY KEY (id) )

Úspech

(mysql): CREATE INDEX mdl_gradimponewi_imp_ix ON mdl_grade_import_newitem (importer)

Úspech

(mysql): SHOW TABLES

(mysql): CREATE TABLE mdl_grade_import_values ( id BIGINT(10) unsigned NOT NULL auto_increment, itemid BIGINT(10) unsigned DEFAULT NULL, newgradeitem BIGINT(10) unsigned DEFAULT NULL, userid BIGINT(10) unsigned NOT NULL, finalgrade NUMERIC(10,5) DEFAULT NULL, feedback MEDIUMTEXT, importcode BIGINT(10) unsigned NOT NULL, importer BIGINT(10) unsigned DEFAULT NULL, CONSTRAINT PRIMARY KEY (id) )

Úspech

(mysql): CREATE INDEX mdl_gradimpovalu_ite_ix ON mdl_grade_import_values (itemid)

Úspech

(mysql): CREATE INDEX mdl_gradimpovalu_new_ix ON mdl_grade_import_values (newgradeitem)

Úspech

(mysql): CREATE INDEX mdl_gradimpovalu_imp_ix ON mdl_grade_import_values (importer)

Úspech

(mysql): SELECT name FROM mdl_config WHERE name = 'version' LIMIT 1

(mysql): UPDATE mdl_config SET value = '2007100700' WHERE name = 'version'

(mysql): DROP TABLE mdl_context_rel

Úspech

(mysql): SELECT name FROM mdl_config WHERE name = 'version' LIMIT 1

(mysql): UPDATE mdl_config SET value = '2007100800' WHERE name = 'version'

(mysql): TRUNCATE TABLE mdl_cache_text

Úspech

(mysql): SHOW TABLES

(mysql): SHOW INDEX FROM mdl_cache_text

(mysql): CREATE INDEX mdl_cachtext_tim_ix ON mdl_cache_text (timemodified)

Úspech

(mysql): SELECT name FROM mdl_config WHERE name = 'version' LIMIT 1

(mysql): UPDATE mdl_config SET value = '2007100802' WHERE name = 'version'

(mysql): SHOW TABLES

(mysql): CREATE TABLE mdl_grade_settings ( id BIGINT(10) unsigned NOT NULL auto_increment, courseid BIGINT(10) unsigned NOT NULL, name VARCHAR(255) NOT NULL DEFAULT '', value TEXT, CONSTRAINT PRIMARY KEY (id) )

Úspech

(mysql): CREATE UNIQUE INDEX mdl_gradsett_counam_uix ON mdl_grade_settings (courseid, name)

Úspech

(mysql): CREATE INDEX mdl_gradsett_cou_ix ON mdl_grade_settings (courseid)

Úspech

(mysql): SELECT name FROM mdl_config WHERE name = 'version' LIMIT 1

(mysql): UPDATE mdl_config SET value = '2007100803' WHERE name = 'version'

(mysql): DELETE FROM mdl_user_lastaccess WHERE NOT EXISTS (SELECT 'x' FROM mdl_course c WHERE c.id = mdl_user_lastaccess.courseid)

Úspech

(mysql): SELECT name FROM mdl_config WHERE name = 'version' LIMIT 1

(mysql): UPDATE mdl_config SET value = '2007100902' WHERE name = 'version'

(mysql): DROP TABLE mdl_grade_category

Úspech

(mysql): DROP TABLE mdl_grade_item

Úspech

(mysql): DROP TABLE mdl_grade_preferences

Úspech

(mysql): DROP TABLE mdl_grade_exceptions

Úspech

(mysql): SELECT name FROM mdl_config WHERE name = 'version' LIMIT 1

(mysql): UPDATE mdl_config SET value = '2007100903' WHERE name = 'version'

Could not create the README.txt file in /home/var/www/web/moodle/moodledata/users/README.txt.

(mysql): SELECT userid, itemid, COUNT(*) FROM mdl_grade_grades GROUP BY userid, itemid HAVING COUNT( * ) >1

(mysql): SHOW TABLES

(mysql): SHOW INDEX FROM mdl_grade_grades

(mysql): CREATE UNIQUE INDEX mdl_gradgrad_useite_uix ON mdl_grade_grades (userid, itemid)

Úspech

(mysql): SELECT name FROM mdl_config WHERE name = 'version' LIMIT 1

(mysql): UPDATE mdl_config SET value = '2007101502' WHERE name = 'version'

(mysql): ALTER TABLE mdl_timezone MODIFY COLUMN dst_time VARCHAR(6) NOT NULL DEFAULT '00:00' after dst_skipweeks

Úspech

(mysql): ALTER TABLE mdl_timezone MODIFY COLUMN std_time VARCHAR(6) NOT NULL DEFAULT '00:00' after std_skipweeks

Úspech

(mysql): SELECT name FROM mdl_config WHERE name = 'version' LIMIT 1

(mysql): UPDATE mdl_config SET value = '2007101505' WHERE name = 'version'

(mysql): DELETE FROM mdl_context WHERE contextlevel=20

Úspech

(mysql): SELECT name FROM mdl_config WHERE name = 'version' LIMIT 1

(mysql): UPDATE mdl_config SET value = '2007101506' WHERE name = 'version'

Started rebuilding of course cache...

...finished rebuilding of course cache.

(mysql): SELECT name FROM mdl_config WHERE name = 'version' LIMIT 1

(mysql): UPDATE mdl_config SET value = '2007101507' WHERE name = 'version'

Updating country list according to recent official ISO listing...

...update complete. Remember to update the language pack to get the most recent country names defitions and codes. This is specialy important for sites with users from Congo (now CD), Timor (now TL), Kosovo (now RS), Wales (now GB), Serbia (RS) and Montenegro (ME). Users based in Montenegro (ME) will need to manually update their profile.

(mysql): SELECT name FROM mdl_config WHERE name = 'version' LIMIT 1

(mysql): UPDATE mdl_config SET value = '2007101508' WHERE name = 'version'

(mysql): SELECT name FROM mdl_config WHERE name = 'version' LIMIT 1

(mysql): UPDATE mdl_config SET value = '2007101508.01' WHERE name = 'version'

(mysql): DELETE FROM mdl_stats_weekly WHERE timeend < 591635051

Úspech

(mysql): DELETE FROM mdl_stats_daily WHERE (stattype = 'enrolments' OR stattype = 'activity') AND roleid = 0

Úspech

(mysql): INSERT INTO mdl_stats_weekly (stattype, timeend, courseid, roleid, stat1, stat2) SELECT stattype, (timeend - 946080000), courseid, 0, SUM(stat1), SUM(stat2) FROM mdl_stats_daily WHERE (stattype = 'enrolments' OR stattype = 'activity') AND roleid <> 0 GROUP BY stattype, timeend, courseid

Úspech

(mysql): INSERT INTO mdl_stats_daily (stattype, timeend, courseid, roleid, stat1, stat2) SELECT stattype, (timeend + 946080000), courseid, roleid, stat1, stat2 FROM mdl_stats_weekly WHERE (stattype = 'enrolments' OR stattype = 'activity') AND roleid = 0 AND timeend < 630720000

Úspech

(mysql): DELETE FROM mdl_stats_weekly WHERE timeend < 591635051

Úspech

(mysql): DELETE FROM mdl_stats_monthly WHERE timeend < 591635051

Úspech

(mysql): DELETE FROM mdl_stats_weekly WHERE (stattype = 'enrolments' OR stattype = 'activity') AND roleid = 0

Úspech

(mysql): INSERT INTO mdl_stats_monthly (stattype, timeend, courseid, roleid, stat1, stat2) SELECT stattype, (timeend - 946080000), courseid, 0, SUM(stat1), SUM(stat2) FROM mdl_stats_weekly WHERE (stattype = 'enrolments' OR stattype = 'activity') AND roleid <> 0 GROUP BY stattype, timeend, courseid

Úspech

(mysql): INSERT INTO mdl_stats_weekly (stattype, timeend, courseid, roleid, stat1, stat2) SELECT stattype, (timeend + 946080000), courseid, roleid, stat1, stat2 FROM mdl_stats_monthly WHERE (stattype = 'enrolments' OR stattype = 'activity') AND roleid = 0 AND timeend < 630720000

Úspech

(mysql): DELETE FROM mdl_stats_monthly WHERE timeend < 591635051

Úspech

(mysql): DELETE FROM mdl_stats_daily WHERE timeend < 591635051

Úspech

(mysql): DELETE FROM mdl_stats_monthly WHERE (stattype = 'enrolments' OR stattype = 'activity') AND roleid = 0

Úspech

(mysql): INSERT INTO mdl_stats_daily (stattype, timeend, courseid, roleid, stat1, stat2) SELECT stattype, (timeend - 946080000), courseid, 0, SUM(stat1), SUM(stat2) FROM mdl_stats_monthly WHERE (stattype = 'enrolments' OR stattype = 'activity') AND roleid <> 0 GROUP BY stattype, timeend, courseid

Úspech

(mysql): INSERT INTO mdl_stats_monthly (stattype, timeend, courseid, roleid, stat1, stat2) SELECT stattype, (timeend + 946080000), courseid, roleid, stat1, stat2 FROM mdl_stats_daily WHERE (stattype = 'enrolments' OR stattype = 'activity') AND roleid = 0 AND timeend < 630720000

Úspech

(mysql): DELETE FROM mdl_stats_daily WHERE timeend < 591635051

Úspech

Upgrading log table indexes, this may take a long time, please be patient.

(mysql): ALTER TABLE mdl_log DROP INDEX mdl_log_timcoumodact_ix

Úspech

(mysql): ALTER TABLE mdl_log DROP INDEX mdl_log_use_ix

Úspech

(mysql): ALTER TABLE mdl_log DROP INDEX mdl_log_inf_ix

Úspech

(mysql): SHOW TABLES

(mysql): SHOW INDEX FROM mdl_log

(mysql): CREATE INDEX mdl_log_tim_ix ON mdl_log (time)

Úspech

(mysql): SHOW TABLES

(mysql): SHOW INDEX FROM mdl_log

(mysql): CREATE INDEX mdl_log_act_ix ON mdl_log (action)

Úspech

(mysql): SELECT name FROM mdl_config WHERE name = 'version' LIMIT 1

(mysql): UPDATE mdl_config SET value = '2007101508.02' WHERE name = 'version'

(mysql): ALTER TABLE mdl_log DROP INDEX mdl_log_couuse_ix

Úspech

(mysql): SHOW TABLES

(mysql): SHOW INDEX FROM mdl_log

(mysql): CREATE INDEX mdl_log_usecou_ix ON mdl_log (userid, course)

Úspech

(mysql): SELECT name FROM mdl_config WHERE name = 'version' LIMIT 1

(mysql): UPDATE mdl_config SET value = '2007101508.03' WHERE name = 'version'

(mysql): UPDATE mdl_tag_instance SET itemtype = 'post' WHERE itemtype = 'blog'

(mysql): SELECT name FROM mdl_config WHERE name = 'version' LIMIT 1

(mysql): UPDATE mdl_config SET value = '2007101508.04' WHERE name = 'version'

(mysql): SHOW TABLES

(mysql): SHOW INDEX FROM mdl_log

(mysql): CREATE INDEX mdl_log_cmi_ix ON mdl_log (cmid)

Úspech

(mysql): SELECT name FROM mdl_config WHERE name = 'version' LIMIT 1

(mysql): UPDATE mdl_config SET value = '2007101508.05' WHERE name = 'version'

(mysql): SHOW TABLES

(mysql): SHOW INDEX FROM mdl_event

(mysql): CREATE INDEX mdl_even_grocouvisuse_ix ON mdl_event (groupid, courseid, visible, userid)

Úspech

(mysql): SELECT name FROM mdl_config WHERE name = 'version' LIMIT 1

(mysql): UPDATE mdl_config SET value = '2007101508.06' WHERE name = 'version'

(mysql): SHOW TABLES

(mysql): CREATE TABLE mdl_webdav_locks ( id BIGINT(10) unsigned NOT NULL auto_increment, token VARCHAR(255) NOT NULL DEFAULT '', path VARCHAR(255) NOT NULL DEFAULT '', expiry BIGINT(10) unsigned NOT NULL DEFAULT 0, userid BIGINT(10) unsigned NOT NULL DEFAULT 0, recursive TINYINT(1) unsigned NOT NULL DEFAULT 0, exclusivelock TINYINT(1) unsigned NOT NULL DEFAULT 0, created BIGINT(10) unsigned NOT NULL DEFAULT 0, modified BIGINT(10) unsigned NOT NULL DEFAULT 0, owner VARCHAR(255) DEFAULT NULL, CONSTRAINT PRIMARY KEY (id) )

Úspech

(mysql): CREATE INDEX mdl_webdlock_pat_ix ON mdl_webdav_locks (path)

Úspech

(mysql): CREATE INDEX mdl_webdlock_exp_ix ON mdl_webdav_locks (expiry)

Úspech

(mysql): CREATE UNIQUE INDEX mdl_webdlock_tok_uix ON mdl_webdav_locks (token)

Úspech

(mysql): SELECT name FROM mdl_config WHERE name = 'version' LIMIT 1

(mysql): UPDATE mdl_config SET value = '2007101508.07' WHERE name = 'version'

(mysql): ALTER TABLE mdl_role_names ADD name VARCHAR(255) NOT NULL DEFAULT '' after text

Úspech

(mysql): UPDATE mdl_role_names SET name = text

Úspech

(mysql): ALTER TABLE mdl_role_names DROP COLUMN text

Úspech

(mysql): SELECT name FROM mdl_config WHERE name = 'version' LIMIT 1

(mysql): UPDATE mdl_config SET value = '2007101508.08' WHERE name = 'version'

(mysql): UPDATE mdl_grade_items SET needsupdate = '1' WHERE needsupdate = '0'

(mysql): UPDATE mdl_question SET parent = id WHERE qtype = 'random' AND parent <> id

Úspech

(mysql): SELECT name FROM mdl_config WHERE name = 'version' LIMIT 1

(mysql): UPDATE mdl_config SET value = '2007101510' WHERE name = 'version'

(mysql): SELECT * FROM mdl_role WHERE id = '7' LIMIT 1

(mysql): SELECT r.* FROM mdl_role r, mdl_role_capabilities rc WHERE rc.capability = 'moodle/legacy:guest' AND rc.roleid = r.id AND rc.permission = '1'

Increasing size of user idnumber field, this may take a while...

(mysql): UPDATE mdl_user SET idnumber = '' WHERE idnumber IS NULL

Úspech

(mysql): ALTER TABLE mdl_user DROP INDEX mdl_user_idn_ix

Úspech

(mysql): ALTER TABLE mdl_user MODIFY COLUMN idnumber VARCHAR(255) NOT NULL DEFAULT '' after password

Úspech

(mysql): SHOW TABLES

(mysql): SHOW INDEX FROM mdl_user

(mysql): CREATE INDEX mdl_user_idn_ix ON mdl_user (idnumber)

Úspech

(mysql): SELECT name FROM mdl_config WHERE name = 'version' LIMIT 1

(mysql): UPDATE mdl_config SET value = '2007101512' WHERE name = 'version'

(mysql): SELECT * FROM mdl_log_display WHERE action = 'unenrol' AND module = 'course' LIMIT 1

(mysql): SELECT * FROM mdl_log_display WHERE id = '-1'

(mysql): INSERT INTO mdl_log_display ( MODULE, ACTION, MTABLE, FIELD ) VALUES ( 'course', 'unenrol', 'course', 'fullname' )

(mysql): SELECT LAST_INSERT_ID()

(mysql): SELECT name FROM mdl_config WHERE name = 'version' LIMIT 1

(mysql): UPDATE mdl_config SET value = '2007101513' WHERE name = 'version'

(mysql): ALTER TABLE mdl_mnet_enrol_course MODIFY COLUMN sortorder BIGINT(10) unsigned NOT NULL DEFAULT 0

Úspech

(mysql): SELECT name FROM mdl_config WHERE name = 'version' LIMIT 1

(mysql): UPDATE mdl_config SET value = '2007101514' WHERE name = 'version'

(mysql): DELETE FROM mdl_role_names WHERE name = ''

(mysql): SELECT name FROM mdl_config WHERE name = 'version' LIMIT 1

(mysql): UPDATE mdl_config SET value = '2007101515' WHERE name = 'version'

(mysql): SELECT name FROM mdl_config WHERE name = 'version' LIMIT 1

(mysql): UPDATE mdl_config SET value = '2007101517' WHERE name = 'version'

Database was successfully upgraded