Changeset 10236
- Timestamp:
- 01/20/09 11:19:01 (1 year ago)
- Files:
-
- OpenPNE3/trunk/config/schema.yml (modified) (9 diffs)
Legend:
- Unmodified
- Added
- Removed
- Modified
- Copied
- Moved
OpenPNE3/trunk/config/schema.yml
r10122 r10236 2 2 member: 3 3 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 } 6 6 created_at: ~ 7 7 updated_at: ~ … … 28 28 file: 29 29 id: ~ 30 name: { type: varchar(64), index: unique, required: true }30 name: { type: varchar(64), index: unique, required: true, defaultValue: "" } 31 31 original_filename: { type: longvarchar } 32 type: { type: varchar(64), required: true, index: true }32 type: { type: varchar(64), required: true, index: true, defaultValue: "" } 33 33 created_at: ~ 34 34 updated_at: ~ … … 40 40 profile: 41 41 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: "" } 47 47 value_regexp: { type: longvarchar } 48 48 value_min: { type: integer } 49 49 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 } 53 53 sort_order: { type: integer } 54 54 55 55 profile_i18n: 56 caption: { type: longvarchar, required: true }56 caption: { type: longvarchar, required: true, defaultValue: "" } 57 57 info: { type: longvarchar } 58 58 … … 68 68 _attributes: { treeMode: NestedSet } 69 69 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 } 73 73 member_id: { type: integer, required: true, foreignTable: member, foreignReference: id, onDelete: cascade } 74 74 profile_id: { type: integer, required: true, foreignTable: profile, foreignReference: id, onDelete: cascade } … … 78 78 community: 79 79 id: ~ 80 name: { type: varchar(64), index: unique, required: true }80 name: { type: varchar(64), index: unique, required: true, defaultValue: "" } 81 81 file_id: { type: integer, required: false, foreignTable: file, foreignReference: id, onDelete: setnull } 82 82 created_at: ~ … … 90 90 community_id: { type: integer, required: true, foreignTable: community, foreignReference: id, onDelete: cascade } 91 91 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: "" } 93 93 94 94 admin_user: 95 95 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: "" } 98 98 99 99 sns_config: 100 100 id: ~ 101 name: { type: varchar(64), index: unique, required: true }101 name: { type: varchar(64), index: unique, required: true, defaultValue: "" } 102 102 value: { type: longvarchar } 103 103 … … 105 105 id: ~ 106 106 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: "" } 108 108 value: { type: longvarchar } 109 109 … … 111 111 id: ~ 112 112 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: "" } 114 114 value: { type: longvarchar } 115 115 116 116 home_widget: 117 117 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: "" } 120 120 sort_order: { type: integer } 121 121 … … 123 123 id: ~ 124 124 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: "" } 126 126 value: { type: longvarchar } 127 127 128 128 navi: 129 129 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: "" } 132 132 sort_order: { type: integer } 133 133 134 134 navi_i18n: 135 caption: { type: longvarchar, required: true }135 caption: { type: longvarchar, required: true, defaultValue: "" } 136 136 137 137 blacklist: 138 138 id: ~ 139 uid: { type: varchar(32), index: unique, required: true }139 uid: { type: varchar(32), index: unique, required: true, defaultValue: "" } 140 140 memo: { type: longvarchar }