From 60f1cfc6c6601832c7812bd537f719ad4d4f5a47 Mon Sep 17 00:00:00 2001
From: garvinhicking <garvinhicking>
Date: Fri, 9 Jun 2006 09:01:24 +0000
Subject: [PATCH] fix indices

---
 .../serendipity_event_statistics.php                   | 10 +++++++++-
 1 file changed, 9 insertions(+), 1 deletion(-)

diff --git a/plugins/serendipity_event_statistics/serendipity_event_statistics.php b/plugins/serendipity_event_statistics/serendipity_event_statistics.php
index b3e84b8..7e766da 100644
--- a/plugins/serendipity_event_statistics/serendipity_event_statistics.php
+++ b/plugins/serendipity_event_statistics/serendipity_event_statistics.php
@@ -20,7 +20,7 @@ class serendipity_event_statistics extends serendipity_event
         $propbag->add('description',   PLUGIN_EVENT_STATISTICS_DESC);
         $propbag->add('stackable',     false);
         $propbag->add('author',        'Garvin Hicking, Fredrik Sandberg');
-        $propbag->add('version',       '1.23');
+        $propbag->add('version',       '1.24');
         $propbag->add('requirements',  array(
             'serendipity' => '0.8',
             'smarty'      => '2.6.7',
@@ -643,6 +643,14 @@ class serendipity_event_statistics extends serendipity_event
         )";
         serendipity_db_schema_import($q);
         
+        //create indices
+        $q   = "CREATE INDEX visitorses ON {$serendipity['dbPrefix']}visitors(sessID);";
+        serendipity_db_schema_import($q);
+        $q   = "CREATE INDEX visitorday ON {$serendipity['dbPrefix']}visitors(day);";
+        serendipity_db_schema_import($q);
+        $q   = "CREATE INDEX visitortime ON {$serendipity['dbPrefix']}visitors(time);";
+        serendipity_db_schema_import($q);
+
     } //end of function createTables()
 
 
-- 
2.39.5