aboutsummaryrefslogtreecommitdiff
path: root/engine/schema
diff options
context:
space:
mode:
Diffstat (limited to 'engine/schema')
-rw-r--r--engine/schema/mysql.sql2
-rw-r--r--engine/schema/upgrades/2008120501.sql2
2 files changed, 2 insertions, 2 deletions
diff --git a/engine/schema/mysql.sql b/engine/schema/mysql.sql
index 391cad46e..9a6efd683 100644
--- a/engine/schema/mysql.sql
+++ b/engine/schema/mysql.sql
@@ -312,7 +312,7 @@ CREATE TABLE `prefix_private_settings` (
PRIMARY KEY ( `id` ) ,
UNIQUE KEY ( `entity_guid` , `name` ),
KEY `name` (`name`),
- KEY `value` (`value`)
+ KEY `value` (`value` (50))
) ENGINE = MYISAM DEFAULT CHARSET=utf8;
-- System log
diff --git a/engine/schema/upgrades/2008120501.sql b/engine/schema/upgrades/2008120501.sql
index bd08556ee..dd44b96b0 100644
--- a/engine/schema/upgrades/2008120501.sql
+++ b/engine/schema/upgrades/2008120501.sql
@@ -6,4 +6,4 @@ ALTER TABLE `prefix_private_settings` DROP KEY `name`;
ALTER TABLE `prefix_private_settings` ADD KEY `name` (`name`);
ALTER TABLE `prefix_private_settings` DROP KEY `value`;
-ALTER TABLE `prefix_private_settings` ADD KEY `value` (`value`); \ No newline at end of file
+ALTER TABLE `prefix_private_settings` ADD KEY `value` (`value` (50)); \ No newline at end of file