From 882b76bda8b701a8718960b8d639f060ae79e998 Mon Sep 17 00:00:00 2001
From: Greg Aker <greg.aker@ellislab.com>
Date: Wed, 20 Apr 2011 11:22:09 -0500
Subject: Fixed a bug (Reactor #231) where Sessions Library database table
 example SQL did not contain an index on last_activity. See <a
 href="installation/upgrade_203.html">Upgrade Notes</a>

Fixed a bug (Reactor #229) where the Sessions Library example SQL in the documentation contained incorrect SQL.
---
 user_guide/installation/upgrade_203.html | 10 ++++++++++
 1 file changed, 10 insertions(+)

(limited to 'user_guide/installation/upgrade_203.html')

diff --git a/user_guide/installation/upgrade_203.html b/user_guide/installation/upgrade_203.html
index 38cfb72c9..d7c0fae3a 100644
--- a/user_guide/installation/upgrade_203.html
+++ b/user_guide/installation/upgrade_203.html
@@ -94,6 +94,16 @@ Upgrading from 2.0.2 to 2.0.3
 
 <p>Which should provide for nominal performance gains if not autoloading packages.</p>
 
+<h2>Update Sessions Database Tables</h2>
+
+<p>If you are using database sessions with the CI Session Library, please update your <samp>ci_sessions</samp> database table as follows:</p>
+
+<code>	
+	CREATE INDEX last_activity_idx ON ci_sessions(last_activity);
+</code>	
+	
+	
+	
 
 </div>
 <!-- END CONTENT -->
-- 
cgit v1.2.3-24-g4f1b