diff options
author | Ivan Kohler <ivan@freeside.biz> | 2018-11-29 09:53:30 -0800 |
---|---|---|
committer | Ivan Kohler <ivan@freeside.biz> | 2018-11-29 09:53:30 -0800 |
commit | aad287228dfbe5ef01be73ebaaa9a06dfbe11226 (patch) | |
tree | 5f82bf40662e19330da7d4ec02cbc042ef72bf62 /FS/FS/Schema.pm | |
parent | 697a8343f7ef80f69c1b974515550afc6b794010 (diff) |
svc_group, RT#81628
Diffstat (limited to 'FS/FS/Schema.pm')
-rw-r--r-- | FS/FS/Schema.pm | 34 |
1 files changed, 25 insertions, 9 deletions
diff --git a/FS/FS/Schema.pm b/FS/FS/Schema.pm index 169d22a..7cc84a9 100644 --- a/FS/FS/Schema.pm +++ b/FS/FS/Schema.pm @@ -7666,11 +7666,11 @@ sub tables_hashref { ], }, - realestate_location => { + 'realestate_location' => { 'columns' => [ 'realestatelocnum', 'serial', '', '', '', '', 'agentnum', 'int', 'NULL', '', '', '', - 'location_title', 'varchar', '', $char_d, '', '', + 'location_title', 'varchar', '', $char_d, '', '', 'address1', 'varchar', 'NULL', $char_d, '', '', 'address2', 'varchar', 'NULL', $char_d, '', '', 'city', 'varchar', 'NULL', $char_d, '', '', @@ -7678,23 +7678,39 @@ sub tables_hashref { 'zip', 'char', 'NULL', 5, '', '', 'disabled', 'char', 'NULL', 1, '', '', ], - primary_key => 'realestatelocnum', - 'unique' => [ ['location_title'] ], - 'index' => [ ['agentnum'], ['disabled'] ], + 'primary_key' => 'realestatelocnum', + 'unique' => [ ['location_title'] ], + 'index' => [ ['agentnum'], ['disabled'] ], 'foreign_keys' => [ {columns => ['agentnum'], table => 'agent'}, ], }, - svc_realestate => { - columns => [ + 'svc_realestate' => { + 'columns' => [ 'svcnum', 'serial', '', '', '', '', 'realestatenum', 'int', 'NULL', '', '', '', ], - primary_key => 'svcnum', - index => [], + 'primary_key' => 'svcnum', + 'index' => [], + }, + + 'svc_group' => { + 'columns' => [ + 'svcnum', 'int', '', '', '', '', + 'max_accounts', 'int', '', '', '', '', + ], + 'primary_key' => 'svcnum', + 'unique' => [], + 'index' => [], + 'foreign_keys' => [ + { columns => [ 'svcnum' ], + table => 'cust_svc', + }, + ], }, + # name type nullability length default local #'new_table' => { |