projects
/
freeside.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
UI to disable message templates, #26035
[freeside.git]
/
FS
/
FS
/
Schema.pm
diff --git
a/FS/FS/Schema.pm
b/FS/FS/Schema.pm
index
ae9cb41
..
bc9d37a
100644
(file)
--- a/
FS/FS/Schema.pm
+++ b/
FS/FS/Schema.pm
@@
-3,7
+3,7
@@
package FS::Schema;
use vars qw(@ISA @EXPORT_OK $DEBUG $setup_hack %dbdef_cache);
use subs qw(reload_dbdef);
use Exporter;
use vars qw(@ISA @EXPORT_OK $DEBUG $setup_hack %dbdef_cache);
use subs qw(reload_dbdef);
use Exporter;
-use DBIx::DBSchema 0.4
3; #0.43 for foreign keys
+use DBIx::DBSchema 0.4
4; #for foreign keys with MATCH / ON DELETE/UPDATE
use DBIx::DBSchema::Table;
use DBIx::DBSchema::Column;
use DBIx::DBSchema::Index;
use DBIx::DBSchema::Table;
use DBIx::DBSchema::Column;
use DBIx::DBSchema::Index;
@@
-1138,9
+1138,10
@@
sub tables_hashref {
{ columns => [ 'invnum' ],
table => 'cust_bill_void',
},
{ columns => [ 'invnum' ],
table => 'cust_bill_void',
},
- { columns => [ 'pkgnum' ],
- table => 'cust_pkg',
- },
+ #pkgnum 0 and -1 are used for special things
+ #{ columns => [ 'pkgnum' ],
+ # table => 'cust_pkg',
+ #},
{ columns => [ 'pkgpart_override' ],
table => 'part_pkg',
references => [ 'pkgpart' ],
{ columns => [ 'pkgpart_override' ],
table => 'part_pkg',
references => [ 'pkgpart' ],
@@
-2389,7
+2390,7
@@
sub tables_hashref {
'index' => [ [ 'billpaynum' ], [ 'billpkgnum' ], ],
'foreign_keys' => [
{ columns => [ 'billpaynum' ],
'index' => [ [ 'billpaynum' ], [ 'billpkgnum' ], ],
'foreign_keys' => [
{ columns => [ 'billpaynum' ],
- table => 'cust_bill_pay
_batch
',
+ table => 'cust_bill_pay',
},
{ columns => [ 'billpkgnum' ],
table => 'cust_bill_pkg',
},
{ columns => [ 'billpkgnum' ],
table => 'cust_bill_pkg',
@@
-3953,6
+3954,7
@@
sub tables_hashref {
'foreign_keys' => [
{ columns => [ 'jobnum' ],
table => 'queue',
'foreign_keys' => [
{ columns => [ 'jobnum' ],
table => 'queue',
+ on_delete => 'CASCADE',
},
],
},
},
],
},
@@
-3973,6
+3975,7
@@
sub tables_hashref {
{ columns => [ 'depend_jobnum' ],
table => 'queue',
references => [ 'jobnum' ],
{ columns => [ 'depend_jobnum' ],
table => 'queue',
references => [ 'jobnum' ],
+ on_delete => 'CASCADE',
},
],
},
},
],
},
@@
-5843,7
+5846,7
@@
sub tables_hashref {
'statustext', 'varchar', 'NULL', $char_d, '', '',
],
'primary_key' => 'upgradenum',
'statustext', 'varchar', 'NULL', $char_d, '', '',
],
'primary_key' => 'upgradenum',
- 'unique' => [
[ 'upgradenum' ]
],
+ 'unique' => [],
'index' => [ [ 'upgrade' ] ],
},
'index' => [ [ 'upgrade' ] ],
},