[civicrm-core.git] / xml / schema / PCP / PCPBlock.xml

<?xml version="1.0" encoding="iso-8859-1" ?>

<table>
  <base>CRM/PCP</base>
  <class>PCPBlock</class>
  <name>civicrm_pcp_block</name>
  <comment>A Personal Campaign Page Block stores admin configurable status options and rules</comment>
  <add>2.2</add>
  <log>true</log>
  <field>
    <name>id</name>
    <title>PCP Block ID</title>
    <type>int unsigned</type>
    <required>true</required>
    <comment>PCP block Id</comment>
    <add>2.2</add>
  </field>
  <primaryKey>
    <name>id</name>
    <autoincrement>true</autoincrement>
  </primaryKey>
  <field>
    <name>entity_table</name>
    <title>Entity Table</title>
    <type>varchar</type>
    <length>64</length>
    <add>2.2</add>
  </field>
  <field>
    <name>entity_id</name>
    <title>Entity</title>
    <type>int unsigned</type>
    <required>true</required>
    <comment>FK to civicrm_contribution_page.id OR civicrm_event.id</comment>
    <add>2.2</add>
  </field>
  <dynamicForeignKey>
    <idColumn>entity_id</idColumn>
    <typeColumn>entity_table</typeColumn>
    <add>2.2</add>
  </dynamicForeignKey>
  <foreignKey>
    <name>entity_id</name>
    <table>civicrm_contribution_page</table>
    <key>id</key>
    <add>2.2</add>
    <drop>4.1</drop>
  </foreignKey>
  <field>
    <name>target_entity_type</name>
    <title>Target Entity</title>
    <type>varchar</type>
    <length>255</length>
    <required>true</required>
    <default>'contribute'</default>
    <comment>The type of entity that this pcp targets</comment>
    <add>4.1</add>
  </field>
  <field>
    <name>target_entity_id</name>
    <title>Target Entity ID</title>
    <type>int unsigned</type>
    <required>true</required>
    <comment>The entity that this pcp targets</comment>
    <add>4.1</add>
  </field>
  <dynamicForeignKey>
    <idColumn>target_entity_id</idColumn>
    <!-- FIXME: typename and not tablename? -->
    <typeColumn>target_entity_type</typeColumn>
    <add>4.1</add>
  </dynamicForeignKey>
  <field>
    <name>supporter_profile_id</name>
    <title>Supporter Profile</title>
    <type>int unsigned</type>
    <comment>FK to civicrm_uf_group.id. Does Personal Campaign Page require manual activation by administrator? (is inactive by default after setup)?</comment>
    <default>NULL</default>
    <add>2.2</add>
  </field>
  <foreignKey>
    <name>supporter_profile_id</name>
    <table>civicrm_uf_group</table>
    <key>id</key>
    <add>3.1</add>
    <onDelete>SET NULL</onDelete>
  </foreignKey>
  <field>
    <name>owner_notify_id</name>
    <title>Owner Notification</title>
    <type>int unsigned</type>
    <default>0</default>
    <comment>FK to civicrm_option_group with name = PCP owner notifications</comment>
    <add>4.6</add>
    <pseudoconstant>
      <optionGroupName>pcp_owner_notify</optionGroupName>
    </pseudoconstant>
    <html>
      <type>Radio</type>
    </html>
  </field>
  <field>
    <name>is_approval_needed</name>
    <title>Approval Required?</title>
    <type>boolean</type>
    <comment>Does Personal Campaign Page require manual activation by administrator? (is inactive by default after setup)?</comment>
    <default>NULL</default>
    <add>2.2</add>
  </field>
  <field>
    <name>is_tellfriend_enabled</name>
    <title>Tell a Friend Enabled?</title>
    <type>boolean</type>
    <comment>Does Personal Campaign Page allow using tell a friend?</comment>
    <default>NULL</default>
    <add>2.2</add>
  </field>
  <field>
    <name>tellfriend_limit</name>
    <title>Tell A Friend Limit</title>
    <type>int unsigned</type>
    <default>NULL</default>
    <comment>Maximum recipient fields allowed in tell a friend</comment>
    <add>2.2</add>
  </field>
  <field>
    <name>link_text</name>
    <title>Link Text</title>
    <type>varchar</type>
    <length>255</length>
    <default>NULL</default>
    <localizable>true</localizable>
    <comment>Link text for PCP.</comment>
    <add>2.2</add>
  </field>
  <field>
    <name>is_active</name>
    <title>Enabled?</title>
    <type>boolean</type>
    <comment>Is Personal Campaign Page Block enabled/active?</comment>
    <default>1</default>
    <add>2.2</add>
  </field>
  <field>
    <name>notify_email</name>
    <title>Notification Email</title>
    <type>varchar</type>
    <length>255</length>
    <comment>If set, notification is automatically emailed to this email-address on create/update Personal Campaign Page</comment>
    <default>NULL</default>
    <add>2.2</add>
  </field>
