diff options
| author | Mike Chen <chagel@gmail.com> | 2009-07-05 10:23:30 +0800 |
|---|---|---|
| committer | Mike Chen <chagel@gmail.com> | 2009-07-05 10:23:30 +0800 |
| commit | 4347c2947834fe7f2edf2b457b2d513454fc6a03 (patch) | |
| tree | 93e9d22d6fb8a6c882e3915a8511a3ac542a1e67 /sql_scripts/update_2009_12_27_001.sql | |
| download | askbot-4347c2947834fe7f2edf2b457b2d513454fc6a03.tar.gz askbot-4347c2947834fe7f2edf2b457b2d513454fc6a03.tar.bz2 askbot-4347c2947834fe7f2edf2b457b2d513454fc6a03.zip | |
initiliaze git rep
Diffstat (limited to 'sql_scripts/update_2009_12_27_001.sql')
| -rw-r--r-- | sql_scripts/update_2009_12_27_001.sql | 3 |
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 |