From 690aeeeae3b788009b6afb17bb59623e475ec06b Mon Sep 17 00:00:00 2001 From: marcus Date: Tue, 21 Oct 2008 17:52:20 +0000 Subject: Database session code. IMPORTANT NOTE: The trigger for this is commented out, so old session code is used. There are serious problems with using the new code since it causes a chicken and egg problem with the upgrade script. git-svn-id: https://code.elgg.org/elgg/trunk@2289 36083f99-b078-4883-b0ff-0f9b5a30f544 --- engine/schema/mysql.sql | 12 ++++++++++++ 1 file changed, 12 insertions(+) (limited to 'engine/schema/mysql.sql') diff --git a/engine/schema/mysql.sql b/engine/schema/mysql.sql index bb8646858..f82a276d6 100644 --- a/engine/schema/mysql.sql +++ b/engine/schema/mysql.sql @@ -270,6 +270,18 @@ CREATE TABLE `prefix_hmac_cache` ( KEY `ts` (`ts`) ) ENGINE=MEMORY; +-- PHP Session storage +CREATE TABLE `prefix_users_sessions` ( + `id` int(11) NOT NULL auto_increment, + `session` varchar(255) NOT NULL, + `ts` int(11) unsigned NOT NULL default '0', + `data` mediumtext, + + PRIMARY KEY (`id`), + KEY `session` (`session`), + KEY `expires` (`expires`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; + -- Datalists for things like db version CREATE TABLE `prefix_datalists` ( `name` varchar(32) NOT NULL, -- cgit v1.2.3