diff options
| author | marcus <marcus@36083f99-b078-4883-b0ff-0f9b5a30f544> | 2008-10-21 17:52:20 +0000 |
|---|---|---|
| committer | marcus <marcus@36083f99-b078-4883-b0ff-0f9b5a30f544> | 2008-10-21 17:52:20 +0000 |
| commit | 690aeeeae3b788009b6afb17bb59623e475ec06b (patch) | |
| tree | 8061e6b5301281fe1241f3fba44942bb0753882c /engine/schema | |
| parent | fa161bd35911c6220fd45ff05357da689118b1b3 (diff) | |
| download | elgg-690aeeeae3b788009b6afb17bb59623e475ec06b.tar.gz elgg-690aeeeae3b788009b6afb17bb59623e475ec06b.tar.bz2 | |
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
Diffstat (limited to 'engine/schema')
| -rw-r--r-- | engine/schema/mysql.sql | 12 | ||||
| -rw-r--r-- | engine/schema/upgrades/2008102101.sql | 11 |
2 files changed, 23 insertions, 0 deletions
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,
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 |