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

Changeset 10236


Ignore:
Timestamp:
Jan 20, 2009, 11:19:01 AM (12 years ago)
Author:
ebihara
Message:

#3458:changed some definitions for required column in the core database schema to define their default values

File:
1 edited

Legend:

Unmodified
Added
Removed
  • OpenPNE3/trunk/config/schema.yml

    r10122 r10236  
    22  member:
    33    id: ~
    4     name: { type: varchar(64), required: true }
    5     is_active: { type: boolean, required: true }
     4    name: { type: varchar(64), required: true, defaultValue: "" }
     5    is_active: { type: boolean, required: true, defaultValue: 0 }
    66    created_at: ~
    77    updated_at: ~
     
    2828  file:
    2929    id: ~
    30     name: { type: varchar(64), index: unique, required: true }
     30    name: { type: varchar(64), index: unique, required: true, defaultValue: "" }
    3131    original_filename: { type: longvarchar }
    32     type: { type: varchar(64), required: true, index: true }
     32    type: { type: varchar(64), required: true, index: true, defaultValue: "" }
    3333    created_at: ~
    3434    updated_at: ~
     
    4040  profile:
    4141    id: ~
    42     name: { type: varchar(64), index: unique, required: true }
    43     is_required: { type: boolean, required: true }
    44     is_unique: { type: boolean, required: true }
    45     form_type: { type: varchar(32), required: true }
    46     value_type: { type: varchar(32), required: true }
     42    name: { type: varchar(64), index: unique, required: true, defaultValue: "" }
     43    is_required: { type: boolean, required: true, defaultValue: 0 }
     44    is_unique: { type: boolean, required: true, defaultValue: 0 }
     45    form_type: { type: varchar(32), required: true, defaultValue: "" }
     46    value_type: { type: varchar(32), required: true, defaultValue: "" }
    4747    value_regexp: { type: longvarchar }
    4848    value_min: { type: integer }
    4949    value_max: { type: integer }
    50     is_disp_regist: { type: boolean, required: true }
    51     is_disp_config: { type: boolean, required: true }
    52     is_disp_search: { type: boolean, required: true }
     50    is_disp_regist: { type: boolean, required: true, defaultValue: 0 }
     51    is_disp_config: { type: boolean, required: true, defaultValue: 0 }
     52    is_disp_search: { type: boolean, required: true, defaultValue: 0 }
    5353    sort_order: { type: integer }
    5454
    5555  profile_i18n:
    56     caption: { type: longvarchar, required: true }
     56    caption: { type: longvarchar, required: true, defaultValue: "" }
    5757    info: { type: longvarchar }
    5858
     
    6868    _attributes: { treeMode: NestedSet }
    6969    id: ~
    70     lft_key: { type: integer, nestedSetLeftKey: true ,index: true }
    71     rht_key: { type: integer, nestedSetRightKey: true ,index: true }
    72     tree_key : { type: integer, treeScopeKey: true ,index: true }
     70    lft_key: { type: integer, nestedSetLeftKey: true, index: true, defaultValue: 0 }
     71    rht_key: { type: integer, nestedSetRightKey: true, index: true, defaultValue: 0 }
     72    tree_key : { type: integer, treeScopeKey: true, index: true }
    7373    member_id: { type: integer, required: true, foreignTable: member, foreignReference: id, onDelete: cascade }
    7474    profile_id: { type: integer, required: true, foreignTable: profile, foreignReference: id, onDelete: cascade }
     
    7878  community:
    7979    id: ~
    80     name: { type: varchar(64), index: unique, required: true }
     80    name: { type: varchar(64), index: unique, required: true, defaultValue: "" }
    8181    file_id: { type: integer, required: false, foreignTable: file, foreignReference: id, onDelete: setnull }
    8282    created_at: ~
     
    9090    community_id: { type: integer, required: true, foreignTable: community, foreignReference: id, onDelete: cascade }
    9191    member_id: { type: integer, required: true, foreignTable: member, foreignReference: id, onDelete: cascade }
    92     position: { type: varchar(32), index: true }
     92    position: { type: varchar(32), index: true, defaultValue: "" }
    9393
    9494  admin_user:
    9595    id: ~
    96     username: { type: varchar(64), index: unique, required: true }
    97     password: { type: varchar(40), required: true }
     96    username: { type: varchar(64), index: unique, required: true, defaultValue: "" }
     97    password: { type: varchar(40), required: true, defaultValue: "" }
    9898
    9999  sns_config:
    100100    id: ~
    101     name: { type: varchar(64), index: unique, required: true }
     101    name: { type: varchar(64), index: unique, required: true, defaultValue: "" }
    102102    value: { type: longvarchar }
    103103
     
    105105    id: ~
    106106    member_id: { type: integer, required: true, foreignTable: member, foreignReference: id, onDelete: cascade }
    107     name: { type: varchar(64), required: true }
     107    name: { type: varchar(64), required: true, defaultValue: "" }
    108108    value: { type: longvarchar }
    109109
     
    111111    id: ~
    112112    community_id: { type: integer, required: true, foreignTable: community, foreignReference: id, onDelete: cascade }
    113     name: { type: varchar(64), required: true }
     113    name: { type: varchar(64), required: true, defaultValue: "" }
    114114    value: { type: longvarchar }
    115115
    116116  home_widget:
    117117    id: ~
    118     type: { type: varchar(64), required: true, index: true }
    119     name: { type: varchar(64), required: true }
     118    type: { type: varchar(64), required: true, index: true, defaultValue: "" }
     119    name: { type: varchar(64), required: true, defaultValue: "" }
    120120    sort_order: { type: integer }
    121121
     
    123123    id: ~
    124124    home_widget_id: { type: integer, foreignTable: home_widget, foreignReference: id, onDelete: cascade }
    125     name: { type: varchar(64), required: true }
     125    name: { type: varchar(64), required: true, defaultValue: "" }
    126126    value: { type: longvarchar }
    127127
    128128  navi:
    129129    id: ~
    130     type: { type: varchar(64), required: true, index: true }
    131     uri: { type: longvarchar, required: true }
     130    type: { type: varchar(64), required: true, index: true, defaultValue: "" }
     131    uri: { type: longvarchar, required: true, defaultValue: "" }
    132132    sort_order: { type: integer }
    133133
    134134  navi_i18n:
    135     caption: { type: longvarchar, required: true }
     135    caption: { type: longvarchar, required: true, defaultValue: "" }
    136136
    137137  blacklist:
    138138    id: ~
    139     uid: { type: varchar(32), index: unique, required: true }
     139    uid: { type: varchar(32), index: unique, required: true, defaultValue: "" }
    140140    memo: { type: longvarchar }
Note: See TracChangeset for help on using the changeset viewer.