Merge pull request #17127 from totten/master-dispatch-policy

[civicrm-core.git] / xml / schema / Core / County.xml

diff --git a/xml/schema/Core/County.xml b/xml/schema/Core/County.xml
index 2a5ba001f7461c98c269c217261fb35d5e2941d8..0d25df45110c69d8af09ce9ec4eec2b1bb59f5a7 100644 (file)
--- a/xml/schema/Core/County.xml
+++ b/xml/schema/Core/County.xml
@@ -7,6 +7,7 @@
   <add>1.1</add>
   <field>
     <name>id</name>
+    <title>County ID</title>
     <type>int unsigned</type>
     <required>true</required>
     <comment>County ID</comment>
@@ -37,10 +38,16 @@
   </field>
   <field>
     <name>state_province_id</name>
+    <title>State</title>
     <type>int unsigned</type>
     <required>true</required>
     <comment>ID of State/Province that County belongs</comment>
     <add>1.1</add>
+    <pseudoconstant>
+      <table>civicrm_state_province</table>
+      <keyColumn>id</keyColumn>
+      <labelColumn>name</labelColumn>
+    </pseudoconstant>
   </field>
   <foreignKey>
     <name>state_province_id</name>