From 960128817a9a22d226b19c4e3141f792df5200c4 Mon Sep 17 00:00:00 2001
From: Pradeep Nayak <pradpnayak@gmail.com>
Date: Mon, 16 Mar 2020 17:28:48 +0000
Subject: [PATCH] Added pseudoconstant for state province

---
 CRM/Core/DAO/County.php    | 7 ++++++-
 xml/schema/Core/County.xml | 5 +++++
 2 files changed, 11 insertions(+), 1 deletion(-)

diff --git a/CRM/Core/DAO/County.php b/CRM/Core/DAO/County.php
index 7c183f5de0..4a1524d510 100644
--- a/CRM/Core/DAO/County.php
+++ b/CRM/Core/DAO/County.php
@@ -6,7 +6,7 @@
  *
  * Generated from xml/schema/CRM/Core/County.xml
  * DO NOT EDIT.  Generated by CRM_Core_CodeGen
- * (GenCodeChecksum:9af9ee85c4e413dda6398cc51e9e4f82)
+ * (GenCodeChecksum:c22121afe6539d3ec7c51e905de299d7)
  */
 
 /**
@@ -141,6 +141,11 @@ class CRM_Core_DAO_County extends CRM_Core_DAO {
           'bao' => 'CRM_Core_DAO_County',
           'localizable' => 0,
           'FKClassName' => 'CRM_Core_DAO_StateProvince',
+          'pseudoconstant' => [
+            'table' => 'civicrm_state_province',
+            'keyColumn' => 'id',
+            'labelColumn' => 'name',
+          ],
         ],
       ];
       CRM_Core_DAO_AllCoreTables::invoke(__CLASS__, 'fields_callback', Civi::$statics[__CLASS__]['fields']);
diff --git a/xml/schema/Core/County.xml b/xml/schema/Core/County.xml
index edd4513ff8..0d25df4511 100644
--- a/xml/schema/Core/County.xml
+++ b/xml/schema/Core/County.xml
@@ -43,6 +43,11 @@
     <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>
-- 
2.25.1