From 50671cf8d67c805692fec49eda33d21227a21ec2 Mon Sep 17 00:00:00 2001
From: Greg Aker <greg.aker@ellislab.com>
Date: Wed, 20 Apr 2011 11:36:45 -0500
Subject: Altered Session to use a longer match against the user_agent string.
 See upgrade notes if using database sessions.</li

---
 user_guide/changelog.html                | 5 +++++
 user_guide/installation/upgrade_203.html | 3 ++-
 user_guide/libraries/sessions.html       | 2 +-
 3 files changed, 8 insertions(+), 2 deletions(-)

(limited to 'user_guide')

diff --git a/user_guide/changelog.html b/user_guide/changelog.html
index 70db33d48..7ff71d07a 100644
--- a/user_guide/changelog.html
+++ b/user_guide/changelog.html
@@ -79,6 +79,11 @@ Change Log
 			<li>Added an optional third parameter to <samp>heading()</samp> which allows adding html attributes to the rendered heading tag.</li>
 		</ul>
 	</li>
+	<li>Libraries
+		<ul>
+			<li>Altered Session to use a longer match against the user_agent string. See upgrade notes if using database sessions.</li>
+		</ul>
+	</li>
 </ul>
 
 <h3>Bug fixes for 2.0.3</h3>
diff --git a/user_guide/installation/upgrade_203.html b/user_guide/installation/upgrade_203.html
index d7c0fae3a..7dbc907ea 100644
--- a/user_guide/installation/upgrade_203.html
+++ b/user_guide/installation/upgrade_203.html
@@ -98,8 +98,9 @@ Upgrading from 2.0.2 to 2.0.3
 
 <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>	
+<code>
 	CREATE INDEX last_activity_idx ON ci_sessions(last_activity);
+	ALTER TABLE ci_sessions MODIFY user_agent VARCHAR(120);
 </code>	
 	
 	
diff --git a/user_guide/libraries/sessions.html b/user_guide/libraries/sessions.html
index 6048f4809..a6f3c601c 100644
--- a/user_guide/libraries/sessions.html
+++ b/user_guide/libraries/sessions.html
@@ -222,7 +222,7 @@ prototype (for MySQL) required by the session class:</p>
 CREATE TABLE IF NOT EXISTS  `ci_sessions` (
 	session_id varchar(40) DEFAULT '0' NOT NULL,
 	ip_address varchar(16) DEFAULT '0' NOT NULL,
-	user_agent varchar(50) NOT NULL,
+	user_agent varchar(120) NOT NULL,
 	last_activity int(10) unsigned DEFAULT 0 NOT NULL,
 	user_data text NOT NULL,
 	PRIMARY KEY (session_id),
-- 
cgit v1.2.3-24-g4f1b