Index: temp_moodle_dev/lamstwo/db/upgrade.php =================================================================== diff -u -r62b759b2231dbe0da31519bdb7d8f0855f53d2c0 -r2960171a0494cb002f9b35d3b7e58949e076b88e --- temp_moodle_dev/lamstwo/db/upgrade.php (.../upgrade.php) (revision 62b759b2231dbe0da31519bdb7d8f0855f53d2c0) +++ temp_moodle_dev/lamstwo/db/upgrade.php (.../upgrade.php) (revision 2960171a0494cb002f9b35d3b7e58949e076b88e) @@ -29,6 +29,9 @@ $field->setAttributes(XMLDB_TYPE_TEXT, 'small', null, true, null, null, null, null, null); $result = change_field_default($table, $field); + // save lamstwo data + $lamstwos = get_records('lamstwo'); + // modify lamstwo table $result = $result && rename_field($table, $field, 'intro'); $result = $result && drop_field($table, new XMLDBField('sequence_id')); @@ -83,6 +86,18 @@ $result = $result && create_table($table); + // insert lamstwo data into lamstwo_lesson table + foreach ($lamstwos as $lamstwoid => $lamstwo) { + $lesson->course = $lamstwo->course; + $lesson->lamstwo = $lamstwoid; + $lesson->name = $lamstwo->name; + $lesson->intro = $lamstwo->introduction; + $lesson->sequence_id = $lamstwo->sequence_id; + $lesson->lesson_id = $lamstwo->lesson_id; + $lesson->timemodified = $lamstwo->timemodified; + $lesson->id = insert_record('lamstwo_lesson', $lesson); + } + // add table lamstwo_grade $table = new XMLDBTable('lamstwo_grade');