diff options
| -rw-r--r-- | engine/schema/mysql.sql | 2 | ||||
| -rw-r--r-- | engine/schema/upgrades/2008120501.sql | 2 |
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 |