diff options
| author | Mark Wells <mark@freeside.biz> | 2014-07-08 17:06:52 -0700 |
|---|---|---|
| committer | Mark Wells <mark@freeside.biz> | 2014-07-08 17:06:52 -0700 |
| commit | b8e4ca0d3999d51c6970bd084d889abebcaae2cf (patch) | |
| tree | b619157e8cd9f425e034cf1893e41d310beaff5e /FS | |
| parent | 94759bfdd5d12dd02c4fd850667d936b77cd7d81 (diff) | |
avoid foreign key errors when reconciling NENA2 batches, #14049
Diffstat (limited to 'FS')
| -rw-r--r-- | FS/FS/Schema.pm | 6 | ||||
| -rw-r--r-- | FS/FS/export_batch_item.pm | 1 | ||||
| -rw-r--r-- | FS/FS/part_export/nena2.pm | 1 |
3 files changed, 1 insertions, 7 deletions
diff --git a/FS/FS/Schema.pm b/FS/FS/Schema.pm index 1b76a23e9..1c9c4a200 100644 --- a/FS/FS/Schema.pm +++ b/FS/FS/Schema.pm @@ -6610,7 +6610,7 @@ sub tables_hashref { 'exportnum', 'int', '', '', '', '', '_date', 'int', '', '', '', '', 'status', 'varchar', 'NULL', 32, '', '', - 'statustext', 'varchar', 'NULL', $char_d, '', '', + 'statustext', 'text', 'NULL', '', '', '', ], 'primary_key' => 'batchnum', 'unique' => [], @@ -6640,10 +6640,6 @@ sub tables_hashref { table => 'export_batch', references => [ 'batchnum' ] }, - { columns => [ 'svcnum' ], - table => 'cust_svc', - references => [ 'svcnum' ] - }, ], }, diff --git a/FS/FS/export_batch_item.pm b/FS/FS/export_batch_item.pm index accb3f1e2..e442748b5 100644 --- a/FS/FS/export_batch_item.pm +++ b/FS/FS/export_batch_item.pm @@ -104,7 +104,6 @@ sub check { || $self->ut_number('batchnum') || $self->ut_foreign_key('batchnum', 'export_batch', 'batchnum') || $self->ut_number('svcnum') - || $self->ut_foreign_key('svcnum', 'cust_svc', 'svcnum') || $self->ut_enum('action', [ qw(insert delete replace suspend unsuspend relocate) ] ) diff --git a/FS/FS/part_export/nena2.pm b/FS/FS/part_export/nena2.pm index 71d753aa1..ad67ba2a0 100644 --- a/FS/FS/part_export/nena2.pm +++ b/FS/FS/part_export/nena2.pm @@ -355,7 +355,6 @@ sub process { # ignore items that have no data to add to the batch next if $item->action eq 'suspend' or $item->action eq 'unsuspend'; - my $svcnum = $item->svcnum; my $data = $item->data; %hash = %{ $item_format->parse($data) }; my $phonenum = $hash{npa} . $hash{calling_number}; |