From f389e50029a053de2ec1cc4368ca5b9981e74bdf Mon Sep 17 00:00:00 2001
From: Eileen <eileen@fuzion.co.nz>
Date: Wed, 4 Dec 2013 15:58:14 +1300
Subject: [PATCH] Schema tidy ups - add pseudoconstants for recurring
 contributions, add a couple of titles

---
 xml/schema/Contribute/ContributionPage.xml  | 8 ++++++++
 xml/schema/Contribute/ContributionRecur.xml | 8 ++++++++
 2 files changed, 16 insertions(+)

diff --git a/xml/schema/Contribute/ContributionPage.xml b/xml/schema/Contribute/ContributionPage.xml
index c8f0ee7d79..10aa925d26 100644
--- a/xml/schema/Contribute/ContributionPage.xml
+++ b/xml/schema/Contribute/ContributionPage.xml
@@ -20,6 +20,7 @@
   </primaryKey>
   <field>
     <name>title</name>
+    <title>Contribution Page Title</title>
     <type>varchar</type>
     <length>255</length>
     <localizable>true</localizable>
@@ -28,6 +29,7 @@
   </field>
   <field>
     <name>intro_text</name>
+    <title>Contribution Page Introduction Text</title>
     <type>text</type>
     <htmlType>textarea</htmlType>
     <rows>6</rows>
@@ -334,6 +336,7 @@
   </field>
   <field>
     <name>honor_block_title</name>
+    <title>Contribution Page Honor Block Title</title>
     <type>varchar</type>
     <length>255</length>
     <localizable>true</localizable>
@@ -342,6 +345,7 @@
   </field>
   <field>
     <name>honor_block_text</name>
+    <title>Contribution Page Honor Block Text</title>
     <type>text</type>
     <htmlType>textarea</htmlType>
     <rows>2</rows>
@@ -366,6 +370,7 @@
   </field>
   <field>
     <name>created_id</name>
+    <title>Contribution Page Created By</title>
     <type>int unsigned</type>
     <comment>FK to civicrm_contact, who created this contribution page</comment>
     <add>3.0</add>
@@ -386,6 +391,7 @@
   </field>
   <field>
     <name>currency</name>
+    <title>Contribution Page Currency</title>
     <type>varchar</type>
     <length>3</length>
     <default>NULL</default>
@@ -402,6 +408,7 @@
   </field>
   <field>
     <name>campaign_id</name>
+    <title>Contribution Page Campaign ID</title>
     <type>int unsigned</type>
     <comment>The campaign for which we are collecting contributions with this page.</comment>
     <add>3.4</add>
@@ -414,6 +421,7 @@
   </foreignKey>
   <field>
     <name>is_share</name>
+    <title>Is Contribution Page Shared?</title>
     <type>boolean</type>
     <default>1</default>
     <comment>Can people share the contribution page through social media?</comment>
diff --git a/xml/schema/Contribute/ContributionRecur.xml b/xml/schema/Contribute/ContributionRecur.xml
index 01602426f1..5be85af260 100644
--- a/xml/schema/Contribute/ContributionRecur.xml
+++ b/xml/schema/Contribute/ContributionRecur.xml
@@ -159,6 +159,9 @@
     <default>1</default>
     <import>true</import>
     <add>1.6</add>
+    <pseudoconstant>
+      <optionGroupName>contribution_status</optionGroupName>
+    </pseudoconstant>
   </field>
   <index>
     <name>index_contribution_status</name>
@@ -257,6 +260,11 @@
     <type>int unsigned</type>
     <comment>FK to Financial Type</comment>
     <add>4.3</add>
+    <pseudoconstant>
+      <table>civicrm_financial_type</table>
+      <keyColumn>id</keyColumn>
+      <labelColumn>name</labelColumn>
+    </pseudoconstant>
   </field>
   <foreignKey>
     <name>financial_type_id</name>
-- 
2.25.1