Details
Major Description
copy of Alok's Email
Hi Ramesh/Guru,
I have noticed that the structure of below 2 Bing tables in lasham DB are not in sync with what we have in fairford and Detroit Db.
QA Team: Please raise a bug on the same.
Use content_editor_bing;
bce_campaignProximityTargetMap
bce_campaignProximityTargetMapPendingUpdate
Instead of having lat and long column as varchar type, lasham has it as decimal type. Also verified bitbucket, but the script is also not updated with varchar type instead has decimal column type.
Details:
Lasham:
mysql> desc bce_campaignProximityTargetMap;
----------------------------------------------------------------+
| Field | Type | Null | Key | Default | Extra |
----------------------------------------------------------------+
| campaignID | int(11) | NO | PRI | NULL | |
| targetID | int(11) | NO | PRI | NULL | |
| latitudeInDegrees | decimal(20,15) | NO | 0.000000000000000 | ||
| longitudeInDegrees | decimal(20,16) | NO | 0.0000000000000000 | ||
| radius | int(3) | NO | NULL | ||
| radiusUnits | enum('miles') | YES | NULL |
----------------------------------------------------------------+
6 rows in set (0.01 sec)
mysql> desc bce_campaignProximityTargetMapPendingUpdate;
-------------------------------------------------------------------------------+
| Field | Type | Null | Key | Default | Extra |
-------------------------------------------------------------------------------+
| campaignID | int(11) | NO | PRI | NULL | |
| targetID | int(11) | NO | PRI | NULL | |
| latitudeInDegrees | decimal(20,15) | NO | 0.000000000000000 | ||
| longitudeInDegrees | decimal(20,16) | NO | 0.0000000000000000 | ||
| radius | int(3) | NO | NULL | ||
| radiusUnits | enum('miles') | YES | NULL | ||
| updateType | enum('add','delete','update') | NO | NULL |
-------------------------------------------------------------------------------+
7 rows in set (0.00 sec)
Detroit:
mysql> desc bce_campaignProximityTargetMap;
----------------------------------------------------+
| Field | Type | Null | Key | Default | Extra |
----------------------------------------------------+
| campaignID | int(11) | NO | PRI | NULL | |
| targetID | int(11) | NO | PRI | NULL | |
| latitudeInDegrees | varchar(50) | NO | NULL | ||
| longitudeInDegrees | varchar(50) | NO | NULL | ||
| radius | int(3) | NO | NULL | ||
| radiusUnits | enum('miles') | YES | NULL |
----------------------------------------------------+
6 rows in set (0.00 sec)
mysql> desc bce_campaignProximityTargetMapPendingUpdate;
--------------------------------------------------------------------+
| Field | Type | Null | Key | Default | Extra |
--------------------------------------------------------------------+
| campaignID | int(11) | NO | PRI | NULL | |
| targetID | int(11) | NO | PRI | NULL | |
| latitudeInDegrees | varchar(50) | NO | NULL | ||
| longitudeInDegrees | varchar(50) | NO | NULL | ||
| radius | int(3) | NO | NULL | ||
| radiusUnits | enum('miles') | YES | NULL | ||
| updateType | enum('add','delete','update') | NO | NULL |
--------------------------------------------------------------------+
7 rows in set (0.00 sec)
Fairford:
mysql> desc bce_campaignProximityTargetMap;
----------------------------------------------------+
| Field | Type | Null | Key | Default | Extra |
----------------------------------------------------+
| campaignID | int(11) | NO | PRI | NULL | |
| targetID | int(11) | NO | PRI | NULL | |
| latitudeInDegrees | varchar(50) | NO | NULL | ||
| longitudeInDegrees | varchar(50) | NO | NULL | ||
| radius | int(3) | NO | NULL | ||
| radiusUnits | enum('miles') | YES | NULL |
----------------------------------------------------+
6 rows in set (0.00 sec)
mysql> desc bce_campaignProximityTargetMapPendingUpdate
-> ;
--------------------------------------------------------------------+
| Field | Type | Null | Key | Default | Extra |
--------------------------------------------------------------------+
| campaignID | int(11) | NO | PRI | NULL | |
| targetID | int(11) | NO | PRI | NULL | |
| latitudeInDegrees | varchar(50) | NO | NULL | ||
| longitudeInDegrees | varchar(50) | NO | NULL | ||
| radius | int(3) | NO | NULL | ||
| radiusUnits | enum('miles') | YES | NULL | ||
| updateType | enum('add','delete','update') | NO | NULL |
--------------------------------------------------------------------+
7 rows in set (0.00 sec)