</table>
Commit	Line	Data
6a488035 TO	1	<?xml version="1.0" encoding="iso-8859-1" ?>
	2
	3	<table>
	4	<base>CRM/PCP</base>
	5	<class>PCPBlock</class>
	6	<name>civicrm_pcp_block</name>
	7	<comment>A Personal Campaign Page Block stores admin configurable status options and rules</comment>
	8	<add>2.2</add>
	9	<log>true</log>
	10	<field>
e244747c	11	<name>id</name>
f3ea5182	12	<title>PCP Block ID</title>
e244747c EM	13	<type>int unsigned</type>
	14	<required>true</required>
	15	<comment>PCP block Id</comment>
	16	<add>2.2</add>
6a488035 TO	17	</field>
6a488035 TO	18	<primaryKey>
e244747c EM	19	<name>id</name>
e244747c EM	20	<autoincrement>true</autoincrement>
6a488035 TO	21	</primaryKey>
6a488035 TO	22	<field>
e244747c	23	<name>entity_table</name>
f3ea5182	24	<title>Entity Table</title>
e244747c EM	25	<type>varchar</type>
	26	<length>64</length>
	27	<add>2.2</add>
6a488035 TO	28	</field>
6a488035 TO	29	<field>
e244747c	30	<name>entity_id</name>
f3ea5182	31	<title>Entity</title>
e244747c EM	32	<type>int unsigned</type>
	33	<required>true</required>
	34	<comment>FK to civicrm_contribution_page.id OR civicrm_event.id</comment>
	35	<add>2.2</add>
6a488035	36	</field>
71e5aa5c	37	<dynamicForeignKey>
e244747c EM	38	<idColumn>entity_id</idColumn>
	39	<typeColumn>entity_table</typeColumn>
	40	<add>2.2</add>
71e5aa5c	41	</dynamicForeignKey>
3c7d2158	42	<foreignKey>
e244747c EM	43	<name>entity_id</name>
	44	<table>civicrm_contribution_page</table>
	45	<key>id</key>
	46	<add>2.2</add>
	47	<drop>4.1</drop>
6a488035 TO	48	</foreignKey>
6a488035 TO	49	<field>
e244747c	50	<name>target_entity_type</name>
f3ea5182	51	<title>Target Entity</title>
e244747c EM	52	<type>varchar</type>
	53	<length>255</length>
	54	<required>true</required>
	55	<default>'contribute'</default>
	56	<comment>The type of entity that this pcp targets</comment>
	57	<add>4.1</add>
6a488035 TO	58	</field>
6a488035 TO	59	<field>
e244747c	60	<name>target_entity_id</name>
f3ea5182	61	<title>Target Entity ID</title>
e244747c EM	62	<type>int unsigned</type>
	63	<required>true</required>
	64	<comment>The entity that this pcp targets</comment>
	65	<add>4.1</add>
