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

source: OpenPNE/branches/ebihara/prj_pnebiz/setup/sql/update/update02-for2.3.1-add_index.sql @ 557

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

create prj_pnebiz

File size: 1.3 KB
Line 
1ALTER TABLE c_commu ADD INDEX(r_datetime);
2ALTER TABLE c_commu_member ADD INDEX c_commu_id_r_datetime(c_commu_id, r_datetime);
3ALTER TABLE c_diary ADD INDEX c_member_id_r_date(c_member_id, r_date);
4ALTER TABLE c_diary ADD INDEX c_member_id_r_datetime(c_member_id, r_datetime);
5ALTER TABLE c_diary_comment ADD INDEX c_diary_id_r_datetime(c_diary_id, r_datetime);
6ALTER TABLE c_friend ADD INDEX c_member_id_from_c_friend_id(c_member_id_from, c_friend_id);
7ALTER TABLE c_friend ADD INDEX c_member_id_from_r_datetime(c_member_id_from, r_datetime);
8ALTER TABLE c_friend ADD INDEX c_member_id_to_r_datetime_intro(c_member_id_to, r_datetime_intro);
9ALTER TABLE c_member ADD INDEX birth_year_c_member_id(birth_year, c_member_id);
10ALTER TABLE c_member_profile ADD INDEX c_profile_option_id_c_member_id(c_profile_option_id, c_member_id);
11ALTER TABLE c_member_profile ADD INDEX public_flag_c_profile_option_id(public_flag, c_profile_option_id);
12ALTER TABLE c_message ADD INDEX c_member_id_from_r_datetime(c_member_id_from, r_datetime);
13ALTER TABLE c_message ADD INDEX c_member_id_to_r_datetime(c_member_id_to, r_datetime);
14ALTER TABLE c_profile_option ADD INDEX c_profile_id_sort_order(c_profile_id, sort_order);
15ALTER TABLE c_rss_cache ADD INDEX c_member_id_r_datetime(c_member_id, r_datetime);
Note: See TracBrowser for help on using the repository browser.