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

source: OpenPNE/branches/ebihara/prj_pnebiz/setup/sql/update/update14-for2.3.4-fix_c_diary_public_flag.sql @ 557

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

create prj_pnebiz

File size: 373 bytes
Line 
1ALTER TABLE `c_diary` CHANGE COLUMN `public_flag` `public_flag` enum('public','friend','private') NOT NULL default 'public';
2ALTER TABLE `c_member` CHANGE COLUMN `public_flag_diary` `public_flag_diary` enum('public','friend','private') NOT NULL default 'public';
3
4UPDATE c_diary INNER JOIN c_member USING (c_member_id) SET c_diary.public_flag = c_member.public_flag_diary ;
Note: See TracBrowser for help on using the repository browser.