Development

/plugins/sfSocialPlugin/trunk/config/schema.yml

You must first sign up to be able to contribute.

root/plugins/sfSocialPlugin/trunk/config/schema.yml

Revision 19825, 5.7 kB (checked in by garak, 4 years ago)

enhanced event module (with some tests); fixed some message module bugs

Line 
1 propel:
2   _attributes:      { package: plugins.sfSocialPlugin.lib.model }
3
4   sf_social_contact:
5     _attributes:    { phpName: sfSocialContact }
6     id: ~
7     user_from: { type: integer, required: true, foreignTable: sf_guard_user, foreignReference: id, onDelete: cascade, onUpdate: cascade }
8     user_to: { type: integer, required: true, foreignTable: sf_guard_user, foreignReference: id, onDelete: cascade, onUpdate: cascade }
9     created_at: ~
10     _uniques: { contact: [user_from, user_to] }
11
12   sf_social_contact_group:
13     _attributes:    { phpName: sfSocialContactGroup }
14     id: ~
15     contact_id: { type: integer, required: true, foreignTable: sf_social_contact, foreignReference: id, onDelete: cascade, onUpdate: cascade }
16     name: { type: varchar, size: 255 }
17
18   sf_social_contact_group_contact:
19     _attributes:    { phpName: sfSocialContactGroupContact }
20     contact_group_id: { type: integer, primaryKey: true, required: true, foreignTable: sf_social_contact_group, foreignReference: id, onDelete: cascade, onUpdate: cascade }
21     contact_id: { type: integer, primaryKey: true, required: true, foreignTable: sf_social_contact, foreignReference: id, onDelete: cascade, onUpdate: cascade }
22     created_at: ~
23
24   sf_social_contact_request:
25     _attributes:    { phpName: sfSocialContactRequest }
26     id: ~
27     user_from: { type: integer, required: true, foreignTable: sf_guard_user, foreignReference: id, onDelete: cascade, onUpdate: cascade }
28     user_to: { type: integer, required: true, foreignTable: sf_guard_user, foreignReference: id, onDelete: cascade, onUpdate: cascade }
29     message: { type: varchar, size: 255 }
30     accepted: { type: boolean, default: false }
31     created_at: ~
32     _uniques: { request: [user_from, user_to] }
33
34   sf_social_event:
35     _attributes:    { phpName: sfSocialEvent }
36     id: ~
37     user_admin: { type: integer, required: true, foreignTable: sf_guard_user, foreignReference: id, onDelete: cascade, onUpdate: cascade }
38     title: { type: varchar, size: 255, required: true }
39     description: { type: longvarchar, required: true }
40     start: { type: timestamp }
41     end: { type: timestamp }
42     location: { type: varchar, size: 255, required: true }
43     created_at: ~
44     updated_at: ~
45
46   sf_social_event_invite:
47     _attributes:    { phpName: sfSocialEventInvite }
48     id: ~
49     event_id: { type: integer, required: true, foreignTable: sf_social_event, foreignReference: id, onDelete: cascade, onUpdate: cascade }
50     user_id: { type: integer, required: true, foreignTable: sf_guard_user, foreignReference: id, onDelete: cascade, onUpdate: cascade }
51     user_from: { type: integer, required: true, foreignTable: sf_guard_user, foreignReference: id, onDelete: cascade, onUpdate: cascade }
52     replied: { type: boolean, default: false }
53     created_at: ~
54     _uniques: { invite: [event_id, user_id, user_from] }
55
56   sf_social_event_user:
57     _attributes:    { phpName: sfSocialEventUser }
58     event_id: { type: integer, primaryKey: true, required: true, foreignTable: sf_social_event, foreignReference: id, onDelete: cascade, onUpdate: cascade }
59     user_id: { type: integer, primaryKey: true, required: true, foreignTable: sf_guard_user, foreignReference: id, onDelete: cascade, onUpdate: cascade }
60     confirm: { type: integer }
61     created_at: ~
62
63   sf_social_group:
64     _attributes:    { phpName: sfSocialGroup }
65     id: ~
66     user_admin: { type: integer, required: true, foreignTable: sf_guard_user, foreignReference: id, onDelete: cascade, onUpdate: cascade }
67     title: { type: varchar, size: 255 }
68     description: { type: longvarchar }
69     created_at: ~
70     updated_at: ~
71
72   sf_social_group_invite:
73     _attributes:    { phpName: sfSocialGroupInvite }
74     id: ~
75     group_id: { type: integer, required: true, foreignTable: sf_social_group, foreignReference: id, onDelete: cascade, onUpdate: cascade }
76     user_id: { type: integer, required: true, foreignTable: sf_guard_user, foreignReference: id, onDelete: cascade, onUpdate: cascade }
77     user_from: { type: integer, required: true, foreignTable: sf_guard_user, foreignReference: id, onDelete: cascade, onUpdate: cascade }
78     replied: { type: boolean, default: false }
79     created_at: ~
80     _uniques: { invite: [group_id, user_id, user_from] }
81
82   sf_social_group_user:
83     _attributes:    { phpName: sfSocialGroupUser }
84     id: ~
85     group_id: { type: integer, required: true, foreignTable: sf_social_group, foreignReference: id, onDelete: cascade, onUpdate: cascade }
86     user_id: { type: integer, required: true, foreignTable: sf_guard_user, foreignReference: id, onDelete: cascade, onUpdate: cascade }
87     confirm: { type: integer }
88     created_at: ~
89
90   sf_social_message:
91     _attributes:    { phpName: sfSocialMessage }
92     id: ~
93     user_from: { type: integer, required: true, foreignTable: sf_guard_user, foreignReference: id, onDelete: cascade, onUpdate: cascade }
94     subject: { type: varchar, size: 255, required: true }
95     text: { type: longvarchar, required: true }
96     created_at: ~
97
98   sf_social_message_rcpt:
99     _attributes:    { phpName: sfSocialMessageRcpt }
100     id: ~
101     msg_id: { type: integer, required: true, foreignTable: sf_social_message, foreignReference: id, onDelete: cascade, onUpdate: cascade }
102     user_to: { type: integer, required: true, foreignTable: sf_guard_user, foreignReference: id, onDelete: cascade, onUpdate: cascade }
103     read: { type: boolean, default: false }
104
105   sf_social_notify:
106     _attributes:    { phpName: sfSocialNotify }
107     id: ~
108     user_id: { type: integer, required: true, foreignTable: sf_guard_user, foreignReference: id, onDelete: cascade, onUpdate: cascade }
109     model_name: { type: varchar, size: 255, required: true }
110     model_id: { type: integer, required: true }
111     read: { type: boolean, default: false }
112     created_at: ~
Note: See TracBrowser for help on using the browser.