summaryrefslogtreecommitdiff
path: root/FS/FS/Schema.pm
diff options
context:
space:
mode:
authorIvan Kohler <ivan@freeside.biz>2015-04-30 02:34:51 -0700
committerIvan Kohler <ivan@freeside.biz>2015-04-30 02:34:51 -0700
commit7d34aacffa38c4cac09b54080487a66c264e4668 (patch)
treee3b27abf58b2c71ff3a12eb18971140c60e6d973 /FS/FS/Schema.pm
parent58cdf1b78c0cd419eacf7db8661564af050e0f12 (diff)
service dependencies: UI, RT#33685
Diffstat (limited to 'FS/FS/Schema.pm')
-rw-r--r--FS/FS/Schema.pm25
1 files changed, 25 insertions, 0 deletions
diff --git a/FS/FS/Schema.pm b/FS/FS/Schema.pm
index 42122f7..114acb8 100644
--- a/FS/FS/Schema.pm
+++ b/FS/FS/Schema.pm
@@ -3618,6 +3618,31 @@ sub tables_hashref {
'index' => [ ['disabled'] ],
},
+ 'part_svc_link' => {
+ 'columns' => [
+ 'svclinknum', 'serial', '', '', '', '',
+ #'linkname', 'varchar', 'NULL', $char_d, '', '',
+ 'agentnum', 'int', 'NULL', '', '', '',
+ 'src_svcpart', 'int', '', '', '', '',
+ 'dst_svcpart', 'int', '', '', '', '',
+ 'link_type', 'varchar', '', $char_d, '', '',
+ 'disabled', 'char', 'NULL', 1, '', '',
+ ],
+ 'primary_key' => 'svclinknum',
+ 'unique' => [ ['agentnum','src_svcpart','dst_svcpart','link_type'] ],
+ 'index' => [ [ 'src_svcpart' ] ],
+ 'foreign_keys' => [
+ { columns => [ 'src_svcpart' ],
+ table => 'part_svc',
+ references => [ 'svcpart' ]
+ },
+ { columns => [ 'dst_svcpart' ],
+ table => 'part_svc',
+ references => [ 'svcpart' ]
+ },
+ ],
+ },
+
#(this should be renamed to part_pop)
'svc_acct_pop' => {
'columns' => [