-------------------------------- SELECT a.attnum, a.attname AS field, t.typname AS type, a.attlen, a.atttypmod, a.attnotnull, a.atthasdef, d.adsrc FROM pg_catalog.pg_class c JOIN pg_catalog.pg_attribute a ON a.attrelid = c.oid JOIN pg_catalog.pg_type t ON t.oid = a.atttypid LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = c.oid AND d.adnum = a.attnum) WHERE relkind = 'r' AND c.relname = 'mdl_course_categories' AND c.reltype > 0 AND a.attnum > 0 ORDER BY a.attnum -------------------------------- -------------------------------- SELECT * FROM mdl_course_categories WHERE id = $1 [array ( 0 => 1, )] -------------------------------- -------------------------------- SELECT 'x' FROM mdl_course WHERE shortname = $1 LIMIT 1 OFFSET 0 [array ( 0 => 'ICT_4d22e2d7b7608', )] -------------------------------- -------------------------------- INSERT INTO mdl_course (fullname,shortname,category,sortorder,timecreated,timemodified,visible,visibleold) VALUES($1,$2,$3,$4,$5,$6,$7,$8) RETURNING id [array ( 'fullname' => 'Test course 1294131927', 'shortname' => 'ICT_4d22e2d7b7608', 'category' => 1, 'sortorder' => 0, 'timecreated' => 1294131927, 'timemodified' => 1294131927, 'visible' => '1', 'visibleold' => '1', )] -------------------------------- -------------------------------- SELECT * FROM mdl_context WHERE contextlevel = $1 AND instanceid = $2 [array ( 0 => 50, 1 => 44, )] -------------------------------- -------------------------------- SELECT ctx.path, ctx.depth FROM mdl_context ctx JOIN mdl_course c ON (c.category=ctx.instanceid AND ctx.contextlevel=40) WHERE c.id=$1 AND c.id !=1 [array ( 0 => 44, )] -------------------------------- -------------------------------- INSERT INTO mdl_context (contextlevel,instanceid,depth) VALUES($1,$2,$3) RETURNING id [array ( 'contextlevel' => 50, 'instanceid' => 44, 'depth' => 3, )] -------------------------------- -------------------------------- UPDATE mdl_context SET path = $2 WHERE id = $1 [array ( 0 => 270, 1 => '/1/3/270', )] -------------------------------- -------------------------------- SELECT * FROM mdl_context WHERE id = $1 [array ( 0 => 270, )] -------------------------------- -------------------------------- SELECT * FROM mdl_course WHERE id = $1 [array ( 0 => 44, )] -------------------------------- -------------------------------- SELECT * FROM mdl_block [array ( )] -------------------------------- -------------------------------- SELECT a.attnum, a.attname AS field, t.typname AS type, a.attlen, a.atttypmod, a.attnotnull, a.atthasdef, d.adsrc FROM pg_catalog.pg_class c JOIN pg_catalog.pg_attribute a ON a.attrelid = c.oid JOIN pg_catalog.pg_type t ON t.oid = a.atttypid LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = c.oid AND d.adnum = a.attnum) WHERE relkind = 'r' AND c.relname = 'mdl_block_instances' AND c.reltype > 0 AND a.attnum > 0 ORDER BY a.attnum -------------------------------- -------------------------------- INSERT INTO mdl_block_instances (blockname,parentcontextid,showinsubcontexts,pagetypepattern,subpagepattern,defaultregion,defaultweight,configdata) VALUES($1,$2,$3,$4,$5,$6,$7,$8) RETURNING id [array ( 'blockname' => 'search_forums', 'parentcontextid' => '270', 'showinsubcontexts' => 0, 'pagetypepattern' => 'course-view-*', 'subpagepattern' => NULL, 'defaultregion' => 'side-post', 'defaultweight' => 0, 'configdata' => '', )] -------------------------------- -------------------------------- SELECT * FROM mdl_context WHERE contextlevel = $1 AND instanceid = $2 [array ( 0 => 80, 1 => 185, )] -------------------------------- -------------------------------- SELECT ctx.path, ctx.depth FROM mdl_context ctx JOIN mdl_block_instances bi ON (bi.parentcontextid=ctx.id) WHERE bi.id = $1 [array ( 0 => 185, )] -------------------------------- -------------------------------- INSERT INTO mdl_context (contextlevel,instanceid,depth) VALUES($1,$2,$3) RETURNING id [array ( 'contextlevel' => 80, 'instanceid' => 185, 'depth' => 4, )] -------------------------------- -------------------------------- UPDATE mdl_context SET path = $2 WHERE id = $1 [array ( 0 => 271, 1 => '/1/3/270/271', )] -------------------------------- -------------------------------- SELECT * FROM mdl_context WHERE id = $1 [array ( 0 => 271, )] -------------------------------- -------------------------------- INSERT INTO mdl_block_instances (blockname,parentcontextid,showinsubcontexts,pagetypepattern,subpagepattern,defaultregion,defaultweight,configdata) VALUES($1,$2,$3,$4,$5,$6,$7,$8) RETURNING id [array ( 'blockname' => 'news_items', 'parentcontextid' => '270', 'showinsubcontexts' => 0, 'pagetypepattern' => 'course-view-*', 'subpagepattern' => NULL, 'defaultregion' => 'side-post', 'defaultweight' => 1, 'configdata' => '', )] -------------------------------- -------------------------------- SELECT * FROM mdl_context WHERE contextlevel = $1 AND instanceid = $2 [array ( 0 => 80, 1 => 186, )] -------------------------------- -------------------------------- SELECT ctx.path, ctx.depth FROM mdl_context ctx JOIN mdl_block_instances bi ON (bi.parentcontextid=ctx.id) WHERE bi.id = $1 [array ( 0 => 186, )] -------------------------------- -------------------------------- INSERT INTO mdl_context (contextlevel,instanceid,depth) VALUES($1,$2,$3) RETURNING id [array ( 'contextlevel' => 80, 'instanceid' => 186, 'depth' => 4, )] -------------------------------- -------------------------------- UPDATE mdl_context SET path = $2 WHERE id = $1 [array ( 0 => 272, 1 => '/1/3/270/272', )] -------------------------------- -------------------------------- SELECT * FROM mdl_context WHERE id = $1 [array ( 0 => 272, )] -------------------------------- -------------------------------- INSERT INTO mdl_block_instances (blockname,parentcontextid,showinsubcontexts,pagetypepattern,subpagepattern,defaultregion,defaultweight,configdata) VALUES($1,$2,$3,$4,$5,$6,$7,$8) RETURNING id [array ( 'blockname' => 'calendar_upcoming', 'parentcontextid' => '270', 'showinsubcontexts' => 0, 'pagetypepattern' => 'course-view-*', 'subpagepattern' => NULL, 'defaultregion' => 'side-post', 'defaultweight' => 2, 'configdata' => '', )] -------------------------------- -------------------------------- SELECT * FROM mdl_context WHERE contextlevel = $1 AND instanceid = $2 [array ( 0 => 80, 1 => 187, )] -------------------------------- -------------------------------- SELECT ctx.path, ctx.depth FROM mdl_context ctx JOIN mdl_block_instances bi ON (bi.parentcontextid=ctx.id) WHERE bi.id = $1 [array ( 0 => 187, )] -------------------------------- -------------------------------- INSERT INTO mdl_context (contextlevel,instanceid,depth) VALUES($1,$2,$3) RETURNING id [array ( 'contextlevel' => 80, 'instanceid' => 187, 'depth' => 4, )] -------------------------------- -------------------------------- UPDATE mdl_context SET path = $2 WHERE id = $1 [array ( 0 => 273, 1 => '/1/3/270/273', )] -------------------------------- -------------------------------- SELECT * FROM mdl_context WHERE id = $1 [array ( 0 => 273, )] -------------------------------- -------------------------------- INSERT INTO mdl_block_instances (blockname,parentcontextid,showinsubcontexts,pagetypepattern,subpagepattern,defaultregion,defaultweight,configdata) VALUES($1,$2,$3,$4,$5,$6,$7,$8) RETURNING id [array ( 'blockname' => 'recent_activity', 'parentcontextid' => '270', 'showinsubcontexts' => 0, 'pagetypepattern' => 'course-view-*', 'subpagepattern' => NULL, 'defaultregion' => 'side-post', 'defaultweight' => 3, 'configdata' => '', )] -------------------------------- -------------------------------- SELECT * FROM mdl_context WHERE contextlevel = $1 AND instanceid = $2 [array ( 0 => 80, 1 => 188, )] -------------------------------- -------------------------------- SELECT ctx.path, ctx.depth FROM mdl_context ctx JOIN mdl_block_instances bi ON (bi.parentcontextid=ctx.id) WHERE bi.id = $1 [array ( 0 => 188, )] -------------------------------- -------------------------------- INSERT INTO mdl_context (contextlevel,instanceid,depth) VALUES($1,$2,$3) RETURNING id [array ( 'contextlevel' => 80, 'instanceid' => 188, 'depth' => 4, )] -------------------------------- -------------------------------- UPDATE mdl_context SET path = $2 WHERE id = $1 [array ( 0 => 274, 1 => '/1/3/270/274', )] -------------------------------- -------------------------------- SELECT * FROM mdl_context WHERE id = $1 [array ( 0 => 274, )] -------------------------------- -------------------------------- SELECT a.attnum, a.attname AS field, t.typname AS type, a.attlen, a.atttypmod, a.attnotnull, a.atthasdef, d.adsrc FROM pg_catalog.pg_class c JOIN pg_catalog.pg_attribute a ON a.attrelid = c.oid JOIN pg_catalog.pg_type t ON t.oid = a.atttypid LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = c.oid AND d.adnum = a.attnum) WHERE relkind = 'r' AND c.relname = 'mdl_course_sections' AND c.reltype > 0 AND a.attnum > 0 ORDER BY a.attnum -------------------------------- -------------------------------- INSERT INTO mdl_course_sections (course,section,summaryformat) VALUES($1,$2,$3) RETURNING id [array ( 'course' => '44', 'section' => 0, 'summaryformat' => '1', )] -------------------------------- -------------------------------- SELECT * FROM mdl_course_categories WHERE sortorder = $1 [array ( 0 => 0, )] -------------------------------- -------------------------------- SELECT id, sortorder, parent, depth, path FROM mdl_course_categories ORDER BY sortorder, id [array ( )] -------------------------------- -------------------------------- SELECT * FROM mdl_course WHERE category = $1 ORDER BY id [array ( 0 => 0, )] -------------------------------- -------------------------------- SELECT cc.id, cc.coursecount, COUNT(c.id) AS newcount FROM mdl_course_categories cc LEFT JOIN mdl_course c ON c.category = cc.id GROUP BY cc.id, cc.coursecount HAVING cc.coursecount <> COUNT(c.id) [array ( )] -------------------------------- -------------------------------- UPDATE mdl_course_categories SET coursecount = $1 WHERE id=$2 [array ( 'coursecount' => '42', 0 => '1', )] -------------------------------- -------------------------------- SELECT DISTINCT cc.id, cc.sortorder FROM mdl_course_categories cc JOIN mdl_course c ON c.category = cc.id WHERE c.sortorder < cc.sortorder OR c.sortorder > cc.sortorder + 10000 [array ( )] -------------------------------- -------------------------------- UPDATE mdl_course SET sortorder = ((sortorder) % (10000)) + $1 WHERE category = $2 [array ( 0 => '40000', 1 => '1', )] -------------------------------- -------------------------------- SELECT DISTINCT c1.category AS id , cc.sortorder FROM mdl_course c1 JOIN mdl_course c2 ON c1.sortorder = c2.sortorder JOIN mdl_course_categories cc ON (c1.category = cc.id) WHERE c1.id <> c2.id [array ( )] -------------------------------- -------------------------------- SELECT cc.id, cc.sortorder, cc.coursecount, MAX(c.sortorder) AS maxsort, MIN(c.sortorder) AS minsort FROM mdl_course_categories cc JOIN mdl_course c ON c.category = cc.id GROUP BY cc.id, cc.sortorder, cc.coursecount HAVING (MAX(c.sortorder) <> cc.sortorder + cc.coursecount) OR (MIN(c.sortorder) <> cc.sortorder + 1) [array ( )] -------------------------------- -------------------------------- UPDATE mdl_course SET sortorder = sortorder + 1 WHERE category = $1 [array ( 0 => '1', )] -------------------------------- -------------------------------- SELECT a.attnum, a.attname AS field, t.typname AS type, a.attlen, a.atttypmod, a.attnotnull, a.atthasdef, d.adsrc FROM pg_catalog.pg_class c JOIN pg_catalog.pg_attribute a ON a.attrelid = c.oid JOIN pg_catalog.pg_type t ON t.oid = a.atttypid LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = c.oid AND d.adnum = a.attnum) WHERE relkind = 'r' AND c.relname = 'mdl_cache_flags' AND c.reltype > 0 AND a.attnum > 0 ORDER BY a.attnum -------------------------------- -------------------------------- SELECT * FROM mdl_cache_flags WHERE name = $1 AND flagtype = $2 LIMIT 1 OFFSET 0 [array ( 0 => '/1/3/270', 1 => 'accesslib/dirtycontexts', )] -------------------------------- -------------------------------- INSERT INTO mdl_cache_flags (flagtype,name,value,expiry,timemodified) VALUES($1,$2,$3,$4,$5) RETURNING id [array ( 'flagtype' => 'accesslib/dirtycontexts', 'name' => '/1/3/270', 'value' => 1, 'expiry' => 1294139127, 'timemodified' => 1294131927, )] -------------------------------- -------------------------------- SELECT a.attnum, a.attname AS field, t.typname AS type, a.attlen, a.atttypmod, a.attnotnull, a.atthasdef, d.adsrc FROM pg_catalog.pg_class c JOIN pg_catalog.pg_attribute a ON a.attrelid = c.oid JOIN pg_catalog.pg_type t ON t.oid = a.atttypid LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = c.oid AND d.adnum = a.attnum) WHERE relkind = 'r' AND c.relname = 'mdl_config_plugins' AND c.reltype > 0 AND a.attnum > 0 ORDER BY a.attnum -------------------------------- -------------------------------- SELECT name,value FROM mdl_config_plugins WHERE plugin = $1 [array ( 0 => 'enrol_manual', )] -------------------------------- -------------------------------- SELECT a.attnum, a.attname AS field, t.typname AS type, a.attlen, a.atttypmod, a.attnotnull, a.atthasdef, d.adsrc FROM pg_catalog.pg_class c JOIN pg_catalog.pg_attribute a ON a.attrelid = c.oid JOIN pg_catalog.pg_type t ON t.oid = a.atttypid LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = c.oid AND d.adnum = a.attnum) WHERE relkind = 'r' AND c.relname = 'mdl_enrol' AND c.reltype > 0 AND a.attnum > 0 ORDER BY a.attnum -------------------------------- -------------------------------- SELECT 'x' FROM mdl_enrol WHERE courseid = $1 AND enrol = $2 LIMIT 1 OFFSET 0 [array ( 0 => '44', 1 => 'manual', )] -------------------------------- -------------------------------- SELECT COALESCE(MAX(sortorder), -1) + 1 FROM mdl_enrol WHERE courseid = $1 [array ( 0 => '44', )] -------------------------------- -------------------------------- INSERT INTO mdl_enrol (enrol,status,courseid,enrolstartdate,enrolenddate,timemodified,timecreated,sortorder,enrolperiod,roleid) VALUES($1,$2,$3,$4,$5,$6,$7,$8,$9,$10) RETURNING id [array ( 'enrol' => 'manual', 'status' => '0', 'courseid' => '44', 'enrolstartdate' => 0, 'enrolenddate' => 0, 'timemodified' => 1294131927, 'timecreated' => 1294131927, 'sortorder' => '0', 'enrolperiod' => '0', 'roleid' => '5', )] -------------------------------- -------------------------------- SELECT * FROM mdl_capabilities ORDER BY id, name, captype, riskbitmask [array ( )] -------------------------------- -------------------------------- SELECT name,value FROM mdl_config_plugins WHERE plugin = $1 [array ( 0 => 'enrol_guest', )] -------------------------------- -------------------------------- SELECT COALESCE(MAX(sortorder), -1) + 1 FROM mdl_enrol WHERE courseid = $1 [array ( 0 => '44', )] -------------------------------- -------------------------------- INSERT INTO mdl_enrol (enrol,status,courseid,enrolstartdate,enrolenddate,timemodified,timecreated,sortorder) VALUES($1,$2,$3,$4,$5,$6,$7,$8) RETURNING id [array ( 'enrol' => 'guest', 'status' => '1', 'courseid' => '44', 'enrolstartdate' => 0, 'enrolenddate' => 0, 'timemodified' => 1294131927, 'timecreated' => 1294131927, 'sortorder' => '1', )] -------------------------------- -------------------------------- SELECT name,value FROM mdl_config_plugins WHERE plugin = $1 [array ( 0 => 'enrol_self', )] -------------------------------- -------------------------------- SELECT COALESCE(MAX(sortorder), -1) + 1 FROM mdl_enrol WHERE courseid = $1 [array ( 0 => '44', )] -------------------------------- -------------------------------- INSERT INTO mdl_enrol (enrol,status,courseid,enrolstartdate,enrolenddate,timemodified,timecreated,sortorder,customint1,customint2,customint3,customint4,enrolperiod,roleid) VALUES($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14) RETURNING id [array ( 'enrol' => 'self', 'status' => '1', 'courseid' => '44', 'enrolstartdate' => 0, 'enrolenddate' => 0, 'timemodified' => 1294131927, 'timecreated' => 1294131927, 'sortorder' => '2', 'customint1' => '0', 'customint2' => '0', 'customint3' => '0', 'customint4' => '1', 'enrolperiod' => '0', 'roleid' => '5', )] -------------------------------- -------------------------------- INSERT INTO mdl_log (time,userid,course,ip,module,cmid,action,url,info) VALUES($1,$2,$3,$4,$5,$6,$7,$8,$9) [array ( 'time' => 1294131927, 'userid' => '0', 'course' => '1', 'ip' => '0.0.0.0', 'module' => 'course', 'cmid' => 0, 'action' => 'new', 'url' => 'view.php?id=44', 'info' => 'Test course 1294131927 (ID 44)', )] -------------------------------- -------------------------------- SELECT a.attnum, a.attname AS field, t.typname AS type, a.attlen, a.atttypmod, a.attnotnull, a.atthasdef, d.adsrc FROM pg_catalog.pg_class c JOIN pg_catalog.pg_attribute a ON a.attrelid = c.oid JOIN pg_catalog.pg_type t ON t.oid = a.atttypid LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = c.oid AND d.adnum = a.attnum) WHERE relkind = 'r' AND c.relname = 'mdl_events_handlers' AND c.reltype > 0 AND a.attnum > 0 ORDER BY a.attnum -------------------------------- -------------------------------- SELECT * FROM mdl_events_handlers WHERE eventname = $1 [array ( 0 => 'course_created', )] -------------------------------- CREATED COURSE 44