aboutsummaryrefslogtreecommitdiff
path: root/engine/schema
diff options
context:
space:
mode:
Diffstat (limited to 'engine/schema')
-rw-r--r--engine/schema/mysql.sql12
-rw-r--r--engine/schema/upgrades/2008102101.sql11
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