X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=blobdiff_plain;f=FS%2FFS%2FSchema.pm;fp=FS%2FFS%2FSchema.pm;h=d88403644cc5b3a9ae14d1db0bb7738a2691300b;hp=4ebda4e11950fc296ebd1fb45545e787eb4ae85c;hb=8e1e9bfc08df3ffe96515019d26ced7f89f34ff1;hpb=3eac3c31f8d8a90fb896f9e95ee9276a4ae0280e

diff --git a/FS/FS/Schema.pm b/FS/FS/Schema.pm
index 4ebda4e11..d88403644 100644
--- a/FS/FS/Schema.pm
+++ b/FS/FS/Schema.pm
@@ -5736,6 +5736,9 @@ sub tables_hashref {
         # FK to cust_bill_pkg_detail; having a value here absolutely means
         # that the CDR appears on an invoice
         'detailnum',     'bigint',    'NULL',      '', '', '',
+
+        #for mediation/deduplication
+        'sipcallid',    'varchar',    'NULL',     255, '', '',
       ],
       'primary_key' => 'acctid',
       'unique' => [],
@@ -5749,7 +5752,7 @@ sub tables_hashref {
                    [ 'freesidestatus' ], [ 'freesiderewritestatus' ],
                    [ 'cdrbatchnum' ],
                    [ 'src_ip_addr' ], [ 'dst_ip_addr' ], [ 'dst_term' ],
-                   [ 'detailnum' ],
+                   [ 'detailnum' ], [ 'sipcallid' ],
                  ],
       #no FKs on cdr table... choosing not to throw errors no matter what's
       # thrown in here.  better to have the data.