summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorEvan Prodromou <evan@controlyourself.ca>2009-06-23 09:16:41 -0700
committerEvan Prodromou <evan@controlyourself.ca>2009-06-23 09:16:41 -0700
commit4ca6aa1930f65120162a692c4cb86f5becb4ae7f (patch)
treef119e132ee1662af5a93ec777012b89ce8c900ab
parente261a97150684c943ebd6f994f610a2c2d0ba6b6 (diff)
a little sql script to drop full-text index and use innodb for profile and notice
-rw-r--r--db/innodb.sql2
1 files changed, 2 insertions, 0 deletions
diff --git a/db/innodb.sql b/db/innodb.sql
new file mode 100644
index 000000000..f3ab6cd69
--- /dev/null
+++ b/db/innodb.sql
@@ -0,0 +1,2 @@
+alter table profile drop index nickname, engine=InnoDB;
+alter table notice drop index content, engine=InnoDB;