aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authormarcus <marcus@36083f99-b078-4883-b0ff-0f9b5a30f544>2008-10-22 11:19:34 +0000
committermarcus <marcus@36083f99-b078-4883-b0ff-0f9b5a30f544>2008-10-22 11:19:34 +0000
commitfb63a6ab72ac4deb823cecd14c7e95f21801a575 (patch)
tree198781f9c0f27b56729d2c192a2953299b7364d2
parent1b91801a6fe90f4c6f94751380c6fa53654bb208 (diff)
downloadelgg-fb63a6ab72ac4deb823cecd14c7e95f21801a575.tar.gz
elgg-fb63a6ab72ac4deb823cecd14c7e95f21801a575.tar.bz2
Removed unnecessary column
git-svn-id: https://code.elgg.org/elgg/trunk@2293 36083f99-b078-4883-b0ff-0f9b5a30f544
-rw-r--r--engine/schema/mysql.sql4
-rw-r--r--engine/schema/upgrades/2008102101.sql4
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