From d0117715f39576e5eb91e0547680514a5482d701 Mon Sep 17 00:00:00 2001
From: moodler <moodler>
Date: Wed, 27 Aug 2003 09:33:12 +0000
Subject: [PATCH] Added a log display for "course use reports"

---
 lib/db/mysql.php     | 3 +++
 lib/db/mysql.sql     | 1 +
 lib/db/postgres7.php | 3 +++
 lib/db/postgres7.sql | 1 +
 version.php          | 2 +-
 5 files changed, 9 insertions(+), 1 deletion(-)

diff --git a/lib/db/mysql.php b/lib/db/mysql.php
index 29244480b5..71a209820c 100644
--- a/lib/db/mysql.php
+++ b/lib/db/mysql.php
@@ -497,6 +497,9 @@ function main_upgrade($oldversion=0) {
     if ($oldversion < 2003082101) {
         execute_sql(" ALTER TABLE `{$CFG->prefix}course` ADD INDEX category (category) ");
     }
+    if ($oldversion < 2003082702) {
+        execute_sql(" INSERT INTO {$CFG->prefix}log_display (module, action, mtable, field) VALUES ('course', 'user report', 'user', 'CONCAT(firstname,\" \",lastname)') ");
+    }
 
     return $result;
 
diff --git a/lib/db/mysql.sql b/lib/db/mysql.sql
index 421793cd85..dd3e025eb7 100644
--- a/lib/db/mysql.sql
+++ b/lib/db/mysql.sql
@@ -295,6 +295,7 @@ CREATE TABLE `prefix_user_coursecreators` (
 ) TYPE=MyISAM COMMENT='One record per course creator';
 
 INSERT INTO prefix_log_display VALUES ('user', 'view', 'user', 'CONCAT(firstname," ",lastname)');
+INSERT INTO prefix_log_display VALUES ('course', 'user report', 'user', 'CONCAT(firstname," ",lastname)');
 INSERT INTO prefix_log_display VALUES ('course', 'view', 'course', 'fullname');
 INSERT INTO prefix_log_display VALUES ('course', 'update', 'course', 'fullname');
 INSERT INTO prefix_log_display VALUES ('course', 'enrol', 'course', 'fullname');
diff --git a/lib/db/postgres7.php b/lib/db/postgres7.php
index e38fdcb01c..f24b3729f0 100644
--- a/lib/db/postgres7.php
+++ b/lib/db/postgres7.php
@@ -241,6 +241,9 @@ function main_upgrade($oldversion=0) {
     if ($oldversion < 2003082101) {
         execute_sql(" CREATE INDEX {$CFG->prefix}course_category_idx ON {$CFG->prefix}course (category) ");
     }
+    if ($oldversion < 2003082702) {
+        execute_sql(" INSERT INTO {$CFG->prefix}log_display (module, action, mtable, field) VALUES ('course', 'user report', 'user', 'CONCAT(firstname,\" \",lastname)') ");
+    }
 
     return $result;
 }
diff --git a/lib/db/postgres7.sql b/lib/db/postgres7.sql
index a91698bb71..4921be041e 100644
--- a/lib/db/postgres7.sql
+++ b/lib/db/postgres7.sql
@@ -187,6 +187,7 @@ CREATE TABLE prefix_user_coursecreators (
 );
 
 INSERT INTO prefix_log_display VALUES ('user', 'view', 'user', 'CONCAT(firstname," ",lastname)');
+INSERT INTO prefix_log_display VALUES ('course', 'user report', 'user', 'CONCAT(firstname," ",lastname)');
 INSERT INTO prefix_log_display VALUES ('course', 'view', 'course', 'fullname');
 INSERT INTO prefix_log_display VALUES ('course', 'update', 'course', 'fullname');
 INSERT INTO prefix_log_display VALUES ('course', 'enrol', 'course', 'fullname');
diff --git a/version.php b/version.php
index 4da7142f61..bb48fbe055 100644
--- a/version.php
+++ b/version.php
@@ -5,7 +5,7 @@
 // database to determine whether upgrades should
 // be performed (see lib/db/*.php)
 
-$version = 2003082700;   // The current version is a date (YYYYMMDDXX)
+$version = 2003082702;   // The current version is a date (YYYYMMDDXX)
 
 $release = "1.1 Beta +++";   // User-friendly version number
 
-- 
2.39.5