ここの情報は古いです。ご理解頂いた上でお取り扱いください。

source: OpenPNE/trunk/setup/sql/mysql41/update/update04-for2.11.5-add_index.sql @ 6460

Last change on this file since 6460 was 5455, checked in by ebihara, 14 years ago

#1967:インデックス追加用SQLを追加

File size: 446 bytes
Line 
1/*!40101 SET NAMES utf8 */;
2
3CREATE INDEX c_member_id_c_member_id_block on c_access_block(c_member_id,c_member_id_block);
4CREATE INDEX c_member_id_block ON c_access_block(c_member_id_block);
5
6CREATE INDEX c_review_id_r_datetime ON c_review_comment(c_review_id,r_datetime);
7CREATE INDEX c_member_id_r_datetime ON c_review_comment(c_member_id,r_datetime);
8
9CREATE INDEX c_commu_id_c_memer_id_to ON c_commu_admin_invite(c_commu_id,c_member_id_to);
10
Note: See TracBrowser for help on using the repository browser.