...
Step 6 – Application testing has to happen next step in UAT.
Step 7 – Db patch missing should be updated by Dev team. below is 1 script and rest script need to check with Dev Team.
USE `db_iemr`;
CREATE
OR REPLACE VIEW `v_get_prkngplc_blok_dist_zone_state` AS
SELECT DISTINCT
`m_sp`.`ServicePointID` AS `Servicepointid`,
`m_pp`.`ParkingPlaceID` AS `ParkingPlaceID`,
`m_pp`.`ParkingPlaceName` AS `ParkingPlaceName`,
`m_db`.`BlockID` AS `BlockID`,
`m_db`.`BlockName` AS `BlockName`,
`m_d`.`DistrictID` AS `DistrictID`,
`m_d`.`DistrictName` AS `DistrictName`,
`m_zdm`.`ZoneID` AS `ZoneID`,
`m_z`.`ZoneName` AS `ZoneName`,
`m_s`.`StateID` AS `StateID`,
`m_s`.`StateName` AS `StateName`,
`m_sp`.`ProviderServiceMapID` AS `SPproviderservicemapid`,
`m_pp`.`ProviderServiceMapID` AS `PPproviderservicemapid`,
`m_zdm`.`ProviderServiceMapID` AS `ZDMproviderservicemapid`
FROM
((((((`m_servicepoint` `m_sp`
JOIN `m_parkingplace` `m_pp` ON (((`m_sp`.`ParkingPlaceID` = `m_pp`.`ParkingPlaceID`)
AND ((0 <> `m_pp`.`Deleted`) IS FALSE))))
JOIN `m_districtblock` `m_db` ON (((`m_pp`.`DistrictBlockID` = `m_db`.`BlockID`)
AND ((0 <> `m_db`.`Deleted`) IS FALSE))))
JOIN `m_district` `m_d` ON (((`m_db`.`DistrictID` = `m_d`.`DistrictID`)
AND ((0 <> `m_d`.`Deleted`) IS FALSE))))
JOIN `m_zonedistrictmap` `m_zdm` ON (((`m_d`.`DistrictID` = `m_zdm`.`DistrictID`)
AND ((0 <> `m_zdm`.`Deleted`) IS FALSE))))
JOIN `m_zone` `m_z` ON (((`m_z`.`ZoneID` = `m_zdm`.`ZoneID`)
AND ((0 <> `m_z`.`Deleted`) IS FALSE))))
JOIN `m_state` `m_s` ON (((`m_d`.`StateID` = `m_s`.`StateID`)
AND ((0 <> `m_s`.`Deleted`) IS FALSE))))
WHERE
((0 <> `m_sp`.`Deleted`) IS FALSE);
Step- 8 If we are changing path of my.ini file, Please keep same query in both place in C drive also and installed setup path in my.ini file.
sql_mode="STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION"