root/trunk/config/sfGuardPlugin_schema.custom.yml

Revision 2, 1.2 kB (checked in by nperriault, 2 years ago)

First commit of the extracted code from production, I hope no passwd has been forgotten :-)

Line 
1 propel:
2
3   sf_guard_user:
4     _attributes:        { phpName: sfGuardUser }
5     display_name:       { type: varchar, size: 255, index: true }
6     email:              { type: varchar, size: 100, required: true }
7     avatar_path:        { type: varchar, size: 40 }
8     trac_username:      { type: varchar, size: 50 }
9     homepage:           { type: varchar, size: 255 }
10     feed_url:           varchar(255)
11     summary:            longvarchar
12     php_at:             timestamp
13     symfony_at:         timestamp
14     birthdate:          timestamp
15     address:            longvarchar
16     zip:                varchar(10)
17     city:               { type: varchar, size: 50, required: true, index: true }
18     state:              varchar(50)
19     country:            { type: varchar, size: 2, required: true, index: true }
20     phone:              varchar(20)
21     karma:              { type: integer, default: 0, required: true, index: true }
22     is_validated:       { type: boolean, default: 0 }
23     allow_contact:      { type: boolean, default: 0 }
24     allow_localization: { type: boolean, default: 0 }
25     is_for_hire:        { type: boolean, default: 0 }
26     created_at:
27     updated_at:
28     _uniques:
29       users:            [username]
30       emails:           [email]
Note: See TracBrowser for help on using the browser.