Subject: Database Compare Log
From: [email-masked]
To: [email-masked]
Date: Wed, 19 Oct 2016 18:36:11 +0800

[2016-10-19 18:35:36] INFO db4- dsn:mysql:host=localhost;dbname=grandtag_i;charset:utf8;
[2016-10-19 18:35:36] INFO MIGA_i- dsn:mysql:host=172.16.10.9;dbname=grandtag_i;charset:utf8;
[2016-10-19 18:35:36] INFO sale_figure_ap (db4) Versus sale_figure_ap (MIGA_i)

[2016-10-19 18:35:36] WARNING PK(ref 16) FK() "written_ytd_premium": 151314.08 | 151188.80
[2016-10-19 18:35:36] WARNING PK(ref 16) FK() "submit_ytd_premium": 163314.08 | 163188.80
[2016-10-19 18:35:36] WARNING PK(ref 232) FK() "written_ytd_premium": 72130.00 | 72190.00
[2016-10-19 18:35:36] WARNING PK(ref 232) FK() "submit_ytd_premium": 72130.00 | 72190.00
[2016-10-19 18:35:36] WARNING PK(ref 284) FK() "written_premium": 705222.66 | 705222.65
[2016-10-19 18:35:36] WARNING PK(ref 284) FK() "written_ytd_premium": 707589.16 | 707589.15
[2016-10-19 18:35:36] WARNING PK(ref 284) FK() "submit_ytd_premium": 250193.02 | 250193.01
[2016-10-19 18:35:36] WARNING PK(ref 308) FK() "written_ytd_premium": 302716.41 | 302716.40
[2016-10-19 18:35:36] WARNING PK(ref 356) FK() "written_ytd_premium": 46359.39 | 46359.40
[2016-10-19 18:35:36] WARNING PK(ref 390) FK() "written_premium": 10551.84 | 10551.85
[2016-10-19 18:35:36] WARNING PK(ref 403) FK() "written_premium": 80803.04 | 80803.05
[2016-10-19 18:35:36] WARNING PK(ref 403) FK() "pending_premium": 351603.77 | 351603.76
[2016-10-19 18:35:36] WARNING PK(ref 413) FK() "written_ytd_premium": 114076.96 | 114076.97
[2016-10-19 18:35:36] WARNING PK(ref 413) FK() "submit_ytd_premium": 59494.86 | 59494.87
[2016-10-19 18:35:36] WARNING PK(ref 413) FK() "last2_mtd": 59494.86 | 59494.87
[2016-10-19 18:35:36] WARNING PK(ref 494) FK() "written_premium": 70758.18 | 70091.14
[2016-10-19 18:35:36] WARNING PK(ref 494) FK() "written_ytd_premium": 70758.18 | 70091.14
[2016-10-19 18:35:36] WARNING PK(ref 494) FK() "submit_premium": 70758.18 | 70091.14
[2016-10-19 18:35:36] WARNING PK(ref 494) FK() "submit_ytd_premium": 70758.18 | 70091.14
[2016-10-19 18:35:36] WARNING PK(ref 901) FK() "written_ytd_premium": 17637.12 | 17637.11
[2016-10-19 18:35:36] WARNING PK(ref 901) FK() "submit_ytd_premium": 17637.12 | 17637.11
[2016-10-19 18:35:37] WARNING PK(ref 1238) FK() "written_ytd_premium": 1320730.43 | 1316812.62
[2016-10-19 18:35:37] WARNING PK(ref 1238) FK() "submit_ytd_premium": 2348643.80 | 2344351.80
[2016-10-19 18:35:37] INFO Total Data Mismatch Count: 23