Index: temp_moodle_dev/lamstwo/db/upgrade.php =================================================================== RCS file: /usr/local/cvsroot/temp_moodle_dev/lamstwo/db/Attic/upgrade.php,v diff -u -r1.1 -r1.2 --- temp_moodle_dev/lamstwo/db/upgrade.php 27 Aug 2008 07:03:23 -0000 1.1 +++ temp_moodle_dev/lamstwo/db/upgrade.php 29 Aug 2008 06:35:05 -0000 1.2 @@ -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');