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

source: OpenPNE3/trunk/config/schema.yml @ 10288

Last change on this file since 10288 was 10288, checked in by ebihara, 11 years ago

#3458:fixed setting defaultValues to longvarchar column

File size: 5.4 KB
Line 
1propel:
2  member:
3    id: ~
4    name: { type: varchar(64), required: true, defaultValue: "" }
5    is_active: { type: boolean, required: true, defaultValue: 0 }
6    created_at: ~
7    updated_at: ~
8    _behaviors:
9      activate: {}
10
11  member_relationship:
12    id: ~
13    member_id_to: { type: integer, required: true, foreignTable: member, foreignReference: id, onDelete: cascade }
14    member_id_from: { type: integer, required: true, foreignTable: member, foreignReference: id, onDelete: cascade }
15    is_friend: { type: boolean }
16    is_friend_pre: { type: boolean }
17    is_access_block: { type: boolean }
18    _uniques:
19      member_id_to_from: [ member_id_to, member_id_from ]
20      member_id_from_to: [ member_id_from, member_id_to ]
21
22  member_image:
23    id: ~
24    member_id: { type: integer, required: true, foreignTable: member, foreignReference: id, onDelete: cascade }
25    file_id: { type: integer, required: true, foreignTable: file, foreignReference: id, onDelete: cascade }
26    is_primary: { type: boolean }
27
28  file:
29    id: ~
30    name: { type: varchar(64), index: unique, required: true, defaultValue: "" }
31    original_filename: { type: longvarchar }
32    type: { type: varchar(64), required: true, index: true, defaultValue: "" }
33    created_at: ~
34    updated_at: ~
35
36  file_bin:
37    file_id: { type: integer, required: true, primaryKey: true, foreignTable: file, foreignReference: id, onDelete: cascade }
38    bin: { type: blob }
39
40  profile:
41    id: ~
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    value_regexp: { type: longvarchar }
48    value_min: { type: integer }
49    value_max: { type: integer }
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    sort_order: { type: integer }
54
55  profile_i18n:
56    caption: { type: longvarchar, required: true }
57    info: { type: longvarchar }
58
59  profile_option:
60    id: ~
61    profile_id: { type: integer, required: true, foreignTable: profile, foreignReference: id, onDelete: cascade }
62    sort_order: { type: integer }
63
64  profile_option_i18n:
65    value: { type: longvarchar }
66
67  member_profile:
68    _attributes: { treeMode: NestedSet }
69    id: ~
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    member_id: { type: integer, required: true, foreignTable: member, foreignReference: id, onDelete: cascade }
74    profile_id: { type: integer, required: true, foreignTable: profile, foreignReference: id, onDelete: cascade }
75    profile_option_id: { type: integer, required: false, foreignTable: profile_option, foreignReference: id, onDelete: cascade }
76    value: { type: longvarchar }
77
78  community:
79    id: ~
80    name: { type: varchar(64), index: unique, required: true, defaultValue: "" }
81    file_id: { type: integer, required: false, foreignTable: file, foreignReference: id, onDelete: setnull }
82    created_at: ~
83    updated_at: ~
84    _behaviors:
85      check_privilege_belong: { class_name: CommunityMember }
86      check_privilege_owner: { class_name: CommunityMember }
87
88  community_member:
89    id: ~
90    community_id: { type: integer, required: true, foreignTable: community, foreignReference: id, onDelete: cascade }
91    member_id: { type: integer, required: true, foreignTable: member, foreignReference: id, onDelete: cascade }
92    position: { type: varchar(32), index: true, defaultValue: "" }
93
94  admin_user:
95    id: ~
96    username: { type: varchar(64), index: unique, required: true, defaultValue: "" }
97    password: { type: varchar(40), required: true, defaultValue: "" }
98
99  sns_config:
100    id: ~
101    name: { type: varchar(64), index: unique, required: true, defaultValue: "" }
102    value: { type: longvarchar }
103
104  member_config:
105    id: ~
106    member_id: { type: integer, required: true, foreignTable: member, foreignReference: id, onDelete: cascade }
107    name: { type: varchar(64), required: true, defaultValue: "" }
108    value: { type: longvarchar }
109
110  community_config:
111    id: ~
112    community_id: { type: integer, required: true, foreignTable: community, foreignReference: id, onDelete: cascade }
113    name: { type: varchar(64), required: true, defaultValue: "" }
114    value: { type: longvarchar }
115
116  gadget:
117    id: ~
118    type: { type: varchar(64), required: true, index: true, defaultValue: "" }
119    name: { type: varchar(64), required: true, defaultValue: "" }
120    sort_order: { type: integer }
121
122  gadget_config:
123    id: ~
124    gadget_id: { type: integer, foreignTable: gadget, foreignReference: id, onDelete: cascade }
125    name: { type: varchar(64), required: true, defaultValue: "" }
126    value: { type: longvarchar }
127
128  navigation:
129    id: ~
130    type: { type: varchar(64), required: true, index: true, defaultValue: "" }
131    uri: { type: longvarchar, required: true }
132    sort_order: { type: integer }
133
134  navigation_i18n:
135    caption: { type: longvarchar, required: true }
136
137  blacklist:
138    id: ~
139    uid: { type: varchar(32), index: unique, required: true, defaultValue: "" }
140    memo: { type: longvarchar }
Note: See TracBrowser for help on using the repository browser.