From 201980c921618256ee14c7bad253ade76d842487 Mon Sep 17 00:00:00 2001 From: Janusz Dobrowolski Date: Fri, 4 Dec 2009 23:31:13 +0000 Subject: [PATCH] Added key on comments table for better performance. --- sql/en_US-demo.sql | 3 ++- sql/en_US-new.sql | 3 ++- 2 files changed, 4 insertions(+), 2 deletions(-) diff --git a/sql/en_US-demo.sql b/sql/en_US-demo.sql index eca1048f..5fcaa366 100644 --- a/sql/en_US-demo.sql +++ b/sql/en_US-demo.sql @@ -345,7 +345,8 @@ CREATE TABLE `0_comments` ( `type` int(11) NOT NULL default '0', `id` int(11) NOT NULL default '0', `date_` date default '0000-00-00', - `memo_` tinytext + `memo_` tinytext, + KEY `type_and_id` (`type`, `id`) ) TYPE=InnoDB ; diff --git a/sql/en_US-new.sql b/sql/en_US-new.sql index d62c3203..1be4f088 100644 --- a/sql/en_US-new.sql +++ b/sql/en_US-new.sql @@ -328,7 +328,8 @@ CREATE TABLE `0_comments` ( `type` int(11) NOT NULL default '0', `id` int(11) NOT NULL default '0', `date_` date default '0000-00-00', - `memo_` tinytext + `memo_` tinytext, + KEY `type_and_id` (`type`, `id`) ) TYPE=InnoDB ; -- 2.30.2