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/upgrades/2008102101.sql | 11 +++++++++++ 1 file changed, 11 insertions(+) create mode 100644 engine/schema/upgrades/2008102101.sql (limited to 'engine/schema/upgrades/2008102101.sql') diff --git a/engine/schema/upgrades/2008102101.sql b/engine/schema/upgrades/2008102101.sql new file mode 100644 index 000000000..815fa05de --- /dev/null +++ b/engine/schema/upgrades/2008102101.sql @@ -0,0 +1,11 @@ + +CREATE TABLE IF NOT EXISTS `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; \ No newline at end of file -- cgit v1.2.3