diff options
Diffstat (limited to 'engine/schema')
| -rw-r--r-- | engine/schema/mysql.sql | 6 | ||||
| -rw-r--r-- | engine/schema/upgrades/2008102101.sql | 6 |
2 files changed, 6 insertions, 6 deletions
diff --git a/engine/schema/mysql.sql b/engine/schema/mysql.sql index f82a276d6..b0d86f629 100644 --- a/engine/schema/mysql.sql +++ b/engine/schema/mysql.sql @@ -275,11 +275,11 @@ 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,
+ `data` mediumblob,
PRIMARY KEY (`id`),
- KEY `session` (`session`),
- KEY `expires` (`expires`)
+ UNIQUE KEY `session` (`session`),
+ KEY `ts` (`ts`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- Datalists for things like db version
diff --git a/engine/schema/upgrades/2008102101.sql b/engine/schema/upgrades/2008102101.sql index 815fa05de..d0c3d4cac 100644 --- a/engine/schema/upgrades/2008102101.sql +++ b/engine/schema/upgrades/2008102101.sql @@ -3,9 +3,9 @@ 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, + `data` mediumblob, PRIMARY KEY (`id`), - KEY `session` (`session`), - KEY `expires` (`expires`) + UNIQUE KEY `session` (`session`), + KEY `ts` (`ts`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
\ No newline at end of file |