2 /* each table to be backed up. includes the sql entry and fields */
\r
5 $sql['faq_topics'] = 'SELECT topic_id, name FROM '.TABLE_PREFIX.'faq_topics WHERE course_id=? ORDER BY name';
\r
6 $sql['faq_entries'] = 'SELECT E.topic_id, E.revised_date, E.approved, E.question, E.answer FROM '.TABLE_PREFIX.'faq_entries E INNER JOIN '.TABLE_PREFIX.'faq_topics T USING (topic_id) WHERE T.course_id=? ORDER BY T.name, E.question';
\r
8 function faq_topics_convert($row, $course_id, $table_id_map, $version) {
\r
10 $new_row[0] = $row[0];
\r
11 $new_row[1] = $course_id;
\r
12 $new_row[2] = $row[1];
\r
17 function faq_entries_convert($row, $course_id, $table_id_map, $version) {
\r
20 $new_row[1] = $table_id_map['faq_topics'][$row[0]];
\r
21 $new_row[2] = $row[1];
\r
22 $new_row[3] = $row[2];
\r
23 $new_row[4] = $row[3];
\r
24 $new_row[5] = $row[4];
\r