From 264d4e0b9ab2eef21bb8d04c8e60b9ac9d0d8fd4 Mon Sep 17 00:00:00 2001
From: moodler <moodler>
Date: Wed, 26 Mar 2003 02:17:46 +0000
Subject: [PATCH] Added two new indexes on log table to help speed it up.

See Greg's note in bug 113
---
 lib/db/mysql.php | 7 +++++++
 lib/db/mysql.sql | 4 +++-
 version.php      | 2 +-
 3 files changed, 11 insertions(+), 2 deletions(-)

diff --git a/lib/db/mysql.php b/lib/db/mysql.php
index a41aeeaf6b..bb95cae201 100644
--- a/lib/db/mysql.php
+++ b/lib/db/mysql.php
@@ -263,6 +263,13 @@ function main_upgrade($oldversion=0) {
                              UNIQUE KEY `id` (`id`)
                              ) TYPE=MyISAM COMMENT='One record per course creator';");
 	}
+	if ($oldversion < 2003032602) {
+        // Redoing it because of no prefix last time
+        execute_sql(" ALTER TABLE `{$CFG->prefix}log_display` CHANGE `module` `module` VARCHAR( 20 ) NOT NULL ");
+        // Add some indexes for speed
+        execute_sql(" ALTER TABLE `{$CFG->prefix}log` ADD INDEX(course) ");
+        execute_sql(" ALTER TABLE `{$CFG->prefix}log` ADD INDEX(userid) ");
+    }
 
     return true;
 }
diff --git a/lib/db/mysql.sql b/lib/db/mysql.sql
index 5e65510d18..e725943eb7 100644
--- a/lib/db/mysql.sql
+++ b/lib/db/mysql.sql
@@ -110,7 +110,9 @@ CREATE TABLE `prefix_log` (
   `action` varchar(15) NOT NULL default '',
   `url` varchar(100) NOT NULL default '',
   `info` varchar(255) NOT NULL default '',
-  PRIMARY KEY  (`id`)
+  PRIMARY KEY  (`id`),
+  KEY `course` (`course`),
+  KEY `userid` (`userid`)
 ) TYPE=MyISAM COMMENT='Every action is logged as far as possible.';
 # --------------------------------------------------------
 
diff --git a/version.php b/version.php
index 3acebac22f..9340caceaa 100644
--- a/version.php
+++ b/version.php
@@ -5,7 +5,7 @@
 // database to determine whether upgrades should
 // be performed (see lib/db/*.php)
 
-$version = 2003032601;   // The current version is a date (YYYYMMDDXX)
+$version = 2003032602;   // The current version is a date (YYYYMMDDXX)
 
 $release = "1.0.9 development";  // User-friendly version number
 
-- 
2.39.5