Development

/plugins/sfGuardMessagesPlugin/config/schema.yml

You must first sign up to be able to contribute.

root/plugins/sfGuardMessagesPlugin/config/schema.yml

Revision 30467, 1.8 kB (checked in by tomi, 3 years ago)

format database schema

Line 
1 propel:
2   _attributes:      { package: plugins.sfGuardMessagesPlugin.lib.model }
3
4   sf_guard_messages_priority:
5     _attributes:    { phpName: sfGuardMessagesPriority }
6     id:             ~
7     name:           { type: varchar, size: 255, required: true, index: unique }
8     description:    { type: longvarchar }
9
10   sf_guard_messages_type:
11     _attributes:    { phpName: sfGuardMessagesType }
12     id:             ~
13     name:           { type: varchar, size: 255, required: true, index: unique }
14     description:    { type: longvarchar }
15
16   sf_guard_messages_message:
17     _attributes:    { phpName: sfGuardMessagesMessage }
18     id:             ~
19     type_id:        { type: integer, required: true, foreignTable: sf_guard_messages_type, foreignReference: id, onDelete: cascade }
20     priority_id:    { type: integer, required: true, foreignTable: sf_guard_messages_priority, foreignReference: id, onDelete: cascade }
21     message:        { type: longvarchar, required: true }
22     start_date:     { type: date, required: true }
23     end_date:       { type: date }
24
25   sf_guard_messages_message_group:
26     _attributes:    { phpName: sfGuardMessagesMessageGroup }
27     message_id:     { type: integer, required: true, primaryKey: true, foreignTable: sf_guard_messages_message, foreignReference: id, onDelete: cascade }
28     group_id:       { type: integer, required: true, primaryKey: true, foreignTable: sf_guard_group, foreignReference: id, onDelete: cascade }
29
30   sf_guard_messages_message_user:
31     _attributes:    { phpName: sfGuardMessagesMessageUser }
32     message_id:     { type: integer, required: true, primaryKey: true, foreignTable: sf_guard_messages_message, foreignReference: id, onDelete: cascade }
33     user_id:        { type: integer, required: true, primaryKey: true, foreignTable: sf_guard_user, foreignReference: id, onDelete: cascade }
Note: See TracBrowser for help on using the browser.