setAttributes(XMLDB_TYPE_INTEGER, '2', XMLDB_UNSIGNED, XMLDB_NOTNULL, null, null, null, '0', 'content'); /// Launch add field format $result = $result && add_field($table, $field); } if ($result && $oldversion < 2007022600) { /// Define field asearchtemplate to be added to data $table = new XMLDBTable('data'); $field = new XMLDBField('asearchtemplate'); $field->setAttributes(XMLDB_TYPE_TEXT, 'small', null, null, null, null, null, null, 'jstemplate'); /// Launch add field asearchtemplate $result = $result && add_field($table, $field); } if ($result && $oldversion < 2007072200) { require_once($CFG->dirroot.'/mod/data/lib.php'); // too much debug output $db->debug = false; data_update_grades(); $db->debug = true; } if ($result && $oldversion < 2007081400) { /// Define field notification to be added to data $table = new XMLDBTable('data'); $field = new XMLDBField('notification'); $field->setAttributes(XMLDB_TYPE_INTEGER, '10', null, null, null, null, null, null, 'editany'); /// Launch add field notification $result = $result && add_field($table, $field); } if ($result && $oldversion < 2007081402) { /// Define index type-dataid (not unique) to be added to data_fields $table = new XMLDBTable('data_fields'); $index = new XMLDBIndex('type-dataid'); $index->setAttributes(XMLDB_INDEX_NOTUNIQUE, array('type', 'dataid')); /// Launch add index type-dataid if (!index_exists($table, $index)) { $result = $result && add_index($table, $index); } /// Define index course (not unique) to be added to data $table = new XMLDBTable('data'); $index = new XMLDBIndex('course'); $index->setAttributes(XMLDB_INDEX_NOTUNIQUE, array('course')); /// Launch add index course if (!index_exists($table, $index)) { $result = $result && add_index($table, $index); } } //===== 1.9.0 upgrade line ======// if ($result && $oldversion < 2007101512) { /// Launch add field asearchtemplate again if does not exists yet - reported on several sites $table = new XMLDBTable('data'); $field = new XMLDBField('asearchtemplate'); $field->setAttributes(XMLDB_TYPE_TEXT, 'small', null, null, null, null, null, null, 'jstemplate'); if (!field_exists($table, $field)) { $result = $result && add_field($table, $field); } } ///Display a warning message about "Required Entries" fix from MDL-16999 if ($result && $oldversion < 2007101514) { if (!get_config('data', 'requiredentriesfixflag')) { set_config('requiredentriesfixflag', true, 'data'); // remove old flag $databases = get_records_sql("SELECT d.*, c.fullname FROM {$CFG->prefix}data d, {$CFG->prefix}course c WHERE d.course = c.id AND (d.requiredentries > 0 OR d.requiredentriestoview > 0) ORDER BY c.fullname, d.name"); if (!empty($databases)) { $a = new object(); $a->text = ''; foreach($databases as $database) { $a->text .= "
".$database->fullname." - " .$database->name. " (course id: ".$database->course." - database id: ".$database->id.")
"; } notify(get_string('requiredentrieschanged', 'data', $a)); } } } return $result; } ?>