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

Changeset 12153


Ignore:
Timestamp:
Jul 7, 2009, 12:56:18 PM (11 years ago)
Author:
urabe
Message:

#4064 is_admit カラムの値を修正するSQLを作成 (trunk)

Location:
OpenPNE/trunk/setup/sql
Files:
2 added
2 edited

Legend:

Unmodified
Added
Removed
  • OpenPNE/trunk/setup/sql/mysql40/upgrade/upgrade-2.12to2.14.sql

    r11869 r12153  
    6060
    6161UPDATE c_commu SET is_admit='public',is_open='public',is_comment='member' WHERE public_flag='public';
    62 UPDATE c_commu SET is_admit='admit',is_open='public',is_comment='member' WHERE public_flag='auth_public';
    63 UPDATE c_commu SET is_admit='admit',is_open='public',is_comment='member' WHERE public_flag='auth_sns';
    64 UPDATE c_commu SET is_admit='admit',is_open='member',is_comment='member' WHERE public_flag='auth_commu_member';
     62UPDATE c_commu SET is_admit='auth',is_open='public',is_comment='member' WHERE public_flag='auth_public';
     63UPDATE c_commu SET is_admit='auth',is_open='public',is_comment='member' WHERE public_flag='auth_sns';
     64UPDATE c_commu SET is_admit='auth',is_open='member',is_comment='member' WHERE public_flag='auth_commu_member';
    6565
    6666UPDATE c_commu SET is_topic='member' WHERE topic_authority='public';
  • OpenPNE/trunk/setup/sql/mysql41/upgrade/upgrade-2.12to2.14.sql

    r11869 r12153  
    6060
    6161UPDATE c_commu SET is_admit='public',is_open='public',is_comment='member' WHERE public_flag='public';
    62 UPDATE c_commu SET is_admit='admit',is_open='public',is_comment='member' WHERE public_flag='auth_public';
    63 UPDATE c_commu SET is_admit='admit',is_open='public',is_comment='member' WHERE public_flag='auth_sns';
    64 UPDATE c_commu SET is_admit='admit',is_open='member',is_comment='member' WHERE public_flag='auth_commu_member';
     62UPDATE c_commu SET is_admit='auth',is_open='public',is_comment='member' WHERE public_flag='auth_public';
     63UPDATE c_commu SET is_admit='auth',is_open='public',is_comment='member' WHERE public_flag='auth_sns';
     64UPDATE c_commu SET is_admit='auth',is_open='member',is_comment='member' WHERE public_flag='auth_commu_member';
    6565
    6666UPDATE c_commu SET is_topic='member' WHERE topic_authority='public';
Note: See TracChangeset for help on using the changeset viewer.