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 c1333e497f8a48518c223c9b535ecc470dc8843c..0d25df45110c69d8af09ce9ec4eec2b1bb59f5a7 100644 (file)
--- a/xml/schema/Core/County.xml
+++ b/xml/schema/Core/County.xml
@@ -6,47 +6,54 @@
   <name>civicrm_county</name>
   <add>1.1</add>
   <field>
-       <name>id</name>
-       <type>int unsigned</type>
-       <required>true</required>
-       <comment>County ID</comment>
-       <add>1.1</add>
+    <name>id</name>
+    <title>County ID</title>
+    <type>int unsigned</type>
+    <required>true</required>
+    <comment>County ID</comment>
+    <add>1.1</add>
   </field>
   <primaryKey>
-       <name>id</name>
-       <autoincrement>false</autoincrement>
+    <name>id</name>
+    <autoincrement>false</autoincrement>
   </primaryKey>
   <field>
-       <name>name</name>
-       <title>County</title>
-       <type>varchar</type>
-       <length>64</length>
-       <import>true</import>
-       <headerPattern>/county/i</headerPattern>
-       <dataPattern>/[A-Z]{2}/</dataPattern>
-       <comment>Name of County</comment>
-       <add>1.1</add>
+    <name>name</name>
+    <title>County</title>
+    <type>varchar</type>
+    <length>64</length>
+    <import>true</import>
+    <headerPattern>/county/i</headerPattern>
+    <dataPattern>/[A-Z]{2}/</dataPattern>
+    <comment>Name of County</comment>
+    <add>1.1</add>
   </field>
   <field>
-       <name>abbreviation</name>
-       <title>County Abbreviation</title>
-       <type>varchar</type>
-       <length>4</length>
-       <comment>2-4 Character Abbreviation of County</comment>
-       <add>1.1</add>
+    <name>abbreviation</name>
+    <title>County Abbreviation</title>
+    <type>varchar</type>
+    <length>4</length>
+    <comment>2-4 Character Abbreviation of County</comment>
+    <add>1.1</add>
   </field>
   <field>
-       <name>state_province_id</name>
-       <type>int unsigned</type>
-       <required>true</required>
-       <comment>ID of State / Province that County belongs</comment>
-       <add>1.1</add>
+    <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>
-       <table>civicrm_state_province</table>
-       <key>id</key>
-       <add>1.1</add>
+    <name>state_province_id</name>
+    <table>civicrm_state_province</table>
+    <key>id</key>
+    <add>1.1</add>
   </foreignKey>
   <index>
     <name>UI_name_state_id</name>