From fb63a6ab72ac4deb823cecd14c7e95f21801a575 Mon Sep 17 00:00:00 2001 From: marcus Date: Wed, 22 Oct 2008 11:19:34 +0000 Subject: Removed unnecessary column git-svn-id: https://code.elgg.org/elgg/trunk@2293 36083f99-b078-4883-b0ff-0f9b5a30f544 --- engine/schema/mysql.sql | 4 +--- engine/schema/upgrades/2008102101.sql | 4 +--- 2 files changed, 2 insertions(+), 6 deletions(-) diff --git a/engine/schema/mysql.sql b/engine/schema/mysql.sql index b0d86f629..3277de23a 100644 --- a/engine/schema/mysql.sql +++ b/engine/schema/mysql.sql @@ -272,13 +272,11 @@ CREATE TABLE `prefix_hmac_cache` ( -- 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` mediumblob, - PRIMARY KEY (`id`), - UNIQUE KEY `session` (`session`), + PRIMARY KEY `session` (`session`), KEY `ts` (`ts`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; diff --git a/engine/schema/upgrades/2008102101.sql b/engine/schema/upgrades/2008102101.sql index d0c3d4cac..544f28d2f 100644 --- a/engine/schema/upgrades/2008102101.sql +++ b/engine/schema/upgrades/2008102101.sql @@ -1,11 +1,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` mediumblob, - PRIMARY KEY (`id`), - UNIQUE KEY `session` (`session`), + PRIMARY KEY `session` (`session`), KEY `ts` (`ts`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; \ No newline at end of file -- cgit v1.2.3