-- Table structure for table `alf_node_aspects`
--

CREATE TABLE `alf_node_aspects` (
  `node_id` decimal(19,0) NOT NULL,
  `qname_id` decimal(19,0) NOT NULL,
  PRIMARY KEY (`node_id`,`qname_id`),
  KEY `fk_alf_nasp_n` (`node_id`),
  KEY `fk_alf_nasp_qn` (`qname_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `alf_node_aspects`
--


--
-- Table structure for table `alf_node_assoc`
--

CREATE TABLE `alf_node_assoc` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `version` decimal(19,0) NOT NULL,
  `source_node_id` decimal(19,0) NOT NULL,
  `target_node_id` decimal(19,0) NOT NULL,
  `type_qname_id` decimal(19,0) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `source_node_id` (`source_node_id`,`target_node_id`,`type_qname_id`),
  KEY `fk_alf_nass_snode` (`source_node_id`),
  KEY `fk_alf_nass_tnode` (`target_node_id`),
  KEY `fk_alf_nass_tqn` (`type_qname_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `alf_node_assoc`
--


--
-- Table structure for table `alf_permission`
--

CREATE TABLE `alf_permission` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `version` decimal(19,0) NOT NULL,
  `type_qname_id` decimal(19,0) NOT NULL,
  `name` varchar(100) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `type_qname_id` (`type_qname_id`,`name`),
  KEY `fk_alf_perm_tqn` (`type_qname_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `alf_permission`
--


--
-- Table structure for table `alf_prop_class`
--

CREATE TABLE `alf_prop_class` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `java_class_name` varchar(255) NOT NULL,
  `java_class_name_short` varchar(32) NOT NULL,
  `java_class_name_crc` decimal(19,0) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `idx_alf_propc_crc` (`java_class_name_crc`,`java_class_name_short`),
  KEY `idx_alf_propc_clas` (`java_class_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `alf_prop_class`
--


--
-- Table structure for table `alf_prop_date_value`
--

CREATE TABLE `alf_prop_date_value` (
  `DATE_value` decimal(19,0) NOT NULL,
  `full_year` int NOT NULL,
  `half_of_year` tinyint NOT NULL,
  `quarter_of_year` tinyint NOT NULL,
  `month_of_year` tinyint NOT NULL,
  `week_of_year` tinyint NOT NULL,
  `week_of_month` tinyint NOT NULL,
  `day_of_year` int NOT NULL,
  `day_of_month` tinyint NOT NULL,
  `day_of_week` tinyint NOT NULL,
  PRIMARY KEY (`DATE_value`),
  KEY `idx_alf_propdt_dt` (`full_year`,`month_of_year`,`day_of_month`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `alf_prop_date_value`
--


--
-- Table structure for table `alf_prop_link`
--

CREATE TABLE `alf_prop_link` (
  `root_prop_id` decimal(19,0) NOT NULL,
  `prop_index` decimal(19,0) NOT NULL,
  `contained_in` decimal(19,0) NOT NULL,
  `key_prop_id` decimal(19,0) NOT NULL,
  `value_prop_id` decimal(19,0) NOT NULL,
  PRIMARY KEY (`root_prop_id`,`contained_in`,`prop_index`),
  KEY `fk_alf_propln_key` (`key_prop_id`),
  KEY `fk_alf_propln_val` (`value_prop_id`),
  KEY `idx_alf_propln_for` (`root_prop_id`,`key_prop_id`,`value_prop_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `alf_prop_link`
--


--
-- Table structure for table `alf_prop_string_value`
--

CREATE TABLE `alf_prop_string_value` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `string_value` varchar(1024) NOT NULL,
  `string_end_lower` varchar(16) NOT NULL,
  `string_crc` decimal(19,0) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `idx_alf_props_crc` (`string_end_lower`,`string_crc`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `alf_prop_string_value`
--


--
-- Table structure for table `alf_prop_unique_ctx`
--

CREATE TABLE `alf_prop_unique_ctx` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `version` int NOT NULL,
  `value1_prop_id` decimal(19,0) NOT NULL,
  `value2_prop_id` decimal(19,0) NOT NULL,
  `value3_prop_id` decimal(19,0) NOT NULL,
  `prop1_id` decimal(19,0) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `idx_alf_propuctx` (`value1_prop_id`,`value2_prop_id`,`value3_prop_id`),
  KEY `fk_alf_propuctx_p1` (`prop1_id`),
  KEY `fk_alf_propuctx_v2` (`value2_prop_id`),
  KEY `fk_alf_propuctx_v3` (`value3_prop_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `alf_prop_unique_ctx`
--


--
-- Table structure for table `alf_prop_value`
--

CREATE TABLE `alf_prop_value` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `actual_type_id` decimal(19,0) NOT NULL,
  `persisted_type` tinyint NOT NULL,
  `long_value` decimal(19,0) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `idx_alf_propv_act` (`actual_type_id`,`long_value`),
  KEY `idx_alf_propv_per` (`persisted_type`,`long_value`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `alf_prop_value`
--


--
-- Table structure for table `alf_qname`
--

CREATE TABLE `alf_qname` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `version` decimal(19,0) NOT NULL,
  `ns_id` decimal(19,0) NOT NULL,
  `local_name` varchar(200) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `ns_id` (`ns_id`,`local_name`),
  KEY `fk_alf_qname_ns` (`ns_id`)
) ENGINE=InnoDB AUTO_INCREMENT=20277 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `alf_qname`
--



--
-- Table structure for table `alf_server`
--

CREATE TABLE `alf_server` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `version` decimal(19,0) NOT NULL,
  `ip_address` varchar(39) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `ip_address` (`ip_address`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `alf_server`
--


--
-- Table structure for table `alf_store`
--

CREATE TABLE `alf_store` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `version` decimal(19,0) NOT NULL,
  `protocol` varchar(50) NOT NULL,
  `identifier` varchar(100) NOT NULL,
  `root_node_id` decimal(19,0) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `protocol` (`protocol`,`identifier`),
  KEY `fk_alf_store_root` (`root_node_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `alf_store`
--


--
-- Table structure for table `alf_transaction`
--

CREATE TABLE `alf_transaction` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `version` decimal(19,0) NOT NULL,
  `server_id` decimal(19,0) DEFAULT NULL,
  `change_txn_id` varchar(56) NOT NULL,
  `commit_time_ms` decimal(19,0) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `COMMIT_TIME_MS_ID_SID_IDX` (`commit_time_ms`,`id`,`server_id`),
  KEY `fk_alf_txn_svr` (`server_id`),
  KEY `idx_alf_txn_ctms` (`commit_time_ms`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `alf_transaction`
--


--
-- Table structure for table `alf_usage_delta`
--

CREATE TABLE `alf_usage_delta` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `version` decimal(19,0) NOT NULL,
  `node_id` decimal(19,0) NOT NULL,
  `delta_size` decimal(19,0) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `fk_alf_usaged_n` (`node_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `alf_usage_delta`
--


--
-- Table structure for table `avm_aspects`
--

CREATE TABLE `avm_aspects` (
  `node_id` decimal(19,0) NOT NULL,
  `qname_id` decimal(19,0) NOT NULL,
  PRIMARY KEY (`node_id`,`qname_id`),
  KEY `fk_avm_nasp_n` (`node_id`),
  KEY `fk_avm_nasp_qn` (`qname_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `avm_aspects`
--


--
-- Table structure for table `avm_child_entries`
--

CREATE TABLE `avm_child_entries` (
  `parent_id` decimal(19,0) NOT NULL,
  `lc_name` varchar(160) NOT NULL,
  `name` varchar(160) NOT NULL,
  `child_id` decimal(19,0) NOT NULL,
  PRIMARY KEY (`parent_id`,`lc_name`),
  KEY `fk_avm_ce_child` (`child_id`),
  KEY `fk_avm_ce_parent` (`parent_id`),
  KEY `idx_avm_ce_lc_name` (`lc_name`,`parent_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `avm_child_entries`
--


--
-- Table structure for table `avm_history_links`
--

CREATE TABLE `avm_history_links` (
  `ancestor` decimal(19,0) NOT NULL,
  `descendent` decimal(19,0) NOT NULL,
  PRIMARY KEY (`ancestor`,`descendent`),
  KEY `fk_avm_hl_ancestor` (`ancestor`),
  KEY `fk_avm_hl_desc` (`descendent`),
  KEY `idx_avm_hl_revpk` (`descendent`,`ancestor`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `avm_history_links`
--


--
-- Table structure for table `avm_merge_links`
--

CREATE TABLE `avm_merge_links` (
  `mfrom` decimal(19,0) NOT NULL,
  `mto` decimal(19,0) NOT NULL,
  PRIMARY KEY (`mfrom`,`mto`),
  KEY `fk_avm_ml_from` (`mfrom`),
  KEY `fk_avm_ml_to` (`mto`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `avm_merge_links`
--


--
-- Table structure for table `avm_nodes`
--

CREATE TABLE `avm_nodes` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `class_type` varchar(20) NOT NULL,
  `vers` decimal(19,0) NOT NULL,
  `version_id` int NOT NULL,
  `guid` varchar(36) DEFAULT NULL,
  `creator` varchar(255) NOT NULL,
  `owner` varchar(255) NOT NULL,
  `lastModifier` varchar(255) NOT NULL,
  `createDate` decimal(19,0) NOT NULL,
  `modDate` decimal(19,0) NOT NULL,
  `accessDate` decimal(19,0) NOT NULL,
  `is_root` tinyint DEFAULT NULL,
  `store_new_id` decimal(19,0) DEFAULT NULL,
  `acl_id` decimal(19,0) DEFAULT NULL,
  `deletedType` int DEFAULT NULL,
  `layer_id` decimal(19,0) DEFAULT NULL,
  `indirection` varchar(1024) DEFAULT NULL,
  `indirection_version` int DEFAULT NULL,
  `primary_indirection` tinyint DEFAULT NULL,
  `opacity` tinyint DEFAULT NULL,
  `content_url` varchar(128) DEFAULT NULL,
  `mime_type` varchar(100) DEFAULT NULL,
  `encoding` varchar(16) DEFAULT NULL,
  `length` decimal(19,0) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `fk_avm_n_acl` (`acl_id`),
  KEY `fk_avm_n_store` (`store_new_id`),
  KEY `idx_avm_n_pi` (`primary_indirection`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `avm_nodes`
--


--
-- Table structure for table `avm_stores`
--

CREATE TABLE `avm_stores` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `vers` decimal(19,0) NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `next_version_id` int NOT NULL,
  `current_root_id` decimal(19,0) DEFAULT NULL,
  `acl_id` decimal(19,0) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UQ__avm_stor__72E12F1B7EF5E282` (`name`),
  KEY `fk_avm_s_acl` (`acl_id`),
  KEY `fk_avm_s_root` (`current_root_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `avm_stores`
--


--
-- Table structure for table `avm_version_layered_node_entry`
--

CREATE TABLE `avm_version_layered_node_entry` (
  `version_root_id` decimal(19,0) NOT NULL,
  `md5sum` varchar(32) NOT NULL,
  `path` varchar(1024) DEFAULT NULL,
  PRIMARY KEY (`version_root_id`,`md5sum`),
  KEY `fk_avm_vlne_vr` (`version_root_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `avm_version_layered_node_entry`
--


--
-- Table structure for table `avm_version_roots`
--

CREATE TABLE `avm_version_roots` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `version_id` int NOT NULL,
  `avm_store_id` decimal(19,0) NOT NULL,
  `create_date` decimal(19,0) NOT NULL,
  `creator` varchar(255) NOT NULL,
  `root_id` decimal(19,0) NOT NULL,
  `tag` varchar(255) DEFAULT NULL,
  `description` varchar(1024) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UQ__avm_vers__EF2A660E853BEB3E` (`version_id`,`avm_store_id`),
  KEY `fk_avm_vr_root` (`root_id`),
  KEY `fk_avm_vr_store` (`avm_store_id`),
  KEY `idx_avm_vr_revuq` (`avm_store_id`,`version_id`),
  KEY `idx_avm_vr_version` (`version_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `avm_version_roots`
--


--
-- Table structure for table `boundary`
--

CREATE TABLE `boundary` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `boundary_number` varchar(50) NOT NULL,
  `name` varchar(255) NOT NULL,
  `boundary_type` enum('interstate','international','administrative','customary','disputed') NOT NULL,
  `state_a` varchar(100) NOT NULL,
  `state_b` varchar(100) NOT NULL,
  `length_km` decimal(10,2) DEFAULT NULL,
  `established_date` date DEFAULT NULL,
  `legal_basis` text,
  `status` varchar(50) DEFAULT 'active',
  `dispute_status` varchar(50) DEFAULT NULL,
  `security_classification` varchar(50) DEFAULT NULL,
  `is_locked` tinyint(1) NOT NULL DEFAULT '0',
  `workflow_stage` varchar(50) NOT NULL DEFAULT 'published',
  `assigned_commissioner_id` bigint unsigned DEFAULT NULL,
  `description` text,
  `created_at` datetime DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `police_command` varchar(255) DEFAULT NULL,
  `military_formation` varchar(255) DEFAULT NULL,
  `dss_zone` varchar(255) DEFAULT NULL,
  `nscdc_region` varchar(255) DEFAULT NULL,
  `is_high_risk` tinyint(1) NOT NULL DEFAULT '0',
  `risk_type` varchar(50) DEFAULT NULL,
  `has_active_incident` tinyint(1) NOT NULL DEFAULT '0',
  `boundary_sub_type` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `boundary_number` (`boundary_number`),
  KEY `idx_boundary_number` (`boundary_number`),
  KEY `idx_boundary_type` (`boundary_type`),
  KEY `idx_states` (`state_a`,`state_b`),
  KEY `idx_status` (`status`),
  KEY `boundary_assigned_commissioner_id_foreign` (`assigned_commissioner_id`),
  CONSTRAINT `boundary_assigned_commissioner_id_foreign` FOREIGN KEY (`assigned_commissioner_id`) REFERENCES `commission_members` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `boundary`
--

INSERT INTO `boundary` VALUES (1,'BND-001','Plateau-Benue Interstate Boundary','interstate','Plateau State','Benue State',245.50,'1960-10-01','Constitutional Act 1960','active',NULL,NULL,0,'published',NULL,'The official boundary between Plateau and Benue States, established at independence.','2025-12-16 16:08:58','2026-03-01 15:17:37',NULL,NULL,NULL,NULL,0,NULL,1,NULL),(2,'BND-002','Plateau-Kaduna Interstate Boundary','interstate','Plateau State','Kaduna State',189.30,'1960-10-01','Constitutional Act 1960','active',NULL,NULL,0,'published',NULL,'Northern boundary of Plateau State with Kaduna State.','2025-12-16 16:08:58','2025-12-16 16:08:58',NULL,NULL,NULL,NULL,0,NULL,0,NULL),(3,'BND-003','Plateau-Nasarawa Interstate Boundary','interstate','Plateau State','Nasarawa State',156.80,'1996-10-01','State Creation Act 1996','active',NULL,NULL,0,'published',NULL,'Eastern boundary established during state creation.','2025-12-16 16:08:58','2025-12-16 16:08:58',NULL,NULL,NULL,NULL,0,NULL,0,NULL),(4,'BND-004','Jos North-Jos South Administrative Boundary','administrative','Jos North LGA','Jos South LGA',42.50,'1991-05-15','Local Government Creation Decree','active',NULL,NULL,0,'published',NULL,'Administrative boundary within Plateau State.','2025-12-16 16:08:58','2025-12-16 16:08:58',NULL,NULL,NULL,NULL,0,NULL,0,NULL),(5,'BND-005','Plateau-Cameroon International Boundary','international','Plateau State','Cameroon',78.20,'1914-01-01','Anglo-German Treaty 1914','active',NULL,NULL,0,'published',NULL,'International boundary section within Plateau State jurisdiction.','2025-12-16 16:08:58','2025-12-16 16:08:58',NULL,NULL,NULL,NULL,0,NULL,0,NULL);

--
-- Table structure for table `boundary_access_log`
--

CREATE TABLE `boundary_access_log` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `boundary_id` bigint unsigned NOT NULL,
  `user_authority` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `action` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `boundary_access_log`
--

INSERT INTO `boundary_access_log` VALUES (1,5,'yusuphdilas@gmail.com','export','2026-03-01 15:39:33');

--
-- Table structure for table `boundary_alert_log`
--

CREATE TABLE `boundary_alert_log` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `boundary_id` bigint DEFAULT NULL,
  `dispute_id` bigint DEFAULT NULL,
  `alert_type` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `message` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `sent_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `boundary_alert_log_alert_type_created_at_index` (`alert_type`,`created_at`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `boundary_alert_log`
--


--
-- Table structure for table `boundary_audit_log`
--

CREATE TABLE `boundary_audit_log` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `boundary_id` bigint unsigned NOT NULL,
  `user_authority` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `action` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `old_values` json DEFAULT NULL,
  `new_values` json DEFAULT NULL,
  `reason` varchar(500) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `boundary_audit_log`
--


--
-- Table structure for table `boundary_checkpoint`
--

CREATE TABLE `boundary_checkpoint` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `boundary_id` bigint NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `latitude` decimal(10,8) NOT NULL,
  `longitude` decimal(11,8) NOT NULL,
  `checkpoint_type` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `notes` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `boundary_checkpoint_boundary_id_index` (`boundary_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `boundary_checkpoint`
--


--
-- Table structure for table `boundary_coordinate`
--

CREATE TABLE `boundary_coordinate` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `boundary_id` bigint NOT NULL,
  `sequence` int NOT NULL,
  `latitude` decimal(10,8) NOT NULL,
  `longitude` decimal(11,8) NOT NULL,
  `elevation` decimal(8,2) DEFAULT NULL,
  `coordinate_system` varchar(50) DEFAULT 'WGS84',
  `accuracy` decimal(8,2) DEFAULT NULL,
  `survey_date` date DEFAULT NULL,
  `survey_method` varchar(100) DEFAULT NULL,
  `created_at` datetime DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `idx_boundary_id` (`boundary_id`),
  KEY `idx_sequence` (`boundary_id`,`sequence`),
  KEY `idx_coordinates` (`latitude`,`longitude`),
  CONSTRAINT `boundary_coordinate_ibfk_1` FOREIGN KEY (`boundary_id`) REFERENCES `boundary` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `boundary_coordinate`
--

INSERT INTO `boundary_coordinate` VALUES (1,1,1,9.89650000,8.85830000,1250.50,'WGS84',2.50,'2020-03-15','GPS','2025-12-16 16:08:58'),(2,1,2,9.91230000,8.87560000,1248.20,'WGS84',2.30,'2020-03-15','GPS','2025-12-16 16:08:58'),(3,1,3,9.92870000,8.89210000,1245.80,'WGS84',2.10,'2020-03-15','GPS','2025-12-16 16:08:58'),(4,1,4,9.94520000,8.90870000,1243.50,'WGS84',2.40,'2020-03-15','GPS','2025-12-16 16:08:58'),(5,1,5,9.96180000,8.92540000,1241.20,'WGS84',2.20,'2020-03-15','GPS','2025-12-16 16:08:58'),(6,2,1,10.12340000,8.52340000,1350.00,'WGS84',2.00,'2019-11-20','GPS','2025-12-16 16:08:58'),(7,2,2,10.14560000,8.54560000,1348.50,'WGS84',2.10,'2019-11-20','GPS','2025-12-16 16:08:58'),(8,2,3,10.16780000,8.56780000,1347.00,'WGS84',2.20,'2019-11-20','GPS','2025-12-16 16:08:58'),(9,1,1,9.89650000,8.85830000,1250.50,'WGS84',2.50,'2020-03-15','GPS','2025-12-16 16:30:49'),(10,1,2,9.91230000,8.87560000,1248.20,'WGS84',2.30,'2020-03-15','GPS','2025-12-16 16:30:49'),(11,1,3,9.92870000,8.89210000,1245.80,'WGS84',2.10,'2020-03-15','GPS','2025-12-16 16:30:49'),(12,1,4,9.94520000,8.90870000,1243.50,'WGS84',2.40,'2020-03-15','GPS','2025-12-16 16:30:49'),(13,1,5,9.96180000,8.92540000,1241.20,'WGS84',2.20,'2020-03-15','GPS','2025-12-16 16:30:49'),(14,2,1,10.12340000,8.52340000,1350.00,'WGS84',2.00,'2019-11-20','GPS','2025-12-16 16:30:49'),(15,2,2,10.14560000,8.54560000,1348.50,'WGS84',2.10,'2019-11-20','GPS','2025-12-16 16:30:49'),(16,2,3,10.16780000,8.56780000,1347.00,'WGS84',2.20,'2019-11-20','GPS','2025-12-16 16:30:49');

--
-- Table structure for table `boundary_crossing_point`
--

CREATE TABLE `boundary_crossing_point` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `boundary_id` bigint NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `latitude` decimal(10,8) NOT NULL,
  `longitude` decimal(11,8) NOT NULL,
  `risk_type` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `notes` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `boundary_crossing_point_boundary_id_index` (`boundary_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `boundary_crossing_point`
--


--
-- Table structure for table `boundary_dispute`
--

CREATE TABLE `boundary_dispute` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `dispute_number` varchar(50) NOT NULL,
  `boundary_id` bigint DEFAULT NULL,
  `title` varchar(255) NOT NULL,
  `description` text NOT NULL,
  `status` enum('pending','under_investigation','mediation','adjudication','resolved','appealed','closed') DEFAULT 'pending',
  `dispute_type` varchar(50) DEFAULT NULL,
  `claimant_a` varchar(100) NOT NULL,
  `party_a_type` varchar(50) DEFAULT NULL,
  `claimant_b` varchar(100) NOT NULL,
  `party_b_type` varchar(50) DEFAULT NULL,
  `disputed_area_km2` decimal(10,2) DEFAULT NULL,
  `filed_date` date NOT NULL,
  `resolution_date` date DEFAULT NULL,
  `resolution_summary` text,
  `legal_reference` varchar(255) DEFAULT NULL,
  `assigned_officer` varchar(100) DEFAULT NULL,
  `assigned_mediator_id` bigint unsigned DEFAULT NULL,
  `priority` enum('low','normal','high','urgent') DEFAULT 'normal',
  `created_at` datetime DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `escalated_to_violence` tinyint(1) NOT NULL DEFAULT '0',
  `escalated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `dispute_number` (`dispute_number`),
  KEY `idx_dispute_number` (`dispute_number`),
  KEY `idx_boundary_id` (`boundary_id`),
  KEY `idx_status` (`status`),
  KEY `idx_priority` (`priority`),
  KEY `idx_claimants` (`claimant_a`,`claimant_b`),
  KEY `idx_filed_date` (`filed_date`),
  KEY `boundary_dispute_assigned_mediator_id_foreign` (`assigned_mediator_id`),
  CONSTRAINT `boundary_dispute_assigned_mediator_id_foreign` FOREIGN KEY (`assigned_mediator_id`) REFERENCES `commission_members` (`id`) ON DELETE SET NULL,
  CONSTRAINT `boundary_dispute_ibfk_1` FOREIGN KEY (`boundary_id`) REFERENCES `boundary` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `boundary_dispute`
--

INSERT INTO `boundary_dispute` VALUES (1,'DSP-001',1,'Plateau-Benue Land Dispute at Wase Area','Dispute over 15.5 km² of land along the Plateau-Benue boundary near Wase Local Government Area. Both states claim ownership of the disputed territory.','under_investigation',NULL,'Plateau State',NULL,'Benue State',NULL,15.50,'2023-01-15',NULL,NULL,NULL,'Officer John Doe',NULL,'high','2025-12-16 16:08:58','2025-12-16 16:08:58',0,NULL),(2,'DSP-002',4,'Jos North-South Administrative Boundary Dispute','Ongoing dispute regarding the exact location of the administrative boundary between Jos North and Jos South LGAs, affecting several communities.','mediation',NULL,'Jos North LGA',NULL,'Jos South LGA',NULL,3.20,'2023-03-20',NULL,NULL,NULL,'Officer Jane Smith',NULL,'normal','2025-12-16 16:08:58','2025-12-16 16:08:58',0,NULL),(3,'DSP-003',NULL,'General Interstate Boundary Clarification','Request for clarification on multiple boundary points between Plateau and neighboring states. No specific area disputed.','pending',NULL,'Plateau State',NULL,'Multiple States',NULL,NULL,'2023-05-10',NULL,NULL,NULL,NULL,NULL,'low','2025-12-16 16:08:58','2025-12-16 16:08:58',0,NULL);

--
-- Table structure for table `boundary_document`
--

CREATE TABLE `boundary_document` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `document_number` varchar(50) NOT NULL,
  `document_type` enum('evidence','treaty','survey_report','map','testimony','other') NOT NULL,
  `related_boundary_id` bigint DEFAULT NULL,
  `related_dispute_id` bigint DEFAULT NULL,
  `related_survey_id` bigint DEFAULT NULL,
  `related_treaty_id` bigint DEFAULT NULL,
  `title` varchar(255) NOT NULL,
  `description` text,
  `content_path` varchar(500) DEFAULT NULL,
  `file_name` varchar(255) DEFAULT NULL,
  `file_size` bigint DEFAULT NULL,
  `mime_type` varchar(100) DEFAULT NULL,
  `page_count` int DEFAULT '0',
  `uploaded_by` varchar(100) DEFAULT NULL,
  `uploaded_date` datetime DEFAULT CURRENT_TIMESTAMP,
  `indexed_at` datetime DEFAULT NULL,
  `indexed_by` varchar(100) DEFAULT NULL,
  `captured_at` datetime DEFAULT NULL,
  `captured_by` varchar(100) DEFAULT NULL,
  `status` varchar(50) DEFAULT 'active',
  `metadata` json DEFAULT NULL,
  `created_at` datetime DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `document_number` (`document_number`),
  KEY `related_survey_id` (`related_survey_id`),
  KEY `related_treaty_id` (`related_treaty_id`),
  KEY `idx_document_number` (`document_number`),
  KEY `idx_document_type` (`document_type`),
  KEY `idx_boundary_id` (`related_boundary_id`),
  KEY `idx_dispute_id` (`related_dispute_id`),
  KEY `idx_uploaded_date` (`uploaded_date`),
  KEY `idx_status` (`status`),
  CONSTRAINT `boundary_document_ibfk_1` FOREIGN KEY (`related_boundary_id`) REFERENCES `boundary` (`id`) ON DELETE SET NULL,
  CONSTRAINT `boundary_document_ibfk_2` FOREIGN KEY (`related_dispute_id`) REFERENCES `boundary_dispute` (`id`) ON DELETE SET NULL,
  CONSTRAINT `boundary_document_ibfk_3` FOREIGN KEY (`related_survey_id`) REFERENCES `boundary_survey` (`id`) ON DELETE SET NULL,
  CONSTRAINT `boundary_document_ibfk_4` FOREIGN KEY (`related_treaty_id`) REFERENCES `boundary_treaty` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `boundary_document`
--

INSERT INTO `boundary_document` VALUES (1,'BND-DOC-20251205-151635-7519','map',NULL,NULL,NULL,NULL,'test',NULL,'boundary/ae66aa2a-65cc-4daa-a8a2-8d494d1ee075.bin','boundary_upload_c7f910a44855459da24728c0eee867c5',0,'application/octet-stream',1,NULL,'2025-12-05 15:16:35',NULL,NULL,NULL,NULL,'active',NULL,'2025-12-05 15:16:35','2025-12-05 15:16:35');

--
-- Table structure for table `boundary_incident`
--

CREATE TABLE `boundary_incident` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `boundary_id` bigint NOT NULL,
  `incident_type` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text COLLATE utf8mb4_unicode_ci,
  `latitude` decimal(10,8) DEFAULT NULL,
  `longitude` decimal(11,8) DEFAULT NULL,
  `reported_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `reported_by` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `severity` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'medium',
  `status` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'open',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `boundary_incident_boundary_id_reported_at_index` (`boundary_id`,`reported_at`),
  KEY `boundary_incident_incident_type_index` (`incident_type`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `boundary_incident`
--

INSERT INTO `boundary_incident` VALUES (1,1,'attack','Fulani Herdsmen bandit attacks on villages',NULL,NULL,'2026-03-01 15:17:37','yusuphdilas@gmail.com','high','open','2026-03-01 14:17:37','2026-03-01 14:17:37'),(2,1,'attack','Fulani Herdsmen bandit attacks on villages',NULL,NULL,'2026-03-01 15:17:37','yusuphdilas@gmail.com','high','open','2026-03-01 14:17:37','2026-03-01 14:17:37');

--
-- Table structure for table `boundary_marker`
--

CREATE TABLE `boundary_marker` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `boundary_id` bigint NOT NULL,
  `marker_number` varchar(50) NOT NULL,
  `marker_type` enum('pillar','beacon','monument','natural','gps_coordinate') NOT NULL,
  `latitude` decimal(10,8) NOT NULL,
  `longitude` decimal(11,8) NOT NULL,
  `elevation` decimal(8,2) DEFAULT NULL,
  `marker_condition` varchar(50) DEFAULT NULL,
  `last_inspection_date` date DEFAULT NULL,
  `description` text,
  `photos` text,
  `created_at` datetime DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `unique_marker` (`boundary_id`,`marker_number`),
  KEY `idx_boundary_id` (`boundary_id`),
  KEY `idx_marker_type` (`marker_type`),
  KEY `idx_coordinates` (`latitude`,`longitude`),
  CONSTRAINT `boundary_marker_ibfk_1` FOREIGN KEY (`boundary_id`) REFERENCES `boundary` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `boundary_marker`
--

INSERT INTO `boundary_marker` VALUES (1,1,'BND-001-MK-001','pillar',9.89650000,8.85830000,1250.50,'good','2023-06-15','Primary boundary pillar at starting point',NULL,'2025-12-16 16:08:58','2025-12-16 16:08:58'),(2,1,'BND-001-MK-002','pillar',9.92870000,8.89210000,1245.80,'good','2023-06-15','Mid-point boundary pillar',NULL,'2025-12-16 16:08:58','2025-12-16 16:08:58'),(3,1,'BND-001-MK-003','pillar',9.96180000,8.92540000,1241.20,'damaged','2023-06-15','End-point pillar - requires repair',NULL,'2025-12-16 16:08:58','2025-12-16 16:08:58'),(4,2,'BND-002-MK-001','beacon',10.12340000,8.52340000,1350.00,'good','2023-05-10','GPS beacon marker',NULL,'2025-12-16 16:08:58','2025-12-16 16:08:58'),(5,3,'BND-003-MK-001','monument',9.78900000,8.45670000,1200.00,'good','2023-07-20','Historical boundary monument',NULL,'2025-12-16 16:08:58','2025-12-16 16:08:58');

--
-- Table structure for table `boundary_survey`
--

CREATE TABLE `boundary_survey` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `boundary_id` bigint NOT NULL,
  `survey_number` varchar(50) NOT NULL,
  `survey_date` date NOT NULL,
  `survey_team` varchar(255) DEFAULT NULL,
  `survey_method` varchar(100) NOT NULL,
  `accuracy` decimal(8,2) DEFAULT NULL,
  `report_url` varchar(500) DEFAULT NULL,
  `report_document_id` bigint DEFAULT NULL,
  `notes` text,
  `approved` tinyint(1) DEFAULT '0',
  `approved_by` varchar(100) DEFAULT NULL,
  `approved_date` date DEFAULT NULL,
  `created_at` datetime DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `unique_survey` (`boundary_id`,`survey_number`),
  KEY `idx_boundary_id` (`boundary_id`),
  KEY `idx_survey_date` (`survey_date`),
  KEY `idx_approved` (`approved`),
  KEY `idx_report_document_id` (`report_document_id`),
  CONSTRAINT `boundary_survey_ibfk_1` FOREIGN KEY (`boundary_id`) REFERENCES `boundary` (`id`) ON DELETE CASCADE,
  CONSTRAINT `boundary_survey_ibfk_2` FOREIGN KEY (`report_document_id`) REFERENCES `boundary_document` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `boundary_survey`
--

INSERT INTO `boundary_survey` VALUES (1,1,'SUR-2020-001','2020-03-15','Survey Team Alpha','GPS',2.30,NULL,NULL,'Complete boundary survey using modern GPS technology. All coordinates verified.',1,'Director Survey','2020-04-01','2025-12-16 16:08:58'),(2,2,'SUR-2019-045','2019-11-20','Survey Team Beta','GPS',2.10,NULL,NULL,'Routine boundary verification survey.',1,'Director Survey','2019-12-05','2025-12-16 16:08:58'),(3,3,'SUR-2023-012','2023-07-20','Survey Team Gamma','Satellite',1.80,NULL,NULL,'High-resolution satellite survey for boundary clarification.',0,NULL,NULL,'2025-12-16 16:08:58');

--
-- Table structure for table `boundary_treaty`
--

CREATE TABLE `boundary_treaty` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `boundary_id` bigint DEFAULT NULL,
  `treaty_number` varchar(50) NOT NULL,
  `title` varchar(255) NOT NULL,
  `signing_date` date NOT NULL,
  `effective_date` date DEFAULT NULL,
  `parties` text NOT NULL,
  `document_url` varchar(500) DEFAULT NULL,
  `treaty_document_id` bigint DEFAULT NULL,
  `summary` text,
  `status` varchar(50) DEFAULT 'active',
  `created_at` datetime DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `is_peace_agreement` tinyint(1) NOT NULL DEFAULT '0',
  `published_at` timestamp NULL DEFAULT NULL,
  `is_locked` tinyint(1) NOT NULL DEFAULT '0',
  `resolution_document_id` bigint unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `treaty_number` (`treaty_number`),
  KEY `idx_treaty_number` (`treaty_number`),
  KEY `idx_boundary_id` (`boundary_id`),
  KEY `idx_status` (`status`),
  KEY `idx_signing_date` (`signing_date`),
  KEY `idx_treaty_document_id` (`treaty_document_id`),
  CONSTRAINT `boundary_treaty_ibfk_1` FOREIGN KEY (`boundary_id`) REFERENCES `boundary` (`id`) ON DELETE SET NULL,
  CONSTRAINT `boundary_treaty_ibfk_2` FOREIGN KEY (`treaty_document_id`) REFERENCES `boundary_document` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `boundary_treaty`
--

INSERT INTO `boundary_treaty` VALUES (1,1,'TRT-1960-001','Plateau-Benue Boundary Agreement 1960','1960-10-01','1960-10-01','Plateau State,Benue State',NULL,NULL,'Original agreement establishing the interstate boundary at independence.','active','2025-12-16 16:08:58','2025-12-16 16:08:58',0,NULL,0,NULL),(2,5,'TRT-1914-INT-001','Anglo-German Boundary Treaty 1914','1914-01-01','1914-01-01','United Kingdom,Germany',NULL,NULL,'International treaty establishing Nigeria-Cameroon boundary.','active','2025-12-16 16:08:58','2025-12-16 16:08:58',0,NULL,0,NULL),(3,3,'TRT-1996-001','State Creation Boundary Agreement 1996','1996-10-01','1996-10-01','Plateau State,Nasarawa State',NULL,NULL,'Agreement establishing boundaries during state creation in 1996.','active','2025-12-16 16:08:58','2025-12-16 16:08:58',0,NULL,0,NULL);

--
-- Table structure for table `commission_members`
--

CREATE TABLE `commission_members` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint unsigned DEFAULT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `role` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `assigned_region` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `phone` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `notes` text COLLATE utf8mb4_unicode_ci,
  `status` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'active',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `commission_members_status_index` (`status`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `commission_members`
--

INSERT INTO `commission_members` VALUES (1,11,'Che Yusuph','commissioner','Plateau','yusuphdilas@gmail.com','4141930904','I am the commissioner','active','2026-02-28 23:11:55','2026-02-28 23:11:55');

--
-- Table structure for table `dispute_evidence`
--

CREATE TABLE `dispute_evidence` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `document_id` bigint DEFAULT NULL,
  `dispute_id` bigint NOT NULL,
  `document_type` varchar(100) NOT NULL,
  `title` varchar(255) NOT NULL,
  `description` text,
  `document_url` varchar(500) DEFAULT NULL,
  `file_path` varchar(500) DEFAULT NULL,
  `submitted_by` varchar(100) DEFAULT NULL,
  `submitted_date` date NOT NULL,
  `is_primary` tinyint(1) DEFAULT '0',
  `created_at` datetime DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `idx_dispute_id` (`dispute_id`),
  KEY `idx_document_type` (`document_type`),
  KEY `idx_is_primary` (`is_primary`),
  KEY `idx_document_id` (`document_id`),
  CONSTRAINT `dispute_evidence_ibfk_1` FOREIGN KEY (`dispute_id`) REFERENCES `boundary_dispute` (`id`) ON DELETE CASCADE,
  CONSTRAINT `dispute_evidence_ibfk_2` FOREIGN KEY (`document_id`) REFERENCES `boundary_document` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `dispute_evidence`
--

INSERT INTO `dispute_evidence` VALUES (1,NULL,1,'survey','2020 Boundary Survey Report - Wase Area','Comprehensive survey report documenting the boundary coordinates in the disputed area.',NULL,NULL,'Survey Team Alpha','2023-01-20',1,'2025-12-16 16:08:58'),(2,NULL,1,'map','Historical Map 1950','Historical map showing boundary location from 1950.',NULL,NULL,'Plateau State Archives','2023-01-25',0,'2025-12-16 16:08:58'),(3,NULL,1,'treaty','1960 Constitutional Boundary Agreement','Original constitutional document establishing state boundaries.',NULL,NULL,'National Archives','2023-02-01',1,'2025-12-16 16:08:58'),(4,NULL,2,'survey','2022 Administrative Boundary Survey','Recent survey of administrative boundaries in Jos area.',NULL,NULL,'Survey Team Beta','2023-03-25',1,'2025-12-16 16:08:58'),(5,NULL,2,'testimony','Community Leader Testimonies','Collection of testimonies from community leaders on both sides.',NULL,NULL,'Mediation Committee','2023-04-10',0,'2025-12-16 16:08:58'),(6,NULL,1,'survey','2020 Boundary Survey Report - Wase Area','Comprehensive survey report documenting the boundary coordinates in the disputed area.',NULL,NULL,'Survey Team Alpha','2023-01-20',1,'2025-12-16 16:30:49'),(7,NULL,1,'map','Historical Map 1950','Historical map showing boundary location from 1950.',NULL,NULL,'Plateau State Archives','2023-01-25',0,'2025-12-16 16:30:49'),(8,NULL,1,'treaty','1960 Constitutional Boundary Agreement','Original constitutional document establishing state boundaries.',NULL,NULL,'National Archives','2023-02-01',1,'2025-12-16 16:30:49'),(9,NULL,2,'survey','2022 Administrative Boundary Survey','Recent survey of administrative boundaries in Jos area.',NULL,NULL,'Survey Team Beta','2023-03-25',1,'2025-12-16 16:30:49'),(10,NULL,2,'testimony','Community Leader Testimonies','Collection of testimonies from community leaders on both sides.',NULL,NULL,'Mediation Committee','2023-04-10',0,'2025-12-16 16:30:49');

--
-- Table structure for table `dispute_stakeholder`
--

CREATE TABLE `dispute_stakeholder` (
  `dispute_id` bigint NOT NULL,
  `stakeholder_id` bigint NOT NULL,
  `role_in_dispute` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`dispute_id`,`stakeholder_id`),
  KEY `idx_dispute_id` (`dispute_id`),
  KEY `idx_stakeholder_id` (`stakeholder_id`),
  CONSTRAINT `dispute_stakeholder_ibfk_1` FOREIGN KEY (`dispute_id`) REFERENCES `boundary_dispute` (`id`) ON DELETE CASCADE,
  CONSTRAINT `dispute_stakeholder_ibfk_2` FOREIGN KEY (`stakeholder_id`) REFERENCES `stakeholder` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `dispute_stakeholder`
--

INSERT INTO `dispute_stakeholder` VALUES (1,1,'claimant'),(1,2,'claimant'),(1,3,'affected_party'),(1,6,'mediator'),(2,4,'claimant'),(2,5,'claimant'),(2,6,'mediator');

--
-- Table structure for table `dispute_timeline`
--

CREATE TABLE `dispute_timeline` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `dispute_id` bigint NOT NULL,
  `event_date` datetime NOT NULL,
  `event_type` varchar(100) NOT NULL,
  `description` text,
  `actor` varchar(100) DEFAULT NULL,
  `document_url` varchar(500) DEFAULT NULL,
  `created_at` datetime DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `idx_dispute_id` (`dispute_id`),
  KEY `idx_event_date` (`event_date`),
  KEY `idx_event_type` (`event_type`),
  CONSTRAINT `dispute_timeline_ibfk_1` FOREIGN KEY (`dispute_id`) REFERENCES `boundary_dispute` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `dispute_timeline`
--

INSERT INTO `dispute_timeline` VALUES (1,1,'2023-01-15 10:00:00','filed','Dispute case filed by Plateau State Government','Plateau State Government',NULL,'2025-12-16 16:08:58'),(2,1,'2023-01-20 14:30:00','evidence_submitted','Initial survey evidence submitted','Survey Team Alpha',NULL,'2025-12-16 16:08:58'),(3,1,'2023-02-15 09:00:00','status_change','Status changed to Under Investigation','Officer John Doe',NULL,'2025-12-16 16:08:58'),(4,2,'2023-03-20 11:00:00','filed','Administrative boundary dispute filed','Jos North LGA',NULL,'2025-12-16 16:08:58'),(5,2,'2023-04-01 10:00:00','status_change','Status changed to Mediation','Officer Jane Smith',NULL,'2025-12-16 16:08:58'),(6,2,'2023-04-15 14:00:00','mediation_meeting','First mediation meeting held','National Boundary Commission',NULL,'2025-12-16 16:08:58');

--
-- Table structure for table `document_treatments`
--

CREATE TABLE `document_treatments` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `boundary_document_id` bigint NOT NULL,
  `user_id` bigint unsigned DEFAULT NULL,
  `user_authority` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `action` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `role_snapshot` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `treated_at` datetime NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `document_treatments_boundary_document_id_treated_at_index` (`boundary_document_id`,`treated_at`),
  KEY `document_treatments_action_index` (`action`),
  CONSTRAINT `document_treatments_boundary_document_id_foreign` FOREIGN KEY (`boundary_document_id`) REFERENCES `boundary_document` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `document_treatments`
--


--
-- Table structure for table `electoral_constituency`
--

CREATE TABLE `electoral_constituency` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `code` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `population` bigint unsigned NOT NULL DEFAULT '0',
  `allocated_seats` int unsigned NOT NULL DEFAULT '1',
  `boundary_id` bigint DEFAULT NULL,
  `region` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `underserved_flag` tinyint(1) NOT NULL DEFAULT '0',
  `notes` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `electoral_constituency_code_unique` (`code`),
  KEY `electoral_constituency_boundary_id_index` (`boundary_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `electoral_constituency`
--


--
-- Table structure for table `JBPM_ACTION`
--

CREATE TABLE `JBPM_ACTION` (
  `ID_` bigint NOT NULL AUTO_INCREMENT,
  `class` char(1) NOT NULL,
  `NAME_` varchar(255) DEFAULT NULL,
  `ISPROPAGATIONALLOWED_` tinyint DEFAULT NULL,
  `ACTIONEXPRESSION_` varchar(255) DEFAULT NULL,
  `ISASYNC_` tinyint DEFAULT NULL,
  `REFERENCEDACTION_` decimal(19,0) DEFAULT NULL,
  `ACTIONDELEGATION_` decimal(19,0) DEFAULT NULL,
  `EVENT_` decimal(19,0) DEFAULT NULL,
  `PROCESSDEFINITION_` decimal(19,0) DEFAULT NULL,
  `TIMERNAME_` varchar(255) DEFAULT NULL,
  `DUEDATE_` varchar(255) DEFAULT NULL,
  `REPEAT_` varchar(255) DEFAULT NULL,
  `TRANSITIONNAME_` varchar(255) DEFAULT NULL,
  `TIMERACTION_` decimal(19,0) DEFAULT NULL,
  `EXPRESSION_` text,
  `EVENTINDEX_` int DEFAULT NULL,
  `EXCEPTIONHANDLER_` decimal(19,0) DEFAULT NULL,
  `EXCEPTIONHANDLERINDEX_` int DEFAULT NULL,
  PRIMARY KEY (`ID_`),
  KEY `FK_ACTION_ACTNDEL` (`ACTIONDELEGATION_`),
  KEY `FK_ACTION_EVENT` (`EVENT_`),
  KEY `FK_ACTION_EXPTHDL` (`EXCEPTIONHANDLER_`),
  KEY `FK_ACTION_PROCDEF` (`PROCESSDEFINITION_`),
  KEY `FK_ACTION_REFACT` (`REFERENCEDACTION_`),
  KEY `FK_CRTETIMERACT_TA` (`TIMERACTION_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `JBPM_ACTION`
--


--
-- Table structure for table `JBPM_BYTEARRAY`
--

CREATE TABLE `JBPM_BYTEARRAY` (
  `ID_` bigint NOT NULL AUTO_INCREMENT,
  `NAME_` varchar(255) DEFAULT NULL,
  `FILEDEFINITION_` decimal(19,0) DEFAULT NULL,
  PRIMARY KEY (`ID_`),
  KEY `FK_BYTEARR_FILDEF` (`FILEDEFINITION_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `JBPM_BYTEARRAY`
--


--
-- Table structure for table `JBPM_COMMENT`
--

CREATE TABLE `JBPM_COMMENT` (
  `ID_` bigint NOT NULL AUTO_INCREMENT,
  `VERSION_` int NOT NULL,
  `ACTORID_` varchar(255) DEFAULT NULL,
  `TIME_` datetime DEFAULT NULL,
  `MESSAGE_` text,
  `TOKEN_` decimal(19,0) DEFAULT NULL,
  `TASKINSTANCE_` decimal(19,0) DEFAULT NULL,
  `TOKENINDEX_` int DEFAULT NULL,
  `TASKINSTANCEINDEX_` int DEFAULT NULL,
  PRIMARY KEY (`ID_`),
  KEY `FK_COMMENT_TOKEN` (`TOKEN_`),
  KEY `FK_COMMENT_TSK` (`TASKINSTANCE_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `JBPM_COMMENT`
--


--
-- Table structure for table `JBPM_DECISIONCONDITIONS`
--

CREATE TABLE `JBPM_DECISIONCONDITIONS` (
  `DECISION_` decimal(19,0) NOT NULL,
  `TRANSITIONNAME_` varchar(255) DEFAULT NULL,
  `EXPRESSION_` varchar(255) DEFAULT NULL,
  `INDEX_` int NOT NULL,
  PRIMARY KEY (`DECISION_`,`INDEX_`),
  KEY `FK_DECCOND_DEC` (`DECISION_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `JBPM_DECISIONCONDITIONS`
--


--
-- Table structure for table `JBPM_DELEGATION`
--

CREATE TABLE `JBPM_DELEGATION` (
  `ID_` bigint NOT NULL AUTO_INCREMENT,
  `CLASSNAME_` text,
  `CONFIGURATION_` text,
  `CONFIGTYPE_` varchar(255) DEFAULT NULL,
  `PROCESSDEFINITION_` decimal(19,0) DEFAULT NULL,
  PRIMARY KEY (`ID_`),
  KEY `FK_DELEGATION_PRCD` (`PROCESSDEFINITION_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `JBPM_DELEGATION`
--


--
-- Table structure for table `JBPM_EVENT`
--

CREATE TABLE `JBPM_EVENT` (
  `ID_` bigint NOT NULL AUTO_INCREMENT,
  `EVENTTYPE_` varchar(255) DEFAULT NULL,
  `TYPE_` char(1) DEFAULT NULL,
  `GRAPHELEMENT_` decimal(19,0) DEFAULT NULL,
  `PROCESSDEFINITION_` decimal(19,0) DEFAULT NULL,
  `NODE_` decimal(19,0) DEFAULT NULL,
  `TRANSITION_` decimal(19,0) DEFAULT NULL,
  `TASK_` decimal(19,0) DEFAULT NULL,
  PRIMARY KEY (`ID_`),
  KEY `FK_EVENT_NODE` (`NODE_`),
  KEY `FK_EVENT_PROCDEF` (`PROCESSDEFINITION_`),
  KEY `FK_EVENT_TASK` (`TASK_`),
  KEY `FK_EVENT_TRANS` (`TRANSITION_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `JBPM_EVENT`
--


--
-- Table structure for table `JBPM_EXCEPTIONHANDLER`
--

CREATE TABLE `JBPM_EXCEPTIONHANDLER` (
  `ID_` bigint NOT NULL AUTO_INCREMENT,
  `EXCEPTIONCLASSNAME_` text,
  `TYPE_` char(1) DEFAULT NULL,
  `GRAPHELEMENT_` decimal(19,0) DEFAULT NULL,
  `PROCESSDEFINITION_` decimal(19,0) DEFAULT NULL,
  `GRAPHELEMENTINDEX_` int DEFAULT NULL,
  `NODE_` decimal(19,0) DEFAULT NULL,
  `TRANSITION_` decimal(19,0) DEFAULT NULL,
  `TASK_` decimal(19,0) DEFAULT NULL,
  PRIMARY KEY (`ID_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `JBPM_EXCEPTIONHANDLER`
--


--
-- Table structure for table `JBPM_JOB`
--

CREATE TABLE `JBPM_JOB` (
  `ID_` bigint NOT NULL AUTO_INCREMENT,
  `CLASS_` char(1) NOT NULL,
  `VERSION_` int NOT NULL,
  `DUEDATE_` datetime DEFAULT NULL,
  `PROCESSINSTANCE_` decimal(19,0) DEFAULT NULL,
  `TOKEN_` decimal(19,0) DEFAULT NULL,
  `TASKINSTANCE_` decimal(19,0) DEFAULT NULL,
  `ISSUSPENDED_` tinyint DEFAULT NULL,
  `ISEXCLUSIVE_` tinyint DEFAULT NULL,
  `LOCKOWNER_` varchar(255) DEFAULT NULL,
  `LOCKTIME_` datetime DEFAULT NULL,
  `EXCEPTION_` text,
  `RETRIES_` int DEFAULT NULL,
  `NAME_` varchar(255) DEFAULT NULL,
  `REPEAT_` varchar(255) DEFAULT NULL,
  `TRANSITIONNAME_` varchar(255) DEFAULT NULL,
  `ACTION_` decimal(19,0) DEFAULT NULL,
  `GRAPHELEMENTTYPE_` varchar(255) DEFAULT NULL,
  `GRAPHELEMENT_` decimal(19,0) DEFAULT NULL,
  `NODE_` decimal(19,0) DEFAULT NULL,
  PRIMARY KEY (`ID_`),
  KEY `FK_JOB_ACTION` (`ACTION_`),
  KEY `FK_JOB_NODE` (`NODE_`),
  KEY `FK_JOB_PRINST` (`PROCESSINSTANCE_`),
  KEY `FK_JOB_TOKEN` (`TOKEN_`),
  KEY `FK_JOB_TSKINST` (`TASKINSTANCE_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `JBPM_JOB`
--


--
-- Table structure for table `JBPM_LOG`
--

CREATE TABLE `JBPM_LOG` (
  `ID_` bigint NOT NULL AUTO_INCREMENT,
  `CLASS_` char(1) NOT NULL,
  `INDEX_` int DEFAULT NULL,
  `DATE_` datetime DEFAULT NULL,
  `TOKEN_` decimal(19,0) DEFAULT NULL,
  `PARENT_` decimal(19,0) DEFAULT NULL,
  `MESSAGE_` text,
  `EXCEPTION_` text,
  `ACTION_` decimal(19,0) DEFAULT NULL,
  `NODE_` decimal(19,0) DEFAULT NULL,
  `ENTER_` datetime DEFAULT NULL,
  `LEAVE_` datetime DEFAULT NULL,
  `DURATION_` decimal(19,0) DEFAULT NULL,
  `NEWLONGVALUE_` decimal(19,0) DEFAULT NULL,
  `TRANSITION_` decimal(19,0) DEFAULT NULL,
  `CHILD_` decimal(19,0) DEFAULT NULL,
  `SOURCENODE_` decimal(19,0) DEFAULT NULL,
  `DESTINATIONNODE_` decimal(19,0) DEFAULT NULL,
  `VARIABLEINSTANCE_` decimal(19,0) DEFAULT NULL,
  `OLDBYTEARRAY_` decimal(19,0) DEFAULT NULL,
  `NEWBYTEARRAY_` decimal(19,0) DEFAULT NULL,
  `OLDDATEVALUE_` datetime DEFAULT NULL,
  `NEWDATEVALUE_` datetime DEFAULT NULL,
  `OLDDOUBLEVALUE_` double DEFAULT NULL,
  `NEWDOUBLEVALUE_` double DEFAULT NULL,
  `OLDLONGIDCLASS_` varchar(255) DEFAULT NULL,
  `OLDLONGIDVALUE_` decimal(19,0) DEFAULT NULL,
  `NEWLONGIDCLASS_` varchar(255) DEFAULT NULL,
  `NEWLONGIDVALUE_` decimal(19,0) DEFAULT NULL,
  `OLDSTRINGIDCLASS_` varchar(255) DEFAULT NULL,
  `OLDSTRINGIDVALUE_` varchar(255) DEFAULT NULL,
  `NEWSTRINGIDCLASS_` varchar(255) DEFAULT NULL,
  `NEWSTRINGIDVALUE_` varchar(255) DEFAULT NULL,
  `OLDLONGVALUE_` decimal(19,0) DEFAULT NULL,
  `OLDSTRINGVALUE_` text,
  `NEWSTRINGVALUE_` text,
  `TASKINSTANCE_` decimal(19,0) DEFAULT NULL,
  `TASKACTORID_` varchar(255) DEFAULT NULL,
  `TASKOLDACTORID_` varchar(255) DEFAULT NULL,
  `SWIMLANEINSTANCE_` decimal(19,0) DEFAULT NULL,
  PRIMARY KEY (`ID_`),
  KEY `FK_LOG_ACTION` (`ACTION_`),
  KEY `FK_LOG_CHILDTOKEN` (`CHILD_`),
  KEY `FK_LOG_DESTNODE` (`DESTINATIONNODE_`),
  KEY `FK_LOG_NEWBYTES` (`NEWBYTEARRAY_`),
  KEY `FK_LOG_NODE` (`NODE_`),
  KEY `FK_LOG_OLDBYTES` (`OLDBYTEARRAY_`),
  KEY `FK_LOG_PARENT` (`PARENT_`),
  KEY `FK_LOG_SOURCENODE` (`SOURCENODE_`),
  KEY `FK_LOG_SWIMINST` (`SWIMLANEINSTANCE_`),
  KEY `FK_LOG_TASKINST` (`TASKINSTANCE_`),
  KEY `FK_LOG_TOKEN` (`TOKEN_`),
  KEY `FK_LOG_TRANSITION` (`TRANSITION_`),
  KEY `FK_LOG_VARINST` (`VARIABLEINSTANCE_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `JBPM_LOG`
--


--
-- Table structure for table `JBPM_MODULEDEFINITION`
--

CREATE TABLE `JBPM_MODULEDEFINITION` (
  `ID_` bigint NOT NULL AUTO_INCREMENT,
  `CLASS_` char(1) NOT NULL,
  `NAME_` varchar(255) DEFAULT NULL,
  `PROCESSDEFINITION_` decimal(19,0) DEFAULT NULL,
  `STARTTASK_` decimal(19,0) DEFAULT NULL,
  PRIMARY KEY (`ID_`),
  KEY `FK_MODDEF_PROCDEF` (`PROCESSDEFINITION_`),
  KEY `FK_TSKDEF_START` (`STARTTASK_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `JBPM_MODULEDEFINITION`
--


--
-- Table structure for table `JBPM_MODULEINSTANCE`
--

CREATE TABLE `JBPM_MODULEINSTANCE` (
  `ID_` bigint NOT NULL AUTO_INCREMENT,
  `CLASS_` char(1) NOT NULL,
  `VERSION_` int NOT NULL,
  `PROCESSINSTANCE_` decimal(19,0) DEFAULT NULL,
  `TASKMGMTDEFINITION_` decimal(19,0) DEFAULT NULL,
  `NAME_` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`ID_`),
  KEY `FK_MODINST_PRCINST` (`PROCESSINSTANCE_`),
  KEY `FK_TASKMGTINST_TMD` (`TASKMGMTDEFINITION_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `JBPM_MODULEINSTANCE`
--


--
-- Table structure for table `JBPM_NODE`
--

CREATE TABLE `JBPM_NODE` (
  `ID_` bigint NOT NULL AUTO_INCREMENT,
  `CLASS_` char(1) NOT NULL,
  `NAME_` varchar(255) DEFAULT NULL,
  `DESCRIPTION_` text,
  `PROCESSDEFINITION_` decimal(19,0) DEFAULT NULL,
  `ISASYNC_` tinyint DEFAULT NULL,
  `ISASYNCEXCL_` tinyint DEFAULT NULL,
  `ACTION_` decimal(19,0) DEFAULT NULL,
  `SUPERSTATE_` decimal(19,0) DEFAULT NULL,
  `SUBPROCNAME_` varchar(255) DEFAULT NULL,
  `SUBPROCESSDEFINITION_` decimal(19,0) DEFAULT NULL,
  `DECISIONEXPRESSION_` varchar(255) DEFAULT NULL,
  `DECISIONDELEGATION` decimal(19,0) DEFAULT NULL,
  `SCRIPT_` decimal(19,0) DEFAULT NULL,
  `PARENTLOCKMODE_` varchar(255) DEFAULT NULL,
  `SIGNAL_` int DEFAULT NULL,
  `CREATETASKS_` tinyint DEFAULT NULL,
  `ENDTASKS_` tinyint DEFAULT NULL,
  `NODECOLLECTIONINDEX_` int DEFAULT NULL,
  PRIMARY KEY (`ID_`),
  KEY `FK_DECISION_DELEG` (`DECISIONDELEGATION`),
  KEY `FK_NODE_ACTION` (`ACTION_`),
  KEY `FK_NODE_PROCDEF` (`PROCESSDEFINITION_`),
  KEY `FK_NODE_SCRIPT` (`SCRIPT_`),
  KEY `FK_NODE_SUPERSTATE` (`SUPERSTATE_`),
  KEY `FK_PROCST_SBPRCDEF` (`SUBPROCESSDEFINITION_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `JBPM_NODE`
--


--
-- Table structure for table `JBPM_POOLEDACTOR`
--

CREATE TABLE `JBPM_POOLEDACTOR` (
  `ID_` bigint NOT NULL AUTO_INCREMENT,
  `VERSION_` int NOT NULL,
  `ACTORID_` varchar(255) DEFAULT NULL,
  `SWIMLANEINSTANCE_` decimal(19,0) DEFAULT NULL,
  PRIMARY KEY (`ID_`),
  KEY `FK_POOLEDACTOR_SLI` (`SWIMLANEINSTANCE_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `JBPM_POOLEDACTOR`
--


--
-- Table structure for table `JBPM_PROCESSDEFINITION`
--

CREATE TABLE `JBPM_PROCESSDEFINITION` (
  `ID_` bigint NOT NULL AUTO_INCREMENT,
  `CLASS_` char(1) NOT NULL,
  `NAME_` varchar(255) DEFAULT NULL,
  `DESCRIPTION_` text,
  `VERSION_` int DEFAULT NULL,
  `ISTERMINATIONIMPLICIT_` tinyint DEFAULT NULL,
  `STARTSTATE_` decimal(19,0) DEFAULT NULL,
  PRIMARY KEY (`ID_`),
  KEY `FK_PROCDEF_STRTSTA` (`STARTSTATE_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `JBPM_PROCESSDEFINITION`
--


--
-- Table structure for table `JBPM_PROCESSINSTANCE`
--

CREATE TABLE `JBPM_PROCESSINSTANCE` (
  `ID_` bigint NOT NULL AUTO_INCREMENT,
  `VERSION_` int NOT NULL,
  `KEY_` varchar(255) DEFAULT NULL,
  `START_` datetime DEFAULT NULL,
  `END_` datetime DEFAULT NULL,
  `ISSUSPENDED_` tinyint DEFAULT NULL,
  `PROCESSDEFINITION_` decimal(19,0) DEFAULT NULL,
  `ROOTTOKEN_` decimal(19,0) DEFAULT NULL,
  `SUPERPROCESSTOKEN_` decimal(19,0) DEFAULT NULL,
  PRIMARY KEY (`ID_`),
  KEY `FK_PROCIN_PROCDEF` (`PROCESSDEFINITION_`),
  KEY `FK_PROCIN_ROOTTKN` (`ROOTTOKEN_`),
  KEY `FK_PROCIN_SPROCTKN` (`SUPERPROCESSTOKEN_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `JBPM_PROCESSINSTANCE`
--


--
-- Table structure for table `JBPM_RUNTIMEACTION`
--

CREATE TABLE `JBPM_RUNTIMEACTION` (
  `ID_` bigint NOT NULL AUTO_INCREMENT,
  `VERSION_` int NOT NULL,
  `EVENTTYPE_` varchar(255) DEFAULT NULL,
  `TYPE_` char(1) DEFAULT NULL,
  `GRAPHELEMENT_` decimal(19,0) DEFAULT NULL,
  `PROCESSINSTANCE_` decimal(19,0) DEFAULT NULL,
  `ACTION_` decimal(19,0) DEFAULT NULL,
  `PROCESSINSTANCEINDEX_` int DEFAULT NULL,
  PRIMARY KEY (`ID_`),
  KEY `FK_RTACTN_ACTION` (`ACTION_`),
  KEY `FK_RTACTN_PROCINST` (`PROCESSINSTANCE_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `JBPM_RUNTIMEACTION`
--


--
-- Table structure for table `JBPM_SWIMLANE`
--

CREATE TABLE `JBPM_SWIMLANE` (
  `ID_` bigint NOT NULL AUTO_INCREMENT,
  `NAME_` varchar(255) DEFAULT NULL,
  `ACTORIDEXPRESSION_` varchar(255) DEFAULT NULL,
  `POOLEDACTORSEXPRESSION_` varchar(255) DEFAULT NULL,
  `ASSIGNMENTDELEGATION_` decimal(19,0) DEFAULT NULL,
  `TASKMGMTDEFINITION_` decimal(19,0) DEFAULT NULL,
  PRIMARY KEY (`ID_`),
  KEY `FK_SWL_ASSDEL` (`ASSIGNMENTDELEGATION_`),
  KEY `FK_SWL_TSKMGMTDEF` (`TASKMGMTDEFINITION_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `JBPM_SWIMLANE`
--


--
-- Table structure for table `JBPM_SWIMLANEINSTANCE`
--

CREATE TABLE `JBPM_SWIMLANEINSTANCE` (
  `ID_` bigint NOT NULL AUTO_INCREMENT,
  `VERSION_` int NOT NULL,
  `NAME_` varchar(255) DEFAULT NULL,
  `ACTORID_` varchar(255) DEFAULT NULL,
  `SWIMLANE_` decimal(19,0) DEFAULT NULL,
  `TASKMGMTINSTANCE_` decimal(19,0) DEFAULT NULL,
  PRIMARY KEY (`ID_`),
  KEY `FK_SWIMLANEINST_SL` (`SWIMLANE_`),
  KEY `FK_SWIMLANEINST_TM` (`TASKMGMTINSTANCE_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `JBPM_SWIMLANEINSTANCE`
--


--
-- Table structure for table `JBPM_TASK`
--

CREATE TABLE `JBPM_TASK` (
  `ID_` bigint NOT NULL AUTO_INCREMENT,
  `NAME_` varchar(255) DEFAULT NULL,
  `DESCRIPTION_` text,
  `PROCESSDEFINITION_` decimal(19,0) DEFAULT NULL,
  `ISBLOCKING_` tinyint DEFAULT NULL,
  `ISSIGNALLING_` tinyint DEFAULT NULL,
  `CONDITION_` varchar(255) DEFAULT NULL,
  `DUEDATE_` varchar(255) DEFAULT NULL,
  `PRIORITY_` int DEFAULT NULL,
  `ACTORIDEXPRESSION_` varchar(255) DEFAULT NULL,
  `POOLEDACTORSEXPRESSION_` varchar(255) DEFAULT NULL,
  `TASKMGMTDEFINITION_` decimal(19,0) DEFAULT NULL,
  `TASKNODE_` decimal(19,0) DEFAULT NULL,
  `STARTSTATE_` decimal(19,0) DEFAULT NULL,
  `ASSIGNMENTDELEGATION_` decimal(19,0) DEFAULT NULL,
  `SWIMLANE_` decimal(19,0) DEFAULT NULL,
  `TASKCONTROLLER_` decimal(19,0) DEFAULT NULL,
  PRIMARY KEY (`ID_`),
  KEY `FK_TASK_ASSDEL` (`ASSIGNMENTDELEGATION_`),
  KEY `FK_TASK_PROCDEF` (`PROCESSDEFINITION_`),
  KEY `FK_TASK_STARTST` (`STARTSTATE_`),
  KEY `FK_TASK_SWIMLANE` (`SWIMLANE_`),
  KEY `FK_TASK_TASKMGTDEF` (`TASKMGMTDEFINITION_`),
  KEY `FK_TASK_TASKNODE` (`TASKNODE_`),
  KEY `FK_TSK_TSKCTRL` (`TASKCONTROLLER_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `JBPM_TASK`
--


--
-- Table structure for table `JBPM_TASKACTORPOOL`
--

CREATE TABLE `JBPM_TASKACTORPOOL` (
  `TASKINSTANCE_` decimal(19,0) NOT NULL,
  `POOLEDACTOR_` decimal(19,0) NOT NULL,
  PRIMARY KEY (`TASKINSTANCE_`,`POOLEDACTOR_`),
  KEY `FK_TASKACTPL_TSKI` (`TASKINSTANCE_`),
  KEY `FK_TSKACTPOL_PLACT` (`POOLEDACTOR_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `JBPM_TASKACTORPOOL`
--


--
-- Table structure for table `JBPM_TASKCONTROLLER`
--

CREATE TABLE `JBPM_TASKCONTROLLER` (
  `ID_` bigint NOT NULL AUTO_INCREMENT,
  `TASKCONTROLLERDELEGATION_` decimal(19,0) DEFAULT NULL,
  PRIMARY KEY (`ID_`),
  KEY `FK_TSKCTRL_DELEG` (`TASKCONTROLLERDELEGATION_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `JBPM_TASKCONTROLLER`
--


--
-- Table structure for table `JBPM_TOKEN`
--

CREATE TABLE `JBPM_TOKEN` (
  `ID_` bigint NOT NULL AUTO_INCREMENT,
  `VERSION_` int NOT NULL,
  `NAME_` varchar(255) DEFAULT NULL,
  `START_` datetime DEFAULT NULL,
  `END_` datetime DEFAULT NULL,
  `NODEENTER_` datetime DEFAULT NULL,
  `NEXTLOGINDEX_` int DEFAULT NULL,
  `ISABLETOREACTIVATEPARENT_` tinyint DEFAULT NULL,
  `ISTERMINATIONIMPLICIT_` tinyint DEFAULT NULL,
  `ISSUSPENDED_` tinyint DEFAULT NULL,
  `LOCK_` varchar(255) DEFAULT NULL,
  `NODE_` decimal(19,0) DEFAULT NULL,
  `PROCESSINSTANCE_` decimal(19,0) DEFAULT NULL,
  `PARENT_` decimal(19,0) DEFAULT NULL,
  `SUBPROCESSINSTANCE_` decimal(19,0) DEFAULT NULL,
  PRIMARY KEY (`ID_`),
  KEY `FK_TOKEN_NODE` (`NODE_`),
  KEY `FK_TOKEN_PARENT` (`PARENT_`),
  KEY `FK_TOKEN_PROCINST` (`PROCESSINSTANCE_`),
  KEY `FK_TOKEN_SUBPI` (`SUBPROCESSINSTANCE_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `JBPM_TOKEN`
--


--
-- Table structure for table `JBPM_TOKENVARIABLEMAP`
--

CREATE TABLE `JBPM_TOKENVARIABLEMAP` (
  `ID_` bigint NOT NULL AUTO_INCREMENT,
  `VERSION_` int NOT NULL,
  `TOKEN_` decimal(19,0) DEFAULT NULL,
  `CONTEXTINSTANCE_` decimal(19,0) DEFAULT NULL,
  PRIMARY KEY (`ID_`),
  KEY `FK_TKVARMAP_CTXT` (`CONTEXTINSTANCE_`),
  KEY `FK_TKVARMAP_TOKEN` (`TOKEN_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `JBPM_TOKENVARIABLEMAP`
--


--
-- Table structure for table `JBPM_TRANSITION`
--

CREATE TABLE `JBPM_TRANSITION` (
  `ID_` bigint NOT NULL AUTO_INCREMENT,
  `NAME_` varchar(255) DEFAULT NULL,
  `DESCRIPTION_` text,
  `PROCESSDEFINITION_` decimal(19,0) DEFAULT NULL,
  `FROM_` decimal(19,0) DEFAULT NULL,
  `TO_` decimal(19,0) DEFAULT NULL,
  `CONDITION_` varchar(255) DEFAULT NULL,
  `FROMINDEX_` int DEFAULT NULL,
  PRIMARY KEY (`ID_`),
  KEY `FK_TRANS_PROCDEF` (`PROCESSDEFINITION_`),
  KEY `FK_TRANSITION_FROM` (`FROM_`),
  KEY `FK_TRANSITION_TO` (`TO_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `JBPM_TRANSITION`
--


--
-- Table structure for table `JBPM_VARIABLEACCESS`
--

CREATE TABLE `JBPM_VARIABLEACCESS` (
  `ID_` bigint NOT NULL AUTO_INCREMENT,
  `VARIABLENAME_` varchar(255) DEFAULT NULL,
  `ACCESS_` varchar(255) DEFAULT NULL,
  `MAPPEDNAME_` varchar(255) DEFAULT NULL,
  `PROCESSSTATE_` decimal(19,0) DEFAULT NULL,
  `TASKCONTROLLER_` decimal(19,0) DEFAULT NULL,
  `INDEX_` int DEFAULT NULL,
  `SCRIPT_` decimal(19,0) DEFAULT NULL,
  PRIMARY KEY (`ID_`),
  KEY `FK_VARACC_PROCST` (`PROCESSSTATE_`),
  KEY `FK_VARACC_SCRIPT` (`SCRIPT_`),
  KEY `FK_VARACC_TSKCTRL` (`TASKCONTROLLER_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `JBPM_VARIABLEACCESS`
--


--
-- Table structure for table `JBPM_VARIABLEINSTANCE`
--

CREATE TABLE `JBPM_VARIABLEINSTANCE` (
  `ID_` bigint NOT NULL AUTO_INCREMENT,
  `CLASS_` char(1) NOT NULL,
  `VERSION_` int NOT NULL,
  `NAME_` varchar(255) DEFAULT NULL,
  `CONVERTER_` char(1) DEFAULT NULL,
  `TOKEN_` decimal(19,0) DEFAULT NULL,
  `TOKENVARIABLEMAP_` decimal(19,0) DEFAULT NULL,
  `PROCESSINSTANCE_` decimal(19,0) DEFAULT NULL,
  `BYTEARRAYVALUE_` decimal(19,0) DEFAULT NULL,
  `DATEVALUE_` datetime DEFAULT NULL,
  `DOUBLEVALUE_` double DEFAULT NULL,
  `LONGIDCLASS_` varchar(255) DEFAULT NULL,
  `LONGVALUE_` decimal(19,0) DEFAULT NULL,
  `STRINGIDCLASS_` varchar(255) DEFAULT NULL,
  `STRINGVALUE_` varchar(255) DEFAULT NULL,
  `TASKINSTANCE_` decimal(19,0) DEFAULT NULL,
  PRIMARY KEY (`ID_`),
  KEY `FK_BYTEINST_ARRAY` (`BYTEARRAYVALUE_`),
  KEY `FK_VAR_TSKINST` (`TASKINSTANCE_`),
  KEY `FK_VARINST_PRCINST` (`PROCESSINSTANCE_`),
  KEY `FK_VARINST_TK` (`TOKEN_`),
  KEY `FK_VARINST_TKVARMP` (`TOKENVARIABLEMAP_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `JBPM_VARIABLEINSTANCE`
--


--
-- Table structure for table `JMS_MESSAGES`
--

CREATE TABLE `JMS_MESSAGES` (
  `MESSAGEID` int NOT NULL,
  `DESTINATION` varchar(1024) NOT NULL,
  `TXID` int DEFAULT NULL,
  `TXOP` char(1) DEFAULT NULL,
  `MESSAGEBLOB` longblob,
  KEY `JMS_MESSAGES_TXOP_TXID` (`TXOP`,`TXID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `JMS_MESSAGES`
--


--
-- Table structure for table `JMS_ROLES`
--

CREATE TABLE `JMS_ROLES` (
  `ROLEID` varchar(32) NOT NULL,
  `USERID` varchar(32) NOT NULL,
  PRIMARY KEY (`USERID`,`ROLEID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `JMS_ROLES`
--


--
-- Table structure for table `JMS_SUBSCRIPTIONS`
--

CREATE TABLE `JMS_SUBSCRIPTIONS` (
  `CLIENTID` varchar(128) NOT NULL,
  `SUBNAME` varchar(128) NOT NULL,
  `TOPIC` varchar(255) NOT NULL,
  `SELECTOR` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`CLIENTID`,`SUBNAME`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `JMS_SUBSCRIPTIONS`
--


--
-- Table structure for table `JMS_TRANSACTIONS`
--

CREATE TABLE `JMS_TRANSACTIONS` (
  `TXID` int NOT NULL,
  PRIMARY KEY (`TXID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `JMS_TRANSACTIONS`
--


--
-- Table structure for table `JMS_USERS`
--

CREATE TABLE `JMS_USERS` (
  `USERID` varchar(32) NOT NULL,
  `PASSWD` varchar(32) NOT NULL,
  `CLIENTID` varchar(128) DEFAULT NULL,
  PRIMARY KEY (`USERID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `JMS_USERS`
--


--
-- Table structure for table `landing_contact`
--

CREATE TABLE `landing_contact` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `phone` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `landing_contact`
--

INSERT INTO `landing_contact` VALUES (1,'4141930904','josephdilas@gmail.com','Behind NMDC, Rock haven Jos','2026-02-27 21:43:59','2026-02-28 21:41:43');

--
-- Table structure for table `landing_hero`
--

CREATE TABLE `landing_hero` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(500) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `subtitle` varchar(500) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `banner_text` varchar(1000) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `background_image_url` varchar(1000) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `landing_hero`
--

INSERT INTO `landing_hero` VALUES (1,'Boundary Commission Digital Archive','We are ready to serve. Managing boundaries and disputes with clarity.','Welcome to the Boundary Commission – your source for boundary and land dispute information.',NULL,'2026-02-27 21:43:59','2026-02-27 21:43:59');

--
-- Table structure for table `landing_service_cards`
--

CREATE TABLE `landing_service_cards` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text COLLATE utf8mb4_unicode_ci,
  `link_url` varchar(500) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sort_order` int NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `landing_service_cards`
--


--
-- Table structure for table `landing_services_block`
--

CREATE TABLE `landing_services_block` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `body_text` text COLLATE utf8mb4_unicode_ci,
  `image_url` varchar(1000) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `button_1_label` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `button_1_url` varchar(500) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `button_2_label` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `button_2_url` varchar(500) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `button_3_label` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `button_3_url` varchar(500) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `landing_services_block`
--

INSERT INTO `landing_services_block` VALUES (1,'Boundary Commission Services','Access boundary records, dispute information, surveys, and treaties. Our services cover interstate and administrative boundaries.',NULL,'Search Boundaries','/dashboard?section=boundary','View Disputes','/dashboard?section=dispute','Documentation','/dashboard?section=overview','2026-02-27 21:43:59','2026-02-27 21:43:59');

--
-- Table structure for table `landing_stats`
--

CREATE TABLE `landing_stats` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `label` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `value` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `sort_order` int NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `landing_stats`
--


--
-- Table structure for table `login_panel`
--

CREATE TABLE `login_panel` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Boundary Commission',
  `title_highlight` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Word in title to highlight (e.g. Everywhere)',
  `description` text COLLATE utf8mb4_unicode_ci,
  `central_image_url` varchar(1000) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `background_color` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT '#eff6ff',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `login_panel`
--

INSERT INTO `login_panel` VALUES (1,'Access Everywhere','Everywhere','Compatible with **dashboard**, **boundary search**, and **document management** for a smooth experience.',NULL,'#eff6ff','2026-02-28 22:16:00','2026-02-28 22:16:00');

--
-- Table structure for table `lr_address`
--

CREATE TABLE `lr_address` (
  `id` decimal(19,0) NOT NULL,
  `Hjtype` varchar(255) NOT NULL,
  `address_area_name` varchar(250) DEFAULT NULL,
  `street_number` varchar(50) DEFAULT NULL,
  `street_name` varchar(100) DEFAULT NULL,
  `building_name` varchar(50) DEFAULT NULL,
  `building_number` int DEFAULT NULL,
  `layout_name` decimal(19,0) DEFAULT NULL,
  `postal_code` varchar(10) DEFAULT NULL,
  `city` varchar(100) DEFAULT NULL,
  `ward` varchar(100) DEFAULT NULL,
  `cell` varchar(100) DEFAULT NULL,
  `local_government_area` decimal(19,0) DEFAULT NULL,
  `country` decimal(19,0) NOT NULL,
  `region` decimal(19,0) NOT NULL,
  `origin_region` decimal(19,0) DEFAULT NULL,
  `district` decimal(19,0) NOT NULL,
  `cadregion` decimal(19,0) NOT NULL,
  `subdistrict` decimal(19,0) NOT NULL,
  `subcounty` varchar(30) DEFAULT NULL,
  `address_line1` varchar(50) DEFAULT NULL,
  `address_line2` varchar(100) DEFAULT NULL,
  `address_line3` varchar(100) DEFAULT NULL,
  `district_text` varchar(100) DEFAULT NULL,
  `version` decimal(19,0) DEFAULT NULL,
  `begin_lifespan_version` datetime DEFAULT NULL,
  `end_lifespan_version` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `lr_address_city_idx` (`city`),
  KEY `lr_address_district_idx` (`district`),
  KEY `lr_address_region_idx` (`region`),
  KEY `lr_address_street_name_idx` (`street_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `lr_address`
--


--
-- Table structure for table `lr_admin_document_party`
--

CREATE TABLE `lr_admin_document_party` (
  `document` decimal(19,0) NOT NULL,
  `party` decimal(19,0) NOT NULL,
  `party_index` int NOT NULL,
  PRIMARY KEY (`document`,`party_index`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `lr_admin_document_party`
--


--
-- Table structure for table `lr_admin_document_rrr`
--

CREATE TABLE `lr_admin_document_rrr` (
  `document` decimal(19,0) NOT NULL,
  `rrr` decimal(19,0) NOT NULL,
  `rrr_index` int NOT NULL,
  PRIMARY KEY (`document`,`rrr_index`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `lr_admin_document_rrr`
--


--
-- Table structure for table `lr_admin_source_document`
--

CREATE TABLE `lr_admin_source_document` (
  `id` decimal(19,0) NOT NULL,
  `purchase_price` double DEFAULT NULL,
  `memo_text` varchar(2500) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `lr_admin_source_document`
--


--
-- Table structure for table `lr_applicant`
--

CREATE TABLE `lr_applicant` (
  `id` decimal(19,0) NOT NULL,
  `application_type` decimal(19,0) NOT NULL,
  `delivery_type` decimal(19,0) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `lr_applicant`
--


--
-- Table structure for table `lr_batch`
--

CREATE TABLE `lr_batch` (
  `id` decimal(19,0) NOT NULL,
  `Hjtype` varchar(255) NOT NULL,
  `batch_number` varchar(50) DEFAULT NULL,
  `application_status` decimal(19,0) NOT NULL,
  `invoice_number` varchar(150) DEFAULT NULL,
  `create_date` datetime DEFAULT NULL,
  `delivery_date` datetime DEFAULT NULL,
  `office` decimal(19,0) DEFAULT NULL,
  `comments` varchar(800) DEFAULT NULL,
  `decision` varchar(100) DEFAULT NULL,
  `decision_date` datetime DEFAULT NULL,
  `decision_number` varchar(50) DEFAULT NULL,
  `attachments` varchar(255) DEFAULT NULL,
  `registrar` varchar(50) DEFAULT NULL,
  `registration_date` datetime DEFAULT NULL,
  `version` decimal(19,0) DEFAULT NULL,
  `begin_lifespan_version` datetime DEFAULT NULL,
  `end_lifespan_version` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `lr_batch_batch_status_idx` (`application_status`),
  KEY `lr_batch_office_idx` (`office`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `lr_batch`
--


--
-- Table structure for table `lr_batch_party`
--

CREATE TABLE `lr_batch_party` (
  `batch` decimal(19,0) NOT NULL,
  `party` decimal(19,0) NOT NULL,
  `party_index` int NOT NULL,
  PRIMARY KEY (`batch`,`party_index`),
  KEY `lr_batch_party__idx` (`batch`,`party`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `lr_batch_party`
--


--
-- Table structure for table `lr_batch_related`
--

CREATE TABLE `lr_batch_related` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `Hjtype` varchar(255) NOT NULL,
  `parent_id` decimal(19,0) NOT NULL,
  `child_id` decimal(19,0) NOT NULL,
  `process_id` decimal(19,0) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `lr_batch_related`
--


--
-- Table structure for table `lr_billing`
--

CREATE TABLE `lr_billing` (
  `id` decimal(19,0) NOT NULL,
  `Hjtype` varchar(255) NOT NULL,
  `invoice_number` varchar(50) DEFAULT NULL,
  `total_amount` double DEFAULT NULL,
  `status` decimal(19,0) NOT NULL,
  `invoice_type` decimal(19,0) NOT NULL,
  `wires_trx_id` decimal(19,0) DEFAULT NULL,
  `wrx_date_submitted` datetime DEFAULT NULL,
  `wrx_date_accepted` datetime DEFAULT NULL,
  `due_date` datetime DEFAULT NULL,
  `party` decimal(19,0) DEFAULT NULL,
  `party_contact` decimal(19,0) DEFAULT NULL,
  `ref_number` varchar(50) DEFAULT NULL,
  `description` varchar(800) DEFAULT NULL,
  `comments` varchar(800) DEFAULT NULL,
  `submitted_by` varchar(50) DEFAULT NULL,
  `bil1` varchar(50) DEFAULT NULL,
  `bil2` varchar(50) DEFAULT NULL,
  `bil_dict1` decimal(19,0) NOT NULL,
  `bil_dict2` decimal(19,0) NOT NULL,
  `version` decimal(19,0) DEFAULT NULL,
  `begin_lifespan_version` datetime DEFAULT NULL,
  `end_lifespan_version` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `lr_billing`
--


--
-- Table structure for table `lr_billing_dist_line`
--

CREATE TABLE `lr_billing_dist_line` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `Hjtype` varchar(255) NOT NULL,
  `trans_code` varchar(50) DEFAULT NULL,
  `amount` double DEFAULT NULL,
  `flex_field_1` varchar(250) DEFAULT NULL,
  `flex_field_2` varchar(250) DEFAULT NULL,
  `flex_field_3` varchar(250) DEFAULT NULL,
  `flex_field_4` varchar(250) DEFAULT NULL,
  `flex_field_5` varchar(250) DEFAULT NULL,
  `wires_dist_line_id` varchar(50) DEFAULT NULL,
  `version` decimal(19,0) DEFAULT NULL,
  `begin_lifespan_version` datetime DEFAULT NULL,
  `end_lifespan_version` datetime DEFAULT NULL,
  `line_id` decimal(19,0) DEFAULT NULL,
  `line_index` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `lr_billing_dist_line`
--


--
-- Table structure for table `lr_billing_line`
--

CREATE TABLE `lr_billing_line` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `Hjtype` varchar(255) NOT NULL,
  `line_type` varchar(50) DEFAULT NULL,
  `quantity` double DEFAULT NULL,
  `amount` double DEFAULT NULL,
  `total_amount` double DEFAULT NULL,
  `wires_line_id` varchar(50) DEFAULT NULL,
  `description` varchar(800) DEFAULT NULL,
  `version` decimal(19,0) DEFAULT NULL,
  `begin_lifespan_version` datetime DEFAULT NULL,
  `end_lifespan_version` datetime DEFAULT NULL,
  `bill_id` decimal(19,0) DEFAULT NULL,
  `bill_index` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `lr_billing_line`
--


--
-- Table structure for table `lr_building`
--

CREATE TABLE `lr_building` (
  `id` decimal(19,0) NOT NULL,
  `compl_number` varchar(30) DEFAULT NULL,
  `actual_use_type` decimal(19,0) NOT NULL,
  `number_of_units` int DEFAULT NULL,
  `number_of_floors` int DEFAULT NULL,
  `floor_area` double DEFAULT NULL,
  `floor_area_unit_type` decimal(19,0) NOT NULL,
  `internal_area` double DEFAULT NULL,
  `internal_area_unit_type` decimal(19,0) NOT NULL,
  `unit_factor` int DEFAULT NULL,
  `adjacents` varchar(500) DEFAULT NULL,
  `build_category` decimal(19,0) NOT NULL,
  `build_purpose` decimal(19,0) NOT NULL,
  `build_date1` datetime DEFAULT NULL,
  `build_date2` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `lr_building`
--


--
-- Table structure for table `lr_building_unit`
--

CREATE TABLE `lr_building_unit` (
  `id` decimal(19,0) NOT NULL,
  `unit_number` varchar(30) DEFAULT NULL,
  `building_number` varchar(30) DEFAULT NULL,
  `compl_number` varchar(30) DEFAULT NULL,
  `condo_plan` varchar(20) DEFAULT NULL,
  `use_type` decimal(19,0) NOT NULL,
  `bunit_type` decimal(19,0) DEFAULT NULL,
  `bunit_category` decimal(19,0) NOT NULL,
  `bunit_purpose` decimal(19,0) NOT NULL,
  `use_typespecificbld` varchar(50) DEFAULT NULL,
  `unit_factor` int DEFAULT NULL,
  `unit_type` decimal(19,0) NOT NULL,
  `number_of_units` int DEFAULT NULL,
  `number_of_floors` int DEFAULT NULL,
  `floor_type` decimal(19,0) NOT NULL,
  `floor_area` double DEFAULT NULL,
  `floor_area_unit_type` decimal(19,0) NOT NULL,
  `internal_area` double DEFAULT NULL,
  `internal_area_unit_type` decimal(19,0) NOT NULL,
  `adjacents` varchar(500) DEFAULT NULL,
  `bunit1` varchar(50) DEFAULT NULL,
  `bunit2` varchar(50) DEFAULT NULL,
  `bunit_dict1` decimal(19,0) NOT NULL,
  `bunit_dict2` decimal(19,0) NOT NULL,
  `bunit_date1` datetime DEFAULT NULL,
  `bunit_date2` datetime DEFAULT NULL,
  `bunit_count1` int DEFAULT NULL,
  `bunit_count2` int DEFAULT NULL,
  `plot_uid` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `lr_building_unit_use_type_idx` (`use_type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `lr_building_unit`
--


--
-- Table structure for table `lr_business_calendar`
--

CREATE TABLE `lr_business_calendar` (
  `Id` bigint NOT NULL AUTO_INCREMENT,
  `Hjtype` varchar(255) NOT NULL,
  `code` varchar(255) NOT NULL,
  `label` varchar(255) NOT NULL,
  `day_part` varchar(500) DEFAULT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `lr_business_calendar`
--


--
-- Table structure for table `lr_condition`
--

CREATE TABLE `lr_condition` (
  `id` decimal(19,0) NOT NULL,
  `Hjtype` varchar(255) NOT NULL,
  `condition_type` decimal(19,0) NOT NULL,
  `condition_seq` decimal(19,0) DEFAULT NULL,
  `condition_number` varchar(100) DEFAULT NULL,
  `cond_stage` varchar(150) DEFAULT NULL,
  `condition_text` varchar(1500) DEFAULT NULL,
  `original_text` varchar(1000) DEFAULT NULL,
  `custom_condition` tinyint DEFAULT NULL,
  `last_edited_by` varchar(255) DEFAULT NULL,
  `sign_by` varchar(100) DEFAULT NULL,
  `validated_by` varchar(100) DEFAULT NULL,
  `last_edited` datetime DEFAULT NULL,
  `received_date` datetime DEFAULT NULL,
  `validated_date` datetime DEFAULT NULL,
  `monitored` tinyint DEFAULT NULL,
  `cond_status` decimal(19,0) NOT NULL,
  `cond1` varchar(50) DEFAULT NULL,
  `cond2` varchar(50) DEFAULT NULL,
  `cond_dict1` decimal(19,0) NOT NULL,
  `cond_dict2` decimal(19,0) NOT NULL,
  `cond_count1` int DEFAULT NULL,
  `cond_count2` int DEFAULT NULL,
  `transaction_` decimal(19,0) DEFAULT NULL,
  `condition_index` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `lr_condition`
--


--
-- Table structure for table `lr_contact`
--

CREATE TABLE `lr_contact` (
  `id` decimal(19,0) NOT NULL,
  `contact_type` decimal(19,0) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `lr_contact_contact_type_idx` (`contact_type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `lr_contact`
--


--
-- Table structure for table `lr_corporation`
--

CREATE TABLE `lr_corporation` (
  `id` decimal(19,0) NOT NULL,
  `name` varchar(150) DEFAULT NULL,
  `represent_name` varchar(50) DEFAULT NULL,
  `gsm_number` varchar(50) DEFAULT NULL,
  `cac_number` varchar(50) DEFAULT NULL,
  `corp1` varchar(50) DEFAULT NULL,
  `corp2` varchar(50) DEFAULT NULL,
  `corp_dict1` decimal(19,0) NOT NULL,
  `corp_dict2` decimal(19,0) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `lr_corporation_name_idx` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `lr_corporation`
--


--
-- Table structure for table `lr_dictionary`
--

CREATE TABLE `lr_dictionary` (
  `Id` decimal(19,0) NOT NULL,
  `Hjtype` varchar(255) NOT NULL,
  `code` varchar(64) NOT NULL,
  `label` varchar(254) NOT NULL,
  `descr` varchar(1000) DEFAULT NULL,
  `category` varchar(64) NOT NULL,
  `general_term` tinyint DEFAULT NULL,
  `sort_order` int DEFAULT NULL,
  `hidden` tinyint DEFAULT NULL,
  `version` decimal(19,0) DEFAULT NULL,
  `begin_lifespan_version` datetime DEFAULT NULL,
  `end_lifespan_version` datetime DEFAULT NULL,
  `label_lang` varchar(254) DEFAULT NULL,
  `descr_lang` varchar(1000) DEFAULT NULL,
  `parentcode` varchar(64) DEFAULT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `lr_dictionary`
--

INSERT INTO `lr_dictionary` VALUES (1,'com.landsystems.lrs.model.Dictionary',' ',' ',NULL,'null',0,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(2,'com.landsystems.lrs.model.Dictionary','rep_created','Replica Package Created',NULL,'replica_status',0,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(3,'com.landsystems.lrs.model.Dictionary','rep_delivered','Replica Package Delivered',NULL,'replica_status',0,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(4,'com.landsystems.lrs.model.Dictionary','rep_replicated','Replica Package Replicated',NULL,'replica_status',0,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(5,'com.landsystems.lrs.model.Dictionary','rep_processed','Replica Package Processed',NULL,'replica_status',0,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(6,'com.landsystems.lrs.model.Dictionary','task-suspend','Workflow Task Suspended',NULL,'task_event',0,2,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(7,'com.landsystems.lrs.model.Dictionary','task-resume','Workflow Task Resumed',NULL,'task_event',0,3,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(8,'com.landsystems.lrs.model.Dictionary','task-comment','Workflow Task Commented',NULL,'task_event',0,4,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(9,'com.landsystems.lrs.model.Dictionary','task_event_public','Public',NULL,'task_event_access',0,1,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(10,'com.landsystems.lrs.model.Dictionary','task_event_private','Private',NULL,'task_event_access',0,2,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(11,'com.landsystems.lrs.model.Dictionary','overdue','Overdue Notice','Transaction {0} is overdue. Regisitration had to be completed before {1}.','event_type',1,1,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(12,'com.landsystems.lrs.model.Dictionary','expired','Expired Transaction','Please check in the transaction {0}. It is expired. The transaction was expired {1}.','event_type',1,2,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(13,'com.landsystems.lrs.model.Dictionary','lapsed','Lapsed Transaction','Please check in the transaction {0}. It is lapsed. The transaction was lapsed {1}.','event_type',1,3,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(14,'com.landsystems.lrs.model.Dictionary','canceled','Canceled Transaction','Please check in the transaction {0}. It is canceled.','event_type',1,4,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(15,'com.landsystems.lrs.model.Dictionary','assignment','Assignment Alert','Transaction {0} has been assigned to you for processing.','event_type',1,5,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(16,'com.landsystems.lrs.model.Dictionary','access_type_authorized_only','Authorized Only',NULL,'access_type',1,1,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(17,'com.landsystems.lrs.model.Dictionary','access_type_public_access','Public Access',NULL,'access_type',1,2,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(18,'com.landsystems.lrs.model.Dictionary','application_issued','Issued',NULL,'application_status',0,1,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(19,'com.landsystems.lrs.model.Dictionary','application_lodged','Lodged',NULL,'application_status',0,2,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(20,'com.landsystems.lrs.model.Dictionary','application_completed','Completed',NULL,'application_status',0,3,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(21,'com.landsystems.lrs.model.Dictionary','application_rejected','Rejected',NULL,'application_status',0,4,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(22,'com.landsystems.lrs.model.Dictionary','application_withdrawn','Withdrawn',NULL,'application_status',0,5,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(23,'com.landsystems.lrs.model.Dictionary','application_postponed','Postponed',NULL,'application_status',0,6,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(24,'com.landsystems.lrs.model.Dictionary','transaction_lodged','Active',NULL,'transaction_status',0,1,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(25,'com.landsystems.lrs.model.Dictionary','transaction_completed','Completed',NULL,'transaction_status',0,2,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(26,'com.landsystems.lrs.model.Dictionary','transaction_postponed','Postponed',NULL,'transaction_status',0,3,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(27,'com.landsystems.lrs.model.Dictionary','transaction_rejected','Rejected',NULL,'transaction_status',0,4,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(28,'com.landsystems.lrs.model.Dictionary','transaction_suspended','Suspended',NULL,'transaction_status',0,5,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(29,'com.landsystems.lrs.model.Dictionary','transaction_withdrawn','Withdrawn',NULL,'transaction_status',0,6,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(30,'com.landsystems.lrs.model.Dictionary','normal','Created as LRS Registration',NULL,'record_source',0,1,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(31,'com.landsystems.lrs.model.Dictionary','past','Created as Past',NULL,'record_source',0,2,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(32,'com.landsystems.lrs.model.Dictionary','supporting_scanned_document','Supporting Document',NULL,'scanned_objects',0,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(33,'com.landsystems.lrs.model.Dictionary','outgoing_scanned_document','Outgoing Document',NULL,'scanned_objects',0,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(34,'com.landsystems.lrs.model.Dictionary','delivery_type_in_person','In person',NULL,'delivery_type',1,1,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(35,'com.landsystems.lrs.model.Dictionary','delivery_type_mail_out','Mail Out',NULL,'delivery_type',1,2,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(36,'com.landsystems.lrs.model.Dictionary','process_started','Workflow Process Started',NULL,'process_status',0,1,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(37,'com.landsystems.lrs.model.Dictionary','process_canceled','Workflow Process Canceled',NULL,'process_status',0,2,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(38,'com.landsystems.lrs.model.Dictionary','process_finished','Workflow Process Finished',NULL,'process_status',0,3,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(39,'com.landsystems.lrs.model.Dictionary','male','Male',NULL,'gender',0,1,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(40,'com.landsystems.lrs.model.Dictionary','female','Female',NULL,'gender',0,2,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(41,'com.landsystems.lrs.model.Dictionary','tenure_type_state','State',NULL,'tenure_type',1,1,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(42,'com.landsystems.lrs.model.Dictionary','tenure_type_private','Private',NULL,'tenure_type',1,2,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(43,'com.landsystems.lrs.model.Dictionary','natural','Individual',NULL,'party_type',0,1,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(44,'com.landsystems.lrs.model.Dictionary','juridical','Organization',NULL,'party_type',0,2,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(45,'com.landsystems.lrs.model.Dictionary','party_state','Governor',NULL,'party_type',0,3,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(46,'com.landsystems.lrs.model.Dictionary','party_scan','Data Processing Unit',NULL,'party_type',0,4,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(47,'com.landsystems.lrs.model.Dictionary','representative','Representative',NULL,'party_type',0,5,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(48,'com.landsystems.lrs.model.Dictionary','party_role_type_allotter','Allotter',NULL,'party_role_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(49,'com.landsystems.lrs.model.Dictionary','party_role_type_allottee','Allottee',NULL,'party_role_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(50,'com.landsystems.lrs.model.Dictionary','party_role_type_grantor','Grantor',NULL,'party_role_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(51,'com.landsystems.lrs.model.Dictionary','party_role_type_grantee','Grantee',NULL,'party_role_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(52,'com.landsystems.lrs.model.Dictionary','party_role_type_mortgagor','Mortgagor',NULL,'party_role_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(53,'com.landsystems.lrs.model.Dictionary','party_role_type_mortgagee','Mortgagee',NULL,'party_role_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(54,'com.landsystems.lrs.model.Dictionary','party_role_type_caveator','Caveator',NULL,'party_role_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(55,'com.landsystems.lrs.model.Dictionary','party_role_type_lessor','Lessor',NULL,'party_role_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(56,'com.landsystems.lrs.model.Dictionary','party_role_type_lessee','Lessee',NULL,'party_role_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(57,'com.landsystems.lrs.model.Dictionary','party_role_type_complainant','Complainant',NULL,'party_role_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(58,'com.landsystems.lrs.model.Dictionary','party_role_type_assignor','Assignor',NULL,'party_role_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(59,'com.landsystems.lrs.model.Dictionary','party_role_type_assignee','Assignee',NULL,'party_role_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(60,'com.landsystems.lrs.model.Dictionary','party_role_type_power_of_attorney','Power of Attorney',NULL,'party_role_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(61,'com.landsystems.lrs.model.Dictionary','party_role_type_deceased','Deceased',NULL,'party_role_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(62,'com.landsystems.lrs.model.Dictionary','passport','Passport',NULL,'id_document_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(63,'com.landsystems.lrs.model.Dictionary','nat_id','National ID Card',NULL,'id_document_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(64,'com.landsystems.lrs.model.Dictionary','driver_license','Driver\'s License',NULL,'id_document_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(65,'com.landsystems.lrs.model.Dictionary','outd_conf_lodgment','Confirmation of Lodgment',NULL,'outdoc_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(66,'com.landsystems.lrs.model.Dictionary','outd_delivery_receipt','Delivery Letter',NULL,'outdoc_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(67,'com.landsystems.lrs.model.Dictionary','outd_reject_letter','Rejection Letter',NULL,'outdoc_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(68,'com.landsystems.lrs.model.Dictionary','outd_postponed_letter','Postponed Letter',NULL,'outdoc_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(69,'com.landsystems.lrs.model.Dictionary','outd_withdrawal_letter','Withdrawal Letter',NULL,'outdoc_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(70,'com.landsystems.lrs.model.Dictionary','outd_state_act','Certificate of Occupancy',NULL,'outdoc_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(71,'com.landsystems.lrs.model.Dictionary','outd_land_register','Land Register',NULL,'outdoc_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(72,'com.landsystems.lrs.model.Dictionary','outd_survey_diagram','Survey Diagram',NULL,'outdoc_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(73,'com.landsystems.lrs.model.Dictionary','outd_deed_plan','Title Deed Plan',NULL,'outdoc_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(74,'com.landsystems.lrs.model.Dictionary','outd_AcceptanceReceipt','Acceptance Receipt',NULL,'outdoc_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(75,'com.landsystems.lrs.model.Dictionary','outd_sched_letter','Demand for Recertification Fees',NULL,'outdoc_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(76,'com.landsystems.lrs.model.Dictionary','outd_ASG','Assignment',NULL,'outdoc_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(77,'com.landsystems.lrs.model.Dictionary','outd_BL','Building Lease',NULL,'outdoc_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(78,'com.landsystems.lrs.model.Dictionary','outd_DC','Deed of Conveyance',NULL,'outdoc_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(79,'com.landsystems.lrs.model.Dictionary','outd_IPOA','Irrevocable Power of Attorney',NULL,'outdoc_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(80,'com.landsystems.lrs.model.Dictionary','outd_demandfees','Demand of Fees',NULL,'outdoc_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(81,'com.landsystems.lrs.model.Dictionary','outd_allocplotletter','Allocation of Plot Letter',NULL,'outdoc_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(82,'com.landsystems.lrs.model.Dictionary','outd_landform12','Land Form No. 12',NULL,'outdoc_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(83,'com.landsystems.lrs.model.Dictionary','outd_consent_certificate','Consent Certificatet',NULL,'outdoc_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(84,'com.landsystems.lrs.model.Dictionary','outd_registrationmemorandum','Memorandum of Certificate',NULL,'outdoc_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(85,'com.landsystems.lrs.model.Dictionary','outd_demandforregistrationfees','Demand of Registration Fees',NULL,'outdoc_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(86,'com.landsystems.lrs.model.Dictionary','outd_demandnoticestate','Demand Notice',NULL,'outdoc_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(87,'com.landsystems.lrs.model.Dictionary','outd_receiptpayment','Payment Receipt',NULL,'outdoc_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(88,'com.landsystems.lrs.model.Dictionary','outd_lodgmentletter','Lodgment Letter',NULL,'outdoc_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(89,'com.landsystems.lrs.model.Dictionary','sd_titledeedplan','Title Deed Plan',NULL,'document_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(90,'com.landsystems.lrs.model.Dictionary','sd_ASG','Deed of Assignment',NULL,'document_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(91,'com.landsystems.lrs.model.Dictionary','sd_DSR','Deed of Surrender',NULL,'document_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(92,'com.landsystems.lrs.model.Dictionary','sd_LOA','Letter of Administration',NULL,'document_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(93,'com.landsystems.lrs.model.Dictionary','sd_LEAS','Deed of Lease',NULL,'document_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(94,'com.landsystems.lrs.model.Dictionary','sd_POA','Power of Attorney',NULL,'document_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(95,'com.landsystems.lrs.model.Dictionary','sd_DR','Deed of Revocation',NULL,'document_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(96,'com.landsystems.lrs.model.Dictionary','sd_publication','Publication',NULL,'document_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(97,'com.landsystems.lrs.model.Dictionary','sd_GRreceipt','Ground Rent Receipt',NULL,'document_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(98,'com.landsystems.lrs.model.Dictionary','sd_deathcert','Death Certificate',NULL,'document_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(99,'com.landsystems.lrs.model.Dictionary','sd_incorpcert','Certificate of Incorporation',NULL,'document_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(100,'com.landsystems.lrs.model.Dictionary','sd_evidGRpayment','Evidence of Last Ground Rent Payment',NULL,'document_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(101,'com.landsystems.lrs.model.Dictionary','sd_recappfee','Bank Deposit Slip',NULL,'document_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(102,'com.landsystems.lrs.model.Dictionary','sd_memoassoc','Memorandum and Articles of Association',NULL,'document_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(103,'com.landsystems.lrs.model.Dictionary','sd_PropertyFile','Property File',NULL,'document_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(104,'com.landsystems.lrs.model.Dictionary','sd_APRF','Application for Recertification',NULL,'document_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(105,'com.landsystems.lrs.model.Dictionary','sd_ADE','Addendum Document',NULL,'document_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(106,'com.landsystems.lrs.model.Dictionary','sd_CRO','Customary Right of Occupancy Certificate',NULL,'document_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(107,'com.landsystems.lrs.model.Dictionary','sd_DG','Deed of Gift',NULL,'document_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(108,'com.landsystems.lrs.model.Dictionary','sd_DWI','Deed of Will and Testament',NULL,'document_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(109,'com.landsystems.lrs.model.Dictionary','sd_MORO','Deed of Mortgage',NULL,'document_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(110,'com.landsystems.lrs.model.Dictionary','sd_IPOA','Irrevocable Power of Attorney',NULL,'document_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(111,'com.landsystems.lrs.model.Dictionary','sd_histcard','History Card',NULL,'document_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(112,'com.landsystems.lrs.model.Dictionary','sd_receiptnonref','Receipt of Non-Refundable Deposit for Allocation',NULL,'document_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(113,'com.landsystems.lrs.model.Dictionary','sd_reject_letter','Rejection Letter',NULL,'document_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(114,'com.landsystems.lrs.model.Dictionary','sd_landform_5','Land Form 5 (Right of Occupancy Recommendation Form)',NULL,'document_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(115,'com.landsystems.lrs.model.Dictionary','sd_landform_1A','Land Form 1A (Application Form RofO for Private Individuals)',NULL,'document_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(116,'com.landsystems.lrs.model.Dictionary','sd_landform_1B','Land Form 1B (Application Form RofO for Organisations)',NULL,'document_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(117,'com.landsystems.lrs.model.Dictionary','sd_sales_agreement','Sales Agreement',NULL,'document_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(118,'com.landsystems.lrs.model.Dictionary','sd_lease_agreement','Lease Agreement',NULL,'document_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(119,'com.landsystems.lrs.model.Dictionary','sd_localGovChOwn','Local Govt Change of Ownership',NULL,'document_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(120,'com.landsystems.lrs.model.Dictionary','sd_demandnotice','Demand Notice',NULL,'document_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(121,'com.landsystems.lrs.model.Dictionary','sd_recMemo_Com','Recommendation Memo for Commissioner\'s Approval','HON.COMMISSIONER','document_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(122,'com.landsystems.lrs.model.Dictionary','sd_recMemo_Gov','Recommendation Memo For Governor\'s Approval','GOVERNOR','document_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(123,'com.landsystems.lrs.model.Dictionary','sd_COrecom_Gov','Certificate of Occupancy Recommendation Form For Governor Approval',NULL,'document_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(124,'com.landsystems.lrs.model.Dictionary','sd_CM','Conveyance Memorandum',NULL,'document_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(125,'com.landsystems.lrs.model.Dictionary','sd_rightOcc_accept','Right of Occupancy Acceptance Form',NULL,'document_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(126,'com.landsystems.lrs.model.Dictionary','sd_Co_title','Certificate of Occupancy Title',NULL,'document_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(127,'com.landsystems.lrs.model.Dictionary','sd_landfoem_7','Land Form 7 (Right of Occupancy Title)',NULL,'document_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(128,'com.landsystems.lrs.model.Dictionary','sd_caveatEmptor','Caveat Emptor',NULL,'document_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(129,'com.landsystems.lrs.model.Dictionary','sd_valuatReport','Valuation Report',NULL,'document_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(130,'com.landsystems.lrs.model.Dictionary','sd_EIA_report','EIA - Environment Impact Assessment Report',NULL,'document_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(131,'com.landsystems.lrs.model.Dictionary','sd_SAR','Site Analysis Report',NULL,'document_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(132,'com.landsystems.lrs.model.Dictionary','sd_policeReport','Police Report',NULL,'document_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(133,'com.landsystems.lrs.model.Dictionary','sd_surveyPlan','Survey Plan',NULL,'document_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(134,'com.landsystems.lrs.model.Dictionary','sd_survey_67','Survey 67 - Schedule for Preparation of Title Deed Plan and CofO',NULL,'document_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(135,'com.landsystems.lrs.model.Dictionary','sd_surbReport_RightOcc','Survey Report on Right of Occupancy',NULL,'document_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(136,'com.landsystems.lrs.model.Dictionary','sd_traverse_compute','Traverse Computation',NULL,'document_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(137,'com.landsystems.lrs.model.Dictionary','sd_finSurvey_report','Final Survey Report',NULL,'document_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(138,'com.landsystems.lrs.model.Dictionary','sd_courtAff','Court Affidavit',NULL,'document_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(139,'com.landsystems.lrs.model.Dictionary','sd_originRofO','Photocopy of Original RofO',NULL,'document_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(140,'com.landsystems.lrs.model.Dictionary','sd_originCofO','Photocopy of Original CofO',NULL,'document_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(141,'com.landsystems.lrs.model.Dictionary','sd_honourCommission','Cover Letter to the Honourable Commissioner',NULL,'document_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(142,'com.landsystems.lrs.model.Dictionary','sd_deedRelease','Deed of Release',NULL,'document_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(143,'com.landsystems.lrs.model.Dictionary','sd_grantProbate','Grant of Probate',NULL,'document_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(144,'com.landsystems.lrs.model.Dictionary','sd_nasrilIslam','Religious Document',NULL,'document_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(145,'com.landsystems.lrs.model.Dictionary','sd_devolte_order','Devolution Order',NULL,'document_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(146,'com.landsystems.lrs.model.Dictionary','sd_court_judgement','Court Judgement',NULL,'document_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(147,'com.landsystems.lrs.model.Dictionary','sd_RecerForm','Recertification Form',NULL,'document_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(148,'com.landsystems.lrs.model.Dictionary','sd_revokeOrder_attorney','Revocation Order for Power of Attorney',NULL,'document_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(149,'com.landsystems.lrs.model.Dictionary','sd_DLegal_mortage','Deed of Legal Mortgage',NULL,'document_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(150,'com.landsystems.lrs.model.Dictionary','sd_passportPic','Passport Photograph',NULL,'document_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(151,'com.landsystems.lrs.model.Dictionary','sd_incomeTaxClearance','Income Tax Clearance',NULL,'document_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(152,'com.landsystems.lrs.model.Dictionary','sd_teller','Teller Printout',NULL,'document_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(153,'com.landsystems.lrs.model.Dictionary','sd_originRight_occu','Original Right of Occupancy',NULL,'document_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(154,'com.landsystems.lrs.model.Dictionary','sd_originCert_occu','Original Certificate of Occupancy',NULL,'document_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(155,'com.landsystems.lrs.model.Dictionary','sd_allocate_letter','Allocation Letter',NULL,'document_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(156,'com.landsystems.lrs.model.Dictionary','sd_certRecog','Certificate of Recognition',NULL,'document_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(157,'com.landsystems.lrs.model.Dictionary','sd_payment_receipt','Fee Payment Verification Receipt',NULL,'document_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(158,'com.landsystems.lrs.model.Dictionary','sd_regist_memoMem','Registration Memorandum Memo',NULL,'document_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(159,'com.landsystems.lrs.model.Dictionary','sd_lodgement_letter','Confirmation of Lodgement Letter',NULL,'document_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(160,'com.landsystems.lrs.model.Dictionary','sd_delivery_letter','Delivery of Documents Letter',NULL,'document_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(161,'com.landsystems.lrs.model.Dictionary','r1','Variation of signature',NULL,'returned_reason',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(162,'com.landsystems.lrs.model.Dictionary','r2','Failure to pay or underpayment of fees',NULL,'returned_reason',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(163,'com.landsystems.lrs.model.Dictionary','r3','Non-payment of proposed fees',NULL,'returned_reason',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(164,'com.landsystems.lrs.model.Dictionary','r4','Incorrect parcel identification',NULL,'returned_reason',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(165,'com.landsystems.lrs.model.Dictionary','r5','Statutory forms incorrectly completed',NULL,'returned_reason',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(166,'com.landsystems.lrs.model.Dictionary','r6','Initial all amendments',NULL,'returned_reason',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(167,'com.landsystems.lrs.model.Dictionary','r7','State the tenancy of the transferees',NULL,'returned_reason',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(168,'com.landsystems.lrs.model.Dictionary','r8','State date of birth or age of',NULL,'returned_reason',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(169,'com.landsystems.lrs.model.Dictionary','r9','Reconcile the words and figures in',NULL,'returned_reason',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(170,'com.landsystems.lrs.model.Dictionary','r10','Submit original or certified copy of',NULL,'returned_reason',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(171,'com.landsystems.lrs.model.Dictionary','r11','Submit release of restrictive covenant',NULL,'returned_reason',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(172,'com.landsystems.lrs.model.Dictionary','r12','State the capacity of the person(s) signing on behalf of',NULL,'returned_reason',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(173,'com.landsystems.lrs.model.Dictionary','r13','Submit original of Agreement',NULL,'returned_reason',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(174,'com.landsystems.lrs.model.Dictionary','r14','Submit original certificate of good standing from the Registrar of Companies',NULL,'returned_reason',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(175,'com.landsystems.lrs.model.Dictionary','r15','The following name(s) is(are) inconsistent',NULL,'returned_reason',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(176,'com.landsystems.lrs.model.Dictionary','r16','Outstanding mortgage/caveat(s)',NULL,'returned_reason',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(177,'com.landsystems.lrs.model.Dictionary','r17','Address incorrectly completed',NULL,'returned_reason',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(178,'com.landsystems.lrs.model.Dictionary','r18','Reconcile following name(s) with those on the Certificate of Occupancy',NULL,'returned_reason',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(179,'com.landsystems.lrs.model.Dictionary','r19','Reconcile the following description(s) of land with those on the Certificate of Occupancy',NULL,'returned_reason',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(180,'com.landsystems.lrs.model.Dictionary','r20','Perfom the Payment of Fees or Stamp Duties',NULL,'returned_reason',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(181,'com.landsystems.lrs.model.Dictionary','r21','Returned for Regeneration by the MLH:',NULL,'returned_reason',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(182,'com.landsystems.lrs.model.Dictionary','r22','Provide on demand of MLH:',NULL,'returned_reason',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(183,'com.landsystems.lrs.model.Dictionary','r23','Fraudulent Documents:',NULL,'returned_reason',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(184,'com.landsystems.lrs.model.Dictionary','r24','Duplicated Documents:',NULL,'returned_reason',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(185,'com.landsystems.lrs.model.Dictionary','r25','Irregularities in application form, property details or caveats on the land so applied',NULL,'returned_reason',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(186,'com.landsystems.lrs.model.Dictionary','single_tenancy','Single Tenancy',NULL,'share_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(187,'com.landsystems.lrs.model.Dictionary','join_tenancy','Joint Tenancy',NULL,'share_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(188,'com.landsystems.lrs.model.Dictionary','tenancy_common','Tenancy in Common',NULL,'share_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(189,'com.landsystems.lrs.model.Dictionary','tenancy_common_equal','Tenancy in Common in Equal Shares',NULL,'share_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(190,'com.landsystems.lrs.model.Dictionary','tenancy_common_spec','Tenancy in Common in Specific Shares',NULL,'share_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(191,'com.landsystems.lrs.model.Dictionary','spatial_unit_plot','Land Parcel',NULL,'spatial_unit_type',0,1,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(192,'com.landsystems.lrs.model.Dictionary','acre','Acres','4046.8564224','area_measurement_unit',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(193,'com.landsystems.lrs.model.Dictionary','hectar','Hectares','10000','area_measurement_unit',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(194,'com.landsystems.lrs.model.Dictionary','sqm','Square Meters','1','area_measurement_unit',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(195,'com.landsystems.lrs.model.Dictionary','sqyrd','Square Yards','0.9144','area_measurement_unit',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(196,'com.landsystems.lrs.model.Dictionary','inches','Inches',NULL,'maximum_height_measurement_unit',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(197,'com.landsystems.lrs.model.Dictionary','feet','Feet',NULL,'maximum_height_measurement_unit',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(198,'com.landsystems.lrs.model.Dictionary','metres','Metres',NULL,'maximum_height_measurement_unit',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(199,'com.landsystems.lrs.model.Dictionary','bungalow','Bungalow',NULL,'maximum_height_allowable',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(200,'com.landsystems.lrs.model.Dictionary','flat','Flat',NULL,'maximum_height_allowable',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(201,'com.landsystems.lrs.model.Dictionary','1_2_storey','1-2 Storey Building',NULL,'maximum_height_allowable',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(202,'com.landsystems.lrs.model.Dictionary','over_2_storey','Over 2 Storey Building',NULL,'maximum_height_allowable',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(203,'com.landsystems.lrs.model.Dictionary','salut1','Mr.',NULL,'salutation',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(204,'com.landsystems.lrs.model.Dictionary','salut2','Miss',NULL,'salutation',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(205,'com.landsystems.lrs.model.Dictionary','salut3','Mrs.',NULL,'salutation',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(206,'com.landsystems.lrs.model.Dictionary','salut4','Dr.',NULL,'salutation',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(207,'com.landsystems.lrs.model.Dictionary','salut5','Most Rev.',NULL,'salutation',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(208,'com.landsystems.lrs.model.Dictionary','salut6','Prof.',NULL,'salutation',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(209,'com.landsystems.lrs.model.Dictionary','ause_agr','Agricultural',NULL,'actual_use_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(210,'com.landsystems.lrs.model.Dictionary','ause_resid','Residential',NULL,'actual_use_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(211,'com.landsystems.lrs.model.Dictionary','ause_commer','Commercial',NULL,'actual_use_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(212,'com.landsystems.lrs.model.Dictionary','ause_pubins','Public Buildings or Institutional',NULL,'actual_use_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(213,'com.landsystems.lrs.model.Dictionary','ause_indust','Industrial',NULL,'actual_use_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(214,'com.landsystems.lrs.model.Dictionary','ause_recreat','Recreational Area',NULL,'actual_use_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(215,'com.landsystems.lrs.model.Dictionary','ause_mining','Mining',NULL,'actual_use_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(216,'com.landsystems.lrs.model.Dictionary','ause_voluntary','Voluntary Organization',NULL,'actual_use_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(217,'com.landsystems.lrs.model.Dictionary','ause_otherurban','Other Urban Uses',NULL,'actual_use_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(218,'com.landsystems.lrs.model.Dictionary','cond_inscription','Inscription',NULL,'condition_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(219,'com.landsystems.lrs.model.Dictionary','cond_recommend','Recommendation',NULL,'condition_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(220,'com.landsystems.lrs.model.Dictionary','cond_decision_1','Lands Department Decision',NULL,'condition_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(221,'com.landsystems.lrs.model.Dictionary','cond_decision_2','Survey Department Decision',NULL,'condition_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(222,'com.landsystems.lrs.model.Dictionary','cond_decision_3','Senior Land Officer Decision',NULL,'condition_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(223,'com.landsystems.lrs.model.Dictionary','cond_decision_7','Registrar Decision',NULL,'condition_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(224,'com.landsystems.lrs.model.Dictionary','cond_decision_8','Final Registrar Decision',NULL,'condition_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(225,'com.landsystems.lrs.model.Dictionary','cond_decision_9','Results of Survey Preparation',NULL,'condition_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(226,'com.landsystems.lrs.model.Dictionary','cond_note_1','Conformance to Layout Plan',NULL,'condition_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(227,'com.landsystems.lrs.model.Dictionary','cond_status_1','Approved',NULL,'condition_status',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(228,'com.landsystems.lrs.model.Dictionary','cond_status_2','Approved upon the Terms and Conditions',NULL,'condition_status',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(229,'com.landsystems.lrs.model.Dictionary','cond_status_3','Deferred',NULL,'condition_status',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(230,'com.landsystems.lrs.model.Dictionary','cond_status_4','Not Approved',NULL,'condition_status',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(231,'com.landsystems.lrs.model.Dictionary','cond_status_5','Confirmed',NULL,'condition_status',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(232,'com.landsystems.lrs.model.Dictionary','cond_status_6','Not Confirmed',NULL,'condition_status',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(233,'com.landsystems.lrs.model.Dictionary','cond_status_7','Not Available',NULL,'condition_status',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(234,'com.landsystems.lrs.model.Dictionary','cond_status_surv_1','Available',NULL,'condition_status',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(235,'com.landsystems.lrs.model.Dictionary','cond_status_surv_2','Requested',NULL,'condition_status',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(236,'com.landsystems.lrs.model.Dictionary','feetype_app_C_APF','Application Fee',NULL,'fee_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(237,'com.landsystems.lrs.model.Dictionary','feetype_groundrent_C_GR','Outstanding Ground Rent',NULL,'fee_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(238,'com.landsystems.lrs.model.Dictionary','feetype_premiumCofO_C_PCOFO','Premium of CofO Fee',NULL,'fee_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(239,'com.landsystems.lrs.model.Dictionary','feetype_survey_C_SVF','Survey Fee',NULL,'fee_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(240,'com.landsystems.lrs.model.Dictionary','feetype_tdp_C_TDPF','TDP Fee',NULL,'fee_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(241,'com.landsystems.lrs.model.Dictionary','feetype_planlodgement_C_PLF','Plan Lodgement Fee',NULL,'fee_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(242,'com.landsystems.lrs.model.Dictionary','feetype_groundrentpenalty_C_GRP','Ground Rent Penalty',NULL,'fee_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(243,'com.landsystems.lrs.model.Dictionary','feetype_multiplefees','Multiple Fees',NULL,'fee_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(244,'com.landsystems.lrs.model.Dictionary','zone_A','Zone A',NULL,'zone_type',1,1,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(245,'com.landsystems.lrs.model.Dictionary','zone_B','Zone B',NULL,'zone_type',1,2,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(246,'com.landsystems.lrs.model.Dictionary','zone_C','Zone C',NULL,'zone_type',1,3,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(247,'com.landsystems.lrs.model.Dictionary','zone_rural','Rural',NULL,'zone_type',1,4,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(248,'com.landsystems.lrs.model.Dictionary','zone_urban','Urban',NULL,'zone_type',1,5,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(249,'com.landsystems.lrs.model.Dictionary','jos_1','(Gwafan) Lamingo Residential Layout',NULL,'layout_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(250,'com.landsystems.lrs.model.Dictionary','jos_2$','Rock Haven Layout Phase III ',NULL,'layout_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(251,'com.landsystems.lrs.model.Dictionary','jos_3$','Miango Road Layout Behind Customs Sabo Gari extension',NULL,'layout_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(252,'com.landsystems.lrs.model.Dictionary','jos_4$','Rock Heaven Layout Phase I, II & III',NULL,'layout_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(253,'com.landsystems.lrs.model.Dictionary','jos_5$','St. Pirans Layout',NULL,'layout_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(254,'com.landsystems.lrs.model.Dictionary','jos_6$','East of Delimi Layout (Rikkos Layout)',NULL,'layout_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(255,'com.landsystems.lrs.model.Dictionary','jos_7$','West of State Layout',NULL,'layout_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(256,'com.landsystems.lrs.model.Dictionary','jos_8$','Tudun Wada Residential Layout',NULL,'layout_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(257,'com.landsystems.lrs.model.Dictionary','jos_9$','South of G.T.C mini Layout Zaria Road',NULL,'layout_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(258,'com.landsystems.lrs.model.Dictionary','jos_10$','Makeri House Layout',NULL,'layout_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(259,'com.landsystems.lrs.model.Dictionary','jos_11$','Fair field Residential Layout',NULL,'layout_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(260,'com.landsystems.lrs.model.Dictionary','jos_12$','Race Course Mini Layout Shopping Track',NULL,'layout_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(261,'com.landsystems.lrs.model.Dictionary','jos_13$','Rayfield Residential Layout',NULL,'layout_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(262,'com.landsystems.lrs.model.Dictionary','jos_14$','Rock Haven Layout Phase II',NULL,'layout_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(263,'com.landsystems.lrs.model.Dictionary','jos_15$','Rock Heaven Layout (Kabong)',NULL,'layout_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(264,'com.landsystems.lrs.model.Dictionary','jos_16$','Proposed New Commercial Area Jos',NULL,'layout_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(265,'com.landsystems.lrs.model.Dictionary','jos_17$','Low Density Residential Layout (Presidential Rayfield)',NULL,'layout_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(266,'com.landsystems.lrs.model.Dictionary','jos_18$','Weit II Rayfield',NULL,'layout_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(267,'com.landsystems.lrs.model.Dictionary','jos_19$','Land field Residential/Commercial Layout',NULL,'layout_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(268,'com.landsystems.lrs.model.Dictionary','jos_20$','PIPC Layout Ray field',NULL,'layout_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(269,'com.landsystems.lrs.model.Dictionary','jos_21$','Manr(Ministry of Agriculture and Natural Resources) Bukuru Layout',NULL,'layout_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(270,'com.landsystems.lrs.model.Dictionary','jos_22$','Presidential Lodge Layout Rayfied (PSG 858)',NULL,'layout_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(271,'com.landsystems.lrs.model.Dictionary','jos_23$','PL 15337 Zarmaganda Layout',NULL,'layout_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(272,'com.landsystems.lrs.model.Dictionary','jos_24$','PL13591 Layout Gold & Base',NULL,'layout_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(273,'com.landsystems.lrs.model.Dictionary','jos_25$','Yelwa Club Residential Layout',NULL,'layout_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(274,'com.landsystems.lrs.model.Dictionary','jos_26$','Bukuru Manr Layout',NULL,'layout_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(275,'com.landsystems.lrs.model.Dictionary','jos_27$','Sabo Gari Extension Layout ST. Mulumba',NULL,'layout_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(276,'com.landsystems.lrs.model.Dictionary','jos_28$','Rantya Lowcost Housing Estate Layout',NULL,'layout_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(277,'com.landsystems.lrs.model.Dictionary','jos_29$','Ray field Layout Phase III',NULL,'layout_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(278,'com.landsystems.lrs.model.Dictionary','jos_30$','Anglo Jos industrial Layout Extension Transporters\' Layout Zaria Road',NULL,'layout_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(279,'com.landsystems.lrs.model.Dictionary','jos_31$','PL 15785 Jubud Housing Cooperative Soc. Uni Jos',NULL,'layout_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(280,'com.landsystems.lrs.model.Dictionary','jos_32$','BP 2128 Turf Club /Race course Extension',NULL,'layout_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(281,'com.landsystems.lrs.model.Dictionary','jos_33$','Unplanned area of Rock Heaven Phase II  PL15856/PL 15857 Layout Ray field',NULL,'layout_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(282,'com.landsystems.lrs.model.Dictionary','jos_34$','Fairfield Layout Phase II',NULL,'layout_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(283,'com.landsystems.lrs.model.Dictionary','jos_35$','Naraguta Light Industrial Layout',NULL,'layout_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(284,'com.landsystems.lrs.model.Dictionary','jos_36$','Abattoir Mini Layout',NULL,'layout_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(285,'com.landsystems.lrs.model.Dictionary','jos_37$','Transporter Layout Zaria Road',NULL,'layout_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(286,'com.landsystems.lrs.model.Dictionary','jos_38$','Miango Road Layout',NULL,'layout_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(287,'com.landsystems.lrs.model.Dictionary','jos_39$','PL 11156 Layout Ray field',NULL,'layout_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(288,'com.landsystems.lrs.model.Dictionary','jos_40$','Tudun Wada Residential Layout',NULL,'layout_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(289,'com.landsystems.lrs.model.Dictionary','jos_41$','Kwang Residential Layout',NULL,'layout_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(290,'com.landsystems.lrs.model.Dictionary','jos_42$','Lamingo (Gwafan) Residential Layout',NULL,'layout_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(291,'com.landsystems.lrs.model.Dictionary','jos_43$','Part of Miango Layout',NULL,'layout_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(292,'com.landsystems.lrs.model.Dictionary','jos_44$','Rock Layout Phase II & III',NULL,'layout_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(293,'com.landsystems.lrs.model.Dictionary','jos_45$','Rantya Mini Residential Layout',NULL,'layout_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(294,'com.landsystems.lrs.model.Dictionary','jos_46$','Zaria Road New Layout',NULL,'layout_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(295,'com.landsystems.lrs.model.Dictionary','jos_47$','Government Residential Layout Yandaba Bukuru',NULL,'layout_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(296,'com.landsystems.lrs.model.Dictionary','jos_48$','Rock Heaven Phase II',NULL,'layout_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(297,'com.landsystems.lrs.model.Dictionary','jos_49$','Zanariya Residential Layout',NULL,'layout_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(298,'com.landsystems.lrs.model.Dictionary','jos_50$','Lo - Fwol & Lo- Gas Zawan Layout Government House Security Zone',NULL,'layout_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(299,'com.landsystems.lrs.model.Dictionary','jos_51$','PIPC Layout Phase II Jos',NULL,'layout_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(300,'com.landsystems.lrs.model.Dictionary','jos_52$','Main Race Course Layout',NULL,'layout_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(301,'com.landsystems.lrs.model.Dictionary','jos_53$','Proposed Anglo Jos Industrial Layout Extension',NULL,'layout_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(302,'com.landsystems.lrs.model.Dictionary','jos_54$','Forest Camp Mini Layout',NULL,'layout_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(303,'com.landsystems.lrs.model.Dictionary','jos_55$','Proposed Government Residential Layout Dogon Karfe',NULL,'layout_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(304,'com.landsystems.lrs.model.Dictionary','jos_56$','Mini Residential Layout Rayfield',NULL,'layout_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(305,'com.landsystems.lrs.model.Dictionary','jos_57$','Zinariya Layout',NULL,'layout_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(306,'com.landsystems.lrs.model.Dictionary','jos_58$','Zaria Road Layout Main Industrial Anglo Jos Layout',NULL,'layout_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(307,'com.landsystems.lrs.model.Dictionary','jos_59$','Anglo- Jos industrial Layout Extension Abattoir mini Layout',NULL,'layout_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(308,'com.landsystems.lrs.model.Dictionary','jos_60$','Rock Haven Layout Phase I',NULL,'layout_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(309,'com.landsystems.lrs.model.Dictionary','jos_61$','Mungyel (behind WAEC) Res. Layout Jos.',NULL,'layout_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(310,'com.landsystems.lrs.model.Dictionary','jos_62$','Zaria Road Layout South of GTC Jos.',NULL,'layout_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(311,'com.landsystems.lrs.model.Dictionary','jos_63$','Anglo- Jos Industrial Layout Extension',NULL,'layout_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(312,'com.landsystems.lrs.model.Dictionary','jos_64$','Kalambai Layout',NULL,'layout_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(313,'com.landsystems.lrs.model.Dictionary','jos_65$','Zaria Road Layout',NULL,'layout_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(314,'com.landsystems.lrs.model.Dictionary','jos_66$','Industrial Layout Anglo - Jos Extension Near Europharm',NULL,'layout_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(315,'com.landsystems.lrs.model.Dictionary','jos_67$','Federal Low-cost Housing Estate Miango Road',NULL,'layout_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(316,'com.landsystems.lrs.model.Dictionary','jos_68$','Mado Residential Layout',NULL,'layout_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(317,'com.landsystems.lrs.model.Dictionary','jos_69$','Dogon Dutse Staff Junior Layout',NULL,'layout_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(318,'com.landsystems.lrs.model.Dictionary','jos_70$','Re-structure portion of Race course Layout St. Pirans',NULL,'layout_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(319,'com.landsystems.lrs.model.Dictionary','jos_71$','Miango Road Layout B&C',NULL,'layout_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(320,'com.landsystems.lrs.model.Dictionary','jos_72$','Furaka Residential Layout',NULL,'layout_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(321,'com.landsystems.lrs.model.Dictionary','jos_73$','Race Course Residential Extension',NULL,'layout_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(322,'com.landsystems.lrs.model.Dictionary','jos_74$','Liberty Dam Phase two\' B\'',NULL,'layout_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(323,'com.landsystems.lrs.model.Dictionary','jos_75$','Rayfield Layout',NULL,'layout_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(324,'com.landsystems.lrs.model.Dictionary','jos_76$','Kwang Layout Rayfield Two copies',NULL,'layout_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(325,'com.landsystems.lrs.model.Dictionary','jos_77$','New Legislators Quarters Bauchi Ring Road',NULL,'layout_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(326,'com.landsystems.lrs.model.Dictionary','jos_78$','East of Bauchi Layout Reserve',NULL,'layout_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(327,'com.landsystems.lrs.model.Dictionary','jos_79$','East of Bauchi Layout',NULL,'layout_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(328,'com.landsystems.lrs.model.Dictionary','jos_80$','South of GTC Jos mini Layout Zaria Road',NULL,'layout_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(329,'com.landsystems.lrs.model.Dictionary','jos_81$','She he Medium Residential Layout',NULL,'layout_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(330,'com.landsystems.lrs.model.Dictionary','jos_82$','Kalambai Residential mini Layout, Rayfield',NULL,'layout_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(331,'com.landsystems.lrs.model.Dictionary','jos_83$','New legislators Quarters Layout',NULL,'layout_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(332,'com.landsystems.lrs.model.Dictionary','jos_84$','Dogon Dutse Junior staff upgrade Layout Yingi Residential Layout (Rayfield)',NULL,'layout_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(333,'com.landsystems.lrs.model.Dictionary','jos_85$','New Legislators Quarters Layout Reserve',NULL,'layout_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(334,'com.landsystems.lrs.model.Dictionary','jos_86$','Mungyel Residential Layout',NULL,'layout_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(335,'com.landsystems.lrs.model.Dictionary','jos_87$','Gold & Base Layout',NULL,'layout_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(336,'com.landsystems.lrs.model.Dictionary','jos_88$','Little Rayfield Layout',NULL,'layout_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(337,'com.landsystems.lrs.model.Dictionary','jos_89$','Main Race Course Layout',NULL,'layout_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(338,'com.landsystems.lrs.model.Dictionary','jos_90$','Yingi Residential Layout',NULL,'layout_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(339,'com.landsystems.lrs.model.Dictionary','jos_91$','Weit II Residential Layout',NULL,'layout_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(340,'com.landsystems.lrs.model.Dictionary','jos_92$','Residential Layout Ray field Zanariya Layout Reserves',NULL,'layout_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(341,'com.landsystems.lrs.model.Dictionary','jos_93$','Manr showing Excised portion',NULL,'layout_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(342,'com.landsystems.lrs.model.Dictionary','jos_94$','Transporters Layout Zaria Road',NULL,'layout_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(343,'com.landsystems.lrs.model.Dictionary','jos_95$','Katon Rikkos Residential Layout',NULL,'layout_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(344,'com.landsystems.lrs.model.Dictionary','jos_96$','Low Density Residential Layout Rayfield',NULL,'layout_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(345,'com.landsystems.lrs.model.Dictionary','jos_97$','PL 7504 Col. Walbe Layout Rayfield',NULL,'layout_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(346,'com.landsystems.lrs.model.Dictionary','jos_98$','First copy of Lamingo Gwafan Layout',NULL,'layout_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(347,'com.landsystems.lrs.model.Dictionary','jos_99$','Dong Residential Layout Army Vacates Layout Rayfield',NULL,'layout_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(348,'com.landsystems.lrs.model.Dictionary','jos_100$','Kalambai Residential Layout Extension',NULL,'layout_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(349,'com.landsystems.lrs.model.Dictionary','jos_101$','Part of Item PSG 389 Layout Barkin Acha',NULL,'layout_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(350,'com.landsystems.lrs.model.Dictionary','mangu_1','Part of Item PSG 420 Layout',NULL,'layout_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(351,'com.landsystems.lrs.model.Dictionary','mangu_2','Yakjib Residential Layout Lapap',NULL,'layout_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(352,'com.landsystems.lrs.model.Dictionary','mangu_3','Dingse Community Layout',NULL,'layout_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(353,'com.landsystems.lrs.model.Dictionary','mangu_4','Mangu GRA Layout',NULL,'layout_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(354,'com.landsystems.lrs.model.Dictionary','mangu_5','Miskaham Bungha Residential Layout ',NULL,'layout_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(355,'com.landsystems.lrs.model.Dictionary','langtang_1$','Langtang GRA Layout shopping track',NULL,'layout_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(356,'com.landsystems.lrs.model.Dictionary','langtang_2$','Amended Part of Langtang GRA Layout',NULL,'layout_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(357,'com.landsystems.lrs.model.Dictionary','langtang_3$','Amended Plan of Compensation Part Langtang GRA',NULL,'layout_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(358,'com.landsystems.lrs.model.Dictionary','barkin_ladi_1','Gassa Community Residential Layout',NULL,'layout_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(359,'com.landsystems.lrs.model.Dictionary','barkin_ladi_2','Kworos New Layout',NULL,'layout_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(360,'com.landsystems.lrs.model.Dictionary','barkin_ladi_3','Logabot Community Layout',NULL,'layout_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(361,'com.landsystems.lrs.model.Dictionary','pankshin_1','Mini Central Business District Layout',NULL,'layout_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(362,'com.landsystems.lrs.model.Dictionary','pankshin_2','Phase II mini Extension Layout II',NULL,'layout_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(363,'com.landsystems.lrs.model.Dictionary','pankshin_3','Pankshin GRA mini Layout Extension',NULL,'layout_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(364,'com.landsystems.lrs.model.Dictionary','pankshin_4','Re- designed Pankshin GRA Phase I',NULL,'layout_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(365,'com.landsystems.lrs.model.Dictionary','pankshin_5','Amended Pankshin GRA Phase I',NULL,'layout_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(366,'com.landsystems.lrs.model.Dictionary','pankshin_6','Pankshin GRA Phase I',NULL,'layout_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(367,'com.landsystems.lrs.model.Dictionary','pankshin_7','Pankshin GRA Layout Phase II',NULL,'layout_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(368,'com.landsystems.lrs.model.Dictionary','pankshin_8','Phase 1 Mini Extension(2) Layout Phase',NULL,'layout_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(369,'com.landsystems.lrs.model.Dictionary','pankshin_9','Proposed Pankshin GRA Layout Phase one Block Z, 2A Part of Block A',NULL,'layout_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(370,'com.landsystems.lrs.model.Dictionary','shendam_1','Kwansan mini Layout',NULL,'layout_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(371,'com.landsystems.lrs.model.Dictionary','shendam_2','Kwansan Residential Layout',NULL,'layout_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(372,'com.landsystems.lrs.model.Dictionary','shendam_3','Pipe Shendam Residential Layout',NULL,'layout_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(373,'com.landsystems.lrs.model.Dictionary','shendam_4','Behind Shendam Hotel mini Layout',NULL,'layout_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(374,'com.landsystems.lrs.model.Dictionary','shendam_5','Shendam GRA Layout',NULL,'layout_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(375,'com.landsystems.lrs.model.Dictionary','ause_agr_1','Agricultural-Large Scale',NULL,'use_specific',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(376,'com.landsystems.lrs.model.Dictionary','ause_agr_2','Agricultural-Small Scale',NULL,'use_specific',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(377,'com.landsystems.lrs.model.Dictionary','ause_agr_3','Arable',NULL,'use_specific',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(378,'com.landsystems.lrs.model.Dictionary','ause_agr_4','Poultry',NULL,'use_specific',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(379,'com.landsystems.lrs.model.Dictionary','ause_resid_1','Low Density Residential',NULL,'use_specific',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(380,'com.landsystems.lrs.model.Dictionary','ause_resid_2','Medium Density Residential',NULL,'use_specific',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(381,'com.landsystems.lrs.model.Dictionary','ause_resid_3','High Density Residential',NULL,'use_specific',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(382,'com.landsystems.lrs.model.Dictionary','ause_commer_1','Commercial (individual)',NULL,'use_specific',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(383,'com.landsystems.lrs.model.Dictionary','ause_commer_2','Commercial (corporate bodies)',NULL,'use_specific',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(384,'com.landsystems.lrs.model.Dictionary','ause_commer_3','CDB',NULL,'use_specific',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(385,'com.landsystems.lrs.model.Dictionary','ause_commer_4','Banks',NULL,'use_specific',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(386,'com.landsystems.lrs.model.Dictionary','ause_commer_5','Office Complex',NULL,'use_specific',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(387,'com.landsystems.lrs.model.Dictionary','ause_commer_6','Departmental Stores',NULL,'use_specific',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(388,'com.landsystems.lrs.model.Dictionary','ause_commer_7','Commercial (Restaurant/Fast Food)',NULL,'use_specific',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(389,'com.landsystems.lrs.model.Dictionary','ause_commer_8','Shopping Mall/Plaza',NULL,'use_specific',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(390,'com.landsystems.lrs.model.Dictionary','ause_commer_9','Commercial (Shops/Warehouse)',NULL,'use_specific',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(391,'com.landsystems.lrs.model.Dictionary','ause_commer_10','Commercial',NULL,'use_specific',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(392,'com.landsystems.lrs.model.Dictionary','ause_commer_11','Hotel',NULL,'use_specific',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(393,'com.landsystems.lrs.model.Dictionary','ause_commer_12','Repair Garages',NULL,'use_specific',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(394,'com.landsystems.lrs.model.Dictionary','ause_commer_13','Petrol Filling Station',NULL,'use_specific',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(395,'com.landsystems.lrs.model.Dictionary','ause_pubins_1','Hospital',NULL,'use_specific',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(396,'com.landsystems.lrs.model.Dictionary','ause_pubins_2','Clinic',NULL,'use_specific',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(397,'com.landsystems.lrs.model.Dictionary','ause_pubins_3','Health Centre',NULL,'use_specific',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(398,'com.landsystems.lrs.model.Dictionary','ause_pubins_4','Telephone Subexchange/ Base Station Site (T)',NULL,'use_specific',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(399,'com.landsystems.lrs.model.Dictionary','ause_pubins_5','Government Houses',NULL,'use_specific',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(400,'com.landsystems.lrs.model.Dictionary','ause_pubins_6','Post Offices',NULL,'use_specific',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(401,'com.landsystems.lrs.model.Dictionary','ause_pubins_7','Railways Stations',NULL,'use_specific',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(402,'com.landsystems.lrs.model.Dictionary','ause_pubins_8','Book and Harbour Building',NULL,'use_specific',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(403,'com.landsystems.lrs.model.Dictionary','ause_pubins_9','Police Station',NULL,'use_specific',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(404,'com.landsystems.lrs.model.Dictionary','ause_pubins_10','Airport',NULL,'use_specific',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(405,'com.landsystems.lrs.model.Dictionary','ause_pubins_11','Mining Tin Shed',NULL,'use_specific',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(406,'com.landsystems.lrs.model.Dictionary','ause_pubins_12','Theatre',NULL,'use_specific',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(407,'com.landsystems.lrs.model.Dictionary','ause_pubins_13','Stadium(Stadia)',NULL,'use_specific',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(408,'com.landsystems.lrs.model.Dictionary','ause_pubins_14','Community Hall',NULL,'use_specific',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(409,'com.landsystems.lrs.model.Dictionary','ause_pubins_15','Religious Buildings',NULL,'use_specific',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(410,'com.landsystems.lrs.model.Dictionary','ause_pubins_16','Educational Buildings: Schools, Colleges, Universities, Day Care',NULL,'use_specific',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(411,'com.landsystems.lrs.model.Dictionary','ause_pubins_17','Military formations',NULL,'use_specific',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(412,'com.landsystems.lrs.model.Dictionary','ause_indust_1','Industrial-Light',NULL,'use_specific',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(413,'com.landsystems.lrs.model.Dictionary','ause_indust_2','Industrial-Heavy',NULL,'use_specific',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(414,'com.landsystems.lrs.model.Dictionary','ause_recreat_1','Public Open Spaces',NULL,'use_specific',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(415,'com.landsystems.lrs.model.Dictionary','ause_recreat_2','Private Open Spaces',NULL,'use_specific',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(416,'com.landsystems.lrs.model.Dictionary','ause_recreat_3','Golf Courses',NULL,'use_specific',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(417,'com.landsystems.lrs.model.Dictionary','ause_recreat_4','Private Golf Ground',NULL,'use_specific',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(418,'com.landsystems.lrs.model.Dictionary','ause_mining_1','Mining-Quarry (Machine)',NULL,'use_specific',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(419,'com.landsystems.lrs.model.Dictionary','ause_mining_2','Mining-Quarry (Manual)',NULL,'use_specific',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(420,'com.landsystems.lrs.model.Dictionary','ause_voluntary_1','Voluntary Organization',NULL,'use_specific',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(421,'com.landsystems.lrs.model.Dictionary','ause_otherurban_1','Land covered by water including Reservoirs',NULL,'use_specific',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(422,'com.landsystems.lrs.model.Dictionary','ause_otherurban_2','Sewage disposal works',NULL,'use_specific',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(423,'com.landsystems.lrs.model.Dictionary','ause_otherurban_3','Refuse dump or Landfill Site',NULL,'use_specific',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(424,'com.landsystems.lrs.model.Dictionary','ause_otherurban_4','Rail Line',NULL,'use_specific',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(425,'com.landsystems.lrs.model.Dictionary','ause_otherurban_5','Air Fields',NULL,'use_specific',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(426,'com.landsystems.lrs.model.Dictionary','ause_otherurban_6','Roads',NULL,'use_specific',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(427,'com.landsystems.lrs.model.Dictionary','ause_otherurban_7','Public Car parks',NULL,'use_specific',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(428,'com.landsystems.lrs.model.Dictionary','ause_otherurban_8','Cemetery',NULL,'use_specific',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(429,'com.landsystems.lrs.model.Dictionary','ause_otherurban_9','Forest/Game Reserves',NULL,'use_specific',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(430,'com.landsystems.lrs.model.Dictionary','ause_otherurban_10','Flood plain',NULL,'use_specific',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(431,'com.landsystems.lrs.model.Dictionary','ause_otherurban_11','Parks and Private Recreation Area',NULL,'use_specific',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(432,'com.landsystems.lrs.model.Dictionary','ause_otherurban_12','Mixed Uses',NULL,'use_specific',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(434,'com.landsystems.lrs.model.Dictionary','spec_market','Speculative Market',NULL,'basis_for_valuation',0,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(435,'com.landsystems.lrs.model.Dictionary','fair_market','Fair Market',NULL,'basis_for_valuation',0,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(436,'com.landsystems.lrs.model.Dictionary','single','Single',NULL,'civil_status',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(437,'com.landsystems.lrs.model.Dictionary','married','Married',NULL,'civil_status',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(438,'com.landsystems.lrs.model.Dictionary','divorced','Divorced',NULL,'civil_status',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(439,'com.landsystems.lrs.model.Dictionary','widowed','Widowed',NULL,'civil_status',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(440,'com.landsystems.lrs.model.Dictionary','high','High Density',NULL,'density',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(441,'com.landsystems.lrs.model.Dictionary','medium','Medium Density',NULL,'density',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(442,'com.landsystems.lrs.model.Dictionary','low','Low Density',NULL,'density',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(443,'com.landsystems.lrs.model.Dictionary','undulating','Undulating',NULL,'topography',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(444,'com.landsystems.lrs.model.Dictionary','rocky','Rocky',NULL,'topography',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(445,'com.landsystems.lrs.model.Dictionary','flat','Flat',NULL,'topography',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(446,'com.landsystems.lrs.model.Dictionary','sloping','Sloping',NULL,'topography',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(447,'com.landsystems.lrs.model.Dictionary','clay','Clay',NULL,'soil_condition',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(448,'com.landsystems.lrs.model.Dictionary','loamy','Loamy',NULL,'soil_condition',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(449,'com.landsystems.lrs.model.Dictionary','sandy','Sandy',NULL,'soil_condition',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(450,'com.landsystems.lrs.model.Dictionary','cmp_apart','Apartment',NULL,'component_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(451,'com.landsystems.lrs.model.Dictionary','cmp_balcon','Balcony',NULL,'component_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(452,'com.landsystems.lrs.model.Dictionary','cmp_cnfroom','Conference Room',NULL,'component_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(453,'com.landsystems.lrs.model.Dictionary','cmp_garage','Garage',NULL,'component_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(454,'com.landsystems.lrs.model.Dictionary','cmp_garden','Garden',NULL,'component_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(455,'com.landsystems.lrs.model.Dictionary','cmp_kitchen','Kitchen',NULL,'component_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(456,'com.landsystems.lrs.model.Dictionary','cmp_outbuild','Out building',NULL,'component_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(457,'com.landsystems.lrs.model.Dictionary','cmp_parking','Parking',NULL,'component_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(458,'com.landsystems.lrs.model.Dictionary','cmp_praroom','Prayer room',NULL,'component_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(459,'com.landsystems.lrs.model.Dictionary','cmp_rest','Restaurant',NULL,'component_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(460,'com.landsystems.lrs.model.Dictionary','cmp_restrooms','Restrooms',NULL,'component_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(461,'com.landsystems.lrs.model.Dictionary','cmp_shop','Shop',NULL,'component_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(462,'com.landsystems.lrs.model.Dictionary','cmp_storage','Storage',NULL,'component_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(463,'com.landsystems.lrs.model.Dictionary','cmp_studio','Studio',NULL,'component_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(464,'com.landsystems.lrs.model.Dictionary','cmp_dinroom','Sitting/Dining Room',NULL,'component_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(465,'com.landsystems.lrs.model.Dictionary','cmp_servant','Servant’s quarter',NULL,'component_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(466,'com.landsystems.lrs.model.Dictionary','ct_status_current','Current','','ct_status',1,1,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(467,'com.landsystems.lrs.model.Dictionary','ct_status_over6','Over 6 years','','ct_status',1,2,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(468,'com.landsystems.lrs.model.Dictionary','floor_bsmt1','Basement 1',NULL,'floor_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(469,'com.landsystems.lrs.model.Dictionary','floor_bsmt2','Basement 2',NULL,'floor_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(470,'com.landsystems.lrs.model.Dictionary','floor_bsmt3','Basement 3',NULL,'floor_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(471,'com.landsystems.lrs.model.Dictionary','floor_bsmt4','Basement 4',NULL,'floor_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(472,'com.landsystems.lrs.model.Dictionary','floor_ground','Ground',NULL,'floor_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(473,'com.landsystems.lrs.model.Dictionary','floor_mezz','Mezzanine',NULL,'floor_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(474,'com.landsystems.lrs.model.Dictionary','floor_1','1',NULL,'floor_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(475,'com.landsystems.lrs.model.Dictionary','floor_2','2',NULL,'floor_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(476,'com.landsystems.lrs.model.Dictionary','floor_3','3',NULL,'floor_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(477,'com.landsystems.lrs.model.Dictionary','floor_4','4',NULL,'floor_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(478,'com.landsystems.lrs.model.Dictionary','floor_5','5',NULL,'floor_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(479,'com.landsystems.lrs.model.Dictionary','floor_6','6',NULL,'floor_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(480,'com.landsystems.lrs.model.Dictionary','floor_7','7',NULL,'floor_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(481,'com.landsystems.lrs.model.Dictionary','floor_8','8',NULL,'floor_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(482,'com.landsystems.lrs.model.Dictionary','floor_9','9',NULL,'floor_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(483,'com.landsystems.lrs.model.Dictionary','floor_10','10',NULL,'floor_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(484,'com.landsystems.lrs.model.Dictionary','floor_11','11',NULL,'floor_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(485,'com.landsystems.lrs.model.Dictionary','floor_12','12',NULL,'floor_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(486,'com.landsystems.lrs.model.Dictionary','floor_13','13',NULL,'floor_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(487,'com.landsystems.lrs.model.Dictionary','floor_14','14',NULL,'floor_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(488,'com.landsystems.lrs.model.Dictionary','floor_15','15',NULL,'floor_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(489,'com.landsystems.lrs.model.Dictionary','floor_16','16',NULL,'floor_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(490,'com.landsystems.lrs.model.Dictionary','floor_17','17',NULL,'floor_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(491,'com.landsystems.lrs.model.Dictionary','floor_18','18',NULL,'floor_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(492,'com.landsystems.lrs.model.Dictionary','floor_19','19',NULL,'floor_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(493,'com.landsystems.lrs.model.Dictionary','floor_20','20',NULL,'floor_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(494,'com.landsystems.lrs.model.Dictionary','floor_21','21',NULL,'floor_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(495,'com.landsystems.lrs.model.Dictionary','floor_22','22',NULL,'floor_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(496,'com.landsystems.lrs.model.Dictionary','floor_23','23',NULL,'floor_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(497,'com.landsystems.lrs.model.Dictionary','floor_24','24',NULL,'floor_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(498,'com.landsystems.lrs.model.Dictionary','floor_25','25',NULL,'floor_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(499,'com.landsystems.lrs.model.Dictionary','floor_26','26',NULL,'floor_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(500,'com.landsystems.lrs.model.Dictionary','floor_27','27',NULL,'floor_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(501,'com.landsystems.lrs.model.Dictionary','floor_28','28',NULL,'floor_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(502,'com.landsystems.lrs.model.Dictionary','floor_29','29',NULL,'floor_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(503,'com.landsystems.lrs.model.Dictionary','floor_30','30',NULL,'floor_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(504,'com.landsystems.lrs.model.Dictionary','floor_penthouse','Penthouse',NULL,'floor_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(505,'com.landsystems.lrs.model.Dictionary','lex_10','Additional 10 years and below',NULL,'lease_extension',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(506,'com.landsystems.lrs.model.Dictionary','lex_20','Additional 20 years and below',NULL,'lease_extension',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(507,'com.landsystems.lrs.model.Dictionary','lex_30','Additional 30 years and below',NULL,'lease_extension',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(508,'com.landsystems.lrs.model.Dictionary','lex_40','Additional 40 years and below',NULL,'lease_extension',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(509,'com.landsystems.lrs.model.Dictionary','lex_50b','Additional 50 years and below',NULL,'lease_extension',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(510,'com.landsystems.lrs.model.Dictionary','lex_50m','More than 50 years',NULL,'lease_extension',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(511,'com.landsystems.lrs.model.Dictionary','payment_application','Payment for Application',NULL,'payment_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(512,'com.landsystems.lrs.model.Dictionary','payment_registration','Payment for Registration',NULL,'payment_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(513,'com.landsystems.lrs.model.Dictionary','payment_groundrent','Payment for Ground Rent',NULL,'payment_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(514,'com.landsystems.lrs.model.Dictionary','payment_stamp','Payment for Stamp Duty',NULL,'payment_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(515,'com.landsystems.lrs.model.Dictionary','payment_penalty','Penalty',NULL,'payment_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(516,'com.landsystems.lrs.model.Dictionary','block_plot','By Block/Plot',NULL,'property_identification',0,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(517,'com.landsystems.lrs.model.Dictionary','road_plot','By Road/Plot',NULL,'property_identification',0,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(518,'com.landsystems.lrs.model.Dictionary','st_gov','Government Survey',NULL,'survey_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(519,'com.landsystems.lrs.model.Dictionary','st_private','Private Survey',NULL,'survey_type',1,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(520,'com.landsystems.lrs.model.Dictionary','active','Active',NULL,'unit_status',0,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(521,'com.landsystems.lrs.model.Dictionary','archived','Archived',NULL,'unit_status',0,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(522,'com.landsystems.lrs.model.Dictionary','existing','Existing',NULL,'development_status',0,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(523,'com.landsystems.lrs.model.Dictionary','proposed','Proposed',NULL,'development_status',0,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(524,'com.landsystems.lrs.model.Dictionary','existing','Existing',NULL,'access_road_status',0,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(525,'com.landsystems.lrs.model.Dictionary','proposed','Proposed',NULL,'access_road_status',0,0,0,1,'2014-11-25 03:46:47',NULL,NULL,NULL,NULL),(526,'com.landsystems.lrs.model.Dictionary','abuja','Abuja',NULL,'region',1,1,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(527,'com.landsystems.lrs.model.Dictionary','anambra','Anambra',NULL,'region',1,2,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(528,'com.landsystems.lrs.model.Dictionary','enugu','Enugu',NULL,'region',1,3,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(529,'com.landsystems.lrs.model.Dictionary','akwaibom','Akwa Ibom',NULL,'region',1,4,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(530,'com.landsystems.lrs.model.Dictionary','adamawa','Adamawa',NULL,'region',1,5,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(531,'com.landsystems.lrs.model.Dictionary','abia','Abia',NULL,'region',1,6,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(532,'com.landsystems.lrs.model.Dictionary','bauchi','Bauchi',NULL,'region',1,7,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(533,'com.landsystems.lrs.model.Dictionary','bayelsa','Bayelsa',NULL,'region',1,8,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(534,'com.landsystems.lrs.model.Dictionary','benue','Benue',NULL,'region',1,9,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(535,'com.landsystems.lrs.model.Dictionary','borno','Borno',NULL,'region',1,10,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(536,'com.landsystems.lrs.model.Dictionary','crossriver','Cross River',NULL,'region',1,11,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(537,'com.landsystems.lrs.model.Dictionary','delta','Delta',NULL,'region',1,12,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(538,'com.landsystems.lrs.model.Dictionary','ebonyi','Ebonyi',NULL,'region',1,13,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(539,'com.landsystems.lrs.model.Dictionary','edo','Edo',NULL,'region',1,14,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(540,'com.landsystems.lrs.model.Dictionary','ekiti','Ekiti',NULL,'region',1,15,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(541,'com.landsystems.lrs.model.Dictionary','gombe','Gombe',NULL,'region',1,16,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(542,'com.landsystems.lrs.model.Dictionary','imo','Imo',NULL,'region',1,17,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(543,'com.landsystems.lrs.model.Dictionary','jigawa','Jigawa',NULL,'region',1,18,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(544,'com.landsystems.lrs.model.Dictionary','kaduna','Kaduna',NULL,'region',1,19,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(545,'com.landsystems.lrs.model.Dictionary','kano','Kano',NULL,'region',1,21,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(546,'com.landsystems.lrs.model.Dictionary','katsina','Katsina',NULL,'region',1,22,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(547,'com.landsystems.lrs.model.Dictionary','kebbi','Kebbi',NULL,'region',1,23,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(548,'com.landsystems.lrs.model.Dictionary','kogi','Kogi',NULL,'region',1,24,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(549,'com.landsystems.lrs.model.Dictionary','kwara','Kwara',NULL,'region',1,25,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(550,'com.landsystems.lrs.model.Dictionary','lagos','Lagos',NULL,'region',1,26,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(551,'com.landsystems.lrs.model.Dictionary','nasarawa','Nasarawa',NULL,'region',1,27,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(552,'com.landsystems.lrs.model.Dictionary','niger','Niger',NULL,'region',1,28,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(553,'com.landsystems.lrs.model.Dictionary','ogun','Ogun',NULL,'region',1,29,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(554,'com.landsystems.lrs.model.Dictionary','ondo','Ondo',NULL,'region',1,30,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(555,'com.landsystems.lrs.model.Dictionary','osun','Osun',NULL,'region',1,31,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(556,'com.landsystems.lrs.model.Dictionary','oyo','Oyo',NULL,'region',1,32,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(557,'com.landsystems.lrs.model.Dictionary','plateau','Plateau',NULL,'region',1,33,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(558,'com.landsystems.lrs.model.Dictionary','rivers','Rivers',NULL,'region',1,34,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(559,'com.landsystems.lrs.model.Dictionary','sokoto','Sokoto',NULL,'region',1,35,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(560,'com.landsystems.lrs.model.Dictionary','taraba','Taraba',NULL,'region',1,36,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(561,'com.landsystems.lrs.model.Dictionary','yobe','Yobe',NULL,'region',1,37,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(562,'com.landsystems.lrs.model.Dictionary','zamfara','Zamfara',NULL,'region',1,38,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(580,'com.landsystems.lrs.model.Dictionary','af','Afghanistan',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(581,'com.landsystems.lrs.model.Dictionary','ax','Aland Islands',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(582,'com.landsystems.lrs.model.Dictionary','al','Albania',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(583,'com.landsystems.lrs.model.Dictionary','dz','Algeria',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(584,'com.landsystems.lrs.model.Dictionary','as','American Samoa',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(585,'com.landsystems.lrs.model.Dictionary','ad','Andorra',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(586,'com.landsystems.lrs.model.Dictionary','ao','Angola',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(587,'com.landsystems.lrs.model.Dictionary','ai','Anguilla',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(588,'com.landsystems.lrs.model.Dictionary','aq','Antarctica',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(589,'com.landsystems.lrs.model.Dictionary','ag','Antigua and Barbuda',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(590,'com.landsystems.lrs.model.Dictionary','ar','Argentina',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(591,'com.landsystems.lrs.model.Dictionary','am','Armenia',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(592,'com.landsystems.lrs.model.Dictionary','aw','Aruba',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(593,'com.landsystems.lrs.model.Dictionary','au','Australia',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(594,'com.landsystems.lrs.model.Dictionary','at','Austria',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(595,'com.landsystems.lrs.model.Dictionary','az','Azerbaijan',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(596,'com.landsystems.lrs.model.Dictionary','bs','Bahamas',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(597,'com.landsystems.lrs.model.Dictionary','bh','Bahrain',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(598,'com.landsystems.lrs.model.Dictionary','bd','Bangladesh',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(599,'com.landsystems.lrs.model.Dictionary','bb','Barbados',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(600,'com.landsystems.lrs.model.Dictionary','by','Belarus',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(601,'com.landsystems.lrs.model.Dictionary','be','Belgium',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(602,'com.landsystems.lrs.model.Dictionary','bz','Belize',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(603,'com.landsystems.lrs.model.Dictionary','bj','Benin',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(604,'com.landsystems.lrs.model.Dictionary','bm','Bermuda',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(605,'com.landsystems.lrs.model.Dictionary','bt','Bhutan',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(606,'com.landsystems.lrs.model.Dictionary','bo','Bolivia,Plurinational State Of',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(607,'com.landsystems.lrs.model.Dictionary','ba','Bosnia and Herzegovina',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(608,'com.landsystems.lrs.model.Dictionary','bw','Botswana',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(609,'com.landsystems.lrs.model.Dictionary','bv','Bouvet Island',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(610,'com.landsystems.lrs.model.Dictionary','br','Brazil',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(611,'com.landsystems.lrs.model.Dictionary','io','British Indian Ocean Territory',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(612,'com.landsystems.lrs.model.Dictionary','bn','Brunei Darussalam',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(613,'com.landsystems.lrs.model.Dictionary','bg','Bulgaria',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(614,'com.landsystems.lrs.model.Dictionary','bf','Burkina Faso',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(615,'com.landsystems.lrs.model.Dictionary','bi','Burundi',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(616,'com.landsystems.lrs.model.Dictionary','kh','Cambodia',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(617,'com.landsystems.lrs.model.Dictionary','cm','Cameroon',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(618,'com.landsystems.lrs.model.Dictionary','ca','Canada',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(619,'com.landsystems.lrs.model.Dictionary','cv','Cape Verde',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(620,'com.landsystems.lrs.model.Dictionary','ky','Cayman Islands',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(621,'com.landsystems.lrs.model.Dictionary','cf','Central African Republic',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(622,'com.landsystems.lrs.model.Dictionary','td','Chad',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(623,'com.landsystems.lrs.model.Dictionary','cl','Chile',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(624,'com.landsystems.lrs.model.Dictionary','cn','China',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(625,'com.landsystems.lrs.model.Dictionary','cx','Christmas Island',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(626,'com.landsystems.lrs.model.Dictionary','cc','Cocos (Keeling) Islands',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(627,'com.landsystems.lrs.model.Dictionary','co','Colombia',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(628,'com.landsystems.lrs.model.Dictionary','km','Comoros',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(629,'com.landsystems.lrs.model.Dictionary','cd','Congo,The Democratic Republic of the',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(630,'com.landsystems.lrs.model.Dictionary','cg','Congo',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(631,'com.landsystems.lrs.model.Dictionary','ck','Cook Islands',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(632,'com.landsystems.lrs.model.Dictionary','cr','Costa Rica',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(633,'com.landsystems.lrs.model.Dictionary','ci','Cote d\'Ivoire',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(634,'com.landsystems.lrs.model.Dictionary','hr','Croatia',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(635,'com.landsystems.lrs.model.Dictionary','cu','Cuba',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(636,'com.landsystems.lrs.model.Dictionary','cy','Cyprus',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(637,'com.landsystems.lrs.model.Dictionary','cz','Czech Republic',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(638,'com.landsystems.lrs.model.Dictionary','dk','Denmark',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(639,'com.landsystems.lrs.model.Dictionary','dj','Djibouti',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(640,'com.landsystems.lrs.model.Dictionary','dm','Dominica',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(641,'com.landsystems.lrs.model.Dictionary','do','Dominican Republic',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(642,'com.landsystems.lrs.model.Dictionary','ec','Ecuador',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(643,'com.landsystems.lrs.model.Dictionary','eg','Egypt',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(644,'com.landsystems.lrs.model.Dictionary','sv','El Salvador',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(645,'com.landsystems.lrs.model.Dictionary','gq','Equatorial Guinea',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(646,'com.landsystems.lrs.model.Dictionary','er','Eritrea',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(647,'com.landsystems.lrs.model.Dictionary','ee','Estonia',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(648,'com.landsystems.lrs.model.Dictionary','et','Ethiopia',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(649,'com.landsystems.lrs.model.Dictionary','fk','Falkland Islands (Malvinas)',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(650,'com.landsystems.lrs.model.Dictionary','fo','Faroe Islands',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(651,'com.landsystems.lrs.model.Dictionary','fj','Fiji',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(652,'com.landsystems.lrs.model.Dictionary','fi','Finland',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(653,'com.landsystems.lrs.model.Dictionary','fr','France',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(654,'com.landsystems.lrs.model.Dictionary','gf','French Guiana',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(655,'com.landsystems.lrs.model.Dictionary','pf','French Polynesia',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(656,'com.landsystems.lrs.model.Dictionary','tf','French Southern Territories',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(657,'com.landsystems.lrs.model.Dictionary','ga','Gabon',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(658,'com.landsystems.lrs.model.Dictionary','gm','Gambia',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(659,'com.landsystems.lrs.model.Dictionary','ge','Georgia',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(660,'com.landsystems.lrs.model.Dictionary','de','Germany',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(661,'com.landsystems.lrs.model.Dictionary','gh','Ghana',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(662,'com.landsystems.lrs.model.Dictionary','gi','Gibraltar',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(663,'com.landsystems.lrs.model.Dictionary','gr','Greece',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(664,'com.landsystems.lrs.model.Dictionary','gl','Greenland',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(665,'com.landsystems.lrs.model.Dictionary','gd','Grenada',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(666,'com.landsystems.lrs.model.Dictionary','gp','Guadeloupe',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(667,'com.landsystems.lrs.model.Dictionary','gu','Guam',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(668,'com.landsystems.lrs.model.Dictionary','gt','Guatemala',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(669,'com.landsystems.lrs.model.Dictionary','gg','Guernsey',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(670,'com.landsystems.lrs.model.Dictionary','gn','Guinea',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(671,'com.landsystems.lrs.model.Dictionary','gw','Guinea-Bissau',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(672,'com.landsystems.lrs.model.Dictionary','gy','Guyana',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(673,'com.landsystems.lrs.model.Dictionary','ht','Haiti',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(674,'com.landsystems.lrs.model.Dictionary','hm','Heard Island and McDonald Islands',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(675,'com.landsystems.lrs.model.Dictionary','va','Holy See (Vatican City)',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(676,'com.landsystems.lrs.model.Dictionary','hn','Honduras',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(677,'com.landsystems.lrs.model.Dictionary','hk','Hong Kong',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(678,'com.landsystems.lrs.model.Dictionary','hu','Hungary',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(679,'com.landsystems.lrs.model.Dictionary','is','Iceland',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(680,'com.landsystems.lrs.model.Dictionary','in','India',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(681,'com.landsystems.lrs.model.Dictionary','id','Indonesia',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(682,'com.landsystems.lrs.model.Dictionary','ir','Iran, Islamic Republic of',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(683,'com.landsystems.lrs.model.Dictionary','iq','Iraq',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(684,'com.landsystems.lrs.model.Dictionary','ie','Ireland',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(685,'com.landsystems.lrs.model.Dictionary','im','Isle of Man',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(686,'com.landsystems.lrs.model.Dictionary','il','Israel',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(687,'com.landsystems.lrs.model.Dictionary','it','Italy',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(688,'com.landsystems.lrs.model.Dictionary','jm','Jamaica',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(689,'com.landsystems.lrs.model.Dictionary','jp','Japan',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(690,'com.landsystems.lrs.model.Dictionary','je','Jersey',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(691,'com.landsystems.lrs.model.Dictionary','jo','Jordan',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(692,'com.landsystems.lrs.model.Dictionary','kz','Kazakhstan',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(693,'com.landsystems.lrs.model.Dictionary','ke','Kenya',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(694,'com.landsystems.lrs.model.Dictionary','ki','Kiribati',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(695,'com.landsystems.lrs.model.Dictionary','kp','Korea, Democratic People\'s Republic of',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(696,'com.landsystems.lrs.model.Dictionary','kr','Korea, Republic of',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(697,'com.landsystems.lrs.model.Dictionary','kw','Kuwait',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(698,'com.landsystems.lrs.model.Dictionary','kg','Kyrgyzstan',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(699,'com.landsystems.lrs.model.Dictionary','la','Lao People\'s Democratic Republic',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(700,'com.landsystems.lrs.model.Dictionary','lv','Latvia',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(701,'com.landsystems.lrs.model.Dictionary','lb','Lebanon',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(702,'com.landsystems.lrs.model.Dictionary','ls','Lesotho',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(703,'com.landsystems.lrs.model.Dictionary','lr','Liberia',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(704,'com.landsystems.lrs.model.Dictionary','ly','Libyan Arab Jamahiriya',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(705,'com.landsystems.lrs.model.Dictionary','li','Liechtenstein',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(706,'com.landsystems.lrs.model.Dictionary','lt','Lithuania',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(707,'com.landsystems.lrs.model.Dictionary','lu','Luxembourg',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(708,'com.landsystems.lrs.model.Dictionary','mo','Macao',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(709,'com.landsystems.lrs.model.Dictionary','mk','Macedonia, The Former Yugoslav Republic of',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(710,'com.landsystems.lrs.model.Dictionary','mg','Madagascar',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(711,'com.landsystems.lrs.model.Dictionary','mw','Malawi',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(712,'com.landsystems.lrs.model.Dictionary','my','Malaysia',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(713,'com.landsystems.lrs.model.Dictionary','mv','Maldives',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(714,'com.landsystems.lrs.model.Dictionary','ml','Mali',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(715,'com.landsystems.lrs.model.Dictionary','mt','Malta',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(716,'com.landsystems.lrs.model.Dictionary','mh','Marshall Islands',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(717,'com.landsystems.lrs.model.Dictionary','mq','Martinique',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(718,'com.landsystems.lrs.model.Dictionary','mr','Mauritania',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(719,'com.landsystems.lrs.model.Dictionary','mu','Mauritius',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(720,'com.landsystems.lrs.model.Dictionary','yt','Mayotte',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(721,'com.landsystems.lrs.model.Dictionary','mx','Mexico',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(722,'com.landsystems.lrs.model.Dictionary','fm','Micronesia, Federated States of',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(723,'com.landsystems.lrs.model.Dictionary','md','Moldova, Republic of',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(724,'com.landsystems.lrs.model.Dictionary','mc','Monaco',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(725,'com.landsystems.lrs.model.Dictionary','mn','Mongolia',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(726,'com.landsystems.lrs.model.Dictionary','me','Montenegro',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(727,'com.landsystems.lrs.model.Dictionary','ms','Montserrat',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(728,'com.landsystems.lrs.model.Dictionary','ma','Morocco',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(729,'com.landsystems.lrs.model.Dictionary','mz','Mozambique',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(730,'com.landsystems.lrs.model.Dictionary','mm','Myanmar',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(731,'com.landsystems.lrs.model.Dictionary','na','Namibia',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(732,'com.landsystems.lrs.model.Dictionary','nr','Nauru',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(733,'com.landsystems.lrs.model.Dictionary','np','Nepal',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(734,'com.landsystems.lrs.model.Dictionary','nl','Netherlands',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(735,'com.landsystems.lrs.model.Dictionary','an','Netherlands Antilles',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(736,'com.landsystems.lrs.model.Dictionary','nc','New Caledonia',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(737,'com.landsystems.lrs.model.Dictionary','nz','New Zealand',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(738,'com.landsystems.lrs.model.Dictionary','ni','Nicaragua',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(739,'com.landsystems.lrs.model.Dictionary','ne','Niger',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(740,'com.landsystems.lrs.model.Dictionary','ng','Nigeria',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(741,'com.landsystems.lrs.model.Dictionary','nu','Niue',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(742,'com.landsystems.lrs.model.Dictionary','nf','Norfolk Island',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(743,'com.landsystems.lrs.model.Dictionary','mp','Northern Mariana Islands',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(744,'com.landsystems.lrs.model.Dictionary','no','Norway',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(745,'com.landsystems.lrs.model.Dictionary','om','Oman',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(746,'com.landsystems.lrs.model.Dictionary','pk','Pakistan',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(747,'com.landsystems.lrs.model.Dictionary','pw','Palau',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(748,'com.landsystems.lrs.model.Dictionary','ps','Palestinian Territory, Occuped',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(749,'com.landsystems.lrs.model.Dictionary','pa','Panama',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(750,'com.landsystems.lrs.model.Dictionary','pg','Papua New Guinea',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(751,'com.landsystems.lrs.model.Dictionary','py','Paraguay',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(752,'com.landsystems.lrs.model.Dictionary','pe','Peru',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(753,'com.landsystems.lrs.model.Dictionary','ph','Philippines',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(754,'com.landsystems.lrs.model.Dictionary','pn','Pitcairn',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(755,'com.landsystems.lrs.model.Dictionary','pl','Poland',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(756,'com.landsystems.lrs.model.Dictionary','pt','Portugal',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(757,'com.landsystems.lrs.model.Dictionary','pr','Puerto Rico',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(758,'com.landsystems.lrs.model.Dictionary','qa','Qatar',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(759,'com.landsystems.lrs.model.Dictionary','re','Reunion',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(760,'com.landsystems.lrs.model.Dictionary','ro','Romania',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(761,'com.landsystems.lrs.model.Dictionary','ru','Russian Federation',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(762,'com.landsystems.lrs.model.Dictionary','rw','Rwanda',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(763,'com.landsystems.lrs.model.Dictionary','bl','Saint Barthelemy',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(764,'com.landsystems.lrs.model.Dictionary','sh','Saint Helena,Ascension and Tristan da Cunha',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(765,'com.landsystems.lrs.model.Dictionary','kn','Saint Kitts and Nevis',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(766,'com.landsystems.lrs.model.Dictionary','lc','Saint Lucia',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(767,'com.landsystems.lrs.model.Dictionary','mf','Saint Martin',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(768,'com.landsystems.lrs.model.Dictionary','pm','Saint Pierre and Miquelon',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(769,'com.landsystems.lrs.model.Dictionary','vc','Saint Vincent and the Grenadines',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(770,'com.landsystems.lrs.model.Dictionary','ws','Samoa',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(771,'com.landsystems.lrs.model.Dictionary','sm','San Marino',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(772,'com.landsystems.lrs.model.Dictionary','st','Sao Tome and Principe',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(773,'com.landsystems.lrs.model.Dictionary','sa','Saudi Arabia',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(774,'com.landsystems.lrs.model.Dictionary','sn','Senegal',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(775,'com.landsystems.lrs.model.Dictionary','rs','Serbia',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(776,'com.landsystems.lrs.model.Dictionary','sc','Seychelles',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(777,'com.landsystems.lrs.model.Dictionary','sl','Sierra Leone',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(778,'com.landsystems.lrs.model.Dictionary','sg','Singapore',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(779,'com.landsystems.lrs.model.Dictionary','sk','Slovakia',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(780,'com.landsystems.lrs.model.Dictionary','si','Slovenia',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(781,'com.landsystems.lrs.model.Dictionary','sb','Solomon Islands',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(782,'com.landsystems.lrs.model.Dictionary','so','Somalia',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(783,'com.landsystems.lrs.model.Dictionary','za','South Africa',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(784,'com.landsystems.lrs.model.Dictionary','gs','South Georgia and the South Sandwich Islands',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(785,'com.landsystems.lrs.model.Dictionary','es','Spain',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(786,'com.landsystems.lrs.model.Dictionary','lk','Sri Lanka',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(787,'com.landsystems.lrs.model.Dictionary','sd','Sudan',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(788,'com.landsystems.lrs.model.Dictionary','sr','Suriname',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(789,'com.landsystems.lrs.model.Dictionary','sj','Svalbard and Jan Mayen',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(790,'com.landsystems.lrs.model.Dictionary','sz','Swaziland',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(791,'com.landsystems.lrs.model.Dictionary','se','Sweden',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(792,'com.landsystems.lrs.model.Dictionary','ch','Switzerland',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(793,'com.landsystems.lrs.model.Dictionary','sy','Syrian Arab Republic',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(794,'com.landsystems.lrs.model.Dictionary','tw','Taiwan, Province of China',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(795,'com.landsystems.lrs.model.Dictionary','tj','Tajikistan',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(796,'com.landsystems.lrs.model.Dictionary','tz','Tanzania, United Republic of',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(797,'com.landsystems.lrs.model.Dictionary','th','Thailand',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(798,'com.landsystems.lrs.model.Dictionary','tl','Timor-Leste',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(799,'com.landsystems.lrs.model.Dictionary','tg','Togo',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(800,'com.landsystems.lrs.model.Dictionary','tk','Tokelau',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(801,'com.landsystems.lrs.model.Dictionary','to','Tonga',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(802,'com.landsystems.lrs.model.Dictionary','tt','Trinidad and Tobago',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(803,'com.landsystems.lrs.model.Dictionary','tn','Tunisia',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(804,'com.landsystems.lrs.model.Dictionary','tr','Turkey',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(805,'com.landsystems.lrs.model.Dictionary','tm','Turkmenistan',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(806,'com.landsystems.lrs.model.Dictionary','tc','Turks and Caicos Islands',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(807,'com.landsystems.lrs.model.Dictionary','tv','Tuvalu',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(808,'com.landsystems.lrs.model.Dictionary','ug','Uganda',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(809,'com.landsystems.lrs.model.Dictionary','ua','Ukraine',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(810,'com.landsystems.lrs.model.Dictionary','ae','United Arab Emirates',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(811,'com.landsystems.lrs.model.Dictionary','gb','United Kingdom',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(812,'com.landsystems.lrs.model.Dictionary','us','United States',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(813,'com.landsystems.lrs.model.Dictionary','um','United States Minor Outlying Islands',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(814,'com.landsystems.lrs.model.Dictionary','uy','Uruguay',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(815,'com.landsystems.lrs.model.Dictionary','uz','Uzbekistan',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(816,'com.landsystems.lrs.model.Dictionary','vu','Vanuatu',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(817,'com.landsystems.lrs.model.Dictionary','ve','Venezuela, Bolivarian republic of',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(818,'com.landsystems.lrs.model.Dictionary','vn','Vietnam',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(819,'com.landsystems.lrs.model.Dictionary','vg','Virgin Islands, British',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(820,'com.landsystems.lrs.model.Dictionary','vi','Virgin Islands, U.S.',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(821,'com.landsystems.lrs.model.Dictionary','wf','Wallis and Futuna',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(822,'com.landsystems.lrs.model.Dictionary','eh','Western Sahara',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(823,'com.landsystems.lrs.model.Dictionary','ye','Yemen',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(824,'com.landsystems.lrs.model.Dictionary','zm','Zambia',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(825,'com.landsystems.lrs.model.Dictionary','zw','Zimbabwe',NULL,'country',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(826,'com.landsystems.lrs.model.Dictionary','layout1','ABONNEMA/DEGEMA',NULL,'layout',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(827,'com.landsystems.lrs.model.Dictionary','layout2','ABULOMA GRA ANNEX LAYOUT',NULL,'layout',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(828,'com.landsystems.lrs.model.Dictionary','layout3','ABULOMA HOUSING ESTATE',NULL,'layout',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(829,'com.landsystems.lrs.model.Dictionary','layout4','AGIP WAY MINI ESTATE',NULL,'layout',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(830,'com.landsystems.lrs.model.Dictionary','layout5','AHOADA COMM/IND. LAYOUT',NULL,'layout',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(831,'com.landsystems.lrs.model.Dictionary','layout6','AHOADA DIVISION',NULL,'layout',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(832,'com.landsystems.lrs.model.Dictionary','layout7','AMADI FLAT EXTENSION LAYOUT',NULL,'layout',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(833,'com.landsystems.lrs.model.Dictionary','layout8','AMADI FLATS LAYOUT',NULL,'layout',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(834,'com.landsystems.lrs.model.Dictionary','layout9','AMADI-AMA LAYOUT EXTENSION',NULL,'layout',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(835,'com.landsystems.lrs.model.Dictionary','layout10','AMADI-AMA RESIDENTIAL LAYOUT',NULL,'layout',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(836,'com.landsystems.lrs.model.Dictionary','layout11','AMIGBO OLU OBASANJO ROAD',NULL,'layout',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(837,'com.landsystems.lrs.model.Dictionary','layout12','BISHOP JOHNSON STREET LAYOUT',NULL,'layout',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(838,'com.landsystems.lrs.model.Dictionary','layout13','BONNY',NULL,'layout',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(839,'com.landsystems.lrs.model.Dictionary','layout14','BORI TOWN',NULL,'layout',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(840,'com.landsystems.lrs.model.Dictionary','layout15','BORIKIRI LAYOUT PHASE 1',NULL,'layout',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(841,'com.landsystems.lrs.model.Dictionary','layout16','BORIKIRI LAYOUT PHASE 2',NULL,'layout',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(842,'com.landsystems.lrs.model.Dictionary','layout17','BORIKIRI LAYOUT PHASE 3',NULL,'layout',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(843,'com.landsystems.lrs.model.Dictionary','layout18','BORIKIRI RESIDENTIAL LAYOUT',NULL,'layout',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(844,'com.landsystems.lrs.model.Dictionary','layout19','BUGUMA LAYOUT',NULL,'layout',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(845,'com.landsystems.lrs.model.Dictionary','layout20','CALABAR/ENUGU MISCELLANOUS',NULL,'layout',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(846,'com.landsystems.lrs.model.Dictionary','layout21','CHOKOTA/IGBO- ETCHE GRA I',NULL,'layout',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(847,'com.landsystems.lrs.model.Dictionary','layout22','CLUB ROAD LAYOUT',NULL,'layout',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(848,'com.landsystems.lrs.model.Dictionary','layout23','CORONATION LAYOUT',NULL,'layout',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(849,'com.landsystems.lrs.model.Dictionary','layout24','DEGEMA CROWN LAND LAYOUT',NULL,'layout',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(850,'com.landsystems.lrs.model.Dictionary','layout25','DIOBU',NULL,'layout',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(851,'com.landsystems.lrs.model.Dictionary','layout26','DIOBU GRA PHASE 1',NULL,'layout',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(852,'com.landsystems.lrs.model.Dictionary','layout27','DIOBU GRA PHASE 1 EXTENSION',NULL,'layout',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(853,'com.landsystems.lrs.model.Dictionary','layout28','DIOBU GRA PHASE 2',NULL,'layout',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(854,'com.landsystems.lrs.model.Dictionary','layout29','DIOBU GRA PHASE 3',NULL,'layout',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(855,'com.landsystems.lrs.model.Dictionary','layout30','EAGLE ISLAND LAYOUT',NULL,'layout',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(856,'com.landsystems.lrs.model.Dictionary','layout31','EASTERN BY PASS LAYOUT PHASE 1',NULL,'layout',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(857,'com.landsystems.lrs.model.Dictionary','layout32','EASTERN BY PASS LAYOUT PHASE 2',NULL,'layout',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(858,'com.landsystems.lrs.model.Dictionary','layout33','ELECHI ACCESS ROAD LAYOUT',NULL,'layout',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(859,'com.landsystems.lrs.model.Dictionary','layout34','ELECHI LAYOUT',NULL,'layout',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(860,'com.landsystems.lrs.model.Dictionary','layout35','ELEKAHIA HOUSING ESTATE',NULL,'layout',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(861,'com.landsystems.lrs.model.Dictionary','layout36','ELEKAHIA-DIOBU',NULL,'layout',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(862,'com.landsystems.lrs.model.Dictionary','layout37','ELEME TAI DIVISION',NULL,'layout',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(863,'com.landsystems.lrs.model.Dictionary','layout38','GOLF COURSE /OLD GRA EXTENSION LAYOUT',NULL,'layout',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(864,'com.landsystems.lrs.model.Dictionary','layout39','GRA PHASE 4',NULL,'layout',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(865,'com.landsystems.lrs.model.Dictionary','layout40','GRA PHASE 7',NULL,'layout',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(866,'com.landsystems.lrs.model.Dictionary','layout41','GRA PHASE 8',NULL,'layout',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(867,'com.landsystems.lrs.model.Dictionary','layout42','GRA PHASE IV EXTENSION',NULL,'layout',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(868,'com.landsystems.lrs.model.Dictionary','layout43','HARBOUR  ROAD',NULL,'layout',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(869,'com.landsystems.lrs.model.Dictionary','layout44','HOSPITAL ROAD',NULL,'layout',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(870,'com.landsystems.lrs.model.Dictionary','layout45','IKWERRE/ETCHE DIVISION',NULL,'layout',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(871,'com.landsystems.lrs.model.Dictionary','layout46','INDUSTRY ROAD LAYOUT',NULL,'layout',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(872,'com.landsystems.lrs.model.Dictionary','layout47','IRIEBE LAYOUT',NULL,'layout',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(873,'com.landsystems.lrs.model.Dictionary','layout48','ISIODU LAYOUT',NULL,'layout',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(874,'com.landsystems.lrs.model.Dictionary','layout49','KHANA DIVISION',NULL,'layout',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(875,'com.landsystems.lrs.model.Dictionary','layout50','LIBERATION STADIUM SUB- COM CORR ELEKOHIA LAYOUT',NULL,'layout',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(876,'com.landsystems.lrs.model.Dictionary','layout51','MISCELANEOUS TOWN',NULL,'layout',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(877,'com.landsystems.lrs.model.Dictionary','layout52','MISCELLANEOUS  DIOBU',NULL,'layout',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(878,'com.landsystems.lrs.model.Dictionary','layout53','OBIGBO-ENUGU/OWERRI',NULL,'layout',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(879,'com.landsystems.lrs.model.Dictionary','layout54','OBIGBO/BORI',NULL,'layout',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(880,'com.landsystems.lrs.model.Dictionary','layout55','OBIO LAYOUT',NULL,'layout',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(881,'com.landsystems.lrs.model.Dictionary','layout56','OGBUNABALI',NULL,'layout',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(882,'com.landsystems.lrs.model.Dictionary','layout57','OGBUNABALI WEST LAYOUT',NULL,'layout',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(883,'com.landsystems.lrs.model.Dictionary','layout58','OIL FIELD(OPL)',NULL,'layout',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(884,'com.landsystems.lrs.model.Dictionary','layout59','OKRIKA TOWN',NULL,'layout',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(885,'com.landsystems.lrs.model.Dictionary','layout60','OLD GRA LAYOUT',NULL,'layout',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(886,'com.landsystems.lrs.model.Dictionary','layout61','OMAGWA GRA',NULL,'layout',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(887,'com.landsystems.lrs.model.Dictionary','layout62','OROGBUM LAYOUT',NULL,'layout',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(888,'com.landsystems.lrs.model.Dictionary','layout63','OROGBUM/OROIJE VILLAGE',NULL,'layout',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(889,'com.landsystems.lrs.model.Dictionary','layout64','OROIJE LAYOUT',NULL,'layout',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(890,'com.landsystems.lrs.model.Dictionary','layout65','OROMEREZIMGBU DIOBU',NULL,'layout',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(891,'com.landsystems.lrs.model.Dictionary','layout66','OROMINEKE  VILLAGE',NULL,'layout',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(892,'com.landsystems.lrs.model.Dictionary','layout67','OROMINEKE LAYOUT',NULL,'layout',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(893,'com.landsystems.lrs.model.Dictionary','layout68','OROWORUKWO DIOBU',NULL,'layout',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(894,'com.landsystems.lrs.model.Dictionary','layout69','OYIGBO LAYOUT',NULL,'layout',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(895,'com.landsystems.lrs.model.Dictionary','layout70','OZUOBA GRA PHASE 5 LAYOUT',NULL,'layout',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(896,'com.landsystems.lrs.model.Dictionary','layout71','PHALGA',NULL,'layout',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(897,'com.landsystems.lrs.model.Dictionary','layout72','PRESIDENTIAL HOUSING ESTATE',NULL,'layout',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(898,'com.landsystems.lrs.model.Dictionary','layout73','RECLAIMED DIOBU CREEK LAYOUT',NULL,'layout',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(899,'com.landsystems.lrs.model.Dictionary','layout74','RECLAMATION 1',NULL,'layout',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(900,'com.landsystems.lrs.model.Dictionary','layout75','RECLAMATION 2',NULL,'layout',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(901,'com.landsystems.lrs.model.Dictionary','layout76','RECREATION LAYOUT',NULL,'layout',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(902,'com.landsystems.lrs.model.Dictionary','layout77','RUMUIBEKWE  HOUSING  ESTATE',NULL,'layout',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(903,'com.landsystems.lrs.model.Dictionary','layout78','RUMUKALAGBOR VILLAGE',NULL,'layout',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(904,'com.landsystems.lrs.model.Dictionary','layout79','RUMUOBIAKANI  HOUSING ESTATE',NULL,'layout',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(905,'com.landsystems.lrs.model.Dictionary','layout80','RUMUOGBA  RESIDENTIAL  LAYOUT',NULL,'layout',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(906,'com.landsystems.lrs.model.Dictionary','layout81','RUMUOLA LAYOUT',NULL,'layout',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(907,'com.landsystems.lrs.model.Dictionary','layout82','SATELITE  LAYOUT',NULL,'layout',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(908,'com.landsystems.lrs.model.Dictionary','layout83','STATION FACTORY ROAD LAYOUT',NULL,'layout',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(909,'com.landsystems.lrs.model.Dictionary','layout84','TOWNSHIP LAYOUT(NATIVE)CREEK ROAD EXTENSION',NULL,'layout',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(910,'com.landsystems.lrs.model.Dictionary','layout85','TOWNSHIP NATIVE LAYOUT',NULL,'layout',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(911,'com.landsystems.lrs.model.Dictionary','layout86','TRANS AMADI GRA  LAYOUT',NULL,'layout',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(912,'com.landsystems.lrs.model.Dictionary','layout87','TRANS AMADI INDUSTRIAL LAYOUT PHASE 1',NULL,'layout',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(913,'com.landsystems.lrs.model.Dictionary','layout88','TRANS AMADI INDUSTRIAL LAYOUT PHASE 2',NULL,'layout',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(914,'com.landsystems.lrs.model.Dictionary','layout89','WOBO LAYOUT',NULL,'layout',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(915,'com.landsystems.lrs.model.Dictionary','jos','Jos - Bukuru Metropolis',NULL,'location',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(916,'com.landsystems.lrs.model.Dictionary','outsidejos','Outside Jos - Bukuru Metropolis',NULL,'location',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(917,'com.landsystems.lrs.model.Dictionary','lgc','LGC Headquarters',NULL,'location',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(918,'com.landsystems.lrs.model.Dictionary','rural','Rural Areas',NULL,'location',1,0,0,1,'2014-11-25 03:46:48',NULL,NULL,NULL,NULL),(919,'com.landsystems.lrs.model.Dictionary','sd_certified_document','Certified Document',NULL,'document_type',1,0,0,1,'2014-11-25 03:46:49',NULL,NULL,NULL,NULL),(920,'com.landsystems.lrs.model.Dictionary','feetype_CETC_C_CETC','Certified True Copies Fee',NULL,'fee_type',1,0,0,1,'2014-11-25 03:46:49',NULL,NULL,NULL,NULL),(921,'com.landsystems.lrs.model.Dictionary','feetype_SEAR_C_SEAR','Search Fee',NULL,'fee_type',1,0,0,1,'2014-11-25 03:46:49',NULL,NULL,NULL,NULL),(922,'com.landsystems.lrs.model.Dictionary','feetype_apff_C_APFF','Application Form Fee',NULL,'fee_type',1,0,0,1,'2014-11-25 03:46:49',NULL,NULL,NULL,NULL),(923,'com.landsystems.lrs.model.Dictionary','feetype_PFROFO_C_PFROFO','Processing Fee',NULL,'fee_type',1,0,0,1,'2014-11-25 03:46:49',NULL,NULL,NULL,NULL),(924,'com.landsystems.lrs.model.Dictionary','feetype_LAF_C_LAF','Layout Approval Fee',NULL,'fee_type',1,0,0,1,'2014-11-25 03:46:49',NULL,NULL,NULL,NULL),(925,'com.landsystems.lrs.model.Dictionary','feetype_BPAF_C_BPAF','Building Plan Approval Fee',NULL,'fee_type',1,0,0,1,'2014-11-25 03:46:49',NULL,NULL,NULL,NULL),(926,'com.landsystems.lrs.model.Dictionary','feetype_IPL_C_IPL','Infrastructure Provision Levy',NULL,'fee_type',1,0,0,1,'2014-11-25 03:46:49',NULL,NULL,NULL,NULL),(927,'com.landsystems.lrs.model.Dictionary','feetype_CF_C_CF','Contravention Fee',NULL,'fee_type',1,0,0,1,'2014-11-25 03:46:49',NULL,NULL,NULL,NULL),(928,'com.landsystems.lrs.model.Dictionary','feetype_ALF_C_ALF','Allocation Fee',NULL,'fee_type',1,0,0,1,'2014-11-25 03:46:49',NULL,NULL,NULL,NULL),(929,'com.landsystems.lrs.model.Dictionary','feetype_RF_C_RF','Registration Fee',NULL,'fee_type',1,0,0,1,'2014-11-25 03:46:49',NULL,NULL,NULL,NULL),(930,'com.landsystems.lrs.model.Dictionary','ause_pubins_18','Nursery',NULL,'use_specific',1,0,0,1,'2014-11-25 03:46:49',NULL,NULL,NULL,NULL),(931,'com.landsystems.lrs.model.Dictionary','ause_pubins_19','Primary School',NULL,'use_specific',1,0,0,1,'2014-11-25 03:46:49',NULL,NULL,NULL,NULL),(932,'com.landsystems.lrs.model.Dictionary','ause_pubins_20','Secondary School',NULL,'use_specific',1,0,0,1,'2014-11-25 03:46:49',NULL,NULL,NULL,NULL),(933,'com.landsystems.lrs.model.Dictionary','ause_pubins_21','Tertiary Institution',NULL,'use_specific',1,0,0,1,'2014-11-25 03:46:49',NULL,NULL,NULL,NULL),(934,'com.landsystems.lrs.model.Dictionary','sd_search_report','Search Letter',NULL,'document_type',1,0,0,1,'2014-11-25 03:46:49',NULL,NULL,NULL,NULL),(935,'com.landsystems.lrs.model.Dictionary','feetype_groundrentpublicland_C_GRPL','Ground Rent',NULL,'fee_type',1,0,0,1,'2014-11-25 03:46:49',NULL,NULL,NULL,NULL),(936,'com.landsystems.lrs.model.Dictionary','feetype_CPCF_C_CPCF','Change of Purpose Clause Fee',NULL,'fee_type',1,0,0,1,'2014-11-25 03:46:49',NULL,NULL,NULL,NULL),(937,'com.landsystems.lrs.model.Dictionary','feetype_CSF_C_CSF','Consent Fee',NULL,'fee_type',1,0,0,1,'2014-11-25 03:46:49',NULL,NULL,NULL,NULL),(938,'com.landsystems.lrs.model.Dictionary','feetype_LCOO_C_LCOO','Lost of C of O',NULL,'fee_type',1,0,0,1,'2014-11-25 03:46:49',NULL,NULL,NULL,NULL),(939,'com.landsystems.lrs.model.Dictionary','feetype_PSF_C_PSF','Part Surrender Fee',NULL,'fee_type',1,0,0,1,'2014-11-25 03:46:49',NULL,NULL,NULL,NULL),(940,'com.landsystems.lrs.model.Dictionary','feetype_ROOF_C_ROOF','R of O Fee',NULL,'fee_type',1,0,0,1,'2014-11-25 03:46:49',NULL,NULL,NULL,NULL),(941,'com.landsystems.lrs.model.Dictionary','feetype_SIF_C_SIF','Site Inspection Fee',NULL,'fee_type',1,0,0,1,'2014-11-25 03:46:49',NULL,NULL,NULL,NULL),(942,'com.landsystems.lrs.model.Dictionary','ause_commer_14','Cottage Industry',NULL,'use_specific',1,0,0,1,'2014-11-25 03:46:49',NULL,NULL,NULL,NULL),(943,'com.landsystems.lrs.model.Dictionary','ause_commer_15','Tinsheds Bakery',NULL,'use_specific',1,0,0,1,'2014-11-25 03:46:49',NULL,NULL,NULL,NULL),(944,'com.landsystems.lrs.model.Dictionary','ause_commer_16','Supermarket',NULL,'use_specific',1,0,0,1,'2014-11-25 03:46:49',NULL,NULL,NULL,NULL),(945,'com.landsystems.lrs.model.Dictionary','ause_commer_17','Block Industries',NULL,'use_specific',1,0,0,1,'2014-11-25 03:46:49',NULL,NULL,NULL,NULL),(946,'com.landsystems.lrs.model.Dictionary','ause_voluntary_2','Religious Body',NULL,'use_specific',1,0,0,1,'2014-11-25 03:46:49',NULL,NULL,NULL,NULL),(947,'com.landsystems.lrs.model.Dictionary','create','Create',NULL,'operation_type',0,0,0,1,'2014-11-25 03:46:49',NULL,NULL,NULL,NULL),(948,'com.landsystems.lrs.model.Dictionary','modify','Modify',NULL,'operation_type',0,0,0,1,'2014-11-25 03:46:49',NULL,NULL,NULL,NULL),(949,'com.landsystems.lrs.model.Dictionary','discharge','Discharge',NULL,'operation_type',0,0,0,1,'2014-11-25 03:46:49',NULL,NULL,NULL,NULL),(950,'com.landsystems.lrs.model.Dictionary','no_retrieve','not retrieve',NULL,'party_retrieve_type',1,0,0,1,'2014-11-25 03:46:49',NULL,NULL,NULL,NULL),(951,'com.landsystems.lrs.model.Dictionary','retrieve_source','retrieving from source party of related RRR',NULL,'party_retrieve_type',1,1,0,1,'2014-11-25 03:46:49',NULL,NULL,NULL,NULL),(952,'com.landsystems.lrs.model.Dictionary','retrieve_target','retrieving from target party of related RRR',NULL,'party_retrieve_type',1,2,0,1,'2014-11-25 03:46:49',NULL,NULL,NULL,NULL),(953,'com.landsystems.lrs.model.Dictionary','sd_cert_copy','Certified Copy of Requested Document',NULL,'outdoc_type',1,0,0,1,'2014-11-25 03:46:49',NULL,NULL,NULL,NULL),(954,'com.landsystems.lrs.model.Dictionary','abuja_1','Abaji',NULL,'region_lga',1,0,0,1,'2014-12-05 02:36:55',NULL,NULL,NULL,NULL),(955,'com.landsystems.lrs.model.Dictionary','abuja_2','Bwari',NULL,'region_lga',1,0,0,1,'2014-12-05 02:36:55',NULL,NULL,NULL,NULL),(956,'com.landsystems.lrs.model.Dictionary','abuja_3','Gwagwalada',NULL,'region_lga',1,0,0,1,'2014-12-05 02:36:55',NULL,NULL,NULL,NULL),(957,'com.landsystems.lrs.model.Dictionary','abuja_4','Kuje',NULL,'region_lga',1,0,0,1,'2014-12-05 02:36:55',NULL,NULL,NULL,NULL),(958,'com.landsystems.lrs.model.Dictionary','abuja_5','Kwali',NULL,'region_lga',1,0,0,1,'2014-12-05 02:36:55',NULL,NULL,NULL,NULL),(959,'com.landsystems.lrs.model.Dictionary','abuja_6','Municipal Area Council',NULL,'region_lga',1,0,0,1,'2014-12-05 02:36:55',NULL,NULL,NULL,NULL),(960,'com.landsystems.lrs.model.Dictionary','anambra_1','Aguata',NULL,'region_lga',1,0,0,1,'2014-12-05 02:36:55',NULL,NULL,NULL,NULL),(961,'com.landsystems.lrs.model.Dictionary','anambra_2','Awka North',NULL,'region_lga',1,0,0,1,'2014-12-05 02:36:55',NULL,NULL,NULL,NULL),(962,'com.landsystems.lrs.model.Dictionary','anambra_3','Awka South',NULL,'region_lga',1,0,0,1,'2014-12-05 02:36:55',NULL,NULL,NULL,NULL),(963,'com.landsystems.lrs.model.Dictionary','anambra_4','Anambra East',NULL,'region_lga',1,0,0,1,'2014-12-05 02:36:55',NULL,NULL,NULL,NULL),(964,'com.landsystems.lrs.model.Dictionary','anambra_5','Anambra West',NULL,'region_lga',1,0,0,1,'2014-12-05 02:36:55',NULL,NULL,NULL,NULL),(965,'com.landsystems.lrs.model.Dictionary','anambra_6','Anaocha',NULL,'region_lga',1,0,0,1,'2014-12-05 02:36:55',NULL,NULL,NULL,NULL),(966,'com.landsystems.lrs.model.Dictionary','anambra_7','Ayamelum',NULL,'region_lga',1,0,0,1,'2014-12-05 02:36:55',NULL,NULL,NULL,NULL),(967,'com.landsystems.lrs.model.Dictionary','anambra_8','Dunukofia',NULL,'region_lga',1,0,0,1,'2014-12-05 02:36:55',NULL,NULL,NULL,NULL),(968,'com.landsystems.lrs.model.Dictionary','anambra_9','Ekwusigo',NULL,'region_lga',1,0,0,1,'2014-12-05 02:36:55',NULL,NULL,NULL,NULL),(969,'com.landsystems.lrs.model.Dictionary','anambra_10','Idemili North',NULL,'region_lga',1,0,0,1,'2014-12-05 02:36:55',NULL,NULL,NULL,NULL),(970,'com.landsystems.lrs.model.Dictionary','anambra_11','Idemili South',NULL,'region_lga',1,0,0,1,'2014-12-05 02:36:55',NULL,NULL,NULL,NULL),(971,'com.landsystems.lrs.model.Dictionary','anambra_12','Ihiala',NULL,'region_lga',1,0,0,1,'2014-12-05 02:36:55',NULL,NULL,NULL,NULL),(972,'com.landsystems.lrs.model.Dictionary','anambra_13','Njikoka',NULL,'region_lga',1,0,0,1,'2014-12-05 02:36:55',NULL,NULL,NULL,NULL),(973,'com.landsystems.lrs.model.Dictionary','anambra_14','Nnewi North',NULL,'region_lga',1,0,0,1,'2014-12-05 02:36:55',NULL,NULL,NULL,NULL),(974,'com.landsystems.lrs.model.Dictionary','anambra_15','Nnewi South',NULL,'region_lga',1,0,0,1,'2014-12-05 02:36:55',NULL,NULL,NULL,NULL),(975,'com.landsystems.lrs.model.Dictionary','anambra_16','Ogbaru',NULL,'region_lga',1,0,0,1,'2014-12-05 02:36:55',NULL,NULL,NULL,NULL),(976,'com.landsystems.lrs.model.Dictionary','anambra_17','Onitsha North',NULL,'region_lga',1,0,0,1,'2014-12-05 02:36:55',NULL,NULL,NULL,NULL),(977,'com.landsystems.lrs.model.Dictionary','anambra_18','Onitsha South',NULL,'region_lga',1,0,0,1,'2014-12-05 02:36:55',NULL,NULL,NULL,NULL),(978,'com.landsystems.lrs.model.Dictionary','anambra_19','Orumba North',NULL,'region_lga',1,0,0,1,'2014-12-05 02:36:55',NULL,NULL,NULL,NULL),(979,'com.landsystems.lrs.model.Dictionary','anambra_20','Orumba South',NULL,'region_lga',1,0,0,1,'2014-12-05 02:36:55',NULL,NULL,NULL,NULL),(980,'com.landsystems.lrs.model.Dictionary','anambra_21','Oyi',NULL,'region_lga',1,0,0,1,'2014-12-05 02:36:55',NULL,NULL,NULL,NULL),(981,'com.landsystems.lrs.model.Dictionary','enugu_1','Aninri',NULL,'region_lga',1,0,0,1,'2014-12-05 02:36:55',NULL,NULL,NULL,NULL),(982,'com.landsystems.lrs.model.Dictionary','enugu_2','Awgu',NULL,'region_lga',1,0,0,1,'2014-12-05 02:36:55',NULL,NULL,NULL,NULL),(983,'com.landsystems.lrs.model.Dictionary','enugu_3','Enugu East',NULL,'region_lga',1,0,0,1,'2014-12-05 02:36:55',NULL,NULL,NULL,NULL),(984,'com.landsystems.lrs.model.Dictionary','enugu_4','Enugu North',NULL,'region_lga',1,0,0,1,'2014-12-05 02:36:55',NULL,NULL,NULL,NULL),(985,'com.landsystems.lrs.model.Dictionary','enugu_5','Enugu South',NULL,'region_lga',1,0,0,1,'2014-12-05 02:36:55',NULL,NULL,NULL,NULL),(986,'com.landsystems.lrs.model.Dictionary','enugu_6','Ezeagu',NULL,'region_lga',1,0,0,1,'2014-12-05 02:36:55',NULL,NULL,NULL,NULL),(987,'com.landsystems.lrs.model.Dictionary','enugu_7','Igbo Etiti',NULL,'region_lga',1,0,0,1,'2014-12-05 02:36:55',NULL,NULL,NULL,NULL),(988,'com.landsystems.lrs.model.Dictionary','enugu_8','Igbo Eze North',NULL,'region_lga',1,0,0,1,'2014-12-05 02:36:55',NULL,NULL,NULL,NULL),(989,'com.landsystems.lrs.model.Dictionary','enugu_9','Igbo Eze South',NULL,'region_lga',1,0,0,1,'2014-12-05 02:36:55',NULL,NULL,NULL,NULL),(990,'com.landsystems.lrs.model.Dictionary','enugu_10','Isi Uzo',NULL,'region_lga',1,0,0,1,'2014-12-05 02:36:55',NULL,NULL,NULL,NULL),(991,'com.landsystems.lrs.model.Dictionary','enugu_11','Nkanu East',NULL,'region_lga',1,0,0,1,'2014-12-05 02:36:55',NULL,NULL,NULL,NULL),(992,'com.landsystems.lrs.model.Dictionary','enugu_12','Nkanu West',NULL,'region_lga',1,0,0,1,'2014-12-05 02:36:55',NULL,NULL,NULL,NULL),(993,'com.landsystems.lrs.model.Dictionary','enugu_13','Nsukka',NULL,'region_lga',1,0,0,1,'2014-12-05 02:36:55',NULL,NULL,NULL,NULL),(994,'com.landsystems.lrs.model.Dictionary','enugu_14','Oji River',NULL,'region_lga',1,0,0,1,'2014-12-05 02:36:55',NULL,NULL,NULL,NULL),(995,'com.landsystems.lrs.model.Dictionary','enugu_15','Udenu',NULL,'region_lga',1,0,0,1,'2014-12-05 02:36:55',NULL,NULL,NULL,NULL),(996,'com.landsystems.lrs.model.Dictionary','enugu_16','Udi',NULL,'region_lga',1,0,0,1,'2014-12-05 02:36:55',NULL,NULL,NULL,NULL),(997,'com.landsystems.lrs.model.Dictionary','enugu_17','Uzo Uwani',NULL,'region_lga',1,0,0,1,'2014-12-05 02:36:55',NULL,NULL,NULL,NULL),(998,'com.landsystems.lrs.model.Dictionary','akwaibom_1','Abak',NULL,'region_lga',1,0,0,1,'2014-12-05 02:36:55',NULL,NULL,NULL,NULL),(999,'com.landsystems.lrs.model.Dictionary','akwaibom_2','Eastern Obolo',NULL,'region_lga',1,0,0,1,'2014-12-05 02:36:55',NULL,NULL,NULL,NULL),(1000,'com.landsystems.lrs.model.Dictionary','akwaibom_3','Eket',NULL,'region_lga',1,0,0,1,'2014-12-05 02:36:55',NULL,NULL,NULL,NULL),(1001,'com.landsystems.lrs.model.Dictionary','akwaibom_4','Esit-Eket',NULL,'region_lga',1,0,0,1,'2014-12-05 02:36:55',NULL,NULL,NULL,NULL),(1002,'com.landsystems.lrs.model.Dictionary','akwaibom_5','Essien Udim',NULL,'region_lga',1,0,0,1,'2014-12-05 02:36:55',NULL,NULL,NULL,NULL),(1003,'com.landsystems.lrs.model.Dictionary','akwaibom_6','Etim-Ekpo',NULL,'region_lga',1,0,0,1,'2014-12-05 02:36:55',NULL,NULL,NULL,NULL),(1004,'com.landsystems.lrs.model.Dictionary','akwaibom_7','Etinan',NULL,'region_lga',1,0,0,1,'2014-12-05 02:36:55',NULL,NULL,NULL,NULL),(1005,'com.landsystems.lrs.model.Dictionary','akwaibom_8','Ibeno',NULL,'region_lga',1,0,0,1,'2014-12-05 02:36:55',NULL,NULL,NULL,NULL),(1006,'com.landsystems.lrs.model.Dictionary','akwaibom_9','Ibesikpo-Asutan',NULL,'region_lga',1,0,0,1,'2014-12-05 02:36:55',NULL,NULL,NULL,NULL),(1007,'com.landsystems.lrs.model.Dictionary','akwaibom_10','Ibiono-Ibom',NULL,'region_lga',1,0,0,1,'2014-12-05 02:36:55',NULL,NULL,NULL,NULL),(1008,'com.landsystems.lrs.model.Dictionary','akwaibom_11','Ika-Annang',NULL,'region_lga',1,0,0,1,'2014-12-05 02:36:55',NULL,NULL,NULL,NULL),(1009,'com.landsystems.lrs.model.Dictionary','akwaibom_12','Ikono',NULL,'region_lga',1,0,0,1,'2014-12-05 02:36:55',NULL,NULL,NULL,NULL),(1010,'com.landsystems.lrs.model.Dictionary','akwaibom_13','Ikot Abasi',NULL,'region_lga',1,0,0,1,'2014-12-05 02:36:55',NULL,NULL,NULL,NULL),(1011,'com.landsystems.lrs.model.Dictionary','akwaibom_14','Ikot Ekpene',NULL,'region_lga',1,0,0,1,'2014-12-05 02:36:55',NULL,NULL,NULL,NULL),(1012,'com.landsystems.lrs.model.Dictionary','akwaibom_15','Ini',NULL,'region_lga',1,0,0,1,'2014-12-05 02:36:55',NULL,NULL,NULL,NULL),(1013,'com.landsystems.lrs.model.Dictionary','akwaibom_16','Itu',NULL,'region_lga',1,0,0,1,'2014-12-05 02:36:55',NULL,NULL,NULL,NULL),(1014,'com.landsystems.lrs.model.Dictionary','akwaibom_17','Mbo',NULL,'region_lga',1,0,0,1,'2014-12-05 02:36:55',NULL,NULL,NULL,NULL),(1015,'com.landsystems.lrs.model.Dictionary','akwaibom_18','Mkpat-Enin',NULL,'region_lga',1,0,0,1,'2014-12-05 02:36:55',NULL,NULL,NULL,NULL),(1016,'com.landsystems.lrs.model.Dictionary','akwaibom_19','Nsit-Atai',NULL,'region_lga',1,0,0,1,'2014-12-05 02:36:55',NULL,NULL,NULL,NULL),(1017,'com.landsystems.lrs.model.Dictionary','akwaibom_20','Nsit-Ibom',NULL,'region_lga',1,0,0,1,'2014-12-05 02:36:55',NULL,NULL,NULL,NULL),(1018,'com.landsystems.lrs.model.Dictionary','akwaibom_21','Nsit-Ubium',NULL,'region_lga',1,0,0,1,'2014-12-05 02:36:55',NULL,NULL,NULL,NULL);

--
