Added pseudoconstant for state province
[civicrm-core.git] / xml / schema / Core / StateProvince.xml
index daa60c48719a768692e94de3dd5840c475e4abd0..53f7aba31fa21cc7fac67af61a5abb652cd694b6 100644 (file)
@@ -7,9 +7,10 @@
   <add>1.1</add>
   <field>
     <name>id</name>
+    <title>State ID</title>
     <type>int unsigned</type>
     <required>true</required>
-    <comment>State / Province ID</comment>
+    <comment>State/Province ID</comment>
     <add>1.1</add>
   </field>
   <primaryKey>
@@ -24,7 +25,7 @@
     <import>true</import>
     <headerPattern>/state|prov(ince)?/i</headerPattern>
     <dataPattern>/[A-Z]{2}/</dataPattern>
-    <comment>Name of State / Province</comment>
+    <comment>Name of State/Province</comment>
     <add>1.1</add>
   </field>
   <field>
     <title>State Abbreviation</title>
     <type>varchar</type>
     <length>4</length>
-    <comment>2-4 Character Abbreviation of State / Province</comment>
+    <comment>2-4 Character Abbreviation of State/Province</comment>
     <add>1.1</add>
   </field>
   <field>
     <name>country_id</name>
+    <title>Country</title>
     <type>int unsigned</type>
     <required>true</required>
-    <comment>ID of Country that State / Province belong</comment>
+    <comment>ID of Country that State/Province belong</comment>
     <add>1.1</add>
   </field>
   <foreignKey>