6a488035	66	</field>
71e5aa5c	67	<dynamicForeignKey>
e244747c EM	68	<idColumn>target_entity_id</idColumn>
	69	<!-- FIXME: typename and not tablename? -->
	70	<typeColumn>target_entity_type</typeColumn>
	71	<add>4.1</add>
71e5aa5c	72	</dynamicForeignKey>
3c7d2158	73	<field>
e244747c	74	<name>supporter_profile_id</name>
f3ea5182	75	<title>Supporter Profile</title>
e244747c EM	76	<type>int unsigned</type>
	77	<comment>FK to civicrm_uf_group.id. Does Personal Campaign Page require manual activation by administrator? (is inactive by default after setup)?</comment>
	78	<default>NULL</default>
	79	<add>2.2</add>
6a488035	80	</field>
3c7d2158	81	<foreignKey>
e244747c EM	82	<name>supporter_profile_id</name>
	83	<table>civicrm_uf_group</table>
	84	<key>id</key>
	85	<add>3.1</add>
	86	<onDelete>SET NULL</onDelete>
6a488035	87	</foreignKey>
12f92dbd N	88	<field>
	89	<name>owner_notify_id</name>
	90	<title>Owner Notification</title>
	91	<type>int unsigned</type>
8bbae400	92	<default>0</default>
12f92dbd N	93	<comment>FK to civicrm_option_group with name = PCP owner notifications</comment>
	94	<add>4.6</add>
	95	<pseudoconstant>
	96	<optionGroupName>pcp_owner_notify</optionGroupName>
	97	</pseudoconstant>
	98	<html>
	99	<type>Radio</type>
	100	</html>
	101	</field>
3c7d2158	102	<field>
e244747c	103	<name>is_approval_needed</name>
f3ea5182	104	<title>Approval Required?</title>
e244747c EM	105	<type>boolean</type>
	106	<comment>Does Personal Campaign Page require manual activation by administrator? (is inactive by default after setup)?</comment>
	107	<default>NULL</default>
	108	<add>2.2</add>
6a488035	109	</field>
3c7d2158	110	<field>
e244747c	111	<name>is_tellfriend_enabled</name>
f3ea5182	112	<title>Tell a Friend Enabled?</title>
e244747c EM	113	<type>boolean</type>
	114	<comment>Does Personal Campaign Page allow using tell a friend?</comment>
	115	<default>NULL</default>
	116	<add>2.2</add>
6a488035	117	</field>
3c7d2158	118	<field>
e244747c	119	<name>tellfriend_limit</name>
f3ea5182	120	<title>Tell A Friend Limit</title>
e244747c EM	121	<type>int unsigned</type>
	122	<default>NULL</default>
	123	<comment>Maximum recipient fields allowed in tell a friend</comment>
	124	<add>2.2</add>
6a488035 TO	125	</field>
6a488035 TO	126	<field>
e244747c	127	<name>link_text</name>
f3ea5182	128	<title>Link Text</title>
e244747c EM	129	<type>varchar</type>
	130	<length>255</length>
	131	<default>NULL</default>
	132	<localizable>true</localizable>
	133	<comment>Link text for PCP.</comment>
	134	<add>2.2</add>
3c7d2158	135	</field>
3c7d2158	136	<field>
e244747c	137	<name>is_active</name>
f3ea5182	138	<title>Enabled?</title>
e244747c EM	139	<type>boolean</type>
	140	<comment>Is Personal Campaign Page Block enabled/active?</comment>
	141	<default>1</default>
	142	<add>2.2</add>
6a488035	143	</field>
3c7d2158	144	<field>
e244747c	145	<name>notify_email</name>
f3ea5182	146	<title>Notification Email</title>
e244747c EM	147	<type>varchar</type>
	148	<length>255</length>
	149	<comment>If set, notification is automatically emailed to this email-address on create/update Personal Campaign Page</comment>
	150	<default>NULL</default>
	151	<add>2.2</add>
6a488035 TO	152	</field>
6a488035 TO	153	</table>