From 808f9930b3a80d5c377c69e564bd5f03e0e4dfc0 Mon Sep 17 00:00:00 2001 From: toyomoyo Date: Mon, 24 Apr 2006 06:00:37 +0000 Subject: [PATCH] adding proper _idx postfix --- lib/db/mysql.php | 2 +- lib/db/mysql.sql | 2 +- 2 files changed, 2 insertions(+), 2 deletions(-) diff --git a/lib/db/mysql.php b/lib/db/mysql.php index d6a41944d2..563a0b8c41 100644 --- a/lib/db/mysql.php +++ b/lib/db/mysql.php @@ -1832,7 +1832,7 @@ function main_upgrade($oldversion=0) { if ($oldversion < 2006042401) { table_column('tags','type','type','varchar','20','','','not null'); modify_database('',"ALTER TABLE prefix_tags ADD INDEX tags_typeuserid_idx (type(20), userid)"); - modify_database('',"ALTER TABLE prefix_tags ADD INDEX tags_text(text(255))"); + modify_database('',"ALTER TABLE prefix_tags ADD INDEX tags_text_idx(text(255))"); } return $result; diff --git a/lib/db/mysql.sql b/lib/db/mysql.sql index 6656691793..7dc125a843 100644 --- a/lib/db/mysql.sql +++ b/lib/db/mysql.sql @@ -880,7 +880,7 @@ CREATE TABLE prefix_tags ( `userid` int(10) NOT NULL default '0', `text` varchar(20) NOT NULL default '', KEY `tags_typeuserid_idx` (`type`, `userid`), - KEY `tags_text` (`text`); + KEY `tags_text_idx` (`text`); PRIMARY KEY (`id`) ) TYPE=MyISAM COMMENT ='tags structure for moodle.'; -- 2.39.5