summaryrefslogtreecommitdiffstats
path: root/sql_scripts/update_2009_12_27_001.sql
diff options
context:
space:
mode:
Diffstat (limited to 'sql_scripts/update_2009_12_27_001.sql')
-rw-r--r--sql_scripts/update_2009_12_27_001.sql3
1 files changed, 3 insertions, 0 deletions
diff --git a/sql_scripts/update_2009_12_27_001.sql b/sql_scripts/update_2009_12_27_001.sql
new file mode 100644
index 00000000..e2da7d4d
--- /dev/null
+++ b/sql_scripts/update_2009_12_27_001.sql
@@ -0,0 +1,3 @@
+ALTER TABLE comment DROP INDEX content_type_id;
+
+ALTER TABLE comment ADD INDEX `content_type_id` (`content_type_id`,`object_id`,`user_id`); \ No newline at end of file