root/branches/trivoallan/config/schema.yml

Revision 2, 6.9 kB (checked in by nperriault, 10 months ago)

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

Line 
1 propel:
2
3   activation:
4     _attributes:      { phpName: Activation }
5     id:
6     user_id:          { type: integer, foreignTable: sf_guard_user, foreignReference: id, required: true }
7     hash:             { type: varchar, size: 32, required: true, index: true }
8     _indexes:
9       user_hash:      [user_id, hash]
10
11   application:
12     _attributes:      { phpName: Application }
13     id:
14     submitter_id:     { type: integer, foreignTable: sf_guard_user, foreignReference: id, required: true, onDelete: setnull }
15     name:             { type: varchar, size: 255, required: true }
16     slug:             { type: varchar, size: 255, required: true, index: true }
17     description:      longvarchar
18     homepage:         { type: varchar, size: 255 }
19     feed_url:         { type: varchar, size: 255 }
20     screenshot_path:  varchar(150)
21     is_opensource:    { type: boolean, default: 0, index: true }
22     licence:          varchar(30)
23     country:          { type: varchar, size: 2, index: true }
24     is_featured:      { type: boolean, default: 0, index: true }
25     started_at:       timestamp
26     released_at:      timestamp
27     created_at:       { type: timestamp, index: true }
28     updated_at:
29     _indexes:
30       filter_index:   [country, created_at, is_featured]
31
32   application_company:
33     _attributes:      { phpName: ApplicationCompany }
34     id:
35     company_id:       { type: integer, foreignTable: company, foreignReference: id, required: true, onDelete: cascade }
36     application_id:   { type: integer, foreignTable: application, foreignReference: id, required: true, onDelete: cascade }
37     submitter_id:     { type: integer, foreignTable: sf_guard_user, foreignReference: id, required: true, onDelete: cascade }
38     role:             varchar(255)
39     description:      longvarchar
40     started_at:       { type: timestamp, index: true }
41     ended_at:         { type: timestamp, index: true }
42     created_at:       { type: timestamp, index: true }
43     updated_at:       { type: timestamp, index: true }
44
45   application_developer:
46     _attributes:      { phpName: ApplicationDeveloper }
47     id:
48     developer_id:     { type: integer, foreignTable: sf_guard_user, foreignReference: id, required: true, onDelete: cascade }
49     application_id:   { type: integer, foreignTable: application, foreignReference: id, required: true, onDelete: cascade }
50     role:             varchar(255)
51     description:      longvarchar
52     started_at:       { type: timestamp, index: true }
53     ended_at:         { type: timestamp, index: true }
54     created_at:       { type: timestamp, index: true }
55     updated_at:       { type: timestamp, index: true }
56
57   blog_posts:
58     _attributes:      { phpName: BlogPost }
59     id:
60     title:            { type: varchar, size: 255, required: true }
61     slug:             { type: varchar, size: 255, required: true }
62     body:             { type: longvarchar }
63     author_id:        { type: integer, foreignTable: sf_guard_user, foreignReference: id, required: true, onDelete: setnull }
64     is_published:     { type: boolean, required: true, index: true, default: 0 }
65     created_at:       { type: timestamp, index: true }
66     updated_at:       { type: timestamp, index: true }
67     _indexes:
68       post_index:     [slug, created_at, is_published]
69
70   company:
71     _attributes:      { phpName: Company }
72     name:             { type: varchar, size: 255, required: true }
73     summary:          longvarchar
74     slug:             { type: varchar, size: 255, required: true, index: true }
75     logo_path:        { type: varchar, size: 40 }
76     homepage:         { type: varchar, size: 255 }
77     address:          longvarchar
78     zip:              varchar(10)
79     city:             varchar(50)
80     state:            varchar(50)
81     country:          { type: varchar, size: 2, required: true, index: true }
82     phone:            varchar(20)
83     email:            varchar(100)
84     submitter_id:     { type: integer, foreignTable: sf_guard_user, foreignReference: id, required: true, onDelete: setnull }
85     allow_contact:    { type: boolean, default: 0 }
86     is_active:        { type: boolean, default: 1 }
87     created_at:       { type: timestamp, index: true }
88     updated_at:
89     _indexes:
90       filter_index:   [country, created_at]
91  
92   company_people:
93     _attributes:      { phpName: CompanyPerson }
94     id:
95     user_id:          { type: integer, foreignTable: sf_guard_user, foreignReference: id, required: true, onDelete: cascade }
96     company_id:       { type: integer, foreignTable: company, foreignReference: id, required: true, onDelete: cascade }
97     role:             varchar(255)
98     description:      longvarchar
99     started_at:       timestamp
100     ended_at:         timestamp
101     created_at:       { type: timestamp, index: true }
102     updated_at:       { type: timestamp, index: true }
103  
104   event:
105     _attributes:      { phpName: Event }
106     id:
107     type:           { type: varchar, size: 255, required: true, index: true }
108     source_model:   { type: varchar, size: 25, required: true }
109     source_name:    { type: varchar, size: 255, required: true }
110     source_slug:    { type: varchar, size: 255, required: true }
111     target_model:   { type: varchar, size: 255 }
112     target_name:    { type: varchar, size: 255 }
113     target_slug:    { type: varchar, size: 255 }
114     occured_at:     { type: timestamp, required: true, index: true }
115     is_admin:       { type: boolean, default: 0, index: true }
116     _indexes:
117       filter_index: [source_model, source_slug, occured_at, is_admin]
118  
119   jobs:
120     _attributes:      { phpName: Job }
121     id:
122     title:            { type: varchar, size: 255, required: true, index: true }
123     slug:             { type: varchar, size: 255, required: true, index: true }
124     summary:          { type: longvarchar, required: true }
125     company_id:       { type: integer, foreignTable: company, foreignReference: id, onDelete: cascade }
126     contact_id:       { type: integer, foreignTable: sf_guard_user, foreignReference: id, required: true, onDelete: cascade }
127     city:             varchar(50)
128     state:            varchar(50)
129     country:          { type: varchar, size: 2, index: true }
130     teleworking:      { type: boolean, default: 0, index: true }
131     expires_at:       { type: timestamp, index: true }
132     created_at:       { type: timestamp, index: true }
133     updated_at:       { type: timestamp }
134     budget:           { type: varchar, size: 255 }
135     _indexes:
136       filter_index:   [created_at, country]
137
138   recommendation:
139     _attributes:      { phpName: Recommendation }
140     id:
141     recommender_id:   { type: integer, foreignTable: sf_guard_user, foreignReference: id, required: true, onDelete: cascade }
142     recommended_id:   { type: integer, foreignTable: sf_guard_user, foreignReference: id, required: true, onDelete: cascade }
143     content:          longvarchar
144     created_at:       { type: timestamp, index: true }
145     updated_at:       { type: timestamp, index: true }
146     _indexes:
147       filter_index:   [recommender_id, recommended_id, created_at]
Note: See TracBrowser for help on using the browser.