projects
/
freeside.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
avoid foreign key errors when reconciling NENA2 batches, #14049
[freeside.git]
/
FS
/
FS
/
Schema.pm
diff --git
a/FS/FS/Schema.pm
b/FS/FS/Schema.pm
index
4ad9cec
..
71442b6
100644
(file)
--- a/
FS/FS/Schema.pm
+++ b/
FS/FS/Schema.pm
@@
-2815,7
+2815,7
@@
sub tables_hashref {
],
'primary_key' => 'prepaynum',
'unique' => [ ['identifier'] ],
],
'primary_key' => 'prepaynum',
'unique' => [ ['identifier'] ],
- 'index' => [],
+ 'index' => [
['agentnum']
],
},
'port' => {
},
'port' => {
@@
-4551,7
+4551,7
@@
sub tables_hashref {
'exportnum', 'int', '', '', '', '',
'_date', 'int', '', '', '', '',
'status', 'varchar', 'NULL', 32, '', '',
'exportnum', 'int', '', '', '', '',
'_date', 'int', '', '', '', '',
'status', 'varchar', 'NULL', 32, '', '',
- 'statustext',
'varchar', 'NULL', $char_d
, '', '',
+ 'statustext',
'text', 'NULL', ''
, '', '',
],
'primary_key' => 'batchnum',
'unique' => [],
],
'primary_key' => 'batchnum',
'unique' => [],
@@
-4569,7
+4569,7
@@
sub tables_hashref {
'itemnum', 'serial', '', '', '', '',
'batchnum', 'int', '', '', '', '',
'svcnum', 'int', '', '', '', '',
'itemnum', 'serial', '', '', '', '',
'batchnum', 'int', '', '', '', '',
'svcnum', 'int', '', '', '', '',
- 'action', 'varchar',
32, ''
, '', '',
+ 'action', 'varchar',
'', 32
, '', '',
'data', 'text', 'NULL', '', '', '',
'frozen', 'char', 'NULL', 1, '', '',
],
'data', 'text', 'NULL', '', '', '',
'frozen', 'char', 'NULL', 1, '', '',
],
@@
-4581,10
+4581,6
@@
sub tables_hashref {
table => 'export_batch',
references => [ 'batchnum' ]
},
table => 'export_batch',
references => [ 'batchnum' ]
},
- { columns => [ 'svcnum' ],
- table => 'cust_svc',
- references => [ 'svcnum' ]
- },
],
},
],
},