Change Rejected Net Usage

database/functions/dw/000-sa.sql

@@ -104,6 +104,7 @@ BEGIN
en.id as id_ent_net,
n.ip,
CAST(n.macaddr as MACADDR),
+                n.city_code,
n.collect_date,
n.collect_time,
n.down_kbits,
@@ -349,10 +350,10 @@ BEGIN
-- log the invalid information into rejected table
INSERT INTO rejected_net_usage
-        (contact_date, id_point, id_city, id_ent_net, macaddr, ip, collect_date, collect_time,
+        (contact_date, id_point, id_city, city_code, id_ent_net, macaddr, ip, collect_date, collect_time,
down_kbits, down_packages, up_kbits, up_packages)
(SELECT
-        contact_date, id_point, id_city, id_ent_net, macaddr, ip, collect_date, collect_time,
+        contact_date, id_point, id_city, city_code, id_ent_net, macaddr, ip, collect_date, collect_time,
down_kbits, down_packages, up_kbits, up_packages
FROM
sa_net_usage