E-mail
Table: civicrm_pcp
Field |
Type |
Null |
Key |
Default |
Extra |
|---|---|---|---|---|---|
id |
int(10) unsigned |
NO |
PRI |
NULL |
auto_increment |
contact_id |
int(10) unsigned |
NO |
|
|
|
status_id |
int(10) unsigned |
NO |
|
|
|
title |
varchar(255) |
YES |
|
NULL |
|
intro_text |
text |
YES |
|
NULL |
|
page_text |
text |
YES |
|
NULL |
|
donate_link_text |
varchar(255) |
YES |
|
NULL |
|
contribution_page_id |
int(10) unsigned |
NO |
MUL |
NULL |
|
is_thermometer |
tinyint(4) |
YES |
|
0 |
|
is_honor_roll |
tinyint(4) |
YES |
|
0 |
|
goal_amount |
decimal(20,2) |
YES |
|
NULL |
|
referer |
varchar(255) |
YES |
|
NULL |
|
is_active |
tinyint(4) |
YES |
|
0 |
|
Table: civicrm_pcp_block
Field |
Type |
Null |
Key |
Default |
Extra |
|---|---|---|---|---|---|
entity_table |
varchar(64) |
YES |
|
NULL |
|
entity_id |
int(10) unsigned |
NO |
MUL |
NULL |
|
supporter_profile_id |
int(10) unsigned |
NO |
|
NULL |
|
is_approval_needed |
tinyint(4) |
YES |
|
0 |
|
is_tellfriend_enabled |
tinyint(4) |
YES |
|
0 |
|
tellfriend_limit |
int(10) unsigned |
YES |
|
NULL |
|
link_text |
varchar(255) |
YES |
|
NULL |
tinyint(4) |
is_active |
tinyint(4) |
YES |
|
1 |
|
Table: civicrm_contribution (extensions)
Field |
Type |
Null |
Key |
Default |
Extra |
|---|---|---|---|---|---|
pcp_made_through_id |
int(10) unsigned |
YES |
|
NULL |
|
pcp_display_in_roll |
tinyint(4) |
YES |
|
0 |
|
pcp_roll_nickname |
varchar(255) |
YES |
|
NULL |
|
pcp_personal_note |
varchar(255) |
YES |
|
NULL |
|
Additional changes
- "pcp_status" option group in civicrm_option_group
- values for "pcp_status" in civicrm_option_value: "Needs Review", "Approved", "Rejected"
